Exhibit 7.1 The Following Questions Are Based on the Problem Below

question 77

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. Which cell(s) is(are) the objective cell(s) in this model?

• A) $B$20
• B) $D$6
• C) $E$6
• D) $B$13:$E$14, $B$9:$E$9

---

Definitions:

Flowchart

A graphical representation of a process or system, showing the steps as boxes of various kinds, and their order by connecting them with arrows.

Standard Symbols

Predefined symbols that are universally recognized and used to convey specific information clearly and concisely.

Diagram

A visual representation of information, showing how different parts of a system, process, or concept are related or organized.

Bivariate Joint Frequency Distributions

A statistical analysis method that examines the relationship between two variables by counting the frequency of their joint occurrences.