Act on the result
Use the adverse-FX required price and price buffer to set the import selling-price floor for this SKU.
Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
Importers allocating freight, duty and tax costs across an international shipment.
Allocated logistics, landed unit cost, current and adverse margin and price buffer.
Choose the allocation basis that matches the supplier and freight records.
Use a different tool when: Do not use this to set a price buffer for adverse currency movement; use Cross-border Price Buffer Planner for that decision. Use this tool to allocate landed costs and protect margin under adverse FX.
Commerce & operations
Allocated logistics, landed unit cost, current and adverse margin and price buffer.
Amounts use the same currency as your inputs. No currency conversion is performed.
Allocate shipment costs by units, supplier value or weight and test an adverse exchange rate.
Your numbers stay in this browser
Whole units of this SKU in the shipment.
Whole units across the shipment.
Foreign-currency invoice value for this SKU. Enter foreign supplier currency units, not the selected market currency.
Foreign-currency value across the shipment. Enter foreign supplier currency units, not the selected market currency.
Weight of this SKU using one consistent unit.
Total weight using the same unit.
Choose the shipment record used to allocate shared logistics costs.
Current entered FX conversion.
Adverse FX scenario on the same quote basis.
Freight allocated by the selected basis. Enter the amount on one consistent ex-tax market-currency basis.
Insurance allocated by the selected basis. Enter the amount on one consistent ex-tax market-currency basis.
Brokerage allocated by the selected basis. Enter the amount on one consistent ex-tax market-currency basis.
Entered duty assumption; no jurisdiction default is embedded.
Only enter the non-recoverable share. This planner applies it to supplier value, allocated freight, insurance and brokerage, plus duty; no policy default is embedded.
Share not recoverable for sale.
Margin required on landed cost.
Each output is bound to its registered ecommerce engine formula.
Each row names the assumption axis changed from the baseline.
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
selected item basis / matching shipment total0.2 percentReports percent for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
International Landed Cost & Margin Planner formulas โallocation share ร shipment logistics cost500.00Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
International Landed Cost & Margin Planner formulas โcurrent-FX (supplier value + allocated freight, insurance and brokerage + duty + non-recoverable import tax) / saleable units37.47Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
International Landed Cost & Margin Planner formulas โadverse-FX (supplier value + allocated freight, insurance and brokerage + duty + non-recoverable import tax) / saleable units40.68Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
International Landed Cost & Margin Planner formulas โcurrent landed cost / (1 โ target margin)57.65Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
International Landed Cost & Margin Planner formulas โadverse landed cost / (1 โ target margin)62.59Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
International Landed Cost & Margin Planner formulas โadverse required price โ current required price4.95Reports money for the entered planning period using the declared ex-tax cost and revenue basis. The engine retains full precision; presentation rounding does not feed calculation.
International Landed Cost & Margin Planner formulas โThis calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| adverseExchangeRateDomesticPerForeign | Adverse FX scenario on the same quote basis. | domestic currency units/foreign currency unit | 0.0001 to 10000 | Required | 1.65 |
| allocationBasisCode | Choose the shipment record used to allocate shared logistics costs. | โ | 0 (Units), 1 (Supplier value), 2 (Weight) | Required | Supplier value |
| currentExchangeRateDomesticPerForeign | Current entered FX conversion. | domestic currency units/foreign currency unit | 0.0001 to 10000 | Required | 1.5 |
| dutyRate | Entered duty assumption; no jurisdiction default is embedded. | proportion of allocated customs value charged as duty | 0 to 1 | Required | 0.05 |
| itemSupplierValueForeign | Foreign-currency invoice value for this SKU. Enter foreign supplier currency units, not the selected market currency. | currency units/planning period, ex tax | 0 to 100000000 | Required | 2000 |
| itemUnits | Whole units of this SKU in the shipment. | whole events/planning period | 0 to 100000000 | Required | 100 |
| itemWeight | Weight of this SKU using one consistent unit. | shipment weight units | 0 to 100000000 | Required | 250 |
| nonRecoverableImportTaxRate | Only enter the non-recoverable share. This planner applies it to supplier value, allocated freight, insurance and brokerage, plus duty; no policy default is embedded. | proportion of landed value charged as non-recoverable import tax | 0 to 1 | Required | 0 |
| shipmentBrokerageDomestic | Brokerage allocated by the selected basis. Enter the amount on one consistent ex-tax market-currency basis. | currency units/planning period, ex tax | 0 to 100000000 | Required | 300 |
| shipmentFreightDomestic | Freight allocated by the selected basis. Enter the amount on one consistent ex-tax market-currency basis. | currency units/planning period, ex tax | 0 to 100000000 | Required | 2000 |
| shipmentInsuranceDomestic | Insurance allocated by the selected basis. Enter the amount on one consistent ex-tax market-currency basis. | currency units/planning period, ex tax | 0 to 100000000 | Required | 200 |
| targetMarginRate | Margin required on landed cost. | proportion of selling price retained as contribution | 0 to 1 | Required | 0.35 |
| totalShipmentUnits | Whole units across the shipment. | whole events/planning period | 0 to 100000000 | Required | 1000 |
| totalShipmentValueForeign | Foreign-currency value across the shipment. Enter foreign supplier currency units, not the selected market currency. | currency units/planning period, ex tax | 0 to 100000000 | Required | 10000 |
| totalShipmentWeight | Total weight using the same unit. | shipment weight units | 0 to 100000000 | Required | 1000 |
| wastageRate | Share not recoverable for sale. | proportion of landed units expected to be unsaleable | 0 to 1 | Required | 0.02 |
The adverse-FX required price includes the selected shipment allocation, duty, non-recoverable import tax and wastage assumptions.
Data used here
Use the adverse-FX required price and price buffer to set the import selling-price floor for this SKU.
Retest adverse domestic units per foreign unit on the same FX quote basis and wastage rate as a percentage of landed units.
Educational estimate, not advice. See all assumptions & limitations โ
Guides to interpret the decision and its assumptions.
Build contribution per order, then test fees, shipping, returns, acquisition, fulfilment and product mix one decision at a time.
Read guideUse the adverse-FX required price and price buffer to set the import selling-price floor for this SKU.
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.