GridWorkshop
Free tool

Reorder point calculator

Find the stock level at which to place your next order, so the delivery arrives before you run out.

Runs in your browser. Nothing you type is sent anywhere or saved.

Your numbers
Units sold in a recent period, divided by the number of days.
Days from placing an order to having stock ready to sell.
A buffer for busy weeks and late deliveries. Enter 0 for none.
Fill this in to see how long until you need to order.
Not sure about safety stock?

One simple estimate: (busiest daily sales × longest lead time) minus (average daily sales × average lead time).

Suggested safety stock:

Result

Sold during the lead time
Safety stock
Reorder point

How it is worked out

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

Worked example

You sell 4 units a day and your supplier takes 7 days, so you will sell 4 × 7 = 28 units while you wait. Add 10 units of safety stock and the reorder point is 38. When stock falls to 38 units, place the order. The result is rounded up to a whole unit.

The suggested safety stock in the example is (6 × 10) minus (4 × 7) = 60 minus 28 = 32 units. It is a cautious figure, because it assumes your busiest sales and slowest delivery happen together.

Want this in a spreadsheet you can keep? The Inventory Tracker is a ready made template for Excel and Google Sheets: live stock levels, smart reorder alerts and a dashboard.

Keep reading