Who can we rely on? Supplier performance scorecard for 14 suppliers
One year of purchase order lines scored on OTIF, lead-time reliability and fill rate – and translated into safety-stock decisions.
Business question
Case study 03 showed that most lost sales start with late deliveries. Procurement needed facts for supplier reviews, and planning needed to know which suppliers require more safety stock – and how much.
Data & method
OTIF, on-time rate, fill rate (delivered ÷ ordered), average lead time and its standard deviation in weeks.
0–100 points: 50% OTIF, 25% lead-time reliability, 25% fill rate. Below 55 = high risk, 55–75 = medium, above 75 = low.
SS = z × √(LT × σ²demand + D² × σ²LT) with z = 1.65 (95% service) – including lead-time variability.
Interactive dashboard
OTIF vs. lead-time variability
Supplier ranking
Recommended safety stock – A/B items from high-risk suppliers
Key findings
are high-risk suppliers: OTIF between 55% and 75% and lead times that vary by more than a week.
lost revenue in one year is linked to late or short deliveries from these four suppliers – 69% of all supplier-caused losses.
The most reliable supplier reaches 93% OTIF – proof that the network can perform; the gap is supplier-specific.
of extra safety stock on 42 A/B items would protect against roughly €95k of lost sales per year.
Recommendations
Quarterly reviews with high-risk suppliers
Share the scorecard, agree on OTIF targets and root causes (capacity, transport, order lead times) and follow up every quarter.
Variability-based safety stock
Use the formula above for A/B items from risky suppliers instead of a flat week; reduce it again once OTIF improves.
Second source for critical A items
For the top lost-sales SKUs from high-risk suppliers, qualify a second source together with Procurement.
Monthly scorecard in the planning routine
Automate the scorecard from purchase order data (SQL + dashboard) so it takes minutes, not a day, to update.
Data
All purchase order lines with promised and actual lead time, ordered and delivered quantity: