Project Implementation Budget
This article contains: |
See how to configure this object under Project Workflows under this admin guide: Configuring Project Implementation Budget.
1. Overview |
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.
2. 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).
2.1 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
2.2 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.
View other articles under this section: |