You need help with finding out this equation to help solve this linear programming equation.
Tom is allocated $300,00 to these advertising alternatives in a way to maximize the impact achieved. Tom wants to derive at least 20% of total advertising impact from evening TV adverstisements.
Can you help me come up with an equation that can solve this problem using the information below?
Once I have that equation, I will run the analytic problem solver.
|
|
|
Impact |
Cost |
| Advertising Medium |
Units |
Min |
Max |
Per Unit |
Total |
Per Unit |
Total |
| Half-page, Daily paper |
46.0 |
24 |
48 |
55 |
2,530 |
$800 |
$36,800 |
| Full-page, Daily paper |
2.0 |
2 |
48 |
75 |
150 |
$1,400 |
$2,800 |
| Half-page, Sunday paper |
6.0 |
0 |
8 |
65 |
390 |
$1,200 |
$7,200 |
| Full-page, Sunday paper |
2.0 |
2 |
8 |
80 |
160 |
$1,800 |
$3,600 |
| Daytime TV spot |
29.6 |
28 |
84 |
85 |
2,513 |
$2,500 |
$73,900 |
| Evening TV spot |
28.0 |
28 |
56 |
100 |
2,800 |
$3,500 |
$98,000 |
| Highway Billboards |
10.0 |
3 |
10 |
35 |
350 |
$750 |
$7,500 |
| 15 second Radio spot |
140.0 |
56 |
140 |
45 |
6,300 |
$150 |
$21,000 |
| 30 second Radio spot |
140.0 |
56 |
140 |
55 |
7,700 |
$300 |
$42,000 |
| Half-page, magazine |
9.0 |
0 |
12 |
50 |
450 |
$500 |
$4,500 |
| Full-page, magazine |
3.0 |
3 |
12 |
60 |
180 |
$900 |
$2,700 |
| Key Totals: |
Units |
Min |
Max |
Total: |
23,523 |
Total: |
$300,000 |
| Daily paper ads |
48.0 |
24 |
48 |
|
|
Budget: |
$300,000 |
| Sunday paper ads |
8.0 |
2 |
8 |
|
|
|
|
| Magazine ads |
12.0 |
3 |
12 |
|
|
|