Bill Of Materials BOM Development – Case StudyWater Treatment - Canberra, ACT, Australia
The Challenge
As part of an Enterprise Resource Planning (ERP) tool implementation, our client identified the need to establish the bill of materials (BOM) for all their assets to execute practical routine maintenance tasks.
The initial assessment of the data available to undertake this task indicated that it would not be possible to extract data from the legacy system, resulting in a requirement to re-create all BOMs from OEM manuals and invoice histories.
As a result, our client engaged EnterpriseIS to assist with this process and look for ways to improve the BOM development.
The Solution
Following a review of the available data and discussions with crucial maintenance personnel, EnterpriseIS was able to identify a process to extract BOM data from the legacy system. This involved working alongside the clients’ team at each site and central office to conduct the following activities:
• Review and update the client asset register
• Identify the assets for the subsequent shut-down, which were to be used to trial the initial BOM development
• Identify a method of data extraction for legacy system and work with the system administrator to copy this data
• Review copied BOM data for use as a baseline to build the new BOMs
• Development of asset-level BOMs for single-site shut-down
• Coordinate the data upload for new BOMs with the clients ERP administrators
• Conduct introductory training for the client maintenance planning team to use the new BOMs.
The Results
An analysis of expected savings associated with the time take to plan work using the new Bill of Materials showed they would result in:
• Eliminate 90% of current delays sourcing spare parts
• Estimated saving of $493,479 due to efficiency gains in data management
• Identified and rectified 500 items in catalogue data
• Established business improvement processes