Skip to content
Shop | Excel system

FMEA and Control Plan System

Structure and function analysis, FMEA with action priority, actions, risk profile per process step, linked control plan, change history, lessons log and audit.

Screenshot of the FMEA and Control Plan System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: process, team, dates. 03 Rating Guide: anchors and the priority logic.
  2. 04 Structure: process steps and work elements. 05 Functions: what each step must achieve, with characteristics and requirements.
  3. 06 FMEA: failure chains, controls of today, ratings. The action priority calculates.
  4. 07 Actions: one line per FMEA row with owner, date, proof and new ratings. 08 Risk Profile: priorities per step, before and after.
  5. 09 Control Plan: one line per characteristic with method, frequency and reaction plan. Enter the line number in column Q of 06 FMEA to link them.
  6. 10 Change History and 11 Lessons: every review and every failure that reaches the FMEA.
  7. 12 Audit every three to six months. 13 Status in every review.

Definitions used in the workbook

  • Work element: What acts on the product in a step: machine, person, material, environment. Causes are found here.
  • Special characteristic: A characteristic whose failure has a severity of 9 or 10, or that the customer has marked. The control plan marks it from the linked FMEA rows.
  • Control plan check: Linked: the row points to a control plan line. Missing: a row with High or Medium priority before actions or severity 9 or 10 has no line.
  • Failure coverage: Share of complaints and new failures that were already a row in the FMEA.

Sheets in the workbook

  1. Start
  2. Setup
  3. Rating Guide
  4. Structure
  5. Functions
  6. FMEA
  7. Actions
  8. Risk Profile
  9. Control Plan
  10. Change History
  11. Lessons
  12. Audit
  13. Status

Who it is for

Quality managers and process engineers who keep FMEA and control plan linked and alive.

The method behind the numbers

This workbook is part of the FMEA and Control Plan 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.