Use the spreadsheet model that you developed in Exercise $15\mathrm{.}11,$ part a$,$ for this exercise: Use the spreadsheet model that you developed in Exercise $15\mathrm{.}11,$ part a$,$ for this exercise:

Click here for the Excel Data File

a$.$ Use the data table to show the impact of the number of new customers acquired ranging from $20,000$ to $30,000$ with $1,000-$

customer increments on the total costs and total increase in profit of the referral program. What are the total costs and total profit

for acquiring $28,000$ new customers?

Total cost

Total profit

b$.$ Use Goal Seek to find out the number of new customers needed for the referral program to break even.

Note: Round your answer to the nearest whole number.

Number of new customers c$.$ What does the average customer annual spending need to be in order to achieve $$5,000,000$ in profit from the referral program,

assuming $25,000$ new customers are acquired through the referral program? Now reevaluate this question by taking into account

the fact that $10\%$ of the customers acquired through the referral program would have become customers of the credit card company

even without the referral program.

d$.$ Use the original assumptions for the spreadsheet model to compare the following three scenarios. Which scenario will yield the

highest profit from the referral program? What is the highest profit?

Click here for the Excel Data File

a$.$ Use the data table to show the impact of the number of new customers acquired ranging from $20,000$ to $30,000$ with $1,000-$

customer increments on the total costs and total increase in profit of the referral program. What are the total costs and total profit

for acquiring $28,000$ new customers?

Total cost

Total profit

b$.$ Use Goal Seek to find out the number of new customers needed for the referral program to break even.

Note: Round your answer to the nearest whole number.

Number of new customersc. What does the average customer annual spending need to be in order to achieve $$5,000,000$ in profit from the referral program,

assuming $25,000$ new customers are acquired through the referral program? Now reevaluate this question by taking into account

the fact that $10\%$ of the customers acquired through the referral program would have become customers of the credit card company

even without the referral program.

d$.$ Use the original assumptions for the spreadsheet model to compare the following three scenarios. Which scenario will yield the

highest profit from the referral program? What is the highest profit?