Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2022 - February 2022 Financial Report - Josh DeLay, Finance Director
City of East Wenatchee April 19, 2022, City Council Meeting February 2022 Financial Report Date: April 19, 2022 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: February 2022 Financial Report This report provides a summary of the City’s overall financial operations through February 28, 2022. 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, 2022, compared to revenue collections through February 28, 2021, along with the respective dollar and percentage variances for its operating funds. Table 1 February 28, 2022 February 28, 2021 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 808,524 1,032,791 (224,267) (21.71%) Street Fund - 101 595,033 312,844 282,189 90.20% Events Board Fund - 117 275 - 275 - Equipment R&R Fund - 501 87,531 67,051 20,480 30.54% Total Revenues - Operating Funds 1,491,363 1,412,686 78,677 5.57% Revenues - Operating Funds CITY OF EAST WENATCHEE Finance Department 271 9th Street NE * East Wenatchee, WA 98802 P: (509) 886-6101 * F: (509) 884-6233 Email: jdelay@eastwenatcheewa.gov City of East Wenatchee April 19, 2022, City Council Meeting February 2022 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, 2022, compared to revenue collections through February 28, 2021, along with the respective dollar and percentage variances for its non-operating funds. City of East Wenatchee April 19, 2022, City Council Meeting February 2022 Financial Report Table 2 February 28, 2022 February 28, 2021 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - 35,000 (35,000) (100.00%) Affordable Housing Tax Fund - 103 7,553 7,311 243 3.32% Housing & Related Services Fund - 104 105,408 - 105,408 - Trans Benefit District Fund - 105 33,205 38,333 (5,128) (13.38%) SWAT Fund - 107 45,000 - 45,000 - Library Fund - 112 - - - - Hotel/Motel Tax Fund - 113 61,545 36,690 24,855 67.74% Drug Fund - 114 6 2 4 212.50% Criminal Justice Fund - 116 5,376 4,995 381 7.62% Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 355,079 43,862 311,218 709.54% Capital Improvements Fund - 314 85,017 84,446 571 0.68% Storm Water Fund - 401 44,581 1,280 43,301 3382.59% Total Revenues - Non-Operating Funds 742,771 251,919 490,852 194.85% 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 City of East Wenatchee April 19, 2022, City Council Meeting February 2022 Financial Report Revenue Highlights: General Fund revenues are down $224,267, or 21.71%, year over year due to a $248,012 decrease in sales tax allocated to this fund because of normal year over year allocation variances. This will normalize throughout the rest of the fiscal year. Sales tax is up overall for 2022 by 2.1%. Street Fund revenues are up $282,189, or 90.20%, year over year due a $276,048 greater sales tax allocation to this fund now versus last year. Gas tax is up $5,228, or 14.11%, year over year. Equipment R&R Fund revenues are up $20,480, or 30.54%, 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 and managed by the Public Works Department. Community Development Grants Fund revenues are down $35,000 year over year due to the timing of projects and reimbursements associated with these federal grant funds. SWAT Fund revenues are up $45,000 year over year because this is a new fund managed by the City for the regional SWAT team. Hotel/Motel Tax Fund revenues are up $24,855, or 67.74%, year over year presumably due to an increase in hotel stays in the City. Street Improvements Fund revenues are up $311,218, or 709.54%, year over year due to the normal timing differences of projects associated with this fund. Storm Water Fund revenues are up $43,301, or 3,382.59%, year over year because of the timing of the receipt of a reimbursement from the Department of Ecology for the City’s stormwater comp plan update. Table 3 below shows the City’s expenditures through February 28, 2022, compared to expenditures through February 28, 2021, along with respective dollar and percentage variances for its operating funds. Table 3 February 28, 2022 February 28, 2021 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 1,270,628 1,166,769 103,859 8.90% Street Fund - 101 203,956 147,678 56,279 38.11% Events Board Fund - 117 15,259 18,243 (2,985) (16.36%) Equipment R&R Fund - 501 9,001 141,710 (132,709) (93.65%) Total Expenditures - Operating Funds 1,498,844 1,474,400 24,444 1.66% Expenditures - Operating Funds Chart 3 is a graphical representation of year over year expenditure comparisons for the City’s operating funds. City of East Wenatchee April 19, 2022, City Council Meeting February 2022 Financial Report Chart 3 Table 4 below shows the City’s expenditures through February 28, 2022, compared to expenditures through February 28, 2021, along with respective dollar and percentage variances for its non-operating funds. Table 4 February 28, 2022 February 28, 2021 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - 416 (416) (100.00%) Affordable Housing Tax Fund - 103 - - - - Housing & Related Services Fund - 104 - - - - Trans Benefit District Fund - 105 - - - - SWAT Fund - 107 - - - - Library Fund - 112 147 360 (213) (59.26%) Hotel/Motel Tax Fund - 113 10,124 10,124 - 0.00% Drug Fund - 114 221 - 221 - Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 3,318 60,238 (56,920) (94.49%) Capital Improvements Fund - 314 32,635 - 32,635 - Storm Water Fund - 401 14,249 37,820 (23,571) (62.32%) Total Expenditures - Non-Operating Funds 60,694 108,958 (48,264) (44.30%) Expenditures - Non-Operating Funds City of East Wenatchee April 19, 2022, City Council Meeting February 2022 Financial Report Chart 4 is a graphical representation of year over year expenditure comparisons for the City’s non-operating funds. Chart 4 Expenditure Highlights: General Fund expenditures are up $103,859, or 8.90%, year over year primarily due to general overall salary and benefit increases, and an increase in fleet rental costs for the Police Department based on the Street Fund expenditures are up $56,279, or 38.11%, year over year primarily due to salary and benefit increases, and expenses related to the removal of snow from the massive snow storm our area endured. Equipment R&R Fund expenditures are down $132,709, or 93.65%, year over year due to the timing of the purchase of new police cruisers compared to when they were purchased last year. City of East Wenatchee April 19, 2022, City Council Meeting February 2022 Financial Report Street Improvements Fund expenditures are down $56,920, or 94.49%, year over year due to typical timing and project size variances associated with the capital projects in this 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, 2022. 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 $6,969.37 $1,318,200.00 0.53 %$1,311,230.63 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $325,988.36 $325,988.36 $3,850,000.00 8.47 %$3,524,011.64 001-000-000-313-71-00-00 Criminal Justice Sales Tax $55,526.28 $103,469.60 $307,277.00 33.67 %$203,807.40 001-000-000-316-40-00-00 Electric Utility Tax $46,923.95 $79,381.11 $360,230.00 22.04 %$280,848.89 001-000-000-316-45-00-00 Natural Gas Utility Tax $5,993.41 $5,993.41 $35,409.00 16.93 %$29,415.59 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $6,409.62 $16,913.66 $180,000.00 9.40 %$163,086.34 001-000-000-316-84-00-00 Gambling Tax $0.00 $127,447.32 $329,394.00 38.69 %$201,946.68 Total Taxes $440,841.62 $666,162.83 $6,380,510.00 10.44 %$5,714,347.17 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 $74.00 $372.00 $800.00 46.50 %$428.00 001-000-000-321-91-00-50 Franchise Fees - Cable $22,452.89 $22,452.89 $91,692.00 24.49 %$69,239.11 001-000-000-321-91-00-60 Franchise Fees - Fiber Optics $0.00 $4,000.00 $0.00 ($4,000.00) 001-000-000-321-99-00-00 Business Licenses & Permits $13,641.34 $27,225.84 $103,970.00 26.19 %$76,744.16 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 $97.75 $1,402.50 $100,000.00 1.40 %$98,597.50 001-000-000-322-90-01-00 Gun Permits $482.00 $1,067.25 $5,741.00 18.59 %$4,673.75 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $125.00 0.00 %$125.00 Total Licenses and Permits $36,747.98 $56,520.48 $303,488.00 18.62 %$246,967.52 001-000-000-330-00-00-00 ESD SRO Reimbursement $0.00 $0.00 $60,000.00 0.00 %$60,000.00 001-000-000-331-21-00-00 American Rescue Plan Funds $0.00 $0.00 $1,528,692.00 0.00 %$1,528,692.00 001-000-000-334-01-20-00 WaState Court Equip Reimb $0.00 $18,000.00 $0.00 ($18,000.00) 001-000-000-334-03-51-03 TSC - Seatbelt Emphasis Patrols $0.00 $0.00 $864.00 0.00 %$864.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $0.00 $0.00 $2,663.00 0.00 %$2,663.00 001-000-000-334-03-51-12 TSC - DUI Emphasis Patrol $0.00 $0.00 $2,702.00 0.00 %$2,702.00 001-000-000-334-06-91-00 WA ST Office of Public Defense $0.00 $0.00 $18,000.00 0.00 %$18,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-00-98-03 City Assistance $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $592.74 $2,000.00 29.64 %$1,407.26 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $23,874.59 $89,075.00 26.80 %$65,200.41 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $0.00 $107,580.00 0.00 %$107,580.00 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 001-000-000-341-35-30-00 Duplicating Services - Court & Police $0.00 $0.00 $100.00 0.00 %$100.00 Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 501-000-000-397-00-00-02 Transfer-In - Criminal Justice Fund Period: 2022 - February 2022 Account Number Title Period Fiscal Budget % of Total Balance 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 Waste Management Annual Fee $0.00 $0.00 $80,000.00 0.00 %$80,000.00 001-000-000-341-96-00-00 Personnel Services $0.00 $3,031.46 $0.00 ($3,031.46) 001-000-000-342-33-00-00 Adult Probation Services $4,182.00 $8,126.06 $61,966.00 13.11 %$53,839.94 001-000-000-342-36-00-00 Housing of Prisoners $366.09 $864.69 $19,256.00 4.49 %$18,391.31 001-000-000-342-40-00-01 Fire Marshall Inspection Services $0.00 $98.00 $4,000.00 2.45 %$3,902.00 001-000-000-345-83-00-00 Plan Checking Fees $45.01 $872.95 $50,000.00 1.75 %$49,127.05 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $560.89 $1,000.00 56.09 %$439.11 001-000-000-345-86-00-00 Sepa Permits $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-000-345-89-00-00 Planning & Development Fees $430.00 $1,411.00 $7,000.00 20.16 %$5,589.00 Total Charges for Goods and Services $5,023.10 $14,965.05 $224,742.00 6.66 %$209,776.95 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $9,848.96 $19,619.68 $175,420.00 11.18 %$155,800.32 001-000-000-357-33-00-00 Public Defender Costs $965.20 $1,885.80 $22,453.00 8.40 %$20,567.20 001-000-000-357-35-00-00 Restitution $0.00 $0.00 $400.00 0.00 %$400.00 001-000-000-357-37-00-00 Miscellaneous $0.75 $0.75 $0.00 ($0.75) Total Fines and Penalties $10,814.91 $21,506.23 $198,273.00 10.85 %$176,766.77 Miscellaneous Revenues 001-000-000-361-10-00-00 Interest Earnings $388.25 $723.48 $30,000.00 2.41 %$29,276.52 001-000-000-361-40-00-00 Sales Tax Interest $186.86 $358.04 $4,000.00 8.95 %$3,641.96 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $0.00 $1,295.00 $14,006.00 9.25 %$12,711.00 001-000-000-362-00-00-01 Rental Income - 50 Simon Street $0.00 $0.00 $27,600.00 0.00 %$27,600.00 001-000-000-369-91-50-00 Miscellaneous Revenue $0.75 $4,525.55 $7,000.00 64.65 %$2,474.45 Total Miscellaneous Revenues $575.86 $6,902.07 $82,606.00 8.36 %$75,703.93 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 Total Other Increases in Fund Resources $0.00 $0.00 $2,550.00 0.00 %$2,550.00 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 Total Other Financing Sources $0.00 $0.00 $509,900.00 0.00 %$509,900.00 Total General Fund $494,003.47 $808,523.99 $9,606,645.00 8.42 %$8,798,121.01 Rainy Day Fund 002-000-000-397-00-00-00 Transfer In - General Fund $0.00 $0.00 $750,000.00 0.00 %$750,000.00 Total Rainy Day Fund $0.00 $0.00 $750,000.00 0.00 %$750,000.00 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $2,757.82 $2,757.82 $500,000.00 0.55 %$497,242.18 101-000-000-313-11-00-00 Sales & Use Tax $158,988.50 $550,000.00 $550,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $0.00 $0.00 $2,000.00 0.00 %$2,000.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 $22,033.81 $42,275.06 $250,000.00 16.91 %$207,724.94 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 $0.00 $0.00 $500.00 0.00 %$500.00 Total Street Fund $183,780.13 $595,032.88 $1,336,500.00 44.52 %$741,467.12 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $0.00 $423,886.00 0.00 %$423,886.00 Total Community Development Grants Fund $0.00 $0.00 $423,886.00 0.00 %$423,886.00 Affordable Housing Sales Tax Fund 103-000-000-313-27-00-00 Affordable & Supportive Housing Sales/Use Tax $4,211.18 $7,553.33 $32,000.00 23.60 %$24,446.67 Total Affordable Housing Sales Tax Fund $4,211.18 $7,553.33 $32,000.00 23.60 %$24,446.67 Housing & Related Services Fund 104-000-000-313-25-00-00 Housing & Related Services Sales/Use Tax $57,579.80 $105,407.66 $440,000.00 23.96 %$334,592.34 Total Housing & Related Services Fund $57,579.80 $105,407.66 $440,000.00 23.96 %$334,592.34 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $15,741.00 $33,204.60 $250,000.00 13.28 %$216,795.40 105-000-000-361-10-00-00 Interest Earnings $0.00 $0.00 $200.00 0.00 %$200.00 Total Transportation Benefit District Fund $15,741.00 $33,204.60 $250,200.00 13.27 %$216,995.40 SWAT Fund 107-000-000-330-00-00-01 CCSO SWAT Fee $15,000.00 $15,000.00 $0.00 ($15,000.00) 107-000-000-330-00-00-02 City of Wenatchee SWAT Fee $15,000.00 $15,000.00 $0.00 ($15,000.00) 107-000-000-330-00-00-03 DCSO SWAT Fee $15,000.00 $15,000.00 $0.00 ($15,000.00) Total SWAT Fund $45,000.00 $45,000.00 $0.00 ($45,000.00) Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $0.00 $7,500.00 0.00 %$7,500.00 112-000-000-361-10-00-00 Interest Earnings $0.00 $0.00 $25.00 0.00 %$25.00 Total Library Fund $0.00 $0.00 $7,525.00 0.00 %$7,525.00 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $37,995.64 $61,545.28 $250,000.00 24.62 %$188,454.72 Total Hotel/Motel Tax Fund $37,995.64 $61,545.28 $250,000.00 24.62 %$188,454.72 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $5.00 $6.25 $100.00 6.25 %$93.75 Total Drug Fund $5.00 $6.25 $100.00 6.25 %$93.75 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $1,180.45 $4,500.00 26.23 %$3,319.55 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $4,195.53 $16,000.00 26.22 %$11,804.47 Total Criminal Justice Fund $0.00 $5,375.98 $20,500.00 26.22 %$15,124.02 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 $275.00 $275.00 $9,000.00 3.06 %$8,725.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 Account Number Title Period Fiscal Budget % of Total Balance 117-000-400-347-90-00-11 Wings & Wheels Sponsorships $0.00 $0.00 $12,000.00 0.00 %$12,000.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 $275.00 $275.00 $151,650.00 0.18 %$151,375.00 Street Improvements Fund 301-000-000-330-00-00-00 GWID - 10th St. NE Improvements $49,651.51 $49,651.51 $0.00 ($49,651.51) 301-000-000-330-00-00-01 EWWD - 10th St. NE Improvements $0.00 $15,360.06 $0.00 ($15,360.06) 301-000-000-330-00-00-02 EWWD - Hamilton St. Improvements $0.00 $0.00 $250,000.00 0.00 %$250,000.00 301-000-000-330-00-00-03 EWSD - Hamilton St. Improvements $0.00 $0.00 $25,000.00 0.00 %$25,000.00 301-000-000-330-00-00-04 County Sales/Use Tax - Hamilton St. Improvements $0.00 $0.00 $228,000.00 0.00 %$228,000.00 301-000-000-333-20-00-13 STP 9th/VMP Intersection $0.00 $0.00 $1,096,000.00 0.00 %$1,096,000.00 301-000-000-333-20-00-21 STBG - 10th St. NE Improvements $0.00 $290,067.77 $0.00 ($290,067.77) 301-000-000-333-20-00-22 SRTS - 5th St NE: Sterling $0.00 $0.00 $200,000.00 0.00 %$200,000.00 301-000-000-333-20-00-23 SRTS - 5th St NE: Kenroy $0.00 $0.00 $253,000.00 0.00 %$253,000.00 301-000-000-333-20-00-24 NHS - Grant Rd. Overlay Grover to Kentucky $0.00 $0.00 $129,000.00 0.00 %$129,000.00 301-000-000-333-20-00-25 NHS - Grant/Highline PCCP Intersection $0.00 $0.00 $109,000.00 0.00 %$109,000.00 301-000-000-334-03-80-13 TIB N Kentucky Ave Overlay $0.00 $0.00 $690,200.00 0.00 %$690,200.00 301-000-000-334-03-80-15 TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $86,500.00 0.00 %$86,500.00 301-000-000-334-03-80-21 TIB 2022 Complete Streets $0.00 $0.00 $550,000.00 0.00 %$550,000.00 301-000-000-334-03-80-23 TIB - Grant Rd. Overlay Eastmont to Grover $0.00 $0.00 $27,000.00 0.00 %$27,000.00 301-000-000-334-03-80-24 TIB 5th St. NE SRTS Overlay $0.00 $0.00 $74,000.00 0.00 %$74,000.00 301-000-000-397-00-00-00 Transfer-In - Fund 401 $0.00 $0.00 $50,000.00 0.00 %$50,000.00 301-000-000-397-00-00-01 Transfer-In - Fund 102 $0.00 $0.00 $175,212.00 0.00 %$175,212.00 301-000-000-397-41-10-05 Transfer-In from Fund 105 $0.00 $0.00 $322,000.00 0.00 %$322,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 $49,651.51 $355,079.34 $5,014,912.00 7.08 %$4,659,832.66 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $22,356.72 $85,017.46 $450,000.00 18.89 %$364,982.54 314-000-000-391-10-00-00 LTGO Bond Proceeds $0.00 $0.00 $6,000,000.00 0.00 %$6,000,000.00 Total Capital Improvements Fund $22,356.72 $85,017.46 $6,450,000.00 1.32 %$6,364,982.54 Stormwater Fund 401-000-000-334-03-10-00 Dept. of Ecology Capacity Grant $0.00 $0.00 $50,000.00 0.00 %$50,000.00 401-000-000-334-03-10-01 19th St. Ecology Grant $0.00 $0.00 $75,000.00 0.00 %$75,000.00 401-000-000-334-03-10-02 Stormwater Comp Plan Ecology Grant $0.00 $43,614.10 $40,000.00 109.04 %($3,614.10) 401-000-000-334-03-10-03 Pace Pond Ecology Grant $0.00 $0.00 $127,500.00 0.00 %$127,500.00 401-000-000-343-10-00-00 SWU Fee $180.00 $756.00 $525,000.00 0.14 %$524,244.00 401-000-000-361-10-00-00 Interest Earnings $0.12 $30.54 $0.00 ($30.54) 401-000-000-382-30-00-00 Non-Fiduciary Collections $180.00 $180.00 $0.00 ($180.00) Total Stormwater Fund $360.12 $44,580.64 $817,500.00 5.45 %$772,919.36 Equipment Purchase, Repair & Replacement Fund 501-000-000-348-00-00-01 Police - Fleet Maintenance Rentals $20,822.92 $41,645.84 $250,000.00 16.66 %$208,354.16 501-000-000-348-00-00-02 Street - Fleet Maintenance Rentals $15,661.14 $31,322.28 $188,000.00 16.66 %$156,677.72 Account Number Title Period Fiscal Budget % of Total Balance 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-395-20-00-00 Insurance Recoveries - Police $5,080.72 $5,080.72 $0.00 ($5,080.72) 501-000-000-397-00-00-00 Transfer In - General Fund $0.00 $0.00 $357,291.00 0.00 %$357,291.00 501-000-000-397-00-00-02 Transfer-In - Criminal Justice Fund $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Total Equipment Purchase, Repair & Replacement Fund $46,305.79 $87,530.86 $872,291.00 10.03 %$784,760.14 Grand Totals $957,265.36 $2,234,133.27 $26,423,709.00 8.46 %$24,189,575.73 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $494,003.47 $808,523.99 $9,606,645.00 8.42 %$8,798,121.01 002-000-000-000-00-00-00 Rainy Day Fund $0.00 $0.00 $750,000.00 0.00 %$750,000.00 101-000-000-000-00-00-00 Street Fund $183,780.13 $595,032.88 $1,336,500.00 44.52 %$741,467.12 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $423,886.00 0.00 %$423,886.00 103-000-000-000-00-00-00 Affordable Housing Sales Tax Fund $4,211.18 $7,553.33 $32,000.00 23.60 %$24,446.67 104-000-000-000-00-00-00 Housing & Related Services Fund $57,579.80 $105,407.66 $440,000.00 23.96 %$334,592.34 105-000-000-000-00-00-00 Transportation Benefit District Fund $15,741.00 $33,204.60 $250,200.00 13.27 %$216,995.40 107-000-000-000-00-00-00 SWAT Fund $45,000.00 $45,000.00 $0.00 ($45,000.00) 112-000-000-000-00-00-00 Library Fund $0.00 $0.00 $7,525.00 0.00 %$7,525.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $37,995.64 $61,545.28 $250,000.00 24.62 %$188,454.72 114-000-000-000-00-00-00 Drug Fund $5.00 $6.25 $100.00 6.25 %$93.75 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $5,375.98 $20,500.00 26.22 %$15,124.02 117-000-000-000-00-00-00 Events Board Fund $275.00 $275.00 $151,650.00 0.18 %$151,375.00 301-000-000-000-00-00-00 Street Improvements Fund $49,651.51 $355,079.34 $5,014,912.00 7.08 %$4,659,832.66 314-000-000-000-00-00-00 Capital Improvements Fund $22,356.72 $85,017.46 $6,450,000.00 1.32 %$6,364,982.54 401-000-000-000-00-00-00 Stormwater Fund $360.12 $44,580.64 $817,500.00 5.45 %$772,919.36 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $46,305.79 $87,530.86 $872,291.00 10.03 %$784,760.14 Grand Totals $957,265.36 $2,234,133.27 $26,423,709.00 8.46 %$24,189,575.73 Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 001-000-001-518-63-40-00 Flywheel Conference $5,000.00 $5,000.00 $5,000.00 100.00 %$0.00 001-000-001-518-90-40-00 GWATA Membership $0.00 $0.00 $315.00 0.00 %$315.00 001-000-001-518-91-30-00 Wellness $127.35 $127.35 $2,000.00 6.37 %$1,872.65 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 $27,000.00 16.50 %$22,545.00 001-000-001-528-70-40-00 River Com $17,500.00 $35,000.00 $261,251.00 13.40 %$226,251.00 001-000-001-531-00-40-00 Annual SWU Charge $0.00 $0.00 $82,500.00 0.00 %$82,500.00 001-000-001-539-30-40-00 Animal Control $7,186.07 $14,372.14 $86,233.00 16.67 %$71,860.86 001-000-001-553-70-40-00 Douglas County Solid Waste Removal $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $0.00 $14,221.00 0.00 %$14,221.00 001-000-001-558-70-40-00 Contributions - Region $30,000.00 $30,000.00 $30,000.00 100.00 %$0.00 001-000-001-558-70-40-02 ARPA Contributions $20,000.00 $20,000.00 $500,000.00 4.00 %$480,000.00 001-000-001-558-70-41-00 NCW Economic Development District $0.00 $500.00 $1,250.00 40.00 %$750.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 $900.00 $900.00 100.00 %$0.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)$0.00 $0.00 $3,600.00 0.00 %$3,600.00 001-000-001-597-00-00-01 Transfer Out - ER&R Fund $0.00 $0.00 $357,291.00 0.00 %$357,291.00 001-000-001-597-00-00-02 Transfer Out - Rainy Day Fund $0.00 $0.00 $750,000.00 0.00 %$750,000.00 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 $87,102.92 $120,478.49 $2,707,811.00 4.45 %$2,587,332.51 Legislative 001-000-110-511-60-10-00 Salaries $4,704.28 $9,443.63 $56,700.00 16.66 %$47,256.37 001-000-110-511-60-20-00 Benefits $361.48 $722.96 $4,338.00 16.67 %$3,615.04 001-000-110-511-60-21-50 Public Defender $11,917.00 $23,834.00 $135,000.00 17.65 %$111,166.00 001-000-110-511-60-30-00 Public Defender Conflicts $0.00 $0.00 $5,200.00 0.00 %$5,200.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,933.82 $11,933.82 $12,000.00 99.45 %$66.18 001-000-110-511-60-41-20 AWC Annual Membership Fee $0.00 $10,328.00 $10,613.00 97.31 %$285.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 $0.00 $0.00 $9,563.00 0.00 %$9,563.00 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: 2022 - February 2022 Account Number Title Period Fiscal Budget % of Total Balance 001-000-110-511-60-47-00 Background Check Costs $0.00 $0.00 $200.00 0.00 %$200.00 001-000-110-511-60-49-00 Miscellaneous $0.00 $0.00 $2,500.00 0.00 %$2,500.00 Total Legislative $28,916.58 $56,262.41 $270,514.00 20.80 %$214,251.59 Mayor's Office 001-000-111-513-00-10-00 Salaries $8,158.31 $16,492.46 $102,000.00 16.17 %$85,507.54 001-000-111-513-00-20-00 Benefits $3,298.99 $9,282.32 $33,000.00 28.13 %$23,717.68 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 Publications $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-111-513-00-40-01 Training $35.00 $35.00 $2,000.00 1.75 %$1,965.00 001-000-111-513-00-40-02 Professional Services $360.00 $360.00 $30,000.00 1.20 %$29,640.00 001-000-111-513-00-40-03 Cell Phone $42.08 $42.08 $550.00 7.65 %$507.92 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 $0.00 $0.00 $9,563.00 0.00 %$9,563.00 001-000-111-513-00-40-06 Miscellaneous $0.00 $0.00 $250.00 0.00 %$250.00 Total Mayor's Office $11,894.38 $26,211.86 $188,613.00 13.90 %$162,401.14 Municipal Court 001-000-120-512-50-10-00 Salaries $21,695.71 $45,310.66 $0.00 ($45,310.66) 001-000-120-512-50-12-00 Salaries - Probation Services $5,238.58 $10,477.16 $0.00 ($10,477.16) 001-000-120-512-50-20-00 Benefits $7,300.77 $17,620.91 $0.00 ($17,620.91) 001-000-120-512-50-22-00 Benefits - Probation Services $3,131.68 $6,437.42 $0.00 ($6,437.42) 001-000-120-512-50-49-02 Judge Protems $600.00 $600.00 $0.00 ($600.00) 001-000-120-512-51-10-00 Salaries $0.00 $0.00 $284,000.00 0.00 %$284,000.00 001-000-120-512-51-10-01 Salaries - Probation $0.00 $0.00 $63,000.00 0.00 %$63,000.00 001-000-120-512-51-20-00 Benefits $0.00 $0.00 $102,000.00 0.00 %$102,000.00 001-000-120-512-51-20-01 Benefits - Probation $0.00 $0.00 $39,636.00 0.00 %$39,636.00 001-000-120-512-51-30-00 Supplies $476.95 $476.95 $4,500.00 10.60 %$4,023.05 001-000-120-512-51-40-00 Training $0.00 $540.00 $1,500.00 36.00 %$960.00 001-000-120-512-51-40-01 IT Services $0.00 $0.00 $2,705.00 0.00 %$2,705.00 001-000-120-512-51-40-02 Insurance $0.00 $0.00 $17,843.00 0.00 %$17,843.00 001-000-120-512-51-40-03 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-51-40-04 Interpreting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-120-512-51-40-05 Judge Protems $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-120-512-51-40-06 Witness Fees $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-51-40-07 Juror Fees $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-120-512-51-40-08 Security $481.25 $481.25 $6,000.00 8.02 %$5,518.75 001-000-120-512-51-40-09 Travel $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-120-594-12-60-00 Capital Outlay $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Municipal Court $38,924.94 $81,944.35 $544,184.00 15.06 %$462,239.65 Human Resources 001-000-139-518-10-10-00 Salaries $3,752.00 $7,548.22 $46,000.00 16.41 %$38,451.78 001-000-139-518-10-20-00 Benefits $1,587.41 $3,632.19 $20,000.00 18.16 %$16,367.81 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,300.00 0.00 %$1,300.00 001-000-139-518-10-40-01 Membership Dues & Publications $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-139-518-10-40-02 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Account Number Title Period Fiscal Budget % of Total Balance 001-000-139-518-10-40-03 Advertising $1,086.80 $1,086.80 $1,000.00 108.68 %($86.80) 001-000-139-518-10-40-04 Insurance $0.00 $0.00 $3,938.00 0.00 %$3,938.00 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 $0.00 $5.95 $250.00 2.38 %$244.05 001-000-139-518-10-40-07 Pre-Employment Services $0.00 $0.00 $700.00 0.00 %$700.00 001-000-139-518-10-40-08 Professional Services $4.55 $4.55 $1,000.00 0.46 %$995.45 Total Human Resources $6,430.76 $12,277.71 $76,938.00 15.96 %$64,660.29 City Clerk 001-000-140-514-20-10-00 Salaries $6,699.11 $10,495.44 $102,000.00 10.29 %$91,504.56 001-000-140-514-20-20-00 Benefits $3,961.73 $13,161.94 $53,000.00 24.83 %$39,838.06 001-000-140-514-20-31-00 Office Supplies $181.17 $181.17 $3,000.00 6.04 %$2,818.83 001-000-140-514-20-31-01 Central Stores $1,893.26 $1,893.26 $6,000.00 31.55 %$4,106.74 001-000-140-514-20-40-00 Training $35.00 $35.00 $3,000.00 1.17 %$2,965.00 001-000-140-514-20-40-01 Records Services $0.00 $0.00 $500.00 0.00 %$500.00 001-000-140-514-20-40-02 Codification $0.00 $0.00 $1,400.00 0.00 %$1,400.00 001-000-140-514-20-41-00 Membership Dues & Publications $290.00 $290.00 $1,200.00 24.17 %$910.00 001-000-140-514-20-43-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-140-514-20-44-00 Advertising $78.03 $78.03 $2,000.00 3.90 %$1,921.97 001-000-140-514-20-46-00 Insurance $0.00 $0.00 $8,213.00 0.00 %$8,213.00 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-26-40-00 Public Records Requests $0.00 $0.00 $500.00 0.00 %$500.00 001-000-140-514-81-40-00 Taxi License Background Fee $0.00 $0.00 $300.00 0.00 %$300.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 $13,138.30 $26,134.84 $186,413.00 14.02 %$160,278.16 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $367.99 $367.99 $12,500.00 2.94 %$12,132.01 001-000-141-514-20-42-01 Telephone Line Charges $1,433.76 $1,433.76 $14,000.00 10.24 %$12,566.24 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 $0.00 $4,000.00 0.00 %$4,000.00 Total Internal Services $1,801.75 $1,801.75 $36,500.00 4.94 %$34,698.25 Finance 001-000-142-514-20-10-00 Salaries $9,921.44 $25,958.34 $182,000.00 14.26 %$156,041.66 001-000-142-514-20-20-00 Benefits $3,132.82 $8,188.44 $72,000.00 11.37 %$63,811.56 001-000-142-514-20-31-00 Office Supplies $0.00 $0.00 $1,600.00 0.00 %$1,600.00 001-000-142-514-20-31-01 Central Stores $51.55 $51.55 $0.00 ($51.55) 001-000-142-514-20-40-00 State Audit $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-142-514-20-40-01 FSA Administrative Fee $0.00 $300.00 $600.00 50.00 %$300.00 001-000-142-514-20-40-02 Bank Charges & Fees $475.07 $951.94 $5,500.00 17.31 %$4,548.06 001-000-142-514-20-40-03 Training $0.00 $0.00 $1,500.00 0.00 %$1,500.00 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 $0.00 $0.00 $13,817.00 0.00 %$13,817.00 001-000-142-594-14-60-00 Capital Outlay $0.00 $0.00 $19,450.00 0.00 %$19,450.00 Total Finance $13,580.88 $35,450.27 $326,967.00 10.84 %$291,516.73 Account Number Title Period Fiscal Budget % of Total Balance Information Technology 001-000-145-514-20-10-00 Salaries $8,747.46 $17,595.72 $107,000.00 16.44 %$89,404.28 001-000-145-514-20-20-00 Benefits $3,792.71 $8,112.90 $47,000.00 17.26 %$38,887.10 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 $2,388.00 $2,388.00 $16,000.00 14.93 %$13,612.00 001-000-145-514-20-40-10 Annual Fee - GIS Systems $0.00 $0.00 $6,500.00 0.00 %$6,500.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-21 Annual License - HR Software $1,225.00 $1,225.00 $5,300.00 23.11 %$4,075.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 $6,511.00 $6,511.00 $7,000.00 93.01 %$489.00 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $0.00 $21,000.00 0.00 %$21,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 $800.00 0.00 %$800.00 001-000-145-514-20-40-51 Annual License - Electronic Archive (Smarsh & Archive Social) $0.00 $0.00 $7,500.00 0.00 %$7,500.00 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $0.00 $0.00 $9,000.00 0.00 %$9,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 $8,000.00 0.00 %$8,000.00 001-000-145-514-20-42-00 Cell Phone $62.26 $62.26 $850.00 7.32 %$787.74 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 $0.00 $0.00 $3,375.00 0.00 %$3,375.00 001-000-145-594-14-60-20 Capital - PC Software Admin $197.21 $197.21 $40,000.00 0.49 %$39,802.79 001-000-145-594-14-60-25 Capital - PC Hardware Admin $0.00 $1,028.76 $35,500.00 2.90 %$34,471.24 Total Information Technology $22,923.64 $37,120.85 $359,925.00 10.31 %$322,804.15 Legal 001-000-151-515-31-10-00 Salaries $7,605.30 $14,591.78 $84,000.00 17.37 %$69,408.22 001-000-151-515-31-20-00 Benefits $2,731.23 $5,485.76 $32,000.00 17.14 %$26,514.24 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 $2,100.00 0.00 %$2,100.00 001-000-151-515-31-40-02 Membership Dues $541.45 $541.45 $30.00 1,804.83 %($511.45) 001-000-151-515-31-40-03 Licensing $0.00 $0.00 $500.00 0.00 %$500.00 001-000-151-515-31-40-10 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-151-515-31-42-01 Cell Phone $52.26 $52.26 $600.00 8.71 %$547.74 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 $0.00 $0.00 $12,690.00 0.00 %$12,690.00 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-40-05 Litigation Expenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-151-515-40-25-00 Professional Services $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-151-515-41-40-00 Legal Services $17,366.00 $17,366.00 $200,000.00 8.68 %$182,634.00 Total Legal $28,296.24 $38,037.25 $355,620.00 10.70 %$317,582.75 Account Number Title Period Fiscal Budget % of Total Balance Civil Service 001-000-160-521-10-10-00 Salaries $425.00 $850.00 $5,600.00 15.18 %$4,750.00 001-000-160-521-10-46-00 Insurance $0.00 $0.00 $9,113.00 0.00 %$9,113.00 Total Civil Service $425.00 $850.00 $14,713.00 5.78 %$13,863.00 Central Services 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $378.10 $378.10 $3,000.00 12.60 %$2,621.90 001-000-180-518-30-35-00 Small Tools & Equipment $473.30 $473.30 $7,000.00 6.76 %$6,526.70 001-000-180-518-30-41-00 Professional Services $301.30 $378.16 $15,000.00 2.52 %$14,621.84 001-000-180-518-30-41-01 Contracted Custodial Services $0.00 $2,580.97 $32,000.00 8.07 %$29,419.03 001-000-180-518-30-46-00 Insurance $0.00 $0.00 $58,500.00 0.00 %$58,500.00 001-000-180-518-30-47-00 Utilities $2,628.45 $2,628.45 $30,000.00 8.76 %$27,371.55 001-000-180-518-30-47-01 Utilities - Simon St.$862.80 $862.80 $0.00 ($862.80) 001-000-180-518-30-48-00 Repairs & Maintenance $685.22 $685.22 $15,000.00 4.57 %$14,314.78 001-000-180-518-30-49-00 Miscellaneous ($750.00)($750.00)$1,000.00 -75.00 %$1,750.00 001-000-180-518-30-49-01 Landscaping $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$181.24 $858.98 $9,000.00 9.54 %$8,141.02 001-000-180-594-18-60-00 Capital Outlay $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Central Services $4,760.41 $8,095.98 $179,500.00 4.51 %$171,404.02 Law Enforcement 001-000-210-521-10-10-00 Salaries $192,600.07 $382,983.71 $2,430,000.00 15.76 %$2,047,016.29 001-000-210-521-10-10-02 Overtime - Shift Coverage $14,076.94 $22,774.91 $150,000.00 15.18 %$127,225.09 001-000-210-521-10-10-03 Overtime Salaries - Traffic Safety $0.00 $0.00 $8,280.00 0.00 %$8,280.00 001-000-210-521-10-10-06 Overtime - Training $0.00 $0.00 $36,225.00 0.00 %$36,225.00 001-000-210-521-10-10-07 Overtime - Other $0.00 $0.00 $16,043.00 0.00 %$16,043.00 001-000-210-521-10-20-00 Benefits $70,671.86 $162,815.46 $940,000.00 17.32 %$777,184.54 001-000-210-521-10-20-01 Clothing Allowance $574.05 $2,174.79 $16,800.00 12.95 %$14,625.21 001-000-210-521-10-31-00 Office Supplies $370.63 $370.63 $8,500.00 4.36 %$8,129.37 001-000-210-521-10-31-05 Office Machine Costs $377.89 $377.89 $5,000.00 7.56 %$4,622.11 001-000-210-521-10-32-00 Fuel Consumed $5,116.83 $5,116.83 $55,000.00 9.30 %$49,883.17 001-000-210-521-10-35-00 Small Tools & Equipment $8,678.40 $11,578.11 $23,250.00 49.80 %$11,671.89 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 $607.63 $607.63 $15,000.00 4.05 %$14,392.37 001-000-210-521-10-41-01 Emergency Management Contract $0.00 $0.00 $42,000.00 0.00 %$42,000.00 001-000-210-521-10-41-02 Membership Dues $12.99 $12.99 $600.00 2.17 %$587.01 001-000-210-521-10-42-01 Telephone $2,908.24 $2,908.24 $30,000.00 9.69 %$27,091.76 001-000-210-521-10-42-03 Postage $0.00 $0.00 $1,175.00 0.00 %$1,175.00 001-000-210-521-10-43-00 Travel $324.50 $324.50 $10,000.00 3.25 %$9,675.50 001-000-210-521-10-46-00 Insurance $0.00 $0.00 $79,875.00 0.00 %$79,875.00 001-000-210-521-10-48-00 Repairs & Maintenance $716.42 $803.05 $9,500.00 8.45 %$8,696.95 001-000-210-521-10-49-00 Miscellaneous $2,724.99 $2,839.99 $2,500.00 113.60 %($339.99) 001-000-210-521-10-49-02 Dry Cleaning Services $169.93 $169.93 $1,200.00 14.16 %$1,030.07 001-000-210-521-30-40-00 Crime Prevention $536.09 $536.09 $850.00 63.07 %$313.91 001-000-210-521-30-40-01 Regional SWAT $0.00 $0.00 $15,000.00 0.00 %$15,000.00 001-000-210-521-40-40-00 Training - Police Chief $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-40-40-01 Training - Officers $95.00 $95.00 $4,500.00 2.11 %$4,405.00 001-000-210-521-40-40-02 Training - Office Staff $35.00 $35.00 $500.00 7.00 %$465.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-548-60-40-00 Fleet Rentals - Police $20,822.92 $41,645.84 $250,000.00 16.66 %$208,354.16 001-000-210-594-21-60-00 Capital Outlay $19,431.28 $19,431.28 $33,000.00 58.88 %$13,568.72 Total Law Enforcement $340,851.66 $657,601.87 $4,193,698.00 15.68 %$3,536,096.13 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $39,925.22 $79,850.44 $479,103.00 16.67 %$399,252.56 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 $39,925.22 $79,850.44 $495,603.00 16.11 %$415,752.56 Public Works 001-000-315-542-10-10-00 Salaries $7,922.28 $15,844.56 $98,000.00 16.17 %$82,155.44 001-000-315-542-10-20-00 Benefits $2,784.23 $5,794.93 $36,000.00 16.10 %$30,205.07 001-000-315-542-10-31-00 Office Supplies $0.00 $0.00 $750.00 0.00 %$750.00 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-542-10-40-00 Cell Phone $0.00 $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 $0.00 $0.00 $14,625.00 0.00 %$14,625.00 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-10 Memberships $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-544-20-45-00 Engineering Support Services $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Total Public Works $10,706.51 $21,639.49 $175,125.00 12.36 %$153,485.51 Planning 001-000-580-558-60-10-00 Salaries $19,602.37 $39,609.14 $243,000.00 16.30 %$203,390.86 001-000-580-558-60-20-00 Benefits $7,202.00 $14,805.90 $91,000.00 16.27 %$76,194.10 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,500.00 0.00 %$1,500.00 001-000-580-558-60-40-01 Dues & Subscriptions $763.00 $763.00 $1,700.00 44.88 %$937.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 $1,800.00 0.00 %$1,800.00 001-000-580-558-60-41-02 Engineer/Architect Services $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-580-558-60-43-00 Travel $0.00 $0.00 $3,500.00 0.00 %$3,500.00 001-000-580-558-60-44-00 Advertising $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-580-558-60-46-00 Insurance $0.00 $0.00 $15,120.00 0.00 %$15,120.00 001-000-580-558-60-48-00 Repairs & Maintenance $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-580-558-60-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total Planning $27,567.37 $55,178.04 $390,895.00 14.12 %$335,716.96 Building Department 001-000-590-558-50-10-00 Salaries $1,195.01 $2,926.02 $106,000.00 2.76 %$103,073.98 001-000-590-558-50-20-00 Benefits $1,325.03 $2,980.20 $50,000.00 5.96 %$47,019.80 Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-31-00 Office Supplies $20.28 $20.28 $2,300.00 0.88 %$2,279.72 001-000-590-558-50-32-00 Fuel Consumed $0.00 $0.00 $600.00 0.00 %$600.00 001-000-590-558-50-35-00 Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 001-000-590-558-50-40-00 Training $0.00 $0.00 $1,644.00 0.00 %$1,644.00 001-000-590-558-50-40-01 Dues & Subscriptions $0.00 $0.00 $500.00 0.00 %$500.00 001-000-590-558-50-41-00 Professional Services $5,765.90 $5,765.90 $0.00 ($5,765.90) 001-000-590-558-50-41-01 Fire Marshal Services $0.00 $0.00 $23,000.00 0.00 %$23,000.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-42-01 Cell Phone $0.00 $0.00 $800.00 0.00 %$800.00 001-000-590-558-50-43-00 Travel $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-590-558-50-46-00 Insurance $0.00 $0.00 $12,026.00 0.00 %$12,026.00 001-000-590-558-50-48-00 Repairs & Maintenance $0.00 $0.00 $500.00 0.00 %$500.00 001-000-590-558-50-49-00 Miscellaneous $0.00 $0.00 $150.00 0.00 %$150.00 Total Building Department $8,306.22 $11,692.40 $216,020.00 5.41 %$204,327.60 Other Expenditures 001-001-000-589-00-00-01 Fireworks - Deposit Refund $0.00 $0.00 $2,500.00 0.00 %$2,500.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 $0.00 $0.00 $3,500.00 0.00 %$3,500.00 001-001-000-589-00-00-04 Remittance: State Building Code Surcharge $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-001-000-589-00-00-05 State Share of Permits & Licenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-001-000-589-00-00-06 Court Remittances $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Other Expenditures $0.00 $0.00 $167,250.00 0.00 %$167,250.00 Total General Fund $685,552.78 $1,270,628.00 $10,886,289.00 11.67 %$9,615,661.00 Street Fund Storm Water Utility Charge 101-000-315-531-00-40-00 Annual SWU Charge $0.00 $0.00 $82,500.00 0.00 %$82,500.00 Total Storm Water Utility Charge $0.00 $0.00 $82,500.00 0.00 %$82,500.00 101-000-420-542-30-10-00 Salaries - Roadway $1,839.52 $3,490.12 $60,000.00 5.82 %$56,509.88 101-000-420-542-30-20-00 Benefits - Roadway $1,379.68 $2,748.70 $30,000.00 9.16 %$27,251.30 101-000-420-542-30-30-00 Supplies - Roadway $1,202.50 $1,261.78 $45,000.00 2.80 %$43,738.22 101-000-420-542-30-48-00 Repairs & Maintenance - Roadway $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $0.00 $4,500.00 0.00 %$4,500.00 101-000-420-542-61-20-00 Benefits - Sidewalks $0.00 $0.00 $2,400.00 0.00 %$2,400.00 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 $0.00 $0.00 $11,000.00 0.00 %$11,000.00 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $0.00 $75.40 $5,500.00 1.37 %$5,424.60 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 $0.00 $0.00 $6,000.00 0.00 %$6,000.00 101-000-420-542-63-20-00 Benefits - Street Lighting $0.00 $13.22 $3,000.00 0.44 %$2,986.78 101-000-420-542-63-30-00 Supplies - Street Lighting $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-420-542-63-47-00 Utilities - Street Lighting $1,822.00 $1,822.00 $60,000.00 3.04 %$58,178.00 101-000-420-542-63-48-00 Repairs & Maintenance - Street Lighting $0.00 $0.00 $12,000.00 0.00 %$12,000.00 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $330.13 $440.18 $44,600.00 0.99 %$44,159.82 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $80.22 $269.14 $22,500.00 1.20 %$22,230.86 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $16.09 $16.09 $40,000.00 0.04 %$39,983.91 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $413.60 $643.13 $9,000.00 7.15 %$8,356.87 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 $204.97 $2,254.57 $2,000.00 112.73 %($254.57) 101-000-420-542-65-20-00 Benefits - Parking Facilities $193.09 $559.97 $1,000.00 56.00 %$440.03 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 $17,565.62 $44,658.30 $70,000.00 63.80 %$25,341.70 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $5,987.77 $19,405.86 $40,000.00 48.51 %$20,594.14 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $18,993.08 $18,993.08 $100,000.00 18.99 %$81,006.92 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $2,961.26 $3,187.17 $5,000.00 63.74 %$1,812.83 101-000-420-542-69-10-00 Salaries - Flags/Banners $801.43 $1,022.76 $20,000.00 5.11 %$18,977.24 101-000-420-542-69-20-00 Benefits - Flags/Banners $143.46 $413.10 $12,000.00 3.44 %$11,586.90 101-000-420-542-69-30-00 Supplies - Flags/Banners $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-420-542-70-10-00 Salaries - Roadside $20,163.02 $35,117.58 $247,000.00 14.22 %$211,882.42 101-000-420-542-70-20-00 Benefits - Roadside $12,037.98 $21,959.95 $136,500.00 16.09 %$114,540.05 101-000-420-542-70-30-00 Supplies - Roadside $56.35 $56.35 $5,000.00 1.13 %$4,943.65 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 $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-75-10-00 Salaries - City Parks $1,204.07 $1,204.07 $45,000.00 2.68 %$43,795.93 101-000-420-542-75-20-00 Benefits - City Parks $695.74 $1,297.00 $23,000.00 5.64 %$21,703.00 101-000-420-542-75-30-00 Supplies - City Parks $36.83 $36.83 $14,500.00 0.25 %$14,463.17 101-000-420-542-75-47-00 Utilities - City Parks $99.00 $99.00 $5,000.00 1.98 %$4,901.00 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $0.00 $0.00 $4,000.00 0.00 %$4,000.00 101-000-420-542-80-48-00 Japanese Garden Agreement $0.00 $0.00 $12,000.00 0.00 %$12,000.00 101-000-420-542-90-10-00 Salaries - Maintenance Admin $316.67 $316.67 $0.00 ($316.67) 101-000-420-542-90-20-00 Benefits - Maintenance Admin $181.30 $208.98 $0.00 ($208.98) 101-000-430-543-30-10-00 Salaries - General Services $597.50 $1,471.44 $0.00 ($1,471.44) 101-000-430-543-30-20-00 Benefits - General Services $662.52 $3,801.40 $0.00 ($3,801.40) 101-000-430-543-30-30-00 Supplies - General Services $1,369.17 $2,112.30 $6,000.00 35.21 %$3,887.70 101-000-430-543-30-46-00 Insurance $0.00 $0.00 $63,250.00 0.00 %$63,250.00 101-000-430-543-30-49-00 Miscellaneous - General Services $0.00 $640.00 $3,000.00 21.33 %$2,360.00 101-000-430-543-50-10-00 Salaries - Facilities $374.63 $374.63 $4,000.00 9.37 %$3,625.37 101-000-430-543-50-20-00 Benefits - Facilities $219.78 $263.25 $1,800.00 14.63 %$1,536.75 101-000-430-543-50-30-00 Supplies - Facilities $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-430-543-50-42-01 Cell Phone $88.31 $88.31 $750.00 11.77 %$661.69 101-000-430-543-50-47-00 Utilities - Facilities $1,593.79 $1,593.79 $6,500.00 24.52 %$4,906.21 101-000-430-543-50-48-00 Repairs & Maintenance - Facilities $203.25 $203.25 $2,500.00 8.13 %$2,296.75 101-000-430-544-90-10-00 Salaries - Training $307.43 $307.43 $7,000.00 4.39 %$6,692.57 101-000-430-544-90-20-00 Benefits - Training $201.31 $207.31 $3,500.00 5.92 %$3,292.69 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 Account Number Title Period Fiscal Budget % of Total Balance 101-000-430-548-60-40-00 Fleet Rentals - Streets $15,661.14 $31,322.28 $188,000.00 16.66 %$156,677.72 Total Street Fund $110,004.21 $203,956.39 $1,508,500.00 13.52 %$1,304,543.61 Community Development Grants Fund 102-000-000-518-63-40-00 CDBG Micro Enterprise Grant $0.00 $0.00 $73,927.00 0.00 %$73,927.00 102-000-000-518-63-40-02 CDBG Emergency Income Payments Program $0.00 $0.00 $94,862.00 0.00 %$94,862.00 102-000-000-558-70-31-00 CDBG Office Supplies/copies $0.00 $0.00 $100.00 0.00 %$100.00 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $0.00 $77,185.00 0.00 %$77,185.00 102-000-000-558-70-44-00 CDBG Advertising $0.00 $0.00 $1,800.00 0.00 %$1,800.00 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 102-000-000-597-00-00-00 Transfer Out to 301 Fund $0.00 $0.00 $175,212.00 0.00 %$175,212.00 Total Community Development Grants Fund $0.00 $0.00 $423,886.00 0.00 %$423,886.00 Affordable Housing Sales Tax Fund 103-000-000-551-00-40-00 Homeless Shelter Assistance $0.00 $0.00 $45,000.00 0.00 %$45,000.00 Total Affordable Housing Sales Tax Fund $0.00 $0.00 $45,000.00 0.00 %$45,000.00 Housing & Related Services Fund 104-000-000-551-00-40-00 Transfer to City of Wenatchee - CRHTF $0.00 $0.00 $600,000.00 0.00 %$600,000.00 Total Housing & Related Services Fund $0.00 $0.00 $600,000.00 0.00 %$600,000.00 Transportation Benefit District Fund 105-000-000-597-91-00-00 Transfer-Out to Fund 301 $0.00 $0.00 $322,000.00 0.00 %$322,000.00 Total Transportation Benefit District Fund $0.00 $0.00 $322,000.00 0.00 %$322,000.00 Library Fund 112-000-000-572-50-47-00 Facilities - Utilities $146.59 $146.59 $6,500.00 2.26 %$6,353.41 Total Library Fund $146.59 $146.59 $6,500.00 2.26 %$6,353.41 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 Drug Fund 114-000-000-566-00-49-05 State Share-Forfeited Property $221.30 $221.30 $0.00 ($221.30) Total Drug Fund $221.30 $221.30 $0.00 ($221.30) Criminal Justice Fund 116-000-000-597-21-00-20 Transfer Out - ER&R Fund $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Total Criminal Justice Fund $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Events Board Fund 117-000-050-557-30-10-00 Salaries $5,039.37 $9,725.00 $60,000.00 16.21 %$50,275.00 117-000-050-557-30-20-00 Benefits $2,527.23 $5,146.46 $29,000.00 17.75 %$23,853.54 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 $35.00 $35.00 $2,000.00 1.75 %$1,965.00 Account Number Title Period Fiscal Budget % of Total Balance 117-000-100-557-30-41-00 Professional Services $119.40 $119.40 $600.00 19.90 %$480.60 117-000-100-557-30-42-00 Cell Phone $52.26 $52.26 $760.00 6.88 %$707.74 117-000-100-557-30-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 117-000-100-557-30-44-00 Advertising $0.00 $0.00 $500.00 0.00 %$500.00 117-000-105-557-30-40-00 Insurance $0.00 $0.00 $11,655.00 0.00 %$11,655.00 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-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,500.00 0.00 %$1,500.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 $0.00 $148.00 $5,000.00 2.96 %$4,852.00 117-000-500-557-30-41-01 Christmas - Professional Services $0.00 $0.00 $400.00 0.00 %$400.00 117-000-500-557-30-44-01 Christmas - Advertising $0.00 $0.00 $750.00 0.00 %$750.00 117-000-500-557-30-49-01 Christmas - Miscellaneous $32.46 $32.46 $100.00 32.46 %$67.54 Total Events Board Fund $7,805.72 $15,258.58 $143,865.00 10.61 %$128,606.42 Bond Redemption Fund 202-000-000-591-48-70-00 Principal - 2021 LTGO Bond $0.00 $0.00 $257,000.00 0.00 %$257,000.00 202-000-000-591-95-70-00 Principal - PWTFL 10th St. NE $0.00 $0.00 $120,000.00 0.00 %$120,000.00 202-000-000-592-48-80-00 Interest - 2021 LTGO Bond $0.00 $0.00 $157,000.00 0.00 %$157,000.00 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Bond Redemption Fund $0.00 $0.00 $544,000.00 0.00 %$544,000.00 Street Improvements Fund 301-000-000-595-10-40-02 Design - TIB N. Kentucky Overlay $0.00 $0.00 $84,000.00 0.00 %$84,000.00 301-000-000-595-10-40-03 Design - TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $101,775.00 0.00 %$101,775.00 301-000-000-595-10-40-04 Design - Grant Rd/Highline Dr Intersection Improvements $0.00 $0.00 $109,000.00 0.00 %$109,000.00 301-000-000-595-10-40-05 Design - Hamilton Ave Reconstruction $0.00 $0.00 $30,000.00 0.00 %$30,000.00 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $1,423.84 $1,635.42 $65,000.00 2.52 %$63,364.58 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $1,423.84 $1,682.43 $75,000.00 2.24 %$73,317.57 301-000-000-595-10-60-00 Design - NHS Overlay Grover to Kentucky $0.00 $0.00 $129,000.00 0.00 %$129,000.00 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-595-10-60-01 Design - TIB Grant Rd. Overlay Eastmont to Grover $0.00 $0.00 $32,000.00 0.00 %$32,000.00 301-000-000-595-10-60-02 Design - TIB 5th St. NE SRTS Overlay $0.00 $0.00 $87,500.00 0.00 %$87,500.00 301-000-000-595-20-60-02 ROW - SRTS - 5th St. Kenroy $0.00 $0.00 $223,000.00 0.00 %$223,000.00 301-000-000-595-20-60-03 ROW - SRTS - 5th St. Sterling $0.00 $0.00 $170,500.00 0.00 %$170,500.00 301-000-000-595-30-60-03 SDC - TIB N. Kentucky Overlay $0.00 $0.00 $56,000.00 0.00 %$56,000.00 301-000-000-595-30-60-04 Construction - TIB N. Kentucky Overlay $0.00 $0.00 $672,000.00 0.00 %$672,000.00 301-000-000-595-30-60-07 SDC - Hamilton St. Rebuild $0.00 $0.00 $35,000.00 0.00 %$35,000.00 301-000-000-595-30-60-08 Construction - Hamilton St. Rebuild $0.00 $0.00 $875,000.00 0.00 %$875,000.00 301-000-000-595-30-60-09 2022 Residential Overlay $0.00 $0.00 $322,000.00 0.00 %$322,000.00 301-000-000-595-61-60-03 TIB 2022 Complete Streets $0.00 $0.00 $550,000.00 0.00 %$550,000.00 301-000-000-595-64-40-01 Design - 9th/VMP Intersection $0.00 $0.00 $5,000.00 0.00 %$5,000.00 301-000-000-595-64-60-00 SDC - 9th/VMP Intersection $0.00 $0.00 $126,710.00 0.00 %$126,710.00 301-000-000-595-64-60-01 Construction - 9th/VMP Intersection $0.00 $0.00 $1,140,390.00 0.00 %$1,140,390.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 $2,847.68 $3,317.85 $5,422,175.00 0.06 %$5,418,857.15 Capital Improvements Fund 314-000-000-594-21-60-01 Simon St. Improvements $30,226.25 $30,226.25 $1,000,000.00 3.02 %$969,773.75 314-000-000-594-48-60-00 Maintenance Facilities Construction $2,409.00 $2,409.00 $6,000,000.00 0.04 %$5,997,591.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 $32,635.25 $32,635.25 $7,250,000.00 0.45 %$7,217,364.75 Stormwater Fund 401-000-000-597-00-00-00 Transfer-Out - Fund 301 $0.00 $0.00 $50,000.00 0.00 %$50,000.00 Stormwater Utility Admin 401-000-001-522-10-40-00 B&O Tax on SWU Revenue $0.00 $0.00 $20,000.00 0.00 %$20,000.00 401-000-001-531-00-10-00 Salaries - Stormwater Admin $0.00 $0.00 $30,000.00 0.00 %$30,000.00 401-000-001-531-00-20-00 Benefits - Stormwater Admin $0.00 $0.00 $13,200.00 0.00 %$13,200.00 401-000-001-531-00-30-00 Supplies - Stormwater Admin $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-531-00-30-01 Small Tools & Equipment $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-001-531-00-40-00 Cell Phone $52.26 $52.26 $750.00 6.97 %$697.74 401-000-001-531-00-40-01 Fee Collection - Douglas Co.$0.00 $0.00 $8,500.00 0.00 %$8,500.00 401-000-001-531-00-40-02 Insurance $0.00 $0.00 $7,313.00 0.00 %$7,313.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 401-000-001-582-30-00-00 Non-Fiduciary Remittance $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Stormwater Utility Admin $4,793.27 $9,534.28 $155,263.00 6.14 %$145,728.72 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $0.00 $0.00 $25,000.00 0.00 %$25,000.00 401-000-002-531-00-20-01 Benefits - NPDES Admin $0.00 $0.00 $11,000.00 0.00 %$11,000.00 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 Account Number Title Period Fiscal Budget % of Total Balance 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 $0.00 $0.00 $49,500.00 0.00 %$49,500.00 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 $8,000.00 0.00 %$8,000.00 Total NPDES Public Involvement $0.00 $0.00 $8,700.00 0.00 %$8,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 $0.00 $600.00 0.00 %$600.00 Total NPDES Construction $0.00 $0.00 $2,100.00 0.00 %$2,100.00 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $0.00 $0.00 $600.00 0.00 %$600.00 Total NPDES Post Construction $0.00 $0.00 $2,100.00 0.00 %$2,100.00 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $1,999.42 $1,999.42 $73,000.00 2.74 %$71,000.58 401-000-008-531-00-10-08 Salaries - Sweeping $148.55 $148.55 $22,000.00 0.68 %$21,851.45 401-000-008-531-00-20-07 Benefits - NPDES PPGH $1,074.06 $1,329.91 $29,200.00 4.55 %$27,870.09 401-000-008-531-00-20-08 Benefits - Sweeping $123.81 $415.28 $11,000.00 3.78 %$10,584.72 401-000-008-531-00-30-05 Supplies - NPDES PPGH $63.03 $63.03 $20,000.00 0.32 %$19,936.97 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 $608.81 $608.81 $7,000.00 8.70 %$6,391.19 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $0.00 $0.00 $5,000.00 0.00 %$5,000.00 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 $150.00 $150.00 $5,000.00 3.00 %$4,850.00 401-000-008-531-00-40-07 Decant Facility Tipping Fee $0.00 $0.00 $75,000.00 0.00 %$75,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 $4,167.68 $4,715.00 $277,600.00 1.70 %$272,885.00 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 Account Number Title Period Fiscal Budget % of Total Balance 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 $75,000.00 0.00 %$75,000.00 401-000-012-594-31-60-05 Small Improvements Projects $0.00 $0.00 $50,000.00 0.00 %$50,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 $0.00 $0.00 $45,000.00 0.00 %$45,000.00 401-000-016-594-31-60-00 Pace Pond $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Stormwater Fund $8,960.95 $14,249.28 $962,863.00 1.48 %$948,613.72 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $104.74 $473.76 $5,300.00 8.94 %$4,826.24 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $60.94 $446.28 $2,800.00 15.94 %$2,353.72 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $1,747.40 $1,855.76 $35,000.00 5.30 %$33,144.24 501-000-000-548-30-10-00 Street Vehicle Repair Labor $833.46 $2,045.73 $24,000.00 8.52 %$21,954.27 501-000-000-548-30-20-00 Street Vehicle Repair Benefits $444.38 $1,595.93 $12,000.00 13.30 %$10,404.07 501-000-000-548-30-30-25 Street Vehicle Repair Supplies $584.17 $606.86 $5,000.00 12.14 %$4,393.14 501-000-000-548-30-48-20 Street Vehicle Repairs & Maintenance $1,888.30 $1,977.04 $23,000.00 8.60 %$21,022.96 501-000-000-548-30-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 $0.00 $0.00 $280,000.00 0.00 %$280,000.00 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $0.00 $160,000.00 0.00 %$160,000.00 501-000-000-594-44-60-20 Capital Outlay - Admin Vehicles $0.00 $0.00 $50,000.00 0.00 %$50,000.00 Total Equipment Purchase, Repair & Replacement Fund $5,663.39 $9,001.36 $603,100.00 1.49 %$594,098.64 Grand Totals $858,899.87 $1,559,538.60 $29,014,178.00 5.38 %$27,454,639.40 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $685,552.78 $1,270,628.00 $10,886,289.00 11.67 %$9,615,661.00 101-000-000-000-00-00-00 Street Fund $110,004.21 $203,956.39 $1,508,500.00 13.52 %$1,304,543.61 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $423,886.00 0.00 %$423,886.00 103-000-000-000-00-00-00 Affordable Housing Sales Tax Fund $0.00 $0.00 $45,000.00 0.00 %$45,000.00 104-000-000-000-00-00-00 Housing & Related Services Fund $0.00 $0.00 $600,000.00 0.00 %$600,000.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $0.00 $322,000.00 0.00 %$322,000.00 112-000-000-000-00-00-00 Library Fund $146.59 $146.59 $6,500.00 2.26 %$6,353.41 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 114-000-000-000-00-00-00 Drug Fund $221.30 $221.30 $0.00 ($221.30) 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $0.00 $20,000.00 0.00 %$20,000.00 117-000-000-000-00-00-00 Events Board Fund $7,805.72 $15,258.58 $143,865.00 10.61 %$128,606.42 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $0.00 $544,000.00 0.00 %$544,000.00 301-000-000-000-00-00-00 Street Improvements Fund $2,847.68 $3,317.85 $5,422,175.00 0.06 %$5,418,857.15 314-000-000-000-00-00-00 Capital Improvements Fund $32,635.25 $32,635.25 $7,250,000.00 0.45 %$7,217,364.75 401-000-000-000-00-00-00 Stormwater Fund $8,960.95 $14,249.28 $962,863.00 1.48 %$948,613.72 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $5,663.39 $9,001.36 $603,100.00 1.49 %$594,098.64 Grand Totals $858,899.87 $1,559,538.60 $29,014,178.00 5.38 %$27,454,639.40 Beginning Activity Ending February 2021 Variance Cash In Cash Ending Cash (Decrease)/Increase 001 $4,936,833.42 $808,523.99 $4,474,729.41 $2,855,708.64 $1,619,020.77 002 $0.00 $0.00 $0.00 $0.00 $0.00 101 $260,311.72 $595,032.88 $651,388.21 $413,363.49 $238,024.72 102 $118,683.19 $0.00 $118,683.19 $74,908.22 $43,774.97 103 $55,491.61 $7,553.33 $63,044.94 $20,805.68 $42,239.26 104 $10,000.00 $105,407.66 $115,407.66 $0.00 $115,407.66 105 $506,934.74 $33,204.60 $540,139.34 $369,734.78 $170,404.56 107 $0.00 $45,000.00 $45,000.00 $0.00 $45,000.00 110 $0.00 $0.00 $0.00 $0.00 $0.00 112 $19,428.94 $0.00 $19,282.35 $14,384.54 $4,897.81 113 $318,181.61 $61,545.28 $369,602.89 $189,299.66 $180,303.23 114 $1,836.11 $6.25 $1,621.06 $1,539.63 $81.43 116 $3,588.52 $5,375.98 $8,964.50 $7,865.74 $1,098.76 117 $21,739.98 $275.00 $6,756.40 $524.58 $6,231.82 202 $566,371.06 $0.00 $566,371.06 $775,826.60 ($209,455.54) 301 $177,978.45 $355,079.34 $529,739.94 $246,033.24 $283,706.70 314 $1,405,618.85 $85,017.46 $1,458,001.06 $1,446,829.81 $11,171.25 401 $1,336,564.47 $44,580.64 $1,366,895.83 $2,130,200.62 ($763,304.79) 501 $316,444.51 $87,530.86 $394,974.01 $338,452.27 $56,521.74 $10,056,007.18 $2,234,133.27 $10,730,601.85 $8,885,477.50 $1,845,124.35 Cash and Investment Activity Period: 2022 - February 2022 Fiscal Totals Fund Activity Rainy Day Fund $0.00 Out General Fund $1,270,628.00 Affordable Housing Sales Tax Fund $0.00 Housing & Related Services Fund $0.00 Street Fund $203,956.39 Community Development Grants Fund $0.00 Financing Reserves Fund $0.00 Library Fund $146.59 Transportation Benefit District Fund $0.00 SWAT Fund $0.00 Criminal Justice Fund $0.00 Events Board Fund $15,258.58 Hotel/Motel Tax Fund $10,124.00 Drug Fund $221.30 Capital Improvements Fund $32,635.25 Bond Redemption Fund $0.00 Street Improvements Fund $3,317.85 $1,559,538.60 Stormwater Fund $14,249.28 Equipment Purchase, Repair & R l t F d $9,001.36