Answer Questions 2-5, and 6 for an upvote

All screenshots of excel are included

Need Answers for the Q&A Questions 1-6

fx What click response rate is required for a gross profit of over $7,000? B D 1 Your Answers Question 1) If10,000 ads are purchased, what is the optimal click response rate Optimal click response rate=4% opti 2 to earn a $5,000 net profit? 2) What click response rate is required for a gross profit of over 3 $7,000? 3) For the two-variable data table, if 20,000 ads are purchased, what is the required response rateto net $5000? 4) For the two-variable data table, if the ads purchased is raised to 40,000, what is the required response rate to net $10000? 4 5 6 $B$12 is 32500 and $B$13 is 24650 5) What is the Net Profit based on the best case scenario? 6) What is the optimal number of ads to purchase and response rate to 7 reach the $20,000 goal? 8 9 10 11 12 13 14 15 16 17 18 50 von 0 G 1 Marketing $ 20,000.00 Click to 2.0 3 4 S 20 $ 30662.02787 7.00 2.5 5 NOE 6 NOTE WSE Gros Prot het Pott 7,665 51 428572 9.5813 5.857.14 11,49826 7.42857 13.41464 9.000.00 15,331 01 10,571.43 17.247.39 12.142.86 19.163.77 11,71 21,080.16 15.285.72 22.99652 1685715 24.51790 18.47.58 4.ON 10000 15000 20000 35000 30000 35000 10000 50.00 $ 1.075.00 5 2.100.00 $ 3.125 00 5 4,150.00 55.175.00 S 5.200.00 556250 S 1.841.755 3.125.00 $ 4.406255 5.687.50 $ 6,96875 S 350.00 $3,075.00 $ 2.612.50 $ 4,150.00 $ 5687.505 7.225.00 $ 3.762.50 $ 10.000 DO $ 1.587.50 S18125 $ 3.175.00 S 468.75 8.752.50 $ 10,55625 $ 12,350.00 5.2.100.00 4.150,00 6,200.00 $ 3.750.00 $ 10 300.00 $ 12.150.00.5 14.400.00 52.612.50 5 491875 5 7 225.00 5 9.53125 $ 11,81750 5 14 14.5 16450.00 5 3,125.00 5568750 $5.250.00 510.812.505 11,175.00 5 15,937.50 1.500.00 53617.50.5645625 $9.275.00 51200175 $ 14,912.50 $ 17,73135 5 20,550.00 $4150.00 57.27500 510 100.00 512 275.00 16.450.00 5 19.525.005 72.600.00 54.467.50 $ 7,993 755 11 325.00 14.65625 17.037.50 $ 21,1155 14,650.00 5 NS 5. 4 ON 45 SON 55% 60% 55 OS ET 5 2,000.00 225 102346 341951 115 12 $76.229.23 11 5 20,000.00 16 15 16 NSS 603 SS 13 19 10 TE IE TE 25 ST 27 21 20 DE 12 31 NE Query Picture AN Edit Links Stock Currencies Geography Automatis Set Fiter Advanced Testiu Count G9 C 0 E G H 1 M A 1 Cost Pe Ad Direct Marketing$$9 2 Design Fee2021 Direct Marketing $$8 Gross Profit Direct Marketing I$8512 4 Profit Der Click Direct Marketing $$11 5 Total Clicks Direct Marketin'50510 6 7 9 10 13 12 13 14 15 10 11 10 1 20 21 23 24 25 76 27 10 10 10 35 H H NOS'S NEWS Scenario Summary Current Values Best Case Worst Case Most hely Changing Cell SRS4 10000 40000 10000 10000 5055 5.00% 1.00 Result Cells $1$12 $ 8,536.59 532,500.00 5 1,250.00 $ 8,537.50 SD$13 $ 5.000.00 $ 24,650.00 5975.00) 55,000.75 Notes Current Values column represents values of charging cells time Scenario Summary Report was created Changing cells for each scenario are highlighted in a he Insert Draw Page Layout Formulas Data Review VI E Queries & Connections Properties Data (Power Query) Data from Picture Refresh AN Stocks Edit Links XV fx Microsoft Excel 16.58 Answer Report A B D E G Microsoft Excel 16.58 Answer Report Worksheet: [e06ci Direct Marketing_BesicAdisadsx]Direct Marketing Report Created: 3/5/22 11:28:26 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine GRG Nonlinear Solution Time: 7497.039 Seconds Iterations: 3 Subproblems:0 Solver Options b Max Time Unlimited, iterations Unlimited, Precision 0.000001, Use Automatic Scaling 1 Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds 2 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Asume NonNegative 13 14 Objective Cell Value on 15 Cell Name Original Value Final Value 16 $B$13 Net Profit $ 5,000.00 $ 20,000.01 17 18 19 Variable Cells 20 Cell Name Original Value Final Value Integer 21 SBS4 Number of Ads 1000030662.02787 Costa 22 $B$5 Click Rate 6.83% 7.00% Contin 23 24 25 Constraints Cell Status Slack Formula 26 Cell Value Name 27 SBS13 Net Profit $ 20,000.01 SBS 13=20000 Binding 28 SBS4 Number of Ads 30662.02787 585440000 Not Binding 9337.972125 Binding 29 SBSS 7.00% SS50.07 Click Rate 30 Window Help e06c1Direct Excel File Edit Viewert Format Tools AutoSave 22 24 Home Insert Draw Page Layout Formulas Data X Calibri (Body) 11 Paste BTU A- Review View Tell me Il lol Wrap Text Merge & Cente D 2 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you x fe A E 1 Your Answers Question 1) 10,000 ads are purchased, what is the optimal click responserate Optimal click response rate=4% opti to earn a $5,000 net profit? 2) What click response rate is required for a gross profit of over $7,000? 3) For the two variable datatable, if 20,000 ads are purchased, what is the required response rateto net $5000? 4) For the two-variable data table, if the ads purchased is raised to 40,000, what is the required response rate to net $10000? 5 5 SR$12 is 32500 and $B$13 is 24650 5) What is the Net Profit based on the best case scenario? 6) What is the optimal number of ads to purchase and response rate to reach the $20,000 goal? 10 12 14 15 16 17 10 20 21 22 22 24 25 26 27 20 Direct Marketing Range Names Scenario Summary Answer Report QAA Data Review Formulas View Tell Insert Home Draw Page Layout Wri ID Calibri (Body) Paste BIU Me CA Open recovered workbooks? Your recent changes were saved. Do you want to continue working A1 XVfx Microsoft Excel 16.58 Answer Report 4 F D E G B H 1 Microsoft Excel 16.58 Answer Report 2 Worksheet: [e06ci Direct Marketing_BesicAdis.xlsx]Direct Marketing 3 Report Created: 3/5/22 11:28:26 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. 5. Solver Engine 5 Engine: GRG Nonlinear 7 Solution Time: 7497.039 Seconds. 8 Iterations: 3 Subproblems:0 9 Solver Options 10 Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling 11 Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds 12 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative 13 14 Objective Cell (Value of) 15 Cell Name Original Value Final Value 16 $B$13 Net Profit $ 5,000.00 $ 20,000.01 17 18 19 Variable Cells 20 Cell Name Original Value Final Value Integer 21 $B$4 Number of Ads 10000 30662.02787 Contin 22 $B$5 Click Rate 6.83% 7.00% Contin 23 24 25 Constraints 26 Cell Name Cell Value Formula Status Slack 27 $8$13 Net Profit $ 20,000.01 $B$13-20000 Binding 28 $B$4 Number of Ads 30662.02787 $B$4.40000 Not Binding 9337.972125 29 SBSS Click Rate 7.00% $B$50.07 Binding 30 31 32 33 34 SRNNNN 0 Review Tell m X Calibri (Body) ~ A A 2 Wrap Paste BIU CA 6 Merge Open recovered workbooks? Your recent changes were saved. Do you want to continue working wh 21 X & fx x 2 2 B D E F G H 1 3 7 WNA 800 N Scenario Summary Current Values: Best Case Worst Case Most Likely Changing Cells: $B$4 10000 40000 10000 10000 $B$5 5.00% 6.50% 1.00% 6.83% Result Cells: $B$12 $ 8,536.59 $ 32,500.00 $ 1,250.00 $ 8,537.50 $B$13 $ 5,000.00 $ 24,650.00 $ (975.00) $ 5,000.75 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 NNN X Calibri (Body) 11 ' ' A A Paste BI UB a. Av Open recovered workbooks? Your recent changes were saved. Do y G9 x & fx x A B D Cost Per Ad 'Direct Marketing 15859 2 Design Fee2021 Direct Marketing 15858 3 Gross Profit Direct Marketing158512 4 Profit Per Click "Direct Marketing 158511 5 Total Clicks - Direct Marketing $8510 6 7 8 10 11 12 13 14 15 16 17 18 19 20 Ooh Home Insert Draw Page Layout Formulas Data Review View Tell me then X Calibr (Body) 11 A A Wrap Text General Driet Pite BIU Morge & Center $ %) 3853 Conditional Format Cell Formatting as Table Styles Format Oper recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off Total Clio XVfB4 C D + 0 H M N Direct Marketing 1 1 Inputs Number of 5 10663 02787 7.00 Parameters De Fee Daster Ad Ta Total Clicks Profiter $ 2.000.00 2.25 7146 1415 1 12.50 1368392) $30,000.00 Click Rate 20% 2.5 3. ON BSN LON 4.5% SON 5.IN 6.ON EN Grow Pront Net Profit 7,565 53 4285.72 9.50188 5.19714 11.498 26 7,428 57 13,416 64 9,000.00 15,39101 10,571.43 37,242.35 12,142,86 19,163.77 11,714.29 21.080.14 15,255.72 22.99652 16,25715 24.912.90 $ 20,000 01 10000 15000 20000 25000 10000 35000 40000 20 5 50.00 5 1075.00 5 2,100.00 125.00 $ 4,150.00 55.17500S 6.700.09 2.5 5562.50 $ 1841.55 1,125.00 $4.40655 5687.50 $ 5,96875 S 750.00 BOX $ 1.075.00 52.612.50 $4,150.00 $ 5.687505 2.235.00 3.767.50 $ 10,300.00 $ 1,547,50 S 2.181.35 $ 5,175.00 $ 60.7 $ 3.762.50 10.55625 $ 12.150.00 4.ON $2,100.00 $ 4150,00 S 6,200.00 SB.250.00 $ 10,300.00 S 32,350.00 5 14.00.99 4.5N $ 2,612.50 5.4918.15$ 2,235.00 $ 1.3 11,817.50 S 36,143.5 5 16.450.00 5.ON 53.125.00 5.670 $ 8,250.00 $ 10.812.50 S 13 375.00 S 35.93 5 18 500 00 5.5 53,637.50 5.6456$ 9,275.00 $12,093.75 $ 14,912.50 S 1723125 5 70,550.00 SON 54,150.00 5222500 510,800.00 511.175.00 5 15,450.00 5 13,325.00 5 22.400.00 SN 5 4,662.50 $ 7,093.75 $11,925.00 $14,656.25 5 17,987 50 5 21358.75 5 24,650.00 Ne Prote 16 17 IN 20 21 24 20 20 17 10 34 13 Direct Marketing Range Navn cenario tummary Answer Roport ORA fx What click response rate is required for a gross profit of over $7,000? B D 1 Your Answers Question 1) If10,000 ads are purchased, what is the optimal click response rate Optimal click response rate=4% opti 2 to earn a $5,000 net profit? 2) What click response rate is required for a gross profit of over 3 $7,000? 3) For the two-variable data table, if 20,000 ads are purchased, what is the required response rateto net $5000? 4) For the two-variable data table, if the ads purchased is raised to 40,000, what is the required response rate to net $10000? 4 5 6 $B$12 is 32500 and $B$13 is 24650 5) What is the Net Profit based on the best case scenario? 6) What is the optimal number of ads to purchase and response rate to 7 reach the $20,000 goal? 8 9 10 11 12 13 14 15 16 17 18 50 von 0 G 1 Marketing $ 20,000.00 Click to 2.0 3 4 S 20 $ 30662.02787 7.00 2.5 5 NOE 6 NOTE WSE Gros Prot het Pott 7,665 51 428572 9.5813 5.857.14 11,49826 7.42857 13.41464 9.000.00 15,331 01 10,571.43 17.247.39 12.142.86 19.163.77 11,71 21,080.16 15.285.72 22.99652 1685715 24.51790 18.47.58 4.ON 10000 15000 20000 35000 30000 35000 10000 50.00 $ 1.075.00 5 2.100.00 $ 3.125 00 5 4,150.00 55.175.00 S 5.200.00 556250 S 1.841.755 3.125.00 $ 4.406255 5.687.50 $ 6,96875 S 350.00 $3,075.00 $ 2.612.50 $ 4,150.00 $ 5687.505 7.225.00 $ 3.762.50 $ 10.000 DO $ 1.587.50 S18125 $ 3.175.00 S 468.75 8.752.50 $ 10,55625 $ 12,350.00 5.2.100.00 4.150,00 6,200.00 $ 3.750.00 $ 10 300.00 $ 12.150.00.5 14.400.00 52.612.50 5 491875 5 7 225.00 5 9.53125 $ 11,81750 5 14 14.5 16450.00 5 3,125.00 5568750 $5.250.00 510.812.505 11,175.00 5 15,937.50 1.500.00 53617.50.5645625 $9.275.00 51200175 $ 14,912.50 $ 17,73135 5 20,550.00 $4150.00 57.27500 510 100.00 512 275.00 16.450.00 5 19.525.005 72.600.00 54.467.50 $ 7,993 755 11 325.00 14.65625 17.037.50 $ 21,1155 14,650.00 5 NS 5. 4 ON 45 SON 55% 60% 55 OS ET 5 2,000.00 225 102346 341951 115 12 $76.229.23 11 5 20,000.00 16 15 16 NSS 603 SS 13 19 10 TE IE TE 25 ST 27 21 20 DE 12 31 NE Query Picture AN Edit Links Stock Currencies Geography Automatis Set Fiter Advanced Testiu Count G9 C 0 E G H 1 M A 1 Cost Pe Ad Direct Marketing$$9 2 Design Fee2021 Direct Marketing $$8 Gross Profit Direct Marketing I$8512 4 Profit Der Click Direct Marketing $$11 5 Total Clicks Direct Marketin'50510 6 7 9 10 13 12 13 14 15 10 11 10 1 20 21 23 24 25 76 27 10 10 10 35 H H NOS'S NEWS Scenario Summary Current Values Best Case Worst Case Most hely Changing Cell SRS4 10000 40000 10000 10000 5055 5.00% 1.00 Result Cells $1$12 $ 8,536.59 532,500.00 5 1,250.00 $ 8,537.50 SD$13 $ 5.000.00 $ 24,650.00 5975.00) 55,000.75 Notes Current Values column represents values of charging cells time Scenario Summary Report was created Changing cells for each scenario are highlighted in a he Insert Draw Page Layout Formulas Data Review VI E Queries & Connections Properties Data (Power Query) Data from Picture Refresh AN Stocks Edit Links XV fx Microsoft Excel 16.58 Answer Report A B D E G Microsoft Excel 16.58 Answer Report Worksheet: [e06ci Direct Marketing_BesicAdisadsx]Direct Marketing Report Created: 3/5/22 11:28:26 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. Solver Engine Engine GRG Nonlinear Solution Time: 7497.039 Seconds Iterations: 3 Subproblems:0 Solver Options b Max Time Unlimited, iterations Unlimited, Precision 0.000001, Use Automatic Scaling 1 Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds 2 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Asume NonNegative 13 14 Objective Cell Value on 15 Cell Name Original Value Final Value 16 $B$13 Net Profit $ 5,000.00 $ 20,000.01 17 18 19 Variable Cells 20 Cell Name Original Value Final Value Integer 21 SBS4 Number of Ads 1000030662.02787 Costa 22 $B$5 Click Rate 6.83% 7.00% Contin 23 24 25 Constraints Cell Status Slack Formula 26 Cell Value Name 27 SBS13 Net Profit $ 20,000.01 SBS 13=20000 Binding 28 SBS4 Number of Ads 30662.02787 585440000 Not Binding 9337.972125 Binding 29 SBSS 7.00% SS50.07 Click Rate 30 Window Help e06c1Direct Excel File Edit Viewert Format Tools AutoSave 22 24 Home Insert Draw Page Layout Formulas Data X Calibri (Body) 11 Paste BTU A- Review View Tell me Il lol Wrap Text Merge & Cente D 2 Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you x fe A E 1 Your Answers Question 1) 10,000 ads are purchased, what is the optimal click responserate Optimal click response rate=4% opti to earn a $5,000 net profit? 2) What click response rate is required for a gross profit of over $7,000? 3) For the two variable datatable, if 20,000 ads are purchased, what is the required response rateto net $5000? 4) For the two-variable data table, if the ads purchased is raised to 40,000, what is the required response rate to net $10000? 5 5 SR$12 is 32500 and $B$13 is 24650 5) What is the Net Profit based on the best case scenario? 6) What is the optimal number of ads to purchase and response rate to reach the $20,000 goal? 10 12 14 15 16 17 10 20 21 22 22 24 25 26 27 20 Direct Marketing Range Names Scenario Summary Answer Report QAA Data Review Formulas View Tell Insert Home Draw Page Layout Wri ID Calibri (Body) Paste BIU Me CA Open recovered workbooks? Your recent changes were saved. Do you want to continue working A1 XVfx Microsoft Excel 16.58 Answer Report 4 F D E G B H 1 Microsoft Excel 16.58 Answer Report 2 Worksheet: [e06ci Direct Marketing_BesicAdis.xlsx]Direct Marketing 3 Report Created: 3/5/22 11:28:26 AM Result: Solver found a solution. All constraints and optimality conditions are satisfied. 5. Solver Engine 5 Engine: GRG Nonlinear 7 Solution Time: 7497.039 Seconds. 8 Iterations: 3 Subproblems:0 9 Solver Options 10 Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling 11 Convergence 0.0001, Population Size 100, Random Seed 0, Derivatives Forward, Require Bounds 12 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative 13 14 Objective Cell (Value of) 15 Cell Name Original Value Final Value 16 $B$13 Net Profit $ 5,000.00 $ 20,000.01 17 18 19 Variable Cells 20 Cell Name Original Value Final Value Integer 21 $B$4 Number of Ads 10000 30662.02787 Contin 22 $B$5 Click Rate 6.83% 7.00% Contin 23 24 25 Constraints 26 Cell Name Cell Value Formula Status Slack 27 $8$13 Net Profit $ 20,000.01 $B$13-20000 Binding 28 $B$4 Number of Ads 30662.02787 $B$4.40000 Not Binding 9337.972125 29 SBSS Click Rate 7.00% $B$50.07 Binding 30 31 32 33 34 SRNNNN 0 Review Tell m X Calibri (Body) ~ A A 2 Wrap Paste BIU CA 6 Merge Open recovered workbooks? Your recent changes were saved. Do you want to continue working wh 21 X & fx x 2 2 B D E F G H 1 3 7 WNA 800 N Scenario Summary Current Values: Best Case Worst Case Most Likely Changing Cells: $B$4 10000 40000 10000 10000 $B$5 5.00% 6.50% 1.00% 6.83% Result Cells: $B$12 $ 8,536.59 $ 32,500.00 $ 1,250.00 $ 8,537.50 $B$13 $ 5,000.00 $ 24,650.00 $ (975.00) $ 5,000.75 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 NNN X Calibri (Body) 11 ' ' A A Paste BI UB a. Av Open recovered workbooks? Your recent changes were saved. Do y G9 x & fx x A B D Cost Per Ad 'Direct Marketing 15859 2 Design Fee2021 Direct Marketing 15858 3 Gross Profit Direct Marketing158512 4 Profit Per Click "Direct Marketing 158511 5 Total Clicks - Direct Marketing $8510 6 7 8 10 11 12 13 14 15 16 17 18 19 20 Ooh Home Insert Draw Page Layout Formulas Data Review View Tell me then X Calibr (Body) 11 A A Wrap Text General Driet Pite BIU Morge & Center $ %) 3853 Conditional Format Cell Formatting as Table Styles Format Oper recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off Total Clio XVfB4 C D + 0 H M N Direct Marketing 1 1 Inputs Number of 5 10663 02787 7.00 Parameters De Fee Daster Ad Ta Total Clicks Profiter $ 2.000.00 2.25 7146 1415 1 12.50 1368392) $30,000.00 Click Rate 20% 2.5 3. ON BSN LON 4.5% SON 5.IN 6.ON EN Grow Pront Net Profit 7,565 53 4285.72 9.50188 5.19714 11.498 26 7,428 57 13,416 64 9,000.00 15,39101 10,571.43 37,242.35 12,142,86 19,163.77 11,714.29 21.080.14 15,255.72 22.99652 16,25715 24.912.90 $ 20,000 01 10000 15000 20000 25000 10000 35000 40000 20 5 50.00 5 1075.00 5 2,100.00 125.00 $ 4,150.00 55.17500S 6.700.09 2.5 5562.50 $ 1841.55 1,125.00 $4.40655 5687.50 $ 5,96875 S 750.00 BOX $ 1.075.00 52.612.50 $4,150.00 $ 5.687505 2.235.00 3.767.50 $ 10,300.00 $ 1,547,50 S 2.181.35 $ 5,175.00 $ 60.7 $ 3.762.50 10.55625 $ 12.150.00 4.ON $2,100.00 $ 4150,00 S 6,200.00 SB.250.00 $ 10,300.00 S 32,350.00 5 14.00.99 4.5N $ 2,612.50 5.4918.15$ 2,235.00 $ 1.3 11,817.50 S 36,143.5 5 16.450.00 5.ON 53.125.00 5.670 $ 8,250.00 $ 10.812.50 S 13 375.00 S 35.93 5 18 500 00 5.5 53,637.50 5.6456$ 9,275.00 $12,093.75 $ 14,912.50 S 1723125 5 70,550.00 SON 54,150.00 5222500 510,800.00 511.175.00 5 15,450.00 5 13,325.00 5 22.400.00 SN 5 4,662.50 $ 7,093.75 $11,925.00 $14,656.25 5 17,987 50 5 21358.75 5 24,650.00 Ne Prote 16 17 IN 20 21 24 20 20 17 10 34 13 Direct Marketing Range Navn cenario tummary Answer Roport ORA