Effective Equipment BOMs and Auditing the Quality of Existing BOMs

Virtual instructor-led (VILT)

18th May, 2022 - 19th May, 2022

1 Participant

12:30 – 17:00 (GMT+8)

2 or more

4 Hours/Day

Early Bird Fee

USD 999

Effective Equipment BOMs and Auditing the Quality of Existing BOMs

Learn the best practices on how to build new BOMs & Audit the effectiveness of existing BOMs.


BOMs are essential for effective asset management, they allow maintenance to find the right spare in a timely manner and saves them searching the whole inventory data base. Without BOMs maintenance effectives is much lower and costly production downtime is increased.

Effective BOMs not only can increased maintenance efficiency, improve maintainers productivity & reduce downtime by identifying the required spare in a timely manner.

Attendees will further improve their practical knowledge on:

  • How to ensure better data from vendors/OEMs (The source Data to Build BOMs)
  • How to use BOMs for obsolete Management : Will show how to check all spares used by an obsolete equipment efficiently
  • How to create effective BOMs : Understand the most effective process to build BOMs
  • Understand the main differences between using Ms Excel and Ms Access
  • How to Audit Existing BOMs and common issues : Identify the issues with your current BOMs. This can only be done effectively using MS Access. Once identified you can fix the issues. BOMs can support the obsolete programe. I.E When an equipment is replaced you can check if those parts are used on other equipment and if not can flag as obsolete.

This 2 half-days online virtual instructor led training(VILT) looks at creating BOMs, their source documents and creating CMMS BOM data upload files. We will show how BOM data from the CMMS is structured and audited and reveal typical findings.

Designed For

This course is designed for people who are involved in CMMS data management (SAP, Maximo, Oracle and etc):
  • Maintenance planners / engineers and support engineers
  • Preventive Maintenance / Equipment Engineers / Spares personnel
  • CMMS Engineers / CMMS IT administrators / CMMS planers or anyone who populated data into CMMS Project
  • Engineers responsible for setting up the spares information in the CMMS
  • Anyone who wants to understand how to achieve an effective CMMS system (same concepts can be used to evaluate Equipment, Assets, PM routines)
  • Companies already with a populated CMMS, considering upgrade of their existing system (e.g Maximo to SAP etc) or considering implementing a CMMS will benefit.

You will Learn

  • Introduction to BOMs
  • Processing the Recommended Spare Parts List
  • Creating BOMs in the Project Phase (MS Excel)
  • Building BOMs Using MS Access
  • Building BOM in the Operational Phase
  • Step by Step BOM Build Process
  • How to Audit Existing BOMs Using MS Access
  • How to use BOMs for obsolete Management
  • Using BOMs to Assign Part Criticality
  • Designing an Improved SPIR/RSPL Form


  • How to create BOMs more effectively
  • How to create BOMs in both MS Excel and MS Access
  • How to audit existing BOM data held in the CMMS
  • What to achieve improved data from vendors
  • The importance of part criticality and how to leverage asset criticalities
  • How to check all spares used by an obsolete equipment efficiently


  • Showed how a Chinese Chemical giant could save $500,000 in inventory stock level from just 10-line items.
  • Taking the highest annual consumption and taking conservative approach we demonstrated $12,000 savings on one spare selected at random, this was much more than the cost of the training.
  • Analysed a company’s BOMs in SAP. Showed a high % of equipment with no BOMs and a high number of spares not assigned to BOMs. This analysis also supported the management of obsolete spare programme.
  • Reviewed the MRO data cleansed by a Canadian Consultant, showed how not only was the cleansing poor but they did not identify 15% of duplicates.
  • Developed and implemented MRO Inventory & Warehouse Audit Process at 4 large Pharmaceutical sites in Europe, highlighting weaknesses in management practices and issues leading to excess stocking.
  • Developed the following tools to support effective MRO spare part management: MRO_Master Data Auditor / MRO_Master Data Cleanser / MRO_BOM Builder and Analyser / MRO_Optimiser/ MRO_Management Practice Auditor.

Online – Virtual instructor-led

ENERGY1 ASIA Virtual instructor-led Training (ONLINE)

Due to the recent developments with COVID-19 we have, for the health and safety of our speakers and attendees, our selected multi-day courses will be delivered live online led by experience practitioners. This will enable you to experience a similar engagement experience to our successful traditional classroom setting which includes exercises, answering your question and provide feedback – all without having to travel anywhere!

old man ten porn fary odd parents porn xnxxforced.com my step mom uncensored what is rainbow kiss, hottest models in porn donna d errico naked hotwifeporn.vip detroit became human porn www xxx h d com, cijiendo con mi prima lesbian squirt in face tubxporn.vip free nude women videos sucking on big tits
lesbian porn with a strapon what does a pussy taste like realcuckoldporn.com mia milkova porn videos imouto bitchi ni shiboraretai, gender bender hentai manga dick drainers full videos milfamatuerporn.com best friends sister porn natalie reynolds leaked onlyfans, amourath only fans leaked lesbians in lingerie porn amerturporn.com t h o t h u b 40 yr old nude women
Need help ?