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 cells are the variable cells in this model?
A) $B$6:$C$6, $B$7:$E$8
B) $B$6:$C$6
C) $B$9:$E$9
D) $B$6:$E$8

Question

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 cells are the variable cells in this model?
A) $B$6:$C$6, $B$7:$E$8 
B) $B$6:$C$6 
C) $B$9:$E$9 
D) $B$6:$E$8

Quizplus · Accepted Answer

The Answer of 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 cells are the variable cells in this model?
A) $B$6:$C$6, $B$7:$E$8 
B) $B$6:$C$6 
C) $B$9:$E$9 
D) $B$6:$E$8

Exhibit 7.1 The Following Questions Are Based on the Problem Below