Worksheet $1$

$$

Additional Questions for Learning Objective $3$

For the students:

One of the quickest moving products has a lead time of $21$ days.$$ Demand during this period averages $100$ units per day and safety stock is set at $2$ times the average demand.

a$)$ What would be the appropriate reorder point?

b$)$ How does your answer change if demand during the lead time doubles?

c$)$ How does your answer change if demand during the lead time drops to half?

give the answer in excel sheet