6. Frogger Inc, has been delivering directly from the manufacturer for years, but now want to consider building a distribution center and is wanting to find the optimal location in the US using the center of gravity approach based on customer location and sales volume. While the company has over 100 customer it serves in the US, 14 make up 85% of their business. The demand projections are listed in the table below: Retailer Whistler/Blackcomb Retail Aspen Mountain, Inc. Bayou Sporting Goods Boards n BBQ Distribution Midwest Sporting Goods Oil Men Who Ride Sports South of Rockies, Inc. ABC Winter Sports Wetlands and Ducks Northern CA Sporting Goods Big 5 Sports Jazzy Sports Mile High Sports Dicks Sporting Goods Year 1 Total Demand Forecast Customer Distribution Center Location Whistler Aspen/Vall New Orleans Kansas City Chicago Houston Phoenix Dallas Seattle San Francisco Los Angeles Salt Lake City Denver Las Vegas Demand Projection (100k) 350 375 400 400 400 400 400 450 550 600 650 650 800 1100 7525 a) Find the center of gravity using the Excel Template provided. You will fill first need to find the longitude and latitude of each of the customer cities using google maps or other internet tools. City center will provide a close approximation of customer's coordinate. What is the calculated Longitude and Latitude? b) Using google map, find the location of the above coordinates? (Closest City) c) Do you recommend this location? Why/why not? d) What location might you recommend? Why?

6. Frogegr Inc, has becen delivering dircetly from the manufscturer for yean, bet now waint to consider building a distribution center and is wanting to find the optimal location in the US aving cenpary has ever 100 custemer it serves in the US, 14 make up 85 , of their busines. The. demand projection are linted in the tatule below: What is the kalcelated Leegense and Latade? 6. Frogegr Inc, has becen delivering dircetly from the manufscturer for yean, bet now waint to consider building a distribution center and is wanting to find the optimal location in the US aving cenpary has ever 100 custemer it serves in the US, 14 make up 85 , of their busines. The. demand projection are linted in the tatule below: What is the kalcelated Leegense and Latade