L-2 - Monthly Departmental Budget Report

Monthly Activity Report October November December January February March April May June July August September Account Typ… 2022 2022 2022 2023 2023 2023 2023 2023 2023 2023 2023 2023 Fund: 600 - Water Revenue 107,440.49 101,490.91 144,406.30 104,927.30 60,936.54 79,323.76 96,890.29 104,830.15 149,919.28 143,450.78 123,223.84 29,447.29 Expense 67,859.45 56,913.26 118,233.09 45,627.07 71,042.37 54,823.75 143,822.84 94,054.45 72,673.96 101,041.22 101,531.43 76,958.03 Fund 600 Surplus (Deficit): 39,581.04 44,577.65 26,173.21 59,300.23 -10,105.83 24,500.01 -46,932.55 10,775.70 77,245.32 42,409.56 21,692.41 -47,510.74 Fund: 601 - Water Sinking Revenue 0.00 0.00 12,342.00 0.00 0.00 0.00 0.00 0.00 12,342.00 0.00 0.00 0.00 Expense 0.00 0.00 192.50 0.00 0.00 0.00 0.00 22,247.50 0.00 0.00 0.00 0.00 Fund 601 Surplus (Deficit): 0.00 0.00 12,149.50 0.00 0.00 0.00 0.00 -22,247.50 12,342.00 0.00 0.00 0.00 Fund: 607 - Second Well Expense 3,290.00 1,279.00 1,300.50 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 Fund 607 Total: 3,290.00 1,279.00 1,300.50 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 Fund: 608 - WATER TREATMENT PLANT Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,825.00 2,562.19 29,318.13 10,356.68 0.00 Fund 608 Total: 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,825.00 2,562.19 29,318.13 10,356.68 0.00 Fund: 610 - Sewer Revenue 109,094.01 104,703.27 101,154.29 115,734.06 85,777.61 94,680.72 105,447.29 110,804.75 113,127.27 126,697.16 119,995.64 31,202.22 Expense 63,065.17 28,840.74 358,525.05 25,224.84 45,243.34 32,056.50 60,047.29 94,982.55 28,900.09 118,563.81 48,426.03 32,874.79 Fund 610 Surplus (Deficit): 46,028.84 75,862.53 -257,370.76 90,509.22 40,534.27 62,624.22 45,400.00 15,822.20 84,227.18 8,133.35 71,569.61 -1,672.57 Fund: 611 - Sewer Sinking Revenue 0.00 0.00 279,509.70 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Expense 0.00 0.00 44,305.55 0.00 0.00 0.00 0.00 463,893.78 0.00 0.00 0.00 0.00 Fund 611 Surplus (Deficit): 0.00 0.00 235,204.15 0.00 0.00 0.00 0.00 -463,893.78 0.00 0.00 0.00 0.00 Fund: 617 - Sanitary Sewer Infrastructure Improvement Expense 0.00 0.00 25,640.00 40,000.00 0.00 30,494.45 0.00 0.00 0.00 0.00 0.00 0.00 Fund 617 Total: 0.00 0.00 25,640.00 40,000.00 0.00 30,494.45 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 618 - Sewer Main Upsize Railroad Revenue 0.00 0.00 0.00 14,060.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund 618 Total: 0.00 0.00 0.00 14,060.07 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Fund: 670 - Recycling/Garbage Revenue 37,201.10 36,129.33 36,813.59 36,781.30 37,965.47 38,138.35 36,931.13 37,458.51 38,004.20 38,216.79 38,786.13 10,225.12 Expense 36,023.84 36,258.50 36,538.00 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 Fund 670 Surplus (Deficit): 1,177.26 -129.17 275.59 123.80 1,977.97 2,077.85 811.63 1,176.51 1,171.64 994.79 1,564.13 10,225.12 Fund: 740 - Storm Water Revenue 8,503.11 8,178.78 8,439.82 8,417.30 8,816.40 8,753.46 8,519.13 8,770.92 8,877.79 8,899.25 9,183.69 2,637.57 Expense 18,355.00 0.00 1,388.75 0.00 0.00 0.00 781.37 0.00 2,850.00 565.86 0.00 49,080.00 Fund 740 Surplus (Deficit): -9,851.89 8,178.78 7,051.07 8,417.30 8,816.40 8,753.46 7,737.76 8,770.92 6,027.79 8,333.39 9,183.69 -46,442.43 Total Surplus (Deficit): 1,465,741.89 -654,361.26 -497,297.58 56,915.77 -539,154.80 -11,829.17 1,219,555.26 -2,225,038.01 -90,009.38 -517,960.68 -137,757.83 -35,189.60 9/14/2023 12:12:55 PM Page 3 of 4