Supplier evaluation with weighted criteria
Which suppliers deliver reliably, and who needs a condition? The template evaluates against criteria you weight yourself and calculates the score and class.
Examples
Five completed evaluations for orientation, invented values
| Supplier | Service or product group | Quality (1-5) |
|---|---|---|
| Weber Precision Housings Ltd | Milled aluminium housings | 4 |
| Northern Circuit Boards plc | Control boards | 3 |
| Cloud storage provider | Storage for design data | 5 |
| Hansen Haulage | Outbound delivery | 4 |
| Spotless Cleaning & Co. | Building cleaning | 2 |
more columns in the file: Criticality · Evaluated on · Ontime delivery (1-5) · Responsiveness and communication (1-5) · Price and value (1-5) · Environment (1-5) · Information security (1-5) · Decision · Action, condition · Next evaluation · Evaluated by
Extract from the Excel file with example rows · the workbook has 4 sheets, highlighted columns are calculated by the template. The example values are invented.
What the template is for
ISO 9001 clause 8.4 asks you to determine and apply criteria for the evaluation, selection, monitoring of performance and re-evaluation of external providers and to retain the results. The question is whether a provider can meet your requirements.
ISO 14001 looks at outsourced processes and environmental requirements for suppliers, ISO 27001 at information security in supplier relationships (Annex A, controls 5.19 to 5.22). The template has its own criteria for both, which you can switch off by setting their weight to zero.
What is in the file
- An “Instructions” sheet with steps and the rating scale from 1 to 5.
- A “Criteria” sheet with six criteria and their weight in per cent: quality, on-time delivery, responsiveness and communication, price and value, environment, information security. Names and weights can be changed.
- An “Evaluation” sheet with 60 rows: supplier, service, criticality, rating per criterion; the template calculates the weighted overall score and the class (A from 4.0, B from 3.0, otherwise C).
- Columns for decision (approved, with conditions, blocked), action, next evaluation and evaluator; an “Examples” sheet with five suppliers.
How to fill it in
- 1
On the “Criteria” sheet, set the weights so they fit your business; together they must add up to 100 per cent, and the template shows the total.
- 2
Enter all external providers whose performance affects your product, your environmental performance or your information security. Service providers such as cloud providers, calibration services or carriers are included.
- 3
Set the criticality; evaluate critical providers more often and more closely.
- 4
Give a rating for each criterion, based on data where possible: complaints, delivery reliability, response times, evidence such as certificates.
- 5
Derive a decision from the class. For B and C, set an action, such as a supplier meeting, an audit or a second source.
- 6
Enter the date of the next evaluation, annually for critical providers.
The same steps are in the file on the “Instructions” sheet, together with the rating scales and the completed examples.
Common mistakes when filling it in
What most often goes wrong when filling in this file, and how to avoid it.
- Preset weights taken over unchecked
- The weights on the “Criteria” sheet are a suggestion. If you do not run ISO 27001, set information security to 0; together the weights must add up to 100, and if the total is off, the cell turns red.
- A rating invented instead of left blank
- If a criterion does not fit a provider, leave the cell blank: criteria without a rating do not count. A 3 “to be on the safe side” shifts the overall score and with it the class.
- Ratings from memory
- If you rate without figures, you get a class nobody can justify. Before the evaluation, gather the complaints, delivery reliability and response times for the period and derive the ratings from them.
- Class B or C without a decision
- The “Decision” column stays empty or says “Approved” despite class C. Classes B and C need a decision and, next to it, an action, such as a supplier meeting or a condition with a deadline.
- Criticality and next date missing
- Without criticality, you cannot decide how often to evaluate, and without “Next evaluation” the re-evaluation is forgotten. Plan providers marked “High” at least once a year.
What an auditor checks for this clause and which nonconformities they often find is explained on the clause page: ISO 9001, clause 8.4: Suppliers and external providers.
ISO 9001 with IMScollect
In IMScollect you evaluate suppliers in the system, with score, approval and date of the next evaluation, and you handle complaints and supplier audits in the same system.
See it working in one system
In a free demo we show you how these lists work together in IMScollect, with your standards and your questions.
More templates
- ISO 27001Statement of Applicability (SoA)ISO 27001 clause 6.1.3 Information security risk treatment, Annex AExcel templateView
- ISO 9001ISO 14001ISO 27001Risk registerClause 6.1 Actions to address risks and opportunities (ISO 27001 also 6.1.2 and 6.1.3)Excel templateView
- ISO 14001Environmental aspectsISO 14001 clause 6.1.2 Environmental aspectsExcel templateView
- ISO 9001ISO 14001ISO 27001Management reviewClause 9.3 Management reviewWord templateView
