reorder point formula excel safety stock

mand: 100 units Standard deviation of daily demand: 15 units Lead time: 7 days Lead time standard deviation: 1.5 days Desired service level: 99% Step-by-Step Calculation Calculate Z-score for 99% service level: =NORM.S.INV(0.99) ≈ 2.33 C