In a manufacturing Industy  producing a certain unit or product ,BOM is used for communication between manufacturing partners or confined to a single manufacturing plant containing  all components Description,Part Number, Quantity, Materials, etc..If there are many Sub-assembly, It is easy to have BOM in excel file to display  all the parts in  the assembly for easy navigation of components.

In Solidworks, there are templates for computed BOMS, weldment BOMs, and weldment cut lists. Each BOM template can have different data variables displayed in the BOM columns depends on the needs of the user. Just insert all the property or data need before saving as excel file.
For example, a BOM for engineers or designers might have the following columns:

  • Part Number
  • Description
  • Part Number
  • Quantity
  • Material

A BOM for purchasing managers might have the following columns:

  • Vendor
  • Cost
  • Material
  • Part Name
  • Part Number
  • Quantity
  • Unit of Measure

From the Bom Created in Solidworks  just Single Click the BOM so it is selected and then go to file-Save As ( or right-click on the BOM and choose Save As.) . Select save as file type Excel (.xls.).


<Back