Reorder point and safety stock calculator
Enter how much you use a day and how long your supplier takes, on a normal day and on a bad one. See the safety stock to keep and the stock level at which to place the next order.
How the reorder point is worked out
- Lead-time demand
- Lead-time demand = average daily usage × average lead time in days.
- Safety stock
- Safety stock = (maximum daily usage × maximum lead time) − (average daily usage × average lead time).
- Reorder point
- Reorder point = lead-time demand + safety stock. Order when stock falls to this level.
Worked example. Example: you use 20 a day on average and 30 on a busy day, and the supplier takes 7 days on average and 10 at worst. Safety stock is 30 × 10 − 20 × 7 = 160, and you reorder when stock falls to 140 + 160 = 300.
Questions
What is a reorder point?
It is the stock level at which you place the next purchase order, so the new stock arrives before you run out. It covers the usage during the supplier's lead time plus a safety stock.
How much safety stock should I keep?
Enough to cover the gap between a normal and a bad period: (maximum daily usage × maximum lead time) − (average daily usage × average lead time). Fast-moving or critical items deserve more.
How often should I recalculate it?
Whenever usage or the supplier's lead time changes, and at least every season. Software that tracks usage can keep the reorder level up to date for you.
These calculators are for quick checks and planning. For tax filing, follow the rules for your business or ask your accountant.
Doing these sums every day?
Sense Softech builds ERP, POS and business software that does them for you, on every invoice, purchase and stock movement.
