Using the data below, you worked with Grazyna to calculate the revenue per ad dollar of the three TV campaigns being broadcast to Sacramento viewers during various programs. Television Campaign: Local News Program Number of Spots: 5 Rate (Ad Cost per Spot): $80,000 Target Market (Sacramento, CA): 466,488 Rating (Obtained from Nielsen Data): 3.8 Revenue per Impression (Obtained from Company Data): $65 Television Campaign: Local Sitcom Number of Spots: 8 Rate: $35,000 Target Market: 466,488 Rating (Obtained from Nielsen Data): 2.5 Revenue per Impression: $45 Television Campaign: Local Talk Show Number of Spots: 10 Rate: $15,000 Target Market: 466,488 Rating (Obtained from Nielsen Data): 1.6 Revenue per Impression: $25 ABCD 1 2 3 4 5 6 7 8 9 10 11 Component News Program Sitcom Talk Show Frequency (No. of Spots) Rate Media Cost (Frequency x Rate) $0 $0 $0 Target Market Rating Reach (Target Market x Rating) / 100 0 0 0 Impressions (Reach x Frequency) 0 0 0 Revenue Per Impression Total Revenue (Impressions x Revenue per Impression) $0 $0 $0 Revenue per Ad Dollar (Total Revenue / Media Cost) NaN NaN NaN