Water Utility Finance Report – April 2020

    Apr 20Oct ’19 – Apr 20YTD Budget% of Budget
 Income    
  3433000 · Water Utility Revenues    
   3433001 · Water Revenue $   7,425.22 $        51,829.99 $   84,000.0061.7%
   3433002 · Water Late Charges $        51.28 $             314.84 $        100.00314.84%
   3433003 · Disconnect Fee $              –   $               30.00 $        100.0030.0%
   3433004 · Reconnect Fee $              –   $               30.00 $        100.0030.0%
   3433005 · New Water Set Up Fees $              –   $          1,400.00 $     3,500.0040.0%
   3433007 · Water Late Notice Fee $        20.50 $             102.49 $        100.00102.49%
   3433011 · New Account Fee $        60.00 $             300.00 $          60.00500.0%
   3433012 · Return Check Fee(s) $              –   $                    –   $          30.000.0%
  Total 3433000 · Water Utility Revenues $   7,557.00 $        54,007.32 $   87,990.0061.38%
  3434000 · Solid Waste Revenues    
   3434001 · Solid Waste Revenue $   1,082.77 $          7,207.42 $   13,000.0055.44%
   3434002 · Solid Waste Late Charges $        21.20 $             130.62 $        100.00130.62%
   3434003 · Special Pick Up Charges $      159.01 $             341.01 $          30.001,136.7%
   3434004 · Solid Waste Late Notice Fee $        19.00 $               84.48 $        100.0084.48%
   3434005 · Solid Waste Franchise Fee $      588.67 $          6,349.80 $   11,000.0057.73%
  Total 3434000 · Solid Waste Revenues $   1,870.65 $        14,113.33 $   24,230.0058.25%
  3611000 · Interest Earned/Misc Revenues    
   3612000 · Ameris -WU Interest $        38.76 $             864.16 $     1,700.0050.83%
   3613000 · Ameris – Cust Deposit Interest $        12.46 $             138.50 $        400.0034.63%
   3614000 · Ameris – Water Reserve Interest $        28.30 $             604.59 $     1,150.0052.57%
  Total 3611000 · Interest Earned/Misc Revenues $        79.52 $          1,607.25 $     3,250.0049.45%
  3810000 · Interfund Transfer (ALL – IN)    
   3810001 · Contingency Reserves (WU) $   1,409.20 $          4,652.86 $   20,000.0023.26%
   3810002 · Contingency Reserves (WW/Sewer) $   1,150.00 $          1,150.00 $   20,000.005.75%
  Total 3810000 · Interfund Transfer (ALL – IN) $   2,559.20 $          5,802.86 $   40,000.0014.51%
 Total Income $ 12,066.37 $        75,530.76 $ 155,470.0048.58%
 Expense    
  5331000 · Water Utility Salary Expense    
   5331200 · Water Utility Admin (Wendy) $   1,356.25 $          8,994.36 $   15,235.0059.04%
   5331201 · Water Utility (Tracy) $              –   $                    –   $   13,834.000.0%
   5331204 · Water Utility (Trevor) $      748.98 $          4,044.56 $     7,610.0053.15%
   5332100 · Payroll Tax – Water $      374.76 $          2,353.31 $     5,321.0044.23%
   5332200 · Pension Expense – Water $      219.63 $          1,351.93 $     4,032.0033.53%
   5332300 · Health Insurance – Water $      154.74 $             825.28 $     5,115.0016.14%
  Total 5331000 · Water Utility Salary Expense $   2,854.36 $        17,569.44 $   51,147.0034.35%
  5333000 · Water Operating Expenses    
   5333100 · Professional Svcs $      379.39 $          5,429.82 $     9,700.0055.98%
   5333200 · Accounting/Auditing $              –   $                    –   $     1,500.000.0%
   5333400 · Other – Services (Tower) $              –   $          4,561.87 $     9,000.0050.69%
   5334200 · Freight & Postage $      264.03 $             599.44 $        550.00108.99%
   5334300 · Utilities $      691.94 $          4,802.02 $     5,500.0087.31%
   5334600 · Repair & Maintenance $      200.00 $             690.00 $     1,400.0049.29%
   5334800 · Machinery & Equipment $              –   $             801.39 $     2,200.0036.43%
   5334900 · Other Charges – Water (Labs) $        68.00 $               68.00 $     1,250.005.44%
   5335100 · Office Supplies (Chlorine) $      125.77 $          1,399.53 $     3,000.0046.65%
   5335200 · Operating – Meters & Components $      447.03 $          1,538.00 $     2,000.0076.9%
   5335400 · Dues/Memberships $              –   $                    –   $        825.000.0%
   5335500 · Education/Certification $              –   $                    –   $        300.000.0%
   5335600 · Contingency Equip & Repairs $   2,559.20 $          5,802.86 $   20,000.0029.01%
  Total 5333000 · Water Operating Expenses $   4,735.36 $        25,692.93 $   57,225.0044.9%
  5340000 · Solid Waste Salary Expense    
   5341200 · Solid Waste Salary (Alex) $   1,202.91 $          6,540.52 $   11,465.0057.05%
   5342100 · Payroll Tax – Solid Waste $      128.04 $             709.93 $     1,168.0060.78%
   5342200 · Pension Expense – Solid Waste $      121.50 $             660.50 $     1,053.0062.73%
   5342300 · Health Insurance – Solid Waste $      394.32 $          2,103.04 $     1,421.00148.0%
  Total 5340000 · Solid Waste Salary Expense $   1,846.77 $        10,013.99 $   15,107.0066.29%
  5343000 · Solid Waste – Operating Expense    
   5344600 · Repair & Maint –  Solid Waste $              –   $               69.00 $     1,000.006.9%
   5344900 · Other – Solid Waste (Landfill) $              –   $          2,000.00 $     2,000.00100.0%
  Total 5343000 · Solid Waste – Operating Expense $              –   $          2,069.00 $     3,000.0068.97%
  5810000 · Interfund Transfers (ALL – OUT)    
   5810004 · Transfer Out to WW/Sewer $   1,150.00 $          1,150.00 $   20,000.005.75%
   5810005 · Water Utility to Water Reserve $      749.25 $          5,244.75 $     8,991.0058.33%
  Total 5810000 · Interfund Transfers (ALL – OUT) $   1,899.25 $          6,394.75 $   28,991.0022.06%
 Total Expense $ 11,335.74 $        61,740.11 $ 155,470.0039.71%
Net Income $      730.63 $        13,790.65 $                –  100.0%