Assignment:
A furniture company is producing tables and chairs for the coming week. The production of tables and chairs will go through two processes: wood cutting and assembly. In the wood cutting process, the required labor hour is 1 hour for a chair and 2 hours for a table. In the assembly process, the required labor hour is 4 hours for a chair and 3 hours for a table. For the coming week, the maximum assembly hours for the wood cutting process and 180 hours for the decides process. Based on the company's inventory level, the company to produce no more than 100 chairs and 30 tables for the coming week. Suppose the profit margin is $5/chair and $6/table. Set up a programming model to maximize the total profit for this furniture company and solve the model using Excel Solver.
Provide complete and step by step solution for the question and show calculations and use formulas.