Question: The following questions are based on the problem below. A company wants to advertise on TV and radio. The company wants to produce about 6
The following questions are based on the problem below. A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people, and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet.
| A | B | C | D | E | |
| 1 | Problem Data | TV | Radio | ||
| 2 | Cost | 20 | 10 | ||
| 3 | Coverage | 10 | 7 | ||
| 4 | |||||
| 5 | Goal Constraints | TV | Radio | Cost | Coverage |
| 6 | Actual Amount | 0 | 0 | ||
| 7 | +Under | 0 | 0 | 0 | 0 |
| 8 | Over | 0 | 0 | 0 | 0 |
| 9 | = Goal | 0 | 0 | 0 | 0 |
| 10 | Target Value | 6 | 12 | 200 | 140 |
| 11 | |||||
| 12 | Percentage Deviation: | ||||
| 13 | Under | 1 | 1 | 1 | 1 |
| 14 | Over | 0 | 0 | 0 | 0 |
| 15 | |||||
| 16 | Weights | ||||
| 17 | Under | ||||
| 18 | Over | ||||
| 19 | |||||
| 20 | Objective | 0 |
Refer to Exhibit 7.1. Which of the following is a constraint specified to Analytic Solver Platform for this model?
| |||
| |||
| |||
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
