Inventory Reorder Point Calculator: Formula & Guide

What a reorder point is, the exact formula behind it, a worked example, and how to calculate it for every SKU at once from a CSV — privately, in your browser.

What is a reorder point?

The reorder point (ROP) is the stock level at which you should place the next purchase order. Order earlier and cash sits idle in excess stock; order later and you risk running out before the delivery arrives. The reorder point balances the two by covering the demand you expect during the supplier's lead time, plus a safety buffer for the unexpected.

The reorder point formula

ROP = ( d × LT ) + SS
SymbolMeaning
ROPReorder point, in units (rounded up to whole units).
dAverage daily demand = average monthly demand ÷ 30.
LTSupplier lead time in days, from order placement to delivery.
SSSafety stock — the buffer against demand and lead-time variability.

The ( d × LT ) part is the demand you expect while the order is in transit. The safety stock part covers the days when demand runs hot or the delivery runs late. Safety stock is usually set with a service-level factor: SS = Z × σ_d × √LT, where Z reflects how often you want to be in stock (95% → Z ≈ 1.65). The full derivation, including the version that accounts for unreliable lead times, is documented on the Methodology page.

A worked example

An item sells 300 units per month on average, so daily demand d = 300 ÷ 30 = 10 units. The supplier takes 14 days to deliver, and you keep 50 units of safety stock:

ROP = ( 10 × 14 ) + 50 = 190 units

When your net stock — what is on hand plus what is already on order — falls to 190 units, it is time to reorder. If net stock is 160 units, you are 30 units short of the reorder target; with a minimum order quantity (MOQ) of 100, the recommended purchase order is max(30, 100) = 100 units.

How the StockLogic reorder point calculator works

The Reorder Point tool applies this formula to every SKU in your file at once — up to 1,000 per upload — entirely in your browser. Your CSV is never uploaded to a server.

  • Demand (d): averaged from your 6 or 12 most recent months of demand history. Extreme months beyond 5 standard deviations are clamped first, so one mistyped cell cannot distort the average.
  • Lead time (LT): measured from your closed purchase-order lines (delivery date minus order date), with fallbacks per item, supplier or a manual default when history is thin.
  • Safety stock (SS): calculated from demand variability and your chosen service level — the same engine as the Safety Stock tool.
  • Reorder decision: if net stock (on hand + on order) is above the ROP, the item is "OK" and no order is suggested. At or below the ROP, the item is flagged "Reorder" and the recommended quantity is the larger of the shortfall and your MOQ.
  • Max stock: the tool also shows an order-up-to level, Max Stock = ROP + ( d × LT ), so you can see the ceiling as well as the trigger.

Try it on your own data

Upload a demand history CSV (and optionally an order book and operations file for lead times, stock and MOQs), or load a sample dataset to see the calculator in action. Everything runs locally — your inventory data never leaves your device.