OpenBOM Calculations & Rollup Improvements: The Key To Cutting Cost & Staying Organized

Oleg Shilovitsky
Oleg Shilovitsky
18 March, 2021 | 3 min for reading
OpenBOM Calculations & Rollup Improvements: The Key To Cutting Cost & Staying Organized

The old saying…”Time Is Money” has never been more true than when you are in the process of product development.  

Every single minute that is mismanaged takes away from your business’s bottom line. In general, Design has a significant monetary impact on the entire product development outcome. 

The ability to predict and fix things early on in the design process can help significantly develop a product with the desired cost, mass, quality, and other parameters reflecting the product requirement. 

Where Are The Savings? 

If I were to tell you that there was a tool out there that was capable of making early calculations related to your product development process that can drastically cut down on your cost, how excited would that make you?  

I’m pretty sure you’d be elated!

The thing is, there are so many engineers and product development organizations that rely solely on Excel spreadsheets to make the early Bill of materials and to manage product data – items and their attributes such as cost, supplier, material, manufacturer, and many others. 

I’m here to tell you that this form of management is outdated and can be costing you big in the long run.  

So What’s The Solution?  

Calculations and formulas are tough. I’m not talking about the SUM function in Excel. That one is easy. Imagine, you have an indented structure and you need to rollup the cost of the product or to calculate the cost of a specific component in all assemblies. In this case, Excel is not your good friend and will come up short in providing you a solution. 

opembom calculations

At OpenBOM, we provide an easy and reliable way to add any data properties and also control how to calculate various things. For example, to rollup cost. OpenBOM automatically calculates the value (eg. Cost) and rolling up the values between sub-assemblies. It is all done with the formula builder. 

But Wait! There’s More…

In a new OpenBOM release, we are expanding rollup formulas to support a very popular Flattened BOM. Check our documentation for information about BOM types. 

In this short video, I made a preview of the new feature related to formula and calculations – support rollups in the flattened BOM need.  

Flatted rollup formula rollup support will allow you to see a granular rollup per each component type across multiple assemblies. In other words, it will sum up all instances of the same item in the BOM and then make the calculation based on these numbers. The feature is expected to roll out in the next OpenBOM release. Stay tuned…

Conclusion 

OpenBOM’s flexible and robust formula and calculation support allow engineers and manufacturing companies to perform an early assessment of the product characteristics (eg. Cost, Mass) and speed up the development process.

New rollup functions coming in the next release will make the process more granular and efficient allowing you to slice and dice cost based on the different components in your product. 

Check it out today – register to OpenBOM for free and start your FREE 14-day professional subscription trial. 

Best, Oleg

Related Posts

Also on OpenBOM

4 6
9 July, 2025

A few days ago, I posted an article titled Is your data BOMable?, where I explored the readiness of your...

8 July, 2025

Let’s be honest – keeping track of accurate Bills of Materials (BOMs) is one of the biggest challenges in engineering...

3 July, 2025

Walk into any engineering office today, and you’ll see it immediately: Excel open on someone’s screen. Spreadsheets have been the...

2 July, 2025

Engineers rarely build entirely new products from scratch. Whether designing machinery, electronics, or high-tech projects, most products are evolutions of...

1 July, 2025

At OpenBOM, our vision has always been clear – to create an open and flexible information model, built using modern...

30 June, 2025

At OpenBOM, we know that managing changes is one of the most critical – and often challenging – aspects of...

27 June, 2025

At OpenBOM, we talk to manufacturing companies of all sizes – startups, mid-sized innovators, and established enterprises, and most of...

26 June, 2025

Products are becoming increasingly complex and teams are distributed across geographies. It brings up a question about how to improve...

25 June, 2025

At OpenBOM, we make engineering data accessible to business functions—procurement planning, supply chain management, cost estimation, and more.But to make...

To the top