The television budget should be at least 140000 the

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

Use no more than 20 television advertisements.The television budget should be at least $140,000.The radio advertising budget is restricted to a maximum of $99,000.The newspaper budget is to be at least $30,000.HJ 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 newspaper advertising. Managerial ReportDecision Variables:T1=# of TV Advertisement w/ rating of 90 & 4000 new customersT2=# of TV Advertisements w/ rating of 40 & 1500 new customersR1=# of Radio Advertisements w/ rating of 25 & 2000 new customersR2=# of Radio Advertisements w/ rating of 15 & 1200 new customersN1=# of Newspaper Advertisements w/ rating of 10 & 1000 new customersN2=# of Newspaper advertisements w/ rating of 5 & 800 new customers
Group 352Objective Function:Max=90T1 + 55T2 + 25R1 + 20R2 + 10N1 + 5N2S.T:Develop a model that can be used to determine the advertising budget allocation for the Flamingo Grill. Include a discussion of the following in your report.1.A schedule showing the recommended number of television, radio, and newspaper advertisements and the budget allocation for each media. Show the total exposure and indicate the total number of potential new customers reached.Please see the attached excel file, sheet for detailed setup and solution.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture