ARPA Agreements and Reporting scenario based tool 122721FINAL.xlsx

	A	B	C	D	E	F	G	H
1		SLFRF Agreements, Reporting and Monitoring Matrix 12/29/2021
2	Purpose: The purpose of this sheet is to outline monitoring and reporting responsibilities, as well as identify the appropriate agreement document (SLFRF Grant Agreement, Intergovernmental Grant Agreement, etc). Each section provides a different scenario to help in determining the processes that are necessary.
3
4			Agency #1	Agency #2	Agency #3	Political Subdivision	Subrecipient	Contractor
5
6	Scenario 1:	State Agency #1 provides funding to State Agency #2
7		OSPB provides funding to CDHS
8		Agreement	Approval by OSPB; interagency
9		Funding Party:	Agency #1 (OSPB)
10		Receiving Party:	Agency #2 (CDHS)
11		Monitoring	Responsible to monitor Agency #2
12		Indirect Cost Rate	Responsible for review of IDCR for Agency #2
13		Reporting
14		Classification:	Pass through entity	NA
15		Gravity:	NA	Gravity for reporting *
16		Exhibit F Workbook:	NA	NA
17		Other	NA	Submits documentation to Agency #1 for reimbursement
18
19	Scenario 2:	State Agency #1 passes funds to State Agency #2, who further passes funds through to State Agency #3
20		OSPB passed funds to CDPHE who further passes funds to the University of Colorado
21		Agreement	Approval by OSPB; interagency	SLFRF Grant Agreement - Interagency
22		Funding Party:	Agency #1 (OSPB)	Agency #2 (CDPHE)
23		Receiving Party:	Agency #2 (CDPHE)	Agency #3 (CU)
24		Monitoring	Responsible to monitor Agency #2	Responsible to monitor Agency #3
25		Indirect Cost Rate	Responsible for review of IDCR for Agency #2	Responsible for review of IDCR for Agency #3
26		Reporting
27		Classification:	Pass through entity	Pass through entity	NA
28		Gravity:	NA	NA	Gravity for reporting *
29		Exhibit F Workbook:	NA	NA	NA
30		Other	NA	Submits documentation to Agency #1 for reimbursement	Submits documentation to Agency #2 for reimbursement
31
32	Scenario 3:	State Agency #1 passes funds to State Agency #2, who further passes to State Agency #3, who further passes to Political Subdivision**
33		OSPB passes funds to CDPHE, who further passes funds to CDPS, who further passes funds to City and County of Denver
34		Agreement	Approval by OSPB; interagency	SLFRF Grant Agreement - Interagency	SLFRF Grant Agreement - Intergovernmental
35		Funding Party:	Agency #1 (OSPB)	Agency #2 (CDPHE)	Agency #2 (CDPS)
36		Receiving Party:	Agency #2 (CDPHE)	Agency #3 (CDPS)	Political Subdivision (Denver)
37		Monitoring	Resonsible for monitoring Agency #2	Resonsible for monitoring Agency #3	Responsible to monitor Political Subdivision
38		Indirect Cost Rate	Responsible for review of IDCR for Agency #2	Responsible for review of IDCR for Agency #3	Responsible for review of IDCR for Political Subdivision
39		Reporting
40		Classification:	Pass through entity	Pass through entity	Pass through entity	NA
41		Gravity:	NA	NA	Gravity for reporting*	NA
42		Exhibit F Workbook:	NA	NA	NA	Exhibit F Workbook for reporting sent to Agency #3
43		Other	NA	Submits documentation to Agency #1 for reimbursement	Submits documentation to Agency #2 for reimbursement	Submits documentation to Agency #3 for reimbursement
44
45	Scenario 4:	State Agency #1 passes funds to State Agency #2 and State Agency #2 passes funds to Subrecipient
46		CDPHE passes funds to University of Colorado and University of Colorado passes funds to Children's Hospital of Colorado
47		Agreement	SLFRF Grant Agreement - Interagency	SLFRF Grant Agreement
48		Funding Party:	Agency #1 (CDPHE)	Agency #2 (CU)
49		Receiving Party:	Agency #2 (CU)	Subrecipient (Children's Hospital)
50		Monitoring	Resonsible for monitoring Agency #2	Responsible for monitoring Subrecipient
51		Indirect Cost Rate	Responsible for review of IDCR for Agency #2	Responsible for review of IDCR for Subrecipient
52		Reporting
53		Classification:	Pass through entity	Pass through entity
54		Gravity:	NA	Gravity for reporting*			NA
55		Exhibit F Workbook:	NA	NA			Exhibit F Workbook for reporting sent to Agency #2
56		Other	NA	Submits documentation to Agency #1 for reimbursement			Submits documentation to Agency #2 for reimbursement
57
58	Scenario 5:	State Agency #1 passes funds to State Agency #2, who futher passed to State Agency #3 that contracts with Contractor
59		OSPB passes funds to CDPHE, who further passes funds to CDHS who contracts with ABC Consulting
60		Agreement	Approval by OSPB; may include interagency	SLFRF Grant Agreement - Interagency	Personal Services Contract or PO
61		Funding Party:	Agency #1 (OSPB)	Agency #2 (CDPHE)	Agency #3 (CDHS)
62		Receiving Party:	Agency #2 (CDPHE)	Agency #3 (CDHS)	Contractor (ABC Consulting)
63		Monitoring	Resonsible for monitoring Agency #2	Resonsible for monitoring Agency #3	Responsible for approving invoices and compliance with contract
64		Indirect Cost Rate	Responsible for review of IDCR for Agency #2	Responsible for review of IDCR for Agency #3	NA
65		Reporting
66		Classification:	Pass through entity	Pass through entity	Purchase of Goods & Services			NA
67		Gravity:	NA	NA	Gravity for reporting*			NA
68		Exhibit F Workbook:	NA	NA	NA			NA
69		Other	NA	Submits documentation to Agency #1 for reimbursement	Submits documentation to Agency #2 for reimbursement			Invoices to Agency #3
70
71	Scenario 6:	State Agency #1 passes funds to State Agency #2 and State Agency #2 purchases services (not the usual situaton)****
72		DOC purchases IT services from OIT
73		Agreement	Interagency Agreement
74		Funding Party:	Agency #1 (DOC)
75		Receiving Party:	Agency #2 (OIT)
76		Monitoring	Responsible for approving invoices and compliance with the interagency
77		Indirect Cost Rate	NA
78		Reporting
79		Classification:	Purchase of Goods & Services	NA
80		Gravity:	Gravity for reporting*	NA
81		Exhibit F Workbook:	NA	NA
82		Other	NA	Invoices to Agency #1
83
84		*	Gravity or manual reporting until Gravity is implemented
85		**	Political Subdivisions Include cities, counties, State of Colorado schools, and special districts
86		***	Subrecipients include entities with program responsibilities - See Uniform Guidance. Section 200.93. Subrecipients include: non-State of Colorado schools such as Colorado Mountain College, Emily Griffith, and Ames Community College
87		****	This scenario occurs when a State Agency purchases goods or services from an Agency that supplies these services as part of their regular ongoing activities. Such a State Agency is usually an internal service fund.
88
89
90
91
92
93
94
95
96
97
98
99
100