Bill of Materials (BOM) Calculator & Excel Template
Calculate total unit manufacturing cost (COGS) and export clean Bill of Materials templates to Excel. Roll up multi-component raw materials, scrap waste rates, direct assembly labor, and factory overhead burden.
1. Component & Raw Material Schedule
5 Parts| Part Number | Description | Unit Cost ($) | Qty/Unit | Scrap % | Total Cost | |
|---|---|---|---|---|---|---|
$ | % | $3.26 | ||||
$ | % | $4.90 | ||||
$ | % | $6.46 | ||||
$ | % | $1.21 | ||||
$ | % | $2.83 | ||||
| Subtotal Raw Materials (incl. Scrap): | $18.67 | |||||
2. Assembly Labor & Factory Burden
Operator wage + payroll taxes.
Assembly & inspection duration.
Tooling, rent, utilities, depreciation.
Wholesale or direct retail target margin.
Free, no signup. Your parts list with live roll-up formulas.
Multi-Level BOM & Batch Costing Workbook
Parts master, multi-level BOM with scrap-adjusted line costs, batch labor and overhead costing, and cost per unit.
Frequently Asked Questions: Bill of Materials (BOM) & Product Costing
What is the standard Bill of Materials (BOM) format in Excel?
A production-grade manufacturing BOM format in Excel includes: BOM Level (Indented depth 0 for Finished Good, 1 for Sub-assembly, 2 for Component), Item / Part Number, Description, Quantity per Assembly, Unit of Measure (UOM), Scrap Yield % factor, Unit Material Cost, and Extended Line Cost. Formatting the range as an Excel Table (Ctrl + T) allows formulas to auto-expand dynamically as new raw material line items are added.
What is the difference between Single-Level and Multi-Level (Indented) BOMs?
A Single-Level BOM displays only the immediate parent assembly and its direct child components. A Multi-Level (Indented) BOM depicts a full nested product hierarchy: the top-level finished good, sub-assemblies, intermediate components, and all raw materials. Multi-level BOMs are essential when components must be manufactured or sub-contracted before final assembly.
How is manufacturing direct labor burden calculated?
Direct labor is determined by multiplying the assembly worker's total hourly loaded rate (base wage + mandatory payroll taxes + benefits) by the cycle time in hours.Direct Labor Cost = Loaded_Hourly_Wage * (Cycle_Time_Minutes / 60)
How does factory overhead allocation work?
Factory overhead includes indirect production costs that cannot be tied directly to a single unit (e.g. facility rent, CNC machine depreciation, CAD software licenses, quality control supervisors, and shop floor electricity). Most manufacturers allocate overhead either as a percentage of Prime Cost (Material + Labor) or based on machine hours.