3. The director of advertising for a retail chain is considering how to allocate her $200,000 budget for television advertising among four programs (A, B, C, D) on three channels (1, 2, 3). Market research studies have shown that the chain's cus- tomers can be broken down into two groups: "High-end Achievers" and "Aspiring Achievers." High-end Achievers spend twice as much in the store as do Aspiring Achievers. The director wants to maximize the total in-store spending potential of the audience but must have at least three ads on each program, and cannot spend more than 50% of the budget on any one channel. The audience by pro- gram and the ad costs are: 1. Expected % High-End % Aspiring Channel Program Audience Achievers Achievers Cost/Ad 1 A 100,000 25 75 $7,500 1 B 50,000 60 40 $4,000 2 C 90,000 40 60 $6,500 3 D 80,000 50 50 $5,000 What is the most effective ad purchase ignoring the fact that the number of ads on any one program must be integer? 2. Include an integer constraint on the number of ads and re-solve. 3. Compare the two solutions.
3. The director of advertising for a retail chain is considering how to allocate her $200,000 budget for television advertising among four programs (A, B, C, D) on three channels (1, 2, 3). Market research studies have shown that the chain's cus- tomers can be broken down into two groups: "High-end Achievers" and "Aspiring Achievers." High-end Achievers spend twice as much in the store as do Aspiring Achievers. The director wants to maximize the total in-store spending potential of the audience but must have at least three ads on each program, and cannot spend more than 50% of the budget on any one channel. The audience by pro- gram and the ad costs are: 1. Expected % High-End % Aspiring Channel Program Audience Achievers Achievers Cost/Ad 1 A 100,000 25 75 $7,500 1 B 50,000 60 40 $4,000 2 C 90,000 40 60 $6,500 3 D 80,000 50 50 $5,000 What is the most effective ad purchase ignoring the fact that the number of ads on any one program must be integer? 2. Include an integer constraint on the number of ads and re-solve. 3. Compare the two solutions.
Chapter14: Monopolistic Competition And Product Differentiation
Section: Chapter Questions
Problem 15P
Related questions
Question
Please see attached:
Can you help me set this problem up in Excel Solver?
What is the most effective ad purchase, ignoring the fact that the number of ads on any one program must be integer?
Include an integer contraint on the number of ads and re-solve.

Transcribed Image Text:3.
The director of advertising for a retail chain is considering how to allocate her
$200,000 budget for television advertising among four programs (A, B, C, D) on
three channels (1, 2, 3). Market research studies have shown that the chain's cus-
tomers can be broken down into two groups: "High-end Achievers" and "Aspiring
Achievers." High-end Achievers spend twice as much in the store as do Aspiring
Achievers. The director wants to maximize the total in-store spending potential
of the audience but must have at least three ads on each program, and cannot
spend more than 50% of the budget on any one channel. The audience by pro-
gram and the ad costs are:
1.
Expected
% High-End
% Aspiring
Channel Program
Audience
Achievers
Achievers
Cost/Ad
1
A
100,000
25
75
$7,500
1
B
50,000
60
40
$4,000
2
C
90,000
40
60
$6,500
3
D
80,000
50
50
$5,000
What is the most effective ad purchase ignoring the fact that the number of
ads on any one program must be integer?
2.
Include an integer constraint on the number of ads and re-solve.
3.
Compare the two solutions.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps

Recommended textbooks for you

Exploring Economics
Economics
ISBN:
9781544336329
Author:
Robert L. Sexton
Publisher:
SAGE Publications, Inc

Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning

Exploring Economics
Economics
ISBN:
9781544336329
Author:
Robert L. Sexton
Publisher:
SAGE Publications, Inc

Managerial Economics: Applications, Strategies an…
Economics
ISBN:
9781305506381
Author:
James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
Publisher:
Cengage Learning

Economics (MindTap Course List)
Economics
ISBN:
9781337617383
Author:
Roger A. Arnold
Publisher:
Cengage Learning


Microeconomics: Private and Public Choice (MindTa…
Economics
ISBN:
9781305506893
Author:
James D. Gwartney, Richard L. Stroup, Russell S. Sobel, David A. Macpherson
Publisher:
Cengage Learning