[Reports & Analytics (CLASSIC)] DRAFT: Standard Report - Healthcare Exposure Analysis

As of Date

This date is used to collect data for Trending pie chart

Supplier

All available suppliers

Look Back Date

Select a data to collect look back data

Hour Type

ALL | FT

Show data for FT employees (>= 30 Hours per week) only or All employees

Gross Up Tax %

User input value

Used to calculate Max Penalty

Participation Rate

User input value

Used to calculate Max Penalty

Percent FT Subsidy

User input value

Used to calculate Max Penalty

Preferred Look Back Period

Used to calculate FT Equivalent count

Employee Contribution

User input value

Used to calculate Max Penalty

Employer Contribution

User input value

Used to calculate Max Penalty

There are different sections in the Healthcare Exposure Analysis report

Total Liability

This is a bar diagram which shows no of FT (Full time) employees and FT Equivalent employees

X – Axes

Number of Employees

This bar is divided into 2 portions: FT Employees (Blue) and FT Equivalent Employees (Green)

FT Employees: Employees who have worked for more than 30 hours per week

FT Equivalent: Number of Employees that would equate to a Full time employee from non-full time employees.

This number is calculated as: Total Hours of non-full time employees / (120 * Look Back period)

e.g.: If there are four employees; E1 works for 32 hours, E2, E3 and E4 works for ten hours each, then number of FT Employees = 1 and No of FT Equivalent employees = 3 as E2, E3 and E4 would work for 30 hours as one FT employee together.

Y – Axes

Look Back Period (3,6,9,12)

If there are no FT employees for period of 12 months, then the 12 month look back data is not shown even if there are non-FT employees

Trending to Full Time as

This is a pie chart which shows what portion of employees have worked against the threshold Hours. Threshold hours = 1560 hours ie: an employee’s total hours worked is what percent of 1560. [1560 by ACA]

There can be at max 5 sectors in a pie chart:

1.        Trending 25 Percent [Total Hours is between 25 to 50 percent of 1560]

2.        Trending 50 Percent [Total Hours is between 50 to 75 percent of 1560]

3.        Trending 75 Percent [Total Hours is between 75 to 90 percent of 1560]

4.        Trending 90 Percent [Total Hours is between 90 to 100 percent of 1560]

5.        Trending FT [Total Hours is above percent of 1560]

The numbers shown on pie chart are the actual number of employees that belong to a particular percent group

No Plan option

Look Back Period

Look Back period month number (3,6,9,12)

Max Penalty

If FT Employee count <= 80, then Max Penalty = 0

If FT Employee Count > 80, then Max Penalty = ((FT Employees – FT Allowances) * No Plan Penalty ) * Gross Up Tax

Where FT Allowances = 80 (set default)

             No Plan Penalty = Annual Penalty Amount Value set in Config Option under Category = Healthcare and Property = PenaltyAnnualAmount

             Gross Up Tax = Value passed in “Gross Up Tax %” parameter

Max Cost

Max Penalty / Total Hours

Employee Only Contribution Plan

Look Back Period

Look Back period month number (3,6,9,12)

Exposure

(FT Employee Count * PCT FT Sub / 100 ) * Subsidy Penalty

Where PCT FT Sub = Value passed in “Percent FT Subsidy” parameter

             Subsidy Penalty = Annual Subsidy Amount Value set in Config Option under Category = Healthcare and Property = SubsidyAnnualAmount

Cost Per Hour

Exposure / Total Hours

Employee and Employer Contribution Plan

Look Back Period

Look Back period month number (3,6,9,12)

Exposure

(FT Employee Count * PCT FT Sub / 100 ) * Subsidy Penalty

Where PCT FT Sub = Value passed in “Percent FT Subsidy” parameter

Subsidy Penalty = Annual Subsidy Amount Value set in Config Option under Category = Healthcare and Property = SubsidyAnnualAmount

Cost Per Hour

Exposure / Total Hours

Employee Contribution Threshold

Look Back Period

Look Back period month number (3,6,9,12)

EE Contribution Threshold

Minimum Total Pay from all the Employees (Total pay of the employee receiving lowest amount)

EE Contribution Threshold Difference

EE Contribution Threshold – Employee Contribution from parameter