|
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 Q2 % of Budget
<br />Water Fund Revenues:
<br />601-000-0000-36210 Interest on Investments (66,764) 32,000 98,448 308%
<br />601-000-0000-37100 Water Sales 1,634,375 1,804,464 1,962,564 212,160 11%
<br />601-000-0000-37120 Bulk Water - - 33,455 - 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,035,000 61%
<br />601-000-0000-37150 Water Connections - Municipal 383,000 299,000 605,000 241,000 40%
<br />601-000-0000-37170 Meter Sales 113,708 123,176 155,675 28,757 18%
<br />Total Water Fund Revenues:2,775,000$ 2,794,808$ 4,483,694$ 1,622,365$ 36.2%
<br />Water Fund Expenses:
<br />Personnel
<br />601-494-9400-41010 Full-time Salaries 290,353 311,541 367,310 150,000 41%
<br />601-494-9400-41020 Overtime 7,979 14,508 9,040 4,745 52%
<br />601-494-9400-41210 PERA Contributions 64,026 24,063 27,548 11,218 41%
<br />601-494-9400-41216 MSRS Contributions - City Admin 634 690 701 364 52%
<br />601-494-9400-41220 FICA Contributions 17,069 19,266 23,334 10,167 44%
<br />601-494-9400-41230 Medicare Contributions 4,003 4,529 5,457 2,377 44%
<br />601-494-9400-41300 Insurance 57,068 63,158 74,341 27,355 37%
<br />601-494-9400-41325 Life Insurance 243 240 299 101 34%
<br />601-494-9400-41330 STD/LTD 1,514 1,671 2,008 659 33%
<br />601-494-9400-41301 Unemployment Insurance - - - - #DIV/0!
<br />601-494-9400-41600 Safety Clothing Allowance 675 432 665 225 34%
<br />601-494-9400-41510 Workers Compensation 5,718 9,833 6,692 10,768 161%
<br />Total Personnel 453,261$ 449,930$ 517,395$ 217,979$ 42.1%
<br />Materials and Supplies
<br />601-494-9400-42000 Office Supplies 954 225 800 525 66%
<br />601-494-9400-42120 Fuel, Oil and Fluids 10,272 8,985 10,500 2,541 24%
<br />601-494-9400-42030 Printed Forms 1,504 335 850 735 86%
<br />601-494-9400-42150 Operating Supplies 763 1,762 2,500 298 12%
<br />601-494-9400-42160 Chemicals 14,307 16,903 12,000 3,446 29%
<br />601-494-9400-42210 Repair/Maint. Supplies 11,170 10,135 10,000 4,941 49%
<br />601-494-9400-42300 Water Meters & Supplies 160,718 317,221 200,000 73,029 37%
<br />601-494-9400-44375 Personal Protective Equipment 297 591 650 268 41%
<br />601-494-9400-42400 Small Tools & Minor Equipment 3,779 11,312 4,500 4,667 104%
<br />Total Materials and Supplies 203,766$ 367,469$ 241,800$ 90,450$ 37.4%
<br />22
|