Anniversary increase calculation

The detailed planning Anniversary increase calculation applies increases to employee salaries based on anniversary dates.

The Anniversary increase calculation behaves differently from General increase because it is always based on a reference date, which in turn depends on a date attribute.

A single Anniversary increase calculation can contain up to six anniversaries. The calculated amount is cumulative over time, meaning the second anniversary calculation includes the prior anniversary amount. However, if two separate Anniversary increase calculations are applied in the same plan , their results are not cumulative.  

 Note:   All increase calculations ignore each other unless the Source value is a value from another "increase calculation." If you want to model increases as cumulative with each other, you must link the calculations. Typically in building a plan 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.

Anniversary increases are always calculated for the entire scope of the scenario and the results are later truncated to the calculation Start period and End period. For employees that start after the scenario starts, this results in no increase to their salaries, because their salary is zero before the Start period. For other uses of this calculation type, the calculation should correctly increase the Source value, regardless when an employee starts.

Parameters

The calculation has the following 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, Global Vector.
  • Reference date: Used to select the time period in each year when the anniversary increase is applied. For example, if the Reference Date selected is the month of February, the anniversary increase is applied in February each year.
    • Attribute: A date defined in an attribute.
    • Value: A user-defined date.
  • Return gross amount: Returns the source amount and the increase amount. Turned on by default. To have the calculation only return the increase amount (net), clear the check box. Is non-adjustable.
  • Scenario year: Select the check box for each anniversary you want the calculation to include. The first anniversary is the referenced time period as it appears in the first year of the scenario. 

  • % 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. 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 calculation uses a Reference date of February each year, and increases Base Salary by 2%. For comparison, it also shows the effect of Return gross amount on/off.

  Jan2107 Feb2017 Mar2017 ... Jan2018 Feb2018 Mar2018
Base Salary 10,000 10,000 10,000 10,000 10,000 10,000  
% Increase   +2%       +2%  
Calculation Result (Return gross amount OFF) 0 200 200 200 200 404 404
Calculation Result (Return gross amount ON) 10,000 10,200 10,200 10,200 10,200 10,404 10,404