Monday Night Football, Dancing with the Stars, Primetime Emmy Awards

Koal Seek

$(3)$ Prepare to run a goal seek by following these directions:

Remove any Week filters so you have all programming listed from $\frac{1}{22}\frac{?}{2018}\frac{7}{24}\frac{?}{2023}.$

Make sure only ABC shows are selected.

Copy the $19$ rows of ABC shows and paste them into the "Goal Seek" worksheet starting in cell B$4.$

Use an appropriate function to calculate the "Cost to Advertise" for each show in cells H$4$:H$22$ using the given "Cost to advertise per Thousand Viewers"

Use an appropriate fuiction to calculate the "Total Cost to Advertise $($no discount$)"$ for all nineteen shows in cell H$24.($Hint: first calculate the "Cost to Advertise" for each show based on "Cost to advertise per Thousand Viewers"$)$

Use an appropriate function to calculate the "Total Cost to Advertise $($with discount$)"$ in cell H$26($Hint: Your formula should reference the discount given in cell J$7)$

Given yearly advertising budget that averages $$140,000$ per week, and you need ads to run for $9$ weeks, calculate the total budget for the ad buy in cell J$11.$

Up to this point you should have put a formula in cells $H4$:$H22,$ cell $H24,$ cell H$26,$ cell J$11.$

Take a screenshot of the table F$3$:H$26$ and paste it into A below. This lets us see what your total Cost to Advertise is Without a discount and with a discount, but before the goal seek is run.