-
Excel workbook preview
Goods Receipt, Inventory and Logistics
Supplier Lead Time Tracker
3 downloads per free account, no card needed.
Who this is for
A buyer or planner needs real lead times when the production manager asks why materials keep arriving later than the system expects.
What is inside
- 14 sample orders from 5 suppliers, 20 blank rows
- Promised date, actual lead time and variance calculate
- Open orders past their promised date turn red as Overdue
- Summary: average quoted and actual, longest, on-time rate per supplier
- Planning lead time = the higher of average quoted and actual
- On-time rates below 80% turn red
How to use it: Add each order when it is placed and the receipt date from the GRN; use the Summary's planning lead time in your reorder points.
Files & formats
- XLSXsupplier-lead-time-tracker.xlsx13 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves.


