In one organisation there are several types of solutions to be implemented, but the organisation needs help to prioritise them, so that they know how to plan their tasks for the next year under potential pandemic scenarios. For the selection of each solution, and based on several focus groups within the organisation, the following main criteria has been identified: Resources availability, Costs of the tasks, Strategic plan of the solution, Implementation feasibility. After this identification, and based on several join analysis within the organisation, the following relationships were also identified: Resources availability is four times more important than Costs of the tasks, six times less important than Strategic plan of the solution and five times more important than Implementation feasibility. Costs of the tasks is nine times more important than Strategic plan of the solution and seven times more important than Implementation Feasibility. Strategic plan of the solution is six times less important than Implementation Feasibility. In the same way, for each criteria, the following sub-criteria and their relationships have been identified: Resources availability: How frequent resources are available, Visibility of resources and variety of resources available. Where relationships amongst them are as follows: o How frequent resources are available is seven times less important than Visibility of resources and two times less important than variety of resources available. Visibility of resources is four times less important than variety of resources available. Costs of the tasks: Task priorities per cost, currency of the task and task value added information. Where relationships amongst them are as follows: o Task priorities per cost is three times more important than currency of the task and equally important to task value added information. Currency of the task is two times less important than task value added information. Strategic plan of the solution: Risk analysis of the solution, sources of uncertainties affecting the solution and validation plan of the solution. Where relationships amongst them are as follows: O Risk analysis of the solution is seven times more important than sources of uncertainties affecting the solution and equally important to the validation plan of the solution. Sources of uncertainties affecting the solution is two times more important than validation plan of the solution. Implementation feasibility: End-users opinions, previous experiences, and results communication. Where relationships amongst them are as follows: End-users opinions is five times more important than previous experiences and seven times more important than Internal knowledge. Previous experiences is five times more important than results communication. In this context, the Random index table is as follows: N 1 2 3 4 5 6 7 8 9 10 RI 0.00 0.00 0.58 0.9 1.12 1.24 1.32 1.41 1.45 1.49 please elaborate an MCDM excel matrix to support your answers to the following parts: a) Elaborate the hierarchical tree and identify each Weights for each criteria and sub-criteria. Provide the global and local weights. Based on the results, what are the most desirable aspects a project should consider? b) Calculate the consistency ratio. Analyze the result. c) The organisation has received five solutions proposals and they are looking now to know which one will be the most convenient. Each proposal was interviewed to obtain the information about which criteria they prioritize. In addition to this, each solution also provided it cost. Considering the collected information about each project priorities shown below, please provide the benefit from each proposal and analyze the results. Which solutions should be selected? Solution 1: How frequent resources are available, currency of the task, sources of uncertainties affecting the solution, End-users opinions. 12,000. Solution 2: Visibility of resources, Task priorities per cost, Risk analysis of the solution, previous experiences. 9,000. Solution 3: variety of resources available, task value added information, validation plan of the solution, communication. 10,000. Solution 4: Visibility of resources, currency of the task, sources of uncertainties affecting the solution, previous experiences. 4,000. Solution 5: How frequent resources are available, Task priorities per cost, Risk analysis of the solution, End-users opinions. 8,000. In one organisation there are several types of solutions to be implemented, but the organisation needs help to prioritise them, so that they know how to plan their tasks for the next year under potential pandemic scenarios. For the selection of each solution, and based on several focus groups within the organisation, the following main criteria has been identified: Resources availability, Costs of the tasks, Strategic plan of the solution, Implementation feasibility. After this identification, and based on several join analysis within the organisation, the following relationships were also identified: Resources availability is four times more important than Costs of the tasks, six times less important than Strategic plan of the solution and five times more important than Implementation feasibility. Costs of the tasks is nine times more important than Strategic plan of the solution and seven times more important than Implementation Feasibility. Strategic plan of the solution is six times less important than Implementation Feasibility. In the same way, for each criteria, the following sub-criteria and their relationships have been identified: Resources availability: How frequent resources are available, Visibility of resources and variety of resources available. Where relationships amongst them are as follows: o How frequent resources are available is seven times less important than Visibility of resources and two times less important than variety of resources available. Visibility of resources is four times less important than variety of resources available. Costs of the tasks: Task priorities per cost, currency of the task and task value added information. Where relationships amongst them are as follows: o Task priorities per cost is three times more important than currency of the task and equally important to task value added information. Currency of the task is two times less important than task value added information. Strategic plan of the solution: Risk analysis of the solution, sources of uncertainties affecting the solution and validation plan of the solution. Where relationships amongst them are as follows: O Risk analysis of the solution is seven times more important than sources of uncertainties affecting the solution and equally important to the validation plan of the solution. Sources of uncertainties affecting the solution is two times more important than validation plan of the solution. Implementation feasibility: End-users opinions, previous experiences, and results communication. Where relationships amongst them are as follows: End-users opinions is five times more important than previous experiences and seven times more important than Internal knowledge. Previous experiences is five times more important than results communication. In this context, the Random index table is as follows: N 1 2 3 4 5 6 7 8 9 10 RI 0.00 0.00 0.58 0.9 1.12 1.24 1.32 1.41 1.45 1.49 please elaborate an MCDM excel matrix to support your answers to the following parts: a) Elaborate the hierarchical tree and identify each Weights for each criteria and sub-criteria. Provide the global and local weights. Based on the results, what are the most desirable aspects a project should consider? b) Calculate the consistency ratio. Analyze the result. c) The organisation has received five solutions proposals and they are looking now to know which one will be the most convenient. Each proposal was interviewed to obtain the information about which criteria they prioritize. In addition to this, each solution also provided it cost. Considering the collected information about each project priorities shown below, please provide the benefit from each proposal and analyze the results. Which solutions should be selected? Solution 1: How frequent resources are available, currency of the task, sources of uncertainties affecting the solution, End-users opinions. 12,000. Solution 2: Visibility of resources, Task priorities per cost, Risk analysis of the solution, previous experiences. 9,000. Solution 3: variety of resources available, task value added information, validation plan of the solution, communication. 10,000. Solution 4: Visibility of resources, currency of the task, sources of uncertainties affecting the solution, previous experiences. 4,000. Solution 5: How frequent resources are available, Task priorities per cost, Risk analysis of the solution, End-users opinions. 8,000