Enter your average usage and your supplier’s lead time, add a safety stock, and the calculator gives your reorder point: the stock level at which to place an order so that it arrives before you run out. Add the stock on hand and anything already on order to see whether it is time to reorder, or how long you have. It also offers a cautious maximum usage method, based on maximum usage and maximum lead time, with the minimum (buffer), maximum and average stock levels.
Pick the time unit
Day, week or month: usage, lead times and safety cover are all counted in this unit. If you sell seven days a week but your supplier quotes working days, convert the lead time to calendar days: an order placed on a working day with a 10-working-day lead time arrives 14 days later, or more when a bank holiday falls in between.
Enter usage, lead time and safety stock
Take average usage from past sales: 900 units sold in 30 days is 30 units a day. Lead time runs from placing the order to having the goods ready to sell, including receiving and checking them. Give the safety stock in units, or as time of usage, such as 3 days of average sales.
Read the result
The reorder point is rounded up to a whole unit, so rounding never eats into the safety stock; the other quantities are exact. The time until the reorder point is rounded down to a tenth. Copy the workings, export them as a CSV file or save them to Priostack.
Usage during lead time = average usage × average lead time.
Reorder point = usage during lead time + safety stock.
Maximum usage method: reorder level = maximum usage × maximum lead time; safety stock (buffer, or minimum level) = reorder level − average usage × average lead time; maximum stock level = reorder level + order quantity − minimum usage × minimum lead time.
Average stock = safety stock + order quantity ÷ 2.
It is time to reorder when stock on hand plus stock on order is at or below the reorder point.
Example: 30 units a day and a 5-day lead time
This is ACCA’s example: with demand of 30 units a day and a lead time of 5 days, usage during the lead time is 30 × 5 = 150 units, which is the reorder point with no safety stock. Add a safety stock of 3 days of sales, 30 × 3 = 90 units, and the reorder point rises to 150 + 90 = 240 units. With 300 units on the shelf and nothing on order, you will need to reorder in (300 − 240) ÷ 30 = 2 days.