Given the demand forecast (shown below) and regular time production capacity 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=$20 per unit

Overtime production cost =$30 per unit

Inventory holding cost=$1 per unit per priod

Backorder cost=$5 per unit per period

The maximum overtime production capacity is $40 units per period. Please use Excel Solver 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.

K M N Instruction One subito dopo UD Please wames of the opinbers who way work on the theme on your few is the corrente during your son Due 1100 of Oct 28 Acceptable bon fonat Given the cound forecast (shown below and putine product cated 30 units per perioden decides to severe profection as well as inventory and backorder to meet dead 4 Regulatime production cost per un Overtime production cost $0 perunt 6 Inventory holding cost period Bade cost per un period Thema meetme production is $40 units per period. Please use Desolver to figure out the optimal repte porting the so that the total cost is minimized 9 Note that your sover printer window should be pro | to 11 1 2 3 4 5 6 TOTAL Total 12 Demand forecast 200 250 350 380 480 200 1860 1 Output 14 regular time 280 280 280 280 280 280 1680 Overtime Subcontracting 22 Output-forecast 1 Inventory Level 19 Beg 20 End. 21 Ave. 22 Backorder 24 Output (production cost) 15 regular time 10 Overtime Subcontracting > Inventory holding cost 2 Backorder cost 30 Total cost 4 1 200 2 250 3 350 5 480 6 TOTAL 200 Total 1860 380 280 280 280 280 280 280 1680 16 19 11 12 Demand forecast 11 Output 14 regular time 15 Overtime Subcontracting -> Output-forecast 18 Inventory Level Beg End. Ave. 22 Backorder 24 Output (production cost) regular time Overtime 27 Subcontracting 28 Inventory holding cost 29 Backorder cost 30 Total cost 20 21 25 26 31