Extracted text (via pymupdf_layout)
70298 characters
Maricopa County FY 2018 Adopted 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 22 Economic Development, Non Profits, and Agricultural Extension 23 Auditor General Forms Summary 24 Auditor General Forms – Schedule G 25 2 Motion Budget Adoption 1) Pursuant to A.R.S. §§ 42-17101 and 42-17105, adopt the Fiscal Year 2018 Maricopa County Budget in the amount of $2,490,087,419 by total appropriation, for each department, fund and appropriation unit group listed in the attached schedules. This amount represents a reduction of $4,246,386 from the Tentative Budget of $2,494,333,805; also 2) Adopt the Five Year Capital Improvement Plan for Fiscal Years 2018-2022; also 3) 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). Approval of the FY 2018 Budget includes the allocations for Economic Development Agencies, Non- Profit Organizations and Agricultural Extension as specified in the Adopted Budget Package and any amendments put forward at the time of budget adoption. 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 Licenses & Permits 1,342,771 41,751,645 - - - 43,094,416 - 43,094,416 6150 Grants - 131,222,198 - - - 131,222,198 - 131,222,198 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 24,774,144 - - 2,336,234 44,380,331 - 44,380,331 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 Fund Charges - - - - 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,255,425 - - 433,000 6,590,567 - 6,590,567 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 - 215,799,653 19,959,846 21,183,032 - 256,942,531 (256,942,531) - Total Operating Sources $ 1,308,944,795 $ 845,534,283 $ 19,959,846 $ 21,183,032 $ 240,225,816 $ 2,435,847,772 $ (461,909,366) $ 1,973,938,406 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 Intergovernmental - 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 - 5,886,659 - - - 5,886,659 - 5,886,659 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 $ 8,332,808 $ 104,806,843 $ 390,755,155 $ 5,223,616 $ 524,213,040 $ (373,073,396) $ 151,139,644 Total Sources $ 1,324,039,413 $ 853,867,091 $ 124,766,689 $ 411,938,187 $ 245,449,432 $ 2,960,060,812 $ (834,982,762) $ 2,125,078,050 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 Use of Funds Operating Personnel $ 577,657,861 $ 518,397,045 $ - $ - $ 15,730,480 $ 1,111,785,386 $ - $ 1,111,785,386 Supplies 13,391,338 45,097,172 - - 11,454,146 69,942,656 (4,972,694) 64,969,962 Services 457,353,520 216,968,383 - - 221,205,039 895,526,942 (199,994,141) 695,532,801 Capital 5,400,322 6,783,455 18,399,600 - 40,000 30,623,377 - 30,623,377 Transfers Out 255,141,754 1,800,777 - - - 256,942,531 (256,942,531) - Total Operating Uses $ 1,308,944,795 $ 789,046,832 $ 18,399,600 $ - $ 248,429,665 $ 2,364,820,892 $ (461,909,366) $ 1,902,911,526 Non Recurring Personnel $ 11,967,133 $ 3,359,674 $ - $ 4,328,773 $ 175,321 $ 19,830,901 $ - $ 19,830,901 Supplies 830,879 2,681,568 - 270,769 527,888 4,311,104 - 4,311,104 Services 47,379,498 23,915,330 - 11,764,260 366,225 83,425,313 - 83,425,313 Capital 9,984,284 8,263,818 113,535,678 346,998,495 826,300 479,608,575 - 479,608,575 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 $ 113,770,927 $ 113,711,816 $ 581,129,076 $ 1,895,734 $ 960,249,289 $ (373,073,396) $ 587,175,893 - - Total Uses $ 1,458,686,531 $ 902,817,759 $ 132,111,416 $ 581,129,076 $ 250,325,399 $ 3,325,070,181 $ (834,982,762) $ 2,490,087,419 - - - - Structural Balance $ - $ 56,487,451 $ 1,560,246 $ 21,183,032 $ (8,203,849) $ 71,026,880 $ - $ 71,026,880 - - Ending Fund Balance $ - $ 113,517,587 $ 18,455,602 $ 661,886,979 $ 24,164,984 $ 818,025,152 $ - $ 818,025,152 Restricted $ - $ 96,848,274 $ 18,455,602 $ 200,895,981 $ 25,309,427 $ 341,509,284 $ - $ 341,509,284 Committed $ - $ 18,858,953 $ - $ 460,990,998 $ 2,860,950 $ 482,710,901 $ - $ 482,710,901 Unassigned $ - $ (2,189,640) $ - $ - $ (4,005,393) $ (6,195,033) $ - $ (6,195,033) 6 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted JUDICIAL D110 ADULT PROBATION 100 GENERAL Non Recurring Non Project $ 54,000 $ 54,000 $ 54,000 $ - Operating 50,970,130 52,087,521 54,898,535 2,811,014 All Appropriations $ 51,024,130 $ 52,141,521 $ 54,952,535 $ 2,811,014 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 34,810,341 (278,520) All Appropriations $ 34,572,666 $ 35,115,861 $ 34,972,341 $ (143,520) D110 Total $ 101,968,190 $ 103,745,094 $ 105,909,367 $ 2,164,273 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) 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,451,657 $ 777,037 All Appropriations $ 34,219,259 $ 34,674,620 $ 35,451,657 $ 777,037 7 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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,237,493 $ 586,545 D800 SUPERIOR COURT - 100 GENERAL - Disaster Rec Equipment $ 337,000 $ 337,000 $ - $ (337,000) Disaster Recovery 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 87,141,746 4,266,092 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 $ 89,120,801 $ 2,407,714 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 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 MAINTENANCE 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 $ 105,526,927 $ (821,982) Total Judicial $ 289,238,590 $ 295,880,222 $ 297,462,244 $ 1,582,022 8 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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 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,585,796 $ (159,356) All Appropriations $ 1,719,187 $ 1,745,152 $ 1,585,796 $ (159,356) D140 Total $ 1,719,187 $ 1,745,152 $ 1,585,796 $ (159,356) 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,635,508 504,105 All Appropriations $ 35,192,277 $ 35,625,944 $ 36,235,508 $ 609,564 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) 9 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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,611,085 $ 1,037,991 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) 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) 10 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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) 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 $ 1,002,488 $ 228,088 Operating 3,792,689 3,792,689 3,740,646 (52,043) All Appropriations $ 4,567,089 $ 4,567,089 $ 4,743,134 $ 176,045 D360 Total $ 6,889,536 $ 6,912,426 $ 9,576,748 $ 2,664,322 D370 COUNTY SCHOOL SUPERINTENDENT - 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 790 EDUCATIONAL SUPPLEMENTAL PROGRAM - Non Recurring Non Project $ - $ - $ 374,059 $ 374,059 Operating - - 495,594 495,594 All Appropriations $ - $ - $ 869,653 $ 869,653 795 EDUCATIONAL SUPPLEMENTAL PROGRAM - Non Recurring Non Project $ 310,510 $ 310,510 $ - $ (310,510) Operating 566,275 566,275 - (566,275) All Appropriations $ 876,785 $ 876,785 $ - $ (876,785) 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,245,463 181,585 Treasurer Printing & Postage 899,140 899,140 899,140 - All Appropriations $ 5,907,713 $ 5,998,018 $ 6,144,603 $ 146,585 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,448,944 $ 146,585 11 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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 102,626,261 4,141,256 All Appropriations $ 109,683,397 $ 118,760,497 $ 125,855,319 $ 7,094,822 203 SHERIFF DONATIONS - Non Recurring Non Project $ - $ - $ 160,000 $ 160,000 Operating 33,969 33,969 60,000 26,031 All Appropriations $ 33,969 $ 33,969 $ 220,000 $ 186,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 222,447,249 5,767,425 All Appropriations $ 218,619,446 $ 216,679,824 $ 223,054,449 $ 6,374,625 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,050,627 $ 9,623,251 Total Elected $ 601,020,979 $ 613,163,614 $ 617,131,616 $ 3,968,002 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 12 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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,475,879 $ 569,535 Single Audit - - 225,000 225,000 All Appropriations $ 2,855,401 $ 2,906,344 $ 3,700,879 $ 794,535 249 NON-DEPARTMENTAL GRANTS - Non Recurring Non Project $ - $ - $ 200,000 $ 200,000 All Appropriations $ - $ - $ 200,000 $ 200,000 D180 Total $ 2,855,401 $ 2,906,344 $ 3,900,879 $ 994,535 D200 COUNTY MANAGER - 100 GENERAL - Operating $ 2,648,433 $ 2,677,972 $ 4,209,961 $ 1,531,989 All Appropriations $ 2,648,433 $ 2,677,972 $ 4,209,961 $ 1,531,989 249 NON-DEPARTMENTAL GRANTS - Non Recurring Non Project $ 326,455 $ 1,745,617 $ - $ (1,745,617) All Appropriations $ 326,455 $ 1,745,617 $ - $ (1,745,617) D200 Total $ 2,974,888 $ 4,423,589 $ 4,209,961 $ (213,628) 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 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,720,143 $ 177,991 All Appropriations $ 3,522,248 $ 3,542,152 $ 3,720,143 $ 177,991 13 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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,164,965 (240,965) All Appropriations $ 64,480,524 $ 65,322,320 $ 65,038,572 $ (283,748) 292 CORRECTIONAL HEALTH GRANTS - Operating $ - $ - $ 339,377 $ 339,377 All Appropriations $ - $ - $ 339,377 $ 339,377 D260 Total $ 68,002,772 $ 68,864,472 $ 69,098,092 $ 233,620 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,407,302 1,083,720 All Appropriations $ 10,398,183 $ 10,687,891 $ 11,646,982 $ 959,091 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,696,982 $ 989,603 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) 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) 14 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted D310 HUMAN RESOURCES - 100 GENERAL - 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) One Time Bus Card Replacement - - 11,500 11,500 Operating 4,262,723 4,331,532 4,535,092 203,560 Recognition Program - - 10,000 10,000 Tuition Reimbursement - - 1,000,000 1,000,000 All Appropriations $ 4,475,633 $ 4,559,459 $ 8,083,137 $ 3,523,678 D310 Total $ 4,475,633 $ 4,559,459 $ 8,083,137 $ 3,523,678 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) 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 Entprise Data Cntr 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 15 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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 547,951,287 28,602,342 All Appropriations $ 659,299,928 $ 644,502,901 $ 674,302,329 $ 29,799,428 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,864,619 $ 5,821,659 $ (7,042,960) Operating 13,112,063 13,047,268 5,009,567 (8,037,701) All Appropriations $ 16,020,975 $ 25,911,887 $ 10,831,226 $ (15,080,661) 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 7,628,995 3,096,659 All Appropriations $ 44,747,293 $ 40,061,046 $ 40,590,911 $ 529,865 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,611,307 $ 515,853 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,817,286 $ (4,164,504) 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 Cntr 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 Professional Standards Bureau - - 3,300,000 3,300,000 16 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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 - (21,708,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) 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,577,696 $ 1,307,703,079 $ 156,125,383 17 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted D490 BUDGET - 100 GENERAL - Operating $ 2,431,156 $ 2,465,697 $ 1,927,528 $ (538,169) All Appropriations $ 2,431,156 $ 2,465,697 $ 1,927,528 $ (538,169) D490 Total $ 2,431,156 $ 2,465,697 $ 1,927,528 $ (538,169) 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 18 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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 - Bridge Preservation $ 90,000 $ - $ - $ - 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 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 19 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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) D850 AIR QUALITY - 100 GENERAL - Air Qual Monitoring Equip NRNP $ 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 20 Appropriated Expenditures and Other Uses by Department, Fund and Appropriation Unit Group (continued) FY 2017 FY 2017 FY 2018 Revised vs. Adopted Revised Adopted Adopted 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) 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 1,400,838 963,882 All Appropriations $ 904,383 $ 906,063 $ 1,782,483 $ 876,420 249 NON-DEPARTMENTAL GRANTS - Operating $ 68,459 $ 912,544 $ 849,000 $ (63,544) All Appropriations $ 68,459 $ 912,544 $ 849,000 $ (63,544) 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 $ 2,237,675 $ 3,052,042 $ 814,367 Total Appointed 2,161,079,837 2,151,338,343 2,363,199,563 211,861,220 ELIMINATIONS D980 ELIMINATIONS COUNTY - 900 ELIMINATIONS - Non Recurring Non Project $ (234,137,282) $ (241,505,706) $ (325,796,638) $ (84,290,932) Operating (461,194,148) (456,498,675) (461,909,366) (5,410,691) All Appropriations $ (695,331,430) $ (698,004,381) $ (787,706,004) $ (89,701,623) D980 Total $ (695,331,430) $ (698,004,381) $ (787,706,004) $ (89,701,623) Total Eliminations $ (695,331,430) $ (698,004,381) $ (787,706,004) $ (89,701,623) TOTAL MARICOPA COUNTY $ 2,356,007,976 $ 2,362,377,798 $ 2,490,087,419 $ 127,709,621 21 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 Professional Standards Bureau - - 3,300,000 - - - - 3,300,000 3,300,000 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 - - - - - - 21,999,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 22 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 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 Economic Development, Non Profits, and Agricultural Extension Economic Development Agency FY 2017 FY 2017 FY 2018 Supported Program Revised Forecast Adopted Greater Phoenix Economic Council Industry Prospecting and Regional Promotion $ 573,675 $ 573,675 $ 629,808 Greater Phoenix Convention & Visitors Bureau Convention & Tourism Destination Marketing 222,431 222,431 222,431 Greater Phoenix Chamber of Commerce Phoenix Forward Initiative 146,805 146,805 146,805 Economic Development Funding $ 942,911 $ 942,911 $ 999,044 Agency FY 2017 FY 2017 FY 2018 Supported Program Revised Forecast Adopted International Genomics Consortium* To put Maricopa County in the Forefront of the Bio-Industry $ 1,000,000 $ 1,000,000 $ 1,000,000 Economic Development Related Funding $ 1,000,000 $ 1,000,000 $ 1,000,000 *5 year agreement for $1,000,000 per year beginning in FY2018 Agricultural Extension Agency FY 2017 FY 2017 FY 2018 Supported Program Revised Forecast Adopted University of Arizona Cooperative Extension Maricopa County Cooperative Extension $ 230,000 $ 230,000 $ 241,500 Total Agricultural Extension Funding $ 230,000 $ 230,000 $ 241,500 23 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,598.81 $ 1,131,616,287 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,018.31 $ 1,162,230,902 24 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,950.63 $ 391,732,112 $ 89,697,727 $ 77,254,059 $ 30,941,096 $ 589,624,994 Regular Staff 7,587.99 389,383,580 89,697,727 77,254,059 30,761,433 587,096,799 Temporary Staff 362.64 2,348,532 - - 179,663 2,528,195 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 673,575 77,465 219,443 52,741 1,023,224 207 - Palo Verde 6.00 342,815 51,027 123,463 31,844 549,149 208 - Judicial Enhancement 14.00 673,870 77,167 159,586 53,457 964,080 209 - Public Defender Training 3.00 142,968 16,440 34,202 10,943 204,553 211 - Adult Probation Grants 24.00 1,087,554 144,048 213,788 86,512 1,531,902 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,179,122 135,695 442,558 100,112 1,857,487 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 322,282 129,575 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,752,936 1,572,047 3,375,759 1,143,222 19,843,964 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 - Juvnile Probation Grants 39.00 1,971,862 408,052 389,120 150,891 2,919,925 228 - Juvneile 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 188,509 3,208,249 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,046,428 380,922 6,133,256 253 - Ballpark Operationg 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 211,588,327 36,845,847 41,622,377 18,300,521 308,357,072 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 37,786 22,798 8,054 160,137 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,146 34,197 12,738 232,620 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,512,498 237,759 364,768 86,796 2,201,821 265 - Public Health Fees 62.00 3,002,524 345,355 753,515 230,759 4,332,153 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 221,853 84,427 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,564,105 179,887 447,848 133,511 2,325,351 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 18,791,090 2,369,789 4,631,131 1,581,982 27,373,992 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,800 813,362 406,808 7,132,868 782 - School Communication 12.00 686,744 79,034 114,606 55,053 935,437 790 - Educational Supplemental Program 8.00 540,907 62,188 82,985 41,135 727,215 991 - Flood Control 188.00 11,360,346 1,196,881 2,048,392 849,006 15,454,625 25 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 - Judical Enhancement 6.00 159,726 12,219 171,945 211 - Adult Probation Grants 5.50 262,677 20,095 282,772 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 Operationg 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,961 1,575,503 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 $ 382,755,118 $ 58,346,151 $ 77,172,267 $ 32,297,798 $ 550,571,334 4,295,431 - - 325,157 4,620,588 DEBT SERVICE FUNDS 378,459,687 58,346,151 77,172,267 31,972,641 545,950,746 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 PERMANENT FUNDS Total Permanent Funds - $ - $ - $ - $ - $ - ENTERPRISE FUNDS Total Enterprise Funds - $ - $ - $ - $ - $ - 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,018.31 $ 790,635,047 $ 149,952,697 $ 157,069,485 $ 64,573,673 $ 1,162,230,902 Regular Staff 14,512.56 783,951,038 149,952,697 157,069,485 64,065,790 1,155,039,010 Temporary Staff 505.75 6,684,009 - - 507,883 7,191,892 11,558,561 40,046 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 26