Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2019 - April 2019 Monthly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee May 21, 2019 City Council Meeting April 2019 Financial Report Date: May 21, 2019 To: Councilmembers, Mayor Lacy & Department Heads From: Josh DeLay, Finance Director Subject: April 2019 Financial Report This report provides a summary of the City’s overall financial operations through April 30, 2019. 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 April 30, 2019 compared to revenue collections through April 30, 2018, along with the respective dollar and percentage variances for its operating funds. Table 1 April 30, 2019 April 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 1,474,437 1,930,753 (456,316) (23.63%) Street Fund - 101 593,202 297,818 295,383 99.18% Events Board Fund - 117 28,487 47,556 (19,069) (40.10%) Equipment R&R Fund - 501 300,000 250,000 50,000 20.00% Total Revenues - Operating Funds 2,396,125 2,526,127 (130,002) (5.15%) Revenues - Operating Funds CITY OF EAST WENATCHEE Finance Department 271 9th Street NE * East Wenatchee, WA 98802 P: (509) 886-4507 * F: (509) 884-6233 * Email: jdelay@east- wenatchee.com Page 1 of 25 City of East Wenatchee May 21, 2019 City Council Meeting April 2019 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 April 30, 2019 compared to revenue collections through April 30, 2018, along with the respective dollar and percentage variances for its non-operating funds. Page 2 of 25 City of East Wenatchee May 21, 2019 City Council Meeting April 2019 Financial Report Table 2 April 30, 2019 April 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - - - - Trans Benefit District Fund - 105 72,388 77,021 (4,633) (6.02%) Debt Reserve Fund - 110 - - - - Library Fund - 112 - - - - Hotel/Motel Tax Fund - 113 40,397 14,000 26,397 188.55% Drug Fund - 114 444 92 351 380.23% Criminal Justice Fund - 116 9,187 8,910 277 3.10% Bond Redemption Fund - 202 30,000 30,000 - - Street Improvements Fund - 301 108,048 69,585 38,462 55.27% Storm Water Improvements Fund - 308 - 18,022 (18,022) (100.00%) Capital Improvements Fund - 314 63,604 209,414 (145,810) (69.63%) Total Revenues - Non-Operating Funds 324,068 427,045 (102,978) (24.11%) 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 Page 3 of 25 City of East Wenatchee May 21, 2019 City Council Meeting April 2019 Financial Report Revenue Highlights: General Fund revenues are down $456,316, or 23.63%, from last year due to: •$308,562 less sales tax allocation due to other funds needing their allotted sales tax for large purchases and cash flow purposes •$50,545 less combined utility tax receipts for all three major utilities (electric, natural gas and phone) This fund will start receiving a higher percentage of the monthly sales tax allocation, while the other funds receive a lesser percentage, as the year progresses. Street Fund revenues are up $295,383, or 99.18%, from last year due to a larger sales tax allocation this year versus last year at the same point in time. This will even out as the year progresses as this fund receives less of a percentage of the monthly sales tax allocation. Equipment R&R Fund revenues are up $50,000, or 20.00%, from last year due to a larger sales tax allocation this year versus last year at the same point in time. This will even out as the year progresses as this fund receives less of a percentage of the monthly sales tax allocation. Hotel/Motel Tax Fund revenues are up $26,397, or 188.55%, from last year due to an overall increase in hotel/motel taxes, and a decision in 2018 to change the hotel/motel tax allocation between this fund and the Events Fund whose revenues are down $19,069, or 40.10%. Street Improvements Fund revenues are up $38,462, or 55.27%, from last year due to the Public Works Trust Fund Loan associated with 10th Street improvements. Capital Improvements Fund revenues are down $145,810, or 69.63%, from last year due to the timing and receipt of the various taxes and revenues that support this fund. Page 4 of 25 City of East Wenatchee May 21, 2019 City Council Meeting April 2019 Financial Report Table 3 below shows the City’s expenditures through April 30, 2019 compared to expenditures through April 30, 2018, along with respective dollar and percentage variances for its operating funds. Table 3 April 30, 2019 April 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 2,443,772 2,085,431 358,341 17.18% Street Fund - 101 582,992 499,264 83,729 16.77% Events Board Fund - 117 38,501 43,771 (5,270) (12.04%) Equipment R&R Fund - 501 192,775 140,406 52,369 37.30% Total Expenditures - Operating Funds 3,258,040 2,768,872 489,168 17.67% 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 April 30, 2019 compared to expenditures through April 30, 2018, along with respective dollar and percentage variances for its non-operating funds. Page 5 of 25 City of East Wenatchee May 21, 2019 City Council Meeting April 2019 Financial Report Table 4 April 30, 2019 April 30, 2018 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - 382 (382) (100.00%) Trans Benefit District Fund - 105 - - - - Debt Reserve Fund - 110 - - - - Library Fund - 112 1,938 1,642 296 18.04% Hotel/Motel Tax Fund - 113 37,092 - 37,092 - Drug Fund - 114 - - - - Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 173,074 81,061 92,013 113.51% Storm Water Improvements Fund - 308 6,367 3,828 2,539 66.34% Capital Improvements Fund - 314 186,972 47,036 139,935 297.50% Total Expenditures - Non-Operating Funds 405,443 133,949 271,494 202.68% 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 Page 6 of 25 City of East Wenatchee May 21, 2019 City Council Meeting April 2019 Financial Report Expenditure Highlights: General Fund expenditures are up $358,341, or 17.18%, from last year primarily due to the purchase of 1002 N Colorado Ave., and salary and benefit increases. Street Fund expenditures are up $83,729, or 16.77%, from last year due to snow and ice removal overtime, and delayed Department of Transportation utility billings from prior years that we paid this year. Equipment R&R Fund expenditures are up $52,369, or 37.30%, from last year due to the timing of the purchase of replacement vehicles by the Police and Streets Departments. Hotel/Motel Tax Fund expenditures are up $37,092 due to the contributions to the Wenatchee Valley Museum not occurring out of this fund until June of last year. Street Improvements Fund expenditures are up $92,013, or 113.51%, from last year due to the timing and size of projects. Capital Improvements Fund expenditures are up $139,935, or 297.50%, from last year due to Gateway. 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 April 30, 2019. Page 7 of 25 Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $0.00 $19,134.36 $1,000,000.00 1.91 %$980,865.64 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $259,504.60 $602,544.47 $3,270,000.00 18.43 %$2,667,455.53 001-000-000-313-71-00-00 1/10 Sales Tax-Criminal Just $27,818.41 $108,518.14 $277,000.00 39.18 %$168,481.86 001-000-000-316-40-00-00 Electric Utility Tax $40,965.97 $162,216.31 $352,000.00 46.08 %$189,783.69 001-000-000-316-45-00-00 Natural Gas Utility Tax $0.00 $14,938.20 $34,000.00 43.94 %$19,061.80 001-000-000-316-49-00-00 Phone/cellular Utility Tax $15,652.00 $93,810.44 $355,000.00 26.43 %$261,189.56 001-000-000-316-84-00-00 Gambling Tax $0.00 $91,489.71 $302,000.00 30.29 %$210,510.29 001-000-000-316-84-00-01 Gambling Tax Penalties $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Total Taxes $343,940.98 $1,092,651.63 $5,591,500.00 19.54 %$4,498,848.37 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $500.00 $500.00 $500.00 100.00 %$0.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $0.00 $185.00 $800.00 23.13 %$615.00 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $25,737.26 $97,000.00 26.53 %$71,262.74 001-000-000-321-99-00-00 Business Licenses & Permits $7,672.25 $34,983.67 $81,000.00 43.19 %$46,016.33 001-000-000-321-99-05-00 Other Business Lic & Permits $0.00 $660.00 $0.00 ($660.00) 001-000-000-322-10-00-00 Building & Structure Permits $1,949.00 $15,566.35 $63,000.00 24.71 %$47,433.65 001-000-000-322-90-01-00 Gun Permits $754.75 $3,325.00 $6,200.00 53.63 %$2,875.00 001-000-000-322-90-02-00 Sign Permits $72.50 $72.50 $100.00 72.50 %$27.50 Total Licenses and Permits $10,948.50 $81,029.78 $248,600.00 32.59 %$167,570.22 Intergovernmental Revenues 001-000-000-333-16-50-00 Columbia River Drug Task Force $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-000-334-01-20-00 WaState Court Equip Reimb $0.00 $3,493.55 $0.00 ($3,493.55) 001-000-000-334-03-51-03 Tsc - Seatbelt Emphasis Patrols $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-000-334-03-51-04 X-52 Tsc-Speed Limit Emphasis $0.00 $0.00 $2,100.00 0.00 %$2,100.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $2,017.22 $2,017.22 $2,500.00 80.69 %$482.78 001-000-000-334-03-51-12 Tsc - DUI Emphasis Patrol $0.00 $1,148.24 $2,500.00 45.93 %$1,351.76 001-000-000-334-06-95-00 RIVERCOM 911 Funding Assistance $0.00 $0.00 $6,600.00 0.00 %$6,600.00 001-000-000-335-00-91-00 Pud Privilege Tax $0.00 $0.00 $41,000.00 0.00 %$41,000.00 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $7,142.31 $30,000.00 23.81 %$22,857.69 001-000-000-336-06-51-00 DUI - Cities Allocation $497.04 $994.18 $2,100.00 47.34 %$1,105.82 001-000-000-336-06-94-00 Liquor Excise Tax $20,558.50 $37,458.12 $70,000.00 53.51 %$32,541.88 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $27,864.84 $111,500.00 24.99 %$83,635.16 Total Intergovernmental Revenues $23,072.76 $80,118.46 $274,500.00 29.19 %$194,381.54 Charges for Goods and Services 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: 2019 - April 2019 Page 8 of 25 Account Number Title Period Fiscal Budget % of Total Balance 001-000-000-341-33-10-00 Background Check Fees $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-341-35-30-00 Duplicating Services - Court & Police $0.00 $0.00 $900.00 0.00 %$900.00 001-000-000-341-35-31-00 Copy and Duplication Fees - Admin $17.30 $23.20 $200.00 11.60 %$176.80 001-000-000-341-35-33-00 Recording and Filing Fees $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-341-35-35-00 Annual Admin Reimb Fees $0.00 $0.00 $7,700.00 0.00 %$7,700.00 001-000-000-341-96-00-00 Personnel Services $369.60 $1,608.60 $0.00 ($1,608.60) 001-000-000-342-33-00-00 Adult Probation Services $5,522.32 $19,695.40 $80,000.00 24.62 %$60,304.60 001-000-000-342-36-00-00 Housing of Prisoners $1,850.45 $6,541.60 $27,000.00 24.23 %$20,458.40 001-000-000-342-40-00-01 Fire Marshall Inspection Ser $0.00 $302.00 $5,500.00 5.49 %$5,198.00 001-000-000-345-83-00-00 Plan Checking Fees $904.79 $9,477.22 $32,000.00 29.62 %$22,522.78 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-000-345-86-00-00 Sepa Permits $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-345-89-00-00 Planning & Development Fees $0.00 $6,068.00 $4,500.00 134.84 %($1,568.00) 001-000-000-349-17-01-00 Cafeteria Plan $616.66 $616.66 $0.00 ($616.66) Total Charges for Goods and Services $9,281.12 $44,332.68 $160,200.00 27.67 %$115,867.32 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $16,715.93 $55,945.94 $211,000.00 26.51 %$155,054.06 001-000-000-357-33-00-00 Public Defender Costs $2,697.49 $9,037.24 $29,000.00 31.16 %$19,962.76 001-000-000-357-35-00-00 Restitution $15.00 $70.00 $0.00 ($70.00) Total Fines and Penalties $19,428.42 $65,053.18 $240,000.00 27.11 %$174,946.82 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $10,863.08 $45,867.44 $85,000.00 53.96 %$39,132.56 001-000-000-361-40-00-00 Sales Tax Interest $519.19 $2,336.37 $2,800.00 83.44 %$463.63 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,195.00 $3,261.96 $14,400.00 22.65 %$11,138.04 001-000-000-369-20-00-00 Unclaimed Property $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-369-91-50-00 Miscellaneous Revenue $508.46 $847.39 $6,000.00 14.12 %$5,152.61 Total Miscellaneous Revenues $13,085.73 $52,313.16 $108,300.00 48.30 %$55,986.84 Other Increases in Fund Resources 001-000-000-389-30-00-03 Fireworks - Cleaning Deposit $2,500.00 $2,500.00 $2,200.00 113.64 %($300.00) 001-000-000-389-30-00-04 Fireworks - Dcfd Remittance $0.00 $0.00 $200.00 0.00 %$200.00 001-000-000-389-30-00-05 Crime Victim Assessment $313.19 $1,056.91 $3,900.00 27.10 %$2,843.09 001-000-000-389-30-00-10 State Surcharge $144.50 $314.00 $800.00 39.25 %$486.00 001-000-000-389-30-00-15 State Share Weapons Permit Fee $299.75 $2,217.75 $10,000.00 22.18 %$7,782.25 001-000-000-389-30-00-20 Court Remittance--State $16,023.67 $52,796.75 $218,000.00 24.22 %$165,203.25 Total Other Increases in Fund Resources $19,281.11 $58,885.41 $235,100.00 25.05 %$176,214.59 Other Financing Sources 001-000-000-395-10-00-00 Proceeds-Disposition of Assets $0.00 $52.80 $0.00 ($52.80) Total Other Financing Sources $0.00 $52.80 $0.00 ($52.80) Total General Fund $439,038.62 $1,474,437.10 $6,858,200.00 21.50 %$5,383,762.90 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $130,821.65 $130,821.65 $500,000.00 26.16 %$369,178.35 101-000-000-313-11-00-00 Sales And Use Tax $0.00 $317,572.02 $350,000.00 90.73 %$32,427.98 101-000-000-322-40-00-00 Street Permits $1,244.70 $1,314.70 $3,700.00 35.53 %$2,385.30 101-000-000-336-00-71-00 Multimodal Transpo City $0.00 $4,732.15 $18,000.00 26.29 %$13,267.85 Page 9 of 25 Account Number Title Period Fiscal Budget % of Total Balance 101-000-000-336-00-87-00 Street Fuel Excise Tax $18,692.17 $82,939.05 $299,000.00 27.74 %$216,060.95 101-000-000-336-00-87-05 MVA Transport Cities $0.00 $4,140.67 $9,700.00 42.69 %$5,559.33 101-000-000-343-13-00-00 SWA Administrative Services $424.26 $4,497.09 $27,500.00 16.35 %$23,002.91 101-000-000-343-13-00-90 SWA NPDES Reimbursement $3,215.08 $15,629.01 $240,000.00 6.51 %$224,370.99 101-000-000-343-13-00-95 DOE Capacity Grant - SWU $0.00 $31,443.49 $33,149.00 94.86 %$1,705.51 101-000-000-369-91-01-05 Miscellaneous Revenue $0.00 $111.85 $100.00 111.85 %($11.85) Total Street Fund $154,397.86 $593,201.68 $1,481,149.00 40.05 %$887,947.32 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $0.00 $153,841.00 0.00 %$153,841.00 Total Community Development Grants Fund $0.00 $0.00 $153,841.00 0.00 %$153,841.00 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fee Revenue $23,839.20 $72,388.20 $241,000.00 30.04 %$168,611.80 Total Transportation Benefit District Fund $23,839.20 $72,388.20 $241,000.00 30.04 %$168,611.80 Financing Reserves Fund 110-000-000-311-10-00-00 Property Tax $0.00 $0.00 $165,000.00 0.00 %$165,000.00 Total Financing Reserves Fund $0.00 $0.00 $165,000.00 0.00 %$165,000.00 Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $0.00 $6,500.00 0.00 %$6,500.00 Total Library Fund $0.00 $0.00 $6,500.00 0.00 %$6,500.00 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 HM Tax - Allocated $3,982.93 $20,198.60 $56,850.00 35.53 %$36,651.40 113-000-000-313-31-04-00 H/M Tax Allocated $3,982.93 $20,198.60 $56,850.00 35.53 %$36,651.40 Total Hotel/Motel Tax Fund $7,965.86 $40,397.20 $113,700.00 35.53 %$73,302.80 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $3.27 $16.62 $150.00 11.08 %$133.38 114-000-000-369-30-00-00 Confiscated/forfeited Property $427.26 $427.26 $0.00 ($427.26) Total Drug Fund $430.53 $443.88 $150.00 295.92 %($293.88) Criminal Justice Fund 116-000-000-336-06-21-00 Crim Justice - Population $996.88 $1,993.96 $3,700.00 53.89 %$1,706.04 116-000-000-336-06-26-00 Crim Just - Special Programs $3,595.95 $7,192.62 $13,400.00 53.68 %$6,207.38 Total Criminal Justice Fund $4,592.83 $9,186.58 $17,100.00 53.72 %$7,913.42 Events Board Fund 117-000-100-313-31-00-00 H/M Tax - Events $3,982.96 $20,198.73 $60,000.00 33.66 %$39,801.27 117-000-200-347-40-02-01 Easter Egg Hunt Admission Fees $1,427.85 $1,427.85 $1,600.00 89.24 %$172.15 117-000-300-347-40-12-02 Classy Chassis Parade/car Show $4,295.00 $4,810.00 $10,000.00 48.10 %$5,190.00 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $200.00 $250.00 $0.00 ($250.00) 117-000-300-347-90-00-12 Classy Chassis Sponsorships $500.00 $500.00 $9,000.00 5.56 %$8,500.00 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $0.00 $1,650.00 0.00 %$1,650.00 117-000-400-347-40-11-03 Wings & Wheels Car Show Registration $0.00 $0.00 $5,500.00 0.00 %$5,500.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $0.00 $0.00 $300.00 0.00 %$300.00 117-000-400-347-90-00-01 Wings & Wheels Donations $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-347-90-00-11 Wings & Wheels Sponsorships $500.00 $1,300.00 $6,500.00 20.00 %$5,200.00 117-000-400-347-90-00-13 Schedule of Events Brochure $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Page 10 of 25 Account Number Title Period Fiscal Budget % of Total Balance 117-000-450-347-90-00-12 PkwyPile-up Car Show Sponsorship $0.00 $0.00 $450.00 0.00 %$450.00 117-000-450-347-90-00-15 PkwyPile-up Car Show Misc Revenue $0.00 $0.00 $270.00 0.00 %$270.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 $10,905.81 $28,486.58 $103,270.00 27.58 %$74,783.42 Bond Redemption Fund 202-000-000-311-10-00-00 Property Tax $5,786.94 $30,000.00 $30,000.00 100.00 %$0.00 Total Bond Redemption Fund $5,786.94 $30,000.00 $30,000.00 100.00 %$0.00 Street Improvements Fund 301-000-000-311-10-00-00 Property Tax $0.00 $0.00 $17,678.00 0.00 %$17,678.00 301-000-000-334-03-60-01 SRTS - 5th St NE: Sterling $0.00 $0.00 $50,000.00 0.00 %$50,000.00 301-000-000-334-03-60-02 SRTS - 5th St NE: Kenroy $0.00 $0.00 $30,000.00 0.00 %$30,000.00 301-000-000-334-03-80-05 TIB Grant Road/Eastmont Ave Intersection Repair $0.00 $0.00 $97,000.00 0.00 %$97,000.00 301-000-000-334-03-80-07 TIB - S. Kentucky & 5th ST. NE $3,942.20 $3,942.20 $27,000.00 14.60 %$23,057.80 301-000-000-334-03-80-08 TIB 3rd St SE/Highline Drive Roundabout $0.00 $0.00 $85,000.00 0.00 %$85,000.00 301-000-000-334-03-80-11 TIB VMP/15th St Overlay $0.00 $0.00 $659,000.00 0.00 %$659,000.00 301-000-000-334-04-20-02 PWTFL - 10th Street Design $104,105.30 $104,105.30 $750,000.00 13.88 %$645,894.70 301-000-000-397-41-10-05 Transfer In-TBD Fund 105 Proj Funding $0.00 $0.00 $360,000.00 0.00 %$360,000.00 Total Street Improvements Fund $108,047.50 $108,047.50 $2,075,678.00 5.21 %$1,967,630.50 Storm Water Improvements Fund 308-000-000-334-03-10-00 State Ecology Grant $0.00 $0.00 $37,500.00 0.00 %$37,500.00 308-000-000-343-13-00-00 GEWSWU 10th St Design $0.00 $0.00 $225,000.00 0.00 %$225,000.00 308-000-000-343-13-00-30 SWA Small Improvement Projects $0.00 $0.00 $100,000.00 0.00 %$100,000.00 308-000-000-343-13-00-83 DOE Grant 19th St. NW Design $0.00 $0.00 $250,000.00 0.00 %$250,000.00 Total Storm Water Improvements Fund $0.00 $0.00 $612,500.00 0.00 %$612,500.00 Capital Improvements Fund 314-000-000-311-10-00-00 Real and Personal Property Taxes $0.00 $0.00 $100,000.00 0.00 %$100,000.00 314-000-000-318-34-00-00 Real Estate Excise Tax $26,158.32 $63,604.38 $350,000.00 18.17 %$286,395.62 314-000-000-333-10-00-00 Douglas County Regional Share $0.00 $0.00 $188,000.00 0.00 %$188,000.00 Total Capital Improvements Fund $26,158.32 $63,604.38 $638,000.00 9.97 %$574,395.62 Equipment Purchase, Repair & Replacement Fund 501-000-000-313-11-00-10 Sales & Use Tax - Police $0.00 $100,000.00 $150,000.00 66.67 %$50,000.00 501-000-000-313-11-00-20 Sales & Use Tax - Streets $0.00 $200,000.00 $300,000.00 66.67 %$100,000.00 Total Equipment Purchase, Repair & Replacement Fund $0.00 $300,000.00 $450,000.00 66.67 %$150,000.00 Grand Totals $781,163.47 $2,720,193.10 $12,946,088.00 21.01 %$10,225,894.90 Page 11 of 25 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $439,038.62 $1,474,437.10 $6,858,200.00 21.50 %$5,383,762.90 101-000-000-000-00-00-00 Street Fund $154,397.86 $593,201.68 $1,481,149.00 40.05 %$887,947.32 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $153,841.00 0.00 %$153,841.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $23,839.20 $72,388.20 $241,000.00 30.04 %$168,611.80 110-000-000-000-00-00-00 Financing Reserves Fund $0.00 $0.00 $165,000.00 0.00 %$165,000.00 112-000-000-000-00-00-00 Library Fund $0.00 $0.00 $6,500.00 0.00 %$6,500.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $7,965.86 $40,397.20 $113,700.00 35.53 %$73,302.80 114-000-000-000-00-00-00 Drug Fund $430.53 $443.88 $150.00 295.92 %($293.88) 116-000-000-000-00-00-00 Criminal Justice Fund $4,592.83 $9,186.58 $17,100.00 53.72 %$7,913.42 117-000-000-000-00-00-00 Events Board Fund $10,905.81 $28,486.58 $103,270.00 27.58 %$74,783.42 202-000-000-000-00-00-00 Bond Redemption Fund $5,786.94 $30,000.00 $30,000.00 100.00 %$0.00 301-000-000-000-00-00-00 Street Improvements Fund $108,047.50 $108,047.50 $2,075,678.00 5.21 %$1,967,630.50 308-000-000-000-00-00-00 Storm Water Improvements Fund $0.00 $0.00 $612,500.00 0.00 %$612,500.00 314-000-000-000-00-00-00 Capital Improvements Fund $26,158.32 $63,604.38 $638,000.00 9.97 %$574,395.62 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $0.00 $300,000.00 $450,000.00 66.67 %$150,000.00 Grand Totals $781,163.47 $2,720,193.10 $12,946,088.00 21.01 %$10,225,894.90 Page 12 of 25 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 $0.00 $0.00 $1,200.00 0.00 %$1,200.00 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 $67.42 $1,012.81 $2,500.00 40.51 %$1,487.19 001-000-001-518-93-49-00 City Theme $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-001-521-10-29-00 Leoff 1 Ins Premiums/misc $2,082.00 $11,078.16 $34,000.00 32.58 %$22,921.84 001-000-001-528-70-40-00 River Com $28,242.67 $112,970.68 $340,000.00 33.23 %$227,029.32 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 $13,265.00 $13,265.00 100.00 %$0.00 001-000-001-558-70-40-00 Contributions - Region $10,000.00 $15,000.00 $25,000.00 60.00 %$10,000.00 001-000-001-558-70-41-00 Ncw Economic Development Dist $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 $0.00 $1,500.00 0.00 %$1,500.00 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $0.00 $0.00 $360.00 0.00 %$360.00 001-000-001-558-70-41-10 Spirit of Wenatchee Miss Veedol $3,000.00 $3,000.00 $3,000.00 100.00 %$0.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $772.26 $3,600.00 21.45 %$2,827.74 001-000-001-588-80-00-00 Prior Year Corrections $0.00 $1,766.00 $0.00 ($1,766.00) 001-000-001-594-58-60-01 City Land Purchase - 1002 Colorado Ave $0.00 $240,186.69 $0.00 ($240,186.69) Total General Government $49,518.33 $417,430.32 $500,490.00 83.40 %$83,059.68 Legislative 001-000-110-511-60-10-00 Salaries $15,797.06 $59,088.40 $165,000.00 35.81 %$105,911.60 001-000-110-511-60-20-00 Benefits $5,116.22 $18,338.65 $95,000.00 19.30 %$76,661.35 001-000-110-511-60-21-50 Public Defender $8,100.00 $32,900.00 $96,000.00 34.27 %$63,100.00 001-000-110-511-60-30-00 Public Defender Conflicts $900.00 $1,627.50 $6,000.00 27.13 %$4,372.50 001-000-110-511-60-31-00 Office Supplies $0.00 $0.00 $400.00 0.00 %$400.00 001-000-110-511-60-31-05 Newsletter Printing & Mailing $0.00 $1,990.24 $11,000.00 18.09 %$9,009.76 001-000-110-511-60-31-10 Public Records Expenses $0.00 $25.23 $90.00 28.03 %$64.77 001-000-110-511-60-40-00 Training $125.00 $999.47 $4,000.00 24.99 %$3,000.53 001-000-110-511-60-41-00 Professional Services $0.00 $10,630.00 $16,000.00 66.44 %$5,370.00 001-000-110-511-60-41-20 Awc Annual Membership Fee $0.00 $9,703.00 $9,703.00 100.00 %$0.00 001-000-110-511-60-42-01 Telephone $0.00 $587.82 $1,800.00 32.66 %$1,212.18 001-000-110-511-60-43-00 Travel $0.00 $0.00 $2,100.00 0.00 %$2,100.00 001-000-110-511-60-43-01 Travel - Misawa $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-110-511-60-44-00 Advertising $0.00 $220.56 $6,500.00 3.39 %$6,279.44 001-000-110-511-60-45-00 Election Costs - Registered Voters $0.00 $19,902.02 $21,000.00 94.77 %$1,097.98 001-000-110-511-60-46-00 Insurance $25.00 $1,070.27 $11,000.00 9.73 %$9,929.73 001-000-110-511-60-47-00 Background Check Costs $12.00 $84.00 $250.00 33.60 %$166.00 Expenditure Starting Account Number: 001-000-001-515-10-40-00 Professional Services - Legal Ending Account Number: 501-001-000-508-80-00-00 Ending EPM&R Fund Balance - Unreserved Period: 2019 - April 2019 Page 13 of 25 Account Number Title Period Fiscal Budget % of Total Balance 001-000-110-511-60-49-00 Miscellaneous $751.07 $1,319.81 $5,000.00 26.40 %$3,680.19 Total Legislative $30,826.35 $158,486.97 $455,843.00 34.77 %$297,356.03 Municipal Court 001-000-120-512-50-10-00 Salaries $15,100.68 $60,286.00 $182,000.00 33.12 %$121,714.00 001-000-120-512-50-12-00 Salaries - Probation Svcs $4,404.82 $17,619.28 $53,000.00 33.24 %$35,380.72 001-000-120-512-50-20-00 Benefits $5,354.41 $21,356.83 $66,000.00 32.36 %$44,643.17 001-000-120-512-50-22-00 Benefits - Probation Svcs $2,956.71 $11,791.47 $36,000.00 32.75 %$24,208.53 001-000-120-512-50-31-00 Office Supplies $0.00 $531.26 $3,300.00 16.10 %$2,768.74 001-000-120-512-50-40-00 Training $150.00 $1,015.00 $1,500.00 67.67 %$485.00 001-000-120-512-50-43-00 Travel $0.00 $1,803.56 $4,000.00 45.09 %$2,196.44 001-000-120-512-50-46-00 Insurance $0.00 $176.89 $12,600.00 1.40 %$12,423.11 001-000-120-512-50-49-00 Miscellaneous $0.00 $41.09 $1,200.00 3.42 %$1,158.91 001-000-120-512-50-49-01 Interpreting $280.00 $280.00 $5,000.00 5.60 %$4,720.00 001-000-120-512-50-49-02 Judge Protems $225.00 $900.00 $4,000.00 22.50 %$3,100.00 001-000-120-512-50-49-03 Witness Fees $0.00 $75.24 $500.00 15.05 %$424.76 001-000-120-512-50-49-04 Juror Fees $0.00 $656.44 $2,000.00 32.82 %$1,343.56 001-000-120-512-50-49-09 Security $362.50 $1,418.75 $6,000.00 23.65 %$4,581.25 001-000-120-594-12-60-00 Capital Outlay $255.39 $20,114.57 $21,000.00 95.78 %$885.43 Total Municipal Court $29,089.51 $138,066.38 $398,100.00 34.68 %$260,033.62 City Clerk 001-000-140-514-20-10-00 Salaries $6,679.87 $27,340.83 $76,000.00 35.97 %$48,659.17 001-000-140-514-20-20-00 Benefits $3,245.66 $12,944.02 $39,000.00 33.19 %$26,055.98 001-000-140-514-20-31-00 Office Supplies $0.00 $3.29 $3,000.00 0.11 %$2,996.71 001-000-140-514-20-31-01 Central Stores $1,220.60 $2,258.55 $4,000.00 56.46 %$1,741.45 001-000-140-514-20-40-00 Training $175.00 $245.00 $2,000.00 12.25 %$1,755.00 001-000-140-514-20-41-00 Membership Dues & Publications $14.06 $212.18 $1,200.00 17.68 %$987.82 001-000-140-514-20-43-00 Travel $0.00 $1,317.80 $2,500.00 52.71 %$1,182.20 001-000-140-514-20-44-00 Advertising $0.00 $173.40 $2,000.00 8.67 %$1,826.60 001-000-140-514-20-46-00 Insurance $0.00 $38.68 $8,000.00 0.48 %$7,961.32 001-000-140-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $500.00 0.00 %$500.00 001-000-140-514-20-49-00 Miscellaneous $0.00 $1.78 $750.00 0.24 %$748.22 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 $502.48 $502.48 $2,100.00 23.93 %$1,597.52 Total City Clerk $11,837.67 $45,038.01 $142,050.00 31.71 %$97,011.99 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $106.88 $2,161.73 $14,000.00 15.44 %$11,838.27 001-000-141-514-20-42-01 Telephone Line Charges $714.31 $4,455.41 $13,000.00 34.27 %$8,544.59 001-000-141-514-20-42-03 Postage $0.00 $0.00 $8,000.00 0.00 %$8,000.00 001-000-141-514-20-48-00 Repairs & Maintenance $1,009.12 $1,696.87 $1,500.00 113.12 %($196.87) 001-000-141-514-20-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 Total Internal Services $1,830.31 $8,314.01 $37,000.00 22.47 %$28,685.99 Finance 001-000-142-514-20-10-00 Salaries $14,263.27 $56,565.58 $174,000.00 32.51 %$117,434.42 001-000-142-514-20-20-00 Benefits $6,291.17 $25,299.23 $80,000.00 31.62 %$54,700.77 001-000-142-514-20-31-00 Office Supplies $330.96 $374.98 $1,700.00 22.06 %$1,325.02 Page 14 of 25 Account Number Title Period Fiscal Budget % of Total Balance 001-000-142-514-20-43-00 Travel $51.97 $51.97 $600.00 8.66 %$548.03 001-000-142-514-20-46-00 Insurance $0.00 $37.77 $8,000.00 0.47 %$7,962.23 001-000-142-514-20-49-00 Miscellaneous $5.95 $5.95 $400.00 1.49 %$394.05 001-000-142-514-23-20-00 Budgeting, Accting, & Auditing $0.00 $0.00 $22,000.00 0.00 %$22,000.00 001-000-142-514-25-30-00 Bank Charges & Fees $348.49 $1,155.32 $4,000.00 28.88 %$2,844.68 001-000-142-514-40-20-00 Training $0.00 $250.00 $2,000.00 12.50 %$1,750.00 Total Finance $21,291.81 $83,740.80 $292,700.00 28.61 %$208,959.20 Information Technology 001-000-145-514-00-10-00 IT Salaries $7,586.00 $22,758.00 $92,000.00 24.74 %$69,242.00 001-000-145-514-00-20-00 IT Benefits $3,661.69 $10,949.07 $36,000.00 30.41 %$25,050.93 001-000-145-514-00-40-00 Memberships $0.00 $75.00 $0.00 ($75.00) 001-000-145-514-10-10-00 IT Contractor $0.00 $2,671.46 $0.00 ($2,671.46) 001-000-145-514-20-31-00 Supplies $62.29 $307.82 $0.00 ($307.82) 001-000-145-514-20-40-00 Network Services $6,751.14 $13,722.47 $0.00 ($13,722.47) 001-000-145-514-20-40-05 Disaster Backup System Support $0.00 $0.00 $9,000.00 0.00 %$9,000.00 001-000-145-514-20-40-10 Annual Fee - ESRI GIS System License $0.00 $0.00 $1,100.00 0.00 %$1,100.00 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,626.97 $6,000.00 93.78 %$373.03 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 $7,526.01 $7,000.00 107.51 %($526.01) 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 $8,500.00 0.00 %$8,500.00 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $3,570.60 $3,570.60 $8,000.00 44.63 %$4,429.40 001-000-145-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-145-514-20-49-00 Miscellaneous $32.44 $174.82 $300.00 58.27 %$125.18 001-000-145-594-14-60-20 Capital - Cmptr Software Admin $1,194.36 $1,317.17 $28,000.00 4.70 %$26,682.83 001-000-145-594-14-60-25 Capital - Cmptr Hdwe Admin $30.29 $2,508.47 $25,000.00 10.03 %$22,491.53 001-000-145-594-14-60-27 Capital - Cmptr Equip Police $288.76 $710.74 $25,000.00 2.84 %$24,289.26 001-000-145-594-14-60-35 Capital - Cmptr Equip Admin $154.07 $789.84 $6,500.00 12.15 %$5,710.16 001-000-145-594-14-60-40 Capital - Cmptr Sftwr Police $748.12 $748.12 $1,500.00 49.87 %$751.88 Total Information Technology $24,079.76 $73,456.56 $284,045.00 25.86 %$210,588.44 Legal 001-000-151-515-31-10-00 Salaries $11,658.98 $46,941.22 $139,000.00 33.77 %$92,058.78 001-000-151-515-31-20-00 Benefits $5,328.03 $21,475.78 $65,000.00 33.04 %$43,524.22 001-000-151-515-31-20-10 Training $0.00 $35.00 $1,000.00 3.50 %$965.00 001-000-151-515-31-25-00 Professional Services $0.00 $0.00 $2,500.00 0.00 %$2,500.00 001-000-151-515-31-25-10 Licensing $0.00 $0.00 $500.00 0.00 %$500.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-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 $31.37 $11,000.00 0.29 %$10,968.63 001-000-151-515-31-49-00 Miscellaneous $2,692.69 $2,692.69 $5,000.00 53.85 %$2,307.31 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $500.00 0.00 %$500.00 Page 15 of 25 Account Number Title Period Fiscal Budget % of Total Balance 001-000-151-596-00-60-00 Capital Outlay $0.00 $0.00 $500.00 0.00 %$500.00 Total Legal $19,679.70 $71,176.06 $227,300.00 31.31 %$156,123.94 Civil Service 001-000-160-521-10-10-00 Salaries $520.00 $1,040.00 $3,120.00 33.33 %$2,080.00 001-000-160-521-10-46-00 Insurance $0.00 $20.92 $6,500.00 0.32 %$6,479.08 001-000-160-521-10-49-00 Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Civil Service $520.00 $1,060.92 $9,720.00 10.91 %$8,659.08 Central Services 001-000-180-518-30-31-00 Office Supplies $30.83 $30.83 $0.00 ($30.83) 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $69.41 $395.34 $2,000.00 19.77 %$1,604.66 001-000-180-518-30-35-00 Small Tools & Equipment $0.00 $84.01 $10,000.00 0.84 %$9,915.99 001-000-180-518-30-41-00 Professional Services $3,320.25 $4,260.33 $20,000.00 21.30 %$15,739.67 001-000-180-518-30-41-01 Contracted Custodial Services $1,908.30 $8,122.73 $24,000.00 33.84 %$15,877.27 001-000-180-518-30-41-05 Security Services $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-180-518-30-46-00 Insurance $0.00 $76.09 $41,000.00 0.19 %$40,923.91 001-000-180-518-30-47-00 Utilities $2,918.16 $10,200.57 $25,000.00 40.80 %$14,799.43 001-000-180-518-30-48-00 Repairs & Maintenance $0.00 $5,681.89 $12,000.00 47.35 %$6,318.11 001-000-180-518-30-49-00 Miscellaneous $0.00 $19.47 $2,000.00 0.97 %$1,980.53 001-000-180-518-30-49-01 Landscaping $211.51 $211.51 $12,000.00 1.76 %$11,788.49 001-000-180-518-61-41-00 Judgements & Settlements $0.00 $0.00 $18,000.00 0.00 %$18,000.00 001-000-180-518-92-20-00 Ancillary (interfund maintenance)$2.50 $3,273.82 $6,000.00 54.56 %$2,726.18 001-000-180-594-18-60-00 Capital Outlay $3,667.86 $8,488.93 $10,000.00 84.89 %$1,511.07 Total Central Services $12,128.82 $40,845.52 $184,000.00 22.20 %$143,154.48 Law Enforcement 001-000-210-521-10-10-00 Salaries $169,961.65 $690,677.99 $2,100,000.00 32.89 %$1,409,322.01 001-000-210-521-10-10-02 Overtime Salaries $16,618.07 $55,755.16 $150,000.00 37.17 %$94,244.84 001-000-210-521-10-10-03 Overtime Salaries-Traf Control $2,122.57 $2,422.87 $8,000.00 30.29 %$5,577.13 001-000-210-521-10-20-00 Benefits $65,996.58 $254,273.79 $800,000.00 31.78 %$545,726.21 001-000-210-521-10-20-01 Clothing Allowance $600.00 $3,576.47 $15,600.00 22.93 %$12,023.53 001-000-210-521-10-31-00 Office Supplies $658.79 $3,535.18 $8,000.00 44.19 %$4,464.82 001-000-210-521-10-31-05 Office Machine Costs $289.12 $586.34 $5,000.00 11.73 %$4,413.66 001-000-210-521-10-32-00 Fuel Consumed $4,247.16 $11,937.73 $45,000.00 26.53 %$33,062.27 001-000-210-521-10-35-00 Small Tools & Equipment $1,396.11 $7,330.86 $13,000.00 56.39 %$5,669.14 001-000-210-521-10-35-02 Waspc Traffic Safety Grant $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-210-521-10-35-05 Bulletproof Vests $997.60 $997.60 $4,000.00 24.94 %$3,002.40 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 $2,700.30 $5,374.65 $14,000.00 38.39 %$8,625.35 001-000-210-521-10-42-01 Telephone $1,857.23 $5,608.38 $28,000.00 20.03 %$22,391.62 001-000-210-521-10-42-03 Postage $120.29 $302.37 $1,200.00 25.20 %$897.63 001-000-210-521-10-43-00 Travel $3,000.30 $8,650.35 $22,000.00 39.32 %$13,349.65 001-000-210-521-10-46-00 Insurance $0.00 $4,095.55 $72,000.00 5.69 %$67,904.45 001-000-210-521-10-48-00 Repairs & Maintenance $188.92 $957.58 $8,000.00 11.97 %$7,042.42 001-000-210-521-10-49-00 Miscellaneous $535.59 $706.66 $5,500.00 12.85 %$4,793.34 001-000-210-521-10-49-01 Reserves $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-521-10-49-02 Dry Cleaning Services $84.94 $132.01 $1,500.00 8.80 %$1,367.99 Page 16 of 25 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-30-40-00 Crime Prevention $0.00 $0.00 $750.00 0.00 %$750.00 001-000-210-521-40-22-00 Training-Police Chief $0.00 $180.00 $1,000.00 18.00 %$820.00 001-000-210-521-40-25-00 Training--Officers $1,300.00 $2,070.00 $8,000.00 25.88 %$5,930.00 001-000-210-521-40-27-00 Training--Office Staff $0.00 $500.00 $800.00 62.50 %$300.00 001-000-210-521-40-30-00 Training - Recruits-Academy $0.00 $0.00 $9,600.00 0.00 %$9,600.00 001-000-210-521-50-10-00 Ancillary (interfund vehicle maintenance) $1,425.22 $1,425.22 $2,400.00 59.38 %$974.78 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 $15,894.56 $37,461.49 $42,000.00 89.19 %$4,538.51 Total Law Enforcement $289,995.00 $1,098,558.25 $3,372,850.00 32.57 %$2,274,291.75 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $78,962.00 $78,962.00 $302,000.00 26.15 %$223,038.00 001-000-230-523-60-20-00 Medical Care For Prisoners $0.00 $2,839.62 $11,000.00 25.81 %$8,160.38 001-000-230-527-60-30-00 Juvenile Detention $0.00 $0.00 $8,000.00 0.00 %$8,000.00 Total Jail Services $78,962.00 $81,801.62 $321,000.00 25.48 %$239,198.38 Public Works 001-000-315-542-10-10-00 Salaries $6,884.40 $27,468.00 $83,000.00 33.09 %$55,532.00 001-000-315-542-10-20-00 Benefits $3,349.89 $13,301.61 $42,000.00 31.67 %$28,698.39 001-000-315-542-10-31-00 Office Supplies $0.00 $50.93 $750.00 6.79 %$699.07 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-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 $29.10 $10,500.00 0.28 %$10,470.90 001-000-315-542-10-49-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.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-05 Registrations $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-49-10 Memberships $0.00 $124.00 $300.00 41.33 %$176.00 001-000-315-544-20-45-00 Engineering Support Services $0.00 $984.51 $10,000.00 9.85 %$9,015.49 Total Public Works $10,234.29 $41,958.15 $152,050.00 27.59 %$110,091.85 Planning 001-000-580-558-60-10-00 Salaries $14,142.56 $56,487.76 $172,000.00 32.84 %$115,512.24 001-000-580-558-60-20-00 Benefits $5,024.17 $20,003.29 $62,000.00 32.26 %$41,996.71 001-000-580-558-60-31-00 Office Supplies $80.38 $80.38 $900.00 8.93 %$819.62 001-000-580-558-60-32-00 Fuel Consumed $39.46 $62.85 $200.00 31.43 %$137.15 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 $200.00 $200.00 $1,500.00 13.33 %$1,300.00 001-000-580-558-60-41-00 Professional Services $900.00 $900.00 $12,000.00 7.50 %$11,100.00 001-000-580-558-60-41-01 Hearings Examiner $0.00 $0.00 $450.00 0.00 %$450.00 001-000-580-558-60-41-02 Engineer/architect Services $225.00 $792.50 $1,400.00 56.61 %$607.50 001-000-580-558-60-43-00 Travel $724.24 $734.24 $1,500.00 48.95 %$765.76 001-000-580-558-60-44-00 Advertising $0.00 $1,052.19 $2,400.00 43.84 %$1,347.81 001-000-580-558-60-46-00 Insurance $0.00 $44.13 $10,400.00 0.42 %$10,355.87 001-000-580-558-60-48-00 Repairs & Maintenance $43.28 $43.28 $100.00 43.28 %$56.72 001-000-580-558-60-49-00 Miscellaneous $100.00 $889.00 $2,000.00 44.45 %$1,111.00 Total Planning $21,479.09 $81,289.62 $266,950.00 30.45 %$185,660.38 Code Compliance Page 17 of 25 Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-10-00 Salaries $8,453.77 $33,815.08 $104,000.00 32.51 %$70,184.92 001-000-590-558-50-20-00 Benefits $4,284.68 $17,073.44 $53,000.00 32.21 %$35,926.56 001-000-590-558-50-31-00 Office Supplies $0.00 $0.00 $200.00 0.00 %$200.00 001-000-590-558-50-32-00 Fuel Consumed $39.04 $111.48 $350.00 31.85 %$238.52 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 $5,268.66 $5,268.66 $20,664.00 25.50 %$15,395.34 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 $24.56 $7,900.00 0.31 %$7,875.44 001-000-590-558-50-49-00 Miscellaneous $0.00 $95.00 $300.00 31.67 %$205.00 Total Code Compliance $18,046.15 $56,388.22 $217,289.00 25.95 %$160,900.78 Other Expenditures 001-001-000-589-30-00-03 Fireworks-Cleaning Deposit Ref $0.00 $0.00 $900.00 0.00 %$900.00 001-001-000-589-30-00-04 Fireworks - Dcfd Remittance $0.00 $0.00 $200.00 0.00 %$200.00 001-001-000-589-30-00-05 County Share of Crime Victims $0.00 $800.74 $4,200.00 19.07 %$3,399.26 001-001-000-589-30-00-10 Remittance: State Bldg Code Surcharge $163.00 $138.00 $400.00 34.50 %$262.00 001-001-000-589-30-00-15 State Share of Permits & Licenses $924.50 $3,138.75 $12,000.00 26.16 %$8,861.25 001-001-000-589-30-00-20 Court Remittances $12,480.42 $42,083.49 $220,000.00 19.13 %$177,916.51 Total Other Expenditures $13,567.92 $46,160.98 $237,700.00 19.42 %$191,539.02 Total General Fund $633,086.71 $2,443,772.39 $7,099,087.00 34.42 %$4,655,314.61 Street Fund Storm Water Administration 101-000-311-542-42-10-00 SWU Administration - Salaries $295.48 $875.21 $15,000.00 5.83 %$14,124.79 101-000-311-542-42-20-00 SWU Administration - Benefits $95.73 $452.97 $5,000.00 9.06 %$4,547.03 101-000-311-542-42-31-00 SWU Administration - DC Annual Billing Fee $0.00 $0.00 $7,500.00 0.00 %$7,500.00 Total Storm Water Administration $391.21 $1,328.18 $27,500.00 4.83 %$26,171.82 NPDES 101-000-313-542-42-10-00 NPDES Maintenance Salaries $3,412.66 $8,542.11 $75,000.00 11.39 %$66,457.89 101-000-313-542-42-10-10 NPDES Sweeping Salaries $1,847.83 $5,735.70 $16,000.00 35.85 %$10,264.30 101-000-313-542-42-20-00 NPDES Maintenance Benefits $1,819.39 $9,133.58 $45,000.00 20.30 %$35,866.42 101-000-313-542-42-20-10 NPDES Sweeping Benefits $911.26 $4,558.60 $8,000.00 56.98 %$3,441.40 101-000-313-542-42-30-00 NPDES Supplies $1,826.52 $5,122.66 $63,149.00 8.11 %$58,026.34 101-000-313-542-42-31-10 NPDES GIS System License $0.00 $0.00 $1,100.00 0.00 %$1,100.00 101-000-313-542-42-35-00 NPDES Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 101-000-313-542-42-40-00 NPDES Training $377.64 $1,280.14 $9,400.00 13.62 %$8,119.86 101-000-313-542-42-40-01 NPDES DOE Annual Permit $0.00 $2,413.23 $5,000.00 48.26 %$2,586.77 101-000-313-542-42-40-02 NPDES Equipment Rental $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-313-542-42-40-03 NPDES Intergovernmental Services $0.00 $0.00 $30,000.00 0.00 %$30,000.00 101-000-313-542-42-41-00 NPDES Effectiveness Studies $0.00 $0.00 $8,500.00 0.00 %$8,500.00 101-000-313-542-42-45-00 NPDES Travel $14.00 $14.00 $1,500.00 0.93 %$1,486.00 101-000-313-542-42-47-00 NPDES Utilities $102.82 $940.79 $1,500.00 62.72 %$559.21 101-000-313-542-42-48-00 NPDES Equipment Repair & Maintenance $448.52 $1,071.89 $2,500.00 42.88 %$1,428.11 Page 18 of 25 Account Number Title Period Fiscal Budget % of Total Balance 101-000-313-542-42-49-00 NPDES Miscellaneous Expense $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES $10,760.64 $38,812.70 $273,149.00 14.21 %$234,336.30 Storm Water Utility Charge 101-000-315-542-41-47-00 Annual GEWSWU Utility Charge $0.00 $164,385.00 $165,000.00 99.63 %$615.00 Total Storm Water Utility Charge $0.00 $164,385.00 $165,000.00 99.63 %$615.00 101-000-420-542-30-10-00 Salaries -Roadway $975.14 $8,141.82 $60,000.00 13.57 %$51,858.18 101-000-420-542-30-20-00 Benefits $415.20 $3,934.47 $33,000.00 11.92 %$29,065.53 101-000-420-542-30-30-00 Supplies $1,097.28 $2,170.55 $50,000.00 4.34 %$47,829.45 101-000-420-542-30-48-00 Repairs & Maintenance $0.00 $0.00 $6,000.00 0.00 %$6,000.00 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $266.41 $4,500.00 5.92 %$4,233.59 101-000-420-542-61-20-00 Benefits $0.00 $294.87 $2,400.00 12.29 %$2,105.13 101-000-420-542-61-30-00 Supplies $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-420-542-61-48-00 Repairs & Maintenance $1.71 $1.71 $3,000.00 0.06 %$2,998.29 101-000-420-542-62-10-00 Salaries - Special Purpose Paths $23.21 $23.21 $500.00 4.64 %$476.79 101-000-420-542-62-20-00 Benefits $17.73 $17.73 $250.00 7.09 %$232.27 101-000-420-542-62-30-00 Supplies $359.91 $382.06 $2,500.00 15.28 %$2,117.94 101-000-420-542-62-45-00 Annual Fee - Loop Trail Services $13,000.00 $13,000.00 $13,000.00 100.00 %$0.00 101-000-420-542-63-10-00 Salaries - Street Lighting $456.58 $649.06 $2,000.00 32.45 %$1,350.94 101-000-420-542-63-20-00 Benefits $443.93 $474.36 $1,200.00 39.53 %$725.64 101-000-420-542-63-30-00 Supplies $0.00 $103.96 $500.00 20.79 %$396.04 101-000-420-542-63-47-00 Utilities $4,535.30 $49,911.36 $60,000.00 83.19 %$10,088.64 101-000-420-542-63-48-00 Repairs & Maintenance $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $15,316.40 $20,788.10 $40,000.00 51.97 %$19,211.90 101-000-420-542-64-20-00 Benefits $8,642.80 $12,513.10 $23,000.00 54.40 %$10,486.90 101-000-420-542-64-30-00 Supplies $12,606.46 $13,971.42 $48,000.00 29.11 %$34,028.58 101-000-420-542-64-47-00 Utilities $582.53 $1,885.98 $9,000.00 20.96 %$7,114.02 101-000-420-542-64-48-00 Repairs & Maintenance $10.30 $726.48 $14,000.00 5.19 %$13,273.52 101-000-420-542-65-10-00 Salaries - Parking Facilities $0.00 $128.38 $1,000.00 12.84 %$871.62 101-000-420-542-65-20-00 Benefits $0.00 $87.68 $500.00 17.54 %$412.32 101-000-420-542-65-30-00 Supplies $0.00 $0.00 $300.00 0.00 %$300.00 101-000-420-542-65-47-00 Utilities $0.00 $270.00 $500.00 54.00 %$230.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $6.98 $33,626.29 $50,000.00 67.25 %$16,373.71 101-000-420-542-66-20-00 Benefits $4.09 $14,063.70 $27,000.00 52.09 %$12,936.30 101-000-420-542-66-30-00 Supplies $167.35 $51,263.55 $100,000.00 51.26 %$48,736.45 101-000-420-542-66-48-00 Repairs & Maintenance $0.00 $1,192.63 $5,000.00 23.85 %$3,807.37 101-000-420-542-69-10-00 Salaries - Flags/Banners $1,288.82 $3,129.70 $10,000.00 31.30 %$6,870.30 101-000-420-542-69-20-00 Benefits $583.08 $1,338.49 $5,000.00 26.77 %$3,661.51 101-000-420-542-69-30-00 Supplies $101.23 $165.31 $2,000.00 8.27 %$1,834.69 101-000-420-542-70-10-00 Salaries - Roadside $10,908.41 $63,655.68 $180,000.00 35.36 %$116,344.32 101-000-420-542-70-20-00 Benefits $6,220.04 $32,092.12 $94,000.00 34.14 %$61,907.88 101-000-420-542-70-30-00 Supplies $152.41 $691.61 $5,000.00 13.83 %$4,308.39 101-000-420-542-70-41-00 Professional Services $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-70-47-00 Utilities $0.00 $790.60 $1,000.00 79.06 %$209.40 101-000-420-542-70-48-00 Repairs & Maintenance $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-75-10-00 Salaries - City Parks $5,940.94 $14,954.64 $45,000.00 33.23 %$30,045.36 Page 19 of 25 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-75-20-00 Benefits $2,920.14 $7,102.26 $23,000.00 30.88 %$15,897.74 101-000-420-542-75-30-00 Supplies $568.22 $728.82 $15,000.00 4.86 %$14,271.18 101-000-420-542-75-47-00 Utilities $45.00 $835.06 $4,000.00 20.88 %$3,164.94 101-000-420-542-75-48-00 Repairs & Maintenance $95.57 $96.41 $4,000.00 2.41 %$3,903.59 101-000-420-542-80-48-00 Maint Agmt - Japanese Gdn $0.00 $0.00 $18,000.00 0.00 %$18,000.00 101-000-420-542-90-10-00 Salaries - Maintenance Admin $162.39 $393.35 $73,158.00 0.54 %$72,764.65 101-000-420-542-90-20-00 Benefits $124.42 $324.64 $23,520.00 1.38 %$23,195.36 101-000-430-543-30-10-00 Salaries $1,732.68 $6,734.76 $0.00 ($6,734.76) 101-000-430-543-30-20-00 Benefits $738.94 $2,954.38 $0.00 ($2,954.38) 101-000-430-543-30-30-00 Supplies $1,161.73 $2,810.61 $6,000.00 46.84 %$3,189.39 101-000-430-543-30-46-00 Insurance $10.32 $1,275.75 $48,600.00 2.63 %$47,324.25 101-000-430-543-30-49-00 Miscellaneous $0.00 $759.00 $3,000.00 25.30 %$2,241.00 101-000-430-543-50-10-00 Salaries - Facilities $0.00 $431.80 $3,000.00 14.39 %$2,568.20 101-000-430-543-50-20-00 Benefits $0.00 $104.57 $1,600.00 6.54 %$1,495.43 101-000-430-543-50-30-00 Supplies $6.48 $20.54 $2,000.00 1.03 %$1,979.46 101-000-430-543-50-47-00 Utilities $696.33 $2,693.71 $6,000.00 44.90 %$3,306.29 101-000-430-543-50-48-00 Repairs & Maintenance $673.82 $814.48 $2,500.00 32.58 %$1,685.52 101-000-430-544-90-10-00 Salaries - Training $0.00 $1,599.97 $6,500.00 24.61 %$4,900.03 101-000-430-544-90-20-00 Benefits $0.86 $725.87 $3,872.00 18.75 %$3,146.13 101-000-430-544-90-30-00 Supplies $0.00 $54.30 $500.00 10.86 %$445.70 101-000-430-544-90-35-00 Travel - Training $1,200.00 $1,214.00 $4,000.00 30.35 %$2,786.00 101-000-430-544-90-49-01 Training Miscellaneous $0.00 $85.00 $1,000.00 8.50 %$915.00 Total Street Fund $105,146.58 $582,992.19 $1,625,049.00 35.88 %$1,042,056.81 Community Development Grants Fund 102-000-000-558-70-10-00 CDBG Salaries $0.00 $0.00 $2,000.00 0.00 %$2,000.00 102-000-000-558-70-20-00 CDBG Benefits $0.00 $0.00 $642.00 0.00 %$642.00 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $0.00 $142,769.00 0.00 %$142,769.00 102-000-000-558-70-41-00 CDBG Professional Services $0.00 $0.00 $6,000.00 0.00 %$6,000.00 102-000-000-558-70-42-03 CDBG Postage $0.00 $0.00 $30.00 0.00 %$30.00 102-000-000-558-70-44-00 CDBG Advertising $0.00 $0.00 $1,700.00 0.00 %$1,700.00 102-000-000-558-70-49-00 CDBG Miscellaneous $0.00 $0.00 $700.00 0.00 %$700.00 Total Community Development Grants Fund $0.00 $0.00 $153,841.00 0.00 %$153,841.00 Transportation Benefit District Fund 105-000-000-597-91-00-00 Transfer Out - Fund 301 Project Expenditures $0.00 $0.00 $360,000.00 0.00 %$360,000.00 Total Transportation Benefit District Fund $0.00 $0.00 $360,000.00 0.00 %$360,000.00 Library Fund 112-000-000-572-50-41-00 Facilities -- Professional Services $0.00 $0.00 $3,200.00 0.00 %$3,200.00 112-000-000-572-50-47-00 Facilities--Utilities $653.19 $1,938.24 $2,200.00 88.10 %$261.76 112-000-000-572-50-49-00 Facilities--Supplies & Miscellaneous $0.00 $0.00 $40.00 0.00 %$40.00 Total Library Fund $653.19 $1,938.24 $5,440.00 35.63 %$3,501.76 Hotel/Motel Tax Fund 113-000-000-557-30-41-10 Contributions to Other Entities $0.00 $0.00 $14,500.00 0.00 %$14,500.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $9,273.00 $37,092.00 $111,276.00 33.33 %$74,184.00 Page 20 of 25 Account Number Title Period Fiscal Budget % of Total Balance Total Hotel/Motel Tax Fund $9,273.00 $37,092.00 $125,776.00 29.49 %$88,684.00 Events Board Fund 117-000-050-557-30-10-00 Eweb Salaries $4,733.06 $18,434.26 $72,000.00 25.60 %$53,565.74 117-000-050-557-30-20-00 Eweb Benefits $2,994.63 $9,015.25 $32,000.00 28.17 %$22,984.75 117-000-050-557-30-30-00 Contract Services $1,950.02 $7,800.08 $23,500.00 33.19 %$15,699.92 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-100-557-30-31-00 Events Department Office Supplies $172.88 $187.36 $0.00 ($187.36) 117-000-100-557-30-32-00 Eweb Fuel Consumed $0.00 $0.00 $200.00 0.00 %$200.00 117-000-100-557-30-35-00 Eweb Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 117-000-100-557-30-49-00 Eweb Miscellaneous $0.00 $44.59 $100.00 44.59 %$55.41 117-000-100-594-58-64-00 EWEB Capital Outlay $0.00 $0.00 $200.00 0.00 %$200.00 117-000-105-557-30-40-00 Eweb Insurance $0.00 $7.54 $7,600.00 0.10 %$7,592.46 117-000-115-557-30-31-05 Eweb Office Supplies $37.94 $113.82 $1,000.00 11.38 %$886.18 117-000-200-557-30-35-02 Easter Small Tools & Equipmen $0.00 $0.00 $200.00 0.00 %$200.00 117-000-200-557-30-44-02 Easter Advertising $0.00 $428.66 $350.00 122.47 %($78.66) 117-000-200-557-30-46-02 Easter Office Supplies $0.00 $0.00 $0.00 $0.00 117-000-200-557-30-49-02 Easter Miscellaneous $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-300-557-30-32-12 Classy Chassis Fuel Consumed $0.00 $0.00 $100.00 0.00 %$100.00 117-000-300-557-30-34-11 Classy Chassis Event Merch For Resale $0.00 $0.00 $4,800.00 0.00 %$4,800.00 117-000-300-557-30-35-12 Classy Chassis Small Tools & Equipment $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-300-557-30-41-12 CC Professional Services $605.92 $605.92 $5,500.00 11.02 %$4,894.08 117-000-300-557-30-42-14 Classy Chassis Postage $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-300-557-30-43-12 CC EMPD Facility Fee $0.00 $0.00 $1,100.00 0.00 %$1,100.00 117-000-300-557-30-44-12 Classy Chassis Advertising $1,209.43 $1,594.43 $4,500.00 35.43 %$2,905.57 117-000-300-557-30-49-12 Classy Chassis Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-557-30-34-11 W&W Event Merch For Resale $0.00 $0.00 $3,500.00 0.00 %$3,500.00 117-000-400-557-30-35-11 W & W Small Tools & Equipment $0.00 $0.00 $3,000.00 0.00 %$3,000.00 117-000-400-557-30-41-00 W & W Professional Services $0.00 $0.00 $2,750.00 0.00 %$2,750.00 117-000-400-557-30-42-13 Wings & Wheels Postage $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-557-30-43-12 W&W EMPD Facility Fee $0.00 $0.00 $1,100.00 0.00 %$1,100.00 117-000-400-557-30-44-11 Wings & Wheels Advertising $0.00 $0.00 $8,000.00 0.00 %$8,000.00 117-000-400-557-30-44-15 W&W Sponsored Car Show Prizes $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-557-30-49-11 Wings & Wheels Miscellaneous $0.00 $0.00 $1,100.00 0.00 %$1,100.00 117-000-400-557-30-49-13 W&W Schedule of Events Brochur $0.00 $0.00 $3,500.00 0.00 %$3,500.00 117-000-450-557-30-41-00 PPU Professional Services $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-450-557-30-44-12 PkwyPile-up Car Show Advertising $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-450-557-30-49-01 PkwyPile-up Car Show Miscellaneous $0.00 $0.00 $1,200.00 0.00 %$1,200.00 117-000-500-557-30-35-01 Christmas Small Tools & Equip $0.00 $0.00 $400.00 0.00 %$400.00 117-000-500-557-30-40-05 Christmas Events & Decorations $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-500-557-30-41-01 Christmas Professional Ser $227.22 $227.22 $0.00 ($227.22) 117-000-500-557-30-44-01 Christmas Advertising $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-500-557-30-49-01 Christmas Miscellaneous $0.00 $41.53 $800.00 5.19 %$758.47 Total Events Board Fund $11,931.10 $38,500.66 $192,600.00 19.99 %$154,099.34 Bond Redemption Fund Page 21 of 25 Account Number Title Period Fiscal Budget % of Total Balance 202-000-000-591-95-71-05 Redemption of PWTFL Debt $0.00 $0.00 $30,000.00 0.00 %$30,000.00 202-000-000-592-95-89-05 Interest Exp PWTFL Debt $0.00 $0.00 $600.00 0.00 %$600.00 Total Bond Redemption Fund $0.00 $0.00 $30,600.00 0.00 %$30,600.00 Street Improvements Fund 301-000-000-595-10-40-13 Design - TIB Grant Road/Eastmont Ave Intersection $0.00 $0.00 $115,000.00 0.00 %$115,000.00 301-000-000-595-10-40-19 Design - TIB 3rd St SE/Highline Dr Roundabout $0.00 $0.00 $100,000.00 0.00 %$100,000.00 301-000-000-595-10-40-21 Design - TIB VMP/15th St Overlay $0.00 $0.00 $95,000.00 0.00 %$95,000.00 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $0.00 $0.00 $59,000.00 0.00 %$59,000.00 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $0.00 $0.00 $35,000.00 0.00 %$35,000.00 301-000-000-595-10-40-26 Design - PWTFL - 10th St $0.00 $104,105.30 $750,000.00 13.88 %$645,894.70 301-000-000-595-10-40-27 Design 2019 TBD Paving $0.00 $10,388.56 $30,000.00 34.63 %$19,611.44 301-000-000-595-30-40-33 SDC - TIB VMP/15th St Overlay $0.00 $0.00 $63,000.00 0.00 %$63,000.00 301-000-000-595-30-40-36 Construction - TIB VMP/15th St Overlay $0.00 $0.00 $630,000.00 0.00 %$630,000.00 301-000-000-595-30-40-37 SDC - S. Kentucky & 5th St. NE $0.00 $430.00 $0.00 ($430.00) 301-000-000-595-30-40-38 SDC 2019 TBD Paving $0.00 $0.00 $15,000.00 0.00 %$15,000.00 301-000-000-595-30-40-39 Construction 2019 TBD Paving $0.00 $0.00 $345,000.00 0.00 %$345,000.00 301-000-000-595-40-45-00 Materials - Relight WA Project $58,150.00 $58,150.00 $53,150.00 109.41 %($5,000.00) Total Street Improvements Fund $58,150.00 $173,073.86 $2,290,150.00 7.56 %$2,117,076.14 Storm Water Improvements Fund 308-000-000-541-40-40-00 State Ecology Robotic Grant $0.00 $0.00 $50,000.00 0.00 %$50,000.00 308-000-000-595-40-60-01 10th Street Design $0.00 $0.00 $225,000.00 0.00 %$225,000.00 308-000-000-595-40-63-00 SWA Small Improvement Projects $0.00 $0.00 $100,000.00 0.00 %$100,000.00 308-000-000-595-40-63-39 19th St. NW Design SWU DOE $6,367.00 $6,367.00 $250,000.00 2.55 %$243,633.00 Total Storm Water Improvements Fund $6,367.00 $6,367.00 $625,000.00 1.02 %$618,633.00 Capital Improvements Fund 314-000-000-594-48-60-00 Public Works Remodel $0.00 $0.00 $750,000.00 0.00 %$750,000.00 314-000-000-594-59-60-00 Gateway Property SDC $4,563.73 $8,290.25 $42,000.00 19.74 %$33,709.75 314-000-000-594-59-60-01 Gateway Property Construction $178,681.54 $178,681.54 $517,000.00 34.56 %$338,318.46 Total Capital Improvements Fund $183,245.27 $186,971.79 $1,309,000.00 14.28 %$1,122,028.21 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicles R&M Labor $834.45 $2,263.25 $7,000.00 32.33 %$4,736.75 501-000-000-521-10-20-00 Police Vehicle R&M Benefits $414.03 $1,124.68 $2,300.00 48.90 %$1,175.32 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $1,942.25 $7,897.74 $35,000.00 22.56 %$27,102.26 501-000-000-542-90-10-00 Street Vehicle R&M Labor $92.16 $8,562.67 $19,000.00 45.07 %$10,437.33 501-000-000-542-90-20-00 Street Vehicle R&M Benefits $24.72 $3,624.54 $10,000.00 36.25 %$6,375.46 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $3,078.79 $8,428.50 $31,000.00 27.19 %$22,571.50 501-000-000-542-90-48-25 Street Vehicle R&M Supplies $1,447.10 $1,882.12 $5,000.00 37.64 %$3,117.88 501-000-000-542-90-48-30 Street Equipment R&M $118.44 $210.60 $1,600.00 13.16 %$1,389.40 501-000-000-594-21-60-00 Capital Outlay - Police Vehicles $26,991.04 $111,663.16 $104,600.00 106.75 %($7,063.16) 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $47,117.81 $48,000.00 98.16 %$882.19 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $0.00 $180,000.00 0.00 %$180,000.00 Total Equipment Purchase, Repair & Replacement Fund $34,942.98 $192,775.07 $443,500.00 43.47 %$250,724.93 Page 22 of 25 Account Number Title Period Fiscal Budget % of Total Balance Grand Totals $1,042,795.83 $3,663,483.20 $14,260,043.00 25.69 %$10,596,559.80 Page 23 of 25 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $633,086.71 $2,443,772.39 $7,099,087.00 34.42 %$4,655,314.61 101-000-000-000-00-00-00 Street Fund $105,146.58 $582,992.19 $1,625,049.00 35.88 %$1,042,056.81 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $153,841.00 0.00 %$153,841.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $0.00 $360,000.00 0.00 %$360,000.00 112-000-000-000-00-00-00 Library Fund $653.19 $1,938.24 $5,440.00 35.63 %$3,501.76 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $9,273.00 $37,092.00 $125,776.00 29.49 %$88,684.00 117-000-000-000-00-00-00 Events Board Fund $11,931.10 $38,500.66 $192,600.00 19.99 %$154,099.34 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $0.00 $30,600.00 0.00 %$30,600.00 301-000-000-000-00-00-00 Street Improvements Fund $58,150.00 $173,073.86 $2,290,150.00 7.56 %$2,117,076.14 308-000-000-000-00-00-00 Storm Water Improvements Fund $6,367.00 $6,367.00 $625,000.00 1.02 %$618,633.00 314-000-000-000-00-00-00 Capital Improvements Fund $183,245.27 $186,971.79 $1,309,000.00 14.28 %$1,122,028.21 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $34,942.98 $192,775.07 $443,500.00 43.47 %$250,724.93 Grand Totals $1,042,795.83 $3,663,483.20 $14,260,043.00 25.69 %$10,596,559.80 Page 24 of 25 Beginning Activity Ending Cash In Cash 001 $3,224,637.95 $1,474,568.25 $2,255,302.66 101 $324,859.26 $601,894.74 $335,068.75 102 $77,954.27 $0.00 $77,954.27 105 $379,978.50 $72,448.20 $452,366.70 110 $495,000.00 $0.00 $495,000.00 112 $10,371.75 $0.00 $8,433.51 113 $76,558.62 $40,397.20 $79,863.82 114 $1,063.88 $443.88 $1,507.76 116 $28,363.65 $9,186.58 $37,550.23 117 $109,898.73 $28,736.58 $99,884.65 202 $9,088.19 $30,000.00 $39,088.19 301 $617,142.84 $108,047.50 $552,116.48 308 $115,590.47 $0.00 $109,223.47 314 $1,071,531.13 $63,604.38 $948,163.72 501 $131,631.44 $300,000.00 $238,856.37 $6,673,670.68 $2,729,327.31 $5,730,380.58 Cash and Investment Activity Period: 2019 - April 2019 Fund Activity $591,685.25 Out $2,443,903.54 $0.00 $60.00 $0.00 $1,938.24 $37,092.00 $0.00 $0.00 $38,750.66 $0.00 $173,073.86 $6,367.00 $186,971.79 $3,672,617.41 General Fund Street Fund Community Development Grants Fund Transportation Benefit District Fund Financing Reserves Fund Library Fund Hotel/Motel Tax Fund Drug Fund Criminal Justice Fund Events Board Fund Bond Redemption Fund Street Improvements Fund Storm W ater Improvements Fund Capital Improvements Fund Equipment Purchase, R & R $192,775.07 Page 25 of 25