Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2021 - July 2021 Financial Report - Josh DeLay, Finance Director
City of East Wenatchee September 7, 2021, City Council Meeting July 2021 Financial Report Date: September 7, 2021 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: July 2021 Financial Report This report provides a summary of the City’s overall financial operations through July 31, 2021. It offers a comparison of total overall revenues and expenditures between the current fiscal year and the same point in time as the last fiscal year. For the purposes of this report, operating funds are funds that receive general local tax support and/or expend wages and other steady expenses to support the day-to-day operations of the City. Non-operating funds are funds that are supported through special revenues and/or include non-wage and varying expenses (i.e., capital, grant projects, etc.). Table 1 below shows the City’s revenue collections through July 31, 2021, compared to revenue collections through July 31, 2020, along with the respective dollar and percentage variances for its operating funds. Table 1 July 31, 2021 July 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 5,562,899 3,520,282 2,042,617 58.02% Street Fund - 101 1,142,397 746,032 396,365 53.13% Events Board Fund - 117 62,612 38,266 24,346 63.62% Equipment R&R Fund - 501 608,687 372,073 236,615 63.59% Total Revenues - Operating Funds 7,376,594 4,676,652 2,699,943 57.73% Revenues - Operating Funds CITY OF EAST WENATCHEE Finance Department 271 9th Street NE * East Wenatchee, WA 98802 P: (509) 886-6101 * F: (509) 884-6233 Email: jdelay@eastwenatcheewa.gov 1 of 28 City of East Wenatchee September 7, 2021, City Council Meeting July 2021 Financial Report Chart 1 is a graphical representation of year over year revenue comparisons for the City’s operating funds. Chart 1 Table 2 below shows the City’s revenue collections through July 31, 2021, compared to revenue collections through July 31, 2020, along with the respective dollar and percentage variances for its non-operating funds. 2 of 28 City of East Wenatchee September 7, 2021, City Council Meeting July 2021 Financial Report Table 2 July 31, 2021 July 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 35,008 12,893 22,115 171.53% Affordable Housing Tax Fund - 103 23,368 - 23,368 - Trans Benefit District Fund - 105 153,251 146,777 6,474 4.41% Library Fund - 112 3,753 3,500 253 7.23% Hotel/Motel Tax Fund - 113 160,221 131,025 29,196 22.28% Drug Fund - 114 11 11 (0) (0.28%) Criminal Justice Fund - 116 15,298 14,604 694 4.75% Bond Redemption Fund - 202 151 100,000 (99,849) (99.85%) Street Improvements Fund - 301 1,971,278 460,194 1,511,084 328.36% Capital Improvements Fund - 314 4,289,514 296,807 3,992,707 1345.22% Storm Water Fund - 401 548,849 3,187,979 (2,639,130) (82.78%) Total Revenues - Non-Operating Funds 7,200,703 4,353,790 2,846,912 65.39% Revenues - Non-Operating Funds Chart 2 is a graphical representation of year over year revenue comparisons for the City’s non- operating funds. Chart 2 3 of 28 City of East Wenatchee September 7, 2021, City Council Meeting July 2021 Financial Report Revenue Highlights: General Fund revenues are up $2,042,617, or 58.02%, year over year due to: $1,528,693 received from the federal government as part of the American Rescue Plan Act for economic recovery due to the COVID-19 lockdowns; and a $342,338 increase in retail sales and use tax due to a 24.2% overall increase in collections year over year; and a $215,133 increase in gambling tax due to less restrictive COVID lockdown orders in 2021 versus 2020 The above increases are offset by the following decreases year over year: $34,487 decrease in interest earnings due to historically low interest rates. This variance should decrease throughout the year as the new investment interest earnings accrue; and a, $37,062 decrease in phone/cellular utility tax – Finance has identified and contacted the companies that stopped paying this tax and will continue to follow-up as needed Street Fund revenues are up $396,365, or 53.13%, year over year due to a $170,000 increase in sales tax allocated to the fund and a $208,099 increase in property tax allocated to the fund. Both budgeted increases are out of necessity to keep the fund with a healthy year-end fund balance. Events Fund revenues are up $24,346, or 63.62%, year over year due to a larger transfer-in from the Hotel/Motel Tax Fund. The City was limited in the volume of funds it could transfer last year because events were cancelled, and the Events Director was not working on tourism related activities. Equipment R&R Fund revenues are up $236,615, or 63.59%, year over year due to the increased revenue needs of this fund per the new revolving fund format as recommended by the State Auditor’s Office. Community Development Grants Fund revenues are up $22,115, or 171.53%, year over year due to the timing of reimbursements. Affordable Housing Tax Fund revenues are up $23,368 year over year because the City did not start receiving this tax until August of 2020. Street Improvements Fund revenues are up $1,511,084, or 328.36%, year over year due to the normal timing differences of projects associated with this fund. Capital Improvements Fund revenues are up $3,992,707, or 1,345.22%, year over year due to the bond proceeds the City received to purchase the 50 Simon St. building. Storm Water Fund revenues are down $2,639,130, or 82.78%, year over year because last year the City received a large influx of its share of revenue from Douglas County due to a terminated interlocal agreement with them for storm water services. 4 of 28 City of East Wenatchee September 7, 2021, City Council Meeting July 2021 Financial Report Table 3 below shows the City’s expenditures through July 31, 2021, compared to expenditures through July 31, 2020, along with respective dollar and percentage variances for its operating funds. Table 3 July 31, 2021 July 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 4,841,060 4,123,634 717,427 17.40% Street Fund - 101 708,106 540,229 167,877 31.08% Events Board Fund - 117 58,948 47,881 11,067 23.11% Equipment R&R Fund - 501 278,722 304,202 (25,480) (8.38%) Total Expenditures - Operating Funds 5,886,836 5,015,946 870,890 17.36% 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 July 31, 2021, compared to expenditures through July 31, 2020, along with respective dollar and percentage variances for its non-operating funds. 5 of 28 City of East Wenatchee September 7, 2021, City Council Meeting July 2021 Financial Report Table 4 July 31, 2021 July 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 41,995 14,714 27,281 185.40% Trans Benefit District Fund - 105 190,000 1,500 188,500 12566.67% Library Fund - 112 1,841 3,021 (1,180) (39.05%) Hotel/Motel Tax Fund - 113 115,434 118,814 (3,380) (2.84%) Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 170,975 47,842 123,132 257.37% Street Improvements Fund - 301 2,084,013 1,398,661 685,352 49.00% Capital Improvements Fund - 314 4,341,037 19,962 4,321,075 21646.38% Storm Water Fund - 401 1,098,665 730,242 368,423 50.45% Total Expenditures - Non-Operating Funds 8,043,960 2,334,756 5,709,204 244.53% Expenditures - Non-Operating Funds Chart 4 is a graphical representation of year over year expenditure comparisons for the City’s non- operating funds. Chart 4 6 of 28 City of East Wenatchee September 7, 2021, City Council Meeting July 2021 Financial Report Expenditure Highlights: General Fund expenditures are up $717,427, or 17.4%, year over year due to: General overall salary and benefit increases; and a $103,148 increase in fleet rental costs for the Police Department related to the new format of the City’s equipment rental fund. The above increases are offset by the following decreases: $25,296 decrease in capital outlay costs for the Police Department due to the timing of purchases related to that line item. Street Fund expenditures are up $167,877, or 31.08%, year over year due to salary and benefit increases, and a $98,345 increase in fleet rental costs related to the new format of the City’s equipment rental fund. Equipment R&R Fund expenditures are down $25,480, or 8.38%, year over year due to the timing of the purchase of replacement vehicles and equipment. Community Development Grants Fund expenditures are up $27,281, or 185.4%, due to payments related to the micro enterprise grant, and food assistance programs. Hotel/Motel Tax Fund expenditures are down $3,380, or 2.84%, year over year due to less contributions to the Wenatchee Valley Museum. Half of that contracted cost is now coming out of the General Fund. Bond Redemption Fund expenditures are up $123,132, or 257.37%, year over year due to the increased debt payment for the 10th St. Public Works Trust Fund loan. Street Improvements Fund expenditures are up $685,352, or 49.00%, year over year due typical timing variances associated with the capital projects in this fund. The expenditures in this fund are expected to increase substantially throughout the rest of 2021. Capital Improvements Fund expenditures are up $4,321,075, or 21,606.38%, year over year due to the purchase of the 50 Simon St. building. Storm Water Fund expenditures are up $368,423, or 50.45%, year over year primarily due to the timing payment difference to Douglas County for outstanding debt when we were a joint utility. 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 July 31, 2021. 7 of 28 Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $7,445.15 $578,641.11 $1,318,200.00 43.90 %$739,558.89 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $421,344.31 $1,864,528.55 $3,306,000.00 56.40 %$1,441,471.45 001-000-000-313-71-00-00 Criminal Justice Sales Tax $39,238.67 $247,737.99 $296,000.00 83.70 %$48,262.01 001-000-000-316-40-00-00 Electric Utility Tax $23,565.06 $223,961.05 $354,000.00 63.27 %$130,038.95 001-000-000-316-45-00-00 Natural Gas Utility Tax $4,632.51 $29,168.39 $35,000.00 83.34 %$5,831.61 001-000-000-316-47-00-00 Recycling $0.00 $60.00 $0.00 ($60.00) 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $11,558.45 $96,955.19 $360,000.00 26.93 %$263,044.81 001-000-000-316-84-00-00 Gambling Tax $143,511.57 $364,244.54 $317,000.00 114.90 %($47,244.54) Total Taxes $651,295.72 $3,405,296.82 $5,986,200.00 56.89 %$2,580,903.18 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $0.00 $350.00 $500.00 70.00 %$150.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $62.00 $561.00 $800.00 70.13 %$239.00 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $48,540.11 $91,000.00 53.34 %$42,459.89 001-000-000-321-99-00-00 Business Licenses & Permits $11,528.75 $73,629.24 $100,000.00 73.63 %$26,370.76 001-000-000-321-99-05-00 Other Business Lic & Permits $0.00 $57.00 $660.00 8.64 %$603.00 001-000-000-322-10-00-00 Building & Structure Permits $3,160.45 $23,243.36 $60,000.00 38.74 %$36,756.64 001-000-000-322-90-01-00 Gun Permits $565.00 $4,277.25 $5,700.00 75.04 %$1,422.75 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $125.00 0.00 %$125.00 Total Licenses and Permits $15,316.20 $150,657.96 $258,785.00 58.22 %$108,127.04 Intergovernmental Revenues 001-000-000-331-21-00-00 American Rescue Plan Funds $0.00 $1,528,692.50 $0.00 ($1,528,692.50) 001-000-000-332-92-10-00 IRS Refund $14,425.93 $14,425.93 $0.00 ($14,425.93) 001-000-000-334-01-20-01 Washington Courts Funding $0.00 $20,000.00 $0.00 ($20,000.00) 001-000-000-334-03-10-00 Dept. of Ecology SMP Grant $0.00 $2,583.63 $0.00 ($2,583.63) 001-000-000-334-03-51-03 TSC - Seatbelt Emphasis Patrols $0.00 $0.00 $900.00 0.00 %$900.00 001-000-000-334-03-51-04 X-52 TSC-Speed Limit Emphasis $0.00 $0.00 $1,900.00 0.00 %$1,900.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $1,077.40 $2,027.96 $2,500.00 81.12 %$472.04 001-000-000-334-03-51-12 TSC - DUI Emphasis Patrol $0.00 $428.82 $2,500.00 17.15 %$2,071.18 001-000-000-334-04-20-05 Dept. of Commerce Grant $5,390.00 $15,920.00 $0.00 ($15,920.00) 001-000-000-334-06-91-00 WA ST Office of Public Defense $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-000-335-00-91-00 PUD Privilege Tax $0.00 $0.00 $43,000.00 0.00 %$43,000.00 001-000-000-335-04-01-00 LE & CJ One Time Allocation $54,540.00 $54,540.00 $0.00 ($54,540.00) 001-000-000-336-00-98-03 City Assistance $0.00 $16,084.28 $0.00 ($16,084.28) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $16,802.87 $23,000.00 73.06 %$6,197.13 001-000-000-336-06-51-00 DUI - Cities Allocation $584.95 $1,663.75 $2,000.00 83.19 %$336.25 Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 999-000-000-384-00-00-00 Proceeds From Sales of Investments Period: 2021 - July 2021 8 of 28 Account Number Title Period Fiscal Budget % of Total Balance 001-000-000-336-06-94-00 Liquor Excise Tax $22,810.41 $70,105.44 $77,000.00 91.05 %$6,894.56 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $54,293.49 $108,000.00 50.27 %$53,706.51 Total Intergovernmental Revenues $98,828.69 $1,797,568.67 $280,800.00 640.16 %($1,516,768.67) 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 $2.85 $100.00 2.85 %$97.15 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 $73.65 $60.00 122.75 %($13.65) 001-000-000-341-35-35-00 Waste Management Annual Fee $0.00 $5,000.00 $5,000.00 100.00 %$0.00 001-000-000-342-10-00-00 Vaccine Patrol Reimbursement $0.00 $8,181.95 $0.00 ($8,181.95) 001-000-000-342-33-00-00 Adult Probation Services $5,255.01 $32,678.94 $63,000.00 51.87 %$30,321.06 001-000-000-342-36-00-00 Housing of Prisoners $625.84 $4,895.99 $20,000.00 24.48 %$15,104.01 001-000-000-342-40-00-01 Fire Marshall Inspection Services $0.00 $805.00 $5,000.00 16.10 %$4,195.00 001-000-000-345-83-00-00 Plan Checking Fees $1,948.34 $8,134.24 $30,000.00 27.11 %$21,865.76 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $802.00 $750.00 106.93 %($52.00) 001-000-000-345-86-00-00 Sepa Permits $0.00 $736.00 $1,000.00 73.60 %$264.00 001-000-000-345-89-00-00 Planning & Development Fees $248.00 $2,889.00 $8,000.00 36.11 %$5,111.00 Total Charges for Goods and Services $8,077.19 $64,199.62 $133,070.00 48.24 %$68,870.38 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $15,799.45 $99,377.28 $175,000.00 56.79 %$75,622.72 001-000-000-357-33-00-00 Public Defender Costs $1,563.02 $8,823.52 $23,000.00 38.36 %$14,176.48 001-000-000-357-35-00-00 Restitution $0.00 $0.00 $400.00 0.00 %$400.00 Total Fines and Penalties $17,362.47 $108,200.80 $198,400.00 54.54 %$90,199.20 Miscellaneous Revenues 001-000-000-361-10-00-00 Interest Earnings $226.87 $4,476.28 $90,000.00 4.97 %$85,523.72 001-000-000-361-40-00-00 Sales Tax Interest $214.54 $1,792.00 $5,700.00 31.44 %$3,908.00 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,246.26 $8,002.05 $12,000.00 66.68 %$3,997.95 001-000-000-369-80-00-00 Cash Adjustments $0.00 $1.00 $0.00 ($1.00) 001-000-000-369-90-00-00 Other Misc Revenue $0.00 $2.00 $0.00 ($2.00) 001-000-000-369-91-50-00 Miscellaneous Revenue $370.60 $4,959.60 $7,000.00 70.85 %$2,040.40 Total Miscellaneous Revenues $2,058.27 $19,232.93 $114,700.00 16.77 %$95,467.07 Other Increases in Fund Resources 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 $50.00 $200.00 25.00 %$150.00 001-000-000-389-00-00-01 Crime Victim Assessment $0.00 $0.00 $3,200.00 0.00 %$3,200.00 001-000-000-389-00-00-02 State Surcharge $0.00 $0.00 $700.00 0.00 %$700.00 001-000-000-389-00-00-03 State Share Weapons Permit Fee $0.00 $0.00 $8,700.00 0.00 %$8,700.00 001-000-000-389-00-00-04 Court Remittance - State $0.00 $0.00 $175,000.00 0.00 %$175,000.00 Total Other Increases in Fund Resources $0.00 $2,050.00 $190,150.00 1.08 %$188,100.00 Other Financing Sources 001-000-000-395-10-00-00 Proceeds - Disposition of Assets $69.46 $69.46 $9,800.00 0.71 %$9,730.54 001-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-397-95-00-25 Transfer In - Street Imp Fund $0.00 $0.00 $500,000.00 0.00 %$500,000.00 001-000-000-398-10-00-00 Insurance Recoveries $167.22 $15,622.67 $0.00 ($15,622.67) 9 of 28 Account Number Title Period Fiscal Budget % of Total Balance Total Other Financing Sources $236.68 $15,692.13 $509,900.00 3.08 %$494,207.87 Total General Fund $793,175.22 $5,562,898.93 $7,672,005.00 72.51 %$2,109,106.07 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 $470,000.00 $470,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $2,035.00 $16,790.00 $2,000.00 839.50 %($14,790.00) 101-000-000-336-00-71-00 Multi-Modal Distribution $0.00 $9,220.40 $18,000.00 51.22 %$8,779.60 101-000-000-336-00-87-00 Gas Tax $22,080.64 $133,571.59 $275,000.00 48.57 %$141,428.41 101-000-000-336-00-87-05 Increased Gas Tax $0.00 $8,067.93 $16,000.00 50.42 %$7,932.07 101-000-000-341-96-00-00 SkillSource CDL Reimbursement $0.00 $4,000.00 $0.00 ($4,000.00) 101-000-000-361-10-00-00 Interest Earnings $13.40 $48.38 $0.00 ($48.38) 101-000-000-361-40-00-00 Sales Tax Interest $0.00 $251.57 $0.00 ($251.57) 101-000-000-369-91-01-05 Miscellaneous Revenue $0.00 $446.64 $0.00 ($446.64) Total Street Fund $24,129.04 $1,142,396.51 $1,281,000.00 89.18 %$138,603.49 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $35,000.00 $74,764.00 46.81 %$39,764.00 102-000-000-361-10-00-00 Interest Earnings $2.18 $7.86 $0.00 ($7.86) Total Community Development Grants Fund $2.18 $35,007.86 $74,764.00 46.82 %$39,756.14 Affordable Housing Sales Tax Fund 103-000-000-313-27-00-00 Affordable & Supportive Housing Sales/Use Tax $3,651.26 $23,365.06 $0.00 ($23,365.06) 103-000-000-361-10-00-00 Interest Earnings $0.73 $2.63 $0.00 ($2.63) Total Affordable Housing Sales Tax Fund $3,651.99 $23,367.69 $0.00 ($23,367.69) Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $24,410.40 $153,166.50 $0.00 ($153,166.50) 105-000-000-361-10-00-00 Interest Earnings $23.43 $84.58 $0.00 ($84.58) Total Transportation Benefit District Fund $24,433.83 $153,251.08 $0.00 ($153,251.08) Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $3,750.00 $7,500.00 50.00 %$3,750.00 112-000-000-361-10-00-00 Interest Earnings $0.80 $2.88 $0.00 ($2.88) Total Library Fund $0.80 $3,752.88 $7,500.00 50.04 %$3,747.12 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $32,104.53 $160,189.73 $225,000.00 71.20 %$64,810.27 113-000-000-361-10-00-00 Interest Earnings $8.79 $31.72 $0.00 ($31.72) Total Hotel/Motel Tax Fund $32,113.32 $160,221.45 $225,000.00 71.21 %$64,778.55 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $0.00 $10.47 $100.00 10.47 %$89.53 114-000-000-361-10-00-00 Interest Earnings $0.08 $0.30 $0.00 ($0.30) Total Drug Fund $0.08 $10.77 $100.00 10.77 %$89.23 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $1,166.47 $3,352.44 $4,500.00 74.50 %$1,147.56 116-000-000-336-06-26-00 Criminal Justice - Special Programs $4,142.16 $11,945.44 $16,000.00 74.66 %$4,054.56 116-000-000-361-10-00-00 Interest Earnings $0.16 $0.56 $0.00 ($0.56) 10 of 28 Account Number Title Period Fiscal Budget % of Total Balance Total Criminal Justice Fund $5,308.79 $15,298.44 $20,500.00 74.63 %$5,201.56 Events Board Fund 117-000-100-361-10-00-00 Interest Earnings $1.01 $3.65 $0.00 ($3.65) 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 $108.00 $9,000.00 1.20 %$8,892.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 $2,500.00 $8,000.00 31.25 %$5,500.00 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-347-40-11-03 Wings & Wheels Car Show Registration $0.00 $0.00 $4,500.00 0.00 %$4,500.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $0.00 $0.00 $100.00 0.00 %$100.00 117-000-400-347-90-00-11 Wings & Wheels Sponsorships $0.00 $0.00 $12,000.00 0.00 %$12,000.00 117-000-400-347-90-11-00 Wings & Wheels Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-500-367-19-00-01 Christmas Sponsorships $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Events Board Fund $1.01 $62,611.65 $156,750.00 39.94 %$94,138.35 Bond Redemption Fund 202-000-000-361-10-00-00 Interest Earnings $41.90 $151.23 $0.00 ($151.23) Total Bond Redemption Fund $41.90 $151.23 $0.00 ($151.23) Street Improvements Fund 301-000-000-330-00-00-00 GWID - 10th St. NE Improvements $0.00 $0.00 $298,534.00 0.00 %$298,534.00 301-000-000-333-20-00-13 STP 9th/VMP Intersection $0.00 $39,028.26 $825,000.00 4.73 %$785,971.74 301-000-000-333-20-00-21 STBG - 10th St. NE Improvements $0.00 $0.00 $1,683,159.00 0.00 %$1,683,159.00 301-000-000-333-20-00-22 SRTS - 5th St NE: Sterling $0.00 $34,267.46 $207,500.00 16.51 %$173,232.54 301-000-000-333-20-00-23 SRTS - 5th St NE: Kenroy $0.00 $36,003.33 $233,250.00 15.44 %$197,246.67 301-000-000-334-03-80-13 TIB N Kentucky Ave Overlay $0.00 $0.00 $675,750.00 0.00 %$675,750.00 301-000-000-334-03-80-15 TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $81,800.00 0.00 %$81,800.00 301-000-000-334-03-80-17 TIB - 10th St. NE Improvements $0.00 $0.00 $1,126,608.00 0.00 %$1,126,608.00 301-000-000-334-03-80-19 TIB - Grant/Highline Intersection Improvements $0.00 $0.00 $48,875.00 0.00 %$48,875.00 301-000-000-361-10-00-00 Interest Earnings $14.17 $51.15 $0.00 ($51.15) 301-000-000-369-90-00-00 Miscellaneous Revenue $0.00 $96.00 $0.00 ($96.00) 301-000-000-391-80-00-00 PWTFL - 10th Street Design $0.00 $193,831.72 $50,000.00 387.66 %($143,831.72) 301-000-000-397-00-00-00 Transfer-In - Fund 401 $728,000.00 $728,000.00 $728,000.00 100.00 %$0.00 301-000-000-397-00-00-01 Transfer-In - Fund 102 $0.00 $0.00 $70,000.00 0.00 %$70,000.00 301-000-000-397-41-10-05 Transfer-In from Fund 105 $190,000.00 $190,000.00 $190,000.00 100.00 %$0.00 301-000-000-397-95-00-20 Transfer-In from Fund 314 $250,000.00 $250,000.00 $250,000.00 100.00 %$0.00 301-000-000-397-95-00-25 Transfer In From General Fund $500,000.00 $500,000.00 $500,000.00 100.00 %$0.00 Total Street Improvements Fund $1,668,014.17 $1,971,277.92 $6,968,476.00 28.29 %$4,997,198.08 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $74,386.42 $326,846.66 $400,000.00 81.71 %$73,153.34 314-000-000-361-10-00-00 Interest Earnings $73.57 $267.73 $0.00 ($267.73) 314-000-000-391-10-00-00 LTGO Bond Proceeds $0.00 $3,962,400.00 $5,000,000.00 79.25 %$1,037,600.00 Total Capital Improvements Fund $74,459.99 $4,289,514.39 $5,400,000.00 79.44 %$1,110,485.61 Stormwater Fund 401-000-000-334-03-10-01 19th St. Ecology Grant $0.00 $11,062.09 $50,000.00 22.12 %$38,937.91 11 of 28 Account Number Title Period Fiscal Budget % of Total Balance 401-000-000-334-03-10-02 Stormwater Comp Plan Ecology Grant $0.00 $18,323.66 $31,875.00 57.49 %$13,551.34 401-000-000-343-10-00-00 SWU Fee $3,255.12 $516,678.12 $520,000.00 99.36 %$3,321.88 401-000-000-361-10-00-00 Interest Earnings $117.01 $584.25 $0.00 ($584.25) 401-000-000-382-30-00-00 Non-Fiduciary Collections $0.00 $2,201.06 $0.00 ($2,201.06) Total Stormwater Fund $3,372.13 $548,849.18 $601,875.00 91.19 %$53,025.82 Equipment Purchase, Repair & Replacement Fund 501-000-000-313-11-00-10 Sales & Use Tax - Police $0.00 $151,000.00 $151,000.00 100.00 %$0.00 501-000-000-313-11-00-20 Sales & Use Tax - Streets $0.00 $223,000.00 $223,000.00 100.00 %$0.00 501-000-000-348-00-00-01 Police - Fleet Maintenance Rentals $14,735.42 $103,147.94 $177,000.00 58.28 %$73,852.06 501-000-000-348-00-00-02 Street - Fleet Maintenance Rentals $14,049.23 $98,344.61 $169,000.00 58.19 %$70,655.39 501-000-000-348-00-00-03 Stormwater - Fleet Maintenance Rentals $4,741.01 $33,187.07 $57,000.00 58.22 %$23,812.93 501-000-000-361-10-00-00 Interest Earnings $2.11 $7.62 $0.00 ($7.62) 501-000-000-397-00-00-02 Transfer-In - Criminal Justice Fund $0.00 $0.00 $25,000.00 0.00 %$25,000.00 Total Equipment Purchase, Repair & Replacement Fund $33,527.77 $608,687.24 $802,000.00 75.90 %$193,312.76 Cafeteria Plan 634-000-000-361-10-00-00 Interest Earnings $0.08 $0.29 $0.00 ($0.29) Total Cafeteria Plan $0.08 $0.29 $0.00 ($0.29) Custodial Activities Fund 635-000-000-361-10-00-00 Interest Earnings $0.51 $1.85 $0.00 ($1.85) 635-000-000-386-00-00-01 State Share Court Revenue $18,212.00 $100,768.78 $0.00 ($100,768.78) 635-000-000-389-30-00-01 Crime Victim Assessment $297.58 $1,773.51 $0.00 ($1,773.51) 635-000-000-389-30-00-02 State Surcharge - Building Code $32.50 $549.00 $0.00 ($549.00) 635-000-000-389-30-00-15 State Share Gun Permits $983.25 $6,858.75 $0.00 ($6,858.75) Total Custodial Activities Fund $19,525.84 $109,951.89 $0.00 ($109,951.89) Grand Totals $2,681,758.14 $14,687,249.40 $23,209,970.00 63.28 %$8,522,720.60 12 of 28 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $793,175.22 $5,562,898.93 $7,672,005.00 72.51 %$2,109,106.07 101-000-000-000-00-00-00 Street Fund $24,129.04 $1,142,396.51 $1,281,000.00 89.18 %$138,603.49 102-000-000-000-00-00-00 Community Development Grants Fund $2.18 $35,007.86 $74,764.00 46.82 %$39,756.14 103-000-000-000-00-00-00 Affordable Housing Sales Tax Fund $3,651.99 $23,367.69 $0.00 ($23,367.69) 105-000-000-000-00-00-00 Transportation Benefit District Fund $24,433.83 $153,251.08 $0.00 ($153,251.08) 112-000-000-000-00-00-00 Library Fund $0.80 $3,752.88 $7,500.00 50.04 %$3,747.12 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $32,113.32 $160,221.45 $225,000.00 71.21 %$64,778.55 114-000-000-000-00-00-00 Drug Fund $0.08 $10.77 $100.00 10.77 %$89.23 116-000-000-000-00-00-00 Criminal Justice Fund $5,308.79 $15,298.44 $20,500.00 74.63 %$5,201.56 117-000-000-000-00-00-00 Events Board Fund $1.01 $62,611.65 $156,750.00 39.94 %$94,138.35 202-000-000-000-00-00-00 Bond Redemption Fund $41.90 $151.23 $0.00 ($151.23) 301-000-000-000-00-00-00 Street Improvements Fund $1,668,014.17 $1,971,277.92 $6,968,476.00 28.29 %$4,997,198.08 314-000-000-000-00-00-00 Capital Improvements Fund $74,459.99 $4,289,514.39 $5,400,000.00 79.44 %$1,110,485.61 401-000-000-000-00-00-00 Stormwater Fund $3,372.13 $548,849.18 $601,875.00 91.19 %$53,025.82 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $33,527.77 $608,687.24 $802,000.00 75.90 %$193,312.76 634-000-000-000-00-00-00 Cafeteria Plan $0.08 $0.29 $0.00 ($0.29) 635-000-000-000-00-00-00 Custodial Activities Fund $19,525.84 $109,951.89 $0.00 ($109,951.89) Grand Totals $2,681,758.14 $14,687,249.40 $23,209,970.00 63.28 %$8,522,720.60 13 of 28 Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 001-000-001-518-90-40-00 GWATA Membership $0.00 $0.00 $300.00 0.00 %$300.00 001-000-001-518-91-30-00 Wellness $241.32 $926.85 $1,000.00 92.69 %$73.15 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 $15,592.50 $26,500.00 58.84 %$10,907.50 001-000-001-528-70-40-00 River Com $21,770.90 $152,396.30 $261,251.00 58.33 %$108,854.70 001-000-001-531-00-40-00 Annual SWU Charge $0.00 $1,665.00 $0.00 ($1,665.00) 001-000-001-539-30-40-00 Animal Control $6,248.76 $49,867.56 $73,515.00 67.83 %$23,647.44 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $15,918.00 $14,500.00 109.78 %($1,418.00) 001-000-001-558-70-40-00 Contributions - Region $0.00 $20,000.00 $25,000.00 80.00 %$5,000.00 001-000-001-558-70-41-00 NCW Economic Development District $0.00 $500.00 $1,250.00 40.00 %$750.00 001-000-001-558-70-41-05 NCWEDD Chelan/Douglas Trends $0.00 $1,500.00 $1,500.00 100.00 %$0.00 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $0.00 $900.00 $500.00 180.00 %($400.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 $35,434.00 $61,000.00 58.09 %$25,566.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $2,015.76 $3,600.00 55.99 %$1,584.24 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 $35,550.48 $299,715.97 $973,666.00 30.78 %$673,950.03 Legislative 001-000-110-511-60-10-00 Salaries $4,643.38 $44,159.72 $55,440.00 79.65 %$11,280.28 001-000-110-511-60-20-00 Benefits $353.43 $7,124.19 $4,500.00 158.32 %($2,624.19) 001-000-110-511-60-21-50 Public Defender $11,350.00 $79,950.00 $135,000.00 59.22 %$55,050.00 001-000-110-511-60-30-00 Public Defender Conflicts $0.00 $180.00 $5,200.00 3.46 %$5,020.00 001-000-110-511-60-31-00 Office Supplies $80.79 $164.99 $650.00 25.38 %$485.01 001-000-110-511-60-31-10 Public Records Expenses $4.81 $1.81 $0.00 ($1.81) 001-000-110-511-60-40-00 Training $0.00 $110.00 $1,500.00 7.33 %$1,390.00 001-000-110-511-60-41-00 Professional Services $0.00 $12,679.00 $10,000.00 126.79 %($2,679.00) 001-000-110-511-60-41-20 AWC Annual Membership Fee $0.00 $10,089.00 $9,989.00 101.00 %($100.00) 001-000-110-511-60-42-01 Cell Phone $41.99 $209.93 $0.00 ($209.93) 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 $12,426.90 $25,000.00 49.71 %$12,573.10 001-000-110-511-60-46-00 Insurance $0.00 $32.57 $8,500.00 0.38 %$8,467.43 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 $80.88 $222.14 $5,000.00 4.44 %$4,777.86 Expenditure Starting Account Number: 001-000-001-518-20-40-00 Property Management - 311 9th St NE Ending Account Number: 999-000-000-584-00-00-00 Purchase of Investments Period: 2021 - July 2021 14 of 28 Account Number Title Period Fiscal Budget % of Total Balance Total Legislative $16,555.28 $167,416.25 $268,229.00 62.42 %$100,812.75 Mayor's Office 001-000-111-513-00-10-00 Salaries $8,095.58 $44,568.37 $97,000.00 45.95 %$52,431.63 001-000-111-513-00-20-00 Benefits $3,234.26 $19,237.99 $26,000.00 73.99 %$6,762.01 001-000-111-513-00-30-00 Office Supplies $0.00 $0.00 $250.00 0.00 %$250.00 001-000-111-513-00-40-00 Newsletter Printing & Mailing $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-111-513-00-40-01 Training $0.00 $0.00 $2,500.00 0.00 %$2,500.00 001-000-111-513-00-40-02 Professional Services $5,082.19 $16,887.57 $30,000.00 56.29 %$13,112.43 001-000-111-513-00-40-03 Cell Phone $0.00 $0.00 $550.00 0.00 %$550.00 001-000-111-513-00-40-04 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-111-513-00-40-05 Insurance $0.00 $32.57 $8,500.00 0.38 %$8,467.43 001-000-111-513-00-40-06 Miscellaneous $108.98 $108.98 $250.00 43.59 %$141.02 Total Mayor's Office $16,521.01 $80,835.48 $176,050.00 45.92 %$95,214.52 Municipal Court 001-000-120-512-50-10-00 Salaries $22,839.72 $151,670.11 $262,000.00 57.89 %$110,329.89 001-000-120-512-50-12-00 Salaries - Probation Services $4,986.26 $34,803.54 $58,500.00 59.49 %$23,696.46 001-000-120-512-50-20-00 Benefits $8,088.45 $54,268.58 $89,000.00 60.98 %$34,731.42 001-000-120-512-50-22-00 Benefits - Probation Services $3,036.13 $22,121.99 $39,000.00 56.72 %$16,878.01 001-000-120-512-50-31-00 Office Supplies $218.32 $945.11 $3,500.00 27.00 %$2,554.89 001-000-120-512-50-31-01 Central Stores $0.00 $1,184.96 $0.00 ($1,184.96) 001-000-120-512-50-40-00 Training $0.00 $780.00 $1,500.00 52.00 %$720.00 001-000-120-512-50-40-01 IT Services $0.00 $2,759.92 $2,705.00 102.03 %($54.92) 001-000-120-512-50-43-00 Travel $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-120-512-50-46-00 Insurance $0.00 $130.31 $15,860.00 0.82 %$15,729.69 001-000-120-512-50-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-50-49-01 Interpreting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-120-512-50-49-02 Judge Protems $0.00 $750.00 $4,000.00 18.75 %$3,250.00 001-000-120-512-50-49-03 Witness Fees $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-50-49-04 Juror Fees $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-120-512-50-49-09 Security $500.00 $1,872.25 $6,000.00 31.20 %$4,127.75 001-000-120-594-12-60-00 Capital Outlay $290.86 $3,058.71 $5,000.00 61.17 %$1,941.29 Total Municipal Court $39,959.74 $274,345.48 $501,065.00 54.75 %$226,719.52 Human Resources 001-000-139-518-10-10-00 Salaries $3,588.80 $17,900.34 $42,500.00 42.12 %$24,599.66 001-000-139-518-10-20-00 Benefits $1,579.87 $8,111.37 $19,000.00 42.69 %$10,888.63 001-000-139-518-10-30-00 Office Supplies $48.18 $48.18 $500.00 9.64 %$451.82 001-000-139-518-10-40-00 Training $0.00 $300.00 $1,000.00 30.00 %$700.00 001-000-139-518-10-40-01 Membership Dues & Publications $219.00 $914.60 $500.00 182.92 %($414.60) 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 $602.42 $1,000.00 60.24 %$397.58 001-000-139-518-10-40-04 Insurance $0.00 $21.72 $3,500.00 0.62 %$3,478.28 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 $39.83 $250.00 15.93 %$210.17 001-000-139-518-10-40-07 Pre-Employment Services $0.00 $343.00 $0.00 ($343.00) Total Human Resources $5,435.85 $28,281.46 $69,500.00 40.69 %$41,218.54 15 of 28 Account Number Title Period Fiscal Budget % of Total Balance City Clerk 001-000-140-514-20-10-00 Salaries $8,038.77 $62,795.61 $97,500.00 64.41 %$34,704.39 001-000-140-514-20-20-00 Benefits $4,349.14 $33,532.42 $50,800.00 66.01 %$17,267.58 001-000-140-514-20-31-00 Office Supplies $177.90 $686.40 $3,000.00 22.88 %$2,313.60 001-000-140-514-20-31-01 Central Stores $913.30 $3,461.23 $5,500.00 62.93 %$2,038.77 001-000-140-514-20-40-00 Training $35.00 $804.00 $3,000.00 26.80 %$2,196.00 001-000-140-514-20-41-00 Membership Dues & Publications $75.00 $500.00 $1,000.00 50.00 %$500.00 001-000-140-514-20-42-03 Postage $44.77 $44.77 $0.00 ($44.77) 001-000-140-514-20-43-00 Travel $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-140-514-20-44-00 Advertising $426.65 $1,104.23 $2,000.00 55.21 %$895.77 001-000-140-514-20-46-00 Insurance $0.00 $21.72 $7,300.00 0.30 %$7,278.28 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 $130.07 $500.00 26.01 %$369.93 001-000-140-514-30-20-00 Records Services $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-140-514-30-25-00 Codification $0.00 $2,962.15 $2,100.00 141.05 %($862.15) 001-000-140-582-10-40-00 Fireworks - Deposit Refund $0.00 $0.00 $2,300.00 0.00 %$2,300.00 001-000-140-594-00-60-00 Code Publishing $0.00 $610.07 $0.00 ($610.07) Total City Clerk $14,060.53 $106,652.67 $178,000.00 59.92 %$71,347.33 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $534.30 $3,128.09 $12,500.00 25.02 %$9,371.91 001-000-141-514-20-42-01 Telephone Line Charges $1,713.24 $9,692.50 $14,000.00 69.23 %$4,307.50 001-000-141-514-20-42-03 Postage $0.00 $2,802.96 $6,000.00 46.72 %$3,197.04 001-000-141-514-20-48-00 Repairs & Maintenance $867.76 $2,584.41 $4,000.00 64.61 %$1,415.59 Total Internal Services $3,115.30 $18,207.96 $36,500.00 49.88 %$18,292.04 Finance 001-000-142-514-20-10-00 Salaries $14,332.11 $100,112.03 $169,000.00 59.24 %$68,887.97 001-000-142-514-20-20-00 Benefits $5,656.36 $42,014.41 $70,000.00 60.02 %$27,985.59 001-000-142-514-20-31-00 Office Supplies $51.13 $606.79 $1,600.00 37.92 %$993.21 001-000-142-514-20-43-00 Travel $43.77 $92.15 $500.00 18.43 %$407.85 001-000-142-514-20-46-00 Insurance $0.00 $65.16 $12,282.00 0.53 %$12,216.84 001-000-142-514-23-20-00 State Audit $870.87 $1,956.63 $30,000.00 6.52 %$28,043.37 001-000-142-514-25-30-00 Bank Charges & Fees $234.07 $4,651.58 $4,500.00 103.37 %($151.58) 001-000-142-514-40-20-00 Training $125.00 $125.00 $1,500.00 8.33 %$1,375.00 Total Finance $21,313.31 $149,623.75 $289,382.00 51.70 %$139,758.25 Information Technology 001-000-145-514-20-10-00 Salaries $8,364.33 $57,878.06 $98,100.00 59.00 %$40,221.94 001-000-145-514-20-20-00 Benefits $3,673.63 $26,881.75 $45,500.00 59.08 %$18,618.25 001-000-145-514-20-31-00 Supplies $0.00 $424.18 $1,000.00 42.42 %$575.82 001-000-145-514-20-40-01 Memberships $0.00 $105.00 $100.00 105.00 %($5.00) 001-000-145-514-20-40-05 Disaster Backup System Support $0.00 $9,063.39 $16,000.00 56.65 %$6,936.61 001-000-145-514-20-40-10 Annual Fee - GIS Systems $7,498.48 $9,556.18 $10,100.00 94.62 %$543.82 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $15,237.14 $31,251.86 $23,000.00 135.88 %($8,251.86) 001-000-145-514-20-40-25 Annual License - Municipal Court $0.00 $0.00 $3,000.00 0.00 %$3,000.00 16 of 28 Account Number Title Period Fiscal Budget % of Total Balance 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.00 $6,085.00 $7,000.00 86.93 %$915.00 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $11,531.36 $20,000.00 57.66 %$8,468.64 001-000-145-514-20-40-40 Annual Subscription - Website $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-145-514-20-40-50 Annual License - FTR Recording System $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-145-514-20-40-51 Annual License - Electronic Archive (Smarsh & Archive Social) $0.00 $7,249.90 $7,500.00 96.67 %$250.10 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $1,644.65 $1,644.65 $10,000.00 16.45 %$8,355.35 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $0.00 $13,849.60 $8,000.00 173.12 %($5,849.60) 001-000-145-514-20-41-00 Professional Services $0.00 $1,644.36 $5,000.00 32.89 %$3,355.64 001-000-145-514-20-42-00 Cell Phone $62.18 $343.29 $850.00 40.39 %$506.71 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 $43.44 $3,000.00 1.45 %$2,956.56 001-000-145-594-14-60-20 Capital - PC Software Admin $3,242.33 $15,555.16 $33,000.00 47.14 %$17,444.84 001-000-145-594-14-60-25 Capital - PC Hardware Admin $2,424.64 $22,474.04 $32,000.00 70.23 %$9,525.96 Total Information Technology $42,147.38 $215,581.22 $334,650.00 64.42 %$119,068.78 Legal 001-000-151-515-31-10-00 Salaries $14,740.91 $102,496.51 $175,000.00 58.57 %$72,503.49 001-000-151-515-31-20-00 Benefits $5,720.25 $42,649.91 $72,000.00 59.24 %$29,350.09 001-000-151-515-31-20-10 Training $0.00 $102.96 $2,000.00 5.15 %$1,897.04 001-000-151-515-31-25-00 Professional Services $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-151-515-31-25-10 Licensing $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-151-515-31-31-00 Office Supplies $0.00 $71.85 $200.00 35.93 %$128.15 001-000-151-515-31-40-01 Legal Research $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-151-515-31-40-02 Membership Dues $0.00 $30.00 $30.00 100.00 %$0.00 001-000-151-515-31-43-00 Travel $0.00 $601.58 $500.00 120.32 %($101.58) 001-000-151-515-31-46-00 Insurance $0.00 $32.57 $11,280.00 0.29 %$11,247.43 001-000-151-515-31-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-151-515-35-25-05 Litigation Expenses $0.00 $1,000.00 $10,000.00 10.00 %$9,000.00 001-000-151-596-00-60-00 Capital Outlay $0.00 $30.00 $0.00 ($30.00) Total Legal $20,461.16 $147,015.38 $284,210.00 51.73 %$137,194.62 Legal - Public Records 001-000-152-515-31-10-00 Salaries $2,041.15 $14,228.69 $25,000.00 56.91 %$10,771.31 001-000-152-515-31-20-00 Benefits $797.80 $5,883.42 $11,000.00 53.49 %$5,116.58 001-000-152-515-31-40-00 Training $0.00 $0.00 $300.00 0.00 %$300.00 001-000-152-515-31-40-01 Postage $0.00 $0.00 $25.00 0.00 %$25.00 001-000-152-515-31-40-02 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-152-515-31-40-03 Insurance $0.00 $10.86 $2,820.00 0.39 %$2,809.14 001-000-152-515-31-40-04 Self-Insurance $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Legal - Public Records $2,838.95 $20,122.97 $45,145.00 44.57 %$25,022.03 Civil Service 001-000-160-521-10-10-00 Salaries $0.00 $1,300.00 $3,300.00 39.39 %$2,000.00 17 of 28 Account Number Title Period Fiscal Budget % of Total Balance 001-000-160-521-10-46-00 Insurance $0.00 $43.44 $8,100.00 0.54 %$8,056.56 Total Civil Service $0.00 $1,343.44 $11,400.00 11.78 %$10,056.56 Central Services 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $0.00 $1,126.64 $5,000.00 22.53 %$3,873.36 001-000-180-518-30-35-00 Small Tools & Equipment $0.00 $351.83 $10,000.00 3.52 %$9,648.17 001-000-180-518-30-41-00 Professional Services $71.43 $3,966.74 $25,000.00 15.87 %$21,033.26 001-000-180-518-30-41-01 Contracted Custodial Services $2,524.07 $14,657.77 $32,000.00 45.81 %$17,342.23 001-000-180-518-30-46-00 Insurance $0.00 $86.87 $52,000.00 0.17 %$51,913.13 001-000-180-518-30-47-00 Utilities $1,241.61 $12,521.76 $30,000.00 41.74 %$17,478.24 001-000-180-518-30-48-00 Repairs & Maintenance $0.00 $1,368.04 $15,000.00 9.12 %$13,631.96 001-000-180-518-30-49-00 Miscellaneous $35.91 $221.12 $2,000.00 11.06 %$1,778.88 001-000-180-518-30-49-01 Landscaping $0.00 $1,452.69 $1,000.00 145.27 %($452.69) 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$452.04 $9,515.62 $9,000.00 105.73 %($515.62) 001-000-180-594-18-60-00 Capital Outlay ($389.85)$2,040.37 $5,000.00 40.81 %$2,959.63 Total Central Services $3,935.21 $47,309.45 $186,000.00 25.44 %$138,690.55 Law Enforcement 001-000-210-521-10-10-00 Salaries $184,631.42 $1,289,008.00 $2,230,000.00 57.80 %$940,992.00 001-000-210-521-10-10-02 Overtime - Shift Coverage $15,003.21 $138,133.14 $140,000.00 98.67 %$1,866.86 001-000-210-521-10-10-03 Overtime Salaries - Traffic Safety $0.00 $0.00 $8,000.00 0.00 %$8,000.00 001-000-210-521-10-10-06 Overtime - Training $0.00 $0.00 $35,000.00 0.00 %$35,000.00 001-000-210-521-10-10-07 Overtime - Other $0.00 $0.00 $15,500.00 0.00 %$15,500.00 001-000-210-521-10-20-00 Benefits $62,197.41 $495,225.73 $841,000.00 58.89 %$345,774.27 001-000-210-521-10-20-01 Clothing Allowance $0.00 $7,614.88 $14,400.00 52.88 %$6,785.12 001-000-210-521-10-31-00 Office Supplies $63.46 $2,127.59 $8,500.00 25.03 %$6,372.41 001-000-210-521-10-31-05 Office Machine Costs $342.88 $2,477.16 $5,000.00 49.54 %$2,522.84 001-000-210-521-10-32-00 Fuel Consumed $5,118.88 $24,125.63 $55,000.00 43.86 %$30,874.37 001-000-210-521-10-35-00 Small Tools & Equipment $2,495.51 $47,302.09 $23,250.00 203.45 %($24,052.09) 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 $3,230.58 $13,116.48 $15,000.00 87.44 %$1,883.52 001-000-210-521-10-41-01 Emergency Management Contract $0.00 $21,308.02 $44,000.00 48.43 %$22,691.98 001-000-210-521-10-41-02 Membership Dues $0.00 $0.00 $600.00 0.00 %$600.00 001-000-210-521-10-42-01 Telephone $591.58 $14,088.04 $30,000.00 46.96 %$15,911.96 001-000-210-521-10-42-03 Postage $45.06 $483.04 $1,175.00 41.11 %$691.96 001-000-210-521-10-43-00 Travel $1,607.70 $5,609.20 $10,000.00 56.09 %$4,390.80 001-000-210-521-10-46-00 Insurance $4,879.77 $6,136.77 $71,000.00 8.64 %$64,863.23 001-000-210-521-10-48-00 Repairs & Maintenance $486.85 $3,260.39 $9,500.00 34.32 %$6,239.61 001-000-210-521-10-49-00 Miscellaneous $1,004.18 $3,642.32 $1,000.00 364.23 %($2,642.32) 001-000-210-521-10-49-02 Dry Cleaning Services $116.36 $602.13 $1,000.00 60.21 %$397.87 001-000-210-521-30-40-00 Crime Prevention $332.66 $332.66 $850.00 39.14 %$517.34 001-000-210-521-40-22-00 Training - Police Chief $0.00 $700.00 $1,000.00 70.00 %$300.00 001-000-210-521-40-25-00 Training - Officers $2,017.79 $3,217.79 $4,500.00 71.51 %$1,282.21 001-000-210-521-40-27-00 Training - Office Staff $250.00 $275.00 $500.00 55.00 %$225.00 001-000-210-521-40-30-00 Training - Academy $0.00 $3,347.00 $3,200.00 104.59 %($147.00) 18 of 28 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-50-10-00 Ancillary (Interfund Vehicle Maintenance) $0.00 $0.00 $2,400.00 0.00 %$2,400.00 001-000-210-521-50-49-00 Other Services $58.75 $58.75 $1,500.00 3.92 %$1,441.25 001-000-210-548-60-40-00 Fleet Rentals - Police $14,735.42 $103,147.94 $177,000.00 58.28 %$73,852.06 001-000-210-594-21-60-00 Capital Outlay $0.00 $7,875.48 $33,000.00 23.87 %$25,124.52 Total Law Enforcement $299,209.47 $2,193,215.23 $3,788,375.00 57.89 %$1,595,159.77 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $76,048.04 $266,548.39 $456,500.00 58.39 %$189,951.61 001-000-230-523-60-20-00 Medical Care - Prisoners $997.00 $4,708.70 $9,000.00 52.32 %$4,291.30 001-000-230-527-60-30-00 Juvenile Detention $0.00 $1,920.00 $7,500.00 25.60 %$5,580.00 Total Jail Services $77,045.04 $273,177.09 $473,000.00 57.75 %$199,822.91 Public Works 001-000-315-542-10-10-00 Salaries $48.72 $47,460.97 $81,500.00 58.23 %$34,039.03 001-000-315-542-10-20-00 Benefits $46.66 $23,318.11 $37,500.00 62.18 %$14,181.89 001-000-315-542-10-31-00 Office Supplies $0.00 $281.46 $750.00 37.53 %$468.54 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $34.54 $500.00 6.91 %$465.46 001-000-315-542-10-40-00 Cell Phone $52.18 $260.84 $750.00 34.78 %$489.16 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 $43.44 $13,000.00 0.33 %$12,956.56 001-000-315-542-10-49-00 Training $50.00 $342.62 $2,000.00 17.13 %$1,657.38 001-000-315-542-10-49-01 Miscellaneous $0.00 $45.39 $1,000.00 4.54 %$954.61 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 $1,460.47 $15,000.00 9.74 %$13,539.53 Total Public Works $197.56 $73,247.84 $153,500.00 47.72 %$80,252.16 Planning 001-000-580-558-60-10-00 Salaries $17,090.10 $101,365.46 $190,000.00 53.35 %$88,634.54 001-000-580-558-60-20-00 Benefits $6,606.96 $34,552.73 $62,000.00 55.73 %$27,447.27 001-000-580-558-60-31-00 Office Supplies $73.78 $875.97 $1,500.00 58.40 %$624.03 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 $143.89 $527.89 $1,000.00 52.79 %$472.11 001-000-580-558-60-40-01 Dues & Subscriptions $0.00 $787.00 $1,250.00 62.96 %$463.00 001-000-580-558-60-41-00 Professional Services $0.00 $1,244.00 $25,000.00 4.98 %$23,756.00 001-000-580-558-60-41-01 Hearings Examiner $0.00 $0.00 $600.00 0.00 %$600.00 001-000-580-558-60-41-02 Engineer/Architect Services $0.00 $1,455.00 $1,000.00 145.50 %($455.00) 001-000-580-558-60-43-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-580-558-60-44-00 Advertising $194.55 $2,580.85 $3,000.00 86.03 %$419.15 001-000-580-558-60-46-00 Insurance $0.00 $86.87 $13,440.00 0.65 %$13,353.13 001-000-580-558-60-48-00 Repairs & Maintenance $0.00 $401.18 $100.00 401.18 %($301.18) 001-000-580-558-60-49-00 Miscellaneous $0.00 $1,554.81 $1,000.00 155.48 %($554.81) Total Planning $24,109.28 $145,431.76 $302,165.00 48.13 %$156,733.24 Code Compliance 001-000-590-558-50-10-00 Salaries $8,477.89 $59,647.54 $109,000.00 54.72 %$49,352.46 001-000-590-558-50-20-00 Benefits $4,573.34 $32,485.24 $53,000.00 61.29 %$20,514.76 001-000-590-558-50-31-00 Office Supplies $0.00 $111.84 $300.00 37.28 %$188.16 19 of 28 Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-32-00 Fuel Consumed $43.90 $345.58 $400.00 86.40 %$54.42 001-000-590-558-50-35-00 Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 001-000-590-558-50-40-00 Training $100.00 $315.00 $300.00 105.00 %($15.00) 001-000-590-558-50-40-01 Dues & Subscriptions $0.00 $95.00 $275.00 34.55 %$180.00 001-000-590-558-50-41-01 Fire Marshal Services $0.00 $5,502.98 $22,145.00 24.85 %$16,642.02 001-000-590-558-50-42-00 Abatement $0.00 $0.00 $15,000.00 0.00 %$15,000.00 001-000-590-558-50-43-00 Travel $0.00 $0.00 $300.00 0.00 %$300.00 001-000-590-558-50-46-00 Insurance $0.00 $43.44 $10,690.00 0.41 %$10,646.56 001-000-590-558-50-48-00 Repairs & Maintenance $0.00 $1,134.34 $1,000.00 113.43 %($134.34) 001-000-590-558-50-49-00 Miscellaneous $0.00 $0.00 $150.00 0.00 %$150.00 Total Code Compliance $13,195.13 $99,680.96 $212,660.00 46.87 %$112,979.04 Other Expenditures 001-001-000-589-00-00-01 Fireworks - Deposit Refund $0.00 $0.00 $2,300.00 0.00 %$2,300.00 001-001-000-589-00-00-02 Fireworks - DCFD Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-001-000-589-00-00-03 County Share of Crime Victims $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 $650.00 0.00 %$650.00 001-001-000-589-00-00-05 State Share of Permits & Licenses $0.00 ($144.00)$10,000.00 -1.44 %$10,144.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 ($144.00)$166,700.00 -0.09 %$166,844.00 001-001-000-597-95-00-25 Transer Out to St Imp Fund $500,000.00 $500,000.00 $0.00 ($500,000.00) Total General Fund $1,135,650.68 $4,841,060.36 $8,450,197.00 57.29 %$3,609,136.64 Street Fund Storm Water Utility Charge 101-000-315-531-00-40-00 Annual SWU Charge $0.00 $82,215.00 $0.00 ($82,215.00) Total Storm Water Utility Charge $0.00 $82,215.00 $0.00 ($82,215.00) 101-000-420-542-30-10-00 Salaries - Roadway $169.04 $19,057.57 $64,500.00 29.55 %$45,442.43 101-000-420-542-30-20-00 Benefits - Roadway $103.35 $10,767.32 $34,000.00 31.67 %$23,232.68 101-000-420-542-30-30-00 Supplies - Roadway $2,952.24 $25,531.59 $50,000.00 51.06 %$24,468.41 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $53.18 $4,500.00 1.18 %$4,446.82 101-000-420-542-61-20-00 Benefits - Sidewalks $0.24 $17.17 $2,400.00 0.72 %$2,382.83 101-000-420-542-61-30-00 Supplies - Sidewalks $309.25 $323.83 $2,000.00 16.19 %$1,676.17 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 $197.68 $1,458.66 $2,000.00 72.93 %$541.34 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $87.27 $753.04 $1,000.00 75.30 %$246.96 101-000-420-542-62-30-00 Supplies - Special Purpose Paths $85.00 $85.00 $1,000.00 8.50 %$915.00 101-000-420-542-63-10-00 Salaries - Street Lighting $0.00 $1,201.02 $2,000.00 60.05 %$798.98 101-000-420-542-63-20-00 Benefits - Street Lighting $1.34 $870.11 $1,200.00 72.51 %$329.89 101-000-420-542-63-30-00 Supplies - Street Lighting $0.00 $49.01 $500.00 9.80 %$450.99 101-000-420-542-63-47-00 Utilities - Street Lighting $1,861.00 $13,304.90 $60,000.00 22.17 %$46,695.10 101-000-420-542-63-48-00 Repairs & Maintenance - Street Lighting $0.00 $783.26 $5,000.00 15.67 %$4,216.74 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $0.00 $33,858.70 $35,000.00 96.74 %$1,141.30 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $106.35 $19,436.12 $18,600.00 104.50 %($836.12) 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $2,346.05 $39,399.12 $48,000.00 82.08 %$8,600.88 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $818.07 $3,762.91 $9,000.00 41.81 %$5,237.09 20 of 28 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $0.00 $76.76 $14,000.00 0.55 %$13,923.24 101-000-420-542-65-10-00 Salaries - Parking Facilities $0.00 $358.01 $1,000.00 35.80 %$641.99 101-000-420-542-65-20-00 Benefits - Parking Facilities $0.00 $293.37 $500.00 58.67 %$206.63 101-000-420-542-65-30-00 Supplies - Parking Facilities $0.00 $4.72 $0.00 ($4.72) 101-000-420-542-65-47-00 Utilities - Parking Facilities $0.00 $0.00 $700.00 0.00 %$700.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $0.00 $8,945.83 $60,000.00 14.91 %$51,054.17 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $0.00 $6,383.16 $35,000.00 18.24 %$28,616.84 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $2,671.54 $15,985.83 $100,000.00 15.99 %$84,014.17 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $0.00 $1,793.25 $5,000.00 35.87 %$3,206.75 101-000-420-542-69-10-00 Salaries - Flags/Banners $289.85 $2,076.45 $20,000.00 10.38 %$17,923.55 101-000-420-542-69-20-00 Benefits - Flags/Banners $56.99 $1,054.08 $12,000.00 8.78 %$10,945.92 101-000-420-542-69-30-00 Supplies - Flags/Banners $200.04 $262.42 $2,000.00 13.12 %$1,737.58 101-000-420-542-70-10-00 Salaries - Roadside $28,979.58 $137,272.67 $240,000.00 57.20 %$102,727.33 101-000-420-542-70-20-00 Benefits - Roadside $12,960.45 $75,342.43 $130,000.00 57.96 %$54,657.57 101-000-420-542-70-30-00 Supplies - Roadside $1,533.71 $2,459.86 $5,000.00 49.20 %$2,540.14 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 $540.60 $1,000.00 54.06 %$459.40 101-000-420-542-70-48-00 Repairs & Maintenance - Roadside $61.30 $144.34 $1,000.00 14.43 %$855.66 101-000-420-542-75-10-00 Salaries - City Parks $3,758.38 $25,314.00 $45,000.00 56.25 %$19,686.00 101-000-420-542-75-20-00 Benefits - City Parks $1,706.80 $14,086.15 $23,000.00 61.24 %$8,913.85 101-000-420-542-75-30-00 Supplies - City Parks $1,217.73 $5,564.16 $15,000.00 37.09 %$9,435.84 101-000-420-542-75-47-00 Utilities - City Parks $771.68 $2,988.29 $5,000.00 59.77 %$2,011.71 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $18.40 $1,706.27 $4,000.00 42.66 %$2,293.73 101-000-420-542-90-49-00 Miscellaneous $0.00 ($119.48)$0.00 $119.48 101-000-430-543-30-10-00 Salaries - General Services $3,153.84 $19,016.16 $0.00 ($19,016.16) 101-000-430-543-30-20-00 Benefits - General Services $1,106.15 $8,911.04 $0.00 ($8,911.04) 101-000-430-543-30-30-00 Supplies - General Services $1,413.79 $6,629.01 $6,000.00 110.48 %($629.01) 101-000-430-543-30-46-00 Insurance $0.00 $451.84 $55,000.00 0.82 %$54,548.16 101-000-430-543-30-49-00 Miscellaneous - General Services $0.00 $728.99 $3,000.00 24.30 %$2,271.01 101-000-430-543-50-10-00 Salaries - Facilities $0.00 $232.36 $4,000.00 5.81 %$3,767.64 101-000-430-543-50-20-00 Benefits - Facilities $0.82 $228.44 $1,800.00 12.69 %$1,571.56 101-000-430-543-50-30-00 Supplies - Facilities $0.00 $93.11 $2,000.00 4.66 %$1,906.89 101-000-430-543-50-42-01 Cell Phone $88.85 $429.32 $750.00 57.24 %$320.68 101-000-430-543-50-47-00 Utilities - Facilities $186.66 $3,188.42 $6,500.00 49.05 %$3,311.58 101-000-430-543-50-48-00 Repairs & Maintenance - Facilities $0.00 $300.00 $2,500.00 12.00 %$2,200.00 101-000-430-544-90-10-00 Salaries - Training $0.00 $4,089.53 $7,000.00 58.42 %$2,910.47 101-000-430-544-90-20-00 Benefits - Training $15.95 $3,114.75 $3,500.00 88.99 %$385.25 101-000-430-544-90-30-00 Supplies - Training $0.00 $34.45 $500.00 6.89 %$465.55 101-000-430-544-90-35-00 Travel $0.00 $6,275.00 $4,000.00 156.88 %($2,275.00) 101-000-430-544-90-49-01 Training $313.68 $578.32 $1,000.00 57.83 %$421.68 101-000-430-548-60-40-00 Fleet Rentals - Streets $14,049.23 $98,344.61 $169,000.00 58.19 %$70,655.39 Total Street Fund $83,592.30 $708,106.03 $1,332,450.00 53.14 %$624,343.97 Community Development Grants Fund 102-000-000-518-63-40-00 CDBG Micro Enterprise Grant $0.00 $30,000.00 $0.00 ($30,000.00) 21 of 28 Account Number Title Period Fiscal Budget % of Total Balance 102-000-000-518-63-40-01 CDBG Food Assistance Program $83.61 $10,618.27 $0.00 ($10,618.27) 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $0.00 $72,164.00 0.00 %$72,164.00 102-000-000-558-70-44-00 CDBG Advertising $580.89 $1,376.78 $1,800.00 76.49 %$423.22 102-000-000-558-70-45-00 CDBG Travel $0.00 $0.00 $700.00 0.00 %$700.00 102-000-000-558-70-49-00 CDBG Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Community Development Grants Fund $664.50 $41,995.05 $74,764.00 56.17 %$32,768.95 Transportation Benefit District Fund 105-000-000-595-90-61-00 Pavement Ratings $0.00 $0.00 $6,000.00 0.00 %$6,000.00 105-000-000-597-91-00-00 Transfer-Out to Fund 301 $190,000.00 $190,000.00 $190,000.00 100.00 %$0.00 Total Transportation Benefit District Fund $190,000.00 $190,000.00 $196,000.00 96.94 %$6,000.00 Library Fund 112-000-000-572-50-47-00 Facilities - Utilities $212.68 $1,841.14 $6,500.00 28.33 %$4,658.86 Total Library Fund $212.68 $1,841.14 $6,500.00 28.33 %$4,658.86 Hotel/Motel Tax Fund 113-000-000-557-30-41-05 Wenatchee Valley Chamber $15,000.00 $15,000.00 $45,000.00 33.33 %$30,000.00 113-000-000-557-30-41-10 Contributions to Other Entities $5,000.00 $5,000.00 $50,000.00 10.00 %$45,000.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $5,062.00 $35,434.00 $61,000.00 58.09 %$25,566.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 $25,062.00 $115,434.00 $276,000.00 41.82 %$160,566.00 Criminal Justice Fund 116-000-000-597-21-00-20 Transfer Out - ER&R Fund $0.00 $0.00 $25,000.00 0.00 %$25,000.00 Total Criminal Justice Fund $0.00 $0.00 $25,000.00 0.00 %$25,000.00 Events Board Fund 117-000-050-557-30-10-00 Salaries $4,410.66 $33,381.11 $60,000.00 55.64 %$26,618.89 117-000-050-557-30-20-00 Benefits $2,080.61 $22,017.95 $29,000.00 75.92 %$6,982.05 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $0.00 $3,000.00 0.00 %$3,000.00 117-000-100-557-30-32-00 Fuel $0.00 $0.00 $200.00 0.00 %$200.00 117-000-100-557-30-40-00 Training $0.00 $359.00 $2,000.00 17.95 %$1,641.00 117-000-100-557-30-41-00 Professional Services $12.95 $221.70 $600.00 36.95 %$378.30 117-000-100-557-30-42-00 Cell Phone $52.18 $260.84 $760.00 34.32 %$499.16 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 $86.87 $10,360.00 0.84 %$10,273.13 117-000-110-557-30-31-14 Classy Chassis Central Stores $0.00 $499.88 $0.00 ($499.88) 117-000-115-557-30-31-05 Office Supplies $127.10 $179.17 $1,000.00 17.92 %$820.83 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-35-12 CC - Small Tools & Equipment $0.00 $471.98 $0.00 ($471.98) 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 $47.58 $344.97 $3,000.00 11.50 %$2,655.03 117-000-300-557-30-49-12 CC - Miscellaneous $23.77 $23.77 $500.00 4.75 %$476.23 117-000-300-557-30-49-15 Classy Chassis Miscellaneous $0.00 $60.00 $0.00 ($60.00) 22 of 28 Account Number Title Period Fiscal Budget % of Total Balance 117-000-400-557-30-31-11 Wings & Wheels Office Supplies $0.00 $0.00 $700.00 0.00 %$700.00 117-000-400-557-30-34-11 W&W Event Merch For Resale $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-400-557-30-41-00 W&W - Professional Services $0.00 $0.00 $5,200.00 0.00 %$5,200.00 117-000-400-557-30-42-13 W&W - Postage $0.00 $0.00 $800.00 0.00 %$800.00 117-000-400-557-30-43-12 W&W - EMPD Facility Fee $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-557-30-44-11 W&W - Advertising $0.00 $0.00 $5,000.00 0.00 %$5,000.00 117-000-400-557-30-44-15 W&W Prizes $0.00 $0.00 $250.00 0.00 %$250.00 117-000-400-557-30-49-11 W&W - Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 117-000-400-557-30-49-13 W&W - Schedule of Events Brochure $0.00 $0.00 $1,600.00 0.00 %$1,600.00 117-000-500-557-00-31-01 Christmas Office Supplies $0.00 $0.00 $500.00 0.00 %$500.00 117-000-500-557-30-35-01 Christmas - Small Tools & Equipment $0.00 $8.64 $150.00 5.76 %$141.36 117-000-500-557-30-40-05 Christmas - Events & Decorations $0.00 $997.72 $5,000.00 19.95 %$4,002.28 117-000-500-557-30-41-01 Christmas - Professional Services $0.00 $30.30 $400.00 7.58 %$369.70 117-000-500-557-30-44-01 Christmas - Advertising $0.00 $3.99 $750.00 0.53 %$746.01 117-000-500-557-30-49-01 Christmas - Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Events Board Fund $6,754.85 $58,947.89 $143,570.00 41.06 %$84,622.11 Bond Redemption Fund 202-000-000-591-95-70-00 Principal - PWTFL 10th St. NE $0.00 $165,000.00 $165,000.00 100.00 %$0.00 202-000-000-592-48-80-00 Interest - 2021 LTGO Bond (Public Works Area) $0.00 $0.00 $75,000.00 0.00 %$75,000.00 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $0.00 $5,974.55 $8,500.00 70.29 %$2,525.45 Total Bond Redemption Fund $0.00 $170,974.55 $248,500.00 68.80 %$77,525.45 Street Improvements Fund 301-000-000-595-10-40-02 Design - TIB N. Kentucky Overlay $0.00 $0.00 $79,500.00 0.00 %$79,500.00 301-000-000-595-10-40-03 Design - TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $96,300.00 0.00 %$96,300.00 301-000-000-595-10-40-04 Design - Grant Rd/Highline Dr Intersection Improvements $0.00 $0.00 $58,000.00 0.00 %$58,000.00 301-000-000-595-10-40-05 Design - Hamilton Ave Reconstruction $194.55 $194.55 $70,000.00 0.28 %$69,805.45 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $22,451.75 $48,901.77 $155,000.00 31.55 %$106,098.23 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $24,020.75 $50,648.45 $170,000.00 29.79 %$119,351.55 301-000-000-595-10-40-26 Design - PWTFL - 10th St $8,595.16 $171,458.40 $55,000.00 311.74 %($116,458.40) 301-000-000-595-20-60-01 ROW - PWTFL -10th St. Design $0.00 $8,770.47 $0.00 ($8,770.47) 301-000-000-595-20-60-02 ROW - SRTS - 5th St. Kenroy $39,016.58 $39,016.58 $105,000.00 37.16 %$65,983.42 301-000-000-595-20-60-03 ROW - SRTS - 5th St. Sterling $35,559.50 $35,559.50 $90,000.00 39.51 %$54,440.50 301-000-000-595-30-40-42 SDC - 10th St. NE Improvements $31,441.48 $31,441.48 $300,000.00 10.48 %$268,558.52 301-000-000-595-30-60-03 SDC - TIB N. Kentucky Overlay $0.00 $0.00 $53,000.00 0.00 %$53,000.00 301-000-000-595-30-60-04 Construction - TIB N. Kentucky Overlay $0.00 $0.00 $662,500.00 0.00 %$662,500.00 301-000-000-595-30-60-05 Construction - 10th St. NE Improvements $1,655,257.49 $1,655,257.49 $3,340,000.00 49.56 %$1,684,742.51 301-000-000-595-30-60-06 2021 Residential Overlay $0.00 $0.00 $190,000.00 0.00 %$190,000.00 301-000-000-595-61-60-00 TIB Complete Streets - Grant/Georgia Crossing $0.00 $767.56 $0.00 ($767.56) 301-000-000-595-61-60-01 TIB Complete Streets - Grant/June Crossing $0.00 $5,876.78 $0.00 ($5,876.78) 301-000-000-595-61-60-02 TIB Complete Streets - 3rd St. Sidewalk $0.00 $2,774.79 $0.00 ($2,774.79) 23 of 28 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-595-64-40-01 Design - 9th/VMP Intersection $0.00 $33,345.02 $71,000.00 46.96 %$37,654.98 301-000-000-595-64-60-00 SDC - 9th/VMP Intersection $0.00 $0.00 $93,100.00 0.00 %$93,100.00 301-000-000-595-64-60-01 Construction - 9th/VMP Intersection $0.00 $0.00 $795,000.00 0.00 %$795,000.00 301-000-000-595-90-10-00 Street Improvements Staff Salaries $0.00 $0.00 $22,300.00 0.00 %$22,300.00 301-000-000-595-90-20-00 Street Improvements Staff Benefits $0.00 $0.00 $11,000.00 0.00 %$11,000.00 301-000-000-597-95-00-25 Transfer Out to General Fund $0.00 $0.00 $500,000.00 0.00 %$500,000.00 Total Street Improvements Fund $1,816,537.26 $2,084,012.84 $6,916,700.00 30.13 %$4,832,687.16 Capital Improvements Fund 314-000-000-594-14-60-00 50 Simon St. Purchase $0.00 $4,031,900.86 $0.00 ($4,031,900.86) 314-000-000-594-14-60-01 50 Simon St. - Appraisal $4,500.00 $4,500.00 $0.00 ($4,500.00) 314-000-000-594-22-60-50 Maintenance Facilities Design $26,031.31 $54,636.63 $182,000.00 30.02 %$127,363.37 314-000-000-594-48-60-00 Maintenance Facilities Construction $0.00 $0.00 $1,000,000.00 0.00 %$1,000,000.00 314-001-000-597-00-00-01 Transfer-Out to 301 Fund $250,000.00 $250,000.00 $250,000.00 100.00 %$0.00 Total Capital Improvements Fund $280,531.31 $4,341,037.49 $1,432,000.00 303.15 %($2,909,037.49) Stormwater Fund 401-000-000-597-00-00-00 Transfer-Out - Fund 301 $728,000.00 $728,000.00 $728,000.00 100.00 %$0.00 Stormwater Utility Admin 401-000-001-522-10-40-00 B&O Tax on SWU Revenue $8,842.68 $8,842.68 $0.00 ($8,842.68) 401-000-001-531-00-10-00 Salaries - Stormwater Admin $470.80 $9,643.52 $30,000.00 32.15 %$20,356.48 401-000-001-531-00-20-00 Benefits - Stormwater Admin $222.97 $3,509.20 $13,200.00 26.58 %$9,690.80 401-000-001-531-00-30-00 Supplies - Stormwater Admin $0.00 $281.48 $500.00 56.30 %$218.52 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.18 $310.17 $750.00 41.36 %$439.83 401-000-001-531-00-40-01 Fee Collection - Douglas Co.$0.00 $7,233.84 $8,500.00 85.10 %$1,266.16 401-000-001-531-00-40-02 Insurance $0.00 $86.87 $6,500.00 1.34 %$6,413.13 401-000-001-531-00-40-03 City Stormwater Utility Charge $0.00 $83,902.50 $165,000.00 50.85 %$81,097.50 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 $408.00 $1,000.00 40.80 %$592.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 $33,187.07 $70,000.00 47.41 %$36,812.93 401-000-001-582-30-00-00 Non-Fiduciary Remittance $135.00 $1,620.00 $0.00 ($1,620.00) Total Stormwater Utility Admin $14,464.64 $149,025.33 $297,450.00 50.10 %$148,424.67 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $351.89 $9,319.68 $25,000.00 37.28 %$15,680.32 401-000-002-531-00-20-01 Benefits - NPDES Admin $181.41 $3,702.70 $11,000.00 33.66 %$7,297.30 401-000-002-531-00-40-00 Training - NPDES Admin $0.00 $85.00 $500.00 17.00 %$415.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,676.38 $8,000.00 33.45 %$5,323.62 Total NPDES Admin $533.30 $15,783.76 $49,500.00 31.89 %$33,716.24 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 24 of 28 Account Number Title Period Fiscal Budget % of Total Balance Total NPDES Outreach $0.00 $0.00 $3,100.00 0.00 %$3,100.00 NPDES Public Involvement 401-000-004-531-00-10-03 Salaries - NPDES Public Involvement $0.00 $0.00 $500.00 0.00 %$500.00 401-000-004-531-00-20-03 Benefits - NPDES Public Involvement $0.00 $0.00 $200.00 0.00 %$200.00 401-000-004-531-00-30-03 Supplies - NPDES Public Involvement $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Public Involvement $0.00 $0.00 $1,700.00 0.00 %$1,700.00 NPDES IDDE 401-000-005-531-00-10-04 Salaries - NPDES IDDE $0.00 $95.96 $3,000.00 3.20 %$2,904.04 401-000-005-531-00-20-04 Benefits - NPDES IDDE $0.43 $50.31 $1,000.00 5.03 %$949.69 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.43 $146.27 $7,000.00 2.09 %$6,853.73 NPDES Construction 401-000-006-531-00-10-05 Salaries - NPDES Construction $0.00 $95.97 $1,500.00 6.40 %$1,404.03 401-000-006-531-00-20-05 Benefits - NPDES Construction $0.43 $34.77 $600.00 5.80 %$565.23 Total NPDES Construction $0.43 $130.74 $2,100.00 6.23 %$1,969.26 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $434.70 $714.77 $1,500.00 47.65 %$785.23 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $77.94 $159.26 $600.00 26.54 %$440.74 Total NPDES Post Construction $512.64 $874.03 $2,100.00 41.62 %$1,225.97 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $9,529.26 $31,670.14 $73,000.00 43.38 %$41,329.86 401-000-008-531-00-10-08 Salaries - Sweeping $1,773.18 $15,750.85 $22,000.00 71.59 %$6,249.15 401-000-008-531-00-20-07 Benefits - NPDES PPGH $6,560.40 $18,403.75 $29,200.00 63.03 %$10,796.25 401-000-008-531-00-20-08 Benefits - Sweeping $875.65 $8,159.59 $11,000.00 74.18 %$2,840.41 401-000-008-531-00-30-05 Supplies - NPDES PPGH $0.00 $723.33 $20,000.00 3.62 %$19,276.67 401-000-008-531-00-30-06 Irrigation Supplies $0.00 $594.56 $3,000.00 19.82 %$2,405.44 401-000-008-531-00-30-07 Fuel $678.24 $2,554.33 $7,000.00 36.49 %$4,445.67 401-000-008-531-00-40-02 Training - NPDES PPGH $0.00 $2,443.81 $0.00 ($2,443.81) 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $41.13 $3,025.06 $5,000.00 60.50 %$1,974.94 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 $219.34 $2,042.55 $5,000.00 40.85 %$2,957.45 401-000-008-531-00-40-07 Decant Facility Tipping Fee $0.00 $0.00 $100,000.00 0.00 %$100,000.00 401-000-008-531-00-40-08 Decant Facility Admin. Charge $0.00 $0.00 $2,400.00 0.00 %$2,400.00 Total NPDES PPGH $19,677.20 $85,367.97 $302,600.00 28.21 %$217,232.03 NPDES Monitoring 401-000-009-531-00-10-09 Salaries - NPDES Monitoring $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-009-531-00-20-09 Benefits - NPDES Monitoring $0.00 $0.00 $400.00 0.00 %$400.00 401-000-009-531-00-30-06 Supplies - NPDES Monitoring $0.00 $0.00 $100.00 0.00 %$100.00 Total NPDES Monitoring $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Capital Outlay 401-000-010-594-31-60-03 Devon Pond $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Capital Outlay $0.00 $0.00 $10,000.00 0.00 %$10,000.00 401-000-011-594-31-60-04 19th Stormwater Facility Design $0.00 $9,995.38 $100,000.00 10.00 %$90,004.62 25 of 28 Account Number Title Period Fiscal Budget % of Total Balance 401-000-012-594-31-60-05 Small Improvements Projects $1,721.75 $4,776.57 $25,000.00 19.11 %$20,223.43 401-000-013-531-00-40-08 Payment to Douglas Co. for PWTFL $0.00 $75,400.79 $76,000.00 99.21 %$599.21 401-000-014-531-00-40-07 Stormwater Comp Plan Update $0.00 $29,163.87 $70,000.00 41.66 %$40,836.13 Total Stormwater Fund $764,910.39 $1,098,664.71 $1,676,050.00 65.55 %$577,385.29 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $1,369.66 $6,834.36 $5,300.00 128.95 %($1,534.36) 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $839.29 $4,262.48 $2,800.00 152.23 %($1,462.48) 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $2,314.30 $28,209.89 $35,000.00 80.60 %$6,790.11 501-000-000-542-90-10-00 Street Vehicle Repair Labor $1,997.87 $16,887.72 $24,000.00 70.37 %$7,112.28 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $823.41 $10,456.31 $12,000.00 87.14 %$1,543.69 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $2,237.28 $9,785.04 $23,000.00 42.54 %$13,214.96 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $0.00 $327.41 $5,000.00 6.55 %$4,672.59 501-000-000-542-90-48-30 Street Equipment Repairs $420.55 $732.03 $1,500.00 48.80 %$767.97 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 $190,291.89 $176,000.00 108.12 %($14,291.89) 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $64.00 $64.00 $208,000.00 0.03 %$207,936.00 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $10,870.88 $15,000.00 72.47 %$4,129.12 Total Equipment Purchase, Repair & Replacement Fund $10,066.36 $278,722.01 $512,100.00 54.43 %$233,377.99 Cafeteria Plan 634-000-000-589-40-00-01 Cafe Plan Bank Maintenance Fee $0.00 $500.00 $0.00 ($500.00) Total Cafeteria Plan $0.00 $500.00 $0.00 ($500.00) Custodial Activities Fund 635-000-000-586-00-00-01 Court Remittance $0.00 $67,524.66 $0.00 ($67,524.66) 635-000-000-589-30-00-01 Crime Victim Assessment - Douglas Co. Remittance $0.00 $1,276.97 $0.00 ($1,276.97) 635-000-000-589-30-00-02 Building Code Remittance $0.00 $309.50 $0.00 ($309.50) 635-000-000-589-30-00-03 Gun Permit State Remittance $842.25 $5,980.00 $0.00 ($5,980.00) Total Custodial Activities Fund $842.25 $75,091.13 $0.00 ($75,091.13) Grand Totals $4,314,824.58 $14,006,387.20 $21,289,831.00 65.79 %$7,283,443.80 26 of 28 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $1,135,650.68 $4,841,060.36 $8,450,197.00 57.29 %$3,609,136.64 101-000-000-000-00-00-00 Street Fund $83,592.30 $708,106.03 $1,332,450.00 53.14 %$624,343.97 102-000-000-000-00-00-00 Community Development Grants Fund $664.50 $41,995.05 $74,764.00 56.17 %$32,768.95 105-000-000-000-00-00-00 Transportation Benefit District Fund $190,000.00 $190,000.00 $196,000.00 96.94 %$6,000.00 112-000-000-000-00-00-00 Library Fund $212.68 $1,841.14 $6,500.00 28.33 %$4,658.86 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $25,062.00 $115,434.00 $276,000.00 41.82 %$160,566.00 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $0.00 $25,000.00 0.00 %$25,000.00 117-000-000-000-00-00-00 Events Board Fund $6,754.85 $58,947.89 $143,570.00 41.06 %$84,622.11 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $170,974.55 $248,500.00 68.80 %$77,525.45 301-000-000-000-00-00-00 Street Improvements Fund $1,816,537.26 $2,084,012.84 $6,916,700.00 30.13 %$4,832,687.16 314-000-000-000-00-00-00 Capital Improvements Fund $280,531.31 $4,341,037.49 $1,432,000.00 303.15 %($2,909,037.49) 401-000-000-000-00-00-00 Stormwater Fund $764,910.39 $1,098,664.71 $1,676,050.00 65.55 %$577,385.29 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $10,066.36 $278,722.01 $512,100.00 54.43 %$233,377.99 634-000-000-000-00-00-00 Cafeteria Plan $0.00 $500.00 $0.00 ($500.00) 635-000-000-000-00-00-00 Custodial Activities Fund $842.25 $75,091.13 $0.00 ($75,091.13) Grand Totals $4,314,824.58 $14,006,387.20 $21,289,831.00 65.79 %$7,283,443.80 27 of 28 Beginning Activity Ending July 2020 Variance Cash In Balance Ending Cash (Decrease)/Increase 001 $3,338,907.76 $5,568,021.66 $4,060,746.33 $2,448,155.74 $1,612,590.59 101 $248,197.36 $1,143,926.51 $682,487.84 $431,773.28 $250,714.56 102 $40,324.38 $35,007.86 $33,337.19 $75,609.93 ($42,272.74) 103 $13,494.91 $23,367.69 $36,862.60 $0.00 $36,862.60 105 $433,896.56 $153,251.08 $397,147.64 $479,847.38 ($82,699.74) 110 $0.00 $0.00 $0.00 $660,000.00 ($660,000.00) 112 $14,744.33 $3,752.88 $16,656.07 $12,558.36 $4,097.71 113 $162,733.87 $160,221.45 $207,521.32 $152,657.98 $54,863.34 114 $1,537.63 $10.77 $1,548.40 $1,525.57 $22.83 116 $2,870.61 $15,298.44 $18,169.05 $61,808.42 ($43,639.37) 117 $18,767.92 $62,611.65 $22,431.68 $55,411.32 ($32,979.64) 202 $775,826.60 $151.23 $605,003.28 $60,826.60 $544,176.68 301 $262,409.25 $1,971,277.92 $149,674.33 $1,552.64 $148,121.69 308 $0.00 $0.00 $0.00 $0.00 $0.00 314 $1,362,383.49 $4,289,514.39 $1,310,860.39 $1,353,708.42 ($42,848.03) 401 $2,166,740.88 $548,895.42 $1,616,925.35 $2,457,737.14 ($840,811.79) 501 $39,111.03 $608,687.24 $369,076.26 $248,870.54 $120,205.72 $8,881,946.58 $14,583,996.19 $9,528,447.73 $8,502,043.32 $1,026,404.41 Cash and Investment Activity Period: 2021 - July 2021 Fiscal Totals Fund Activity Street Fund $709,636.03 Out General Fund $4,846,183.09 Transportation Benefit District Fund $190,000.00 Financing Reserves Fund $0.00 Community Development Grants Fund $41,995.05 Affordable Housing Sales Tax Fund $0.00 Drug Fund $0.00 Criminal Justice Fund $0.00 Library Fund $1,841.14 Hotel/Motel Tax Fund $115,434.00 Street Improvements Fund $2,084,012.84 Storm Water Improvements Fund $0.00 Events Board Fund $58,947.89 Bond Redemption Fund $170,974.55 $13,937,495.04 Equipment Purchase, Repair & Replacement Fund $278,722.01 Capital Improvements Fund $4,341,037.49 Stormwater Fund $1,098,710.95 28 of 28