Answer Happy

The owner of Blue Ridge Hot Tubs, Howie Jones, has asked for
your assistance analyzing how the feasible region and solution to
his production problem might change in response to changes in
various parameters in the LP model. He is hoping this might further
his understanding of LP and how the constraints, objective function
and optimal solution interrelate. To assist in this process, he
asked a consulting firm to develop the spreadsheet shown earlier
in Figure 2.8 (and the file Fig2-8.xlsm that accompanies
this book) that dynamically updates the feasible region and optimal
solution as the various parameters in the model change.
Unfortunately, Howie has not had much time to play around with this
spreadsheet, so he has left it in your hands and asked you to use
it to answer the following questions. Click the Reset button in
file Fig2-8.xlsm before answering each of the following
questions.
The file Fig2-8.xlsm contains a macro that must be enabled for
the workbook to operate correctly. To allow this (and other) macros
to run in Excel click: File, Options, Trust Center, Trust Center
Settings, Macro Settings, select “Disbable all macros with
notification“, and click OK twice. Now when Excel opens a workbook
containing macros it should display a security message indicating
some active content has been disabled and will give you the
opportunity to enable this content, which you should do for the
Excel files accompanying this book.
How much would the optimal profit change if the company
increased the amount of tubing required to produce Aqua- Spas from
12 to 13 feet? From 13 to 14 feet? From 14 to 15 feet?
How much would the optimal profit change if the company
increased the amount of tubing required to produce Hydro- Luxes
from 16 to 17 feet? From 17 to 18 feet? From 18 to 19 feet?
Optimal Qty Unit Profits Total Profit Constraints Aqua Spas (X1) 122.00 $350 Pumps Labor Tubing Optimal solution Profit level curve Pump boundary line Labor boundary line Tubing boundary line Display 1 9 12 Hydro Luxes (X2) 78.00 $300 $66,100 # Required 1 6 16 Blue Ridge Hot Tubs X2 250- 200- 150- 100- 50 0 # Available 200 1566 2880 0 50 150 200 250 X1