Water Utility Finance Report (May 2020)

    May 21Oct ’20 – May 21YTD Budget% of Budget
 Income     
  3433000 · Water Utility Revenues    
   3433001 · Water Revenue7,808.4259,791.4497,000.0061.64%
   3433002 · Water Late Charges47.86358.16100.00358.16%
   3433003 · Disconnect Fee0.000.00100.000.0%
   3433004 · Reconnect Fee0.000.00100.000.0%
   3433005 · New Water Set Up Fees500.003,300.003,500.0094.29%
   3433007 · Water Late Notice Fee0.00199.12100.00199.12%
   3433011 · New Account Fee0.0090.0060.00150.0%
   3433012 · Return Check Fee(s)11.0052.00  
  Total 3433000 · Water Utility Revenues8,367.2863,790.72100,960.0063.18%
  3434000 · Solid Waste Revenues    
   3434001 · Solid Waste Revenue936.248,004.5513,000.0061.57%
   3434002 · Solid Waste Late Charges14.00102.15100.00102.15%
   3434003 · Special Pick Up Charges0.0055.5050.00111.0%
   3434004 · Solid Waste Late Notice Fee0.00194.34100.00194.34%
   3434005 · Solid Waste Franchise Fee731.847,642.3110,200.0074.93%
  Total 3434000 · Solid Waste Revenues1,682.0815,998.8523,450.0068.23%
  3611000 · Interest Earned/Misc Revenues    
   3612000 · Ameris -WU Interest6.91124.78530.0023.54%
   3613000 · Ameris – Cust Deposit Interest1.0418.2485.0021.46%
   3614000 · Ameris – Water Reserve Interest4.2281.27370.0021.97%
  Total 3611000 · Interest Earned/Misc Revenues12.17224.29985.0022.77%
  3810000 · Interfund Transfer (ALL – IN)    
   3810001 · Contingency Reserves (WU)2,653.0015,364.6020,000.0076.82%
   3810002 · Contingency Reserves (WW/Sewer)2,683.926,709.9220,000.0033.55%
  Total 3810000 · Interfund Transfer (ALL – IN)5,336.9222,074.5240,000.0055.19%
 Total Income15,398.45102,088.38165,395.0061.72%
 Expense    
  5331000 · Water Utility Salary Expense    
   5331200 · Water Utility Admin (Wendy)0.00949.25950.0099.92%
   5331201 · Water Utility Salary (Josh)1,120.0010,093.7515,220.0066.32%
   5331204 · Water Utility Salary (Trevor)242.654,426.314,427.0099.98%
   5331205 · Water Utility Salary (Anita)516.724,108.726,363.0064.57%
   5331206 · Water Utility Salary (Ashley)0.001,256.621,257.0099.97%
   5331207 · Water Utility Salary (Jenna)436.01436.014,467.009.76%
   5331208 · Water Utility Salary (Ryan)149.53149.531,350.0011.08%
   5332100 · Payroll Tax – Water345.913,168.434,945.0064.07%
   5332200 · Pension Expense – Water195.681,584.993,032.0052.28%
   5332300 · Health Insurance – Water319.033,387.074,738.0071.49%
  Total 5331000 · Water Utility Salary Expense3,325.5329,560.6846,749.0063.23%
  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 & Postage0.00444.011,000.0044.4%
   5334300 · Utilities713.705,536.708,000.0069.21%
   5334600 · Repair & Maintenance0.000.002,000.000.0%
   5334800 · Machinery & Equipment0.000.002,000.000.0%
   5334900 · Other Charges – Water (Labs)0.004,018.363,500.00114.81%
   5335100 · Office Supplies (Chlorine)0.00268.542,000.0013.43%
   5335200 · Operating – Meters & Components136.951,257.022,000.0062.85%
   5335400 · Dues/Memberships314.00314.00500.0062.8%
   5335500 · Education/Certification0.0075.001,500.005.0%
   5335600 · Contingency Equip & Repairs5,281.0015,364.6020,000.0076.82%
  Total 5333000 · Water Operating Expenses6,445.6533,009.1660,500.0054.56%
  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)0.002,276.642,277.0099.98%
   5341208 · Solid Waste Salary (Trevor)253.90523.562,643.0019.81%
   5341209 · Solid Waste Salary (Ryan)302.81302.81303.0099.94%
   5342100 · Payroll Tax – Solid Waste81.87524.111,583.0033.11%
   5342200 · Pension Expense – Solid Waste30.0060.00676.008.88%
   5342300 · Health Insurance – Solid Waste56.97157.561,434.0010.99%
  Total 5340000 · Solid Waste Salary Expense725.554,489.939,565.0046.94%
  5343000 · Solid Waste – Operating Expense    
   5344600 · Repair & Maint –  Solid Waste0.00488.501,000.0048.85%
   5344900 · Other – Solid Waste (Landfill)1,000.003,000.004,000.0075.0%
  Total 5343000 · Solid Waste – Operating Expense1,000.003,488.505,000.0069.77%
  5810000 · Interfund Transfers (ALL – OUT)    
   5810004 · Transfer Out to WW/Sewer2,683.926,709.9220,000.0033.55%
   5810005 · Water Utility to Water Reserve1,965.0815,720.6423,581.0066.67%
  Total 5810000 · Interfund Transfers (ALL – OUT)4,649.0022,430.5643,581.0051.47%
 Total Expense16,145.7392,978.83165,395.0056.22%
Net Income (747.28)9,109.550.00100.00