A carpenter makes tables and chairs. Each table can be sold with a profit of 30 and each chair with a profit of 10 . The carpenter can work up to 40 hours a week and needs 6 hours to make a table and 3 hours to make a chair. Customer demand requires him to make at least 3 times more chairs than tables. Tables take up 4 times as much storage space as chairs and there is room for up to 4 tables each week.

How many tables and how many chairs will he have to build to maximize his profit based on the restrictions?

Solve the above problem with the use of

• Linear programming
• Excel solver
• Reformulate / re-define the problem and solve it with the use of non-linear programming.
• In each case elaborate on the results and comment / analyze findings.