Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 5. Performance Ranking > mmPERFCV, Customer Value Rank

Business Formulas

mmPERFCV, Customer Value Rank

Category: Reporting > Ranking

The Customer Value Rank is used to identify products that are above or below average in performance or price.

Business analysis formulas for Excel. Marketing tool for professionals

Where:

PERFR = Relative Performance Rank (see formula mmPERFR)
Relative_Price = Brand i price divided by the average of all prices of all competing brands

Syntax

mmPERFCV(Relative_Performance, Relative_Price)

Relative_Performance The result of the mmPERFR formula
Relative_Price The relative performance of a brand or item (can use the mmRELATIVE formula)

Example

See example file Business Formulas.xls, sheet mmPERFCV.

Business analysis formulas for Excel. Marketing tool for professionals

Related functions
  • mmDBAVG
  • mmDBCOUNT
  • mmDBSUM
  • mmEI
  • mmPERFO
  • mmPERFR
  • mmAUC
  • mmBDI
  • mmCDI
  • mmHERF
  • mmMOI
  • mmPRESS
  • mmRANK
Related MM4XL software tools
  • Quality Analyst
  • BCG Matrix
  • McKinsey Matrix
  • Profile Manager
  • Descriptive Statistics
Source
Roger J. Best, Market-Based Management. Strategies for growing customer value and profitability
Lifetime license:

Price: euro

Vote this tool
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: