PLEASE PLEASE HELP ME STEP BY STEP.

$1$

On the Direct Marketing worksheet, create appropriate range names for Design$\_$Fee $($cell B$8),$ Cost$\_$Per$\_$Ad $($cell B$9),$ Total$\_$Clicks $($cell B$10),$ Profit$\_$Per$\_$Click $($B$11),$ and Gross$\_$Profit $($cell B$12).$

Note, the Cost$\_$Per$\_$Ad is charged with each click by a potential customer.

$3$

Edit the existing name range Design$\_$Fee to Design$\_$Fee$2021$ to reflect the current year.

$4$

Use the newly created range names to create a formula to calculate Gross Profit $($cell B$12)$ and Net Profit $($cell B$13).$

$5$

Create a new worksheet named Range Names, paste the newly created range name information in cell A$1,$ and resize the columns as needed for proper display.

Mac users, use the Insert menu to insert a new worksheet and paste the range names.

$6$

On the Direct Marketing worksheet, use Goal Seek to determine the optimal click rate in order to earn a $$5,000$ net profit.

$7$

Starting in cell E$4.$ Complete the series of substitution values ranging from $2\%$ to $6\mathrm{.}5\%$ at increments of $\mathrm{.}50\%$ vertically down column E$.$

$8$

Enter references to the Gross Profit and Net Profit in the correct location for a one$-$variable data table.

$9$

Complete the one$-$variable data table, and then format the results with Accounting Number Format with two decimal places.

$10$

Apply custom number formats to display Gross Profit in cell F$3$ and Net Profit in cell G$3.$

$11$

Copy the response rate substitution values from the one$-$variable data table, and then paste the values starting in cell I$4.$

$12$

Type $10000$ in cell J$3.$ Complete the series of substitution values from $10000$ to $40000$ at $5000$ increments.

$13$

Enter the reference to net profit formula in the correct location for a two$-$variable data table.

$14$

Complete the two$-$variable data table and format the results with Accounting Number Format with two decimal places.

$15$

Apply a custom number format to make the formula reference appear as Net Profit.

$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\mathrm{.}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\mathrm{.}83\%.$

$19$

Generate a scenario summary report using Gross Profit and Net Income.

$20$

Return to the Direct Marketing $2$ worksheet. Load the Solver add$-$in if it is not already loaded. Launch Solver and set the objective to calculate a net profit of $$20,000.$

$21$

Use Number of Ads and Click Rate $($B$4$:B$5)$ as changing variable cells.

$22$

Set a constraint to ensure Number of Ads purchased is less than or equal to $40,000.$

$23$

Set a constraint to ensure Click Rate is less than or equal to $7\%.($Mac users should enter the value in decimal form. Example $\mathrm{.}07)$

$24$

Solve the problem. Generate the Answer Report.

$25$

Create a footer on all worksheets with your name on the left side, the sheet name code in the center, and the file name code on the right side.