Supplier Scorecard: Normalised KPIs, Weights & Rank
This lesson is part of the course
In this lesson
You turn raw supplier KPIs (on-time %, defect ppm, price index) into 0–100 scores, weight them with SUMPRODUCT and rank the six suppliers.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Spend Cube: Category × Supplier with SUMIFS Locked
- Supplier Pareto & Tail Spend Locked
- Purchase Price Variance, Cost Reduction & Cost Avoidance Locked
- Supplier Scorecard: Normalised KPIs, Weights & Rank Locked
- Should-Cost Model: What the Part Ought to Cost Locked
- Total Cost of Ownership: Beyond the Unit Price Locked
- Contract Compliance & Maverick Spend Locked
- Tender Evaluation: Price Normalisation & Weighted Award Locked