Page 26 - Quality Industries
P. 26
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
$843.71
Total Claims $833.66 $37,729,657
$38,184,500
-$10.05
ISL Adjustments
-$454,843
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
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
Plan Design Adjustment
Jan-19 to Nov-19
$30.07
$1,337,562
Administration Fees
$11.13
Stop Loss Fees
$495,269
Estimated Rx Claims Savings
$0.00
$0
$1,500,000
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
$43,000,000
112,140
$44,000,000
Jan-18 to Dec-18
Current Accrual
$40,084,594
$901.15
$41,500,000
$42,000,000
111,429
($500,000)
Jan-17 to Dec-17
101%
3.56%
% Change in Current Accrual
$890.12
$39,593,962
Actual Cost
-$490,632
Actual Cost vs. Current Accrual
-1.22%
10
• Cash and accrual (C&A) • Demographic analysis
reports — inance/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
Fixed Costs
IIa.
Total Plan Costs
Enrolled
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
Subscribers
= Fixed +
$2,798,615
$2,512,347
$2,370,591
$2,787,127
$2,491,964
$2,350,736
$2,786,464
$2,734,267
$0
$2,875,265
$2,430,645
$0
$2,784,263
$2,571,296
Expected Annual
$0
$3,188,961
• 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 $738 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 $2,414,380 Admin Fee $3,239,682 $107,634 $108,437 $3,111,491 Specific Stop- $3
$3,329,971
$2,792,313
$2,818,647
$2,960,222
$19,845
$2,803,103
$2,785,631
$2,624,883
July-18
Average Members
August-18
$3,383,081
$222,319
$2,810,564
$2,509,503
$2,803,528
$39,661
September-18
October-18
10,635
$491,274
10,007
10,635
$2,907,057
$40,127
$2,761,428
Total Sub-
$2,781,392 Total Fixed
November-18
$2,274,797
Month/Year
Loss Premium
Claims
scribers
$3,098,325
$90,583
$2,795,963
December-18
$33,490,389
Frequency/Severity
($450k)
Jan-19
$33,490,389
$32,691,492
$0
3,806
$942,392
3,834
$0 Feb-19
$0
$3,205,023 $141,856
$3,205,023
January-19
• 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,
$2,970,669
$162,430
$159,440
$161,632
$3,231,924 $140,848
$150k - $175k
$3,211,094 $141,863
$187,746
$186,198
$175k - $200k
$3,231,374 $141,598
$186,695
$3,225,183 $138,911
$200k - $250k
• 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
$213,335
$222,076
$222,856
$3,161,773 $138,830
$3,164,750 $136,895
$250k+
$0 Oct-19
$468,150
September-19
October-19
$3,118,977 $137,415
$246,780
$3,138,444
Grand Totals
November-19
$238,459
December-19
YTD Totals
$259,468
$246,780
$35,037,333 $139,772
$246,780
Average/PEPM
Norms
Current Policy Year To Date
• 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
Lagged Lives
(Paid Basis)
Current Policy Year Stop Loss Summary
4.9
5.5
5.3
(based on lagged enrollment)
1,000 Members
Rolling Twelve Actual Plan Costs
Large Claims Adjustments
Rolling Twelve Expected Plan Costs
Expected Plan Costs
Percent of Expected
2019 YTD Actual
Total Large Claims >$125k
Percent of Expected
2019 YTD 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
Actual vs. Budget
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
• Expense allocation analysis $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
Claims
Loss
Plan Cost
Claims ($175k)
Premium
• Year-over-year (YOY) or rolling $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
$317,239
$224,692
$3,005,297
Feb-19
$92,547
$703,886
$2,688,058
$2,923,154
$688
$225,540
$318,437
$777,111
$92,896
$2,146,731
$3,241,591
$3,266,494
$386,407
$225,446
$855,677
$2,948,190
$2,478,921
$92,857
$318,303
Apr-19
$92,819
$898,619
$2,934,763
$318,170
$225,352
May-19
$221,631
$2,257,775
$3,252,934
$0
12 months • Other customized reports 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 5,406 5,456 5,421 5,442 5,492 $92,547 $224,692 $317,239 $2,216,474 $876,056 $667,899 $2,424,631 $2,741,870
Jun-19
$93,013
$2,090,771
$882,345
$2,903,452
Jul-19
$225,823
$388,500
$318,836
$2,584,616
$316,973
$92,469
$2,959,412
$469,760
$224,504
$3,276,385
$2,544,848
$884,324
$2,630,017
$3,118,959
$3,437,396
$225,540
Sep-19
$870,380
$318,437
$92,896
$381,438
$2,804,168
$447,031
Oct-19
$229,028
$323,360
$939,423
$94,333
$1,988,416
$2,480,808
$2,866,986
$821,998
$84,968
$2,544,691
$94,022
Nov-19
$1,807,660
$322,296
$228,274
$641,403
$227,991
$93,906
Cost Accrual YTD Totals 2,422 2,419 28,791 5,468 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
$3,195,739
Dec-19
$2,873,843
$2,610,313
$904,933
$321,896
$1,000
• Detailed expense (admin., stop- • COVID-19 reporting and $800 $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
$900
Average/Month
$942.91
$1,300.26
$133.07
$1,167.19
Average/PEPM
$94.25
$353.69
$129.41
$38.82
Lagged Lives
loss, medical, pharmacy, dental, analytics $300 $200 $100 $0 YTD Total PEPM (based on lagged enrollment) $1,300.26
$1,249.35
2018 Total PEPM
4.1%
2019 vs. 2018 Change
2019 Budget PEPM $1,392.08 6
2019 Actual vs. Budget
-6.6%
vision) • Actuarial projections, i.e., large 8
• Global or plan-level reporting claim frequency and severity Executive Overview
Self Funded Medical
PEPM Cost vs Accrual
$879.33
$843.25
$842.75 $817.89 $832.28 $843.65 $846.01
$780.11 $747.79 $765.31
• Gross and net of employee
contributions
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
Quality Industries — Lockton Total Rewards Practice overview 26 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
$843.71
Total Claims $833.66 $37,729,657
$38,184,500
-$10.05
ISL Adjustments
-$454,843
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
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
Plan Design Adjustment
Jan-19 to Nov-19
$30.07
$1,337,562
Administration Fees
$11.13
Stop Loss Fees
$495,269
Estimated Rx Claims Savings
$0.00
$0
$1,500,000
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
$43,000,000
112,140
$44,000,000
Jan-18 to Dec-18
Current Accrual
$40,084,594
$901.15
$41,500,000
$42,000,000
111,429
($500,000)
Jan-17 to Dec-17
101%
3.56%
% Change in Current Accrual
$890.12
$39,593,962
Actual Cost
-$490,632
Actual Cost vs. Current Accrual
-1.22%
10
• Cash and accrual (C&A) • Demographic analysis
reports — inance/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
Fixed Costs
IIa.
Total Plan Costs
Enrolled
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
Subscribers
= Fixed +
$2,798,615
$2,512,347
$2,370,591
$2,787,127
$2,491,964
$2,350,736
$2,786,464
$2,734,267
$0
$2,875,265
$2,430,645
$0
$2,784,263
$2,571,296
Expected Annual
$0
$3,188,961
• 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 $738 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 $2,414,380 Admin Fee $3,239,682 $107,634 $108,437 $3,111,491 Specific Stop- $3
$3,329,971
$2,792,313
$2,818,647
$2,960,222
$19,845
$2,803,103
$2,785,631
$2,624,883
July-18
Average Members
August-18
$3,383,081
$222,319
$2,810,564
$2,509,503
$2,803,528
$39,661
September-18
October-18
10,635
$491,274
10,007
10,635
$2,907,057
$40,127
$2,761,428
Total Sub-
$2,781,392 Total Fixed
November-18
$2,274,797
Month/Year
Loss Premium
Claims
scribers
$3,098,325
$90,583
$2,795,963
December-18
$33,490,389
Frequency/Severity
($450k)
Jan-19
$33,490,389
$32,691,492
$0
3,806
$942,392
3,834
$0 Feb-19
$0
$3,205,023 $141,856
$3,205,023
January-19
• 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,
$2,970,669
$162,430
$159,440
$161,632
$3,231,924 $140,848
$150k - $175k
$3,211,094 $141,863
$187,746
$186,198
$175k - $200k
$3,231,374 $141,598
$186,695
$3,225,183 $138,911
$200k - $250k
• 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
$213,335
$222,076
$222,856
$3,161,773 $138,830
$3,164,750 $136,895
$250k+
$0 Oct-19
$468,150
September-19
October-19
$3,118,977 $137,415
$246,780
$3,138,444
Grand Totals
November-19
$238,459
December-19
YTD Totals
$259,468
$246,780
$35,037,333 $139,772
$246,780
Average/PEPM
Norms
Current Policy Year To Date
• 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
Lagged Lives
(Paid Basis)
Current Policy Year Stop Loss Summary
4.9
5.5
5.3
(based on lagged enrollment)
1,000 Members
Rolling Twelve Actual Plan Costs
Large Claims Adjustments
Rolling Twelve Expected Plan Costs
Expected Plan Costs
Percent of Expected
2019 YTD Actual
Total Large Claims >$125k
Percent of Expected
2019 YTD 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
Actual vs. Budget
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
• Expense allocation analysis $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
Claims
Loss
Plan Cost
Claims ($175k)
Premium
• Year-over-year (YOY) or rolling $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
$317,239
$224,692
$3,005,297
Feb-19
$92,547
$703,886
$2,688,058
$2,923,154
$688
$225,540
$318,437
$777,111
$92,896
$2,146,731
$3,241,591
$3,266,494
$386,407
$225,446
$855,677
$2,948,190
$2,478,921
$92,857
$318,303
Apr-19
$92,819
$898,619
$2,934,763
$318,170
$225,352
May-19
$221,631
$2,257,775
$3,252,934
$0
12 months • Other customized reports 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 5,406 5,456 5,421 5,442 5,492 $92,547 $224,692 $317,239 $2,216,474 $876,056 $667,899 $2,424,631 $2,741,870
Jun-19
$93,013
$2,090,771
$882,345
$2,903,452
Jul-19
$225,823
$388,500
$318,836
$2,584,616
$316,973
$92,469
$2,959,412
$469,760
$224,504
$3,276,385
$2,544,848
$884,324
$2,630,017
$3,118,959
$3,437,396
$225,540
Sep-19
$870,380
$318,437
$92,896
$381,438
$2,804,168
$447,031
Oct-19
$229,028
$323,360
$939,423
$94,333
$1,988,416
$2,480,808
$2,866,986
$821,998
$84,968
$2,544,691
$94,022
Nov-19
$1,807,660
$322,296
$228,274
$641,403
$227,991
$93,906
Cost Accrual YTD Totals 2,422 2,419 28,791 5,468 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
$3,195,739
Dec-19
$2,873,843
$2,610,313
$904,933
$321,896
$1,000
• Detailed expense (admin., stop- • COVID-19 reporting and $800 $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
$900
Average/Month
$942.91
$1,300.26
$133.07
$1,167.19
Average/PEPM
$94.25
$353.69
$129.41
$38.82
Lagged Lives
loss, medical, pharmacy, dental, analytics $300 $200 $100 $0 YTD Total PEPM (based on lagged enrollment) $1,300.26
$1,249.35
2018 Total PEPM
4.1%
2019 vs. 2018 Change
2019 Budget PEPM $1,392.08 6
2019 Actual vs. Budget
-6.6%
vision) • Actuarial projections, i.e., large 8
• Global or plan-level reporting claim frequency and severity Executive Overview
Self Funded Medical
PEPM Cost vs Accrual
$879.33
$843.25
$842.75 $817.89 $832.28 $843.65 $846.01
$780.11 $747.79 $765.31
• Gross and net of employee
contributions
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
Quality Industries — Lockton Total Rewards Practice overview 26 Lockton Companies
