How would the total exposure change if an additional

This preview shows page 2 - 3 out of 3 pages.

2. How would the total exposure change if an additional $10,000 were added to the advertising budget? Please see the attached excel file, sheet for detailed setup and solution. C1 Advertising campaign must reach at least 100,000 new C2 Use at least twice as many radio advertisements as television advertisements C3 Use no more than 20 television advertisements C4 The television budget should be at least $140,000. C5 The radio advertising budget is restricted to a maximum of $99,000 C6 The newspaper budget is to be at least $30,000. C7 Budget total
Group 35 3 Actually, you can see that this additional $10,000 is all devoted to television ads. Creating an increase in the dual price of advertising by 0.006 points for each dollar. Right hand side range of the dual price shows the budget increase: $289,000-$279,000= $10,000 and provides an increase of 2.8% in the total exposure. 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?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture