Advertising strategy case problem

Assignment Help Financial Management
Reference no: EM13849718

Advertising Strategy Case Problem- I can't seem to get the numbers right with this problem. Can someone show me step-by-step how to solve this problem?

Duke Motors, Inc., has hired a marketing services firm to develop an advertising strategy for promoting Duke’s used car sales. The marketing firm has recommended that Duke use spot announcements on both television and radio as the advertising media for the proposed promotional campaign. Advertising strategy guidelines are expressed as follows:

-Use at least 30 announcements for combined television and radio coverage.

-Do not use more than 25 radio announcements.

-The number of radio announcements cannot be less than the number of television announcements.

The television station has quoted a cost of $1200 per spot announcement, and the radio station has quoted a cost of $300 per spot announcement. Duke’s advertising budget has been set at $25,500. The marketing services firm has rated the various advertising media in terms of audience coverage and recall power of the advertisement. For Duke’s media alternatives, the television announcement is rated at 600 and the radio announcement is rated at 200. Duke’s president would like to know how many television and how many radio spot announcements should be used to maximize the overall rating of the advertising campaign.

Duke’s president believes that the television station will consider running the Duke spot announcement on its highly rated evening news program (at the same cost) if Duke will consider using additional television announcements.

MANAGERIAL REPORT

Perform an analysis of advertising strategy for Duke Motors and prepare a report to Duke’s president presenting your findings and recommendations. Include, but do not limit your discussion to, a consideration of the following items.

1) The recommended number of television and radio spot announcements.

2) The relative merits of each advertising medium.

3) The rating that would be necessary for the news program before it would make sense to increase the number of television spots.

4) The number of television spots that should be purchased if the news program is rated highly enough to make increasing the number of television spots advisable.

5) The restrictions placed on the advertising strategy that Duke might want to consider relaxing or altering.

6) The best use of any possible increase in the advertising budget.

7) Any other information that may help Duke’s president make the advertising strategy decision.

Can you also include?

- a formulation of the problem with decision variables clearly defined

-a copy of your spreadsheet with formulas exposed;

- the answer report (generated by Solver)

- the sensitivity report (generated by Solver).

Reference no: EM13849718

Questions Cloud

What limitations prevent the forecasts from being foolproof : Give examples of how ratios gleaned from the financial statements can be used as a tool in helping a firm plan for the future. What do these ratios tell an individual analyzing them? What limitations prevent the forecasts from being foolproof?
What kinds of south korean leadership behaviors : What kinds of South Korean leadership behaviors
Debt is stock variable while deficit is flow variable : Which of the following is a conclusion of using the generational accounting measure? Both debt and deficit are flow variables. Debt is a stock variable while deficit is a flow variable. Debt is a flow variable while deficit is a stock variable. Debt ..
The mortgage is standard mortgage with monthly payments : What is the remaining balance on a $125,000.00 mortgage after 110 months? The mortgage is a standard mortgage (360 months) with monthly payments and a nominal rate (monthly compounding) of 6.10%. How Would I figure this out?
Advertising strategy case problem : Duke Motors, Inc., has hired a marketing services firm to develop an advertising strategy for promoting Duke’s used car sales. The marketing firm has recommended that Duke use spot announcements on both television and radio as the advertising media f..
Develop framework for school counseling collaborative model : You will develop a framework for a School Counseling Collaborative Model as the culminating benchmark assignment for this course, which will integrate learning across all course modules. This is a detailed model that will take considerable time, s..
How would you characterize timberlands exercise : How would you characterize Timberlands exercise of its corporate power in society? Is Timberland using its influence responsibly?
Standard mortgage with monthly payments and nominal rate : Consider a standard mortgage (360 months) with monthly payments and a nominal rate (monthly compounding) of 5.70%. What portion of the payments during the first 31 months goes toward interest? How Would I figure this out?
List launch vehicles that might be used to launch spacecraft : Go back and check your needs, goals and objectives to see if there are any obvious on the launch vehicle choice.  List several launch vehicles that might be used to launch your spacecraft into your chosen orbit.

Reviews

Write a Review

 

Financial Management Questions & Answers

  Complete the financial reporting for each period

Complete the financial reporting for each period

  Annual net patient revenues

Community Hospital has annual net patient revenues of $150 million. At the present time, payments received by the hospital are not deposited for six days on average. The hospital is exploring a lockbox arrangement that promises to cut the six days to..

  What interest rate would legally have to be quoted

A local finance company quotes an interest rate of 17 percent on one-year loans. So, if you borrow $31,000, the interest for the year will be $5,270. What interest rate would legally have to be quoted? What is the effective annual rate?

  Explain what is securitization

What is securitization? What are the benefits that banks can get from it? What impact is securitization likely to have on the quality of assets that banks keep in their portfolio?

  Weighted-average interest rate used interest capitalization

Hanson Company is constructing a building. Construction began on February 1 and was completed on December 31. Expenditures were $1,824,000 on March 1, $1,212,000 on June 1, and $3,057,100 on December 31.

  Assume that you have been provide with the following data

Assume that you have been provided with the following data: D1 = $1.30; P0 = $42.50; and g = 5.0% (constant). What is the cost of equity based on the Dividend Growth Model? ________ 8.06% 10.06% 11.41%   12.0%

  Default on its sovereign debt caused the spread

In early 2010, the possibility that Greece might default on its sovereign debt caused the spread between German and Greek debt to ____ by about ____ percentage points

  Mortgage balance at the lower rate for same maturity date

Consider a 15-year, $150,000 mortgage with a rate of .0590 percent. Nine years into the mortgage, rates have fallen to 5 percent. What would be the monthly saving to a homeowner from refinancing the outstanding mortgage balance at the lower rate for ..

  Value against an appreciation of the us exporter currency

Explain how Ghanaian importer can protect its value against an appreciation of the US exporter currency. Show calculations to support your explanation

  What would be the annual cost of jet fuel

Jet fuel: 32% of operating expenses per ASM as reported in most recent annual report, operating expenses per ASM (cents) = 12.5, number of ASM per year is 58055805 ASM. What would be the annual cost of jet fuel if Southwest Airlines offer three fligh..

  What are the annual carrying costs of post card inventory

Post Card Depot, an large retailer of post cards, orders 3,361,530 post cards per year from its manufacturer. Post Card Depot plans on ordering post card 19 times over the next year. What are the annual carrying costs of post card inventory

  Delay in integrating the acquired business

Delay in integrating the acquired business can contribute to which of the following?

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