I started working on this problem using Excel , but I am not sure if i am am approaching this correctly. the problem statement is in a word document AHP some explanation would be helpful.
The MIS Department is developing a computer lab to support advanced applications. The planning committee has focused on three main criteria in their choice of PC vendors. These criteria are price, speed and reputation of the vendor. Reputation involves the likelihood of staying in business, telephone support and favorable reviews in computer magazines. Because of a limited budget the price criterion is strongly preferred to speed and moderately preferred to reputation. Reputation is equally to moderately preferred to speed. The committee has narrowed the choices to three vendors, A, B and C. The following pair wise comparison matrices were developed among the vendors with respect to the three criteria.
i) Construct the pair wise comparison matrix for the three criteria.
ii) Calculate the priorities and consistency ratio for each of the four pair wise comparison matrices.
iii) Determine the overall priorities for each of the three vendors and declare a winner.
A seven page long step by step explanation of Analytic Hierarchy Process (AHP), explaining in detail how to construct the pair wise comparison matrix for criteria, how to calculate the priorities and consistency ratio for each of the pair wise comparison matrices and finally determine the overall priorities deciding the optimal choice.