## Question

# 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

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.

## Step by Step Solution

There are 3 Steps involved in it

### Step: 1

To solve this problem we will use linear optimization a Define the decision variables x Time in minu...### Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

### Step: 2

### Step: 3

## Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started