SEWER - Account Summary as of Mar 19, 2021

$ 107,766.71
Period
$ 1,340,498.25
Year-To-Date
$ 2,045,000.00
Budget
$ 704,501.75
Unexpended
Budget
Expenses
Account Summary
Account Name Account Period Year-to-Date Budget Unexpended Period at 71.10%
SALARIES AND WAGES 51-72-01 24,916.24 222,054.73 378,500.00 156,445.27 58.7
PART TIME WAGES 51-72-02 438.28 3,780.79 4,500.00 719.21 84.0
OVERTIME WAGES 51-72-03 881.59 11,841.22 22,000.00 10,158.78 53.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 42.00 167.95 100.00 (67.95) 167.9
MEDICAL INSURANCE 51-72-08 3,902.80 38,930.19 94,000.00 55,069.81 41.4
SOCIAL SECURITY (FICA) 51-72-09 1,832.70 18,407.50 31,000.00 12,592.50 59.4
WORKERS' COMPENSATION 51-72-10 2,019.38 12,903.25 11,000.00 (1,903.25) 117.3
OTHER EMP BENEFITS 51-72-11 0.00 0.00 0.00 0.00 0.0
RETIREMENT 51-72-12 3,139.23 28,574.29 48,900.00 20,325.71 58.4
SAFETY, DRUG TEST & PHYSICALS 51-72-14 0.00 327.30 700.00 372.70 46.8
EDUCATION AND TRAINING 51-72-15 35.85 847.02 1,500.00 652.98 56.5
UNIFORM ALLOWANCE 51-72-16 86.03 1,986.16 3,500.00 1,513.84 56.7
TRAVEL 51-72-17 0.00 112.00 1,800.00 1,688.00 6.2
DUES/SUBSCRIPTIONS/MEMBERSHIPS 51-72-18 0.00 501.42 1,700.00 1,198.58 29.5
CONTRACT LABOR 51-72-19 0.00 8,045.95 6,000.00 (2,045.95) 134.1
OTHER MATERIALS AND SUPPLIES 51-72-20 679.48 12,204.96 20,000.00 7,795.04 61.0
REPAIR/MAINTENANCE - EQUIPMENT 51-72-21 336.26 43,394.62 70,000.00 26,605.38 62.0
REPAIR/MAINTENANCE - BUILDING 51-72-22 114.96 5,824.76 3,000.00 (2,824.76) 194.2
REPAIR/MAINTENANCE-SEWER LINES 51-72-24 458.85 24,253.96 45,000.00 20,746.04 53.9
PERMITS AND LICENSES 51-72-25 2,500.00 9,000.04 20,000.00 10,999.96 45.0
REPAIR/MAINTENANCE - VEHICLE 51-72-26 214.71 4,686.09 6,000.00 1,313.91 78.1
GASOLINE AND OIL 51-72-27 544.40 4,942.31 8,000.00 3,057.69 61.8
TELEPHONE 51-72-28 296.10 2,849.41 5,000.00 2,150.59 57.0
UTILITIES 51-72-29 12,221.13 97,553.57 134,400.00 36,846.43 72.6
OFFICE SUPPLIES 51-72-30 50.55 148.43 500.00 351.57 29.7
PRINTING 51-72-31 124.93 2,032.79 3,500.00 1,467.21 58.1
COMPUTER-TECHNICAL SUPPORT 51-72-32 221.83 7,799.99 15,000.00 7,200.01 52.0
ADVERTISING 51-72-33 0.00 414.90 400.00 (14.90) 103.7
ENGINEERING 51-72-34 0.00 337.50 20,000.00 19,662.50 1.7
ACCOUNTING & AUDITING 51-72-36 0.00 0.00 0.00 0.00 0.0
OTHER SERVICES 51-72-37 2,269.68 39,251.42 40,000.00 748.58 98.1
PUBLIC RELATIONS 51-72-38 0.00 0.00 0.00 0.00 0.0
ON-LINE BILL PAY 51-72-39 0.00 6,341.08 25,000.00 18,658.92 25.4
INSURANCE & BONDS 51-72-40 31,290.12 93,441.24 120,000.00 26,558.76 77.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 80.06 0.00 (80.06) 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 919.75 0.00 (919.75) 0.0
CHEMICALS 51-72-48 0.00 69,431.45 70,000.00 568.55 99.2
LANDFILL CHARGES 51-72-49 0.00 18,254.45 20,000.00 1,745.55 91.3
RENTAL - EQUIPMENT 51-72-50 0.00 0.00 0.00 0.00 0.0
PAYROLL PROCESSING 51-72-51 0.00 0.00 500.00 500.00 0.0
COMPUTER-TECHNICAL EQUIPMENT 51-72-52 136.50 211.90 500.00 288.10 42.4
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 40.70 40.70 0.00 (40.70) 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 15,057.00 60,600.00 45,543.00 24.8
WWTP USDA RD INTEREST-2010 51-72-69 0.00 15,606.00 61,800.00 46,194.00 25.3
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 7,815.00 0.00 (7,815.00) 0.0
DEPRECIATION EXPENSE 51-72-95 0.00 0.00 0.00 0.00 0.0
Subtotals $ 107,766.71 $ 1,340,498.25 $ 2,045,000.00 $ 704,501.75 65.55 %
>