Costing & FinanceFree worksheetPDF, Excel, Word exportInfor VISUALAll Infor VISUAL tools

BOM Component Cost Roll-Up Worksheet for Infor VISUAL

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.

Free, optional. Reopen it on any device.

Download:

Component part	Description	UoM	Qty per assembly	Scrap % (%)	Unit cost	Extended cost
						$39
						$23
						$8
						$4
						$1
						$1

Total material cost per assembly

$76

Average cost per component line

$13

Highest single line cost

$39

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.

BOM cost comparison from your ERP

Optional: we can compare spreadsheet roll-ups to ERP cost for a set of assemblies.

Optional. The tool and every export work without this. No spam.

Was this tool useful?

How to use it

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.

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

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

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

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.

Frequently Asked Questions

Does this include labor and overhead?

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?

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?

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.