Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020 - February 2020 Monthly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee April 7, 2020 City Council Meeting February 2020 Financial Report Date: April 7, 2020 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: February 2020 Financial Report This report provides a summary of the City’s overall financial operations through February 29, 2020. It offers a comparison of total overall revenues and expenditures between the current fiscal year and the same point in time as the last fiscal year. For the purposes of this report, operating funds are funds that receive general local tax support and/or expend wages and other steady expenses to support the day-to-day operations of the City. Non-operating funds are funds that are supported through special revenues and/or include non-wage and varying expenses (i.e. capital, grant projects, etc.). Table 1 below shows the City’s revenue collections through February 29, 2020 compared to revenue collections through February 28, 2019, along with the respective dollar and percentage variances for its operating funds. Table 1 February 29, 2020 February 28, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 670,703 707,141 (36,438) (5.15%) Street Fund - 101 346,895 347,720 (825) (0.24%) Events Board Fund - 117 250 12,230 (11,980) (97.96%) Equipment R&R Fund - 501 350,000 200,000 150,000 75.00% Total Revenues - Operating Funds 1,367,848 1,267,091 100,757 7.95% 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 26 City of East Wenatchee April 7, 2020 City Council Meeting February 2020 Financial Report Chart 1 is a graphical representation of year to year revenue comparisons for the City’s operating funds. Chart 1 Table 2 below shows the City’s revenue collections through February 29, 2020 compared to revenue collections through February 28, 2019, along with the respective dollar and percentage variances for its non-operating funds. 2 of 26 City of East Wenatchee April 7, 2020 City Council Meeting February 2020 Financial Report Table 2 February 29, 2020 February 28, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - - - - Trans Benefit District Fund - 105 35,165 33,501 1,664 4.97% Library Fund - 112 - - - - Hotel/Motel Tax Fund - 113 52,045 22,860 29,185 127.67% Drug Fund - 114 2 10 (8) (81.27%) Criminal Justice Fund - 116 4,770 4,594 176 3.83% Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 75,536 - 75,536 - Capital Improvements Fund - 314 160,817 10,011 150,806 1506.38% Storm Water Fund - 401 2,613,275 - 2,613,275 - Total Revenues - Non-Operating Funds 2,941,609 70,976 2,870,633 4044.53% Revenues - Non-Operating Funds Chart 2 is a graphical representation of year to year revenue comparisons for the City’s non-operating funds. Chart 2 3 of 26 City of East Wenatchee April 7, 2020 City Council Meeting February 2020 Financial Report Revenue Highlights: General Fund revenues are down $36,438, or 5.15%, from last year due to: $96,677 less sales tax allocated to this fund this year versus last year at this time $14,271 less property tax allocated to this fund this year versus last year at this time The above decreases are offset by the following increases from last year: $20,000 in grant funding from the Washington State Office of Public Defense $19,714 reimbursement from RiverCom for Police Department purchases Events Fund revenues are down $11,980, or 97.96%, because hotel/motel taxes are no longer directly deposited into this fund – a transfer of up to $135,000 from the Hotel/Motel Tax Fund is scheduled to occur this year, when necessary. Equipment R&R Fund revenues are up $150,000, or 75.00%, from last year due to a larger sales tax allocation this year versus last year currently due to the timing of vehicle purchases. Hotel/Motel Tax Fund revenues are up $29,185, or 127.67%, from last year presumably due to an increase in hotel stays in the City. Additionally, this fund now receives all hotel/motel taxes; however, a transfer of up to $135,000 is budgeted to go to the Events Fund. Street Improvements Fund revenues are up $75,536 from last year due to the timing of 10th Street Public Works Trust Fund Loan reimbursements, and grant funding received for the 3rd Street SE/Highline Drive roundabout. Capital Improvements Fund revenues are up $150,806, or 1,506.38%, from last year due to the increased collection of real estate excise tax presumably due to more or larger real estate sales transactions. Storm Water Fund revenues are up $2,613,275 because this is a new fund that the City is accounting for due to a terminated Interlocal Agreement with Douglas County for storm water services. Prior to 2020, Douglas County accounted for these monies as a fiduciary agent for the City. Table 3 below shows the City’s expenditures through February 29, 2020 compared to expenditures through February 28, 2019, along with respective dollar and percentage variances for its operating funds. 4 of 26 City of East Wenatchee April 7, 2020 City Council Meeting February 2020 Financial Report Table 3 February 29, 2020 February 28, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 1,202,001 1,238,467 (36,466) (2.94%) Street Fund - 101 125,895 200,745 (74,851) (37.29%) Events Board Fund - 117 18,098 16,772 1,326 7.90% Equipment R&R Fund - 501 65,951 101,007 (35,056) (34.71%) Total Expenditures - Operating Funds 1,411,945 1,556,992 (145,047) (9.32%) Expenditures - Operating Funds Chart 3 is a graphical representation of year to year expenditure comparisons for the City’s operating funds. Chart 3 Table 4 below shows the City’s expenditures through February 29, 2020 compared to expenditures through February 28, 2019, along with respective dollar and percentage variances for its non- operating funds. 5 of 26 City of East Wenatchee April 7, 2020 City Council Meeting February 2020 Financial Report Table 4 February 29, 2020 February 28, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - - - - Trans Benefit District Fund - 105 - - - - Debt Reserve Fund - 110 - - - - Library Fund - 112 1,015 344 672 195.59% Hotel/Motel Tax Fund - 113 - 18,546 (18,546) (100.00%) Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 62,524 98,550 (36,026) (36.56%) Storm Water Improvements Fund - 308 - - - - Capital Improvements Fund - 314 - 787 (787) (100.00%) Storm Water Fund - 401 31,226 - 31,226 - Total Expenditures - Non-Operating Funds 94,765 118,226 (23,461) (19.84%) Expenditures - Non-Operating Funds Chart 4 is a graphical representation of year to year expenditure comparisons for the City’s non- operating funds. Chart 4 6 of 26 City of East Wenatchee April 7, 2020 City Council Meeting February 2020 Financial Report Expenditure Highlights: General Fund expenditures are down $36,466, or 2.94%, from last year due to: $240,187 purchase of the Colorado Ave. property last year $19,059 less spending on Municipal Court capital outlay due to some equipment upgrades that were needed last year The above decreases are offset by the following increases: General salary and benefit increases, and increases due to retirements and separations $32,659 increase in bills to the Chelan County Regional Justice Center due to the timing of billings received, and due to the terms of the City’s new contract with them Street Fund expenditures are down $74,851, or 37.29%, from last year due to a calm winter, which resulted in less snow and ice removal overtime, and getting caught up with delayed Department of Transportation utility billings from prior years that we paid in the early part of 2019. Equipment R&R Fund expenditures are down $35,056, or 34.71%, from last year due to one less vehicle purchase by the Police Department. Hotel/Motel Tax Fund expenditures are down $18,546 due to a decrease in contributions to the Wenatchee Valley Museum. Monies for the museum were budgeted to come out of the General Fund; in early 2020, the Lodging Tax Advisory Committee approved the funding to come out of this fund. Finance will move the Wenatchee Valley Museum expenditures to this fund after a budget amendment is completed by year-end. Street Improvements Fund expenditures are down $36,026, or 36.56%, from last year due to a decrease in expenditures for the design of 10th Street. Storm Water Fund expenditures are up $31,226 from last year because this is a new fund that the City is accounting for due to a terminated Interlocal Agreement with Douglas County for storm water services. Prior to 2020, these expenditures were accounted for in the Street Fund. The reports presented in the following pages represent accounting system generated line-item details of revenues, expenditures, budgets, and cash balances for each fund through February 29, 2020. 7 of 26 Account Number Title Period Fiscal Budget % of Total Balance General Fund Taxes 001-000-000-311-10-00-00 Real & Personal Property Tax $4,379.29 $4,379.29 $1,245,000.00 0.35 %$1,240,620.71 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $138,521.62 $138,521.62 $3,500,000.00 3.96 %$3,361,478.38 001-000-000-313-71-00-00 Criminal Justice Sales Tax $29,720.79 $55,996.52 $300,000.00 18.67 %$244,003.48 001-000-000-316-40-00-00 Electric Utility Tax $39,384.65 $75,943.90 $355,000.00 21.39 %$279,056.10 001-000-000-316-45-00-00 Natural Gas Utility Tax $7,041.01 $12,854.47 $35,000.00 36.73 %$22,145.53 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $21,964.52 $46,639.24 $350,000.00 13.33 %$303,360.76 001-000-000-316-84-00-00 Gambling Tax $35,415.68 $108,279.74 $345,000.00 31.39 %$236,720.26 Total Taxes $276,427.56 $442,614.78 $6,130,000.00 7.22 %$5,687,385.22 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 $87.00 $87.00 $800.00 10.88 %$713.00 001-000-000-321-91-00-50 Franchise Fees - Cable $23,905.02 $23,905.02 $97,000.00 24.64 %$73,094.98 001-000-000-321-99-00-00 Business Licenses & Permits $8,135.83 $17,534.59 $107,100.00 16.37 %$89,565.41 001-000-000-321-99-05-00 Other Business Lic & Permits $660.00 $660.00 $650.00 101.54 %($10.00) 001-000-000-322-10-00-00 Building & Structure Permits $134.00 $20,909.24 $50,000.00 41.82 %$29,090.76 001-000-000-322-90-01-00 Gun Permits $421.00 $1,037.00 $6,500.00 15.95 %$5,463.00 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $100.00 0.00 %$100.00 Total Licenses and Permits $33,342.85 $64,132.85 $262,650.00 24.42 %$198,517.15 Intergovernmental Revenues 001-000-000-333-16-50-00 Columbia River Drug Task Force $0.00 $0.00 $7,500.00 0.00 %$7,500.00 001-000-000-334-03-10-00 Dept. of Ecology SMP Grant $0.00 $0.00 $16,800.00 0.00 %$16,800.00 001-000-000-334-03-51-03 TSC - Seatbelt Emphasis Patrols $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-334-03-51-04 X-52 TSC-Speed Limit Emphasis $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-000-334-03-51-10 Distracted Driving Enforcement Patrol $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-000-334-03-51-12 TSC - DUI Emphasis Patrol $0.00 $1,194.96 $2,750.00 43.45 %$1,555.04 001-000-000-334-04-20-05 Dept. of Commerce Grant $0.00 $0.00 $15,920.00 0.00 %$15,920.00 001-000-000-334-06-91-00 WA ST Office of Public Defense $0.00 $20,000.00 $0.00 ($20,000.00) 001-000-000-334-06-91-10 Washington State Archives Grant $0.00 $0.00 $20,000.00 0.00 %$20,000.00 001-000-000-334-06-95-00 RIVERCOM 911 Funding Assistance $19,714.23 $19,714.23 $21,000.00 93.88 %$1,285.77 001-000-000-335-00-91-00 PUD Privilege Tax $0.00 $0.00 $42,000.00 0.00 %$42,000.00 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $0.00 $21,000.00 0.00 %$21,000.00 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $449.72 $2,000.00 22.49 %$1,550.28 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $18,186.52 $75,000.00 24.25 %$56,813.48 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $0.00 $107,500.00 0.00 %$107,500.00 Revenue Starting Account Number: 001-000-000-308-00-00-00 Beginning Net Cash & Invest Ending Account Number: 501-000-000-397-21-00-20 Transfer In - Criminal Justice Period: 2020 - February 2020 8 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Intergovernmental Revenues $19,714.23 $59,545.43 $336,470.00 17.70 %$276,924.57 Charges for Goods and Services 001-000-000-341-33-10-00 Background Check Fees $0.00 $0.00 $60.00 0.00 %$60.00 001-000-000-341-35-30-00 Duplicating Services - Court & Police $0.00 $0.00 $500.00 0.00 %$500.00 001-000-000-341-35-31-00 Copy and Duplication Fees - Admin $0.00 $0.00 $200.00 0.00 %$200.00 001-000-000-341-35-33-00 Recording and Filing Fees $0.00 $0.00 $75.00 0.00 %$75.00 001-000-000-341-35-35-00 Annual Admin Reimb Fees $0.00 $0.00 $6,000.00 0.00 %$6,000.00 001-000-000-342-33-00-00 Adult Probation Services $3,177.89 $6,893.21 $70,000.00 9.85 %$63,106.79 001-000-000-342-36-00-00 Housing of Prisoners $502.80 $1,284.62 $25,000.00 5.14 %$23,715.38 001-000-000-342-40-00-01 Fire Marshall Inspection Services $0.00 $2,930.00 $5,000.00 58.60 %$2,070.00 001-000-000-345-83-00-00 Plan Checking Fees $15.27 $12,774.21 $25,000.00 51.10 %$12,225.79 001-000-000-345-83-41-00 Engineering Review Fees $0.00 $600.00 $800.00 75.00 %$200.00 001-000-000-345-86-00-00 Sepa Permits $0.00 $0.00 $500.00 0.00 %$500.00 001-000-000-345-89-00-00 Planning & Development Fees $490.00 $490.00 $7,500.00 6.53 %$7,010.00 Total Charges for Goods and Services $4,185.96 $24,972.04 $140,635.00 17.76 %$115,662.96 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $8,477.05 $20,300.77 $190,000.00 10.68 %$169,699.23 001-000-000-357-33-00-00 Public Defender Costs $419.65 $1,646.93 $25,000.00 6.59 %$23,353.07 001-000-000-357-35-00-00 Restitution $0.00 $50.00 $150.00 33.33 %$100.00 Total Fines and Penalties $8,896.70 $21,997.70 $215,150.00 10.22 %$193,152.30 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $8,898.94 $17,973.46 $100,000.00 17.97 %$82,026.54 001-000-000-361-40-00-00 Sales Tax Interest $585.44 $1,207.12 $5,000.00 24.14 %$3,792.88 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,092.11 $2,287.11 $10,000.00 22.87 %$7,712.89 001-000-000-369-91-50-00 Miscellaneous Revenue $0.00 $110.50 $7,500.00 1.47 %$7,389.50 Total Miscellaneous Revenues $10,576.49 $21,578.19 $122,500.00 17.61 %$100,921.81 Other Increases in Fund Resources 001-000-000-389-30-00-03 Fireworks - Cleaning Deposit $0.00 $0.00 $2,200.00 0.00 %$2,200.00 001-000-000-389-30-00-04 Fireworks - Dcfd Remittance $0.00 $0.00 $250.00 0.00 %$250.00 001-000-000-389-30-00-05 Crime Victim Assessment $140.61 $358.04 $3,500.00 10.23 %$3,141.96 001-000-000-389-30-00-10 State Surcharge $6.50 $194.50 $500.00 38.90 %$305.50 001-000-000-389-30-00-15 State Share Weapons Permit Fee $683.00 $1,663.25 $9,500.00 17.51 %$7,836.75 001-000-000-389-30-00-20 Court Remittance - State $8,065.73 $21,221.16 $200,000.00 10.61 %$178,778.84 Total Other Increases in Fund Resources $8,895.84 $23,436.95 $215,950.00 10.85 %$192,513.05 Other Financing Sources 001-000-000-395-10-00-00 Proceeds - Disposition of Assets $12,424.80 $12,424.80 $100.00 12,424.80 %($12,324.80) 001-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total Other Financing Sources $12,424.80 $12,424.80 $1,100.00 1,129.53 %($11,324.80) Total General Fund $374,464.43 $670,702.74 $7,424,455.00 9.03 %$6,753,752.26 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $0.00 $3,142.31 $400,000.00 0.79 %$396,857.69 101-000-000-313-11-00-00 Sales & Use Tax $151,288.36 $300,000.00 $300,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $35.00 $35.00 $3,000.00 1.17 %$2,965.00 101-000-000-336-00-71-00 Multi-Modal Distribution $0.00 $0.00 $18,000.00 0.00 %$18,000.00 9 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-000-336-00-87-00 Gas Tax $21,643.29 $43,717.70 $275,000.00 15.90 %$231,282.30 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 $172,966.65 $346,895.01 $1,012,000.00 34.28 %$665,104.99 Community Development Grants Fund 102-000-000-331-14-00-00 HUD CD Block Grant $0.00 $0.00 $219,619.00 0.00 %$219,619.00 Total Community Development Grants Fund $0.00 $0.00 $219,619.00 0.00 %$219,619.00 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $20,730.60 $35,164.80 $40,000.00 87.91 %$4,835.20 Total Transportation Benefit District Fund $20,730.60 $35,164.80 $40,000.00 87.91 %$4,835.20 Library Fund 112-000-000-347-20-00-00 Library Services $0.00 $0.00 $7,000.00 0.00 %$7,000.00 Total Library Fund $0.00 $0.00 $7,000.00 0.00 %$7,000.00 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $30,713.76 $52,044.79 $250,000.00 20.82 %$197,955.21 Total Hotel/Motel Tax Fund $30,713.76 $52,044.79 $250,000.00 20.82 %$197,955.21 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $0.57 $1.83 $100.00 1.83 %$98.17 Total Drug Fund $0.57 $1.83 $100.00 1.83 %$98.17 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $1,039.30 $3,700.00 28.09 %$2,660.70 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $3,730.39 $14,000.00 26.65 %$10,269.61 Total Criminal Justice Fund $0.00 $4,769.69 $17,700.00 26.95 %$12,930.31 Events Board Fund 117-000-100-397-00-00-00 Transfer-In from Fund 113 $0.00 $0.00 $135,000.00 0.00 %$135,000.00 117-000-200-347-40-02-01 Easter Egg Hunt Admission Fees $0.00 $0.00 $1,400.00 0.00 %$1,400.00 117-000-300-347-40-12-02 Classy Chassis Parade/Car Show $175.00 $250.00 $9,000.00 2.78 %$8,750.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-450-347-90-00-12 Parkway Pile-Up Car Show Sponsorships $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 $175.00 $250.00 $173,650.00 0.14 %$173,400.00 Bond Redemption Fund 202-000-000-311-10-00-00 Property Tax $0.00 $0.00 $155,000.00 0.00 %$155,000.00 202-000-000-397-00-00-00 Transfer-In from Fund 110 $0.00 $0.00 $660,000.00 0.00 %$660,000.00 Total Bond Redemption Fund $0.00 $0.00 $815,000.00 0.00 %$815,000.00 Street Improvements Fund 301-000-000-311-10-00-00 Property Tax $0.00 $0.00 $20,000.00 0.00 %$20,000.00 10 of 26 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-333-20-00-13 STP 9th/VMP Intersection $0.00 $0.00 $901,700.00 0.00 %$901,700.00 301-000-000-334-03-60-01 SRTS - 5th St NE: Sterling $0.00 $0.00 $220,224.00 0.00 %$220,224.00 301-000-000-334-03-60-02 SRTS - 5th St NE: Kenroy $0.00 $0.00 $225,778.00 0.00 %$225,778.00 301-000-000-334-03-80-08 TIB 3rd St SE/Highline Drive Roundabout $0.00 $15,467.01 $663,000.00 2.33 %$647,532.99 301-000-000-334-03-80-13 TIB N Kentucky Ave Overlay $0.00 $0.00 $637,500.00 0.00 %$637,500.00 301-000-000-334-03-80-15 TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $76,500.00 0.00 %$76,500.00 301-000-000-334-04-20-02 PWTFL - 10th Street Design $0.00 $60,068.94 $315,000.00 19.07 %$254,931.06 301-000-000-397-41-10-05 Transfer-In from Fund 105 $0.00 $0.00 $375,000.00 0.00 %$375,000.00 301-000-000-397-95-00-20 Transfer-In from Fund 314 $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Street Improvements Fund $0.00 $75,535.95 $3,584,702.00 2.11 %$3,509,166.05 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $39,409.84 $160,817.22 $350,000.00 45.95 %$189,182.78 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 $39,409.84 $160,817.22 $5,350,000.00 3.01 %$5,189,182.78 Stormwater Fund 401-000-000-334-03-10-00 Dept. of Ecology Capacity Grant $0.00 $0.00 $95,000.00 0.00 %$95,000.00 401-000-000-334-03-10-01 19th St. Ecology Grant $0.00 $46,140.36 $170,000.00 27.14 %$123,859.64 401-000-000-337-00-00-00 Transfer-In from Douglas Co.$0.00 $2,567,089.36 $2,500,000.00 102.68 %($67,089.36) 401-000-000-343-10-00-00 SWU Fee $45.00 $45.00 $518,000.00 0.01 %$517,955.00 401-000-000-397-00-00-00 Transfer-In from Fund 308 $0.00 $0.00 $103,090.00 0.00 %$103,090.00 Total Stormwater Fund $45.00 $2,613,274.72 $3,386,090.00 77.18 %$772,815.28 Equipment Purchase, Repair & Replacement Fund 501-000-000-313-11-00-10 Sales & Use Tax - Police $0.00 $50,000.00 $50,000.00 100.00 %$0.00 501-000-000-313-11-00-20 Sales & Use Tax - Streets $150,000.00 $300,000.00 $300,000.00 100.00 %$0.00 Total Equipment Purchase, Repair & Replacement Fund $150,000.00 $350,000.00 $350,000.00 100.00 %$0.00 Grand Totals $788,505.85 $4,309,456.75 $22,630,316.00 19.04 %$18,320,859.25 11 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $374,464.43 $670,702.74 $7,424,455.00 9.03 %$6,753,752.26 101-000-000-000-00-00-00 Street Fund $172,966.65 $346,895.01 $1,012,000.00 34.28 %$665,104.99 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $219,619.00 0.00 %$219,619.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $20,730.60 $35,164.80 $40,000.00 87.91 %$4,835.20 112-000-000-000-00-00-00 Library Fund $0.00 $0.00 $7,000.00 0.00 %$7,000.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $30,713.76 $52,044.79 $250,000.00 20.82 %$197,955.21 114-000-000-000-00-00-00 Drug Fund $0.57 $1.83 $100.00 1.83 %$98.17 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $4,769.69 $17,700.00 26.95 %$12,930.31 117-000-000-000-00-00-00 Events Board Fund $175.00 $250.00 $173,650.00 0.14 %$173,400.00 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $0.00 $815,000.00 0.00 %$815,000.00 301-000-000-000-00-00-00 Street Improvements Fund $0.00 $75,535.95 $3,584,702.00 2.11 %$3,509,166.05 314-000-000-000-00-00-00 Capital Improvements Fund $39,409.84 $160,817.22 $5,350,000.00 3.01 %$5,189,182.78 401-000-000-000-00-00-00 Stormwater Fund $45.00 $2,613,274.72 $3,386,090.00 77.18 %$772,815.28 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $150,000.00 $350,000.00 $350,000.00 100.00 %$0.00 Grand Totals $788,505.85 $4,309,456.75 $22,630,316.00 19.04 %$18,320,859.25 12 of 26 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 $9.74 $3,000.00 0.32 %$2,990.26 001-000-001-518-93-49-00 City Theme $0.00 $0.00 $750.00 0.00 %$750.00 001-000-001-521-10-29-00 LEOFF 1 Insurance Premiums $2,227.50 $4,455.00 $27,500.00 16.20 %$23,045.00 001-000-001-528-70-40-00 River Com $25,380.31 $50,760.62 $365,000.00 13.91 %$314,239.38 001-000-001-539-30-40-00 Animal Control $6,126.24 $12,252.48 $73,515.00 16.67 %$61,262.52 001-000-001-558-60-41-00 Chelan-Douglas Transportation Council $0.00 $0.00 $13,928.00 0.00 %$13,928.00 001-000-001-558-70-40-00 Contributions - Region $0.00 $0.00 $45,000.00 0.00 %$45,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 $1,500.00 $1,500.00 $1,500.00 100.00 %$0.00 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $360.00 $360.00 $360.00 100.00 %$0.00 001-000-001-558-70-41-10 Spirit of Wenatchee Miss Veedol $3,000.00 $3,000.00 $3,000.00 100.00 %$0.00 001-000-001-558-70-41-15 Wenatchee Valley Museum $10,124.00 $20,248.00 $121,488.00 16.67 %$101,240.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$958.80 $958.80 $3,600.00 26.63 %$2,641.20 Total General Government $49,676.85 $93,544.64 $660,191.00 14.17 %$566,646.36 Legislative 001-000-110-511-60-10-00 Salaries $44,376.18 $65,725.50 $197,000.00 33.36 %$131,274.50 001-000-110-511-60-20-00 Benefits $10,046.01 $14,681.32 $60,000.00 24.47 %$45,318.68 001-000-110-511-60-21-50 Public Defender $12,145.46 $20,245.46 $135,000.00 15.00 %$114,754.54 001-000-110-511-60-30-00 Public Defender Conflicts $0.00 $0.00 $5,500.00 0.00 %$5,500.00 001-000-110-511-60-31-00 Office Supplies $38.93 $321.27 $300.00 107.09 %($21.27) 001-000-110-511-60-31-05 Newsletter Printing & Mailing $0.00 $0.00 $10,500.00 0.00 %$10,500.00 001-000-110-511-60-31-10 Public Records Expenses $0.00 $0.00 $200.00 0.00 %$200.00 001-000-110-511-60-40-00 Training $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-110-511-60-41-00 Professional Services $20,337.21 $20,337.21 $42,000.00 48.42 %$21,662.79 001-000-110-511-60-41-20 AWC Annual Membership Fee $0.00 $9,967.00 $10,000.00 99.67 %$33.00 001-000-110-511-60-42-01 Cell Phone $56.13 $56.13 $500.00 11.23 %$443.87 001-000-110-511-60-43-00 Travel $391.84 $391.84 $1,500.00 26.12 %$1,108.16 001-000-110-511-60-43-01 Travel - Misawa $0.00 $0.00 $4,750.00 0.00 %$4,750.00 001-000-110-511-60-44-00 Advertising $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-110-511-60-45-00 Election Costs - Registered Voters $0.00 $0.00 $22,000.00 0.00 %$22,000.00 001-000-110-511-60-46-00 Insurance $28.83 $28.83 $13,000.00 0.22 %$12,971.17 001-000-110-511-60-47-00 Background Check Costs $0.00 $55.00 $200.00 27.50 %$145.00 001-000-110-511-60-49-00 Miscellaneous $245.81 $565.01 $5,000.00 11.30 %$4,434.99 Total Legislative $87,666.40 $132,374.57 $512,450.00 25.83 %$380,075.43 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: 2020 - February 2020 13 of 26 Account Number Title Period Fiscal Budget % of Total Balance Municipal Court 001-000-120-512-50-10-00 Salaries $16,433.82 $32,867.64 $199,000.00 16.52 %$166,132.36 001-000-120-512-50-12-00 Salaries - Probation Services $4,673.08 $9,346.16 $55,000.00 16.99 %$45,653.84 001-000-120-512-50-20-00 Benefits $5,537.86 $11,075.72 $74,000.00 14.97 %$62,924.28 001-000-120-512-50-22-00 Benefits - Probation Services $2,964.86 $5,987.14 $41,000.00 14.60 %$35,012.86 001-000-120-512-50-31-00 Office Supplies $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-120-512-50-40-00 Training $0.00 $690.00 $1,500.00 46.00 %$810.00 001-000-120-512-50-43-00 Travel $1,802.72 $2,005.13 $6,000.00 33.42 %$3,994.87 001-000-120-512-50-46-00 Insurance $43.25 $143.25 $13,860.00 1.03 %$13,716.75 001-000-120-512-50-49-00 Miscellaneous $152.00 $152.00 $0.00 ($152.00) 001-000-120-512-50-49-01 Interpreting $140.00 $140.00 $5,000.00 2.80 %$4,860.00 001-000-120-512-50-49-02 Judge Protems $300.00 $300.00 $4,000.00 7.50 %$3,700.00 001-000-120-512-50-49-03 Witness Fees $59.90 $59.90 $500.00 11.98 %$440.10 001-000-120-512-50-49-04 Juror Fees $1,045.52 $1,199.98 $2,000.00 60.00 %$800.02 001-000-120-512-50-49-09 Security $408.25 $408.25 $6,000.00 6.80 %$5,591.75 001-000-120-594-12-60-00 Capital Outlay $23.70 $280.04 $5,000.00 5.60 %$4,719.96 Total Municipal Court $33,584.96 $64,655.21 $414,360.00 15.60 %$349,704.79 City Clerk 001-000-140-514-20-10-00 Salaries $6,438.52 $12,877.04 $78,000.00 16.51 %$65,122.96 001-000-140-514-20-20-00 Benefits $3,011.28 $5,647.56 $42,000.00 13.45 %$36,352.44 001-000-140-514-20-31-00 Office Supplies $153.81 $543.24 $3,000.00 18.11 %$2,456.76 001-000-140-514-20-31-01 Central Stores $244.94 $260.73 $5,000.00 5.21 %$4,739.27 001-000-140-514-20-40-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-140-514-20-41-00 Membership Dues & Publications $170.00 $170.00 $1,200.00 14.17 %$1,030.00 001-000-140-514-20-43-00 Travel $0.00 $231.60 $2,500.00 9.26 %$2,268.40 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 $14.42 $14.42 $8,800.00 0.16 %$8,785.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-49-00 Miscellaneous $40.31 $58.58 $750.00 7.81 %$691.42 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 Total City Clerk $10,073.28 $19,803.17 $148,600.00 13.33 %$128,796.83 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $0.00 $0.00 $14,000.00 0.00 %$14,000.00 001-000-141-514-20-42-01 Telephone Line Charges $1,004.38 $1,383.70 $14,000.00 9.88 %$12,616.30 001-000-141-514-20-42-03 Postage $15.65 $15.65 $7,000.00 0.22 %$6,984.35 001-000-141-514-20-48-00 Repairs & Maintenance $747.76 $747.76 $3,000.00 24.93 %$2,252.24 Total Internal Services $1,767.79 $2,147.11 $38,000.00 5.65 %$35,852.89 Finance 001-000-142-514-20-10-00 Salaries $46,100.95 $69,175.08 $210,000.00 32.94 %$140,824.92 001-000-142-514-20-20-00 Benefits $12,108.92 $19,894.71 $95,000.00 20.94 %$75,105.29 001-000-142-514-20-31-00 Office Supplies $0.00 $65.34 $1,700.00 3.84 %$1,634.66 001-000-142-514-20-43-00 Travel $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-142-514-20-46-00 Insurance $28.83 $28.83 $9,680.00 0.30 %$9,651.17 001-000-142-514-23-20-00 State Audit $0.00 $0.00 $18,000.00 0.00 %$18,000.00 14 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-142-514-25-30-00 Bank Charges & Fees $265.72 $596.61 $5,000.00 11.93 %$4,403.39 001-000-142-514-40-20-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Finance $58,504.42 $89,760.57 $342,380.00 26.22 %$252,619.43 Information Technology 001-000-145-514-20-10-00 Salaries $7,949.86 $15,899.72 $96,000.00 16.56 %$80,100.28 001-000-145-514-20-20-00 Benefits $3,663.64 $7,327.28 $50,000.00 14.65 %$42,672.72 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 $75.00 $100.00 75.00 %$25.00 001-000-145-514-20-40-05 Disaster Backup System Support $0.00 $0.00 $25,000.00 0.00 %$25,000.00 001-000-145-514-20-40-10 Annual Fee - ESRI GIS System License $0.00 $0.00 $1,100.00 0.00 %$1,100.00 001-000-145-514-20-40-20 Annual License - Spillman, NetMotion & Ragnasoft $0.00 $0.00 $20,645.00 0.00 %$20,645.00 001-000-145-514-20-40-30 Annual Fee - Vision Financial Software $0.00 $5,908.32 $6,000.00 98.47 %$91.68 001-000-145-514-20-40-35 Annual License Fee - Evidence.com $0.00 $0.00 $7,000.00 0.00 %$7,000.00 001-000-145-514-20-40-40 Annual Subscription - Granicus $594.64 $594.64 $7,000.00 8.49 %$6,405.36 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-55 Annual Support & Maintenance - Laserfiche $0.00 $0.00 $9,800.00 0.00 %$9,800.00 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $0.00 $3,200.00 $8,000.00 40.00 %$4,800.00 001-000-145-514-20-41-00 Professional Services $5,800.00 $5,800.00 $5,000.00 116.00 %($800.00) 001-000-145-514-20-42-00 Cell Phone $69.04 $69.04 $750.00 9.21 %$680.96 001-000-145-514-20-43-00 Training $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-145-514-20-44-00 Travel $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-145-514-20-49-00 Miscellaneous $0.00 $73.60 $0.00 ($73.60) 001-000-145-594-14-60-20 Capital - PC Software Admin $2,132.16 $2,716.44 $20,000.00 13.58 %$17,283.56 001-000-145-594-14-60-25 Capital - PC Hardware Admin $427.44 $2,272.58 $50,000.00 4.55 %$47,727.42 Total Information Technology $20,636.78 $43,936.62 $316,895.00 13.86 %$272,958.38 Legal 001-000-151-515-31-10-00 Salaries $9,836.18 $19,672.36 $195,000.00 10.09 %$175,327.64 001-000-151-515-31-20-00 Benefits $4,059.16 $8,164.50 $104,000.00 7.85 %$95,835.50 001-000-151-515-31-20-10 Training $100.00 $100.00 $2,000.00 5.00 %$1,900.00 001-000-151-515-31-25-00 Professional Services $56.00 $56.00 $1,500.00 3.73 %$1,444.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 $300.00 0.00 %$300.00 001-000-151-515-31-42-03 Postage $28.93 $28.93 $0.00 ($28.93) 001-000-151-515-31-43-00 Travel $0.00 $0.00 $2,000.00 0.00 %$2,000.00 001-000-151-515-31-46-00 Insurance $14.42 $14.42 $12,100.00 0.12 %$12,085.58 001-000-151-515-31-49-00 Miscellaneous $0.00 $649.00 $3,000.00 21.63 %$2,351.00 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Legal $14,094.69 $28,685.21 $330,900.00 8.67 %$302,214.79 Civil Service 001-000-160-521-10-10-00 Salaries $0.00 $260.00 $3,214.00 8.09 %$2,954.00 001-000-160-521-10-46-00 Insurance $14.42 $14.42 $7,150.00 0.20 %$7,135.58 15 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Civil Service $14.42 $274.42 $10,364.00 2.65 %$10,089.58 Central Services 001-000-180-518-30-31-01 Central Stores $0.00 $13.53 $0.00 ($13.53) 001-000-180-518-30-31-06 Cleaning & Sanitation Supplies $267.51 $267.51 $2,000.00 13.38 %$1,732.49 001-000-180-518-30-35-00 Small Tools & Equipment $34.08 $34.08 $10,000.00 0.34 %$9,965.92 001-000-180-518-30-41-00 Professional Services $510.17 $522.67 $25,000.00 2.09 %$24,477.33 001-000-180-518-30-41-01 Contracted Custodial Services $2,099.13 $4,198.40 $24,000.00 17.49 %$19,801.60 001-000-180-518-30-46-00 Insurance $28.83 $28.83 $47,300.00 0.06 %$47,271.17 001-000-180-518-30-47-00 Utilities $2,241.21 $2,436.96 $25,000.00 9.75 %$22,563.04 001-000-180-518-30-48-00 Repairs & Maintenance $569.18 $598.40 $12,000.00 4.99 %$11,401.60 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 $12,000.00 0.00 %$12,000.00 001-000-180-518-61-41-00 Judgements & Settlements $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-180-518-92-20-00 Ancillary (Interfund Maintenance)$2,948.29 $4,200.00 $6,000.00 70.00 %$1,800.00 001-000-180-594-18-60-00 Capital Outlay $0.00 $0.00 $22,000.00 0.00 %$22,000.00 Total Central Services $8,698.40 $12,300.38 $197,300.00 6.23 %$184,999.62 Law Enforcement 001-000-210-521-10-10-00 Salaries $214,176.96 $389,241.37 $2,100,000.00 18.54 %$1,710,758.63 001-000-210-521-10-10-02 Overtime Salaries $15,795.74 $29,174.24 $175,000.00 16.67 %$145,825.76 001-000-210-521-10-10-03 Overtime Salaries - Traffic Control $0.00 $555.26 $8,000.00 6.94 %$7,444.74 001-000-210-521-10-20-00 Benefits $57,196.86 $114,505.05 $900,000.00 12.72 %$785,494.95 001-000-210-521-10-20-01 Clothing Allowance $911.81 $911.81 $14,400.00 6.33 %$13,488.19 001-000-210-521-10-31-00 Office Supplies ($216.36)($216.36)$8,500.00 -2.55 %$8,716.36 001-000-210-521-10-31-05 Office Machine Costs $307.67 $630.15 $5,000.00 12.60 %$4,369.85 001-000-210-521-10-32-00 Fuel Consumed $35.46 $35.46 $52,000.00 0.07 %$51,964.54 001-000-210-521-10-35-00 Small Tools & Equipment $3,778.74 $3,778.74 $13,000.00 29.07 %$9,221.26 001-000-210-521-10-35-02 WASPC Traffic Safety Grant $0.00 $0.00 $3,000.00 0.00 %$3,000.00 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 $1,045.56 $1,045.56 $15,000.00 6.97 %$13,954.44 001-000-210-521-10-42-01 Telephone $1,883.52 $1,883.52 $28,000.00 6.73 %$26,116.48 001-000-210-521-10-42-03 Postage $84.74 $84.74 $1,200.00 7.06 %$1,115.26 001-000-210-521-10-43-00 Travel $1,663.88 $1,663.88 $22,000.00 7.56 %$20,336.12 001-000-210-521-10-46-00 Insurance $317.12 $317.12 $69,000.00 0.46 %$68,682.88 001-000-210-521-10-48-00 Repairs & Maintenance $262.07 $262.07 $8,000.00 3.28 %$7,737.93 001-000-210-521-10-49-00 Miscellaneous $245.00 $245.00 $5,500.00 4.45 %$5,255.00 001-000-210-521-10-49-01 Reserves $0.00 $0.00 $500.00 0.00 %$500.00 001-000-210-521-10-49-02 Dry Cleaning Services $17.58 $17.58 $1,500.00 1.17 %$1,482.42 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 $9,000.00 0.00 %$9,000.00 001-000-210-521-40-27-00 Training - Office Staff $0.00 $0.00 $900.00 0.00 %$900.00 001-000-210-521-40-30-00 Training - Academy $0.00 $0.00 $9,600.00 0.00 %$9,600.00 001-000-210-521-50-10-00 Ancillary (Interfund Vehicle Maintenance) $0.00 $0.00 $2,400.00 0.00 %$2,400.00 16 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-50-49-00 Other Services $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-594-21-60-00 Capital Outlay $0.00 $33,171.22 $33,000.00 100.52 %($171.22) Total Law Enforcement $297,506.35 $577,306.41 $3,493,350.00 16.53 %$2,916,043.59 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $32,659.23 $32,659.23 $378,000.00 8.64 %$345,340.77 001-000-230-523-60-20-00 Medical Care - Prisoners $0.00 $0.00 $10,000.00 0.00 %$10,000.00 001-000-230-527-60-30-00 Juvenile Detention $0.00 $0.00 $6,500.00 0.00 %$6,500.00 Total Jail Services $32,659.23 $32,659.23 $394,500.00 8.28 %$361,840.77 Public Works 001-000-315-542-10-10-00 Salaries $7,732.80 $15,465.60 $94,000.00 16.45 %$78,534.40 001-000-315-542-10-20-00 Benefits $3,477.52 $6,955.04 $46,000.00 15.12 %$39,044.96 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 $59.04 $59.04 $750.00 7.87 %$690.96 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 $14.42 $14.42 $11,000.00 0.13 %$10,985.58 001-000-315-542-10-49-00 Training $227.00 $227.00 $2,000.00 11.35 %$1,773.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,510.78 $22,721.10 $172,500.00 13.17 %$149,778.90 Planning 001-000-580-558-60-10-00 Salaries $14,837.74 $29,675.48 $179,500.00 16.53 %$149,824.52 001-000-580-558-60-20-00 Benefits $5,062.88 $10,125.76 $62,000.00 16.33 %$51,874.24 001-000-580-558-60-31-00 Office Supplies $37.86 $37.86 $1,000.00 3.79 %$962.14 001-000-580-558-60-32-00 Fuel Consumed $0.00 $0.00 $200.00 0.00 %$200.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 $2,000.00 0.00 %$2,000.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,200.00 0.00 %$1,200.00 001-000-580-558-60-43-00 Travel $0.00 $0.00 $3,000.00 0.00 %$3,000.00 001-000-580-558-60-44-00 Advertising $0.00 $0.00 $3,500.00 0.00 %$3,500.00 001-000-580-558-60-46-00 Insurance $28.83 $28.83 $11,440.00 0.25 %$11,411.17 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 $615.00 $615.00 $2,200.00 27.95 %$1,585.00 Total Planning $20,582.31 $40,482.93 $291,840.00 13.87 %$251,357.07 Code Compliance 001-000-590-558-50-10-00 Salaries $8,739.08 $17,446.50 $111,000.00 15.72 %$93,553.50 001-000-590-558-50-20-00 Benefits $4,259.68 $8,512.88 $56,000.00 15.20 %$47,487.12 001-000-590-558-50-31-00 Office Supplies $71.67 $71.67 $2,200.00 3.26 %$2,128.33 001-000-590-558-50-32-00 Fuel Consumed $37.81 $37.81 $460.00 8.22 %$422.19 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-41-01 Fire Marshal Services $0.00 $0.00 $21,500.00 0.00 %$21,500.00 17 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-42-00 Abatement $0.00 $0.00 $30,000.00 0.00 %$30,000.00 001-000-590-558-50-43-00 Travel $0.00 $0.00 $475.00 0.00 %$475.00 001-000-590-558-50-46-00 Insurance $14.42 $14.42 $8,690.00 0.17 %$8,675.58 001-000-590-558-50-49-00 Miscellaneous $95.00 $95.00 $300.00 31.67 %$205.00 Total Code Compliance $13,217.66 $26,178.28 $231,025.00 11.33 %$204,846.72 Other Expenditures 001-001-000-589-30-00-03 Fireworks - Deposit Refund $0.00 $0.00 $2,500.00 0.00 %$2,500.00 001-001-000-589-30-00-04 Fireworks - DCFD Remittance $0.00 $0.00 $500.00 0.00 %$500.00 001-001-000-589-30-00-05 County Share of Crime Victims $748.96 $748.96 $4,000.00 18.72 %$3,251.04 001-001-000-589-30-00-10 Remittance: State Building Code Surcharge $188.00 $188.00 $500.00 37.60 %$312.00 001-001-000-589-30-00-15 State Share of Permits & Licenses $806.25 $1,079.25 $11,500.00 9.38 %$10,420.75 001-001-000-589-30-00-20 Court Remittances $13,155.42 $13,155.42 $211,000.00 6.23 %$197,844.58 Total Other Expenditures $14,898.63 $15,171.63 $230,000.00 6.60 %$214,828.37 Total General Fund $675,092.95 $1,202,001.48 $7,784,655.00 15.44 %$6,582,653.52 Street Fund Storm Water Administration 101-000-311-542-42-10-00 SWU Administration - Salaries $0.00 $1,703.52 $0.00 ($1,703.52) Total Storm Water Administration $0.00 $1,703.52 $0.00 ($1,703.52) NPDES 101-000-313-542-42-10-00 NPDES Maintenance Salaries $0.00 $269.47 $0.00 ($269.47) 101-000-313-542-42-10-10 NPDES Sweeping Salaries $0.00 $641.61 $0.00 ($641.61) 101-000-313-542-42-20-00 NPDES Maintenance Benefits $0.00 $55.27 $0.00 ($55.27) 101-000-313-542-42-20-10 NPDES Sweeping Benefits $0.00 $131.60 $0.00 ($131.60) 101-000-313-542-42-30-00 NPDES Supplies $206.20 $206.20 $0.00 ($206.20) 101-000-313-542-42-47-00 NPDES Utilities $52.40 $52.40 $0.00 ($52.40) 101-000-313-542-42-49-00 NPDES Miscellaneous Expense $0.00 $10.66 $0.00 ($10.66) Total NPDES $258.60 $1,367.21 $0.00 ($1,367.21) 101-000-420-542-30-10-00 Salaries - Roadway $1,295.70 $2,858.58 $80,000.00 3.57 %$77,141.42 101-000-420-542-30-20-00 Benefits - Roadway $844.96 $1,518.53 $53,000.00 2.87 %$51,481.47 101-000-420-542-30-30-00 Supplies - Roadway $101.02 $1,070.49 $50,000.00 2.14 %$48,929.51 101-000-420-542-30-48-00 Repairs & Maintenance - Roadway $0.00 $0.00 $6,000.00 0.00 %$6,000.00 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $0.00 $4,500.00 0.00 %$4,500.00 101-000-420-542-61-20-00 Benefits - Sidewalks $0.00 $0.00 $2,400.00 0.00 %$2,400.00 101-000-420-542-61-30-00 Supplies - Sidewalks $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-420-542-61-48-00 Repairs & Maintenance - Sidewalks $0.00 $0.00 $3,000.00 0.00 %$3,000.00 101-000-420-542-62-10-00 Salaries - Special Purpose Paths $0.00 $0.00 $500.00 0.00 %$500.00 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $0.00 $0.00 $250.00 0.00 %$250.00 101-000-420-542-62-30-00 Supplies - Special Purpose Paths $0.00 $0.00 $2,500.00 0.00 %$2,500.00 101-000-420-542-63-10-00 Salaries - Street Lighting $111.92 $355.20 $2,000.00 17.76 %$1,644.80 101-000-420-542-63-20-00 Benefits - Street Lighting $22.95 $95.50 $1,200.00 7.96 %$1,104.50 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,462.00 $2,566.40 $60,000.00 4.28 %$57,433.60 101-000-420-542-63-48-00 Repairs & Maintenance - Street Lighting $0.00 $0.00 $5,000.00 0.00 %$5,000.00 18 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-64-10-00 Salaries - Traffic Control Devices $123.10 $335.72 $40,000.00 0.84 %$39,664.28 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $73.71 $204.68 $23,000.00 0.89 %$22,795.32 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $0.00 $64.97 $48,000.00 0.14 %$47,935.03 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $358.87 $622.00 $9,000.00 6.91 %$8,378.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 $371.18 $1,000.00 37.12 %$628.82 101-000-420-542-65-20-00 Benefits - Parking Facilities $0.00 $311.65 $500.00 62.33 %$188.35 101-000-420-542-65-30-00 Supplies - Parking Facilities $0.00 $0.00 $300.00 0.00 %$300.00 101-000-420-542-65-47-00 Utilities - Parking Facilities $0.00 $0.00 $500.00 0.00 %$500.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $1,720.42 $8,700.71 $70,000.00 12.43 %$61,299.29 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $1,234.67 $5,212.66 $47,000.00 11.09 %$41,787.34 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $1,709.56 $8,690.65 $100,000.00 8.69 %$91,309.35 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $425.40 $425.40 $5,000.00 8.51 %$4,574.60 101-000-420-542-69-10-00 Salaries - Flags/Banners $739.51 $1,616.31 $30,000.00 5.39 %$28,383.69 101-000-420-542-69-20-00 Benefits - Flags/Banners $184.60 $412.54 $25,000.00 1.65 %$24,587.46 101-000-420-542-69-30-00 Supplies - Flags/Banners $341.68 $798.07 $2,000.00 39.90 %$1,201.93 101-000-420-542-70-10-00 Salaries - Roadside $18,149.56 $38,297.48 $180,000.00 21.28 %$141,702.52 101-000-420-542-70-20-00 Benefits - Roadside $9,230.27 $19,663.93 $94,000.00 20.92 %$74,336.07 101-000-420-542-70-30-00 Supplies - Roadside $112.25 $223.87 $5,000.00 4.48 %$4,776.13 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 $5,387.69 $9,573.44 $45,000.00 21.27 %$35,426.56 101-000-420-542-75-20-00 Benefits - City Parks $2,479.45 $4,146.35 $23,000.00 18.03 %$18,853.65 101-000-420-542-75-30-00 Supplies - City Parks $263.82 $375.43 $15,000.00 2.50 %$14,624.57 101-000-420-542-75-47-00 Utilities - City Parks $46.00 $46.00 $4,000.00 1.15 %$3,954.00 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $428.04 $525.77 $4,000.00 13.14 %$3,474.23 101-000-420-542-80-48-00 Japanese Garden Agreement $0.00 $1,500.00 $18,000.00 8.33 %$16,500.00 101-000-420-542-90-10-00 Salaries - Maintenance Admin $0.00 $1,172.88 $0.00 ($1,172.88) 101-000-420-542-90-20-00 Benefits - Maintenance Admin $0.00 $284.71 $0.00 ($284.71) 101-000-430-543-30-10-00 Salaries - General Services $1,965.93 $3,992.68 $0.00 ($3,992.68) 101-000-430-543-30-20-00 Benefits - General Services $868.57 $1,746.29 $0.00 ($1,746.29) 101-000-430-543-30-30-00 Supplies - General Services $622.52 $687.61 $6,000.00 11.46 %$5,312.39 101-000-430-543-30-46-00 Insurance $115.32 $124.35 $54,000.00 0.23 %$53,875.65 101-000-430-543-30-49-00 Miscellaneous - General Services $0.00 $640.00 $3,000.00 21.33 %$2,360.00 101-000-430-543-50-10-00 Salaries - Facilities $0.00 $1,410.94 $3,000.00 47.03 %$1,589.06 101-000-430-543-50-20-00 Benefits - Facilities $0.00 $486.89 $1,600.00 30.43 %$1,113.11 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 $59.04 $59.04 $750.00 7.87 %$690.96 101-000-430-543-50-47-00 Utilities - Facilities $810.76 $810.76 $6,000.00 13.51 %$5,189.24 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 $577.51 $577.51 $6,500.00 8.88 %$5,922.49 101-000-430-544-90-20-00 Benefits - Training $246.68 $246.68 $3,872.00 6.37 %$3,625.32 101-000-430-544-90-30-00 Supplies - Training $0.00 $0.00 $500.00 0.00 %$500.00 19 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 Total Street Fund $53,372.08 $125,894.58 $1,175,872.00 10.71 %$1,049,977.42 Community Development Grants Fund 102-000-000-558-70-40-00 CDBG Housing Program Costs $0.00 $0.00 $192,619.00 0.00 %$192,619.00 102-000-000-558-70-41-00 CDBG Professional Services $0.00 $0.00 $25,300.00 0.00 %$25,300.00 102-000-000-558-70-44-00 CDBG Advertising $0.00 $0.00 $1,600.00 0.00 %$1,600.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 $219,619.00 0.00 %$219,619.00 Transportation Benefit District Fund 105-000-000-597-91-00-00 Transfer-Out to Fund 301 $0.00 $0.00 $375,000.00 0.00 %$375,000.00 Total Transportation Benefit District Fund $0.00 $0.00 $375,000.00 0.00 %$375,000.00 Financing Reserves Fund 110-000-000-597-00-00-00 Transfer-Out to Fund 202 $0.00 $0.00 $660,000.00 0.00 %$660,000.00 Total Financing Reserves Fund $0.00 $0.00 $660,000.00 0.00 %$660,000.00 Library Fund 112-000-000-572-50-41-00 Facilities - Professional Services $0.00 $0.00 $2,000.00 0.00 %$2,000.00 112-000-000-572-50-47-00 Facilities - Utilities $657.35 $1,015.37 $4,000.00 25.38 %$2,984.63 112-000-000-572-50-49-00 Facilities - Supplies & Miscellaneous $0.00 $0.00 $40.00 0.00 %$40.00 Total Library Fund $657.35 $1,015.37 $6,040.00 16.81 %$5,024.63 Hotel/Motel Tax Fund 113-000-000-557-30-41-10 Contributions to Other Entities $0.00 $0.00 $70,000.00 0.00 %$70,000.00 113-001-000-597-00-00-01 Transfer-Out to Fund 117 $0.00 $0.00 $135,000.00 0.00 %$135,000.00 Total Hotel/Motel Tax Fund $0.00 $0.00 $205,000.00 0.00 %$205,000.00 Events Board Fund 117-000-050-557-30-10-00 Salaries $4,707.75 $11,742.62 $78,000.00 15.05 %$66,257.38 117-000-050-557-30-20-00 Benefits $2,093.06 $5,402.20 $41,000.00 13.18 %$35,597.80 117-000-100-557-30-25-00 Marketing - Regional Tourism $0.00 $249.00 $3,000.00 8.30 %$2,751.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 $12.95 $600.00 2.16 %$587.05 117-000-100-557-30-42-00 Cell Phone $59.04 $59.04 $600.00 9.84 %$540.96 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 $28.83 $28.83 $8,360.00 0.34 %$8,331.17 117-000-115-557-30-31-05 Office Supplies $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-200-557-30-35-02 Easter - Small Tools & Equipment $0.00 $0.00 $200.00 0.00 %$200.00 117-000-200-557-30-44-02 Easter - Advertising $0.00 $0.00 $500.00 0.00 %$500.00 117-000-200-557-30-46-02 Easter - Office Supplies $0.00 $0.00 $100.00 0.00 %$100.00 117-000-200-557-30-49-02 Easter - Miscellaneous $0.00 $54.14 $600.00 9.02 %$545.86 117-000-300-557-30-35-12 CC - Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 117-000-300-557-30-41-12 CC - Professional Services $259.68 $259.68 $2,300.00 11.29 %$2,040.32 117-000-300-557-30-42-14 CC - Postage $0.00 $0.00 $500.00 0.00 %$500.00 117-000-300-557-30-43-12 CC - EMPD Facility Fee $0.00 $0.00 $1,000.00 0.00 %$1,000.00 20 of 26 Account Number Title Period Fiscal Budget % of Total Balance 117-000-300-557-30-44-12 CC - Advertising $99.00 $109.00 $3,000.00 3.63 %$2,891.00 117-000-300-557-30-49-12 CC - Miscellaneous $0.00 $0.00 $2,000.00 0.00 %$2,000.00 117-000-400-557-30-35-11 W&W - Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$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 $550.00 0.00 %$550.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 $99.00 $109.00 $5,000.00 2.18 %$4,891.00 117-000-400-557-30-49-11 W&W - Miscellaneous $0.00 $0.00 $300.00 0.00 %$300.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-450-557-30-41-00 Parkway Pile-Up - Professional Services $0.00 $0.00 $600.00 0.00 %$600.00 117-000-450-557-30-44-12 Parkway Pile-Up - Advertising $0.00 $10.00 $500.00 2.00 %$490.00 117-000-450-557-30-49-01 Parkway Pile-Up - Miscellaneous $0.00 $0.00 $300.00 0.00 %$300.00 117-000-500-557-30-35-01 Christmas - Small Tools & Equipment $61.64 $61.64 $150.00 41.09 %$88.36 117-000-500-557-30-40-05 Christmas - Events & Decorations $0.00 $0.00 $10,000.00 0.00 %$10,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 $500.00 0.00 %$500.00 Total Events Board Fund $7,408.00 $18,098.10 $173,810.00 10.41 %$155,711.90 Bond Redemption Fund 202-000-000-591-48-70-00 Principal - 2020 LTGO Bond (Public Works Area) $0.00 $0.00 $150,000.00 0.00 %$150,000.00 202-000-000-591-95-70-00 Principal - PWTFL 10th St. NE $0.00 $0.00 $125,000.00 0.00 %$125,000.00 202-000-000-591-95-71-05 Principal - PWTFL 11th St. NE $0.00 $0.00 $29,713.00 0.00 %$29,713.00 202-000-000-592-48-80-00 Interest - 2020 LTGO Bond (Public Works Area) $0.00 $0.00 $223,300.00 0.00 %$223,300.00 202-000-000-592-95-80-00 Interest - PWTFL 10th St. NE $0.00 $0.00 $7,500.00 0.00 %$7,500.00 202-000-000-592-95-89-05 Interest - PWTFL 11th St. NE $0.00 $0.00 $298.00 0.00 %$298.00 Total Bond Redemption Fund $0.00 $0.00 $535,811.00 0.00 %$535,811.00 Street Improvements Fund 301-000-000-595-10-40-01 Design 2020 TBD Paving $0.00 $0.00 $30,000.00 0.00 %$30,000.00 301-000-000-595-10-40-02 Design - TIB N. Kentucky Overlay $0.00 $0.00 $80,000.00 0.00 %$80,000.00 301-000-000-595-10-40-03 Design - TIB 3rd/Rock Island Rd. Traffic Signal $0.00 $0.00 $90,000.00 0.00 %$90,000.00 301-000-000-595-10-40-19 Design - TIB 3rd St SE/Highline Dr Roundabout $2,158.25 $2,158.25 $5,000.00 43.17 %$2,841.75 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $0.00 $0.00 $259,087.00 0.00 %$259,087.00 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $0.00 $0.00 $265,321.00 0.00 %$265,321.00 301-000-000-595-10-40-26 Design - PWTFL - 10th St $711.86 $711.86 $320,000.00 0.22 %$319,288.14 301-000-000-595-20-60-01 ROW - PWTFL -10th St. Design $285.71 $285.71 $78,000.00 0.37 %$77,714.29 301-000-000-595-30-40-41 SDC - TIB 3rd St/Highline Roundabout $0.00 $0.00 $75,000.00 0.00 %$75,000.00 301-000-000-595-30-60-00 Construction - TIB 3rd St/Highline Roundabout $0.00 $0.00 $700,000.00 0.00 %$700,000.00 301-000-000-595-30-60-01 SDC 2020 TBD Paving $0.00 $0.00 $20,000.00 0.00 %$20,000.00 301-000-000-595-30-60-02 Construction 2020 TBD Paving $0.00 $0.00 $325,000.00 0.00 %$325,000.00 301-000-000-595-30-60-03 SDC - TIB N. Kentucky Overlay $0.00 $0.00 $45,000.00 0.00 %$45,000.00 301-000-000-595-30-60-04 Construction - TIB N. Kentucky Overlay $0.00 $0.00 $625,000.00 0.00 %$625,000.00 21 of 26 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-595-61-60-00 TIB Complete Streets - Grant/Georgia Crossing $10,025.94 $17,147.61 $75,000.00 22.86 %$57,852.39 301-000-000-595-61-60-01 TIB Complete Streets - Grant/June Crossing $11,792.05 $24,650.21 $100,000.00 24.65 %$75,349.79 301-000-000-595-61-60-02 TIB Complete Streets - 3rd St. Sidewalk $10,505.42 $17,570.61 $225,000.00 7.81 %$207,429.39 301-000-000-595-64-40-01 Design - 9th/VMP Intersection $0.00 $0.00 $156,400.00 0.00 %$156,400.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 Total Street Improvements Fund $35,479.23 $62,524.25 $4,361,908.00 1.43 %$4,299,383.75 Storm Water Improvements Fund 308-000-000-597-00-00-00 Transfer-Out to 401 Fund $0.00 $0.00 $103,090.00 0.00 %$103,090.00 Total Storm Water Improvements Fund $0.00 $0.00 $103,090.00 0.00 %$103,090.00 Capital Improvements Fund 314-000-000-594-22-60-50 Maintenance Facilities Design $0.00 $0.00 $145,000.00 0.00 %$145,000.00 314-000-000-594-48-60-00 Maintenance Facilities Construction $0.00 $0.00 $2,500,000.00 0.00 %$2,500,000.00 314-001-000-597-00-00-01 Transfer-Out to 301 Fund $0.00 $0.00 $150,000.00 0.00 %$150,000.00 Total Capital Improvements Fund $0.00 $0.00 $2,795,000.00 0.00 %$2,795,000.00 Stormwater Fund Stormwater Utility Admin 401-000-001-531-00-10-00 Salaries - Stormwater Admin $2,251.08 $4,319.63 $15,750.00 27.43 %$11,430.37 401-000-001-531-00-20-00 Benefits - Stormwater Admin $841.57 $2,186.34 $6,300.00 34.70 %$4,113.66 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 $59.04 $59.04 $750.00 7.87 %$690.96 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 $283.80 $283.80 $5,000.00 5.68 %$4,716.20 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 $10.67 $67.67 $0.00 ($67.67) Total Stormwater Utility Admin $3,446.16 $6,916.48 $202,800.00 3.41 %$195,883.52 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $1,612.27 $2,190.25 $9,000.00 24.34 %$6,809.75 401-000-002-531-00-20-01 Benefits - NPDES Admin $476.78 $696.09 $3,600.00 19.34 %$2,903.91 401-000-002-531-00-40-02 Repairs & Maint. - NPDES Admin $145.12 $145.12 $0.00 ($145.12) 401-000-002-531-00-40-04 Municipal Stormwater Permit Fee $0.00 $2,535.65 $8,000.00 31.70 %$5,464.35 Total NPDES Admin $2,234.17 $5,567.11 $20,600.00 27.02 %$15,032.89 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 22 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 $6,500.00 0.00 %$6,500.00 401-000-005-531-00-20-04 Benefits - NPDES IDDE $0.00 $0.00 $2,600.00 0.00 %$2,600.00 401-000-005-531-00-30-04 Supplies - NPDES IDDE $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES IDDE $0.00 $0.00 $10,100.00 0.00 %$10,100.00 NPDES Construction 401-000-006-531-00-10-05 Salaries - NPDES Construction $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-006-531-00-20-05 Benefits - NPDES Construction $0.00 $0.00 $600.00 0.00 %$600.00 Total NPDES Construction $0.00 $0.00 $2,100.00 0.00 %$2,100.00 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $0.00 $0.00 $600.00 0.00 %$600.00 Total NPDES Post Construction $0.00 $0.00 $2,100.00 0.00 %$2,100.00 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $2,969.90 $4,424.53 $73,000.00 6.06 %$68,575.47 401-000-008-531-00-10-08 Salaries - Sweeping $2,391.11 $2,391.11 $12,000.00 19.93 %$9,608.89 401-000-008-531-00-20-07 Benefits - NPDES PPGH $1,165.24 $2,420.40 $29,200.00 8.29 %$26,779.60 401-000-008-531-00-20-08 Benefits - Sweeping $1,510.07 $1,510.07 $4,800.00 31.46 %$3,289.93 401-000-008-531-00-30-05 Supplies - NPDES PPGH $49.80 $49.80 $30,000.00 0.17 %$29,950.20 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $126.50 $126.50 $0.00 ($126.50) 401-000-008-531-00-40-05 Rental Equipment $0.00 $0.00 $35,000.00 0.00 %$35,000.00 401-000-008-531-00-40-06 Utilities $150.00 $150.00 $2,200.00 6.82 %$2,050.00 Total NPDES PPGH $8,362.62 $11,072.41 $186,200.00 5.95 %$175,127.59 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-00 Mechanical Sweeper $0.00 $0.00 $355,000.00 0.00 %$355,000.00 401-000-010-594-31-60-01 Storm Sewer Camera $0.00 $0.00 $15,000.00 0.00 %$15,000.00 401-000-010-594-31-60-03 Devon Pond $0.00 $0.00 $15,000.00 0.00 %$15,000.00 Total Capital Outlay $0.00 $0.00 $385,000.00 0.00 %$385,000.00 401-000-011-594-31-60-04 19th Stormwater Facility Design $7,669.50 $7,669.50 $130,000.00 5.90 %$122,330.50 401-000-012-594-31-60-05 Small Improvements Projects $0.00 $0.00 $100,000.00 0.00 %$100,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 $150,000.00 0.00 %$150,000.00 401-000-015-594-31-60-02 ConTech Filter Design $0.00 $0.00 $50,000.00 0.00 %$50,000.00 401-000-016-594-31-60-06 VMP LID Landscape $0.00 $0.00 $20,000.00 0.00 %$20,000.00 Total Stormwater Fund $21,712.45 $31,225.50 $1,341,200.00 2.33 %$1,309,974.50 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $501.90 $1,027.71 $5,000.00 20.55 %$3,972.29 23 of 26 Account Number Title Period Fiscal Budget % of Total Balance 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $215.85 $348.59 $2,600.00 13.41 %$2,251.41 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $10,450.53 $11,373.16 $30,000.00 37.91 %$18,626.84 501-000-000-542-90-10-00 Street Vehicle Repair Labor $2,424.37 $6,040.21 $23,000.00 26.26 %$16,959.79 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $970.29 $2,160.12 $12,000.00 18.00 %$9,839.88 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $2,559.37 $2,599.54 $31,000.00 8.39 %$28,400.46 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $56.38 $77.88 $5,000.00 1.56 %$4,922.12 501-000-000-542-90-48-30 Street Equipment Repairs $0.00 $0.00 $1,600.00 0.00 %$1,600.00 501-000-000-594-21-60-00 Capital Outlay - Police Vehicles $42,323.70 $42,323.70 $58,500.00 72.35 %$16,176.30 501-000-000-594-42-60-20 Capital Outlay - Street Vehicles $0.00 $0.00 $8,000.00 0.00 %$8,000.00 501-000-000-594-42-60-30 Capital - Street Equipment $0.00 $0.00 $250,000.00 0.00 %$250,000.00 Total Equipment Purchase, Repair & Replacement Fund $59,502.39 $65,950.91 $426,700.00 15.46 %$360,749.09 Grand Totals $853,224.45 $1,506,710.19 $20,163,705.00 7.47 %$18,656,994.81 24 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $675,092.95 $1,202,001.48 $7,784,655.00 15.44 %$6,582,653.52 101-000-000-000-00-00-00 Street Fund $53,372.08 $125,894.58 $1,175,872.00 10.71 %$1,049,977.42 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $0.00 $219,619.00 0.00 %$219,619.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $0.00 $0.00 $375,000.00 0.00 %$375,000.00 110-000-000-000-00-00-00 Financing Reserves Fund $0.00 $0.00 $660,000.00 0.00 %$660,000.00 112-000-000-000-00-00-00 Library Fund $657.35 $1,015.37 $6,040.00 16.81 %$5,024.63 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $0.00 $0.00 $205,000.00 0.00 %$205,000.00 117-000-000-000-00-00-00 Events Board Fund $7,408.00 $18,098.10 $173,810.00 10.41 %$155,711.90 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $0.00 $535,811.00 0.00 %$535,811.00 301-000-000-000-00-00-00 Street Improvements Fund $35,479.23 $62,524.25 $4,361,908.00 1.43 %$4,299,383.75 308-000-000-000-00-00-00 Storm Water Improvements Fund $0.00 $0.00 $103,090.00 0.00 %$103,090.00 314-000-000-000-00-00-00 Capital Improvements Fund $0.00 $0.00 $2,795,000.00 0.00 %$2,795,000.00 401-000-000-000-00-00-00 Stormwater Fund $21,712.45 $31,225.50 $1,341,200.00 2.33 %$1,309,974.50 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $59,502.39 $65,950.91 $426,700.00 15.46 %$360,749.09 Grand Totals $853,224.45 $1,506,710.19 $20,163,705.00 7.47 %$18,656,994.81 25 of 26 Beginning Activity Cash In 001 $3,125,890.64 $670,702.74 101 $225,970.94 $346,895.01 102 $77,431.47 $0.00 105 $334,569.98 $35,164.80 110 $660,000.00 $0.00 112 $12,079.33 $0.00 113 $81,632.99 $52,044.79 114 $1,514.77 $1.83 116 $47,204.19 $4,769.69 117 $52,972.21 $250.00 202 $8,668.69 $0.00 301 $940,019.68 $75,535.95 308 $66,058.66 $0.00 314 $1,076,863.08 $160,817.22 401 $0.00 $2,613,274.72 501 $121,658.96 $350,000.00 $6,832,535.59 $4,309,456.75 Cash and Investment Activity Period: 2020 - February 2020 Fiscal Totals Fund Activity Ending Out Cash General Fund $1,202,001.48 $2,594,591.90 Street Fund $125,894.58 $446,971.37 Community Development Grants Fund $0.00 $77,431.47 Transportation Benefit District Fund $0.00 $369,734.78 Financing Reserves Fund $0.00 $660,000.00 Library Fund $1,015.37 $11,063.96 Hotel/Motel Tax Fund $0.00 $133,677.78 Drug Fund $0.00 $1,516.60 Criminal Justice Fund $0.00 $51,973.88 Events Board Fund $18,098.10 $35,124.11 Bond Redemption Fund $0.00 $8,668.69 Street Improvements Fund $62,524.25 $953,031.38 Storm Water Improvements Fund $0.00 $66,058.66 Capital Improvements Fund $0.00 $1,237,680.30 Stormwater Fund $31,225.50 $2,582,049.22 Equipment Purchase, Repair & R l t F d $65,950.91 $405,708.05 $1,506,710.19 $9,635,282.15 26 of 26