What you need
Two things: the product structure from the model, with the total number of instances per part, and your BOM. Both from the same version of the design, otherwise you compare two moments instead of two sources.
You get the product structure from your CAD package or straight from the STEP. A STEP with assembly structure contains for each part how often it occurs and under which assembly it hangs.
If you do not have a BOM at hand, you can make one from the model. The free STEP to Excel on this site gives the total quantity, the material and the dimensions per part.