Built on your total lead time, not the supplier's quote. Five inputs, and you see both numbers: 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.
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.