Formula Guide
Landed cost formula
A landed cost formula converts all real import costs into a total landed cost number and a per-unit cost you can use for pricing. If you need a step-by-step process first, start with how to calculate landed cost for imported products.
Direct answer
Total landed cost = product cost + shipping + duties + import taxes + insurance + handling and related fees. Landed cost per unit = total landed cost / units received.
Definition
What is a landed cost formula?
It is a practical way to translate import overhead into usable unit economics.
The formula is not one universal template for every company. But the objective is consistent: capture every shipment-related cost that affects inventory, then allocate those costs into a total and per-unit number that supports pricing and margin decisions.
For comparison context, see landed cost vs product cost.
Standard landed cost formula in plain language
Landed cost per unit = (Product cost + Shipping + Customs duty + Import tax + Insurance + Handling/Brokerage/Port fees) / Units received
- Total landed cost: Use this to understand full shipment spend and cash impact.
- Per-unit landed cost: Use this for sell-price floors, margin checks, and break-even math.
- Important: Divide by actual units received, not ordered quantity, when there are shortages or damage.
Formula inputs
What costs belong in the formula?
Include costs that are necessary to import and receive inventory.
Core components
- Supplier product cost
- International and inbound shipping
- Customs duty and import tax
- Insurance
What people forget to include
- Brokerage and documentation fees
- Port or terminal handling charges
- Inspection and compliance costs
- Local transfer and receiving costs
Worked example
Worked landed cost formula example
1,200 imported units with common cost layers.
Inputs
- Product cost: $14,400
- Shipping: $2,100
- Duty: $1,440
- Import tax: $1,050
- Insurance: $360
- Handling and brokerage: $450
Outputs
- Total landed cost: $19,800
- Units received: 1,200
- Landed cost per unit: $16.50
- Cost gap vs supplier-only unit cost: +$4.50
Stage comparison
How the formula builds total and per-unit landed cost
Each additional cost layer changes your usable unit-economics baseline.
| Scenario | Formula components included | Total cost | Per-unit landed cost |
|---|---|---|---|
| Product cost only | Product cost | $14,400 | $12.00 |
| After shipping | Product + shipping | $16,500 | $13.75 |
| After duty and import tax | Product + shipping + duty + tax | $18,990 | $15.83 |
| Total landed cost | All formula components | $19,800 | $16.50 |
Formula behavior
Per-unit landed cost rises as more real costs are included
This is why total landed cost formula depth affects pricing confidence.
Spreadsheet logic
How to calculate landed cost formula in Excel
Simple structure that works in most spreadsheet models.
Keep one row per cost component and one row for units received. Then calculate total landed cost and per-unit landed cost separately.
B2:B7 = Product, Shipping, Duty, Tax, Insurance, Handling
B8 = Units received
B9 (Total landed cost) =SUM(B2:B7)
B10 (Landed cost per unit) =IF(B8=0,"",B9/B8)
If you want a faster workflow than manual sheets, use the landed cost calculator and the cost-per-unit calculator.
Common mistakes when building a landed cost formula
- Using product cost as total landed cost.
- Skipping customs and handling fees because each looks small.
- Dividing by ordered units instead of received units.
- Not updating formulas when freight or tax assumptions change.
When landed cost formula matters for pricing and margin
- Use landed cost per unit before setting sell price or promo discounts.
- Validate break-even selling price from landed cost, not supplier cost.
- Model margin after shipping and variable fees before scaling volume.
- Recalculate formula outputs when duty, freight, or quantity assumptions move.
Next decision steps: test break-even thresholds in break-even selling price after import costs, then validate contribution margins in profit margin after shipping and fees.
If discounting is part of your plan, review how discounts affect profit margin before launch.
Turn your landed cost formula into pricing decisions
Calculate totals and per-unit costs, then connect them to break-even and margin planning workflows.
FAQ
Frequently asked questions
Clarifications for landed cost formula, total landed cost, and spreadsheet use.
Related
Related tools
Use these next to compare scenarios and validate decisions from multiple angles.
Landed Cost Calculator for Importers
Calculate your full landed cost and unit economics including shipping, duty, tax, and extra fees.
Cost Per Unit After Shipping & Import Fees
See exactly how shipping and import charges change your true unit cost.
Break-even Selling Price After Import Costs
Set minimum selling price to cover cost, fees, and your target profit per unit.
Import Profit Margin Calculator
Turn landed cost into clear profit, margin %, and markup % for better pricing decisions.