Water Utility Finance Report – April 2020

        Apr 20 Oct ’19 – Apr 20 YTD Budget % of Budget
  Income        
    3433000 · Water Utility Revenues        
      3433001 · Water Revenue  $   7,425.22  $        51,829.99  $   84,000.00 61.7%
      3433002 · Water Late Charges  $        51.28  $             314.84  $        100.00 314.84%
      3433003 · Disconnect Fee  $              –    $               30.00  $        100.00 30.0%
      3433004 · Reconnect Fee  $              –    $               30.00  $        100.00 30.0%
      3433005 · New Water Set Up Fees  $              –    $          1,400.00  $     3,500.00 40.0%
      3433007 · Water Late Notice Fee  $        20.50  $             102.49  $        100.00 102.49%
      3433011 · New Account Fee  $        60.00  $             300.00  $          60.00 500.0%
      3433012 · Return Check Fee(s)  $              –    $                    –    $          30.00 0.0%
    Total 3433000 · Water Utility Revenues  $   7,557.00  $        54,007.32  $   87,990.00 61.38%
    3434000 · Solid Waste Revenues        
      3434001 · Solid Waste Revenue  $   1,082.77  $          7,207.42  $   13,000.00 55.44%
      3434002 · Solid Waste Late Charges  $        21.20  $             130.62  $        100.00 130.62%
      3434003 · Special Pick Up Charges  $      159.01  $             341.01  $          30.00 1,136.7%
      3434004 · Solid Waste Late Notice Fee  $        19.00  $               84.48  $        100.00 84.48%
      3434005 · Solid Waste Franchise Fee  $      588.67  $          6,349.80  $   11,000.00 57.73%
    Total 3434000 · Solid Waste Revenues  $   1,870.65  $        14,113.33  $   24,230.00 58.25%
    3611000 · Interest Earned/Misc Revenues        
      3612000 · Ameris -WU Interest  $        38.76  $             864.16  $     1,700.00 50.83%
      3613000 · Ameris – Cust Deposit Interest  $        12.46  $             138.50  $        400.00 34.63%
      3614000 · Ameris – Water Reserve Interest  $        28.30  $             604.59  $     1,150.00 52.57%
    Total 3611000 · Interest Earned/Misc Revenues  $        79.52  $          1,607.25  $     3,250.00 49.45%
    3810000 · Interfund Transfer (ALL – IN)        
      3810001 · Contingency Reserves (WU)  $   1,409.20  $          4,652.86  $   20,000.00 23.26%
      3810002 · Contingency Reserves (WW/Sewer)  $   1,150.00  $          1,150.00  $   20,000.00 5.75%
    Total 3810000 · Interfund Transfer (ALL – IN)  $   2,559.20  $          5,802.86  $   40,000.00 14.51%
  Total Income  $ 12,066.37  $        75,530.76  $ 155,470.00 48.58%
  Expense        
    5331000 · Water Utility Salary Expense        
      5331200 · Water Utility Admin (Wendy)  $   1,356.25  $          8,994.36  $   15,235.00 59.04%
      5331201 · Water Utility (Tracy)  $              –    $                    –    $   13,834.00 0.0%
      5331204 · Water Utility (Trevor)  $      748.98  $          4,044.56  $     7,610.00 53.15%
      5332100 · Payroll Tax – Water  $      374.76  $          2,353.31  $     5,321.00 44.23%
      5332200 · Pension Expense – Water  $      219.63  $          1,351.93  $     4,032.00 33.53%
      5332300 · Health Insurance – Water  $      154.74  $             825.28  $     5,115.00 16.14%
    Total 5331000 · Water Utility Salary Expense  $   2,854.36  $        17,569.44  $   51,147.00 34.35%
    5333000 · Water Operating Expenses        
      5333100 · Professional Svcs  $      379.39  $          5,429.82  $     9,700.00 55.98%
      5333200 · Accounting/Auditing  $              –    $                    –    $     1,500.00 0.0%
      5333400 · Other – Services (Tower)  $              –    $          4,561.87  $     9,000.00 50.69%
      5334200 · Freight & Postage  $      264.03  $             599.44  $        550.00 108.99%
      5334300 · Utilities  $      691.94  $          4,802.02  $     5,500.00 87.31%
      5334600 · Repair & Maintenance  $      200.00  $             690.00  $     1,400.00 49.29%
      5334800 · Machinery & Equipment  $              –    $             801.39  $     2,200.00 36.43%
      5334900 · Other Charges – Water (Labs)  $        68.00  $               68.00  $     1,250.00 5.44%
      5335100 · Office Supplies (Chlorine)  $      125.77  $          1,399.53  $     3,000.00 46.65%
      5335200 · Operating – Meters & Components  $      447.03  $          1,538.00  $     2,000.00 76.9%
      5335400 · Dues/Memberships  $              –    $                    –    $        825.00 0.0%
      5335500 · Education/Certification  $              –    $                    –    $        300.00 0.0%
      5335600 · Contingency Equip & Repairs  $   2,559.20  $          5,802.86  $   20,000.00 29.01%
    Total 5333000 · Water Operating Expenses  $   4,735.36  $        25,692.93  $   57,225.00 44.9%
    5340000 · Solid Waste Salary Expense        
      5341200 · Solid Waste Salary (Alex)  $   1,202.91  $          6,540.52  $   11,465.00 57.05%
      5342100 · Payroll Tax – Solid Waste  $      128.04  $             709.93  $     1,168.00 60.78%
      5342200 · Pension Expense – Solid Waste  $      121.50  $             660.50  $     1,053.00 62.73%
      5342300 · Health Insurance – Solid Waste  $      394.32  $          2,103.04  $     1,421.00 148.0%
    Total 5340000 · Solid Waste Salary Expense  $   1,846.77  $        10,013.99  $   15,107.00 66.29%
    5343000 · Solid Waste – Operating Expense        
      5344600 · Repair & Maint –  Solid Waste  $              –    $               69.00  $     1,000.00 6.9%
      5344900 · Other – Solid Waste (Landfill)  $              –    $          2,000.00  $     2,000.00 100.0%
    Total 5343000 · Solid Waste – Operating Expense  $              –    $          2,069.00  $     3,000.00 68.97%
    5810000 · Interfund Transfers (ALL – OUT)        
      5810004 · Transfer Out to WW/Sewer  $   1,150.00  $          1,150.00  $   20,000.00 5.75%
      5810005 · Water Utility to Water Reserve  $      749.25  $          5,244.75  $     8,991.00 58.33%
    Total 5810000 · Interfund Transfers (ALL – OUT)  $   1,899.25  $          6,394.75  $   28,991.00 22.06%
  Total Expense  $ 11,335.74  $        61,740.11  $ 155,470.00 39.71%
Net Income  $      730.63  $        13,790.65  $                –   100.0%