Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.1h ERMUSR 11-8-2022
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 Water SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER Revenue Operating Revenue Water Sales WATER SALES RESIDENTIAL WATER SALES COMMERCIAL WATER SALES IRRIGATION Total For Water Sales: Total Operating Revenue Total For Total Operating Revenue: Other Operating Revenue Interest/Dividend Income INTEREST & DIVIDEND INCOME OTHER INTEREST/MISC REVENUE Total For Interest/Dividend Income: Customer Penalties CUSTOMER PENALTIES Total For Customer Penalties: Connection Fees WATER/ACCESS/CONNECTION FE CUSTOMER CONNECTION FEES BULK WATER SALES/HYDRANT R Total For Connection Fees: Misc Revenue MISC NON -UTILITY MISCELLANEOUS REVENUE HYDRANT MAINTENANCE PROGR CONTRIBUTIONS FROM DEVELOP WATER TOWER LEASE Total For Misc Revenue: Total Other Revenue Total For Total Other Revenue: 2021 YTD 2021 v. 2022 YTD VARIANCE Actual Var% 225,529 1,332,225 1,082,148 1,359,866 23 223,773 1,457,354 (125,129) (9) 134,126 706,759 652,776 842,024 8 134,824 719,921 (13,161) (2) 67,828 240,476 207,317 243,025 16 67,656 317,960 (77,484) (24) 427,484 2,279,460 1,942,242 2,444,916 17 426,254 2,495,236 (215,775) (9) 427,484 2,279,460 1,942,242 2,444,916 17 426,254 2,495,236 (215,775) (9) 427,484 2,279,460 1,942,242 2,444,916 17 426,254 2,495,236 (215,775) (9) (13,497) (38,541) 26,250 35,000 (247) 4,090 21,828 (60,370) (277) 0 592 749 1,000 (21) 0 681 (88) (13) (13,497) (37,948) 27,000 36,000 (241) 4,090 22,509 (60,458) (269) 3,854 19,375 13,088 18,000 48 0 0 19,375 0 3,854 19,375 13,088 18,000 48 0 0 19,375 0 39,328 1,251,931 322,499 430,000 288 21,056 421,684 830,246 197 3,478 50,572 26,250 35,000 93 3,202 31,788 18,784 59 3,236 9,062 11,250 15,000 (19) 5,118 8,799 262 3 46,043 1,311,565 360,000 480,000 264 29,377 462,272 849,293 184 85 110 0 0 0 31 31 79 255 0 287 0 0 0 43 882 (594) (67) 2,105 10,279 9,749 13,000 5 975 8,805 1,474 17 0 0 48,750 65,000 (100) 0 0 0 0 24,197 213,408 213,405 286,153 0 23,314 205,633 7,775 4 26,387 224,085 271,905 364,153 (18) 24,364 215,351 8,734 4 62,789 1,517,078 671,993 898,153 126 57,831 700,133 816,944 117 62,789 1,517,078 671,993 898,153 126 57,831 700,133 816,944 117 Total Revenue 490,273 3,796,538 2,614,236 3,343,069 45 484,086 3,195,370 601,168 19 64 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% Expenses Production Expense MTCE OF STRUCTURES 9,287 69,220 56,250 75,000 23 9,455 155,765 (86,544) (56) Total For Production Expense: 9,287 69,220 56,250 75,000 23 9,455 155,765 (86,544) (56) Pumping Expense SUPERVISION 6,450 47,810 49,500 66,000 (3) 5,126 42,707 5,102 12 ELECTRIC & GAS UTILITIES 25,927 218,450 202,500 270,000 8 19,441 208,920 9,529 5 SAMPLING 1,084 10,411 11,250 15,000 (7) 1,679 9,736 675 7 CHEMICAL FEED 1,788 25,338 27,000 36,000 (6) 4,608 31,336 (5,998) (19) MTCE OF ELECTRIC PUMPING EQ 0 46 0 0 0 124 161 (115) (71) MTCE OF WELLS 12,857 123,944 119,999 160,000 3 8,330 95,636 28,308 30 SCADA - PUMPING 369 9,036 11,999 16,000 (25) 901 4,336 4,699 108 Total For Pumping Expense: 48,478 435,036 422,249 563,000 3 40,211 392,834 42,201 11 Distribution Expense MTCE OF WATER MAINS 8,036 65,595 90,000 120,000 (27) 7,002 84,623 (19,028) (22) LOCATE WATER LINES 1,652 9,163 12,750 17,000 (28) 1,599 12,298 (3,134) (25) MTCE OF WATER SERVICES 321 897 0 0 0 0 0 897 0 WATER METER SERVICE 3,713 58,954 41,249 55,000 43 4,498 43,673 15,281 35 BACKFLOW DEVICE INSPECTION 505 10,717 11,700 15,000 (8) 1,512 6,300 4,416 70 MTCE OF CUSTOMERS SERVICE 2,290 21,267 22,875 30,500 (7) 2,569 21,213 54 0 WATER MAPPING 1,741 8,923 9,375 12,500 (5) 129 7,228 1,695 23 MTCE OF WATER HYDRANTS - PU 1,922 14,691 13,500 18,000 9 2,130 10,484 4,207 40 MTCE OF WATER HYDRANTS - PR 1,107 3,820 3,750 5,000 2 461 1,580 2,239 142 WATER CLOTHING/PPE 3 7,297 5,249 7,000 39 16 9,946 (2,648) (27) WAGES WATER 1,095 6,171 7,125 9,500 (13) 578 4,763 1,408 30 TRANSPORTATION EXPENSE 1,483 12,766 11,250 15,000 13 1,078 7,617 5,149 68 WATER PERMIT 0 18,370 18,600 18,600 (1) 0 14,875 3,494 23 Total For Distribution Expense: 23,874 238,638 247,425 323,100 (4) 21,575 224,604 14,034 6 Depreciation & Amortization DEPRECIATION 91,639 829,165 853,920 1,199,123 (3) 95,137 861,157 (31,991) (4) Total For Depreciation & Amortization: 91,639 829,165 853,920 1,199,123 (3) 95,137 861,157 (31,991) (4) Interest Expense INTEREST EXPENSE - BONDS 3,666 35,371 35,371 46,371 0 5,037 21,183 14,188 67 INTEREST EXPENSE - DEFEASED 0 0 0 0 0 0 (69) 69 100 AMORTIZATION OF DEBT DISCOU (554) (4,988) (4,988) (6,651) 0 (554) (1,662) (3,325) (200) 65 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% Total For Interest Expense: 3,112 30,383 30,382 39,720 0 4,483 19,451 10,931 56 Other Operating Expense DAM MAINTENANCE EXPENSE 53 1,185 1,312 1,750 (10) 0 (667) 1,852 278 OPEB EXPENSE 0 0 0 0 0 0 (44,525) 44,525 100 OTHER INTEREST EXPENSE 94 938 0 0 0 182 (792) 1,730 219 INTEREST EXPENSE - METER DEP 4 39 74 100 (47) 2 20 19 100 Total For Other Operating Expense: 152 2,163 1,387 1,850 56 184 (45,965) 48,128 105 Customer Accounts Expense METER READING EXPENSE 240 1,814 1,874 2,500 (3) 176 1,747 67 4 MISC CUSTOMER ACCOUNTS EXP 7,949 58,207 53,399 71,200 9 6,225 51,968 6,238 12 BAD DEBT EXPENSE & RECOVER 28 28 375 500 (93) 0 0 28 0 Total For Customer Accounts Expense: 8,218 60,049 55,649 74,200 8 6,402 53,715 6,334 12 Administrative Expense SALARIES OFFICE & COMMISSION 20,289 174,337 176,249 235,000 (1) 20,182 174,718 (381) 0 SALARIES COVID-19 0 0 0 0 0 0 1,791 (1,791) (100) TEMPORARY STAFFING 0 0 749 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,098 10,733 17,775 23,700 (40) 1,431 18,131 (7,398) (41) ELECTRIC & WATER CONSUMPTI 615 4,956 6,000 8,000 (17) 501 4,774 181 4 BANK FEES 31 376 524 700 (28) 39 438 (62) (14) LEGAL FEES 406 5,241 6,000 8,000 (13) 350 3,799 1,442 38 AUDITING FEES 375 3,382 3,382 4,510 0 353 3,179 202 6 INSURANCE 2,918 24,827 20,250 27,000 23 2,097 19,072 5,754 30 UTILITY SHARE - DEFERRED COM 853 17,174 20,999 28,000 (18) 1,201 13,909 3,265 23 UTILITY SHARE - MEDICAL/DENT 16,454 173,106 169,045 217,000 2 13,874 147,834 25,271 17 UTILITY SHARE - PERA 4,686 40,000 38,250 51,000 5 4,301 36,664 3,336 9 UTILITY SHARE - FICA 4,489 38,447 36,749 49,000 5 4,122 35,289 3,158 9 EMPLOYEE SICK PAY 2,925 19,123 22,500 30,000 (15) 2,208 17,575 1,548 9 EMPLOYEE HOLIDAY PAY 2,550 11,954 15,272 28,000 (22) 2,456 14,309 (2,354) (16) EMPLOYEE VACATION & PTO PA 5,229 35,490 32,000 41,000 11 3,109 30,969 4,521 15 UPMIC DISTRIBUTION 5,359 9,904 8,250 11,000 20 3,145 8,010 1,893 24 WELLHEAD PROTECTION 0 4,724 20,000 20,000 (76) 1,888 1,888 2,835 150 LONGEVITY PAY 0 310 0 0 0 0 0 310 0 CONSULTING FEES 1,012 19,410 15,000 20,000 29 0 19,299 110 1 TELEPHONE 638 6,303 5,100 6,800 24 698 5,297 1,006 19 ADVERTISING 192 2,579 3,750 5,000 (31) 340 2,839 (260) (9) 66 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2022 2022 2022 2022 2022 YTD ANNUAL 2022 YTD 2021 2021 YTD 2021 v. 2022 Water SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% DUES & SUBSCRIPTIONS - FEES 1,695 57,951 55,000 73,615 5 1,388 89,215 (31,263) (35) SCHOOLS & MEETINGS 4,893 30,847 41,269 55,025 (25) 2,627 19,119 11,727 61 MTCE OF GENERAL PLANT & OFFI 152 1,371 1,424 1,900 (4) 149 1,342 29 2 Total For Administrative Expense: 76,867 692,554 715,544 945,251 (3) 66,468 669,470 23,084 3 General Expense CIP REBATES - RESIDENTIAL 45 834 3,375 4,500 (75) 588 4,839 (4,005) (83) CIP REBATES - COMMERCIAL 0 0 375 500 (100) 0 0 0 0 CIP - MARKETING 0 613 375 500 63 0 121 491 402 CIP - LABOR 415 3,352 3,525 4,700 (5) 326 3,342 10 0 ENVIRONMENTAL COMPLIANCE 53 1,428 1,649 2,200 (13) 49 809 619 77 MISC GENERAL EXPENSE 1,980 0 187 250 (100) (1,888) 809 (809) (100) Total For General Expense: 2,493 6,228 9,487 12,650 (34) (923) 9,922 (3,694) (37) Total Expenses(before Operating Transfers) 264,123 2,363,440 2,392,297 3,233,895 (1) 242,995 2,340,955 22,485 1 Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl 0 0 1,125 1,500 (100) 316 1,258 (1,258) (100) Total Operating Transfer Total For Total Operating Transfer: 0 0 1,125 1,500 (100) 316 1,258 (1,258) (100) Net Income Profit(Loss) 226,149 1,433,098 220,813 107,673 549 579,942 68 240,773 853,155