Exhibit 14.8 The Following Questions Use the Information Below

question 15

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)

---

Definitions:

Body Contact

Physical touching or closeness between individuals, which can foster emotional bonding, communicate nonverbally, and promote comfort and security.

Autism Spectrum Disorder

A developmental disorder characterized by challenges with social skills, repetitive behaviors, and communication.

MMR Vaccine

A vaccination that protects against measles, mumps, and rubella, three serious and potentially life-threatening diseases.

Fraudulent Study

An illegitimate or deceitful research project deliberately designed to produce misleading or incorrect results.