EXCEL SPREAD SHEET

Level Production Strategy

Aggregate Production Plan for the ATV Corporation

Desired End of Year Inventory $160$

Worker hours needed per unit $8$

Worker hours per month $(8$ hrs x $5$ days x $4$ weeks$)160$

Ending Inventory Last December $120$ Formulas

December Inventory Adjustment #N$/$A

Desired Monthly Production #N$/$A

Capacity Needed $($Labor$)$ Capacity Needed $($Labor$)$

Period Forecast Demand $($Units$)*$ Total Forecast Demand $($Units$)**$ Production $($Units$)$ Ending Inventory$/$ Backlog $($Units$)$ Hours Workers Total Forecast Demand $($Units$)**$ Production $($Units$)$ Ending Inventory$/$ Backlog $($Units$)$ Hours Workers

January $180$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

February $160$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

March $380$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

April $520$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

May $600$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

June $720$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

July $840$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

August $720$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

September $540$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

October $600$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

November $340$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

December $360$ #N$/$A #N$/$A #N$/$A #N$/$A #N$/$A

TOTALS $5,960$ #N$/$A #N$/$A #N$/$A #N$/$A

$*$excluding December Inventory Adjustment

$**$including December Inventory Adjustment