112 - FIRE TRUCK FUND 25.00% 112-Fire Truck Fund Details OCT NOV DEC YTD Original Over/ (Under) Budget % of Account Number Account Description Actual Actual Budget Actual Actual Budget Budget 00.4800 Other Rev:Interest on Invest 369 370 339 391 1,130 4,195 (3,065) 26.9% Total Other Revenue 369 370 339 391 1,130 4,195 (3,065) 26.9% 00.4900 Transfer-In 2,083 2,083 2,083 2,083 6,250 25,000 (18,750) 25.0% Total Other Revenue 2,083 2,083 2,083 2,083 6,250 25,000 (18,750) 25.0% TOTAL REVENUE 2,453 2,453 2,423 2,474 7,380 29,195 (21,815) 25.3% 50.9350 Capital Outlay-Equipment 0.0% Total Capital 0.0% 40.9700 Transfer Out 0.0% Total Other Uses 0.0% TOTAL EXPENDITURES 0.0% Revenue Over/(Under) Expenditures 2,453 2,453 2,423 2,474 7,380 29,195 01/18/2024 Page 19 of 47 5 S S 5 8 9 a S S S - 5 S S - f S 115 - COURT SECURITY FUND 25.00% 115-Court Security Fund Details OCT NOV DEC YTD Over/ (Under) Account Number Account Description Actual Actual Budget Actual Actual Original Budget Budget %of Budget 00.4220 Municipal Court: Fees-Court 1,109 1,089 833 1,116 3,313 10,000 (6,687) 33.1% Total Fines & Fees 1,109 1,089 833 1,116 3,313 10,000 (6,687) 33.1% 00.4800 Other Rev:Interest on Invest 76 95 60 30 201 720 (519) 27.9% Total Other Revenue 76 95 60 30 201 720 (519) 27.9% TOTAL REVENUE 1,185 1,183 893 1,146 3,514 10,720 (7,206) 32.8% 50.6000 PeromnisabntuyPartime 45 588 (588) 0.0% 50.6020 Personnel-Salaries Overtime 6 75 (75) 0.0% 50.6036 PersonnelSupplements 0.0% Total Salary & Wages 51 663 (663) 0.0% 50.6030 Personnel.FICA/SS) & MediCare 4 49 (49) 0.0% 50.6045 PersonnelTMRS 12 159 (159) 0.0% Total Taxes & Benefits 16 208 (208) 0.0% 50.6100 Training & Travel 0.0% Total Travel & Training 0.0% 50.6220 Mat/Supplies Court Security 0.0% 50.6270 Ma/Supplestmergeny Eqpt 0.0% 50.6300 Mat/Supples.Uniforms 0.0% Total Materials & Supplies 0.0% 50.8070 Other - Miscellaneous 0.0% Total Other 0.0% 50.9350 Capital Outlay-Equipment 0.0% Total Capital 0.0% TOTAL EXPENDITURES 67 871 (871) 0.0% Revenue Over/(Under) Expenditures 1,185 1,183 826 1,146 3,514 9,849 01/18/2024 Page 21 of 47 S 3 of a 118 - COURT AUTOMATION FUND 25.00% COURT AUTOMATION FUND DETAILS OCT NOV DEC YTD Original Over/(Under) Budget Account Number Account Description Actual Actual Budget Actual Actual Budget % of Budget 00.4230 Municipal Court: Fees-Court 929 919 750 945 2,793 9,000 (6,207) 31.0% Total Fines & Fees 929 919 750 945 2,793 9,000 (6,207) 31.0% 00.4800 Other Rev:Interest in Invest 125 138 100 44 308 1,200 (892) 25.7% Total Other Revenue 125 138 100 44 308 1,200 (892) 25.7% TOTAL REVENUE 1,055 1,057 850 989 3,101 10,200 (7,099) 30.4% 30.6100 Training & Travel 0.0% Total Training & Travel 0.0% 30.6215 Mat/Supplies: Office/Computer 0.0% 30.6230 Mat/Supplies: Office Equipment 27 27 3,250 (3,223) 0.8% 30.6276 Mavsupples:fumshngs 100 (100) 0.0% Total Materials & Supplies 27 27 3,350 (3,323) 0.8% 30.7226 Contractual: Notification Fees 18 30 17 29 77 200 (123) 38.4% 30.7300 Contractual: Computer System 124 173 9,284 7,744 8,040 13,665 (5,624) 58.8% Total Contractual 142 203 9,301 7,773 8,117 13,865 (5,748) 58.5% 30.8070 Other: Miscellaneous 0.0% Total Other 0.0% 30.9010 Capital Outlay.Computer/Off Eq 1,000 (1,000) 0.0% 30.9030 Capital Outlay:Court Equipment 0.0% Total Capital Outlay 1,000 (1,000) 0.0% TOTAL EXPENDITURES 142 203 9,301 7,800 8,144 18,215 (10,071) 44.7% Revenue Over/(Under) Expenditures 913 855 (8,451) (6,811) (5,043) (8,015) 01/18/2024 Page 23 of 47 € a E E a a I : 3 3 E € E E E E à a 6 8 a - - E & * 2 & : E à a & a E o - € I o # 9 I É I 8 120 - ENTERPRISE FUND 25.00% ENTERPRISE FUND DETAILS OCT NOV DEC YTD Original Budget Amended Over/(Under) Budget Amended Budget %0 of Budget Original Budget VS Amended Account Number Account Description Actual Actual Budget Actual Actual Budget 00.4300 Water Sales 137,791 94,531 93,691 87,212 319,534 1,546,597 (1,227,063) 20.7% 1,546,597 00.4305 Sewer Sales 66,857 58,894 58,709 58,432 184,183 769,228 (585,045) 23.9% 769,228 00.4315 Permits & Fees: Connection Fees 240 200 120 140 580 1,440 (860) 40.3% 1,440 00.4318 Permits & Fees:Sewer Tap Fee 130 130 260 (130) 50.0% 260 00.4320 Permits &F Fees: Meter & TapFee 472 480 952 600 352 158.6% 600 Total Water/Sewer Sales & Fees 205,489 153,625 152,520 146,264 505,378 2,318,125 (1,812,746) 21.8% 2,318,125 00.4465 Chrg for Serv:Refuse Collectio 16,681 16,662 16,847 16,699 50,043 203,345 (153,303) 24.6% 203,345 00.4470 Chrg for Serv:Haz' Waste Collection Fee 796 795 799 797 2,387 9,611 (7,224) 24.8% 9,611 Total Charges for Service 17,477 17,457 17,647 17,496 52,430 212,957 (160,526) 24.6% 212,957 00.4800 Other Rev:int from Investments 1,273 1,267 500 445 2,986 6,000 (3,014) 49.8% 6,000 00.4805 Other Rev:Delinquent Charge 809 2,916 1,600 2,198 5,922 19,200 (13,278) 30.8% 19,200 00.4810 Other Rev:Cellular' Tower Lease 0.0% 00.4816 Other Rev: Sales Tax Discount 13 13 5 13 38 63 (25) 60.0% 63 00.4820 Other Rev: Eqpt Damage Reimburs 0.0% 00.4890 Other Rev: Miscellaneous 30 42 90 120 500 (380) 24.0% 500 00.4895 Other Rev: Contributed Capital 14,400 (14,400) 0.0% 14,400 Total Other Revenue 2,125 4,196 2,147 2,746 9,066 40,163 (31,097) 22.6% 40,163 00.4900 Transfer In 0.0% 00.4954 Other Rev: Prop/Liab Reimb 0.0% 00.4955 Lease Proceeds 0.0% 00.4960 Proceeds from Sale 0.0% Total Other Financing Sources 0.0% TOTALI REVENUES 225,091 175,277 172,314 166,506 566,874 2,571,244 (2,004,370) 22.0% 2,571,244 40.6000 Personnel-Salaries Full Time 22,443 18,242 22,503 14,065 54,751 292,535 (237,784) 18.7% 292,535 40.6005 Personnel-Salaries Part Time 1,449 1,601 1,500 1,427 4,477 19,500 (15,023) 23.0% 19,500 40.6015 Personnel:Salaries Standby 640 640 855 396 1,675 11,117 (9,442) 15.1% 11,117 40.6020 PersonnelSalaries Overtime 579 1,208 1,200 430 2,217 15,605 (13,388) 14.2% 15,605 40.6025 Personnel-Salaries Sick Leave 1,384 517 517 1,384 (867) 37.3% 1,384 40.6036 PerionnelSupplements: 763 2,301 850 2,301 5,365 11,046 (5,682) 48.6% 11,046 40.6050 Personnel-Servicel Pay-Longevit 712 712 876 (164) 81.3% 876 Total Salary & Wages 25,873 24,703 28,292 19,136 69,713 352,063 (282,350) 19.8% 352,063 01/18/2024 Page 26 of 47 120 - ENTERPRISE FUND 25.00% ENTERPRISE FUND DETAILS OCT NOV DEC YTD Original Budget Amended Over/(Under) Budget Amended Budget %0 of Budget Original Budget VS Amended Account Number Account Description Actual Actual Budget Actual Actual Budget 40.6027 Personnel: Pre-Employment Screening 0.0% 40.6028 Personnel: Recruiting Costs 0.0% 40.6030 Personnel.FICAISS) & MediCare 1,918 1,835 2,004 1,400 5,153 26,053 (20,899) 19.8% 26,053 40.6031 Personnel:: SUTA Taxes 45 (45) 0.0% 45 40.6042 Per:ionnelERUie/AD8D Ins 14 11 14 11 35 172 (136) 20.6% 172 40.6045 Personnel.TMRS 5,422 5,129 6,105 3,932 14,482 79,365 (64,882) 18.2% 79,365 40.6046 Personnel:ER Long Term Disab 49 37 51 37 123 613 (490) 20.1% 613 40.6047 Personnel.Employee Health Ins 3,460 2,248 4,027 1,827 7,535 48,330 (40,795) 15.6% 48,330 40.6048 PersonnelHSA/HRA 781 610 842 610 2,001 10,100 (8,099) 19.8% 10,100 40.6049 Personnel: ER Short Term Disab 46 35 47 35 116 570 (454) 20.4% 570 40.6099 Personnel.TMRS OPED Supplemental Exp 1,000 (1,000) 0.0% 1,000 Total Taxes & Benefits 11,690 9,904 13,091 7,851 29,445 166,247 (136,801) 17.7% 166,247 40.6100 Training & Travel 831 644 71 902 7,734 (6,832) 11.7% 7,734 Total Training &Travel 831 644 71 902 7,734 (6,832) 11.7% 7,734 40.6205 Mat/Supplies: Legal Notices 0.0% 40.6215 Mat/Supplies: Office Supplies 16 (16) 0.0% 16 40.6230 Mat/Supplies: Office Equipment 130 130 1,050 (920) 12.4% 1,050 40.6235 Mat/Supplies: Records Mgmt 400 (400) 0.0% 400 40.6240 Mat/Supplies: Printing 386 386 396 386 1,158 4,752 (3,594) 24.4% 4,752 40.6245 Mat/Supplies: Postage 462 459 478 458 1,379 5,740 (4,361) 24.0% 5,740 40.6250 Mat/Supplies: Water Systems 59 108 59 1,300 (1,241) 4.5% 1,300 40.6275 Mat/Supplies: Equipment 2,000 (2,000) 0.0% 2,000 40.6276 Mat/Supplies: Furnishings 0.0% 40.6300 Mat/Supplies: Uniforms 37 210 37 2,524 (2,487) 1.5% 2,524 40.6315 Mat/Supplies: Other 13 157 (157) 0.0% 157 40.6350 Mat/Supplies: Fuel 536 487 588 391 1,414 7,052 (5,637) 20.1% 7,052 40.6400 Mat/Supplies: Tools & Supplies 5 1,683 125 1,688 1,500 188 112.6% 1,500 40.6410 Mat/Supplies: Weed & Pest Control 8 100 (100) 0.0% 100 40.6450 Mat/Supplies: Testing Supplies 167 543 543 2,000 (1,457) 27.2% 2,000 40.6499 Mat/Supplies: O/H Cost Expense 253 102 484 410 766 5,809 (5,043) 13.2% 5,809 Total Materials & Supplies 1,701 3,285 2,578 2,189 7,175 34,400 (27,226) 20.9% 34,400 40.6500 Utilities: Electricity 1,992 2,033 1,411 1,295 5,320 18,147 (12,827) 29.3% 18,147 40.6505 Utilities:Gas 4 6 12 9 20 101 (81) 19.5% 101 40.6510 Utilities: Telephone 43 43 50 43 130 600 (470) 21.6% 600 40.6515 Utilities: Water & Sewer 16 14 12 16 47 157 (111) 29.6% 157 40.6520 Utilities: Mobile Data Terminal 55 55 83 55 164 990 (826) 16.5% 990 40.6599 Utilities: O/H Cost Expense 923 1,244 897 878 3,044 12,263 (9,219) 24.8% 12,263 Total Utilities 3,033 3,395 2,464 2,296 8,724 32,259 (23,535) 27.0% 32,259 01/18/2024 Page 27 of 47 120 - ENTERPRISE FUND 25.00% ENTERPRISE FUND DETAILS OCT NOV DEC YTD Original Budget Amended Over/(Under) Budget Amended Budget %0 of Budget Original Budget VS Amended Account Number Account Description Actual Actual Budget Actual Actual Budget 40.6805 Maintenance: Vehicles 205 153 205 1,837 (1,632) 11.2% 1,837 40.6810 Mammnass/CrudPaA 11 26 11 313 (303) 3.4% 313 40.6825 Maintenane:fquipment 301 3,615 (3,615) 0.0% 3,615 40.6900 Maintenance-Water: Tank 2,300 (2,300) 0.0% 2,300 40.6905 Maintenance:Water Pumps/Motors 658 7,900 (7,900) 0.0% 7,900 40.6910 Maintenance: Water Distribution 2,137 5,167 10,008 12,145 62,000 (49,855) 19.6% 62,000 40.6925 Maintenance: Sewer Collection 4,187 3,333 4,187 40,000 (35,813) 10.5% 40,000 40.6999 Maintenance: :0/H Cost Expense 244 177 244 2,122 (1,878) 11.5% 2,122 Total Maintenance 4,392 2,392 9,816 10,008 16,791 120,087 (103,296) 14.0% 120,087 40.7015 ConsultantsilegalRegua 125 1,500 (1,500) 0.0% 1,500 40.7025 Consultants: Auditor 9,420 (9,420) 0.0% 9,420 40.7030 Consultants: Engineer-Regular 26,370 110,000 23,153 49,523 113,000 (63,478) 43.8% 33,000 80,000 40.7095 Consultants:Other 0.0% Total Consultants 26,370 110,125 23,153 49,523 123,920 (74,398) 40.0% 43,920 80,000 40.7225 Contractual: Credit Card Proces 1,338 1,428 1,263 1,233 3,999 14,730 (10,731) 27.1% 14,730 40.7226 Contractual: Call Notification Fees 55 50 42 61 166 500 (334) 33.2% 500 40.7227 Contractual: :CC Online Trans Fee 424 433 433 451 1,309 5,200 (3,892) 25.2% 5,200 40.7300 Contractual: Computer System 144 189 14,092 10,425 10,758 27,638 (16,880) 38.9% 27,638 40.7415 Contractual: Contract Labor 2,821 2,821 2,821 0.0% 40.7505 Contractual: Liability Insur 1,363 1,363 4,868 (3,504) 28.0% 4,868 40.7510 Contractual: Worker's Compens 823 823 3,292 (2,469) 25.0% 3,292 40.7600 Contractual: Refuse Collectio 15,339 15,322 15,528 15,356 46,016 186,812 (140,796) 24.6% 186,812 40.7601 Contractual: Haz Waste Collection 709 708 713 710 2,128 8,577 (6,449) 24.8% 8,577 40.7605 Contractual: Water System Fee 2,631 2,631 2,700 (69) 97.5% 2,700 40.7615 Contractual: Sewer Treatment 34,200 28,223 27,605 30,856 93,279 417,270 (323,991) 22.4% 417,270 40.7650 Contractual: Water Purchase 44,011 62,671 48,047 46,615 153,297 647,020 (493,722) 23.7% 647,020 40.7655 Contractual: Water Testing 60 120 90 317 497 31,640 (31,143) 1.6% 31,640 40.7699 Contractual: O/H Cost Expense 2,268 1,124 6,863 6,184 9,577 31,652 (22,075) 30.3% 31,652 Total Contractual 100,734 112,900 114,676 115,029 328,663 1,381,897 (1,053,234) 23.8% 1,381,897 40.7834 Capital Lease: Principal Expense 87,381 (87,381) 0.0% 87,381 40.7835 Capital Lease: Interest Expense 6,184 (6,184) 0.0% 6,184 Total Debt 93,565 (93,565) 0.0% 93,565 01/18/2024 Page 28 of 47 120 - ENTERPRISE FUND 25.00% ENTERPRISE FUND DETAILS OCT NOV DEC YTD Original Budget Amended Over/(Under) Budget Amended Budget %0 of Budget Original Budget VS Amended Account Number Account Description Actual Actual Budget Actual Actual Budget 40.8010 Other.Membership &Dues 63 70 133 760 (627) 17.4% 760 40.8020 Other.Meetings 0.0% 40.8025 Other.Mileage Reimbursement 0.0% 40.8028 Other:Cell Phone Reimbursement 78 78 78 78 233 930 (698) 25.0% 930 40.8040 Other: Bank Charges 107 101 125 112 321 1,500 (1,179) 21.4% 1,500 40.8070 Other.Miseellineous 8 100 (100) 0.0% 100 40.8085 Other: Interest on Cash Deficit 0.0% 40.8100 Other.Cash-Shor/Over 0.0% 40.8199 Other: 0/H Cost Recovery 350 130 33 174 655 1,311 (656) 50.0% 1,311 Total Other 597 379 243 364 1,341 4,601 (3,260) 29.1% 4,601 40.9005 Capital Outlay-Building 0.0% 40.9010 Capital OutiayComputer/Off Eq 1,600 (1,600) 0.0% 1,600 40.9020 Capital Outlay Water Tank 21,000 20,780 20,780 21,000 (220) 99.0% 21,000 40.9200 Capital Outlay Water System (63,333) 137,777 (137,777) 0.0% 217,777 (80,000) 40.9205 Capital Outlay- Sewer System 0.0% 40.9350 Capital Outlay Equipment 8,000 (8,000) 0.0% 8,000 Total Capital Outlay (42,333) 20,780 20,780 168,377 (147,597) 12.3% 248,377 (80,000) 00.9700 Transfer Out 0.0% 00.9701 Transfer Out:w/S Cost OH 5,500 5,500 5,500 5,500 16,500 66,000 (49,500) 25.0% 66,000 Total Transfer Out 5,500 5,500 5,500 5,500 16,500 66,000 (49,500) 25.0% 66,000 TOTALI EXPENSES 154,351 188,827 245,097 206,378 549,556 2,551,149 (2,001,593) 21.5% 2,551,149 0 Income (Loss) 70,740 (13,550) (72,783) (39,872) 17,318 20,095 (2,777) 20,095 (0) 01/18/2024 Page 29 of 47 a - S S S à S S S f a 140 - CIP FUND-CAPITAL CDBG 25.00% CIP FUND CDBG DETAILS OCT NOV DEC YTD Ovr/(Under) Original Account Number Account Description Actual Actual Budget Actual Actual Budget Budget % of Budget 00.4895 Other Rev:Contributed Capital 0.0% Total Other Revenue 0.0% 00.4900 Transfer In 4,700 4,700 38,841 (34,141) 12.1% Total Other Financing Sources 4,700 4,700 38,841 (34,141) 12.1% TOTAL REVENUE 4,700 4,700 38,841 (34,141) 12.1% 00.6605 CDBG Projects 4,700 5,658 10,358 38,841 (28,483) 26.7% Total Capital Projects 4,700 5,658 10,358 38,841 (28,483) 26.7% 00.8100 Issuance Cost Expense 0.0% Total Issuance Cost 0.0% 00.9700 Transfer Out 0.0% Total Other Financing Uses 0.0% TOTAL EXPENDITURES 4,700 5,658 10,358 38,841 (28,483) 26.7% Revenue Over/(Under) Expenditures (4,700) (958) (5,658) 01/18/2024 Page 31 of 47 5 V S of a 141 CIP FUND - STREETS 25.00% 141 CIP FUND-Streets OCT NOV DEC Ovr/(Under) YTD Actual Original Original % of Budget Budget Budget Account Number Account Description Actual Actual Budget Actual 00.4800 Other Revenue:Bond Interest 1,793 2,122 1,000 2,788 6,703 10,665 (3,962) 62.9% 00.4895 Other Revenue-Contrbuted Capital 36,789 36,789 520,170 (483,381) 7.1% Total Other Revenue 1,793 2,122 1,000 39,577 43,492 530,835 (487,343) 8.2% 00.4901 Bond Issuance 0.0% 00.4902 Premium on Bonds Issued 0.0% Total Other Sources 0.0% TOTAL REVENUE 1,793 2,122 1,000 39,577 43,492 530,835 (487,343) 8.2% 00.6602 Streets 50,641 380,298 50,641 380,298 (329,657) 13.3% Total Projects 50,641 380,298 50,641 380,298 (329,657) 13.3% 40.8100 Debt related issuance costs 0.0% Total Other 0.0% 00.9700 Transfer Out 4,700 4,700 38,841 (34,141) 12.1% Total Transfer Out 4,700 4,700 38,841 (34,141) 12.1% TOTAL EXPENDITURES 50,641 380,298 4,700 55,341 419,139 (363,798) 13.2% Revenue Over/(Under) Expenditures (48,848) 2,122 (379,298) 34,877 (11,849) 111,696 01/18/2024 Page 33 of 47