Explain in excel. Step by step . Michael Carrigg, Inc., is a disk manufacturer in need of an aggregate plan for July through December. T

Month	Demand
July	400
August	500
September	550
October	700
November	800
December	700

Beginning inventory		150
Labour hours / disk		4	hours
Current workforce june		8	people
Labour hours / disk		4	hours
Workdays/month		20	days

What will each of the two following strategies cost?

Vary the workforce so that production meets demand. Carrigg had eight workers on board in June.

Vary overtime only and use a constant workforce of eight

\begin{tabular}{|l|l|} \hline \multicolumn{2}{|l|}{ Costs } \\ \hline Holding cost & $8/ disk/month \\ \hline Subcontracting & $80/ disk \\ \hline Regular-time labour & $12/ hour \\ \hline Overtime labour & $18/ hour for hours above 8 hours/worker/day \\ \hline Hiring cost & $40/ worker \\ \hline Layoff cost & $80/ worker \\ \hline \end{tabular} Other Data \begin{tabular}{|l|l|} \hline Current workforce (June) & 8 people \\ \hline Labour-hours/disk & 4 hours \\ \hline Workdays/month & 20 days \\ \hline Beginning inventory & 150 disks - ** \\ \hline Ending inventory & 0 disks \\ \hline \end{tabular}