Problem $2.$ Consider a scenario where the anticipated demand for SKU $1996-00785-7777$ occurs over a limited time horizon. You are tasked to determine the best replenishment schedule $-$ that is$,$ what are the order quantities and in what periods should the orders be placed.

Answer the next questions, Problem $2$ parts a $-$ d$.$ Attach your Excel file in Problem $2$e$.$

The following information applies:

$$ Item Value $=$$$10$ per unit

Order Cost $=$$$50$ per order

Holding rate $=0\mathrm{.}36\frac{\text{\$}}{\text{\$}}\frac{?}{yr}=0\mathrm{.}03\frac{\text{\$}}{\text{\$}}\frac{?}{\text{m}\text{o}\text{n}\text{t}\text{h}}$