Ahp excel _ due in 5 hours

A motorist is using the AHP to choose a new car from three possible models Arrow, a Bestmobile and a Commuter. The choice will attributes, Cost and Style. The motorist considers that Cost is “weakly more than Style. When asked to compare the cost of the cars, the motorist makes the following statements: On cost, the Bestmobile is ‘weakly preferred’ to the Arrow, but the Arrow is “weakly preferred’ to the Commuter Also, the Bestmobile is ‘extremely preferred’ to the Commuter. On style, the Arrow is ‘very strongly preferred’ to the Bestmobile, but the Commuter is ‘weakly preferred’ to the Arrow. Also, the Commuter is ‘extremely preferred’ to the Bestmobile (a) Construct a hierarchy to represent the decision problem. b) Use an appropriate software package, or the approximation method, to cal culate the weights for each table in the hierarchy and hence determine which car should be purchasedprofessor asked to answer questions  3 a  and b and  and refer to the table in the center of page 77 for some of the w h ighting factors , I have attached the 77 page and the question and also slides of the chapterhe needs the answer using excel(tables)

"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "GET10" in your order"