How to split up a B.O.M.?

[draftsman2008]

I have an assembly that I am remaking from an AutoCAD drawing. On the original drawing it had the B.O.M. separated into made and buy out parts. The drawing is a D size sheet. What I am wanting to do is the same with my drawing that I create. The only way that I have come up with is to create sub-assembles and use a sheet for the entire assembly and using separate sheets for the sub-assembles. On the 1st sheet denote each sub-assembly and what sheet its on and have the B.O.M. per sub-assembly.

My question is, What is the best way to get my B.O.M. to show manufactured items and then buy out items?

Thanks in advance,


Brian
Dell Optiplex 745
2 gig Ram
Solidworks 2007
AutoCAD Mechanical 2005
Springfield, Mo User Group

 

[SCRUDRIVER]

You can sort your items on the BOM then just split the BOM at that point. Or you can create two different BOMS and just hide the components that are made for the bought Bom and vice versa. Not real user friendly though.

 

[CorBlimeyLimey]

The only way that I have come up with is to create sub-assembles and use a sheet for the entire assembly and using separate sheets for the sub-assembles. On the 1st sheet denote each sub-assembly and what sheet its on and have the B.O.M. per sub-assembly.

Isn't that standard practice ... or at least one of the several standard methods?

An alternative;
If you separate the manufactured and purchased components in the model, then the BOM will automatically reflect that structure.

 

[ShaggyPE]

I would recommend adding a custom property to your parts. Call the property something like MANUFACTURING TYPE and populate it with either make or buy. Then add this custom property to your BOM as a new column.

-Dustin
Professional Engineer
Certified SolidWorks Professional

 

[draftsman2008]

Isn't that standard practice ... or at least one of the several standard methods?

Not sure!

The company that I work for doesn't really follow any standards to speak of. They like to see things the way that they have seen them for years and really grip when I try to make something look the way it should.

Brian
Dell Optiplex 745
2 gig Ram
Solidworks 2007
AutoCAD Mechanical 2005
Springfield, Mo User Group

 

[TheTick]

I think sorting and splitting the BOM is about the sanest way to go. It does not force you to over-structure your assembly for the sake of your drawing Shaggy's suggestion of a property for purchase vs. manufacture makes sense no matter which way you go.

Separate subassemblies is folly. I doubt this would do anything positive for the functional aspects of your model, and it's one more file to track. It would be better to have configurations that suppress all but one type (i.e. suppress all but purchased parts, etc.). In the drawing, you can choose which configuration to show in a view, and the BOM attached to that view would reflect the configuration's contents.

Honesty may be the best policy, but insanity is a better defense.

http://www.EsoxRepublic.com

-SolidWorks API VB programming help

 

[CorBlimeyLimey]

Separate subassemblies is folly

Obviously I'm missing something. Can you explain that statement, please?

 

[MadMango]

I think he means that creating separate subassys just to define purchase/made parts is the wrong approach. The BOM should define the manufactured item, not the procurement of it.

"Art without engineering is dreaming; Engineering without art is calculating."

Have you read faq731-376 to make the best use of Eng-Tips Forums?

 

[TheTick]

What Mango said.

 

[CorBlimeyLimey]

OK, Thank you. I missed the subs were of just the purchased components.

 

[draftsman2008]

I am not trying to define the procurement of it, I just want to separate the purchase/made parts!

Brian
Dell Optiplex 745
2 gig Ram
Solidworks 2007
AutoCAD Mechanical 2005
Springfield, Mo User Group

 

[ShaggyPE]

What I think MadMango is referring to is whether a part is made inside or outside (not defining the procurement). I am still in favor of adding the custom property and also sorting the BOM to have all of one group early and the other group late... as SCRUDRIVER and Tick mentioned.

-Dustin
Professional Engineer
Certified SolidWorks Professional

 

[CorBlimeyLimey]

Having the Make or Buy properties (or at least one of them) is a good idea. I use them on the rare occasion that I have a large assy where separating the purchased parts makes life easier. I export the SW BOM to Excel and use the properties as the sort criteria.

I commiserate with you about your company's "that's the way we've always done it" attitude. You will have to keep at it and prove to them that better ways exist, and that by doing it the old way is actually creating more work.

Good luck.

 

[draftsman2008]

Thanks

Brian
Dell Optiplex 745
2 gig Ram
Solidworks 2007
AutoCAD Mechanical 2005
Springfield, Mo User Group

 

[draftsman2008]

The only problem that I have with sorting by make/buy is that I would rather my BOM be sorted by part number instead. If I understand correctly, I could export my BOM into excel and sort by make/buy and then remove one or the other and then do a sort by part number and repeat the steps for the other. Thanks for all the help.

Brian
Dell Optiplex 745
2 gig Ram
Solidworks 2007
AutoCAD Mechanical 2005
Springfield, Mo User Group

 

[CorBlimeyLimey]

The Excel sort function can sort by three levels at the same time.
Make or Buy
Part Number
Whatever