Given results after developing the excell P and Solver: Question 4: Sensitivity Analysis (20 Points Using the Excel Solver results in Table, address the following questions explaining your answer: 10 minutes on slide a. How much will it cost to buy 40 more units of "wood"? b. How much will it cost to increase the "hours" by 30 more? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient increase Decrease Type A 10 0 3 8 Type B Y 5 0 5 2 Type C 2 0 -6.5 2 6.5 1E+30 c. How much can the amount of "steel" change without changing the optimal solution? d. Will the optimal solution remain unchanged if coefficient of "Type A" increases to 7 and coefficient of "Type B" increases to 6? Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Wood 1 15 1 15 20 10 Steel 2 30 1.5 30 110 30 hours 3 15 0 1E+30 55 70 How much should the "Type C" product unit profit be increased by so the manufacturer can produce them? Given results after developing the excell P and Solver: Question 4: Sensitivity Analysis (20 Points Using the Excel Solver results in Table, address the following questions explaining your answer: 10 minutes on slide a. How much will it cost to buy 40 more units of "wood"? b. How much will it cost to increase the "hours" by 30 more? Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient increase Decrease Type A 10 0 3 8 Type B Y 5 0 5 2 Type C 2 0 -6.5 2 6.5 1E+30 c. How much can the amount of "steel" change without changing the optimal solution? d. Will the optimal solution remain unchanged if coefficient of "Type A" increases to 7 and coefficient of "Type B" increases to 6? Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease Wood 1 15 1 15 20 10 Steel 2 30 1.5 30 110 30 hours 3 15 0 1E+30 55 70 How much should the "Type C" product unit profit be increased by so the manufacturer can produce them