Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2021 - March 2021 Financial Report - Josh DeLay, Finance Director
City of East Wenatchee April 20, 2021 City Council Meeting March 2021 Financial Report Date: April 20, 2021 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: March 2021 Financial Report This report provides a summary of the City’s overall financial operations through March 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 March 31, 2021 compared to revenue collections through March 31, 2020, along with the respective dollar and percentage variances for its operating funds. Table 1 March 31, 2021 March 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 1,020,991 1,186,383 (165,392) (13.94%) Street Fund - 101 530,406 376,266 154,141 40.97% Events Board Fund - 117 60,000 38,591 21,409 55.48% Equipment R&R Fund - 501 474,577 350,000 124,577 35.59% Total Revenues - Operating Funds 2,085,974 1,951,239 134,735 6.91% 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 27 City of East Wenatchee April 20, 2021 City Council Meeting March 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 March 31, 2021 compared to revenue collections through March 31, 2020, along with the respective dollar and percentage variances for its non-operating funds. 2 of 27 City of East Wenatchee April 20, 2021 City Council Meeting March 2021 Financial Report Table 2 March 31, 2021 March 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 35,000 - 35,000 - Affordable Housing Tax Fund - 103 10,007 - 10,007 - Trans Benefit District Fund - 105 54,232 52,708 1,525 2.89% Library Fund - 112 - - - - Hotel/Motel Tax Fund - 113 58,448 73,047 (14,599) (19.99%) Drug Fund - 114 5 5 0 1.98% Criminal Justice Fund - 116 4,995 4,770 225 4.73% Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 62,717 75,585 (12,868) (17.02%) Capital Improvements Fund - 314 106,857 187,308 (80,451) (42.95%) Storm Water Fund - 401 16,814 2,615,611 (2,598,797) (99.36%) Total Revenues - Non-Operating Funds 349,075 3,009,033 (2,659,958) (88.40%) 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 27 City of East Wenatchee April 20, 2021 City Council Meeting March 2021 Financial Report Revenue Highlights: General Fund revenues are down $165,392, or 13.94%, year over year due to: $98,084 decrease in the sales tax allocation to this fund per normal year over year allocation variances (overall total sales tax is up 9.1% for the City’s funds combined); and a $23,663 decrease in phone/cellular utility tax for reasons that the Finance Department is currently auditing. The above decreases are offset by the following increases year over year: $32,868 increase in criminal justice sales tax presumably due to an increase in retail sales activity in Douglas County; and a $31,857 increase in property tax allocation to this fund per normal year over year allocation variances Street Fund revenues are up $154,141, or 40.97%, year over year due to a $170,000 increase in sales tax allocated to the fund, which is a budgeted increase out of necessity to keep the fund with a healthy year-end fund balance. Equipment R&R Fund revenues are up $124,577, or 35.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 $35,000 year over year due to the timing of reimbursements. Hotel/Motel Tax Fund revenues are down $14,599, or 19.99%, year over year presumably due to a decrease in hotel stays in the City. Street Improvements Fund revenues are down $12,868, or 17.02%, year over year due to the normal timing differences of projects associated with this fund. Capital Improvements Fund revenues are down $80,451, or 42.95%, year over year due to the decreased collection of real estate excise tax presumably due to less or smaller real estate sales transactions. Storm Water Fund revenues are down $2,598,797, or 99.36%, 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 27 City of East Wenatchee April 20, 2021 City Council Meeting March 2021 Financial Report Table 3 below shows the City’s expenditures through March 31, 2021 compared to expenditures through March 31, 2020, along with respective dollar and percentage variances for its operating funds. Table 3 March 31, 2021 March 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 1,873,746 1,828,693 45,054 2.46% Street Fund - 101 254,493 241,427 13,066 5.41% Events Board Fund - 117 27,202 26,478 724 2.73% Equipment R&R Fund - 501 156,391 120,690 35,701 29.58% Total Expenditures - Operating Funds 2,311,832 2,217,288 94,545 4.26% Expenditures - Operating Funds Chart 3 is a graphical representation of year over year expenditure comparisons for the City’s operating funds. Chart 3 5 of 27 City of East Wenatchee April 20, 2021 City Council Meeting March 2021 Financial Report Table 4 below shows the City’s expenditures through March 31, 2021 compared to expenditures through March 31, 2020, along with respective dollar and percentage variances for its non-operating funds. Table 4 March 31, 2021 March 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 416 - 416 - Trans Benefit District Fund - 105 - - - - Library Fund - 112 657 1,712 (1,055) (61.62%) Hotel/Motel Tax Fund - 113 75,186 78,318 (3,132) (4.00%) Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 105,235 74,953 30,281 40.40% Capital Improvements Fund - 314 22,933 - 22,933 - Storm Water Fund - 401 90,622 219,573 (128,951) (58.73%) Total Expenditures - Non-Operating Funds 295,050 374,557 (79,507) (21.23%) 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 27 City of East Wenatchee April 20, 2021 City Council Meeting March 2021 Financial Report Expenditure Highlights: General Fund expenditures are up $45,054, or 2.46%, year over year due to: General overall salary and benefit increases; and a $44,206 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 $13,066, or 5.41%, year over year due to a $42,148 increase in fleet rental costs related to the new format of the City’s equipment rental fund. Equipment R&R Fund expenditures are up $35,701, or 29.58%, year over year due to the timing of the purchase of three new police vehicles compared to when they were purchased last year. Additionally, the new vehicles are hybrids, which are more expensive than non-hybrid models. Street Improvements Fund expenditures are up $30,281, or 40.40%, year over year due typical timing variances associated with the capital projects in this fund. Storm Water Fund expenditures are down $128,951, or 58.73%, year over year primarily due to the City’s stormwater utility cost no longer being paid for 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 March 31, 2021. 7 of 27 Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $30,310.17 $43,961.91 $1,318,200.00 3.33 %$1,274,238.09 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $106,207.95 $306,207.95 $3,306,000.00 9.26 %$2,999,792.05 001-000-000-313-71-00-00 Criminal Justice Sales Tax $25,769.35 $113,793.14 $296,000.00 38.44 %$182,206.86 001-000-000-316-40-00-00 Electric Utility Tax $39,233.97 $114,390.22 $354,000.00 32.31 %$239,609.78 001-000-000-316-45-00-00 Natural Gas Utility Tax $11,214.59 $16,378.25 $35,000.00 46.80 %$18,621.75 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $20,871.35 $40,413.86 $360,000.00 11.23 %$319,586.14 001-000-000-316-84-00-00 Gambling Tax $0.00 $98,191.12 $317,000.00 30.98 %$218,808.88 Total Taxes $233,607.38 $733,336.45 $5,986,200.00 12.25 %$5,252,863.55 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $0.00 $0.00 $500.00 0.00 %$500.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $62.00 $474.00 $800.00 59.25 %$326.00 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $27,494.08 $91,000.00 30.21 %$63,505.92 001-000-000-321-99-00-00 Business Licenses & Permits $14,654.08 $32,373.08 $100,000.00 32.37 %$67,626.92 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 $2,837.60 $6,773.31 $60,000.00 11.29 %$53,226.69 001-000-000-322-90-01-00 Gun Permits $631.00 $2,224.00 $5,700.00 39.02 %$3,476.00 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $125.00 0.00 %$125.00 Total Licenses and Permits $18,184.68 $69,338.47 $258,785.00 26.79 %$189,446.53 Intergovernmental Revenues 001-000-000-334-01-20-01 Washington Courts Funding $0.00 $20,000.00 $0.00 ($20,000.00) 001-000-000-334-03-51-03 TSC - Seatbelt Emphasis Patrols $0.00 $0.00 $900.00 0.00 %$900.00 001-000-000-334-03-51-04 X-52 TSC-Speed Limit Emphasis $0.00 $0.00 $1,900.00 0.00 %$1,900.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $0.00 $0.00 $2,500.00 0.00 %$2,500.00 001-000-000-334-03-51-12 TSC - DUI Emphasis Patrol $0.00 $428.82 $2,500.00 17.15 %$2,071.18 001-000-000-334-04-20-05 Dept. of Commerce Grant $0.00 $10,530.00 $0.00 ($10,530.00) 001-000-000-334-06-91-00 WA ST Office of Public Defense $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-000-335-00-91-00 PUD Privilege Tax $0.00 $0.00 $43,000.00 0.00 %$43,000.00 001-000-000-336-00-71-00 Multimodal Transportation $4,610.12 $4,610.12 $0.00 ($4,610.12) 001-000-000-336-00-98-03 City Assistance $7,948.84 $7,948.84 $0.00 ($7,948.84) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $8,401.35 $8,401.35 $23,000.00 36.53 %$14,598.65 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $539.39 $2,000.00 26.97 %$1,460.61 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $22,004.78 $77,000.00 28.58 %$54,995.22 001-000-000-336-06-95-00 Liquor Board Profits $27,146.29 $27,146.29 $108,000.00 25.14 %$80,853.71 Total Intergovernmental Revenues $48,106.60 $101,609.59 $280,800.00 36.19 %$179,190.41 Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 501-000-000-397-00-00-02 Transfer-In - Criminal Justice Fund Period: 2021 - March 2021 8 of 27 Account Number Title Period Fiscal Budget % of Total Balance 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 $0.00 $70.00 0.00 %$70.00 001-000-000-341-35-33-00 Recording and Filing Fees $0.00 $0.00 $60.00 0.00 %$60.00 001-000-000-341-35-35-00 Annual Admin Reimb Fees $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-000-342-33-00-00 Adult Probation Services $4,344.25 $11,531.67 $63,000.00 18.30 %$51,468.33 001-000-000-342-36-00-00 Housing of Prisoners $545.09 $1,968.94 $20,000.00 9.84 %$18,031.06 001-000-000-342-40-00-01 Fire Marshall Inspection Services $196.00 $196.00 $5,000.00 3.92 %$4,804.00 001-000-000-345-83-00-00 Plan Checking Fees $1,714.57 $3,850.74 $30,000.00 12.84 %$26,149.26 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $243.00 $750.00 32.40 %$507.00 001-000-000-345-86-00-00 Sepa Permits $0.00 $488.00 $1,000.00 48.80 %$512.00 001-000-000-345-89-00-00 Planning & Development Fees $371.00 $1,213.00 $8,000.00 15.16 %$6,787.00 Total Charges for Goods and Services $7,170.91 $19,491.35 $133,070.00 14.65 %$113,578.65 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $12,048.30 $32,985.68 $175,000.00 18.85 %$142,014.32 001-000-000-357-33-00-00 Public Defender Costs $1,083.60 $2,579.60 $23,000.00 11.22 %$20,420.40 001-000-000-357-35-00-00 Restitution $0.00 $0.00 $400.00 0.00 %$400.00 Total Fines and Penalties $13,131.90 $35,565.28 $198,400.00 17.93 %$162,834.72 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $825.57 $2,755.97 $90,000.00 3.06 %$87,244.03 001-000-000-361-40-00-00 Sales Tax Interest $362.94 $1,052.77 $5,700.00 18.47 %$4,647.23 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,295.00 $2,870.79 $12,000.00 23.92 %$9,129.21 001-000-000-369-91-50-00 Miscellaneous Revenue $666.27 $666.27 $7,000.00 9.52 %$6,333.73 Total Miscellaneous Revenues $3,149.78 $7,345.80 $114,700.00 6.40 %$107,354.20 Other Increases in Fund Resources 001-000-000-382-10-00-00 Fireworks - Cleaning Deposit $0.00 $0.00 $2,350.00 0.00 %$2,350.00 001-000-000-382-10-00-01 Fireworks - Dcfd Remittance $0.00 $0.00 $200.00 0.00 %$200.00 001-000-000-389-00-00-01 Crime Victim Assessment $215.37 $571.41 $3,200.00 17.86 %$2,628.59 001-000-000-389-00-00-02 State Surcharge $132.50 $190.00 $700.00 27.14 %$510.00 001-000-000-389-00-00-03 State Share Weapons Permit Fee $969.25 $3,394.75 $8,700.00 39.02 %$5,305.25 001-000-000-389-00-00-04 Court Remittance - State $12,710.75 $34,692.39 $175,000.00 19.82 %$140,307.61 Total Other Increases in Fund Resources $14,027.87 $38,848.55 $190,150.00 20.43 %$151,301.45 Other Financing Sources 001-000-000-395-10-00-00 Proceeds - Disposition of Assets $0.00 $0.00 $9,800.00 0.00 %$9,800.00 001-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $0.00 $100.00 0.00 %$100.00 001-000-000-397-95-00-25 Transfer In - Street Imp Fund $0.00 $0.00 $500,000.00 0.00 %$500,000.00 001-000-000-398-10-00-00 Insurance Recoveries $0.00 $15,455.45 $0.00 ($15,455.45) Total Other Financing Sources $0.00 $15,455.45 $509,900.00 3.03 %$494,444.55 Total General Fund $337,379.12 $1,020,990.94 $7,672,005.00 13.31 %$6,651,014.06 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $0.00 $0.00 $500,000.00 0.00 %$500,000.00 101-000-000-313-11-00-00 Sales & Use Tax $196,047.57 $470,000.00 $470,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $250.00 $1,780.00 $2,000.00 89.00 %$220.00 9 of 27 Account Number Title Period Fiscal Budget % of Total Balance 101-000-000-336-00-71-00 Multi-Modal Distribution $0.00 $0.00 $18,000.00 0.00 %$18,000.00 101-000-000-336-00-87-00 Gas Tax $17,231.14 $54,277.72 $275,000.00 19.74 %$220,722.28 101-000-000-336-00-87-05 Increased Gas Tax $4,033.90 $4,033.90 $16,000.00 25.21 %$11,966.10 101-000-000-369-91-01-05 Miscellaneous Revenue $0.00 $314.65 $0.00 ($314.65) Total Street Fund $217,562.61 $530,406.27 $1,281,000.00 41.41 %$750,593.73 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 Total Community Development Grants Fund $0.00 $35,000.00 $74,764.00 46.81 %$39,764.00 Affordable Housing Sales Tax Fund 103-000-000-313-27-00-00 Affordable & Supportive Housing Sales/Use Tax $2,696.00 $10,006.77 $0.00 ($10,006.77) Total Affordable Housing Sales Tax Fund $2,696.00 $10,006.77 $0.00 ($10,006.77) Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $15,899.40 $54,232.20 $0.00 ($54,232.20) Total Transportation Benefit District Fund $15,899.40 $54,232.20 $0.00 ($54,232.20) Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $0.00 $7,500.00 0.00 %$7,500.00 Total Library Fund $0.00 $0.00 $7,500.00 0.00 %$7,500.00 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $21,758.21 $58,448.00 $225,000.00 25.98 %$166,552.00 Total Hotel/Motel Tax Fund $21,758.21 $58,448.00 $225,000.00 25.98 %$166,552.00 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $3.14 $5.14 $100.00 5.14 %$94.86 Total Drug Fund $3.14 $5.14 $100.00 5.14 %$94.86 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $1,093.10 $4,500.00 24.29 %$3,406.90 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $3,902.03 $16,000.00 24.39 %$12,097.97 Total Criminal Justice Fund $0.00 $4,995.13 $20,500.00 24.37 %$15,504.87 Events Board Fund 117-000-100-397-00-00-00 Transfer-In from Fund 113 $60,000.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 $0.00 $9,000.00 0.00 %$9,000.00 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $0.00 $0.00 $150.00 0.00 %$150.00 117-000-300-347-90-00-12 Classy Chassis Sponsorships $0.00 $0.00 $8,000.00 0.00 %$8,000.00 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-347-40-11-03 Wings & Wheels Car Show Registration $0.00 $0.00 $4,500.00 0.00 %$4,500.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $0.00 $0.00 $100.00 0.00 %$100.00 117-000-400-347-90-00-11 Wings & Wheels Sponsorships $0.00 $0.00 $12,000.00 0.00 %$12,000.00 117-000-400-347-90-11-00 Wings & Wheels Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-500-367-19-00-01 Christmas Sponsorships $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Events Board Fund $60,000.00 $60,000.00 $156,750.00 38.28 %$96,750.00 Street Improvements Fund 301-000-000-330-00-00-00 GWID - 10th St. NE Improvements $0.00 $0.00 $298,534.00 0.00 %$298,534.00 301-000-000-333-20-00-13 STP 9th/VMP Intersection $0.00 $26,438.55 $825,000.00 3.20 %$798,561.45 10 of 27 Account Number Title Period Fiscal Budget % of Total Balance 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 $17,423.21 $207,500.00 8.40 %$190,076.79 301-000-000-333-20-00-23 SRTS - 5th St NE: Kenroy $18,759.42 $18,759.42 $233,250.00 8.04 %$214,490.58 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-369-90-00-00 Miscellaneous Revenue $96.00 $96.00 $0.00 ($96.00) 301-000-000-391-80-00-00 PWTFL - 10th Street Design $0.00 $0.00 $50,000.00 0.00 %$50,000.00 301-000-000-397-00-00-00 Transfer-In - Fund 401 $0.00 $0.00 $728,000.00 0.00 %$728,000.00 301-000-000-397-00-00-01 Transfer-In - Fund 102 $0.00 $0.00 $70,000.00 0.00 %$70,000.00 301-000-000-397-41-10-05 Transfer-In from Fund 105 $0.00 $0.00 $190,000.00 0.00 %$190,000.00 301-000-000-397-95-00-20 Transfer-In from Fund 314 $0.00 $0.00 $250,000.00 0.00 %$250,000.00 301-000-000-397-95-00-25 Transfer In From General Fund $0.00 $0.00 $500,000.00 0.00 %$500,000.00 Total Street Improvements Fund $18,855.42 $62,717.18 $6,968,476.00 0.90 %$6,905,758.82 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $22,410.68 $106,857.00 $400,000.00 26.71 %$293,143.00 314-000-000-391-10-00-00 LTGO Bond Proceeds $0.00 $0.00 $5,000,000.00 0.00 %$5,000,000.00 Total Capital Improvements Fund $22,410.68 $106,857.00 $5,400,000.00 1.98 %$5,293,143.00 Stormwater Fund 401-000-000-334-03-10-01 19th St. Ecology Grant $6,483.86 $6,483.86 $50,000.00 12.97 %$43,516.14 401-000-000-334-03-10-02 Stormwater Comp Plan Ecology Grant $0.00 $0.00 $31,875.00 0.00 %$31,875.00 401-000-000-343-10-00-00 SWU Fee $6,984.00 $8,262.00 $520,000.00 1.59 %$511,738.00 401-000-000-361-40-00-00 Interest Earnings $0.00 $2.10 $0.00 ($2.10) 401-000-000-382-30-00-00 Non-Fiduciary Collections $2,066.06 $2,066.06 $0.00 ($2,066.06) Total Stormwater Fund $15,533.92 $16,814.02 $601,875.00 2.79 %$585,060.98 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 $44,206.26 $177,000.00 24.98 %$132,793.74 501-000-000-348-00-00-02 Street - Fleet Maintenance Rentals $14,049.23 $42,147.69 $169,000.00 24.94 %$126,852.31 501-000-000-348-00-00-03 Stormwater - Fleet Maintenance Rentals $4,741.01 $14,223.03 $57,000.00 24.95 %$42,776.97 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,525.66 $474,576.98 $802,000.00 59.17 %$327,423.02 Grand Totals $745,624.16 $2,435,049.63 $23,209,970.00 10.49 %$20,774,920.37 11 of 27 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $337,379.12 $1,020,990.94 $7,672,005.00 13.31 %$6,651,014.06 101-000-000-000-00-00-00 Street Fund $217,562.61 $530,406.27 $1,281,000.00 41.41 %$750,593.73 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $35,000.00 $74,764.00 46.81 %$39,764.00 103-000-000-000-00-00-00 Affordable Housing Sales Tax Fund $2,696.00 $10,006.77 $0.00 ($10,006.77) 105-000-000-000-00-00-00 Transportation Benefit District Fund $15,899.40 $54,232.20 $0.00 ($54,232.20) 112-000-000-000-00-00-00 Library Fund $0.00 $0.00 $7,500.00 0.00 %$7,500.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $21,758.21 $58,448.00 $225,000.00 25.98 %$166,552.00 114-000-000-000-00-00-00 Drug Fund $3.14 $5.14 $100.00 5.14 %$94.86 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $4,995.13 $20,500.00 24.37 %$15,504.87 117-000-000-000-00-00-00 Events Board Fund $60,000.00 $60,000.00 $156,750.00 38.28 %$96,750.00 301-000-000-000-00-00-00 Street Improvements Fund $18,855.42 $62,717.18 $6,968,476.00 0.90 %$6,905,758.82 314-000-000-000-00-00-00 Capital Improvements Fund $22,410.68 $106,857.00 $5,400,000.00 1.98 %$5,293,143.00 401-000-000-000-00-00-00 Stormwater Fund $15,533.92 $16,814.02 $601,875.00 2.79 %$585,060.98 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $33,525.66 $474,576.98 $802,000.00 59.17 %$327,423.02 Grand Totals $745,624.16 $2,435,049.63 $23,209,970.00 10.49 %$20,774,920.37 12 of 27 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 $136.83 $204.41 $1,000.00 20.44 %$795.59 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 $6,682.50 $26,500.00 25.22 %$19,817.50 001-000-001-528-70-40-00 River Com $21,770.90 $65,312.70 $261,251.00 25.00 %$195,938.30 001-000-001-539-30-40-00 Animal Control $6,248.76 $24,872.52 $73,515.00 33.83 %$48,642.48 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $15,918.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 $0.00 $1,250.00 0.00 %$1,250.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 $0.00 $3,000.00 0.00 %$3,000.00 001-000-001-558-70-41-15 Wenatchee Valley Museum $5,062.00 $15,186.00 $61,000.00 24.90 %$45,814.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $1,032.74 $3,600.00 28.69 %$2,567.26 001-000-001-597-95-00-25 Transfer Out to Street Impv Fund 301 $0.00 $0.00 $500,000.00 0.00 %$500,000.00 Total General Government $51,363.99 $151,608.87 $973,666.00 15.57 %$822,057.13 Legislative 001-000-110-511-60-10-00 Salaries $4,608.31 $25,626.62 $55,440.00 46.22 %$29,813.38 001-000-110-511-60-20-00 Benefits $353.43 $5,710.47 $4,500.00 126.90 %($1,210.47) 001-000-110-511-60-21-50 Public Defender $11,350.00 $34,550.00 $135,000.00 25.59 %$100,450.00 001-000-110-511-60-30-00 Public Defender Conflicts $45.00 $180.00 $5,200.00 3.46 %$5,020.00 001-000-110-511-60-31-00 Office Supplies $50.00 $50.00 $650.00 7.69 %$600.00 001-000-110-511-60-40-00 Training $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-110-511-60-41-00 Professional Services $0.00 $11,216.00 $10,000.00 112.16 %($1,216.00) 001-000-110-511-60-41-20 AWC Annual Membership Fee $0.00 $10,089.00 $9,989.00 101.00 %($100.00) 001-000-110-511-60-42-01 Cell Phone $41.98 $41.98 $0.00 ($41.98) 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 $12,426.90 $12,426.90 $25,000.00 49.71 %$12,573.10 001-000-110-511-60-46-00 Insurance $0.00 $15.62 $8,500.00 0.18 %$8,484.38 001-000-110-511-60-47-00 Background Check Costs $22.00 $66.00 $200.00 33.00 %$134.00 001-000-110-511-60-49-00 Miscellaneous $45.00 $45.00 $5,000.00 0.90 %$4,955.00 Total Legislative $28,942.62 $100,017.59 $268,229.00 37.29 %$168,211.41 Mayor's Office Expenditure Starting Account Number: 001-000-001-518-20-40-00 Property Management - 311 9th St NE Ending Account Number: 501-001-000-508-91-00-00 Unassigned Cash and Investments - Ending Period: 2021 - March 2021 13 of 27 Account Number Title Period Fiscal Budget % of Total Balance 001-000-111-513-00-10-00 Salaries $8,001.55 $12,297.72 $97,000.00 12.68 %$84,702.28 001-000-111-513-00-20-00 Benefits $3,416.94 $5,589.95 $26,000.00 21.50 %$20,410.05 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 $4,881.00 $4,881.00 $30,000.00 16.27 %$25,119.00 001-000-111-513-00-40-03 Cell Phone $0.00 $0.00 $550.00 0.00 %$550.00 001-000-111-513-00-40-04 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-111-513-00-40-05 Insurance $0.00 $15.62 $8,500.00 0.18 %$8,484.38 001-000-111-513-00-40-06 Miscellaneous $0.00 $0.00 $250.00 0.00 %$250.00 Total Mayor's Office $16,299.49 $22,784.29 $176,050.00 12.94 %$153,265.71 Municipal Court 001-000-120-512-50-10-00 Salaries $22,549.28 $60,830.48 $262,000.00 23.22 %$201,169.52 001-000-120-512-50-12-00 Salaries - Probation Services $4,981.90 $14,858.50 $58,500.00 25.40 %$43,641.50 001-000-120-512-50-20-00 Benefits $8,372.93 $20,414.88 $89,000.00 22.94 %$68,585.12 001-000-120-512-50-22-00 Benefits - Probation Services $3,109.30 $9,439.85 $39,000.00 24.20 %$29,560.15 001-000-120-512-50-31-00 Office Supplies $272.06 $272.06 $3,500.00 7.77 %$3,227.94 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 $390.00 $1,500.00 26.00 %$1,110.00 001-000-120-512-50-40-01 IT Services $0.00 $0.00 $2,705.00 0.00 %$2,705.00 001-000-120-512-50-43-00 Travel $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-120-512-50-46-00 Insurance $0.00 $62.49 $15,860.00 0.39 %$15,797.51 001-000-120-512-50-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-50-49-01 Interpreting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-120-512-50-49-02 Judge Protems $150.00 $150.00 $4,000.00 3.75 %$3,850.00 001-000-120-512-50-49-03 Witness Fees $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-50-49-04 Juror Fees $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-120-512-50-49-09 Security $0.00 $306.25 $6,000.00 5.10 %$5,693.75 001-000-120-594-12-60-00 Capital Outlay $528.31 $803.00 $5,000.00 16.06 %$4,197.00 Total Municipal Court $39,963.78 $108,712.47 $501,065.00 21.70 %$392,352.53 Human Resources 001-000-139-518-10-10-00 Salaries $3,496.22 $3,599.53 $42,500.00 8.47 %$38,900.47 001-000-139-518-10-20-00 Benefits $1,570.89 $1,617.29 $19,000.00 8.51 %$17,382.71 001-000-139-518-10-30-00 Office Supplies $0.00 $0.00 $500.00 0.00 %$500.00 001-000-139-518-10-40-00 Training $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-139-518-10-40-01 Membership Dues & Publications $199.00 $415.60 $500.00 83.12 %$84.40 001-000-139-518-10-40-02 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-139-518-10-40-03 Advertising $0.00 $602.42 $1,000.00 60.24 %$397.58 001-000-139-518-10-40-04 Insurance $0.00 $10.42 $3,500.00 0.30 %$3,489.58 001-000-139-518-10-40-05 Repairs & Maintenance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-139-518-10-40-06 Miscellaneous $0.00 $9.31 $250.00 3.72 %$240.69 001-000-139-518-10-40-07 Pre-Employment Services $0.00 $321.00 $0.00 ($321.00) Total Human Resources $5,266.11 $6,575.57 $69,500.00 9.46 %$62,924.43 City Clerk 001-000-140-514-20-10-00 Salaries $7,917.50 $30,669.24 $97,500.00 31.46 %$66,830.76 14 of 27 Account Number Title Period Fiscal Budget % of Total Balance 001-000-140-514-20-20-00 Benefits $4,202.20 $15,965.61 $50,800.00 31.43 %$34,834.39 001-000-140-514-20-31-00 Office Supplies $0.00 $64.97 $3,000.00 2.17 %$2,935.03 001-000-140-514-20-31-01 Central Stores $266.35 $690.44 $5,500.00 12.55 %$4,809.56 001-000-140-514-20-40-00 Training $0.00 $49.00 $3,000.00 1.63 %$2,951.00 001-000-140-514-20-41-00 Membership Dues & Publications $350.00 $350.00 $1,000.00 35.00 %$650.00 001-000-140-514-20-43-00 Travel $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-140-514-20-44-00 Advertising $0.00 $22.14 $2,000.00 1.11 %$1,977.86 001-000-140-514-20-46-00 Insurance $0.00 $10.42 $7,300.00 0.14 %$7,289.58 001-000-140-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-140-514-20-48-01 Fireworks - DCFD Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-140-514-20-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 001-000-140-514-30-20-00 Records Services $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-140-514-30-25-00 Codification $0.00 $0.00 $2,100.00 0.00 %$2,100.00 001-000-140-582-10-40-00 Fireworks - Deposit Refund $0.00 $0.00 $2,300.00 0.00 %$2,300.00 Total City Clerk $12,736.05 $47,821.82 $178,000.00 26.87 %$130,178.18 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $101.93 $420.85 $12,500.00 3.37 %$12,079.15 001-000-141-514-20-42-01 Telephone Line Charges $1,384.29 $3,825.86 $14,000.00 27.33 %$10,174.14 001-000-141-514-20-42-03 Postage $302.96 $302.96 $6,000.00 5.05 %$5,697.04 001-000-141-514-20-48-00 Repairs & Maintenance $350.81 $459.11 $4,000.00 11.48 %$3,540.89 Total Internal Services $2,139.99 $5,008.78 $36,500.00 13.72 %$31,491.22 Finance 001-000-142-514-20-10-00 Salaries $14,089.48 $42,879.93 $169,000.00 25.37 %$126,120.07 001-000-142-514-20-20-00 Benefits $5,890.31 $17,936.77 $70,000.00 25.62 %$52,063.23 001-000-142-514-20-31-00 Office Supplies $58.90 $457.76 $1,600.00 28.61 %$1,142.24 001-000-142-514-20-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 001-000-142-514-20-46-00 Insurance $0.00 $31.25 $12,282.00 0.25 %$12,250.75 001-000-142-514-23-20-00 State Audit $1,085.76 $1,085.76 $30,000.00 3.62 %$28,914.24 001-000-142-514-25-30-00 Bank Charges & Fees $320.85 $1,144.01 $4,500.00 25.42 %$3,355.99 001-000-142-514-40-20-00 Training $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Total Finance $21,445.30 $63,535.48 $289,382.00 21.96 %$225,846.52 Information Technology 001-000-145-514-20-10-00 Salaries $8,148.60 $24,506.34 $98,100.00 24.98 %$73,593.66 001-000-145-514-20-20-00 Benefits $3,779.11 $11,448.43 $45,500.00 25.16 %$34,051.57 001-000-145-514-20-31-00 Supplies $155.69 $155.69 $1,000.00 15.57 %$844.31 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 $1,260.00 $1,260.00 $16,000.00 7.88 %$14,740.00 001-000-145-514-20-40-10 Annual Fee - GIS Systems $2,057.70 $2,057.70 $10,100.00 20.37 %$8,042.30 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $0.00 $0.00 $23,000.00 0.00 %$23,000.00 001-000-145-514-20-40-25 Annual License - Municipal Court $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.00 $6,085.00 $7,000.00 86.93 %$915.00 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-145-514-20-40-40 Annual Subscription - Website $0.00 $0.00 $5,000.00 0.00 %$5,000.00 15 of 27 Account Number Title Period Fiscal Budget % of Total Balance 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) $19.25 $2,415.61 $7,500.00 32.21 %$5,084.39 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $6,924.80 $6,924.80 $8,000.00 86.56 %$1,075.20 001-000-145-514-20-41-00 Professional Services $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-145-514-20-42-00 Cell Phone $62.15 $62.15 $850.00 7.31 %$787.85 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 $20.83 $3,000.00 0.69 %$2,979.17 001-000-145-594-14-60-20 Capital - PC Software Admin $3,877.07 $5,519.32 $33,000.00 16.73 %$27,480.68 001-000-145-594-14-60-25 Capital - PC Hardware Admin $4,360.09 $10,991.53 $32,000.00 34.35 %$21,008.47 Total Information Technology $30,719.46 $71,522.40 $334,650.00 21.37 %$263,127.60 Legal 001-000-151-515-31-10-00 Salaries $14,519.77 $43,682.63 $175,000.00 24.96 %$131,317.37 001-000-151-515-31-20-00 Benefits $6,014.81 $18,246.91 $72,000.00 25.34 %$53,753.09 001-000-151-515-31-20-10 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-151-515-31-25-00 Professional Services $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-151-515-31-25-10 Licensing $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-151-515-31-31-00 Office Supplies $71.85 $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 $30.00 $30.00 $30.00 100.00 %$0.00 001-000-151-515-31-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 001-000-151-515-31-46-00 Insurance $0.00 $15.62 $11,280.00 0.14 %$11,264.38 001-000-151-515-31-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-151-596-00-60-00 Capital Outlay $30.00 $30.00 $0.00 ($30.00) Total Legal $20,666.43 $62,077.01 $284,210.00 21.84 %$222,132.99 Legal - Public Records 001-000-152-515-31-10-00 Salaries $2,028.25 $6,084.73 $25,000.00 24.34 %$18,915.27 001-000-152-515-31-20-00 Benefits $831.18 $2,493.54 $11,000.00 22.67 %$8,506.46 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 $5.21 $2,820.00 0.18 %$2,814.79 001-000-152-515-31-40-04 Self-Insurance $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Legal - Public Records $2,859.43 $8,583.48 $45,145.00 19.01 %$36,561.52 Civil Service 001-000-160-521-10-10-00 Salaries $260.00 $520.00 $3,300.00 15.76 %$2,780.00 001-000-160-521-10-46-00 Insurance $0.00 $20.83 $8,100.00 0.26 %$8,079.17 Total Civil Service $260.00 $540.83 $11,400.00 4.74 %$10,859.17 Central Services 16 of 27 Account Number Title Period Fiscal Budget % of Total Balance 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $237.40 $237.40 $5,000.00 4.75 %$4,762.60 001-000-180-518-30-35-00 Small Tools & Equipment $249.99 $477.83 $10,000.00 4.78 %$9,522.17 001-000-180-518-30-41-00 Professional Services $349.27 $349.27 $25,000.00 1.40 %$24,650.73 001-000-180-518-30-41-01 Contracted Custodial Services $2,426.74 $4,853.48 $32,000.00 15.17 %$27,146.52 001-000-180-518-30-46-00 Insurance $0.00 $41.66 $52,000.00 0.08 %$51,958.34 001-000-180-518-30-47-00 Utilities $2,172.36 $4,283.98 $30,000.00 14.28 %$25,716.02 001-000-180-518-30-48-00 Repairs & Maintenance $146.16 $146.16 $15,000.00 0.97 %$14,853.84 001-000-180-518-30-49-00 Miscellaneous $177.96 $177.96 $2,000.00 8.90 %$1,822.04 001-000-180-518-30-49-01 Landscaping $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$2,630.68 $4,255.90 $9,000.00 47.29 %$4,744.10 001-000-180-594-18-60-00 Capital Outlay $1,109.04 $1,109.04 $5,000.00 22.18 %$3,890.96 Total Central Services $9,499.60 $15,932.68 $186,000.00 8.57 %$170,067.32 Law Enforcement 001-000-210-521-10-10-00 Salaries $180,903.73 $540,015.48 $2,230,000.00 24.22 %$1,689,984.52 001-000-210-521-10-10-02 Overtime - Shift Coverage $36,091.85 $71,954.12 $140,000.00 51.40 %$68,045.88 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 $63,454.29 $201,425.55 $841,000.00 23.95 %$639,574.45 001-000-210-521-10-20-01 Clothing Allowance $1,146.46 $3,128.33 $14,400.00 21.72 %$11,271.67 001-000-210-521-10-31-00 Office Supplies $476.70 $1,100.68 $8,500.00 12.95 %$7,399.32 001-000-210-521-10-31-05 Office Machine Costs $636.51 $948.31 $5,000.00 18.97 %$4,051.69 001-000-210-521-10-32-00 Fuel Consumed $3,278.62 $6,721.55 $55,000.00 12.22 %$48,278.45 001-000-210-521-10-35-00 Small Tools & Equipment $13,254.57 $17,296.01 $23,250.00 74.39 %$5,953.99 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,933.72 $6,212.74 $15,000.00 41.42 %$8,787.26 001-000-210-521-10-41-01 Emergency Management Contract $0.00 $10,442.40 $44,000.00 23.73 %$33,557.60 001-000-210-521-10-41-02 Membership Dues $0.00 $0.00 $600.00 0.00 %$600.00 001-000-210-521-10-42-01 Telephone $2,366.49 $5,921.26 $30,000.00 19.74 %$24,078.74 001-000-210-521-10-42-03 Postage $0.00 $111.63 $1,175.00 9.50 %$1,063.37 001-000-210-521-10-43-00 Travel $1,820.00 $1,820.00 $10,000.00 18.20 %$8,180.00 001-000-210-521-10-46-00 Insurance $0.00 $759.67 $71,000.00 1.07 %$70,240.33 001-000-210-521-10-48-00 Repairs & Maintenance $561.56 $928.69 $9,500.00 9.78 %$8,571.31 001-000-210-521-10-49-00 Miscellaneous $54.15 $610.79 $1,000.00 61.08 %$389.21 001-000-210-521-10-49-02 Dry Cleaning Services $49.81 $182.47 $1,000.00 18.25 %$817.53 001-000-210-521-30-40-00 Crime Prevention $0.00 $0.00 $850.00 0.00 %$850.00 001-000-210-521-40-22-00 Training - Police Chief $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-210-521-40-25-00 Training - Officers $0.00 $0.00 $4,500.00 0.00 %$4,500.00 001-000-210-521-40-27-00 Training - Office Staff $0.00 $0.00 $500.00 0.00 %$500.00 001-000-210-521-40-30-00 Training - Academy $0.00 $0.00 $3,200.00 0.00 %$3,200.00 001-000-210-521-50-10-00 Ancillary (Interfund Vehicle Maintenance) $0.00 $0.00 $2,400.00 0.00 %$2,400.00 001-000-210-521-50-49-00 Other Services $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-548-60-40-00 Fleet Rentals - Police $14,735.42 $44,206.26 $177,000.00 24.98 %$132,793.74 001-000-210-594-21-60-00 Capital Outlay $0.00 $7,875.48 $33,000.00 23.87 %$25,124.52 17 of 27 Account Number Title Period Fiscal Budget % of Total Balance Total Law Enforcement $322,763.88 $921,661.42 $3,788,375.00 24.33 %$2,866,713.58 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $76,048.04 $114,452.31 $456,500.00 25.07 %$342,047.69 001-000-230-523-60-20-00 Medical Care - Prisoners $3,608.73 $3,608.73 $9,000.00 40.10 %$5,391.27 001-000-230-527-60-30-00 Juvenile Detention $0.00 $0.00 $7,500.00 0.00 %$7,500.00 Total Jail Services $79,656.77 $118,061.04 $473,000.00 24.96 %$354,938.96 Public Works 001-000-315-542-10-10-00 Salaries $8,005.38 $24,075.66 $81,500.00 29.54 %$57,424.34 001-000-315-542-10-20-00 Benefits $3,754.69 $11,353.47 $37,500.00 30.28 %$26,146.53 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 $34.54 $500.00 6.91 %$465.46 001-000-315-542-10-40-00 Cell Phone $52.15 $52.15 $750.00 6.95 %$697.85 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 $20.83 $13,000.00 0.16 %$12,979.17 001-000-315-542-10-49-00 Training $0.00 $171.00 $2,000.00 8.55 %$1,829.00 001-000-315-542-10-49-01 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-49-10 Memberships $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-544-20-45-00 Engineering Support Services $579.13 $692.91 $15,000.00 4.62 %$14,307.09 Total Public Works $12,391.35 $36,400.56 $153,500.00 23.71 %$117,099.44 Planning 001-000-580-558-60-10-00 Salaries $15,984.92 $48,000.91 $190,000.00 25.26 %$141,999.09 001-000-580-558-60-20-00 Benefits $5,579.82 $16,488.40 $62,000.00 26.59 %$45,511.60 001-000-580-558-60-31-00 Office Supplies $48.83 $48.83 $1,500.00 3.26 %$1,451.17 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 $70.00 $70.00 $1,000.00 7.00 %$930.00 001-000-580-558-60-40-01 Dues & Subscriptions $95.00 $787.00 $1,250.00 62.96 %$463.00 001-000-580-558-60-41-00 Professional Services $0.00 $0.00 $25,000.00 0.00 %$25,000.00 001-000-580-558-60-41-01 Hearings Examiner $0.00 $0.00 $600.00 0.00 %$600.00 001-000-580-558-60-41-02 Engineer/Architect Services $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-580-558-60-43-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-580-558-60-44-00 Advertising $0.00 $297.20 $3,000.00 9.91 %$2,702.80 001-000-580-558-60-46-00 Insurance $0.00 $41.66 $13,440.00 0.31 %$13,398.34 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 $52.15 $52.15 $1,000.00 5.22 %$947.85 Total Planning $21,830.72 $66,187.33 $302,165.00 21.90 %$235,977.67 Code Compliance 001-000-590-558-50-10-00 Salaries $8,515.57 $25,735.95 $109,000.00 23.61 %$83,264.05 001-000-590-558-50-20-00 Benefits $4,707.76 $13,316.91 $53,000.00 25.13 %$39,683.09 001-000-590-558-50-31-00 Office Supplies $0.00 $0.00 $300.00 0.00 %$300.00 001-000-590-558-50-32-00 Fuel Consumed $0.00 $30.67 $400.00 7.67 %$369.33 001-000-590-558-50-35-00 Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 001-000-590-558-50-40-00 Training $0.00 $0.00 $300.00 0.00 %$300.00 001-000-590-558-50-40-01 Dues & Subscriptions $0.00 $95.00 $275.00 34.55 %$180.00 001-000-590-558-50-41-01 Fire Marshal Services $0.00 $0.00 $22,145.00 0.00 %$22,145.00 18 of 27 Account Number Title Period Fiscal Budget % of Total Balance 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 $20.83 $10,690.00 0.19 %$10,669.17 001-000-590-558-50-48-00 Repairs & Maintenance $0.00 $1,042.49 $1,000.00 104.25 %($42.49) 001-000-590-558-50-49-00 Miscellaneous $0.00 $0.00 $150.00 0.00 %$150.00 Total Code Compliance $13,223.33 $40,241.85 $212,660.00 18.92 %$172,418.15 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 $607.83 $3,500.00 17.37 %$2,892.17 001-001-000-589-00-00-04 Remittance: State Building Code Surcharge $44.50 $89.00 $650.00 13.69 %$561.00 001-001-000-589-00-00-05 State Share of Permits & Licenses $717.00 $2,695.25 $10,000.00 26.95 %$7,304.75 001-001-000-589-00-00-06 Court Remittances $14,145.60 $23,080.79 $150,000.00 15.39 %$126,919.21 Total Other Expenditures $14,907.10 $26,472.87 $166,700.00 15.88 %$140,227.13 Total General Fund $706,935.40 $1,873,746.34 $8,450,197.00 22.17 %$6,576,450.66 Street Fund 101-000-420-542-30-10-00 Salaries - Roadway $1,431.63 $2,759.16 $64,500.00 4.28 %$61,740.84 101-000-420-542-30-20-00 Benefits - Roadway $431.44 ($176.20)$34,000.00 -0.52 %$34,176.20 101-000-420-542-30-30-00 Supplies - Roadway $131.31 $264.35 $50,000.00 0.53 %$49,735.65 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $0.00 $4,500.00 0.00 %$4,500.00 101-000-420-542-61-20-00 Benefits - Sidewalks $0.00 $3.15 $2,400.00 0.13 %$2,396.85 101-000-420-542-61-30-00 Supplies - Sidewalks $14.58 $14.58 $2,000.00 0.73 %$1,985.42 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 $685.65 $2,000.00 34.28 %$1,314.35 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $0.00 $194.58 $1,000.00 19.46 %$805.42 101-000-420-542-62-30-00 Supplies - Special Purpose Paths $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-63-10-00 Salaries - Street Lighting $0.00 $733.41 $2,000.00 36.67 %$1,266.59 101-000-420-542-63-20-00 Benefits - Street Lighting $0.00 $606.89 $1,200.00 50.57 %$593.11 101-000-420-542-63-30-00 Supplies - Street Lighting $0.00 $0.00 $500.00 0.00 %$500.00 101-000-420-542-63-47-00 Utilities - Street Lighting $2,827.96 $4,735.96 $60,000.00 7.89 %$55,264.04 101-000-420-542-63-48-00 Repairs & Maintenance - Street Lighting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $5,055.06 $5,508.11 $35,000.00 15.74 %$29,491.89 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $4,515.38 $4,784.21 $18,600.00 25.72 %$13,815.79 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $30,051.41 $31,648.10 $48,000.00 65.93 %$16,351.90 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $576.10 $983.83 $9,000.00 10.93 %$8,016.17 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $2.73 $2.73 $14,000.00 0.02 %$13,997.27 101-000-420-542-65-10-00 Salaries - Parking Facilities $358.01 $358.01 $1,000.00 35.80 %$641.99 101-000-420-542-65-20-00 Benefits - Parking Facilities $268.45 $268.45 $500.00 53.69 %$231.55 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 $1,243.39 $8,945.83 $60,000.00 14.91 %$51,054.17 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $256.37 $5,940.38 $35,000.00 16.97 %$29,059.62 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $10,944.17 $13,239.26 $100,000.00 13.24 %$86,760.74 19 of 27 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $437.64 $1,308.88 $5,000.00 26.18 %$3,691.12 101-000-420-542-69-10-00 Salaries - Flags/Banners $0.00 $657.23 $20,000.00 3.29 %$19,342.77 101-000-420-542-69-20-00 Benefits - Flags/Banners $0.00 $219.41 $12,000.00 1.83 %$11,780.59 101-000-420-542-69-30-00 Supplies - Flags/Banners ($6.59)$62.38 $2,000.00 3.12 %$1,937.62 101-000-420-542-70-10-00 Salaries - Roadside $15,522.96 $59,135.95 $240,000.00 24.64 %$180,864.05 101-000-420-542-70-20-00 Benefits - Roadside $8,586.56 $33,046.24 $130,000.00 25.42 %$96,953.76 101-000-420-542-70-30-00 Supplies - Roadside $473.01 $663.35 $5,000.00 13.27 %$4,336.65 101-000-420-542-70-41-00 Professional Services - Roadside $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-70-47-00 Utilities - Roadside $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-70-48-00 Repairs & Maintenance - Roadside $0.00 $4.32 $1,000.00 0.43 %$995.68 101-000-420-542-75-10-00 Salaries - City Parks $2,402.61 $10,442.90 $45,000.00 23.21 %$34,557.10 101-000-420-542-75-20-00 Benefits - City Parks $865.07 $5,816.71 $23,000.00 25.29 %$17,183.29 101-000-420-542-75-30-00 Supplies - City Parks $319.59 $2,090.09 $15,000.00 13.93 %$12,909.91 101-000-420-542-75-47-00 Utilities - City Parks $210.76 $1,561.21 $5,000.00 31.22 %$3,438.79 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $0.00 $53.65 $4,000.00 1.34 %$3,946.35 101-000-430-543-30-10-00 Salaries - General Services $2,289.86 $7,316.51 $0.00 ($7,316.51) 101-000-430-543-30-20-00 Benefits - General Services $1,232.89 $3,298.79 $0.00 ($3,298.79) 101-000-430-543-30-30-00 Supplies - General Services $638.38 $1,028.57 $6,000.00 17.14 %$4,971.43 101-000-430-543-30-46-00 Insurance $0.00 $270.99 $55,000.00 0.49 %$54,729.01 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 $52.78 $4,000.00 1.32 %$3,947.22 101-000-430-543-50-20-00 Benefits - Facilities $0.00 $36.54 $1,800.00 2.03 %$1,763.46 101-000-430-543-50-30-00 Supplies - Facilities $0.00 $93.11 $2,000.00 4.66 %$1,906.89 101-000-430-543-50-42-01 Cell Phone $88.69 $88.69 $750.00 11.83 %$661.31 101-000-430-543-50-47-00 Utilities - Facilities $823.72 $1,699.01 $6,500.00 26.14 %$4,800.99 101-000-430-543-50-48-00 Repairs & Maintenance - Facilities $0.00 $0.00 $2,500.00 0.00 %$2,500.00 101-000-430-544-90-10-00 Salaries - Training $324.39 $567.53 $7,000.00 8.11 %$6,432.47 101-000-430-544-90-20-00 Benefits - Training $243.30 $390.91 $3,500.00 11.17 %$3,109.09 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 $205.70 $205.70 $1,000.00 20.57 %$794.30 101-000-430-548-60-40-00 Fleet Rentals - Streets $14,049.23 $42,147.69 $169,000.00 24.94 %$126,852.31 Total Street Fund $106,815.76 $254,493.29 $1,332,450.00 19.10 %$1,077,956.71 Community Development Grants Fund 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $0.00 $72,164.00 0.00 %$72,164.00 102-000-000-558-70-44-00 CDBG Advertising $0.00 $416.16 $1,800.00 23.12 %$1,383.84 102-000-000-558-70-45-00 CDBG Travel $0.00 $0.00 $700.00 0.00 %$700.00 102-000-000-558-70-49-00 CDBG Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Community Development Grants Fund $0.00 $416.16 $74,764.00 0.56 %$74,347.84 Transportation Benefit District Fund 105-000-000-595-90-61-00 Pavement Ratings $0.00 $0.00 $6,000.00 0.00 %$6,000.00 105-000-000-597-91-00-00 Transfer-Out to Fund 301 $0.00 $0.00 $190,000.00 0.00 %$190,000.00 Total Transportation Benefit District Fund $0.00 $0.00 $196,000.00 0.00 %$196,000.00 Library Fund 20 of 27 Account Number Title Period Fiscal Budget % of Total Balance 112-000-000-572-50-47-00 Facilities - Utilities $297.29 $657.08 $6,500.00 10.11 %$5,842.92 Total Library Fund $297.29 $657.08 $6,500.00 10.11 %$5,842.92 Hotel/Motel Tax Fund 113-000-000-557-30-41-05 Wenatchee Valley Chamber $0.00 $0.00 $45,000.00 0.00 %$45,000.00 113-000-000-557-30-41-10 Contributions to Other Entities $0.00 $0.00 $50,000.00 0.00 %$50,000.00 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $5,062.00 $15,186.00 $61,000.00 24.90 %$45,814.00 113-001-000-597-00-00-01 Transfer-Out to Fund 117 $60,000.00 $60,000.00 $120,000.00 50.00 %$60,000.00 Total Hotel/Motel Tax Fund $65,062.00 $75,186.00 $276,000.00 27.24 %$200,814.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,763.94 $15,614.69 $60,000.00 26.02 %$44,385.31 117-000-050-557-30-20-00 Benefits $3,805.60 $11,117.98 $29,000.00 38.34 %$17,882.02 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 $324.00 $324.00 $2,000.00 16.20 %$1,676.00 117-000-100-557-30-41-00 Professional Services $12.95 $25.90 $600.00 4.32 %$574.10 117-000-100-557-30-42-00 Cell Phone $52.15 $52.15 $760.00 6.86 %$707.85 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 $41.66 $10,360.00 0.40 %$10,318.34 117-000-115-557-30-31-05 Office Supplies $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-300-557-30-31-12 Classy Chassis Office Supplies $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-300-557-30-34-11 Classy Chassis Event Merch For Resale $0.00 $0.00 $2,500.00 0.00 %$2,500.00 117-000-300-557-30-41-12 CC - Professional Services $0.00 $0.00 $2,300.00 0.00 %$2,300.00 117-000-300-557-30-42-14 CC - Postage $0.00 $0.00 $800.00 0.00 %$800.00 117-000-300-557-30-43-12 CC - EMPD Facility Fee $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-300-557-30-44-12 CC - Advertising $0.00 $0.00 $3,000.00 0.00 %$3,000.00 117-000-300-557-30-49-12 CC - Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-557-30-31-11 Wings & Wheels Office Supplies $0.00 $0.00 $700.00 0.00 %$700.00 117-000-400-557-30-34-11 W&W Event Merch For Resale $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-400-557-30-41-00 W&W - Professional Services $0.00 $0.00 $5,200.00 0.00 %$5,200.00 117-000-400-557-30-42-13 W&W - Postage $0.00 $0.00 $800.00 0.00 %$800.00 117-000-400-557-30-43-12 W&W - EMPD Facility Fee $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-400-557-30-44-11 W&W - Advertising $0.00 $0.00 $5,000.00 0.00 %$5,000.00 117-000-400-557-30-44-15 W&W Prizes $0.00 $0.00 $250.00 0.00 %$250.00 117-000-400-557-30-49-11 W&W - Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 117-000-400-557-30-49-13 W&W - Schedule of Events Brochure $0.00 $0.00 $1,600.00 0.00 %$1,600.00 117-000-500-557-00-31-01 Christmas Office Supplies $0.00 $0.00 $500.00 0.00 %$500.00 117-000-500-557-30-35-01 Christmas - Small Tools & Equipment $0.00 $0.00 $150.00 0.00 %$150.00 117-000-500-557-30-40-05 Christmas - Events & Decorations $0.00 $21.61 $5,000.00 0.43 %$4,978.39 117-000-500-557-30-41-01 Christmas - Professional Services $0.00 $0.00 $400.00 0.00 %$400.00 117-000-500-557-30-44-01 Christmas - Advertising $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 21 of 27 Account Number Title Period Fiscal Budget % of Total Balance Total Events Board Fund $8,958.64 $27,201.98 $143,570.00 18.95 %$116,368.02 Bond Redemption Fund 202-000-000-591-95-70-00 Principal - PWTFL 10th St. NE $0.00 $0.00 $165,000.00 0.00 %$165,000.00 202-000-000-592-48-80-00 Interest - 2021 LTGO Bond (Public Works Area) $0.00 $0.00 $75,000.00 0.00 %$75,000.00 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $0.00 $0.00 $8,500.00 0.00 %$8,500.00 Total Bond Redemption Fund $0.00 $0.00 $248,500.00 0.00 %$248,500.00 Street Improvements Fund 301-000-000-595-10-40-02 Design - TIB N. Kentucky Overlay $0.00 $0.00 $79,500.00 0.00 %$79,500.00 301-000-000-595-10-40-03 Design - TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $96,300.00 0.00 %$96,300.00 301-000-000-595-10-40-04 Design - Grant Rd/Highline Dr Intersection Improvements $0.00 $0.00 $58,000.00 0.00 %$58,000.00 301-000-000-595-10-40-05 Design - Hamilton Ave Reconstruction $0.00 $0.00 $70,000.00 0.00 %$70,000.00 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $7,651.06 $13,840.81 $155,000.00 8.93 %$141,159.19 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $8,557.81 $13,928.56 $170,000.00 8.19 %$156,071.44 301-000-000-595-10-40-26 Design - PWTFL - 10th St $18,496.97 $56,002.62 $55,000.00 101.82 %($1,002.62) 301-000-000-595-20-60-01 ROW - PWTFL -10th St. Design $5,263.95 $5,263.95 $0.00 ($5,263.95) 301-000-000-595-20-60-02 ROW - SRTS - 5th St. Kenroy $0.00 $0.00 $105,000.00 0.00 %$105,000.00 301-000-000-595-20-60-03 ROW - SRTS - 5th St. Sterling $0.00 $0.00 $90,000.00 0.00 %$90,000.00 301-000-000-595-30-40-42 SDC - 10th St. NE Improvements $0.00 $0.00 $300,000.00 0.00 %$300,000.00 301-000-000-595-30-60-03 SDC - TIB N. Kentucky Overlay $0.00 $0.00 $53,000.00 0.00 %$53,000.00 301-000-000-595-30-60-04 Construction - TIB N. Kentucky Overlay $0.00 $0.00 $662,500.00 0.00 %$662,500.00 301-000-000-595-30-60-05 Construction - 10th St. NE Improvements $0.00 $0.00 $3,340,000.00 0.00 %$3,340,000.00 301-000-000-595-30-60-06 2021 Residential Overlay $0.00 $0.00 $190,000.00 0.00 %$190,000.00 301-000-000-595-61-60-00 TIB Complete Streets - Grant/Georgia Crossing $295.00 $435.06 $0.00 ($435.06) 301-000-000-595-61-60-01 TIB Complete Streets - Grant/June Crossing $295.00 $5,544.28 $0.00 ($5,544.28) 301-000-000-595-61-60-02 TIB Complete Streets - 3rd St. Sidewalk $295.00 $2,442.29 $0.00 ($2,442.29) 301-000-000-595-64-40-01 Design - 9th/VMP Intersection $4,142.19 $7,777.18 $71,000.00 10.95 %$63,222.82 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 $44,996.98 $105,234.75 $6,916,700.00 1.52 %$6,811,465.25 Capital Improvements Fund 314-000-000-594-22-60-50 Maintenance Facilities Design $22,933.32 $22,933.32 $182,000.00 12.60 %$159,066.68 314-000-000-594-48-60-00 Maintenance Facilities Construction $0.00 $0.00 $1,000,000.00 0.00 %$1,000,000.00 314-001-000-597-00-00-01 Transfer-Out to 301 Fund $0.00 $0.00 $250,000.00 0.00 %$250,000.00 Total Capital Improvements Fund $22,933.32 $22,933.32 $1,432,000.00 1.60 %$1,409,066.68 Stormwater Fund 401-000-000-582-30-00-00 Non-Fiduciary Remittance $945.00 $945.00 $0.00 ($945.00) 22 of 27 Account Number Title Period Fiscal Budget % of Total Balance 401-000-000-597-00-00-00 Transfer-Out - Fund 301 $0.00 $0.00 $728,000.00 0.00 %$728,000.00 Stormwater Utility Admin 401-000-001-531-00-10-00 Salaries - Stormwater Admin $1,161.87 $4,204.02 $30,000.00 14.01 %$25,795.98 401-000-001-531-00-20-00 Benefits - Stormwater Admin $401.64 $1,335.75 $13,200.00 10.12 %$11,864.25 401-000-001-531-00-30-00 Supplies - Stormwater Admin $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-531-00-30-01 Small Tools & Equipment $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-001-531-00-40-00 Cell Phone $52.15 $52.15 $750.00 6.95 %$697.85 401-000-001-531-00-40-01 Fee Collection - Douglas Co.$0.00 $0.00 $8,500.00 0.00 %$8,500.00 401-000-001-531-00-40-02 Insurance $0.00 $41.66 $6,500.00 0.64 %$6,458.34 401-000-001-531-00-40-03 City Stormwater Utility Charge $0.00 $0.00 $165,000.00 0.00 %$165,000.00 401-000-001-531-00-40-04 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-531-00-40-05 Training - Stormwater Admin $408.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 $14,223.03 $70,000.00 20.32 %$55,776.97 Total Stormwater Utility Admin $6,764.67 $20,264.61 $297,450.00 6.81 %$277,185.39 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $2,943.08 $6,184.67 $25,000.00 24.74 %$18,815.33 401-000-002-531-00-20-01 Benefits - NPDES Admin $1,094.17 $2,179.05 $11,000.00 19.81 %$8,820.95 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 $2,676.38 $2,676.38 $8,000.00 33.45 %$5,323.62 Total NPDES Admin $6,713.63 $11,040.10 $49,500.00 22.30 %$38,459.90 NPDES Outreach 401-000-003-531-00-10-02 Salaries - NPDES Outreach $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-003-531-00-20-02 Benefits - NPDES Outreach $0.00 $0.00 $600.00 0.00 %$600.00 401-000-003-531-00-30-02 Supplies - NPDES Outreach $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Outreach $0.00 $0.00 $3,100.00 0.00 %$3,100.00 NPDES Public Involvement 401-000-004-531-00-10-03 Salaries - NPDES Public Involvement $0.00 $0.00 $500.00 0.00 %$500.00 401-000-004-531-00-20-03 Benefits - NPDES Public Involvement $0.00 $0.00 $200.00 0.00 %$200.00 401-000-004-531-00-30-03 Supplies - NPDES Public Involvement $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Public Involvement $0.00 $0.00 $1,700.00 0.00 %$1,700.00 NPDES IDDE 401-000-005-531-00-10-04 Salaries - NPDES IDDE $0.00 $0.00 $3,000.00 0.00 %$3,000.00 401-000-005-531-00-20-04 Benefits - NPDES IDDE $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-005-531-00-30-04 Supplies - NPDES IDDE $0.00 $0.00 $3,000.00 0.00 %$3,000.00 Total NPDES IDDE $0.00 $0.00 $7,000.00 0.00 %$7,000.00 NPDES Construction 401-000-006-531-00-10-05 Salaries - NPDES Construction $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-006-531-00-20-05 Benefits - NPDES Construction $0.00 $13.90 $600.00 2.32 %$586.10 Total NPDES Construction $0.00 $13.90 $2,100.00 0.66 %$2,086.10 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $0.00 $216.09 $1,500.00 14.41 %$1,283.91 23 of 27 Account Number Title Period Fiscal Budget % of Total Balance 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $0.00 $65.07 $600.00 10.85 %$534.93 Total NPDES Post Construction $0.00 $281.16 $2,100.00 13.39 %$1,818.84 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $7,044.87 $14,586.16 $73,000.00 19.98 %$58,413.84 401-000-008-531-00-10-08 Salaries - Sweeping $3,155.43 $7,158.95 $22,000.00 32.54 %$14,841.05 401-000-008-531-00-20-07 Benefits - NPDES PPGH $2,369.09 $6,735.37 $29,200.00 23.07 %$22,464.63 401-000-008-531-00-20-08 Benefits - Sweeping $1,476.37 $3,508.48 $11,000.00 31.90 %$7,491.52 401-000-008-531-00-30-05 Supplies - NPDES PPGH $0.00 $0.00 $20,000.00 0.00 %$20,000.00 401-000-008-531-00-30-06 Irrigation Supplies $0.00 $0.00 $3,000.00 0.00 %$3,000.00 401-000-008-531-00-30-07 Fuel $0.00 $88.59 $7,000.00 1.27 %$6,911.41 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $0.00 $1,241.73 $5,000.00 24.83 %$3,758.27 401-000-008-531-00-40-05 Rental Equipment $0.00 $0.00 $25,000.00 0.00 %$25,000.00 401-000-008-531-00-40-06 Utilities $160.80 $178.99 $5,000.00 3.58 %$4,821.01 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 $14,206.56 $33,498.27 $302,600.00 11.07 %$269,101.73 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 $4,578.23 $4,578.23 $100,000.00 4.58 %$95,421.77 401-000-012-594-31-60-05 Small Improvements Projects $0.00 $0.00 $25,000.00 0.00 %$25,000.00 401-000-013-531-00-40-08 Payment to Douglas Co. for PWTFL $0.00 $0.00 $76,000.00 0.00 %$76,000.00 401-000-014-531-00-40-07 Stormwater Comp Plan Update $19,593.91 $20,001.09 $70,000.00 28.57 %$49,998.91 Total Stormwater Fund $52,802.00 $90,622.36 $1,676,050.00 5.41 %$1,585,427.64 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $1,508.83 $3,136.57 $5,300.00 59.18 %$2,163.43 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $985.26 $1,908.26 $2,800.00 68.15 %$891.74 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $5,050.47 $14,021.09 $35,000.00 40.06 %$20,978.91 501-000-000-542-90-10-00 Street Vehicle Repair Labor $3,181.48 $9,544.38 $24,000.00 39.77 %$14,455.62 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $1,784.91 $4,732.58 $12,000.00 39.44 %$7,267.42 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $2,074.08 $4,869.84 $23,000.00 21.17 %$18,130.16 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $82.18 $183.57 $5,000.00 3.67 %$4,816.43 501-000-000-542-90-48-30 Street Equipment Repairs $13.22 $13.22 $1,500.00 0.88 %$1,486.78 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 $117,981.00 $176,000.00 67.03 %$58,019.00 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $0.00 $208,000.00 0.00 %$208,000.00 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $0.00 $15,000.00 0.00 %$15,000.00 24 of 27 Account Number Title Period Fiscal Budget % of Total Balance Total Equipment Purchase, Repair & Replacement Fund $14,680.43 $156,390.51 $512,100.00 30.54 %$355,709.49 Grand Totals $1,023,481.82 $2,606,881.79 $21,289,831.00 12.24 %$18,682,949.21 25 of 27 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $706,935.40 $1,873,746.34 $8,450,197.00 22.17 %$6,576,450.66 101-000-000-000-00-00-00 Street Fund $106,815.76 $254,493.29 $1,332,450.00 19.10 %$1,077,956.71 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $416.16 $74,764.00 0.56 %$74,347.84 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $0.00 $196,000.00 0.00 %$196,000.00 112-000-000-000-00-00-00 Library Fund $297.29 $657.08 $6,500.00 10.11 %$5,842.92 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $65,062.00 $75,186.00 $276,000.00 27.24 %$200,814.00 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $0.00 $25,000.00 0.00 %$25,000.00 117-000-000-000-00-00-00 Events Board Fund $8,958.64 $27,201.98 $143,570.00 18.95 %$116,368.02 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $0.00 $248,500.00 0.00 %$248,500.00 301-000-000-000-00-00-00 Street Improvements Fund $44,996.98 $105,234.75 $6,916,700.00 1.52 %$6,811,465.25 314-000-000-000-00-00-00 Capital Improvements Fund $22,933.32 $22,933.32 $1,432,000.00 1.60 %$1,409,066.68 401-000-000-000-00-00-00 Stormwater Fund $52,802.00 $90,622.36 $1,676,050.00 5.41 %$1,585,427.64 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $14,680.43 $156,390.51 $512,100.00 30.54 %$355,709.49 Grand Totals $1,023,481.82 $2,606,881.79 $21,289,831.00 12.24 %$18,682,949.21 26 of 27 Beginning Activity Activity Ending March 2020 Variance Cash In Out Cash Ending Cash (Decrease)/Increase 001 $3,338,907.76 $1,021,010.94 $1,873,766.34 $2,486,152.36 $2,429,331.91 $56,820.45 101 $248,197.36 $531,936.27 $256,023.29 $524,110.34 $360,810.38 $163,299.96 102 $40,324.38 $35,000.00 $416.16 $74,908.22 $78,245.47 ($3,337.25) 103 $13,494.91 $10,006.77 $0.00 $23,501.68 $0.00 $23,501.68 105 $433,896.56 $54,232.20 $0.00 $488,128.76 $387,277.58 $100,851.18 110 $0.00 $0.00 $0.00 $0.00 $660,000.00 ($660,000.00) 112 $14,744.33 $0.00 $657.08 $14,087.25 $10,367.19 $3,720.06 113 $162,733.87 $58,448.00 $75,186.00 $145,995.87 $94,679.80 $51,316.07 114 $1,537.63 $5.14 $0.00 $1,542.77 $1,519.81 $22.96 116 $2,870.61 $4,995.13 $0.00 $7,865.74 $51,973.88 ($44,108.14) 117 $18,767.92 $60,000.00 $27,201.98 $51,565.94 $77,139.34 ($25,573.40) 202 $775,826.60 $0.00 $0.00 $775,826.60 $8,668.69 $767,157.91 301 $262,409.25 $62,717.18 $105,234.75 $219,891.68 $940,651.09 ($720,759.41) 308 $0.00 $0.00 $0.00 $0.00 $66,049.25 ($66,049.25) 314 $1,362,383.49 $106,857.00 $22,933.32 $1,446,307.17 $1,264,171.30 $182,135.87 401 $2,166,740.88 $16,860.26 $90,668.60 $2,092,932.54 $2,396,037.51 ($303,104.97) 501 $39,111.03 $474,576.98 $156,390.51 $357,297.50 $350,969.05 $6,328.45 $8,881,946.58 $2,436,645.87 $2,608,478.03 $8,710,114.42 $9,177,892.25 ($467,777.83) Equipment Purchase, Repair & Replacement Fund Capital Improvements Fund Stormwater Fund Street Improvements Fund Storm Water Improvements Fund Events Board Fund Bond Redemption Fund Drug Fund Criminal Justice Fund Library Fund Hotel/Motel Tax Fund Transportation Benefit District Fund Financing Reserves Fund Community Development Grants Fund Affordable Housing Sales Tax Fund Street Fund General Fund Cash and Investment Activity Period: 2021 - March 2021 Fiscal Totals Fund 27 of 27