Water Utility Finance Report (July 2021)

        Jul 21 Oct ’20 – Jul 21 YTD Budget % of Budget
  Income          
    3433000 · Water Utility Revenues        
      3433001 · Water Revenue 8,090.73 76,889.36 97,000.00 79.27%
      3433002 · Water Late Charges 87.79 537.54 100.00 537.54%
      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 1,400.00 4,700.00 3,500.00 134.29%
      3433007 · Water Late Notice Fee 0.00 201.14 100.00 201.14%
      3433011 · New Account Fee 0.00 90.00 60.00 150.0%
      3433012 · Return Check Fee(s) 41.00 93.00    
    Total 3433000 · Water Utility Revenues 9,619.52 82,511.04 100,960.00 81.73%
    3434000 · Solid Waste Revenues        
      3434001 · Solid Waste Revenue 933.94 9,914.65 13,000.00 76.27%
      3434002 · Solid Waste Late Charges 30.55 163.24 100.00 163.24%
      3434003 · Special Pick Up Charges 73.50 129.00 50.00 258.0%
      3434004 · Solid Waste Late Notice Fee 0.00 196.36 100.00 196.36%
      3434005 · Solid Waste Franchise Fee 177.36 8,294.31 10,200.00 81.32%
    Total 3434000 · Solid Waste Revenues 1,215.35 18,697.56 23,450.00 79.73%
    3611000 · Interest Earned/Misc Revenues        
      3612000 · Ameris -WU Interest 7.50 140.43 530.00 26.5%
      3613000 · Ameris – Cust Deposit Interest 1.11 20.56 85.00 24.19%
      3614000 · Ameris – Water Reserve Interest 4.44 90.65 370.00 24.5%
    Total 3611000 · Interest Earned/Misc Revenues 13.05 251.64 985.00 25.55%
    3810000 · Interfund Transfer (ALL – IN)        
      3810001 · Contingency Reserves (WU) 0.00 18,946.87 20,000.00 94.73%
      3810002 · Contingency Reserves (WW/Sewer) 0.00 7,284.92 20,000.00 36.43%
    Total 3810000 · Interfund Transfer (ALL – IN) 0.00 26,231.79 40,000.00 65.58%
  Total Income 10,847.92 127,692.03 165,395.00 77.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,172.50 12,399.37 15,220.00 81.47%
      5331204 · Water Utility Salary (Trevor) 0.00 4,426.31 4,427.00 99.98%
      5331205 · Water Utility Salary (Anita) 519.68 5,149.06 6,363.00 80.92%
      5331206 · Water Utility Salary (Ashley) 0.00 1,256.62 1,257.00 99.97%
      5331207 · Water Utility Salary (Jenna) 730.80 1,927.01 4,467.00 43.14%
      5331208 · Water Utility Salary (Ryan) 281.25 727.73 1,350.00 53.91%
      5332100 · Payroll Tax – Water 355.78 3,881.11 4,945.00 78.49%
      5332200 · Pension Expense – Water 172.35 1,925.84 3,032.00 63.52%
      5332300 · Health Insurance – Water 262.06 3,911.19 4,738.00 82.55%
    Total 5331000 · Water Utility Salary Expense 3,494.42 36,553.49 46,749.00 78.19%
    5333000 · Water Operating Expenses        
      5333100 · Professional Svcs 0.00 600.00 7,500.00 8.0%
      5333200 · Accounting/Auditing 1,500.00 1,500.00 1,500.00 100.0%
      5333400 · Other – Services (Tower) 0.00 9,397.46 9,000.00 104.42%
      5334200 · Freight & Postage 216.00 660.01 1,000.00 66.0%
      5334300 · Utilities 678.18 6,913.81 8,000.00 86.42%
      5334600 · Repair & Maintenance 0.00 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 5,209.34 3,500.00 148.84%
      5335100 · Office Supplies (Chlorine) 0.00 351.74 2,000.00 17.59%
      5335200 · Operating – Meters & Components 900.62 2,400.59 2,000.00 120.03%
      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 0.00 18,946.87 20,000.00 94.73%
    Total 5333000 · Water Operating Expenses 3,674.19 46,684.72 60,500.00 77.17%
    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) 428.11 1,423.82 2,643.00 53.87%
      5341209 · Solid Waste Salary (Ryan) 0.00 302.81 303.00 99.94%
      5342100 · Payroll Tax – Solid Waste 89.31 711.59 1,583.00 44.95%
      5342200 · Pension Expense – Solid Waste 52.03 168.47 676.00 24.92%
      5342300 · Health Insurance – Solid Waste 113.94 385.44 1,434.00 26.88%
    Total 5340000 · Solid Waste Salary Expense 683.39 5,914.02 9,565.00 61.83%
    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 0.00 7,284.92 20,000.00 36.43%
      5810005 · Water Utility to Water Reserve 1,965.08 19,650.80 23,581.00 83.33%
    Total 5810000 · Interfund Transfers (ALL – OUT) 1,965.08 26,935.72 43,581.00 61.81%
  Total Expense 9,817.08 119,576.45 165,395.00 72.3%
Net Income   1,030.84 8,115.58 0.00 100.0%