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
- 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.
- 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
- 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 | Z | In 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) |
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
- 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.
- 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.