Setting Up Estimated Landed Costs

Separate vouchering of landed costs allows you to voucher freight, duty, brokerage, insurance, and local freight separately from your material. When you create a header for a purchase order, GRN, or transfer order, you can enter estimated landed costs. Follow these steps to set up landed costs:

1. Find the purchase order, transfer order, or GRN where you want to set up landed costs, or create a new one.
2. In the Purchase Orders, Transfer Orders, or Goods Receiving Notes form, click the Landed Cost button.
3. In the related Landed Costs form, select the Freight Vendor, Duty Vendor, Brokerage Vendor, Insurance Vendor, and Local Freight Vendor, as applicable.
4. Select the Allocation Type (Percent or Amount) for each vendor you enter.

   NOTE: Blanket purchase orders may not use Amount as the Allocation Type.

   • If you select Percent, you must fill in the Alloc Percent field.
   • If you select Amount, you must fill in the Alloc Method field. Your choices are: cost, weight, and units. Then enter estimates for the eventual invoice amounts.
5. Save the record. The allocations will be performed according to the calculations below when you run the Allocate Landed Costs activity.

Allocation Types and Calculations

Percent Allocation

This calculation multiplies each PO or TO line's total material cost by the user-entered allocation percent.

EXAMPLE:

PO line total material cost = 120

PO Header %  = .05

PO line Landed cost = 6

PO line unit cost  = 6 / PO line qty ordered

Amount Allocation

This calculation distributes the user-entered estimated amount for each landed cost category evenly across all PO or TO lines according to the Allocation Method selected.

Allocation Methods and Calculations

Cost Allocation

The total material cost for the PO or TO will be determined and the proportion of each PO/TO line's material cost to the total material cost for the PO/TO will be determined. The estimated landed cost amount will be distributed across all PO/TO lines using the same proportion to determine the landed cost amount to be applied to the PO/TO line.

EXAMPLE:

TO total material cost - overridden material cost = 1000

Estimated landed cost - overridden landed cost = 300

TO line material cost = 100

% TO Line to total = 100 / 1000 = .10

TO line landed cost = .10 * 300 = 30

TO line unit cost = 30 / PO line qty ordered

Weight Allocation

The total weight for the PO/TO and the proportion of each PO/TO line's weight to the total weight is determined. The estimated landed cost amount is distributed across all PO/TO lines using that proportion.

EXAMPLE:

PO total weight - overridden PO weight = 2000

PO line weight = 40

Estimated Landed Cost - overridden landed costs = 200

% PO line wt to total = 40 / 2000 = .02

PO Line landed cost = .02 * 200 = 4

PO Line unit cost = 4 / PO line qty ordered

• Zero weight line items will not have any landed cost assigned.
• Weight allocation will be disallowed if all PO lines have zero weight.
• Weight U/M's will be ignored when weights are being totaled. For example: 1 kg + 5 lbs = 6.
• You will receive a warning during the Allocation Activity if multiple weight U/M's exist on the PO/TO.
• The Allocation Activity will use the Base Quantity in all calculations.

Unit Allocation

The total number of units for the PO/TO will be determined and the estimated landed cost amount will be divided by that total to determine the per unit cost.

EXAMPLE:

TO total qty ordered - overridden qty ordered = 1000

Estimated landed cost - overridden landed cost = 2000

TO line unit cost = 2000 / 1000 = 2

Related Topics

Purchasing Overview

Purchasing Steps

Allocating Landed Costs

Example: Landed Cost Actual Costing

Generating Landed Cost Vouchers