Attachment K Caseload Projections with Retros.xlsx

XLSX spreadsheet 28 KB Posted May 30, 2019

Attached to: Actuarial Services
Solicitation number: 40DHHS-S697
Issued by: Churchill County, Nevada

About this file

Written by GovTribe AI · Apr 2, 2024

This document appears to be an Excel attachment containing caseload projections with retrospective enrollments for the Medicaid program in the state of Nevada. The file includes actual caseload data through October 2020 across various eligibility categories such as Parents and Children, Newly Eligible Adults, Aged Blind and Disabled, and Nevada Check Up. The data is provided for managed care and fee-for-service programs. This information is likely being used to support the State of Nevada's Actuarial Services contract, which involves providing actuarial analysis and consulting for the Medicaid program.

The document provides detailed historical and projected enrollment data that would be valuable for the selected actuarial services provider to analyze and model future program costs and utilization. Key details such as the contract term, award date, and pricing structure are not included in this particular file, as it appears to focus solely on the caseload projections. However, this information would be important for fully understanding the requirements of the Actuarial Services contract opportunity.

View the file

Other files

File	Type	Posted
ATTACHMENT C Standard Form Contract-Health~1.docx	DOCX document	May 30, 2019
ATTACHMENT E Reference Questionnaire 4-5-19~3.doc	DOC document	May 30, 2019
Amendment Question 11.xlsx	XLSX spreadsheet	May 30, 2019
Amendment Question 5.xlsx	XLSX spreadsheet	May 30, 2019
Question 37 History of Rate re-casts.docx	DOCX document	May 30, 2019
ATTACHMENT A Confidentiality and Certification of Idemnification 4-5-19.docx	DOCX document	May 30, 2019
ATTACHMENT I Federal Laws and Authorities 4-5-19.docx	DOCX document	May 30, 2019
Attachment D Insurance Schedule.docx	DOCX document	May 30, 2019
Attachment G Cost Schedule~1.xlsx	XLSX spreadsheet	May 30, 2019
Attachment J Business Associate Addendum.docx	DOCX document	May 30, 2019
Attachment L Nevada Medicaid Caseload Demographics v3 181212 - HIPAA.XLSX	XLSX spreadsheet	May 30, 2019
Quote Instructions.pdf	PDF	May 30, 2019
RFP 40DHHS-S697 Actuarial Services Final.docx	DOCX document	May 30, 2019
RFP 40DHHS-S697 LOI.pdf	PDF	May 30, 2019
ATTACHMENT B Vendor Certification 4-5-19.docx	DOCX document	May 30, 2019
ATTACHMENT F Proposed Staff Resume 4-5-19.doc	DOC document	May 30, 2019
ATTACHMENT H Certification Regarding Lobbying 4-5-19.docx	DOCX document	May 30, 2019
RFP S697 Actuarial Q and A.xls	XLS spreadsheet	May 30, 2019

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.

Sheet1

Actual caseloads through October 2018 (include estimated retroactive enrollments)
	Total Medicaid

Ellen Crecelius: Ellen Crecelius:

Does not include Nevada Check Up	Chip to Medicaid			Parents and Children			Newly Eligible Adults			Aged Blind and Disabled			Waiver	County Match Program	Child
Welfare		Nevada Check Up
			Total	MCO	FFS	Total	MCO	FFS	Total	MCO	FFS	Total	14 inst	14 Non Inst
	Jul-13	314,050	0	0	0	239,577	180,321	59,256	0	0	0	60,469	2,102	58,367	4,006	1,471	8,527	21,287
	Aug-13	317,161	0	0	0	242,223	180,538	61,685	0	0	0	60,769	2,092	58,677	4,007	1,447	8,715	21,415
	Sep-13	318,697	0	0	0	243,369	178,738	64,631	0	0	0	61,125	2,070	59,055	4,023	1,436	8,744	21,275
	Oct-13	322,323	448	125	323	245,953	180,703	65,250	0	0	0	61,564	2,098	59,466	4,086	1,453	8,819	21,392
	Nov-13	324,860	834	462	372	247,351	193,284	54,067	1	0	1	62,175	2,118	60,057	4,079	1,457	8,963	22,430
	Dec-13	329,182	1,366	861	505	251,553	196,465	55,088	1	0	1	61,721	2,081	59,640	4,104	1,463	8,974	22,116
	Jan-14	367,058	2,112	1,348	764	257,429	197,643	59,786	30,425	10,470	19,955	62,397	2,093	60,304	4,104	1,492	9,099	21,561
	Feb-14	392,399	2,783	1,818	965	264,560	203,578	60,982	47,093	22,643	24,450	63,224	2,092	61,132	4,146	1,479	9,114	21,152
	Mar-14	426,681	3,607	2,255	1,352	275,840	209,311	66,529	68,192	35,199	32,993	64,155	2,132	62,023	4,186	1,488	9,213	21,072
	Apr-14	460,095	4,155	2,671	1,484	287,268	217,005	70,263	89,041	49,365	39,676	64,706	2,115	62,591	4,212	1,505	9,208	21,398
	May-14	489,736	5,013	3,428	1,585	296,263	227,551	68,712	108,481	69,812	38,669	65,053	2,106	62,947	4,206	1,498	9,222	22,495
	Jun-14	529,724	6,042	3,996	2,046	308,499	234,574	73,925	134,808	84,427	50,381	65,392	2,107	63,285	4,241	1,493	9,249	23,655
	Jul-14	573,174	6,940	4,630	2,310	328,441	242,067	86,374	156,399	102,004	54,395	66,133	2,128	64,005	4,305	1,518	9,438	24,062
	Aug-14	588,452	7,406	5,230	2,176	333,756	250,214	83,542	165,001	116,710	48,291	66,973	2,032	64,941	4,321	1,518	9,477	26,057
	Sep-14	599,150	7,781	5,518	2,263	337,020	253,941	83,079	171,281	122,941	48,340	67,624	2,052	65,572	4,351	1,548	9,545	24,276
	Oct-14	607,749	8,279	5,825	2,454	337,970	254,370	83,600	177,537	127,480	50,057	68,421	2,098	66,323	4,378	1,562	9,602	24,717
	Nov-14	563,585	7,972	6,199	1,773	305,207	245,945	59,262	167,757	133,092	34,665	67,347	1,971	65,376	4,357	1,406	9,539	24,597
	Dec-14	562,436	8,434	6,556	1,878	299,024	246,175	52,849	172,679	135,852	36,827	66,876	1,936	64,940	4,361	1,402	9,660	23,603
	Jan-15	558,255	8,785	6,680	2,105	292,518	234,113	58,405	174,236	134,994	39,242	67,349	1,930	65,419	4,343	1,368	9,656	20,767
	Feb-15	561,694	8,983	6,734	2,249	290,376	226,342	64,034	179,103	136,242	42,861	67,857	1,902	65,955	4,356	1,360	9,659	20,600
	Mar-15	569,784	9,460	7,040	2,420	291,027	222,809	68,218	185,170	140,674	44,496	68,402	1,975	66,427	4,418	1,485	9,822	19,985
	Apr-15	573,328	9,606	7,509	2,097	290,752	229,617	61,135	188,233	144,971	43,262	68,836	1,980	66,856	4,487	1,465	9,949	20,208
	May-15	577,636	9,905	7,805	2,100	292,817	233,147	59,670	189,586	145,036	44,550	69,276	1,961	67,315	4,498	1,466	10,088	21,298
	Jun-15	582,654	10,155	8,011	2,144	297,011	235,662	61,349	189,341	146,559	42,782	69,943	1,982	67,961	4,554	1,503	10,147	21,089
	Jul-15	581,690	10,169	8,237	1,932	298,084	238,935	59,149	186,596	149,111	37,485	70,442	1,844	68,598	4,502	1,585	10,312	20,995
	Aug-15	585,506	10,392	8,565	1,827	300,087	242,592	57,495	188,152	152,262	35,890	70,335	1,877	68,458	4,530	1,565	10,445	21,373
	Sep-15	628,347	12,255	8,920	3,335	314,958	247,459	67,499	208,181	156,076	52,105	75,789	2,037	73,752	4,558	1,520	11,086	21,154
	Oct-15	598,528	11,057	9,098	1,959	305,667	247,643	58,024	194,174	158,049	36,125	70,988	1,957	69,031	4,573	1,556	10,513	22,419
	Nov-15	601,412	11,180	9,098	2,082	305,527	247,018	58,509	196,837	158,819	38,018	71,174	1,943	69,231	4,568	1,549	10,577	22,742
	Dec-15	607,772	11,325	9,307	2,018	306,838	248,293	58,545	201,161	161,849	39,312	71,639	1,937	69,702	4,585	1,558	10,666	22,922
	Jan-16	613,213	11,609	9,508	2,101	307,584	248,387	59,197	204,323	164,263	40,060	72,052	1,965	70,087	4,570	1,574	11,501	22,211
	Feb-16	619,459	11,830	9,527	2,303	309,329	248,298	61,031	208,171	166,004	42,167	72,533	1,963	70,570	4,568	1,570	11,458	23,276
	Mar-16	621,897	11,981	9,651	2,330	310,633	249,362	61,271	208,823	166,441	42,382	73,277	1,997	71,280	4,616	1,596	10,971	22,471
	Apr-16	619,790	11,842	9,704	2,138	309,866	250,468	59,398	207,328	166,822	40,506	73,731	1,994	71,737	4,592	1,583	10,848	23,837
	May-16	620,729	11,844	9,776	2,068	310,511	250,014	60,497	207,109	165,352	41,757	74,193	1,974	72,219	4,581	1,558	10,933	24,431
	Jun-16	621,517	11,970	9,778	2,192	311,614	253,123	58,491	206,452	166,231	40,221	74,363	1,943	72,420	4,611	1,556	10,951	23,728
	Jul-16	620,588	11,842	9,853	1,989	311,164	253,349	57,815	205,537	165,885	39,652	74,946	1,927	73,019	4,668	1,497	10,934	24,315
	Aug-16	626,343	12,051	10,140	1,911	314,731	255,687	59,044	207,114	168,266	38,848	75,239	2,002	73,237	4,706	1,505	10,997	24,801
	Sep-16	628,483	12,255	10,343	1,912	314,958	256,351	58,607	208,181	169,373	38,808	75,789	2,037	73,752	4,694	1,520	11,086	24,741
	Oct-16	632,011	12,574	10,518	2,056	315,804	256,422	59,382	209,938	170,471	39,467	76,338	2,081	74,257	4,705	1,538	11,114	25,558
	Nov-16	632,276	12,762	10,682	2,080	314,993	257,783	57,210	210,480	171,552	38,928	76,711	2,066	74,645	4,717	1,537	11,076	26,036
	Dec-16	635,927	12,920	10,919	2,001	315,543	257,579	57,964	213,103	172,528	40,575	76,941	2,073	74,868	4,723	1,551	11,146	25,492
	Jan-17	640,397	13,210	10,888	2,322	316,828	257,512	59,316	215,490	172,358	43,132	77,460	2,119	75,341	4,766	1,559	11,084	25,896
	Feb-17	641,533	13,171	11,003	2,168	317,322	257,804	59,518	215,874	174,164	41,710	77,715	2,094	75,621	4,765	1,540	11,146	26,551
	Mar-17	644,203	13,259	11,108	2,151	318,601	259,099	59,502	216,636	175,639	40,997	78,126	2,098	76,028	4,845	1,552	11,184	25,795
	Apr-17	642,839	13,235	11,000	2,235	317,995	258,956	59,039	216,069	175,495	40,574	78,034	2,120	75,914	4,874	1,546	11,086	26,050
	May-17	643,771	13,117	11,033	2,084	318,276	261,533	56,743	216,266	176,373	39,893	78,520	2,119	76,401	4,923	1,554	11,115	26,989
	Jun-17	646,969	13,088	11,084	2,171	319,066	261,310	55,750	216,171	176,119	40,701	80,990	2,107	76,610	4,935	1,523	11,196	26,165
	Jul-17	645,387	13,183	10,984	2,199	319,583	260,114	59,469	216,384	175,004	41,380	78,599	2,335	76,264	4,984	1,507	11,147	26,369
	Aug-17	648,382	13,173	11,187	1,986	321,577	262,498	59,079	217,077	176,921	40,156	79,020	2,315	76,705	4,994	1,530	11,011	26,604
	Sep-17	646,862	13,250	11,153	2,097	321,077	262,595	58,482	216,761	176,858	39,903	78,112	2,332	75,780	5,036	1,523	11,103	26,935
	Oct-17	649,401	13,273	11,200	2,073	321,778	260,930	60,848	217,148	176,515	40,633	79,562	2,332	77,230	5,060	1,502	11,078	27,515
	Nov-17	648,515	13,360	11,310	2,050	320,258	262,406	57,852	217,376	176,442	40,934	79,660	2,320	77,340	5,055	1,515	11,291	27,372
	Dec-17	650,155	13,566	11,331	2,235	320,057	262,607	57,450	218,767	177,263	41,504	79,939	2,369	77,570	5,064	1,511	11,251	26,842
	Jan-18	654,289	13,675	11,397	2,278	321,631	264,459	57,172	220,665	179,385	41,280	80,295	2,393	77,902	5,091	1,502	11,430	27,314
	Feb-18	654,085	13,534	11,300	2,234	322,021	264,291	57,730	219,982	178,985	40,997	80,557	2,370	78,187	5,095	1,498	11,398	27,825
	Mar-18	654,313	13,495	11,337	2,158	322,289	264,814	57,475	219,671	179,117	40,554	80,797	2,392	78,405	5,107	1,494	11,460	27,893
	Apr-18	656,037	13,461	11,195	2,266	323,463	264,857	58,606	220,289	178,554	41,735	80,893	2,370	78,523	5,138	1,527	11,266	27,713
	May-18	656,086	13,297	11,081	2,216	323,344	266,882	56,462	220,527	179,883	40,644	80,882	2,363	78,519	5,180	1,516	11,340	27,813
	Jun-18	655,621	13,225	11,054	2,171	323,280	267,530	55,750	219,899	179,198	40,701	80,990	2,375	78,615	5,192	1,521	11,514	27,406
	Jul-18	656,940	13,129	10,938	2,191	324,369	266,153	58,216	220,130	177,917	42,213	81,079	2,334	78,745	5,210	1,500	11,523	28,066
	Aug-18	658,076	13,142	11,220	1,922	325,672	269,015	56,657	219,665	179,828	39,837	81,178	2,343	78,835	5,296	1,527	11,596	28,608
	Sep-18	656,859	13,415	11,395	2,020	324,350	267,039	57,311	219,264	178,996	40,268	81,445	2,353	79,092	5,295	1,504	11,586	28,027
	Oct-18	656,373	13,562	11,395	2,167	323,043	267,039	56,004	219,599	178,585	41,014	81,635	2,382	79,253	5,355	1,540	11,639	28,144
	Nov-18	656,343	13,539	11,376	2,163	323,040	267,037	56,003	219,565	178,557	41,008	81,571	2,384	79,187	5,337	1,536	11,755	28,416
	Dec-18	656,383	13,559	11,392	2,167	323,549	267,455	56,094	218,818	177,950	40,868	81,712	2,388	79,324	5,358	1,539	11,848	28,607
	Jan-19	655,439	13,498	11,341	2,157	323,130	267,110	56,020	218,189	177,438	40,751	81,791	2,377	79,414	5,386	1,524	11,921	28,699
	Feb-19	655,005	13,400	11,259	2,141	323,602	267,499	56,103	217,134	176,579	40,555	82,023	2,358	79,665	5,407	1,513	11,926	28,871
	Mar-19	656,214	13,299	11,174	2,125	324,479	268,222	56,257	217,185	176,621	40,564	82,302	2,364	79,938	5,432	1,518	11,999	28,940
	Apr-19	657,322	12,886	10,827	2,059	325,273	268,877	56,396	217,876	177,183	40,693	82,403	2,373	80,030	5,462	1,516	11,906	28,961
	May-19	659,403	12,938	10,871	2,067	326,258	269,690	56,568	218,651	177,814	40,837	82,623	2,377	80,246	5,481	1,519	11,933	29,030
	Jun-19	659,953	12,989	10,914	2,075	326,618	269,987	56,631	218,585	177,760	40,825	82,732	2,370	80,362	5,498	1,519	12,012	29,219
	Jul-19	661,626	13,024	10,943	2,081	327,652	270,841	56,811	218,935	178,045	40,890	82,985	2,372	80,613	5,522	1,527	11,981	29,390
	Aug-19	664,390	13,003	10,926	2,077	328,790	271,781	57,009	220,263	179,125	41,138	83,225	2,388	80,837	5,569	1,538	12,002	29,450
	Sep-19	663,926	12,998	10,922	2,076	328,458	271,506	56,952	219,883	178,816	41,067	83,407	2,393	81,014	5,599	1,538	12,043	29,635
	Oct-19	666,377	13,132	11,034	2,098	329,612	272,460	57,152	220,614	179,411	41,203	83,746	2,420	81,326	5,639	1,547	12,087	29,676
	Nov-19	666,474	13,066	10,979	2,087	329,777	272,596	57,181	220,542	179,352	41,190	83,689	2,416	81,273	5,658	1,543	12,199	29,764
	Dec-19	667,265	13,078	10,989	2,089	330,492	273,187	57,305	220,375	179,216	41,159	83,800	2,419	81,381	5,679	1,547	12,294	29,835
	Jan-20	667,189	13,035	10,953	2,082	330,311	273,038	57,273	220,371	179,213	41,158	83,867	2,409	81,458	5,705	1,533	12,367	29,854
	Feb-20	667,408	13,180	11,075	2,105	330,640	273,310	57,330	219,899	178,829	41,070	84,078	2,388	81,690	5,723	1,520	12,368	29,950
	Mar-20	668,854	13,261	11,143	2,118	331,377	273,919	57,458	220,188	179,064	41,124	84,318	2,394	81,924	5,746	1,524	12,440	29,965
	Apr-20	669,900	13,021	10,941	2,080	331,994	274,429	57,565	220,897	179,641	41,256	84,351	2,406	81,945	5,773	1,523	12,341	29,928
	May-20	671,547	13,089	10,998	2,091	332,762	275,064	57,698	221,525	180,151	41,374	84,490	2,412	82,078	5,790	1,525	12,366	29,917
	Jun-20	671,768	13,147	11,047	2,100	332,919	275,193	57,726	221,402	180,051	41,351	84,524	2,410	82,114	5,805	1,524	12,447	30,012
	Jul-20	673,215	13,229	11,116	2,113	333,790	275,913	57,877	221,706	180,299	41,407	84,717	2,416	82,301	5,828	1,530	12,415	30,070
	Aug-20	675,594	13,267	11,148	2,119	334,783	276,734	58,049	222,790	181,180	41,610	84,904	2,430	82,474	5,874	1,539	12,437	30,022
	Sep-20	674,989	13,318	11,191	2,127	334,312	276,345	57,967	222,402	180,865	41,537	85,036	2,431	82,605	5,903	1,538	12,480	30,139
	Oct-20	677,258	13,501	11,344	2,157	335,261	277,129	58,132	223,147	181,470	41,677	85,339	2,460	82,879	5,940	1,547	12,523	30,114
	Nov-20	677,126	13,513	11,354	2,159	335,200	277,079	58,121	223,061	181,401	41,660	85,216	2,458	82,758	5,957	1,543	12,636	30,145
	Dec-20	677,781	13,571	11,403	2,168	335,735	277,521	58,214	222,954	181,314	41,640	85,267	2,461	82,806	5,976	1,546	12,732	30,189
	Jan-21	677,604	13,498	11,342	2,156	335,382	277,229	58,153	223,150	181,473	41,677	85,238	2,445	82,793	6,001	1,532	12,803	30,182
	Feb-21	677,689	13,590	11,419	2,171	335,609	277,417	58,192	222,771	181,165	41,606	85,375	2,418	82,957	6,018	1,521	12,805	30,259
	Mar-21	679,029	13,627	11,450	2,177	336,261	277,956	58,305	223,130	181,457	41,673	85,567	2,424	83,143	6,040	1,525	12,879	30,242
	Apr-21	679,876	13,371	11,235	2,136	336,761	278,369	58,392	223,841	182,035	41,806	85,538	2,434	83,104	6,064	1,527	12,774	30,187
	May-21	681,360	13,421	11,277	2,144	337,402	278,899	58,503	224,501	182,572	41,929	85,630	2,444	83,186	6,079	1,528	12,799	30,139
	Jun-21	681,438	13,461	11,311	2,150	337,469	278,954	58,515	224,414	182,501	41,913	85,597	2,435	83,162	6,092	1,525	12,880	30,188

File details come from the government source that posted it. Updated Apr 2, 2024.