CELLWRIGHTOperator-grade spreadsheets & automation packs

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.

1 · Demand

2 · Supplier lead time

3 · Stock & service level

4 · Order economics

Results

Reorder point (units)—
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
—

—

Get the 40-SKU Excel Planner — $29

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

  1. z = NORMSINV(service level). 90% → 1.282, 95% → 1.645, 99% → 2.326.
  2. σ of lead-time demand = √(LT × σd² + d² × σLT²) — it covers both demand swings and late suppliers.
  3. Safety stock = z × σ of lead-time demand, rounded up.
  4. Reorder point = d × LT + safety stock, rounded up.
  5. EOQ = √(2 × annual demand × cost per PO ÷ (holding % × unit cost)).
  6. Suggested order (only when on hand + on order ≤ reorder point) = MAX(MOQ, reorder point + EOQ − inventory position), rounded up to a full case.
  7. 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.

Reorder point: — · see results ↓