Tutorial 1A - Manually Created BOM

Tutorial 1A - Manually Creating a BOM for a Skateboard

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 MAN_Skateboard tab)
Purchasing generally works in the flat BOM (the Library tab).
Any changes on MAN_Skateboard tab or the Library tab will be reflected on the other tab.
During periods of heavy design time, it is recommended that engineers keep the structured BOM (the MAN_Skateboard tab) up to date at all times. This 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.