# BOM Component Cost Roll-Up Worksheet for Infor VISUAL

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

## Short answer

Editable table to list components, quantity per, scrap and cost, with extended cost and a total per assembly.

## Category

cost-finance

## Erp

Infor VISUAL

## Audience

- Cost accountant
- Engineer
- Estimator

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Component part

**Key:** part

**Type:** text

#### Description

**Key:** desc

**Type:** text

#### UoM

**Key:** uom

**Type:** select

**Options:**

- EA
- FT
- M
- KG
- LB
- SET

#### Qty per assembly

**Key:** qty

**Type:** number

#### Scrap %

**Key:** scrap

**Type:** number

**Unit:** %

#### Unit cost

**Key:** cost

**Type:** number

**Format:** currency

#### Extended cost

**Key:** ext

**Type:** number

**Expr:** qty * (1 + scrap / 100) * cost

**Format:** currency

**Rows:**

**Part:** HSG-2201

**Desc:** Housing, machined

**Uom:** EA

**Qty:** 1

**Scrap:** 2

**Cost:** 38.4

**Part:** SHF-0415

**Desc:** Drive shaft

**Uom:** EA

**Qty:** 1

**Scrap:** 1

**Cost:** 22.75

**Part:** BRG-6204

**Desc:** Ball bearing

**Uom:** EA

**Qty:** 2

**Scrap:** 0

**Cost:** 4.15

**Part:** SEAL-118

**Desc:** Shaft seal

**Uom:** EA

**Qty:** 2

**Scrap:** 0

**Cost:** 1.9

**Part:** FSN-M6x20

**Desc:** Cap screw M6x20

**Uom:** EA

**Qty:** 8

**Scrap:** 5

**Cost:** 0.12

**Part:** WIRE-22AWG

**Desc:** Lead wire

**Uom:** FT

**Qty:** 3.5

**Scrap:** 8

**Cost:** 0.31

**Totals:**

#### Total material cost per assembly

**Key:** ext

**Agg:** sum

**Format:** currency

**Summary:**

#### Average cost per component line

**Key:** avg_line

**Expr:** sum_ext / count

**Format:** currency

#### Highest single line cost

**Key:** max_line

**Expr:** max_ext

**Format:** currency

**Notes:** Single-level worksheet. For multilevel assemblies, cost each subassembly first, then enter it as a component line. Scrap % is added on top of quantity per.

## Content

**Intro:** Before a quote or a cost review, many teams rebuild a bill of material in a spreadsheet. This worksheet does the arithmetic for you: quantity, scrap, unit cost and extended cost, with a running total you can export to Excel.

**Sections:**

#### How to use it

**Body:** Replace the sample rows with your components. Enter the part number, description, unit of measure, quantity per assembly, scrap percent and current unit cost, from a purchased price or a rolled-up subassembly cost. The extended cost computes for each row and the total updates at the bottom. Add rows for each level you cost, then export to Excel to share with purchasing or finance.

**Bullets:**

- Use the same unit of measure as the cost
- Cost subassemblies first and enter them as lines
- Add a line for packaging and consumables
- Keep a date for the cost source

#### The formula behind it

**Body:** Extended cost for a line is quantity per assembly times one plus scrap percent divided by 100, times unit cost. Total material cost is the sum of extended costs. This matches the usual material roll-up where a scrap or shrink factor inflates the required quantity. The summary shows the average line cost and the highest line, which highlights where purchasing effort pays off.

#### Reading the result

**Body:** Sort mentally by extended cost: in most assemblies a few lines make up the majority of material cost, so concentrate on those. If the total differs from your ERP's rolled cost, check unit of measure conversions, scrap factors, phantom assemblies and which cost field (standard, average, last) the system uses. A mismatch often traces to a stale price in one expensive line rather than a general error.

#### Common mistakes

**Body:** Typical errors are entering a purchase unit price per box while quantity per is in each, forgetting scrap on cut-to-length materials, and leaving out labor and overhead, which this worksheet does not include. Others use last price for some parts and standard for others, so the total mixes bases. Finally, remember effective dates: a cost taken from an outdated revision of the BOM can mislead the whole review.

**Cta:** If you want BOM cost roll-ups produced from live ERP structures at scale, we can build that analysis in your environment.

**Faq:**

#### Does this include labor and overhead?

**Answer:** No, only material lines. Use the part standard cost build-up calculator for labor, burden and outside processing, then add the result as a line for a subassembly.

#### How do I handle phantom assemblies?

**Answer:** Enter the phantom's components directly in the parent list, since phantoms are not stocked or costed separately. Keep a note that those lines come from a phantom.

#### What scrap percent should I use?

**Answer:** Use measured yield or purchase overage from history. Common examples are a few percent for machined parts and higher for cut wire, film or sheet nesting.

#### Can I export it?

**Answer:** Yes. Use the export controls to download Excel, PDF or CSV. The computed extended costs and totals are included.

## Search terms

bom cost rollup excel, bill of material cost worksheet, visual manufacturing bom cost, material cost per assembly template, component cost with scrap, bom costing spreadsheet

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