use excel to answer and show work

example solituon

Amazon operates 11 warehouses in the state of Georgia. Below is a map that contains 8 of those warehouses. The various routes from Augusta to the destination cities are presented in the map below, as well as the distance, in miles, that will be required of a truck transiting on each of the routes 1. Determine the shortest route from Lithia Springs to all Destinations. Provide your answer in tale form as well as a diagram of the routes taken as shown on the solution slide in class. 2. Determine the shortest route from any origin point to any destination points in the network. Provide a diagram that shows these routes. Buford 245mi Jefferson 43.7m 23. Am 40.2m Lithia Sorings 28 mi 100ml Stone MIT 17 mi 15.2m 126 29.8mi East Point 141 Augusta 29. 73.8m Nowran 74.2 773 104 Macon Networks Optimization graphical Solution O Q 1 of 2 - + - View as Text Download >> From Lithia Springs to East Point Stone Mountain Newnan Buford Jefferson Macon Augusta Route LS to EP LS to SM LS to N LS to B LS-B- LS-EP-M LS-SM-A Total Miles 15.2 28.3 29.8 43.7 68.2 89.4 154.3 Buford 24. 437 21 402 Springs DO 17. 15.2 20. Po 14 August 293 73 N 74 775 10 M