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.
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