Instructions: List your variables, write out the basic formulas, then calculate in the next step. Please fill in your answers below each question part in the document $($in black font$).$ The assignment is worth $90$ points. See brackets for point values. Please submit one copy per team. I encourage you all to try the questions and compare answers. That way, you will be checking each other to make sure they are correct. If you want to do it in Excel, please label all your numbers, and show your work with enough steps, so that it is easy to follow. Please type out the formulas. Note: If you use Excel, please use the formula functions to do the calculations. Otherwise, just do them in this file using the equation writer $($on the Insert menu bar$)$ and your calculator, as I have shown you in class.

Brookside Tailors sells suits to three segments: Executive Custom, Signature, and Brookside One. Last year they had $6,000$ Executive Custom, $15,550$ Signature, and $38,200$ Brookside One clients. The revenue they make annually from the three segments are as follows: $$3500,$$$1800,$ and $$600.$ The cost to serve these customers is as follows: $$1000,$$$400,$ and $$120,$ respectively. The retention rate for segments are $80\%,76\%,$ and $85\%.$ Assuming an annual discount rate of $5\%,$ please calculate the following:

a$.$ CLV for each segment. What is the total value of each segment? $[6]$

b$.$ Suppose the company decides that it would like to invest $$2,500,000$ next year on loyalty programs to increase the retention rate. How much would the retention rate need to increase to for each segment if the whole sum were spent in that segment? $[6]$

c$.$ Instead of spending on retention, let us say they are going to spend it to acquire more of customers. If they spend that amount of money, they anticipate targeting $2,000,5000,$ and $10,000$ customers from Executive Custom, Signature, and Brookside One, respectively. What percentage do they have to acquire from targeted audience from each segment to breakeven? How many customers does that work out to$?[6]$

d$.$ Imagine that growth rates in contribution are different for each segment for this incoming cohort of customers. The growth rates are $8\%,12\%,$ and $15\%$ respectively. Recalculate CLV for each segment. What is the total value of each segment? $[6]$

$\backslash$table$[[,$Small,Large,Business$],[$Segment Size,$80,30,15],[$Price $($monthly$),120,400,1,000],[$VC$,50,250,380],[$r$,0\mathrm{.}9,0\mathrm{.}7,0\mathrm{.}65],[$d$,0\mathrm{.}05,,],[$M$,840,1,800,7,440],[$CLV$,5,040,3,600,12,090],[,,,],[,,,],[$CLV d$-$r