We partnered with a consumer goods manufacturer to establish a structured BOM management process. The project involved standardizing material codes, segmenting finished goods (FG), and developing an automated Excel tool to streamline BOM generation.
The company struggled with inconsistent material codes, leading to errors in inventory tracking. There was no formal process for categorizing FG products, making it difficult to understand product relationships. Additionally, the absence of detailed BOMs complicated material management and production planning. This lack of standardization and structure hampered efficiency across departments.
Sanitization of RM, PM
and FG codes
Standard Template for
Material Nomenclature and
Codification
BOM Creation for
Finished Goods
Excel Based Tool for BOM
Generation, Monthly Cost
Tracking
The centralized tracking system and dashboards provided a clear view of PO status, enabling the management team to make informed decisions quickly.
The dynamic Excel Based BOM generation tool simplifies the management of finished goods and their components, reducing errors and saving time.
The Excel-based BOM tool provides precise monthly cost tracking, allowing for timely decision-making and responsiveness to market changes
In the pandemic’s wake, the company quickly repositioned its supply chain