Apply the three strategies $($Chase$,$ Level, Mix$)$ to determine which is the most appropriate

for this case. On each strategy write the assumptions you have made if that is the case.

$3.$ Determine the Total Cost for each of the six$-$month periods. Include material and labor.

Consider Hiring and Lay Off Costs, inventory costs, and write any assumption$($s$)$ you may

need to make.

$4.$ Use Excel Spreadsheet to Determine the Total Cost for the entire six$-$month period.

$5.$ Make a comparison chart with the Total cost per each strategy.

$6.$ Write the group comments regarding the results and if you made assumptions.

Due Date : Sunday March $24$th$,2024$

Information:

Materials : $ $5/$ unit.

Holding cost : $ $1/$unit per month.

Stock Out cost : $ $1\mathrm{.}25/$unit per month.

Hiring and training cost : $ $500\mathrm{.}00/$worker$.$

Layoff costs : $$650/$worker$.$

Labor hours required : $0\mathrm{.}15$ hrs$/$unit$.$

Labor Cost : $ $20\mathrm{.}00/$hour$.$

Beginning Inventory : $250$ units

Productive hours$/$worker$/$day : $7\mathrm{.}25$

Paid straight hrs$/$day : $8$

Beginning workforce level : $7$ employees

Number of Working Days : January $22$ days, February $19$ days, March $21$ days, April $21$ days, May $22$

days, June $20$ days.