Exhibit 14.8 The Following Questions Use the Information Below

Multiple Choice

Exhibit 14.8
The following questions use the information below.
A company needs to buy a new insurance policy. They have three policies to choose from, A, B and C. The policies differ with respect to price, coverage and ease of billing. The company has developed the following AHP tables for price and summary. The other tables are not shown due to space limitations.
-Refer to Exhibit 14.8. What formula should go in cell C7 and get copied to D7:E7 of the Summary worksheet to compute the Weighted Average Score?

A) =SUMPRODUCT(C4:E4,$G$4:$G$6)
B) =SUMPRODUCT(C4:C6,$C$5:$C$7)
C) =SUMPRODUCT($G$4,$G$6)
D) =SUMPRODUCT(C4:C6,$G$4:$G$6)