Take the 2-minute tour ×
Electrical Engineering Stack Exchange is a question and answer site for electronics and electrical engineering professionals, students, and enthusiasts. It's 100% free, no registration required.

My understanding of a BoM is that it's essentially a list of the various components required for an electronic product or module. Does this mean it could be as simple as a spreadsheet?

Are there any formal standards/templates for BoM's citing required/mandatory fields/data that it must contain? Any good samples/templates that can be referenced?

share|improve this question
1  
yes, it can be as simple as a sheet of paper –  kenny Sep 4 at 14:28
4  
It depends entirely on who's asking for it. –  Matt Young Sep 4 at 14:31
    
A lot BOM formats are dictated by the MRP/ERP tool being used. Often turn key assemblers have their own format for interface to their tool. MRP = Manufacturing Resource Planning and ERP = Enterprise etc etc –  placeholder Sep 4 at 16:14
    
It should be noted that the term is used in other contexts. For instance, a software product may be built by a builder tool that accepts a list of components referred to as a "bill of material" (or, more often, just "BOM"). And I recall a software product that contained within it a "BOM table", used to identify and locate individual components for diagnostic purposes. –  Hot Licks Sep 4 at 20:58

4 Answers 4

Yup, BOM is a spreadsheet.

At minimum it should contain refdes and internal part number for each component.

If you don't maintain an internal parts database, it should contain refdes and manufacturer / full part number for each component.

If this is for a small build, I put the Digi-Key or Mouser part numbers on there too, so you can order off the BOM.

I like to coalesce identical part numbers so instead of a row for C1 and a row for C2 and a row for C3, I have a row for C1,C2,C3. This also necessitates a "quantity" column. It also makes it harder to look up a given refdes since they are not in order.

The BOM will be used by the guy ordering parts and the guy running the pick and place machine, so add any annotations you want those folks to see.

Oh, and the BOM is useful for costing if you add component prices on there. Again, this is for small runs. Big runs will use more sophisticated accounting.

share|improve this answer
1  
Thanks @markrages - (+1) 2 followup questions: (1) can you elaborate on what a refdes is? What does it stand for and how is it used? And (2) What is a "pick and place machine"? Thanks again! –  smeeb Sep 4 at 14:44
2  
refdes = reference designator "C1" etc. Pick and place machine is a robot that assembles PCBs. They are fascinating to watch, so I suggest searching youtube to see them in operation. –  markrages Sep 4 at 14:50

Yes, a useful and common way to express a BOM is a spreadsheet. No, there is no standard format. Individual companies may have internal specs and forms for BOMs, but there is no independent standard, at least that enough people follow to make is useful.

I use the following columns in my BOM spreadsheets:

A: Total quantity of this part required for the complete build. The A1 cell contains the number of units to be built. The remaining A cells are derived from A1 and the quantity per unit (column B).

B: "Qty". Number of parts required per unit.

C: "Designators". Component designators, like R1, C5, etc. The cell for each line lists all of the designators for the instances of that particular part within the unit.

D: "Desc". Basic description string, like "Capacitor, unpolarized", "Resistor, fixed", etc.

E: "Value". More detailed value beyond the basic description. This might be "12 Ohms, 2 W, 1%" for a particular resistor.

F: "Package". The name of the package for that part variant, like "SMD-0805", but sometimes proprietary package designations if it's not something standard. This defaults to the name of the package in the Eagle libary if I don't explicitly set it.

G: "Subst". Yes or no to indicate whether substitutions are allowed. For example, you probably want to let purchasing buy whatever 1 kΩ 0805 5% resistor they can get that week, but the microcontroller had better be exactly the one you specify.

H: "Manuf". Manufacturer name, usually blank for generic parts.

I: "Manuf part #". Manufacturer's part number.

J: "Supplier". Example supplier name, like "Mouser".

K: "Supp part #". Part or stock number of the supplier listed in column J.

L: "$Part". Cost per part.

M: "$Board". Cost of all of these parts on a whole board or unit. This is automatically derived from B and L.

N: "$All". Cost of all of these parts for a whole production run. This is automatically derived from A and L.

I also have a few lines at bottom. These are for the bare board itself, kitting, manufacturing, testing, and delivery to stock. The purpose of these additional lines mostly to allow summing up the complete cost of a production run.

I would attach a example, but there doesn't seem to be a way to do that. Here is a screen shot of one such BOM spreadsheet for something internal, so I'm not giving out any customer information. To be able to read it, you probably have to save the image to disk, then view it externally. This site resizes images to some maximum width for display in a message.

In this case I never filled in the per-part costs, so this doesn't show overall costing.

share|improve this answer
1  
+1 Nice example. Very similar to what we use, except we have a separate column for DNP (do not place) to make them stand out. –  tcrosley Sep 4 at 16:41
    
This is the full image URL. –  Uwe Keim Sep 5 at 5:51
    
I often package a spreadsheet similar to this with a front sheet giving the bare board description (material, thickness, soldermask colour, plating, layer stack etc) to let the population company know what they're getting and a component list sheet with an individual line for each part with reference designator, side of board, orientation and X and Y location to assist in pick and place programming. That seems to suit most companies we work with. –  Xcodo Sep 9 at 21:56
    
@Xcodo: Yes, I also make a separate parts locator index. This gives the X,Y location of each part on the board, and the sheet and rough coordinates of every gate within a part on the schematic. –  Olin Lathrop Sep 9 at 23:02

Typically with integrated layout environments when you create the schematic you choose components from the library, and/or add your own. You can also indicate preferred suppliers and costs. One of the tools is the export of BoMs, and its automatic updating with schematic changes, in various formats including Excel.

share|improve this answer
1  
Thanks @Dirk Bruere (+1) - please see my comment underneath markrages' answer - I have the same question for you! –  smeeb Sep 4 at 14:48

Here is an example: Arduino BOM

That is from this site (if you want to see the whole thing): Arduino Uno at SOLDERPad.

share|improve this answer
2  
Thanks @Enemy Of the State Machine! Good example! –  smeeb Sep 4 at 14:45
5  
I'd expect much more on a BOM. This one does not list stuff like component package sizes. If I asked someone for a BOM, I'd expect something that will let me build an order containing components sufficient to populate a part, and this doesn't do that. –  Scott Seidman Sep 4 at 14:49
5  
But that is more like a broken car. I know - one did not ask for a working car, but... I would expect to have enough information in a BOM that I could go away and actually build the final assembly. That means the information on the parts has to be good enough to identify them (manufacturer parts number or at least package, type of capacitor...). Which isn't the case in this example... –  og1L Sep 4 at 15:11
4  
Yes, its the type of BOM an inexperienced person would provide-- once. –  Scott Seidman Sep 4 at 17:43
5  
A proper BOM is something you can give to a turnkey manufacturer and not have them get back to you with part questions. –  Olin Lathrop Sep 4 at 17:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.