FY2017 CIP & 1X REVISED BUDGET RECON.PDF

Prepared by OMB FY 2016 Reconciliation Agenda 10:32 AM
10/21/2016
Total Project Prior Actuals FY 2016 FY 2016 Prep Actuals/Forecast FY 2017 FY 2017
Department Fund Name Budget Through FY 2015 Actuals Forecast Variance Adopted Revised Comment
Capital Project Reconciliation
470 422 VULTURE MOUNTAIN 179,301 50,001 5,465 6,000 535 123,300 123,835 FY 2016 Actual spending was less than Forecast.
Fund 422 Subtotal 535
470 445 CHAMBERS BUILDING REMODEL 3,952,196 36,591 2,124,175 2,324,818 200,643 1,590,787 1,791,430 FY 2016 Actual spending was less than Forecast and FY17 Increase to include Phase 3 Warehouse
470 445 EAST COURT IMPROVEMENTS 19,405,366 9,760,695 3,497,242 2,644,671 (852,571) 7,000,000 6,147,429 FY 2016 Actual spending exceeded Forecast and FY17 increase to include 9th Floor.
470 445 MARICOPA REGIONAL TRAIL SYSTEM 5,000,000 3,626,930 452,630 496,586 43,956 532,889 576,845 FY 2016 Actual spending was less than Forecast.
470 445 SHERIFF HEADQUARTERS 33,111,464 32,647,131 86,380 12,185 (74,195) 452,148 377,953 FY 2016 Actual spending exceeded Forecast.
470 445 WEST COURT IMPROVEMENTS 944,182 - 550,618 559,182 8,564 385,000 393,564 FY 2016 Actual spending was less than Forecast.
Fund 445 Subtotal (673,603)
470 455 INTAKE TRANSFER RELEASE JAIL 185,000,000 - 5,825,459 4,000,000 (1,825,459) 31,000,000 29,174,541 FY 2016 Actual spending exceeded Forecast.
Fund 455 Subtotal (1,825,459)
470 460 BIX ROOM BYTE INFO EXCHANGE 4,499,456 430,743 2,914,183 1,283,438 (1,630,745) 2,785,275 1,154,530 FY 2016 Actual spending exceeded Forecast.
470 460 TREASURER TECHNOLOGY SYSTEM UPG 35,587,600 803,102 2,636,174 3,760,583 1,124,409 18,751,162 19,875,571 FY 2016 Actual spending was less than Forecast.
Fund 460 Subtotal (506,336)
470 461 CHS ELECTRONIC HEALTH RECORDS 8,238,801 5,643,415 534,799 1,707,859 1,173,060 887,527 2,060,587 FY 2016 Actual spending was less than Forecast.
Fund 461 Subtotal 1,173,060
470 445/440 SOUTHWEST JUSTICE COURTS 30,620,246 1,969,704 6,941,628 7,500,000 558,372 21,150,541 21,708,913 FY 2016 Actual spending was less than Forecast.
470 460/440 INFRASTRUCTURE REFRESH PHASE 2 60,180,257 50,210,291 7,452,586 5,411,192 (2,041,394) 4,558,781 2,517,387 FY 2016 Actual spending exceeded Forecast.
470 460/440 INFRASTRUCTURE REFRESH PHASE 1 12,259,411 10,885,826 1,040,883 1,300,000 259,117 73,586 332,703 FY 2016 Actual spending was less than Forecast.
470 460/440 COMPUTER AIDED MASS APPRAISAL 24,887,725 4,088,070 5,968,446 5,923,921 (44,525) 7,677,886 7,633,361 FY 2016 Actual spending exceeded Forecast.
470 460/440 ENTERPRISE DATA CTNR CT 45,337,528 37,188,498 5,365,263 3,165,783 (2,199,480) 4,983,247 2,783,767 FY 2016 Actual spending exceeded Forecast.
470 460/440 COUNTY TELEPHONE SYSTEM 29,086,200 18,237,882 8,676,127 5,455,993 (3,220,134) 5,392,330 2,172,196 FY 2016 Actual spending exceeded Forecast.
470 460/440 ENTERPRISE RES PLANNING SYSTEM 28,491,860 11,506,787 10,732,685 10,531,317 (201,368) 6,453,753 6,252,385 FY 2016 Actual spending exceeded Forecast.
470 460/440 PUBLIC SAFETY RADIO 131,351,230 45,980,986 32,856,155 26,045,818 (6,810,337) 35,241,579 28,431,242 FY 2016 Actual spending exceeded Forecast.
470 460/440 JAIL KITCHEN EQUIPMENT 300,000 - 162,121 - (162,121) 300,000 137,879 FY 2016 Actual spending exceeded Forecast.
470 461/440 JAIL MGMT INFORMATION SYSTEM 25,117,938 1,800,619 2,369,427 4,520,745 2,151,318 8,893,241 11,044,559 FY 2016 Actual spending was less than Forecast
470 461/440 JAIL SECURITY SYSTEM UPGRADE 30,700,006 26,359,558 1,764,659 1,677,198 (87,461) 2,663,250 2,575,789 FY 2016 Actual spending exceeded Forecast.
Fund 440 Subtotal (11,798,013)
Total CIP Variance (13,629,816)
Department Non Recurring Reconciliation
160 100 RfR System 2,395,940 - 721,186 650,000 (71,186) 1,565,727 1,494,541 FY 2016 Actual spending exceeded Forecast.
300 100 Parks Restroom Upgrades 350,000 - 79,081 42,000 (37,081) 350,000 312,919 FY 2016 Actual spending exceeded Forecast.
310 100 Job Analysis Consultant Project 385,000 - 151,253 150,770 (483) 202,910 202,427 FY 2016 Actual spending exceeded Forecast.
410 100 Advantage 2X Hosting Charges 1,153,944 - 872,356 873,944 1,588 280,000 281,588 FY 2016 Actual spending was less than Forecast.
410 100 Cyber Security - eDiscovery 3,585,000 - 3,425,367 2,150,239 (1,275,128) 2,116,703 841,575 FY 2016 Actual spending exceeded Forecast.
410 100 Cyber Security Major Maint 185,149 - 184,472 185,149 677 259,000 259,677 FY 2016 Actual spending was less than Forecast.
410 100 Desktop Laptop Replacement 956,073 - 686,364 844,192 157,828 100,000 257,828 FY 2016 Actual spending was less than Forecast.
410 100 Enterprise Data Center 4,606,700 - 2,984,626 1,715,799 (1,268,827) 2,797,017 1,528,190 FY 2016 Actual spending exceeded Forecast.
560 100 Capital Post Conviction Relief 3,652,470 - 1,624,609 1,517,897 (106,712) 2,828,092 2,721,380 FY 2016 Actual spending exceeded Forecast.
Fund 100 Subtotal (2,599,324)
470 210 Waste Management Fund 654,183 - 53,456 42,411 (9,130) 688,762 679,632 Received additional $1,917 in revenues.
Waste Management Fund District 1 - - - - 383 99,968 100,351 $383 additional
Waste Management Fund District 2 - - 10,529 10,529 383 186,508 186,891 $383 additional
Waste Management Fund District 3 - - 25,295 15,000 (9,912) 240,872 230,960 $383 additional
Waste Management Fund District 4 - - 5,000 5,000 383 121,010 121,393 $383 additional
Waste Management Fund District 5 - - 12,632 11,882 (367) 40,404 40,037 $383 additional
Fund 210 Subtotal (9,130)
190 213 RICO 250,000 - - 250,000 250,000 - 250,000 FY 2016 Actual spending was less than Forecast.
Fund 213 Subtotal 250,000
500 214 Sheriff's Jail Enhancement Fund 786,498 - 541,879 786,498 244,619 450,000 694,619 FY 2016 Actual spending was less than Forecast.
Fund 214 Subtotal 244,619
860 265 Public Health Fee Fund Non Project - - - - 61,616 510,592 572,208 FY 2016 Actual spending was less than Forecast.
Fund 265 Subtotal 61,616
Non F100 Subtotal 547,105
Total Non Recurring Variance (2,052,219)
Total CIP and Non Recurring Variance (15,682,035)
S:\Projects\CIP-MM\Harold - CIP Budget Maintenance\FY 2017\Building FY2017 CIP Revised Budget