Reference no: EM133305175

Assignment: XYZ Airlines Ltd. is a low-cost airline headquartered at Gurgaon, Haryana, India. Human Resource Department (HRD) of XYZ Airlines Ltd. recently conducted recruitment and selection process for the post of one flight attendant required to serve in their new aircraft. After primary filtration, three candidates were called for the final interview process. Below are the names of three candidates: 1. Pooja Arora 2. Shruti Mehra 3. Sanjana Suri HRD also defined that the two most important parameters on which a candidate should be judged are: 1. Soft Skills 2. Domain Skills Below were the judgements given by interviewer regarding three candidates and their two skills: 1. Soft Skills are five times more important than Domain Skills. 2. On Soft Skill assessment: a. Pooja is twice better than Shruti. Pooja is thrice better than Sanjana b. Shruti is twice better than Sanjana. 3. On Domain Skills assessment: a. Sanjana is five times better than Pooja. Sanjana is twice better than Shruti. b. Shruti is twice better than Pooja. Q. Who is the best possible candidate for the post of flight attendant at XYZ Airlines Ltd. Explain detailed process of solution using Analytic Hierarchy Process.

Question: Submit following documents: 1. MS-Excel sheet with detailed calculation which will be taken as a point of reference. The findings for which needs to mentioned in the report as you will be evaluated based on that. a. Creation of pairwise comparison matrices b. Calculation of Normalized matrices c. Calculation of Local Weights all nodes d. Calculation of Global Weights for alternatives 2. PDF document with detailed step by step process of solution with required explanation. a. Hierarchical Structure Creation b. Creating AHP Scale and Marking Data. Explanation on Local Weight and Global Weight Calculation d. Final Decision Making