AA 6:52 Reference the following sensitivity report to answer the questions: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Number to Make Chair $C$5 Number to Make Table 0 -230 240 230 1E+30 10 0 720 180 120 $D$5 Number to Make Armoire 15 0 600 120 120 Constraints Final Shadow Constraint Allowable Allowable Cell Name $E$9 Assembly Minutes Used SE$10 Finishing Minutes Used $E$11 Wood Pounds Used Value Price R.H. Side Increase Decrease 3600 20 3600 400 600 2000 4.5 2000 400 400 3600 0 4000 1E+30 400 1) What is the optimal solution? 2) Suppose the profit per table changed to $950. Will the optimal solution change, and what can be said about the effect on total profit? Why/why not? Will the total profit change? If so, by how much? 3) Suppose the profit per table changed to $800. Will the optimal solution change, and what can be said about the effect on total profit? Why/why not? Will the total profit change? If so, by how much? 4) Suppose there are 300 less minutes available for Assembly. What can be said about the effect on total profit? If so, by how much? 5) Suppose the company had an opportunity to acquire 500 minutes of Finishing capacity for a total cost of $2300. Should they do so? Explain. ccis.ucourses.com