Page 41 - Reliance Partners
P. 41
Financial Reporting
Financial reporting Expected Accrual Assessment by Total Summary (Total Medical) Monthly Medical/Rx Projection
Self Funded Medical
Total Cost vs Expected Accrual
12-Month Renewal Projection
$46,500,000 $48,000,000 $44,000,000 Self Funded Medical - Status Quo Total Medical
$43,000,000 $42,000,000 $41,500,000 Projected Lives (Nov-19) PEPM 3,707 Total
Experience (Dec-18 - Nov-19)
Average Lagged Lives (1 Month) 3,772
$38,184,500
$843.71
Total Claims $833.66 $37,729,657
-$454,843
ISL Adjustments
-$10.05
Claims Net ISL Adjustments
Extensive and Additional reports 97% 102% 101% Annual Trend $892.01 7.0% 7.0% 0.0% 14 $40,370,733
Trending Months
Effective Trend
Trended Claims
Claim Fluctuation Corridor
Plan Design Adjustment
customizable inancial include Total Medical Summary Lives Total Cost Jan-18 to Dec-18 Accrual Var ($) Jan-17 to Dec-17 % Projected Claims $892.01 1.0000 $40,370,733
Jan-19 to Nov-19
Administration Fees
$1,337,562
$30.07
$495,269
Stop Loss Fees
$11.13
$0
Estimated Rx Claims Savings
$0.00
reporting capabilities • Utilization reports Jan-19 to Nov-19 103,819 $46,500,000 $48,000,000 ($1,000,000) 102% 97% Projected Cost $933.22 $42,203,564 1
$1,500,000
$43,000,000
Jan-18 to Dec-18
$44,000,000
112,140
$901.15
$40,084,594
Current Accrual
$42,000,000
111,429
$41,500,000
101%
Jan-17 to Dec-17
($500,000)
3.56%
% Change in Current Accrual
Actual Cost
$890.12
$39,593,962
-1.22%
-$490,632
Actual Cost vs. Current Accrual
10
• Cash & Accrual (C&A) reports • Demographic analysis
— Finance/HR executive • Enrollment reports Large claim distribution analysis Monthly Financial Reporting Sample
Medical /Rx
dashboards Large Claim Distribution - Annual Sample Client Month Paid Claim Payments are Valued as of: (ASO and Stop Loss Paid Claims Large Claims 1 Total Paid Net Claims = Fixed + Claims (Monthly) Expected Plan Costs 2 Total Plan Costs (Cumulative) Expected Plan Costs 2
Sample Client
Medical and Rx Cash Flow Summary - (By Month Paid)
I.
November 30, 2019
IIa.
Fixed Costs
Total Plan Costs
Enrolled
= Fixed +
Subscribers
Adjustments
• Network discounts Plan Year 2018 2019 Actuarial Norm - January-18 February-18 March-18 April-18 May-18 June-18 3,762 3,749 3,743 3,730 3,737 3,753 Premium) $141,756 $141,228 $140,998 $140,651 $141,010 $141,575 $2,408,184 $2,350,989 $2,734,267 $2,430,645 $3,188,961 $2,838,492 $37,593 $253 Sample Self Funded Claim Report - Medical $2,512,347 $5,004,311 $7,879,575 $10,450,871 $13,780,842 $16,741,064 Claims $2,798,615 $5,585,742 $8,372,206 $11,156,468 $13,948,781 $16,751,884
$2,512,347
$2,798,615
$2,370,591
$2,350,736
$2,787,127
$2,491,964
$2,875,265
$2,786,464
$2,734,267
$0
$2,571,296
$0
$2,430,645
$2,784,263
$2,792,313
$3,329,971
• Clinical and utilization reporting Average Employees Count 18,612 Average Cost Count 19,525 Average Cost Count 19,525 Average Cost Cumulative (1/1/2018-18) 3,726 3,760 3,745 3,714 3,695 3,742 44,856 3,806 $140,651 $141,999 $141,493 $140,420 $139,583 $141,357 $1,692,721 $140,822 $2,625,621 $3,605,400 $2,549,164 $3,398,331 $2,314,924 $3,188,907 $33,633,884 $2,970,669 Plan Year Ending 12/31/19 Members Total 5,747 5,784 $34,384,213 $2,765,534 $3,525,080 $2,650,996 $3,047,477 Admin Fee $2,414,380 $3,239,682 $107,634 $108,437 $3,111,491 Specific Stop- $33,188
$0
Expected Annual
$3,188,961
$2,960,222
$19,845
$2,818,647
$2,803,103
$738
$2,624,883
Average Members
July-18
$2,785,631
$2,810,564
$222,319
$3,383,081
August-18
$2,803,528
September-18
$39,661
$2,509,503
10,007
10,635
$2,907,057
10,635
$491,274
October-18
Month/Year
$30,694,426
Total Sub-
$2,274,797
$40,127
$2,761,428
November-18
$2,781,392 Total Fixed
scribers
Claims
Loss Premium
$90,583
December-18
($450k)
$33,490,389
$3,098,325
Frequency/Severity
$2,795,963
$942,392
$33,490,389
3,806
$32,691,492
$0
Jan-19
$0
3,834
$0 Feb-19
$3,205,023 $141,856
$2,970,669
$3,205,023
• Network disruption $125k - $150k 30 22 13 11 $135,913 22 15 20 13 $134,996 24.8 17.0 11.2 14.8 $136,788 IIb. February-19 March-19 April-19 May-19 June-19 July-19 August-19 3,834 3,828 3,805 3,834 3,826 3,753 3,748 $141,856 $141,738 $140,848 $141,863 $141,598 $138,911 $138,830 $2,596,009 $2,723,194 $2,773,443 $3,604,519 $2,579,242 $2,954,615 $3,363,539 $2,741 Jul-19 $440 Aug-19 $40,121 Sep-19 $0 Mar-19 $0 Apr-19 $0 May-19 $0 Jun-19 $2,596,009 $2,723,194 $2,773,443 $3,604,519 $2,576,501 $2,954,176 $3,323,418 3,828 3,805 3,834 3,826 3,753 3,
January-19
$161,632
$150k - $175k
$162,430
$3,231,924 $140,848
$159,440
$3,211,094 $141,863
$3,231,374 $141,598
$187,746
$186,198
$186,695
$175k - $200k
$3,225,183 $138,911
$213,335
$222,076
• Budget vs. claim reports Membership Adjusted 90.3 22 98 $496,851 37 107 94.7 $273,870 27.0 94.7 $439,674 Cumulative (1/1/2019-19) 3,696 3,690 3,707 41,528 $136,895 $136,718 $137,415 $1,537,496 $2,730,685 $3,139,786 $3,297,017 $32,732,717 ($3,074) v - 19 $219,239 Average/Month No Dec-19 $32,473,249 $2,730,685 $3,142,859 $3,077,777 3,690 3,707 41,528 3,775 41,563 0 62,914 62,951 5,613 5,643 0 5,719 $1,174,401 $34,010,745 $104,342 $2,867,580 $104,828 $3,279,578 $3,215,192 $106,764 $28.30 $0 $32,376 $32,587 $363,095 $33,009 $0 $8.72 $3,120,375 $1
$200k - $250k
$222,856
$3,161,773 $138,830
$3,164,750 $136,895
$250k+
$0 Oct-19
$468,150
September-19
$3,118,977 $137,415
October-19
Grand Totals
$238,459
$246,780
$3,138,444
November-19
December-19
YTD Totals
$246,780
$35,037,333 $139,772
$246,780
$259,468
Norms
Average/PEPM
Lagged Lives
• Plan design modeling # of Claimants > $100k per $23,369,000 $29,304,000 $23,373,000 III. Rolling 12 Months Actual vs Expected (Dec-18 to Nov-19) $93,126,066 $94,583,239 98% IV. Actual Plan Cost $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 Cautiously Optimistic $34,010,745 $35,037,333 97% V. Ind Stop Loss (ISL) Deductible Per Claimant $500,000 $259,468 Employee Contributions Sample Net Plan PEPM Comparison 96.4% $825 $856
Current Policy Year To Date
4.9
Current Policy Year Stop Loss Summary
5.3
5.5
(Paid Basis)
(based on lagged enrollment)
1,000 Members
Rolling Twelve Actual Plan Costs
Rolling Twelve Expected Plan Costs
Expected Plan Costs
Large Claims Adjustments
Percent of Expected
Total Large Claims >$125k
Percent of Expected
2019 YTD Actual
2019 YTD Budget
Actual vs. Budget
• Monthly IBNR analysis PEPM Large Claims $195 $230 $183 1 $1,500,000 $1,000,000 $500,000 $0 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Cost Total Accrual 2018 Actual 104.0% 12.6% $780 $750 6.5% 5
2018 Budget
Actual vs. Budget
2019 vs. 2018 Actual
2019 vs. 2018 Budget
• Contribution analysis
• Certiied IBNR reports Claims Trending
• Clinical reports (Infolock) Self Funded Medical Self Insured Claim Report Sample
• Large claim reports PEPM Claims by Policy Period Quarter PEPM Claims $710 $730 12-Month Average $780 $730 $790 $790 Medical/Rx
$900
$800
• On-site clinic utilization and $700 $600 $500 $650 $680 Month/Year Subscribers Members Admin Fee Specific Stop- Total Fixed Gross Medical Gross Rx Claims Reimbursable Net Paid Claims Total Net
Stop-Loss
Total
Total
Plan Cost
Claims
Loss
Claims ($175k)
Premium
• Year-over-year (YOY) or rolling claims $400 $300 $200 $100 $65 Mar-19 2,405 2,384 2,393 2,392 2,391 5,471 5,423 5,424 5,445 5,419 $93,362 $226,671 $320,033 $2,254,931 $724,894 $20,317 $0 $2,979,824 $3,299,858
Jan-19
$2,004,489
$2,688,058
$92,547
Feb-19
$703,886
$224,692
$317,239
$3,005,297
$225,540
$688
$2,923,154
$777,111
$318,437
$2,146,731
$3,241,591
$92,896
Apr-19
$2,478,921
$2,948,190
$225,446
$92,857
$386,407
$318,303
$855,677
$3,266,494
$898,619
$3,252,934
$2,257,775
$2,934,763
$221,631
$225,352
$92,819
May-19
$318,170
12 months PEPM COST VS ACCRUAL 1Q17 2Q17 3Q17 4Q17 1Q18 2Q18 3Q18 4Q18 1Q19 2Q19 3Q19 4Q19 Aug-19 2,384 2,396 2,382 2,393 2,430 2,422 5,406 5,456 5,421 5,442 5,492 5,468 $92,547 $224,692 $317,239 $2,216,474 $876,056 $667,899 $2,424,631 $2,741,870
Jun-19
$0
$2,090,771
$2,903,452
$882,345
Jul-19
$93,013
$318,836
$388,500
$225,823
$2,584,616
$469,760
$316,973
$2,959,412
$3,276,385
$92,469
$224,504
$2,544,848
$884,324
$2,630,017
$225,540
$3,118,959
$318,437
Sep-19
$92,896
$381,438
$870,380
$3,437,396
$94,333
$447,031
$1,988,416
$2,804,168
Oct-19
$2,480,808
$229,028
$939,423
$323,360
$2,544,691
$821,998
$84,968
$2,866,986
$94,022
$228,274
$322,296
Nov-19
$1,807,660
• Expense allocation analysis $1,000 $900 $800 Cost Accrual YTD Totals 2,419 28,791 5,460 65,327 $1,117,667 $2,713,552 $3,831,218 $27,031,348 $10,139,645 $3,710,042 $33,460,951 $37,292,169
$2,873,843
$227,991
Dec-19
$93,906
$641,403
$321,896
$3,195,739
$904,933
$2,610,313
• Detailed expense (admin., stop $700 $600 $500 $400 PEPM Comparison 2,399 28,668 5,444 65,051 $93,139 $226,129 $319,268.20 $2,252,612 $844,970 $309,170 $2,788,413 $3,107,681
Average/Month
$133.07
$942.91
$1,167.19
Average/PEPM
$1,300.26
$129.41
$353.69
$94.25
$38.82
Lagged Lives
loss, medical, pharmacy, dental, • Other customized reports $300 $200 $100 $0 YTD Total PEPM (based on lagged enrollment) $1,300.26
$1,249.35
2018 Total PEPM
2019 vs. 2018 Change
4.1%
2019 Budget PEPM $1,392.08 6
-6.6%
2019 Actual vs. Budget
vision) • COVID-19 reporting and 8
• Global or plan level reporting analytics Executive Overview
Self Funded Medical
PEPM Cost vs Accrual
$879.33
$843.25
$842.75 $817.89 $832.28 $843.65 $846.01
$765.31
$780.11 $747.79
• Gross and net of employee • Actuarial projections, i.e., large
contributions claim frequency and severity
104% 91% 97% 99% 104%
4Q18 1Q19 2Q19 3Q19 4Q19
Policy Period Claims by Band $250,000 - $449,999 $450,000+ 4.1%
5.1%
$150,000 - $249,999
7.0%
<$150,000
LOCKTON COMPANIES | 1 83.8%
7
Reliance Partners — Lockton Employee Beneits Practice Overview 41 Lockton Companies
Financial reporting Expected Accrual Assessment by Total Summary (Total Medical) Monthly Medical/Rx Projection
Self Funded Medical
Total Cost vs Expected Accrual
12-Month Renewal Projection
$46,500,000 $48,000,000 $44,000,000 Self Funded Medical - Status Quo Total Medical
$43,000,000 $42,000,000 $41,500,000 Projected Lives (Nov-19) PEPM 3,707 Total
Experience (Dec-18 - Nov-19)
Average Lagged Lives (1 Month) 3,772
$38,184,500
$843.71
Total Claims $833.66 $37,729,657
-$454,843
ISL Adjustments
-$10.05
Claims Net ISL Adjustments
Extensive and Additional reports 97% 102% 101% Annual Trend $892.01 7.0% 7.0% 0.0% 14 $40,370,733
Trending Months
Effective Trend
Trended Claims
Claim Fluctuation Corridor
Plan Design Adjustment
customizable inancial include Total Medical Summary Lives Total Cost Jan-18 to Dec-18 Accrual Var ($) Jan-17 to Dec-17 % Projected Claims $892.01 1.0000 $40,370,733
Jan-19 to Nov-19
Administration Fees
$1,337,562
$30.07
$495,269
Stop Loss Fees
$11.13
$0
Estimated Rx Claims Savings
$0.00
reporting capabilities • Utilization reports Jan-19 to Nov-19 103,819 $46,500,000 $48,000,000 ($1,000,000) 102% 97% Projected Cost $933.22 $42,203,564 1
$1,500,000
$43,000,000
Jan-18 to Dec-18
$44,000,000
112,140
$901.15
$40,084,594
Current Accrual
$42,000,000
111,429
$41,500,000
101%
Jan-17 to Dec-17
($500,000)
3.56%
% Change in Current Accrual
Actual Cost
$890.12
$39,593,962
-1.22%
-$490,632
Actual Cost vs. Current Accrual
10
• Cash & Accrual (C&A) reports • Demographic analysis
— Finance/HR executive • Enrollment reports Large claim distribution analysis Monthly Financial Reporting Sample
Medical /Rx
dashboards Large Claim Distribution - Annual Sample Client Month Paid Claim Payments are Valued as of: (ASO and Stop Loss Paid Claims Large Claims 1 Total Paid Net Claims = Fixed + Claims (Monthly) Expected Plan Costs 2 Total Plan Costs (Cumulative) Expected Plan Costs 2
Sample Client
Medical and Rx Cash Flow Summary - (By Month Paid)
I.
November 30, 2019
IIa.
Fixed Costs
Total Plan Costs
Enrolled
= Fixed +
Subscribers
Adjustments
• Network discounts Plan Year 2018 2019 Actuarial Norm - January-18 February-18 March-18 April-18 May-18 June-18 3,762 3,749 3,743 3,730 3,737 3,753 Premium) $141,756 $141,228 $140,998 $140,651 $141,010 $141,575 $2,408,184 $2,350,989 $2,734,267 $2,430,645 $3,188,961 $2,838,492 $37,593 $253 Sample Self Funded Claim Report - Medical $2,512,347 $5,004,311 $7,879,575 $10,450,871 $13,780,842 $16,741,064 Claims $2,798,615 $5,585,742 $8,372,206 $11,156,468 $13,948,781 $16,751,884
$2,512,347
$2,798,615
$2,370,591
$2,350,736
$2,787,127
$2,491,964
$2,875,265
$2,786,464
$2,734,267
$0
$2,571,296
$0
$2,430,645
$2,784,263
$2,792,313
$3,329,971
• Clinical and utilization reporting Average Employees Count 18,612 Average Cost Count 19,525 Average Cost Count 19,525 Average Cost Cumulative (1/1/2018-18) 3,726 3,760 3,745 3,714 3,695 3,742 44,856 3,806 $140,651 $141,999 $141,493 $140,420 $139,583 $141,357 $1,692,721 $140,822 $2,625,621 $3,605,400 $2,549,164 $3,398,331 $2,314,924 $3,188,907 $33,633,884 $2,970,669 Plan Year Ending 12/31/19 Members Total 5,747 5,784 $34,384,213 $2,765,534 $3,525,080 $2,650,996 $3,047,477 Admin Fee $2,414,380 $3,239,682 $107,634 $108,437 $3,111,491 Specific Stop- $33,188
$0
Expected Annual
$3,188,961
$2,960,222
$19,845
$2,818,647
$2,803,103
$738
$2,624,883
Average Members
July-18
$2,785,631
$2,810,564
$222,319
$3,383,081
August-18
$2,803,528
September-18
$39,661
$2,509,503
10,007
10,635
$2,907,057
10,635
$491,274
October-18
Month/Year
$30,694,426
Total Sub-
$2,274,797
$40,127
$2,761,428
November-18
$2,781,392 Total Fixed
scribers
Claims
Loss Premium
$90,583
December-18
($450k)
$33,490,389
$3,098,325
Frequency/Severity
$2,795,963
$942,392
$33,490,389
3,806
$32,691,492
$0
Jan-19
$0
3,834
$0 Feb-19
$3,205,023 $141,856
$2,970,669
$3,205,023
• Network disruption $125k - $150k 30 22 13 11 $135,913 22 15 20 13 $134,996 24.8 17.0 11.2 14.8 $136,788 IIb. February-19 March-19 April-19 May-19 June-19 July-19 August-19 3,834 3,828 3,805 3,834 3,826 3,753 3,748 $141,856 $141,738 $140,848 $141,863 $141,598 $138,911 $138,830 $2,596,009 $2,723,194 $2,773,443 $3,604,519 $2,579,242 $2,954,615 $3,363,539 $2,741 Jul-19 $440 Aug-19 $40,121 Sep-19 $0 Mar-19 $0 Apr-19 $0 May-19 $0 Jun-19 $2,596,009 $2,723,194 $2,773,443 $3,604,519 $2,576,501 $2,954,176 $3,323,418 3,828 3,805 3,834 3,826 3,753 3,
January-19
$161,632
$150k - $175k
$162,430
$3,231,924 $140,848
$159,440
$3,211,094 $141,863
$3,231,374 $141,598
$187,746
$186,198
$186,695
$175k - $200k
$3,225,183 $138,911
$213,335
$222,076
• Budget vs. claim reports Membership Adjusted 90.3 22 98 $496,851 37 107 94.7 $273,870 27.0 94.7 $439,674 Cumulative (1/1/2019-19) 3,696 3,690 3,707 41,528 $136,895 $136,718 $137,415 $1,537,496 $2,730,685 $3,139,786 $3,297,017 $32,732,717 ($3,074) v - 19 $219,239 Average/Month No Dec-19 $32,473,249 $2,730,685 $3,142,859 $3,077,777 3,690 3,707 41,528 3,775 41,563 0 62,914 62,951 5,613 5,643 0 5,719 $1,174,401 $34,010,745 $104,342 $2,867,580 $104,828 $3,279,578 $3,215,192 $106,764 $28.30 $0 $32,376 $32,587 $363,095 $33,009 $0 $8.72 $3,120,375 $1
$200k - $250k
$222,856
$3,161,773 $138,830
$3,164,750 $136,895
$250k+
$0 Oct-19
$468,150
September-19
$3,118,977 $137,415
October-19
Grand Totals
$238,459
$246,780
$3,138,444
November-19
December-19
YTD Totals
$246,780
$35,037,333 $139,772
$246,780
$259,468
Norms
Average/PEPM
Lagged Lives
• Plan design modeling # of Claimants > $100k per $23,369,000 $29,304,000 $23,373,000 III. Rolling 12 Months Actual vs Expected (Dec-18 to Nov-19) $93,126,066 $94,583,239 98% IV. Actual Plan Cost $4,000,000 $3,500,000 $3,000,000 $2,500,000 $2,000,000 Cautiously Optimistic $34,010,745 $35,037,333 97% V. Ind Stop Loss (ISL) Deductible Per Claimant $500,000 $259,468 Employee Contributions Sample Net Plan PEPM Comparison 96.4% $825 $856
Current Policy Year To Date
4.9
Current Policy Year Stop Loss Summary
5.3
5.5
(Paid Basis)
(based on lagged enrollment)
1,000 Members
Rolling Twelve Actual Plan Costs
Rolling Twelve Expected Plan Costs
Expected Plan Costs
Large Claims Adjustments
Percent of Expected
Total Large Claims >$125k
Percent of Expected
2019 YTD Actual
2019 YTD Budget
Actual vs. Budget
• Monthly IBNR analysis PEPM Large Claims $195 $230 $183 1 $1,500,000 $1,000,000 $500,000 $0 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Cost Total Accrual 2018 Actual 104.0% 12.6% $780 $750 6.5% 5
2018 Budget
Actual vs. Budget
2019 vs. 2018 Actual
2019 vs. 2018 Budget
• Contribution analysis
• Certiied IBNR reports Claims Trending
• Clinical reports (Infolock) Self Funded Medical Self Insured Claim Report Sample
• Large claim reports PEPM Claims by Policy Period Quarter PEPM Claims $710 $730 12-Month Average $780 $730 $790 $790 Medical/Rx
$900
$800
• On-site clinic utilization and $700 $600 $500 $650 $680 Month/Year Subscribers Members Admin Fee Specific Stop- Total Fixed Gross Medical Gross Rx Claims Reimbursable Net Paid Claims Total Net
Stop-Loss
Total
Total
Plan Cost
Claims
Loss
Claims ($175k)
Premium
• Year-over-year (YOY) or rolling claims $400 $300 $200 $100 $65 Mar-19 2,405 2,384 2,393 2,392 2,391 5,471 5,423 5,424 5,445 5,419 $93,362 $226,671 $320,033 $2,254,931 $724,894 $20,317 $0 $2,979,824 $3,299,858
Jan-19
$2,004,489
$2,688,058
$92,547
Feb-19
$703,886
$224,692
$317,239
$3,005,297
$225,540
$688
$2,923,154
$777,111
$318,437
$2,146,731
$3,241,591
$92,896
Apr-19
$2,478,921
$2,948,190
$225,446
$92,857
$386,407
$318,303
$855,677
$3,266,494
$898,619
$3,252,934
$2,257,775
$2,934,763
$221,631
$225,352
$92,819
May-19
$318,170
12 months PEPM COST VS ACCRUAL 1Q17 2Q17 3Q17 4Q17 1Q18 2Q18 3Q18 4Q18 1Q19 2Q19 3Q19 4Q19 Aug-19 2,384 2,396 2,382 2,393 2,430 2,422 5,406 5,456 5,421 5,442 5,492 5,468 $92,547 $224,692 $317,239 $2,216,474 $876,056 $667,899 $2,424,631 $2,741,870
Jun-19
$0
$2,090,771
$2,903,452
$882,345
Jul-19
$93,013
$318,836
$388,500
$225,823
$2,584,616
$469,760
$316,973
$2,959,412
$3,276,385
$92,469
$224,504
$2,544,848
$884,324
$2,630,017
$225,540
$3,118,959
$318,437
Sep-19
$92,896
$381,438
$870,380
$3,437,396
$94,333
$447,031
$1,988,416
$2,804,168
Oct-19
$2,480,808
$229,028
$939,423
$323,360
$2,544,691
$821,998
$84,968
$2,866,986
$94,022
$228,274
$322,296
Nov-19
$1,807,660
• Expense allocation analysis $1,000 $900 $800 Cost Accrual YTD Totals 2,419 28,791 5,460 65,327 $1,117,667 $2,713,552 $3,831,218 $27,031,348 $10,139,645 $3,710,042 $33,460,951 $37,292,169
$2,873,843
$227,991
Dec-19
$93,906
$641,403
$321,896
$3,195,739
$904,933
$2,610,313
• Detailed expense (admin., stop $700 $600 $500 $400 PEPM Comparison 2,399 28,668 5,444 65,051 $93,139 $226,129 $319,268.20 $2,252,612 $844,970 $309,170 $2,788,413 $3,107,681
Average/Month
$133.07
$942.91
$1,167.19
Average/PEPM
$1,300.26
$129.41
$353.69
$94.25
$38.82
Lagged Lives
loss, medical, pharmacy, dental, • Other customized reports $300 $200 $100 $0 YTD Total PEPM (based on lagged enrollment) $1,300.26
$1,249.35
2018 Total PEPM
2019 vs. 2018 Change
4.1%
2019 Budget PEPM $1,392.08 6
-6.6%
2019 Actual vs. Budget
vision) • COVID-19 reporting and 8
• Global or plan level reporting analytics Executive Overview
Self Funded Medical
PEPM Cost vs Accrual
$879.33
$843.25
$842.75 $817.89 $832.28 $843.65 $846.01
$765.31
$780.11 $747.79
• Gross and net of employee • Actuarial projections, i.e., large
contributions claim frequency and severity
104% 91% 97% 99% 104%
4Q18 1Q19 2Q19 3Q19 4Q19
Policy Period Claims by Band $250,000 - $449,999 $450,000+ 4.1%
5.1%
$150,000 - $249,999
7.0%
<$150,000
LOCKTON COMPANIES | 1 83.8%
7
Reliance Partners — Lockton Employee Beneits Practice Overview 41 Lockton Companies
