Skip to content
Shop | Excel system

Engineering Change and Part Approval System

Register, evaluation, board record, run-out plan with three options in EUR, document and master data list, part approval sheet, supplier change log, key figures, trend and audit.

Screenshot of the Engineering Change and Part Approval System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup: report date, targets and lists. 03 Register: every change with class, reason and four dates.
  2. 04 Evaluation: six dimensions, cost and earliest date for one change. 05 Board: the decision record of the weekly meeting.
  3. 06 Run-Out: stock and orders of the old parts and three options in EUR. 07 Documents: every document and data record with owner and date.
  4. 08 Part Approval: measured samples against the limits. 09 Supplier Changes: process and supplier changes, announced or not.
  5. 10 Key Figures and 11 Trend: speed and quality of the process over time.
  6. 12 Audit every three to six months. 13 Status every month.

Definitions used in the workbook

  • Change: Every planned change to something that was released: a document, a part, a process, a tool or a source of supply.
  • Classes: A: form, fit, function or customer affected. B: process, tool, source or supplier. C: documents only.
  • Rush change: A change introduced before evaluation and decision.
  • Lead time: Working days from the request to the closure, Monday to Friday. Plant holidays are not counted.
  • Effectivity: The rule that says from when the new state applies: a fixed date, the run-out of the old parts, or immediately.

Sheets in the workbook

  1. Start
  2. Setup
  3. Register
  4. Evaluation
  5. Board
  6. Run-Out
  7. Documents
  8. Part Approval
  9. Supplier Changes
  10. Key Figures
  11. Trend
  12. Audit
  13. Status

Who it is for

Change coordinators and plant managers who steer changes from the request to the approved part.

The method behind the numbers

This workbook is part of the Engineering Change and Part Approval 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.