FY20 GRANT REVENUE BUDGET RECONCILIATION.XLSX
Extracted text (via pymupdf)
9796 characters
FY 2020 Budget Appropriation Adjustment - Supporting Documentation Grant Summary Worksheet - Object Code 6150 Detail Reference 6150: Grants-Federal 6151: Grants-State 6152: Grants-Other Dept: D220 Fund: 222 Grant Source Grant Activity Start Date End Date Program Total Award Adopted FY 2020 Requested Budget FY 2020 Revised Budget TRUE UP Comment Direct Exp FY 2020 Indirect Cost Rate Grant Source NAWB HSDX 7/1/2019 6/30/2020 22NAWB 100,000 - 25,000 25,000 25,000 - Grant Source CSCA CHARGES VARIOUS 7/1/2019 6/30/2020 N/A - 3,413,840 3,413,840 - 3,413,840 - Grant Source COSTPOOL POOL 7/1/2019 6/30/2019 COSTPOOL - (2,777,752) (2,777,752) - (2,777,752) - Grant Source HSDX 7/1/2019 6/30/2020 22CSADOH 89,100 88,201 89,098 897 72,824 16,274 Grant Source HSDX 8/1/2019 7/31/2020 22CSAPSE3 131,000 43,976 121,505 77,529 Awarded additional funding to extend thru June 97,776 23,729 Grant Source CS HAMC Coffelt HSDX 5/1/2019 4/30/2020 22CSHMCFLT 25,000 23,961 14,575 (9,386) 10,126 4,449 Grant Source CS-NHN-VOUCHERS HSDX 7/1/2019 6/30/2020 22CSNHNVH 6,910 6,046 5,685 (361) 5,685 - Grant Source AZ COMMUNITY ACTION ASSOC-APS HSDX 7/1/2019 6/30/2020 CSACAAAPS 353,317 118,889 353,317 234,428 Additional funding awarded in the fall 353,317 Grant Source AZ COMMUNITY ACTION ASSOC-HEAF HSDX 7/1/2019 6/30/2020 CSACAAHEAF - 6,680 - (6,680) Delete Budget - Grant Source AZ COMMUNITY ACTION ASSOC-SRP HSDX 7/1/2019 6/30/2020 CSACAASRP 111,859 53,940 111,859 57,919 Additional funding awarded in the fall 111,859 Grant Source AZ COMMUNITY ACTION ASSOC-SWG ENERGY SHARE HSDX 7/1/2019 6/30/2020 CSACAASWES - 45,000 - (45,000) Delete Budget - Grant Source AZ COMMUNITY ACTION ASSOC-GWL HSDX 7/1/2019 6/30/2020 CSACAASWG 49,230 45,000 49,230 4,230 49,230 Grant Source AZ COMMUNITY ACTION ASSOC-URRD HSDX 7/1/2019 6/30/2020 CSACAAURRD 54,891 54,794 54,891 97 54,891 Grant Source CS DES COMMUNITY SVCS BLOCK GRANT-ADMIN HSDX 7/1/2019 6/30/2020 CSBGADM 452,476 831,032 379,262 (451,770) 334,093 45,169 Grant Source CS DES COMMUNITY SVCS BLOCK GRANT-VOUCHER HSDX 7/1/2019 6/30/2020 CSBGVH 176,832 49,440 176,832 127,392 176,832 - Grant Source HUD FAMILY SELF SUFFICIENCY HSDX 1/1/2019 12/31/2019 CSHMCHFSS 69,380 71,794 44,698 (27,097) 44,698 - Grant Source CS HAMC MADISON HEIGHTS HSDX 1/1/2019 12/31/2019 CSHMCMADHT 25,000 53,008 7,861 (45,147) 3,326 4,535 Grant Source CSD DES LIHEAP HSDX 7/1/2019 6/30/2020 CSLIHEAP - 79,729 - (79,729) Delete Budget - - Grant Source CSD DES LIHEAP-ADM HSDX 7/1/2019 6/30/2020 CSLIHEAPAM 260,322 404,735 244,310 (160,425) 194,701 49,609 Grant Source CSD DES LIHEAP - VOUCHER HSDX 7/1/2019 6/30/2020 CSLIHEAPVH 3,676,935 3,213,829 3,676,935 463,106 Carry over funding 3,676,935 - Grant Source ADES TANF-ADMIN HSDX 7/1/2019 6/30/2020 CSTANF 98,485 90,713 91,696 983 75,138 16,558 Grant Source ADES- TANF SUB HSDX 7/1/2019 6/30/2020 CSTANFSUB 109,777 199,432 109,777 (89,655) 109,777 - Grant Source ADES TANF-VOUCHERS HSDX 7/1/2019 6/30/2020 CSTANFVH 385,062 221,441 385,062 163,621 385,062 - Grant Source SSBGCM HSDX 7/1/2019 6/30/2020 SSBGCM 353,966 345,759 353,047 7,288 293,658 59,389 Grant Source HSDX 7/1/2019 6/30/2020 CSBGSUB 272,000 - 199,724 199,724 Carry over funding 199,724 - Grant Source HSDX 7/1/2019 6/30/2020 22CSLIHEAP 44,222 - 34,133 34,133 34,133 - Grant Source HSDX 7/1/2019 6/30/2020 CSLIHEAPSB 436,253 - 430,469 430,469 430,469 - Grant Source HSDX 3/27/2020 12/31/2020 22CSDOHCVA 51,031 - 51,031 51,031 COVD 41,760 9,271 Grant Source HSDX 3/27/2020 12/31/2020 22CSSRPCV 153,909 - 153,909 153,909 COVD 153,909 - Grant Source HSDX 7/1/2019 6/30/2020 22CSADOHVH 390,400 - 390,400 390,400 Additional funding awarded in the spring 390,400 - Grant Source HSDX 3/27/2020 12/31/2020 22CSDOHCVV 290,000 - 290,000 290,000 COVD 290,000 - Grant Source CCP EXPANSION BASE HSDX 3/1/2019 3/31/2020 EDCCPEXP 1,884,735 1,771,139 1,852,698 81,559 1,749,178 103,520 Grant Source EARY CHILDHOOD PARTNERSHIP HSDX 7/1/2019 6/30/2020 EDCCPSHP 2,772,392 2,587,582 2,810,622 223,040 2,707,065 103,557 Grant Source EARY CHILDHOOD TTA HSDX 7/1/2019 6/30/2020 EDCCTTA 61,299 61,299 54,079 (7,220) 46,982 7,097 Grant Source CCP EXPANSION TTA HSDX 3/1/2019 3/31/2020 EDCPXTTA 43,114 43,115 13,794 (29,321) 13,794 - Grant Source EARLY HEADSTART BASE HSDX 7/1/2019 6/30/2020 EDEHEADST 2,972,032 2,883,131 2,920,288 37,157 2,408,931 511,357 Grant Source CACFP MEALS REIMBURSEMENT EARLY HEADSTART HSDX 10/1/2019 9/30/2020 EDEHHCACF 98,000 98,000 98,000 - 98,000 - Grant Source EARLY HEADSTART TTA HSDX 7/1/2019 6/30/2020 EDEHSTTA 66,934 66,934 45,149 (21,785) 40,259 4,890 Grant Source CACFP MEALS REIMBURSEMENT HEADSTART HSDX 10/1/2019 9/30/2020 EDHDHCACF 342,000 342,000 342,000 - 342,000 - Grant Source HEAD START BASE HSDX 7/1/2019 6/30/2020 EDHDSTTA 126,164 126,164 116,798 (9,366) 106,359 10,439 Grant Source HSDED HEAD START ADMIN HSDX 7/1/2019 6/30/2020 EDHEADST 12,067,306 10,738,744 11,747,455 1,008,711 10,137,311 1,610,144 Grant Source SASD AAA SAIL HSDX 7/1/2019 6/30/2020 SASDAAS 1,623,172 1,476,777 1,622,736 145,959 1,336,582 286,154 Grant Source SAIL WAITLIST HSDX 7/1/2019 6/30/2020 22SAILWTLT 200,000 203,198 199,589 (3,609) 165,845 33,744 Grant Source CITY OF PHOENIX HSDX 7/1/2019 6/30/2020 22SWFIPX 174,334 174,334 174,334 - 160,626 13,708 Grant Source CITY OF SURPRISE HSDX 7/1/2019 6/30/2020 22WDSURP 43,968 43,968 43,968 - 35,980 7,988 Grant Source CITY OF WICKENBURG HSDX 7/1/2019 6/30/2020 22WDWKBG 48,805 48,805 48,805 - 39,939 8,866 Grant Source WDD - ADULT ADMIN-FY HSDX 7/1/2019 6/30/2020 WDFYADADMN 509,961 587,785 587,785 - - 587,785 Grant Source WDD - ADULT-FY HSDX 7/1/2019 6/30/2020 WDFYADULT 7,715,307 2,956,940 2,956,940 - 2,956,940 - Grant Source WDD - DISLOCATED WORKER-FY HSDX 7/1/2019 6/30/2020 WDFYDISWRK 2,556,456 1,726,488 1,726,488 - 1,726,488 - Grant Source WDD - ADULT TO DISLOCATED-FY HSDX 7/1/2019 6/30/2020 WDFYDWADLT - 2,001,806 2,001,806 - 2,001,806 - Grant Source WDD - DISLOCATED ADMIN-FY HSDX 7/1/2019 6/30/2020 WDFYDWADMN 696,357 87,937 87,937 - - 87,937 Grant Source WDD - RAPID RESPONSE-FY HSDX 7/1/2019 6/30/2020 WDFYRPDRSP 793,231 530,924 530,924 - 530,924 - Grant Source WDD - ADULT ADMIN-PY HSDX 7/1/2019 6/30/2020 WDPYADADMN 97,640 93,446 93,446 - - 93,446 Grant Source WDD - ADULT-PY HSDX 7/1/2019 6/30/2020 WDPYADULT 1,706,382 565,338 565,338 - 565,338 - Grant Source WDD - DISLOCATED WORKER-PY HSDX 7/1/2019 6/30/2020 WDPYDISWRK 514,831 827,840 827,840 - 827,840 - Grant Source WDD - DISLOCATED ADMIN-PY HSDX 7/1/2019 6/30/2020 WDPYDWADMN 149,186 - - - - - Grant Source WDD - RAPID RESPONSE-PY HSDX 7/1/2019 6/30/2020 WDPYRPDRSP 179,023 110,379 110,379 - 110,379 - Grant Source WDD - YOUTH ADMIN-PY HSDX 7/1/2019 6/30/2020 WDPYYTHADM 320,859 568,973 568,973 - 161,765 407,208 Grant Source WDD - YOUTH PROGRAM-PY HSDX 7/1/2019 6/30/2020 WDPYYTHPRO 5,811,190 3,972,818 3,972,818 - 3,972,818 - Grant Source AZ COMMUNITY ACTION ASSOC SRP WX HSDX 7/1/2019 6/30/2020 22CDACAAUR 762 762 689 (73) 569 120 Grant Source AZ COMMUNITY ACTION ASSOC SRP WX HSDX 7/1/2019 6/30/2020 22CDACAURS 13,636 7,619 13,636 6,017 13,636 - Grant Source HUDESG HSDX 7/1/2019 6/30/2020 22ESGAZSUB 107,000 37,000 99,011 62,011 99,011 - Grant Source HUDESG HSDX 7/1/2019 6/30/2020 22ESGNCSUB 11,830 11,830 7,032 (4,798) 7,032 - Grant Source HUDESG HSDX 7/1/2019 6/30/2020 22ESGNLSUB 180,000 90,000 90,000 - 90,000 - Grant Source AZ COMMUNITY ACTION ASSOC SRP WX- ADMIN HSDX 7/1/2019 6/30/2020 CDACAASRP 45,203 45,203 20,633 (24,570) 17,043 3,590 Grant Source ACAA UTILITY REPAIR, REPLACE AND DEPOSIT WX-ADMIN HSDX 7/1/2019 6/30/2020 CDACAAURAD 37,401 21,817 37,401 15,584 30,889 6,512 Grant Source ACAA UTILITY REPAIR, REPLACE AND DEPOSIT WX HSDX 7/1/2019 6/30/2020 CDACAAURRD 454,983 272,708 454,983 182,275 454,983 - Grant Source AZ COMMUNITY ACTION ASSOC SRP WX HSDX 7/1/2019 6/30/2020 CDACASRP 226,017 226,017 215,763 (10,254) 215,763 - Grant Source APS WEATHERIZATION-ADMIN HSDX 7/1/2019 6/30/2020 CDACSADM 137,500 98,872 19,283 (79,589) 15,955 3,328 Grant Source APS WEATHERIZATION HSDX 7/1/2019 6/30/2020 CDACSAPS 687,500 494,362 294,333 (200,029) 294,333 - Grant Source ESG16 HUD HSDX 7/1/2019 6/30/2020 CDESGADM 18,887 18,715 18,032 (683) 14,914 3,118 Grant Source ESG16 HUD-COMMUNITY BRIDGES ES26 SUB HSDX 7/1/2019 6/30/2020 CDESGSUB 164,944 92,000 113,367 21,367 113,367 - Grant Source AZ DEPT OF HOUSING WEATHERIZATION GOEP LIHEAP HSDX 7/1/2019 6/30/2020 CDLIHEAP 400 7,776 400 (7,376) 400 - Grant Source AZ DEPT OF HOUSING WEATHERIZATION GOEP DOE ADM HSDX 7/1/2019 6/30/2020 CDWTHRDOEA 51,592 29,676 22,885 (6,791) 18,982 3,903 Grant Source AZ DEPT OF HOUSING WEATHERIZATION GOEP DOE PRG HSDX 7/1/2019 6/30/2020 CDWTHRDOEP 409,621 263,079 407,221 144,142 407,221 - Grant Source AZ DEPT OF HOUSING WEATHERIZATION GOEP DOE TRN HSDX 7/1/2019 6/30/2020 CDWTHRDOET 28,766 24,848 5,712 (19,136) 5,712 - Grant Source AZ DEPT OF HOUSING WEATHERIZATION LIHEAP ADM HSDX 7/1/2019 6/30/2020 CDWTHRLA 46,975 53,419 46,975 (6,444) 46,975 - Grant Source AZ DEPT OF HOUSING WEATHERIZATION LIHEAP WX HSDX 7/1/2019 6/30/2020 CDWTHRLP 963,552 909,651 834,843 (74,808) 821,725 13,118 Grant Source AZ DEPT OF HOUSING WEATHERIZATION SWG WX HSDX 7/1/2019 6/30/2020 CDWTHRSG 147,572 36,713 107,749 71,036 107,749 - Grant Source AZ DEPT OF HOUSING WEATHERIZATION SWG ADM HSDX 7/1/2019 6/30/2020 CDWTHRSGA 14,667 3,671 6,577 2,906 5,423 1,154 Grant Source HSCDES HSDX 7/1/2019 6/30/2020 22DESWXHSC 50,000 - 50,000 50,000 50,000 - Grant Source TRSRPM HSDX 7/1/2019 6/30/2020 CDSRPTRBL 50,430 - 50,430 50,430 50,430 - Grant Source HCDUN HSDX 7/1/2019 6/30/2020 22CDNSPUNR 2,325 - 2,325 2,325 2,325 - Grant Source HRANSP HSDX 7/1/2019 6/30/2020 NSPPROFUND 3,715 - 3,715 3,715 3,715 - TOTAL GRANT REVENUE 55,597,313 44,125,089 47,524,377 3,399,288 43,382,711 4,141,666