EXCEL TEMPLATE - ENGLISH + ESPAÑOL

SMED: Changeover Reduction

Every changeover is stopped machine time. This template applies the SMED method without a consultant: time it, split internal from external and calculate by itself how many minutes you save per change.

What you get

→ Current changeover analysis

Time every activity of the changeover and mark it internal or external. The template sums times and percentages by itself.

→ Internal vs external, in plain sight

You'll see the number that changes everything: how many minutes are done with the machine stopped that could be done with it running.

→ SMED improvement plan

For each activity you decide: convert to external, improve or keep. With owner and new duration.

→ Before and after, calculated

Downtime before, downtime after, minutes saved and % reduction come out by themselves. The argument for your boss, done.

→ Real pre-filled example

An A→B changeover on a press analysed end to end, with a 51% reduction, so you can copy the mechanics.

→ PDF guide (4 pages)

The SMED method explained without jargon, how to time without making anyone nervous and classic mistakes. EN/ES.

Single bilingual file: headers and instructions in Spanish and English. Calculation cells are locked so nobody breaks the formulas; you only type in the input cells.

What it looks like inside

Current changeover analysis with internal and external activities
Every activity timed and classified: internal (machine stopped) or external.
SMED improvement plan with before, after and % reduction
The plan calculates the before/after by itself: 43 → 21 minutes, 51% less per change.

How it works

  1. Pick a frequent changeover and time every activity once (phone and stopwatch, nothing else).
  2. Mark each activity as internal (machine stopped) or external (machine running). You'll see where the time goes.
  3. Decide an action per activity: anything that can be done externally goes out; the internal ones get improved.
  4. Check the before/after: if you don't cut 30-50% in the first round, there are still hidden internal activities.

Factories that apply SMED well cut their changeovers by 30-60% without spending a euro on machines. All it takes is looking at the changeover with method - and that's what this template gives you.

Who it's for

For the production or continuous improvement manager of an industrial SME with frequent changeovers (presses, injection moulding, machining, packaging) who knows time is lost in changeovers but has never measured it with method.

More templates