B D F G 4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 C-Spire Communications, a cellular communications provider based in Mississippi, charges S79 per month for an unlimited service plan. The company wants to determine Customer Lifetime Value (CLV). Variable costs per account are $30 and monthly retention marketing expenditures are $10 per account. C-Spire has a churn rate of 18%. The discount rate used to project present value of future profits is 10%. 16. Calculate the current Customer Lifetime Value for C-Spire Communications. Calculate in cell MII. (4 points) CLV 17. In a quest to boost long-term profits, C-Spire's director of marketing is considering two approaches: - Increase monthly price to S85 Improve customer service in an effort to reduce chum rate from 18% to 15%. Calculate CLV for each of the two approaches being considered. For each calculation only change the focal variable (revenue or churn rate). Hold all other variables constant from the original scenario. Calculate in cells M16 and M18. Increase revenue (4 points) Decrease churn 18. Which approach should C-Spire Communications make a focus for increasing CLV? Why? Enter answer in space below. (3 points) 999 &NNAS 018 ANSWER: = Section Section2 Section Section4 Sections Section +