This article will introduce you to ICG's 'KPI Chart' which is a simple and effective feature that allows you to instantly provide a graphical representation of your data.More >
This article provides a step-by-step guide for logging into ICG.More >
This article will show you how to create a KPI.More >
This article will show you how to insert data for a KPI.More >
This article will show you how to set tolerance ranges for your KPIs.More >
Setting Tolerance ranges
This article will show you how to set 'Tolerance Ranges' for 'Forecast KPIs'.
Setting Tolerance Ranges
For Period KPIs, you need to define Tolerance 'Ranges' to define the point at which the result is acceptable.
This involves using the colour scale under 'Indicator Type'
(This is different to Process KPIs where you define 'Upper and lower ranges' )
The Colour Scale
The left side of the scale is your 'Actual' against your 'Process Range'.
This is represented by the KPI Bubbles on the Dashboard.
The right side of the scale is your 'Forecast' against your 'Budget'
This is represented by the Client Range Boxes on the right of the Dashboard.
Variable - Forecasted
'Variable - Forecasted' uses your forecast for the month to calculate the Tolerance range.
Using the scale below, if your forecast is 200 for the month, and the Actual is 194, the bubble will be green.
This is because the Actual is > Not more than 10% above the forecast to become blue.
> Not less than -5% to become yellow.
'Variable Forecasted' is particularly useful if the values are high because of its simplicity.
Tip : You do not need to a value in the 'Reference Value'
Variable - Minimum
If your forecast is sometimes very low, the tolerance range will be very tight and therefore not be very meaningful.
Therefore to combat this, we can set a 'minimum' value.
For instance, if our forecast was 10, less than our Minimum of 90, the Minimum value will be used to calculate our Tolerance Ranges
Using the example below, the 'blue tolerance' would be anything above 9.
If our Forecast was 200 for the month (which would be higher than the minimum value) the Forecast would be used to calculate the Tolerance Range (Same as Variable-Forecasted)
Therefore, this is the recommended option to use.
Unlike 'Variable Forecasted' and 'Minimum', 'Fixed' does not use the forecast to calculate the Tolerance ranges.
Instead it uses the same 'Fixed' number each month.
To work out the ranges, you simply divide the Fixed value (which you insert in the 'Reference value' box) by the numbers in the colour scale.
For instance, if your Fixed Value is 80, any result will turn blue if the 'Actual' is 8% above your forecast.
If your Actual is 10, it will be more than -20% outside of your forecast and therefore it will turn red.
Fixed is particularly useful if your forecast does not fluctuate too much due to its simplicity.