Question: Develop your answers on an Excel spreadsheet Question 2: Linear Programming Problem A manufacturer of three models of tote bag must determine the production plan
Develop your answers on an Excel spreadsheet Question 2: Linear Programming Problem A manufacturer of three models of tote bag must determine the production plan for the next quarter. The specifics for each model are shown in the following table: Model Revenue ($ per item) Cutting (hours per item) Sewing (hours per item) Packing (hours per item) A $8.75 .10 .05 .20 B $10.50 .15 .12 .20 C $11.50 .20 .18 .20 Time available in the three production departments are: Cutting 450 hours, Sewing 550 hours, Packing 450 hours. Based on market research, the company wants to make at least 300 model As, 400 model Bs and 250 model Cs but no more than no more than 1200 of any one model. Costs in each department are: Cutting $10.00 per hour, Sewing $12.50 per hour, Packing $9.50 per hour. Write the Linear Programming formulation for this problem to help determine the best production mix of the three models that will maximize profit.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
