Tutorial 1B - CAD Driven BOM for a Skateboard

Prerequisits

• Tutorial 1A - Manually Created BOM

Files to Download

• Latest Version of QuickBOM

• Skateboard-Example-CAD-files.zip

• QuickBOM-example-SW-export-BOM.sldbomtbt

General Tips & Tricks

• If you share this file using OneDrive or SharePoint, you can have multiple users in the sheet at one time.

• Engineers generally work in the tab that shows the indented BOM (the CAD_Skateboard tab)

• Purchasing generally works in the flat BOM (the Library tab).

• Any changes on CAD_Skateboard tab or the Library tab will be reflected on the other tab.

• During periods of heavy design time, it is recommended that you do a fresh import from your CAD system every few days. QuickBOM is designed to do lots of imports without accidentally overwriting data. Frequent updates will allow engineering and purchasing to always be working with the same data.

• Experiment with adding other “Custom” columns. In my experience, it’s very helpful add custom columns for the following.

  • Status - I use this column to track where the part is in it’s design process. Examples: Drafted, Ready for Checking, Redlined, Ready for Purchasing, etc… Every company’s process will be slightly different

  • Engineering Assignee - I generally assign an engineer from the team to every single part. If there is a drafting error on that part, I make that person go back to it and fix it.

  • Purchasing Assignee - I generally assign a purchasing person for every part. That way, I can be confident that we will fully cost a design on time.

  • Stock as Spare Part - When an engineer identifies a part as a wear item, they indicate it in this column. That tells supply chain to stock extra parts to be sold as spares.