General increase calculation

The detailed planning General increase calculation applies up to six increases at predefined dates using percentage rates.

The increase date is based on a valid member of the Time dimension. The increases are calculated cumulatively over time. Both the increase period and percentage can be set to be adjustable by users with the appropriate security settings.

 Note:   All increase calculations ignore each other unless the Source value is a value from another "increase calculation" (for example, Anniversary increase). If you want to model increases as cumulative with each other, you must link the calculations. Typically in building a model you link your increase calculations, having them return the gross amount and using each other as a Source value, so that each increase affects the values of all other increases.

Any increases (with a time period) that occur outside the scenario time scope are ignored. Any increases that are outside the calculation time scope but within the scenario time scope, the results are calculated for the entire scope of the scenario and then the results are truncated to fall within the calculation time scope.

The General increase calculation is similar to Anniversary increase but instead of being based on reference data, the General increase calculation can be based on any time period that is adjustable.

Parameters

  • Source value: Select Value to enter a numeric value; selecting any of the other options presents a list of the currently defined objects of that type. The options are Value, Attribute, Calculation, and Global Vector.
  • Return gross amount: By default is selected. Is non-adjustable.
  • Time period Set by selecting a Time dimension member. No increase is calculated for a Time period that remains Not defined. To allow end users to edit the time period, select Adjustable.

  • % Increase The percentage value of each increase. You are allowed to leave this field empty. The format is always a percent, with two decimal places.

     Note:  All increases are cumulative within the calculation: if there is a second increase, it is based on the result of the first increase, a third is based on the result of the second, and so on.

    To allow end users to edit the percentage increase amount, select Adjustable.

Example

In the following example, the increases are set for January and July of each of three years, starting in 2017. (The results are shown rounded to two decimal places, but within the calculation nothing is rounded). For comparison, the effect of Return gross amount, both enabled and disabled, is shown.

  Dec2017 Jan2018 ... July2018 ... Jun2019 July2019
Base Salary 10,000 10,000 10,000 10,000 10,000 10,000 10,000
% Increase   +5%   +5%   +5.2% +5.2%
Calculation Result with Return gross amount
 0 500 500 1,025 1,025 1,598.30 2201.41
Calculation Result without Return gross amount 10,000 10,500 10,500 11,025 11,025 11,598.30 12,201.41