Standardized procedures streamline cycle times and optimize resource use. 🚀 Pro-Tips for Your Next Audit
An XLS file can automatically calculate the overall score, percentage compliance, and flag whether a supplier passes, fails, or needs a corrective action plan (CAP).
Use Data Validation for scoring cells (e.g., limiting inputs to "Satisfactory", "Unsatisfactory", "N/A") to prevent typos and ensure clean data.
Clear identification of non-conforming or quarantined materials. 4. Process Tables (The Technical Core) cqi-27 casting system assessment xls
Ensuring heat lots and raw materials are fully traceable to the final casting.
An organized, automated Excel sheet streamlines the auditing process. Use these design guidelines to build or customize your CQI-27 Excel toolkit: Sheet Architecture
"That," Henderson smiled, "is the point of CQI-27. It’s not about the audit. It’s about whether your system is robust enough to catch the defect before I do." An organized, automated Excel sheet streamlines the auditing
The CQI-27 Excel tool was designed to catch the invisible killers of casting quality. It didn't ask, "Is the part good?" It asked, "Is the environment controlled enough to ensure the part stays good?"
Permanent Mold / Semi-Permanent Mold (Aluminum) Process Table F: Low-Pressure Die Casting (Aluminum)
The Excel workbook is designed to automatically calculate a based on the number of "Satisfactory" ratings relative to the total rated items. Many automotive customers set a minimum acceptable overall conformance rate, often 85% or 90% . A common pass/fail threshold for supplier certification is a minimum overall conformance rate of 90% , combined with the ability to implement effective corrective actions for all identified nonconformances within six months. "Is the part good?" It asked
"An Excel sheet?" Sal scoffed, wiping graphite dust from his hands. "I’ve been pouring metal for thirty years. A spreadsheet doesn’t stop porosity. The operators stop porosity."
| 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 |