|
601 Water Fund
<br />Water, Sewer & Stormwater are separate Utility (aka Enterprise or Proprietary) Funds.
<br />2022 2023 2024 2024 YTD
<br />Account Number Description Actual Actual Budget Q3 % of Budget
<br />Water Fund Revenues:
<br />601-000-0000-36210 Interest on Investments (66,764) 32,000 98,448 307.6%
<br />601-000-0000-37100 Water Sales 1,634,375 1,804,464 1,962,564 212,068 10.8%
<br />601-000-0000-37120 Bulk Water - - 33,455 - 0.0%
<br />601-000-0000-37130 Water Lat Benefit Fee 12,400 13,200 - 7,000 #DIV/0!
<br />601-000-0000-37140 Water Access Revenue 685,000 550,000 1,695,000 1,125,000 66.4%
<br />601-000-0000-37150 Water Connections - Municipal 383,000 299,000 605,000 295,000 48.8%
<br />601-000-0000-37170 Meter Sales 113,708 123,176 155,675 40,938 26.3%
<br />Total Water Fund Revenues:2,775,000$ 2,794,808$ 4,483,694$ 1,778,454$ 39.7%
<br />Water Fund Expenses:
<br />Personnel
<br />601-494-9400-41010 Full-time Salaries 290,353 311,541 367,310 216,218 58.9%
<br />601-494-9400-41020 Overtime 7,979 14,508 9,040 7,063 78.1%
<br />601-494-9400-41210 PERA Contributions 64,026 24,063 27,548 16,358 59.4%
<br />601-494-9400-41216 MSRS Contributions - City Admin 634 690 701 503 71.8%
<br />601-494-9400-41220 FICA Contributions 17,069 19,266 23,334 14,255 61.1%
<br />601-494-9400-41230 Medicare Contributions 4,003 4,529 5,457 3,333 61.1%
<br />601-494-9400-41300 Insurance 57,068 63,158 74,341 40,899 55.0%
<br />601-494-9400-41325 Life Insurance 243 240 299 148 49.5%
<br />601-494-9400-41330 STD/LTD 1,514 1,671 2,008 1,009 50.2%
<br />601-494-9400-41301 Unemployment Insurance - - - - #DIV/0!
<br />601-494-9400-41600 Safety Clothing Allowance 675 432 665 310 46.6%
<br />601-494-9400-41510 Workers Compensation 5,718 9,833 6,692 10,768 160.9%
<br />Total Personnel 453,261$ 449,930$ 517,395$ 310,864$ 60.1%
<br />Materials and Supplies
<br />601-494-9400-42000 Office Supplies 954 225 800 992 124.0%
<br />601-494-9400-42120 Fuel, Oil and Fluids 10,272 8,985 10,500 3,819 36.4%
<br />601-494-9400-42030 Printed Forms 1,504 335 850 735 86.5%
<br />601-494-9400-42150 Operating Supplies 763 1,762 2,500 506 20.2%
<br />601-494-9400-42160 Chemicals 14,307 16,903 12,000 8,137 67.8%
<br />601-494-9400-42210 Repair/Maint. Supplies 11,170 10,135 10,000 6,834 68.3%
<br />601-494-9400-42300 Water Meters & Supplies 160,718 317,221 200,000 79,554 39.8%
<br />601-494-9400-44375 Personal Protective Equipment 297 591 650 268 41.3%
<br />601-494-9400-42400 Small Tools & Minor Equipment 3,779 11,312 4,500 5,000 111.1%
<br />Total Materials and Supplies 203,766$ 367,469$ 241,800$ 105,985$ 43.8%
<br />Charges and Services
<br />601-494-9400-43030 Engineering Services 3,430 37,089 25,000 22,249 89.0%
<br />22
|