Water Utility Finance Report (February 2020)

        Feb 21 Oct ’20 – Feb 21 YTD Budget % of Budget
  Income          
    3433000 · Water Utility Revenues        
      3433001 · Water Revenue 7,656.51 37,273.53 97,000.00 38.43%
      3433002 · Water Late Charges 29.01 196.87 100.00 196.87%
      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 13.00 93.63 100.00 93.63%
      3433011 · New Account Fee 30.00 0.00 60.00 0.0%
    Total 3433000 · Water Utility Revenues 7,728.52 37,564.03 100,960.00 37.21%
    3434000 · Solid Waste Revenues        
      3434001 · Solid Waste Revenue 968.60 5,033.35 13,000.00 38.72%
      3434002 · Solid Waste Late Charges 0.00 44.36 100.00 44.36%
      3434003 · Special Pick Up Charges 0.00 55.50 50.00 111.0%
      3434004 · Solid Waste Late Notice Fee 13.00 88.85 100.00 88.85%
      3434005 · Solid Waste Franchise Fee 1,062.41 4,702.27 10,200.00 46.1%
    Total 3434000 · Solid Waste Revenues 2,044.01 9,924.33 23,450.00 42.32%
    3611000 · Interest Earned/Misc Revenues        
      3612000 · Ameris -WU Interest 7.61 102.34 530.00 19.31%
      3613000 · Ameris – Cust Deposit Interest 1.15 14.90 85.00 17.53%
      3614000 · Ameris – Water Reserve Interest 5.22 66.97 370.00 18.1%
    Total 3611000 · Interest Earned/Misc Revenues 13.98 184.21 985.00 18.7%
    3810000 · Interfund Transfer (ALL – IN)        
      3810001 · Contingency Reserves (WU) 0.00 0.00 20,000.00 0.0%
      3810002 · Contingency Reserves (WW/Sewer) 3,676.00 3,676.00 20,000.00 18.38%
    Total 3810000 · Interfund Transfer (ALL – IN) 3,676.00 3,676.00 40,000.00 9.19%
  Total Income 13,462.51 51,348.57 165,395.00 31.05%
  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,123.50 6,147.50 15,220.00 40.39%
      5331204 · Water Utility Salary (Trevor) 507.80 2,909.48 8,150.00 35.7%
      5331205 · Water Utility Salary (Anita) 449.64 2,406.18 5,363.00 44.87%
      5331206 · Water Utility Salary (Ashley) 199.81 698.25 2,624.00 26.61%
      5332100 · Payroll Tax – Water 305.42 1,943.44 4,945.00 39.3%
      5332200 · Pension Expense – Water 218.56 829.82 3,032.00 27.37%
      5332300 · Health Insurance – Water 376.00 1,972.88 4,738.00 41.64%
    Total 5331000 · Water Utility Salary Expense 3,180.73 17,856.80 45,022.00 39.66%
    5333000 · Water Operating Expenses        
      5333100 · Professional Svcs 0.00 1,032.20 7,500.00 13.76%
      5333200 · Accounting/Auditing 0.00 0.00 1,500.00 0.0%
      5333400 · Other – Services (Tower) 0.00 4,698.73 9,000.00 52.21%
      5334200 · Freight & Postage 0.00 210.00 1,000.00 21.0%
      5334300 · Utilities 677.05 3,468.02 8,000.00 43.35%
      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) 925.99 2,880.19 3,500.00 82.29%
      5335100 · Office Supplies (Chlorine) 0.00 104.00 2,000.00 5.2%
      5335200 · Operating – Meters & Components 66.95 404.50 2,000.00 20.23%
      5335400 · Dues/Memberships 0.00 0.00 500.00 0.0%
      5335500 · Education/Certification 75.00 75.00 1,500.00 5.0%
      5335600 · Contingency Equip & Repairs 0.00 0.00 20,000.00 0.0%
    Total 5333000 · Water Operating Expenses 1,744.99 12,872.64 60,500.00 21.28%
    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) 468.00 1,634.76 6,680.00 24.47%
      5341208 · Solid waste Salary (Trevor) 0.00 269.66 270.00 99.87%
      5342100 · Payroll Tax – Solid Waste 59.30 363.63 1,583.00 22.97%
      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 527.30 3,043.89 11,292.00 26.96%
    5343000 · Solid Waste – Operating Expense        
      5344600 · Repair & Maint –  Solid Waste 180.50 180.50 1,000.00 18.05%
      5344900 · Other – Solid Waste (Landfill) 0.00 1,000.00 4,000.00 25.0%
    Total 5343000 · Solid Waste – Operating Expense 180.50 1,180.50 5,000.00 23.61%
    5810000 · Interfund Transfers (ALL – OUT)        
      5810004 · Transfer Out to WW/Sewer 3,676.00 3,676.00 20,000.00 18.38%
      5810005 · Water Utility to Water Reserve 1,965.08 9,825.40 23,581.00 41.67%
    Total 5810000 · Interfund Transfers (ALL – OUT) 5,641.08 13,501.40 43,581.00 30.98%
  Total Expense 11,274.60 48,455.23 165,395.00 29.3%
Net Income   2,187.91 2,893.34 0.00 100.0%