Department - Author 1

Industrial and Manufacturing Engineering Department

Degree Name - Author 1

BS in Industrial Engineering



Primary Advisor

Tao Yang


This report provides a detailed analysis on how to optimize driving routes by creating a computer application. There are many different route-optimization issues that logistical companies consistently face, as well as many different solutions and algorithms. With technology on the rise, pick-up, delivery, and transportation services are become a huge part of our everyday lives. When optimizing routes, reducing transportation costs by minimizing travel distance is always ideal, but other factors must be considered such as arriving at a location before or after a certain time. Our objective is to optimize driving routes based on travel distance and priorities. We approached this project by using SQL as our main source of determining the route order based on the given distances and priorities of each destination in the projected route. We also used VBA as a tool to support the calculations and to insert Javascript and HTML code, which allows us to visualize the Google Maps route once the order has been determined.