Skip to content
Free tool · no sign-up

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.

ComponentQty / unitUnitScrap %Rate (₹)Qty for batchCost
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
Download Excel templateFree · no sign-up · works in Excel and Google Sheets
Share WhatsApp LinkedIn
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.

Key facts
Full formBill of Materials
Issue quantityQty per unit × (1 + scrap %) × batch
LevelsAssemblies, sub-assemblies, parts, raw material
CostFree — 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. 1

    Start from the drawing

    Take the product's latest approved drawing and revision so the BOM matches what will actually be built.

  2. 2

    Break it into levels

    List the top assembly, its sub-assemblies, and the parts and raw materials inside each.

  3. 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. 4

    Add scrap allowance

    Add a scrap or wastage percentage where material is cut or machined, so the issue quantity covers it.

  5. 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. 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.

Common questions

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.

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.