Water Utility Finance Report (May 2020)

        May 21 Oct ’20 – May 21 YTD Budget % of Budget
  Income          
    3433000 · Water Utility Revenues        
      3433001 · Water Revenue 7,808.42 59,791.44 97,000.00 61.64%
      3433002 · Water Late Charges 47.86 358.16 100.00 358.16%
      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 500.00 3,300.00 3,500.00 94.29%
      3433007 · Water Late Notice Fee 0.00 199.12 100.00 199.12%
      3433011 · New Account Fee 0.00 90.00 60.00 150.0%
      3433012 · Return Check Fee(s) 11.00 52.00    
    Total 3433000 · Water Utility Revenues 8,367.28 63,790.72 100,960.00 63.18%
    3434000 · Solid Waste Revenues        
      3434001 · Solid Waste Revenue 936.24 8,004.55 13,000.00 61.57%
      3434002 · Solid Waste Late Charges 14.00 102.15 100.00 102.15%
      3434003 · Special Pick Up Charges 0.00 55.50 50.00 111.0%
      3434004 · Solid Waste Late Notice Fee 0.00 194.34 100.00 194.34%
      3434005 · Solid Waste Franchise Fee 731.84 7,642.31 10,200.00 74.93%
    Total 3434000 · Solid Waste Revenues 1,682.08 15,998.85 23,450.00 68.23%
    3611000 · Interest Earned/Misc Revenues        
      3612000 · Ameris -WU Interest 6.91 124.78 530.00 23.54%
      3613000 · Ameris – Cust Deposit Interest 1.04 18.24 85.00 21.46%
      3614000 · Ameris – Water Reserve Interest 4.22 81.27 370.00 21.97%
    Total 3611000 · Interest Earned/Misc Revenues 12.17 224.29 985.00 22.77%
    3810000 · Interfund Transfer (ALL – IN)        
      3810001 · Contingency Reserves (WU) 2,653.00 15,364.60 20,000.00 76.82%
      3810002 · Contingency Reserves (WW/Sewer) 2,683.92 6,709.92 20,000.00 33.55%
    Total 3810000 · Interfund Transfer (ALL – IN) 5,336.92 22,074.52 40,000.00 55.19%
  Total Income 15,398.45 102,088.38 165,395.00 61.72%
  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 10,093.75 15,220.00 66.32%
      5331204 · Water Utility Salary (Trevor) 242.65 4,426.31 4,427.00 99.98%
      5331205 · Water Utility Salary (Anita) 516.72 4,108.72 6,363.00 64.57%
      5331206 · Water Utility Salary (Ashley) 0.00 1,256.62 1,257.00 99.97%
      5331207 · Water Utility Salary (Jenna) 436.01 436.01 4,467.00 9.76%
      5331208 · Water Utility Salary (Ryan) 149.53 149.53 1,350.00 11.08%
      5332100 · Payroll Tax – Water 345.91 3,168.43 4,945.00 64.07%
      5332200 · Pension Expense – Water 195.68 1,584.99 3,032.00 52.28%
      5332300 · Health Insurance – Water 319.03 3,387.07 4,738.00 71.49%
    Total 5331000 · Water Utility Salary Expense 3,325.53 29,560.68 46,749.00 63.23%
    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 444.01 1,000.00 44.4%
      5334300 · Utilities 713.70 5,536.70 8,000.00 69.21%
      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) 0.00 4,018.36 3,500.00 114.81%
      5335100 · Office Supplies (Chlorine) 0.00 268.54 2,000.00 13.43%
      5335200 · Operating – Meters & Components 136.95 1,257.02 2,000.00 62.85%
      5335400 · Dues/Memberships 314.00 314.00 500.00 62.8%
      5335500 · Education/Certification 0.00 75.00 1,500.00 5.0%
      5335600 · Contingency Equip & Repairs 5,281.00 15,364.60 20,000.00 76.82%
    Total 5333000 · Water Operating Expenses 6,445.65 33,009.16 60,500.00 54.56%
    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) 253.90 523.56 2,643.00 19.81%
      5341209 · Solid Waste Salary (Ryan) 302.81 302.81 303.00 99.94%
      5342100 · Payroll Tax – Solid Waste 81.87 524.11 1,583.00 33.11%
      5342200 · Pension Expense – Solid Waste 30.00 60.00 676.00 8.88%
      5342300 · Health Insurance – Solid Waste 56.97 157.56 1,434.00 10.99%
    Total 5340000 · Solid Waste Salary Expense 725.55 4,489.93 9,565.00 46.94%
    5343000 · Solid Waste – Operating Expense        
      5344600 · Repair & Maint –  Solid Waste 0.00 488.50 1,000.00 48.85%
      5344900 · Other – Solid Waste (Landfill) 1,000.00 3,000.00 4,000.00 75.0%
    Total 5343000 · Solid Waste – Operating Expense 1,000.00 3,488.50 5,000.00 69.77%
    5810000 · Interfund Transfers (ALL – OUT)        
      5810004 · Transfer Out to WW/Sewer 2,683.92 6,709.92 20,000.00 33.55%
      5810005 · Water Utility to Water Reserve 1,965.08 15,720.64 23,581.00 66.67%
    Total 5810000 · Interfund Transfers (ALL – OUT) 4,649.00 22,430.56 43,581.00 51.47%
  Total Expense 16,145.73 92,978.83 165,395.00 56.22%
Net Income   (747.28) 9,109.55 0.00 100.00