All use cases
Freight and Duty Eat the Margin · Integrity · already happened
  1. 01How it is found
  2. 02What you see
  3. 03What you do next
  4. 04The money
  5. 05In both engines' views
  6. 06On from the start

The supplier price was fine. Freight and duty took the margin.

A product looks profitable on its purchase price, until freight and import duty are added. Otiox checks every received purchase order line and raises a finding when freight and duty per unit take too large a share of the selling price.
app.otiox.comFig. 00
Integrity · margin
Freight and duty are 25 % of the price
Received PO line · last 90 days
SignalMeasuredValue
Selling priceper unit$20.00
Freight + dutyper unit received$5.00
Share of pricethreshold 20 %25 %
Freight + duty on the line: $1,000
What to do

Check the freight allocation and the duty, or the selling price.

New receipts land under the threshold; the margin holds.

01The Challenge

Priced on the supplier price. Paid on the landed cost.

For example: a $20 item where the freight allocated to it plus the duty come to $5 a unit, 25 % of the price, before the goods themselves are paid for. Low-price, bulky or long-haul products are where this hides.
  1. 01
    Prices are set on the supplier price alone
  2. 02
    Freight is a PO total, not a cost per unit
  3. 03
    Duty changes with origin and HS code
  4. 04
    Bulky, cheap items lose the most
02SEE IT IN OTIOX

The same situation, in the product.

Real screens from the Otiox demo workspace, step by step.
  1. 01

    The finding, and how it happened

    The Integrity Engine's finding names the record and what to do, and its cascade shows how it reached the money. Check the freight allocation and the duty on the PO, then the selling price or the way the goods ship (pallet vs parcel, another origin).

    The finding, and how it happened
  2. 02

    On, shadow or off

    The scenario's row on the Scenario switches page: how many findings are open, and its switch. It is on from the start; shadow keeps it counting without raising findings.

    On, shadow or off
03

How It Works

Purpose-built features that solve these exact problems.
01

How it is found

PO lines received in the last 90 days whose allocated freight plus duty per received unit is at least 20 % of the selling price (setting "Freight + duty above (% of price)").
02

What you see

The Risk Inbox line "Freight and duty on {PO · product} are 25 % of the price" with an Open PO button, in the Integrity Engine with its cascade from receipt to money.
03

What you do next

Check the freight allocation and the duty on the PO, then the selling price or the way the goods ship (pallet vs parcel, another origin).
04

The money

The freight and duty on that line, in your books currency.
05

In both engines' views

The finding appears in the Integrity Engine with its cascade from the record to the money, in the Risk Inbox and in the Loss Prevention Report.
06

On from the start

The scenario is on by default. Put it in shadow to keep it counting on the margin scenarios screen, with a six-month backtest, without raising findings, or switch it off.
04

What You'll Gain

Tangible improvements that impact your bottom line.
  1. 01
    Margin on landed cost

    Freight and duty are part of the margin you look at.

  2. 02
    Line by line

    You see which product and which receipt carry the weight.

  3. 03
    Counted with every other loss

    Margin findings feed the Loss Prevention Report next to the other engine findings.

  4. 04
    Nothing changes by itself

    No scenario changes a price, a discount or an order. You decide.

05

Real-World Scenarios

See how this works in practice.
Scenario 1

A bulky, cheap item

A $20 enclosure arrives with $5 a unit of freight and duty.
Scenario 2

Flagged on the line

The finding shows freight and duty at 25 % of the price, above the 20 % threshold.
Scenario 3

Fixed

The next order ships by pallet and the price is raised; new receipts stay under the threshold.
06

The Transformation

From chaos to clarity.
Before
  • Margin on supplier price
  • Freight as one PO total
  • Duty ignored in pricing
  • Cheap items quietly unprofitable
After
  • Freight and duty per unit
  • Share of price measured
  • Flagged on the PO line
  • Price or shipping changed
07

Frequently Asked Questions

Quick answers to common questions.
01Where does the freight per unit come from?
From the freight allocated to the PO line plus its duty, divided by the units received.
02Can I change the 20 % threshold?
Yes. "Freight + duty above (% of price)" is a workspace setting in the margin scenarios.
03Who sees the numbers?
Cost and margin figures are shown only to people with cost or accounting rights.
04Does Otiox change prices or orders?
No. No scenario changes a price, a discount or an order. It raises the finding and opens the record; the decision is yours.
05Can I put it in shadow or switch it off?
Yes. Every scenario is on from the start. Per scenario, you can put it in shadow (it keeps counting on the margin scenarios screen, with a six-month backtest, but raises nothing) or switch it off, on the margin card or the Scenario switches page. Thresholds are workspace settings.
06Which currency are the amounts in?
Your books currency, at the store's own rate. With no rate, the amount is left empty, never guessed. VAT is taken out before margins; test, cancelled, refunded, draft and abandoned orders are left out.
Freight and Duty Eat the Margin

Ready to transform your freight and duty eat the margin?

See how Otiox can solve your specific challenges.