To investigate the profitability of routes for which there was anecdotal evidence of unprofitability. While the client understood profit at the station level, gaining insight into cost at the shipment level remained a challenge.
Developed a methodology to allocate cost on an individual shipment basis
Applied methodology to individual shipments on a number of suspect routes
Developed an excel-based model to provide the client with an effective pricing tool
Discovered opportunities for improving client profitability by:
Improving pricing based on shipment type and routing
