Aggregate Planning and Cost Minimization for Furniture Production: A Case Study of Wormwood, Ltd

Analysis of cost-effective production planning in the furniture industry.

David Rodriguez
Contributor
4.8
58
6 months ago
Preview (2 of 3 Pages)
100%
Purchase to unlock

Page 1

Aggregate Planning and Cost Minimization for Furniture Production: A Case Study of Wormwood, Ltd - Page 1 preview image

Loading page ...

award:10 out of10.00pointsAggregate Planning and Cost Minimization for Furniture Production: A Case Study of Wormwood, LtdProblem11-9Wormwood, Ltd., produces a variety of furniture products. The planning committee wants to prepare anaggregate plan for the next six months using the following information:MONTH123456Demand160150160180170140CapacityRegular150150150150160160Overtime10100101010Cost Per UnitRegulartime$50Overtime75Subcontract80Inventory,perperiod4Subcontracting can handle a maximum of 10 units per month. Beginning inventory is zero. Develop a planthat minimizes total cost. No back orders are allowed.(Negative amounts should be indicated by aminus sign. Leave no cells blank-be certain to enter "0" wherever required. Omit the "$" sign inyour response.)PeriodForecastOutputRegular116015021501503160150418015051701606140160Total960920OvertimeSubcontract01001010010100100102050Output-Forecast0100-1003030InventoryBeginning00101000Ending010100030Average0510501535Backlog0000000Costs:Regular$7,5007,5007,5007,5008,0008,000$46,000Overtime75075007507507503,750Subcontract00800800001,600Inventory0204020060140Backlog0000000Total$8,2508,2708,3409,0708,7508,810$51,490

Page 2

Preview Mode

This document has 3 pages. Sign in to access the full document!

Study Now!

XY-Copilot AI
Unlimited Access
Secure Payment
Instant Access
24/7 Support
Document Chat

Document Details

Related Documents

View all