How To Video: Create a Cost Rollup Using OpenBOM

Oleg Shilovitsky
Oleg Shilovitsky
20 December, 2024 | 2 min for reading
How To Video: Create a Cost Rollup Using OpenBOM

There is no single company in the world that will tell you that BOM cost is not important. However, when you ask how they perform cost calculations and estimations, the common answer involves spreadsheets, CSV files, or other manual methods. Surprisingly, even billion-dollar PLM product suites often fail to provide effective solutions for cost calculations.

At OpenBOM, we address this problem with a simple and effective cost rollup mechanism using OpenBOM formulas. This guide will walk you through the process step-by-step.

Learn Through a Video

In this video tutorial, you will learn how to perform a simple BOM cost rollup using OpenBOM’s formula mechanism. We will build on the BOM created in the previous lesson by adding calculated properties and formulas.

Watch the video – BOM Cost Rollup 

Step-by-Step Instructions

These are properties you need to perform a rollup, you need:

  1. A property to represent a “unit” value (e.g., “Cost”).
  2. A property to represent “Quantity” (used as a usage multiplier).
  3. A property to collect the rollup result (e.g., “Extended Cost”).

In this example, we use “Extended Cost” as the rollup property name, but you can customize it as needed. 

To create a formula, please follow these Step-by-Step Instructions

  1. Open Your Bill of Materials
  2. Access the BOM you created previously.
  3. Verify Required Properties
  4. Ensure the BOM includes both “Cost” and “Quantity” properties. These are typically default properties, so they are likely already present.
  5. Add the Rollup Property
  6. Add a new property to store the rollup result. For this example, name it “Extended Cost.”
  7. Enable the property across all sublevels by checking the “Include Sublevels” flag. If you skip this step, you’ll need to manually add the property to each sublevel later.
  8. Define the Rollup Formula
  9. Add a formula to the “Extended Cost” property:
    Extended Cost = Cost * Quantity
  10. Enable the rollup flag for this property.
  11. Once the formula is applied, the rollup values will be calculated automatically.

After the formula is added, verify you didn’t get any ERR messages in the BOM, which will indicate that something is wrong. Review the rollup values in your BOM. The “Extended Cost” property will display the aggregated cost for each item, taking into account the quantities specified.

For more information about cost rollup and other OpenBOM formula capabilities, please visit OpenBOM best practices documentation – advanced formulas. 

Conclusion

The OpenBOM rollup mechanism is a versatile tool that simplifies calculations for costs, weights, or any other values within your BOM. By using rollup formulas, you can efficiently manage complex data without relying on cumbersome manual methods.

Ready to streamline your BOM management? Register for free and discover how OpenBOM can transform your workflows!

Best regards,
Oleg

Related Posts

Also on OpenBOM

4 6
1 May, 2025

Welcome to the April 2025 edition of What’s New in OpenBOM! Each month, we work hard to turn your feedback...

30 April, 2025

I’m super excited to introduce April 2025 release of OpenBOM for PTC Creo with the new features to help you...

29 April, 2025

Meet Sarah. She’s a mechanical engineer at a growing robotics company, juggling CAD models, spreadsheets, supplier lists, and emails from...

25 April, 2025

Spreadsheets are everywhere. Every engineer, buyer, or project manager has their own system—color-coded tabs, clever formulas, and “just one more”...

24 April, 2025

Accessing the right information at the right time is a paramount requirement for all engineering and manufacturing teams. I’m super...

23 April, 2025

In my article today, I want to continue to share ideas about how to organize new types of agentic workflows...

21 April, 2025

There’s a lot of excitement right now about Large Language Models (LLMs). From writing code to generating marketing copy, these...

18 April, 2025

At OpenBOM, we believe seamless integration is the key to efficient product development. Engineering teams today work across mechanical and...

17 April, 2025

At OpenBOM, we’re always striving to improve the user experience. One of our guiding principles is continuous improvement — especially...

To the top