Skip to content
Master Data and ERP Readiness | Part 1 of 8

What Bad Master Data Costs Your Plant Every Year

How to turn complaints about the planning system into one number in EUR, from six cost items that already exist in your reports.

Nobody books a cost to “wrong lead time”. That is why master data work never gets people or time, while everyone agrees that the data is bad. The money is real, but it hides in freight invoices, waiting hours, stock and corrections.

Six items that already exist

A plant for gear units with 320 employees, revenue EUR 68 million and 18,400 active material numbers collected six items in one week, each from a source that already existed.

Cost item Calculation EUR per year
Express freight for missing parts Freight invoices of twelve months 186,000
Assembly hours lost waiting for parts 2,400 h x EUR 48 115,200
Carrying cost of excess stock EUR 1.4 million x 9 % 126,000
Write-off at the annual physical inventory Inventory result 92,000
Planner time for manual corrections 6 x 30 % x 1,600 h x EUR 55 158,400
Rework and wrong picks from wrong bills Quality cost report 64,000
Total 1.1 percent of revenue 741,600

None of these six items appears in any report under the heading master data. Together they are more than the plant spends on its entire planning department.

Where to get each number

Freight. Take express and special freight of the last twelve months from the invoices and subtract the cases with a clear external cause, such as a supplier fire or a customs delay. What remains is mostly ordered too late.

Waiting. Assembly and production know exactly how many hours they lose because a part is missing. Take it from the shift reports, or run a two-week tally with one line per stop.

Excess stock. Stock above twelve months of demand, valued, times your carrying cost rate. The gear unit plant used 9 percent for capital, space and risk.

Write-off. The result of the last physical inventory, the part that is written off and not explained by a known cause.

Planner time. Ask every planner and buyer what share of the week goes into correcting what the system proposes: changing dates by hand, calling suppliers about quantities nobody ordered, keeping a private list beside the system. Six planners said 30 percent.

Rework and wrong picks. From the quality cost report, the cases where the cause is a wrong bill of material or a wrong component.

Rough is enough

The number does not have to be exact. It has to be accepted by controlling and large enough to free two people for a year. Write every assumption next to its number, in one line, so that nobody can argue the total away without arguing against a specific assumption.

In the example plant, two assumptions were challenged: the carrying cost rate and the planner share. Controlling lowered the rate from 12 to 9 percent, and the planners logged one week to confirm the 30 percent. The total fell from EUR 798,000 to EUR 741,600 and was then accepted by the plant manager.

What the number buys

With EUR 741,600 on the table, the request changes. It is no longer “we would like to clean up the data”, it is “we can take back half of this within a year, and it costs two people”. The gear unit plant freed two data stewards for twelve months and gave each field owner two hours per week. The cleanup took 3,183 hours, EUR 175,065 at EUR 55 per hour.

Twelve months later the same six items came to EUR 305,560. The saving of EUR 436,040 per year paid back the effort in less than five months.

Before you start

Collect the number before the first audit. Measuring accuracy without a cost attached produces an interesting report. Measuring it with EUR 741,600 attached produces a project.

Newsletter

One Lean idea.
Every two weeks.