Advertising 1 Finished_A

Advertising 1 Finished_A - A 1 2 3 4 5 B C D E F G H I...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Advertising model Inputs Exposures to various groups per ad Desperate Housewives MNF Malcolm in Middle Sports Center The Real World Lifetime movie CNN Men 18-35 5 6 5 0.5 0.7 0.1 0.1 3 Men 36-55 3 5 2 0.5 0.2 0.1 0.2 5 Men >55 1 3 0 0.3 0 0 0.3 4 Women 18-35 6 1 4 0.1 0.9 0.6 0.1 3 Women 36-55 4 1 2 0.1 0.1 1.3 0.2 5 Women >55 2 1 0 0 0 0.4 0.3 4 Total viewers 21 17 13 1.5 1.9 2.5 1.2 24 Cost per ad 140 100 80 9 13 15 8 140 Cost per million exposures 6.667 5.882 6.154 6.000 6.842 6.000 6.667 5.833 Advertising plan Desperate Housewives MNF Malcolm in Middle Sports Center The Real World Lifetime movie CNN Number ads purchased 0.000 0.000 8.719 20.625 0.000 6.875 0.000 6.313 Constraints on numbers of exposures Range names used: Actual exposures Required exposures Actual_exposures =Model!$B$23:$B$28 Men 18-35 73.531 >= 60 Number_ads_purchased =Model!$B$19:$I$19 Men 36-55 60.000 >= 60 Required_exposures =Model!$D$23:$D$28 Men >55 31.438 >= 28 Total_cost =Model!$B$31 Women 18-35 60.000
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/24/2010 for the course ACCT 302 taught by Professor Staff during the Spring '08 term at Old Dominion.

Page1 / 3

Advertising 1 Finished_A - A 1 2 3 4 5 B C D E F G H I...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online