There are $10,000$ potential customers for the product sold by companies $1$ through $10.$ Table $1$ provides information about the number of potential customers exposed to an advertising message presented in each of five specific venues. For each venue, the overall number of people exposed to the message is shown. Additionally, the audience is broken down by age, gender, and income. Remember, there are $10,000$ people overall; each of these people falls into exactly one age, gender, and income category. That is$,$ of those $10,000$ people, $5,000$ are $<30$ years old and $5,000$ are $>30$ years old, $5,000$ are women and $5,000$ are men, and $5,000$ make $<50$K and $5,000$ make more than $50$K$.$ The number of impressions in each venue overall and by groups is in Table $1.$

Table $1$: Viewing Audience $($same information included on Week $5-$ Week $10$ spreadsheet$)$

Table $1$: Viewing Audience

Impressions $($#$)$

Overall

Age

Gender

Income

$<30$

$>30$

Women

Men

$<50$K

$>50$K

Venue$1$

$2000$

$1000$

$1000$

$1000$

$1000$

$1000$

$1000$

Venue$2$

$500$

$400$

$100$

$450$

$50$

$350$

$150$

Venue$3$

$1000$

$800$

$200$

$450$

$550$

$650$

$350$

Venue$4$

$3500$

$500$

$3000$

$1500$

$2000$

$1000$

$2500$

Venue$5$

$1500$

$750$

$750$

$250$

$1250$

$500$

$1500$

Total Population

$10000$

$5000$

$5000$

$5000$

$5000$

$5000$

$5000$

Table $2$: Gross Ratings Points

Assume that each person can only receive one impression from one venue. For each venue, find the GRP overall and within each subgroup $($remember$,$ GRP is presented as a whole number and not a percentage$).$ Fill in Table $2$ with the GRP for each venue overall and within each subgroup:

$($a$)$ Overall GRP $[$number of all people exposed to a venue$/$total population $(10,000)]$

$($b$)$ GRP by age $(<30$ and $>30)[$number of all people exposed to a venue $(<30$ and $>30)/$total people in each age group $(5000)]$

$($c$)$ GRP by gender $($men and women$)[$number of all people exposed to a venue $($men and women$)/$total people in each gender group $(5000)]$

$($d$)$ GRP by income $(<50$K and $>50$K$)[$number of all people exposed to a venue $(<50$K and $>50$K$)/$total people in each income group $(5000)]$

Table $3$: Cost Per Point

The cost of running an ad in each of the five venues is presented in Table $3.$ Based on this information and your GRP findings in Table $2,$ calculate the cost per point for each venue overall and by subgroup. Fill in Table $3$ with the following metrics:

$($a$)$ Overall cost per point $($cost of the ad$/$GRP overall$)$

$($b$)$ Cost per point by age group $($cost of the ad$/$GRP for each age group$)$

$($c$)$ Cost per point by gender $($cost of the ad$/$GRP for each gender$)$

$($d$)$ Cost per point by Income $($cost of the ad$/$GRP for each Income Group$)$