Loading...
HomeMy WebLinkAbout2021 - January 2021 Financial Report - Josh DeLay, Finance DirectorCity of East Wenatchee March 2, 2021 City Council Meeting January 2021 Financial Report Date: March 2, 2021 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: January 2021 Financial Report This report provides a summary of the City’s overall financial operations through January 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 January 31, 2021 compared to revenue collections through January 31, 2020, along with the respective dollar and percentage variances for its operating funds. Table 1 January 31, 2021 January 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 321,437 296,238 25,199 8.51% Street Fund - 101 130,703 173,928 (43,226) (24.85%) Events Board Fund - 117 - 75 (75) (100.00%) Equipment R&R Fund - 501 184,526 200,000 (15,474) (7.74%) Total Revenues - Operating Funds 636,665 670,242 (33,576) (5.01%) 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 March 2, 2021 City Council Meeting January 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 January 31, 2021 compared to revenue collections through January 31, 2020, along with the respective dollar and percentage variances for its non-operating funds. 2 of 27 City of East Wenatchee March 2, 2021 City Council Meeting January 2021 Financial Report Table 2 January 31, 2021 January 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - - - - Trans Benefit District Fund - 105 19,305 14,434 4,871 33.74% Library Fund - 112 - - - - Hotel/Motel Tax Fund - 113 16,007 21,331 (5,324) (24.96%) Drug Fund - 114 1 1 (0) (20.63%) Criminal Justice Fund - 116 4,995 4,770 225 4.73% Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 - 75,536 (75,536) (100.00%) Capital Improvements Fund - 314 59,721 121,407 (61,686) (50.81%) Storm Water Fund - 401 83 2,613,230 (2,613,147) (100.00%) Total Revenues - Non-Operating Funds 100,113 2,850,709 (2,750,597) (96.49%) 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 March 2, 2021 City Council Meeting January 2021 Financial Report Revenue Highlights: General Fund revenues are up $25,199, or 8.51%, year over year due to:  $100,000 increase in the sales tax allocation to this fund per normal year over year allocation variances; and a  $17,688 increase in criminal justice sales tax presumably because retail sales activity is up in Douglas County The above increases are offset by the following decreases year over year:  $72,864 decrease in gambling tax due to the timing of gambling tax filings; and a  $17,397 decrease in building & structure permits revenue presumably due to a decrease in the size and/or volume of construction activity within the City’s limits Street Fund revenues are down $43,226, or 24.85%, year over year due to $34,820 less sales tax allocation per normal year over year allocation variances. Gas tax is also down $5,263 presumably due to less driving because of COVID-19 restrictions. Hotel/Motel Tax Fund revenues are down $5,324, or 24.96%, year over year presumably due to a decrease in hotel stays in the City. Street Improvements Fund revenues are down $75,536 year over year due to the normal timing differences of projects associated with this fund. Capital Improvements Fund revenues are down $61,686, or 50.81%, 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,613,147 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 March 2, 2021 City Council Meeting January 2021 Financial Report Table 3 below shows the City’s expenditures through January 31, 2021 compared to expenditures through January 31, 2020, along with respective dollar and percentage variances for its operating funds. Table 3 January 31, 2021 January 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 584,001 516,785 67,217 13.01% Street Fund - 101 77,173 72,512 4,661 6.43% Events Board Fund - 117 9,356 10,690 (1,334) (12.48%) Equipment R&R Fund - 501 4,642 6,449 (1,807) (28.02%) Total Expenditures - Operating Funds 675,172 606,435 68,737 11.33% 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 March 2, 2021 City Council Meeting January 2021 Financial Report Table 4 below shows the City’s expenditures through January 31, 2021 compared to expenditures through January 31, 2020, along with respective dollar and percentage variances for its non-operating funds. Table 4 January 31, 2021 January 31, 2020 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - - - - Trans Benefit District Fund - 105 - - - - Library Fund - 112 - 358 (358) (100.00%) Hotel/Motel Tax Fund - 113 5,062 10,124 (5,062) (50.00%) Criminal Justice Fund - 116 - - - - Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 - 27,045 (27,045) (100.00%) Capital Improvements Fund - 314 - - - - Storm Water Fund - 401 15,584 9,524 6,060 63.63% Total Expenditures - Non-Operating Funds 20,646 47,051 (26,405) (56.12%) Expenditures - Non-Operating Funds Chart 4 is a graphical representation of year over year expenditure comparisons for the City’s non- operating funds. 6 of 27 City of East Wenatchee March 2, 2021 City Council Meeting January 2021 Financial Report Chart 4 Expenditure Highlights: General Fund expenditures are up $67,217, or 13.01%, year over year due to:  General overall salary and benefit increases; and a  $38,024 increase in jail services costs related to the timing of invoices; and a  $14,735 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 decrease:  $33,087 decrease in capital outlay costs for the Police Department due to the timing of purchases related to that line item 7 of 27 City of East Wenatchee March 2, 2021 City Council Meeting January 2021 Financial Report Street Fund expenditures are up $4,661, or 6.43%, year over year due to a $14,049 increase in fleet rental costs related to the new format of the City’s equipment rental fund Hotel/Motel Tax Fund expenditures are down $5,062, or 50%, year over year due to half of the funds appropriated for the Wenatchee Valley Museum now coming out of the General Fund. Street Improvements Fund expenditures are down $27,045 year over year due typical timing variances associated with the capital projects in this fund. Storm Water Fund expenditures are up $6,060, or 63.63%, year over year primarily due to a $4,741 increase in fleet rental costs related to the new format of the City’s equipment rental fund. The reports presented in the following pages represent accounting system generated line-item details of revenues, expenditures, budgets, and cash balances for each fund through January 31, 2021. 8 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 $9,823.46 $9,823.46 $1,318,200.00 0.75 %$1,308,376.54 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $100,000.00 $100,000.00 $3,306,000.00 3.02 %$3,206,000.00 001-000-000-313-27-00-00 Affordable & Supportive Housing Sales/Use Tax $3,135.66 $3,135.66 $0.00 ($3,135.66) 001-000-000-313-71-00-00 Criminal Justice Sales Tax $43,964.21 $43,964.21 $296,000.00 14.85 %$252,035.79 001-000-000-316-40-00-00 Electric Utility Tax $35,126.79 $35,126.79 $354,000.00 9.92 %$318,873.21 001-000-000-316-45-00-00 Natural Gas Utility Tax $5,163.66 $5,163.66 $35,000.00 14.75 %$29,836.34 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $14,326.28 $14,326.28 $360,000.00 3.98 %$345,673.72 001-000-000-316-84-00-00 Gambling Tax $0.00 $0.00 $317,000.00 0.00 %$317,000.00 Total Taxes $211,540.06 $211,540.06 $5,986,200.00 3.53 %$5,774,659.94 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 $387.00 $387.00 $800.00 48.38 %$413.00 001-000-000-321-91-00-50 Franchise Fees - Cable $4,000.00 $4,000.00 $91,000.00 4.40 %$87,000.00 001-000-000-321-99-00-00 Business Licenses & Permits $9,316.01 $9,316.01 $100,000.00 9.32 %$90,683.99 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 $3,378.66 $3,378.66 $60,000.00 5.63 %$56,621.34 001-000-000-322-90-01-00 Gun Permits $1,013.00 $1,013.00 $5,700.00 17.77 %$4,687.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,094.67 $18,094.67 $258,785.00 6.99 %$240,690.33 Intergovernmental Revenues 001-000-000-334-01-20-01 Washington Courts Funding $20,000.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 $428.82 $428.82 $2,500.00 17.15 %$2,071.18 001-000-000-334-06-91-00 WA ST Office of Public Defense $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-000-335-00-91-00 PUD Privilege Tax $0.00 $0.00 $43,000.00 0.00 %$43,000.00 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $0.00 $23,000.00 0.00 %$23,000.00 001-000-000-336-06-51-00 DUI - Cities Allocation $539.39 $539.39 $2,000.00 26.97 %$1,460.61 001-000-000-336-06-94-00 Liquor Excise Tax $22,004.78 $22,004.78 $77,000.00 28.58 %$54,995.22 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $0.00 $108,000.00 0.00 %$108,000.00         Total Intergovernmental Revenues $42,972.99 $42,972.99 $280,800.00 15.30 %$237,827.01         Charges for Goods and Services 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 - January 2021 9 of 27 Account Number Title Period Fiscal Budget % of Total Balance 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 $3,352.47 $3,352.47 $63,000.00 5.32 %$59,647.53 001-000-000-342-36-00-00 Housing of Prisoners $730.13 $730.13 $20,000.00 3.65 %$19,269.87 001-000-000-342-40-00-01 Fire Marshall Inspection Services $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-000-345-83-00-00 Plan Checking Fees $1,829.34 $1,829.34 $30,000.00 6.10 %$28,170.66 001-000-000-345-83-41-00 Engineering Review Fees $243.00 $243.00 $750.00 32.40 %$507.00 001-000-000-345-86-00-00 Sepa Permits $488.00 $488.00 $1,000.00 48.80 %$512.00 001-000-000-345-89-00-00 Planning & Development Fees $719.00 $719.00 $8,000.00 8.99 %$7,281.00         Total Charges for Goods and Services $7,361.94 $7,361.94 $133,070.00 5.53 %$125,708.06         Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $10,830.34 $10,830.34 $175,000.00 6.19 %$164,169.66 001-000-000-357-33-00-00 Public Defender Costs $443.31 $443.31 $23,000.00 1.93 %$22,556.69 001-000-000-357-35-00-00 Restitution $0.00 $0.00 $400.00 0.00 %$400.00 Total Fines and Penalties $11,273.65 $11,273.65 $198,400.00 5.68 %$187,126.35 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $1,039.61 $1,039.61 $90,000.00 1.16 %$88,960.39 001-000-000-361-40-00-00 Sales Tax Interest $343.94 $343.94 $5,700.00 6.03 %$5,356.06 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $0.00 $0.00 $12,000.00 0.00 %$12,000.00 001-000-000-369-91-50-00 Miscellaneous Revenue $0.00 $0.00 $7,000.00 0.00 %$7,000.00 Total Miscellaneous Revenues $1,383.55 $1,383.55 $114,700.00 1.21 %$113,316.45 Other Increases in Fund Resources 001-000-000-380-00-50-08 Storm Water Utility $6.50 $6.50 $0.00 ($6.50) 001-000-000-389-30-00-03 Fireworks - Cleaning Deposit $0.00 $0.00 $2,350.00 0.00 %$2,350.00 001-000-000-389-30-00-04 Fireworks - Dcfd Remittance $0.00 $0.00 $200.00 0.00 %$200.00 001-000-000-389-30-00-05 Crime Victim Assessment $179.97 $179.97 $3,200.00 5.62 %$3,020.03 001-000-000-389-30-00-10 State Surcharge $44.50 $44.50 $700.00 6.36 %$655.50 001-000-000-389-30-00-15 State Share Weapons Permit Fee $1,572.50 $1,572.50 $8,700.00 18.07 %$7,127.50 001-000-000-389-30-00-20 Court Remittance - State $11,551.07 $11,551.07 $175,000.00 6.60 %$163,448.93         Total Other Increases in Fund Resources $13,354.54 $13,354.54 $190,150.00 7.02 %$176,795.46         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 $15,455.45 $15,455.45 $0.00 ($15,455.45) Total Other Financing Sources $15,455.45 $15,455.45 $509,900.00 3.03 %$494,444.55 Total General Fund $321,436.85 $321,436.85 $7,672,005.00 4.19 %$7,350,568.15 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 $113,891.49 $113,891.49 $470,000.00 24.23 %$356,108.51 101-000-000-322-40-00-00 Street Permits $0.00 $0.00 $2,000.00 0.00 %$2,000.00 10 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 $16,811.33 $16,811.33 $275,000.00 6.11 %$258,188.67 101-000-000-336-00-87-05 Increased Gas Tax $0.00 $0.00 $16,000.00 0.00 %$16,000.00 Total Street Fund $130,702.82 $130,702.82 $1,281,000.00 10.20 %$1,150,297.18 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $0.00 $74,764.00 0.00 %$74,764.00 Total Community Development Grants Fund $0.00 $0.00 $74,764.00 0.00 %$74,764.00 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $19,305.00 $19,305.00 $0.00 ($19,305.00) Total Transportation Benefit District Fund $19,305.00 $19,305.00 $0.00 ($19,305.00) 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 $16,007.03 $16,007.03 $225,000.00 7.11 %$208,992.97 Total Hotel/Motel Tax Fund $16,007.03 $16,007.03 $225,000.00 7.11 %$208,992.97 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $0.99 $0.99 $100.00 0.99 %$99.01 Total Drug Fund $0.99 $0.99 $100.00 0.99 %$99.01 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $1,093.10 $1,093.10 $4,500.00 24.29 %$3,406.90 116-000-000-336-06-26-00 Criminal Justice - Special Programs $3,902.03 $3,902.03 $16,000.00 24.39 %$12,097.97 Total Criminal Justice Fund $4,995.13 $4,995.13 $20,500.00 24.37 %$15,504.87 Events Board Fund 117-000-100-397-00-00-00 Transfer-In from Fund 113 $0.00 $0.00 $120,000.00 0.00 %$120,000.00 117-000-300-347-40-12-02 Classy Chassis Parade/Car Show $0.00 $0.00 $9,000.00 0.00 %$9,000.00 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $0.00 $0.00 $150.00 0.00 %$150.00 117-000-300-347-90-00-12 Classy Chassis Sponsorships $0.00 $0.00 $8,000.00 0.00 %$8,000.00 117-000-300-347-90-12-00 Classy Chassis Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-347-40-11-03 Wings & Wheels Car Show Registration $0.00 $0.00 $4,500.00 0.00 %$4,500.00 117-000-400-347-40-11-07 Wings & Wheels Vendor Fees $0.00 $0.00 $100.00 0.00 %$100.00 117-000-400-347-90-00-11 Wings & Wheels Sponsorships $0.00 $0.00 $12,000.00 0.00 %$12,000.00 117-000-400-347-90-11-00 Wings & Wheels Merchandise Sales $0.00 $0.00 $500.00 0.00 %$500.00 117-000-500-367-19-00-01 Christmas Sponsorships $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Events Board Fund $0.00 $0.00 $156,750.00 0.00 %$156,750.00 Street Improvements Fund 301-000-000-330-00-00-00 GWID - 10th St. NE Improvements $0.00 $0.00 $298,534.00 0.00 %$298,534.00 301-000-000-333-20-00-13 STP 9th/VMP Intersection $0.00 $0.00 $825,000.00 0.00 %$825,000.00 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-334-03-60-01 SRTS - 5th St NE: Sterling $0.00 $0.00 $207,500.00 0.00 %$207,500.00 301-000-000-334-03-60-02 SRTS - 5th St NE: Kenroy $0.00 $0.00 $233,250.00 0.00 %$233,250.00 301-000-000-334-03-80-13 TIB N Kentucky Ave Overlay $0.00 $0.00 $675,750.00 0.00 %$675,750.00 301-000-000-334-03-80-15 TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $81,800.00 0.00 %$81,800.00 11 of 27 Account Number Title Period Fiscal Budget % of Total Balance 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-334-04-20-02 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 $0.00 $0.00 $6,968,476.00 0.00 %$6,968,476.00 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $59,721.28 $59,721.28 $400,000.00 14.93 %$340,278.72 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 $59,721.28 $59,721.28 $5,400,000.00 1.11 %$5,340,278.72 Stormwater Fund 401-000-000-334-03-10-01 19th St. Ecology Grant $0.00 $0.00 $50,000.00 0.00 %$50,000.00 401-000-000-334-03-10-02 Stormwater Comp Plan Ecology Grant $0.00 $0.00 $31,875.00 0.00 %$31,875.00 401-000-000-343-10-00-00 SWU Fee $81.00 $81.00 $520,000.00 0.02 %$519,919.00 401-000-000-361-40-00-00 Interest Earnings $2.10 $2.10 $0.00 ($2.10) Total Stormwater Fund $83.10 $83.10 $601,875.00 0.01 %$601,791.90 Equipment Purchase, Repair & Replacement Fund 501-000-000-313-11-00-10 Sales & Use Tax - Police $151,000.00 $151,000.00 $151,000.00 100.00 %$0.00 501-000-000-313-11-00-20 Sales & Use Tax - Streets $0.00 $0.00 $223,000.00 0.00 %$223,000.00 501-000-000-348-00-00-01 Police - Fleet Maintenance Rentals $14,735.42 $14,735.42 $177,000.00 8.33 %$162,264.58 501-000-000-348-00-00-02 Street - Fleet Maintenance Rentals $14,049.23 $14,049.23 $169,000.00 8.31 %$154,950.77 501-000-000-348-00-00-03 Stormwater - Fleet Maintenance Rentals $4,741.01 $4,741.01 $57,000.00 8.32 %$52,258.99 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 $184,525.66 $184,525.66 $802,000.00 23.01 %$617,474.34 Grand Totals $736,777.86 $736,777.86 $23,209,970.00 3.17 %$22,473,192.14 12 of 27 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $321,436.85 $321,436.85 $7,672,005.00 4.19 %$7,350,568.15 101-000-000-000-00-00-00 Street Fund $130,702.82 $130,702.82 $1,281,000.00 10.20 %$1,150,297.18 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $74,764.00 0.00 %$74,764.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $19,305.00 $19,305.00 $0.00 ($19,305.00) 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 $16,007.03 $16,007.03 $225,000.00 7.11 %$208,992.97 114-000-000-000-00-00-00 Drug Fund $0.99 $0.99 $100.00 0.99 %$99.01 116-000-000-000-00-00-00 Criminal Justice Fund $4,995.13 $4,995.13 $20,500.00 24.37 %$15,504.87 117-000-000-000-00-00-00 Events Board Fund $0.00 $0.00 $156,750.00 0.00 %$156,750.00 301-000-000-000-00-00-00 Street Improvements Fund $0.00 $0.00 $6,968,476.00 0.00 %$6,968,476.00 314-000-000-000-00-00-00 Capital Improvements Fund $59,721.28 $59,721.28 $5,400,000.00 1.11 %$5,340,278.72 401-000-000-000-00-00-00 Stormwater Fund $83.10 $83.10 $601,875.00 0.01 %$601,791.90 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $184,525.66 $184,525.66 $802,000.00 23.01 %$617,474.34 Grand Totals $736,777.86 $736,777.86 $23,209,970.00 3.17 %$22,473,192.14 13 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 $0.00 $0.00 $1,000.00 0.00 %$1,000.00 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 $2,227.50 $26,500.00 8.41 %$24,272.50 001-000-001-528-70-40-00 River Com $21,770.90 $21,770.90 $261,251.00 8.33 %$239,480.10 001-000-001-539-30-40-00 Animal Control $6,248.76 $6,248.76 $73,515.00 8.50 %$67,266.24 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $0.00 $14,500.00 0.00 %$14,500.00 001-000-001-558-70-40-00 Contributions - Region $0.00 $0.00 $25,000.00 0.00 %$25,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 $0.00 $1,500.00 0.00 %$1,500.00 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $0.00 $0.00 $500.00 0.00 %$500.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 $5,062.00 $61,000.00 8.30 %$55,938.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $0.00 $3,600.00 0.00 %$3,600.00 001-000-001-597-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,309.16 $35,309.16 $973,666.00 3.63 %$938,356.84 Legislative 001-000-110-511-60-10-00 Salaries $10,556.54 $10,556.54 $55,440.00 19.04 %$44,883.46 001-000-110-511-60-20-00 Benefits $2,695.11 $2,695.11 $4,500.00 59.89 %$1,804.89 001-000-110-511-60-21-50 Public Defender $11,350.00 $11,350.00 $135,000.00 8.41 %$123,650.00 001-000-110-511-60-30-00 Public Defender Conflicts $0.00 $0.00 $5,200.00 0.00 %$5,200.00 001-000-110-511-60-31-00 Office Supplies $0.00 $0.00 $650.00 0.00 %$650.00 001-000-110-511-60-40-00 Training $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-110-511-60-41-00 Professional Services $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-110-511-60-41-20 AWC Annual Membership Fee $10,089.00 $10,089.00 $9,989.00 101.00 %($100.00) 001-000-110-511-60-43-00 Travel $0.00 $0.00 $1,250.00 0.00 %$1,250.00 001-000-110-511-60-43-01 Travel - Misawa $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-110-511-60-44-00 Advertising $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-110-511-60-45-00 Election Costs - Registered Voters $0.00 $0.00 $25,000.00 0.00 %$25,000.00 001-000-110-511-60-46-00 Insurance $0.00 $0.00 $8,500.00 0.00 %$8,500.00 001-000-110-511-60-47-00 Background Check Costs $0.00 $0.00 $200.00 0.00 %$200.00 001-000-110-511-60-49-00 Miscellaneous $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Legislative $34,690.65 $34,690.65 $268,229.00 12.93 %$233,538.35 Mayor's Office 001-000-111-513-00-10-00 Salaries $2,148.08 $2,148.08 $97,000.00 2.21 %$94,851.92 Expenditure Starting Account Number: 001-000-001-518-20-40-00 Property Management - 311 9th St NE Ending Account Number: 501-001-000-508-80-00-00 Ending EPM&R Fund Balance - Unreserved Period: 2021 - January 2021 14 of 27 Account Number Title Period Fiscal Budget % of Total Balance 001-000-111-513-00-20-00 Benefits $1,064.57 $1,064.57 $26,000.00 4.09 %$24,935.43 001-000-111-513-00-30-00 Office Supplies $0.00 $0.00 $250.00 0.00 %$250.00 001-000-111-513-00-40-00 Newsletter Printing & Mailing $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-111-513-00-40-01 Training $0.00 $0.00 $2,500.00 0.00 %$2,500.00 001-000-111-513-00-40-02 Professional Services $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-111-513-00-40-03 Cell Phone $0.00 $0.00 $550.00 0.00 %$550.00 001-000-111-513-00-40-04 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-111-513-00-40-05 Insurance $0.00 $0.00 $8,500.00 0.00 %$8,500.00 001-000-111-513-00-40-06 Miscellaneous $0.00 $0.00 $250.00 0.00 %$250.00 Total Mayor's Office $3,212.65 $3,212.65 $176,050.00 1.82 %$172,837.35 Municipal Court 001-000-120-512-50-10-00 Salaries $19,195.86 $19,195.86 $262,000.00 7.33 %$242,804.14 001-000-120-512-50-12-00 Salaries - Probation Services $4,938.30 $4,938.30 $58,500.00 8.44 %$53,561.70 001-000-120-512-50-20-00 Benefits $6,115.35 $6,115.35 $89,000.00 6.87 %$82,884.65 001-000-120-512-50-22-00 Benefits - Probation Services $3,230.24 $3,230.24 $39,000.00 8.28 %$35,769.76 001-000-120-512-50-31-00 Office Supplies $0.00 $0.00 $3,500.00 0.00 %$3,500.00 001-000-120-512-50-40-00 Training $350.00 $350.00 $1,500.00 23.33 %$1,150.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 $0.00 $15,860.00 0.00 %$15,860.00 001-000-120-512-50-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-50-49-01 Interpreting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-120-512-50-49-02 Judge Protems $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-120-512-50-49-03 Witness Fees $0.00 $0.00 $500.00 0.00 %$500.00 001-000-120-512-50-49-04 Juror Fees $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-120-512-50-49-09 Security $306.25 $306.25 $6,000.00 5.10 %$5,693.75 001-000-120-594-12-60-00 Capital Outlay $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Municipal Court $34,136.00 $34,136.00 $501,065.00 6.81 %$466,929.00 Human Resources 001-000-139-518-10-10-00 Salaries $51.65 $51.65 $42,500.00 0.12 %$42,448.35 001-000-139-518-10-20-00 Benefits $23.20 $23.20 $19,000.00 0.12 %$18,976.80 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 $0.00 $0.00 $500.00 0.00 %$500.00 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 $0.00 $1,000.00 0.00 %$1,000.00 001-000-139-518-10-40-04 Insurance $0.00 $0.00 $3,500.00 0.00 %$3,500.00 001-000-139-518-10-40-05 Repairs & Maintenance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-139-518-10-40-06 Miscellaneous $0.00 $0.00 $250.00 0.00 %$250.00 Total Human Resources $74.85 $74.85 $69,500.00 0.11 %$69,425.15 City Clerk 001-000-140-514-20-10-00 Salaries $11,389.68 $11,389.68 $97,500.00 11.68 %$86,110.32 001-000-140-514-20-20-00 Benefits $6,013.52 $6,013.52 $50,800.00 11.84 %$44,786.48 001-000-140-514-20-31-00 Office Supplies $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-140-514-20-31-01 Central Stores $0.00 $0.00 $5,500.00 0.00 %$5,500.00 15 of 27 Account Number Title Period Fiscal Budget % of Total Balance 001-000-140-514-20-40-00 Training $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-140-514-20-41-00 Membership Dues & Publications $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-140-514-20-43-00 Travel $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-140-514-20-44-00 Advertising $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-140-514-20-46-00 Insurance $0.00 $0.00 $7,300.00 0.00 %$7,300.00 001-000-140-514-20-48-00 Repairs & Maintenance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-140-514-20-48-01 Fireworks - DCFD Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-140-514-20-49-00 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 001-000-140-514-30-20-00 Records Services $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-140-514-30-25-00 Codification $0.00 $0.00 $2,100.00 0.00 %$2,100.00 001-000-140-582-10-40-00 Fireworks - Deposit Refund $0.00 $0.00 $2,300.00 0.00 %$2,300.00 Total City Clerk $17,403.20 $17,403.20 $178,000.00 9.78 %$160,596.80 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $0.00 $0.00 $12,500.00 0.00 %$12,500.00 001-000-141-514-20-42-01 Telephone Line Charges $1,388.50 $1,388.50 $14,000.00 9.92 %$12,611.50 001-000-141-514-20-42-03 Postage $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-141-514-20-48-00 Repairs & Maintenance $108.30 $108.30 $4,000.00 2.71 %$3,891.70 Total Internal Services $1,496.80 $1,496.80 $36,500.00 4.10 %$35,003.20 Finance 001-000-142-514-20-10-00 Salaries $14,700.97 $14,700.97 $169,000.00 8.70 %$154,299.03 001-000-142-514-20-20-00 Benefits $6,156.15 $6,156.15 $70,000.00 8.79 %$63,843.85 001-000-142-514-20-31-00 Office Supplies $0.00 $0.00 $1,600.00 0.00 %$1,600.00 001-000-142-514-20-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 001-000-142-514-20-46-00 Insurance $0.00 $0.00 $12,282.00 0.00 %$12,282.00 001-000-142-514-23-20-00 State Audit $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-142-514-25-30-00 Bank Charges & Fees $340.09 $340.09 $4,500.00 7.56 %$4,159.91 001-000-142-514-40-20-00 Training $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Total Finance $21,197.21 $21,197.21 $289,382.00 7.32 %$268,184.79 Information Technology 001-000-145-514-20-10-00 Salaries $8,209.14 $8,209.14 $98,100.00 8.37 %$89,890.86 001-000-145-514-20-20-00 Benefits $3,890.21 $3,890.21 $45,500.00 8.55 %$41,609.79 001-000-145-514-20-31-00 Supplies $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-145-514-20-40-01 Memberships $0.00 $0.00 $100.00 0.00 %$100.00 001-000-145-514-20-40-05 Disaster Backup System Support $0.00 $0.00 $16,000.00 0.00 %$16,000.00 001-000-145-514-20-40-10 Annual Fee - GIS Systems $0.00 $0.00 $10,100.00 0.00 %$10,100.00 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $0.00 $0.00 $23,000.00 0.00 %$23,000.00 001-000-145-514-20-40-25 Annual License - Municipal Court $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $6,085.00 $6,085.00 $7,000.00 86.93 %$915.00 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-145-514-20-40-40 Annual Subscription - Website $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-145-514-20-40-50 Annual License - FTR Recording System $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-145-514-20-40-51 Annual License - Electronic Archive (Smarsh & Archive Social) $2,396.36 $2,396.36 $7,500.00 31.95 %$5,103.64 16 of 27 Account Number Title Period Fiscal Budget % of Total Balance 001-000-145-514-20-40-55 Annual Support & Maintenance - Laserfiche $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $0.00 $0.00 $8,000.00 0.00 %$8,000.00 001-000-145-514-20-41-00 Professional Services $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-145-514-20-42-00 Cell Phone $0.00 $0.00 $850.00 0.00 %$850.00 001-000-145-514-20-43-00 Training $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-145-514-20-44-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-145-514-20-45-00 Insurance $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-145-594-14-60-20 Capital - PC Software Admin $0.00 $0.00 $33,000.00 0.00 %$33,000.00 001-000-145-594-14-60-25 Capital - PC Hardware Admin $0.00 $0.00 $32,000.00 0.00 %$32,000.00 Total Information Technology $20,580.71 $20,580.71 $334,650.00 6.15 %$314,069.29 Legal 001-000-151-515-31-10-00 Salaries $14,643.09 $14,643.09 $175,000.00 8.37 %$160,356.91 001-000-151-515-31-20-00 Benefits $6,217.29 $6,217.29 $72,000.00 8.64 %$65,782.71 001-000-151-515-31-20-10 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-151-515-31-25-00 Professional Services $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-151-515-31-25-10 Licensing $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-151-515-31-31-00 Office Supplies $0.00 $0.00 $200.00 0.00 %$200.00 001-000-151-515-31-40-01 Legal Research $0.00 $0.00 $1,200.00 0.00 %$1,200.00 001-000-151-515-31-40-02 Membership Dues $0.00 $0.00 $30.00 0.00 %$30.00 001-000-151-515-31-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 001-000-151-515-31-46-00 Insurance $0.00 $0.00 $11,280.00 0.00 %$11,280.00 001-000-151-515-31-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Legal $20,860.38 $20,860.38 $284,210.00 7.34 %$263,349.62 Legal - Public Records 001-000-152-515-31-10-00 Salaries $2,028.23 $2,028.23 $25,000.00 8.11 %$22,971.77 001-000-152-515-31-20-00 Benefits $831.18 $831.18 $11,000.00 7.56 %$10,168.82 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 $0.00 $2,820.00 0.00 %$2,820.00 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.41 $2,859.41 $45,145.00 6.33 %$42,285.59 Civil Service 001-000-160-521-10-10-00 Salaries $0.00 $0.00 $3,300.00 0.00 %$3,300.00 001-000-160-521-10-46-00 Insurance $0.00 $0.00 $8,100.00 0.00 %$8,100.00 Total Civil Service $0.00 $0.00 $11,400.00 0.00 %$11,400.00 Central Services 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-180-518-30-35-00 Small Tools & Equipment $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-180-518-30-41-00 Professional Services $0.00 $0.00 $25,000.00 0.00 %$25,000.00 001-000-180-518-30-41-01 Contracted Custodial Services $0.00 $0.00 $32,000.00 0.00 %$32,000.00 001-000-180-518-30-46-00 Insurance $0.00 $0.00 $52,000.00 0.00 %$52,000.00 17 of 27 Account Number Title Period Fiscal Budget % of Total Balance 001-000-180-518-30-47-00 Utilities $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-180-518-30-48-00 Repairs & Maintenance $0.00 $0.00 $15,000.00 0.00 %$15,000.00 001-000-180-518-30-49-00 Miscellaneous $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-180-518-30-49-01 Landscaping $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$352.50 $352.50 $9,000.00 3.92 %$8,647.50 001-000-180-594-18-60-00 Capital Outlay $0.00 $0.00 $5,000.00 0.00 %$5,000.00 Total Central Services $352.50 $352.50 $186,000.00 0.19 %$185,647.50 Law Enforcement 001-000-210-521-10-10-00 Salaries $180,888.92 $180,888.92 $2,230,000.00 8.11 %$2,049,111.08 001-000-210-521-10-10-02 Overtime - Shift Coverage $18,142.52 $18,142.52 $140,000.00 12.96 %$121,857.48 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 $79,079.18 $79,079.18 $841,000.00 9.40 %$761,920.82 001-000-210-521-10-20-01 Clothing Allowance $0.00 $0.00 $14,400.00 0.00 %$14,400.00 001-000-210-521-10-31-00 Office Supplies $0.00 $0.00 $8,500.00 0.00 %$8,500.00 001-000-210-521-10-31-05 Office Machine Costs $0.00 $0.00 $5,000.00 0.00 %$5,000.00 001-000-210-521-10-32-00 Fuel Consumed $0.00 $0.00 $55,000.00 0.00 %$55,000.00 001-000-210-521-10-35-00 Small Tools & Equipment $1,687.93 $1,687.93 $23,250.00 7.26 %$21,562.07 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 $71.37 $71.37 $15,000.00 0.48 %$14,928.63 001-000-210-521-10-41-01 Emergency Management Contract $10,442.40 $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 $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-210-521-10-42-03 Postage $0.00 $0.00 $1,175.00 0.00 %$1,175.00 001-000-210-521-10-43-00 Travel $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-210-521-10-46-00 Insurance $0.00 $0.00 $71,000.00 0.00 %$71,000.00 001-000-210-521-10-48-00 Repairs & Maintenance $0.00 $0.00 $9,500.00 0.00 %$9,500.00 001-000-210-521-10-49-00 Miscellaneous $75.00 $75.00 $1,000.00 7.50 %$925.00 001-000-210-521-10-49-02 Dry Cleaning Services $0.00 $0.00 $1,000.00 0.00 %$1,000.00 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 $14,735.42 $177,000.00 8.33 %$162,264.58 001-000-210-594-21-60-00 Capital Outlay $84.21 $84.21 $33,000.00 0.26 %$32,915.79 Total Law Enforcement $305,206.95 $305,206.95 $3,788,375.00 8.06 %$3,483,168.05 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $38,024.02 $38,024.02 $456,500.00 8.33 %$418,475.98 001-000-230-523-60-20-00 Medical Care - Prisoners $0.00 $0.00 $9,000.00 0.00 %$9,000.00 18 of 27 Account Number Title Period Fiscal Budget % of Total Balance 001-000-230-527-60-30-00 Juvenile Detention $0.00 $0.00 $7,500.00 0.00 %$7,500.00 Total Jail Services $38,024.02 $38,024.02 $473,000.00 8.04 %$434,975.98 Public Works 001-000-315-542-10-10-00 Salaries $8,064.90 $8,064.90 $81,500.00 9.90 %$73,435.10 001-000-315-542-10-20-00 Benefits $3,844.09 $3,844.09 $37,500.00 10.25 %$33,655.91 001-000-315-542-10-31-00 Office Supplies $0.00 $0.00 $750.00 0.00 %$750.00 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-542-10-40-00 Cell Phone $0.00 $0.00 $750.00 0.00 %$750.00 001-000-315-542-10-43-00 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-46-00 Insurance $0.00 $0.00 $13,000.00 0.00 %$13,000.00 001-000-315-542-10-49-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-315-542-10-49-01 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-315-542-10-49-10 Memberships $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-544-20-45-00 Engineering Support Services $0.00 $0.00 $15,000.00 0.00 %$15,000.00 Total Public Works $11,908.99 $11,908.99 $153,500.00 7.76 %$141,591.01 Planning 001-000-580-558-60-10-00 Salaries $16,707.13 $16,707.13 $190,000.00 8.79 %$173,292.87 001-000-580-558-60-20-00 Benefits $5,444.76 $5,444.76 $62,000.00 8.78 %$56,555.24 001-000-580-558-60-31-00 Office Supplies $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-580-558-60-32-00 Fuel Consumed $0.00 $0.00 $175.00 0.00 %$175.00 001-000-580-558-60-35-00 Small Tools & Equipment $0.00 $0.00 $100.00 0.00 %$100.00 001-000-580-558-60-40-00 Training $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-580-558-60-40-01 Dues & Subscriptions $0.00 $0.00 $1,250.00 0.00 %$1,250.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 $0.00 $3,000.00 0.00 %$3,000.00 001-000-580-558-60-46-00 Insurance $0.00 $0.00 $13,440.00 0.00 %$13,440.00 001-000-580-558-60-48-00 Repairs & Maintenance $0.00 $0.00 $100.00 0.00 %$100.00 001-000-580-558-60-49-00 Miscellaneous $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total Planning $22,151.89 $22,151.89 $302,165.00 7.33 %$280,013.11 Code Compliance 001-000-590-558-50-10-00 Salaries $9,829.94 $9,829.94 $109,000.00 9.02 %$99,170.06 001-000-590-558-50-20-00 Benefits $4,360.37 $4,360.37 $53,000.00 8.23 %$48,639.63 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 $0.00 $400.00 0.00 %$400.00 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 $0.00 $275.00 0.00 %$275.00 001-000-590-558-50-41-01 Fire Marshal Services $0.00 $0.00 $22,145.00 0.00 %$22,145.00 001-000-590-558-50-42-00 Abatement $0.00 $0.00 $15,000.00 0.00 %$15,000.00 001-000-590-558-50-43-00 Travel $0.00 $0.00 $300.00 0.00 %$300.00 001-000-590-558-50-46-00 Insurance $0.00 $0.00 $10,690.00 0.00 %$10,690.00 001-000-590-558-50-48-00 Repairs & Maintenance $0.00 $0.00 $1,000.00 0.00 %$1,000.00 19 of 27 Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-49-00 Miscellaneous $0.00 $0.00 $150.00 0.00 %$150.00 Total Code Compliance $14,190.31 $14,190.31 $212,660.00 6.67 %$198,469.69           Other Expenditures 001-001-000-589-30-00-03 Fireworks - Deposit Refund $0.00 $0.00 $2,300.00 0.00 %$2,300.00 001-001-000-589-30-00-04 Fireworks - DCFD Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-001-000-589-30-00-05 County Share of Crime Victims $0.00 $0.00 $3,500.00 0.00 %$3,500.00 001-001-000-589-30-00-10 Remittance: State Building Code Surcharge $0.00 $0.00 $650.00 0.00 %$650.00 001-001-000-589-30-00-15 State Share of Permits & Licenses $345.75 $345.75 $10,000.00 3.46 %$9,654.25 001-001-000-589-30-00-20 Court Remittances $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Other Expenditures $345.75 $345.75 $166,700.00 0.21 %$166,354.25 Total General Fund $584,001.43 $584,001.43 $8,450,197.00 6.91 %$7,866,195.57 Street Fund 101-000-420-542-30-10-00 Salaries - Roadway $687.90 $687.90 $64,500.00 1.07 %$63,812.10 101-000-420-542-30-20-00 Benefits - Roadway ($857.90)($857.90)$34,000.00 -2.52 %$34,857.90 101-000-420-542-30-30-00 Supplies - Roadway $0.00 $0.00 $50,000.00 0.00 %$50,000.00 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $0.00 $4,500.00 0.00 %$4,500.00 101-000-420-542-61-20-00 Benefits - Sidewalks $3.15 $3.15 $2,400.00 0.13 %$2,396.85 101-000-420-542-61-30-00 Supplies - Sidewalks $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-420-542-61-48-00 Repairs & Maintenance - Sidewalks $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-62-10-00 Salaries - Special Purpose Paths $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $36.41 $36.41 $1,000.00 3.64 %$963.59 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 $632.33 $632.33 $2,000.00 31.62 %$1,367.67 101-000-420-542-63-20-00 Benefits - Street Lighting $586.05 $586.05 $1,200.00 48.84 %$613.95 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 $0.00 $0.00 $60,000.00 0.00 %$60,000.00 101-000-420-542-63-48-00 Repairs & Maintenance - Street Lighting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $453.05 $453.05 $35,000.00 1.29 %$34,546.95 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $268.83 $268.83 $18,600.00 1.45 %$18,331.17 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $12.01 $12.01 $48,000.00 0.03 %$47,987.99 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $0.00 $0.00 $9,000.00 0.00 %$9,000.00 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $0.00 $0.00 $14,000.00 0.00 %$14,000.00 101-000-420-542-65-10-00 Salaries - Parking Facilities $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-65-20-00 Benefits - Parking Facilities $0.00 $0.00 $500.00 0.00 %$500.00 101-000-420-542-65-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 $5,420.40 $5,420.40 $60,000.00 9.03 %$54,579.60 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $3,710.31 $3,710.31 $35,000.00 10.60 %$31,289.69 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $0.00 $0.00 $100,000.00 0.00 %$100,000.00 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-69-10-00 Salaries - Flags/Banners $657.23 $657.23 $20,000.00 3.29 %$19,342.77 101-000-420-542-69-20-00 Benefits - Flags/Banners $219.41 $219.41 $12,000.00 1.83 %$11,780.59 101-000-420-542-69-30-00 Supplies - Flags/Banners $0.00 $0.00 $2,000.00 0.00 %$2,000.00 20 of 27 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-70-10-00 Salaries - Roadside $24,444.04 $24,444.04 $240,000.00 10.19 %$215,555.96 101-000-420-542-70-20-00 Benefits - Roadside $14,803.19 $14,803.19 $130,000.00 11.39 %$115,196.81 101-000-420-542-70-30-00 Supplies - Roadside $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-70-41-00 Professional Services - Roadside $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-70-47-00 Utilities - Roadside $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-70-48-00 Repairs & Maintenance - Roadside $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-420-542-75-10-00 Salaries - City Parks $4,091.23 $4,091.23 $45,000.00 9.09 %$40,908.77 101-000-420-542-75-20-00 Benefits - City Parks $2,816.59 $2,816.59 $23,000.00 12.25 %$20,183.41 101-000-420-542-75-30-00 Supplies - City Parks $433.19 $433.19 $15,000.00 2.89 %$14,566.81 101-000-420-542-75-47-00 Utilities - City Parks $0.00 $0.00 $5,000.00 0.00 %$5,000.00 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $0.00 $0.00 $4,000.00 0.00 %$4,000.00 101-000-430-543-30-10-00 Salaries - General Services $2,819.43 $2,819.43 $0.00 ($2,819.43) 101-000-430-543-30-20-00 Benefits - General Services $817.60 $817.60 $0.00 ($817.60) 101-000-430-543-30-30-00 Supplies - General Services $0.00 $0.00 $6,000.00 0.00 %$6,000.00 101-000-430-543-30-46-00 Insurance $0.00 $0.00 $55,000.00 0.00 %$55,000.00 101-000-430-543-30-49-00 Miscellaneous - General Services $695.00 $695.00 $3,000.00 23.17 %$2,305.00 101-000-430-543-50-10-00 Salaries - Facilities $52.78 $52.78 $4,000.00 1.32 %$3,947.22 101-000-430-543-50-20-00 Benefits - Facilities $36.54 $36.54 $1,800.00 2.03 %$1,763.46 101-000-430-543-50-30-00 Supplies - Facilities $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-430-543-50-42-01 Cell Phone $0.00 $0.00 $750.00 0.00 %$750.00 101-000-430-543-50-47-00 Utilities - Facilities $0.00 $0.00 $6,500.00 0.00 %$6,500.00 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 $155.08 $155.08 $7,000.00 2.22 %$6,844.92 101-000-430-544-90-20-00 Benefits - Training $129.45 $129.45 $3,500.00 3.70 %$3,370.55 101-000-430-544-90-30-00 Supplies - Training $0.00 $0.00 $500.00 0.00 %$500.00 101-000-430-544-90-35-00 Travel $0.00 $0.00 $4,000.00 0.00 %$4,000.00 101-000-430-544-90-49-01 Training $0.00 $0.00 $1,000.00 0.00 %$1,000.00 101-000-430-548-60-40-00 Fleet Rentals - Streets $14,049.23 $14,049.23 $169,000.00 8.31 %$154,950.77 Total Street Fund $77,172.53 $77,172.53 $1,332,450.00 5.79 %$1,255,277.47 Community Development Grants Fund 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $0.00 $72,164.00 0.00 %$72,164.00 102-000-000-558-70-44-00 CDBG Advertising $0.00 $0.00 $1,800.00 0.00 %$1,800.00 102-000-000-558-70-45-00 CDBG Travel $0.00 $0.00 $700.00 0.00 %$700.00 102-000-000-558-70-49-00 CDBG Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Community Development Grants Fund $0.00 $0.00 $74,764.00 0.00 %$74,764.00 Transportation Benefit District Fund 105-000-000-595-90-61-00 Pavement Ratings $0.00 $0.00 $6,000.00 0.00 %$6,000.00 105-000-000-597-91-00-00 Transfer-Out to Fund 301 $0.00 $0.00 $190,000.00 0.00 %$190,000.00 Total Transportation Benefit District Fund $0.00 $0.00 $196,000.00 0.00 %$196,000.00 Library Fund 112-000-000-572-50-47-00 Facilities - Utilities $0.00 $0.00 $6,500.00 0.00 %$6,500.00 Total Library Fund $0.00 $0.00 $6,500.00 0.00 %$6,500.00 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 21 of 27 Account Number Title Period Fiscal Budget % of Total Balance 113-000-000-557-30-41-15 Wenatchee Valley Museum & CC $5,062.00 $5,062.00 $61,000.00 8.30 %$55,938.00 113-001-000-597-00-00-01 Transfer-Out to Fund 117 $0.00 $0.00 $120,000.00 0.00 %$120,000.00 Total Hotel/Motel Tax Fund $5,062.00 $5,062.00 $276,000.00 1.83 %$270,938.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 $6,524.46 $6,524.46 $60,000.00 10.87 %$53,475.54 117-000-050-557-30-20-00 Benefits $2,831.65 $2,831.65 $29,000.00 9.76 %$26,168.35 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $0.00 $3,000.00 0.00 %$3,000.00 117-000-100-557-30-32-00 Fuel $0.00 $0.00 $200.00 0.00 %$200.00 117-000-100-557-30-40-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-100-557-30-41-00 Professional Services $0.00 $0.00 $600.00 0.00 %$600.00 117-000-100-557-30-42-00 Cell Phone $0.00 $0.00 $760.00 0.00 %$760.00 117-000-100-557-30-43-00 Travel $0.00 $0.00 $500.00 0.00 %$500.00 117-000-100-557-30-44-00 Advertising $0.00 $0.00 $500.00 0.00 %$500.00 117-000-105-557-30-40-00 Insurance $0.00 $0.00 $10,360.00 0.00 %$10,360.00 117-000-115-557-30-31-05 Office Supplies $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-300-557-30-31-12 Classy Chassis Office Supplies $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-300-557-30-34-11 Classy Chassis Event Merch For Resale $0.00 $0.00 $2,500.00 0.00 %$2,500.00 117-000-300-557-30-41-12 CC - Professional Services $0.00 $0.00 $2,300.00 0.00 %$2,300.00 117-000-300-557-30-42-14 CC - Postage $0.00 $0.00 $800.00 0.00 %$800.00 117-000-300-557-30-43-12 CC - EMPD Facility Fee $0.00 $0.00 $1,500.00 0.00 %$1,500.00 117-000-300-557-30-44-12 CC - Advertising $0.00 $0.00 $3,000.00 0.00 %$3,000.00 117-000-300-557-30-49-12 CC - Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 117-000-400-557-30-31-11 Wings & Wheels Office Supplies $0.00 $0.00 $700.00 0.00 %$700.00 117-000-400-557-30-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 $0.00 $5,000.00 0.00 %$5,000.00 117-000-500-557-30-41-01 Christmas - Professional Services $0.00 $0.00 $400.00 0.00 %$400.00 117-000-500-557-30-44-01 Christmas - Advertising $0.00 $0.00 $750.00 0.00 %$750.00 117-000-500-557-30-49-01 Christmas - Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Events Board Fund $9,356.11 $9,356.11 $143,570.00 6.52 %$134,213.89 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 22 of 27 Account Number Title Period Fiscal Budget % of Total Balance 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 $0.00 $0.00 $155,000.00 0.00 %$155,000.00 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $0.00 $0.00 $170,000.00 0.00 %$170,000.00 301-000-000-595-10-40-26 Design - PWTFL - 10th St $0.00 $0.00 $55,000.00 0.00 %$55,000.00 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-64-40-01 Design - 9th/VMP Intersection $0.00 $0.00 $71,000.00 0.00 %$71,000.00 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 $0.00 $0.00 $6,916,700.00 0.00 %$6,916,700.00 Capital Improvements Fund 314-000-000-594-22-60-50 Maintenance Facilities Design $0.00 $0.00 $182,000.00 0.00 %$182,000.00 314-000-000-594-48-60-00 Maintenance Facilities Construction $0.00 $0.00 $1,000,000.00 0.00 %$1,000,000.00 314-001-000-597-00-00-01 Transfer-Out to 301 Fund $0.00 $0.00 $250,000.00 0.00 %$250,000.00 Total Capital Improvements Fund $0.00 $0.00 $1,432,000.00 0.00 %$1,432,000.00 Stormwater Fund 401-000-000-597-00-00-00 Transfer-Out - Fund 301 $0.00 $0.00 $728,000.00 0.00 %$728,000.00 Stormwater Utility Admin 401-000-001-531-00-10-00 Salaries - Stormwater Admin $1,840.32 $1,840.32 $30,000.00 6.13 %$28,159.68 401-000-001-531-00-20-00 Benefits - Stormwater Admin $686.30 $686.30 $13,200.00 5.20 %$12,513.70 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 $0.00 $0.00 $750.00 0.00 %$750.00 401-000-001-531-00-40-01 Fee Collection - Douglas Co.$0.00 $0.00 $8,500.00 0.00 %$8,500.00 401-000-001-531-00-40-02 Insurance $0.00 $0.00 $6,500.00 0.00 %$6,500.00 401-000-001-531-00-40-03 City Stormwater Utility Charge $0.00 $0.00 $165,000.00 0.00 %$165,000.00 401-000-001-531-00-40-04 Miscellaneous $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-531-00-40-05 Training - Stormwater Admin $0.00 $0.00 $1,000.00 0.00 %$1,000.00 23 of 27 Account Number Title Period Fiscal Budget % of Total Balance 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 $4,741.01 $70,000.00 6.77 %$65,258.99 Total Stormwater Utility Admin $7,267.63 $7,267.63 $297,450.00 2.44 %$290,182.37 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $1,706.07 $1,706.07 $25,000.00 6.82 %$23,293.93 401-000-002-531-00-20-01 Benefits - NPDES Admin $572.79 $572.79 $11,000.00 5.21 %$10,427.21 401-000-002-531-00-40-00 Training - NPDES Admin $0.00 $0.00 $500.00 0.00 %$500.00 401-000-002-531-00-40-02 Repairs & Maint. - NPDES Admin $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-002-531-00-40-03 Aerial Pictometry - NPDES Admin $0.00 $0.00 $4,000.00 0.00 %$4,000.00 401-000-002-531-00-40-04 Municipal Stormwater Permit Fee $0.00 $0.00 $8,000.00 0.00 %$8,000.00 Total NPDES Admin $2,278.86 $2,278.86 $49,500.00 4.60 %$47,221.14 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 $13.90 $13.90 $600.00 2.32 %$586.10 Total NPDES Construction $13.90 $13.90 $2,100.00 0.66 %$2,086.10 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $152.11 $152.11 $1,500.00 10.14 %$1,347.89 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $32.41 $32.41 $600.00 5.40 %$567.59 Total NPDES Post Construction $184.52 $184.52 $2,100.00 8.79 %$1,915.48 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $3,088.49 $3,088.49 $73,000.00 4.23 %$69,911.51 401-000-008-531-00-10-08 Salaries - Sweeping $456.09 $456.09 $22,000.00 2.07 %$21,543.91 401-000-008-531-00-20-07 Benefits - NPDES PPGH $2,001.12 $2,001.12 $29,200.00 6.85 %$27,198.88 401-000-008-531-00-20-08 Benefits - Sweeping $324.13 $324.13 $11,000.00 2.95 %$10,675.87 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 $0.00 $7,000.00 0.00 %$7,000.00 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH ($30.84)($30.84)$5,000.00 -0.62 %$5,030.84 401-000-008-531-00-40-05 Rental Equipment $0.00 $0.00 $25,000.00 0.00 %$25,000.00 24 of 27 Account Number Title Period Fiscal Budget % of Total Balance 401-000-008-531-00-40-06 Utilities $0.00 $0.00 $5,000.00 0.00 %$5,000.00 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 $5,838.99 $5,838.99 $302,600.00 1.93 %$296,761.01 NPDES Monitoring 401-000-009-531-00-10-09 Salaries - NPDES Monitoring $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-009-531-00-20-09 Benefits - NPDES Monitoring $0.00 $0.00 $400.00 0.00 %$400.00 401-000-009-531-00-30-06 Supplies - NPDES Monitoring $0.00 $0.00 $100.00 0.00 %$100.00 Total NPDES Monitoring $0.00 $0.00 $1,500.00 0.00 %$1,500.00 Capital Outlay 401-000-010-594-31-60-03 Devon Pond $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Capital Outlay $0.00 $0.00 $10,000.00 0.00 %$10,000.00 401-000-011-594-31-60-04 19th Stormwater Facility Design $0.00 $0.00 $100,000.00 0.00 %$100,000.00 401-000-012-594-31-60-05 Small Improvements Projects $0.00 $0.00 $25,000.00 0.00 %$25,000.00 401-000-013-531-00-40-08 Payment to Douglas Co. for PWTFL $0.00 $0.00 $76,000.00 0.00 %$76,000.00 401-000-014-531-00-40-07 Stormwater Comp Plan Update $0.00 $0.00 $70,000.00 0.00 %$70,000.00 Total Stormwater Fund $15,583.90 $15,583.90 $1,676,050.00 0.93 %$1,660,466.10 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $172.45 $172.45 $5,300.00 3.25 %$5,127.55 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $83.80 $83.80 $2,800.00 2.99 %$2,716.20 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $140.86 $140.86 $35,000.00 0.40 %$34,859.14 501-000-000-542-90-10-00 Street Vehicle Repair Labor $2,663.75 $2,663.75 $24,000.00 11.10 %$21,336.25 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $1,307.16 $1,307.16 $12,000.00 10.89 %$10,692.84 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $273.56 $273.56 $23,000.00 1.19 %$22,726.44 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $0.00 $0.00 $5,000.00 0.00 %$5,000.00 501-000-000-542-90-48-30 Street Equipment Repairs $0.00 $0.00 $1,500.00 0.00 %$1,500.00 501-000-000-548-60-10-00 Stormwater Vehicle R & M Labor $0.00 $0.00 $2,000.00 0.00 %$2,000.00 501-000-000-548-60-20-00 Stormwater Vehicle R & M Benefits $0.00 $0.00 $1,000.00 0.00 %$1,000.00 501-000-000-548-60-30-00 Stormwater Vehicle R & M $0.00 $0.00 $1,500.00 0.00 %$1,500.00 501-000-000-594-21-60-00 Capital - Police Vehicles $0.00 $0.00 $176,000.00 0.00 %$176,000.00 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $0.00 $208,000.00 0.00 %$208,000.00 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $0.00 $15,000.00 0.00 %$15,000.00 Total Equipment Purchase, Repair & Replacement Fund $4,641.58 $4,641.58 $512,100.00 0.91 %$507,458.42 Grand Totals $695,817.55 $695,817.55 $21,289,831.00 3.27 %$20,594,013.45 25 of 27 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $584,001.43 $584,001.43 $8,450,197.00 6.91 %$7,866,195.57 101-000-000-000-00-00-00 Street Fund $77,172.53 $77,172.53 $1,332,450.00 5.79 %$1,255,277.47 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $74,764.00 0.00 %$74,764.00 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 $0.00 $0.00 $6,500.00 0.00 %$6,500.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $5,062.00 $5,062.00 $276,000.00 1.83 %$270,938.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 $9,356.11 $9,356.11 $143,570.00 6.52 %$134,213.89 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 $0.00 $0.00 $6,916,700.00 0.00 %$6,916,700.00 314-000-000-000-00-00-00 Capital Improvements Fund $0.00 $0.00 $1,432,000.00 0.00 %$1,432,000.00 401-000-000-000-00-00-00 Stormwater Fund $15,583.90 $15,583.90 $1,676,050.00 0.93 %$1,660,466.10 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $4,641.58 $4,641.58 $512,100.00 0.91 %$507,458.42 Grand Totals $695,817.55 $695,817.55 $21,289,831.00 3.27 %$20,594,013.45 26 of 27 Beginning Activity Ending January 2020 Variance Cash In Cash Ending Cash (Decrease)/Increase 001 $3,338,907.76 $321,436.85 $3,076,343.18 $2,905,344.42 $170,998.76 101 $248,197.36 $132,232.82 $301,727.65 $327,387.46 ($25,659.81) 102 $40,324.38 $0.00 $40,324.38 $77,431.47 ($37,107.09) 105 $433,896.56 $19,305.00 $453,201.56 $349,004.18 $104,197.38 112 $14,744.33 $0.00 $14,744.33 $11,721.31 $3,023.02 113 $162,733.87 $16,007.03 $173,678.90 $92,840.02 $80,838.88 114 $1,537.63 $0.99 $1,538.62 $1,516.03 $22.59 116 $2,870.61 $4,995.13 $7,865.74 $51,973.88 ($44,108.14) 117 $18,767.92 $0.00 $9,411.81 $42,357.11 ($32,945.30) 202 $775,826.60 $0.00 $775,826.60 $8,668.69 $767,157.91 301 $262,409.25 $0.00 $262,409.25 $988,510.61 ($726,101.36) 314 $1,362,383.49 $59,721.28 $1,422,104.77 $1,198,270.46 $223,834.31 401 $2,166,740.88 $129.34 $2,151,240.08 $2,603,706.01 ($452,465.93) 501 $39,111.03 $184,525.66 $218,995.11 $315,210.44 ($96,215.33) $8,868,451.67 $738,354.10 $8,909,411.98 $8,973,942.09 ($64,530.11)$697,393.79 Stormwater Fund $15,630.14 Equipment Purchase, Repair & Replacement Fund $4,641.58 Street Improvements Fund $0.00 Capital Improvements Fund $0.00 Events Board Fund $9,356.11 Bond Redemption Fund $0.00 Drug Fund $0.00 Criminal Justice Fund $0.00 Library Fund $0.00 Hotel/Motel Tax Fund $5,062.00 Community Development Grants Fund $0.00 Transportation Benefit District Fund $0.00 Street Fund $78,702.53 Out General Fund $584,001.43 Cash and Investment Period: 2021 - January 2021 Fiscal Totals Fund Activity 27 of 27