The costs of a route sit in two systems and are never brought together.
Freight costs sit in the TMS, staff and warehousing costs in the ERP. For the monthly report, controlling exports data from both systems and lines it up in a spreadsheet. Because cost centres and shipment numbers are named differently in the two exports, the matching has to be redone by hand every month.
2source systemsFreight costs come from the TMS, staff and warehousing costs from the ERP.
12cost centresFour sites each run three cost centres, named differently in the two exports.
3 daysmanual workThat is how long it takes until the exports line up and the monthly report is ready.
4 weeksdelayThat is how late the analysis flags the expensive tariff, which keeps running in the meantime.
If you have these four figures side by side on the same day rather than four weeks later, you capture the 10 to 15% cost savings while the tariffs are still running.
The 10 to 15% cost saving is this agent's headline figure. The twelve cost centres across four sites and the three days of manual work before the monthly report are a typical set-up in logistics controlling, not a measured value.