To keep up$-$to$-$date with security updates, fixes, and improvements, ch$...$

Check for U

Use an appro iate function to calculate "Total Cost to Advertise $($no discount$)"$ for all $19$ prograis in cell H$24.($Hjint: first calculate "Cost to Advertise" for each program based on "Cost to advertise per Thousand Vieweis"$)$

Use an apprioniate function to calculate the "Total Cost to Advertise $($with discount$)"$ in cell H$26($Hin o our formula should r$$fe ence the discount given in cell J$7)$

Assuming the carly Advertising Budget averages $$140,000$ per week, and that this campaign needs advertisements to run for $9$ weeks, calculate the Total Budget for the Advertisement in cell J$11.$

The following cells should have formulas $-$ H$4$:H$22,$ cell H$24,$ 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 the Total Cost to Advertise, both without a discount and with a discount.

$(4)$ Now that you have calculated the total budget in cell J$11,$ you will use Goal Seek to calculate how big of a discount is needed for WDRP to afford to advertise on all $19$ of the top $10$ shows for $9$ weeks nf advertising

Current Document $1$e goal seek pop$-$up window after you've entered your inputs $($but before running the goal $($gek$),$ and paste it into Part B$.$

Part B should have a scre$$nshot of the Goal Seek Dialogue Box, filled out:

$(5)$ Run the goal seek and write the result $($the required discount$)$ in Part C$.$