Scientific Program > Tutorials

gunes_erdogan.jpg

Dr. Gunes Erdogan

Reader in Management Science; Director of Studies MSc in Business Analytics

School of Management, University of Bath

Title: "Solving Vehicle Routing Problems Using Excel"

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.

 

 

michael.jpg

Prof. Michael Schneider

Deutsche Post Chair of Optimization of Distribution Networks

School of Business and Economics, RWTH Aachen University

Title: "Routing Electric Vehicles: Problem Variants, Methods, and Future Challenges"

Online user: 1