graphic representation of the landed cost calculator template from merchant sheets
screenshot of the merchant sheets landed cost calculator template
screenshot of the merchant sheets landed cost calculator template
graphic representation of the landed cost calculator template from merchant sheets
screenshot of the merchant sheets landed cost calculator template
screenshot of the merchant sheets landed cost calculator template

Landed Cost Calculator

$49

The Landed Cost Calculator computes true landed cost per unit for inbound shipments of up to 12 SKUs. It allocates freight, insurance, and broker charges across SKUs by value, weight, volume, or units, then adds per-SKU customs duty from each line's HTS rate. Output includes landed uplift % and a suggested retail floor. Formula-only, so it runs identically in Excel and Google Sheets.

Works in Excel & Google Sheets

Template includes both versions. One price, no add-ons.

Save 67%

Skip to the Full Library

All 20 templates in one purchase, with lifetime updates and every new release included.

How it works

The calculator runs as four steps on a single tab: set up the shipment, list your SKUs, enter the charges, then choose how those charges get split.

  1. Shipment header: Step 1: supplier, mode, incoterm, ship dates, currency, FX rate, and allocation basis
  2. SKU lines: Step 2: quantity, unit FOB in supplier currency, unit weight, unit volume, HTS code, and duty rate for each SKU
  3. Shipment charges: Step 3: freight, insurance, broker, port and terminal, drayage, inspection, and other pooled costs
  4. Allocation and output: Step 4: pick value, weight, volume, or units as the allocation basis, then read per-SKU FOB, allocated charges, duty, landed total, landed cost per unit, uplift %, and floor price

Steps to use it

  1. Open Calculator and fill the shipment header: supplier, mode, incoterm, currency, FX rate
  2. Enter each SKU line: quantity, unit FOB, weight, volume, HTS code, duty rate
  3. Enter shipment-level charges: freight, insurance, broker, port fees, drayage, and other
  4. Pick your allocation basis and read per-SKU landed cost, uplift %, and suggested retail floor
  5. Open Reference to sanity-check totals and use the glossary and incoterm cheat sheet

Allocation basis is yours to choose: value is the default and matches CIF/insurance logic, weight suits freight rated by kilogram, volume suits ocean LCL or volumetric air freight, and units suits uniform small parcels.