When a project is implemented and in progress, the Project Implementation Budget object allows you to review the current budget information for the project. It is determined by; 

  • Linking the action in planning side to accounts from your financial system through a financial integration.
  • The project account mapping through a financial integration
  • Manually adding budget details

The drill down option allows you to obtain a breakdown of figures for each of the elements as shown below:

Simply click on the arrow key against the row, in order to get a detail view.


Budget Traffic Light Calculation
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