Anew Italian restaurant called the Olive Grove is opening in several 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.

a. Formulate a GP model for this problem assuming that the marketing manager has the following goals:

Goal 1: Exposures should be maximized.

Goal 2: No more than $120,000 should be spent on advertising.

(You will have to determine an appropriate target value for the first goal.)

Assume that the marketing manager wants to minimize the maximum percentage deviation from either goal.

b. Implement your model in a spreadsheet and solve it.

c. What is the solution you obtain?

d. What changes do you make to your model if the manager wants to spend less on advertising than your solution suggests?