The CQI-27 includes specific tables for different casting methods. Your XLS should include the specific table relevant to your facility: Sand Casting (Iron/Steel) Table B: Centrifugal Casting Table C: Investment Casting Table D: Aluminum Die Casting Table E: Semi-Solid Molding Best Practices for a Successful Assessment
A well-constructed CQI-27 XLS tool contains several critical modules. First, the logs essential metadata: supplier name, casting process type, audit date, and cross-functional team members. Second, the Core Question Bank replicates the 100+ verification points of the standard, covering furnace controls, shot profiles, die cooling, and heat treat verification. Third, the Scoring Matrix automatically calculates category-specific scores (e.g., “Metal Handling” at 92% vs. “Inspection” at 78%). Finally, the Action Log Dashboard consolidates all non-conformances into a prioritized corrective action plan, complete with due dates and responsible parties. This structure ensures that the assessment is not just a grade but a roadmap for continuous improvement.
Names and contact details for both internal and external assessors. 2. Process Tables (A through J)
This is where the "XLS" format becomes vital. CQI-27 uses specific for different casting methods. Each table lists the "Process Parameters" (like melt temperature, cycle time, or chemistry control) and the "Job Audit" requirements. Key Requirements for Compliance
A comprehensive assessment spreadsheet typically includes several specialized sections: