Skip to content
Shop | Excel tracker

Business Unit Scorecard

Monthly KPIs and a cost view per production unit, so each unit leader steers safety, quality, delivery and cost.

Screenshot of the Business Unit Scorecard workbook with example data
Example data from the workbook.

How it works

  1. Open 02 Setup. Enter the unit name, the leader and the products. Check the eight KPIs, their targets and whether higher or lower is better.
  2. Fill one row per month in 04 Cost View: good units, sales value and material per unit, operator hours, labor rate, support, energy, scrap and allocated cost.
  3. Fill one row per month in 03 Monthly KPIs. Cost per unit is taken from the cost view. Green means on target, red means off target.
  4. Open 05 Dashboard before the monthly review: last month against target, the cost view, the trends.
  5. Agree the actions of the review in 06 Action Plan, with owner and date.

Definitions used in the workbook

  • Contribution I: Sales value minus material.
  • Contribution II: Contribution I minus unit direct cost: operators, assigned support, energy and consumables, scrap and rework.
  • Unit result: Contribution II minus allocated plant cost.
  • Cost per unit: Material plus unit direct cost plus allocated cost, divided by good units. Period values are weighted by units, never averaged.

Sheets in the workbook

  1. Start
  2. Setup
  3. Monthly KPIs
  4. Cost View
  5. Dashboard
  6. Action Plan

Who it is for

Unit and value stream managers with their own results responsibility.

The method behind the numbers

This workbook is part of the Factory within Factory 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 week.