Question $2$

A$.(5$ points$)$ Using the inputs from Question $1,$ increase the desired inventory fill$-$rate to $97\backslash \%,$ recalculate the inputs, performance measures, cost measures, and inventory policy settings $($including the EOQ$).$

B$.(5$ points$)$ Assuming On$-$hand at the end of Week $1$ is $320$ bags of kitty litter, and the weekly demand from the inputs in question $2$A$,$ create a table for Weeks $1-15$ showing Demand, Onhand, Scheduled Receipts, Inventory Position, and orders $(\backslash ($ Q $\backslash )),$ based on the ROP $+$ SS you calculated in question $2$A$.$

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline F & G & H & I & J & K $\backslash \backslash$

$\backslash$hline Week & Demand & On Hand & $\backslash$begin$\{$tabular$\}\{$l$\}$

Scheduled $\backslash \backslash$

Receipts

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Inventory $\backslash \backslash$

Position

$\backslash$end$\{$tabular$\}$ & Q $\backslash \backslash$

$\backslash$hline Week $01$ & & & & & $\backslash \backslash$

$\backslash$hline Week $02$ & & & & & $\backslash \backslash$

$\backslash$hline Week $03$ & & & & & $\backslash \backslash$

$\backslash$hline Week $04$ & & & & & $\backslash \backslash$

$\backslash$hline Week $05$ & & & & & $\backslash \backslash$

$\backslash$hline Week $06$ & & & & & $\backslash \backslash$

$\backslash$hline Week $07$ & & & & & $\backslash \backslash$

$\backslash$hline Week $08$ & & & & & $\backslash \backslash$

$\backslash$hline Week $09$ & & & & & $\backslash \backslash$

$\backslash$hline Week $10$ & & & & & $\backslash \backslash$

$\backslash$hline Week $11$ & & & & & $\backslash \backslash$

$\backslash$hline Week $12$ & & & & & $\backslash \backslash$

$\backslash$hline Week $13$ & & & & & $\backslash \backslash$

$\backslash$hline Week $14$ & & & & & $\backslash \backslash$

$\backslash$hline Week $15$ & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

C$.(5$ points$)$ Graph the On$-$hand and Inventory position values for the $15$ weeks in question $2$B$.$ Also create and label two horizontal lines representing the approximate positions of the ROP $+$ SS and SS values across the $15$ weeks.