Analytics · Freight Forwarders
Demurrage and detention cost analytics
An importer and its forwarder found where demurrage and detention charges came from and cut the avoidable ones.
Microsoft FabricPower BIAzure SQLAlerting
- D&D charges
- -29%
- illustrative
- Free time
- Tracked
- per container
- Cause
- Attributed
- and owned
- Alerts
- Before
- charges hit
Illustrative scenario · example figures
The challenge
Demurrage and detention charges arrived weeks later with no context, so the team paid them without knowing which were avoidable or who caused them.
What we built
We tied charge records to container events and the free-time clock, attributing each charge to a cause and an owner so avoidable fees could be prevented.
- Charges tied to container events and free-time windows.
- Attribution by cause: late pickup, congestion, or documents.
- Avoidable-charge alerts as free time runs down.
Outcomes
- Avoidable charges are prevented instead of paid.
- The causes behind recurring fees are named and fixed.
- Disputes are backed by a timeline, not a guess.
Where the data came from
Ocean carrier EDITerminal eventsTMSInvoice records
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 quoteMore case studies
ImportersLanded cost analytics by SKU and supplierAn importer moved landed cost off a monthly spreadsheet into a model that allocates freight, duty, and fees to every unit as goods arrive.ImportersTariff and duty exposure modelingWith tariffs shifting, an importer needed to see duty exposure by product and country and model the cost of a rate change before it landed.ImportersSupplier performance and lead-time analyticsAn importer consolidated supplier data to see lead-time reliability, defect rates, and total cost by vendor in one place.