How to use the safety stock and reorder point calculator
Waiting until the shelf is empty to place an order is already too late, because demand keeps running during the supplier lead time. The reorder point is the stock level that covers that lead time demand, and safety stock is the cushion that absorbs the days when demand runs hot. Enter average daily demand, the standard deviation of daily demand, lead time, and a target service level to get both numbers.
Safety stock equals the service factor Z multiplied by the daily standard deviation and the square root of lead time. The square root appears because independent daily variations add as variances rather than as straight sums. The reorder point is that cushion plus the average demand expected during lead time.
Raising the service level raises Z and therefore inventory. The common factors are 1.28 at 90 percent, 1.65 at 95 percent, 2.33 at 99 percent, and 3.09 at 99.9 percent, so moving from 95 to 99.9 percent roughly doubles safety stock. Applying high service levels only to items where a stockout really hurts is what keeps total inventory value under control.
Calculate the standard deviation from three to six months of daily shipments, and handle promotional spikes separately so a single unusual week does not inflate the cushion for the whole year.
Frequently asked questions
Critical items where a stockout is expensive often run at 97.5 to 99 percent, while easily substituted items sit at 90 to 95 percent. Going to 99.9 percent nearly doubles safety stock, so set it item by item.
Pull daily shipment quantities for the last three to six months and apply a standard deviation function in your spreadsheet. Strip out promotions and one-off bulk orders first, or the figure comes out inflated.
This calculator uses the basic model that treats lead time as fixed. When lead time swings, either enter your recent worst-case lead time to stay conservative or move to the extended formula that includes lead time variability.