Inventory planning

Safety Stock & Reorder Point

Most calculators use the simple formula and quietly under-stock you, because they ignore how much your lead time moves. This one handles both sources of variability — and shows you which one is actually driving your buffer.

Your data never leaves your browser — everything is calculated on your device.

Example inputs and performance bands are illustrative, not industry benchmarks. Confirm assumptions for your site. Method and limitations.

Your numbers

The probability of not stocking out during a replenishment cycle. Going from 95% to 99% roughly doubles the safety stock for the same item.

Demand
Enter a positive number
Enter 0 or more

Use STDEV.S() across daily issues for the last 3–6 months. Exclude one-off bulk orders or they will inflate your buffer permanently.

Lead time
Enter a positive number
Enter 0 or more

From PO release to goods available for picking — including customs, transit and GRN time, not just the supplier's quoted number. Set the deviation to 0 for a genuinely fixed lead time.

Costing (optional)

Holding cost covers capital, storage, insurance, obsolescence and shrinkage. In Indian warehousing 18–25% a year is typical.

Result
Safety stock
 
Reorder point
Demand in lead time
Days of cover
Value held
Annual holding cost
Z factor

Which formula this uses, and why

There are two safety stock formulas in common use, and the difference between them is not academic.

The simple one, which assumes lead time never varies:

SS = Z × σd × √LT

The full one, which accounts for lead time varying too:

SS = Z × √( LT × σd² + d² × σLT² )

This calculator uses the full version. The second term under the root — d² × σLT² — is the part the simple formula throws away, and in Indian supply chains it is frequently the larger of the two. A part with steady demand but a lead time that swings between 14 and 35 days needs a buffer driven almost entirely by the lead time, not by the demand.

Check the split before you argue about demand forecasts

The result panel shows how much of your buffer comes from demand variability versus lead-time variability. If lead time dominates, no amount of forecasting improvement will help — the fix is supplier reliability, a second source, or a shorter, more predictable transit lane. Teams spend months improving forecasts for items whose problem was never demand.

A worked example

Using the pre-filled figures — a fast-moving part at 120 units a day, standard deviation 34, lead time 21 days with a deviation of 5 days, at 95% service:

  • Demand during lead time = 120 × 21 = 2,520 units
  • Demand-variability term = 21 × 34² = 24,276
  • Lead-time-variability term = 120² × 5² = 360,000
  • Safety stock = 1.645 × √384,276 = 1,020 units
  • Reorder point = 2,520 + 1,020 = 3,540 units

Notice that the lead-time term is roughly fifteen times the demand term. Using the simple formula here would give a safety stock of about 256 units — a quarter of what this part actually needs. That gap is what a stockout looks like three months later, and it is the single most common cause of “but the system said we had enough”.

Common mistakes

  • Using the supplier's quoted lead time. Quoted is not actual. Measure from PO release to stock available for picking, using your own GRN dates. The gap between quoted and actual is usually where the variability lives.
  • Calculating standard deviation on monthly data, then using daily demand. The units must match. If you have monthly figures, either convert everything to months or divide carefully — mixing the two is the most frequent arithmetic error in inventory planning.
  • Applying one service level to the whole catalogue. A 99% target on C-class items ties up enormous capital for almost no service benefit. Classify first, then set service levels by class — the ABC–XYZ classifier does that in one pass.
  • Never recalculating. Safety stock set in 2023 against 2023's lead times is a liability now. Review quarterly, and immediately after any supplier or transport-lane change.
  • Including one-off bulk orders in the deviation. A single dealer stocking order can double your measured standard deviation, and you then carry that inflated buffer for a year. Strip the outliers first, and handle them as project demand instead.

Questions people ask

What service level should I choose?

Work backwards from the cost of a stockout. For a part that stops a customer's machine, 98–99% is easy to justify. For a slow-moving consumable with a substitute on the shelf, 90% is generous. The compare table above shows exactly what each level costs you per year for this item — that number usually settles the argument faster than any policy document.

Does this work for intermittent demand?

Not well. Items that sell on only a handful of days a month break the normal-distribution assumption behind the Z factor. For those, a Croston-style method or a simple min-max based on observed maximum demand in lead time is more honest than a formula that looks precise but isn't. Most spare-parts catalogues have a long tail of these — treat them separately rather than pretending the formula covers them.

Why is my reorder point higher than my maximum stock?

Because your order quantity is too small for the lead time. If the reorder point exceeds the max level, you will be raising a new PO before the last one arrives — which is fine, but it means you need multiple open orders in the pipeline and your system must handle that. If it doesn't, increase the order quantity (see the EOQ calculator) or shorten the lead time.

Get the free KPI starter pack

Blank and invented sample copies, with editable targets and a reporting-month selector. No email required.

Turn this result into an action

Check the assumptions with your team, compare a second scenario, and keep the result in your monthly review.

Explore the matching workbooks · Methods and limitations