I need a step by step of how to do this part on excel like what buttons to click BE SPECIFIC

19 4 20 4 21 4 Generate a scenario summary report using Gross Profit and Net Income. 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. Use Number of Ads and click Rate (B4:B5) as changing variable cells. Set a constraint to ensure Number of Ads purchased is less than or equal to 40,000. Set a constraint to ensure Click Rate is less than or equal to 7%. (Mac users should enter the value in decimal form. Example.07) Solve the problem. Generate the Answer Report. 22 2 23 N 24 3 K16 fx A B C D D E F G H I J K L M M N O P Q 1 Direct Marketing 2.00% 2.50% 3.00% Net Profit 2.00% 2.50% 3.00% 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% Gross Profit $7,666 $9,582 $11,498 $13,415 $15,331 $17,247 $19,164 $ $21,080 $22,997 $24,913 Net Profit $4,286 $5,857 $7,429 $9,000 $10,571 $12,143 $13,714 $15,286 $16,857 $18,429 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% 10000 15000 20000 25000 30000 35000 40000 $ 50.00 $1,075.00 $ 2,100.00 $ 3,125.00 $ 4,150.00 $ 5,175.00 $ 6,200.00 $ $ 562.50 $1,843.75 $ 3,125.00 $ 4,406.25 $ 5,687.50 $ 6,968.75 $ 8,250.00 $ 1,075.00 $ 2,612.50 $ 4,150.00 $ 5,687.50 $ 7,225.00 $ 8,762.50 $ 10,300.00 $1,587.50 $3,381.25 $ 5,175.00 $ 6,968.75 $ 8,762.50 $ 10,556.25 $ 12,350.00 $ 2,100.00 $ 4,150.00 $ 6,200.00 $ 8,250.00 $ 10,300.00 $ 12,350.00 $ 14,400.00 $ 2,612.50 $ 4,918.75 $ 7,225.00 $ 9,531.25 $ 11,837.50 $ 14,143.75 $ 16,450.00 $ $ 3,125.00 $5,687.50 $ 8,250.00 $ 10,812.50 $ 13,375.00 $ 15,937.50 $ 18,500.00 $3,637.50 $6,456.25 $ 9,275.00 $ 12,093.75 $ 14,912.50 $ 17,731.25 $ 20,550.00 $ 4,150.00 $ 7,225.00 $ 10,300.00 $ 13,375.00 $ 16,450.00 $ 19,525.00 $ 22,600.00 $ 4,662.50 $ 7,993.75 $ 11,325.00 $ 14,656.25 $ 17,987.50 $ 21,318.75 $ 24,650.00 2 3 Inputs 4 Number of 10000 5 Click Rate 5.00% 6 7 Parameters 8 Design Fee $ 2,000.00 9 Cost Per Ad $ 2.25 10 Total Clicks 500 11 Profit Per C $ 12.50 12 Gross Profi $ 6,250.00 13 Net Profit $ 3,125.00 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Direct Marketing Direct Marketing 2 Range Names + x fx K20 Name Box B E F G I J K L M N 0 0 P 0 1 Direct Marketing 1000 10000 6.83% 2.0% 2.5% 3.0% % $ $ $ $ S $5,000 2.0% 2.5% 3.0% 3.5% 3.5% Gross Profit Net Profit 2,500.00 $ 50.00 3,125.00 $ 562.50 3,750.00 $ 1,075.00 4,375.00 $ 1,587.50 5,000.00 $ 2,100.00 5,625.00 $ 2,612.50 6,250.00 $ 3,125.00 6,875.00 $ 3,637.50 7,500.00 $ 4,150.00 8,125.00 $ 4,662.50 $ 2,000.00 $ 2.25 682.9268293 $ 12.50 $ $ 8,536.59 $ 5,000.00 $ $ $ s $ s $ $ $ ($1,795 JU ($1,744 ($1,693) . ($1,641) ($1,590) ($1,539) ($1,488) ($1,436) ($1,385) ($1,334) 4.0% 4.5% 5.0% 5.5% 6.0% 6.5% 1500 ($1,693) ($1,616) ($1,539) . ($1,462) ($1,385) ($1,308) ($1,231) ($1,154) ($1,078) ($1,001) 4.0% 4.5% 5.0% 5.5% 6.0% 6.5% % 2000 ($1,590) ($1,488) ($1,385) ($1,283) ($1,180) ($1,078) ($975) ($873) ($770) ($668) 2500 ($1,488) ($1,359) $ ($1,231) ($1,103) ($975) ($847) ($719) ($591) ($463) ($334) 4000 ($1,180) ($975) ($770) ($565) ($360) ($155) $50 $255 $460 $665 3000 ($1,385) ($1,231) ($1,078) . ($924) () ($770) ($616) ($463) ($309) ($155) ($1) 3500 ($1,283) ($1,103) ($924) ($744) ($565) ($386) ($206) ($27) $153 $332 2 3 Inputs 4 Number of Ads 5 Click Rate 6 7 Parameters 8 Design Fee 9 Cost Per Ad 10 Total Clicks 11 Profit Per Click 12 Gross Profit 13 Net Profit 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Direct Marketing Direct Marketing 2 Range Names +