A comprehensive assessment spreadsheet typically includes several specialized sections:
The primary goal of CQI-27 is to reduce waste, minimize variation, prevent defects, and ensure seamless communication throughout the automotive supply chain. Core Structure of the CQI-27 Assessment
The CQI-27 Excel file is a powerful tool, but it is often misused as a simple checklist. cqi-27 casting system assessment xls
CQI-27 is applicable to any site, anywhere in the automotive supply chain, where customer-specified production or service parts are processed. It was developed by drawing on the collective experiences of OEMs and Tier 1 customers, with requirements designed to directly benefit the entire foundry industry. The standard is built on the principle that a proactive focus on process control is far more effective than end-of-line inspection for preventing defects related to dimensional accuracy, internal density, and surface quality.
Focusing solely on checking off boxes rather than thoroughly inspecting actual shop-floor conditions and process control stability. It was developed by drawing on the collective
Casting is a uniquely complex process, and minor defects can lead to major component failures. CQI-27 was written from the customer's perspective—it focuses on common failure modes that cause non-conforming castings. For foundries, full compliance is a structured way to reduce risk, akin to systematically lowering the Risk Priority Numbers (RPNs) on a Process Failure Mode and Effects Analysis (PFMEA).
: Focuses on sand moisture levels, binder ratios, mold hardness, and core stability. Casting is a uniquely complex process, and minor
: Rigorous control loops lower scrap rates and save significant material costs. Core Components of the CQI-27 Worksheet