Quality Column

Quality Control Column

Supplier Evaluation System in Practice | From Annual Excel to Real-Time Quality Visibility | MiDFUN

2026.04.01 | MiDFUN Editorial Team

Supplier Evaluation System in Practice: The Upgrade Path from Annual Spreadsheets to Real-Time Quality Visibility

About this article

Supplier evaluation is a core activity of supply-chain quality management, yet most enterprises remain stuck at the stage of an annual Excel scoring sheet. This article analyzes the blind spots of traditional supplier evaluation and proposes a data-driven real-time evaluation framework, paired with the practical application of the MiDFUN SQM supplier quality management system, to help enterprises upgrade from “evaluating once a year” to “real-time quality visibility.”

The Three Blind Spots of Traditional Supplier Evaluation

Supplier evaluation is not a new concept in most enterprises. Both ISO 9001 and IATF 16949 require enterprises to assess and monitor external suppliers. However, when the practice of evaluation stays at the level of an annual Excel spreadsheet, three structural blind spots emerge.

Blind Spot One — The Time Lag of Annual Evaluation

Evaluating once a year means a quality problem may have occurred several months before it is formally recorded. A given supplier may have a string of lot rejections in March, but if the evaluation takes place in December, by year-end the problem may already have been “diluted” within the full-year data. Worse, if the rejected lots have already caused a line stoppage or customer returns, the point deduction in the annual evaluation cannot possibly make up for the actual losses.

An evaluation that lacks timeliness is, in essence, an after-the-fact record rather than a management tool.

Blind Spot Two — High Subjectivity in Scoring

How many points each go to quality, delivery, and cooperativeness? How do you quantify “cooperativeness”? Different evaluators may give wildly different scores to the same supplier. When the evaluation result depends on “which buyer filled out the form” rather than on objective data, the credibility of the evaluation is greatly diminished.

Subjective scoring also gives rise to another problem: the supplier cannot know “why points were deducted,” and therefore cannot make targeted improvements.

Blind Spot Three — Evaluation Results Cannot Drive Procurement Decisions

The most common scenario: the evaluation results come out, a supplier is rated Class D (unqualified), but the procurement department keeps placing orders anyway, possibly because “there is no alternative supplier” or “the price is the lowest.” When evaluation results are decoupled from procurement behavior, evaluation degenerates into a formality and cannot drive substantive improvement in supply-chain quality.

A Data-Driven Supplier Evaluation Framework

To break out of the blind spots of traditional evaluation, the key is to replace human subjective judgment with systematic data, and to turn evaluation from an “annual snapshot” into “continuous monitoring.”

Evaluation Dimension Design: The Q-C-D-S Model

Q-C-D-S is the classic framework for supplier evaluation, breaking evaluation into the four major dimensions of Quality, Cost, Delivery, and Service. Each dimension has its corresponding quantified indicators:

Dimension Specific Quantified Indicators Recommended Weighting
Q Quality IQC pass rate, lot rejection rate, PPM, number of MRB cases, number of customer-return attributions 35-50%
C Cost Price competitiveness, cooperation on annual price reductions, cost of handling defective products 15-20%
D Delivery On-time delivery rate, delivery achievement rate, cooperation rate on urgent insertion orders 20-30%
S Service SCAR response timeliness, technical support capability, document completeness, audit cooperativeness 10-15%

There is no absolute standard for setting the weighting; it must be adjusted to industry characteristics and corporate strategy. In the automotive components industry, quality weighting is usually the highest (required by IATF 16949); the electronics contract-manufacturing industry may place greater emphasis on delivery; while in the food industry, quality and compliance account for the largest share.

Quantified Indicators of the Quality Dimension

The Q dimension is the core of supplier evaluation and also the dimension most easily driven by data. Key indicators include:

  • IQC pass rate: the proportion of lots passing incoming inspection, the most direct indicator reflecting a supplier’s shipment quality. For the IQC digitalization process, see the full explanation in the article IQC Incoming Inspection Digital Transformation.
  • Lot rejection rate: the proportion of lots returned due to quality nonconformance. Lot rejection not only affects production scheduling but also generates rework and logistics costs.
  • PPM (Parts Per Million): the number of defects per million parts, suitable for long-term quality trend tracking in a mass-production environment.
  • Number of MRB cases: the number of cases referred to the Material Review Board, reflecting the frequency of serious quality nonconformances.

These indicators can be automatically calculated in the MiDFUN SQM system from IQC inspection results and nonconformance records, without manual compilation.

Real-Time Evaluation vs. Annual Evaluation: From Snapshot to Continuous Monitoring

Traditional annual evaluation is like taking a static photograph, whereas data-driven real-time evaluation is like continuous video recording. The difference between the two is not merely frequency but a fundamental shift in management logic:

  • Annual evaluation: an after-the-fact review; the problem occurred months ago, and the evaluation result is in the past tense
  • Real-time evaluation: every batch of incoming inspection, every nonconformance record, and every delivery record is immediately incorporated into the evaluation score, and the supplier performance dashboard is visible at any time

The value of real-time evaluation lies in “early warning.” When a supplier’s monthly IQC pass rate declines for two consecutive months, the system can automatically trigger an alert notifying the quality assurance and procurement managers, allowing intervention before the problem escalates.

Evaluation Grades and Action Plans

Evaluation scores need to be translated into concrete management actions to truly take effect. Below is a common A/B/C/D four-grade system:

Grade Score Range Definition Management Strategy
A 90-100 Preferred supplier Increase procurement share, prioritize for new part numbers, reduce IQC inspection frequency (inspection waiver or relaxed sampling)
B 75-89 Qualified supplier Maintain current procurement proportion, standard IQC inspection, periodic review
C 60-74 Watch-list supplier Require submission of an improvement plan (CAR), tighten IQC inspection, restrict new part-number development, re-evaluate within three months
D Below 60 Supplier to be phased out Time-bound improvement (usually 3-6 months), full inspection, initiate alternative supplier development; if not improved by the deadline, remove from the AVL

The MiDFUN SQM system supports customizing classification rules and the corresponding automated actions, for example, when a supplier drops to Class C, the system automatically sends an improvement notification and creates a tracking case.

The Role of the Supplier Collaboration Platform (SQP)

Evaluation results should not remain solely within the enterprise; suppliers also need to know their own performance and direction for improvement. SQP (Supplier Quality Portal) is the key tool that turns evaluation from “one-way scoring” into “two-way collaboration.”

In the MiDFUN SQM + SQP solution, suppliers log into their own dedicated portal through a browser and can perform the following operations:

  • View evaluation scores and trends: understand their real-time scores in each Q-C-D-S dimension, as well as trend changes over the past 12 months
  • Receive improvement notifications: when the enterprise issues a SCAR (Supplier Corrective Action Request) or an 8D report request, the supplier receives and responds to it directly on the SQP
  • Upload quality documents: shipment inspection reports, material certificates, process change notifications (PCN), and so on, all centrally managed on the platform
  • Track improvement progress: the handling progress of open nonconformance cases and the execution status of corrective actions are visible to both parties in real time

The value of the SQP lies in reducing communication costs. Traditional email back-and-forth is prone to missed messages and version confusion; platform-based collaboration ensures that all interactions are recorded, time-stamped, and traceable.

Supplier Management Requirements of IATF 16949 / ISO 9001

Supplier evaluation is not just a self-initiated management activity by enterprises; international quality standards have explicit requirements for it. Below is a summary of the clauses directly related to supplier evaluation:

Standard and Clause Key Requirements
IATF 16949:2016
Clause 8.4.1.2
Supplier selection process: requires assessing the risk to product conformity and uninterrupted supply posed by suppliers, including quality and delivery performance, quality management system assessment, cross-functional decision-making, and software development capability assessment (where applicable). Selection criteria and approval decisions must be retained as documented records.
IATF 16949:2016
Clause 8.4.2.3
Supplier quality management system development: requires the organization to use a risk-based approach to define the minimum acceptable QMS development level and the target level for each supplier. Unless otherwise authorized by the customer, the minimum requirement is to be certified to ISO 9001, with the ultimate goal of obtaining IATF 16949 certification.
ISO 9001:2015
Clause 8.4
Control of externally provided processes, products, and services: requires the organization to determine and apply criteria for the selection, evaluation, and re-evaluation of external suppliers based on their ability to provide products, services, or processes that meet requirements, and to retain the relevant documented information.

From the standpoint of the standards, supplier evaluation must have: clear assessment criteria, documented records, periodic re-evaluation, and a risk-based management approach. While these requirements are “technically feasible” with Excel, as data volumes grow and audit-verification needs arise, the benefits of systematic management are clearly higher. For the full terminology explanation of SQM supplier quality management, refer to the MiDFUN glossary page.

Real Cases: From Excel Evaluation to Systematic Management

Below are the practical experiences of several Taiwanese enterprises upgrading from traditional supplier management to systematic evaluation, spanning different industries and scales:

  • Shih-Hsiang Auto Parts Manufacturing: adopted the MiDFUN SQM + SQP system, establishing a supplier self-service portal that lets suppliers directly view evaluation results and respond to improvement requests.
  • FSP Group: upgraded from Oracle ERP + paper-based management to the MiDFUN supply-chain management system, achieving real-time traceability and supplier performance visualization.
  • Standard Foods: adopted an end-to-end SPC + SQM + COM + SQP integration, achieving integrated management from production-line quality monitoring to the supplier collaboration platform, and establishing a food-safety traceability architecture.
  • Kingston Technology: the global memory leader adopted the MiDFUN SQM + SPC + MSA system, integrating supplier quality management, statistical process control, and measurement system analysis.

Below is a comparison of the key differences before and after adoption:

Management Aspect Before Adoption (Excel / Paper) After Adoption (SQM System)
Evaluation frequency Once a year Updated in real time (automatically calculated per incoming batch)
Data source Manual form filling, recall from memory Automatic calculation by the IQC system, integration of ERP delivery data
Supplier visibility Receive a PDF evaluation report at year-end View scores, improvement notifications, and document management in real time on the SQP
Nonconformance response Email back-and-forth, averaging 5-10 days Online responses on the SQP, with overdue reminders, averaging 2-3 days
Audit evidence Digging through Excel files and email records A complete built-in trail in the system, one-click export of audit reports

Quick Glossary

Abbreviation Full Name Description
SQM Supplier Quality Management Supplier quality management, covering the complete supplier quality management process of evaluation, incoming inspection, nonconformance handling, and more
SQP Supplier Quality Portal Supplier quality portal platform, where suppliers can self-service view evaluation results, respond to improvement requests, and upload documents
Q-C-D-S Quality-Cost-Delivery-Service The four-dimension model of supplier evaluation: quality, cost, delivery, service
AVL Approved Vendor List The list of approved suppliers eligible for procurement, included after passing evaluation
PPM Parts Per Million The number of defects per million parts, an indicator used to quantify a supplier’s long-term quality level

Frequently Asked Questions (FAQ)

Q1: How does a supplier evaluation system differ from an ERP supplier module?

An ERP supplier module mainly manages the procurement process (ordering, receiving, payment), focusing on transaction data. An SQM supplier evaluation system, by contrast, focuses on the quality dimension, integrating IQC incoming inspection data, lot rejection rate, PPM, MRB records, audit results, and other quality indicators, automatically calculating evaluation scores and triggering management actions. The two are usually integrated through an API or an intermediate table, each fulfilling its own role.

Q2: How should evaluation items and weightings be set reasonably?

We recommend adopting the four major dimensions of Q-C-D-S (Quality, Cost, Delivery, Service), with weightings adjusted to industry characteristics. In the automotive components industry, quality usually accounts for 40-50%, delivery 25-30%, cost 15-20%, and service 10%. In the food industry, quality may account for more than 50%. The key is that the weighting be set through cross-departmental (quality assurance, procurement, production) consensus and reviewed regularly.

Q3: With a large number of suppliers, how can evaluation be managed by classification?

We recommend first classifying suppliers by procurement value and quality risk into key suppliers (Class A), important suppliers (Class B), and general suppliers (Class C). Class A suppliers are evaluated monthly and audited annually; Class B quarterly; Class C semi-annually or annually. The MiDFUN SQM system supports automatic classification and differentiated evaluation-frequency settings.

Q4: What is the SQP supplier platform, and how do suppliers use it on their end?

SQP (Supplier Quality Portal) is a supplier self-service portal website. After logging in, suppliers can view their own evaluation scores and trends, receive improvement notifications (SCAR/8D), upload quality documents (inspection reports, certificates), and respond to the progress of nonconformance handling. Suppliers do not need to install software and can operate it through a browser, lowering the barrier to adoption.

Q5: Can MiDFUN’s SQM system customize evaluation forms?

Yes. The MiDFUN SQM system supports customizing evaluation dimensions, indicators, weightings, scoring methods, and evaluation cycles. Enterprises can set different evaluation templates for different supplier categories (raw materials, parts, outsourced processing) and adjust them as management needs change. The system also supports importing historical evaluation data to ensure data continuity.

Still doing supplier evaluation with Excel?

Learn how the MiDFUN SQM supplier quality management system helps enterprises build a data-driven real-time evaluation framework.

Learn About the MiDFUN SQM System


Copyright © 2026 MiDFUN Co., Ltd.. Some rights reserved

Author: Pei-Chi Chiu. First published: 2026-03-31. Type: Quality Management Column

Original link: https://www.midfun.com.tw/qc/supplier-evaluation-system-data-driven-assessment/

This work is released under the Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License (CC BY-NC-ND 4.0). You are welcome to share it freely, provided that you credit the original author, include the original link, do not use it commercially, and do not modify the content.

Suggested citation format: Pei-Chi Chiu (2026). “Supplier Evaluation System in Practice.” MiDFUN Quality Management Column.

Reprint authorization and content inquiries: midfun@midfun.com.tw

   
Scroll to Top
5/21 線上研討會 QMS/QRP 品質內循環