20240731Schultz Workpapers.pdf

2024 Idaho PCA
Case No. AVU-E-24-07
Avista Corporation
Workpapers
Kaylene J. Schultz

AVISTA UTILITIES
IDAHO ELECTRIC
IMPACT OF PROPOSED SCHEDULE 66 PCA CHANGE
PROPOSED RATE TO BE EFFECTIVE OCTOBER 1,2024
(000s of Dollars)
(000s of kWh) Total Billed Percent
Revenue Proposed change
Line Type of Schedule Forecasted at Present Sch.66 on Billed
No. Service Number Kilowatt-hours Rates Change Revenue
(a) (b) (c)(1) (d) (e) (f)
1 Residential 1 1,362,736 $ 148,447 $ (9,594) -6.5%
2 General Service 11,12 591,380 $ 53,229 $ (4,163) -7.8%
3 Large General Service 21,22 492,856 $ 51,143 $ (3,470) -6.8%
4 Extra Large General Service 25 344,595 $ 22,608 $ (2,426) -10.7%
5 Clearwater 25P 377,883 $ 22,810 $ (2,660) -11.7%
6 Pumping Service 31,32 60,691 $ 7,173 $ (427) -6.0%
7 Street&Area Lights 41-49 10,014 $ 3,932 $ (70) -1.8%
8 Total 3,240,155 $ 309,342 $ (22,810) -7.4%
check -7.4%
9 Proposed rate $ (0.00205) $ (6,642)
10 Present rate(AVU-E-23-08,Order No.35937) $ 0.00499 $ 16,168
11 Rate Change $ (0.00704) $ (22,810)
Proposed rate
12 Total Amortization and Deferral Balance including interest thru 9/30/24 $ (6,604)
13 Conversion factor(Case No.AVU-E-23-01: Per Final Stipulation&Settlement) 0.996223
14 Revenue Requirement $ (6,629)
15 kWh's from above 3,240,155
16 Proposed rate: $ (0.00205)
(1) Source: Calendar Load forecast for the twelve month period October 1,2024-September 30,2025
2024 Idaho PCA-Schultz Workpapers
Exhibit KJS-1 Page 1 of 7

Avista Corporation PCA
July 2023 through June 2024
IPUC Deferral Analysis
AVU-E-21-01 AVU-E-23-01 Jul-23 thru
Deferral for 2023-24 Deferral Period JulJul23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-2 4 Jun-24 Jun-24
BASE RATE RECOVERY-LOAD CHANGE ADJUSTMENT
Idaho Actual Sales MWh 279,720 263,228 215,006 227,601 269,272 293,112 330,857 273,846 270,724 235,960 231,429 222,612 3,113,367
Idaho Base Sales MWh 245,017 250,933 218,497 235,421 260,464 297,899 304,450 275,917 276,088 250,222 227,023 225,845 3,067,776
Actual-Base Sales MWh 34,703 12,295 (3,491) (7,820) 8,808 (4,787) 26,407 (2,071) (5,364) (14,262) 4,406 (3,233) 45,591
LCAR $/MWh 25.43 25.43 24.41 24.41 24.41 24.41 24.41 24.41 24.41 24.41 24.41 24.41
Retail Revenue Adjustment-Under(+)/Over(-) $ (882,497) (312,662) 85,215 190,886 (215,003) 116,851 (644,595) 50,553 130,935 348,135 (107,550) 78,918 (1,160,814)
Base-to-Actual Percent Difference % 14.16% 4.90% -1.60% -3.32% 3.38% -1.61% 8.67% -0.75% -1.94% -5.70% 1.94% -1.43% 1.49%
NET POWER SUPPLY EXPENSE
Actual Expense
555 Purchased Power $ 16,958,915 27,838,359 14,025,205 15,530,377 18,598,072 13,671,747 54,690,914 15,757,837 15,483,601 14,341,408 14,693,295 14,238,851 235,828,581
447 Sales for Resale $ (26,000,202) (22,956,191) (25,903,589) (18,891,771) (21,245,654) (18,129,690) (33,943,259) (26,569,719) (26,892,327) (16,036,987) (12,103,135) (17,187,526) (265,860,050)
501 Thermal Fuel $ 4,637,531 4,195,868 4,263,142 3,028,895 3,763,156 3,979,809 4,419,464 4,123,045 3,817,132 3,057,279 733,455 1,114,678 41,133,454
547 CT Fuel $ 10,398,260 9,852,495 8,996,101 12,524,452 14,838,485 17,119,650 21,574,355 12,617,001 13,274,499 4,996,584 2,934,591 4,030,212 133,156,685
456 Transmission Revenue $ (2,720,244) (2,730,714) (2,680,016) (3,085,232) (2,933,461) (3,189,820) (3,346,342) (3,343,315) (3,329,394) (3,554,069) (3,401,900) (3,022,063) (37,336,570)
565 Transmission Expense $ 1,585,031 1,498,269 1,475,607 1,482,065 1,402,141 1,450,677 1,782,206 1,735,976 1,687,036 1,659,166 1,611,410 1,578,466 18,948,050
537 MT.Invasive Species Expense $ 64,722 64,722 64,722 64,722 64,722 64,722 64,722 64,722 64,722 64,722 64,722 64,722 776,664
557 Expense Broker Fees $ (7,566) 153,632 196,190 6,777 9,001 5,574 6,131 30,209 7,090 1,627 9,261 40,256 458,182
557 Resource Optimization $ 210,313 809,212 890,798 399,237 1,637,183 2,347,018 3,021,411 1,851,473 228,377 151,774 406,169 329,822 12,282,787
Adjusted Actual Net Expense $ 5,126,760 18,725,652 1,328,160 11,059,522 16,133,645 17,319,687 48,269,602 6,267,229 4,340,736 4,681,504 4,947,868 1,187,418 139,387,783
Idaho Allocation Factor $ 34.36% 34.36% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47%
Idaho Actual Net Expense $ 1,761,555 6,434,134 457,817 3,812,217 5,561,267 5,970,097 16,638,532 2,160,314 1,496,252 1,613,714 1,705,531 409,303 48,020,733
Authorized Net Expense
555 Purchased Power $ 5,937,659 5,836,088 5,942,565 6,184,512 6,489,810 6,556,792 7,435,932 7,069,211 7,433,801 5,672,869 5,579,483 5,419,545 75,558,267
447 Sales for Resale $ (9,557,120) (4,493,194) (7,072,562) (3,997,529) (2,672,014) (4,453,080) (2,316,991) (1,936,564) (2,540,468) (4,230,873) (3,489,856) (5,862,698) (52,622,949)
501 Thermal Fuel $ 2,879,162 3,146,005 3,033,757 2,874,156 2,395,831 3,087,726 3,151,777 2,749,966 2,896,333 2,060,445 1,526,412 1,782,225 31,583,795
547 CT Fuel $ 6,693,265 7,977,571 8,729,385 8,223,214 8,133,493 10,790,239 8,942,104 7,474,530 5,068,911 4,095,763 2,284,385 3,117,887 81,530,747
456 Transmission Revenue $ (2,267,860) (2,209,469) (1,714,509) (1,711,129) (1,937,530) (2,146,621) (1,634,727) (1,811,669) (1,891,560) (1,715,927) (2,123,305) (2,306,697) (23,471,003)
565 Transmission Expense $ 1,439,897 1,439,897 1,439,897 1,439,897 1,439,897 1,439,897 1,439,897 1,439,897 1,439,897 1,439,897 1,439,897 1,439,897 17,278,764
90%Palouse Wind and Rattlesnake Flats $ 0 0 2,442,750 2,442,750 2,442,750 2,442,750 2,442,750 2,442,750 2,442,750 2,442,750 2,442,750 2,442,750 24,427,500
Remove Columbia Basin Hydro Transmission Project(embedd $ 0 0 (83,917) (83,917) (83,917) (83,917) (83,917) (83,917) (83,917) (83,917) (83,917) (83,917) (839,170)
Gas Liquids Revenue-456018 $ (524,310) (514,471) (290,007) (311,801) (548,421) (265,977) (633,351) (664,038) (880,329) (385,474) (657,028) (615,703) (6,290,910)
Montana Invasive Species Expense $ 134,167 134,167 134,167 134,167 134,167 134,167 134,167 134,167 134,167 134,167 134,167 134,167 1,610,004
Settlement Adjustments $ 52,636 52,636 52,636 52,636 52,636 52,636 52,636 52,636 52,636 52,636 52,636 52,636 631,632
Authorized Net Expense $ 4,787,496 11,369,230 12,614,162 15,246,956 15,846,702 17,554,612 18,930,277 16,866,969 14,072,221 9,482,336 7,105,624 5,520,092 149,396,677
Idaho Allocation Factor $ 34.36% 34.36% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47%
Idaho Authorized Net Expense $ 1,644,984 3,906,467 4,348,102 5,255,626 5,462,358 6,051,075 6,525,266 5,814,044 4,850,695 3,268,561 2,449,309 1,902,776 51,479,263
RENEWABLE ENERGY CREDIT REVENUE
Actual REC Revenue $ (121,260) (54,060) (93,740) (327,820) (529,574) (561,552) (331,704) (311,542) (333,892) (1,799,999) (1,129,608) (863,676) (6,458,427)
Authorized REC Revenue $ 0 0 0 0 0 0 0 0 0 0 0 0 0
Actual-Authorized REC Revenue $ (121,260) (54,060) (93,740) (327,820) (529,574) (561,552) (331,704) (311,542) (333,892) (1,799,999) (1,129,608) (863,676) (6,458,427)
Idaho Allocation Factor $ 34.36% 34.36% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47% 34.47%
Actual-Authorized Idaho REC Revenue $ (41,665) (18,575) (32,312) (113,000) (182,544) (193,567) (114,338) (107,389) (115,093) (620,460) (389,376) (297,709) (2,226,028)
COST RECOVERY SUBJECT TO SHARING
Actual-Authorized Net Expense(Idaho share) $ 116,571 2,527,667 (3,890,285) (1,443,409) 98,909 (80,978) 10,113,266 (3,653,730) (3,354,443) (1,654,847) (743,778) (1,493,473) (3,458,530)
Retail Revenue Adjustment $ (882,497) (312,662) 85,215 190,886 (215,003) 116,851 (644,595) 50,553 130,935 348,135 (107,550) 78,918 (1,160,814)
REC Revenue $ (41,665) (18,575) (32,312) (113,000) (182,544) (193,567) (114,338) (107,389) (115,093) (620,460) (389,376) (297,709) (2,226,028)
456030 ED ID-Sch 25P Transmission $ 13,750 13,750 13,750 13,750 13,750 13,750 13,750 13,750 14,536 14,587 14,730 15,090 168,943
456380 ED ID-Sch 25P REC Revenue $ (25,912) (28,254) (30,599) (26,827) (30,349) (31,591) (31,365) (70,300) (94,774) (89,991) (92,425) (95,186) (647,573)
Sch 25P Net Cost (12,162) (14,504) (16,949) (13,077) (16,599) (17,841) (17,615) (56,550) (80,238) (75,404) (77,695) (80,096) (478,630)
Energy Imbalance Market Incremental O&M Costs l'I $ 52,486 57,590 23,511 23,949 9,019 62,362 24,038 25,215 31,101 22,106 23,787 24,339 379,503
Total Cost(Subject to Sharing) $ (767,267) 2,239,516 (3,830,720) (1,354,651) (306,218) (113,173) 9,360,756 (3,741,901) (3,387,738) (1,980,470) (1,294,612) (1,768,021) (6,944,499)
Sharing Percentage % 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% 90% $ (694,450)
Total Cost Recovery Subject to Sharing $ (690,540) 2,015,564 (3,447,648) (1,219,186) (275,596) (101,856) 8,424,680 (3,367,710) (3,048,964) (1,782,423) (1,165,151) (1,591,219) (6,250,049)
Total Power Cost Deferral with Adjustments $ (690,540) 2,015,564 (3,447,648) (1,219,186) (275,596) (101,856) 8,424,680 (3,367,710) (3,048,964) (1,782,423) (1,165,151) (1,591,219) (6,250,049)
2024 Idaho PCA-Schultz Workpapers
Act-Auth-Proposed Page 2 of 7

Avista Corporation PCA
July 2023 through June 2024
IPUC Deferral Analysis
AVU-E-21-01 AVU-E-23-01 Jul-23 thru
Deferral for 2023-24 Deferral Period JulJul23 Aug-23 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-2 4 May-2 4 lun-24 Jun-24
Monthly Interest Rate % 0.16667% 0.16667% 0.16667% 0.16667% 0.16667% 0.16667% 0.41667% 0.41667% 0.41667% 0.41667% 0.41667% 0.41667% 0.41667% 0.41667% 0.41667%
PCA Ending Balances
Account 182385 June 2023 Ending Balance $ 636,536 636,536
Account 182386 June 2023 Ending Balance S 16,017,001 16,017,001
Account 182387 June 2023 Ending Balance $ 0 0
2023-2024 Beginning Balance S 16,653,537 14,539,132 16,169,063 12,385,192 10,577,002 9,091,958 7,627,492 14,467,597 9,674,078 5,323,503 2,291,741 7,330 (2,712,886) (4,126,586) (5,480,520) 16,653,537
2023-2024 Incremental Deferral $ (690,540) 2,015,564 (3,447,648) (1,219,186) (275,596) (101,856) 8,424,680 (3,367,710) (3,048,964) (1,782,423) (1,165,151) (1,591,219) (6,250,049)
RPS Compliance Adjustment S (1,058,163) (1,058,163)
Amortization-Account 182385 $ (393,458) (409,865) (363,172) (609,647) (1,776,142)
Amortization-Account 182386 S (1,227,077) (1,377,764) (1,616,355) (1,486,090) (1,341,921) (1,271,522) (1,128,809) (1,129,028) (10,578,566)
Amortization-Projected $ (1,402,396) (1,336,740) (1,100,714) (3,839,850)
2023-24 Ending Balance w/out Current Month Interest $ 14,511,376 16,144,831 12,358,243 10,556,359 9,074,329 7,612,338 14,435,817 9,613,797 5,283,193 2,269,558 (2,219) (2,712,917) (4,115,282) (5,463,326) (6,581,234) (6,849,233)
Interest $ 27,756 24,232 26,949 20,643 17,629 15,154 31,780 60,281 40,310 22,183 9,549 31 (11,304) (17,194) (22,836) 245,163
2023-24 Final Ending Deferral Balance $ 14,539,132 16,169,063 12,385,192 10,577,002 9,091,958 7,627,492 14,467,597 9,674,078 5,323,503 2,291,741 7,330 (2,712,886) (4,126,586) (5,480,520) (6,604,070) (6,604,070)
I'I Per Avista ID General Rate Case,Case No.AVU-E-21-01,Order No.35156,section 6.Other Settlement Components,subpart E.Energy Imbalance Market("EIM")
202307 202308 202309 202310 202311 202312 202401 202402 202403 202404 202405 202406
$ 16,043697 $ 16,070,437 $ 16,097,222 $ 14,994,756 $ 13,782,654 $ 12,427,862 $ 10,863,290 $ 9,422,464 8,119,804 6,882,115 5,781,982 4,677,046
$ (1,748:704) $ 263,945 $ (3,183,263) $ (4,407,754) $ (4,690,696) $ (4,800,370) $ 3,604,307 $ 251,614 (2,796,301) (4,590,374) (5,774,652) (7,389,932)
$ 244,139 $ (165,319) $ (528,767) $ $ $ $ $ $ $ $ $
$ 14,539,132 $ 16,169,063 $ 12,385,192 $ 10,577,002 $ 9,091,958 $ 7,627,492 $ 14,467,597 $ 9,674,078 5,323,503 2,291,741 7,330 (2,712,886)
2024 Idaho PCA-Schultz Workpapers
Act-Auth-Proposed Page 3 of 7

Source: EREV June Mid-month 06.12.24,Bill Determ Tab
Calendar Load(kWh)by Rate Schedule
Oct 24 Nov 24 Dec 24 Jan 25 Feb 25 Mar 25 Apr 25 May 25 Jun 25 Jul 25 Aug 25 Sep 25 Total
ID001 89,635,324 126,487,143 161,321,860 164,775,756 125,051,527 121,190,603 104,547,622 92,495,613 89,725,779 106,570,700 101,294,498 79,639,244 1,362,735,669
IDO11 43,985,633 47,712,475 51,187,592 53,925,621 45,599,569 45,359,295 42,407,000 41,610,075 43,124,809 49,253,666 46,992,450 40,858,115 552,016,300
ID012 2,532,299 3,794,725 4,604,453 5,126,506 4,032,974 3,801,486 3,026,929 2,538,344 2,368,179 2,733,089 2,583,562 2,220,885 39,363,431
ID021 42,259,253 44,098,847 44,815,482 44,111,493 38,115,478 38,059,706 37,468,439 37,728,048 39,498,038 43,928,852 39,571,932 35,583,396 485,238,964
ID022 571,992 636,249 815,810 866,712 718,300 654,179 559,776 524,753 517,217 609,535 595,207 547,183 7,616,913
ID025 30,783,187 26,726,710 28,862,523 29,217,676 26,794,250 30,251,423 26,978,231 29,712,240 28,017,855 29,814,511 29,858,091 27,577,925 344,594,622
ID025P 31,897,470 25,888,455 32,435,949 30,817,140 26,700,417 33,957,073 28,129,913 34,275,788 31,746,553 37,044,136 35,482,212 29,508,186 377,883,292
ID031 4,613,302 2,911,856 3,386,315 3,747,644 3,109,081 3,017,045 3,139,670 4,203,178 6,257,751 6,807,068 8,534,304 6,294,505 56,021,719
ID032 233,108 214,535 253,579 282,652 219,440 209,881 196,563 286,412 480,569 891,534 949,878 451,248 4,669,399
I D04X 831,823 832,878 830,887 851,788 812,683 861,811 810,877 841,538 832,122 835,246 836,544 835,626 10,013,823
Total 247,343,391 279,303,873 328,514,450 333,722,988 271,153,719 277,362,502 247,265,020 244,215,989 242,568,872 278,488,337 266,698,678 223,516,313 3,240,154,132
3,240,154
Calendar Loads
Jul-24 Aug-24 Sep-24
ID001 108,312,152 101,011,808 77,394,173
IDO11 48,378,248 46,209,101 40,093,929
ID012 2,678,291 2,506,620 2,160,032
ID021 47,379,612 42,208,326 38,247,220
ID022 604,662 584,352 545,023
ID025 29,242,241 30,811,253 26,436,726
ID025P 36,583,865 35,113,026 29,219,813
ID031 7,188,585 8,661,116 6,029,826
ID032 896,178 950,028 451,077
I D04X 843,061 843,864 842,458
Total 282,106,895 268,899,494 221,420,277 772,426,666
Present Rate $0.00499 $0.00499 $0.00499
$1,407,713 $1,341,808 $1,104,887
Present RCF* 0.996223 0.996223 0.996223
$1,402,396 $1,336,740 $1,100,714 $3,839,850
*Case No.AVU-E-23-01:Per Final Stipulation&Settlement
2024 Idaho PCA-Schultz Workpapers
KWh Forecast Page 4 of 7

AVISTA UTILITIES
Settlement Revenue Conversion Factor
Idaho - Electric System
TWELVE MONTHS ENDED JUNE 30, 2022
Line
No. Description Factor
1 Revenues 1.000000
Expenses:
2 Uncollectibles 0.001795
3 Commission Fees 0.001982
4 Idaho Income Tax
5 Total Expenses 0.003777
6 Net Operating Income Before FIT 0.996223
Case No. AVU-E-23-01: Per Final Stipulation &Settlement
2024 Idaho PCA- Schultz Workpapers
Conversion Factor Page 5 of 7

Bill Determinants
2024 Idaho Annual PCA Filing
Present Proposed
Basic Charge $ 15.00 $ 15.00
Block 1 $ 0.09207 $ 0.08503
Block 2 $ 0.10379 $ 0.09675
Present Proposed
Bill Bill
Basic Charge $ 15.00 $ 15.00
Block 1 $ 55.24 $ 51.02 600
Block 2 $ 33.94 $ 31.64 327
Total Bill $ 104.18 $ 97.66 927
Total Bill Impact $ (6.52) -6.3%
2024 Idaho PCA- Schultz Workpapers
Bill Impact Page 6 of 7

Avista Utilities
Idaho Jurisdiction
2024 PCA
Electric Service
(000s of Dollars)
(000s of kWh)
PCA Present Present Proposed Proposed Proposed Incremental
Type of Schedule Billing PCA PCA PCA PCA PCA Rate
Service Number Determinants Rate Revenue Decrease Revenue Rate change
(a) (b) (c) (d) (e) (f) (g) (h) (i)
Residential 1 1,362,736 $ 0.00499 $ 6,800 $ (9,594) $ (2,794) $ (0.00205) $ (0.00704)
General Service 11/12 591,380 $ 0.00499 $ 2,951 $ (4,163) $ (1,212) $ (0.00205) $ (0.00704)
Large General Service 21/22 492,856 $ 0.00499 $ 2,459 $ (3,469) $ (1,010) $ (0.00205) $ (0.00704)
Extra Large General Service 25 344,595 $ 0.00499 $ 1,720 $ (2,426) $ (706) $ (0.00205) $ (0.00704)
Clearwater 25P 377,883 $ 0.00499 $ 1,886 $ (2,661) $ (775) $ (0.00205) $ (0.00704)
Pumping Service 31/32 60,691 $ 0.00499 $ 303 $ (427) $ (124) $ (0.00205) $ (0.00704)
Street&Area Lights 41-49 10,014 $ 0.00499 $ 50 $ (71) $ (21) $ (0.00205) $ (0.00704)
Total 3,240,155 $ 16,169 $ (22,811) $ (6,642)
2024 Idaho PCA- Schultz Workpapers
Bill Impact for Staff Page 7 of 7