City Manager's Report, July 2023

City of East Ridge Summary Financial Statement of Revenues and Expenditures Jul-23 FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr % 110 General Fund REVENUE 31100 Property Taxes 6,569,000 0 0.00% 8.33% 31200 Property Taxes (Delinquent) 500,000 0 0.00% 8.33% 31610 Local Sales Tax - Co. Trustee 3,600,000 0 0.00% 8.33% 31611 Incremental State Sales Tax 9,304,398 0 0.00% 8.33% 31710 Wholesale Beer Tax 420,000 0 0.00% 8.33% 31800 State Net Allocation 290,000 0 0.00% 8.33% 31810 Minimum Business Licenses 7,000 0 0.00% 8.33% 31827 5% State Commission 22,000 0 0.00% 8.33% 31912 * Cable TV Franchise Tax 200,000 0 0.00% 8.33% 31961 Liens Collected by Trustee 25,000 0 0.00% 8.33% 32120 Wrecker Licenses 350 0 0.00% 8.33% 32200 Alcoholic Beverage Tax 200,000 0 0.00% 8.33% 32210 Beer Licenses & Etc. 8,000 50 1.25% 8.33% 32220 Liquor Licenses 3,500 0 0.00% 8.33% 32225 Fireworks Fees/Permits 3,000 0 0.00% 8.33% 32226 Annual Fireworks Permit Fee 300 0 0.00% 8.33% 32610 Building Permits 200,000 22,388 0.95% 8.33% 32615 Fire Preventions/Permits 1,000 150 5.00% 8.33% 32620 Electrical Permits 30,000 1,490 3.93% 8.33% 32630 Plumbing Permits 15,000 1,212 8.93% 8.33% 32640 Natural Gas Permits 2,000 420 13.95% 8.33% 32650 Excavating Permits (St. Opening 4,000 3,830 5.00% 8.33% 32660 Zoning Permits 4,000 850 1.25% 8.33% 32671 Regular Sign Permits 3,500 150 3.57% 8.33% 32672 Temporary Sign Permits 300 0 0.00% 8.33% 32690 Plan Review Fees 100 0 0.00% 8.33% 32691 Tree Trimming Permits 100 0 0.00% 8.33% 32905 Other Code Enforcement Fees 25,000 17,411 1.20% 8.33% 32960 Yard Sale Permits 200 ie) 0.00% 8.33% 32990 Mechanical Permits 15,000 1,865 6.40% 8.33% 33140 ARPA Funds - Federal 0 0 0.00% 8.33% 33190 FEMA/TEMA FY 2021 0 0 0.00% 8.33% 33191 Direct Appropriation State of TN 0 0 0.00% 8.33% 33410 State Law Enforcement Education 37,600 0 0.00% 8.33% 33430 State Fire Service Educational Grant 19,200 0 0.00% 8.33% 33510 State Sales Tax 2,627,122 0 0.00% 8.33% 33511 Interstate Telecom. Sales Tax 5,000 0 0.00% 8.33% 33512 Sportsbetting 32,000 0 0.00% 8.33% 33513 Occupcity Tax 1,500 0 0.00% 8.33% 33515 State Sales Tax/Telecommunications 500 0 0.00% 8.33% 33520 State Income Tax 0 0 0.00% 8.33% 33530 ** State Beer Tax 10,192 0 0.00% 8.33% 33540 State Mixed Drink Tax 95,000 0 0.00% 8.33% 33552 State-City Streets And Transportation 40,565 0 0.00% 8.33% 33560 Seized/Awarded by State 0 0 0.00% 8.33% 33591 * TVA- Gross Receipts Tax 266,004 0 0.00% 8.33% 33593 Corporate Excise Tax 6,000 0 0.00% 8.33% 34121 Clerks' Fees - Business Tax 2,000 195 9.75% 8.33% 34211 Accident Report Charges 2,000 116 5.95% 8.33% 34212 Driver Licenses Reinstatement Fee 2,000 50 0.00% 8.33% FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr % 34221 Ridgeside Fire Service Contract 116,604 8,984 8.33% 8.33% 34231 Police Services 0 0 0.00% 8.33% 34314 Mowing 9,800 270 0.00% 8.33% 34500 Donations - New Animal Shelter 5,000 0 0.80% 8.33% 34515 Rabies & Spay/Neuter Cert. 500 0 0.00% 8.33% 34516 Registration 500 25 6.00% 8.33% 34517 Adoption 1,000 150 0.00% 8.33% 34518 Board & Impound Fees 1,000 0 7.00% 8.33% 34520 A/S Donations-Designated 1,000 0 30.00% 8.33% 34641 Indoor Soccer Income 140,000 0 0.00% 8.33% 34642 Community Center Income 40,000 6,487 444% 8.33% 34643 Outdoor Soccer Fees 70,000 4,780 13.89% 8.33% 34644 Baseball Fees 35,000 4,320 19.11% 8.33% 34645 Softball Fees 25,000 2,530 18.20% 8.33% 34646 Gate 30,000 1,883 15.14% 8.33% 34648 Adult League - Softball 30,000 1,000 4.00% 8.33% 34649 Concerts/Events - Camp Jordan 10,000 125 0.00% 8.33% 34651 Multi-Purpose Building (Arena) 140,000 19,347 17.52% 8.33% 34652 Pavilion Rental 18,000 1,175 5.38% 8.33% 34653 Track Rental 2,000 0 0.00% 8.33% 34654 Field Rental 62,000 8,325 10.21% 8.33% 34655, Amphitheater 14,000 0 18.93% 8.33% 34656 Concessions 40,000 3,816 11.33% 8.33% 34657 Overnight - Rv Rental 18,000 1,025 13.15% 8.33% 34658 Tournament Team Fees 1,500 0 0.00% 8.33% 34712 Sponsorship/Parks & Rec 5,000 0 0.00% 8.33% 34720 Football Gate 3,000 0 0.00% 8.33% 34751 Basketball Gate 18,000 0 0.00% 8.33% 34742 Basketball Player Fees 16,000 0 0.00% 8.33% 34743 Football Player Fees 11,000 3,150 41.59% 8.33% 34744 Photography 1,200 0 0.00% 8.33% 34745, Vending/Concessions 8,000 509 5.56% 8.33% 34746 Cheerleading 2,000 0 0.00% 8.33% 34747 Rent-Arena Equipment 25,000 0 8.01% 8.33% 34749 Soccer Field Rentals 60,000 1,520 12.46% 8.33% 34760 Library Charges 1,200 136 5.93% 8.33% 34761 Library - Copies 1,500 73 5.97% 8.33% 34794 Community Center M. Fee 4,000 0 0.00% 8.33% 35100 Municipal Court Fines & Costs 400,000 45,164 4.00% 8.33% 35120 Public Defender Fees 500 0 0.00% 8.33% 35150 Diversion Filing 300 0 0.00% 8.33% 36100 Interest Earnings 5,000 1,883 17.62% 8.33% 36211 Rent - Cell Tower 12,925 1,077 8.33% 8.33% 36310 Sale of Land 0 0 0.00% 8.33% 36330 Sale Of Equipment 10,000 0 0.00% 8.33% 36350 Insurance Recoveries 50,000 0 0.00% 8.33% 36901 Pipes/Culverts 3,000 0 0.00% 8.33% 36902 Repayment - Damages- Traffic Device 0 0 0.00% 8.33% 36903 Christmas Parade 500 0 0.00% 8.33% 36905 Designated Police-Sale of Vehicles 15,000 1,152 24.79% 8.33% 36906 Designated Fire-Sale of Vehicles 5,000 0 0.00% 8.33% 36990 Miscellaneous Revenues 25,000 3,364 0.62% 8.33% 36992 Hamilton County 0 0 0.00% 8.33% 37200 AHO- Fines/Court Costs 1,500 0 0.00% 8.33% Use of Fund Balance 0 1,704,605 0.00% 8.33% Total Revenues 26,091,960 1,876,750 0.47% 8.33% FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr % EXPENDITURES 41000 General Government 1,195,825 86,801 48.89% 8.33% 41100 Administrative 1,051,215 97,737 10.14% 8.33% 41111 City Council 99,490 5,956 8.63% 8.33% 41210 Municipal Court 395,640 28,138 7.24% 8.33% 41520 City Attorney 137,075 0) 0.32% 8.33% 41800 Buildings & Grounds Maintenance 362,274 27,120 9.33% 8.33% 41900 City Hall Complex 51,975 3,518 5.69% 8.33% 42100 Police 2,515,428 773,406 19.15% 8.33% 42121 Criminal Investigation 879,088 50,278 5.87% 8.33% 42123 Patrol 2,500,004 170,431 8.30% 8.33% 42125 Traffic Division 343,290 12,124 4.08% 8.33% 42200 Fire Department 3,292,814 345,083 10.82% 8.33% 42400 Building/Planning/Zoning 642,506 74,902 9.68% 8.33% 43110 Highway And Street 640,288 28,598 7.87% 8.33% 43120 Traffic Control & Street Markers 389,132 25,986 6.32% 8.33% 43170 Transfer Station/Brush Pit/Fleet 9,600 1,380 18.68% 8.33% 44140 Animal Control 339,617 19,643 5.88% 8.33% 44410 Parks and Recreation 1,076,350 71,381 7.39% 8.33% 44420 Multi-Purpose Recreation Bldg 278,454 18,337 10.68% 8.33% 44430 Community Center 253,290 6,021 5.15% 8.33% 44450 McBrien Complex 1,400 146 10.37% 8.33% 44610 Soccer - Recreation 69,400 485 8.00% 8.33% 44620 Soccer - Indoor 72,700 0 0.00% 8.33% 44630 Baseball/Softball 65,700 11,285 5.94% 8.33% 44640 Football/Cheer 15,050 0 0.00% 8.33% 44650 Adult Softball 34,200 0 0.00% 8.33% 44700 Basketball 18,000 0 0.00% 8.33% 44800 Libraries 296,906 17,910 7.29% 8.33% 44810 History Museum 625 84 22.40% 8.33% 46500 Community Development Programs 10,000 0 0.00% 8.33% 43530 Transfer to ARPA Fund 0 0 0.00% 8.33% 47200 Economic Development 6,678,998 0 0.00% 8.33% 49100 Debt Service 96,013 0 0.00% 8.33% 49400 Capital Projects - Transfer Out 2,279,613 ie} 0.00% 8.33% Total Expenditures 26,091,960 1,876,750 8.39% 8.33% Total ## General Fund ——_____0 FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr % 121 State Street Aid REVENUE 33450 State Grant - TIP Funds 415,000 0 0.00% 8.33% 33460 State Grant - HIP Funds 260,000 0 0.00% 8.33% 33550 2017 Gas Tax Improve 200,000 0 0.00% 8.33% 33551 State Gasoline And Motor Fuel Tax 570,000 0 0.00% 8.33% 36100 Interest Earnings 100 15 13.30% 8.33% 36330 Sale of Equipment 0 0 0.00% 8.33% Use of Fund Balance 1,474,849 18,894 0.00% 8.33% Total Revenues and Other Sources 2,919,949 18,909 0.00% 8.33% EXPENDITURES 43190 State Street Aid 2,919,949 18,909 0.62% 8.33% Total Expenditures 2,919,949 18,909 0.62% 8.33% Total ## State Street Aid Fund 0 0 FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr % 122 Grant Fund REVENUE 33109 CSX Transportation Grant - 2022 0 25,000 0.00% 8.33% 33114 TML Driver Safety Grant 4,000 0 0.00% 8.33% 33120 TDOT 2015 Multi Modal Grant 0 0 0.00% 8.33% 33425, Aquatic Stream Clean Grant 1,000 0 0.00% 8.33% 33493 TML Safety Grant 3,000 0 0.00% 8.33% 36100 Interest Earnings 0 2 0.00% 8.33% 36420 Police Traffic Safety Grant 0 0 0.00% 8.33% 36421 TN AM Grants 0 0 0.00% 8.33% 36422 Target Grant 0 0 0.00% 8.33% 36423 Maddie's Fund 0 0 0.00% 8.33% 36711 Safety Conservation Grant 4,000 0 0.00% 8.33% 36920 THS089-Police 0 475 0.00% 8.33% 36921 Homeland Security - Police 0 0 0.00% 8.33% 36922 Homeland Security - Fire 0 0 0.00% 8.33% 36925 Violent Crime Intervention Grant 190,000 0 0.00% 8.33% 36962 Operating Transfers-Capital Projects 0 0 0.00% 8.33% Use of Fund Balance 8.000 0 0.00% 8.33% Total Revenues and Other Sources 210,000 25,476 0.00% 8.33% EXPENDITURES 21211 Due to General Fund 0 0 0.00% 8.33% 43150 Grants 210,000 0 0.00% 8.33% Total Expenditures 210,000 0 0.00% 8.33% Total ## Grant Fund 2 476 FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr% 127 Drug Investigation Fund REVENUE 33197 Federal/State Grants 10,000 0 61.75% 8.33% 33560 Seized/Awarded by State 35,000 2,151 0.00% 8.33% 35200 Drug Fines 20,000 4,562 4.19% 8.33% 35400 Sale of Confiscated Property 2,000 0 0.00% 8.33% Use of Fund Balance 0 0 0.00% 8.33% Total Revenues and Other Sources 67,000 6,713 10.47% 8.33% EXPENDITURES 42129 Drug Investigation and Control 67,000 0 0.00% 8.33% Total Expenditures 67,000 0 0.00% 8.33% Total ## Drug Investigation Fund _0 6.713 FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr % 130 Economic Development Fund REVENUE 316114 Incremental State Sales Tax Rev 6,628,998 0 0.00% 8.33% 36100 Interest Earnings 0 1 0.00% 8.33% Transfer In 0 0 0.00% 8.33% Use of Fund Balance 0 ie) 0.00% 8.33% Total Revenues and Other Sources 6,628,998 1 0.00% 8.33% EXPENDITURES Economic Development 5,557,478 0 0.00% 8.33% Debt Payment 1,071,520 0 0.00% 8.33% Total Expenditures 6,628,998 0 0.00% 8.33% Total ## Economic Development Fund 0 0 FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr% 131 Solid Waste Fund REVENUE 33190 FEMA/TEMA 2021 0 0 0.00% 8.33% 34416 Special Assessment - Garbage 1,629,279 180 0.00% 8.33% 34418 Extra Cans 1,500 240 0.00% 8.33% 34420 Dumpster Rentals 6,000 400 0.00% 8.33% 34422 Recycling - Transfer Station 2,000 694 0.00% 8.33% 34426 Sale Of Mulch 200 12 0.00% 8.33% 34430 Refuse Collection And Disposal 2,000 51 0.00% 8.33% 36330 Sale of Equipment 0 0 0.00% 8.33% 36350 Insurance Recoveries 0 0 0.00% 8.33% Use of Fund Balance 0 598,189 0.00% 8.33% Total Revenues and Other Sources 1,640,979 599,767 0.00% 8.33% EXPENDITURES 43200 Solid Waste 1,640,979 599,767 5.54% 8.33% Total Expenditures 1,640,979 599,767 5.54% 8.33% Total ## Solid Waste Fund LD — CD FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr % 212 TML Loan Fund REVENUE 31920 Room Occupancy Tax 713,774 3,323 0.00% 8.33% 36100 Interest Earnings 1,000 2,335 941.08% 8.33% 37940 Transfer In 1,401,000 0 0.00% 8.33% Use of Fund Balance it) 0 0.00% 8.33% Total Revenues and Other Sources 2,115,774 5,657 0.44% 8.33% EXPENDITURES 49111 Camp Jordan - Phase Two - 2020 145,564 0 0.00% 8.33% 49114 Refunding Bond Issue - 2021 836,763 0 0.00% 8.33% 49300 Series 2022 Bond Issue 726,325 0 0.00% 8.33% 49310 2015 - Exit One/Capital Projects 208,875 0 0.00% 8.33% 49320 2017 - Exit One - I75 0 0 0.00% 8.33% 49412 Public Safety - Lease Purchase 37,800 0 0.00% 8.33% 49413 Public Safety - Capital Outlay Note 106,917 0 0.00% 8.33% 49414 Public Safety - Lease Purchase 53,530 0 0.00% 8.33% 0 0.00% 8.33% Total Expenditures 2,115,774 0 0.00% 8.33% Total ## TML Loan Fund a: FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr% 341 Capital Projects Fund REVENUE 33113 LPRF 2018 - Pioneer Playground 0 0 0.00% 8.33% 33120 TDOT 2015 Multi Modal Grant 3,000,000 0 0.00% 8.33% 33123 Dog Dash Grant 0 0 13.87% 8.33% 34510 Dog Park Donations 0 0 0.00% 8.33% 36421 TN American Water Grant 0 0 0.00% 8.33% 36915 Bond Proceeds 7,000,000 0 0.00% 8.33% 36992 Hamilton County 1,000,000 0 0.00% 8.33% 37940 Operating Transfers - Other Funds 2,279,613 0 0.00% 8.33% Use of Fund Balance 0 279,684 0.00% 8.33% Total Revenues and Other Sources 13,279,613 279,684 7.31% 8.33% EXPENDITURES 41800 Bldg & Grounds/Maintenance 500,000 0 0.00% 8.33% 43110 Multi Modal Project - Ringgold Road 4,000,000 279,684 4.22% 8.33% 43121 North Mack Smith Road 4,850,000 0 0.00% 8.33% 43122 Resurfacing Projects 500,000 0 0.00% 8.33% 43123 Park Ridge Access Road 0 0 0.00% 8.33% 44410 Parks & Recreation 0 0 0.00% 8.33% 44421 Splash Pad/Playground 0 0 0.00% 8.33% 44423 Dog Park - Town Center 0 0 0.00% 8.33% 44424 Animal Shelter Building 1,600,000 0 0.01% 8.33% 44425 Dickert Pond Boardwalk & Pier 0 0 0.00% 8.33% 44426 Fuel Tank - Public Safety Facility 125,000 0 0.00% 8.33% 47200 Economic Development 50,000 {0} 20.00% 8.33% Total Expenditures 11,625,000 279,684 45.40% 8.33% Total ## Capital Projects Fund 1,654,613 0 FISCAL YEAR ENDING 06/30/2024 Year-To-Date by Amount Variance Account Description BUDGET FY 2023 FY 2024 YTD Avg Yr% 410 ARPA FUND REVENUE 37940 Transfer In 0 0 0.00% 8.33% Use of Fund Balance 4,142,192 0 0.00% 8.33% Total Revenues and Other Sources 4,142,192 18 0.00% 8.33% EXPENDITURES 46490 Stormwater Projects - Ringgold Road 4,142,192 0 0.00% 8.33% Total Expenditures 4,142,192 0 0.00% 8.33% Total ## Capital Projects Fund 0 _L_-1B —