A BOM with hundreds of lines: consolidating the tail without changing the total
Most of a bill of materials is cheap parts that together barely move the cost. How to group them so the sheet stays readable, how to keep the total identical, and when grouping destroys the thing you needed.
A bill of materials with hundreds of lines is normal, and a costing sheet with hundreds of lines is unreadable. Those two facts are in tension, and the way people resolve it is usually to stop entering the small lines — which changes the total.
There is a way to shorten the sheet that does not change the total, and a rule for when not to use it.
Long does not mean accurate
In most bills of materials, a small number of lines carry most of the cost and a long tail carries very little. Entering the tail line by line makes the sheet longer without making the total more accurate — the accuracy was already decided by the expensive lines.
So the goal is not fewer lines. It is a sheet where the lines that matter are visible **and the total is unchanged**.
How to group so the total does not move
- Sort the BOM by extended cost, highest first.
- Keep every line that is individually significant as its own line.
- Sum the remaining tail into one line, named so it is obviously a group — and record how many parts it contains.
- Check the total against the ungrouped total. They must match exactly; if they do not, something was dropped rather than grouped.
When not to group
Three cases where the tail must stay expanded, because grouping destroys exactly the information you were after:
- You are comparing two revisions of the same board — the change may be entirely inside the tail.
- You are looking for consolidation opportunities across a product family — that analysis lives in the tail by definition.
- A tail part has supply risk. Its cost is small, its absence stops the line, and inside a group it is invisible.
The third case is the one that catches people. Cost and risk are different axes, and a costing sheet sorted by cost puts the riskiest cheap part at the bottom.
The real benefit is not a shorter sheet
It is that the expensive lines become **visible**. A cost reduction program that reviews every line equally spends most of its effort where there is nothing to find.
Once the sheet shows which lines carry the cost, the same review effort lands where it changes the number — and the tail, correctly summed, is still there in the total rather than quietly missing from it.
Related guides
- PCB assembly cost: components, placements and everything the BOM does not show
Costing an assembled board across all ten categories. Two things separate this trade from the rest: the bill of materials dominates the cost, and machine time tracks placement count rather than board count.
- Placement count and changeover: the two numbers behind an SMT price
SMT assembly cost is driven by how many parts are placed and how often the line is set up. Both are measurable from data the line already produces, and both point at different improvements.
- Six fields almost nobody fills in, and which way each one bends the cost
Material yield, personal and machine allowances, energy, units per pack and fixed cost per lot: six inputs that are usually left empty, and why five of the six make the cost look cheaper than it is.