How to work out when to reorder stock
Order too late and you run out. Order too early and your money sits on a shelf. The reorder point is the stock level that tells you when to place the next order, and it takes two numbers and one small sum to work out.
The idea in one sentence
You need to reorder while you still have enough stock to keep selling until the new delivery arrives, plus a little extra in case things go wrong.
Reorder point = (average daily sales × lead time in days) + safety stock
When the amount in stock falls to this number, place the order.
The three inputs
Average daily sales
Count how many units of the item you sold over a recent period and divide by the number of days. Ninety days is a sensible period for most items: long enough to smooth out a quiet week, short enough to reflect how the item sells now.
For example, 360 units sold in the last 90 days is 360 divided by 90, which is 4 units a day.
Lead time
Lead time is the number of days between placing an order with your supplier and having the stock ready to sell. Count all of it: the supplier's processing time, the delivery, and the time you need to unpack and check it. Use what really happened on your last few orders, not what the supplier's website promises.
Safety stock
Safety stock is a buffer. It covers a busy week or a late delivery. Without it, the reorder point only works if sales and deliveries are exactly average, and they rarely are.
A worked example
You sell 4 units a day on average. Your supplier takes 7 days. You want 10 units of safety stock.
- Stock sold while you wait: 4 × 7 = 28 units
- Add the safety stock: 28 + 10 = 38 units
Your reorder point is 38. When stock falls to 38 units, order. If everything goes to plan, the delivery arrives just as you reach your last 10 units.
You can try your own numbers in the free reorder point calculator.
How much safety stock?
There is no single right answer. More safety stock means fewer stockouts and more money tied up. A simple way to get a starting number is to compare your worst case with your average case:
Safety stock = (busiest daily sales × longest lead time) minus (average daily sales × average lead time)
Using the example above, suppose your busiest days reach 6 units and the slowest delivery you have had took 10 days:
- Worst case: 6 × 10 = 60 units
- Average case: 4 × 7 = 28 units
- Safety stock: 60 minus 28 = 32 units
That is a cautious figure, because it assumes the busiest sales and the slowest delivery happen together. Treat it as an upper guide. For a cheap item that never goes out of date, holding that much is fine. For something bulky, expensive or perishable, you may choose less and accept a small risk of running out.
Setting it up in a spreadsheet
Give each product a row with these columns:
| Column | Example | Formula |
|---|---|---|
| A: Product | Poly mailer A4 | Typed |
| B: In stock | 45 | Typed, or from a stock log |
| C: Sold in last 90 days | 360 | Typed, or from a stock log |
| D: Average daily sales | 4 | =C2/90 |
| E: Lead time (days) | 7 | Typed |
| F: Safety stock | 10 | Typed |
| G: Reorder point | 38 | =ROUNDUP(D2*E2+F2,0) |
| H: Status | OK | =IF(B2<=G2,"Reorder","OK") |
Add conditional formatting to the Status column so that "Reorder" turns a colour you cannot miss. These formulas work the same way in Excel and Google Sheets.
A useful extra column is days of stock left, which is stock divided by average daily sales: =IF(D2=0,"",B2/D2). If that number is smaller than the lead time, you are already late.
How much to order
The reorder point tells you when to order, not how much. A plain approach is to decide how many days of stock you want each order to cover, then multiply by average daily sales. If you want each order to last 30 days at 4 units a day, order 120 units. Round up to your supplier's pack size or minimum order.
Where the simple formula falls short
- Seasonal items. An average over the last 90 days is wrong just before a busy season. Raise the daily sales figure by hand when you know a peak is coming.
- New products. With no sales history, start with a guess, keep the safety stock generous, and recalculate after a few weeks.
- Slow sellers. If an item sells once a fortnight, averages mean little. A fixed minimum of one or two units is often enough.
- Changing suppliers. A new supplier means a new lead time. Update it straight away.
Recalculate every month or two. Sales speed changes, and a reorder point set a year ago is probably wrong today.
The Inventory Tracker does this for you in Excel and Google Sheets, with live stock levels and reorder alerts based on sales speed and supplier lead time.