Compute the CLV metric and then apply it in a simple breakeven analysis. The data below show the results of a Starbucks segmentation study. Each column shows the values for a typical customer in each class (constant over the lifetime of the customer). The annual retention probability applies only after the first year. That is, no one defects until after a full year of patronizing Starbucks.

	Silver	Gold	Platinum
VISITS/MONTH	4.1	5.6	7.4
REVENUE PER VISIT	$3.85	$4.15	$4.55
ANNUAL RETENTION PROBABILITY	0.35	0.65	0.75

a. Assume that Starbucks gross margin is 45% and that its (one-time) customer acquisition cost is $20. Further assume that Starbucks uses a discount rate of 10%. What is the 5-year individual customer CLV for each class of customer?

b. Suppose Starbucks is considering an investment of $40 million in their 4,500 company-owned North American stores to improve service quality, and thereby, customer retention. How many customers per store would have to be converted from Gold to Platinum for the investment to achieve breakeven after five years? (For simplicity, assume all customer conversions apply throughout the entire five-year period.) Show your work on an Excel spreadsheet.