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