Skip to content
KadmoonINC.
Analytics · Importers

Import margin erosion analysis

An importer traced where margin leaked between quoted cost and the money that actually reached the bottom line.

Microsoft FabricPower BIDAX measuresSemantic model
Margin bridge
End to end
quote to realized
Leak identified
3.8 pts
recovered focus
Drill depth
To the order
per variance
Refresh
Daily
governed model

Illustrative scenario · example figures

The challenge

Gross margin looked healthy on paper but kept eroding by the time orders were delivered, and nobody could point to where it went: freight surcharges, duty, fees, or discounts.

What we built

We built a margin bridge from quoted price to realized margin, decomposing every deduction so leadership could see the cause and size of each leak.

  • A margin waterfall from list price to realized margin.
  • Each deduction named: freight, duty, fees, rebates, and write-offs.
  • Drill-down to the order and shipment behind every variance.

Outcomes

  • The source of margin erosion is named instead of guessed at.
  • Freight surcharges and fee creep are caught and challenged.
  • Discount policy is set with its margin impact visible.

Where the data came from

SAP S/4HANAFreight invoicesRebate and pricing filesDuty tables

Data is drawn from the systems the operation already runs on and delivered in the client’s own tenant.

Want this on your trade data?

Tell us where your numbers live and what leadership needs to see. You get a scoped plan and a quote within one business day.

Request a quote

More case studies