Reference no: EM13971097
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
|
Positive and negative impact of performance reviews
: Discuss the positive and negative impact of performance reviews on employee morale, retention, and business operations improvement. What performance review system (PMS) does your organization use,
|
|
What net tax savings per share for an investor would result
: Suppose that all capital gains are taxed at a 25% rate and that the dividend tax rate is 50%. Arbuckle Corporation is currently trading for $30 and is about to pay a $6 special dividend. Absent any other trading frictions or news, what will its share..
|
|
Simplicity assume that operating-maintenance costs for model
: Jessica is in the market for a new car. She has narrowed her search down to 2 models. Model A costs $27,000 and Model B costs $18,000. With both cars she plans to pay cash and own them for 3 years before trading in for a new car. For simplicity assum..
|
|
What is the interquartile range (iqr)
: What is the probability of no mutant ability rounding to 3 decimal places - what is the probability of being bitten by a flea rounding to 3 decimal places?
|
|
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:
|
|
Discuss some of the impacts of resource constrained projects
: Resource constraints can be a huge burden on a project, sometimes causing project issues and/or project failures. Discuss some of the impacts of resource constrained projects and what the project manager can do to understand if there is a potentia..
|
|
Assignment on operations decision
: Using the regression results and the other computations from Assignment 1, determine the market structure in which the low-calorie frozen, microwavable food company operates.
|
|
What is the expected return on this portfolio
: A stock has a beta of 1.14, an expected return of 13.38 percent, and lies on the security market line. A risk-free asset is yielding 2.84 percent. Ferghus wants to create a $15,000 portfolio that is comprised of these two securities and that will hav..
|
|
Advantages & disadvantages of approving a law like colorados
: Denver now has more marijuana dispensaries than liquor stores and Starbucks combined. The state government of Colorado is collecting millions in taxes and license fees.
|