Skip to content
Shop | Excel tracker

Shop Floor Board KPI and Action Tracker

Daily KPIs, hour by hour tracking and a problem list behind your shop floor board, with a dashboard for the meeting.

Screenshot of the Shop Floor Board KPI and Action Tracker workbook with example data
Example data from the workbook.

How it works

  1. Open 06 Setup. Enter up to seven KPIs with board row, unit, direction, target and owner. Check the settings for red hours and targets.
  2. Fill one row per shift in 02 Daily KPI Log. Red and green calculate from the target.
  3. Use 03 Hour by Hour for one shift at a time: plan and actual per hour, with the reason for every red hour.
  4. Every red gets a line in 04 Problem List with cause, action, owner and due date before the next meeting.
  5. Read 05 Dashboard in the weekly review: share of green days per KPI, the trend of one KPI, open and overdue problems.

Sheets in the workbook

  1. Start
  2. Daily KPI Log
  3. Hour by Hour
  4. Problem List
  5. Dashboard
  6. Setup

Who it is for

Team leaders and supervisors who run daily shop floor meetings.

The method behind the numbers

This workbook is part of the Visual and Shop Floor Management 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.