City of Lake Elmo
<br />2025 Draft Budgets - August 27 Budget Workshop
<br />2021 2022 2023 2024 2024 2024 2025 Change from Budget
<br />Account Number Description Actual Actual Actual Adopted Q2 YTD Projected Requested Prior Year Notes
<br />(excludes any amendments)
<br />601-494-9400-46350 Bond Issuance Costs - - 94,125 - 94,125 - -100.00%
<br />Total Misc. and Non-operating 220,766$ 1,097,942$ 389,002$ 1,588,387$ 1,055,518$ 1,589,277$ 1,472,183$ -7.32%
<br />Prior Period Adjustments - - - -
<br />Total Water Fund Expenses:1,155,793$ 2,155,099$ 6,736,603$ 7,451,932$ 2,033,130$ 7,303,392$ 4,293,550$ -42.38%
<br />Net Water Fund Revs. Over/(Under) Expenses:2,703,003$ 619,901$ (3,769,596)$ (2,968,238)$ (509,212)$ (2,819,698)$ (979,829)$
<br />602 Sewer Fund
<br />Sewer Fund Revenues:
<br />602-000-0000-36100 Special Assessments 1,545,648 1,458,154 (29,951) - - - 255,838 #DIV/0!
<br />602-000-0000-36101 Delinquent Special Assessments 2,628 7,236 - - - - #DIV/0!
<br />602-000-0000-36102 Special Assessments Penalties & Interest 594 684 3,034 - - - - #DIV/0!
<br />602-000-0000-36103 Prepaid Special Assessments 171,577 - 153,033 - - - - #DIV/0!
<br />602-000-0000-36210 Interest on Investments (7,335) (138,866) 387,540 2,500 - 2,500 0.00%
<br />602-000-0000-37200 Sewer Sales 539,130 671,283 755,813 843,721 217,989 843,721 843,721 0.00%
<br />602-000-0000-37220 SAC Early Pay discount/revenue 8,996 8,599 8,126 - 5,059 - - #DIV/0!
<br />602-000-0000-37230 Sewer Lat Benefit Fee 25,000 13,100 13,700 - - - - #DIV/0!revenues to be estimated during Utility Study update.
<br />602-000-0000-37240 Sewer Availability Charges (SAC)1,491,000 477,500 385,500 1,678,500 1,000,900 1,000,900 1,678,500 0.00%
<br />602-000-0000-37260 Sewer Connection Fees Municipa 482,000 310,500 249,500 611,000 207,000 207,000 611,000 0.00%
<br />Total Sewer Fund Revenues:4,258,051$ 1,342,307$ 1,805,146$ 3,135,721$ 1,430,948$ 2,051,621$ 3,135,721$ 0.00%
<br />Sewer Fund Expenses:
<br />Personnel
<br />602-495-9450-41010 Full-time Salaries 104,267 131,072 147,885 161,099 78,451 161,099 195,299 21.23%
<br />602-495-9450-41020 Overtime 7,265 8,581 10,418 8,402 4,054 8,402 8,453 0.60%
<br />602-495-9450-41210 PERA Contributions (10,523) 30,413 11,720 12,082 6,069 12,082 14,647 21.23%
<br />602-495-9450-41216 MSRS Contributions -City Admin 279 317 344 351 182 351 321 -8.49%
<br />602-495-9450-41220 FICA Contributions 6,619 8,013 9,423 10,509 5,393 12,633 20.21%
<br />602-495-9450-41230 Medicare Contributions 1,550 1,881 2,214 2,458 1,261 3,056 24.35%
<br />602-495-9450-41300 Insurance 21,870 27,098 30,814 33,348 15,153 33,348 37,876 13.58%
<br />602-495-9450-41325 Life Insurance 83 115 110 115 56 115 166 44.03%
<br />602-495-9450-41330 STD/LTD 496 738 776 876 365 876 1,023 16.73%
<br />602-495-9450-41600 Safety Clothing Allowance - 225 140 - 140 640 357.14%
<br />602-495-9450-41301 Unemployment Insurance - - - - - - #DIV/0!
<br />602-495-9450-41510 Workers Compensation 2,716 1,978 4,104.36 2,585.69 4,650.73 2,586 2,586 0.00%
<br />Total Personnel 134,622$ 211,487$ 218,033$ 231,965$ 115,635$ 218,998$ 276,698$ 19.28%
<br />Materials and Supplies
<br />602-495-9450-42210 Repair/Maint. Supplies 2,689 10,435 4,262 12,000 5,493 10,000 11,500 -4.17%
<br />602-495-9450-42000 Office Supplies 438 490 580 400 204 450 450 12.50%
<br />602-495-9450-42030 Printed Forms 594 600 335 600 735 900 1,400 133.33%
<br />602-495-9450-42120 Fuel, Oil and Fluids 8,871 11,742 9,687 10,750 2,364 9,500 10,000 -6.98%
<br />602-495-9450-42150 Operating Suppies 663 412 467 750 16 500 650 -13.33%
<br />602-495-9450-42270 Repair/Maint. Supplies 77 396 - - - - - #DIV/0!
<br />602-495-9450-44375 Personal Protective Equipment 193 538 74 400 183 400 400 0.00%
<br />602-495-9450-42400 Small Tools & Minor Equipment 2,117 1,821 7,091.75 5,000.00 3,968.98 4,500 7,500 50.00%2 jetting nozzles
<br />Total Materials and Supplies 15,642$ 26,434$ 22,496$ 29,900$ 12,965$ 26,250$ 31,900$ 6.69%
<br />15
|