• Jan 19, 2026 reorder point formula excel safety stock rvice level) For example, for a 95% service level: =NORM.S.INV(0.95) which yields approximately 1.645. Calculating Safety Stock in Excel Assuming demand variability and lead time standard deviation are known: Safety Stock = Z σd √(Lead Time) For example: =Z σd BY Sonya Schmeler