Import Cost Apportioned Method

Costs are apportioned to physical inventory items only and are apportioned by Cost, Quantity, Weight or Cubic. Where multiple purchase orders are attached to a shipment, costs can be apportioned to all orders or selected orders only.

Individual lines can be excluded from the apportionment of import costs. In order to exclude a line, ensure that the Cost Type that you want to exclude from being apportioned also is not ticked as “Apportioned” on the Import Costs tab. The next step is to go to the Shipment Lines Tab. Right-click on the line to be excluded and click on “View Import Costs”

Open

On the popup window “Line Costs” you will now be able to untick “Include” checkbox for each of the Cost Types for the line that you do not want to attract the Costs.

Open

Cost Apportion Method Calculations

Example

Shipment 0001 has the below Import Costs that are apportioned based on Weight and Costs.

The costs are distributed evenly across all lines.

Let's see how that is calculated based. Firstly, check the Apportion Method of each Cost Type.

1. Freight → Weight

2. Insurance → Cost

3. Storage → Cost

4. Marketing →

Calculate Cost Apportion Method is the easiest so let's start there.

1. Percentage = Line Total Ex Tax / Sum (Line Total Ex Tax) * 100

   1. = 7,100.00 / (7,100.00 + 6,460.00 + 3,230.00) * 100

   2. = 7,100 / (16,790.00) * 100

   3. = 42.28708

2. Import Cost = Percentage * Total Import Costs (Insurance) / 100

   1. = 42.28708 * 250 / 100

   2. = 105.72

Repeat this process for each “Cost” Import line i.e. Storage and Marketing.

Now let’s calculate Freight which is based on Weight Apportion Method.

1. Extended Weight = Item Weight * Qty Ordered

   1. = 175 * 10

   2. = 1,750

2. Percentage = Extended Weight / Sum (Total Extended Weight)

   1. = 1,750 / (1,750 + 37.5 + 16.25)

   2. = 1,750 / 1,803

   3. = 97.02

3. Import Cost = Percentage * Total Import Costs / 100

   1. = 97.02 * 2,581.25 / 100

   2. = 2,504.33