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

Seven Material Master Fields That Decide Your Plan

How to audit lead time, lot size, safety stock, unit, planning method, planner and price on a sample of 200 materials.

A material record has hundreds of fields. Seven of them decide what the planning run proposes and when. If one of the seven is wrong, the proposal is wrong, no matter how good the other six are.

The rule comes before the check

Before anybody opens a record, write one sentence per field that says when the value counts as correct. Without that sentence, an audit turns into an argument.

Field Counts as correct when Hit rate
Lead time Within 20 percent of the median of the last ten receipts 62 %
Lot size and minimum quantity Matches the supplier agreement or the lot size rule 69 %
Safety stock Calculated by the current rule, not older than twelve months 66 %
Base unit and conversion Matches the unit of delivery, storage and use 94 %
Procurement type and planning method Matches how the material is really sourced and planned 88 %
Planner A person who is still responsible for the material 75 %
Standard price Within 10 percent of the last purchase or cost calculation 82 %

The gear unit plant drew 200 active materials at random from its 18,400 and checked all seven fields. Of 1,400 checks, 1,072 were correct: a field hit rate of 77 percent.

The second number matters more. Only 82 of the 200 records, 41 percent, had all seven fields right. Planning needs them all at once.

Lead time against the receipts

Lead time is both the weakest field and the one with the largest effect. The check is mechanical: take the last ten receipts of the material, count working days from order to receipt, and use the median. One delivery that was six weeks late should not set the rule.

Material System Actual (median) Deviation
H-2210 housing, purchased casting 20 days 34 days -41 %
S-1045 output shaft, manufactured 5 days 9 days -44 %
B-6208 bearing, purchased 10 days 9 days +11 %

The housing H-2210 is used at 6 pieces per day. A lead time 14 days too short releases every order 14 days too late: a gap of 84 housings against a safety stock of 40. Half of that gap arrives by express freight, the rest stops the assembly line. Nobody calls it a data error. It is called a supplier problem.

Lot size against agreement and demand

The system said minimum 50 for the housing. The supplier delivers from 200. Every order was changed by hand, and planning kept calculating with a receipt that never came in that size. The output shaft had a fixed lot of 100 against a demand of 60 per month: each lot covered 1.7 months and doubled the stock for no reason.

How lot sizes and safety stocks are calculated is covered in the Inventory Management series. The point here is simpler: the result of that calculation has to reach the field and stay current.

A rule per material group

Nobody maintains 12,000 purchased parts one by one forever. Write one rule per material group and let the rule fill the field: lead time from the supplier agreement plus goods receipt time, lot size from the method of the group, review once a year.

Then run two queries every month over all active materials, which cost nothing and find a surprising amount: planning fields that are empty, planners who no longer work here, lead times of zero or above 200 days, purchased parts without a supplier, lot sizes above twelve months of demand.

A query can tell you whether a value is plausible. Only a person with a written rule can tell you whether it is true. Repeat the sample every four months, and report the hit rate per field with the owner’s name next to it.

Newsletter

One Lean idea.
Every two weeks.