AGENDA ATTACHMENT FY19 CIP RECONCILIATION.PDF

FY 2019 Reconciliation Agenda
FY 2018 Actuals/Forecast New FY 2019
Department Fund Appropriation Name FY 2018 Revised Forecast FY 2018 Actuals Variance FY 2019 Revised Revised Variance
Capital Project Reconciliation
D470 422 VMTN Vulture Mountain 108,091 16,742 - (16,742) 93,292 109,806 16,514
D470 440 RDIO Radio System 31,973,536 11,720,243 13,836,972 2,116,729 28,090,378 25,973,650 (2,116,728)
D470 445 ACED Animal Care Expansion Durango 2,500,000 92,000 308,079 216,079 4,408,000 4,191,921 (216,079)
D470 445 APBL Adult Probation Black Canyon 2,900,436 741,374 991,530 250,156 2,516,062 2,265,906 (250,156)
D470 445 APSP Adult Probation Southport 2,907,836 74,650 113,264 38,614 3,331,186 3,292,573 (38,613)
D470 445 ECIM East Court Improvements 6,494,592 3,527,266 4,269,500 742,234 1,467,326 725,093 (742,233)
D470 445 MRTS Maricopa Regional Trail System 492,352 281,314 272,263 (9,051) 396,038 405,091 9,053
D470 445 PHA1 Hassayampa 848,360 848,360 724,624 (123,736) 264,000 387,741 123,741
D470 445 PLBF Lake Boundary Fencing 638,400 170,000 182,989 12,989 468,400 455,411 (12,989)
D470 445 PPDC Lake Playground at Discovery Center 600,000 2,612 (2,612) 597,388 600,000 2,612
D470 445 PR4P McDowell Restroom at Four Peaks 550,000 32,749 40,650 7,901 517,251 509,350 (7,901)
D470 445 VMTN Vulture Mountain 196,861 114,847 137,945 23,098 82,014 58,914 (23,100)
D470 455 ITRJ Intake Transfer Release Jail 82,291,000 32,000,000 59,578,969 27,578,969 101,174,542 90,000,000 (11,174,542)
D470 460 TIR2 Infrastructure Refresh Ph II 6,189,587 829,953 1,927,562 1,097,609 5,359,634 4,262,031 (1,097,603)
Total CIP Variance (15,528,024)
Department Non Recurring Reconciliation
D060 100 SHC1 SIRE Hyland Conversion 213,619 50,000 24,548 (25,452) 163,619 189,071 25,452
D160 100 RFR1 COSC RFR System Replacement 1,615,490 1,327,490 1,145,984 (181,506) 288,000 469,506 181,506
D220 100 NRNP Non Recurring Non Project 325,643 130,035 85,876 (44,159) 195,608 239,767 44,159
D290 100 CME1 OME Case Management 386,831 - 96,000 96,000 386,831 290,831 (96,000)
D290 100 CRS1 OME Case Records 85,453 20,677 23,414 2,737 64,776 62,039 (2,737)
D300 100 NRNP Non Recurring Non Project 50,000 10,000 - (10,000) 30,000 40,000 10,000
D300 100 PKRR Park Restrooms Upgrades 50,000 50,000 - (50,000) 10,000 60,000 50,000
D410 100 CYB1 Cyber Security Non Recurring 1,766,841 1,534,707 1,555,886 21,179 597,836 576,657 (21,179)
D410 100 CYBS Cyber Security Major Maintenance 226,968 36,863 71,728 34,865 349,105 314,240 (34,865)
D410 100 DLRP Desktop Laptop Replacement 132,440 27,416 44,565 17,149 105,024 87,875 (17,149)
D410 100 EDCS Enterprise Data Center Systems 673,465 525,542 526,578 1,036 2,434,004 2,432,959 (1,045)
D410 100 EDNK Enterprise Data Networking 6,491,318 1,556,365 3,944,347 2,387,982 11,363,844 8,975,871 (2,387,973)
D410 100 MAD1 Microsfot Active Directory 3,000,000 1,933,071 1,932,814 (257) 1,066,929 1,067,186 257
D470 100 MEL1 Melendres Non Recurring 2,439,588 1,475,000 907,304 (567,696) 964,588 1,532,284 567,696
D560 100 PCR1 Capital Post Conviction Relief Backlog 1,310,327 1,245,615 1,033,331 (212,284) 2,521,921 2,734,205 212,284
D700 100 ELV1 Elevator Renovations 3,500,000 500,000 848,538 348,538 3,000,000 2,651,462 (348,538)
D700 100 NRNP Non Recurring Non Project 21,723 13,191 4,371 (8,820) 8,532 17,352 8,820
D950 100 NRNP Non Recurring Non Project 454,100 80,056 40,721 (39,335) 374,044 413,379 39,335
Fund 100 Subtotal (1,769,977)
D260 255 IRN1 Iron Mountain Records Project 92,455 30,969 33,521 2,552 63,123 60,571 (3,542)
D260 255 NRNP Non Recurring Non Project 382,500 36,331 36,331 314,000 346,169 32,169
D470 255 GRV1 Graves Non Recurring 293,175 213,000 232,003 19,003 80,175 61,172 (19,003)
Fund 255 Subtotal 9,624
D470 210 NRNP Non Recurring Non Project 500,440 46,539 27,039 (19,500) 534,236 554,561 20,325
D790 574 NRNP Non Recurring Non Project 150,000 60,000 73,929 13,929 500,000 486,071 (13,929)
D410 681 NRNP Non Recurring Non Project 846,234 655,651 682,192 26,541 190,583 164,042 (26,541)
Special Revenue Funds Subtotal (20,145)
Total Non Recurring Variance (1,780,498)
Total CIP and Non Recurring Variance (17,308,522)
Pay for Performance
FY 2019 FY 2020 Baseline
Department Name Fund Appropriation Unit Group Adjustment Adjustment
D050 District 5 100 OPER (6,790) (19)
D470 Non Departmenal 100 OPER 6,790 19
Total General Fund - -
S:\Budget Administration\FY 2018-19\CIP Rec\Agenda Attachment FY19 CIP Reconciliation