To clarify my previous question concerning linear programming via a link, I decide to capture the question here for easy solution. I need a solution to these two questions using Microsoft excel. A step by step procedure to follow in solving this question as well as the final answer will be much appreciated.

1. A company receives in sales $20 per book and $18 per calculator. The cost per unit to manufacture each book and calculator are $5 and $4 respectively. The monthly (30 day) cost must not exceed $27,000 per month. If the manufacturing equipment used by the company takes 5 minutes to produce a book and 15 minutes to produce a calculator, how many books and calculators should the company make to maximize profit? Determine the maximum profit the company earns in a 30 day period. 2. 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