Appendix 9 Census Data Life Summary Report Basic and Optional Age Count 1000 Units.xlsm

XLSM spreadsheet 71 KB Posted Apr 24, 2020

Attached to: Life Insurance Services - Technical Proposal Only
Solicitation number: 20-416CMS-BENF4-B-12595
Issued by: St. Clair County, Illinois

About this file

Written by GovTribe AI · Aug 1, 2024

This document contains information about a state and local contract opportunity for Life Insurance Services posted by the Illinois Department of Central Management Services. The department is seeking a vendor to provide a group life and accidental death & dismemberment (AD&D) insurance program for its employees and annuitants. This bid is for the technical proposal only, and pricing information should be submitted separately under Bid Number B-14561. The response must be submitted electronically, as no paper responses will be accepted. The contract term is not specified.

The document provides detailed census data and plan information for the basic life, optional life, AD&D, spouse life, and child life coverages. It includes the age distribution, insurance amounts, and counts for each type of coverage. Pricing terms, set-asides, incumbents, funding sources, and other financial details are not included in this technical proposal document.

View the file

Other files

File	Type	Posted
Addendum 1_3.doc	DOC document	Apr 24, 2020
Appendix 8 Census Data.xlsx	XLSX spreadsheet	Apr 24, 2020
Attachment - Notice of Electronic Submission Only v.20.2.pdf	PDF	Apr 24, 2020
CMS Benefits B12595 Notice of Award Form Life Insurance Services_1.pdf	PDF	Apr 24, 2020
Met. Life Protest.zip	ZIP file	Apr 24, 2020
Appendix 10 Certificate of Insurance.pdf	PDF	Apr 24, 2020
Forms A~24.doc	DOC document	Apr 24, 2020
Group Life Insurance RFP.docx	DOCX document	Apr 24, 2020
MetLife Protest CPO Determination.pdf	PDF	Apr 24, 2020
Utilization Plan Version 20.0.pdf	PDF	Apr 24, 2020
Question 18 - Act vs. Ret.pdf	PDF	Apr 24, 2020
Appendices 1 thru 7.xlsx	XLSX spreadsheet	Apr 24, 2020
Question 18 - Financial Experience July 2019 through March 2020.xlsx	XLSX spreadsheet	Apr 24, 2020
Vendor Instruction to submit Technical Proposals B-12595.docx	DOCX document	Apr 24, 2020
CountyCodes.xlsx	XLSX spreadsheet	Apr 24, 2020
Forms B Section V.20.1~17.docx	DOCX document	Apr 24, 2020
Group Life Insurance RFP Revisions 5-19-20.docx	DOCX document	Apr 24, 2020
Question 18 - Optional Life Split.docx	DOCX document	Apr 24, 2020

Show all 18

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.

Circuit Breakers

Actives
Occ Discount	Limit
-20%	80%
-14%	75%
0%	70%
6%	70%
7%	70%
16%	70%
25%	70%

Sheet2

ERROR:#REF!
	Basic	Supp
Manual	ERROR:#REF!	ERROR:#REF!
Participation Load	0.00%	ERROR:#REF!
Manual Claim Rate without Participation Load	ERROR:#REF!	ERROR:#REF!
Table I	ERROR:#REF!	ERROR:#REF!
Experience Claim Rate	ERROR:#REF!	ERROR:#REF!
Male Percentage	ERROR:#REF!	ERROR:#REF!
Average Age	ERROR:#REF!	ERROR:#REF!
Average Salary of Insureds	$ - 0	$ - 0
Experience Claim Rate / Manual	ERROR:#REF!	ERROR:#REF!
Experience Claim Rate / Manual (without Participation Load)	ERROR:#REF!	ERROR:#REF!
Blended Claim Rate Used in Pricing	ERROR:#REF!	ERROR:#REF!
Blended Claim Rate to Exper. CR (2)	ERROR:#REF!	ERROR:#REF!

SUPP PLAN
Participation	40%
Coverage Available	10K - 700K
GI	$250K
Waiver?	ERROR:#REF!
Annual GI Increases?	No

CENSUS DISTRIBUTION
	Count	Volume	% of Total
Above $250K:			ERROR:#DIV/0!
At $250K:			ERROR:#DIV/0!
Below $250K:			ERROR:#DIV/0!
Total:			ERROR:#DIV/0!
PRICING NOTES

Basic Life Coverage

	BASIC LIFE
AGE	COUNT	INS (000)
18	6	215
19	29	901
20	82	2,884
21	167	6,321
22	287	10,734
23	517	20,899
24	839	35,609
TOTAL	1,892	76,447
25	1,129	50,262
26	1,289	59,562
27	1,566	75,383
28	1,878	94,054
29	2,108	108,526
TOTAL	7,970	387,786
30	2,268	123,711
31	2,249	127,615
32	2,406	138,772
33	2,435	145,523
34	2,521	158,502
TOTAL	11,879	694,123
35	2,531	158,958
36	2,527	163,326
37	2,564	166,572
38	2,675	178,607
39	2,595	173,802
TOTAL	12,892	841,265
40	2,797	188,348
41	2,719	188,687
42	2,674	193,239
43	2,817	202,412
44	2,758	202,464
TOTAL	13,765	975,151
45	2,842	213,769
46	2,884	213,601
47	3,064	229,238
48	3,224	244,221
49	3,563	275,399
TOTAL	15,577	1,176,229
50	3,431	262,826
51	3,478	269,131
52	3,416	262,588
53	3,415	267,407
54	3,500	270,738
TOTAL	17,240	1,332,690
55	3,892	301,512
56	4,170	326,527
57	4,216	324,436
58	4,377	333,397
59	4,520	347,203
TOTAL	21,175	1,633,075
60	4,536	229,784
61	4,766	181,522
62	4,825	164,427
63	5,004	148,249
64	4,980	132,103
TOTAL	24,111	856,085
65	5,162	119,932
66	4,976	103,444
67	5,149	86,802
68	5,139	78,648
69	5,039	65,625
TOTAL	25,465	454,450
70	4,859	58,180
71	4,914	50,722
72	4,650	43,822
73	4,929	43,082
74	3,351	29,323
TOTAL	22,703	225,129
75	3,165	25,976
76	3,091	22,665
77	3,129	21,996
78	2,562	16,663
79	2,292	13,515
TOTAL	14,239	100,816
80	2,014	12,617
81	1,995	11,645
82	1,709	10,278
83	1,580	8,585
84	1,377	7,491
TOTAL	8,675	50,616
85	1,310	7,183
86	1,082	5,806
87	982	5,073
88	835	4,313
89	776	3,868
TOTAL	4,985	26,243
90	743	3,787
91	570	2,835
92	482	2,380
93	404	2,027
94	339	1,680
TOTAL	2,538	12,709
95	236	1,159
96	176	865
97	146	715
98	104	520
99	71	343
TOTAL	733	3,602
100+	121	590

GRAND TOTAL 205,989 8,847,907

&"Arial,Regular"&10Appendix 6

Optional Life Coverage

OPTIONAL LIFE

TOTALS

AGE

COUNT

INS (000)

COUNT

INS (000)

COUNT

INS (000)

COUNT

INS (000)

COUNT

INS (000)

COUNT

INS (000)

COUNT

INS (000)

COUNT

INS (000)

COUNT

INS (000)

18	6	215	0	0	0	0	3	444	0	0	0	0	1	155	10	814
19	30	933	0	0	0	0	7	1,064	0	0	0	0	2	728	39	2,725
TOTAL	36	1,147	0	0	0	0	10	1,508	0	0	0	0	3	883	49	3,539
20	84	2,964	0	0	3	319	11	1,876	0	0	1	125	4	891	103	6,175
21	172	6,484	7	593	4	404	42	7,022	1	234	0	0	7	2,262	233	16,999
22	298	11,189	10	850	6	615	62	10,323	1	252	0	0	7	2,148	384	25,375
23	530	21,415	20	1,795	12	1,245	88	15,902	5	1,045	0	0	18	4,813	673	46,214
24	875	37,201	21	1,880	21	2,621	159	28,890	3	699	0	0	37	12,772	1,116	84,063
TOTAL	1,959	79,252	58	5,117	46	5,204	362	64,013	10	2,229	1	125	73	22,886	2,509	178,826

25	1,184	52,746	43	3,732	22	3,067	212	39,564	4	917	1	302	1	211	43	14,438	1,510	114,977
26	1,355	62,656	61	5,791	32	4,600	233	44,545	5	1,326	2	515	1	160	43	17,004	1,732	136,596
27	1,653	79,582	63	6,016	58	8,513	284	55,058	6	1,238	2	845	1	340	46	17,392	2,113	168,984
28	1,988	99,645	113	11,427	52	7,770	326	66,000	11	2,441	7	2,233	1	435	66	25,723	2,564	215,675
29	2,252	116,395	89	9,294	65	10,216	445	92,563	12	3,238	5	1,611	1	365	74	31,544	2,943	265,226
TOTAL	8,432	411,024	369	36,259	229	34,166	1,500	297,730	38	9,159	17	5,506	5	1,511	272	106,102	10,862	901,458

30	2,417	131,856	107	11,348	71	11,078	422	92,462	15	4,466	14	4,379	1	525	96	41,876	3,143	297,990
31	2,410	137,286	124	13,888	89	14,277	439	98,398	17	4,997	6	2,078	1	378	78	35,870	3,164	307,172
32	2,582	149,384	145	17,170	107	17,703	496	112,825	13	3,585	9	3,371	3	1,103	80	38,081	3,435	343,222
33	2,598	156,242	150	17,262	92	16,410	496	114,578	20	6,888	10	3,552	3	1,468	92	44,480	3,461	360,881
34	2,734	171,894	174	22,575	112	22,142	493	121,008	21	7,416	13	5,185	2	728	114	59,252	3,663	410,200
TOTAL	12,741	746,663	700	82,244	471	81,611	2,346	539,273	86	27,350	52	18,565	10	4,202	460	219,558	16,866	1,719,464

35	2,722	171,380	160	19,797	94	17,856	525	131,572	16	5,045	15	6,003	3	1,324	105	51,598	3,640	404,575
36	2,732	176,772	169	22,272	102	19,187	505	125,602	21	7,171	23	9,433	6	3,292	113	59,859	3,671	423,588
37	2,760	179,684	179	22,203	141	26,227	579	148,756	22	9,548	13	5,987	8	4,150	110	59,884	3,812	456,439
38	2,857	190,704	219	27,877	128	25,817	598	157,165	28	12,042	25	9,658	5	1,959	136	76,874	3,996	502,094
39	2,795	186,627	190	25,289	132	27,580	631	168,816	28	12,045	10	3,835	5	2,203	144	85,722	3,935	512,117
TOTAL	13,866	905,167	917	117,438	597	116,666	2,838	731,911	115	45,849	86	34,916	27	12,927	608	333,938	19,054	2,298,813

40	3,020	203,647	203	27,134	167	35,580	654	173,508	34	11,446	22	8,864	10	4,551	140	80,368	4,250	545,098
41	2,910	202,083	222	31,201	127	28,378	706	195,575	26	8,575	23	10,754	7	3,738	144	84,388	4,165	564,691
42	2,897	210,102	201	28,865	128	29,056	639	182,176	27	9,102	30	14,212	7	4,663	161	95,705	4,090	573,881
43	3,046	218,717	195	29,203	143	29,829	730	210,125	26	10,299	31	15,458	8	3,894	201	121,924	4,380	639,449
44	2,948	216,213	210	29,877	136	29,608	742	218,059	25	9,795	34	15,418	5	3,427	165	107,542	4,265	629,938
TOTAL	14,821	1,050,762	1,031	146,279	701	152,451	3,471	979,443	138	49,217	140	64,706	37	20,273	811	489,926	21,150	2,953,057

45	3,033	228,111	220	34,652	150	33,423	781	232,401	32	13,602	24	13,037	4	2,058	184	119,392	4,428	676,675
46	3,080	228,305	230	35,740	160	36,641	807	244,315	38	12,979	33	14,337	5	2,149	199	125,318	4,552	699,784
47	3,284	245,437	262	37,977	177	38,720	897	270,119	37	13,622	21	12,622	5	2,838	179	115,922	4,862	737,258
48	3,462	262,431	213	34,164	183	38,161	982	295,590	38	17,207	31	13,408	9	5,234	212	142,002	5,130	808,197
49	3,816	294,108	282	41,918	214	49,579	1,033	325,466	37	17,075	31	16,124	8	6,202	250	165,867	5,671	916,339
TOTAL	16,675	1,258,392	1,207	184,451	884	196,524	4,500	1,367,890	182	74,485	140	69,529	31	18,481	1,024	668,501	24,643	3,838,253

50	3,668	281,765	280	42,580	218	51,935	993	312,795	35	13,633	33	15,214	10,163	4	1,857	207	130,328	20,619	845,055
51	3,724	288,026	279	44,167	199	48,966	1,059	327,636	39	18,528	24	11,688	5,026	2	1,214	168	112,160	17,158	845,723
52	3,692	284,102	279	45,367	169	39,510	952	296,908	41	16,121	22	10,892	5,479	6	3,521	170	112,435	16,201	803,443
53	3,668	285,992	286	47,468	193	47,417	981	312,070	36	14,242	26	14,555	8,312	4	2,467	141	90,836	19,864	808,803
54	3,774	291,598	312	48,553	195	44,568	1,011	317,900	28	10,443	27	14,126	7,668	8	4,509	137	87,806	19,591	813,046
TOTAL	18,526	1,431,483	1,436	228,135	974	232,397	4,996	1,567,309	179	72,966		66,476	36,648	24	13,568	823	533,565	93,434	4,116,071

55	4,208	326,664	310	51,888	217	47,290	1,072	330,533	28	11,969	19	8,896	4	2,441	108	67,272	5,966	846,952
56	4,495	352,982	332	53,255	182	44,134	1,145	354,388	18	6,563	19	9,843	1	452	121	70,828	6,313	892,445
57	4,521	348,298	344	53,367	188	45,672	1,035	326,842	20	8,327	24	12,450	3	1,691	90	52,973	6,225	849,619
58	4,710	359,684	346	51,697	167	38,679	1,103	345,121	28	9,777	17	7,658	0	0	88	51,334	6,459	863,950
59	4,952	382,215	363	56,347	178	40,839	1,109	341,596	21	7,977	15	7,394	3	1,400	83	48,638	6,724	886,406
TOTAL	22,886	1,769,843	1,695	266,554	932	216,614	5,464	1,698,480	115	44,613	94	46,241	11	5,983	490	291,044	31,687	4,339,372

60	3,140	241,009	251	39,378	140	33,449	626	191,114	9	3,359	11	5,429	2	661	46	31,656	4,225	546,055
61	2,363	186,682	210	35,212	76	17,093	409	127,574	6	2,136	1	225	0	0	20	11,734	3,085	380,655
62	2,031	168,845	160	24,175	64	16,130	296	96,631	7	2,558	4	2,392	1	552	16	12,063	2,579	323,346
63	1,830	147,621	156	25,900	72	18,071	246	72,821	3	710	3	1,384	0	0	11	6,964	2,321	273,471
64	1,576	127,694	145	24,204	46	10,804	195	63,550	1	361	4	1,865	0	0	11	6,522	1,978	234,999
TOTAL	10,940	871,851	922	148,867	398	95,547	1,772	551,690	26	9,123	23	11,296	3	1,213	104	68,939	14,188	1,758,526

65	1,379	111,888	124	20,262	45	12,017	166	51,388	2	720	1	518	6	3,843	1,723	200,636
66	1,105	93,097	92	14,049	30	6,951	106	38,621	1	245	1	245	4	3,031	1,339	156,240
67	825	72,409	66	10,081	17	4,368	83	27,905	0	0	0	0	0	0	991	114,763
68	740	64,441	43	6,750	18	4,980	45	13,962	1	379	0	0	0	0	847	90,512
69	522	47,161	35	6,123	14	3,513	42	14,984	0	0	0	0	1	838	614	72,619
TOTAL	4,571	388,996	360	57,265	124	31,829	442	146,860	4	1,344	2	764	11	7,712	5,514	634,769

70	452	41,232	32	5,089	9	1,640	42	15,256	0	0	0	0	535	63,217
71	342	31,491	23	4,707	8	1,934	24	7,731	1	273	1	482	399	46,617
72	266	25,095	20	4,127	10	3,000	15	5,558	0	0	0	0	311	37,781
73	239	22,309	14	2,832	3	843	6	1,179	0	0	0	0	262	27,164
74	147	15,513	8	1,060	3	1,170	2	978	0	0	0	0	160	18,721
TOTAL	1,446	135,639	97	17,816	33	8,587	89	30,703	1	273	1	482	1,667	193,500

75	109	11,181	6	1,468	1	222	3	678	0	119	13,549
76	92	8,258	7	952	2	480	3	1,470	0	104	11,160
77	64	7,091	4	561	0	0	3	2,014	0	71	9,667
78	46	4,619	1	153	0	0	4	1,678	0	51	6,451
79	30	2,534	1	199	0	0	1	258	0	32	2,991
TOTAL	341	33,683	19	3,334	3	702	14	6,099		377	44,195

80	29	3,228	3	782	0	0	32	4,010
81	21	1,930	0	0	2	1,073	23	3,003
82	23	2,294	0	0	0	0	23	2,294
83	9	899	1	149	0	0	10	1,048
84	6	854	0	0	0	0	6	854
TOTAL	88	9,205	4	931	2	1,073	94	11,210

85	8	723	0	0	0	0	8	723
86	3	414	0	0	1	346	4	759
87	4	189	1	206	0	0	5	394
88	2	157	0	0	0	0	2	157
89	0	0	0	0	0	0	0	0
TOTAL	17	1,482	1	206	1	346	19	2,033

90	1	89	1	89
91	0	0	0	0
92	0	0	0	0
93	1	45	1	45
94	0	0	0	0
TOTAL	2	134	2	134

95		11	110	11	110
96	0	5	38	5	38
97	0	1	10	1	10
98	0	3	24	3	24
99	0	2	14	2	14
TOTAL		22	196	22	196
100+		0	0	0	0

GRAND TOTAL 127,347 9,094,722 8,837 1,294,888 5,393 1,172,503 27,807 7,984,327 894 336,607 67,031 288,295 148 78,158 4,680 2,743,536 242,137 22,993,413

&"Arial,Regular"&10Appendix 6

AD&D, Spouse, Child

	AD&D		SPOUSE LIFE			CHILD LIFE
AGE	COUNT	INS (000)	COUNT	INS (000)		COUNT	INS (000)
18	4	750	0	0		0	0
19	10	1,541	0	0		0	0
TOTAL	14	2,291	0	0		0	0
20	18	2,627	1	10		0	0
21	49	7,581	0	0		2	20
22	84	11,292	7	60		14	140
23	134	19,356	15	140		27	270
24	226	33,586	20	200		45	450
TOTAL	511	74,443	43	410		88	880
25	323	46,633	36	330		84	840
26	402	55,747	73	720		117	1,170
27	504	67,436	94	930		162	1,620
28	687	89,098	141	1,390		257	2,570
29	818	119,111	187	1,870		353	3,530
TOTAL	2,734	378,024	531	5,240		973	9,730
30	872	131,267	216	2,150		442	4,420
31	900	134,454	264	2,630		476	4,760
32	1,068	165,184	339	3,350		621	6,210
33	1,079	174,444	335	3,320		678	6,780
34	1,154	191,464	392	3,900		765	7,650
TOTAL	5,073	796,814	1,546	15,350		2,982	29,820
35	1,184	200,748	378	3,770		821	8,210
36	1,223	210,450	462	4,590		889	8,890
37	1,273	232,431	455	4,510		941	9,410
38	1,314	243,546	486	4,850		1,072	10,720
39	1,283	251,323	490	4,870		1,051	10,510
TOTAL	6,277	1,138,497	2,271	22,590		4,774	47,740
40	1,436	270,299	542	5,370		1,144	11,440
41	1,369	285,792	528	5,270		1,176	11,760
42	1,378	290,750	531	5,270		1,191	11,910
43	1,518	335,988	613	6,120		1,331	13,310
44	1,417	334,633	572	5,690		1,226	12,260
TOTAL	7,118	1,517,462	2,786	27,720		6,068	60,680
45	1,518	356,973	598	5,940		1,307	13,070
46	1,572	381,050	575	5,720		1,327	13,270
47	1,662	411,363	656	6,550		1,379	13,790
48	1,767	441,998	669	6,670		1,462	14,620
49	1,991	511,798	776	7,740		1,574	15,740
TOTAL	8,510	2,103,183	3,274	32,620		7,049	70,490
50	1,896	461,946	778	7,730		1,427	14,270
51	1,907	481,305	811	8,070		1,434	14,340
52	1,869	462,460	726	7,220		1,283	12,830
53	1,849	454,215	763	7,610		1,220	12,200
54	1,840	466,720	778	7,760		1,170	11,700
TOTAL	9,361	2,326,646	3,856	38,390		6,534	65,340
55	2,026	486,686	779	7,780		1,119	11,190
56	2,102	512,451	888	8,830		1,084	10,840
57	2,067	495,111	847	8,470		961	9,610
58	2,166	511,201	859	8,550		846	8,460
59	2,167	502,183	870	8,700		765	7,650
TOTAL	10,528	2,507,631	4,243	42,330		4,775	47,750
60	2,082	318,544	844	6,840		652	6,520
61	2,055	209,923	803	5,960		522	5,220
62	2,137	191,441	890	6,105		396	3,960
63	2,146	163,420	863	5,905		354	3,540
64	1,989	129,774	793	5,150		267	2,670
TOTAL	10,409	1,013,101	4,193	29,960		2,191	21,910
65	2,069	121,166	820	5,225		252	2,520
66	2,031	102,430	782	4,725		188	1,880
67	2,075	81,189	764	4,325		135	1,350
68	2,031	68,333	785	4,380		134	1,340
69	2,003	57,427	773	4,225		86	860
TOTAL	10,209	430,544	3,924	22,880		795	7,950
70	1,932	51,574	725	4,015		70	700
71	1,974	45,419	776	4,120		69	690
72	1,828	38,174	725	3,830		55	550
73	1,976	34,894	829	4,345		41	410
74	1,342	23,375	535	2,745		29	290
TOTAL	9,052	193,435	3,590	19,055		264	2,640
75	1,208	19,012	474	2,430		22	220
76	1,193	19,740	452	2,350		16	160
77	1,245	19,002	495	2,495		16	160
78	991	14,562	365	1,845		9	90
79	922	11,731	333	1,685		6	60
TOTAL	5,559	84,048	2,119	10,805		69	690
80	792	10,476	285	1,435		7	70
81	798	11,064	296	1,495		7	70
82	690	8,626	250	1,260		4	40
83	612	7,685	218	1,090		5	50
84	568	6,762	168	830		1	10
TOTAL	3,460	44,614	1,217	6,110		24	240
85	521	6,035	159	795		0	0
86	446	5,553	141	705		3	30
87	424	5,052	113	570		1	10
88	382	4,120	102	510		1	10
89	329	3,965	91	455		1	10
TOTAL	2,102	24,725	606	3,035		6	10
310	310	3,502	84	420		0	0
232	232	2,637	52	260	0	0	0
220	220	2,607	37	185	0	0	0
205	205	2,526	28	140	0	0	0
142	142	1,611	21	105	0	0	0
TOTAL	1,109	12,883	222	1,110		0	0
95	106	1,254	13	65		0	0
96	77	905	4	20		0	0
97	85	1,004	7	35		0	0
98	52	615	4	20		0	0
99	37	354	1	5		0	0
TOTAL	357	4,132	29	145		0	0
100+	55	590	1	5		0	0
GRAND TOTAL	92,434	12,652,313	34,451	277,755		36,592	365,870

&"Arial,Regular"&10Appendix 6

File details come from the government source that posted it. Updated Aug 1, 2024.