This is a discussion on calulating logistics cost tool within the Excel Questions forums, part of the Question Forums category; I am a Supply Chain intern at a company for the summer. One project I have been given is to ...
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.
These two links may help you out:
Google Maps distance function for Excel | oCoCarbon
Calculating the Distance between Points (Microsoft Excel)