Use the Excel template VLC to find the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $200 per visit, the frequency of repurchase is 7 times per year, the contribution margin is 23 percent, and the average customer defection rate is 19 percent?

Information Technology Project Management
9th Edition
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Kathy Schwalbe
Chapter7: Project Cost Management
Section: Chapter Questions
Problem 9QQ
icon
Related questions
Question

Use the Excel template VLC to find the average value of a loyal customer (VLC) in a target market segment if the average purchase price is $200 per visit, the frequency of repurchase is 7 times per year, the contribution margin is 23 percent, and the average customer defection rate is 19 percent?

 

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Database Development
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Information Technology Project Management
Information Technology Project Management
Computer Science
ISBN:
9781337101356
Author:
Kathy Schwalbe
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole