Spreadsheet Use the Excel template VLC to find the average value of a loyal custormer (VLC) in a target market segment if the average purchase price is $75 per visit, the frequency of repurchase is five times per year, the contribution margin is 5 percent, and the average customer defection rate is 25 percent? Round your answer to the nearest dollar

Managerial Economics: A Problem Solving Approach
5th Edition
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Chapter4: Extent (how Much) Decisions
Section: Chapter Questions
Problem 4.4IP
icon
Related questions
Question

6

Spreadsheet
Use the Excel template VLC to find the average value of a loyal custormer (VLC) in a target market segment if the average purchase price is $75 per visit, the frequency of
repurchase is five times per year, the contribution margin is 5 percent, and the average customer defection rate is 25 percent? Round your answer to the nearest dollar
Transcribed Image Text:Spreadsheet Use the Excel template VLC to find the average value of a loyal custormer (VLC) in a target market segment if the average purchase price is $75 per visit, the frequency of repurchase is five times per year, the contribution margin is 5 percent, and the average customer defection rate is 25 percent? Round your answer to the nearest dollar
Revenue per unit
Percent contribution margin to profit and overhead
$100.00
50.0%
0.25
Repurchase frequency (purchases/year)
Defection rate
0.4
Buyer's life cycle
VLC
2.50
$31.25
Transcribed Image Text:Revenue per unit Percent contribution margin to profit and overhead $100.00 50.0% 0.25 Repurchase frequency (purchases/year) Defection rate 0.4 Buyer's life cycle VLC 2.50 $31.25
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning