Using solver Brown Furniture Revisited Revisit the Brown Furniture Company $($Example $2\mathrm{.}1).$ As plans are being made for a new quarter, a revised set of figures on resource availabilities is compiled. The new resource limits are as follows.

Fabrication hours $2000$

Assembly hours $1800$

Machining hours $1600$

Wood supply $9400$

The other data, on profit contributions and resource consumptions, all remain unchanged.

$($a$)$ What are the optimal production quantities of chairs, desks, and tables?

$($b$)$ What is the maximum profit contribution?

$($c$)$ Which constraints are binding in the optimal solution?

$($d$)$ Which scarce resource is the most valuable? $($ie: if raised by one unit, which constraint raises the profit most? What is the value of that unit increase?