Cost Management and Sourcing Using OpenBOM

Oleg Shilovitsky
Oleg Shilovitsky
8 December, 2023 | 3 min for reading
Cost Management and Sourcing Using OpenBOM

Earlier this week, I initiated a conversation about how OpenBOM can significantly streamline your costing process. Cost management should not be an afterthought; it must be an integral part of the design and engineering process. Unfortunately, for many companies, achieving this can be quite challenging due to information silos and limited accessibility.

Cost Calculation and Management is Not Easy

In our experience working with numerous companies, we have identified five reasons why cost information is often not readily available, hindering the ability to assess costs early in the design process. This challenge extends even to larger companies due to the absence of suitable tools and data silos. However, it is especially pronounced in small and medium-sized manufacturing companies and engineering teams, often trapped in the “Excel kingdom” for cost management, which remains a daunting task.

Here are five reasons why cost management poses challenges for most engineering teams and companies we’ve engaged with:

  • Cost information is isolated in Excel and external databases.
  • Cost information about components is not updated in real-time.
  • Managing multiple sourcing (vendor) information is complicated.
  • It is hard to pull an accurate BOM and combine with costing
  • Cost rollup is time-consuming and involves multiple steps.

Catalogs and Multi-sourcing

OpenBOM offers a straightforward method for organizing data related to components, materials, and labor required for cost management. It begins with a centralized database with catalogs containing all items. OpenBOM enables you to create catalogs (item classifications) and manage the cost of each item within a catalog, including multiple sources for purchasing that component. Vendor information is separately managed, resulting in a multi-sourcing data structure within each catalog.

As you can see from the image above, OpenBOM allows you to define items and multiple sourcing options, with one marked as “preferred” for use in the BOM. Full information about each sourcing option is management as well. 

OpenBOM also facilitates tracking the history (revisions) of all items, vendors, and sourcing information, providing cost data as available from suppliers. 

Product Structures (BOM)

OpenBOM provides a mechanism for organizing product structures (BOM) based on item usage (from the catalog) and managing a comprehensive set of reference-instance relationships, which can be instance-based and quantity-based. Information can be automatically extracted from design (CAD) systems, and then adjusted and validated. Additional components, materials, and other elements can be added, resulting in a complete product data set. Applying formulas to the full product structure allows for cost rollup based on supplier settings, unit cost, and BOM data.

You have immediate access to cost information that recalculates when data changes. Simultaneously, this information can be preserved in revisions, ensuring full traceability of BOM revisions and costs, providing you with costs as initially “planned.”

Purchasing Process

OpenBOM offers a mechanism for managing the purchasing process, including order creation and RFQs (Request for Quotation). This facilitates planning the procurement of all components for a specific production batch and enables order management separately. Procurement managers and purchasers can make changes and adjustments within the context of a specific order. This is where costs can be modified based on specific shipment and supplier information. Ultimately, you will obtain a cost as it was “shipped” for assembly.

I will talk about the purchasing process in my next blog. 


In today’s modern digital manufacturing world, Excel is no longer a viable strategy for cost management. What may have worked 10-20 years ago cannot meet the demands of today’s turbulent supply chains and complex products. Each company must transition from outdated Excel documents to a digital format for cost management and sourcing, and this is precisely what OpenBOM offers. There’s no need to install complex systems or set up intricate databases. OpenBOM provides a straightforward way to import data from existing Excel sheets, capture BOMs from CAD, collaborate, validate, calculate, and order parts. It’s simple and user-friendly.

Register for a free trial and experience OpenBOM’s capabilities for yourself for 14 days. Discover how OpenBOM can help your organization today.

Best regards,


Related Posts

Also on OpenBOM

4 6
21 February, 2024

I haven’t had a chance to meet a manufacturing company that was not interested in cost analysis or cost management….

20 February, 2024

I’m excited to share with you the latest updates to OpenBOM. But before we delve into the details, I want…

17 February, 2024

Despite the widespread adoption of digital technologies like computers, mobile devices, the internet, and various digital services, Excel continues to…

16 February, 2024

Dealing with mistakes made by suppliers is a crucial aspect of managing manufacturing processes and ensuring product quality and timely…

16 February, 2024

In the rapidly evolving landscape of modern product development, the complexity and need for collaboration are at an all-time high….

14 February, 2024

Bill of Materials (BOM) management is an essential component of product development, manufacturing, and supply chain management processes. These processes…

13 February, 2024

Newton, MA  – OpenBOM, a leading provider of cloud-based PDM and PLM software helping manufacturing companies to manage their digital…

9 February, 2024

Data is one of the most valuable assets for any product development and manufacturing company in the world. Unfortunately, for…

9 February, 2024

As a manufacturer, sharing product data with your contract manufacturer (CM) or supplier is one of the most important and…

To the top