2023 Working Rate and Contribution Adjustment Medical Rate Analysis Current 2022 Rates Proposed 2023 Rates Difference ENROLL- TOTAL Velcro EE TOTAL EE ENROLL- RATE Velcro EE TOTAL EE EE EE % MENT MONTHLY ER % MONTHLY MONTHLY ANNUAL ANNUAL Velcro MENT CHANGE MONTHLY ER % MONTHLY MONTHLY ANNUAL ANNUAL Velcro ANNUAL CHANGE HSA 0.0% 0.0% Employee 217 $932.62 80.5% $750.76 $181.86 $2,428,542 $473,566 $1,954,977 236 0.0% $932.62 80.5% $750.76 $181.86 $2,641,180 $515,030 $2,126,150 $0.00 0.0% EE+Spouse 81 $2,145.04 80.5% $1,726.76 $418.28 $2,084,979 $406,571 $1,678,408 80 0.0% $2,145.04 80.5% $1,726.76 $418.28 $2,059,238 $401,551 $1,657,687 $0.00 0.0% EE+ Child(ren) 27 $2,051.78 80.5% $1,651.68 $400.10 $664,777 $129,631 $535,145 20 0.0% $2,051.78 80.5% $1,651.68 $400.10 $492,427 $96,023 $396,404 $0.00 0.0% Family 107 $2,490.13 80.5% $2,004.55 $485.58 $3,197,327 $623,479 $2,573,848 109 0.0% $2,490.13 80.5% $2,004.55 $485.58 $3,257,090 $635,133 $2,621,957 $0.00 0.0% 432 445 HRA Employee 41 $932.62 80.5% $750.76 $181.86 $458,849 $89,476 $369,373 44 0.0% $932.62 80.5% $750.76 $181.86 $492,423 $96,023 $396,401 $0.00 0.0% EE+Spouse 28 $2,145.04 80.5% $1,726.76 $418.28 $720,733 $140,543 $580,190 22 0.0% $2,145.04 80.5% $1,726.76 $418.28 $566,291 $110,427 $455,864 $0.00 0.0% EE+ Child(ren) 2 $2,051.78 80.5% $1,651.68 $400.10 $49,243 $9,602 $39,640 2 0.0% $2,051.78 80.5% $1,651.68 $400.10 $49,243 $9,602 $39,640 $0.00 0.0% Family 13 $2,490.13 80.5% $2,004.55 $485.58 $388,460 $75,750 $312,711 14 0.0% $2,490.13 80.5% $2,004.55 $485.58 $418,342 $81,577 $336,765 $0.00 0.0% 84 82 HDHP Employee 6 -14.5% $797.39 84.7% $675.68 $121.71 $57,412 $8,763 $48,649 EE+Spouse 0 -14.5% $1,834.01 84.7% $1,554.08 $279.93 $0 $0 $0 EE+ Child(ren) 1 -14.5% $1,754.27 84.7% $1,486.51 $267.76 $21,051 $3,213 $17,838 Family 0 -14.5% $2,129.06 84.7% $1,804.10 $324.96 $0 $0 $0 7 516 Annual Total $9,992,910 $1,948,618 $8,044,293 534 Annual Total $10,054,697 $1,957,342 $8,097,356 Annual Change (%) $61,787 $8,724 $53,063 Annual Change ($) 0.6% 0.4% 0.7% Contribution Split Contribution 100.0% 19.5% 80.5% Contribution Split 100.0% 19.5% 80.5% 2022 EBS Services & Capabilities 44