Rachel Company produces chairs and tables. The production of each chair requires 20 square foot of wood and 4 labor hours. The production of each table requires 25 square foot of wood and 5 labor hours. The profit by selling the chair is $ 200 per unit and profit by selling the table is $ 300 per unit. There are total of 1200 square foot of wood available and 1500 labors available.
a) Given these conditions, formulate a linear programming problem.
b) Solve the problem using excel solver.