A Guide to Comparing Lead Times and QC Speed
Unlocking the Power of Timestamp Data
The MuleBuy Spreadsheet is an essential tool for data-driven sourcing. By automatically logging detailed timestamps for each order's QC (Quality Control) completionfinal delivery, it transforms raw data into actionable supplier insights. This guide walks you through the process of using this data to identify which suppliers offer the optimal balance of speed and consistent quality.
Key Data Points in Your Spreadsheet
To begin your analysis, familiarize yourself with these critical columns:
- Order Date:
- QC Pass Timestamp:
- Delivery Confirmation Timestamp:
- Supplier Name:
- QC Status (Pass/Fail):
- QC Pass Timestamp:
Step-by-Step Analysis
Step 1: Calculate Core Metrics
Create two new calculated columns in your spreadsheet:
- Production & QC Lead Time:(QC Pass Timestamp - Order Date). This measures how quickly a supplier manufactures and conducts quality checks.
- Shipping Lead Time:(Delivery Timestamp - QC Pass Timestamp). This isolates the pure logistics speed after goods are ready.
- Total Lead Time:(Delivery Timestamp - Order Date). The overall timeline from order to doorstep.
Step 2: Segment Data by Supplier
Use filters or Pivot Tables to group all calculated metrics by Supplier Name. This creates a clear, supplier-by-supplier view for direct comparison.
Step 3: Assess Speed and Consistency
For each supplier, analyze the following:
- Average Lead Times:
- Variability (Range & Standard Deviation):
- QC Pass Rate:
- Variability (Range & Standard Deviation):
Step 4: Create a Performance Matrix
Plot suppliers on a simple matrix:
- X-Axis:
- Y-Axis:
The ideal suppliers will cluster in the top-left quadrant
Pro Tips for Ongoing Management
- Track Trends:
- Dig into Anomalies:
- Share Findings:
- Dig into Anomalies: