BOM Template — Bill of Materials Format
List the components of a product with quantity per unit and scrap %, and see the quantity to issue and the material cost for any batch — online or in the Excel template.
| Component | Qty / unit | Unit | Scrap % | Rate (₹) | Qty for batch | Cost | |
|---|---|---|---|---|---|---|---|
| 47.25 | ₹15,120 | ||||||
| 40 | ₹7,200 | ||||||
| 10.2 | ₹969 |
Batch of 10 × SS work table 4 ft
₹23,289 · ₹2,328.9 per unit
BOM template in Excel
- Levels for sub-assemblies
- Scrap % added to issue quantity
- Batch quantity and cost per unit
- 25 rows with formulas
Embed this tool on your website
Free to use. Paste this where you want the calculator to appear:
<iframe src="https://cre8r.tech/embed/bom-template" title="BOM Template in Excel – Free Bill of Materials Format" width="100%" height="720" style="border:1px solid #e5e7eb;border-radius:12px;max-width:820px" loading="lazy"></iframe> <p style="font-size:13px">Tool by <a href="https://cre8r.tech/bom-template">CRE8Rx ERP</a></p>
Quick answer
A BOM (bill of materials) lists every component and material needed to make one unit of a product, with quantity, unit and scrap allowance. Batch requirement = quantity per unit × (1 + scrap %) × batch size; adding rate gives the batch cost and cost per unit. Use the calculator or download the Excel template.
| Full form | Bill of Materials |
|---|---|
| Issue quantity | Qty per unit × (1 + scrap %) × batch |
| Levels | Assemblies, sub-assemblies, parts, raw material |
| Cost | Free — no sign-up, runs in your browser |
A bill of materials (BOM) is the list of everything that goes into one unit of a product: raw materials, bought-out parts and sub-assemblies, each with the quantity per unit. Purchase plans from it, stores issue from it, and costing prices it.
The formula
- Quantity to issue
Qty per unit × (1 + scrap % ÷ 100) × batch quantity- Line cost
Quantity to issue × rate- Cost per unit
Batch cost ÷ batch quantity
How to make a BOM
- 1
Start from the drawing
Take the product's latest approved drawing and revision so the BOM matches what will actually be built.
- 2
Break it into levels
List the top assembly, its sub-assemblies, and the parts and raw materials inside each.
- 3
Add quantity and unit per product
For each line enter the quantity needed for one finished unit and its unit — kg, nos, metre, set.
- 4
Add scrap allowance
Add a scrap or wastage percentage where material is cut or machined, so the issue quantity covers it.
- 5
Add item codes and rates
Link each line to its item code in the item master and its current rate to get the cost per unit.
- 6
Approve and control revisions
Have engineering approve the BOM, and record any later change as a new revision so purchase and production use the current one.
What a BOM format should have
The finished product and its revision, then for each component: level (1 for direct parts, 2 and 3 for parts of a sub-assembly), item code, description, quantity per unit, unit, scrap or wastage percent, and rate — so the same sheet gives both the issue quantity and the material cost.
From a spreadsheet BOM to one the whole factory uses
A BOM in Excel works for one person. When purchase, stores and production each keep their own copy, revisions drift apart. A BOM in an ERP is one version for everyone: approved by design, exploded into purchase requisitions, issued against job cards, and costed with live purchase rates.
Questions people ask.
What is a BOM?
A bill of materials — the list of raw materials, parts and sub-assemblies, with quantities, needed to make one unit of a product.
What is included in a BOM template?
Product, revision and batch quantity; for each component the level, code, description, quantity per unit, unit, scrap % and rate, with formulas for issue quantity and cost.
Why add scrap % to a BOM?
Cutting and processing waste part of the material; adding the scrap % makes the issue quantity and cost match what is actually consumed.
What is the difference between a single-level and multi-level BOM?
A single-level BOM lists only direct components; a multi-level BOM also lists the parts of each sub-assembly, marked with levels.
Can I download a BOM format in Excel?
Yes — the template has 25 component rows with formulas for issue quantity, cost, batch cost and cost per unit.
Related free tools
See all free toolsDoing this for every item, every day?
A calculator is the right tool once. When it is every item in the store, it belongs in the system that already knows the numbers.