Resource Library/Quality Leadership, Metrics and Management Review/Quality Performance Dashboard
Quality Performance Dashboard
Twelve quality measures on one scorecard, worked out from plain monthly counts: the latest month, the last three and twelve months, the status against your target and the direction of travel.
- Excel
- fillable PDF
- Worked example
- Your logo on it
- Aegis Insights
Page 1 of the PDF. Every resource includes a fully worked example.
The problem it solves
Most small aerospace shops measure quality in five places: the ERP's delivery report, the NCR log, a customer portal, the corrective action list and finance's scrap figure. Each is looked at alone, percentages are averaged when they should be weighted, targets live in someone's head, and nobody can say on the first Monday of the month which measures are off target and which are getting worse. This workbook takes one line of counts a month and turns it into a scorecard: every measure against its target over the last three months, the direction against the three months before, the twelve-month figure and the months on target, with the lines that need action in crimson.
Who uses it
Quality directors and managers who report quality performance, and the general manager who reviews it.
When
Enter the month's counts in the first week of the next month, read the Scorecard at the monthly quality meeting, and take it to management review as the backbone of the data pack (AQL-F03).
Free to use, change and copy, in your own organization or with your clients; add your own logo, keep the Aegis credit. Part of: Quality Performance Kit, Management Review Kit. Clause references: 9.1.3 (with 6.2, 9.1.1, 9.1.2, 9.3.2) (numbers only; use your own licensed copy of the standard).
A management aid, not certification or a registrar audit. Using it does not by itself show conformity to AS9100D or any other standard.
How to put it to work
Chapters of our free guides that use this tool.
- The kit and how its tools connectThe Management Review Kit Handbook, chapter 2
- The kit and how its tools connectThe Quality Performance Kit Handbook, chapter 2
- The inputs, one by oneThe Management Review Kit Handbook, chapter 7
- The monthly quality performance cycleThe Quality Performance Kit Handbook, chapter 3
- Building the data packThe Management Review Kit Handbook, chapter 8
- Choosing what to measureThe Quality Performance Kit Handbook, chapter 5
Related resources
-
Workbook
Management Review Input Data Pack
Every management review input on its own tab, with four quarters of trend, a front Summary that states the decision each input needs, and an index that tells an auditor where every record is.
Excel · PDFFree by email -
Workbook
NCR Trend Analysis Spreadsheet
Turn a plain NCR log into a monthly trend with control limits, Paretos by defect, cause and operation, counts by part, and a one-page summary of what changed and where to look.
Excel · PDFFree by email -
Workbook
Quality Objectives and KPI Register
Every quality objective with its measure, target, owner, resources, action plan and quarterly results; every KPI defined once with its source and where it is reviewed; and a summary that shows what is off track and what has no plan.
Excel · PDFFree download -
Workbook
Cost of Poor Quality Worksheet
Put a dollar figure on quality: prevention, appraisal, internal failure and external failure, month by month and as a share of sales, with the largest elements named and a one-page improvement case with its payback.
Excel · PDFFree by email -
Deck
Executive Quality Recovery Report
Eight slides that tell executives, yours or a customer's, where a quality recovery stands: what happened, how the customer is protected, the cause, the plan, the evidence it is working, the risks and the decisions needed.
PowerPoint · PDFFree by email -
Workbook
Corrective Action Aging and Program Health Dashboard
See at a glance how many corrective actions are open, how old they are, which are late, where they are stuck and how many of the closed ones were shown to work, from one plain CAPA log.
Excel · PDFFree by email
Need more than one resource, or not sure where to start? Book a complimentary 30-minute Aegis Quality Guidance Call. We'll find the tools that fit your situation and a sensible place to start. No sales pressure, no obligation.
These tools help you run the work by hand. When you want the whole picture of your quality system from the records you already keep, that's what the AeroAssure Audit Defense Pack and the IA9100 Transition Gap Analysis do.