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.

Open

Figure 1.1

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.

Open

Figure 2.1

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, 

If the internal setting ‘Enable Action Budget on Adhoc Calculation' is switched OFF, 

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;

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.