Problem: A self employed carpenter earns $90 for the sale of a table and $180 for the sale of a rocking chair.
It takes 2 hours for him to make a table and 5 hours to manufacture a rocking chair. He is limited to working 40 hours per week. The average manufacturing cost is $15 per table and $45 per rocking chair. He wishes to keep his manufacturing costs at $315 per week. How many tables and rocking chairs should he make to maximize his weekly sales? Determine the maximum sales and profit he can make per week in excel.