Question: help please! 16 Make the Direct Marketing 2 worksheet active. Create a scenario named Best Case, using Number of Ads and Click Rate. Enter these


16 Make the Direct Marketing 2 worksheet active. Create a scenario named Best Case, using Number of Ads and Click Rate. Enter these values for the scenario: 40000 , and 6.5%. 17 Create a second scenario named Worst Case, using the same changing cells. Enter these values for the scenario: 10000 , and 1%. 18 Create a third scenario named Most Likely, using the same changing cells. Enter these values for the scenario: 10000 , and 6.83%. \begin{tabular}{|c|l|} \hline 19 & Generate a scenario summary report using Gross Profit and Net Income. \\ \hline 20 & ReturntotheDirectMarketing2worksheet.LoadtheSolveradd-inifitisnotalreadyloaded.LaunchSolverandsettheobjectivetocalculateanetprofitof$20,000. \\ \hline 21 & Use Number of Ads and Click Rate (B4:B5) as changing variable cells. \\ \hline 22 & Set a constraint to ensure Number of Ads purchased is less than or equal to 40,000. \\ \hline 23 & SetaconstrainttoensureClickRateislessthanorequalto7%.(Macusersshouldenterthevalueindecimalform.Example.07) \\ \hline 24 & Solve the problem. Generate the Answer Report. \end{tabular} Direct Marketing 16 Make the Direct Marketing 2 worksheet active. Create a scenario named Best Case, using Number of Ads and Click Rate. Enter these values for the scenario: 40000 , and 6.5%. 17 Create a second scenario named Worst Case, using the same changing cells. Enter these values for the scenario: 10000 , and 1%. 18 Create a third scenario named Most Likely, using the same changing cells. Enter these values for the scenario: 10000 , and 6.83%. \begin{tabular}{|c|l|} \hline 19 & Generate a scenario summary report using Gross Profit and Net Income. \\ \hline 20 & ReturntotheDirectMarketing2worksheet.LoadtheSolveradd-inifitisnotalreadyloaded.LaunchSolverandsettheobjectivetocalculateanetprofitof$20,000. \\ \hline 21 & Use Number of Ads and Click Rate (B4:B5) as changing variable cells. \\ \hline 22 & Set a constraint to ensure Number of Ads purchased is less than or equal to 40,000. \\ \hline 23 & SetaconstrainttoensureClickRateislessthanorequalto7%.(Macusersshouldenterthevalueindecimalform.Example.07) \\ \hline 24 & Solve the problem. Generate the Answer Report. \end{tabular} Direct Marketing
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
