Figure 13.32 shows the Solver sensitivity report for Valencia Products. Using only the information in the sensitivity report, answer the following questions.

a. Explain why the reduced cost for Speed Buster is 0.

b. If the unit profit for Speed Buster is decreased to $ 35, can you predict how the optimal solution and profit will change?

c. If the unit profit for Laser Stop is increased to $ 64, can you predict how the optimal solution and profit will change? d. If an additional 500 units of component A are available, can you predict how the optimal solu­tion and profit will be affected?

e. If a supplier delay results in only 3,400 units of component B available, can your predict how the optimal solution and profit will be affected?

Transcribed Image Text:

н 6 Objective Cell (Max) Final Value Cell Name SA$18 TOTAL PROFIT 13333.33333 9. 10 Decision Variable Cells Final 11 Reduced Objective Allowable Allowable Coefficient Increase Cell $B$11 Numbers Produced LaserStop $C$11 Numbers Produced SpeedBuster Value 12 Name Cost Decrease 36 13 0.00 -36.00 24 1E+30 333.33 1E+30 24.00000007 0.00 14 40 15 16 Constraints Final Shadow Constraint Allowable Allowable 17 18 Cell Value Price R.H. Side Increase Decrease Name $D$14 Component A Used $D$15 Component B Used 19 4000 3.333333333 4000 200 4000 20 3333.333333 3500 1E+30 166.6666667