Reorder point calculator
Find the stock level at which to place your next order, so the delivery arrives before you run out.
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
- Guide: How to work out when to reorder stock
- Free tool: Marketplace fee and profit calculator
- Free tool: Budget split calculator