Practice Summary: Using Excel to Build Dedicated Routes from Ad Hoc Routes

Abstract

Continental Express Incorporated, a refrigerated carrier, sought to maintain its competitive strengths in an environment that is becoming increasingly more dynamic. Central to this pursuit is driver retention. Traditional responses might have included increasing compensation or instituting retention bonuses. However, we employed management science techniques to exploit an attribute that increased retention and was desirable to drivers although it reduced driver pay.