Question: Please provide the Excel process/formulas. Thank you! Solve the following problems using a computer application (Excel, Excel QM, QM or Excel Solver, etc.) For all


Please provide the Excel process/formulas. Thank you!
Solve the following problems using a computer application (Excel, Excel QM, QM or Excel Solver, etc.) For all the problems, make sure the following are included: o Complete solutions, the complete Linear Programming formulation or model, and the FINAL answers (highlighted in yellow or any other color you wish.) 1) A small furniture manufacturer produces tables and chairs. Each product must go through three stages of the manufacturing process: Assembly, Finishing, and Inspection. Each table requires 3 hours of assembly, 2 hours of finishing, and 1 hour of inspection. Each chair requires 2 hours of assembly, 2 hours of finishing, and 1 hour of inspection. The profit per table is $120, while the profit per chair is $80. Currently, each week there are 200 hours of assembly time available, 180 hours of finishing time, and 40 hours of inspection time. To keep a balance, the number of chairs produced should be at least twice the number of tables. Also, the number of chairs cannot exceed six times the number of tables. How many tables and chairs should the furniture manufacturer produce to maximize profit? What is the optimal profit? (Manufacturing application)Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
