Water Utility Finance Report (December 2020)

        Dec 20 Oct – Dec 20 YTD Budget % of Budget
  Income          
    3433000 · Water Utility Revenues        
      3433001 · Water Revenue 7,469.99 22,259.41 97,000.00 22.95%
      3433002 · Water Late Charges 52.94 123.42 100.00 123.42%
      3433003 · Disconnect Fee 0.00 0.00 100.00 0.0%
      3433004 · Reconnect Fee 0.00 0.00 100.00 0.0%
      3433005 · New Water Set Up Fees 0.00 0.00 3,500.00 0.0%
      3433007 · Water Late Notice Fee 20.43 35.21 100.00 35.21%
      3433011 · New Account Fee 0.00 120.00 60.00 200.0%
    Total 3433000 · Water Utility Revenues 7,543.36 22,538.04 100,960.00 22.32%
    3434000 · Solid Waste Revenues        
      3434001 · Solid Waste Revenue 1,082.31 3,080.11 13,000.00 23.69%
      3434002 · Solid Waste Late Charges 15.42 35.64 100.00 35.64%
      3434003 · Special Pick Up Charges 0.00 55.50 50.00 111.0%
      3434004 · Solid Waste Late Notice Fee 18.43 30.43 100.00 30.43%
      3434005 · Solid Waste Franchise Fee 660.03 2,567.21 10,200.00 25.17%
    Total 3434000 · Solid Waste Revenues 1,776.19 5,768.89 23,450.00 24.6%
    3611000 · Interest Earned/Misc Revenues        
      3612000 · Ameris -WU Interest 22.09 74.56 530.00 14.07%
      3613000 · Ameris – Cust Deposit Interest 3.31 10.63 85.00 12.51%
      3614000 · Ameris – Water Reserve Interest 14.50 47.83 370.00 12.93%
    Total 3611000 · Interest Earned/Misc Revenues 39.90 133.02 985.00 13.51%
    3810000 · Interfund Transfer (ALL – IN)        
      3810001 · Contingency Reserves (WU) 0.00 0.00 20,000.00 0.0%
      3810002 · Contingency Reserves (WW/Sewer) 0.00 0.00 20,000.00 0.0%
    Total 3810000 · Interfund Transfer (ALL – IN) 0.00 0.00 40,000.00 0.0%
  Total Income 9,359.45 28,439.95 165,395.00 17.2%
  Expense        
    5331000 · Water Utility Salary Expense        
      5331200 · Water Utility Admin (Wendy) 0.00 949.25 950.00 99.92%
      5331201 · Water Utility Salary (Josh) 1,120.00 3,904.00 15,220.00 25.65%
      5331204 · Water Utility Salary (Trevor) 539.32 1,862.36 8,150.00 22.85%
      5331205 · Water Utility Salary (Anita) 561.41 1,493.91 5,363.00 27.86%
      5331206 · Water Utility Salary (Ashley) 207.97 317.97 2,624.00 12.12%
      5332100 · Payroll Tax – Water 329.43 1,334.00 4,945.00 26.98%
      5332200 · Pension Expense – Water 116.77 503.75 3,032.00 16.61%
      5332300 · Health Insurance – Water 376.00 1,220.88 4,738.00 25.77%
    Total 5331000 · Water Utility Salary Expense 3,250.90 11,586.12 45,022.00 25.73%
    5333000 · Water Operating Expenses        
      5333100 · Professional Svcs 432.20 1,032.20 7,500.00 13.76%
      5333200 · Accounting/Auditing 0.00 0.00 1,500.00 0.0%
      5333400 · Other – Services (Tower) 4,698.73 4,698.73 9,000.00 52.21%
      5334200 · Freight & Postage 210.00 210.00 1,000.00 21.0%
      5334300 · Utilities 664.33 2,110.75 8,000.00 26.38%
      5334600 · Repair & Maintenance 0.00 0.00 2,000.00 0.0%
      5334800 · Machinery & Equipment 0.00 0.00 2,000.00 0.0%
      5334900 · Other Charges – Water (Labs) 379.39 1,138.17 3,500.00 32.52%
      5335100 · Office Supplies (Chlorine) 0.00 104.00 2,000.00 5.2%
      5335200 · Operating – Meters & Components 66.95 270.60 2,000.00 13.53%
      5335400 · Dues/Memberships 0.00 0.00 500.00 0.0%
      5335500 · Education/Certification 0.00 0.00 1,500.00 0.0%
      5335600 · Contingency Equip & Repairs 0.00 0.00 20,000.00 0.0%
    Total 5333000 · Water Operating Expenses 6,451.60 9,564.45 60,500.00 15.81%
    5340000 · Solid Waste Salary Expense        
      5341205 · Solid Waste Salary (Tyler) 0.00 456.75 457.00 99.95%
      5341206 · Solid Waste Salary (Hunter) 0.00 188.50 192.00 98.18%
      5341207 · Solid Waste Salary (Michael) 518.38 854.76 6,680.00 12.8%
      5341208 · Solid waste Salary (Trevor) 0.00 269.66 270.00 99.87%
      5342100 · Payroll Tax – Solid Waste 69.41 268.71 1,583.00 16.98%
      5342200 · Pension Expense – Solid Waste 0.00 30.00 676.00 4.44%
      5342300 · Health Insurance – Solid Waste 0.00 100.59 1,434.00 7.02%
    Total 5340000 · Solid Waste Salary Expense 587.79 2,168.97 11,292.00 19.21%
    5343000 · Solid Waste – Operating Expense        
      5344600 · Repair & Maint –  Solid Waste 0.00 0.00 1,000.00 0.0%
      5344900 · Other – Solid Waste (Landfill) 0.00 1,000.00 4,000.00 25.0%
    Total 5343000 · Solid Waste – Operating Expense 0.00 1,000.00 5,000.00 20.0%
    5810000 · Interfund Transfers (ALL – OUT)        
      5810004 · Transfer Out to WW/Sewer 0.00 0.00 20,000.00 0.0%
      5810005 · Water Utility to Water Reserve 1,965.08 5,895.24 23,581.00 25.0%
    Total 5810000 · Interfund Transfers (ALL – OUT) 1,965.08 5,895.24 43,581.00 13.53%
  Total Expense 12,255.37 30,214.78 165,395.00 18.27%
Net Income   (2,895.92) (1,774.83) 0.00 100.0%