Question: WFinal Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Number of units Oak tables 3.00 0.00 75.00 0.00 1E+30 $C$4 Number
WFinal Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Number of units Oak tables 3.00 0.00 75.00 0.00 1E+30 $C$4 Number of units Oak chairs 51.67 0.00 35.00 1E+30 0.00 $D$4 Number of units Cherry tables 3.00 0.00 90.00 0.00 1E+30 $E$4 Number of units Cherry chairs 85.56 0.00 60.00 1E+30 0.00 $F$4 Number of units Pine tables 42.26 0.00 45.00 88.33 0.00 $G$4 Number of units Pine chairs 33.08 0.00 20.00 0.00 13.25 Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $H$7 Labor hours 1000.00 10.00 1000.00 373.30 37.21 $H$8 Oak (pounds) 2150.00 0.00 2150.00 318.93 1250.00 $H$9 Cherry (pounds) 3800.00 0.00 3800.00 223.25 2239.78 $H$10 Pine (pounds) 8500.00 0.00 8500.00 1488.33 5039.50 $H$11 Min oak tables 3.00 0.00 3.00 6.25 2.35 $H$12 Min cherry tables 3.00 0.00 3.00 11.33 1.20 $H$13 Min oak chairs 51.67 0.00 10.00 41.67 1E+30 $H$14 Min cherry chairs 85.56 0.00 10.00 75.56 1E+30 $H$15 Min pine chairs 33.08 0.00 5.00 28.08 1E+30hat is the range over which the unit profit for oak chairs can change without changing the optimal solution
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
