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 via a percentage or exact value by selecting one of the options provided.

STEP 1: To do this, go to Administration > interplan® Configuration > Budget ThresholdWrench> System Configuration> Budget Threshold.

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

Variance < Lower Exception	Off Track
Lower Exception =< Variance =< Upper Exception	Monitor
Upper Exception < Variance	On Track

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

Variance % < Lower Exception	Off Track
Lower Exception =< Variance %=< Upper Exception	Monitor
Upper Exception < Variance%	On Track

Last revised: September 23, 2018