# 144|EXCEL – Solver **URL:** \ **Category:** Challenges\ **Tags:** solver, intro, learningpath\ **Created:** [March 7, 2024, 5:12am UTC](https://www.techhub.training/t/144-excel-solver/2232 "2024-03-07T05:12:09Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Dallin\_Gardner](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/dallin_gardner/32/5553_2.png) [@Dallin\_Gardner](https://www.techhub.training/u/Dallin_Gardner)\ **Post date:** [March 7, 2024, 5:12am UTC](https://www.techhub.training/t/144-excel-solver/2232/1 "2024-03-07T05:12:09Z")
_BYU Student Author_: @Dallin_Gardner _Reviewers_: @Carter_Lee, @Benjamin_Lau _Estimated Time to Solve:_ 10 Minutes This is an intro challenge that is part of the [Excel Learning Path](https://www.techhub.training/t/excel-learning-path/2225/1). We provide the solution to this challenge using: - Excel - [Python](https://www.techhub.training/t/144-python-solver/4826) Need a program? Click [here](https://www.techhub.training/t/information-about-software-used-on-techhub-training/138). **Overview** SmartHome Co. sells smart home systems of three levels (Base, Plus, and Full). SmartHome has an international salesforce and generates millions of sales each year. The Argentina branch of SmartHome Co. is historically profitable. However, its managers are exploring opportunities to increase profits even higher. As an analyst, you’ve been asked to find the most profitable sales mix given the range of demand for each level. **Instructions** Go to sheet “Sales Mix Analysis” to start the analysis. 1. Import the Solver Add-in. Use the search bar to search for “Tools.” In the dropdown menu click on the Gearbox labeled “Add-ins.” Check Solver Add-in and click ok. Solver will now be available in the far-right side of the Data Ribbon. 2. Click on the Data Ribbon, and open solver. 3. We’ve been asked to find an order combination that would maximize our profit. So, make sure we set our profit (Cell B17) as our objective. 4. Our variable cells will be the “# ordered” of each product level (Cells B10, B11, B12). Make sure to separate by a comma. 5. Now we must set constraints for the # Ordered. Each count must be between the Minimum and Maximum demand on the sheet. 6. The Argentina branch has an Account Payable limit of $200,000 with our suppliers, so we must also set a constraint, so we don’t get an answer that goes above that limit 7. Double check you have constraints for all demand levels, and Account spend limit, and then click “Solve.” **Data Files** - [Challenge144\_Data.xlsx](https://byu.box.com/shared/static/9jr2tz4z4asu91z4roovwidfav1eam32) > **Suggestions and Hints** > > - Make sure to have a each product possible “#Ordered” constrained between “Min demand” and “Max demand.” Use both =\< and \>=. > - For the Account Limit Constraint, add a rule that says “E13 =\< E14” **Solution** [Challenge144\_Solver\_Solution.xlsx](https://byu.box.com/shared/static/4n4ibsf6bx55bw2c9qtg8nj7z6rhyuf8) _Solution Video:_ [Challenge 144EXCEL – Solver](https://youtu.be/C1Ti9higB_0) ---
**Author:** ![Benjamin\_Lau](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/benjamin_lau/32/379_2.png) [@Benjamin\_Lau](https://www.techhub.training/u/Benjamin_Lau)\ **Post date:** [March 12, 2024, 8:36pm UTC](https://www.techhub.training/t/144-excel-solver/2232/2 "2024-03-12T20:36:27Z")
Thanks Dallin for the nice little solver challenge. Here is my solution. ![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/0/06a8304fa3c8c30f436586c96e73bbb548de89bf.png) [Challenge144\_Solver.xlsx](https://www.techhub.training/uploads/short-url/kTz2jyCaQ0vy8BSRfpExJQKNU2g.xlsx) (12.3 KB) ---
**Author:** ![Carter\_Lee](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/carter_lee/32/5482_2.png) [@Carter\_Lee](https://www.techhub.training/u/Carter_Lee)\ **Post date:** [March 12, 2024, 8:37pm UTC](https://www.techhub.training/t/144-excel-solver/2232/3 "2024-03-12T20:37:54Z")
Great short challenge that helped me refresh my skills in solver! [Solver Start\_carter.xlsx](https://www.techhub.training/uploads/short-url/8QhG0ee9y7LFmeQ69PATMaxwjNm.xlsx) (14.2 KB) ---
**Author:** ![Jared\_Persson](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Jared\_Persson](https://www.techhub.training/u/Jared_Persson)\ **Post date:** [April 8, 2024, 5:57pm UTC](https://www.techhub.training/t/144-excel-solver/2232/4 "2024-04-08T17:57:45Z")
I liked the solver challenge! I got 248,500$ for the answer. It was a good refresher on how everything works! I especially enjoyed the extra constraint of not surpassing the value–sometimes, we need to remember that the constraints make it non-infinite! ---
**Author:** ![Jared\_Persson](https://avatars.discourse-cdn.com/v4/letter/j/13edae/32.png) [@Jared\_Persson](https://www.techhub.training/u/Jared_Persson)\ **Post date:** [April 8, 2024, 5:58pm UTC](https://www.techhub.training/t/144-excel-solver/2232/5 "2024-04-08T17:58:20Z")
[Challenge144\_Data.xlsx](https://www.techhub.training/uploads/short-url/hWuoKln8ehHndVUq12EQms9HoC3.xlsx) (110.8 KB) Whoops, heres the file. ---
**Author:** ![Andrew\_Christensen](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/andrew_christensen/32/7013_2.png) [@Andrew\_Christensen](https://www.techhub.training/u/Andrew_Christensen)\ **Post date:** [April 8, 2024, 8:13pm UTC](https://www.techhub.training/t/144-excel-solver/2232/6 "2024-04-08T20:13:36Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/8/8eec7211ba806820c8523786e879c7100c931f8c.png) ---
**Author:** ![Alexis\_Larsen](https://avatars.discourse-cdn.com/v4/letter/a/dc4da7/32.png) [@Alexis\_Larsen](https://www.techhub.training/u/Alexis_Larsen)\ **Post date:** [April 8, 2024, 10:37pm UTC](https://www.techhub.training/t/144-excel-solver/2232/7 "2024-04-08T22:37:11Z")
Here is my solution to your challenge! Thanks! ![Screenshot (94)](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/d/d7831e429d1c3b98353b0e55b6fa1283a9dfad09.jpeg) ---
**Author:** ![Nathan\_Orton](https://avatars.discourse-cdn.com/v4/letter/n/85e7bf/32.png) [@Nathan\_Orton](https://www.techhub.training/u/Nathan_Orton)\ **Post date:** [April 9, 2024, 12:59am UTC](https://www.techhub.training/t/144-excel-solver/2232/8 "2024-04-09T00:59:36Z")
Here is my solution ![Screenshot 2024-04-08 185859](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/f/f450c8334b314dd316b5071abddd1745f1dd8ee0.png) ---
**Author:** ![Cade\_Miller](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/cade_miller/32/7032_2.png) [@Cade\_Miller](https://www.techhub.training/u/Cade_Miller)\ **Post date:** [April 9, 2024, 2:56am UTC](https://www.techhub.training/t/144-excel-solver/2232/9 "2024-04-09T02:56:20Z")
I got $248,500 ---
**Author:** ![BenWaite](https://avatars.discourse-cdn.com/v4/letter/b/bb73d2/32.png) [@BenWaite](https://www.techhub.training/u/BenWaite)\ **Post date:** [April 9, 2024, 3:23am UTC](https://www.techhub.training/t/144-excel-solver/2232/10 "2024-04-09T03:23:58Z")
The solution I got was $248,500. ---
**Author:** ![jrdangl](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jrdangl](https://www.techhub.training/u/jrdangl)\ **Post date:** [April 9, 2024, 7:02am UTC](https://www.techhub.training/t/144-excel-solver/2232/11 "2024-04-09T07:02:34Z")
Dallin Gardner, the Excel Solver Problem was interesting. I was glad to refresh my skills with the application. [Challenge144\_Data.xlsx](https://www.techhub.training/uploads/short-url/eaGTHgiFhRgUVL0GD1fNqFSc5F2.xlsx) (85.4 KB) ---
**Author:** ![Maddie\_Monroe](https://avatars.discourse-cdn.com/v4/letter/m/ea666f/32.png) [@Maddie\_Monroe](https://www.techhub.training/u/Maddie_Monroe)\ **Post date:** [April 9, 2024, 7:02pm UTC](https://www.techhub.training/t/144-excel-solver/2232/12 "2024-04-09T19:02:28Z")
Here is my solution! Thank you! ![Screenshot 2024-04-09 at 1.01.35 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/2/2d16559188d9862dcdf14b16d41193ed33411c9f.png) ---
**Author:** ![Makenzie\_Whitman](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/makenzie_whitman/32/7124_2.png) [@Makenzie\_Whitman](https://www.techhub.training/u/Makenzie_Whitman)\ **Post date:** [April 9, 2024, 7:21pm UTC](https://www.techhub.training/t/144-excel-solver/2232/13 "2024-04-09T19:21:35Z")
![image](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/a/ad70e4658e1e30995dda9fca35eafc7967036d5b.png) Here is my solution ---
**Author:** ![Alex\_Perry](https://sea2.discourse-cdn.com/flex016/user_avatar/www.techhub.training/alex_perry/32/6937_2.png) [@Alex\_Perry](https://www.techhub.training/u/Alex_Perry)\ **Post date:** [April 9, 2024, 9:28pm UTC](https://www.techhub.training/t/144-excel-solver/2232/14 "2024-04-09T21:28:53Z")
I got $248,500 using the following constraints: $B$10:$B$12 \<= $H$10:$H$12 $B$10:$B$12 \>= $G$10:$G$12 $E$13 \<= $E$14 ---
**Author:** ![Michael\_Nichols](https://avatars.discourse-cdn.com/v4/letter/m/3ec8ea/32.png) [@Michael\_Nichols](https://www.techhub.training/u/Michael_Nichols)\ **Post date:** [April 9, 2024, 9:52pm UTC](https://www.techhub.training/t/144-excel-solver/2232/15 "2024-04-09T21:52:47Z")
Here’s my solution, thank you for the challenge! ![Screenshot 2024-04-09 155132](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/f/f8c375dbb38ec125a26dc68e7f39b2f25a6a47f1.png) ---
**Author:** ![Austin\_Napierski](https://avatars.discourse-cdn.com/v4/letter/a/6a8cbe/32.png) [@Austin\_Napierski](https://www.techhub.training/u/Austin_Napierski)\ **Post date:** [April 11, 2024, 1:04am UTC](https://www.techhub.training/t/144-excel-solver/2232/16 "2024-04-11T01:04:11Z")
Time to complete: 15 minutes Difficulty: Easy Solution: $248,500 ---
**Author:** ![Adalyn\_Curtis](https://avatars.discourse-cdn.com/v4/letter/a/e9a140/32.png) [@Adalyn\_Curtis](https://www.techhub.training/u/Adalyn_Curtis)\ **Post date:** [April 11, 2024, 8:51pm UTC](https://www.techhub.training/t/144-excel-solver/2232/17 "2024-04-11T20:51:51Z")
Time to complete: 20 min Difficulty: medium-hard Solution: $248,500.00 Thanks for the challenge! ---
**Author:** ![Avery\_Evans](https://avatars.discourse-cdn.com/v4/letter/a/e99b99/32.png) [@Avery\_Evans](https://www.techhub.training/u/Avery_Evans)\ **Post date:** [April 16, 2024, 7:23pm UTC](https://www.techhub.training/t/144-excel-solver/2232/18 "2024-04-16T19:23:56Z")
![Screen Shot 2024-04-16 at 1.18.48 PM](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/5/5dc01b59511b24dc3cfe0f21dbb9e2c77031acaf.jpeg) I completed the survey in about 5 minutes. It was a great refresher on how to use Solver! Thank you!! ---
**Author:** ![Cooper\_Kennedy](https://avatars.discourse-cdn.com/v4/letter/c/6bbea6/32.png) [@Cooper\_Kennedy](https://www.techhub.training/u/Cooper_Kennedy)\ **Post date:** [April 16, 2024, 10:52pm UTC](https://www.techhub.training/t/144-excel-solver/2232/19 "2024-04-16T22:52:23Z")
here is my solution ![Screen Shot 2024-04-16 at 16.51.54](https://us1.discourse-cdn.com/flex016/uploads/weeklytechchallenge/original/2X/1/1fbf51f1b88b41d59cbb7f2cedfde3f2f31c599d.png) ---
**Author:** ![Taylor\_Wall](https://avatars.discourse-cdn.com/v4/letter/t/3da27b/32.png) [@Taylor\_Wall](https://www.techhub.training/u/Taylor_Wall)\ **Post date:** [April 18, 2024, 4:18pm UTC](https://www.techhub.training/t/144-excel-solver/2232/20 "2024-04-18T16:18:09Z")
I enjoyed this! I got $248,500 as my answer. Rating: Intro Great refresher as to use solver. [Next page](https://www.techhub.training/t/144-excel-solver/2232.md?page=2)