Question: Using the Sensitivity Report output for the Blue Ridge Hot Tub example appearing below: a. What is the range in the number of available pumps

Using the Sensitivity Report output for the Blue Ridge Hot Tub example appearing below: a. What is the range in the number of available pumps that will keep the current basis optimal assuming the amount of labor hours and tubing feet remain constant ? b. Blue Ridge is considering introducing a new model of hot tub called the Typhoon-Tub. Suppose that each unit of this new model requires 1 pump, 12 hours of labor, and 13 feet of tubing. Find the inimum marginal profit that will make this new product profitable. Adjustable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$3 Units Aqua Spa 122 0 3 50 100 $C$3 Units Hydro-Lux 78 0 300 50 66.66666667 50 Constraints Final Allowable Decrease Cell $1$4 $1$5 $1$6 Name Pumps Usage Labor Usage Tubing Usage 26 Shadow Price 200 16.66666667 0 Value 200 1566 2712 Constraint Allowable R.H. Side Increase 2007 1566 234 2880 1E+30 126 168
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
