Chapman Pharmaceuticals, a large manufacturer of drugs, has this aggregate demand forecast (in thousands of liters) for a liquid cold medicine:

Month	Demand
January	220
February	90
March	95
April	65
May	15
June	7
July	7
August	11
September	28
October	65
November	115
December	230

The firm has a normal production rate of 70 thousand liters per month, and the initial inventory is 90 thousand liters. Inventory-holding costs are $33 per 1,000 liters per month, regular-time production costs are $380 per 1,000 liters. Overtime costs an additional 25 percent, and undertime costs an additional 13 percent. Assume that there are no lost sales or rate change costs. Use the Agg Plan Level and Agg Plan Chase Excel templates to compute the costs of a level production rate of 70 thousand liters per month and a chase demand production plan. Round all cost values to the nearest cent and all other answers to the nearest whole number. Do not round intermediate calculations. If your answer is zero, enter "0".

Level production plan:

					Cumulative
			Cumulative		Product	Ending	Lost
	Demand		Demand	Production	Availability	Inventory	Sales
Month	(1,000s)		(1,000s)	(1,000s)	(1,000s)	(1,000s)	(1,000s)
January	220
February	90
March	95
April	65
May	15
June	7
July	7
August	11
September	28
October	65
November	115
December	230
Average					Maximum

	Production	Inventory	Lost Sales	Overtime	Undertime	Rate Change
Month	Cost	Cost	Cost	Cost	Cost	Cost
January	$	$	$	$	$	$
February	$	$	$	$	$	$
March	$	$	$	$	$	$
April	$	$	$	$	$	$
May	$	$	$	$	$	$
June	$	$	$	$	$	$
July	$	$	$	$	$	$
August	$	$	$	$	$	$
September	$	$	$	$	$	$
October	$	$	$	$	$	$
November	$	$	$	$	$	$
December	$	$	$	$	$	$
Totals	$	$	$	$	$	$

Total cost: $

					Cumulative
			Cumulative		Product	Ending	Lost
	Demand		Demand	Production	Availability	Inventory	Sales
Month	(1,000s)		(1,000s)	(1,000s)	(1,000s)	(1,000s)	(1,000s)
January	220
February	90
March	95
April	65
May	15
June	7
July	7
August	11
September	28
October	65
November	115
December	230
Average					Maximum

	Production	Inventory	Lost Sales	Overtime	Undertime	Rate Change
Month	Cost	Cost	Cost	Cost	Cost	Cost
January	$	$	$	$	$	$
February	$	$	$	$	$	$
March	$	$	$	$	$	$
April	$	$	$	$	$	$
May	$	$	$	$	$	$
June	$	$	$	$	$	$
July	$	$	$	$	$	$
August	$	$	$	$	$	$
September	$	$	$	$	$	$
October	$	$	$	$	$	$
November	$	$	$	$	$	$
December	$	$	$	$	$	$
Totals	$	$	$	$	$	$