A plant does not need more measures. It needs a short set that people act on, each one defined so everybody calculates it the same way. This package gives you both the library and the method.
Most KPI collections are long lists. This one is built to be used: every KPI is defined so two people calculate the same number, every one has a working calculator, and every one names the way it is most often gamed or misread. The guide then shows how to pick a short set from the goals down, and how to react to signals rather than to every red month.
THE EXCEL LIBRARY (8 SHEETS)
KPI Library. 186 KPIs in 13 families: internal quality, customer quality, supplier quality, quality system and compliance, delivery, productivity and equipment, maintenance, cost, inventory and planning, safety health and environment, people, continuous improvement, and launch and development. Each KPI has a code, definition, formula, unit, direction (higher or lower is better), frequency, level (shop floor, plant or executive), data source, and the trap to avoid.
Live calculators. Every one of the 186 KPIs calculates from sample inputs. Overwrite them with your own figures and the result updates.
Scorecard. Up to 24 KPIs over twelve months, with automatic status (on target, watch, off target) against your target and a trend against the previous three months.
Trend Chart. Any scorecard KPI plotted month by month against its target.
KPI Card. Choose any code and print a one-page definition card for the KPI owner, with space to agree target, reaction rule and counter-KPI.
Starter Sets. Tested combinations for the shop floor board, the plant scorecard, the executive dashboard, the quality department and automotive suppliers.
KPI Check. Ten questions, scored automatically, that tell you whether a KPI is ready to publish.
THE POWERPOINT GUIDE (59 SLIDES)
Six modules: why KPIs fail; designing a KPI (definition, leading and lagging, the KPI tree, SQDCP, levels, denominators, data quality, targets); the 13 KPI families with their core measures; running KPIs (tiered meetings, the shop floor board, reaction rules, counter-KPIs, and why a red month is not a signal); a worked case from plant goals to a working scorecard; and answers. Four exercises use the Excel library, with a full answer key. Trainer notes on every slide and a full index of all 186 KPIs.
WHO IT IS FOR
Plant managers, quality and operations managers, continuous improvement leads, Lean Six Sigma Belts and consultants who need to build or clean up a KPI system, prepare a monthly business review, or set up a shop floor board. Strong fit for automotive and other IATF 16949 or ISO 9001 environments.
FORMAT
Two files: one Excel workbook (.xlsx, 8 sheets, no macros, Excel 2016 or later and LibreOffice) and one PowerPoint presentation (.pptx, 16:9, 59 slides, trainer notes, native editable charts). Sample data is fictitious.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Key Performance Indicators, Manufacturing PowerPoint Slides: Manufacturing & Quality KPI Library: 186 KPIs and Scorecard PowerPoint (PPTX) Presentation Slide Deck, Moussa | Six Sigma Tools & Training