AWRA OpsHub Search

Supplier Scorecard Calculator

Turn delivery, quality and price data into one comparable supplier score.

Most supplier reviews are a conversation about the last thing that went wrong. A scorecard replaces that with three measured facts — did they deliver on time, was the goods acceptable, did the invoice match the quote — weighted so that reliability outranks price. The result is a number you can put in front of the supplier and defend.

Overall supplier score

Out of 100. Above 90 is a preferred supplier; below 70 needs a corrective plan.

On-time in-full rate
Quality acceptance rate
Price adherence

Updates as you type · nothing leaves your browser

Your numbers

deliveries
deliveries
units
units
value
value

The formula

Score = (On-time% × 0.4) + (Quality% × 0.4) + (Price adherence% × 0.2)

Delivery and quality carry twice the weight of price — a cheap supplier who stops your line is not cheap.

What it means

Supplier Scorecard — full definition

Read in the glossary

How to use it

  1. 1

    Count on-time-in-full deliveries against the requested date, not the revised one. A delivery rescheduled by the supplier is not on time.

  2. 2

    Take accepted units from goods-received and inspection records, so quality reflects what passed rather than what was invoiced.

  3. 3

    Compare invoiced value to quoted value over the same set of orders — the gap is price adherence, and it is where quiet increases hide.

Where it goes wrong

  • A score built from too few deliveries is noise. Ten deliveries is a minimum before the number means anything; a quarter of activity is better.

  • Scoring only your problem suppliers guarantees a distorted panel. Run the same calculation across the whole category, including the ones you assume are fine.

Worked example

The cheap supplier who is not

86 of 100 deliveries on time, 9,820 of 10,000 units accepted, and 462,000 invoiced against 450,000 quoted. That is 86.0% OTIF, 98.2% quality and 97.3% price adherence — an overall score of 93.15. Strong on quality, but the 14 late deliveries are the expediting, the stockouts and the buffer stock that this supplier quietly costs you.

Common questions

Can I change the weightings?

The 40/40/20 split suits most stock-driven operations. Weight quality higher for regulated or safety-critical goods, and price higher only for true commodities where delivery is never in doubt.

What score should trigger action?

Below 70 warrants a documented corrective plan with review dates. Between 70 and 85 belongs on a watch list. Above 90 is preferred-supplier territory and worth consolidating volume into.

How often should suppliers be scored?

Quarterly for strategic suppliers, annually for the tail. Scoring more often than you are willing to act on it just creates reporting work.

Let AWRA do this on your live data

This calculator works on one set of numbers. AWRA OpsHub keeps supplier scorecard calculator results current across every item, supplier and location — automatically.