ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Docket No. 2024.05.053
3
ELECTRIC SUMMARY
4
5
TABLE 1 - Total Revenue Requirement Increase2024Overall
6
IncreaseProp. TaxTotalReturnROE
7
Electric Base Revenue Requirement$156,503,585 $7,409,982 $163,913,567 7.49%10.80%
8
PCCAM - Reduce from $213,529,449 to $119,007,402($94,522,047)($94,522,047)
9
Total Electric Utility (July 10, 2024 Application Letter)$61,981,538 $69,391,520
10
11
TABLE 2 - Total Broken Down between T&D, Generation, and PCCAM
12
T & D Base Revenue Requirement (Delivery)$98,758,616 $2,485,381 $101,243,997
13
Generation Base Revenue Requirement Supply)$57,744,969 $4,924,601 $62,669,570
14
Total Electric Base Revenue Requirement (EAR-1)$156,503,585 $7,409,982 $163,913,567
15
16
Generation Excluding CU4 and YCGS Base Rev. Req.$17,510,753 ($183,705)$17,327,048
17
CU4 Base Rev. Requirement($2,520,701)$637,838 ($1,882,863)
18
YCGS Base Revenue Requirement$42,754,917 $4,470,468 $47,225,385
19
Total Generation (EAR-1)$57,744,969 $4,924,601 $62,669,570
20
21
PCCAM (Supply) July 10, 2024 Application Letter.
Total Electric (July 10, 2024 Application Letter)
($94,522,047)
22
Total Generation/Supply($31,852,477)
23
24
Total Delivery (T&D) plus Generation plus Supply (PCCAM)$69,391,520
25
26
27
TABLE 3 - Total Percentage Increase
28
Total Electric Utility (Base + PCCAM) Percentage Increase
29
Source Electric Statement G
Total Retail Customer Revenues
30
\$628,827,106 $628,827,106
31
PCCAM Total Revs. As Referenced in Application$213,529,449
32
PCCAM Total Revs. As Approved in 2022.07.078$208,282,098
33
Total Current Retail Revenues$842,356,555 $837,109,204
34
35
Total Requested Retail Rev. Increase 2024.05.053$69,391,520 $69,391,520
36
Percentage Increase8.24%8.29%
37
C. Fang Application Leter stated % Increase8.30%8.30%
38
39
40
TABLE 4 Base Only
41
Electric Utility (Base Only Excluding PCCAM) Percentage Increase
GenerationTotalTotal
42
Source NorthWestern Electric Statement GT & DExcl CU4 /YCGSCU4YCGSGenerationElectric
43
Rate Schedule Retail Revenues - Current Rates$363,394,925$189,069,403 $70,091,496 $259,160,899 $622,555,824
44
Required Revenue Increase$101,243,997$17,327,048 ($1,882,863)$47,225,385 $62,669,570 $163,913,567
45
46
Rate Schedule Retail Revenues - Proposed Rates$464,638,922$206,396,451$68,208,633$47,225,385$321,830,469$786,469,391
47
48
Percentage Increase27.9%9.2%-2.7%NA24.2%26.3%
49
50
51
TABLE 5 - Percentage Increase by Customer Class
52
NorthWestern Proposed Rate Design Adjusted
53
by Customer Class - Non-Fuel Base Revs. + Prop. TaxRevenue atRevenue atPercentage
54
C. Fang Exhibit CSF-2.1Current RatesProposed IncreaseProposed RatesIncrease
55
Residential$293,366,698 $75,886,457 $369,253,155 25.87%
56
GS-1 Secondary$259,637,431 $71,862,509 $331,499,940 27.68%
57
GS-1 Primary$21,765,838 $6,457,504 $28,223,342 29.67%
58
GS-2 Substation$17,890,987 $4,541,061 $22,432,048 25.38%
59
GS-2 Transmission$6,099,830 $1,902,288 $8,002,118 31.19%
60
Irrigation$9,540,464 $1,049,664 $10,590,128 11.00%
61
Lighting$14,254,578 $2,214,093 $16,468,671 15.53%
62
Total$622,555,826 $163,913,576 $786,469,402 26.33%
63
64
65
TABLE 6 - Residential ImpactMonthlyAnnualPercentage
66
Avg. Residential Cutomer Increase using 750kWh per month$7.02 $84.24 6.26%
67
July 10, 2024 Application Letter - Page 6
68
69
70
TABLE 7 - Interim
71
INTERIM ELECTRIC INCREASE PROPOSAL TO BE EFFECTIVE OCTOBER 1, 2024
72
73
ProposedProposed
74
Interim IncreaseFinal IncreaseDifference
75
Base Revenue Requirement -T&D + Generation (Excl Prop.Tax)$50,609,797 $113,748,668 ($63,138,871)
76
Property Taxes -2024$7,409,982 $7,409,982 $0
77
YCGS - Interim = Bridge Rate, Final = Rev. Req. (Excl Prop Tax)$58,470,142 $42,754,917 $15,715,225
78
PCCAM($94,522,047)($94,522,047)$0
79
Total Interim$21,967,874 $69,391,520 ($47,423,646)
80
81
82
Bridge Rate
83
Rather than ask for interim increase October 1, 2024 for YCGS, NorthWestern has filed for approval of a "Bridge Rate."
84
Typically an interim increase is base on the revenue requirement as filed which is then reduced by various adjustments.
85
The "Bridge Rate" is addressed in the testimony of Joseph Stimatz Pages 11-12. Stimatz uses an approach which he
86
calls the total benefit approach. This is a marked different approach than using the filed revenue requirement.
87
It is completely unclear how the total benefit is actually calculated.
88
The filed total revenue requirement for YCGS excluding property taxes was $42,754,917. If the ROE used to calculate
89
the revenue requirement is reduced from the proposed 10.80% to the last approved 9.65%, as required by Montana statute
90
for an interim increase request, this reduces the YCGS revenue requirement to $40,643,858. This amount would be the maximum
91
one would expect in an interim filing for YCGS. This is $17,826,284 less than the requested "Bridge Rate" of $58,470,142 which also
92
excluded property taxes.
93
94
95
TABLE 8 - Residential ImpactMonthlyAnnualPercentage
96
Avg. Residential Cutomer Increase using 750kWh per month$2.35 $28.20 2.16%
97
July 10, 2024 Interim Application - Page 10
98
99
100