Bill Of Materials For Digital Manufacturing

Oleg Shilovitsky
Oleg Shilovitsky
12 April, 2021 | 4 min for reading
Bill Of Materials For Digital Manufacturing

Bill of Materials in Excel is a thing of the past. But for many companies, it is still a long way. If you can make it, you will secure the space in the digital manufacturing future and won’t stay behind. 

If you’ve been following my blog at all, you’ll know by now that a bill of materials (BOM) is a recipe for your product. 

It contains all items, materials, components, assemblies, and everything else needed to create a product. It sounds simple, but because of the high diversity of manufacturing processes, industries, supply chain, and business relationships, a Bill of Materials is not a simple entity. 

The bill of materials explains what, where, how to buy, build, acquire or prepare every item that needs to be included in the product. The bill of materials is needed in every manufacturing process, but the way it’s created, managed, and maintained is changing like everything else in our lives these days.

Back In The Days

The old way of doing things consisted of creating a Bill of Materials in an Excel spreadsheet. 

When the only thing you have is a hammer, everything around you is a nail. If a table is your way of managing a BOM, then I’m sorry to say, your processes will be very limited and cost you a pretty penny. 

So before making the grave mistake of managing your BOM’s in a spreadsheet, I recommend you do some homework and find a better way to manage it. Take some time and check out previous blogs I have written on features that OpenBOM provides customers or better yet try out our 14 Day Trial!

Part Numbering Schema 

Before you start developing your BOM one thing should be on your mind…Part Numbers. The earlier you make the right decision about part numbering the smoother things will go for you. Getting this right, in the beginning, can save you a ton of money and time. 

Adding a Part Number might sound like a cheap thing to do, but it ties together revisions, change process, and many other things. Every new Part Number, as well as Change Process (ECO), can cost a small fortune if you calculate the entire time your company will spend on this. 

Item Records and Multi-Disciplinary Information

Everything to do with BOMs focuses on items. An Item is a universal representation of anything you need to accomplish – it is a data foundation for your process because it will connect all the pieces together.

 Managing Items is absolutely important. Collecting all item information in your company and pulling it together with multiple sources (Excels, legacy databases, drawing sheets) will make a good first step in organizing a single source of truth in your company. 

Start by defining what parameters to manage for each item (eg. Part Number, Description, Cost, Unit Of Measure, Revision, Manufacturer, Supplier, etc.) is a good start. 

Digital World – Move From Syncing to Sharing 

While email was a great way to move from a paper trail to some sort of digital process, it is a limiting factor in the way it organizes your information. By sending data in Excel via email or PDF file, you can very soon lose track of your process and data., revision, file, change or anything else. So, placing the data in the middle and sharing data in real-time is the modern way to work with data. Check for systems that can help you do so by connecting your engineers, contractors, and suppliers together. 

BOM Changes, Revisions, Views 

Companies are relying on digital records to be more accurate and eliminate mistakes. Each time you re-enter data and change it manually, you have a chance of making a mistake. If the process of copy/ export/change is part of the process of work between engineers in the company as well as between contractors and suppliers, it eventually will come to collapse. 

To prevent it, the data needs to be organized, changes need to be managed and revisions preserved to give you the data traceability. If you don’t do it – it is just a matter of time before you lose control. 

There are two aspects of data control – (1) changes/revisions; (2) access control. You need to think about how to track every change and identify the level of data that needs to be shared (eg. Revision and not work-in-progress data).

Second thing is to control who has access to which information. Organizing views can be a good idea and used as a lens to access the data. Then every person based in that role will have the right access. 


The time when BOM was a simple table in Excel or drawing sheet is gone. Companies that still operate this way are basically creating a time bomb for them in the future. The digital transformation is raising many questions, but the main focus is on how to transfer old fashion paper sheet process into a new digital form. A proper organization of product information from the early beginning will allow you to save tons of money in the future. 

Check how OpenBOM can help. Create a FREE OpenBOM Account here. 

Contact us, we will be happy to help. 

Best, Oleg

Related Posts

Also on OpenBOM

4 6
16 July, 2024

Welcome to the OpenBOM What’s New July 2024 release! I hope you’re having a fantastic summer. It’s scorching here in…

15 July, 2024

OpenBOM is excited to announce significant enhancements for our customers with the introduction of the ability to manage xBOM (BOM…

12 July, 2024

Non-recurring engineering (NRE) costs are critical, one-time expenses incurred during the design, development, and testing of a new product before…

12 July, 2024

In the world of cloud-based PLM solutions, “multi-tenancy” is a frequently mentioned term. It’s often presented, especially by major PLM…

10 July, 2024

Talking to many companies, it’s not unusual to hear a familiar refrain: “We don’t have time to solve data management….

9 July, 2024

Product Data Management (PDM) has been around for a long time, but its core functionality has remained largely unchanged. Initially…

5 July, 2024

It is July 4th in the US—a time to relax, reflect, and think about the future. Today, I want to…

4 July, 2024

In the fast-paced world of electronics design, managing content and integrating it with existing data is critical for efficiency and…

3 July, 2024

In today’s highly competitive market, seamless communication and data sharing between departments are crucial for success. One of the common…

To the top