How OpenBOM Turbocharges Your Product Cost Rollup Process

Oleg Shilovitsky
Oleg Shilovitsky
6 December, 2023 | 2 min for reading
How OpenBOM Turbocharges Your Product Cost Rollup Process

Last month, I wrote an article discussing whether it’s a good idea to store cost and supplier data in CAD systems. Most of my colleagues on LinkedIn agreed that cost info shouldn’t be kept in CAD systems, and I totally agree with them. Cost calculations can be a real headache. Cost info usually comes from different sources: quotes for custom parts, catalog prices for off-the-shelf items, and calculations based on materials and labor costs. But, unfortunately many engineers and manufacturers still use very inefficient method of cost rollups using Excel or other spreadsheets. 

The Problem with Excel:

Many engineering teams use Excel for calculations, but when it comes to figuring out the total cost of a product assembly, Excel falls short. CAD data can be pulled into Excel, but it often doesn’t include all the materials, especially when they come from different sources. Adding unit costs for components and factoring in labor becomes a messy process that both engineering teams and production planners have to deal with.

How OpenBOM Helps:

OpenBOM simplifies cost management by providing three essential tools:

Item Catalogs:

You can create a database of all components, whether they are custom, off-the-shelf, assemblies, labor, or materials. These catalogs help you define unit costs and other essential information. Collaborative tools allow you to share catalogs with contractors and suppliers to keep unit cost data up to date.

Product Structure (BOMs):

OpenBOM lets you create a structured bill of materials that includes all components, sub-assemblies, and extra information needed to build a product. You can generate BOMs automatically from CAD systems with just a click, even if you use multiple CAD systems. You can also add non-CAD elements, labor, and other details to your BOMs.

Cost Rollup Formula:

OpenBOM comes with a formula roll-up mechanism designed to work with structured data. It collects unit information from all levels and sublevels and calculates the cost. You can define different formulas, including specific business logic, and the rollup will pull data and calculate the total cost. You can also exclude certain components or entire assemblies from the calculation.

Collaboration and Cost Changes:

OpenBOM’s collaborative editing tools allow everyone to make changes in catalogs and bring BOM data directly from CAD simultaneously. No one has to wait, and the cost is automatically recalculated. Revision history keeps track of cost changes.

Documentation and future steps

You can check OpenBOM documentation to learn more about formula and rollup management. Check this link. Watch the following video to learn more about cost management: 


OpenBOM offers a practical solution for organizing product information, including suppliers and cost data. Once your data is organized, you can use BOMs created from CAD systems and adjust them manually to calculate costs effectively. 

Give it a try with a 14-day free trial to see how OpenBOM can simplify your cost management.

Best, Oleg

Related Posts

Also on OpenBOM

4 6
14 June, 2024

The Bill of Materials (BOM) serves as a key component of the manufacturing process. The BOM is a comprehensive list…

14 June, 2024

Change is the only constant thing you can see in every engineering and manufacturing process in your organization. Despite the…

13 June, 2024

In every manufacturing business, cost is a critical factor that can determine success or failure. Efficient cost management is essential…

12 June, 2024

In today’s fast-paced manufacturing environment, companies are increasingly seeking ways to work in a more connected and efficient manner. The…

11 June, 2024

In my previous article, I briefly introduced you to upcoming OpenBOM enhancements related to product structure management and the introduction…

8 June, 2024

In the modern manufacturing and supply chain management environment, streamlining processes from engineering to procurement is vital. To support customer…

7 June, 2024

The common story is for manufacturers to outsource production overseas to take advantage of lower costs amongst other things. At…

6 June, 2024

One of the questions that often causes confusion in product development and manufacturing is change management. This topic has many…

5 June, 2024

The last two decades of SaaS development have changed the way customers are buying software. What was before a lengthy…

To the top