Evaluates overall quality management, including operator training, maintenance, and documentation effectiveness.
A standard CQI-27 assessment is divided into distinct sections, each focusing on a specific element of the manufacturing and quality system. When translated into an XLS spreadsheet, these sections are typically organized into individual tabs: 1. Cover Sheet and General Information
Monitoring scrap rates, customer returns, and rework metrics. cqi-27 casting system assessment xls
These tables prescribe the required tolerances for process parameters, define control methods, and specify inspection frequencies for both the process and the resulting parts.
| Clause ID | Process Step | Requirement (from AIAG) | Finding / Observation | Compliance (Drop-down) | Evidence Reference | Action Required | Due Date | |-----------|--------------|-------------------------|----------------------|----------------|--------------------|------------------|-----------| | 2.1.1 | Melting | Furnace temperature uniformity ±15°C | Thermocouple calibration overdue | Non-Compliant | Cal log p.42 | Calibrate by 6/15 | 6/15/2025 | | 2.2.3 | Pouring | Tundish preheat temp logged daily | No log for shift 2 | Requires Action | Shift reports missing | Implement log sheet | 6/10/2025 | Cover Sheet and General Information Monitoring scrap rates,
Focuses on critical parameters such as melting temperatures, pouring conditions, and solidification control.
AIAG CQI-27 Casting System Assessment (2nd Edition) is a specialized quality framework designed to evaluate and improve metal casting processes within the automotive supply chain. Its primary goal is to minimize casting defects through a robust, standardized assessment that should be conducted at least once per year www.cqi-support.de Overview of the CQI-27 Assessment XLS Structure AIAG CQI-27 Casting System Assessment (2nd Edition) is
The Job Audit acts as a vertical slice verification. The auditor selects a specific part number currently in production and tracks it from raw material receipt to final packaging. This ensures that the theoretical procedures documented in Sections 1-3 are actively followed on the shop floor. Designing Excel Formulas for Automated Scoring
Weight certain clauses as “Critical” (e.g., Clauses related to safety-critical casting integrity). Use a multiplier so that failure on a critical clause automatically fails the entire assessment, regardless of total score.