$15\mathrm{.}11$ Credit Card Revenue 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

a$.$

Reward per new customer $$50\mathrm{.}00$

Annual spending per customer $$15,000\mathrm{.}00$

Revenue as percent of spending $5\%$

Cost of referral program $$1,750,000\mathrm{.}00$

Number of new customers $$25,000\mathrm{.}00$

Profit increase $$17,000,000\mathrm{.}00$

b$.$

Reward per new customer $$50\mathrm{.}00$

Annual spending per customer $$15,000\mathrm{.}00$

Revenue as percent of spending $5\%$

Cost of referral program $$1,750,000\mathrm{.}00$

Number of new customers $$25,000\mathrm{.}00$

$\%$ of new customer who would be customers without the referral $10\%$

Profit increase $$15,125,000\mathrm{.}00$ 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 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?