calulating logistics cost tool

[scm2014]

I am a Supply Chain intern at a company for the summer. One project I have been given is to create a tool in excel that allows our purchasing people to type in certain inputs (origin, destination, etc.) to calculate the total cost of shipping an item from a supplier in anywhere from china, to somewhere locally. I am gathering quotes for shipping via ocean and truck. What I need help with is how can I get where I enter in one location, say shanghai, china, shipping to another location, say Norfolk, VA, and get the total mileage difference to show? any help would be awesome.

 

[gorem]

These two links may help you out:

Google Maps distance function for Excel | oCoCarbon

Calculating the Distance between Points (Microsoft Excel)