# Infor LN Landed Cost Allocation Worksheet

> Source: https://netray.co/tools/infor-ln-landed-cost-allocation-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable worksheet that adds duty and freight to purchase lines to show landed cost per unit and the total uplift.

## Category

infor-ln

## Erp

Infor LN

## Audience

- Buyer
- Import logistics
- Cost accountant

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Item

**Key:** item

**Type:** text

#### Qty

**Key:** qty

**Type:** number

#### Unit price

**Key:** unit_price

**Type:** number

**Format:** currency

#### Goods value

**Key:** ext

**Type:** number

**Expr:** qty * unit_price

**Format:** currency

#### Weight (kg)

**Key:** weight

**Type:** number

#### Duty %

**Key:** duty_pct

**Type:** number

#### Freight per kg

**Key:** freight_kg

**Type:** number

**Format:** currency

#### Duty

**Key:** duty

**Type:** number

**Expr:** ext * duty_pct / 100

**Format:** currency

#### Freight

**Key:** freight

**Type:** number

**Expr:** weight * freight_kg

**Format:** currency

#### Landed cost

**Key:** landed

**Type:** number

**Expr:** ext + duty + freight

**Format:** currency

#### Landed per unit

**Key:** landed_unit

**Type:** number

**Expr:** landed / qty

**Format:** currency

**Rows:**

**Item:** Servo motor 750W

**Qty:** 40

**Unit price:** 212.5

**Weight:** 96

**Duty pct:** 5

**Freight kg:** 3.2

**Item:** Linear guide rail 1m

**Qty:** 120

**Unit price:** 38.9

**Weight:** 300

**Duty pct:** 3.5

**Freight kg:** 2.4

**Item:** Control PCB assembly

**Qty:** 500

**Unit price:** 21.75

**Weight:** 85

**Duty pct:** 0

**Freight kg:** 6.8

**Item:** Stainless fasteners kit

**Qty:** 800

**Unit price:** 2.35

**Weight:** 160

**Duty pct:** 8

**Freight kg:** 1.9

**Totals:**

#### Total goods value

**Key:** ext

**Agg:** sum

**Format:** currency

#### Total duty

**Key:** duty

**Agg:** sum

**Format:** currency

#### Total freight

**Key:** freight

**Agg:** sum

**Format:** currency

#### Total landed cost

**Key:** landed

**Agg:** sum

**Format:** currency

**Summary:**

#### Landed cost uplift over goods value

**Key:** uplift

**Expr:** (sum_landed - sum_ext) / sum_ext * 100

**Format:** percent

**Primary:** true

**Notes:** 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.

## Content

**Intro:** 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.

**Sections:**

#### How to use it

**Body:** 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

**Body:** 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

**Body:** 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.

**Cta:** If you want landed cost variances flagged automatically from your purchase receipts, we can build that against your LN data.

**Faq:**

#### What is landed cost?

**Answer:** 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?

**Answer:** 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?

**Answer:** 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?

**Answer:** Yes. The worksheet exports to Excel or PDF with your rows and totals, so you can attach it to a purchase approval.

## Search terms

infor ln landed cost, landed cost worksheet excel, landed cost per unit calculator, import duty and freight allocation, baan landed cost, purchase landed cost template

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json