Percent
This action type supports taxes or other costs expressed as a percentage.
This action type must have a Based On selection.
When this action is applied, a percentage value must be specified. You can specify a positive or negative value.
This action type can apply to a single period or spread across the budget year.
This action type can calculate by fiscal year or calendar year.
You can define ranges for this action type.
Example
Percent = 6% (Based on Total
Compensation)
Total Compensation (period 3) =
$1000
Number of leaf periods = 12This is the calculation rule when the action is applied across the budgeting periods:
Percent * Based on action group amount for the current
period
6% * $1000 = $60 = Period 3 amount
This is the calculation rule when the action is applied to a single period:
Percent * Based On action group amount for the current period *
Number of leaf periods
6% * $1000 * 12 = $720 = Period 3 amount
Percent actions do not include spread ratio in the calculation. The spread ratio is already included in any action the Percent action is based on.
Percent actions do not include partial month proration based on action start date. Percent actions defined to apply across the budget periods and assigned partway through the period will calculate based on the action group for the entire period. Percent actions defined to apply in a single period and assigned partway through the period will calculate based on the annualized action group amount for the entire period. Best practice recommendation is to assign all actions on the first day of the period to insure the action group amount does not contain prorated actions which are annualized.
If a Percent action is defined to calculate based on salary with the given range:
| Percent | Start | End |
|---|---|---|
| 5 | 0 | 25,000 |
| 4 | 50,000 25,000 | |
| 3 | 50,000 |
Given that the annualized salary for the period is 30,000 and the above action is applied to an assignment, the action calculates as follows depending on the type selected.
(25,000 * 5%) + [(30,000 - 25,000) * 4%] = 1,450
Because the YTD salary is greater than 25,000 the first portion is calculated by multiplying the end of the range times the defined percent for that range.
The second portion is calculated by determining the difference between the smaller of the range end or the YTD salary and the previous range end. Since 30,000 is smaller than the range end, the previous range end (25,000) is subtracted from 30,000 and that result is multiplied by the defined percent for that range.
Then the two portions are added to determine the final result.