Question: ( 4 ) Now that you have calculated the total budget in cell J 1 1 , you can use Goal Seek to calculate how

(4) Now that you have calculated the total budget in cell J11, you can 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 of advertising.
(5) NOTE: 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 B.
(6) Run the goal seek and write the result (the required discount) in part C. Part B should have a screenshot of the Goal Seek Dialogue Box, filled out:
\table[[Goal Seek,?,x
 (4) Now that you have calculated the total budget in cell

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!