FY 2018 TENTATIVE PACKET COUNTY.PDF
Extracted text (via pymupdf_layout)
68087 characters
Maricopa County FY 2018 Tentative Budget Table of Contents Motion 3 Executive Summary 4 Consolidated Sources, Uses and Fund Balance by Fund Type 5 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group 7 Capital Improvement Program 25 Auditor General Forms Summary 27 Auditor General Forms – Schedule G 28 2 Motion Tentative Budget Adoption 1) Pursuant to A.R.S. §§ 42-17101 and 42-17102, approve the Fiscal Year 2018 Maricopa County Tentative Budget in the amount of $2,494,333,805 by total appropriation, for each department, fund and appropriation unit group listed in the attached schedules; also adopt the Five Year Capital Improvement Plan for Fiscal Years 2018-2022. 2) Approve the attached Executive Summary. 3 Executive Summary Notwithstanding the Budgeting and Accountability Policy, approve the following: a) Adult Probation, Juvenile Probation and Superior Court are collectively known as the Judicial Branch, and considered as one appropriation. Any and all appropriations within the Judicial Branch can be transferred between any and all Judicial Branch departments by fund and appropriation unit group, as requested and approved by the Presiding Judge of the Superior Court, without any further Board approval. b) Contract Counsel, Legal Advocate, Legal Defender, Public Advocate and Public Defender are known as the Public Defense System, and are considered as one appropriation. Any and all appropriations within the Public Defense System can be transferred between any and all Public Defense System departments by fund and appropriation unit group, as requested and approved by the County Manager, without any further Board approval. c) The budgets for Operating Major Maintenance Projects will be appropriated at the department, fund and appropriation unit category rather than department, fund and appropriation unit group. d) The Facilities Management Department is authorized to transfer unused Operating Major Maintenance funding to the reserve in the Capital Improvement Program. e) Authorize the Budget Office to review the change in participation in the DROP program and make necessary adjustments to the Maricopa County Sheriff’s department budget on a quarterly basis. Pursuant to A.R.S. §11-275, the Board of Supervisors authorizes the transfer of any monies received in the General Obligation - Debt Service Fund (312) to be reported in the General Fund (100). 4 Consolidated Sources, Uses and Fund Balance by Fund Type Special Debt Capital Internal General Fund Revenue Funds Service Funds Project Funds Service Funds Subtotal Eliminations Total Beginning Fund Balance $ 134,647,118 $ 162,468,255 $ 25,800,329 $ 831,077,868 $ 29,040,951 $ 1,183,034,521 $ - $ 1,183,034,521 Sources of Funds Operating 6010 Property Tax $ 531,047,908 $ - $ - $ - $ - $ 531,047,908 $ - $ 531,047,908 6050 Tax Penalties & Interest 7,519,586 - - - - 7,519,586 - 7,519,586 6060 Sales Tax - 158,237,746 - - - 158,237,746 - 158,237,746 6100 censes & Permits 1,342,771 41,751,645 - - - 43,094,416 - 43,094,416 6150 Grants - 131,231,765 - - - 131,231,765 - 131,231,765 6151 Grants - State - 22,550,647 - - - 22,550,647 - 22,550,647 6152 Grants - Other - 8,921,410 - - - 8,921,410 - 8,921,410 6200 Intergovernmental 92,999 1,976,167 - - - 2,069,166 - 2,069,166 6201 Intergovernmental - State 50,000 8,712,602 - - - 8,762,602 - 8,762,602 6202 Intergovernmental - Other 249,287 5,215,609 - - - 5,464,896 - 5,464,896 6210 PILT 10,622,182 - - - - 10,622,182 - 10,622,182 6211 PILT - Federal 3,011,264 - - - - 3,011,264 - 3,011,264 6212 PILT - City GPLET 356,448 - - - - 356,448 - 356,448 6250 State Shared Sales Tax 533,940,557 - - - - 533,940,557 - 533,940,557 6260 State Shared Highway User Revenue - 111,917,883 - - - 111,917,883 - 111,917,883 6300 State Shared Vehicle License 156,707,940 11,103,437 - - - 167,811,377 - 167,811,377 6340 Intergov Charges For Services 3,154,774 1,276,827 - - - 4,431,601 - 4,431,601 6341 Intergov Charges For Services - State 328,257 3,511,091 - - - 3,839,348 - 3,839,348 6342 Intergov Charges For Services - District 560,425 32,002 - - 1,815,889 2,408,316 - 2,408,316 6343 Intergov Charges For Services - Other 17,269,953 29,020,530 - - 2,336,234 48,626,717 - 48,626,717 6350 Charges For Services 17,123,376 24,635,490 - - - 41,758,866 - 41,758,866 6351 Insurance Charges For Services - - - - 31,562,867 31,562,867 - 31,562,867 6352 Other Charges For Services 9,945,209 49,843,432 - - (1,149,205) 58,639,436 - 58,639,436 6360 Internal Service FundCharges - - - - 204,966,835 204,966,835 (204,966,835) - 6370 Fines And Forfeits 10,746,561 14,277,582 - - - 25,024,143 - 25,024,143 6380 Patient Services Revenue 6,988 2,772,209 - - - 2,779,197 - 2,779,197 6450 Interest Income 2,400,000 870,726 - - 260,196 3,530,922 - 3,530,922 6500 Miscellaneous 1,902,142 4,245,858 - - 433,000 6,581,000 - 6,581,000 6502 Sale of Asset 296 - - - - 296 - 296 6503 Unclaimed/Abandoned Property 1,170 - - - - 1,170 - 1,170 6504 Donations/Contributions - 1,179,737 - - - 1,179,737 - 1,179,737 6505 Other Miscellaneous 564,702 446,621 - - - 1,011,323 - 1,011,323 6510 Gain On Fixed Assets - 250,000 - - - 250,000 - 250,000 6800 Transfers In - 214,071,670 19,959,846 21,183,032 - 255,214,548 (255,214,548) - Total Operating Sources $ 1,308,944,795 $ 848,052,686 $ 19,959,846 $ 21,183,032 $ 240,225,816 $ 2,438,366,175 $ (460,181,383) $ 1,978,184,792 Non Recurring 6150 Grants $ - $ 757,973 $ - $ 11,520,765 $ - $ 12,278,738 $ - $ 12,278,738 6151 Grants - State - 703,857 - - - 703,857 - 703,857 6152 Grants - Other - 200,000 - - - 200,000 - 200,000 6201 Intergov - State 4,777,300 - - - - 4,777,300 - 4,777,300 6340 Intergov Charges For Services - - - 9,735,564 - 9,735,564 - 9,735,564 6342 Intergov Charges For Services - District 8,007 - - - - 8,007 - 8,007 6343 Intergov Charges For Services - Other - - - - - - - - 6352 Other Charges For Services - 34,319 - - - 34,319 - 34,319 6450 Interest Income - 750,000 - 200 - 750,200 - 750,200 6500 Miscellaneous - 6,715,000 - - - 6,715,000 - 6,715,000 6502 Sale of Asset - - - - - - - - 6520 Proceeds From Financing - - - 116,765,000 - 116,765,000 - 116,765,000 6800 Transfers In 10,309,311 - 104,806,843 252,733,626 5,223,616 373,073,396 (373,073,396) - Total Non Recurring Sources $ 15,094,618 $ 9,161,149 $ 104,806,843 $ 390,755,155 $ 5,223,616 $ 525,041,381 $ (373,073,396) $ 151,967,985 Total Sources $ 1,324,039,413 $ 857,213,835 $ 124,766,689 $ 411,938,187 $ 245,449,432 $ 2,963,407,556 $ (833,254,779) $ 2,130,152,777 5 Consolidated Sources, Uses and Fund Balance by Fund Type (continued) Special Debt Capital Internal General Fund Revenue Funds Service Funds Project Funds Service Funds Subtotal Eliminations Total Uses of Funds Operating Personnel $ 577,173,997 $ 521,242,200 $ - $ - $ 15,730,480 $ 1,114,146,677 $ - $ 1,114,146,677 Supplies 13,545,253 45,030,351 - - 11,454,146 70,029,750 (4,972,694) 65,057,056 Services 459,411,452 216,708,452 - - 221,205,039 897,324,943 (199,994,141) 697,330,802 Capital 5,400,322 6,783,455 18,399,600 - 40,000 30,623,377 - 30,623,377 Transfers Out 253,413,771 1,800,777 - - - 255,214,548 (255,214,548) - Total Operating Uses $ 1,308,944,795 $ 791,565,235 $ 18,399,600 $ - $ 248,429,665 $ 2,367,339,295 $ (460,181,383) $ 1,907,157,912 Non Recurring Personnel $ 11,967,084 $ 3,359,674 $ - $ 4,328,773 $ 175,321 $ 19,830,852 $ - $ 19,830,852 Supplies 830,879 2,771,568 - 270,769 527,888 4,401,104 - 4,401,104 Services 47,379,547 24,743,671 - 11,764,260 366,225 84,253,703 - 84,253,703 Capital 9,984,284 7,861,330 113,019,825 346,998,495 826,300 478,690,234 - 478,690,234 Transfers Out 79,579,942 75,550,537 176,138 217,766,779 - 373,073,396 (373,073,396) - Total Non Recurring Uses $ 149,741,736 $ 114,286,780 $ 113,195,963 $ 581,129,076 $ 1,895,734 $ 960,249,289 $ (373,073,396) $ 587,175,893 - - Total Uses $ 1,458,686,531 $ 905,852,015 $ 131,595,563 $ 581,129,076 $ 250,325,399 $ 3,327,588,584 $ (833,254,779) $ 2,494,333,805 Structural Balance $ - $ 56,487,451 $ 1,560,246 $ 21,183,032 $ (8,203,849) $ 71,026,880 $ - $ 71,026,880 Ending Fund Balance $ - $ 113,830,075 $ 18,971,455 $ 661,886,979 $ 24,164,984 $ 818,853,493 $ - $ 818,853,493 Restricted $ - $ 97,328,632 $ 18,971,455 $ 200,895,981 $ 25,309,427 $ 342,505,495 $ - $ 342,505,495 Committed $ - $ 18,858,953 $ - $ 460,990,998 $ 2,860,950 $ 482,710,901 $ - $ 482,710,901 Unassigned $ - $ (2,357,510) $ - $ - $ (4,005,393) $ (6,362,903) $ - $ (6,362,903) 6 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm JUDICIAL D110 ADULT PROBATION 100 GENERAL Non Recurring Non Project $ 54,000 $ 54,000 $ 54,000 $ - Operating 50,970,130 52,087,521 52,581,986 494,465 All Appropriations $ 51,024,130 $ 52,141,521 $ 52,635,986 $ 494,465 201 ADULT PROBATION FEES Non Recurring Non Project $ 820,000 $ 820,000 $ 800,000 $ (20,000) Operating 12,743,611 12,743,611 12,672,199 (71,412) All Appropriations $ 13,563,611 $ 13,563,611 $ 13,472,199 $ (91,412) 211 ADULT PROBATION GRANTS Operating $ 2,807,783 $ 2,924,101 $ 2,512,292 $ (411,809) All Appropriations $ 2,807,783 $ 2,924,101 $ 2,512,292 $ (411,809) 255 DETENTION OPERATIONS Non Recurring Non Project $ 27,000 $ 27,000 $ 162,000 $ 135,000 Operating 34,545,666 35,088,861 37,123,124 2,034,263 All Appropriations $ 34,572,666 $ 35,115,861 $ 37,285,124 $ 2,169,263 D110 Total $ 101,968,190 $ 103,745,094 $ 105,905,601 $ 2,160,507 D240 JUSTICE COURTS 100 GENERAL Non Recurring Non Project $ 500,327 $ 500,327 $ - $ (500,327) Operating 17,812,231 18,124,108 18,252,388 128,280 All Appropriations $ 18,312,558 $ 18,624,435 $ 18,252,388 $ (372,047) 204 JUSTICE COURT JUDICIAL ENHANCEMENT Operating $ 737,183 $ 737,183 $ 737,183 $ - All Appropriations $ 737,183 $ 737,183 $ 737,183 $ - 237 JUSTICE COURTS PHOTO ENFORCEMENT Non Recurring Non Project $ 9,000 $ 9,000 $ - $ (9,000) All Appropriations $ 9,000 $ 9,000 $ - $ (9,000) 245 JUSTICE COURTS SPECIAL REVENUE Non Recurring Non Project $ 100,000 $ 100,000 $ - $ (100,000) Operating 6,664,653 6,664,653 6,798,886 134,233 All Appropriations 6,764,653 6,764,653 6,798,886 34,233 D240 Total $ 25,823,394 $ 26,135,271 $ 25,788,457 $ (346,814) D270 JUVENILE PROBATION 100 GENERAL Operating $ 17,154,428 $ 17,569,012 $ 17,611,596 $ 42,584 All Appropriations $ 17,154,428 $ 17,569,012 $ 17,611,596 $ 42,584 227 JUVENILE PROBATION GRANTS Operating $ 3,811,356 $ 3,928,047 $ 4,113,768 $ 185,721 All Appropriations $ 3,811,356 $ 3,928,047 $ 4,113,768 $ 185,721 228 JUVENILE PROBATION SPECIAL FEE Non Recurring Non Project $ 410,888 $ 410,888 $ 257,078 $ (153,810) Operating 2,669,777 2,669,777 2,412,699 (257,078) All Appropriations $ 3,080,665 $ 3,080,665 $ 2,669,777 $ (410,888) 7 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm 229 JUVENILE RESTITUTION Non Recurring Non Project $ 6,007 $ 6,007 $ 6,000 $ (7) Operating 4,000 4,000 1,430 (2,570) All Appropriations $ 10,007 $ 10,007 $ 7,430 $ (2,577) 255 DETENTION OPERATIONS Operating $ 34,219,259 $ 34,674,620 $ 35,412,680 $ 738,060 All Appropriations $ 34,219,259 $ 34,674,620 $ 35,412,680 $ 738,060 275 JUVENILE PROBATION DIVERSION Non Recurring Non Project $ 174,502 $ 174,502 $ 203,265 $ 28,763 Operating 214,095 214,095 180,000 (34,095) All Appropriations $ 388,597 $ 388,597 $ 383,265 $ (5,332) D270 Total $ 58,664,312 $ 59,650,948 $ 60,198,516 $ 547,568 D800 SUPERIOR COURT 100 GENERAL Disaster Rec Equipment $ 337,000 $ 337,000 $ - $ (337,000) Disaster Rec Equip Oper 97,933 97,933 100,621 2,688 Non Recurring Non Project 3,000 3,000 178,434 175,434 Operating 81,854,793 82,875,654 83,933,310 1,057,656 Sup Court Case Mgmt System 1,899,500 1,899,500 1,700,000 (199,500) Sup Ct For The Record Equip 1,500,000 1,500,000 - (1,500,000) All Appropriations $ 85,692,226 $ 86,713,087 $ 85,912,365 $ (800,722) 208 JUDICIAL ENHANCEMENT Operating $ 499,000 $ 499,000 $ 499,000 $ - All Appropriations $ 499,000 $ 499,000 $ 499,000 $ - 238 SUPERIOR COURT GRANTS Operating $ 3,432,507 $ 5,159,653 $ 4,082,087 $ (1,077,566) All Appropriations $ 3,432,507 $ 5,159,653 $ 4,082,087 $ (1,077,566) 256 PROBATE FEES Non Recurring Non Project $ 50,000 $ 50,000 $ 75,000 $ 25,000 Operating 392,000 392,000 392,000 - All Appropriations $ 442,000 $ 442,000 $ 467,000 $ 25,000 257 CONCILIATION COURT FEES Operating $ 1,583,362 $ 1,583,362 $ 1,583,362 $ - All Appropriations $ 1,583,362 $ 1,583,362 $ 1,583,362 $ - 259 SUPERIOR COURT SPECIAL REVENUE Non Recurring Non Project $ 246,371 $ 246,371 $ 240,000 $ (6,371) Operating 4,881,783 4,881,783 4,932,280 50,497 All Appropriations $ 5,128,154 $ 5,128,154 $ 5,172,280 $ 44,126 261 LAW LIBRARY FEES Non Recurring Non Project $ - $ 225,000 $ - $ (225,000) Operating 1,165,971 1,165,971 1,225,447 59,476 All Appropriations $ 1,165,971 $ 1,390,971 $ 1,225,447 $ (165,524) 264 SUPERIOR COURT FILL THE GAP Non Recurring Non Project $ - $ 30,755 $ - $ (30,755) Operating 2,202,900 2,009,415 2,202,900 193,485 All Appropriations $ 2,202,900 $ 2,040,170 $ 2,202,900 $ 162,730 8 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm 271 EXPEDITED CHILD SUPPORT Non Recurring Non Project $ - $ - $ 40,000 $ 40,000 Operating 677,500 677,500 637,500 (40,000) All Appropriations $ 677,500 $ 677,500 $ 677,500 $ - 276 SPOUSAL MAINT ENFORCEMENT ENHANCEMENT Operating $ 108,000 $ 108,000 $ 108,000 $ - All Appropriations $ 108,000 $ 108,000 $ 108,000 $ - 280 SUPERIOR COURT BUILDING REPAIR Non Recurring Non Project $ 1,650,474 $ 2,406,412 $ 195,000 $ (2,211,412) All Appropriations $ 1,650,474 $ 2,406,412 $ 195,000 $ (2,211,412) 282 DOMESTIC RELATIONS MEDIATION EDUCATION Operating $ 200,600 $ 200,600 $ 193,550 $ (7,050) All Appropriations $ 200,600 $ 200,600 $ 193,550 $ (7,050) D800 Total $ 102,782,694 $ 106,348,909 $ 102,318,491 $ (4,030,418) Total Judicial $ 289,238,590 $ 295,880,222 $ 294,211,065 $ (1,669,157) ELECTED D010 BOARD OF SUPERVISORS DIST 1 100 GENERAL Operating $ 376,999 $ 382,871 $ 383,892 $ 1,021 All Appropriations $ 376,999 $ 382,871 $ 383,892 $ 1,021 D010 Total $ 376,999 $ 382,871 $ 383,892 $ 1,021 D020 BOARD OF SUPERVISORS DIST 2 100 GENERAL Operating $ 376,999 $ 382,871 $ 383,892 $ 1,021 All Appropriations $ 376,999 $ 382,871 $ 383,892 $ 1,021 D020 Total $ 376,999 $ 382,871 $ 383,892 $ 1,021 D030 BOARD OF SUPERVISORS DIST 3 100 GENERAL Operating $ 376,999 $ 382,871 $ 383,892 $ 1,021 All Appropriations $ 376,999 $ 382,871 $ 383,892 $ 1,021 D030 Total $ 376,999 $ 382,871 $ 383,892 $ 1,021 D040 BOARD OF SUPERVISORS DIST 4 100 GENERAL Operating $ 376,999 $ 382,871 $ 383,892 $ 1,021 All Appropriations $ 376,999 $ 382,871 $ 383,892 $ 1,021 D040 Total $ 376,999 $ 382,871 $ 383,892 $ 1,021 D050 BOARD OF SUPERVISORS DIST 5 100 GENERAL Operating $ 376,999 $ 382,871 $ 383,892 $ 1,021 All Appropriations $ 376,999 $ 382,871 $ 383,892 $ 1,021 D050 Total $ 376,999 $ 382,871 $ 383,892 $ 1,021 9 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm D120 ASSESSOR 100 GENERAL Legal Class Verification $ - $ - $ 191,000 $ 191,000 Operating 24,026,441 24,404,617 24,413,445 8,828 All Appropriations $ 24,026,441 $ 24,404,617 $ 24,604,445 $ 199,828 D120 Total $ 24,026,441 $ 24,404,617 $ 24,604,445 $ 199,828 D140 CALL CENTER 100 GENERAL Operating $ 1,719,187 $ 1,745,152 $ 1,952,439 $ 207,287 All Appropriations $ 1,719,187 $ 1,745,152 $ 1,952,439 $ 207,287 D140 Total $ 1,719,187 $ 1,745,152 $ 1,952,439 $ 207,287 D160 CLERK OF THE SUPERIOR COURT 100 GENERAL COSC RFR System Replacement $ 1,565,727 $ 1,494,541 $ 1,600,000 $ 105,459 Operating 33,626,550 34,131,403 34,268,865 137,462 All Appropriations $ 35,192,277 $ 35,625,944 $ 35,868,865 $ 242,921 205 COURT DOCUMENT RETRIEVAL Non Recurring Non Project $ 159,993 $ 159,993 $ - $ (159,993) Operating 1,034,000 1,034,000 1,053,207 19,207 All Appropriations $ 1,193,993 $ 1,193,993 $ 1,053,207 $ (140,786) 208 JUDICIAL ENHANCEMENT Non Recurring Non Project $ 602,000 $ 602,000 $ 1,350,000 $ 748,000 Operating 900,000 900,000 900,000 - All Appropriations $ 1,502,000 $ 1,502,000 $ 2,250,000 $ 748,000 216 CLERK OF THE COURT GRANTS Operating $ 1,446,855 $ 1,693,126 $ 1,442,472 $ (250,654) All Appropriations $ 1,446,855 $ 1,693,126 $ 1,442,472 $ (250,654) 218 CLERK OF COURT FILL THE GAP Non Recurring Non Project - $ 83,655 $ - $ (83,655) Operating 1,905,898 1,939,376 1,905,898 (33,478) All Appropriations $ 1,905,898 $ 2,023,031 $ 1,905,898 $ (117,133) 270 CHILD SUPPORT ENHANCEMENT Non Recurring Non Project $ 20,000 $ 20,000 $ 20,000 $ - All Appropriations $ 20,000 $ 20,000 $ 20,000 $ - 273 VICTIM LOCATION Non Recurring Non Project $ 15,000 $ 15,000 $ 49,000 $ 34,000 All Appropriations $ 15,000 $ 15,000 $ 49,000 $ 34,000 274 CLERK OF THE COURT EDMS Non Recurring Non Project $ - $ - $ 84,310 $ 84,310 Operating 2,500,000 2,500,000 2,570,690 70,690 All Appropriations $ 2,500,000 $ 2,500,000 $ 2,655,000 $ 155,000 D160 Total $ 43,776,023 $ 44,573,094 $ 45,244,442 $ 671,348 D190 COUNTY ATTORNEY 100 GENERAL Operating $ 87,639,468 $ 89,055,447 $ 88,685,407 $ (370,040) All Appropriations $ 87,639,468 $ 89,055,447 $ 88,685,407 $ (370,040) 10 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm 213 COUNTY ATTORNEY RICO Non Recurring Non Project $ - $ 250,000 $ - $ (250,000) Operating 1,879,086 1,879,086 2,185,173 306,087 All Appropriations $ 1,879,086 $ 2,129,086 $ 2,185,173 $ 56,087 219 COUNTY ATTORNEY GRANTS Non Recurring Non Project $ - $ 250,000 $ 124,437 $ (125,563) Operating 6,490,942 7,085,355 6,800,061 (285,294) All Appropriations $ 6,490,942 $ 7,335,355 $ 6,924,498 $ (410,857) 220 DIVERSION Non Recurring Non Project $ 758,656 $ 758,656 $ 767,057 $ 8,401 Operating 1,713,350 1,713,350 1,718,186 4,836 All Appropriations $ 2,472,006 $ 2,472,006 $ 2,485,243 $ 13,237 221 COUNTY ATTORNEY FILL THE GAP Operating $ 1,494,911 $ 1,494,911 $ 1,529,368 $ 34,457 All Appropriations $ 1,494,911 $ 1,494,911 $ 1,529,368 $ 34,457 266 CHECK ENFORCEMENT PROGRAM Non Recurring Non Project $ 53,038 $ 53,038 $ 70,746 $ 17,708 Operating 72,302 72,302 50,200 (22,102) All Appropriations $ 125,340 $ 125,340 $ 120,946 $ (4,394) 267 CRIMINAL JUSTICE ENHANCEMENT Non Recurring Non Project $ 262,633 $ 262,633 $ 253,386 $ (9,247) Operating 1,239,649 1,256,277 1,294,408 38,131 All Appropriations $ 1,502,282 $ 1,518,910 $ 1,547,794 $ 28,884 268 VICTIM COMPENSATION RESTITUTION Non Recurring Non Project $ - $ 418,833 $ - $ (418,833) Operating 164,759 164,759 199,800 35,041 All Appropriations $ 164,759 $ 583,592 $ 199,800 $ (383,792) 269 VICTIM COMPENSATION INTEREST Non Recurring Non Project $ - $ - $ 12,252 $ 12,252 Operating 19,756 19,756 10,500 (9,256) All Appropriations $ 19,756 $ 19,756 $ 22,752 $ 2,996 D190 Total $ 101,788,550 $ 104,734,403 $ 103,700,981 $ (1,033,422) D210 ELECTIONS 100 GENERAL Non Recurring Non Project $ 1,913,301 $ 1,913,301 $ - $ (1,913,301) Operating 9,164,929 9,229,301 6,740,707 (2,488,594) Pri Gen Elec Cycle Spending 12,104,659 12,354,659 - (12,354,659) All Appropriations $ 23,182,889 $ 23,497,261 $ 6,740,707 $ (16,756,554) 248 ELECTIONS GRANTS Operating $ 406,750 $ 406,750 $ - $ (406,750) All Appropriations $ 406,750 $ 406,750 $ - $ (406,750) D210 Total $ 23,589,639 $ 23,904,011 $ 6,740,707 $ (17,163,304) D250 CONSTABLES 100 GENERAL Non Recurring Non Project $ - $ 70,561 $ - $ (70,561) Operating 3,242,537 3,297,832 3,348,847 51,015 All Appropriations $ 3,242,537 $ 3,368,393 $ 3,348,847 $ (19,546) D250 Total $ 3,242,537 $ 3,368,393 $ 3,348,847 $ (19,546) 11 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm D360 RECORDER 100 GENERAL Non Recurring Non Project $ - $ - $ 88,523 $ 88,523 Operating 2,322,447 2,345,337 4,745,091 2,399,754 All Appropriations $ 2,322,447 $ 2,345,337 $ 4,833,614 $ 2,488,277 236 RECORDERS SURCHARGE Non Recurring Non Project $ 774,400 $ 774,400 $ 600,000 $ (174,400) Operating 3,792,689 3,792,689 3,740,646 (52,043) All Appropriations $ 4,567,089 $ 4,567,089 $ 4,340,646 $ (226,443) D360 Total $ 6,889,536 $ 6,912,426 $ 9,174,260 $ 2,261,834 D370 EDUCATION SERVICE 100 GENERAL Garnishment System Upgrade $ 260,000 $ 260,000 $ - $ (260,000) Operating 2,722,933 2,747,082 2,735,517 (11,565) All Appropriations $ 2,982,933 $ 3,007,082 $ 2,735,517 $ (271,565) 255 DETENTION OPERATIONS Non Recurring Non Project $ 679,906 $ 679,906 $ 252,858 $ (427,048) All Appropriations $ 679,906 $ 679,906 $ 252,858 $ (427,048) 669 SMALL SCHOOL SERVICE Operating $ 109,551 $ 109,551 $ 109,551 $ - All Appropriations $ 109,551 $ 109,551 $ 109,551 $ - 715 SCHOOL GRANTS Non Recurring Non Project $ - $ - $ 398,023 $ 398,023 Operating 24,494,498 24,501,039 33,198,027 8,696,988 All Appropriations $ 24,494,498 $ 24,501,039 $ 33,596,050 $ 9,095,011 780 SCHOOL TRANSPORTATION Operating $ 600,000 $ 600,000 $ 600,000 $ - All Appropriations $ 600,000 $ 600,000 $ 600,000 $ - 782 SCHOOL COMMUNICATION Non Recurring Non Project $ 582,065 $ 582,065 $ 712,666 $ 130,601 Operating 521,000 521,000 667,681 146,681 All Appropriations $ 1,103,065 $ 1,103,065 $ 1,380,347 $ 277,282 795 EDUCATIONAL SUPPLEMENTAL PROGRAM Non Recurring Non Project $ 310,510 $ 310,510 $ 374,059 $ 63,549 Operating 566,275 566,275 495,594 (70,681) All Appropriations $ 876,785 $ 876,785 $ 869,653 $ (7,132) D370 Total $ 30,846,738 $ 30,877,428 $ 39,543,976 $ 8,666,548 D430 TREASURER 100 GENERAL Non Recurring Non Project $ 35,000 $ 35,000 $ - $ (35,000) Operating 4,973,573 5,063,878 5,089,349 25,471 Treasurer Printing & Postage 899,140 899,140 899,140 - All Appropriations $ 5,907,713 $ 5,998,018 $ 5,988,489 $ (9,529) 741 TAXPAYER INFORMATION Operating $ 304,341 $ 304,341 $ 304,341 $ - All Appropriations $ 304,341 $ 304,341 $ 304,341 $ - D430 Total $ 6,212,054 $ 6,302,359 $ 6,292,830 $ (9,529) 12 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm D500 SHERIFF 100 GENERAL Compliance - Non Recurring $ - $ 1,739,363 $ - $ (1,739,363) Compliance - Operating 10,239,881 18,429,542 19,721,258 1,291,716 Non Recurring Non Project - 106,587 3,507,800 3,401,213 Operating 99,443,516 98,485,005 103,455,633 4,970,628 All Appropriations $ 109,683,397 $ 118,760,497 $ 126,684,691 $ 7,924,194 203 SHERIFF DONATIONS Non Recurring Non Project $ - $ - $ 250,000 $ 250,000 Operating 33,969 33,969 60,000 26,031 All Appropriations $ 33,969 $ 33,969 $ 310,000 $ 276,031 206 OFFICER SAFETY EQUIPMENT Non Recurring Non Project $ 300,000 $ 300,000 $ 250,000 $ (50,000) Operating 52,000 52,000 52,000 - All Appropriations $ 352,000 $ 352,000 $ 302,000 $ (50,000) 212 SHERIFF RICO Operating $ 1,750,000 $ 1,750,000 $ 1,750,000 $ - All Appropriations $ 1,750,000 $ 1,750,000 $ 1,750,000 $ - 214 SHERIFF JAIL ENHANCEMENT Non Recurring Non Project $ 450,000 $ 694,619 $ 2,000,000 $ 1,305,381 Operating 1,482,444 1,482,444 1,482,444 - All Appropriations $ 1,932,444 $ 2,177,063 $ 3,482,444 $ 1,305,381 251 SHERIFF GRANTS Operating $ 7,624,572 $ 7,624,572 $ 8,847,429 $ 1,222,857 All Appropriations $ 7,624,572 $ 7,624,572 $ 8,847,429 $ 1,222,857 252 INMATE SERVICES Non Recurring Non Project $ 6,750,000 $ 6,750,000 $ - $ (6,750,000) Operating 9,596,352 9,596,352 9,596,352 - All Appropriations $ 16,346,352 $ 16,346,352 $ 9,596,352 $ (6,750,000) 254 INMATE HEALTH SERVICES Non Recurring Non Project $ 106,620 $ 106,620 $ 215,938 $ 109,318 Operating 369,950 369,950 369,950 - All Appropriations $ 476,570 $ 476,570 $ 585,888 $ 109,318 255 DETENTION OPERATIONS Non Recurring Non Project $ - $ - $ 607,200 $ 607,200 Operating 218,619,446 216,679,824 221,617,877 4,938,053 All Appropriations $ 218,619,446 $ 216,679,824 $ 222,225,077 $ 5,545,253 258 SHERIFF TOWING AND IMPOUND Non Recurring Non Project $ 15,429 $ 15,429 $ 170,000 $ 154,571 Operating 211,100 211,100 186,746 (24,354) All Appropriations $ 226,529 $ 226,529 $ 356,746 $ 130,217 D500 Total $ 357,045,279 $ 364,427,376 $ 374,140,627 $ 9,713,251 Total Elected $ 601,020,979 $ 613,163,614 $ 616,663,014 $ 3,499,400 13 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm APPOINTED D060 CLERK OF THE BOARD 100 GENERAL Board of Equalization Expenses $ - $ - $ 130,000 $ 130,000 BOS Discretionary Charges - - 2,500 2,500 Operating 1,245,373 1,264,401 1,266,762 2,361 SIRE Hyland Conversion 213,619 213,619 213,619 - All Appropriations $ 1,458,992 $ 1,478,020 $ 1,612,881 $ 134,861 D060 Total $ 1,458,992 $ 1,478,020 $ 1,612,881 $ 134,861 D150 EMERGENCY MANAGEMENT 100 GENERAL Operating $ 253,651 $ 259,006 $ 2,913,470 $ 2,654,464 All Appropriations $ 253,651 $ 259,006 $ 2,913,470 $ 2,654,464 207 PALO VERDE Non Recurring Non Project $ 85,264 $ 85,264 $ 20,513 $ (64,751) Operating 706,722 706,722 704,721 (2,001) All Appropriations $ 791,986 $ 791,986 $ 725,234 $ (66,752) 215 EMERGENCY MANAGEMENT Non Recurring Non Project $ 67,162 $ 152,162 $ 89,677 $ (62,485) Operating 951,853 1,028,998 944,264 (84,734) All Appropriations $ 1,019,015 $ 1,181,160 $ 1,033,941 $ (147,219) 255 DETENTION OPERATIONS Operating $ - $ - $ 48,941 $ 48,941 All Appropriations $ - $ - $ 48,941 $ 48,941 D150 Total $ 2,064,652 $ 2,232,152 $ 4,721,586 $ 2,489,434 D180 FINANCE 100 GENERAL Operating $ 2,855,401 $ 2,906,344 $ 3,050,614 $ 144,270 Single Audit - - 225,000 225,000 All Appropriations $ 2,855,401 $ 2,906,344 $ 3,275,614 $ 369,270 D180 Total $ 2,855,401 $ 2,906,344 $ 3,275,614 $ 369,270 D200 COUNTY MANAGER 100 GENERAL Operating $ 2,648,433 $ 2,677,972 $ 4,313,025 $ 1,635,053 All Appropriations $ 2,648,433 $ 2,677,972 $ 4,313,025 $ 1,635,053 249 NON0DEPARTMENTAL GRANTS Non Recurring Non Project $ 326,455 $ 1,745,617 $ 200,000 $ (1,545,617) All Appropriations $ 326,455 $ 1,745,617 $ 200,000 $ (1,545,617) D200 Total $ 2,974,888 $ 4,423,589 $ 4,513,025 $ 89,436 D220 HUMAN SERVICES 100 GENERAL Non Recurring Non Project $ 122,796 $ 122,796 $ 325,643 $ 202,847 Operating 2,260,912 2,260,912 2,260,912 - All Appropriations $ 2,383,708 $ 2,383,708 $ 2,586,555 $ 202,847 217 CDBG HOUSING TRUST Operating $ 6,231,776 $ 6,231,776 $ 10,343,521 $ 4,111,745 All Appropriations $ 6,231,776 $ 6,231,776 $ 10,343,521 $ 4,111,745 14 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm 222 HUMAN SERVICES GRANTS Operating $ 51,497,289 $ 51,497,289 $ 40,842,630 $ (10,654,659) All Appropriations $ 51,497,289 $ 51,497,289 $ 40,842,630 $ (10,654,659) D220 Total $ 60,112,773 $ 60,112,773 $ 53,772,706 $ (6,340,067) D230 INTERNAL AUDIT 100 GENERAL Operating $ 1,888,018 $ 1,924,489 $ 1,928,016 $ 3,527 Outside Audit Firms - - 324,000 324,000 All Appropriations $ 1,888,018 $ 1,924,489 $ 2,252,016 $ 327,527 D230 Total $ 1,888,018 $ 1,924,489 $ 2,252,016 $ 327,527 D260 CORRECTIONAL HEALTH 100 GENERAL Operating $ 3,522,248 $ 3,542,152 $ 3,714,177 $ 172,025 All Appropriations $ 3,522,248 $ 3,542,152 $ 3,714,177 $ 172,025 255 DETENTION OPERATIONS CHS Graves Judgment Operating $ 3,780,639 $ 3,803,917 $ 3,803,917 $ - Iron Mountain Records Projects 112,473 112,473 69,690 (42,783) Operating 60,587,412 61,405,930 61,046,953 (358,977) All Appropriations $ 64,480,524 $ 65,322,320 $ 64,920,560 $ (401,760) 292 CORRECTIONAL HEALTH GRANTS Operating $ - $ - $ 348,944 $ 348,944 All Appropriations $ - $ - $ 348,944 $ 348,944 D260 Total $ 68,002,772 $ 68,864,472 $ 68,983,681 $ 119,209 D290 MEDICAL EXAMINER 100 GENERAL Non Recurring Non Project $ - $ - $ 100,000 $ 100,000 OME Case Management 232,800 232,800 139,680 (93,120) OME Case Records 131,509 131,509 - (131,509) Operating 10,033,874 10,323,582 11,370,831 1,047,249 All Appropriations $ 10,398,183 $ 10,687,891 $ 11,610,511 $ 922,620 224 MEDICAL EXAMINER GRANTS Operating $ 8,851 $ 19,488 $ 50,000 $ 30,512 All Appropriations $ 8,851 $ 19,488 $ 50,000 $ 30,512 D290 Total $ 10,407,034 $ 10,707,379 $ 11,660,511 $ 953,132 D300 PARKS AND RECREATION 100 GENERAL Non Recurring Non Project $ 50,000 $ 50,000 $ 50,000 $ - Operating 874,325 874,325 874,325 - Parks Restrooms Upgrades 350,000 312,919 50,000 (262,919) All Appropriations $ 1,274,325 $ 1,237,244 $ 974,325 $ (262,919) 225 SPUR CROSS RANCH CONSERVATION Non Recurring Non Project $ 163,075 $ 163,075 $ 125,000 $ (38,075) Operating 272,132 272,132 272,132 - All Appropriations $ 435,207 $ 435,207 $ 397,132 $ (38,075) 230 PARKS AND RECREATION GRANTS Non Recurring Non Project $ 34,696 $ 34,696 $ - $ (34,696) Operating - - 23,560 23,560 All Appropriations $ 34,696 $ 34,696 $ 23,560 $ (11,136) 15 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm 239 PARKS SOUVENIR Operating $ 396,182 $ 396,182 $ 396,182 $ - All Appropriations $ 396,182 $ 396,182 $ 396,182 $ - 240 LAKE PLEASANT RECREATION SERVICES Non Recurring Non Project $ 1,264,809 $ 1,264,809 $ 695,123 $ (569,686) Operating 2,640,393 2,640,393 2,848,028 207,635 All Appropriations $ 3,905,202 $ 3,905,202 $ 3,543,151 $ (362,051) 241 PARKS ENHANCEMENT Non Recurring Non Project $ 1,775,340 $ 1,775,340 $ 828,424 $ (946,916) Operating 4,893,687 4,893,687 5,240,230 346,543 Parks Restrooms Upgrades 342,000 342,000 - (342,000) All Appropriations $ 7,011,027 $ 7,011,027 $ 6,068,654 $ (942,373) 243 PARKS DONATIONS Daisy Mountain And Trails $ - $ 185,000 $ 110,000 $ (75,000) Non Recurring Non Project 468,166 468,166 188,166 (280,000) Operating 25,404 25,404 25,404 - All Appropriations $ 493,570 $ 678,570 $ 323,570 $ (355,000) D300 Total $ 13,550,209 $ 13,698,128 $ 11,726,574 $ (1,971,554) D310 HUMAN RESOURCES 100 GENERAL Bus Card Replacement One Time $ - $ - $ 11,500 $ 11,500 Bus Cards - - 1,620 1,620 Human Resources System Ops - - 2,478,995 2,478,995 Job Analysis Consultant 202,910 202,427 45,930 (156,497) Learning Management 10,000 25,500 - (25,500) Operating 4,262,723 4,331,532 4,354,790 23,258 Recognition Program - - 10,000 10,000 Tuition Reimbursement - - 1,000,000 1,000,000 All Appropriations $ 4,475,633 $ 4,559,459 $ 7,902,835 $ 3,343,376 D310 Total $ 4,475,633 $ 4,559,459 $ 7,902,835 $ 3,343,376 D340 PUBLIC FIDUCIARY 100 GENERAL Operating $ 3,857,641 $ 3,905,571 $ 3,929,288 $ 23,717 All Appropriations $ 3,857,641 $ 3,905,571 $ 3,929,288 $ 23,717 D340 Total $ 3,857,641 $ 3,905,571 $ 3,929,288 $ 23,717 D390 EMPLOYEE BENEFITS AND HEALTH 100 GENERAL Operating $ 276,946 $ 283,762 $ 281,799 $ (1,963) All Appropriations $ 276,946 $ 283,762 $ 281,799 $ (1,963) 532 PUBLIC HEALTH GRANTS Operating $ 7,891,088 $ 8,274,503 $ 7,941,302 $ (333,201) All Appropriations $ 7,891,088 $ 8,274,503 $ 7,941,302 $ (333,201) 685 BENEFITS TRUST Non Recurring Non Project $ 500,400 $ 500,400 $ 200,000 $ (300,400) Operating 158,452,761 158,452,761 158,174,650 (278,111) All Appropriations $ 158,953,161 $ 158,953,161 $ 158,374,650 $ (578,511) 16 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm 686 BENEFITS TRUST - AGENCY Operating $ 14,922,290 $ 14,922,290 $ 15,281,010 $ 358,720 All Appropriations $ 14,922,290 $ 14,922,290 $ 15,281,010 $ 358,720 D390 Total $ 182,043,485 $ 182,433,716 $ 181,878,761 $ (554,955) D410 ENTERPRISE TECHNOLOGY 100 GENERAL Advantage 2x Hosting Charges $ 280,000 $ 281,588 $ - $ (281,588) Content Management System Web 985,629 985,629 241,250 (744,379) Cyber Security / Major Maint 259,000 259,677 361,588 101,911 Cyber Security NRNP 2,116,703 841,575 1,974,244 1,132,669 Desktop/Laptop Replacement 100,000 257,828 154,807 (103,021) Enterprise Data Networking - - 6,491,318 6,491,318 Enterprise Data Center Systems 2,797,017 1,528,190 1,055,254 (472,936) Information Technology Maintenance Operating 14,992,342 14,992,342 17,437,469 2,445,127 Microsoft Active Directory - - 3,000,000 3,000,000 Non Recurring Non Project 1,335,475 1,335,475 1,046,059 (289,416) Operating 10,632,051 10,862,650 10,849,078 (13,572) All Appropriations $ 33,498,217 $ 31,344,954 $ 42,611,067 $ 11,266,113 255 DETENTION OPERATIONS Operating $ 984,584 $ 1,001,031 $ 1,001,031 $ - All Appropriations $ 984,584 $ 1,001,031 $ 1,001,031 $ - 681 TELECOMMUNICATIONS Non Recurring Non Project $ 1,204,547 $ 1,204,547 $ 846,234 $ (358,313) Operating 21,636,326 21,636,326 23,633,017 1,996,691 All Appropriations $ 22,840,873 $ 22,840,873 $ 24,479,251 $ 1,638,378 D410 Total $ 57,323,674 $ 55,186,858 $ 68,091,349 $ 12,904,491 D420 INTEGRATED CRIM JUSTICE INFO 255 DETENTION OPERATIONS Operating $ 1,674,309 $ 1,697,008 $ 1,700,328 $ 3,320 All Appropriations $ 1,674,309 $ 1,697,008 $ 1,700,328 $ 3,320 D420 Total $ 1,674,309 $ 1,697,008 $ 1,700,328 $ 3,320 D440 PLANNING AND DEVELOPMENT 100 GENERAL Operating $ 868,232 $ 868,232 $ 868,232 $ - All Appropriations $ 868,232 $ 868,232 $ 868,232 $ - 226 PLANNING AND DEVELOPMENT FEES Non Recurring Non Project $ 532,127 $ 1,132,127 $ 678,716 $ (453,411) Operating 8,001,694 8,001,694 8,456,606 454,912 All Appropriations $ 8,533,821 $ 9,133,821 $ 9,135,322 $ 1,501 D440 Total $ 9,402,053 $ 10,002,053 $ 10,003,554 $ 1,501 D470 NON DEPARTMENTAL 100 GENERAL Compliance - Non Recurring $ - $ 1,350,000 $ 2,439,588 $ 1,089,588 Compliance - Operating 3,023,124 5,023,124 5,023,124 - Non Recurring Non Project 119,536,371 118,780,832 118,888,330 107,498 Operating 536,740,433 519,348,945 553,750,997 34,402,052 All Appropriations $ 659,299,928 $ 644,502,901 $ 680,102,039 $ 35,599,138 17 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm 210 WASTE MANAGEMENT Non Recurring Non Project $ 688,762 $ 679,632 $ 494,352 $ (185,280) All Appropriations $ 688,762 $ 679,632 $ 494,352 $ (185,280) 249 NON-DEPARTMENTAL GRANTS Non Recurring Non Project $ 2,908,912 $ 12,831,789 $ 6,650,000 $ (6,181,789) Operating 13,112,063 13,047,268 5,000,000 (8,047,268) All Appropriations $ 16,020,975 $ 25,879,057 $ 11,650,000 $ (14,229,057) 255 DETENTION OPERATIONS CHS Graves Judgment Non Recurring $ 400,000 $ 400,000 $ 357,198 $ (42,802) Non Recurring Non Project 35,128,710 35,128,710 32,604,718 (2,523,992) Operating 9,218,583 4,532,336 8,820,976 4,288,640 All Appropriations $ 44,747,293 $ 40,061,046 $ 41,782,892 $ 1,721,846 320 COUNTY IMPROVEMENT DEBT Non Recurring Non Project $ 106,615,480 $ 113,302,480 $ 105,894,530 $ (7,407,950) Operating 13,353,000 13,353,000 18,399,600 5,046,600 All Appropriations $ 119,968,480 $ 126,655,480 $ 124,294,130 $ (2,361,350) 321 COUNTY IMPROVEMENT DEBT 2 Desktop/Laptop Replacement $ 2,926,394 $ 3,095,454 $ 3,095,454 $ - Non Recurring Non Project 7,555,569 7,555,569 2,875,212 (4,680,357) VM Ware Non Recurring 1,330,767 1,330,767 1,330,767 - All Appropriations $ 11,812,730 $ 11,981,790 $ 7,301,433 $ (4,680,357) 422 INTERGOVERNMENTAL CAPITAL PROJECTS Vulture Mountain $ 123,300 $ 123,835 $ 108,091 $ (15,744) All Appropriations $ 123,300 $ 123,835 $ 108,091 $ (15,744) 440 COUNTY IMPROVEMENT COP SERIES 2015 Computer Aided Mass Appraisal $ 7,677,886 $ 7,633,361 $ 5,304,395 $ (2,328,966) County Telephone System 5,392,330 2,172,196 - (2,172,196) Enterprise Data Center Ct 4,983,247 2,783,767 632,114 (2,151,653) Enterprise Res Planning System 6,453,753 7,483,135 3,311,927 (4,171,208) Infrastructure Refresh Ph I 73,586 332,703 - (332,703) Infrastructure Refresh Ph II 4,558,781 2,517,387 - (2,517,387) Jail Kitchen Equipment 300,000 137,879 - (137,879) Jail Mgmt Information System 8,893,241 11,044,559 13,747,927 2,703,368 Non Recurring Non Project - - 9,639,172 9,639,172 Radio System 35,241,579 28,431,242 31,973,536 3,542,294 Sheriff Nice Vision 2,663,250 2,575,789 - (2,575,789) Southwest Justice Courts 21,150,541 21,708,913 3,300,000 (18,408,913) All Appropriations $ 97,388,194 $ 86,820,931 $ 67,909,071 $ (18,911,860) 441 COUNTY IMPROVEMENT 441 COP SERIES 2016 Madison Street Jail Adap Phase $ 17,600,000 $ 17,600,000 $ 37,000,000 $ 19,400,000 All Appropriations $ 17,600,000 $ 17,600,000 $ 37,000,000 $ 19,400,000 445 GENERAL FUND COUNTY IMPROVEMENTS Adobe Boundary Fence $ - $ - $ 112,000 $ 112,000 Adult Probation Black Canyon 3,000,000 3,000,000 2,950,000 (50,000) Adult Probation Mesa Building - - 1,500,000 1,500,000 Adult Probation Southport 3,000,000 3,000,000 2,950,000 (50,000) Animal Care Expansion Durango - - 2,500,000 2,500,000 Buckeye Hills Range Electric 1,751,294 1,751,294 - (1,751,294) 18 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm Chambers Building 1,590,787 1,791,430 - (1,791,430) East Court Improvements 7,000,000 6,147,429 9,447,429 3,300,000 Estrella Ramada Renovations - - 580,000 580,000 Estrella Turf Improvements - - 470,000 470,000 Estrella Water System Replacement - - 300,000 300,000 Hassayampa 1,000,000 1,000,000 835,294 (164,706) Hassayampa Elec/Septic/Water - - 250,000 250,000 Lake Boundary Fencing - - 638,400 638,400 Lake Playground at Discovery Center - - 600,000 600,000 Lake Ramada Renovations - - 150,480 150,480 Maricopa Regional Trail System 532,889 576,845 675,811 98,966 McDowell Restroom at Four Peaks - - 550,000 550,000 Nav Aide Boathouse Construction - - 300,000 300,000 Non Recurring Non Project 18,104,659 18,479,659 49,473,530 30,993,871 Parks Restrooms Upgrades - - 342,000 342,000 Project Reserve 377,978 377,978 - (377,978) Reserve - - 4,200,000 4,200,000 Sheriff HQ Project 452,148 377,953 - (377,953) Vulture Day-Use Campground Construction - - 342,000 342,000 Vulture Day-Use Design/Engineering - - 175,000 175,000 Vulture Mountain 217,751 217,751 217,751 - West Court Improvements 385,000 18,564 - (18,564) White Tank Willow Campground Improvements - - 580,000 580,000 All Appropriations $ 37,412,506 $ 36,738,903 $ 80,139,695 $ 43,400,792 455 DETENTION CAPITAL PROJECTS Intake Transfer Release Jail $ 31,000,000 29,174,541 82,291,000 53,116,459 All Appropriations $ 31,000,000 $ 29,174,541 $ 82,291,000 $ 53,116,459 460 TECHNOLOGY CAPITAL IMPROVEMENT BIX Room Byte Info Exchange $ 2,785,275 $ 1,154,530 $ - $ (1,154,530) Desktop/Laptop Replacement 2,959,125 2,959,125 - (2,959,125) Infrastructure Refresh Ph II 2,452,744 2,452,744 6,742,662 4,289,918 Non Recurring Non Project 99,375,000 99,375,000 123,659,008 24,284,008 Treasurer Tech System Upgrade 18,751,162 19,875,571 16,154,138 (3,721,433) All Appropriations $ 126,323,306 $ 125,816,970 $ 146,555,808 $ 20,738,838 461 DETENTION TECHNOLOGY CAPITAL IMPROVEMENT CHS Electronic Medical Record $ 887,527 $ 2,060,587 $ 374,111 $ (1,686,476) Desktop/Laptop Replacement 162,534 162,534 - (162,534) Non Recurring Non Project 3,286,659 3,286,659 34,995,069 31,708,410 All Appropriations $ 4,336,720 $ 5,509,780 $ 35,369,180 $ 29,859,400 D470 Total $ 1,166,722,194 $ 1,151,544,866 $ 1,314,997,691 $ 163,452,825 D490 BUDGET 100 GENERAL Operating $ 2,431,156 $ 2,465,697 $ 2,366,828 $ (98,869) All Appropriations $ 2,431,156 $ 2,465,697 $ 2,366,828 $ (98,869) D490 Total $ 2,431,156 $ 2,465,697 $ 2,366,828 $ (98,869) 19 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm D520 PUBLIC DEFENDER 100 GENERAL Operating $ 41,570,118 $ 42,277,571 $ 42,851,483 $ 573,912 All Appropriations $ 41,570,118 $ 42,277,571 $ 42,851,483 $ 573,912 209 PUBLIC DEFENDER TRAINING Non Recurring Non Project $ 66,702 $ 66,702 $ 110,011 $ 43,309 Operating 271,108 271,108 226,298 (44,810) All Appropriations $ 337,810 $ 337,810 $ 336,309 $ (1,501) 233 PUBLIC DEFENDER GRANTS Operating $ 222,141 $ 222,141 $ 198,518 $ (23,623) All Appropriations $ 222,141 $ 222,141 $ 198,518 $ (23,623) 262 PUBLIC DEFENDER FILL THE GAP Operating $ 775,462 $ 775,462 $ 807,679 $ 32,217 PDS Case Management System 38,008 38,008 128,786 90,778 All Appropriations $ 813,470 $ 813,470 $ 936,465 $ 122,995 D520 Total $ 42,943,539 $ 43,650,992 $ 44,322,775 $ 671,783 D540 LEGAL DEFENDER 100 GENERAL Operating $ 13,436,322 $ 13,672,096 $ 13,996,656 $ 324,560 All Appropriations $ 13,436,322 $ 13,672,096 $ 13,996,656 $ 324,560 209 PUBLIC DEFENDER TRAINING Non Recurring Non Project $ 14,999 $ 14,999 $ 64,713 $ 49,714 Operating 54,378 54,378 43,093 (11,285) All Appropriations $ 69,377 $ 69,377 $ 107,806 $ 38,429 263 LEGAL DEFENDER FILL THE GAP Operating $ 66,362 $ 66,362 $ 66,362 $ - All Appropriations $ 66,362 $ 66,362 $ 66,362 $ - D540 Total $ 13,572,061 $ 13,807,835 $ 14,170,824 $ 362,989 D550 LEGAL ADVOCATE 100 GENERAL Operating $ 12,046,888 $ 12,248,897 $ 12,565,709 $ 316,812 All Appropriations $ 12,046,888 $ 12,248,897 $ 12,565,709 $ 316,812 209 PUBLIC DEFENDER TRAINING Non Recurring Non Project $ 14,387 $ 14,387 $ 11,814 $ (2,573) Operating 20,627 20,627 16,099 (4,528) All Appropriations $ 35,014 $ 35,014 $ 27,913 $ (7,101) D550 Total $ 12,081,902 $ 12,283,911 $ 12,593,622 $ 309,711 D560 CONTRACT COUNSEL 100 GENERAL Capital Post Conviction Relief Backlog $ - $ - $ 1,289,869 $ 1,289,869 Non Recurring Non Project 2,828,092 2,721,380 - (2,721,380) Operating 51,658,915 51,700,230 50,193,921 (1,506,309) All Appropriations $ 54,487,007 $ 54,421,610 $ 51,483,790 $ (2,937,820) D560 Total $ 54,487,007 $ 54,421,610 $ 51,483,790 $ (2,937,820) D570 PUBLIC ADVOCATE 100 GENERAL Operating $ 9,297,577 $ 9,454,607 $ 9,526,644 $ 72,037 All Appropriations $ 9,297,577 $ 9,454,607 $ 9,526,644 $ 72,037 D570 Total $ 9,297,577 $ 9,454,607 $ 9,526,644 $ 72,037 20 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm D640 TRANSPORTATION 100 GENERAL Operating $ - $ - $ 111,672 $ 111,672 All Appropriations $ - $ - $ 111,672 $ 111,672 223 TRANSPORTATION GRANTS MAG ALCP Projects $ - $ 76,054 $ - $ (76,054) Non Recurring Non Project 320,000 420,000 593,000 173,000 All Appropriations $ 320,000 $ 496,054 $ 593,000 $ 96,946 232 TRANSPORTATION OPERATIONS Non Recurring Non Project $ 58,489,784 $ 58,489,784 $ 52,887,238 $ (5,602,546) Operating 63,501,718 63,501,718 72,123,947 8,622,229 All Appropriations $ 121,991,502 $ 121,991,502 $ 125,011,185 $ 3,019,683 234 TRANSPORTATION CAPITAL PROJECT Capacity $ - $ 21,001,500 $ 36,685,100 $ 15,683,600 County Arterials 23,305,233 - - - Dust Mitigation 6,243,887 5,381,000 7,293,800 1,912,800 Intelligent Trans Syst ITS 4,067,000 - - - MAG ALCP Projects 26,194,639 23,096,696 26,028,500 2,931,804 Partnership Support 2,045,000 - - - Pavement Preservation 11,384,319 - - - Right Of Way 250,000 - - - Safety Projects 18,585,000 - - - System Preservation and Reconstruction - 16,785,000 19,096,031 2,311,031 Traffic Improvements 8,056,118 - - - Transportation System Management - 33,957,000 42,652,800 8,695,800 All Appropriations $ 100,221,196 $ 100,221,196 $ 131,756,231 $ 31,535,035 900 ELIMINATIONS Non Recurring Non Project $ (46,191,794) $ (46,191,794) $ (47,276,758) $ (1,084,964) All Appropriations $ (46,191,794) $ (46,191,794) $ (47,276,758) $ (1,084,964) D640 Total $ 176,340,904 $ 176,516,958 $ 210,195,330 $ 33,678,372 D670 WASTE RESOURCES AND RECYCLING 100 GENERAL Operating $ 4,186,564 $ 4,207,411 $ 4,138,556 $ (68,855) All Appropriations $ 4,186,564 $ 4,207,411 $ 4,138,556 $ (68,855) 290 WASTE TIRE Operating $ 4,751,611 $ 4,951,611 $ 4,952,726 $ 1,115 All Appropriations $ 4,751,611 $ 4,951,611 $ 4,952,726 $ 1,115 D670 Total $ 8,938,175 $ 9,159,022 $ 9,091,282 $ (67,740) D700 FACILITIES MANAGEMENT 100 GENERAL East Court Elevator Renovations $ - $ - $ 3,500,000 $ 3,500,000 Facilities Major Maintenance Operating 7,877,906 7,877,906 7,877,906 - Non Recurring Non Project 139,321 139,321 21,723 (117,598) Operating 38,098,140 38,377,191 35,745,942 (2,631,249) All Appropriations $ 46,115,367 $ 46,394,418 $ 47,145,571 $ 751,153 21 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm 255 DETENTION OPERATIONS Facilities Major Maintenance Operating $ 6,726,998 $ 6,726,998 $ 6,726,998 $ - Non Recurring Non Project 25,052 25,052 - (25,052) Operating 19,387,545 19,425,108 19,385,204 (39,904) All Appropriations $ 26,139,595 $ 26,177,158 $ 26,112,202 $ (64,956) D700 Total $ 72,254,962 $ 72,571,576 $ 73,257,773 $ 686,197 D730 PROCUREMENT SERVICES 100 GENERAL Operating $ 2,438,032 $ 2,482,132 $ 2,503,913 $ 21,781 All Appropriations $ 2,438,032 $ 2,482,132 $ 2,503,913 $ 21,781 673 REPROGRAPHICS Non Recurring Non Project $ 87,450 $ 87,450 $ - $ (87,450) Operating 739,834 739,834 - (739,834) All Appropriations $ 827,284 $ 827,284 $ - $ (827,284) D730 Total $ 3,265,316 $ 3,309,416 $ 2,503,913 $ (805,503) D740 EQUIPMENT SERVICES 100 GENERAL Non Recurring Non Project $ - $ - $ 450,000 $ 450,000 Operating - - 4,634,400 4,634,400 All Appropriations $ - $ - $ 5,084,400 $ 5,084,400 255 DETENTION OPERATIONS Operating $ - $ - $ 1,050,000 $ 1,050,000 All Appropriations $ - $ - $ 1,050,000 $ 1,050,000 654 EQUIPMENT SERVICES Non Recurring Non Project $ 1,006,500 $ 1,006,500 $ 849,500 $ (157,000) Operating 16,854,693 16,854,693 16,976,629 121,936 All Appropriations $ 17,861,193 $ 17,861,193 $ 17,826,129 $ (35,064) D740 Total $ 17,861,193 $ 17,861,193 $ 23,960,529 $ 6,099,336 D750 RISK MANAGEMENT 675 RISK MANAGEMENT Operating $ 33,338,997 $ 33,338,997 $ 34,364,359 $ 1,025,362 All Appropriations $ 33,338,997 $ 33,338,997 $ 34,364,359 $ 1,025,362 D750 Total $ 33,338,997 $ 33,338,997 $ 34,364,359 $ 1,025,362 D790 ANIMAL CARE AND CONTROL 100 GENERAL Operating $ 758,954 $ 758,954 $ 758,954 $ - All Appropriations $ 758,954 $ 758,954 $ 758,954 $ - 572 ANIMAL CONTROL LICENSE/SHELTER Non Recurring Non Project $ 38,806 $ 38,806 $ 15,000 $ (23,806) Operating 11,936,923 11,936,923 11,362,828 (574,095) All Appropriations $ 11,975,729 $ 11,975,729 $ 11,377,828 $ (597,901) 574 ANIMAL CONTROL FIELD OPERATIONS Non Recurring Non Project $ 325,000 $ 325,000 $ 325,000 $ - Operating 3,733,360 3,733,360 3,749,933 16,573 All Appropriations $ 4,058,360 $ 4,058,360 $ 4,074,933 $ 16,573 D790 Total $ 16,793,043 $ 16,793,043 $ 16,211,715 $ (581,328) 22 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm D850 AIR QUALITY 100 GENERAL Air Qual Monitoring Equip $ 308,080 $ 308,080 $ - $ (308,080) Air Qual Monitoring Equip Oper - - 308,080 308,080 Operating 810,957 810,957 810,957 - All Appropriations $ 1,119,037 $ 1,119,037 $ 1,119,037 $ - 503 AIR QUALITY GRANTS Operating $ 4,128,306 $ 4,128,306 $ 5,403,005 $ 1,274,699 All Appropriations $ 4,128,306 $ 4,128,306 $ 5,403,005 $ 1,274,699 504 AIR QUALITY FEES Non Recurring Non Project $ 2,413,236 $ 2,413,236 $ 3,918,032 $ 1,504,796 Operating 11,114,786 11,114,786 11,193,314 78,528 All Appropriations $ 13,528,022 $ 13,528,022 $ 15,111,346 $ 1,583,324 D850 Total $ 18,775,365 $ 18,775,365 $ 21,633,388 $ 2,858,023 D860 PUBLIC HEALTH 100 GENERAL Operating $ 11,878,845 $ 12,094,552 $ 12,275,818 $ 181,266 All Appropriations $ 11,878,845 $ 12,094,552 $ 12,275,818 $ 181,266 265 PUBLIC HEALTH FEES Non Recurring Non Project $ 510,592 $ 572,208 $ 250,000 $ (322,208) Operating 6,638,299 6,638,299 6,793,302 155,003 All Appropriations $ 7,148,891 $ 7,210,507 $ 7,043,302 $ (167,205) 532 PUBLIC HEALTH GRANTS Non Recurring Non Project $ - $ 114,437 $ 719,393 $ 604,956 Operating 42,884,495 42,884,495 44,230,398 1,345,903 All Appropriations $ 42,884,495 $ 42,998,932 $ 44,949,791 $ 1,950,859 D860 Total $ 61,912,231 $ 62,303,991 $ 64,268,911 $ 1,964,920 D880 ENVIRONMENTAL SERVICES 100 GENERAL Non Recurring Non Project $ 485,587 $ 485,587 $ 189,932 $ (295,655) Operating 4,152,458 4,203,894 4,136,444 (67,450) Vector Control Foggers - - 75,000 75,000 All Appropriations $ 4,638,045 $ 4,689,481 $ 4,401,376 $ (288,105) 505 ENVIRONMENTAL SERVICES GRANTS Operating $ 67,198 $ 67,198 $ 67,198 $ - All Appropriations $ 67,198 $ 67,198 $ 67,198 $ - 506 ENVIRONMENTAL SERVICES ENVIRONMENTAL HEALTH Non Recurring Non Project $ 949,243 $ 949,243 $ 1,611,941 $ 662,698 Operating 19,166,315 19,166,315 19,480,116 313,801 All Appropriations $ 20,115,558 $ 20,115,558 $ 21,092,057 $ 976,499 D880 Total $ 24,820,801 $ 24,872,237 $ 25,560,631 $ 688,394 D920 DEPUTY COUNTY MANAGER 920 100 GENERAL Operating $ 1,473,270 $ 1,503,174 $ - $ (1,503,174) All Appropriations $ 1,473,270 $ 1,503,174 $ - $ (1,503,174) D920 Total $ 1,473,270 $ 1,503,174 $ - $ (1,503,174) 23 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Recomm Recomm D940 ASSISTANT COUNTY MANAGER 940 100 GENERAL Operating $ 295,088 $ 301,337 $ 693,334 $ 391,997 All Appropriations $ 295,088 $ 301,337 $ 693,334 $ 391,997 D940 Total $ 295,088 $ 301,337 $ 693,334 $ 391,997 D950 ASSISTANT COUNTY MANAGER 950 100 GENERAL Non Recurring Non Project $ 469,107 $ 469,107 $ 381,645 $ (87,462) Operating 435,276 436,956 558,495 121,539 All Appropriations $ 904,383 $ 906,063 $ 940,140 $ 34,077 249 NON0DEPARTMENTAL GRANTS Operating $ 68,459 $ 68,459 $ 849,000 $ 780,541 All Appropriations $ 68,459 $ 68,459 $ 849,000 $ 780,541 255 DETENTION OPERATIONS Operating $ 410,680 $ 419,068 $ 420,559 $ 1,491 All Appropriations $ 410,680 $ 419,068 $ 420,559 $ 1,491 D950 Total $ 1,383,522 $ 1,393,590 $ 2,209,699 $ 816,109 Total Appointed $ 2,161,079,837 $ 2,150,461,428 $ 2,369,437,747 $ 218,976,319 ELIMINATIONS D980 ELIMINATIONS COUNTY 900 ELIMINATIONS Non Recurring Non Project $ (234,137,282) $ (241,472,876) $ (325,796,638) $ (84,323,762) Operating (461,194,148) (456,498,675) (460,181,383) (3,682,708) All Appropriations $ (695,331,430) $ (697,971,551) $ (785,978,021) $ (88,006,470) D980 Total $ (695,331,430) $ (697,971,551) $ (785,978,021) $ (88,006,470) Total Eliminations $ (695,331,430) $ (697,971,551) $ (785,978,021) $ (88,006,470) TOTAL MARICOPA COUNTY $ 2,356,007,976 $ 2,361,533,713 $ 2,494,333,805 $ 132,800,092 24 Capital Improvement Program Intergovernmental and County Improvement Capital Projects – General Fund and Special Revenue Funds 234 TRANSPORTATION Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total CAPITAL PROJECT Actuals FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Total Project Dust Mitigation $ 22,757,794 $ 3,224,531 $ 7,293,800 $ 3,589,467 $ 2,823,119 $ 2,893,555 $ 8,250,000 $ 24,849,941 $ 50,832,266 MAG ALCP Projects 107,096,591 6,948,261 26,028,500 37,645,781 62,297,751 83,995,560 12,738,571 222,706,163 336,751,015 System Preservation and Reconstruction 18,396,053 12,595,567 19,096,031 19,239,253 10,021,709 19,342,990 25,250,000 92,949,983 123,941,603 Capacity 22,325,414 11,699,590 36,685,100 16,850,474 38,819,337 8,854,496 19,960,000 121,169,407 155,194,411 Transportation System Management 23,714,233 17,511,299 42,652,800 21,679,264 17,929,815 2,960,416 20,867,731 106,090,026 147,315,558 TOTAL FUND 234 $ 194,290,085 $ 51,979,248 $ 131,756,231 $ 99,004,239 $ 131,891,731 $ 118,047,017 $ 87,066,302 $ 567,765,520 $ 814,034,853 422 INTERGOVERNMENTAL Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total CAP PROJ Actuals FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Total Project Maricopa Regional Trail System $ 996,937 $ - $ - $ - $ - $ - $ - $ - $ 996,937 Vulture Mountain Study 55,464 15,744 108,091 - - - - 108,091 179,299 TOTAL FUND 422 $ 1,052,401 $ 15,744 $ 108,091 $ - $ - $ - $ - $ 108,091 $ 1,176,236 440 COUNTY Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total IMPROVEMENT FUND Actuals FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Total Project Computer Aided Mass Appraisal $ 9,364,385 $ 2,328,966 $ 5,304,395 $ 7,197,848 $ - $ - $ - $ 12,502,243 $ 24,195,594 County Telephone System 14,707,906 2,172,196 - - - - - - 16,880,102 Enterprise Data Center 17,060,229 563,869 632,114 - - - - 632,114 18,256,212 Enterprise Resource Planning Sys 18,860,100 3,417,908 3,311,927 - - - - 3,311,927 25,589,935 Infrastructure Refresh Phase 1 7,192,760 - - - - - - - 7,192,760 Infrastructure Refresh Phase 2 24,802,809 1,880,071 - - - - - - 26,682,880 Jail Mgmt Information System 3,099,676 2,905,308 13,747,927 4,275,543 19,117 - 18,042,587 24,047,571 Jail Kitchen Equipment 162,122 121,365 - - - - - - 283,487 Jail Security System Upgrade 5,874,437 210,933 - - - - - - 6,085,370 Public Safety Radio System 42,488,377 5,701,474 31,973,536 14,839,080 - - 46,812,616 95,002,467 Southwest Justice Courts 8,291,085 13,708,884 3,300,000 - - - 3,300,000 25,299,969 TOTAL PROJECTS 440 $ 151,903,886 $ 33,010,974 $ 58,269,899 $ 26,312,471 $ 19,117 $ - $ - $ 84,601,487 $ 269,516,347 441 COUNTY Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total IMPROVEMENT 441 Actuals FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Total Project Madison Street Jail Adaptation $ - $ 1,800,000 $ 37,000,000 $ 77,200,000 $ - $ - $ - $ 114,200,000 $ 116,000,000 TOTAL PROJECTS 441 $ - $ 1,800,000 $ 37,000,000 $ 77,200,000 $ - $ - $ - $ 114,200,000 $ 116,000,000 445 GENERAL FUND Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total CTY IMPROV Actuals FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Total Project Adobe Boundary Fence $ - $ - $ 112,000 $ - $ - $ - $ - $ 112,000 $ 112,000 Adult Probation-Black Canyon Fac - 50,000 2,950,000 - - - - 2,950,000 3,000,000 Adult Probation-Mesa Building - - 1,500,000 14,151,000 - - - 15,651,000 15,651,000 Adult Probation-Southport Fac - 50,000 2,950,000 - - - - 2,950,000 3,000,000 Animal Care Expansion Durango - - 2,500,000 - - - - 2,500,000 2,500,000 Buckeye Hills Range Electric - 90,000 - - - - - - 90,000 Chambers Building 2,160,766 1,661,430 - - - - - - 3,822,196 East Court Improvements 13,257,937 2,000,000 9,447,429 - - - - 9,447,429 24,705,366 Estrella Ramada Renovations - - 580,000 - - - - 580,000 580,000 Estrella Turf Improvements - - 470,000 - - - - 470,000 470,000 Estrella Water System Replacement - - 300,000 - - - - 300,000 300,000 Hassayampa - 164,706 835,294 - - - - 835,294 1,000,000 Hassayampa Elec/Septic/Water - - 250,000 - - - - 250,000 250,000 Lake Boundary Fencing - - 638,400 - - - - 638,400 638,400 Lake Playground At Discovery Ctr - - 600,000 - - - - 600,000 600,000 Lake Ramada Renovations - - 150,480 - - - - 150,480 150,480 Maricopa Regional Trail System 4,079,560 244,629 675,811 - - - - 675,811 5,000,000 McDowell Restroom At Four Peaks - - 550,000 - - - - 550,000 550,000 Nav Aide Boathouse Construction - - 300,000 - - - - 300,000 300,000 Parks Restrooms Upgrades - - 342,000 - - - - 342,000 342,000 Sheriff HQ Project 32,733,517 145,728 - - - - - - 32,879,245 Southwest Justice Courts 620,246 - - - - - - - 620,246 Vulture Day - Use Campground Construction - - 342,000 - - - - 342,000 342,000 Vulture Day - Use Design/Engineering - - 175,000 - - - - 175,000 175,000 Vulture Mountain 57,249 - 217,751 - - - - 217,751 275,000 West Court Improvements 550,618 18,564 - - - - - - 569,182 White Tank Willow CG Const - - 580,000 - - - - 580,000 580,000 TOTAL PROJECTS 445 $ 53,459,893 $ 4,425,057 $ 26,466,165 $ 14,151,000 $ - $ - $ - $ 40,617,165 $ 98,502,115 Project Reserve 445 $ - $ - $ 4,200,000 $ 19,661,294 $ - $ 33,416,593 $ 234,079,470 $ 291,357,357 $ 291,357,357 TOTAL FUND 445 $ 53,459,893 $ 4,425,057 $ 30,666,165 $ 33,812,294 $ - $ 33,416,593 $ 234,079,470 $ 331,974,522 $ 389,859,472 25 Capital Improvement Program (continued) Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total 455 DETENTION CAPITAL PROJECTS Actuals FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Total Project Intake Transfer Release Jail $ 5,825,458 $ 10,177,801 $ 82,291,000 $ 86,705,740 $ - $ - $ - $ 168,996,740 $ 184,999,999 Sheriff HQ Project 30,000,000 - - - - - - - 30,000,000 TOTAL PROJECTS 455 $ 35,825,458 $ 10,177,801 $ 82,291,000 $ 86,705,740 $ - $ - $ - $ 168,996,740 $ 214,999,999 Project Reserve 455 $ - $ - $ - $ - $ - $ - $ 75,919,181 $ 75,919,181 $ 75,919,181 TOTAL FUND 455 $ 35,825,458 $ 10,177,801 $ 82,291,000 $ 86,705,740 $ - $ - $ 75,919,181 $ 244,915,921 $ 290,919,180 Technology Capital Improvement Program Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total 460 TECHNOLOGY CAP IMPROVEMENT Actuals FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Total Project BIX Room Byte Info Exchange $ 3,344,926 $ 721,958 $ - $ - $ - $ - $ - $ - $ 4,066,884 Computer Aided Mass Appraisal 692,132 - - - - - - - 692,132 County Telephone System 12,206,104 - - - - - - - 12,206,104 Enterprise Data Center 25,493,531 - - - - - - - 25,493,531 Enterprise Resource Planning Sys 4,132,672 - - - - - - - 4,132,672 Infrastructure Refresh Phase 1 4,733,947 - - - - - - - 4,733,947 Infrastructure Refresh Phase 2 32,860,060 - - - - - - - 32,860,060 Public Safety Radio System 36,348,757 - - - - - - - 36,348,757 Refresh Remote Sites Phase 3 - 876,301 1,576,443 - - - - 1,576,443 2,452,744 Refresh Remote Sites Phase 4 - - 5,166,219 - - - - 5,166,219 5,166,219 Treasurer Tech System Upgrade 3,439,277 14,383,889 16,154,138 1,610,297 - - - 17,764,435 35,587,600 TOTAL PROJECTS 460 $ 123,251,406 $ 15,982,148 $ 22,896,800 $ 1,610,297 $ - $ - $ - $ 24,507,097 $ 163,740,650 Project Reserve 460 $ - $ - $ - $ 9,692,190 $ - $ - $ 43,570,185 $ 53,262,375 $ 53,262,375 TOTAL FUND 460 $ 123,251,406 $ 15,982,148 $ 22,896,800 $ 11,302,487 $ - $ - $ 43,570,185 $ 77,769,472 $ 217,003,025 Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total 461 DETENTION TECH CAP IMPROVEMENT Actuals FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 Total Project CHS Electronic Health Records $ 6,178,220 $ 1,686,476 $ 374,111 $ - $ - $ - $ - $ 374,111 $ 8,238,807 Jail Mgmt Information System 1,070,364 - - - - - - - 1,070,364 Jail Security System Upgrade 22,249,778 - - - - - - - 22,249,778 TOTAL PROJECTS 461 $ 29,498,362 $ 1,686,476 $ 374,111 $ - $ - $ - $ - $ 374,111 $ 31,558,949 Project Reserve 461 $ - $ - $ - $ 500,000 $ - $ - $ - $ 500,000 $ 500,000 TOTAL FUND 461 $ 29,498,362 $ 1,686,476 $ 374,111 $ 500,000 $ - $ - $ - $ 874,111 $ 32,058,949 26 Auditor General Forms Summary In compliance with A.R.S 42-17102, the detail on the number of positions and related personnel costs for Maricopa County can be found on the attached Schedule G of forms supplied by the Auditor General. Full Time Equivalent Positions (Regular and Temporary) Personnel Costs Maricopa County 14,595.31 $ 1,133,977,529 Maricopa County Flood Control District 190.95 17,334,336 Maricopa County Library District 223.45 12,861,939 Maricopa County Stadium District 5.10 418,340 TOTAL 15,014.81 $ 1,164,592,144 27 Auditor General Forms – Schedule G MARICOPA COUNTY Full-Time Employees and Personnel Compensation Fiscal Year 2018 Employee Total Estimated Full-Time Salaries and Other Benefit Personnel Equivalent (FTE) Hourly Costs Retirement Costs Healthcare Costs Costs Compensation FUND 2018 2018 2018 2018 2018 2018 GENERAL FUND 7,947.13 $ 391,582,900 $ 89,479,407 $ 75,434,682 $ 32,644,092 $ 589,141,081 Regular Staff 7,583.49 389,207,134 89,479,407 75,434,682 32,462,346 586,583,569 Temporary Staff 363.64 2,375,766 181,746 2,557,512 SPECIAL REVENUE FUNDS Regular Staff 201 - Adult Probation Fees 1.50 $ 8,521,679 $ 1,777,004 $ 980,879 $ 651,912 $ 11,931,474 204 - Justice Court Judicial Enhancement 3.00 187,337 21,546 34,197 17,811 260,891 205 - Court Document Retrieval 22.00 672,047 76,060 216,431 54,144 1,018,682 207 - Palo Verde 6.00 393,820 44,786 80,826 29,717 549,149 208 - Judicial Enhancement 14.00 673,870 76,542 159,586 54,081 964,079 209 - Public Defender Training 3.00 142,968 16,440 34,202 10,943 204,553 211 - Adult Probation Grants 24.00 1,078,238 128,853 230,244 99,772 1,537,107 215 - Emergency Management 8.00 501,527 56,494 87,808 36,860 682,689 216 - Clerk of the Court Grants 1,105,027 126,857 125,973 84,535 1,442,392 217 - CDBG Housing Trust 6.00 429,339 49,374 68,405 37,193 584,311 218 - Clerk of Court Fill The Gap 46.50 1,175,871 131,021 442,558 100,112 1,849,562 219 - County Attorney Grants 62.00 2,556,694 330,998 596,756 195,308 3,679,756 220 - Diversion 29.00 1,641,411 214,545 318,032 133,825 2,307,813 221 - County Attorney Fill the Gap 24.00 1,022,911 117,648 273,576 86,378 1,500,513 222 - Human Services Grants 337.00 13,739,187 1,575,296 3,432,729 1,143,560 19,890,772 225 - Spur Cross Ranch Conservation 1.00 136,955 37,590 25,392 13,130 213,067 226 - Planning and Development Fees 102.60 4,332,756 479,786 988,192 303,704 6,104,438 227 - Juvenile Probation Grants 39.00 1,971,862 408,052 389,120 150,891 2,919,925 228 - Juvenile Probation Special Revenue Fee 1,735,989 405,180 395,805 132,803 2,669,777 232 - Transportation Operations 423.00 21,707,774 2,386,426 4,650,404 1,939,358 30,683,962 233 - Public Defender Grants 2.80 149,684 17,225 18,599 13,010 198,518 236 - Recorders Surcharge 26.00 1,928,247 220,804 292,324 148,548 2,589,923 238 - Superior Court Grants 32.00 2,291,388 261,485 466,867 180,766 3,200,506 239 - Parks Souvenir 30,757 3,535 7,750 2,484 44,526 240 - Lake Pleasant Recreation Services 22.00 1,122,446 115,133 288,985 99,866 1,626,430 241 - Parks Enhancement 58.50 2,191,301 251,750 544,055 224,761 3,211,867 242 - Library District Grants 1.00 47,098 5,415 11,399 3,604 67,516 244 - Library District 166.73 7,998,178 907,999 1,852,393 661,957 11,420,527 245 - Justice Courts Special Revenue 4,115,473 467,381 883,411 314,821 5,781,086 249 - Non Departmental Grants 1.00 34,826 3,808 8,776 2,530 49,940 250 - Cactus League Operations 10,894 1,249 1,140 755 14,038 251 - Sheriff Grants 24.00 2,392,971 1,165,130 194,179 207,279 3,959,559 252 - Inmate Services 108.00 4,127,679 578,227 1,066,428 360,922 6,133,256 253 - Ballpark Operations 4.50 302,436 34,749 44,878 22,239 404,302 254 - Inmate Health Services 171,363 19,704 34,200 13,104 238,371 255 - Detention Operations 3,710.55 213,165,042 37,188,714 42,116,134 18,210,405 310,680,295 256 - Probate Fees 300,298 34,474 34,234 22,972 391,978 257 - Conciliation Court Fees 1,051,068 120,662 119,821 80,406 1,371,957 258 - Sheriff Towing and Impound 2.00 91,499 38,021 22,798 8,054 160,372 259 - Superior Court Special Revenue 3,442,883 395,239 392,487 263,376 4,493,985 261 - Law Library Fees 3.00 166,539 19,084 34,197 12,697 232,517 262 - Public Defender Fill the Gap 9.00 563,272 64,781 101,565 44,077 773,695 263 - Legal Defender Fill the Gap 50,838 5,839 5,796 3,889 66,362 264 - Superior Court Fill the Gap 32.00 1,528,617 228,079 364,768 80,357 2,201,821 265 - Public Health Fees 62.00 3,002,524 336,201 753,515 224,677 4,316,917 266 - Check Enforcement Program 2.00 79,273 9,111 22,798 6,064 117,246 267 - Criminal Justice Enhancement 19.00 1,081,133 160,381 216,581 89,699 1,547,794 271 - Expedited Child Support 458,561 52,642 52,275 35,079 598,557 273 - Victim Location 37,539 4,310 4,279 2,872 49,000 274 - Clerk of the Court EDMS 45.00 1,559,858 179,887 447,848 133,511 2,321,104 275 - Juvenile Probation Diversion 4.00 258,525 60,343 43,616 19,780 382,264 276 - Spousal Maintenance Enforcement Enhancement 82,739 9,498 9,432 6,329 107,998 282 - Domestic Relations Mediation Education 148,280 17,023 16,904 11,343 193,550 290 - Waste Tire 2.00 57,883 6,649 22,798 4,427 91,757 503 - Air Quality Grants 14.75 2,432,466 279,182 354,715 191,495 3,257,858 504 - Air Quality Fees 127.90 5,476,361 637,954 1,263,464 450,278 7,828,057 505 - Environmental Services Grants 21,624 2,482 11,427 1,660 37,193 506 - Environmental Services Environmental Health 234.00 11,484,275 1,328,582 2,448,716 954,779 16,216,352 532 - Public Health Grants 422.00 19,401,208 2,335,547 4,620,676 1,550,175 27,907,606 572 - Animal Control License/Shelter 137.00 4,586,807 475,481 1,403,721 382,140 6,848,149 574 - Animal Control Field Operations 48.00 1,551,610 151,291 492,016 152,837 2,347,754 669 - Small School Service 1.00 67,933 7,772 11,399 5,370 92,474 715 - School Grants 69.49 5,302,898 609,799 813,362 406,808 7,132,867 782 - School Communication 12.00 687,081 78,849 116,905 52,286 935,121 795 - Educational Supplemental Program 8.00 540,907 62,104 82,985 41,022 727,018 991 - Flood Control 188.00 11,360,346 1,196,881 2,048,392 849,006 15,454,625 28 Auditor General Forms – Schedule G (continued) Employee Total Estimated Full-Time Salaries and Other Benefit Personnel Equivalent (FTE) Hourly Costs Retirement Costs Healthcare Costs Costs Compensation FUND 2018 2018 2018 2018 2018 2018 Temporary Staff 204 - Justice Court Judicial Enhancement 10.00 150,259 8,052 158,311 208 - Judicial Enhancement 6.00 159,726 12,219 171,945 211 - Adult Probation Grants 5.50 240,768 18,419 259,187 218 - Clerk of Court Fill The Gap 0.50 19,836 1,517 21,353 221 - County Attorney Fill the Gap 1.00 26,619 2,036 28,655 225 - Spur Cross Ranch Conservation 97 7 104 232 - Transportation Operations 2.50 74,753 5,719 80,472 238 - Superior Court Grants 1.38 155,377 11,886 167,263 239 - Parks Souvenir 1.36 30,450 2,329 32,779 240 - Lake Pleasant Recreation Services 1.36 39,051 2,987 42,038 241 - Parks Enhancement 4.87 26,258 2,009 28,267 244 - Library District 55.72 1,276,262 97,634 1,373,896 253 - Ballpark Operations 0.60 - 255 - Detention Operations 7.50 329,252 25,188 354,440 265 - Public Health Fees 1.00 27,980 2,140 30,120 503 - Air Quality Grants 0.50 14,162 1,083 15,245 504 - Air Quality Fees 4.00 120,269 9,201 129,470 505 - Environmental Services Grants 0.98 6,428 492 6,920 532 - Public Health Grants 31.40 1,463,542 111,927 1,575,469 715 - School Grants 1.00 25,857 1,978 27,835 782 - School Communication 0.50 12,530 959 13,489 991 - Flood Control 2.95 74,046 5,665 79,711 Total Special Revenue Funds 6,891.44 $ 384,955,412 $ 58,610,954 $ 77,696,123 $ 32,154,000 $ 553,416,489 DEBT SERVICE FUNDS Total Debt Service Funds - $ - $ - $ - $ - $ - CAPITAL PROJECTS FUNDS 234 - Transportation Capital Project $ 2,051,448 $ 235,493 $ 233,864 $ 156,926 $ 2,677,731 440 - County Improvement 877,292 108,452 111,606 65,664 1,163,014 445 - General Fund County Improvements 105,674 12,131 17,100 8,085 142,990 460 - Technology Capital Improvement 264,336 30,346 30,134 20,222 345,038 990 - Flood Control Capital Projects 1,250,460 206,640 205,200 137,700 1,800,000 Total Capital Projects Funds - $ 4,549,210 $ 593,062 $ 597,904 $ 388,597 $ 6,128,773 INTERNAL SERVICE FUND Regular Staff 615 - Wellness 6.00 $ 347,474 $ 39,955 $ 64,973 $ 26,971 $ 479,373 618 - Benefits Administration 16.00 1,035,321 119,029 194,896 80,335 1,429,581 654 - Equipment Services 54.00 3,011,682 327,216 612,559 314,835 4,266,292 675 - Risk Management 32.75 2,176,459 250,186 384,543 163,491 2,974,679 681 - Technology Infrastructure 65.00 4,987,625 579,371 788,284 357,487 6,712,767 Temporary Staff 618 - Benefit Administration 2.00 21,114 1,615 22,729 681 - Technology Infrastructure 0.49 18,932 1,448 20,380 Total Internal Service Fund 176.24 $ 11,598,607 $ 1,315,757 $ 2,045,255 $ 946,182 $ 15,905,801 TOTAL ALL FUNDS 15,014.81 $ 792,686,129 $ 149,999,180 $ 155,773,964 $ 66,132,871 $ 1,164,592,144 Regular Staff 14,508.06 785,996,795 149,999,180 155,773,964 65,624,615 1,157,394,554 Temporary Staff 506.75 6,689,334 - - 508,256 7,197,590 Salaries/Hourly includes OT and are net of budgeted vacancy savings Retirement Costs include ASRS LTC Regular FTE count is exclusive of positions that expire before the end of FY 2018 Retirement is net of budgeted vacancy savings Healthcare is net of budgeted vacancy savings Other Benefits includes FICA/Medicare/Workers Comp/Unemployment Comp and is net of budgeted vacancy savings 29