Woodworks Industries Inc.

please answer using excel!

Q1. (30 points) Woodworks Industries Inc. produces a variety of products. In a particular manufacturing process, two types of wood, mahogany and pine along with the carpenters are the main resources of the company. The company is planning to introduce a new type of closet, a new set tables and office chairs using these three main resources, The requirements of each product for each resources is given in the table below. Constraints: 1. Number of chairs should be more than 4 times the number of tables. 2. Number of closets and tables should be balanced, 3. A maximum of 95 should be manufactured from each product. If we model this problem as a linear programming problem and represent C: number of closets to be manufactured T: number of tables to be manufactured O: number of office chairs to be manufactured And each closet set is sold for $400, each table set for $300 and each office chair for $80, Then, what number of each product should be manufactured to maximize the revenue? (Decimal numbers are OK) Carpenter hours Mahogany Pine (units) (units) 2.5 1 1.52 1 3 300 350 Closet set Table set Chairs set Available 5 3 4 600 Q1. (30 points) Woodworks Industries Inc. produces a variety of products. In a particular manufacturing process, two types of wood, mahogany and pine along with the carpenters are the main resources of the company. The company is planning to introduce a new type of closet, a new set tables and office chairs using these three main resources, The requirements of each product for each resources is given in the table below. Constraints: 1. Number of chairs should be more than 4 times the number of tables. 2. Number of closets and tables should be balanced, 3. A maximum of 95 should be manufactured from each product. If we model this problem as a linear programming problem and represent C: number of closets to be manufactured T: number of tables to be manufactured O: number of office chairs to be manufactured And each closet set is sold for $400, each table set for $300 and each office chair for $80, Then, what number of each product should be manufactured to maximize the revenue? (Decimal numbers are OK) Carpenter hours Mahogany Pine (units) (units) 2.5 1 1.52 1 3 300 350 Closet set Table set Chairs set Available 5 3 4 600