Given yearly advertising budget that averages $130,000 per week, use Goal Seek to calculate how big...

Transcribed Image Text:

Given yearly advertising budget that averages $130,000 per week, use Goal Seek to calculate how big of a discount WDRP needs to ask for to afford to advertise on all 15 of their top 10 shows for 10 weeks of advertising. Put this total in J11. Take a screenshot of the goal seek pop- up window after you've entered your inputs (but before running the goal seek), and paste it into part A. Then run the goal seek and write the result (the required discount) in part B. a. < > b. < > Given yearly advertising budget that averages $130,000 per week, use Goal Seek to calculate how big of a discount WDRP needs to ask for to afford to advertise on all 15 of their top 10 shows for 10 weeks of advertising. Put this total in J11. Take a screenshot of the goal seek pop- up window after you've entered your inputs (but before running the goal seek), and paste it into part A. Then run the goal seek and write the result (the required discount) in part B. a. < > b. < >