WS - C - Water Sewer Rate Structure Increase Information - Water Plant Upgrade Project

Summary of detailed water operating revenue and expenditures - City of Tiffin Iowa Actual Projection no rate increase FY2023 FY 2024 FY 2025 FY 2026 FY 2027 Interest 55,853 122,050 70,000 50,000 50,000 Charges 1,011,814 1,048,617 1,142,518 1,199,644 1,259,626 Bulk 27,227 13,912 14,000 14,700 15,435 Water Meter 66,265 147,984 50,000 52,500 55,125 Penalty 6,161 7,940 10,000 10,500 11,025 Misc (457) (24) - - - Hook Up 14,150 7,650 5,000 5,250 5,513 Sales Tax 54,877 58,964 60,000 63,000 66,150 Reimburse 115 - - - Deposits 14,310 12,302 30,000 31,500 33,075 Total 1,250,315 1,419,394 1,381,518 1,427,094 1,495,949 Wages 173,344 202,190 254,000 283,390 303,227 Part Time 1,013 - 7,500 8,025 FICA 12,965 15,245 19,488 21,680 23,198 IPERS 16,347 20,305 24,050 26,752 28,625 GROUP 37,462 52,058 60,742 55,039 58,892 Insurance 9,763 7,055 7,548 26,272 28,111 uniform 803 832 890 935 1,000 dues 1,384 1,676 1,793 1,883 2,015 Training 1,787 694 743 780 834 Building Repair 3,709 3,539 3,786 3,976 4,254 Vehicle Repair 1,868 1,304 1,395 1,465 1,567 Operation Equip Repair 13,788 68,602 73,404 77,075 82,470 Utilities 148,057 167,398 179,116 188,071 201,236 Telephone 9,315 8,596 9,198 9,658 10,334 Other Repair 1,500 6,930 7,415 7,786 8,331 Auditing 5,479 13,813 14,779 15,518 16,605 Engineering 8,201 43,404 46,442 48,764 52,178 Prop Insur 36,413 58,768 62,882 66,026 70,648 Sales Tax 54,142 27,734 29,675 31,159 33,340 Technology 21,099 5,056 5,410 5,681 6,078 Other Prof 2,088 152,662 163,348 171,516 183,522 Chemicals 129,169 3,956 4,232 4,444 4,755 Minor Equip 5,927 5,458 5,840 6,132 6,562 Other Equip 9,167 3,184 3,406 3,577 3,827 Office Supplies 2,365 - - - - Operating Supplies 20,156 42,046 44,989 47,238 50,545 Postage 6,791 7,263 7,772 8,160 8,731 Safety Supplies 1,389 2,700 2,889 3,033 3,245 Water Testing 12,401 4,982 5,331 5,598 5,989 Fuel 7,150 1,501 1,606 1,686 1,804 Operating Equip 5,428 603 646 678 725 Other Supplies 51,245 - - - Total 810,699 930,564 1,042,817 1,131,471 1,210,674