DQ Sensitivity Analysis.jpg Using the information in the Sensitivity Analysis report above, answer the following questions. Assume each question is independent of any other question.

1. If the objective function coefficient of hockey sticks increases to $2.50, does the final solution change?

2. What is the total profit of this optimal plan?

3. What is the impact on the objective function if we acquire 15 additional resource hours for machine B?

4. Which constraint is non-binding?

5. What is the impact on the objective function if we lose 60 resource hours for Machine A?

Variable Cells Final Reduced Cost Value Cell Name $B$2 Hockey Sticks $C$2 Chess Sets Objective Allowable Allowable Coefficient Increase Decrease 2 0.666666667 0.666666667 Constraints Final Shadow Value PriceR 120 0.333333333 72 0.333333333 Constraint Allowable .H. Side Increase 120 Allowable Decrease 36 Cell Name SD$6 Machine A Resources Used $D$7 Machine B Resources Used $D$8 Machine C Resources Used 24 18 1E+30 Using the information in the Sensitivity Analysis report above, answer the following questions. Assume each question is independent of any other