please fill out all the blanks and answer ONLY in excel formula. Please make sure u include excel formula, that is most important. thanks so much

Now that you're warmed up, here's a more challenging probiem; Complete Cable has an Jos retention rate. Each custemer costs the company $75 monthly. The company offers three plans with monthly revenues as autlined in the table below. Assume a 12% distrunt rate in your calculations. Part A(5 peinta) Calculate the CLV fer each customer group at the current retention rate. Part C (5 points) Aavuming the compary has sco,0so customers, what is the maximum it sheuld spend to increase its retention rate fram 70% to 75 ? in each stoup ( mx). The mx it thewn below. Now that you're warmed up, here's a mare challesging problem: Complete Cable has an 70k retention rate. Each customer costs the company $75 moenthly. The company offers three plans with manthly revenues as autined in the table belaw. Assume a 12% discount rate in your calculations. Part A (5 points): Calculate the CLV for each customer group at the current retention rate. Part C (5 points): Assuming the company has 500,000 customers, what is the maximum it should spend to increase its retention rate from 70% to 75% ? Mint: For this problem, you'll need to calculate the weighted average of CuVs across all customer groups (e-g, Binge Watchers, TV Lovers) iaing the percent of Complete Cable's total custemers in each group (mia). The mix is shown below