How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Scott Your Own Question

Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

due 8/1 Linear Programming Case URGENT

Customer Question

Linear Programming Case

Planning an Advertising Campaign

The Flamingo Grill is an upscale restaurant located in St. Petersburg, Florida. They have asked you to help them plan their advertising campaign for the coming season. They requested your recommendation concerning how the advertising budget should be distributed across television, radio, and newspaper advertisements. The budget has been set at $300,000.

In a meeting with Flamingo management you are provided the following information about the industry exposure effectiveness rating per ad, their estimate of the number of potential new customers reached per ad, and the cost for each ad.

Advertising Media

Exposure Rating per Ad

New Customers per Ad

Cost per Ad

Television

90

4000

$10,000

Radio

25

2000

$3000

Newspaper

10

1000

$1000

 

Flamingo management team indicated maximizing the total exposure rating, across all media, as the objective function of the advertising campaign. Because of management's concern with attracting new customers, management stated that the advertising campaign must reach at least 100,000 new customers. To balance the advertising campaign and make use of all media, Flamingo's management team also provided the following guidelines.

  • Use at least as twice as many radio advertisements as television advertisements.
  • Use no more than 20 television advertisements.
  • The television budget must be at least $140,000.
  • The radio advertising budget is restricted to a maximum of $100,000.
  • The newspaper budget is to be at least $30,000.

 

You have agreed to work with these guidelines and provide a recommendation as how the $300,000 advertising budget should be allocated among TV, Radio, and newspaper advertising.

Part A

Develop a model that can be used to determine the advertising budget allocation for Flamingo Grill. Include a discussion of the following in your report.

  • 1- A schedule showing the recommended number of TV, Radio, and Newspaper advertisements and the budget allocation for each media. Find total exposure and indicate the total number of potential new customers reached.
  • 2- How would the above recommendation change if an additional $50,000 were added to the advertising budget.

 

  • 3- How the advertising campaign schedule change if the objective function of the advertising campaign is to maximize the number of new customers reached. Show the new ad campaign with number and budget for each media as in part (1).

 

Part B

A media marketing research indicates that the data concerning exposure and customer reach were only applicable to the first few ads in each media. For television, the exposure rating of 90 and the new customer reached per ad were reliable for the first 10 TV ads. After 10 TV ads, the benefit is expected to decline. It is estimated that after 10 TV ads, the exposure rating declines to 55 and new customers reached is reduced to 2500. For radio ads beyond 15, the exposure rating declines to 20 and new customers reached declines to 1000 per ad. Similarly, for newspaper ads above 20, the exposure rating declines to 5 and new customers reached declines to 700.

 

Develop a new model under above conditions and prepare a report similar to part A.

 

Submitted: 5 years ago.
Category: Homework
Expert:  R.R. Jha replied 5 years ago.
Would the solution without graphical representation be okay with you ?
Customer: replied 5 years ago.
hi i need to get it tonight can you? yeno graphs needed
Expert:  R.R. Jha replied 5 years ago.
Our standard times are different. How much hours are left before the night ?
Customer: replied 5 years ago.
this case need tobe solved by excell solver okey?
Expert:  R.R. Jha replied 5 years ago.
First one can definitely be. I'll have to think for second one. May be solver or graphically.
Customer: replied 5 years ago.
hmm, ok actually i can do it by myself but i have an headache :) thanks for your help..we have 6 hours left can we do it?
Expert:  R.R. Jha replied 5 years ago.
If completed, I'll try to reply no later than 6 hours.
Customer: replied 5 years ago.

hmm have you ever tried that kind questions before? if you can not do it I am not going to have any other chance to finish it let say you have 4 hours ok?

Expert:  R.R. Jha replied 5 years ago.
Sure I've.
It's not even half an hour question if you are not manually solving it. What I meant to say that I'd try my best to reply within your deadline. But if you wish and are confident of solving it yourself for your own good as you say, I may opt out so that you close the question.
Customer: replied 5 years ago.
ok lets start
Customer: replied 5 years ago.

I mean I need your help to finish it.. ok?

Customer: replied 5 years ago.
did you start? or not?
Expert:  R.R. Jha replied 5 years ago.
I've decided to opt out. May be some other expert would be able help you.
Expert:  muvee replied 5 years ago.
I can do the PART A, do you need it?
Customer: replied 5 years ago.

not enough thank you

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3121
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3035
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/lanis/2009-4-1_233717_phput9xef_c1pm.jpg Lani S.'s Avatar

    Lani S.

    Tutor

    Satisfied Customers:

    2457
    Registered Nurse, Internet Researcher, Private Tutor
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2341
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1975
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1873
    Bachelors Degree and CPA with Accounting work experience