Kindly, explaining is needed via solving it manually and in excel :

Solve this Aggregate Planning Problem by minimizing the cost of mathcing the capacity vaious options in various periods to the future demand?

Find inventory cost, regular time cost, overtime cosr and subcontract cost, and the total cost?

	Sales Period
	Mar	Apr	May
Demand	700	700	1100
Capacity:
Regular Time	700	700	700
OverTime	100	100	100
Subcontracting	200	200	100
Begening inventory is zero	0

	Cost
Regular Time	$50	per tire
OverTime	$60	per tire
Subcontracting	$80	per tire
Carrying Cost	$5	per tire per month

Answer

		Demand
	Supply From	Period 1 ( Mar)	Period 2 ( Apr)	Period 3 ( may)	Unused Capacity ( Dummy)
	Beginning Inventory	0
Period 1	Regular Time	700	200
	OverTime
	Subcontracting
Period 2	Regular Time
	OverTime
	Subcontracting
Period 3	Regular Time
	OverTime
	Subcontracting
Total Demand

	PERIOD 1	PERIOD 3	PERIOD 3
Inventoy Cost
Regular Time Cost
Overtime Cost
Subcontracting
Total