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

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.

A B C D E
1 Problem Data TV Radio
2 Cost 20 10
3 Coverage 10 7
4
5 Goal Constraints TV Radio Cost Coverage
6 Actual Amount 0 0
7 +Under 0 0 0 0
8 Over 0 0 0 0
9 = Goal 0 0 0 0
10 Target Value 6 12 200 140
11
12 Percentage Deviation:
13 Under 1 1 1 1
14 Over 0 0 0 0
15
16 Weights
17 Under
18 Over
19
20 Objective 0

Refer to Exhibit 7.1. Which of the following is a constraint specified to Analytic Solver Platform for this model?

a. $B$9:$E$9<$B$10:$E$10
b. $B$9:$E$9=$B$6:$E$6
c. $B$9:$E$9=$B$10:$E$10
d. $B$9:$E$9>$B$10:$E$10

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!