Determine the advertising mix for a new product

Assignment Help Business Management

Reference no: EM13971111

A marketing manager is trying to determine the advertising mix for a new product. Three types of ads are being considered: radio, TV and newspaper. The firm's ad agency has provided the following data:

Type of ad	Radio	TV	Newspaper
Cost per ad	$1900	$3000	$1400
Number of customers exposed per ad	35,000	70,000	50,000
Number of units sold per ad	3,000	8,000	5,000

Several other criteria must be met: the advertising budget is $100,000, total exposure must be 2,500,000 customers, and no more than 30 ads may appear in any medium. The firm wants to maximize total number of units sold.

Write the LP formulation, set the problem up in Excel and use Solver to find the optimal solution

Use your Solver output to answer the questions below.

A. What is the optimal solution and the total number of units sold?

B. Within what range can the objective function coefficient for newspapers vary without changing the optimal solution?

C. What would the number of units sold per radio ad have to change to in order for radio ads to be used in the advertising mix?

D. What would marginal benefit of adding to the advertising budget be? How high could we increase the budget and still expect this benefit?

E. If we didn't restrict the number of newspaper ads, how many could we allow before the optimal solution would change?

F. Would the solution change if the number of units sold per ad changed to the values in the following table?

Radio TV Newspaper

No. of units sold per ad 3500 10000 4500

Reference no: EM13971111

Questions Cloud

What is the nature of such loss : How much loss may Donna recognize in 2006 and 2012? What is the nature of this loss? How much loss may Walter (a single taxpayer) recognize in 2012, and what is the nature of such loss?

What risks does southwest face : What risks does Southwest face? Can it continue to thrive as a low-cost airline when tough economic times hit?

Aid for the following given scenario : List in detail ALL THE STEPS you need to do to give proper aid for the following scenario: You are driving atone through the Ellensburg High School parking lot to watch a basketball game when you notice a mother loading her four young children int..

What is its speed at the end of the displacement : A horizontal force F a of magnitude 19.0 N is applied to a 3.16 kg book as the book slides a distance d = 0.70 m up a frictionless ramp at angle theta = 30 degree. During he displacement, what is the net work done on the book by F ,the gravitation..

Determine the advertising mix for a new product : A marketing manager is trying to determine the advertising mix for a new product. Three types of ads are being considered: radio, TV and newspaper. The firm's ad agency has provided the following data:

About how organization functions in one frame verses another : How does my organization function in this frame and compared to other frames and what might be different if the organization functioned in this frame?

Is there a net transfer of energy to or from the trunk : During the displacement, what is the net work done on the trunk by the three applied forces, the gravitational force, and the normal force?

Technical details of norms for using construction chemicals : What is the source of information to know the technical details of norms for using Construction Chemicals?

Discuss the rights of the defendant in your state : Discuss the rights of the defendant in your state during the trial phase of the criminal justice process.

User Account

All Pages