The URL can be used to link to this page

Home My WebLink About11/01/2016 02 Council Budget Review by DepartmentBUSINESS OF THE CITY COUNCIL YAKIMA, WASHINGTON AGENDASTATEMENT Item No. 2. For Meeting of: November 1, 2016 ITEM TITLE: Council Budget Review by Department Municipal Court City Administration - Council - City Management- Indigent Defense - City Clerks and Records - Information Technology Services - Community Relations Legal Human Resources Airport Finance - Purchasing - Utility Services - Financial Services SUBMITTED BY: Cliff Moore, City Manager Cindy Epperson, Finance & Budget Director SUMMARY EXPLANATION: We are pleased to submit for your review the 2017 Preliminary Budget and Strategic Initiative for the City of Yakima. Included in this presentation is the pro- active steps currently being taken to meet the fiscal challenges facing the City. Attached are PowerPoint presentations for the above listed operating units. Additional detail on the Strategic Initiatives can be found in the separate 2017 Preliminary Budget Summary document, which will be provided to Council separately and is available at https: / /www.yakimawa.gov /services /finance /financial - reports/ ITEM BUDGETED: STRATEGIC PRIORITY: APPROVED FOR 0 City Manager SUBMITTAL: STAFF RECOMMENDATION: BOARD/COMMITTEE RECOMMENDATION: ATTACHMENTS: Description Upload Date Type D I Municipal Court Budget Review 10/2812016 Coxer Memo D 2 City Administration Budget Re\4ew 1012812016 Presentation D 3 Legal Budget Redew 10/2812016 Presentation D 4 Human Resources Budget Reaest 1012812016 Presentation D 5Airport Budget Redew 10128/2016 Presentation D 6 Finance Dept, Budget Overnew 1012812016 Cover Memo iiilll +~ Zl AOW AMW AdIW AW•. owl r • r i G owl AIIW AW AMW r r r r �� • , • ili • • 1� Council Budget Review Municipal Court MUNICIPAL COURT 2017 Budgeted Staffing Levels K.OLWELL Presiding Judge - Position No. I (Re- elected to four -year term 01/01/14) 11.20 Positions S. WOODARD Judge Position No. 2 (Re- elected to four -year term 01/01/14) T. HANLON Commissioner 1/2 -time - Appointed Pro Tempore Judges and Commissioners 2 LIAISON WITH COUNTY PROBATION C. EPPERSON Finance & Budget Director Logistical and Financial Services Support L. HAGERT Court Services Manager 8.70 Positions Municipal Court Clerks Case Filing Scheduling / Processing Records Management Fine & Penalty Collections Municipal Court - General Fund This branch of government is responsible for operation is . • Hears and determines all causes, civil and criminal, including traffic, parking and animal control infractions, arising under City ordinance and pronounces judgment in accordance therewith • Judges are elected for a four -year term • Court Commissioners are appointed by the Presiding Judge. • The City contracts with the County to provide probation services for convicted offenders sentenced by the Municipal Court to Probation. Probationers are required to pay the County directly for their services; therefore, the City has not subsidized the program since 2009 3 1 R P, rev 9 mm Werm ffoo Class Code Position Title 1412 Municipal Court Commissioner 1413 Municipal Court Judge 1421 Court Services Manager 1422 Municipal Court Judicial Specialist (1) 1424 Municipal Court Cashier (1) 1425 Municipal Court Department Assistant (2) Total Personnel 2.00 (1) One Municipal Court Judicial Specialist was changed to a Municipal Court Cashier mid -year 2015. (2) The Municipal Court Department Assistant was changed from .62 to .70 mid -year 2016. 0 2016 2017 2015 Amended Proposed Actual Budget Budget 0.50 0.50 0.50 2.00 2.00 2.00 1.00 1.00 1.00 7.00 6.00 6.00 1.00 2.00 2.00 0.62 0.70 0.70 12.12 12.12 12.20 (1) One Municipal Court Judicial Specialist was changed to a Municipal Court Cashier mid -year 2015. (2) The Municipal Court Department Assistant was changed from .62 to .70 mid -year 2016. 0 Municipal Court - General Fund Dept 180 Municipal Court Exp Summary By Service Unit 155 Crim Justice Sls Tx .3% 155 Administration Total Expenditures (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 $ 275,954 $ 276,750 $ 194,526 $ 285,783 $ 346,469 125.2% 121.2% 1,070,907 1,150,369 795,559 1,144,246 1,184,577 103.0% 103.5% $1,346,861 $1,427,119 $ 990,085 $1,430,029 $1,531,046 107.3% 107.1% 5 (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $ 799,773 $ 887,330 $ 618,578 $ 844,182 $ 922,851 104.0% 60.3% 200 Benefits 272,420 301,836 207,923 299,445 327,255 108.4% 21.4% Sub -Total Salaries & Benefits 1,072,194 1,189,167 826,501 1,143,627 1,250,106 105.1% 81.7% 300 Operating Supplies 28,567 22,000 13,052 18,000 18,000 81.8% 1.2% 400 Professional Svcs & Chgs 218,863 192,952 131,085 239,402 232,940 120.7% 15.2% 500 Intergovernmental Svcs 27,237 23,000 19,447 29,000 30,000 130.4% 2.0% Total Expenditures $1,346,861 $1,427,119 $ 990,085 $1,430,029 $1,531,046 107.3% 100.0% 5 Personnel Changes SU Fund Description 1,5,5 1110 Judicial Specialist 0 Decrease FN 35,200 V qr; ?nn F/V = Filled / Vacant Cap Outlay/Maint /Oper Changes Description Decrease Grand Total $ 35,200 7 Municipal Court - Performance Statistics Infractions (Non - Criminal) 2015 Actual 2016 Prelim 2017 Proposed Budget Filings and Hearings Infractions Filed 12,709 13,513 13,513 Violations Charged 19,130 20,528 20,528 Mitigation Hearings 1,496 1,274 1,274 Contested Hearings 382 332 332 Show Cause Hearings 144 139 139 Other Hearings on Record and Deferred Findings 1,727 1,855 1,855 Total Filings and Hearings 35,588 37,641 37,641 Dispositions Infractions Paid 2,966 3,186 3,186 Failure to Respond 366 393 393 Committed 5,239 4,687 4,687 Not Committed 237 137 137 Dismissed 1,586 1,529 1,529 Amended 2 28 28 Total Disposed 10,396 9,960 9,960 MMM�,al Court - Performance Statistics - Continued 2016 2014 2015 Proposed Infractions (Non - Criminal) Actual Prelim Budget Filings Citations Filed 3,303 3,200 3,200 Violations Charged 4,334 4,169 4,169 Trial Settings Non -Jury Trials Set 5 9 9 Jury Trials 1,889 1,794 1,794 Proceedings Arraignments 2,798 2,765 2,765 Non -Jury Trials 0 2 2 Jury Trials 11 16 16 Other Hearings 4,911 4,232 4,232 Dispositions Bail Forfeitures 0 0 0 Guilty 2,830 2,677 2,677 Not Guilty 7 9 9 Dismissed 1,340 1,620 1,620 Amended 187 223 223 Deferred / Driver /other 552 590 590 Prosecution Resumed 88 71 71 +� iii AW• • . . • AW • A •' �� 00 r Awl AW . r • r i Council Budget Review City Administration S. HAWKINS Economic Development Manager ECONOMIC DEVELOPMENT 1.00 Positions Economic Development Funding / Promotion Promotional Opportunities 2 CITY ADMINISTRATION 2017 Budgeted Staffing Levels C. MOORE City Manager 36.00 Positions C. PRICE Assistant to the City Manager S. CLAAR -TEE City Clerk RECORDS DIVISION 4.00 Positions City Council Clerk Agenda Preparation and Council Minutes Transcription Central Records Depository Voter Registration Public / Customer Service / Inquiry City -wide Records Management Pension W. WANTLAND Information Technology Manager INFO/TECH SERVICES 22.00 Positions Operate Centralized Computer & Data Communications Systems Analyze, Design, Program & Implement New Computer Software Applications Systems Maintain & Enhance Existing Application Systems Hardware and Equipment Mapping and GIS High Volume Printing Copying Document & Bindery Services R. BEEHLER Communications & Public Affairs Director COMMUNITY RELATIONS 4.00 Positions Marketing Media Relations Community Outreach Communications Training State & Federal Legislative Liaison Administration Yakima Public Affairs Channel (Y -PAC) Yakima Community Television (YCTV) Telecommunications Cable TV Franchises J. COOPER Yakima Valley Visitors & Convention Bureau President & CEO C. UPTON General Manager Convention Center C. ROBIN Capitol Theatre Executive Director ity Administration This presentation focuses on the following departments: ( ' ' ity Council - General Fund I I I •The City Council serves as the legislative body of the City and consists of seven (7) members. • The City Council approves all ordinances, resolutions and contracts of the City. • With the advice and assistance of the appointed City Manager, the Council analyzes proposals to meet community needs. • Initiates action for new programs and determines the ability of the City to provide financing for City operations. • The Council reviews, modifies and adopts the annual municipal budget presented by the City Manager. • The City Council reviews and adopts long -range planning documents prescribed by the Growth Management Act and other state statutes. 0 J01-4 0 (.-,lty Council - Authorized Personnel 2016 2017 Class 2015 Amended Proposed Code Position Title Actual Budget Budget 100 Mayor 1.00 1.00 1.00 150 Assistant Mayor 1.00 1.00 1.00 200 City Council Member 5.00 5.00 5.00 Total Personnel 7.00 7.00 7.00 fjt City Council - Budget Overview Dept 110 City Council (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 122 Legislative $ 216,775 $ 220,699 $143,958 $ 206,774 $ 226,249 102.5% 109.4% 123 Professional Assn Dues 63,904 64,641 64,641 64,641 65,177 100.8% 100.8% $ 280,679 $ 285,340 $ 208,599 $ 271,415 $ 291,426 102.1% 107.4% 0 (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Expenditure Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $ 95,100 $ 95,100 $ 71,325 $ 95,100 $ 95,100 100.0% 32.6% 200 Benefits 7,680 7,697 5,767 7,697 7,703 100.1% 2.6% Sub -Total Salaries & Benefits 102,780 102,797 77,092 102,797 102,803 100.0% 35.3% 300 Operating Supplies 6,196 5,250 3,836 5,250 5,250 100.0% 1.8% 400 Professional Svcs & Chgs 171,703 177,293 127,670 163,368 183,373 103.4% 62.9% Total Expenditures $ 280,679 $ 285,340 $ 208,599 $ 271,415 $ 291,426 102.1% 100.0% 0 City Council - Reduction Alternatives F/V = Filled / Vacant 7 Personnel Changes Cap Outlay/Maint /Oper Changes SU Fund Description Decrease FN Description Decrease 122 3110 - Office & Operating Supplies 1,000 122 3500 Small Tools & Minor Equipment 250 122 4100 - Professional Services 35,000 122 4300 - Transportation 3,000 Personnel Changes Total - Other Changes Total 39,250 Grand Total $ 39,250 F/V = Filled / Vacant 7 City Management - General Fund 102 This department provides policy recommendations and administrative oversight in the effective discharge of City Council policy, and Charter and ordinance provisions. This office is also responsible for the administration of nine departments and four service divisions. 9 E 2016 2017 Class 2015 Amended Proposed Code Position Title Actual Budget Budget 1110 City Manager 1.00 1.00 1.00 1331 Admin Assistant to the City Manager 1.00 1.00 1.00 Total Personnel 2.00 2.00 2.00 E City Management - Budget Overview Dept 102 City Management (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 102 City Management $ 504,402 $ 418,138 $ 321,636 $ 429,828 $ 411,938 98.5% 95.8% (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected fr om of Expenditure Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $ 382,129 $ 304,253 $ 218,022 $ 290,383 $ 297,965 97.9% 72.3% 200 Benefits 83,511 76,287 53,862 78,416 80,493 105.5% 19.5% Sub -Total Salaries & Benefits 465,640 380,539 271,884 368,799 378,459 99.5% 91.9% 300 Operating Supplies 4,151 5,000 3,839 5,000 5,000 100.0% 1.2% 400 Professional Svcs & Chgs 34,610 32,599 45,913 56,029 28,479 87.4% 6.9% Total Expenditures $ 504,402 $ 418,138 $ 321,636 $ 429,828 $ 411,938 98.5% 100.0% 10 City Management - Reduction Alternatives Personnel Changes SU Fund Description 102 1120 Temporary Salaries 143 3110 102 4110 102 4213 102 4220 102 4910 Personnel Changes Total Cap Outlay /Maint /Oper Changes Decrease FN Description Decrease 2,850 Office & Operating Supplies 1,000 - Professional Services 8,000 Data Communications 100 - Postage 100 - Transportation 1,400 - Dues & Subscriptions (1,000) 2,850 Other Changes Total 9,600 Grand Total $ 12,450 F/V = Filled / Vacant 11 Dept 109 Indigent Defense 109 Indigent Defense Expenses 300 Operating Supplies 310 Office & Oper Supplies 400 Professional Svcs & Chgs 410 Professional Services Total Expenditures 12 (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 $ - $ 500 $ - $ 500 $ 500 100.0% 100.0% 910,981 935,000 714,467 940,000 965,000 103.2% 102.7% $ 910,981 $ 935,500 $ 714,467 $ 940,500 $ 965,500 103.2% 102.7% LIM$ • Maintains the official records of the City • Takes and maintains a true record of all City Council meetings • Provides proper legal noticing • Processes and publishes resolutions, ordinances and other documents in accordance with the law • Accepts and processes requests for information under the Public Records Disclosure Act • Provides general information to the public 13 M .MO Class Code Position Title 1234 City Clerk 7123 Department Assistant III (1) 7161 Public Records Officer 7165 Records Assistant G) 10501 Records Administrator Total Personnel (2) (1) .50 Department Assistant III upgraded to a full time City Records Assistant in 2017. (2) .60 FTE's funded by the Risk Management Fund (515). 14 2016 2017 2015 Amended Proposed Actual Budget Budget 1.00 1.00 1.00 1.50 1.50 1.00 1.00 1.00 1.00 0.00 0.00 1.00 1.00 1.00 1.00 4.50 4.50 5.00 (1) .50 Department Assistant III upgraded to a full time City Records Assistant in 2017. (2) .60 FTE's funded by the Risk Management Fund (515). 14 LV!M* L4.gMK2MLRJ =Do get Overview Dept 140 Records (1) (2) (3) 2016 2017 2016 2016 Estimated 2015 Amended Actual Exp Summary By Service Unit Actual Budget 09/30/16 143 Records $ 354,426 $ 463,982 $ 343,021 144 City Clerk 172,792 183,104 161,832 145 Official Proceedings /Pubs 6,067 5,000 3,109 Total Expenditures $ 533,284 $ 652,086 $ 507,961 (4) (5) (6) (7) (1) (2) (3) % Chng 2016 2016 2015 Amended Actual Expenditure Summary By Type Actual Budget 09/30/16 100 Salaries & Wages $ 274,261 $ 290,645 $ 201,756 200 Benefits 96,881 94,741 71,343 Sub -Total Salaries & Benefits 371,143 385,386 273,098 300 Operating Supplies 13,247 14,800 3,409 400 Professional Svcs & Chgs 148,895 251,900 231,454 Total Expenditures $ 533,284 $ 652,086 $ 507,961 15 (4) (5) (6) (7) 2016 2017 % Chng % Chng Estimated Projected from from Year -End Budget 2 to 5 4 to 5 $ 460,273 $ 405,805 87.5% 88.2% 183,211 180,525 98.6% 98.5% 5,000 5,000 100.0% 100.0% $ 648,483 $ 591,329 90.7% 91.2% (4) (5) (6) (7) 2016 2017 % Chng % Chng Estimated Projected Year -End Budget $ 290,644 97,018 $ 306,902 106,993 387,662 413,894 11,500 14,800 249,321 162,635 $ 648,483 $ 591,329 from 2to5 105.6% 112.9% 107.4% 100.0% 64.6% 90.7% from 4to5 51.9% 18.1% 70.0% 2.5% 27.5% 100.0% Personnel Changes Cap Outlay /Maint /Oper Changes SU Fund Description Decrease FN Description Decrease 143 1200 Overtime $ 3,500 $ - 143 3110 - Office & Operating Supplies 2,300 143 3500 - Small Tools & Minor Equip 100 144 1200 Overtime 2,000 - 144 3110 - Office & Operating Supplies 1,000 Personnel Changes Total 5,500 F/V = Filled / Vacant 16 Other Changes Total 3,400 Grand Total $ 8,900 Records/City Clerk - Strategic Initiative Summary Strategic Initiative Proposed Personnel Request /Justification Funding Source Salary / Benefits Non - Personnel Notes Change position from 50% DA -III to General Fund Budgeted 100% City Records Assistant $23,800 PT Reduce Temporary Personnel 1( 3,000) Net Increase $10,800 17 fjt y } Records/City Clerk — Performance Statistics 2016 2017 2015 Amended Proposed Records Actual Budget Budget Formal Public Disclosure Requests 1,903 1,833 1,868 Bid openings 43 28 40 Legislation Council Meetings (Regular, Special, Adjourned & Exec. Session) 42 54 48 Legislation Adopted (Resolution and Ordinance) 216 195 208 Legal Publications 59 57 58 Contracts Processed 269 274 272 18 fjt y } =�ogy - Ueneral Pund 350 • Security and operations of the City's Information Systems infrastructure (e.g.: databases; operating systems; flrewalls; anti - virus; anti -spam; communications networks; etc.) • Maintenance, enhancement and support of: • Existing software applications. • The Geographical Information Services (GIS). • Existing computer hardware (e.g.: computers; printers; copiers; mobile data terminals; wireless data communications devices; data radios; microwaves; fiber optics; surveillance cameras; etc.) • Implementation of new software application systems. • Creation, enhancement, and support of Web Based applications and services. • Voice communications equipment maintenance including; radio, vehicular communications and emergency operations equipment, telephone and personal mobile communications devices. • Document services to include; printing, copying, and creation both in paper and electronic formats. +t 19 (1) A mid -year restructuring in 2015 resulted in the reduction of one Client Service Technician position and the creation of a Senior Client Services Technician and a second Information Technology System Admin. 20 (2) One Telephone Technician was replaced with a Telephone Systems Analyst in the 2017 budget. 2016 2017 Class 2015 Amended Proposed Code Position Title Actual Budget Budget 1233 Information Systems Manager 1.00 1.00 1.00 2102 GIS Technician 1.00 1.00 1.00 2107 Computer Operations Technician 1.00 1.00 1.00 2108 Computer Client Services Technician 5.00 4.00 4.00 2110 Database Administrator 1.00 1.00 1.00 2112 Network Services Engineer 1.00 1.00 1.00 2113 Senior Client Services Technician(') 0.00 1.00 1.00 2117 Web Applications Developer / Admin 1.00 1.00 1.00 2118 Information Technology System Admin 1.00 2.00 2.00 2119 Telephone Technician (2) 1.00 1.00 0.00 n/a Telephone Systems Analyst (2) 0.00 0.00 1.00 4520 Electronics Technician I 1.00 1.00 1.00 4521 Electronics Technician II 1.00 1.00 1.00 4522 Electronic Supervisor 1.00 1.00 1.00 7171 Information Technology Services Asst 1.00 1.00 1.00 7611 Print Shop Operator 1.00 1.00 1.00 10201 Senior Analyst 1.00 1.00 1.00 11901 Supervising Senior Analyst 2.00 2.00 2.00 11902 Operation Supervisor 1.00 1.00 1.00 Total Personnel 22.00 23.00 23.00 (1) A mid -year restructuring in 2015 resulted in the reduction of one Client Service Technician position and the creation of a Senior Client Services Technician and a second Information Technology System Admin. 20 (2) One Telephone Technician was replaced with a Telephone Systems Analyst in the 2017 budget. Information TecBudget Dept 350 Information Tech Exp Summary By Service Unit (1) 2015 Actual (2) 2016 Amended Budget (3) 2016 Actual 09/30/16 (4) 2016 Estimated Year -End (5) 2017 Projected Budget (6) % Chng from 2 to 5 (7) % Chng from 4 to 5 351/352 Crim Justice Sls Tx .3% $ 177,103 $ 162,044 $ 160,842 $ 162,851 $ 168,596 104.0% 103.5% 351 Information Tech Services 2,340,969 2,453,974 1,818,811 2,417,403 2,802,140 114.2% 115.9% 352 Electronic Tech Services 331,180 341,007 246,519 312,607 392,295 115.0% 125.5% 353 Document Center 237,840 156,877 143,607 190,686 164,955 105.1% 86.5% Total Expenditures $ 3,087,092 $ 3,113,902 $ 2,369,779 $ 3,083,547 $ 3,527,985 113.3% 114.4% (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $1,597,932 $1,708,581 $1,192,926 $1,624,422 $1,844,483 108.0% 52.3% 200 Benefits 530,147 573,611 401,247 584,565 628,335 109.5% 17.8% Sub -Total Salaries & Benefits 2,128,079 2,282,192 1,594,173 2,208,986 2,472,818 108.4% 70.1% 300 Operating Supplies 144,895 157,600 53,882 139,000 182,600 115.9% 5.2% 400 Professional Svcs & Chgs 719,042 612,610 581,414 644,417 790,567 129.0% 22.4% 600 Capital Outlays 95,077 61,500 140,310 91,143 82,000 133.3% 2.3% Total Expenditures $ 3,087,092 $ 3,113,902 $ 2,369,779 $ 3,083,547 $ 3,527,985 113.3% 100.0% 21 Information Personnel Changes Cap Outlay /Maint /Oper Changes SU Fund Description Decrease FN Description Decrease 351 1110 Delay filling Tele Tech Analyst $ 30,000 V $ - 351 4100 - Profession Services 20,000 30,000 20,000 Grand Total $ 50,000 F/V = Filled / Vacant 22 •� ' Strategic Initiative 23 Proposed Personnel Strategic Initiative Request / Justification Funding Source Salary / Benefits Non - Personnel Notes Replace Telephone Technician position General Fund $9,500 Budgeted with Telecommunications Analyst PT 23 Community Relations The Community Relations office has four primary areas of responsibility: • Management and administration of the City's communications and marketing initiatives. The City's communications and marketing initiatives are focused on meeting four key objectives: 1) providing proactive media relations; 2) communicating with key audiences using a variety of platforms; 3) providing communications support to all City departments and divisions; and, 4) creating better opportunities for community involvement. • Operation of two cable television channels: 1) YCTV (Charter Cable channel 192), and 2) Y -PAC (Charter Cable channel 194) • Negotiation and compliance monitoring of cable and telecommunications franchises. • Management and administration of the City's public affairs initiatives. The City's public affairs initiatives include development and management of state legislative and administrative priorities, development and management of Congressional and federal agency priorities, collaborating with state and federal advocacy contract consultants, and building and maintaining liaison relationships and partnerships with other local governmental entities, non -F-L organizations, as well as local, state and federal elected officials. 24 25 2016 2017 Class 2015 Amended Proposed Code Position Title Actual Budget Budget 1255 Communications & Public Affairs Director 1.00 1.00 1.00 2245 Community Relations Specialist 1.00 1.00 1.00 2246 Senior Community Relations Specialist 1.00 1.00 1.00 2252 Community Programming Coordinator 1.00 1.00 1.00 2254 Municipal Producer 1.00 1.00 1.00 Total Personnel 5.00 5.00 5.00 25 Dept 125 Community Relations (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 125 Capital Improvement $ 34,874 $ 39,000 $ 24,652 $ 34,000 $ 39,000 100.0% 114.7% 126 Cable Communications 599,278 579,913 387,411 544,572 605,423 104.4% 111.2% Total Expenditures 634,153 618,913 412,063 578,572 644,423 104.1% 111.4% Rev Summary By Type 310 Taxes 687,493 665,000 337,321 676,500 676,500 101.7% 100.0% 360 Miscellaneous Revenues 598 1,600 1,105 1,600 1,600 100.0% 100.0% Total Revenues 688,091 666,600 338,426 678,100 678,100 101.7% 100.0% Fund Balance Beginning Balance 603,474 657,412 657,412 657,412 756,940 115.1% 115.1% Revenues Less Expenditures 53,938 47,687 (73,637) 99,528 33,677 70.6% 33.8% Ending Balance $ 657,412 $ 705,099 $ 583,775 $ 756,940 $ 790,617 112.1% 104.4% 26 Community Relations - Performance Statistics Community Relations Division 2015 Actual 2016 Preliminary 2017 Proposed YCTV community programming (1) 122 shows — 64 hrs 130 shows — 70 hrs 135 shows — 75 hrs "Imported" Programming (2) 165 - 99 hrs 170 shows —100 hrs 175 shows — 105 hrs Production Equipment (cameras, misc., etc.) Used by YCTV producers (3) 102 hrs per week 110 hrs per week 115 hrs per week Editing Equipment Use by YCTV producers (4) 62 hrs per week 70 hrs per week 75 hrs per week YCTV Producers Trained (5) 32 40 45 YPAC Programming (6) 325 shows — 370 hrs 330 shows — 380 hrs 335 shows — 385 hrs Program Sales Revenue (7) $234 $250 $260 News Releases (8) 200 215 225 Social Media Posts (9) 400 430 450 (1) Number of programs and hours of community programming produced through YCTV. (2) Number of programs and hours of "imported" YCTV programming, which consists of programs produced elsewhere and aired on YCTV at the request of local community members. (3) Community use of YCTV field production equipment. (4) Community use of YCTV editing equipment. (5) Number of community members trained as YCTV producers. (6) Number of programs and hours of public affairs programming produced through Y -PAC. (7) Revenue from sales of copies of YCTV and Y -PAC programs. (8) Number of news releases issued annually by the Community Relations office. (9) Number of social media posts (Facebook, Twitter, YouTube) created annually by the Community Relations office. 27 iiilll +~ Zl AOW AMW AMW AW•. owl r • r i G owl AIIW AW AMW r r r r �� • , • ili • • 1� Council Budget Review Legal H. HARVEY Senior Assistant City Attorney Civil Liability Civil Litigation Damage Claims Risk Management Litigation Discovery Insurance Insurance Programs (CIAW & WSTIP) Public Records Act Ordinances & Contracts 2 LEGAL 2017 Budgeted Staffing Levels J. CUTTER Acting City Attorney 17.50 Positions P. MARTINEZ Legal Assistant to the City Attorney CIVIL DIVISION Civil Legal Assistants 2.00 Positions M. KUNKLER Senior Assistant City Attorney Employment & Personnel Law including FLSA, WMWA, ADA, WLAD, & FMLA Labor Unions including PERC & ULP Civil Service Commissions Public Records Act Ordinances & Contracts S. WATKINS Senior Assistant City Attorney Land Use Zoning Comprehensive Plans Growth Management State Environmental Policy Act Hearing Examiner Hearings & Appeals Environmental Law Ordinances & Contracts B. FAUL Senior Assistant City Attorney Drug Seizure Forfeitures Employment & Personnel Public Records Act Ordinances & Contracts PROSECUTION DIVISION C. MARTINEZ Senior Assistant City Attorney T Prosecution Legal Assistants 4.50 Positions T 5.00 Attorneys Criminal Prosecution Contested Infractions Officer Advice & Training Criminal Records Privacy Act/Public Records Pre - filing & Community Diversion Programs Public Safety Ordinances & Contracts units. Legal- General Fund The Legal Department provides legal support for the City. The department is separated into Prosecution and Civil legal counsel service • Prosecution of all misdemeanor and gross misdemeanor cases, including crimes of domestic violence, criminal traffic and civil infractions • Advise the Council, the City Manager, all department heads and other administrative officials and all boards and commissions regarding legal matters • Preparation of legislation enacting, amending, and repealing City Ordinances, regulations and traffic and penal code provisions in the Yakima Municipal Code • Prepare and advise on the legality, correctness, and form of all contracts, bonds, and other legal instruments to which the City is a party • Represent the City as attorney in all Civil legal proceedings in which the City is a party • The Community Diversion Program addresses non - violent repeat offenders by connecting willing participants to work and life skills programming to address the underlying issues that are driving criminal behavior 3 & Val - Authorized Personnel Class Code Position Title 1120 City Attorney 1321 Senior Assistant City Attorney II �1> 1322 Senior Assistant City Attorney I �1> 1323 Assistant City Attorney II �1> 1324 Assistant City Attorney I �1> 10510 Legal Assistant III (2) 10511 Legal Assistant II (2 )(3) 10512 Legal Assistant I 11810 Legal Department Office Supervisor Total Personnel (4) 2015 Actual 1.00 4.00 1.00 4.00 1.00 0.00 6.50 1.00 1_nn 2016 2017 Amended Proposed Budget Budget 1.00 1.00 4.00 4.00 1.00 1.00 5.00 3.00 0.00 2.00 2.00 2.00 4.50 3.50 1.00 1.00 1.00 1.00 19.50 19.50 18.50 (1) Senior Assistant City Attorneys /Assistant City Attorney advance to the next level when minimum requirements are met. (2) Two Legal Assistant II positions were upgraded to Legal Assistant III positions in 2016. (3) One Legal Assistant II was deleted due to budget constraints mid -year 2016. (4) 4.85 FTE's funded by the Risk Management Fund (515) and 1.00 FTE funded by Police Grants (152). 4 Legal - General Dept 170 Legal Exp Summary By Service Unit (1) 2015 Actual (2) 2016 Amended Budget (3) 2016 Actual 09/30/16 (4) 2016 Estimated Year -End (5) 2017 Projected Budget (6) % Chng from 2 to 5 (7) % Chng from 4 to 5 152 Crim Justice Sls Tx .3% $ 186,171 $ 261,941 $ 149,971 $ 203,571 $ 218,536 83.4% 107.4% 152 Prosecution 902,065 949,783 697,698 948,702 981,129 103.3% 103.4% 153 Legal Counsel 379,685 433,313 259,852 385,432 464,080 107.1% 120.4% 154 Community Diversion - - 2,860 28,927 56,969 n/a 196.9% Total Expenditures $1,467,922 $1,645,037 $1,110,380 $1,566,632 $1,720,714 104.6% 109.8% (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $ 999,591 $1,118,656 $ 773,746 $1,071,652 $1,159,442 103.6% 67.4% 200 Benefits 317,163 348,321 244,299 347,790 383,062 110.0% 22.3% Sub -Total Salaries & Benefits 1,316,754 1,466,976 1,018,045 1,419,442 1,542,505 105.1% 89.6% 300 Operating Supplies 19,521.57 17,500 11,900 17,575 17,850 102.0% 1.0% 400 Professional Svcs & Chgs 131,646 160,560 80,435 129,616 160,359 99.9% 9.3% Total Expenditures $1,467,922 $1,645,037 $1,110,380 $1,566,632 $1,720,714 104.6% 100.0% 5 0 Legal - Reduction Alternatives 1.5% Personnel Changes SU Fund Description Decrease FN 152/153 All Temporary Salaries $ 10,126 iu,120 Add'1.5% Personnel Changes SU Fund Description Decrease FN 152/153 All $ - F/V = Filled / Vacant Cap Outlay/Maint /Oper Changes Description Decrease Office & Operating Supplies $ 3,500 Professional Services 1,000 Postage 300 Transportation 1,100 Miscellaneous Expenses 1,704 Dues & Subscriptions 3,500 Repairs & Maintenance 500 11,604 Total 1% Reductions $ 21,730 Cap Outlay/Maint /Oper Changes Description Decrease Professional Services $ 300 Postage 500 Miscellaneous Expenses 444 Dues & Subscriptions 4,000 Repairs & Maintenance 2,000 Total Additional 5% $ 7,244 Total 2% Reductions 28,974 I 04� Legal has no strategic initiatives & M Rkal — Performance Statistics wo zo Legal 2015 Actual 2016 Prelim 2017 Proposed Budget Traffic and Criminal Case Arraignments in Municipal Court 2,850 2,850 2,850 Trials, Motions and Other Hearings 4,929 4,600 4,600 Municipal Court Citations Filed 3,300 3,000 3,300 Cases Actually Tried 9 14 14 Cases Set for Trial 1,859 1,940 1,940 Legislation Prepared 216 226 236 Legal Opinions Prepared 330 335 340 Pending Civil Suits Filed By or Against the City 39 39 39 Damage Claims Handled 110 105 110 iiilll +~ Zl AOW AMW AMW AW•. owl r • r i G owl AIIW AW AMW r r r r �� • , • ili • • 1� Council Budget Review Human Resources HUMAN RESOURCES 2017 Budgeted Staffing Levels C. MENDOZA Director of Human Resources 8.1 Positions M. WILTSEY Human Resources Assistant CIVIL SERVICE COMMISSION D. KOREVAAR Civil Services Chief Examiner 2 HUMAN RESOURCES 5.1 Positions Recruitment & Testing Employee Orientation Records Maintenance Collective Bargaining Support • Administration Charter, Police and Fire Civil Service Health Insurance Plan Workers Compensation Retirement System Unemployment Benefits ICMA Deferred Compensation Benefit Program • FTA / DOT Random Drug Testing J. ZEUTENHORST Training Coordinator Human Resources The Human Resources Department is responsible for the administration of a comprehensive human resource management program in accordance with Federal, State and local regulations. M=1 ADA (Americans with Disabilities Act) :: FMLA (Family and Medical Leave Act) 3 • FTA / DOT random drug testing administration • lCMA 457 Deferred Compensation Plan • Labor Relations • Police and Fire Civil Service operations • Pre-employment physical examination administration • Retirement system administration • Self-insurance for health insurance 0 Self-insurance for Workers Compensation 0 Self-insurance for unemployment insurai 0 Section 125 Plan (1) One Human Resources Specialist position was converted to a Senior Human Resources Specialist in 2015. (2) 4.10 FTE's funded by Employee Benefit Funds (512, 513 & 514). F 2016 2017 Class 2015 Amended Proposed Code Position Title Actual Budget Budget 1135 Director of Human Resources 1.00 1.00 1.00 10102 Chief Examiner 1.00 1.00 1.00 10103 Human Resources Specialist M 3.50 2.50 2.50 10104 Human Resources Assistant 1.60 1.60 1.60 10105 Senior Human Resources Assistant M 1.00 2.00 2.00 10110 Training Program Coordinator 1.00 1.00 1.00 Total Personnel (2) 9.10 9.10 9.10 (1) One Human Resources Specialist position was converted to a Senior Human Resources Specialist in 2015. (2) 4.10 FTE's funded by Employee Benefit Funds (512, 513 & 514). F Human Resources - Budlret Overview qP Dept 160 Human Resources (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 162 Administration $ 349,312 $ 337,305 $ 224,255 $ 316,899 $ 358,273 106.2% 113.1% 163 Crim Justice Sls Tx .3% 6,500 6,500 - 6,500 6,500 100.0% 100.0% 165 Charter Civil Service 151,737 165,408 121,924 169,724 179,539 108.5% 105.8% 166 Police / Fire Civil Service 141,476 139,561 110,294 145,230 154,825 110.9% 106.6% Total Expenditures $ 649,024 $ 648,774 $ 456,473 $ 638,353 $ 699,137 107.8% 109.5% k (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $ 357,525 $ 382,133 $ 287,117 $ 388,107 $ 396,286 103.7% 56.7% 200 Benefits 130,696 127,545 99,221 132,707 146,686 115.0% 21.0% Sub -Total Salaries & Benefits 488,220 509,679 386,338 520,814 542,972 106.5% 77.7% 300 Operating Supplies 27,427 14,400 3,732 10,300 14,400 100.0% 2.1% 400 Professional Svcs & Chgs 133,377 124,695 66,402 107,239 141,765 113.7% 20.3% Total Expenditures $ 649,024 $ 648,774 $ 456,473 $ 638,353 $ 699,137 107.8% 100.0% k Personnel Changes Cap Outlay /Maint /Oper Changes SU Fund Description Decrease FN Description Decrease 162 4100 $ - Professional Services $ 14,000 14,000 Grand Total $ 14,000 F/V = Filled / Vacant 0 Human Resources - Strategic 7 Proposed Personnel Strategic Initiative Request / Justification Funding Source Salary / Benefits Non - Personnel Notes Add 2 modules to NEOGov Software General Fund Implement $10,000 Unbudgeted Annual Sub: 29,200 PT $39,200 7 Human Resources 2015 Actual 2016 Prelim 2017 Proposed Budget Personnel Requisitions 262 200 200 Employment Tests Administered 128 140 140 Number of Candidates Scheduled /Tested(') 634 600 600 Personnel Hired 182 140 140 Classification Studies Completed 13 22 20 Unique Training Hours (Individual CYU Course Hours) (') 228 190 200 Cumulative Hours of CYU Instruction(') 604 628 650 Number of CYU Training Participants(') 1708 3269 3300 Total Hours of CYU Training Obtained(') 7186 8206 8300 Hours Invested in Labor Negotiations /Contract Admin /Grievances 200 200 250 Medical Leave of Absence Cases (FMLA, WA State Law) 110 115 115 ADA Accommodations(') 1 5 5 Worker's Comp Claims Handled(') 136 100 100 Hours spent on Safety Issues(') 480 500 500 Hours Invested in Employee Relations (Consultations on Staff Dev. Performance Evaluation / Improvement, Discipline Administration, etc.) 1600 1600 1600 Personnel Action Forms - Handling 1935 1860 1860 Performance Evaluations Issued 875 850 850 Hours Invested in Evaluations Process(') 240 280 280 (1) Change in recording process Dept 512 Unempl Comp Rsv (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 182 Benefit Administration $ 65,443 $ 70,751 $ 51,568 $ 71,044 $ 70,699 99.9% 99.5% 183 Insurance Premiums 6,480 6,600 4,981 6,600 6,600 100.0% 100.0% 185 Claims Paid 124,739 150,000 39,922 115,000 150,000 100.0% 130.4% 196,662 227,351 96,471 192,644 227,299 100.0% 118.0% Rev Summary By Type 360 Miscellaneous Revenues 201,962 197,000 153,491 205,000 205,000 104.1% 100.0% Fund Balance Beginning Balance 435,945 441,244 441,244 441,244 453,600 102.8% 102.8% Revenues Less Expenditures 5,299 (30,351) 57,020 12,356 (22,299) 73.5% 180.5% Ending Balance $ 441,244 $ 410,893 $ 498,264 $ 453,600 $ 431,301 105.0% 95.1% 0 Budget Employee Health Benefit Reserve - Dept 513 Emp Hlth Benefit Rsv (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 171 Benefit Administration $ 387,418 $ 426,438 $ 306,221 $ 425,528 $ 436,051 102.3% 102.5% 172 Insurance Premiums 487,096 515,000 415,474 565,000 580,000 112.6% 102.7% 173 Medical Claim Processing 547,354 565,000 466,840 646,700 725,000 128.3% 112.1% 174 Medical Claims Paid 8,415,859 8,345,000 6,248,688 9,331,000 9,945,000 119.2% 106.6% 186 MiCare Clinic Services 525,344 500,000 430,522 580,000 586,300 117.3% 101.1% 187 MiCare Clinic Admin 31,379 36,900 25,460 35,800 35,800 97.0% 100.0% Total Expenditures 10,394,450 10,388,338 7,893,206 11,584,028 12,308,151 118.5% 106.3% Rev Summary By Type 360 Miscellaneous Revenues 9,933,545 10,407,500 7,678,778 11,280,500 12,450,000 119.6% 110.4% 370 Insurance Recoveries - - 89,318 90,186 - n/a n/a Total Revenues 9,933,545 10,407,500 7,768,096 11,370,686 12,450,000 119.6% 109.5% Fund Balance Beginning Balance 2,077,874 1,616,969 1,616,969 1,616,969 1,403,627 86.8% 86.8% Revenues Less Expenditures (460,905) 19,162 (125,110) (213,342) 141,849 740.3% 66.5% Ending Balance $ 1,616,969 $ 1,636,131 $1,491,859 $ 1,403,627 $ 1,545,476 94.5% 110.1% 11 The Wellness Program sponsors and maintains the fitness equipment located in various Departments throughout the City. Current locations: Yakima Police Department, Fire Station 91, Fire Station 92, Fire Station 93, Fire Station 94, Fire- Station 95, Fire Station 96, Public Works, City Hall, WW Collections and WW Treatment Plant. Dept 516 Wellness/EAP Fund (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 168 Wellness Program $ 53,260 $ 70,500 $ 20,941 $ 66,500 $ 58,000 82.3% 87.2% 169 Employee Assistance Prog 42,270 51,300 16,174 44,800 43,800 85.4% 97.8% Total Expenditures 95,530 121,800 37,115 111,300 101,800 83.6% 91.5% Rev Summary By Type 360 Miscellaneous Revenues 40,000 121,800 463 111,463 100,000 82.1% 89.7% Fund Balance Beginning Balance 182,715 127,185 127,185 127,185 127,348 100.1% 100.1% Revenues Less Expenditures (55,530) - (36,653) 163 (1,800) n/a 1104.3% Ending Balance $127,185 $127,185 $ 90,532 $127,348 $125,548 98.7% 98.6% 13 tZ`lil ,."�' Zl AW AIW illy Adw • • • • 00 r 0 r i r r r ,'W . 1111 •�,, � �....' Council Budget Review Yakima Airport AIRPORT 2017 Budgeted Staffing Levels R. PETERSON Air Terminal Manager 6.00 Positions 2 BUILDING ADMINISTRATION AIRFIELD MAINTENANCE 1.00 Positions MAINTENANCE 1.00 Positions 4.00 Positions ID System & Access Building Maintenance Programs /Passenger Airfield Inspections Plumbing/Electrical Facility Charges Snow Removal Landscaping & Security Badges Vegetation Management Vegetation Management Training Airfield Painting Snow Removal Airport Leases Sign Replacement Interior/Exterior Painting Capital Improvement Electrical Work HVAC Projects FAA Recurrent Training Terminal Grants Equipment Repairs Security/Access Control Records Emergency Coordination System Timekeeping Wildlife Management Heavy Equipment Operation 2 ON fl • Airport Management and Administration • Airfield and Terminal Maintenance • Snow Removal Operations • Airport Operations • Hazardous Wildlife Management • Airport Security • Heavy Equipment Operations and Repairs • Airfield Construction Management • Airport Security and Badging • Landscaping and Janitorial Services 3 Class Code Position Title 1175 Yakima Air Terminal Manager 8910 Airport Maintenance Specialist 11610 Admin Assistant for Yakima Air Terminal Total Personnel 0 2016 2017 2015 Amended Proposed Actual Budget Budget 1.00 1.00 1.00 5.00 5.00 5.00 1.00 1.00 1.00 7.00 7.00 7.00 iget Overview Dept 421 Airport Operating (1) (2) (3) (4) (5) (6) (7) 340 Chrgs f /Goods & Services 184,450 2016 2016 2016 2017 % Chng % Chng 360 Miscellaneous Revenues 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 281 Airfield $ 499,820 $ 544,917 $ 381,326 $ 518,731 $ 510,959 93.8% 98.5% 282 Air Terminal 166,627 195,117 166,574 194,952 221,451 113.5% 113.6% 283 Commercial 7,138 5,900 4,308 5,200 5,900 100.0% 113.5% 284 Security 2,357 6,400 3,252 4,200 3,900 60.9% 92.9% 286 Administration 346,411 376,651 279,479 374,001 403,915 107.2% 108.0% Total Expenditures 1,022,353 1,128,985 834,938 1,097,083 1,146,125 101.5% 104.5% Rev Summary By Type 310 Taxes 13,212 14,000 9,952 14,000 14,000 100.0% 100.0% 340 Chrgs f /Goods & Services 184,450 263,250 152,673 270,650 223,150 84.8% 82.4% 360 Miscellaneous Revenues 861,864 857,679 656,592 891,679 909,679 106.1% 102.0% 390 Other Financing Sources - - 20,604 21,472 - n/a 0.0% Transfers In 600 - - - - n/a n/a Total Revenue 1,060,127 1,134,929 839,820 1,197,801 1,146,829 101.0% 95.7% Fund Balance Beginning Balance 8,539 46,313 46,313 46,313 147,031 317.5% 317.5% Revenues Less Expenditures 37,774 5,944 4,882 100,718 704 11.9% 0.7% Ending Balance $ 46,313 $ 52,257 $ 51,195 $ 147,031 $ 147,735 282.7% 100.5% 19 Y A akima Airport Operating - Continued (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $ 437,661 $ 511,734 $ 384,030 $ 522,134 $ 511,354 99.9% 44.6% 200 Benefits 165,399 164,832 133,615 168,729 187,542 113.8% 16.4% Sub -Total Salaries & Benefits 603,060 676,566 517,645 690,863 698,896 103.3% 61.0% 300 Operating Supplies 55,889 54,440 32,131 43,600 58,940 108.3% 5.1% 400 Professional Svcs & Chgs 309,481 337,479 250,345 322,121 342,788 101.6% 29.9% 600 Capital Outlay 53,922 60,500 34,817 40,500 45,500 75.2% 4.0% Total Expenditures $1,022,353 $1,128,985 $ 834,938 $1,097,083 $1,146,125 101.5% 100.0% fjt Yakima Airport FAA- Dept 422 Airport Capital (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 291 Airport Capital $ 547,128 $11,645,247 $ 6,214,066 $12,222,668 $1,775,089 15.2% 14.5% Rev Summary By Type 330 Intergovernmental 455,605 10,684,418 5,729,250 12,780,674 2,600,000 24.3% 20.3% 340 Chrgs f /Goods & Services 253,374 240,000 190,669 255,000 255,000 106.3% 100.0% 360 Miscellaneous Revenues 679 150 137 150 150 100.0% 100.0% 380 Nonrevenues - 400,000 - - - 0.0% n/a 390 Other Financing Sources - 1,000 - 20,604 1,000 100.0% 4.9% Total Revenues 709,658 11,325,568 5,920,057 13,056,428 2,856,150 25.2% 21.9% Fund Balance Beginning Balance 333,020 495,550 495,550 495,550 1,329,310 268.2% 268.2% Revenues Less Expenditures 162,530 (319,679) (294,009) 833,760 1,081,061 338.2% 129.7% Ending Balance $ 495,550 $ 175,871 $ 201,541 $ 1,329,310 $ 2,410,371 1370.5% 181.3% 7 Y A akima Airport FAA - Continued (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 400 Professional Svcs & Chgs $ 26,565 $ - $ - $ - $ - n/a 0.0% 600 Capital Outlay 520,563 11,645,247 6,214,066 12,222,668 1,775,089 15.2% 100.0% Total Expenditures $ 547,128 $11,645,247 $ 6,214,066 $12,222,668 $1,775,089 15.2% 100.0% fjt Yakima Airport - Strategic Initiative Summary Proposed Personnel Strategic Initiative Request / Justification Funding Source Salary / Benefits Non - Personnel Notes Airport Capital Projects Airport Capital Budgeted Security Perimeter Fence 90% Grants $700,000 NC Snow Removal Equipment 10% Passenger 1,040,000 West General Aviation Itinerant Apron Facility Charge 160,000 East Apron & Taxiway Crack Sealing 50,000 Total $1,950,000 Replace Ford Tractor Airport Operating $43,000 Budgeted ED Add One Airport Assistant Manager Airport Operations $102,400 Unbudgeted position or General Fund ED fjt +� iii AW• • . . • AW • A •' �� 00 r Awl AW . r • r i Council Budget Review Finance 2 FINANCE 2017 Budgeted Staffing Levels C. EPPERSON Director of Finance & Budget 34.75 Positions R.DUKART Utility & Finance Assistant T. LEWIS Financial Services Manager FINANCIAL SERVICES 12.00 Positions Treasury Management Accounting Accounts Receivable Grant Fiscal Management Collections Accounts Payable • Payroll Appropriations Budget Preparation Budget Monitoring & Analysis • Financial Reporting & Analysis Financial Statements Special Projects Debt Issuance & Administration Internal Controls *Directly reports to the City Manager for Disadvantaged Business Enterprise concerns. S. OWNBY* Purchasing Manager PURCHASING DIVISION 5.00 Positions Procurement of Goods and Services Purchasing Law and Regulation Compliance Contract Administration Disposal of Surplus Property Procurement Cards DBE Liaison* Prevailing Wage and Insurance Assessment Purchase Audits Citywide Vendor Lists J. DEAN Utility Services Manager UTILITY SERVICES 13.75 Positions Water, Wastewater, Irrigation, Refuse & Stormwater Account Ser Customer Rel Meter Read Billing Field Servi Collectiol Parking Enfon Finance Department This presentation focuses on the following divisions and services: Utility Services - General Fund • Customer service and account administration and maintenance for all 5 city utilities: water, wastewater, stormwater, refuse, and irrigation • Utility billing • Customer account credit and adjustments • Administration of delinquent accounts and collections • Utility customer communications and notifications • Phone support to customers • Other City Treasury functions • Parking Enforcement 19 Class Code Position Title 1242 Utility Customer Services Manager (1) A Business Analyst position was added mid -year 2016. (2) A Water Services Specialist position was dropped from 1.00 to .75 mid -year 2016. (3) Utility Services funds portions of the Finance Director (.15), Administrative Assistant (.25) Accountant (.75) and a Technician (.50). Utility Services also has 1.05 FTE's funded by Finance. 19 Business Analyst G) 6610 Parking Enforcement Officer 7311 Water Service Specialist (2) 7315 Utility Services Representative 7320 Utility Services Billing Specialist 7325 Utility Services Specialist Total Personnel (3) (1) A Business Analyst position was added mid -year 2016. (2) A Water Services Specialist position was dropped from 1.00 to .75 mid -year 2016. (3) Utility Services funds portions of the Finance Director (.15), Administrative Assistant (.25) Accountant (.75) and a Technician (.50). Utility Services also has 1.05 FTE's funded by Finance. 19 2016 2017 2015 Amended Proposed Actual Budget Budget 1.00 1.00 1.00 0.00 0.00 1.00 2.00 2.00 2.00 2.00 2.00 1.75 7.00 7.00 7.00 1.00 1.00 1.00 1.00 1.00 1.00 14.00 14.00 14.75 (1) A Business Analyst position was added mid -year 2016. (2) A Water Services Specialist position was dropped from 1.00 to .75 mid -year 2016. (3) Utility Services funds portions of the Finance Director (.15), Administrative Assistant (.25) Accountant (.75) and a Technician (.50). Utility Services also has 1.05 FTE's funded by Finance. 19 Utility Services - Budget Overview Dept 650 Utility Customer Svc Exp Summary By Service Unit (1) 2015 Actual (2) 2016 Amended Budget (3) 2016 Actual 09/30/16 (4) 2016 Estimated Year -End (5) 2017 Projected Budget (6) % Chng from 2 to 5 (7) % Chng from 4 to 5 651 Utility Meter Services $ 242,513 $ 322,202 $ 183,832 $ 280,524 $ 268,751 83.4% 95.8% 652 Utility Customer Service 1,129,050 1,195,735 879,838 1,191,499 1,261,083 105.5% 105.8% 653 Parking 146,891 173,136 121,923 175,456 184,545 106.6% 10.8% Total Expenditures $1,518,454 $1,691,074 $1,185,594 $1,647,479 $1,714,379 101.4% 100.0% (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $ 765,019 $ 823,512 $ 580,003 $ 797,149 $ 847,664 102.9% 49.4% 200 Benefits 289,869 305,732 212,017 314,740 362,150 118.5% 21.1% Sub -Total Salaries & Benefits 1,054,889 1,129,244 792,020 1,111,890 1,209,814 107.1% 70.6% 300 Operating Supplies 40,328 18,500 8,664 14,500 15,500 83.8% 0.9% 400 Professional Svcs & Chgs 413,634 520,329 359,971 513,089 481,064 92.5% 28.1% 600 Capital Outlay 7,604 15,000 20,941 - - 0.0% 0.0% Transfers Out 2,000 8,000 3,998 8,000 8,000 100.0% 0.5% Total Expenditures $1,518,454 $1,691,074 $1,185,594 $1,647,479 $1,714,379 101.4% 100.0% 0 affity Services - Performance Statistics Utility Services 2015 Actual 2016 Prelim 2017 Proposed Budget New Accounts Started 5,923 4,300 5,000 Meters Read (1) 5,217 2,735 2,400 Customer Service Calls Answered (2) 78,419 78,105 77,000 Bills Issued 195,982 198,130 204,130 Suspension Notices Issued 36,913 32,000 30,000 Delinquent Bills in Collection (4) 1,695 1,200 1,900 Parking Parking Citations Issued (5) 2,921 2,534 3,100 Unmetered Space Available — Downtown Business District 4,052 4,212 4,212 Spaces Available City Lots (6) 428 588 588 (1) Began transition to AMI system mid -year 2014. 90 -95% of reads are now being transmitted thru the AMI system. (2) No longer receiving phone log reports from Information Technology (IT) — a new phone tracking system is being researched. (3) The Suspension Notices Issued do not include the 1St door hanger or the delinquent shut -off hanger. (4) Represents billing sent to collection in given year - not total amount of accounts in collections. (5) Parking Facilities was transferred to the Utility Services Division December 1, 2014. (6) Parking space availability includes the county owned Courthouse visitor lots and the City Hall Visitor Lot. 7 • The timely and cost - effective procurement of goods and services in compliance with pertinent laws and regulations to assist internal customers of the City and County to fulfill their mission. • Take advantage of opportunities to leverage the combined purchasing power of the City and County. • Provide excellent customer service to City and County departments and divisions. Establish and maintain communications with internal customers in an effort to improve performance. • Establish and maintain vendor relationships. 6 i Class Code Position Title 1232 City Procurement Manager 2231 Buyer I (1) 2233 Purchasing Assistant 2234 Buyer II 11805 Senior Buyer Total Personnel (1) (1) Buyer I's may become Buyer II's by obtaining a certification. (2) Purchasing funds .15 of the Finance Director, and .50 of the Purchasing Assistant is funded by Risk Management. E 2016 2017 2015 Amended Proposed Actual Budget Budget 1.00 1.00 1.00 1.00 1.00 2.00 1.00 1.00 1.00 2.00 2.00 1.00 1.00 1.00 1.00 6.00 6.00 6.00 (1) Buyer I's may become Buyer II's by obtaining a certification. (2) Purchasing funds .15 of the Finance Director, and .50 of the Purchasing Assistant is funded by Risk Management. E Dept 670 Purchasing Exp Summary By Service Unit (1) 2015 Actual (2) 2016 Amended Budget (3) 2016 Actual 09/30/16 (4) 2016 Estimated Year -End (5) 2017 Projected Budget (6) % Chng from 2 to 5 (7) % Chng from 4 to 5 672 Purchasing $ 610,041 $ 630,092 $ 459,857 $ 625,273 $ 608,152 96.5% 97.3% (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $ 435,203 $ 447,297 $ 330,585 $ 447,297 $ 426,298 95.3% 70.1% 200 Benefits 147,404 154,639 113,194 149,700 157,697 102.0% 25.9% Sub -Total Salaries & Benefits 582,607 601,936 443,779 596,997 583,995 97.0% 96.0% 300 Operating Supplies 10,157 9,148 3,878 9,268 7,050 77.1% 1.2% 400 Professional Svcs & Chgs 17,277 19,008 12,200 19,008 17,107 90.0% 2.8% Total Expenditures $ 610,041 $ 630,092 $ 459,857 $ 625,273 $ 608,152 96.5% 100.0% 10 Purchasing - Strategic Initiative Summari Strategic Initiative Proposed Personnel Request /Justification Funding Source Salary / Benefits Non - Personnel Notes Move 0.5 Purchasing Position to Risk Risk Net Savings Budgeted Management Fund to monitor Management $38,000 PT certificate of insurance contract Fund compliance (funded by a mid -year 2016 reduction in a Legal Assistant II position) 11 i City 2015 Actual 2016 Preliminary 2017 Proposed Budget Bid Processes Averted YTD (utilizing interlocal agreements, State 37 40 40 contracts and sole source procurements) Formal Sealed Bids Processed (over $25,000) 35 29 29 Written & Informal Quotes Processed ($7,500 to $25,000) 21 20 20 Number of Units Surplus Disposed of / Gross Revenues 292/$294,475 493/$350,310 357/$227,145 Dollar Value of Purchase Orders Processed $13,673,454 $12,500,000 $12,500,000 Number / Dollar Value of Tenure Contracts Administered $15,140,405 $17,000,000 $17,000,000 Total Dollar Value of Contractual Responsibility $32,775,200 $35,000,000 $35,000,000 County Bid Processes Averted YTD (utilizing interlocal agreements, State 64 50 50 contracts and sole source procurements) Formal Sealed Bids Processed (over $25,000) 13 15 15 Written & Informal Quotes Processed ($5,000 to $25,000) 2 5 5 Number of Units Surplus Disposed of / Gross Revenues 1,134/$165,964 542/$19,619 244/$19,619 Dollar Value of Purchase Orders Processed $5,964,554 $6,500,000 $6,500,000 Number / Dollar Value of Tenure Contracts Administered $25,924,171 $26,500,000 $26,500,000 Total Dollar Value of Contractual Responsibility $34,690,093 $36,000,000 $36,000,000 Joint (both City and County) Formal Sealed Bids Processed (over $25,000) Dollar Value of Tenure Contracts Administered Total City /County Contractual Responsibility 12 11 13 13 $25,924,171 $27,500,000 $27,500,000 $67,465,293 1 $70,000,000 1 $70,000,000 Financial �iervices - Uenerai Pund The Financial Services Division supports all City departments and is responsible . • Financial compliance and internal control oversight • Accounting and reporting for all expenditure and revenue transactions • Financial Statement preparation and distribution • Design, preparation and administration of the operating and capital budgets • Financial analysis of operating, financial, legislative and economic development proposals • Risk management administration • Investment portfolio administration • Debt portfolio administration including ongoing legal and fiscal reporting and compliance • Capital financing research and preparation of regulatory financial and legal documents with Underwriters and Bond Counsel • Receiving and recording of all City receipts (cash, electronic funds, etc.) • Payment of all invoices (Accounts Payable) • Payroll processing and administration • Administration and budget responsibilities for Trust and Agency funds, Debt Service funds; various contingency /reserve funds; and operating fund transfers. • 13 Administrative liaison with the Municipal Court, Public Facilities District, and intergovernmental agencies. Class Code Position Title 1140 Director of Finance and Budget 1241 Financial Services Manager 2316 Financial Services Specialist(') 10301 Payroll Officer 10302 Accountant 10303 Financial Service Officer 10305 Financial Services Technician— Payroll(') 10520 Utility and Finance Assistant Total Personnel «> (1) One Financial Services Specialist upgraded to a Financial Services Technician due to the complexity of the new Cayenta Utility System requirements. (2) 1.65 FTE's are funded by Utility Services (054), and Purchasing funds .15 of the Director of Finance and Budget. Additionally, 1.05 FTE's of Utility Service Representatives (054) are funded by Finance. 14 2016 2017 2015 Amended Proposed Actual Budget Budget 1.00 1.00 1.00 1.00 1.00 1.00 4.00 3.00 3.00 1.00 1.00 1.00 3.00 3.00 3.00 2.00 2.00 2.00 2.00 3.00 3.00 1.00 1.00 1.00 15.00 15.00 15.00 (1) One Financial Services Specialist upgraded to a Financial Services Technician due to the complexity of the new Cayenta Utility System requirements. (2) 1.65 FTE's are funded by Utility Services (054), and Purchasing funds .15 of the Director of Finance and Budget. Additionally, 1.05 FTE's of Utility Service Representatives (054) are funded by Finance. 14 Financial �iervices - Budget Overview Dept 612 Financial Services (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 612 Finance $1,532,581 $1,529,538 $1,105,525 $1,538,377 $1,650,945 107.9% 107.3% (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year -End Budget 2 to 5 Total 100 Salaries & Wages $1,058,953 $1,034,783 $ 745,199 $1,026,526 $1,088,624 105.2% 65.9% 200 Benefits 331,049 331,314 240,617 330,813 371,177 112.0% 22.5% Sub -Total Salaries & Benefits 1,390,002 1,366,097 985,817 1,357,338 1,459,801 106.9% 88.4% 300 Operating Supplies 15,745 20,000 14,303 20,000 20,000 100.0% 1.2% 400 Professional Svcs & Chgs 126,833 143,441 105,405 161,039 171,144 119.3% 10.4% Total Expenditures $1,532,581 $1,529,538 $1,105,525 $1,538,377 $1,650,945 107.9% 100.0% 15 fjt y } Personnel Changes SU Fund Descri Decrease FN 612 1110 Reallocate USR salary distributions $ 43,800 F 612 1110 Allocate AR time to Utilities 10,900 F 54,700 F/V = Filled / Vacant 16 Cap Outlay /Maint /Oper Changes Description Decrease Grand Total $ 54,700 i Strategic Initiative Proposed Personnel Request / Justification Funding Source Salary / Benefits Non - Personnel Notes Purchase Workiva Reporting Software General Fund $29,000 Unbudgeted PT 17 FbTeT.. re M M.. � MA,, 1 Accounting Functions 2015 Actual 2016 Prelim 2017 Proposed Budget Expenditures (1) $193.9 $207.2 $235 Capital Projects $16.7 $34.4 $57.9 Invoices Processed 24,431 24,253 25,000 Number of Grants Administered 48 39 40 Payroll Warrants Issued and Direct Deposits made 101057 10,258 10,463 Payroll and Benefits Paid (1) $69.3 $72.2 $83.9 Employees Paid (Perm and Part Time) Average Monthly 805 822 839 Claims Warrants Issued and EFT's paid 10,845 11,172 11,500 Dollar Amount of Claims Paid $55.8 $65.2 $65 Number of Funds 71 71 71 Number of Full Accrual Funds 32 32 32 LID's in Process 0 0 0 FbTeM re W R.. � MA,, 1 Treasury Functions 2015 Actual 2016 Prelim 2017 Proposed Budget Revenue Recorded $188.8 $208.4 $215.8 Invoices Generated 5,045 4,728 5,000 GO and Revenue Debt Issues Administered 20 20 23 LID's Closed (Establish Notes and redeem LID Warrants) 0 0 0 Intergovernmental Loans Administered 20 18 18 Special Assessment Notes / Bonds 5 5 5 Debt Service Principal Payments Made $7.42 $7.8 $9.0 2017 2015 2016 Proposed Impact Actual Prelim Budget Investment Income $0.5 $0.4 $0.4 Average Total Portfolio Managed $54.2 $51.4 $49.5 (1) Numbers in millions. 19 Dept 613 State Auditor (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from 613 State Auditor Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 Expenses 400 Professional Svcs & Chgs 410 Professional Services $127,429 $113,000 $ 56,115 $115,072 $117,000 103.5% 101.7% 20 Dept 682 Fire Relief & Pension (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 682 Prior Fire Pensions $1,220,413 $1,349,628 $ 894,570 $1,183,583 $1,289,452 95.5% 108.9% Rev Summary By Type 310 Taxes 11182,452 1,240,760 685,356 1,140,760 1,240,760 100.0% 108.8% 330 Intergov't Revenues 82,768 83,000 91,883 91,883 91,900 110.7% 100.0% 360 Miscellaneous Revenues 500 500 - 500 500 100.0% 100.0% Total Revenues 1,265,720 1,324,260 777,239 1,233,143 1,333,160 100.7% 108.1% Fund Balance Beginning Balance 974,543 1,019,850 1,019,850 1,019,850 1,069,410 104.9% 104.9% Revenues Less Expenditures 45,307 (25,368) (117,331) 49,560 43,708 172.3% 88.2% Ending Balance $1,019,850 $ 994,482 $ 902,519 $1,069,410 $1,113,118 111.9% 104.1% 22 Capitol Theatre Expansion A) Non Taxable portion 8/29/2009 12/1/2018 2,055,000 PFD 235,000 20,613 4.25% 250,000 B) Taxable -Build America Bonds(1) 8/29/2009 12/1/2032 4,980,000 PFD /Tax Rebate - 260,439 3.42% 4,980,000 (1) Interest and rate are net of rebate. Interest on Build America Bonds (BABs) is taxable to bondholders. The City receives a rebate from the IRS lowering the effective interest rate. General Government Infrastructure 6/17/2003 12/1/2023 1,430,528 Fire Station - West Valley 2017 Remaining 815,000 Final Original 2017 2017 Interest Balance General Obligation Bonds Issue Date Maturity Issue Funding Source Principal Interest Rate 12/31/2017 Convention Center 26,815 5.00% Street /Pedestrian Improvements 8/28/2008 12/1/2019 2,190,000 Expansion (refunding 1996 bonds) 9/7/2004 11/1/2019 $4,910,000 Hotel /Motel Tax $ 315,000 $147,470 5.00% $3,435,000 Addition (refunding 2002 bonds) 5/8/2007 5/1/2026 4,175,000 PFD 380,000 45,465 4.00% 730,000 Capitol Theatre Expansion A) Non Taxable portion 8/29/2009 12/1/2018 2,055,000 PFD 235,000 20,613 4.25% 250,000 B) Taxable -Build America Bonds(1) 8/29/2009 12/1/2032 4,980,000 PFD /Tax Rebate - 260,439 3.42% 4,980,000 (1) Interest and rate are net of rebate. Interest on Build America Bonds (BABs) is taxable to bondholders. The City receives a rebate from the IRS lowering the effective interest rate. General Government Infrastructure 6/17/2003 12/1/2023 1,430,528 Fire Station - West Valley 5/8/2007 5/1/2022 815,000 River Rd, 16th, Fruitvale 5/8/2001 5/1/2017 1,765,000 Gas tax 215,000 5,375 5.00% Downtown Revitalization 5/8/2007 5/1/2022 1,490,000 REET 2 110,000 26,815 5.00% Street /Pedestrian Improvements 8/28/2008 12/1/2019 2,190,000 REET 1 & 2 215,000 26,263 3.75% Street Resurfacing /Improvements 7/20/2013 6/20/2028 5,000,000 Property tax 313,751 63,479 1.67% Street Resurfacing /Improvements 6/9/2014 6/1/2024 13,140,000 Prop /Sales taxes 1,205,000 445,425 3.00% Sports Complex Infrastructure 2017* 2028* 1,700,000 Gas tax or Other - - 4.00% Downtown Plaza 2017* 2038* 7,975,000 Pledges /REET 2 - - 4.00% Other General Government Projects SunDome Expansion 6/17/2003 12/1/2023 1,430,528 Fire Station - West Valley 5/8/2007 5/1/2022 815,000 Fire Ladder Apparatus 8/28/2008 12/1/2021 760,000 24 Sports Complex -City Fields /Park 12/22/2015 12/1/2035 5,000,000 Business License 600,000 455,000 3,630,769 9,885,000 1,700,000 7,975,000 fees, REET 1 78,302 68,387 4.39% 393,790 REET 1 60,000 14,735 5.00% 330,000 Property tax 60,000 13,050 3.75% 270,000 Property tax 242,703 157,297 3.35% 4,512,916 Intergovernmental General Obligations Final Issue Date Maturity Original 2017 Issue Funding Source Principal Local Option Capital Asset Lending Program (LOCAL) - General Fund 2017 2017 Interest Interest Rate Remaining Balance 12/31/2017 Two Fire Apparatus 6/1/2011 12/1/2020 $ 576,847 Prop /Sales tax $ 59,801 $ 10,158 3.02% $ 194,141 One Fire Apparatus 3/13/2013 6/1/2023 310,414 Prop /Sales tax 28,341 10,874 1.93% 203,316 70 Fire Air Packs 8/22/2013 6/1/2019 459,602 Prop /Sales tax 77,086 9,813 1.62% 16,422 74 Police Vehicles 8/22/2013 6/1/2019 4,173,190 Prop /Sales tax 699,937 89,100 1.62% 1,502,033 Two Fire Apparatus, other vehicles and equipment 8/15/2017* 8/15/2028* 2,019,000 Prop /Sales tax 59,801 10,158 3.02% 194,141 Public Works Trust Fund /State Revolving Loan Fund - Funds 342 & 343 Railroad Grade Separation (2009) 8/14/2009 7/1/2028 3,000,000 REET 2 215,000 5,375 5.00% - Railroad Grade Separation (2010) 5/6/2010 6/1/2034 1,229,295 Gas tax 110,000 26,815 5.00% 600,000 Supporting Investment in Economic Development (SIED) - Fund 323 & 142 Mill Site (LIFT area) Development 4/15/2014 6/1/2017 900,000 LIFT tax credit 900,000 6,868 2.44% - 21st Ave extension & Airport Lane Realignment 7/21/2015 6/1/2023 307,000 Gas tax - - 2.44% 307,000 Other General Government Projects - Fund 151 Communications Center General Fund Relocation - City portion of County Telephone GO Bond 6/17/2014 5/1/2034 1,716,500 Utility Tax 65,000 53,900 3.00% 1,535,000 26 Revenue Bonds Irrigation System Bonds Initial irrigation system rebuild Rebuild Nelson Dam Final Issue Date Maturity Original 2017 Issue Funding Source Principal 9/14/2004 9/1/2034 $5,215,000 Irrigation fees 2017* 2038* 6,000,000 Irrigation fees 2017 Remaining 2017 Interest Balance Interest Rate 12/31/2017 $ 145,000 $322,141 4.00% $3,680,000 - - 4.00% 6,000,000 Water and Wastewater (WW) System Bonds Water - refund 1998 issue 6/5/2008 11/1/2018 1,883,951 Water fees 210,000 21,500 5.00% 220,000 WW - refund 1996 issue 6/5/2008 11/1/2027 5,440,000 WW fees 260,000 151,813 5.00% 3,345,000 WW - refund 2003 issue 4/30/2014 11/1/2023 9,400,000 WW fees 900,000 262,300 3.00% 6,115,000 Debt Service Intergovernmental Revenue Obligations 29 2017 Remaining Intergovernmental Final Original 2017 2017 Interest Balance Revenue Obligations Issue Date Maturity Issue Funding Source Principal Interest Rate 12/31/2017 Wastewater System Fruitvale Neighborhood Sewer River Road Sewer Ultra Violet Disinfection System Energy Efficiency Project Industrial Waste Anaerobic Project Treatment Plant Improvements Industrial Sewer Main Extension 6/1/2001 7/1/2021 12/30/2005 7/1/2025 4/30/2007 7/1/2027 10/10/2011 3/31/2033 8/1/2011 7/1/2034 6/1/2012 6/1/2032 10/11/2012 6/1/2037 $1,466,250 WW fees $ 77,625 $ 1,941 0.50% $ 310,500 2,307,000 WW fees 124,246 5,591 0.50% 993,966 2,300,000 WW fees 121,389 6,676 0.50% 1,213,889 516,192 WW fees 22,107 12,718 2.80% 434,966 602,634 WW fees 24,854 14,555 2.60% 538,103 5,000,000 WW fees 269,079 20,181 0.50% 3,767,108 2,000,000 WW fees 81,340 8,541 0.50% 1,626,794 Water System Treatment Plant Improvements 9/1/2003 7/1/2023 2,559,775 Water fees 134,725 4,715 0.50% 808,350 Naches River Filter Rehab 6/27/2005 10/1/2025 894,380 Water fees 47,073 2,118 0.50% 376,581 New Water Well 4/15/2009 7/1/2028 2,257,200 Water fees 121,149 7,269 0.50% 1,332,637 Automated Meter Reading System 8/5/2013 7/1/2032 5,000,000 Water fees 263,158 10,526 0.30% 3,947,368 Treatment Lagoons (Federal) 12/12/2013 10/1/2034 3,480,000 Water fees 175,740 47,450 1.50% 2,987,580 30 Position Vacancy - General Fund Dept 601 Position Vacancy (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from 601 Position Vacancy Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 Expenses 400 Professional Svcs & Chgs 490 Miscellaneous $ - $ (1,085,000) $ - $ - $ (675,000) 62.2% n/a 31 Operafin6 Transfers - General Fund Operating transfers from General Fund are made primarily to cover debt service and to distribute tax revenues 2016 2017 Amended Proposed Fund Budget Budget SunDome Debt Service $109,234 $106,690 Parks and Recreation Utility Tax (3.5%) 1,450,000 1,513,060 Law and Justice Capital Utility Tax (0.5%) 206,500 217,800 Public Safety Communications Fund (Portion of Telephone Tax) 930,000 930,000 Fire Capital — Ladder Truck Debt Service 75,300 73,050 Debt Service for Street Project 2,023,205 2,027,655 CPI Adjustment for City-wide Street Improvement 45,306 74,159 Total Transfers 32 $4,839,545 $4,942,414 PFD - Capitol Theatre - Fund 17� Dept 174 PFD Capitol Theatre (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 273 Public Facilities District $ 639,918 $ 630,883 $ 316,835 $ 630,883 $ 661,400 104.8% 104.8% Rev Summary By Type 330 Intergov't Revenues 629,905 624,300 478,565 647,200 660,000 105.7% 102.0% 360 Miscellaneous Revenues 500 500 - 500 500 100.0% 100.0% Total Revenues 630,405 624,800 478,565 647,700 660,500 105.7% 102.0% Fund Balance Beginning Balance 176,424 166,911 166,911 166,911 183,728 110.1% 110.1% Revenues Less Expenditures (9,513) (6,083) 161,729 16,817 (900) 14.8% 5.4% Ending Balance $166,911 $160,828 $ 328,640 $183,728 $182,828 113.7% 99.5% 34 Risk Management - Fund 515 Risk Management funds 5.95 FTEs that are included in other divisions' Authorized Personnel Charts. Purchasing (670) includes .50 FTE (Purchasing Assistant), City Clerks (014) includes 0.60 FTEs (Public Records Officer) and Legal (017) includes 4.85 FTEs (Attorneys and Legal Assistants). • Administration of the program • Legal, claims adjustment, and broker services • The purchase of liability, property and other miscellaneous insurance coverages 35 Risk Management - Budget Overview Dept 515 Risk Management Rsv Exp Summary By Service Unit 661 Legal 662 Administration 663 Insurance & Bond Prem 665 Claims Paid 667 LIFT Environment Remed 669 Internal City Claims Total Expenditures Rev Summary By Type 360 Miscellaneous Revenues 380 Nonrevenues (interfund loan) 390 Other Financing Sources Total Revenues Fund Balance Beginning Balance Revenues Less Expenditures Ending Balance 36 (1) 2015 Actual (2) 2016 Amended Budget (3) 2016 Actual 09/30/16 (4) 2016 Estimated Year -End (5) 2017 Projected Budget (6) % Chng from 2 to 5 (7) % Chng from 4 to 5 $1,772,391 $1,548,370 $ 871,933 $1,391,651 $1,497,355 96.7% 107.6% 191,991 176,781 98,891 145,781 173,000 97.9% 118.7% 1,467,970 1,519,400 1,509,644 1,517,335 1,572,000 103.5% 103.6% 438,745 1,350,000 217,727 300,000 450,000 33.3% 150.0% 503,068 120,000 1,940,204 1,966,014 120,000 100.0% 6.1% 310,828 150,313 73,513 150,313 100,000 66.5% 66.5% $ 4,684,994 $ 4,864,864 $ 4,711,911 $ 5,471,094 $ 3,912,355 80.4% 71.5% 3,610,225 3,800,000 3,518,507 3,800,000 3,984,528 104.9% 104.9% - 1,000,000 - 1,000,000 - 0.0% 0.0% 281,345 94,000 20,000 94,000 94,000 100.0% 100.0% 3,891,570 4,894,000 3,538,507 4,894,000 4,078,528 83.3% 83.3% 1,526,667 733,243 733,243 733,243 156,149 21.3% 21.3% (793,424) 29,136 (1,173,404) (577,094) 166,173 570.3% 28.8% $ 733,243 $ 762,379 $ (440,161) $ 156,149 $ 322,322 42.3% 206.4% Risk Management Charges by Service Unii- 2015 2016 2017 16 vs. 17 Fund Description Actual Estimate Budget Budget 220 Code Administration $ 1,885 $ 2,074 $ 2,322 221 City Hall Facility 126,263 138,889 155,556 310 Police 614,350 449,079 502,970 320 Fire 147,506 162,257 181,727 610 Finance 18,718 20,590 23,060 650 Utility Services 3,771 4,148 4,646 700 Engineering 13,551 14,906 16,695 General Fund Total 926,044 791,943 886,976 12.0% 124 Neighborhood Development 13,200 14,520 16,262 125 Community Relations 5,817 6,399 7,167 131 Parks & Recreation 146,690 161,359 180,722 141 Streets & Traffic 163,974 180,371 202,016 144 Cemetery 8,751 9,626 10,781 150 Emergency Services 30,013 31,603 35,395 151 Public Safety Communications 40,901 35,862 40,165 170 Tourist Promotion 32,043 35,248 39,478 171 Capitol Theatre 37,026 40,729 45,617 421 Airport Operating 66,274 71,072 79,601 441 Stormwater Operating 71,835 62,783 70,317 462 Transit Operating 359,744 379,456 424,991 471 Refuse 143,892 157,074 175,923 473 Wastewater Operating 998,027 1,023,550 1,146,376 474 Water Operating 322,922 322,718 361,444 475 Irrigation Operating 83,083 88,961 99,636 560 Public Works 52,760 55,055 61,661 37 City Total $ 3,502,997 $ 3,468,329 $ 3,884,528 12.0% Cemetery Trust - Fund 710 In accordance with State law, the City maintains a trust fund for money received for endowment care when cemetery plots are sold. The corpus is to remain in trust, while interest earnings are transferred interest earnings have not been adequate to support cemetery operations, the Cemetery Fund has been supplemented Parks by the 2 . Dept 710 Cemetery Trust (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year -End Budget 2 to 5 4 to 5 Transfer Out $ 12,000 $ 12,000 $ - $ 12,000 $ 12,000 100.0% 100.0% Rev Summary By Type 340 Chrgs f /Goods & Svcs 15,709 9,000 6,161 9,000 9,000 100.0% 100.0% 360 Miscellaneous Revenue 12,000 12,000 - 12,000 12,000 100.0% 100.0% Total Revenues 27,709 21,000 6,161 21,000 21,000 100.0% 100.0% Fund Balance Beginning Balance 632,022 647,731 647,731 647,731 656,731 101.4% 101.4% Revenues Less Expenditures 15,709 9,000 6,161 9,000 91000 100.0% 100.0% Ending Balance $ 647,731 $ 656,731 $ 653,892 $ 656,731 $ 665,731 101.4% 101.4% fjt Intergovernmental - General Fund This division, included in General Fund, is used to pay the City"s assessments and other fixed obligations to external intergovernmental agencies. In the past, it was also used to account for the outside agency requests that are supported by General Fund. Now most of the contracts with outside agencies are managed through the Economic Development budget in General Fund. Dept 590/804 Intergovernmental (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % Chng 2015 Amended Actual Estimated Projected from from Exp Summary By Service Unit Actual Budget 09/30/16 Year-End Budget 2 to 5 4 to 5 567 Clean Air 37,048 37,232 27,924 37,232 37,288 100.2% 100.2% 569 Division of Alcoholism 22,430 25,000 12,477 25,000 26,000 104.0% 104.0% 575 Council of Governments 45,136 51,823 41,103 51,823 52,104 100.5% 100.5% 587 Interlocal Agreement Cnty 39,095 39,095 39,095 39,095 39,095 100.0% 100.0% 591 Court Costs 744 800 356 800 800 100.0% 100.0% 804 CERB Loan 35,601 35,601 35,601 35,601 - 0.0% 0.0% Total Expenditures $ 180,054 $ 189,551 $ 156,556 $ 189,551 $ 155,287 81.9% 81.9% (1) (2) (3) (4) (5) (6) (7) 2016 2016 2016 2017 % Chng % 2015 Amended Actual Estimated Projected from of Exp Summary By Type Actual Budget 09/30/16 Year-End Budget 2 to 5 Total 400 Other Services/Charges $ 45,880 $ 52,623 $ 41,459 $ 52,623 $ 52,904 100.5% 34.1% 500 Intergovernmental Svcs 98,572 101,327 79,496 101,327 102,383 101.0% 65.9% 700 Debt Service Principal 31,986 33,745 33,745 33,745 - 0.0% 0.0% 800 Debt Service Int/Other 3,615 1,856 1,856 1,856 - 0.0% 0.0% 39 Total Expenditures $ 180,054 189,551 $ 156,556 189,551 $ 155,287 81.9% 100.0%