Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started