← All Tools & Templates

Supplier Performance Scorecard Excel Template | Free

About this template

Free Supplier Performance Scorecard Excel workbook for measuring supplier performance, OTIF, quality, fill rate, lead-time adherence and price variance.

Stop managing supplier performance by gut feeling.

Most companies already know which suppliers are causing problems. The challenge is proving it with consistent, measurable data.

Delivery dates might be sitting in your ERP. Defect information could be in quality records. Price increases may be buried in invoices. When the quarterly supplier review arrives, the discussion can quickly become based on memory, opinions and whoever complains the loudest.

The Smart Supply Hub Supplier Performance Scorecard turns your purchase order history into a measurable supplier performance score out of 100.

You provide the PO data you already have. The workbook calculates the supplier KPIs, compares suppliers, identifies underperformers and creates a ranking you can use for supplier reviews, sourcing decisions and corrective actions.

What Is a Supplier Performance Scorecard?

A supplier performance scorecard is a structured way to measure and compare suppliers using predefined supplier KPIs.

Instead of asking: “Is this supplier performing well?”

You can answer: “This supplier achieved 72/100, with 61% OTIF, 94% quality and an average lead-time variance of +4.2 days.”

The workbook converts individual purchase order performance into supplier-level metrics and combines those metrics into an overall supplier performance score.

It is designed for procurement teams, supply chain managers, purchasing departments, operations teams and small to medium-sized businesses that want a practical supplier evaluation system without needing a dedicated procurement analytics platform.

What Does the Supplier Performance Scorecard Measure?

The workbook measures seven key supplier performance metrics.

1. On-Time Delivery

Measures whether the supplier delivered the purchase order on or before the required delivery date.

An optional grace period can be applied where appropriate.

On-Time % = On-Time Purchase Orders ÷ Eligible Purchase Orders × 100

2. In-Full Delivery

Measures whether the supplier delivered the required quantity.

A configurable under-delivery tolerance can be used where your business allows small quantity variances.

3. OTIF — On Time In Full

OTIF combines delivery timing and quantity.

A purchase order is considered OTIF only when it is:

On time + delivered in full

This is particularly useful because a supplier can deliver on time but still create an operational problem by delivering insufficient quantities.

OTIF % = OTIF Purchase Orders ÷ Eligible Purchase Orders × 100

4. Supplier Quality %

Measures the proportion of received units that were free from defects.

Quality % = Defect-Free Units ÷ Units Received × 100

This allows you to identify suppliers whose delivery performance looks acceptable but whose products are creating quality problems.

5. Fill Rate %

Measures how much of the ordered quantity was actually received.

Fill Rate % = Units Received ÷ Units Ordered × 100

Fill rate provides additional visibility into short shipments that may otherwise be hidden by an overall supplier score.

6. Lead-Time Variance

Compares the supplier’s actual delivery lead time with its quoted or agreed lead time.

Lead-Time Variance = Actual Lead Time − Quoted Lead Time

A positive result means the supplier took longer than promised.

For example:

• Quoted lead time: 10 days
• Actual lead time: 15 days
• Lead-time variance: +5 days

The workbook scores lead-time performance against defined tolerances rather than treating every delay as identical.

7. Price Variance %

Measures the difference between the actual unit price and the agreed supplier price.

Price Variance % = (Actual Unit Price − Agreed Unit Price) ÷ Agreed Unit Price × 100

A positive variance indicates that the actual price paid was higher than the agreed price.

This can help identify supplier price creep that may otherwise remain hidden in invoice data.

How Is the Supplier Score Calculated?

The individual supplier KPIs are combined into a weighted score out of 100.

The default weighting is:

• OTIF – 30%
• Quality – 25%
• Fill Rate – 15%
• Lead-Time Adherence – 15%
• Price Adherence – 15%
• Total – 100%

 The weighting can be adapted to suit different procurement and supply chain priorities ” The weighting can be modified in the settings sheet”.

For example, a manufacturer with strict product-quality requirements may choose to place greater emphasis on quality, while a distribution business may place greater emphasis on OTIF and lead-time performance.

Lead-time and price performance are evaluated against defined tolerances rather than using a simple pass/fail approach.

A supplier averaging one day late should not necessarily receive the same penalty as a supplier averaging six days late.

What Data Do You Need?

You don’t need to create a new supplier survey or manually collect another set of KPIs.

The workbook uses standard purchase order and receiving information.

You need:

• Supplier
• PO number
• PO date
• Required delivery date
• Actual delivery date
• Ordered quantity
• Received quantity
• Defect quantity
• Invoice value
• Quoted lead time
• Actual unit price
• Agreed unit price

If you can export your purchase order history from your ERP, purchasing system or existing Excel files, you can use the workbook.

Supported workflow

1. ERP / Purchasing System
2. Export PO History
3. Paste into Excel
4. Supplier Performance Scorecard
5. Supplier KPIs
6. Supplier Ranking
7. Corrective Action / Sourcing Decision

What Does the Excel Supplier Scorecard Produce?

The workbook provides supplier performance analysis at three levels.

Purchase Order Level

Each PO is individually evaluated.

The workbook calculates:

• Actual lead time
• Lead-time variance
• On-time status
• In-full status
• OTIF status
• Fill rate
• Quality percentage
• Price variance

This provides an audit trail when a supplier disputes its performance score.

Instead of saying: “Your deliveries have been poor.”

You can identify the specific purchase orders that caused the result.

Supplier Level

Each supplier receives a complete performance profile.

The scorecard calculates:

• Number of POs
• Total supplier spend
• On-time %
• In-full %
• OTIF %
• Quality %
• Fill rate %
• Average lead-time variance
• Average price variance
• Lead-time score
• Price score
• Weighted supplier score
• Supplier rank
• Performance rating

Suppliers can then be automatically ranked.

For example:

1. 🥇 Alpha Components — 93.9/100
2. 🥈 Evergreen Logistics — 93.8/100
3. 🥉 Cygnus Metals — 84.7/100

Supplier Performance Dashboard

The portfolio dashboard provides a management-level view of supplier performance.

It includes:

• Total suppliers
• Total supplier spend
• Overall OTIF
• Overall quality
• Supplier count
• Red-flagged suppliers
• Supplier rankings
• Supplier performance ratings

The workbook also includes visual comparisons of supplier scores and key performance indicators such as:

OTIF vs Quality vs Fill Rate

This allows you to quickly identify why a supplier is performing well or poorly.

Supplier Performance Watchlist

The workbook automatically identifies suppliers requiring attention.

For example:🔴 Borealis Plastics — 38.5/100

Corrective action required. OTIF performance was 0%, average delivery exceeded quoted lead time by more than five days, and average pricing was approximately 7% above the agreed price.

Instead of manually analysing dozens of purchase orders before every supplier review, the workbook brings the exceptions to the surface.

Supplier Performance Ratings

The scorecard categorises suppliers according to their overall performance.

For example:

• 🟢 Preferred — Strong performance and suitable for additional volume
• 🔵 Approved — Acceptable performance but should be monitored
• 🟡 Monitor — Performance requires attention
• 🔴 Corrective Action — Supplier performance requires formal intervention

The thresholds can be configured to match your organisation’s supplier management policy.

Example: Supplier Performance Analysis

The workbook includes 25 example purchase orders across five suppliers so you can see how the system works before entering your own data.

Alpha Components — 93.9/100 🟢

Four of five orders arrived on time and all five were delivered in full.

Lead time averaged slightly better than the supplier’s quoted commitment, while pricing remained slightly below the agreed price.

Result: Preferred supplier.

Evergreen Logistics — 93.8/100 🟢

Evergreen achieved a score almost identical to Alpha, but through a different performance profile.

Its shorter lead times offset a small short-shipment.

The KPI comparison shows exactly where the two suppliers differ.

Result: Preferred supplier.

Cygnus Metals — 84.7/100 🔵

Cygnus performed well overall, but one order delivered 175 units against 180 ordered.

The supplier therefore failed the in-full criterion on that PO.

Result: Approved — monitor.

This illustrates why supplier performance should be measured across multiple KPIs rather than relying on a single metric.

Delta Electricals — 65.6/100 🔴

Quality remained strong at 98.6%, but only one of five orders achieved OTIF and prices averaged approximately 2.5% above the agreed price.

Result: Corrective action required.

The supplier would have looked acceptable if quality was the only KPI being measured.

Borealis Plastics — 38.5/100 🔴

Borealis achieved zero OTIF performance across the five example orders.

Deliveries averaged more than five days beyond quoted lead time, short shipments occurred consistently and prices were approximately 7% above the agreed price.

Result: Corrective action required.

The data provides a defensible basis for the supplier discussion.

When Should You Use a Supplier Performance Scorecard?

Quarterly Supplier Reviews

Enter the supplier review with measurable performance data rather than opinions.

Identify:

• OTIF failures
• Quality issues
• Short shipments
• Lead-time problems
• Price deviations

Supplier Selection and Sourcing

When two suppliers offer similar pricing, supplier performance data can help determine which supplier represents the lower operational risk.

Price should not be considered in isolation.

A cheaper supplier that consistently delivers late or short may cost the business more than a slightly more expensive reliable supplier.

Supplier Consolidation

When reducing the number of suppliers, the scorecard provides a consistent method for comparing supplier performance.

Instead of asking: “Which supplier do we like?”

You can ask: “Which suppliers consistently provide the best combination of delivery, quality, quantity, lead time and price performance?”

Supplier Corrective Action

Use the scorecard to identify suppliers below your performance threshold and determine which KPI is driving the problem.

The scorecard can provide evidence for:

• Corrective Action Plans
• Supplier Improvement Plans
• Performance reviews
• Escalations
• Contract discussions

Management and Executive Reporting

Turn detailed PO data into a small number of management KPIs.

For example:

• Overall Supplier OTIF: 86.4%
• Overall Supplier Quality: 98.1%
• Red-Flagged Suppliers: 4
• Total Supplier Spend: $2.84M

This gives management a portfolio-level view without requiring them to analyse individual purchase orders.

Why Use Excel for Supplier Performance Management?

You don’t need an expensive procurement analytics platform to start measuring supplier performance.

This workbook is designed for businesses that already have purchasing and receiving data but need a structured way to analyse it.

Advantages

• No ERP integration required
• Uses existing PO data
• No supplier questionnaire required
• Automated calculations
• Supplier ranking
• KPI dashboard
• Configurable scoring
• PO-level audit trail
• Works with standard Excel data
• Suitable for small and medium-sized businesses

Important Limitations

The workbook is designed for supplier performance analysis and operational decision-making. It does not replace an ERP, procurement system, supplier relationship management platform or quality management system.

Results depend on the accuracy and completeness of the underlying purchase order, receiving, quality and pricing data.

Businesses should also configure KPI weights, tolerances and performance thresholds to reflect their own supplier agreements and operating requirements.

The default weighting is a starting point rather than a universal supplier evaluation standard. ” The weighting can be modified in the settings sheet”.

Who Is This Supplier Scorecard For?

This Excel supplier performance template is suitable for:

• Small businesses
• Medium-sized businesses
• Procurement teams
• Purchasing managers
• Supply chain managers
• Operations managers
• Supply planners
• Warehouse managers
• Inventory managers
• Manufacturing businesses
• Wholesalers
• Distributors
• Retail businesses

It is particularly useful for businesses that manage multiple suppliers but don’t have a dedicated supplier performance management system.

Frequently Asked Questions

What is a supplier performance scorecard?

A supplier performance scorecard is a structured method for measuring supplier performance against predefined KPIs such as OTIF, quality, fill rate, lead-time adherence and price adherence.

What are the most important supplier performance KPIs?

Common supplier KPIs include OTIF, on-time delivery, in-full delivery, quality, fill rate, lead-time adherence and price variance. The appropriate weighting depends on the business and supplier relationship.

How do you calculate supplier OTIF?

OTIF measures whether an order was delivered both on time and in full. The OTIF percentage is calculated by dividing the number of orders that met both conditions by the total number of eligible orders.

How do you score supplier performance out of 100?

Supplier KPIs can be converted into individual scores and combined using predefined weights. For example, a business could assign 30% to OTIF, 25% to quality, 15% to fill rate, 15% to lead-time adherence and 15% to price adherence.

Can I use this supplier scorecard with ERP data?

Yes. The workbook is designed around standard purchase order and receiving information. Data can be exported from an ERP or purchasing system and entered into the workbook.

Is this supplier performance scorecard free?

Yes. Smart Supply Hub provides this Excel supplier performance scorecard as a free resource.

Can I customise the supplier KPI weights?

Yes. The scoring methodology can be configured so businesses can place greater or lesser importance on OTIF, quality, fill rate, lead time and price performance.

Download the Free Supplier Performance Scorecard

Turn your purchase order history into measurable supplier performance data.

Download the free Excel workbook and start measuring your suppliers using data you already have.

How to use it

Download the file, open it in Excel or Google Sheets, and replace the sample inputs with your own data — calculated fields update automatically. Cells you should edit are highlighted; everything else is formula-driven. If anything is unclear, contact us and we’ll point you in the right direction.