Coffee Landed Cost Calculator: From Supplier Quote to Cost per Retail Pack

Create one row per SKU and separate rows for shipment charges. Split bundled fields where currencies, quote inclusions, or allocation methods differ. Every amount needs a source and date; leave an unknown charge flagged until it is resolved.

If the supplier quotes per carton, divide the carton price by its consumer-pack count before calculating goods value. Do not use the number of cartons as the denominator for retail-pack cost.

Keep estimate and actual columns side by side. The estimate supports the order decision; invoices and received counts establish the result after delivery.

A correct formula still produces a misleading answer if it adds freight already included in the supplier’s price. Check freight, insurance, origin handling, destination handling, clearance, duty, tax, and warehouse delivery individually. Mark each included, excluded, or unknown.

Add excluded charges once. Record included charges for visibility without adding them again. For an unclear bundle, ask the supplier or forwarder to identify what it covers and where the service ends.

The FOB versus CIF guide explains quote boundaries. Record the actual inclusions and named place in this worksheet; the quoted term alone does not supply an itemized shipment budget.

Compare suppliers at the same warehouse endpoint, shipment quantity, currency assumptions, and delivery scope. A quote ending at a port cannot be compared directly with one covering warehouse delivery. For transport options, consult the LCL versus FCL shipping guide, then enter the chosen quote’s itemized charges.

Convert each amount consistently

Define FX as reporting-currency units per source-currency unit. An illustrative rate of 0.90 EUR/USD therefore converts USD 100 into EUR 90.

These formulas use spreadsheet named ranges; the suffix _i identifies a SKU:

ConvertedAmount = SourceAmount * FX

Goods_i = OrderedPacks_i * PricePerPack_i * FX_i

Convert each invoice currency separately and record the rate’s date. Include payment conversion fees once. Keep commercial payment FX separate from any exchange rate required for customs valuation.

Enter verified duty and tax inputs

This worksheet supplies no current tariff rates. Confirm the destination, product classification, origin, valuation basis, duty method, and tax treatment using official destination guidance.

Only where an ad valorem method has been verified, use:

Duty = OfficialDutyBasis * VerifiedDutyRate

Specific or mixed duties require their applicable calculation. Customs value is a separate input; do not substitute delivered cost automatically.

For this planning model, exclude confirmed recoverable VAT from delivered expense. Include nonrecoverable tax in cost once its treatment is confirmed. In the formulas below, AdditionalDuty and AdditionalNonrecoverableTax mean amounts not already included in quoted goods value.

AdditionalCosts = SUM(ExcludedConvertedCharges)

DeliveredCost =

SUM(GoodsRange) + AdditionalCosts

+ AdditionalDuty + AdditionalNonrecoverableTax

ShipmentCashRequirement =

DeliveredCost + RecoverableVATPayable

ExcludedConvertedCharges omits duty and tax because they appear separately. Quoted goods value must also exclude any separately tracked recoverable VAT so that it does not enter delivered expense.

The cash formula assumes all modeled costs and recoverable VAT are payable before warehouse delivery. Adjust the payment schedule for documented credits or deferrals. This total does not measure peak funding over time or the timing of a VAT recovery.

Assign costs that belong to one SKU directly to it. Split shared charges using a documented driver for each cost pool.

For freight billed by volume, use packed carton volume. Coffee’s net weight will not reproduce that billing basis. Insurance may follow goods value, while comparable packs can share a fixed handling fee by unit count. Duty assessed by SKU should remain with that SKU.

Choose the driver to reflect the charge. Splitting every fee equally is easy, but it can distort pack costs when carton dimensions and quantities differ.

AllocationShare_i = Driver_i / SUM(DriverRange)

AllocatedCharge_i = SharedCharge * AllocationShare_i

SellablePacks_i = OrderedPacks_i - UnsellablePacks_i

PlanningCostPerPack_i =

(Goods_i + DirectCosts_i + SUM(AllocatedCharges_i))

/ SellablePacks_i

Repeat the allocation for each shared cost pool. DirectCosts_i includes additional SKU-specific duty and nonrecoverable tax; neither the direct nor shared costs include recoverable VAT.

Flag zero sellable packs instead of calculating a pack cost. Before using the results, check that the SKU cost totals reconcile to delivered shipment cost.

Every figure below is an illustrative assumption. These figures do not represent an actual shipment or a MR.VIET quotation. The duty and VAT amounts are planning assumptions, not tariff rates or evidence of tax eligibility.

Assume finished coffee travels under an FOB quote, Incoterms 2020, from an unspecified origin port to the buyer’s warehouse. For this example, goods prices exclude all charges listed below, including separately quoted origin handling. The reporting currency is EUR, and supplier prices convert at an assumed 0.90 EUR/USD.

The volume shares stand in for packing measurements; they are not inferred from pack weight. Goods-value shares are 8/15 and 7/15, while ordered-unit shares are 2/3 and 1/3.

All charges are already expressed in EUR. Assume VAT is fully recoverable but payable before warehouse delivery, with no deferral. All delivery costs are also paid by that point.

The volume-based pool totals EUR 1,590. Applying the 60%/40% split assigns EUR 954 to the 250 g SKU and EUR 636 to the 500 g SKU. The insurance and conversion-fee pool totals EUR 150, allocated by goods value.

Delivered cost is EUR 13,500 + EUR 2,160 = EUR 15,660. Including recoverable VAT, shipment cash requirement is EUR 18,160.

The supplier prices converted to EUR are EUR 1.80 and EUR 3.15 per ordered pack. After allocating arrival costs and allowing for unsellable units, the buying figures become EUR 2.145 and EUR 3.619 per sellable pack. Those are the figures to compare with each SKU’s buying ceiling.

Retain full precision in spreadsheet formulas; the displayed pack costs are rounded to three decimals. A shipment average would conceal the difference between the two SKUs.

Test the assumptions most likely to change the order decision. In this example, a 20% freight increase adds EUR 180. With the same volume split and sellable counts, that increases cost by about EUR 0.027 per 250 g pack and EUR 0.036 per 500 g pack.

Also calculate scenarios with a higher reporting-currency cost of supplier payments and fewer sellable units. Label each assumption so the buyer can see what causes the change. Compare the resulting SKU costs with your maximum buying cost, allowing separately for channel fees, outbound distribution, and selling expenses.

Larger orders can spread fixed fees across more packs. They also require more cash and leave the buyer with more stock to sell. Use the lower unit cost only when expected demand supports the quantity.

After delivery, replace estimates with invoices and received counts, then reconcile the shipment again. Keep contingencies separate from actual costs. This sellable-pack model supports purchasing decisions; statutory inventory accounting may treat losses and particular charges differently.

Is landed cost the retail selling price?

No. Landed cost is an input to pricing. Your selling price must also accommodate channel costs, operating expenses, and the margin your business needs.

Should samples reduce sellable units?

Paid packs reserved for sampling should be removed from the sellable denominator. Track their cost treatment separately so the same expense is not charged twice.

Can I calculate without a confirmed duty amount?

Use a clearly flagged scenario amount for preliminary planning. Resolve duty and tax treatment before treating the result as an order-ready budget.

If your team wants to assess MR.VIET branded products for retail distribution, request a wholesale quote with your target market, retail channel, product format, and expected volume. These details provide the starting point for a comparable shipment budget.