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 of the following is a constraint specified to Risk Solver Platform (RSP) for this model?

Question

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 of the following is a constraint specified to Risk Solver Platform (RSP) for this model?
A)$B$9:$E$9=$B$6:$E$6 
B)$B$9:$E$9<$B$10:$E$10 
C)$B$9:$E$9=$B$10:$E$10 
D)$B$9:$E$9>$B$10:$E$10

Quizplus · Accepted Answer

The constraint specified in cell range $B$9:$E$9 is that the total number of people reached through TV ads and radio ads should be equal to the target audience of 140 million people (specified in cell B6). This constraint is represented by the formula $B$9:$E$9=$B$10:$E$10. Therefore, option C is the correct choice.

The Following Questions Are Based on the Problem Below