D E 1 250 2 300 3 3.80 4 480 5 560 6 TOTAL 250 320 320 320 320 320 320 Demand forecast Output regular time Overtime Subcontracting Output forecast Inventory Beg End Ave. Backorder 0 0 Costs Output regular time Overtime Subcontracting Inventory Backorder Total Given the demand information and the level production plan given in the Excel spreadsheet, prepare an aggregate plan that minimizes the total cost. Regular time production $20 per unit Overtime production $30 per unit Inventory holding cost-$3 per unit per period on average inventory Backorder $10 per unit per period Note that due to the labor union regulations, the overtime limit is 80 units per period. All demand has to be met by the end of the planning horizon. Pease use Excel Solver to find the optimal solution. D E 1 250 2 300 3 3.80 4 480 5 560 6 TOTAL 250 320 320 320 320 320 320 Demand forecast Output regular time Overtime Subcontracting Output forecast Inventory Beg End Ave. Backorder 0 0 Costs Output regular time Overtime Subcontracting Inventory Backorder Total Given the demand information and the level production plan given in the Excel spreadsheet, prepare an aggregate plan that minimizes the total cost. Regular time production $20 per unit Overtime production $30 per unit Inventory holding cost-$3 per unit per period on average inventory Backorder $10 per unit per period Note that due to the labor union regulations, the overtime limit is 80 units per period. All demand has to be met by the end of the planning horizon. Pease use Excel Solver to find the optimal solution