BOM Mass Rollup
How much does your product weigh?
Manufacturers need to calculate the weight of a product to calculate shipping costs and/or to meet contract requirements early in the design phase.
Calculate the weigh or mass from the parts list.
PLM enables manufacturers to assign a mass or weigh to each part in the parts list.
BOM Mass Rollup Report...
In past and present organizations, I frequently get asked the question, how can we do a bom mass/weight rollup report? Do we enter the information in the CAD package or do enter in Teamcenter? If we enter in the CAD package, how do I keep track of masses that don't modeled in CAD? There are a number of questions that need to be addressed before you can do a BOM mass rollup report. This kind of report seems to be a customization most of the time. But do we need to include this logic in the PLM application? Not really.
The pseudo code of a BOM Mass rollup algorithm can take weeks to develop and the quality of the data makes also the development a bit more complicated. This program can take up to 30 days or to complete depending on the level of complexity. So, I finally wrote a quick piece of code, I can take an excel spreadsheet with the assembly level, level 0 being the top level product such as ship, jet engine, a truck, or any other large product with 500 parts or more, the quantity, and mass (per unit of measure). From there, I can calculate the Applied Mass or Roll up mass of the entire product. It does not matter if you have 100 or 10,000 parts; the code can process this in seconds. Here are some of the assumptions and rules that this algorithm follow:
The applied mass of an assembly is the greater weight of two calculations, the assembly mass times its quantity or the sum of the mass of each component part times its quantity times the quantity of the assembly.
If a mass is not provided, the quantity is assumed to be zero.
If quantity is not provided, the quantity is assumed to be 1.
The same logic can be applied to the cost rollup report.
If you follow the above assumptions, you will be able to write a robust algorithm. If you would like me to run your sample or full product bom through the code, please reach out to me. I can also give you a demo.
#Teamcenter #PLM
If you'd like to receive a copy of the code, please fill out the form below!