Vision RPF Q&A #28.xlsx

XLSX spreadsheet 23 KB Posted Mar 12, 2018

Attached to: Vision Insurance Plan Administration for CSC
Solicitation number: RFP-171-180000001030-4
Issued by: Grand Traverse County, Lansing City, Michigan

About this file

Written by GovTribe AI · Feb 13, 2025

This file is an Excel spreadsheet containing detailed Vision Plan enrollment data for active employees and retirees during calendar years 2016 and 2017. The data breaks down monthly enrollment numbers across different coverage tiers including Employee/Retiree Only, Employee/Retiree & Spouse, Employee/Retiree & Children, and Full Family coverage, with active employees also having a Waive Plan option.

For active employees, the data tracks employee counts, dependent counts, and total member counts across all coverage tiers. In 2016, total active enrollment ranged from approximately 115,930 to 117,161 members, while 2017 saw slightly lower numbers ranging from about 115,941 to 116,775 members. Retiree enrollment remained relatively stable across both years, with total enrollments ranging from approximately 54,681 to 55,741 members. The data shows a slight trend toward single coverage over family coverage during this period.

View the file

Other files

File	Type	Posted
Schedule A - Final.docx	DOCX document	Mar 12, 2018
Schedule C - Plan Design Final.docx	DOCX document	Mar 12, 2018
Schedule E - HIPAA 834 File Layouts Final.pdf	PDF	Mar 12, 2018
Schedule D - GeoAccess Data Final_Rev 2-28-18.xlsx	XLSX spreadsheet	Mar 12, 2018
Standard Contract Terms Final.docx	DOCX document	Mar 12, 2018
Vision RPF Q&A #33.xlsx	XLSX spreadsheet	Mar 12, 2018
Proposal Instructions and Vendor Questions Worksheet Final.docx	DOCX document	Mar 12, 2018
Schedule B - Pricing Matrix Final.xlsx	XLSX spreadsheet	Mar 12, 2018
Schedule G - Provider Location Data for Disruption Analysis Final_Rev 2-28-18.xlsx	XLSX spreadsheet	Mar 12, 2018
Schedule H - Sample Claims Report and Invoice Format Final.xlsx	XLSX spreadsheet	Mar 12, 2018
Schedule I - SLA Reporting Format Final.pdf	PDF	Mar 12, 2018
RFP 180000001030 Questions and Answers Final.docx	DOCX document	Mar 12, 2018
Schedule F - Provider Cost Claims Data Final.XLSX	XLSX spreadsheet	Mar 12, 2018
Schedule J Safeguard Requirements of Confidential Data Final.docx	DOCX document	Mar 12, 2018

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 Feb 13, 2025.