Infor LN Standard Cost Rollup Calculator
Before you load cost components in Infor LN, it helps to check the arithmetic on one item by hand. This calculator builds a unit standard cost from the same elements you maintain in item and routing data. It exports to PDF or Excel for review with finance.
Your numbers
Your results
A simplified single level model. LN costing also includes subcontracting, surcharges and multi level rollups.
Unit cost vs lot size
Sweeps Standard lot size from 1 to 500, holding your other inputs fixed.
Cost variance review
An optional review of costing set up against your LN routing and BOM data.
Optional. The tool and every export work without this. No spam.
How to use it
Enter the material cost, scrap allowance, setup and run times, the lot size used for costing, and the labor, machine and overhead rates. The result shows each element per unit and the total. Compare it against what LN calculates for the same item. A gap usually points to a wrong lot size, a missing routing operation or a rate that differs between the costing and the operation.
How the cost is built
Material is increased by the scrap allowance. Setup time is spread across the costing lot, so small lots carry more setup per unit, which the chart makes obvious. Conversion cost is hours times labor and machine rates, and overhead is applied as a percentage of labor here. Some companies apply overhead to machine hours instead, so adjust to match your policy.
Common mistakes
Costing at a lot size that production never runs inflates or deflates the standard. Applying scrap in both the BOM and the cost step double counts it. Mixing a rate that already includes overhead with a separate overhead percent also doubles the burden. Document each assumption next to the result when you submit a cost change.
Frequently Asked Questions
Does this replace the LN costing run?
No. It is a sanity check on one item. The costing run in LN handles multi level BOMs, subcontracting and surcharges. Use this to confirm the logic and to explain a result to finance.
Which lot size should I use?
Use the lot size that production actually runs, not the theoretical best. If a cost standard assumes a lot of 500 and the shop runs 50, setup variance will appear every month.
How is scrap treated?
Here scrap increases the material cost by the percentage. If your BOM already carries a scrap percent, do not add it again in the calculation.
Can I model overhead on machine hours?
You can approximate it by setting the machine rate to include the overhead and the overhead percent to zero. Make sure the same rule is applied everywhere or the comparison will not tie.
If you need cost differences explained across thousands of LN items, we can build a read-only comparison on your data.
Related Tools
Infor LN EOQ Order Quantity Calculator
Calculate economic order quantity, orders per year and total annual cost, then use the result to set LN item ordering data.
Infor LN & BaanInfor LN Landed Cost Allocation Worksheet
An editable worksheet that adds duty and freight to purchase lines to show landed cost per unit and the total uplift.
Infor LN & BaanInfor LN Project Earned Value Calculator
Compute earned value, CPI, SPI and forecast cost at completion from budget, planned and actual percent complete and actual cost.
Infor LN & BaanInfor LN Safety Stock and Reorder Point Calculator
Compute safety stock, reorder point and the equivalent safety time in days, with a lead time what-if chart.
More Infor LN & Baan tools
See all- Infor LN Session and Module Code Reference
- Infor LN Production Order Status and Lifecycle Reference
- Infor LN 4GL Session Script Template
- Infor LN Company and Enterprise Unit Design Worksheet
- Infor LN DAL Hook Review Checklist
- Infor LN Warehousing Order Origins and Types Reference
- Infor LN Table Name and SQL Query Builder
- Infor LN Regression Test Effort Calculator
- Infor LN and Baan Customization Inventory Worksheet