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
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
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.
Other free tools
Doing 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.