Water Utility Finance Report (March 2020)

        Mar 21 Oct ’20 – Mar 21 YTD Budget % of Budget
  Income          
    3433000 · Water Utility Revenues        
      3433001 · Water Revenue 6,922.48 44,196.01 97,000.00 45.56%
      3433002 · Water Late Charges 70.54 267.41 100.00 267.41%
      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 1,400.00 3,500.00 40.0%
      3433007 · Water Late Notice Fee 46.14 139.77 100.00 139.77%
      3433011 · New Account Fee 30.00 30.00 60.00 50.0%
    Total 3433000 · Water Utility Revenues 8,469.16 46,033.19 100,960.00 45.6%
    3434000 · Solid Waste Revenues        
      3434001 · Solid Waste Revenue 1,038.76 6,072.11 13,000.00 46.71%
      3434002 · Solid Waste Late Charges 27.79 72.15 100.00 72.15%
      3434003 · Special Pick Up Charges 0.00 55.50 50.00 111.0%
      3434004 · Solid Waste Late Notice Fee 46.14 134.99 100.00 134.99%
      3434005 · Solid Waste Franchise Fee 852.80 5,555.07 10,200.00 54.46%
    Total 3434000 · Solid Waste Revenues 1,965.49 11,889.82 23,450.00 50.7%
    3611000 · Interest Earned/Misc Revenues        
      3612000 · Ameris -WU Interest 8.03 110.37 530.00 20.83%
      3613000 · Ameris – Cust Deposit Interest 1.20 16.10 85.00 18.94%
      3614000 · Ameris – Water Reserve Interest 5.34 72.31 370.00 19.54%
    Total 3611000 · Interest Earned/Misc Revenues 14.57 198.78 985.00 20.18%
    3810000 · Interfund Transfer (ALL – IN)        
      3810001 · Contingency Reserves (WU) 0.00 0.00 20,000.00 0.0%
      3810002 · Contingency Reserves (WW/Sewer) 5,749.80 9,425.80 20,000.00 47.13%
    Total 3810000 · Interfund Transfer (ALL – IN) 5,749.80 9,425.80 40,000.00 23.57%
  Total Income 16,199.02 67,547.59 165,395.00 40.84%
  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,146.25 7,293.75 15,220.00 47.92%
      5331204 · Water Utility Salary (Trevor) 519.05 3,428.53 8,150.00 42.07%
      5331205 · Water Utility Salary (Anita) 487.19 2,893.37 5,363.00 53.95%
      5331206 · Water Utility Salary (Ashley) 217.22 915.47 2,624.00 34.89%
      5332100 · Payroll Tax – Water 358.13 2,301.57 4,945.00 46.54%
      5332200 · Pension Expense – Water 227.59 1,057.41 3,032.00 34.88%
      5332300 · Health Insurance – Water 376.00 2,348.88 4,738.00 49.58%
    Total 5331000 · Water Utility Salary Expense 3,331.43 21,188.23 45,022.00 47.06%
    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 234.01 444.01 1,000.00 44.4%
      5334300 · Utilities 677.16 4,145.18 8,000.00 51.82%
      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) 379.39 3,259.58 3,500.00 93.13%
      5335100 · Office Supplies (Chlorine) 0.00 104.00 2,000.00 5.2%
      5335200 · Operating – Meters & Components 648.62 1,053.12 2,000.00 52.66%
      5335400 · Dues/Memberships 0.00 0.00 500.00 0.0%
      5335500 · Education/Certification 0.00 75.00 1,500.00 5.0%
      5335600 · Contingency Equip & Repairs 5,399.80 5,399.80 20,000.00 27.0%
    Total 5333000 · Water Operating Expenses 7,338.98 20,211.62 60,500.00 33.41%
    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) 520.00 2,154.76 6,680.00 32.26%
      5341208 · Solid waste Salary (Trevor) 0.00 269.66 270.00 99.87%
      5342100 · Payroll Tax – Solid Waste 69.28 432.91 1,583.00 27.35%
      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 589.28 3,633.17 11,292.00 32.18%
    5343000 · Solid Waste – Operating Expense        
      5344600 · Repair & Maint –  Solid Waste 308.00 488.50 1,000.00 48.85%
      5344900 · Other – Solid Waste (Landfill) 1,000.00 2,000.00 4,000.00 50.0%
    Total 5343000 · Solid Waste – Operating Expense 1,308.00 2,488.50 5,000.00 49.77%
    5810000 · Interfund Transfers (ALL – OUT)        
      5810004 · Transfer Out to WW/Sewer 5,749.80 9,425.80 20,000.00 47.13%
      5810005 · Water Utility to Water Reserve 1,965.08 11,790.48 23,581.00 50.0%
    Total 5810000 · Interfund Transfers (ALL – OUT) 7,714.88 21,216.28 43,581.00 48.68%
  Total Expense 20,282.57 68,737.80 165,395.00 41.56%
Net Income   (4,083.55) (1,190.21) 0.00 100.0%