Part 1: Using CLV to evaluate spending on customer acquisition and customer retention.

Brushes & Buckets, a paint wholesaler, sells paint to professional painters. On average, each painter spends $38,333 per year on paint. The average gross margin for Brushes & Buckets is 35%, and it currently has $4.2 million of sales in this segment. The current retention rate of each painter is 80%, and the revenue per painter is stable over time. (Assume a 10% discount rate.)

1. The marketing director proposes spending $1,000,000 for a one-time direct marketing campaign to acquire new professional painters. How many painters would Brushes & Buckets need to acquire to make this investment profitable in the long term?
2. The marketing director also wants to determine the maximum amount of money Brushes & Buckets should spend to increase the retention rate of the current professional painters from 80% to 90%.
3. Use the data to identify ABCs best customer segments. Use Excel Pivot tables