Captures general information including facility location, date, auditor names, and the casting processes being assessed.
You can build automated scoring logic using standard Excel formulas:
The CQI-27 standard is structured into distinct sections that evaluate both high-level management practices and specific shop-floor operations. 1. Management Responsibility and Quality Planning cqi-27 casting system assessment xls
A: Yes. Organizations like AIAG and other training providers (e.g., TRIGO) offer courses ranging from one-day overviews to multi-day, on-site workshops. These courses typically require participants to have the latest manual and XLS assessment workbook.
: Captures basic data about the casting organization, audited areas, and contact information for auditors and participants. Assessment Results Management Responsibility and Quality Planning A: Yes
A: You can purchase it directly from the AIAG website (aiag.org). Member pricing is typically around $89, while non-member pricing is approximately $276 for a single-user document. It is available in English and Portuguese.
Seated across the table was Mr. Henderson, a supplier quality engineer (SQE) from one of the "Big Three" automakers. He had just slammed a heavy casting—a brake caliper bracket—onto the table. It made a dull, heavy thud. : Captures basic data about the casting organization,
Most foundries use an excel-based workbook (XLS) to complete, document, and share their CQI-27 assessments. The XLS tool automates scoring and simplifies data entry for the audit team. Assessment Structure in the XLS File
"Corrective Action Plan" laid out timelines and owners—bold dates, measurable targets, and a column for verification evidence. For the overdue thermocouple calibration, the action was simple: schedule calibration within 24 hours, confirm via signed certificate, and repeat check on the next three pours to demonstrate control. Another action was more strategic: implement revised sand compaction training to reduce porosity incidents by 50% within three months.