Answered step by step
Verified Expert Solution
Question
1 Approved Answer
will upvote for fast correct answer C-Spire Communications, a cellalar comrsanications provider based in Mississippi, charges $79 per month for as unlimited service plan. The
will upvote for fast correct answer C-Spire Communications, a cellalar comrsanications provider based in Mississippi, charges $79 per month for as unlimited service plan. The company wasts to determine Customer Lifetime Value (CLV). Variable costs per account are $30 and monthly retention marketing expenditures are $6 per account. C.Spire has a custoence retention rate of 84%. The discount rate used to project present value of future profis is 10%. 11. Calculate the current Customer Lifetime Value for C-Spire Commanications. Calculate in cell M11, (2 points) 12. In a guest to boost long -term profits, C-Spire's ditector of matketing is considering two approaches: - Increase monthly price to 585 - Imperve customer service in an effort to increase retention rate from 84% so 87.5%. Caloulas CLV for each approach being considered. For each caloulation enly chaege the focal variable (revenae of retention rate). Hold all cher variables constant froen the original scenario. Calculate in cells M16 and M18. (2 points) 13. Which approach should C-Spire Corrmunications make a focus for increasing CLV? Why? Enter answer in space below. (2 points) Moathly nate Costs per account Retention Rate Discount Rate CLV Increase retention rate 579 $36 84% 10% Inerease revenue Q13
will upvote for fast correct answer
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started