How to manage packaging units and to use catalog formulas to normalize BOM Unit of Measures?

Oleg Shilovitsky
Oleg Shilovitsky
12 May, 2020 | 2 min for reading
How to manage packaging units and to use catalog formulas to normalize BOM Unit of Measures?

In this article, I will explain how to manage a situation in which you’re buying materials in one unit and consume it in different units of measures. This is one of the most demanding scenarios and it is very often happening in manufacturing companies. A very typical situation. You buy paint in gallons and consume it in BOMs in grams. Another example – you buy screws in boxes, but consuming it in BOMs in EA units. 

So, how to manage it in OpenBOM? Since we have now Formulas in OpenBOM catalog(s), it is very simple to solve the problem. 

You can create a catalog and have purchasing costs there together with unit of measure and conversation factor. Once it is done, you create a formula in the OpenBOM catalog to calculate the unit of measure based on packaging prices and the conversion factor. Once it is done, the remaining work is to create a typical cost rollup quantity in BOM (eg. Extended Cost = Unit Cost * Quantity). 

One the picture above, you can see how it works. Change packaging cost for any product leads to a recalculation of BOM cost automatically. Watch the video for more details. 

Conclusion

In this article, you learn about how to manage materials and purchases in one unit (packaging price) and convert it to the Bill of Materials unit of measures using catalog formulas. This is one of the most typical scenarios you can think about in BOM cost management. 

Check OpenBOM now by registering an account here

Best, Oleg @ openbom dot com.

Want to learn more about PLM? Check out my Beyond PLM blog and PLM Book website

Read OpenBOM customer reviews on G2 Crowd to learn what customers are saying about OpenBOM. 

Related Posts

Also on OpenBOM

4 6
2 May, 2025

Data is everything in today’s digital world. While every manufacturing company thinks differently about their products and strategy, the common...

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

To the top