|
Exhibit 3-D
<br /> Elk River Municipal Utilities
<br /> 2015 Test Year Allocation of Revenue Requirements
<br /> Commercial Large Allocation
<br /> Total Residential Non-demand Demand Demand Factor
<br /> Demand Component
<br /> Purchased Power 4,466,929 1,394,922 476,358 1,615,799 979,850 12 CP
<br /> Production 726,794 226,961 77,506 262,899 159,427 12 CP
<br /> Transmission 5,189 2,076 604 1,568 941 1 CP
<br /> Distribution 659,043 245,947 73,384 233,124 106,589 1 NCP
<br /> General&Administrative 1,415,066 528,085 157,566 500,552 228,863 1 NCP
<br /> Depreciation 1,325,317 494,592 147,572 468,806 214,348 1 NCP
<br /> Other Operating Income (838,711) (261,911) (89,441) (303,383) (183,977) 12 CP
<br /> Non-Operating Income (6,324) (2,360) (704) (2,237) (1,023) 1 NCP
<br /> Margin 1,268,716 473,469 141,270 448,784 205,193 1 NCP
<br /> Total Demand $ 9,022,019 $ 3,101,781 $ 984,114 $ 3,225,912 $ 1,710,212
<br /> Energy Component
<br /> Purchased Power 16,020,115 4,665,264 1,520,746 5,266,781 4,567,324 WE
<br /> Production 202,129 58,863 19,188 66,452 57,627 WE
<br /> General&Administrative 210,452 60,310 19,659 69,747 60,735 RE
<br /> Depreciation 24,437 7,003 2,283 8,099 7,052 RE
<br /> Other Operating Income (236,437) (67,757) (22,086) (78,359) (68,234) RE
<br /> Non-Operating Income (74) (21) (7) (24) (21) RE
<br /> Margin 2,654,269 760,646 247,945 879,671 766,008 RE
<br /> Total Energy $ 18,874,892 $ 5,484,308 $ 1,787,728 $ 6,212,366 $ 5,390,491
<br /> Customer Facility Component
<br /> Distribution 462,220 187,507 41,474 151,758 81,481 CF
<br /> General&Administrative 643,198 260,924 57,712 211,177 113,384 CF
<br /> Depreciation 472,427 191,648 42,390 155,109 83,280 CF
<br /> Non-Operating Income (2,156) (875) (193) (708) (380) CF
<br /> Margin 257,839 104,597 23,135 84,655 45,452 CF
<br /> Total Customer Facility $ 1,833,527 $ 743,802 $ 164,517 $ 601,991 $ 323,217
<br /> Customer Service Component
<br /> Distribution 6,064 4,923 817 319 5 CS
<br /> Customer Accounts 567,076 460,393 76,374 29,809 500 CS
<br /> General&Administrative 366,266 297,361 49,329 19,253 323 CS
<br /> Depreciation 69,291 56,255 9,332 3,642 61 CS
<br /> Non-Operating Income (209) (169) (28) (11) (0) CS
<br /> Margin 165,024 133,979 22,225 8,675 146 CS
<br /> Total Customer Service $ 1,173,513 $ 952,742 $ 158,049 $ 61,688 $ 1,035
<br /> Direct Lighting Component
<br /> Distribution $ 65,211 57,863 6,399 937 13 C
<br /> General&Administrative 87,461 77,606 8,583 1,256 17 C
<br /> Depreciation 30,887 27,407 3,031 444 6 C
<br /> Non-Operating Income (136) (121) (13) (2) (0) C
<br /> Margin 30,014 26,632 2,945 431 6 C
<br /> Total Direct $ 213,437 $ 189,386 $ 20,945 $ 3,066 $ 41
<br /> Revenue Component
<br /> Other Operating Income (401,534) (135,129) (40,200) (130,394) (95,811) R
<br /> Non-Operating Income (258,344) (86,941) (25,864) (83,894) (61,644) R
<br /> Transfer to City 1,099,657 370,071 110,093 357,101 262,392 R
<br /> Margin 71,964 24,218 7,205 23,369 17,171 R
<br /> Total Revenue $ 511,743 $ 172,218 $ 51,234 $ 166,183 $ 122,108
<br /> Total Revenue Requirements $ 31,629,131 $ 10,644,237 $ 3,166,586 $10,271,205 $ 7,547,103
<br /> Total Revenues $ 31,629,131 $ 11,249,153 $ 3,350,843 $ 9,957,797 $ 7,071,338
<br /> Percent Revenue Requirements 100.0% 33.7% 10.0% 32.5% 23.9%
<br /> Percent Revenues 100.0% 35.6% 10.6% 31.5% 22.4%
<br /> Percent Change 0.0% -5.4% -5.5% 3.1% 6.7%
<br /> Revenue Req/kWh 0.112 0.132 0.120 0.110 0.093
<br /> Revenue/kWh 0.112 0.139 0.127 0.107 0.087
<br /> 8n
<br />
|