Compute a qualitative decision for a global location:

Instructions: Global Location Decision Model 1) Decide on at least 4 factors to will significantly influence your decision. 2) Based on relative importance, decide on weights for each factor -- must sum to 100% Factor 1 Factor 2 Factor 3 Factor 4 SUM 0 3) Show just 3 options for Country locations in the column headings -- a full analysis may have 5-20 options! 10% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/0! 4) Score each factor for Options 1, 2 and 3. 10 is best, 0 is worst. You don't have real data, just estimate each score. 20% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! 5) Compute the Weighted Score for each Option. (Consider using the =SUMPRODUCT function.) 30% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/0! 6) Select the best option! (.. or if scores are close, performance additional analyses.) 40% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/0! Options 50% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/0! Factors Weight 60% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! Factor 1 Scores = 0 to 10) 70% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/0! Factor 2 80% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! Factor 3 90% #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/O! #DIV/0! Factor 4 Sensitivity of Factor 1 Total 0% 1.0 0.9 0.8 Weighted Score --> 9 0.7 9 0.6 6 0.5 in 3 0.3 - 0 0.2 0.1 00 0% 20% 40% 60% 80% 100% Factor 1 Weight