# BOM Comparison Worksheet: Compare Two BOM Revisions

> Source: https://netray.co/tools/bom-comparison-revision-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Enter quantities and costs for each BOM revision and get the quantity change and cost delta per component, ready to export to Excel.

## Category

engineering-plm

## Industry

Discrete Manufacturing

## Audience

- Engineering manager
- BOM administrator
- Cost accountant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Component

**Key:** component

**Type:** text

#### Description

**Key:** desc

**Type:** text

#### UoM

**Key:** uom

**Type:** select

**Options:**

- EA
- KG
- M
- L
- SET

#### Qty Rev A

**Key:** qty_a

**Type:** number

#### Qty Rev B

**Key:** qty_b

**Type:** number

#### Unit cost

**Key:** cost

**Type:** number

**Format:** currency

#### Qty change

**Key:** dqty

**Type:** number

**Expr:** qty_b - qty_a

**Format:** decimal

#### Cost Rev A

**Key:** cost_a

**Type:** number

**Expr:** qty_a * cost

**Format:** currency

#### Cost Rev B

**Key:** cost_b

**Type:** number

**Expr:** qty_b * cost

**Format:** currency

#### Cost delta

**Key:** dcost

**Type:** number

**Expr:** qty_b * cost - qty_a * cost

**Format:** currency

**Rows:**

**Component:** HM-300-110

**Desc:** Manifold body blank

**Uom:** EA

**Qty a:** 1

**Qty b:** 1

**Cost:** 18.4

**Component:** SL-2210

**Desc:** O-ring 18x2 NBR

**Uom:** EA

**Qty a:** 4

**Qty b:** 6

**Cost:** 0.12

**Component:** FS-M6-25

**Desc:** Screw M6x25 zinc

**Uom:** EA

**Qty a:** 8

**Qty b:** 8

**Cost:** 0.09

**Component:** PL-0045

**Desc:** Plug G1/4 steel

**Uom:** EA

**Qty a:** 3

**Qty b:** 0

**Cost:** 0.55

**Component:** PL-0046

**Desc:** Plug G1/4 stainless

**Uom:** EA

**Qty a:** 0

**Qty b:** 3

**Cost:** 1.1

**Component:** LB-0102

**Desc:** Label, serial plate

**Uom:** EA

**Qty a:** 1

**Qty b:** 1

**Cost:** 0.3

**Totals:**

#### Total cost Rev A

**Key:** cost_a

**Agg:** sum

**Format:** currency

#### Total cost Rev B

**Key:** cost_b

**Agg:** sum

**Format:** currency

#### Net cost delta

**Key:** dcost

**Agg:** sum

**Format:** currency

**Summary:**

#### Cost change

**Key:** pct

**Expr:** if(gt(sum_cost_a, 0), sum_dcost / sum_cost_a * 100, 0)

**Format:** percent

**Primary:** true

#### Lines compared

**Key:** lines

**Expr:** count

**Format:** integer

**Notes:** Enter a component with Rev A quantity 0 for an added line, and Rev B quantity 0 for a removed line. Use one unit cost per component so the delta reflects quantity changes only. If the cost also changes between revisions, add a second row for the same component and note it.

## Content

**Intro:** When a BOM goes from Revision A to Revision B, you need to know exactly what was added, removed or changed in quantity, and what it does to cost. This worksheet lets you key or paste the two revisions side by side and gives the delta per line and in total.

**Sections:**

#### How to use the BOM comparison worksheet

**Body:** List every component that appears in either revision, one per row. Enter its quantity per parent in Revision A and Revision B, using zero where the component does not exist. Enter a unit cost, typically the standard cost or latest purchase price. The sheet calculates the quantity change, the extended cost in each revision and the cost delta, then totals them and shows the percentage cost change. Export to Excel to share with the change control board or attach the CSV to the ECO. Start from a BOM export from your ERP so that component numbers match exactly.

**Bullets:**

- Use identical component numbers in both columns, no retyping
- Zero in Rev A means added, zero in Rev B means removed
- Compare at the same level and the same unit of measure
- Sort by cost delta to find the lines that matter

#### What counts as a BOM change

**Body:** A real comparison covers more than quantity. Typical differences are added or removed components, quantity per changes, unit of measure changes, substitutes and alternates, scrap or yield factors, reference designators in electronics, operation assignment of a component, and effectivity dates. This worksheet focuses on quantity and cost because those drive the financial and planning impact. For the other attributes, add notes to the description column or compare the exported ERP tables in a spreadsheet. In SAP the relevant data sits in the STKO and STPO tables, and in other systems the equivalent BOM header and component tables.

#### Worked example

**Body:** The sample rows show a Revision B that adds two O-rings, swaps a steel plug for a stainless one and leaves the rest unchanged. The extended cost of the O-rings rises by 0.24, removing the three steel plugs saves 1.65, and adding three stainless plugs costs 3.30. The net effect is a small increase. That is the kind of result a change board needs: a clear statement that the revision costs slightly more per assembly, so the benefit (for example corrosion resistance) can be weighed against it. Multiply the per-unit delta by annual volume for the full financial picture.

#### Common mistakes

**Body:** Comparing different BOM levels, such as a single-level BOM on one side and a flattened multilevel BOM on the other, produces false differences. Mixing units of measure (meters versus millimeters) causes quantity errors that look like real changes. Forgetting that a phantom assembly can hide component changes is another trap. Finally, comparing cost with different cost bases (standard in one, last purchase in the other) mixes price effects with design effects. Fix the cost basis first, then compare designs, then separately review price variances.

**Cta:** If you compare BOMs by hand often, Netray can help automate revision comparison straight from your ERP BOM tables with a read-only query. The worksheet is free to use as it is.

**Faq:**

#### How do I compare two BOMs in Excel?

**Answer:** List all components from both BOMs in one column, then use lookups or this worksheet to show each revision quantity side by side. Subtract to get the change. Rows where one side is zero are added or removed components.

#### Can I paste a BOM export into this worksheet?

**Answer:** You can enter rows manually, and exporting to Excel lets you extend the sheet with your own data. Keep component numbers consistent between revisions so that changes are not reported as separate additions and removals.

#### Does it compare multilevel BOMs?

**Answer:** It compares whatever rows you enter. For a multilevel comparison, explode both BOMs to the same depth and level first, or compare each sub-assembly separately, then roll the deltas up.

#### Why does cost delta ignore price changes?

**Answer:** It uses a single unit cost per component so the delta shows the effect of design change alone. Price changes are a purchasing matter, and mixing both makes it unclear what the engineering change actually cost or saved.

## Search terms

BOM comparison excel, compare two BOMs, BOM revision comparison, BOM difference worksheet, bom compare template, bill of materials revision change, BOM cost delta, ECO BOM changes

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json