Reorder Point & Safety Stock Calculator
Demand + lead time + how much both swing + the service level you want → safety stock, reorder point, how much to order and the date you must order by. Free, no sign-up, nothing leaves your browser.
Results
- Safety stock
- —
- z (from service level)
- —
- σ of lead-time demand
- —
- Lead-time demand
- —
- Inventory position
- —
- Days of cover
- —
- Stock-out date (no reorder)
- —
- Order-by date
- —
- EOQ
- —
- Suggested order (MOQ + case)
- —
- Order value
- —
- Cash in safety stock
- —
—
26 weeks of sales → demand σ calculated for you · per-SKU service levels · safety stock, ROP, EOQ, MOQ + case rounding · STOCKOUT / ORDER NOW / WATCH / OVERSTOCK flags · ABC · purchase orders per supplier · service level vs cash · dashboard · bonus n8n low-stock email alerts. Excel + Google Sheets.
Or grab the free 1-tab Excel version ($0+) →How the calculation works
- z = NORMSINV(service level). 90% → 1.282, 95% → 1.645, 99% → 2.326.
- σ of lead-time demand = √(LT × σd² + d² × σLT²) — it covers both demand swings and late suppliers.
- Safety stock = z × σ of lead-time demand, rounded up.
- Reorder point = d × LT + safety stock, rounded up.
- EOQ = √(2 × annual demand × cost per PO ÷ (holding % × unit cost)).
- Suggested order (only when on hand + on order ≤ reorder point) = MAX(MOQ, reorder point + EOQ − inventory position), rounded up to a full case.
- Order-by date = today + (inventory position − reorder point) ÷ d.
Worked example
A cutting-board set sells 13.6 units a day with a daily standard deviation of 4.2. The supplier quotes 45 days, give or take 10. At a 95% service level z = 1.645, so σ of lead-time demand = √(45 × 4.2² + 13.6² × 10²) = 138.9 and safety stock is 229 units. Lead-time demand is 612, so the reorder point is 841. With 820 on hand and nothing on order you are already below it: EOQ is 718, so order 841 + 718 − 820 = 739, rounded up to a 20-unit case = 740 units ($4,847) today. Notice that lead-time variability, not demand noise, drives most of that safety stock.
Where a single-SKU calculator stops
Want the formulas explained step by step, with Excel and Google Sheets versions? Read the safety stock and reorder point formula guide.
A real catalogue has 20–200 SKUs from several suppliers. The Cellwright Reorder Point & Safety Stock Planner calculates demand mean and variability from 26 weeks of sales for 40 SKUs, applies per-SKU service levels, flags every SKU as STOCKOUT, BELOW SAFETY, ORDER NOW, WATCH or OVERSTOCK, ranks them ABC, drafts a purchase order per supplier and shows what each extra point of service costs in cash. A bonus n8n pack emails you when something needs ordering.
FAQ
What is a reorder point?
The stock level at which you place the next purchase order so the new stock arrives before you run out: expected demand over the lead time plus safety stock. Compare it with on hand + on order (inventory position), not on hand alone.
Which safety stock formula is this?
The combined demand and lead-time variability formula (sometimes called the King formula): z × √(LT × σd² + d² × σLT²). If your supplier is perfectly reliable (σLT = 0) it reduces to z × σd × √LT.
What service level should I choose?
95% is a common default; 98–99% for best sellers and items where a stock-out loses the customer. Going from 95% to 99% raises safety stock by about 41% (2.326 ÷ 1.645).
Does this work for slow or lumpy items?
The formula assumes demand is roughly normal. For SKUs that sell a few units a month or in irregular bulk orders, use a manual minimum based on your largest likely order instead.
Importing stock? Work out your true cost per unit with the free Landed Cost & Tariff Calculator.