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…


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
23 July, 2024

Last week, we introduced a new and groundbreaking service – xBOM, designed to support complex product development and lifecycle management….

19 July, 2024

Data is a new oil of the modern digital environment. Therefore the way companies can manage information about their products…

18 July, 2024

OpenBOM, a leading provider of cloud-based PDM and PLM software, announced the expansion of its services to include xBOM and…

18 July, 2024

I’m thrilled to share the launch of OpenBOM’s latest innovation – the xBOM Service. This architecture of xBOM is designed…

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….

To the top