The internet budget is to be at least 30000 hj agreed

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

The internet budget is to be at least $30,000HJ 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 internet advertising.Managerial ReportDevelop a model that can be used to determine the advertising budget allocation for the Flamingo Grill. Include a discussion of the following items in the report:1.A schedule showing the recommended number of television, radio and internet advertisements and the budget allocation for each medium. Show the total exposure and indicate the total number of potential new customers reach.2.A discussion of how the total exposure would change if an additional $10,000 were added to the advertising budget.Development of model:Let xrepresent the number of television ads, yrepresent the number of radio ads, and zrepresent the number of newspaper ads.The objective is to maximize the exposure rating. However, there are two different rates, depending on the number of each ad purchased. P= 90*min(x, 10) + 55*max(0, x– 10) +25*min(y, 15) + 20*max(0, y– 15) + 10*min(z, 20) + 5*max(0, z– 20)Taking the various constraints one by one:
• Reach at least 100,000 customers.This constraint has a similar form as the objective function above, since there are two different rates for each type of ad:4000*min(x, 10) + 1500*max(0, x– 10) +2000*min(y, 15) + 1200*max(0, y– 15) + 1000*min(z, 20) + 800*max(0, z– 20) ≥ 100,000which can be simplified to:40*min(x, 10) + 15*max(0, x– 10) +20*min(y, 15) + 12*max(0, y– 15) + 10*min(z, 20) + 8*max(0, z– 20) ≥ 1,000• Total budget of $279,00010,000x+ 3,000y+ 1,000z≤ 279,000which can be simplified as:10x + 3y+ z≤ 279

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture