A bill of materials is the DNA of a manufactured product. It defines what goes in, how much, and in what sequence. When the BOM is wrong, everything downstream is wrong - and in FMCG production, where margins are thin and volumes are high, "wrong" has a cost measured in thousands per batch.
The Spreadsheet BOM Problem
Most FMCG manufacturers maintain BOMs in spreadsheets. The format varies - sometimes a tab per product, sometimes a master sheet with nested rows - but the limitations are universal: no version control, no approval workflow, no link to live inventory data, no automatic cost rollup.
When a formulation changes - say, the fragrance concentration in a body wash increases from 1.2% to 1.5% - the engineer updates their copy of the spreadsheet. Production may or may not receive the update before the next batch. Procurement may or may not adjust their order quantities. Costing may or may not reflect the higher material input.
The Cascade Effect
A BOM error at the top level cascades through every system that depends on it:
- Production under-reserves materials by the error margin
- Procurement orders quantities that don't match actual need
- Cost estimates diverge from actual production costs
- Variance reports show discrepancies that nobody can explain
If the BOM says a product needs 100g of Component X per unit, but the actual requirement is 120g, then every production run under-reserves by 20%. The compounding effect across thousands of units per batch and dozens of batches per month is significant.
Multi-Level Complexity
In FMCG, many finished goods contain sub-assemblies or intermediate products. A bottled beverage might require a flavoring concentrate that itself has a BOM. A personal care product might use a pre-mixed base. These multi-level BOMs compound the error rate: a mistake at the sub-assembly level propagates to every finished good that uses it.
Version Control as a Safety Net
FalOrb maintains full version history for every BOM. Changes require explicit action. The current version is always linked to live stock data, so material availability calculations reflect the actual requirements. Cost rollups update automatically when component prices change.
When the next batch runs, the production floor is working from the same BOM that procurement used to order materials and that finance used to calculate costs. One source of truth, not three conflicting spreadsheets.
The cost of BOM chaos isn't just the material waste from a single bad batch. It's the accumulated inaccuracy across every system that trusts the BOM to be right.
FalOrb provides multi-level BOM management with version control, auto-costing, and real-time links to live inventory data. One source of truth across production, procurement, and finance.