What landed cost represents
Landed cost is the cost of making a product available at the required destination, not simply the supplier invoice. For an industrial distributor, the calculation may include currency conversion, freight, insurance, customs duty, handling, bank charges and allocation rules.
Build the calculation from explicit inputs
Store supplier price, currency, exchange rate source, Incoterm, origin, weight or volume, freight basis and duty treatment separately. Clear inputs allow reviewers to identify which assumption changed when the recommended sell price moves.
- Supplier price and currency
- Approved exchange rate
- Freight and insurance
- Customs duty and clearance
- Local handling
- Margin or markup rule
Avoid spreadsheet inconsistency
Teams often maintain several calculators with different formulas, rates and rounding. Approved deterministic rules reduce this variation. Exceptions should remain editable, but every override should be visible and attributable to the quotation case.
Review before committing a price
A landed cost engine should provide a recommendation, not an irreversible answer. Reviewers still need to confirm scope, technical compliance, delivery assumptions and the commercial strategy for the account.
Use a transparent calculation sequence
Begin with the supplier price on its stated Incoterm and currency basis. Apply the approved exchange rate, add the logistics and import components that are not included, allocate shared costs using an agreed method and only then apply the relevant markup or margin policy.
Every stage should retain its source and timestamp. A reviewer should be able to explain whether a price moved because the supplier revised the offer, the exchange rate changed, freight was reallocated or a commercial override was approved.
- Supplier price on the original commercial basis
- Approved exchange rate and timestamp
- Freight, insurance and shipment allocation
- Customs duty and clearance treatment
- Local delivery, handling and bank charges
- Approved margin or markup rule
- Visible overrides and reviewer identity
Do not treat UAE duty and VAT as universal constants
The correct treatment depends on the product, origin, customs classification, transaction structure and the company’s accounting process. Quotation software should store the applicable rule and its source rather than hard-code one percentage across every case.
Where classification or tax treatment is uncertain, the quotation should carry an explicit assumption for review by the company’s customs, finance or tax adviser. The system can prepare the arithmetic, but it should not present unverified regulatory treatment as fact.
Test the model against completed quotations
Select historical cases with different currencies, shipment sizes and delivery terms. Rebuild the cost from the original supplier evidence and compare the result with the approved quotation and actual known costs where available.
Track which inputs required correction, which allocation rules caused disagreement and whether the reviewer could trace every amount. The goal is a consistent, explainable cost basis—not a black-box price.