×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

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

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

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

(OP)
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
 

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

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.

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

Quote:

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.

cheers

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

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

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

(OP)

Quote (CBL):

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
 

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

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.

batHonesty may be the best policy, but insanity is a better defense.bat
http://www.EsoxRepublic.com-SolidWorks API VB programming help

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

Quote (TheTick):

Separate subassemblies is folly
Obviously I'm missing something. Can you explain that statement, please?
 

cheers

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

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: Eng-Tips.com Forum Policies to make the best use of Eng-Tips Forums?

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

What Mango said.

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

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

cheers

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

(OP)
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
 

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

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

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

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.

cheers

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

(OP)
Thanks

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

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

(OP)
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
 

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

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

cheers

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources