WS - F - Budget Worksheet - EXPENSES

Budget Worksheet For Fiscal: 2024-2025 Period Ending: 02/28/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 600-910-6910 TRANSFER OUT-WATER 22,440.00 22,440.00 113,400.00 0.00 0.00 0.00 Expense Total: 766,864.00 950,207.69 1,093,143.00 774,379.52 1,177,048.00 0.00 Fund: 600 - Water Total: 766,864.00 950,207.69 1,093,143.00 774,379.52 1,177,048.00 0.00 Fund: 601 - Water Sinking Expense 601-810-6801 PRINCIPAL - 2004 REV BONDS 22,000.00 22,000.00 0.00 0.00 0.00 0.00 601-810-6851 INTEREST - 2004 REV BONDS 385.00 385.00 0.00 0.00 0.00 0.00 601-810-6899 BOND REGISTRATION FEES 55.00 55.00 0.00 0.00 0.00 0.00 Expense Total: 22,440.00 22,440.00 0.00 0.00 0.00 0.00 Fund: 601 - Water Sinking Total: 22,440.00 22,440.00 0.00 0.00 0.00 0.00 Fund: 607 - Second Well Expense 607-810-6407 ENGINEERING- THIRD WELL 8,000.00 22,823.32 15,000.00 16,956.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 167,109.13 0.00 0.00 Fund: 607 - Second Well Total: 779,000.00 871,924.74 40,000.00 167,109.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 86,761.80 0.00 0.00 Expense Total: 0.00 4,387.19 400,000.00 86,761.80 1,000,000.00 0.00 Fund: 608 - WATER TREATMENT PLANT Total: 0.00 4,387.19 400,000.00 86,761.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 123,813.84 254,738.00 0.00 610-815-6110 FICA - SEWER 12,602.00 12,959.23 15,639.00 9,280.14 19,488.00 0.00 610-815-6130 IPERS - SEWER 16,734.00 16,347.18 19,298.00 12,932.53 24,050.00 0.00 610-815-6150 GROUP INSURANCE - SEWER 30,775.00 37,457.81 35,936.00 31,877.51 60,742.00 0.00 610-815-6160 INSURANCE-WORKERS COMP 3,680.00 9,763.25 7,230.00 0.00 7,750.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 - DO NO… 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 2/5/2024 3:12:44 PM Page 15 of 18