Planners for a company that makes several models of skateboards are about to pre
ID: 452027 • Letter: P
Question
Planners for a company that makes several models of skateboards are about to prepare the aggregate plan that will cover six periods. They have assembled the following information:
They have learned that one person is about to retire from the company. The reduced regular-time output is 280 units per period. Prepare a plan that minimizes cost using subcontracting at a maximum rate of 50 units per period as needed with no overtime. Again, plan for a zero inventory balance at the end of period 6.(Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Omit the "$" sign in your response.)
Planners for a company that makes several models of skateboards are about to prepare the aggregate plan that will cover six periods. They have assembled the following information:
Explanation / Answer
Period 1 2 3 4 5 6 Total Forecast 200.00 200.00 300.00 400.00 500.00 200.00 1800.00 Output Regular 280.00 280.00 280.00 280.00 280.00 280.00 1680.00 Subcontract 20 50 50 0 120.00 Output- 280.00 280.00 300.00 330.00 330.00 280.00 1800.00 output- Forecast 80.00 80.00 0.00 -70.00 -170.00 80.00 0.00 Inventory Beginning 0 80 160 160.00 90.00 -80.00 410.00 Ending 80 160 160.00 90.00 -80.00 0.00 410.00 Average 40 120 160 125 45 0 Backlog -80.00 -80.00 Costs: Regular 1680 1680 1680 1680 1680 1680 10080.00 Subcontract 0 0 140 350 350 0 840.00 Inventory 240 720 960 750 270 0 Backorder -480 Total 1920 2400 2780 2780 2780 1680 14340.00