An ad campaign for a new snack chip will be conducted in a limited geographical area and can use TV time, radio time, and newspaper

ads. Information about each medium is shown below.

Consider the following limitations: $(1)$ the advertising budget is $$20,000,$ and $(2)$ they must achieve an exposure quality of at least

$1000,(3)$ the number of TV ads cannot exceed the number of radio ads by more than $4.$

Develop and solve an LP model to determine the number of ads in each medium in order to maximize the total number reached.

Hint: to avoid errors and confusions, first write down the algebraic formulation on paper before solving the model in Excel.

$($a$)$ What is the optimal solution?

Optimal number of TV ads is

Optimal number of Radio ads is

Optimal number of Newspaper ads is

$($b$)$ The maximum total number reached is

$($c$)$How much do they have to pay for the optimal number of TV ads?