happytails.ai

Landed cost calculator

Open Landed cost calculator on Happytails.ai. This view has the same page content and links, with explicit tool capabilities. Read the processing notes before using a tool.

Tool capabilities

{
  "id": "landed-cost-calculator",
  "category": "business-tools",
  "built": true,
  "requirements": "Up to 150 shipment lines and 100,000 characters, with item names of up to 80 characters. Quantities from 1 to 10,000,000, unit costs up to 1,000,000 with four decimal places, unit weights up to 1,000,000 with three decimal places and duty rates up to 1,000 percent with four decimal places. Freight, insurance, handling and other costs up to 1,000,000,000 each. Calculated on your device. Download a JSON report and CSV files.",
  "implementation": {
    "fields": [
      {
        "key": "freight",
        "label": "Freight for the shipment",
        "value": "1850.00",
        "type": "text",
        "inputMode": "decimal",
        "maxLength": 32
      },
      {
        "key": "insurance",
        "label": "Cargo insurance",
        "value": "120.00",
        "help": "Shared by product value.",
        "type": "text",
        "inputMode": "decimal",
        "maxLength": 32
      },
      {
        "key": "handling",
        "label": "Customs brokerage, port and handling fees",
        "value": "395.00",
        "type": "text",
        "inputMode": "decimal",
        "maxLength": 32
      },
      {
        "key": "otherCosts",
        "label": "Other shipment costs",
        "value": "0",
        "help": "Inspection, storage or delivery to your warehouse.",
        "type": "text",
        "inputMode": "decimal",
        "maxLength": 32
      },
      {
        "key": "freightBasis",
        "label": "Share freight by",
        "value": "weight",
        "type": "select",
        "values": [
          "weight",
          "value",
          "quantity"
        ],
        "labels": {
          "weight": "Total weight",
          "value": "Product value",
          "quantity": "Units"
        }
      },
      {
        "key": "handlingBasis",
        "label": "Share handling and other costs by",
        "value": "value",
        "type": "select",
        "values": [
          "value",
          "weight",
          "quantity"
        ],
        "labels": {
          "value": "Product value",
          "weight": "Total weight",
          "quantity": "Units"
        }
      },
      {
        "key": "dutyBasis",
        "label": "Duty is charged on",
        "value": "product",
        "help": "Check which value your customs authority uses.",
        "type": "select",
        "values": [
          "product",
          "cif"
        ],
        "labels": {
          "product": "Product value only",
          "cif": "Product value plus freight and insurance (CIF)"
        }
      },
      {
        "key": "defaultDutyRate",
        "label": "Duty rate for lines without one (%)",
        "value": "0",
        "help": "Use the rate from your import tariff for each product. No rates are built in.",
        "type": "text",
        "inputMode": "decimal",
        "maxLength": 32
      },
      {
        "key": "currency",
        "label": "Currency code",
        "value": "USD",
        "type": "text",
        "maxLength": 3,
        "autoCapitalize": "characters"
      },
      {
        "key": "precision",
        "label": "Currency decimal places",
        "value": "2",
        "type": "select",
        "values": [
          "0",
          "1",
          "2",
          "3",
          "4",
          "5",
          "6"
        ]
      },
      {
        "key": "rounding",
        "label": "Rounding",
        "value": "half-up",
        "type": "select",
        "values": [
          "half-up",
          "half-even",
          "half-down",
          "down",
          "up",
          "floor",
          "ceiling"
        ],
        "labels": {
          "half-up": "Half up (ties away from zero)",
          "half-even": "Half even (ties to even)",
          "half-down": "Half down (ties toward zero)",
          "down": "Toward zero (truncate)",
          "up": "Away from zero",
          "floor": "Toward negative infinity",
          "ceiling": "Toward positive infinity"
        }
      }
    ],
    "registrationFamily": "commerce-margins",
    "presentation": "metrics",
    "note": "Freight, handling and other costs are shared across the lines by the basis you choose and insurance by product value, in whole minor currency units that add up exactly to each cost. Duty is your rate times the product value, or times product value plus freight and insurance. No duty rates are built in. Processing stays on your device.",
    "inputMaxLength": 100000,
    "inputErrorCode": "COMMERCE_MARGINS_TOO_LONG",
    "experience": {
      "automatic": false,
      "single": false,
      "inputMaxLength": 100000,
      "inputMode": "text",
      "label": "Shipment lines",
      "placeholder": "item,quantity,unit cost,unit weight,duty rate",
      "help": "One product per line: name, quantity, unit cost, then optional unit weight and duty rate. Write numbers without thousands separators. Up to 100,000 characters. Review the settings before running.",
      "helpParts": [
        "One product per line: name, quantity, unit cost, then optional unit weight and duty rate. Write numbers without thousands separators.",
        "Up to 100,000 characters.",
        "Review the settings before running."
      ],
      "action": null
    },
    "mode": "explicit",
    "interactive": false
  },
  "execution": "Browser interface",
  "api": null,
  "browser_agent": {
    "supported": true,
    "name": "run_current_tool",
    "discovery": "WebMCP on the human page in a supporting browser",
    "verification": "See audit/API-AUDIT.md; availability is not verification"
  }
}

Page guide

Work out the landed cost of each product in a shipment by sharing freight, insurance and handling across the lines and adding duty at the rates you enter. Get a landed cost per unit for pricing.

How to use Landed cost calculator
  1. Paste one shipment line per row with quantity, unit cost and, if you have them, unit weight and duty rate.
  2. Enter freight, insurance, handling and other costs for the whole shipment.
  3. Choose how to share freight and handling, and whether duty is charged on product value alone or with freight and insurance.
  4. Calculate, review the landed unit costs, then download the report.

Useful next steps

What goes into landed cost

Landed cost is the purchase price plus the costs of getting the goods to you. IAS 2 Inventories (revised December 2003), paragraph 11, lists the purchase price, import duties and other taxes you cannot recover, and transport, handling and other costs directly attributable to buying the goods. Each line product value is quantity times unit cost, rounded to the currency decimal places. Shared shipment costs and duty are then added, and the landed unit cost is the line total divided by its quantity.

Sharing shipment costs

Freight is shared by total weight, product value or units, insurance by product value, and handling and other costs by the basis you choose. Each cost is split in whole minor units: every line first gets its share rounded down, and the units left go to the largest remainders, the Hamilton method described in Fair Representation by Balinski and Young (Yale University Press, 1982), so the shares add up exactly to the cost. In the example, the 729.5 kg shipment puts 699.93 of the 1,850.00 freight on the dog beds, which weigh 276 kg.

Duty is your input

Duty for each line is the rate you enter times its dutiable value. Article 8.2 of the WTO Customs Valuation Agreement (1994) lets each country decide whether that value includes freight and insurance to the port of import, so choose product value only or product value plus freight and insurance. No tariff rates, de minimis thresholds, trade agreements or exchange rates are built in, so look up the rate for each product in your import tariff. Recoverable taxes such as VAT or GST are left out of landed cost.