A manufacturing BOM template suppliers can quote from
A manufacturing BOM (bill of materials) template needs eight columns before a supplier can quote: part number, revision, description, quantity per assembly, annual volume, material, finish and drawing file. Allied Mile's template has 17, with a filled example line, in Excel or CSV.
Download
Columns in the template
Seventeen columns, in the order they appear in the download. Eight are required before a made-to-print line can go out for quotes; the rest help when you have them, and catalog lines also need a manufacturer part number (MPN). The example column follows one part, BRKT-1042 Rev C, a formed steel bracket; its figures are illustrative. No BOM yet? We draft one from your drawings, CAD or schematics.
| Column | Required | Example | Why it matters |
|---|---|---|---|
| Level | If known | 1 | Level 0 is the top assembly and 1 its direct parts, as Arena's BOM article describes; parts inside a sub-assembly take level 2. Blank is fine for a flat list. |
| Part number | Yes | BRKT-1042 | Ties every quote and every question back to one line. Use the number on the drawing's title block, not a nickname. |
| Revision | Yes | C | Shops quote a revision, not a part number. It must match the drawing file you send, or the shop quotes one revision and builds another. |
| Description | Yes | Bracket, formed, 14 ga cold-rolled steel, black powder coat | Lets a shop see at a glance whether the part fits its process. Noun first, then what matters: form, material, finish. |
| Quantity per assembly | Yes | 2 | How many of this part go into one parent assembly, not into the year's build. |
| Unit of measure | If known | ea | Blank means each. Raw material and bulk items need the unit the supplier sells in (feet, pounds, sheets), or the quantity means nothing. |
| Type (made-to-print / catalog / raw material) | If known | Made-to-print | Sets the route: made-to-print lines get quoted, catalog lines get a distribution recommendation, raw material usually stays with the part maker. General BOM templates call this procurement type, or make or buy. |
| Material / grade | Yes | Cold-rolled steel sheet, 14 ga (0.0747 in) | Narrows which shops can make the part and sets the material cost. Grade and form, not just "steel"; add the spec number when the drawing gives one. |
| Process | If known | Sheet metal: laser cut and form | Which kind of shop to ask. Usually clear from the drawing; state it when it isn't, or when you need a particular method. |
| Finish | Yes | Black powder coat | Often done by a separate finisher, so some quotes leave it out unless the line asks. "Per drawing" works if the drawing names a spec; blank does not. |
| Drawing or file + revision | Yes | BRKT-1042_RevC.pdf; BRKT-1042_RevC.step | The files a shop will receive. Tolerances, datums and notes live here, not in the BOM. A PDF drawing plus a STEP model is the usual pair to send. |
| Critical tolerances / inspection | If known | Hole pattern to datum A per drawing; FAI (first-article inspection) on first lot | Tells a shop what to inspect and what inspection time to quote. List only what is critical and the documents you want with the parts. |
| Manufacturer + MPN | If known | n/a (made-to-print) | Fill it for every catalog line: the manufacturer and its part number pin down exactly what to buy. Blank for made-to-print lines, which your drawing defines. |
| Alternates allowed? | If known | Material: no. Finish: an equivalent black powder coat is accepted | Whether an equivalent catalog part, or a substitute material or finish, may be quoted. "Yes, within limits" saves a round of questions; silence is read as no. |
| Annual volume / quantity breaks | Yes | 250 assemblies/yr = 500 pcs; quote at 500 and 1,000 | Drives price breaks, whether tooling pays off and whether you clear a supplier's MOQ (minimum order quantity). Name the quantities to quote so every quote lands on the same breaks. |
| Required certifications | If known | Certificate of conformance (CoC) per shipment; mill cert on request | Material certs, CoCs and compliance declarations take the shop time and change who can quote. If you require them, say so here; we review supplier certificates when you do. |
| Notes | If known | State whether powder coat is included in the piece price | Anything a shop would otherwise ask: masking, packaging, a mating part, a question to put to every shop. One note per line; long notes belong on the drawing. |
How to fill it in
Start at the top-level assembly and work down. Quantities are per parent: two brackets in one enclosure is 2, even if you will build 250 enclosures this year. Annual volume has its own column.
Take part numbers and revisions from the drawing title blocks, not from memory or an old order. If your parts list already lives in CAD or a spreadsheet, paste it in and map the columns; the order doesn't matter, the content does.
Mark each line's type if you know it: made-to-print, catalog or raw material. If you don't, leave it blank. We review every line and sort it before anything goes out for quotes.
One line per part
One part number per line, and one line per part number under each parent. A left and a right bracket are two lines even when they mirror each other, because each has its own drawing and its own quantity. Hardware gets a line per size and type, with an MPN or the characteristics an equivalent must match.
Raw material gets a line only when you will buy it yourself. If the shop making the part supplies its own bar or sheet, the material needs no line; the shop prices it into the part. When you do buy it, use the unit the mill or distributor sells in.
A sub-assembly you might buy complete, such as a welded frame or a wired panel, gets its own line at level 1 with its parts beneath at level 2. That lets the frame be quoted as one item and its parts as separate items, so you can compare the two. Levels also keep quantities straight when the same part sits under two parents.
What to leave blank
Leave a cell blank rather than guess. A blank material or finish comes back to you as a question before any RFQ (request for quote) goes out; a wrong one comes back as a quote on the wrong part. A partial BOM is fine to send.
Dates, delivery location, packaging, payment terms and quote validity belong in the RFQ, not on the BOM, because they apply to every line at once. Our RFQ checklist covers them.
Why are there no supplier, price or lead time columns?
They are answers, not inputs. Many general-purpose BOM templates carry them; two of the three guides we cite below include supplier and cost columns. On a BOM you are about to quote, though, old figures read as targets and are usually out of date. Each quoted line gets a named supplier, a price at each quantity, tooling, lead time, MOQ and terms in the quote comparison.
When is a BOM line quote-ready?
A made-to-print line is quote-ready when the eight columns marked Required above are filled and the drawing file carries the same revision as the line. The BOM sourcing review checks those eight; a line missing one comes back as a no-quote or a guess.
A catalog line is ready when it names a manufacturer and MPN, or lists what an equivalent must match and whether alternates are allowed. A raw material line needs a grade, a size and a unit of measure. Where the BOM and the drawing disagree, say which wins.
Where BOM templates go wrong
These are the gaps that turn a complete-looking BOM into no-quotes and follow-up questions.
- Order quantity typed where quantity per assembly belongs, or mixed between lines. Keep per-assembly in its column and volume in its own.
- Two parts on one line, such as "bracket, left and right". Each needs its own part number, drawing and quantity.
- Catalog parts with a description but no MPN. "Connector, 3-position" can be quoted a dozen ways.
- A revision on the line that is behind the drawing. Fictiv's BOM guide recommends keeping a revision history; at minimum, date the file and note what changed.
- Old prices and suppliers copied forward from a past build. Leave them off a BOM you are about to quote.
- A column for everything anyone ever asked. Duro's template page puts it well: "The goal is not to add every possible field." Add a column only when a supplier would read it.
Questions buyers ask
- Can I send our own BOM instead of this template?
- Yes. A spreadsheet BOM (Excel or CSV) in your own layout is fine; the column names don't need to match ours. Use the template when you are starting from scratch, or to check your own file against the Required column above.
- Should fasteners and other catalog parts be on the BOM if they won't be quoted?
- Yes, with an MPN. Catalog lines get a distribution recommendation rather than an RFQ, but they still belong on the BOM. A long-lead fastener can hold up a build as surely as a bracket, and a catalog item that needs cutting or machining before it fits has to be quoted after all, which we only spot if the line is there.
- Where do reference designators go for electronics?
- In the notes column, or add a column of their own; Arena's BOM article lists reference designators among the standard elements for board assemblies. Quantity per assembly is the count of designators, so C4, C7 and C9 is 3. If you only have a schematic or PCB files, send those and we draft the lines.
Have a BOM ready to quote?
Related pages
- BOM sourcingBOM sourcing with Allied Mile: we sort every line, find and vet manufacturers for your custom parts, run the RFQs and line up the quotes side by side.
- BOM from drawingsHave drawings, CAD or schematics but no BOM? Allied Mile drafts the bill of materials, names the file behind each line and flags gaps as open questions.
- Manufacturing RFQ checklistAllied Mile's manufacturing RFQ checklist and RFQ template (xlsx, csv): what to send machine and sheet metal shops so their quotes come back comparable.