L-2 - Monthly Departmental Budget Report

Monthly Activity Report January February March April May June July August September October November December Account Typ… 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 2023 Fund 600 Surplus (Deficit): 59,300.23 -10,105.83 24,500.01 -46,932.55 10,775.70 79,489.32 42,409.56 21,692.41 32,658.34 11,178.24 37,012.63 -8,808.72 Fund: 601 - Water Sinking Revenue 0.00 0.00 0.00 0.00 0.00 10,098.00 0.00 0.00 0.00 0.00 0.00 0.00 Expense 0.00 0.00 0.00 0.00 22,247.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund 601 Surplus (Deficit): 0.00 0.00 0.00 0.00 -22,247.50 10,098.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 607 - Second Well Expense 1,347.00 212,368.36 137,826.59 274,174.65 3,055.19 54,258.85 138,061.93 855.75 19,031.09 1,981.17 5,583.93 0.00 Fund 607 Total: 1,347.00 212,368.36 137,826.59 274,174.65 3,055.19 54,258.85 138,061.93 855.75 19,031.09 1,981.17 5,583.93 0.00 Fund: 608 - WATER TREATMENT PLANT Expense 0.00 0.00 0.00 0.00 1,825.00 2,562.19 29,318.13 10,356.68 1,487.50 0.00 12,966.41 0.00 Fund 608 Total: 0.00 0.00 0.00 0.00 1,825.00 2,562.19 29,318.13 10,356.68 1,487.50 0.00 12,966.41 0.00 Fund: 610 - Sewer Revenue 115,734.06 85,777.61 94,680.72 105,447.29 110,804.75 113,127.27 126,697.16 119,995.64 111,066.42 120,118.91 112,232.54 31,546.53 Expense 25,224.84 45,243.34 32,056.50 60,047.29 94,982.55 257,589.72 118,563.81 48,426.03 50,467.62 37,070.34 278,853.50 18,062.56 Fund 610 Surplus (Deficit): 90,509.22 40,534.27 62,624.22 45,400.00 15,822.20 -144,462.45 8,133.35 71,569.61 60,598.80 83,048.57 -166,620.96 13,483.97 Fund: 611 - Sewer Sinking Revenue 0.00 0.00 0.00 0.00 0.00 228,689.63 0.00 0.00 0.00 0.00 212,583.30 0.00 Expense 0.00 0.00 0.00 0.00 463,893.78 0.00 0.00 0.00 0.00 0.00 0.00 41,811.75 Fund 611 Surplus (Deficit): 0.00 0.00 0.00 0.00 -463,893.78 228,689.63 0.00 0.00 0.00 0.00 212,583.30 -41,811.75 Fund: 617 - Sanitary Sewer Infrastructure Improvement Expense 40,000.00 0.00 30,494.45 0.00 0.00 0.00 0.00 0.00 0.00 11,150.00 0.00 0.00 Fund 617 Total: 40,000.00 0.00 30,494.45 0.00 0.00 0.00 0.00 0.00 0.00 11,150.00 0.00 0.00 Fund: 618 - Sewer Main Upsize Railroad Revenue 14,060.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund 618 Total: 14,060.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 670 - Recycling/Garbage Revenue 36,781.30 37,965.47 38,138.35 36,931.13 37,458.51 38,004.20 38,216.79 38,786.13 39,006.51 38,956.95 40,280.99 11,037.08 Expense 36,657.50 35,987.50 36,060.50 36,119.50 36,282.00 36,832.56 37,222.00 37,222.00 0.00 76,768.50 38,313.00 38,596.00 Fund 670 Surplus (Deficit): 123.80 1,977.97 2,077.85 811.63 1,176.51 1,171.64 994.79 1,564.13 39,006.51 -37,811.55 1,967.99 -27,558.92 Fund: 740 - Storm Water Revenue 8,417.30 8,816.40 8,753.46 8,519.13 8,770.92 8,877.79 8,899.25 9,183.69 8,744.15 8,904.13 9,184.16 3,405.80 Expense 0.00 0.00 0.00 781.37 0.00 2,850.00 565.86 0.00 49,080.00 14,000.00 3,000.00 0.00 Fund 740 Surplus (Deficit): 8,417.30 8,816.40 8,753.46 7,737.76 8,770.92 6,027.79 8,333.39 9,183.69 -40,335.85 -5,095.87 6,184.16 3,405.80 Total Surplus (Deficit): 56,915.77 -539,154.80 24,082.49 1,219,555.26 -2,225,038.01 -45,606.29 -516,148.26 -137,757.83 199,775.32 2,036,050.31 -75,877.74 -50,528.02 12/15/2023 2:59:48 PM Page 3 of 4