Built on your total lead time, not the supplier's quote. Five inputs, and you see three numbers: your safety stock in units, the reorder point that keeps you in stock, and the one your spreadsheet probably uses. No email, no signup.
Five numbers, all in days except the first. Everything is calculated in your browser.
Use a 30-60 day average for this SKU. Decimals are fine.
The production + ship time on the quote or the last PO confirmation.
For your actual shipping mode. Sea freight from Asia is typically 25-40; air is 5-10; domestic ground 2-5.
Dock to sellable. Most 3PLs quote 1-3 business days; peak season runs longer.
How many days of demand you want as a cushion. 7-14 for steady A-SKUs; more if demand or the supplier is volatile.
A reorder point is the stock level that triggers your next purchase order. The formula has two halves:
Reorder point = (average daily demand × total lead time in days) + safety stock
Safety stock = average daily demand × days of cover
The first half covers what you will sell while the order is in transit. The second is the buffer that absorbs a demand spike or a late shipment. This calculator sets safety stock in days of cover rather than the statistical z-score method, because days of cover is a number an operator can defend in a meeting and revise on the spot. Seven to fourteen days suits a steady A-SKU. Push it higher when demand swings, when the supplier has slipped before, or when the lead time itself is long, since a long pipeline gives you less time to react to any of it.
Every reorder point formula is the same multiplication: daily demand times lead time, plus a buffer. What separates brands that stay in stock from brands that do not is one input. The supplier's quoted lead time covers production. Your money is on the shelf only after freight, customs, and your 3PL's receiving queue, and that total is routinely two to four weeks longer than the quote. A reorder point built on the quote is not wrong math, it is right math on a wrong number, and it fires the purchase order weeks late every single cycle.
We use essential cookies for sign-in and a small amount of analytics to improve the product. Privacy policy.