Cqi-27 Casting System Assessment Xls |best| Access

Mastering the CQI-27 Casting System Assessment: The Ultimate Guide to Using an XLS Tool for Compliance

The Spreadsheet in the Furnace Room

The meeting room at Prestige Auto Parts was freezing, but Raj felt like he was standing next to a ladle of molten iron.

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. cqi-27 casting system assessment xls

"We found gas porosity in the machining cut," Henderson said, his voice dangerously calm. "It’s a containment issue. If we find one more defect, we stop the line. You know what that means?" Mastering the CQI-27 Casting System Assessment: The Ultimate

Raj knew. It meant millions in warranty costs and a potential black mark that would take years to clean up. Schedule assessment (allow 1 full day per shift

"I can fix the die design," Raj stammered, his mind racing through metallurgical variables. "We can adjust the cooling rates, maybe change the shot profile—"

"I don't want guesses, Raj," Henderson interrupted. "I don't want you to 'fix' it. I want to know if your system is capable of preventing it. I’m sending you a CQI-27 assessment file. You have 48 hours."

He slid a USB drive across the table. On it was a single file: CQI-27_Casting_System_Assessment.xls.

4. Preparation

• Schedule assessment (allow 1 full day per shift for medium sites; adjust for complexity).
• Gather documentation: process flow, control plans, PFMEA, work instructions, material certifications, equipment calibration records, maintenance logs, inspection records, NCRs, corrective action records, training matrix, heat‑treatment charts, melting logs, and previous audit reports.
• Configure XLS: set scoring weights, import site name, assessment date, assessor names, and prepare sections to match site processes.

8. Typical High‑Risk Areas for Casting

• Melt chemistry control and charge calculation errors
• Inconsistent pouring temperature and metal cleanliness
• Core/mold integrity and core print mismatches
• Sand system control (moisture, fines, clay, CBEs)
• Heat treatment cycle inaccuracies and furnace calibration
• Inadequate NDT or sampling plans
• Poor segregation of conforming vs nonconforming parts
• Insufficient maintenance of refractory, ladles, and pouring equipment
• Incomplete material traceability and certification retention
• Training gaps for operators and inspectors