Problem 4-21 (Algorithmic)
Greenville Cabinets received a contract to produce speaker cabinets for a major speaker manufacturer. The contract calls for the production of 5,300 bookshelf speakers and 6,100 floor speakers over the next two months, with the following delivery schedule:
Model | Month 1 | Month 2 |
Bookshelf | 3,100 | 2,200 |
Floor | 2,500 | 3,600 |
Greenville estimates that the production time for each bookshelf model is 0.6 hour and the production time for each floor model is 1 hour. The raw material costs are $20 for each bookshelf model and $22 for each floor model. Labor costs are $32 per hour using regular production time and $43 using overtime. Greenville has up to 3,400 hours of regular production time available each month and up to 2,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 $15 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. If required, round your answers to the nearest whole number.
Regular Time Manufacture | ||
Model | Month 1 | Month 2 |
Bookshelf | ||
Floor |
Overtime Manufacture | ||
Model | Month 1 | Month 2 |
Bookshelf | ||
Floor |
Spreadsheet model and solution using Solver is determined as below:
Solver parameters:
EXCEL FORMULAS:
Optimal production schedule:
Regular Time Manufacture | ||
Model | Mth 1 | Mth 2 |
Bookshelf | 1,500 | 0 |
Floor | 2,500 | 3,400 |
Overtime Manufacture | ||
Model | Mth 1 | Mth 2 |
Bookshelf | 1,600 | 2,200 |
Floor | 0 | 200 |
Total cost = $ 564,440
Problem 4-21 (Algorithmic) Greenville Cabinets received a contract to produce speaker cabinets for a major speaker...
Problem 4-21 (Algorithmic) Greenville Cabinets received a contract to produce speaker cabinets for a major speaker manufacturer. The contract calls for the production of 3,900 bookshelf speakers and 4,700 floor speakers over the next two months, with the following delivery schedule: Model Month 1 Month 2 Bookshelf 2,400 1,500 Floor 1,800 2,900 Greenville estimates that the production time for each bookshelf model is 0.8 hour and the production time for each floor model is hour. The raw material costs are...
Problem 3-25 Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and...
Wixis Cabinets makes custom wooden cabinets for high-end stereo systems from specialty woods. The company uses a job-order costing system. The capacity of the plant is determined by the capacity of its constraint, which is time on the automated bandsaw that makes finely beveled cuts in wood according to the preprogrammed specifications of each cabinet. The bandsaw can operate up to 187 hours per month. The estimated total manufacturing overhead cost at capacity is $15,147 per month. The company bases...
O/ Write an appropriate mathematical model for this problem including Decision Variables and their description, Objective Function, & Constraints. XAMPLE 4.3 AGGREGATE PLANNING AT SURESTEP uring the next four months the SureStep Company must meet (on time) the fol lowing demands for pairs of shoes: 3000 in month 1 5000 in month 2; 2000 in month 3; and 1000 in month 4. At the beginning of month 1, 500 pairs of shoes are on hand, and SureStep has 100 workers....
Alan Industries is expanding its product line to include three new products: A, B, and C. These are to be produced on the same production equipment, and the objective is to meet the demands for the three products using overtime where necessary. The demand forecast for the next four months, in hours required to make each product is: PRODUCT APRIL MAY JUNE JULY A 800 600 800 1,200 B 600 700 900 1,100 C 700 500 700 850 Because the...
Here is an operations planning case analysis. You are expected to do the following questions and submit them for marking at the end of the semester via utsonline and in hard copy to your tutor in week 10. A company has the following demand forecast next year, expressed in six bimonthly periods: Forecast Demand: Period 1 = 4,500 units Period 4 = 6,500 units Period 2 = 3,000 units Period 5 = 5,100 units Period 3 = 4,800 units Period...
Problem 2-53 (Algorithmic) Management of High Tech Services (HTS) would like to develop a model that will help allocate its technicians' time between service calls to regular contract customers and new customers. A maximum of 90 hours of technician time is available over the two-week planning period. To satisfy cash flow requirements, at least $950 in revenue (per technician) must be generated during the two-week period. Technician time for regular customers generates $40 per hour. However, technician time for new...
Wixis Cabinets makes custom wooden cabinets for high-end stereo systems from specialty woods. The company uses a job-order costing system. The capacity of the plant is determined by the capacity of its constraint, which is time on the automated bandsaw that makes finely beveled cuts in wood according to the preprogrammed specifications of each cabinet. The bandsaw can operate up to 181 hours per month. The estimated total manufacturing overhead cost at capacity is $14,842 per month. The company bases...
Medisan Inc. has just signed a contract to supply walky-talkiesto the Turkish Armed Forces. During the next four months, the firm must deliver 150 in December, 160 in January, 225 in February and 180 in March. Medisan’s factory in Temelli can produce walky-talkies at a cost of $20 per unit (labor cost is not included). To produce a walky-talky 10 hours of labor are required and there are 10 workers available at the plant at the beginning of December. Each...
Problem 4-19 (Algorithmic) The Silver Star Bicycle Company will be manufacturing both men’s and women’s models of its Easy-Pedal 10-speed bicycles during the next two months. Management wants to develop a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men’s and 125 women’s models to be shipped during the first month and 220 men’s and 170 women’s models to be shipped during the second month. Additional data...