We are having discussions on how to create the correct bills using SolidWorks and EPDM.   Currently we are somewhat stuck on how to drive raw materials.   We are not using configurations in our parts.  Still will need to drive multiple qty's of the same raw material.   One thought that came up was to have an excel sheet raw material with custom properties that would drive quantities to the individual parts.   I'm not liking this idea, but need to research it non the less.   Any ideas on how this could be accomplished?   Is it even possible?

Thanks