Page 46 - Erlanger Health System
P. 46
A
ACTUARIALCTUARIAL
Large claim distribution analysis
Sample – large claim distribution analysis
Sample client
Sample
Large Claim Distribution
YTD 2019
Plan Year 2018 (through November) Actuarial Norm - Expected
Annual
Average Members 5,595 5,723 5,723
Average Employees 3,677 3,778 3,778
Frequency/Severity Count Average Cost Count Average Cost Count Average Cost
$50K - $100K 63 $27,670 74 $27,617 67 $27,586
$100K - $200K 36 $54,472 29 $52,001 27 $54,548
$200K - $300K 6 $93,042 8 $96,847 7 $96,001
$300K - $450K 4 $152,096 2 $143,166 3 $144,277
$450K+ 2 $339,129 2 $223,245 2 $290,574
Grand Totals 111 $49,819 115 $44,843 106 $48,040
Total Large Claims >$50K $13,800,000 $12,914,800 $12,742,400
Stop Loss Reimbursements >$450K $795,600 $259,600 $628,000
Net Paid Large Claims $13,004,400 $12,655,200 $12,114,400
PEPM Net Large Claims $118 $122 $107
Variance to Norm $11 $15 -
1
46 Lockton Companies
ACTUARIALCTUARIAL
Large claim distribution analysis
Sample – large claim distribution analysis
Sample client
Sample
Large Claim Distribution
YTD 2019
Plan Year 2018 (through November) Actuarial Norm - Expected
Annual
Average Members 5,595 5,723 5,723
Average Employees 3,677 3,778 3,778
Frequency/Severity Count Average Cost Count Average Cost Count Average Cost
$50K - $100K 63 $27,670 74 $27,617 67 $27,586
$100K - $200K 36 $54,472 29 $52,001 27 $54,548
$200K - $300K 6 $93,042 8 $96,847 7 $96,001
$300K - $450K 4 $152,096 2 $143,166 3 $144,277
$450K+ 2 $339,129 2 $223,245 2 $290,574
Grand Totals 111 $49,819 115 $44,843 106 $48,040
Total Large Claims >$50K $13,800,000 $12,914,800 $12,742,400
Stop Loss Reimbursements >$450K $795,600 $259,600 $628,000
Net Paid Large Claims $13,004,400 $12,655,200 $12,114,400
PEPM Net Large Claims $118 $122 $107
Variance to Norm $11 $15 -
1
46 Lockton Companies