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 purchased

 professor 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 chapter 

he needs the answer using excel(tables)