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

help please!
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 values for the scenario: 40000 , and 6.5%. 17 Create a

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

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 General Management Questions!