I have developed a prototype quality management Excel spreadsheet tool for evaluating, scoring and approving suppliers.

Be sure to join our Quality Managers User Group to download the Excel workbook and the work instructions, which are described below.

Click here to Join our User Group or Download our resources.

Supplier Evaluation & Scoring Calculator Log.xlsx

The following table describes the features in the Supplier Evaluation Excel Workbook, which is shown above.

1. The Active Suppliers field is automatically tallied when a 1 or 0 is entered into Column A.
2. A supplier can be marked active or inactive by entering a 1 or 0 into Column A.
3. The Minimum Score Required to be APPROVED field is user-defined and intended to mean the minimum scored needed to indicate an approved supplier.
4. The Over-all Experience with a supplier is an average score of all suppliers.
5. Enter up to 100 suppliers for evaluation.
6. Enter the date of the last evaluation and the next evaluation date is automatically generated.
7. If the (H) Supplier Score in less than the (C) Minimum Score Required to be APPROVED, then the (G) Approval Status automatically becomes ‘Not-approved’, else the Status becomes ‘Approved’. The ‘Provisional’ column to the right of the Approval Status column is meant to be used for indicating that a supplier ‘Not-approved’ may be used as needed.
8. The average individual Supplier Score.

Supplier Evaluation & Scoring Calculator Log.xlsx

(not within the print area)

The image below shows the Excel columns not intended for printing.

1. The Supplier Evaluation Criteria should be entered into row 1, columns G1 through Q1.
2. The over-all average score and the average score for each supplier is displayed on row 2, columns G1 through Q1.
3. Section (C) shows the individual scores for each supplier.
4. Section (D) shows the individual criteria score for each supplier.

A Supplier Evaluation form is located in the Excel Workbook, Supplier Form tab/worksheet.