GridWorkshop
Guide

How to work out when to reorder stock

Published by GridWorkshop. About 4 minutes to read.

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.

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:

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:

ColumnExampleFormula
A: ProductPoly mailer A4Typed
B: In stock45Typed, or from a stock log
C: Sold in last 90 days360Typed, or from a stock log
D: Average daily sales4=C2/90
E: Lead time (days)7Typed
F: Safety stock10Typed
G: Reorder point38=ROUNDUP(D2*E2+F2,0)
H: StatusOK=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

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.

Keep reading