Part Standard Cost Build-Up Calculator for Infor VISUAL
A standard cost is a sum of pieces that each have their own assumptions. This tool makes those pieces explicit for a single part, so you can check what Infor VISUAL will roll up or test a quote before it leaves the building.
Your numbers
Your results
A simplified single-level build-up. Your ERP costing method, cost pools and rounding rules may differ.
Standard cost per unit vs lot size
Sweeps Lot size from 5 to 500, holding your other inputs fixed.
Cost comparison from your ERP
Optional: compare calculated cost against system cost for a set of parts.
Optional. The tool and every export work without this. No spam.
How to use it
Enter the net material cost per unit and a scrap allowance. Add setup hours per lot and the lot size, then run hours per unit. Provide the labor wage and your overhead rate per labor hour, plus any outside processing such as plating or heat treat. The tool shows each component per unit, the standard cost and the cost of a full lot. Compare the result with the cost your system shows for the same part.
- Use the same lot size as the part's costing quantity
- Include inbound freight in material if you cost it
- Keep outside processing at the vendor price
- Check unit of measure conversions
The formula behind it
Material is net cost times one plus the scrap allowance. Setup is spread across the lot, so setup hours per unit equal setup hours divided by lot size. Labor hours per unit are run hours plus that setup share. Labor cost multiplies by the wage, and overhead multiplies the same hours by the overhead rate. Standard cost is material plus labor plus overhead plus outside processing, the usual roll-up of a single-level routing.
Reading the result
The chart shows setup cost fading as the lot grows, flattening toward run cost plus material. If the curve is steep near your usual lot, small lots are costing more than the standard assumes, and variances will appear. A material share above 60% to 70% means purchase price is the main lever, while a high labor and overhead share points to routing and setup improvements. Always cost at the quantity you really run.
Common mistakes
Setting a standard at a large lot size but producing small lots hides a permanent unfavorable variance. Counting scrap in both the material and the routing yield double counts it. Others apply overhead to outside processing hours that never touch your floor. When you compare with the system, confirm the same cost method and that the burden is applied to hours, not to dollars, in the same way.
Frequently Asked Questions
Why does setup depend on lot size?
Setup happens once per lot, so its cost is shared across all units in that lot. Doubling the lot halves the setup cost per unit, which is why small lots cost more per piece.
Should scrap be on material only?
It depends on where scrap occurs. If it happens at the first operation, applying it to material is common. Scrap late in a routing also wastes labor, so use yield by operation for accuracy.
Can I use this for quotes?
Yes, as a cost base. Add margin, tooling and any one-time charges separately. For quotes, use the actual quote quantity as the lot size.
How does this relate to multilevel BOMs?
This is a single-level build-up. For assemblies, roll up each component's cost, then add assembly labor and burden. The BOM cost worksheet in this series handles the component side.
If you need cost build-ups checked across thousands of parts from your ERP, we can build a read-only comparison of calculated and system cost.
Related Tools
VISUAL Labor Overhead and Machine Burden Rate Calculator
Derive burden rates per direct labor hour and per machine hour, then cost a job on either basis. Includes a volume sensitivity chart.
Costing & FinanceVISUAL BOM Component Cost Roll-Up Worksheet
Editable table to list components, quantity per, scrap and cost, with extended cost and a total per assembly.
Discrete ManufacturingVISUAL EOQ and Lot Size Setup Cost Calculator
Compute economic order quantity and see what your current lot size costs per year, with a sweep chart across lot sizes.
MES & Shop FloorVISUAL Shop Resource Capacity and Load Calculator
Find available capacity hours, load percentage and the number of machines needed for a work center, plus an efficiency sweep.
More Costing & Finance tools
See all- VISUAL Month-End Inventory Reconciliation Checklist
- SAP QM Inspection Effort and Cost Calculator
- SAP Standard Cost Estimate BOM Rollup Calculator
- Legacy ERP Retirement Cost and Payback Calculator
- JD Edwards World Month-End Close Procedure Template
- Distributor Customer Credit Application Template
- Distributor Customer Profitability Worksheet
- Distributor GMROI and Inventory Turns Calculator
- Vendor Early Pay Discount Worksheet