GenFrontier homeScope a project
Menu
Filed under
Deliver toBuyers and planners deciding when to place the next purchase order

Reorder point calculator with inventory position

Calculate a reorder point from daily demand, lead time and safety stock, then compare it with inventory position to see whether the item needs an order now.

Plan an inventory project
resources / reorder-point-calculator
An hourglass whose falling sand is made of tiny cardboard boxes, with a red line marked partway down the lower bulb

Calculator

Example values are filled in. Replace them with your own; results update as you type. Nothing you enter leaves your browser.

Results

Demand during lead time
1,080 units
Reorder point
1,511 units
Inventory position (on hand + on order − backorders)
1,190 units
Order now?
Yes, position is at or below the reorder point

Compare the reorder point with inventory position, not just on-hand stock, so open purchase orders are not ordered twice.

The reorder point tells you when to place the next order. ASCM describes the order point as “normally calculated as forecasted usage during the replenishment lead time plus safety stock.” This calculator does that sum, then checks your current inventory position against it, so you can see whether the item needs an order today.

How to use the calculator

  1. Average daily demand, on the same day basis as the lead time.
  2. Lead time in days, from order release to stock available to pick.
  3. Review period. Enter 0 if your system checks the item after every transaction (continuous review). If a buyer reviews it on a schedule, enter the days between reviews.
  4. Safety stock in units. Size it with the safety stock calculator or enter your current setting.
  5. Stock status: units on hand, units on open purchase orders, and backorders or committed quantities not yet shipped.

The formula

Reorder point = d × (L + R) + SS

Inventory position = on hand + on order − backorders and committed

Order when the inventory position is at or below the reorder point.

Symbol Meaning Example value
d Average daily demand 120 units
L Lead time 9 days
R Review period (0 for continuous review) 0 days
SS Safety stock 431 units

With R at 0, this is the form in the MIT ESD.260 lecture: expected demand over the lead time plus a safety factor times the standard deviation of lead-time demand. The calculator rounds the reorder point up to a whole unit.

Example (fictional). Item EX-20118 ships 120 units a day, the supplier takes 9 days, the system reviews continuously, and safety stock is set at 431 units, the figure the safety stock calculator gives for the same item. The warehouse has 1,250 units on hand, nothing on order, and 60 units committed to orders not yet shipped.

  • Demand during lead time: 120 × 9 = 1,080 units
  • Reorder point: 1,080 + 431 = 1,511 units
  • Inventory position: 1,250 + 0 − 60 = 1,190 units
  • Result: 1,190 is below 1,511, so order now

Reading the result

The on-hand figure alone looks comfortable: 1,250 units is more than ten days of demand against a nine-day lead time. But 60 of those units already belong to customers. If the order goes today, the expected stock when it arrives is 1,190 − 1,080 = 110 units, well inside the 431-unit buffer. The position is 321 units below the reorder point, so at 120 units a day the order is almost three days late.

Now enter 1,000 units on open purchase orders. The inventory position becomes 2,190 units, and the calculator answers “Not yet, 720 units above the reorder point”. That is why the comparison uses position instead of on-hand stock: an order already placed is not placed twice.

The reorder point answers when. How much to order is a separate decision; the EOQ calculator gives a starting quantity for items with steady demand.

With a review period

If you enter a review period, read the result as a target level. At each review, order the difference between that level and the inventory position. A weekly review adds seven days of exposure: 120 × (9 + 7) = 1,920 units plus safety stock. Size that safety stock for the review period plus the lead time, because an item that just missed a review is exposed for both.

Common mistakes

  • Comparing with on hand only. This is the usual cause of duplicate purchase orders.
  • Ignoring committed stock. Allocated or backordered units are not available, even while they are still on the shelf.
  • Lead time from the quote. Use measured lead time from your receipts.
  • Mismatched units of measure. A reorder point in eaches compared with on hand in cases gives a wrong answer with no warning.
  • Static settings. Demand in spring is not demand in fall. Recalculate when the rate changes, not once a year.

When the simple model stops working

  • Trend and seasonality. The formula uses one average rate. When demand is rising or seasonal, use forecast demand over the lead time, as the MIT lecture does.
  • Minimum order quantities and pack sizes, which can make real orders much larger than the gap between position and reorder point.
  • Lumpy demand, where one large order can consume the whole buffer.
  • Several suppliers or lanes with different lead times for the same item.
  • Many locations, where a shortage at one site might be covered by a transfer from another.

When reorder points for thousands of items need to update from real demand and real receipts, and order suggestions need to reach buyers inside the ERP, it becomes a software project. See inventory management software for how that work is scoped and built.

Scope your project.

Tell us what you need to track, which systems you run and when it has to work. We reply with questions or a time to talk.