The following questions are based on the problem below. A company wants to adver
ID: 3297106 • Letter: T
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.
A
B
C
D
E
1
TV
Radio
2
20
10
3
10
7
4
5
TV
Radio
Cost
Coverage
6
0
0
7
0
0
0
0
8
0
0
0
0
9
0
0
0
0
10
6
12
200
140
11
12
13
1
1
1
1
14
0
0
0
0
15
16
17
18
19
20
0
Refer to Exhibit 7.1. Which of the following is a constraint specified to Analytic Solver Platform for this model?
$B$9:$E$9=$B$6:$E$6
$B$9:$E$9>$B$10:$E$10
$B$9:$E$9<$B$10:$E$10
$B$9:$E$9=$B$10:$E$10
A
B
C
D
E
1
Problem DataTV
Radio
2
Cost20
10
3
Coverage10
7
4
5
Goal ConstraintsTV
Radio
Cost
Coverage
6
Actual Amount0
0
7
+Under0
0
0
0
8
Over0
0
0
0
9
= Goal0
0
0
0
10
Target Value6
12
200
140
11
12
Percentage Deviation:13
Under1
1
1
1
14
Over0
0
0
0
15
16
Weights17
Under18
Over19
20
Objective0
Explanation / Answer
cost <= 200
coverage >= 140
x >= 6 {x- -TV}
y >= 12 {y -Radio}
$B$9:$E$9>$B$10:$E$10 is nearest close answer
b.$B$9:$E$9>$B$10:$E$10 is nearest close answer
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.