Answer Happy

Variable Cells Cell Name $B$14 Quantity Produced Gallery $C$14 Quantity Produced NeoChef Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 84 0 14 36 72 0 30 108 7 46 Constraints Cell Name $D$16 Fabrication Limitations $D$18 Assembly Limitations Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 480 10.8 480 720 280 600 1.4 600 840 360

Using only the Solver sensitivity report, answer the following questions. [11] If the unit profit for Gallery microwaves is increased to $60, can you predict how the optimal solution and profit will change? If so, what would change? Current: $46. New: $60. Increase of $16. NO, the increase of $16 is greater than the max allowable increase of $14. [12] Are any of the constraints binding? If so, which constraint(s)? [13] What is the shadow price of Fabrication and what does it indicate for this problem?