|
Typical report pages - Page 6 of 7
|
|
Part 1 of the Value Simulator
|
|
Estimates of how 5-unit OEI increases are likely to
impact on the Desired Behaviour:
|
|
BEHAVIOUR DRIVEN BY THE OEI
|
Score
|
Impact on the behaviour
|
Economic weights
|
|
Buy more
|
89
|
3.6
|
10
|
Recommend more
|
84
|
4.9
|
1
|
Price sensitivity
|
71
|
3.2
|
5
|
|
|
Financial value of a 5-unit increase of the
Overall Evaluation Index:
|
Present sales to segment, millions
|
600
|
|
Margin, %
|
20
|
Likely increase in sales to segment, %
|
4
|
GROSS FINANCIAL VALUE, millions
|
5
|
|
The value simulation is done in Excel in two steps.
In part 1, the gross financial value of OEI increases is
estimated based on the impacts of the OEI on the behaviour as it results from the
econometric analysis.
The weighted average of the impacts is inserted in the second table as
"Likely increase in sales to segment, %".
The impacts and their economic weights are shown for guidance and
convenience, while the information about present sales to the segment and the average
contribution margin is entered manually using data provided from
other sources than the survey.
|