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

Inventory Record Accuracy: Count Daily, Repair the Booking

How to measure stock accuracy per location with a tolerance, build a count plan of 80 counts a day and fix the causes instead of the records.

Stock records are master data that changes every minute. Planning subtracts stock from demand, so a wrong record makes every proposal after it wrong, however good the material master is.

Measure per location, not by value

Inventory record accuracy is the share of storage locations where the counted quantity matches the system quantity within a written tolerance. It is not the value difference of the annual physical inventory, where a plus in one aisle cancels a minus in the next and the plant congratulates itself.

The gear unit plant counted 400 of its 9,600 locations across all classes.

Class Tolerance Counted Within tolerance Accuracy
A (high value or critical) Exact 100 71 71 %
B 2 percent 140 108 77 %
C 5 percent 160 133 83 %
Total 400 312 78 %

The A locations, the ones that stop the line, were the worst. That is normal: they move most often, so they are booked most often, and every booking is a chance to be wrong.

Counting does not make stock accurate

Counting finds errors. The booking process creates them. The plant visited each of the 88 deviations and asked why.

Cause Locations Repair
Consumption booked late or by a wrong bill 31 Correct the bills, book at the time of use
Material in a different location than booked 22 Scan location at putaway and transfer
Quantity or unit error at goods receipt 14 Count or weigh at receipt, fix conversions
Scrap and rework not booked 12 Scrap booking at the work center, same shift
Unknown 9 Recount and watch the location

Note the largest cause. Thirty-one of 88 deviations came out of the bill of material and the time of booking, not out of the warehouse at all. Without the cause analysis, the plant would have hired another counter.

The count plan

Daily counting replaces the campaign. Each class gets a frequency, and the plan produces the list of the day, so that the counter does not choose the easy locations.

Class Locations Counts per year Counts
A 960 6 5,760
B 2,400 3 7,200
C 6,240 1 6,240
Total 9,600 19,200

Nineteen thousand two hundred counts in 240 working days are 80 counts per day. At three minutes each that is four hours: one person for half a shift, every day. How the classes are formed is covered in the Inventory Management series.

Five rules that make it work

Count blind, so the counter sees location and material but not the system quantity. Count at a fixed time, before the first picks of the shift. Recount every deviation once before anybody looks for a cause. Write the cause on the sheet with one of five codes, then correct the record. Report accuracy per class every week and the cause Pareto every month.

The order of the last two matters. A deviation found today can be explained today: the pallet is still there, the order is still open, the person remembers. After a week, every deviation is “unknown”, and unknown teaches nothing.

What it is worth

Twelve months later the plant was at 97 percent across all classes. The write-off at the annual inventory fell from EUR 92,000 to EUR 30,000, and the share of assembly orders that started with missing parts fell from 23 to 6 percent.

Where record accuracy holds above the level your auditors and local rules require, daily counting can replace the annual wall-to-wall inventory. That is a question for your auditor, and it is worth asking early.

Newsletter

One Lean idea.
Every two weeks.