I have been given an interesting question. In creating new part and assembly drawing templates I had been requested to place the paint and material information in a table in the upper right of the drawings. Then the BOM in assemblies was to be set under the paint table. Now looking at the finished drawings I have been asked to do something a little more difficult. I am now to create a dummy part for each paint to add to the assembly so the paint will show in the normal BOM. Easy, but. Now we come to the quantity of paint used which needs to be driven by the assembly. I can take the area of the assembly times 6 mills for thickness, plus scrap factor, and determine how much paint is required. But this value would be at the assembly level.

How do I enter this value as the QTY. property of the paint in the BOM?