Performance Measurement with Data Analytics
A company has implemented a new data analytics dashboard to monitor the performance of its sales team. The dashboard tracks sales revenue, customer acquisition cost (CAC), and customer lifetime value (CLV) by salesperson. The sales team is compensated based on revenue, but the CFO wants to align incentives with profitability. The dashboard shows that Salesperson A has high revenue ($2 million) but also high CAC ($500,000) and low CLV ($1.5 million). Salesperson B has lower revenue ($1.5 million) but lower CAC ($200,000) and higher CLV ($2.5 million). The company's cost of capital is 10%. The CFO is considering changing the compensation plan to include a profitability metric such as CLV/CAC ratio or net CLV (CLV - CAC). However, the sales team is resistant to change, arguing that the dashboard data is inaccurate because it does not capture all their efforts, such as relationship building that may not immediately translate to sales. The CFO is concerned about the reliability of the data and the potential for gaming the metrics.
1. Calculate the CLV/CAC ratio and net CLV for each salesperson. Based on these metrics, which salesperson is more profitable? Show your work.
Read the worked answer
Salesperson A: CLV/CAC = $1.5M / $0.5M = 3.0. Net CLV = $1.5M - $0.5M = $1.0M. Salesperson B: CLV/CAC = $2.5M / $0.2M = 12.5. Net CLV = $2.5M - $0.2M = $2.3M. Based on both metrics, Salesperson B is more profitable. Note: Revenue is not directly used in these metrics, but net CLV represents the profitability of the customer base acquired. Salesperson B generates higher net CLV despite lower revenue.
2. Discuss the potential issues with using these metrics for compensation and suggest how the CFO could address them.
Read the worked answer
Issues: (1) Data accuracy: The dashboard may not capture all sales efforts, leading to unfair evaluations. (2) Gaming: Salespeople might focus on customers with high CLV and ignore others, or manipulate CAC by delaying marketing expenses. (3) Short-term focus: CLV is a long-term metric, but salespeople may not stay long enough to see the benefits, leading to underinvestment in relationship building. (4) Subjectivity: CLV estimation involves assumptions that may be disputed. To address: (1) Improve data quality by integrating more sources and validating with sales team input. (2) Use a balanced scorecard with multiple metrics including revenue, net CLV, and qualitative factors. (3) Set thresholds and caps to prevent gaming. (4) Involve sales team in metric design and provide transparency. (5) Phase in the new plan with a trial period and adjustments.