Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2022 - June 2022 Monthly Financial Report - -
City of East Wenatchee August 2, 2022, City Council Meeting June 2022 Financial Report Date: August 2, 2022 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: June 2022 Financial Report This report provides a summary of the City’s overall financial operations through June 30, 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 June 30, 2022, compared to revenue collections through June 30, 2021, along with the respective dollar and percentage variances for its operating funds. Table 1 June 30, 2022 June 30, 2021 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 5,325,880 5,143,724 182,157 3.54% Rainy Day Fund - 002 750,000 - 750,000 - Street Fund - 101 1,167,445 1,118,267 49,177 4.40% Events Board Fund - 117 73,742 62,611 11,131 17.78% Equipment R&R Fund - 501 610,042 201,159 408,882 203.26% Total Revenues - Operating Funds 7,927,108 6,525,761 1,401,347 21.47% 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 August 2, 2022, City Council Meeting June 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 June 30, 2022, compared to revenue collections through June 30, 2021, along with the respective dollar and percentage variances for its non-operating funds. City of East Wenatchee August 2, 2022, City Council Meeting June 2022 Financial Report Table 2 June 30, 2022 June 30, 2021 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 105,882 35,006 70,876 202.47% Affordable Housing Tax Fund - 103 11,016 19,716 (8,700) (44.13%) Housing & Related Services Fund - 104 272,081 - 272,081 - Trans Benefit District Fund - 105 124,163 128,817 (4,655) (3.61%) SWAT Fund - 107 58,500 - 58,500 - Library Fund - 112 3,770 3,752 18 0.47% Hotel/Motel Tax Fund - 113 165,325 128,108 37,217 29.05% Drug Fund - 114 9 11 (2) (14.22%) Criminal Justice Fund - 116 10,755 9,990 766 7.67% Bond Redemption Fund - 202 572 109 462 422.93% Street Improvements Fund - 301 744,195 303,264 440,932 145.40% Capital Improvements Fund - 314 257,704 4,215,054 (3,957,351) (93.89%) Storm Water Fund - 401 608,189 545,477 62,712 11.50% Total Revenues - Non-Operating Funds 2,362,160 5,389,304 (3,027,144) (56.17%) 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 August 2, 2022, City Council Meeting June 2022 Financial Report Revenue Highlights: General Fund revenues are up $182,157, or 3.54%, year over year primarily due to a: $59,834 increase in criminal justice sales tax; $42,040 increase in gambling tax; and a $35,023 increase in fees received for building & structure permits. Sales tax is up $5,419, or .23%, year over year. Rainy Day Fund revenues are up $750,000 year over year because this is a new fund for 2022 established and approved by the City Council in the City’s new financial management policy. Street Fund revenues are up $49,177, or 4.4%, year over year due to a $80,000 greater sales tax allocation to this fund now versus last year. Events Fund revenues are up $11,131, or 17.78%, year over year due to the revenue generated for the 2022 Classy Chassis parade and car show. Equipment R&R Fund revenues are up $408,882, or 203.26%, 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, and due to the timing differences of funds transferred into this fund. Community Development Grants Fund revenues are up $70,876, or 202.47%, year over year due to the timing of projects and reimbursements associated with these federal grant funds. Housing & Related Services Fund revenues are up $272,081 year over year because the City did not begin receiving this tax until August 2021. SWAT Fund revenues are up $58,500 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 $37,217, or 29.05%, year over year presumably due to an increase in hotel stays in the City. Street Improvements Fund revenues are up $440,932, or 145.40%, year over year due to the normal timing differences of projects associated with this fund. Capital Improvements Fund revenues are down $3,957,351, or 93.89%, year over year because by this time last year the City had drawn from its Banner Bank bond to purchase the Simon St. location. The City has not needed to draw from its bond yet in 2022. Table 3 below shows the City’s expenditures through June 30, 2022, compared to expenditures through June 30, 2021, along with respective dollar and percentage variances for its operating funds. City of East Wenatchee August 2, 2022, City Council Meeting June 2022 Financial Report Table 3 June 30, 2022 June 30, 2021 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 5,202,445 3,705,554 1,496,891 40.40% Rainy Day Fund - 002 - - - - Street Fund - 101 726,621 624,514 102,108 16.35% Events Board Fund - 117 63,302 52,193 11,109 21.29% Equipment R&R Fund - 501 576,230 268,656 307,575 114.49% Total Expenditures - Operating Funds 6,568,599 4,650,916 1,917,683 41.23% Expenditures - Operating Funds Chart 3 is a graphical representation of year over year expenditure comparisons for the City’s operating funds. Chart 3 Table 4 below shows the City’s expenditures through June 30, 2022, compared to expenditures through June 30, 2021, along with respective dollar and percentage variances for its non-operating funds. City of East Wenatchee August 2, 2022, City Council Meeting June 2022 Financial Report Table 4 June 30, 2022 June 30, 2021 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - 41,331 (41,331) (100.00%) Affordable Housing Tax Fund - 103 - - - - Housing & Related Services Fund - 104 - - - - Trans Benefit District Fund - 105 - - - - SWAT Fund - 107 15,678 - 15,678 - Library Fund - 112 845 1,628 (783) (48.10%) Hotel/Motel Tax Fund - 113 113,372 90,372 23,000 25.45% Drug Fund - 114 221 - 221 - Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 176,800 170,975 5,825 - Street Improvements Fund - 301 324,732 267,476 57,256 21.41% Capital Improvements Fund - 314 255,099 4,060,506 (3,805,407) (93.72%) Storm Water Fund - 401 212,741 333,754 (121,014) (36.26%) Total Expenditures - Non-Operating Funds 1,099,488 4,966,042 (3,866,553) (77.86%) 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 City of East Wenatchee August 2, 2022, City Council Meeting June 2022 Financial Report Expenditure Highlights: General Fund expenditures are up $1,496,891, or 40.40%, year over year primarily due to a: $750,000 transfer to the Rainy Day Fund; $357,291 transfer to the Equipment R&R Fund (this transfer happened in 2021 too but later in the year); $36,525 increase in fleet rental costs for the Police Department; and General overall salary and benefit increases Street Fund expenditures are up $102,108, or 16.35%, 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 up $307,575, or 114.49%, year over year due to the timing of the purchase of new vehicles compared to when they were purchased last year. Street Improvements Fund expenditures are up $57,256, or 21.41%, year over year due to typical timing and project size variances associated with the capital projects in this fund. Capital Improvements Fund expenditures are down $3,805,407, or 93.72%, year over year due to the 2021 Simon St. building purchase. Storm Water Fund expenditures are down $121,014, or 36.26%, year over year primarily because the City’s own storm water fees are no longer expended out of 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 June 30, 2022. Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $123,972.44 $574,129.05 $1,318,200.00 43.55 %$744,070.95 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $376,539.97 $1,742,603.24 $3,850,000.00 45.26 %$2,107,396.76 001-000-000-313-71-00-00 Criminal Justice Sales Tax $41,674.76 $268,333.11 $307,277.00 87.33 %$38,943.89 001-000-000-316-40-00-00 Electric Utility Tax $26,342.46 $213,781.84 $360,230.00 59.35 %$146,448.16 001-000-000-316-45-00-00 Natural Gas Utility Tax $3,127.65 $36,833.75 $35,409.00 104.02 %($1,424.75) 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $11,392.13 $69,725.87 $180,000.00 38.74 %$110,274.13 001-000-000-316-84-00-00 Gambling Tax $0.00 $262,772.51 $329,394.00 79.77 %$66,621.49 Total Taxes $583,049.41 $3,168,179.37 $6,380,510.00 49.65 %$3,212,330.63 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $0.00 $500.00 $500.00 100.00 %$0.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $0.00 $644.00 $800.00 80.50 %$156.00 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $44,309.13 $91,692.00 48.32 %$47,382.87 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 $10,540.33 $80,153.73 $103,970.00 77.09 %$23,816.27 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 $11,395.00 $55,105.64 $100,000.00 55.11 %$44,894.36 001-000-000-322-90-01-00 Gun Permits $840.00 $3,649.75 $5,741.00 63.57 %$2,091.25 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $125.00 0.00 %$125.00 Total Licenses and Permits $22,775.33 $188,362.25 $303,488.00 62.07 %$115,125.75 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 $1,528,692.50 $1,528,692.50 $1,528,692.00 100.00 %($0.50) 001-000-000-332-92-10-00 IRS Refund $0.00 $154.87 $0.00 ($154.87) 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-03-51-13 TSC - Walker & Roller Safety Project $3,426.88 $3,426.88 $0.00 ($3,426.88) 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-334-06-95-00 RIVERCOM 911 Funding Assistance $11,211.77 $11,211.77 $0.00 ($11,211.77) 001-000-000-335-00-91-00 PUD Privilege Tax $0.00 $44,365.75 $43,000.00 103.18 %($1,365.75) 001-000-000-336-00-87-00 City Hardship Assistance $0.00 $21,764.70 $0.00 ($21,764.70) 001-000-000-336-00-98-03 City Assistance $27,064.60 $37,289.40 $20,000.00 186.45 %($17,289.40) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $10,801.42 $21,602.84 $30,000.00 72.01 %$8,397.16 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $1,185.47 $2,000.00 59.27 %$814.53 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $50,425.14 $89,075.00 56.61 %$38,649.86 Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 501-000-000-397-00-00-05 Stormwater - Fleet Maintenance Rentals Period: 2022 - June 2022 Account Number Title Period Fiscal Budget % of Total Balance 001-000-000-336-06-95-00 Liquor Board Profits $27,496.76 $54,994.22 $107,580.00 51.12 %$52,585.78 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 001-000-000-341-35-31-00 Copy and Duplication Fees - Admin $0.00 $110.25 $70.00 157.50 %($40.25) 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 Admin fee $0.00 $21,388.18 $80,000.00 26.74 %$58,611.82 001-000-000-341-35-36-00 Admin Fees - Other $0.00 $7,299.42 $0.00 ($7,299.42) 001-000-000-341-96-00-00 Personnel Services $0.00 $5,668.62 $0.00 ($5,668.62) 001-000-000-342-33-00-00 Adult Probation Services $0.00 $16,149.52 $61,966.00 26.06 %$45,816.48 001-000-000-342-36-00-00 Housing of Prisoners $0.00 $2,055.26 $19,256.00 10.67 %$17,200.74 001-000-000-342-40-00-01 Fire Marshall Inspection Services $326.00 $1,082.00 $4,000.00 27.05 %$2,918.00 001-000-000-345-83-00-00 Plan Checking Fees $6,636.89 $28,585.94 $50,000.00 57.17 %$21,414.06 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $888.89 $1,000.00 88.89 %$111.11 001-000-000-345-86-00-00 Sepa Permits $0.00 $519.00 $1,200.00 43.25 %$681.00 001-000-000-345-89-00-00 Planning & Development Fees $261.00 $5,089.00 $7,000.00 72.70 %$1,911.00 Total Charges for Goods and Services $7,223.89 $88,836.08 $224,742.00 39.53 %$135,905.92 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $0.00 $35,074.96 $175,420.00 19.99 %$140,345.04 001-000-000-357-33-00-00 Public Defender Costs $0.00 $3,493.70 $22,453.00 15.56 %$18,959.30 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.00 $0.75 $0.00 ($0.75) Total Fines and Penalties $0.00 $38,569.41 $198,273.00 19.45 %$159,703.59 Miscellaneous Revenues 001-000-000-361-10-00-00 Interest Earnings $4,727.98 $14,937.61 $30,000.00 49.79 %$15,062.39 001-000-000-361-40-00-00 Sales Tax Interest $280.45 $1,241.68 $4,000.00 31.04 %$2,758.32 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,301.22 $4,085.32 $14,006.00 29.17 %$9,920.68 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 $134.73 $22,183.74 $7,000.00 316.91 %($15,183.74) Total Miscellaneous Revenues $6,444.38 $42,448.35 $82,606.00 51.39 %$40,157.65 Other Increases in Fund Resources 001-000-000-380-00-50-02 Douglas County Reimbursement $4,351.78 $4,351.78 $0.00 ($4,351.78) 001-000-000-382-10-00-00 Fireworks - Cleaning Deposit $0.00 $2,000.00 $2,350.00 85.11 %$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-30-40-00 Engineering Reimbursements $13.00 $19.50 $0.00 ($19.50) Total Other Increases in Fund Resources $4,364.78 $6,371.28 $2,550.00 249.85 %($3,821.28) 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 $2,232,551.72 $5,325,880.28 $9,606,645.00 55.44 %$4,280,764.72 Rainy Day Fund 002-000-000-397-00-00-00 Transfer In - General Fund $750,000.00 $750,000.00 $750,000.00 100.00 %$0.00 Account Number Title Period Fiscal Budget % of Total Balance Total Rainy Day Fund $750,000.00 $750,000.00 $750,000.00 100.00 %$0.00 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $0.00 $500,000.00 $500,000.00 100.00 %$0.00 101-000-000-313-11-00-00 Sales & Use Tax $0.00 $550,000.00 $550,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $250.00 $500.00 $2,000.00 25.00 %$1,500.00 101-000-000-336-00-71-00 Multi-Modal Distribution $4,669.64 $9,339.40 $18,000.00 51.89 %$8,660.60 101-000-000-336-00-87-00 Gas Tax $20,580.70 $98,314.71 $250,000.00 39.33 %$151,685.29 101-000-000-336-00-87-05 Increased Gas Tax $4,085.98 $8,172.06 $16,000.00 51.08 %$7,827.94 101-000-000-343-14-00-00 Storm Water Utility $0.00 $351.00 $0.00 ($351.00) 101-000-000-361-10-00-00 Interest Earnings $32.94 $267.51 $0.00 ($267.51) 101-000-000-369-91-01-05 Miscellaneous Revenue $0.00 $500.00 $500.00 100.00 %$0.00 Total Street Fund $29,619.26 $1,167,444.68 $1,336,500.00 87.35 %$169,055.32 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $29,730.77 $105,761.94 $423,886.00 24.95 %$318,124.06 102-000-000-361-10-00-00 Interest Earnings $14.75 $119.80 $0.00 ($119.80) Total Community Development Grants Fund $29,745.52 $105,881.74 $423,886.00 24.98 %$318,004.26 Affordable Housing Sales Tax Fund 103-000-000-313-27-00-00 Affordable & Supportive Housing Sales/Use Tax $0.00 $10,959.89 $32,000.00 34.25 %$21,040.11 103-000-000-361-10-00-00 Interest Earnings $6.90 $56.02 $0.00 ($56.02) Total Affordable Housing Sales Tax Fund $6.90 $11,015.91 $32,000.00 34.42 %$20,984.09 Housing & Related Services Fund 104-000-000-313-25-00-00 Housing & Related Services Sales/Use Tax $44,137.12 $272,071.26 $440,000.00 61.83 %$167,928.74 104-000-000-361-10-00-00 Interest Earnings $1.24 $10.09 $0.00 ($10.09) Total Housing & Related Services Fund $44,138.36 $272,081.35 $440,000.00 61.84 %$167,918.65 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $24,314.40 $123,651.00 $250,000.00 49.46 %$126,349.00 105-000-000-361-10-00-00 Interest Earnings $63.02 $511.72 $200.00 255.86 %($311.72) Total Transportation Benefit District Fund $24,377.42 $124,162.72 $250,200.00 49.63 %$126,037.28 SWAT Fund 107-000-000-330-00-00-01 CCSO SWAT Fee $0.00 $15,000.00 $0.00 ($15,000.00) 107-000-000-330-00-00-02 City of Wenatchee SWAT Fee $0.00 $15,000.00 $0.00 ($15,000.00) 107-000-000-330-00-00-03 DCSO SWAT Fee $0.00 $15,000.00 $0.00 ($15,000.00) 107-000-000-397-00-00-00 Transfer-In - General Fund EWPD SWAT Fee $0.00 $13,500.00 $0.00 ($13,500.00) Total SWAT Fund $0.00 $58,500.00 $0.00 ($58,500.00) Library Fund 112-000-000-347-20-00-00 Library Services $3,750.00 $3,750.00 $7,500.00 50.00 %$3,750.00 112-000-000-361-10-00-00 Interest Earnings $2.42 $19.62 $25.00 78.48 %$5.38 Total Library Fund $3,752.42 $3,769.62 $7,525.00 50.09 %$3,755.38 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $30,252.71 $165,003.46 $250,000.00 66.00 %$84,996.54 113-000-000-361-10-00-00 Interest Earnings $39.55 $321.18 $0.00 ($321.18) Account Number Title Period Fiscal Budget % of Total Balance Total Hotel/Motel Tax Fund $30,292.26 $165,324.64 $250,000.00 66.13 %$84,675.36 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $0.00 $7.32 $100.00 7.32 %$92.68 114-000-000-361-10-00-00 Interest Earnings $0.23 $1.85 $0.00 ($1.85) Total Drug Fund $0.23 $9.17 $100.00 9.17 %$90.83 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $2,360.85 $4,500.00 52.46 %$2,139.15 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $8,390.89 $16,000.00 52.44 %$7,609.11 116-000-000-361-10-00-00 Interest Earnings $0.45 $3.63 $0.00 ($3.63) Total Criminal Justice Fund $0.45 $10,755.37 $20,500.00 52.47 %$9,744.63 Events Board Fund 117-000-100-361-10-00-00 Interest Earnings $2.70 $21.95 $0.00 ($21.95) 117-000-100-397-00-00-00 Transfer-In from Fund 113 $0.00 $60,000.00 $120,000.00 50.00 %$60,000.00 117-000-300-347-40-12-02 Classy Chassis Parade/Car Show $0.00 $10,400.00 $9,000.00 115.56 %($1,400.00) 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $0.00 $350.00 $150.00 233.33 %($200.00) 117-000-300-347-90-00-12 Classy Chassis Sponsorships $0.00 $1,600.00 $8,000.00 20.00 %$6,400.00 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $1,370.00 $500.00 274.00 %($870.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-500-367-19-00-01 Christmas Sponsorships $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Events Board Fund $2.70 $73,741.95 $151,650.00 48.63 %$77,908.05 Bond Redemption Fund 202-000-000-361-10-00-00 Interest Earnings $70.41 $571.72 $0.00 ($571.72) Total Bond Redemption Fund $70.41 $571.72 $0.00 ($571.72) Street Improvements Fund 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 $10,276.99 $1,096,000.00 0.94 %$1,085,723.01 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 $26,356.33 $200,000.00 13.18 %$173,643.67 301-000-000-333-20-00-23 SRTS - 5th St NE: Kenroy $0.00 $26,401.71 $253,000.00 10.44 %$226,598.29 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 $25,901.31 $25,901.31 $86,500.00 29.94 %$60,598.69 301-000-000-334-03-80-21 TIB 2022 Complete Streets $300,000.00 $300,000.00 $550,000.00 54.55 %$250,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-337-00-00-01 GWID - 10th St. NE Improvements $0.00 $49,651.51 $0.00 ($49,651.51) 301-000-000-337-00-00-02 EWWD - 10th St. NE Improvements $0.00 $15,360.06 $0.00 ($15,360.06) 301-000-000-361-10-00-00 Interest Earnings $22.13 $179.67 $0.00 ($179.67) 301-000-000-397-00-00-00 Transfer-In - Fund 401 $0.00 $0.00 $50,000.00 0.00 %$50,000.00 Account Number Title Period Fiscal Budget % of Total Balance 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 $325,923.44 $744,195.35 $5,014,912.00 14.84 %$4,270,716.65 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $54,695.82 $256,284.80 $450,000.00 56.95 %$193,715.20 314-000-000-361-10-00-00 Interest Earnings $174.74 $1,418.86 $0.00 ($1,418.86) 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 $54,870.56 $257,703.66 $6,450,000.00 4.00 %$6,192,296.34 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 $22,539.00 $47,798.00 $75,000.00 63.73 %$27,202.00 401-000-000-334-03-10-02 Stormwater Comp Plan Ecology Grant $0.00 $51,844.90 $40,000.00 129.61 %($11,844.90) 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 $56,808.00 $505,948.50 $525,000.00 96.37 %$19,051.50 401-000-000-361-10-00-00 Interest Earnings $220.09 $1,442.04 $0.00 ($1,442.04) 401-000-000-382-30-00-00 Non-Fiduciary Collections $0.00 $1,155.39 $0.00 ($1,155.39) Total Stormwater Fund $79,567.09 $608,188.83 $817,500.00 74.40 %$209,311.17 Equipment Purchase, Repair & Replacement Fund 501-000-000-361-10-00-00 Interest Earnings $39.34 $319.43 $0.00 ($319.43) 501-000-000-395-20-00-00 Insurance Recoveries - Police $0.00 $5,080.72 $0.00 ($5,080.72) 501-000-000-397-00-00-00 Transfer In - General Fund $357,291.00 $357,291.00 $357,291.00 100.00 %$0.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 501-000-000-397-00-00-03 Police - Fleet Maintenance Rentals $20,822.92 $124,937.52 $250,000.00 49.98 %$125,062.48 501-000-000-397-00-00-04 Street - Fleet Maintenance Rentals $15,661.14 $93,966.84 $188,000.00 49.98 %$94,033.16 501-000-000-397-00-00-05 Stormwater - Fleet Maintenance Rentals $4,741.01 $28,446.06 $57,000.00 49.91 %$28,553.94 Total Equipment Purchase, Repair & Replacement Fund $398,555.41 $610,041.57 $872,291.00 69.94 %$262,249.43 Grand Totals $4,003,474.15 $10,289,268.56 $26,423,709.00 38.94 %$16,134,440.44 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $2,232,551.72 $5,325,880.28 $9,606,645.00 55.44 %$4,280,764.72 002-000-000-000-00-00-00 Rainy Day Fund $750,000.00 $750,000.00 $750,000.00 100.00 %$0.00 101-000-000-000-00-00-00 Street Fund $29,619.26 $1,167,444.68 $1,336,500.00 87.35 %$169,055.32 102-000-000-000-00-00-00 Community Development Grants Fund $29,745.52 $105,881.74 $423,886.00 24.98 %$318,004.26 103-000-000-000-00-00-00 Affordable Housing Sales Tax Fund $6.90 $11,015.91 $32,000.00 34.42 %$20,984.09 104-000-000-000-00-00-00 Housing & Related Services Fund $44,138.36 $272,081.35 $440,000.00 61.84 %$167,918.65 105-000-000-000-00-00-00 Transportation Benefit District Fund $24,377.42 $124,162.72 $250,200.00 49.63 %$126,037.28 107-000-000-000-00-00-00 SWAT Fund $0.00 $58,500.00 $0.00 ($58,500.00) 112-000-000-000-00-00-00 Library Fund $3,752.42 $3,769.62 $7,525.00 50.09 %$3,755.38 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $30,292.26 $165,324.64 $250,000.00 66.13 %$84,675.36 114-000-000-000-00-00-00 Drug Fund $0.23 $9.17 $100.00 9.17 %$90.83 116-000-000-000-00-00-00 Criminal Justice Fund $0.45 $10,755.37 $20,500.00 52.47 %$9,744.63 117-000-000-000-00-00-00 Events Board Fund $2.70 $73,741.95 $151,650.00 48.63 %$77,908.05 202-000-000-000-00-00-00 Bond Redemption Fund $70.41 $571.72 $0.00 ($571.72) 301-000-000-000-00-00-00 Street Improvements Fund $325,923.44 $744,195.35 $5,014,912.00 14.84 %$4,270,716.65 314-000-000-000-00-00-00 Capital Improvements Fund $54,870.56 $257,703.66 $6,450,000.00 4.00 %$6,192,296.34 401-000-000-000-00-00-00 Stormwater Fund $79,567.09 $608,188.83 $817,500.00 74.40 %$209,311.17 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $398,555.41 $610,041.57 $872,291.00 69.94 %$262,249.43 Grand Totals $4,003,474.15 $10,289,268.56 $26,423,709.00 38.94 %$16,134,440.44 Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 001-000-001-518-63-40-00 Flywheel Conference $0.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 $156.09 $980.86 $2,000.00 49.04 %$1,019.14 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 $13,365.00 $27,000.00 49.50 %$13,635.00 001-000-001-528-70-40-00 River Com $0.00 $87,500.00 $261,251.00 33.49 %$173,751.00 001-000-001-531-00-40-00 Annual SWU Charge $0.00 $86,750.40 $82,500.00 105.15 %($4,250.40) 001-000-001-539-30-40-00 Animal Control $7,186.07 $43,116.42 $86,233.00 50.00 %$43,116.58 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 $16,309.45 $14,221.00 114.69 %($2,088.45) 001-000-001-558-70-40-00 Contributions - Region $0.00 $30,000.00 $30,000.00 100.00 %$0.00 001-000-001-558-70-40-02 ARPA Contributions $0.00 $40,000.00 $500,000.00 8.00 %$460,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 $1,550.00 $1,500.00 103.33 %($50.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 $3,000.00 $3,000.00 100.00 %$0.00 001-000-001-558-70-41-15 Wenatchee Valley Museum $5,062.00 $30,372.00 $61,000.00 49.79 %$30,628.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $1,027.44 $3,600.00 28.54 %$2,572.56 001-000-001-597-00-00-01 Transfer Out - ER&R Fund $357,291.00 $357,291.00 $357,291.00 100.00 %$0.00 001-000-001-597-00-00-02 Transfer Out - Rainy Day Fund $750,000.00 $750,000.00 $750,000.00 100.00 %$0.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 $1,121,922.66 $1,467,662.57 $2,707,811.00 54.20 %$1,240,148.43 Legislative 001-000-110-511-60-10-00 Salaries $4,745.72 $28,385.07 $56,700.00 50.06 %$28,314.93 001-000-110-511-60-20-00 Benefits $361.48 $2,168.88 $4,338.00 50.00 %$2,169.12 001-000-110-511-60-21-50 Public Defender $12,155.00 $61,013.00 $135,000.00 45.19 %$73,987.00 001-000-110-511-60-30-00 Public Defender Conflicts $82.50 $375.00 $5,200.00 7.21 %$4,825.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-31-10 Public Records Expenses $0.00 $26.95 $0.00 ($26.95) 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 $0.00 $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 $26,117.82 $25,000.00 104.47 %($1,117.82) Expenditure Starting Account Number: 001-000-001-518-20-40-00 Property Management - 311 9th St NE Ending Account Number: 501-001-000-508-51-00-00 Assigned Cash and Investments - Ending Period: 2022 - June 2022 Account Number Title Period Fiscal Budget % of Total Balance 001-000-110-511-60-46-00 Insurance $0.00 $40.20 $9,563.00 0.42 %$9,522.80 001-000-110-511-60-47-00 Background Check Costs $0.00 $66.00 $200.00 33.00 %$134.00 001-000-110-511-60-49-00 Miscellaneous $0.00 $70.00 $2,500.00 2.80 %$2,430.00 Total Legislative $17,344.70 $140,524.74 $270,514.00 51.95 %$129,989.26 Mayor's Office 001-000-111-513-10-10-00 Salaries $8,213.66 $49,347.10 $102,000.00 48.38 %$52,652.90 001-000-111-513-10-20-00 Benefits $3,323.56 $23,660.67 $33,000.00 71.70 %$9,339.33 001-000-111-513-10-30-00 Office Supplies $0.00 $0.00 $250.00 0.00 %$250.00 001-000-111-513-10-40-00 Publications $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-111-513-10-40-01 Training $0.00 $35.00 $2,000.00 1.75 %$1,965.00 001-000-111-513-10-40-02 Professional Services $0.00 $2,090.50 $30,000.00 6.97 %$27,909.50 001-000-111-513-10-40-03 Cell Phone $74.14 $242.45 $550.00 44.08 %$307.55 001-000-111-513-10-40-04 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-111-513-10-40-05 Insurance $0.00 $40.20 $9,563.00 0.42 %$9,522.80 001-000-111-513-10-40-06 Miscellaneous $250.00 $310.00 $250.00 124.00 %($60.00) Total Mayor's Office $11,861.36 $75,725.92 $188,613.00 40.15 %$112,887.08 Municipal Court 001-000-120-512-50-10-00 Salaries $0.00 $0.00 $0.00 $0.00 001-000-120-512-50-12-00 Salaries - Probation Services $0.00 $0.00 $0.00 $0.00 001-000-120-512-50-20-00 Benefits $130.42 $1,906.89 $0.00 ($1,906.89) 001-000-120-512-50-22-00 Benefits - Probation Services $0.00 $0.00 $0.00 $0.00 001-000-120-512-50-46-00 Insurance $0.00 $66.99 $0.00 ($66.99) 001-000-120-512-51-10-00 Salaries $23,838.51 $139,372.08 $284,000.00 49.07 %$144,627.92 001-000-120-512-51-10-01 Salaries - Probation $5,238.58 $31,431.48 $63,000.00 49.89 %$31,568.52 001-000-120-512-51-20-00 Benefits $8,908.48 $52,862.63 $102,000.00 51.83 %$49,137.37 001-000-120-512-51-20-01 Benefits - Probation $3,239.70 $19,379.62 $39,636.00 48.89 %$20,256.38 001-000-120-512-51-30-00 Supplies $34.69 $1,020.46 $4,500.00 22.68 %$3,479.54 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 $80.00 $800.00 $5,000.00 16.00 %$4,200.00 001-000-120-512-51-40-05 Judge Protems $450.00 $2,475.00 $4,000.00 61.88 %$1,525.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 $0.00 $1,926.13 $6,000.00 32.10 %$4,073.87 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 $317.59 $1,533.52 $5,000.00 30.67 %$3,466.48 Total Municipal Court $42,237.97 $253,314.80 $544,184.00 46.55 %$290,869.20 Human Resources 001-000-139-518-10-10-00 Salaries $3,776.99 $22,656.18 $46,000.00 49.25 %$23,343.82 001-000-139-518-10-20-00 Benefits $1,754.57 $10,255.70 $20,000.00 51.28 %$9,744.30 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 $33.69 $216.69 $1,300.00 16.67 %$1,083.31 001-000-139-518-10-40-01 Membership Dues & Publications $169.00 $623.00 $1,000.00 62.30 %$377.00 Account Number Title Period Fiscal Budget % of Total Balance 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 $0.00 $4,006.04 $1,000.00 400.60 %($3,006.04) 001-000-139-518-10-40-04 Insurance $0.00 $13.40 $3,938.00 0.34 %$3,924.60 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 $72.00 $72.00 $700.00 10.29 %$628.00 001-000-139-518-10-40-08 Professional Services $28.30 $188.50 $1,000.00 18.85 %$811.50 Total Human Resources $5,834.55 $38,037.46 $76,938.00 49.44 %$38,900.54 City Clerk 001-000-140-514-20-10-00 Salaries $8,357.56 $36,494.84 $102,000.00 35.78 %$65,505.16 001-000-140-514-20-20-00 Benefits $3,564.18 $23,876.88 $53,000.00 45.05 %$29,123.12 001-000-140-514-20-31-00 Office Supplies $611.59 $1,235.29 $3,000.00 41.18 %$1,764.71 001-000-140-514-20-31-01 Central Stores $704.99 $3,546.73 $6,000.00 59.11 %$2,453.27 001-000-140-514-20-40-00 Training $1,859.00 $2,599.00 $3,000.00 86.63 %$401.00 001-000-140-514-20-40-01 Records Services $0.00 $837.00 $500.00 167.40 %($337.00) 001-000-140-514-20-40-02 Codification $4,951.44 $4,951.44 $1,400.00 353.67 %($3,551.44) 001-000-140-514-20-41-00 Membership Dues & Publications $235.19 $525.19 $1,200.00 43.77 %$674.81 001-000-140-514-20-43-00 Travel $435.72 $992.58 $2,000.00 49.63 %$1,007.42 001-000-140-514-20-44-00 Advertising $0.00 $1,437.39 $2,000.00 71.87 %$562.61 001-000-140-514-20-46-00 Insurance $0.00 $33.50 $8,213.00 0.41 %$8,179.50 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 $180.49 $500.00 36.10 %$319.51 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 $20,719.67 $76,710.33 $186,413.00 41.15 %$109,702.67 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $665.64 $3,653.54 $12,500.00 29.23 %$8,846.46 001-000-141-514-20-42-01 Telephone Line Charges $1,427.60 $7,465.19 $14,000.00 53.32 %$6,534.81 001-000-141-514-20-42-03 Postage $0.00 $239.56 $6,000.00 3.99 %$5,760.44 001-000-141-514-20-48-00 Repairs & Maintenance $0.00 $1,397.18 $4,000.00 34.93 %$2,602.82 Total Internal Services $2,093.24 $12,755.47 $36,500.00 34.95 %$23,744.53 Finance 001-000-142-514-20-10-00 Salaries $14,769.28 $84,541.11 $182,000.00 46.45 %$97,458.89 001-000-142-514-20-20-00 Benefits $6,029.06 $30,321.90 $72,000.00 42.11 %$41,678.10 001-000-142-514-20-31-00 Office Supplies $333.67 $2,031.37 $1,600.00 126.96 %($431.37) 001-000-142-514-20-40-00 State Audit $0.00 $12,254.25 $30,000.00 40.85 %$17,745.75 001-000-142-514-20-40-01 FSA Administrative Fee $50.00 $417.68 $600.00 69.61 %$182.32 001-000-142-514-20-40-02 Bank Charges & Fees $536.68 $3,485.09 $5,500.00 63.37 %$2,014.91 001-000-142-514-20-40-03 Training $0.00 $140.00 $1,500.00 9.33 %$1,360.00 001-000-142-514-20-43-00 Travel $458.52 $458.52 $500.00 91.70 %$41.48 001-000-142-514-20-46-00 Insurance $0.00 $53.60 $13,817.00 0.39 %$13,763.40 001-000-142-594-14-60-00 Capital Outlay $0.00 $0.00 $19,450.00 0.00 %$19,450.00 Total Finance $22,177.21 $133,703.52 $326,967.00 40.89 %$193,263.48 Account Number Title Period Fiscal Budget % of Total Balance Information Technology 001-000-145-514-20-10-00 Salaries $8,805.69 $52,818.48 $107,000.00 49.36 %$54,181.52 001-000-145-514-20-20-00 Benefits $4,006.18 $24,470.92 $47,000.00 52.07 %$22,529.08 001-000-145-514-20-31-00 Supplies $17.75 $31.03 $1,000.00 3.10 %$968.97 001-000-145-514-20-40-01 Memberships $75.00 $75.00 $100.00 75.00 %$25.00 001-000-145-514-20-40-05 Disaster Backup System Support $0.00 $10,076.89 $16,000.00 62.98 %$5,923.11 001-000-145-514-20-40-10 Annual Fee - GIS Systems $0.00 $2,093.21 $6,500.00 32.20 %$4,406.79 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $15,846.62 $15,846.62 $23,000.00 68.90 %$7,153.38 001-000-145-514-20-40-21 Annual License - HR Software $0.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 $1,299.60 $3,000.00 43.32 %$1,700.40 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.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 $11,166.83 $21,000.00 53.18 %$9,833.17 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 $6,443.34 $7,500.00 85.91 %$1,056.66 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $10,211.28 $10,211.28 $9,000.00 113.46 %($1,211.28) 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 $114.46 $363.47 $850.00 42.76 %$486.53 001-000-145-514-20-43-00 Training $0.00 $400.00 $3,000.00 13.33 %$2,600.00 001-000-145-514-20-44-00 Travel $0.00 $625.69 $2,000.00 31.28 %$1,374.31 001-000-145-514-20-45-00 Insurance $0.00 $13.40 $3,375.00 0.40 %$3,361.60 001-000-145-594-14-60-20 Capital - PC Software Admin $2,848.13 $11,884.06 $40,000.00 29.71 %$28,115.94 001-000-145-594-14-60-25 Capital - PC Hardware Admin $1,981.49 $8,817.56 $35,500.00 24.84 %$26,682.44 Total Information Technology $43,906.60 $164,373.38 $359,925.00 45.67 %$195,551.62 Legal 001-000-151-515-31-10-00 Salaries $7,318.97 $43,867.67 $84,000.00 52.22 %$40,132.33 001-000-151-515-31-20-00 Benefits $2,882.88 $17,202.95 $32,000.00 53.76 %$14,797.05 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 $149.03 $2,100.00 7.10 %$1,950.97 001-000-151-515-31-40-02 Membership Dues $0.00 $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 $244.40 $2,000.00 12.22 %$1,755.60 001-000-151-515-31-42-01 Cell Phone $94.46 $303.47 $600.00 50.58 %$296.53 001-000-151-515-31-43-00 Travel $668.11 $668.11 $500.00 133.62 %($168.11) 001-000-151-515-31-46-00 Insurance $0.00 $53.60 $12,690.00 0.42 %$12,636.40 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-41-40-00 Legal Services $6,147.50 $53,917.00 $200,000.00 26.96 %$146,083.00 001-000-151-515-45-40-00 Professional Services $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Legal $17,111.92 $116,947.68 $355,620.00 32.89 %$238,672.32 Account Number Title Period Fiscal Budget % of Total Balance Legal - Public Records 001-000-152-515-31-40-03 Insurance $0.00 $13.40 $0.00 ($13.40) Total Legal - Public Records $0.00 $13.40 $0.00 ($13.40) Civil Service 001-000-160-521-10-10-00 Salaries $425.00 $2,550.00 $5,600.00 45.54 %$3,050.00 001-000-160-521-10-46-00 Insurance $0.00 $26.80 $9,113.00 0.29 %$9,086.20 Total Civil Service $425.00 $2,576.80 $14,713.00 17.51 %$12,136.20 Central Services 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $0.00 $1,089.48 $3,000.00 36.32 %$1,910.52 001-000-180-518-30-35-00 Small Tools & Equipment $46.14 $1,191.77 $7,000.00 17.03 %$5,808.23 001-000-180-518-30-41-00 Professional Services $391.80 $5,052.77 $15,000.00 33.69 %$9,947.23 001-000-180-518-30-41-01 Contracted Custodial Services $5,108.01 $15,034.42 $32,000.00 46.98 %$16,965.58 001-000-180-518-30-46-00 Insurance $0.00 $234.48 $58,500.00 0.40 %$58,265.52 001-000-180-518-30-47-00 Utilities $2,665.11 $14,234.83 $30,000.00 47.45 %$15,765.17 001-000-180-518-30-47-01 Utilities - Simon St.$340.50 $3,189.64 $0.00 ($3,189.64) 001-000-180-518-30-48-00 Repairs & Maintenance $790.16 $3,821.51 $15,000.00 25.48 %$11,178.49 001-000-180-518-30-49-00 Miscellaneous $0.00 ($750.00)$1,000.00 -75.00 %$1,750.00 001-000-180-518-30-49-01 Landscaping $372.08 $746.65 $4,000.00 18.67 %$3,253.35 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$1,814.76 $17,180.18 $9,000.00 190.89 %($8,180.18) 001-000-180-594-18-60-00 Capital Outlay $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Central Services $11,528.56 $61,025.73 $179,500.00 34.00 %$118,474.27 Law Enforcement 001-000-210-521-10-10-00 Salaries $197,990.16 $1,157,670.06 $2,430,000.00 47.64 %$1,272,329.94 001-000-210-521-10-10-02 Overtime - Shift Coverage $29,717.97 $149,877.68 $150,000.00 99.92 %$122.32 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 $91,618.25 $510,771.91 $940,000.00 54.34 %$429,228.09 001-000-210-521-10-20-01 Clothing Allowance $964.64 $7,495.95 $16,800.00 44.62 %$9,304.05 001-000-210-521-10-31-00 Office Supplies $1,283.93 $2,006.00 $8,500.00 23.60 %$6,494.00 001-000-210-521-10-31-05 Office Machine Costs $340.30 $2,341.06 $5,000.00 46.82 %$2,658.94 001-000-210-521-10-32-00 Fuel Consumed $8,171.10 $32,934.65 $55,000.00 59.88 %$22,065.35 001-000-210-521-10-35-00 Small Tools & Equipment $10,188.80 $39,066.19 $23,250.00 168.03 %($15,816.19) 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,618.75 $16,813.22 $15,000.00 112.09 %($1,813.22) 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 $0.00 $12.99 $600.00 2.17 %$587.01 001-000-210-521-10-42-01 Telephone $1,044.92 $15,477.14 $30,000.00 51.59 %$14,522.86 001-000-210-521-10-42-03 Postage $0.00 $503.07 $1,175.00 42.81 %$671.93 001-000-210-521-10-43-00 Travel $1,631.29 $10,580.56 $10,000.00 105.81 %($580.56) 001-000-210-521-10-46-00 Insurance $0.00 $281.38 $79,875.00 0.35 %$79,593.62 001-000-210-521-10-48-00 Repairs & Maintenance $324.78 $3,672.68 $9,500.00 38.66 %$5,827.32 001-000-210-521-10-49-00 Miscellaneous $1,469.75 $7,270.41 $2,500.00 290.82 %($4,770.41) 001-000-210-521-10-49-02 Dry Cleaning Services $0.00 $515.41 $1,200.00 42.95 %$684.59 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-30-40-00 Crime Prevention $20.00 $806.57 $850.00 94.89 %$43.43 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-20-00 Training $1,582.77 $1,582.77 $0.00 ($1,582.77) 001-000-210-521-40-40-00 Training - Police Chief $851.98 $851.98 $1,000.00 85.20 %$148.02 001-000-210-521-40-40-01 Training - Officers $3,883.08 $8,603.08 $4,500.00 191.18 %($4,103.08) 001-000-210-521-40-40-02 Training - Office Staff $0.00 $35.00 $500.00 7.00 %$465.00 001-000-210-521-50-10-00 Ancillary (Interfund Vehicle Maintenance) $0.00 $308.05 $2,400.00 12.84 %$2,091.95 001-000-210-594-21-60-00 Capital Outlay $3,710.68 $23,141.96 $33,000.00 70.13 %$9,858.04 001-000-210-597-00-00-00 Transfer-Out - SWAT Fund $0.00 $13,500.00 $0.00 ($13,500.00) 001-000-210-597-00-00-01 Fleet Rentals - Police $20,822.92 $124,937.52 $250,000.00 49.98 %$125,062.48 Total Law Enforcement $378,236.07 $2,131,057.29 $4,193,698.00 50.82 %$2,062,640.71 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $79,850.44 $239,551.32 $479,103.00 50.00 %$239,551.68 001-000-230-523-60-20-00 Medical Care - Prisoners $0.00 $1,938.71 $9,000.00 21.54 %$7,061.29 001-000-230-527-60-30-00 Juvenile Detention $0.00 $750.00 $7,500.00 10.00 %$6,750.00 Total Jail Services $79,850.44 $242,240.03 $495,603.00 48.88 %$253,362.97 Public Works 001-000-315-542-10-10-00 Salaries $8,173.94 $48,538.60 $98,000.00 49.53 %$49,461.40 001-000-315-542-10-20-00 Benefits $2,900.79 $18,068.78 $36,000.00 50.19 %$17,931.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 $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 $53.60 $14,625.00 0.37 %$14,571.40 001-000-315-542-10-49-00 Training $0.00 $105.00 $2,000.00 5.25 %$1,895.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 $2,561.48 $8,471.63 $20,000.00 42.36 %$11,528.37 Total Public Works $13,636.21 $75,237.61 $175,125.00 42.96 %$99,887.39 Planning 001-000-580-558-60-10-00 Salaries $19,452.09 $117,614.10 $243,000.00 48.40 %$125,385.90 001-000-580-558-60-20-00 Benefits $8,861.04 $47,428.03 $91,000.00 52.12 %$43,571.97 001-000-580-558-60-31-00 Office Supplies $0.00 $114.03 $1,500.00 7.60 %$1,385.97 001-000-580-558-60-32-00 Fuel Consumed $0.00 $66.69 $175.00 38.11 %$108.31 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 $0.00 $1,088.00 $1,700.00 64.00 %$612.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 $1,200.00 $1,800.00 66.67 %$600.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 $207.89 $797.45 $3,000.00 26.58 %$2,202.55 001-000-580-558-60-46-00 Insurance $0.00 $53.60 $15,120.00 0.35 %$15,066.40 001-000-580-558-60-48-00 Repairs & Maintenance $0.00 $91.07 $1,000.00 9.11 %$908.93 Account Number Title Period Fiscal Budget % of Total Balance 001-000-580-558-60-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total Planning $28,521.02 $168,452.97 $390,895.00 43.09 %$222,442.03 Building Department 001-000-590-558-50-10-00 Salaries $643.66 $5,893.81 $106,000.00 5.56 %$100,106.19 001-000-590-558-50-20-00 Benefits $412.59 $7,210.18 $50,000.00 14.42 %$42,789.82 001-000-590-558-50-31-00 Office Supplies $0.00 $80.53 $2,300.00 3.50 %$2,219.47 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 $150.00 $1,644.00 9.12 %$1,494.00 001-000-590-558-50-40-01 Dues & Subscriptions $0.00 $145.00 $500.00 29.00 %$355.00 001-000-590-558-50-41-00 Professional Services $5,773.25 $22,629.01 $0.00 ($22,629.01) 001-000-590-558-50-41-01 Fire Marshal Services $0.00 $5,822.15 $23,000.00 25.31 %$17,177.85 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 $107.60 $107.60 $800.00 13.45 %$692.40 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 $46.90 $12,026.00 0.39 %$11,979.10 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 $6,937.10 $42,085.18 $216,020.00 19.48 %$173,934.82 001-001-000-582-10-00-01 Fireworks - Deposit Refund $0.00 $0.00 $2,500.00 0.00 %$2,500.00 Other Expenditures 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 $164,750.00 0.00 %$164,750.00 Total General Fund $1,824,344.28 $5,202,444.88 $10,886,289.00 47.79 %$5,683,844.12 Street Fund Storm Water Utility Charge 101-000-315-531-00-40-00 Annual SWU Charge $0.00 $83,866.22 $82,500.00 101.66 %($1,366.22) Total Storm Water Utility Charge $0.00 $83,866.22 $82,500.00 101.66 %($1,366.22) 101-000-420-542-30-10-00 Salaries - Roadway $16,079.79 $26,940.83 $60,000.00 44.90 %$33,059.17 101-000-420-542-30-20-00 Benefits - Roadway $9,778.22 $18,049.99 $30,000.00 60.17 %$11,950.01 101-000-420-542-30-30-00 Supplies - Roadway $7,172.92 $37,422.33 $45,000.00 83.16 %$7,577.67 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 $57.40 $11,000.00 0.52 %$10,942.60 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $0.00 $88.09 $5,500.00 1.60 %$5,411.91 101-000-420-542-62-30-00 Supplies - Special Purpose Paths $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-63-10-00 Salaries - Street Lighting $0.00 $25.62 $6,000.00 0.43 %$5,974.38 101-000-420-542-63-20-00 Benefits - Street Lighting $0.00 $18.91 $3,000.00 0.63 %$2,981.09 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,878.51 $9,635.87 $60,000.00 16.06 %$50,364.13 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 $634.01 $20,939.16 $44,600.00 46.95 %$23,660.84 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $354.32 $13,264.09 $22,500.00 58.95 %$9,235.91 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $3,225.08 $37,791.02 $40,000.00 94.48 %$2,208.98 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $791.47 $3,993.47 $9,000.00 44.37 %$5,006.53 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $3,795.53 $4,706.46 $14,000.00 33.62 %$9,293.54 101-000-420-542-65-10-00 Salaries - Parking Facilities $0.00 $2,254.57 $2,000.00 112.73 %($254.57) 101-000-420-542-65-20-00 Benefits - Parking Facilities $0.00 $669.08 $1,000.00 66.91 %$330.92 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 $0.00 $46,472.85 $70,000.00 66.39 %$23,527.15 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $0.00 $21,742.40 $40,000.00 54.36 %$18,257.60 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $0.00 $38,314.36 $100,000.00 38.31 %$61,685.64 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $4,552.48 $12,028.99 $5,000.00 240.58 %($7,028.99) 101-000-420-542-69-10-00 Salaries - Flags/Banners $337.61 $2,232.12 $20,000.00 11.16 %$17,767.88 101-000-420-542-69-20-00 Benefits - Flags/Banners $195.74 $962.03 $12,000.00 8.02 %$11,037.97 101-000-420-542-69-30-00 Supplies - Flags/Banners $375.59 $1,426.90 $2,000.00 71.35 %$573.10 101-000-420-542-70-10-00 Salaries - Roadside $19,049.12 $108,255.61 $247,000.00 43.83 %$138,744.39 101-000-420-542-70-20-00 Benefits - Roadside $13,770.18 $69,525.66 $136,500.00 50.93 %$66,974.34 101-000-420-542-70-30-00 Supplies - Roadside $365.31 $2,306.91 $5,000.00 46.14 %$2,693.09 101-000-420-542-70-41-00 Professional Services - Roadside $0.00 $1,003.63 $3,000.00 33.45 %$1,996.37 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 $4,525.82 $22,486.60 $45,000.00 49.97 %$22,513.40 101-000-420-542-75-20-00 Benefits - City Parks $1,990.58 $11,332.85 $23,000.00 49.27 %$11,667.15 101-000-420-542-75-30-00 Supplies - City Parks $1,315.25 $3,274.18 $14,500.00 22.58 %$11,225.82 101-000-420-542-75-47-00 Utilities - City Parks $337.20 $928.72 $5,000.00 18.57 %$4,071.28 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $167.24 $3,004.19 $4,000.00 75.10 %$995.81 101-000-420-542-80-48-00 Japanese Garden Agreement $0.00 $3,000.00 $12,000.00 25.00 %$9,000.00 101-000-420-542-90-10-00 Salaries - Maintenance Admin $0.00 $316.67 $0.00 ($316.67) 101-000-420-542-90-20-00 Benefits - Maintenance Admin $0.00 $218.33 $0.00 ($218.33) 101-000-430-543-30-10-00 Salaries - General Services $323.84 $2,968.14 $0.00 ($2,968.14) 101-000-430-543-30-20-00 Benefits - General Services $139.03 $5,838.10 $0.00 ($5,838.10) 101-000-430-543-30-30-00 Supplies - General Services $599.99 $4,939.64 $6,000.00 82.33 %$1,060.36 101-000-430-543-30-46-00 Insurance $0.00 $227.74 $63,250.00 0.36 %$63,022.26 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 $297.10 $1,121.88 $4,000.00 28.05 %$2,878.12 101-000-430-543-50-20-00 Benefits - Facilities $62.53 $435.44 $1,800.00 24.19 %$1,364.56 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 $146.49 $499.55 $750.00 66.61 %$250.45 101-000-430-543-50-47-00 Utilities - Facilities $148.40 $4,107.78 $6,500.00 63.20 %$2,392.22 Account Number Title Period Fiscal Budget % of Total Balance 101-000-430-543-50-48-00 Repairs & Maintenance - Facilities $0.00 $382.12 $2,500.00 15.28 %$2,117.88 101-000-430-544-90-10-00 Salaries - Training $0.00 $1,117.20 $7,000.00 15.96 %$5,882.80 101-000-430-544-90-20-00 Benefits - Training $0.00 $398.87 $3,500.00 11.40 %$3,101.13 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 $20.58 $1,422.08 $1,000.00 142.21 %($422.08) 101-000-430-597-00-00-00 Fleet Rentals - Streets $15,661.14 $93,966.84 $188,000.00 49.98 %$94,033.16 Total Street Fund $108,091.07 $726,621.49 $1,508,500.00 48.17 %$781,878.51 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 SWAT Fund 107-000-000-521-10-30-00 Supplies & Equipment $2,878.12 $2,878.12 $0.00 ($2,878.12) 107-000-000-521-40-40-00 Training $0.00 $12,800.00 $0.00 ($12,800.00) Total SWAT Fund $2,878.12 $15,678.12 $0.00 ($15,678.12) Library Fund 112-000-000-572-50-47-00 Facilities - Utilities $247.02 $845.13 $6,500.00 13.00 %$5,654.87 Total Library Fund $247.02 $845.13 $6,500.00 13.00 %$5,654.87 Hotel/Motel Tax Fund 113-000-000-557-30-41-05 Wenatchee Valley Chamber $0.00 $15,000.00 $45,000.00 33.33 %$30,000.00 113-000-000-557-30-41-10 Contributions to Other Entities $0.00 $8,000.00 $50,000.00 16.00 %$42,000.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $5,062.00 $30,372.00 $61,000.00 49.79 %$30,628.00 113-001-000-597-00-00-01 Transfer-Out to Fund 117 $0.00 $60,000.00 $120,000.00 50.00 %$60,000.00 Total Hotel/Motel Tax Fund $5,062.00 $113,372.00 $276,000.00 41.08 %$162,628.00 Drug Fund 114-000-000-566-00-49-05 State Share-Forfeited Property $0.00 $221.30 $0.00 ($221.30) Account Number Title Period Fiscal Budget % of Total Balance Total Drug Fund $0.00 $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 $4,682.90 $30,865.92 $60,000.00 51.44 %$29,134.08 117-000-050-557-30-20-00 Benefits $2,202.00 $15,135.04 $29,000.00 52.19 %$13,864.96 117-000-100-557-30-25-00 Marketing - Regional Tourism $437.26 $437.26 $3,000.00 14.58 %$2,562.74 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 $439.48 $2,000.00 21.97 %$1,560.52 117-000-100-557-30-41-00 Professional Services $0.00 $119.40 $600.00 19.90 %$480.60 117-000-100-557-30-42-00 Cell Phone $94.46 $303.47 $760.00 39.93 %$456.53 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 $46.90 $11,655.00 0.40 %$11,608.10 117-000-110-557-30-31-14 Classy Chassis Central Stores $0.00 ($25.00)$0.00 $25.00 117-000-115-557-30-31-05 Office Supplies $103.98 $103.98 $1,000.00 10.40 %$896.02 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 $1,997.98 $1,997.98 $2,500.00 79.92 %$502.02 117-000-300-557-30-35-12 CC - Small Tools & Equipment $177.58 $1,581.70 $0.00 ($1,581.70) 117-000-300-557-30-41-12 CC - Professional Services $3,838.44 $4,835.72 $2,300.00 210.25 %($2,535.72) 117-000-300-557-30-42-14 CC - Postage $0.00 $743.27 $800.00 92.91 %$56.73 117-000-300-557-30-43-12 CC - EMPD Facility Fee $1,000.00 $1,000.00 $1,500.00 66.67 %$500.00 117-000-300-557-30-44-12 CC - Advertising $2,515.34 $4,064.03 $3,000.00 135.47 %($1,064.03) 117-000-300-557-30-49-12 CC - Miscellaneous $471.02 $1,371.02 $500.00 274.20 %($871.02) 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-30-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 $0.00 $134.29 $100.00 134.29 %($34.29) Total Events Board Fund $17,520.96 $63,302.46 $143,865.00 44.00 %$80,562.54 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 $120,000.00 $120,000.00 100.00 %$0.00 202-000-000-592-14-80-00 Interest - 2021 LTGO Bond $46,800.00 $46,800.00 $157,000.00 29.81 %$110,200.00 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $0.00 $10,000.00 $10,000.00 100.00 %$0.00 Account Number Title Period Fiscal Budget % of Total Balance Total Bond Redemption Fund $46,800.00 $176,800.00 $544,000.00 32.50 %$367,200.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 $18,707.37 $30,472.16 $101,775.00 29.94 %$71,302.84 301-000-000-595-10-40-04 Design - Grant Rd/Highline Dr Intersection Improvements $3,703.78 $3,703.78 $109,000.00 3.40 %$105,296.22 301-000-000-595-10-40-05 Design - Hamilton Ave Reconstruction $4,515.44 $117,962.72 $30,000.00 393.21 %($87,962.72) 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $4,739.85 $46,696.46 $65,000.00 71.84 %$18,303.54 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $8,285.16 $74,713.51 $75,000.00 99.62 %$286.49 301-000-000-595-10-60-00 Design - NHS Overlay Grover to Kentucky $8,766.97 $8,766.97 $129,000.00 6.80 %$120,233.03 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-40-42 SDC - 10th St. NE Improvements $0.00 $3,013.50 $0.00 ($3,013.50) 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-05 Construction - 10th St. NE Improvements $0.00 $13,769.78 $0.00 ($13,769.78) 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 $1,292.10 $25,047.62 $5,000.00 500.95 %($20,047.62) 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 $585.46 $1,140,390.00 0.05 %$1,139,804.54 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 $50,010.67 $324,731.96 $5,422,175.00 5.99 %$5,097,443.04 Capital Improvements Fund 314-000-000-594-21-60-01 Simon St. Improvements $85,035.31 $145,237.95 $1,000,000.00 14.52 %$854,762.05 314-000-000-594-22-60-50 Maintenance Facilities Design $40,610.84 $85,789.56 $0.00 ($85,789.56) 314-000-000-594-48-60-00 Maintenance Facilities Construction $10,422.39 $24,071.89 $6,000,000.00 0.40 %$5,975,928.11 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 $136,068.54 $255,099.40 $7,250,000.00 3.52 %$6,994,900.60 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 $6,834.17 $6,834.17 $30,000.00 22.78 %$23,165.83 401-000-001-531-00-20-00 Benefits - Stormwater Admin $1,810.02 $1,810.02 $13,200.00 13.71 %$11,389.98 401-000-001-531-00-30-00 Supplies - Stormwater Admin $0.00 $0.00 $500.00 0.00 %$500.00 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 $94.46 $303.47 $750.00 40.46 %$446.53 401-000-001-531-00-40-01 Fee Collection - Douglas Co.$0.00 $7,181.85 $8,500.00 84.49 %$1,318.15 401-000-001-531-00-40-02 Insurance $0.00 $40.20 $7,313.00 0.55 %$7,272.80 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-582-30-00-00 Non-Fiduciary Remittance $3,690.00 $3,690.00 $2,000.00 184.50 %($1,690.00) 401-000-001-597-00-00-00 Fleet Rentals - Stormwater $4,741.01 $28,446.06 $70,000.00 40.64 %$41,553.94 Total Stormwater Utility Admin $17,169.66 $48,305.77 $155,263.00 31.11 %$106,957.23 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $1,120.01 $1,120.01 $25,000.00 4.48 %$23,879.99 401-000-002-531-00-20-01 Benefits - NPDES Admin $548.40 $548.40 $11,000.00 4.99 %$10,451.60 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 $2,682.26 $8,000.00 33.53 %$5,317.74 Total NPDES Admin $1,668.41 $4,350.67 $49,500.00 8.79 %$45,149.33 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,757.52 $7,146.01 $73,000.00 9.79 %$65,853.99 401-000-008-531-00-10-08 Salaries - Sweeping $675.23 $6,922.12 $22,000.00 31.46 %$15,077.88 Account Number Title Period Fiscal Budget % of Total Balance 401-000-008-531-00-20-07 Benefits - NPDES PPGH $826.20 $3,660.00 $29,200.00 12.53 %$25,540.00 401-000-008-531-00-20-08 Benefits - Sweeping $469.35 $3,960.43 $11,000.00 36.00 %$7,039.57 401-000-008-531-00-30-05 Supplies - NPDES PPGH $0.00 $2,202.20 $20,000.00 11.01 %$17,797.80 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 $459.30 $2,570.00 $7,000.00 36.71 %$4,430.00 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $0.00 $2,224.62 $5,000.00 44.49 %$2,775.38 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 $83.80 $2,792.22 $5,000.00 55.84 %$2,207.78 401-000-008-531-00-40-07 Decant Facility Tipping Fee $1,585.62 $1,585.62 $75,000.00 2.11 %$73,414.38 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 $5,857.02 $33,063.22 $277,600.00 11.91 %$244,536.78 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 $7,350.00 $29,889.00 $75,000.00 39.85 %$45,111.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 $75,033.45 $76,000.00 98.73 %$966.55 401-000-014-531-00-40-07 Stormwater Comp Plan Update $10,661.74 $22,098.40 $45,000.00 49.11 %$22,901.60 401-000-016-594-31-60-00 Pace Pond $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Stormwater Fund $42,706.83 $212,740.51 $962,863.00 22.09 %$750,122.49 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $209.51 $2,411.71 $5,300.00 45.50 %$2,888.29 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $63.56 $1,714.85 $2,800.00 61.24 %$1,085.15 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $3,092.45 $38,285.79 $35,000.00 109.39 %($3,285.79) 501-000-000-548-30-10-00 Street Vehicle Repair Labor $1,206.28 $8,899.55 $24,000.00 37.08 %$15,100.45 501-000-000-548-30-20-00 Street Vehicle Repair Benefits $871.56 $6,205.53 $12,000.00 51.71 %$5,794.47 501-000-000-548-30-30-25 Street Vehicle Repair Supplies $141.35 $2,990.58 $5,000.00 59.81 %$2,009.42 501-000-000-548-30-48-20 Street Vehicle Repairs & Maintenance $2,049.36 $10,273.64 $23,000.00 44.67 %$12,726.36 501-000-000-548-30-48-30 Street Equipment Repairs $395.34 $812.01 $1,500.00 54.13 %$687.99 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 $95,508.92 $260,719.42 $280,000.00 93.11 %$19,280.58 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $243,917.18 $160,000.00 152.45 %($83,917.18) 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 $103,538.33 $576,230.26 $603,100.00 95.54 %$26,869.74 Account Number Title Period Fiscal Budget % of Total Balance Grand Totals $2,337,267.82 $7,668,087.51 $29,014,178.00 26.43 %$21,346,090.49 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $1,824,344.28 $5,202,444.88 $10,886,289.00 47.79 %$5,683,844.12 101-000-000-000-00-00-00 Street Fund $108,091.07 $726,621.49 $1,508,500.00 48.17 %$781,878.51 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 107-000-000-000-00-00-00 SWAT Fund $2,878.12 $15,678.12 $0.00 ($15,678.12) 112-000-000-000-00-00-00 Library Fund $247.02 $845.13 $6,500.00 13.00 %$5,654.87 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $5,062.00 $113,372.00 $276,000.00 41.08 %$162,628.00 114-000-000-000-00-00-00 Drug Fund $0.00 $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 $17,520.96 $63,302.46 $143,865.00 44.00 %$80,562.54 202-000-000-000-00-00-00 Bond Redemption Fund $46,800.00 $176,800.00 $544,000.00 32.50 %$367,200.00 301-000-000-000-00-00-00 Street Improvements Fund $50,010.67 $324,731.96 $5,422,175.00 5.99 %$5,097,443.04 314-000-000-000-00-00-00 Capital Improvements Fund $136,068.54 $255,099.40 $7,250,000.00 3.52 %$6,994,900.60 401-000-000-000-00-00-00 Stormwater Fund $42,706.83 $212,740.51 $962,863.00 22.09 %$750,122.49 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $103,538.33 $576,230.26 $603,100.00 95.54 %$26,869.74 Grand Totals $2,337,267.82 $7,668,087.51 $29,014,178.00 26.43 %$21,346,090.49 Beginning Activity Activity Ending June 2021 Variance Cash In Out Cash Ending Cash (Decrease)/Increase 001 $4,921,660.00 $5,327,415.04 $5,203,979.64 $5,045,095.40 $4,398,159.79 $646,935.61 002 $0.00 $750,000.00 $0.00 $750,000.00 $0.00 $750,000.00 101 $265,014.00 $1,167,845.16 $727,021.97 $705,837.19 $741,951.10 ($36,113.91) 102 $118,683.19 $105,881.74 $0.00 $224,564.93 $33,999.51 $190,565.42 103 $55,491.61 $11,015.91 $0.00 $66,507.52 $33,210.61 $33,296.91 104 $10,000.00 $272,081.35 $0.00 $282,081.35 $0.00 $282,081.35 105 $506,934.74 $124,162.72 $0.00 $631,097.46 $562,713.81 $68,383.65 107 $0.00 $58,500.00 $15,678.12 $42,821.88 $0.00 $42,821.88 112 $19,428.94 $3,769.62 $845.13 $22,353.43 $16,867.95 $5,485.48 113 $318,181.61 $165,324.64 $113,372.00 $370,134.25 $205,532.00 $164,602.25 114 $1,836.11 $9.17 $221.30 $1,623.98 $1,548.32 $75.66 116 $3,588.52 $10,755.37 $0.00 $14,343.89 $12,860.26 $1,483.63 117 $21,739.98 $73,766.95 $63,327.46 $32,179.47 $29,185.52 $2,993.95 202 $566,371.06 $571.72 $176,800.00 $390,142.78 $604,961.38 ($214,818.60) 301 $177,978.45 $803,150.36 $383,686.97 $597,441.84 $298,197.42 $299,244.42 314 $1,405,618.85 $257,703.66 $255,099.40 $1,408,223.11 $1,516,931.71 ($108,708.60) 401 $1,336,564.47 $608,188.83 $212,740.51 $1,732,012.79 $2,378,463.61 ($646,450.82) 501 $316,444.51 $610,041.57 $576,230.26 $350,255.82 $345,614.85 $4,640.97 $10,045,536.04 $10,350,183.81 $7,729,002.76 $12,666,717.09 $11,180,197.84 $1,486,519.25 Cash and Investment Activity Rainy Day Fund General Fund Period: 2022 - June 2022 Fiscal Totals Fund Transportation Benefit District Fund SWAT Fund Affordable Housing Sales Tax Fund Housing & Related Services Fund Street Fund Community Development Grants Fund Criminal Justice Fund Events Board Fund Hotel/Motel Tax Fund Drug Fund Library Fund Stormwater Fund Equipment Purchase, Repair & Replacement Fund Capital Improvements Fund Bond Redemption Fund Street Improvements Fund