Reconciling BOM to Shop-Floor Consumption
The comparison itself is short arithmetic. Making it mean something is the work.
Standard consumption = good output + rejected units, multiplied by the quantity per unit in the bill. Consumption variance = quantity issued, less returns credited, less standard consumption.
Some difference is expected and allowed for. Process loss, machining allowance, set-up pieces at the start of a run and rejection at inspection are all normal, and a well-kept bill carries an allowance for them. What matters is whether the actual difference sits inside that allowance and stays there period after period.
A gap that widens without any change in product or process points somewhere specific: material issued and never returned, scrap generated and not recorded, output under-reported, or a standard set once and never revisited as the process changed. An auditor treats a persistent, unexplained variance as a control finding, not as a costing curiosity, because it is the one number that shows whether material leaving the store is accounted for.
An example: a bracket uses 1.20 kg of steel per piece, allowance included. The month's output is 10,000 good pieces and 300 rejects, so standard consumption is 12,360 kg. Stores issued 13,100 kg and credited 250 kg of returns, so net issues are 12,850 kg. The 490 kg gap, about 4 per cent, is what has to be explained.
Reading the Bill of Materials
A bill of materials lists each input and the standard quantity needed per unit of output. Reading it correctly means knowing what has already been built into that quantity. It is rarely the theoretical minimum: it usually includes an allowance for the swarf from machining, the offcuts from cutting, the set-up pieces and the expected rejects. Where the allowance is inside the standard, issues compared with it should show only a small variance. Where the bill holds the net quantity and the allowance sits elsewhere, the comparison has to add it back before anything is concluded.
The bill version is the second thing to establish, and it causes most false variances. Bills are revised when a design changes, a supplier changes or a process is improved, and a single period's production may have run under more than one version. Comparing a quarter's issues with the current bill, when an older version applied for part of it, measures the revision rather than the consumption, and the effect can easily exceed any leakage being looked for.
- Allowance inside or outside the standard? Find out before comparing anything.
Check - Which version applied, and from which date? Split the period at each revision.
Check - Unit of measure. A bill in kilograms against issues in sheets or metres needs a conversion that is itself checked.
Check - Sub-assemblies. Explode them to raw material, or compare at the level the stores actually issue.
Check
Actual Issues From Stores
The other side of the comparison is what stores issued, and that record has its own weaknesses. The basic test sets issue slips against the output of the job they were drawn for. It works only where issues are booked to a specific work order; where they go to a general cost centre, the comparison can be made for the period as a whole but not job by job.
Over-issue that is never credited back is the largest distortion. Material drawn in a round quantity because that is how it is packed, with the balance carried back to the store but never entered as a return, shows as consumption that never happened and inflates every variance computed afterwards. Issues booked to the wrong work order are the third weakness: they cancel out in total but not job by job, which is why apparent leakage on one job often disappears when a group of related jobs is looked at together.
The issue figure is only as good as the store's own records, and a stores ledger that has drifted from the bin cards will carry that drift into the comparison. How the two store records are brought back into agreement is covered in stores ledger vs bin card.
Explaining the Variance
Work through the gap in a fixed order, because each explanation has to be exhausted before the next becomes plausible.
- Normal process loss. What the process inherently consumes, measured against the allowance in the standard. If the actual sits inside it, the variance is explained and no further work is needed.
- Rejection and rework. Rejected units used material and produced nothing saleable; reworked units used some material twice. Reconcile to output including rejects, not only to good output.
- Unreturned and misbooked issues. Adjust for balances carried back but not credited, and for issues booked to the wrong job.
- Bill versions and cut-off. Recompute against the version in force, over a window where output and issues cover the same dates.
- The residue. Only what survives all four, and persists across periods, points to material that left without a record.
That last step is reached last, not first. A residue that persists is investigated as a control matter, not reported as a costing variance, because no change to the standard will make it go away. How the accounts carry losses above the normal level is a separate question. Under AS 2 (paragraph 13(a)) and Ind AS 2 (paragraph 16(a)), abnormal amounts of wasted materials, labour or other production costs are kept out of the cost of inventory and charged as an expense in the period in which they arise, while normal, expected process losses stay within the cost of the good units produced. Where a residue looks deliberate rather than careless, the methods change; see how auditors detect inventory fraud and inflated stock statements.
Evidence the Auditor Wants
Three records make the comparison meaningful; a gap in any one leaves the variance unexplainable.
Output
Production records tied to transfers into finished goodsStandard consumption is computed from output, so an output figure taken from a plan, or never tied to what reached finished goods, makes the whole calculation circular.
Returns
Return-to-stores notes against the original issueThe record most often missing. Without it, every surplus carried back to the shelf looks like consumption, and the variance cannot be read at all.
Scrap
Scrap generated against scrap expectedScrap is where the legitimate difference goes. Recorded scrap well below the process norm suggests material leaving unrecorded; well above it suggests good material being thrown away.
Scrap sales are worth tying in as well: weights sold to the scrap dealer over the period should broadly agree with the scrap the floor says it produced. A shortfall there is the same question asked from the other end.
Substitutions need their own record too. When a shortage forces the floor to use a different grade, a thicker sheet or an alternative component, the bill still shows the original input. Unless the substitution is recorded against the job, the comparison shows an over-issue of one material and an unexplained saving on another, and both are wrong. A short substitution register, signed off by production and stores, removes this noise before the auditor finds it.
Running the Reconciliation Yourself
Select part numbers by value and by volume rather than reconciling the whole bill, because the exercise is diagnostic and a full reconciliation costs far more than it reveals. High-value materials show where the money goes; high-volume materials show whether process discipline holds, since a small percentage on a part issued in tens of thousands is a large quantity. Between them, a few dozen part numbers tell most of what a full exercise would.
- Choose the period. A quarter usually averages out batch-to-batch noise better than a month.
- Fix the cut-off. Output and issues must cover exactly the same dates; a mismatch creates a variance out of nothing.
- Pull the bill versions in force across the period, and split at each revision.
- Net off returns and rejects before calculating, then compare against the allowance.
- Repeat next period. One period's gap is a question; the same gap three periods running is an answer.
A mismatched cut-off is the most common reason a first attempt produces alarming results, so check it before anything else. An independent reconciliation is worth commissioning where the variance persists without explanation, where the standards themselves are suspected of being stale, or where the finding will go to a lender. A stock audit for auto components tests consumption against the bills as part of verifying raw material, work in progress and finished stock.
