Question

(10) Problem #3 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 minimum marginal profit that will make this new product profitable Adiustable Cells Final Reduced Objective Allowable Allowable Decrease Cell SBS3 Units Aqua Spa $C$3 Units Hydro-Lux Value 122 78 Name Cost Coefficient Increase 100 350 300 50 50 66.66666667 Constraints Final Shadow Constraint Allowable Allowable Increase Decrease Cell $I$4 Pumps Usage $I$5 Labor Usage SIS6 Tubing Usage Value Price Name R.H. Side 200 1566 16.66666667 2712 200 1566 2880 200 26 126 168 234 1E+30

Answer 1

Soccutton ) Ngco caicrei laseng the sange tn ta) the nombe of the nomb a vaitable umps 2 Range nd .Faom table ble Pu14 , 207)