Develop an aggregate plan and input all values below you

Question

Consider the following scenario:
Period	Forecast demand	Description	Cost	Max. Capacity
1	2000	Regular time:	$17/unit	2200/period
2	1900	Overtime	$29/unit	500/period
3	2500	Subcontracting	*NONE AVAIL*
4	3000	Beginning inventory	*NONE*
5	2800	Holding cost of inventory	$4/unit/period
6	2500	Backorder cost	$9/unit/period
Develop an aggregate plan and input all values below (you may use formulas as you wish):
You MUST end period 6 with no inventory and no backorders and the object is to minimize total cost.
Period	Forecast demand	Planned production Qty	Reg time cost	OT cost	Ending Inv. Qty	Backorder Qty	Total Cost
1	2000
2	1900
3	2500
4	3000
5	2800
6	2500
Total cost, periods 1-6: