Im looking for the solutions for case problem 1 in chapter 4

Im looking for the solutions for case problem 1 in chapter 4 from the text; An introduction to management science 13ed. The question asks me to plan an advertising campaign. I didn\'t see the solution on the website, I\'m specifically looking for the LP models used to answer the questions

Solution

1. A schedule showing the recommended number of television, radio, and newspaper advertisements and the budget allocation for each media. Show the total exposure and indicate the total number of potential new customers reached.

Advertising

Potential

Exposure

$allocated

T.V.

15

47500

1175

150000

Radio

33

51600

735

99000

Newspaper

30

28000

250

30000

Total

127100

2160

279000

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

The exposure rating would rise to 2215

3. A discussion of the ranges for the objective function coefficients. What do the ranges indicate about how sensitive the recommended solution is to HJ\'s exposure rating coefficients?

The ranges should indicate a high degree of sensitivity of the exposure coefficients to the recommended solution
4. After reviewing HJ\'s recommendation, the Flamingo\'s management team asked how the recommendation would change if the objective of the advertising campaign was to maximize the number of potential new customers reached. Develop the media schedule under this objective.

Excel solver has been used to solve the pproblem. if u need excel sheet then let me know.