Answered step by step
Verified Expert Solution
Question
1 Approved Answer
To keep up - to - date with security updates, fixes, and improvements, ch . . . Check for U Use an appro iate function
To keep uptodate 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 prograis in cell HHjint: 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 HHin o our formula should rfe ence the discount given in cell J
Assuming the carly Advertising Budget averages $ per week, and that this campaign needs advertisements to run for weeks, calculate the Total Budget for the Advertisement in cell J
The following cells should have formulas H:H cell H cell H cell J
Take a screenshot of the table F:H and paste it into A below. This lets us see the Total Cost to Advertise, both without a discount and with a discount.
Now that you have calculated the total budget in cell J you will 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 nf advertising
Current Document e goal seek popup window after you've entered your inputs but before running the goal gek and paste it into Part B
Part B should have a screnshot of the Goal Seek Dialogue Box, filled out:
Run the goal seek and write the result the required discount in Part C
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started