FY 2017 ADOPTED PACKET COUNTY.PDF
Extracted text (via pymupdf_layout)
64145 characters
Maricopa County FY 2017 Adopted Budget Table of Contents Motion 1 Executive Summary 2 Consolidated Sources, Uses and Fund Balance by Fund Type 3 Appropriated Expenditures and Other Uses by Department, Fund and Function Class 4 Capital Improvement Program 18 Economic Development, Non Profits, and Agricultural Extension 20 Auditor General Forms Summary and Schedules 21 Maricopa County FY 2017 Adopted Budget Motion Budget Adoption 1) Adopt the FY 2017 Budget in the amount of $2,356,007,976 by total appropriation for each department, fund and function class listed in the attached schedules. This amount represents no change from the FY 2017 Tentative Budget of $2,356,007,976, except those minor modifications as noted in the public hearing. 2) Approve the attached Executive Summary. Page 1 of 22 Maricopa County FY 2017 Adopted Budget 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 function, 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 function, as requested and approved by the County Manager, without any further Board approval. c) The appropriated budgets for all employee benefits internal service funds administered by the Employee Benefits and Health department are considered one appropriation. Any and all employee benefits internal service fund appropriations within Employee Benefits and Health department can be transferred between any and all funds by function as requested, upon review and recommendation of the Office of Management and Budget and approval by the County Manager, without any further approval by the Board of Supervisors. d) The budgets for Operating Major Maintenance Projects will be appropriated at the department, fund and function category rather than department, fund and function class. e) Authorize the Office of Management and Budget to validate and approve an incoming JV in the last month of the fiscal year for an elected or judicial department that is unable to achieve their budgeted vacancy savings. The amount will be the lesser of the projected expenditure overrun or the unachievable vacancy savings. 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 2017 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. Page 2 of 22 Maricopa County FY 2017 Adopted Budget Consolidated Sources, Uses and Fund Balance by Fund Type SPECIAL DEBT CAPITAL INTERNAL GENERAL REVENUE SERVICE PROJECTS SERVICE SUBTOTAL ELIMINATIONS TOTAL BEGINNING FUND BALANCE $ 133,944,163 $ 132,906,884 $ 19,691,150 $946,250,675 $ 16,597,557 $1,249,390,429 $ - $1,249,390,429 SOURCES OF FUNDS OPERATING PROPERTY TAXES $ 500,147,476 $ - $ - $ - $ - $ 500,147,476 $ - $ 500,147,476 TAX PENALTIES & INTEREST 7,519,586 - - - - 7,519,586 - 7,519,586 SALES TAXES - 149,670,043 - - - 149,670,043 - 149,670,043 LICENSES AND PERMITS 2,329,936 39,531,300 - - - 41,861,236 - 41,861,236 GRANTS - 156,952,708 - - - 156,952,708 - 156,952,708 OTHER INTERGOVERNMENTAL 2,393,521 14,375,636 - - - 16,769,157 - 16,769,157 PAYMENTS IN LIEU OF TAXES 13,659,917 - - - - 13,659,917 - 13,659,917 STATE SHARED SALES TAX 516,863,039 - - - - 516,863,039 - 516,863,039 STATE SHARED HIGHWAY USER REV - 106,154,321 - - - 106,154,321 - 106,154,321 STATE SHARED VEHICLE LICENSE 149,955,458 10,769,580 - - - 160,725,038 - 160,725,038 INTERGOV CHARGES FOR SERVICES 18,624,116 33,496,842 - - 4,662,059 56,783,017 - 56,783,017 OTHER CHARGES FOR SERVICES 26,101,214 69,038,627 - - 28,596,699 123,736,540 - 123,736,540 INTERNAL SERVICE CHARGES - - - - 205,447,397 205,447,397 (205,447,397) - PATIENT SERVICES REVENUE 6,988 2,460,757 - - - 2,467,745 - 2,467,745 FINES & FORFEITS 10,372,054 13,454,834 - - - 23,826,888 - 23,826,888 INTEREST EARNINGS 2,400,000 838,319 - - 524,938 3,763,257 - 3,763,257 MISCELLANEOUS REVENUE 2,504,000 5,931,457 - - 33,000 8,468,457 - 8,468,457 GAIN ON FIXED ASSETS - 250,000 - - - 250,000 - 250,000 TRANSFERS IN - 214,322,323 14,992,954 26,431,474 - 255,746,751 (255,746,751) - TOTAL OPERATING SOURCES $1,252,877,305 $ 817,246,747 $ 14,992,954 $ 26,431,474 $239,264,093 $2,350,812,573 $(461,194,148) $1,889,618,425 NON RECURRING GRANTS - 713,617 - 7,713,620 - 8,427,237 - 8,427,237 OTHER INTERGOVERNMENTAL 1,913,301 - - - - 1,913,301 - 1,913,301 INTERGOV CHARGES FOR SERVICES 8,007 - - 10,371,914 - 10,379,921 - 10,379,921 OTHER CHARGES FOR SERVICES - 1,046 - - - 1,046 - 1,046 INTEREST EARNINGS - 750,774 - 200 - 750,974 - 750,974 MISCELLANEOUS REVENUE - 65,000 - - - 65,000 - 65,000 PROCEEEDS FROM FINANCING 5,156,400 5,715,440 - 168,120,251 - 178,992,091 - 178,992,091 TRANSFERS IN 12,104,659 112,473 125,199,086 139,394,957 3,517,901 280,329,076 (280,329,076) - TOTAL NON RECURRING SOURCES $ 19,182,367 $ 7,358,350 $125,199,086 $325,600,942 $ 3,517,901 $ 480,858,646 $(280,329,076) $ 200,529,570 TOTAL SOURCES $1,272,059,672 $ 824,605,097 $140,192,040 $352,032,416 $242,781,994 $2,831,671,219 $(741,523,224) $2,090,147,995 USES OF FUNDS OPERATING PERSONAL SERVICES $ 549,836,366 $ 514,732,860 $ - $ - $ 14,957,115 $1,079,526,341 $ - $1,079,526,341 SUPPLIES 14,077,219 45,565,074 - - 11,928,279 71,570,572 (6,412,224) 65,158,348 SERVICES 429,825,054 205,466,775 - - 218,994,507 854,286,336 (199,035,173) 655,251,163 CAPITAL 5,206,321 6,179,768 13,353,000 - 65,000 24,804,089 - 24,804,089 OTHER FINANCING USES 253,932,345 1,814,406 - - - 255,746,751 (255,746,751) - TOTAL OPERATING USES $1,252,877,305 $ 773,758,883 $ 13,353,000 $ - $245,944,901 $2,285,934,089 $(461,194,148) $1,824,739,941 NON RECURRING PERSONAL SERVICES $ 98,198 $ 3,386,934 $ - $ 5,042,052 $ 258,188 $ 8,785,372 $ - $ 8,785,372 SUPPLIES 1,580,802 1,991,605 - 2,050 50,000 3,624,457 - 3,624,457 SERVICES 60,086,165 41,524,071 - 14,126,615 2,218,209 117,955,060 - 117,955,060 CAPITAL 1,795,731 5,938,518 118,428,210 274,468,187 272,500 400,903,146 - 400,903,146 OTHER FINANCING USES 89,565,634 69,997,124 - 120,766,318 - 280,329,076 (280,329,076) - TOTAL NON RECURRING USES $ 153,126,530 $ 122,838,252 $118,428,210 $414,405,222 $ 2,798,897 $ 811,597,111 $(280,329,076) $ 531,268,035 TOTAL USES $1,406,003,835 $ 896,597,135 $131,781,210 $414,405,222 $248,743,798 $3,097,531,200 $(741,523,224) $2,356,007,976 STRUCTURAL BALANCE $ - $ 43,487,864 $ 1,639,954 $ 26,431,474 $ (6,680,808) $ 64,878,484 $ - $ 64,878,484 ENDING FUND BALANCE: RESTRICTED $ - $ 67,017,922 $ 7,414,230 $391,152,466 $ 45,403,730 $ 510,988,348 $ - $ 510,988,348 COMMITTED - 14,220,891 20,687,750 492,725,403 2,557,158 530,191,202 - 530,191,202 UNASSIGNED - (20,323,967) - - (37,325,135) (57,649,102) - (57,649,102) Page 3 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. JUDICIAL 110 ADULT PROBATION 100 GENERAL OPERATING $ 49,084,413 $ 48,184,413 $ 50,970,130 $ (2,785,717) NON RECURRING NON PROJECT 171,000 171,000 54,000 117,000 ALL FUNCTIONS $ 49,255,413 $ 48,355,413 $ 51,024,130 $ (2,668,717) 201 ADULT PROBATION FEES OPERATING $ 12,343,549 $ 12,343,549 $ 12,743,611 $ (400,062) NON RECURRING NON PROJECT 428,787 428,787 820,000 (391,213) ALL FUNCTIONS $ 12,772,336 $ 12,772,336 $ 13,563,611 $ (791,275) 211 ADULT PROBATION GRANTS OPERATING $ 3,171,370 $ 3,247,199 $ 2,807,783 $ 439,416 255 DETENTION OPERATIONS OPERATING $ 33,803,153 $ 33,803,153 $ 34,545,666 $ (742,513) NON RECURRING NON PROJECT 55,800 55,800 27,000 28,800 ALL FUNCTIONS $ 33,858,953 $ 33,858,953 $ 34,572,666 $ (713,713) TOTAL DEPARTMENT $ 99,058,072 $ 98,233,901 $ 101,968,190 $ (3,734,289) 240 JUSTICE COURTS 100 GENERAL OPERATING $ 17,825,008 $ 17,825,008 $ 17,812,231 $ 12,777 ELEC DOCUMENT MGMNT SYSTEM 512,000 512,000 - 512,000 NON RECURRING NON PROJECT - - 500,327 (500,327) ALL FUNCTIONS $ 18,337,008 $ 18,337,008 $ 18,312,558 $ 24,450 204 JUSTICE CT JUDICIAL ENHANCEMNT OPERATING $ 737,183 $ 737,183 $ 737,183 $ - 237 JUST COURTS PHOTO ENFORCEMENT NON RECURRING NON PROJECT $ - $ - 9,000 (9,000) 245 JUSTICE COURTS SPECIAL REVENUE OPERATING $ 6,379,000 $ 6,379,000 $ 6,664,653 $ (285,653) NON RECURRING NON PROJECT 105,250 105,250 100,000 5,250 ALL FUNCTIONS $ 6,484,250 $ 6,484,250 $ 6,764,653 $ (280,403) TOTAL DEPARTMENT $ 25,558,441 $ 25,558,441 $ 25,823,394 $ (264,953) 270 JUVENILE PROBATION 100 GENERAL OPERATING $ 17,872,534 $ 16,767,534 $ 17,154,428 $ (386,894) 227 JUVENILE PROBATION GRANTS OPERATING $ 3,811,356 $ 3,951,405 $ 3,811,356 $ 140,049 228 JUVENILE PROBATION SPECIAL FEE OPERATING $ 2,669,777 $ 2,669,777 $ 2,669,777 $ - NON RECURRING NON PROJECT 388,353 388,353 410,888 (22,535) ALL FUNCTIONS $ 3,058,130 $ 3,058,130 $ 3,080,665 $ (22,535) 229 JUVENILE RESTITUTION OPERATING $ 4,000 $ 4,000 $ 4,000 $ - NON RECURRING NON PROJECT - - 6,007 (6,007) ALL FUNCTIONS $ 4,000 $ 4,000 $ 10,007 $ (6,007) 255 DETENTION OPERATIONS OPERATING $ 33,607,736 $ 33,607,736 $ 34,219,259 $ (611,523) ALL FUNCTIONS $ 33,607,736 $ 33,607,736 $ 34,219,259 $ (611,523) 275 JUVENILE PROBATION DIVERSION OPERATING $ 214,095 $ 214,095 $ 214,095 $ - NON RECURRING NON PROJECT 175,915 175,915 174,502 1,413 ALL FUNCTIONS $ 390,010 $ 390,010 $ 388,597 $ 1,413 TOTAL DEPARTMENT $ 58,743,766 $ 57,778,815 $ 58,664,312 $ (885,497) Page 4 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 800 SUPERIOR COURT 100 GENERAL DISASTER REC EQUIPMENT $ - $ - $ 97,933 $ (97,933) OPERATING 83,111,344 85,151,380 81,854,793 3,296,587 NON RECURRING NON PROJECT 245,926 245,926 3,000 242,926 DISASTER REC EQUIPMENT 668,000 668,000 337,000 331,000 SUP COURT CASE MGMT SYSTEM 1,899,500 1,899,500 1,899,500 - SUP CT FOR THE RECORD EQUIP 1,500,000 1,500,000 1,500,000 - ALL FUNCTIONS $ 87,424,770 $ 89,464,806 $ 85,692,226 $ 3,772,580 208 JUDICIAL ENHANCEMENT OPERATING $ 476,000 $ 476,000 $ 499,000 $ (23,000) NON RECURRING NON PROJECT 29,901 29,901 - 29,901 ALL FUNCTIONS $ 505,901 $ 505,901 $ 499,000 $ 6,901 238 SUPERIOR COURT GRANTS OPERATING $ 3,432,507 $ 3,899,566 $ 3,432,507 $ 467,059 256 PROBATE FEES OPERATING $ 392,000 $ 392,000 $ 392,000 $ - NON RECURRING NON PROJECT 138,756 138,756 50,000 88,756 ALL FUNCTIONS $ 530,756 $ 530,756 $ 442,000 $ 88,756 257 CONCILIATION COURT FEES OPERATING $ 1,372,000 $ 1,372,000 $ 1,583,362 $ (211,362) NON RECURRING NON PROJECT 206,566 206,566 - 206,566 ALL FUNCTIONS $ 1,578,566 $ 1,578,566 $ 1,583,362 $ (4,796) 259 SUPERIOR COURT SPECIAL REVENUE OPERATING $ 4,598,154 $ 4,598,154 $ 4,881,783 $ (283,629) NON RECURRING NON PROJECT 696,603 696,603 246,371 450,232 ALL FUNCTIONS $ 5,294,757 $ 5,294,757 $ 5,128,154 $ 166,603 261 LAW LIBRARY OPERATING $ 1,165,971 $ 1,165,971 $ 1,165,971 $ - NON RECURRING NON PROJECT - 2,063,093 - 2,063,093 ALL FUNCTIONS $ 1,165,971 $ 3,229,064 $ 1,165,971 $ 2,063,093 264 SUPERIOR COURT FILL THE GAP OPERATING $ 2,218,728 $ 2,202,900 $ 2,202,900 $ - 271 EXPEDITED CHILD SUPPORT OPERATING $ 600,000 $ 600,000 $ 677,500 $ (77,500) NON RECURRING NON PROJECT 113,621 113,621 - 113,621 ALL FUNCTIONS $ 713,621 $ 713,621 $ 677,500 $ 36,121 276 SPOUSAL MAINT ENF ENHANCEMENT OPERATING $ 99,000 $ 99,000 $ 108,000 $ (9,000) NON RECURRING NON PROJECT 9,000 9,000 - 9,000 ALL FUNCTIONS $ 108,000 $ 108,000 $ 108,000 $ - 280 SUPERIOR COURT BUILDING REPAIR NON RECURRING NON PROJECT $ - $ 412,619 $ 1,650,474 $ (1,237,855) 281 CHILDRENS ISSUES EDUCATION OPERATING $ 105,000 $ 105,000 $ - $ 105,000 NON RECURRING NON PROJECT 10,007 10,007 - 10,007 ALL FUNCTIONS $ 115,007 $ 115,007 $ - $ 115,007 282 DOM REL MEDIATION EDUCATION OPERATING $ 180,600 $ 180,600 $ 200,600 $ (20,000) ALL FUNCTIONS $ 180,600 $ 180,600 $ 200,600 $ (20,000) TOTAL DEPARTMENT $ 103,269,184 $ 108,236,163 $ 102,782,694 $ 5,453,469 TOTAL JUDICIAL $ 286,629,463 $ 289,807,320 $ 289,238,590 $ 568,730 ELECTED 010 BOARD OF SUPERVISORS DIST 1 100 GENERAL OPERATING $ 370,718 $ 370,718 $ 376,999 $ (6,281) 020 BOARD OF SUPERVISORS DIST 2 100 GENERAL OPERATING $ 370,718 $ 370,718 $ 376,999 $ (6,281) Page 5 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 030 BOARD OF SUPERVISORS DIST 3 100 GENERAL OPERATING $ 370,718 $ 370,718 $ 376,999 $ (6,281) 040 BOARD OF SUPERVISORS DIST 4 100 GENERAL OPERATING $ 370,718 $ 370,718 $ 376,999 $ (6,281) 050 BOARD OF SUPERVISORS DIST 5 100 GENERAL OPERATING $ 370,718 $ 370,718 $ 376,999 $ (6,281) 120 ASSESSOR 100 GENERAL OPERATING $ 24,132,164 $ 24,132,164 $ 24,026,441 $ 105,723 140 CALL CENTER 100 GENERAL OPERATING $ 1,719,187 $ 1,719,187 $ 1,719,187 $ - 160 CLERK OF THE SUPERIOR COURT 100 GENERAL OPERATING $ 33,364,056 $ 33,364,056 $ 33,626,550 $ (262,494) NON RECURRING NON PROJECT 12,000 12,000 - 12,000 COSC RFR SYSTEM REPLACEMENT 2,292,400 2,215,727 1,565,727 650,000 ALL FUNCTIONS $ 35,668,456 $ 35,591,783 $ 35,192,277 $ 399,506 205 COURT DOCUMENT RETRIEVAL OPERATING $ 1,064,545 $ 1,064,545 $ 1,034,000 $ 30,545 NON RECURRING NON PROJECT 85,396 85,396 159,993 (74,597) ALL FUNCTIONS $ 1,149,941 $ 1,149,941 $ 1,193,993 $ (44,052) 208 JUDICIAL ENHANCEMENT OPERATING $ 700,746 $ 700,746 $ 900,000 $ (199,254) NON RECURRING NON PROJECT - - 602,000 (602,000) ALL FUNCTIONS $ 700,746 $ 700,746 $ 1,502,000 $ (801,254) 216 CLERK OF THE COURT GRANTS OPERATING $ 1,484,286 $ 1,484,286 $ 1,446,855 $ 37,431 218 CLERK OF COURT FILL THE GAP OPERATING $ 1,915,696 $ 1,944,794 $ 1,905,898 $ 38,896 NON RECURRING NON PROJECT - 83,655 - 83,655 ALL FUNCTIONS $ 1,915,696 $ 2,028,449 $ 1,905,898 $ 122,551 270 CHILD SUPPORT ENHANCEMENT NON RECURRING NON PROJECT $ - $ - $ 20,000 $ (20,000) 273 VICTIM LOCATION NON RECURRING NON PROJECT $ 75,000 $ 75,000 $ 15,000 $ 60,000 274 CLERK OF THE COURT EDMS OPERATING $ 2,448,571 $ 2,448,571 $ 2,500,000 $ (51,429) TOTAL DEPARTMENT $ 43,442,696 $ 43,478,776 $ 43,776,023 $ (297,247) 190 COUNTY ATTORNEY 100 GENERAL OPERATING $ 85,548,461 $ 85,548,461 $ 87,639,468 $ (2,091,007) 213 COUNTY ATTORNEY RICO OPERATING $ 1,910,940 $ 1,910,940 $ 1,879,086 $ 31,854 NON RECURRING NON PROJECT - 1,500,000 - 1,500,000 ALL FUNCTIONS $ 1,910,940 $ 3,410,940 $ 1,879,086 $ 1,531,854 219 COUNTY ATTORNEY GRANTS OPERATING $ 5,351,226 $ 5,868,595 $ 6,490,942 $ (622,347) Page 6 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 220 DIVERSION OPERATING $ 1,792,874 $ 1,792,874 $ 1,713,350 $ 79,524 NON RECURRING NON PROJECT 774,662 774,662 758,656 16,006 ALL FUNCTIONS $ 2,567,536 $ 2,567,536 $ 2,472,006 $ 95,530 221 COUNTY ATTORNEY FILL THE GAP OPERATING $ 1,527,206 $ 1,527,206 $ 1,494,911 $ 32,295 266 CHECK ENFORCEMENT PROGRAM OPERATING $ 125,048 $ 125,048 $ 72,302 $ 52,746 NON RECURRING NON PROJECT - - 53,038 (53,038) ALL FUNCTIONS $ 125,048 $ 125,048 $ 125,340 $ (292) 267 CRIM JUSTICE ENHANCEMENT OPERATING $ 1,377,000 $ 1,377,000 $ 1,239,649 $ 137,351 NON RECURRING NON PROJECT 196,727 196,727 262,633 (65,906) ALL FUNCTIONS $ 1,573,727 $ 1,573,727 $ 1,502,282 $ 71,445 268 VICTIM COMP RESTITUTION OPERATING $ 111,600 $ 111,600 $ 164,759 $ (53,159) ALL FUNCTIONS $ 111,600 $ 111,600 $ 164,759 $ (53,159) 269 VICTIM COMPENSATION INTEREST OPERATING $ 16,516 $ 16,516 $ 19,756 $ (3,240) ALL FUNCTIONS $ 16,516 $ 16,516 $ 19,756 $ (3,240) TOTAL DEPARTMENT $ 98,732,260 $ 100,749,629 $ 101,788,550 $ (1,038,921) 210 ELECTIONS 100 GENERAL OPERATING $ 9,018,145 $ 9,018,145 $ 9,164,929 $ (146,784) PRI/GEN ELEC CYCLE SPENDING 4,329,156 9,707,544 12,104,659 (2,397,115) NON RECURRING NON PROJECT - - 1,913,301 (1,913,301) ALL FUNCTIONS $ 13,347,301 $ 18,725,689 $ 23,182,889 $ (4,457,200) 248 ELECTIONS GRANTS OPERATING $ 470,278 $ 973,494 $ 406,750 $ 503,216 TOTAL DEPARTMENT $ 13,817,579 $ 19,699,183 $ 23,589,639 $ (3,890,456) 250 CONSTABLES 100 GENERAL OPERATING $ 3,076,881 $ 3,076,881 $ 3,242,537 $ (165,656) NON RECURRING NON PROJECT - 6,333 - 6,333 TOTAL DEPARTMENT $ 3,076,881 $ 3,083,214 $ 3,242,537 $ (159,323) 360 RECORDER 100 GENERAL OPERATING $ 2,185,621 $ 2,185,621 $ 2,322,447 $ (136,826) 236 RECORDERS SURCHARGE OPERATING $ 3,792,689 $ 3,792,689 $ 3,792,689 $ - NON RECURRING NON PROJECT 1,698,269 1,698,269 774,400 923,869 ALL FUNCTIONS $ 5,490,958 $ 5,490,958 $ 4,567,089 $ 923,869 TOTAL DEPARTMENT $ 7,676,579 $ 7,676,579 $ 6,889,536 $ 787,043 370 EDUCATION SERVICE 100 GENERAL OPERATING $ 2,630,770 $ 2,630,770 $ 2,722,933 $ (92,163) GARNISHMENT SYSTEM UPGRADE 280,000 280,000 260,000 20,000 ALL FUNCTIONS $ 2,910,770 $ 2,910,770 $ 2,982,933 $ (72,163) 255 DETENTION OPERATIONS NON RECURRING NON PROJECT $ - $ 838,219 $ 679,906 $ 158,313 669 SMALL SCHOOL SERVICE OPERATING $ 109,551 $ 109,551 $ 109,551 $ - NON RECURRING NON PROJECT 58,221 58,221 - 58,221 ALL FUNCTIONS $ 167,772 $ 167,772 $ 109,551 $ 58,221 Page 7 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 715 SCHOOL GRANTS OPERATING $ 24,960,910 $ 25,168,410 $ 24,494,498 $ 673,912 NON RECURRING NON PROJECT 440,974 764,971 - 764,971 ALL FUNCTIONS $ 25,401,884 $ 25,933,381 $ 24,494,498 $ 1,438,883 780 SCHOOL TRANSPORTATION OPERATING $ 600,000 $ 600,000 $ 600,000 $ - 782 SCHOOL COMMUNICATION OPERATING $ 665,000 $ 690,157 $ 521,000 $ 169,157 NON RECURRING NON PROJECT 204,575 204,575 582,065 (377,490) ALL FUNCTIONS $ 869,575 $ 894,732 $ 1,103,065 $ (208,333) 795 EDUCATIONAL SUPPLEMENTAL PROG OPERATING $ 566,275 $ 566,275 $ 566,275 $ - NON RECURRING NON PROJECT 562,600 562,600 310,510 252,090 ALL FUNCTIONS $ 1,128,875 $ 1,128,875 $ 876,785 $ 252,090 TOTAL DEPARTMENT $ 31,078,876 $ 32,473,749 $ 30,846,738 $ 1,627,011 430 TREASURER 100 GENERAL OPERATING $ 5,059,279 $ 5,059,279 $ 4,973,573 $ 85,706 TREASURER PRINTING & POSTAGE - - 899,140 (899,140) NON RECURRING NON PROJECT - - 35,000 (35,000) ALL FUNCTIONS $ 5,059,279 $ 5,059,279 $ 5,907,713 $ (848,434) 741 TAXPAYER INFORMATION OPERATING $ 304,341 $ 304,341 $ 304,341 $ - TOTAL DEPARTMENT $ 5,363,620 $ 5,363,620 $ 6,212,054 $ (848,434) 500 SHERIFF 100 GENERAL OPERATING $ 98,849,320 $ 98,849,320 $ 99,443,516 $ (594,196) MCSO JUDGMENT ORDER OPERATING 14,510,847 14,510,847 10,239,881 4,270,966 MCSO RECORDS MANAGEMENT 676,000 381,426 - 381,426 NON RECURRING NON PROJECT 366,768 301,556 - 301,556 PROPERTY AND EVIDENCE 247,978 247,978 - 247,978 ALL FUNCTIONS $ 114,650,913 $ 114,291,127 $ 109,683,397 $ 4,607,730 203 SHERIFF DONATIONS OPERATING $ 26,774 $ 26,774 $ 33,969 $ (7,195) ALL FUNCTIONS $ 26,774 $ 26,774 $ 33,969 $ (7,195) 206 OFFICER SAFETY EQUIPMENT OPERATING $ 52,000 $ 52,000 $ 52,000 $ - NON RECURRING NON PROJECT - - 300,000 (300,000) ALL FUNCTIONS $ 52,000 $ 52,000 $ 352,000 $ (300,000) 212 SHERIFF RICO OPERATING $ 1,750,000 $ 1,750,000 $ 1,750,000 $ - 214 SHERIFF JAIL ENHANCEMENT OPERATING $ 1,482,444 $ 1,482,444 $ 1,482,444 $ - NON RECURRING NON PROJECT 1,236,498 1,236,498 450,000 786,498 ALL FUNCTIONS $ 2,718,942 $ 2,718,942 $ 1,932,444 $ 786,498 251 SHERIFF GRANTS OPERATING $ 7,184,985 $ 7,596,313 $ 7,624,572 $ (28,259) 252 INMATE SERVICES OPERATING $ 11,250,326 $ 11,250,326 $ 9,596,352 $ 1,653,974 NON RECURRING NON PROJECT - 750,000 6,750,000 (6,000,000) ALL FUNCTIONS $ 11,250,326 $ 12,000,326 $ 16,346,352 $ (4,346,026) 254 INMATE HEALTH SERVICES OPERATING $ 300,873 $ 300,873 $ 369,950 $ (69,077) NON RECURRING NON PROJECT 300,000 300,000 106,620 193,380 ALL FUNCTIONS $ 600,873 $ 600,873 $ 476,570 $ 124,303 Page 8 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 255 DETENTION OPERATIONS OPERATING $ 212,498,230 $ 212,498,230 $ 218,619,446 $ (6,121,216) JAIL KITCHEN EQUIPMENT 340,000 340,000 - 340,000 LAUNDRY EQUIPMENT 397,000 397,000 - 397,000 MCSO IVR 905,000 905,000 - 905,000 ALL FUNCTIONS $ 214,140,230 $ 214,140,230 $ 218,619,446 $ (4,479,216) 258 SHERIFF TOWING AND IMPOUND OPERATING $ 226,100 $ 226,100 $ 211,100 $ 15,000 NON RECURRING NON PROJECT - - 15,429 (15,429) ALL FUNCTIONS $ 226,100 $ 226,100 $ 226,529 $ (429) TOTAL DEPARTMENT $ 352,601,143 $ 353,402,685 $ 357,045,279 $ (3,642,594) TOTAL ELECTED $ 583,494,575 $ 593,632,376 $ 601,020,979 $ (7,388,603) APPOINTED 060 CLERK OF THE BOARD 100 GENERAL OPERATING $ 1,210,792 $ 1,210,792 $ 1,245,373 $ (34,581) SIRE HYLAND CONVERSION - - 213,619 (213,619) NON RECURRING NON PROJECT 213,619 213,619 - 213,619 TOTAL DEPARTMENT $ 1,424,411 $ 1,424,411 $ 1,458,992 $ (34,581) 150 EMERGENCY MANAGEMENT 100 GENERAL OPERATING $ 250,989 $ 250,989 $ 253,651 $ (2,662) 207 PALO VERDE OPERATING $ 682,808 $ 682,808 $ 706,722 $ (23,914) NON RECURRING NON PROJECT 78,031 78,031 85,264 (7,233) ALL FUNCTIONS $ 760,839 $ 760,839 $ 791,986 $ (31,147) 215 EMERGENCY MANAGEMENT OPERATING $ 963,826 $ 1,038,625 $ 951,853 $ 86,772 NON RECURRING NON PROJECT 90,601 203,601 67,162 136,439 ALL FUNCTIONS $ 1,054,427 $ 1,242,226 $ 1,019,015 $ 223,211 TOTAL DEPARTMENT $ 2,066,255 $ 2,254,054 $ 2,064,652 $ 189,402 180 FINANCE 100 GENERAL OPERATING $ 2,855,401 $ 2,855,401 $ 2,855,401 $ - 200 COUNTY MANAGER 100 GENERAL OPERATING $ 2,577,919 $ 2,577,919 $ 2,648,433 $ (70,514) 249 NON DEPARTMENTAL GRANTS NON RECURRING NON PROJECT $ 5,000 $ 1,623,576 $ 326,455 $ 1,297,121 TOTAL DEPARTMENT $ 2,582,919 $ 4,201,495 $ 2,974,888 $ 1,226,607 220 HUMAN SERVICES 100 GENERAL OPERATING $ 2,260,912 $ 2,260,912 $ 2,260,912 $ - NON RECURRING NON PROJECT 120,000 120,000 122,796 (2,796) ALL FUNCTIONS $ 2,380,912 $ 2,380,912 $ 2,383,708 $ (2,796) 217 CDBG HOUSING TRUST OPERATING $ 20,143,632 $ 20,143,632 $ 6,231,776 $ 13,911,856 222 HUMAN SERVICES GRANTS OPERATING $ 45,246,229 $ 53,613,125 $ 51,497,289 $ 2,115,836 TOTAL DEPARTMENT $ 67,770,773 $ 76,137,669 $ 60,112,773 $ 16,024,896 Page 9 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 230 INTERNAL AUDIT 100 GENERAL OPERATING $ 1,855,357 $ 1,855,357 $ 1,888,018 $ (32,661) 260 CORRECTIONAL HEALTH 100 GENERAL OPERATING $ 3,289,967 $ 3,307,802 $ 3,522,248 $ (214,446) 255 DETENTION OPERATIONS CHS GRAVES JUDGMENT OPERATING $ 2,332,585 $ 2,332,585 $ 3,780,639 $ (1,448,054) OPERATING 61,297,272 61,310,900 60,587,412 723,488 IRON MOUNTAIN RECORDS PROJECTS - - 112,473 (112,473) ALL FUNCTIONS $ 63,629,857 $ 63,643,485 $ 64,480,524 $ (837,039) TOTAL DEPARTMENT $ 66,919,824 $ 66,951,287 $ 68,002,772 $ (1,051,485) 290 MEDICAL EXAMINER 100 GENERAL OPERATING $ 8,573,553 $ 8,701,063 $ 10,033,874 $ (1,332,811) NON RECURRING NON PROJECT 217,948 217,948 - 217,948 OME CASE MANAGEMENT - - 232,800 (232,800) OME CASE RECORDS - - 131,509 (131,509) ALL FUNCTIONS $ 8,791,501 $ 8,919,011 $ 10,398,183 $ (1,479,172) 224 MEDICAL EXAMINER GRANTS OPERATING $ - $ 8,406 $ 8,851 $ (445) TOTAL DEPARTMENT $ 8,791,501 $ 8,927,417 $ 10,407,034 $ (1,479,617) 300 PARKS AND RECREATION 100 GENERAL OPERATING $ 564,802 $ 564,802 $ 874,325 $ (309,523) NON RECURRING NON PROJECT 50,000 121,169 50,000 71,169 PARKS PLAYGROUNDS UPGRADES 168,000 168,000 - 168,000 PARKS RESTROOMS UPGRADES 392,000 392,000 350,000 42,000 PARKS WATER UPGRADES 85,000 53,869 - 53,869 ALL FUNCTIONS $ 1,259,802 $ 1,299,840 $ 1,274,325 $ 25,515 225 SPUR CROSS RANCH CONSERVATION OPERATING $ 275,359 $ 275,359 $ 272,132 $ 3,227 NON RECURRING NON PROJECT 130,250 130,250 163,075 (32,825) ALL FUNCTIONS $ 405,609 $ 405,609 $ 435,207 $ (29,598) 230 PARKS AND RECREATION GRANTS NON RECURRING NON PROJECT $ 13,990 $ 13,990 $ 34,696 $ (20,706) 239 PARKS SOUVENIR OPERATING $ 362,544 $ 362,544 $ 396,182 $ (33,638) 240 LAKE PLEASANT RECREATION SVCS OPERATING $ 2,719,236 $ 2,719,236 $ 2,640,393 $ 78,843 NON RECURRING NON PROJECT 744,600 744,600 1,264,809 (520,209) PARKS PLAYGROUNDS UPGRADES 33,600 33,600 - 33,600 PARKS RESTROOMS UPGRADES 336,000 336,000 - 336,000 ALL FUNCTIONS $ 3,833,436 $ 3,833,436 $ 3,905,202 $ (71,766) 241 PARKS ENHANCEMENT FUND OPERATING $ 4,671,308 $ 4,671,308 $ 4,893,687 $ (222,379) NON RECURRING NON PROJECT 689,937 689,937 1,775,340 (1,085,403) PARKS RESTROOMS UPGRADES 616,000 616,000 342,000 274,000 ALL FUNCTIONS $ 5,977,245 $ 5,977,245 $ 7,011,027 $ (1,033,782) 243 PARKS DONATIONS OPERATING $ 23,277 $ 23,277 $ 25,404 $ (2,127) NON RECURRING NON PROJECT 300,960 300,960 468,166 (167,206) ALL FUNCTIONS $ 324,237 $ 324,237 $ 493,570 $ (169,333) 900 ELIMINATIONS OPERATING $ - $ - $ - $ - TOTAL DEPARTMENT $ 12,176,863 $ 12,216,901 $ 13,550,209 $ (1,333,308) Page 10 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 310 HUMAN RESOURCES 100 GENERAL LEARNING MANAGEMENT OPER $ - $ 185,800 $ - $ 185,800 OPERATING 3,985,245 3,806,445 4,262,723 (456,278) JOB ANALYSIS CONSULTANT 385,000 353,680 202,910 150,770 LEARNING MANAGEMENT 70,000 70,000 10,000 60,000 TOTAL DEPARTMENT $ 4,440,245 $ 4,415,925 $ 4,475,633 $ (59,708) 340 PUBLIC FIDUCIARY 100 GENERAL OPERATING $ 3,201,348 $ 3,302,783 $ 3,857,641 $ (554,858) 390 EMPLOYEE BENEFITS AND HEALTH 100 GENERAL OPERATING $ 270,537 $ 270,537 $ 276,946 $ (6,409) 532 PUBLIC HEALTH GRANTS OPERATING $ 7,935,127 $ 7,935,127 $ 7,891,088 $ 44,039 601 MEDICAL HMO OPERATING $ 52,845,683 $ 52,845,683 $ 52,886,919 $ (41,236) 604 MEDICAL PPO OPERATING $ 39,659,466 $ 39,659,466 $ 40,883,745 $ (1,224,279) 606 MEDICAL HDHP W HSA OPERATING $ 26,029,963 $ 26,029,963 $ 26,684,781 $ (654,818) 607 FI DENTAL PPO OPERATING $ 4,702,760 $ 4,702,760 $ 5,176,907 $ (474,147) 608 COINSURANCE PHARMACY OPERATING $ 18,072,572 $ 18,072,572 $ 22,131,797 $ (4,059,225) 611 60 PERCENT STD OPERATING $ 2,207,008 $ 2,207,008 $ 2,107,539 $ 99,469 612 50 PERCENT STD OPERATING $ 408,473 $ 408,473 $ 530,448 $ (121,975) 613 40 PERCENT STD OPERATING $ 161,260 $ 161,260 $ 203,520 $ (42,260) 614 BEHAVIORAL HEALTH OPERATING $ 1,760,590 $ 1,760,590 $ 1,536,123 $ 224,467 615 WELLNESS OPERATING $ 1,556,248 $ 1,556,248 $ 1,561,473 $ (5,225) NON RECURRING NON PROJECT 625,000 625,000 300,400 324,600 ALL FUNCTIONS $ 2,181,248 $ 2,181,248 $ 1,861,873 $ 319,375 618 BENEFIT ADMINISTRATION OPERATING $ 3,005,916 $ 3,005,916 $ 3,005,916 $ - NON RECURRING NON PROJECT - - 200,000 (200,000) ALL FUNCTIONS $ 3,005,916 $ 3,005,916 $ 3,205,916 $ (200,000) 619 ONSITE PHARMACY CLINIC OPERATING $ 2,003,810 $ 2,003,810 $ 2,079,812 $ (76,002) 620 BENEFITS ELIMINATIONS OPERATING $ (1,157,990) $ (1,157,990) $ (1,157,990) $ - 621 FLEX SPENDING HEALTH OPERATING $ 2,269,651 $ 2,269,651 $ 2,362,430 $ (92,779) 622 FLEX SPENDING DEP CARE OPERATING $ 801,620 $ 801,620 $ 1,009,392 $ (207,772) 623 VISION OPERATING $ 1,735,553 $ 1,735,553 $ 1,713,648 $ 21,905 625 FI PREPAID DENTAL OPERATING $ 225,977 $ 225,977 $ 224,239 $ 1,738 626 FI LIFE AND AD AND D OPERATING $ 597,992 $ 597,992 $ 632,580 $ (34,588) 627 SUPPLEMENTAL LIFE OPERATING $ 3,471,236 $ 3,471,236 $ 3,949,284 $ (478,048) 628 EMPLOYEE ASSISTANCE OPERATING $ 420,963 $ 420,963 $ 420,354 $ 609 Page 11 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) 629 SI DENTAL PPO OPERATING $ 4,530,902 $ 4,530,902 $ 4,285,030 $ 245,872 630 DEPENDENT LIFE OPERATING $ 345,300 $ 345,300 $ 415,704 $ (70,404) 631 VOLUNTARY BENEFITS OPERATING $ 683,838 $ 683,838 $ 731,400 $ (47,562) TOTAL DEPARTMENT $ 175,169,455 $ 175,169,455 $ 182,043,485 $ (6,874,030) 410 ENTERPRISE TECHNOLOGY 100 GENERAL OPERATING $ 11,193,593 $ 11,193,593 $ 10,632,051 $ 561,542 MAJOR MAINTENANCE OPERATING 14,976,798 15,678,798 14,992,342 686,456 ADVANTAGE 2X HOSTING CHARGES 1,153,944 1,153,944 280,000 873,944 CONTENT MANAGEMENT SYSTEM WEB 1,250,000 1,250,000 985,629 264,371 CYBER SECURITY NRNP 3,585,000 3,446,942 2,116,703 1,330,239 DESKTOP LAPTOP REPLACEMENT 250,000 956,073 100,000 856,073 VMWARE NON RECURRING 1,382,000 1,390,007 - 1,390,007 CYBER SECURITY MAJOR MAINT 185,149 185,149 259,000 (73,851) ENTPRISE DATA CNTR SYSTEMS 4,606,700 4,512,816 2,797,017 1,715,799 TELEPHONY MAJOR MAINT 565,000 565,000 - 565,000 NON RECURRING NON PROJECT - - 1,335,475 (1,335,475) ALL FUNCTIONS $ 39,148,184 $ 40,332,322 $ 33,498,217 $ 6,834,105 255 DETENTION OPERATIONS OPERATING $ 986,484 $ 986,484 $ 984,584 $ 1,900 DESKTOP LAPTOP REPLACEMENT 15,000 15,000 - 15,000 NON RECURRING NON PROJECT 150,000 150,000 - 150,000 ALL FUNCTIONS $ 1,151,484 $ 1,151,484 $ 984,584 $ 166,900 681 TECHNOLOGY INFRASTRUCTURE OPERATING $ 17,069,304 $ 17,069,304 $ 21,636,326 $ (4,567,022) NON RECURRING NON PROJECT 1,952,154 1,952,154 1,204,547 747,607 ALL FUNCTIONS $ 19,021,458 $ 19,021,458 $ 22,840,873 $ (3,819,415) TOTAL DEPARTMENT $ 59,321,126 $ 60,505,264 $ 57,323,674 $ 3,181,590 420 INTEGRATED CRIM JUSTICE INFO 255 DETENTION OPERATIONS OPERATING $ 1,656,954 $ 1,656,954 $ 1,674,309 $ (17,355) NON RECURRING NON PROJECT 74,033 74,033 - 74,033 TOTAL DEPARTMENT $ 1,730,987 $ 1,730,987 $ 1,674,309 $ 56,678 440 PLANNING AND DEVELOPMENT 100 GENERAL OPERATING $ 868,232 $ 868,232 $ 868,232 $ - 226 PLANNING AND DEVELOPMENT FEES OPERATING $ 8,001,694 $ 8,001,694 $ 8,001,694 $ - NON RECURRING NON PROJECT 177,097 927,097 532,127 394,970 ALL FUNCTIONS $ 8,178,791 $ 8,928,791 $ 8,533,821 $ 394,970 TOTAL DEPARTMENT $ 9,047,023 $ 9,797,023 $ 9,402,053 $ 394,970 470 NON DEPARTMENTAL 100 GENERAL MCSO JUDGMENT ORDER OPERATING $ 5,023,124 $ 5,023,124 $ 3,023,124 $ 2,000,000 OPERATING 470,437,283 468,953,467 536,740,433 (67,786,966) MCSO JUDGMENT ORDER NON RECURRING 4,350,000 4,350,000 - 4,350,000 NON RECURRING NON PROJECT 50,423,670 49,749,110 119,536,371 (69,787,261) ALL FUNCTIONS $ 530,234,077 $ 528,075,701 $ 659,299,928 $ (131,224,227) 210 WASTE MANAGEMENT NON RECURRING NON PROJECT $ 653,328 $ 654,183 $ 688,762 $ (34,579) Page 12 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 249 NON DEPARTMENTAL GRANTS OPERATING $ 6,500,000 $ 6,486,730 $ 13,112,063 $ (6,625,333) NON RECURRING NON PROJECT 30,591,664 23,245,661 2,908,912 20,336,749 ALL FUNCTIONS $ 37,091,664 $ 29,732,391 $ 16,020,975 $ 13,711,416 255 DETENTION OPERATIONS OPERATING $ 3,336,407 $ 3,322,779 $ 9,218,583 $ (5,895,804) CHS GRAVES JUDGMENT NON RECURRING 500,000 500,000 400,000 100,000 NON RECURRING NON PROJECT 35,539,740 26,019,715 35,128,710 (9,108,995) ALL FUNCTIONS $ 39,376,147 $ 29,842,494 $ 44,747,293 $ (14,904,799) 320 COUNTY IMPROVEMENT DEBT OPERATING $ - $ - $ 13,353,000 $ (13,353,000) NON RECURRING NON PROJECT 7,409,480 16,131,464 106,615,480 (90,484,016) ALL FUNCTIONS $ 7,409,480 $ 16,131,464 $ 119,968,480 $ (103,837,016) 321 CAPITAL LEASE DEBT SERVICE DESKTOP LAPTOP REPLACEMENT $ - $ 3,845,477 $ 2,926,394 $ 919,083 NON RECURRING NON PROJECT 2,171,297 2,832,370 7,555,569 (4,723,199) VMWARE NON RECURRING - 1,330,811 1,330,767 44 ALL FUNCTIONS $ 2,171,297 $ 8,008,658 $ 11,812,730 $ (3,804,072) 422 INTERGOVERNMENTAL CAP PROJ VULTURE MOUNTAIN $ 127,500 $ 127,500 $ 123,300 $ 4,200 440 COUNTY IMPROVEMENT COMPUTER AIDED MASS APPRAISAL $ 7,701,827 $ 8,226,990 $ 7,677,886 $ 549,104 COUNTY TELEPHONE SYSTEM 14,458,269 10,848,323 5,392,330 5,455,993 ENTERPRISE DATA CTNR CT 14,388,694 8,149,030 4,983,247 3,165,783 ENTERPRISE RES PLANNING SYSTEM 12,469,551 11,831,665 6,453,753 5,377,912 INFRASTRUCTURE REFRESH PH I 1,393,288 1,373,586 73,586 1,300,000 INFRASTRUCTURE REFRESH PH II 17,544,011 9,969,973 4,558,781 5,411,192 JAIL KITCHEN EQUIPMENT 300,000 300,000 300,000 - JAIL MGMT INFORMATION SYSTEM 6,692,086 6,161,831 8,893,241 (2,731,410) JAIL SECURITY SYSTEM UPGRADE 4,591,960 4,340,445 2,663,250 1,677,195 PUBLIC SAFETY RADIO 58,031,609 57,994,638 35,241,579 22,753,059 SOUTHWEST JUSTICE COURTS 23,413,814 22,659,357 21,150,541 1,508,816 ALL FUNCTIONS $ 160,985,109 $ 141,855,838 $ 97,388,194 $ 44,467,644 441 GENERAL FUND CTY IMPROV 441 MADISON STREET JAIL ADAP PHASE $ - $ - $ 17,600,000 $ (17,600,000) 445 GENERAL FUND CTY IMPROV NON RECURRING NON PROJECT $ 5,242,821 $ 14,185,805 $ 18,104,659 $ (3,918,854) ADULT PROBATION BLACK CANYON - - 3,000,000 (3,000,000) ADULT PROBATION SOUTHPORT - - 3,000,000 (3,000,000) BUCKEYE HILLS RANGE ELECTRIC - - 1,751,294 (1,751,294) CHAMBERS BUILDING 2,127,591 2,336,500 1,590,787 745,713 EAST COURT IMPROVEMENTS 4,699,814 4,644,671 7,000,000 (2,355,329) MARICOPA REGIONAL TRAIL SYSTEM 557,173 728,191 532,889 195,302 HASSAYAMPA - - 1,000,000 (1,000,000) SHERIFF HQ PROJECT 476,731 464,333 452,148 12,185 VULTURE MOUNTAIN 42,751 42,751 217,751 (175,000) WEST COURT IMPROVEMENTS 944,182 944,182 385,000 559,182 PROJECT RESERVE - - 377,978 (377,978) ALL FUNCTIONS $ 14,091,063 $ 23,346,433 $ 37,412,506 $ (14,066,073) 455 DETENTION CAPITAL PROJECTS NON RECURRING NON PROJECT $ 153,031 $ 153,031 $ - $ 153,031 4TH AVENUE JAIL 1,201,805 1,182,218 - 1,182,218 INTAKE TRANSFER RELEASE JAIL 10,000,000 10,000,000 31,000,000 (21,000,000) LOWER BUCKEYE JAIL 1,296,001 1,315,851 - 1,315,851 ALL FUNCTIONS $ 12,650,837 $ 12,651,100 $ 31,000,000 $ (18,348,900) Page 13 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 460 TECHNOLOGY CAP IMPROVEMENT DESKTOP LAPTOP REPLACEMENT $ - $ 4,659,490 $ 2,959,125 $ 1,700,365 NON RECURRING NON PROJECT 8,074,562 8,074,562 99,375,000 (91,300,438) VMWARE NON RECURRING - 4,503,283 - 4,503,283 BIX ROOM BYTE INFO EXCHANGE 4,374,901 4,068,713 2,785,275 1,283,438 INFRASTRUCTURE REFRESH PH II - - 2,452,744 (2,452,744) PROJECT RESERVE 8,441,465 5,436,316 - 5,436,316 TREASURER TECH SYSTEM UPGRADE 755,434 3,760,583 18,751,162 (14,990,579) ALL FUNCTIONS $ 21,646,362 $ 30,502,947 $ 126,323,306 $ (95,820,359) 461 DETENTION TECH CAP IMPROVEMENT DESKTOP LAPTOP REPLACEMENT $ - $ 237,788 $ 162,534 $ 75,254 NON RECURRING NON PROJECT 1,106,989 1,106,989 3,286,659 (2,179,670) CHS ELECTRONIC HEALTH RECORDS 2,455,284 2,707,859 887,527 1,820,332 PROJECT RESERVE 2,382,062 2,382,062 - 2,382,062 ALL FUNCTIONS $ 5,944,335 $ 6,434,698 4,336,720 2,097,978 462 INTERGOVERNMENTAL TECH PROJECT DESKTOP LAPTOP REPLACEMENT $ - $ 145,108 $ - $ 145,108 VMWARE NON RECURRING - 236,898 - 236,898 ALL FUNCTIONS $ - $ 382,006 - 382,006 TOTAL DEPARTMENT $ 832,381,199 $ 827,745,413 $ 1,166,722,194 $ (338,976,781) 490 MANAGEMENT AND BUDGET 100 GENERAL OPERATING $ 2,431,156 $ 2,431,156 $ 2,431,156 $ - 520 PUBLIC DEFENDER 100 GENERAL OPERATING $ 40,490,466 $ 40,490,466 $ 41,570,118 $ (1,079,652) ALL FUNCTIONS $ 40,490,466 $ 40,490,466 $ 41,570,118 $ (1,079,652) 209 PUBLIC DEFENDER TRAINING OPERATING $ 330,198 $ 330,198 $ 271,108 $ 59,090 NON RECURRING NON PROJECT 185,932 185,932 66,702 119,230 ALL FUNCTIONS $ 516,130 $ 516,130 $ 337,810 $ 178,320 233 PUBLIC DEFENDER GRANTS OPERATING $ 237,289 $ 237,289 $ 222,141 $ 15,148 262 PUBLIC DEFENDER FILL THE GAP OPERATING $ 805,134 $ 805,134 $ 775,462 $ 29,672 PDS CASE MANAGEMENT SYSTEM 206,261 206,261 38,008 168,253 ALL FUNCTIONS $ 1,011,395 $ 1,011,395 $ 813,470 $ 197,925 TOTAL DEPARTMENT $ 42,255,280 $ 42,255,280 $ 42,943,539 $ (688,259) 540 LEGAL DEFENDER 100 GENERAL OPERATING $ 13,258,636 $ 13,258,636 $ 13,436,322 $ (177,686) NON RECURRING NON PROJECT - - - - ALL FUNCTIONS $ 13,258,636 $ 13,258,636 $ 13,436,322 $ (177,686) 209 PUBLIC DEFENDER TRAINING OPERATING $ 57,244 $ 57,244 $ 54,378 $ 2,866 NON RECURRING NON PROJECT 58,828 58,828 14,999 43,829 ALL FUNCTIONS $ 116,072 $ 116,072 $ 69,377 $ 46,695 263 LEGAL DEFENDER FILL THE GAP OPERATING $ 66,362 $ 66,362 $ 66,362 $ - TOTAL DEPARTMENT $ 13,441,070 $ 13,441,070 $ 13,572,061 $ (130,991) 550 LEGAL ADVOCATE 100 GENERAL OPERATING $ 12,055,425 $ 12,055,425 $ 12,046,888 $ 8,537 209 PUBLIC DEFENDER TRAINING OPERATING $ 17,168 $ 17,168 $ 20,627 $ (3,459) NON RECURRING NON PROJECT 8,800 8,800 14,387 (5,587) ALL FUNCTIONS $ 25,968 $ 25,968 $ 35,014 $ (9,046) TOTAL DEPARTMENT $ 12,081,393 $ 12,081,393 $ 12,081,902 $ (509) Page 14 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 560 CONTRACT COUNSEL 100 GENERAL OPERATING $ 51,891,419 $ 51,891,419 $ 51,658,915 $ 232,504 NON RECURRING NON PROJECT 3,652,470 3,652,470 2,828,092 824,378 TOTAL DEPARTMENT $ 55,543,889 $ 55,543,889 $ 54,487,007 $ 1,056,882 570 PUBLIC ADVOCATE 100 GENERAL OPERATING $ 9,441,291 $ 9,441,291 $ 9,297,577 $ 143,714 640 TRANSPORTATION 223 TRANSPORTATION GRANTS NON RECURRING NON PROJECT $ 250,939 $ 346,828 $ 320,000 $ 26,828 232 TRANSPORTATION OPERATIONS OPERATING $ 59,822,918 $ 59,822,918 $ 63,501,718 $ (3,678,800) NON RECURRING NON PROJECT 71,057,232 71,057,232 58,489,784 12,567,448 ALL FUNCTIONS $ 130,880,150 $ 130,880,150 $ 121,991,502 $ 8,888,648 234 TRANSPORTATION CAPITAL PROJECT MAG ALCP PROJECTS $ 26,939,800 $ 17,739,800 $ 26,194,639 $ (8,454,839) COUNTY ARTERIALS 10,626,000 11,326,000 23,305,233 (11,979,233) BRIDGE CONST/PRESERVATION 1,779,000 1,779,000 90,000 1,689,000 DUST MITIGATION 11,211,000 11,211,000 6,243,887 4,967,113 INTELLIGENT TRANS SYST ITS 4,186,800 4,186,800 4,067,000 119,800 PAVEMENT CONST/PRESERVATION 16,988,740 21,988,740 11,384,319 10,604,421 PARTNERSHIP SUPPORT 2,709,000 3,209,000 2,045,000 1,164,000 RIGHT-OF-WAY 158,000 1,158,000 250,000 908,000 SAFETY PROJECTS 5,754,000 5,754,000 18,585,000 (12,831,000) TRANSPORTATION ADMINISTRATION 6,536,230 6,536,230 - 6,536,230 TRAFFIC IMPROVEMENTS 5,802,000 7,802,000 8,056,118 (254,118) TRANSPORTATION PLANNING 1,680,000 1,680,000 - 1,680,000 ALL FUNCTIONS $ 94,370,570 $ 94,370,570 $ 100,221,196 $ (5,850,626) 900 ELIMINATIONS NON RECURRING NON PROJECT $ (70,403,183) $ (70,403,183) $ (46,191,794) $ (24,211,389) TOTAL DEPARTMENT $ 155,098,476 $ 155,194,365 $ 176,340,904 $ (21,146,539) 670 WASTE RESOURCES AND RECYCLING 100 GENERAL OPERATING $ 2,991,384 $ 2,991,384 $ 4,186,564 $ (1,195,180) WASTE RES EROSION CONTROL 120,000 120,000 - 120,000 WASTE RES LANDFILL DRAINAGE 50,000 50,000 - 50,000 WASTE RES GAS PROBE EQUIP 70,000 70,000 - 70,000 ALL FUNCTIONS $ 3,231,384 $ 3,231,384 $ 4,186,564 $ (955,180) 290 WASTE TIRE OPERATING $ 4,751,611 $ 4,751,611 $ 4,751,611 $ - NON RECURRING NON PROJECT - 100,000 - 100,000 ALL FUNCTIONS $ 4,751,611 $ 4,851,611 $ 4,751,611 $ 100,000 TOTAL DEPARTMENT $ 7,982,995 $ 8,082,995 $ 8,938,175 $ (855,180) 700 FACILITIES MANAGEMENT 100 GENERAL OPERATING $ 34,006,424 $ 34,006,424 $ 38,098,140 $ (4,091,716) MAJOR MAINTENANCE OPERATING 7,877,906 7,877,906 7,877,906 - NON RECURRING NON PROJECT 52,804 52,804 139,321 (86,517) CENTRAL COURT BLDG 3,772,524 3,578,759 - 3,578,759 LIFE SAFETY PROJECTS - 100,000 - 100,000 EMERGENCY SVCS ADMIN IMP - 221,000 - 221,000 ALL FUNCTIONS $ 45,709,658 $ 45,836,893 $ 46,115,367 $ (278,474) Page 15 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 255 DETENTION OPERATIONS OPERATING $ 19,333,033 $ 19,333,033 $ 19,387,545 $ (54,512) NON RECURRING NON PROJECT - - 25,052 (25,052) MAJOR MAINTENANCE OPERATING 6,726,998 6,726,998 6,726,998 - 4TH AVE JAIL MAINTENANCE 435,000 1,100,916 - 1,100,916 LBJ COMPLEX 500,000 953,988 - 953,988 ALL FUNCTIONS $ 26,995,031 $ 28,114,935 $ 26,139,595 $ 1,975,340 TOTAL DEPARTMENT $ 72,704,689 $ 73,951,828 $ 72,254,962 $ 1,696,866 720 PROTECTIVE SERVICES 100 GENERAL OPERATING $ 4,141,089 $ 4,141,089 $ - $ 4,141,089 255 DETENTION OPERATIONS OPERATING $ 48,942 $ 48,942 $ - $ 48,942 TOTAL DEPARTMENT $ 4,190,031 $ 4,190,031 $ - $ 4,190,031 730 PROCUREMENT SERVICES 100 GENERAL OPERATING $ 2,487,658 $ 2,487,658 $ 2,438,032 $ 49,626 673 REPROGRAPHICS OPERATING $ 845,217 $ 845,217 $ 739,834 $ 105,383 NON RECURRING NON PROJECT - - 87,450 (87,450) ALL FUNCTIONS $ 845,217 $ 845,217 $ 827,284 $ 17,933 TOTAL DEPARTMENT $ 3,332,875 $ 3,332,875 $ 3,265,316 $ 67,559 740 EQUIPMENT SERVICES 654 EQUIPMENT SERVICES OPERATING $ 16,854,693 $ 16,854,693 $ 16,854,693 $ - NON RECURRING NON PROJECT 967,500 967,500 1,006,500 (39,000) TOTAL DEPARTMENT $ 17,822,193 $ 17,822,193 $ 17,861,193 $ (39,000) 750 RISK MANAGEMENT 675 RISK MANAGEMENT OPERATING $ 33,338,997 $ 33,338,997 $ 33,338,997 $ - 790 ANIMAL CARE AND CONTROL 100 GENERAL OPERATING $ 258,954 $ 758,954 $ 758,954 $ - 572 ANIMAL CONTROL LICENSE SHELTER OPERATING $ 9,480,584 $ 9,480,584 $ 11,936,923 $ (2,456,339) NON RECURRING NON PROJECT 502,426 537,384 38,806 498,578 ALL FUNCTIONS $ 9,983,010 $ 10,017,968 $ 11,975,729 $ (1,957,761) 573 ANIMAL CONTROL GRANTS NON RECURRING NON PROJECT $ - $ 196,000 $ - $ 196,000 ALL FUNCTIONS $ - $ 196,000 $ - $ 196,000 574 ANIMAL CONTROL FIELD OPERATION OPERATING $ 3,399,773 $ 3,399,773 $ 3,733,360 $ (333,587) NON RECURRING NON PROJECT 345,980 345,980 325,000 20,980 ALL FUNCTIONS $ 3,745,753 $ 3,745,753 $ 4,058,360 $ (312,607) TOTAL DEPARTMENT $ 13,987,717 $ 14,718,675 $ 16,793,043 $ (2,074,368) 850 AIR QUALITY 100 GENERAL OPERATING $ 810,957 $ 810,957 $ 810,957 $ - AIR QUAL MONITORING EQUIP 409,700 409,700 308,080 101,620 ALL FUNCTIONS $ 1,220,657 $ 1,220,657 $ 1,119,037 $ 101,620 503 AIR QUALITY GRANTS OPERATING $ 3,973,521 $ 3,973,521 $ 4,128,306 $ (154,785) Page 16 of 22 Maricopa County FY 2017 Adopted Budget Appropriated Expenditures and Other Uses by Department, Fund and Function Class (continued) FY 2016 FY 2016 FY 2017 (INC.)/DEC ADOPTED REVISED ADOPTED FROM REV. 504 AIR QUALITY FEES OPERATING $ 12,083,397 $ 12,083,397 $ 11,114,786 $ 968,611 NON RECURRING NON PROJECT 2,210,731 2,210,731 2,413,236 (202,505) ALL FUNCTIONS $ 14,294,128 $ 14,294,128 $ 13,528,022 $ 766,106 TOTAL DEPARTMENT $ 19,488,306 $ 19,488,306 $ 18,775,365 $ 712,941 860 PUBLIC HEALTH 100 GENERAL OPERATING $ 11,844,181 $ 11,844,181 $ 11,878,845 $ (34,664) 265 PUBLIC HEALTH FEES OPERATING $ 6,638,299 $ 6,638,299 $ 6,638,299 $ - NON RECURRING NON PROJECT - 715,210 510,592 204,618 ALL FUNCTIONS $ 6,638,299 $ 7,353,509 $ 7,148,891 $ 204,618 532 PUBLIC HEALTH GRANTS OPERATING $ 44,121,225 $ 44,121,225 $ 42,884,495 $ 1,236,730 TOTAL DEPARTMENT $ 62,603,705 $ 63,318,915 $ 61,912,231 $ 1,406,684 880 ENVIRONMENTAL SERVICES 100 GENERAL OPERATING $ 4,026,395 $ 4,026,395 $ 4,152,458 $ (126,063) NON RECURRING NON PROJECT 142,600 142,600 485,587 (342,987) ALL FUNCTIONS $ 4,168,995 $ 4,168,995 $ 4,638,045 $ (469,050) 505 ENVIRONMENTAL SERVICES GRANTS OPERATING $ - $ 70,198 $ 67,198 $ 3,000 506 ENVIRONMTL SVCS ENV HEALTH OPERATING $ 19,383,201 $ 19,383,201 $ 19,166,315 $ 216,886 NON RECURRING NON PROJECT 471,826 471,826 949,243 (477,417) ALL FUNCTIONS $ 19,855,027 $ 19,855,027 $ 20,115,558 $ (260,531) TOTAL DEPARTMENT $ 24,024,022 $ 24,094,220 $ 24,820,801 $ (726,581) 920 DEPUTY COUNTY MANAGER 920 100 GENERAL OPERATING $ 1,473,270 $ 1,473,270 $ 1,473,270 $ - 940 ASSISTANT COUNTY MANAGER 940 100 GENERAL OPERATING $ 295,088 $ 295,088 $ 295,088 $ - 950 ASSISTANT COUNTY MANAGER 950 100 GENERAL OPERATING $ 431,764 $ 424,764 $ 435,276 $ (10,512) NON RECURRING NON PROJECT 529,597 489,950 469,107 20,843 ALL FUNCTIONS $ 961,361 $ 914,714 $ 904,383 $ 10,331 249 NON DEPARTMENTAL GRANTS OPERATING $ 68,459 $ 68,459 $ 68,459 $ - ALL FUNCTIONS $ 68,459 $ 68,459 $ 68,459 $ - 255 DETENTION OPERATIONS OPERATING $ 405,930 $ 405,930 $ 410,680 $ (4,750) TOTAL DEPARTMENT $ 1,435,750 $ 1,389,103 $ 1,383,522 $ 5,581 TOTAL APPOINTED $ 1,804,706,880 $ 1,815,375,782 $ 2,161,079,837 $ (345,704,055) 980 ELIMINATIONS COUNTY 900 ELIMINATIONS OPERATING $ (402,434,555) $ (402,854,203) $ (461,194,148) $ 58,339,945 NON RECURRING NON PROJECT (37,990,530) (44,055,453) (234,137,282) 190,081,829 TOTAL DEPARTMENT $ (440,425,085) $ (446,909,656) $ (695,331,430) $ 248,421,774 TOTAL MARICOPA COUNTY $ 2,234,405,833 $ 2,251,905,822 $ 2,356,007,976 $ (104,102,154) Page 17 of 22 Maricopa County FY 2017 Adopted Budget Capital Improvement Program Intergovernmental and County Improvement Capital Projects - General Fund and Special Revenue Funds 422 INTERGOVERNMENTAL Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total CAP PROJ Actuals FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Total Project MARICOPA REGIONAL TRAIL SYSTEM $ 996,937 $ - $ - $ - $ - $ - $ - $ - $ 996,937 VULTURE MOUNTAIN STUDY 50,001 6,000 123,300 - - - - 123,300 179,301 TOTAL FUND 422 $ 1,046,938 $ 6,000 $ 123,300 $ - $ - $ - $ - $ 123,300 $ 1,176,238 440 COUNTY Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total IMPROVEMENT FUND Actuals FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Total Project COMPUTER AIDED MASS APPRAISAL $ 3,395,938 $ 5,923,921 $ 7,677,886 $ 7,197,847 $ - $ - $ - $ 14,875,733 $ 24,195,592 COUNTY TELEPHONE SYSTEM 6,031,774 5,455,993 5,392,330 - - - - 5,392,330 16,880,097 ENTERPRISE DATA CENTER 11,694,968 3,165,783 4,983,247 - - - - 4,983,247 19,843,998 ENTERPRISE RESOURCE PLANNING SYS 7,374,115 10,531,317 6,453,753 - - - - 6,453,753 24,359,185 INFRASTRUCTURE REFRESH PHASE 1 6,151,879 1,300,000 73,586 - - - - 73,586 7,525,465 INFRASTRUCTURE REFRESH PHASE 2 17,350,227 5,411,192 4,558,781 - - - - 4,558,781 27,320,200 JAIL MGMT INFORMATION SYSTEM 730,252 4,520,745 8,893,241 5,608,676 4,275,543 19,117 - 18,796,577 24,047,574 JAIL KITCHEN EQUIPMENT - - 300,000 - - - - 300,000 300,000 JAIL SECURITY SYSTEM UPGRADE 4,109,778 1,680,903 2,663,250 - - - - 2,663,250 8,453,931 PUBLIC SAFETY RADIO SYSTEM 9,632,227 26,045,818 35,241,579 9,243,768 14,839,080 - - 59,324,427 95,002,472 SOUTHWEST JUSTICE COURTS 1,349,458 7,500,000 21,150,541 - - - - 21,150,541 29,999,999 TOTAL PROJECTS 440 $ 67,820,616 $ 71,535,672 $ 97,388,194 $ 22,050,291 $ 19,114,623 $ 19,117 $ - $ 138,572,225 $ 277,928,513 441 COUNTY Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total IMPROVEMENT 441 Actuals FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Total Project MADISON STREET JAIL ADAPTATION $ - $ - $ 17,600,000 $ 91,100,000 $ 7,300,000 $ - $ - $ 116,000,000 $ 116,000,000 TOTAL PROJECTS 441 $ - $ - $ 17,600,000 $ 91,100,000 $ 7,300,000 $ - $ - $ 116,000,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 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Total Project ADULT PROBATION-BLACK CANYON FAC $ - $ - $ 3,000,000 $ - $ - $ - $ - $ 3,000,000 $ 3,000,000 ADULT PROBATION-SOUTHPORT FAC - - 3,000,000 - - - - 3,000,000 3,000,000 BUCKEYE HILLS RANGE ELECTRIC - - 1,751,294 - - - - 1,751,294 1,751,294 CHAMBERS BUILDING 36,591 2,324,818 1,590,787 - - - - 1,590,787 3,952,196 EAST COURT IMPROVEMENTS 9,760,695 2,644,671 7,000,000 - - - - 7,000,000 19,405,366 HASSAYAMPA - - 1,000,000 - - - - 1,000,000 1,000,000 MARICOPA REGIONAL TRAIL SYSTEM 3,626,930 496,586 532,889 343,595 - - - 876,484 5,000,000 SHERIFF HQ PROJECT 32,647,131 12,185 452,148 - - - - 452,148 33,111,464 SOUTHWEST JUSTICE COURTS 620,246 - - - - - - - 620,246 VULTURE MOUNTAIN 57,249 - 217,751 - - - - 217,751 275,000 WEST COURT IMPROVEMENTS - 559,182 385,000 - - - - 385,000 944,182 TOTAL PROJECTS 445 $ 46,748,842 $ 6,037,442 $ 18,929,869 $ 343,595 $ - $ - $ - $ 19,273,464 $ 72,059,748 PROJECT RESERVE 445 $ - $ - $ 377,978 $ - $ - $ - $ 204,061,295 $ 204,439,273 $ 204,439,273 TOTAL FUND 445 $ 46,748,842 $ 6,037,442 $ 19,307,847 $ 343,595 $ - $ - $ 204,061,295 $ 223,712,737 $ 276,499,021 455 DETENTION CAPITAL Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total PROJECTS Actuals FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Total Project 4TH AVENUE JAIL $ 1,262,780 $ 275,000 $ - $ - $ - $ - $ - $ - $ 1,537,780 INTAKE TRANSFER RELEASE JAIL - 4,000,000 31,000,000 103,000,000 47,000,000 - - 181,000,000 185,000,000 LOWER BUCKEYE JAIL 1,239,147 275,000 - - - - - - 1,514,147 SHERIFF HQ PROJECT 30,000,000 - - - - - - - 30,000,000 TOTAL PROJECTS 455 $ 32,501,927 $ 4,550,000 $ 31,000,000 $ 103,000,000 $ 47,000,000 $ - $ - $ 181,000,000 $ 218,051,927 PROJECT RESERVE 455 $ - $ - $ - $ - $ - $ - $ 49,219,815 $ 49,219,815 $ 49,219,815 TOTAL FUND 455 $ 32,501,927 $ 4,550,000 $ 31,000,000 $ 103,000,000 $ 47,000,000 $ - $ 49,219,815 $ 230,219,815 $ 267,271,742 Technology Capital Improvement Program 460 TECHNOLOGY CAP Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total IMPROVEMENT Actuals FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Total Project BIX ROOM BYTE INFO EXCHANGE $ 430,743 $ 1,283,438 $ 2,785,275 $ - $ - $ - $ - $ 2,785,275 $ 4,499,456 COMPUTER AIDED MASS APPRAISAL 692,132 - - - - - - - 692,132 COUNTY TELEPHONE SYSTEM 12,206,108 - - - - - - - 12,206,108 ENTERPRISE DATA CENTER 25,493,530 - - - - - - - 25,493,530 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,064 - - - - - - - 32,860,064 PUBLIC SAFETY RADIO SYSTEM 36,348,759 - - - - - - - 36,348,759 REFRESH REMOTE SITES PHASE 3 - - 2,452,744 - - - - 2,452,744 2,452,744 SHERIFF HQ PROJECT IT INFRA - - - - - - - - - TREASURER TECH SYSTEM UPGRADE 803,102 3,760,583 18,751,162 10,662,456 1,610,298 - - 31,023,916 35,587,600 TOTAL PROJECTS 460 $ 117,701,057 $ 5,044,021 $ 23,989,181 $ 10,662,456 $ 1,610,298 $ - $ - $ 36,261,935 $ 159,007,012 PROJECT RESERVE 460 $ - $ - $ - $ - $ - $ - $ 38,580,504 $ 38,580,504 $ 38,580,504 TOTAL FUND 460 $ 117,701,057 $ 5,044,021 $ 23,989,181 $ 10,662,456 $ 1,610,298 $ - $ 38,580,504 $ 74,842,439 $ 197,587,516 Page 18 of 22 Maricopa County FY 2017 Adopted Budget Technology Capital Improvement Program (continued) 461 DETENTION TECH CAP Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total IMPROVEMENT Actuals FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Total Project CHS ELECTRONIC HEALTH RECORDS $ 5,643,415 $ 1,707,859 $ 887,527 $ - $ - $ - $ - $ 887,527 $ 8,238,801 JAIL MGMT INFORMATION SYSTEM 1,070,367 - - - - - - - 1,070,367 JAIL SECURITY SYSTEM UPGRADE 22,246,075 - - - - - - - 22,246,075 TOTAL PROJECTS 461 $ 28,959,857 $ 1,707,859 $ 887,527 $ - $ - $ - $ - $ 887,527 $ 31,555,243 PROJECT RESERVE 461 - - - - - - 792,122 792,122 792,122 TOTAL FUND 461 $ 28,959,857 $ 1,707,859 $ 887,527 $ - $ - $ - $ 792,122 $ 1,679,649 $ 32,347,365 Transportation Capital Improvement Program 234 TRANSPORTATION Previous Projected Year 1 Year 2 Year 3 Year 4 Year 5 5-Year Total CAPITAL PROJECT Actuals FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 Total Project BRIDGE CONST/PRESERVATION $ 457,352 $ 209,152 $ 90,000 $ 260,000 $ 1,105,000 $ 880,000 $ - $ 2,335,000 $ 3,001,504 COUNTY ARTERIALS 11,703,686 9,436,082 23,305,233 21,243,824 15,170,474 34,047,337 22,212,496 115,979,364 137,119,132 DUST MITIGATION 750,615 1,207,826 6,243,887 5,394,302 3,963,932 3,978,049 4,768,555 24,348,725 26,307,166 INTELLIGENT TRANS SYST ITS 538,266 717,492 4,067,000 30,000 75,000 55,000 125,000 4,352,000 5,607,758 MAG ALCP PROJECTS 104,273,949 3,023,870 26,194,639 26,823,913 63,009,542 27,574,668 43,575,025 187,177,787 294,475,606 PARTNERSHIP SUPPORT 5,512,027 2,572,000 2,045,000 1,520,000 1,520,000 1,520,000 1,520,000 8,125,000 16,209,027 PAVEMENT CONST/PRESERVATION 1,299,079 3,326,953 11,384,319 17,272,446 16,054,253 16,531,709 18,742,990 79,985,717 84,611,749 RIGHT-OF-WAY 2,289,184 116,838 250,000 100,000 100,000 100,000 100,000 650,000 3,056,022 SAFETY PROJECTS 4,853,802 1,943,967 18,585,000 19,001,000 18,360,000 4,325,000 - 60,271,000 67,068,769 TRAFFIC IMPROVEMENTS 1,555,574 2,365,189 8,056,118 3,709,711 1,409,264 10,584,815 10,220,416 33,980,324 37,901,087 TOTAL FUND 234 $ 133,233,534 $ 24,919,369 $ 100,221,196 $ 95,355,196 $ 120,767,465 $ 99,596,578 $ 101,264,482 $ 517,204,917 $ 675,357,820 Economic Development, Non Profits, and Agricultural Extension Economic Development Agency FY 2016 FY 2016 FY 2017 Supported Program REVISED FORECAST ADOPTED Greater Phoenix Economic Council Industry Prospecting and Regional Promotion $ 573,675 $ 573,675 $ 573,675 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 $ 942,911 Agency FY 2016 FY 2016 FY 2017 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 Silicon Valley Bank** Information Technology and Operations "Center of Excellence" $250,000 $250,000 - Economic Development Related Funding $ 1,250,000 $ 1,250,000 $ 1,000,000 *5 year agreement for $1,000,000 per year beginning in FY2013 **This will be paid in disbursements of $250,000, each based on achievement of performance thresholds. Agricultural Extension Agency FY 2016 FY 2016 FY 2017 Supported Program REVISED FORECAST ADOPTED University of Arizona Cooperative Extension Maricopa County Cooperative Extension $ 230,000 $ 230,000 $ 230,000 Total Agricultural Extension Funding $ 230,000 $ 230,000 $ 230,000 Page 19 of 22 Maricopa County FY 2017 Adopted Budget 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 Schedule G of the forms supplied by the Auditor General. Auditor General Forms Reconciliation for the FY 2017 Adopted Budget Full Time Equivalent Positions (Regular and Temporary) Personnel Costs Maricopa County 14,766.22 $ 1,088,311,713 Maricopa County Flood Control District 188.00 17,826,642 Maricopa County Library District 194.59 11,827,967 Maricopa County Stadium District 5.60 424,972 TOTAL 15,154.41 $ 1,118,391,294 Page 20 of 22 Maricopa County FY 2017 Adopted Budget Maricopa County , Flood Control District, Library District, Stadium District Full-Time Employees and Personnel Compensation Fiscal Year 2017 Full-Time Total Estimated Employee Salaries Equivalent Other Benefit Personnel and Hourly Costs (FTE) Retirement Costs Healthcare Costs Costs Compensation FUND FY 2017 FY 2017 FY 2017 FY 2017 FY 2017 FY 2017 GENERAL FUND 7,918.69 380,015,813 64,489,051 70,189,553 35,240,146 549,934,564 Regular Staff 7,553.13 376,729,674 64,489,051 70,189,553 34,557,525 545,965,804 Temporary Staff 365.57 3,286,139 - - 682,621 3,968,760 SPECIAL REVENUE FUNDS Regular Staff 201 - ADULT PROBATION FEES 1.50 8,598,039 970,939 1,815,883 726,314 12,111,174 204 - JUSTICE CT JUDICIAL ENHANCEMNT 3.00 217,179 20,486 33,244 22,051 292,959 205 - COURT DOCUMENT RETRIEVAL 25.00 796,479 88,995 245,579 62,939 1,193,993 207 - PALO VERDE 6.00 337,037 38,417 68,474 25,845 469,772 208 - JUDICIAL ENHANCEMENT 8.00 579,043 52,470 86,718 58,405 776,635 209 - PUBLIC DEFENDER TRAINING 3.00 139,793 16,048 34,200 10,720 200,761 211 - ADULT PROBATION GRANTS 24.00 1,228,626 137,097 261,930 158,808 1,786,461 215 - EMERGENCY MANAGEMENT 8.00 547,251 62,297 103,821 42,601 755,969 216 - CLERK OF THE COURT GRANTS - 1,027,267 115,748 217,028 86,811 1,446,855 217 - CDBG HOUSING TRUST 6.00 401,430 41,370 66,343 36,480 545,622 218 - CLERK OF COURT FILL THE GAP 47.00 1,226,900 133,850 404,471 97,971 1,863,192 219 - COUNTY ATTORNEY GRANTS 54.00 2,547,750 273,258 465,121 258,387 3,544,516 220 - DIVERSION 28.00 1,589,232 182,441 319,200 200,501 2,291,374 221 - COUNTY ATTORNEY FILL THE GAP 24.00 970,604 111,425 273,600 99,257 1,454,886 222 - HUMAN SERVICES GRANTS 523.50 16,859,401 2,163,651 5,407,490 1,726,696 26,157,238 225 - SPUR CROSS RANCH CONSERVATION 2.00 157,586 17,911 40,616 14,229 230,342 226 - PLANNING AND DEVELOPMENT FEES 100.00 4,271,427 510,398 810,714 372,831 5,965,371 227 - JUVENILE PROBATION GRANTS 38.00 2,380,553 435,682 459,981 182,406 3,458,621 228 - JUVENILE PROBATION SPECIAL FEE - 2,187,272 246,453 462,100 184,840 3,080,665 232 - TRANSPORTATION OPERATIONS 421.00 20,153,226 2,259,948 4,236,540 1,895,693 28,545,406 233 - PUBLIC DEFENDER GRANTS 2.00 162,190 18,641 22,273 14,028 217,133 236 - RECORDERS SURCHARGE 27.00 1,894,029 215,350 303,293 154,744 2,567,416 238 - SUPERIOR COURT GRANTS 25.00 1,614,110 192,086 407,333 142,438 2,355,967 239 - PARKS SOUVENIR - 21,700 2,445 4,585 1,935 30,665 240 - LAKE PLEASANT RECREATION SVCS 29.00 1,164,179 124,146 293,220 98,883 1,680,429 241 - PARKS ENHANCEMENT FUND 50.75 2,026,645 236,726 514,042 196,731 2,974,144 244 - LIBRARY DISTRICT 117.73 5,592,397 650,090 1,331,760 496,631 8,070,879 245 - JUSTICE COURTS SPECIAL REVENUE - 4,018,376 452,775 848,953 339,581 5,659,685 246 - LIBRARY INTERGOVERNMENTAL 47.00 1,696,753 207,543 527,147 138,299 2,569,742 249 - NON DEPARTMENTAL GRANTS 1.00 36,751 4,435 8,094 2,976 52,257 250 - CACTUS LEAGUE OPERATIONS - 9,173 1,034 1,938 775 12,920 251 - SHERIFF GRANTS 27.00 2,091,138 391,816 225,384 639,986 3,348,324 252 - INMATE SERVICES 133.00 3,595,798 478,272 1,018,509 322,334 5,414,913 253 - BALLPARK OPERATIONS 5.00 298,199 32,179 49,322 21,833 401,533 255 - DETENTION OPERATIONS 3,712.35 210,889,941 30,098,932 44,258,764 19,819,659 305,067,296 256 - PROBATE FEES - 278,306 31,358 58,797 23,519 391,980 257 - CONCILIATION COURT FEES - 974,092 109,757 205,794 82,318 1,371,960 258 - SHERIFF TOWING AND IMPOUND 2.00 85,418 30,065 22,800 8,930 147,213 259 - SUPERIOR COURT SPECIAL REVENUE - 3,148,140 354,720 665,100 266,040 4,434,000 261 - LAW LIBRARY 3.00 101,534 11,654 21,889 7,768 142,845 262 - PUBLIC DEFENDER FILL THE GAP 9.00 552,016 63,368 100,225 42,629 758,238 263 - LEGAL DEFENDER FILL THE GAP - 47,117 5,309 9,954 3,982 66,362 264 - SUPERIOR COURT FILL THE GAP 32.00 1,372,182 217,434 350,324 78,577 2,018,517 265 - PUBLIC HEALTH FEES 63.00 2,722,074 306,083 727,103 229,651 3,984,911 266 - CHECK ENFORCEMENT PROGRAM 2.00 77,467 8,894 22,800 7,846 117,007 267 - CRIM JUSTICE ENHANCEMENT 19.00 1,022,433 115,486 213,115 148,609 1,499,643 271 - EXPEDITED CHILD SUPPORT - 424,978 47,885 89,784 35,914 598,560 273 - VICTIM LOCATION - 10,650 1,200 2,250 900 15,000 274 - CLERK OF THE COURT EDMS 48.00 1,429,637 160,352 406,855 112,282 2,109,126 275 - JUVENILE PROBATION DIVERSION 4.00 266,660 54,311 44,702 21,759 387,432 276 - SPOUSAL MAINT ENF ENHANCEMENT - 76,680 8,640 16,200 6,480 108,000 282 - DOM REL MEDIATION EDUCATION - 142,426 16,048 30,090 12,036 200,600 290 - WASTE TIRE 2.00 121,278 13,784 36,525 9,799 181,385 503 - AIR QUALITY GRANTS 14.00 2,040,016 192,981 376,317 151,671 2,760,985 504 - AIR QUALITY FEES 130.15 5,346,421 604,142 1,103,728 424,292 7,478,583 505 - ENVIRONMENTAL SERVICES GRANTS - 29,122 - - 15,681 44,803 506 - ENVIRONMTL SVCS ENV HEALTH 235.00 10,949,259 1,267,024 2,479,367 900,449 15,596,099 532 - PUBLIC HEALTH GRANTS 427.05 20,842,176 2,467,615 4,525,265 1,669,367 29,504,423 Page 21 of 22 Maricopa County FY 2017 Adopted Budget Full-Time Total Estimated Employee Salaries Equivalent Other Benefit Personnel and Hourly Costs (FTE) Retirement Costs Healthcare Costs Costs Compensation FUND FY 2017 FY 2017 FY 2017 FY 2017 FY 2017 FY 2017 572 - ANIMAL CONTROL LICENSE SHELTER 126.00 4,245,155 468,543 1,186,945 389,993 6,290,636 574 - ANIMAL CONTROL FIELD OPERATION 48.00 1,623,930 167,477 450,468 127,539 2,369,414 669 - SMALL SCHOOL SERVICE 1.00 65,918 7,567 11,400 5,045 89,930 715 - SCHOOL GRANTS 51.50 4,036,726 463,644 635,775 309,759 5,445,904 782 - SCHOOL COMMUNICATION 9.00 490,778 56,527 82,061 37,162 666,528 795 - EDUCATIONAL SUPPLEMENTAL PROG 8.00 583,586 66,882 93,382 44,719 788,568 991 - FLOOD CONTROL 185.50 11,295,066 1,396,861 2,327,621 961,250 15,980,799 Temporary Staff - - 204 - JUSTICE CT JUDICIAL ENHANCEMNT 10.00 240,383 - - 25,554 265,937 208 - JUDICIAL ENHANCEMENT 8.00 212,976 - - 16,292 229,268 211 - ADULT PROBATION GRANTS 5.50 224,913 - - 17,207 242,120 218 - CLERK OF COURT FILL THE GAP 1.00 39,672 - - 3,034 42,706 221 - COUNTY ATTORNEY FILL THE GAP 1.00 26,622 - - 2,038 28,660 222 - HUMAN SERVICES GRANTS 1.00 25,056 - - 1,918 26,974 232 - TRANSPORTATION OPERATIONS 6.00 215,967 - - 16,515 232,482 238 - SUPERIOR COURT GRANTS 1.00 102,987 - - 3,194 106,181 239 - PARKS SOUVENIR 1.77 43,575 - - 3,324 46,899 240 - LAKE PLEASANT RECREATION SVCS 1.74 42,009 - - 3,216 45,225 241 - PARKS ENHANCEMENT FUND 11.16 137,837 - - 10,552 148,389 244 - LIBRARY DISTRICT 29.87 616,688 - - 50,746 667,434 246 - LIBRARY INTERGOVERNMENTAL 25.37 480,314 - - 39,598 519,912 253 - BALLPARK OPERATIONS 0.60 9,772 - - 747 10,519 255 - DETENTION OPERATIONS 8.00 349,858 - - 25,274 375,132 265 - PUBLIC HEALTH FEES 1.00 96,479 - - 2,313 98,792 503 - AIR QUALITY GRANTS 0.50 14,156 - - 1,080 15,236 504 - AIR QUALITY FEES 3.50 97,025 - - 7,428 104,453 532 - PUBLIC HEALTH GRANTS 18.80 884,565 - - 67,666 952,231 572 - ANIMAL CONTROL LICENSE SHELTER 1.00 31,423 - - 2,404 33,827 715 - SCHOOL GRANTS 0.75 14,654 - - 1,935 16,589 991 - FLOOD CONTROL 2.50 43,056 - - 4,787 47,843 Total Special Revenue Funds 7,058.08 379,678,699 49,700,967 81,924,301 35,097,408 546,401,375 DEBT SERVICE FUNDS Total Debt Service Funds - - - - - - CAPITAL PROJECTS FUNDS 234 - TRANSPORTATION CAPITAL PROJECT - 1,902,939 214,416 402,029 160,812 2,680,196 440 - COUNTY IMPROVEMENT - 1,393,308 156,992 294,361 117,744 1,962,405 445 - GENERAL FUND CTY IMPROV - 97,624 11,000 20,625 8,250 137,499 461 - DETENTION TECH CAP IMPROVEMENT - 185,986 20,956 39,293 15,717 261,952 990 - FLOOD CONTROL CAPITAL PROJECTS - 1,276,580 143,840 269,700 107,880 1,798,000 Total Capital Projects Funds - 4,856,437 547,204 1,026,008 410,403 6,840,052 INTERNAL SERVICE FUNDS Regular Staff 615 - WELLNESS 6.00 340,652 39,141 64,993 26,618 471,403 618 - BENEFIT ADMINISTRATION 16.00 991,839 113,648 193,823 78,332 1,377,642 654 - EQUIPMENT SERVICES 54.00 2,731,415 293,787 628,175 214,955 3,868,331 673 - REPROGRAPHICS 9.40 380,885 42,822 106,139 28,949 558,795 675 - RISK MANAGEMENT 31.75 2,093,398 239,895 369,307 158,093 2,860,693 681 - TECHNOLOGY INFRASTRUCTURE 55.00 4,416,235 490,217 751,687 340,440 5,998,580 Temporary Staff 618 - BENEFIT ADMINISTRATION 4.00 20,800 - - 1,591 22,391 654 - EQUIPMENT SERVICES 1.00 34,452 - - 2,634 37,086 681 - TECHNOLOGY INFRASTRUCTURE 0.49 18,931 - - 1,451 20,382 Total Internal Service Funds 177.64 11,028,606 1,219,509 2,114,125 853,063 15,215,303 ENTERPRISE FUNDS Total Enterprise Funds - - - - - - TOTAL ALL FUNDS 15,154.41 775,579,555 115,956,731 155,253,987 71,601,020 1,118,391,294 Regular Staff 14,643.30 768,269,246 115,956,731 155,253,987 70,605,901 1,110,085,866 Temporary Staff 511.11 7,310,309 - - 995,119 8,305,428 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 2017 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 Page 22 of 22