A supplier’s quoted unit price is only one part of what you pay. This landed cost calculator worksheet helps you compare suppliers on a like-for-like basis by adding freight, duties, insurance, brokerage, payment charges, inspection, storage, currency conversion, and expected waste. Use the formulas and worked example below as a repeatable purchasing tool for wholesale, imported, and domestic orders.
Overview
Landed cost is the total cost of getting usable inventory to the location where your business receives, stores, or sells it. It is different from the supplier’s quoted price because a low unit price can be offset by a high minimum order quantity, expensive freight, import charges, payment fees, or a larger expected waste rate.
The basic landed cost formula is:
Total landed cost = product cost + logistics and import costs + transaction costs + handling costs + expected loss
To calculate the landed cost per usable unit, divide the total landed cost by the expected number of usable units:
Landed cost per usable unit = total landed cost ÷ usable units received
Use the same order quantity, destination, currency, delivery terms, and cost categories for every supplier. This turns a supplier directory or B2B marketplace shortlist into a more meaningful vendor comparison. For a broader decision that also considers quality, lead time, and reliability, pair this worksheet with the Vendor Comparison Scorecard.
How to estimate
Start with a single comparison scenario rather than mixing several possible orders. Define the product specification, requested quantity, delivery destination, currency, and required delivery method. Then collect a written quote from each supplier using the same assumptions. An RFQ template for wholesale quotes can help you request comparable information.
- Calculate the product subtotal. Multiply the supplier’s unit price by the order quantity. Include setup, tooling, packaging, customization, or sample charges if they apply to the order.
- Add freight and transport costs. Record the quoted shipping charge and identify what it covers. Separate origin pickup, main transport, destination delivery, and surcharges when those amounts are available.
- Add insurance and import-related costs. Include cargo insurance, duties, taxes that are not recoverable by your business, customs brokerage, documentation, and other clearance charges. Do not assume a fee is included merely because a supplier uses a delivery term; confirm the allocation in writing.
- Add transaction and purchasing costs. Include payment processing, bank charges, currency conversion, inspection, testing, and marketplace fees connected to the order.
- Add receiving and storage costs. Estimate unloading, local handling, short-term storage, labeling, and other costs required before inventory is ready for sale or production.
- Adjust for waste or defects. If a portion of the shipment may be unusable, calculate the cost per usable unit rather than dividing by the original order quantity.
For each supplier, keep both the amount and the basis of the estimate. For example, freight may be a fixed shipment charge, while inspection may be a per-order fee and storage may be charged per pallet or per day. Recording the basis makes the worksheet easier to update when the order size changes.
Inputs and assumptions
Use the following worksheet fields. Add a notes column so you can record whether each figure is quoted, estimated, or still awaiting confirmation.
| Input | What to record | Useful calculation |
|---|---|---|
| Order quantity | Units ordered and supplier MOQ | Unit price × units |
| Unit price | Quoted price in the agreed currency | Product subtotal |
| Freight | Origin, main transport, and destination charges | Fixed or allocated by unit |
| Duty and non-recoverable tax | Applicable charges based on the product and destination | Use the confirmed classification or a clearly labeled estimate |
| Insurance | Cargo coverage or shipment protection | Fixed fee or percentage of shipment value |
| Brokerage and clearance | Customs, documentation, and broker charges | Per shipment or per entry |
| Payment and currency fees | Bank, card, platform, and conversion charges | Fixed fee plus percentage where applicable |
| Inspection and testing | Pre-shipment inspection, samples, or compliance testing | Allocate across ordered units |
| Storage and receiving | Handling, labeling, unloading, and temporary storage | Fixed or unit-based allocation |
| Expected waste | Units or percentage expected to be unusable | Usable units = ordered units − expected loss |
Currency conversion deserves its own line. Convert every input to one comparison currency, identify the exchange-rate assumption and date, and consider adding a separate sensitivity case if the rate could materially change the decision. Avoid presenting a provisional exchange rate as a guaranteed cost.
Also document delivery terms, because they can affect which party arranges or pays for transport, insurance, and import handling. If responsibilities are unclear, request a revised quote that lists the included and excluded charges. The vendor due diligence checklist is useful for validating quote details, company information, and supporting documents before committing.
Worked examples
The following figures are illustrative assumptions, not current market prices. They show how two supplier quotes can produce a different result after all costs are included.
Assume a buyer compares two suppliers for an order of 1,000 units. Supplier A quotes a unit price of $8.00, while Supplier B quotes $7.20. The buyer estimates the following costs for the order:
- Supplier A: freight $1,050, duty and non-recoverable tax $720, insurance $90, brokerage $180, payment and currency fees $130, inspection $150, receiving and storage $180, expected waste of 20 units.
- Supplier B: freight $1,650, duty and non-recoverable tax $720, insurance $110, brokerage $180, payment and currency fees $130, inspection $150, receiving and storage $180, expected waste of 30 units.
Supplier A’s product subtotal is $8,000. Its additional costs total $2,500, producing a total landed cost of $10,500. After the expected 20-unit loss, 980 usable units remain. The estimated landed cost per usable unit is therefore $10.71.
Supplier B’s product subtotal is $7,200. Its additional costs total $3,120, producing a total landed cost of $10,320. After the expected 30-unit loss, 970 usable units remain. The estimated landed cost per usable unit is approximately $10.64.
In this example, Supplier B still has the lower usable-unit cost, but the difference is much smaller than the quoted unit prices suggest. A purchasing team could now compare other factors—lead time, payment terms, quality controls, reorder flexibility, and supplier verification—rather than choosing solely on the initial quote. If the MOQ forces the buyer to order more units than needed, add the carrying cost and realistic disposal or markdown risk to the relevant scenario.
When to recalculate
Recalculate the worksheet whenever a cost assumption or purchasing condition changes. At minimum, revisit it for every new supplier shortlist, product refresh, international order, and annual cost review. A comparison that was accurate for one shipment may not remain accurate when the order quantity, destination, packaging, route, currency, or delivery method changes.
Update the worksheet when a supplier changes its price or MOQ; freight, insurance, brokerage, or storage quotes change; a payment platform introduces a different fee; the product specification changes; expected waste moves outside the original assumption; or a tax, duty, classification, or import requirement needs confirmation. Regional terminology and documentation practices can also differ, so keep a short glossary or note beside any term that vendors use inconsistently.
For practical use, save a dated copy of each comparison and label every input as quoted, confirmed, or estimated. Run at least a base case and a conservative case for uncertain costs. Then use the result alongside your vendor scorecard, verification process, and quality requirements. The goal is not to predict every charge perfectly; it is to expose hidden assumptions and make supplier decisions consistent, reviewable, and easier to update.