14 Interpreting Sensitivity Reports Adjustable cells Final V

14. Interpreting Sensitivity Reports Adjustable cells Final Value Cell Name $G$17 Product X SHS 17 Product Y Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 40 13.33333333 0 40 120 80 Constraints Final Value Shadow Price 6.2 Cell Name SI$18 Machining $I$19 Labor SI$20 Painting Constraint Allowable Allowable R.H. Side Increase Decrease 1E+30 0.8 4.70588235 1 0.666666667 0.444444444 10 80 10

Solution

D.

5.

As the possible decrease is	0.8
7 to 6.5 the change is	0.5
So the optimal solution remains the same
Optimal solution
Prod X	120
Prod Y	80
Objective function
	Value	Coeff
Prod X	120	40
Prod Y	80	40
Total cost	8000	Sum (Value*Coeff)