- In the Excel sheet, turn to the tab labeled “5 – Problem B.6.” Here’s a screenshot:
This has been partially formulated for you in Excel.
Run Solver and fill in the Solver parameters to get an optimal solution.
At optimality, you would produce
units of Model A and
units of Model B.Your total profit would be $. (Please enter your number without any commas. For example, if you want to enter $12,345 as your answer, just type in 12345.67.)
- Formulate and solve Problem B.10 (William Barnes) on p. 724 of Heizer and Render (13th edition). Run solver on it. You can check your answer against the back of the book to verify you have it working properly.
For this one, please round your units to the nearest tenth.
For example, if Solver tells you that you want 1.99999 wren houses, replace that with a 2.0 (literally by typing a 2.0 in the cell.)
If it tells you it wants 10.49999 bluebird houses, replace that with a 10.5.
You may need to expand the number of decimal places shown to see if this issue is happening.
You learn that instead of the given constraints, you now have
12 units of labor and
130 units of lumber available.At optimality,
What is your new maximum profit? $
How many wren houses would you make?
How many bluebird houses would you make?
- Formulate and solve Problem B.8 (Lifang Wu) on p. 724 of Heizer and Render (13th edition) in Excel and run Solver on it.”You can check your answer against that in the back of the book to ensure you have it set up correctly.
Assume you are allowed to produce a fractional unit, so if your answer calls for 3.5 units of something, you could make that.
Your dollar figures change so that A nets you $1800 per unit and B nets you $1200 per unit. The constraints remain the same.
What is your new optimal profit? Enter your answer as a number without any commas. For example, if you want to enter 12,345.67, type in 12345.67. $
How many of the Alpha 1 will you now produce?
How many of the Beta 2 will you now produce?