Greenville Cabinets received a contract to produce speakercabinets for a major speaker manufacturer. The contract calls forthe production of 3300 bookshelf speakers and 4100 floor speakersover the next two months, with the following delivery schedule:
Model | Month 1 | Month 2 |
Bookshelf | 2100 | 1200 |
Floor | 1500 | 2600 |
Greenville estimates that the production time for each bookshelfmodel is 0.7 hour and the production time for each floor model is 1hour. The raw material costs are $10 for each bookshelf model and$12 for each floor model. Labor costs are $22 per hour usingregular production time and $33 using overtime. Greenville has upto 2400 hours of regular production time available each month andup to 1000 additional hours of overtime available each month. Ifproduction for either cabinet exceeds demand in month 1, thecabinets can be stored at a cost of $5 per cabinet. For eachproduct, determine the number of units that should be manufacturedeach month on regular time and on overtime to minimize totalproduction and storage costs.
Build an LP model for this problem (insert a textbox in an Excelworksheet and type in the LP model by defining decision variables,clearly stating the objective function and the constraints). Then,enter your model into the same Excel worksheet and solve it usingExcel solver. Save your Excel file under your full name and thenupload your file.
