Solved

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. 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
-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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions