|
Claims vs Funding PY 2020
<br />ABCD = A+B+CEFGHIJ = E+F+G+H+IKLM = K+LNO = J+M+NP = J+MQR = Q-P
<br />ENROLLMENTCLAIMS DATAFIXED COSTEMPLOYER NET COSTBUDGET DATA
<br />AHF AHF
<br />23
<br />MonthPPO10001500TotalPPOAHF 1000AHF 1500Stop LossAHF FundTotalAdminStop LossTotalEE ContribsNet CostTotal CostBudgetSurplus
<br />2020-01162 109 132 403 $392,812$117,948$975,116($732,425)$20,298$773,748$12,441$46,260$58,701($56,986)$775,463$832,449$744,232($88,217)
<br />2020-02161 108 129 398 $325,802$194,774$103,857($44,321)$33,528$613,641$12,286$45,686$57,973($56,626)$614,987$671,614$750,778$79,164
<br />2020-03160 104 131 395 $352,027$121,297$26,902$0 $23,965$524,191$12,194$45,342$57,536($55,599)$526,128$581,727$731,261$149,534
<br />2020-04159 104 132 395 $293,740$161,184$44,972$0 $6,224$506,119$12,194$45,342$57,536($55,556)$508,099$563,655$714,138$150,484
<br />2020-05159 103 133 395 $163,565$78,832$40,949$0 $7,709$291,054$12,194$45,342$57,536($55,558)$293,032$348,590$715,918$367,328
<br />2020-06158 102 136 396 $270,789$101,759$79,778$0 $11,714$464,040$12,225$45,457$57,681($55,263)$466,458$521,721$718,170$196,449
<br />2020-07157 99 136 392 $234,002$199,806$112,185$0 $10,162$556,155$12,101$44,998$57,099($54,979)$558,275$613,253$712,008$98,755
<br />2020-08157 98 141 396 $272,525$77,529$89,726$0 $7,281$447,062$12,225$45,457$57,681($55,135)$449,608$504,744$713,819$209,076
<br />2020-09156 97 140 393 $219,602$192,264$97,245($6,748)$3,530$505,892$12,132$45,112$57,244($54,480)$508,656$563,136$704,763$141,627
<br />2020-10156 94 145 395 $200,459$121,231$76,575($14,147)$7,281$391,399$12,194$45,342$57,536($54,210)$394,724$448,934$708,781$259,847
<br />2020-11156 95 149 400 $317,742$101,559$142,860($20,405)$8,195$549,951$12,348$45,916$58,264($54,356)$553,859$608,215$716,219$108,004
<br />2020-12154 95 151 400 $351,433$86,096$609,846($456,776)$7,281$597,882$12,348$45,916$58,264($54,475)$601,670$656,146$716,871$60,726
<br />Total1,8951,20816554,758$3,394,498$1,554,278$2,400,010($1,274,823)$147,170 $6,221,133$146,879$546,171$693,050($663,223)$6,250,960$6,914,183$8,646,960$1,732,777
<br />Avg/PEPM 158101138 397$1,791.29$1,286.65$1,450.16($267.93)$51.40 $1,307.51$30.87$114.79$145.66($139.39)$1,313.78$1,453.17$1,817.35$364.18
<br />BUDGET AND CONTRIBUTION DATA
<br />Year to Date SummaryTotalPEPM
<br />PPO Plan EEEESpEEChFam
<br />Total Net Paid Claims$6,221,133$1,307.51
<br />2020 Maximum Claims$1,962.36
<br />Total Fixed Costs$693,050$145.66
<br />Employee Contributions$55.22$276.28$255.20$315.42
<br />Subtotal -Total Costs$6,914,183$1,453.17
<br />Employer Contributions$1,092.14$2,247.90$1,810.04$3,011.92
<br />Total Cost as % of Budget80%
<br />Premium Equivalents$1,147.36$2,524.18$2,065.24$3,327.34
<br />Employee Contributions($663,223)($139.39)
<br />AHF 1000 Plan EEEESpEEChFam
<br />Total -Net Employer Costs$6,250,960$1,313.78
<br />2020 Maximum Claims$1,962.36
<br />Employee Contributions$22.71$184.17$168.77$222.06
<br />Employer Contributions$801.56$1,629.23$1,314.93$2,168.33
<br />AHF 1500
<br />Med, 87%
<br />Rx, 13%
<br />Premium Equivalents$824.27$1,813.40$1,483.70$2,390.39
<br />AHF 1500 Plan EEEESpEEChFam
<br />AHF 1000
<br />Med, 82%Rx, 18%
<br />2020 Maximum Claims$1,962.36
<br />Employee Contributions$14.65$105.00$95.25$120.68
<br />Employer Contributions$784.75$1,653.69$1,343.67$2,197.59
<br />PPO
<br />Med, 74%Rx, 26%
<br />Premium Equivalents$799.40$1,758.69$1,438.92$2,318.27
<br />0%10%20%30%40%50%60%70%80%90%100%
<br />© 2018 HUB International Limited.
<br />7
<br />
<br />
|