DEAR CHEGG SOLVER, ONLY USE THE EXCEL TEMPLATE PROVIDED. THERE ARE $10$ TOTAL CONSTRAINTS. PLEASE ADD THE SOLVER SOLUTION SCREENSHOTS. ANSWER A$-$F AS WELL FOR A THUMBS UP$.$ THANK YOU.

Use the case study problem given on the next page $($or see page $204$ of textbook$)$ to answer the following questions:

a$.$ Formulate a linear programming model $($identify and define decision variables, objective function and

constraints$)$ that can be used to determine the advertising budget allocation for the Flamingo Grill in order

to maximize the total exposure rating. $(20$ points$)$

b$.$ Use Solver in Microsoft Excel to solve the model that you developed in part $($a$).$ Give the values of each

decision variable and the objective function. Also indicate the total number of new customers reached. You

MUST attach a copy of the solution report. $(10$ points$)$

c$.$ How would the total exposure change if an additional $$10,000$ were added to the advertising budget?

Explain. $(5$ points$)$

d$.$ Comment on the ranges for the objective function coefficients. What do the ranges indicate about how

sensitive the recommended solution is to HJ$\text{'}$s exposure rating coefficients? Explain. $(5$ points$)$

e$.$ After reviewing HJ$\text{'}$s recommendation, the Flamingo's management team asked how the optimal solution

would change if the objective of the advertising campaign was to maximize the number of potential new

customers reached. Use Solver in Microsoft Excel to solve this new model that you developed in part $($e$).$

Give the values of each decision variable and the objective function. Also indicate the total exposure

rating. You MUST attach a copy of the solution report. $(5$ points$)$

f$.$ Compare the optimal solutions from part $($b$)$ and part $($e$).$ Which objective function is a better indicator of

advertising effectiveness? Please comment $(5$ points$)$