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

Here is how the final excel sheet should look.

 

Transcribed Image Text:

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

Answer rating: 100% (QA)

Solution Understanding the requirement The requirement is to use Go... View the full answer