Interpreting Sensitivity Reports Adjustable Cells

Cell: $G$17 Name: Product X Final Value: 120 Reduced Cost: 0 Objective Coefficient: 40 Allowable Increase: 13.33333333 Allowable Decrease: 0

Cell:$H$17 Name: Product Y Final Value: 80 Reduced Cost: 0 Objective Coefficient: 40 Allowable Increase: 0 Allowable Decrease: 10

Constraints

Cell: $I$18 Name: Machining Final Value: 6.2 Shadow Price: 0 Constraint RHS: 7 Allowable Increase: 1E+30 Allowable Decrease:.8

Cell: $I$19 Name: Labor Final Value: 10 Shadow Price: 80 Constraints RHS: 10 Allowable Increase: 4.70588235 Allowable Decrease: 1

Cell: $I$20 Name: Painting Final Value: 6 Shadow Price: 0 Constraint RHS:6 Allowable Increase: .666666667 Allowable Decrease: .4444444

A) If profit margin for X is increased by 10, what would be the change in optimum value? What if it is increased by 15?

B) If profit margin for Y is decreased to 39, what would he te change in optimum value?

C) If 3 hours of extra labor can be provided for a total cost of $200, should the conpanyt do it? Why or why not?

D) The machining availability has dropped from 7 to 6.5. What impact will Thai have on the optimal solution and the optimal value?

E) The painting availability has dropped from 6 to 5.5. What impact will this have o. the optimal solution and the optimal value?