A marketing company needs to decide how much time to allocate between radio and television advertising during the next month. The manager has determined that

Question

36 users unlocked this solution today!

A marketing company needs to decide how much time to allocate between radio and television advertising during the next month. The manager has determined that at least 80% of the time should be allocated to TV. Each minute of Ad on Radio costs $400, and provide 300 units of exposure. Each minute of Ad on TV costs $1500, and provide 800 units of exposure. How much time should the manager allocate between radio and television advertising to achieve 35,000 units of exposure at the minimum cost?

a) Very clearly define appropriate decision variables. x: y:

b) Define the objective function. List the function. Do we want to maximize or minimize?

c) Formulate all needed constraints (including non-negativity).

d) Implement the linear optimization model in Excel and use Solver to find an optimal solution.