Strategy Configuration – Budget Threshold

You can define budget thresholds (on track figure and off-track figures) using this option. This is currently used for defining the threshold for Budget Traffic Lights both within the system and in standard reports. You can choose to define the thresholds either via a percentage or exact value by selecting one of the options provided.

• STEP 1: To do this, go to Administration > Configuration> Budget Threshold.

Open

Figure 1.1

• STEP 2: Select your preferred option and enter ‘On track’ and ‘Off Track’ figures.

  • Define as percentage: Enter percentage values between 0 and 100 for On Track and Off Track cells

  • Define as Exact Value: Enter any integer values for On Track and Off Track cells.

• STEP 3: Click the save icon.

  • If a Budget has not been entered, a blank traffic light will be displayed.

  • If Budget = 0 but Actual > 0, traffic light will be green.

If Exact value selected

YTD Variance = YTD Budget – YTD Actual

When Income is recorded with (-), reverse income budget and actual figures to (+) when calculating the variance.

If Percentage value selected

YTD Variance% = ((YTD Budget – YTD actual)/YTD Budget) *100

Open