Performance review worksheet

Supplier scorecard builder

Score suppliers on the same 1–5 scale. Weights must total 100%, and the weighted result remains traceable to each input.

Browser-local worksheet

Enter your inputs

Nothing is uploaded or saved

Criteria weights

Weights must total 100%. Scores use 1 (weak) through 5 (strong).

Supplier scores

Supplier score inputs
SupplierQualityDeliveryCommercialServiceActions

How to use it

A short, reviewable workflow

  1. 01

    Set criterion weights totaling exactly 100%.

  2. 02

    Score at least two suppliers from 1 (weak) to 5 (strong).

  3. 03

    Review the ranking alongside evidence and escalation thresholds.

Useful for

Common use cases

  • Quarterly business reviews
  • Supplier development prioritization
  • Structured sourcing discussions

Important boundary

What this result cannot decide

Set non-negotiable compliance, safety, quality, and continuity gates outside the weighted score; never let a high average override a failed mandatory requirement.

Model notes

Assumptions and limitations

Assumptions

  • Every criterion uses the same 1–5 direction, where higher is better.
  • Weights reflect current business priorities.
  • Scores are supported by comparable evidence.

Limitations

  • Subjective scoring can encode bias.
  • A weighted average can hide a critical failure.
  • This does not verify evidence or supplier claims.

Questions

Frequently asked

Why must weights total 100%?

It makes the contribution of each criterion explicit and the final score easy to audit.

Can a top score automatically approve a supplier?

No. Use it as decision support alongside due diligence, mandatory gates, and documented evidence.