The aggregate planning template below is almost entirely complete, but is missing a few calculations designated by yellow shaded boxes. After making the missing calculations, determine the grand total cost of the aggregate plan, designated by the red shaded box. Costs: Output Regular time: Overtime: 600 $2/unit $6/unit Regular production output: Overtime production output: Inventory carrying cost: $1/unit Average inventory = (beginning inventory + ending inventory)/2 Subcontracting: $6/unit Backorders: $5/unit/month Aggregate Planning Policy: 3 4 5 1 600 2 400 6 200 Total 1500 800 450 550 Month Forecast Output: Regular time Overtime Subcontract Output - Forecast 600 600 600 600 600 600 1500 0 200 -200 150 50 400 0 200 Inventory: Beginning Ending Average Backlog 0 0 200 100 0 100 0 150 75 150 200 175 200 400 300 0 $1200 Output Cost: Regular Time Overtime Subcontract Inventory Cost $0 $0 $0 $0 $0 $100 $1200 $0 $0 $100 $1200 $0 $0 $75 $1200 SO $0 $1200 $o SO $300 Saved Costs: Output Regular time: Overtime: 600 $2/unit $6/unit Regular production output: Overtime production output: Inventory carrying cost: $1/unit Average inventory = (beginning inventory + ending inventory)/2 Subcontracting: $6/unit Backorders: $5/unit/month Aggregate Planning Policy: 3 1 600 2 400 4 450 5 550 6 200 Total 1500 800 Month Forecast Output: Regular time Overtime Subcontract Output - Forecast 600 600 600 600 600 600 1500 0 200 -200 150 50 400 Inventory: Beginning Ending Average Backlog 0 0 0 0 200 100 200 0 100 0 150 75 150 200 175 200 400 300 $0 Output Cost: Regular Time Overtime Subcontract Inventory Cost Backorder Cost $1200 $0 $0 $100 $1200 $0 $0 $100 $1200 $0 $0 $75 $1200 $0 $0 $0 $1200 $0 $0 $300 $0 Total Cost