Akiba Tools › Free tools
Reorder Level Calculator
Work out when to reorder an item and how much to order. Enter how much you use, how long a new order takes to reach your shelf and how much safety stock you want. You get the reorder level, the maximum and the working, step by step.
How the reorder level is worked out
Use during lead time = usage × lead time
Reorder level = use during lead time + safety stock
Maximum = usage × maximum cover
Order quantity = maximum − (stock on hand + stock on order)
Lead time is the real time from raising the order to the item on your shelf. Count approval, the supplier's time, shipping, customs clearing and receiving. Using only the delivery time a supplier quotes is the most common reason a reorder level is too low.
Safety stock covers use that runs faster than average, or a delivery that runs late. A practical start is 25% of the use during the lead time for items used steadily, and 50% for items whose use goes up and down. You can also set it as a number of days or weeks of use, or as a fixed quantity.
The reorder level is the point to order at: when stock on hand plus stock on order falls to it, place an order.
The maximum caps how much stock you hold. It has to sit clearly above the reorder level, with room for the safety stock and the lead time. If your maximum cover is too short, the calculator raises it and tells you.
The order quantity brings you back up to the maximum. If you order exactly at the reorder level, that is the maximum minus the safety stock: the "usual order quantity".
All results are rounded up to whole units, and order quantities to your pack size. The calculator takes a year as 52 weeks or 12 months.
Two worked examples
1. A V-belt, ordered from abroad
About 6 used a week. 8 weeks from order to shelf. Steady use, so safety stock is 25%. Maximum cover 3 months. 35 on the shelf, none on order.
- Use during lead time: 6 × 8 = 48
- Safety stock: 25% × 48 = 12
- Reorder level: 48 + 12 = 60
- Maximum: 26 a month × 3 months = 78
- 35 + 0 = 35, at or below 60, so order now: 78 − 35 = 43
2. A hydraulic filter, packs of 10, already on order
120 used a year. 3 months from order to shelf. Use goes up and down, so safety stock is 50%. Maximum cover 6 months. 25 on the shelf, 40 on order.
- Use during lead time: 10 a month × 3 = 30
- Safety stock: 50% × 30 = 15
- Reorder level: 30 + 15 = 45
- Maximum: 10 a month × 6 months = 60
- 25 + 40 = 65, above 45, so no order
Looking only at the 25 on the shelf, you would order 40 more and end up with 105 filters, close to a year of use.
Made-up items. Try them in the calculator above.
When a formula is the wrong answer
- Critical spares are held for breakdowns, not for regular use. Set them by decision, based on what a stoppage would cost, and record why.
- Erratic use, with big swings from year to year, gives misleading averages. Set these levels by hand, item by item.
- Items with no use, or whose use has stopped, should have a reorder level of 0. Otherwise they will be bought again.
- Very slow movers, where less than 1 is used during the lead time, get a reorder level of 1 and a maximum of 2.
Hundreds or thousands of items? The Stock Health Check does this for every item in your stock export. It works out usage from your yearly issues, sorts steady, variable and erratic items, and puts your current levels next to the suggested ones with the cash each change frees or needs. You approve each line: nothing changes on its own.
Want to set levels in Excel for a whole store? The reorder level formula guide gives the full method with formulas.
Next step
Every item at once
Stock Health Check
$39 founder price (first 100 founders, then $79)
Suggested reorder levels, maximums and order quantities for every item in your stock export, with local and foreign lead times, pack sizes and critical spares. Your current levels side by side, with the cash freed or needed. Runs in your browser: your file is never uploaded. Includes the Dead Stock Action Pack.
Become a founderStart with what's dead
Dead Stock Finder
Free
Find the dead and non-moving items in your stock export, including the ones still on order or still carrying a reorder level.
Try it freeFrequently asked questions
Is a reorder level the same as a reorder point?
Yes. Both mean the stock level at which you place a new order. Many systems call it the minimum and pair it with a maximum (min/max).
What should the lead time include?
Everything from the moment the need is seen to the moment the item is on the shelf and can be issued: raising and approving the order, the supplier's time, shipping, customs clearing and receiving. For imports this is often months, not the weeks a supplier quotes.
How much safety stock should I hold?
A practical starting point is 25% of the use during the lead time for items used steadily and 50% for items with variable use. Critical spares are set by decision, based on what a breakdown would cost, not by formula.
Should stock on order count when deciding to reorder?
Yes. Order when stock on hand plus stock on order is at or below the reorder level, and order up to the maximum minus both. Looking at stock on hand alone leads to double orders.
What is the difference between the reorder level and the maximum?
The reorder level tells you when to order. The maximum caps how much stock you hold once the order arrives. The order quantity fills the gap between what you have, including what is on order, and the maximum.
Practical tips on stores and stock: Follow Akiba Tools on LinkedIn