## Question

# Before tackling the Rosewood case, this initial question tests your ability to compute the CLV metric and then apply it in a simple breakeven analysis.

Before tackling the Rosewood case, this initial question tests your ability to 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.2 5.3 9.8

REVENUE PER VISIT $3.98 $4.20 $4.42

ANNUAL RETENTION PROBABILITY 0.40 0.50 0.60

A. Assume that Starbucks' gross margin is 40% and that its (one-time) customer acquisition cost is $100. Further assume that Starbucks uses a discount rate of 9%. What is the 5-year individual customer CLV for each class of customer? Show your work on an Excel spreadsheet.

B. Suppose Starbucks is considering an investment of $40 million in their 3500 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.)

## Step by Step Solution

There are 3 Steps involved in it

### Step: 1

To compute the Customer Lifetime Value CLV and perform the breakeven analysis lets follow these steps with detailed calculations Part A Computing 5year CLV for each class of customer Step 1 Understand...### Get Instant Access to Expert-Tailored 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