L-2 - Monthly Departmental Budgetary Report

Detail vs Budget Report Date Range: 07/01/2024 - 04/16/2025 Account Name Encumbrances Fiscal Budget Beginning Balance Total Activity Ending Balance Budget Remaining % Remaining 600-810-6020 WAGES - PART TIME - WATER 0.00 0.00 0.00 2,077.50 2,077.50 -2,077.50 0.00% 600-810-6110 FICA - WATER 0.00 19,488.00 0.00 15,550.39 15,550.39 3,937.61 20.21% 600-810-6130 IPERS - WATER 0.00 24,050.00 0.00 18,617.84 18,617.84 5,432.16 22.59% 600-810-6150 GROUP INSURANCE - WATER 0.00 60,742.00 0.00 38,576.12 38,576.12 22,165.88 36.49% 600-810-6160 INSURANCE-WORKERS COMP 0.00 7,750.00 0.00 16,965.75 16,965.75 -9,215.75 -118.91% 600-810-6181 UNIFORM ALLOWANCE - WATER 0.00 1,000.00 0.00 899.56 899.56 100.44 10.04% 600-810-6210 DUES - WATER 0.00 1,000.00 0.00 1,655.00 1,655.00 -655.00 -65.50% 600-810-6230 TRAINING - WATER 0.00 2,500.00 0.00 1,550.38 1,550.38 949.62 37.98% 600-810-6310 BUILDING REPAIR/MAINT 0.00 2,500.00 0.00 7,467.07 7,467.07 -4,967.07 -198.68% 600-810-6332 VEHICLE REPAIRS - WATER 0.00 1,500.00 0.00 448.70 448.70 1,051.30 70.09% 600-810-6350 OPERATIONAL EQUIP REPAIR 0.00 25,000.00 0.00 22,313.31 22,313.31 2,686.69 10.75% 600-810-6371 UTILITIES - WATER 0.00 165,000.00 0.00 125,302.46 125,302.46 39,697.54 24.06% 600-810-6373 TELEPHONE/COMM-WATER 0.00 8,000.00 0.00 8,370.59 8,370.59 -370.59 -4.63% 600-810-6401 AUDITING/ACCOUNTING/CC PRCSNG 0.00 5,000.00 0.00 4,925.00 4,925.00 75.00 1.50% 600-810-6408 INSURANCE-PROPERTY INSURANCE 0.00 36,780.00 0.00 282.60 282.60 36,497.40 99.23% 600-810-6412 MEDICAL/WELLNESS WATER 0.00 0.00 0.00 72.50 72.50 -72.50 0.00% 600-810-6418 SALES TAX - WATER EXCISE TAX 0.00 70,000.00 0.00 52,598.93 52,598.93 17,401.07 24.86% 600-810-6419 TECHNOLOGY SERVICES 0.00 38,000.00 0.00 23,458.31 23,458.31 14,541.69 38.27% 600-810-6490 OTHER PROFESSIONAL SERV 0.00 5,000.00 0.00 8,064.83 8,064.83 -3,064.83 -61.30% 600-810-6501 CHEMICALS 0.00 140,000.00 0.00 117,651.94 117,651.94 22,348.06 15.96% 600-810-6504 MINOR EQUIPMENT 0.00 2,000.00 0.00 3,229.27 3,229.27 -1,229.27 -61.46% 600-810-6505 OTHER EQUIPMENT 0.00 7,500.00 0.00 5,259.59 5,259.59 2,240.41 29.87% 600-810-6506 OFFICE SUPPLIES 0.00 2,500.00 0.00 1,933.40 1,933.40 566.60 22.66% 600-810-6507 OPERATING SUPPLIES 0.00 20,000.00 0.00 16,589.53 16,589.53 3,410.47 17.05% 600-810-6508 POSTAGE 0.00 7,500.00 0.00 6,489.15 6,489.15 1,010.85 13.48% 600-810-6511 WATER TESTING SUPPLIES 0.00 2,500.00 0.00 1,261.45 1,261.45 1,238.55 49.54% 600-810-6512 VEHICLE/EQUIPMENT FUEL 0.00 5,000.00 0.00 1,266.34 1,266.34 3,733.66 74.67% 600-810-6599 OTHER SUPPLIES 0.00 2,000.00 0.00 76,745.70 76,745.70 -74,745.70 -3,737.29% 600-810-6710 CAP OUTLAY 0.00 85,000.00 0.00 347,061.19 347,061.19 -262,061.19 -308.31% 600-810-6780 WATER METERS 0.00 175,000.00 0.00 232,973.07 232,973.07 -57,973.07 -33.13% 607-810-6407 ENGINEERING- THIRD WELL 0.00 0.00 0.00 1,942.57 1,942.57 -1,942.57 0.00% 608-810-6407 ENGINEERING - WATER TREATMENT PLANT 0.00 1,000,000.00 0.00 578,234.56 578,234.56 421,765.44 42.18% 608-810-6499 CONTRACTUAL - WATER TREATMENT PLANT 0.00 0.00 0.00 10,864.91 10,864.91 -10,864.91 0.00% Expense Totals: 0.00 2,177,048.00 0.00 1,949,612.95 1,949,612.95 227,435.05 10.45% 810 - WATER Totals: 0.00 -201,952.00 0.00 874,717.66 874,717.66 -1,076,669.66 Department: 815 - SEWER & SEWAGE DISPOSAL Revenue 610-815-4500 CHARGES/FEES FOR SERVICES 0.00 -1,309,000.00 0.00 -1,099,510.74 -1,099,510.74 -209,489.26 -16.00% 610-815-4530 PENALTIES 0.00 -7,000.00 0.00 -13,296.82 -13,296.82 6,296.82 89.95% 610-815-4551 DEVELOPMENT FEE - SEWER 0.00 0.00 0.00 -9,909.89 -9,909.89 9,909.89 0.00% 610-815-4552 HOOK UP FEES - SEWER 0.00 -45,000.00 0.00 -20,200.00 -20,200.00 -24,800.00 -55.11% 610-815-4560 SALES TAXES COLLECTED 0.00 -4,500.00 0.00 -4,683.01 -4,683.01 183.01 4.07% 610-815-4710 REIMB-SEWER 0.00 0.00 0.00 -282.60 -282.60 282.60 0.00% 4/16/2025 9:39:59 AM Page 14 of 18