Business, 26.02.2020 03:59 rodres17

A brand manager for ColPal Products must determine how much time to allocate between radio and television advertising during the next month. Market research has provided estimates of the audience exposure for each minute of advertising in each medium, which it would like to maximize. Costs per minute of advertising are also known, and the manager has a limited budget of $25,000. The manager has decided that because television ads have been found to be much more effective than radio ads, at least 70% of the time should be allocated to television. Suppose that we have the following data:

Components Required/unit
Radio TV
Exposure/Minute 350 800
Cost/Minute 400 2000
Minimum allocation - 0.7

a. identify the decision variables
b. Mathematically formulate a linear optimization model
c. Solve the model using Excel solver
d. Get sensitivity report

e. Answer the following questions:

1. Suppose that the exposure for TV advertising was incorrectly estimated and should have been 875. How would the optimal solution have been affected?
2. Radio listening has gone down, and new marketing studies have found that the exposure has dropped to 150. How will this affect the optimal solution?
3. The marketing manager has increased the budget by $2,000. How will this affect the solution and total exposure?

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 13:50

Ateam of engineers has decided to design a new shoe for people suffering from a painful foot condition. what should the engineers do during the planning stage of their project? a. look at the trial's results to see how the design can be improved. b. build a variety of shoe models. c. have patients wear the new shoe in an experimental trial to see if symptoms improve. d. estimate how much potential consumers would be willing to pay for this new shoe.

Answers: 1

Answer

Business, 21.06.2019 21:00

Which of the following is a reason why it is important for students to study strategy and the strategic management process? answers: studying strategy and the strategic management process can give students tools to evaluate the strategies of firms that may employ them.it can be very important to a new hire's career success to understand the strategies of the firm that hired them and their place in implementing these strategies.while strategic choices are generally limited to very experienced senior managers in large organizations, in smaller and entrepreneurial firms many employees end up being involved in the strategic management process.all of these.

Answers: 3

Answer

Business, 22.06.2019 16:50

In terms of the "great wheel of science", statistics are central to the research process (a) only between the hypothesis phase and the observation phase (b) only between the observation phase and the empirical generalization phase (c) only between the theory phase and the hypothesis phase (d) only between the empirical generalization phase and the theory phase

Answers: 1

Answer

Business, 22.06.2019 23:00

Abeverage company puts game pieces under the caps of its drinks and claims that one in six game pieces wins a prize. the official rules of the contest state that the odds of winning a prize are is the claim "one in six game pieces wins a prize" correct? why or why not? 1: 6.

Answers: 1

Answer

You know the right answer?

A brand manager for ColPal Products must determine how much time to allocate between radio and telev...

Questions