Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020 - April 2020 Monthly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee May 19, 2020 City Council Meeting April 2020 Financial Report Date: May 19, 2020 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: April 2020 Financial Report This report provides a summary of the City’s overall financial operations through April 30, 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 April 30, 2020 compared to revenue collections through April 30, 2019, along with the respective dollar and percentage variances for its operating funds. Table 1 April 30, 2020 April 30, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 1,663,658 1,473,907 189,751 12.87% Street Fund - 101 485,760 601,895 (116,135) (19.29%) Events Board Fund - 117 50,320 28,487 21,833 76.64% Equipment R&R Fund - 501 350,000 300,000 50,000 16.67% Total Revenues - Operating Funds 2,549,738 2,404,289 145,449 6.05% 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 May 19, 2020 City Council Meeting April 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 April 30, 2020 compared to revenue collections through April 30, 2019, along with the respective dollar and percentage variances for its non-operating funds. 2 of 26 City of East Wenatchee May 19, 2020 City Council Meeting April 2020 Financial Report Table 2 April 30, 2020 April 30, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 814 - 814 - Trans Benefit District Fund - 105 75,636 72,388 3,248 4.49% Library Fund - 112 - - - - Hotel/Motel Tax Fund - 113 96,533 40,397 56,136 138.96% Drug Fund - 114 880 444 436 98.32% Criminal Justice Fund - 116 9,538 9,187 352 3.83% Bond Redemption Fund - 202 - 30,000 (30,000) (100.00%) Street Improvements Fund - 301 117,325 108,048 9,277 8.59% Capital Improvements Fund - 314 220,442 63,604 156,838 246.58% Storm Water Fund - 401 2,897,252 - 2,897,252 - Total Revenues - Non-Operating Funds 3,418,421 324,068 3,094,353 954.85% 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 May 19, 2020 City Council Meeting April 2020 Financial Report Revenue Highlights: General Fund revenues are up $189,751, or 12.87%, from last year due to: ➢ $65,290 increase in sales tax allocation from last year due to an 8% overall increase in sales tax collections ➢ $47,350 increase in property taxes due to the way the property tax checks have been distributed/receipted to date ➢ $20,000 in grant funding from the Washington State Office of Public Defense ➢ $19,714 reimbursement from RiverCom for Police Department purchases The above increases are offset by the following decreases from last year: ➢ $14,937 less interest earnings due to lower interest rates ➢ $14,667 less electric utility taxes collected Street Fund revenues are down $116,135, or 19.29%, from last year because prior to this year stormwater reimbursements we received from Douglas County as our fiduciary agent were deposited into this fund. Those revenues now go directly into the Stormwater Fund. Additionally, this fund has received $38,920 and $17,572 less in property tax and sales tax, respectively, be cause the City budgeted less in this fund for each of these revenue sources for 2020. Events Fund revenues are up $21,833, or 76.64%, because the Finance Department transferred $50,000 from the Hotel/Motel Tax Fund due to the Events Fund cash balance dipping below $30,000. The City budgeted for a $135,000 transfer, which means this fund is due an additional $85,000 in hotel/motel taxes. However, due to the cancellation of Classy Chassis and less administrative time being spent on events, this will most likely need to be reevaluated, and amended. Equipment R&R Fund revenues are up $50,000, or 16.67%, from last year due to a larger sales tax allocation this year versus last year as approved in the budget. Hotel/Motel Tax Fund revenues are up $56,136, or 138.96%, 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 $9,277, or 8.59%, from last year due to the timing of the receipt of its property tax allocation. Capital Improvements Fund revenues are up $156,838, or 246.58%, from last year due to the increased collection of real estate excise tax presumably due to more and/or larger real estate sales transactions. Storm Water Fund revenues are up $2,897,252 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. 4 of 26 City of East Wenatchee May 19, 2020 City Council Meeting April 2020 Financial Report Table 3 below shows the City’s expenditures through April 30, 2020 compared to expenditures through April 30, 2019, along with respective dollar and percentage variances for its operating funds. Table 3 April 30, 2020 April 30, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 2,466,510 2,442,437 24,074 0.99% Street Fund - 101 313,501 591,017 (277,516) (46.96%) Events Board Fund - 117 35,658 38,476 (2,818) (7.32%) Equipment R&R Fund - 501 182,218 192,767 (10,550) (5.47%) Total Expenditures - Operating Funds 2,997,887 3,264,697 (266,810) (8.17%) Expenditures - Operating Funds Chart 3 is a graphical representation of year to year expenditure comparisons for the City’s operating funds. Chart 3 5 of 26 City of East Wenatchee May 19, 2020 City Council Meeting April 2020 Financial Report Table 4 below shows the City’s expenditures through April 30, 2020 compared to expenditures through April 30, 2019, along with respective dollar and percentage variances for its non-operating funds. Table 4 April 30, 2020 April 30, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - - - - Trans Benefit District Fund - 105 - - - - Debt Reserve Fund - 110 - - - - Library Fund - 112 2,040 1,938 102 5.24% Hotel/Motel Tax Fund - 113 60,000 37,092 22,908 61.76% Bond Redemption Fund - 202 - - - - Street Improvements Fund - 301 165,581 173,074 (7,493) (4.33%) Storm Water Improvements Fund - 308 9 6,367 (6,358) (99.85%) Capital Improvements Fund - 314 3,980 186,972 (182,992) (97.87%) Storm Water Fund - 401 232,903 - 232,903 - Total Expenditures - Non-Operating Funds 464,513 405,443 59,070 14.57% 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 May 19, 2020 City Council Meeting April 2020 Financial Report Expenditure Highlights: General Fund expenditures are up $24,074, or 0.99%, from last year due to: ➢General salary and benefit increases, and increases due to retirements and separations ➢$61,259 increase in bills from 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. This variance will equalize towards year-end. The above increases are offset by the following decreases: ➢$240,187 purchase of the Colorado Ave. property last year ➢$18,964 less spending on Municipal Court capital outlay due to some equipment upgrades that were needed last year Street Fund expenditures are down $277,516, or 46.96%, 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. Additionally, the expenses for storm water activities are no longer accounted for in this fund as they were prior to 2020. Equipment R&R Fund expenditures are down $10,550, or 5.47%, from last year due to the timing of vehicle purchases by the Police and Street departments. Hotel/Motel Tax Fund expenditures are up $22,908, or 61.76%, due to a transfer of $50,000 to the Events Fund. Expenses for the Wenatchee Valley Museum are currently coming out of the General Fund, but those will be moved to this fund by year-end as approved by the Lodging Tax Advisory Committee. Street Improvements Fund expenditures are down $7,493, or 4.33%, from last year due to a decrease in expenditures for the design of 10th Street, and a decrease in materials for the Relight WA project. Capital Improvements Fund expenditures are down $182,992, or 97.87%, from last year due to the expenses related to the Gateway project. Storm Water Fund expenditures are up $232,903 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 April 30, 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 $54,379.46 $66,484.10 $1,245,000.00 5.34 %$1,178,515.90 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $263,542.33 $667,834.40 $3,500,000.00 19.08 %$2,832,165.60 001-000-000-313-71-00-00 Criminal Justice Sales Tax $23,019.93 $103,944.90 $300,000.00 34.65 %$196,055.10 001-000-000-316-40-00-00 Electric Utility Tax $31,144.60 $147,549.09 $355,000.00 41.56 %$207,450.91 001-000-000-316-45-00-00 Natural Gas Utility Tax $4,664.93 $22,837.49 $35,000.00 65.25 %$12,162.51 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $18,378.01 $82,454.82 $350,000.00 23.56 %$267,545.18 001-000-000-316-84-00-00 Gambling Tax $0.00 $108,279.74 $345,000.00 31.39 %$236,720.26 Total Taxes $395,129.26 $1,199,384.54 $6,130,000.00 19.57 %$4,930,615.46 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $0.00 $0.00 $500.00 0.00 %$500.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $62.00 $186.00 $800.00 23.25 %$614.00 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $23,905.02 $97,000.00 24.64 %$73,094.98 001-000-000-321-99-00-00 Business Licenses & Permits $9,533.34 $36,833.18 $107,100.00 34.39 %$70,266.82 001-000-000-321-99-05-00 Other Business Lic & Permits $0.00 $660.00 $650.00 101.54 %($10.00) 001-000-000-322-10-00-00 Building & Structure Permits $521.50 $24,821.29 $50,000.00 49.64 %$25,178.71 001-000-000-322-90-01-00 Gun Permits $42.00 $1,442.00 $6,500.00 22.18 %$5,058.00 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $100.00 0.00 %$100.00 Total Licenses and Permits $10,158.84 $87,847.49 $262,650.00 33.45 %$174,802.51 Intergovernmental Revenues 001-000-000-333-16-50-00 Columbia River Drug Task Force $3,770.75 $3,770.75 $7,500.00 50.28 %$3,729.25 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 $0.00 $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-00-98-03 City Assistance $0.00 $11,174.33 $0.00 ($11,174.33) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $0.00 $8,087.12 $21,000.00 38.51 %$12,912.88 001-000-000-336-06-51-00 DUI - Cities Allocation $449.67 $899.39 $2,000.00 44.97 %$1,100.61 001-000-000-336-06-94-00 Liquor Excise Tax $21,142.98 $39,329.50 $75,000.00 52.44 %$35,670.50 001-000-000-336-06-95-00 Liquor Board Profits $0.00 $27,514.91 $107,500.00 25.60 %$79,985.09 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 - April 2020 8 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Intergovernmental Revenues $25,363.40 $131,685.19 $336,470.00 39.14 %$204,784.81 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 $6,773.13 $20,297.58 $70,000.00 29.00 %$49,702.42 001-000-000-342-36-00-00 Housing of Prisoners $1,203.91 $3,264.70 $25,000.00 13.06 %$21,735.30 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 $290.22 $15,078.21 $25,000.00 60.31 %$9,921.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 $488.00 $488.00 $500.00 97.60 %$12.00 001-000-000-345-89-00-00 Planning & Development Fees $500.00 $1,357.00 $7,500.00 18.09 %$6,143.00 Total Charges for Goods and Services $9,255.26 $44,015.49 $140,635.00 31.30 %$96,619.51 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $14,694.43 $52,668.53 $190,000.00 27.72 %$137,331.47 001-000-000-357-33-00-00 Public Defender Costs $1,881.31 $4,920.44 $25,000.00 19.68 %$20,079.56 001-000-000-357-35-00-00 Restitution $100.00 $400.00 $150.00 266.67 %($250.00) Total Fines and Penalties $16,675.74 $57,988.97 $215,150.00 26.95 %$157,161.03 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $5,069.91 $30,930.87 $100,000.00 30.93 %$69,069.13 001-000-000-361-40-00-00 Sales Tax Interest $513.63 $2,402.26 $5,000.00 48.05 %$2,597.74 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,146.26 $4,579.63 $10,000.00 45.80 %$5,420.37 001-000-000-369-91-50-00 Miscellaneous Revenue $0.00 $137.50 $7,500.00 1.83 %$7,362.50 Total Miscellaneous Revenues $6,729.80 $38,050.26 $122,500.00 31.06 %$84,449.74 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 $258.70 $930.48 $3,500.00 26.59 %$2,569.52 001-000-000-389-30-00-10 State Surcharge $17.50 $344.50 $500.00 68.90 %$155.50 001-000-000-389-30-00-15 State Share Weapons Permit Fee $54.00 $2,294.75 $9,500.00 24.16 %$7,205.25 001-000-000-389-30-00-20 Court Remittance - State $14,543.81 $53,635.28 $200,000.00 26.82 %$146,364.72 Total Other Increases in Fund Resources $14,874.01 $57,205.01 $215,950.00 26.49 %$158,744.99 Other Financing Sources 001-000-000-395-10-00-00 Proceeds - Disposition of Assets $0.00 $12,489.80 $100.00 12,489.80 %($12,389.80) 001-000-000-395-20-00-00 Insurance Recoveries - Capital Assets $0.00 $0.00 $1,000.00 0.00 %$1,000.00 001-000-000-398-10-00-00 Insurance Recoveries $0.00 $34,991.36 $0.00 ($34,991.36) Total Other Financing Sources $0.00 $47,481.16 $1,100.00 4,316.47 %($46,381.16) Total General Fund $478,186.31 $1,663,658.11 $7,424,455.00 22.41 %$5,760,796.89 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $88,758.92 $91,901.23 $400,000.00 22.98 %$308,098.77 101-000-000-313-11-00-00 Sales & Use Tax $0.00 $300,000.00 $300,000.00 100.00 %$0.00 101-000-000-322-40-00-00 Street Permits $0.00 $570.00 $3,000.00 19.00 %$2,430.00 9 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-000-336-00-71-00 Multi-Modal Distribution $0.00 $4,672.72 $18,000.00 25.96 %$13,327.28 101-000-000-336-00-87-00 Gas Tax $20,735.08 $84,526.92 $275,000.00 30.74 %$190,473.08 101-000-000-336-00-87-05 Increased Gas Tax $0.00 $4,088.68 $16,000.00 25.55 %$11,911.32 Total Street Fund $109,494.00 $485,759.55 $1,012,000.00 48.00 %$526,240.45 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 102-000-000-345-89-00-01 Smp - Dct&ls Reimbursement $0.00 $814.00 $0.00 ($814.00) Total Community Development Grants Fund $0.00 $814.00 $219,619.00 0.37 %$218,805.00 Transportation Benefit District Fund 105-000-000-317-60-00-00 Car Tab Fees $22,928.40 $75,636.00 $40,000.00 189.09 %($35,636.00) Total Transportation Benefit District Fund $22,928.40 $75,636.00 $40,000.00 189.09 %($35,636.00) 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 $23,486.55 $96,533.36 $250,000.00 38.61 %$153,466.64 Total Hotel/Motel Tax Fund $23,486.55 $96,533.36 $250,000.00 38.61 %$153,466.64 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $1.26 $6.30 $100.00 6.30 %$93.70 114-000-000-369-30-00-00 Confiscated/forfeited Property $874.00 $874.00 $0.00 ($874.00) Total Drug Fund $875.26 $880.30 $100.00 880.30 %($780.30) Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $1,039.07 $2,078.37 $3,700.00 56.17 %$1,621.63 116-000-000-336-06-26-00 Criminal Justice - Special Programs $3,729.60 $7,459.99 $14,000.00 53.29 %$6,540.01 Total Criminal Justice Fund $4,768.67 $9,538.36 $17,700.00 53.89 %$8,161.64 Events Board Fund 117-000-100-397-00-00-00 Transfer-In from Fund 113 $0.00 $50,000.00 $135,000.00 37.04 %$85,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 ($350.00)$145.00 $9,000.00 1.61 %$8,855.00 117-000-300-347-40-12-03 Classy Chassis Vendor Fees $0.00 $50.00 $150.00 33.33 %$100.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 $25.00 $125.00 $4,500.00 2.78 %$4,375.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 ($325.00)$50,320.00 $173,650.00 28.98 %$123,330.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 10 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 $20,000.00 $20,000.00 $20,000.00 100.00 %$0.00 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 $4,090.30 $19,557.31 $663,000.00 2.95 %$643,442.69 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 $17,649.80 $77,718.74 $315,000.00 24.67 %$237,281.26 301-000-000-361-10-00-00 Interest Earnings $0.00 $48.73 $0.00 ($48.73) 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 $41,740.10 $117,324.78 $3,584,702.00 3.27 %$3,467,377.22 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $33,133.72 $220,441.94 $350,000.00 62.98 %$129,558.06 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 $33,133.72 $220,441.94 $5,350,000.00 4.12 %$5,129,558.06 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 $15,943.23 $62,083.59 $170,000.00 36.52 %$107,916.41 401-000-000-337-00-00-00 Transfer-In from Douglas Co.$0.00 $2,567,670.57 $2,500,000.00 102.71 %($67,670.57) 401-000-000-343-10-00-00 SWU Fee $265,698.00 $267,498.00 $518,000.00 51.64 %$250,502.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 $281,641.23 $2,897,252.16 $3,386,090.00 85.56 %$488,837.84 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 $0.00 $300,000.00 $300,000.00 100.00 %$0.00 Total Equipment Purchase, Repair & Replacement Fund $0.00 $350,000.00 $350,000.00 100.00 %$0.00 Grand Totals $995,929.24 $5,968,158.56 $22,630,316.00 26.37 %$16,662,157.44 11 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $478,186.31 $1,663,658.11 $7,424,455.00 22.41 %$5,760,796.89 101-000-000-000-00-00-00 Street Fund $109,494.00 $485,759.55 $1,012,000.00 48.00 %$526,240.45 102-000-000-000-00-00-00 Community Development Grants Fund $0.00 $814.00 $219,619.00 0.37 %$218,805.00 105-000-000-000-00-00-00 Transportation Benefit District Fund $22,928.40 $75,636.00 $40,000.00 189.09 %($35,636.00) 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 $23,486.55 $96,533.36 $250,000.00 38.61 %$153,466.64 114-000-000-000-00-00-00 Drug Fund $875.26 $880.30 $100.00 880.30 %($780.30) 116-000-000-000-00-00-00 Criminal Justice Fund $4,768.67 $9,538.36 $17,700.00 53.89 %$8,161.64 117-000-000-000-00-00-00 Events Board Fund ($325.00)$50,320.00 $173,650.00 28.98 %$123,330.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 $41,740.10 $117,324.78 $3,584,702.00 3.27 %$3,467,377.22 314-000-000-000-00-00-00 Capital Improvements Fund $33,133.72 $220,441.94 $5,350,000.00 4.12 %$5,129,558.06 401-000-000-000-00-00-00 Stormwater Fund $281,641.23 $2,897,252.16 $3,386,090.00 85.56 %$488,837.84 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $0.00 $350,000.00 $350,000.00 100.00 %$0.00 Grand Totals $995,929.24 $5,968,158.56 $22,630,316.00 26.37 %$16,662,157.44 12 of 26 Account Number Title Period Fiscal Budget % of Total Balance General Fund General Government 001-000-001-518-20-40-00 Property Management - 311 9th St NE $0.00 $7.45 $0.00 ($7.45) 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 $48.99 $169.15 $3,000.00 5.64 %$2,830.85 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 $8,910.00 $27,500.00 32.40 %$18,590.00 001-000-001-528-70-40-00 River Com $25,380.31 $101,521.24 $365,000.00 27.81 %$263,478.76 001-000-001-539-30-40-00 Animal Control $6,126.24 $24,504.96 $73,515.00 33.33 %$49,010.04 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 $15,000.00 $45,000.00 33.33 %$30,000.00 001-000-001-558-70-41-00 NCW Economic Development District $0.00 $0.00 $1,250.00 0.00 %$1,250.00 001-000-001-558-70-41-05 NCWEDD Chelan/Douglas Trends $0.00 $1,500.00 $1,500.00 100.00 %$0.00 001-000-001-558-70-41-07 Wenatchee Valley Chamber of Commerce $0.00 $360.00 $360.00 100.00 %$0.00 001-000-001-558-70-41-10 Spirit of Wenatchee Miss Veedol $0.00 $3,000.00 $3,000.00 100.00 %$0.00 001-000-001-558-70-41-15 Wenatchee Valley Museum $10,124.00 $40,496.00 $121,488.00 33.33 %$80,992.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $958.80 $3,600.00 26.63 %$2,641.20 Total General Government $43,907.04 $196,427.60 $660,191.00 29.75 %$463,763.40 Legislative 001-000-110-511-60-10-00 Salaries $12,452.75 $91,127.26 $197,000.00 46.26 %$105,872.74 001-000-110-511-60-20-00 Benefits $3,738.67 $22,045.15 $60,000.00 36.74 %$37,954.85 001-000-110-511-60-21-50 Public Defender $11,645.46 $43,536.38 $135,000.00 32.25 %$91,463.62 001-000-110-511-60-30-00 Public Defender Conflicts $367.50 $622.50 $5,500.00 11.32 %$4,877.50 001-000-110-511-60-31-00 Office Supplies $90.51 $411.78 $300.00 137.26 %($111.78) 001-000-110-511-60-31-05 Newsletter Printing & Mailing $0.00 $3,991.82 $10,500.00 38.02 %$6,508.18 001-000-110-511-60-31-10 Public Records Expenses ($29.00)($29.00)$200.00 -14.50 %$229.00 001-000-110-511-60-40-00 Training $0.00 $79.81 $3,000.00 2.66 %$2,920.19 001-000-110-511-60-41-00 Professional Services $135.38 $39,939.92 $42,000.00 95.10 %$2,060.08 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 $47.25 $103.38 $500.00 20.68 %$396.62 001-000-110-511-60-43-00 Travel $0.00 $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 $112.50 $503.30 $2,000.00 25.17 %$1,496.70 001-000-110-511-60-45-00 Election Costs - Registered Voters $0.00 $6,257.57 $22,000.00 28.44 %$15,742.43 001-000-110-511-60-46-00 Insurance $25.00 $53.83 $13,000.00 0.41 %$12,946.17 001-000-110-511-60-47-00 Background Check Costs $0.00 $66.00 $200.00 33.00 %$134.00 001-000-110-511-60-49-00 Miscellaneous $267.83 $1,782.87 $5,000.00 35.66 %$3,217.13 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 - April 2020 13 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Legislative $28,853.85 $220,851.41 $512,450.00 43.10 %$291,598.59 Municipal Court 001-000-120-512-50-10-00 Salaries $18,268.84 $67,958.64 $199,000.00 34.15 %$131,041.36 001-000-120-512-50-12-00 Salaries - Probation Services $4,673.08 $18,692.32 $55,000.00 33.99 %$36,307.68 001-000-120-512-50-20-00 Benefits $5,630.15 $22,140.92 $74,000.00 29.92 %$51,859.08 001-000-120-512-50-22-00 Benefits - Probation Services $2,964.86 $11,869.28 $41,000.00 28.95 %$29,130.72 001-000-120-512-50-31-00 Office Supplies $97.99 $97.99 $1,500.00 6.53 %$1,402.01 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 $0.00 $2,005.13 $6,000.00 33.42 %$3,994.87 001-000-120-512-50-46-00 Insurance $0.00 $143.25 $13,860.00 1.03 %$13,716.75 001-000-120-512-50-49-00 Miscellaneous $0.00 $152.00 $0.00 ($152.00) 001-000-120-512-50-49-01 Interpreting $120.00 $260.00 $5,000.00 5.20 %$4,740.00 001-000-120-512-50-49-02 Judge Protems $225.00 $675.00 $4,000.00 16.88 %$3,325.00 001-000-120-512-50-49-03 Witness Fees $0.00 $59.90 $500.00 11.98 %$440.10 001-000-120-512-50-49-04 Juror Fees $0.00 $1,199.98 $2,000.00 60.00 %$800.02 001-000-120-512-50-49-09 Security $206.25 $1,052.00 $6,000.00 17.53 %$4,948.00 001-000-120-594-12-60-00 Capital Outlay $298.49 $1,150.58 $5,000.00 23.01 %$3,849.42 Total Municipal Court $32,484.66 $128,146.99 $414,360.00 30.93 %$286,213.01 City Clerk 001-000-140-514-20-10-00 Salaries $6,438.52 $25,962.37 $78,000.00 33.29 %$52,037.63 001-000-140-514-20-20-00 Benefits $3,011.28 $11,533.61 $42,000.00 27.46 %$30,466.39 001-000-140-514-20-31-00 Office Supplies $34.09 $664.44 $3,000.00 22.15 %$2,335.56 001-000-140-514-20-31-01 Central Stores $231.65 $1,785.01 $5,000.00 35.70 %$3,214.99 001-000-140-514-20-40-00 Training $0.00 $125.00 $2,000.00 6.25 %$1,875.00 001-000-140-514-20-41-00 Membership Dues & Publications $0.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 $225.42 $2,000.00 11.27 %$1,774.58 001-000-140-514-20-46-00 Insurance $0.00 $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 $0.00 $58.58 $750.00 7.81 %$691.42 001-000-140-514-30-20-00 Records Services $113.50 $113.50 $1,000.00 11.35 %$886.50 001-000-140-514-30-25-00 Codification $0.00 $0.00 $2,100.00 0.00 %$2,100.00 Total City Clerk $9,829.04 $40,883.95 $148,600.00 27.51 %$107,716.05 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $103.84 $415.44 $14,000.00 2.97 %$13,584.56 001-000-141-514-20-42-01 Telephone Line Charges $2,297.41 $3,681.11 $14,000.00 26.29 %$10,318.89 001-000-141-514-20-42-03 Postage $2,500.00 $2,515.65 $7,000.00 35.94 %$4,484.35 001-000-141-514-20-48-00 Repairs & Maintenance $663.10 $2,928.10 $3,000.00 97.60 %$71.90 Total Internal Services $5,564.35 $9,540.30 $38,000.00 25.11 %$28,459.70 Finance 001-000-142-514-20-10-00 Salaries $13,534.14 $96,632.92 $210,000.00 46.02 %$113,367.08 001-000-142-514-20-20-00 Benefits $5,705.63 $30,950.26 $95,000.00 32.58 %$64,049.74 001-000-142-514-20-31-00 Office Supplies $131.29 $508.52 $1,700.00 29.91 %$1,191.48 001-000-142-514-20-43-00 Travel $51.52 $51.52 $1,000.00 5.15 %$948.48 001-000-142-514-20-46-00 Insurance $0.00 $28.83 $9,680.00 0.30 %$9,651.17 14 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-142-514-23-20-00 State Audit $0.00 $0.00 $18,000.00 0.00 %$18,000.00 001-000-142-514-25-30-00 Bank Charges & Fees $489.55 $1,217.54 $5,000.00 24.35 %$3,782.46 001-000-142-514-40-20-00 Training $0.00 $0.00 $2,000.00 0.00 %$2,000.00 Total Finance $19,912.13 $129,389.59 $342,380.00 37.79 %$212,990.41 Information Technology 001-000-145-514-20-10-00 Salaries $7,949.86 $32,032.96 $96,000.00 33.37 %$63,967.04 001-000-145-514-20-20-00 Benefits $3,686.25 $14,441.39 $50,000.00 28.88 %$35,558.61 001-000-145-514-20-31-00 Supplies $76.86 $76.86 $1,000.00 7.69 %$923.14 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 $2,057.70 $1,100.00 187.06 %($957.70) 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 $0.00 $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 $1,513.32 $1,513.32 $9,800.00 15.44 %$8,286.68 001-000-145-514-20-40-60 Service Package - Laserfiche (Legal, Police, & Planning) $0.00 $3,462.40 $8,000.00 43.28 %$4,537.60 001-000-145-514-20-41-00 Professional Services $800.00 $6,600.00 $5,000.00 132.00 %($1,600.00) 001-000-145-514-20-42-00 Cell Phone $137.91 $206.95 $750.00 27.59 %$543.05 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 $92.00 $239.20 $0.00 ($239.20) 001-000-145-594-14-60-20 Capital - PC Software Admin $6,946.41 $10,218.97 $20,000.00 51.09 %$9,781.03 001-000-145-594-14-60-25 Capital - PC Hardware Admin $3,133.54 $10,760.52 $50,000.00 21.52 %$39,239.48 Total Information Technology $24,336.15 $88,188.23 $316,895.00 27.83 %$228,706.77 Legal 001-000-151-515-31-10-00 Salaries $16,086.76 $52,180.50 $195,000.00 26.76 %$142,819.50 001-000-151-515-31-20-00 Benefits $6,632.21 $21,067.85 $104,000.00 20.26 %$82,932.15 001-000-151-515-31-20-10 Training $300.00 $550.00 $2,000.00 27.50 %$1,450.00 001-000-151-515-31-25-00 Professional Services $0.00 $3,185.50 $1,500.00 212.37 %($1,685.50) 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 $0.00 $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 $0.00 $14.42 $12,100.00 0.12 %$12,085.58 001-000-151-515-31-49-00 Miscellaneous $0.00 $679.00 $3,000.00 22.63 %$2,321.00 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Legal $23,018.97 $77,706.20 $330,900.00 23.48 %$253,193.80 Civil Service 001-000-160-521-10-10-00 Salaries $260.00 $1,040.00 $3,214.00 32.36 %$2,174.00 15 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-160-521-10-46-00 Insurance $0.00 $14.42 $7,150.00 0.20 %$7,135.58 Total Civil Service $260.00 $1,054.42 $10,364.00 10.17 %$9,309.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 $972.29 $1,478.36 $2,000.00 73.92 %$521.64 001-000-180-518-30-35-00 Small Tools & Equipment $0.00 $250.66 $10,000.00 2.51 %$9,749.34 001-000-180-518-30-41-00 Professional Services $2,903.68 $3,760.90 $25,000.00 15.04 %$21,239.10 001-000-180-518-30-41-01 Contracted Custodial Services $0.00 $6,297.53 $24,000.00 26.24 %$17,702.47 001-000-180-518-30-46-00 Insurance $0.00 $28.83 $47,300.00 0.06 %$47,271.17 001-000-180-518-30-47-00 Utilities $2,477.26 $10,191.95 $25,000.00 40.77 %$14,808.05 001-000-180-518-30-48-00 Repairs & Maintenance $1,083.20 $3,939.12 $12,000.00 32.83 %$8,060.88 001-000-180-518-30-49-00 Miscellaneous $10.82 $10.82 $2,000.00 0.54 %$1,989.18 001-000-180-518-30-49-01 Landscaping $135.38 $312.58 $12,000.00 2.60 %$11,687.42 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)$137.99 $4,666.71 $6,000.00 77.78 %$1,333.29 001-000-180-594-18-60-00 Capital Outlay $0.00 $969.00 $22,000.00 4.40 %$21,031.00 Total Central Services $7,720.62 $31,919.99 $197,300.00 16.18 %$165,380.01 Law Enforcement 001-000-210-521-10-10-00 Salaries $165,304.62 $743,044.00 $2,100,000.00 35.38 %$1,356,956.00 001-000-210-521-10-10-02 Overtime Salaries $6,485.65 $51,487.92 $175,000.00 29.42 %$123,512.08 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 $54,939.32 $259,241.98 $900,000.00 28.80 %$640,758.02 001-000-210-521-10-20-01 Clothing Allowance $1,761.49 $3,158.04 $14,400.00 21.93 %$11,241.96 001-000-210-521-10-31-00 Office Supplies $571.99 $751.70 $8,500.00 8.84 %$7,748.30 001-000-210-521-10-31-05 Office Machine Costs $313.26 $1,247.54 $5,000.00 24.95 %$3,752.46 001-000-210-521-10-32-00 Fuel Consumed $3,338.59 $11,357.77 $52,000.00 21.84 %$40,642.23 001-000-210-521-10-35-00 Small Tools & Equipment $213.19 $4,129.57 $13,000.00 31.77 %$8,870.43 001-000-210-521-10-35-02 WASPC Traffic Safety Grant $0.00 $3,575.53 $3,000.00 119.18 %($575.53) 001-000-210-521-10-35-05 Bulletproof Vests $0.00 $0.00 $4,000.00 0.00 %$4,000.00 001-000-210-521-10-35-06 US Marshall Fugitive Task Force $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-521-10-41-00 Professional Services $3,327.82 $5,897.48 $15,000.00 39.32 %$9,102.52 001-000-210-521-10-42-01 Telephone $3,302.08 $5,646.68 $28,000.00 20.17 %$22,353.32 001-000-210-521-10-42-03 Postage $0.00 $84.74 $1,200.00 7.06 %$1,115.26 001-000-210-521-10-43-00 Travel $50.00 $1,713.88 $22,000.00 7.79 %$20,286.12 001-000-210-521-10-46-00 Insurance $0.00 $317.12 $69,000.00 0.46 %$68,682.88 001-000-210-521-10-48-00 Repairs & Maintenance $331.35 $817.99 $8,000.00 10.22 %$7,182.01 001-000-210-521-10-49-00 Miscellaneous $178.37 $473.37 $5,500.00 8.61 %$5,026.63 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 $0.00 $17.58 $1,500.00 1.17 %$1,482.42 001-000-210-521-30-40-00 Crime Prevention $0.00 $850.00 $850.00 100.00 %$0.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 $190.00 $1,575.00 $9,000.00 17.50 %$7,425.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 $530.31 $530.31 $9,600.00 5.52 %$9,069.69 16 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-210-521-50-10-00 Ancillary (Interfund Vehicle Maintenance) $0.00 $0.00 $2,400.00 0.00 %$2,400.00 001-000-210-521-50-49-00 Other Services $0.00 $0.00 $1,500.00 0.00 %$1,500.00 001-000-210-594-21-60-00 Capital Outlay $0.00 $78,588.65 $33,000.00 238.15 %($45,588.65) Total Law Enforcement $240,838.04 $1,175,062.11 $3,493,350.00 33.64 %$2,318,287.89 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $62,978.46 $140,220.92 $378,000.00 37.10 %$237,779.08 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 $960.00 $6,500.00 14.77 %$5,540.00 Total Jail Services $62,978.46 $141,180.92 $394,500.00 35.79 %$253,319.08 001-000-310-531-30-44-00 Swu - Maint - Advertising $0.00 $19.08 $0.00 ($19.08) 001-000-310-531-30-45-00 Swu Maintenance Rentals/leases $0.00 $23.68 $0.00 ($23.68) Public Works 001-000-315-542-10-10-00 Salaries $7,761.15 $31,192.47 $94,000.00 33.18 %$62,807.53 001-000-315-542-10-20-00 Benefits $3,483.35 $13,737.29 $46,000.00 29.86 %$32,262.71 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 $117.91 $176.95 $750.00 23.59 %$573.05 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 $14.42 $11,000.00 0.13 %$10,985.58 001-000-315-542-10-49-00 Training $0.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 $1,076.26 $1,076.26 $15,000.00 7.18 %$13,923.74 Total Public Works $12,438.67 $46,424.39 $172,500.00 26.91 %$126,075.61 Planning 001-000-580-558-60-10-00 Salaries $14,837.74 $59,622.20 $179,500.00 33.22 %$119,877.80 001-000-580-558-60-20-00 Benefits $5,062.88 $19,921.74 $62,000.00 32.13 %$42,078.26 001-000-580-558-60-31-00 Office Supplies $187.77 $282.13 $1,000.00 28.21 %$717.87 001-000-580-558-60-32-00 Fuel Consumed $0.00 $15.27 $200.00 7.64 %$184.73 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 $355.47 $528.87 $3,500.00 15.11 %$2,971.13 001-000-580-558-60-46-00 Insurance $0.00 $28.83 $11,440.00 0.25 %$11,411.17 001-000-580-558-60-48-00 Repairs & Maintenance $0.00 $8.27 $100.00 8.27 %$91.73 001-000-580-558-60-49-00 Miscellaneous $0.00 $915.00 $2,200.00 41.59 %$1,285.00 Total Planning $20,443.86 $81,322.31 $291,840.00 27.87 %$210,517.69 Code Compliance 001-000-590-558-50-10-00 Salaries $8,766.79 $34,980.08 $111,000.00 31.51 %$76,019.92 001-000-590-558-50-20-00 Benefits $4,265.38 $16,902.39 $56,000.00 30.18 %$39,097.61 001-000-590-558-50-31-00 Office Supplies $0.00 $71.67 $2,200.00 3.26 %$2,128.33 17 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-590-558-50-32-00 Fuel Consumed $0.10 $71.73 $460.00 15.59 %$388.27 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 ($97.00)$21,500.00 -0.45 %$21,597.00 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 $0.00 $14.42 $8,690.00 0.17 %$8,675.58 001-000-590-558-50-49-00 Miscellaneous $0.00 $95.00 $300.00 31.67 %$205.00 Total Code Compliance $13,032.27 $52,038.29 $231,025.00 22.52 %$178,986.71 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 $0.00 $748.96 $4,000.00 18.72 %$3,251.04 001-001-000-589-30-00-10 Remittance: State Building Code Surcharge $107.50 $327.00 $500.00 65.40 %$173.00 001-001-000-589-30-00-15 State Share of Permits & Licenses $566.50 $2,141.50 $11,500.00 18.62 %$9,358.50 001-001-000-589-30-00-20 Court Remittances $15,833.20 $43,113.38 $211,000.00 20.43 %$167,886.62 Total Other Expenditures $16,507.20 $46,330.84 $230,000.00 20.14 %$183,669.16 Total General Fund $562,125.31 $2,466,510.30 $7,784,655.00 31.68 %$5,318,144.70 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) 101-000-311-542-42-20-00 SWU Administration - Benefits $0.00 ($288.52)$0.00 $288.52 Total Storm Water Administration $0.00 $1,415.00 $0.00 ($1,415.00) 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 $801.54 $0.00 ($801.54) 101-000-313-542-42-20-10 NPDES Sweeping Benefits $0.00 $322.24 $0.00 ($322.24) Total NPDES $0.00 $2,034.86 $0.00 ($2,034.86) 101-000-420-542-30-10-00 Salaries - Roadway $32.87 $5,648.69 $80,000.00 7.06 %$74,351.31 101-000-420-542-30-20-00 Benefits - Roadway $36.16 $3,894.36 $53,000.00 7.35 %$49,105.64 101-000-420-542-30-30-00 Supplies - Roadway $173.79 $1,373.79 $50,000.00 2.75 %$48,626.21 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 $14.10 $2,400.00 0.59 %$2,385.90 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 $277.10 $500.00 55.42 %$222.90 101-000-420-542-62-20-00 Benefits - Special Purpose Paths $0.00 $67.29 $250.00 26.92 %$182.71 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 $0.00 $355.20 $2,000.00 17.76 %$1,644.80 101-000-420-542-63-20-00 Benefits - Street Lighting $0.00 $135.32 $1,200.00 11.28 %$1,064.68 101-000-420-542-63-30-00 Supplies - Street Lighting $0.00 $0.00 $500.00 0.00 %$500.00 18 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-420-542-63-47-00 Utilities - Street Lighting $1,902.29 $9,162.18 $60,000.00 15.27 %$50,837.82 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 $23,264.32 $27,100.46 $40,000.00 67.75 %$12,899.54 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $11,842.36 $14,724.78 $23,000.00 64.02 %$8,275.22 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $6,096.96 $22,923.15 $48,000.00 47.76 %$25,076.85 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $584.02 $2,006.99 $9,000.00 22.30 %$6,993.01 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $0.00 $34.44 $14,000.00 0.25 %$13,965.56 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 $347.05 $500.00 69.41 %$152.95 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 $270.00 $500.00 54.00 %$230.00 101-000-420-542-66-10-00 Salaries - Snow & Ice Control $0.00 $9,313.30 $70,000.00 13.30 %$60,686.70 101-000-420-542-66-20-00 Benefits - Snow & Ice Control $0.00 $5,999.65 $47,000.00 12.77 %$41,000.35 101-000-420-542-66-30-00 Supplies - Snow & Ice Control $24.29 $42,428.00 $100,000.00 42.43 %$57,572.00 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $210.60 $2,082.97 $5,000.00 41.66 %$2,917.03 101-000-420-542-69-10-00 Salaries - Flags/Banners $0.00 $1,616.31 $30,000.00 5.39 %$28,383.69 101-000-420-542-69-20-00 Benefits - Flags/Banners $0.00 $618.63 $25,000.00 2.47 %$24,381.37 101-000-420-542-69-30-00 Supplies - Flags/Banners $0.00 $798.07 $2,000.00 39.90 %$1,201.93 101-000-420-542-70-10-00 Salaries - Roadside $7,373.79 $60,715.46 $180,000.00 33.73 %$119,284.54 101-000-420-542-70-20-00 Benefits - Roadside $3,806.33 $31,656.00 $94,000.00 33.68 %$62,344.00 101-000-420-542-70-30-00 Supplies - Roadside $128.29 $514.79 $5,000.00 10.30 %$4,485.21 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 $796.20 $1,000.00 79.62 %$203.80 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 $8,207.97 $25,539.02 $45,000.00 56.75 %$19,460.98 101-000-420-542-75-20-00 Benefits - City Parks $3,694.30 $12,757.88 $23,000.00 55.47 %$10,242.12 101-000-420-542-75-30-00 Supplies - City Parks $168.88 $709.47 $15,000.00 4.73 %$14,290.53 101-000-420-542-75-47-00 Utilities - City Parks $44.00 $769.06 $4,000.00 19.23 %$3,230.94 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $0.00 $625.97 $4,000.00 15.65 %$3,374.03 101-000-420-542-80-48-00 Japanese Garden Agreement $0.00 $3,000.00 $18,000.00 16.67 %$15,000.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 $356.82 $0.00 ($356.82) 101-000-430-543-30-10-00 Salaries - General Services $2,117.99 $7,654.56 $0.00 ($7,654.56) 101-000-430-543-30-20-00 Benefits - General Services $977.69 $3,007.59 $0.00 ($3,007.59) 101-000-430-543-30-30-00 Supplies - General Services $649.31 $2,192.45 $6,000.00 36.54 %$3,807.55 101-000-430-543-30-46-00 Insurance $21.28 $156.27 $54,000.00 0.29 %$53,843.73 101-000-430-543-30-49-00 Miscellaneous - General Services $0.00 $920.24 $3,000.00 30.67 %$2,079.76 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 $613.79 $1,600.00 38.36 %$986.21 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 $117.61 $176.65 $750.00 23.55 %$573.35 101-000-430-543-50-47-00 Utilities - Facilities $524.00 $2,552.58 $6,000.00 42.54 %$3,447.42 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 $0.00 $708.08 $6,500.00 10.89 %$5,791.92 19 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-430-544-90-20-00 Benefits - Training $0.00 $331.56 $3,872.00 8.56 %$3,540.44 101-000-430-544-90-30-00 Supplies - Training $0.00 $14.15 $500.00 2.83 %$485.85 101-000-430-544-90-35-00 Travel $0.00 $27.00 $4,000.00 0.68 %$3,973.00 101-000-430-544-90-49-01 Training $75.00 $108.99 $1,000.00 10.90 %$891.01 Total Street Fund $72,074.10 $313,501.27 $1,175,872.00 26.66 %$862,370.73 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 $327.72 $2,039.86 $4,000.00 51.00 %$1,960.14 112-000-000-572-50-49-00 Facilities - Supplies & Miscellaneous $0.00 $0.00 $40.00 0.00 %$40.00 Total Library Fund $327.72 $2,039.86 $6,040.00 33.77 %$4,000.14 Hotel/Motel Tax Fund 113-000-000-557-30-41-00 First 2% Tax $0.00 $5,000.00 $0.00 ($5,000.00) 113-000-000-557-30-41-10 Contributions to Other Entities $0.00 $5,000.00 $70,000.00 7.14 %$65,000.00 113-001-000-597-00-00-01 Transfer-Out to Fund 117 $0.00 $50,000.00 $135,000.00 37.04 %$85,000.00 Total Hotel/Motel Tax Fund $0.00 $60,000.00 $205,000.00 29.27 %$145,000.00 Events Board Fund 117-000-050-557-30-10-00 Salaries $4,192.10 $20,250.00 $78,000.00 25.96 %$57,750.00 117-000-050-557-30-20-00 Benefits $2,093.06 $9,749.99 $41,000.00 23.78 %$31,250.01 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 $13.95 $39.85 $600.00 6.64 %$560.15 117-000-100-557-30-42-00 Cell Phone $117.91 $256.76 $600.00 42.79 %$343.24 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 $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 $420.86 $420.86 $500.00 84.17 %$79.14 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 $1,671.14 $600.00 278.52 %($1,071.14) 117-000-300-557-30-35-12 CC - Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 20 of 26 Account Number Title Period Fiscal Budget % of Total Balance 117-000-300-557-30-41-12 CC - Professional Services $0.00 $259.68 $2,300.00 11.29 %$2,040.32 117-000-300-557-30-42-14 CC - Postage $758.16 $758.16 $500.00 151.63 %($258.16) 117-000-300-557-30-43-12 CC - EMPD Facility Fee $0.00 $0.00 $1,000.00 0.00 %$1,000.00 117-000-300-557-30-44-12 CC - Advertising $1,086.70 $1,295.70 $3,000.00 43.19 %$1,704.30 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 $497.50 $606.50 $5,000.00 12.13 %$4,393.50 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 $0.00 $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 $9,180.24 $35,658.11 $173,810.00 20.52 %$138,151.89 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 $3,687.16 $3,687.16 $30,000.00 12.29 %$26,312.84 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 $0.00 $5,135.04 $5,000.00 102.70 %($135.04) 301-000-000-595-10-40-23 Design - SRTS - 5th St NE: Sterling $12,044.09 $12,044.09 $259,087.00 4.65 %$247,042.91 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $11,880.87 $11,880.87 $265,321.00 4.48 %$253,440.13 301-000-000-595-10-40-26 Design - PWTFL - 10th St $15,711.04 $21,797.49 $320,000.00 6.81 %$298,202.51 301-000-000-595-20-60-01 ROW - PWTFL -10th St. Design $3,681.86 $8,045.21 $78,000.00 10.31 %$69,954.79 301-000-000-595-30-40-41 SDC - TIB 3rd St/Highline Roundabout $5,903.72 $5,903.72 $75,000.00 7.87 %$69,096.28 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 21 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 301-000-000-595-61-60-00 TIB Complete Streets - Grant/Georgia Crossing $8,195.03 $25,342.64 $75,000.00 33.79 %$49,657.36 301-000-000-595-61-60-01 TIB Complete Streets - Grant/June Crossing $7,296.93 $31,947.14 $100,000.00 31.95 %$68,052.86 301-000-000-595-61-60-02 TIB Complete Streets - 3rd St. Sidewalk $15,634.13 $33,204.74 $225,000.00 14.76 %$191,795.26 301-000-000-595-64-40-01 Design - 9th/VMP Intersection $6,592.55 $6,592.55 $156,400.00 4.22 %$149,807.45 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 $90,627.38 $165,580.65 $4,361,908.00 3.80 %$4,196,327.35 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 308-000-312-595-40-20-00 Benefits - SWA Improvement Projects $0.00 $9.41 $0.00 ($9.41) Total Storm Water Improvements Fund $0.00 $9.41 $103,090.00 0.01 %$103,080.59 Capital Improvements Fund 314-000-000-594-22-60-50 Maintenance Facilities Design $3,980.00 $3,980.00 $145,000.00 2.74 %$141,020.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 $3,980.00 $3,980.00 $2,795,000.00 0.14 %$2,791,020.00 Stormwater Fund Stormwater Utility Admin 401-000-001-531-00-10-00 Salaries - Stormwater Admin $2,697.00 $9,176.44 $15,750.00 58.26 %$6,573.56 401-000-001-531-00-20-00 Benefits - Stormwater Admin $978.40 $4,214.67 $6,300.00 66.90 %$2,085.33 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 $117.91 $176.95 $750.00 23.59 %$573.05 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 $283.80 $5,000.00 5.68 %$4,716.20 401-000-001-531-00-40-03 City Stormwater Utility Charge $0.00 $164,430.00 $165,000.00 99.65 %$570.00 401-000-001-531-00-40-04 Miscellaneous $0.00 $67.67 $0.00 ($67.67) 401-000-001-531-00-40-06 Travel - Stormwater Admin $0.00 $10.66 $0.00 ($10.66) Total Stormwater Utility Admin $3,793.31 $178,360.19 $202,800.00 87.95 %$24,439.81 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $1,693.14 $6,545.15 $9,000.00 72.72 %$2,454.85 401-000-002-531-00-20-01 Benefits - NPDES Admin $542.07 $2,281.85 $3,600.00 63.38 %$1,318.15 401-000-002-531-00-40-02 Repairs & Maint. - NPDES Admin $0.00 $145.12 $0.00 ($145.12) 401-000-002-531-00-40-04 Municipal Stormwater Permit Fee $0.00 $5,071.29 $8,000.00 63.39 %$2,928.71 Total NPDES Admin $2,235.21 $14,043.41 $20,600.00 68.17 %$6,556.59 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 22 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total NPDES Outreach $0.00 $0.00 $3,100.00 0.00 %$3,100.00 NPDES Public Involvement 401-000-004-531-00-10-03 Salaries - NPDES Public Involvement $0.00 $0.00 $500.00 0.00 %$500.00 401-000-004-531-00-20-03 Benefits - NPDES Public Involvement $0.00 $0.00 $200.00 0.00 %$200.00 401-000-004-531-00-30-03 Supplies - NPDES Public Involvement $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Public Involvement $0.00 $0.00 $1,700.00 0.00 %$1,700.00 NPDES IDDE 401-000-005-531-00-10-04 Salaries - NPDES IDDE $0.00 $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 $273.77 $1,500.00 18.25 %$1,226.23 401-000-006-531-00-20-05 Benefits - NPDES Construction $0.00 $59.11 $600.00 9.85 %$540.89 Total NPDES Construction $0.00 $332.88 $2,100.00 15.85 %$1,767.12 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $0.00 $0.00 $1,500.00 0.00 %$1,500.00 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $0.00 $0.00 $600.00 0.00 %$600.00 Total NPDES Post Construction $0.00 $0.00 $2,100.00 0.00 %$2,100.00 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $1,452.85 $6,226.41 $73,000.00 8.53 %$66,773.59 401-000-008-531-00-10-08 Salaries - Sweeping $837.46 $5,855.82 $12,000.00 48.80 %$6,144.18 401-000-008-531-00-20-07 Benefits - NPDES PPGH $822.28 $3,677.84 $29,200.00 12.60 %$25,522.16 401-000-008-531-00-20-08 Benefits - Sweeping $740.10 $3,485.90 $4,800.00 72.62 %$1,314.10 401-000-008-531-00-30-05 Supplies - NPDES PPGH $475.56 $5,457.00 $30,000.00 18.19 %$24,543.00 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $179.67 $462.97 $0.00 ($462.97) 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 $491.14 $1,412.68 $2,200.00 64.21 %$787.32 Total NPDES PPGH $4,999.06 $26,578.62 $186,200.00 14.27 %$159,621.38 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 $2,302.00 $13,414.50 $130,000.00 10.32 %$116,585.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 $173.40 $150,000.00 0.12 %$149,826.60 23 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 $13,329.58 $232,903.00 $1,341,200.00 17.37 %$1,108,297.00 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $167.31 $2,868.01 $5,000.00 57.36 %$2,131.99 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $94.98 $1,474.18 $2,600.00 56.70 %$1,125.82 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $7,569.67 $19,984.45 $30,000.00 66.61 %$10,015.55 501-000-000-542-90-10-00 Street Vehicle Repair Labor $71.70 $8,143.41 $23,000.00 35.41 %$14,856.59 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $40.71 $3,652.77 $12,000.00 30.44 %$8,347.23 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $1,859.39 $5,150.25 $31,000.00 16.61 %$25,849.75 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $513.11 $1,760.08 $5,000.00 35.20 %$3,239.92 501-000-000-542-90-48-30 Street Equipment Repairs $0.00 $104.50 $1,600.00 6.53 %$1,495.50 501-000-000-594-21-60-00 Capital Outlay - Police Vehicles $0.00 $42,451.70 $58,500.00 72.57 %$16,048.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 $96,628.36 $96,628.36 $250,000.00 38.65 %$153,371.64 Total Equipment Purchase, Repair & Replacement Fund $106,945.23 $182,217.71 $426,700.00 42.70 %$244,482.29 Grand Totals $858,589.56 $3,462,400.31 $20,163,705.00 17.17 %$16,701,304.69 24 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $562,125.31 $2,466,510.30 $7,784,655.00 31.68 %$5,318,144.70 101-000-000-000-00-00-00 Street Fund $72,074.10 $313,501.27 $1,175,872.00 26.66 %$862,370.73 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 $327.72 $2,039.86 $6,040.00 33.77 %$4,000.14 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $0.00 $60,000.00 $205,000.00 29.27 %$145,000.00 117-000-000-000-00-00-00 Events Board Fund $9,180.24 $35,658.11 $173,810.00 20.52 %$138,151.89 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 $90,627.38 $165,580.65 $4,361,908.00 3.80 %$4,196,327.35 308-000-000-000-00-00-00 Storm Water Improvements Fund $0.00 $9.41 $103,090.00 0.01 %$103,080.59 314-000-000-000-00-00-00 Capital Improvements Fund $3,980.00 $3,980.00 $2,795,000.00 0.14 %$2,791,020.00 401-000-000-000-00-00-00 Stormwater Fund $13,329.58 $232,903.00 $1,341,200.00 17.37 %$1,108,297.00 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $106,945.23 $182,217.71 $426,700.00 42.70 %$244,482.29 Grand Totals $858,589.56 $3,462,400.31 $20,163,705.00 17.17 %$16,701,304.69 25 of 26 Beginning Activity Ending April 2019 Variance Cash In Cash Ending Cash (Decrease)/Increase 001 $3,088,243.67 $1,663,884.11 $2,285,391.48 $30,088.82 101 $225,970.94 $485,759.55 $398,229.22 $63,160.47 102 $77,431.47 $814.00 $78,245.47 $291.20 105 $334,569.98 $75,636.00 $410,205.98 ($42,160.72) 110 $660,000.00 $0.00 $660,000.00 $165,000.00 112 $12,079.33 $0.00 $10,039.47 $1,605.96 113 $81,632.99 $96,533.36 $118,166.35 $38,302.53 114 $1,514.77 $880.30 $2,395.07 $887.31 116 $47,204.19 $9,538.36 $56,742.55 $19,192.32 117 $52,972.21 $50,670.00 $67,634.10 ($32,250.55) 202 $8,668.69 $0.00 $8,668.69 ($30,419.50) 301 $940,019.68 $117,324.78 $891,763.81 $339,647.33 308 $66,058.66 $0.00 $66,049.25 ($43,174.22) 314 $1,076,863.08 $220,441.94 $1,293,325.02 $345,161.30 401 $0.00 $2,897,252.16 $2,664,349.16 $2,664,349.16 501 $121,658.96 $350,000.00 $289,441.25 $2,255,302.66 $335,068.75 $77,954.27 $452,366.70 $495,000.00 $8,433.51 $79,863.82 $1,507.76 $37,550.23 $99,884.65 $39,088.19 $552,116.48 $109,223.47 $948,163.72 $0.00 $238,856.37 $50,584.88 $6,794,888.62 $5,968,734.56 $9,300,646.87 $5,730,380.58 $3,570,266.29 Cash and Investment Activity Period: 2020 - April 2020 Fund Activity Street Fund $313,501.27 Out General Fund $2,466,736.30 Financing Reserves Fund $0.00 Library Fund $2,039.86 Community Development Grants Fund $0.00 Transportation Benefit District Fund $0.00 Criminal Justice Fund $0.00 Events Board Fund $36,008.11 Hotel/Motel Tax Fund $60,000.00 Drug Fund $0.00 Storm Water Improvements Fund $9.41 Capital Improvements Fund $3,980.00 Bond Redemption Fund $0.00 Street Improvements Fund $165,580.65 $3,462,976.31 Stormwater Fund $232,903.00 Equipment Purchase, Repair & Replacement Fund $182,217.71 26 of 26