Skip to content
Shop | Excel system

Changeover Reduction System

Pilot selection, step list, stages, ideas with cost, a standard for two people, log, trend, batch size effect, business case and audit.

Screenshot of the Changeover Reduction System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: machine, time, cost and targets. 03 Machines: compare your machines and choose the pilot.
  2. 04 Steps and 05 Stages: the recorded changeover, the split and the effect of each stage.
  3. 06 Ideas: every lever with minutes, cost, owner and status. 07 Standard: the sequence for two people.
  4. 08 Log and 09 Trend: every changeover and the weekly average and range.
  5. 10 Batch Size and 11 Business Case: what the gain is used for and what it pays.
  6. 12 Audit every three months. 13 Status every week.

Definitions used in the workbook

  • Changeover time: From the last good part of the old job to the first good part of the new job at full speed.
  • Interval: Days until every part of the machine has been produced once: number of parts / changeovers per day.
  • Cycle stock: Half the batch on average: interval / 2 x demand per day.

Sheets in the workbook

  1. Start
  2. Setup
  3. Machines
  4. Steps
  5. Stages
  6. Ideas
  7. Standard
  8. Log
  9. Trend
  10. Batch Size
  11. Business Case
  12. Audit
  13. Status

Who it is for

Production managers and lean leads who roll out quick changeover to several machines.

The method behind the numbers

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