Cqi-27 Casting System Assessment Xls ((top)) -

If you supply cast parts—whether aluminum, magnesium, iron, or steel—to major OEMs (Original Equipment Manufacturers) like Ford, GM, or Stellantis, CQI-27 compliance is typically a mandatory contractual requirement. Why Use an XLS (Excel) Format for CQI-27?

"I still hate computers," Sal muttered. "But... I like knowing exactly why we make good parts now."

The 2nd Edition (released in 2018) includes several enhancements for better usability and process coverage: Unlocked Sheets

A detailed review of specific parts to ensure they adhere to control plans. cqi-27 casting system assessment xls

Assessments must be conducted at least once a year . Key Components of the XLS Report

Most XLS templates use the formula: (Total Compliant Items) / (Total Applicable Items) x 100 = Score %

This tab assesses operational discipline on the shop floor. It checks if operators have access to clear work instructions, if raw materials (like ingots and scrap) are properly segregated to prevent contamination, and if non-conforming material is strictly quarantined. 4. Section 3: Equipment and Facilities Key Components of the XLS Report Most XLS

This is the most critical part of the workbook. Depending on the casting method used, the auditor fills out the corresponding process table. These tables list specific parameters that must be monitored, such as: Melt temperature ranges.

Emphasizes defect prevention and variation reduction.

: A summary section indicating compliance levels and highlighting areas for improvement. Process Tables It made a dull

Enter a score of if the element is N/A but has potential future risk.

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.

This core section evaluates the foundational aspects of the quality system specific to casting, such as process document control (FMEAs and Control Plans), scrap rate metrics, corrective actions (like 8D), and skill certifications for key personnel. It ensures the organization has the leadership and basic systems in place before moving to the process details.

Emphasis on tracking tool life (cycles/shots) and executing pre-defined maintenance plans. Quality Assurance:

Strict containment procedures for defective items to prevent accidental shipment. Section 3: Equipment & Facilities