Landed Cost: The Formula, the Traps, and Why Your Margins Are Estimates

Landed cost is the total cost of getting one unit to your warehouse shelf, ready to sell: the supplier’s price plus everything the journey adds. It’s the number your margins are actually built on, and at most small import operations, nobody knows it precisely. They know the FOB price. The rest is a spreadsheet built at order time and never touched again.

An apparel distributor described his process to us like this: “We’re buying 10,000 shirts of varying SKUs, ranging from $6.23 US FOB to $50 and change, fluctuating Canadian exchange rates, fluctuating shipping costs at time of order and time of actual payment, and royalty fees. I literally pull out a calculator and maybe build a cell in an Excel file. Our margins are estimates.”

That last sentence is the whole problem. Here’s the formula, the two traps, and the fix.

The formula

Landed cost per unit = FOB + allocated freight + duty/tariffs + brokerage and compliance + insurance + royalties/licensing, with every foreign-currency component converted at the rate you actually paid.

Trap one: the exchange rate has two dates

You commit to a US-dollar price at order time. You pay a deposit now and the balance months later, after production. If you’re a Canadian importer, you wear every move in USD/CAD between those payments, and a few percent of drift on the currency leg can outweigh any fee line on the sheet.

The spreadsheet version bakes in one rate, the day the sheet was made. The real version records the actual rate on each actual payment. On a six-month production lead, those are routinely different enough to move a product’s margin by full points, in either direction. You don’t control the rate; you can control whether your cost numbers know about it.

Trap two: allocation across a mixed container

A container holds $6.23 shirts and $50 jackets. Divide total freight by total units and the shirt eats far too much freight cost while the jacket gets a subsidy: cheap items look margin-poor, premium items look better than they are, and pricing decisions follow the distortion.

Different costs allocate differently: freight typically by volume or weight, duty by value (it’s charged that way), fixed shipment fees per unit or by value. None of this is hard math. It’s just math a one-cell spreadsheet formula doesn’t do, and a re-order decision made on the distorted version compounds it.

Why it matters beyond the spreadsheet

Three moments force the issue. Pricing: if landed cost is fuzzy, wholesale price lists get set by feel, and feel is generous in the wrong places. Re-orders: you double down on what the sheet says performs, which may be an allocation artifact. Raising money or credit: the distributor quoted above said it directly: when an investor asks about unit economics, “those are things I need to be able to quote in an educated way. We’re kind of winging it.” Banks and investors can tell estimated margins from measured ones by the second question.

What real-time landed cost looks like

The fix isn’t a better spreadsheet; it’s moving the math to where the data already flows:

1. Purchase orders carry their cost structure: FOB per SKU, expected freight, duty rate, royalty terms, entered once when the order is placed.
2. Payments record reality: actual amount, actual date, actual exchange rate, deposit and balance separately.
3. Shipment costs land when invoiced: the real freight bill and the real duty entry replace the estimates on that shipment.
4. Allocation runs automatically: every unit in the shipment gets its true share, by the right basis per cost type.
5. Margins report from landed cost, not FOB, in the same system that tracks the stock. When the goods hit the shelf, each SKU already knows what it cost.

This is bookkeeping-grade arithmetic applied continuously instead of once a season. Nothing about it requires an ERP; it requires the purchase order, the payments, and the inventory living in one system, which is exactly the architecture we described in our wholesale inventory guide.

We build landed-cost engines as part of custom inventory systems for importers and distributors: your formulas, your currencies, your royalty terms, wired to your actual POs and payments. If your margins are currently estimates and the calculator-and-Excel-cell routine is the process, book a discovery call and bring one real purchase order. Working through it live is the fastest way to see where the drift is, and that exercise is free either way.