|
601Water FundWater, Sewer & Stormwater are separate Utility (aka Enterprise or Proprietary) Funds. 202220232023YTDQ4Account Number DescriptionActualAdoptedQ4% of BudgetCommentsWater Fund Revenues:601-000-0000-36210 Interest on Investments(66,764) 32,000 601-000-0000-37100 Water Sales1,634,375 1,276,703 671,727 0% allocated at year end53% q3 and q4 billings need Journal Entry601-000-0000-37120 Bulk Water- 2,000 - 0%601-000-0000-37130 Water Lat Benefit Fee12,400 - 13,200 #DIV/0!601-000-0000-37140 Water Access Revenue685,000 1,707,000 499,000 29%601-000-0000-37150 Water Connections - Municipal383,000 458,000 276,000 60%601-000-0000-37170 Meter Sales113,708 100,000 123,176 123%Total Water Fund Revenues:2,775,000$ 3,575,703$ 1,583,103$ 44.3% Water Fund Expenses:Personnel601-494-9400-41010 Full-time Salaries290,353 362,767 311,768 86%No Fin. Director Q1601-494-9400-41020 Overtime7,979 8,805 14,508 165%601-494-9400-41210 PERA Contributions64,026 27,868 24,063 86%601-494-9400-41216 MSRS Contributions - City Admin634 657 690 105%601-494-9400-41220 FICA Contributions17,069 23,038 19,257 84%601-494-9400-41230 Medicare Contributions4,003 5,388 4,527 84%601-494-9400-41300 Insurance57,068 73,313 63,158 86%601-494-9400-41325 Life Insurance243 270 240 89%601-494-9400-41330 STD/LTD1,514 1,802 1,671 93%601-494-9400-41301 Unemployment Insurance- - #DIV/0!601-494-9400-41600 Safety Clothing Allowance675 665 432 65%601-494-9400-41510 Workers Compensation5,718 7,324 9,833 134%Total Personnel453,261$ 511,897$ 450,145$ 87.9%Materials and Supplies601-494-9400-42000 Office Supplies954 800 225 28%601-494-9400-42120 Fuel, Oil and Fluids10,272 9,500 8,735 92%601-494-9400-42030 Printed Forms1,504 850 335 39%601-494-9400-42150 Operating Supplies763 3,000 1,762 59%601-494-9400-42160 Chemicals14,307 12,000 16,903 141%601-494-9400-42210 Repair/Maint. Supplies11,170 10,000 10,135 101%601-494-9400-42300 Water Meters & Supplies160,718 200,000 203,341 102%601-494-9400-44375 Personal Protective Equipment297 800 591 74%601-494-9400-42400 Small Tools & Minor Equipment3,779 10,572 11,312 107%Total Materials and Supplies203,766$ 247,522$ 253,339$ 102.4%Charges and Services601-494-9400-43030 Engineering Services3,430 25,000 30,122 120%21
|