Furnco manufactures desks and chairs. Each desk uses 4 units of wood, and each chair uses 3 units of wood. A desk contributes $40 to profit, and a chair contributes $25. Marketing restrictions require...

Furnco manufactures desks and chairs. Each desk uses 4 units of wood, and each chair uses 3 units of wood. A desk contributes $40 to profit, and a chair contributes $25. Marketing restrictions require that the number of chairs produced be at least twice the number of desks produced. There are 20 units of wood available.

 a. Use Solver to maximize Furnco’s profit.

 b. Confirm graphically that the solution in part a maximizes Furnco’s profit.

c. Starting with the optimal solution, use SolverTable to see what happens to the decision variables and the total profit when the availability of wood varies from 10 to 30 in 1-unit increments. Based on your findings, how much would Furnco be willing to pay for each extra unit of wood over its current 20 units? How much profit would Furnco lose if it lost any of its current 20 units?