Skip to content
Shop | Excel system

Master Data and ERP Readiness System

Field, bill and routing audits, count plan, ownership matrix, cleanup tracker, key figures, requirement list, vendor comparison and go-live checklist.

Screenshot of the Master Data and ERP Readiness System workbook with example data
Example data from the workbook.

How it works

  1. 02 Setup holds plant, targets and tolerances. 03 Field Audit, 04 Bill Audit and 05 Routing Audit measure accuracy on samples and keep the results of every audit round.
  2. 06 Count Plan sets the counts per class and day and tracks inventory record accuracy per month.
  3. 07 Ownership names one owner role per planning field. 08 Cleanup tracks the work packages with hours, progress and due dates.
  4. 09 Key Figures shows nine figures per month against targets and the cost of bad data at the start and after twelve months.
  5. 10 Requirements holds the requirement list with the answers of three vendors. 11 Vendor Comparison weighs five criteria and compares the cost over seven years.
  6. 12 Go-Live holds 40 criteria with two checks and the decision rule. 13 Audit holds the 25 statements. 14 Status is the one-page summary.

Definitions used in the workbook

  • Routing accuracy: Routings with complete operations on the real work center and with run and setup time within the tolerance, divided by routings checked.
  • Weighted fulfillment: Sum of priority weight (must 3, should 2, nice to have 1) x answer (2 standard, 1 configuration or workaround, 0 not met) divided by the maximum.
  • Go-live decision: Go when all must criteria are met and at least 90 percent of all criteria.

Sheets in the workbook

  1. Start
  2. Setup
  3. Field Audit
  4. Bill Audit
  5. Routing Audit
  6. Count Plan
  7. Ownership
  8. Cleanup
  9. Key Figures
  10. Requirements
  11. Vendor Comparison
  12. Go-Live
  13. Audit
  14. Status

Who it is for

Plants that clean their master data and select or load a new ERP system.

The method behind the numbers

This workbook is part of the Master Data and ERP Readiness 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.