Exhibit 7.1 The Following Questions Are Based on the Problem Below

question 7

Multiple Choice

Exhibit 7.1
The following questions are based on the problem below.
A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet.
-Refer to Exhibit 7.1. What formula goes in cell D6?

• A) =SUMPRODUCT(B2:B3,B6:B7)
• B) =B2*C2+B6*C6
• C) =SUMPRODUCT(B2:C2,B10:C10)
• D) =SUMPRODUCT(B2:C2,B6:C6)

---

Definitions:

Mortise-and-Tenon System

A woodworking or masonry joint that connects two pieces of material through a cutout (mortise) and a projecting piece (tenon) that fits inside the cutout.

Kamakura Period

A period in Japanese history (1185-1333) marked by the rise of the samurai class and the establishment of feudalism.

Sociopolitical Force

A term referring to the influence and interplay of societal and political factors on events and behaviors.

Shogunate

The Japanese military government of the 12th through 19th centuries.