Warehouse	Demand	% of Demand	Miles from Kansas City	Miles from Los Angeles	Miles from Seattle
Kansas City	20900	11.0%	0	1620	1870
Cleveland	17100	9.0%	800	2350	2410
New Jersey	24700	13.0%	1200	2780	2890
Jacksonville	15200	8.0%	1150	2420	2990
Chicago	22800	12.0%	520	2020	2060
Greenville	15200	8.0%	940	2320	2950
Memphis	17100	9.0%	510	1790	2330
Dallas	22800	12.0%	500	1430	2130
Los Angeles	34200	18.0%	1620	0	1140

Plz solve it in excel sheet...

1. Assume Grainger, Inc., is considering the possibility of getting their supplies from China, India, and/or Japan and keeping the usage of the two ports in Seattle and Los Angeles as two independent distribution centers to supply the demand of the nine warehouses listed in part (1). The Cargo Freight Rates between the three suppliers in China, India, and Japan and the two USA ports are show below.

Country of Supply	China	India	Japan
Sea Freight Rates/1000 CBM/mile	$1.5	$1.0	$2.0

Use Google maps, Google Earth, or any other location on the web to estimate the distances between:

1. the three countries of supply and the two ports, and
2. the two distribution centers (in Seattle and LA) and the nine warehouses.

Assuming that each supplier is capable of providing a maximum of 100,000 CBM during the required time period and each port/distribution center can handle and process all the received CBMs, use the 'solver' module on Excel to provide a complete plan that satisfies the required demands at the nine warehouses in order to minimize the total shipping costs (by sea and road). Show all your work and references for a full credit.

1. Comment on the obtained results in part (6) and feel free to suggest any modifications or introduce new assumptions to provide your overall recommendations to Grainger, Inc.