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%.	4
17	Create a second scenario named Worst Case, using the same changing cells. Enter these values for the scenario: 10000, and 1%.	4
18	Create a third scenario named Most Likely, using the same changing cells. Enter these values for the scenario: 10000, and 6.83%.	4
19	Generate a scenario summary report using Gross Profit and Net Income.	4
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.	4
21	Use Number of Ads and Click Rate (B4:B5) as changing variable cells.	4
22	Set a constraint to ensure Number of Ads purchased is less than or equal to 40,000.	2
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 .07)	2
24	Solve the problem. Generate the Answer Report.	3
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.	4
26	Save and close Exp19_Excel_Ch06_CAP_DirectMarketing.xlsx. Exit Excel. Submit the file as directed.	0

Direct Marketing Net Profit 20000 25000 30000 40000 Inputs Number of Click Rate 10000 5.00% 2.00% 2.50% 3.00% $4,286 $5,857 $7,429 Net Profit 2.00% 2.50% 3.00% 10000 $50 $563 $1,075 15000 $1,075 $1,844 $2,613 35000 $5,175 $6,969 $8,763 $6,200 $8,250 $10,300 3.50% Parameters Design Fee $ 2,000.00 Cost Per A $ Total Click: 500 Profit Per ($ 12.50 Gross Profi $ 6,250.00 Net Profit $ 3,125.00 Gross Profit $7,666 $9,582 $11,498 $13,415 $15,331 $17,247 $19,164 $21,080 $22,997 $24,913 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% 2.25 $9,000 $10,571 $12,143 $13,714 $15,286 $16,857 $18,429 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% $1,588 $2,100 $2,613 $3,125 $3,638 $4,150 $4,663 $2,100 $3,125 $3,125 $4,406 $4,150 $5,688 $5,175 $6,969 $6,200 $8,250 $7,225 $9,531 $8,250 $10,813 $9,275 $12,094 $10,300 $13,375 $11,325 $14,656 $3,381 $4,150 $4,919 $5,688 $6,456 $7,225 $7,994 $4,150 $5,688 $7,225 $8,763 $10,300 $11,838 $13,375 $14,913 $16,450 $17,988 $10,556 $12,350 $14,144 $15,938 $17,731 $19,525 $21,319 $12,350 $14,400 $16,450 $18,500 $20,550 $22,600 $24,650 Direct Marketing Net Profit 20000 25000 30000 40000 Inputs Number of Click Rate 10000 5.00% 2.00% 2.50% 3.00% $4,286 $5,857 $7,429 Net Profit 2.00% 2.50% 3.00% 10000 $50 $563 $1,075 15000 $1,075 $1,844 $2,613 35000 $5,175 $6,969 $8,763 $6,200 $8,250 $10,300 3.50% Parameters Design Fee $ 2,000.00 Cost Per A $ Total Click: 500 Profit Per ($ 12.50 Gross Profi $ 6,250.00 Net Profit $ 3,125.00 Gross Profit $7,666 $9,582 $11,498 $13,415 $15,331 $17,247 $19,164 $21,080 $22,997 $24,913 3.50% 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% 2.25 $9,000 $10,571 $12,143 $13,714 $15,286 $16,857 $18,429 4.00% 4.50% 5.00% 5.50% 6.00% 6.50% $1,588 $2,100 $2,613 $3,125 $3,638 $4,150 $4,663 $2,100 $3,125 $3,125 $4,406 $4,150 $5,688 $5,175 $6,969 $6,200 $8,250 $7,225 $9,531 $8,250 $10,813 $9,275 $12,094 $10,300 $13,375 $11,325 $14,656 $3,381 $4,150 $4,919 $5,688 $6,456 $7,225 $7,994 $4,150 $5,688 $7,225 $8,763 $10,300 $11,838 $13,375 $14,913 $16,450 $17,988 $10,556 $12,350 $14,144 $15,938 $17,731 $19,525 $21,319 $12,350 $14,400 $16,450 $18,500 $20,550 $22,600 $24,650