Free calculators

Safety stock calculator

Safety stock when demand and lead time both vary, the demand-only figure for comparison, and how much of the buffer the supplier’s lead time creates. Free, in the browser, no sign-up.

When both demand and lead time vary, safety stock is z × √(L × σd² + d² × σL²): the variances add, not the standard deviations. With the defaults below, a part selling 1,840 units a week with a standard deviation of 462, on a six-week lead time that varies by 1.9 weeks, needs 7,547 units of safety stock at a 98 per cent cycle service level. The demand-only formula gives 2,324.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
z at the service level2.0537
Safety stock, demand and lead time variable7,547
Safety stock if lead time were fixed2,324
Share of variance from lead time90.52%
Reorder point18,587
Value of the safety stock215,844

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

Using this for a real deal?

The formula

Safety stock = z × √(L × σd² + d² × σL²)

z = NORM.S.INV(service level). In Excel: =NORM.S.INV(B6)*SQRT(B3*B2^2+B1^2*B4^2)

How it works

Demand and lead time must be in the same unit: weekly demand with a lead time in days is the most common way this formula produces nonsense. In the default case 90.5 per cent of the variance comes from the supplier, so shortening or stabilising the lead time is worth far more stock than a better demand forecast.

Use the reorder point calculator for when to order: reorder point calculator.

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

What is the safety stock formula?

With demand and lead time both variable: z × square root of (lead time × demand variance + demand squared × lead time variance). With lead time fixed, the second term drops out.

Why is my safety stock so high?

Usually because of lead time variability. In the default case 1.9 weeks of lead time variation creates nine tenths of the variance and more than triples the buffer against the demand-only formula.

What service level should I use?

A cycle service level is the probability of no stockout in a replenishment cycle. Each extra point costs more stock than the last: compare 95, 98 and 99 per cent in the calculator.

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 →