A) Using Multi Criteria Decision Analysis (MCDA) develop a model in Excel to evaluate the options open to one of your classmates in terms of progressing his career once he has finished his masters Course. Making clear the way in which you generated their value tree, the reasoning behind the criteria used in the evaluation and the weightings for the evaluation process. You should produce results that indicate which of the options is seen as most desirable, and also comment on the sensitivity of your findings to changes in the weightings. You must compare at least 4 options in your analysis.
All excel models (Graphs and tables) outputs should have explanations of model development alongside. Maximum of 1000 words.