composite indicators
DESCRIPTION
KRI ReportingTRANSCRIPT
![Page 1: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/1.jpg)
1
Enter Presentation Title Here
Composite Indicators
&
Senior Management ReportingLondon
January 17th & 18th, 2006
Charles Taylor
Director, Operational Risk
![Page 2: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/2.jpg)
2
Agenda
Basic Concepts
Transforming Individual KRIs
Creating a Composite Indicator
Senior Management Reporting
![Page 3: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/3.jpg)
3
Agenda
Basic Concepts
Transforming Individual KRIs
Creating a Composite Indicator
Senior Management Reporting
![Page 4: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/4.jpg)
4
The Basic Problem
Combining apples and oranges
Combining things in a way that will highlight what senior management needs to focus on
![Page 5: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/5.jpg)
5
KRIs & Management LevelsBasic Concepts
Location KRI Type Management Level
Local Individual Lower/Mid-Level
Organization Composite Mid-Level/Senior
![Page 6: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/6.jpg)
6
KRIs & Management LevelsBasic Concepts
Location KRI Type Management Level
Local Individual Lower/Mid-Level Transformation – apples to apples
Aggregation – flagging what should be flagged
Organization Composite Mid-Level/Senior
![Page 7: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/7.jpg)
7
Individual KRI ThresholdsBasic Concepts
Junior management is managing the risk; no mid-level attention required
Junior management is managing the risk; mid-level management should monitor the indicator
Management should escalate from junior to mid-level management
![Page 8: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/8.jpg)
8
Composite KRI ThresholdsBasic Concepts
Mid-level (or junior) management is managing the risk; no senior attention required
Mid-level management is managing the risk; senior management should monitor the indicator
Management should escalate from mid-level to senior management
![Page 9: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/9.jpg)
9
Ranges of Individual KRIsBasic Concepts
Low Low Exected High HighUnderlying KRIs Red Yellow /Target Yellow Red
L1 L0 E H0 H1
Staff Turnover (%) 1 3 8 14 20Staff Training Days (days/year) 4 8 15 na na
![Page 10: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/10.jpg)
10
Ranges of Individual KRIsBasic Concepts
Low Low Exected High HighUnderlying KRIs Red Yellow /Target Yellow Red
L1 L0 E H0 H1
Staff Turnover (%) 1 3 8 14 20Staff Training Days (days/year) 4 8 15 na na
L0L1 H1H0E
![Page 11: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/11.jpg)
11
Ranges of Individual KRIsBasic Concepts
Low Low Exected High HighUnderlying KRIs Red Yellow /Target Yellow Red
L1 L0 E H0 H1
Staff Turnover (%) 1 3 8 14 20Staff Training Days (days/year) 4 8 15 na na
L0L1 H1H0E
Typically, KRIs go: red-yellow-green-yellow-red or red-yellow-green or green-yellow-red
![Page 12: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/12.jpg)
12
Basic Concepts
Individual KRIs
Staff Turnover
0
5
10
15
20
25
1 5 9 13 17 21 25 29 33 37 41 45
Months
Perc
ent
Training
02468
10121416
1 5 9 13 17 21 25 29 33 37 41 45
Months
Ave
rage
day
s in
last
12
mos
![Page 13: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/13.jpg)
13
Basic Concepts
Individual KRIs
Staff Turnover
0
5
10
15
20
25
1 5 9 13 17 21 25 29 33 37 41 45
Months
Perc
ent
Training
02468
10121416
1 5 9 13 17 21 25 29 33 37 41 45
Months
Ave
rage
day
s in
last
12
mos
The ranges and measures are very different before we transform the KRIs
![Page 14: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/14.jpg)
14
Basic Concepts
Individual KRIs
Staff Turnover
0
5
10
15
20
25
1 5 9 13 17 21 25 29 33 37 41 45
Months
Perc
ent
Training
02468
10121416
1 5 9 13 17 21 25 29 33 37 41 45
Months
Ave
rage
day
s in
last
12
mos
The thresholds are very different too
![Page 15: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/15.jpg)
15
Agenda
Basic Concepts
Transforming Individual KRIs
Creating a Composite Indicator
Senior Management Reporting
![Page 16: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/16.jpg)
16
Transformation to T-ValueTransforming Individual KRIs
T-V
alue
KRI L0L1 H1H0
1
2
The graphic presentation of the transformation
![Page 17: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/17.jpg)
17
Transformation to T-ValueTransforming Individual KRIs
T-V
alue
KRI L0L1
1
2
The graphic presentation of the transformation for a red-yellow-green KRI
![Page 18: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/18.jpg)
18
Transformation to T-ValuesTransforming Individual KRIs
T = 1 when L0< KRI < H0
T = (KRI + L1 – 2*L0 )/ (L1 – L0) when KRI < L0
T = (KRI + H1 – 2*H0)/(H1 – H0) when KRI > H0.
The algebraic presentation of the transformation
![Page 19: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/19.jpg)
19
Individual KRIs: T-ValuesTransforming Individual KRIs
Staff Turnover T-value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9 13 17 21 25 29 33 37 41 45
Months
T-Va
lue
Training T-Value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9
13 17 21 25 29 33 37 41 45
Months
T-Va
lue
The transformed ranges and measures are now the same
![Page 20: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/20.jpg)
20
Individual KRIs: T-ValuesTransforming Individual KRIs
Staff Turnover T-value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9 13 17 21 25 29 33 37 41 45
Months
T-Va
lue
Training T-Value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9
13 17 21 25 29 33 37 41 45
Months
T-Va
lue
And so are the thresholds
![Page 21: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/21.jpg)
21
Individual KRIs: T-ValuesTransforming Individual KRIs
Staff Turnover T-value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9 13 17 21 25 29 33 37 41 45
Months
T-Va
lue
Training T-Value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9
13 17 21 25 29 33 37 41 45
Months
T-Va
lue
Does this work really? Three ranges of months are red in the two graphs …
![Page 22: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/22.jpg)
22
Individual KRIsTransforming Individual KRIs
Staff Turnover
0
5
10
15
20
25
1 5 9 13 17 21 25 29 33 37 41 45
Months
Perc
ent
Training
02468
10121416
1 5 9 13 17 21 25 29 33 37 41 45
Months
Ave
rage
day
s in
last
12
mos
… exactly as they were for the untransformed KRIs. So it does work!
![Page 23: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/23.jpg)
23
Individual KRIs: T-ValuesTransforming Individual KRIs
Staff Turnover T-value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9 13 17 21 25 29 33 37 41 45
Months
T-Va
lue
Training T-Value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9
13 17 21 25 29 33 37 41 45
Months
T-Va
lue
So, now we can combine “apples” to “apples.”
![Page 24: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/24.jpg)
24
Agenda
Basic Concepts
Transforming Individual KRIs
Creating a Composite Indicator
Senior Management Reporting
![Page 25: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/25.jpg)
25
Senior Management Focus
Are many small things going slightly wrong in (one or related) area(s)? Are any things going gravely wrong in any (unrelated but similar) areas?
![Page 26: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/26.jpg)
26
Basic DistinctionsCreating a Composite Indicator
Related indicators reflect factors that compound one another in their influence on a common underlying risk
Eg: staff turnover and training
Unrelated indicators reflect factors that do not impact one another
Eg: staff turnover in London and staff turnover in Sydney
![Page 27: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/27.jpg)
27
Basic PrinciplesCreating a Composite Indicator
Related T-Values indicators we combine by “multiplying” them:
NB: green x green = green, because 1 x 1 = 1. yellow x yellow can equal yellow or red, because yellows on average between 1 and square root 2 multiply to less than 2, and yellows on average above square root 2 multiply to more than 2
Unrelated T-Values we combine by taking the “maximum”:
NB: then the combined indicators tells us if anything really serious is happening in any of the covered areas
![Page 28: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/28.jpg)
28
RefinementsCreating a Composite Indicator
We should be able to:
Weight the influence of different individual KRIs differently
adjustable weights for each T-Value
Adjust the overall composite indicator to reflect how closely and how soon senior management wants to be alerted to issues – their appetite for risk. (We want “red” to be “higher” for senior management than for middle management: how much higher?)
scaling parameters that affect the thresholds up and down and the sensitivity of the composite to changes in the weighted underlying T-Values
![Page 29: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/29.jpg)
29
Individual KRIs: T-ValuesCreating a Composite Indicator
Staff Turnover T-value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9 13 17 21 25 29 33 37 41 45
Months
T-Va
lue
Training T-Value
0.0
0.5
1.0
1.5
2.0
2.5
1 5 9
13 17 21 25 29 33 37 41 45
Months
T-Va
lue
The two component individual KRIs …
![Page 30: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/30.jpg)
30
Aggregation FormulaeCreating a Composite Indicator
Related I = max [1, a * [T(1)w(1) * T(2)w(2)]b]
Unrelated I = max [1, a * max [T(1)w(1), T(2)w(2)]b]
where I = composite indicatorT(i) = the ith individual KRIw(i) = the ith KRI weight, Σw(i) = 1, i = 1,2a and b = “appetite” parameters
It is straightforward to generalize to more than 2 indicators
![Page 31: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/31.jpg)
31
Staff Quality IndexCreating a Composite Indicator
0.0
1.0
2.0
3.0
4.0
5.0
6.0
7.0
1 4 7 10 13 16 19 22 25 28 31 34 37 40 43 46
Months
T-Va
lues Turnover
Training
SQI
a = 0.2b = 1.2w(1) = 2w(2) = 2
... And the Composite Staff Quality Index (SQI)
![Page 32: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/32.jpg)
32
Adjusting Appetite and WeightsCreating a Composite Indicator
0.0
1.0
2.0
3.0
4.0
5.0
6.0
7.0
1 5 9 13 17 21 25 29 33 37 41 45
Months
T-Va
lue a = 0.2
b = 1.2w(1) = 2w(2) = 2
0.0
0.5
1.0
1.5
2.0
2.5
3.0
1 5 9 13 17 21 25 29 33 37 41 45
Months
T-Va
lue a = 0.2
b = 0.9w(1) = 2w(2) = 2
6 – 8, 19, 23 - 24 6 - 8
0.0
0.5
1.0
1.5
2.0
2.5
3.0
1 5 9 13 17 21 25 29 33 37 41 45
Months
T-Va
lue
a = 0.2b = 0.6
w(1) = 5w(2) = 1
7 - 10
![Page 33: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/33.jpg)
33
Agenda
Basic Concepts
Transforming Individual KRIs
Creating a Composite Indicator
Senior Management Reporting
![Page 34: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/34.jpg)
34
The One-Page SummarySenior Management Reporting
Staff Quality Index ___ Audit Issue Management Index ___
Business Continuity Index ___ Failed Customer Interactions Index ___
Information Security Index ___ Information Technology Index ___
Operational Losses ___Process Breaks Index ___
Profitability Index ___Policy Exceptions Index ___
Regulatory Index ___Change Management Index ___
EuropeNorth AmericaAsia
Trading and Sales Payments and Settlement Retail BankingBrokerage
Maybe the trading and sales business in North America is growing too fast? Drill down and see…
![Page 35: Composite indicators](https://reader037.vdocuments.us/reader037/viewer/2022100309/54987be2ac79591d2e8b5659/html5/thumbnails/35.jpg)
35
Enter Presentation Title Here
Composite Indicators
&
Senior Management ReportingLondon
January 17th & 18th, 2006
Charles Taylor
Director, Operational Risk