Skip to content
Shop | Excel system

KPI Systems and Balanced Scorecard System

Catalog, targets, monthly values, scorecard over four views, cause and effect chain, cascade to areas and lines, data quality and effort, deviations, action tracker, half-year system review and audit.

Screenshot of the KPI Systems and Balanced Scorecard System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup holds plant, period, the number of slots and the size of the plant. 03 Catalog is the definition sheet of every figure.
  2. 04 Targets gives every figure a baseline, a target, a tolerance and a reaction limit. 05 Monthly holds twelve periods per figure.
  3. 06 Scorecard shows the four views with status and trend. 07 Chain holds the written expectation between the views and checks it.
  4. 08 Cascade breaks the system down to areas and lines and counts the reported values. 09 Data Quality holds method, effort and the reliability check.
  5. 10 Deviations logs what was outside the limit and why. 11 Actions is the tracker with owner, date and effect.
  6. 12 System Review scores every figure twice a year and proposes keep, fix or retire. 13 Audit holds the 25 statements. 14 Status is the one-page summary.

Definitions used in the workbook

  • Reaction limit: Target minus tolerance when high is better, target plus tolerance when low is better.
  • Reported values: Plant figures plus area figures times areas plus line figures times lines. They come from one set of definitions.
  • Chain link: A written expectation between two figures, with two numbers on each side, so that it can be checked.
  • System review: Five questions per figure twice a year: decision, sheet, source, target, level. Three or fewer yes means fix or retire.

Sheets in the workbook

  1. Start
  2. Setup
  3. Catalog
  4. Targets
  5. Monthly
  6. Scorecard
  7. Chain
  8. Cascade
  9. Data Quality
  10. Deviations
  11. Actions
  12. System Review
  13. Audit
  14. Status

Who it is for

Plant managers and controllers who run one key figure system across plant, areas and lines.

The method behind the numbers

This workbook is part of the KPI Systems and Balanced Scorecard toolkits. The Starter Kit adds the guide and the checklist for the first 30 days. The Excellence Bundle adds playbook, workshop pack, templates, deck and the complete Excel system.

Newsletter

One Lean idea.
Every two weeks.