Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2021 - February 2021 Monthly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee April 6, 2021 City Council Meeting February 2021 Financial Report Date: April 6, 2021 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: February 2021 Financial Report This report provides a summary of the City’s overall financial operations through February 28, 2021. 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 February 28, 2021 compared to revenue collections through February 29, 2020, along with the respective dollar and percentage variances for its operating funds. Table 1 February 28, 2021 February 29, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 683,612 670,703 12,909 1.92% Street Fund - 101 312,844 346,895 (34,051) (9.82%) Events Board Fund - 117 - 250 (250) (100.00%) Equipment R&R Fund - 501 441,051 350,000 91,051 26.01% Total Revenues - Operating Funds 1,437,507 1,367,848 69,659 5.09% 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 1 of 26 City of East Wenatchee April 6, 2021 City Council Meeting February 2021 Financial Report Chart 1 is a graphical representation of year over year revenue comparisons for the City’s operating funds. Chart 1 Table 2 below shows the City’s revenue collections through February 28, 2021 compared to revenue collections through February 29, 2020, along with the respective dollar and percentage variances for its non-operating funds. 2 of 26 City of East Wenatchee April 6, 2021 City Council Meeting February 2021 Financial Report Table 2 February 28, 2021 February 29, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 35,000 - 35,000 - Affordable Housing Tax Fund - 103 7,311 - 7,311 - Trans Benefit District Fund - 105 38,333 35,165 3,168 9.01% Library Fund - 112 - - - - Hotel/Motel Tax Fund - 113 36,690 52,045 (15,355) (29.50%) Drug Fund - 114 2 2 0 9.29% Criminal Justice Fund - 116 4,995 4,770 225 4.73% Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 43,862 75,536 (31,674) (41.93%) Capital Improvements Fund - 314 84,446 160,817 (76,371) (47.49%) Storm Water Fund - 401 1,280 2,613,275 (2,611,995) (99.95%) Total Revenues - Non-Operating Funds 251,919 2,941,609 (2,689,690) (91.44%) Revenues - Non-Operating Funds Chart 2 is a graphical representation of year over year revenue comparisons for the City’s non- operating funds. Chart 2 3 of 26 City of East Wenatchee April 6, 2021 City Council Meeting February 2021 Financial Report Revenue Highlights: General Fund revenues are up $12,909, or 1.92%, year over year due to: $61,478 increase in the sales tax allocation to this fund per normal year over year allocation variances; and a $32,028 increase in criminal justice sales tax presumably because retail sales activity is up in Douglas County The above increases are offset by the following decreases year over year: $27,097 decrease in phone/cellular utility tax; and a $19,714 decrease in funding assistance from Rivercom Street Fund revenues are down $34,051, or 9.82%, year over year due to $26,048 less sales tax allocation per normal year over year allocation variances. Gas tax is also down $6,671 presumably due to less driving because of COVID-19 restrictions. Equipment R&R Fund revenues are up $91,051, or 26.01%, year over year due to the increased revenue needs of this fund per the new revolving fund format as recommended by the State Auditor’s Office. Community Development Grants Fund revenues are up $35,000 year over year due to the timing of reimbursements. Hotel/Motel Tax Fund revenues are down $15,355, or 29.50%, year over year presumably due to a decrease in hotel stays in the City. Street Improvements Fund revenues are down $31,674, or 41.93%, year over year due to the normal timing differences of projects associated with this fund. Capital Improvements Fund revenues are down $76,371, or 47.49%, year over year due to the decreased collection of real estate excise tax presumably due to less or smaller real estate sales transactions. Storm Water Fund revenues are down $2,611,995, or 99.95%, year over year because last year the City received a large influx of its share of revenue from Douglas County due to a terminated interlocal agreement with them for storm water services. 4 of 26 City of East Wenatchee April 6, 2021 City Council Meeting February 2021 Financial Report Table 3 below shows the City’s expenditures through February 28, 2021 compared to expenditures through February 29, 2020, along with respective dollar and percentage variances for its operating funds. Table 3 February 28, 2021 February 29, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 1,166,811 1,184,753 (17,943) (1.51%) Street Fund - 101 147,678 125,625 22,052 17.55% Events Board Fund - 117 18,243 18,098 145 0.80% Equipment R&R Fund - 501 141,710 65,951 75,759 114.87% Total Expenditures - Operating Funds 1,474,442 1,394,428 80,014 5.74% Expenditures - Operating Funds Chart 3 is a graphical representation of year over year expenditure comparisons for the City’s operating funds. Chart 3 5 of 26 City of East Wenatchee April 6, 2021 City Council Meeting February 2021 Financial Report Table 4 below shows the City’s expenditures through February 28, 2021 compared to expenditures through February 29, 2020, along with respective dollar and percentage variances for its non- operating funds. Table 4 February 28, 2021 February 29, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 416 - 416 - Trans Benefit District Fund - 105 - - - - Library Fund - 112 360 1,015 (656) (64.57%) Hotel/Motel Tax Fund - 113 10,124 20,248 (10,124) (50.00%) Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 60,238 62,524 (2,286) (3.66%) Capital Improvements Fund - 314 - - - - Storm Water Fund - 401 37,820 31,495 6,326 20.08% Total Expenditures - Non-Operating Funds 108,958 115,282 (6,324) (5.49%) Expenditures - Non-Operating Funds Chart 4 is a graphical representation of year over year expenditure comparisons for the City’s non- operating funds. Chart 4 6 of 26 City of East Wenatchee April 6, 2021 City Council Meeting February 2021 Financial Report Expenditure Highlights: General Fund expenditures are down $17,943, or 1.51%, year over year due to: $25,296 decrease in capital outlay costs for the Police Department due to the timing of purchases related to that line item The above decrease is offset by the following increases: General overall salary and benefit increases; and a $29,471 increase in fleet rental costs for the Police Department related to the new format of the City’s equipment rental fund Street Fund expenditures are up $22,052, or 17.55%, year over year due to a $28,098 increase in fleet rental costs related to the new format of the City’s equipment rental fund Equipment R&R Fund expenditures are up $75,759, or 114.87%, year over year due to the timing of the purchase of three new police vehicles compared to when they were purchased last year. Hotel/Motel Tax Fund expenditures are down $10,124, or 50%, year over year due to half of the funds appropriated for the Wenatchee Valley Museum now coming out of the General Fund. Street Improvements Fund expenditures are down $2,286 year over year due typical timing variances associated with the capital projects in this fund. Storm Water Fund expenditures are up $6,326, or 20.08%, year over year primarily due to a $9,482 increase in fleet rental costs related to the new format of the City’s equipment rental 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 February 28, 2021. 7 of 26 Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $3,828.28 $13,651.74 $1,318,200.00 1.04 %$1,304,548.26 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $100,000.00 $200,000.00 $3,306,000.00 6.05 %$3,106,000.00 001-000-000-313-71-00-00 Criminal Justice Sales Tax $44,059.58 $88,023.79 $296,000.00 29.74 %$207,976.21 001-000-000-316-40-00-00 Electric Utility Tax $40,029.46 $75,156.25 $354,000.00 21.23 %$278,843.75 001-000-000-316-45-00-00 Natural Gas Utility Tax $0.00 $5,163.66 $35,000.00 14.75 %$29,836.34 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $5,216.23 $19,542.51 $360,000.00 5.43 %$340,457.49 001-000-000-316-84-00-00 Gambling Tax $98,191.12 $98,191.12 $317,000.00 30.98 %$218,808.88 Total Taxes $291,324.67 $499,729.07 $5,986,200.00 8.35 %$5,486,470.93 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 $25.00 $412.00 $800.00 51.50 %$388.00 001-000-000-321-91-00-50 Franchise Fees - Cable $23,494.08 $27,494.08 $91,000.00 30.21 %$63,505.92 001-000-000-321-99-00-00 Business Licenses & Permits $8,402.99 $17,719.00 $100,000.00 17.72 %$82,281.00 001-000-000-321-99-05-00 Other Business Lic & Permits $0.00 $0.00 $660.00 0.00 %$660.00 001-000-000-322-10-00-00 Building & Structure Permits $557.05 $3,935.71 $60,000.00 6.56 %$56,064.29 001-000-000-322-90-01-00 Gun Permits $580.00 $1,593.00 $5,700.00 27.95 %$4,107.00 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $125.00 0.00 %$125.00 Total Licenses and Permits $33,059.12 $51,153.79 $258,785.00 19.77 %$207,631.21 Intergovernmental Revenues 001-000-000-334-01-20-01 Washington Courts Funding $0.00 $20,000.00 $0.00 ($20,000.00) 001-000-000-334-03-51-03 TSC - Seatbelt Emphasis Patrols $0.00 $0.00 $900.00 0.00 %$900.00 001-000-000-334-03-51-04 X-52 TSC-Speed Limit Emphasis $0.00 $0.00 $1,900.00 0.00 %$1,900.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $0.00 $0.00 $2,500.00 0.00 %$2,500.00 001-000-000-334-03-51-12 TSC - DUI Emphasis Patrol $0.00 $428.82 $2,500.00 17.15 %$2,071.18 001-000-000-334-04-20-05 Dept. of Commerce Grant $10,530.00 $10,530.00 $0.00 ($10,530.00) 001-000-000-334-06-91-00 WA ST Office of Public Defense $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-000-335-00-91-00 PUD Privilege Tax $0.00 $0.00 $43,000.00 0.00 %$43,000.00 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $0.00 $23,000.00 0.00 %$23,000.00 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $539.39 $2,000.00 26.97 %$1,460.61 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $22,004.78 $77,000.00 28.58 %$54,995.22 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $0.00 $108,000.00 0.00 %$108,000.00 Total Intergovernmental Revenues $10,530.00 $53,502.99 $280,800.00 19.05 %$227,297.01 Charges for Goods and Services 001-000-000-341-33-10-00 Background Check Fees $0.00 $0.00 $90.00 0.00 %$90.00 Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 999-000-000-384-00-00-00 Proceeds From Sales of Investments Period: 2021 - February 2021 8 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-000-341-35-30-00 Duplicating Services - Court & Police $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-341-35-31-00 Copy and Duplication Fees - Admin $0.00 $0.00 $70.00 0.00 %$70.00 001-000-000-341-35-33-00 Recording and Filing Fees $0.00 $0.00 $60.00 0.00 %$60.00 001-000-000-341-35-35-00 Annual Admin Reimb Fees $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-000-342-33-00-00 Adult Probation Services $3,834.95 $7,187.42 $63,000.00 11.41 %$55,812.58 001-000-000-342-36-00-00 Housing of Prisoners $693.72 $1,423.85 $20,000.00 7.12 %$18,576.15 001-000-000-342-40-00-01 Fire Marshall Inspection Services $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-000-345-83-00-00 Plan Checking Fees $306.83 $2,136.17 $30,000.00 7.12 %$27,863.83 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $243.00 $750.00 32.40 %$507.00 001-000-000-345-86-00-00 Sepa Permits $0.00 $488.00 $1,000.00 48.80 %$512.00 001-000-000-345-89-00-00 Planning & Development Fees $123.00 $842.00 $8,000.00 10.53 %$7,158.00 Total Charges for Goods and Services $4,958.50 $12,320.44 $133,070.00 9.26 %$120,749.56 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $10,107.04 $20,937.38 $175,000.00 11.96 %$154,062.62 001-000-000-357-33-00-00 Public Defender Costs $1,052.69 $1,496.00 $23,000.00 6.50 %$21,504.00 001-000-000-357-35-00-00 Restitution $0.00 $0.00 $400.00 0.00 %$400.00 Total Fines and Penalties $11,159.73 $22,433.38 $198,400.00 11.31 %$175,966.62 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $890.79 $1,930.40 $90,000.00 2.14 %$88,069.60 001-000-000-361-40-00-00 Sales Tax Interest $345.89 $689.83 $5,700.00 12.10 %$5,010.17 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,575.79 $1,575.79 $12,000.00 13.13 %$10,424.21 001-000-000-369-91-50-00 Miscellaneous Revenue $0.00 $0.00 $7,000.00 0.00 %$7,000.00 Total Miscellaneous Revenues $2,812.47 $4,196.02 $114,700.00 3.66 %$110,503.98 Other Increases in Fund Resources 001-000-000-382-10-00-00 Fireworks - Cleaning Deposit $0.00 $0.00 $2,350.00 0.00 %$2,350.00 001-000-000-382-10-00-01 Fireworks - Dcfd Remittance $0.00 $0.00 $200.00 0.00 %$200.00 001-000-000-389-00-00-01 Crime Victim Assessment $176.07 $356.04 $3,200.00 11.13 %$2,843.96 001-000-000-389-00-00-02 State Surcharge $6.50 $57.50 $700.00 8.21 %$642.50 001-000-000-389-00-00-03 State Share Weapons Permit Fee $853.00 $2,425.50 $8,700.00 27.88 %$6,274.50 001-000-000-389-00-00-04 Court Remittance - State $10,430.57 $21,981.64 $175,000.00 12.56 %$153,018.36 Total Other Increases in Fund Resources $11,466.14 $24,820.68 $190,150.00 13.05 %$165,329.32 Other Financing Sources 001-000-000-395-10-00-00 Proceeds - Disposition of Assets $0.00 $0.00 $9,800.00 0.00 %$9,800.00 001-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-397-95-00-25 Transfer In - Street Imp Fund $0.00 $0.00 $500,000.00 0.00 %$500,000.00 001-000-000-398-10-00-00 Insurance Recoveries $0.00 $15,455.45 $0.00 ($15,455.45) Total Other Financing Sources $0.00 $15,455.45 $509,900.00 3.03 %$494,444.55 Total General Fund $365,310.63 $683,611.82 $7,672,005.00 8.91 %$6,988,393.18 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $0.00 $0.00 $500,000.00 0.00 %$500,000.00 101-000-000-313-11-00-00 Sales & Use Tax $160,060.94 $273,952.43 $470,000.00 58.29 %$196,047.57 101-000-000-322-40-00-00 Street Permits $1,530.00 $1,530.00 $2,000.00 76.50 %$470.00 101-000-000-336-00-71-00 Multi-Modal Distribution $0.00 $0.00 $18,000.00 0.00 %$18,000.00 101-000-000-336-00-87-00 Gas Tax $20,235.25 $37,046.58 $275,000.00 13.47 %$237,953.42 9 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-000-336-00-87-05 Increased Gas Tax $0.00 $0.00 $16,000.00 0.00 %$16,000.00 101-000-000-369-91-01-05 Miscellaneous Revenue $314.65 $314.65 $0.00 ($314.65) Total Street Fund $182,140.84 $312,843.66 $1,281,000.00 24.42 %$968,156.34 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $35,000.00 $35,000.00 $74,764.00 46.81 %$39,764.00 Total Community Development Grants Fund $35,000.00 $35,000.00 $74,764.00 46.81 %$39,764.00 Affordable Housing Sales Tax Fund 103-000-000-313-27-00-00 Affordable & Supportive Housing Sales/Use Tax $4,175.11 $7,310.77 $0.00 ($7,310.77) Total Affordable Housing Sales Tax Fund $4,175.11 $7,310.77 $0.00 ($7,310.77) Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $19,027.80 $38,332.80 $0.00 ($38,332.80) Total Transportation Benefit District Fund $19,027.80 $38,332.80 $0.00 ($38,332.80) Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $0.00 $7,500.00 0.00 %$7,500.00 Total Library Fund $0.00 $0.00 $7,500.00 0.00 %$7,500.00 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $20,682.76 $36,689.79 $225,000.00 16.31 %$188,310.21 Total Hotel/Motel Tax Fund $20,682.76 $36,689.79 $225,000.00 16.31 %$188,310.21 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $1.01 $2.00 $100.00 2.00 %$98.00 Total Drug Fund $1.01 $2.00 $100.00 2.00 %$98.00 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $1,093.10 $4,500.00 24.29 %$3,406.90 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $3,902.03 $16,000.00 24.39 %$12,097.97 Total Criminal Justice Fund $0.00 $4,995.13 $20,500.00 24.37 %$15,504.87 Events Board Fund 117-000-100-397-00-00-00 Transfer-In from Fund 113 $0.00 $0.00 $120,000.00 0.00 %$120,000.00 117-000-300-347-40-12-02 Classy Chassis Parade/Car Show $0.00 $0.00 $9,000.00 0.00 %$9,000.00 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $0.00 $0.00 $150.00 0.00 %$150.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 $0.00 $0.00 $4,500.00 0.00 %$4,500.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-500-367-19-00-01 Christmas Sponsorships $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Events Board Fund $0.00 $0.00 $156,750.00 0.00 %$156,750.00 Street Improvements Fund 301-000-000-330-00-00-00 GWID - 10th St. NE Improvements $0.00 $0.00 $298,534.00 0.00 %$298,534.00 301-000-000-333-20-00-13 STP 9th/VMP Intersection $26,438.55 $26,438.55 $825,000.00 3.20 %$798,561.45 301-000-000-333-20-00-21 STBG - 10th St. NE Improvements $0.00 $0.00 $1,683,159.00 0.00 %$1,683,159.00 301-000-000-333-20-00-22 SRTS - 5th St NE: Sterling $17,423.21 $17,423.21 $207,500.00 8.40 %$190,076.79 10 of 26 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-333-20-00-23 SRTS - 5th St NE: Kenroy $0.00 $0.00 $233,250.00 0.00 %$233,250.00 301-000-000-334-03-80-13 TIB N Kentucky Ave Overlay $0.00 $0.00 $675,750.00 0.00 %$675,750.00 301-000-000-334-03-80-15 TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $81,800.00 0.00 %$81,800.00 301-000-000-334-03-80-17 TIB - 10th St. NE Improvements $0.00 $0.00 $1,126,608.00 0.00 %$1,126,608.00 301-000-000-334-03-80-19 TIB - Grant/Highline Intersection Improvements $0.00 $0.00 $48,875.00 0.00 %$48,875.00 301-000-000-391-80-00-00 PWTFL - 10th Street Design $0.00 $0.00 $50,000.00 0.00 %$50,000.00 301-000-000-397-00-00-00 Transfer-In - Fund 401 $0.00 $0.00 $728,000.00 0.00 %$728,000.00 301-000-000-397-00-00-01 Transfer-In - Fund 102 $0.00 $0.00 $70,000.00 0.00 %$70,000.00 301-000-000-397-41-10-05 Transfer-In from Fund 105 $0.00 $0.00 $190,000.00 0.00 %$190,000.00 301-000-000-397-95-00-20 Transfer-In from Fund 314 $0.00 $0.00 $250,000.00 0.00 %$250,000.00 301-000-000-397-95-00-25 Transfer In From General Fund $0.00 $0.00 $500,000.00 0.00 %$500,000.00 Total Street Improvements Fund $43,861.76 $43,861.76 $6,968,476.00 0.63 %$6,924,614.24 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $24,725.04 $84,446.32 $400,000.00 21.11 %$315,553.68 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 $24,725.04 $84,446.32 $5,400,000.00 1.56 %$5,315,553.68 Stormwater Fund 401-000-000-334-03-10-01 19th St. Ecology Grant $0.00 $0.00 $50,000.00 0.00 %$50,000.00 401-000-000-334-03-10-02 Stormwater Comp Plan Ecology Grant $0.00 $0.00 $31,875.00 0.00 %$31,875.00 401-000-000-343-10-00-00 SWU Fee $1,197.00 $1,278.00 $520,000.00 0.25 %$518,722.00 401-000-000-361-40-00-00 Interest Earnings $0.00 $2.10 $0.00 ($2.10) Total Stormwater Fund $1,197.00 $1,280.10 $601,875.00 0.21 %$600,594.90 Equipment Purchase, Repair & Replacement Fund 501-000-000-313-11-00-10 Sales & Use Tax - Police $0.00 $151,000.00 $151,000.00 100.00 %$0.00 501-000-000-313-11-00-20 Sales & Use Tax - Streets $223,000.00 $223,000.00 $223,000.00 100.00 %$0.00 501-000-000-348-00-00-01 Police - Fleet Maintenance Rentals $14,735.42 $29,470.84 $177,000.00 16.65 %$147,529.16 501-000-000-348-00-00-02 Street - Fleet Maintenance Rentals $14,049.23 $28,098.46 $169,000.00 16.63 %$140,901.54 501-000-000-348-00-00-03 Stormwater - Fleet Maintenance Rentals $4,741.01 $9,482.02 $57,000.00 16.64 %$47,517.98 501-000-000-397-00-00-02 Transfer-In - Criminal Justice Fund $0.00 $0.00 $25,000.00 0.00 %$25,000.00 Total Equipment Purchase, Repair & Replacement Fund $256,525.66 $441,051.32 $802,000.00 54.99 %$360,948.68 Grand Totals $952,647.61 $1,689,425.47 $23,209,970.00 7.28 %$21,520,544.53 11 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $365,310.63 $683,611.82 $7,672,005.00 8.91 %$6,988,393.18 101-000-000-000-00-00-00 Street Fund $182,140.84 $312,843.66 $1,281,000.00 24.42 %$968,156.34 102-000-000-000-00-00-00 Community Development Grants Fund $35,000.00 $35,000.00 $74,764.00 46.81 %$39,764.00 103-000-000-000-00-00-00 Affordable Housing Sales Tax Fund $4,175.11 $7,310.77 $0.00 ($7,310.77) 105-000-000-000-00-00-00 Transportation Benefit District Fund $19,027.80 $38,332.80 $0.00 ($38,332.80) 112-000-000-000-00-00-00 Library Fund $0.00 $0.00 $7,500.00 0.00 %$7,500.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $20,682.76 $36,689.79 $225,000.00 16.31 %$188,310.21 114-000-000-000-00-00-00 Drug Fund $1.01 $2.00 $100.00 2.00 %$98.00 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $4,995.13 $20,500.00 24.37 %$15,504.87 117-000-000-000-00-00-00 Events Board Fund $0.00 $0.00 $156,750.00 0.00 %$156,750.00 301-000-000-000-00-00-00 Street Improvements Fund $43,861.76 $43,861.76 $6,968,476.00 0.63 %$6,924,614.24 314-000-000-000-00-00-00 Capital Improvements Fund $24,725.04 $84,446.32 $5,400,000.00 1.56 %$5,315,553.68 401-000-000-000-00-00-00 Stormwater Fund $1,197.00 $1,280.10 $601,875.00 0.21 %$600,594.90 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $256,525.66 $441,051.32 $802,000.00 54.99 %$360,948.68 Grand Totals $952,647.61 $1,689,425.47 $23,209,970.00 7.28 %$21,520,544.53 12 of 26 Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 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.58 $67.58 $1,000.00 6.76 %$932.42 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 $4,455.00 $26,500.00 16.81 %$22,045.00 001-000-001-528-70-40-00 River Com $21,770.90 $43,541.80 $261,251.00 16.67 %$217,709.20 001-000-001-539-30-40-00 Animal Control $12,375.00 $18,623.76 $73,515.00 25.33 %$54,891.24 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $0.00 $14,500.00 0.00 %$14,500.00 001-000-001-558-70-40-00 Contributions - Region $20,000.00 $20,000.00 $25,000.00 80.00 %$5,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 $1,500.00 $1,500.00 $1,500.00 100.00 %$0.00 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $900.00 $900.00 $500.00 180.00 %($400.00) 001-000-001-558-70-41-10 Spirit of Wenatchee Miss Veedol $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-001-558-70-41-15 Wenatchee Valley Museum $5,062.00 $10,124.00 $61,000.00 16.60 %$50,876.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$1,032.74 $1,032.74 $3,600.00 28.69 %$2,567.26 001-000-001-597-95-00-25 Transfer Out to Street Impv Fund 301 $0.00 $0.00 $500,000.00 0.00 %$500,000.00 Total General Government $64,935.72 $100,244.88 $973,666.00 10.30 %$873,421.12 Legislative 001-000-110-511-60-10-00 Salaries $10,461.77 $21,018.31 $55,440.00 37.91 %$34,421.69 001-000-110-511-60-20-00 Benefits $2,661.93 $5,357.04 $4,500.00 119.05 %($857.04) 001-000-110-511-60-21-50 Public Defender $11,850.00 $23,200.00 $135,000.00 17.19 %$111,800.00 001-000-110-511-60-30-00 Public Defender Conflicts $135.00 $135.00 $5,200.00 2.60 %$5,065.00 001-000-110-511-60-31-00 Office Supplies $0.00 $0.00 $650.00 0.00 %$650.00 001-000-110-511-60-40-00 Training $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-110-511-60-41-00 Professional Services $11,216.00 $11,216.00 $10,000.00 112.16 %($1,216.00) 001-000-110-511-60-41-20 AWC Annual Membership Fee $0.00 $10,089.00 $9,989.00 101.00 %($100.00) 001-000-110-511-60-43-00 Travel $0.00 $0.00 $1,250.00 0.00 %$1,250.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 $0.00 $1,000.00 0.00 %$1,000.00 001-000-110-511-60-45-00 Election Costs - Registered Voters $0.00 $0.00 $25,000.00 0.00 %$25,000.00 001-000-110-511-60-46-00 Insurance $15.62 $15.62 $8,500.00 0.18 %$8,484.38 001-000-110-511-60-47-00 Background Check Costs $44.00 $44.00 $200.00 22.00 %$156.00 001-000-110-511-60-49-00 Miscellaneous $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Legislative $36,384.32 $71,074.97 $268,229.00 26.50 %$197,154.03 Mayor's Office 001-000-111-513-00-10-00 Salaries $2,148.09 $4,296.17 $97,000.00 4.43 %$92,703.83 Expenditure Starting Account Number: 001-000-001-518-20-40-00 Property Management - 311 9th St NE Ending Account Number: 501-001-000-508-91-00-00 Unassigned Cash and Investments - Ending Period: 2021 - February 2021 13 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-111-513-00-20-00 Benefits $1,108.44 $2,173.01 $26,000.00 8.36 %$23,826.99 001-000-111-513-00-30-00 Office Supplies $0.00 $0.00 $250.00 0.00 %$250.00 001-000-111-513-00-40-00 Newsletter Printing & Mailing $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-111-513-00-40-01 Training $0.00 $0.00 $2,500.00 0.00 %$2,500.00 001-000-111-513-00-40-02 Professional Services $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-111-513-00-40-03 Cell Phone $0.00 $0.00 $550.00 0.00 %$550.00 001-000-111-513-00-40-04 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-111-513-00-40-05 Insurance $15.62 $15.62 $8,500.00 0.18 %$8,484.38 001-000-111-513-00-40-06 Miscellaneous $0.00 $0.00 $250.00 0.00 %$250.00 Total Mayor's Office $3,272.15 $6,484.80 $176,050.00 3.68 %$169,565.20 Municipal Court 001-000-120-512-50-10-00 Salaries $19,085.34 $38,281.20 $262,000.00 14.61 %$223,718.80 001-000-120-512-50-12-00 Salaries - Probation Services $4,938.30 $9,876.60 $58,500.00 16.88 %$48,623.40 001-000-120-512-50-20-00 Benefits $5,926.60 $12,041.95 $89,000.00 13.53 %$76,958.05 001-000-120-512-50-22-00 Benefits - Probation Services $3,100.31 $6,330.55 $39,000.00 16.23 %$32,669.45 001-000-120-512-50-31-00 Office Supplies $0.00 $0.00 $3,500.00 0.00 %$3,500.00 001-000-120-512-50-31-01 Central Stores $1,184.96 $1,184.96 $0.00 ($1,184.96) 001-000-120-512-50-40-00 Training $40.00 $390.00 $1,500.00 26.00 %$1,110.00 001-000-120-512-50-40-01 IT Services $0.00 $0.00 $2,705.00 0.00 %$2,705.00 001-000-120-512-50-43-00 Travel $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-120-512-50-46-00 Insurance $62.49 $62.49 $15,860.00 0.39 %$15,797.51 001-000-120-512-50-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-50-49-01 Interpreting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-120-512-50-49-02 Judge Protems $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-120-512-50-49-03 Witness Fees $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-50-49-04 Juror Fees $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-120-512-50-49-09 Security $0.00 $306.25 $6,000.00 5.10 %$5,693.75 001-000-120-594-12-60-00 Capital Outlay $274.69 $274.69 $5,000.00 5.49 %$4,725.31 Total Municipal Court $34,612.69 $68,748.69 $501,065.00 13.72 %$432,316.31 Human Resources 001-000-139-518-10-10-00 Salaries $51.66 $103.31 $42,500.00 0.24 %$42,396.69 001-000-139-518-10-20-00 Benefits $23.20 $46.40 $19,000.00 0.24 %$18,953.60 001-000-139-518-10-30-00 Office Supplies $0.00 $0.00 $500.00 0.00 %$500.00 001-000-139-518-10-40-00 Training $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-139-518-10-40-01 Membership Dues & Publications $216.60 $216.60 $500.00 43.32 %$283.40 001-000-139-518-10-40-02 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-139-518-10-40-03 Advertising $602.42 $602.42 $1,000.00 60.24 %$397.58 001-000-139-518-10-40-04 Insurance $10.42 $10.42 $3,500.00 0.30 %$3,489.58 001-000-139-518-10-40-05 Repairs & Maintenance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-139-518-10-40-06 Miscellaneous $9.31 $9.31 $250.00 3.72 %$240.69 001-000-139-518-10-40-07 Pre-Employment Services $321.00 $321.00 $0.00 ($321.00) Total Human Resources $1,234.61 $1,309.46 $69,500.00 1.88 %$68,190.54 City Clerk 001-000-140-514-20-10-00 Salaries $11,362.06 $22,751.74 $97,500.00 23.34 %$74,748.26 001-000-140-514-20-20-00 Benefits $5,749.89 $11,763.41 $50,800.00 23.16 %$39,036.59 14 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-140-514-20-31-00 Office Supplies $64.97 $64.97 $3,000.00 2.17 %$2,935.03 001-000-140-514-20-31-01 Central Stores $424.09 $424.09 $5,500.00 7.71 %$5,075.91 001-000-140-514-20-40-00 Training $49.00 $49.00 $3,000.00 1.63 %$2,951.00 001-000-140-514-20-41-00 Membership Dues & Publications $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-140-514-20-43-00 Travel $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-140-514-20-44-00 Advertising $22.14 $22.14 $2,000.00 1.11 %$1,977.86 001-000-140-514-20-46-00 Insurance $10.42 $10.42 $7,300.00 0.14 %$7,289.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-48-01 Fireworks - DCFD Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-140-514-20-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 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 001-000-140-582-10-40-00 Fireworks - Deposit Refund $0.00 $0.00 $2,300.00 0.00 %$2,300.00 Total City Clerk $17,682.57 $35,085.77 $178,000.00 19.71 %$142,914.23 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $318.92 $318.92 $12,500.00 2.55 %$12,181.08 001-000-141-514-20-42-01 Telephone Line Charges $1,053.07 $2,441.57 $14,000.00 17.44 %$11,558.43 001-000-141-514-20-42-03 Postage $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-141-514-20-48-00 Repairs & Maintenance $0.00 $108.30 $4,000.00 2.71 %$3,891.70 Total Internal Services $1,371.99 $2,868.79 $36,500.00 7.86 %$33,631.21 Finance 001-000-142-514-20-10-00 Salaries $14,089.48 $28,790.45 $169,000.00 17.04 %$140,209.55 001-000-142-514-20-20-00 Benefits $5,890.31 $12,046.46 $70,000.00 17.21 %$57,953.54 001-000-142-514-20-31-00 Office Supplies $398.86 $398.86 $1,600.00 24.93 %$1,201.14 001-000-142-514-20-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 001-000-142-514-20-46-00 Insurance $31.25 $31.25 $12,282.00 0.25 %$12,250.75 001-000-142-514-23-20-00 State Audit $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-142-514-25-30-00 Bank Charges & Fees $483.07 $823.16 $4,500.00 18.29 %$3,676.84 001-000-142-514-40-20-00 Training $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Total Finance $20,892.97 $42,090.18 $289,382.00 14.54 %$247,291.82 Information Technology 001-000-145-514-20-10-00 Salaries $8,148.60 $16,357.74 $98,100.00 16.67 %$81,742.26 001-000-145-514-20-20-00 Benefits $3,779.11 $7,669.32 $45,500.00 16.86 %$37,830.68 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 $0.00 $100.00 0.00 %$100.00 001-000-145-514-20-40-05 Disaster Backup System Support $0.00 $0.00 $16,000.00 0.00 %$16,000.00 001-000-145-514-20-40-10 Annual Fee - GIS Systems $0.00 $0.00 $10,100.00 0.00 %$10,100.00 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $0.00 $0.00 $23,000.00 0.00 %$23,000.00 001-000-145-514-20-40-25 Annual License - Municipal Court $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.00 $6,085.00 $7,000.00 86.93 %$915.00 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-145-514-20-40-40 Annual Subscription - Website $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-145-514-20-40-50 Annual License - FTR Recording System $0.00 $0.00 $1,500.00 0.00 %$1,500.00 15 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-145-514-20-40-51 Annual License - Electronic Archive (Smarsh & Archive Social) $0.00 $2,396.36 $7,500.00 31.95 %$5,103.64 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $0.00 $0.00 $8,000.00 0.00 %$8,000.00 001-000-145-514-20-41-00 Professional Services $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-145-514-20-42-00 Cell Phone $0.00 $0.00 $850.00 0.00 %$850.00 001-000-145-514-20-43-00 Training $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-145-514-20-44-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-145-514-20-45-00 Insurance $20.83 $20.83 $3,000.00 0.69 %$2,979.17 001-000-145-594-14-60-20 Capital - PC Software Admin $1,642.25 $1,642.25 $33,000.00 4.98 %$31,357.75 001-000-145-594-14-60-25 Capital - PC Hardware Admin $6,631.44 $6,631.44 $32,000.00 20.72 %$25,368.56 Total Information Technology $20,222.23 $40,802.94 $334,650.00 12.19 %$293,847.06 Legal 001-000-151-515-31-10-00 Salaries $14,519.77 $29,162.86 $175,000.00 16.66 %$145,837.14 001-000-151-515-31-20-00 Benefits $6,014.81 $12,232.10 $72,000.00 16.99 %$59,767.90 001-000-151-515-31-20-10 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-151-515-31-25-00 Professional Services $0.00 $0.00 $10,000.00 0.00 %$10,000.00 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 $200.00 0.00 %$200.00 001-000-151-515-31-40-01 Legal Research $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-151-515-31-40-02 Membership Dues $0.00 $0.00 $30.00 0.00 %$30.00 001-000-151-515-31-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 001-000-151-515-31-46-00 Insurance $15.62 $15.62 $11,280.00 0.14 %$11,264.38 001-000-151-515-31-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Legal $20,550.20 $41,410.58 $284,210.00 14.57 %$242,799.42 Legal - Public Records 001-000-152-515-31-10-00 Salaries $2,028.25 $4,056.48 $25,000.00 16.23 %$20,943.52 001-000-152-515-31-20-00 Benefits $831.18 $1,662.36 $11,000.00 15.11 %$9,337.64 001-000-152-515-31-40-00 Training $0.00 $0.00 $300.00 0.00 %$300.00 001-000-152-515-31-40-01 Postage $0.00 $0.00 $25.00 0.00 %$25.00 001-000-152-515-31-40-02 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-152-515-31-40-03 Insurance $5.21 $5.21 $2,820.00 0.18 %$2,814.79 001-000-152-515-31-40-04 Self-Insurance $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Legal - Public Records $2,864.64 $5,724.05 $45,145.00 12.68 %$39,420.95 Civil Service 001-000-160-521-10-10-00 Salaries $260.00 $260.00 $3,300.00 7.88 %$3,040.00 001-000-160-521-10-46-00 Insurance $20.83 $20.83 $8,100.00 0.26 %$8,079.17 Total Civil Service $280.83 $280.83 $11,400.00 2.46 %$11,119.17 Central Services 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-180-518-30-35-00 Small Tools & Equipment $227.84 $227.84 $10,000.00 2.28 %$9,772.16 001-000-180-518-30-41-00 Professional Services $0.00 $0.00 $25,000.00 0.00 %$25,000.00 16 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-180-518-30-41-01 Contracted Custodial Services $2,426.74 $2,426.74 $32,000.00 7.58 %$29,573.26 001-000-180-518-30-46-00 Insurance $41.66 $41.66 $52,000.00 0.08 %$51,958.34 001-000-180-518-30-47-00 Utilities $2,111.62 $2,111.62 $30,000.00 7.04 %$27,888.38 001-000-180-518-30-48-00 Repairs & Maintenance $0.00 $0.00 $15,000.00 0.00 %$15,000.00 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 $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$1,272.72 $1,625.22 $9,000.00 18.06 %$7,374.78 001-000-180-594-18-60-00 Capital Outlay $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Central Services $6,080.58 $6,433.08 $186,000.00 3.46 %$179,566.92 Law Enforcement 001-000-210-521-10-10-00 Salaries $178,222.83 $359,111.75 $2,230,000.00 16.10 %$1,870,888.25 001-000-210-521-10-10-02 Overtime - Shift Coverage $17,719.75 $35,862.27 $140,000.00 25.62 %$104,137.73 001-000-210-521-10-10-03 Overtime Salaries - Traffic Safety $0.00 $0.00 $8,000.00 0.00 %$8,000.00 001-000-210-521-10-10-06 Overtime - Training $0.00 $0.00 $35,000.00 0.00 %$35,000.00 001-000-210-521-10-10-07 Overtime - Other $0.00 $0.00 $15,500.00 0.00 %$15,500.00 001-000-210-521-10-20-00 Benefits $58,892.08 $137,971.26 $841,000.00 16.41 %$703,028.74 001-000-210-521-10-20-01 Clothing Allowance $1,981.87 $1,981.87 $14,400.00 13.76 %$12,418.13 001-000-210-521-10-31-00 Office Supplies $623.98 $623.98 $8,500.00 7.34 %$7,876.02 001-000-210-521-10-31-05 Office Machine Costs $311.80 $311.80 $5,000.00 6.24 %$4,688.20 001-000-210-521-10-32-00 Fuel Consumed $3,442.93 $3,442.93 $55,000.00 6.26 %$51,557.07 001-000-210-521-10-35-00 Small Tools & Equipment $2,353.51 $4,041.44 $23,250.00 17.38 %$19,208.56 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 $2,207.65 $2,279.02 $15,000.00 15.19 %$12,720.98 001-000-210-521-10-41-01 Emergency Management Contract $0.00 $10,442.40 $44,000.00 23.73 %$33,557.60 001-000-210-521-10-41-02 Membership Dues $0.00 $0.00 $600.00 0.00 %$600.00 001-000-210-521-10-42-01 Telephone $3,554.77 $3,554.77 $30,000.00 11.85 %$26,445.23 001-000-210-521-10-42-03 Postage $111.63 $111.63 $1,175.00 9.50 %$1,063.37 001-000-210-521-10-43-00 Travel $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-210-521-10-46-00 Insurance $759.67 $759.67 $71,000.00 1.07 %$70,240.33 001-000-210-521-10-48-00 Repairs & Maintenance $367.13 $367.13 $9,500.00 3.86 %$9,132.87 001-000-210-521-10-49-00 Miscellaneous $481.64 $556.64 $1,000.00 55.66 %$443.36 001-000-210-521-10-49-02 Dry Cleaning Services $132.66 $132.66 $1,000.00 13.27 %$867.34 001-000-210-521-30-40-00 Crime Prevention $0.00 $0.00 $850.00 0.00 %$850.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 $0.00 $0.00 $4,500.00 0.00 %$4,500.00 001-000-210-521-40-27-00 Training - Office Staff $0.00 $0.00 $500.00 0.00 %$500.00 001-000-210-521-40-30-00 Training - Academy $0.00 $0.00 $3,200.00 0.00 %$3,200.00 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-548-60-40-00 Fleet Rentals - Police $14,735.42 $29,470.84 $177,000.00 16.65 %$147,529.16 001-000-210-594-21-60-00 Capital Outlay $7,791.27 $7,875.48 $33,000.00 23.87 %$25,124.52 Total Law Enforcement $293,690.59 $598,897.54 $3,788,375.00 15.81 %$3,189,477.46 Jail Services 17 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $380.25 $38,404.27 $456,500.00 8.41 %$418,095.73 001-000-230-523-60-20-00 Medical Care - Prisoners $0.00 $0.00 $9,000.00 0.00 %$9,000.00 001-000-230-527-60-30-00 Juvenile Detention $0.00 $0.00 $7,500.00 0.00 %$7,500.00 Total Jail Services $380.25 $38,404.27 $473,000.00 8.12 %$434,595.73 Public Works 001-000-315-542-10-10-00 Salaries $8,005.38 $16,070.28 $81,500.00 19.72 %$65,429.72 001-000-315-542-10-20-00 Benefits $3,754.69 $7,598.78 $37,500.00 20.26 %$29,901.22 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 $34.54 $34.54 $500.00 6.91 %$465.46 001-000-315-542-10-40-00 Cell Phone $0.00 $0.00 $750.00 0.00 %$750.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 $20.83 $20.83 $13,000.00 0.16 %$12,979.17 001-000-315-542-10-49-00 Training $171.00 $171.00 $2,000.00 8.55 %$1,829.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 $113.78 $113.78 $15,000.00 0.76 %$14,886.22 Total Public Works $12,100.22 $24,009.21 $153,500.00 15.64 %$129,490.79 Planning 001-000-580-558-60-10-00 Salaries $15,308.86 $32,015.99 $190,000.00 16.85 %$157,984.01 001-000-580-558-60-20-00 Benefits $5,463.82 $10,908.58 $62,000.00 17.59 %$51,091.42 001-000-580-558-60-31-00 Office Supplies $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-580-558-60-32-00 Fuel Consumed $0.00 $0.00 $175.00 0.00 %$175.00 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 $1,000.00 0.00 %$1,000.00 001-000-580-558-60-40-01 Dues & Subscriptions $692.00 $692.00 $1,250.00 55.36 %$558.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,000.00 0.00 %$1,000.00 001-000-580-558-60-43-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-580-558-60-44-00 Advertising $297.20 $297.20 $3,000.00 9.91 %$2,702.80 001-000-580-558-60-46-00 Insurance $41.66 $41.66 $13,440.00 0.31 %$13,398.34 001-000-580-558-60-48-00 Repairs & Maintenance $401.18 $401.18 $100.00 401.18 %($301.18) 001-000-580-558-60-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total Planning $22,204.72 $44,356.61 $302,165.00 14.68 %$257,808.39 Code Compliance 001-000-590-558-50-10-00 Salaries $7,390.44 $17,220.38 $109,000.00 15.80 %$91,779.62 001-000-590-558-50-20-00 Benefits $4,248.78 $8,609.15 $53,000.00 16.24 %$44,390.85 001-000-590-558-50-31-00 Office Supplies $0.00 $0.00 $300.00 0.00 %$300.00 001-000-590-558-50-32-00 Fuel Consumed $30.67 $30.67 $400.00 7.67 %$369.33 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-40-01 Dues & Subscriptions $95.00 $95.00 $275.00 34.55 %$180.00 001-000-590-558-50-41-01 Fire Marshal Services $0.00 $0.00 $22,145.00 0.00 %$22,145.00 001-000-590-558-50-42-00 Abatement $0.00 $0.00 $15,000.00 0.00 %$15,000.00 001-000-590-558-50-43-00 Travel $0.00 $0.00 $300.00 0.00 %$300.00 18 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-46-00 Insurance $20.83 $20.83 $10,690.00 0.19 %$10,669.17 001-000-590-558-50-48-00 Repairs & Maintenance $1,042.49 $1,042.49 $1,000.00 104.25 %($42.49) 001-000-590-558-50-49-00 Miscellaneous $0.00 $0.00 $150.00 0.00 %$150.00 Total Code Compliance $12,828.21 $27,018.52 $212,660.00 12.71 %$185,641.48 Other Expenditures 001-001-000-589-00-00-01 Fireworks - Deposit Refund $0.00 $0.00 $2,300.00 0.00 %$2,300.00 001-001-000-589-00-00-02 Fireworks - DCFD Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-001-000-589-00-00-03 County Share of Crime Victims $607.83 $607.83 $3,500.00 17.37 %$2,892.17 001-001-000-589-00-00-04 Remittance: State Building Code Surcharge $44.50 $44.50 $650.00 6.85 %$605.50 001-001-000-589-00-00-05 State Share of Permits & Licenses $1,632.50 $1,978.25 $10,000.00 19.78 %$8,021.75 001-001-000-589-00-00-06 Court Remittances $8,935.19 $8,935.19 $150,000.00 5.96 %$141,064.81 Total Other Expenditures $11,220.02 $11,565.77 $166,700.00 6.94 %$155,134.23 Total General Fund $582,809.51 $1,166,810.94 $8,450,197.00 13.81 %$7,283,386.06 Street Fund 101-000-420-542-30-10-00 Salaries - Roadway $639.63 $1,327.53 $64,500.00 2.06 %$63,172.47 101-000-420-542-30-20-00 Benefits - Roadway $250.26 ($607.64)$34,000.00 -1.79 %$34,607.64 101-000-420-542-30-30-00 Supplies - Roadway $133.04 $133.04 $50,000.00 0.27 %$49,866.96 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 $0.00 $3.15 $2,400.00 0.13 %$2,396.85 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 $685.65 $685.65 $2,000.00 34.28 %$1,314.35 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $158.17 $194.58 $1,000.00 19.46 %$805.42 101-000-420-542-62-30-00 Supplies - Special Purpose Paths $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-63-10-00 Salaries - Street Lighting $101.08 $733.41 $2,000.00 36.67 %$1,266.59 101-000-420-542-63-20-00 Benefits - Street Lighting $20.84 $606.89 $1,200.00 50.57 %$593.11 101-000-420-542-63-30-00 Supplies - Street Lighting $0.00 $0.00 $500.00 0.00 %$500.00 101-000-420-542-63-47-00 Utilities - Street Lighting $1,908.00 $1,908.00 $60,000.00 3.18 %$58,092.00 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 $0.00 $453.05 $35,000.00 1.29 %$34,546.95 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $0.00 $268.83 $18,600.00 1.45 %$18,331.17 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $1,584.68 $1,596.69 $48,000.00 3.33 %$46,403.31 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $407.73 $407.73 $9,000.00 4.53 %$8,592.27 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $0.00 $0.00 $14,000.00 0.00 %$14,000.00 101-000-420-542-65-10-00 Salaries - Parking Facilities $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-65-20-00 Benefits - Parking Facilities $0.00 $0.00 $500.00 0.00 %$500.00 101-000-420-542-65-30-00 Supplies - Parking Facilities $4.72 $4.72 $0.00 ($4.72) 101-000-420-542-65-47-00 Utilities - Parking Facilities $0.00 $0.00 $700.00 0.00 %$700.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $2,282.04 $7,702.44 $60,000.00 12.84 %$52,297.56 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $1,973.70 $5,684.01 $35,000.00 16.24 %$29,315.99 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $2,295.09 $2,295.09 $100,000.00 2.30 %$97,704.91 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $871.24 $871.24 $5,000.00 17.42 %$4,128.76 19 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-69-10-00 Salaries - Flags/Banners $0.00 $657.23 $20,000.00 3.29 %$19,342.77 101-000-420-542-69-20-00 Benefits - Flags/Banners $0.00 $219.41 $12,000.00 1.83 %$11,780.59 101-000-420-542-69-30-00 Supplies - Flags/Banners $68.97 $68.97 $2,000.00 3.45 %$1,931.03 101-000-420-542-70-10-00 Salaries - Roadside $19,168.95 $43,612.99 $240,000.00 18.17 %$196,387.01 101-000-420-542-70-20-00 Benefits - Roadside $9,656.49 $24,459.68 $130,000.00 18.82 %$105,540.32 101-000-420-542-70-30-00 Supplies - Roadside $190.34 $190.34 $5,000.00 3.81 %$4,809.66 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 $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-70-48-00 Repairs & Maintenance - Roadside $4.32 $4.32 $1,000.00 0.43 %$995.68 101-000-420-542-75-10-00 Salaries - City Parks $3,949.06 $8,040.29 $45,000.00 17.87 %$36,959.71 101-000-420-542-75-20-00 Benefits - City Parks $2,135.05 $4,951.64 $23,000.00 21.53 %$18,048.36 101-000-420-542-75-30-00 Supplies - City Parks $1,337.31 $1,770.50 $15,000.00 11.80 %$13,229.50 101-000-420-542-75-47-00 Utilities - City Parks $1,350.45 $1,350.45 $5,000.00 27.01 %$3,649.55 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $53.65 $53.65 $4,000.00 1.34 %$3,946.35 101-000-430-543-30-10-00 Salaries - General Services $2,207.22 $5,026.65 $0.00 ($5,026.65) 101-000-430-543-30-20-00 Benefits - General Services $1,248.30 $2,065.90 $0.00 ($2,065.90) 101-000-430-543-30-30-00 Supplies - General Services $390.19 $390.19 $6,000.00 6.50 %$5,609.81 101-000-430-543-30-46-00 Insurance $270.99 $270.99 $55,000.00 0.49 %$54,729.01 101-000-430-543-30-49-00 Miscellaneous - General Services $33.99 $728.99 $3,000.00 24.30 %$2,271.01 101-000-430-543-50-10-00 Salaries - Facilities $0.00 $52.78 $4,000.00 1.32 %$3,947.22 101-000-430-543-50-20-00 Benefits - Facilities $0.00 $36.54 $1,800.00 2.03 %$1,763.46 101-000-430-543-50-30-00 Supplies - Facilities $93.11 $93.11 $2,000.00 4.66 %$1,906.89 101-000-430-543-50-42-01 Cell Phone $0.00 $0.00 $750.00 0.00 %$750.00 101-000-430-543-50-47-00 Utilities - Facilities $875.29 $875.29 $6,500.00 13.47 %$5,624.71 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 $88.06 $243.14 $7,000.00 3.47 %$6,756.86 101-000-430-544-90-20-00 Benefits - Training $18.16 $147.61 $3,500.00 4.22 %$3,352.39 101-000-430-544-90-30-00 Supplies - Training $0.00 $0.00 $500.00 0.00 %$500.00 101-000-430-544-90-35-00 Travel $0.00 $0.00 $4,000.00 0.00 %$4,000.00 101-000-430-544-90-49-01 Training $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-430-548-60-40-00 Fleet Rentals - Streets $14,049.23 $28,098.46 $169,000.00 16.63 %$140,901.54 Total Street Fund $70,505.00 $147,677.53 $1,332,450.00 11.08 %$1,184,772.47 Community Development Grants Fund 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $0.00 $72,164.00 0.00 %$72,164.00 102-000-000-558-70-44-00 CDBG Advertising $416.16 $416.16 $1,800.00 23.12 %$1,383.84 102-000-000-558-70-45-00 CDBG Travel $0.00 $0.00 $700.00 0.00 %$700.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 $416.16 $416.16 $74,764.00 0.56 %$74,347.84 Transportation Benefit District Fund 105-000-000-595-90-61-00 Pavement Ratings $0.00 $0.00 $6,000.00 0.00 %$6,000.00 105-000-000-597-91-00-00 Transfer-Out to Fund 301 $0.00 $0.00 $190,000.00 0.00 %$190,000.00 Total Transportation Benefit District Fund $0.00 $0.00 $196,000.00 0.00 %$196,000.00 Library Fund 112-000-000-572-50-47-00 Facilities - Utilities $359.79 $359.79 $6,500.00 5.54 %$6,140.21 Total Library Fund $359.79 $359.79 $6,500.00 5.54 %$6,140.21 20 of 26 Account Number Title Period Fiscal Budget % of Total Balance Hotel/Motel Tax Fund 113-000-000-557-30-41-05 Wenatchee Valley Chamber $0.00 $0.00 $45,000.00 0.00 %$45,000.00 113-000-000-557-30-41-10 Contributions to Other Entities $0.00 $0.00 $50,000.00 0.00 %$50,000.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $5,062.00 $10,124.00 $61,000.00 16.60 %$50,876.00 113-001-000-597-00-00-01 Transfer-Out to Fund 117 $0.00 $0.00 $120,000.00 0.00 %$120,000.00 Total Hotel/Motel Tax Fund $5,062.00 $10,124.00 $276,000.00 3.67 %$265,876.00 Criminal Justice Fund 116-000-000-597-21-00-20 Transfer Out - ER&R Fund $0.00 $0.00 $25,000.00 0.00 %$25,000.00 Total Criminal Justice Fund $0.00 $0.00 $25,000.00 0.00 %$25,000.00 Events Board Fund 117-000-050-557-30-10-00 Salaries $4,326.29 $10,850.75 $60,000.00 18.08 %$49,149.25 117-000-050-557-30-20-00 Benefits $4,480.73 $7,312.38 $29,000.00 25.22 %$21,687.62 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $0.00 $3,000.00 0.00 %$3,000.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 $12.95 $600.00 2.16 %$587.05 117-000-100-557-30-42-00 Cell Phone $0.00 $0.00 $760.00 0.00 %$760.00 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 $41.66 $41.66 $10,360.00 0.40 %$10,318.34 117-000-115-557-30-31-05 Office Supplies $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-300-557-30-31-12 Classy Chassis Office Supplies $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-300-557-30-34-11 Classy Chassis Event Merch For Resale $0.00 $0.00 $2,500.00 0.00 %$2,500.00 117-000-300-557-30-41-12 CC - Professional Services $0.00 $0.00 $2,300.00 0.00 %$2,300.00 117-000-300-557-30-42-14 CC - Postage $0.00 $0.00 $800.00 0.00 %$800.00 117-000-300-557-30-43-12 CC - EMPD Facility Fee $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-300-557-30-44-12 CC - Advertising $0.00 $0.00 $3,000.00 0.00 %$3,000.00 117-000-300-557-30-49-12 CC - Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-557-30-31-11 Wings & Wheels Office Supplies $0.00 $0.00 $700.00 0.00 %$700.00 117-000-400-557-30-34-11 W&W Event Merch For Resale $0.00 $0.00 $1,500.00 0.00 %$1,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 $800.00 0.00 %$800.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 $0.00 $5,000.00 0.00 %$5,000.00 117-000-400-557-30-44-15 W&W Prizes $0.00 $0.00 $250.00 0.00 %$250.00 117-000-400-557-30-49-11 W&W - Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.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-500-557-00-31-01 Christmas Office Supplies $0.00 $0.00 $500.00 0.00 %$500.00 117-000-500-557-30-35-01 Christmas - Small Tools & Equipment $0.00 $0.00 $150.00 0.00 %$150.00 117-000-500-557-30-40-05 Christmas - Events & Decorations $21.61 $21.61 $5,000.00 0.43 %$4,978.39 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 $3.99 $3.99 $750.00 0.53 %$746.01 117-000-500-557-30-49-01 Christmas - Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Events Board Fund $8,887.23 $18,243.34 $143,570.00 12.71 %$125,326.66 Bond Redemption Fund 21 of 26 Account Number Title Period Fiscal Budget % of Total Balance 202-000-000-591-95-70-00 Principal - PWTFL 10th St. NE $0.00 $0.00 $165,000.00 0.00 %$165,000.00 202-000-000-592-48-80-00 Interest - 2021 LTGO Bond (Public Works Area) $0.00 $0.00 $75,000.00 0.00 %$75,000.00 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $0.00 $0.00 $8,500.00 0.00 %$8,500.00 Total Bond Redemption Fund $0.00 $0.00 $248,500.00 0.00 %$248,500.00 Street Improvements Fund 301-000-000-595-10-40-02 Design - TIB N. Kentucky Overlay $0.00 $0.00 $79,500.00 0.00 %$79,500.00 301-000-000-595-10-40-03 Design - TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $96,300.00 0.00 %$96,300.00 301-000-000-595-10-40-04 Design - Grant Rd/Highline Dr Intersection Improvements $0.00 $0.00 $58,000.00 0.00 %$58,000.00 301-000-000-595-10-40-05 Design - Hamilton Ave Reconstruction $0.00 $0.00 $70,000.00 0.00 %$70,000.00 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $6,189.75 $6,189.75 $155,000.00 3.99 %$148,810.25 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $5,370.75 $5,370.75 $170,000.00 3.16 %$164,629.25 301-000-000-595-10-40-26 Design - PWTFL - 10th St $37,505.65 $37,505.65 $55,000.00 68.19 %$17,494.35 301-000-000-595-20-60-02 ROW - SRTS - 5th St. Kenroy $0.00 $0.00 $105,000.00 0.00 %$105,000.00 301-000-000-595-20-60-03 ROW - SRTS - 5th St. Sterling $0.00 $0.00 $90,000.00 0.00 %$90,000.00 301-000-000-595-30-40-42 SDC - 10th St. NE Improvements $0.00 $0.00 $300,000.00 0.00 %$300,000.00 301-000-000-595-30-60-03 SDC - TIB N. Kentucky Overlay $0.00 $0.00 $53,000.00 0.00 %$53,000.00 301-000-000-595-30-60-04 Construction - TIB N. Kentucky Overlay $0.00 $0.00 $662,500.00 0.00 %$662,500.00 301-000-000-595-30-60-05 Construction - 10th St. NE Improvements $0.00 $0.00 $3,340,000.00 0.00 %$3,340,000.00 301-000-000-595-30-60-06 2021 Residential Overlay $0.00 $0.00 $190,000.00 0.00 %$190,000.00 301-000-000-595-61-60-00 TIB Complete Streets - Grant/Georgia Crossing $140.06 $140.06 $0.00 ($140.06) 301-000-000-595-61-60-01 TIB Complete Streets - Grant/June Crossing $5,249.28 $5,249.28 $0.00 ($5,249.28) 301-000-000-595-61-60-02 TIB Complete Streets - 3rd St. Sidewalk $2,147.29 $2,147.29 $0.00 ($2,147.29) 301-000-000-595-64-40-01 Design - 9th/VMP Intersection $3,634.99 $3,634.99 $71,000.00 5.12 %$67,365.01 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 301-000-000-595-90-10-00 Street Improvements Staff Salaries $0.00 $0.00 $22,300.00 0.00 %$22,300.00 301-000-000-595-90-20-00 Street Improvements Staff Benefits $0.00 $0.00 $11,000.00 0.00 %$11,000.00 301-000-000-597-95-00-25 Transfer Out to General Fund $0.00 $0.00 $500,000.00 0.00 %$500,000.00 Total Street Improvements Fund $60,237.77 $60,237.77 $6,916,700.00 0.87 %$6,856,462.23 Capital Improvements Fund 314-000-000-594-22-60-50 Maintenance Facilities Design $0.00 $0.00 $182,000.00 0.00 %$182,000.00 314-000-000-594-48-60-00 Maintenance Facilities Construction $0.00 $0.00 $1,000,000.00 0.00 %$1,000,000.00 314-001-000-597-00-00-01 Transfer-Out to 301 Fund $0.00 $0.00 $250,000.00 0.00 %$250,000.00 Total Capital Improvements Fund $0.00 $0.00 $1,432,000.00 0.00 %$1,432,000.00 Stormwater Fund 401-000-000-597-00-00-00 Transfer-Out - Fund 301 $0.00 $0.00 $728,000.00 0.00 %$728,000.00 Stormwater Utility Admin 401-000-001-531-00-10-00 Salaries - Stormwater Admin $1,201.83 $3,042.15 $30,000.00 10.14 %$26,957.85 401-000-001-531-00-20-00 Benefits - Stormwater Admin $247.81 $934.11 $13,200.00 7.08 %$12,265.89 401-000-001-531-00-30-00 Supplies - Stormwater Admin $0.00 $0.00 $500.00 0.00 %$500.00 22 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 $0.00 $750.00 0.00 %$750.00 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 $41.66 $41.66 $6,500.00 0.64 %$6,458.34 401-000-001-531-00-40-03 City Stormwater Utility Charge $0.00 $0.00 $165,000.00 0.00 %$165,000.00 401-000-001-531-00-40-04 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-531-00-40-05 Training - Stormwater Admin $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-001-531-00-40-06 Travel - Stormwater Admin $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-548-60-40-00 Fleet Rentals - Stormwater $4,741.01 $9,482.02 $70,000.00 13.55 %$60,517.98 Total Stormwater Utility Admin $6,232.31 $13,499.94 $297,450.00 4.54 %$283,950.06 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $1,535.52 $3,241.59 $25,000.00 12.97 %$21,758.41 401-000-002-531-00-20-01 Benefits - NPDES Admin $512.09 $1,084.88 $11,000.00 9.86 %$9,915.12 401-000-002-531-00-40-00 Training - NPDES Admin $0.00 $0.00 $500.00 0.00 %$500.00 401-000-002-531-00-40-02 Repairs & Maint. - NPDES Admin $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-002-531-00-40-03 Aerial Pictometry - NPDES Admin $0.00 $0.00 $4,000.00 0.00 %$4,000.00 401-000-002-531-00-40-04 Municipal Stormwater Permit Fee $0.00 $0.00 $8,000.00 0.00 %$8,000.00 Total NPDES Admin $2,047.61 $4,326.47 $49,500.00 8.74 %$45,173.53 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 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 $3,000.00 0.00 %$3,000.00 401-000-005-531-00-20-04 Benefits - NPDES IDDE $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-005-531-00-30-04 Supplies - NPDES IDDE $0.00 $0.00 $3,000.00 0.00 %$3,000.00 Total NPDES IDDE $0.00 $0.00 $7,000.00 0.00 %$7,000.00 NPDES Construction 401-000-006-531-00-10-05 Salaries - NPDES Construction $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-006-531-00-20-05 Benefits - NPDES Construction $0.00 $13.90 $600.00 2.32 %$586.10 Total NPDES Construction $0.00 $13.90 $2,100.00 0.66 %$2,086.10 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $63.98 $216.09 $1,500.00 14.41 %$1,283.91 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $32.66 $65.07 $600.00 10.85 %$534.93 Total NPDES Post Construction $96.64 $281.16 $2,100.00 13.39 %$1,818.84 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $4,452.80 $7,541.29 $73,000.00 10.33 %$65,458.71 401-000-008-531-00-10-08 Salaries - Sweeping $3,547.43 $4,003.52 $22,000.00 18.20 %$17,996.48 23 of 26 Account Number Title Period Fiscal Budget % of Total Balance 401-000-008-531-00-20-07 Benefits - NPDES PPGH $2,365.16 $4,366.28 $29,200.00 14.95 %$24,833.72 401-000-008-531-00-20-08 Benefits - Sweeping $1,707.98 $2,032.11 $11,000.00 18.47 %$8,967.89 401-000-008-531-00-30-05 Supplies - NPDES PPGH $0.00 $0.00 $20,000.00 0.00 %$20,000.00 401-000-008-531-00-30-06 Irrigation Supplies $0.00 $0.00 $3,000.00 0.00 %$3,000.00 401-000-008-531-00-30-07 Fuel $88.59 $88.59 $7,000.00 1.27 %$6,911.41 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $1,272.57 $1,241.73 $5,000.00 24.83 %$3,758.27 401-000-008-531-00-40-05 Rental Equipment $0.00 $0.00 $25,000.00 0.00 %$25,000.00 401-000-008-531-00-40-06 Utilities $18.19 $18.19 $5,000.00 0.36 %$4,981.81 401-000-008-531-00-40-07 Decant Facility Tipping Fee $0.00 $0.00 $100,000.00 0.00 %$100,000.00 401-000-008-531-00-40-08 Decant Facility Admin. Charge $0.00 $0.00 $2,400.00 0.00 %$2,400.00 Total NPDES PPGH $13,452.72 $19,291.71 $302,600.00 6.38 %$283,308.29 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-03 Devon Pond $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Capital Outlay $0.00 $0.00 $10,000.00 0.00 %$10,000.00 401-000-011-594-31-60-04 19th Stormwater Facility Design $0.00 $0.00 $100,000.00 0.00 %$100,000.00 401-000-012-594-31-60-05 Small Improvements Projects $0.00 $0.00 $25,000.00 0.00 %$25,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 $407.18 $407.18 $70,000.00 0.58 %$69,592.82 Total Stormwater Fund $22,236.46 $37,820.36 $1,676,050.00 2.26 %$1,638,229.64 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $1,455.29 $1,627.74 $5,300.00 30.71 %$3,672.26 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $839.20 $923.00 $2,800.00 32.96 %$1,877.00 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $8,829.76 $8,970.62 $35,000.00 25.63 %$26,029.38 501-000-000-542-90-10-00 Street Vehicle Repair Labor $3,699.15 $6,362.90 $24,000.00 26.51 %$17,637.10 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $1,640.51 $2,947.67 $12,000.00 24.56 %$9,052.33 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $2,522.20 $2,795.76 $23,000.00 12.16 %$20,204.24 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $101.39 $101.39 $5,000.00 2.03 %$4,898.61 501-000-000-542-90-48-30 Street Equipment Repairs $0.00 $0.00 $1,500.00 0.00 %$1,500.00 501-000-000-548-60-10-00 Stormwater Vehicle R & M Labor $0.00 $0.00 $2,000.00 0.00 %$2,000.00 501-000-000-548-60-20-00 Stormwater Vehicle R & M Benefits $0.00 $0.00 $1,000.00 0.00 %$1,000.00 501-000-000-548-60-30-00 Stormwater Vehicle R & M $0.00 $0.00 $1,500.00 0.00 %$1,500.00 501-000-000-594-21-60-00 Capital - Police Vehicles $117,981.00 $117,981.00 $176,000.00 67.03 %$58,019.00 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $0.00 $208,000.00 0.00 %$208,000.00 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $0.00 $15,000.00 0.00 %$15,000.00 Total Equipment Purchase, Repair & Replacement Fund $137,068.50 $141,710.08 $512,100.00 27.67 %$370,389.92 Grand Totals $887,582.42 $1,583,399.97 $21,289,831.00 7.44 %$19,706,431.03 24 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $582,809.51 $1,166,810.94 $8,450,197.00 13.81 %$7,283,386.06 101-000-000-000-00-00-00 Street Fund $70,505.00 $147,677.53 $1,332,450.00 11.08 %$1,184,772.47 102-000-000-000-00-00-00 Community Development Grants Fund $416.16 $416.16 $74,764.00 0.56 %$74,347.84 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $0.00 $196,000.00 0.00 %$196,000.00 112-000-000-000-00-00-00 Library Fund $359.79 $359.79 $6,500.00 5.54 %$6,140.21 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $5,062.00 $10,124.00 $276,000.00 3.67 %$265,876.00 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $0.00 $25,000.00 0.00 %$25,000.00 117-000-000-000-00-00-00 Events Board Fund $8,887.23 $18,243.34 $143,570.00 12.71 %$125,326.66 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $0.00 $248,500.00 0.00 %$248,500.00 301-000-000-000-00-00-00 Street Improvements Fund $60,237.77 $60,237.77 $6,916,700.00 0.87 %$6,856,462.23 314-000-000-000-00-00-00 Capital Improvements Fund $0.00 $0.00 $1,432,000.00 0.00 %$1,432,000.00 401-000-000-000-00-00-00 Stormwater Fund $22,236.46 $37,820.36 $1,676,050.00 2.26 %$1,638,229.64 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $137,068.50 $141,710.08 $512,100.00 27.67 %$370,389.92 Grand Totals $887,582.42 $1,583,399.97 $21,289,831.00 7.44 %$19,706,431.03 25 of 26 Beginning Activity Activity Ending February 2020 Variance Cash In Out Cash Ending Cash (Decrease)/Increase 001 $3,338,907.76 $683,611.82 $1,166,810.94 $2,855,708.64 $2,594,591.90 $261,116.74 101 $248,197.36 $312,843.66 $147,677.53 $413,363.49 $446,971.37 ($33,607.88) 102 $40,324.38 $35,000.00 $416.16 $74,908.22 $77,431.47 ($2,523.25) 103 $13,494.91 $7,310.77 $0.00 $20,805.68 $0.00 $20,805.68 105 $433,896.56 $38,332.80 $0.00 $472,229.36 $369,734.78 $102,494.58 110 $0.00 $0.00 $0.00 $0.00 $660,000.00 ($660,000.00) 112 $14,744.33 $0.00 $359.79 $14,384.54 $11,063.96 $3,320.58 113 $162,733.87 $36,689.79 $10,124.00 $189,299.66 $133,677.78 $55,621.88 114 $1,537.63 $2.00 $0.00 $1,539.63 $1,516.60 $23.03 116 $2,870.61 $4,995.13 $0.00 $7,865.74 $51,973.88 ($44,108.14) 117 $18,767.92 $0.00 $18,243.34 $524.58 $35,124.11 ($34,599.53) 202 $775,826.60 $0.00 $0.00 $775,826.60 $8,668.69 $767,157.91 301 $262,409.25 $43,861.76 $60,237.77 $246,033.24 $953,031.38 ($706,998.14) 308 $0.00 $0.00 $0.00 $0.00 $66,058.66 ($66,058.66) 314 $1,362,383.49 $84,446.32 $0.00 $1,446,829.81 $1,237,680.30 $209,149.51 401 $2,166,740.88 $1,280.10 $37,820.36 $2,130,200.62 $2,582,049.22 ($451,848.60) 501 $39,111.03 $441,051.32 $141,710.08 $338,452.27 $405,708.05 ($67,255.78) $8,881,946.58 $1,689,425.47 $1,583,399.97 $8,987,972.08 $9,635,282.15 ($647,310.07) Events Board Fund Bond Redemption Fund Equipment Purchase, Repair & Replacement Fund Capital Improvements Fund Stormwater Fund Financing Reserves Fund Storm Water Improvements Fund Cash and Investment Activity Period: 2021 - February 2021 Fiscal Totals Fund Street Fund General Fund Transportation Benefit District Fund Community Development Grants Fund Affordable Housing Sales Tax Fund Drug Fund Criminal Justice Fund Library Fund Hotel/Motel Tax Fund Street Improvements Fund 26 of 26