Screaming Circuits: BOMs Away


BOMs Away

Yes, I'm talking about BOMs (bills of materials), not bombs. That would be silly and irrelevant. At least mostly irrelevant. If you make bombs, it wouldn't be, but it would probably be all secret so we couldn't talk about it.

The question of the day is: "What makes a good BOM?" There are a lot of BOM formats in use. It's one area that the standards train more or less left behind. Well, there are standards. For example, IPC-2581 covers not only BOM standards, but a replacement for Gerbers and the whole manufacturing data package. One of these days, we'll all be using the IPC-2581 formats for our data and life will be beautiful all of the time.

However, those standards aren't really in common use today. And, they are complex enough that they can't really be used in spreadsheet form. There's a lot of nesting and hierarchy that makes it more difficult to deal with without a BOM management software package. Still there is good data in there. A lot of good data. So much good data that my head is still swimming.

But until that day, there is a set of data and data labels that will help ensure accuracy. The headers are important too. If this seems quite rudimentary, that's because it is. But it's important.

BOM snippet

  • "BomItem" or "Item #": This is just the line number. Each type of part gets an item line, not each part. If the pat number is the same, you just put it down once and give the quantity.
  • "quantity" or "Qty": How many of this specific part you need per board
  • "RefDes": The reference designators used by the parts on the PCB silk screen. All of the same part number should be in the same excel spreadsheet cell: i.e., "R3, R4, R5, R6". You can also indicate a contiguous range with a dash: "R3-R6" or "R3-R6, R10, R15"
  • "Manufacturer" or "Manf": The name of the component manufacturer. It's best to spell out the full name, e.g., "Texas Instruments", but common abbreviations such as "TI" generally work too. The less ambiguity, the better.
  • "Mfg Part #" or "Manufacturer Part #": The part number that you would use if you were buying this exact part from the manufacturer or a distributor. All of the suffixes are important too. For example, "PIC16F88" is not enough when you really need a "PIC16F88-I/P".
  • "Dist. Part #" or "Distributor Part #":Not strictly necessary, but can help in cases with a bit of ambiguity. Again, this would need to be the exact part numer as you would order it from that distributor.
  • "Description"or "Desc": This is the component description as given by the manufacturer. Again, this isn't strictly required, just a good idea.
  • "Package": This is the standard package type, e.g., "SOT-23", "TO-92", "0201". Again, not strictly necessary but can be a good redundant check.
  • "Type": Optional indicator of the generic type. e.g., "fine pitch", "smt", "thru-hole", "Leadless". Not required but can help with assembly quoting.

That's not IPC-2581, but it is a good set of usual requirements. It's also best to put your final BOM on the first tab in your excel spreadsheet. That will make it easier for buyers to know exactly what you want.

Duane Benson
So long mom, I'm off to drop the bill of materials
So, don't wait up for me

 

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341c008a53ef017d3d8ef25d970c

Listed below are links to weblogs that reference BOMs Away:

Comments

It amazes me that there isn't a good solution for BOM management. If there is I certainly haven't seen it. There are expensive solutions, but nothing that I've seen that works well for folks without gobs of money.

I'd really like to see a software package recommendation that isn't huge $$$, and that works nicely with Eagle. I'm at the point (and I'm one design engineer all on my own), where I'm going to hire a software developer to build me a custom web app to create and manage all my parts, vendors, and BOMs and then export what I need, when I need it. I can't believe the tools to manage this process aren't out there... well, my budget is a few K, not 10K+. Managing excel spreadsheets of all your BOMs and part numbers is so 1985.

/end rant

Post a comment

If you have a TypeKey or TypePad account, please Sign In.

« Let's Get Small, as in 0.3mm | Main | Speaking of Reference Designators... »