A retail store sells a popular cosmetic called Devine and the store manager was given $140,000 by the corporate office to improve store performance any way she thinks best. The "base case" information is a price of $28 per bottle, a contribution margin of 0.30, a customer defection rate of 17 percent, and a repurchase frequency of five times a year. These improvement funds could be used to (a) increase the contribution margin to 0.39 or (b) reduce the customer defection rate to 12 percent or (c) increase the repurchase frequency to six times per year. Assume all other variables remain at the base case level for each of the three improvement options. Use the Excel template VLC to calculate the VLC for each option and summarize your answers using the table below. Round your answers to the nearest cent. (a) (b) (c) Contribution Repurchase Price Margin 0.30 $28 $28 $28 $28 0.39 0.30 0.30 What is the best way to use $140,000 in improvement funds? The best way to use the $140,000 in improvement funds is option (a) ✓ Defection Frequency Rate 5 17% 5 5 6 17% $ $ 12% $ $ 17% VLC in $ 45.91 56.95 52.38 55.09

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question
A retail store sells a popular cosmetic called Devine and the store manager was given $140,000 by the corporate office to improve store performance any way
she thinks best. The "base case" information is a price of $28 per bottle, a contribution margin of 0.30, a customer defection rate of 17 percent, and a
repurchase frequency of five times a year. These improvement funds could be used to (a) increase the contribution margin to 0.39 or (b) reduce the customer
defection rate to 12 percent or (c) increase the repurchase frequency to six times per year. Assume all other variables remain at the base case level for each of
the three improvement options.
Use the Excel template VLC to calculate the VLC for each option and summarize your answers using the table below. Round your answers to the nearest cent.
Contribution Repurchase Defection
Margin Frequency Rate
0.30
5
17%
The
0.39
5
17%
0.30
5
12%
6
17% $
(a)
(b)
Price
$28
$28
$28
(c) $28
0.30
What is the best way to use $140,000 in improvement funds?
The best way to use the $140,000 in improvement funds is option (a)
$
VLC in $
45.91
56.95
52.38
55.09
Transcribed Image Text:A retail store sells a popular cosmetic called Devine and the store manager was given $140,000 by the corporate office to improve store performance any way she thinks best. The "base case" information is a price of $28 per bottle, a contribution margin of 0.30, a customer defection rate of 17 percent, and a repurchase frequency of five times a year. These improvement funds could be used to (a) increase the contribution margin to 0.39 or (b) reduce the customer defection rate to 12 percent or (c) increase the repurchase frequency to six times per year. Assume all other variables remain at the base case level for each of the three improvement options. Use the Excel template VLC to calculate the VLC for each option and summarize your answers using the table below. Round your answers to the nearest cent. Contribution Repurchase Defection Margin Frequency Rate 0.30 5 17% The 0.39 5 17% 0.30 5 12% 6 17% $ (a) (b) Price $28 $28 $28 (c) $28 0.30 What is the best way to use $140,000 in improvement funds? The best way to use the $140,000 in improvement funds is option (a) $ VLC in $ 45.91 56.95 52.38 55.09
What is the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $80 per visit, the frequency of repurchase is
every month, the contribution margin is 25 percent, and the average customer defection rate is 24 percent? If a continuous improvement goal is set of a 20
percent defection rate next year and 18 percent two years from now, what are the revised VLCs over their average buying life? Do not round intermediate
calculations. Round your answers to the nearest dollar.
For defection rate = 24%, VLC = $
For defection rate =
20%, VLC = $
For defection rate = 18%, VLC = $
316
300
293
Transcribed Image Text:What is the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $80 per visit, the frequency of repurchase is every month, the contribution margin is 25 percent, and the average customer defection rate is 24 percent? If a continuous improvement goal is set of a 20 percent defection rate next year and 18 percent two years from now, what are the revised VLCs over their average buying life? Do not round intermediate calculations. Round your answers to the nearest dollar. For defection rate = 24%, VLC = $ For defection rate = 20%, VLC = $ For defection rate = 18%, VLC = $ 316 300 293
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education