NetSuiteFree calculatorPDF, Excel, Word exportOracle NetSuiteDiscrete Manufacturing

NetSuite Assembly Item Standard Cost Rollup Calculator

Standard cost for an assembly is the sum of material, labor and overhead per unit at a defined lot size. This calculator shows the rollup logic behind the cost you load into NetSuite, and how the lot size you assume changes the setup burden per unit.

Your numbers

$
hours
min
$/hour
%
100 units

Your results

Standard cost per unit
$44
Material share of cost
87.4%
Setup cost per unit
$1
Run labor per unit
$3
Total labor per unit
$4
Overhead per unit
$2
Standard cost per lot
$4,407

Simplified single-operation rollup. Real routings have several operations, work centers and machine rates; sum them the same way.

Save results:

Standard cost per unit vs lot size

Sweeps Standard lot size from 10 to 500, holding your other inputs fixed.

Standard cost drift review

Optional: we can outline a read-only comparison of standard cost against actual work order cost in NetSuite.

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

How to use it

Enter the BOM material cost per unit, the setup time per lot, the run time per unit, a labor rate and the overhead rate applied to labor. Set the standard lot size. The result splits cost into material, setup, run and overhead. Drag the lot size slider to see the setup effect: small lots carry a heavy per-unit setup cost, and the curve flattens as lots grow. Use the number as a cross-check against what your costing run produces.

The method

Setup cost per unit is setup hours times the labor rate divided by lot size. Run labor per unit is run minutes divided by 60 times the rate. Overhead is applied as a percentage of labor here, but your organization may absorb it on machine hours or per unit instead; the structure of the rollup is the same. Standard cost is material plus labor plus overhead. For multi-level assemblies, roll up lowest-level items first so each parent picks up the correct child cost.

  • Cost lowest-level subassemblies first
  • Keep lot size consistent between costing and planning
  • Review overhead basis with finance before changing it

Reading it and common mistakes

Material share tells you where cost reduction effort belongs; above 70 percent, labor tweaks hardly matter. A frequent mistake is costing at a lot size that never occurs, so actual setup absorption differs from standard and generates unfavorable variances every month. Another is leaving stale labor rates in place after a wage change. Compare the output to your actual average work order lot size and update the standard when the gap becomes persistent.

Frequently Asked Questions

Does this replace the NetSuite cost rollup?

No. It is a transparent cross-check of the arithmetic. NetSuite performs the actual rollup from your BOM, routing and cost settings, and results depend on your costing method and configuration.

How should overhead be applied?

Common bases are direct labor hours, machine hours or a percentage of labor cost. Use the base that best correlates with how overhead is consumed. Your cost accountant should own the choice.

What lot size should I use for standard cost?

Use a representative lot size from recent history, often a median of completed work orders. A lot that is rarely built produces misleading standards.

Does scrap belong in the standard?

If scrap is stable and expected, include it through yield on material and labor so the standard reflects realistic consumption. Treat abnormal scrap as a variance, not as part of the standard.

Netray can pull actual lot sizes, routing times and component costs from NetSuite to show which standards have drifted from reality.