Setting Reorder Levels and Avoiding Stock-Outs

Stock-outs lose sales and excess stock ties up cash. Reorder levels are the control that sits between the two, and most businesses set them once from intuition and never revisit them.

The four numbers a reorder level needs

Reorder level equals average daily consumption multiplied by lead time, plus safety stock. The arithmetic is simple; getting honest inputs is the work.

Lead time is longer than suppliers say

Measure lead time from your purchase order to the stock being available to sell, not to the delivery date. Inward inspection, quality checks and put-away all consume days that are invisible in the supplier's quoted time.

Sizing safety stock without guessing

Safety stock covers variability, not average demand. A practical starting point is the difference between your highest recent weekly consumption and the average, held for the length of the lead time.

Items with steady demand need very little. Items with lumpy, order-driven demand need more, or a different approach entirely: buy to order rather than stock.

Reviewing levels so they stay useful

1. Review quarterly, and after any supplier change.
2. Reset levels for seasonal items before the season, not during it.
3. Drop reorder levels to zero for items being discontinued.
4. Investigate any item that triggered a stock-out despite being above its level.

A worked calculation

An item sells around 40 units a week. The supplier quotes seven days, but measured lead time from order to shelf is twelve. The busiest recent week was 62 units.

Using the supplier's quoted seven days instead of the measured twelve would have produced a reorder level of 62 units, and a stock-out roughly every time demand ran above average.

Classifying items so effort goes where it matters

Not every item deserves the same attention. A simple value-based classification concentrates effort on the stock that ties up cash.

Seasonality breaks standing reorder levels

A level calculated on annual averages is wrong in both directions for a seasonal item: too low entering the season and far too high leaving it.

What good stock control looks like in the numbers

1. Stock-outs on A-class items approaching zero.
2. Inventory turnover improving year on year.
3. Fewer emergency purchases at unfavourable prices.
4. Falling value of stock older than a defined age.
5. Purchase orders driven by reorder triggers rather than by someone noticing an empty shelf.

Economic order quantity, briefly

Reorder level answers when to order. Order quantity answers how much, and the trade-off is between ordering cost and holding cost.

Formal EOQ calculations are often overkill for a small business. Sense-checking against supplier minimum order quantity and available storage usually lands close enough.

Supplier terms change the arithmetic

Negotiating delivery frequency often cuts working capital more than negotiating price, and it is the conversation businesses have least often.

Handling new items with no history

A new item has no consumption data, so the formula has nothing to work with. Treat the first quarter as a measurement period.

1. Start with a conservative quantity based on a comparable item.
2. Track actual consumption weekly rather than monthly.
3. Set a provisional reorder level after four weeks of data.
4. Recalculate after a full quarter.
5. Discontinue items that show no movement after two quarters.

Reviewing the whole list periodically

Frequently asked questions

Should every item have a reorder level?

No. Set them for items with regular demand. Slow-moving and made-to-order items are better managed by exception than by an automatic trigger.

What if the supplier has a high minimum order quantity?

The minimum order quantity becomes the effective reorder quantity, which raises average stock holding. That is a commercial cost worth quantifying before accepting the term.