An e-commerce site that sells beverages has enrolled 17,863 into a coffee club. The financial data is provided in Figure 9.19. The retention rate for Year 2 was 43% and for year 3 was 68%. While the average number of purchases of coffee per year increased each year, the average sales per purchase did not increase significantly. The company calculated they spent $175,000 to develop the coffee club. Calculate the net marketing contribution for each year, the cumulative net marketing contribution, and the overall lifetime value of the members in the coffee club.

Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Chapter6: Statistical Inference
Section: Chapter Questions
Problem 43P: The Port Authority sells a wide variety of cables and adapters for electronic equipment online. Last...
icon
Related questions
icon
Concept explainers
Question
An e-commerce site that sells beverages has enrolled 17,863 into a coffee club. The
financial data is provided in Figure 9.19. The retention rate for Year 2 was 43% and for
year 3 was 68%. While the average number of purchases of coffee per year increased
each year, the average sales per purchase did not increase significantly. The company
calculated they spent $175,000 to develop the coffee club. Calculate the net marketing
contribution for each year, the cumulative net marketing contribution, and the overall
lifetime value of the members in the coffee club.
Figure 9.19:
Lifetime Value of Digital Coffee Club
Variable
Year 1
Year 2
Year 3
Initial customers
17,863
Retention rate
43%
68%
Average purchases/year
Average sales/purchase
CofG Sold (%)
Acquisition costs
Database costs (per entry)
4.2
8.4
11.3
$41.16
$55.12
$55.27
58%
58%
58%
$175,000
$6.25
$7.25
$8.25
Transcribed Image Text:An e-commerce site that sells beverages has enrolled 17,863 into a coffee club. The financial data is provided in Figure 9.19. The retention rate for Year 2 was 43% and for year 3 was 68%. While the average number of purchases of coffee per year increased each year, the average sales per purchase did not increase significantly. The company calculated they spent $175,000 to develop the coffee club. Calculate the net marketing contribution for each year, the cumulative net marketing contribution, and the overall lifetime value of the members in the coffee club. Figure 9.19: Lifetime Value of Digital Coffee Club Variable Year 1 Year 2 Year 3 Initial customers 17,863 Retention rate 43% 68% Average purchases/year Average sales/purchase CofG Sold (%) Acquisition costs Database costs (per entry) 4.2 8.4 11.3 $41.16 $55.12 $55.27 58% 58% 58% $175,000 $6.25 $7.25 $8.25
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning