Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5.02h ERMUSR 11-14-2023
ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 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 GAIN ON DISPOSITION OF PROPER MISCELLANEOUS REVENUE HYDRANT MAINTENANCE PROGR CONTRIBUTIONS FROM DEVELOP WATER TOWER LEASE Total For Misc Revenue: Total Other Revenue Total For Total Other Revenue: 2022 YTD 2022 v. 2023 YTD VARIANCE Actual Var% 269,218 1,510,556 1,120,888 1,397,043 35 225,529 1,332,225 178,331 13 163,352 801,048 648,694 850,022 23 134,126 706,759 94,289 13 86,094 344,231 204,993 256,349 68 67,828 240,476 103,755 43 518,665 2,655,836 1,974,576 2,503,414 35 427,484 2,279,460 376,375 17 518,665 2,655,836 1,974,576 2,503,414 35 427,484 2,279,460 376,375 17 518,665 2,655,836 1,974,576 2,503,414 35 427,484 2,279,460 376,375 17 2,891 30,443 26,250 35,000 16 (13,497) (38,541) 68,985 179 0 543 1,125 1,500 (52) 0 592 (49) (8) 2,891 30,987 27,375 36,500 13 (13,497) (37,948) 68,936 182 3,250 17,530 20,999 28,000 (17) 3,854 19,375 (1,844) (10) 3,250 17,530 20,999 28,000 (17) 3,854 19,375 (1,844) (10) 29,190 141,905 337,500 450,000 (58) 39,328 1,251,931 (1,110,025) (89) 2,750 11,494 29,999 40,000 (62) 3,478 50,572 (39,078) (77) 619 14,805 20,999 28,000 (30) 3,236 9,062 5,742 63 32,559 168,205 388,499 518,000 (57) 46,043 1,311,565 (1,143,360) (87) 20 40 37 50 5 85 110 (70) (64) 2,940 2,940 0 0 0 0 0 2,940 0 0 258 375 500 (31) 0 287 (28) (10) 975 11,212 10,125 13,500 11 2,105 10,279 932 9 0 0 0 65,000 0 0 0 0 0 0 0 0 296,984 0 24,197 213,408 (213,408) (100) 3,935 14,451 10,537 376,034 37 26,387 224,085 (209,634) (94) 42,636 231,174 447,412 958,534 (48) 62,789 1,517,078 (1,285,903) (85) 42,636 231,174 447,412 958,534 (48) 62,789 1,517,078 (1,285,903) (85) 73 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% Total Revenue 561,301 2,887,011 2,421,988 3,461,948 19 490,273 3,796,538 (909,527) (24) Expenses Production Expense MTCE OF STRUCTURES 7,341 78,130 67,500 90,000 16 9,287 69,220 8,910 13 Total For Production Expense: 7,341 78,130 67,500 90,000 16 9,287 69,220 8,910 13 Pumping Expense SUPERVISION 5,319 46,606 51,750 69,000 (10) 6,450 47,810 (1,203) (3) ELECTRIC & GAS UTILITIES 23,564 247,879 216,000 288,000 15 25,927 218,450 29,429 13 SAMPLING 878 11,362 11,250 15,000 1 1,084 10,411 951 9 CHEMICAL FEED 6,970 40,277 37,500 50,000 7 1,788 25,338 14,939 59 MTCE OF ELECTRIC PUMPING EQ 0 0 0 0 0 0 46 (46) (100) MTCE OF WELLS 14,067 116,552 123,750 165,000 (6) 12,857 123,944 (7,391) (6) SCADA - PUMPING 347 2,553 11,999 16,000 (79) 369 9,036 (6,482) (72) Total For Pumping Expense: 51,146 465,232 452,250 603,000 3 48,478 435,036 30,196 7 Distribution Expense MTCE OF WATER MAINS 7,608 126,523 90,000 120,000 41 8,036 65,595 60,927 93 LOCATE WATER LINES 1,109 6,790 12,937 17,250 (48) 1,652 9,163 (2,373) (26) MTCE OF WATER SERVICES 0 240 0 0 0 321 897 (656) (73) WATER METER SERVICE 4,489 24,401 49,500 66,000 (51) 3,713 58,954 (34,552) (59) BACKFLOW DEVICE INSPECTION 1,638 15,368 13,300 16,000 16 505 10,717 4,650 43 MTCE OF CUSTOMERS SERVICE 2,495 22,570 22,875 30,500 (1) 2,290 21,267 1,302 6 WATER MAPPING 1,329 11,139 9,375 12,500 19 1,741 8,923 2,215 25 MTCE OF WATER HYDRANTS - PU 47 11,239 14,249 19,000 (21) 1,922 14,691 (3,452) (23) MTCE OF WATER HYDRANTS - PR 269 3,607 3,750 5,000 (4) 1,107 3,820 (212) (6) WATER CLOTHING/PPE 117 8,855 6,750 9,000 31 3 7,297 1,557 21 WAGES WATER 574 5,274 5,474 7,300 (4) 1,095 6,171 (897) (15) TRANSPORTATION EXPENSE 1,199 11,523 12,375 16,500 (7) 1,483 12,766 (1,242) (10) WATER PERMIT 0 15,752 18,600 18,600 (15) 0 18,370 (2,617) (14) Total For Distribution Expense: 20,877 263,286 259,187 337,650 2 23,874 238,638 24,648 10 Depreciation & Amortization DEPRECIATION 97,591 878,646 880,743 1,202,937 0 91,639 829,165 49,481 6 Total For Depreciation & Amortization: 97,591 878,646 880,743 1,202,937 0 91,639 829,165 49,481 6 Interest Expense INTEREST EXPENSE - BONDS 3,466 32,599 32,600 43,000 0 3,666 35,371 (2,771) (8) AMORTIZATION OF DEBT DISCOU (554) (4,988) (4,988) (6,651) 0 (554) (4,988) 0 0 74 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% Total For Interest Expense: 2,912 27,611 27,611 36,349 0 3,112 30,383 (2,771) (9) Other Operating Expense LOSS ON DISPOSITION OF PROP (C 0 0 0 500 0 0 0 0 0 DAM MAINTENANCE EXPENSE 0 1,707 1,312 1,750 30 53 1,185 521 44 OTHER INTEREST EXPENSE 0 94 95 95 0 94 938 (844) (90) INTEREST EXPENSE - METER DEP 104 943 93 125 903 4 39 903 2,258 Total For Other Operating Expense: 104 2,745 1,501 2,470 83 152 2,163 581 27 Customer Accounts Expense METER READING EXPENSE 216 1,619 1,874 2,500 (14) 240 1,814 (194) (11) MISC CUSTOMER ACCOUNTS EXP 7,449 64,481 61,215 81,620 5 7,949 58,207 6,274 11 BAD DEBT EXPENSE & RECOVER 0 (28) 187 250 (115) 28 28 (56) (200) Total For Customer Accounts Expense: 7,665 66,073 63,277 84,370 4 8,218 60,049 6,023 10 Administrative Expense SALARIES OFFICE & COMMISSION 18,011 173,091 201,375 268,500 (14) 20,289 174,337 (1,245) (1) TEMPORARY STAFFING 0 0 749 1,000 (100) 0 0 0 0 OFFICE SUPPLIES 1,298 19,805 19,125 25,500 4 1,098 10,733 9,071 85 ELECTRIC & WATER CONSUMPTI 618 5,667 6,000 8,000 (6) 615 4,956 711 14 BANK FEES 28 349 468 625 (26) 31 376 (26) (7) LEGAL FEES 119 3,461 6,750 9,000 (49) 406 5,241 (1,780) (34) AUDITING FEES 405 4,438 3,472 4,630 28 375 3,382 1,056 31 INSURANCE 3,303 41,057 27,000 36,000 52 2,918 24,827 16,229 65 UTILITY SHARE - DEFERRED COM 1,793 17,440 22,875 30,500 (24) 853 17,174 265 2 UTILITY SHARE- MEDICAUDENT 13,579 160,131 172,454 215,000 (7) 16,454 173,106 (12,974) (7) UTILITY SHARE - PERA 4,189 39,931 40,500 54,000 (1) 4,686 40,000 (69) 0 UTILITY SHARE- FICA 3,972 38,636 38,999 52,000 (1) 4,489 38,447 188 0 EMPLOYEE SICK PAY 2,349 20,677 20,250 27,000 2 2,925 19,123 1,554 8 EMPLOYEE HOLIDAY PAY 2,700 17,362 16,800 30,800 3 2,550 11,954 5,407 45 EMPLOYEE VACATION & PTO PA 4,936 38,121 34,181 44,000 12 5,229 35,490 2,630 7 UPMIC DISTRIBUTION 4,683 10,967 13,551 18,069 (19) 5,359 9,904 1,063 11 WELLHEAD PROTECTION 0 6,861 10,000 10,000 (31) 0 4,724 2,137 45 LONGEVITY PAY 0 2,581 3,001 3,106 (14) 0 310 2,271 733 CONSULTING FEES 112 8,026 26,250 35,000 (69) 1,012 19,410 (11,384) (59) TELEPHONE 673 6,321 7,125 9,500 (11) 638 6,303 17 0 ADVERTISING 462 3,403 4,875 6,500 (30) 192 2,579 824 32 DUES & SUBSCRIPTIONS - FEES 1,236 53,793 59,000 78,320 (9) 1,695 57,951 (4,158) (7) 75 ELK RIVER MUNICIPAL UTILITIES ELK RIVER, MINNESOTA STATEMENTS OF REVENUES, EXPENSES AND CHANGES IN NET POSITION FOR PERIOD ENDING SEPTEMBER 2023 2023 2023 2023 2023 YTD ANNUAL 2023 YTD 2022 2022 YTD 2022 v. 2023 Water SEPTEMBER YTD BUDGET BUDGET Bud Var% SEPTEMBER YTD VARIANCE Actual Var% SCHOOLS & MEETINGS 6,015 25,394 47,778 63,705 (47) 4,893 30,847 (5,453) (18) MTCE OF GENERAL PLANT & OFFI 250 2,256 1,424 1,900 58 152 1,371 884 65 Total For Administrative Expense: 70,742 699,778 784,009 1,032,655 (11) 76,867 692,554 7,223 1 General Expense CIP REBATES - RESIDENTIAL 74 1,185 7,875 10,500 (85) 45 834 351 42 CIP REBATES - COMMERCIAL 0 0 375 500 (100) 0 0 0 0 CIP - MARKETING 0 966 375 500 158 0 613 353 58 CIP - LABOR 0 1,288 3,525 4,700 (63) 415 3,352 (2,063) (62) ENVIRONMENTAL COMPLIANCE 52 1,203 1,649 2,200 (27) 53 1,428 (224) (16) MISC GENERAL EXPENSE 0 (24) 187 250 (113) 1,980 0 (24) 0 Total For General Expense: 125 4,619 13,987 18,650 (67) 2,493 6,228 (1,608) (26) Total Expenses(before Operating Transfers) 258,508 2,486,125 2,550,067 3,408,081 (3) 264,123 2,363,440 122,684 5 Operating Transfer Utilities & Labor Donated WATER & LABOR DONATED TO Cl 0 0 1,125 1,500 (100) 0 0 0 0 Total Operating Transfer Total For Total Operating Transfer: 0 0 1,125 1,500 (100) 0 0 0 0 Net Income Profit(Loss) 302,793 400,885 (129,203) 52,367 410 (1,032,212) (72) 226,149 1,433,098