Using the Excel Solver results in Table, address the following questions explaining your answer: 10 minutes on slide How much will it cost to buy 40 more units of "wood" - 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 x 10 0 3 8 Type By 5 0 5 2 Type C 2 0 -6.5 2 6.5 1E+30 How much can the amount of steel change without changing the optimal solution? 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 15 30 110 30 hours 3 15 0 70 1E+30 55 How much should the "Type C product unit profit be increased by so the manufacturer can produce them