YTDRanges
This section describes how the YTDRanges calculation type is calculated. When setting up a benefit of
this type, you must specify one or more YTD ranges. A single YTD range consists of a low
YTD value, a high YTD value, and a percentage that applies to YTD values in the range.
You must specify one or more based-on benefits. The calculations are done by applying
the ranges to the YTD sum of the values of the based-on benefits.
You can also specify an annual cap, that is, the maximum amount that can be applied over the course of a year. The cap can be based on the calendar year or the fiscal year.
This calculation type is not prorated to avoid double proration in the case that the based-on benefit is prorated.
Example: YTDRanges calculation
This example shows how a YTDRanges action is calculated.
This table shows the start and end date for the YTDRanges action:
| Start date | End date |
|---|---|
| 1/1/17 | 2/28/17 |
This table shows the low and high values and their corresponding percentages:
| Low value | High value | Percent |
|---|---|---|
| 10,000 | 20,000 | 10% |
| 20,000 | 40,000 | 15% |
| 45,000 | 50,000 | 20% |
This action is based on two benefits, Benefit A and Benefit B. This table shows the corresponding values for each based-on benefit:
| Benefit | Jan 2017 | Feb 2017 | Mar 2017 |
|---|---|---|---|
| Benefit A | 0 | $11,000 | $15,000 |
| Benefit B | 0 | 0 | $21,000 |
| Total Periodic | 0 | $11,000 | $36,000 |
| Total YTD | 0 | $11,000 | $47,000 |
This table shows the calculation results for this action:
| Month | Calculation | Result |
|---|---|---|
| Jan | 0 | 0 |
| Feb | ((11,000 – 10,000)x10%) | $100 |
| Mar | ((47,000– 45,000) x 20% + (40,000 – 20,000) x 15% + (20,000 – 11,000) x 10%) | $4,300 |