ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1
2
Stipulation Revenue Allocation with NorthWestern Rebuttal on Contested Issues
3
SchedulesTotal Base Revenues at Current Rates $Current Base Revenue Allocation By Customer ClassTotal Base Revenues at Proposed Rates $Base Revenue
Increase $		Base Revenue Increase Allocation by Customer ClassYCGS Revenue Requirement Alloated Across Customer ClassesBase Revenue Increase w/Staff's YCGS Position (All to Residential)YCGS Revenue Requirement Allocation Increase w/ $18.36 Distributed BackBase Revenue Increase Accounting for $18.36 Million Added Back(Original) Base Revenue % IncreaseUpdated base revenue % increaseBase Revenue % Increase w/$18.36 Million Added BackTotal PCCAM Revenues at Current Rates $PCCAM Allocation by Customer ClassPCCAM Revenue
Decrease $		New PCCAM Revenue ProjectionsPCCAM Actuals from Quarterly Adjustments (Allocated by %)Revenue
Increase $		Revenue
Increase %		Previous Total RRNew Total RRTotal Increase (Staff Recommendation)Total RR w/$18.36 Million Added BackTotal Increase w/$18.36 Million Added Back
4
Residential 293,366,699 47.12% 352,479,937 59,113,238 54.16%13,333,06946,497,879$16,360,01749,524,82720.15%15.85%16.88% 95,354,435 44.66% (42,165,557) 53,188,878 92,343,256 16,947,681 4.36% 388,721,134 432,207,833 11.19% 435,234,782 11.97%
5
GS-1 Secondary 259,637,430 41.71% 296,895,401 37,257,971 34.14%15,992,91436,896,075$15,992,91436,896,07514.35%14.21%14.21% 92,757,211 43.44% (41,014,512) 51,742,699 89,828,049 (3,756,541)-1.07% 352,394,641 386,361,555 9.64% 386,361,555 9.64%
6
GS-1 Primary 21,765,838 3.50% 26,771,981 5,006,143 4.59%2,167,1654,975,805$2,167,1654,975,80523.00%22.86%22.86% 10,355,943 4.85% (4,615,589) 5,740,354 10,028,915 390,554 1.22% 32,121,781 36,770,557 14.47% 36,770,557 14.47%
7
GS-2 Substation 17,890,986 2.87% 21,165,037 3,274,051 3.00%1,412,2453,249,114$1,412,2453,249,11418.30%18.16%18.16% 6,939,802 3.25% (3,107,465) 3,832,337 6,720,651 166,586 0.67% 24,830,788 27,860,751 12.20% 27,860,751 12.20%
8
GS-2 Transmission 6,099,830 0.98% 6,507,909 408,079 0.37%170,629399,577$170,629399,5776.69%6.55%6.55% 4,011,803 1.88% (1,801,489) 2,210,314 3,885,115 (1,393,410)-13.78% 10,111,633 10,384,522 2.70% 10,384,522 2.70%
9
Irrigation 9,540,464 1.53% 11,849,256 2,308,792 2.12%1,000,1732,295,494$1,000,1732,295,49424.20%24.06%24.06% 3,139,541 1.47% (1,388,213) 1,751,328 3,040,398 920,579 7.26% 12,680,005 14,876,356 17.32% 14,876,356 17.32%
10
Lighting 14,254,578 2.29% 16,022,146 1,767,568 1.62%756,0251,747,699$756,0251,747,69912.40%12.26%12.26% 970,713 0.45% (429,221) 541,492 940,059 1,338,347 8.79% 15,225,291 16,942,336 11.28% 16,942,336 11.28%
11
Total 622,555,824 100.00% 731,691,666 109,135,842 100.00%34,832,21996,061,642$34,832,21999,088,59017.53%15.43%15.92% 213,529,448 100.00% (94,522,046) 119,007,402 206,786,444 14,613,796 1.75% 836,085,272 925,403,910 10.68% 928,430,858 11.04%
12
13
Calculation Check
14
YCGS Dissallowances: 0
15
YCGS Revenue RequirementRRTaxTotalW/$18.36 Million Put Back (Estimate)Approximate RR Increase from $18.36 Million
16
NWE Settlement Position43,929,4683,976,95147,906,419
17
Staff Recommendation$31,418,644$3,413,575$34,832,219$37,859,167$3,026,948
18
Difference12,510,824563,37613,074,200
19
20
LCG Depreciation Reduction-$867,750-$867,750
21
MCC YCGS Cost Overruns Reduction-$11,643,074-563,376-$12,206,450
22
Total Reduction-$12,510,824-563,376-$13,074,200
23
24
Rate BaseRRRR as % of Rate Base
25
NWE YCGS Settlement Position$305,394,384$43,929,46814%
26
YCGS Staff Recommendation$227,679,944$31,418,64414%
27
YCGS Commission Order$246,039,944$34,445,592
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100