The URL can be used to link to this page

Home My WebLink About2011 - Final Budget - Nick A GerdeCity of East Wenatchee, Washington 2011 Annual Financial Budget Manor Steven C. Lacy Councilmembers Wayne Barnhart David Bremmer George Buckner Dennis Hendricks Chuck Johnson Sandra McCourt Harry Raab Finance Director Nick Gerde 2011 FINANCIAL BUDGET TABLE OF CONTENTS PAGE TITLE PAGE - 2011 FINANCIAL BUDGET.........................................-1 TABLE OF CONTENTS...............................................................i &ii 2011 BUDGET COMMITTEE............................................................-2 ELECTEDOFFICIALS....................................................................-3 APPOINTED OFFICIALS..................................................................-4 ACCOUNTING POLICY AND FUND STRUCTURE...............................-5 BUDGET ASSUMPTIONS AND HIGHLIGHTS6-9 - 9 - SUMMARY FINANCIAL INFORMATION.................................10 - 17 - HIGH LEVEL CASH FLOW SUMMARY (10) - CASH FLOW -MAJOR SOURCES OF REVENUE (11) - CASH FLOW - MAJOR EXPENDITURE AREAS (12) - CASH FLOW BY FUND (13) - PROPOSED REVENUE SOURCES (14-15) - PROPOSED EXPENDITURES (16-17) GENERAL FUND REVENUES.....................................................18 - 23 (A NARRATIVE FOLLOWED BY FINANCIAL SCHEDULES) GENERAL FUND EXPENDITURES..................................................24 (A NARRATIVE FOLLOWED BY FINANCIAL SCHEDULES) GENERAL FUND DEPARTMENT DETAIL .................................... (A NARRATIVE FOLLOWED BY A FINANCIAL SCHEDULES) GENERAL GOVERNMENT....................................................25 - 27 LEGISLATIVE....................................................................28 - 29 MUNICIPAL COURT...........................................................30 - 31 CITYCLERK..................................................................... 32 - 33 FINANCE............................................................................34 - 35 INFORMATION TECHNOLOGY............................................36 - 37 INTERNAL SERVICES..........................................................38 - 39 LEGAL................................................................................40 - 41 CITYENGINEER..................................................................42 - 43 CIVILSERVICE.....................................................................44 - 45 CENTRAL SERVICES.............................................................46 - 47 LAW ENFORCEMENT...........................................................48 - 53 STORM WATER UTILITY.......................................................54 - 58 ENGINEERING SERVICES.....................................................59 - 60 PLANNING..........................................................................61 - 62 CODE COMPLIANCE............................................................63 - 64 STREETFUND........................................................................ 65 - 68 COMMUNITY DEVELOPMENT GRANTS FUND ...........................69 - 70 LIBRARYFUND.......................................................................71 - 72 HOTEL/MOTEL TAX FUND ....................................................... 73 - 74 DRUGFUND...................................................................................................75 - 76 CRIMINAL JUSTICE FUND.........................................................................77- 78 EAST WENATCHEE EVENTS BOARD FUND.........................................79 - 82 BOND REDEMPTION FUND..............................................................83 - 84 STREET IMPROVEMENTS FUND.............................................................85 - 90 CAPITAL IMPROVEMENTS FUND...............................................91 - 92 EQUIPMENT RENTAL & REPLACEMENT FUND ............................93 - 94 Cit of East Wenatchee, Washington 2011 Budget Committee Mayor Steven C. Lacy Councilmember George Buckner Councilmember Dennis Hendricks Councilmember Harry Raab Finance Director Nick Gerde 2 East Wenatchee City Officials Elected Officials Mayor Steven C. Lacy, Four year term, expiring 12/31/11 Councilmembers Position Number One David Bremmer, Four year term, expiring 12/31/11 Position Number Two Harry Raab, Four year term, expiring 12/31/11 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 Fi Sandra McCourt, Four year term, expiring 12/31/11 Position Number Six Dennis Hendricks, Four year term, expiring 12/31/11 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 Gerde Police Chief Randy Harrison City Clerk Dana Barnard City Engineer Donald McGahuey Community Development Director Lorraine Barnett Code Compliance Officer Jeffrey Morrison Events Board Coordinator Dawn Collings Municipal Court Judge Chancey Crowell Court Administrator Joan Sims Librarian — North Central Regional Library Elena Ptak City of East Wenatchee, Washington 2011 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. 4 CITY OF EAST WENATCHEE, WASHINGTON 2011 FINANCIAL BUDGET 2011 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 budget assumptions for 2011 costs include: 1. Budget costs conservatively: No increases in operating costs unless they can be substantiated and approved by the 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. Increase in compensation for five (5) City employees not covered by a collective bargaining agreement or an employment agreement based upon the City's long-standing policy of wage parity. This group currently covers eight (8) City employees, or about 16% of the City workforce. 4. The collective bargaining unit agreements with the police department unions, not including the Police Chief and Assistant Chief, expire on December 31, 2010 and are in the negotiation process. No significant increases in cost are expected as a result of this union negotiation. 5. The collective bargaining unit agreement with Local 846-W expires on December 31, 2010 and is also in the negotiation process. This agreement covers thirteen (13) employees in the Street, Planning, Code, Court, City Clerk and Events Departments. No significant increases in cost are expected as a result of this union negotiation. 2010 BUDGET ASSUMPTIONS AND HIGHLIGHTS (continued) 6. Healthcare premiums, commercial insurance, detention costs, RiverCom costs, and any other significant costs will be determined through communication or quotes from the vendors. Primary budget assumptions for 2010 operational revenues included: 1. Fourteen sources of revenue for the City represent over 94% of the budgeted revenue for 2011. They include: A. Sales and Use Tax $2,520,000 24.4% B. Property Tax 1,512,000 14.7% C. Utility Taxes 769,000 7.5% D. Storm Water Utility 21330,000 22.6% E. Street Improvement Revenue 588,000 5.7% F. Fines & Penalties — Court 375,000 3.6% G. Gambling Tax 26000 2.5% H. Street Fuel Excise Tax 24500 2.4% I. Criminal Justice Taxes 16700 1.6% J. Liquor Taxes 1431000 1.4% K. Hotel/Motel Taxes 1371000 1.3 % L. Real Estate Excise Tax 1451000 1.4% M. Events Revenue 122,000 1.2% N. Pass -Through Revenue 40500 3.9% N. Balance of Revenue Budget 588,000 5.8% Total 2011 Revenue Budget $10,306,000 100% 2. Each revenue source was evaluated in consideration of a 5 year receipt history, or shorter in the case of utility taxes and street improvements/capital projects. 7 2010 BUDGET ASSUMPTIONS AND HIGHLIGHTS (continued) 3. Monthly trends over the last three years and the nine months of 2010 were studied, particularly in light of recent economic trends, experience by other cities in our region, and the continuing recession. 4. Any consideration for annual increases in each revenue category beyond the budget year for forecasts for the financial plan, were estimated on a conservative basis. Primary assumptions for capital costs for street preservation projects, intersection signal lighting and street reconstruction projects, include the following: 1. The primary 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 2011 budget year, and for each year from 2012 thru 2016 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 three projects which were specifically scheduled: $75,000 for the Audible Pedestrian Crossings is on hold due to engineering challenges; $430,000 for the second stage of the Grant Road overlay project to be done in conjunction with the George Sellar Bridge and Highway 28 work scheduled by WSDOT in 2011; and $151,000 for the Loop Trail Enhancement Project which the City applied for and was granted during 2010. 8 2010 BUDGET ASSUMPTIONS AND HIGHLIGHTS continued 4. Scheduled capital projects for which there is no current source of grant monies, reflect no calculated source through 2012. This is a result of the continuing confirmation that State and Federal funding is extremely unlikely over the next several years. Estimations of historical funding levels are included in capital projects from 2013 to 2015 without any assurance that funding will be available. 9 City of East Wenatchee, Washington 2011 Financial Budget Summary Financial Information 3 Pages 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 three ways, as follows: 1. High Level Cash Flow Summary 2. Cash Flow by Categories of Revenue and Expenditures, and Summarized Cash Flow: Hiah Level Summa 2011 2010 As Amended Final Estimated 2010 Budget Actual Budget Cash Balances, Beginning of the Year $ 1,971,000 $ 1,647,500 $ 1,081,070 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 ,! •11 �11 405,400 7,770,600 405,400 8,340,000 405,600 10,305,800 8,176,000 8,745,600 12,276,800 9,823,500 9,826,670 9,798,900 448,400 7,359,800 8,438,100 492,700 477,300 10,247,300 7,852,500 8,915,400 $ 2,029,500 $ 1,971,000 $ 911,270 NOTE: 2010 Budget Amendment included the first phase of the Grant Road Overlay; improvements to the southeast residence building; additional Storm Water Utility revenue and costs related to NPDES compliance work; revenue and costs for the Sprint Boat Event; and receipt of a Community Development Block Grant which included both revenue and costs. 2011 Revenues and Costs are higher in comparison to 2010 primarily because of budgeted increases in Storm Water Utility work related to the Canyon A Project and NPDES compliance expenditures. 10 Summarized Cash Flow: l3v Maior Revenue and Exaense Cateaories 2011 2010 As Amended Maior Revenue Sources Final Estimated 2010 Budget Actual Budget Cash Balances, Beginning of the Year $ 1,971,000 $ 1,647,500 $ 1,081,100 Revenues Received Sales & Use Taxes 2,520,000 2,630,000 2,415,000 Property Taxes - 2009 Base 1,512,000 1,498,400 1,498,400 Property Taxes - Add'I 1 % Plus New Adds - - - Real Estate Excise Tax 145,000 150,000 90,500 Municipal Court Receipts - Fines 375,000 375,000 367,000 Gambling Tax Receipts 260,000 255,000 280,000 6% Utility Tax - Natural Gas - New 40,000 40,000 50,500 6% Utility Tax - Electricity - New 294,000 277,000 300,000 $% Utility Tax - Telephones/Cells - New 435,000 435,000 400,000 Street Fuel Excise Tax 245,000 245,000 245,000 Funding for Street Improvements 588,000 569,500 600,500 Storm Water Utility Capital Reimbursed 2,007,000 208,000 590,000 Other Revenues 1,479,400 1,087,700 1,503,100 Total Revenues 9,900,400 7,770,600 8,340,000 Non -Revenues Received Court Receipts for the State 391,000 391,000 391,000 Other Non -Revenue 14,400 14,400 14,600 Total Non -Revenues 405,400 405,400 405,600 Grand Total Revenues 10,305,800 8,176,000 8,745,600 Total Resources Available (Cash plus Revenue) 12,276,800 9,823,500 9,826,700 11 Major Expenditure Areas: 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 Utili Gapi al'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 2011 2010 As Amended Final Estimated 2010 Budget Actual Budget 3,090,000 3,045,000 3,055,700 1,270,000 1,250,000 1,325,100 199,700 199,700 201,200 277,900 285,000 428,000 149,400 131,750 132,000 220,000 220,000 220,000 285,900 257,100 256,500 51,000 66,000 75,000 596,000 526,100 578,000 2,007,000 87,000 503,000 1,652,000 1,292,150 1,663,600 9,798,900 7,359,800 8,438,100 360,000 355,000 330,000 10,000 60,000 60,000 56,000 55,800 57,000 22,400 21,900 30,300 448,400 492,700 477,300 10,247,300 7,852,500 8,915,400 $ 2,029,500 $ 1,971,000 $ 911,300 12 City of East Wenatchee, Washington 2011 Final Budget Worksheet By Fund I Beginning Add: Less: Ending Balance Budgeted Budgeted Balance Jan 1, 2011 Revenue. Expenditures Dec 31, 2011 General Fund 962,961 8,209,523 7,998,452 1,174,032 Street Fund 117,782 722,700 755,500 84,982 CD Grants Fund 2,034 98,418 98,418 2,034 Library Fund 6,681 2,750 3,600 5,831 Hotel/Motel Tax Fund 19,017 51,000 51,000 19,017 Drug Fund 7,421 2,000 3,000 6,421 Criminal Justice Fund 48,466 37,800 45,000 41,266 Events Fund 1,316 275,800 275,600 1,516 Bond Fund 40,220 172,755 199,712 13,263 Street Improvements Fund 175,721 588,000 596,000 167,721 Capital Improvements Fund 581,940 145,000 221,000 505,940 ER&R Fund 7,486 - - 7,486 Total 1,971,045 10,305,746 10,247,282 2,029,509 13 City of East Wenatchee, Washington 2011 Final Budget Worksheet - Revenues Final Revenue Sources for the 2011 Budget: Final Actual 2009 Est Actual 2010 Budget 2011 Property Taxes - General Fund 1,095,185 1,073,400 1,152,000 Property Taxes - Street Fund 200,000 200,000 200,000 Property Taxes - Debt Service 200,000 225,000 160,000 Sales Taxes - General Fund 2,364,700 2,091,000 2,177,000 Sales Taxes - Street Fund 469,064 385,000 275,000 Sales Taxes - Events Fund 20,000 154,000 68,000 (A) Utility Taxes 561,777 752,000 769,000 (B) Gambling Taxes 256,075 255,000 260,000 Criminal Justice Revenue 167,090 130,000 130,000 Business Licenses 47,719 53,000 53,000 PUD Privilege Tax 34,101 37,100 37,100 Franchise Fees 95,393 93,000 93,000 Liquor Board Profits & Tax 136,152 142,000 143,000 Storm Water Utility Funding 630,494 208,000 2,330,003 (E) Court Fines and Penalties 377,971 375,000 375,000 Pass through Revenues 432,154 405,350 405,350 Street Fuel Excise Tax 251,701 245,000 245,000 Community Development Grants 28,199 25,703 98,418 Hotel/Motel Taxes - Pass through 78,283 75,600 51,000 (F) Hotel/Motel Taxes - Events Dept 52,189 56,600 85,800 (F) Events Dept - Participation 50,344 80,207 122,000 (A) Criminal Justice Revenue 38,942 39,069 37,800 Street Improvements Revenue 295,182 672,280 588,000 (G) Capital Projects Revenue 616,278 261,000 145,000 (G) Other Revenue 86,890 129,137 305,275 $ 8,585,883 $ 8,163,446 $ 10,305,746 (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. (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. 14 (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. 15 City of East Wenatchee, Washington 2011 Final Budget Worksheet - Expenditures Final Expenditure Areas for the 2011 Budget: General Government Legislative Municipal Court City Clerk Finance Information Technology Internal Services Legal Department City Engineering Dept Civil Service Central Services Law Enforcement Jail Services Emergency Management Storm Water Utility Operations Storm Water Utility Constructic Engineering Support Planning Code Compliance Non -Expenditures - Pass throu€ Street Maintenance Community Dev Grants Library Hotel/Motel Tax Fund Drug Fund Criminal Justice Fund Events Fund Bond Fund Debt Service Street Improvements Capital Improvements Other Total Expenditures Actual 2009 Est Actual 2010 406,107 400,226 196,936 156,311 313,375 318,500 125,789 127,600 155,621 163,150 55,700 151,225 25,851 37,200 128,621 161,631 - 109,977 2,933 126 102,212 98,230 2,454,532 2,612,100 260,849 227,000 13,011 14,000 65,994 239,000 579,273 107,002 22,132 10,400 175,785 179,800 132,988 138,535 725,689 492,685 830,430 760,000 34,404 25,703 2,207 3,011 87,709 66,000 12,423 3,000 35,056 36,205 139,806 239,175 197,020 200,980 29,895 526,100 - 183,000 19,997 - $ 7,332,345 16 Final Budget 2011 420,734 316,600 278,550 138,550 179,500 92,000 39,200 178,725 122,380 2,975 97,230 2,716,300 230,500 1a1 (D) (E) 472,040 (F) 2,007,363 (G) 128,230 129,175 448,400 755,500 98,418 3,600 51,000 3,000 45,000 275,600 199,712 596,000 221,000 $ 7,787,872 $ 10,247,282 (H) (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. 17 2011 BUDGET GENERAL FUND REVENUES Beginning Fund Balance The 2011 beginning fund balance is projected to be approximately $963,000. Property Tax/Contingency Property Tax It is the recommendation of the 2011 Budget Committee to take the allowable 1 % increase in property taxes, but the Council voted the recommendation down 4 for and 3 against. The total 2011 Levy is calculated by the Douglas County Assessor's Office at $1,511,892, compared to $1,498,428 in 2009. $1,152,000 will be allocated to the General Fund, $200,000 to the Street O&M Fund, and $160,000 to the Bond Fund for Debt Service. Sales & Use Tax Sales and Use Taxes for 2010 are budgeted to be $2,520,000, slightly higher than the 2010 budget of $2,415,000. Actual receipts are expected to be over $2,660,000 in 2010, but include taxes from projects and activity the may not repeat in 2011. $2,177,000 is allocated to the General Fund, $275,000 is for the Street O&M Fund, and $68,000 is for the Events Fund. Approximately $10,000 of these taxes will be paid as a non -expenditure to Douglas County under the final year of a tax sharing agreement for the Kentucky Avenue Annexation. Recycling Based upon the agreement with Waste Management, we expect to receive $23,000 in 2011, 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. 2010 projected receipts of utility taxes total $752,000. 2011 budgeted revenues for utility taxes total $769,000. Gambling Tax Gambling taxes are forecast at historical levels at the same effective rate of 8%. In 2010 BUDGET GENERAL FUND REVENUES Business Licenses Business License revenue is expected to be about $53,000 for 2010. Business license fees have not been changed since 1983. If Council passes a proposal to increase fees over a three year period, the budget for 2011 will be $65,500. (voted down) Franchise Fees Franchise fees are expected to be $93,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, and $65,000 in 2009. Actual fees for 2010 are estimated at $42,000 compared to a budget of $46,500. The budget for 2011 is $46,000 on the expectation that building and development activity may have bottomed out. Gun Permits 2010 receipts are expected to be $2,500. $2,500 is the budget for 2011. PUD Privilege Tax This payment by Chelan PUD in lieu of property taxes was nearly $37,100 in 2010, and is expected to be about the same in 2011. Local Government Assistance The City did not receive local assistance late in 2010, and does not expect any for 2011. Liquor Excise Tax Liquor Excise Tax for 2010 is expected to be approximately 57,000 and is budgeted at $58,000 for 2011. Liquor Board Profits Liquor Board Profits for 2010 is expected to exceed $85,000, and is budgeted at that level for 2011. 19 2010 BUDGET GENERAL FUND REVENUES 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. $37,500 is expected for 2010, and budgeted at that level for 2011. In comparison, the City will pay nearly $220,000 to the Regional Justice Center during 2010 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 2011, the City has forecasted over $1.9 million in capital construction for the Canyon A Project, $100,000 for smaller capital projects, and over $300,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 $22,000 for Plan Checking Fees, generally at lesser levels than in the recent past. Fines & Penalties Municipal Court activity has increased significantly during 2009, and we expect to receive approximately $375,000 in 2010 in comparison to a budget of $367,000. The budget for 2011 is $375,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 $400,000 during 2010 and the same amount in 2011. The largest revenue is Municipal Court Receipts that are allocated directly to the State of Washington totaling approximately $390,000 for both 2010 and 2011. 20 CITY OF EAST WENATCHEE CURRENT EXPENSE REVENUES GENERAL FUND REVENUE PAGE 1 OF 3 2011 Budget Worksheet BARS Numbers Description 2005 Actuals 2006 Actuals 2007 Actual 2008 2009 2010 2010 Budget 6 Months 2010 2011 Estimate Budget Actual Actual 001.000.000.308.00.00.00 Beginning NC&I 122,283 103,966 153,206 253,525 218,641 612,280 826,340 825,000 1,264,000 Totals 122,283 103,966 153,206 253,525 218,641 612,280 826,340 825,000 1,264,000 Taxes 001.000.000.311.10.00.00 Property Tax 524,754 597,444 981,625 1,013,632 1,095,185 1,100,800 514,820 1,073,400 1,152,000 001 .000.000.31 1.10.00.01 Contingency PropertV Tax 001.000.000.313.10.00.00 Sales & Use Tax 1,380,954 1,697,230 1,596,599 2,276,883 2,364,700 1,702,500 1,157,151 2,091,000 2,177,000 001.000.000.313.71.00.00 Criminal Justice 82,214 111,833 133,550 172,675 167,090 160,000 62,324 130,000 130,000 001.000.000.316.51.00.00 Electric UtilitV Tax - - _ - 226,539 300,000 162,725 277,000 294,000 001.000.000.316.53.00.00 Natural Gas UtilitV Tax 31,966 50,500 24,959 40,000 40,000 001.000.000.316.55.00.00 Garbage UtilitV Tax 001,000.000.316.57.00.00 6% Tax Tele/Cellular 303,272 400,000 250,066 435,000 435,000 001.000.000.316.55.01.00 Recycling 15,805 14,506 30,957 22,000 23,092 23,000 15 22,804 23,000 001.000.000.317.54.00.00 Gambling Tax 316,658 288,505 280,776 235,755 256,075 280,000 106,062 255,000 260,000 001.000.000.314.51.00.01 Gambling Tax Penalties 453 292 Totals 2,320,385 2,709,518 3,023,507 3,720,945 4,468,372 4,016,800 2,278,414 4,324,204 4,511,000 Licenses & Permits 001.000.000.321.00.00.00 Business Licenses 39,043 39,627 43,384 46,506 47,719 48,000 36,243 53,000 53,000 Proposed Fee Increase 001.000.000.321.30.01.00 Fireworks Permits 400 450 400 600 500 500 400 400 400 001.000.000.321.60,00.00 Taxicab Licenses 200 675 965 1,558 465 100 328 330 330 001.000.000.321.70.00.00 Amusement Licenses 1,885 1,305 2,510 2,160 1,990 1,000 690 690 690 001.000.000.321.70.01.00 Panoram Licenses 660 - 1,320 - 300 300 300 300 001.000.000.321.80.00.00 Business License Penalties 622 520 780 624 689 300 142 350 350 001.000.000.321.91.00.00 Franchise Fees 41,322 72,014 85,248 95,857 95,393 96,000 47,293 93,000 93,000 001.000.000,322.10.00.00 Building Permits 117,566 118,291 161,794 89,586 64,690 46,500 24,030 42,000 46,000 001.000.000.322.90.01.00 Gun Permits 770 2,154 2,801 2,611 2,951 2,500 1,714 2,500 2,500 Totals 202,467 235,037 299,202 239,502 214,697 194,900 111,140 192,570 196,570 (A) Total Forecast Property Taxes for 2011 are $1,512,000. $160,000 is allocated to the Bond Fund 202, AND $200,000 is allocated to the Street O&M Fund 101, leaving $1,152,000 to the General Fund. (B) Total Forecast Sales & Use Taxes for 2011 are $2,520,000. $275,000 is allocated to the Street O&M Fund 101, and $68,000 is allocated to the Events Fund 117. 21 CITY OF EAST WENATCHEE CURRENT EXPENSE REVENUES GENERAL FUND REVENUE 2011 BUDGET WORKSHEET PAGE 2OF3 PAGE 2OF3 BARS Numbers Description 2,005 Actuals 2,006 Actuals 2007 Actual 2008 2009 2010 2010 Budget 6 Months 2010 2011 Estimate Budget Actual Actual Intergovernmental 001.000.000.331.16.60.00 Bullet Proof Vest Grant - _ 3,846 - 640 640 2,500 001.000.000.331.16.70.00 COPS Grant 55,562 26,467 - 87,000 33,272 75,000 87,000 001.000.333.04.21.01.00 WASPC Safety Grant 1,920 1,300 3,000 - - - 001.000.000.333.16.50.00 CRDTF 10,423 - - 001.000.000.333.16.51.01 WASPC Block Grant 5,000 - - - - 001.000.000.334.03.51.00 TSC Grant - 7,956 1,651 5,000 001.000.000.334.03.51.01 TSC - Drive Hammered Get Nailed 5,882 2,108 4,342 3,318 1,145 - 001.000.000.334.03.51.02 TSC - Click It or Ticket 5,696 3,426 747 3,271 - - - 001.00.000.334.03.51.03 TSC-Night Seat Belt Emp 2,985 521 600 1,400 001.000.000.334.06.51.04 TSC Speed Limit Emp 1,471 2,332 3,505 4,000 2,800 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 001.000.000.335.00.91.00 PUD Privilege Tax 24,474 24,496 25,379 25,663 34,101 35,000 37,085 37,100 37,100 001.000.000.336.00.98.00 Local Govt Assistance 2007 - 129,628 2,013 - - 001.000.000.336.06.51.00 DUI 1,388 1,761 2,639 2,526 4,032 2,100 1,890 3,000 4,200 001.000.000.336.06.94.00 Liquor Excise Tax 33,776 45,681 52,028 27,660 28,128 57,000 14,250 57,000 58,000 001.000.000.336.06.95.00 Liquor Board Profits 58,550 73,763 83,540 105,186 108,024 81,000 63,736 85,000 85,000 001.000.000.338.21.01.00 Eastmont School - SRQTotals 24,964 24,820 28,455 28,093 3,305 - - - 227,634 203,823 361,560 198,839 206,511 282,100 169,259 276,700 290,500 Charges for Services 001.000.000.341.00.00.00 General Services 68 80 102 4,260 2,570 100 25 100 100 001.000.000.341.50.00.00 Sales of Maps 25 21 2,305 2 22 PassportFees 725 800 800 001.000.000.341.60.00.00 Duplicating Services 1,101' 1,953 1,468 2,424 1,431 2,300 703 1,000 1,000 001.000.000.341.96.00.00 Personnel Services - 001.000.000.342.36.00.00 Housing of Prisoners 11,400 14,158 26,004 31,133 36,755 28,000 19,761 37,600 37,500 001.000.000.342.40.00.01 Fire Marshall Inspection Service - _ 47 47 250 150 200 050.000.000.343.13.00.00 SWU Maint Svcs 89,410 248,042 104,879 76,880 80,039 80,000 41,626 65,000 - 050.000.000.343.13.00.20 SWU Admin 16,600 3,000 15,300 050.000.000.343.13.00.30 SWU Small Capital 70,000 40,000 100,000 050.000.000.343.13.00.Var SWU-Canyon A Phase 2 550,445 - 050.000.000.343.13.00.Var SWU-Canyon A Phase 3 & 4 433,000 33,112 40,000 1,907,363 050.000.000.343.13.00.Var SWU NPDES Revenue 149,817 14,841 60,000 307,340 001.000.000.345.80.00.00 banning & 1,325 16,798 4,590 7,554 10,490 6,000 1,631 3,000 5,000 001.000.000.345.81.00.00 Zoning & Subdivision Fees 150 225 150 - 500 - - 001.000.000.345.83.00.00 Plans Checking Fees 64,550 54,722 60,328 36,968 27,619 30,000 12,285 22,000 22,000 001.000.000.345.89.00.00 SEPA Permits 257 350 1,000 1,200 483 1,000 161 300 1,000 Totals 168,285 336,348 200,873 160,468 710,604 816,817 125,020 272,800 2,397,603 22 - CURRENT EXPENSE REVENUES GENERAL FUND REVENUE 2011 BUDGET WORKSHEET PAGE 3OF3 PAGE 3OF3 BARS Numbers Description Z005 Actuals 2,006 Actuals 2007 Actual 2008 2009 2010 2010 2010 2011 Actual Actual Budget 6 Months Estimate Budget Fines & Penalties 001.000.000.350.00.00.00 Fines & Penalties 139,730 164,204 206,752 300,675 377,971 367,000 186,173 375,000 375,000 001.000.000.351.00.01.00 Disabled Parking 1,675 3,149 - - - - - 001.000.000.357.30.01.00 Restitution 100 100 13 81 - 651 651 - 001.000.000.357.33.00.00 Public Defender - 14,456 12,030 13,142 13,358 19,096 15,000 12,567 23,500 23,500 Totals 155,961 179,482 219,907 314,114 397,067 382,000 199,391 399,151 398,500 Miscellaneous 001.000.000.360.00.00.00 Miscellaneous 76,939 14,412 192,553 14,628 9,672 1,000 2,295 2,750 2,000 001.000.000.361.00.00.00 Interest Earnings, 16,333 21,668 14,673 11,753 6,709 4,000 2,939 6,000 5,000 001.000.000.361.40.00.00 Sales Tax Interest 2,813 6,095 7,686 6,743 6,035 6,000 1,860 3,000 3,000 001.000.000.362.50.00.01 EWEB Monthly Lease Payment 110 120 60 - - - - 001.000.000.367.00.00.00 Donations 100 - 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 50,695 - - - - - - - Totals 146,990 42,294 214,972 41,962 29,378 11,000 71094 11,750 10,000 Sub -Total Current Revenues 3,221,722 3,706,503 4,320,021 4,675,830 6,026,629 5,703,617 2,890,318 5,477,175 7,804,173 Non -Revenues 3,343 5227 001.000.000.380.00.50.00 State Building Code Surcharge 540 620 1,024 699 396 300 324 350 350 001.000.000.380.00.50.01 State Share of Gun Permits 1,090 3,448 4,752 4,778 5,684 5,000 3,243 4,000 4,000 001.000.000.380.00.50.07 Engineering Reimbursement 26,128 26,753 16,699 8,317 17,450 - 656 1,000 1,000 001.000.000.380.00.50.11 Fireworks - DCFD Remittance 300 350 400 250 300 250 300 300 300 001.000.000.380.00.50.12 Fireworks - Cleaning Deposit 3,000 2,200 3,500 2,200 2,200 3,000 3,000 2,200 2,200 001.000.000.386.12.00.00 Crime Victim Assessment 2,701 3,062 3,746 5,395 6,811 6,000 3,438 6,500 6,500 001.000.000.386.91.00.00 State - Court Remittance 124,687 145,607 178,354 316,204 399,313 391,000 194,842 391,000 391,000 Totals 158,446 182,039 211,818 343,070 432,154 405,550 205,803 405,350 405,350 001.000.000.395.20.00.00 Insurance Recoveries - 856 13,512.00 134.00 134.00 - 001.000.000.397.00.00.00 Operating Transfer In 15,834 - 14,099.00 Totals 16,690 27,611.00 134.00 134.00 Total Current Non- Revenues 158,446 182,039 228,508 343,070 459,765 405,550 205,937 405,484 405,350 Total Available Resources 3,502,451 3,992,509 4,701,735 5,272,425 6,705,035 6,721,447 3,922,595 6,707,659 9,473,523 23 CITY OF EAST WENATCHEE +FUND EXPENDITURES PAGE IOF1 CURRENT EXPENSE EXPENDITURES RECAIGENERALSUMMARY 2011 BUDGET WORKSHEET SUM MAR 1 Description 2005 Actual 2006 Actuals 2007 Actuals 2008 Actuals 2009 Actual 2010 Budget 2010 6Months 2010 Estimate 2011 Budget 001 520-596 General Government 399,409 400,952 366,066 384,425 406,107 405,109 214,965 400,226 420,734 110511 Legislative 128,149 133,994 171,505 172,990 196,936 183,800 85,920 156,311 316,600 120 512 Municipal Court 240,949 200,303 225,798 282,332 313,375 343,337 145,818 318,500 278,550 140 514 City Clerk 79,878 87,951 95,544 116,588 125,789 133,115 61,862 127,600 138,550 142 514 Finance 117,443 119,701 129,868 140,641 155,321 175,900 78,127 163,150 179,500 New Information Technoloy 60,158 55,700 145,700 68,345 151,225 92,000 141 514 Internal Services 23,290 20,070 15,250 18,036 25,851 40,700 19,804 37,200 39,200 151 515 Legal Department - 54,782 99,709 119,562 128,621 137,575 63,682 161,631 178,725 City Engineering Dept 143,500 38,576 109,977 122,380 160 521 Civil Service 4,397 3,048 4,856 3,162 2,933 2,940 126 126 2,975 180 518 Central Services 72,841 84,064 78,630 85,507 102,212 94,870 25,578 98,230 97,230 210 521 Law Enforcement 1,471,212 1,769,372 2,126,300 2,374,520 2,424,532 2,703,927 1,284,658 2,612,100 2,716,300 230 523 Jail Services 155,979 158,603 121,150 185,166 260,849 230,500 91,368 227,000 230,500 250 525 Emergency Management - 14,606 12,991 13,953 13,011 14,000 5,794 14,000 - Lots Storm Water Utility Operations 143,957 58,754 65,994 377,917 82,242 239,000 472,040 Storm Water Utility Capital Projects 579,273 503,000 40,949 107,002 2,007,363 320 532 Engineering 43,692 18,921 19,565 34,833 22,132 12,800 3,774 10,400 - 280 558 Planning 161,596 105,170 160,445 186,659 175,785 194,478 86,179 179,800 128,230 590 559 Code Compliance 119,272 105,830 120,872 132,143 132,988 140,128 67,059 138,535 129,175 Sub -Total Current Expenditures 3,018,107 3,277,365 3,892,506 4,369,429 5,187,409 5,983,296 2,464,726 5,252,013 7,550,052 001 001 586 00 05 Non -Exp Court Remittances 123,850 147,465 163,034 338,690 399,321 330,000 158,532 355,000 360,000 001 001 586 00 03 Non-Exp State Gun Permits 1,362 3,363 4,255 5,366 6,078 3,750 2,408 5,500 5,000 001 001 586 00 13 Non-Exp Kentucky Annex S&U - 142,165 205,096 219,872 126,728 60,000 34,297 60,000 10,000 Non-Exp Kent Annex PWTFL 170,788 57,000 55,835 55,835 56,000 001 001 586 00 07 Non-Exp Engr Reimburse 23,532 31,430 20,333 17,563 19,629 15,000 553 5,000 5,000 001 001 586 00 08 Cirime Victims - County Share 4,617 8,411 5,500 1,785 7,000 7,000 001 001 586 00 09 Non-Exp Turner Annex 7,209 4,450 17,462 - Non-Exp Transfers Out 43,300 Non-Exp Clearing Corrections 250,800 1,364 (19,050) 001 001 Var Non-Exp- Other 201,169 13,088 001.001.586.00.06 Building Code Surcharge 396 1,000 117 350 400 001.001.586.00.11 DCFD Fireworks Remittance 300 500 500 001.001.587.02 Contingency 4,500 4,000 4,000 4,500 Sub -Total Non - Current Expenditures 155,953 328,873 704,280 788,641 725,689 477,250 257,527 492,685 448,400 Grand -Total Current Expenditures 3,174,060 3,606,238 4,596,786 5,158,070 5,913,098 6,460,546 2,722,253 5,744,698 7,998,452 Fund Balance, End of Budget Year 328,931 386,271 104,949 114,355 789,937 310,901 913,961 1,174,032 24 2011 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 $285,900 in 2011, an increase of 11.45%. Past monthly payments were as follows: Year 2004 2005 2006 2007 2008 2009 2010 2011 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 Percent of Increase 0.00% (15.40)% 11.37% 8.59% 6.5% (5.4%) 11.45% The Wenatchee Valley Humane Society, has submitted a 2011 budget proposal of $64,600 per year. Following is a history of animal control expenditures: 25 2011 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% Wenatchee Valley Transportation Council (formerly Metropolitan Planning Organization) The membership dues amount will be $10,434 in 2011. This is the same as last year. NCW Economic Development District The membership dues amount will be $1,000 in 2009, 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,100 is budgeted for 2011. 26 CITY OF EAST WENATCHEE GENERAL GOVERNMENT EXPENDITURES GENERAL GOVERNMENT 2011 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2006 Actuals 2007 Actuals 2008 Actuals 2009 Actuals 2010 Budget 2010 2010 Estimate 2011 Budget 1 $ % 8 Months Change Change 001.000.001.520.00.00.00 Wellness Program 375 324 177 - 500 500 500 - 0.00% 001.000.001.521.10.29.00 LEOFF 1 34,010 33,407 41,719 48,324 48,000 38,582 51,200 53,500 5,500 11.46% 001.000.001.521.10.29.01 LEOFF 1 LTC Ins - - #DIV/0! 001.000.001.528.70.51.00 RiverCom 211,532 235,684 255,839 271,811 256,522 171,370 257,055 285,900 29,378 11.45% 001.000.001.537.20.51.00 Solid Waste Administration 9,486 - 1,403 - 1,403 1,403 - 0.00% 001.000.001.539.30.51.00 Animal Control 58,006 59,064 60,777 63,634 66,247 42,423 63,634 64,600 (1,647) -2.49% 001.000.001.539.90.51.00 Dept of Ecology (NPDES) 1,747 2,235 1,290 2,905 (2,905) -100.00% 001.000.001.558.20.00.00 Wenatchee Valley Trans Council 9,835 9,835 10,130 10,434 10,435 10,434 10,434 10,434 (1) -0.01 001.000.001.55820.00.01 NCW Economic Dev District 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 - 0.00% 001.000.001.558.20.00.02 Community Foundation of NCW 5,000 #DIV/0! 001.000.001.564.00.52.00 Community Mental Health (2% Liquor) 1,740 2,695 2,649 3,396 3,000 1,560 3,050 3,100 100 3.33% 001.000.001.596.00.47.00 Rental Utilities 111 1,435 1,500 404 750 200 001.000.001.596.00.47.05 Rental Rep & Maint 2,596 3,000 001.000.001.596.00.48.00 Repairs & Maintenance 34,028 1,133 2,198 784 2,000 548 1,200 1,500 (500) 0.00% 001.000.001.596.00.55.00 Donations -Region (Bridge Repairs) 10,000 10,000 10,000 001.000.001.596.00.60.00 Capital Outlay 29,930 663 2,590 - - 0.00% Totals 389,942 345,552 384,425 406,107 405,109 277,724 400,226 420,734 15,625 3.86% 27 2011 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 2011. 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 2010 membership amount is $7,117.62, the same as last year. Other Expenses Other expenses are self-explanatory according to their titles and nature. The level and changes in these expenditures reflect specific analysis by the department head. W CITY OF EAST WENATCHEE LEGISLATIVE EXPENDITURES LEGISLATIVE EXPENDITURES 2011 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2006 Actuals 2007 Actuals 2008 Actuals 2009 Actuals 2010 fidget 2010 8 Months 2010 Estimate 2011 Budget $$ % Change Change 001.000.110.511.10.10.00 Salaries 97,198 117,229 123,049 122,382 127,000 69,990 110,000 127,400 40,010 57.17% 001.000.110.511.10.20.00 Benefits 13,811 16,016 17,428 18,250 30,000 13,056 20,000 42,500 6,944 53.19% 001.000.110.511.10.31.00 Office Supplies 873 227 145 72 100 227 250 250 23 10.13% 001.000.110.511.10.31.01 Central Stores 227 401 355 - - #DIV/0! 001.000.110.511.10.41.00. Prof Services 773 800 500 27 3 49%a 001.000.110.511.10.42.01 Telephone - - 4 - #DIV/01 001.000.110.511.10.42.03 Postage 918 634 43 (7) (7) - 0.00% 001.000.110.511.10.43.00 Travel 1,824 1,502 1,400 794 1,000 1,467 1,500 1,500 33 2.25% 00l..000.110.511.10.43.01 Travel - Misawa 2,770 4,016 6,023 2,233 5,000 2,421 4,-00 5,000 2,079 85.87% 001.000.110.511.10.44.00 Advertising 647 63 788 968 600 - #DIV/0! 001.000.110.511.10.46.00 Insurance 1,959 2,201 2,531 2,673 2,800 2,834 2,800 2,900 (34) -1.20% 001.000.110.511.10.48.00 Repairs & Maintenance 67 - 152 - - - #DIV/0! 001.000.110.511.10.47.00 Background Check Costs 20 46 100 100 54 117.39% 001.000.110.511.10.49.00 Miscellaneous 7,076 9,551 14,448 4,429 4,800 3,151 4,000 4,500 849 26.94% 001.000.110.511.10.60.01 Council of Governments 23 - 35 10 50 - #DIV/0! 001.000.110.511.10.60.05 AWC Annual Fee 7,118 7,200 7,118 7,118 7,200 - 0.00% 001.000.110.511.40.00.00 Training 1,487 950 400 290 250 250 250 250 #DIV/01 001.000.110.511.70.00.00 Election Costs - Officials 3,613 7,262 6,341 5,390 5,000 7,500 - #DIV/01. 001.000.110.511.75.00.00 Election Costs - Reg Voters 14,184 15,000 001.000.110.511.90.00.00 Census Services 1,568 001.000.110.596.00.60.00 Capital Outlay - 001.000.110.517.10.00.00 Tuition Reimb 32,156 ** ** New Public Defender - Court From Municipal Court 96,000 New Public Defender - Conflicts From Municipal Court 6,000 Totals 133,994 160,119 172,990 196,937 183,800 101,076 165,495 316,600 64,419 63.73% ** Tuition Reimbursement for 2010 has been budget in each applicable department. 29 2011 BUDGET GENERAL FUND MUNICIPAL COURT Salaries The Court Administrator, Assistant Administrator, Clerical Assistant 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 $3,000 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. 30 CITY OF EAST WENATCHEE MUNICIPAL COURT EXPENDITURES MUNICIPAL COURT 2011 BUDGET WORKSHEET - Department Head BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actuals 2009 Actual 2010 Budget 2010 8 Months 2010 Estimate 2011 Budget ss Change Change 001.000.120.512.50.10.00 Salaries 77,283 85,938 98,164 108,579 158,864 89,194 145,600 180,500 34,900 23.97% 001.000.120.512.50.20.00 Benefits 32,570 37,864 47,729 52,422 60,792 36,654 58,400 70,500 12,100 20.72% 001.000.120.512.50.25.00 Tuition Reimbursement - 8,000 3,000 3,000 #DIV/0! 001.000.120.512.50.31.00 Office Supplies 2,691 2,983 3,898 3,300 3,200 2,875 3,200 3,500 300 9.38% 001.000.120.512.50.31.01 Central Stores 183 324 205 81 100 (100) -100.00% 00 1,000. 120.512.50.40.00 Training 380 95 100 265 500 300 500 1,250 750 150.00% 001.000.120.512,50.41.01 Public Defender'* 45,608 54,145 83,035 94,325 90,000 48,750 90,000 (90,000) -100.00% 001.000.120.512.50.41.02 Prosecuting Attome 153 - - 001.000.120.512.50.41.03 Judge 24,200 28,600 32,100 35,100 - #DIV/0! 001.000.120.512.50.41.05 Public Defender Confilicts 1,426 1,408 6,000 3,612 6,000 (6,000) -100.00% 001.000.120.512.50.42.01 Telephone 108 29 36 154 - #DIV/01 001.000.120.512.50.42.03 Postage 1,505 2,436 657 13 12 100 - (100) -100.00% 001.000.120.512.50.43.00 Travel 701 202 85 306 100 100 1,800 1,700 1700.00% 001.000.120.512.50.46.00 Insurance 2,603 2,661 3,131 3,273 3,381 3,380 3,300 3,500 200 6.06% 001.000.120.512.50.48.00 Repairs & Maintenance 264 - - - - - #DIV/0! 001.000.120.512.50.49.00 Miscellaneous 1,553 2,135 1,448 740 1000 538 1,000 1,000 - 0.00% 001.000.120.512.50.49.01 Interpreting Services 1,529 1,968 4,266 5,324 3,500 5,056 3,400 6,000 2,600 76.47% 001.000.120.512.50.49.02 Judge Protems 1,050 715 775 2,475 2,500 850 2,000 2,500 500 25.00% 001.000.120.512.50A9.03 Witness Fees 801 2,321 429 618 1,000 74 500 500 - 0.00% 001.000.120.512.50.49.04 Juror Fees 300 2,164 1,500 793 1,300 1,500 200 15.38% 001.000.120.596.00.60.00 Capital Outlay 7,123 3,382 4,548 2,911 3,000 2,338 3,000 3,000 - 0.00% Totals 200,303 225,798 282,332 313,377 343,337 194,507 318,500 278,550 (39,950) -12.54% 31 2011 BUDGET GENERAL FUND CITY CLERK Salaries The City Clerk and 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. 32 CITY OF EAST WENATCHEE CITY CLERK EXPENDITURES CITY CLERK 2011 BUDGET WORKSHEET - Department Head BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 2010 2010 2011 $ % Budget 8 Months Estimate Budget Change Change 001.000.140.514.10.10.00 Salaries 51,685 61,150 72,207 75,234 75,800 51,126 75,800 78,500 27,374 53.54% 001.000.140.514.10.20.00 Benefits 18,700 24,071 30,724 33,457 37,415 23,044 35,000 38,600 15,556 67.51% 001,000.140.514.10.31.00 Office Supplies 2,155 1,153 1,363 1,607 1,000 1,010 1,500 2,500 1,490 147.52% 001.000.140.514.10.31.01 Central Stores 211 372 473 6,243 5,000 3,695 6,000 7,500 3,805 102.98% 001.000.140.514.10.42.01 Telephone 83 51 6 #DIV/0! 001.000.140.514.10.42.03 Postage 980 1,180 242 (17) - #DIV/01 001.000.140.514.10.43.00 Travel 887 896 20 231 1,200 488 750 1,200 712 145.90% 001.000.140.514.10.44.00 Advertising 2,301 1,126 1,343 1,957 1,500 1,083 1,500 1,500 417 38.50% 001.000.140.514.10.46.00 Insurance 1,163 1,216 1,531 1,573 1,750 1,735 1,750 1,800 65 3.75% 001.000.140.514.10.48.00 Repairs & Maint 2,507 2,130 726 595 1,000 300 500 500 #DIV/0! 001.000.140.514.10.49.00 Miscellaneous 691 1,340 749 553 750 427 750 750 323 75.64% 001.000.140.514.30.00.00 Records Services 206 230 803 470 500 203 500 297 146.31% 001.000.140.514.30.01.00 Codification 1,404 - 5,232 2,640 5,500 2,750 3,500 3,500 #DIV/0! 001.000.140.514.40.00.00 Training 295 629 895 400 1,200 725 1,000 1,200 475 65.52% 001.000.140.596.00.60.00 Capital Outlay 4,684 - 274 849 500 500 500 500 #DIV/0! Totals 87,951 95,544 116,588 125,792 133,115 83,536 127,600 138,550 55,014 65.86% 33 2011 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. 2011 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. M CITY OF EAST WENATCHEE FINANCE EXPENDITURES FINANCE DEPARTMENT 2011 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actuals 2009 Actual 2010 Budget 2009 6 Months 2010 Estimate 2011 Budget $ 01 o Change Change 001.000.142.514.20.10.00 Salaries 73,480 76,392 87,855 102,733 104,000 52,585 104,000 111,600 59,015 112.23% 001.000.142.514.20.20.00 Benefits 28,448 30,870 31,376 36,534 47,000 18,907 40,000 48,000 29,093 153.87% 001.000.142.514.20.31.00 Office Supplies 2,743 1,136 2,376 1,572 1,000 1,459 2,000 2,000 541 001.000.142.514.20.31.01 Central Stores 109 193 257 - #DIV/0! 001.000.142.514.20.42.01 Telephone 11 10 - - 001.000.142.514.20.42.03 Postage 587 729 234 7 - 001.000.142.514.20.43.00 Travel 339 506 742 157 500 500 500 500 #DIV/0! 001.000.142.514.20.46.00 Insurance 1,025 851 1,261 1,373 1,400 34 1,400 1,600 1,566 001.000.142.514.20.48.00 Repairs & Maintenance 1,889 1,362 1,434 1,362 2,500 110 1,000 750 640 581.82% 001.000.142.514.20.49.00 Miscellaneous 2,158 305 4,832 1,934 2,000 1,473 2,000 2,300 827 56.14% 001.000.142.514.20.49.05 Tax Rtn Diff Form 941 (3,792) " 001.000.142.514.23.00.00 Budgeting, Accounting, Auditing2,735 6,724 15,816 8,262 12,694 9,000 3,265 5,000 6,000 83.77% 001.000.142.514.40.00.00 Training 250 818 995 160 1,000 750 750 750 001.000.142.596.00.60.00 Capital Outlay 1,938 880 1,017 587 7,500 294 6,500 6,000 5,706 Totals 119,701 129,868 140,641 155,321 175,900 78,127 163,150 179,500 101,373 129.75% 35 2011 BUDGET GENERAL FUND INFORMATION TECHNOLOGY Contracted Services The City currently provides information technology support through an independent contractor, who reports to the Mayor. At 2011 Budget deliberations, this position is vacant and the City has contracted on a short-term basis with a local information technology service company. Capital Expenditures Computer 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. 36 CITY OF EAST WENATCHEE p R/� p Ai �/ IT DEPARTMENT EXPENDITURES INFORMATION TECHNONOG I 2011 BUDGET WORKSHEET - Department Head - Mayor Lacy BARS Numbers Description 2008 Actual 2009 Actual 2010 2010 2010 2011 $ % Budget 8 Months Estimate Budget Change Change 001.000.145.514.10.10.00 IT contractor 54,288 55,700 55,700 37,133 55,700 55,700 18,567 50.00% 001.000.145.514.20.31.00 Supplies 2,459 - 2,000 952 2,000 2,000 1,048 110.08% 001.000.145.514.20.48.00 Repairs & Maint 3,331 3,000 750 1,500 2,000 1,250 166.67% 001.000.145.514.20.49.00 Miscellaneous 80 - 250 300 300 50 20.00% 001.000.145.596.00.60.01 Computer Equipment - Admin Capital - 15,000 001.000.145.596.00.60.10 Computer Licenses - Admin Capital 14,000 9,792 12,000 7,500 (2,292) 100.00% 001.000.145.596.00.60.20 Computer Software - Admin Capital 10,000 3,451 5,000 5,000 1,549 100.00% 00 1.000. 145.596.00.60.30 Computer Hardware - Admin Capital 12,000 22,518 23,000 5,000 (17,518) 100.00% 001.000.145.596.00.60.51 Computer Equipment - Police Dept Capital 5,000 1,018 2,000 2,000 982 100.00% 001.000.145.596.00.60.60 Computer Licenses - Police Dept Capital 14,000 2,257 5,900 7,500 5,243 00 1. 000. 145.596.00.60.70 Computer Software - Police Dept Capital 725 725 (725) 00 1.000. 145.596.00.60.80 Computer Hardware - Police Dept Capital 30,000 28,584 29,000 5,000 (23,584) 100.00% Capital Outlay 38,367 Totals 60,158 55,700 145,700 107,430 151,225 92,000 (15,430) -14.36% 37 2011 BUDGET GENERAL FUND INTERNAL SERVICES DEPARTMENT Telephone Line Charges 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 2010 expenditures. W CITY OF EAST WENATCHEE INTERNAL SERVICES EXPENDITURES INTERNAL SERVICES 2011 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actuals 2009 Actual 2010 Budget 2010 8 Months 2010 Estimate 2011 Budget $$ Change Change 001.000.141.514.80.31.00 Office Supplies - 38 94 0.00% 001.000.141.514.80.31.01 Copier Maintenance - 13 - - 0.00% 001.000.141.514.80.42.01 Telephone Line Charges 17,029 14,749 8,027 9,001 11,00C 7,038 11,000 11,500 500 7.10% 001.000.141.514.80.42.03 Postage Meter 486 2,267 5,102 10,995 12,000 6,645 10,000 10,000 0.00% 001.000.141.514.80.48.00 Repairs & Maintenance Postage 0 1,062 1,003 1,510 1,000 869 1,000 1,000 - 0.00% 001.000.141.514.80.49.00 Miscellaneous 685 135 156 214 300 200 300 100 #DIV/0! 001.000.141.596.00.60.00 Capital Outlay'* 1,868 2,766 3,711 4,037 16,400 9,990 15,000 16,400 1,400 14.01% Totals 20,070 20,992 18,037 25,851 40,700 24,542 37,200 39,200 2,000 8.15% �• 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. 39 2011 BUDGET GENERAL FUND LEGAL DEPARTMENT Salaries The City Attorney position will receive an increase per his employment agreement, effective January 1, 2011. The 2011 budget also includes a full-time clerical support for the City Attorney Department beginning in 2011. Benefits The benefits line item is payroll benefits, insurance premiums, and retirement contributions for the City Attorney and the new 2011 addition of a 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. 40 CITY OF EAST WENATCHEE LEGAL DEPARTMENT EXPENDITURES LEGAL DEPARTMENT 2011 BUDGET WORKSHEET -Department Head BARS Numbers Description 2006 Actua/s 2007 Actual 2008 2009 Actuals Actual 2010 Budget 2010 8 Months 2010 Estimate 2011 Budget $$ % Change Change 001.000.151.515.10.10.00 Salaries 37,640 72,443 84,123 91,218 92,500 78,864 92,500 123,800 44,936 56.98% 001.000.151.515.10.20.00 Benefits 13,165 22,077 29,455 32,553 38,300 26,391 34,000 49,600 23,209 87.94% 001.000.151.515.10.25.00 Prof Services 300 1,500 800 1,000 - (800) 001.000.151.515.10.31.00 Office Supplies 1,256 1,502 525 468 500 206 500 500 294 142.72% 001.000.151.515.10.31.01 Central Stores 137 242 360 - 100 - #DIV/0! 001.000.151.515.10.42.01 Telephone - - - - #DIV/0! 001.000.151.515.10.42.03 Postage 35 372 58 (26) 100 - #DIV/0! 001.000.151.515.10.43.00 Travel 321 373 492 92 750 97 100 100 3 001.000.151.515.10.46.00 Insurance 1,162 851 2,531 2,637 2,800 2,767 2,800 2,900 133 4.81% 001.000.151.515.10.48.00 Repairs & Maintenance - - 158 200 - 200 200 #DIV/0! 001.000.151.515.10.49.00 Miscellaneous 287 1,649 1,636 520 200 70 200 200 130 185.71% 001.000.151.515.40.00.00 Training 630 200 350 - 75 325 325 #DIV/0! 001.000.151.515.45.00.00 Licensing 550 531 531 600 69 12.99% 001.000.151.596.00.60.00 Capital Outlay 151 - 32 700 500 500 #DIV/01 Totals 54,782 99,709 119,562 128,620 137,575 109,726 131,631 178,725 68,999 62.88% Note: This budget includes the City Attorney's employment contracted salary increase and his request for a clerical assistant, as well as the other items he requested in his presentation to the budget committee. 41 2011 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. 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. 42 City of East Wenatchee, Washington General Fund Budget 2011 ENGINEERING DEPARTMENT Costs for a City Engineer (Engineering Department) BARS Account Budget 2010 2010 Six Months 2010 Estimate 2011 Budget 001.000.315.532.20.10.00 Salary 85,000 25,200 67,200 73,080 001.000.315.532.20.20.00 Benefits 34,000 1 , ,401 23,000 29,600 001.000.315.532.20.41.00 Prof Services 5,000 5,000 001.000.315.532.20.31.00 Office Supplies 400 200 200 001.000.315.532.20.43.00 Travel 750 750 1,800 001.000.315.532.20.46.00 Insurance 2,500 2,500 2,500 001.000.315.532.20.48.00 Repairs & Maintenance 001.000.315.532.20.49.00 Training 150 400 001.000.315.532.20.49.01 Miscellaneous 200 200 001.000.315.532.20.49.05 Registrations 975 2,400 001.000.315.532.20.49.10 Memberships 352 1,000 001.000.315.532.45.00.00 Licensing 500 200 001.000.315.596.00.60.00 Capital 15,000 5,976 15,000 6,000 Total Costs 143,500 38,577 109,977 122,380 Notes: 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 - 3 conferences x 2 people x $400 / 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 Capital - $3,000 for a new printer - $3,000 for new office furniture for Associate Engineer's office Note: Reflects the compensation for the City Engineer under his "new" employment agreement. 43 2011 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. CITY OF EAST WENATCHEE CIVIL + p CIVIL SERVICE EXPENDITURES CI Y`, IL SERVICE 2011 BUDGET WORKSHEET - Department Head - Finance BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actuals 2009 Actual 2010 Budget 2010 8 Months 2010 Estimate 2011 Budget $ % Change Change 001.000.160.521.10.10.00 Salaries 792 2,310 1,172 1,716 900 79 79 1,500 1,421 F 001.000.160.521.10.20.00 Benefits 66 194 99 146 100 13 13 125 112 861.54% 001.000.160.521.10.46.00 Insurance 1,338 1,181 1,631 1,035 1,840 1,234 34 1,250 16 1.30% 001.000.160.521.10.49.00 Miscellaneous 852 1,171 260 36 100 100 100 #DIV/0! Totals 3,048 4,856 3,162 2,933 2,940 1,326 126 2,975 1,649 124.36% 45 2011 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 2011, a portion of the carpet in City Hall will be replaced in the 3rd year as a part of a 3-year replacement program. 46 CITY OF EAST WENATCHEE CENTRAL SERVICES EXPENDITURES CENTRAL SERVICES 2011 BUDGET WORKSHEET - Department Head BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget $ % Change Change 001.000.180.518.10.10.00 Salaries 13,690 14,750 782 #DIV/0! 001.000.180.518.10.20.00 Benefits 8,155 8,850 359 #DIV/0! 001.000.180.518.10.31.00 Office Supplies 570 50 130 166 500 13 100 200 187 1438.46% 001.000.180.518.10.31.02 Central Stores 82 150 65 228 80 44 80 80 36 81.82% 001.000.180.518.10.31.06 Cleaning Supplies 1,570 2,500 2,407 1,713 2,200 693 1,500 2,200 1,507 217.46% 001.000.180.518.10.35.00 Small Tools & Equipment 607 400 161 762 400 - - #DIV/0! 001.000.180.518.10.41.00 Professional Services Services 12,300 15,829 13,326 10,000 5,177 10,000 10,000 4,823 93.16% 001.000.180.518.10.41.01 Contracted Custodial Services 5,905 15,765 19,000 6,749 17,000 19,000 12,251 182% 001.000.180.518.10.46.00 Insurance 10,410 11,130 12,631 13,073 13,750 - 13,750 13,750 13,750 #DIV/0! 001.000.180.518.10.47.00 Utilities 12,098 14,000 18,699 19,260 19,440 6,236 19,000 20,000 13,764 220.72% 001.000.180.518.10.48.00 Repairs & Maintenance 3,428 3,000 19,502 17,424 4,000 557 8,000 3,500 2,943 528.37% 001.000.180.518.10.49.00 Miscellaneous 1,330 2,500 2,123 2,407 1,500 1,436 1,500 1,500 64 4.46% 001.000.180.518.10.49.01 Landscaping 414 1,500 5,837 1,572 2,000 75 300 (75) -100.00% 001.000.180.518.92.00.00 Ancillary 7,806 5,000 103 3,024 2,000 1,730 2,000 2,000 270 15.61% 001.000.180.596.00.60.00 Capital Outlay 12,625 2,500 974 13,493 20,000 2,869 25,000 25,000 22,131 771.38% Totals 84,064 78,630 85,507 102,213 94,870 25,579 98,230 97,230 71,651 280.12% Notes: Cleaning Supplies - Dana provides input Professional Services - Divco Contract - $8,500 annual fee + $347 for Police Admin Bldg + Appleand Pest Control x 3 - Should probably be in called something other than "Professional Services". Contracted Custodial Services - ABM Janitorial Contract - $17,100 annual fee + floor stripping, etc. Repairs and Maintenance - 2010 - $6,000 additional for City Hall door repair and update to ADA Miscellaneous - Medical supplies Ancillary - Salaries for minor repairs Capital Outlay - $15,000 for furniture for Police Administration Building + $5,000 for modification to main police entrance + $5,000 for Council Chambers sound system. 47 2011 BUDGET GENERAL FUND LAW ENFORCEMENT Salaries This line item is salaries for the Police Chief, Assistant Police Chief, and police bargaining unit and police clerical bargaining unit employees. The Police Chief compensation is not proposed for change in 2011. This position receives a 5% longevity incentive for completion of twenty- five consecutive years of service. The Chief also receives $10,000 in additional compensation annually for Emergency Management Services for the City. The Assistant Police Chief compensation is also not proposed for change in 2011, but receives a 3% longevity incentive. 2010 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. 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 1/2 months of the school year. Because of budget constraints, this funding is not available in 2010 or 2011, and 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. ClothinE Allowance This figure is for the purchase and maintenance (not including drycleaning) of uniforms and police -related equipment. SRO Benefits See SRO salary above. .6 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. 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). 50 Jail Services - Detention Housing of prisoners is provided by the Chelan County Regional Justice Center under an interlocal agreement. Per -day charges are $73.50. Utilization is expected to be similar in 2011 in comparison to 2010, consequently 2011 reflects a budget amount equal to 2010. 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. 51 CITY OF EAST WENATCHEE LAW ENFORCEMENT EXPENDITURES LAW ENFORCEMENT 2011 BUDGET WORKSHEET - Department Head - Police Chief BARS Numbers Description ZUU6 Actuals ZU07 Actual 2008 Actual 2009 Actual Zulu Budget Zulu 8 Months Zulu Estimate zull Budget ang nge 001.000.210.521.10.10.00 Salaries 1,059,281 1,263,672 1,479,147 1,551,757 1,634,917 1,080,663 1,625,000 1,650,000 25,000 1.54% 001.000.210.521.10,10.01 COPS Salaries 8,614 - - - 49,868 14,484 44,400 51,400 7,000 001.000.210.521.10.10.02 Overtime Salaries 44,912 68,951 58,838 64,000 51,400 31,180 48,500 51,400 2,900 5.98% 001.000.210.521.10.10.03 Overtime Sal - _ _ _ _ 5,000 3,052 2,500 6,000 Traffic Control 3,500 001.000.210.521.10.10.05 SRO Salaries 11,956 16,532 7,247 - #DIV/01 001.000.210.521.10.20.00 Benefits 379,511 469,624 546,612 583,725 656,419 435,977 650,000 669,000 19,000 2.92% 001.000.210.521.10.20.01 Clothing 8,357 7,327 14,162 12,131 13,800 9,012 13,800 13,800 Allowance - 0.00% 001.000.210.521.10.20.02 COPS Benefits 4,620 - 20,423 2,667 20,000 20,500 500 001.000.210.521.10.20.03 CRDTF Benefits - - - 001.000.210.521.10.20.05 SRO Benefits 4,104 5,951 2,669 - #DIV/0! 001.000.210.521.10.25.00 Tuition Reimbursement 57,000 21,045 40,000 40,000 001.000.210.521.10.31.00 Office Supplies 6,984 6,697 6,542 5,339 5,500 1,289 5,000 5,000 _ 0.00% 001.000.210.521.10.31.01 Central Stores 297 531 267 - #DIV/0! 001.000.210.521.10.32.00 Fuel Consumed 42,551 44,078 64,807 45,419 48,700 26,489 46,700 47,000 300 0.64% 001.000.210.521.10.35.00 Small Tools & 8,397 12,439 10,212 4,886 7,000 5.126 7,000 7,900 E ui ment 900 12.86% 001.000.210.521.10.35.01 WASGran PC Block - _ _ _ 3,000 3,000 001.000.210.521.10.35.02 WASPC Traffic 2,052 - - - 2,500 Safe Grt 2,500 001.000.210.521.10.41.00 Professional Services 6,761 7,308 6,965 7,542 7,000 4,466 6,500 6,800 300 4.62% 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 13,000 11,303 17,500 17,700 200 1.14% 001.000.210.521.10.42.03 Postage 695 906 471 387 800 196 500 500 0.00% 001.000.210.521.10.43.00 Travel 3,982 4,512 7,089 5,086 5,000 3,020 5,000 5,000 0.00% 001.000.210.521.10.44.00 Advertising - - 245 - #DIV/0! 001.000.210.521.10.46.00 Insurance 23,178 24,997 27,653 28,211 28,000 29,068 28,000 28,000 0.00% 001.000.210.521.10.48.00 Repairs & 43,440 43,817 55,196 46,715 41,000 30,013 40,000 40,000 Maintenance 0.00% 001.000.210.521.10.49.00 Miscellaneous 3,949 4,399 2,286 3,849 3,500 1,773 3,000 3,000 0.00% 001.000.210.521.10.49.01 Reserves 2,990 490 3,554 - 1,000 707 1,000 1,000 0.00% 001.000.210.521.10.49.02 Drycleaning 2,695 4,003 4,545 2,645 4,500 1,650 3,500 4,000 500 14.29% 001.000.210.521.23.01.00 K-9 Unit 295 682 834 - - #DIV/0! 001.000.210.521.30.00.00 Crime Prevention 450 330 456 200 200 #DIV/0! 001.000.210.521.40.01.00 Training - 400 400 Chief 400 #DIV/01 001.000.210.521.40.02.00 Training - 1,500 1,192 2,053 1,344 2,000 1,050 2,000 2,000 Officers - 0.00% 001.000.210.521.40.03.00 Training - Office Staff 500 - 90 - 100 - 100 100 0.00% 001.000.210.521.30.02.00 TrfSftyComm 6,146 Grant Subtotal 1,688,441 2,009,117 2,322,326 2,380,895 2,660,927 1,714,230 2,570,000 2,676,200 106,200 4.13% 52 CITY OF EAST WENATCHEE LAW ENFORCEMENT EXPENDITURES LAW ENFORCEMENT 2011 BUDGET WORKSHEET PAGE 2 OF 2gths AGE 2 OF 2 GE 2 OF 2 BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Budget 2010 Estimate 2011 Budget $$ % Change Change Balance Forward 1,688,441 2,009,117 2,322,326 2,380,895 2,660,927 1,714,230 2,570,000 2,676,200 106,200 4.13% 001.000.210.521.90.00.00 Other Services 235 445 445 500 1,000 1,070 1,100 1,100 0.00% 001.000.210.521.90.01.00 Ancillary 8,035 3,644 6,127 4,228 6,000 3,901 6,000 5,500 (500) -8.33% 001.000.210.525.92.00.00 Emerg Services 379 001.000.210.596.00.60.00 Capital Outlay 72,662 56,837 45,243 38,909 36,000 12,699 35,000 33,500 (1,500) -4.29% Totals 1,769,372 2,070,043 2,374,520 2,424,532 2,703,927 1,731,900 2,612,100 2,716,300 104,200 3.99% Jail Services - Finance 001.000.230.523.20.00.00 Detention 155,979 121,150 182,086 250,839 220,000 114,965 220,000 220,000 0.00% 001.000.230.523.20.00.01 Medical Care for Prisoners 2,623 - 3,000 3,000 3,000 0.00% 001.000.230.523.20.00.02 Juvenile Detention 3,080 10,010 7,500 2,480 4,000 7,500 3,500 001.000.230.523.20.00.02 Totals 158,603 121,150 185,166 260,849 230,500 117,445 227,000 230,500 3,500 1.54% Emergency Management - Police Chief 001.000.250.525.10.10.00 Salaries 10,111 10,122 10,109 10,008 10,000 6,672 10,000 (10,000) -100.00% 001.000.250.525.10.20.00 Benefits 2,806 2,869 2,940 3,003 3,000 822 3,000 (3,000) -100.00% 001.000.250.525.10.30.00 Equipment 1,688 - 904 1,000 1,000 (1,000) -100.00% Totals 14,606 12,991 13,953 13,011 14,000 7,494 14,000 (14,000) -100.00% 53 2011 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. 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. The City is represented on the Storm Water Utility by the City Engineer, Community Development Director, and an assigned City Council Member as a "City Management Team" to provide the necessary collaboration and coordination with representative from Douglas County to successfully manage, maintain and extend the storm water system. Based upon the above, the enclosed revenue and expenditure budgets are significantly higher in 2011 compared to the 2010 budgets. Capital construction work on the Canyon A project is estimated to be over $1.2 million in 2011, compared to a budget of $433,000 in 2010. The Canyon A work will now be accomplished by WSDOT (Washington State Department of Transportation) as a segment of the Sellar Bridge Project, and has been delayed because of the timing of planning and completion of bridge access work. The City also expects to complete additional capital construction of approximately $420,000 to retrofit catch basins. This 2011 budget has also committed over $300,000 for compliance with NPDES regulations (National Pollutant Discharge Elimination System). Storm water work that was previously classified as "maintenance" will now also be included in this caption under the "good housekeeping" section of the regulations. Also note the expenditure the City makes to the Greater East Wenatchee Storm Water Utility as its annual utility charge or fee for impervious surfaces in the City. This fee is revenue to the GEWSWU and consequently is not a reimbursed cost back to the City. As noted in the revenue portion of the budget, the City is reimbursed by the GEWSWU for all of its costs incurred for Storm Water work. The GEWSWU receives fees from residents of the City and County through an annual charge, borrows funds through State Public Works Trust Fund Loans to support funding for capital projects, and has received grants to help defray costs of implementation and compliance with NPDES regulations described above. I CITY OF EAST WENATCHEE STORM WATER UTILITY - REVENUE CITY STORM WATER UTILITY 2011 BUDGET WORKSHEET - Department Head 7 BARS 2009 2010 2010 2010 2011 Numbers Description Actual Bucrget 9 Months Estimate Budai 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 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 050.000.000.343.13.00.77 050.000.000.343.13.00.79 050.000.000.343.13.00.81 050.000.000.343.13.00.90 86, 600 I 46,8081 49,000 I 15,300 35,832 - 6,500 6,500 - 150,000 363,000 26,612 26,612 1,087,000 45,000 - - - 25,000 - - - 32, 860 217,140 200,000 220,363 68, DOE DC NPDES Ph2 G0600351 49,317 38,783 38,783 50,000 DOE CEW NPDES Ph2 G1000254 35,000 - - 50,000 DOE COW NPDES Ph2 G1000365 4,500 - 3,500 DOE COW NPDES Ph2 00000366 3,600 - 2,400 Greater EW SWU NPDES 57,400 - - 114,800 O&M Allocation 100,000 EW Share Comp Plan 20,000 TOTAL STORM WATER UTILITY REVENUES 61�i 1 149,817 1 387783 1 38,783 1 307,340 1 ,417 CITY OF EAST WENATCHEE STORM WATER UTILITY - EXPENDITURES CITY STORM WATER UTILITY 2011 BUDGET WORKSHEET - Department Head BARS Numbers Description 2007 Actual 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget $ % Change Change SWU Maintenance 050.000.310.531.30.10.00 Salaries 8,914 14,096 14,776 34,000 26,203 30,000 (30,000) -100.00% 050.000.310.531.31.20.00 Benefits 2,769 4,623 5,354 16,000 12,271 14,000 (14,000) -100.00% 050.000.310.531.30.30.00 Supplies 2,010 536 4,814 3,000 2,295 2,500 (2,500) -100.00% 050.000.310.531.30.41.00 Prof Services 289 765 2,000 6,294 7,000 (7,000) -100.00% 050.000.310.531.30.44.00 Advertising 98 100 (100) -100.00% 050.000.310.531.30.45.00 Rentals/Leases 6,480 326 22,000 1,784 2,000 (2,000) -100.00% 050.000.310.531.30.47.00 Utilities 491 519 1,229 956 1,000 (1,000) -100.00% 050.000.310.531.30.48.00 Repairs/Maint 138 13 103 3,000 1,000 (1,000) -100.00% 050.000.310.531.30.49.00 Miscellaneous - #DIV/0! 050.000.310.596.30.60.00 Capital Outlay - #DIV/0! tal Maintenance Expenditures 21,091 20,878 26,276 49,901 57,600 (57,600) -100.00% BARS Numbers Description 2007 Actual 2008 Actual 2009 Actual iu Budget 2010 6 Months _`0:'0 Estima'- I 2011 Budget $ % Change Change SWU Administration 050.000.311.531.31.10.00 Salaries 5,400 38 100 8,880 0.00% 050.000.311.531.31.20.00 Benefits 1,900 43 50 5,920 0.00% 050.000.311.531.31.41.00 Prof Services 8,366 2,327 4,602 1,200 260 300 (300) -100.00% 050.000.311.531.31.44.00 Advertising 442 500 050.000.311.531.31.49.00 Miscellaneous 200 276 270 1,000 #DIV/0! 050.000.311.531.31.51.00 InterGovtProfSvcs - 334 3,500 #DIV/0! 050.000.311.531.31.90.00 Admin-Accounting 3,600 #DIV/0! 050.000.311.596.31.60.00 Capital Outlay Total Administration Expenditures 8,566 2,937 5,314 16,600 341 450 15,300 14,850 3300.00% Note: Maintenance Activities are now consolidated in the NPDES portion of the Storm Water Utility Budget in the "Polution Prevention and Good Housekeeping" category. 56 BARS Numbers Description 2007 Actual 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 20;; Budget $ % Change Change SWU Capital/Construction 050.000.312.531.32.00.00 Small Projects 70,000 11,878 25,000 100,000 75,000 300.00% 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 050.000.312.531.32.00.15 CnynA Constr Phase 2 432,612 2,069 3,000 050.000.312.531.32.01.05 CnynA Dsn Phase 3 3,994 27,002 27,002 050.000.312.531.32.01.12 Cnyn A SDC Phase 3 33,000 150,000 050.000.312.531.32.01.15 Cnyn A Constr Phase 3 330,000 1,087,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 8,000 050.000.312.531.32.02.15 Cnyn A Constr Phase 4 62,000 32,000 Cnyn A SDC - Eastmont to 2nd 32,860 Cnyn A Constr - Eastmont to 2nd 217,140 Retrofit 5 Catch Basins 200,000 23rd Street Retro-fit 220,363 050.000.312.531.32.30.00 Prof Services 2,116 050.000.312.531.32.41.00 Supplies 200 138 #DIV/0! 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 #DIV/0! 050.000.310.531.30.60.00 Capital Outlay - - #DIV/0! tal Construction Expenditures 200 20,985 579,273 503,000 40,949 87,002 2,007,363 ####### 2207.26% BARS Numbers Description 2007 Actual 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget $ % Change Change SWU NPDES REGS 050.000.313.531.33.10.00 Salaries 2,437 60,224 105,100 050.000.313.531.33.20.00 Benefits 27,093 43,150 050.000.313.531.33.30.00 Supplies 12,126 1,000 10,950 050.000.313.531.33.31.00 Office Supplies 24 300 050.000.313.531.33.35.00 Small Tools & Equipment 8,000 050.000.313.531.33.40.00 Training 6,000 6,000 050.000.313.531.33.41.00 Professional Svcs 9,643 35,000 4,231 2,100 050.000.313.531.33.42.00 Postage 700 1,100 050.000.313.531.33.43.00 Travel 2,300 2,000 050.000.313.531.33.44.00 Advertising 232 1,500 91 2,000 050.000.313.531.33.49.00 Miscellaneous 9,942 1,300 3,890 050.000.313.531.33.51.01 DEOE Ms4 Annual Permit 2,900 3,050 Equipment Rental 27,000 Contracted Services 66,000 InterGpvt Services 30,000 Monitoring 5,000 050.000.313.531.33.90.00 Administration 3,500 Total NPDES Expenditures 34,404 149,817 4,322 307,340 050.000.315.531.341.00 Annual Utility Char e 114,100 114,065 114,065 131,500 131,750 149,400 Grand total SWU Expenditures 143,957 158,865 759,332 1 880,917 1 95,513 1 276,802 1 2,479,403 1 54 57 Small Projects - chronic flooding / stormwater problems - 3rd & Jarvis - $50,000 - Ashland / Astor - $50,000 - Dolfav - $25.000 - Gail - $25,000 - Clean / weed abatement for ponds - $7,500 - GIS work by County (Todd) - $2,500 Canyon A Phase 3 - $1,000,000 = latest engineer's estimate from WSDOT including sales tax and engineering. Canyon A Phase 4 - Culvert inlet modification (trash rack) - $29,157 (bid) + $1,500 (change order) — $32,000 Cnyn A Constr - Eastmont to VMP - $217,140 + 15% for construction engineering — $250,000 Retrofit 5 Catch Basins - $112,500 grant + $37,500 match = $150,000 58 2011 BUDGET GENERAL FUND ENGINEERING SERVICES The City contracts for engineering services. The actual cost of all project review of land use applications is reimbursed to the City by the applicant. Based upon the City's decision to hire a City Engineer, the outside use and necessity for outside engineering resources has lessened. By the beginning of 2011, these resources are expected to be provided internally. Previously, other engineering expenses in past years` have been broken out under the following categories: Planning Contracted engineering services associated with the planning department. Code Compliance Contracted engineering services associated with the code compliance department. Street Contracted engineering services associated with the street department maintenance and on -going capital projects. Other Miscellaneous engineering services. Design Manual Ongoing updates to engineering design standards. This cost represents compiling the City's own standards, as opposed to relying upon other agency standards. Transportation Planning Contracted engineering services associated with transportation planning. NPDES These costs will now be incurred and reimbursed based upon available grants accounted for Fund 102 — Community Development Grants Fund. NOTE: The 2010 budget for outside engineering services has been reduced to acknowledge and recognize the plan to hire a City Engineer, and the expectation that the acquired internal resources will replace or offset a large portion of the historical cost for outside engineering services. Z CITY OF EAST WENATCHEE ENGINEERING SERVICES EXPENDITURES ENGINEERING SERVICES PAGE 1 OF 1 2011 BUDGET WORKSHEET -Department Head BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Budget 2010 Six Months 2010 Estimate 2011 Budget $ % Change Change 001.000.320.532.20.01.00 Planning 8,407 2,787 8,581 3,871 5,000 2,368 5,000 (5,000) -100.00% 001.000.320.532.20.02.00 Code Compliance 312 266 - 377 300 300 (300) -100.00% 001.000.320.532.20.03.00 Street 4,809 14,788 17,780 14,409 - 1,092 2,000 (2,000) -100.00% 001.000.320.532.20.04.00 Other 1,909 33 1,893 - 2,000 - #DIV/0! 001.000.320.532.20.05.00 Design Manual 1,420 1,500 54 100 (100) -100.00% 001.000.320.532.20.06.00 NPDES 2,740 322 135 - 0.00% 001.000.320.532.20.07.00 Transportation Planning 1 744 1 1,369 6,444 2,054 4,000 260 3,000 (3,000) -100.00% Totals 18,921 19,565 34,833 22,131 12,800 3,774 10,400 (10,400) -100.00% Note: Street Engineering is now a function of the City Engineer and is included in that Department. This fund will no longer be used. 60 2011 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. 61 CITY OF EAST WENATCHEE PLANNING DEPARTMENT EXPENDITURES PLANNING DEPARTMENT 2011 BUDGET WORKSHEET -Department Head Expenditures 2010 Est to Budget BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actuals 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget $$ Change Change 001.000.580.558.10.10.00 Salaries 65,660 109,035 124,477 125,822 131,000 63,466 128,000 84,600 (43,400) -33.91% 001.000.580.558.10.20.00 Benefits 21,310 34,752 37,954 38,841 45,200 19,414 39,700 29,600 (10,100) -25.44% 001.000.580.558.10.31.00 Office Supplies 3,236 1,102 683 628 1,000 176 500 700 200 40.00% 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 500 56 250 250 - 0.00% 001.000.580.558.10.35.00 Small Tools & Equipment - - 168 92 300 12 100 200 100 100.00% 001.000.580.558.10.41.00 Professional Services 1,380 4,982 3,924 2,283 5,000 85 2,000 4,000 2,000 100.00% 001.000.580.558.10.41.01 Hearings Examiner - - 1,350 - 1,200 900 1,350 900 (450) -33.33% 001.000.580.558.10.42.01 Telephone 183 232 48 - 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 1,500 23 1,000 600 (400) -40.00% 001.000.580.558.10.44.00 Advertising 578 1,844 1,453 2,269 2,500 975 1,700 2,200 500 29.41% 001.000.580.558.10.46.00 Insurance 2,262 2,401 2,831 2,885 3,078 34 3,000 3,000 - 0.00% 001.000.580.558.10.48.00 Repairs & Maintenance 500 396 774 494 400 202 400 800 400 100.00% 001.000.580.558.10.49.00 Miscellaneous 3,606 1,955 1,158 1,414 1,300 853 1,300 700 (600) -46.15% 001.000.580.558.20.41.00 GMA (DCTED) 570 - - 001.000.580.558.40.00.00 Training 790 441 822 595 1,500 500 680 180 36.00% 001.000.580.596.00.60.00 Capital Outlay 4,080 745 8,952 Totals 105,170 160,445 186,659 175,785 194,478 86,180 179,800 128,230 (51,570) -28.68% Note: This budget includes the compensation recommendations for both the Director and the Permit Tech. Does not include any costs for the Associate Planner position. 2009 Actual 2010 Budget 2010 7 Months 2010 Estimate I 2011 Budget Revenue 001.000.000.342.40.00.01 Fire Marshal Ser 250 - 150 201 200 001.000.000.345.80.00.00 Planning & Dev Fees 10,490 6,000 1,706 2,925 57000 001.000.000.345.89.00.00 SEPA Fees 483 1,000 276 1,000 11,223 7,000 2,017 1 3,402 6,200 62 Planning 2011 BC.xls 2011 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 2011. 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. 63 CITY OF EAST WENATCHEE CODE COMPLIANCE DEPARTMENT EXPENDITURES CODE COMPLIANCE 2011 BUDGET WORKSHEET - Department Head Expenditures 2010 Est to Budget BARS 2006 2007 2008 2009 2010 2010 2010 2011 $ % Numbers Description Actuals Actual Actual Actual Budget 6 Months Estimate Budget Change Change 001.000.590.559.10.10.00 Salaries 67,237 71,274 74,759 76,234 77,000 38,317 77,000 70,000 (7,000) -9.09% 001.000.590.559.10.20.00 Benefits 23,735 27,419 35,441 37,085 40,000 19,107 40,000 38,000 (2,000) -5.00% 001.000.590.559.10.31.00 Office Supplies 551 1,181 629 95 2,000 782 1,700 600 (1,100) -64.71% 001.000.590.559.10.31.01 Central Stores 55 97 235 - 0.00% 001.000.590.559.10.32.00 Fuel Consumed 510 464 938 527 850 183 550 600 50 9.09% 001.000.590.559.10.35.00 Small Tools & Equipment - 16 - 13 200 - 100 200 100 100.00% 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 8,150 16,300 16,300 0.00% 001.000.590.559.10.42.01 Telephone 52 46 13 - 001.000.590.559.10.42.03 Postage 52 54 14 - 50 - 001.000.590.559.10.43.00 Travel 2 132 253 7 5d0 300 400 100 33.33% 001.000.590.559.10.44.00 Advertising - - - - 100 - 100 100 001.000.590.559.10.46.00 Insurance 1,190 1,001 1,566 1,673 1,728 34 1,700 1,700 - 0.00% 001.000.590.559.10.48.00 Repairs & Maintenance 6 232 868 339 300 100 425 325 325.00% 001.000.590.559.10.49.00 Miscellaneous 215 516 792 480 500 485 500 350 (150) -30.00% 001.000.590.559.40.00.00 Training 294 335 235 600 285 500 215 75.44% 001.000.580.596.00.60.00 Capital Outlay 373 - - Totals 105,830 119,434 132,143 132,988 140,128 67,058 138,535 129,175 (9,360) -6.76% 2009 Actual 2010 Budget 2010 7 Months 2010 Estimate 2011 Budget Revenue 001.000.000.322.10.00.00 Building & Structure Permits 64,690 46,500 24,979 1 42,821 46,000 001.000.000.345.83.00.00 Plan Checking Fees 27,619 30,000 12,902 22,118 20,000 001.000.000.380.00.50.00 State Surcharge (Bldg Code) 396 300 342 387 360 92,705 11 76,800 11 38,223 65,326 11 66,360 64 Code Compliance 2011 BC.xls 2011 BUDGET STREET FUND REVENUES Property Tax The Street Fund is allocated a portion of property tax receipts. For 2011, $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 201.1, $275,000 has been budgeted. Licenses & Permits Street and curb permits are expected to be the same in 2010. Intergovernmental Revenue Street Fuel Excise Tax is received from the State and is limited in use for street maintenance. $245,000 has been budgeted for 2011. Miscellaneous Sales tax interest is budgeted at $1,200 for 2011. This is an allocation of a portion received from the State each month, and is lower because of the decline in effective interest rates. 65 CITY OF EAST WENATCHEE STREET FUND 101 REVENUES STREET FUND REVENUES 2011 BUDGET WORKSHEET BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Budget 2010 9 Months 2010 Estimate 2011 Budget $$ % Change Change 101.000.000.308.00.00.00 Beginning NC&I 57,175 50,684 101,977 45,082 46,717 25,948 25,948 160,000 Totals 57,175 50,684 101,977 45,082 46,717 25,948 25,948 160,000 134,052 516.62% Taxes 101.000.000.311.10.00.00 Property Tax 99,519 157,317 244,446 200,000 200,000 75,000 200,000 200,000 0.00% 101.000.000.311.10.00.01 Contingency Property Tax _ #DIV/01 101.000.000.313.10.00.00 Sales & Use Tax 300,261 478,650 488,566 469,064 625,000 275,000 385,000 275,000 (110,000) -28.57% Totals 399,780 635,967 733,012 669,064 825,000 350,000 585,000 475,000 (110,000) -18.80% Licenses & Permits 101.000.000.322.40.00.00 Street & Curb Permits 6,980 7,552 3,528 2,130 1,500 1,983 1,500 1,500 0.00% Totals 6,980 7,552 3,528 2,130 1,500 1,983 1,500 1,500 0.00% Intergovernmental Revenue 101.000.000.336.00.87.00 Street Fuel Excise 247,511 252,637 262,848 251,701 245,000 186,324 245,000 245,000 0.00% 101.000.000.336.00.88.00 Arterial Street Excise Fuel Tax Totals 247,511 252,637 262,848 251,701 245,000 186,324 245,000 245,000 0.00% 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 100 178 #DIV/0! 101.000.000.361.00.00.00 Interest Earnings 8,693 2,838 987 #DIV/0! 101.000.000.361.40.00.00 Sales Tax Interest 1,805 2,347 2,248 2,012 2,100 816 1,200 1,200 0.00% 101.000.000.363.00.00.00 Insurance Claims Pym 4,583 40,278 - Totals 21,517 45,684 40,397 2,467 2,200 994 1,200 1,200 _ 0.00% Grand Total Current Revenue 675,788 941,840 1,039,785 925,362 1,073,700 539,301 832,700 722,700 (110,000) -13.21% Total Available Resources 732,963 992,524 1,141,762 970,444 1,120,417 565,249 858,648 882,700 24,052 2.80% 66 2011 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. 67 CITY OF EAST WENATCHEE STREET FUND 101 EXPENDITURES STREET FUND EXPENDITURES 2011 WORKSHEET BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 Budget 2010 9 Months 2010 Estimate 2011 Budget $$ % Change Change Total Available Resources 732,963 1,141,762 970,444 1,120,417 565,249 858,648 882,700 24,052 0 Maintenance t20,769 101.000.420.542.30.00.00 Roadway 17,166 13,087 49,005 45,000 30,723 40,000 30,000 (10,000) 25.00% 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 5,000 1,236 2,000 101.000.420.542.61.00.00 Sidewalks 3,077 2,806 11,666 8,381 14,000 4,438 8,000 14,000 6,000 75.00% 101.000.420.542.62.00.00 Special Purpose Paths 6,578 5,288 5,224 5,202 15,000 9,864 12,000 15,000 3,000 25.00% 101.000.420.542.63.00.00 Street Lighting 40,618 40,337 53,937 47,593 45,000 38,964 45,000 45,000 0.00% 101.000.420.542.64.00.00 Traffic Control Devices 96,256 88,958 121,271 89,160 100,000 104,995 120,000 100,000 (20,000) -16.67% 101.000.420.542.65.00.00 Parking Facilities 894 464 107 384 2,000 1,092 2,000 2,000 0.00% 101.000.420.542.66.00.00 Snow &Ice Control 68,671 72,315 85,778 71,852 85,000 15,845 80,000 80,000 0.00% 101.000.420.542.67.00.00 Street Cleaning 37,162 43,264 33,482 27,420 30,000 32,735 40,000 10,000 (30,000) -75.00% 101.000.420.542.70.00.00 Roadside 94,404 143,840 170,194 126,018 100,000 114,040 130,000 100,000 (30,000) 23.08% 101.000.420.542.75.00.00 City Parks 4,278 45,000 42,552 45,000 45,000 0.00% 101.000.420.542.90.00.00 Maintenance Administration 51,240 52,609 64,293 63,652 60,000 20,622 30,000 30,000' 0.00% Totals 422,186 474,851 560,134 495,316 546,000 417,106 554,000 471,000 (83,000) -14.98% Administration 101.000.430.543.30.00.00 General Services 16,907 17,352 24,355 18,135 21,500 19,781 21,500 15,000 (6,500) -30.23% 101.000.430.543.50.00.00 Facilities 4,010 62,118 25,381 11,308 14,000 4,778 10,000 10,000 0.00% 101.000.430.543.60.00.00 Training 3,467 4,397 5,218 2,886 5,500 5,164 5,500 5,500 0.00% 101.000.430.543.90.49.00 Miscellaneous 214,303 304,538 9,000 8,179 4,000 2,835 4,000 4,000 _ 0.00% 101.000.430.543.90.49.10 Misc Salaries - 102,266 92,594 90,000 50,382 70,000 75,000 5,000 7.14% 101.000.430.543.90.49.20 Street Benefits 201,351 187,491 205,000 62,744 90,000 165,000 75,000 83.33% 101.000.430.596.00.60.00 Capital Outlay 15,332 27,291 54,912 14,521 8,000 1,398 5,000 10,000 5,000 100.00% Totals 254,020 415,696 422,483 335,114 348,000 147,082 206,000 284,500 78,500 38.11% Grand Totals All 676,205 890,547 982,616 830,430 894,000 564,188 760,000 755,500 (4,500) -0.59% Ending NC & 1 56,758 101,977 159,146 140,014 226,417 1,061 98,648 127,200 28,552 0 Notes: Roadway - Patching + Crackseal Eastmont, 9th Street 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 - Brandon's salary Misc Salaries - overtime and compensatory time 68 Note: Includes reduction of Raodway, Street Cleaning, and Maintenance Administration, recognizing the transfer of a portion of these costs to Storm Water Utility Activities. 2011 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. 69 CITY OF EAST WENATCHEE COMMUNITY DEVELOPMENT GRANTS FUND102 COMMUNITY DEVELOPMENT GRANTS 2011 BUDGET WORKSHEET - Department Head Description 2007 Actual Actual 2008r28, 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget Revenues 102.000.000.308.00.00.00 Beginning NC&I 20,931 2,208 9,782 2,034 2,034 Totals 20,931 2,208 9,782 2,034 2,034 2,034 102.000.000.334.03.11.00 DOE - NPDES Phase II 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 124,121 25,703 98,418 102.000.000.345.89.00.01 SMP - DCT&LS Reimbursement 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 124,121 25,703 98,418 Resources Available 49,038 8,788 36,438 133,903 2,034 27,737 100,452 Expenditures SMP Professional Services 1,155 SMP Office Supplies 6 138 102.000.000.558.21.10.00 CDBG Salaries 13,270 15,000 14,000 102.000.000.558.21.10.00 CDBG Benefits 387 5,000 ]350 4,650 102.000.000.558.21.31.00 CDBG Office Supplies 120 16 24 300 300 102.000.000.558.21.41.00 CDBG Professional Services 15,175 333 25,000 24,000 24,000 1,000 CDBG Telephone 61 102.000.000.558.21.42.03 CDBG Postage 507 - 100 10 10 250 102.000.000.558.21.44.00 CDBG Advertising 373 400 343 343 1,000 102.000.000.558.21.49.00 CDBG Miscellaneous 200 200 102.000.000.558.21.50.00 CDBG - Capital Outlay Sidewalks 78,121 77,018 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 124,121 26,1131 25,703 98,418 Ending NC&I 2,209 8,239 2,034 9,782 (24,079) 2,034 2,034 70 2011 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. 71 CITY OF EAST WENATCHEE LIBRARY FUND 112 LIBRARY FUND 2011 BUDGET Description 2006 Actua/s 2007 Actuals 2008 2009 Actual Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budger $ Chg % Chg Beginning NC&I 3,271 4,452 5,448 6,399 7,249 6,942 6,942 6,681 Totals 3,271 4,452 5,448 6,399 7,249 6,942 6,942 6,681 (261) -3.76% Revenues Library Services 2,500 2,500 2,500 2,750 2,750 1,375 2,750 2,750 - 0.00% Interest Earnings 151 190 65 - #DIV/0! Total Revenue 2,651 2,690 2,565 2,750 2,750 1,375 2,750 2,750 - 0.00% Resources Available 5,922 7,142 8,013 9,149 9,999 8,317 9,692 9,431 (261) -2.69% Expenditures Salaries 279 480 68 - Benefits 99 142 17 Professional Services - - - 659 1,400 573 1,400 1,600 200 14.29% Utilities 1,048 1,038 1,529 1,538 2,000 554 1,200 1,500 300 25.00% Miscellaneous 44 34 - 10 411 411 500 89 21.65% Total Expenditures 1,470 1,694 1,614 2,207 3,400 1,538 3,011 3,600 589 19.56% Ending NC&I 4,452 5,448 6,399 6,942 6,599 6,779 6,681 5,831 (850) -12.72% 72 2011 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 activities; a portion is allocated for payment to the Visitors and Convention Bureau to support their activities; and a portion is allocated for payment to the City of Wenatchee for support of the Wenatchee Convention Center. The City of Wenatchee interlocal agreement expires at the end of 2010, and the tentative expectation is to re -direct those funds to the Events Fund 117 where the funds are needed. REVENUES/EXPENDITURES First 2% Tax Retained by the City to support the activities of the Events Fund 117. 60% of Second 2% Tax Per contract through 2010, this 60% is remitted quarterly to the City of Wenatchee for the convention center remodel. 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. 73 CITY OF EAST WENATCHEE HOTEL/MOTEL TAX FUND113 HOTEUMOTEL TAX FUND 2011 BUDGET WORKSHEET BARS Numbers Description 2006 Actua/s 2007 Actual 2008 2009 Actual Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget $$ % Change Change Revenues 113.000.000.308.00.00.00 Beginning NC&I 16,158 16,900 16,227 18,843 28,698 9,417 9,417 19,017 9,600 101.94% Totals 16,158 16,900 16,227 18,843 28,698 9,417 9,417 19,017 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 25,000 13,141 25,000 (A) 0.00% 113.000.000.313.30.02.00 40% of 2nd 2% Tax 13,496 17,005 17,233 17,396 20,500 8,761 17,600 18,000 400 2.27% 113.000.000.313.30.03.00 80% of 3rd 2% Tax 26,993 34,010 35,386 34,793 32,000 17,522 33,000 33,000 _ 0.00% 113.000.000.313.30.04.00 20 % of 3rd 2% Tax 6,748 3,828 - - 113.000.000.361.00.00.00 Interest Earnings 4,740 846 137 #DIV/01 Total Revenue 105,963 100,336 78,605 78,283 77,500 39,424 75,600 51,000 (24,600) -32.54% Total Resources Available 122,121 117,236 94,832 97,126 106,198 48,841 85,017 70,017 (15,000) -17.64% Expenditures 113.000.000.557.30.41.00 1st 2% 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 25,000 7,635 20,000 (A) 0.00% 113.000.000.557.30.41.02 40% of 2nd 2% Tax 14,707 16,582 16,761 18,801 20,000 6,569 17,000 18,000 1,000 5.88% 113.000.000.557.30.41.03 80% of 3rd 2% Tax 26,509 33,163 33,524 34,844 30,000 13,138 29,000 33,000 4,000 13.79% 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 75,000 27,342 66,000 51,000 (15,000) -22.73% 113.000.000.508.00.00.00 Ending NC&I 16,900 16,628 18,843 9,417 3l,198 21,499 1977 19,017 _ 0.00% (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. 74 2011 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. 75 CITY OF EAST WENATCHEE DRUG FUND 114 DRUG FUND 2011 Budget BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 Actual 2010 2010 6 Months 2010 2011 $$ % Budget Estimate Budget Change Change Revenues 114.000.000.308.00.00.00 Beginning NC&I 3,696 4,899 6,001 10,584 9,684 2,989 2,989 5,521 2,532 84.71% Total 3,696 4,899 6,001 10,584 9,684 2,989 2,989 5,521 114.000.000.356.50.03.00 Drug Buy 887 709 1,307 2,479 2,000 908 1,800 1,800 0.00% 114.000.000.357.30.01.00 Restitution 100 155 8 71 - #DIV/0! 114.000.000.360.00.00.00 Miscellaneous 4 21 967 114.000.000.361.00.00.00 Interest Earnings 211 217 77 - #DIV/0! 114.000.000.367.00.00.00 Contributions 1,221 1,311 114.000.000.369.30.00.00 Forfeited Property 5,632 5,632 Transfer in From D.A.R-E- Fund#VALUE! 1,970 100.00% Total Revenue 1,202 1,102 4,583 4,828 2,000 6,540 7,432 1,800 (5,632) -75.78% Total Resources Available 4,899 6,001 10,584 15,412 11,684 9,529 10,421 7,321 (3,100) 29.75% Expenditures 114.000.000.566.00.49.00 Miscellaneous 3,406 3,000 1,000 1,000 3,000 2,000 100.00% 114.000.000.566.00.49.05 Stare Share - Prop 563 114.000.000.596.00.60.00 Capital Outlay 9,017 644 3,900 #DIV/0! Total Exp 12,423 3,000 2,207 4,900 3,000 (1,900) -38.78% 115.000.000.508.00.00.00 Ending NC&I 4,899 6,001 10,584 2,989 8,684 7,322 5,521 4,321 (1,200) 76 2011 BUDGET CRIMINAL JUSTICE FUND REVENUES 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 2010 Criminal Justice Fund expenditures include the lease payments for police vehicles, including the motorcycle. Miscellaneous Miscellaneous Criminal Justice related expenditures. 77 CITY OF EAST WENATCHEE CRIMINAL JUSTICE FUND 116 CRIMINAL_ JUSTICE FUND 2010 BUDGET WORKSHEET BARS Numbers Description 2006 Actuals 2007 Actual 2008 2009 Actual Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget ss Change Change Revenues 116.000.000.308.00.00.00 Beginning NC&I 24,141 31,925 36,380 41,716 43,716 45,602 45,602 48,466 2,864 6.28% Totals 24,141 31,925 36,380 41,716 43,716 45,602 45,602 48,466 116.000.000.334.06.90.01 WASPC Grant 3,000 3,000 116.000.000.336.06.20.00 High Crime 23,110 24,674 25,642 26,920 26,000 14,004 26,000 26,000 0.00% 116.000.000.336.06.21.00 Population 2,023 2,254 2,368 2,495 2,500 1,273 2,500 2,500 0.00% 116.000.000.336.06.26.00 Special Programs 7,985 8,800 91132 9,527 9,300 4,839 9,300 9,300 0.00% 116.000.000.336.06.30.00 EWPD Unclaimed Monies 1,269 1,269 116.000.000.361.00.00.00 Interest Earnings 1,499 504 #DIV/0! Total Revenue 34,617 35,728 37,646 38,942 37,800 24,385 39,069 37,800 (1,269) -3.25% Total Resources Available 58,759 67,653 74,026 80,658 81,516 69,987 84,671 86,266 1,595 1.88% Expenditures 116.000.000.596.00.60.00 Capital Outlay 26,384 32,312 32,312 35,056 36,000 50,400 33,000 :5,000 12,000 36.36% 116.000.000.596.00.60.01 Cap WASPC Equip 3,205 3,205 116.000.000.596.00.60.49 Miscellaneous 450 1 250 - #DIV/0! Total Expenditures 26,834 32,562 32,312 35,056 36,000 53,605 36,205 45,000 8,795 24.29% 116.000.000.508.00.00.00 Ending NC&I 31,925 35,091 41,714 45,602 45,516 16,382 48,466 41,266 (7,200) -14.86% 78 2011 BUDGET EAST WENATCHE EVENTS FUND Note: This will be the third 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, Sprint Boat Races, Easter Egg Hunt, and Christmas Tree Lighting are currently the main events. This was the inaugural year for the Sprint Boat Races. 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. The City also celebrated the 75th anniversary of the formation of the City over the July 4th Holiday this year. Fred Meyer was the prime sponsor of the event. 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 2011 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 and $48,000 has been budgeted for 2011. As noted in the narrative for Hotel/Motel Taxes, in 2011 the amounts currently allocated to the City of Wenatchee are expected to be re -directed to support the Events Fund. 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 2011. WI CITY OF EAST WENATCHEE EAST WENATCHEE EVENTS BOARD FUND 117 EVENTS FUND REVENUE 2010 BUDGET REVENUES BARS Numbers Description 2008 Actual 2009 Actual 2010 Budget 20106 Months 2010 Estimate 2011 Budget Revenues 117.000.100.308.00.00.00 Beginning NC&I 33,350 20,376 1,684 1,684 1,684 1,316 Totals 33,350 20,376 1,684 1,6841 1,684 1,316 117.000.100.313.30.00.00 1st 2% Tax 43,082 43,491 46,000 24,708 50,300 77,500 117.000.100.313.30.00.04 20% of 3rd 2% Tax 7,697 8,698 9,400 4,380 12,000 8,300 117.000.100.315.00.00.00 EWED Alloc S&U Tax 20,000 135,800 17,000 154,000 68,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,200 46,088 216,300 153,800 117.000.200.347.40.02.01 EEH Admission Fees 1,306 1,550 1,500 1,509 1,509 1,500 117.000.200.360.00.00.02 EEH Misc Revenue 278 292 250 369 369 250 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,750 1,878 1,878 1,750 117.000.300.321.70.12.02 CC Parade/Car Show 8,850 8,890 9,000 8,440 8,440 8,500 117.000.300,321.70.12.03 CC Vendor Fees 585 600 600 700 700 600 117.000.300.341.70.12.00 CC Merchandise Sales 2,313 2,442 2,500 2,339 2,339 2,250 117.000.300.36..00.12 CC Misc Revenue 283 54 117.000.300.367.1111.00.12 CC Donations 117.000.300.367.19.00.12 CC Sponsorships 7,000 4,000 4,500 4,356 4,3501 9,500 Total 19,031 15,986 16,600 15,829 15,829 20,850 117.000.400.321.70.11.02 W&W Car Show 2,775 3,275 2,750 110 2,750 2,750 117.000.400.321.70.11.03 W&W Motorcycle Fest 1,580 1,453 1,500 1,250 1,000 117.000.400.321.70.11.04 W&W Vendor Fees 1,810 2,037 1,500 375 1,500 1,000 117.000.400.341.70.11.00 W&W Merch Sales 5,463 4,082 5,000 801 4,500 4,000 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,500 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 500 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 14,000 1,000 12,000 8,000 117.000.400.367.19.00.13 Sched of Events Brochure 6,400 5,000 4,900 6,100 5,000 117.000.400.367.19.00.14 W&W Ad Reimb 452 450 - 450 Total 41,951 32,103 33,200 7,186 30,600 24,400 117.000.500.360.00.00.01 Christmas Misc Rev - 103 117.000.500.367.11.00.01 Christmas Donations 117.000.500.367.19.00.01 Christmas Sponsorships 133 Total 133 103 117.000.600.367.19.00.01 75th Birthday Celebration 10,000 2,500 117.000.530.367.19.00.10 Sprint Boat Race Revenue 50,700 27,500 65,000 117000.530.367.19.00.20 Prize Purse Sponsorships 1,500 5,000 117.000.830.367.19.00.30 Race Revenue 7,343 5,000 LOther otal - - 50,700 36,343 75,000 Revenue 115,787 122,553 303,450 70,981 303,450 275,800 Total Resources Available 149,137 142,929 305,134 72,665 305,134 277,116 CITY OF EAST WENATCHEE EAST WENATCHEE EVENTS BOARD FUND 117 EWEB EXPENDITURES 2011 BUDGET - EXPENDITURES BARS Numbers Description 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget 117.000.000.557.00.10.00 117.000.000.557.00.10.00 EWEB Salaries 4,422 8,257 56,000 30,926 85,000 75,00G 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.0 57 _ 00. 20-0 117.000.000.557.00.20.00 117.000.000.557.00.20.00 EWEB Benefits EWEB Benefits 2,046 2,046 2,469 2,469 25,500 25,500 13,612 13,612 35,000 35,000 13,50e 33,50f 117.000.000.557.00.20.01 117.000.000.557.00.20.01 117.000.000.557.00.20.01 117.000.000.557.00.20.01 Christmas Benefits Christmas Benefits 2,047 2,047 2,138 2,138 117.000.000.557.00 117.000.000.557.0 ..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 CC Benefits 6,140 6,415 Total EWEB Salaries and Benefits 1 64,6861 70,783 81,500 44,538 120,000 108,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 1,000 2,000 117.000.100.557.00.27.00 City Theme 7,191 6,516 10,000 260 53000 10,000 117.000.000.557.00.32.00 117.000.100.557.00.32.00 EWEB Fuel Consumed 12 - 15 15 25 117.000.000.557.00.35.00 117.000.100.557.00.35.00 EWEB Smalls Tools 54 100 100 22 100 100 117.000.000.557.00.42.00 117.000.100.557.00.42.00 EWEB Training - - 250 250 250 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 - 117.000.000.557.00.42.03 117.000.100.557.00.42.03 EWEB Postage 18 - 61k2E,4OO 117.000.000.557.00.43.00 117.000.100.557.00.43.00 EWEB Travel 204 2,935 3,000 1,455 3,000 117.000.000.557.00.44.00 117.000.100.557.00.44.00 EWEB Advertising117.000.000.557.00.48.00 117.000.100.557.00.48.00 EWEB Repairs 110 103 125 58 125 117.00.000.557.00.49.00 117.000.100.557.00.49.00 EWEB Misc 647 333 300 144 300 300 117.000.100.596.00.60.00 EWEB Capital Outlay 513 587 300 294 6000 300 EWEB General Expenditures 12,302 12,074 16,090 2,294 15,290 16,100 117.000.000.557.00.46.00 117.000.105.557.00.46.00 EWEB Insurance 545 1,311 1,500 34 2,100 2,100 117.000.000.557.00.46.01 117.000.105.557.00.46.01 Christmas Insurance 29 - 117.000.000.557.00.46.02 117.000.105.557.00.46.02 EEH Insurance 21 117.000.000.557.30.46.11 117.000.105.557.30.46.11 W&W Insurance 14 117.000.000.557.30.46.12 117.000.105.557.30.46.12 CC Insurance 29 EWEB Insurance Costs 638 1,311 1,500 34 2,100 2,100 117.000.000.557.00.31.03 117.000.110.557.00.31.03 EWEB Central Stores 235 350 150 117.000.000.557.00.31.04 117.000.110.557.00.31.04 Christmas Central Stores 24 117.000.000.557.30.31.13 117.000.110.557.30.31.13 W&W Central Stores 32 117.000.000.557.30.31.14 117.000.110.557.30.31.14 CC Central Stores 32 EWEB Central Stores 1 323 350 117.000.000.557.00.31.00 117.000.115.557.00.31.00 EWEB Office Supplies 272 475 350 1,000 1,000 117.000.000.557.00.31.01 117.000.115.557.00.31.01 Christmas Office Supplies 14 - 1843 117.000.000.557.00.31.02 117.000.115.557.00.31:02 EEH Office Supplies 14 - 117.000.000.557.30.31.11 117.000.115.557.30.31.11 W&W Office Supplies 14 117.000.000.557.30.31.12 117.000.115.557.30.31.12 CC Office Supplies 14 EWEB Office Supplies 314 475 350 843 1,000 1,000 117.000.000.557.00.35.02 117.000.200.557.00.35.02 EEH Small Tools 14 400 162 200 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 824 1,050 1,000 1,062 849 1,062 850 1,100 1,000 117.000.000.557.00.49.02 117.000.200.557.00.49.02 EEH Misc 354 117.000.200.596.00.60.02 Easter Capital Outlay Easter Event Expenses 818 1,824 2,450 2,073 2,112 2,450 81 EWEB EXPENDITURES EWEB Fund 117 2011 Budget - Page 2 BARS Numbers Description 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget 117.000.300.557.30.32.12 CC Fuel Consumed 498 500 117.000.000.557.30.35.12 117.000.300.557.30.35.12 CC Small Tools & Equipment 3,222 3,062 3,500 2,850 3,500 3,000 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 23 117.000.000.557.30.44.12 117.000.300.557.30.44.12 CC Advertising 3,144 2,621 3,600 3,673 3,750 4,000 117.000.000.557.00.49.12 117.000.300.557.00.49.12 CC Misc ' 1,125 4,297 3,500 2,021 2,100 3,000 117,000.300.596.30.60.12 CC Capital Outlay Classy Chassis Event Expenses 9,565 10,551 10,600 9,065 9,873 10,000 117.000.000.557.00.49.11 117.000.400.557.00.49.11 W&W Misc 318 522 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 5,000 1,953 6,500 5,000 117.000.000.557.30.35.11 117.000.400.557.30.35.11 W&W Small Tools 5,133 5,201 4,500 102 3,800 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 581 600 117.000.000.557.30.44.11 117.000.400.557.30.44.11 W&W Advertising 7,796 8,111 8,000 1,200 4,000 8,000 117.000.000.557,30.49.11 117.000.400.557.30.49.11 W&W Miscellaneous 14,223 9,564 3,000 843 6,000 3,000 117.000.400.557.30.49.13 W&W Events Brochure 4,600 5,000 4,600 5,000 117.000.400.596.30.60.11 1 W&W Capital Outlay Wings & Wheels Event Expenses 44,193 36,487 25,500 4,6791 25,500 25,500 117.000.000.557.00.35.01 117.000.500.557.00.35.01 Christmas Small Tools 472 1,281 1,250 29 1,250 1,250 117.000.500.557.00.40.05 Christmas Events & DecE 164 2,250 2,000 40 2,000 2,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 2,500 60 2,000 2,500 117.000.000.557.00.49.01 117.000.500.557.00.49.01 Christmas Misc 699 578 550 550 550 117.000.500.596.00.60.01 Christmas Capital Christmas Event Expenses 3,1411 6,301 3;0 129 5,800 6,300 117.000.530.557.00.30.00 Boat Race Permits 7,500 2,886 18,000 117.000.530.557.30. 00. 10 USSBA Fee 8,000 8,000 16,000 117.000.530.557.30.00.15 Land Lease Cost 7,500 7,500 15,000 117.000.530.557.30.00.20 Track Water & Mtls 2,000 10,500 5,000 117.000.530.557.30.00.25 Revenue Sharing Cost 2,500 2,600 6,500 117.000.530.557.30.00.30 Sanitary Facilities 3,500 5,500 7,000 117.000.530.557.30.00.35 Security & Safety 5,000 4,600 9,000 117.000.530.557.30.00.40 Donated Prize Purse 5,000 5,000 5,000 117.000.530.557.30.00.45 Advertising - Radio 425 6,000 117.000.530.557.30.00.47 Advertising - Print 1,000 1,000 4,000 117.000.530.557.30.00.49 Miscellaneous 5,000 5,000 10,000 117.000.530.557.30.00.60 Capital Outlay 50,000 52,218 20,000 Christmas Event Expenses 97,000 2,886 120,343 103,500 117.000.550.557.49.00.01 75th B-day Celebration 10,000 1,351 1,600 Total Expenditures 135,980 139,806 251,640 67,8921 303,618 275,600 82 2011 BUDGET BOND REDEMPTION FUND #202 Note: The 202 Fund is a Redemption Fund for original proceeds used for street improvements. The bond, in the 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 2010 were approximately $168,000, and are budgeted at $167,000 for 2011. This fund also includes the debt service on the Public Works Trust Fund Loan used to improve IIth Street and the related Storm Water Utility improvements. These payments were previously inadvertently paid out of the Street Improvements Fund 301. Debt Service is $29,713 for 2011. 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. X CITY OF EAST WENATCHEE STREET IMPROVEMENTS BOND REDEMPTION FUND 202 BOND REDEMPTION FUND 2011 BUDGET - Finance BARS Numbers Description. 2006 Actuals 2007 Actual 2008 2009 Actual Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget $ % Change Change Revenues 202.000.000.308.00,00.00 Beginning NC&I 398 125 437 349 637 3,329 3,329 40,220 36,891 1108.17% Totals 398 125 437 349 637 3,329 3,329 40,220 Revenues 202.000.000.311.10.00.00 Property Tax 162,718 158,319 163,500 200,000 201,100 225,000 225,000 160,000 (65,000) -28.89% 202.000.000.338.90.00.00 SWU PWTFL Reimb 12,871 12,755 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 201,100 225,000 237,871 172,755 Resources Available 163,138 158,497 164,013 200,349 201,737 228,329 241,200 212,975 (28,225) -11.70% Expenditures 202.000.000.591.00.71.00 Redemption - GO Bonds 100,000 100,000 110,000 115,000 125,000 125,000 130,000 5,000 4.00% 202.000.000.591.00.71.05 Redemption - PWTF Debt 29,712 29,713 29,712 29,712 29,712 202.000.000.592.00.89.00 Interest Debt 63,014 58,060 53,664 48,742 43,000 21,308 43,000 37,000 (6,000) -13.95% 202.000.000.592.00.89.05 Interest - PWTF Loan 3,566 3,500 3,268 3,268 3,000 Total Expenditures 163,014 158,060 1 163,664 197,020 1 201,213 54,288 200,980 1 199,712 202.000.000.508.00.00.00 Ending NC&I 125 437 350 3,330 524 174,041 40,220 13,263 (26,957) -67.02% 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, a able $135,000 in 2012, $140,000 in 2013, $150,000 in 2014 and $155,000 in 2015. I i 1 1 84 2011 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 2011 have been selected from the Transportation Improvement Plan (TIP) provided to the Washington State Department of Transportation each June. They include $430,000 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 Fedeal Grant for 86.5% of cost and the City's contribution for the balance. The third is $15,000 in engineering for surveying and basemap development for future improvements to Eastmont Avenue from Grant Road to 9'h Street, funded by the City. 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 2011, 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 constriction costs related to the second stage of the Grant Road Overlay, the Loop Trail Enhancement project and Eastmont Avenue planning costs. WIT VrtA51 WtNAIGHEE STREET IMPROVEMENTS FUND 301 REVENUES STREET IMPROVEMENTS FUND 2011 BUDGET Description 2006 Actuals 2007 Actuals 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget Beginning NC&I 10,000 476,521 12,599 (175,247) 93,262 90,041 90,041 175,721 Totals 10,000 476,521 12,599 (175,247) 93,262 90,041 90,041 175,721 Property Tax 62,775 205,367 Real Estate Excise Tas 100,000 Sales & Use Tax 114,144 269,783 - STP Grant - Samara 37,500 Engr Grant Rd Overlay STP - Grant Rd Overlay 406,550 389,000 365,000 REET - Grant Rd Overlay From 314 63,450 61,000 57,000 Georgia Ave Ped Crossing - REET from 314 62,000 59,000 STP - Loop Trail Enhancement 131,000 REET - Loop Trail Enhancement -From 314 20,000 REET - Eastmont Surveying/Basemapping - from 314 15,000 DC Regional Share 102,780 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 1,139,565 89,691 -Ave TIB - 15th St to 19th St 2,838 97,563 351,818 8th St NE DCSD Reimburse 3,227 _ 8th St NE ReimburseEWWD 10,361 15th/Eastmont - DCSD Reimburse 78,666 848 - 15th/Eastmont-EWWD Reimburse- 318,540 2,169 - 15th/Eastmont - DCPUD 300,954 1,055 2,872Reimburse - 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 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 E41 2,689 - Kenroy - ESD Reimburse 22,444 86 Miscellaneous 63,870 3,482 Grover St - CLChurch Reimburse 184 Total Current Revenue 4,572,875 1 2,206,196 1,818,987 295,182 569,586 611,780 588,000 Total Resources Available 4,582,875 2,682,717 1,831,586 119,935 662,848 90,041 701,821 763,721 87 CITY OF EAST WENATCHEE STREET IMPROVEMENTS FUND 301 EXPE STREET IMPROVEMENTS FUND 2011 BUDGET WORKSHEET Description 2006 Actuals 2007 Actuals 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget Expenditures Rentals - Water Utilities 85 Rentals - Sewer Utilities 816 - 32 Rentals - Miscellaneous 29,799 - - 19 100 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 ' 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 25,000 16,884 17,000 8,000 Roadway - Grant Road Overlay 450,000 450,000 422,000 SAMARA Project Intersections 41,000 Georgia Ave Ped Crossing 62,000 59,000 Loop Trail Enhancement 151,000 Eastmont - Surveying + Basemap Development 15,000 Right -of -Way 12,228 _ ROW - REV Grant - CBD Pro ect 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 - RIR Project - 209,298 23,905 1,311 - - ROW - STP - Eastmont Avenue - Subtotal 1,200,128 871,594 587,943 29,895 578,000 16,903 526,100 596,000 88 CITY OF EAST WENATCHEE p� �+ STREET IMPROVEMENTS FUND 301 EXPE STREET IMPROVEMENTS FUND 2011 BUDGET WORKSHEET _. Description 2006 Actua/s 2007 Actuals 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget Expenditures Balance Forward 1,200,128 871,594 587,943 29,895 578,000 16,903 526,100 596,000 Roadway 4,332 - - _ Roadway - REV Grant - CBD Pro'ect 1,670,163 1,305,783 191,933 - Roadway - TIB - 11th St NE - - Roadway - TIB - VMP Turn Lane 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 Safet 337,842 71,191 - Roadway - TIB - Eastmont Avenue g05,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-RI R 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 4,402,264 2,985,499 2,006,832 29,895 578,000 16,903 526,100 596,0 Net Resources 180,611 (302,782) (175,246) 90,040 84,848 73,138 175,721 167,7L 89 Notes: Revenues STP Grant - Samara - City of Wenatchee grant - Project was changed to a research and design for Wenatchee only REET - Grant Rd Overlay From 314 - 2010 TALK TO NICK - Engr Grant Rd Overlay - Added this line to show revenue for design engineering phase - Contract award + Engineering = $364,806 + $43,777 = $408,583 - STP contribution = 86.5% x $408,583 = $353,000 - Add 10% for change orders and contingencies — $389,000 REET - Grant Rd Overlay From 314 - 2011 - SR 28 to Georgia — 75% of the length of Georgia to Kentucky - STP contribution = $389,000 x 75% = $292,000 - Add 25% for inflation, change orders and contingencies — $365,000 Georgia Ave Ped Crossing - REET from 314 - Contract award + Engineering = $47,517 + $5,702 = $53,219 - Add 10% for change orders and contingencies — $59,000 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 Expenditures Engr Grant Rd Overlay - Design phase Roadway - Grant Road Overlay SAMARA Project Intersections Georgia Ave Ped Crossing Loop Trail Enhancement 90 2011 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 2011, the City has determined the amount and level of spending for capital improvements in this fund. All three 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. The only scheduled capital project for 2011 is the continuation of the improvements to the former residence building in the Southeast corner of City property for Police Department management staff. REVENUES Real Estate Excise Tax Real Estate Excise Tax from real estate transactions. EXPENDITURES Improvement costs to satisfy office and storage space for police department staff. 91 CITY OF EAST WENATCHEE CAPITAL IMPROVEMENT FUND314 CAPITAL IMPROVEMENTS FUND 2010 BUDGET BARS Numbers Description 2006 Actuate 2007 Actua/s 2008 Actual 2009 Actual 2010 Budget 2010 6 Months 2010 Estimate 2011 Budget Revenues 314.000.000.308.00.00.00 Beginning NC&I 741,508 591,883 - (1,338) 227,053 614,940 614,940 581,940 Totals 741,508 591,883 (1,338) 227,053 614,940 614,940 581,940 314.000.000.317.30.00.00 Real Estate Excise Tax 174,039 182,333 100,961 135,273 90,500 81,800 150,000 145,000 314.000.000.333.10.00.00 Regional Fund Share 123,000 314.000.000.395.00.00.05 Property Sale Proceeds - Colorado Ave 110,992 - 314.000.000.311.10.00.00 Property Tax 31,000 314.000.000.395.00.00.10 ROW WSDOT- Seller 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 244,500 81,800 150,000 145,000 Total Resources Available 934,765 787,665 101,306 614,940 471,553 696,740 764,940 726,940 Expenditures 314.000.000.596.00.41.00 Professional Service - - - 314.000.000.596.00.41.01 Expenses - - 498 - - - 314.000.000.596.00.60.00 Capital Outlay 342,882 865,951 102,146 - - - 314.000.000.596.10.10.00 Salaries - - 314.000.000.596.10.20.00 Benefits - 314.000.000.896.00.60.10 Capital Outlay - East Wing Improvements 143,000 63,000 129,000 Transfer REET to Fund 301 - Grant Rd Overlay 63,450 61,000 57,000 Transfer REET to Fund 301 - Georgia Ped Crossing 62,000 59,000 Transfer REET to Fund 301 - Loop Trail Enhancement 20,000 Transfer Eastmont - Surveying + Basemap Development 15,000 Totals Espenditures 342,882 865,951 102,644 268,450 183,000 221,000 314.000.000.508.00.00.00 Ending NC&I 591,883 (78,286) (1,338) 614,940 203,103 696,740 581,940 505,940 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. Allocation of Fund Balance: Dec 31, 2009 Dec 31, 2010 REET Funds 133,948.60 163,948.60 Est to Receive $150,000 Rev in 2010/ Est to Spend $120,000 for St Impv Proceeds Sale 110,991.70 47,991.70 Est to Spend $63,000 in 2010 on Harrison Annex Regionl Share -Rev 102,780.00 WSDOT "Deposit" 370,000.00 370,000.00 614,940.30 684,720.30 Notes: Capital Outlay - East Wing Improvments - Anticipate contract will carry over into 2011 REET to Fund 301 - Grant Road Overlay - 2010 - Contract award + Engineering = $364,806 + $43,777 = $408,583 - City match = 13.5% x $408,583 = $55,159 -Add 10%for change orders and contingencies - $61,000 REET to Fund 301 - Grant Road Overlay - 2011 - SR 28 to Georgia- 75% of the length of Geor is to Kentucky City match = $61,000 x 75% = $46,000 Add 25% for inflation, change orders and contingencies - $57,000 REET to Fund 301 - Georgia Ped Crossing - Contract award + Engineering = $47,517 + $5,702 = $53,219 - Add 10% for change orders and contingencies - $59,000 REET to Fund 301 - Loop Trail Enhancement - Estimate = $131 K STP + $20K City = $151 92 2011 BUDGET EQUIPMENT RENTAL & REPLACEMENT FUND RF.VFNTTFC Sales and Use Tax None Sale of Surplus Property Budgeted for $2,000 for 2011. Operatiniz Transfers In — Monthly Lease Payments Departments will "lease" computer equipment purchased by the ER&R Fund. EXPENDITURES Capital Outlay/Supplies/Repairs & Maintenance/Miscellaneous Computer and related equipment purchases from the ER&R Fund and leased to City Departments. Supplies Operating supplies for the ER&R Fund. Repairs and Maintenance Computer support and service. Miscellaneous Miscellaneous expenditures for the ER&R Fund. M CITY OF EAST WENATCHEE EQUIPMENT RENTAL & REPLACEMENT FUND 501 EQUIPMENT R&R FUND 2010 BUDGET BARS Numbers Description 2006 Actuals 2007 Actual 2008 Actual 2009 9Months 2009 Est Actual 2009 Budget 2011 Budget $$ Change Change Revenues 501.000.000.308.00.00.00 Beginning NC&I 55,092 62,276 44,888 6,802 6,802 6,802 b; (6,494) -95.47% Totals 55,092 62,276 44,888 6,802 6,802 6,802 (6,494) -95.47% 501.000.000.313.10.00.00 Sales & Use Tax 501.000.000.360.00.00 Miscellaneous 179 15 501.000.000.361.00.00.00 Interest Earnings 2,780 2,508 399 - 150 (150) -100.00% 501.000.000.369. 10. 00. 00 Sale of Surplus Merchandise 4,403 8,681 3,217 1,606 1,606 2,000 2,000 #DIV/0! 501.000.000.397.00.00.00 Operating Transfer In 42,800 - - 10,000 9,800 (9,800) -100.00% 501.000.000.397.00.00.01 Operating Transfer In - Monthiv Lease Pa ments _ 4,038 2,521 - - 5,000 (5,000) -100.00% Total Revenue 7,184 58,206 6,152 1,606 11,606 14,950 2,000 (12,950) -86.62% Resources Available 62,276 120,482 51,040 8,408 18,408 21,752 2,308 (19,444) -89.39% Expenditures 501.000.000.596.00.60.00 Capital Outlay - 29,262 38,367 2,778 16,000 17,000 #VALUE! #VALUE! 501.000.000.596.00.60.30 Supplies - 450 2,459 556 100 250 #VALUE! #VALUE! 501.000.000.596.00.60.48 Repairs & Maintenance - 45,881 3,331 1,380 2,000 3,000 #VALUE! #VALUE! 501.000.000.596.00.60.49 Miscellaneous - 80 - - 500 (500) -100.00% TotalExpenditures 75,593 44,237 4,714 18,100 20,750 (20,750) -100.00% Ending NC&I 62,276 44,889 6,803 3,694 308 1,002 2,3- 1,306 130.34% Expenditures in the Fund were primarily for computer and related equipment/software for all departments within the City. This activity has been transferred to the Information Technology Department of the General Fund. 94