Paint, grease & other consumables in SolidWorks' BOM

Let's take a look at how and why companies are quantifying consumable products in BOM's within SolidWorks.

First off, let's assume that in order to get an account of such products in assemblies, customers are creating actual part models of such things.  This might sound strange but when companies are using parametric designs to create complete and accurate BOM's to pass to ERP systems or purchasing folks this becomes a necessary step.

So to keep these folks happy, when should they re-order the grease that keeps the wheel from squeaking?  If the standard recorded quantity is "1" each time the consumable was used in an assembly, this could mean that this item is ordered by the truckload.  On the other hand, if the consumable product is not within the BOM, how do you quantify it?

Let's have SolidWorks create an accurate BOM.  In this example, let's assume we need to quantify grease and we use approximately .005 ounces per application.  We have an assembly that uses 4 applications.

Steps involved:

1. Create a custom property for a part named grease.

2. Name the property Amount.

3. Assign the value .005 to this custom property.

4. Select Amount in the BOM Quantity field of the custom or configuration specific tab of the part.





This quantity is also computed and accurately displayed in the BOM should you use this in Enterprise BOM or export this to an Excel file for import into your ERP/MRP program.

So hopefully this will give you some ideas on how to more accurately display and account for your consumable items in your next SolidWorks Assembly BOM.

Thank you,

Brian Reel

  • Share this
Find Your Design Solution in the CATI Store.
Browse Products