Loading...
5.2c ERMUSR 11-8-2022ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA 2023 WATER BUDGET 2023 Annual 2022 Annual 2021 Annual Water Budget Budget Actual Revenue Operating Revenue Water Sales 610.6101 Water Sales Residential 1,397,043 1,359,866 1,764,627 610.6102 Water Sales Commercial 850,022 842,025 925,451 610.6103 Water Sales Irrigation 256,349 243,025 359,060 Total for Water Sales: 2,503,413 2,444,916 3,049,140 Total Operating Revenue 2,503,413 2,444,916 3,049,139 Total for Total Operating Revenue: 2,503,413 2,444,916 3,049,140 Other Operating Revenue Interest/Dividend Income 460.4691 Interest & Dividend Income 35,000 35,000 24,676 460.4692 Otherinterest/Misc Revenue 1,000 1,000 1,310 Total for Interest/Dividend Income: 36,000 36,000 25,988 Customer Penalties 620.6301 Customer Penalties 25,000 18,000 - Total for Customer Penalties: 25,000 18,000 - Connection Fees 620.6401 Water/Access/Connections Fees 450,000 430,000 548,947 620.6402 Customer Connection Fees 35,000 35,000 42,709 620.6407 Bulk Water Sales/Hydrant Rental 25,500 15,000 28,810 Total for Connection Fees: 510,500 480,000 620,467 Misc Revenue 470.4722 Misc Non -Utility - - 31 470.4739 Pera Pension Revenue - - 910 620.626 Transfer In From City - - 195,245 620.6403 Miscellaneous Revenue - - 1,141 620.6323 Gain On Disposition Of Property - - - 620.6404 Hydrant Maintenance Program 13,200 13,000 13,209 620.6405 Contributions from Developers 65,000 65,000 552,919 620.6406 Water Tower Lease 296,984 286,153 275,727 Total for Misc Revenue: 375,184 364,153 1,042,472 Total Other Revenue 946,684 898,153 1,688,927 Total for Total Other Revenue: 946,684 898,153 1,688,927 Total Revenue 3,450,097 3,343,069 4,738,067 Expenses Production Expense 700.7021 MTCE OF STRUCTURES 85,000 75,000 173,376 Total for Production Expense: 85,000 75,000 173,376 Pumping Expense 710.7101 SUPERVISION 60,000 66,000 57,004 710.7181 ELECTRIC & GAS UTILITIES 288,000 270,000 263,078 710.7182 SAMPLING 15,000 15,000 14,339 710.7183 CHEMICAL FEED 50,000 36,000 36,273 710.722 MTCE OF WELLS 160,000 160,000 125,418 710.723 SCADA- PUMPING 16,000 16,000 5,140 Total for Pumping Expense: 589,000 563,000 501,438 Distribution Expense 730.7301 MTCE OF WATER MAINS 120,000 120,000 226,593 730.7309 LOCATE WATER LINES 17,250 17,000 16,132 730.7312 WATER METER SERVICE 66,000 55,000 60,844 730.7316 BACKFLOW DEVICE INSPECTION 16,000 15,000 9,055 labor and software expense 730.7321 MTCE OF CUSTOMERS SERVICE 30,500 30,500 28,116 730.7325 WATER MAPPING 12,500 12,500 8,732 730.7331 MTCE OF WATER HYDRANTS - PUBLIC 19,000 18,000 13,517 730.7332 MTCE OF WATER HYDRANTS - PRIVATE 5,000 5,000 5,093 730.7341 WATER CLOTHING/PPE 9,000 7,000 13,542 730.7391 WAGES WATER 7,300 9,500 6,138 730.7395 TRANSPORTATION EXPENSE 16,500 15,000 10,198 730.7399 WATER PERMIT 18,600 18,600 14,875 Total for Distribution Expense: 337,650 323,100 412,901 Depreciation & Amortization 595.8031 DEPRECIATION 1,202,937 1,199,124 1,139,801 Total for Depreciation & Amortization: 1,202,937 1,199,124 1,139,802 74 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA 2023 WATER BUDGET 2023 Annual 2022 Annual 2021 Annual Water Budget Budget Actual Interest Expense 596.8071 INTEREST EXPENSE -BONDS 43,000 46,371 36,296 596.8075INTEREST EXPENSE -DEFEASEDBONDS - - (69) 597.8281 AMORTIZATION OF DEBT DISCOUNT/PREMIUM (6,651) (6,651) (3,325) Total for Interest Expense: 36,349 39,720 32,902 Other Operating Expense 597.8213 LOSS ON DISPOSITION OF PROP (CAPITAL) 500 - 662 597.8264 DAM MAINTENANCE EXPENSE 1,750 1,750 (393) 597.8302 PENSION EXPENSE - - 18,645 597.8303 OPEB EXPENSE - - (44,525) 597.8311 OTHER INTEREST EXPENSE 95 - (244) 597.8341 INTEREST EXPENSE - METER DEPOSITS 125 100 26 597.84 RENTAL PROPERTY EXPENSE - - - Total for Other Operatin Expense: 2,470 1,850 (25,830) Customer Accounts Expense 900.9021 METER READING EXPENSE 2,500 2,500 2,326 900.9051 MISC CUSTOMER ACCOUNTS EXPENSE UTILITY 81,620 71,200 69,886 Customer satisfaction survey 900.9061 BAD DEBT EXPENSE & RECOVERY 250 500 - Total for Customer Accounts Expense: 84,370 74,200 72,213 Administrative Expense 920.9201 SALARIES OFFICE & COMMISSION 268,500 235,000 224,435 Admin Director 920.9202 SALARIESCOVID-19 - - 1,791 920.9205 TEMPORARY STAFFING 1,000 1,000 - 920.9211 OFFICE SUPPLIES 26,000 23,700 23,716 920.9212 ELECTRIC & WATER CONSUMPTION - OFFICE 8,000 8,000 6,160 920.9213 BANK FEES 625 700 607 920.9221 LEGAL FEES 9,000 8,000 5,080 920.9231 AUDITING FEES 4,630 4,510 4,240 920.9241 INSURANCE 36,000 27,000 22,128 920.926 UTILITY SHARE -DEFERRED COMP 30,500 28,000 17,722 920.9261 UTILITY SHARE - MEDICAL/DENTAL/DISABIL 225,003 217,000 189,669 920.9262 UTILITY SHARE - PERA 55,000 51,000 49,360 920.9263 UTILITY SHARE - FICA 53,000 49,000 47,321 920.9264 EMPLOYEE SICK PAY 27,000 30,000 26,235 920.9265 EMPLOYEE HOLIDAY PAY 30,800 28,000 28,139 920.9266 EMPLOYEE VACATION & PTO PAY 44,000 41,000 41,535 920.9267 UPMIC DISTRIBUTION 18,069 11,000 11,275 920.929 LONGEVITY PAY 3,416 - - 920.9268 WELLHEAD PROTECTION 10,000 20,000 3,790 Wellhead protection plan amendment 920.9291 CONSULTING FEES 29,000 20,000 43,887 920.9301 TELEPHONE 9,500 6,800 7,365 920.9302 ADVERTISING 7,000 5,000 3,791 920.9303 DUES & SUBSCRIPTIONS - FEES 78,740 73,616 106,965 920.9305 SCHOOLS & MEETINGS 63,705 55,026 24,356 920.9321 MTCE OF GENERAL PLANT & OFFICE HEATING 1,900 1,900 1,828 Total for Administrative Expense: 1,040,387 945,252 891,406 General Expense 920.9269CIPREBATES -RESIDENTIAL 10,500 4,500 5,279 920.927CIPREBATES -COMMERCIAL 500 500 - 920.9272 CIP- MARKETING 500 500 121 920.9273 CIP - LABOR 4,700 4,700 4,430 920.9281 ENVIRONMENTAL COMPLIANCE 2,200 2,200 952 920.9306 MISC GENERAL EXPENSE 250 250 805 Total for General Expense: 18,650 12,650 11,590 Total Expenses (before Operating Transfers) 3,396,813 3,233,895 3,209,798 Operating Transfer Utilities & Labor Donated 597.8261 WATER & LABOR DONATED TO CITY 1,500 1,500 1,258 Total Operating Transfer - Total for Total Operating Transfer: 1,500 1,500 1,259 Net Income Profit(Loss) 51,784 107,674 1,527,010 Total Expense 3,398,313 3,235,395 Budget Change Year over Year 5.0% 75