Estimate of the number of potential new customers

Assignment Help Finance Basics
Reference no: EM13790388

The Flamingo Grill is an upscale restaurant located in St. Petersburg, Florida. To help plan an advertising campaign for the coming season, Flamingo's management team hired the advertising firm of Haskell and Johnson (HJ). The management team requested HJ's recommendation concerning how the advertising budget should be distributed across television, radio, and newspaper advertisements. The budget has been set at $279,000.

In a meeting with Flamingo's management team, HJ consultants 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

Advertising Media Exposure Rating per Ad New Customers per Ad Cost per Ad
TV (Up to 10 Ads/More than 10 Ads) 90/55 4000/1500 $10,000
Radio (Up to 15 Ads/More than 15 Ads) 25/20 2000/1200 $3,000
NP (Up to 20 Ads/More than 20 Ads) 10/5 1000/800 $1,000

The exposure rating is viewed as a measure of the value of the ad to both existing customers and potential new customers. It is a function of such things as image, message recall, visual and audio appeal, and so on. As expected, the more expensive television advertisement has the highest exposure effectiveness rating along with the greatest potential for reaching new customers.

At this point, the HJ consultants pointed out that the data concerning exposure and reach were only applicable to the first few ads in each medium. For television, HJ stated that the exposure rating of 90 and the 4000 new customers reached per ad were reliable for the first 10 television ads. After 10 ads, the benefit is expected to decline. For planning purposes, HJ recommended reducing the exposure rating to 55 and the estimate of the potential new customers reached to 1500 for any television ads beyond 10. For radio ads, the preceding data are reliable up to a maximum of 15 ads. Beyond 15 ads, the exposure rating declines to 20 and the number of new customers reached declines to 1200 per ad. Similarly, for newspaper ads, the preceding data are reliable up to a maximum of 20; the exposure rating declines to 5 and the potential number of new customers reached declines to 800 for additional ads.

Flamingo's management team accepted maximizing the total exposure rating across all media as the objective 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 advertising media, Flamingo's management team also adopted the following guidelines:

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

HJ agreed to work with these guidelines and provide a recommendation as to how the $279,000 advertising budget should be allocated among television, radio, and newspaper advertising.

Managerial Report

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

1. A schedule showing the recommended number of television, radio, and newspaper advertisements and the budget allocation for each medium. Show the total exposure and indicate the total number of potential new customers reached.

2. A discussion of how the total exposure would change if an additional $10,000 were added to the advertising budget.

3. A discussion of the ranges for the objective function coefficients. What do the ranges indicate about how sensitive the recommended solution is to HJ's exposure rating coefficients?

4. The resulting media schedule if the objective of the advertising campaign was to maximize the number of potential new customers reached instead of maximizing the total exposure rating.

5. A comparison of the two media schedules resulting from items 1 and 4, respectively. What is your recommendation for the Flamingo Grill's advertising campaign?

Reference no: EM13790388

Questions Cloud

Learn energy psychology mind body healing technique : Learn Energy Psychology Mind Body Healing Technique
Describe the civil service syste : Describe the civil service system and how it affects police organization
Managing payroll in quickbooks : Analyze the importance of the payroll function in QuickBooks, and recommend at least one (1) additional feature or function you would prefer to see included in QuickBooks
How much is the departmental margin for the year : Thomas Company recorded operating data for its shoe division for the year. How much is the departmental margin for the year?
Estimate of the number of potential new customers : In a meeting with Flamingo's management team, HJ consultants 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 ..
Compute the direct materials price and efficiency variances : Material cost variances, use of variances for performance evaluation. Katharine Johnson is the owner of Best Bikes, a company that produces high- quality cross- country bicycles. Best Bikes participates in a supply chain that consists of suppliers, m..
What is biological psychology : What is biological psychology
Man-made and nature made endocrine disruptors : What steps can you take to help ensure you do not come in contact with endocrine disruptors?
Long-term investment decisions : Assume that the low-calorie frozen, microwavable food company from Assignments 1 and 2 wants to expand and has to make some long-term capital budgeting decisions. The company is currently facing increases in the costs of major ingredients.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Sampp has a rating of bb on these bonds and the typical

you have been asked to estimate a riskless rate in indonesian rupiah. the indonesian government has rupiah denominated

  What is a contingent liability why are contingent

what is a contingent liability? why are contingent liabilities accounted for differently than contingent

  How many additional shares can bob buy

Bob has $20,000 and want to buy the maximum amount of XYZ Stock's that he can. Hid margin A/C price XYZ is currently $30; the IMR is 45% & MMR is 25%. The broker charges 9% in loan's.

  Should the firm accept the following project

A firm evaluates all of its projects by applying the IRR rule. If the required return is 18%, should the firm accept the following project?

  Identify which of the expenses are deductible

Assume all of the same facts as in Part a., except that Roberta is self-employed. Identify which of the expenses are deductible, and indicate whether they are deductions for or from AGI.

  If the required return is 11 percent what is the npv for

mahjong inc. has identified the following two mutually exclusive projectsyearcash flow acash flow

  Article available in the ku library.

Include as part of your paper a discussion regarding the dangers of early retirement plan distributions. You should use multiple sources beyond the article for the review whether it agrees or disagrees with the KU Library article as part of your a..

  What is harper expected return

J. Harper Inc.'s stock has a 50% chance of producing a 35% return, a 30% chance of producing a 10% return, and a 20% chance of producing a -28% return. What is Harper's expected return?

  What is next year dividend

The last reported earnings for White Corp. were $1.50 last year and earnings are expected to grow at 5% indefinitely. If their dividend policy is to pay out 50% of earnings in dividends, what is next year's dividend?

  The housekeeping services department of abc hospital had

the housekeeping services department of abc hospital had 250000 in direct costs during 2006. these costs must be

  What is the project equivalent annual cost

If the required return is 19 percent, what is the project's equivalent annual cost, or EAC? (Do not round your intermediate calculations.)

  Computation of the borrowable amount through debentures

Computation of the borrowable amount through debentures and Delaware borrow under a term loan at 13 percent interest without breaching the indenture restriction

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd