RFP_31786-00192_Appendix_7.10_Census_of_Enrolled_June_2026_REVISED.xlsx

XLSX spreadsheet 43 KB Posted

Attached to
Voluntary, Fully-Insured Vision Insurance Plan - UPDATED
Solicitation number
RFP 31786-00192
Issued by
Tennessee

About this file

This file is a Census of Enrolled Members as of June 2026 for the State of Tennessee's Voluntary, Fully-Insured Vision Insurance Plan RFP 31786-00192. The spreadsheet provides enrollment data across five subscriber categories (employee only, employee plus one, employee plus two, employee plus three or more, and retiree) broken down by both Basic Vision and Expanded Vision benefit options. The RFP seeks proposals for a fully-insured vision insurance plan covering eligible state employees, local education and local government employees, retirees, and dependents across Tennessee's 83 counties and national coverage. The plan offers two distinct benefit options with specified frame and contact lens allowances, with contract performance running from January 1, 2028 through December 31, 2032. The pre-response conference is scheduled for August 21, 2026, with technical proposal responses due November 6, 2026. Technical evaluation is targeted for completion by December 17, 2026, with cost proposal opening on December 18, 2026, negotiations scheduled for January 6-8, 2027, and Notice of Intent to Award on January 28, 2027.

The enrolled population as of June 2026 totals approximately 175,000 members across all coverage types and geographic areas spanning all 50 states and the District of Columbia. Utilization projections indicate monthly paid claims ranging from $550,000 to $1.088 million across both plan options, with exams representing the highest-volume service category. Respondents must hold a current Tennessee Certificate of Authority and demonstrate at least six years of experience providing group vision insurance to at least five employer accounts, with at least one account serving 10,000 members. The evaluation methodology weighs general qualifications (10 points), technical qualifications (20 points), network analysis (30 points), and cost proposals (40 points) for a total of 100 points, with award made to the responsive and responsible respondent offering the best combination of attributes rather than necessarily the lowest cost. The current incumbent vendor is EyeMed Vision, and all proposals must remain valid for at least 120 days following cost proposal opening.

View the file

Other files

File Type Posted
RFP_31786-00192_Vision_Release_3.docx DOCX document
RFP_31786-00192_Appendix_7_15_Vision_Premium_Rates.xlsx XLSX spreadsheet
RFP_31786-00192_Appendix_7_16_Vision_Enrollment_Including_Zip_and_Status-1.xlsx XLSX spreadsheet
RFP_31786-00192_Appendix_7_5%20Enrollment_by_Coverage_2023_June_2026_REVISED.xlsx XLSX spreadsheet
RFP_31786-00192_Amendment_2.docx DOCX document
RFP_31786-00192_Vision_Release_2.docx DOCX document
RFP_31786-00192_Amendment_One.docx DOCX document
RFP_31786-00192_Appendix_7.12_Expanded_Plan_Certificate_Eff.%201-1-26_.docx DOCX document
RFP_31786-00192_Appendix_7.7_Basic_Plan_Vision_Utilization_by_Year2023-June2026.xlsx XLSX spreadsheet
RFP_31786-00192_Appendix_7.11_Basic_Plan_Certificate_Eff.%201-1-26_.docx DOCX document
RFP_31786-00192_Appendix_7.9_HIPAA_Business_Associate_Assessment.xlsx XLSX spreadsheet
RFP%2031786-00192%20Attachment%206.3%20Cost%20Proposal.xlsx XLSX spreadsheet
RFP%2031786-00192%20Vision.docx DOCX document
RFP_31786-00192_Appendix_7.6_Benefits_Administration_834_Guidance_Manual.docx DOCX document
31786-00192%20Digital%20Submission%20Instructions.docx DOCX document
RFP_31786-00192_Appendix_7.10_Census_of_Enrolled_as_of_June_2026.xlsx XLSX spreadsheet
RFP_31786-00192_Appendix_7.14_Written_QuestionsComments_Template.xlsx XLSX spreadsheet
RFP_31786-00192_Appendix_7.4_Eligibility_and_Enrollment_Counts_by_Zip_Code.xlsx XLSX spreadsheet
RFP_31786-00192_Appendix_7.2_Quest_Analytics_Access_Report_Instructions.docx DOCX document
RFP_31786-00192_Appendix_7.8_Expanded_Plan_Vision_Utilization_by_Year_2023%20June%202026.xlsx XLSX spreadsheet
RFP_31786-00192_Appendix_7.3_Sample_Quest_Analytics_Analysis_Report.docx DOCX document
RFP_31786-00192_Appendix_7.13_Plan_Benefit_Changes.xlsx XLSX spreadsheet
RFP_31786-00192_Appendix_7.1_Premium_Collections2023-June2026.xlsx XLSX spreadsheet
RFP_31786-00192_Appendix_7.5_Enrollment_by_Coverage_2023%E2%80%93June_2026.xlsx XLSX spreadsheet
Show all 24

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1 RFP 31786-00192 Appendix 7.10 Census of Enrolled as of June 2026 REVISED

DependentEE/RetireeGrand Total
Coverage CodeBirth yearGenderVision BasicVision ExpandedVision BasicVision Expanded
Employee + Children1942M11
1944F11
1946M11
1949F11
M11
1950M11
1951F11
1952M112
1953M44
1954F112
M123
1955F11
M33
1956F22
M437
1957F33
M224
1958F11
M156
1959F4913
M246
1960F11314
M6612
1961F73340
M41317
1962F132740
M92332
1963F83038
M92029
1964F156378
M103545
1965F206888
M152843
1966F206585
M112435
1967F2679105
M173148
1968F35112147
M183755
1969F33127160
M274370
1970F55145200
M176582
1971F58177235
M3071101
1972F49177226
M246589
1973F46216262
M326395
1974F58213271
M286795
1975F174219294
M316899
1976F70242312
M3087117
1977F83249332
M3875113
1978F83243326
M286290
1979F102236338
M3487121
1980F113252365
M356095
1981F101230331
M365894
1982F114260374
M1415698
1983F102197299
M376299
1984F123188311
M414182
1985F106182288
M4361104
1986F104170274
M335083
1987F90170260
M455499
1988F92168260
M3464594
1989F290139231
M11405496
1990F92169261
M1284372
1991F85124209
M3282657
1992F7682158
M2332762
1993F36098161
M222143
1994F16469134
M1182342
1995F116458124
M241943
1996F14753101
M11182040
1997F1504495
M1181130
1998F2323872
M14111127
1999F11192243
M317626
2000F541981617285
M5616039228
2001F8227397371
M8227033358
2002F9732868439
M9530325405
2003F11135623472
M10532123431
2004F1253591485
M127338465
2005F1363821519
M1423602504
2006F120373493
M1343761511
2007F143383526
M139365504
2008F146359505
M157348505
2009F121319440
M125321446
2010F111313424
M138305443
2011F132292424
M134248382
2012F132300432
M126247373
2013F124272396
M139266405
2014F133262395
M145278423
2015F132201333
M139208347
2016F103228331
M111230341
2017F120192312
M128205333
2018F135183318
M106200306
2019F103152255
M139174313
2020F106125231
M110151261
2021F95139234
M96146242
2022F102119221
M106107213
2023F93111204
M88107195
U11
2024F8086166
M8679165
2025F7170141
M8079159
2026F261743
M291847
Employee + Spouse1933M11
1934M11
1936M22
1937M11
1938M213
1939M314
1940F11
M11
1941F112
M415
1942F11
M314
1943F112
M161412
1944F1315
M281516
1945F13116
M91717
1946F1427
M2111225
1947F131712
M3221540
1948F372315
M13361959
1949F2172728
M52941755
1950F32321543
M54782686
1951F53211048
M650539100
1952F104532280
M859854129
1953F94112071
M13651546139
1954F755934105
M1881863170
1955F1256737112
M231061283224
1956F12841349158
M311252393272
1957F23981564200
M271202498269
1958F22981791228
M2717927137370
1959F3313726128324
M3720734123401
1960F2914832160369
M4119537175448
1961F4719157217512
M9331359241706
U11
1962F8221176297666
M8131960236696
1963F4621882350696
M9234163239735
1964F53217100341711
M9934481224748
1965F6821886353725
M7230674209661
1966F5718088317642
M6628356225630
U11
1967F6119853304616
M6325857175553
1968F4619569303613
M6121733172483
1969F5318479324640
M5720747190501
1970F5019357287587
M6721639183505
1971F4417154286555
M6221540148465
1972F3811865225446
M3219638137403
1973F3113440186391
M3415531100320
U11
1974F3711453163367
M5511620106297
1975F1810557127307
M431093479265
1976F258340122270
M34932274223
1977F289934120281
M50663370219
1978F25744192232
M36842377220
1979F35804485244
M32763766211
1980F26704180217
M38723378221
1981F38643876216
M28633260183
1982F31704384228
M37733665211
1983F29543569187
M30653258185
1984F36483268184
M34664057197
1985F30653778210
M37804056213
1986F46623261201
M52754754228
1987F33755174233
M54685461237
1988F49694872238
M39705558222
1989F51734495263
M50694967235
1990F54917483302
M45764671238
1991F53784878257
M57825071260
1992F63624783255
M58755469256
1993F61734885267
M55706174260
1994F58636080261
M54825477267
1995F56817086293
M45766168250
1996F69707970288
M47575764225
1997F73886562288
M48475451200
1998F67775066260
M46474163197
1999F55545359221
M47463452179
2000F38603648182
M43343142150
2001F20382529112
M2019202281
2002F1429121570
M811101847
2003F81791145
M474722
2004F4101520
M162514
2005F4228
M1225
2006F2417
M1113
Family1943M11
1944M22
1945M213
1946M112
1947M123
1948F11
M22
1949M22149
1950M33
1951M2316
1952F112
M241310
1953F22
M58215
1954F11
M35412
1955F437
M2113723
1956F12115
M21861844
1957F283316
M41841137
1958F17210
M63051960
1959F473519
M93453482
1960F41131028
M12461135104
1961F81932050
M24571447142
1962F1028113281
M24801265181
1963F12401040102
M241072773231
1964F13551562145
M281162598267
1965F11611773162
M3712628132323
1966F288326107244
M4715549112363
1967F2910023106258
M4616737137387
1968F3711134162344
M6021433182489
1969F3816061191450
M6722673212578
1970F4716859236510
M5930458264685
1971F5422163290628
M8031360230683
1972F5619673289614
M8030481242707
1973F4422079273616
M8728173237678
1974F8823587304714
M8432582233724
1975F6124776315699
M11428881233716
1976F91255115332793
M11729772246732
1977F98261115352826
M134291100248773
1978F75283110323791
M100291112257760
1979F96253121330800
M11727997260753
1980F117309128320874
M126274116244760
1981F108263141302814
M116236103221676
1982F128232147287794
M115239123220697
1983F116241132239728
M111229104205649
1984F112233116254715
M107214134154609
1985F137225105212679
M95181116204596
1986F106223107233669
M93179112173557
1987F12317091176560
M79145104152480
1988F11417298175559
M69133119147468
1989F13716394152546
M86126100148460
1990F137168101134540
M8512195142443
1991F9614685127454
M958581112373
1992F10512588101419
M71818389324
1993F821079593377
M61767864279
1994F901117087358
M52706669257
1995F83946375315
M51596064234
1996F76857552288
M38455268203
1997F46732738184
M28264038132
1998F48463840172
M34322730123
1999F27352419105
M2217191876
2000F10037999497
M103351149477
2001F18062464814
M15257199741
2002F18766232854
M17768046867
2003F19467821875
M18670324895
U11
2004F210764974
M2147442960
2005F199727926
M2267451972
2006F233711944
M236735971
2007F237714951
M223709932
2008F237690927
M252697949
2009F234637871
M227687914
2010F201618819
M264617881
U11
2011F238601839
M254620874
U11
2012F234567801
M271549820
2013F250579829
M235563798
2014F217528745
M256501757
2015F236437673
M268508776
U11
2016F241445686
M240458698
2017F244426670
M278437715
2018F221366587
M249364613
2019F232334566
M237351588
2020F224315539
M245292537
2021F234281515
M246309555
2022F218273491
M229268497
2023F203222425
M238259497
U11
2024F202193395
M197222419
2025F167185352
M200191391
2026F5549104
M5849107
One Child Only1978M11
1979F11
1981F11
M22
1982F11
1983F11
1986F11
M11
1988M33
1989M11
1990F11
1991F11
M11
1993F11
1996M11
1999F11
2000F33
M22
2001F268
M336
2002F112
M44
2003F21012
2004F44
M11
2005F145
M213
2006M11
2007F11
M11
2008F112
M112
2009M213
2010F11
M11
2011M11
2012F22
2013F11
2015F22
2016M11
Single1936F11
1937M11
1938F11
M22
1939F22
M22
1940F112
M123
1941F112
M44
1942F134
M123
1943F167
M22
1944F55
M22
1945F178
M336
1946F1010
M178
1947F358
M99
1948F32225
M279
1949F52833
M51520
1950F53439
M31518
1951F93847
M52328
1952F127082
M62935
1953F147993
M63743
1954F1790107
M112940
1955F2598123
M124860
1956F25140165
M126577
1957F39171210
M3177108
1958F45192237
M2980109
1959F77261338
M3194125
1960F94342436
M34111145
1961F218734952
M95218313
1962F243753996
M78262340
1963F213769982
M88247335
1964F189680869
M85263348
1965F173650823
M107261368
1966F174581755
M86234320
1967F159603762
M80229309
1968F186590776
M83224307
1969F157610767
M81257338
1970F167602769
M98229327
1971F168559727
M103203306
1972F157461618
M73211284
1973F140439579
M86201287
1974F138421559
M75190265
1975F138435573
M87182269
1976F150383533
M99173272
1977F164378542
M69147216
1978F132353485
M67151218
1979F145332477
M86176262
1980F164364528
M81153234
1981F157330487
M92170262
1982F175340515
M106153259
1983F165301466
M104178282
1984F171342513
M101169270
1985F175314489
M113161274
1986F178328506
M99165264
1987F188349537
M140191331
1988F210364574
M140200340
1989F253380633
M143206349
1990F277398675
M151219370
1991F281377658
M140231371
1992F258364622
M172222394
1993F266370636
M164220384
1994F260391651
M165207372
1995F306378684
M172253425
1996F299383682
M188240428
1997F333428761
M184251435
1998F348420768
M180250430
1999F318369687
M200235435
2000F252363615
M142179321
2001F189262451
M114160274
2002F137170307
M93126219
2003F95108203
M5663119
2004F4361104
M5160111
2005F203151
M325183
2006F132538
M201737
2007F415
M91019
Spouse + Child(ren) Only1958F11
1961F22
M22
1962F145
1963F246
1964F22
1965F246
1966F213
M11
1967F22
1968F33
1969F11
1970F22
1971F134
1972F112
1973M11
1974F11
1975F11
1976F11
1977F11
M11
1978F112
1979F11
1980F11
1981F11
1985M11
1986F11
1991F11
M11
1993M11
2000F112
M213
2001F123
M213
2002F224
M145
2003F224
M44
2004F178
M11
2005M325
2006F123
M22
2007F134
M213
2008M33
2009F112
M11
2010F11
2011F123
M11
2012F22
M11
2013M11
2014F11
M22
2016F22
M11
2017M11
2018F11
2021F11
2024U11
Spouse Only1961F227395
M72532
1962F124153
M101222
1963F163046
M3912
1964F62935
M178
1965F62127
M628
1966F111122
M145
1967F3710
M123
1968F3710
M33
1969F33
M11
1970F325
M33
1971F336
M11
1972F123
M11
1973F145
1974F11
1975F11
1976F11
M11
1977F11
1980F11
1992F11
Two or more Children Only2000F325
2001F11
M22
2002F11
M33
2003F11
M11
2004F11
2005F11
2006F11
M213
2007F11
M213
2008M123
2009F11
M11
2010M11
2011F11
2013M11
2017F11
2020F11
Grand Total28,04664,65728,18562,332183,220

File details come from the government source that posted it. Updated .