Water Utility Finance Report (January 2020)

        Jan 21 Oct ’20 – Jan 21 YTD Budget % of Budget
  Income          
    3433000 · Water Utility Revenues        
      3433001 · Water Revenue 7,357.61 29,617.02 97,000.00 30.53%
      3433002 · Water Late Charges 44.44 167.86 100.00 167.86%
      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 45.42 80.63 100.00 80.63%
      3433011 · New Account Fee 90.00 210.00 60.00 350.0%
    Total 3433000 · Water Utility Revenues 7,537.47 30,075.51 100,960.00 29.79%
    3434000 · Solid Waste Revenues        
      3434001 · Solid Waste Revenue 984.64 4,064.75 13,000.00 31.27%
      3434002 · Solid Waste Late Charges 8.72 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 45.42 75.85 100.00 75.85%
      3434005 · Solid Waste Franchise Fee 1,072.65 3,639.86 10,200.00 35.69%
    Total 3434000 · Solid Waste Revenues 2,111.43 7,880.32 23,450.00 33.61%
    3611000 · Interest Earned/Misc Revenues        
      3612000 · Ameris -WU Interest 20.17 94.73 530.00 17.87%
      3613000 · Ameris – Cust Deposit Interest 3.12 13.75 85.00 16.18%
      3614000 · Ameris – Water Reserve Interest 13.92 61.75 370.00 16.69%
    Total 3611000 · Interest Earned/Misc Revenues 37.21 170.23 985.00 17.28%
    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,686.11 38,126.06 165,395.00 23.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,120.00 5,024.00 15,220.00 33.01%
      5331204 · Water Utility Salary (Trevor) 539.32 2,401.68 8,150.00 29.47%
      5331205 · Water Utility Salary (Anita) 462.63 1,956.54 5,363.00 36.48%
      5331206 · Water Utility Salary (Ashley) 180.47 498.44 2,624.00 19.0%
      5332100 · Payroll Tax – Water 304.02 1,638.02 4,945.00 33.13%
      5332200 · Pension Expense – Water 107.51 611.26 3,032.00 20.16%
      5332300 · Health Insurance – Water 376.00 1,596.88 4,738.00 33.7%
    Total 5331000 · Water Utility Salary Expense 3,089.95 14,676.07 45,022.00 32.6%
    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 680.22 2,790.97 8,000.00 34.89%
      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) 816.03 1,954.20 3,500.00 55.83%
      5335100 · Office Supplies (Chlorine) 0.00 104.00 2,000.00 5.2%
      5335200 · Operating – Meters & Components 66.95 337.55 2,000.00 16.88%
      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 1,563.20 11,127.65 60,500.00 18.39%
    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) 312.00 1,166.76 6,680.00 17.47%
      5341208 · Solid waste Salary (Trevor) 0.00 269.66 270.00 99.87%
      5342100 · Payroll Tax – Solid Waste 35.62 304.33 1,583.00 19.23%
      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 347.62 2,516.59 11,292.00 22.29%
    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 7,860.32 23,581.00 33.33%
    Total 5810000 · Interfund Transfers (ALL – OUT) 1,965.08 7,860.32 43,581.00 18.04%
  Total Expense 6,965.85 37,180.63 165,395.00 22.48%
Net Income   2,720.26 945.43 0.00 100.0%