Water Utility Finance Report (March 2020)

    Mar 21Oct ’20 – Mar 21YTD Budget% of Budget
 Income     
  3433000 · Water Utility Revenues    
   3433001 · Water Revenue6,922.4844,196.0197,000.0045.56%
   3433002 · Water Late Charges70.54267.41100.00267.41%
   3433003 · Disconnect Fee0.000.00100.000.0%
   3433004 · Reconnect Fee0.000.00100.000.0%
   3433005 · New Water Set Up Fees1,400.001,400.003,500.0040.0%
   3433007 · Water Late Notice Fee46.14139.77100.00139.77%
   3433011 · New Account Fee30.0030.0060.0050.0%
  Total 3433000 · Water Utility Revenues8,469.1646,033.19100,960.0045.6%
  3434000 · Solid Waste Revenues    
   3434001 · Solid Waste Revenue1,038.766,072.1113,000.0046.71%
   3434002 · Solid Waste Late Charges27.7972.15100.0072.15%
   3434003 · Special Pick Up Charges0.0055.5050.00111.0%
   3434004 · Solid Waste Late Notice Fee46.14134.99100.00134.99%
   3434005 · Solid Waste Franchise Fee852.805,555.0710,200.0054.46%
  Total 3434000 · Solid Waste Revenues1,965.4911,889.8223,450.0050.7%
  3611000 · Interest Earned/Misc Revenues    
   3612000 · Ameris -WU Interest8.03110.37530.0020.83%
   3613000 · Ameris – Cust Deposit Interest1.2016.1085.0018.94%
   3614000 · Ameris – Water Reserve Interest5.3472.31370.0019.54%
  Total 3611000 · Interest Earned/Misc Revenues14.57198.78985.0020.18%
  3810000 · Interfund Transfer (ALL – IN)    
   3810001 · Contingency Reserves (WU)0.000.0020,000.000.0%
   3810002 · Contingency Reserves (WW/Sewer)5,749.809,425.8020,000.0047.13%
  Total 3810000 · Interfund Transfer (ALL – IN)5,749.809,425.8040,000.0023.57%
 Total Income16,199.0267,547.59165,395.0040.84%
 Expense    
  5331000 · Water Utility Salary Expense    
   5331200 · Water Utility Admin (Wendy)0.00949.25950.0099.92%
   5331201 · Water Utility Salary (Josh)1,146.257,293.7515,220.0047.92%
   5331204 · Water Utility Salary (Trevor)519.053,428.538,150.0042.07%
   5331205 · Water Utility Salary (Anita)487.192,893.375,363.0053.95%
   5331206 · Water Utility Salary (Ashley)217.22915.472,624.0034.89%
   5332100 · Payroll Tax – Water358.132,301.574,945.0046.54%
   5332200 · Pension Expense – Water227.591,057.413,032.0034.88%
   5332300 · Health Insurance – Water376.002,348.884,738.0049.58%
  Total 5331000 · Water Utility Salary Expense3,331.4321,188.2345,022.0047.06%
  5333000 · Water Operating Expenses    
   5333100 · Professional Svcs0.001,032.207,500.0013.76%
   5333200 · Accounting/Auditing0.000.001,500.000.0%
   5333400 · Other – Services (Tower)0.004,698.739,000.0052.21%
   5334200 · Freight & Postage234.01444.011,000.0044.4%
   5334300 · Utilities677.164,145.188,000.0051.82%
   5334600 · Repair & Maintenance0.000.002,000.000.0%
   5334800 · Machinery & Equipment0.000.002,000.000.0%
   5334900 · Other Charges – Water (Labs)379.393,259.583,500.0093.13%
   5335100 · Office Supplies (Chlorine)0.00104.002,000.005.2%
   5335200 · Operating – Meters & Components648.621,053.122,000.0052.66%
   5335400 · Dues/Memberships0.000.00500.000.0%
   5335500 · Education/Certification0.0075.001,500.005.0%
   5335600 · Contingency Equip & Repairs5,399.805,399.8020,000.0027.0%
  Total 5333000 · Water Operating Expenses7,338.9820,211.6260,500.0033.41%
  5340000 · Solid Waste Salary Expense    
   5341205 · Solid Waste Salary (Tyler)0.00456.75457.0099.95%
   5341206 · Solid Waste Salary (Hunter)0.00188.50192.0098.18%
   5341207 · Solid Waste Salary (Michael)520.002,154.766,680.0032.26%
   5341208 · Solid waste Salary (Trevor)0.00269.66270.0099.87%
   5342100 · Payroll Tax – Solid Waste69.28432.911,583.0027.35%
   5342200 · Pension Expense – Solid Waste0.0030.00676.004.44%
   5342300 · Health Insurance – Solid Waste0.00100.591,434.007.02%
  Total 5340000 · Solid Waste Salary Expense589.283,633.1711,292.0032.18%
  5343000 · Solid Waste – Operating Expense    
   5344600 · Repair & Maint –  Solid Waste308.00488.501,000.0048.85%
   5344900 · Other – Solid Waste (Landfill)1,000.002,000.004,000.0050.0%
  Total 5343000 · Solid Waste – Operating Expense1,308.002,488.505,000.0049.77%
  5810000 · Interfund Transfers (ALL – OUT)    
   5810004 · Transfer Out to WW/Sewer5,749.809,425.8020,000.0047.13%
   5810005 · Water Utility to Water Reserve1,965.0811,790.4823,581.0050.0%
  Total 5810000 · Interfund Transfers (ALL – OUT)7,714.8821,216.2843,581.0048.68%
 Total Expense20,282.5768,737.80165,395.0041.56%
Net Income (4,083.55)(1,190.21)0.00100.0%