A linear programming computer package is needed.Greenville Cabinets received a contract to produce cabinets for a major furniture distributor. The contract calls for the production of 3,300 small cabinets and 4,100 large over the next two months, with the following delivery scheduleModelMonth 1Month 2Small2,1001,200Large1,5002,600Greenville estimates that the production time for each small cabinet is 0.7 hours and the production time for each large cabinet is 1 hour. The raw material costs are $10 for each small cabinet and $12 for each large cabinet. Labor costs are $22 per hour using regular production time and $33 using overtime. Greenville has up to 2,400 hours of regular production time available each month and up to 1,000 additional hours of overtime available each month. If production for either cabinet exceeds demand in month 1, the cabinets can be stored at a cost of $5 per cabinet. For each product, determine the number of units that should be manufactured each month on regular time and on overtime to minimize total production and storage costs. (Round your answers to the nearest integer. Let SaR = regular small cabinets for month 1, SbR = regular small cabinets for month 2, LaR = regular large cabinets for month 1, LbR = regular large cabinets for month 2, SaO = overtime small cabinets for month 1, SbO = overtime small cabinets for month 2, LaO = overtime large cabinets for month 1, and LbO = overtime large cabinets for month 2)(SaR, SbR, LaR, LbR, SaO, SbO, LaO, LbO)= Total Production Cost=$ ### Linear Programming Computer Package for Greenville Cabinets**Context:**Greenville Cabinets received a contract to produce cabinets for a major furniture distributor. The contract calls for the production of 3,300 small cabinets and 4,100 large cabinets over the next two months, with the following delivery schedule:#### Delivery Schedule:| Model | Month 1 | Month 2 ||-------|---------|---------|| Small | 2,100 | 1,200 || Large | 1,500 | 2,600 |**Production Estimates & Costs:**Greenville estimates the production time for each small cabinet is 0.7 hours, and for each large cabinet, it is 1 hour. The raw material costs are $10 per small cabinet and $12 per large cabinet. Labor costs are $32 per hour using regular production time and $33 using overtime. **Production Constraints:**- Regular production time available: 2,400 hours per month.- Overtime available: up to 1,000 additional hours per month.If production for either cabinet exceeds demand in Month 1, the cabinets can be stored at a cost of $5 per cabinet.**Objective:**Determine the number of units that should be manufactured each month on both regular time and overtime to minimize total production and storage costs.**Decision Variables:**- **SR1**: Regular small cabinets for Month 1- **SR2**: Regular small cabinets for Month 2- **LR1**: Regular large cabinets for Month 1- **LR2**: Regular large cabinets for Month 2- **SO1**: Overtime small cabinets for Month 1- **SO2**: Overtime small cabinets for Month 2- **LO1**: Overtime large cabinets for Month 1- **LO2**: Overtime large cabinets for Month 2**Calculation Box:**- Total Production Cost: `[Input Placeholder]`This model helps to optimize production scheduling ensuring minimal costs while meeting contract requirements.

Find the Given details below:ModelMonth 1Month 2Small2,1001,200Large1,5002,600

Greenville Cabinets received a contract to produce cabinets for a major furniture distributor. The contract calls for the production of 3,300 small cabinets and 4,100 large over the next two months, with the following delivery schedule Model Month 1 Month 2 Small 2,100 1,200 Large 1,500 2,600 Greenville estimates that the production time for each small cabinet is 0.7 hours and the production time for each large cabinet is 1 hour. The raw material costs are $10 for each small cabinet and $12 for each large cabinet. Labor costs are $22 per hour using regular production time and $33 using overtime. Greenville has up to 2,400 hours of regular production time available each month and up to 1,000 additional hours of overtime available each month. If production for either cabinet exceeds demand in month 1, the cabinets can be stored at a cost of $5 per cabinet. For each product, determine the number of units that should be manufactured each month on regular time and on overtime to minimize total production and storage costs. (Round your answers to the nearest integer. Let SaR = regular small cabinets for month 1, SbR = regular small cabinets for month 2, LaR = regular large cabinets for month 1, LbR = regular large cabinets for month 2, SaO = overtime small cabinets for month 1, SbO = overtime small cabinets for month 2, LaO = overtime large cabinets for month 1, and LbO = overtime large cabinets for month 2) (SaR, SbR, LaR, LbR, SaO, SbO, LaO, LbO)= Total Production Cost=$

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

A linear programming computer package is needed.

Greenville Cabinets received a contract to produce cabinets for a major furniture distributor. The contract calls for the production of 3,300 small cabinets and 4,100 large over the next two months, with the following delivery schedule

Model	Month 1	Month 2
Small	2,100	1,200
Large	1,500	2,600

Greenville estimates that the production time for each small cabinet is 0.7 hours and the production time for each large cabinet is 1 hour. The raw material costs are $10 for each small cabinet and $12 for each large cabinet. Labor costs are $22 per hour using regular production time and $33 using overtime. Greenville has up to 2,400 hours of regular production time available each month and up to 1,000 additional hours of overtime available each month. If production for either cabinet exceeds demand in month 1, the cabinets can be stored at a cost of $5 per cabinet. For each product, determine the number of units that should be manufactured each month on regular time and on overtime to minimize total production and storage costs. (Round your answers to the nearest integer. Let SaR = regular small cabinets for month 1, SbR = regular small cabinets for month 2, LaR = regular large cabinets for month 1, LbR = regular large cabinets for month 2, SaO = overtime small cabinets for month 1, SbO = overtime small cabinets for month 2, LaO = overtime large cabinets for month 1, and LbO = overtime large cabinets for month 2)

(SaR, SbR, LaR, LbR, SaO, SbO, LaO, LbO)=

Total Production Cost=$