13) A university team wants to do to increasing attendance at their home games.

Question

13) A university team wants to do to increasing attendance at their home games. There are different options the administration is considering Yard signs $25, Social Media ads $5, Radio spots $150, Newspaper ads $20, Posters $3, Club sport partnerships 320u, and Free food $400. The expected audience reached by each of the marketing and promotion options is signs 200, Social Media ads 1000, Radio spots 3000, Newspaper ads 800, Posters 200, Club sport partnershups 50, Free food 150. The budget for each weekly game is $800. Print advertising (yard signs, newspaper, and posters) should not exceed 40% of the total budget Non-print advertising should make up at least 70%of marketing/promotion activities. A maximum of seven Social Media ads should be done in a week; F can only be offered once at the game; and only one Club sport partnership can be made per game. Let Y-Yard signs some marketing/promotions to increase their audience exposure in hopes of ard S Social Media ads R- Radio spots N-Newspaper P Posters C-Club partnerships F- Free food ads (a) what is the objective function? (5 pts) b) Complete the fllowing excel preadshet as f you wer using sover, In boes that need formalas, be sure to write the formula: (15 pts) 5 Constraints 320 non. 'Sec, media 11 club 12 13 14 15 16 17 18 19 20 21 13

Explanation / Answer

Y – Yard signs

S – Social Media ads

R – Radio spots

N – Newspaper ads

P – Posters

C – Club Partnership

F – Free food

Objective Function(Z):

Is to maximize total expected audience reach

Z = 200Y + 1000S + 3000R + 800N + 200P + 50C + 150F

Total Budget = $800

25Y + 5S + 150R + 20N + 3P + 200C + 400F   =< 800

25Y + 20N + 3P   =< $320 (40% of $800)

Non-print Advertising should be at least 70% of the promotional/ marketing activites

S + R + C + F >= 70% of (Y + S + R+ N + P + C +F)

So,

S + R + C + F >= 0.7Y + 0.7S + 0.7R+ 0.7N + 0.7P + 0.7C + 0.7F

So,

-0.7Y + 0.3S + 0.3R - 0.7N - 0.7P + 0.3C + 0.3F >= 0

So that’s why the non-print advertising in the table represents the negative number.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.