Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020 - June 2020 Monthly Financial Report - Josh DeLay, Finance Director
City of East Wenatchee July 21, 2020 City Council Meeting June 2020 Financial Report Date: July 21, 2020 To: Councilmembers, Mayor Crawford & Department Heads From: Josh DeLay, Finance Director Subject: June 2020 Financial Report This report provides a summary of the City’s overall financial operations through June 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 June 30, 2020 compared to revenue collections through June 30, 2019, along with the respective dollar and percentage variances for its operating funds. Table 1 June 30, 2020 June 30, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 3,077,177 3,074,152 3,025 0.10% Street Fund - 101 718,434 1,015,925 (297,491) (29.28%) Events Board Fund - 117 50,320 54,505 (4,185) (7.68%) Equipment R&R Fund - 501 350,000 400,000 (50,000) (12.50%) Total Revenues - Operating Funds 4,195,931 4,544,582 (348,651) (7.67%) 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 July 21, 2020 City Council Meeting June 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 June 30, 2020 compared to revenue collections through June 30, 2019, along with the respective dollar and percentage variances for its non-operating funds. 2 of 26 City of East Wenatchee July 21, 2020 City Council Meeting June 2020 Financial Report Table 2 June 30, 2020 June 30, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 - - - - Trans Benefit District Fund - 105 121,235 126,898 (5,662) (4.46%) Library Fund - 112 3,500 3,500 - - Hotel/Motel Tax Fund - 113 110,618 64,040 46,578 72.73% Drug Fund - 114 8 445 (437) (98.11%) Criminal Justice Fund - 116 9,538 9,187 352 3.83% Bond Redemption Fund - 202 100,000 30,000 70,000 233.33% Street Improvements Fund - 301 170,241 108,048 62,193 57.56% Capital Improvements Fund - 314 278,394 131,960 146,434 110.97% Storm Water Fund - 401 3,105,388 - 3,105,388 - Total Revenues - Non-Operating Funds 3,898,923 474,077 3,424,846 722.42% 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 July 21, 2020 City Council Meeting June 2020 Financial Report Revenue Highlights: General Fund revenues are up $3,025, or .10%, from last year due to: $44,084 increase in property taxes due to how property tax checks have been distributed/receipted to date, and because the City budgeted for this fund to receive $245,000 more property tax than last year; $37,710 increase in sales tax allocation from last year because the City budgeted for this fund to receive $230,000 more sales tax than last year. Overall sales tax collections year over year are down 3.3%; $30,523 increase in fees for building & structure permits; and $20,000 in grant funding from the Washington State Office of Public Defense The above increases are offset by the following decreases from last year: $76,640 less gambling tax due to the City deferring the 1st quarter payment to July 31, 2020 because of COVID-19; $52,036 less phone/cellular utility tax for reasons currently under review; and $31,996 less in interest earnings due to historically low interest rates Street Fund revenues are down $297,491, or 29.28%, 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 $138,920 and $50,000 less in property tax and sales tax, respectively, because the City budgeted less in this fund for each of these revenue sources for 2020. Events Fund revenues are down $4,185, or 7.68%, from last year because the City received no sponsorship dollars or merchandise sales for Classy Chassis due to its cancellation over COVID-19. Equipment R&R Fund revenues are down $50,000, or 12.5%, from last year because the City budgeted for this fund to receive less revenue than last year. Hotel/Motel Tax Fund revenues are up $46,578, or 72.73%, from last year presumably due to an increase in hotel stays in the City. Additionally, this fund now receives all hotel/motel taxes; whereas, last year these taxes were also allocated directly to the Events Fund. Bond Redemption Fund revenues are up $70,000, or 233.33%, from last year due to the fund needing a larger allocation of property tax to start paying off the 10th Street loan debt. Street Improvements Fund revenues are up $62,193, or 57.56%, from last year due to reimbursements from the Transportation Improvement Board for the 3rd Street/Highline roundabout, and reimbursements from the Department of Commerce for the 10th Street loan. Capital Improvements Fund revenues are up $146,434, or 110.97%, from last year due to the increased collection of real estate excise tax presumably due to more and/or larger real estate sales transactions. 4 of 26 City of East Wenatchee July 21, 2020 City Council Meeting June 2020 Financial Report Storm Water Fund revenues are up $3,105,388 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 June 30, 2020 compared to expenditures through June 30, 2019, along with respective dollar and percentage variances for its operating funds. Table 3 June 30, 2020 June 30, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) General Fund - 001 3,514,419 3,560,926 (46,507) (1.31%) Street Fund - 101 475,569 786,402 (310,833) (39.53%) Events Board Fund - 117 43,896 71,145 (27,249) (38.30%) Equipment R&R Fund - 501 204,511 202,966 1,545 0.76% Total Expenditures - Operating Funds 4,238,395 4,621,439 (383,044) (8.29%) 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 July 21, 2020 City Council Meeting June 2020 Financial Report Table 4 below shows the City’s expenditures through June 30, 2020 compared to expenditures through June 30, 2019, along with respective dollar and percentage variances for its non-operating funds. Table 4 June 30, 2020 June 30, 2019 Variance - Higher/(Lower) Percentage Increase/(Decrease) Comm Dev Grants Fund - 102 7,744 - 7,744 - Trans Benefit District Fund - 105 - - - - Debt Reserve Fund - 110 - - - - Library Fund - 112 2,778 2,452 325 13.27% Hotel/Motel Tax Fund - 113 60,000 55,638 4,362 7.84% Bond Redemption Fund - 202 47,842 30,420 17,423 57.27% Street Improvements Fund - 301 1,017,596 205,815 811,782 394.42% Storm Water Improvements Fund - 308 9 31,477 (31,467) (99.97%) Capital Improvements Fund - 314 16,177 334,757 (318,581) (95.17%) Storm Water Fund - 401 264,417 - 264,417 - Total Expenditures - Non-Operating Funds 1,416,563 660,558 756,005 114.45% 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 July 21, 2020 City Council Meeting June 2020 Financial Report Expenditure Highlights: General Fund expenditures are down $46,507, or 1.31%, from last year due to: $240,187 purchase of the Colorado Ave. property last year $19,642 decrease in the cost of network services due to the hiring of an internal IT employee $19,518 decrease in overtime salaries for the Police Department The above decreases are offset by the following increases: General salary and benefit increases, and increases due to retirements and separations $59,960 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. Street Fund expenditures are down $310,833, or 39.53%, 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. Events Fund expenditures are up $27,249, or 38.30%, from last year due to the vacant Events Assistant position, and the fact that all events year-to-date have been cancelled because of the COVID-19 pandemic. Hotel/Motel Tax Fund expenditures are up $4,362, or 7.84%, 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 up $811,782, or 394.42%, from last year due to the Complete Streets, and Safe Routes to School projects currently underway, and the 3rd Street/Highline roundabout project. Most of the cost of all these projects are reimbursed. Capital Improvements Fund expenditures are down $318,581, or 95.17%, from last year due to the expenses related to the Gateway project. Storm Water Fund expenditures are up $264,417 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 June 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 $114,414.69 $605,939.98 $1,245,000.00 48.67 %$639,060.02 001-000-000-313-11-00-00 Local Retail Sales & Use Tax $252,359.45 $1,192,710.05 $3,500,000.00 34.08 %$2,307,289.95 001-000-000-313-71-00-00 Criminal Justice Sales Tax $22,589.75 $146,591.48 $300,000.00 48.86 %$153,408.52 001-000-000-316-40-00-00 Electric Utility Tax $21,180.39 $196,212.83 $355,000.00 55.27 %$158,787.17 001-000-000-316-45-00-00 Natural Gas Utility Tax $1,987.92 $27,863.78 $35,000.00 79.61 %$7,136.22 001-000-000-316-49-00-00 Phone/Cellular Utility Tax $16,425.03 $115,791.65 $350,000.00 33.08 %$234,208.35 001-000-000-316-84-00-00 Gambling Tax $0.00 $108,279.74 $345,000.00 31.39 %$236,720.26 Total Taxes $428,957.23 $2,393,389.51 $6,130,000.00 39.04 %$3,736,610.49 Licenses and Permits 001-000-000-321-30-01-00 Fireworks Permits $300.00 $300.00 $500.00 60.00 %$200.00 001-000-000-321-60-00-00 Taxicab Licenses & Permits $0.00 $186.00 $800.00 23.25 %$614.00 001-000-000-321-91-00-50 Franchise Fees - Cable $0.00 $47,483.66 $97,000.00 48.95 %$49,516.34 001-000-000-321-99-00-00 Business Licenses & Permits $8,481.25 $53,981.43 $107,100.00 50.40 %$53,118.57 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 $14,691.85 $51,334.99 $50,000.00 102.67 %($1,334.99) 001-000-000-322-90-01-00 Gun Permits $425.00 $2,077.00 $6,500.00 31.95 %$4,423.00 001-000-000-322-90-02-00 Sign Permits $0.00 $0.00 $100.00 0.00 %$100.00 Total Licenses and Permits $23,898.10 $156,023.08 $262,650.00 59.40 %$106,626.92 Intergovernmental Revenues 001-000-000-333-16-50-00 Columbia River Drug Task Force $3,770.75 $7,541.50 $7,500.00 100.55 %($41.50) 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 $20,000.00 100.00 %$0.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-71-00 Multimodal Transportation $4,672.20 $4,672.20 $0.00 ($4,672.20) 001-000-000-336-00-98-03 City Assistance $7,625.18 $18,799.51 $0.00 ($18,799.51) 001-000-000-336-06-42-00 Marijuana Excise Tax Distribution $8,086.97 $16,174.09 $21,000.00 77.02 %$4,825.91 001-000-000-336-06-51-00 DUI - Cities Allocation $0.00 $899.39 $2,000.00 44.97 %$1,100.61 001-000-000-336-06-94-00 Liquor Excise Tax $0.00 $39,329.50 $75,000.00 52.44 %$35,670.50 001-000-000-336-06-95-00 Liquor Board Profits $27,511.84 $55,026.75 $107,500.00 51.19 %$52,473.25 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 - June 2020 8 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Intergovernmental Revenues $51,666.94 $183,352.13 $336,470.00 54.49 %$153,117.87 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 $5,000.00 $6,000.00 83.33 %$1,000.00 001-000-000-342-33-00-00 Adult Probation Services $3,525.80 $25,950.63 $70,000.00 37.07 %$44,049.37 001-000-000-342-36-00-00 Housing of Prisoners $1,060.56 $5,137.06 $25,000.00 20.55 %$19,862.94 001-000-000-342-40-00-01 Fire Marshall Inspection Services $323.00 $3,350.00 $5,000.00 67.00 %$1,650.00 001-000-000-345-83-00-00 Plan Checking Fees $9,154.48 $24,305.00 $25,000.00 97.22 %$695.00 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 $488.00 $500.00 97.60 %$12.00 001-000-000-345-89-00-00 Planning & Development Fees $490.00 $2,661.00 $7,500.00 35.48 %$4,839.00 Total Charges for Goods and Services $14,553.84 $67,491.69 $140,635.00 47.99 %$73,143.31 Fines and Penalties 001-000-000-356-50-00-00 Fines And Penalties $11,079.51 $71,473.17 $190,000.00 37.62 %$118,526.83 001-000-000-357-33-00-00 Public Defender Costs $876.80 $6,787.71 $25,000.00 27.15 %$18,212.29 001-000-000-357-35-00-00 Restitution $0.00 $500.00 $150.00 333.33 %($350.00) Total Fines and Penalties $11,956.31 $78,760.88 $215,150.00 36.61 %$136,389.12 Miscellaneous Revenues 001-000-000-361-11-00-00 Interest Earnings $2,520.34 $36,840.06 $100,000.00 36.84 %$63,159.94 001-000-000-361-40-00-00 Sales Tax Interest $365.20 $3,222.08 $5,000.00 64.44 %$1,777.92 001-000-000-362-00-00-00 Rental Income - 311 9th St NE $1,195.00 $6,969.63 $10,000.00 69.70 %$3,030.37 001-000-000-369-80-00-00 Cash Adjustments $6.05 $6.05 $0.00 ($6.05) 001-000-000-369-91-50-00 Miscellaneous Revenue $0.00 $137.50 $7,500.00 1.83 %$7,362.50 Total Miscellaneous Revenues $4,086.59 $47,175.32 $122,500.00 38.51 %$75,324.68 Other Increases in Fund Resources 001-000-000-389-30-00-03 Fireworks - Cleaning Deposit $2,500.00 $2,500.00 $2,200.00 113.64 %($300.00) 001-000-000-389-30-00-04 Fireworks - Dcfd Remittance $300.00 $300.00 $250.00 120.00 %($50.00) 001-000-000-389-30-00-05 Crime Victim Assessment $198.06 $1,273.83 $3,500.00 36.40 %$2,226.17 001-000-000-389-30-00-10 State Surcharge $120.50 $471.50 $500.00 94.30 %$28.50 001-000-000-389-30-00-15 State Share Weapons Permit Fee $641.50 $3,456.25 $9,500.00 36.38 %$6,043.75 001-000-000-389-30-00-20 Court Remittance - State $12,170.16 $73,429.04 $200,000.00 36.71 %$126,570.96 Total Other Increases in Fund Resources $15,930.22 $81,430.62 $215,950.00 37.71 %$134,519.38 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 $22,072.50 $57,063.86 $0.00 ($57,063.86) Total Other Financing Sources $22,072.50 $69,553.66 $1,100.00 6,323.06 %($68,453.66) Total General Fund $573,121.73 $3,077,176.89 $7,424,455.00 41.45 %$4,347,278.11 Street Fund 101-000-000-311-10-00-00 Property Taxes - Street Dept $0.00 $291,901.23 $400,000.00 72.98 %$108,098.77 101-000-000-313-11-00-00 Sales & Use Tax $0.00 $300,000.00 $300,000.00 100.00 %$0.00 9 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-000-322-40-00-00 Street Permits $907.00 $1,227.00 $3,000.00 40.90 %$1,773.00 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 $14,362.98 $111,730.87 $275,000.00 40.63 %$163,269.13 101-000-000-336-00-87-05 Increased Gas Tax $4,088.22 $8,176.90 $16,000.00 51.11 %$7,823.10 101-000-000-369-91-01-05 Miscellaneous Revenue $725.13 $725.13 $0.00 ($725.13) Total Street Fund $20,083.33 $718,433.85 $1,012,000.00 70.99 %$293,566.15 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 $22,690.80 $121,235.40 $40,000.00 303.09 %($81,235.40) Total Transportation Benefit District Fund $22,690.80 $121,235.40 $40,000.00 303.09 %($81,235.40) Library Fund 112-000-000-347-20-00-00 Library Services $3,500.00 $3,500.00 $7,000.00 50.00 %$3,500.00 Total Library Fund $3,500.00 $3,500.00 $7,000.00 50.00 %$3,500.00 Hotel/Motel Tax Fund 113-000-000-313-31-02-00 Hotel/Motel Tax $5,930.30 $110,617.64 $250,000.00 44.25 %$139,382.36 Total Hotel/Motel Tax Fund $5,930.30 $110,617.64 $250,000.00 44.25 %$139,382.36 Drug Fund 114-000-000-356-50-03-00 Drug Investigation $1.54 $8.41 $100.00 8.41 %$91.59 114-000-000-369-30-00-00 Confiscated/forfeited Property $0.00 $0.00 $0.00 $0.00 Total Drug Fund $1.54 $8.41 $100.00 8.41 %$91.59 Criminal Justice Fund 116-000-000-336-06-21-00 Criminal Justice - Population $0.00 $2,078.37 $3,700.00 56.17 %$1,621.63 116-000-000-336-06-26-00 Criminal Justice - Special Programs $0.00 $7,459.99 $14,000.00 53.29 %$6,540.01 Total Criminal Justice Fund $0.00 $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 $0.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 $0.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 $0.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 $100,000.00 $155,000.00 64.52 %$55,000.00 10 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 $100,000.00 $815,000.00 12.27 %$715,000.00 Street Improvements Fund 301-000-000-311-10-00-00 Property Tax $0.00 $20,000.00 $20,000.00 100.00 %$0.00 301-000-000-333-20-00-13 STP 9th/VMP Intersection $5,702.56 $5,702.56 $901,700.00 0.63 %$895,997.44 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 $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 $47,175.69 $124,894.43 $315,000.00 39.65 %$190,105.57 301-000-000-361-10-00-00 Interest Earnings $37.90 $86.63 $0.00 ($86.63) 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 $52,916.15 $170,240.93 $3,584,702.00 4.75 %$3,414,461.07 Capital Improvements Fund 314-000-000-318-34-00-00 Real Estate Excise Tax $26,865.35 $278,388.15 $350,000.00 79.54 %$71,611.85 314-000-000-361-11-00-00 Interest Earnings $6.25 $6.25 $0.00 ($6.25) 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 $26,871.60 $278,394.40 $5,350,000.00 5.20 %$5,071,605.60 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 $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 $45,850.50 $475,569.00 $518,000.00 91.81 %$42,431.00 401-000-000-361-00-00-00 Interest Earnings $65.13 $65.13 $0.00 ($65.13) 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,915.63 $3,105,388.29 $3,386,090.00 91.71 %$280,701.71 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 $751,031.08 $8,094,854.17 $22,630,316.00 35.77 %$14,535,461.83 11 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $573,121.73 $3,077,176.89 $7,424,455.00 41.45 %$4,347,278.11 101-000-000-000-00-00-00 Street Fund $20,083.33 $718,433.85 $1,012,000.00 70.99 %$293,566.15 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 $22,690.80 $121,235.40 $40,000.00 303.09 %($81,235.40) 112-000-000-000-00-00-00 Library Fund $3,500.00 $3,500.00 $7,000.00 50.00 %$3,500.00 113-000-000-000-00-00-00 Hotel/Motel Tax Fund $5,930.30 $110,617.64 $250,000.00 44.25 %$139,382.36 114-000-000-000-00-00-00 Drug Fund $1.54 $8.41 $100.00 8.41 %$91.59 116-000-000-000-00-00-00 Criminal Justice Fund $0.00 $9,538.36 $17,700.00 53.89 %$8,161.64 117-000-000-000-00-00-00 Events Board Fund $0.00 $50,320.00 $173,650.00 28.98 %$123,330.00 202-000-000-000-00-00-00 Bond Redemption Fund $0.00 $100,000.00 $815,000.00 12.27 %$715,000.00 301-000-000-000-00-00-00 Street Improvements Fund $52,916.15 $170,240.93 $3,584,702.00 4.75 %$3,414,461.07 314-000-000-000-00-00-00 Capital Improvements Fund $26,871.60 $278,394.40 $5,350,000.00 5.20 %$5,071,605.60 401-000-000-000-00-00-00 Stormwater Fund $45,915.63 $3,105,388.29 $3,386,090.00 91.71 %$280,701.71 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 $751,031.08 $8,094,854.17 $22,630,316.00 35.77 %$14,535,461.83 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 $125.20 $403.56 $3,000.00 13.45 %$2,596.44 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 $13,365.00 $27,500.00 48.60 %$14,135.00 001-000-001-528-70-40-00 River Com $25,380.31 $152,281.86 $365,000.00 41.72 %$212,718.14 001-000-001-539-30-40-00 Animal Control $6,126.24 $36,757.44 $73,515.00 50.00 %$36,757.56 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 $60,744.00 $121,488.00 50.00 %$60,744.00 001-000-001-564-00-40-00 Comm Mental Health (2% Liquor)$0.00 $1,872.83 $3,600.00 52.02 %$1,727.17 Total General Government $43,983.25 $285,292.14 $660,191.00 43.21 %$374,898.86 Legislative 001-000-110-511-60-10-00 Salaries $12,048.30 $114,580.50 $197,000.00 58.16 %$82,419.50 001-000-110-511-60-20-00 Benefits $3,525.98 $29,047.76 $60,000.00 48.41 %$30,952.24 001-000-110-511-60-21-50 Public Defender $11,645.46 $66,827.30 $135,000.00 49.50 %$68,172.70 001-000-110-511-60-30-00 Public Defender Conflicts $0.00 $2,002.50 $5,500.00 36.41 %$3,497.50 001-000-110-511-60-31-00 Office Supplies $100.66 $723.94 $300.00 241.31 %($423.94) 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 $77.80 $48.80 $200.00 24.40 %$151.20 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 $600.00 $47,397.18 $42,000.00 112.85 %($5,397.18) 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 $0.00 $150.33 $500.00 30.07 %$349.67 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 $0.00 $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 $0.00 $234.92 $13,000.00 1.81 %$12,765.08 001-000-110-511-60-47-00 Background Check Costs $0.00 $77.00 $200.00 38.50 %$123.00 001-000-110-511-60-49-00 Miscellaneous $0.00 $1,835.66 $5,000.00 36.71 %$3,164.34 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 - June 2020 13 of 26 Account Number Title Period Fiscal Budget % of Total Balance Total Legislative $27,998.20 $284,117.23 $512,450.00 55.44 %$228,332.77 Municipal Court 001-000-120-512-50-10-00 Salaries $18,268.84 $104,496.32 $199,000.00 52.51 %$94,503.68 001-000-120-512-50-12-00 Salaries - Probation Services $4,673.08 $28,038.48 $55,000.00 50.98 %$26,961.52 001-000-120-512-50-20-00 Benefits $5,630.15 $33,401.22 $74,000.00 45.14 %$40,598.78 001-000-120-512-50-22-00 Benefits - Probation Services $2,964.86 $17,799.00 $41,000.00 43.41 %$23,201.00 001-000-120-512-50-31-00 Office Supplies $526.52 $822.46 $1,500.00 54.83 %$677.54 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 $788.42 $13,860.00 5.69 %$13,071.58 001-000-120-512-50-49-00 Miscellaneous $27.08 $179.08 $0.00 ($179.08) 001-000-120-512-50-49-01 Interpreting $0.00 $260.00 $5,000.00 5.20 %$4,740.00 001-000-120-512-50-49-02 Judge Protems $75.00 $750.00 $4,000.00 18.75 %$3,250.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 $0.00 $1,052.00 $6,000.00 17.53 %$4,948.00 001-000-120-594-12-60-00 Capital Outlay $252.93 $1,660.05 $5,000.00 33.20 %$3,339.95 Total Municipal Court $32,418.46 $193,202.04 $414,360.00 46.63 %$221,157.96 City Clerk 001-000-140-514-20-10-00 Salaries $6,438.52 $38,839.41 $78,000.00 49.79 %$39,160.59 001-000-140-514-20-20-00 Benefits $3,011.28 $17,556.17 $42,000.00 41.80 %$24,443.83 001-000-140-514-20-31-00 Office Supplies $0.00 $680.98 $3,000.00 22.70 %$2,319.02 001-000-140-514-20-31-01 Central Stores $364.44 $2,720.74 $5,000.00 54.41 %$2,279.26 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 $0.00 $245.00 $1,200.00 20.42 %$955.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 $95.37 $468.18 $2,000.00 23.41 %$1,531.82 001-000-140-514-20-46-00 Insurance $0.00 $623.93 $8,800.00 7.09 %$8,176.07 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 $224.00 $337.50 $1,000.00 33.75 %$662.50 001-000-140-514-30-25-00 Codification $777.42 $777.42 $2,100.00 37.02 %$1,322.58 Total City Clerk $10,911.03 $62,539.51 $148,600.00 42.09 %$86,060.49 Internal Services 001-000-141-514-20-31-01 Office Machine Costs $1,001.41 $1,518.18 $14,000.00 10.84 %$12,481.82 001-000-141-514-20-42-01 Telephone Line Charges $1,198.95 $6,105.90 $14,000.00 43.61 %$7,894.10 001-000-141-514-20-42-03 Postage $0.00 $2,515.65 $7,000.00 35.94 %$4,484.35 001-000-141-514-20-48-00 Repairs & Maintenance $617.36 $4,297.61 $3,000.00 143.25 %($1,297.61) Total Internal Services $2,817.72 $14,437.34 $38,000.00 37.99 %$23,562.66 Finance 001-000-142-514-20-10-00 Salaries $13,534.14 $123,916.28 $210,000.00 59.01 %$86,083.72 001-000-142-514-20-20-00 Benefits $5,940.45 $43,010.80 $95,000.00 45.27 %$51,989.20 001-000-142-514-20-31-00 Office Supplies $484.42 $992.94 $1,700.00 58.41 %$707.06 001-000-142-514-20-43-00 Travel $0.00 $51.52 $1,000.00 5.15 %$948.48 001-000-142-514-20-46-00 Insurance $0.00 $1,459.13 $9,680.00 15.07 %$8,220.87 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 $331.09 $1,791.88 $5,000.00 35.84 %$3,208.12 001-000-142-514-40-20-00 Training $0.00 $125.00 $2,000.00 6.25 %$1,875.00 Total Finance $20,290.10 $171,347.55 $342,380.00 50.05 %$171,032.45 Information Technology 001-000-145-514-20-10-00 Salaries $7,949.86 $47,932.68 $96,000.00 49.93 %$48,067.32 001-000-145-514-20-20-00 Benefits $3,663.64 $21,803.27 $50,000.00 43.61 %$28,196.73 001-000-145-514-20-31-00 Supplies $0.00 $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 $468.18 $468.18 $25,000.00 1.87 %$24,531.82 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 $14,651.11 $15,772.28 $20,645.00 76.40 %$4,872.72 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 $2,635.27 $7,000.00 37.65 %$4,364.73 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 $348.00 $10,430.76 $9,800.00 106.44 %($630.76) 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 $629.59 $7,229.59 $5,000.00 144.59 %($2,229.59) 001-000-145-514-20-42-00 Cell Phone $0.00 $275.82 $750.00 36.78 %$474.18 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-45-00 Insurance $0.00 $591.68 $0.00 ($591.68) 001-000-145-514-20-49-00 Miscellaneous $92.00 $423.20 $0.00 ($423.20) 001-000-145-594-14-60-20 Capital - PC Software Admin $2,024.78 $14,373.68 $20,000.00 71.87 %$5,626.32 001-000-145-594-14-60-25 Capital - PC Hardware Admin $2,416.89 $13,531.42 $50,000.00 27.06 %$36,468.58 Total Information Technology $32,244.05 $147,642.75 $316,895.00 46.59 %$169,252.25 Legal 001-000-151-515-31-10-00 Salaries $16,183.20 $84,450.46 $195,000.00 43.31 %$110,549.54 001-000-151-515-31-20-00 Benefits $6,652.03 $34,352.09 $104,000.00 33.03 %$69,647.91 001-000-151-515-31-20-10 Training ($250.00)$300.00 $2,000.00 15.00 %$1,700.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 $83.39 $300.00 27.80 %$216.61 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 $32.25 $12,100.00 0.27 %$12,067.75 001-000-151-515-31-49-00 Miscellaneous $30.00 $709.00 $3,000.00 23.63 %$2,291.00 001-000-151-515-35-25-05 Litigation Expenses $0.00 $0.00 $10,000.00 0.00 %$10,000.00 Total Legal $22,615.23 $123,141.62 $330,900.00 37.21 %$207,758.38 Civil Service 15 of 26 Account Number Title Period Fiscal Budget % of Total Balance 001-000-160-521-10-10-00 Salaries $260.00 $1,300.00 $3,214.00 40.45 %$1,914.00 001-000-160-521-10-46-00 Insurance $0.00 $32.25 $7,150.00 0.45 %$7,117.75 Total Civil Service $260.00 $1,332.25 $10,364.00 12.85 %$9,031.75 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 $0.00 $1,668.25 $2,000.00 83.41 %$331.75 001-000-180-518-30-35-00 Small Tools & Equipment $0.00 $559.19 $10,000.00 5.59 %$9,440.81 001-000-180-518-30-41-00 Professional Services $997.26 $5,050.25 $25,000.00 20.20 %$19,949.75 001-000-180-518-30-41-01 Contracted Custodial Services $2,426.74 $13,250.14 $24,000.00 55.21 %$10,749.86 001-000-180-518-30-46-00 Insurance $0.00 $64.49 $47,300.00 0.14 %$47,235.51 001-000-180-518-30-47-00 Utilities $1,476.90 $13,568.20 $25,000.00 54.27 %$11,431.80 001-000-180-518-30-48-00 Repairs & Maintenance $0.00 $4,453.55 $12,000.00 37.11 %$7,546.45 001-000-180-518-30-49-00 Miscellaneous $0.00 $18.93 $2,000.00 0.95 %$1,981.07 001-000-180-518-30-49-01 Landscaping $0.00 $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)$178.29 $4,946.14 $6,000.00 82.44 %$1,053.86 001-000-180-594-18-60-00 Capital Outlay $0.00 $1,049.43 $22,000.00 4.77 %$20,950.57 Total Central Services $5,079.19 $44,954.68 $197,300.00 22.78 %$152,345.32 Law Enforcement 001-000-210-521-10-10-00 Salaries $165,524.87 $1,074,532.02 $2,100,000.00 51.17 %$1,025,467.98 001-000-210-521-10-10-02 Overtime Salaries $5,245.76 $67,236.36 $175,000.00 38.42 %$107,763.64 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 $56,984.63 $371,671.93 $900,000.00 41.30 %$528,328.07 001-000-210-521-10-20-01 Clothing Allowance $227.70 $4,379.98 $14,400.00 30.42 %$10,020.02 001-000-210-521-10-31-00 Office Supplies $724.99 $1,907.83 $8,500.00 22.45 %$6,592.17 001-000-210-521-10-31-05 Office Machine Costs $350.50 $1,887.84 $5,000.00 37.76 %$3,112.16 001-000-210-521-10-32-00 Fuel Consumed $2,759.40 $17,074.79 $52,000.00 32.84 %$34,925.21 001-000-210-521-10-35-00 Small Tools & Equipment $1,803.41 $10,849.84 $13,000.00 83.46 %$2,150.16 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 $794.44 $7,597.27 $15,000.00 50.65 %$7,402.73 001-000-210-521-10-42-01 Telephone $461.08 $12,964.56 $28,000.00 46.30 %$15,035.44 001-000-210-521-10-42-03 Postage $0.00 $310.96 $1,200.00 25.91 %$889.04 001-000-210-521-10-43-00 Travel $0.00 $1,751.96 $22,000.00 7.96 %$20,248.04 001-000-210-521-10-46-00 Insurance $1,000.00 $2,761.11 $69,000.00 4.00 %$66,238.89 001-000-210-521-10-48-00 Repairs & Maintenance $191.72 $1,239.70 $8,000.00 15.50 %$6,760.30 001-000-210-521-10-49-00 Miscellaneous $242.75 $2,167.95 $5,500.00 39.42 %$3,332.05 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 $10.83 $28.41 $1,500.00 1.89 %$1,471.59 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 ($390.00)$1,000.00 -39.00 %$1,390.00 001-000-210-521-40-25-00 Training - Officers $1,554.00 $3,129.00 $9,000.00 34.77 %$5,871.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 $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 $237,876.08 $1,665,201.26 $3,493,350.00 47.67 %$1,828,148.74 Jail Services 001-000-230-523-21-10-00 Housing & Monitoring Prisoners $0.00 $171,710.15 $378,000.00 45.43 %$206,289.85 001-000-230-523-60-20-00 Medical Care - Prisoners $482.00 $482.00 $10,000.00 4.82 %$9,518.00 001-000-230-527-60-30-00 Juvenile Detention $0.00 $1,560.00 $6,500.00 24.00 %$4,940.00 Total Jail Services $482.00 $173,752.15 $394,500.00 44.04 %$220,747.85 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,810.12 $46,812.71 $94,000.00 49.80 %$47,187.29 001-000-315-542-10-20-00 Benefits $3,493.42 $20,724.13 $46,000.00 45.05 %$25,275.87 001-000-315-542-10-31-00 Office Supplies $0.00 $0.00 $750.00 0.00 %$750.00 001-000-315-542-10-35-00 Small Tools & Equipment $0.00 $0.00 $500.00 0.00 %$500.00 001-000-315-542-10-40-00 Cell Phone $0.00 $235.82 $750.00 31.44 %$514.18 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 $32.25 $11,000.00 0.29 %$10,967.75 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 $0.00 $1,758.92 $15,000.00 11.73 %$13,241.08 Total Public Works $11,303.54 $69,790.83 $172,500.00 40.46 %$102,709.17 Planning 001-000-580-558-60-10-00 Salaries $14,837.74 $89,297.68 $179,500.00 49.75 %$90,202.32 001-000-580-558-60-20-00 Benefits $5,062.88 $30,047.50 $62,000.00 48.46 %$31,952.50 001-000-580-558-60-31-00 Office Supplies $0.00 $319.10 $1,000.00 31.91 %$680.90 001-000-580-558-60-32-00 Fuel Consumed $28.09 $43.36 $200.00 21.68 %$156.64 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 $20.00 $20.00 $2,000.00 1.00 %$1,980.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 $138.72 $667.59 $3,500.00 19.07 %$2,832.41 001-000-580-558-60-46-00 Insurance $0.00 $64.49 $11,440.00 0.56 %$11,375.51 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,087.43 $121,382.99 $291,840.00 41.59 %$170,457.01 Code Compliance 001-000-590-558-50-10-00 Salaries $8,766.79 $52,513.66 $111,000.00 47.31 %$58,486.34 001-000-590-558-50-20-00 Benefits $4,265.38 $25,433.15 $56,000.00 45.42 %$30,566.85 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 $22.90 $125.63 $460.00 27.31 %$334.37 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-00 Professional Services $5,400.37 $5,400.37 $0.00 ($5,400.37) 001-000-590-558-50-41-01 Fire Marshal Services $0.00 $0.00 $21,500.00 0.00 %$21,500.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 $32.25 $8,690.00 0.37 %$8,657.75 001-000-590-558-50-49-00 Miscellaneous $0.00 $95.00 $300.00 31.67 %$205.00 Total Code Compliance $18,455.44 $83,671.73 $231,025.00 36.22 %$147,353.27 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 $1,502.43 $4,000.00 37.56 %$2,497.57 001-001-000-589-30-00-10 Remittance: State Building Code Surcharge $24.00 $351.00 $500.00 70.20 %$149.00 001-001-000-589-30-00-15 State Share of Permits & Licenses $432.00 $2,806.50 $11,500.00 24.40 %$8,693.50 001-001-000-589-30-00-20 Court Remittances $24,796.95 $67,910.33 $211,000.00 32.18 %$143,089.67 Total Other Expenditures $25,252.95 $72,570.26 $230,000.00 31.55 %$157,429.74 Total General Fund $512,074.67 $3,514,419.09 $7,784,655.00 45.15 %$4,270,235.91 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 $16,845.17 $22,493.86 $80,000.00 28.12 %$57,506.14 101-000-420-542-30-20-00 Benefits - Roadway $10,882.08 $14,776.44 $53,000.00 27.88 %$38,223.56 101-000-420-542-30-30-00 Supplies - Roadway ($1,200.00)$20,192.78 $50,000.00 40.39 %$29,807.22 101-000-420-542-30-48-00 Repairs & Maintenance - Roadway $6,076.00 $6,076.00 $6,000.00 101.27 %($76.00) 101-000-420-542-61-10-00 Salaries - Sidewalks $0.00 $49.23 $4,500.00 1.09 %$4,450.77 101-000-420-542-61-20-00 Benefits - Sidewalks $0.00 $43.58 $2,400.00 1.82 %$2,356.42 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 18 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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,010.00 $13,147.18 $60,000.00 21.91 %$46,852.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 $2,508.92 $46,512.66 $40,000.00 116.28 %($6,512.66) 101-000-420-542-64-20-00 Benefits - Traffic Control Devices $1,140.98 $24,632.64 $23,000.00 107.10 %($1,632.64) 101-000-420-542-64-30-00 Supplies - Traffic Control Devices $2,174.79 $26,199.25 $48,000.00 54.58 %$21,800.75 101-000-420-542-64-47-00 Utilities - Traffic Control Devices $552.33 $3,126.39 $9,000.00 34.74 %$5,873.61 101-000-420-542-64-48-00 Repairs & Maintenance - Traffic Control Devices $0.00 $48.09 $14,000.00 0.34 %$13,951.91 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 $0.00 $42,428.00 $100,000.00 42.43 %$57,572.00 101-000-420-542-66-48-00 Repairs & Maintenance - Snow & Ice Control $0.00 $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 $27.86 $825.93 $2,000.00 41.30 %$1,174.07 101-000-420-542-70-10-00 Salaries - Roadside $13,384.34 $88,757.86 $180,000.00 49.31 %$91,242.14 101-000-420-542-70-20-00 Benefits - Roadside $5,373.18 $44,953.73 $94,000.00 47.82 %$49,046.27 101-000-420-542-70-30-00 Supplies - Roadside $1,191.30 $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 $4,276.24 $36,119.53 $45,000.00 80.27 %$8,880.47 101-000-420-542-75-20-00 Benefits - City Parks $1,742.52 $17,393.85 $23,000.00 75.63 %$5,606.15 101-000-420-542-75-30-00 Supplies - City Parks $64.25 $1,001.15 $15,000.00 6.67 %$13,998.85 101-000-420-542-75-47-00 Utilities - City Parks $48.00 $2,680.46 $4,000.00 67.01 %$1,319.54 101-000-420-542-75-48-00 Repairs & Maintenance - City Parks $38.79 $1,043.37 $4,000.00 26.08 %$2,956.63 101-000-420-542-80-48-00 Japanese Garden Agreement $0.00 $6,000.00 $18,000.00 33.33 %$12,000.00 101-000-420-542-90-10-00 Salaries - Maintenance Admin $243.36 $1,416.24 $0.00 ($1,416.24) 101-000-420-542-90-20-00 Benefits - Maintenance Admin $127.83 $484.65 $0.00 ($484.65) 101-000-430-543-30-10-00 Salaries - General Services $2,006.72 $11,977.01 $0.00 ($11,977.01) 101-000-430-543-30-20-00 Benefits - General Services $783.16 $4,721.32 $0.00 ($4,721.32) 101-000-430-543-30-30-00 Supplies - General Services $351.36 $2,927.13 $6,000.00 48.79 %$3,072.87 101-000-430-543-30-46-00 Insurance $10.64 $320.18 $54,000.00 0.59 %$53,679.82 101-000-430-543-30-49-00 Miscellaneous - General Services $128.02 $1,048.26 $3,000.00 34.94 %$1,951.74 101-000-430-543-50-10-00 Salaries - Facilities $0.00 $1,742.92 $3,000.00 58.10 %$1,257.08 101-000-430-543-50-20-00 Benefits - Facilities $0.00 $681.87 $1,600.00 42.62 %$918.13 101-000-430-543-50-30-00 Supplies - Facilities $0.00 $0.00 $2,000.00 0.00 %$2,000.00 101-000-430-543-50-42-01 Cell Phone $0.00 $235.52 $750.00 31.40 %$514.48 101-000-430-543-50-47-00 Utilities - Facilities $106.66 $2,867.00 $6,000.00 47.78 %$3,133.00 101-000-430-543-50-48-00 Repairs & Maintenance - Facilities $0.00 $0.00 $2,500.00 0.00 %$2,500.00 19 of 26 Account Number Title Period Fiscal Budget % of Total Balance 101-000-430-544-90-10-00 Salaries - Training $0.00 $708.08 $6,500.00 10.89 %$5,791.92 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 $0.00 $1,348.99 $1,000.00 134.90 %($348.99) Total Street Fund $70,894.50 $475,568.71 $1,175,872.00 40.44 %$700,303.29 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 $7,267.50 $7,267.50 $25,300.00 28.73 %$18,032.50 102-000-000-558-70-44-00 CDBG Advertising $476.85 $476.85 $1,600.00 29.80 %$1,123.15 102-000-000-558-70-49-00 CDBG Miscellaneous $0.00 $0.00 $100.00 0.00 %$100.00 Total Community Development Grants Fund $7,744.35 $7,744.35 $219,619.00 3.53 %$211,874.65 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 $164.18 $2,777.57 $4,000.00 69.44 %$1,222.43 112-000-000-572-50-49-00 Facilities - Supplies & Miscellaneous $0.00 $0.00 $40.00 0.00 %$40.00 Total Library Fund $164.18 $2,777.57 $6,040.00 45.99 %$3,262.43 Hotel/Motel Tax Fund 113-000-000-557-30-41-00 Sports Foundation - Special Olympics $0.00 $5,000.00 $0.00 ($5,000.00) 113-000-000-557-30-41-01 EMPD Winter Classic AAU Tournament $0.00 $5,000.00 $0.00 ($5,000.00) 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 $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 $2,096.01 $24,442.02 $78,000.00 31.34 %$53,557.98 117-000-050-557-30-20-00 Benefits $1,662.06 $13,074.11 $41,000.00 31.89 %$27,925.89 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 $12.95 $65.75 $600.00 10.96 %$534.25 117-000-100-557-30-42-00 Cell Phone $0.00 $315.63 $600.00 52.61 %$284.37 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 $175.00 $239.49 $8,360.00 2.86 %$8,120.51 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 $427.91 $500.00 85.58 %$72.09 117-000-200-557-30-46-02 Easter - Office Supplies $0.00 $0.00 $100.00 0.00 %$100.00 20 of 26 Account Number Title Period Fiscal Budget % of Total Balance 117-000-200-557-30-49-02 Easter - Miscellaneous $0.00 $1,805.35 $600.00 300.89 %($1,205.35) 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 $0.00 $259.68 $2,300.00 11.29 %$2,040.32 117-000-300-557-30-42-14 CC - Postage $0.00 $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 $0.00 $1,438.20 $3,000.00 47.94 %$1,561.80 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 $0.00 $749.00 $5,000.00 14.98 %$4,251.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 $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 $3,946.02 $43,895.94 $173,810.00 25.26 %$129,914.06 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 $14,728.88 $14,728.88 $125,000.00 11.78 %$110,271.12 202-000-000-591-95-71-05 Principal - PWTFL 11th St. NE $0.00 $29,712.48 $29,713.00 100.00 %$0.52 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 $3,103.61 $3,103.61 $7,500.00 41.38 %$4,396.39 202-000-000-592-95-89-05 Interest - PWTFL 11th St. NE $0.00 $297.12 $298.00 99.70 %$0.88 Total Bond Redemption Fund $17,832.49 $47,842.09 $535,811.00 8.93 %$487,968.91 Street Improvements Fund 301-000-000-595-10-40-01 Design 2020 TBD Paving $0.00 $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 $0.00 $33,733.34 $259,087.00 13.02 %$225,353.66 301-000-000-595-10-40-24 Design - SRTS - 5th St NE: Kenroy $0.00 $27,873.37 $265,321.00 10.51 %$237,447.63 301-000-000-595-10-40-26 Design - PWTFL - 10th St $0.00 $43,017.05 $320,000.00 13.44 %$276,982.95 301-000-000-595-20-60-01 ROW - PWTFL -10th St. Design $0.00 $14,608.44 $78,000.00 18.73 %$63,391.56 301-000-000-595-30-40-41 SDC - TIB 3rd St/Highline Roundabout $0.00 $11,639.44 $75,000.00 15.52 %$63,360.56 21 of 26 Account Number Title Period Fiscal Budget % of Total Balance 301-000-000-595-30-60-00 Construction - TIB 3rd St/Highline Roundabout $622,206.01 $622,206.01 $700,000.00 88.89 %$77,793.99 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 301-000-000-595-61-60-00 TIB Complete Streets - Grant/Georgia Crossing $3,319.23 $30,219.54 $75,000.00 40.29 %$44,780.46 301-000-000-595-61-60-01 TIB Complete Streets - Grant/June Crossing $47,757.64 $81,262.45 $100,000.00 81.26 %$18,737.55 301-000-000-595-61-60-02 TIB Complete Streets - 3rd St. Sidewalk $93,882.20 $128,644.60 $225,000.00 57.18 %$96,355.40 301-000-000-595-64-40-01 Design - 9th/VMP Intersection $0.00 $15,569.74 $156,400.00 9.96 %$140,830.26 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 $767,165.08 $1,017,596.18 $4,361,908.00 23.33 %$3,344,311.82 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 $12,196.78 $16,176.78 $145,000.00 11.16 %$128,823.22 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 $12,196.78 $16,176.78 $2,795,000.00 0.58 %$2,778,823.22 Stormwater Fund Stormwater Utility Admin 401-000-001-531-00-10-00 Salaries - Stormwater Admin $2,828.32 $14,073.33 $15,750.00 89.35 %$1,676.67 401-000-001-531-00-20-00 Benefits - Stormwater Admin $1,083.27 $6,014.41 $6,300.00 95.47 %$285.59 401-000-001-531-00-30-00 Supplies - Stormwater Admin $0.00 $0.00 $500.00 0.00 %$500.00 401-000-001-531-00-30-01 Small Tools & Equipment $0.00 $0.00 $1,000.00 0.00 %$1,000.00 401-000-001-531-00-40-00 Cell Phone $0.00 $235.82 $750.00 31.44 %$514.18 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 $319.46 $5,000.00 6.39 %$4,680.54 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,911.59 $185,151.35 $202,800.00 91.30 %$17,648.65 NPDES Admin 401-000-002-531-00-10-01 Salaries - NPDES Admin $1,399.31 $9,282.94 $9,000.00 103.14 %($282.94) 401-000-002-531-00-20-01 Benefits - NPDES Admin $520.76 $3,330.39 $3,600.00 92.51 %$269.61 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 $1,920.07 $17,829.74 $20,600.00 86.55 %$2,770.26 NPDES Outreach 401-000-003-531-00-10-02 Salaries - NPDES Outreach $0.00 $0.00 $1,500.00 0.00 %$1,500.00 22 of 26 Account Number Title Period Fiscal Budget % of Total Balance 401-000-003-531-00-20-02 Benefits - NPDES Outreach $0.00 $0.00 $600.00 0.00 %$600.00 401-000-003-531-00-30-02 Supplies - NPDES Outreach $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Outreach $0.00 $0.00 $3,100.00 0.00 %$3,100.00 NPDES Public Involvement 401-000-004-531-00-10-03 Salaries - NPDES Public Involvement $0.00 $0.00 $500.00 0.00 %$500.00 401-000-004-531-00-20-03 Benefits - NPDES Public Involvement $0.00 $0.00 $200.00 0.00 %$200.00 401-000-004-531-00-30-03 Supplies - NPDES Public Involvement $0.00 $0.00 $1,000.00 0.00 %$1,000.00 Total NPDES Public Involvement $0.00 $0.00 $1,700.00 0.00 %$1,700.00 NPDES IDDE 401-000-005-531-00-10-04 Salaries - NPDES IDDE $0.00 $0.00 $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 $91.26 $425.87 $1,500.00 28.39 %$1,074.13 401-000-006-531-00-20-05 Benefits - NPDES Construction $47.94 $119.52 $600.00 19.92 %$480.48 Total NPDES Construction $139.20 $545.39 $2,100.00 25.97 %$1,554.61 NPDES Post Construction 401-000-007-531-00-10-06 Salaries - NPDES Post Construction $0.00 $76.05 $1,500.00 5.07 %$1,423.95 401-000-007-531-00-20-06 Benefits - NPDES Post Construction $0.00 $15.60 $600.00 2.60 %$584.40 Total NPDES Post Construction $0.00 $91.65 $2,100.00 4.36 %$2,008.35 NPDES PPGH 401-000-008-531-00-10-07 Salaries - NPDES PPGH $2,398.68 $9,593.14 $73,000.00 13.14 %$63,406.86 401-000-008-531-00-10-08 Salaries - Sweeping $782.92 $7,893.95 $12,000.00 65.78 %$4,106.05 401-000-008-531-00-20-07 Benefits - NPDES PPGH $1,453.41 $5,696.25 $29,200.00 19.51 %$23,503.75 401-000-008-531-00-20-08 Benefits - Sweeping $160.57 $4,097.79 $4,800.00 85.37 %$702.21 401-000-008-531-00-30-05 Supplies - NPDES PPGH $64.03 $5,821.03 $30,000.00 19.40 %$24,178.97 401-000-008-531-00-40-04 Repairs & Maint. - NPDES PPGH $309.79 $783.26 $0.00 ($783.26) 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 $95.14 $1,711.23 $2,200.00 77.78 %$488.77 Total NPDES PPGH $5,264.54 $35,596.65 $186,200.00 19.12 %$150,603.35 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 $10,918.81 $10,918.81 $15,000.00 72.79 %$4,081.19 401-000-010-594-31-60-03 Devon Pond $0.00 $0.00 $15,000.00 0.00 %$15,000.00 Total Capital Outlay $10,918.81 $10,918.81 $385,000.00 2.84 %$374,081.19 401-000-011-594-31-60-04 19th Stormwater Facility Design $0.00 $13,414.50 $130,000.00 10.32 %$116,585.50 401-000-012-594-31-60-05 Small Improvements Projects $0.00 $695.46 $100,000.00 0.70 %$99,304.54 23 of 26 Account Number Title Period Fiscal Budget % of Total Balance 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 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 $22,154.21 $264,416.95 $1,341,200.00 19.71 %$1,076,783.05 Equipment Purchase, Repair & Replacement Fund 501-000-000-521-10-10-00 Police Vehicle Repair Labor $621.38 $4,086.88 $5,000.00 81.74 %$913.12 501-000-000-521-10-20-00 Police Vehicle Repair Benefits $224.32 $1,970.46 $2,600.00 75.79 %$629.54 501-000-000-521-10-48-00 Police Vehicle Repairs & Maintenance $2,849.83 $23,341.90 $30,000.00 77.81 %$6,658.10 501-000-000-542-90-10-00 Street Vehicle Repair Labor $573.61 $9,772.20 $23,000.00 42.49 %$13,227.80 501-000-000-542-90-20-00 Street Vehicle Repair Benefits $233.89 $4,455.97 $12,000.00 37.13 %$7,544.03 501-000-000-542-90-48-20 Street Vehicle Repairs & Maintenance $1,467.26 $13,148.54 $31,000.00 42.41 %$17,851.46 501-000-000-542-90-48-25 Street Vehicle Repair Supplies $0.00 $2,152.60 $5,000.00 43.05 %$2,847.40 501-000-000-542-90-48-30 Street Equipment Repairs $13.58 $118.08 $1,600.00 7.38 %$1,481.92 501-000-000-594-21-60-00 Capital Outlay - Police Vehicles $0.00 $48,835.83 $58,500.00 83.48 %$9,664.17 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 $96,628.36 $250,000.00 38.65 %$153,371.64 Total Equipment Purchase, Repair & Replacement Fund $5,983.87 $204,510.82 $426,700.00 47.93 %$222,189.18 Grand Totals $1,420,156.15 $5,654,957.89 $20,163,705.00 28.05 %$14,508,747.11 24 of 26 Totals By Fund Fund Number Title Period Fiscal Budget % of Total Balance 001-000-000-000-00-00-00 General Fund $512,074.67 $3,514,419.09 $7,784,655.00 45.15 %$4,270,235.91 101-000-000-000-00-00-00 Street Fund $70,894.50 $475,568.71 $1,175,872.00 40.44 %$700,303.29 102-000-000-000-00-00-00 Community Development Grants Fund $7,744.35 $7,744.35 $219,619.00 3.53 %$211,874.65 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 $164.18 $2,777.57 $6,040.00 45.99 %$3,262.43 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 $3,946.02 $43,895.94 $173,810.00 25.26 %$129,914.06 202-000-000-000-00-00-00 Bond Redemption Fund $17,832.49 $47,842.09 $535,811.00 8.93 %$487,968.91 301-000-000-000-00-00-00 Street Improvements Fund $767,165.08 $1,017,596.18 $4,361,908.00 23.33 %$3,344,311.82 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 $12,196.78 $16,176.78 $2,795,000.00 0.58 %$2,778,823.22 401-000-000-000-00-00-00 Stormwater Fund $22,154.21 $264,416.95 $1,341,200.00 19.71 %$1,076,783.05 501-000-000-000-00-00-00 Equipment Purchase, Repair & Replacement Fund $5,983.87 $204,510.82 $426,700.00 47.93 %$222,189.18 Grand Totals $1,420,156.15 $5,654,957.89 $20,163,705.00 28.05 %$14,508,747.11 25 of 26 Beginning Activity Ending June 2019 Variance Cash In Cash Ending Cash (Decrease)/Increase 001 $3,088,243.67 $3,078,773.29 $2,651,001.47 $2,734,991.58 ($83,990.11) 101 $225,970.94 $719,875.15 $468,836.08 $553,528.77 ($84,692.69) 102 $77,431.47 $0.00 $69,687.12 $77,954.27 ($8,267.15) 105 $334,569.98 $121,235.40 $455,805.38 $506,876.32 ($51,070.94) 110 $660,000.00 $0.00 $660,000.00 $495,000.00 $165,000.00 112 $12,079.33 $3,500.00 $12,801.76 $11,419.53 $1,382.23 113 $81,632.99 $110,617.64 $132,250.63 $84,960.72 $47,289.91 114 $1,514.77 $882.41 $1,523.18 $1,508.90 $14.28 116 $47,204.19 $9,538.36 $56,742.55 $37,550.23 $19,192.32 117 $52,972.21 $50,670.00 $59,396.27 $93,191.26 ($33,794.99) 202 $8,668.69 $100,000.00 $60,826.60 $8,668.69 $52,157.91 301 $940,019.68 $170,240.93 $92,664.43 $519,375.83 ($426,711.40) 308 $66,058.66 $0.00 $66,049.25 $84,113.68 ($18,064.43) 314 $1,076,863.08 $278,394.40 $1,339,080.70 $868,734.16 $470,346.54 401 $0.00 $3,105,388.29 $2,840,971.34 $0.00 $2,840,971.34 501 $121,658.96 $350,000.00 $267,148.14 $328,652.24 ($61,504.10) $6,794,888.62 $8,099,115.87 $9,234,784.90 $6,406,526.18 $2,828,258.72 Cash and Investment Activity Period: 2020 - June 2020Fund Activity Street Fund $477,010.01 Out General Fund $3,516,015.49 Financing Reserves Fund $0.00 Library Fund $2,777.57 Community Development Grants Fund $7,744.35 Transportation Benefit District Fund $0.00 Criminal Justice Fund $0.00 Events Board Fund $44,245.94 Hotel/Motel Tax Fund $60,000.00 Drug Fund $874.00 Storm Water Improvements Fund $9.41 Capital Improvements Fund $16,176.78 Bond Redemption Fund $47,842.09 Street Improvements Fund $1,017,596.18 $5,659,219.59 Stormwater Fund $264,416.95 Equipment Purchase, Repair & Replacement Fund $204,510.82 26 of 26