AGENDA ITEM FINANCIAL IMPACT FORM 20201007.XLSX

Maricopa County — Formal (2020-10-07)

View PDF Item 28 Meeting page

Extracted text (via pymupdf) 5377 characters
Financial Impact for Budget Adjustments Only
Agenda Item C#
C-95-21-004-X-00
Meeting Date
10/7/2020
Line #
Dept
Code
Fund
Approp
 Unit
Unit
Activity
Obj
Code
Program
Code
Project
Code
Amount
Fiscal
Year
1
D060
200
1001
xxxx
xxxx
Expend
CARES
$
976
FY 21
2
D110
200
1001
xxxx
xxxx
Expend
CARES
$
93,995
FY 21
3
D120
200
1001
xxxx
xxxx
Expend
CARES
$
39,200
FY 21
4
D140
200
1001
xxxx
xxxx
Expend
CARES
$
6,457
FY 21
5
D150
200
1001
xxxx
xxxx
Expend
CARES
$
37,205
FY 21
6
D160
200
1001
xxxx
xxxx
Expend
CARES
$
968,900
FY 21
7
D180
200
1001
xxxx
xxxx
Expend
CARES
$
729
FY 21
8
D200
200
1001
xxxx
xxxx
Expend
CARES
$
22,375
FY 21
9
D210
200
1001
xxxx
xxxx
Expend
CARES
$
262,068
FY 21
10
D220
200
1001
xxxx
xxxx
Expend
CARES
$
7,237,600
FY 21
11
D260
200
1001
xxxx
xxxx
Expend
CARES
$
13,111,699
FY 21
12
D270
200
1001
xxxx
xxxx
Expend
CARES
$
298,447
FY 21
13
D290
200
1001
xxxx
xxxx
Expend
CARES
$
999,414
FY 21
14
D300
200
1001
xxxx
xxxx
Expend
CARES
$
24,249
FY 21
15
D310
200
1001
xxxx
xxxx
Expend
CARES
$
766,183
FY 21
16
D340
200
1001
xxxx
xxxx
Expend
CARES
$
12,227
FY 21
17
D360
200
1001
xxxx
xxxx
Expend
CARES
$
11,726
FY 21
18
D370
200
1001
xxxx
xxxx
Expend
CARES
$
32,569
FY 21
19
D410
200
1001
xxxx
xxxx
Expend
CARES
$
591,513
FY 21
20
D440
200
1001
xxxx
xxxx
Expend
CARES
$
25,961
FY 21
21
D490
200
1001
xxxx
xxxx
Expend
CARES
$
2,780
FY 21
22
D500
200
1001
xxxx
xxxx
Expend
CARES
$
54,481,605
FY 21
23
D560
200
1001
xxxx
xxxx
Expend
CARES
$
104,993
FY 21
24
D640
200
1001
xxxx
xxxx
Expend
CARES
$
234,988
FY 21
25
D700
200
1001
xxxx
xxxx
Expend
CARES
$
382,900
FY 21
26
D730
200
1001
xxxx
xxxx
Expend
CARES
$
49,494
FY 21
27
D750
200
1001
xxxx
xxxx
Expend
CARES
$
30,517
FY 21
28
D780
200
1001
xxxx
xxxx
Expend
CARES
$
3,834
FY 21
29
D790
200
1001
xxxx
xxxx
Expend
CARES
$
8,296
FY 21
30
D800
200
1001
xxxx
xxxx
Expend
CARES
$
1,540,810
FY 21
31
D850
200
1001
xxxx
xxxx
Expend
CARES
$
352
FY 21
32
D880
200
1001
xxxx
xxxx
Expend
CARES
$
162,452
FY 21
33
D930
200
1001
xxxx
xxxx
Expend
CARES
$
3,395
FY 21
34
D950
200
1001
xxxx
xxxx
Expend
CARES
$
19,114,314
FY 21
35
36
37
38
D470
200
NRNP
xxxx
xxxx
Expend
CARES
$
(100,664,223)
FY21 offset to current expenditure need
39
D470
200
NRNP
xxxx
xxxx
Expend
CARES
$
(77,985,632)
FY21 Above budget grant usage in FY20, reduce FY21
40
D470
249
NRNP
4712
GGOV
8120
$
77,985,632
FY21 Offset FY21 reduction to Contingency
41
42
D500
100
OPER
xxxx
xxxx
7954
$
(16,286,347)
FY21 Patrol
43
D500
100
MEL0
xxxx
xxxx
7954
$
(2,214,928)
FY21 Patrol
44
D500
255
OPER
xxxx
xxxx
7954
$
(611,257)
FY21 Patrol
45
D500
255
OPER
xxxx
xxxx
7954
$
(32,342,382)
FY21 Correctional
46
D500
255
GRV0
xxxx
xxxx
7954
$
(55,835)
FY21 Correctional
47
D260
255
OPER
xxxx
xxxx
7954
$
(9,109,756)
FY21 Correctional
48
D260
255
GRV0
xxxx
xxxx
7954
$
(265,608)
FY21 Correctional
49
D260
255
OPER
xxxx
xxxx
8720
$
(224,159)
FY21 Correctional - registry
50
51
D470
100
OPER
4712
GGOV
8120
$
18,501,275
FY21 Contingency
52
D470
255
OPER
4712
GGOV
8120
$
42,608,997
FY21 Contingency
53
$
-

Financial Impact for Budget Adjustments Only
Agenda Item C#
C-95-21-004-X-00
Meeting Date
10/7/2020
Line #
Dept
Code
Fund
Approp
 Unit
Unit
Activity
Obj
Code
Program
Code
Project
Code
Amount
Fiscal
Year
1
D060
200
1001
xxxx
xxxx
6150
CARES
$
976
FY 21
2
D110
200
1001
xxxx
xxxx
6150
CARES
$
93,995
FY 21
3
D120
200
1001
xxxx
xxxx
6150
CARES
$
39,200
FY 21
4
D140
200
1001
xxxx
xxxx
6150
CARES
$
6,457
FY 21
5
D150
200
1001
xxxx
xxxx
6150
CARES
$
37,205
FY 21
6
D160
200
1001
xxxx
xxxx
6150
CARES
$
968,900
FY 21
7
D180
200
1001
xxxx
xxxx
6150
CARES
$
729
FY 21
8
D200
200
1001
xxxx
xxxx
6150
CARES
$
22,375
FY 21
9
D210
200
1001
xxxx
xxxx
6150
CARES
$
262,068
FY 21
10
D220
200
1001
xxxx
xxxx
6150
CARES
$
7,237,600
FY 21
11
D260
200
1001
xxxx
xxxx
6150
CARES
$
13,111,699
FY 21
12
D270
200
1001
xxxx
xxxx
6150
CARES
$
298,447
FY 21
13
D290
200
1001
xxxx
xxxx
6150
CARES
$
999,414
FY 21
14
D300
200
1001
xxxx
xxxx
6150
CARES
$
24,249
FY 21
15
D310
200
1001
xxxx
xxxx
6150
CARES
$
766,183
FY 21
16
D340
200
1001
xxxx
xxxx
6150
CARES
$
12,227
FY 21
17
D360
200
1001
xxxx
xxxx
6150
CARES
$
11,726
FY 21
18
D370
200
1001
xxxx
xxxx
6150
CARES
$
32,569
FY 21
19
D410
200
1001
xxxx
xxxx
6150
CARES
$
591,513
FY 21
20
D440
200
1001
xxxx
xxxx
6150
CARES
$
25,961
FY 21
21
D490
200
1001
xxxx
xxxx
6150
CARES
$
2,780
FY 21
22
D500
200
1001
xxxx
xxxx
6150
CARES
$
54,481,605
FY 21
23
D560
200
1001
xxxx
xxxx
6150
CARES
$
104,993
FY 21
24
D640
200
1001
xxxx
xxxx
6150
CARES
$
234,988
FY 21
25
D700
200
1001
xxxx
xxxx
6150
CARES
$
382,900
FY 21
26
D730
200
1001
xxxx
xxxx
6150
CARES
$
49,494
FY 21
27
D750
200
1001
xxxx
xxxx
6150
CARES
$
30,517
FY 21
28
D780
200
1001
xxxx
xxxx
6150
CARES
$
3,834
FY 21
29
D790
200
1001
xxxx
xxxx
6150
CARES
$
8,296
FY 21
30
D800
200
1001
xxxx
xxxx
6150
CARES
$
1,540,810
FY 21
31
D850
200
1001
xxxx
xxxx
6150
CARES
$
352
FY 21
32
D880
200
1001
xxxx
xxxx
6150
CARES
$
162,452
FY 21
33
D930
200
1001
xxxx
xxxx
6150
CARES
$
3,395
FY 21
34
D950
200
1001
xxxx
xxxx
6150
CARES
$
19,114,314
FY 21
35
36
D470
200
NRNP
xxxx
xxxx
Expend
CARES
$
(100,664,223)
FY21
60
$
-

INFORMATION ONLY:
FY20 
Budget
Actual
Fund 200
30,935,900.00
98,946,545.00
(68,010,645.00)
Total CARES from US Treasury
398,960,913.00
300,014,368.00
Amount left afer FY20
378,000,000.00
FY21 Original Budget
FY21 Budget
77,985,632.00
Budget Reduction Needed to match funding provided