Question

1. A big national university is planning to open a new campus in one of the following countries: India, Singapore, Philippines, Thailand, and China. The president of the university is considering seven factors in her choice of location. The factor scores (based on a 10-point scale) and factor weighs are given in the following table. Score (on 10-point scale) Thailand China Singapore Philippines Weight India Factor 5 6 7 0.1 Social and cultural factors Availability of Technology Political and Legal issues 5 8 6 0.1 7 5 6 6 7 5 0.1 5 Faculty Availability and Costs 0.3 9 Communication Infrastructure 0.2 6 Population Demographics 0.1 9 7 6 6 0.1 Housing Availability 5 4 5 8 Which country should the university's president select? a. How would the president's decision change if "communication infrastructure" is not an issue? b.

Answer 1

a)

India Singapore Philippines Thailand China 2 Factor Weight Social and cultural factors 0.1 Availability of Technology 0.1 Political and Legal issues 0.1 Faculty Availability and Costs 0.3 Communication Infrastructure 0.2 Population Demographics 0.1 Housing Availability 0.1 Do NON CAN 5 6 7 Total weighted score =SUMPRODUCT($B$2:$B$8,C2:C8) =SUMPRODUCT($B$2:$B$8,D2:08) =SUMPRODUCT($B$2:$B$8,E2:E8) =SUMPRODUCT($B$2:$B$8,F2:F8) =SUMPRODUCT($B$2:$B$8, G2:68)

H B Weight 0.1 C India D E Singapore Philippi F Thailand G China 0.1 0.1 2 3 4 5 6 7 Factor Social and cultural factors Availability of Technology Political and Legal issues Faculty Availability and Costs Communication Infrastructure Population Demographics Housing Availability 0.1 8 0.1 Total weighted score 7.5

The total weighted score is highest for Singapore. Therefore, Singapore has to be selected.

b)

When communication infrastructure is not considered,

Weight India Singapore Philippines Thailand China 0.1 0.1 1 2 3 4 5 6 7 Factor Social and cultural factors Availability of Technology Political and Legal issues Faculty Availability and Costs Population Demographics Housing Availability 0.1 0.3 0.1 0.1 Total weighted score =SUMPRODUCT($B$2:$B$7, C2:07) =SUMPRODUCT($B$2:$B$7,02:07) =SUMPRODUCT($B$2:$B$7,E2:E7) =SUMPRODUCT($B$2:$B$7,F2:F7) =SUMPRODUCT($B$2:$B$7,62:67)

Singapore Philippines Thailand China 1 2 3 4 5 6 Factor Social and cultural factors Availability of Technology Political and Legal issues Faculty Availability and Costs Population Demographics Housing Availability B Weight 0.1 0.1 0.1 0.3 0.1 0.1 Total weighted score

India has the highest score. India must be selected