PremiumAmountPremiumRate

The PremiumAmountPremiumRate actions are typically overtime actions. When creating a PremiumAmountPremiumRate action, you must specify an amount. The amount is either an hourly rate or an annual rate, depending on whether the position is hourly or annual.

You can also specify the number of hours or an FTE value, depending on whether the position is hourly or annual. If you do not specify the number or hours or an FTE value, base hours or base FTE values are used for calculations.

Calculation formulas

For hourly positions, the formula for calculating a PremiumAmountPremiumRate action for a specific period is:

Period value = Rate for this period x Action hours x Number of pay periods x Phasing factor for this period

For annual positions, the formula for calculating a PremiumAmountPremiumRate action for a specific period is:

Period value = Rate for this period x Action FTE x Phasing factor for this period

When setting up a benefit of this type, you must specify a Based-on benefit that must be either a PremiumAmountBaseRate or a PremiumPercentBaseRate benefit. Rate for this period is calculated by adding the action amount to the Based-on benefit rate. This calculation must account for the fact that the Based-on benefit rate changes over time.

You can see examples of how the based-on benefit rate is calculated.

Example 1: PremiumAmountPremiumRate calculation for an hourly position

This example shows the PremiumAmountPremiumRate calculation for an hourly position with these settings:

  • Number of pay periods: 12
  • Phasing method: Even

    For each period, the phasing factor is 1/12.

  • This table shows the PremiumAmountPremiumRate action details:
    Start date End date Amount Hours
    2/15/16 9/15/16 $6 4
  • This table shows the Based-on rates and their start and end dates:
    Start date End date Based-on rate
    1/1/16 4/15/16 $10
    4/16/16 6/15/16 $12
    9/1/16 None $14

This table shows the action calculations for February through September:

Month Calculation of rate for this period Rate for this period

Period value

Result
Feb 14/28 x ($10 + $6) $8 $8 x 4 x 12 x 1/12 $32
Mar 31/31 x ($10 +$6) $16 $16 x 4 x 12 x 1/12 $64
Apr (15/30 x ($10 + $6)) + (15/30 x ($12 + $6)) $17 $17 x 4 x 12 x 1/12 $68
May 31/31 x ($12 +$6) $18 $18 x 4 x 12 x 1/12 $72
Jun 15/30 x ($12 + $6) $9 $9 x 4 x 12 x 1/12 $36
Jul Action not calculated for July because of the missing value of the based-on benefit in July.
Aug Action not calculated for August because of the missing value of the based-on benefit in August.
Sep 15/30 x ($14 + $6) $10 $10 x 4 x 12 x 1/12 $40

Example 2: PremiumAmountPremiumRate calculation for an annual position

This example shows salary calculation for an annual position with these settings:

  • Phasing method: Even

    For each period, the phasing factor is 1/12.

  • This table shows the amount, FTE, and the corresponding start and end dates for the action:
    Start date End date Amount FTE
    2/15/16 9/15/16 $60,000 1
  • This table shows the based-on benefit rates for the indicated date ranges:
    Start date End date Based-on rate
    1/1/16 4/15/16 $100,000
    4/16/16 6/15/16 $120,000
    9/1/16 None $140,000

This table shows the action calculation for February through September:

Month Calculation of rate for this period Rate for this period Period value Result
Feb 14/28 x ($100,000 + $60,000) $80,000 $80,000 x 1 x 1/12 $6,666.67
Mar 31/31 x ($100,000 +$60,000) $160,000 $160,000 x 1 x 1/12 $13,333.33
Apr

(15/30 x ($100,000 + $60,000)) +

(15/30 x ($120,000 + $60,000))

$170,000 $170,000 x 1 x 1/12 $14,166.67
May 31/31 x ($120,000 +$60,000) $180,000 $180,000 x 1 x 1/12 $15,000.00
Jun 15/30 x ($120,000 + $60,000) $90,000 $90,000 x 1 x 1/12 $7,500.00
Jul Action not calculated for July because of gap in the based-on benefit.
Aug Action not calculated for August because of gap in the based-on benefit.
Sep 15/30 x ($140,000 + $60,000) $100,000 $100,000 x 1 x 1/12 $8,333.33