# Packaging Supplier Scorecard Worksheet

> Source: https://netray.co/tools/packaging-supplier-scorecard-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable scorecard that weights quality, on-time delivery, price, responsiveness and compliance into one score per packaging supplier.

## Category

supply-chain

## Industry

Packaging and Printing

## Audience

- Buyer
- Supplier quality engineer
- Purchasing manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Supplier

**Key:** supplier

**Type:** text

#### Material

**Key:** category

**Type:** select

**Options:**

- Corrugated boxes
- Labels
- Flexible film
- Folding cartons
- Inks and coatings
- Pallets

#### Rejected lots %

**Key:** ppm

**Type:** number

**Format:** percent

#### On-time delivery %

**Key:** otd

**Type:** number

**Format:** percent

#### Quality score (0-100)

**Key:** q_score

**Type:** number

**Format:** integer

#### Delivery score (0-100)

**Key:** d_score

**Type:** number

**Format:** integer

#### Price score (0-100)

**Key:** p_score

**Type:** number

**Format:** integer

#### Responsiveness (0-100)

**Key:** r_score

**Type:** number

**Format:** integer

#### Compliance and certs (0-100)

**Key:** c_score

**Type:** number

**Format:** integer

#### Weighted score

**Key:** total

**Type:** number

**Expr:** q_score * 0.35 + d_score * 0.25 + p_score * 0.2 + r_score * 0.1 + c_score * 0.1

**Format:** decimal

**Rows:**

**Supplier:** Midland Corrugated

**Category:** Corrugated boxes

**Ppm:** 1.2

**Otd:** 96

**Q score:** 90

**D score:** 92

**P score:** 80

**R score:** 85

**C score:** 90

**Supplier:** Precision Labels Inc

**Category:** Labels

**Ppm:** 0.6

**Otd:** 98

**Q score:** 95

**D score:** 96

**P score:** 70

**R score:** 90

**C score:** 95

**Supplier:** Clearflex Films

**Category:** Flexible film

**Ppm:** 3.1

**Otd:** 88

**Q score:** 72

**D score:** 78

**P score:** 90

**R score:** 70

**C score:** 80

**Supplier:** Summit Cartons

**Category:** Folding cartons

**Ppm:** 2

**Otd:** 93

**Q score:** 82

**D score:** 86

**P score:** 78

**R score:** 80

**C score:** 85

**Supplier:** ColorChem Inks

**Category:** Inks and coatings

**Ppm:** 0.9

**Otd:** 91

**Q score:** 92

**D score:** 82

**P score:** 75

**R score:** 88

**C score:** 92

**Totals:**

#### Average weighted score

**Key:** total

**Agg:** avg

**Format:** decimal

**Notes:** Weights used: quality 35 percent, delivery 25, price 20, responsiveness 10, compliance 10. These are an example. Download to Excel to change the weights to match your supplier policy. Convert rejected lots and on-time percent into the 0-100 scores using your own scoring bands.

## Content

**Intro:** Packaging suppliers fail in different ways, such as late deliveries, colour drift or damaged pallets, and a plain average hides which one hurts you. This scorecard weights the factors you care about and gives one comparable number per supplier.

**Sections:**

#### How to use the scorecard

**Body:** List each supplier and material. Record rejected lot percent and on-time delivery percent for reference, then enter a 0 to 100 score for each factor based on your scoring bands. The weighted score is computed for every row. Review the lowest scores quarterly with the supplier and agree an action plan.

#### Choosing weights and bands

**Body:** Weights should reflect risk. For printed packaging, quality and delivery usually dominate because a rejected lot stops a packing line. Price matters, but a cheap supplier with late deliveries can cost more in line stoppages. Define scoring bands in advance, for example 100 points at 99 percent on-time and fewer points per percentage lost.

**Bullets:**

- Use the same bands for every supplier in a material category
- Take data from receiving inspection and ERP receipts, not memory
- Share the scorecard with the supplier

#### Common mistakes

**Body:** Scorecards fail when scores are subjective, when only price is measured, or when nobody acts on a low score. Another mistake is comparing suppliers of unrelated materials on one list. Keep each category separate and trend the score over time instead of reading a single quarter.

**Cta:** If supplier delivery and receiving data already exist in your ERP, we can help generate this scorecard from it automatically instead of keying scores.

**Faq:**

#### What weights should a supplier scorecard use?

**Answer:** There is no standard. A common starting point puts quality and delivery at roughly half to two thirds of the total, with price, service and compliance sharing the rest. Adjust to your risk and review it when strategy changes.

#### How often should suppliers be scored?

**Answer:** Quarterly is typical for active suppliers, with monthly tracking of raw delivery and rejection data. Critical suppliers may be reviewed more often, especially after a quality incident.

#### What score should trigger action?

**Answer:** Decide thresholds in advance, for example below 70 triggers a corrective action request and below 60 triggers sourcing review. The exact numbers are a policy choice, but they should be written down.

#### Can this support ISO 9001 supplier evaluation?

**Answer:** It can serve as documented evidence of ongoing supplier evaluation, which ISO 9001 expects for externally provided products and services. Your quality system still defines criteria, frequency and records.

## Search terms

packaging supplier scorecard, supplier evaluation template excel, supplier performance scorecard, vendor rating sheet, packaging vendor evaluation, supplier scorecard weighted score, purchasing supplier rating template, label supplier scorecard

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json