Akiba Tools › Free tools

Reorder Level Calculator

Free · works in your browser · nothing is stored or sent

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.

1. How much do you use?
An average from recent issues. If use is falling, take the latest period.
2. Lead time
The real time from raising the order to the item on your shelf: approval, supplier, shipping, clearing and receiving.
3. Safety stock
4. Maximum cover
of use
The most stock you want to hold. A common start: 2 months for local supply, 6 months for imports.

5. Order now? (optional)
Reorder level
60

Order when stock on hand + stock on order falls to this level.

48
Use during lead time
12
Safety stock
78
Maximum
66
Usual order quantity
Order now? Add your stock on hand and on order to check.

The working

  1. Use during lead time: 6 a week × 8 weeks = 48

Runs in your browser. Nothing you type is stored or sent.

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.

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.

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

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 founder

Start 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 free

Frequently 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.