Bill of Materials (BOM) Cost Rollup Calculator

Calculates your true finished-good unit cost through up to three stages of production — raw materials into a component, that component into a sub-assembly, and the sub-assembly into a finished good — with overhead and scrap loss compounding correctly at each stage. Also shows batch production cost, margin at your target price, and the price needed to hit a target margin.

✓ True multi-level rollup — most free tools only handle a single flat stage✓ Overhead & scrap compound correctly at each stage, not just at the end✓ Works for 1-stage, 2-stage, or 3-stage builds — no formulas to touch✓ Free Excel download✓ No signup required

Download This Calculator

Get the Excel spreadsheet behind this calculator to use offline, customize for your needs, and publish as a web tool using Sheetflow.

True Multi-Level Rollup

Rolls raw materials into a component, that component into a sub-assembly, and the sub-assembly into a finished good — not just a single flat stage like most free tools.

Overhead & Scrap Compound Correctly

Overhead and scrap loss compound at each stage, not just tacked on at the end — dividing by (1 − scrap rate) at every step instead of applying one rough buffer at the finish line.

Works for 1, 2, or 3-Stage Builds

Leave Stage 2 and/or Stage 3 at their pass-through defaults if your product doesn't need that many stages — no formulas to touch, no fragile multi-tab spreadsheet to maintain.

Frequently Asked Questions

What is a BOM cost rollup, and how is it different from a simple parts list?

A bill of materials (BOM) lists every part and material that goes into a product. A cost rollup takes that list a step further — it calculates the total cost to produce one finished unit by adding up material, labor, overhead, and scrap loss at every stage of production, not just tallying line-item prices.

The distinction matters most when your product has sub-assemblies. A simple parts list might show "10 screws at $0.05, 1 bracket at $2.00" and add them up. A true rollup recognizes that the bracket itself was manufactured from raw material plus labor plus its own overhead and scrap rate — and that cost has to be correctly baked in before it becomes an input to the next stage. Skip that step and you're pricing your product on an incomplete cost, which either erodes your margin without you noticing or makes you overprice when you didn't need to.

How do I calculate the cost of a multi-level BOM step by step?

Work from raw materials upward, one stage at a time, and let each stage's finished cost become the next stage's input cost:

  1. Stage 1: Add raw material cost + labor cost to get a base cost. Apply your overhead rate, then divide by (1 − scrap rate) to get the true cost per usable unit — dividing by scrap rate (not just adding it) is what correctly accounts for the units that don't survive QC.
  2. Stage 2: Multiply Stage 1's unit cost by however many of those units go into one Stage 2 assembly, then add any new material and labor introduced at this stage. Apply Stage 2's own overhead and scrap rate the same way.
  3. Stage 3: Repeat the same pattern to get your finished-good cost.

Using the calculator's defaults: a component costs $13.93 after Stage 1's 15% overhead and 3% scrap. Two of those feed into a sub-assembly that costs $38.13 after Stage 2's own overhead and scrap. That sub-assembly becomes a $50.95 finished good after Stage 3. Each stage's overhead and scrap compounds on top of everything already built into the number before it — that's the part flat, single-level costing sheets miss.

How do I skip Stage 2 or Stage 3 if my product doesn't have that many stages?

Both extra stages are optional and built to pass costs straight through unchanged when you don't need them — you're not forcing your simpler product into a 3-stage structure.

To skip Stage 2 (you go straight from raw materials to a finished good with no separate sub-assembly step), set:

  • Components Per Sub-Assembly = 1
  • Additional Material Cost = $0
  • Labor Cost = $0
  • Overhead Rate = 0%
  • Scrap Rate = 0%

To skip Stage 3 (your product stops at the sub-assembly level), set the same five values to the same defaults in the Stage 3 fields.

With those values in place, that stage's unit cost comes out identical to the stage before it — the calculator correctly reports one number all the way through, whether you're running a 1-stage, 2-stage, or 3-stage build. If you only make a single flat part, set both Stage 2 and Stage 3 to these values and your finished-good cost will simply equal your Stage 1 unit cost.

What's a normal overhead rate and scrap rate for manufacturing?

Overhead rates commonly run 10–25% of direct material and labor cost for small and mid-sized manufacturers, though it varies widely by industry — a job shop with expensive equipment and low volume sits at the high end, while a high-volume, low-complexity operation sits lower. If you don't know your actual overhead rate, a rough starting point is to divide your total annual facility, equipment, and indirect labor cost by your total annual direct material + labor cost.

Scrap rates depend heavily on process maturity and part complexity: well-controlled processes for simple parts often run under 2%, while newer processes, tight tolerances, or hand-assembly steps can run 5% or higher. If your scrap rate is above 5% at any single stage, that stage is usually worth investigating before you finalize pricing — the cost impact compounds forward into every later stage.

Should I price my product off my calculated cost, or off what competitors charge?

Your calculated cost should set the floor, not the price. Competitor pricing tells you what the market will bear; your BOM rollup tells you whether you can profitably meet that price at all. The calculator handles both directions: enter a target selling price to see your resulting margin, or enter a target margin to see the price you'd need to charge to hit it.

Using the defaults, a $50.95 finished-good cost sold at a $75 target price yields a 32.1% gross margin. If your actual target margin is 40%, the calculator shows you'd need to charge $84.92 instead. If that number is above what the market pays, the fix isn't to ignore your cost calculation — it's to go back into the BOM and find where material, labor, overhead, or scrap can realistically come down.

Transform Your Excel Models into Web Tools

Turn your complex Excel calculations into online calculators, web forms, and APIs. No coding required — upload your spreadsheet and publish your calculations instantly.

Calculations are for estimation and planning purposes. Users should verify important results for their specific situations. No signup required. Calculations performed securely.