Homework Help is Here – Start Your Trial Now!
Business
Marketing
Please do it In Excel! Thanks, I will give you a thumbs up! Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

Please do it In Excel! Thanks, I will give you a thumbs up! Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

Principles Of Marketing
Principles Of Marketing
17th Edition
ISBN:9780134492513
Author:Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:Kotler, Philip, Armstrong, Gary (gary M.)
Chapter1: Marketing: Creating Customer Value And Engagement
Section: Chapter Questions
Problem 1.1DQ
See similar textbooks
icon
Related questions
Question

Please do it In Excel! Thanks, I will give you a thumbs up!

Note:-

  • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
  • Answer completely.
  • You will get up vote for sure.
Amanda has a yearly advertising and promotions budget of $50,000. Her goal is to maximize the reach (the number of customers that see her company's ads or other marketing efforts). She is considering a mix of placing ads on art websites and in printed art magazines, as well as using targeted social media ad placements and appearances at art tradeshows. She wants to make sure that the company has an online presence, so would like to see at least 100 ads placed in any combination of websites and social media per year. However, she has data that suggests that if she advertises on the websites more than 60 times per year she will be wasting money. There are seven art tradeshows that the company could attend, but Amanda feels it is mandatory to attend at least the two most popular tradeshows. There are three major art magazines, each published monthly, that Amanda would like to advertise in. She could advertise in each of these once per month but would be comfortable reducing the frequency to a minimum of once every three months in each magazine and rotating the placements between the magazines. The reach and cost of each type of ad placement or event is shown below: Reach (number of people) Cost (dollars) Art Websites 14000 200 Social Media Tradeshows 12,000 250 Art 5,000 1,000 Print Magazine Ads 10,000 400 Recommend the appropriate mix of advertising and promotions for the company. Also comment on what would change if Amanda doubled her advertising and promotions budget. Estimate the increased reach.
Transcribed Image Text:Amanda has a yearly advertising and promotions budget of $50,000. Her goal is to maximize the reach (the number of customers that see her company's ads or other marketing efforts). She is considering a mix of placing ads on art websites and in printed art magazines, as well as using targeted social media ad placements and appearances at art tradeshows. She wants to make sure that the company has an online presence, so would like to see at least 100 ads placed in any combination of websites and social media per year. However, she has data that suggests that if she advertises on the websites more than 60 times per year she will be wasting money. There are seven art tradeshows that the company could attend, but Amanda feels it is mandatory to attend at least the two most popular tradeshows. There are three major art magazines, each published monthly, that Amanda would like to advertise in. She could advertise in each of these once per month but would be comfortable reducing the frequency to a minimum of once every three months in each magazine and rotating the placements between the magazines. The reach and cost of each type of ad placement or event is shown below: Reach (number of people) Cost (dollars) Art Websites 14000 200 Social Media Tradeshows 12,000 250 Art 5,000 1,000 Print Magazine Ads 10,000 400 Recommend the appropriate mix of advertising and promotions for the company. Also comment on what would change if Amanda doubled her advertising and promotions budget. Estimate the increased reach.
Expert Solution
steps

Step by step

Solved in 7 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Principles Of Marketing
Principles Of Marketing
Marketing
ISBN:
9780134492513
Author:
Kotler, Philip, Armstrong, Gary (gary M.)
Publisher:
Pearson Higher Education,
Marketing
Marketing
Marketing
ISBN:
9781259924040
Author:
Roger A. Kerin, Steven W. Hartley
Publisher:
McGraw-Hill Education
Foundations of Business (MindTap Course List)
Foundations of Business (MindTap Course List)
Marketing
ISBN:
9781337386920
Author:
William M. Pride, Robert J. Hughes, Jack R. Kapoor
Publisher:
Cengage Learning
Marketing: An Introduction (13th Edition)
Marketing: An Introduction (13th Edition)
Marketing
ISBN:
9780134149530
Author:
Gary Armstrong, Philip Kotler
Publisher:
PEARSON
MKTG 12:STUDENT ED.-TEXT
MKTG 12:STUDENT ED.-TEXT
Marketing
ISBN:
9781337407595
Author:
Lamb
Publisher:
Cengage
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS