Supplier Scorecard Calculator — Track KPI Performance

A supplier scorecard translates supplier performance from anecdote into data. It replaces "they're doing fine" with a structured, quantifiable basis for quarterly business reviews, award-or-reduce decisions, and continuous improvement discussions. A well-built scorecard doesn't just measure — it drives behavior.

OTD — On-Time Delivery (default weight 25): The most universally tracked supplier metric. Measure by part number, not aggregate volume. A supplier delivering 95% of aggregate volume on time while being 0% on your 3 bottleneck parts produces a 95% OTD that is dangerously misleading. Track OTD against the supplier's confirmed delivery date (not your requested date — that's a different metric called Request Date Performance). Industry targets: automotive ≥98%, electronics ≥97%, general manufacturing ≥95%. Red flag pattern: OTD >98% but increasing expedite requests — the supplier is padding lead times to game the metric. When you see this, switch to measuring against request date.

PPM — Parts Per Million Defective (default weight 25): The procurement metric with the highest leverage because defect cost multiplies exponentially. A defective part costs 10-100x the part cost itself when you account for receiving inspection, production line stoppage, rework, containment, and customer impact. A $0.10 defective capacitor that halts a $2M production line for 4 hours — that math doesn't appear in the PPM number but it's the real cost. Industry benchmarks: Six Sigma = 3.4 PPM (aspirational for most categories), automotive Tier 1 target <50 PPM, electronics <200 PPM, general manufacturing <1,000 PPM. Critical distinction: measure PPM at your receiving inspection, not the supplier's outgoing inspection. Their data reflects what they caught, not what they shipped. The delta between the two is your true quality exposure.

Lead Time (default weight 20): Average order-to-delivery time in calendar days. But the average is insufficient — standard deviation matters more. A supplier with a 14-day average and 2-day standard deviation is operationally superior to one with a 10-day average and 7-day standard deviation. The first supplier lets you plan inventory precisely; the second forces you to buffer with safety stock. Track three dimensions simultaneously: mean lead time, standard deviation, and trend direction. Also measure emergency lead time — what is their shortest possible delivery at what cost premium? This number tells you their true flexibility. Measure from PO issuance to goods receipt at your dock, not shipment date — suppliers routinely claim "shipped on time" when goods arrived 5 days late.

Cost Variance (default weight 15): Actual invoice price vs contract price, expressed as percentage variance. Positive variance (paying more than agreed) = contract enforcement failure. A supplier that consistently invoices above contract — even by small amounts — has either a process problem or an integrity problem. Track at the line-item level, not just the invoice total — suppliers can hide overcharges in bulk invoices. Also track year-over-year cost trend: are they delivering contracted annual productivity improvements (typically 2-3% for mature manufacturing relationships)? Track premium freight costs caused by their late deliveries separately — this is a hidden cost that should appear on the scorecard and in QBR discussions.

Responsiveness (default weight 15): Average response time to inquiries, quality alerts, and corrective action requests. Measure in business hours, not calendar hours — a 48-hour response over a weekend is different from 48 hours mid-week. A supplier with 99% OTD and 0 PPM but a 5-day response time to quality alerts is a ticking time bomb — when (not if) a quality incident occurs, their slow response multiplies the damage exponentially. Targets: <4 business hours for critical quality or delivery issues, <24 hours for standard inquiries, <5 business days for corrective action plans with root cause analysis. The single best responsiveness indicator: does the supplier respond to your draft scorecard with questions before the QBR, or do they see it for the first time in the meeting? Engaged suppliers engage before the meeting — it's a leading indicator of partnership quality that no quantitative metric captures.

The scorecard uses a traffic light system — green, yellow, red — widely adopted in procurement because it enables 30-second comprehension by executives who may not understand every underlying KPI but can instantly see where attention is required.

The scoring formula handles two KPI types differently. For higher-is-better KPIs (OTD, Responsiveness): Score = (Actual / Target) × 5, capped at 5. For lower-is-better KPIs (PPM, Lead Time, Cost Variance): Score = (Target / Actual) × 5, capped at 5. Capping at 5 prevents a single exceptional KPI from mathematically masking failures in others — a supplier with zero defects but 70% OTD should not receive a passing overall score.

Trend analysis is as important as the current period's score. A supplier trending 4.2 → 3.8 → 3.5 over three quarters needs intervention now, even if the most recent score is still technically "Approved." The trajectory matters more than the snapshot. Conversely, a 2.5 that was 1.8 and 1.2 in the prior two quarters is a recovery story worth supporting, not a problem to escalate. Scorecards produce time series — use them.

Q1 Performance Data:

• OTD: 94.2% (target ≥97%) — 47 out of 812 line items delivered late, concentrated in weeks 4-6 when their SMT line 3 experienced unplanned downtime. The supplier disclosed the downtime proactively in week 5. Yellow.
• PPM: 1,850 (target <500) — 15 defective parts across 8,100 received. Root cause traced to a single lot of PCB substrates from their Tier-2 supplier that passed incoming inspection but failed after thermal cycling. This reveals a supplier management failure — their incoming inspection missed a latent defect. Red.
• Lead Time: 22 days average (target ≤18 days), standard deviation 6 days. Worsened from Q4 (17 days avg, 3 days SD). The SMT line downtime forced orders into later production slots, extending lead times across the board. Yellow.
• Cost Variance: +1.2% (target ≤0%) — $50,400 in over-contract charges across 3 invoices. Two were premium freight charges the supplier attributed to our late engineering change notice; one remains disputed. This is partially a shared-responsibility issue, partially a supplier billing process gap. Yellow.
• Responsiveness: 6 hours average (target <4 hours) — 31 inquiries logged. However, 8 of 31 (26%) took >24 hours, and 2 took >48 hours. The average is misleading — worst-case responsiveness is the real concern. Yellow.

KPI Scores:

• OTD: Score = (94.2 / 97) × 5 = 4.86 | Green | Weighted: 4.86 × 25 / 100 = 1.215
• PPM: Score = (500 / 1,850) × 5 = 1.35 | Red | Weighted: 1.35 × 25 / 100 = 0.338
• Lead Time: Score = (18 / 22) × 5 = 4.09 | Yellow | Weighted: 4.09 × 20 / 100 = 0.818
• Cost Variance: Score = (5 / 6.2) × 5 = 4.03 (using 1.2% variance and 0% target, treating 1% as baseline tolerance) | Yellow | Weighted: 4.03 × 15 / 100 = 0.605
• Responsiveness: Score = (4 / 6) × 5 = 3.33 | Yellow | Weighted: 3.33 × 15 / 100 = 0.500