SEWER - Account Summary as of Nov 27, 2020

$ 68,834.24
Period
$ 935,486.71
Year-To-Date
$ 2,674,600.00
Budget
$ 1,739,113.29
Unexpended
Budget
Expenses
Account Summary
Account Name Account Period Year-to-Date Budget Unexpended Period at 39.89%
SALARIES AND WAGES 51-72-01 0.00 93,838.30 378,500.00 284,661.70 24.8
PART TIME WAGES 51-72-02 0.00 1,308.78 4,500.00 3,191.22 29.1
OVERTIME WAGES 51-72-03 0.00 5,926.51 22,000.00 16,073.49 26.9
INDUSTRIAL LEAVE WAGES 51-72-05 0.00 0.00 0.00 0.00 0.0
COMPENSATED ABSENCES 51-72-06 0.00 0.00 0.00 0.00 0.0
HEALTH EQUITY 51-72-07 0.00 3.73 100.00 96.27 3.7
MEDICAL INSURANCE 51-72-08 0.00 15,363.51 94,000.00 78,636.49 16.3
SOCIAL SECURITY (FICA) 51-72-09 0.00 7,573.48 31,000.00 23,426.52 24.4
WORKERS' COMPENSATION 51-72-10 0.00 7,290.73 11,000.00 3,709.27 66.3
OTHER EMP BENEFITS 51-72-11 0.00 0.00 0.00 0.00 0.0
RETIREMENT 51-72-12 0.00 12,108.72 48,900.00 36,791.28 24.8
SAFETY, DRUG TEST & PHYSICALS 51-72-14 0.00 210.00 1,400.00 1,190.00 15.0
EDUCATION AND TRAINING 51-72-15 0.00 192.94 3,000.00 2,807.06 6.4
UNIFORM ALLOWANCE 51-72-16 86.03 1,260.43 7,000.00 5,739.57 18.0
TRAVEL 51-72-17 0.00 112.00 3,600.00 3,488.00 3.1
DUES/SUBSCRIPTIONS/MEMBERSHIPS 51-72-18 0.00 57.00 3,200.00 3,143.00 1.8
CONTRACT LABOR 51-72-19 0.00 8,000.00 8,500.00 500.00 94.1
OTHER MATERIALS AND SUPPLIES 51-72-20 295.30 7,627.83 35,500.00 27,872.17 21.5
REPAIR/MAINTENANCE - EQUIPMENT 51-72-21 336.26 33,842.34 140,000.00 106,157.66 24.2
REPAIR/MAINTENANCE - BUILDING 51-72-22 61.66 4,363.23 6,200.00 1,836.77 70.4
REPAIR/MAINTENANCE-SEWER LINES 51-72-24 0.00 12,837.60 90,000.00 77,162.40 14.3
PERMITS AND LICENSES 51-72-25 2,500.00 8,500.00 40,000.00 31,500.00 21.3
REPAIR/MAINTENANCE - VEHICLE 51-72-26 150.15 3,394.20 12,300.00 8,905.80 27.6
GASOLINE AND OIL 51-72-27 0.00 0.00 16,000.00 16,000.00 0.0
TELEPHONE 51-72-28 286.10 1,528.82 10,000.00 8,471.18 15.3
UTILITIES 51-72-29 12,221.13 53,739.99 269,400.00 215,660.01 19.9
OFFICE SUPPLIES 51-72-30 18.64 29.52 1,000.00 970.48 3.0
PRINTING 51-72-31 124.93 1,200.09 7,000.00 5,799.91 17.1
COMPUTER-TECHNICAL SUPPORT 51-72-32 221.83 3,815.47 30,000.00 26,184.53 12.7
ADVERTISING 51-72-33 0.00 38.06 750.00 711.94 5.1
ENGINEERING 51-72-34 0.00 0.00 40,000.00 40,000.00 0.0
ACCOUNTING & AUDITING 51-72-36 0.00 0.00 0.00 0.00 0.0
OTHER SERVICES 51-72-37 2,269.68 20,418.21 80,000.00 59,581.79 25.5
PUBLIC RELATIONS 51-72-38 0.00 0.00 0.00 0.00 0.0
ON-LINE BILL PAY 51-72-39 0.00 1,980.94 45,000.00 43,019.06 4.4
INSURANCE & BONDS 51-72-40 31,290.12 62,367.48 240,000.00 177,632.52 26.0
LEGAL FEES 51-72-41 0.00 0.00 0.00 0.00 0.0
BAD DEBT WRITE OFF 51-72-42 0.00 0.00 0.00 0.00 0.0
PROGRAM SUPPLIES 51-72-43 0.00 0.00 0.00 0.00 0.0
UNRESTRICTED CONTINGENCY 51-72-44 0.00 0.00 0.00 0.00 0.0
RESTRICTED CONTINGENCY 51-72-45 0.00 0.00 0.00 0.00 0.0
BANK FEES 51-72-46 0.00 0.00 0.00 0.00 0.0
CONTRACT SERVICES 51-72-47 0.00 300.00 0.00 (300.00) 0.0
CHEMICALS 51-72-48 0.00 36,304.00 140,000.00 103,696.00 25.9
LANDFILL CHARGES 51-72-49 0.00 7,001.70 40,000.00 32,998.30 17.5
RENTAL - EQUIPMENT 51-72-50 0.00 0.00 0.00 0.00 0.0
PAYROLL PROCESSING 51-72-51 0.00 0.00 1,000.00 1,000.00 0.0
COMPUTER-TECHNICAL EQUIPMENT 51-72-52 0.00 0.00 750.00 750.00 0.0
CAPITAL OUTLAY 51-72-53 0.00 17,106.97 20,000.00 2,893.03 85.5
CAPITAL OUTLAY-OTHER THAN BLDG 51-72-54 0.00 0.00 0.00 0.00 0.0
CAPITAL OUTLAY - EQUIPMENT 51-72-55 18,972.41 18,972.41 0.00 (18,972.41) 0.0
CAPITAL OUTLAY - VEHICLE 51-72-56 0.00 0.00 0.00 0.00 0.0
OFFICE & COMPUTER EQUIPMENT 51-72-59 0.00 0.00 0.00 0.00 0.0
WWTP WIFA PRINCIPAL-2004 51-72-61 0.00 296,932.85 297,000.00 67.15 100.0
WWTP WIFA INTEREST-2004 51-72-62 0.00 20,539.92 36,200.00 15,660.08 56.7
US BANK BOND PRINCIPAL-2015 51-72-63 0.00 0.00 65,000.00 65,000.00 0.0
US BANK 2004 BOND ADMIN FEES 51-72-64 0.00 0.00 70,000.00 70,000.00 0.0
US BANK BOND INTEREST-2015 51-72-65 0.00 0.00 8,000.00 8,000.00 0.0
WWTP WIFA PRINCIPAL-2010 51-72-66 0.00 118,997.13 119,000.00 2.87 100.0
WWTP WIFA INTEREST-2010 51-72-67 0.00 13,029.85 25,000.00 11,970.15 52.1
WWTP USDA RD PRINCIPAL-2010 51-72-68 0.00 5,009.08 60,600.00 55,590.92 8.3
WWTP USDA RD INTEREST-2010 51-72-69 0.00 5,211.92 61,800.00 56,588.08 8.4
WIFA SOLAR PRINCIPAL-2013 51-72-70 0.00 20,760.30 44,000.00 23,239.70 47.2
WIFA SOLAR INTEREST-2013 51-72-71 0.00 3,785.67 6,400.00 2,614.33 59.2
2019 USDA WTP LOAN 51-72-72 0.00 2,605.00 0.00 (2,605.00) 0.0
DEPRECIATION EXPENSE 51-72-95 0.00 0.00 0.00 0.00 0.0
Subtotals $ 68,834.24 $ 935,486.71 $ 2,674,600.00 $ 1,739,113.29 34.97 %
>