Supplier Lead Time Variability

This dataset provides detailed tracking of supplier lead time performance by recording both promised and actual delivery dates for each purchase order, along with item, quantity, and status information. It enables procurement teams to analyze supplier reliability, identify patterns in delivery delays, and optimize supply chain planning. The data supports actionable insights for improving supplier relationships and reducing inventory risk.

  • opened 16 times
  • last updated 12 Jul 2025
  • by GoMask
The brief that made it

Supplier performance benchmarking and scorecarding

Sample rows

preview · 8 of 50 rows · all 19 columns
record_idstringorder_statusstringactual_lead_time_daysintegeron_time_deliverybooleanitem_idstringsupplier_idstringsupplier_namestringitem_descriptionstringpurchase_order_idstringorder_datedatepromised_delivery_datedateactual_delivery_datedatepromised_lead_time_daysintegerlead_time_variance_daysintegerquantity_orderedintegerquantity_receivedintegerlate_reasonstringbuyer_idstringbuyer_namestring
REC-0001delivered11trueSKU-5001SUP-101Alpha Supplies Inc.High-Grade Steel BoltsPO-900012023-01-152023-01-272023-01-2612-1500500blankBUY-301Morgan Lee
REC-0002delivered18falseSKU-5002SUP-102Beta IndustrialPrecision Ball BearingsPO-900022023-02-032023-02-172023-02-21144200200Supplier backlogBUY-302Alyssa Kim
REC-0003delivered13trueSKU-5003SUP-103Delta ComponentsIndustrial Rubber GasketsPO-900032023-03-102023-03-242023-03-2314-1150150blankBUY-303Samuel Yates
REC-0004partial17falseSKU-5004SUP-101Alpha Supplies Inc.Copper Wiring 20mPO-900042023-04-052023-04-192023-04-221431000950Transport strikeBUY-304Derek Wong
REC-0005delivered14trueSKU-5005SUP-104Gamma MetalsAluminum Sheets 2mmPO-900052023-05-152023-05-292023-05-29140300300blankBUY-305Priya Nair
REC-0006delivered20falseSKU-5001SUP-105Omega Parts Co.High-Grade Steel BoltsPO-900062023-06-202023-07-042023-07-10146700700Customs delayBUY-306Elena Alvarez
REC-0007delivered12trueSKU-5006SUP-102Beta IndustrialPlastic Fasteners SetPO-900072023-07-252023-08-082023-08-0614-2400400blankBUY-301Morgan Lee
REC-0008partial17falseSKU-5007SUP-103Delta ComponentsIndustrial Lubricant 5LPO-900082023-08-122023-08-262023-08-2914310098Supplier ran out of stockBUY-302Alyssa Kim

What the 50 rows show

from the 50-row sample

Delivered (order status) stands out: 25 of its 37 rows have on_time_delivery = true, against 0 of 13 for the rest.

  • 50%on_time_delivery = true
  • 14.5median actual_lead_time_days
  • 6buyers
  • 6buyer names
  • 7suppliers
  • 7supplier names
On time delivery rate by order_statuson_time_delivery = true
0%50%100%68%delivered25 of 370%partial0 of 13

Delivered (order status)'s mean actual_lead_time_days is 14.2, against 17.5 for partial.

actual_lead_time_days50 rows, in bands of 2
0816312151073101622actual_lead_time_days →

Median 14.5, from 10 to 22.

item_id50 rows · top 10 of 20 values
  1. SKU-50013
  2. SKU-50023
  3. SKU-50033
  4. SKU-50043
  5. SKU-50053
  6. SKU-50093
  7. SKU-50103
  8. SKU-50113
  9. SKU-50143
  10. SKU-50183
19 columns by typefrom the column list below
  • string 10
  • integer 5
  • date 3
  • boolean 1

Columns

19 columns in four groups
blueprint · 19 columns
columntypedescriptionexample
Text 10 columns
record_idstringUnique identifier for each supplier lead time recorduniqueREC-0001
supplier_idstringUnique identifier for the supplier7 suppliersSUP-101
supplier_namestringName of the supplier7 namesAlpha Supplies Inc.
item_idstringUnique identifier for the item or SKU being procuredSKU-5001
item_descriptionstringDescription of the item or SKUoptionalHigh-Grade Steel Bolts
purchase_order_idstringUnique identifier for the purchase orderPO-90001
late_reasonstringReason for late delivery, if applicableoptionalSupplier backlog
order_statusstringCurrent status of the order (e.g., delivered, pending, cancelled)delivered · pending · cancelled · partialdelivered
buyer_idstringUnique identifier for the buyer or procurement agent6 buyers · optionalBUY-301
buyer_namestringName of the buyer or procurement agent6 names · optionalMorgan Lee
Numbers 5 columns
promised_lead_time_daysintegerNumber of days between order date and promised delivery date0 or more12
actual_lead_time_daysintegerNumber of days between order date and actual delivery date0 or more11
lead_time_variance_daysintegerDifference between actual and promised lead time in days (actual_lead_time_days - promised_lead_time_days)-1
quantity_orderedintegerQuantity of items ordered1 or more500
quantity_receivedintegerQuantity of items actually received0 or more500
Dates and times 3 columns
order_datedateDate when the purchase order was placed2023-01-15
promised_delivery_datedateDate promised by the supplier for delivery2023-01-27
actual_delivery_datedateDate when the goods were actually delivered2023-01-26
True or false 1 column
on_time_deliverybooleanIndicates if the delivery was on or before the promised datetrue

Use it for

  • on time delive…50%25 of 50 rowsmean actual lead time…14.2delive…17.5partial

    A logistics dashboard

    The on_time_delivery rate, actual_lead_time_days by order_status and a breakdown of item_id. Excel, Power BI or Tableau.

  • Why do 25 of 50 rows have on_time_delivery = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable records with supplier_id, supplier_name and item_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset50 rows19 columns
Yours1,000 rows19 columns

blueprint · supplier-lead-time-variability

Behind this dataset

Same schema. As many rows as you need.

These 50 rows came out of a blueprint — 19 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • Compare promised and actual delivery dates
  • Flag deviations over 2 days
  • Aggregate by supplier
  • Calculate mean lead time variance
  • Highlight top 3 reliable suppliers
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
supplier-lead-time-variability

More in Logistics

Browse all
Also in LogisticsAI Supplier Risk Scoring DataCold Chain Logistics Temperature LogsSupply Chain Disruption EventsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.