CELLWRIGHTOperator-grade spreadsheets & automation packs

Landed Cost & Tariff Calculator

Supplier price + freight + duty + extra tariffs + fees → your true cost per sellable unit, the break-even price and the price that holds your margin. Free, no sign-up, nothing leaves your browser.

1 · Shipment & goods

2 · Freight & charges (home currency, this SKU's share)

3 · Duty & tariffs

4 · Selling

Results

Landed cost per sellable unit—
Goods value
—
Customs value
—
Duty + extra tariff
—
Processing / port fees
—
Total landed cost
—
Landed uplift over goods
—
Duty + tariffs share of landed
—
Profit per unit
—
Net margin
—
Break-even price
—
Price for target margin
—

—

Download the Full Multi-Tab Excel Bundle — $29

40 SKUs · freight auto-split by CBM, weight, value or units · multi-currency · duty + extra tariff + AD/CVD per SKU · break-even & target price with LOSS flags · tariff / FX / freight shock scenarios · dashboard. Excel + Google Sheets.

Or grab the free 1-tab Excel version ($0+) →

How the calculation works

  1. Goods value = units × unit cost × FX rate.
  2. Customs value = goods value on an FOB basis, or goods + freight + insurance on a CIF basis.
  3. Duty + extra tariff = customs value × (base duty % + extra tariff %). Tariffs stack additively on the same customs value; they do not compound.
  4. Total landed cost = goods + freight & insurance + other charges + duty & tariffs + processing/port fees.
  5. Landed cost per sellable unit = total ÷ (units × (1 − shrink %)).
  6. Target price = (landed / unit + fulfilment) ÷ (1 − fee % − target margin %). Break-even uses a 0% margin.

Worked example

1,200 bamboo board sets at ¥38.50 (FX 0.139) = $6,421.80 of goods. Add $1,450 freight & insurance and $620 of port, broker and inland charges. On an FOB basis the customs value is $6,421.80, so 3.2% duty + 30% extra tariff = $2,132.04 and 0.47% fees = $30.18. Total landed cost is $10,654.02 across 1,182 sellable units: $9.01 per unit, a 65.9% uplift over the factory price. With 17.9% marketplace and payment fees and $6.40 fulfilment, break-even is $18.77 and a 25% margin needs $26.99.

Where a single-SKU calculator stops

Real shipments carry 5–40 SKUs on one freight invoice. Splitting that invoice by value makes bulky cheap items look profitable when they are not — ocean freight is bought by volume. The Cellwright Landed Cost & Tariff Model allocates freight, insurance and charges per SKU by CBM, weight, value or units, handles multiple supplier currencies, applies the processing-fee minimum and maximum per entry, and shows which SKUs now sell at a loss after a tariff change.

FAQ

What is landed cost?

The full cost of getting a product from the supplier to your warehouse: supplier price in your currency plus freight, insurance, origin and destination charges, broker fees, duties, extra tariffs and government processing fees, divided by the units you can actually sell.

FOB or CIF — which customs value basis applies to me?

The US assesses duty on FOB transaction value (freight and insurance not dutiable). The EU, UK and many others use CIF. Confirm with your customs broker; on a freight-heavy shipment the difference is material.

Do extra tariffs compound on base duty?

Normally no. Each programme is a percentage of the same customs value, added together: 3.2% + 30% = 33.2%.

Is this customs advice?

No. It is arithmetic on the numbers you enter. Verify duty and tariff rates against your tariff schedule or with a licensed customs broker.

Landed / unit: — · see results ↓