Excel

Question 1 (100 points). There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company. The evaluation criteria are price, delivery conditions, geographical location and quality. The following matrix compares the criteria: PRICE DELIVERY QUALITY CRITERIA COMPARISON GEOGRAPHIC AL PRICE 1 113 1/3 15 DELIVERY 3 1 3 13 3 1/31 1 1/5 GEOGRAPHIC AL QUALITY $ 3 5 1 The following matrices compares the alternative suppliers for all criteria: PRICEA B C D E A13529 181337 1/5 1/3/13 1/71/5 1/31 13 1/9 17 15131 B C D E DELIVERY A B C D E CONDITIONS A 1 1/35 2 B 31 ss 19 1/5 1/51 1/33 D 1 1/5 3 1 5 E 1/91/9 1/31/51 GEOGRAPHIC AL LOCATION BE B C D E 1 1/91/31/913 19 113 1139 Is 1/31/33 1933 319 LS 151 QUALITY A B C D E 113 15 13 13 1/311 1/31/31/51 5 3 113 1/2 33 1/31 1/5 3 $ 25 1 E 135 25 Using AHP methodology, the calculate score of each supplier and find out the best supplier. For each matrix, you must show your calculations. Note that you must also conduct consistency analysis for each matrix. Please create an Excel file for this problem and use your calculations on that (hint: you can extend the excel template that was posted on Sakai which includes the class example). Any other submissions other than MS Excel (including handwritten calculations) will receive zero