Page 47 - Erlanger Health System

ACTUARIAL

Monthly medical/Rx projection

Monthly medical/Rx projection

Sample client

12-Month Renewal Projection
Self Funded Medical - Status Quo
Total Medical
PEPM Total
Projected Lives (Nov-19) 3,707

Experience (Dec-18 - Nov-19)
Average Lagged Lives (1 Month) 3,772
Total Claims $843.71 $38,184,500
ISL Adjustments -$10.05 -$454,843
Claims Net ISL Adjustments $833.66 $37,729,657
Trend Considerations:
Annual Trend 7.0% Erlanger specific trend
Trending Months 14 components, i.e.
Effective Trend 7.0% managed care rates for
domestic, chargemaser
Trended Claims $892.01 $40,370,733 increases, domestic
Claim Fluctuation Corridor 0.0% utilization etc.
Plan Design Adjustment 1.0000
Projected Claims $892.01 $40,370,733

Administration Fees $30.07 $1,337,562
Stop Loss Fees $11.13 $495,269
Estimated Rx Claims Savings $0.00 $0

Projected Cost $933.22 $42,203,564
Current Accrual $901.15 $40,084,594
% Change in Current Accrual 3.56%

Actual Cost $890.12 $39,593,962

Actual Cost vs. Current Accrual -1.22% -$490,632

2
47 Lockton Companies