1.A Wood Company manufactures Oak Tables, Pine Tables, Oak Chairs and Pine Chairs. The unit profit respectively on each is $40, $40, $15 and $15. Each Oak table utilizes 17 feet of Oak and each Oak chair utilizes 5 feet of oak. Each pine table uses 30 feet of pine and each pine chair uses 1 feet of pine.

Total Oak available is 300 feet and total pine available is 550 feet.

Use Solver in MS Excel to maximize the Total Profit.

use solver in excel