Queenie wants to expand her business into Africa. Based on her initial analysis there are no ports large enough in many African countries to make them viable by themselves. However, transporting goods from another port to African ports would be a sound business move. Queenie had her staff provide a list of five ports that could be used to serve Africa. Using the recommendation you provided Queenie for in #1, rate each of the factors listed below, and use the weighting-factor model to select the best port for Quigley Global Transportation. Submit the factor ratings and final weighted score for each location.

here is the data:

 

Here is the table to fill in the data, Use the table below to fill in the data on a scale of 1-100% (1=BEST, 100= WORST)

Important Location Factors	UAE	SRI LANKA	SAUDI ARABIA	MALTA	SPAIN
Port Ranking by TEU [30%]
Ease of Doing Business by Country [25%]
GDP Growth by Country-2016 [20%]
Getting Credit by Country [15%]
Enforcing Contract by Country [10%]
Total Weighted Scores
RANK

*Note: the lower the number, the higher the ranking for the TEU, GDP, Credit, and Contract Enforcement. (so, smaller is better!)

COUNTRY United Arab Emirates Sri Lanka Saudi Arabia Malta Spain PORT RANKING BY TEU (1 = BEST) 44 28 36 49 33 EASE OF DOING BUSINESS BY COUNTRY 28 110 147 132 85 GDP GROWTH BY COUNTRY- 2016 2.3% 5.0% 1.2% 4.1% 3.1% GETTING CREDIT BY COUNTRY 101 118 82 139 62 ENFORCING CONTRACT BY COUNTRY 25 116 105 58 29