Excel

There are five candidate suppliers (A, B, C, D and E) to select for a manufacturing company. The evaluation criteria are profit, service network, financial stability of supplier, delivery conditions, geographical location and quality. The following matrix shows the scores of the suppliers for all criteria: service financial delivery geographical Supplier profit network stability conditions quality loc. 4 8 1 5 6 9 B C 2 2 7 7 S 4 2 10 1 D E The criteria weights are given in the following table: service financial delivery geographical profit network stability conditions loc. quality 0.28 0.24 0.16 0.1 0.15 0.07 Question 1 (50 points). Using TOPSIS methodology, calculate the score of each supplier and find out the best supplier. 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. Question 2 (50 points). Using ELECTRE methodology, find out the best supplier. 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