Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020 - March 2020 Monthly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee May 5, 2020 City Council Meeting March 2020 Financial Report Date: May 5, 2020 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: March 2020 Financial Report This report provides a summary of the City’s overall financial operations through March 31, 2020. It offers a comparison of total overall revenues and expenditures between the current fiscal year and the same point in time as the last fiscal year. For the purposes of this report, operating funds are funds that receive general local tax support and/or expend wages and other steady expenses to support the day-to-day operations of the City. Non-operating funds are funds that are supported through special revenues and/or include non-wage and varying expenses (i.e. capital, grant projects, etc.). Table 1 below shows the City’s revenue collections through March 31, 2020 compared to revenue collections through March 31, 2019, along with the respective dollar and percentage variances for its operating funds. Table 1 March 31, 2020 March 31, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 1,185,472 1,035,398 150,073 14.49% Street Fund - 101 376,266 438,804 (62,538) (14.25%) Events Board Fund - 117 50,645 17,581 33,064 188.07% Equipment R&R Fund - 501 350,000 300,000 50,000 16.67% Total Revenues - Operating Funds 1,962,382 1,791,783 170,599 9.52% Revenues - Operating Funds CITY OF EAST WENATCHEE Finance Department 271 9th Street NE * East Wenatchee, WA 98802 P: (509) 886-6101 * F: (509) 884-6233 Email: jdelay@eastwenatcheewa.gov City of East Wenatchee May 5, 2020 City Council Meeting March 2020 Financial Report Chart 1 is a graphical representation of year to year revenue comparisons for the City’s operating funds. Chart 1 Table 2 below shows the City’s revenue collections through March 31, 2020 compared to revenue collections through March 31, 2019, along with the respective dollar and percentage variances for its non-operating funds. City of East Wenatchee May 5, 2020 City Council Meeting March 2020 Financial Report Table 2 March 31, 2020 March 31, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 814 - 814 - Trans Benefit District Fund - 105 52,708 48,549 4,159 8.57% Library Fund - 112 - - - - Hotel/Motel Tax Fund - 113 73,047 32,431 40,615 125.24% Drug Fund - 114 5 13 (8) (62.25%) Criminal Justice Fund - 116 4,770 4,594 176 3.83% Bond Redemption Fund - 202 - 24,213 (24,213) (100.00%) Street Improvements Fund - 301 75,585 - 75,585 - Capital Improvements Fund - 314 187,308 37,446 149,862 400.21% Storm Water Fund - 401 2,615,611 - 2,615,611 - Total Revenues - Non-Operating Funds 3,009,847 147,247 2,862,600 1944.09% Revenues - Non-Operating Funds Chart 2 is a graphical representation of year to year revenue comparisons for the City’s non-operating funds. Chart 2 City of East Wenatchee May 5, 2020 City Council Meeting March 2020 Financial Report Revenue Highlights: General Fund revenues are up $150,073, or 14.49%, from last year due to: $61,252 increase in sales tax allocation from last year due to an overall increase in sales tax collections $20,000 in grant funding from the Washington State Office of Public Defense $19,714 reimbursement from RiverCom for Police Department purchases The above increases are offset by the following decreases from last year: $14,082 less phone/cellular utility taxes collected $9,143 less interest earnings due to lower interest rates Street Fund revenues are down $62,538, or 14.25%, from last year because prior to this year stormwater reimbursements we received from Douglas County as our fiduciary agent were deposited into this fund. Those revenues now go directly into the Stormwater Fund. Events Fund revenues are up $33,064, or 188.07%, because the Finance Department transferred $50,000 from the Hotel/Motel Tax Fund due to the Events Fund cash balance dipping below $30,000. The City budgeted for a $135,000 transfer, which means this fund is due an additional $85,000 in hotel/motel taxes. However, due to the cancellation of Classy Chassis and less administrative time being spent on events, this will most likely need to be reevaluated, and amended. Equipment R&R Fund revenues are up $50,000, or 16.67%, from last year due to a larger sales tax allocation this year versus last year as approved in the budget. Hotel/Motel Tax Fund revenues are up $40,615, or 125.24%, from last year presumably due to an increase in hotel stays in the City. Additionally, this fund now receives all hotel/motel taxes; however, a transfer of up to $135,000 is budgeted to go to the Events Fund. Street Improvements Fund revenues are up $75,585 from last year due to the timing of 10 th Street Public Works Trust Fund Loan reimbursements, and grant funding received for the 3 rd Street SE/Highline Drive roundabout. Capital Improvements Fund revenues are up $149,862, or 400.21%, from last year due to the increased collection of real estate excise tax presumably due to more and/or larger real estate sales transactions. Storm Water Fund revenues are up $2,615,611 because this is a new fund that the City is accounting for due to a terminated Interlocal Agreement with Douglas County for storm water services. Prior to 2020, Douglas County accounted for these monies as a fiduciary agent for the City. Table 3 below shows the City’s expenditures through March 31, 2020 compared to expenditures through March 31, 2019, along with respective dollar and percentage variances for its operating funds. City of East Wenatchee May 5, 2020 City Council Meeting March 2020 Financial Report Table 3 March 31, 2020 March 31, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 1,858,968 1,810,686 48,282 2.67% Street Fund - 101 241,427 477,470 (236,043) (49.44%) Events Board Fund - 117 26,478 26,570 (92) (0.35%) Equipment R&R Fund - 501 120,690 157,832 (37,142) (23.53%) Total Expenditures - Operating Funds 2,247,563 2,472,557 (224,995) (9.10%) Expenditures - Operating Funds Chart 3 is a graphical representation of year to year expenditure comparisons for the City’s operating funds. Chart 3 Table 4 below shows the City’s expenditures through March 31, 2020 compared to expenditures through March 31, 2019, along with respective dollar and percentage variances for its non-operating funds. City of East Wenatchee May 5, 2020 City Council Meeting March 2020 Financial Report Table 4 March 31, 2020 March 31, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - - - - Trans Benefit District Fund - 105 - - - - Debt Reserve Fund - 110 - - - - Library Fund - 112 1,712 1,285 427 33.24% Hotel/Motel Tax Fund - 113 60,000 27,819 32,181 115.68% Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 74,953 114,924 (39,971) (34.78%) Storm Water Improvements Fund - 308 9 - 9 - Capital Improvements Fund - 314 - 3,727 (3,727) (100.00%) Storm Water Fund - 401 219,573 - 219,573 - Total Expenditures - Non-Operating Funds 356,248 147,754 208,494 141.11% Expenditures - Non-Operating Funds Chart 4 is a graphical representation of year to year expenditure comparisons for the City’s non- operating funds. Chart 4 City of East Wenatchee May 5, 2020 City Council Meeting March 2020 Financial Report Expenditure Highlights: General Fund expenditures are up $48,282, or 2.67%, from last year due to: General salary and benefit increases, and increases due to retirements and separations $77,242 increase in bills from the Chelan County Regional Justice Center due to the timing of billings received, and due to the terms of the City’s new contract with them. This variance will equalize towards year-end. The above increases are offset by the following decreases: $240,187 purchase of the Colorado Ave. property last year $19,007 less spending on Municipal Court capital outlay due to some equipment upgrades that were needed last year Street Fund expenditures are down $62,538, or 14.25%, from last year due to a calm winter, which resulted in less snow and ice removal overtime, and getting caught up with delayed Department of Transportation utility billings from prior years that we paid in the early part of 2019. Equipment R&R Fund expenditures are down $37,142, or 23.53%, from last year due to the timing of vehicle purchases by the Police and Street departments. Hotel/Motel Tax Fund expenditures are up $32,181, or 115.68%, due to a transfer of $50,000 to the Events Fund. Street Improvements Fund expenditures are down $39,971, or 34.78%, from last year due to a decrease in expenditures for the design of 10th Street. Storm Water Fund expenditures are up $219,573 from last year because this is a new fund that the City is accounting for due to a terminated Interlocal Agreement with Douglas County for storm water services. Prior to 2020, these expenditures were accounted for in the Street Fund. The reports presented in the following pages represent accounting system generated line-item details of revenues, expenditures, budgets, and cash balances for each fund through March 31, 2020. Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $7,725.35 $12,104.64 $1,245,000.00 0.97 %$1,232,895.36 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $265,770.45 $404,292.07 $3,500,000.00 11.55 %$3,095,707.93 001-000-000-313-71-00-00 Criminal Justice Sales Tax $24,928.45 $80,924.97 $300,000.00 26.97 %$219,075.03 001-000-000-316-40-00-00 Electric Utility Tax $40,460.59 $116,404.49 $355,000.00 32.79 %$238,595.51 001-000-000-316-45-00-00 Natural Gas Utility Tax $5,318.09 $18,172.56 $35,000.00 51.92 %$16,827.44 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $17,437.57 $64,076.81 $350,000.00 18.31 %$285,923.19 001-000-000-316-84-00-00 Gambling Tax $0.00 $108,279.74 $345,000.00 31.39 %$236,720.26 Total Taxes $361,640.50 $804,255.28 $6,130,000.00 13.12 %$5,325,744.72 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $0.00 $0.00 $500.00 0.00 %$500.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $37.00 $124.00 $800.00 15.50 %$676.00 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $23,905.02 $97,000.00 24.64 %$73,094.98 001-000-000-321-99-00-00 Business Licenses & Permits $9,765.25 $27,299.84 $107,100.00 25.49 %$79,800.16 001-000-000-321-99-05-00 Other Business Lic & Permits $0.00 $660.00 $650.00 101.54 %($10.00) 001-000-000-322-10-00-00 Building & Structure Permits $3,390.55 $24,299.79 $50,000.00 48.60 %$25,700.21 001-000-000-322-90-01-00 Gun Permits $363.00 $1,400.00 $6,500.00 21.54 %$5,100.00 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $100.00 0.00 %$100.00 Total Licenses and Permits $13,555.80 $77,688.65 $262,650.00 29.58 %$184,961.35 Intergovernmental Revenues 001-000-000-333-16-50-00 Columbia River Drug Task Force $0.00 $0.00 $7,500.00 0.00 %$7,500.00 001-000-000-334-03-10-00 Dept. of Ecology SMP Grant $0.00 $0.00 $16,800.00 0.00 %$16,800.00 001-000-000-334-03-51-03 TSC - Seatbelt Emphasis Patrols $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-334-03-51-04 X-52 TSC-Speed Limit Emphasis $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-000-334-03-51-12 TSC - DUI Emphasis Patrol $0.00 $1,194.96 $2,750.00 43.45 %$1,555.04 001-000-000-334-04-20-05 Dept. of Commerce Grant $0.00 $0.00 $15,920.00 0.00 %$15,920.00 001-000-000-334-06-91-00 WA ST Office of Public Defense $0.00 $20,000.00 $0.00 ($20,000.00) 001-000-000-334-06-91-10 Washington State Archives Grant $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-000-334-06-95-00 RIVERCOM 911 Funding Assistance $0.00 $19,714.23 $21,000.00 93.88 %$1,285.77 001-000-000-335-00-91-00 PUD Privilege Tax $0.00 $0.00 $42,000.00 0.00 %$42,000.00 001-000-000-336-00-98-03 City Assistance $11,174.33 $11,174.33 $0.00 ($11,174.33) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $8,087.12 $8,087.12 $21,000.00 38.51 %$12,912.88 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $449.72 $2,000.00 22.49 %$1,550.28 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $18,186.52 $75,000.00 24.25 %$56,813.48 001-000-000-336-06-95-00 Liquor Board Profits $27,514.91 $27,514.91 $107,500.00 25.60 %$79,985.09 Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 501-000-000-397-21-00-20 Transfer In - Criminal Justice Period: 2020 - March 2020 Printed by EASTWENATCHEE\jdelay on 4/15/2020 10:55:07 AM Page 1 of 5 East Wenatchee - Revenue Account Number Title Period Fiscal Budget % of Total Balance Total Intergovernmental Revenues $46,776.36 $106,321.79 $336,470.00 31.60 %$230,148.21 Charges for Goods and Services 001-000-000-341-33-10-00 Background Check Fees $0.00 $0.00 $60.00 0.00 %$60.00 001-000-000-341-35-30-00 Duplicating Services - Court & Police $0.00 $0.00 $500.00 0.00 %$500.00 001-000-000-341-35-31-00 Copy and Duplication Fees - Admin $0.00 $0.00 $200.00 0.00 %$200.00 001-000-000-341-35-33-00 Recording and Filing Fees $0.00 $0.00 $75.00 0.00 %$75.00 001-000-000-341-35-35-00 Annual Admin Reimb Fees $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-000-342-33-00-00 Adult Probation Services $6,631.24 $13,524.45 $70,000.00 19.32 %$56,475.55 001-000-000-342-36-00-00 Housing of Prisoners $776.17 $2,060.79 $25,000.00 8.24 %$22,939.21 001-000-000-342-40-00-01 Fire Marshall Inspection Services $0.00 $2,930.00 $5,000.00 58.60 %$2,070.00 001-000-000-345-83-00-00 Plan Checking Fees $2,013.78 $14,787.99 $25,000.00 59.15 %$10,212.01 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $600.00 $800.00 75.00 %$200.00 001-000-000-345-86-00-00 Sepa Permits $0.00 $0.00 $500.00 0.00 %$500.00 001-000-000-345-89-00-00 Planning & Development Fees $367.00 $857.00 $7,500.00 11.43 %$6,643.00 Total Charges for Goods and Services $9,788.19 $34,760.23 $140,635.00 24.72 %$105,874.77 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $17,673.33 $37,974.10 $190,000.00 19.99 %$152,025.90 001-000-000-357-33-00-00 Public Defender Costs $1,392.20 $3,039.13 $25,000.00 12.16 %$21,960.87 001-000-000-357-35-00-00 Restitution $250.00 $300.00 $150.00 200.00 %($150.00) Total Fines and Penalties $19,315.53 $41,313.23 $215,150.00 19.20 %$173,836.77 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $7,887.50 $25,860.96 $100,000.00 25.86 %$74,139.04 001-000-000-361-40-00-00 Sales Tax Interest $681.51 $1,888.63 $5,000.00 37.77 %$3,111.37 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,146.26 $3,433.37 $10,000.00 34.33 %$6,566.63 001-000-000-369-91-50-00 Miscellaneous Revenue $27.00 $137.50 $7,500.00 1.83 %$7,362.50 Total Miscellaneous Revenues $9,742.27 $31,320.46 $122,500.00 25.57 %$91,179.54 Other Increases in Fund Resources 001-000-000-389-30-00-03 Fireworks - Cleaning Deposit $0.00 $0.00 $2,200.00 0.00 %$2,200.00 001-000-000-389-30-00-04 Fireworks - Dcfd Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-000-389-30-00-05 Crime Victim Assessment $313.74 $671.78 $3,500.00 19.19 %$2,828.22 001-000-000-389-30-00-10 State Surcharge $132.50 $327.00 $500.00 65.40 %$173.00 001-000-000-389-30-00-15 State Share Weapons Permit Fee $577.50 $2,240.75 $9,500.00 23.59 %$7,259.25 001-000-000-389-30-00-20 Court Remittance - State $17,870.31 $39,091.47 $200,000.00 19.55 %$160,908.53 Total Other Increases in Fund Resources $18,894.05 $42,331.00 $215,950.00 19.60 %$173,619.00 Other Financing Sources 001-000-000-395-10-00-00 Proceeds - Disposition of Assets $65.00 $12,489.80 $100.00 12,489.80 %($12,389.80) 001-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-398-10-00-00 Insurance Recoveries $34,991.36 $34,991.36 $0.00 ($34,991.36) Total Other Financing Sources $35,056.36 $47,481.16 $1,100.00 4,316.47 %($46,381.16) Total General Fund $514,769.06 $1,185,471.80 $7,424,455.00 15.97 %$6,238,983.20 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $0.00 $3,142.31 $400,000.00 0.79 %$396,857.69 101-000-000-313-11-00-00 Sales & Use Tax $0.00 $300,000.00 $300,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $535.00 $570.00 $3,000.00 19.00 %$2,430.00 Printed by EASTWENATCHEE\jdelay on 4/15/2020 10:55:07 AM Page 2 of 5 East Wenatchee - Revenue Account Number Title Period Fiscal Budget % of Total Balance 101-000-000-336-00-71-00 Multi-Modal Distribution $4,672.72 $4,672.72 $18,000.00 25.96 %$13,327.28 101-000-000-336-00-87-00 Gas Tax $20,074.14 $63,791.84 $275,000.00 23.20 %$211,208.16 101-000-000-336-00-87-05 Increased Gas Tax $4,088.68 $4,088.68 $16,000.00 25.55 %$11,911.32 Total Street Fund $29,370.54 $376,265.55 $1,012,000.00 37.18 %$635,734.45 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $0.00 $219,619.00 0.00 %$219,619.00 102-000-000-345-89-00-01 Smp - Dct&ls Reimbursement $814.00 $814.00 $0.00 ($814.00) Total Community Development Grants Fund $814.00 $814.00 $219,619.00 0.37 %$218,805.00 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $17,542.80 $52,707.60 $40,000.00 131.77 %($12,707.60) Total Transportation Benefit District Fund $17,542.80 $52,707.60 $40,000.00 131.77 %($12,707.60) Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $0.00 $7,000.00 0.00 %$7,000.00 Total Library Fund $0.00 $0.00 $7,000.00 0.00 %$7,000.00 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $21,002.02 $73,046.81 $250,000.00 29.22 %$176,953.19 Total Hotel/Motel Tax Fund $21,002.02 $73,046.81 $250,000.00 29.22 %$176,953.19 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $3.21 $5.04 $100.00 5.04 %$94.96 Total Drug Fund $3.21 $5.04 $100.00 5.04 %$94.96 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $1,039.30 $3,700.00 28.09 %$2,660.70 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $3,730.39 $14,000.00 26.65 %$10,269.61 Total Criminal Justice Fund $0.00 $4,769.69 $17,700.00 26.95 %$12,930.31 Events Board Fund 117-000-100-397-00-00-00 Transfer-In from Fund 113 $50,000.00 $50,000.00 $135,000.00 37.04 %$85,000.00 117-000-200-347-40-02-01 Easter Egg Hunt Admission Fees $0.00 $0.00 $1,400.00 0.00 %$1,400.00 117-000-300-347-40-12-02 Classy Chassis Parade/Car Show $245.00 $495.00 $9,000.00 5.50 %$8,505.00 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $50.00 $50.00 $150.00 33.33 %$100.00 117-000-300-347-90-00-12 Classy Chassis Sponsorships $0.00 $0.00 $8,000.00 0.00 %$8,000.00 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-347-40-11-03 Wings & Wheels Car Show Registration $100.00 $100.00 $4,500.00 2.22 %$4,400.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $0.00 $0.00 $100.00 0.00 %$100.00 117-000-400-347-90-00-11 Wings & Wheels Sponsorships $0.00 $0.00 $12,000.00 0.00 %$12,000.00 117-000-400-347-90-11-00 Wings & Wheels Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-450-347-90-00-12 Parkway Pile-Up Car Show Sponsorships $0.00 $0.00 $500.00 0.00 %$500.00 117-000-500-367-19-00-01 Christmas Sponsorships $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Events Board Fund $50,395.00 $50,645.00 $173,650.00 29.16 %$123,005.00 Bond Redemption Fund 202-000-000-311-10-00-00 Property Tax $0.00 $0.00 $155,000.00 0.00 %$155,000.00 202-000-000-397-00-00-00 Transfer-In from Fund 110 $0.00 $0.00 $660,000.00 0.00 %$660,000.00 Total Bond Redemption Fund $0.00 $0.00 $815,000.00 0.00 %$815,000.00 Printed by EASTWENATCHEE\jdelay on 4/15/2020 10:55:07 AM Page 3 of 5 East Wenatchee - Revenue Account Number Title Period Fiscal Budget % of Total Balance Street Improvements Fund 301-000-000-311-10-00-00 Property Tax $0.00 $0.00 $20,000.00 0.00 %$20,000.00 301-000-000-333-20-00-13 STP 9th/VMP Intersection $0.00 $0.00 $901,700.00 0.00 %$901,700.00 301-000-000-334-03-60-01 SRTS - 5th St NE: Sterling $0.00 $0.00 $220,224.00 0.00 %$220,224.00 301-000-000-334-03-60-02 SRTS - 5th St NE: Kenroy $0.00 $0.00 $225,778.00 0.00 %$225,778.00 301-000-000-334-03-80-08 TIB 3rd St SE/Highline Drive Roundabout $0.00 $15,467.01 $663,000.00 2.33 %$647,532.99 301-000-000-334-03-80-13 TIB N Kentucky Ave Overlay $0.00 $0.00 $637,500.00 0.00 %$637,500.00 301-000-000-334-03-80-15 TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $76,500.00 0.00 %$76,500.00 301-000-000-334-04-20-02 PWTFL - 10th Street Design $0.00 $60,068.94 $315,000.00 19.07 %$254,931.06 301-000-000-361-10-00-00 Interest Earnings $48.73 $48.73 $0.00 ($48.73) 301-000-000-397-41-10-05 Transfer-In from Fund 105 $0.00 $0.00 $375,000.00 0.00 %$375,000.00 301-000-000-397-95-00-20 Transfer-In from Fund 314 $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Street Improvements Fund $48.73 $75,584.68 $3,584,702.00 2.11 %$3,509,117.32 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $26,491.00 $187,308.22 $350,000.00 53.52 %$162,691.78 314-000-000-391-10-00-00 LTGO Bond Proceeds $0.00 $0.00 $5,000,000.00 0.00 %$5,000,000.00 Total Capital Improvements Fund $26,491.00 $187,308.22 $5,350,000.00 3.50 %$5,162,691.78 Stormwater Fund 401-000-000-334-03-10-00 Dept. of Ecology Capacity Grant $0.00 $0.00 $95,000.00 0.00 %$95,000.00 401-000-000-334-03-10-01 19th St. Ecology Grant $0.00 $46,140.36 $170,000.00 27.14 %$123,859.64 401-000-000-337-00-00-00 Transfer-In from Douglas Co.$581.21 $2,567,670.57 $2,500,000.00 102.71 %($67,670.57) 401-000-000-343-10-00-00 SWU Fee $1,755.00 $1,800.00 $518,000.00 0.35 %$516,200.00 401-000-000-397-00-00-00 Transfer-In from Fund 308 $0.00 $0.00 $103,090.00 0.00 %$103,090.00 Total Stormwater Fund $2,336.21 $2,615,610.93 $3,386,090.00 77.25 %$770,479.07 Equipment Purchase, Repair & Replacement Fund 501-000-000-313-11-00-10 Sales & Use Tax - Police $0.00 $50,000.00 $50,000.00 100.00 %$0.00 501-000-000-313-11-00-20 Sales & Use Tax - Streets $0.00 $300,000.00 $300,000.00 100.00 %$0.00 Total Equipment Purchase, Repair & Replacement Fund $0.00 $350,000.00 $350,000.00 100.00 %$0.00 Grand Totals $662,772.57 $4,972,229.32 $22,630,316.00 21.97 %$17,658,086.68 Printed by EASTWENATCHEE\jdelay on 4/15/2020 10:55:07 AM Page 4 of 5 East Wenatchee - Revenue Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $514,769.06 $1,185,471.80 $7,424,455.00 15.97 %$6,238,983.20 101-000-000-000-00-00-00 Street Fund $29,370.54 $376,265.55 $1,012,000.00 37.18 %$635,734.45 102-000-000-000-00-00-00 Community Development Grants Fund $814.00 $814.00 $219,619.00 0.37 %$218,805.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $17,542.80 $52,707.60 $40,000.00 131.77 %($12,707.60) 112-000-000-000-00-00-00 Library Fund $0.00 $0.00 $7,000.00 0.00 %$7,000.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $21,002.02 $73,046.81 $250,000.00 29.22 %$176,953.19 114-000-000-000-00-00-00 Drug Fund $3.21 $5.04 $100.00 5.04 %$94.96 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $4,769.69 $17,700.00 26.95 %$12,930.31 117-000-000-000-00-00-00 Events Board Fund $50,395.00 $50,645.00 $173,650.00 29.16 %$123,005.00 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $0.00 $815,000.00 0.00 %$815,000.00 301-000-000-000-00-00-00 Street Improvements Fund $48.73 $75,584.68 $3,584,702.00 2.11 %$3,509,117.32 314-000-000-000-00-00-00 Capital Improvements Fund $26,491.00 $187,308.22 $5,350,000.00 3.50 %$5,162,691.78 401-000-000-000-00-00-00 Stormwater Fund $2,336.21 $2,615,610.93 $3,386,090.00 77.25 %$770,479.07 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $0.00 $350,000.00 $350,000.00 100.00 %$0.00 Grand Totals $662,772.57 $4,972,229.32 $22,630,316.00 21.97 %$17,658,086.68 Printed by EASTWENATCHEE\jdelay on 4/15/2020 10:55:07 AM Page 5 of 5 East Wenatchee - Revenue Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 001-000-001-518-20-40-00 Property Management - 311 9th St NE $7.45 $7.45 $0.00 ($7.45) 001-000-001-518-90-40-00 GWATA Membership $0.00 $0.00 $300.00 0.00 %$300.00 001-000-001-518-91-30-00 Wellness $110.42 $120.16 $3,000.00 4.01 %$2,879.84 001-000-001-518-93-49-00 City Theme $0.00 $0.00 $750.00 0.00 %$750.00 001-000-001-521-10-29-00 LEOFF 1 Insurance Premiums $2,227.50 $6,682.50 $27,500.00 24.30 %$20,817.50 001-000-001-528-70-40-00 River Com $25,380.31 $76,140.93 $365,000.00 20.86 %$288,859.07 001-000-001-539-30-40-00 Animal Control $6,126.24 $18,378.72 $73,515.00 25.00 %$55,136.28 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $0.00 $13,928.00 0.00 %$13,928.00 001-000-001-558-70-40-00 Contributions - Region $15,000.00 $15,000.00 $45,000.00 33.33 %$30,000.00 001-000-001-558-70-41-00 NCW Economic Development District $0.00 $0.00 $1,250.00 0.00 %$1,250.00 001-000-001-558-70-41-05 NCWEDD Chelan/Douglas Trends $0.00 $1,500.00 $1,500.00 100.00 %$0.00 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $0.00 $360.00 $360.00 100.00 %$0.00 001-000-001-558-70-41-10 Spirit of Wenatchee Miss Veedol $0.00 $3,000.00 $3,000.00 100.00 %$0.00 001-000-001-558-70-41-15 Wenatchee Valley Museum $10,124.00 $30,372.00 $121,488.00 25.00 %$91,116.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $958.80 $3,600.00 26.63 %$2,641.20 Total General Government $58,975.92 $152,520.56 $660,191.00 23.10 %$507,670.44 Legislative 001-000-110-511-60-10-00 Salaries $12,949.01 $78,674.51 $197,000.00 39.94 %$118,325.49 001-000-110-511-60-20-00 Benefits $3,625.16 $18,306.48 $60,000.00 30.51 %$41,693.52 001-000-110-511-60-21-50 Public Defender $11,645.46 $31,890.92 $135,000.00 23.62 %$103,109.08 001-000-110-511-60-30-00 Public Defender Conflicts $255.00 $255.00 $5,500.00 4.64 %$5,245.00 001-000-110-511-60-31-00 Office Supplies $0.00 $321.27 $300.00 107.09 %($21.27) 001-000-110-511-60-31-05 Newsletter Printing & Mailing $3,991.82 $3,991.82 $10,500.00 38.02 %$6,508.18 001-000-110-511-60-31-10 Public Records Expenses $0.00 $0.00 $200.00 0.00 %$200.00 001-000-110-511-60-40-00 Training $79.81 $79.81 $3,000.00 2.66 %$2,920.19 001-000-110-511-60-41-00 Professional Services $19,467.33 $39,804.54 $42,000.00 94.77 %$2,195.46 001-000-110-511-60-41-20 AWC Annual Membership Fee $0.00 $9,967.00 $10,000.00 99.67 %$33.00 001-000-110-511-60-42-01 Cell Phone $0.00 $56.13 $500.00 11.23 %$443.87 001-000-110-511-60-43-00 Travel $0.00 $391.84 $1,500.00 26.12 %$1,108.16 001-000-110-511-60-43-01 Travel - Misawa $0.00 $0.00 $4,750.00 0.00 %$4,750.00 001-000-110-511-60-44-00 Advertising $390.80 $390.80 $2,000.00 19.54 %$1,609.20 001-000-110-511-60-45-00 Election Costs - Registered Voters $6,257.57 $6,257.57 $22,000.00 28.44 %$15,742.43 001-000-110-511-60-46-00 Insurance $0.00 $28.83 $13,000.00 0.22 %$12,971.17 001-000-110-511-60-47-00 Background Check Costs $11.00 $66.00 $200.00 33.00 %$134.00 001-000-110-511-60-49-00 Miscellaneous $950.03 $1,515.04 $5,000.00 30.30 %$3,484.96 Expenditure Starting Account Number: 001-000-001-518-20-40-00 Property Management - 311 9th St NE Ending Account Number: 501-001-000-508-80-00-00 Ending EPM&R Fund Balance - Unreserved Period: 2020 - March 2020 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 1 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance Total Legislative $59,622.99 $191,997.56 $512,450.00 37.47 %$320,452.44 Municipal Court 001-000-120-512-50-10-00 Salaries $16,822.16 $49,689.80 $199,000.00 24.97 %$149,310.20 001-000-120-512-50-12-00 Salaries - Probation Services $4,673.08 $14,019.24 $55,000.00 25.49 %$40,980.76 001-000-120-512-50-20-00 Benefits $5,435.05 $16,510.77 $74,000.00 22.31 %$57,489.23 001-000-120-512-50-22-00 Benefits - Probation Services $2,917.28 $8,904.42 $41,000.00 21.72 %$32,095.58 001-000-120-512-50-31-00 Office Supplies $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-120-512-50-40-00 Training $0.00 $690.00 $1,500.00 46.00 %$810.00 001-000-120-512-50-43-00 Travel $0.00 $2,005.13 $6,000.00 33.42 %$3,994.87 001-000-120-512-50-46-00 Insurance $0.00 $143.25 $13,860.00 1.03 %$13,716.75 001-000-120-512-50-49-00 Miscellaneous $0.00 $152.00 $0.00 ($152.00) 001-000-120-512-50-49-01 Interpreting $0.00 $140.00 $5,000.00 2.80 %$4,860.00 001-000-120-512-50-49-02 Judge Protems $150.00 $450.00 $4,000.00 11.25 %$3,550.00 001-000-120-512-50-49-03 Witness Fees $0.00 $59.90 $500.00 11.98 %$440.10 001-000-120-512-50-49-04 Juror Fees $0.00 $1,199.98 $2,000.00 60.00 %$800.02 001-000-120-512-50-49-09 Security $437.50 $845.75 $6,000.00 14.10 %$5,154.25 001-000-120-594-12-60-00 Capital Outlay $572.05 $852.09 $5,000.00 17.04 %$4,147.91 Total Municipal Court $31,007.12 $95,662.33 $414,360.00 23.09 %$318,697.67 City Clerk 001-000-140-514-20-10-00 Salaries $6,646.81 $19,523.85 $78,000.00 25.03 %$58,476.15 001-000-140-514-20-20-00 Benefits $2,874.77 $8,522.33 $42,000.00 20.29 %$33,477.67 001-000-140-514-20-31-00 Office Supplies $87.11 $630.35 $3,000.00 21.01 %$2,369.65 001-000-140-514-20-31-01 Central Stores $1,292.63 $1,553.36 $5,000.00 31.07 %$3,446.64 001-000-140-514-20-40-00 Training $125.00 $125.00 $2,000.00 6.25 %$1,875.00 001-000-140-514-20-41-00 Membership Dues & Publications $0.00 $170.00 $1,200.00 14.17 %$1,030.00 001-000-140-514-20-43-00 Travel $0.00 $231.60 $2,500.00 9.26 %$2,268.40 001-000-140-514-20-44-00 Advertising $225.42 $225.42 $2,000.00 11.27 %$1,774.58 001-000-140-514-20-46-00 Insurance $0.00 $14.42 $8,800.00 0.16 %$8,785.58 001-000-140-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-140-514-20-49-00 Miscellaneous $0.00 $58.58 $750.00 7.81 %$691.42 001-000-140-514-30-20-00 Records Services $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-140-514-30-25-00 Codification $0.00 $0.00 $2,100.00 0.00 %$2,100.00 Total City Clerk $11,251.74 $31,054.91 $148,600.00 20.90 %$117,545.09 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $311.60 $311.60 $14,000.00 2.23 %$13,688.40 001-000-141-514-20-42-01 Telephone Line Charges $0.00 $1,383.70 $14,000.00 9.88 %$12,616.30 001-000-141-514-20-42-03 Postage $0.00 $15.65 $7,000.00 0.22 %$6,984.35 001-000-141-514-20-48-00 Repairs & Maintenance $1,517.24 $2,265.00 $3,000.00 75.50 %$735.00 Total Internal Services $1,828.84 $3,975.95 $38,000.00 10.46 %$34,024.05 Finance 001-000-142-514-20-10-00 Salaries $13,923.70 $83,098.78 $210,000.00 39.57 %$126,901.22 001-000-142-514-20-20-00 Benefits $5,349.92 $25,244.63 $95,000.00 26.57 %$69,755.37 001-000-142-514-20-31-00 Office Supplies $311.89 $377.23 $1,700.00 22.19 %$1,322.77 001-000-142-514-20-43-00 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-142-514-20-46-00 Insurance $0.00 $28.83 $9,680.00 0.30 %$9,651.17 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 2 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance 001-000-142-514-23-20-00 State Audit $0.00 $0.00 $18,000.00 0.00 %$18,000.00 001-000-142-514-25-30-00 Bank Charges & Fees $131.38 $727.99 $5,000.00 14.56 %$4,272.01 001-000-142-514-40-20-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Finance $19,716.89 $109,477.46 $342,380.00 31.98 %$232,902.54 Information Technology 001-000-145-514-20-10-00 Salaries $8,183.38 $24,083.10 $96,000.00 25.09 %$71,916.90 001-000-145-514-20-20-00 Benefits $3,427.86 $10,755.14 $50,000.00 21.51 %$39,244.86 001-000-145-514-20-31-00 Supplies $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-145-514-20-40-01 Memberships $0.00 $75.00 $100.00 75.00 %$25.00 001-000-145-514-20-40-05 Disaster Backup System Support $0.00 $0.00 $25,000.00 0.00 %$25,000.00 001-000-145-514-20-40-10 Annual Fee - ESRI GIS System License $2,057.70 $2,057.70 $1,100.00 187.06 %($957.70) 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $0.00 $0.00 $20,645.00 0.00 %$20,645.00 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.00 $5,908.32 $6,000.00 98.47 %$91.68 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $0.00 $7,000.00 0.00 %$7,000.00 001-000-145-514-20-40-40 Annual Subscription - Granicus $0.00 $594.64 $7,000.00 8.49 %$6,405.36 001-000-145-514-20-40-50 Annual License - FTR Recording System $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $0.00 $0.00 $9,800.00 0.00 %$9,800.00 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $262.40 $3,462.40 $8,000.00 43.28 %$4,537.60 001-000-145-514-20-41-00 Professional Services $0.00 $5,800.00 $5,000.00 116.00 %($800.00) 001-000-145-514-20-42-00 Cell Phone $0.00 $69.04 $750.00 9.21 %$680.96 001-000-145-514-20-43-00 Training $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-145-514-20-44-00 Travel $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-145-514-20-49-00 Miscellaneous $73.60 $147.20 $0.00 ($147.20) 001-000-145-594-14-60-20 Capital - PC Software Admin $556.12 $3,272.56 $20,000.00 16.36 %$16,727.44 001-000-145-594-14-60-25 Capital - PC Hardware Admin $5,354.40 $7,626.98 $50,000.00 15.25 %$42,373.02 Total Information Technology $19,915.46 $63,852.08 $316,895.00 20.15 %$253,042.92 Legal 001-000-151-515-31-10-00 Salaries $16,421.38 $36,093.74 $195,000.00 18.51 %$158,906.26 001-000-151-515-31-20-00 Benefits $6,271.14 $14,435.64 $104,000.00 13.88 %$89,564.36 001-000-151-515-31-20-10 Training $150.00 $250.00 $2,000.00 12.50 %$1,750.00 001-000-151-515-31-25-00 Professional Services $3,129.50 $3,185.50 $1,500.00 212.37 %($1,685.50) 001-000-151-515-31-25-10 Licensing $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-151-515-31-31-00 Office Supplies $0.00 $0.00 $300.00 0.00 %$300.00 001-000-151-515-31-42-03 Postage $0.00 $28.93 $0.00 ($28.93) 001-000-151-515-31-43-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-151-515-31-46-00 Insurance $0.00 $14.42 $12,100.00 0.12 %$12,085.58 001-000-151-515-31-49-00 Miscellaneous $30.00 $679.00 $3,000.00 22.63 %$2,321.00 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Legal $26,002.02 $54,687.23 $330,900.00 16.53 %$276,212.77 Civil Service 001-000-160-521-10-10-00 Salaries $520.00 $780.00 $3,214.00 24.27 %$2,434.00 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 3 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance 001-000-160-521-10-46-00 Insurance $0.00 $14.42 $7,150.00 0.20 %$7,135.58 Total Civil Service $520.00 $794.42 $10,364.00 7.67 %$9,569.58 Central Services 001-000-180-518-30-31-01 Central Stores $0.00 $13.53 $0.00 ($13.53) 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $238.56 $506.07 $2,000.00 25.30 %$1,493.93 001-000-180-518-30-35-00 Small Tools & Equipment $216.58 $250.66 $10,000.00 2.51 %$9,749.34 001-000-180-518-30-41-00 Professional Services $334.55 $857.22 $25,000.00 3.43 %$24,142.78 001-000-180-518-30-41-01 Contracted Custodial Services $2,099.13 $6,297.53 $24,000.00 26.24 %$17,702.47 001-000-180-518-30-46-00 Insurance $0.00 $28.83 $47,300.00 0.06 %$47,271.17 001-000-180-518-30-47-00 Utilities $5,277.73 $7,714.69 $25,000.00 30.86 %$17,285.31 001-000-180-518-30-48-00 Repairs & Maintenance $2,257.52 $2,855.92 $12,000.00 23.80 %$9,144.08 001-000-180-518-30-49-00 Miscellaneous $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-180-518-30-49-01 Landscaping $177.20 $177.20 $12,000.00 1.48 %$11,822.80 001-000-180-518-61-41-00 Judgements & Settlements $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$328.72 $4,528.72 $6,000.00 75.48 %$1,471.28 001-000-180-594-18-60-00 Capital Outlay $969.00 $969.00 $22,000.00 4.40 %$21,031.00 Total Central Services $11,898.99 $24,199.37 $197,300.00 12.27 %$173,100.63 Law Enforcement 001-000-210-521-10-10-00 Salaries $188,498.01 $577,739.38 $2,100,000.00 27.51 %$1,522,260.62 001-000-210-521-10-10-02 Overtime Salaries $15,828.03 $45,002.27 $175,000.00 25.72 %$129,997.73 001-000-210-521-10-10-03 Overtime Salaries - Traffic Control $0.00 $555.26 $8,000.00 6.94 %$7,444.74 001-000-210-521-10-20-00 Benefits $86,797.61 $204,302.66 $900,000.00 22.70 %$695,697.34 001-000-210-521-10-20-01 Clothing Allowance $484.74 $1,396.55 $14,400.00 9.70 %$13,003.45 001-000-210-521-10-31-00 Office Supplies $396.07 $179.71 $8,500.00 2.11 %$8,320.29 001-000-210-521-10-31-05 Office Machine Costs $304.13 $934.28 $5,000.00 18.69 %$4,065.72 001-000-210-521-10-32-00 Fuel Consumed $7,983.72 $8,019.18 $52,000.00 15.42 %$43,980.82 001-000-210-521-10-35-00 Small Tools & Equipment $137.64 $3,916.38 $13,000.00 30.13 %$9,083.62 001-000-210-521-10-35-02 WASPC Traffic Safety Grant $3,575.53 $3,575.53 $3,000.00 119.18 %($575.53) 001-000-210-521-10-35-05 Bulletproof Vests $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-210-521-10-35-06 US Marshall Fugitive Task Force $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-521-10-41-00 Professional Services $1,524.10 $2,569.66 $15,000.00 17.13 %$12,430.34 001-000-210-521-10-42-01 Telephone $461.08 $2,344.60 $28,000.00 8.37 %$25,655.40 001-000-210-521-10-42-03 Postage $0.00 $84.74 $1,200.00 7.06 %$1,115.26 001-000-210-521-10-43-00 Travel $0.00 $1,663.88 $22,000.00 7.56 %$20,336.12 001-000-210-521-10-46-00 Insurance $0.00 $317.12 $69,000.00 0.46 %$68,682.88 001-000-210-521-10-48-00 Repairs & Maintenance $224.57 $486.64 $8,000.00 6.08 %$7,513.36 001-000-210-521-10-49-00 Miscellaneous $50.00 $295.00 $5,500.00 5.36 %$5,205.00 001-000-210-521-10-49-01 Reserves $0.00 $0.00 $500.00 0.00 %$500.00 001-000-210-521-10-49-02 Dry Cleaning Services $0.00 $17.58 $1,500.00 1.17 %$1,482.42 001-000-210-521-30-40-00 Crime Prevention $850.00 $850.00 $850.00 100.00 %$0.00 001-000-210-521-40-22-00 Training - Police Chief $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-210-521-40-25-00 Training - Officers $1,385.00 $1,385.00 $9,000.00 15.39 %$7,615.00 001-000-210-521-40-27-00 Training - Office Staff $0.00 $0.00 $900.00 0.00 %$900.00 001-000-210-521-40-30-00 Training - Academy $0.00 $0.00 $9,600.00 0.00 %$9,600.00 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 4 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-50-10-00 Ancillary (Interfund Vehicle Maintenance) $0.00 $0.00 $2,400.00 0.00 %$2,400.00 001-000-210-521-50-49-00 Other Services $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-594-21-60-00 Capital Outlay $0.00 $33,171.22 $33,000.00 100.52 %($171.22) Total Law Enforcement $308,500.23 $888,806.64 $3,493,350.00 25.44 %$2,604,543.36 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $44,583.23 $77,242.46 $378,000.00 20.43 %$300,757.54 001-000-230-523-60-20-00 Medical Care - Prisoners $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-230-527-60-30-00 Juvenile Detention $960.00 $960.00 $6,500.00 14.77 %$5,540.00 Total Jail Services $45,543.23 $78,202.46 $394,500.00 19.82 %$316,297.54 001-000-310-531-30-44-00 Swu - Maint - Advertising $19.08 $19.08 $0.00 ($19.08) 001-000-310-531-30-45-00 Swu Maintenance Rentals/leases $23.68 $23.68 $0.00 ($23.68) Public Works 001-000-315-542-10-10-00 Salaries $7,965.72 $23,431.32 $94,000.00 24.93 %$70,568.68 001-000-315-542-10-20-00 Benefits $3,298.90 $10,253.94 $46,000.00 22.29 %$35,746.06 001-000-315-542-10-31-00 Office Supplies $0.00 $0.00 $750.00 0.00 %$750.00 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-542-10-40-00 Cell Phone $0.00 $59.04 $750.00 7.87 %$690.96 001-000-315-542-10-43-00 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-46-00 Insurance $0.00 $14.42 $11,000.00 0.13 %$10,985.58 001-000-315-542-10-49-00 Training $0.00 $227.00 $2,000.00 11.35 %$1,773.00 001-000-315-542-10-49-01 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-49-10 Memberships $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-544-20-45-00 Engineering Support Services $0.00 $0.00 $15,000.00 0.00 %$15,000.00 Total Public Works $11,264.62 $33,985.72 $172,500.00 19.70 %$138,514.28 Planning 001-000-580-558-60-10-00 Salaries $15,108.98 $44,784.46 $179,500.00 24.95 %$134,715.54 001-000-580-558-60-20-00 Benefits $4,733.10 $14,858.86 $62,000.00 23.97 %$47,141.14 001-000-580-558-60-31-00 Office Supplies $56.50 $94.36 $1,000.00 9.44 %$905.64 001-000-580-558-60-32-00 Fuel Consumed $15.27 $15.27 $200.00 7.64 %$184.73 001-000-580-558-60-35-00 Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 001-000-580-558-60-40-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-580-558-60-41-00 Professional Services $0.00 $0.00 $25,000.00 0.00 %$25,000.00 001-000-580-558-60-41-01 Hearings Examiner $0.00 $0.00 $600.00 0.00 %$600.00 001-000-580-558-60-41-02 Engineer/Architect Services $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-580-558-60-43-00 Travel $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-580-558-60-44-00 Advertising $173.40 $173.40 $3,500.00 4.95 %$3,326.60 001-000-580-558-60-46-00 Insurance $0.00 $28.83 $11,440.00 0.25 %$11,411.17 001-000-580-558-60-48-00 Repairs & Maintenance $8.27 $8.27 $100.00 8.27 %$91.73 001-000-580-558-60-49-00 Miscellaneous $300.00 $915.00 $2,200.00 41.59 %$1,285.00 Total Planning $20,395.52 $60,878.45 $291,840.00 20.86 %$230,961.55 Code Compliance 001-000-590-558-50-10-00 Salaries $8,766.79 $26,213.29 $111,000.00 23.62 %$84,786.71 001-000-590-558-50-20-00 Benefits $4,124.13 $12,637.01 $56,000.00 22.57 %$43,362.99 001-000-590-558-50-31-00 Office Supplies $0.00 $71.67 $2,200.00 3.26 %$2,128.33 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 5 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-32-00 Fuel Consumed $33.82 $71.63 $460.00 15.57 %$388.37 001-000-590-558-50-35-00 Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 001-000-590-558-50-40-00 Training $0.00 $0.00 $300.00 0.00 %$300.00 001-000-590-558-50-41-01 Fire Marshal Services ($97.00)($97.00)$21,500.00 -0.45 %$21,597.00 001-000-590-558-50-42-00 Abatement $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-590-558-50-43-00 Travel $0.00 $0.00 $475.00 0.00 %$475.00 001-000-590-558-50-46-00 Insurance $0.00 $14.42 $8,690.00 0.17 %$8,675.58 001-000-590-558-50-49-00 Miscellaneous $0.00 $95.00 $300.00 31.67 %$205.00 Total Code Compliance $12,827.74 $39,006.02 $231,025.00 16.88 %$192,018.98 Other Expenditures 001-001-000-589-30-00-03 Fireworks - Deposit Refund $0.00 $0.00 $2,500.00 0.00 %$2,500.00 001-001-000-589-30-00-04 Fireworks - DCFD Remittance $0.00 $0.00 $500.00 0.00 %$500.00 001-001-000-589-30-00-05 County Share of Crime Victims $0.00 $748.96 $4,000.00 18.72 %$3,251.04 001-001-000-589-30-00-10 Remittance: State Building Code Surcharge $31.50 $219.50 $500.00 43.90 %$280.50 001-001-000-589-30-00-15 State Share of Permits & Licenses $495.75 $1,575.00 $11,500.00 13.70 %$9,925.00 001-001-000-589-30-00-20 Court Remittances $14,124.76 $27,280.18 $211,000.00 12.93 %$183,719.82 Total Other Expenditures $14,652.01 $29,823.64 $230,000.00 12.97 %$200,176.36 Total General Fund $653,966.08 $1,858,967.56 $7,784,655.00 23.88 %$5,925,687.44 Street Fund Storm Water Administration 101-000-311-542-42-10-00 SWU Administration - Salaries $0.00 $1,703.52 $0.00 ($1,703.52) 101-000-311-542-42-20-00 SWU Administration - Benefits ($288.52)($288.52)$0.00 $288.52 Total Storm Water Administration ($288.52)$1,415.00 $0.00 ($1,415.00) NPDES 101-000-313-542-42-10-00 NPDES Maintenance Salaries $0.00 $269.47 $0.00 ($269.47) 101-000-313-542-42-10-10 NPDES Sweeping Salaries $0.00 $641.61 $0.00 ($641.61) 101-000-313-542-42-20-00 NPDES Maintenance Benefits $746.27 $801.54 $0.00 ($801.54) 101-000-313-542-42-20-10 NPDES Sweeping Benefits $190.64 $322.24 $0.00 ($322.24) Total NPDES $936.91 $2,034.86 $0.00 ($2,034.86) 101-000-420-542-30-10-00 Salaries - Roadway $2,757.24 $5,615.82 $80,000.00 7.02 %$74,384.18 101-000-420-542-30-20-00 Benefits - Roadway $2,339.67 $3,858.20 $53,000.00 7.28 %$49,141.80 101-000-420-542-30-30-00 Supplies - Roadway $129.51 $1,200.00 $50,000.00 2.40 %$48,800.00 101-000-420-542-30-48-00 Repairs & Maintenance - Roadway $0.00 $0.00 $6,000.00 0.00 %$6,000.00 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $0.00 $4,500.00 0.00 %$4,500.00 101-000-420-542-61-20-00 Benefits - Sidewalks $14.10 $14.10 $2,400.00 0.59 %$2,385.90 101-000-420-542-61-30-00 Supplies - Sidewalks $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-420-542-61-48-00 Repairs & Maintenance - Sidewalks $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-62-10-00 Salaries - Special Purpose Paths $277.10 $277.10 $500.00 55.42 %$222.90 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $67.29 $67.29 $250.00 26.92 %$182.71 101-000-420-542-62-30-00 Supplies - Special Purpose Paths $0.00 $0.00 $2,500.00 0.00 %$2,500.00 101-000-420-542-63-10-00 Salaries - Street Lighting $0.00 $355.20 $2,000.00 17.76 %$1,644.80 101-000-420-542-63-20-00 Benefits - Street Lighting $39.82 $135.32 $1,200.00 11.28 %$1,064.68 101-000-420-542-63-30-00 Supplies - Street Lighting $0.00 $0.00 $500.00 0.00 %$500.00 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 6 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-63-47-00 Utilities - Street Lighting $4,693.49 $7,259.89 $60,000.00 12.10 %$52,740.11 101-000-420-542-63-48-00 Repairs & Maintenance - Street Lighting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $3,500.42 $3,836.14 $40,000.00 9.59 %$36,163.86 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $2,677.74 $2,882.42 $23,000.00 12.53 %$20,117.58 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $16,761.22 $16,826.19 $48,000.00 35.05 %$31,173.81 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $800.97 $1,422.97 $9,000.00 15.81 %$7,577.03 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $34.44 $34.44 $14,000.00 0.25 %$13,965.56 101-000-420-542-65-10-00 Salaries - Parking Facilities $0.00 $371.18 $1,000.00 37.12 %$628.82 101-000-420-542-65-20-00 Benefits - Parking Facilities $35.40 $347.05 $500.00 69.41 %$152.95 101-000-420-542-65-30-00 Supplies - Parking Facilities $0.00 $0.00 $300.00 0.00 %$300.00 101-000-420-542-65-47-00 Utilities - Parking Facilities $270.00 $270.00 $500.00 54.00 %$230.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $612.59 $9,313.30 $70,000.00 13.30 %$60,686.70 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $786.99 $5,999.65 $47,000.00 12.77 %$41,000.35 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $33,713.06 $42,403.71 $100,000.00 42.40 %$57,596.29 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $1,446.97 $1,872.37 $5,000.00 37.45 %$3,127.63 101-000-420-542-69-10-00 Salaries - Flags/Banners $0.00 $1,616.31 $30,000.00 5.39 %$28,383.69 101-000-420-542-69-20-00 Benefits - Flags/Banners $206.09 $618.63 $25,000.00 2.47 %$24,381.37 101-000-420-542-69-30-00 Supplies - Flags/Banners $0.00 $798.07 $2,000.00 39.90 %$1,201.93 101-000-420-542-70-10-00 Salaries - Roadside $15,044.19 $53,341.67 $180,000.00 29.63 %$126,658.33 101-000-420-542-70-20-00 Benefits - Roadside $8,185.74 $27,849.67 $94,000.00 29.63 %$66,150.33 101-000-420-542-70-30-00 Supplies - Roadside $162.63 $386.50 $5,000.00 7.73 %$4,613.50 101-000-420-542-70-41-00 Professional Services - Roadside $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-70-47-00 Utilities - Roadside $796.20 $796.20 $1,000.00 79.62 %$203.80 101-000-420-542-70-48-00 Repairs & Maintenance - Roadside $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-75-10-00 Salaries - City Parks $7,757.61 $17,331.05 $45,000.00 38.51 %$27,668.95 101-000-420-542-75-20-00 Benefits - City Parks $4,917.23 $9,063.58 $23,000.00 39.41 %$13,936.42 101-000-420-542-75-30-00 Supplies - City Parks $165.16 $540.59 $15,000.00 3.60 %$14,459.41 101-000-420-542-75-47-00 Utilities - City Parks $679.06 $725.06 $4,000.00 18.13 %$3,274.94 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $100.20 $625.97 $4,000.00 15.65 %$3,374.03 101-000-420-542-80-48-00 Japanese Garden Agreement $1,500.00 $3,000.00 $18,000.00 16.67 %$15,000.00 101-000-420-542-90-10-00 Salaries - Maintenance Admin $0.00 $1,172.88 $0.00 ($1,172.88) 101-000-420-542-90-20-00 Benefits - Maintenance Admin $72.11 $356.82 $0.00 ($356.82) 101-000-430-543-30-10-00 Salaries - General Services $1,543.89 $5,536.57 $0.00 ($5,536.57) 101-000-430-543-30-20-00 Benefits - General Services $283.61 $2,029.90 $0.00 ($2,029.90) 101-000-430-543-30-30-00 Supplies - General Services $855.53 $1,543.14 $6,000.00 25.72 %$4,456.86 101-000-430-543-30-46-00 Insurance $10.64 $134.99 $54,000.00 0.25 %$53,865.01 101-000-430-543-30-49-00 Miscellaneous - General Services $280.24 $920.24 $3,000.00 30.67 %$2,079.76 101-000-430-543-50-10-00 Salaries - Facilities $0.00 $1,410.94 $3,000.00 47.03 %$1,589.06 101-000-430-543-50-20-00 Benefits - Facilities $126.90 $613.79 $1,600.00 38.36 %$986.21 101-000-430-543-50-30-00 Supplies - Facilities $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-430-543-50-42-01 Cell Phone $0.00 $59.04 $750.00 7.87 %$690.96 101-000-430-543-50-47-00 Utilities - Facilities $1,217.82 $2,028.58 $6,000.00 33.81 %$3,971.42 101-000-430-543-50-48-00 Repairs & Maintenance - Facilities $0.00 $0.00 $2,500.00 0.00 %$2,500.00 101-000-430-544-90-10-00 Salaries - Training $130.57 $708.08 $6,500.00 10.89 %$5,791.92 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 7 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance 101-000-430-544-90-20-00 Benefits - Training $84.88 $331.56 $3,872.00 8.56 %$3,540.44 101-000-430-544-90-30-00 Supplies - Training $14.15 $14.15 $500.00 2.83 %$485.85 101-000-430-544-90-35-00 Travel $27.00 $27.00 $4,000.00 0.68 %$3,973.00 101-000-430-544-90-49-01 Training $33.99 $33.99 $1,000.00 3.40 %$966.01 Total Street Fund $115,801.85 $241,427.17 $1,175,872.00 20.53 %$934,444.83 Community Development Grants Fund 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $0.00 $192,619.00 0.00 %$192,619.00 102-000-000-558-70-41-00 CDBG Professional Services $0.00 $0.00 $25,300.00 0.00 %$25,300.00 102-000-000-558-70-44-00 CDBG Advertising $0.00 $0.00 $1,600.00 0.00 %$1,600.00 102-000-000-558-70-49-00 CDBG Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Community Development Grants Fund $0.00 $0.00 $219,619.00 0.00 %$219,619.00 Transportation Benefit District Fund 105-000-000-597-91-00-00 Transfer-Out to Fund 301 $0.00 $0.00 $375,000.00 0.00 %$375,000.00 Total Transportation Benefit District Fund $0.00 $0.00 $375,000.00 0.00 %$375,000.00 Financing Reserves Fund 110-000-000-597-00-00-00 Transfer-Out to Fund 202 $0.00 $0.00 $660,000.00 0.00 %$660,000.00 Total Financing Reserves Fund $0.00 $0.00 $660,000.00 0.00 %$660,000.00 Library Fund 112-000-000-572-50-41-00 Facilities - Professional Services $0.00 $0.00 $2,000.00 0.00 %$2,000.00 112-000-000-572-50-47-00 Facilities - Utilities $696.77 $1,712.14 $4,000.00 42.80 %$2,287.86 112-000-000-572-50-49-00 Facilities - Supplies & Miscellaneous $0.00 $0.00 $40.00 0.00 %$40.00 Total Library Fund $696.77 $1,712.14 $6,040.00 28.35 %$4,327.86 Hotel/Motel Tax Fund 113-000-000-557-30-41-00 First 2% Tax $5,000.00 $5,000.00 $0.00 ($5,000.00) 113-000-000-557-30-41-10 Contributions to Other Entities $5,000.00 $5,000.00 $70,000.00 7.14 %$65,000.00 113-001-000-597-00-00-01 Transfer-Out to Fund 117 $50,000.00 $50,000.00 $135,000.00 37.04 %$85,000.00 Total Hotel/Motel Tax Fund $60,000.00 $60,000.00 $205,000.00 29.27 %$145,000.00 Events Board Fund 117-000-050-557-30-10-00 Salaries $4,315.28 $16,057.90 $78,000.00 20.59 %$61,942.10 117-000-050-557-30-20-00 Benefits $2,254.73 $7,656.93 $41,000.00 18.68 %$33,343.07 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $249.00 $3,000.00 8.30 %$2,751.00 117-000-100-557-30-32-00 Fuel $0.00 $0.00 $200.00 0.00 %$200.00 117-000-100-557-30-40-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-100-557-30-41-00 Professional Services $12.95 $25.90 $600.00 4.32 %$574.10 117-000-100-557-30-42-00 Cell Phone $79.81 $138.85 $600.00 23.14 %$461.15 117-000-100-557-30-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 117-000-100-557-30-44-00 Advertising $0.00 $0.00 $500.00 0.00 %$500.00 117-000-105-557-30-40-00 Insurance $0.00 $28.83 $8,360.00 0.34 %$8,331.17 117-000-115-557-30-31-05 Office Supplies $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-200-557-30-35-02 Easter - Small Tools & Equipment $0.00 $0.00 $200.00 0.00 %$200.00 117-000-200-557-30-44-02 Easter - Advertising $0.00 $0.00 $500.00 0.00 %$500.00 117-000-200-557-30-46-02 Easter - Office Supplies $0.00 $0.00 $100.00 0.00 %$100.00 117-000-200-557-30-49-02 Easter - Miscellaneous $1,617.00 $1,671.14 $600.00 278.52 %($1,071.14) 117-000-300-557-30-35-12 CC - Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 8 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance 117-000-300-557-30-41-12 CC - Professional Services $0.00 $259.68 $2,300.00 11.29 %$2,040.32 117-000-300-557-30-42-14 CC - Postage $0.00 $0.00 $500.00 0.00 %$500.00 117-000-300-557-30-43-12 CC - EMPD Facility Fee $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-300-557-30-44-12 CC - Advertising $100.00 $209.00 $3,000.00 6.97 %$2,791.00 117-000-300-557-30-49-12 CC - Miscellaneous $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-400-557-30-35-11 W&W - Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-557-30-41-00 W&W - Professional Services $0.00 $0.00 $5,200.00 0.00 %$5,200.00 117-000-400-557-30-42-13 W&W - Postage $0.00 $0.00 $550.00 0.00 %$550.00 117-000-400-557-30-43-12 W&W - EMPD Facility Fee $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-557-30-44-11 W&W - Advertising $0.00 $109.00 $5,000.00 2.18 %$4,891.00 117-000-400-557-30-49-11 W&W - Miscellaneous $0.00 $0.00 $300.00 0.00 %$300.00 117-000-400-557-30-49-13 W&W - Schedule of Events Brochure $0.00 $0.00 $1,600.00 0.00 %$1,600.00 117-000-450-557-30-41-00 Parkway Pile-Up - Professional Services $0.00 $0.00 $600.00 0.00 %$600.00 117-000-450-557-30-44-12 Parkway Pile-Up - Advertising $0.00 $10.00 $500.00 2.00 %$490.00 117-000-450-557-30-49-01 Parkway Pile-Up - Miscellaneous $0.00 $0.00 $300.00 0.00 %$300.00 117-000-500-557-30-35-01 Christmas - Small Tools & Equipment $0.00 $61.64 $150.00 41.09 %$88.36 117-000-500-557-30-40-05 Christmas - Events & Decorations $0.00 $0.00 $10,000.00 0.00 %$10,000.00 117-000-500-557-30-41-01 Christmas - Professional Services $0.00 $0.00 $400.00 0.00 %$400.00 117-000-500-557-30-44-01 Christmas - Advertising $0.00 $0.00 $750.00 0.00 %$750.00 117-000-500-557-30-49-01 Christmas - Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 Total Events Board Fund $8,379.77 $26,477.87 $173,810.00 15.23 %$147,332.13 Bond Redemption Fund 202-000-000-591-48-70-00 Principal - 2020 LTGO Bond (Public Works Area) $0.00 $0.00 $150,000.00 0.00 %$150,000.00 202-000-000-591-95-70-00 Principal - PWTFL 10th St. NE $0.00 $0.00 $125,000.00 0.00 %$125,000.00 202-000-000-591-95-71-05 Principal - PWTFL 11th St. NE $0.00 $0.00 $29,713.00 0.00 %$29,713.00 202-000-000-592-48-80-00 Interest - 2020 LTGO Bond (Public Works Area) $0.00 $0.00 $223,300.00 0.00 %$223,300.00 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $0.00 $0.00 $7,500.00 0.00 %$7,500.00 202-000-000-592-95-89-05 Interest - PWTFL 11th St. NE $0.00 $0.00 $298.00 0.00 %$298.00 Total Bond Redemption Fund $0.00 $0.00 $535,811.00 0.00 %$535,811.00 Street Improvements Fund 301-000-000-595-10-40-01 Design 2020 TBD Paving $0.00 $0.00 $30,000.00 0.00 %$30,000.00 301-000-000-595-10-40-02 Design - TIB N. Kentucky Overlay $0.00 $0.00 $80,000.00 0.00 %$80,000.00 301-000-000-595-10-40-03 Design - TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $90,000.00 0.00 %$90,000.00 301-000-000-595-10-40-19 Design - TIB 3rd St SE/Highline Dr Roundabout $2,976.79 $5,135.04 $5,000.00 102.70 %($135.04) 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $0.00 $0.00 $259,087.00 0.00 %$259,087.00 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $0.00 $0.00 $265,321.00 0.00 %$265,321.00 301-000-000-595-10-40-26 Design - PWTFL - 10th St $5,374.59 $6,086.45 $320,000.00 1.90 %$313,913.55 301-000-000-595-20-60-01 ROW - PWTFL -10th St. Design $4,077.64 $4,363.35 $78,000.00 5.59 %$73,636.65 301-000-000-595-30-40-41 SDC - TIB 3rd St/Highline Roundabout $0.00 $0.00 $75,000.00 0.00 %$75,000.00 301-000-000-595-30-60-00 Construction - TIB 3rd St/Highline Roundabout $0.00 $0.00 $700,000.00 0.00 %$700,000.00 301-000-000-595-30-60-01 SDC 2020 TBD Paving $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 9 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-595-30-60-02 Construction 2020 TBD Paving $0.00 $0.00 $325,000.00 0.00 %$325,000.00 301-000-000-595-30-60-03 SDC - TIB N. Kentucky Overlay $0.00 $0.00 $45,000.00 0.00 %$45,000.00 301-000-000-595-30-60-04 Construction - TIB N. Kentucky Overlay $0.00 $0.00 $625,000.00 0.00 %$625,000.00 301-000-000-595-61-60-00 TIB Complete Streets - Grant/Georgia Crossing $0.00 $17,147.61 $75,000.00 22.86 %$57,852.39 301-000-000-595-61-60-01 TIB Complete Streets - Grant/June Crossing $0.00 $24,650.21 $100,000.00 24.65 %$75,349.79 301-000-000-595-61-60-02 TIB Complete Streets - 3rd St. Sidewalk $0.00 $17,570.61 $225,000.00 7.81 %$207,429.39 301-000-000-595-64-40-01 Design - 9th/VMP Intersection $0.00 $0.00 $156,400.00 0.00 %$156,400.00 301-000-000-595-64-60-00 SDC - 9th/VMP Intersection $0.00 $0.00 $93,100.00 0.00 %$93,100.00 301-000-000-595-64-60-01 Construction - 9th/VMP Intersection $0.00 $0.00 $795,000.00 0.00 %$795,000.00 Total Street Improvements Fund $12,429.02 $74,953.27 $4,361,908.00 1.72 %$4,286,954.73 Storm Water Improvements Fund 308-000-000-597-00-00-00 Transfer-Out to 401 Fund $0.00 $0.00 $103,090.00 0.00 %$103,090.00 308-000-312-595-40-20-00 Benefits - SWA Improvement Projects $9.41 $9.41 $0.00 ($9.41) Total Storm Water Improvements Fund $9.41 $9.41 $103,090.00 0.01 %$103,080.59 Capital Improvements Fund 314-000-000-594-22-60-50 Maintenance Facilities Design $0.00 $0.00 $145,000.00 0.00 %$145,000.00 314-000-000-594-48-60-00 Maintenance Facilities Construction $0.00 $0.00 $2,500,000.00 0.00 %$2,500,000.00 314-001-000-597-00-00-01 Transfer-Out to 301 Fund $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Capital Improvements Fund $0.00 $0.00 $2,795,000.00 0.00 %$2,795,000.00 Stormwater Fund Stormwater Utility Admin 401-000-001-531-00-10-00 Salaries - Stormwater Admin $2,159.81 $6,479.44 $15,750.00 41.14 %$9,270.56 401-000-001-531-00-20-00 Benefits - Stormwater Admin $1,049.93 $3,236.27 $6,300.00 51.37 %$3,063.73 401-000-001-531-00-30-00 Supplies - Stormwater Admin $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-531-00-30-01 Small Tools & Equipment $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-001-531-00-40-00 Cell Phone $0.00 $59.04 $750.00 7.87 %$690.96 401-000-001-531-00-40-01 Fee Collection - Douglas Co.$0.00 $0.00 $8,500.00 0.00 %$8,500.00 401-000-001-531-00-40-02 Insurance $0.00 $283.80 $5,000.00 5.68 %$4,716.20 401-000-001-531-00-40-03 City Stormwater Utility Charge $164,430.00 $164,430.00 $165,000.00 99.65 %$570.00 401-000-001-531-00-40-04 Miscellaneous $0.00 $67.67 $0.00 ($67.67) 401-000-001-531-00-40-06 Travel - Stormwater Admin $0.00 $10.66 $0.00 ($10.66) Total Stormwater Utility Admin $167,639.74 $174,566.88 $202,800.00 86.08 %$28,233.12 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $2,661.76 $4,852.01 $9,000.00 53.91 %$4,147.99 401-000-002-531-00-20-01 Benefits - NPDES Admin $1,043.69 $1,739.78 $3,600.00 48.33 %$1,860.22 401-000-002-531-00-40-02 Repairs & Maint. - NPDES Admin $0.00 $145.12 $0.00 ($145.12) 401-000-002-531-00-40-04 Municipal Stormwater Permit Fee $2,535.64 $5,071.29 $8,000.00 63.39 %$2,928.71 Total NPDES Admin $6,241.09 $11,808.20 $20,600.00 57.32 %$8,791.80 NPDES Outreach 401-000-003-531-00-10-02 Salaries - NPDES Outreach $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-003-531-00-20-02 Benefits - NPDES Outreach $0.00 $0.00 $600.00 0.00 %$600.00 401-000-003-531-00-30-02 Supplies - NPDES Outreach $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 10 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance Total NPDES Outreach $0.00 $0.00 $3,100.00 0.00 %$3,100.00 NPDES Public Involvement 401-000-004-531-00-10-03 Salaries - NPDES Public Involvement $0.00 $0.00 $500.00 0.00 %$500.00 401-000-004-531-00-20-03 Benefits - NPDES Public Involvement $0.00 $0.00 $200.00 0.00 %$200.00 401-000-004-531-00-30-03 Supplies - NPDES Public Involvement $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Public Involvement $0.00 $0.00 $1,700.00 0.00 %$1,700.00 NPDES IDDE 401-000-005-531-00-10-04 Salaries - NPDES IDDE $0.00 $0.00 $6,500.00 0.00 %$6,500.00 401-000-005-531-00-20-04 Benefits - NPDES IDDE $0.00 $0.00 $2,600.00 0.00 %$2,600.00 401-000-005-531-00-30-04 Supplies - NPDES IDDE $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES IDDE $0.00 $0.00 $10,100.00 0.00 %$10,100.00 NPDES Construction 401-000-006-531-00-10-05 Salaries - NPDES Construction $273.77 $273.77 $1,500.00 18.25 %$1,226.23 401-000-006-531-00-20-05 Benefits - NPDES Construction $59.11 $59.11 $600.00 9.85 %$540.89 Total NPDES Construction $332.88 $332.88 $2,100.00 15.85 %$1,767.12 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $0.00 $0.00 $600.00 0.00 %$600.00 Total NPDES Post Construction $0.00 $0.00 $2,100.00 0.00 %$2,100.00 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $349.03 $4,773.56 $73,000.00 6.54 %$68,226.44 401-000-008-531-00-10-08 Salaries - Sweeping $2,627.25 $5,018.36 $12,000.00 41.82 %$6,981.64 401-000-008-531-00-20-07 Benefits - NPDES PPGH $435.16 $2,855.56 $29,200.00 9.78 %$26,344.44 401-000-008-531-00-20-08 Benefits - Sweeping $1,235.73 $2,745.80 $4,800.00 57.20 %$2,054.20 401-000-008-531-00-30-05 Supplies - NPDES PPGH $4,885.62 $4,981.44 $30,000.00 16.60 %$25,018.56 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $156.80 $283.30 $0.00 ($283.30) 401-000-008-531-00-40-05 Rental Equipment $0.00 $0.00 $35,000.00 0.00 %$35,000.00 401-000-008-531-00-40-06 Utilities $558.96 $921.54 $2,200.00 41.89 %$1,278.46 Total NPDES PPGH $10,248.55 $21,579.56 $186,200.00 11.59 %$164,620.44 NPDES Monitoring 401-000-009-531-00-10-09 Salaries - NPDES Monitoring $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-009-531-00-20-09 Benefits - NPDES Monitoring $0.00 $0.00 $400.00 0.00 %$400.00 401-000-009-531-00-30-06 Supplies - NPDES Monitoring $0.00 $0.00 $100.00 0.00 %$100.00 Total NPDES Monitoring $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Capital Outlay 401-000-010-594-31-60-00 Mechanical Sweeper $0.00 $0.00 $355,000.00 0.00 %$355,000.00 401-000-010-594-31-60-01 Storm Sewer Camera $0.00 $0.00 $15,000.00 0.00 %$15,000.00 401-000-010-594-31-60-03 Devon Pond $0.00 $0.00 $15,000.00 0.00 %$15,000.00 Total Capital Outlay $0.00 $0.00 $385,000.00 0.00 %$385,000.00 401-000-011-594-31-60-04 19th Stormwater Facility Design $3,443.00 $11,112.50 $130,000.00 8.55 %$118,887.50 401-000-012-594-31-60-05 Small Improvements Projects $0.00 $0.00 $100,000.00 0.00 %$100,000.00 401-000-013-531-00-40-08 Payment to Douglas Co. for PWTFL $0.00 $0.00 $76,000.00 0.00 %$76,000.00 401-000-014-531-00-40-07 Stormwater Comp Plan Update $173.40 $173.40 $150,000.00 0.12 %$149,826.60 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 11 of 13 East Wenatchee - Expenditure Account Number Title Period Fiscal Budget % of Total Balance 401-000-015-594-31-60-02 ConTech Filter Design $0.00 $0.00 $50,000.00 0.00 %$50,000.00 401-000-016-594-31-60-06 VMP LID Landscape $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Total Stormwater Fund $188,078.66 $219,573.42 $1,341,200.00 16.37 %$1,121,626.58 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $1,672.99 $2,700.70 $5,000.00 54.01 %$2,299.30 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $1,030.61 $1,379.20 $2,600.00 53.05 %$1,220.80 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $1,041.62 $12,414.78 $30,000.00 41.38 %$17,585.22 501-000-000-542-90-10-00 Street Vehicle Repair Labor $2,031.50 $8,071.71 $23,000.00 35.09 %$14,928.29 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $1,451.94 $3,612.06 $12,000.00 30.10 %$8,387.94 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $691.32 $3,290.86 $31,000.00 10.62 %$27,709.14 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $1,169.09 $1,246.97 $5,000.00 24.94 %$3,753.03 501-000-000-542-90-48-30 Street Equipment Repairs $104.50 $104.50 $1,600.00 6.53 %$1,495.50 501-000-000-594-21-60-00 Capital Outlay - Police Vehicles $45,545.43 $87,869.13 $58,500.00 150.20 %($29,369.13) 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $0.00 $8,000.00 0.00 %$8,000.00 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $0.00 $250,000.00 0.00 %$250,000.00 Total Equipment Purchase, Repair & Replacement Fund $54,739.00 $120,689.91 $426,700.00 28.28 %$306,010.09 Grand Totals $1,094,100.56 $2,603,810.75 $20,163,705.00 12.91 %$17,559,894.25 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 12 of 13 East Wenatchee - Expenditure Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $653,966.08 $1,858,967.56 $7,784,655.00 23.88 %$5,925,687.44 101-000-000-000-00-00-00 Street Fund $115,801.85 $241,427.17 $1,175,872.00 20.53 %$934,444.83 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $219,619.00 0.00 %$219,619.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $0.00 $375,000.00 0.00 %$375,000.00 110-000-000-000-00-00-00 Financing Reserves Fund $0.00 $0.00 $660,000.00 0.00 %$660,000.00 112-000-000-000-00-00-00 Library Fund $696.77 $1,712.14 $6,040.00 28.35 %$4,327.86 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $60,000.00 $60,000.00 $205,000.00 29.27 %$145,000.00 117-000-000-000-00-00-00 Events Board Fund $8,379.77 $26,477.87 $173,810.00 15.23 %$147,332.13 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $0.00 $535,811.00 0.00 %$535,811.00 301-000-000-000-00-00-00 Street Improvements Fund $12,429.02 $74,953.27 $4,361,908.00 1.72 %$4,286,954.73 308-000-000-000-00-00-00 Storm Water Improvements Fund $9.41 $9.41 $103,090.00 0.01 %$103,080.59 314-000-000-000-00-00-00 Capital Improvements Fund $0.00 $0.00 $2,795,000.00 0.00 %$2,795,000.00 401-000-000-000-00-00-00 Stormwater Fund $188,078.66 $219,573.42 $1,341,200.00 16.37 %$1,121,626.58 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $54,739.00 $120,689.91 $426,700.00 28.28 %$306,010.09 Grand Totals $1,094,100.56 $2,603,810.75 $20,163,705.00 12.91 %$17,559,894.25 Printed by EASTWENATCHEE\jdelay on 4/15/2020 11:11:28 AM Page 13 of 13 East Wenatchee - Expenditure Beginning Activity Ending March 2019 Variance Cash In Cash Ending Cash (Decrease)/Increase 001 $3,102,827.67 $1,185,471.80 $2,429,331.91 $2,453,382.20 ($24,050.29) 101 $225,972.00 $376,265.55 $360,810.38 $280,987.89 $79,822.49 102 $77,431.47 $814.00 $78,245.47 $77,954.27 $291.20 105 $334,569.98 $52,707.60 $387,277.58 $428,527.50 ($41,249.92) 110 $660,000.00 $0.00 $660,000.00 $495,000.00 $165,000.00 112 $12,079.33 $0.00 $10,367.19 $9,086.70 $1,280.49 113 $81,632.99 $73,046.81 $94,679.80 $81,170.96 $13,508.84 114 $1,514.77 $5.04 $1,519.81 $1,077.23 $442.58 116 $47,204.19 $4,769.69 $51,973.88 $32,957.40 $19,016.48 117 $52,972.21 $50,645.00 $77,139.34 $100,904.88 ($23,765.54) 202 $8,668.69 $0.00 $8,668.69 $33,301.25 ($24,632.56) 301 $940,019.68 $75,584.68 $940,651.09 $502,218.98 $438,432.11 308 $66,058.66 $0.00 $66,049.25 $115,590.47 ($49,541.22) 314 $1,076,863.08 $187,308.22 $1,264,171.30 $1,105,250.67 $158,920.63 401 $0.00 $2,615,610.93 $2,396,037.51 $0.00 $2,396,037.51 501 $121,658.96 $350,000.00 $350,969.05 $273,793.61 $77,175.44 $6,809,473.68 $4,972,229.32 $9,177,892.25 $5,991,204.01 $3,186,688.24$2,603,810.75 Stormwater Fund $219,573.42 Equipment Purchase, Repair & Replacement Fund $120,689.91 Storm Water Improvements Fund $9.41 Capital Improvements Fund $0.00 Bond Redemption Fund $0.00 Street Improvements Fund $74,953.27 Criminal Justice Fund $0.00 Events Board Fund $26,477.87 Hotel/Motel Tax Fund $60,000.00 Drug Fund $0.00 Financing Reserves Fund $0.00 Library Fund $1,712.14 Community Development Grants Fund $0.00 Transportation Benefit District Fund $0.00 Street Fund $241,427.17 Out General Fund $1,858,967.56 Cash and Investment Activity Period: 2020 - March 2020 Fund Activity