The Country Attractiveness spreadsheet consists of 4 main parts, each of which has its own sheet / tab located

at the bottom of

1) Latin America Subjective Rating (for use with the Latin America Scenario only)

First consider some of the factors that make a market or country more attractive. We've grouped them into four general categories: Demand, Supply, Competition, a
However, you may prefer a different way to organize them. Note that you don't have to have 5 factors for each category. All that matters is that the factors you choo
that you believe are important differences in the attractiveness of the market / country. The spreadsheet will automatically calculate the overall attractiveness of each
country based on the weight that you've entered for the factor and the rating of the factor on a scale of 1-10. Weights should total 100% when done.

- In short, your job is to decide on the factors, the weights (importance), and the assessment for each country on each factor chosen.

2) Asia Subjective Rating (for use with the Asia Scenario only)

Same as above but with Asian countries.

3) Raw Data Formula Conversion

This sheet provides a statistical methodology for converting data from the simulation into ratings. It also provides sample calculations for 3 factors for both Latin Ame
and Asia. This is only a one possible approach however. If you would like to use this methology to calculate ratings, you will need to expand the sheet to address othe

4) Raw Data VLOOKUP Conversion

This sheet provides a second methodology for converting data from the simulation into ratings using straight - line interpolation. It also provides sample calculations f
Latin America and Asia. This is only a one possible approach however. If you would like to use this methology to calculate ratings, you will need to expand the sheet t
 Country Attractiveness Analysis for use with the Asia Scenario

China Japan India S. Korea Philippines Thailand

Importance Rating Assessment Rating Assessment Rating Assessment Rating Assessment Rating Assessment Rating Assessment
Weight (1-10) (Calculated) (1-10) (Calculated) (1-10) (Calculated) (1-10) (Calculated) (1-10) (Calculated) (1-10) (Calculated)

1) PRICE 30% 4.5 1.35 5 1.5 6 1.8 3 0.9 7 2.1 8 2.4

2) MARKET SHARE COMPETITORS 15% 6.5 0.975 8 1.2 3 0.45 5.5 0.825 3 0.45 4.5 0.675

3) COST MANUFACT 20% 6 1.2 4 0.8 6 1.2 5.5 1.1 8 1.6 7 1.4

4) POPULATION 25% 8 2 5 1.25 7.5 1.875 2.5 0.625 4.5 1.125 3 0.75

5) INFLATION 10% 4.5 0.45 7 0.7 3.5 0.35 4.5 0.45 5 0.5 7 0.7

6) 0% 0 0 0 0 0 0

7) 0% 0 0 0 0 0 0

8) 0% 0 0 0 0 0 0

9) 0% 0 0 0 0 0 0

10) 0% 0 0 0 0 0 0

Competition Criteria
11) 0% 0 0 0 0 0 0

12) 0% 0 0 0 0 0 0

13) 0% 0 0 0 0 0 0

14) 0% 0 0 0 0 0 0

15) 0% 0 0 0 0 0 0

Other Criteria
16) geographic 0% 0 0 0 0 0 0

17) cultural 0% 0 0 0 0 0 0

18) political 0% 0 0 0 0 0 0

19) 0% 0 0 0 0 0 0

20) 0% 0 0 0 0 0 0

TOTAL 100% 6.0 5.5 5.7 3.9 5.8 5.9

1st 4th 3rd 2nd

Country Attractiveness Analysis Using Raw Data, Standardized
For use with the Latin America Scenario
Criteria Population GDP per Capita ($) - Higher is More Attractive
Weight 15% 10%
Raw Data Standardized Rating Assessment Raw Data Standardized
Argentina 45.5 -0.47 2.3 0.3 20,300 0.55
Brazil 211.7 1.75 10.0 1.5 15,300 -0.61
Chile 18.2 -0.84 1.0 0.2 24,800 1.59
Colombia 49.1 -0.42 2.4 0.4 14,500 -0.80
Mexico 128.6 0.64 6.1 0.9 19,200 0.29
Peru 31.9 -0.65 1.6 0.2 13,500 -1.03

Statistics
Mean 80.8 17,933
SD 74.8 4,307
Max 1.7 1.6
Min -0.8 -1.0
Range 2.6 2.6

For use with the Asia Scenario

Criteria Population GDP per Capita ($) - Higher is More Attractive
Weight 15% 10%
Raw Data Standardized Rating Assessment Raw Data Standardized
China 1,385.0 1.36 10.0 1.5 16,758 -0.35
Japan 126.2 -0.59 1.5 0.2 43,130 1.35
India 1,297.0 1.22 9.4 1.4 7,305 -0.96
S. Korea 51.4 -0.70 1.0 0.2 39,591 1.12
Philippines 105.9 -0.62 1.4 0.2 8,281 -0.90
Thailand 68.6 -0.67 1.1 0.2 18,017 -0.27

Statistics
Mean 505.7 22,180
SD 648.2 15,513
Max 1.4 1.4
Min -0.7 -1.0
Range 2.1 2.3
Capita ($) - Higher is More Attractive GDP per Capita ($) - Lower is More Attractive
10% 10% Total
Rating Assessment Raw Data Standardized Rating Assessment Assessment
6.4 0.6 20,300 0.5 4.6 0.5 1.4
2.4 0.2 15,300 -0.6 8.6 0.9 2.6
10.0 1.0 24,800 1.6 1.0 0.1 1.3
1.8 0.2 14,500 -0.8 9.2 0.9 1.5
5.5 0.6 19,200 0.3 5.5 0.5 2.0
1.0 0.1 13,500 -1.0 10.0 1.0 1.3

17,933
4,307
1.6
-1.0
2.6

Capita ($) - Higher is More Attractive GDP per Capita ($) - Lower is More Attractive
10% 10% Total
Rating Assessment Raw Data Standardized Rating Assessment Assessment
3.4 0.3 16,758 -0.3 7.6 0.8 2.6
10.0 1.0 43,130 1.4 1.0 0.1 1.3
1.0 0.1 7,305 -1.0 10.0 1.0 2.5
9.1 0.9 39,591 1.1 1.9 0.2 1.3
1.2 0.1 8,281 -0.9 9.8 1.0 1.3
3.7 0.4 18,017 -0.3 7.3 0.7 1.3

22,180
15,513
1.4
-1.0
2.3
Country Attractiveness Analysis Using Raw Data, Standardized, Scaled Using VLOOKUP
For use with the Latin America Scenario
Criteria Population GDP per Capita ($) - Higher More Attractive
Weight 15% 10%
Raw Data Standardized Rating Assessment Raw Data Standardized
Argentina 45.5 -0.47 2.0 0.3 20,300 0.55
Brazil 211.7 1.75 10.0 1.5 15,300 -0.61
Chile 18.2 -0.84 1.0 0.2 24,800 1.59
Colombia 49.1 -0.42 2.0 0.3 14,500 -0.80
Mexico 128.6 0.64 6.0 0.9 19,200 0.29
Peru 31.9 -0.65 1.0 0.2 13,500 -1.03

Statistics
Mean 80.8 17,933
SD 74.8 4,307
Max 1.75 1.59
Min -0.84 -1.03
Range 2.59 2.62
Interval (1-10) 0.29 0.29

Ranked Values
1 (Min) -0.84 1.0 -1.03
2 -0.55 2.0 -0.74
3 -0.26 3.0 -0.45
4 0.02 4.0 -0.15
5 0.31 5.0 0.14
6 0.60 6.0 0.43
7 0.89 7.0 0.72
8 1.17 8.0 1.01
9 1.46 9.0 1.30
10 (Max) 1.75 10.0 1.59

For use with the Asia Scenario

Criteria Population GDP per Capita ($) - Higher More Attractive
Weight 15% 10%
Raw Data Standardized Rating Assessment Raw Data Standardized
China 1,385.0 1.36 10.0 1.5 16,758 -0.35
Japan 126.2 -0.59 1.0 0.2 43,130 1.35
India 1,297.0 1.22 9.0 1.3 7,305 -0.96
S. Korea 51.4 -0.70 1.0 0.2 39,591 1.12
Philippines 105.9 -0.62 1.0 0.2 8,281 -0.90
Thailand 68.6 -0.67 1.0 0.2 18,017 -0.27

Statistics
Mean 505.7 22,180
SD 648.2 15,513
Max 1.36 1.35
Min -0.70 -0.96
Range 2.06 2.31
Interval (1-10) 0.23 0.26

Ranked Values
1 (Min) -0.70 1.0 -0.96
2 -0.47 2.0 -0.70
3 -0.24 3.0 -0.45
4 -0.02 4.0 -0.19
5 0.21 5.0 0.07
6 0.44 6.0 0.32
7 0.67 7.0 0.58
8 0.90 8.0 0.84
9 1.13 9.0 1.09
10 (Max) 1.36 10.0 1.35
Capita ($) - Higher More Attractive GDP per Capita ($) - Lower More Attractive
10% 10% Total
Rating Assessment Raw Data Standardized Rating Assessment Assessment
6.0 0.6 20,300 0.55 5.0 0.5 1.4
2.0 0.2 15,300 -0.61 9.0 0.9 2.6
10.0 1.0 24,800 1.59 1.0 0.1 1.3
1.0 0.1 14,500 -0.80 10.0 1.0 1.4
5.0 0.5 19,200 0.29 6.0 0.6 2.0
1.0 0.1 13,500 -1.03 10.0 1.0 1.3

17,933
4,307
1.59
-1.03
2.62
0.29

1.0 (Max) -1.03 10.0

2.0 -0.74 9.0
3.0 -0.45 8.0
4.0 -0.15 7.0
5.0 0.14 6.0
6.0 0.43 5.0
7.0 0.72 4.0
8.0 1.01 3.0
9.0 1.30 2.0
10.0 (Min) 1.59 1.0

Capita ($) - Higher More Attractive GDP per Capita ($) - Lower More Attractive
10% 10% Total
Rating Assessment Raw Data Standardized Rating Assessment Assessment
3.0 0.3 16,758 -0.35 8.0 0.8 2.6
10.0 1.0 43,130 1.35 1.0 0.1 1.3
1.0 0.1 7,305 -0.96 10.0 1.0 2.4
9.0 0.9 39,591 1.12 2.0 0.2 1.3
1.0 0.1 8,281 -0.90 10.0 1.0 1.3
3.0 0.3 18,017 -0.27 8.0 0.8 1.3

22,180
15,513
1.35
 -0.96
2.31
0.26

1.0 (Max) -0.96 10.0

2.0 -0.70 9.0
3.0 -0.45 8.0
4.0 -0.19 7.0
5.0 0.07 6.0
6.0 0.32 5.0
7.0 0.58 4.0
8.0 0.84 3.0
9.0 1.09 2.0
10.0 (Min) 1.35 1.0