Skip to content
KadmoonINC.
Analytics · Importers

Landed cost analytics by SKU and supplier

An importer moved landed cost off a monthly spreadsheet into a model that allocates freight, duty, and fees to every unit as goods arrive.

Microsoft FabricPower BIAzure Data FactorySemantic model
Landed cost accuracy
98%
vs actuals at receipt
Close time
3 days
from 12
Margin granularity
Per SKU
and supplier
Sources unified
6
into one model

Illustrative scenario · example figures

Result

Margin by product and supplier became a daily number the commercial team could act on, instead of a monthly reconstruction.

The challenge

Landed cost was rebuilt by hand each month from freight invoices, duty tables, and ERP exports, so margin by product was always a lagging guess and pricing decisions ran on stale numbers.

What we built

We pulled purchase orders from SAP, freight invoices from the forwarder, and duty rates from customs tables into one model that allocates every cost to the unit, surfaced in a governed set of reports.

  • A semantic model that allocates freight, duty, insurance, and brokerage to the unit.
  • Landed cost and margin by SKU, supplier, and shipment, refreshed daily.
  • A variance view comparing quoted cost to actual at receipt.

Outcomes

  • Landed cost known at receipt instead of at month end.
  • Pricing and sourcing decisions made on current margin.
  • The monthly spreadsheet retired.

Where the data came from

SAP S/4HANAForwarder freight invoicesCustoms duty tablesFX rates

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