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