Skip to content
Shop | Excel tracker

Master Data Audit Workbook

Field audit on a sample with hit rate per field, bill of material check, count check with accuracy by class and causes, and the cost of bad data in EUR.

Screenshot of the Master Data Audit Workbook workbook with example data
Example data from the workbook.

How it works

  1. Open 02 Setup. Enter the plant, revenue, the targets and the count tolerances per class.
  2. Draw a random sample of active materials. In 03 Field Audit enter 1 or 0 per field against your written rules.
  3. Check bills of material at the bench. In 04 Bill Check enter lines, wrong lines and the main error per bill.
  4. Count storage locations blind. In 05 Count Check enter system quantity, counted quantity and the cause of every deviation.
  5. Collect the six cost items in 06 Cost of Bad Data. Read 07 Status and hang the numbers on the wall.

Definitions used in the workbook

  • Field hit rate: Correct field checks divided by all field checks of the sample.
  • Bill of material accuracy: Bills without any wrong line divided by bills checked. Line accuracy is shown next to it and is always much higher.
  • Inventory record accuracy: Locations where the counted quantity matches the system quantity within the tolerance of the class, divided by locations counted.

Sheets in the workbook

  1. Start
  2. Setup
  3. Field Audit
  4. Bill Check
  5. Count Check
  6. Cost of Bad Data
  7. Status

Who it is for

Planners, buyers and logistics managers who want to know how good their master data really is.

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.