Exotech computers produces computer components such as chips, circuit boards, motherboards, keyboards, LCD panels and like and sells them in the world. It wishes to create a new warehouse/ distribution center in Asia to serve emerging Asian markets. It has identified sites in Shanghai, Hong Kong and Singapore and has rated the important location factors for each site as follows:
Weight Shanghai Hong Kong Singapore
Location factor
Political stability 0.25 50 80 90
Economic growth 0.18 90 50 75
Port facilities 0.15 60 95 90
Support 0.1 50 80 90
Land and construction cost 0.08 90 50 30
Transportation / Distribution 0.08 50 80 70
Tariffs 0.07 70 90 90
Trade regulation 0.05 70 95 95
Airline service 0.02 60 80 70
Roads 0.02 60 70 80
Recommend a site based on these location factors and ratings. Please work in a spreadsheet to document calculations.