Laserfiche WebLink
Exhibit 3-C <br />2024 Customer <br />REVENUE REQUIREMENT Test Year Demand Facilities Classification Basis <br />Elk River Municipal Utilities <br />2024 Test Year Distribution Classification <br />METER READING EXPENSE - - - NA <br />COLLECTING EXP DISC/RECONNECT - - - NA <br />MISC CUSTOMER ACCTS EXP-COMP - - - NA <br />CUST BLGS NOT PD/SENT FOR COLL - - - NA <br />Total Customer Accounts -$ -$ -$ <br />General & Administrative <br />SALARIES/OFFICE & COMMISSION 682,932 448,412 234,520 total revenue requirement <br />TEMPORARY STAFFING - - - NA <br />OFFICE SUPPLIES & EXPENSE 73,869 48,502 25,367 total revenue requirement <br />LT & WATER CONSUMPTION/OFFICE 18,709 12,284 6,425 total revenue requirement <br />BANK CHARGES 2,195 1,442 754 total revenue requirement <br />LEGAL FEES 27,287 17,917 9,370 total revenue requirement <br />AUDITING FEES 14,569 9,566 5,003 total revenue requirement <br />INSURANCE 141,665 93,017 48,648 total revenue requirement <br />UTILITY SHARE DEF COMP 85,833 56,358 29,475 total revenue requirement <br />UTIL SH OF MEDICAL/DENTAL 639,847 420,122 219,724 total revenue requirement <br />UTILITY SHARE OF PERA 237,689 156,066 81,623 total revenue requirement <br />UTILITY SHARE OF FICA 231,633 152,090 79,543 total revenue requirement <br />EMPLOYEES SICK PAY 383,325 251,691 131,634 total revenue requirement <br />EMP HOLIDAY PAY 138,188 90,734 47,454 total revenue requirement <br />EMPLOYEE VACATION & PTO 256,088 168,147 87,941 total revenue requirement <br />UPMIC DISTRIBUTION 86,844 57,022 29,822 total revenue requirement <br />LONGEVITY PAY 5,373 3,528 1,845 total revenue requirement <br />CONSULTING FEES 31,104 20,423 10,681 total revenue requirement <br />TELEPHONE 23,912 15,700 8,211 total revenue requirement <br />ADVERTISING 10,858 7,129 3,729 total revenue requirement <br />DUES & SUBSCRIPTIONS - FEES 95,415 62,649 32,766 total revenue requirement <br />TRAVEL EXPENSE - - - NA <br />SCHOOLS & MEETINGS 153,981 101,103 52,877 total revenue requirement <br />MTCE OF GENERAL PLANT & OFFICE 7,772 5,103 2,669 total revenue requirement <br />Total General & Administrative 3,349,089$ 2,199,007$ 1,150,082$ <br />General Expense <br />CIP REBATES - RESIDENTIAL - - - NA <br />CIP REBATES - COMMERCIAL - - - NA <br />CIP - ADMINISTRATION - - - NA <br />CIP - MARKETING - - - NA <br />CIP - LABOR - - - NA <br />CIP REBATES - LOW INCOME - - - NA <br />CIP - LOW INCOME LABOR - - - NA <br />ENVIRONMENTAL COMPLIANCE - - - NA <br />MISC GENERAL EXPENSE - - - NA <br />Total General Expense -$ -$ -$ <br />TOTAL OPERATING EXPENSES 8,797,208$ 5,964,039$ 2,833,169$ <br />OTHER OPERATING REVENUES <br />LFG PROJECT - - - NA <br />DISPERSED GENERATION CREDIT - - - NA <br />CONNECTION MAINTENANCE - - - NA <br />CUSTOMER PENALTIES - - - NA <br />SECURITY LIGHTS - - - NA <br />CONTRIBUTIONS FROM CUSTOMERS 690,934 690,934 - 100% Dist demand <br />TOTAL OTHER OPERATING REVENUES 690,934$ 690,934$ -$ <br />NON-OPERATING INCOME (EXPENSES) <br />Interest income - - - NA <br />Miscellaneous revenue - - - NA <br />Interest expense and other (773,344) (557,239) (216,105) Dist/Cust split <br />Gain (Loss) on sale of capital assets - - - NA <br />TOTAL NON-OPERATING INCOME (EXPENSES)(773,344)$ (557,239)$ (216,105)$ <br />TRANSFER TO CITY -$ -$ -$ NA <br />MARGIN -$ -$ -$ NA <br />TOTAL REVENUE REQUIREMENT 8,879,618$ 5,830,344$ 3,049,274$ <br />page 2 of 2