# SAP Business One BOM Cost Rollup Worksheet

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

## Short answer

An editable component cost worksheet with scrap allowance that rolls up material cost per finished unit, for checking a Business One BOM before loading it.

## Category

sap

## Erp

SAP Business One

## Industry

Discrete Manufacturing

## Audience

- Cost accountant
- Production planner
- Engineer
- B1 consultant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Component

**Key:** component

**Type:** text

#### Type

**Key:** kind

**Type:** select

**Options:**

- Raw material
- Purchased part
- Sub-assembly
- Packaging

#### Qty per parent

**Key:** qty

**Type:** number

#### Scrap allowance

**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:**

**Component:** Steel bar 40 mm, per metre

**Kind:** Raw material

**Qty:** 0.45

**Scrap:** 6

**Cost:** 8.2

**Component:** Bearing 6205-2RS

**Kind:** Purchased part

**Qty:** 2

**Scrap:** 0

**Cost:** 3.15

**Component:** Housing sub-assembly

**Kind:** Sub-assembly

**Qty:** 1

**Scrap:** 2

**Cost:** 14.6

**Component:** Seal kit

**Kind:** Purchased part

**Qty:** 1

**Scrap:** 0

**Cost:** 1.75

**Component:** Carton and foam insert

**Kind:** Packaging

**Qty:** 1

**Scrap:** 1

**Cost:** 0.95

**Totals:**

#### Material cost per parent unit

**Key:** ext

**Agg:** sum

**Format:** currency

**Summary:**

#### Component lines

**Key:** lines

**Expr:** count

**Format:** integer

#### Average extended cost per line

**Key:** avg_line

**Expr:** sum_ext / count

**Format:** currency

#### Material cost for 100 units

**Key:** batch100

**Expr:** sum_ext * 100

**Format:** currency

**Primary:** true

**Notes:** Scrap allowance is entered as a percent of the quantity per parent. Add labour and overhead outside this sheet, or as separate lines with a type of your choice. Compare the result with the item cost shown in Business One after loading the BOM.

## Content

**Intro:** Before a bill of materials goes into Business One, someone should check that its material cost makes sense. This worksheet rolls up component cost with a scrap allowance so you can compare it with the cost the system shows.

**Sections:**

#### How to use the worksheet

**Body:** List each component from the BOM with the quantity needed for one parent unit, a scrap allowance and the current unit cost. The extended cost column multiplies quantity by one plus the scrap percentage by the unit cost. The total is the material cost per finished unit. Add or delete rows, then export to Excel to share with engineering and finance.

#### The formula

**Body:** Extended cost equals quantity times (1 plus scrap divided by 100) times unit cost. Scrap here is the extra quantity you expect to consume beyond the theoretical requirement, due to cutting loss, setup or rejects. If the BOM already includes the scrap in its quantity, enter zero to avoid double counting. Sub-assemblies should carry their own rolled-up cost from a separate sheet or from the system.

#### Using it with Business One

**Body:** Business One production BOMs list components with quantities per parent, and production orders consume them at the configured issue method. Item cost depends on your valuation method, for example standard, moving average or FIFO, so the system cost may differ from this sheet when purchase prices move. Use the sheet as a sanity check on newly migrated BOMs, not as a replacement for the system's costing.

**Bullets:**

- Explode one finished good fully and compare each line
- Check units of measure for each component
- Investigate any line more than a few percent away from the system cost

#### Common mistakes

**Body:** Mixing purchase UoM and inventory UoM, such as costing per metre against a quantity in millimetres. Forgetting packaging and consumables. Using a stale price list. Entering scrap twice, once in the BOM quantity and once here.

**Cta:** If you want BOM and cost anomalies flagged automatically from live ERP data, Netray can build a read-only reporting layer for your system.

**Faq:**

#### Does this replace Business One costing?

**Answer:** No. It is a check on material cost for one BOM. The system's valuation method, overhead and variance accounts determine actual postings. Differences are a prompt to investigate, not necessarily an error.

#### How should I treat scrap?

**Answer:** Enter the expected extra consumption as a percent of the theoretical quantity. Base it on measured yield. If a process loses 5 percent, enter 5. Do not add scrap if the BOM quantity already includes it.

#### How do I cost multi-level BOMs?

**Answer:** Roll up the lowest level first, then enter each sub-assembly's cost as a unit cost in the parent sheet. Repeat up the structure. This keeps each sheet short and easy to audit.

#### Can I add labour and overhead?

**Answer:** Yes. Add lines with a quantity in hours and a rate as the unit cost. Keep the type labelled, so you can separate material from conversion cost when comparing with the system.

## Search terms

bom cost rollup excel, sap business one bom cost, bill of materials costing template, sap b1 production bom cost check, material cost per unit worksheet, bom scrap allowance calculation, standard cost rollup spreadsheet

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