Skip to content

Guide

Reorder point and safety stock: when to reorder and how much

A reorder point tells you when to order a product again, and safety stock is the extra you hold in case sales run faster or the supplier runs late. Here are the formulas, worked through on one product, with the spreadsheet functions that do the sums and how to decide how much to order.

Updated 19 November 2026 · 6 minute read · General information, not advice for your business

What a reorder point and safety stock are

Business.gov.au describes a reorder point as the smallest amount of each item you want in stock before you order more. Set it right and a new delivery lands just as the shelf gets low. Set it too low and you run out while you wait; set it too high and cash sits on the shelf.

The reorder point has two parts. The first covers the sales you expect while you wait for the supplier, which is the lead time. The second is safety stock, a buffer for the weeks when sales are higher than usual or the delivery comes late.

The reorder point formula

Reorder point
Sales during the lead time
average daily sales × lead time in days
Reorder point
sales during the lead time + safety stock

Take a product that sells an average of 12 units a day, from a supplier that takes 10 days to deliver. You expect to sell 12 × 10 = 120 units while you wait. With no safety stock the reorder point is 120, and any day busier than average means running out before the delivery arrives.

Microsoft's own setup advice for its Business Central planning software uses the same idea: if an item's average demand over a seven-day lead time is 100 units, the reorder point can be set to 100 as a minimum. The safety stock goes on top of that.

Two ways to work out safety stock

From your busiest day and longest wait

The simplest method needs only your records. Take the most you have sold in a day and the longest the supplier has taken to deliver, and subtract what you expect on an average day and an average delivery.

Busiest day and longest wait
Most sold in a day × longest lead time: 20 × 14
280
Average daily sales × average lead time: 12 × 10
120
Safety stock: 280 − 120
160
Reorder point: 120 + 160
280

Easy to work out and easy to explain. It assumes your busiest day and longest delay happen together, so it usually holds more stock than you need.

From how much sales vary (a service level)

The second method uses how much daily sales move around their average, measured as a standard deviation, and a service level: the share of deliveries you want to arrive before the shelf runs empty. It assumes daily sales vary the way they have in the past, independently from one day to the next.

Safety stock from a service level
Safety stock
Z × standard deviation of daily sales × √lead time
Z for a 95% service level
1.645
Standard deviation of daily sales
4 units
1.645 × 4 × √10
20.8, so 21 units
Reorder point: 120 + 21
141

Same product as above. Measuring how much sales really vary gives a far smaller buffer than assuming the worst day and the worst delay at once.

Service level and its Z figure
Service levelZIn Excel
90%1.282=NORM.S.INV(0.90)
95%1.645=NORM.S.INV(0.95)
97.5%1.960=NORM.S.INV(0.975)
99%2.326=NORM.S.INV(0.99)
Each step up in service level costs more stock than the one before. A higher level suits the lines customers will not wait for; a lower one can suit slow, costly lines.

When the supplier's lead time varies too

If deliveries arrive anywhere from 8 to 12 days after you order, that spread needs a buffer of its own. The fuller formula adds the variation in lead time to the variation in sales.

Safety stock when both sales and lead time vary
Safety stock
Z × √(lead time × sales SD² + daily sales² × lead time SD²)
Standard deviation of the lead time
2 days
1.645 × √(10 × 4² + 12² × 2²)
1.645 × √736
Safety stock
44.6, so 45 units

SD means standard deviation. Two days of uncertainty in delivery more than doubles the buffer from the example above, which is why a supplier who delivers on time is worth paying attention to.

How much to order

The reorder point tells you when. How much depends on how often you place orders. A common way is to order enough to cover the lead time and the days until your next order, plus the safety stock, less what you already have on hand and on order.

Ordering once a week
Cover needed: 12 a day × (10 days lead time + 7 days to the next order)
204
Plus safety stock
21
Less stock on hand and on order
141
Order
84 units

Round up to the supplier's carton or pallet size and check any minimum order. A larger order at a better price can be worth it, as long as you count the cash it ties up.

Working it out in a spreadsheet

With 90 days of daily sales for one product in B2:B91 and its lead time in days in E2, these Excel formulas give the figures above, one cell at a time. They work the same way in Google Sheets.

  • Average daily sales, in F2: =AVERAGE(B2:B91)
  • Standard deviation of daily sales, in G2: =STDEV.S(B2:B91)
  • Safety stock at 95%, in H2: =NORM.S.INV(0.95)*G2*SQRT(E2)
  • Reorder point, in I2: =F2*E2+H2

Count the days a product sold nothing as zeros, or the average comes out too high. Work the figures out again every month or so, and when a supplier or a season changes, because a reorder point set on last year's sales slowly drifts out of date.

When a spreadsheet stops being enough

One sheet per product works for a handful of lines. With hundreds of lines, several suppliers and stock already on order, keeping every figure current by hand becomes a job of its own, and a missed update means a stock-out or a pallet nobody needed. Our guide to turning a spreadsheet into a web app covers the signs.

We build stock and reorder tools for wholesalers that work these figures out for every line from your own sales and lead times and give you one list of what to order each morning. Answer a few questions in the price guide for an estimate.

Questions

What is the difference between a reorder point and safety stock?

Safety stock is the buffer. The reorder point is the level that triggers an order: the sales you expect while you wait for delivery, plus that buffer. If a product sells 12 a day, takes 10 days to arrive and carries 21 units of safety stock, you reorder when stock on hand and on order falls to 141.

What service level should I choose?

It is a business choice. A higher level means fewer stock-outs and more cash on the shelf. A higher level suits lines that sell steadily and that customers will not wait for; a lower one can suit slow or costly lines.

How often should I recalculate reorder points?

Whenever sales or lead times change in a way you notice, and at least every few months. Seasonal products need a separate set of figures for the busy season.

Sources

Find out what yours would cost

Answer a few questions and you get an estimate for a tool built around your business. You don't need to leave an email to see it.

We reply by email within two working days, wherever you are.

Get an estimate