10-12 Jul 2017 Amsterdam (Netherlands)
Reader in Management Science; Director of Studies MSc in Business Analytics
School of Management, University of Bath
In this tutorial, we will show how to solve Vehicle Routing Problems using VRP Spreadsheet Solver, an Excel workbook with embedded VBA functions to acquire location and distance data from a GIS, solve the problem instance, and display the solution on a map. We will present challenges and associated practical solutions regarding the VRP solution process including the acquisition of GIS data, scenario analyses, and visualization. We will demonstrate the use of a solver on a real-world instance and conclude with future directions for VRP software design.
Deutsche Post Chair of Optimization of Distribution Networks
School of Business and Economics, RWTH Aachen University