Landed cost calculator: how to use it and what it misses

What the calculator does

The Qumek landed cost calculator turns a set of cost lines into a total cost per part for up to three sourcing options. It adds the goods value, freight, insurance, duty, clearance, inland delivery and any other charge you enter, then divides the total by the good parts you expect to receive.

It is a comparison tool, not a pricing tool. It does not tell you what a part should cost, and it does not know the duty rate for your commodity. It applies the numbers you give it and shows the result on one basis so that three quotes can be read side by side.

That is deliberately narrow. A calculator that tried to model every commercial term would be harder to use and easier to distrust. The value is in the discipline of entering the same lines for every option and seeing the gap.

Gather the inputs first

Before you open the calculator, collect the quotes, the Incoterm for each one, the freight rate, the insurance rate, the duty rate and the clearance cost. Add the inland delivery to your warehouse and the payment terms, because the cost of money while goods are in transit belongs in the model.

Decide the volume and the expected good parts. If a supplier has a measured reject rate, use it. If not, use a conservative estimate and mark it as provisional. The difference between the parts ordered and the good parts received can move the answer more than a small freight change.

Also decide the currency and the exchange rate. Use the same rate and the same date for every option, and write them down. A comparison built on three different exchange rates is not a comparison.

• Quoted price and Incoterm for each option
• Freight, insurance and fuel surcharge
• Duty rate and the customs value basis
• Clearance, terminal and documentation charges
• Inland delivery and unloading
• Order quantity and expected good parts
• Payment terms and the cost of capital

Reading the output

The headline is the cost per good part. Read it with the total cost and the split between the cost groups beside it. A total that is only slightly higher may still be the better option if most of the difference sits in a line you control, such as freight, rather than in a line you do not, such as duty.

Look for the option where the goods value is a small share of the total. That is a sign that logistics or duty is doing the work, and it is worth checking whether the route or the classification can change before the supplier does.

Then look at the sensitivity. Change the volume by twenty percent and the freight by ten percent, and see whether the ranking holds. If a small change flips the decision, the options are close and the decision should rest on capability and risk as much as cost.

A worked comparison of three options

The table below is illustrative and does not represent a real part, route or rate. It compares a domestic supplier, an Indian supplier and a Chinese supplier for the same part at an annual volume of 20,000 pieces. Each quote has been normalised to DAP the buyer's warehouse.

The domestic option has the highest piece price but the lowest landed cost per part, because freight, duty and inventory are small. The Indian and Chinese options are close to each other after freight and duty, and the ranking between them depends on the quality assumption. That is the kind of result a calculator is good at showing.

What the calculator cannot see

The first gap is lead time. A longer route needs more safety stock and ties up cash for longer. The calculator can include a carrying cost if you enter one, but it cannot know the variability of the route or the chance of a delay at a port.

The second gap is risk. A single site, a single tool, a single port or a supplier in financial difficulty is a cost that does not appear until it happens. Keep a short risk note beside the result and give it weight in the decision.

The third gap is flexibility. A closer supplier can often support a smaller batch, a design change or an urgent increase. That has a value for a part with a short life cycle or volatile demand, and it is hard to put in a cost line.

The fourth gap is the cost of a line stop. A late shipment can stop a production line, and the cost per hour can dwarf the difference between the options. If the part is critical, add a line stop scenario to the review rather than the calculator.

The fifth gap is the cost of the transition. Moving a part means tooling, a first article, a pilot batch and a period of dual supply. A calculator that compares the steady state, without the cost of getting there, can make a switch look better than it is in the first year.

Using the result in negotiation

A landed cost model gives a buyer a factual basis for a conversation. If the freight line is the reason a supplier is uncompetitive, the discussion can be about the route, the pack density or the shipment mode rather than the piece price.

If the duty line is the issue, check the classification and the origin before asking for a discount. A part classified under the wrong code can carry a rate that was never intended, and correcting it may be worth more than a price negotiation.

If the quality line is the issue, the conversation is about process control and inspection, not price. A supplier who reduces rejects by a few points can be more valuable than one who cuts the piece price by the same amount.

Keep the model current

Freight, duty, currency and supplier prices move. Save the model with the date, the source for each rate and the name of the person who provided it. Review it when a quote is older than the rate basis, or when a material, route or trade measure changes.

For a long programme, agree which inputs are indexed and how often they are reviewed. A metal index, a currency clause and a freight review cadence turn a one-off calculation into a commercial agreement that both sides can defend.

The calculator is the start of the record, not the end. The decisions, the assumptions and the reasons behind them are what a new team will need when the programme is reviewed a year later. Keep the saved comparison with the supplier file, so the next buyer can see what was known at the time.