Can you please do this on excel, I will like the response: Kentwood electronics is interested in marketing its business in the Chicagoland area.

It is considering three alternatives: TV$,$ radio, and internet.

Kentwood electronics has estimated the number of audience reached per ad$,$ the cost per ad$,$

and the maximum number of ads allowed. This information is reported in the following table:

Component Television Radio Internet

Audience Reached per Ad $100,00018,00040,000$

Cost Per Ad $$2000$ $$300$ $$600$

Maximum Usage Count $102010$

Your goal is to determine the number of each type of media to use such that the number of

audience reached is maximized. You have to ensure that your solutions adhere to the following

constraints:

$$ The number of each type of media used should not exceed the maximum usage count;

$$ Total cost of ads should be less than the available budget of $$18,000.$

$$ To balance the use of advertising types, television usage must not exceed $50\%$ of the

total number authorized, and the internet ads should account for at least $10\%.$

Please answer the following questions:

$1.$ Write down a formulation for this optimization problem. Please define and explain the

objective function, decision variables, and the constraints in your formulation.

$2.$ Set up the optimization problem in Excel and solve the problem.

$3.$ Report the optimal solution and the optimal value $($optimal audience reached$)$ obtained.

$4.$ Rerun your model to answer the following questions: By how much does the optimal

value change if

a$.$ the budget is increased by $5\%?$

b$.$ the audience reached per Ad for internet increases by $2\%?$

c$.$ the maximum usage count of television reduces by $10\%?$