
How it works
- 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.
- 06 Count Plan sets the counts per class and day and tracks inventory record accuracy per month.
- 07 Ownership names one owner role per planning field. 08 Cleanup tracks the work packages with hours, progress and due dates.
- 09 Key Figures shows nine figures per month against targets and the cost of bad data at the start and after twelve months.
- 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.
- 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
- Start
- Setup
- Field Audit
- Bill Audit
- Routing Audit
- Count Plan
- Ownership
- Cleanup
- Key Figures
- Requirements
- Vendor Comparison
- Go-Live
- Audit
- 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.