Loading...
HomeMy WebLinkAbout2012 - Final Budget - Nick A GerdeCi of East Wenatchee, Washington 2012 Annual Financial Budget M— Steven C. Lacy Councilmembers Frank Collings Harry Raab Chuck Johnson George Buckner Sandra McCourt Timothy Detering Wayne Barnhart Finance Director Nick A. Gerde 2012 FINANCIAL BUDGET TABLE OF CONTENTS PAGE TITLE PAGE - 2012 FINANCIAL BUDGET ........................................: 1 TABLE OF CONTENTS...............................................................i &ii 2012 BUDGET COMMITTEE...........................................................: 2 ELECTED OFFICIALS...................................................................: 3 APPOINTED OFFICIALS.................................................................: 4 ACCOUNTING POLICY AND FUND STRUCTURE ..............................: 5 BUDGET ASSUMPTIONS AND HIGHLIGHTS..................................6-9 - SUMMARY FINANCIAL INFORMATION.................................10 -17 - HIGH LEVEL CASH FLOW SUMMARY (10) - CASH FLOW -MAJOR SOURCES OF REVENUE AND - CASH FLOW - MAJOR EXPENDITURE AREAS (11) - CASH FLOW BY FUND (12) - PROPOSED REVENUE SOURCES (13-14) - PROPOSED EXPENDITURES (15-16) GENERAL FUND REVENUE.....................................................17 - 23 (A NARRATIVE FOLLOWED BY FINANCIAL SCHEDULES) GENERAL FUND EXPENDITURES............................................24 - 27 (A NARRATIVE FOLLOWED BY FINANCIAL SCHEDULES) GENERAL FUND DEPARTMENT DETAIL .................................... (A NARRATIVE FOLLOWED BY A FINANCIAL SCHEDULES) GENERAL GOVERNMENT....................................................28 - 30 LEGISLATIVE....................................................................31- 32 MUNICIPAL COURT..........................................................33 - 34 CITYCLERK.......................................................................35 - 36 FINANCE.............................................................................37 - 38 INFORMATION TECHNOLOGY............................................39 - 40 INTERNAL SERVICES........................................................ ..41- 42 LEGAL................................................................................43 - 44 CITY ENGINEER..................................................................45 - 46 CIVIL SERVICE.....................................................................47 - 48 CENTRAL SERVICES.............................................................49 - 50 LAW ENFORCEMENT........................................................... 51- 56 PLANNING..........................................................................57 - 58 CODE COMPLIANCE............................................................59 - 60 STORM WATER UTILITY.......................................................61 - 65 STREETFUND........................................................................ 66 - 69 COMMUNITY DEVELOPMENT GRANTS FUND ...........................70 - 71 LIBRARYFUND.......................................................................72 - 73 HOTEL/MOTEL TAX FUND ....................................................... 74 - 75 DRUGFUND...................................................................................................76 - 77 CRIMINAL JUSTICE FUND.........................................................................78- 79 EAST WENATCHEE EVENTS BOARD FUND.........................................80 - 83 BOND REDEMPTION FUND..............................................................84 - 85 STREET IMPROVEMENTS FUND.............................................................86 - 91 CAPITAL IMPROVEMENTS FUND...............................................92 - 94 EQUIPMENT RENTAL & REPLACEMENT FUND...............................95 11 City of East Wenatchee, Washington 2012 Budget Committee Mayor Steven C. Lacy Councilmember David Bremmer Councilmember Chuck Johnson Councilmember Sandra McCourt Finance Director Nick A. Gerde ba East Wenatchee City Officials Elected Officials Mayor Steven C. Lacy, Four year term, expiring 12/31/15 Councilmembers Position Number One Frank Collings, Four year term, expiring 12/31/15 Position Number Two Harry Raab, Four year term, expiring 12/31/15 Position Number Three Chuck Johnson, Four year term, expiring 12/31/13 Position Number Four George Buckner, Four year term, expiring 12/31/13 Position Number Five Sandra McCourt, Four year term, expiring 12/31/15 Position Number Six Timothy Detering, Four year term, expiring 12/31/15 Position Number Seven Wayne Barnhart, Four year term, expiring 12/31/13 3 East Wenatchee City Officials Appointed Officials City Attorney Devin Poulson City Treasurer/Finance Director Nick A. Gerde Police Chief Randy Harrison City Clerk Dana Barnard City Engineer Donald McGahuey Community Development Director Lorraine Barnett Code Compliance Officer Jeffrey Morrison Events Department Coordinator Open Position Municipal Court Judge Chancey Crowell 0 City of East Wenatchee, Washington 2012 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, 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. 5 CITY OF EAST WENATCHEE, WASHINGTON 2012 FINANCIAL BUDGET 2012 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. Departmental costs are the responsibility of each Department Director. All other costs are the responsibility of the Finance Director. Primary revenue estimates for 2012 include: 1. Fourteen sources of revenue for the City represent over 94% of the estimated revenue for 2012. They include: Percent Amount of Total A. Sales and Use Tax $2,625,000 24.3% B. Property Tax 1,534,200 14.2% C. Storm Water Utility 191609300 10.7% D. Utility Taxes 7879000 7.3% E. Fines & Penalties — Court 360,000 3.3% F. State Portion — Court Revenue 35000 3.3% G. Gambling Tax 275,000 2.5% H. Street Fuel Excise Tax 2609000 2.4% I. Community Development Grant 2019500 1.9% J. Real Estate Excise Tax 200,000 1.9% K. Liquor Taxes 153,000 1.4% L. Criminal Justice Taxes 1301000 1.2% M. Hotel/Motel Taxes 1175500 1.1 % N. Balance of Revenue Estimate 596,900 5.5% Sub -total Operational Revenue 8,750,400 80.9% O. Street Improvement Projects 2,059,600 19.1% Total 2012 Revenue Estimate $10,810,000 100% 6 2012 BUDGET ASSUMPTIONS AND HIGHLIGHTS (continued) 2. Each revenue source was evaluated in consideration of a six year receipt history, or shorter in the case of utility taxes and street improvements/capital projects. 3. Monthly trends over the last four years and the nine months of 2012 were studied, particularly in light of recent negative economic trends, experience by other cities in our region, and the continuing recession. Primary expenditure budget assumptions for 2012 costs included the following: l . 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. 3. The City currently has fifty-one 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 and three part-time employees. 4. The City Attorney, City Engineer and Municipal Court Judge are compensated according to employment agreements. 5. The collective bargaining unit agreements with the police department unions covering twenty-two employees expired on December 31, 2010 and are in the negotiation process. 2012 wage and benefit costs have been estimated based upon the City's current offer to those unions. 7 2012 BUDGET ASSUMPTIONS AND HIGHLIGHTS continued 6. The collective bargaining unit agreement with Local 846-W was negotiated during 2011 for the three year period of 2011, 2012 and 2013. This agreement covers fifteen employees in the Street, Planning, Code, Court, City Clerk and Events Departments. 2012 wage and benefit costs have been estimated based upon the terms of that agreement. 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 expenditure categories for 2012 include: A. Labor Costs B. Benefit Costs C. Municipal Court to State D. Dept Capital Expense E. Rivercom 9-1-1 F. Jail Services — Detention Amount $ 351299500 1,484,600 350,000 3199000 267,123 G. Debt Service -Principal & Interest H. Storm Water Utility Charge 280,000 1989413 1499400 I. Storm Water Utility Capital 811,000 J. Street Improvements Capital 294345589 K. Balance of Expenditures 1,512,975 Budgeted Expenditures 2012 $10,936,600 0 Percent of Total 28.6% 13.6% 3.2% 2.9% 2.4% 2.5% 1.8% 1.4% 7.4% 22.3% 13.8% 100% 2012 BUDGET ASSUMPTIONS AND HIGHLIGHTS continued Primary assumptions for capital costs for street preservation projects, intersection signal lighting and street reconstruction projects, include the following: 1. The principal source for these 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. 2. Projects were selected from the TIP based upon an assessment of the highest needs in the City for the 2012 budget year, and for each year from 2013 thru 2017 for the cash flow forecast. Consideration was also given for the total number of projects which the City could effectively manage during any given year. 3. The City received grant funding for five projects which have been specifically scheduled for work and/or completion in 2012. These projects and their funding requirements include: Grant City Project Description Fundiniz Match Total Grant Rd Overlay-Ph2 90010 124,979 991,726 Loop Trail Enhancement 131,000 2000 151,000 Eastmont Design/ROW 278,000 429000 3209000 9th Street Preservation 500,000 1169000 616,000 15th Street Preservation 250,000 102,000 352,000 Total 2,059,610 404,979 2,464,589 Please note that the Eastmont Street Rebuild has total grant availability of $2,330,000 of which $250,000 is scheduled to be spent in 2012, with construction scheduled for 2013. The total estimated City Match for these projects of $404,979 will be funded from Real Estate Excise Taxes, $200,000 of which is estimated revenue for 2012 and the balance is available from previous years' accumulation of reserves. 9 City of East Wenatchee, Washington 2012 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 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 Summary and in Detail, as follows: 1. High Level Cash Flow Summary 2. Cash Flow by Categories of Revenue and Expenditures. Summarized Cash Flow: High Level Summary Cash Balances, Beginning of the Year Revenues 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 2011 2011 2012 Estimated Budget Budget Actual As Amended $ 2,357,232 $ 2,043,567 $ 1,971,000 10,443,651 366,350 7,615,596 353,764 9,902,196 405,350 10, 810, 001 7,969,360 10, 307, 546 13,167,233 10,012,927 12,278,546 10,566,213 370,400 7,214,398 10,034,882 441,297 448,400 10,936,613 7,655,695 10,483,282 $ 2,230,620 $ 2,357,232 $ 1,795,264 NOTE: 1. 2011 Budget Amendments have been drafted and will change the 2011 Budget when approved by the City Council. The Finance Department has updated the estimated actual results for 2011 based upon the most recent financial statements. 3. The primary reason for the reduced revenue and expense for 2011 in comparison to budget is the delay capital project work. The phase II Grant Road Overlay Project, the Loop Trail Enhancement Project and the final phase of Canyon A Storm Water Utility System were originally scheduled for completion in 2011 and have now been re -scheduled for 2012. W1 Summarized Cash Flow: By Maior Revenue and Expense Categories 2011 2011 Maior Revenue Sources Cash Balances, Beginning of the Year Revenues Received Sales & Use Taxes Property Taxes - 2009 Base Property Taxes - Add'I 1 % Real Estate Excise Tax Municipal Court Receipts - Fines Gambling Tax Receipts 6% Utility Tax - Natural Gas - New 6% Utility Tax - Electricity - New 6% Utility Tax - Telephones/Cells - New Street Fuel Excise Tax Funding for Street Improvements Storm Water Utility Capital Reimbursed Other Revenues Total Revenues Non -Revenues Received Court Receipts for the State Other Non -Revenue Total Non -Revenues Grand Total Revenues Total Resources Available (Cash plus Revenue) Expenditures Payroll Costs Employee Benefit Costs Debt Service Principal & Interest Capital Expenses Storm Water Utility Charge Jail Services - Adult Detention Rivercom 911 Hotel/Motel Tax to Others Street Improvements Expenditures Storm Water Utility Capital Expenditures Other Expenditures Total Expenditures Non -Expenditures Municipal Court Receipts for the State Sales Taxes - Kentucky Annexation Kentucky Annexation Debt Repayment Other Non -Expenditures Total Non -Expenditures Grand Total Expenditures Cash Balances, End of the Year 2012 Estimated Budget Budget Actual As Amended $ 2,357,232 $ 2,043,567 $ 1,971,000 2,625,000 2,708,000 2,520,000 1,516,600 1,512, 000 1,512,000 200,000 200,000 145,000 360,000 340,000 375,000 275,000 255,000 260,000 42,000 42,000 40,000 305,000 305,000 294,000 440,000 450,000 435,000 260,000 260,000 245,000 2,059,600 30,000 588,000 815,000 100,000 2,007,000 1,545,451 1,413,596 1,481,200 10,443,651 7,615,596 9,902,200 350,000 340,000 391,000 16,350 13,764 14,350 366,350 353,764 405,350 10,810,001 7, 969, 360 10,307,550 13,167,233 10,012,927 12,278,550 3,129,500 3,107,000 3,145,000 1,484,600 1,290,000 1,275,000 198,413 199,713 199,700 319,000 328,471 433,900 149,400 148,725 149,400 280,000 240,000 220,000 267,123 285,900 285,900 47,000 47,762 51,000 2,464,589 39,000 596,000 815,000 237,200 2,007,000 1,411,588 1,290,627 1,672,000 10,566,213 7,214,398 10,034,900 350,000 355,000 360,000 - 15,755 10,000 - 55,287 56,000 20,400 15,255 22,400 370,400 441,297 448,400 10,936,613 7,655,695 10,483,300 $ 2,230,620 $ 2,357,232 $ 1,795,250 11 inw N It N It fq m N N w 00 N N n U d Ol ei M 00 O N O m '6 10 N cn N N a N C1 M N 10 f�0 m M M a -I C N W N e'i W O OC1 d JI L M C O Z rn O M OOOOON* ' 14 i Ln N 14 O Ln O O O M d O cn O 00 N 14 O M M N C01 A .a_3+ N C O) Ln d x W co 01 AO O N O 0^0 O N M M N i N o0 O O tea N M 0^0 O N ar oc a O0 GC O I— M W � aI to to 0 Q OC M O m Z N M M O � O O O N rn W 3 w OI C W N O M d N 000 m Q j Or Ln ei G1 O d 14 N n M 00 00 M N W u C N O O 0 O c LNR n HI O O N O M N of tf1 t0 t0 01 10 U CO Md r.j O1 m a-1 Ln N toM M OMO tOo N d tD d ' ' w n M WV e0i � 00 N Do 0l � M N N M M Lr LA a' n m M O M N 14 N M cb O O -t N 00 N N M d0 M O M M M Lr�d N qr co d 00 1-4 N I I M31 M Q r'I M N � M C Y u LL E LL c a 4- � Q a0+ gL N O M N M N O M O 1 c. N C C y C ri a 7 H ai r'I t0 N m V C M 7 N U.Ln p G 41 �• C N C LL F � LL O 3 C UL L O W C UUJ C 0) r N LL L.L C C m c E O: E w O w O L ~ (� ' i �' C 0) r'1 H M LO c LL $ O O O ++ L CI 0) C i+ G i LL C C tA y N to i O O) L 7 rr u. H U 2 G U Lu m Vf L7 W H City of East Wenatchee, Washington 2012 Final Budget Worksheet - Revenues 2012 Overview Revenue Sources for the 2012 Budget: Estimated Actual 2009 Actual 2010 Actual 2011 Budget 2012 Property Taxes - General Fund 1,095,185 1,092,570 1,062,000 1,139,150 Property Taxes - Street Fund 200,000 200,000 2001000 200,000 Property Taxes - Debt Service 200,000 201,100 180,000 180,000 Property Taxes - Street Improvements 15,119 Property Taxes - Capital Improvements 70,000 Sales Taxes - General Fund 2,364,700 2,089,623 2,350,000 2,306,000 Sales Taxes - Street Fund 469,064 425,000 250,000 250,000 Sales Taxes - Events Fund 20,000 135,800 108,000 69,000 (A) Utility Taxes 561,777 744,423 797,000 787,000 (B) Gambling Taxes 256,075 249,312 305,000 290,000 Criminal Justice Revenue 167,090 133,320 160,000 130,000 Business Licenses 47,719 51,116 53,000 53,000 PUD Privilege Tax 34,101 37,085 37,571 38,000 Franchise Fees 95,393 91,925 89,000 90,000 Liquor Board Profits & Tax 136,152 151,046 156,000 153,000 Storm Water Utility Funding 630,494 183,352 4371200 1,160,345 (E) Court Fines and Penalties 377,971 375,628 340,000 360,000 Pass through Revenues 432,154 431,645 353,630 366,350 Street Fuel Excise Tax 251,701 252,553 260,000 260,000 Community Development Grant., 28,199 - 24,329 201,478 Hotel/Motel Taxes - Pass througl 78,283 79,599 46,463 36,000 (F) Hotel/Motel Taxes - Events Dept 52,189 55,872 55,000 70,500 (F) Events Dept - Participation 50,344 214,151 89,974 41,350 (A) Criminal Justice Revenue 38,942 43,572 27,150 27,250 Street Improvements Revenue 295,182 102,871 - 2,074,729 (G) Real Estate Excise Taxes 170,370 212,000 200,000 Capital Projects Revenue 616,278 - - - (G) Other Revenue 86,890 227,018 306,043 311,730 $ 8,585,883 $ 7,738,951 $ 7,969,360 $ 00,810,001 (A) 2009 was the first year that the City supplemented the Events Fund with sales tax revenue. In 2010, additional funding was required to support the new event of the Sprint Boat Race held in September. The Events Fund will receive an additional contribution of Hotel/Motel taxes in 2011 of approximately $27,000 which had been previously committed to the Wenatchee Convention Center. 13 (B) Utility taxes went into effect on February 1, 2009 in response to revenue shortfalls in 2008. These taxes are a necessary portion of City revenues. (E) The significant increase in Storm Water Utility spending is driven by NPDES federal regs, as well as capital spending on completion of the Canyon A project and other smaller capital projects. Funding for these activities is a combination of grants, revenue from fees paid to the SWU from residents of the SWU service area, and proceeds from a State Trust Fund Loan for Canyon A. (F) As noted in (A) above, a portion of Hotel/Motel taxes that were previously paid to the Wenatchee Convention Center will be kept by the City for its Events Fund, thereby reducing payments of pass -through revenues. (G) Street Improvements and Capital Improvements are funded by a number of sources including revenue specifically designated by the Council for that purpose, Real Estate Excise Taxes that are designated for street improvements, STP federal grant funds for street improvements, other specific purpose grants and matching or percentage contributions from sales or property taxes. 14 City of East Wenatchee, Washington 2012 Final Budget Worksheet - Expenditures 2012 Overview Expenditure Areas for the 2012 Budget: Actual 2009 General Government 406,107 Legislative 196,936 Municipal Court 313,375 City Clerk 125,789 Finance 155,621 Information Technology 55,700 Internal Services 25,851 Legal Department 128,621 City Engineering Dept - Civil Service 2,933 Central Services 102,212 Law Enforcement 2,454,532 Jail Services 260,849 Emergency Management 13,011 Storm Water Utility Operations 65,994 Storm Water Utility Constructic 579,273 Engineering Support 22,132 Planning 175,785 Code Compliance 132,988 Non -Expenditures - Pass throuE 725,689 Street Maintenance 830,430 Community Dev Grants 34,404 Library 2,207 Hotel/Motel Tax Fund 87,709 Drug Fund 12,423 Criminal Justice Fund 35,056 Events Fund 139,806 Bond Fund Debt Service 197,020 Street Improvements 29,895 Capital Improvements - Other 19,997 Total Expenditures $ 7,332,345 Estimated Actual 2010 Actual 2011 Budget 2012 403,944 4241484 413,440 179,982 286,871 309,528 (A) 329,814 2761867 334,200 (A) 128,572 128,750 138,750 162,217 191,850 186,600 135,062 72,200 149,500 (B) 36,113 35,800 35,200 130,009 167,500 180,050 (D) 100,119 108,701 115,580 (E) 1,433 - 3,225 91,154 99,700 112,000 2,679,515 2,775,700 2,848,650 235,701 251,500 293,000 11,830 - - 205,745 348,725 494,745 (F) 118,235 237,200 815,000 (G) 4,171 - - 171,222 125,340 131,050 135,228 1381075 152,025 497,599 441,297 370,400 813,050 777,000 728,100 25,942 2,670 201,038 4,019 3,400 3,500 72,241 47,762 47,000 6,131 - 1,000 52,845 56,500 32,000 272,405 252,390 178,300 (H) 200,596 199,713 198,413 108,377 39,000 2,059,610 (1) 13,097 170,000 404,979 (J) 134 - - $ 7,326,502 $7,655,695 $10,936,613 1s (A) The reporting for public defender costs has been changed from the Municipal Court to the Legislative cost center because of Court requirements. (B) Because of budget constraints, no computer equipment was purchased during 2009. The City caught up during 2010 and the 2011 budget has been somewhat reduced. (D) The City Attorney has been required to spend significantly more time supporting the Municipal Court as the prosecuting attorney. The case load and types of cases now results in the need for clerical assistance beginning in 2011. (E) The City Engineer was hired according to plan during 2010. (F) Federal unfundated mandates for polution control and monitoring requires,this additional funding requirement. The City and Douglas County jointly operate the Storm Water Utility and funding for these activities is provided through City and County Grants, as well as storm water paid by the residents of the storm water benefit area. (G) Most of these Storm Water Utility capital costs are directed at the Canyon A Project. The joint Storm Water Utility obtained a public works trust fund loan from the State through Douglas County to fund these project costs. (H) The Events Fund coordinates the Sprint Boat Race Event that was held for the first time in September 2010, resulting in greater costs to the City. (1) & (J) Capital Projects generally are partially funded through grants, with a portion of the costs borne by the City. 16 2012 BUDGET GENERAL FUND REVENUE Beginning Fund Balance The 2012 beginning fund balance is projected to be approximately $1,363,500. Property Tax/Contingency Property Tax It is the Finance Director's recommendation of the 2012 Budget Committee to take the allowable 1 % increase in property tax, which the Council approved at the meeting on November 22, 2011. The total 2012 Levy is calculated by the Douglas County Assessor's Office at $1,534,269 compared to $1,511,892 in 2011. $1,139,150 will be allocated to the General Fund, $200,000 to the Street O&M Fund, $180,000 to the Bond Fund for Debt Service, and the 1 % increase amount of $15,118.91 will be allocated to the Street Improvements Fund 301 per Resolution 2011-18 passed on November 8, 2011. Sales & Use Tax Sales and Use Taxes for 2012 are budgeted to be $2,600,000, slightly higher than the 2011 budget of $2,520,000. Actual receipts are expected to be over $2,600,000 in 2011, but include taxes from projects and activity the may not repeat in 2012. $2,281,000 is allocated to the General Fund, $250,000 is for the Street O&M Fund, and $69,000 is for the Events Fund. Recycling Based upon the agreement with Waste Management, we expect to receive $23,000 in 2012, comparable to prior years. Utility Taxes Utility taxes at the rate of 6% on natural gas, electricity, telephone and cellular phone service were approved by the City Council effective February 1, 2009. Two of the reasons for these new taxes include the fact that the City had unexpectedly depleted its cash position in 2008 completing major street projects, and declining revenues due to the economic downturn, primarily sales and use taxes and real estate excise taxes. 2011 projected receipts of utility taxes total $797,000. 2012 budgeted revenues for utility taxes total $787,000. Gambling Tax Gambling taxes are forecast at historical levels at the same effective rate of 8%. $290,000 is the projected receipts for 2011, and $275,000 in estimated revenue for 2012. 17 2012 BUDGET GENERAL FUND REVENUE Business Licenses Business License revenue is expected to be about $53,000 for 2011 and is estimated at that same level for 2012. Business license fees have not been changed since 1983. Franchise Fees Franchise fees are expected to be $90,000, approximately the same as in previous years. These fees are paid by the local cable provider. Building Permits Building permit revenues fell from over $161,000 in 2007 to approximately $86,000 in 2008, $65,000 in 2009, and $41,000 for 2010. Actual fees for 2011 are projected to be $46,000 compared to a budget of $46,000. The budget for 2012 is $46,000 on the expectation that building and development activity may have bottomed out. Gun Permits 2011 receipts are expected to be $2,500. $2,500 is the budget for 2012. PUD Privilege Tax This payment by Douglas PUD in lieu of property taxes was nearly $37,571 in 2011, and is expected to be about the same at $38,000 in 2012. Local Government Assistance The City did not receive local assistance late in 2011, and does not expect any for 2012. Liquor Excise Tax Liquor Excise Tax for 2011 is expected to be approximately 61,000 and is budgeted at $58,000 for 2012. Liquor Board Profits Liquor Board Profits for 2011 are expected to exceed $95,000, and is budgeted at that level for 2012. 2012 BUDGET GENERAL FUND REVENUE Eastmont School District SRO The funding for the School Resource Officer (SRO) program was cut by the School District at the beginning of 2009, although the City has continued to provide officers on - site. Housing of Prisoners This revenue is apportioned as a portion of the City's Municipal Court. Since overall court receipts have increased, this revenue has also increased. $41,500 is expected for 2011, and budgeted at that level for 2012. In comparison, the City will pay nearly $240,000 to the Regional Justice Center during 2011 for its share of housing prisoners. Storm Water Utility The City has an interlocal agreement with the Greater East Wenatchee Storm Water Utility (GEWSWU) to provide maintenance, small project and large capital project support for the SWU infrastructure within the City. With the advent of NPDES Federal Regulations (National Pollutant Discharge Elimination System), costs of compliance are expected to be very significant in the future, requiring higher SWU fees to citizens and greater expertise and resource allocation for the City. For 2012, the City has forecasted over $721,000 in capital construction for the Canyon A Project, $100,000 for smaller capital projects, and nearly $332,000 for NPDES maintenance and compliance work. Funding for this work is primarily on a reimbursement basis .... the City pays for and does the work, and gets reimbursed by the GEWSWU. Planning, Plan Checking & Development Fees Similar to building permits, revenues in these categories are dependent on building and development activity. $5,000 has been budgeted for Planning fees and $20,000 for Plan Checking Fees, generally at lesser levels than in the recent past. Fines & Penalties Municipal Court activity had increased significantly during 2009 and 2010 at $378,000 and 376,000 respectively, but is expected to be slightly lower at $340,000 in 2011. The estimated revenue for 2012 is $360,000. 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 City expects to receive and subsequently pay out more than $354,000 during 2011, and $366,000 is estimated for 2012. The greater portion of this non -revenue is Municipal Court Receipts that are allocated directly to the State of Washington totaling approximately $350,000 for 2012. 19 CITY OF EAST WENATCHEE CURRENT EXPENSE REVENUES GENERAL FUND REVENUE PAGE 1 OF 4 2012 Budget Worksheet SUMMARY BARS Numbers Description 2006 Actua/s 2007 Actual 2008 2009 2010 2011 Budget 2011 2011 2012 Budget Actual Actual Actual 7 Months Estimate 001.000.000.308.00.00.00 Beginning NC&I 103,966 153,206 253,525 218,641 826,340 962,961 999,260 999,260 1,305,039 Totals 103,966 153,206 253,525 218,641 826,340 962,961 999,260 999,260 1,305,039 Taxes 001.000.000.311.10.00.00 Property Tax 597,444 981,625 1,013,632 1,095,185 1,092,570 1,057,000 524,101 1,062,000 1,139,150 001.000.000.311.10.00.01 Contingency Property Tax - - - - 001.000.000.313.10.00.00 Sales & Use Tax 1,697,230 1,596,599 2,276,883 2,364,700 2,089,623 2,097,000 1,552,735 2,350,000 2,306,000 001.000.000.313.71.00.00 Criminal Justice 111,833 133,550 172,675 167,090 133,320 130,000 90,791 160,000 130,000 001.000.000.316.51.00.00 Electric Utility Tax - - _ 226,539 279,867 294,000 207,722 305,000 305,000 001.000.000.316.53.00.00 Natural Gas Utility Tax 31,966 40,085 40,000 27,608 37,000 42,000 001.000.000.316.55.00.00 Garbage Utility Tax - - - 001.000.000.316.57.00.00 6% Tax Tele/Cellular 303,272 424,481 435,000 279,199 450,000 440,000 001.000.000.316.55.01.00 Recycling 14,506 30,957 22,000 23,092 23,116 23,000 23,074 23,100 23,000 001.000.000.317.54.00.00 Gambling Tax 288,505 280,776 235,755 256,075 249,020 260,000 158,066 290,000 275,000 001.000.000.314.51.00.01 Gambling Tax Penalties 453 292 5,440 15,000 15,000 Totals 2,709,518 3,023,507 3,720,945 4,468,372 4,332,374 4,336,000 2,868,736 4,692,100 4,675,150 Licenses & Permits 001.000.000.321.00.00.00 Business Licenses 39,627 43,384 46,506 47,719 51,326 53,000 46,185 53,000 53,000 Proposed Fee Increase - 001.000.000.321.30.01.00 Fireworks Permits 450 400 600 500 400 400 450 450 450 001.000.000.321.60.00.00 Taxicab Licenses 675 965 1,558 465 431 330 400 400 400 001.000.000.321.70.00.00 Amusement Licenses 1,305 2,510 2,160 1,990 1,170 690 710 690 690 001.000.000.321.70.01.00 Panoram Licenses - 1,320 - 300 960 300 - - - 001.000.000.321.80.00.00 Business License Penalties 520 780 624 689 781 350 120 350 350 001.000.000.321.91.00.00 Franchise Fees 72,014 85,248 95,857 95,393 91,925 93,000 44,880 89,000 90,000 001.000.000.322.10.00.00 Building Permits 118,291 161,794 89,586 64,690 41,248 46,000 25,522 50,000 46,000 001.000.000.322.90.01.00 Gun Permits 2,154 2,801 2,611 2,951 3,106 2,500 2,004 3,500 2,500 Totals 235,037 299,202 239,502 214,697 191,347 196,570 120,271 197,390 193,390 (A) Total Forecast Property Taxes for 2011 are $1,534,269. $180,000 is allocated to the Bond Fund 202, $200,000 is allocated to the Street O&M Fund 101, $15,118.91 is allocated to Street Improvements Fund 301, leaving the balance of $1,139,150.00 to the General Fund. (B) Total Forecast Sales & Use Taxes for 2011 are $2,625,000. $250,000 is allocated to the Street O&M Fund 101, $69,000 is allocated to the Events Fund 117, leaving $2,306,000 in the General Fund. 20 CITY OF EAST WENATCHEE CURRENT EXPENSE REVENUES 2012 BUDGET WORKSHEET EE� PAGE 2 OF 4 BARS Numbers Description Z006 Actuals 2007 Actual 2008 2009 2010 2011 2011 Actual Budget 7 Months 2011 2012 Estimate Budget Actual Actual Intergovemmental 001.000.000.331.16.60.00 Bullet Proof Vest Grant 3,846 640 194 200 200 001.000.000.331.16.70.00 COPS Grant 26,467 - 85,698 87,000 56,581 88,000 87,000 001.000.333.04.21.01.00 WASPC Safety Grant 1,300 3,000 - _ _ _ 001.000.000.333.16.80.00 DOJ Video Grant - 13,021 3,764 4,821 5,000 001.000.000.333.06.93.00 Court Equipment Grant - - 3,209 329 400 400 001.000.000.334.03.51.00 TSC Grant - 7,956 1,651 001.000.000.334.03.51.01 TSC - Drive Hammered Hammered Get Nailed 4,342 3,318 1,145 - - - - 001.000.000.334.03.51.02 TSC - Click It or Ticket 3,426 747 3,271 - 001.00.000.334.03.51.03 TSC-Night Seat Belt Emp 2,985 521 1,400 1,522 1,522 1,400 001.000.000.334.06.51.04 TSC Speed Limit Emp 1,471 2,332 7,203, 2,800 - - 2,000 001.000.000.334.03.51.06 TSC - BoosterSeat Emp 446 . 001.000.000.334.06.91.00 Public Def Grant 20,000 20,000 15,000 15,000 15,000 15,000 15,000 001.000.000.335.00.91.00 PUD Privilege Tax 24,496 25,379 25,663 34,101 37,085 37,100 37,571 37,571 38,000 001.000.000.336.00.98.00 Local Govt Assistance 2007 _ 129,628 2,013 - 001.000.000.336.06.51.00 DUI 1,761 2,639 2,526 4,032 6,009 4,200 3,858 4,200 4,200 001.000.000.336.06.94.00 Liquor Excise Tax 45,681 52,028 27,660 28,128 57,777 58,000 46,754 61,000 58,000 001.000.000.336.06.95.00 Liquor Board Profits 73,763 83,540 105,186 108,024 93,269 85,000 51,624 70,000 95,000 001.000.000.338.21.01.00 Eaastmont School - SRO 24,820 28,455 28,093 3,305 - _ _ Totals 203,823 361,560 198,839 206,511 319,432 290,500 217,197 282,714 306,200 barges for Services 001.000.000.341.00.00.00 General Services 80 102 4,260 2,570 35 100 105 100 100 001.000.000.341.50.00.00 Sales of Maps 21 2,305 2 22 Passport Fees 925 800 1,100 1,600 1,200 001.000.000.341.60.00.00 Duplicating Services 1,953 1,468 2,424 1,431 1,291 1,000 771 1,000 1,000 001.000.000.341.96.00.00 Personnel Services - - - 001.000.000.342.36.00.00 Housing of Prisoners 14,158 26,004 31,133 36,755 41,392 37,500 25,388 41,500 41,500 001.000.000.342.40.00.01 Fire Marshall Ins ection Service 47 47 250 350 200 220 220 220 001.000.000.345.80.00.00 Planning & Development Fees 16,798 4,590 7,554 10,490 3,232 51000 5,614 8,000 5,000 001.000.000.345.81.00.00 Zoning & Subdivision Fees 225 150 - 500 - - 001.000.000.345.83.00.00 Plans Checking Fees 54,722 60,328 36,968 27,619 21,622 22,000 14,686 26,000 20,000 001.000.000.345.89.00.00 SEPA Permits 350 1,000 1,200 483 322 1,000 1,044 1,500 1,000 Totals 88,306 95,994 83,588 80,120 69,169 67,600 48,928 79,920 70,020 21 CURRENT EXPENSE REVENUES 2012 BUDGET WORKSHEET PAGE 3 OF 4 BARS Numbers Description 2,006 Actuals 2007 Actual 2008 2009 2010 2011 2011 2011 2012 Actual Actual Actual Budget 7 Months Estimate Budget Fines & Penalties 001.000.000.350.00.00.00 Fines & Penalties 164,204 206,752 300,675 377,971 375,628 375,000 210,288 340,000 360,000 001.000.000.351.00.01.00 Disabled Parking 3,149 - - _ _ _ - 001.000.000.357.30.01.00 Restitution 100 13 81 - 651 - 84 651 - 001.000.000.357.33.00.00 PuCc rt Receipts blic Defender - Uou_d Re 12,030 13,142 13,358 19,096 25,401 23,500 16,969 28,000 30,000 Totals 179,482 219,907 314,114 397,067 401,680 398,500 227,341 368,651 390,000 Miscellaneous 001.000.000.360.00.00.00 Miscellaneous 14,412 192,553 14,628 9,672 5,681 2,000 4 100 2,000 001.000.000.361.00.00.00 Interest Earnings 21,668 14,673 11,753 6,709 5,876 5,000 3,230 4,800 5,000 001.000.000.361.40.00.00 Sales Tax Interest 6,095 7,686 6,743 6,035 3,039 3,000 715 1,600 1,600 001.000.000.362.50.00.01 Eyment thly Lease Paayment 120 60 - - - 001.000.000.367.00.00.00 Donations _ 001.000.000.362.60.00.02 Rental Property 9thSt 8,838 6,962 _ 001.000.000.369.90.01.00 Eastmont MPD Loan Repayment - Totals 42,294 214,972 41,962 29,378 14,596 10,000 3,949 6,500 8,600 Sub -Total Current Revenues 3,458,461 4,215,142 4,598,950 5,396,145 5,328,598 5,299,170 3,486,422 5,627,275 5,643,360 Non -Revenues 3,343 5227 001.000.000.380.00.50.00 State Building Code Surcharge 620 1,024 699 396 477 350 184 280 300 001.000.000.380.00.50.01 State Share of Gun Permits 3,448 4,752 4,778 5,684 5,695 4,000 3,480 6,000 5,000 001.000.000.380.00.50.07 Engineering Reimbursement 26,753 16,699 8,317 17,450 1,653 1,000 64 100 001.000.000.380.00.50.11 Fireworks - DCFD Remittance 350 400 250 300 300 300 250 250 250 001.000.000.380.00.50.12 Fireworks - Cleaning Deposit 2,200 3,500 2,200 2,200 2,200 2,200 2,500 1,700 2,500 001.000.000.386.12.00.00 Crime Victim Assessment 3,062 3,746 5,395 6,811 6,894 6,500 731 3,000 6,000 001.000.000.386.91.00.00 State - Court Remittance 145,607 178,354 316,204 399,313 393,178 391,000 208,739 340,000 350,000 001.000.000.389.00.00.00 Other Non -Revenues 2,234 2,300 2,300 Totals 182,039 211,818 343,070 432,154 410,397 405,350 218,182 353,630 366,350 001.000.000.395.20.00.00 Insurance Recoveries 856 13,512.00 1,243.00 - 134.00 - 001.000.000.397.00.00.00 Operating Transfer In 15,834 14,099.00 6,995.00 Totals 16,690 27,611.00 8,238.00 134.00 - Total Current Non- Revenues 182,039 228,508 343,070 459,765 418,635 405,350 218,182 353 7764 366,350 General Fund Revenues Before SWU 3,640,500 4,443,650 4,942,020 5,855,910 5,747,233 5,704,520 3,704,604 5,981,039 6,009,710 22 CURRENT EXPENSE REVENUES 2012 BUDGET WORKSHEET STORM WATER UTILITY REVENUES PAGE 4 OF 4 BARS Numbers Description Z006 Actuals 2007 Actual 2008 2009 2010 2011 2011 2011 2012 Actual Actual Actual Budget 1 7 Months Estimate I Budget 050.000.000.343.13.00.00 SWU MaintSvcs 248,042 104,879 76,880 80,039 46,808 95 - - 050.000.000.343.13.00.20 SWU Admin 3,817 15,300 508 12,000 7,500 050.000.000.343.13.00.30 SWU Small Capital 35,831 100,000 939 76,000 100,000 050.000.000.343.13.00.61 Retrofit Catch Basins 420,363 - 190,000 050.000.000.343.13.00.Var SWU-Canyon A All Phases 550,445 58,112 1,487,000 4,652 161,200 525,000 Other SWU Activities 56,000 050.000.000.343.13.00.Var SWU NPDES Revenue 38,783 307,340 65,155 188,000 281,845 Total Storm Water Revenues 248,042 104,879 76,880 630,484 183,351 2,330,003 71,349 437,200 1,160,345 Grand Total General Fund Revenues 3,888,542 4,548,529 5,018,900 6,486,394 5,930,584 8,034,523 3,775,953 6,418,239 7,170,055 Total Available Resources 3,992,509 4,701,735 5,272,425 6,705,035 6,756,924 8,997,484 4,775,213 7,417,499 8,475,094 23 2012 BUDGET GENERAL FUND EXPENDITURE SUMMARY 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. RiverCom, the regional 911 center for the region, the Wenatchee Humane Society, and the Wenatchee Valley Transportation Council are the most significant. 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 inconsistent and a potential conflict of interest for the Court to be charged for and manage. Since then, these costs and the contracts with law firms to satisfy these functions are now part of the Legislative function of the City. Municipal Court: Includes costs of operation of the court, including payroll and benefit costs three full-time employees, one part-time employee, the judge who is on an employment contract. Cites: Includes payroll and benefit costs for the City Clerk and a 2/3 part-time assistant. The City Clerk's desk collects and tracks payments for business licenses, provides agendas/minutes/documentation for Council meetings, and maintains the City Code among other activities. Finance Department: Includes payroll and benefit costs for the Finance Director and part-time assistant. Accounting for receipts, expenses and payroll expenditures, financial reporting, and budget origination/management are the 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 software, licenses, hardware and peripheral equipment are being consolidated into this department. Internal Services: Includes the shared costs for telephone and postage for the City departments. Legal Department: Includes the payroll and benefit costs for the City Attorney and common department costs. City Engineering Department: This department was established in 2010 after the Council approved hiring a City Engineer to offset a portion of engineering costs for capital projects, manage capital projects, and oversee the public works department. ME Civil Service: Includes the necessity to retain a civil service secretary on an as -needed basis for testing in recruiting law enforcement officers. Central Services: Includes the costs to service and maintain City Hall. Law Enforcement: Includes the costs of staffing and operating the City police department. The department includes the Chief of Police, the Assistant Chief, three Sergeants, two Detectives, fourteen Patrol Officers, two records Custodians and an administrative 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). EmergencManagement: The Chief of Police provides this function for the City in coordination with other local and regional entities where mutual cooperation and support are required in the event of an emergency. Storm Water Utility: The City provides maintenance, small project support and capital project management for the Storm Water Utility according to an interlocal agreement, and is reimbursed for these services from the Storm Water Utility. Enizineering Services: The Community Development Department (Planning and Code) and the Street Department utilize outside engineering consultants in support of certain of their activities. As indicated previously, the 2010 Budget included a recommendation to hire a City Engineer, and if approved, a substantial portion of these costs are expected to be eliminated or offset by the work of the City Engineer. Planning Department: Includes the payroll and benefit costs for the Community Development Director, Associate Planner and a portion of the cost for 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 for administrative support, 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 serving in a temporary custodial function. For example, the largest amount is the State's allocated portion of revenues generated in the City's Municipal Court. 25 CITY OF EAST WENATCHEE CURRENT EXPENSE EXPENDGENERAL FUND EXPENDITURES PAGE IOF2 2012 BUDGET WORKSHEET SUMMARY Description 2006 Actuals 2007 Actuals 2008 Actuals 2009 Actual 2010 Actual 2011 Budget 2011 8 Months 2011 Estimate 2012 Budget 001 520-596 General Government 400,952 366,066 384,425 406,107 403,944 420,734 250,906 424,484 413,440 110 511 Legislative 133,994 171,505 172,990 196,936 179,981 316,600 161,048 286,871 309,258 120 512 Municipal Court 200,303 225,798 282,332 313,375 329,814 278,550 159,108 278,767 334,200 140 514 City Clerk 87,951 95,544 116,588 125,789 128,573 138,550 67,043 128,750 138,750 142 514 Finance 119,701 129,868 140,641 155,321 162,215 199,500 93,905 191,850 186,600 New Information Technoloy 60,158 55,700 135,062 92,000 40,026 72,200 149,500 141 514 Internal Services 20,070 15,250 18,036 25,851 36,114 40,700 22,199 35,800 35,200 151 515 Legal Department 54,782 99,709 119,562 128,621 130,009 178,725 93,182 167,500 180,050 City Engineering Dept 100,119 122,380 38,576 108,701 115,580 160 521 Civil Service 3,048 4,856 3,162 2,933 1,433 2,975 - 3,225 180 518 Central Services 84,064 78,630 85,507 102,212 91,155 97,230 43,592 99,700 112,000 210 521 Law Enforcement 1,769,372 2,126,300 2,374,520 2,424,532 2,679,514 2,791,300 1,553,166 2,775,700 2,848,650 230 523 Jail Services 158,603 121,150 185,166 260,849 235,701 230,500 139,398 251,500 293,000 250 525 Emergency Management 14,606 12,991 13,953 13,011 11,830 320532 Engineering 18,921 19,565 34,833 22,132 - - - 280 558 Planning 105,170 160,445 186,659 175,785 171,223 128,230 69,600 125,340 131,050 590 559 Code Compliance 105,830 120,872 132.143 132,988 135,228 144,175 79,915 138,075 152,025 Sub -Total Routine Expenditures 3,277,365 3,748,549 4,310,675 4,542,142 4,931,915 5,182,149 2,811,664 5,085,238 5,402,528 001 001 586 00 05 Non -Exp Court Remittances 147,465 163,034 338,690 399,321 364,288 360,000 214,127 355,000 350,000 001 001 586 00 03 Non-Exp State Gun Permits 3,363 4,255 5,366 6,078 5,912 5,000 3,165 5,500 5,000 001 001 586 00 13 Non-Exp Kentucky Annex S&U 142,165 205,096 219,872 126,728 65,173 10,000 15,755 15,755 Non-Exp Kent Annex PWTFL 170,788 55,835 56,000 55,287 55,287 - 001 001 586 00 07 Non-Exp Engr Reimburse 31,430 20,333 17,563 19,629 2,398 5,000 84 100 5,000 001 001 586 00 08 Cirime Victims - County Share 4,617 8,411 3,439 7,000 7,000 5,000 001 001 586 00 09 Non-Exp Turner Annex 4,450 17,462 Non-Exp Transfers Out 43,300 1,000 1,000 Non-Exp Clearing Corrections 250,800 1,364 (19,050) 001 001 Var Non-Exp - Other 201,169 13,088 (66) 380 380 001.001.586.00.06 Building Code Surcharge 396 320 400 171 275 400 001.001.586.00.11 DCFD Fireworks Remittance 300 300 500 250 500 001.001.587.02 Contingency 4,500 - 1,000 4,500 Sub -Total Non -Routine Expenditures 328,873 704,280 788,641 725,689 497,599 448,400 290,219 441,297 370,400 Total Current Expense Expenditures 3,606,238 4,452,829 1 5,099,316 5,267,831 5,429,514 5,630,549 3,101,883 5,526,535 5,772,928 26 CITY OF EAST WENATCHEE CURRENT EXPENSE EXPENDITURES RECAP 2012 BUDGET WORKSHEET PAGE 2 OF 2 2006 Description Actuals 2007 Actuals 2008 Actuals 2009 Actual 2010 Actual 2011 Budget 2011 8 Months 2011 Estimate 2012 Budget Storm Water Utility Operations: 050.000.310.531 Administration 1 15,300 7,637 12,000 7,500 050.000.311.531 Capital Projects - Small Capital Projects 100,000 19,471 76,000 100,000 050.000.312.531 Capital Projects - Canyon A 1,487,000 615 161,200 525,000 050.000.312.531 Retrofit Catch Basins 420,363 190,000 050.000.313.531 NPDES Compliance 307,340 79,234 188,000 281,845 Other Storm Water Activities 56,000 050.000.315.531 Annual Street Utility Charge 149,400 148,725 149,400 Total - Storm Water Utility Expenditures 143,957 58,754 645,267 323,981 2,479,403 106,957 585,925 1,309,745 Grand Total - General Fund Expenditures 4,596,786 5,158,070 5,913,098 5,753,495 8,109,952 3,208,840 6,112,460 7,082,673 Total Available Resources - Revenue 3,992,509 4,701,735 5,272,425 6,705,035 6,756,924 8,997,484 4,775,213 7,417,499 8,475,094 Fund Balance, End of Budget Year 104,949 114,355 791,937 1,003,429 887,532 1,566,373 1,305,039 1,392,421 27 2012 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. $500 has been budgeted each year. 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. RiverCom RiverCom costs are estimated to total $267,123 in 2012, a decrease due to higher call volumes in 2011. Past monthly payments were as follows: Year 2004 2005 2006 2007 2008 2009 2010 2011 2012 Animal Control Monthly Amount $20,756.43 $20,756.43 $17,559.20 $19,555.50 $21,234.75 $22,606.08 $21,376.83 $23,825.00 $22,260.25 Percent of Increase 0.00% (15.40)% 11.37% 8.59% 6.5% (5.4%) 11.45% (6.6%) The Wenatchee Valley Humane Society, has submitted a 2012 budget proposal of $66,483 per year. Following is a history of animal control expenditures: %61 2012 BUDGET GENERAL GOVERNMENT 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 % Wenatchee Valley Transportation Council (formerly_ Metropolitan Planning Organization) The membership dues amount will be $10,434 in 2012. This is the same as last year. NCW Economic Development District The membership dues amount will be $1,000 in 2012, the same as in the previous years Community Mental Health Quarterly, state -mandated payments in the amount of 2% of the City's quarterly liquor board profits and liquor excise tax receipts are remitted to the Chelan County Treasurer for community mental health (serving Chelan and Douglas Counties). $3,500 is budgeted for 2012. 29 CITY OF EAST WENATCHEE GENERAL GOVERNMENT EXPENDITURES GENERAL GOVERNMENT - 2012 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2006 Actuals 2007 Actuals 2008 Actuals 2009 Actuals 2010 Actuals 2011 Budget 2011 2011 Estimate 2012 Budget $ 7 Months Change 001.000.001.520.00.00.00 Wellness Program 375 324 177 80 500 263 500 500 001.000.001.521.10.29.00 LEOFF 1 34,010 33,407 41,719 48,324 56,233 53,500 32,885 56,400 61,700 5,300 001.000.001.521.10.29.01 LEOFF 1 LTC Ins - - 001.000.001.528.70.51.00 RiverCom 211,532 235,684 255,839 271,811 257,055 285,900 167,090 285,900 267,123 (18,777) 001.000.001.537.20.51.00 Solid Waste Administration 9,486 1,403 1,403 001.000.001.539.30.51.00 Animal Control 58,006 59,064 60,777 63,634 63,634 64,600 37,120 64,600 66,483 1,883 001.000.001.539.90.51.00 Dept of Ecology (NPDES) - 1,747 2,235 1,290 001.000.001.558.20.00.00 Wenatchee Valley Trans Council 9,835 9,835 10,130 10,434 10,434 10,434 10,434 10,434 10,434 001.000.001.558.20.00.01 NCW Economic Dev District 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 001.000.001.558.20.00.02 Community Foundation of NCW 5,000 1,000 1,000 1,000 001.000.001.564.00.52.00 Community Mental Health (2% Liquor) 1,740 2,695 2,649 3,396 3,021 3,100 776 3,500 3,500 - 001.000.001.596.00.47.00 Rental Utilities 111 1,435 536 200 338 400 200 (200) 001.000.001.596.00.47.05 Rental Rep & Maint 2,596 001.000.001.596.00.48.00 Repairs & Maintenance 34,028 1,133 2,198 784 548 1,500 750 1,500 750 001.000.001.596.00.55.00 Donations -Region (Bridge Repairs) 10,000 001.000.001.594.00.60.00 Capital Outlay 29,930 663 2,590 Totals 389,942 345,552 384,425 406,107 403,944 420,734 250,906 424,484 413,440 (7,294) Note: Increases in the LEOFF insurance for retirees - 11 % estimated by AWC 30 2012 BUDGET GENERAL FUND LEGISLATIVE DEPARTMENT Salaries Fifty percent of the Executive Secretary (to the Mayor)/Accounting Assistant salary is budgeted under the Legislative Department. The Mayor is paid here with no increase in 2012. All Council Positions receive $550/month. Benefits The benefits line item includes basic benefits such as L&I for the Mayor and Councilmembers; basic benefits, retirement, and insurance for 50% of the Executive Secretary position; and added health insurance benefits for the Mayor in 2010. Public Defender Court & Conflict Costs 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. Miscellaneous Miscellaneous expenditures include the annual membership to the Association of Washington Cities. The 2012 membership amount is $8,113, an 11.1% increase over last year's cost. 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. 31 U I Y UI- EAJ I WENATCHEE LEGISLATIVE EXPENDITURES LEGISLATIVE EXPENDITURES 2012 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2006 Actuals 2007 Actuals 2008 Actuals 2009 Actuals 2010 Actuals 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Change 001.000.110.511.10.10.00 Salaries 97,198 117,229 123,049 122,382 121,558 127,400 73,617 127,000 130,500 3,500 001.000.110.511.10.20.00 Benefits 13,811 16,016 17,428 18,250 25,096 42,500 15,426 27,000 29,500 2,500 001.000.110.511.10.31.00 Office Supplies 873 227 145 72 227 250 250 250 001.000.110.511.10.31.01 Central Stores 227 401 355 001.000.110.511.10.41.00. Prof Services 754 500 984 1,200 1,000 (200) 001.000.110.511.10.42.01 Telephone 4 001.000.110.511.10.42.03 Postage 918 634 43 11,48 18 18 (18) 001.000.110.511.10.43.00 Travel 1,824 1,502 1,400 794 1,500 1,496 1,500 1,500 001.000.110.511.10.43.01 Travel - Misawa 2,770 4,016 6,023 2,233 2,421 5,000 5,000 5,000 001.000.110.511.10.44.00 Advertising 647 63 788 968 001.000.110.511.10.46.00 Insurance 1,959 2,201 2,531 21673 3,038 2,900 76 3,600 3,700 100 001.000.110.511.10.48.00 Repairs & Maintenance 67 152 001.000.110.511.10.47:00 Background Check Costs 20 46 100 30 100 100 001.000.110.511.10.49.00 Miscellaneous 7,076 9,551 14,448 4,429 4,067 4,500 2,614 4,000 4,500 500 001.000.110.511.10.60.01 Council of Governments Governments 35 10 - 001.000.110.511.10.60.05 AWCAnnual Fee 7,118 7,118 7,200 7,303 7,303 8,133 830 001.000.110.511.40.00.00 Training 1,487 950 400 290 250 900 900 250 (650) 001.000.110.511.70.00.00 Election Costs - Officials 3,613 7,262 6,341 5,390 7,500 7,500 7,500 001.000.110.511.75.00.00 Election Costs - Reg Voters 14,184 15,000 15,000 15,325 325 001.000.110.511.90.00.00 Census Services 1,568 001.000.110.594.00.60.00 Capital Outlay 001.000.110.517.10.00.00 Tuition Reimb 32,156 ** ** ** New Public Defender Court From Municipal Court p 96,000 55,500 96,000 96,000 New Public Defender - Conflicts From Municipal Court p 6,000 3,084 3,000 6,000 3,000 Totals 133,994 160,119 172,990 196,937 179,982 316,600 161,048 286,871 309,258 22,387 ** Tuition Reimbursement for 2010 has been budget in each applicable department. Note: No significant changes. The Public Defender contract runs for two years - 2011 & 2012 32 2012 BUDGET GENERAL FUND MUNICIPAL COURT Salaries The Court Administrator, Assistant Administrator, two Clerical Assistants and half-time Clerical Assistant are paid through the Municipal Court, as well as the Judge. Benefits This line item is payroll benefits; medical, dental, and vision premiums; and retirement contributions for the Court Administrator, Court Clerk, and Clerical Assistant. Public Defender and Public Defender Conflicts Costs have been transferred to the Legislative area because of conflict of interest. Municipal Court Judge The Municipal Court Judge is under contract at a $4,500 per month salary, without benefits. Compensation for the Judge is now included above in Salaries and Benefits. Other Cost Line Items Other expenses are self-explanatory according to their titles and nature. 33 CITY OF EAST WENATCHEE MUNICIPAL COURT EXPENDITURES MUNICIPAL COURT 2012 BUDGET WORKSHEET - Department Head BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actuals 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Change 001.000. 120.512.50. 10.00 Salaries 77,283 85,938 98,164 108,579 151,759 180,500 104,335 180,500 200,000 19,500 001.000.120.512.50.20.00 Benefits 32,570 37,864 47,729 52,422 66,982 70,500 41,762 72,000 92,000 20,000 001.000.120.512.50.25.00 Tuition Reimbursement - 001.000.120.512.50.31.00 Office Supplies 2,691 2,983 3,898 3,300 3,659 3,500 2,510 3,500 3,500 001,000.120.512.50.31.01 Central Stores 183 324 205 81 001.000.120.512.50.40.00 Training 380 95 100 265 678 750 946 1,200 2,000 800 001.000.120.512.50.41.01 Public Defender ** 45,608 54,145 83,035 94,325 82,500 233 233 (233) 001.000.120.512.50.41.02 Prosecuting Attorney 153 - 001.000.120.512.50.41.03 Judge 24,200 28,600 32,100 35,100 - 001.000.120.512.50.41.05 Public Defender Confilicts 1,426 1,408 3,768 1,534 1,534 (1,534) 001.000.120.512.50.42.01 Telephone 108 29 36 154 - 001.000.120.512.50.42.03 Postage 1,505 2,436 657 13 12 001.000.120.512.50.43.00 Travel 701 202 85 306 (194) 5,300 2,346 5,000 5,000 001.000.120.512.50.46.00 Insurance 2,603 2,661 3,131 3,273 3,718 3,500 4,200 4,500 300 001.000.120.512.50.48.00 Repairs & Maintenance 264 - - - - 001.000.120.512.50.49.00 Miscellaneous 1,553 2,135 1,448 740 558 1,0001 22 300 500 200 001.000.120.512.50.49.01 Interpreting Services 1,529 1,968 4,266 5,324 8,869 6,000 2,006 3,700 3,700 - 001.000.120.512.50.49.02 Judge Protems 1,050 715 775 2,475 1,975 2,500 225 900 2,500 1,600 001.000.120.512.50.49.03 Witness Fees 801 2,321 429 618 223 500 432 700 1,500 800 001.000.120.512.50.49.04 Juror Fees - 300 2,164 1,119 1,500 1,367 2,500 4,000 1,500 001.000.120.518.30.00.00 Security 12,000 001.000.120.596.00.60.00 Capital Outlay 7,123 3,382 4,548 2,911 4,107 3,000 1,390 2,500 3,000 500 Totals 200,303 225,798 282,332 313,377 329,814 278,550 159,108 278,767 334,200 55,433 34 2012 BUDGET GENERAL FUND CITY CLERK Salaries The City Clerk and 60% part-time Clerical Assistant are paid in this department. Benefits This line item is payroll benefits; medical, dental, and vision premiums; and retirement contributions for the City Clerk and Clerical Assistant. Codification This line item is for codification of ordinances, incorporating them into the East Wenatchee Municipal Code Book. Other Expense Line Items Other expenses are self-explanatory according to their titles and nature. 35 CITY OF EAST WENATCHEE CITY CLERK EXPENDITURES CITY CLERK 2012 BUDGET WORKSHEET - Department Head BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 2011 2011 2012 $ Budget 7 Months Estimate Budget Change 001.000.140.514.10.10.00 Salaries 51,685 61,150 72,207 75,234 77,024 78,500 43,796 76,500 80,500 4,000 001.000.140.514.10.20.00 Benefits 18,700 24,071 30,724 33,457 34,435 38,600 18,672 34,000 40,000 6,000 001.000.140.514.10.31.00 Office Supplies 2,155 1,153 1,363 1,607 1,153 2,500 895 2,000 2,000 001.000.140.514.10.31.01 Central Stores 211 372 473 6,243 6,014 7,500 2,123 5,000 5,000 001.000.140.514.10.42.01 Telephone 83 51 6 - - 001.000.140.514.10.42.03 Postage 980 1,180 242 (17) 10 001.000.140.514.10.43.00 Travel 887 896 20 231 488 1,200 71 1,000 1,200 200 001.000.140.514.10.44.00 Advertising 2,301 1,126 1,343 1,957 1,184 1,500 686 2,500 1,500 (1,000) 001.000.140.514.10.46.00 Insurance 1,163 1,216 1,531 1,573 1,908 1,800 2,200 2,300 100 001.000.140.514.10.48.00 Repairs & Maint 2,507 2,130 726 595 759 500 600 1,000 400 001.000.140.514.10.49.00 Miscellaneous 691 1,340 749 553 427 750 415 750 750 001.000.140.514.30.00.00 Records Services 206 230 803 470 203 500 300 500 200 001.000.140.514.30.01.00 Codification 1,404 - 5,232 2,640 4,048 3,500 - 3,000 3,000 001.000.140.514.40.00.00 Training 295 629 895 400 725 1,200 375 500 1,000 500 001.000.140.596.00.60.00 Capital Outlay 4,684 - 274 849 204 500 400 (400) Totals 87,951 95,544 116,588 125,792 128,572 138,550 67,043 128,750 138,750 10,000 36 2012 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. Benefits The benefits line item is payroll benefits; medical, dental, and vision premiums; and retirement contributions for the City Treasurer/Finance Director and Accounting Assistant Budgeting, Accounting, and Auditing Represents costs for audits and annual reports required by the Washington State Auditor's Office. Capital Outlay 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. 2012 includes the annual payment and an allowance for a possible software addition. Other Expense Line Items Other expenses are self-explanatory according to their titles and nature. 37 CITY OF EAST WENATCHEE FINANCE EXPENDITURES FINANCE DEPARTMENT 2012 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actuals 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $ Change 001.000.142.514.20.10.00 Salaries 73,480 76,392 87,855 102,733 106,872 111,600 63,928 110,500 118,200 7,700 001.000.142.514.20.20.00 Benefits 28,448 30,870 31,376 36,534 38,380 48,000 22,603 40,000 46,500 6,500 001.000. 142.514.20.3 1.00 Office Supplies 2,743 1,136 2,376 1,572 2,442 2,000 1,859 3,200 3,500 300 001.000.142.514.20.31.01 Central Stores 109 193 257 001.000.142.514.20.42.01 Telephone 11 10 001.000.142.514.20.42.03 Postage 587 729 234 7 (9) 1 001.000.142.514.20.43.00 Travel 339 506 742 157 152 500 43 300 500 200 001.000.142.514.20.46.00 Insurance 1,025 851 1,261 1,373 1,548 1,600 2,100 2,100 001.000.142.514.20.48.00 Repairs & Maintenance 1,889 1,362 1,434 1,362 613 750 500 750 250 001.000.142.514.20.49.00 Miscellaneous 2,158 305 4,832 1,934 2,494 2,300 1,571 3,000 2,300 (700) 001.000.142.514.20.49.05 Tax Rtn Diff Form 941 (3,792) _ 001.000.142.514.23.00.00 Budgeting, Accounting, Auditing 6,724 15,816 8,262 12,694 3,265 26,000 2,400 26,000 6,000 (20,000) 001.000.142.514.40.00.00 Training 250 818 995 160 600 750 498 750 750 - 001.000.142.594.00.60.00 Capital Outlay 1,938 880 1,017 587 5,860 6,000 1,002 5,500 6,000 500 Totals 119,701 129,868 140,641 155,321 162,217 199,500 93,905 191,850 186,600 (5,250) Note: Except for Auditing costs, no material changes in costs. The audit costs for 2011 result from the requirement for a federal audit because of the City's receipt of more than $500,000 in 2010 (required the audits of 2009, 2010, and a federal single audit). We expect no audit requirement for 2011, but a repeat in 2012 because of the Sellar Bridge Project. 38 2012 BUDGET GENERAL FUND INFORMATION TECHNOLOGY Contracted Services The City had previously provided information technology support through an independent contractor through 2010. During 2011, the City has purchased support from a local information technology service vendor and is in the public bid process to negotiate a longer term vendor relationship. Website Upgrade The City has provide monies in the miscellaneous category with the intent of upgrading its website during 2012. 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. 39 CITY OF EAST WENATCHEE IT DEPARTMENT EXPENDITURES INFORMATION TECHNOLOGY 2012 BUDGET WORKSHEET - Department Head - Mayor Lacy/City Engineer BARS Numbers Description 2008 Actual 2009 Actual 2010 Actual 2011 2011 2011 2012 $ Budget 7 Months Estimate Budget Change 001.000.145.514.10.10.00 IT contractor 54,288 55,700 41,775 55,700 001.000.145.514.20.31.00 Supplies 2,459 - 1,038 2,000 2,000 2,000 001.000.145.514.20.40.00 Network Services - 4,592 30,671 55,000 50,000 (5,000) 001.000.145.514.20.48.00 Repairs & Maint 3,331 752 2,000 197 1,200 2,000 800 001.000.145.514.20.49.00 Miscellaneous 80 344 300 507 1,000 40,000 39,000 001.000.145.594.00.60.01 Computer Equipment - Admin Capital 14,026 13,500 13,500 001.000.145.594.00.60.10 Computer Licenses - Admin Capital 9,792 7,500 001.000.145.594.00.60.20 Computer Software - Admin Capital 3,451 5,000 1,867 3,000 10,000 7,000 001.000.145.594.00.60.30 Computer Hardware - Admin Capital 26,708 5,000 4,333 7,000 17,500 10,500 001.000.145.594.00.60.51 Computer Equipment - Police Dept Capital 1,018 2,000 2,000 2,000 001.000.145.594.00.60.60 Computer Licenses - Police Dept Capital 2,257 7,500 7,500 7,500 001.000.145.594.00.60.70 Computer Software - Police Dept Capital 725 001.000.145.594.00.60.80 Computer Hardware - Police Dept Capital 28,584 5,000 2,451 5,000 5,000 Capital Outlay 38,367 Totals 60,158 55,700 135,062 92,000 40,026 72,200 149,500 77,300 2012 Notes: Network Services - Estimated (based on 2011) - plan to contract with a vendor based on RFP specs. Computer Equipment - Admin - 6 computers (estimate) x $2,000 each + 3 printers (estimate) x $500 each Computer Software - Admin - 12 copies of Microsoft Office (includes license) x $250 each Computer Hardware - Admin - New Server - Total - $27,500 Server Hardware = $10,428.60 + tax - $12,000 Installation & Setup = $4,500 + tax - $5,500 Software = $8,949.30 + tax - $10,000 Website Modernization Estimated at $40,000 - Included in Miscellaneous Police Department Requested same budget as last year. 40 2012 BUDGET GENERAL FUND INTERNAL SERVICES DEPARTMENT Telephone Line Charles Charges for telephone service to City Hall. Postage Meter This line item is used to reimburse the postage meter by department usage. Repairs & Maintenance Repairs and maintenance of internal services equipment includes the postage meter and city hall copier. Miscellaneous This line item covers the quarterly rental expense of the postage meter, postage meter supplies, and membership in the state contract program. It has been reduced based upon the new rental agreement. Capital Outlay Internal Services capital outlay covers the monthly rental payments for the City Hall main copier. It has been increased to reflect the anticipated 2012 expenditures. 41 CITY OF EAST WENATCHEE INTERNAL SERVICES EXPENDITURES INTERNAL SERVICES 2012 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actuals 2009 Actual 2010 Actual 2011 Budget 2011 8 Months 2011 Estimate 2012 Budget $$ % Change Change 001.000.141.514.80.31.00 Office Supplies - 38 94 447 500 (500) 0.00% 001.000.141.514.80.31.01 Copier Maintenance - 13 - 94 200 (200) 0.00% 001.000.141.514.80.42.01 Telephone Line Charges 17,029 14,749 8,027 9,001 10,627 11,000 6,552 11,000 11,500 500 7.63% 001.000.141.514.80.42.03 Postage Meter 486 2,267 5,102 10,995 10,890 12,000 8,192 12,000 10,000 (2,000) -24.41% 001.000.141.514.80.48.00 Repairs & Maintenance Postage 0 1,062 1,003 1,510 1,283 1,000 1,187 1,500 1,000 (500) -42.12% 001.000.141.514.80.49.00 Miscellaneous 685 135 156 214 300 100 300 200 #DIV/01 001.000.141.594.00.60.00 Capital Outlay** 1,868 2,766 3,711 4,037 13,313 16,400 5,727 10,000 12,400 2,400 41.91% Totals 20,070 20,992 18,037 25,851 36,113 40,700 22,199 35,300 35,200 (100) -0.45% ** Copier Monthly Payment Color copies add'I cost. Mis-read of lease. Additional annual costs thru Jan 2013. Increase in Postage Costs due to increase in postal rates and consolidation of postage costs in this cost center. 42 2012 BUDGET GENERAL FUND LEGAL DEPARTMENT Salaries The City Attorney position will receive an increase per his employment agreement, effective January 1, 2012. The 2012 budget also includes a 3/4-time clerical support for the City Attorney Department to support the increasing workload of cases in the Municipal Court in which the City Attorney is the Prosecuting Attorney. Benefits The benefits line item is payroll benefits, insurance premiums, and retirement contributions for the City Attorney and his clerical support employee. Professional Services This resource for the City Attorney to provide casework documentation for Municipal Court cases will now be satisfied by the new clerical support employee. 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. W CITY OF EAST WENATCHEE LEGAL DEPARTMENT EXPENDITURES LEGAL DEPARTMENT 2012 BUDGET WORKSHEET - Department Head BARS Numbers Description 2006 Actuals 2007 Actual 2008 2009 Actuals Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Change 001.000.151.515.10.10.00 Salaries 37,640 72,443 84,123 91,218 92,250 123,800 66,957 117,000 119,000 2,000 00 1.000. 151.515.10.20.00 Benefits 13,165 22,077 29,455 32,553 32,261 49,600 25,729 46,000 54,800 8,800 001.000.151.515.10.25.00 Prof Services 300 950 001.000.151.515.10.31.00 Office Supplies 1,256 1,502 525 468 461 500 184 250 500 250 001.000.151.515.10.31.01 Central Stores 137 242 360 - - 001.000.151.515.10.42.01 Telephone - - - - - 001.000.151.515.10.42.03 Postage 35 372 58 (26) (1) 001.000.151.515.10.43.00 Travel 321 373 492 92 97 100 100 100 001.000.151.515.10.46.00 Insurance 1,162 851 2,531 2,637 2,914 2,900 3,300 3,700 400 001.000.151.515.10.48.00 Repairs & Maintenance - - - 158 - 200 200 200 001.000.151.515.10.49.00 Miscellaneous 287 1,649 1,636 520 70 200 312 350 350 001.000.151.515.40.00.00 Training 630 200 350 - - 325 500 100 (400) 001.000.151.515.45.00.00 Licensing 1,007 600 600 600 001.000.151.594.00.60.00 Capital Outlay 151 32 700 - 500 700 700 Totals 54,782 99,709 119,562 128,620 130,009 178,725 93,182 167,500 180,050 86,868 Note: This budget includes the City Attorney's employment contracted salary increase and his clerical assistant. Health Comp Insurance Taxes Total City Attorney Contract 96920 25050 17200 139170 Clerical Assistant 22000 8650 3900 34550 Total 118920 33700 21100 173720 44 2012 BUDGET GENERAL FUND CITY ENGINEER DEPARTMENT Salaries The City Engineer position was approved for the 2010 Budget. This position was filled early in March of 2010 under an employment contract through 2012. This is a Department Head position reporting to the Mayor. Salary & Benefit costs Salary and benefit costs represent arrangements under an employment agreement whereby the City Engineer works an approximate 3/a schedule or 1,500 hours per year. The contract term is thru 2012. Other Expense Line items 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. M City of East Wenatchee, Washington General Fund Budget 2012 ENGINEERING DEPARTMENT Costs for a City Engineer (Engineering Department) BARS Account 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Bud et Change 001.000.315.532.20.10.00 Salary 64,470 73,080 42,630 73,080 75,280 2,200 001.000.315.532.20.20.00 Benefits 18,346 29,600 12,263 27,000 28,000 1,000 001.000.315.532.20.41.00 Prof Services 186 5,000 57 400 2,000 1,600 001.000.315.532.20.31.00 Office Supplies 200 - - - 001.000.315.532.20.43.00 Travel 1,800 728 1,400 1,800 400 001.000.315.532.20.46.00 Insurance 2,604 2,500 3,000 3,100 100 001.000.315.532.20.48.00 Repairs & Maintenance - 001.000.315.532.20.49.00 Training 1,357 400 200 400 200 001.000.315.532.20.49.01 Miscellaneous 200 200 200 001.000.315.532.20.49.05 Registrations 2,400 460 1,035 1,800 765 001.000.315.532.20.49.10 Memberships 1,000 155 310 1,000 690 001.000.315.532.45.00.00 Licensing 2001 1 76 76 001.000.315.594.00.60.00 Capital 13,156 6,000 2,102 2,200 2,000 200 Total Costs 1 100,1191 122,380 58,395 108,701 1 115,5801 6,879 Notes: UPDATE FOR 2012 Travel - 2 conferences x 3 days x 2 people x $150 / day Training - inspection and entry level engineering training for Associate Engineer Registrations - new BARS accounted added in mid 2010 - 4 conferences x $450 / conference Memberships - new BARS accounted added in mid 2010 - 2 memberships x 2 people x $250 / membership Licensing - P.E. license is due every 2 years - due in 2011 - fee has been reduced 46 2012 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. 47 CITY OF EAST WENATCHEE CIVIL SERVICE EXPENDITURES CIVIL SERVICE 2012 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2007 Actual 2008 Actuals 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $ Change 001.000. 160.521. 10.10.00 Salaries 2,310 1,172 1,716 79 1,500 1,500 1,500 001.000.160.521.10.20.00 Benefits 194 99 146 13 125 - 125 125 001.000.160.521.10.46.00 Insurance 1,181 1,631 1,035 1,341 1,250 1,500 1,500 001.000.160.521.10.49.00 Miscellaneous 1,171 260 36 - 100 100 100 -Totals 4,856 3,162 2,933 1,433 2,975 3,225 3,225 Note: Allow for the possibility for a recruitment under civil service conditions. 48 2012 BUDGET GENERAL FUND CENTRAL SERVICES Note: Central Services represents the costs of maintaining the City Hall Building. 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 Street Department Director. Capital Outlay For 2012, the City has planned to provide better security of City Hall by changing its access system. 49 CITY OF EAST WENATCHEE CENTRAL SERVICES EXPENDITURES CENTRAL SERVICES 2012 BUDGET WORKSHEET - Department Head BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $ Change 001.000.180.518.10.10.00 Salaries 13,690 14,750 782 001.000.180.518.10.20.00 Benefits 8,155 8,850 359 - - 001.000.180.518.10.31.00 Office Supplies 570 50 130 166 13 200 97 200 200 001.000.180.518.10.31.02 Central Stores 82 150 65 228 59 80 (38) 001.000.180.518.10.31.06 Cleaning Supplies 1,570 2,500 2,407 1,713 1,684 2,200 875 1,800 2,200 400 001.000.180.518.10.35.00 Small Tools & Equipment 607 400 161 762 - 001.000.180.518.10.41.00 Professional Services 11,279 12,300 15,829 13,326 10,828 10,000 8,168 12,000 14,000 2,000 001.000.180.518.10.41.01 Contracted Custodial Services 5,905 15,765 15,666 19,000 9,606 19,000 25,000 6,000 001.000.180.518.10.46.00 Insurance 10,410 11,130 12,631 13,073 14,200 13,750 15,700 16,600 900 001.000.180.518.10.47.00 Utilities 12,098 14,000 18,699 19,260 13,980 20,000 8,845 17,000 19,000 2,000 001.000.180.518.10.48.00 Repairs & Maintenance 3,428 3,000 19,502 17,424 8,997 3,500 3,657 5,000 7,500 2,500 001.000.180.518.10.49.00 Miscellaneous 1,330 2,500 2,123 2,407 2,563 1,500 1,214 2,000 2,000 001.000.180.518.10.49.01 Landscaping 414 1,500 5,837 1,572 130 - 001.000.180.518.92.00.00 Ancillary 7,806 5,000 103 3,024 4,568 2,000 6,534 12,000 12,000 001.000.180.594.00.60.00 Capital Outlay 12,625 2,500 974 13,493 18,466 25,000 4,634 15,000 13,500 (1,500) Totals 84,064 78,630 85,507 102,213 91,154 97,230 43,592 99,700 112,000 12,300 Notes: Update for 2012 Cleaning Supplies - Dana provides input 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 & Maintnenance - Irrigation, doors, locks, tree spraying, plumbing, etc. Miscellaneous - Medical supplies Ancillary - Street Division salaries for minor repairs Capital Outlay Master Key / Access System Proposal Project 1 Rebuild or replace lock cores for City Hall and Court entry doors + new keys - $1600 Project 2 Rebuild or replace lock cores for internal offices + new keys - $900 Project 3 Proximity lock and cards for Police Department - $1,000 Additional I Programmable proximity lock and cards for City Hall - $5,000 (estimate) Pave lower employee parking area - $15,000 (estimate) Budget Committee Deferred for 2012 Miscellaneous repairs and painting - $5,000 50 2012 BUDGET GENERAL FUND LAW ENFORCEMENT Salaries This line item is salaries for the Police Chief, Assistant Police Chief, and police officer bargaining unit and police clerical bargaining unit employees. 2011 was the third and last year of a three year contract for Bargaining Unit employees resulting in a cumulative 23.6% pay increase for both locals over its term covering police officers and records staff. The City has spent most of 2011 attempting to bargain a new agreement with these employees who are affiliated with the Teamsters Union. At present, an agreement has not been reached. The City has estimated the costs of its last offer for purposes of budgeting for 2012. COPS Salaries A COPS (Community Oriented Policing Services) officer was hired late in 2009 under this three year federal grant program administered by the US Department of Justice. The grant covers salary and benefit costs over the three year period. The City is required to employ the COPS officer for a period of 12 months after the 36 month grant period. Overtime Salaries Overtime is incurred for court, detective call out, coverage for sick and vacation leave, mandatory/needed training, shift hold overs due to service calls, and special events. SRO Salaries 50% of the school resource officer's salary was previously reimbursed by the Eastmont School District for 9 '/2 months of the school year thru 2009. Because of budget constraints at the School District, this funding has not been available in 2010 or 2011, and is not expected in 2012. Consequently the costs are included in regular salaries and benefit categories. Benefits This figure covers city paid portions of medical benefits, retirement, social security, L&I, and employment security. Clothing Allowance This figure is for the purchase and maintenance (not including drycleaning) of uniforms and police -related equipment. SRO Benefits See SRO salary above. 51 Tuition Reimbursement This amount is estimated for police officers who are attending college for allowable reimbursement of costs under this program. Office Supplies Individual department office supplies. Central Stores Proportionate share of Central Stores (stocked) office supplies. Fuel Consumed Fuel for police vehicles. Small Tools & Equipment This amount is for firearms qualifications supplies, evidence gathering supplies, emergency vehicle equipment, bullet proof vests, mobile data terminals, radar equipment, radios, weapons, flashlights, batteries, tapes, flares, first aid supplies, uniforms/equipment for new hires, and other emergency equipment. Professional Services This amount covers WSP ACCESS fees, interpreting fees, polygraph and psychological exams, messenger service fees, and paper shredding service. Telephone This amount covers cellular telephones, long distance, fax, via RiverCom auto attendant, and mobile data terminal charges. Postage This amount is for department mailing expenses. Travel This amount covers the expense of meals and lodging to attend criminal justice training. Advertising This amount is for department advertising expenses. Insurance This amount is for police department liability and property insurance, including claims deductibles. 52 Repairs & Maintenance This amount is for repairs and maintenance of vehicles, radar equipment, radio equipment, computers, office equipment, and other emergency equipment. Miscellaneous This amount covers the expense of radar calibrations, professional membership dues, vehicle wash tokens, medical examinations, and first aid kit replacements. Reserves This figure is for uniforms, equipment, and training for reserve police officers. Dry cleaning This amount is for the cleaning and pressing of officers', police clerical employees', and reserves' uniforms. Crime Prevention Public safety materials and supplies. Training — Chief This amount is for the registration fees for criminal justice training for the police chief. Training — Officers This amount is for the registration fees for criminal justice training for sergeants, detectives, and patrol officers. Training — Office Staff This amount is for the registration fees for criminal justice records training. Other Services This amount is for the cost of firearms qualifications usage of the gun club range, and emergency driving training at the Ephrata airport. Ancillary This figure covers the Interfund expense for Street Department personnel to perform maintenance on police vehicles and equipment such as oil changes and installations. Capital Outlay This amount is for copier lease fees, currently leased police vehicles, annual Spillman computer maintenance agreement, and Spillman software to run the new National Incident Reporting System (unfunded federal mandate). 53 Jail Services - Detention Housing of prisoners is provided by the Chelan County Regional Justice Center and the Okanagan County Jail under inter -local agreements. Per -day charges are currently $73.50 and $52.00 respectively. Utilization is expected to be similar in 2012 in comparison to 2011, consequently 2012 reflects only a modest increase. Emergency Management The Chief of Police is the Emergency Management Director for the City, and this category reflects his pay and benefits for those duties, as well as a minor equipment allowance. These costs are now included in the main categories of salary and benefit costs. 54 CITY OF EAST WENATCHEE LAW ENFORCEMENT EXPENDITURES LAW ENFORCEMENT 2012 BUDGET WORKSHEET - Department Head - Police Chief Numbers Description Actuals Actual Actual Actual Actual Budget 7 Months Estimate Budget nge 001.000.210.521.10.10.00 Salaries 1,059,281 1,263,672 1,479,147 1,551,757 1,613,431 1,650,000 955,793 1,650,000 1,624,200 (25,800) 001.000.210.521.10.10.01 COPS Salaries 8,614 - 60,842 51,400 39,962 64,500 72,300 7,800 001.000.210.521.10.10.02 Overtime Salaries 44,912 68,951 58,838 64,000 76,478 51,400 37,023 60,000 53,500 (6,500) 001.000.210.521.10.10.03 Overtime Sal - Traffic Control _ - - - 4,105 6,000 2,670 3,300 6,250 2,950 001.000.210.521.10.10.05 SRO Salaries 11,956 16,532 7,247 - - 001.000.210.521.10.20.00 Benefits 379,511 469,624 546,612 583,725 638,382 669,000 369,226 655,000 752,500 97,500 001.000.210.521.10.20.01 Clothing Allowance 8,357 7,327 14,162 12,131 13,666 13,800 9,510 13,500 13,800 300 001.000.210.521.10.20.02 COPS Benefits 4,620 - - - 29,294 20,500 16,657 27,700 32,400 4,700 001.000.210.521.10.20.03 CRDTF Benefits - - 001.000.210.521.10.20.05 SRO Benefits 4,104 5,951 2,669 - - 001.000.210.521.10.25.00 Tuition Reimbursement 27,648 40,000 15,000 15,000 001.000.210.521.10.31.00 Office Supplies 6,984 6,697 6,542 5,339 4,480 5,000 2,424 4,000 5,000 1,000 001.000.210.521.10.31.01 Central Stores 297 531 267 - - 001.000.210.521.10.32.00 Fuel Consumed 42,551 44,078 64,807 45,419 50,053 47,000 39,200 65,000 57,500 (7,500) 001.000.210.521.10.35.00 Small Tools & E ui ment 8,397 12,439 10,212 4,886 6,991 7,900 5,308 7,900 7,900 - 001.000.210.521.10.35.01 WASPC Block Grant - - - 3,000 3,000 3,000 001.000.210.521.10.35.02 WASPC Traffic Safety Grt 2,052 2,500 2,500 2,500 001.000.210.521.10.41.00 Professional Services 6,761 7,308 6,965 7,542 7,116 6,800 4,396 6,800 6,800 - 001.000.210.521.10.42.00 Dispatch - - 2,194 - - 001.000.210.521.10.42.01 Telephone 15,971 14,533 18,192 17,859 16,614 17,700 9,237 17,000 17,000 001.000.210.521.10.42.03 Postage 695 906 471 387 426 500 320 500 500 001.000.210.521.10.43.00 Travel 3,982 4,512 7,089 5,086 4,940 5,000 2,662 5,000 5,000 001.000.210.521.10.44.00 Advertising - - 245 - - 400 400 001.000.210.521.10.46.00 Insurance 23,178 24,997 27,653 28,211 31,333 28,000 384 33,700 32,500 (1,200) 001.000.210.521.10.48.00 Repairs & Maintenance 43,440 43,817 55,196 46,715 41,675 40,000 29,148 40,000 45,000 5,000 001.000.210.521.10.49.00 Miscellaneous 3,949 4,399 2,286 3,849 4,260 3,000 2,428 3,500 3,400 (100) 001.000.210.521.10.49.01 Reserves 2,990 490 3,554 - 855 1,000 174 800 1,000 200 001.000.210.521.10.49.02 Drycleaning 2,695 4,003 4,545 2,645 2,541 4,000 1,183 2,500 2,800 300 001.000.210.521.23.01.00 K-9 Unit 295 682 834 - 001.000.210.521.30.00.00 Crime Prevention 450 330 456 200 200 200 001.000.210.521.40.01.00 Training - Chief 400 - - - - 400 215 400 400 - 001.000.210.521.40.02.00 Training - Officers 1,500 1,192 2,053 1,344 970 2,000 199 2,000 2,000 - 001.000.210.521.40.03.00 Training - Office Staff 500 90 - 100 100 200 100 001.000.210.521.30.02.00 TrfSftyComm Grant 6,146 - - Subtotal 1,688,441 2,009,117 2,322,326 2,380,895 2,636,100 2,676,200 1,528,119 2,663,200 2,763,050 99,850 55 CITY OF EAST WENATCHEE LAW ENFORCEMENT EXPENDITURES LAW ENFORCEMENT 2012 BUDGET WORKSHEET IPAGE 2 OF 2 PAGE 2 OF 2 kGE 2 OF 2 BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Change Balance Forward 11688,441 2,009,117 2,322,326 2,380,895 2,636,100 2,676,200 1,528,119 2,663,200 2,763,050 99,850 001.000.210.521.90.00.00 Other Services 235 445 445 500 1,070 1,100 500 1,100 600 001.000.210.521.90.01.00 Ancillary 8,035 3,644 6,127 4,228 5,907 5,500 3,375 7,000 5,500 (1,500) 001.000.210.525.92.00.00 Emerg Services 379 001.000.210.594.00.60.00 Capital Outlay 72,662 56,837 45,243 38,909 36,438 108,500 21,672 105,000 79,000 (26,000) Totals 1,769,372 2,070,043 2,374,520 2,424,532 2,679,515 2,791,300 1,553,166 2,775,700 2,848,650 72,950 Jail Services - Finance 001.000.230.523.20.00.00 Detention 155,979 121,150 182,086 250,839 231,444 220,000 132,985 240,000 280,000 40,000 001.000.230.523.20.00.01 Medical Care for Prisoners 2,623 - - 217 3,000 173 500 1,000 500 001.000.230.523.20.00.02 Juvenile Detention 3,080 10,010 4,040 7,500 6,240 11,000 12,000 1,000 001.000.230.523.20.00.02 Totals 158,603 121,150 185,166 260,849 235,701 230,500 139,398 251,500 293,000 41,500 Emergency Management - Police Chief 001.000.250.525.10.10.00 Salaries 10,111 10,122 10,109 10,008 10,008 001.000.250.525.10.20.00 Benefits 2,806 2,869 2,940 3,003 822 001.000.250.525.10.30.00 Equipment 1,688 - 904 - 1,000 Totals 14,606 12,991 13,953 13,011 11,830 56 2012 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 Inspector and the Street Department. An Associate Planner left the City's employment and that position is currently open and unfilled. Benefits The benefits line item is payroll benefits; medical, dental, and vision premiums; and retirement contributions for the Community Development Director, and 25% of the Permit Technician. Professional Services The requested amount for this line item anticipates expenses necessary to complete long range planning projects next year. Several of these projects will require the use of outside professionals. Hearing Examiner The requested amount for this line item anticipates expenses necessary for a hearing examiner processing quasi-judicial applications. This amount is an estimate based upon the average number of permits processed. The City contracts for the hearing examiner position. 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. 57 CITY OF EAST WENATCHEE PLANNING DEPARTMENT EXPENDITURES PLANNING DEPARTMENT 2012 BUDGET WORKSHEET - Department Head Expenditures BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actuals 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Change 001.000.580.558.10.10.00 Salaries 65,660 109,035 124,477 125,822 123,983 84,600 49,584 84,600 89,000 4,400 001.000.580.558.10.20.00 Benefits 21,310 34,752 37,954 38,841 37,047 29,600 14,585 25,600 29,000 3,400 001.000.580.558.10.31.00 Office Supplies 3,236 1,102 683 628 893 700 158 300 400 100 001.000.580.558.10.31.01 Central Stores 108 193 482 19 001.000.580.558.10.32.00 Fuel Consumed 180 571 480 270 157 250 167 200 150 (50) 001.000.580.558.10.35.00 Small Tools & Equipment - _ 168 92 12 200 162 200 200 - 001.000.580.558.10.41.00 Professional Services 1,380 4,982 3,924 2,283 1,315 4,000 1,083 4,000 4,000 001.000.580.558.10.41.01 Hearings Examiner - - 1,350 - 1,350 900 1,350 2,250 900 (1,350) 001.000.580.558.10.42.01 Telephone 183 232 48 - - 001.000.580.558.10.41.02 Engr/Architect Svc 190 190 001.000.580.558.10.42.03 Postage 889 514 172 (9) (16) - 001.000.580.558.10.43.00 Travel 408 1,282 361 182 23 600 104 500 (500) 001.000.580.558.10.44.00 Advertising 578 1,844 1,453 2,269 1,639 2,200 1,301 2,000 2,000 - 001.000.580.558.10.46.00 Insurance 2,262 2,401 2,831 2,885 3,238 3,000 3,400 3,500 100 001.000.580.558.10.48.00 Repairs & Maintenance 500 396 774 494 202 800 309 1,200 800 4 (00 ) 001.000.580.558.10.49.00 Miscellaneous 3,606 1,955 1,158 1,414 965 700 544 700 700 - 001.000.580.558.20.41.00 GMA (DCTED) 570 - _ 001.000.580.558.40.00.00 Training 790 441 822 595 414 680 .63 200 400 200 001.000.580.594.00.60.00 Capital Outlay 4,080 745 8,952 - Totals 105,170 160,445 186,659 175,785 171,222 128,230 69,600 125,340 131,050 5,900 2009 Actual 2011 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Revenue Change 001.000.000.345.80.00.00 Fees 10,490 3,232 5,000 5,614 7,500 5,000 (2,500) 001.000.000.345.89.00.00 SEPA Fees 483 322 1,000 1,044 1,500 1,000 (500) 10,973 3,554 6,000 6,658 9,000 6,000 (3,000) 001.000.000.342.40.00.01 Fire Marshal Ser 250 350 200 220 220 - (220) 58 Planning 2012BC.xls 2012 BUDGET GENERAL FUND CODE COMPLIANCE DEPARTMENT Salaries This line item is salaries for the Code Compliance Officer/Building Inspector 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 Inspector and 50% of the Permit Technician. Professional Services The City is required to have fire marshal services and is currently utilizing the Douglas County Fire District for those services. The Fire Chief requested payment for these services starting in 2005. The Fire Marshal indicated no increase was anticipated for 2012, and annual costs will remain at $16,300, payable quarterly. 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. 59 CITY OF EAST WENATCHEE CODE COMPLIANCE DEPARTMENT EXPENDITURES CODE COMPLIANCE 2012 BUDGET WORKSHEET - Department Head Expenditures BARS 2006 2007 2008 2009 2010 2011 2011 2011 2012 $ Numbers Description Actuals Actual Actual Actual Actual Budget 7 Months Estimate Budget Change 001.000.590.559.10.10.00 Salaries 67,237 71,274 74,759 76,234 76,472 80,000 44,496 78,000 82,000 4,000 001.000.590.559.10.20.00 Benefits 23,735 27,419 35,441 37,085 38,156 43,000 22,402 40,000 49,000 9,000 001.000.590.559.10.31.00 Office Supplies 551 1,181 629 95 1,036 600 56 200 250 50 001.000.590.559.10.31.01 Central Stores 55 97 235 - 001.000.590.559.10.32.00 Fuel Consumed 510 464 938 527 522 600 172 500 525 25 001.000.590.559.10.35.00 Small Tools & Equipment 16 - 13 - 200 99 200 200 - 001.000.590.559.10.41.00 Professional Services 35 8,150 - 001.000.590.559.10.41.01 Fire Marshal Services 12,225 16,300 8,150 16,300 16,300 16,300 12,225 16,300 16,300 001.000.590.559.10.42.01 Telephone 52 46 13 - 001.000.590.559.10.42.03 Postage 52 54 14 001.000.590.559.10.43.00 Travel 2 132 253 7 221 400 100 400 300 001.000.590.559.10.44.00 Advertising - - - - - 100 61 100 100 001.000.590.559.10.46.00 Insurance 1,190 1,001 1,566 1,673 1,851 1,700 2,000 2,200 200 001.000.590.559.10.48.00 Repairs & 6 232 868 339 - 425 309 425 400"(25)Maintenance 001.000.590.559.10.49.00 Miscellaneous 215 516 792 480 605 350 95 150 250 001.000.590.559.40.00.00 Training - 294 335 235 65 500 100 400 300 001.000.580.594.00.60.00 Capital Outlay - 373 Totals 105,830 119,434 132,143 132,988 135,228 144,175 79,915 138,075 152,025 13,950 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 1 2011 Estimate 2012 Budget $ Revenue Change 001.000.000.342.40.00.01 Fire Marshal Ser 250 64,690 350 41,248 200 46,000 220 25,522 220 46,000 200 42,000 -220 001.000.000.322.10.00.00 Building & Structure Permits (4,000) 001.000.000.345.83.00.00 Plan Checking Fees 27,619 21,622 22,000 14,686 22,000 20,000 (2,000) 001.000.000.380.00.50.00 State Surcharge (Bldg Code) 3961 478 350 185 300 325 25 92,955 63,698 68,550 40,613 68,520 62,525 (6,195) 60 Code Compliance 2012BC.xls 2012 BUDGET GENERAL FUND STORM WATER UTILITY Note: The City of East Wenatchee has the responsibility to provide maintenance and manage construction projects for the Storm Water Utility 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 Stormwater Utility (GEWSWU), whereby the GEWSWU charges an annual fee of $45.00 to City and County residents in the local 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 perceived need for these increases was the necessity to satisfy the costs to comply with the NPDES regulations related to Storm Water discharge and treatment. The City's fee for its impervious surfaces (streets) increased from $114,000 in 2009 to $130,000 in 2010, and is now $149,000 for 2011. The Storm Water Utility jointly 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 from the State to assist in compliance with the NPDES regulations. The City is represented on the Storm Water Utility by the City Engineer, Associate Engineer, and an assigned City Council Member as a "City Management Team" to provide the necessary collaboration and coordination with representatives from Douglas County to successfully manage, maintain and extend the storm water system throughout its service area. Revenue: The City records Storm Water Utility Revenue from reimbursements from the GEWSWU and from grants. Generally, revenue results from administrative services, improvement projects, construction projects and from NPDES activities. The City tracks its internal costs, as well as those incurred by bidding and incurring costs by contracting work out. Expenditures: Internal costs are predominantly incurred by Street Department personnel assigned to SWU work within the City limits, and those supplies, materials and equipment costs of doing the work. In addition to small capital projects, the City is responsible for the completion of the Canyon A SWU system in the GEWSWU service area. Budget for 2012: The SWU operational plans for 2012 are communicated on the following budget worksheets with explanations of the projects expected to be completed in 2012. 61 CITY OF EAST WENATCHEE STORM WATER UTILITY - REVENUE 2012 BUDGET WORKSHEET - Department Head BARS Numbers Description CHARGES FOR SERVICES 050.000.000.343.13.00.00 Administrative Services 050.000.000.343.13.00.20 SWU Maintenance Services Total IMPROVEMENT PROJECTS 050.000.000.343.13.00.30 Improvement Projects New BARS # Eastmont - Grant Rd to 3rd CONSTRUCTION PROJECTS: 050.000.000.343.13.00.40 Canyon A Constr Phase 2 Cnyn A SDC Phase 3 050.000.000.343.13.00.50 Canyon A Constr Phase 3 050.000.000.343.13.00.52 Canyon A Constr Phase 4 050.000.000.343.13.00.54 Cnyn A Constr Ph4 FDP Trp Cnyn A SDC Easmt to 2nd Cnyn A Consr Estmt to 2nd Retrofit 5 Catchbasins 23rd St Retrofit NPDES REVENUE 050.000.000.343.13.00.75 DOE DC NPDES Ph2 G0600351 050.000.000.343.13.00.77 DOE CEW NPDES Ph2 G1000254 050.000.000.343.13.00.79 DOE COW NPDES Ph2 G1000365 050.000.000.343.13.00.81 DOE COW NPDES Ph2 G0000366 050.000.000.343.13.00.90 EW Capacity Grant G1100038 050.000.000.343.13.00.90 Greater EW SWU NPDES O&M Allocation EW Share Comp Plan TOTAL STORM WATER UTILITY REVENUES CITY STORM WATER UTILITY 2009 2010 2011 2011 2011 Actual Actual Budget 7 Months I Estimate 46,8081 15,300 R17 - 6,450 - 150,000 26,612 1,087,000 25,000 - 32,860 217,140 200,000 220,363 38,783 50,000 50,000 3,500 2,400 114,800 100,000 20,000 62 2012 1 & 508 95 I 3,3001 7,500 I 4,200 100,000 14,000 6,000 6,000 75,000 75,000 2,235 150,000 450,000 300,000 2,417 - 10,000 190,000 180,000 50,000 50,000 (50,000 5,000 5,000 (5,000 3,961 4,000 (4,000 62,000 68,377 6,377 37,000 113,468 76,468 62,000 100,000 38,000 50,000 50,000 CITY OF EAST WENATCHEE STORM WATER UTILITY -EXPENDITURES CITY STORM WATER UTILITY 2012 BUDGET WORKSHEET -Department Head BARS Numbers Description 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $ Change SWU Maintenance 050.000.310.531.30.10.00 Salaries 8,914 14,096 14,776 32,541 050.000.310.531.31.20.00 Benefits 2,769 4,623 5,354 16,140 050.000.310.531.30.30.00 Supplies 2,010 536 4,814 2,989 050.000.310.531.30.41.00 Prof Services 289 765 6,609 050.000.310.531.30.44.00 Advertising 98 050.000.310.531.30.45.00 Rentals/Leases 6,480 326 1,784 050.000.310.531.30.47.00 Utilities 491 519 1,229 956 050.000.310.531.30.48.00 Repairs/Maint 138 13 103 050.000.310.531.30.49.00 Miscellaneous 050.000.310.594.30.60.00 Capital Outlay Total Maintenance Expenditures 21,091 20,878 26,276 61,117 SWU Administration 050.000.311.531.31.10.00 Salaries 38 8,880 9,000 4,000 (4,880) 050.000.311.531.31.20.00 Benefits 43 5,920 2,500 3,000 (2,920] 050.000.311.531.31.41.00 Prof Services 8,366 2,327 4,602 260 050.000.311.531.31.44.00 Advertising 442 500 500 050.000.311.531.31.49.00 Miscellaneous 200 276 270 500 (500) 050.000.311.531.31.51.00 InterGovtProfSvcs - 334 050.000.311.531.31.90.00 Admin-Accounting 050.000.311.594.31.60.00 Capital Outlay Total Administration Expenditures 8,566 2,937 5,314 341 15,300 12,000 7,500 (4,500) SWU Capital/Construction 050.000.312.531.32.00.00 Small Projects 14,216 100,000 19,471 76,000 100,000 050.000.312.531.32.00.05 CnynA Design Phase 2 59,315 050.000.312.531.32.00.10 CnynAROW Phase 2 72,376 050.000.312.531.32.00.12 Cnyn A SDC Phase 2 63 374 050.000.312.531.32.00.15 CnynA Constr Phase 2 432,612 26,274 050.000.312.531.32.01.05 CnynA Dsn Phase 3 3,994 33,094 050.000.312.531.32.01.12 Cnyn A SDC Phase 3 13,082 150,000 12,200 75,000 050.000.312.531.32.01.15 Cnyn A Constr Phase 3 1,087,000 615 149,000 450,000 050.000.312.531.32.02.05 Cnyn A Design Phase 4 050.000.312.531.32.02.12 Cnyn A SDC Phase 4 387 050.000.312.531.32.02.15 Cnyn A Constr Phase 4 30,809 Construct 2013 (WSDOT Delay) to Cnyn A SDC - Eastmont 2nd 3 2,860 Construct 2013 (WSDOT Delay) Cnyn A Constr - Eastmont to 2nd 217,140 63 CITY OF EAST WENATCHEE STORM WATER UTILITY- EXPENDITURES CITY STORM WATER UTILITY 2012 BUDGET WORKSHEET - Department Head BARS Numbers Description 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $ Change BARS Numbers Description 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $ Change Retrofit 5 Catch Basins 200,000 190,000 Need New BARS # Comprehensive Plan 50,000 Need New BARS # Eastmont - portion of desi n 6,000 050.000.312.531.32.30.00 Prof Services 2,116 050.000.312.531.32.41.00 Supplies 200 - 138 050.000.312.531.32.44.00 Advertising 290 050.000.312.531.32.45.00 Rentals 674 050.000.312.531.32.48.00 Rep & Maint 7,544 050.000.310.531.30.49.00 Miscellaneous 20,985 151 050.000.310.531.30.60.00 Capital Outlay - Total Construction Expenditures 2,207 22,993 581,282 120,309 1,789,011 22,097 239,211 873,012 633,801 SWU NPDES REGS 050.000.313.531.33.10.00 Salaries 2,437 105,100 38,264 50,000 105,100 050.000.313.531.33.20.00 Benefits 43,150 20,271 27,000 43,150 050.000.313.531.33.30.00 Supplies 12,126 2,506 10,950 19,822 40,000 20,000 9,050 050.000.313.531.33.31.00 Office Supplies 24 805 5 050.000.313.531.33.35.00 Small Tools & Equipment 2,172 050.000.313.531.33.40.00 Training 495 6,000 4,000 (2,000) 050.000.313.531.33.41.00 Professional Svcs 9,643 6,405 2,100 1,000 2,100 050.000.313.531.33.42.00 Postage 1,100 500 (600) 050.000.313.531.33.43.00 Travel 2,000 1,000 (1,000) 050.000.313.531.33.44.00 Advertising 232 91 2,000 1,000 (1,000) 050.000.313.531.33.49.00 Miscellaneous 9,942 3,890 2,621 3,000 3,890 - 050.000.313.531.33.51.01 DEOE Ms4 Annual Permit 1,453 3,050 1,453 3,000 3,105 55 Equipment Rental 27,000 1,339 4,000 22,000 (5,000) Contracted Services 66,000 27,595 60,000 66,000 InterGpvt Services 30,000 5,000 (25,000) Monitoring 5,000 5,000 050.000.313.531.33.90.00 Administration Total NPDES Expenditures 34,404 13,927 307,340 111,370 188,000 281,845 (25,495) 050.000.315.531.341.00 Annual Utility Charge 114,100 114,065 114,065 130,360 131,500 148,725 149,400 Grand total SWU Expenditures 145,964 160,873 761,341 326,054 2,243,151 133,467 587,936 1,311,757 603,806 64 CITY OF EAST WENATCHEE STORM WATER UTILITY -EXPENDITURES CITY STORM WATER UTILITY 2012 BUDGET WORKSHEET - Department Head BARS 2007 Numbers Description Actual 2008 2009 2010 2011 2011 2011 Actual Actual Actual Budget 7 Months Estimate 2012 Budget $ Change Notes for 2012 Budget Small Projects - chronic flooding / stormwater problems (Citywide) - 3rd & Jarvis - $50,000 - Dry Well project (Survey work complete) - Ashland / Astor - $50,000 - Dry Well Project(s) - Dolfay - $25,000 - Extend stormwater conveyance line to 11th street (Survey work complete) 10th Street & Grover - $20,000 -Culvert improvements at intersection (steep shoulders, deep ditches, extend culvert and inprove intersection) - Driveway culvert replacements - Citywide at problem areas - Gail - $25,000 - Frame and Grate adjustment on Valley Mall Parkway - $8,000 Clean / weed abatement for ponds - $7,500 (on going annually) Canyon A Phase 3 - $713,000 = latest engineer's estimate from WSDOT including sales tax and engineering. Cnyn A Constr - Eastmont to VMP - $217,140 + 15% for construction engineering (Construction in 2013) Retrofit 5 Catch Basins - $112,500 grant + $37,500 match = $150,000 (Project titled "23rd Street Retro Project" is a Douglas County Project, remove from EW list) NPDES 2012 DOE NPDES Permit - 4% increase for 2012 and on NPDES Salaries - Previous years, the majority of the salary expense have been for the maintenance of our conveyance lines and recently included street sweeping activities. This account has also covered the cost for the development of our stormwater program managing our NPDES Requirements. Each year the maintenance activities related to NPDES become more involved, the development of our O&M manual and construction/post construction requirements require more maintenance frequency, inspections, record keeping and reporting to the Department of Ecology. NPDES Supplies * Spill kits and supplies * Computer equipment & software for Inventory System * Sweeper brooms and brushes * Vactor tools, nozzles and equipment * small tools and equipment for weed control and pond maintenance * Misc products and material: pipe, curb inlets, frame and grates, mortar, concrete, rock * parts for mechanical repairs to sweeper and equipment * Specialized equipment rental for projects (bull dozer, excavator) * The ER&R cost for the vactor truck is covered under this account, however, the City sends a tracking report to Douglas County for the hours used and the County does a fund transfer from the NPDES maintenance cost to the County ER&R fund. The City will need to change the process for the Vactor billing in order to track our expense more appropriately. Professional Service - Assistance with treatment design for retro and drywell projects Contracted Services - Pond maintenance and repair * Catch basin markers (VMP, Grant Road, Briarwood, Summerhill) * Retro projects for problem areas, * Facility improvements for Pollution Prevention * Assistance by Erlandsen for Stormwater Inventory & GIS * Contracted maintenance repairs (City Streets) Inter Governement - GIS work by County (Todd) 65 2012 BUDGET STREET FUND REVENUES Property Tax The Street Fund is allocated a portion of property tax receipts. For 2012, $200,000 has been budgeted, the same as last year. Sales &Use Tax The Street Fund is also allocated a portion of sales tax receipts. For 2012, $250,000 has been budgeted. Licenses & Permits Street and curb permits are expected to be the same in 2012. Intergovernmental Revenue Street Fuel Excise Tax is received from the State and is limited in use for street maintenance. $260,000 has been budgeted for 2012. Miscellaneous Sales tax interest is budgeted at $500 for 2012. This is an allocation of a portion received from the State each month, and is lower because of the decline in effective interest rates. 66 CITY OF EAST WENATCHEE STREET FUND 101 REVENUES STREET FUND REVENUES 2012 BUDGET WORKSHEET BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Change 101.000.000.308.00.00.00 Beginning NC&I 57,175 50,684 101,977 45,082 25,949 117,782 93,714 93,714 37,014 Totals 57,175 50,684 101,977 45,082 25,949 117,782 93,714 93,714 37,014 (56,700) Taxes 101.000.000.311.10.00.00 Property Tax 99,519 157,317 244,446 200,000 200,000 200,000 125,000 200,000 200,000 101.000.000.311.10.00.01 Contingency Property Tax 101.000.000.313.10.00.00 Sales & Use Tax 300,261 478,650 488,566 469,064 425,000 275,000 105,000 250,000 250,000 Totals 399,780 635,967 733,012 669,064 625,000 475,000 230,000 450,000 450,000 Licenses & Permits 101.000.000.322.40.00.00 Street & Curb Permits 6,980 7,552 3,528 2,130 2,053 1,500 765 1,800 1,500 (300) Totals 6,980 7,552 3,528 2,130 2,053 1,500 765 1,800 1,500 (300) Intergovernmental Revenue 101.000.000.336.00.87.00 Street Fuel Excise 247,511 252,637 262,848 251,701 252,553 245,000 152,896 268,000 260,000 (8,000) ) 101.000.000.336.00.88.00 Arterial Street Excise Fuel Tax Totals 247,511 252,637 262,848 251,701 252,553 245,000 152,896 268,000 260,000 (8,000) Miscellaneous 101.000.000.313.14.00.00 Storm Wtr Utility 36,196 101.000.000.360.00.00.00 Miscellaneous 6,436 221 966 455 177 101.000.000.361.00.00.00 Interest Earnings 8,693 2,838 987 - 25 101.000.000.361.40.00.00 Sales Tax Interest 1,805 2,347 2,248 2,012 1,013 1,200 238 500 500 101.000.000.363.00.00.00 Insurance Claims Pym 4,583 40,278 - - Totals 21,517 45,684 40,397 2,467 1,190 1,200 263 500 500 Grand Total Current Revenue 675,788 941,840 1,039,785 925,362 880,796 722,700 383,924 720,300 712,000 (8,300) Total Available Resources 732,963 992,524 1,141,762 970,44411 906,745 840,482 477,638 814,014 749,014 (65,000) 6% 2012 BUDGET STREET FUND EXPENDITURES 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 continue at current levels, except that a portion will now be charged to the Storm Water Utility as an NPDES expense. These expenditures include street cleaning which are now considered a "good housekeeping" practice under NPDES regulations. Administration Costs in these categories include all other costs of the Street Department, including the Director 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, can be allocated to the maintenance categories above to better reflect the true costs of these activities. M CITY OF EAST WENATCHEE STREET FUND101 EXPENDITURES STREET FUND EXPENDITURES 2012 WORKSHEET BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Change Total Available Resources 732,963 992,524 1,141,762 970.444 906,745 840,482 477,638 814,014 749,014 (65,000) Maintenance 101.000.420.542.30.00.00 Roadway 17,166 20,769 13,087 49,005 59,115 40,000 23,459 40,000 36,200 (3,800) 101.000.420.542.40.00.00 Storm Drainage 1,094 101.000.420.542.60.00.00 Traffic & Pedestrian Services 6,119 4,203 2,371 1,350 101.000.420.542.61.00.00 Sidewalks 3,077 2,806 11,666 8,381 4,688 14,000 233 500 3,100 2,600 101.000.420.542.62.00.00 Special Purpose 6,578 5,288 5,224 5,202 9,864 15,000 5,000 6,000 10,200Paths 4,200 101.000.420.542.63.00.00 Street Lighting 40,618 40,337 53.937 47,593 56,970 50,000 26,695 45,000 45,500 500 101.000.420.542.64.00.00 Traffic Control Devices 96,256 88,958 121,271 89,160 116,804 145,000 86,285 125,000 123,100 (1,900) 101.000.420.542.65.00.00 Parking Facilities 894 464 107 384 1,324 2,000 551 1,500 4,050 2,550 101.000.420.542.66.00.00 Snow &Ice Control 68,671 72,315 85,778 71,852 107,620 120,000 39,948 105,000 82,100 (22,900) 101.000.420.542.67.00.00 Street Cleaning 37,162 43,264 33,482 27,420 38,256 15,000 16,310 5,000 (5,000) 101.000.420.542.70.00.00 Roadside 94,404 143,840 170,194 126,018 158,484 130,000 $5,933 175,000 145,000 (30,000) 101.000.420.542.75.00.00 City Parks 4,278 49,666 75,000 44,727 75,000 57,400 (17,600) 101.000.420.542.90.00.00 Maintenance Administration 51,240 52,609 64,293 63,652 27,089 30,000 13,622 25,000 26,200 1,200 Totals 422,186 474,851 560,134 495,316 631,230 636,000 342,763 603,000 532,850 (70,150) Administration 101.000.430.543.30.00.00 General Services 16,907 17,352 24,355 18,135 21,152 15,000 567 22,000 24,800 2,800 101.000.430.543.50.00.00 Facilities 4,010 62,118 25,381 11,308 10,091 10,000 7,203 15,000 20,300 5,300 101.000.430.543.60.00.00 Training 3,467 4,397 5,218 2,886 6,406 5,500 5,918 10,000 6,150 (3,850) 101.000.430.543.90.49.00 Miscellaneous 214,303 304.538 9,000 8,179 4,825 4,000 811 2,000 2,000 101.000.430.543.90.49.10 Misc Salaries - 102,266 92,594 66,256 75,000 36,931 70,000 75,000 5,000 101.000.430.543.90.49.20 Street Benefits 201,351 187,491 71,672 45,000 24,137 45,000 57,000 12,000 101.000.430.596.00.60.00 Capital Outlay 15,332 27,291 54,912 14,521 1,398 15,000 9,962 10,000 10,000 Totals 254,020 415,696 422,483 335,114 181,800 169,500 85,529 174,000 195,250 21,250 Grand Totals All 676,205 890,547 982,616 830,430 813,030 805,500 428,292 777,000 728,100 (48,900) Ending NC & 1 56,758 101,977 159,146 140,014 93,715 34,982 49,346 37,014 20,914 (16,100) Notes: Update for 2012 Roadway - Patching + Crackseal Traffic & Pedestrian Services - not needed - use Traffic Control Devices Special Purpose Paths - $5,000 annual maintenance fee to Eastmont Metropolitan Parks + fence repair and other improvements Traffic Control Devices - Signals, Signs, Striping Roadside - Weed & vegetation control, regrading shoulders. This fund used to include expenses for the gardens - moved to City Parks City Parks - Includes maintenance of Japanese gardens Maintenance Administration - Portion of Brandon's salary that is not charged to SWU Misc Salaries - overtime and compensatory time General Services - Insurance Facilities - Power and water to salt shed + general repairs 69 2012 BUDGET COMMUNITY DEVELOPMENT GRANTS FUND Revenues and expenditures associated with Community Development Grants are included for a Community Development Block Grant under a US Department of Housing and Urban Development allocation of funds for housing, community and economic development activities and assistance for low -and moderate -income persons and special populations. Time and materials by the Community Development Department and professional service support are segregated in this fund, and billed for reimbursement under this grant. 70 CITY OF EAST WENATCHEE COMMUNITY DEVELOPMENT GRANTS FUND102 COMMUNITY DEVELOPMENT GRANTS 2012 BUDGET WORKSHEET - Department Head Description 2007 Actual 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 9 Months 2011 Estimate 2012 Budget $$$$ Change Revenues 102.000.000.308.00.00.00 Beginning NC&I 20,931 2,208 8,239 2,034 2,034 6,093 6,093 27,752 (21,659) Totals 20,931 2,208 8,239 2,034 2,034 6,093 6,093 27,752 (21,659) 102.000.000.313.10.00.00 Allocated Sales & Use Tax Revenue 10,000 102.000.000.334.03.11.00 DOE - NPDESPhasell 28,199 102.000.000.334.03.12.00 DOE - Shoreline Master Program 6,556 102.000.000.334.04.21.00 CTED - Growth Management Act 24,000 - 102.000.000.334.04.30.00 HUD CD Block Grant 98,418 24,329 24,329 201,478 (177,149) 102.000.000.345.89.00.01 SMP - DCT&LS Reimbursement - 102.000.000.397.00.00.00 Operating Transfer In 30,000 j (30,000) _ 102.000.000.360.00.00.00 Miscellaneous 102.000.000.361.00.00.00 Interest Earnings 4,107 24 - Total Revenue 28,107 6,580 28,199 30,000 98,418 (5,671) 24,329 201,478 (177,149) Resources Available 49,038 8,788 36,438 32,034 100,452 422 30,422 229,230 (198,808) Expenditures SMP Professional Services 1,155 SMP Office Supplies 6 138 102.000.000.558.21.10.00 CDBG Salaries 13,270 14,000 1,400 7,559 (6,159) 102.000.000.558.21.10.00 CDBG Benefits 387 4,650 420 3,087 (2,667) 102.000.000.558.21.31.00 CDBG Office Supplies 120 16 24 762 300 102.000.000.558.21.41.00 CDBG Professional Services 15,175 333 23,238 1,000 440 440 440 CDBG Telephone 61 102.000.000.558.21.42.03 CDBG Postage 507 - 250 60 150 (90) 102.000.000.558.21.44.00 CDBG Advertising 373 182 1,000 201 350 450 (100) 102.000.000.558,21.49.00 CDBG Miscellaneous 200 102.000.000.558.21.50.00 CDBG - Capital Outlay Sidewalks 77,018 92 (99,792) CDBG - Housing Program Costs 00 M45,000 45,000) CDBG - Capital Outlay Downtown (45,000) CDBG Reimburse DCT&LS NPDES Salaries 2,437 NPDES Benefits NPDES Supplies 2 12,126 NPDES Small Tools NPDES Office Supplies/Copies 8,943 NPDES Training 999 NPDES Professionsl Services 9,643 1,760 NPDES Postage 1 NPDES Travel NPDES Advertising 232 NPDES Miscellaneous Operating Transfer Out 15,834 _ Totals 46,829 549 34,404 25,942 98,418 641 2,670 201,038 (198,368) Ending NC&I 2,209 8,239 2,034 6,092 2,034 (219) 27,752 28,192 (440) 71 2012 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 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 REVENUES Library Services This revenue is paid to the City for contracted building use and maintenance reimbursement from the North Central Regional Library District. Reimbursement payments are received in June and November of each year. EXPENDITURES 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. 72 V11 r yr cAJI vvc AI 1.11cc LIBRARYFUND112 LIBRARY FUND 2012 BUDGET Description 2006 Actuals 2007 Actuals 2008 2009 Actual Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $ Chg Beginning NC&I 3,271 4,452 5,448 6,399 7,017 6,681 5,673 5,673 5,023 Totals 3,271 4,452 5,448 6,399 7,017 6,681 5,673 5,673 5,023 (650) Revenues Library Services 2,500 2,500 2,500 2,750 2,750 2,750 1,375 2,750 3,000 250 Interest Earnings 151 190 65 Total Revenue 2,651 2,690 2,565 2,750 2,750 2,750 1,375 2,750 3,000 250 Resources Available 5,922 7,142 8,013 9,149 9,767 9,431 7,048 8,423 8,023 (400) a Expenditures Salaries 279 480 68 Benefits 99 142 17 Professional Services 659T259500 1,065 1,600 1,600 Utilities 1,048 1,038 1,529 1,538 1,186 1,500 1,500 Miscellaneous 44 34 - 10 22 300 400 100 Total Expenditures 1,470 1,694 1,614 2,207 4,019 3,600 2,273 3,400 3,500 100 Ending NC&I 4,452 5,448 6,399 6,942 5,748 5,831 4,775 5,023 4,523 (500) Note: The agreement with the North Central Regional Library District calls for an increase from $2,750 to $3,000 annually in cost reimbursement to offset the City's costs for the allocated space, maintenance and utility costs. 73 2012 BUDGET HOTEL/MOTEL TAX FUND Note: Hotel/Motel Taxes are collected by the State and remitted to the City. A portion is allocated to the Events Fund 117 to support its tourism and recreation activities, and a portion is allocated for payment to the Visitors and Convention Bureau to support their activities. The City of Wenatchee interlocal agreement expired at the end of 2010, and those funds have been re -directed to the Events Fund 117. REVENUES/EXPENDITURES First 2% Tax Retained by the City to support the activities of the Events Fund 117. 60% of Second 2% Tax Retained by the City to support the activities of the Events Fund 117 40% of Second 2% Tax Per contract, remitted monthly to the Wenatchee Valley Visitor & Convention Bureau. 80% of Third 2% Tax Per contract, remitted monthly to the Wenatchee Valley Visitor & Convention Bureau. 20% of Third 2% Tax Retained by the City to support the activities of the Events Fund 117. 74 CITY OF EAST WENATCHEE /gyp /� HOTEL/MOTEL TAX FUND 113 H01T EUMTAX AX FUN 2012 BUDGET WORKSHEET BARS Numbers Description 2006 Actuals 2007 Actual 2008 2009 Actual Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Change Revenues 113.000.000.308.00.00.00 Beginning NC&I 16,158 16,900 16,227 18,843 9,418 19,017 16,777 16,777 16,878 101 Totals 16,158 16,900 16,227 18,843 9,418 19,017 16,777 16,777 16,878 101 Revenues 113.000.000.313.30.00.00 1st 2% Tax 33,741 19,139 - - 113.000.000.313.30.01.00 60% of 2nd 2% Tax 20,245 25,508 25,849 26,094 26,533 - (A) 113.000.000.313.30.02.00 40% of 2nd 2% Tax 13,496 17,005 17,233 17,396 17,689 18,000 7,102 15,700 16,000 300 113.000.000.313.30.03.00 80% of 3rd 2% Tax 26,993 34,010 35,386 34,793 35,377 33,000 14,204 30,700 31,000 300 113.000.000.313.30.04.00 20% of 3rd 2% Tax 6,748 3,828 - - 1,463 1,463 (1,463) 113.000.000.361.00.00.00 Interest Earnings 4,740 846 137 Total Revenue 105,963 100,336 78,605 78,283 79,599 51,000 22,769 47,863 47,000 (863) Total Resources Available 122,121 117,236 94,832 97,126 89,017 70,017 39,546 64,640 63,878 (762) Expenditures 113.000.000.557.30.41.00 1st2% Tax 49,000 1,930 113.000.000.557.30.41.01 60% of 2nd 2% Tax 15,005 22,933 25,704 34,064 26,533 1,462 1,462 (A) 113.000.000.557.30.41.02 40% of 2nd 2% Tax 14,707 16,582 16,761 18,801 15,236 18,000 6,569 15,600 16,000 400 113.000.000.557.30.41.03 80% of 3rd 2% Tax 26,509 33,163 33,524 34,844 30,472 33,000 13,138 30,700 31,000 300 113.000.000.557.30.41.04 20% of 3rd 2% Tax Operating Transfer Out to EWEB 26,000 Total Expenditures 105,221 100,608 75,989 87,709 72,241 51,000 21,169 47,762 47,000 (762) 113.000.000.508.00.00.00 Ending NC&I 16,900 16,628 18,843 9,417 16,776 19,017 18,377 16,878 16,878 (A) The agreement to provide this funding to the City of Wenatchee Convention Center expires in 2010. In 2011 and beyond, this revenue will be receipted into the Events Fund #117 to support events funding. Note: Revenue is expected to be somewhat reduced in 2012 based upon the current pattern, and continuation of the decline experienced over the last 3 years. Expenditures for 2011 include continued support of the Wenatchee Valley Visitors & Convention Bureau. 75 2012 BUDGET DRUG FUND REVENUES The City allocates a portion of Municipal Court Receipts to this fund. During 2010, the City also determined to remove forfeited property (cash) from its Police repository and deposit these funds to be used for purposes consistent with this fund. EXPENDITURES The City spends a portion of these funds in support of drug related programs. 76 CITY OF EAST WENATCHEE DRUG FUND 114 DRUG FUND 2012 Budget BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Actual 1 2011 2011 7 Months 2011 2012 $$ Budget Estimate Budget Change Revenues 114.000.000.308.00.00.00 Beginning NC&I 3,696 4,899 6,001 10,584 2,990 7,421 4,168 4,168 5,068 900 Total 3,696 4,899 6,001 10,584 2,990 7,421 4,168 4,168 5,068 114.000.000.356.50.03.00 Drug Buy 887 709 1,307 2,479 1,677 2,000 615 900 1,000 100 114.000.000.357.30.01.00 Restitution 100 155 8 71 114.000.000.360.00. 00. 00 Miscellaneous 4 21 - 967 114.000.000.361.00.00.00 Interest Earnings 211 217 77 114.000.000.367.00.00.00 Contributions 1,221 1,311 - 114.000.000.369.30.00.00 Forfeited Property 5,632 Transfer in From D.A.R.E. Fund 1,970 #VALUE! Total Revenue 1,202 1,102 4,583 4,828 7,309 2,000 615 900 1,000 100 Total Resources Available 4,899 1 6,001 10,5841 15,412 10,299 9,421 4,783 5,0681 6,068 1,000 Expenditures 114.000.000.566.00.49.00 Miscellaneous - - - 3,406 1,000 3,000 1,000 1,000 114.000.000.566.00.49.05 Stare Share - Prop 563 114.000.000.596.00.60.00 Capital Outlay 9,017 4,568 Total Exp 12,423 6,131 3,000 1,000 1,000 115.000.000.508.00.00.00 Ending NC&I 4,899 6,001 10,584 2,989 4,168 6,421 4,783 5,068 5,068 Note: No change from 2011. The Police Chief is considering utilizing a portion of these funds for a minor capital asset purchase. 77 2012 BUDGET CRIMINAL JUSTICE FUND RF.VF.NITFS Other Revenues 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 Outlay 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 2012 funds will be used to purchase a police vehicle. Miscellaneous Miscellaneous Criminal Justice related expenditures. W CITY OF EAST WENATCHEE CRIMINAL JUSTICE FUND 116 CRIMINAL JUSTICE FUND 2012 BUDGET WORKSHEET BARS Numbers Description 2006 Actuals 2007 Actual 2008 2009 Actual Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $$ Change Revenues 116.000.000.308.00.00.00 Beginning NC&I 24,141 31,925 36,380 41,716 45,602 48,466 36,329 36,329 6,979 (29,350) Totals 24,141 31,925 36,380 41,716 45,602 48,466 36,329 36,329 6,979 116.000.000.313.10.00.00 Sales & Use Tax 30,000 116.000.000.334.06.90.01 WASPC Grant 3,000 116.000.000.336.06.20.00 High Crime 23,110 24,674 25,642 26,920 26,881 26,000 13,631 13,600 14,000 400 116.000.000.336.06.21.00 Population 2,023 2,254 2,368 2,495 2,594 2,500 2,025 2,850 2,750 (100) 116.000.000.336.06.26.00 Special Programs 7,985 8,800 9,132 9,527 9,828 9,300 8,025 10,700 10,500 (200) 116.000.000.336.06.30.00 EWPD Unclaimed Monies 1,269 116.000.000.361.00.00.00 Interest Earnings 1,499 504 - - Total Revenue 34,617 35,728 37,646 38,942 43,572 67,800 23,681 27,150 27,250 100 Total Resources Available 58,759 67,653 74,026 80,658 89,174 116,266 60,010 63,479 34,229 (29,250) Expenditures 116.000.000.594.00.60.00 Capital Outlay 26,384 32,312 32,312 35,056 49,640 75,000 30,708 56,500 32,000 (24,500) 116.000.000.594.00.60.01 Cap WASPC Equip 3,205 116.000.000.594.00.60.49 Miscellaneous 450 250 - Total Expenditures 26,834 32,562 32,312 35,056 52,845 75,000 30,708 56,500 32,000 (24,500) 116.000.000.508.00.00.00 Ending NC&I 31,925 35,091 41,714 45,602 36,329 41,266 29,302 6,979 2,229 (4,750) Note: Revenue for 2012 will continue at about the same level. Spending for 2011 included the normal payment of police vehicles, and the Council approved cash -out of two leases. Two other leases were cashed -out in the Law Enforcement Department of the General Fund. 2012 includes the purchase of one police vehicle. 79 2012 BUDGET EAST WENATCHE EVENTS FUND Note: This will be the fourth 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 other 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. The Sprint Boat Races in 2010 and 2011 have been discontinued. 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 This 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 current recession and experienced a reduction in sponsorship fees. The expectation for 2012 is the same. Consequently, the City allocates a portion of Sales-& Use Taxes during the year to supplement the financial needs of this fund. $20,000 was allocated for 2009, $102,000 was allocated for 2010, $108,000has been allocated for 2011, and $69,000 for 2012. The Events Coordinator position is full time. Costs for a part-time assistant were added in 2010 to more effectively meet the demands for event planning and support, and will continue in 2012. CITY OF EAST WENATCHEE EAST WENATCHEE EVENTS BOARD FUND 117 EVENTS FUND REVENUE 2012 BUDGET REVENUES BARS Numbers Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 8 Months 2011 Estimate 2012 Budget Revenues 117.000.100.308.00.00.00 Beginning NC&I 33,350 20,376 3,123 1,316 743 743 6,500 Totals 33,350 20,376 3,123 1,316 743 743 6,500 117.000.100.313.30.00.00 1st 2% Tax 43,082 43,491 47,027 77,500 21,315 32,000 39,500 117.000.100.313.30.00.04 20% of 3rd 2% Tax 7,697 8,698 8,844 8,300 15,589 23,000 31,000 117.000.100.315.00.00.00 EWED Alloc S&U Tax 20,000 135,800 108,000 47,500 108,000 69,000 117.000.100.360.00,00.00 EWEB Misc Revenue 1,947 - - - 117.000.100.361.00.00.00 Interest Earnings 362 - - Total 53,088 72,189 191,671 193,800 84,404 163,000 139,500 117.000.200.347.40,02.01 EEH Admission Fees 1,306 1,550 1,509 1,500 1,822 1,822 1,700 117.000.200.360.00.00.02 EEH Misc Revenue 278 292 369 250 65 65 117.000.200.367.00.00.02 EEH Donations 210 - 117.000.200.367.19.00.02 EEH Sponsorships 120 - Total 1,584 2,172 1,878 1,750 1,887 1,887 1,700 117.000.300.321.70.12.02 CC Parade/Car Show 8,850 8,890 8,440 8,500 9,320 9,320 8,500 117.000.300.321.70.12.03 CC Vendor Fees 585 600 700 600 775 775 600 117.000.300.341.70.12.00 CC Merchandise Sales 2,313 2,442 2,349 2,250 5,964 5,964 2,250 117.000.300.360.00.00.12 CC Misc Revenue 283 54 - 117.000.300.367.11.00.12 CC Donations 117.000.300.367.19.00.12 CC Sponsorships 7,000 4,000 4,350 9,500 9,400 9,400 9,400 Total 19,031 15,986 15,839 20,850 25,459 25,459 20,750 117.000.400.321.70.11.02 W&W Car Show 2,775 3,275 2,959 2,750 340 2,750 2,750 117.000.400.321.70.11.03 W&W Motorcycle Fest 1,580 1,453 600 1,000 1,000 117.000.400.321.70.11.04 W&W Vendor Fees 1,810 2,037 1,175 1,000 995 1,000 1,000 117.000.400.341.70.11.00 W&W Merch Sales 5,463 4,082 3,736 4,000 398 4,000 3,500 117.000.400.347.40.11.01 W&W BBQ - - 117.000.400.347.40.11.02 W&W Bingo - - - 117.000.400.347.40.11.03 W&W Parade Amusements 2,532 2,164 2,850 2,200 2,200 2,200 117.000.400.347.40.11.04 W&W Poker Run/Walk - 297 - 117.000.400.360.00.00.11 W&W Misc Revenue 1,392 243 585 36 300 117.000.400.367.11.00.11 W&W Donations 4 200 - 117.000.400.367.19.00.11 W&W Sponsorships 26,395 11,500 5,200 8,000 2,200 5,000 3,000 117.000.400.367.19.00.13 Sched of Events Brochure 6,400 6,078 5,000 5,550 5,600 5,000 117.000.400.367.19.00.14 W&W Ad Reimb 452 452 450 450 450 Total 41,951 32,103 23,635 24,400 9,519 21,300 18,900 117.000.500.360.00.00.01 Christmas Misc Rev - 103 58 117.000.500.367.11.00.01 Christmas Donations 117.000.500.367.19.00.01 Christmas Sponsorships 133 Total 133 103 58 117.000.600.367.19.00.01 75th Birthday Celebration 2,224 Project 98802 117.000.530.367.19.00.10 Sprint Boat Race Revenue 27,467 65,000 36,554 36,828 117000.530.367.19.00.20 Prize Purse Sponsorships 1,500 5,000 2,500 2,500 117.000.830.367.19.00.30 Other Race Revenue 5,751 5,000 2,000 2,000 Total 34,718 75,000 41,054 41,328 Total Revenue 115,787 122,553 270,023 315,800 162,323 252,974 180,850 Total Resources Available 149,137 142,929 273,146 317,116 163,066 253,717 187,350 81 CITY OF EAST WENATCHEE EAST WENATCHEE EVENTS BOARD FUND 117 EWEB EXPENDITURES 2012 BUDGET - EXPENDITURES BARS Numbers Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 8 Months 2011 Estimate 2012 Budget 117.000.000.557.00.10.00 117.000.000.557.00.10.00 EWEB Salaries 4,422 8,257 76,652 75,000 55,274 78,000 60,000 Street Dept Support 15,000 117.000.000.557.00.10.01 117.000.000.557.00.10.01 Christmas Salaries 4,422 4,535 117.000.000.557.00.10.02 117.000.000.557.00.10.02 EEH Salaries 4,422 4,535 117.000.000.557.00.20.00 117.000.000.557.00.20.00 EWEB Benefits 2,046 2,469 30,010 33,500 21,116 32,000 28,500 Street Dept Support 8,000 117.000.000.557.00.20.01 117.000.000.557.00.20.01 Christmas Benefits 2,047 2,138 117.000.000.557.00.20.02 117.000.000.557.00.20.02 EEH Benefits 2,047 2,138 117.000.000.557.30.10.11 117.000.000.557.30.10.11 W&W Salaries 17,688 18,139 - 117.000.000.557.30.10.12 117.000.000.557.30.10.12 CC Salaries 13,266 13,604 117.000.000.557.30.20.11 117.000.000.557.30.20.11 W&W Benefits 8,186 8,553 117.000.000.557.30.20.12 117.000.000.557.30.20.12 1 CC Benefits 6,140 6,415 Total EWEB Salaries and Benefits 64,686 7%783 106,662 108,500 76,390 110,000 111,500 117.000.000.557.00.25.00 117.000.100.557.00.25.00 EWEB Marketing- Regional Tourism 1,500 1,500 - 2,000 2,000 117.000.100.557.00.27.00 City Theme 7,191 6,516 1,660 10,000 (1,898) 10,000 117.000.000.557.00.32.00 117.000.100.557.00.32.00 EWEB Fuel Consumed 12 - - 25 48 15 50 117.000.000.557.00.35.00 117.000.100.557.00.35.00 EWEB Smalls Tools 54 100 22 100 100 100 117.000.000.557.00.42.00 117.000.100.557.00.42.00 EWEB Training 250 250 500 117.000.000.557.00.41.00 117.000.100.557.00.41.00 EWEB Professional Services 2,053 - - 117.000.000.557.00.42.00 117.000.100.557.00.42.00 EWEB Telephone - - 116 305 - 117.000.000.557.00.42.03 117.000.100.557.00.42.03 EWEB Postage 18 - 59 117.000.000.557.00.43.00 117.000.100.557.00.43.00 EWEB Travel 204 2,935 2,034 3,000 584 11000 1,000 117.000.000.557.00.44.00 117.000.100.557.00.44.00 EWEB Advertising - 117.000.000.557.00.48.00 117.000.100.557.00.48.00 EWEB Repairs 110 103 58 125 125 1,000 117.00.000.557.00.49.00 117.000.100.557.00.49.00 EWEB Misc 647 333 307 300 142 300 450 117.000.100.596.00.60.00 EWEB Capital Outlay 513 587 5,888 300 161 300 1300 117.000.000.557.00.46.00 117.000.105.557.00.46.00 EWEB Insurance 638 1,311 2,104 2,100 1,700 1,700 2,100 117.000.000.557.00.31.03 117.000.110.557.00.31.03 EWEB Central Stores 323 - - 150 150 117.000.000.557.00.31.00 117.000.115.557.00.31.00 EWEB Office Supplies 314 475 1,877 1,000 71 250 1,000 EWEB General Expenditures 13,577 13,860 14,125 19,350 1,113 4,040 19,650 117.000.000.557.00.35.02 117.000.200.557.00.35.02 EEH Small Tools 14 162 350 81 100 350 117.000.000.557.00.41.02 117.000.200.557.00.41.02 EEH Professional Services 464 - - - 117.000.200.557.00.42.05 Easter Postage 117.000.000.557.00.44.02 117.000.200.557.00.44.02 EEH Advertising - 986 1,062 1,100 332 350 500 117.000.000.557.00.49.02 117.000.200.557.00.49.02 EEH Misc 354 824 849 1,000 749 750 1,000 117.000.200.594.00.60.02 Easter Capital Outlay Easter Event Expenses 818 1,824 2,073 2,450 1,162 1,200 1,850 82 EWEB EXPENDITURES EWEB Fund 117 2011 Budget - Pane 2 BARS Numbers Description 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget 117.000.300.557.30.32.12 CC Fuel Consumed 499 117.000.000.557.30.35.12 117.000.300.557.30.35.12 CC Small Tools & Equipment 3,222 3,062 3,340 3,000 2,631 2,700 3,000 117.000.300.557.30.34.11 CC Merch for Resale 2761 6,686 6,700 6,500 117.000.000.557.30.41.12 117.000.300.557.30.41.12 CC Professional Services 1,412 - 117.000.000.557.30.42.14 117.000.300.557.30.42.14 CC Postage 662 571 23 45 45 - 117.000.000.557.30.44.12 117.000.300.557.30.44.12 CC Advertising 3,144 2,621 4,430 4,000 2,000 2,000 3,000 117.000.000.557.00.49.12 117.000.300.557.00.49.12 CC Misc 1,125 4,297 2,071 3,000 3,639 3,700 3,500 117.000.300.594.30.60.12 CC Capital Outlay - Classy Chassis Event Expenses 9,565 10,551 1 10,639 10,000 15,001 15,145 16,000 117.000.000.557.00.49.11 117.000.400.557.00.49.11 W&W Misc 318 522 41 117.000.000.557.30.32.11 117.000.400.557.30.32.11 W&W Fuel consumed 126 - - - 117.000.000.557.30.34.11 117.000.400.557.30.34.11 W&W Event Merch for Resale 8,528 7,904 6,632 5,000 528 5,000 6,000 117.000.000.557.30.35.11 117.000.400.557.30.35.11 W&W Small Tools 5,133 5,201 4,216 4,500 4,500 4,500 117.000.000.557.30.41.11 117.000.400.557.30.41.11 W&W Professional Services 7,513 - 117.000.000.557.30.42.13 117.000.400.557.30.42.13 W&W Postage 556 585 804 13 100 117.000.000.557.30.44.11 117.000.400.557.30.44.11 W&W Advertising 7,796 8,111 3,902 8,000 294 8,000 4,000 117.000.000.557.30.49.11 117.000.400.557.30.49.11 W&W Miscellaneous 14,223 9,564 5,375 3,000 5,287 5,300 3,000 117.000.400.557.30.49.13 W&W Events Brochure 4,600 4,604 5,000 4,600 5,000 117.000.400.594.30.60.11 W&W Capital Outlay Wings & Wheels Event Expenses 44,193 36,487 25,574 25,500 6,122 27,500 22,500 117.000.000.557.00.35.01 117.000.500.557.00.35.01 Christmas Small Tools 472 1,281 975 1,250 48 1,250 1,250 117.000.500.557.00.40.05 Christmas Events & Decs 164 2,250 2,611 2,000 932 2,000 3,000 117.000.000.557.00.41.01 117.000.500.557.00.41.01 Christmas Professional Services 117.000.000.557.30.42.04 117.000.500.557.00.42.04 Christmas Postage - 117.000.000.557.00.44.01 117.000.500.557.00.44.01 Christmas Advertising 1,806 2,192 1,911 2,500 82 2,000 2,000 117.000.000.557.00.49.01 117.000.500.557.00.49.01 Christmas Misc 699 578 475 550 550 550 117.000.500.594.00.60.01 Christmas Capital Christmas Event Expenses 3,141 6,301 5,972 6,300 1,062 5,800 6,800 117.000.530.557.00.30.00 Boat Race Permits 17,110 117.000.530.557.30.00.10 USSBA Fee 8,0001 16,000 16,000 16,000 117.000.530.557.30.00.15 Land Lease Cost 2,604 15,000 15,000 15,000 117.000.530.557.30.00.20 Track Water & Mtls 10,414 5,000 455 2,570 117.000.530.557.30.00.25 Revenue Sharing Cost 598 6,500 1,619 2,983 117.000.530.557.30.00.30 Sanitary Facilities 3,746 7,000 - 5,020 117.000.530.557.30.00.35 Security & Safety 5,370 91000 1,340 9,151 117.000.530.557.30.00.40 Donated Prize Purse 1,500 5,000 2,300 2,500 117.000.530.557.30.00.42 Sboat Merch Resale 1,709 1,882 117.000.530.557.30.00.45 Advertising - Radio 6,000 3,262 7,610 117.000.530.557.30.00.47 Advertising - Print 1,031 4,000 2,518 3,645 117.000.530.557.30.00.49 Miscellaneous 9,1321 10,000 8,775 13,873 117.000.530.557.30.00.60 Capital Outlay 45,598 20,000 3,271 3,271 Christmas Event Expenses 105,103 103,500 56,249 83,505 117.000.550.557.49.00.01 75th B-day Celebration 2,257 Project 98802 Total Expenditures 135,162 137,982 272,405 275,600 157,099 247,190 178,300 83 2012 BUDGET BOND REDEMPTION FUND #202 Note: The 202 Fund 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 will be paid in full December 1, 2015. Payments are made from property tax allocations to this Fund. The principal and interest payments for 2012 are approximately $166,000. This fund also includes the debt service on the Public Works Trust Fund Loan used to improve 111h Street and the related Storm Water Utility improvements. These payments were previously inadvertently paid out of the Street Improvements Fund 301. Debt Service is $32,413 for 2012. 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 because a portion of the project included storm water infrastructure. EXPENDITURES 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. CITY OF EAST WENATCHEE STREET IMPROVEMENTS BOND REDEMPTION FUND202 BOND REDEMPTION FUND 2012 BUDGET - Finance BARS Numbers Description 2006 Actuals 2007 Actual 2008 2009 Actual Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget $ Change Revenues 202.000.000.308.00.00.00 Beginning NC&I 398 125 437 349 3,329 40,220 16,704 16,704 9,746 (6,958) Totals 398 125 437 349 3,329 40,220 16,704 16,704 9,746 (6,958) Revenues 202.000.000.311.10.00.00 Property Tax 162,718 158,319 163,500 200,000 201,100 180,000 180,000 180,000 180,000 - 202.000.000.338.90.00.00 SWU PWTFL Reimb 12,871 12,755 12,755 12,755 12,639 (116) 202.000.000.360.00.49.00 Misc Revenue 73 202.000.000.361.00.00.00 Interest Earnings 22 53 3 Total Revenue 162,740 158,372 163,576 200,000 213,971 192,755 192,755 192,755 192,639 Resources Available 163,138 158,497 164,013 200,349 217,300 232,975 209,459 209,459 202,385 (7,074) Expenditures 202.000.000.591.00.71.00 Redemption - GO Bonds 100,000 100,000 110,000 115,000 125,000 130,000 130,000 135,000 5,000 202.000.000.591.00.71.05 Redemption - PWTF Debt 29,712 29,712 29,712 29,712 29,713 29,713 - 202.000.000.592.00.89.00 Interest Debt 63,014 58,060 53,664 48,742 42,615 37,000 18,276 37,000 31,000 (6,000) 202.000.000.592.00.89.05 Interest - PWTF Loan 3,566 3,269 3,000 2,971 3,000 2,700 (300) Total Expenditures 163,014 158,060 163,664 197,020 200,596 199,712 50,959 199,713 198,413 202.000.000.508.00.00.00 Ending NC&I 125 437 350 3,330 16,704 33,263 158,500 9,746 3,972 (7,074) Note: 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. General Obligation Bonds Outstanding are the result of a financing in December 2000 in the total amount of $1,545,000. After 2011, the total outstanding amount will be $580,000, payabie $135,000 in 2012, $140,000 in 2013, $150,000 in 2014 and $155,000 in 2015. 85 2012 BUDGET STREET IMPROVEMENTS FUND NARRATIVE Note: The Streets 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 and 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. Projects budgeted for 2012 have been selected from the Transportation Improvement Plan (TIP) provided to the Washington State Department of Transportation each June. They include $991,726 for the second phase of the Grant Road Overlay Project (SR28 to Eastmont Avenue) financed through an STP Federal Grant for 86.5% of cost and the City's contribution for the balance. The second project is $151,000 for the Loop Trail Enhancement Project which is also funded through an STP Federal Grant for 86.5% of cost and the City's contribution for the balance. The third is the 15th Street Preservation Project costing $352,000 for a street overlay with an STP Grant for 86.5% of cost and the City's contribution for the balance. The fourth project is the 91h Street Preservation Project costing an estimated $616,000, also financed through an STP Federal Grant for 86.5% of the cost, with the City responsible for the balance. The fifth project is the beginning stages of the Eastmont Street Rebuild project from 3rd to Grant Road, including $320,000 in design and right-of-way costs financed through a TIB State Grant. REVENUES Property Tax None required for 2011. Sales & Use Tax That portion of sales & use tax shared with the Street Fund. None required for 2011. Other Revenues As noted above, STP Federal Grant monies provide the significant portion of street improvements scheduled for 2012, with the City providing the balance primarily with Real Estate Excise Taxes (REET) that is collected at closing as a small % of tax from the seller of real estate within the City limits of East Wenatchee. EXPENDITURES Planning, engineering and construction costs related to the projects described above. M CITY OF EAST WENATCHEE STREET IMPROVEMENTS FUND 301 STREET IMPROVEMENTS FUND 2012 BUDGET Description 2006 Actuals 2007 Actuals 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget Beginning NC&I 10,000 476,521 12,599 (175,247) 90,041 175,721 84,535 84,535 45,535 Totals 10,000 476,521 12,599 (175,247) 90,041 175,721 84,535 84,535 45,535 Revenues Property Tax 62,775 205,367 - - 15,119 Real Estate Excise Tas 100,000 Sales & Use Tax 114,144 269,783 - - STP Grant - Samara Engr Grant Rd Overlay STP - Grant Rd Overlay 365,000 863,747 REET - Grant Rd Overlay From 314 57,000 124,979 Georgia Ave Ped Crossing - REET from 314 STP - Loop Trail Enhancement 131,000 131,000 REET - Loop Trail Enhancement -From 314 20,000 20,000 REET - Eastmont Surveying/Basemapping - from 314 15,000 TIB - Eastmont Avenue - Grant Road to 3rd - Design 204,000 REET - Eastmont Avenue - Grant Road to 3rd - Design - from 314 30,000 SWU - Eastmont Avenue - Grant Road to 3rd - Design - from 314 6,000 TIB - Eastmont Avenue - Grant Road to 3rd - ROW 68,000 REET - Eastmont Avenue - Grant Road to 3rd - ROW - from 314 12,000 STP - 9th Street Preservation 500,000 REET - 9th Street Preservation - from 314 116,000 STP - 15th Street Preservation 250,000 REET - 15th Street Preservation - from 314 102,000 DC Regional Share 102,871 36,863 STP - Eastmont Ave 417,300 - - - REV Grant - CBD Project 1,947,021 954,169 326,628 - TIB - 8th St NE - - - - - - TIB - 15TH St Safety/ Eastmont Ave 1,139,565 89,691 - - - - TIB - 15th St to 19th St 2,838 97,563 351,818 - - - 8th St NE DCSD Reimburse 3,227 - - 8th St NE EWWD Reimburse 10,361 - - - - - 15th/Eastmont - DCSD Reimburse 78,666 848 - - - 15th/Eastmont - EWWD Reimburse 318,540 2,169 - - - 15th/Eastmont- DCPUD Reimburse 300,954 1,055 - 2,872 - - 87 CITY OF EAST WENATCHEE STREET IMPROVEMENTS FUND 301 STREET IMPROVEMENTS FUND 2012 BUDGET Description 2006 Actuals 2007 Actuals 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget CBD Project - DCPUD Reimburse 104,159 16,684 - - - ' CBD Project - EWWD Reimburse 62,848 52,897 - - - CBD Project - SWU Reimburse _ 459,205 - - - Canyon A - SWU Reimburse - 31,640 TIB - Rock Island Rd Project - - 533,584 192,875 - - Miscellaneous 222 15,436 - Interest Earnings 4,882 6,939 421 Housing - Rentals - CBD Project 5,375 2,750 - - ' RIR Project - EWWD Reimburse 103,190 - RIR Project - DCPUD Reimburse 133,710 RIR Project - DCSD Reimburse 5,434 - RIR Project - Charter Reimburse 29,499 342 - ' RIR Project- Misc Reimburse - 70,478 - Kenroy - EWWD Reimburse 1,175 2,689 - - Kenroy - ESD Reimburse 169,474 22,444 - Miscellaneous 63,870 3,482 - - Grover St - CI -Church Reimburse - 184 - - Total Current Revenue 4,572,875 2,206,196 1,818,987 295,269 102,871 588,000 2,479,708 Total Resources Available 4,582,875 2,682,717 1,831,586 120,022 1 192,912 763,721 84,535 84,535 2,525,243 Expenditures _ Rentals - Water Utilities 85 - - - 19 Rentals - Sewer Utilities 816 32 57 Rentals - Miscellaneous 29,799 - - - _ Engineering 1,009 - _ Engineering - REV Grant - CBD Project 572,318 416,877 168,659 Engineering - TIB - 11th St NE Engineering - TIB - VMP Turn Lane - - - Engineering - TIB - 8th St NE Engineering - DCSD - 8th St NE 88 CITY OF EAST WENATCHEE STREET IMPROVEMENTS FUND 301 STREET IMPROVEMENTS FUND 2012 BUDGET Description 2006 Actuals 2007 Actuals 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget Engineering - EWWD - 8th St NE - - Engineering - TIB-15th St Safety- 25,965 6,692 - Engineering - TIB - Eastmont Ave 338,384 125,356 148,979 " Engineering - TIB - RIR Project _ 96,759 43,420 Engineering - STP - Eastmont Ave _ - - Kenroy Schools Sidewalks Project _ 16,468 202,948 28,584 - Engr Grant Rd Overlay, 22,164 8,000 Roadway - Grant Road Overlay 72,269 422,000 22,768 30,000 1,025,589 SAMARA Project Intersections Georgia Ave Ped Crossing 13,868 8,267 9,000 Loop Trail Enhancement 151,000 151,000 Eastmont - Surveying + Basemap Development 15,000 Eastmont Avenue - Grant Road to 3rd SE - Design 240,000 Eastmont Avenue - Grant Road to 3rd SE - ROW - 80,000 9th Street Preservation 616,000 15th Street Preservation 352,000 Right -of -Way 12,228 - - - - ROW - REV Grant - CBD Project 218,193 - - - - ROW - TIB - 11th St NE - 144 - - - ROW - TIB - VMP Turn Lane - - - - ROW - TIB - 8th St NE - - ROW - DSCD - 8th St NE - - - - - ROW - EWWD - 8th St NE - - - - ROW - TIB - 15th St Safety - - - _ ROW - TIB - Eastmont Avenue 1,331 - ROW - TIB - RI Project - 209,298 23,905 1,311 - ROW - STP - Eastmont Avenue - - - Roadway 4,332 - Roadway - REV Grant - CBD Project 1,670,163 1,305,783 191,933 - - Roadway - TIB - 11th St NE - - - - - - Roadway - TIB - VMP Turn Lane - - - 89 CITY OF EAST WENATCHEE STREET IMPROVEMENTS FUND 301 STREET IMPROVEMENTS FUND 2012 BUDGET Description 2006 Actuals 2007 Actua/s 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget Roadway - TIB - 8th St NE - - - - - Roadway - DCSD - 8th St NE - - - - - Roadway - EWWD - 8th St NE _ Roadway - PWTFL# PW-00- 691-019 34,169 33,872 33,575 - - Roadway - TIB - 15th St Safety 337,842 71,191 - - - - - Roadway - TIB - Eastmont Avenue 905,864 657,446 - - - - Roadway - STP - Eastmont Avenue Roadway - DCPUD - 15th/Eastmont 54,425 - - - - Roadway - DCSD - 15th/Eastmont 58,661 - - - - - Roadway - EWWD - 15th/Eastmont 46,139 - - - - - Roadway - PWTF# PW-5-91- 280-020 58,024 - - - - - Roadway -TIB-RIR 1,113,916 - - - Roadway - STP - Eastmont Avenue 61 - - - - PWTFL - Canyon A - Design Phase 30,087 45,613 57,788 PWTFL - Canyon A - ROW - - 13,411 - PWTFL - Canyon A - Construction Phase _ - 8,266 - - - Safe Routes to School Grant - - - Facilities Miscellaneous 2,135 - - - - - Sidewalks - - - - - - Street Lights - - - - - Capital Outlay 234 - - - Total Expenditures 3,202,136 2,113,905 1,418,889 30,072 108,377 596,000 31,035 39,000 2,464,589 Net Resources 1,380,740 568,812 412,697 89,950 84,535 167,721 53,500 45,535 60,654 90 CITY OF EAST WENATCHEE STREET IMPROVEMENTS FUND 301 STREET IMPROVEMENTS FUND 2012 BUDGET Description 2006 Actuals 2007 Actuals 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget Notes: UPDATE FOR 2012 Grant Rd Overlay - SR 28 to Georgia Remaining STP funds = $863,744 per WSDOT City portion = $122,293 (match construction) + $20,787 (shortfall) + $18,762 (match on C.E.) Loop Trail Enhancement - REET from 314 City portion = $112,208 x 1.35 (for engineering, environmental, etc) — $151,000 86.5% STP — $131,000 + 13.5% City — $20,000 Eastmont Avenue - Grant Road to 3rd SE Design Engineering = $240,000. TIB = $204,000. City = $36,000 Expend 1/2 in 2011, reimburse all in 2012 Storm Drainage Construction = $294,800 x 15% (match) x 13% (design) — $6,000 Right of Way = $80,000. TIB = 68,000. City = 12,000 Expend 1/2 in 2011, reimburse all in 2012 9th Street Preservation Total project = $600,000 (preservation) + $16,000 (non -allowed improvements) = $616,000 STP funds = $500,000 (maximum allowable grant per project & $750,000 per agency) City portion = $116,000 15th Street Preservation Total project = $314,000 (preservation) + $38,000 (non -allowed improvements) = $352,000 STP funds = $250,000 (maximum allowable grant per project & $750,000 per agency) City portion = $116,000 91 2012 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. The City has previously approved receipt of the first 1/4 of 1% allowed. In 2009, the City has determined thru Council Ordinance to begin collecting the allowable second 1/4 of 1%. These taxes are generally limited to expenditures for capital improvements of streets and roadways. For 2012, the City has determined the amount and level of spending for capital improvements in this fund. All five street improvement projects will be partially funded with Real Estate Excise Tax Revenues from this fund, noted as transfers in the Expenditure section of the following schedule. REVENUES Real Estate Excise Tax Real Estate Excise Tax from real estate transactions. EXPENDITURES Transfers of REET from this fund to the Street Improvements Fund #301. 92 CITY OF EAST WENATCHEE CAPITAL IMPROVEMENT FUND314 CAPITAL IMPROVEMENTS FUND 2012 BUDGET BARS Numbers Description 2006 Actuals 2007 Actuals 2008 Actual 2009 Actual 2010 Actual 2011 Budget 2011 7 Months 2011 Estimate 2012 Budget Revenues 314.000.000.308.00.00.00 Beginning NC&I 741,508 591,883 (1,338) 614,940 581,940 772,240 772,240 884,340 Totals 741,508 591,883 (1,338) 614,940 581,940 772,240 772,240 884,340 314.000.000.317.30.00.00 Real Estate Excise Tax 174,039 182,333 100,961 135,273 170,397 145,000 119,435 212,000 200,000 314.000.000.333.10.00.00 Regional Fund Share 314.000.000.395.00.00.05 Property Sale Proceeds- Colorado Ave 110,992 314.000.000.311.10.00.00 Property Tax 75,000 70,100 314.000.000.395.00.00.10 ROW WSDOT - Sellar Bridge Project 370,000 314.000.000.361.00.00.00 Interest Earnings 19,218 13,449 345 13 Totals Revenue 193,257 195,782 101,306 616,278 170,397 220,000 119,435 282,100 200,000 Total Resources Available 934,765 787,665 101,306 614,940 785,337 801,940 891,675 1,054,340 1,084,340 Expenditures 314.000.000.594.00.41.00 Professional Service 314.000.000.594.00.41.01 Expenses - 498 314.000.000.594.00.60.00 Capital Outlay 342,882 865,951 102,146 314.000.000.594.10.10.00 Salaries - 314.000.000.594.10.20.00 Benefits 314.000.000.594.00.60.10 Capital Outlay - East Wing Improvements 13.097 175,000 160,267 170,000 Transfer REET to Fund 301 - Grant Rd Overlay 57,000 124,979 Transfer REET to Fund 301 - Georgia Ped Crossing Transfer REET to Fund 301 - Loop Trail Enhancement 20,000 20,000 Transfer Eastmont - Surveying + Basemap Development 15,000 Transfer Eastmont Ave - Grant Road to 3rd - Design 30,000 Transfer Eastmont Ave - Grant Road to 3rd - ROW 12,000 Transfer 9th Street Preservation 116,000 Transfer 15th Street Preservation 102,000 Totals Expenditures 342,882 865,951 102,644 13,097 267,000 160,267 170,000 404,979 314.000.000.508.00.00.00 Ending NC&I 591,883 (78,286) (1,338) 614,940 772,240 534,940 731,408 884,340 679,361 Monies for this Fund come from Real Estate Excise Taxes which are generally limited to Street Improvements. During 2010, plans include transferring funds into the Street Improvements Fund 301 after confirming that expenditures meet the purposes for REET revenue. 93 Estimate Estimate Allocation of Fund Balance: Dec 31, 2009 Dec 31, 2010 Dec 31, 2011 Dec 31, 2012 REET Funds 133,948.60 304,345.59 516,345.59 716,345.59 Proceeds Sale 110,991.70 97,894.70 Spent on East Wing - REET Spend on Capital (404,979.00) Property Tax 1 70,100.00 Property Tax Balance 350.32 - Spent on East Wing (69,649.38) WSDOT "Deposit' 370,000.00 370,000.00 370,000.00 370,000.00 614,940.30 772,240.29 886,796.21 681,716.91 Notes: Grant Rd Overlay - SR 28 to Georgia Remaining STP funds = $863,744 per WSDOT City portion = $122,293 (match construction) + $20,787 (shortfall) + $18,762 (match on C.E.) Loop Trail Enhancement - REET from 314 City portion = $112,208 x 1.35 (for engineering, environmental, etc) — $151,000 86.5% STP -- $131,000 + 13.5% City — $20,000 Eastmont Avenue - Grant Road to 3rd SE Design Engineering = $240,000. TIB = $204,000. City = $36,000 --- Expend 1/2 in 2011 Storm Drainage Construction = $294,800 x 15% (match) x 13% (design) — $6,000 Right of Way = $80,000. TO = 68,000. City = 12,000 --- Expend 1/2 in 2011 9th Street Preservation Total project = $600,000 (preservation) + $16,000 (non -allowed improvements) _ $616,000 STP funds = $500,000 (maximum allowable grant per project & $750,000 per agency) City portion = $116,000 15th Street Preservation Total project = $314,000 (preservation) + $38,000 (non -allowed improvements) _ $352,000 STP funds = $250,000 (maximum allowable grant per project & $750,000 per agency) City portion = $116,000 94 2012 BUDGET EQUIPMENT RENTAL & REPLACEMENT FUND REVENUES Sales and Use Tax None Sale of Surplus Property None Budgeted for 2012 Operating Transfers In — Monthly Lease Payments None for 2012 EXPENDITURES Capital Outlay/Supplies/Repairs & Maintenance/Miscellaneous None for 2012 Supplies None for 2012. Repairs and Maintenance None for 2012. Miscellaneous Miscellaneous expenditures for the ER&R Fund. 95