K-3 - Budget Worksheet - EXPENSES

Budget Worksheet For Fiscal: 2024-2025 Period Ending: 01/31/2025 Defined Budgets 2022-2023 2022-2023 2023-2024 2023-2024 2024-2025 2024-2025 Total Budget Total Activity Total Budget Total Activity Total Budget YTD Activity Fund: 607 - Second Well Expense 607-810-6407 ENGINEERING- THIRD WELL 8,000.00 22,823.32 15,000.00 16,736.46 0.00 0.00 607-810-6499 CONTRACTUAL- THIRD WELL 771,000.00 849,101.42 25,000.00 150,152.67 0.00 0.00 Expense Total: 779,000.00 871,924.74 40,000.00 166,889.13 0.00 0.00 Fund: 607 - Second Well Total: 779,000.00 871,924.74 40,000.00 166,889.13 0.00 0.00 Fund: 608 - WATER TREATMENT PLANT Expense 608-810-6407 ENGINEERING - WATER TREAT… 0.00 0.00 400,000.00 0.00 1,000,000.00 0.00 608-810-6499 CONTRACTUAL - WATER TREA… 0.00 4,387.19 0.00 82,261.80 0.00 0.00 Expense Total: 0.00 4,387.19 400,000.00 82,261.80 1,000,000.00 0.00 Fund: 608 - WATER TREATMENT PLANT Total: 0.00 4,387.19 400,000.00 82,261.80 1,000,000.00 0.00 Fund: 610 - Sewer Expense 610-815-6010 WAGES - FULL TIME - SEWER 176,780.00 173,341.87 204,436.00 116,195.43 0.00 0.00 610-815-6110 FICA - SEWER 12,602.00 12,959.23 15,639.00 8,710.07 0.00 0.00 610-815-6130 IPERS - SEWER 16,734.00 16,347.18 19,298.00 12,216.07 0.00 0.00 610-815-6150 GROUP INSURANCE - SEWER 30,775.00 37,457.81 35,936.00 31,799.10 0.00 0.00 610-815-6160 INSURANCE-WORKERS COMP 3,680.00 9,763.25 7,230.00 0.00 0.00 0.00 610-815-6230 TRAINING - SEWER 1,000.00 2,230.09 2,500.00 702.81 2,500.00 0.00 610-815-6310 BUILDING REPAIR/MAINT - SE… 1,000.00 378.44 1,000.00 436.05 1,000.00 0.00 610-815-6331 VEHICLE OPERATIONS - SEWER 0.00 205.00 0.00 0.00 0.00 0.00 610-815-6332 VEHICLE REPAIRS - SEWER 0.00 959.50 1,000.00 0.00 1,000.00 0.00 610-815-6350 OPERATIONAL EQUIP REPAIR-S… 15,000.00 29,044.74 15,000.00 26,094.54 15,000.00 0.00 610-815-6371 UTILITIES - SEWER 65,000.00 62,338.66 70,000.00 44,737.49 75,000.00 0.00 610-815-6373 TELEPHONE/COMM-SEWER 4,000.00 7,961.50 6,500.00 4,174.15 7,000.00 0.00 610-815-6401 AUDITING/ACCOUNTING/CC P… 4,500.00 5,479.21 4,000.00 6,430.00 5,000.00 0.00 610-815-6407 ENGINEERING-SEWER 0.00 8,200.63 0.00 7,012.50 0.00 0.00 610-815-6408 INSURANCE-PROPERTY INSUR… 14,145.00 36,412.60 33,504.00 6,369.75 0.00 0.00 610-815-6418 SALES TAX - SEWER 4,000.00 3,436.48 4,500.00 2,179.08 5,000.00 0.00 610-815-6419 TECHNOLOGY SERVICES 27,500.00 16,911.72 30,000.00 11,449.82 0.00 0.00 610-815-6490 OTHER PROFESSIONAL SERV 2,500.00 2,373.38 2,500.00 3,504.36 5,000.00 0.00 1/29/2024 4:26:32 PM Page 15 of 18