Over the demand forecast shown below and regular time production capacly capped at 280 units per period, management decides to use overtime production as well as inventory and backorders to meet demand Regular time production cost $0 per unit Overtime production cost 510 perunt Inventory holding costs per unit per priod Backorder costs per unit per period The maximum overtime production capacity is $40 units per period. Phase use ExcelSolver to figure out the optimal aggregate planning schedule so that the total cost is minimized Note that your solver prarameter window should be properly defined. 2 1 200 3 350 4 380 5 480 250 6 TOTAL Total 200 1860 5 280 280 280 280 280 280 1680 Demand forecast Output regular time Overtime Subcontracting Output-forecast Inventory Level Beg. CO 21 End. Ave. Backorder 22 24 Output (production cost) 25 regular time 26 Overtime 27 Subcontracting 28 Inventory holding cost 2 Backorder cost 30 Total cost Over the demand forecast shown below and regular time production capacly capped at 280 units per period, management decides to use overtime production as well as inventory and backorders to meet demand Regular time production cost $0 per unit Overtime production cost 510 perunt Inventory holding costs per unit per priod Backorder costs per unit per period The maximum overtime production capacity is $40 units per period. Phase use ExcelSolver to figure out the optimal aggregate planning schedule so that the total cost is minimized Note that your solver prarameter window should be properly defined. 2 1 200 3 350 4 380 5 480 250 6 TOTAL Total 200 1860 5 280 280 280 280 280 280 1680 Demand forecast Output regular time Overtime Subcontracting Output-forecast Inventory Level Beg. CO 21 End. Ave. Backorder 22 24 Output (production cost) 25 regular time 26 Overtime 27 Subcontracting 28 Inventory holding cost 2 Backorder cost 30 Total cost