Use the $50-$day Hypothetical Demand Data $($in the table below$)$ and the other Hypothetical data included here:

Hypothetical Data:

Assume $365$ days per year.

Use the Hypothetical Demand Data below, not the actual demand data in the simulation.

Assume that management considers physical cost of holding inventory negligible compared to the financial costs.

Assume that Littlefield earns $7$ percent interest on all cash balances $($annual interest rate, compounded daily$),$ so cash spent on materials purchases represents a financial opportunity cost.

Assume that material costs are $$12$ per kit.

Assume that Littlefield incurs $$1,300$ in fixed administrative costs each time an order is placed.

Assume a supplier lead time of $5$ days.

Assume a service level of $88\%.$

Use the normsinv function in Excel to get the correct z$-$value.

Use the stdev.s function in Excel for the standard deviation calculation.

Make sure your answers are in kits. For this hypothetical exercise, assume that one batch consists of $65$ kits and that one order requires $65$ kits.