Organisation Details – Key Risk Indicators

Note: The user will be able to add KRIs by navigating to the Key Risk Indicators section.

STEP 1: Navigate to Menu > Administration > Key Risk Indicators. If you have Camms.Strategy, this will pull through the list of KPIs added and available from Camms.Strategy as well. Any KPI/KRIs added/updated from either side will be synced with the other side as well.

STEP 2: You can search the Key Risk Indicator you are looking for by either using the 'Search' entering the KRI title/responsible officer/reporting period as per the option you select from the dropdown list available below.

STEP 3: Add the details of the project and click on the 'Add' button to define a new KRI.

Below details can be added for a KRIs.

Field

Description/Instruction

Mandatory/Optional

Title

The title of the KPI/KRI. This will be a hyperlink and upon clicking will navigate the user to the KPI/KRI details area in Camms.Strategy if you have Camms.Strategy

Mandatory

Responsible Officer

Select from the pre-defined ‘STAFF’ records in the drop down list. The person selected here will be the one that is responsible for the KPI/KRI.

Mandatory

Unit

Unit of measurement for the KPI/KRI.

Enter a unit of measurement by clicking on the drop down list ‘Unit’ and select the most suitable option.

Examples include number, percentage, days, and currency. This is the ‘Y’ axis of the KPI graph.

Note: Not Applicable for Camms.Risk standalone users.

Mandatory

Period

The Period of the KPI/KRI on which it is being reported on.

Select a period which indicates how often you want to measure this indicator.

For example, is it Monthly, Quarterly or Annually? It is important that this is chosen correctly in the first instance as it cannot be modified once created.

Note: Not Applicable for Camms.Risk standalone users.

Mandatory

Aggregation

The method of aggregation for the KPI/KRI.

Choose your aggregation method from the available options: cumulative, normal and average.

Cumulative will result in the system summing up values based on the time frames selected.
Normal will return the figure for the last closing reporting period within the selected time frame.
Average will display data as an average of the period of analysis.

IMPORTANT: If you have changed the KPI aggregation at any time after setting it up, you will need to re-save the targets and actuals tab (re-save the current data) in order for the calculations to be refreshed and reflect correctly within other screens/reports, etc.

Note: Not Applicable for Camms.Risk standalone users.

Mandatory

Calculation Method

The method of performance calculation for the KPI/KRI.

The calculation method for the KPI determines the rules behind the traffic light reporting. You can choose Less is Better, More is Better or Goal Post.

Note: Not Applicable for Camms.Risk standalone users.

KPI Calculations

Calculation Method

Description

Formula

Less is Better

Where it is desirable to get the lowest possible value for the KPI Actual

Where a result lower in value to the target will result in a green light

Example: Interest ratio (interest on borrowings/total expenditure)
Target 10% | Actual 8%

If (Target = 0)

If (Actual <= 0) then 100

Else 0

If ( Target > 0

1 – (Actual/Target) + 1

Else

Actual/Target

More is Better

Where it is desirable to get the highest value possible for the KPI Actual

Where a result higher in value to the target will result in a green light

Example: Customer Satisfaction
Target 85% | Actual 95

If (Target = 0)

If (Actual >= 0) then 100

Else 0

Else

Actual/Target

Goal Post

Where it is desirable to get the KPI Actual around the Target value within the Variance

Where achievement of the target results in a green light

Example: Achievement of Budget
Target $3,000,000 ± 5% | Actual $2,950,000

If Actual < LB then: (Actual/LB)

If Actual > UP then: LB-(Actual – UB)/LB

UB (Upper Boundary) = Target +(Target*Variance/100)

LB (Lower Boundary) = Target - (Target*Variance/100)

The below table explains how the calculations are reflected in traffic lights, which uses different colours to denote the performance.

Calculation Method	Green	Amber	Red
Less is Better	Performance >= 100	(100 - Variance) >= Performance < 100	Performance < (100 - Variance)
More is Better	Performance >= 100	(100 - Variance) >= Performance < 100	Performance < (100 - Variance)
Goal Post	Performance = 100	N/A	Performance <> 100

Mandatory

Time Horizon

The Time Horizon dropdown lets you choose how the KPI graphs and values are displayed.

This is an optional field which can be activated by CAMMS if requested as part of your Scoping Day. There are three options: YTD, Period and Rolling. If not activated, the Time Horizon will default to Period.

There are three options YTD, Period and Rolling.

YTD will always show beginning of the financial year to Date To chosen, regardless of Date From selected.
Example 1: YTD KPI; Period - Monthly, Aggregation - Cumulative

Month	Target	Actual
July	10	5
August	30	3
September	20	4
October	10	3
November	20	20

If Date From = 1/7/08 and Date To = 30/11/08 the calculation would ignore Date From (as it is a YTD KPI), and therefore calculate it as July+Aug+Sept+Oct+Nov.

2. Period will always show the period Date From and Date To.
Example 2: Period KPI; Period - Monthly, Aggregation - Cumulative

Month	Target	Actual
July	10	5
Aug	30	3
September	20	4
October	10	3
November	20	20

If Date From = 1/8/08 and Date To = 30/11/08, the calculation would be just for those months (August + September+ October+ November)

3. Rolling is a time period for the KPI for when it cumulates or averages, e.g. 5 month cumulative KPI would display as follows:

Period 6 shows the sum of period 2 to period 6 (5 periods)

Period	Target	Variance	Actual	Rolling 5 months Actual
1	100	10	91	91
2	100	10	61	152
3	110	10	92	244
4	111	10	100	344
5	120	10	150	494
6	100	10	120	523
7	180	10	60	522
8	50	10	70	500
9	90	10	90	490
10	100	10	100	440
11	100	10	87	407
12	100	10	95	442
13	98	10	92	464
14	97	10	95	469
15	96	10	97	466

Optional

Description

The detailed description of the KPI/KRI

Optional

The new KPI/KRIs will appear on the left-hand side of the screen and further let you link the same with risks within the application.

View other articles under this section:

<< Back to main section
Organisation Details

Table of Contents