Determine Ideal location for 5-companies via Google Distance Matrix API: fastest route & shortest time. Utilize our database of customer zip codes.

Understanding the scope of the project and the deliverable's. Utilizing the Google Distance Matrix API a service that provides travel distance and time for a matrix of origins and destinations. The information returned is based on the recommended route between start and end points, as calculated by the Google Maps API, and consists of rows containing duration and distance values for each pair. I will provide you 5 list(s) of zip codes (approximately 100 zips per location) for 5 separate locations. I will also include the quantity of customers we have serviced in each of the 100 zip codes. Approximately 5000 customers Locations. 1-location will have approximately 10,000 customers. Deliverable(s): From this information you will provide the most ideal location(s) by zip-code for all 5-locations. You will suggest the most Ideal locations by sip code in an order from the least amount of time and travel distance to the most. Locations are: Columbus Ohio, Cleveland Ohio, Cincinnati Ohio, Indianapolis Indiana and Nashville Tennessee. Attached is an example of how I would most likely provide the data.