|
Exhibit 3-A
<br />2024
<br />REVENUE REQUIREMENT TEST YEAR Plant Distribution Customer Revenue Functionalization Basis
<br />Elk River Municipal Utilities
<br />Functionalization of 2024 Test Year Water Revenue Requirements
<br />Medical/Dental 202,666 78,062 116,628 7,976 - total operating expenses
<br />PERA 59,326 22,851 34,140 2,335 - total operating expenses
<br />FICA 58,185 22,411 33,484 2,290 - total operating expenses
<br />Sick Pay 69,538 26,784 40,017 2,737 - total operating expenses
<br />Holiday Pay 34,537 13,303 19,875 1,359 - total operating expenses
<br />Vacation & PTO 59,901 23,072 34,471 2,358 - total operating expenses
<br />UPMIC Distribution 23,571 9,079 13,564 928 - total operating expenses
<br />Miscellaneous - Wellhead - - - - - NA
<br />Longevity Pay 836 322 481 33 - total operating expenses
<br />Consulting Fees 16,316 6,284 9,389 642 - total operating expenses
<br />Telephone 7,024 2,705 4,042 276 - total operating expenses
<br />Advertising 3,632 1,399 2,090 143 - total operating expenses
<br />Dues & Subscriptions 78,200 30,121 45,002 3,078 - total operating expenses
<br />Travel Expense - - - - - NA
<br />Schools & Meetings 42,421 16,339 24,412 1,670 - total operating expenses
<br />Maintenance of General Plant & Office 2,518 970 1,449 99 - total operating expenses
<br />TOTAL ADMINISTRATIVE EXPENSE 1,017,135 391,774 585,330 40,031 -
<br />GENERAL EXPENSE
<br />CIP Rebates - Residential 1,090 - - 1,090 - 100% customer
<br />CIP Rebates - Commercial - - - - - NA
<br />CIP - Administration - - - - - NA
<br />CIP - Marketing 1,117 - - 1,117 - 100% customer
<br />CIP - Labor - - - - - 100% customer
<br />Environmental Compliance 683 263 393 27 - total operating expenses
<br />Misc General Expense - - - - - total operating expenses
<br />TOTAL GENERAL EXPENSE 2,890 263 393 2,234 -
<br />TOTAL OPERATING EXPENSE 3,553,251 - 1,368,619 2,044,787 139,845 -
<br />NON-OPERATING REVENUES (EXPENSES)
<br />Interest income 104,286 - - - 104,286 100% revenue
<br />Miscellaneous revenue 429,016 - - - 429,016 100% revenue
<br />Interest expense and other (33,949) (5,784) (28,165) - - fixed assets
<br />Gain (Loss) on sale of capital assets (5,090) - - - (5,090) 100% revenue
<br />TOTAL NON-OPERATING REV (EXP)494,263 (5,784) (28,165) - 528,212
<br />OTHER OPERATING REVENUE
<br />Connection maintenance 72,409 - - - 72,409 100% revenue
<br />Customer penalties 31,102 - - - 31,102 100% revenue
<br />TOTAL OTHER OPERATING REVENUE 103,511 - - - 103,511
<br />Developer and Connection Fees 477,998 - 477,998 - - 100% distribution
<br />MARGIN 333,525 - - - 333,525 100% revenue
<br />TOTAL REVENUE REQUIREMENT 2,811,004 1,374,402 1,594,954 139,845 (298,198)
<br />page 2 of 2
|