Water Utility Finance Report (June 2021)

        Jun 21 Oct ’20 – Jun 21 YTD Budget % of Budget
  Income          
    3433000 · Water Utility Revenues        
      3433001 · Water Revenue 9,007.19 68,798.63 97,000.00 70.93%
      3433002 · Water Late Charges 91.59 449.75 100.00 449.75%
      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 3,300.00 3,500.00 94.29%
      3433007 · Water Late Notice Fee 2.02 201.14 100.00 201.14%
      3433011 · New Account Fee 0.00 90.00 60.00 150.0%
      3433012 · Return Check Fee(s) 0.00 52.00    
    Total 3433000 · Water Utility Revenues 9,100.80 72,891.52 100,960.00 72.2%
    3434000 · Solid Waste Revenues        
      3434001 · Solid Waste Revenue 976.16 8,980.71 13,000.00 69.08%
      3434002 · Solid Waste Late Charges 30.54 132.69 100.00 132.69%
      3434003 · Special Pick Up Charges 0.00 55.50 50.00 111.0%
      3434004 · Solid Waste Late Notice Fee 2.02 196.36 100.00 196.36%
      3434005 · Solid Waste Franchise Fee 474.64 8,116.95 10,200.00 79.58%
    Total 3434000 · Solid Waste Revenues 1,483.36 17,482.21 23,450.00 74.55%
    3611000 · Interest Earned/Misc Revenues        
      3612000 · Ameris -WU Interest 8.15 132.93 530.00 25.08%
      3613000 · Ameris – Cust Deposit Interest 1.21 19.45 85.00 22.88%
      3614000 · Ameris – Water Reserve Interest 4.94 86.21 370.00 23.3%
    Total 3611000 · Interest Earned/Misc Revenues 14.30 238.59 985.00 24.22%
    3810000 · Interfund Transfer (ALL – IN)        
      3810001 · Contingency Reserves (WU) 3,582.27 18,946.87 20,000.00 94.73%
      3810002 · Contingency Reserves (WW/Sewer) 575.00 7,284.92 20,000.00 36.43%
    Total 3810000 · Interfund Transfer (ALL – IN) 4,157.27 26,231.79 40,000.00 65.58%
  Total Income 14,755.73 116,844.11 165,395.00 70.65%
  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,133.12 11,226.87 15,220.00 73.76%
      5331204 · Water Utility Salary (Trevor) 0.00 4,426.31 4,427.00 99.98%
      5331205 · Water Utility Salary (Anita) 520.66 4,629.38 6,363.00 72.76%
      5331206 · Water Utility Salary (Ashley) 0.00 1,256.62 1,257.00 99.97%
      5331207 · Water Utility Salary (Jenna) 760.20 1,196.21 4,467.00 26.78%
      5331208 · Water Utility Salary (Ryan) 296.95 446.48 1,350.00 33.07%
      5332100 · Payroll Tax – Water 356.90 3,525.33 4,945.00 71.29%
      5332200 · Pension Expense – Water 168.50 1,753.49 3,032.00 57.83%
      5332300 · Health Insurance – Water 262.06 3,649.13 4,738.00 77.02%
    Total 5331000 · Water Utility Salary Expense 3,498.39 33,059.07 46,749.00 70.72%
    5333000 · Water Operating Expenses        
      5333100 · Professional Svcs 0.00 600.00 7,500.00 8.0%
      5333200 · Accounting/Auditing 0.00 0.00 1,500.00 0.0%
      5333400 · Other – Services (Tower) 4,698.73 9,397.46 9,000.00 104.42%
      5334200 · Freight & Postage 0.00 444.01 1,000.00 44.4%
      5334300 · Utilities 698.93 6,235.63 8,000.00 77.95%
      5334600 · Repair & Maintenance 315.90 315.90 2,000.00 15.8%
      5334800 · Machinery & Equipment 0.00 0.00 2,000.00 0.0%
      5334900 · Other Charges – Water (Labs) 379.39 4,829.95 3,500.00 138.0%
      5335100 · Office Supplies (Chlorine) 83.20 351.74 2,000.00 17.59%
      5335200 · Operating – Meters & Components 242.95 1,499.97 2,000.00 75.0%
      5335400 · Dues/Memberships 0.00 314.00 500.00 62.8%
      5335500 · Education/Certification 0.00 75.00 1,500.00 5.0%
      5335600 · Contingency Equip & Repairs 3,582.27 18,946.87 20,000.00 94.73%
    Total 5333000 · Water Operating Expenses 10,001.37 43,010.53 60,500.00 71.09%
    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) 0.00 2,276.64 2,277.00 99.98%
      5341208 · Solid Waste Salary (Trevor) 472.15 995.71 2,643.00 37.67%
      5341209 · Solid Waste Salary (Ryan) 0.00 302.81 303.00 99.94%
      5342100 · Payroll Tax – Solid Waste 98.17 622.28 1,583.00 39.31%
      5342200 · Pension Expense – Solid Waste 56.44 116.44 676.00 17.23%
      5342300 · Health Insurance – Solid Waste 113.94 271.50 1,434.00 18.93%
    Total 5340000 · Solid Waste Salary Expense 740.70 5,230.63 9,565.00 54.69%
    5343000 · Solid Waste – Operating Expense        
      5344600 · Repair & Maint –  Solid Waste 0.00 488.50 1,000.00 48.85%
      5344900 · Other – Solid Waste (Landfill) 0.00 3,000.00 4,000.00 75.0%
    Total 5343000 · Solid Waste – Operating Expense 0.00 3,488.50 5,000.00 69.77%
    5810000 · Interfund Transfers (ALL – OUT)        
      5810004 · Transfer Out to WW/Sewer 575.00 7,284.92 20,000.00 36.43%
      5810005 · Water Utility to Water Reserve 1,965.08 17,685.72 23,581.00 75.0%
    Total 5810000 · Interfund Transfers (ALL – OUT) 2,540.08 24,970.64 43,581.00 57.3%
  Total Expense 16,780.54 109,759.37 165,395.00 66.36%
Net Income   (2,024.81) 7,084.74 0.00 100.0%