Using the safety stock example data, see if you can calculate the lead$-$time$-$demand required to set the size of a Kanban bin.

Demand Order Lead Time

$215$

$22$

$17$

$18$

$25$

$183$

$18$

$17$

$17$

$21$

$233$

$22$

$21$

$17$

$20$

$225$

$24$

$21$

$20$

$16$

$174$

$22$

$20$

$20$

$19$

$196$

$19$

$23$

$16$

$20$

Step $1$: Use the values below to calculate the EOQ, Order Cost, Holding Cost, and Total Cost $($hint: your quantity to calculate the costs should be the EQQ$)$:

Product A Product B Product C Product D Product E

D $75000100002000045000100000$

V $$20$ $$50$ $$8000$ $$4$ $$62\mathrm{.}50$

O $$30$ $$80$ $$300$ $$40$ $$200$

C $22\mathrm{.}5\%20\%15\%22\mathrm{.}5\%25\%$

Product A Product B Product C Product D Product E

Demand Order Lead Time Demand Order Lead Time Demand Order Lead Time Demand Order Lead Time Demand Order Lead Time

$96310741647168821711$

$9894156200190$

$10398161194184$

$97100155177196$

$10495152172185$

$96310641557195820811$

$103102153193196$

$103104150191199$

$10395151182219$

$10390158181204$

$993107415971611021511$

$103103154189182$

$10090159171212$

$105104155174196$

$96103154163181$

$97210341628195920013$

$10392158190210$

$10094164178213$

$102108158198209$

$100104154166208$

$97210051626187819110$

$9994159166216$

$9593152186199$

$99106163167188$

$102102150172183$

$1052102415361821021913$

$10094154176217$

$9693153169205$

$10193152166219$

$9897150187202$

Step $2$: Use the values below to calculate safety stock:Step $3$: Use the values above $($from the Safety Stock Assignment$)$ to calculate lead$-$time$-$demand:

Step $4$: Once you have made all those calculations, save your answers in a convenient place and you have all the answers to the quiz questions.

$1.$

Question $1$

For Product A$,$ what is the Total Cost $($of holding and ordering inventory$)?($please enter it in the following format xxx$,$ xxxx$,$ or xxxxx$)$

$1$ point

$2.$

Question $2$

For Product B$,$ what is the EOQ? $($please enter it in the following format xxx$,$ xxxx$,$ or xxxxx$)$

$1$ point

$3.$

Question $3$

For product C$,$ what is the Total Cost $($of holding and ordering inventory$)?($please enter it in the following format xxx$,$ xxxx$,$ or xxxxx$)$

$1$ point

$4.$

Question $4$

For product D$,$ what is the EOQ? $($please enter it in the following format xxx$,$ xxxx$,$ or xxxxx$)$

$1$ point

$5.$

Question $5$

For product E$,$ what is the EOQ? $($please enter it in the following format xxx$,$ xxxx$,$ or xxxxx$)$

$1$ point

$6.$

Question $6$

For Product A$,$ what is the safety stock you would hold if you wanted to reach a $99\%$ fill rate? $($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$

$1$ point

$7.$

Question $7$

For Product B$,$ what is the safety stock you would hold if you wanted to reach a $97\mathrm{.}5\%$ fill rate? $($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$

$1$ point

$8.$

Question $8$

For Product C$,$ what is the combined standard deviation of lead time and demand? $($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$

$1$ point

$9.$

Question $9$

For Product D$,$ what is the safety stock you would hold if you wanted to reach a $95\%$ fill rate? $($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$

$1$ point

$10.$

For Product E$,$ what is the combined standard deviation of lead time and demand? $($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$

$11.$

For Product A$,$ how large should the Kanban bin be$?($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$

$12.$

For Product B$,$ how large should the Kanban bin be$?($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$

$13.$

For Product C$,$ how large should the Kanban bin be$?($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$

$14.$

For Product D$,$ how large should the Kanban bin be$?($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$

$15.$

Question $15$

For Product E$,$ how large should the Kanban bin be$?($rounded to the nearest integer, e$.$g$.$ xx$.$xx$-->$xx$)$