Infor LN Landed Cost Allocation Worksheet
Landed cost spreads freight, duty and other import charges over what you buy, so your inventory value and margins reflect reality. In Infor LN the Landed Costs functionality does this at scale, but buyers need a quick check before a deal. This worksheet does it line by line and exports to Excel.
| Item | Qty | Unit price | Goods value | Weight (kg) | Duty % | Freight per kg | Duty | Freight | Landed cost | Landed per unit | |
|---|---|---|---|---|---|---|---|---|---|---|---|
$8,500 | $425 | $307 | $9,232 | $231 | |||||||
$4,668 | $163 | $720 | $5,551 | $46 | |||||||
$10,875 | $0 | $578 | $11,453 | $23 | |||||||
$1,880 | $150 | $304 | $2,334 | $3 |
Freight is allocated by weight and duty by value in this worksheet. Rates shown are examples only. Confirm duty rates for your tariff classification and the allocation basis your finance team uses.
Landed cost automation
An optional review of automating landed cost checks from LN receipts.
Optional. The tool and every export work without this. No spam.
How to use it
Add one row per item with quantity, unit price, total weight, duty rate and the freight rate per kilogram. The sheet computes goods value, duty, freight, landed cost and landed cost per unit. The totals and uplift line show how much the import costs add to the goods value. Change the rows to test alternative suppliers or shipping modes.
Allocation basis
Charges can be allocated by value, weight, volume or quantity, and the choice changes landed cost per item. Duty is naturally a function of value in most tariffs, and freight usually follows weight or volume. Heavy and cheap items absorb more freight per dollar than light and expensive ones, which is why a flat percentage markup misleads.
Common mistakes
Leaving out brokerage, insurance, port fees and inland haulage, which can add several percent. Using a duty rate from an old tariff or the wrong classification. Mixing currencies without applying the exchange rate at the right date. And updating standard cost only once a year when freight rates move monthly.
Frequently Asked Questions
What is landed cost?
The total cost to bring an item to your door: purchase price plus freight, insurance, duty, brokerage and other charges directly tied to the shipment. It is the basis for inventory valuation and a true margin.
Should I allocate by weight or value?
Use the basis that matches how the charge arises. Freight usually by weight or volume, duty and insurance by value. Be consistent and document the rule so costs are comparable over time.
Is the sample duty rate correct for my goods?
No. Sample rates are illustrative. Duty depends on the tariff classification, origin and any trade agreement, so confirm with your customs broker.
Can I download this?
Yes. The worksheet exports to Excel or PDF with your rows and totals, so you can attach it to a purchase approval.
If you want landed cost variances flagged automatically from your purchase receipts, we can build that against your LN data.
Related Tools
Infor LN Standard Cost Rollup Calculator
Check a single level standard cost build up: material with scrap, setup spread over lot size, run time, labor, machine and overhead.
Infor LN & BaanInfor 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 Cycle Count Workload Calculator
Turn ABC class sizes and count frequencies into counts per day, labor hours and the number of counters you need.
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.
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
New to Infor LN and Baan? Start with the Infor LN and Baan guide and toolkit, or plan with Training Path Builder, Upgrade Path Planner, ERP Table and Field Explorer.
Keep exploring
Free tools
- Infor LN AI Assistant Sizing and Value CalculatorSize the GPUs and estimate the monthly value and payback of a private, on-prem AI assistant for Infor LN.
- Infor LN Company and Enterprise Unit Design WorksheetPlan LN companies, enterprise units, sites and currencies row by row, with user and volume totals, and export to Excel.
- Infor LN Private AI Layer Blueprint GeneratorFill in your Infor LN environment and get a ready-to-share architecture plan for a private, on-prem AI assistant.
ERP fixes and how-tos
- SYSPRO Landed Cost Tracking: Freight, Duty and AllocationHow landed cost tracking works in SYSPRO: freight and duty, allocation methods, GRN receipts, and the effect on inventory valuation. A practical setup checklist.
- Conversion Factor Session in Infor LN: Setup and Common ErrorsHow unit conversion factors work in Infor LN: general factors versus item-specific factors, where to maintain them and how to fix missing conversion factor errors.
- Infor LN Master Planning: How It Works and a Setup and Run ChecklistHow master planning works in Infor LN: planned orders, pegging, planning horizons and a practical setup and run checklist for planners and consultants.
Runs with your ERP
- CloudLeap and Infor LN: ERP-integrated multi-carrier shippingCloudLeap adds carrier selection to Infor ERP such as LN through connectors, APIs and webhooks. Data flows, setup, pitfalls and a private AI layer.
- Infor Factory Track with Infor LN: barcode inventory, labor and lot or serial traceabilityFactory Track covers barcode inventory, job material, labor and lot or serial traceability for Infor LN and SyteLine. Setup, pitfalls and a private AI layer.
- Vertex with Infor LN: sales and use tax and VAT calculationHow Vertex indirect tax software works with Infor LN, SyteLine, M3 and other Infor ERPs for sales and use tax and VAT, with setup steps, pitfalls and AI use.
Guides
- Infor LN Accounts Receivable Setup and Credit ManagementConfigure Infor LN accounts receivable with credit management, dunning procedures, payment allocation, and AR aging setup for optimized cash collection cycles.
- Infor LN Cloud Deployment OptionsEvaluate Infor LN cloud deployment options. Multi-tenant, single-tenant, hybrid, and on-premise comparisons for enterprise manufacturers.
- Infor LN Printing and Report Design GuideDesign Infor LN reports and configure printing. Report session development, document output, label printing, and Crystal Reports integration for LN.
AI on your ERP
- AI for Infor LN in Aerospace and Defense ManufacturingAI grounded on Infor LN project, contract, and configuration management data for aerospace and defense manufacturers, with on-prem deployment for ITAR.
- AI for Infor LN: Sessions, BODs, and Engineer-to-Order WorkAdd grounded AI to Infor LN 10.x or CloudSuite: natural-language answers over sessions and BODs, agents for project and engineer-to-order work, on-prem options.
Integrations
- How to add AI agents to Infor LNHow to add AI agents to Infor LN: a tool layer over ION API and BODs, read-only reporting first, approval before writes, and fully on-prem model hosting.
- How to use ChatGPT with Infor LNHow to use ChatGPT with Infor LN: exporting data versus live access through ION API, custom GPT actions, enterprise data controls, and when a private model fits better.