The URL can be used to link to this page

Home My WebLink About2018 - Final Budget - Nick GerdeCity of East Wenatchee, Washington 2018 Annual Financial BudLye� Maw Steven C. Lacy Councilmembers Wayne Barnhart Jerrilea Crawford Timothy Detering Chuck Johnson Sandra McCourt Harry Raab John Sterk Finance Director Nick A. Gerde 2018 FINANCIAL BUDGET TABLE OF CONTENTS PAGE TITLE PAGE - 2018 FINANCIAL BUDGET.........................................I TABLE OF CONTENTS...............................................................i &ii ELECTED OFFICIALS....................................................................2 APPOINTED OFFICIALS...................................................................3 ACCOUNTING POLICY AND FUND STRUCTURE................................4 BUDGET ASSUMPTIONS AND HIGHLIGHTS5-8 - 8 SUMMARY FINANCIAL INFORMATION.......................................9 - 11 - HIGH LEVEL CASH FLOW SUMMARY (9) - CASH FLOW - MAJOR REVENUE & EXPENDITURE AREAS (10) - CASH FLOW BY FUND (11) GENERAL FUND REVENUE........................................................12 - 18 (A NARRATIVE FOLLOWED BY FINANCIAL SCHEDULES) GENERAL FUND EXPENDITURES...............................................19 - 22 (A NARRATIVE FOLLOWED BY FINANCIAL SCHEDULES) GENERAL FUND DEPARTMENT DETAIL .................................... (A NARRATIVE FOLLOWED BY A FINANCIAL SCHEDULES) GENERAL GOVERNMENT........................................................23 - 25 LEGISLATIVE........................................................................26 - 27 MUNICIPAL COURT...............................................................28 - 29 CITYCLERK...........................................................................30 - 31 FINANCE..................................................................................32 - 33 INFORMATION TECHNOLOGY..................................................34 - 35 INTERNAL SERVICES..............................................................36 - 37 LEGAL....................................................................................38 - 40 CITY ENGINEER......................................................................41 - 42 CIVIL SERVICE..........................................................................43 - 44 CENTRAL SERVICES..................................................................45 - 46 LAW ENFORCEMENT.................................................................47 - 48 PLANNING...............................................................................49 - 50 CODE COMPLIANCE.................................................................51- 52 STREET & STORM WATER MAINTENANCE FUND ..........................53 - 59 COMMUNITY DEVELOPMENT GRANTS FUND................................60 - 61 TRANSPORTATION BENEFIT DISTRICT FUND................................62 - 63 DEBT RESERVE FUND..................................................................64 - 65 LIBRARY FUND............................................................................66 - 67 HOTEL/MOTEL TAX FUND............................................................. 68 - 69 DRUG FUND.... CRIMINAL JUSTICE FUND... ....72 - 73 EAST WENATCHEE EVENTS FUND................................................................74 - 77 BOND REDEMPTION FUND....................................................................78 - 79 STREET IMPROVEMENTS FUND.....................................................................80 - 82 STORM WATER IMPROVEMENTS FUND..........................................83 - 86 CAPITAL IMPROVEMENTS FUND......................................................87 - 88 EQUIPMENT PURCHASE/MAINTENANCE & REPLACEMENT FUND ... 89 - 90 ii East Wenatchee City Officials Elected Officials Mayor Steven C. Lacy, Four year term, expiring 12/31/19 Councilmembers Position Number One John Sterk, Four year term, expiring 12/31/19 Position Number Two Harry Raab, Four year term, expiring 12/31/19 Position Number Three Chuck Johnson, Four year term, expiring 12/31/21 Position Number Four Jerrilea Crawford, Completing term, expiring 12/31/21 Position Number Five Sandra McCourt, Four year term, expiring 12/31/19 Position Number Six Timothy Detering, Four year term, expiring 12/31/19 Position Number Seven Wayne Barnhart, Four year term, expiring 12/31/17 2 East Wenatchee City Officials Appointed Officials City Attorney Devin Poulson City Treasurer/Finance Director Nick A. Gerde Police Chief Randy Harrison City Engineer Greg Pezoldt City Clerk Maria Holman Community Development Director Lorraine Barnett Code Compliance Officer Jeffrey Morrison Events Department Coordinator Dan White Municipal Court Judge Chancey Crowell 3 City of East Wenatchee, Washington 2018 Annual Financial Budget Accounting Policy and Fund Structure The City of East Wenatchee uses the revenue and expenditure classifications contained in the Budgeting, Accounting, and Reporting System (BARS) manual. The manual is prescribed by the State Auditor's Office under the authority of Washington State Law, Chapter 43.09 RCW. The City of East Wenatchee was incorporated in 1935 and operates under the laws of the State of Washington applicable to a non -charter code city with a mayor -council form of government. The City of East Wenatchee is a general- purpose government and provides public safety, street improvements, community development, municipal court, prosecuting attorney, and general administrative services. The City of East Wenatchee uses single entry, cash basis accounting, referred to as "other comprehensive basis of accounting" (OCBOA), which is a departure from "generally accepted accounting principles" (GAAP). During 2009, the City's Finance Director recommended, and the City Council approved by Resolution No. 2009-06, a "Finance and Budget Policy" which established the financial framework, approach, requirements and responsibilities for developing the "Annual Budget and Financial Plan" for the City. This Policy significantly expanded the scope of the City's Annual Budget process to include developing a five-year cash flow plan to help insure visibility of financial requirements on a longer term basis. This increased visibility provides the City Council, as the legislative body of the City, better information as to the results of current decisions (or indecisions), and the challenges or opportunities that a financial forecast would provide for future decisions or strategies. The Policy is included in the City's Annual Financial Plan. Cl CITY OF EAST WENATCHEE, WASHINGTON FINANCIAL BUDGET 2018 BUDGET ASSUMPTIONS AND HIGHLIGHTS The City's Budget Committee develops and communicates the budget assumptions that the City will use each year. Revenue is primarily the responsibility of the Finance Director, who is a member of the Budget Committee. Primary revenue estimates for 2018 include: 1. Fifteen sources of revenue for the City represent over 97% of the estimated operational revenue for 2018. They include: Percent of Amount Ops Rev A. Sales and Use Tax $3,600,000 40.5% B. Property Tax 1,767,000 19.4% C. Utility Tax 723,800 8.1% D. Gambling Tax 340,000 3.8% E. Real Estate Excise Tax 337,100 3.8% H. Storm Water Utility Operation 293,500 3.3% F. Street Fuel Excise Tax 282,000 3.2% G. Criminal Justice Sales Tax 270,000 3.0% I. Transportation Benefit District 245,100 2.8% J. State Portion — Court Revenue 200,000 2.2% L. Fines & Penalties — Court 190,000 2.1 % M. Liquor Taxes & Profits 177,000 2.0% N. Hotel/Motel Taxes 173,700 2.0% O. Franchise Fees 95,900 1.1% P. Business Licenses 86,300 1.0% Q. 19 Sources Less than $100,000 each 306,900 3.4% Sub -total Operational Revenue 9.088.300 100.0% 2. Revenue for Capital Improvement Projects: Percent of A. Storm Water Capital Projects B. Street Imp Projects — Grants C. Fund Transfers Sub -total Capital Revenue Total 2018 Revenue Estimate 5 Amount Cgp Rev $ 246,000 20.4% 2,072,400 63.2% 947.300 16.4% 3.265.700 100.0% $12.354.000 2018 BUDGET ASSUMPTIONS AND HIGHLIGHTS (continued) 3. Each revenue source was evaluated in consideration of a six year receipt history, street improvements/capital projects and transfers to support them. 4. Monthly trends over 2017 and the last six years were studied, particularly in light of recent fluctuating economic trends and experience by other cities in our region. Departmental costs are the responsibility of each Department Director. All other costs are the responsibility of the Finance Director. Primary expenditure budget assumptions for 2017 costs included the following: Budget costs conservatively: No increases in operating costs unless they can be substantiated and approved by the Budget Committee for presentation to the City Council. 2. Department Capital Costs: Any budgeted costs for capital need to be specifically budgeted and explained as to need. The City currently has forty-seven employees. Compensation for City employees not covered by either a collective bargaining agreement or an employment agreement is based upon the City's long-standing policy of wage parity. This group consists of eight full-time employees. 4. The City Attorney and Municipal Court Judge are compensated according to employment agreements. Two contracted personnel staff the Events Department. 5. The collective bargaining unit agreements with the police department unions covering twenty-one employees expire on December 31, 2017 and are in negotiation for renewal. 6. The collective bargaining unit agreement with Local 846-W covering thirteen employees in the Street, Planning, Code, Municipal Court, and Legal Departments has been renewed until its expiration on December 31, 2019. 6 2018 BUDGET ASSUMPTIONS AND HIGHLIGHTS continued 7. Healthcare premiums, commercial insurance, detention costs, RiverCom costs, and any other significant operating costs are determined through communication, agreements or quotes from those vendors. Budgeted operating expenditure categories for 2018 include: A. Labor Costs B. Benefit Costs C. Department Capital Expenses D. RiverCom 9-1-1 E. Jail Services — Detention F. Storm Water Utility Operations G. Municipal Fees Court to State H. Storm Water Utility Charge I. Muni Court Public Defense Costs J. Balance of Operating Expenses Total Operating Expenses Percent Amount of Total $ 3,986,600 45.5% 1,554,900 17.7% 340,000 3.9% 322,000 3.6% 317,000 3.3% 208,000 2.4% 200,000 2.3% 164,300 1.9% 97,100 1.1% 1,646,800 18.3% 8.836.700 100% Budgeted capital expenditure categories for 2018 include: L. Storm Water Utility Capital M. Street Improvements Capital N. Capital Expenditures O. Fund Transfers Total Capital Expenses Grand Total 2015 Budgeted Expenditures 233,900 12.1% 1,368,900 60.1% 430,000 17.60/c 947,300 10.2% $ 2.980.100 100% 11.816.800 Primary assumptions for capital costs for street improvement projects, storm water utility projects, and capital expenditures, include the following: 1. The principal source for street improvement projects is the 6 year Transportation Improvement Plan (TIP), which the City is required to provide to the Washington State Department of Transportation (WSDOT) each year in June, and other residential street projects. 7 2018 BUDGET ASSUMPTIONS AND HIGHLIGHTS (continued) 2. Storm Water Utility Projects were selected by the SWU Coordinating Committee of the Greater East Wenatchee Storm Water Utility, jointly owned by the City and Douglas County, and the City's 6 year Transportation Improvement Plan based upon an assessment of the highest needs in the City for the 2018 budget year, giving priority for those grant -funded projects. 3. Projects scheduled for 2018 include: Public City Project Description Funding Funding Total TBD Residential Paving Project 197,300 197,300 South Kentucky Overlay 295,600 52,100 347,700 Baker Avenue 77,000 77.000 Highline Drive 42,500 42,500 51h Str. SE —Baker to Eastmont 203,800 311,100 514,900 Relight Washington Project 189,400 189,400 Storm Water Projects 233,900 233,900 Design/Build Gateway Project 430,000 430,000 Fund Transfers 947,300 947,300 Total $1,162,500 $1,817,500 $2.980.000 City funding of the $1,817,500 above will be satisfied with revenue from property taxes, real estate excise taxes, transportation benefit district revenue and accumulated funds. City of East Wenatchee, Washington 2018 Annual Financial Budget Summary Financial Information CASH FLOW STATEMENTS Basis of Presentation: City of East Wenatchee Cash Accounting and Reporting is frequently depicted in different ways depending upon the amount of detail or the differing classifications of the same revenue and expenditures. These differing presentations result in the same and equal cash flows, but can be presented herein in two ways, as follows: High Level Cash Flow Summary, and 2. Cash Flow by Categories of Revenue and Expenditures Summarized Cash Flow: Hiah Level Summa 2018 2017 2017 Annual Estimated Annual Budget Actual Budget Cash Balances, Beginning of the Year $ 4,217,700 $ 5,338,800 $ 4,823,400 Revenue Non- Revenues(Pass-Through to Others) Total Revenues Total Resources Available (Cash plus Revenue) Expenditures - Non -Expenditures (Pass Through Monies) Total Expenditures Cash Balances, End of the Year 12,138,600 215,400 16,367,400 194,400 15,463,000 252,000 12, 354, 000 16, 561, 800 15, 715, 000 16,571,700 21,900,600 20,538,400 11,607,400 209,400 17,488,500 194,400 16,240,800 257,600 11, 816, 800 17, 682, 900 16, 498, 400 $ 4,754,900 $ 4,217,700 $ 4,040,000 Summarized Cash Flow: By Maior Revenue and Expense Categories 2018 2017 2017 Annual Estimated Annual Budget Actual Budget Cash Balances, Beginning of the Year $ 4,217,661 $ 5,338,817 $ 4,823,400 Revenue Received Sales & Use Taxes 3,600,000 3,480,000 3,490,000 Property Taxes - 2009 Base 1,652,100 1,632,000 1,632,000 6% Utility Tax 723,800 729,400 754,400 Gambling Tax Receipts 340,000 351,000 320,000 Real Estate Excise Tax 337,100 346,200 248,500 Street Fuel Excise Tax 282,000 280,600 281,000 Criminal Justice Taxes 270,000 270,000 270,000 Storm Water Utility Operations 293,500 204,600 263,000 Transportation Benefit District 245,100 242,100 235,000 Municipal Court Receipts - Fines 190.000 209,000 215,000 Liquor Taxes 177,000 177,000 179,000 Hotel/Motel Taxes 173,700 167,300 138,500 Franchise Fees 95,900 96,700 100,000 Business Licenses 86,300 88,700 86,600 Balance of Operational Revenue 406,381 301,024 378,700 Sub -total Operational Revenue 8,872,881 8,576,624 8,591,700 Court Receipts for the State 200,000 180,000 240,000 Other non -revenue 15,400 14,400 12,000 Total Operational Revenue 9,088,281 8,770,024 8,843,700 Storm Water Utility Capital Reimbursed 246,000 210,455 196,000 Funding for Street Improvements 2,072,349 5,944,698 6,303,700 Funding for Capital Improvements - - 57,600 Transfers for Street Improvements 947,335 1,636,489 314,000 Total Capital Project Revenue 3,265,684 7,791,642 6,871,300 Grand Total Revenue 12,353,965 16,561.666 15,715,000 Total Resources Available (Cash plus Revenue) 16,571,626 21,900,483 20,538,400 Expenditures Payroll Costs 3,986,600 3,661,800 3,762,000 Employee Benefit Costs 1,554.900 1,390,300 1,502,000 Jail Services - Adult Detention 317,000 282,000 282,000 Storm Water Utility Operations 208,000 154,000 213.000 Rivercom 911 322,000 282,000 313,000 Department Capital Expenses 340,000 455,000 393,800 Debt Service Principal & Interest 30,600 30,900 29,800 Storm Water Utility Charge 164,300 146,700 147,000 Hotel/Motel Tax to Others 14,500 14,500 12,500 Other Expenditures 1,689,503 1,571,092 1,436,300 Sub -total Operational Costs 8,627,403 7,988,292 8,091,400 Municipal Court Receipts for the State 195,000 180,000 240,000 Other Non -expenditures 14,300 14,300 17,600 Total Operational Costs 8,836,703 8,182,592 8,349,000 Storm Water Utility Capital Expenditures 233,900 77,600 206,400 Street Improvements Expenditures 1,368,865 7,601,141 6,830,000 Capital Improvements 430,000 185,000 800,000 Transfers for Street Improvements 947,335 1,636,489 314,000 Total Capital Project Costs 2,980,100 9,500,230 8,149,400 Total Expenditures 11,816,803 17,682,822 16,498,400 Cash Balances, End of the Year $ 4,754,823 $ 4,217,661 $ 4,040,000 10 Budget by Fund - 2018- City of East Wenatchee Revenue. Expenses and Changes in Fund Balances Beg Balance Add: Resources Less: End Balance Fund 1/1/2018 Revenue Available Expenditures 12/31/2018 General Fund 001 1,676,297 6,743,218 8,419,515 6,772,732 1,646,783 Street & Storm Water Fund 101 183,822 1,410,900 1,594,722 1,441,847 152,875 Comm Dev Grants Fund 102 71,724 - 71,724 32,840 38,884 Trans Benefit Distr Fund 105 266,952 245,100 512,052 197,335 314,717 Debt Reserve Fund 110 330,000 165,000 495,000 - 495,000 Library Fund 112 7,403 6,500 13,903 5,100 8,803 Hotel/Motel Tax Fund 113 2,811 14,000 16,811 14,500 2,311 Drug Fund 114 2,574 250 2,824 2,000 824 Criminal Justice Fund 116 9,836 17,340 27,176 - 27,176 Events Board Fund 117 136,223 208,574 344,797 163,500 181,297 Bond Redemption Fund 202 9,692 30,000 39,692 30,604 9,088 Street Improvements Fund 301 822,136 2,172,369 2,994,505 2,118,845 875,660 Storm Water lmpv Fund 308 232,420 246,000 478,420 244,500 233,920 Capital Improvements Fund 314 424,898 744,714 1,169,612 452,000 717,612 Equipment PM& R Fund 501 40,872 350,000 390,872 341,000 49,872 Total for All City Operations 4,217,661 12,353,965 16,571,626 11,816,803 4,754,823 Revenue Costs Capital Improvements & Proiects - 2018 Residential Street - TBD 197,335 197,335 South Kentucky Overlay 295,560 347,718 Baker Avenue 951,725 77,000 Highline Drive 234,449 42,500 5th St NE -Baker to Eastmont 203,880 514,892 Storm Water Projects 246,000 233,920 Gateway Project Design/Build - 430,000 Relight Washington Project 189,400 189,400 Total Capital Projects Revenue 2,318,349 2,032,765 Operational Revenue and Costs 9,088,281 8,836,723 Add: Fund Transfers 947,335 947,335 Total Revenue & Costs, per above 12,353,965 11,816,823 11 2018 BUDGET GENERAL FUND REVENUE Beeinnin¢ Fund Balance The 2018 beginning fund balance is projected to be approximately $2,914,900. Property Tax/Contin¢ent Property Tax It is the Finance Director's recommendation to the 2017 Budget Committee to take the allowable 1.00% increase in property tax, which the Council is expected to approve at the meeting on November 28, 2017. The total 2017 Levy is calculated by the Douglas County Assessor's Office at $1,652,097 compared to $1,622,785 in 2016. $503,500 will be allocated to the General Fund, $470,700 to the Street/SWA Fund, $30,000 to the Bond Fund for Debt Service, $165,000 to the Bond Reserve Fund, $100,000 to the Street Improvements Fund, $350,000 to the Capital Improvements Fund, and the 1.0% increase amount of approximately $29,300(Resolution 2011-18, November 8, 2011) will be allocated to the Street Improvements Fund. Sales & Use Tax Sales and Use Taxes for 2018 are budgeted to be $3,600,000, 3% higher than the 2016 budget of $3,480,000. Actual receipts are expected to approach the budgeted amount in 2017. $2,930,000 is allocated to the General Fund, $320,000 to the Street/SWA Fund, and $350,000 to the Equipment Purchase/Maintenance/Replacement Fund. Utility Taxes Utility taxes at the rate of 6% on natural gas, electricity, telephone and cellular phone service were approved by the City Council in 2009, were budgeted to be $755,400 in 2017, with an estimate to receive $729,400. 2018 budgeted revenue for utility taxes is $723,800, primarily due to the annual decreases in telephone utility tax. Gamblina Tax Gambling taxes are forecast at the same effective rate of 8%, and are budgeted to be $340,000 for 2018, in comparison to comparable receipts for 2017. Franchise Fees Franchise fees are expected to be $95,900, consistent with the $96,700 we expect to collect in 2017. These fees are paid by the local cable provider. Business Licenses Business License revenue is expected to be about $86,290 for 2018, compared to estimated receipts of $88,660 for 2017. The business license fee structure changed in 2015 and has a scheduled increase in 2017. The State Business License Service is now collecting these fees on behalf of the City according to a Washington State Legislative Directive. Buildine Permits and Plan Checkin¢ Fees Building permit revenues are dependent upon the amount of building or residential development in the City. The 2017 Building Permit estimate is $52,000. Permit fees were significantly higher in 2017 due to several non -recurring projects within the City. Plan Checking Fees generally follow the same pattern as permits, with a $25,550 Budget for 2018 compared to actual fees of $47,850 in 2017. 12 2017 BUDGET GENERAL FUND REVENUE (Continued) Gun Permits 2017 receipts are estimated to be $5,000, and the budget for 2018 is $5,000. Mariivana Enforcement Distribution The Washington State Liquor and Cannabis Board determined that cities receive a quarterly distribution to help fund or offset enforcement of marijuana. The distribution includes a portion of the State's collections of excise tax and other apportionment factors. The City expects to receive $8,116 in 2017 and has forecast same amount for 2018. PUD Privileae Tax This payment by Douglas PUD in lieu of property taxes was $40,500 in 2012, $38,092 in 2013, $41,148 in 2014, 42,561 in 2015, $41,035 in 2016 and $41,000 in 2017. $42,000 has been forecast for 2018. Liquor Excise Tax Liquor Excise Tax for 2011 was over $63,000, $48,700 in 2012, $8,896 was received in 2013 during the privatization process, $25,086 in 2014, $36,400 in 2015, $62,473 in 2016 and forecast to be $63,000 in 2017. The budget for 2018 is $63,000. Liquor Board Profits Liquor Board Profits for 2011 were nearly $92,000, $132,000 in 2012, $119,000 in 2013 $118,600 in 2014, $117,152 in 2015, $115,345 in 2016 and expected to be $114,000 in 2017. City expects to receive approximately $114,000 in 2018. Housin¢ of Prisoners This revenue is apportioned as a portion of the receipts of the City's Municipal Court. $39,400 was received in 2011, $42,000 in 2012, $53,000 in 2013, $50,000 in 2014, $40,850 in 2015, $31,948 in 2016, $24,000 in 2017 and has budgeted $24,000 in 2018. Fluctuations in caseload activity in the Court create these fluctuations. In comparison, the City is expecting to pay nearly $282,000 in each of the years 2017 and 2018 to the Regional Justice Center and Okanogan Jail for its share of housing and medical costs for prisoners. Fines & Penalties Revenue from fines and penalties of the City's Municipal Court was $294,000 in 2012, $250,000 in 2013, $236,000 in 2014, $211,000 in 2015, $220,100 in 2016, and $209,000 is forecast for 2017. The budget for 2018 is $205,000. Municipal Court Cost Offset Receipts Collections of the City's Municipal Court also provide monies to help offset certain portions of costs incurred by the City in support of court -related activities, including probation costs and public defender costs. Revenue in support of these activities was $135,891 in 2013, $120,274 in 2014, $110,413 in 2015, $114,537 in 2016 and expected to be $106,000 in 2017. The 2018 estimates for these receipts total $101,500. 13 2017 BUDGET GENERAL FUND REVENUE (continued) City "Non -Revenues" The City receives monies that it has a responsibility to pass on to other government entities such as the State of Washington. The greater portion of this non -revenue is Municipal Court Receipts that are allocated directly to the State of Washington totaling approximately $298,000 in 2012, $254,000 in 2013, $241,000 in 2014, $225,000 in 2015, $245,100 in 2016, and $221,000 is estimated for 2017. The 2018 budget is $195,000. 14 CITY OF EAST WENATCHEE /+ p /� GENERAL FUND REVENUES IGENERAL FUND REVENUE PAGE OF 2018 Budget Workshest BARS Numbers Description 2012 2013 2014 2015 2018 2017 Actual Budget 2017 2017 2016 Estimate Budger _ _Change_ Actual Actual Actual Actual 9Months 001.000.000.308.00.00.00 Beginning NC81 1,569,239 2,320,016 2,273,633 2,856,810 3,307,823 2,364,566 3,354,831 3,354,831 1,676,297 (1,678,534) Totals 1,569,239 2,320,016 2,273,633 2,356,810 3,307,823 2,304.556 3,354,831 3,364.631 1,676,297 (1,678,534) Taxes 001.000.000.311.10.00.00 Property Tax 1,137,725 246,402 1,080,900 962,834 860,815 347,000 137,628 222,000 622,000 400,000 001.000,000,313.10.00.00 Sales 8 Use Tex 2,601,982 2,951,949 3,043,647 2,848,482 2,787,103 2,893,000 2,151,984 2,860,000 2,930.000 80,000 001.000.000.313.71.00.00 Criminal Justice 176,325 239,393 244,274 259,968 285,840 270.000 185,963 253,100 270,000 16,900 001.000.000.316.51.00.00 Electric Utllit Tax 304,764 324,240 342,817 332,540 330,500 337,500 283,998 345,000 345,800 800 001.000.000.316.53.00.00 Natural Gas Utllit Tax 29,247 34,911 40,972 39,450 32,574 35,400 26,666 35,000 38,000 3,000 001.000.000.316.57.00.00 6%Tax Tele/Cellulai 471,139 438,200 406,899 389,949 356,104 382,500 265,108 349,400 340,000 (9,400) 001.000.000,316.55.01.00 Recycling 2,118 - - - - - - - - 001,000.000.317.54,00.00 Gambling Tax 278,660 287,260 218,759 303,463 348,540 320,000 259,816 351,000 340,000 (11,000) 001,000.000.314,51.00.01 Gambling Tax Penal 19,105 19,776 7,564 - 690 - 1,259 1,259 3,500 2,241 Totals 5,021,065 4,542,134 5,385,831 5,136,686 5,002,166 4,585,400 3,302,322 4,408,759 4,869,300 482,541 Lfoenses 8 Permfts 001.000.000,321.30.01.00 Fireworks Permits 360 350 600 450 355 300 850 850 800 (50) 001.000.000321.60.00.00 Taxicab Licenses 453 328 1,075 1,170 200 200 837 200 200 - 001.000.000.321.70.00.00 Amusement Licenses 2,020 1,460 730 1,260 680 - - - - - 001.000.000,321.70.01.00 Panomm Licenses - 1,290 630 630 - - - - - - 001.000.000.321.90.00.00 Other Lioneses 255 - - 100 100 100 - 001.000.000.321.91.00.00 Franchise Fees 90,402 94,058 98,528 98,955 97,896 100,000 71,170 96,700 95,900 (800) 001.000,000,321.97.00.00 Business Licenses 53,058 55,449 56,260 64,234 73,115 $5,000 87,350 88,660 86,290 (2,370) 001,000,000.321.99.01.00.00 Business License Penalties 432 1,092 1,780 3,714 3,154 59,271 1,600 74 74 - (74) 001.000.000.322.10.00.00 Building Permits 115,828 68,774 31,666 86,824 50,900 69,697 78,300 52,000 (26,300) 001,000.000.322.90,01.00 Gun Permits 4,307 5,495 4,820 5,267 6,602 5.000 4,236 5,000 5,000 - Totals 266,850 228,206 195,344 262,504 246,303 242,100 234,314 289,884 240,290 (29,594) is CITY OF EAST WENATCHEE GENERAL FUND REVENUES PAGE 2 OF 2018 BUDGET WORKSHEET PAGE 2OF BARS Numbers Description 2012 2013 2014 2015 2010 2017 Actual Budget 2017 2017 2018 Estimate Budget Actual Actual Actual Actual 9 Months In ergovemmentel - 001.000.000.331.16.60.00 Bullet Proof Vest Grant 1,066 - - - - - - - - 001.000.000.331.16.70.00 COPS Grant 89,832 - - - - - - - - 001.000.000.331.16.75.00 Dept of Commerce Grant 90,000 - - - - - - - - 001.000.000.331.16,78.00 DC Regional Share Downtown - - 5,000 - - - - - - - 001.000.000.333. 16.80.00 DOJ Video Grant 2,078 4,084 - - - - - - - - 001.000,000,333.04.21.00 WASPC Grant 1,000 - - - - - - - 001.000.000.333.06.93.00 Court Equipment Grant - 2,897 - - - - - - - 001,000,000.333,16.50.00 Cal River Drug Task Force 13,238 13,678 5,000 (8,678) 001.000.000334.03.50.00 TSC Grant 1,820 - - - - - - - 001.00.000.334.03,51.03 TSC-Night Seat Belt 1,314 1,552 2,005 1,209 2,073 3,323 772 1,000 1.000 - 001.000.000.33406.51.04 TSC Speed Limit E - - - 1,526 9,730 3,670 2,931 2,000 2,000 - 001.000.000.334.03.51.06 TSC- BoosterSeat 11 1,948 1,950 - - - - - - 001,000.000.334.03,51, W TSC- Distracted Driving 1,480 2,383 3,052 1,440 1,520 2,500 2,000 (500) 001,000.000,334.03.51.12 TSC - DUI Emphasis Patrols 769. 9,153 2,840 3,170 3,329 1,500 2,000 Soo 001.0130.000.334.04,20.10 CDBG Grant Relmb 83,892 - - - - - - 001.000.000.334.05.91.00 Public Def Grant - - - 10,000 10,000 - 400 400 - (400) 001.000.000.334.06.95.00 Rivercom Funding Assist 6,191 - - 8.903 8,903 - (8,903) 001,000.000,335,00.91.00 PUD Privilege Tax 40,512 38,092 41,148 42,561 41,035 42,500 41,049 41,049 42,000 951 001.000.000.336.06,41.00 Marijuana Enforcement 10,113 14,170 20,224 8,889 8,116 8,116 - 001.600.000.336.06.51.00 DUI Cities Allocation 4,604 5,789 4,847 2,300 2,088 2,100 1,538 2,100 2.100 - 001.000.000.336.06.94.00 Liquor Excise Tax 48,692 8,896 25,086 36,400 62,473 61,000 47,470 63,000 63,000 - 001.000.000.336.06.95.00 Liquor Board Profits 131,870 119,374 118,620 117,151 115,345 118,000 35,509 114,000 114,000 - Totals 321,916 274,461 199,955 322,879 252,806 255,427 218,548 258,246 241,216 (17,030) Charges far Servl 001,000.000,341.30.00.00 Records Services - 2,280 - - - - - 001.000.000.341,33.10.00 Background Check 1 10 20 (32) 192 84 100 - - - - 001.000.000.341.33.20.00 Passport Fees 1,100 925 - - - - - - - - 001.000.000.341.3530.00 Duplicating Services - Police 1,471 1,333 1,326 1,208 1,342 1,200 706 1,100 Boo (600) 001.000.000.341.35.31.00 Duplicating Service -Admin - 61 101 107 595 200 84 50 - (60) 001.000.000.341.35.33.00 Recording & Filing Fees 91 is iS (15) 001.000.000.341.96.10.00 Civil SVC App Fee 3,020 - - - - - - - - 001,000.00.341.35.35.00 Annual Admin Fee- Waste Mgt 5,000 5,000 5,000 10,500 10,500 10,500 - 001.000.000.341.4500.00 FFiiCng Fee Reimb- 3,479 - - - 001.000.000.342.33.00.00 Adult Probation 63,318 104,483 90,164 $4,700 $9,799 90,000 52,638 75.000 70,000 (5,000) 001.000.000.342.36,00.00 Housing of Prisoners 42,077 53,450 49,705 40,850 31,948 40,000 15,508 24,000 23,000 (1,000) 001.000.000.342.40.00.01 Fire Marshall Inspection Service 523 664 1,318 7,687 4,360 3,500 8,395 3,500 3,500 001.000.000,345,83.00.00 Plans Checking Fees 65,875 37,428 1 17,251 1 26,250 1 24,615 20,000 40,906 47,851 25,551 (22,300) 001, 000.000.345.83.41, 00 Engineering Review Fees 2,229 984 750 924 1,000 1,000 - 001.000.000.345.89.00.00 SEPA Permits 904 1,332 569 1,129 618 Soo 903 800 Soo - 001.000.000.345.8900.00.00 Planning & ntFees 3453 2,323 2,233 5,927 2,795 3,000 6,314 6,000 3,000 (3,000) Totals 1$1,751 204,188 182,835 178,658 162,231 164,250 76 136,893 169,816 137,951 (31,865) GENERAL FUND REVENUES 2018 BUDGET WORHSHEET PAGE 3 OF 4 PAGE 3 OF BARS Numbers Description 1 2012 2013 2014 2015 2010 2017 Actual Budget 2017 2017 2018 I Estimate Budget Actual Actual Actual Actual 9Months Fines & Penalties 001.000.000.356.60.00.00 Fines &.Penalties 294,250 249,815 236,437 211,289 220,107 216,000 151,477 209,000 190,000 (19,000) 001.000.000.357.33.00.00 Public Defender- Muni Coun Recei is 30,030 31,408 30,110 25,713 29,222 29,000 23,097 31,000 29,500 (1,500) 001000.000.357.39.0100 Restitution - 238 15 26 - - - - - Totals 324,280 281,462 266,562 237,028 249,329 244,000 174,574 240,000 219,500 (20,500) Miscellaneous 001.000.000361.11.0000 Interest Earnings 5,962 5,322 4,124 7,731 21,709 15,000 33,632 40,951 41,961 1,010 001,000.000.361,40.00.00 Sales Tax Interest 832 608 621 1,550 2,221 1.920 2,115 2,000 2,600 - 001.000.000.362.40.00.05 Rent Income 88 9th St. NE. 4,600 9,650 - - - - 001.000.000.369.20.00.00 Unclaimed Property 280 22 - - 001.000.000369.90.50.00 Miscellaneous 555 1,396 1,803 2,282 4,355 1,000 3,026 4,500 5,000 500 Totals 7,349 7,326 6,828 16,385 37,936 17,920 38,773 48,051 49,561 1,510 Sub -Total Current Revenues 6,123,211 5,537,866 6,217,155 6,154,140 5,960,771 5,509,097 4.105,424 5,392,756 5,777,818 385,062 Non -Revenues 001.000000.389.3000.03 Fireworks - Cleanin Deposit 2,000 2,500 3,600 2,500 2,000 2,000 2,000 2,000 2,000 001.000.000.389.30.00.04 Fireworks - DCFD Remittance 250 400 250 200 200 250 250 250 - 001.000.000.389.30.0005 Crime Victim Assessment 5,492 4,769 4,394 3,913 4,150 4,000 2,622 3,800 3,850 50 001.000.000.386.89.60.00 State Building Code Surcharge 350 401 284 492 454 300 288 300 300 - 001.000.000.386.89.55.00 State Sham of Gun Permits 7,082 9,818 7,797 8,380 11,332 9,000 7,015 9,000 9,000 - 001,000,000.386.91.00.00 State Court Remittance 296,118 253,797 241,488 224,583 245,135 240,000 147,478 221,000 200,000 (21,000) 001,000.000.388.00,00.10 Other Non- Revenues - - 154,860 1,077 809 500 - - - 001,000.000.380.00.50.05 Engineenng Reimbursement 1120 350 - - - - - - 001.000.000.38630,00.00 Rent Deposit 889th St. NE. 1,600 (1,600) - - - 001.000.000.366.00.15.00 Auditor Recording F 72,00 77.00 - - - - 001.000.000.389.00.20.00 Insurance Recovenes 2,314 12,848 25,444 4,259 - - - 001,000.000.395.10.00.00 Disposition of Assets 7,020 8,646 2,980 32,774 - - 001.000.000.697,95.00.25 Transfer In -Street Impv Fund 1,250,000 750.000 750,000 Total Current Non- Revenues 323,816 292,853 441,474 248,043 294,594 1,506,000 159,654 236,350 965,400 729,050 Total General Fund Revenues Before SWU 6,447,027 5,830,719 6,658,630 6,402,183 6,255,365 7,015,097 4,265,078 5,629,106 6,743,218 1,114,112 17 GENERAL FUND REVENUES PAGE 4 OF 4 2018 BUDGET WORKSHEET STORM WATER UTILITY REVENUES PAGE 4 OF BARS Numbers Description 2012 2013 2014 2015 Will 2017 Actual Budget 2017 2017 201e Esdmale Budget Actual Actual Actual Actual 7Months 050.000.000.343.13.00.00 SWU Malnt Svcs 050.000,000.343,13.00.20 SWU Admin 18,463 24,141 18,812 - - - - 050.000,000,343.13.00.30 SWU Small Improve $7,076 49,343 99,811 - - - - 050.000.000.343.13.00.33 WVSWP Decant Facility 10,651 - - - 050.000.000.343.13.00.34 19th Sir Pone Purchase 155,600 - - 050.000.000.343.13.00.Var SWU-Canyon APha 369,620 1 309,602 - - - - SWU-Canyon A Phase 4 1,471 - - - - 050.000.000.343.13.00.61 3re Street SWU Ret - 25,679 - 050.000.000.343.13.00.67 GR Storm Pipe Rehab 13,259 - - - - 050.000.000.343.13.00.85 DOE DEW NPDES LID Design (New Grant) 86,422 050.000.000.343.13.00.87 NPDES Maintenance Capital Outlay - (Sweeper) 245,807 050,000.000.343.13.00 Var DOE NPDES Grant - 050.000.000.343.13.00.83 DOE Capacity Grant 20,735 70,323 - - - - - - - 050.000.000.343.13.00.90 Greater EW SWUN 156,483 161,717 145,078 050.000.000.343.13.00. 92 NPDES O&M Alloca - - - - - - - - 050.000.000.343.13.00.94 Other SWU Activities - Comp Plan 5,184 2,835 - - - - 050.000.000.343.1300.3 salmonAve Dealt; 6,891 263 037EastmonlAvSDC050.000.000,343.13.0 - 050.000.000.343.13.00.39 1 Eastmont Ave Construction 354,855 Total Storm Water Revenues 659,267 975,417 805,425 - Grand Total General Fund Revenues 7,106,294 6,806,136 7,464,055 6,402,183 6,255,365 7,015,097 4,265,078 5,629,106 6,743,218 1,114,112 Total Available Resources 8,675,533 9,126,152 9,737,688 9,258,993 9,563,188 9,379,653 7.619,909 8,983,937 8,419,515 (564,422) 9 Months Year Allocation of Property Tax: 2013 2014 2015 2016 2017 2017 2017 2018 General Fund 1,137,725 246,402 1,080,900 962,834 860,815 222,000 137,528 222,000 622,000 400,000 Street Fund 200,000 260,000 300,000 350,000 475,000 500,000 460,000 500,000 500,000 - Bond Redemption Fund 180,000 185,000 185,000 185,000 20,000 20,000 20,000 20,000 30,000 10,000 Debt Reserve Fund 165,000 165,000 165,000 165,000 - Street Improvements Fund 15,342 683,119 15,714 116,042 4,500 575,000 325,000 575,000 100,000 (475,000) Capital Improvements Fund 190,000 75,000 150,000 90,000 1 150,000 350,000 200,000 Total 1,533,067 1,564,521 1,581,614 1,613,876 1,600,315 1,632,000 1,032,528 1,632,000 1,767,000 135,000 Allocation of Sales & Use Tax: 2012 2013 2014 2015 2016 2017 2017 2017 2018 General Fund 2,601,982 2,951,949 3,043,647 2,848,482 2.787,103 2,893,000 2,151,984 2,850,000 2,930,000 80,000 Street Fund 336,000 250,000 250,000 294,000 290,000 310,000 310,000 310,000 320,000 10,000 Library Fund 3,500 ' Criminal Justice Fund 25,000 ' Events Fund " E,P,M&R Fund 203,000 434,300 277,000 320,000 320,000 350,000 30,000 Street Improvements Fund ' Capital Improvements Fund Total 2,962,982 3,201,949 3,293,647 3,348,982 3,511,403 3,480,000 2,781,984 3,480,000 3,600.000 120,000 18 2018 BUDGET GENERAL FUND EXPENDITURES The following expenditure summary is provided as a reflection of each category and/or department that is supported by funding in the City's General Fund. The categories either represent the nature of the expenditures or the department which is supported by those expenditures. A description of each is as follows: General Government: This category primarily includes payments to other governmental entities that provide services or support to the City, including RiverCom, the regional 911 center for Chelan and Douglas Counties; Wenatchee Valley Animal Control, LLC, a subsidiary of the Humane Society; and the Chelan Douglas Transportation Council, responsible for transportation planning in the Wenatchee Valley Urban Area. In late 2014, the City entered discussions with the City of Wenatchee to provide financial support to the Wenatchee Valley Museum and Cultural Center. Those discussions culminated in a joint agreement for funding for the years 2015 thru 2019. Legislative: This category includes payroll for the Mayor, City Councilmembers and administrative support, as well as election and other costs. At the end of 2010, the Municipal Court determined that public defender activities were a potential conflict of interest for the Court to be charged for and managed in that department. Since then, these costs and the contracts with law firms to satisfy these functions are now part of the Legislative function of the City. Douglas County also allocates costs for elections and charges the City for its share. Municipal Court: Includes costs of operation of the court, including payroll and benefit costs for four full-time employees and the judge, who is paid based upon an employment contract. City Clerk: Includes payroll and benefit costs for the City Clerk and, prior to 2017, a 2/3 part-time assistant. The City Clerk's desk provides agendas/minutes/documentation for Council meetings, maintains the City Code, maintains ordinances/resolutions and overall records management for the City, among other activities. Internal Services: Includes the shared costs for copying, telephone and postage. Finance Department: Includes payroll and benefit costs for the Finance Director, half- time accounting assistant and half-time processing clerk. Accounting for revenue receipts, expenditures, payroll/payroll taxes, internal monthly financial statements, external financial reporting, budget origination/management and the annual financial plan are their primary activities. Information Technology: This department was developed during the 2010 budget process to accumulate costs associated with the management of the City's information technology assets. Budgets for network system support through an outside vendor, software, licenses, hardware and peripheral equipment are managed in this department. Legal Department: Includes the payroll and benefit costs for the City Attorney, part- time assistant and supporting department costs. The City Attorney is also the prosecuting attorney for the City's Municipal Court. 19 2018 BUDGET GENERAL FUND EXPENDITURES (continued) Civil Service: Includes costs for the periodic necessity to retain a civil service secretary on an as -needed basis for testing in recruiting law enforcement personnel. Central Services: Includes the costs to service, maintenance and improvements to City Hall and portions of the City campus. Law Enforcement: Includes the costs of staffing and operating the City police department. Department staffing includes the Chief of Police, the Assistant Chief, three sergeants, two detectives, fourteen patrol officers, two records specialists and an executive secretary. Jail Services: Includes the City's cost for retention of adults and juvenile offenders, according to agreements with the Chelan County Regional Justice Center in Wenatchee and the Okanogan County Jail in Okanogan (the City does not have a jail). City Engineer: This department was established in 2010 after the Council approved hiring a City Engineer to offset a portion of engineering costs for planning and managing capital and street improvement projects. The City Engineer is also the Public Works Director and oversees activities of the street and storm water maintenance functions. Planning Department: Includes the payroll and benefit costs for the Community Development Director and a portion of the Building Permit Technician, as well as common department support costs. Code Compliance: Includes the payroll and benefit costs for the Code Compliance Officer and an allocation of cost for administrative support provided by the Building Permit Technician, as well as common department support costs. Non -Expenditures: In a governmental accounting framework, these expenditures primarily represent "pass -through" monies that the City is receipting, serving in a temporary custodial function, and subsequently distributing to the agencies or organizations which are entitled to the monies. For example, the largest amounts of pass - through monies are collections of fines and penalties occurring in the City's Municipal Court, a portion of which are subsequently remitted monthly to the State of Washington. 20 CITY OF EAST WENATCHEE CURRENT EXPENSE EXPENDITURES RECAP GENERAL FUND EXPENDITURES PAGE OF 2018 BUDGET WORKSHEET SUMMARY Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual Me Actual 2017 Budget 2017 9Months 2017 Estimate 2018 Budget Chancle 001 520-596 General Government 413,433 409,095 427,882 526,121 448,888 576,577 432,365 568,837 592,930 24.093 110511 Legislative 316,754 314,759 331,857 340,395 352,689 445,092 203,909 404,528 492,563 83,035 120512 Municipal Court 316,969 351,665 339,730 329,621 353,778 364,300 106,009 362,100 352,600 (9,500) 140514 City Clerk 133,016 142,176 143,001 147,258 162,372 127,350 70,417 110,300 131,650 21,350 141 514 Internal Services 36,133 36,740 29,061 28,783 33,754 34,000 27,739 36,500 37,250 750 142514 Finance 176,168 209,145 214,683 225,429 213,775 257,200 210,098 311,800 266,900 (44,900) New Information Technoloy 90,274 99,999 114,624 122,831 150,455 155,631 104,999 135,369 178,900 43,531 151 515 Legal Department 172,917 182,418 173,744 172,906 189,084 106,800 143,919 107,600 206,100 8,600 160521 Civil Service 3,749 2,965 3,694 3,432 3,363 3,800 907 4,000 4,300 300 180518 Central Services 124,419 117,608 128,697 268,221 180,161 192,500 82,926 278,900 202,800 (76,100) 210521 Law Enforcement 2,907,550 2,707,543 2,917,811 2,861,348 2,903,494 3,037,300 2,108,643 2,937,457 3.243,000 306,113 230523 dell Services 288,079 286,893 299,004 275,369 306,494 1 282,000 204,814 282,000 317.000 35,000 315 542 City Engineering Dept 106,609 96,788 115,148 121,061 125,168 149,800 61,762 130,500 126,100 (4,400) 280558 Planning 123,111 204,416 136,751 139,907 146,442 198,650 106,378 185,500 236,525 51,025 590559 Code Compliance 143,095 155,505 154,265 157,782 165,070 171,083 116,460 167.969 174,164 6,195 Sub -Total Routine Expenditures 5,351,296 5,317,605 5,528,952 5,710,164 5.724,947 6,192.383 4,041,343 6,113,290 6,553,382 460,092 001.001.589.3 Firwroks Cleaning Deposit 850 Boo 1,000 Boo Boo 1,000 800 Boo - 001.001.589.3 DCFD Fireworks Remittan 200 (50) 1,000 250 200 200 - 200 200 - 001 001 589.3 Cinme Victims- County Slu 5,447 4,768 3,515 4,065 5,108 4,200 1,699 3.000 3,000 - 001.001.589.3 Building Code Surcharge 318 392 261 530 379 400 225 350 350 - 001 001 589.3 State Share of Gun Permits 6,334 8,788 7,454 9,878 10,691 10,000 7,745 10,000 10,000 - 001 001 589.3 Court Remittances 279,604 254,473 242,517 224,283 245,220 240,000 134,383 150,000 195,000 15,000 001.001,597.2 Non-Exp Transfers Out SWA Capital lmpv Fund r/308. - - - - 001.001.586.5 Contingency 600 (320) 35 2,000 - - - - 001001597.9 Ttansier Out to St lmpv Fund 301 1,250.000 - 1,000,000 - (1,000,000) Non-Exp Kent Annex PWTFL 0010015860 Non-Exp Engr Reimburse 1,120 350 - - - - - 001.001.689.9 Other Non -Expenditures - - 152,728 1,000 225,000 - - - - - Sub -Total Non -Routine Expenditu 293,623 268,901 408,660 241,006 487,297 1,507,800 145,252 1,194,350 209,150 (985,000) Total Current Expense Expenditure 5,644,919 5,586,506 5,937,612 5,951,170 6,212,244 7,899,983 4,186,595 7,307,640 6,772,732 (534,908) 21 GENERAL FUND EXPENDITURES CITY OF EAST WENATCHEE SUMMARY CURRENT EXPENSE EXPENDITURES RECAP Page 2 of 2 Page 2 of 2017 BUDGET WORKSHEET Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 2017 Budget a Months 2017 Estimate 2018 hedger Storm Water Utility Operations: 050.000.311.5 Administration 61768 19,599 7,023 7,023 SWU Annual Billing Fee 14,872 5,933 5,933 050.000.311.5 Comprehensive Plan 25,869 Total Administration 6,768 60,340 1 12,956 12,956 050.000.311.5 Capital Projects - Small Car 46,299 121,964 53,562 53,562 050,000.312.5 Capital Projects -Canyon A Phase 3 SDC 14,113 050.000.312.5 Capital Projects - CanyonA 363,040 242,227 Capital Projects - Canyon A 5,454 lee Capital Projects -Canyon A Ph 4 Constr 124,908 050.000.312.5 3rd Street SWU Retrofit Design Engr 2,905 17,100 17,100 3ro Street SWU Retrofit Construction 15,313 - 050.000.312.5 WVSWP Decent Facility 1 10,651 10,551 Eablmont SWU Rebuild - SDC&Constr 381,244 VMP LID Project Design 1 5,920 92,349 92,349 Grant Road Pipe Lining Project 18,285 90,960 90,960 Total Construction Ca 414,793 927,045 264,622 264,622 - 050.000.313.5 NPDES Compliance 142,816 163,094 ll6,963 116,963 Capital Outlay- Sweeper and ATV (Sprayini 7,390 246,3al 246,331 191b Street SWU Pond Pu 155,600 155,600 Sub-Totall WU Operations 564,377 1,157,868 798,fi22 796,522 050.000.315.5 Annual Street Utility Charge 146,790 146,790 168,745 t46,745 Total- Storm Water Utility Expenditi 711,167 1,304,659 943,267 943,267 Grand Total - General Fund EXp 6,356,086 6,691,165 6,880,879 6,894,437 6,212,241 7,609.983 4,186,595 7,307,640 6,772.732 (534,908) Total Available Resources - Rev 5,675,533 9,126,152 9,737,688 9,258,993 9,563,188 9,379,653 7,619,909 8,983,937 8,419,515 (564,422) Fund Balance, End of Budget Y 2,319,447 2,234,987 2,856,808 2,364,556 3,350,9441 1,679,670 3,433,314 1,676,297 1,646,783 (29,514) 22 2018 BUDGET GENERAL FUND GENERAL GOVERNMENT Wellness Program The Wellness Program is an employee incentive program started in 1999. Expenditures have included gym equipment, refreshments for blood drives, and registration fees for an employee to attend the AWC Wellness Program training. In early 2013, the City determined to pursue greater development of a wellness program which could potentially result in a reduction of its health insurance premiums. The Executive Assistant to the Mayor is the coordinator of this effort, a wellness committee has been established which represents every department in the City, the qualification process began with wellness activities regularly scheduled throughout the year. The City completed the AWC qualification in 2014 and has been certified. The resulting 2% reduction of medical premiums began in 2015, the City was re- certified in 2015 for the reduction to repeat in 2016 and 2017to save the City approximately $15,500 annually. Based upon the increase in employee wellness activities and participation, the wellness budget has been increased accordingly. LEOFF 1 Insurance Premiums This line item pays the insurance premiums for LEOFF 1 retired officers as well as the City's portion of medical expenses for LEOFF 1 active and retired officers. These medical expenses are typically unreimbursed medical expenses (that is, deductibles and patient share of medical expenses). Non -routine reimbursements are approved in advance by the Douglas County Disability Board. Premiums have been reduced substantially during 2014 due to insuring that the four participants qualify and obtain a medicare Part B insurance policy. That factor has allowed a significant reduction in the premiums paid by the City in year after 2014. RiverCom RiverCom annual costs are estimated to total $322,026 in 2018, an increase of 2.88% due to higher call volumes in the annual period of July 2016 thru June 2017. Past monthly payments were as follows: Year Monthly Amount Percent of Change 2004 $20,756.43 2005 $20,756.43 0.00% 2006 $17,559.20 (15.40)% 2007 $19,555.50 11.37% 2008 $21,234.75 8.59% 2009 $22,606.08 6.50% 2010 $21,376.83 (5.4%) 2011 $23,825.00 11.45% 2012 $22,260.25 (6.60%) 2013 $21,899.58 (1.62%) 2014 $22,656.42 3.46% 2015 $22,885.33 1.27% 2016 $23,509.50 2.72% 2017 $26,083.42 10.95% 2018 $26,835.50 2.88% Animal Control The Wenatchee Valley Humane Society annual cost is budgeted to be $70,700 per year, based upon a CPI adjustment included in their "Contract for Services" with the City for the period 1/1/2012 through 12/31/2014 with an automatic renewal for three years. Annual changes in expenditures have been as follows; 23 Year Annual Total Percent of Increase 2004 $42,623 2.3% 2005 $43,944 3.1% 2006 $58,006 32.0% (annexation) 2007 $59,064 1.8% 2008 $60,777 2.9% 2009 $63,633 4.7 % 2010 $63,633 0.00% 2011 $64,600 1.52% 2012 $66,483 2.92 % 2013 $67,214 1.10 % 2014 $68,316 1.64% 2015 $69,546 1.8 % 2016 $69,756 0.3% 2017 $70,200 0.64% 2018 $73,513 4.70% Chelan/Douglas TranSportation Council (formerly Metropolitan Plannine Oreanization The membership dues amount will be $13,005 in 2018, a monthly increase of $255 or 2%. NCW Economic Development District The membership dues amount will be $1,000 in 2018, the same as in the previous years. Contributions to the Wenatchee Valley Museum and Cultural Center Effective January 1, 2015 and continuing until December 31, 2019, the City entered into a Joint Agreement between the City of Wenatchee, City of East Wenatchee and the Museum to help fund the operations of the Museum. The City of Wenatchee agreed to a total annual amount of $270,000, payable in monthly installments of $22,500, and the City of East Wenatchee agreed to a total annual amount of $111,276, payable in monthly installments of $9,273. The City expects to fund these contributions from sales tax revenues, with the possibility to include a portion of Hotel/Motel tax revenues, as long as they qualify. Community Mental Health Quarterly, state -mandated payments in the amount of 2% of the City's quarterly liquor board profits receipts are remitted to the Chelan County Treasurer for community mental health (serving Chelan and Douglas Counties). $3,500 is budgeted for 2018, based upon current trends. 24 018 BUDGET WORKSHEET - Department Head -Finance BARS Numbers Description 0010.000.001.515.10.40.00 Prof Svcs Legal 00 1.000.00 1. 518.91.50. 00 Wellness Program 001.000.001.518.93,49.00 City Theme 001.000.001.521,10.29.00 LEOFF 1 001.000.001.528.70.51,00 RiverCom 001,000.001,539,30.51.00 Animal Control 001.000.001.557.20.35.00 Okanagon Trans & Nutntir 001,000,001.558,20.30.00 Community Foundation of NCW 001.000.001.558.60.41.00 Chelan -Douglas Trans Council 001.000.001.558.70.41.00 NCW Economic Dev District 001.000,001,558,70.41.05 Chelan Douglas Trends - CFNCW 001,000.001.558.70.41.07 Wenatchee Valley Chambi of Commerce 001.000.001.558.70,41.10 Spirit of Wenatchee- Miss Veedol Housing 001.000.001.558,70.41.15 Wenatchee Valley Museum & CC 001,000.001.596,70,55.00 Contributions -Region 001.000-001.584.00.52.00 Community Mental Health 2%Liquor) 001.000.001.559.50.53.00 Rental Utilities Totals i I GENERAL GOVERNMENT 2011 2012 2111 2014 1116 2016 2017 2017 2017 2018 Actuals Actual Actual Actual Actual Actual Budaat 9 Months Estimate Buda1 263 500 834 2,169 1,711 1,880 2,000 1,490 2,000 2,500 600 1,436 600 10,000 820 1,000 1.000 - 67,040 63,013 62,795 56,064 38,618 33,176 38,400 23,082 34,000 36,000 1,000 286,467 267,629 263,362 272,460 275,205 282,710 313,001 236,206 313.001 322,026 9,025 63,634 66,483 67,214 68,224 69,546 69,766 70,200 52,660 70,200 73,513 3,313 900 900 900 Soo 1,000 1,500 - 10,434 10,434 10,434 10,434 12,500 12,500 12,750 12,760 12,750 13,005 265 1,000 1,000 1,000 1,000 1,000 1,000 1,260 1,260 1,250 1,260 - 1,600 1,500 1,600 1,500 1,500 1,500 - 360 360 360 - 3,000 3,000 3,000 3,000 3,000 3,000 3,000 - 10,000 111,276 27,819 111,276 83,467 111,276 111,276 - 7,426 10,600 16,000 16,000 16,000 26,000 10,000 3,101 3 2,566 2,161 2,903 44 4,8 3,600 - 1,801 3,500 - 3,600 - - - 338 3,611 424,177 414,333 409,094 427,882 526,121 1 448,889 1 581,877 1 432.365 568.837 1 592.930 24,093 Note: At the 3/28/2017 City Council MeeOn , approval for $5,000 each for the years 2017 and 2018 for the Wenatchee Valley I Sports Foundation in support of Winter Special OI m ics. $5,000 to United Wa for "Our Valle Our Future" $5,000 each in 2016 & 2017 United Wayfor "Our Valley Our Future" 2018 $5,000 Fireworks, $5,000 Winter Olym Ics and $10.000 "Our Valley Our Future", $5,000 Chelan Port "Destination San Francisco Bay" Flight 2018 Animal Control (Humane Societv) was re-neaolialed to $73.512.82 annually. oavable monthly. for 2018. 2019 and 2020. 25 2018 BUDGET GENERAL FUND LEGISLATIVE DEPARTMENT Salaries Fifty percent of the Executive Secretary (to the Mayor)/Accounting Assistant salary and the currently open position of Public Information Officer are budgeted under the Legislative Department, as well as the Mayor and City Council positions. Benefits The benefits line item includes basic benefits such as benefits, retirement, and insurance for 50% of the insurance benefits for the Mayor beginning in 2010. Public Defender Court & Conflict Costs L&I for the Mayor and Councilmembers; basic Executive Secretary position; and added health During 2010, the Municipal Court determined that budgeting for and having implied responsibility for the Public Defender(s) was inconsistent with the necessity for independence of the judge, prosecutorial and public defender roles in the court environment. Consequently, those costs have been transferred to the Legislative area under the primary influence of the Mayor. Newsletter During 2012, the Mayor implemented the process of developing a periodic City newsletter for distribution by mail, by e-mail from a developed listing, and posting on the City website. The Mayor's Executive Assistant manages the collection of written materials provided mostly by Department Heads and staff, printing and distribution. Two issues are planned for each year. Other Expenses Other expenses are self-explanatory according to their titles and nature. The level and changes in these expenditures reflect specific analysis by the department head. ple CITY OF EAST WENATCHEE LEGISLATIVE EXPENDITURES 2018 BUDGET WORKSHEET- Department Head - Finance c� e T LEGISLATIVE BARS 2011 2012 2013 2014 2015 2016 2017 1 2017 2017 2018 $$ Change Numbers Description Actuals Actual Actual Actual Actual Actual Budget 9Months Estimate Budget 001.000. 110.511.60.10.00 Salaries 127,361 132,100 134,467 137,333 141,617 147,319 200,000 118,469 170,000 210,500 40,500 001,000. 110,511.60.20.00 Benefits 26,739 28, 009 30,175 32,610 33,727 34,816 56,000 28,024 40,000 87,000 47,000 001.000. 110.511.60.21.50 Public Defender- 95,500 96,000 97,487 98,700 98,900 93,628 91,100 68,457 91,100 97,200 6,100 Court 001.000. 110.511.60.30.00 Public Defender- 5,430 5,640 3,480 4,489 6,645 5,018 61000 4,703 6,000 6,000 Conflicts 001.000. 110.511.60.31.00 Office Supplies 34 100 56 132 130 152 126 28 125 235 110 001.000. 110.511.60.31.05 Newsletter PrintingSMailing (21ssu 8,330 7,692 8,875 8,965 8,577 9,100 10.283 9,600 9,500 001.000. 110.511.60.40.00 Training 946 460 1,243 1 2,643 T,800 7,804 8,200 8,000 (200) 001. 000. 110.511.60.4 1.00. Prof Services 1,549 6,318 880 663 10,146 7,890 28,000 14.146 25,000 26,000 001.000.110.511.60.41.20 AWC Annual Fee 7,303 8,133 8,170 8,252 8,348 8,444 8,567 8,567 8,667 8,828 261 001.000.110.511.60.43.00 Travel 1,654 243 1,338 580 1,124 1,850 2,600 1,120 2,600 2,500 001.000.110.511.60,43.01 Travel - Misawa 4,220 5,198 4,193 2,595 4,762 7,500 7.500 7,600 001.000.110.511.60.44.00 Advertising 163 1,336 1,000 (331) 001.000.110.511.60.45W Election Coss - Reg 16,160 18,960 16,878 22,408 16,014 21,594 22,000 ]34 22,000 17,000 (5,000) Voters 00 1. 000. 110. 511.60.45.05 Election Costs- 4,651 Officials 001.000,110,511,60.46.00 Insurance 3,611 4,395 5,780 7,912 6,403 6,233 6,700 7,200 7,900 700 Insurance Deductiblds 4,808 001.000. 110.511.60,47.00 Background Check 30 10 565 so 76 818 60 Costs 001.000.110.511.60.49.00 Miscellaneous 2,192 3,409 2,569 5,170 4,562 4,237 5,500 3,006 6,500 4,400 (1100) Totals 292,149 315,830 314,726 331,826 340,396 352,689 449,942 287,819 404,528 492,663 88,035 Training Budget 2016: $1,500 for new Councilmember training and Councilmembers attending AWC annual or regional meetings. $1,500 for Human Resource Training. Travel Budget 2016: $1,500 for Councilmembers travel and $1,000 for travel associated with Human Resource Training. Miscellaneous: Includes $500 for memberships for Human Resource function. 2018 - Professional Services: Broker Insurance Commission $10,600 and $14,400 for Consultants for Consolidation Evaluations 27 2018 BUDGET GENERAL FUND MUNICIPAL COURT Salaries The Court Administrator, Probation Counselor and Clerk/Bailiff are currently paid through the Municipal Court, as well as the Judge who is on contract. Benefits This line item is payroll taxes; medical, dental, and vision premiums; and retirement contributions for the Court staff listed above. Public Defender and Public Defender Conflicts Costs have been transferred to the Legislative area because of conflict of interest considerations. Municipal Court Judge The Municipal Court Judge is under contract for 2018 at $6,000 per month salary, with associated payroll taxes, but without medical benefits, under a contract extending thru 2021. Compensation for the Judge is now included above in Salaries and Benefits. Judge Pro Tern Through careful planning by the Judge to coordinate vacations with the court schedule and because the Judge has not been required to miss a day's work due to illness, the use of proteins for reasons directly related to the Judge have been minimal. Only one affidavit of prejudice has been filed in the last six years against Judge Crowell and there have been minimal conflicts. However, the budget must have a sufficient amount to anticipate that the Judge may be ill, there may be more conflict cases or there may be affidavits of prejudice filed against Judge Crowell. The current contract with the Judge was negotiated based on a projected pro tem budget adequate to provide for those possibilities. Interpreter Interpreter costs will increase due to using a new individual for interpreting. The average cost for uncertified interpreters is $35 per hour and $50 per hour for certified interpreters. In the past, our interpreter charged $25 per hour even though the rates set forth herein above are the minimum established by the Administrative Office of the Court (AOC). Case Filings Criminal case filings are up over last year's figures. In 2016 there were a total of criminal cases filed. Through August of this year criminal cases have been filed with a projected total of cases for the year. Other Cost Line Items Other expenses are self-explanatory according to their titles and nature CITY OF EAST WENATCHEE MUNICIPAL COURT EXPENDITURES MUNICIPAL COURT 2018 BUDGET WORKSHEET - Head of the Judicial Branch of the City of East Wenatchee (currently Judge Crowell) BARS Numbers Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 9Months 2017 Estimate 2018 Budget $$ Change 001.000. 120.512.50, 10.00 Salaries 192.725 190,373 192,600 179.449 182,510 187,600 141,445 190,000 174,100 (15,900) 001,000, 120.512.50.12.00 Salaries -Probation Svcs 10,780 30,661 25,451 38,536 45,014 46,200 34,526 46,000 48,900 2,900 001.000, 120,512.50.20,00 Benefits 74,774 70,028 62,971 47,273 56,715 65.000 46,946 56,000 57,000 2,000 001.000. 120.512.50.22.00 Benefits -Probation Svcs 7,141 18,280 23,808 229,392 31,321 36,600 21,904 36,500 32,600 (4,000) 001.000. 120.512.50.31.00 Office Supplies 2,573 3,292 3,772 2,250 3,740 2,800 2,230 2,500 2,800 300 001.000.120.512.50.40.00 Training 678 1,187 1,650 490 1,305 1,600 840 1,500 1,500 - 00t000.120.512.50.41.01 Public Defender" 255 - 001.000, 120.512.50,41.03 Judge _ 001.000. 120.512.50.41.05 Public Defender Confilicts 360 001.000. 120.512.50.43.00 Travel 2,484 1,606 3,478 3,416 3,232. 4,000 1,440 3,600 4,000 Soo 001.000. 120.512.50,46,00 Insurance 5,259 5,713 6,946 7,166 7,715 7,600 297 8,700 9,600 900 001.000. 120.512.50,49.00 Miscellaneous 625 800 696 1,114 675 1,200 249 1,000 1,200 200 001.000. 120.512.50.49.01 Interpreting Services 6,185 6,641 7,114 8,445 11,245 6,600 5,245 6,600 5,000 (11600) 001.000. 120.512.50,49.02 Judge Protems 1,125 1,082 1,275 825 863 4,000 1,800 1,600 4,000 2,400 001,000,120.512,50.49.03 Witness Fees 253 671 261 1,140 227 Soo Ila 300 Soo 200 001,000, 120.512.50.49.04 Juror Fees 3,530 5,500 1.751 1,104 1,215 1,500 1,274 1,500 1,500 001,000, 120,518,30,00.00 Security 4,911 5,033 5,170 4,774 5,667 4,600 3,130 4,500 5,000 600 001.000. 120.594.21.60.00 Capital Outlay 3,671 10,709 2,787 3,886 2,334 5,000 3,642 3,000 5,000 2,000 Totals 316,969 351,666 339,730 629,620 363,778 364,300 266,086 362,100 362,600 (9,500) CLASSIFICATIONS: MUNICIPAL COURT REVENUE BARS Numbers Description 2012 Actuals 2013 Actual 2014 Actual 2015 Actual 2010 Actual 2017 Budget 2017 7months 2017 Estimate 2018 Budget $$ Change 001.000.000.386.12.00.00 Crime Victim Assessment 5,492 4,769 4,800 3,913 4,150 4,000 2,226 3,850 3,860 001,000.000.341.33.20.00 Passport Fees 1,100 925 - 001.000.000.342.33.00.00 Adult Probation Services 63,318 104.483 100,000 85,437 89,799 90,000 41,686 70,000 70,000 001.000.000,342.36.00.00 Housing of Prisoners 42,078 53,450 48,000 40,850 31,948 40,000 13,144 23,000 1 23,000 114,000.000.356.50.03.00 Drug Buy 447 366 200 64 152 260 101 200 200 001,000.000.357,33.00.00 Public Defender Fees 30,030 31,408 32,000 26,172 291222 29,000 18,636 29,500 29,500 001.000.000.356.50.00.00 Fines B Penalties 294,250 249,815 240,000 210,093 220,107 216,000 118,660 187,000 190,000 3,000 Total Local Revenue 436,715 445,215 425,000 366,529 375,378 378,250 194,342 313,660 316,660 3,000 001.000.000,386.91.00.00 State Revenue Share 298,116 253,797 250.000 224.563 245,135 240,000 116,500 200,000 200,000 Total Court Receipts 734,831 699,012 676,000 591,092 620,513 618,260 310,842 613,560 516.560 3,000 29 2017 BUDGET GENERAL FUND CITY CLERK DEPARTMENT The City Clerk's Office provides services to the City's operating departments as well as a number of external services to Citizens and Businesses in East Wenatchee and the surrounding community. Federal, State, and City laws and regulations guide the Departments operations. The City Clerk is responsible for services such as business licensing, maintaining City ordinances and resolutions, legal notices and publications, records management, and other miscellaneous clerical functions. The City Clerk assists the Mayor with setting Council Meeting Agendas and processing information for Council Packets, as well as providing administrative support for the City Councilmembers. W CITY OF EAST WENATCHEE CITY CLERK EXPENDITURES CITY CLERK 2018 BUDGET WORKSHEET - MARIA HOLMAN, CITY CLERK BARS Numbers Description 2011 Actuate 2012 2013 2014 2015 2016 2017 2017 2017 2018 Actual Actual Actual Actual Actual Budget 9 Months Estimate Budget Change 001.000.140.514.20.10.00 Salaries 77,114 80,662 84,261 87,158 92,566 95,878 75,300 41,035 58,300 71,000 12700 001.000.140.514.20.20.00 Benefits 33,816 38,334 40,708 39,036 37,832 38,716 34,800 18,059 32,000 40.000 8,000 001.000.140.514.20,31.00 Office Supplies 1,059 1,132 2,553 3,439 4,334 2,723 3,000 1,335 2,500 3,000 500 001.000.140.514.20.31.01 Central Stores 5,946 3,639 5,529 3,477 3,813 5,176 4,000 4,105 5,000 4,000 1,000) 001.000.140.514.20A1.00 Dues & Publications 001.000.140.514.20.43.00 Travel 141 503 93 473 55 1,245 am 323 800 1,200 400 001.000.140.514.20.44.00 Advertising 2,604 1,968 1,894 1,782 2,028 2,074 1,800 2,651 3,000 2,000 1,000) 001.000.140.514.20,46.00 Insurance 2,160 2,709 2,966 4,276 3,633 3,958 3,600 98 4,400 4,900 500 001.000.140.514.20.48.00 Repairs & Maint 645 680 715 - 100 350 500 500 001.000.140.514.20.49.00 Miscellaneous 571 736 647 731 1,044 563 750 258 750 750 001.000,140.514.20.50.00 Training 444 703 187 724 - 575 1,000 151 750 2,000 1,250 001,000,140.514.30,20.00 Records Services 70 350 119 243 714 238 200 78 200 200 001.000. 140.514.30.25.00 Codification 1.233 1,600 2,505 1,661 1,240 1,226 2,000 2,074 2,100 2,100 00 1. 000. 140.594,19.60.00 Capital Outlay 319 - Totals 128,122 133,016 142,177 143,000 147,259 152,372 127,350 70,417 110,300 131,650 21,350 Nick Note: Marla will plan classes and locations for training, Mayor approval and to me for per diem costing. CITY CLERK REVENUE CLASSIFICATIONS BARS Numbers Description 2011 Actuals 2012 2013 2014 2016 2016 2017 2017 2017 2018 $ Actual Actual Actual Actual Actual Budget 7 Months Estimate Budget Change 001.000.000.321.97.00.00 Business Licenses 53,293 53,058 55,449 55,260 64,234 78,115 80,500 78,260 85,000 80,000 (5,000) 001.000.000.321,80.00.00 Bus Lic Penalties 733 432 1,092 1,780 3,714 3,184 21500 74 200 1,000 800 001.000.000.321.30.01.00 Fireworks Permits 500 350 350 600 460 356 550 850 850 850 001.000,000.321.60.00.00 Taxicab Licenses 681 453 328 1,075 1,170 200 400 800 800 400 (400 001.000,000.321.70.00.00 Amusement LicensE 1,370 2,020 1,460 730 1,260 680 001.000.000.341.33. 10.00 Background Check 1 280 10 20 (32) 192 84 100 36 36 75 39 001.000,000.389,20,00.00 Fireworks DON Reff 300 250 350 400 250 200 250 250 250 200 (50) 001.000.000.389.30.00.00 Fireworks Cleaning 1,700 2,000 3,500 3,500 2,600 2,000 2,500 2,000 2,000 2,000 - Total Revenue 58,857 58,573 62,549 63,313 73,770 84,818 86,800 82,270 89,136 84,626 (4,611) 31 2018 BUDGET GENERAL FUND FINANCE DEPARTMENT Salaries Fifty percent of the Executive Secretary (to the Mayor)/Accounting Assistant salary is budgeted under the Finance Department, as well as the Treasurer/Finance Director and a part-time clerical support, shared with the City Attorney. Benefits The benefits line item is payroll taxes, medical, dental, and vision premiums; and retirement contributions. Budeetine, Accountine, and Auditine Represents costs for audits and annual reports required by the Washington State Auditor's Office. Capital Outlav The City purchased and implemented a new accounting software system during 2010. Costs included an annual purchase payment amortized over 5 years and vendor training/travel costs. For 2014, the amoral and final payment was paid in the Information Technology Department. Any further technology or hardware/software purchases will be made in the IT Department. Other Expense Line Items Other expenses are self-explanatory according to their titles and nature. 32 V r cna 1 ncrvw cn.. NCE EXPENDITURES FINANCE DEPARTMENT BUDGET WORKSHEET - Department Head - Finance Director, Nick Ganda, 001.000.142.51420.10.00 Salaries 001.000.142,514.20,20.00 Benefits 001,000.142.514.20.31.00 Office Supplies, 001.000,142.514.20.42.03 Postage 001.000,142.51420,43,00 Travel 001.000.142.514.20.46.00 Insurance 001,000.142.514.20A9A0 Miscellaneous 001.000, 142.514.23.20.00 Budgeting, Accounting, Auditing 001.000.142.51425.30,00 Bank Charges B Fees 001.000.142.514.40.20.00 Training 001,000,142,$94.14.60.00 Capital Outlay Actual Actual I Actual Actual Actual Actual Actual Budget 9Months Estimate I Budget lChange 106,872 110.814 115,860 121,247 137,639 141,182 143,073 210,400 140,173 190,000 177,000 1 (13,000) 38,380 39,642 42,926 46,640 $3.704 64,991 59,253 91,400 64,966 91.400 "'000 (14,400) 2,442 2,885 2,993 2,612 2,114 1,677 2,470 2,000 805 1.700 2,000 300 (9) 5 79 68 32 2 2 - - - - 152 43 607 371 107 318 193 300 2" 300 300 1,548 2.050 2,671 2,856 4,062 3,761 3,847 3,500 396 4,000 4,400 400 2.494 2.863 629 362 70 576 600 6 260 600 250 3,265 21,334 2,724 26,638 11,666 19,324 1,633 17,500 10,163 20,700 2.000 (18,700) 3,186 5,859 2,603 3.295 3,184 3,000 3,345 3,200 3,200 600 598 708 436 708 313 140 600 - 260 Soo 250 5.860 4.722 3,905 4,056 2,029 - 161,604 184,958 176,188 209,223 214,683 20,428 213,775 329,200 210,096 311,890 266,Sm (44.900) Note: Except for Auditing costs, no material changes in costs for 2016. The audit costs for 2015 result from the requirement for a federal single audit because of the City's receipt of more than $500,000 in 2014 (SEFA) an accountability audit of 2013, and an accountability/financial statement audit of 2014. The City does not expect to exceed the spending limit that would require a SEFA audit for 2015, consequently no specific audit requirements are expected in 2016. 2017 SAO audit work for 2015 and 2016. 33 2018 BUDGET GENERAL FUND INFORMATION TECHNOLOGY Contracted Network Services The City had previously provided information technology support through an independent contractor through 2010. During 2011, the City purchased support from a local information technology service vendor, performed a public bid process for selection under a contract, and negotiated a contract during 2012. That contract for service continues in effect. Website UDErade The City expects to complete its "website modernization' project by the end of 2013. 2014 included monies for transition, training and consultation with its vendor. 2015 includes an annual maintenance fee and a small allowance for consultation. 2016 thru 2018 includes the annual maintenance fee. Annual Maintenance/License Fees for Software During staff budget discussions in 2013, the costs for software maintenance and licenses that had previously been charged to the departments which had purchased or are the primary user of the software, were determined to be more appropriately paid by the Information Technology Department. Capital Expenditures Computers, supplies, licenses, software and hardware are considered capital. The City has two separate networks and telephone systems, one each for support of City Administrative Staff and one each for support of the Police Department, including linkage with the regional RiverCom emergency 9-1-1 system. 34 CITY OF EAST WENATCHEE IT DEPARTMENT EXPENDITURES INFORMATION TECHNOLOGY 2018 BUDGET WORKSHEET-Department Head - Ma or Lac BARS Numbers Description 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2016 Actual 20fe Actual 2017 Budget 2017 9 Months 2017 Estimate 2018 Budget $ Change 001.000.145,514.10.10.00 IT contractor - - - - 001.000.145.514.20.40.00 Network Services #N## - 55,335 53,493 49,030 47,569 52,625 48,405 47,500 31,032 41,400 72,000 30,600 (101.000.145.514.20.40.05 Distsler Backup System Support 3,622 8,100 8,976 8,000 8,000 - 001.000.145.514.20.40.10 Annual Maintil-icense Fees -Planning- GIS System$1,700 Total (35%to SWA) 1,082 2,618 2,150 1,082 2,000 2,150 150 001.000,145,514.20.40.15 Annual Maint/License Fees- City Clerk- Business License Mmmmnanc 740 765 785 740 - 001.000.145.514.20.40.20 Annual MainVFees- Police - Spillman, Net-Motion,Cmia match,Phone Forensic q 11,570 13,160 13,565 12,602 13,013 1 13,0131 18,500 5,487 001.000.145.514.20,40.25 Annual Malnt/License Fees -Muni Court-Techline Comm 647 862 862 862 862 1,000 138 001.000.145.514,20.40.30 Annual Malnt/License Fees- Finance- Vision Financial Software Maintenance 3,006 2,917 3,063 3.063 3,063 3,063 5,000 1.937 001,000.145.214,20.40.35 Annual License Fees- Evidence.com(body cameras) 3,628 3,249 3,249 3,249 3,249 3,300 51 001.000.145.514.20.40.40 Annual Subscription Fee - Vision Websile 6,365 6,565 6,556 6,556 7,000 444 001,000.145.514.20.48.00 Repels &Main 900 23 - 3,000 3,706 4,000 4,000 - 001.000.145.514.20.49.00 Miscellaneous 1,003 694 167 578 199 349 1,000 500 1,000 500 001.000.145.594.14.60.10 Websile Modernization Capital 16,080 11,554 7,697 350 500 - 001.000.145.594.14.60.12 Disaster Backup Device Capital - 001.000. 145.594.14.60.15 Computer Licenses -Admin Capital - 001.000.145.594.14.60.20 Computer Software -Admin Capital 1,867 7,343 7,218 3,023 1,302 23,300 14,885 17,500 10,000 (7,500) 001.000.145.594.14,60.25 Computer Hardware - Admin- Capital 6,300 12,990 4,374 13,433 36,627 30,000 4,966 10,000 20,000 10,000 001.000. 145.694.14.60.27 Computer Equipment - Police Dept Capital 1,306 11,000 19,581 20,263 26,310 25,000 9,247 20,000 20,000 - 001.000.145.594.14.60.30 Computer Licenses- Police Dept Capital 1,752 6,290 - - - - 001.000. 145.594.14.30.00 Computer Hardware - Police Dept- 0 Capital 2,451 5,000 - - 001.000.145.594.14.60.35 Computer Equipment-Admin Capital 6,594 17,432 6,704 1,319 600 2,000 5.226 5,226 6.950 1,724 001.000.145.594.14.60.40 Computer Software -Police Dept Capital 5,000 1,079 - - Totals 72,856 90,274 99,999 1 114,624 122,529 1 150,454 1 169.631 104,999 135,369 178,9)0 43,531 2016 Notes: Fees for Maintenance of Software of other systems that were previously paid by individual departments are now a budget and expenditure requirement for the IT Department (per Mayor Lacy at the August 6th staff meeting). Consequently, those fees have been budgeted above for 2015 and beyond. (self-explanatory titles) Website Modernization: Costs for 2015 include the annual contracted amount with an amount for the cost of possible changes. 2016 includes the annual maintenance fee. ### Key Methods provided recommendations to the City Attorney for certain captions, including $350 for Firewall License Renewal, $4,500 for workstations, $7,000 for upgrading the server, and $750 for cleaning up the server room. An additional $5,000 has been budgeted for surveillance cameras on the City campus. Computer Software -Admin includes $6,300 for the purchase and Implementation of cash management software, initially expected to increase internal controls surrounding the receipt, accounting and bank depositing processes. (2017) Disaster Back-up Device and Maintenance: Set-up Capital account for the Disaster Backup Device acquired In 2016. Replacement is expected every third year. The on -going maintenance and service is an annual amount and will begin In September of 2017 at an annua cost of $8,100. 2018 Computer Hardware - Admin includes $15,000 for admin computers and approx $3,500 for Municipal Court computers. 2018 Computer Software Admin Includes $5,000 for Office 365 Mlgrationl. 2018 Computer Equipment Admin includes purchase of a projector hardware/softwareflnstallallon 35 2018 BUDGET GENERAL FUND INTERNAL SERVICES Office Machine Costs Since rent payments are not capital according to the SAO, this account will be used in the future to record the rental payments of the copier and other associated costs. Telephone Line Charees Charges for telephone service to City Hall. Postaee Meter This line item is used to reimburse the postage meter for city-wide department usage. Repairs & Maintenance Repairs and maintenance of internal services equipment includes the postage meter. 36 CITY OF EAST W ENATCHEE INTERNAL SERVICES EXPENDITURES INTERNAL SERVICES 2018 BUDGET WORKSHEET - Department Head - Finance BARS 2010 2011 2012 2013 2014 2015 2015 2017 2017 2017 2018 $$ Numbers Description Actual Actual Actual Actual Actual Actual Actual Budget 9Months Estimate Budget Change 001.000. 141.51420.31.00 Office Supplies - 448 385 001.000.141.514.20.31.01 Office Machine Costs 94 10,295 12,490 11,000 8,481 11,000 11,500 _ 001.000.141.514.20.42.01 Telephone Line 10,627 12,363 12,516 12,865 11,139 11,180 12,315 12,500 9,929 13,500 13,500 Charges 001.000, 141.514.20.42.03 Postage Meter 10,890 10,192 10,027 11,000 0,427 5.166 6,516 8.500 8.042 10,500 10,500 001,000,141.514.20,48.00 Ragtag It Maintenance 1283 1,974 2,135 2,044 1,345 1,701 1,373 2,000 1,287 1,500 1,750 250 001. 000.141.514.20.49.00 Miscellaneous - 1 - 880 - 001.000.141. 594,14,60.00 Capital Outlay" 13,313 9,847 1 10,069 1 10,831 1 10,149 450 - - Totals 36,113 34,918 35.133 1 36,740 29,061 1 28,782 33,574 34,000 1 27,738 1 36,500 1 37,250 250 Please Note: Copier costs previously accounted for the the Capital Outlay category, will be accounted for in the future In the "Office Maching Costs" account. 37 2018 BUDGET GENERAL FUND LEGAL DEPARTMENT Salaries The City Attorney position reports to the Mayor and will receive an increase per his employment agreement, effective January 1, 2018. The City Attorney anticipates that the number of criminal cases in 2018 will be about 600. Based on this anticipated caseload, the hours the clerical assistant works should be 19 hours a week. Benefits The benefits line item is payroll benefits, insurance premiums, and retirement contributions for the City Attorney and his clerical support employee. Training This amount reflects the registration fee for the City Attorney's CLE five-day workshop. This amount also reflects the registration fee for the City Attorney to attend WSAMA's Spring or Fall Conference. Professional Services The City Attorney does not anticipate needing to contract out for professional services during 2018. Litigation Expenses This request covers expenses for out -of -county subpoenas and expenses for ordering records from the Secretary of State or the State Toxicologist. Office Supplies The major expense in this category is replacing the ink in the City Attorney's desktop printer. M. Travel The City is contractually obligated to pay for the City Attorney's Continuing -Legal -Education credits. The City Attorney intends to attend a five-day workshop to earn the required credits. The majority of the requested amount is based on the per diem rates for food and lodging. The amount also includes $100 for mileage reimbursement for the occasional trips the City Attorney has to make to Waterville to argue cases on appeal with the Douglas County Superior Court. This account also includes a $200 for an anticipated trip to the Court of Appeals in Spokane. Licensing The City is contractually obligated to pay the City Attorney's licensing fees with the Washington State Bar Association. 39 CITY OF EAST WENATCHEE LEGAL DEPARTMENT EXPENDITURES LEGAL DEPARTMENT 2018 BUDGET WORKSHEET - Department Head I City Attorney, Davin Poulson BARS Numbers Description 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2016 Actual 2016 Actual 2017 Budget 2017 9 Months 2017 Estimate 2018 Budget $$ Change 001,000,151.515.30.10.00 Salaries 116,231 118,694 124,991 117,851 123,112 127,160 131,600 99,126 131,600 134,000 2,400 001.000. 151.515.30.20.00 Benefits 45,155 48,830 51,746 48,267 45,572 51,597 56,600 43,807 56,600 62,000 5,500 001.000.151.515,30.20. 10 Training 494 30 94 85 253 100 65 100 100 001.000.151,515.30.25.00 Prof Services 2,345 100 001.000. 151.515.30.25.05 Litigation Expenses 500 500 500 001.000.151.515.30.25.10 Licensing 355 351 355 487 409 500 500 600 001.000.151.515.30.31.00 Office Supplies 285 358 216 110 50 60 100 241 300 300 001.000.151.515.30.43.00 Travel 364 265 324 595 600 631 600 600 001.000. 151.515.30.46.00 Insurance 3,290 4,115 4,472 6,734 2,167 5,979 6,400 49 7,300 8,000 700 001.000,151.515.30.42.03 Postage 001, 000. 151.515.30.48. 00 Repairs B Maintenance 50 - 001.000.151.515.30.49.00 Miscellaneous 323 75 104 77 254 520 200 100 100 001.000. 151.594.14.60.35 Capital Outlay 409 940 135 200 Totals 165,778 172,917 182,418 173,744 172,906 189,063 196,800 1 143,919 197,500 206,100 8,600 40 2018 BUDGET GENERAL FUND CITY ENGINEER DEPARTMENT Note: The City Engineer position is a Department Head position reporting to the Mayor, with responsibilities including supervision of the Street Department, Storm Water Utility, Central Services (maintenance of City Hall), Street Improvement and Capital Projects. The City Engineer is a member of the City's Storm Water Utility Management Team and participates in the Chelan/Douglas Transportation Council. City Engineer Expense Line items Most of the Department costs are self-explanatory according to their title and nature. The level and change in these expenditures reflect specific analysis by the department head. The federal Highway Performance Monitoring System (IIPMS) annually reviews the national transportation system and requires traffic information to be updated annually. For the most part, the city has been applying a growth factor to the traffic Average Daily Traffic counts for 20 years at some locations. The engineer would like to update the traffic counts at the required HPMS locations to more accurately reflect the true ADT for this important federal program. The counts ideally will be performed by the Chelan -Douglas Transportation Council staff. If they are not able to perform this function, then $20,000 is budgeted to accomplish the task. 41 CITY OF EAST WENATCHEE CITY ENGINEER EXPENDITURES CITY ENGINEER 2018 BUDGET WORKSHEET - Department Head - City Engineer, Greg Pezoldt BARS Numbers Description 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 9 Months 2017 Estimate 1 2018 Budget $$ Change 001.000.315.532. 10A 0.00 Salary 73,080 75,272 69,825 86,020 89,846 92,092 94,900 71,141 94,900 90,000 (4,900) 001.000.315.532.10.20.D0 Benefits 24,659 21,733 18,489 22,600 25,948 27,697 28,900 21,807 28,900 29,000 100 001.000.315.532.10.41.00 Professional Services 358 3,446 1,880 176 - 001.000.315.532.10.46.00 Insurance 2,680 3,619 3,996 5,875 5,267 5,379 5,700 49 6,400 7,000 600 001.000.315.532.10.43.00 Travel 1,508 1,365 1,252 001.000,315.532.10.49.00 Training 255 001,000.315.532.10.49.01 Miscellaneous 106 001.000.315.532,10.49.05 Registrations 1,035 1,000 425 - 001.000.315.532.10.49. 10 Memberships 155 174 512 164 - 001.000.315.532.20.41.10 Traffic Studies 20,000 001.000.315.594.42.60.00 Capital Outlay `" 2,102 409 293 - 300 300 100 (200) Totals 106,138 F106,09T 96,788 115,148 1 121,061 125,168 149,800 92,997 130,500 126,100 (4,400) 42 2018 BUDGET GENERAL FUND CIVIL SERVICE Salaries This line item is the salary for the Civil Service Secretary who is scheduled when a Civil Service position is open and being recruited, generally in the Police Department. Benefits Payroll benefits (social security, medicare, and unemployment) for the Civil Service Secretary. Insurance This line item is for Civil Service liability and property insurance, including claims deductibles. Miscellaneous This line item is for testing expenses and unanticipated civil service expenses. 43 IL SERVICE EXPENDITURES CIVIL SERVICE 8 BUDGET WORKSHEET - Department Head - Finance GAKJ 001.000A60.521.10.10.00 001.000.160.521.10.20.00 001.000.160.521.10.46.00 001.000A 60.521,10.49.00 Description 2010 Actual 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 9Months 2017 Estimate 2018 Budget Salaries 79 1,119 804 710 965 875 1,000 858 1,000 1,000 Benefits 13 - - Insurance 1,341 1,450 1,640 1,850 2,705 2,467 2,479 2,700 49 2,900 3,200 Miscellaneous - 990 280 100 100 100 Totals 1,433 1,450 3,749 1 2,654 3,694 3,432 1 3,354 3,800 907 1 4,000 4,300 001.000.000.341.96.10.00 Civil Service Ap - 3,020 Note: Allow for the possibility for a recruitment under civil service conditions. When active, the Civil Service Chairperson is paid $66.00 per month and $16.50 per hour. 44 2018 BUDGET GENERAL FUND CENTRAL SERVICES Note: Central Services represents the costs of maintaining the City Hall Building and surrounding property. Line item expenses are generally self explanatory according to their titles and nature. The level and changes in these expenditures reflect specific analysis by the department head — in this case, the Public Works Street Manager. Capital Outlav $60,000 has been budgeted to paint the interior of City Hall. 45 CITY OF EAST WENATCHEE CENTRAL SERVICES EXPENDITURES CENTRAL SERVICES 2018 BUDGET WORKSHEET - Department Head - Public Works BARS 1010 2011 2012 1 2013 2014 2015 2016 2017 2017 2017 2018 $ Numbers Description Actual Actual Actual Actual Actual Actual Actual Budget 9Months Estimate Budget Change 001.000. 180.518,30,31.00 Once Supplies 13 198 188 118 272 150 209 001.000. 18D.518.30.31.02 Central Stores 59 27 - 001.000. 180.518.30.31.06 Cleaning Supplies 1,684 1,117 1.526 1,615 1,831 1,327 1,700 1,600 1,659 1,700 11800 10D 001000.180.51330.35,00 Furnishings8 _ - 18,528 2,265 5,000 5,000 Equipment 001.000. 180.518,30,41CD Professional 10,828 11,926 13,448 12,926 13,346 12,733 9,762 12,000 12,472 16,000 15,000 Services 001.000.180.510.30.41 01 Contracted 16,666 20,555 21,339 21,040 20,093 18,76D 21,378 20,000 14,402 20,000 20,000 Services Custodial 001 000.180 51830.46DO Insurance 14,200 15,650 17,663 19,785 29,238 24,000 26,800 27,900 32,200 35,500 3,300 001.000. 180.518.30.47.00 Utilities 13,980 14,504 16,917 22,874 19,678 19,882 19,628 20,000 16,688 22,500 22,500 _ 001.000. 180.518,30.48,00 Repairs8 8,997 5,577 2,007 5,811 10,478 5,648 12,668 12,000 8,453 12,000 12,000 Maintenance 001.00DA80.518.0.49.00 Miscellaneous 2,663 2,104 4,283 2,500 2.492 1,766 1,049 2.000 552 2,000 2,000 001.000.180,518,3049.01 Landscaping 130 - - 10,421 7.000 2.518 5,000 14,000 9.000 001.000. 180.518.64.41.00 Judgements 8 37,579 5,000 Settlements 001.000. 180.518.92.20.00 Ancillary 4,568 9,046 7,509 12,708 8,634 6,766 4.611 5,000 3,808 3,500 5,000 1,500 001.000. 180.594.18.60.00 Capital Outlay 18,466 2,994 39,539 18,172 22,293 110,847 15,830 80.000 109 160.000 70,000 (90,001D) 001.000.180.594,18.60, 10 Capital Outlay -Side - _ 343 66,361 - Totals 91,154 83,698 124,419 117,609 128,697 268,220 180,163 192.500 62,92fi 2]8,900 202,800 (76,100) Move Maintenance Administration Facilities (City Shop) budget to Central Services, leave $1,500 for small tools and equip. $18,800(salary 8 benefit. repair 8maint, Utilities, supply) Professional Services - Divco Contract = $11, 000 annual fee + $2,000 (minor repairs) + Appleand Pest Control = $250 x 4 times per year Contracted Custodial Services - ABM Janitorial Contract - $21,540 annual fee +tax + bio-hazard/specialty cleaning + floor stripping. etc - $25,000 Repairs 8 Maineen since - Irrigation, doors, locks, tree spraying, plumbing, etc. Adjustment to 2014.., add $40,000 capital cost for City Hall Flooring, 2016 Capital Outlay - $20,000 electrical upgrades to carport, salts had and chemical storage building -not planned - unlikely for 2013 - Moved to 2014 and now to 2015 Other Capital items include $45,000 to paint City Hail and $35,000 for upgades to the audio and recording capability in Council Chambers. The City Hall Parking Lot and Sidewalk Project required for compliance with Federal ADA standards estimated to cost $67,000 is budgeted separately as noted above. Est Capital for 2015 includes: $30,000 for the City Hall Sound System, of which $27,700 has been paid so far. $12,500 for the accomodation improvements in reception areas of City Hall, which was not budgeted in 2015. $25,000 to paint city hall, which was budgeted at $45,000, and has been bid. $39,200 estimate for the floor installation in City Hall being contested, not budgeted for 2015 (City received $22,784.97 from Cities Ins. For flooring) $5,000 for carpet in the Library Area of City Hall, also not budgeted for 2015. 2016 Capital includes completion of the finish work in City Hall associated with the new flooring $10,000, $2,600 for Wellness Equipment, and $2,600 misc. 2017 City Hall & Campus Site Security System - $65,000 Paint Rotunda and Hallways - $5,000 Other $10,000 2017 Est - Sec system $65,000, Painting $60,000, Telephone System $22,000 2018 - Paint Interior City Hail $60,000 and Additional Security $10,000 2018 - Landscaping Projects - Historic Perimeter Wall $9,000 plus $5,000 Trees and Vegetation 46 2018 BUDGET GENERAL FUND LAW ENFORCEMENT Police Department Operations The Law Enforcement Department reflects the costs of running the City's Police Department. The Police Department is the largest City department with a total of 24 employees, including the Chief, Assistant Chief, 3 Sergeants, 2 Detectives, 14 Patrol Officers and 3 Records Personnel. This is the only Department in the City that operates 24 hours a day, 7 days a week. The Chief and Assistant Chief are management employees and the remainder of the department is covered by collective bargaining agreements affiliated with the Teamsters Union. In addition to the normal operating expenses of most departments in the City, the Police Department incurs costs for clothing allowance and for dry cleaning expenses because all officers are required to wear uniforms. The fleet of police vehicles requires significant fuel costs. Purchase and maintenance of the fleet is funded in the Equipment Purchase, Maintenance and Replacement Fund #501. Training costs are a requirement for maintaining proficiencies that require certification, as well as obtaining new skills for the continual advancement of technologies in patrolling strategies and investigation analysis. The needs for incurring overtime costs in the Police Department are a result of minimum staffing requirements for all three shifts, satisfying emergency situations and for special patrol programs. Special patrol programs such as seatbelt emphasis (click it or ticket and juvenile safety seat requirements) and DUI patrols may be partially funded thru the Washington State Traffic Safety Commission. Jail Services - Detention Housing of prisoners is provided by the Chelan County Regional Justice Center ("CCRJC") and the Okanagan County Jail ("OCJ") under inter -local agreements. CCRJC per -day charges are currently $87.00, increasing to $96.00 per day in 2018. OCJ charges are currently $58.50 per day. Utilization is expected to be similar in 2018 in comparison to 2017, except that the Municipal Court has re-established the community service process which could reduce per day stays at the CCRJC. 47 CITY OF EAST WENATCHEE LAW ENFORCEMENT EXPENDITURES LAW ENFORCEMENT 2018 BUDGET WORKSHEET - Department Head - Police Chief, Randy Harrison PAGE 1 OF 2 Numbers Description Actual Actual Actual Actual Actual Budget 9 Months Estimate Budget an e 001,000,210.521.10.10.00 Salaries 1,771,431 1,710,418 1,794,205 1,863,104 1,854,230 1.935,000 1,360,419 1,875,000 2,074,000 199000 001.000,210.521.10.10.01 COPS Salaries 67,027 - - 001.000.210.521.10.10.02 Overtime Salaries 74,759 69,190 77,992 75,765 110,915 100,000 83,675 105,000 100,000 5,000 001.000.210.521.10.10.03 Overtime Sal -Traffic Control 4,632 3,670 6,453 6,412 11,392 10,000 6,175 6.000 5,000 2,000 001.000.210.521.10.20.00 Benefits 652,121 695,845 707,283 708,600 723,154 770,000 549,898 740,000 795,000 55,000 001.000.210,521.10.20.01 Clothing Allowance 14,891 13,009 14,119 14,276 11,571 74,/00 8,140 13,000 14,400 1,400 001.000.210.521.10.20.02 COPS Benefits 28,669 - 001.000.210.521.10.31.00 Office Supplies 4,537 6,651 5,196 5,323 8,028 6,000 2,991 6,000 6,000 1.000 001.000.210.521.10.31.05 Office Machines 3,483 2,404 4,000 2,719 2,000 4,000 2,000 001.000.210.521.10.32.00 Fuel Consumed 66,852 58,081 58,944 53,531 40,856 40,000 27,454 37.000 40,000 3,000 001.000.210,521,10.35.00 Small Tools& E ui menl 6,953 4,731 7,406 7,562 6,651 8,000 5,989 8,000 13,000 5,000 001.000.210.521.10.35.02 Gn SPC Traffic Safety 1,065 1,828 1,828 3,000 3,000 3,000 001.000.210.521.10.35.05 Bulletproof Vest Grant 1,978 - 3,305 4,000 271 4,000 4,000 _ 001.000.210.521.10.35.06 USM Fugitive Task Force 1,500 1,500 1,500 001,000,210.521.10.41.00 Professional Services 8,700 3.192 8,362 8,181 5,773 8,500 6,692 8,500 14,000 5,500 001.000,210.521,10.42.00 Dispatch 1,785 - 001.000.210.521.10.42.01 Telephone 18,293 17,256 17,667 18,646 19,701 32,200 20,040 32,200 33,000 800 001.D00.210.521.10.42.03 Postage 365 419 509 1,093 1,346 750 659 75D 850 100 001.000.210.521.10.43.00 Travel 4,192 6,442 10,855 10,245 13,393 15,000 2,159 6,000 15,000 8000 001.000.210.521.10.44.00 Advertising 2,500 001.000,210.521.10.46.00 Insurance 40,704 40,737 60,367 51,444 56,459 63,700 7,450 62,000 68,200 6,200 001.000.210.521,10,48.00 Repairs & Maintenance 45,101 45,969 53,776 9,139 7,187 7,000 6,815 7,500 8,000 500 001.000.210.521.10.49.00 Miscellaneous 3,681 3,264 3,736 3,708 4,547 4,500 2,879 4,000 4,500 500 001.000.210.521.10.49.01 Reserves 820 18 1,200 130 1,680 1,500 269 250 1,500 1,250 001.000.210.521.10.49.02 Drycleaning 2,258 1,361 1,478 1,690 1,237 1,500 284 500 1,500 1,000 001.000.210.521.30.00.00 Crime Prevention 198 3 216 432 510 750 143 300 1 750 1 450 001.000.210.521.40.20.00 Training 192 575 310 - 001,000,210.521.40.22.00 Chiefng 328 21 833 920 1,000 1,000 1,000 001.000.210.521.40.25.00 Training- Officers 2,765 1,745 2,062 2,091 3,537 3,000 2,063 3,000 4,000 1,000 001.000.210.521.40.27.00 Training- Office Staff 35 400 120 Soo 150 300 800 500 001.000,210.521.40.30.00 Recruits- Training-Remits - 3,187 3,187 9,600 6,413 001.000.210.521.50.10.00 Ancillary 6,342 8,037 6,a11 910 407 2,000 1,040 2,000 2,000 001.000.210.521.50.49.00 Other Services 1,500 780 1,500 445 1,000 1,500 500 001.000.210,594,21.60.00 Capital Outlay "' 79.528 20,327 73,960 13,586 11,078 8,000 6,717 8,000 12,000 4JXX Totals 2,907,547 2,707,543 2,917,811 2,851,349 2,903,491 3,037,300 2,108,643 2,937,487 3,243,600 303,613 Jail Services - Finance BARS Numbers Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 9 Months 2017 Estimate 2018 Budget $$ Change 001.000.230.523.21.10.00 Detention 262,965 270,052 294,399 258,511 299,381 266,000 197,178 265,000 300,000 35.000 001.000,230,523,60.20.00 Medical Care for Prisoners 19,594 8,680 525 11,098 7,113 12,000 3,676 12,000 12,000 001.000.230.523.60,30.00 Juvenile Detention 5,520 8,160 4,080 5,760 5.000 3,960 5,000 5,000 Totals 288,079 286,892 299,004 275,369 306,494 282,000 204,814 282,000 317,000 35,000 48 2018 BUDGET GENERAL FUND PLANNING DEPARTMENT Salaries This line item includes salaries for the Community Development Director and 25% of the Permit Technician, who also supports the Code Compliance Department and the Street Department. The 2018 Budget includes filling the Associate Planner position. This position has been vacant since November of 2010. Benefits The benefits line item is payroll benefits; medical, dental, and vision premiums; and retirement contributions for the Community Development Director, Associate Planner and 25% of the Permit Technician. Professional Services The requested amount for this line item anticipates expenses necessary to complete some of the long range planning projects in 2018. Hearine Examiner The requested amount for this line item anticipates expenses necessary for hearing examiner services for processing certain quasi-judicial applications. This amount is an estimate based upon the average number of permits processed over the past 7 years. The City contracts for the hearing examiner position. The cost per hearing is $450. The services are on an as -needed basis. No permits requiring Hearing Examiner action were processed in 2017. Other Expense Line Items Other expenses are self-explanatory according to titles and nature. The level and changes in these expenditures reflect specific analysis by the department head. Cif CITY OF EAST WENATCHEE PLANNING PLANNING DEPARTMENT EXPENDITURES 2018 BUDGET WORKSHEET- Department Head / Community Development Director, Lori Barnett Expenditures BARS Numbers Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 9 Months 2017 Estimate 2018 Budget $$ Change 001.000.580.558.10.10.00 Salaries 85,884 88,521 91,785 95,814 98,616 125,000 76,375 125,000 157,100 32,100 001.000.580.558.10.20.00 Benefits 26,918 28,304 29,830 31,592 33,514 44,500 25,277 44,500 51,200 6,700 001.000.580.558.10.31.00 Office Supplies 774 1,730 393 1,105 657 800 229 650 650 - 001.000.580.558.10.32.00 Fuel Consumed 105 223 46 24 98 100 154 100 125 25 001.000,580.558.10.35.00 Small Tools & Equipment 13 159 - - 46 100 - - 100 100 001.000.580.558.40,00.00 Training 399 525 37 1,261 1,500 80 1,500 1,500 - 001.000.580.558.10.41.00 Professional Services 1298 77,585 4,833 - 4,745 15,000 214 500 12,000 11,500 001.000.580.558.10.41.01 Hearings Examiner 900 - 450 - 450 450 450 001.000.580.558.10.41.02 Eng/Architect Svc - - 1,164 363 1,000 435 1,200 1,200 - 001.000.580.558.10.43.00 Travel 12 359 50 1.416 1,500 363 1,500 1,500 - 001.000.580.558.10.44.00 Advertising 1,778 1,251 1.099 1,404 1,887 1,500 2,169 1,750 1,800 50 001.000.580,558.10.46.00 Insurance 3,890 4,296 6,290 5,433 5,665 6,000 98 6,700 7,400 700 001.000.580.558.10.48.00 Repairs & Maintenance 443 419 131 200 100 100 - 001.000.580,558.10.49.00 Miscellaneous 697 1,044 807 693 852 1,000 984 2,000 1,400 (600) Totals 123,111 204,416 135,751 139,906 146,443 198,650 106,378 185,500 236,525 51,0725 BARS Numbers Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 9 Months 2017 Estimate 2018 Budget $$ Change 001.000.000.345.80.00.00 Planning & Dev Fees 3,453 2,323 2.233 5,927 2,795 3,000 6,314 6,500 3,500 (3,0()0) 001.000.000.345.89.00.00 SEPA Fees 904 1,332 569 1,129 618 500 903 900 600 (300) 001.000,000.331.16.75.00 Commerce Grant 90.000 - 001.000.000.331.16.78.00 DC Regional Council 5,000 -- - - - Totals 4,357 1 93,655 7,802 1 7,056 1 3,413 1 3,500 7,217 1 7,400 1 4,100 1 (3,300) All 2018 BUDGET GENERAL FUND CODE COMPLIANCE DEPARTMENT Expenditures: Salaries This line item includes the salaries for the Code Compliance Officer/Building Official and 50% of the Permit Technician. Benefits The benefits line item is payroll benefits; medical, dental, and vision premiums; and retirement contributions for the Code Compliance Officer/Building Official and 50% of the Permit Technician. Fire Marshal Services The City is required to enforce the International Fire Code. Douglas County Fire District No. 2 serves as the City's Fire Marshal. In 2005, the Fire District requested payment for Fire Marshal services and for fire protection of City buildings. The City and Fire District entered into a Interlocal Agreement in 2014 to increase the annual fee for services and to provide an inflation factor that would automatically increase the annual fee based upon the increase or decrease in the Consumer Price Index (CPI) for West Urban Region. Calculation of the annual adjustment will be adjusted based upon the CPI from September to September of the preceding twelve months. Other Expense Line Items Other expenses are self-explanatory according to titles and nature. The level and changes in these expenditures reflect specific analysis by the department head. Revenue: Revenue for this department is collected on the issuance of building and other structural permits (signs, plumbing, mechanical etc.). Building permits and sign permits also include a plan review fee. Building permit activity has been significantly reduced over the past few years. There was a spike in revenue in 2015 and 2016 as a result of the construction of two restaurants and a 107 unit apartment complex. Another spike occurred in 2017 with the construction of a 5-story hotel. It is anticipated that activity will decrease again in 2018. Non -Revenue State Building Code Surcharges are charged on all building permits and sign permits at a rate of $4.50 per permit. Those funds are remitted to the State of Washington. 51 CITY OF EAST WENATCHEE CODE COMPLIANCE CODE COMPLIANCE DEPARTMENT EXPENDITURES 2018 BUDGET WORKSHEET - Department Head / Community Development Director, Lori Barnett Expenditures BARS Numbers Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 9 Months 2017 Estimate 2018 Budget $ Change 001.000.590.559.10.10.00 Salaries 80,162 84,639 86,468 89,781 93,270 96,200 71,840 96,200 100,900 4,700 001.000.590.559.10.20.00 Benefits 42,519 44,723 44,503 44,138 46,133 49,500 33,884 46,000 46,700 700 001.000.590,559.10.31.00 Office Supplies 79 1,403 49 193 1,755 500 399 400 400 - 001.000.590.559.10.32.00 Fuel Consumed 609 532 487 313 284 300 205 300 300 - 001.000.590.559.50.40.00 Training 135 135 396 213 500 500 500 - 001.000.590.559.10.35.00 Small Tools 8 Equipment 19 001.000.590.559.10.41.01 Fire Marshal Services 16,300 20,375 17,650 19,361 19,438 19,633 9,884 19,769 20,064 295 001.000.590,559.10,43.00 Travel 102 90 - - - - 001.000.590.559.10.44.00 Advertising - 125 - - - - - 001.000.590.559.10.46.00 Insurance 2,575 2,804 4,114 3,467 3,779 4,000 49 4,400 4,900 500 001.000.590.559.10.48.00 Repairs & Maintenance 345 578 79 - 100 69 100 100 - 001.000.590.559.10.49.00 Miscellaneous 269 207 394 317 380 350 130 300 300 - Totals 143,095 155,505 154,265 157,783 165,039 171,083 116,460 167,969 174,164 6,195 Revenue BARS Numbers Description 2012 Actual 2013 Actual 2014 Actual 2016 Actual 2016 Actual 2017 Budget 2017 9 Months 2017 Actual 2018 Budget $$ Change 001.000.000.322.10.00.00 Building & Structure Permits 115,828 68,774 31,666 86,824 59,271 50,000 69,697 78,300 55,000 (23,300) 001.000.000.345.83.00.00 1 Plan Checking Fees 65,875 1 37,428 17,251 26,250 24,615 20,000 40,906 47,851 27,000 (20,851) 001.000.000.342.40.00.01 Fire Marshal Ser 523 554 3318 7587 4360 3,500 1 8,395 1 3,500 3,800 300 Totals 1 182,226 1 106,756 1 50,235 1 120,661 1 88,246 1 73,500 1 118,998 1 129,651 85,800 43,851) .000,000.380.00.50.01 1 Surcharge 300 1 191 1 3001 300 2018 BUDGET STREET & STORM WATER MAINTENANCE FUND REVENUE Please Note: As described on page 58, "Storm Water" operational and maintenance activities are now combined with street maintenance in this fund. Property Tax The Street Fund is allocated a portion of property tax receipts. For 2018, $500,000 has been budgeted. Sales &Use Tax The Street Fund is also allocated a portion of sales tax receipts. For 2018, $320,000 has been budgeted. Licenses & Permits Street and curb permits are expected to be $3,000 in 2018. Intergovernmental Revenue Street Fuel Excise Tax (SFET) is paid to the State by retailers from the sale in the City of gasoline and diesel at the current rate of 37.5 cents per gallon, and subsequently remitted to the City. SFET is limited in use by the City for street maintenance. $282,000 has been budgeted for 2018, a slight $1,400 increase from the 2017 estimate. Beginning in the 3`d Quarter of 2015, the City began receiving an additional tax from State receipts of highway funds as a result of legislative action earlier this year 2015. Based upon quarterly receipts since implementation of "MVA Transport Cities", 2018 estimate for this tax is $7,900. SWA Charges for Services These accounts include the reimbursements from the Greater East Wenatchee Storm Water Utility (GEWSWU), jointly operated by the City and Douglas. Reimbursements are determined based upon the actual costs incurred by the City to defray the costs of storm water operational and maintenance activities in the portion of the GEWSWU that is located within City boundaries. In addition, the City is the recipient of grant monies, primarily from the State Department of Ecology, that are also based upon the costs which the City incurs under terms of those grants. Maintenance Street Department expenses are budgeted according to the nature of the activity, supported by time sheets from employees for labor costs, and by vendor invoices for supplies and materials. Maintenance expenditures are expected to mostly continue at current levels, except that since 2011, a portion is now charged to the Storm Water Utility portion of the General Fund as an NPDES (National Pollutant Discharge Elimination System) expense. These expenditures include street cleaning which are now considered a "good housekeeping" practice under NPDES regulations. 53 For 2018, the department is requesting an additional staff person. This person will fill a vacancy in the department that was created by previous personnel movement. Administration Costs in these categories include all other costs of the Street Department, including the Land and Water Resource Program Manager and 25% of the cost of the Permit Technician for administrative support. Employee benefit costs for the Street Department were previously charged to administration, and beginning in April 2010 with the change in accounting software, are allocated to the appropriate maintenance categories above to better reflect the true costs of these activities. 54 CITY OF EAST WENATCHEE STREET FUND 101 REVENUES STREETISTORM WATER MAINTENANCE FUND 2018 BUDGET WORKSHEET BARS Numbers Description 2013 Actual 2014 Actual 2015 Actual 2018 Actual 1 2017 Budget 2017 9 Months 2017 Estimate 2018 Budget $$ Change 101,000.000.308.00.00.00 Beginning NC&I 184,862 378,201 113,631 89,638 162,200 121,370 121,370 189,374 Totals 184,862 378,201 113,631 89,638 162,200 121,370 121,370 189,374 68,004 Taxes 101.000.000.311.10.00.00 Property Tax 260,000 300,000 360,000g29O,OOO 460,000 500,000 600,000 _ 101.000.000.311.10.00.01 Contingency rope rty Tax 101.000.000,313.10.00.00 Sales & Use Tax 250,000 260,000 294,000 J29O,000 310,000 310,000 320,000 10,000 Totals 610,000 560,000 644,000 770,000 810,000 820,000 10,000 Licenses & Permits 101.000.000.322.40.00.00 Street & Curb Permits 3,060 2,460 3,065 6,360 5,000 3,365 2,300 3,000 700 Totals 3,060 2,460 1 3,065 6,360 1 5,000 3,366 2,300 3,000 700 Intergovernmental Revenue 101.000,000,336.00,71.00 Multimodal Transpo City 13,701 16,000 9,368 9,036 4,600 (4,536) 101.000.000.336.00.87.00 Street Fuel Excise Tax 274,636 276,377 277,671 281,066 281,000 206,340 280,600 282,000 1,400 101,000.000.336,00.87.05 MVA Transport Cities 4,061 7,999 8,000 8,189 7,904 7.900 (4) Totals 274,636 276,377 281,732 302,766 305,00t 223,887 297,640 294,400 (3,140) arges for 101.000.000.336.00.87.10 DOE 2016 Capacity Grant 8,420 41,600 16,580 16,600 60,000 33.400 101.000.000.343.13.00.00 Administrative Services 24,141 18,812 28,296 18,403 21,600 17,909 18,000 28,300 10,300 101.000.000.343.13.00.90 Greater EW SWU NPDE 161,717 145,078 186,724 158,028 200,000 114,923 160,000 210,200 50,200 101,000.000.369.90.50.00 Miscellaneous Revenue 10 10,020 10,000 5,000 (5,000) Totals 186,858 163,890 216,019 184,861 263,000 159,432 204,600 293,600 88,900 101,000.000.343.13.00.83 DOE CEW NPDES CapG 70,323 - - - - 101.000.000.343.13.00.87 NPDES Maint Capital Outlay (Sweeper 245,807 - - 101.000.000.343.13.00.94 EW Share Comp Plan 5,184 2,835 - - - Totals 75,507 248,642 - - Grand Total Current Revenue 1,048,961 1,240,369 1,143,806 1,258,987 1,363,000 1,166,684 1,314,440 1,410,900 96,460 Total Available Resources 1,233,823 1,618,570 1,257,437 1,348,626 1,626,200 1,278,054 1,435,810 1,600,274 164,464 55 CITY OF EAST WENATCHEE STREET FUND 101 EXPENDITURES STREET/STORM WATER MAINTENANCE FUND 2018 WORKSHEET BARS Numbers Description 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget I 2017 9111onths I 2017 Estimate 2018 Budget 68 I Change Total Available Resources 1.233.823 1.618.670 1.257.437 1.348.626 1.626.200 1.278.064 1.436.810 1.600.274 744.464 SWU Administration 101.000.311.542.42.10.00 Salaries 12,921 4.401 11,308 8,575 7,000 4,934 7,000 8,600 1,600 101.000.311.542.42.20.00 Benefits 6,678 2,623 4,480 4,293 3,800 2,779 3,800 4,200 400 101.000,311.542.42.31.00 SWU Annual Billing Fee 14,872 5,933 6,120 6,334 7,000 6,486 6,486 7,000 614 101,000.311.519.71.55.00 Comp Plan Costs 26,868 Administration 60,340 12,957 21,908 19,202 17,800 14,199 17,286 19,700 2,414 SWU NPDES Expenditures 101,000.313.542.42.10.00 Salaries -SWU Mainteru 63.942 41,106 67,281 56,005 70,000 47,613 60,000 66,000 5,000 101.000.313.542.42,10.10 Salaries -Swee in 14,650 12,894 9,631 16,000 8,614 11,000 16,000 4,000 101.000.313.542A2.20.00 Benefits -SWU Mainten 39,196 22,668 32,719 28,161 37,700 24,847 31,800 36,000 3,200 101.000.313.5%71.20.10 Benefits- Sweeping/ 8,701 6,963 6,647 8,100 4,676 6,700 7,400 1,700 101.000.313.542,42.30.00 Supplies 38,787 17,178 30,772 37,919 30,000 21,223 30,000 42,000 12,000 101.000.313.542.42.31.10 SWA ESRI GIS License as 1,483 920 920 1,000 80 101.000.313.542.42.31.31.15 GIB Anal calSvcs 7.004 101,000.313.542.42.35.00 Small Tools & Equipment 498 272 200 91 101,000.313.542.42.40.00 Training 361 33 1,000 697 1,000 1,000 Travel 1,038 1,600 101.000.313.542.42.47.00 Professional Svcs 298 691 Not Used Advertising 176 101.000.313.542.42.47.00 Utilities 345 746 1,000 486 900 1,000 100 101.000,313.542.42.48.00 Repairs and Maintenance 2,283 7,387 10,000 2,022 7,000 10,000 3,000 101.000.313,542.42.49.00 Miscellaneous 2976 1,538 401 2,165 2,600 866 2,000 3,500 1,600 101.000.313.542.42,51.01 DEOE Ms4 Annual Perm 3,332 3,591 1,888 6,089 4,300 2,102 2,100 5,000 2,900 101.000.313.542.420.53.01 Equipment Rental 13,968 3,962 3,217 4,295 10,000 813 1,500 15,000 13,600 101.000.313,542.42,53, 11 InterGpvt Services (Gross Match Grant Fund) Total NPDES Expanditt 162,860 116,964 157,963 168,206 189,800 122,711 153,920 202,400 46,980 101.000.315.542.41,47.00 Annual Utility Charge 146,790 146,746 146,700 146,700 146,700 146,700 146,700 164,347 17,647 101.000.315.594.31.60.00 Equipment 7,390 6,967 2,322 51000 5,000 5,000 101.000.315.594,33.55.00 Equipment - Sweeer 239,414 101.000,315.595.33.65.00 SWU Property 19th St Pond 166,600 - - - - Grand Total SWA Expenditures 377,380 678,647 328,893 324,108 359,300 283,610 317,906 391,447 72,041 Roadway Maintenance 101.000.420.542.30.10.00 salaries 23,741 24,084 14,633 18,779 25,000 18,699 25,000 36,000 10,000 101.000.420.542,30,20.00 benefits 13,877 11,845 6,895 7,090 13,500 8,430 13,500 19,000 5,500 101.000.420.542.30.30.00 supplies 14,663 13,481 11,103 12,314 15,000 11,169 16,000 26,000 10,000 001.000.420.542.30.48.00 Repair & Maint 12,417 221 50,444 6,000 541 6,000 7,500 2,600 101.000.420.542.30.49.00 Miscellaneous 83 - - Total Roadway Maintenance 64,781 49,410 32,852 88,627 58,500 38,729 58,500 86,500 28,000 56 CITY OF EAST WENATCHEE STREET FUND 101 EXPENDITURES STREET/STORM WATER MAINTENANCE FUND 2018 WORKSHEET BARS 2013 2014 2015 2018 2017 2017 2017 2018 $$ Numbers Description Actual Actual Actual I Actual I Budget 1 9Months Estimate I Budget I Change 101.000.420. 542.61,10.00 salaries 416 1,386 1,813 397 1,600 736 1,000 2,600 1,600 101.000.420,542.61,20.00 benefits 216 392 947 202 900 454 630 1,300 770 101.000.420. 542.61.30.00 supplies 352 661 615 7 1,000 - 500 2,000 11500 101.000.420,542.61.48.00 Repairs & Maint 105 1,000 6,293 750 2,500 1,750 Total Sidewalks 984 2,429 3,380 606 4,500 7,482 2,780 8,300 3,770 1 e-:.., D.-...... o..ea 1 101.000.420. 542.62.10.00 salaries 3,786 3,341 2,078 211 3,000 - 1,500 1,600 101.000.420,542.62.20.00 benefits 2,099 1,840 1,255 149 1,600 800 800 101,000,420, 542.62.30.00 supplies 67 3,218 1,638 289 500 2,000 2,000 101.100.420.542,62.45.00 Annual Loop Trail Mainf 6,000 6,492 8,000 6,000 13,000 6,000 6,000 13,000 7,000 Total pedal Purpose 10Paths,962 14,891 12,971 6,649 18,100 6,000 6,000 17,300 11,300 Street Lighting 101.000.420.542,63.10. 00 salaries 3,693 4,085 2,105 2,117 4,000 712 2,000 2,000 101.000.420,542,63.20.00 benefits 2,165 2,295 1,145 870 2,200 232 1,100 1,100 101.000.420.542.63.30.00 supplies 506 1,173 262 190 1,000 397 1,000 600 600) 101,000.420. 542.63.47,00 utilities 33,180 42,197 42,868 43,120 39,000 28,460 39,000 39,000 101.000.420.542.63.48.00 Repair &Maint 92 (796) 4,268 66 2,000 3,005 4,000 1,000 (3,000) Total Street Lighting 44.636 48,964 50,648 46,363 48,200 32,806 47,100 43,600 (3,600) Traffic Control Devices 101.000,420.542.64.10,00 salaries 29,822 31,900 43,073 33,761 40,000 24,412 40,000 40,000 101.000.420.542,64.20.00 benefits 19,652 20,765 26,262 22,886 21,600 16,235 21,600 23,000 1400 101.000420.542.64.30.00 supplies 43,887 32,920 58,388 39,411 60,000 29,148 40,000 65,000 15,000 001.000.420,542,64.47,00 utilities 12,402 7,406 7,301 7,801 8,000 5,127 8,000 9,000 1,000 101.000.420.542.64.48,00 Repair &Main 7,811 11,671 28,954 3,863 20,000 7,341 12,000 20,000 8,000 101.000.420.542,64.49.00 Miscellaneous 290 1,000 1,000 1,000 Totalra is on ro 113,674 104,662 163,978 108,002 140,600 81,263 121,600 148,000 26,400 101,000.420.542,6510,00 salaries 1,421 4,171 3,232 2,484 3,600 383 2,500 2,000 101,000.420.542.65 20 00 benefits 471 2,362 1,029 1,042 1,900 302 1,300 1,200 101,000.420.542, 65. 30. 00 supplies 236 83 65 100 - 300 ]300 101,000.420.542.65.47.00 Utilities 270 270 388 Soo 270 Soo SooParking Facilities 1,892 7.039 4,614 3,979 6,000 965 4,300 4,000 Snow & Ice Control 101, 000.420.542. 66,10.00 salaries 13,910 19,819 25,748 38,200 59,300 27,087 40,000 65,000 25,000 101.000.420.542S6.20.00 benefits 6,497 10,479 17,187 17,041 32,600 11,226 21,200 34,000 12,800 101. 000. 420.542. 66.30.00 supplies 43,069 66,731 63,861 90,639 100,000 69,261 100,000 100,000 101, 000.420.542. 66. 48,00 Repairs & Maint 948 4,962 1,000 2,062 5,000 6,000 1,000 To now ee 63,476 96,977 96,796 150,742 192,900 109,636 166,200 205,000 38,800 57 CITY OF EAST WENATCHEE STREET FUND 101 EXPENDITURES STREET/STORM WATER MAINTENANCE FUND 2018 WORKSHEET BARS 2013 2014 2015 2018 2017 2017 2017 2018 $$ Numbers Description Actual Actual Actual Actual Budget I 9Months Estimate I Budget I Change 101.000.420.542.70, 10,10 Flags/Banners Salaries - 12,116 12,106 15,000 6,766 12,000 18,00014,600 101.000,420,542.70.20.10 Benefits -Flags & Banners 4,356 6,264 8,100 2,694 6,400 10,000 101.000,420542,70.30.00 Supplies -Flags/Banners 826 2,291 1,000 1,650 3,000 2,500 101,000,420.542,70,10.00 Salaries Roadside 124,067 158,157 114,167 157,171 133,600 115,376 133,600 125,000 101.000,420.542,70. 20, 00 Benefits -Roadside 72,746 86,089 67,145 76,827 72,600 59,457 72,600 68,000 101.000.420.542.70.30.00 supplies 10,931 10,849 3,769 742 6,000 2,516 6,000 5,000 101,000,420.542.70.41.00 Professional Sery 4,659 101,000.420,542.70.47.00 Utilities 106 849 663 1,000 663 1,000 1,000 101.000.420.542,70.48.00 Repairs & Maint 2,315 10 1,000 4,076 1,000 1 000 101.000,42Q542.70.49.00 Miscellaneous 1,806 135 1,000 34 1,000 1,000 Total Roadside 214,198 257,615 203,228 266,209 238,300 193,231 234,600 231,500 City Parks 101.000.420.542.75.10.00 salaries 60,713 43,864 46,804 49,714 79,300 32,917 50,000 60,000 10,000 101.000.420.542.75.20.00 benefits 34,364 23,407 25,080 26,606 44,000 18,216 26,600 37,000 10,600 101 000 420,542.75.30.00 supplies 15,034 22,765 21,620 11,198 20,000 11,758 20,000 20,000 101. 000. 420.542,75. 47,00 utilities 2,596 3,709 3,079 3,710 3,000 3,212 3,200 31000 200 101.000.420.542.75 48 00 Repair & Maint 2,675 1,666 2,500 2,737 2,600 3,000 Soo 101.000.420.542.80,48,00 Maint Agreement - Japanese Garden 18,000 16,000 16,000 18,000 10,000 18,000 18XID0 101.000.420. 542.75,49.00 Miscellaneous - Total City Parks 112,707 1 111,745 114,158 1 108,884 166,800 78,840 120,200 141.000 20,800 Maintenance Administration - 101,000.420.542.90.10.00 salaries 1,892 5,570 19,438 9,620 16,000 2,786 15,000 13,000 2,000) 101,000.420.542.90.20,00 benefits 101.000,420.542.90.30.00 shop supplies 101.000.420. 542.90.48.00 Repairs & Maint 1,112 2,344 8,331 4,015 8,100 1.468 8,100 7,600 600 2,099 81 104 27 Total aintenance 3,004 10,094 27,873 13,562 23,100 4,254 23,100 20,500 (2,600) Grand Total Maintenance 630,104 703,716 710,498 783,623 897,000 563,196 784,380 905,700 119,570 General Services 101.000.430.543.30.10.00 Salaries 33,678 32,064 25,546 31,633 50,000 24,926 40,000 60,000 10,000 101.000,430.543,30,20.00 Benefits 22,876 17,461 12,182 17,612 13,500 12,099 21,200 13,500 (7,700) 101,000.430.543.30.30,00 supplies 157 3,932 8,153 10,210 6.000 5,128 6,000 6,000 101. 000. 430.543.30.46.00 Insurance 26,187 39,173 39,622 37,222 36,900 740 41,452 45,600 4,148 101.000.430.543,30.49.00 Miscellaneous 1,373 2,686 3,280 3,331 3,000 3,233 3,000 3,000 Total General Services 84,271 95,316 88,782 99,908 108,400 46.126 111,652 118,100 4,148 Facilities 101.000.430. 543.50.10,00 salaries 5,272 1,785 10,014 2,965 8,000 354 5,000 6,000 1,000 101.000.430.543.50.20.00 benefits 3,732 1,224 6,166 1,453 1,300 138 2,650 3,500 850 101,000.430.543,50.30.00 supplies 308 978 1,784 1,177 2,000 535 1,000 2,000 1,000 101.000,430.543,50.47.00 utilities 4,261 6,861 4,964 4,246 6,000 4,815 6,000 6.000 101.000,430.543.50.48.00 j Repair & Maint 123 517 645 1,582 1,000 13,654 16,000 2,600 (12,500) 101.000.430,543.50.49,00 Miscellaneous 2,928 1,358 Soo 138 - 500 Soo Total Facilities 16,624 10,366 23,573 12,771 18,800 19,634 29,650 20,500 (9,150) 58 CITY OF EAST WENATCHEE STREET FUND 101 EXPENDITURES STREET/STORM WATER MAINTENANCE FUND 2018 WORKSHEET BARS Numbers Description 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 9 Months 2017 Estimate 2018 Budget $$ Change Training 101,000.430. 544.90.10.00 salaries 369 1,738 3,371 2,000 3,318 4,000 2,000 (2,000) 101, 000.430.544. 90.20.00 benefits 321 870 1,603 1,100 1,392 2,000 1,100 (900) 101,000,430.544.90, 30, 00 supplies 1,644 18 590 1,000 223 400 1,000 600 101.000.430. 544.90.35,00 Travel -Training 754 600 1,031 260 1,000 50 1,000 1,000 101.000.430.544.90.49.01 Miscellaneous 210 827 920 1,608 2,000 1,960 2,000 1,000 (1,000) Total Training 2,608 2,136 5,149 6,842 7,100 6,943 8,400 6,100 (2,300) Miscellaneous 101.000.430. 544.90.49,30 Miscellaneous 7,981 693 8 8 - 101.000.430.594.42.60.00 Capital Outlay 14,780 14,067 10,921 - - - Total Miscellaneous 16,761 14,760 10,929 8 - - - - Grand Total Administration Total 120,264 122,576 128,433 119,629 134,300 72,703 149,702 144,700 (7,302) Grand Total Street Expenditures 750,368 826,292 838,931 903,152 1,031,300 625,899 934,082 1,050,400 116.318 Grand Totals All Expenditures 1,127,748 1,504,939 1,167,824 1,227,260 1,390,600 909,509 1 1,251,988 1 1,441,847 184,3 99 LABOR 8 BENEFIT SUMMARY: Description Storm Water Activities salary expense (annual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 9Months 2017 Estimate 2018 Budget $$ Change 76,863 60,067 91,483 74,211 92,000 61,061 78,000 88,600 10,500 Benefitexpense(annu 45,874 33,982 4g162 38,001 49,600 32,201 41,300 46,600 5,300 $ 122,737 § 94,039 $ 136,646 $ 112,212 S 141,600 $ 93,262 $ 119,300 $ 135,100 15,800 Maintenance salary expense(annua 139,395 296,377 284,207 324,460 379,300 229,772 321,100 364,000 42,900 Benefit expense (an nu 80,564 161,818 159,632 162,992 207,100 117,714 172,830 202,900 30,070 $ 219,949 $ 458,195 $ 443,839 $ 487,452 $ 686,400 § 347,486 $ 493,930 S 566.900 72.970 Administration isalary expense(annua 38,950 34,218 37,297 37,959 60,000 28,598 49,000 68,000 9,000 Benefit expense (annul 26,608 19,006 19,218 20,568 29,400 13,629 25,850 31,600 (7,750) $ 65,558 $ 53,224 $ 66,616 $ 58,527 $ 89.400 $ 42,227 $ 74,850 $ 89,600 14,750 Total Street/SWA Labor salary expense(annua 265,208 390,652 412,987 436,630 631,300 319,431 448,100 510,500 62,400 Benefit expense (annu 153,036 214,806 223,012 221,661 286,100 163,644 239,980 281,100 27,620 $ 408,244 $ 606,468 1 $ 636,999 1 $ 658,191 1 $ 817.400 $ 482,975 $ 688,080 S 791.600 103,520 Total SWU Cap EPMBR Gen Fund Events Streets Total Laborfor 2018 563,800 8,000 31,000 3,000 8,000 613,800 Total Benefits for 2018 297,800 4600 18,000 4,000 271,200 Total Labor and Benefits 861,600 12,600 49,000 3,000 12,000 786,000 59 2018 BUDGET COMMUNITY DEVELOPMENT GRANT FUND The City of East Wenatchee is an entitlement jurisdiction and receives annual Community Development Block Grant (CDBG) allocations from the US Department of Housing and Urban Development for housing, community, and economic development activities and assistance to low -and moderate -income persons and special populations. The revenue and expenditures listed in the Community Development Grant Fund budget are only those funds provided by HUD. Allowable time and materials by the Community Development Department and professional service support are segregated in this fund, and billed for reimbursement under this entitlement allocation. The Program Year for these funds is from October 1 through September 30 each year. The 2017 CDBG Program Allocation is $114,552. The adopted 2017 Annual Action Plan designates the funds for the following projects: • $100,000 for the 51h Street NE Street Improvement Project. • $14,552 for general administration and planning of the CDBG program. In addition to the 2017 Program Year allocation, $6,288 is anticipated to carry over from the 2016 Program Year, $2,074 remains from the 2015 Program Year, and $10,000 remains from the 2014 Program Year. The 2014 funds were earmarked for fair housing activities. The City of East Wenatchee will be working with the City of Wenatchee and the Housing Authority to develop a regional Assessment of Fair Housing that will be due in 2018. It is anticipated that the majority of the carryover funds will be expended on that project and some funds used to host local fair housing training sessions for agencies, tenants, and landlords. The 5ch Street Improvement Project revenue and expenditure will not be shown in this Grant Fund budget since it is a capital project. M1I CITY OF EAST WENATCHEE COMMUNITY DEVELOPMENT GRANT FUND 102 COMMUNITY DEVELOPMENT GRANT FUND 2017 BUDGET WORKSHEET - Department Head / Community Development Director, Lori Barnett Description 2012 Actuai 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 6 Months 2017 Estimate 2018 Budget $$$$ Change Revenues 102.000.000.308.00.00.00 Beginning NC&I 26,811 1 29,368 38,484 58,496 68,462 68,462 71,724 71,724 71,724 _ Totals 26,811 29,368 38,484 58,496 68,462 68,462 71,724 71,724 71,724 - 102.000,000.334,04,30.00 HUD CD Block Grant 2,713 15,706 85,065 15,696 6,000 7,005 - 32,840 102.000.000.360.00.00.00 IMiscellaneous Total Revenue 1 2,713 1 15,706 1 85,065 1 15,696 1 6,000 7,005 1- 32,840 Resources Available 29,524 45,074 123,549 74,192 74,462 68,462 71,724 78,729 71,724 32,840 Expenditures _ 102.000.000.558.70,10.00 Salaries - - - 3,024 4,000 976 102.000.000.558,70.20.00 Benefits - 948 1,240 292 102.000.000.558.70.31. 00 Office Supplies 59 167 - - 102.000.000.558.70.41.00 Prof Services 5,000 2,125 5,000 - 22,700 23,800 23,800 Telephone - - - - 102.000.000.558.70.42.03 Postage - 138 10 - - 102.000.000.558.70.44.00 Advertising 157 664 1,611 661 846 1,000 1,600 2,000 400 102.000.000.558.70.49. 00 Misc 788 43 1,892 1,500 1,433 1,800 367 102.000.000.558,70.55. 00 Housing Program Costs 61,275 - - Total Expenditures 157 6,590 66,054 5,730 2,738 25,367 7,005 32,840 25,835 Ending NC&I 29,367 38,484 58,496 68,462 71,724 43,095 71,724 71,724 38,884 7 005 61 2018 BUDGET EAST WENATCHEE TRANSPORTATION BENEFIT DISTRICT FUND ("TBD") I t "A ZLUI The City established this fund in late 2012, registered with the Department of Licensing in 2013, receive approximately $60,647 for the partial year 2013, has received approximately $216,749 in 2014, $215,700 in 2015, $243,558 in 2016, is expected to receive $242,100 in 2017 and has forecast $245,100 for 2018 in proceeds from the $20 car tab fee. The revenue from this fund is specifically designated for support of residential street improvement projects. EXPENDITURES The City spent $393,369 in 2016 on residential street improvement projects primarily due to the rescheduling of projects from 2015 to 2016. The improvement projects in 2017 are in progress and estimated to cost $184,567. $197,335 has been budgeted for projects in 2018. Residential projects for the entire City were identified during the establishment of this fund in 2012, grouped by highest need and proximity, and re-evaluated periodically. j% CITY OF EAST WENATCHEE TRANSPORTATION BENEFIT TRANSPORTATION BENEFIT DISTRICT FUND DISTRICT FUND# 105 2018 BUDGET- Finance BARS Numbers Description 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 Budget 2017 6Months 2017 Estimate 2018 Budget $ Change Revenues 630.000.000.30810 00 00 Beginning NC& 60,647 160,019 359,230 352,341 209,419 209,419 266,962 57,533 Totals 60,647 160,019 359,230 352,341 209,419 209,419 266,952 Revenue 630,000.000.317.60.00.00 Car Tab Fee Revenue 60,647 216,749 218,000 243,558 235,000 120,601 242,100 245.100 3,000 630.000.000,317.60.00.00 Estimated Refunds (2,300) - - - Total Revenue 60,647 216,749 215,700 243,658 235,000 120,601 242,100 245,100 3,000 Resources Available 60,647 277,396 375,719 602,788 587,341 330,020 451,519 512,052 60,533 Expenditures 630,000. 000.540.60.50.00 TBD Project Costs 117,377 23,199 393,369 114,075 184,567 197,335 12,768 630.000,000. 541.60.50.10 TBD Admin Costs 179 - _ Total Expenditures - 117,377 23,378 393,369 114,075 - 184,567 197,335 12,768 630.002.000,508,10,00,00 Ending NC&I 60,647 160,019 352,341 209,419 473,266 330,020 266,962 314,717 47,765 Note: The projects scheduled for 2016 are portions of 2nd St. NE, Rolfs Ct, Rolfs PI, 4th St. NE, Colby Ct., Darwood, and French Avenue. Projects schedule for 2017 include portions of Gale Place, Garden Court and Garden Place. Refunds: The City is responsible under its contract with the Department of Licensing to satisfy and pay all refunds of fees that may have been collected by the DOL and previously remitted to the City from boundary errors or disputes from mapping of City/County boundaries. 63 2018 BUDGET DEBT RESERVE FUND # 110 The City activated this fund after paying off the debt from the 2000 bond issue (See Fund #202). The initial annual contribution of $165,000 to this fund was determined based upon the approximate debt service on that bond issue. These funds will be used for any purpose in support of future debt service or a reserve to support reserve requirements of a future loan or bond issue. The Budget Committee will re-evaluate the periodic contributions to the Fund annually based upon cash flow and reserve strategies. GZ! CITY OF EAST WENATCHEE DEBT RESERVE FUND; DEBT RESERVE FUND 2018 BUDGET - Finance BARS Numbers Description 2016 Actual 2017 Budget 2017Est Actual 2018 Budget $ Change Revenues 110.000.000.308.80.00,00 Beginning NC&I - 165,000 165,000 330,000 Totals 165,000 165,000 330,000 Revenue 110. 000. 000. 311. 10. 00. 00 Property Tax 165,000 165,000 165,000 165,000 110.000.000.369.50,00.00 Disposition Proceeds Total Revenue 165,000 165,000 165,000 165,000 - Resources Available 165,000 330,000 330,000 495,000 Expenditures 110.000.000.569.00.60.49 Miscellaneous 110.000.000.597.00.00.00 Transfer Out Total Expenditures _ _ 110.000.000.508.80.00.00 Ending NC&I 165,000 330,000 330,000 495,000 The purpose of this Fund is to accumulate funds over time for use in supporting the costs of a debt financing or the debt service of a financing. The initial amount of annual funding was approximately the scope of the previous bond financing in Fund 202 I& 2018 BUDGET LIBRARY FUND On July 20, 2006, the City of East Wenatchee signed a new Building Use and Maintenance Agreement with the North Central Regional Library District. The agreement has been renewed in 2014 for the years 2015 thru 2023. The City will be reimbursed as follows: January 1, 2006 — December 31, 2008 $2,500 per year January 1, 2009 —December 31, 2011 $2,750 per year January 1, 2012 — December 31, 2014 $3,000 per year January 1, 2015 — December 31, 2017 $6,500 per year January 1, 2018 — December 31, 2020 $7,000 per year REVENUES Library Services This revenue is paid to the City for contracted building use and maintenance reimbursement from the North Central Regional Library District ("NCRLD"). Reimbursement payments are received in June and November of each year. The City renewed its agreement with the NCRLD to include an additional 1,000 square feet in the calculation. As noted above, the City will receive $7,000 in 2018 thru 2020, at which time the annual payment will increase. Professional Services The City allocates a proportionate share of the cost of contracted janitorial services to the Library. Utilities The City allocates a proportionate share of the cost of utilities to the Library. Repairs & Maintenance The cost of repairs and maintenance to library area are accumulated and charged to the Library. Miscellaneous Miscellaneous expenditures associated with the library are charged accordingly. M CITY OF EAST WENATCHEE LIBRARY FUND 112 LIBRARY FUND 2018 BUDGET Description 2011 Actual 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2010 Actual 2017 Budget 2017 BMonths 2017 Estimate 2018 Budget $Chg Beginning NC&I 5,673 4,615 3,609 2,337 1,370 4,419 5,545 5,703 5,703 7,403 Totals 5,673 4,615 3,609 2,337 1,370 4,419 5,545 5,703 5,703 1 7,403 1,700 Revenues Sales & Use Tax - - 3,500 - Library Services 2,750 3,000 3,000 3,000 6,500 6,500 6,500 3,250 6,500 6,500 Interest Earnings Total Revenue 2,750 3,000 3,000 3,000 10,000 6,500 6,500 J,250 6,500 6,500 - Resources Available 8,423 1 7,615 1 6,609 5,337 11,370 10,919 12,045 8.953 12,203 13,903 1,700 Expenditures Salaries Benefits - - Professional Services 2,188 2,595 2,902 2,852 4,986 2,800 3,500 1,549 3,000 3,200 200 Utilities 1,597 1,111 1,359 1,074 1,874 2,331 1,750 1,021 1,750 1,600 50 Repairs & Maintenance 32 46 100 Miscellaneous Total Expenditures 22 12 8 46 85 50 15 50 100 50 3,807 4,006 4,273 3,966 6,952 5,216 5,400 2,585 4,800 5,100 300 Ending NM 4,616 3,609 2,336 1,370 4,419 5,703 6,645 6,366 7,403 8,803 1,400 Note: The City has renew the agreement with the North Central Library District for use of City space ('Building Use and Maintenance Agreement'). The District has agreed to increase the square footage they would use temporarily for other library activities during the agreement by 1,000 square feet, resulting in a total of 2,000 total square feet. This factor results in a revenue contribution of $6,500 per year, at $3.25 per square foot. The agreement The agreement was renewed in 2015 and extends thru 2023 at the same revenue contribution level. 2018 BUDGET HOTEL/MOTEL TAX FUND Note: Hotel/Motel Taxes are collected by the hoteliers located in the City, remitted to the State, and subsequently remitted to the City. A portion is allocated to the Events Fund to support its events which result in tourism and recreation activities. The remainder is recorded in this fund for the purpose of use in support of tourism and recreation activities. The EWEB Board is the Lodging Tax Advisory Committee (LTAC) for the City, which has the responsibility for considering the City's use of Hotel/Motel Taxes in its Events Fund, as well as considering other uses in the community which would qualify for tourism and promotional purposes. If the LTAC votes favorably upon an expenditure of these funds, it makes a recommendation to the City Council for its deliberation and approval. If approved, the expenditure is made. REVENUE The City has made progress in more accurately apportioning costs in support of the Events Fund. In addition, a new event has been added (Parkway Pileup) and certain event activities have been increased and refined. Consequently, Hotel/Motel Tax Fund is allocated funds in direct response to specific qualified activities that the LTAC and City Council have approved. In 2017, $14,500 has been allocated, with the balance of Hotel/Hotel Receipts allocated to the Events Fund. The LTAC has not received or considered a request for funding for 2017. The contributions to the Wenatchee Sports Council and Chamber have been provided in 2017. Other possible requests for funding will be evaluated as they arise. W CITY OF EAST WENATCHEE HOTELIMOTEL TAX FUND 113 HOTEL/MOTEL TAX FUND 2018 BUDGET WORKSHEET BARS Numbers Desctlp0on 2012 Actual 2'13 Actual 201/ Actual 1015 Actual 1016 Actual 2017 Budget 2017 .Months 2017 EsfimaN 2017 Budget $$ Change 113.000.000.308.00,00.00 Beginning NC81 17,64] 13,278 46,45377,870 87,718 3,761 3,311 3,311 2,811 (500) Tofals 17,647 1 13,278 46,453 77,870 87,718 1 3,761 1 3,311 1 3,311 2,811 1 (500 Revenues 113.000,000.313,30.00.00 1st 2%Tax 113.000.000.313,30.01, 00 60%of 2nd 2%Tex 113,000, 000, 313.30, 02.00 32%of 2nd Tax- 12,116 13,953 14,306 10,000 6,000 7,000 6,000 7,000 7,000 113,000.000.313,30.03.00 64%of 3rd 2%Tax 24,229 27,498 28,611 20,500 6,000 7,000 6,000 7,000 7,000 113.000.000.313.30.04.00 20%of 3rd 2%Tax - 113.000.000.361,00.00, 00 Interest Earnings Total Revenue 36,344 41,451 42,917 30,600 I 12,000 1 14,000 12,000 14,000 1 14,000 Total Resources Avail. ble 53,991 1 54,729 1 89,370 108,370 99.718 17,761 1 15,311 1 17,311 1 16,811 (600 Expenditures 113,000,000.557,30.41.00 1st 2%Tex - 113,000,000.557.30.41. 01 60% of grid 2%Tax 113.000.000.557,30.41.02 32%of 2nd 2%Tax 12,571 1,092 - 113.000.000.557.30.41.03 64%of 3rd 2%Tax 25,142 2,184 113.000.000.557.30,41.10 Contribullons to Other Entities 3,000 5,000 11,500 20,652 12,500 14,600 12,600 14,500 14,500 _ 113.000,000,557,30.41,15 Wenatchee Valley Museum 83,907 Operating Transfer Out to EWER Total Expenditures 40,711 8,276 11,600 20,662 96,407 14,500 12,500#tj 113.000.000.608.00.00.00 Ending NCSI 13,278 46,453 77,870 87,718 3,311 3,261 2,811 (A) The agreement to provide this funding to the City of Wenatchee Convention Center expired In 2010. In 2011 and beyond, this revenue will bl receipted into the Events Fund #117 to support events funding. (B) The agreement to provide this funding to the Wenatchee Valley Visitors and Convention Bureau expires in January 2013. Future receipts will be subject to consideration and recommendations by the Events Board (LTAC for the City) and approval by Council. Note: Revenue is expected to increase in 2016 based upon the current pattern in 2015. The contribution for 2016 is for the Wenatchee Valley Chamber of Commerce, including $10,000 for the Wenatchee Valley Sports Council and $2,500 for coordination of the City's Events to be included in advertising and promotional materials of the Chamber. The Events Coordinator, Dan White, will work with the Chamber to that end. Also note that the allocation of Hotel/Motel Tax to this fund has been reduced to $6,000 each of the second and third 2% portions. As noted in the Events Fund 117, the reduction in this fund is associated with the estimated need for an additional allocation of revenue to the Events Fund. Budget Amendment 2017 $2,000 for Velocity Swimming 69 2018 BUDGET DRUG FUND REVENUE The City allocates a portion of Municipal Court Receipts to this fund. Periodically, the City also determined to remove forfeited property (cash) from its Police repository and the proceeds of forfeited property from drug related offenses and deposit these funds to be used for purposes consistent with this fund. $5,902 was deposited during 2017. The City spends a portion of these funds in support of drug related programs under the direction of the Police Chief. 70 CITY OF EAST WENATCHEE DRUG FUND 114 DRUG INVESTIGATION FUND 2018 Budget BARS Numbers Description 1112 Actual 1 1113 Actual 1 1014 Actual 2015 Actual 2018 Actual 2017 Budget 2017 6Months 2017 Estimate 2018 I Budget $S Change 114.000.000,308.00.00.00 Beginning NC&I 1 5,009 5,456 1 5,182 1 5,868 1 3,219 1 4,181 4,181 4,181 1 2,574 Total 5,009 5,456 5,182 5,868 3,219 4,181 4,181 4,181 2,574 1,607 Revenue 114.000.000.356.50.03.00 Drug Buy 447 4,726 167 1,768 828 250 75 120 120 114.000.000.357.30.01.00 Restitution 13 114.000,000.360.00.00.00 Miscellaneous 114.000.000,361.00.00.00 Interest Earnings 114.000.000.367,00.00.00 Contributions 114.000.000,369.30.00.00 Forfeited Property 519 121 5,902 5,902 (5,902 Transfer in From Total Revenue 447 4,726- 686 1,768 962 250 5,977 6,022 120 (5,902) Total Resources Available 5,456 10,182 768 7,636 4,181 4,431 10,168 10,203 2,694 (7,509) Expenditures 114.000.000.566,00.49.00 Miscellaneous 114.000,000.566.00.49.05 Stare Share -Prop 114.000.000.521.10,35.00 Small ToolsEquip - 5,000 4,417 - 5,272 7,629 2,000 Total Exp 5,000 4,417 5,272 7,629 2,000 (5,629) 115.000.000.508.00.00.00 Ending NC&I 1 5,456 1 5,182 1 5,868 3,219 1 4,181 4,431 4,8861 2,5741 694 (1,880) 71 2018 BUDGET CRIMINAL JUSTICE FUND REVENUE Revenue sources for the Criminal Justice Fund are yearly allocations received monthly and periodically from the State of Washington Department of Community, Trade, and Economic Development to be used for Law Enforcement purposes. EXPENDITURES Capital Outlav In previous years, Criminal Justice Fund expenditures included the lease payments for police vehicles. During 2011, the City Council approved paying off the existing leases to avoid future interest expense costs. The 2015 budget included the funding of the purchase of one police vehicle as planned by the Police Chief by way of a transfer of funds out of this fund to the EPM&R Fund to accomplish the purchase. Accumulation of funds is planned for 2016 and 2017 Have allowed for the purchase of one police vehicle in 2017. Funding for the next police vehicle purchase is scheduled for 2019 or 2020 depending upon the level of receipts. 72 CITY OF EAST WENATCHEE CRIMINAL JUSTICE FUND 116 CRIMINAL JUSTICE FUND 0 2018 BUDGET WORKSHEET BARS Number Description 2012 Actual 2013 Actual 201d Actual 2011 Actual 2016 Actual 2017 Budget 2017 6MonMs 2017 Estimate 2018 Budget $$ Cnange 116.000.000.308D0.00.00 Beginning NC&I 7,138 1 14,480 25,523 41.699 18,361 1 35.311 36,496 35,496 9.836 Totals 7,138 14,480 25,523 1 41,699 18,361 1 35,311 1 35,496 35,496 1 9,836 125,6601 Revenue 116o00.000.313,10.00.00 Allocated Sales and U 25,000 116.000.000.334.06.90.01 WASPC Grant 116.000.000.336.06.20.0D High Crime 116.000.000.336,06.21.00 Population 2,979 3.194 3.457 3,573 3,688 3,575 1,867 3.740 3,740 116.000.000.336.06.26.00 Special Programs 11,201 11,888 12,719 13,090 13,447 13,300 6,793 13,600 13.600 116.000.000.336.06,30.00 EWPD Unclaimed Mo 116.000.000.361.00,00.00 Interest Earnings Total Revenue 39,180 15,082 1 16,176 16,663 17,135 16,8751 8,660 17,340 17,340 Total Resources Available 4Q318 29,562 41,699 58,362 1 35,496 52,186 44,156 52,636 27,176 (25,660) Expenditures 116,000.000.597.21.00.20 Transfer Out. EPM&R - 40,000 - 43,000 43,000 43,000 116.000,000.594,21.60.00 Capital Outlay 31,838 4,040 - - 116.000.000,594.00.60.01 Cap WASPC Equip 116.000.000,594.00.60.49 Miscellaneous - Total Expenditures 31,838 4,040 40,000 43,000 43,000 43,000 (43,000) 116. 000000,508.00,00.00 Ending NC&I 14,480 25.522 41.699 18,362 1 35,496 9,186 1,166 9,836 1 27.176 17,340 Note: The fund is expected to accumulate sufficient funds during 2016 and 2017 to allow for the purchase of one police vehicle in 2017, as planned by the Police Chief. 73 2018 BUDGET EAST WENATCHE EVENTS FUND Note: This will be the tenth full year with the EWEB as a city department. Expenses have been allocated to the various events based upon the historical and planned levels of each event during the upcoming year. Citizen based committees assist in the planning and support of each of these activities, along with the Events Coordinator and Events Support, and City employees. Support is also provided by the Police Department for public safety and traffic control, as well as the Street Department for parade route barricades and facility support. Classy Chassis, Wings & Wheels, Easter Egg Hunt, and Christmas Tree Lighting are currently the main events. A new event called the "Parkway Pile-up" Car Show has been held for the last three years in early summer in the area of 9t" Street and Valley Mall Parkway, sponsored by businesses in that area of the City and local car clubs. Based upon its success, the Events Coordinator is planning to hold the event in 2017, and perhaps each year thereafter. Revenues are generated at each of these events in the form of sales of clothing, fees for exhibit space and sponsorship of various related activities by local and regional businesses. An additional role for this department is marketing for the City through participation on local, regional and state-wide recreation and tourism boards and committees. REVENUES/EXPENDITURES The Events Department is funded with a combination of Hotel/Motel Taxes, Sponsorships, Sales of Promotional Goods, and Event Registrations. During 2009, the Events Fund felt the negative economic impacts of the recent recession and experienced a reduction in sponsorship fees. Consequently, the City had allocated a portion of Sales & Use Taxes during certain years to supplement the financial needs of this fund. $20,000 was allocated for 2009, $102,000 for 2010, and $108,000 for 2011. Since 2011, no allocation of sales tax has been necessary and the expectation is that none will be financially necessary for 2017. The City has determined that the previous allocation of Hotel/Motel Tax is no longer sufficient due to additional costs incurred to satisfy event on -going commitments. Consequently, the City has determined to allocate additional portions of the Hotel/Motel Tax for the 2018 budget year, and continuing at that same approximate level in future years as needed. The City has determined to no longer fund the Wenatchee Valley Visitor's Bureau effective mid - January 2013. The City's Events Board, the Lodging Tax Advisory Committee (LTAC) for the City, determined to maintain these funds internally for the purposes of additional funding for the Events Fund if necessary, as well as considering other uses in the community which would qualify for tourism and promotional purposes. The remainder of Hotel/Motel Tax revenue will be deposited in the Hotel/Motel Tax Fund #113 for availability for those purposes. Beginning in early 2012, the Events Coordinator and Events Support positions are satisfied under employment agreements as independent contractors. CITY OF EAST WENATCHEE EAST WENATCHEE EVENTS BOARD FUND 117 EVENTS FUND REVENUE 2018 REVENUE BUDGET BARS Numbers Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2018 Actual 2017 Budget 2017 9 Months 2017 Estimate 2018 Budget $$ Change 117.000.100.308.00.00.00i Beginning NC&I 22,986 1 26,307 1 42,493 1 36,186 35,888 68,121 85,433 86,433 136,223 Totals 22,986 1 26,307 1 42,493 1 35,186 36,888 Revenue 68,121 85,433 86,433 136,223 30,790 117.000,100.313.31.00.00 H/M Tex- Events Fund 37,859 42,966 44,705 46,130 161,020 126,500 129,424 163,333 169,699 6,366 117.000.100.313,31.00.03 68%of 2nd 2%Tax Alloc 26,743 29,013 30,400 35,130 - 117.000.100.313.31.00.04 36%of 3rd 2%Tax Alloc 13,629 16,468 16,094 24,630 117.000,200.347.40.00.05 Total 77,231 87,447 91,199 104,890 161,020 126,600 129,424 153,333 169,699 6,366 Vendor Fees 250 26 25 26 25 117.000.200.347.40.02,01 EEH Admission Fees 1,760 2,125 1,527 1,647 1,645 1,600 1,584 1,684 1,600 16 117.000.200,360.00.00.02 EEH Misc Revenue 26 117.000.200.347.90.00.01 EEH Donations 250 117.000.200.347,90.00.02 EEH Sponsorships 250 117.000.300.347.40,12.02 Total 21286 2,400 1 1,652 1,547 1,670 1,600 1,609 1,684 1,600 16 CC Parade/Car Show 9,212 10,442 10,788 10,243 10,765 10,760 8,165 8,140 8,500 360 117.000.300.347.40.12.03 CC Vendor Fees 675 426 606 450 324 326 276 276 276 117.000.300.347.90.00.01 CC Donations 690 260 250 (260) 117.000.300.347,90.00.12 CC Sponsorships 7,691 9,660 9,009 10,178 9,450 9,600 9,225 9,226 9,600 276 117.000.300.347.90,12.00 CC Merchandise Sales 1,960 2,669 913 961 1,969 2,000 2,280 2,280 2,300 20 117.000.300.369.90,50.00 CC Misc Revenue 117.000A00.347.40.11.03 Total 19,988 23,076 1 21,216 21,822 22,498 22,576 20,195 20,170 20,576 406 W&W Car Show 3,734 1 4,882 5,216 6,686 6,670 4,600 2,094 6,000 4,700 (300) 117,000.400.347.40.11.04 W&W Carnival 3,697 4,285 3,992 4,000 4,483 3,600 4,000 6,000 1,000 117,000.400.347.40.11.05 W&W Motorcycle Feet 117.000.400.347.40A 1.07 W&W Vendor Fees 1,615 1,116 836 1 310 300 6001 215 600 1 260 (250) 117.000.400.347.90.00.01 W&W Donations 6,000 1,500 1 1,360 260 1,400 1,160 117.000,400.347.90.00. 11 W&W Sponsorships 2,000 10,802 7,363 7,700 6,700 5,000 6,760 6,000 7,000 2,000 117.000.400.347.90.00.13 Schad of Events Brochure 6,360 3,750 6,600 6,200 7,550 5,000 1,600 5,000 6,000 117.000A00.347.90.00.14 W&W Ad Reimb 460 360 460 326 450 117.000.400.347,90.11.00 W&W March Sales 1,202 1,388 654 1,219 1,118 1,200 1,200 900 (300) 117.000.400.369.90,00.00 W&W Misc Revenue 425 70 Total 23,973 26,672 25,109 26,389 28,671 19,700 12,009 20,950 24,260 3,300 117.000.450.347.90.00.12 PPile-up Car Show Sponsorshipj 600 300 1,000 461 451 450 (1) 117.000A50.347.90.00.15 PPile-up Car Show Misc Raven 1 307 550 600 Total 500 607 550 1,600 461 461 450 117.000.500.360.00.00.01 Christmas Misc Rev 117.000.503,3157.11.00.01 Christmas Donations 117.000.500.367.19.00.01 Sponsorship-Wings&Wishes 2,000 2,000 2,000 2,000 - Total Total Revenue 123,477 1393495 1 139,676 1543266 204,309 2,000 2,000 2,000 2,000 173,976 1 166,688 1 198,488 1 208,674 1 10,087 Total Resources Available 146,463 166,802 1 182,068 189,441 240,197 232,096 251,121 283,921 3443797 60,876 75 CITY OF EAST WENATCHEE EAST WENATCHEE EVENTS BOARD FUND 117 EVENTS FUND EXPENDITURES 2018 BUDGET - EXPENDITURES BARS Numbers Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2016 Actual 2017 I Budget 2017 9 Months 2017 Estimate 2018 Budget bb Change Available Resources 1 146,4631 165,8021 182,068 189,441 240,197 232,096 251.121 283,921 344,797 60876 117.000.000.557,30.10.00 EWEB Salaries 15,327 13016 17337 10,527 13,636 12,000 6,571 12,000 12,000 Street Dept Support Police Dept Support 117.000.000.557.30.20.00 EWEB Benefits 4,551 3,883 6,478 1 4841 6,524 5,600 1781 5,600 5,600 117.000.050.557.30.30.00 Contracted Services 55,500 62,400 75,600 78,510 81,293 30,410 62,152 80,410 85,9001 5,490 Total EWEB Salaries and Benefits 75,378 79,299 99 415 93 878 101,453 98,010 70,504 98,010 103,500 5,490 117.000,100.557.30,25.00 EWEB Marketing- Regional Tourism 50 75 2,752 1,050 2,000 100 Soo 2,000 1,500 117.000.100.557.30,27.00 City Theme 117.000.100.557.30.32.00 EWEB Fuel Consumed 127 89 100 41 100 100 117.000.100-557.30.35.00 EWEB Smalls Tools & Equipment 27 208 100 100 117.000.100.557.30.42,00 EWEB Training 500 117.000.100.557.30.41.00 EWEB Professional Services 300 117.000.100.557.00.42.00 EWEB Telephone 117.000.100.557.00.42.03 EWEB Postage 18 117.000. 100.557.00.43.00 EWEB Travel 23 42 30 117.000.100.557,00.44.00 EWEB Advertising 13 117.000.100.557.30A8.00 EWEB Repairs 68 117.000.100.557.30.49.00 EWEB Misc 713 465 228 806 222 100 80 100 100 117.000.100.596.79,60.00 EWEB Capital Outlay 1,716 726 417 1,000 324 500 200 300 117.000.105.557.30 50 00 EWEB Insurance 2,930 3,141 3761 3,267 3,379 3,600 49 4,200 4,600 400 000. 110.557.00!31!03 EVvcB Cenbal Shires 47 117.000.115.557.30.31.05 I EWEB Office Su lies 242 1 340 153 745 169 250 864 11000 1,000 EWEB General Expenditures 1 53642 4,803 4,788 7,7481 5,057 7,8501 1,458 61300 1 8,100 1,800 117.000.200.557.30.35.02 EEH Small Tools 35 228 42 17 413 200 200 200 117.000.200.557,00.41.02 EEH Professional Services 250 - - 117.000.200.557.30.46.00 Easter Office Supplies 40 77 117.000.200.557.30.44.02 EEH Advertising 212 250 427 94 350 250 350 350 117.000.200.557.30A9.02 EEH Misc 1,194 472 1,738 915 1,192 1,500 1,177 1,500 1,500 117.000,200.594.00.60.02 Easter Capital Outlay Easter Event Expenses 1,481 950 2,107 1,359 1,700 2,050 1,427 1,850 2,050 200 117.000,300.557.30.32.12 CC Fuel Consumed 100 100 117.000.300.557.30.34.11 CC March for Resale 3,251 1 4,752 4,3541 4,199 43482 111 4,500V44,,"'P431 4,740 4,800 60 117.000.300,557,30.35.12 CC Small Tools & Equipment 2,589 3,059 2,464 2,499 1,118 1,000 100 1,000 900 117.000.300.557.30.41.12 CC Professional Services 750 920 2,341 2,400 3,224 4,500 1,276 117.000.300.557.30.42.14 CC Postage 902 1,129 1,033 1,009 1,151 1,200 1,429 1,500 71 117.000.300.55TWA3.12 CC EMPD FacilityFee 11000 1,000 1,075 1,000 1,100 100 117.000.300.557.30.44.12 CC Advertising3,500 3,562 3167 5,121 3593 4,000 4,500 4,500 117.000.300.5177 30.49.12 CC Misc 1,932 1 763 1 234 17 2 050 2,000 1,000 1,000 117.000.W0.594.30.60.12 1CC Capital Cullay lClassy Chassis Event Expenses 12 174 I 14,265 13,002 1 14 731 15,736 1 16,175 1 15,874 1 15,993 1 18,500 2 507 76 117.000,500,557.30.35.01 Christmas Small Tools 271 58 162 362 21 400 400 400 117.000.500.557.30.40.05 Christmas Events & Decs 1 728 979 4,031 1 063 1 180 1,500 1.400 1,500 100 117.000,500.557.30.41.01 Christmas Professional Services 503 644 117.000.500.557.30.42.04 Christmas Postage 117.000.500.557.30.44.01 Christmas Advertising 1,340 850 1,023 1,245 500 1,500 1,200 1,500 300 117.000.500.557.30.49.01 Christmas Misc 403 620 737 503 600 97 600 800 200 117.000.500.594.30.60.01 Christmas Capital 10,254 Christmas Event Expenses 3,339 2,793 6,480 13,661 2,204 4.000 97 3,600 4,200 600 187 77 2018 BUDGET BOND REDEMPTION FUND Note: Bond Fund #202 is a Redemption Fund for original proceeds used for street improvements. The bond, in the original amount of $1,545,000 was issued on December 15, 2000. The bond was be paid in full December 1, 2015. Payments are made from property tax allocations to this Fund. This fund also includes the debt service on the Public Works Trust Fund Loan used to improve 1Ith Street and the related Storm Water Utility improvements. By agreement, the Greater East Wenatchee Storm Water Utility (GEWSWU) agreed to participate in the payment of this loan. The GEWSWU contribution in 2016 was $12,175 and $9,770 in 2017 to assist in satisfying total debt service of $31,198 for 2016 and $30,901 in 2017. The GEWSWU's participation expired in 2017 and the City will bear the total annual debt service costs thru 2020. REVENUES Property Tax A portion of property taxes is allocated to the bond redemption fund to satisfy payments of principal and interest. Under terms of an interlocal agreement, the Greater East Wenatchee Storm Water Utility agreed to pay a portion of the annual debt service payments under terms of the City's Public Works Trust Fund loan described above. Redemption Redemption of long term debt through payments of schedule principal is accomplished for both the General Obligation Bonds and the Public Works Trust Fund Loan. Debt Interest Expense Interest payments on debt are also accomplished in this fund and are included in the debt service amounts reflected above. W CITY OF EAST W ENATCHEE STREET IMPROVEMENTS BOND REDEMPTION FUND 202 BOND/DEBT REDEMPTION FUND 2018 BUDGET- Finance BARS Numbers Description 2012 Actual 2013 Actual 2014 Actual 2015 Actual 2010 Actual 2017 Budget 2017 6 Months 2017 Estimate 2018 Budget $ Change Revenues 202,000.000.308.00.00.00 Beginning NC&I 10,222 5,357 7,491 7,015 9,746 10,723 10,723 1D,723 9,693 (1,030) rotals 10,222 5,357 7,491 7,015 9,746 10,723 10,723 10,723 9,693 Revenue 202.000.000.311.10.00.00 Property Tax 180,000 1 186,000 185,000 185,000 1 20,000 20.000 20,000 20,000 30,000 10.000 202.000.000.338.19.00.00 SWU PWrFL Relmb 12,639 12,523 12,407 12,291 12,175 9,770 9,870 9,870 (9,870) 202.000.000.360.00.49.00 Misc Revenue 202.000,000.361.00.00.00 Interest Earnings - Total Revenue 192,639 197,523 197,407 197,291 32,176 29,77D 29,870 29,670 30,000 130 Resources Available 202,861 202,380 204,898 204,306 41,921 40,493 40,693 40.693 39,693 (900) Expenditures 202.000,000.591.95.7L00 Redemption - GO Bonds 135,000 140,000 160,000 155,000 202.000.000.591.95.71.05 Redemption -PWTF Debt 29,713 29,713 29,712 29,713 29,712 29,712 29,712 29,712 29,712 0 202.000.000.592.95.89.00 Interest Debt 30,118 23,300 16,090 8,214 - - - - 202.000.000.592.95,89.05 Interest- PWTF Loan 2,674 2,377 1 2,080 1 1,634 1,486 1,189 1,189 1,189 $91 (297) Total Expenditures 197,606 195,390 197,882 194,561 1 31,198 30,901 30,901 30,901 30,604 (297) 202.000.000.508.00.00.00 Ending NCBI 5,356 7,490 1 7,015 9,746 1 10,723 1 9,593 9,692 9.691 9.189 (603) Note: The Public Works Trust Fund Loan was previously paid as a capital investment and is now paid appropriately as a debt service payment. The original purpose of the loan was the 11th Street and related Storm Water Improvements. Because of the Storm Water portion of the project, the Greater East Wenatchee Storm Water Utility agreed to pay a portion of the debt service for fifteen of the twenty years of the loan amortization and payment. The last year was 2017. General Obligation Bonds Outstanding are the result of a financing in December 2000 in the total amount of $1,545,000, and paid in full in 2015. 79 2018 BUDGET STREET IMPROVEMENTS FUND Note:. The Street Improvements Fund was established and used by the City to fund and manage capital projects related to streets — streets, curbs, gutters, sidewalks, underground utilities, etc. These projects involve pre -project engineering, construction engineering, purchase of right of ways, road building/paving, curb/gutter/sidewalks and storm drains. Projects are bid and performed by outside engineering and construction companies, and involve coordination with other utility and governmental entity partners. Funding is generally received from either Federal or State sources that involve a variable funding contribution support by the City. Funding through bonded debt has also been a source of funds for the City for these projects in the past. Projects budgeted for 2018 have been selected from the Transportation Improvement Plan (TIP) provided to the Washington State Department of Transportation each June and other projects approved by Council. Projects scheduled for 2018 include: Project Description TBD- Residential Paving Projects South Kentucky Overlay Baker Avenue Highline Drive 5d' Street NE — Baker to Eastmont Relight Washington Project Storm Water Projects Design/Build Gateway Project Fund Transfers Grant City Total Fundine Other Match Cost $ 197,300 $ 197,300 $295,600 $52,100 347,700 77,000 77,000 42,500 42,500 203,800 311,100 514,900 189,400 189,400 233,900 233,900 57,600 372,400 430,000 947,300 947,300 "Other" planned project funding sources are the Transportation Benefit District funds collected from a $20 car tab fee that has been collected for many years. Baker and Highline Street Improvement Projects are near completion and have just finish work in early 2018. 5'h Street NE is a combined storm water, sidewalk and pavement that was only partially complete in 2017. Relight Washington is a LED lighting project to change all city street lighting to longer lasting and more energy efficient LED lighting, in conjunction with Douglas PUD and the State of Washington. Storm Water Projects include two neighborhood improvement projects that have been engineered and are scheduled to be completed in 2018. The Gateway project has matured to a full development stage, with some additional engineering/design for completion in 2018. CITY OF EAST WENATCHEE STREET IMPROVEMENTS FUND 301 STREET IMPROVEMENTS 2018 BUDGET FUND 301 REVENUE 2016 Actual 2017 Budget 2017 11 Months 2017 Estimate 2018 Budget Beginning NC&I 189,123 165,685 510,544 510,544 822,136 Property Tax 4,500 376,000 575,000 575,000 100,000 Transfer lin - From Fund 314 - REET 300,000 200,000 200,000 500,000 Transfer IN -General Fund 1,100,000 1,000,000 Transfer In - TBD - Fund 630 - Res Impv 393,369 114,075 136,489 197,335 EWWD - VMP Grant to 9th 6,575 DCSD - VMP Grant to 9th 3,787 - STP Valley Mall - Grant to 9th - Overlay Construction 747,104 - 56,975 56,975 French Street Improvements- CDBG - French Street Improvements -TAP Funding - Douglas County Regional Sales & Use Tax - French Ave 69,700 - - Baker Ave - 15th to Sand Canyon 20th - TIB 279,876 3,116,692 806,927 1,777,627 804,032 Baker Ave- 15th to Sand Canyon 20th-GEWSWU 630,000 599,159 599,159 18,212 Baker Ave - East Wenatchee Water District 262,000 109,147 115,006 108,881 Baker Ave - Douglas County Sewer District 180,000 71,556 73,320 20,620 Highline Or =- GEWSWU 13,200 13,200 13,200 Highline Drive - Trans Impv Board 1,776,650 1,688,128 1,717,088 234,449 Highline Drive - East Wenatchee Water District 390,000 461,479 451,479 Highline Drive - Douglas County Sewer District 286,000 199,266 199,266 5th St. Sidewalks and Storm Water- CDBG 29,363 260,637 64,933 265,933 5th St. Sidewalks and Storm Water- GEWSWU 125,000 109,565 109,565 15,000 5th St. Sidewalks and Storm Water - EWWD 131,867 5th St. Sidewalks and Storm Water- DCSD 142,714 5th St. Sidewalks and Storm Water -TIB 188,880 11 th St NE and 191h St NE Overlay- TIB 432,579 16,452 163452 5th St NE Pedestrian Faciities- SRTS 50,000 - VMP Traffic Signal Controller- Doug Co. Regional 50,000 - Relight Washington- Installation Relight Washington- Materials South Kentucky Overlay - TIB 58,150 131,250 295,560 Total Current Revenue 2,266,853 7,828,154 6,061,787 7,881,140 2,172,369 Total Resources Available 2,455,977 1 7,993,839 1 6,672,331 8,391,684 2,994,505 81 CITY OF EAST WENATCHEE STREET IMPROVEMENTS FUND 301 STREET IMPROVEMENTS 2018 BUDGET FUND 301 EXPENDITURES Description 2016 Actual 2017 Budget 2017 11 Months 2017 Estimate 2018 Budget French St. Improvement Project - SDC 506 French St. Improvement Project- Consruction 23,525 - Valley Mall - Grant to 9th - Overlay - SDC 50,538 - - - Valley Mall - Grant to 9th - Overlay - Construction 535,879 - - Residential St Improvement Project 393,369 114,075 136,489 j 197,335 Transfer Out to the General Fund 750,000 Baker Ave - Design 272,154 85,000 87,067 87,067 Baker Ave -ROW 56,546 243,000 194,644 196,644 25,000 Baker Ave -Construction 3,149,765 2,567,427 2,923,381 42,000 Baker Ave-SDC 374,100 234,580 365,147 10,000 Baker Ave - East Wenatchee Water District 262,000 183,780 189,639 Baker Ave - Douglas County Sewer District 180,000 127,349 129,113 - 5th St NE Sidewalks and Storm Sewer 32,617 5th St NE Sidewalks and Storm Sewer -Design 43,088 60,070 60,070 5th St NE Sidewalks and Storm Sewer -Construction 568,379 176,154 329,009 474,892 5th St NE Sidewalks and Storm Sewer- SDC 68,206 26,393 40,768 40,000 5th St NE Sidewalks and Storm Sewer- EWWD 177,908 131,867 176,925 5th St NE Sidewalks and Storm Sewer- DCSD 147,704 142,564 146,065 Highline Drive- Design 148,195 109,000 104,348 104,348 Highline Drive- ROW 26,850 138,000 82,272 82,272 Highline Drive- Construction 1,557,080 1,523,911 1,649,571 40,000 Highline Drive- SDC 169,865 164,200 168,000 2,500 Highline Drive- East Wenatchee Water District 390,000 453,810 464,337 Highline Drive- Douglas County Sewer District 379 285,000 287,016 295,703 11th St NE and 19th St NE Overlay- Design 62,801 - 11 th St NE and 19th St NE Overlay- Construction 388,782 - - 11th St NE and 19th St NE Overlay- SDC 47,708 - 5th St NE Pedestrian Fadities- SRTS 50,000 - - VMP Traffic Signal Controller 60,000 15,007 25,000 Relight Washington- Design Relight Washington- Installation Relight Washington- Materials South Kentucky Overlay Total Expenditures 0 0 5,000 0 0 53,150 0 0 131,250 347,718 2,039,850 8,162,169 6,562,459 7,569,548 2,118,845 Ending NC&I 416,127 (168,330) 9,872 822,136 875,660 2018 BUDGET STORM WATER IMROVEMENTS FUND Note: The City of East Wenatchee has the responsibility to provide maintenance and manage construction projects for Storm Water Activities utilizing street department labor and equipment resources, or in some cases with capital projects, use of outside vendors. This work is reimbursed at cost under terms of an interlocal agreement between the City and the Greater East Wenatchee Storm Water Utility (GEWSWU), whereby the GEWSWU charges an annual fee of $45.00 to City and County residents in the local service area for each impervious unit of space, generally a residential lot. This rate was $35.00 in 2009, and was raised $5.00 each year in 2010 and 2011 through a combined vote of the City of East Wenatchee and the Douglas County Councils. The GEWSWU fund is used to comply with the Federal National Pollutant Discharge Elimination System (NPDES) regulations related to Storm Water discharge and treatment and to fund both small storm water improvement projects and large Capital Improvement projects identified in the GEWSWU Comprehensive Plan. The City's storm water fee paid to the GEWSWU for its impervious surfaces (streets, City Hall property, City parking lots, etc.) increased from $114,000 in 2009 to $130,000 in 2010, to $149,000 in 2011, and $147,000 in 2012, 2013 and 2014. Absent an action by the GEWSWU, the fee is budgeted at that same amount for 2016. The GEWSWU jointly annually establishes the need and amount for maintenance and capital projects, and provides the resources on a reimbursement basis for the City's costs in providing those maintenance and capital services as described above. The City and the County have also applied for and received individual and joint grants, primarily from the State Department of Ecology, to assist in compliance with the NPDES regulations. The City and Douglas County each select a three member management team. Douglas County is represented by a County Commissioner, County Engineer and the TLS Administrator. The City is represented by the City Engineer, the Land and Water Resource Program Manager, and a City Councilmember. This management team administers day-to-day operations and makes recommendations for policies, procedures and budgets. This framework was developed thru an inter -local agreement to provide the necessary collaboration and coordination to successfully manage, maintain and extend the storm water system throughout its service area. Capital Proiects scheduled for 2018 include: Proiect Description Small Improvement Projects Ashland Ave Storm Project Astor Ct Storm Project 19th St NW Storm Project Grant GEWSWU CitV Fundine Match $125,000 $5,000 $58,000 $58,000 Other Total Cost $5,000 $58,000 $58,000 $125,000 The Ashland Avenue and Astor Court stormwater capital projects will alleviate chronic flooding issues through the construction of stormwater conveyance and treatment systems for each problem area. These noted problem areas have a history of experiencing flooding that has damaged personal property (e.g., basement and yard flooding, swimming pool damage). The 19th St NW stormwater project consists of designing a stormwater treatment facility for the entire 19th St NW corridor. This design project is grant funded through Ecology at 100% ($250,000) with the expectation of taking two years to complete the project (2018 $125,000, 2019 $125,000). 83 CITY OF EAST WENATCHEE STORM WATER CAPITAL IMPV FUND REVENUE CITY STORM WATER CAPITAL IMPROVEMENT FUND 2018 BUDGET WORKSHEET- Department Head - City Engineer BARS Numt,ere Description 2012 Actual 1 2013 Actual 2014 Actual 2015 2016 Actual Actual 2017 8u001 2017 7M0n/he 2017 Estimate 2018 Budget $ Change 308.000.000.397.21,00.20 1 Tran s(er in From General Fund 111/2015/Be Funtl Balance 102155 102,154 99,605 99,605 232,420 REVENUE IMPROVEMENT PROJECTS 308.000.000.343,13.00.30 Improvement Projects Total 87075 49,343 99,811 38,766 37,810 5,000 5,000 5,000 CONSTRUCTION PROJECTS: Transfer in - General Fund 225,000 308.000.000.343.13.00.33 WdSWP Decent Facility 10,651 308.000.000.343.13.00.34 19th St Prop Purchase -Pond 155,600 050.000.000.343.13.00.35 SWU Eastmont Design 6,891 253 050.000.000,343.13.00.37 SWU Eastmont SDC 050.000.000.343.13,00.39 SWU Eastmont Construction 381 276 050.000.000.343.13.00.49 Cn n A SDC Phase 3 37,333 2,105 050.000,000,343.13.00.50 Canyon A Constr Phase 3 332,286 184,200 050.000.000.343.13.00.52 Canyon A Constr Phase 4 123,297 1,471 308.000.000.343.13.00.61 DOE Retrofit 3rd Street Project Cont25,679 84,912 308.000.000.343.13.00,63 GEWSWU Retrofit 3rd Street Project 26,206 050.000.000.343.13.00.67 Grant Road PIph, Rehab 13,259 79,355 308,000.000.343.13.00.85 DOE Grunt - LID Pro' Design 33,578 308.000,000.343.13,00.86 DOE Grant- Construct LlD Pro ect 75% 86,422 334 393,664 308,000.000.343, 13.00.88 GEWSWU Reimb LID Proect 25% 2,132 129,269 4,502 4,500 4,500 308.000.000.343.13.00.90 French Avenue SWU 308.000.000.343.13.00.92 DC Regional Sh - VMP LID SWA Pro act from Funtl201 60,950 60,000 50,000 308.000.000.343.13,00.83 19th St NW Design 125,000 125,000 308.000,000.343.13.00.69 GEWSWU Dolfay Lane Project 149231 GEWSWU Denis Ct Project 4647 51,203 51,203 GEWSWU 7th St HE Proect 8338 83.952 83.952 GEWSWU Astor Ct 65,000 267 10,400 58,000 47,600 GEWSWU Ashland Ave 65,000 267 10,400 56,000 47.600 Total 376,510 691,131 293,061 226,517 908,150 190,950 140,191 210,455 241,000 30,545 TOTAL STORM WATER UTILITY REVENUES 463,585 740,474 1 392,892 1 265,283 1 945,959 195.950 140,191 210.455 246,000 1 35,545. TOTAL FUNDS AVAILABLE 265,2831,048,114 298,106 1 239,796 310,060 478,4201 35,545 •i i CITY OF EAST W ENATCHEE STORM WATER ACTIVITIES - EXPENDITURES 2018 BUDGET WORKSHEET - Department Head - City Engineer BARS Numbers Description T011 Actual 2013 2014 2015 2018 Actual Actual Actual Actual 2017 Budget 2017 9Months 2017 Estimate 2018 Budget FUNDS AVAILABLE 265,283 1,048,114 298,104 239,796 310,060 478,420 COSTS & EXPENSES SWU Ca ital/Construction 308,000.312.595.41.63.00 Small Improvement Prcj 40,464 121,964 53,662 9,038 18,162 5,000 5,000 308. 000,315.595,33.32.00. 1 Bin St SWU Property - Pond 155,600 - 050,000, 312.595,41.63.05 3rd St SWU Retrofit Engr 2,905 17,100 - - 308.000.312.595.41.63.07 3rd St SWU Retrofit Consir 15,313 89,831 0 0 308,000.312. 595,41,63.09 3rd St SWU Retrofit SDC 11,274 0 0 050.000.312,595.41.63.16 SWU Easlmont Construction 381,245 050.000.312.595.41.63.21 Grant Road Pipe Lining Engr 18,285 19,201 1,654 050.000.312.595.41.63.23 Grant Road Pipe Lining 71,769 050.000.312.595.40.35.00 Cnyn A SDC Phase 166 050.000.312.595.40.63.15 CnynA Consir Phase 2 177 - 050,000.312.531.32. 01.05 CnynA Din Phase 3 2,421 050.000.312.595.40.25.00 Cnyn A SDC Phase 3 26,710 14.113 050.000. 312.595.40,35.00 Cnyn A Consir Phase 3 333,908 242,227 050D00.312.595A0,15-17 Cnyn A SDC Phase 5,454 - - 050,000.312,595.4063.28 Cnyn A Consir Phase 4 124,731 - 308.000.312, 595.42, 10.00 Salaries -Impv Prioj 3,576 2,553 8,000 308,000.312595.42.20,00 Benefits -Impv Praj 2,260 787 4,600 308.000,312.595,43.63.05 WVSWP Decant Facility 10,651 308CM312.595.43.63.10 VMP LID Proj (Design) 92,349 51,332 13,070 - - 308.000.312.59543.63.14 VMP LID Proj (construct) 567,982 308,000.312292.4363.12 VMP LID Proj (SDC) 49,698 VMP LID Landscapipng 56,622 49,840 49,840 308,000.314.595,40.10,00 Salaries- Dolfay Lane Project 927 308.000.314,595.40.20.00 Benefits- Dolfay Lane Project 560 308.000,314.595.40.63.00 ROW- Colley Lane Pmject 376 308.000.314.595.40.63. 10 SDC- Dottay Lane Project 16,087 308.000.314.595.40.63.15 Construction - Dolfay Lane Prj 129,835 308. 000.315,595.40, 10,00 Salaries- Denis Court Project 470 308,000.315.59540.20. 00 Benefits- Denis Court Project 246 308.000.315.595.40,63.29 Engineering - Denis Court Project 4,160 308.000,315.595.40.63.33 SDC- Denis Court Project 5,586 464 500 308C00.315.595.40E&35 Construction - Denis Court PO 46,068 308.000.000.595.4063,39 19th NW SW Design - 125.000 308.000,316.595.40, 10, 00 Salaries - An St NE Project 497 308.000.316.595.40.20.00 Benefits -7th St NE Project 270 308.000.316.595.40.63.29 Engineering -7th St NE Project 6,240 308.000.316.595.40:53.33 SDC - 7th St NE Project 1,170 80 100 Construction -7th St NE Project 78,275 - - 85 CITY OF EAST WENATCHEE WATER ACTIVITIES - EXPENDITURES BARS CITY STORM WATER CAPITAL IMPROVEMENT FUND (continued) 2012 1 2013 1 2014 1 2015 2018 2017 2017 1 2017 2018 Salaries -Astor Ct Project 1,000 157 500 600 Benefits -Astor Ct Project 576 32 100 250 Engineering - Astor Ct Project 8,000 10,395 10,500 SEC -Astor Ct Project 11,000 2,600 4,500 Constmction -Astor Ct Project 45,000 52,000 Salaries- Ashland Ave Project 1,000 157 Soo 500 Benefits- Ashland Ave Project 575 32 100 250 Engineering - Ashland Ave Prj 8,000L710, 10,600 SEC -Ashland Ave Project 11,0002,500 4,600 Constmction - Ashland Ave Prj 45,000 52,000 Total Construction Expenditures 414,793 921,126 420,222 163,129 94$509 205,372 77,640 244,600 ENDING FUND BALANCE 102,754 99,605 92,732 166,244 232,420 233,920 LR 2018 BUDGET CAPITAL IMPROVEMENTS FUND Note: Capital Improvements for this fund are specifically provided by receipts of Real Estate Excise Taxes paid by the seller in real estate transactions within City boundaries. These taxes are generally limited to expenditures for capital improvements of streets and roadways; and other uses when the City provides for authorization in a capital facilities plan. REVENUES Real Estate Excise Tax Real Estate Excise Tax from real estate transactions for 2017, as well as accumulated REET from prior years will be used to satisfy the City matching responsibilities for Federal and State Grants for qualified street improvement projects, as well as those qualified capital improvement projects or purchases without grant funding. Property Tax Property taxes for 2017 Street Improvement Projects were required to supplement REET monies described above. As noted on the following schedule, $150,000 had been allocated for that purpose in 2017. The Property Tax apportionment for 2018 is budgeted to be $350,000. Gateway Project: In 2015, the City budgeted $450,000 for the purchase and subsequent initial design of business property at the corner of 9ch and Valley Mall Parkway. The property purchase was consummated on September 30, 2015. Subsequently, the City embarked upon an extensive public outreach program to determine the eventual "best use" of the property. That outreach program was completed in 2017 resulting in a conceptual design. The project is currently near the completion of design engineering, and is expected to be constructed during 2018. Public Works Facilities Upgrade: After a facilities study undertaken in 2016, the City has determined that an upgrade to the public works area of the City Hall property is necessary, including replacing certain buildings and providing for additional new facilities. The City hired an architectural firm to design and develop a multi -year staged construction plan. That design process is nearly complete. The City expects to consider funding resources and the periods of construction when the design aspects and adequacy have been studied and vetted. d CITY OF EAST W ENATCHEE CAPITAL IMPROVEMENT FUND 314 CAPITAL IMPROVEMENTS FUND 2018 BUDGET BARS Numbers Oemdnon 2012 Actual 2013 Actual 2014 AbroadActual 2015 2010 Actual 2017 sued. 2017 if Monrhs 2017 ESUMM 2018 Budgal Revenue 314.000.000.308.00.00.00 Beginning NOW 889,153 558,805 611,146 574,459 512,900 919,200 $13,698 613,698 424011 Toots 889,158 558.805 511,146 574,439 519,200 919,200 613.698 613,698 424,81111 314.000.000.317,34.00.00 Real Estate Exdse Tax 175.647 262,341 321,364 351,899 324,672 248,500 340,328 348,200 337,100 314.000.000.333. 10.00.00 Reglonal Fund Sham - Gateway - 57,014 57.614 314 G1000,311.10,00. 0 Property Tax 19t,000 75,000 350,000 90,000 150,000 350.M 314.000.000295.00.00.10 ROWWSDOT-Sellar Sddge Proles 30,000 314.000.000,33330.00.00 Viewpoint Mitigation- MOOT 29,753 - 314.000.000.361.00.00.00 Interest Eaminga 15.855 - 9 Total. Rename 175.647 452,341 396,482 351,899 399,681 856,114 430,328 498,200 744,714 Tool Resources Available 1,064,80E 1,011,146 907,628 926,358 918.881 1,676,E14 1,W,D26 1,109.598 1.169.612 ExIMnMuru 314 000 000ES7.95.00.20 FEET to Fund 301- 80,000 500,000 300.000 20Q000 200,000 500,000 - 314.000.000.595. 1081.46 Stormont Ave- Grant Road to 3M Design 314,000 314.000.000.595.30.60.49 9th Street Preservation 7,000 - - 314000000.595.30.60.51 15th SbeM Preservation 6,000 314.000.000E94.20.00.20 Streat Dept Storage Building& Improvements 6,194 400,000 78,396 100,000 22,000 314,000.000,594.22.60.32 Property South of 15th St NE. IC82-09-2030 159,084 - - 314,000.000.594.22,30.34 Property South of 15th St NE. IC402-0 2030 170,DS5 314.000000.594.22.W.40 Gateway Property Pumha3e & Dealgn 4,000 407,158 see,000 20,796 $5,000 430,000 To MIS Expendnuros 407,000 500,00 333,162 407,158 305,184 1,000,000 299,192 $86,000 462,000 31d000.000.503.00.00.00 Ending NC&I 657,805 511,148 574,459 1 519,200 613,698 575,314 7461134 434,898 Ti L6II Note: The Gateway spend in 2017 Includes$100,000 for demolition and$60,000 for design (total contract of$80,000). About$15,DD0 was spent on the concept design. The Gateway spend in 2018 includes $20,000 to complete the design and $320,000 to construct the project. 88 EE Change (189,9Dt) (2,100) 57,514 assists 243,514 52,714 (500,000) (78,000) 345,000 NOTE 292,714 2018 BUDGET EQUIPMENT PURCHASE, MAINTENANCE & REPLACEMENT FUND "(EPM&R") STREET, POLICE & ADMIN DEPARTMENT VEHICLES AND EQUIPMENT The City Council established this Fund in 2011 as the Street Fund ER&R Fund. Because the City does not have or need the traditional rental environment of larger entities, this fund's purpose is for the purchase, maintenance and replacement of vehicles and equipment primarly for both the Public Works Department and the Police Department. Sales taxes will be the primary revenue allocation for funding, as well as the Criminal Justice Fund for funding assistance for the purchase of police vehicles. REVENUE & EXPENSE The Budget Committee has recommended the transfer of funds and related expenditures to accomplish the purchase of three police vehicles in 2015, one of which would have otherwise been purchased in the Criminal Justice Fund and the other two in the General Fund Law Enforcement Department. In addition, this fund will receive funding to allow for the estimated maintenance costs for the police department fleet of vehicles. The Police Chief has identified and inventoried all police vehicles, has stratified them as to use and annual mileage factors, for the purpose of establishing a multi -year purchase and maintenance cost funding strategy. 2015 was the first year to initiate funding for this longer term strategy. Four police vehicles were purchased in 2016, four vehicles in 2017 and two are scheduled for purchase in 2018. The City Engineer made an assessment of the Street Department equipment and rolling stock to determine the current and future needs for additional and/or replacement equipment or vehicles, and the associated annual maintenance costs. Upon completion of that analysis, a multi -year funding strategy will be developed and considered for funding approval by the Budget Committee and the City Council. Two snow plow vehicles were purchased in late 2015 and fully equipped in early 2016. A new paint striper was purchased in 2016 and one snow plow vehicle was purchased in 2016. One multi - purposed street department truck was purchased and outfitted in 2017. Additional street department equipment is scheduled for purchase in 2018. CITY OF EAST WENATCHEE E,P,M&R Fund #501 Equipment Purchase, Maintenance & Replacement Fund 2018 BUDGET BARS Numbers Description 2015 Actual 2016 Actual 2017 Budget 2017 9Months 2017 Est Actual 2018 Budget $$ Change Revenues 501.000,000.308.00.00.00 Beginning NC&I 7,331 38,861 47,773 47,778 47,778 40.372 (6,906) Totals 7,331 38,861 47,778 47,778 47,778 40,872 (6,906) 501.000.000.313,11.00.10 Sales & Use Tax - Police Dept 120,000 200,000 127,000 127,000 127,000 150,000 23,000 501.000.000.313.11.00.20 Sales & Use Tax - Street Dept 191,000 207,000 150,000 1253000 174,000 200,000 26,000 501.000.000.313.11.00.30 Sales &Use Tax -Admin 27,300 501.000.000.397.21.00.20 Transfer In - Criminal Justice 40,000 43,000 43,000 43,000 (43,000) 501.000.000.369.90.50.00 Miscellaneous Revenue 1,318 - - Total Revenue 351,000 435,618 320,000 295,000 344,000 350,000 6,000 Resources Available 358,331 474,479 367,778 342,778 391,778 390,872 (906) Expenditures 501,000.000.521, 10. 10.00 Police Vehicle R&M Labor 14,505 4,735 6,000 3,234 4,800 6,000 1,200 501.000.000.521. 10.20.00 Police Vehicle R&M Benefits 1,679 2,364 3,000 2,053 2,400 3,000 600 501,000.000.521.10.48.00 Police Vehicle Repairs & Maint 16,332 29,649 35,000 23,195 28,000 32,000 4,000 Police Vehicle Maintenance 32,516 36,748 44,000 28,482 35,200 41,000 5,800 501.000.000.542.90.10.00 Street Vehicle R&M Labor 10,603 16,634 10,000 16,642 22,000 25,000 3,000 501.000.000,542.90.20.00 Street Vehicle R&M Benefits 5,796 8,190 6.500 9.683 13,500 15,000 1,500 501.000.000.542.90.48.20 Street Vehicle. Repairs & Maint 19,233 37,653 30,000 22,758 35,000 35,000 601.000.000.542.90.48.25 Street Vehicle Repair & Maint Supplies 4,430 5,578 6,000 3,485 4,700 4,000 (700) 501,000.000.542.90,48.30 Street Equipment Repairs & Maint 1,016 2,000 767 1,000 2,000 1,000 501.000.000.558.10.48.00 Admin Vehicle. Repair & Maintenance 100 1,000 6 6 1,000 994 Street Vehicle/EquipMaint 40,062 69,171 55,500 $3,341 76,206 82,000 5,794 501.000.000.594.21..60.00 Capital Outlay - Police Vehicles 120,000 167,097 129,000 129,562 130,000 98,000 (32,000) 501.000.000.594.42.60.20 Capital - Street Vehicles 124,900 89,457 96,500 96,500 80,000 (163500) 501.000.000,594.42.60.30 Capital- Street Equipment 1,993 39,634 13,500 13.000 40,000 27000 501.000.000.594.44.60.20 Capital -Admin Vehicles 24,594 Capital Outlay - Vehicles&Equip 246,893 320,782 239,000 129,562 239,500 218,000 (21,500) Tota/Expenditures 319,470 426,701 338,500 211,385 350,906 341,000 (93906) Ending NC&I 38,861 1 47,778 29,278 131,393 40,872 49,872 9,000 Added $100,000 to 2015 Street Vehicles Budget thru Amendment to allow for purchase of 2 snowplows. Added additional sales tax funding in the same amount to fund the purchase. Note: Three Police Vehicles were purchased during 2015, one funded with criminal justice funds and two with sales tax funds. Four police vehicles are budgeted for purchase in 2016 with sales tax funding. One Snow Plow Trucks (Street Vehicle) and one Paint Striper (Street Equipment) are budgeted for purchase in 2016. One Admin Vehicle(Planning) will be purchased in 2016. Budget Amendments April 2016 added amounts for the snow plow blades from 2015 and additional amounts for police & admin car purchases. The 2017 Budget includes 3 police vehicles, a street vehicle budget of $90,000, including a Kubota Side -by-side and more yet to be specifically identified, and a placeholder of $20,000 for street equipment, yet to be identified. 90