Supplier Scorecard (weekly/monthly KPI template)

Purpose

Use this scorecard to track core supplier KPIs consistently, reduce hidden availability and quality risk, and keep supplier meetings focused on facts and corrective actions — without heavy admin work.

How to score (manual or integratable)

This template captures the raw KPI values. Calculate a weighted composite score to compare suppliers over time using this recommended approach:

1. Normalize each percent-based metric to a 0–100 scale (they already are if entered as percentages).
2. Use suggested weights: On-time delivery 30%, Fill rate 25%, Quality (defect rate converted to score) 25%, Price variance 10%, Responsiveness 10%.
3. For Quality: convert defects into a score = max(0, 100 - (defect ppm normalized to your scale)). Example: if defects are measured as % defective, use (100 - %defective).
4. Composite score = sum(metric_score * weight).

Suggested thresholds (example — adapt to your business):

• Excellent: composite >= 90
• Acceptable: 75–89
• Watch: 60–74 (investigate)
• Poor: < 60 (corrective action required)

One-page meeting report (copy to supplier packet)

The one-page report below is auto-populated from the fields you submit. Use it as the opening slide for supplier review meetings: it summarizes the period, headline score, top issue, agreed actions and owners.

Corrective action template

When a supplier falls into Watch or Poor, use the Corrective Action Plan fields to record: Immediate containment steps, suspected root cause, corrective actions, owner, target completion date, and follow-up verification method.

Note: If you integrate this scorecard with your POS/inventory/quality systems, composite scoring and trend dashboards can be automated. This interactive form stores each submission so you can build a timeline of supplier performance.