Reorder point: how to set one per SKU without overbuying

A reorder point is the stock level that triggers the next order. How to set one per SKU from your real lead time, sales rate and safety stock, and what it costs in cash.

Illustration for Reorder point: how to set one per SKU without overbuying

Reorder point is the stock level that triggers your next order. It covers the sales you expect while the supplier is delivering, plus a buffer so one busy week does not empty the shelf. Set it too low and you stock out. Set it too high and your cash sits in a warehouse.

What a reorder point actually is

A reorder point is a number of units, not a date. It answers one question: how low can this SKU fall before you have to order again?

It has three inputs. How fast the SKU sells, how long the supplier takes, and how much buffer you want. Nothing else. Anything that changes those three changes the reorder point.

Two things it is not. It is not the same as safety stock, though safety stock is part of it. And it is not a stock target, because you pass through a reorder point rather than holding stock there.

The reorder point formula

Reorder point = (average daily sales x lead time in days) + safety stock

Average daily sales is units sold over a period, divided by the days in that period. Use 90 days for a steady SKU, 30 for one that moves quickly.

Lead time in days runs from the moment you send the purchase order to the moment stock is on the shelf and sellable. Include production, shipping, customs and goods-in.

Safety stock is the buffer for the weeks that beat the average.

A worked example

A Shopify brand sells a cotton hoodie.

InputValue
Average daily sales12 units
Lead time21 days
Safety stock60 units

Reorder point = (12 x 21) + 60 = 312 units.

So when the hoodie falls to 312 units, you order. If you order 500 units, they arrive as stock drops to roughly 60, which is your buffer.

Now change one input. The same hoodie from a slower supplier, lead time 35 days: reorder point = (12 x 35) + 60 = 480 units. Demand has not changed at all. The longer lead time moves the trigger by 168 units, and that is 168 units of cash you have to fund earlier. The stock order affordability calculator shows what that earlier commitment does to a given month.

How to set safety stock without guessing

Safety stock is where most brands either panic or under-plan. Three workable approaches:

  • One to two weeks of average sales. Quick and crude, fine for steady SKUs.
  • Cover your worst recent week. Take the last 13 weeks, find the busiest, and hold the gap between that and the average.
  • Statistical. Multiply your sales standard deviation by a service factor. Accurate, but it needs enough history to mean anything.

For a catalogue under a few hundred SKUs, the second option is usually the sweet spot. It is grounded in your own numbers, and it takes ten minutes per SKU. It also pairs well with days inventory outstanding, which tells you how long that buffer keeps your cash tied up, and with inventory turnover ratio, which shows how hard the stock is working once it lands.

Setting reorder points across a whole catalogue

Do not do this by hand if you have more than about 30 SKUs. Sort the catalogue into three bands:

  • Fast movers: recalculate monthly.
  • Steady sellers: recalculate quarterly.
  • Slow or seasonal: set a manual trigger and review before the season starts.

Seasonal SKUs break the formula, because average daily sales hides the peak. For those, use the peak season daily rate in the lead time calculation rather than the annual average. If you are still working out how much to buy in the first place, how much stock to order walks through the order quantity side.

A calculator helps if you want to test triggers quickly. The reorder point calculator runs the same formula without a spreadsheet.

The cash side of the decision

Every reorder point is a cash commitment, and most brands plan the two separately. The stock plan lives in one tool, the forecast in another, and the join between them is a spreadsheet someone updates on a Friday.

That join is where the expensive mistakes happen. A reorder point that looks sensible on the inventory side can land in the same month as a VAT bill, a supplier deposit or a heavy ad spend, and the forecast is the only place that shows it coming.

Cushion is built around that join. One place where the cash forecast can see the stock, and the stock plan can see the bank balance. It reads your bills, balances and payment terms, and connects read-only to Shopify, Xero and QuickBooks, so nothing is entered twice. If that is the gap you are currently patching with a spreadsheet, join the waitlist.

Common mistakes

Ordering to the reorder point instead of ordering to cover the gap. The trigger tells you when, not how much.

Using the quoted lead time instead of your actual one. Measure your last five deliveries. The real number is usually longer.

Setting safety stock once and never revisiting it. Lead times move with freight rates and factory calendars, so the buffer should move too.

Ignoring the cash cost of a longer lead time. A cheaper supplier with a slower ship is often the more expensive choice overall.

FAQs

What is a good reorder point?

There is no universal number. A good reorder point covers your real lead time demand plus a buffer you can actually fund. It is specific to the SKU, the supplier and your cash position.

Should the reorder point include stock already on order?

No. Calculate it from sellable stock on hand. Stock in transit is a separate line, or you count it twice and order late.

How often should I recalculate?

Fast movers monthly, steady sellers quarterly, and any SKU immediately after its supplier or shipping route changes.

What if I cannot fund the reorder?

That is a cash question before it is a stock question. Order less and more often, negotiate a deposit instead of full payment up front, or accept a stockout on your slowest line. Deciding that in advance is cheaper than deciding it in a panic.

Does a reorder point work for made-to-order products?

Partly. You still need a trigger for materials, but the lead time runs from the raw material order rather than finished goods. Treat the component as the SKU.

Filed underReordersInventory Planning
Rory McLaughlan
Written by

Rory McLaughlan

Runs a Shopify store selling mystery football shirt boxes across the UK, EU and US. Built Cushion after years of joining up a cashflow sheet, a stock sheet and a sales forecast in his head every Sunday night.

See whether the next reorder leaves enough cash

Cushion puts your cashflow, stock and sales forecast on one screen, with read-only connections to your store, your books and your bank.