Your supplier said 45 days. Here is what they actually take

Quoted lead times are a sales number. The one that should drive your purchase orders is the one you can measure from your own receiving history. Here is how, with a sheet.

Shipping containers stacked at a port at dawn, one being lifted by a crane

Every supplier has a quoted lead time, and almost every store plans around it. In the receiving records I have looked at over the years, the quoted number is usually optimistic by one to two weeks, and the gap is remarkably consistent for each supplier. That consistency is the useful part: a supplier who is always eight days late is predictable. You just have to measure them.

What to measure

For each purchase order, you need two dates: the day you placed it and the day the goods were booked into stock. Not the ship date, not the arrival at port. The day your team could pick from it.

Subtract one from the other. That is the real lead time for that order. Do it for the last six orders from each supplier, and take the average. Keep the longest too; it tells you the worst case you have actually lived through.

Supplier (example)QuotedLast 6, averageLongest
Footwear factory, Shenzhen45 days53 days61 days
Bag maker, Rotterdam10 days11 days14 days
Cotton tees, Tiruppur30 days38 days52 days

The Shenzhen number is the one that catches people out: eight days late on average, and once in six orders more than two weeks late. If your purchase orders are planned around 45, you are short of stock one order in three.

Use the real number everywhere

Once you have it, the real lead time replaces the quoted one in three places:

  • The reorder point. Days of cover has to beat the real lead time, not the quoted one. (See the reorder point post for the version that also accounts for ad spend.)
  • Promises to customers. If a product is on pre-order, promise the date the real lead time gives you, plus a few days. A customer who gets it early is delighted. One who gets it late is a refund.
  • The conversation with the supplier. "Your last six orders averaged 53 days against a quoted 45" is a different conversation from "you are always late". Most suppliers will either fix it or give you an honest number, and either is a win.

Keep it moving

Lead times drift. A factory takes on a bigger customer, a port gets congested, a holiday falls in the window. Re-run the average when each new order lands, so the number you plan with is always the last six, not the six from last year.

This is a fifteen-minute job per month in a sheet, and it is one of the highest-return fifteen minutes in a store with physical stock. If the sheet stops getting updated, which is what usually happens around month four, that is the point where it is worth having something do it for you. PixL learns the lead time from each delivery as it is booked in and plans every purchase order on the real number, but the sheet is where to start, because you will not believe the numbers until you have seen them in your own data.

More guides

Twenty minutes on a call, on your own numbers. A person replies on WhatsApp.Ask us for a walkthrough on WhatsApp