Skip to content
Shop | Excel tracker

Waste Walk and Changeover Tracker

Log waste found on walks and time every changeover step, so you know where the minutes and euros go.

Screenshot of the Waste Walk and Changeover Tracker workbook with example data
Example data from the workbook.

How it works

  1. Open 06 Lists. Set the cost rate in EUR per hour and the production weeks per year, agreed with finance. Enter your areas and machines.
  2. After every waste walk, enter each finding in 02 Waste Log: type, what you saw, how often and how long, or the material cost per week.
  3. Enter every changeover in 03 Changeover Log with internal and external minutes. Mark the phase Before or After the improvement.
  4. Read 04 Dashboard in the weekly review: total waste cost, the most expensive type, changeover time before and after.
  5. Agree one action per week in 05 Action Plan, with owner, date and the expected saving.

Definitions used in the workbook

  • Cost per week: Minutes per week divided by 60 times the cost rate, plus material or other cost per week.
  • Cost per year: Cost per week times production weeks per year.
  • Internal time: Changeover work that needs the machine stopped. This is the changeover time that counts.
  • External time: Changeover work done while the machine still runs.

Sheets in the workbook

  1. Start
  2. Waste Log
  3. Changeover Log
  4. Dashboard
  5. Action Plan
  6. Lists

Who it is for

Supervisors and lean coaches who run waste walks and SMED workshops.

The method behind the numbers

This workbook is part of the Waste Elimination 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.