Free calculators

Reorder point calculator with safety stock

When to reorder: expected demand over the lead time plus a safety stock that covers variable demand and variable lead time at the service level you choose. Free, in the browser, no sign-up.

The reorder point is expected demand over the lead time plus safety stock: ROP = d × L + z × σLT. With the defaults below, 1,840 units a week on a six-week lead time, both variable, at a 98 per cent cycle service level, the safety stock is 7,547 and the reorder point is 18,587 units. Compare it with stock on hand plus stock on order, not with stock on hand alone.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
Expected demand over the lead time11,040
Standard deviation of demand over the lead time3,674.6
z at the service level2.0537
Safety stock7,547
Reorder point18,587

Runs in your browser: nothing you type is sent anywhere.

Using this for a real deal?

The formula

σLT = √(L × σd² + d² × σL²)

Safety stock = z × σLT, with z = NORM.S.INV(service level)

Reorder point = d × L + safety stock

In Excel: =d*L+NORM.S.INV(SL)*SQRT(L*sd^2+d^2*sL^2)

How it works

Use the same period throughout: weekly demand with a lead time in weeks, or daily demand with days. Set the lead time deviation to zero if the supplier is reliable; on the default part the lead time, not demand, creates nine tenths of the variance, which is why the safety stock is so large.

When the lead time is longer than the time between orders, several orders are open at once. The reorder point must then be compared with inventory position (on hand plus on order minus backorders), or it triggers too many orders.

Go further with the worked example, step by step, the free Excel template and the companion files for Supply Chain Management.

Embed this calculator

Free to embed on your website, blog or intranet, with no sign-up and no tracking. Copy the code below and paste it into any HTML block; the calculator resizes itself to fit.

Preview the embedded version

Questions people ask

How do you calculate a reorder point?

Multiply average demand per period by the lead time in periods and add safety stock. With 1,840 units a week, a six-week lead time and 7,547 units of safety stock, the reorder point is 18,587.

How do you calculate safety stock when lead time varies?

Combine both sources of variance: the standard deviation over the lead time is the square root of (lead time × demand variance + demand squared × lead time variance), then multiply by z for the service level.

What z-score should I use?

NORM.S.INV of the cycle service level: 1.6449 for 95 per cent, 2.0537 for 98 per cent, 2.3263 for 99 per cent. Each extra point of service costs more stock than the last.

The book behind this calculator

This calculator comes from Supply Chain Management by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.

Get the book on Amazon → DRM-free PDF edition, $19.99

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.

Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →

All free calculators → · Free Excel templates →