When to reorder: the calculation that avoids both stockouts and overbuying
Buying when you run out is too late. The reorder point isn't a fixed figure: it depends on how much you sell, how long the supplier takes and how much both of those vary.
Both mistakes cost the same
Running out and overbuying look like opposite problems, and both come from the same thing: not knowing when to order.
- Running out is a lost sale and, sometimes, a customer who discovers the competitor did have it.
- Overbuying is money sitting on a shelf, at risk of expiring or becoming obsolete.
The company that buys «when it looks low» usually has both at once: too much of what moves slowly and too little of what moves fast.
The calculation, no mystery
The reorder point is the quantity at which you place the order so it arrives before you run out. It's built from three things:
- How much you sell a day of that item, measured over a representative period.
- How long the supplier takes from ordering until the goods are available to sell. Not from dispatch: from when you can sell it.
- How much both of them vary. That margin is the safety stock, and it's what absorbs the week you sold double or the supplier was late.
The important one is the third: with no safety margin, the reorder point is right half the time, which is exactly what happens when you calculate with clean averages.
The details that spoil it
- The supplier's lead time isn't the one the supplier quotes. It's the one you measure: order date against availability date, over the last real orders.
- Seasonal items can't be calculated on the annual average. A seasonal product's average describes no month of the year.
- Promotions break the calculation. A campaign multiplies demand; if the reorder point doesn't know, it sells out in two days.
- The supplier's minimum rules. There's little point calculating that you need 7 if the supplier sells cases of 24.
A replenishment system born with every threshold at zero warns about nothing, and looks like it works: it throws no errors, it simply never suggests buying. Thresholds have to be set item by item, or at least by family.
Before the calculation, the data
None of this works if inventory doesn't match. A reorder point calculated on wrong stock levels suggests buying what you already have too much of and doesn't suggest what you're short of.
That's why the order is: first make inventory match, then automate replenishment. The other way round automates the error.