60RRBH21R0011 Attachment J.32 Cash Collections Worksheet.xlsx

XLSX spreadsheet 51 KB Posted Jul 22, 2021

Attached to: Solicitation 60RRBH21R0011 - RRB Specialty MAC
Solicitation number: 60RRBH21R0011
Issued by: Railroad Retirement Board

View the file

Other files

File	Type	Posted
60RRBH21R0011 Attachment J.1.C Performance Requirements Summary -Revised.docx	DOCX document	Sep 2, 2021
60RRBH21R0011 Amendment 0002.pdf	PDF	Sep 2, 2021
60RRBH21R0011 Attachment J.13 CLIN 0004 Cost Proposal Template Option Year Two- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.16 CLIN 0007 Cost Proposal Template Option Year Five- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 RRB SMAC Services- Amendment 0001 Q and A and other changes SF 30.pdf	PDF	Aug 19, 2021
60RRBH21R0011 Attachment J.7 Basis of Estimate- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.1.C Performance Requirements Summary.docx	DOCX document	Aug 19, 2021
60RRBH21R0011 Attachment J.14 CLIN 0005 Cost Proposal Template Option Year Three- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.18 CLIN 0009 Cost Proposal Template Option Year Seven- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.15 CLIN 0006 Cost Proposal Template Option Year Four- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.11 CLIN 0002 Cost Proposal Template Base Year- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.33 RRB SMAC Providers by State.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.20 CLIN 0011 Cost Proposal Template Option Year Nine- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.12 CLIN 0003 Cost Proposal Template Option Year One- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.17 CLIN 0008 Cost Proposal Template Option Year Six- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.34 RRB Responses to Offeror Questions.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.19 CLIN 0010 Cost Proposal Template Option Year Eight- Revised.xlsx	XLSX spreadsheet	Aug 19, 2021
60RRBH21R0011 Attachment J.1 RRB SMAC SOW- Revised.docx	DOCX document	Aug 19, 2021
60RRBH21R0011 Attachment J.14 CLIN 0005 Cost Proposal Template Opt Year 3.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.17 CLIN 0008 Cost Proposal Template Opt Year 6.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.18 CLIN 0009 Cost Proposal Template Opt Year 7.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.10 CLIN 0001 Cost Proposal Template- Implementation Services for RRB SMAC.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.21 CLIN 0012 Cost Proposal Template Closeout.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.16 CLIN 0007 Cost Proposal Template Opt Year 5.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.13 CLIN 0004 Cost Proposal Template Opt Year2.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.15 CLIN 0006 Cost Proposal Template Opt Year 4.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.20 CLIN 0011 Cost Proposal Template Opt Year 9.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.19 CLIN 0010 Cost Proposal Template Opt Year 8.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.3 Small Business Subcontracting Plan.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.8 Past Performance Questionnaire.doc	DOC document	Jul 22, 2021
60RRBH21R0011 Attachment J.27 Compliance Attestation.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.23 Non-Disclosure Statement.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.11 CLIN 0002 Cost Proposal Template Base Year.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.29 Contractor Furnished Property.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.2 RRB SMAC Deliverable Schedule.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.25 Information Security Attestation.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.1.A Fee-For-Service Shared System Base Functions.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.4 Billing Instructions.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.6 Award Fee Plan Template.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.30 CMS Sec and Priv Language for Info Tech Procurements.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.28 HHS Contracting Guide for Contract of Government Property.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.1.B SOW Appendices.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.12 CLIN 0003 Cost Proposal Template Opt Year1.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.24 Proposal Assumptions Template.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.10A Cost Template Summary Sheet RRB SMAC.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011 Attachment J.31 Systems of Records.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.10B CLIN 0001 Cost Proposal Template- Implementation Services for RRB SMAC.xlsx	XLSX spreadsheet	Jul 22, 2021
60RRBH21R0011-Sections B-M.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.26 Corporate Experience Attestation.docx	DOCX document	Jul 22, 2021
60RRBH21R0011 Attachment J.7 Basis of Estimate.xlsx	XLSX spreadsheet	Jul 22, 2021

Show 40 more

Latest 50 of 55 listed here. See the rest on GovTribe.

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.

Allowance

Contractor Name:							LEGEND			Exhibit 1
						Warning: There could be an issue but there may not be.
Period Ending:						Issue: There is an issue such as missing data that needs to be resolved.
						This cell requires manual input
Allowance for Uncollectible Accounts Matrix
			NONFEDERAL-HI-MSP-CM-Registers-TOTAL	NONFEDERAL-HI-NONMSP-CM-Registers-TOTAL	NONFEDERAL-SMI-MSP-CM-Registers-TOTAL	NONFEDERAL-SMI-NONMSP-CM-Registers-TOTAL	NONFEDERAL-GEN-MSP-CM-Registers-TOTAL	NONFEDERAL-GEN-NONMSP-CM-Registers-TOTAL		NONFEDERAL-NA-NA-CM-TROR-TOTAL
			Col E	Col F	Col G	Col H	Col I	Col J
			HI Principal	HI Principal	SMI Principal	SMI Principal	General Fund	General Fund	Fund	TROR
Note: Amounts are from the TROR Supporting Reports			MSP	NON-MSP	MSP	NON-MSP	MSP	NON-MSP	Total	Report	Check
	TROR Line Item	HIGLAS Detail Activity Report/Register Line
A	(1) Beginning FY Balance	CMS Beginning Balance Report / (1) Beginning FY Balance	0	0	71	7,471,680	39	156,949	7,628,739	7,628,738	1
	(2) New Receivables (+)	CMS Transaction Register / LINE 2 NEW RECEIVABLES	0	0	0	12,715,571	0	0	12,715,571	12,715,571	0

(3) Accruals (+) (New Interest Receivables)						2	180,186		180,188	180,188	0
Transaction Register (support line 3)	CMS Transaction Register / LINE 3 ADJUSTMENT					0	56,235		56,235
CMS Adjustment Register (support line 3)	CMS Adjustment Register / LINE 3 MSP/NONMSP ADJUSTMENT					2	123,951		123,953
(5) Adjustments		0	0	263.000	(189,677)	121	18,428		(170,865)	(170,865)	0
(A) Reclassified/Adjusted Amounts (+ or -)	CMS AR Adjustments Register / LINE 5A MSP/NONMSP ADJUSTMENT	0	0	0	(538,772)	0	(612)	0	(539,384)	(539,383)	-1
(B) Adjustments Due to Sale of Assets (+ or -)	CMS AR Adjustments Register / LINE 5B MSP/NONMSP ADJUSTMENT	0	0	0	0	0	0	0	0	0	0
(C) Consolidations (+ or -)	CMS AR Adjustments Register / LINE 5C MSP/NONMSP ADJUSTMENT	0	0	0	0	0	0	0	0	0	0
(D) Forcloser Adjustments (+ or -)	CMS AR Adjustments Register / LINE 5D MSP/NONMSP ADJUSTMENT	0	0	0	0	0	0		0	0	0
(E) Written-Off Debts Reinstated for Collections (+)	CMS AR Adjustments Register / LINE 5E MSP/NONMSP ADJUSTMENT	0	0	263.000	349,095	121	19,040		368,519	368,518	1
(6) Amounts Written-Off (-)		0	0	0	(1,036,986)	0	(71,781)		(1,108,767)	(1,108,767)	0
(A) Currently Not Collectible (-)	CNC - CMS Adjustment Register / LINE 6A MSP/NONMSP ADJUSTMENT	0	0	0	(833,953)	0	(71,117)	0	(905,070)	(905,070)	0
(B) Written-Off and Closed Out (-)	CMS AR Adjustments Register / LINE 5E MSP/NONMSP ADJUSTMENT	0	0	0	(203,033)	0	(664)	0	(203,697)	(203,697)	0

Receivable Available to Be Collected 0 0 334.000 18,960,588 162 283,782 19,244,866 19,244,865 1

B	(4) Collections on Receivables (-)	CMS AR Applied Collections	263.000	10,786,074	121	70,611	10,857,069	10,857,069	0
	(A) At Agency		0	(10,606,769)	0	(43,429)	(10,650,198)	(10,650,198)	0
	(B) At Third Party		0	0	0	0	0	0	0
	(C) Asset Sales		0	0	0	0	0	0	0
	(D) Collections by Treasury through Offset and Cross-Servicing (-)		(263)	(179,305)	(121)	(27,182)	(206,871)	(206,870)	-1
	(E) Collections by Sales After Foreclosure (-)		0	0	0	0	0	0	0
	(F) Collections by Department of Justice (-)		0	0	0	0	0	0	0
	(G) Other - must footnote (-)		0	0	0	0	0	0	0

Collection Percentage n/a n/a 78.74% 56.89% 74.69% 24.88% 56.42% 56.42%

C Allowance Percentage (1-collection %) n/a n/a 21.26% 43.11% 25.31% 75.12% 43.58% 43.58%

D	Average of Allowance (current instruction require Medicare contractors to use five year historical allowance rate
		Average	n/a	n/a	16.31%	20.03%	25.31%	75.12%
		Current Period: Dec 31, 2010	n/a	n/a	21.26%	43.11%
		Sep 30, 2010	0.00%	0.00%	20.00%	15.00%
		Sep 30, 2009	0.00%	0.00%	10.00%	12.00%
		Sep 30, 2008	0.00%	0.00%	14.00%	10.00%
		Sep 30, 2007	n/a	n/a	n/a	n/a

E	(7) Ending Balance (TROR/Activity Registers)	CMS AR Overpayments Report	0	8,174,514	0	213,169	0	8,387,683	8,387,795	112
	Cost Report Settlements		0	0	0	0		0	0	0
	Claims Accounts Receivable		0	0	0	0		0	0	0
	Credit Balances		0	0	0	0		0	0	0
	Other (if cost reports issues included with cost reports)		0	0	0	0		0	0	0
	Physician/Supplier		0	8,129,931	0	213,169		8,343,100	8,343,100	0
	Beneficiary		0	44,583	0	0		44,583	44,583	0
	PIP Accrual		0	0	0	0		0	0	0
	GHP (Data/non-Data Match)		0	0	0	0		0	0	0
	MSP Prov/Phys/Supp/Bene		0	0	0	0		0	0	0
	MSP Beneficiary (Liability)		0	0	0	0		0	0	0
	Other MSP (Liability)		0	0	0	0		0	0	0
	Check		(71)	0	-41	(2)		-114	-1	-113

(X1) Allowance Amount (Collection Percentage) n/a n/a 0 1,637,216 0 160,128 1,797,344

(X2) Individual Account Analysis-Not Applicable for Carriers (Part B) *************************************** CMS has granted a Waiver for Carriers **************************************

(X3)	Delinquencies Exceeding 180 Days	CMS AR Overpayment Report where parameter "Allowance Calc(Over 180 Days Delinquent))"=Y	2,750,314	165,436	2,915,750	2,915,749	1
	Cost Report Settlements[180]		0	0	0	0	- 0
	Claims Accounts Receivable[180]		0	0	0	0	- 0
	Credit Balances[180]		0	0	0	0	- 0
	Other (if cost reports issues included with cost reports)[180]		0	0	0	0	- 0
	Physician/Supplier[180]		2,749,790	165,436	2,915,226	2,915,225	1
	Beneficiary[180]		524	0	524	524	- 0
	PIP Accrual[180]		0	0	0	0	- 0
	GHP (Data/non-Data Match)[180]		0	0	0	0	- 0
	MSP Prov/Phys/Supp/Bene[180]		0	0	0	0	- 0
	MSP Beneficiary (Liability)[180]		0	0	0	0	- 0
	Other MSP (Liability)[180]		0	0	0	0	- 0

F Estimated Allowance Amount ALLOWANCE USING THE MOST CONSERVATIVE AMOUNT 0 0 0 2,750,314 0 165,436 2,915,750

Amount Reported on Trial Balance per Allowance Matrix (Using the conservative amount):
		Amount
	HI MSP Allowance Amount	0
	HI NON-MSP Allowance Amount	0
	HI Total Allowance	0

Fund Acct# 05961 SGL#131901 SGL# 131901 - Allow For Loss on REC-PRINC - 0

SMI MSP Allowance Amount	0
SMI NON-MSP Allowance Amount	(2,750,314)
SMI Total Allowance	(2,750,314)

Fund Acct# 05960 SGL#131901 SGL# 131901 - Allow For Loss on REC-PRINC (2,750,314.00)

General Fund MSP Allowance	0
General Fund NON -MSP Allowance	(165,436)
General Fund Total Allowance	(165,436)

Fund Acct# 050720 SGL#134901 SGL# 134901 - Allow For Loss on REC-INT (165,436.00)

Note: HIGLAS Interest is not split between HI/SMI but MSP/non-MSP. Therefore, contractors shall compare the current interest collection percentage vs. the over 180 days delinquent amounts.

NOTES:

(*) The above amounts are the allowance estimates for loss on receivable for the period-to-date.

(**) Therefore, the estimated amounts are the calculated ending balances to be reported on the Summary 2 Trial Balance by SGL account by fund (Ending Balance Column).

(***) When Line A1, Receivables Available to be Collected by component is less then or equal to zero (0) the component estimated allowance amount must equal zero (0).

(****) When the estimated allowance is greater than the Line 7, Ending Balance (Line E - above by Fund), the reported allowance amount must equal the Line 7, Ending Balance (Line E - above by Fund).

&"Arial,Bold"RFP # 75FCMC21R0002 &"Arial,Bold"&F Allowance

&A &D

Matrix-B MAC

Contractor Name:	Exhibit 3
Contractor Number:
Period Ending :

400.14 - Exhibit 14 - Protocol for Estimating Allowance for Uncollectible Accounts

Carrier - Group 2

Allowance for Uncollectible Accounts Matrix
Part B (SMI)
	Col. A	Col. B	Col. C	Col. D	Col. E
Sub-Group1 (Non-MSP) Claims A/R, Credit Balance & Other Accounts Receivable	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
NONMSP	$ 1,637,216	$ - 0	$ 2,750,314	$ 2,750,314	$ 165,436

Morgan: CMS:

This Cell(F12) in the old version referenced to the Delinquencies Exceeding 180 Days in the Allowance Tab (cell I69). This was changed to reference cell I83, because the estimated allowance amount could potentially be determined based on the Collection percentage. Row I83 applies the comparison between the available methods and should therefore flow to the Matrix.

Total $ 1,637,216 $ - 0 $ 2,750,314 $ 2,750,314 $ 165,436

Sub-Group 2 (MSP) Group Health Plan (Data-Match & Non-Data Match), Liability	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
MSP	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

	Historical Collection % Total	Individual Account Analysis	Delinquencies Exceeding 180 days total	Estimated Allowance for Uncollectible A/R	Estimated Allowance for Uncollectible A/R (Interest Only)	Justification for amount recorded on Summary 2 Trial Balance
Sub-Group 1 (Non-MSP) Claims A/R, Credit Balance & Other Accounts Receivable	$ 1,637,216	$ - 0	$ 2,750,314	$ 2,750,314

Morgan: CMS:

This cell(E22) was mapped to D22 in old version, but changed to E12 in the new version to be consistant with Matrix-FI tab.	$ 165,436
	Sub-Group 2 (MSP) Group Health Plan (Data-Match & Non-Data Match), Liability	$ - 0	$ - 0	$ - 0	$ - 0

Morgan: CMS:

This Cell(E23) was mapped to D23 in old version but changed to E17 in new version to be consistant with Matrix-FI tab. $ - 0

Total Part B (SMI) $ 1,637,216 $ - 0 $ 2,750,314 $ 2,750,314 $ 165,436

&"Arial,Bold"RFP 60RRBH21R0011 &"Arial,Bold"Attachment J.32 Cash Collections Worksheet Matrix-B MAC

Data

TROR_Line	NONFEDERAL-GEN-MSP-CM-Registers-TOTAL	NONFEDERAL-GEN-NONMSP-CM-Registers-TOTAL	NONFEDERAL-NA-NA-CM-Registers-TOTAL	NONFEDERAL-NA-NA-CM-TROR-COUNT	NONFEDERAL-NA-NA-CM-TROR-TOTAL	NONFEDERAL-SMI-MSP-CM-Registers-TOTAL	NONFEDERAL-SMI-NONMSP-CM-Registers-TOTAL
(1) Beginning FY Balance	39	156949		30999	7628738	71	7471680
(2) New Receivables (+)				142633	12715571		12715571
(3) Accruals (+) (New Interest Receivables)					180188
(4) Collections on Receivables (-)					-10857069
(5) Adjustments				5489	-170865
(6) Amounts Written-Off (-)				27374	-1108768
(7) Ending Balance (TROR/Activity Registers)				42302	8387795
(A) At Agency		-43429			-10650198		-10606769
(A) Currently Not Collectible (-)		-71117		573	-905070		-833953
(A) Reclassified/Adjusted Amounts (+ or -)		-612			-539383		-538772
(B) Written-Off and Closed Out (-)		-664		26801	-203697		-203033
(D) Collections by Treasury through Offset and Cross-Servicing (-)	-121	-27182			-206870	-263	-179305
(E) Written-Off Debts Reinstated for Collections (+)	121	19040			368518	263	349095
Beneficiary			44583				44583
Beneficiary[180]			524				524
CMS Adjustment Register (support line 3)	2	123951
GHP(Data/non-Data Match)	41		112			71
GHP(Data/non-Data Match)[180]	41		112			71
Physician/Supplier		213169	8343100				8129931
Physician/Supplier[180]		165436	2915225				2749790
Transaction Register (support line 3)		56235

Changes to calcs

Tab	Cell Changed	Changed From	Changed to	Change Rationale
Matrix-Carrier	F22	D22	E12	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total" or "Historical Collection % Total".
Matrix-Carrier	E23	D23	E17	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total" or "Historical Collection % Total".
Matrix-Carrier	F12	Allowance!I69	Allowance!I83	Cell F12 - Estimated Allowance for Uncollectible A/R (Interest Only) – this is referenced to the Delinquencies Exceeding 180 Days in the Allowance Tab (cell I69). This should be referenced into cell I83, because the estimated allowance amount could potentially be determined based on the Collection percentage. Row 83 applies the comparison between the available methods and should therefore flow to the Matrix.
Matrix-FI	E22	D22	E12	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total", "Individual Account Analysis" or "Historical Collection % Total".
Matrix-FI	E23	D22	E17	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total", "Individual Account Analysis" or "Historical Collection % Total".
Matrix-FI	E41	D41	E31	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total", "Individual Account Analysis" or "Historical Collection % Total".
Matrix-FI	E42	D42	E36	"Estimated Allowance for Uncollectible A/R" should be most conservative estimate of "Delinquencies Exceeding 180 days total", "Individual Account Analysis" or "Historical Collection % Total".
Matrix-Carrier	F12	Allowance!I69	Allowance!I83	Cell F12 - Estimated Allowance for Uncollectible A/R (Interest Only) – this is referenced to the Delinquencies Exceeding 180 Days in the Allowance Tab (cell I69). This should be referenced into cell I83, because the estimated allowance amount could potentially be determined based on the Collection percentage. Row 83 applies the comparison between the available methods and should therefore flow to the Matrix.

&"Arial,Bold"RFP 60RRBH21R0011 &"Arial,Bold"Attachment J.32 Cash Collections Worksheet Changes to calcs

Request_IDs

Original Workload	Cust_Class	Report	12/31/2010
99998	NONFEDERAL	AdjLn3rpt	11337101
99998	NONFEDERAL	AdjLn5_6rpt	11359879
99998	NONFEDERAL	AppCollrpt	11337102
99998	NONFEDERAL	AROvrrpt	11337104
99998	NONFEDERAL	AROvrrpt[180]	11324610
99998	NONFEDERAL	BBrpt	11337098
99998	NONFEDERAL	HIGLAS_TROR	11341019
99998	NONFEDERAL	TALn2rpt	11337099
99998	NONFEDERAL	TALn3rpt	11337100

&"Arial,Bold"RFP 60RRBH21R0011 &"Arial,Bold"Attachment J.32 Cash Collections Worksheet Request_IDs

Lookup_Values

Category	ORG NAME
CM	12/31/2010
ORG	Part B
Part	B
PM	11/30/2010
PQ	9/30/2010
PY	12/31/2009
WL	99998

HISTORICAL_ALLOWANCES

HISTORICAL_YEAR	NONFEDERAL-HI-MSP-CM-Registers-TOTAL	NONFEDERAL-HI-NONMSP-CM-Registers-TOTAL	NONFEDERAL-SMI-MSP-CM-Registers-TOTAL	NONFEDERAL-SMI-NONMSP-CM-Registers-TOTAL
2010			0.2	0.15
2009			0.1	0.12
2008			0.14	0.1

File details come from the government source that posted it. Updated Jul 22, 2021.