Free Bill of Materials Template
Build a bill of materials with part numbers, quantities, units and costs per assembly, see the rolled-up totals, then print it or download it as CSV. Put sub-assemblies under their parent, set how many units you are building, and the CSV opens in Excel and Google Sheets.
What a bill of materials includes
Part number and description
One row per part, with the number your supplier or your ERP uses and a description a person can check against the shelf.
Quantity and unit
How many of the part go into one unit of the assembly above it, and in what unit: each, feet, meters, hours, sets.
Levels and sub-assemblies
Level 0 rows make up the finished product; rows indented under them make up a sub-assembly. Item numbers like 7.2 show where each part belongs.
Unit and extended cost
Unit cost × quantity = extended cost. Sub-assemblies take their cost from their parts, and everything adds up to the cost of one finished unit.
Supplier and lead time
Who you buy each part from and how many days it takes, so purchasing knows what to order first. The BOM shows the longest lead time.
BOM number and revision
A number and a revision letter, so everyone builds from the same version. Change the revision when parts or quantities change.
How the cost roll-up works
Each row's extended cost is its quantity × its cost per unit. A row with parts under it is a sub-assembly: its cost per unit is the sum of its parts' extended costs, plus anything you type as its own cost (assembly labour, for example). The cost of one finished unit is the sum of the level-0 rows.
Example, from the control panel example in the template: the wiring set is 80 ft of control wire at $0.18 ($14.40), 100 ferrules at $0.05 ($5.00) and 50 cable ties at $0.04 ($2.00), so one wiring set costs $21.40. Add the enclosure, rail, breakers, contactors, power supply, terminal blocks and 6 hours of labour at $55, and one panel costs $771.60.
Set the build quantity to 10 and the BOM shows the cost of the batch, $7,716.00, and how many of each part to order: 200 terminal blocks, 800 ft of wire, 60 hours of labour. Quantities multiply down the levels, so a part used twice in a sub-assembly that is used twice counts four times.
Ordering the parts? Turn the BOM into a supplier order with the purchase order template.
Pricing the finished product? Put the cost per unit into the margin calculator to see the price for the margin you want.
Single-level, multi-level, engineering and manufacturing BOMs
- Single-level BOM
- One flat list of the parts in one assembly. Enough for a kit or a simple product; leave every row at level 0.
- Multi-level BOM
- Parts grouped under the sub-assemblies they go into, and those under the product. Use levels 1 and 2 here; costs roll up level by level.
- Engineering BOM
- What the product is made of, as designed: parts and quantities from the drawings, often without suppliers or labour.
- Manufacturing BOM
- What it takes to build it on the shop floor: the same parts plus consumables, packaging, labour and the order of assembly.
Tips for reps and engineers
Quote a kit from a BOM
Reps who sell a kit or a panel can list every part, roll up the cost, and price from there. The customer sees exactly what is in the box.
Use the supplier's part numbers
A description alone invites a substitute. The part number from the supplier's catalog is what purchasing orders and the warehouse picks.
Count labour as a row
Assembly and wiring hours are part of the cost. Put them in as a row with the unit h and an hourly rate.
Change the revision, not the old file
When a part or a quantity changes, raise the revision letter and send the new BOM, so nobody builds from yesterday's list.
More for manufacturers' reps and sales engineers: the manufacturer's rep, the sales engineer, the manufacturing sales process, industrial distributors.
The BOM lists the parts. The meeting decided which ones.
The variant, the quantities and the substitutions were settled with the customer or the engineer in a meeting. Record that meeting in ParrotNotes and get the summary and next steps, so the BOM matches what was agreed. Free for 100 minutes of recording a month.
Get ParrotNotes freeRelated tools
- Purchase Order TemplateFill in a purchase order with supplier, ship-to, line items, tax and terms, then print it or save it as PDF.Open the tool
- Price List TemplateBuild a printable price list with sections, item codes, unit prices and volume tiers, then print it, save it as a PDF or download a CSV.Open the tool
- Quotation GeneratorBuild a clean price quote with line items, discount, tax and terms, then print it or save it as a PDF. Nothing to sign up for.Open the tool
- Margin and Markup CalculatorWork out margin, markup and selling price from cost, convert markup to margin, and see what a discount does to your margin before you quote.Open the tool