EXHIBIT L-2 WORKLOAD VOLUMES.xls

XLS spreadsheet 135 KB Posted Jun 29, 2012

Attached to: TRICARE Dual Eligible Fiscal Intermediary Contract (TDEFIC)
Solicitation number: HT9402-12-R-0005
Issued by: Defense Health Agency

About this file

From the source

TDEFIC Draft Section L Exhibit L-2 Workload Volumes

View the file

Other files

File	Type	Posted
TDEFIC Draft Section D Packaging and Markings.doc	DOC document	Jun 29, 2012
TDEFIC Draft CDRLs 6-15-12.pdf	PDF	Jun 29, 2012
TDEFIC Draft RFP Questions.xls	XLS spreadsheet	Jun 29, 2012
TDEFIC Draft Section H Contract Requirements.doc	DOC document	Jun 29, 2012
TDEFIC Draft Section C Work Statement.doc	DOC document	Jun 29, 2012
ATTACHMENT J-9 MSN Code Payment Determinations.xls	XLS spreadsheet	Jun 29, 2012
TDEFIC Draft Section K Representations and Certifications.doc	DOC document	Jun 29, 2012
ATTACHMENT J-3 TRICARE Reimbursement Manual Chapt 4.docx	DOCX document	Jun 29, 2012
ATTACHMENT J-7 CDRLs.doc	DOC document	Jun 29, 2012
ATTACHMENT J-8 Past Performance Quest.doc	DOC document	Jun 29, 2012
TDEFIC Draft Section E Inspection and Acceptance.doc	DOC document	Jun 29, 2012
TDEFIC Draft Section G Contract Administration.doc	DOC document	Jun 29, 2012
ATTACHMENT J-2 Definitions.doc	DOC document	Jun 29, 2012
TDEFIC Draft Section M Evaluation Criteria.doc	DOC document	Jun 29, 2012
EXHIBIT L-3 STAFFING CHART.xls	XLS spreadsheet	Jun 29, 2012
ATTACHMENT J-10 DMDC Eligibility File Layout.doc	DOC document	Jun 29, 2012
ATTACHMENT J-6 Guaranty Agreement.doc	DOC document	Jun 29, 2012
TDEFIC Draft Section J Exhibits and Attachments.doc	DOC document	Jun 29, 2012
TDEFIC Draft Section F Deliveries or Performance .doc	DOC document	Jun 29, 2012
TDEFIC Draft Section L Instructions to Offerors.doc	DOC document	Jun 29, 2012
TDEFIC Draft Section I Clauses.doc	DOC document	Jun 29, 2012
EXHIBIT L-1 OF ELIGIBLE BENES.xls	XLS spreadsheet	Jun 29, 2012

Show all 22

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.

CLAIMS

MONTH/YEAR	NET RECEIPTS	ADJUSTMENTS	TOTAL RECEIPTS	ELECTRONIC	%	PAPER	%
Jan-09	4,073,011	58,737	4,131,748	3,540,896	85.70%	590,852	14.30%
Feb-09	3,750,393	70,256	3,820,649	3,253,641	85.16%	567,008	14.84%
Mar-09	4,031,072	86,369	4,117,441	3,421,943	83.11%	695,498	16.89%
Apr-09	4,219,582	52,008	4,271,590	3,667,567	85.86%	604,023	14.14%
May-09	4,175,464	53,123	4,228,587	3,684,663	87.14%	543,924	12.86%
Jun-09	3,854,739	49,865	3,904,604	3,267,042	83.67%	637,562	16.33%
Jul-09	4,108,042	53,330	4,161,372	3,568,125	85.74%	593,247	14.26%
Aug-09	4,058,020	52,357	4,110,377	3,505,696	85.29%	604,681	14.71%
Sep-09	3,777,217	135,341	3,912,558	3,314,179	84.71%	598,379	15.29%
Oct-09	4,415,341	82,021	4,497,362	3,899,364	86.70%	597,998	13.30%
Nov-09	3,844,685	51,914	3,896,599	3,319,342	85.19%	577,257	14.81%
Dec-09	3,823,796	39,382	3,863,178	3,610,124	93.45%	253,054	6.55%
TOTALS	48,131,362	784,703	48,916,065	42052582		6,863,483
Jan-10	3,670,510	51,522	3,722,032	3,221,174	86.54%	500,858	13.46%
Feb-10	3,642,627	53,227	3,695,854	3,097,665	83.81%	598,189	16.19%
Mar-10	4,237,951	52,633	4,290,584	3,621,661	84.41%	668,923	15.59%
Apr-10	3,976,760	48,878	4,025,638	3,483,405	86.53%	542,233	13.47%
May-10	4,340,084	51,490	4,391,574	3,819,861	86.98%	571,713	13.02%
Jun-10	3,448,211	51,654	3,499,865	2,924,508	83.56%	575,357	16.44%
Jul-10	4,938,878	78,678	5,017,556	4,525,651	90.20%	491,905	9.80%
Aug-10	3,854,518	69,336	3,923,854	3,353,553	85.47%	570,301	14.53%
Sep-10	4,001,622	80,497	4,082,119	3,608,095	88.39%	474,024	11.61%
Oct-10	4,315,369	72,785	4,388,154	3,903,351	88.95%	484,803	11.05%
Nov-10	3,949,610	84,522	4,034,132	3,477,729	86.21%	556,403	13.79%
Dec-10	4,301,302	88,965	4,390,267	3,905,582	88.96%	484,685	11.04%
TOTALS	48,677,442	784,187	49,461,629	42,942,235		6,519,394
Jan-11	3,795,135	84,818	3,879,953	3,390,159	87.38%	489,794	12.62%
Feb-11	3,578,911	111,477	3,690,388	3,213,503	87.08%	476,885	12.92%
Mar-11	4,445,607	308,176	4,753,783	4,276,171	89.95%	477,612	10.05%
Apr-11	4,091,230	540,755	4,631,985	4,245,247	91.65%	386,738	8.35%
May-11	4,775,326	805,928	5,581,254	5,223,906	93.60%	357,348	6.40%
Jun-11	4,138,811	968,545	5,107,356	4,754,127	93.08%	353,229	6.92%
Jul-11	4,192,433	1,145,422	5,337,855	5,067,530	94.94%	270,325	5.06%
Aug-11	4,318,473	1,070,682	5,389,155	5,177,028	96.06%	212,127	3.94%
Sep-11	4,236,900	715,504	4,952,404	4,640,873	93.71%	311,531	6.29%
Oct-11	4,117,065	522,071	4,639,136	4,160,576	89.68%	478,560	10.32%
Nov-11	4,068,977	503,829	4,572,806	4,145,711	90.66%	427,095	9.34%
Dec-11	3,774,770	588,810	4,363,580	4,309,953	98.77%	53,627	1.23%
TOTALS	49,533,638	7,366,017	56,899,655	52,604,784		4,294,871
*NOTE: The fluctuations or increased adjustment receipts beginning Feb. 2011, are due to Medicare adjustments.
Jan-12	3,236,291	224,820	3,461,111	3,080,875	89.01%	380,236	10.99%
Feb-12	3,945,686	116,325	4,062,011	3,535,421	87.04%	526,590	12.96%
Mar-12	4,098,620	116,349	4,214,969	3,848,836	91.31%	366,133	8.69%
Apr-12	4,426,259	94,138	4,520,397	3,887,726	86.00%	632,671	14.00%
May-12			0		0.00%	0	0.00%
Jun-12			0		0.00%	0	0.00%
Jul-12			0		0.00%	0	0.00%
Aug-12			0		0.00%	0	0.00%
Sep-12			0		0.00%	0	0.00%
Oct-12			0		0.00%	0	0.00%
Nov-12			0		0.00%	0	0.00%
Dec-12			0		0.00%	0	0.00%
TOTALS		551,632	16,258,488	14,352,858		1,905,630
	15,706,856

&C&"-,Bold"SECTION L, EXHIBIT L-2

CLAIMS

&C&"-,Bold"HT9402-12-R-0005

ROUTINE CORRESPONDENCE

MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-09	40,416	39,754
Feb-09	40,218	36,300
Mar-09	45,602	48,665
Apr-09	42,133	38,403
May-09	37,448	41,071
Jun-09	44,697	39,110
Jul-09	38,886	54,337
Aug-09	40,647	26,734
Sep-09	38,497	41,702
Oct-09	37,111	37,470
Nov-09	36,993	38,110
Dec-09	35,198	38,843
TOTALS	477,846	480,499
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-10	34,678	35,607
Feb-10	36,689	33,558
Mar-10	42,088	41,828
Apr-10	39,581	38,997
May-10	38,416	37,606
Jun-10	42,537	39,635
Jul-10	38,385	41,000
Aug-10	41,267	42,860
Sep-10	37,095	33,882
Oct-10	37,140	38,345
Nov-10	40,063	41,418
Dec-10	34,212	38,209
TOTALS	462,151	462,945
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-11	37,945	31,178
Feb-11	34,202	35,341
Mar-11	39,443	41,382
Apr-11	38,045	39,109
May-11	42,641	40,114
Jun-11	41,313	42,694
Jul-11	40,249	37,483
Aug-11	47,825	49,692
Sep-11	37,467	41,479
Oct-11	37,011	35,913
Nov-11	39,377	39,204
Dec-11	33,369	40,149
TOTALS	468,887	473,738
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-12	36,322	35,774
Feb-12	36,645	37,151
Mar-12	36,161	38,845
Apr-12	35,758	31,479
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Nov-12
Dec-12
TOTALS	144,886	143,249

&C&"-,Bold"SECTION L, EXHIBIT L-2

ROUTINE CORRESPONDENCE

&C&"-,Bold"HT9402-12-R-0005

PRIORITY CORRESPONDENCE

MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-09	66	118
Feb-09	144	121
Mar-09	152	131
Apr-09	190	158
May-09	29	106
Jun-09	143	94
Jul-09	70	124
Aug-09	91	92
Sep-09	118	114
Oct-09	194	108
Nov-09	94	110
Dec-09	96	94
TOTALS	1,387	1,370
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-10	116	108
Feb-10	120	104
Mar-10	89	123
Apr-10	122	110
May-10	99	101
Jun-10	123	124
Jul-10	114	119
Aug-10	141	130
Sep-10	145	149
Oct-10	84	85
Nov-10	101	99
Dec-10	78	90
TOTALS	1,332	1,342
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-11	117	117
Feb-11	93	93
Mar-11	117	117
Apr-11	198	94
May-11	19	121
Jun-11	100	110
Jul-11	42	56
Aug-11	96	94
Sep-11	125	74
Oct-11	58	82
Nov-11	69	78
Dec-11	93	111
TOTALS	1,127	1,147
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-12	105	91
Feb-12	114	111
Mar-12	111	116
Apr-12	161	101
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Nov-12
Dec-12
TOTALS	491	419

&C&"-,Bold"SECTION L, EXHIBIT L-2

PRIORITY CORRESPONDENCE

&C&"-,Bold"HT9402-12-R-0005

EXPEDITED APPEALS

MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-09	0	0
Feb-09	0	0
Mar-09	0	0
Apr-09	0	0
May-09	0	0
Jun-09	0	0
Jul-09	0	0
Aug-09	0	0
Sep-09	0	0
Oct-09	0	0
Nov-09	0	0
Dec-09	0	0
TOTALS	0	0
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-10	0	0
Feb-10	0	0
Mar-10	0	0
Apr-10	0	0
May-10	0	0
Jun-10	0	0
Jul-10	0	0
Aug-10	0	0
Sep-10	0	0
Oct-10	0	0
Nov-10	0	0
Dec-10	0	0
TOTALS	0	0
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-11	0	0
Feb-11	0	0
Mar-11	0	0
Apr-11	0	0
May-11	0	0
Jun-11	0	0
Jul-11	0	0
Aug-11	0	0
Sep-11	0	0
Oct-11	0	0
Nov-11	0	0
Dec-11	0	0
TOTALS	0	0
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-12	0	0
Feb-12	0	0
Mar-12	0	0
Apr-12	0	0
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Nov-12
Dec-12
TOTALS	0	0

&C&"-,Bold"SECTION L, EXHIBIT L-2

EXPEDITED APPEALS

&C&"-,Bold"HT9402-12-R-0005

NON EXPEDITED APPEALS

MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-09	35	24
Feb-09	34	34
Mar-09	23	12
Apr-09	49	35
May-09	35	39
Jun-09	39	48
Jul-09	57	36
Aug-09	30	46
Sep-09	28	31
Oct-09	26	36
Nov-09	21	21
Dec-09	21	17
TOTALS	398	379
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-10	9	17
Feb-10	11	7
Mar-10	23	12
Apr-10	26	26
May-10	30	22
Jun-10	27	34
Jul-10	25	27
Aug-10	19	25
Sep-10	29	24
Oct-10	34	23
Nov-10	23	37
Dec-10	9	16
TOTALS	265	270
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-11	19	19
Feb-11	10	11
Mar-11	20	12
Apr-11	9	17
May-11	14	15
Jun-11	7	7
Jul-11	2	5
Aug-11	10	10
Sep-11	1	3
Oct-11	5	4
Nov-11	5	5
Dec-11	2	5
TOTALS	104	113
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-12	2	4
Feb-12	6	6
Mar-12	7	5
Apr-12	6	5
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Nov-12
Dec-12
TOTALS	21	20

&C&"-,Bold"SECTION L, EXHIBIT L-2

NON-EXPEDITED APPEALS

&C&"-,Bold"HT9402-12-R-0005

FACTUAL APPEALS

MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-09	115	112
Feb-09	70	97
Mar-09	118	98
Apr-09	122	111
May-09	112	86
Jun-09	92	108
Jul-09	134	121
Aug-09	103	116
Sep-09	113	118
Oct-09	111	118
Nov-09	98	108
Dec-09	53	92
TOTALS	1,241	1,285
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-10	138	155
Feb-10	111	116
Mar-10	166	142
Apr-10	167	171
May-10	130	120
Jun-10	168	168
Jul-10	115	127
Aug-10	144	141
Sep-10	118	133
Oct-10	112	117
Nov-10	170	124
Dec-10	91	119
TOTALS	1,630	1,633
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-11	123	124
Feb-11	129	140
Mar-11	141	117
Apr-11	103	125
May-11	117	121
Jun-11	128	118
Jul-11	56	114
Aug-11	130	118
Sep-11	130	142
Oct-11	122	126
Nov-11	135	127
Dec-11	119	150
TOTALS	1,433	1,522
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-12	130	156
Feb-12	128	141
Mar-12	228	160
Apr-12	227	194
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Nov-12
Dec-12
TOTALS	713	651

&C&"-,Bold"SECTION L, EXHIBIT L-2

FACTUAL APPEALS

&C&"-,Bold"HT9402-12-R-0005

GRIEVANCES

MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-09	0	0
Feb-09	0	0
Mar-09	0	0
Apr-09	0	0
May-09	0	0
Jun-09	0	0
Jul-09	0	0
Aug-09	0	0
Sep-09	0	0
Oct-09	0	0
Nov-09	0	0
Dec-09	0	0
TOTALS	0	0
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-10	0	0
Feb-10	0	0
Mar-10	0	0
Apr-10	0	0
May-10	0	0
Jun-10	0	0
Jul-10	0	0
Aug-10	0	0
Sep-10	0	0
Oct-10	0	0
Nov-10	0	0
Dec-10	0	0
TOTALS	0	0
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-11	0	0
Feb-11	0	0
Mar-11	0	0
Apr-11	0	0
May-11	0	0
Jun-11	0	0
Jul-11	0	0
Aug-11	0	0
Sep-11	0	0
Oct-11	0	0
Nov-11	0	0
Dec-11	0	0
TOTALS	0	0
MONTH	NET RECEIPTS	NUMBER PROCESSED
Jan-12	0	0
Feb-12	0	0
Mar-12	0	0
Apr-12	0	0
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Nov-12
Dec-12
TOTALS	0	0

&C&"-,Bold"SECTION L, EXHIBIT L-2

GRIEVANCES

&C&"-,Bold"HT9402-12-R-0005

TELEPHONE

MONTH	CALLS ATTEMPTED	CALLS RECEIVED
Jan-09	293,139	271,924
Feb-09	248,477	242,748
Mar-09	276,516	271,987
Apr-09	261,433	257,220
May-09	237,248	232,679
Jun-09	266,843	263,494
Jul-09	258,056	253,909
Aug-09	257,341	257,318
Sep-09	250,755	249,896
Oct-09	255,383	255,180
Nov-09	232,832	231,060
Dec-09	233,621	232,438
TOTALS	3,071,644	3,019,853
MONTH	CALLS ATTEMPTED	CALLS RECEIVED
Jan-10	268,234	264,355
Feb-10	232,819	232,299
Mar-10	281,371	279,348
Apr-10	262,388	257,485
May-10	238,595	235,234
Jun-10	257,980	252,537
Jul-10	233,293	230,857
Aug-10	256,364	250,176
Sep-10	242,673	239,290
Oct-10	235,989	231,226
Nov-10	230,063	225,864
Dec-10	223,384	214,957
TOTALS	2,963,153	2,913,628
MONTH	CALLS ATTEMPTED	CALLS RECEIVED
Jan-11	252,867	248,465
Feb-11	231,139	227,488
Mar-11	288,758	272,733
Apr-11	231,581	227,468
May-11	237,517	233,718
Jun-11	251,482	245,562
Jul-11	236,016	225,411
Aug-11	276,870	252,836
Sep-11	261,337	244,039
Oct-11	257,289	253,563
Nov-11	231,479	228,431
Dec-11	213,255	210,126
TOTALS	2,969,590	2,869,840
MONTH	CALLS ATTEMPTED	CALLS RECEIVED
Jan-12	374,870	256,072
Feb-12	234,338	230,973
Mar-12	255,301	244,019
Apr-12	237,637	234,487
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Nov-12
Dec-12
TOTALS	1,102,146	965,551

&C&"-,Bold"SECTION L, EXHIBIT L-2

TOLL-FREE TELEPHONES

&C&"-,Bold"HT9402-12-R-0005

AUTHS

MONTH	SNF	OTHER
Jan-11	443	240
Feb-11	381	127
Mar-11	418	118
Apr-11	387	175
May-11	440	164
Jun-11	389	90
Jul-11	382	99
Aug-11	462	129
Sep-11	498	259
Oct-11	418	133
Nov-11	409	193
Dec-11	397	192
TOTALS	5,024	1,919
MONTH	SNF	OTHER
Jan-12	523	218
Feb-12
Mar-12
Apr-12
May-12
Jun-12
Jul-12
Aug-12
Sep-12
Oct-12
Nov-12
Dec-12
TOTALS	523	218

&C&"-,Bold"SECTION L, EXHIBIT L-2

AUTHORIZATIONS

&C&"-,Bold"HT9402-12-R-0005

File details come from the government source that posted it. Updated Nov 14, 2017.