Question: Please help complete the aggregate plan! *I don't know if the numbers in the boxes are correct* *I just guessed* *please show all steps, thank


Please help complete the aggregate plan!
*I don't know if the numbers in the boxes are correct* *I just guessed* *please show all steps, thank you!*
Problem 11-4 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: Period Forecast 1 200 2 200 3 300 4 400 5 500 6 200 Total 1,800 Costs Output Regular time Overtime Subcontract Inventory Back orders $ 5 per skateboard $ 7 per skateboard = $ 7 per skateboard = $ 7 per skateboard per period on average inventory = $ 3 per skateboard per period 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 **" wherever required. Omit the "S" sign in your response.) 280 units per period. Prepare a plan that muzes 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. Loave no cells blank - be certain to enter "o" wherever required. Omit the "S" sign in your response) 1 2 3 4 5 6 Total 1.800 200 200 300 400 500 200 280 280 280 280 250 280 1.580 Period Forecast Output Regular Subcontract Output Forecast Inventory Beginning Ending Average Backlog 1,400 1,400 1,400 1,400 1,400 1,400 8.400 Costs: Regular Subcontract Inventory Backorder Total te 03 16.2012 03 30 2013_OC 35471 References Worksheet Problem 11-4 Learning Objective: 11-04 Prepare aggregate plans and compute theirStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
