Average is average of inventory

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 = $ 5 per skateboard Overtime = $ 7 per skateboard Subcontract = $ 10 per skateboard per skateboard per period on average Inventory = $ 5 inventory Back orders = $ 7 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 "O" wherever required. Omit the "$" sign in your response.) 2 200 3 300 4 400 5 500 6 200 Total 1,800 200 Period Forecast Output Regular Subcontract Output- Forecast Inventory Beginning Ending Average Backlog $ $ Costs: Regular Subcontract Inventory Backorder Total $ 5 IM $