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