Question: ( 4 ) Now that you have calculated the total budget in cell J 1 1 , you can use Goal Seek to calculate how
Now that you have calculated the total budget in cell J you can use Goal Seek to calculate how big of a discount is needed for WDRP to afford to advertise on all of the top shows for weeks of advertising.
NOTE: Take a screenshot of the goal seek popup window after you've entered your inputs but before running the goal seek and paste it into part
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:
tableGoal Seek,?,
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
