A supplier quote is only one part of what imported inventory costs. This landed cost worksheet helps you compare offers on a consistent basis by adding product, transport, customs, handling, and delivery expenses, so you can estimate the real unit cost before placing an order.
Overview
Landed cost is the total cost of getting goods from the supplier to the location where you receive, store, or sell them. It is usually more useful for purchasing decisions than the factory or wholesale price alone. A lower product price can be offset by higher freight, duties, brokerage fees, minimum-order requirements, or inland delivery charges.
The basic formula is:
Total landed cost = product cost + origin costs + international transport + insurance + import costs + destination costs + other allocated costs
To calculate the landed cost per unit, divide the total landed cost by the number of sellable units received. If some units are damaged, rejected, used for samples, or lost in transit, use the expected sellable quantity rather than the original order quantity.
This calculation is an estimate, not a customs ruling or a freight quotation. Confirm classification, duties, taxes, documentation requirements, and Incoterms with the supplier, freight provider, customs broker, and relevant authorities before committing to an order.
How to estimate
Use one worksheet for each supplier quote, then compare the results in the same currency and for the same delivery point. Do not compare an EXW quote with a DDP quote without adding the costs that are excluded from one offer or included in the other.
- Define the shipment: record the product, supplier, origin, destination, quantity, packaging format, expected sellable units, and currency.
- Record the quoted product cost: include the unit price multiplied by the order quantity. Separate recurring product costs from one-time tooling, mold, setup, or artwork charges.
- Add origin and preparation costs: include export packing, palletization, labeling, inspection, documentation, and transport from the supplier to the port, airport, or consolidation point.
- Add international transport: enter the freight quote and identify whether it includes surcharges, handling, fuel adjustments, terminal charges, or other accessorial fees.
- Add insurance: include cargo insurance when it is purchased separately or excluded from the supplier's quote.
- Estimate the customs value and import charges: apply the relevant duty rate to the appropriate customs value, then add import taxes or other government charges where applicable. The exact tax base can vary, so document the assumption used.
- Add destination costs: include customs brokerage, port or terminal handling, storage, demurrage or detention risk allowances where appropriate, local delivery, unloading, and warehouse receiving.
- Convert currencies consistently: select a documented exchange-rate assumption and consider a sensitivity case if the supplier invoice and operating budget use different currencies.
- Divide by sellable units: calculate both the shipment total and the landed cost per sellable unit.
For a repeatable process, save the quote, freight assumptions, classification notes, and calculation date with the worksheet. That record makes later price reviews easier and shows which inputs changed.
Inputs and assumptions
Copy the following worksheet into a spreadsheet or purchasing file. Enter zero only when you have confirmed that a cost is not applicable or is already included elsewhere.
| Cost category | Worksheet input | Check before using |
|---|---|---|
| Product | Unit price × order quantity | Confirm currency, quantity breaks, and whether samples are included. |
| Tooling and setup | One-time molds, plates, artwork, or setup | Decide whether to allocate across one order or an expected production volume. |
| Packaging | Export cartons, pallets, labels, and special packing | Check dimensions and weight because they can affect freight. |
| Origin transport | Supplier to port, airport, or consolidator | Identify whether it is included under the quoted Incoterm. |
| Freight and insurance | International transport and cargo cover | Confirm route, mode, chargeable weight, validity, and exclusions. |
| Duty and import taxes | Estimated customs charges | Confirm product classification and the assumed customs value. |
| Brokerage and handling | Broker, terminal, documentation, and clearance fees | Ask which fees are fixed per shipment and which vary by value or weight. |
| Destination delivery | Port or airport to receiving location | Include appointment, unloading, and accessorial charges where relevant. |
| Storage and inspection | Temporary storage, third-party inspection, or testing | Separate routine costs from contingency allowances. |
| Currency conversion | Invoice currency converted to reporting currency | Record the rate source or internal planning rate and its date. |
Incoterms comparison: Under EXW, the buyer generally takes responsibility for most movement from the seller's premises, including origin collection and export arrangements. Under FCA, the seller generally delivers to the named carrier or place, while responsibility after that point depends on the agreed location. Under FOB, used for appropriate sea or inland-waterway shipments, the seller generally handles delivery and export clearance up to loading on board, while the buyer arranges the main carriage and later costs. Under CIF, the seller generally arranges cost, insurance, and freight to the named port, but the buyer normally handles import clearance, duties, and onward delivery. Under DAP, the seller generally delivers to the named destination, while the buyer handles import clearance and import charges. Under DDP, the seller generally takes responsibility for delivery and import clearance, duties, and taxes, subject to the seller's ability to perform those obligations in the destination country.
These are planning distinctions, not substitutes for the full Incoterms rule and named place in the contract. Use the exact term, version, and location shown on the commercial documents. A separate Incoterms comparison guide can help when reviewing responsibility for transport and clearance.
Worked examples
Consider an illustrative shipment of 1,000 units. The figures below are assumptions for demonstrating the method, not market quotes:
| Item | Assumed amount |
|---|---|
| Product price: 1,000 units × $8.00 | $8,000 |
| Tooling allocated to this order | $400 |
| Export packaging and labeling | $250 |
| Origin transport | $300 |
| International freight | $1,200 |
| Insurance | $80 |
| Estimated duty and import charges | $900 |
| Brokerage and destination handling | $350 |
| Final delivery and receiving | $420 |
| Estimated total landed cost | $11,900 |
With 1,000 sellable units, the estimated landed cost is $11.90 per unit. If inspection or transit issues reduce the expected sellable quantity to 970 units, the unit calculation becomes $11,900 ÷ 970, or approximately $12.27 per sellable unit. That difference matters when setting a wholesale price, evaluating a margin target, or comparing a smaller but more expensive order with a larger order.
Now compare two supplier quotes. Supplier A offers a lower unit price but excludes origin transport and freight. Supplier B quotes a higher unit price under a term that includes transport to the destination port. The correct comparison is not the quoted unit price; it is the completed worksheet for each supplier, using the same destination, quantity, currency, duty assumptions, and sellable-unit estimate.
For margin planning, carry the landed unit cost into a separate pricing model. A wholesale pricing and profit margin guide can help connect landed cost with selling price, gross margin, and channel fees. Keep import cost assumptions separate from selling expenses such as marketing, payment processing, and domestic returns unless your business specifically defines a broader fully loaded cost.
When to recalculate
Revisit the worksheet before each purchase order when any major input has changed. Useful triggers include a new supplier quote, a different Incoterm, a change in order quantity or packaging, a new freight quotation, a currency movement that affects your budget, or a revised delivery location.
Recalculate when product classification, duty assumptions, import taxes, brokerage schedules, or documentation requirements may have changed. Also update the model when carriers alter the route or chargeable weight, when storage becomes likely, or when seasonal capacity affects the freight estimate. Keep the prior version so you can see whether the change came from supplier pricing, logistics, customs, or internal handling.
Before approval, run at least three cases: a base estimate, a higher-cost case using conservative freight or currency assumptions, and a lower-cost case only when the saving is supported by a written quote. Then check whether the higher-cost case still meets your target margin and cash-flow limits.
Finally, use the result in supplier discussions. Ask each supplier to identify included charges, request missing origin details, and confirm the named delivery place. For broader due diligence, review the supplier verification checklist and retain the commercial invoice, packing information, transport quote, and customs assumptions with the worksheet. A landed cost calculation is most useful when it is updated before decisions, not reconstructed after the goods arrive.