mytest > help > Part 2. MM4XL Tools > 2. Analytical Tools > Business Formulas > 4. Opportunity Index > mmBDI, Brand Development Index

Business Formulas

mmBDI, Brand Development Index

Category: Reporting > Market Models

The Brand Development Index compares how well a brand performs within a given group of customers according to the average performance among all consumers.

Business analysis formulas for Excel. Marketing tool for professionals

Syntax

mmBDI(Area_Size, Brand_Size, Optional Total_Area, Optional Total_Brand)

Area_Size The number of residents in a geographic area
Brand_Size The revenue of your brand by geographic area
Total_Area Optional - The total number of residents in all geographic areas
Total_Brand Optional - The total revenue of your brand in all geographic areas

When any Optional value is missing the total column is set equal to the sum of the values in the range.

Example

See example file Business Formulas.xls, sheet mmBDI-mmCDI-mmMOI.

Business analysis formulas for Excel. Marketing tool for professionals

Note: This is an Array Function (curly brackets { } ). To enter an array function: (1) select the range where you want to enter it, for instance, E26:E28; (2) type the formula; (3) press CTRL+SHIFT+ENTER.

Related functions
  • mmBEI
  • mmBEP
  • mmBEPR
  • mmCDI
  • mmEI
  • mmHERF
  • mmMOI
  • mmPERFCV
  • mmPERFO
  • mmPERFR
  • mmREBUY
  • mmREBUYS
  • mmPRESS
Related MM4XL software tools
  • BCG Matrix
  • Profile Manager
  • Gravity Analyst
  • Smart Map
  • Differential Semantic
Source
Luiz Moutinho, 1991, Problems in Marketing
Paul Farris, 2006, Marketing metrics: 50+ metrics every executive should master
Lifetime license:
MM4XL All Tools
Price: euro 238.00

Vote this tool
403 votes: vote vote vote vote vote
5 stars:
145
4 stars:
187
3 stars:
61
2 stars:
8
1 star:
2
We proudly serve
Your vote
vote1 vote2 vote3 vote4 vote5
Email:
Gender:
M
F
Age:
Position:
Department:
Comment: