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 $0-2302402301$E$+30$

$C$$5$ Number to Make Table $100720180120$

$D$$5$ Number to Make Armoire $150600120120$

Constraints

Final Shadow Constraint Allowable Allowable

Cell Name Value Price R$.$H$.$ Side Increase Decrease

$E$$9$ Assembly Minutes Used $3600203600400600$

$E$$10$ Finishing Minutes Used $20004\mathrm{.}52000400400$

$E$$11$ Wood Pounds Used $3600040001$E$+30400$

$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.