SEWER - Account Summary as of Jun 29, 2020

$ 569,420.08
Period
$ 1,834,129.53
Year-To-Date
$ 2,037,174.00
Budget
$ 203,044.48
Unexpended
Budget
Expenses
Account Summary
Account Name Account Period Year-to-Date Budget Unexpended Period at 99.04%
SALARIES AND WAGES 51-72-01 37,058.32 343,328.38 380,858.00 37,529.62 90.1
PART TIME WAGES 51-72-02 0.00 278.59 600.00 321.41 46.4
OVERTIME WAGES 51-72-03 1,304.46 20,066.55 15,000.00 (5,066.55) 133.8
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 46.13 59.58 1,800.00 1,740.42 3.3
MEDICAL INSURANCE 51-72-08 7,412.94 81,789.21 143,450.00 61,660.79 57.0
SOCIAL SECURITY (FICA) 51-72-09 2,837.88 27,816.72 29,417.00 1,600.28 94.6
WORKERS' COMPENSATION 51-72-10 1,064.09 11,111.59 14,175.00 3,063.41 78.4
OTHER EMP BENEFITS 51-72-11 0.00 19.67 96.00 76.33 20.5
RETIREMENT 51-72-12 3,848.47 42,239.00 46,184.00 3,945.00 91.5
SAFETY, DRUG TEST & PHYSICALS 51-72-14 0.00 666.11 700.00 33.89 95.2
EDUCATION AND TRAINING 51-72-15 50.85 492.73 1,500.00 1,007.27 32.8
UNIFORM ALLOWANCE 51-72-16 0.00 2,876.21 3,500.00 623.79 82.2
TRAVEL 51-72-17 0.00 996.57 1,800.00 803.43 55.4
DUES/SUBSCRIPTIONS/MEMBERSHIPS 51-72-18 55.50 725.82 2,000.00 1,274.18 36.3
CONTRACT LABOR 51-72-19 269.91 4,866.14 2,540.00 (2,326.14) 191.6
OTHER MATERIALS AND SUPPLIES 51-72-20 2,165.79 16,427.23 15,500.00 (927.23) 106.0
REPAIR/MAINTENANCE - EQUIPMENT 51-72-21 387.54 69,065.91 75,000.00 5,934.09 92.1
REPAIR/MAINTENANCE - BUILDING 51-72-22 0.00 4,939.18 3,000.00 (1,939.18) 164.6
REPAIR/MAINTENANCE-SEWER LINES 51-72-24 918.97 46,609.50 40,000.00 (6,609.50) 116.5
PERMITS AND LICENSES 51-72-25 0.00 15,306.34 15,000.00 (306.34) 102.0
REPAIR/MAINTENANCE - VEHICLE 51-72-26 0.00 7,863.20 6,000.00 (1,863.20) 131.1
GASOLINE AND OIL 51-72-27 830.89 6,195.80 7,500.00 1,304.20 82.6
TELEPHONE 51-72-28 246.66 4,104.02 9,000.00 4,895.98 45.6
UTILITIES 51-72-29 470.02 133,584.94 140,000.00 6,415.06 95.4
OFFICE SUPPLIES 51-72-30 29.93 349.92 1,000.00 650.08 35.0
PRINTING 51-72-31 205.84 3,473.22 2,200.00 (1,273.22) 157.9
COMPUTER-TECHNICAL SUPPORT 51-72-32 231.98 17,532.29 25,500.00 7,967.71 68.8
ADVERTISING 51-72-33 0.00 556.67 1,000.00 443.33 55.7
ENGINEERING 51-72-34 0.00 17,249.39 10,000.00 (7,249.39) 172.5
ACCOUNTING & AUDITING 51-72-36 0.00 0.00 0.00 0.00 0.0
OTHER SERVICES 51-72-37 1,056.39 45,084.23 39,504.00 (5,580.23) 114.1
PUBLIC RELATIONS 51-72-38 0.00 0.00 0.00 0.00 0.0
ON-LINE BILL PAY 51-72-39 2,086.02 23,011.31 16,500.00 (6,511.31) 139.5
INSURANCE & BONDS 51-72-40 28,629.00 113,939.96 120,000.00 6,060.04 94.9
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 725.00 0.00 (725.00) 0.0
CHEMICALS 51-72-48 0.00 101,660.88 70,000.00 (31,660.88) 145.2
LANDFILL CHARGES 51-72-49 0.00 13,987.70 15,000.00 1,012.30 93.3
RENTAL - EQUIPMENT 51-72-50 0.00 0.00 0.00 0.00 0.0
PAYROLL PROCESSING 51-72-51 89.50 320.45 2,500.00 2,179.55 12.8
COMPUTER-TECHNICAL EQUIPMENT 51-72-52 0.00 892.74 0.00 (892.74) 0.0
CAPITAL OUTLAY 51-72-53 0.00 46,449.34 56,150.00 9,700.66 82.7
CAPITAL OUTLAY-OTHER THAN BLDG 51-72-54 0.00 0.00 0.00 0.00 0.0
CAPITAL OUTLAY - EQUIPMENT 51-72-55 0.00 0.00 0.00 0.00 0.0
CAPITAL OUTLAY - VEHICLE 51-72-56 0.00 0.00 0.00 0.00 0.0
WWTP WIFA PRINCIPAL-2004 51-72-61 287,509.72 287,509.72 296,935.00 9,425.28 96.8
WWTP WIFA INTEREST-2004 51-72-62 25,251.48 45,791.40 36,215.00 (9,576.40) 126.4
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 0.00 0.00 0.0
US BANK BOND INTEREST-2015 51-72-65 0.00 0.00 8,050.00 8,050.00 0.0
WWTP WIFA PRINCIPAL-2010 51-72-66 116,663.85 116,663.85 119,000.00 2,336.15 98.0
WWTP WIFA INTEREST-2010 51-72-67 14,196.49 27,226.34 24,880.00 (2,346.34) 109.4
WWTP USDA RD PRINCIPAL-2010 51-72-68 4,891.63 49,354.27 60,780.00 11,425.73 81.2
WWTP USDA RD INTEREST-2010 51-72-69 5,329.37 52,855.73 61,890.00 9,034.27 85.4
WIFA SOLAR PRINCIPAL-2013 51-72-70 20,229.28 20,229.28 44,050.00 23,820.72 45.9
WIFA SOLAR INTEREST-2013 51-72-71 4,051.18 7,836.85 6,400.00 (1,436.85) 122.5
DEPRECIATION EXPENSE 51-72-95 0.00 0.00 0.00 0.00 0.0
Subtotals $ 569,420.08 $ 1,834,129.53 $ 2,037,174.00 $ 203,044.48 90.03 %
>