Statistical Reorder Point Using Probabilistic Demand and Constant Delivery Lead Time

Average demand $()500$

Demand Standard deviation $(\backslash$sigma dLT$)50$

Service level $85\%$

Service level alternate $87\%$

Formulas

Z$-$value for service level $1\mathrm{.}04=$NORMSINV$($B$5)$

Z$-$value for service level alternate $1\mathrm{.}13=$NORMSINV$($B$6)$

Required safety stock $52$ units $=$B$4*$B$8$

ROP $25052$ units $=($B$3*$B$4)+$B$11$

Required safety stock alternate $56$ units $=$B$4*$B$9$

Safety stock difference units #N$/$A