Vision RPF Q&A #28.xlsx
XLSX spreadsheet 23 KB Posted
- Attached to
- Vision Insurance Plan Administration for CSC
- Solicitation number
- RFP 171 180000001030 4
- Issued by
- Michigan
About this file
This file contains enrollment data related to Vision Voluntary Supplemental (VS) health plans for active employees and retirees across calendar years 2016 and 2017. The data tracks membership across five enrollment categories: Employee Only, Employee & Spouse, Employee & Children, Full Family, and Waive Plan for active employees, with separate tracking for retirees by coverage type.
Active employee enrollment in 2016 ranged from 116,415 to 117,161 total members monthly, with consistent representation across all coverage categories. Retiree enrollment remained relatively stable throughout 2016, ranging from 54,681 to 55,320 total enrollments monthly. In 2017, active employee enrollment showed a similar pattern, ranging from 115,941 to 116,775 total members monthly, while retiree enrollment remained steady between 55,409 and 55,747 total enrollments monthly. Employee-only plans represented the largest employee enrollment segment in both years, while retiree-only plans dominated retiree enrollments. The data indicates stable utilization of voluntary vision benefits across both populations, with dependent participation remaining consistent throughout the two-year period reviewed.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Vision RPF Q&A #33.xlsx | XLSX spreadsheet | |
| Schedule J Safeguard Requirements of Confidential Data Final.docx | DOCX document | |
| Schedule C - Plan Design Final.docx | DOCX document | |
| Schedule D - GeoAccess Data Final_Rev 2-28-18.xlsx | XLSX spreadsheet | |
| Schedule I - SLA Reporting Format Final.pdf | ||
| Schedule F - Provider Cost Claims Data Final.XLSX | XLSX spreadsheet | |
| RFP 180000001030 Questions and Answers Final.docx | DOCX document | |
| Standard Contract Terms Final.docx | DOCX document | |
| Schedule A - Final.docx | DOCX document | |
| Schedule E - HIPAA 834 File Layouts Final.pdf | ||
| Proposal Instructions and Vendor Questions Worksheet Final.docx | DOCX document | |
| Schedule B - Pricing Matrix Final.xlsx | XLSX spreadsheet | |
| Schedule G - Provider Location Data for Disruption Analysis Final_Rev 2-28-18.xlsx | XLSX spreadsheet | |
| Schedule H - Sample Claims Report and Invoice Format Final.xlsx | XLSX spreadsheet |
Show all 14
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
2016 VS Plans_Active Employees
| CY2016 | Employee Only | Employee & Spouse | Employee & Children | Full Family | Waive Plan | Total | |
| January | Employee Count | 12,702 | 9,357 | 6,131 | 16,792 | 2,365 | 47,347 |
| Dependent Count | 0 | 9,357 | 9,830 | 50,627 | 0 | 69,814 | |
| Total Members | 12,702 | 18,714 | 15,961 | 67,419 | 2,365 | 117,161 | |
| February | Employee Count | 12,733 | 9,328 | 6,162 | 16,709 | 2,386 | 47,318 |
| Dependent Count | 0 | 9,328 | 9,898 | 50,402 | 0 | 69,628 | |
| Total Members | 12,733 | 18,656 | 16,060 | 67,111 | 2,386 | 116,946 | |
| March | Employee Count | 12,926 | 9,355 | 6,183 | 16,665 | 2,401 | 47,530 |
| Dependent Count | 0 | 9,355 | 9,896 | 50,227 | 0 | 69,478 | |
| Total Members | 12,926 | 18,710 | 16,079 | 66,892 | 2,401 | 117,008 | |
| April | Employee Count | 13,004 | 9,323 | 6,198 | 16,613 | 2,394 | 47,532 |
| Dependent Count | 0 | 9,323 | 9,925 | 50,073 | 0 | 69,321 | |
| Total Members | 13,004 | 18,646 | 16,123 | 66,686 | 2,394 | 116,853 | |
| May | Employee Count | 13,033 | 9,275 | 6,191 | 16,579 | 2,378 | 47,456 |
| Dependent Count | 0 | 9,275 | 9,913 | 49,940 | 0 | 69,128 | |
| Total Members | 13,033 | 18,550 | 16,104 | 66,519 | 2,378 | 116,584 | |
| June | Employee Count | 13,178 | 9,347 | 6,167 | 16,487 | 2,390 | 47,569 |
| Dependent Count | 0 | 9,347 | 9,836 | 49,663 | 0 | 68,846 | |
| Total Members | 13,178 | 18,694 | 16,003 | 66,150 | 2,390 | 116,415 | |
| July | Employee Count | 13,130 | 9,336 | 6,121 | 16,476 | 2,406 | 47,469 |
| Dependent Count | 0 | 9,336 | 9,745 | 49,591 | 0 | 68,672 | |
| Total Members | 13,130 | 18,672 | 15,866 | 66,067 | 2,406 | 116,141 | |
| August | Employee Count | 13,154 | 9,310 | 6,095 | 16,457 | 2,418 | 47,434 |
| Dependent Count | 0 | 9,310 | 9,695 | 49,491 | 0 | 68,496 | |
| Total Members | 13,154 | 18,620 | 15,790 | 65,948 | 2,418 | 115,930 | |
| September | Employee Count | 13,153 | 9,348 | 6,100 | 16,486 | 2,444 | 47,531 |
| Dependent Count | 0 | 9,348 | 9,720 | 49,650 | 0 | 68,718 | |
| Total Members | 13,153 | 18,696 | 15,820 | 66,136 | 2,444 | 116,249 | |
| October | Employee Count | 13,053 | 9,480 | 6,092 | 16,610 | 2369 | 47,604 |
| Dependent Count | 0 | 9,480 | 9,731 | 50,054 | 0 | 69,265 | |
| Total Members | 13,053 | 18,960 | 15,823 | 66,664 | 2,369 | 116,869 | |
| November | Employee Count | 13,043 | 9,476 | 6,100 | 16,636 | 2382 | 47,637 |
| Dependent Count | 0 | 9,476 | 9,744 | 50,123 | 0 | 69,343 | |
| Total Members | 13,043 | 18,952 | 15,844 | 66,759 | 2,382 | 116,980 | |
| December | Employee Count | 13,037 | 9,471 | 6,104 | 16,592 | 2393 | 47,597 |
| Dependent Count | 0 | 9,471 | 9,729 | 49,950 | 0 | 69,150 | |
| Total Members | 13,037 | 18,942 | 15,833 | 66,542 | 2,393 | 116,747 |
2016 VS Plans_Retirees
| CY2016 | Retiree Only | Retiree & Spouse | Retiree & Children | Full Family | Total | |
| January | Total Enrollments | 28,347 | 987 | 23,782 | 1,908 | 55,024 |
| February | Total Enrollments | 28,396 | 976 | 23,859 | 1,908 | 55,139 |
| March | Total Enrollments | 28,355 | 960 | 23,793 | 1,892 | 55,000 |
| April | Total Enrollments | 28,431 | 942 | 23,932 | 1,849 | 55,154 |
| May | Total Enrollments | 28,476 | 939 | 23,931 | 1,854 | 55,200 |
| June | Total Enrollments | 28,501 | 941 | 23,958 | 1,863 | 55,263 |
| July | Total Enrollments | 28,543 | 927 | 23,985 | 1,844 | 55,299 |
| August | Total Enrollments | 28,559 | 928 | 24,007 | 1,826 | 55,320 |
| September | Total Enrollments | 28,563 | 927 | 23,955 | 1,830 | 55,275 |
| October | Total Enrollments | 28,125 | 881 | 23,893 | 1,782 | 54,681 |
| November | Total Enrollments | 28,599 | 880 | 23,989 | 1,793 | 55,261 |
| December | Total Enrollments | 28,621 | 869 | 24,001 | 1,776 | 55,267 |
2017 VS Plans_Active Employees
| CY2017 | Employee Only | Employee & Spouse | Employee & Children | Full Family | Waive Plan | Total | |
| January | Employee Count | 13,001 | 9,368 | 6,091 | 16,582 | 2,391 | 47,433 |
| Dependent Count | 0 | 9,368 | 9,689 | 49,925 | 0 | 68,982 | |
| Total Members | 13,001 | 18,736 | 15,780 | 66,507 | 2,391 | 116,415 | |
| February | Employee Count | 13,046 | 9,304 | 6,113 | 16,584 | 2397 | 47,444 |
| Dependent Count | 0 | 9,304 | 9,726 | 49,886 | 0 | 68,916 | |
| Total Members | 13,046 | 18,608 | 15,839 | 66,470 | 2,397 | 116,360 | |
| March | Employee Count | 13,144 | 9,344 | 6,126 | 16,572 | 2433 | 47,619 |
| Dependent Count | 0 | 9,344 | 9,747 | 49,838 | 0 | 68,929 | |
| Total Members | 13,144 | 18,688 | 15,873 | 66,410 | 2,433 | 116,548 | |
| April | Employee Count | 13,247 | 9,339 | 6,126 | 16,535 | 2440 | 47,687 |
| Dependent Count | 0 | 9,339 | 9,726 | 49,718 | 0 | 68,783 | |
| Total Members | 13,247 | 18,678 | 15,852 | 66,253 | 2,440 | 116,470 | |
| May | Employee Count | 13,232 | 9,319 | 6,124 | 16,511 | 2,438 | 47,624 |
| Dependent Count | 0 | 9,319 | 9,732 | 49,672 | 0 | 68,723 | |
| Total Members | 13,232 | 18,638 | 15,856 | 66,183 | 2,438 | 116,347 | |
| June | Employee Count | 13,367 | 9,346 | 6,100 | 16,475 | 2,437 | 47,725 |
| Dependent Count | 0 | 9,346 | 9,702 | 49,482 | 0 | 68,530 | |
| Total Members | 13,367 | 18,692 | 15,802 | 65,957 | 2,437 | 116,255 | |
| July | Employee Count | 13,399 | 9,322 | 6,097 | 16,414 | 2,438 | 47,670 |
| Dependent Count | 0 | 9,322 | 9,683 | 49,284 | 0 | 68,289 | |
| Total Members | 13,399 | 18,644 | 15,780 | 65,698 | 2,438 | 115,959 | |
| August | Employee Count | 13,373 | 9,313 | 6,051 | 16,433 | 2,485 | 47,655 |
| Dependent Count | 0 | 9,313 | 9,599 | 49,374 | 0 | 68,286 | |
| Total Members | 13,373 | 18,626 | 15,650 | 65,807 | 2,485 | 115,941 | |
| September | Employee Count | 13,432 | 9,377 | 6,069 | 16,433 | 2,495 | 47,806 |
| Dependent Count | 0 | 9,376 | 9,636 | 49,416 | 0 | 68,428 | |
| Total Members | 13,432 | 18,753 | 15,705 | 65,849 | 2,495 | 116,234 | |
| October | Employee Count | 13,276 | 9,529 | 6,059 | 16,552 | 2,413 | 47,829 |
| Dependent Count | 0 | 9,529 | 9,645 | 49,772 | 0 | 68,946 | |
| Total Members | 13,276 | 19,058 | 15,704 | 66,324 | 2,413 | 116,775 | |
| November | Employee Count | 13,190 | 9,543 | 6,041 | 16,520 | 2,410 | 47,704 |
| Dependent Count | 0 | 9,543 | 9,604 | 49,664 | 0 | 68,811 | |
| Total Members | 13,190 | 19,086 | 15,645 | 66,184 | 2,410 | 116,515 | |
| December | Employee Count | 13,170 | 9,506 | 6,011 | 16,476 | 2,419 | 47,582 |
| Dependent Count | 0 | 9,506 | 9,566 | 49,498 | 0 | 68,570 | |
| Total Members | 13,170 | 19,012 | 15,577 | 65,974 | 2,419 | 116,152 |
2017 VS Plans_Retirees
| CY2017 | Retiree Only | Retiree & Spouse | Retiree & Children | Full Family | Total | |
| January | Total Enrollments | 28,687 | 863 | 24,103 | 1,784 | 55,437 |
| February | Total Enrollments | 28,718 | 846 | 24,111 | 1,734 | 55,409 |
| March | Total Enrollments | 28,756 | 847 | 24,106 | 1,742 | 55,451 |
| April | Total Enrollments | 28,779 | 850 | 24,108 | 1,742 | 55,479 |
| May | Total Enrollments | 28,841 | 834 | 24,154 | 1,724 | 55,553 |
| June | Total Enrollments | 28,822 | 819 | 24,211 | 1,717 | 55,569 |
| July | Total Enrollments | 28,926 | 828 | 24,261 | 1,701 | 55,716 |
| August | Total Enrollments | 28,954 | 821 | 24,285 | 1,679 | 55,739 |
| September | Total Enrollments | 28,950 | 831 | 24,289 | 1,671 | 55,741 |
| October | Total Enrollments | 28,973 | 819 | 24,310 | 1,645 | 55,747 |
| November | Total Enrollments | 28,948 | 819 | 24,321 | 1,646 | 55,734 |
| December | Total Enrollments | 28,945 | 800 | 24,370 | 1,626 | 55,741 |
File details come from the government source that posted it. Updated .