AnalysisThreecoltsAnalysis and modeling
Carrier & Logistics Spend Analysis
- ~$263K
- 90-day carrier spend analysed
- ~$70K
- Annualised late-fee exposure identified
01
The problem
A high-volume shipper suspected carrier overspend but had no way to size it from raw invoice data.
02
What I built
Line-level analysis of ninety days of UPS invoices, isolating late-delivery penalties, accessorial patterns, and service-level mix against roughly $263K of quarterly carrier spend.
03
What changed
Identified approximately $70K of annualised late-fee exposure as a specific, recoverable figure rather than a suspicion.
Stack
PythonpandasExcelInvoice analysis