The system was generally referred to as the Manufacturing Quality Reporting System. In this environment, there were 13 PCB’s that represented 90% of our typical production volume month to month. We called these the ‘Baker’s Dozen’, and aggregated their results as our primary Quality index or KPI.
Access databases created for testers and technicians to record their yield and repair data. This tool was also used by the production supervisors to monitor their daily results as well as to drill down into the detail data regarding test failures and repair. Along with this tool, routines to pull parametric data from the networked test sets in addition to sneaker-net implemented
For the Quality Council meetings, which were presented to our VP and his staff, the Plant Manager and his staff as well as my manager and any SME’s that we brought in for issues we needed to discuss. The data for this presentation was directly from the same Access database used by manufacturing personnel. The charts were updated in Excel as each product in the Baker’s Dozen had it’s own unique issues. These charts were linked to a PowerPoint presentation that used to present during the Quality Council meeting itself. Additionally, I would print a full package for all attendees prior to the meeting.
There were also tools created for ISO 9001 / TL 9000, Corrective Action (CAR), Quality Assurance Audits, Cabinet Audits and what was affectionately called, the Bone Pile.