Question

Solve this Aggregate Planning Problem by minimizing the cost of matching the capacity various options in various periods to the future demand? Find inventory cost, regular time cost, overtime cost and subcontract cost, and the total cost? Sales Period Mar Apr May Pemand 700 1000 1100 Capacity: Regular Time 1000 800 800 Overtime 100 100 100 200 200 100 Subcontracting Beginning inventory is zero O Cost Regular Time Overtime $20 per tire $30 per tire $50 per tire $2 per tire per month Subcontracting Carrying Cost Matching Capacity to Demand Period 1 Period 2 Period 3 Period 1 Regular Time 700 - 200 100 Over Time Subcontract Period 2 Regular Time 800 Over Time 100 Subcontract Regular Time Period 3 800 Over Time 100 Subcontract
cheek the answer plz

Answer 1

	Period 1	Period 2	Period 3	Excess Capacity	Row Total
Beginning inventory	0	0	0	0	0
Period 1 reg time	700	100	200	0	1000
Period 1 overtime	0	0	0	100	100
Period 1 subcontracting	0	0	0	200	200
Period 2 reg time	0	800	0	0	800
Period 2 overtime	0	100	0	0	100
Period 2 subcontracting	0	0	0	200	200
Period 3 reg time	0	0	800	0	800
Period 3 overtime	0	0	100	0	100
Period 3 subcontracting	0	0	0	100	100
Column Total	700	1000	1100	600	3400
Total Cost	59000

Regular time cost = 700*20+100*22+200*24+800*20+800*20=53000

Overtime cost = (100+100)*30= 6000

Total subcontracting cost = 0

Please rate me

Thanks