How does the Budget traffic light in Implementation Budget object work?
The Budget traffic light in the Implementation Budget object depends on the threshold values configured in your environment. The threshold values can be configured via the Configuration > Budget Threshold page in Camms.Strategy.
Note: If your environment does not have the Camms.Strategy product, then the system will calculate the budget performance using pre-defined threshold values.
There are two main methods in setting the budget threshold. i.e.; considering the exact value of the variance(Define as Exact Value) and considering the variance percentage(Define as Percentage).
Define as Percentage
If the method selected by the administrator is 'Define as Percentage', then the performance will be based on the Variance % value in the Implementation Budget object, which is calculated by the formula mentioned below;
If YTD Budget = 0,
Variance %= 100
If YTD Budget != 0,
Variance % = ((YTD Budget – YTD Actual)/YTD Budget) *100
If YTD Actual =0,
Variance % = 100
The calculated value is then compared with the budget threshold values set in the Administrative Tools > Budget Thresholds page as follows;
If the internal setting ‘Enable Action Budget On Adhoc Calculation' is switched ON,
Variance % < Lower Exception OR Variance % > (- Lower Exception) | On Track |
Lower Exception =< Variance %=< Upper Exception OR (-Upper Exception) =< Variance %=< (-Lower Exception ) | Monitor |
Variance % > Upper Exception OR Variance % < (-Upper Exception) | Off Track |
If the internal setting ‘Enable Action Budget On Adhoc Calculation' is switched OFF,
Variance % < Lower Exception | On Track |
Lower Exception =< Variance %=< Upper Exception | Monitor |
Variance %> Upper Exception | Off Track |
Example 1: Consider the following thresholds set in the environment;
If the ‘Enable Action Budget On Adhoc Calculation' internal setting is turned ON by the administrator in your environment, the Budget traffic light works for the budget thresholds configured in the above image as mentioned below;
On Track -> Variance % < 10 OR variance % > -10
Monitor -> 10= <variance %=<20 OR - 20= <variance %=< -10
Off Track -> Variance % >20 OR variance % < -20
The below image illustrates the traffic light colours and the respective variance % values.
If the ‘Enable Action Budget On Adhoc Calculation' internal setting is turned OFF by the administrator in your environment, the Budget traffic light works for the budget thresholds configured in the above image as mentioned below; .
On Track -> Variance % < 10
Monitor -> 10= <variance %=<20
Off Track -> Variance % >20
Define as Exact Value
If the method selected by the administrator is 'Define as Exact Value', then the performance will be based on the Variance value in the Implementation Budget object, which is calculated by the formula mentioned below;
Variance = YTD Budget – YTD Actual
This calculated value is then compared with the budget threshold values set in the Administrative Tools > Budget Thresholds page as follows;
Variance < Lower Exception | On Track |
Lower Exception =< Variance =< Upper Exception | Monitor |
Variance> Upper Exception | Off Track |
The internal setting ‘Enable Action Budget On Adhoc Calculation' is not applicable when the method selected by the administrator is 'Define as Exact Value'.
Example 2: Consider the following thresholds set in the environment;
The Budget traffic light works for the budget thresholds configured in the above image as mentioned below;
On Track = Variance < 10,000
Monitor = 10,000= < Variance =<25,000
Off Track = Variance >25,000
The below image illustrates the traffic light colours and the respective variance values.
The Budget traffic light will be displayed in 'Blue' colour in the scenarios below;
No budget values have been entered in any of the reporting years in the Implementation Budget object
No implementation budget object in the project's workflow
Budget YTD or Variance is NULL