DO IT THE SAME EXACT WAY IT'S IN THE PICTURE DO NOT COPY OTHER CHEGG ANSWERS MAKE SURE FORMULAS THAT ARE BEING USED ARE SHOWN AND CLEAR PLEASE !!!!!!!!

1. A new Italian restaurant called the Olive Grove is opening in a number of locations in the Memphis area. The marketing manager for these stores has a budget of $150,000 to use in advertising and promotions for the new stores. The manager can run magazine ads at a cost of $2,000 each that result in 250,000 exposures each. TV ads result in approximately 1,200,000 exposures each, but cost $12,000 each. The manager wants to run at least five TV ads and ten magazine ads, while maximizing the number of exposures generated by the advertising campaign. But the manager also wants to spend no more than $120,000 on magazine and TV advertising so that the remaining $30,000 could be used for other promotional purposes. However, the manager would spend more than $120,000 on advertising if it resulted in a substantial increase in advertising coverage.
   1. Formulate a GP model for this problem assuming the marketing manager has the following goals:
      1. Goal 1: Exposures should be maximized.
      2. Goal 2: No more than $120,000 should be spent on advertising.
   2. Implement your model in a spreadsheet and solve it.
   3. What is the solution you obtain?
   4. What changes do you make to your model if the manager wants to spend less on advertising than your solution suggests?

B5 1 X X fx o B D The Olive Grove A 1 2 3 4. Problem Data: 5 Number 6 Exposures (in 1000s) 7 Cost 8 Min 9 10 Goal Constraints: 11 Actual 12 + Under 13 - Over 14 = Goal 15 Target Magazine 0 250 $2,000 10 TV 0 1,200 $12,000 5 Exposures Cost $0 $0 0 17,250 $120,000 16 17 Percentage Deviation: 18 Under 19 Over 20 21 Objective: 0.00% Solver Parameters Set Objective: $B$21 To: Max Min Value Of: 0 By Changing Variable Cells: $B$5:$C$5,$B$12:$C$13,$B$21 Add Subject to the Constraints: $B$12:$C$13 >= 0 $B$ 14:$C$14 = $B$15:$C$15 $B$18:$C$19 = $B$8:$C$8 Change = Delete Reset All Load/Save Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP Options Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non- smooth. Close Solve