Document
NorthWestern Energy Schedule O‐9
Electric Utility ‐ State of South Dakota Page 1 of 5
Pro Forma Year Ending December 31, 2022
Derivation of Increased Rates and Proof of Revenue
Billing Billing
Line Description Units Rate Revenue Units Rate Revenue $ %
1 Large Commercial and Industrial Rate 34
2 Summer Rate
3 Demand Charge ‐ First 100 kW 203,100 $11.05 $2,244,259 203,100 $14.13 $2,869,808 $625,549 27.87%
4 Demand Charge ‐ Next 400 kW 198,557 $9.79 1,943,877 198,557 $12.52 2,485,938 542,062 27.89%
5 Demand Charge ‐ Next 500 kW 186,424 $8.53 1,590,199 186,424 $10.91 2,033,888 443,690 27.90%
6 Total Demand Charge 588,082 $5,778,334 588,082 $7,389,634 $1,611,300 27.89%
7 Power Factor Charge Revenue 168,515 215,486 46,971 27.87%
8 MIN34 Revenue 42,971 54,940 11,969 27.85%
9 Energy Charge ‐ First 100 X Demand 58,097,495 $0.04911 2,853,168 58,097,495 $0.06279 3,647,942 794,774 27.86%
10 Energy Charge ‐ Next 300 X Demand 141,880,980 $0.02348 3,331,365 141,880,980 $0.03001 4,257,848, 55,572 12,107 27.86%
10 Energy Charge ‐ Next 300 X Demand 2,653,500 $0.02348 62,304 2,653,500 $0.03001 79,632 17,327 27.81%
11 Energy Charge ‐ Next 100 X Demand 686,700 $0.01595 10,953 686,700 $0.02038 13,995 3,042 27.77%
12 Energy Charge ‐ Remaining kWh 72,500 $0.00841 610 72,500 $0.01075 779 170 27.82%
13 Total Energy Charge 4,297,750 $117,332 4,297,750 $149,978 $32,647 27.82%
14 Sub‐total Summer Rate $201,920 $258,157 $56,237 27.85%
15 Booked to Billed Revenue Ratio 100.181% 100.00%
16 Booked Base Rate Revenue $202,285 $258,157 $55,872 27.62%
17 Off‐Peak Rate
18 Demand Charge ‐ First 100 kW 1,600 $11.05 $17,680 1,600 $14.13 $22,608 $4,928 27.87%
19 Demand Charge ‐ Next 400 kW 5,790 $9.79 56,687 5,790 $12.52 72,494 15,807 27.89%
20 Demand Charge ‐ Next 500 kW 3,526 $8.53 30,076 3,526 $10.91 38,468 8,392 27.90%
21 Total Demand Charge 10,916 $104,443 10,916 $133,570 $29,127 27.89%
22 Power Factor Charge Revenue 223 285 62 28.07%
23 Option L Discount ‐2,780 ‐3,554 ‐774 27.84%, 10 Energy Charge ‐ Next 300 X Demand 8,284,458 $0.02348 194,519 8,284,458 $0.03001 248,617 54,098 27.81%
11 Energy Charge ‐ Next 100 X Demand 1,335,191 $0.01595 21,296 1,335,191 $0.02038 27,211 5,915 27.77%
12 Energy Charge ‐ Remaining kWh 1,026,144 $0.00841 8,630 1,026,144 $0.01075 11,031 2,401 27.82%
13 Total Energy Charge 13,527,522 $365,967 13,527,522 $467,803 $101,836 27.83%
14 Sub‐total Summer Rate $621,770 794,973 173,203 27.86%
15 Booked to Billed Revenue Ratio 100.191% 100.00%
16 Booked Base Rate Revenue $622,957 $794,973 $172,015 27.61%
17 Off‐Peak Rate
18 Demand Charge ‐ First 100 kW 1,900 $11.05 $20,995 1,900 $14.13 $26,847 $5,852 27.87%
19 Demand Charge ‐ Next 400 kW 7,144 $9.79 69,940 7,144 $12.52 89,443 19,503 27.89%
20 Demand Charge ‐ Next 500 kW 51,120 $8.53 436,055 51,120 $10.91 557,721 121,666 27.90%
21 Total Demand Charge 60,164 $526,990 60,164 $674,011 $147,021 27.90%
22 Power Factor Charge Revenue 45,842 58,620 12,778 27.87%
23 Option L Discount $0.00000, 27.86%
10 Energy Charge ‐ Next 300 X Demand 10,656,818 $0.02348 250,222 10,656,818 $0.03001 319,811 69,589 27.81%
11 Energy Charge ‐ Next 100 X Demand 3,262,531 $0.01595 52,037 3,262,531 $0.02038 66,490 14,453 27.77%
12 Energy Charge ‐ Remaining kWh 2,342,660 $0.00841 19,702 2,342,660 $0.01075 25,184 5,482 27.82%
13 Total Energy Charge 19,894,065 $500,331 19,894,065 $639,542 $139,210 27.82%
14 Sub‐total Summer Rate $838,795 1,072,431 233,636 27.85%
15 Booked to Billed Revenue Ratio 100.178% 100.00%
16 Booked Base Rate Revenue $840,292 $1,072,431 $232,139 27.63%
17 Off‐Peak Rate
18 Demand Charge ‐ First 100 kW 2,000 $11.05 $22,100 2,000 $14.13 $28,260 $6,160 27.87%
19 Demand Charge ‐ Next 400 kW 7,191 $9.79 70,402 7,191 $12.52 90,034 19,632 27.89%
20 Demand Charge ‐ Next 500 kW 43,206 $8.53 368,550 43,206 $10.91 471,381 102,831 27.90%
21 Total Demand Charge 52,398 $461,052 52,398 $589,675 $128,623 27.90%
22 Power Factor Charge Revenue 56,262 71,944 15,682 27.87%
23 Option, 8,237 1,792 27.81%
11 Energy Charge ‐ Next 100 X Demand 7,157 $0.01595 114 7,157 $0.02038 146 32 27.77%
12 Energy Charge ‐ Remaining kWh 0 $0.00841 0 0 $0.01075 0 0 0.00%
13 Total Energy Charge 381,755 $11,476 381,755 $14,669 $3,194 27.83%
14 Sub‐total Summer Revenue Before YS Discount 22,286 28,493 6,207 27.85%
15 Booked to Billed Revenue Ratio 100.174% 100.00%
16 Booked Base Rate Revenue $22,324 $28,493 $6,168 27.63%
17 Off‐Peak Rate
18 Demand Charge ‐ First 100 kW 1,600 $11.05 $17,680 1,600 $14.13 $22,608 $4,928 27.87%
19 Demand Charge ‐ Next 400 kW 263 $9.79 2,579 263 $12.52 3,299 719 27.89%
20 Demand Charge ‐ Next 500 kW 0 $8.53 0 0 $10.91 0 0 0.00%
21 Total Demand Charge 1,863 $20,259 1,863 $25,907 $5,647 27.87%
22 Power Factor Charge Revenue 1 1 $0 81.82%
23 YS Discount $0.00000 ‐11,389 0 $0.00000 ‐11,389
24 Energy Charge ‐ First 100 X Demand 186,348 $0.04911 $9,152 186,348 $0.06279 11,701 $2,549 27.86%
25 Energy Charge ‐ Next 300 X Demand 473,474 $0.02348 11,117