July 2020 – Water Utility Fund Report

        Jul 20 Oct ’19 – Jul 20 YTD Budget % of Budget
  Income          
    3433000 · Water Utility Revenues        
      3433001 · Water Revenue 8,081.73 77,674.12 84,000.00 92.47%
      3433002 · Water Late Charges 94.37 513.04 100.00 513.04%
      3433003 · Disconnect Fee 0.00 30.00 100.00 30.0%
      3433004 · Reconnect Fee 0.00 30.00 100.00 30.0%
      3433005 · New Water Set Up Fees 0.00 1,400.00 3,500.00 40.0%
      3433007 · Water Late Notice Fee 16.50 140.47 100.00 140.47%
      3433011 · New Account Fee 30.00 480.00 60.00 800.0%
      3433012 · Return Check Fee(s) 0.00 0.00 30.00 0.0%
    Total 3433000 · Water Utility Revenues 8,222.60 80,267.63 87,990.00 91.22%
    3434000 · Solid Waste Revenues        
      3434001 · Solid Waste Revenue 1,032.41 10,347.24 13,000.00 79.59%
      3434002 · Solid Waste Late Charges 21.73 188.35 100.00 188.35%
      3434003 · Special Pick Up Charges 123.50 480.50 30.00 1,601.67%
      3434004 · Solid Waste Late Notice Fee 12.00 116.46 100.00 116.46%
      3434005 · Solid Waste Franchise Fee 813.54 8,542.77 11,000.00 77.66%
    Total 3434000 · Solid Waste Revenues 2,003.18 19,675.32 24,230.00 81.2%
    3611000 · Interest Earned/Misc Revenues        
      3612000 · Ameris -WU Interest 44.56 992.10 1,700.00 58.36%
      3613000 · Ameris – Cust Deposit Interest 6.68 158.20 400.00 39.55%
      3614000 · Ameris – Water Reserve Interest 30.43 693.20 1,150.00 60.28%
    Total 3611000 · Interest Earned/Misc Revenues 81.67 1,843.50 3,250.00 56.72%
    3810000 · Interfund Transfer (ALL – IN)        
      3810001 · Contingency Reserves (WU) 0.00 4,652.86 20,000.00 23.26%
      3810002 · Contingency Reserves (WW/Sewer) 0.00 1,150.00 20,000.00 5.75%
    Total 3810000 · Interfund Transfer (ALL – IN) 0.00 5,802.86 40,000.00 14.51%
  Total Income 10,307.45 107,589.31 155,470.00 69.2%
  Expense        
    5331000 · Water Utility Salary Expense        
      5331200 · Water Utility Admin (Wendy) 922.25 11,989.74 15,235.00 78.7%
      5331201 · Water Utility (Josh) 1,024.00 2,150.40 11,834.00 18.17%
      5331204 · Water Utility (Trevor) 499.32 5,534.07 7,610.00 72.72%
      5332100 · Payroll Tax – Water 371.23 3,374.86 5,321.00 63.43%
      5332200 · Pension Expense – Water 148.23 1,812.57 3,032.00 59.78%
      5332300 · Health Insurance – Water 103.16 1,134.76 5,115.00 22.19%
    Total 5331000 · Water Utility Salary Expense 3,068.19 25,996.40 48,147.00 53.99%
    5333000 · Water Operating Expenses        
      5333100 · Professional Svcs 502.48 6,691.08 9,700.00 68.98%
      5333200 · Accounting/Auditing 1,000.00 1,000.00 1,500.00 66.67%
      5333400 · Other – Services (Tower) 0.00 9,123.74 9,123.74 100.0%
      5334200 · Freight & Postage 0.00 625.70 650.00 96.26%
      5334300 · Utilities 675.28 6,605.51 7,500.00 88.07%
      5334600 · Repair & Maintenance 0.00 690.00 1,400.00 49.29%
      5334800 · Machinery & Equipment 0.00 801.39 1,576.26 50.84%
      5334900 · Other Charges – Water (Labs) 0.00 68.00 150.00 45.33%
      5335100 · Office Supplies (Chlorine) 189.39 1,794.16 3,000.00 59.81%
      5335200 · Operating – Meters & Components 66.95 1,883.93 2,000.00 94.2%
      5335400 · Dues/Memberships 0.00 314.00 825.00 38.06%
      5335500 · Education/Certification 0.00 0.00 300.00 0.0%
      5335600 · Contingency Equip & Repairs 0.00 5,802.86 20,000.00 29.01%
      5335601 · Adm – Miscellaneous 0.00 0.00    
    Total 5333000 · Water Operating Expenses 2,434.10 35,400.37 57,725.00 61.33%
    5340000 · Solid Waste Salary Expense        
      5341200 · Solid Waste Salary (Alex) 58.74 8,211.20 8,211.20 100.0%
      5341205 · Solid Waste Salary (Tyler) 322.00 322.00 3,253.80 9.9%
      5342100 · Payroll Tax – Solid Waste 46.64 927.28 1,168.00 79.39%
      5342200 · Pension Expense – Solid Waste 6.08 828.58 1,053.00 78.69%
      5342300 · Health Insurance – Solid Waste 131.44 2,760.24 3,421.00 80.69%
    Total 5340000 · Solid Waste Salary Expense 564.90 13,049.30 17,107.00 76.28%
    5343000 · Solid Waste – Operating Expense        
      5344600 · Repair & Maint –  Solid Waste 0.00 97.00 1,000.00 9.7%
      5344900 · Other – Solid Waste (Landfill) 0.00 2,500.00 2,500.00 100.0%
    Total 5343000 · Solid Waste – Operating Expense 0.00 2,597.00 3,500.00 74.2%
    5810000 · Interfund Transfers (ALL – OUT)        
      5810004 · Transfer Out to WW/Sewer 0.00 1,150.00 20,000.00 5.75%
      5810005 · Water Utility to Water Reserve 749.25 7,492.50 8,991.00 83.33%
    Total 5810000 · Interfund Transfers (ALL – OUT) 749.25 8,642.50 28,991.00 29.81%
  Total Expense 6,816.44 85,685.57 155,470.00 55.11%
Net Income   3,491.01 21,903.74 0.00 100.0%