Question

# The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising...

(a) Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure. If the constant is "1" it must be entered in the box. If your answer is zero enter “0”.
 Max N + R s.t. N + R = Budget N + R ≥ Newspaper min N + R ≥ Radio min N + R ≥ R Allocation min. ratio.
(b) Develop a spreadsheet model and solve the problem using Excel Solver. If required, round your answer to two decimal places.
 Newspaper Radio Dollars Allocated \$ \$
Total Exposure Index

Given that,

a)  first we build the total exposure formula in the excel cell as seen in the figure above.

Next, we set up the excel solver where we provide the objective function and choose to maximize it

then, we provide the constraints as shown in the solver

choosing non-negative option as the variables are positive and the simplex method to solve, we get the following solution #### Earn Coins

Coins can be redeemed for fabulous gifts.