20210730ID PCA Final Report 05.2021.pdf

AVISTA UTILITIES
POWER COST ADJUSTMENT REPORT
MONTH OF MAY 2021
ID PCA May 2021 Page 1 of 18
Avista Corporation PCA
July 2020 through June 2021IPUC Deferral Analysis
Jul-20 thru
Deferral for 2019-20 Deferral Period Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 May-21
BASE RATE RECOVERY - LOAD CHANGE ADJUSTMENT
Idaho Actual Sales MWh 260,747 262,325 200,094 228,859 264,909 293,188 277,679 268,236 263,641 231,616 240,290 2,791,584Idaho Base Sales MWh 248,508 267,545 222,188 233,573 258,867 300,596 291,519 255,432 263,479 232,405 217,175 2,791,287Actual - Base Sales MWh 12,239 (5,220)(22,094)(4,714)6,042 (7,408)(13,840)12,804 162 (789)23,115 297LCAR$/MWh 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 22.00 Retail Revenue Adjustment - Under(+)/Over(-)$(269,258)114,840 486,068 103,708 (132,924)162,976 304,480 (281,688)(3,564)17,358 (508,530)(6,534)
Base-to-Actual Percent Difference %4.92%-1.95%-9.94%-2.02%2.33%-2.46%-4.75%5.01%0.06%-0.34%10.64%0.01%
NET POWER SUPPLY EXPENSE
Actual Expense555 Purchased Power $9,869,695 10,928,100 9,569,453 10,017,659 11,706,704 11,598,520 10,842,390 11,196,254 12,433,514 11,603,998 10,049,846 119,816,133447 Sales for Resale $(6,841,567)(7,823,003)(4,852,075)(5,606,876)(6,417,968)(6,140,828)(6,141,300)(10,652,299)(4,461,531)(4,528,743)(9,283,538)(72,749,728)
501 Thermal Fuel $2,120,045 3,116,082 2,273,596 1,759,242 1,952,420 3,127,177 3,076,898 2,528,161 3,256,809 1,685,015 1,349,895 26,245,340547 CT Fuel $3,030,971 5,587,553 5,566,648 5,945,096 5,742,175 6,805,062 6,183,441 9,662,506 3,546,107 4,135,657 3,691,972 59,897,188456 Transmission Revenue $(2,088,798)(2,272,043)(1,942,659)(1,894,337)(1,185,446)(1,339,874)(1,148,455)(1,455,347)(1,193,050)(1,162,521)(1,766,188)(17,448,718)
565 Transmission Expense $1,407,838 1,374,950 1,394,933 1,430,774 1,356,670 1,374,950 1,427,937 1,395,907 1,456,732 1,373,241 1,340,017 15,333,949
537 MT. Invasive Species Expe $134,176 134,176 134,176 134,176 134,176 134,176 134,176 134,176 134,176 134,176 134,176 1,475,936557 Expense Broker Fees $19,631 1,829 46,235 16,885 13,647 11,492 9,094 24,579 12,090 13,015 3,667 172,164
557 Resource Optimization $699,050 100,288 100,953 597,407 (465,942)(405,420)432,811 (525,048)(523,916)(475,697)(550,303)(1,015,817)
Adjusted Actual Net Expense $8,351,041 11,147,932 12,291,260 12,400,026 12,836,436 15,165,255 14,816,992 12,308,889 14,660,931 12,778,141 4,969,544 131,726,447Idaho Allocation Factor $34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%Idaho Actual Net Expense $2,890,295 3,858,299 4,254,006 4,291,650 4,442,690 5,248,695 5,128,161 4,260,106 5,074,148 4,422,515 1,719,959 45,590,524
Authorized Net Expense555 Purchased Power $6,873,649 7,493,752 5,812,287 5,858,969 6,095,603 6,285,056 6,656,472 6,714,560 6,376,335 6,174,902 6,066,290 70,407,875
447 Sales for Resale $(4,383,497)(3,207,858)(5,796,167)(4,809,854)(3,282,986)(4,385,610) (3,058,364)(3,072,028)(4,566,884)(5,980,611)(3,814,582) (46,358,441)501 Thermal Fuel $2,296,839 2,529,061 2,596,434 2,643,241 2,568,771 2,658,469 2,626,073 2,508,793 2,598,458 2,294,629 1,616,919 26,937,687547 CT Fuel $3,622,194 6,001,181 6,718,588 6,093,306 5,933,976 7,575,488 7,913,114 6,814,051 6,109,768 3,778,713 1,270,638 61,831,017
456 Transmission Revenue $(1,893,836)(1,745,852)(1,207,426)(1,243,178)(1,250,663)(1,271,088) (1,350,696)(1,404,488)(1,090,019)(1,075,655)(1,442,603) (14,975,504)565 Transmission Expense $1,382,417 1,382,417 1,382,417 1,382,417 1,382,417 1,382,417 1,382,417 1,382,417 1,382,417 1,382,417 1,382,417 15,206,587Gas Liquids Revenue - 456018 $(43,583)(43,583)(43,583)(43,583)(43,583)(43,583) (43,583) (43,583) (43,583) (43,583) (43,583) (479,413)
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 1,475,837Settlement Adjustments $36,545 52,387 (17,283)17,595 88,374 156,333 229,921 (71,932)(7,545)2,378 (164,615) 322,158Authorized Net Expense $8,024,895 12,595,671 9,579,433 10,033,079 11,626,075 12,491,648 14,489,521 12,961,957 10,893,114 6,667,357 5,005,048 114,367,803
Idaho Allocation Factor $34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%Idaho Authorized Net Expense $2,777,416 4,359,362 3,315,442 3,472,449 4,023,785 4,323,359 5,014,823 4,486,133 3,770,107 2,307,572 1,732,247 41,297,079
RENEWABLE ENERGY CREDIT REVENUEActual REC Revenue $(216,916)(186,661)(179,040)(323,874)(328,875)(200,446)(478,216)(266,329)(386,437)(455,504)(470,697)(3,492,995)Authorized REC Revenue $(101,917)(101,917)(101,917)(101,917)(101,917)(101,917)(101,917)(101,917)(101,917)(101,917)(101,917)(1,121,087)
Actual - Authorized REC Revenue $(114,999)(84,744)(77,123)(221,957)(226,958)(98,529)(376,299)(164,412)(284,520)(353,587)(368,780)(1,365,021)
Idaho Allocation Factor $34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%Actual - Authorized Idaho REC Revenue $(39,801)(29,330)(26,692)(76,819)(78,550)(34,101)(130,237)(56,903)(98,472)(122,376)(127,635)(820,916)
COST RECOVERY SUBJECT TO SHARINGActual - Authorized Net Expense (Idaho share)$112,879 (501,063)938,564 819,201 418,905 925,336 113,338 (226,027)1,304,041 2,114,943 (12,288)6,007,829Retail Revenue Adjustment $(269,258)114,840 486,068 103,708 (132,924)162,976 304,480 (281,688)(3,564)17,358 (508,530)(6,534)
REC Revenue $(39,801)(29,330)(26,692)(76,819)(78,550)(34,101)(130,237)(56,903)(98,472)(122,376)(127,635)(820,916)- 456030 ED ID - Sch 25P Transmission $10,000 10,000 10,738 11,624 11,551 10,000 10,000 10,148 10,258 10,221 10,092 114,632
456380 ED ID - Sch 25P REC Revenue $(20,706)(13,899)(31,762)(28,177)(28,363)(25,651) (29,429)(26,883)(24,848)(26,430)(15,014) (271,162)Sch 25P Net Cost (10,706)(3,899)(21,024)(16,553)(16,812)(15,651)(19,429)(16,735)(14,590)(16,209)(4,922)(120,809)0
Total Cost (Subject to Sharing)$(206,886)(419,452)1,376,916 829,537 190,619 1,038,560 268,152 (581,353)1,187,415 1,993,716 (653,375)5,023,849Sharing Percentage %90%90%90%90%90%90%90%90%90%90%90%Total Cost Recovery Subject to Sharing $(186,197)(377,507)1,239,224 746,583 171,557 934,704 241,337 (523,218)1,068,674 1,794,344 (588,038)4,521,463
00Total Power Cost Deferral with Adjustments $(186,197)(377,507)1,239,224 746,583 171,557 934,704 241,337 (523,218)1,068,674 1,794,344 (588,038)4,521,463
AVU-E-19-04
2021 ID PCA - Annual Summary and Act-Auth- Proposed Page: 1 of 2
ID PCA May 2021 Page 2 of 18
PCA Deferral Balance Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jul-20 thru
Monthly Interest Rate %0.1667%0.1667%0.1667%0.1667%0.1667%0.1667%0.0833%0.0833%0.0833%0.0833%0.0833%May-21
PCA Ending Balances
Account 182385 & 182387 June 2019 Ending Balance $0Account 182386 June 2019 Ending Balance $46,080 46,0802019-2020 Beginning Balance $46,080 (450,302)(674,571)702,989 1,515,410 1,652,946 2,547,168 2,747,679 2,185,252 3,212,315 4,973,052 4,356,964
2020-2021 Incremental Deferral $(186,197)(377,507)1,239,224 746,583 171,557 934,704 241,337 (523,218)1,068,674 1,794,344 (588,038)4,521,463RPS Compliance Adjustment*$(446,075) (446,075)Amortization - Account 182386 $135,813 153,989 139,461 64,666 (36,547)(43,237)(42,948)(41,498)(43,431)(36,283)(32,193)217,792
Amortization - Account 182387 $0Amortization - Projected $02020-21 Ending Balance w/out Current Month Interest $(450,379)(673,820)704,114 1,514,238 1,650,420 2,544,413 2,745,557 2,182,963 3,210,495 4,970,376 4,352,821 4,339,260
Interest $77 (751)(1,125)1,172 2,526 2,755 2,122 2,289 1,820 2,676 4,143 17,7042019-20 Final Ending Deferral Balance $(450,302)(674,571)702,989 1,515,410 1,652,946 2,547,168 2,747,679 2,185,252 3,212,315 4,973,052 4,356,964 4,356,964
2021 ID PCA - Annual Summary and Act-Auth- Proposed Page: 2 of 2
ID PCA May 2021 Page 3 of 18
Explanation:
Record deferral of power costs in Idaho, amortization of existing balance, and
interest & DFIT entries.
Se . Co. FERC Ser. Jur. S.I.Debit Credit Comment
5 001 557380 - IDAHO PCA-DEF ED ID DL 588,038.00 0.00 Current Deferral Expense - PCA
10 001 182387 - REGULATORY ASSET ID PCA
DEFERRAL 3
ED ID DL 0.00 588,038.00 Current Deferral Reg Asset - PCA
12 001 419600 - INTEREST ON ENERGY DEFERRALS ED ID DL 0.00 3,893.00 Interest Income on 182387
13 001 182387 - REGULATORY ASSET ID PCA
DEFERRAL 3
ED ID DL 3,893.00 0.00 Interest Income on 182387
15 001 419600 - INTEREST ON ENERGY DEFERRALS ED ID DL 0.00 251.00 Interest Income on 182386 Account
20 001 182386 - REGULATORY ASSET ID PCA
DEFERRAL 2
ED ID D 251.00 0.00 Interest Income on 182386 Account
25 001 182386 - REGULATORY ASSET ID PCA
DEFERRAL 2
ED ID DL 0.00 32,193.00 Amortization of Balance
30 001 557390 - IDAHO PCA AMT ED ID DL 32,193.00 0.00 Amortization of Balance
Totals:624,375.00 624,375.00
Prepared by Cheryl Kettner
Reviewed by
Approved for Entry
Corporate Accounting use Only
Date
Date
Date
Page 1 of 1
Avista Corporation Journal Entry
Journal:
Team:
Type:
Category:
Currency:
480-ID PCA
Last Saved by:
Submitted by:
Approved by:
Cheryl Kettner
Cheryl Kettner
Printed 06/07/2021 at 7:46 AM
Last Update: 06/07/2021 7:45 AM
Approval Requested: 06/07/2021 7:45 AM
Resource Accounting
C
DJ
USD
Effective Date: 202105
June 07, 2021
6/7/2021
ID PCA May 2021 Page 4 of 18
Avista Corp.
DJ480 and DJ481 Power Deferral Calculation Workbook for ID PCA & WA ERM
Manager Revie May‐21
Data Input Validation Sign‐off/Date
Verify that total amounts agree to the underlying detail on attached system 
reports, noting any exceptions. [source data accuracy and completeness]
Primary information is from GL Wand. Other data inputs come from: 
Cognos ‐ Billed Revenue Usage and Rates Department amortization 
calculations.
Attach relevant screen shots of system reports, ensuring that the necessary 
parameters are appropriately displayed. [parameters accuracy and 
com leteness]
Cognos ‐ Billed Revenue Usage reports attached, parameters reviewed 
and noted to be correct for May 2021.
Agree total amount(s) to relevant journal entries in the GL. [source data 
accuracy and completeness]
Total deferral amounts calculated from workbook agree to journal entry 
line items for May 2021.
Validate that check totals equal $0 or variances are immaterial (note all 
variances). [report logic accuracy and completeness]
Updated workbooks for 2021 authorized, updated PT ratio, validated 
formulas, added line items fo new applicable accounts.  
When rolling forward the document, ensure that all formulas are updated 
appropriately.
Validated for May 2021.
Data Input Validation Sign‐off/Date
Review system parameters to ensure that the appropriate filters are used. 
[parameters accuracy and completeness
Reviewed to make sure that May data was used in all spreadsheets and 
reports.  IM
Agree the system report screen shots to the system export data in the report. 
[source data accuracy and completeness
Some data is from GL with use of GL wand.  Agreed volumes from Cognos 
report to Load Adjustment and RRC.  IM
Verify that total amounts agree to the underlying detail on attached  reports. 
[source data accuracy and completeness
Agreed totals to respective reports and journal entry. IM
Validate that check totals equal $0 or are immaterial, as noted above. [source 
data accuracy and completeness]
Data checks equal $0. IM
Spreadsheet Logic Validation Sign‐off/Date
Review report to ensure that any assumption and/or threshold for 
investigation used in the document are appropriate. [completeness]
Noted that May data was used and spreadsheet appeared rolled forward.  
IM
Spot check formulas to ensure that they have been appropriately rolled 
forward and use the appropriate inputs. [accuracy]
IM
Review explanations for all items to ensure appropriateness, and that all 
relevant considerations have been sufficiently documented.
In May we are still in the deadband for ERM. No deferral entry this 
month.
Review all comments left by preparer. IM
Ensure all comments/questions resolved on a timely basis.IM
NOTE: ANY COMMENT OR QUESTION SHOULD BE DOCUMENTED BELO
Comment/Question Response Follow‐Up
Preparer Checklist
Reviewer Checklist
ID PCA May 2021 Page 5 of 18
Idaho Power Cost Adjustment (PCA) Deferral Balance - Current Year Bucket
Interest compounds and is calculated monthly
Interest Rate
2020 0.16667%
2021 0.08333%
12/31/2020 182387 2,083,461
1/31/2021 182387 2,083,461 241,337 1,736 2,326,534 2,326,534 0
2/28/2021 182387 2,326,534 (523,218)1,939 1,805,255 1,805,255 0
3/31/2021 182387 1,805,255 1,068,674 1,504 2,875,433 2,875,433 0
4/30/2021 182387 2,875,433 1,794,344 2,396 4,672,173 4,672,173 0
5/31/2021 182387 4,672,173 (588,038)3,893 4,088,028 4,672,173 584,145
6/30/2021 182387
6/30/2021 182385
7/31/2021 182385
8/31/2021 182385
9/30/2021 182385
10/31/2021 182385
11/30/2021 182385
12/31/2021 182385
Entry:
Debit Credit
557380 ED ID 588,038 0 Idaho PCA-Def
182387 ED ID 0 588,038 Regulatory Asset ID PCA Deferral
419600 ED ID 0 3,893 Interest Income Energy Deferrals
182387 ED ID 3,893 0 Regulatory Asset ID PCA Deferral
to the Pending tab
from the Pending tab
H:\Power Deferrals\Power Deferral Journals\ID PCA\2021 ID PCA\2021 DJ480 ID PCA
ID PCA May 2021 Page 6 of 18
Idaho Power Cost Adjustment (PCA) Deferral Balance - Amortizing Bucket
Interest compounds and is calculated monthly
Interest Rate
2020 0.16667%
2021 0.08333%
12/31/2020 182386 463,707
1/31/2021 182386 463,707 (42,948)386 421,145 421,145 0
2/28/2021 182386 421,145 (41,498)351 379,998 379,998 0
3/31/2021 182386 379,998 (43,431)317 336,884 336,884 0
4/30/2021 182386 336,884 (36,283)281 300,882 300,882 0
5/31/2021 182386 300,882 (32,193)251 268,940 300,882 31,942
6/30/2021 182386
7/31/2021 182386
8/31/2021 182386
9/30/2021 182386
10/31/2021 182386
10/31/2021 182387
11/30/2021 182387 0
12/31/2021 182387
Entry:
Debit Credit
182386 ED ID 0 32,193 Regulatory Asset ID PCA Deferral
557390 ED ID 32,193 0 Idaho PCA Amt
419600 ED ID 0 251 Interest Revenue Energy Deferrals
to the Pending tab
from the Pending tab
H:\Power Deferrals\Power Deferral Journals\ID PCA\2021 ID PCA\2021 DJ480 ID PCA
ID PCA May 2021 Page 7 of 18
Line
No.IDAHO ACTUALS TOTAL Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
1 555 Purchased Power $56,126,002 $10,842,390 $11,196,254 $12,433,514 $11,603,998 $10,049,846 $0 $0 $0 $0 $0 $0 $0
2 447 Sale for Resale ($35,067,411)($6,141,300)($10,652,299)($4,461,531)($4,528,743)($9,283,538)$0 $0 $0 $0 $0 $0 $0
3 501 Thermal Fuel $11,896,778 $3,076,898 $2,528,161 $3,256,809 $1,685,015 $1,349,895 $0 $0 $0 $0 $0 $0 $0
4 547 CT Fuel $27,219,683 $6,183,441 $9,662,506 $3,546,107 $4,135,657 $3,691,972 $0 $0 $0 $0 $0 $0 $0
5 456 Transmission Rev ($6,725,561)($1,148,455)($1,455,347)($1,193,050)($1,162,521)($1,766,188)$0 $0 $0 $0 $0 $0 $0
6 565 Transmission Exp $6,993,834 $1,427,937 $1,395,907 $1,456,732 $1,373,241 $1,340,017 $0 $0 $0 $0 $0 $0 $0
7 537 MT Invasive Species Exp $670,880 $134,176 $134,176 $134,176 $134,176 $134,176 $0 $0 $0 $0 $0 $0 $0
8 557 Expenses $62,445 $9,094 $24,579 $12,090 $13,015 $3,667 $0 $0 $0 $0 $0 $0 $0
9 Adjusted Actual Net Expense $61,176,650 $14,384,181 $12,833,937 $15,184,847 $13,253,838 $5,519,847 $0 $0 $0 $0 $0 $0 $0
AUTHORIZED NET EXPENSE - SYSTEM
Total through
Jan/21 Feb/21 Mar/21 Apr/21 May/21 Jun/21 Jul/21 Aug/21 Sep/21 Oct/21 Nov/21 Dec/21
10 555 Purchased Power 31,988,559.00 6,656,472.00 6,714,560.00 6,376,335.00 6,174,902.00 6,066,290.00 5,885,835.00 6,873,649.00 7,493,752.00 5,812,287.00 5,858,969.00 6,095,603.00 6,285,056.00
11 447 Sale for Resale (20,492,469.00) (3,058,364.00) (3,072,028.00) (4,566,884.00) (5,980,611.00) (3,814,582.00) (3,585,099.00) (4,383,497.00) (3,207,858.00) (5,796,167.00) (4,809,854.00) (3,282,986.00) (4,385,610.00)
12 501 Thermal Fuel 11,644,872.00 2,626,073.00 2,508,793.00 2,598,458.00 2,294,629.00 1,616,919.00 1,641,106.00 2,296,839.00 2,529,061.00 2,596,434.00 2,643,241.00 2,568,771.00 2,658,469.00
13 547 CT Fuel 25,886,284.00 7,913,114.00 6,814,051.00 6,109,768.00 3,778,713.00 1,270,638.00 1,329,074.00 3,622,194.00 6,001,181.00 6,718,588.00 6,093,306.00 5,933,976.00 7,575,488.00
14 456 Transmission Revenue (6,363,461.00) (1,350,696.00) (1,404,488.00) (1,090,019.00) (1,075,655.00) (1,442,603.00) (1,667,688.00) (1,893,836.00) (1,745,852.00) (1,207,426.00) (1,243,178.00) (1,250,663.00) (1,271,088.00)
15 565 Transmission Expense 6,912,085.00 1,382,417.00 1,382,417.00 1,382,417.00 1,382,417.00 1,382,417.00 1,382,417.00 1,382,417.00 1,382,417.00 1,382,417.00 1,382,417.00 1,382,417.00 1,382,417.00
16 REC Rev (509,585.00) (101,917.00) (101,917.00) (101,917.00) (101,917.00) (101,917.00) (101,917.00) (101,917.00) (101,917.00) (101,917.00) (101,917.00) (101,917.00) (101,917.00)
17 Gas Liquids Revenue (217,915.00) (43,583.00) (43,583.00) (43,583.00) (43,583.00) (43,583.00) (43,583.00) (43,583.00) (43,583.00) (43,583.00) (43,583.00) (43,583.00) (43,583.00)
18 Montana Invasive Species Expense 670,835.00 134,167.00 134,167.00 134,167.00 134,167.00 134,167.00 134,167.00 134,167.00 134,167.00 134,167.00 134,167.00 134,167.00 134,167.00
19 Settlement Adjustments (11,793.00) 229,921.00 (71,932.00) (7,545.00) 2,378.00 (164,615.00) (122,794.00) 36,545.00 52,387.00 (17,283.00) 17,595.00 88,374.00 156,333.00
20 Authorized Net Expense 49,507,412.00 14,387,604.00 12,860,040.00 10,791,197.00 6,565,440.00 4,903,131.00 4,851,518.00 7,922,978.00 12,493,755.00 9,477,517.00 9,931,163.00 11,524,159.00 12,389,732.00
21 Actual - Authorized Net Expense $11,669,238 ($3,423)($26,103)$4,393,650 $6,688,398 $616,716
22 Resource Optimization ($3,699,336)($45,405)($791,377)($910,353)($931,201)($1,021,000)
23 Adjusted Actual - Authorized Net Expense $7,969,902 ($48,828)($817,480)$3,483,297 $5,757,197 ($404,284)
24 Idaho Allocation 34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%34.61%
25 Idaho Share $2,758,383 ($16,899)($282,930)$1,205,569 $1,992,566 ($139,923)
Idaho 100% Activity (Clearwater)($71,885)($19,429)($16,735)($14,590)($16,209)($4,922)$0 $0 $0 $0 $0 $0 $0
26 ($471,944)$304,480 ($281,688)($3,564)$17,358 ($508,530)
27 $2,214,554 $268,152 ($581,353)$1,187,415 $1,993,715 ($653,375)
28 90% of Net Power Cost Change $1,993,099 $241,337 ($523,218)$1,068,674 $1,794,344 ($588,038)
29 $1,993,099 $241,337 ($523,218)$1,068,674 $1,794,344 ($588,038)
30 ($1,993,099)($241,337)$523,218 ($1,068,674)($1,794,344)$588,038 Acct 557380 Entry; (+) Rebate, (-) Surcharge
ID Load Change Adjustment (+) Surcharge; (-)
Total Power Cost Deferral (+)
Surcharge; (-) Rebate
Net Power Cost Increase (+) Surcharge; (-)
Rebate
2021 WA ID Actual Deferrals - 6/7/2021
ID PCA May 2021 Page 8 of 18
Line
No.TOTAL Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
555 PURCHASED POWER
1 Other Short-Term Purchases $10,118,511 $1,760,598 $1,547,991 $3,311,009 $2,206,989 $1,291,924 $0 $0 $0 $0 $0 $0 $0
2 Chelan County PUD (Rocky Reach Slice)$5,958,335 $1,191,667 $1,191,667 $1,191,667 $1,191,667 $1,191,667 $0 $0 $0 $0 $0 $0 $0
3 Douglas County PUD (Wells Settlement)$813,838 $192,122 $210,943 $116,948 $138,458 $155,367 $0 $0 $0 $0 $0 $0 $0
4 Douglas County PUD (Wells)$908,170 $181,634 $181,634 $181,634 $181,634 $181,634 $0 $0 $0 $0 $0 $0 $0
5 Grant County PUD (Priest Rapids/Wanapum)$4,700,470 $939,387 $939,387 $939,387 $942,922 $939,387 $0 $0 $0 $0 $0 $0 $0
6
7 Inland Power & Light - Deer Lake $5,922 $1,259 $1,104 $1,364 $1,083 $1,112 $0 $0 $0 $0 $0 $0 $0
8 Small Power $681,186 $156,567 $140,787 $123,152 $140,445 $120,235 $0 $0 $0 $0 $0 $0 $0
9 Stimson Lumber $507,171 $136,396 $105,546 $101,790 $47,743 $115,696 $0 $0 $0 $0 $0 $0 $0
10 City of Spokane-Upriver $1,285,428 $352,910 $210,446 $214,420 $263,620 $244,032 $0 $0 $0 $0 $0 $0 $0
11 City of Spokane- Waste-to-Energy $2,413,248 $553,990 $561,159 $492,538 $463,820 $341,741 $0 $0 $0 $0 $0 $0 $0
12 Clearwater Power Company $7,910 $1,545 $3,341 $0 $1,490 $1,534 $0 $0 $0 $0 $0 $0 $0
13 Rathdrum Power, LLC (Lancaster PPA )$11,999,206 $2,379,924 $2,422,369 $2,400,610 $2,406,660 $2,389,643 $0 $0 $0 $0 $0 $0 $0
14 Palouse Wind $10,523,995 $2,054,962 $2,174,857 $2,096,184 $2,291,429 $1,906,563 $0 $0 $0 $0 $0 $0 $0
15 Rattlesnake Flat, LLC $5,426,457 $741,745 $1,257,608 $1,069,731 $1,280,006 $1,077,367 $0 $0 $0 $0 $0 $0 $0
16 WPM Ancillary Services $849,878 $216,599 $267,709 $204,121 $87,285 $74,164 $0 $0 $0 $0 $0 $0 $0
17 Non-Mon. Accruals ($73,723)($18,915)($20,294)($11,041)($41,253)$17,780 $0 $0 $0 $0 $0 $0 $0
18 Total 555 Purchased Power $56,126,002 $10,842,390 $11,196,254 $12,433,514 $11,603,998 $10,049,846 $0 $0 $0 $0 $0 $0 $0
555 PURCHASED POWER
555000 $55,265,268 $9,888,603 $12,141,354 $12,196,279 $11,427,486 $9,611,546 $0 $0 $0 $0 $0 $0 $0
555030 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
555100 ($1,085,592)$515,200 ($1,494,528)($7,020)($76,544)($22,700)$0 $0 $0 $0 $0 $0 $0
555312 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
555313 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
555380 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
555550 ($73,723)($18,915)($20,294)($11,041)($41,253)$17,780 $0 $0 $0 $0 $0 $0 $0
555700 $1,205,585 $245,545 $307,440 $58,800 $215,500 $378,300 $0 $0 $0 $0 $0 $0 $0
Solar Select Adjustment ($35,414)($4,642)($5,427)($7,625)($8,476)($9,244)$0 $0 $0 $0 $0 $0 $0
555380 $3,781,307 $958,220 $810,387 $926,051 $490,907 $595,742 $0 $0 $0 $0 $0 $0 $0
Clearwater Adjustment ($3,781,307)($958,220)($810,387)($926,051)($490,907)($595,742)$0 $0 $0 $0 $0 $0 $0
555710 $849,878 $216,599 $267,709 $204,121 $87,285 $74,164 $0 $0 $0 $0 $0 $0 $0$56,126,002 $10,842,390 $11,196,254 $12,433,514 $11,603,998 $10,049,846 $0 $0 $0 $0 $0 $0 $0
447 SALES FOR RESALE
19 Short-Term Sales ($26,761,196)($4,624,428)($8,898,576)($3,005,420)($3,078,048)($7,154,724)$0 $0 $0 $0 $0 $0 $0
20 Nichols Pumping Index Sale ($436,360)($60,959)($111,784)($73,106)($101,368)($89,143)$0 $0 $0 $0 $0 $0 $0
21 Soverign/Kaiser Load Following ($54,738)($10,659)($10,198)($11,351)($10,838)($11,692)$0 $0 $0 $0 $0 $0 $0
22 Pend Oreille DES ($138,786)($31,587)($29,894)($25,068)($24,353)($27,884)$0 $0 $0 $0 $0 $0 $0
23 Merchant Ancillary Services ($7,676,331)($1,413,667)($1,601,847)($1,346,586)($1,314,136)($2,000,095)$0 $0 $0 $0 $0 $0 $0
24 Total 447 Sales for Resale ($35,067,411)($6,141,300)($10,652,299)($4,461,531)($4,528,743)($9,283,538)$0 $0 $0 $0 $0 $0 $0

447 SALES FOR RESALE
447000 ($24,341,715)($2,925,963)($6,454,601)($1,455,960)($4,507,136)($8,998,055)$0 $0 $0 $0 $0 $0 $0Deduct Revenue From Solar Select $495,007 $21,742 $48,190 $93,037 $168,687 $163,351 $0 $0 $0 $0 $0 $0 $0
447100 $5,635,082 ($255,100)$289,632 ($253,584)$2,590,380 $3,263,754 $0 $0 $0 $0 $0 $0 $0
447150 ($7,111,897)($1,163,293)($2,319,559)($1,243,577)($1,123,553)($1,261,915)$0 $0 $0 $0 $0 $0 $0
447700 ($1,217,679)($188,420)($346,405)($50,740)($255,700)($376,414)$0 $0 $0 $0 $0 $0 $0
447710 ($849,878)($216,599)($267,709)($204,121)($87,285)($74,164)$0 $0 $0 $0 $0 $0 $0
447720 ($7,676,331)($1,413,667)($1,601,847)($1,346,586)($1,314,136)($2,000,095)$0 $0 $0 $0 $0 $0 $0
($35,067,411)($6,141,300)($10,652,299)($4,461,531)($4,528,743)($9,283,538)$0 $0 $0 $0 $0 $0 $0
501 FUEL-DOLLARS
25 Kettle Falls Wood-501110 $2,311,566 $572,049 $499,776 $642,433 $531,571 $65,737 $0 $0 $0 $0 $0 $0 $0
26 Kettle Falls Gas-501120 $9,379 $1,028 $8,827 ($4,157)$529 $3,152 $0 $0 $0 $0 $0 $0 $0
27 Colstrip Coal-501140 $9,505,967 $2,481,260 $2,015,723 $2,602,101 $1,151,931 $1,254,952 $0 $0 $0 $0 $0 $0 $0
28 Colstrip Oil-501160 $69,866 $22,561 $3,835 $16,432 $984 $26,054 $0 $0 $0 $0 $0 $0 $0
29 Total 501 Fuel Expense $11,896,778 $3,076,898 $2,528,161 $3,256,809 $1,685,015 $1,349,895 $0 $0 $0 $0 $0 $0 $0
30 Kettle Falls 169,179 42,518 37,569 47,100 37,947 4,045 - - - - - - -
31 Colstrip 351,296 89,341 75,697 96,986 43,333 45,939 - - - - - - -
501 FUEL-COST PER TON
32 Kettle Falls $13.45 $13.30 $13.64 $14.01 $16.25
Avista Corp. - Resource AccountingIDAHO DEFERRED POWER COST CALCULATION - ACTUAL SYSTEM POWER SUPPLY EXPENSES
2021 WA ID Actual Deferrals ID Monthly 2
ID PCA May 2021 Page 9 of 18
Line
No.TOTAL Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
Avista Corp. - Resource AccountingIDAHO DEFERRED POWER COST CALCULATION - ACTUAL SYSTEM POWER SUPPLY EXPENSES
547 FUEL
34 NE CT Gas-547213 $959 $113 ($12)$87 ($1)$772 $0 $0 $0 $0 $0 $0 $0
35 Boulder Park-547216 $454,972 $13,515 $102,792 $114,417 $126,490 $97,758 $0 $0 $0 $0 $0 $0 $0
36 Kettle Falls CT-547211 ($691)$120 ($8,703)$9,978 ($113)($1,973)$0 $0 $0 $0 $0 $0 $0
37 Coyote Springs2-547610 $9,155,979 $3,313,555 $4,600,091 $384,055 $426,040 $432,238 $0 $0 $0 $0 $0 $0 $0
38 Lancaster-547312 $16,288,062 $2,848,373 $4,650,571 $2,761,100 $2,921,481 $3,106,537 $0 $0 $0 $0 $0 $0 $0
39 Rathdrum CT-547310 $1,320,402 $7,765 $317,767 $276,470 $661,760 $56,640 $0 $0 $0 $0 $0 $0 $0
40 Total 547 Fuel Expense $27,219,683 $6,183,441 $9,662,506 $3,546,107 $4,135,657 $3,691,972 $0 $0 $0 $0 $0 $0 $0
41 TOTAL NET EXPENSE $60,175,052 $13,961,429 $12,734,622 $14,774,899 $12,895,927 $5,808,175 $0 $0 $0 $0 $0 $0 $0
202101 202102 202103 202104 202105 202106 202107 202108 202109 202110 202111 202112
42 456100 ED AN ($4,136,347)($593,403)($845,855)($644,720)($718,854)($1,333,515)$0 $0 $0 $0 $0 $0 $0
43 456120 ED AN - BPA Trans. ($385,000)($77,000)($77,000)($77,000)($77,000)($77,000)$0 $0 $0 $0 $0 $0 $0
44 456020 ED AN-Sale of excess BPA Trans ($47,289)$0 $0 ($7,259)($18,490)($21,540)$0 $0 $0 $0 $0 $0 $0
45 456030 ED AN - Clearwater Trans ($507,202)($101,484)($102,584)($102,211)($100,923)($100,000)$0 $0 $0 $0 $0 $0 $0
46 456130 ED AN - Ancillary Services Revenue ($849,878)($216,599)($269,939)($201,891)($87,285)($74,164)$0 $0 $0 $0 $0 $0 $0
47 456017 ED AN - Low Voltage ($28,890)($5,778)($5,778)($5,778)($5,778)($5,778)$0 $0 $0 $0 $0 $0 $0
48 456700 ED ID - Low Voltage ($26,165)($5,233)($5,233)($5,233)($5,233)($5,233)$0 $0 $0 $0 $0 $0 $0
49 456705 ED AN - Low Voltage ($744,790)($148,958)($148,958)($148,958)($148,958)($148,958)$0 $0 $0 $0 $0 $0 $0
50 Total 456 Transmission Revenue ($6,725,561)($1,148,455)($1,455,347)($1,193,050)($1,162,521)($1,766,188)$0 $0 $0 $0 $0 $0 $0
51 565000 ED AN $6,971,154 $1,423,401 $1,391,371 $1,452,196 $1,368,705 $1,335,481 $0 $0 $0 $0 $0 $0 $0
52 565710 ED AN $22,680 $4,536 $4,536 $4,536 $4,536 $4,536 $0 $0 $0 $0 $0 $0 $0
53 Total 565 Transmission Expense $6,993,834 $1,427,937 $1,395,907 $1,456,732 $1,373,241 $1,340,017 $0 $0 $0 $0 $0 $0 $0
54 557165 ED AN $40,871 $5,456 $20,823 $8,041 $8,813 ($2,262)$0 $0 $0 $0 $0 $0 $0
55 557018 ED AN $21,574 $3,638 $3,756 $4,049 $4,202 $5,929 $0 $0 $0 $0 $0 $0 $0
56 Total 557 ED AN Broker & Related Fees $62,445 $9,094 $24,579 $12,090 $13,015 $3,667 $0 $0 $0 $0 $0 $0 $0
57 537000 ED AN - MT Invasive Species $670,880 $134,176 $134,176 $134,176 $134,176 $134,176
58 Total 537 ED AN MT Invasive Species $670,880 $134,176 $134,176 $134,176 $134,176 $134,176 $0 $0 $0 $0 $0 $0 $0
59 Econ Dispatch-557010 ($3,468,468)($674,103)($364,175)($1,034,253)($754,555)($641,382)$0 $0 $0 $0 $0 $0 $0
60 Econ Dispatch-557150 $3,941,033 $834,483 ($577,904)$1,001,213 $1,293,782 $1,389,459 $0 $0 $0 $0 $0 $0 $0
61 Gas Bookouts-557700 $73,308 $0 $0 $0 $73,308 $0 $0 $0 $0 $0 $0 $0 $0
62 Gas Bookouts-557711 ($73,308)$0 $0 $0 ($73,308)$0 $0 $0 $0 $0 $0 $0 $0
63 Intraco Thermal Gas-557730 $23,035,951 $2,868,984 $6,447,097 $3,205,749 $3,411,503 $7,102,618 $0 $0 $0 $0 $0 $0 $0
64 Fuel Dispatch-456010 $3,128,466 $1,567,174 $293,860 $489,761 $343,965 $433,706 $0 $0 $0 $0 $0 $0 $0
65 Fuel Dispatch-456015 ($17,680,295)($2,909,737)($2,249,977)($3,422,134)($3,100,295)($5,998,152)$0 $0 $0 $0 $0 $0 $0
66 Other Elec Rev - Extraction Plant Cr - 456018 ($198,693)($2,367)($63,628)($33,745)($50,779)($48,174)$0 $0 $0 $0 $0 $0 $0
67 Other Elec Rev - Specified Source - 456019 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
68 Intraco Thermal Gas-456730 ($10,401,622)($1,251,637)($4,010,362)($731,747)($1,619,411)($2,788,465)$0 $0 $0 $0 $0 $0 $0
69 Fuel Bookouts-456711 $388,882 $111,045 $177,323 $100,514 $0 $0 $0 $0 $0 $0 $0 $0 $0
70 Fuel Bookouts-456720 ($388,882)($111,045)($177,323)($100,514)$0 $0 $0 $0 $0 $0 $0 $0 $0
71 Other Purchases and Sales Subtotal ($1,643,628)$432,797 ($525,089)($525,156)($475,790)($550,390)$0 $0 $0 $0 $0 $0 $0
($2,057,183)($478,216)($266,329)($386,437)($455,504)($470,697)$0 $0 $0 $0 $0 $0 $0
74 Misc. Power Exp. Actual-557160 $1,189 $0 $0 $1,189 $0 $0 $0 $0 $0 $0 $0 $0 $0
75 REC Purchases Subtotal $1,189 $0 $0 $1,189 $0 $0
76 Wind REC Exp Authorized $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
77 Wind REC Exp Actual 557395 $286 $14 $41 $51 $93 $87 $0 $0 $0 $0 $0 $0 $0
78 Wind REC Subtotal $286 $14 $41 $51 $93 $87
79 456030 ED ID - Clearwater Trans $50,719 $10,000 $10,148 $10,258 $10,221 $10,092 $0 $0 $0 $0 $0 $0 $0
2021 WA ID Actual Deferrals ID Monthly 3
ID PCA May 2021 Page 10 of 18
Line
No.TOTAL Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21
Avista Corp. - Resource AccountingIDAHO DEFERRED POWER COST CALCULATION - ACTUAL SYSTEM POWER SUPPLY EXPENSES
81 Clearwater ($71,885)($19,429)($16,735)($14,590)($16,209)($4,922)$0 $0 $0 $0 $0 $0 $0
82 Net Resource Optimization ($3,699,336)($45,405)($791,377)($910,353)($931,201)($1,021,000)
83 Adjusted Actual Net Expense $57,405,429 $14,319,347 $12,025,825 $14,259,904 $12,306,428 $4,493,925
2021 WA ID Actual Deferrals ID Monthly 4
ID PCA May 2021 Page 11 of 18
Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 YTD
Total Billed Sales 287,970 278,350 291,298 243,252 215,915 (24,316) - - - - - - 1,292,469
Deduct Prior Month Unbilled (178,282) (167,991) (157,877) (130,220) (118,584) (142,959) - - - - - - (895,913)
Add Current Month Unbilled 167,991 157,877 130,220 118,584 142,959 - - - - - - - 717,631
Total Retail Sales 277,679 268,236 263,641 231,616 240,290 (167,275) - - - - - - 1,114,187
Test Year Consumption 291,519 255,432 263,479 232,405 217,175 214,774 248,508 267,545 222,188 233,573 258,867 300,596 1,260,010
Difference from Test Year (13,840) 12,804 162 (789) 23,115 (382,049) (360,597)
Load Change Adjustment Rate -
$/MWh $22.00 $22.00 $22.00 $22.00 $22.00 $22.00 $22.00 $22.00 $22.00 $22.00 $22.00 $22.00
($304,480)$281,688 $3,564 ($17,358)$508,530 ($8,405,078) ($7,933,134)
Page 4 of 4
ID PCA May 2021 Page 12 of 18
Accounting Period: 202105 State Code: ID
Rate Schedule Desc Meter Qty Usage Qty Revenue Amt YTD Meter Qty YTD Usage YTD Revenue Amt
0001 - RESIDENTIAL 0 0 11,935.3 0 0 85,637.65
0011 - GENERAL SERVICE 0 0 4,265.51 0 0 25,702.72
0012 - RESID&FARM-GEN SERV 0 0 301.14 0 0 2,225.69
0021 - LARGE GENERAL SERV 0 0 6,524.05 0 0 36,035.52
0022 - RESID&FRM-LGE GEN SE 0 0 74.79 0 0 504.33
0025 - EXTRA LGE GEN SERV 0 0 4,287.83 0 0 21,810.78
0031 - PUMPING SERVICE 0 0 695.22 0 0 2,829.57
0032 - PUMPING SVC RES&FRM 0 0 65.63 0 0 209.59
0041 - CO OWNED ST LIGHTS 0 0 0.21 0 0 1.05
0042 - CO OWND ST LTS SO VA 0 0 45.91 0 0 234.16
0044 - CST OWND ST LT SO VA 0 0 3.93 0 0 19.69
0045 - CUST OWND ST LT ENGY 0 0 4.83 0 0 24.15
0046 - CUST OWND ST LT S V 0 0 14.06 0 0 70.28
0047 - AREA LIGHT-COM&INDUS 0 0 5.23 0 0 26.34
0048 - AREA LGHT-FARM&RESID 0 0 9.04 0 0 46.17
0049 - AREA LGHT-HI PRES SO 0 0 29.23 0 0 162.88
025 EXTRA LARGE GEN SERVICE/POTLATCH 0 0 4,107.75 0 0 21,888.8
Overall - Summary 0 0 32,369.66 0 0 197,429.37
For Internal Use Only
Conversion Factor 0.994549 Conversion Factor Changes October 1st ot Every Year32,193.21
Run Date: Jun 4, 2021
Electric Revenue Report by Revenue Class Data Source: Financial Reporting
H:\Power Deferrals\Power Deferral Journals\ID PCA\2021 ID PCA\Rates Backup\May 2021 Revenue_RateSch_CM_YTD for ID PCA
ID PCA May 2021 Page 13 of 18
State Code: ID
Accounting Period Service Revenue Class Revenue Class Desc Meter Qty Usage Qty Revenue Amt YTD Average Meters YTD Usage YTD Revenue Amt
01 01 RESIDENTIAL 120,551 82,406,311 8,268,393 120,278 590,711,745 58,475,670
21 21 FIRM COMMERCIAL 18,151 74,746,813 6,706,569 18,206 420,071,297 37,003,748
31 31 FIRM- INDUSTRIAL 329 77,677,872 4,054,729 331 470,336,932 22,045,806
39 39 FIRM-PUMPING-IRRIGATION ONLY 38 361,147 33,750 41 747,047 72,196
51 51 LIGHTING-PUBLIC STREET AND HIWAY 180 563,949 230,631 179 2,904,337 1,150,018
80 80 INTERDEPARTMENT REVENUE 46 196,139 18,437 46 1,191,146 104,806
83 83 MISC-SERVICE REVENUE SNP 0 0 5,296 0 0 22,784
85 85 MISC-RENT FROM ELECTRIC PROPERTY 0 0 9,545 0 0 47,723
139,295 235,952,230 19,327,350 139,082 1,485,962,504 118,922,751
139,295 235,952,230 19,327,350 139,082 1,485,962,504 118,922,751
139,295 235,952,230 19,327,350 139,082 1,485,962,504 118,922,751
For Internal Use Only
Run Date: Jun 4, 2021
202105 ED
Data Source: Financial Reporting
Data Updated Daily
H:\Power Deferrals\Power Deferral Journals\ID PCA\2021 ID PCA\Rates Backup\May 2021Revenue By Revenue Class ID
ID PCA May 2021 Page 14 of 18
Current Month Journal Entry
Jurisdiction: ID
Revenue Class Revenue Class Desc Town Code Revenue Class Rate Schedule Gross Unbilled kWh Total Unbilled + Basic Charge
01 01 RESIDENTIAL 3800 01 012 940,661 $118,258
01 RESIDENTIAL 3800 01 001 37,141,220 $3,617,721
01 RESIDENTIAL 3800 01 022 232,766 $17,390
01 RESIDENTIAL 3800 01 032 116,344 $14,306
01 - Summary 38,430,991 $3,767,676
21 21 FIRM COMMERCIAL 3800 21 021 17,990,744 $1,282,353
21 FIRM COMMERCIAL 3800 21 025 5,086,218 $295,269
21 FIRM COMMERCIAL 3800 21 031 1,427,164 $136,786
21 FIRM COMMERCIAL 3800 21 011 13,053,764 $1,228,751
21 - Summary 37,557,889 $2,943,159
31 31 FIRM- INDUSTRIAL 3800 31 021 2,285,355 $152,630
31 FIRM INDUSTRIAL 3800 31 025P 40,732,600 $1,790,999
31 FIRM- INDUSTRIAL 3800 31 011 188,870 $17,055
31 FIRM- INDUSTRIAL 3800 31 031 627,261 $59,561
31 FIRM-INDUSTRIAL 3800 31 025PG 24,316,000 $595,742
31 FIRM-INDUSTRIAL 3800 31 025 23,135,900 $1,338,904
31 - Summary 91,285,985 $3,954,892
ID - Summary 167,274,866 $10,665,727
Jurisdiction: WA
Revenue Class Revenue Class Desc Town Code Revenue Class Rate Schedule Gross Unbilled kWh Total Unbilled + Basic Charge
01 01 RESIDENTIAL 2800 01 032 260,896 $33,758
01 RESIDENTIAL 2800 01 022 924,648 $81,283
01 RESIDENTIAL 2800 01 012 1,872,487 $306,684
01 RESIDENTIAL 2800 01 002 204,789 $13,198
01 RESIDENTIAL 2800 01 001 72,781,216 $7,031,727
01 - Summary 76,044,036 $7,466,651
21 21 FIRM COMMERCIAL 2800 21 031 2,746,283 $265,462
21 FIRM COMMERCIAL 2800 21 021 41,290,248 $3,681,721
21 FIRM COMMERCIAL 2800 21 025 21,269,081 $1,580,378
21 FIRM COMMERCIAL 2800 21 011 19,348,205 $2,409,756
21 - Summary 84,653,817 $7,937,317
31 31 FIRM- INDUSTRIAL 2800 31 021 3,478,899 $292,864
31 FIRM- INDUSTRIAL 2800 31 011 188,640 $22,337
31 FIRM-INDUSTRIAL 2800 31 025 59,538,394 $4,075,388
31 FIRM- INDUSTRIAL 2800 31 031 429,345 $41,664
31 - Summary 63,635,277 $4,432,252
WA - Summary 224,333,130 $19,836,221
Overall - Summary 391,607,996 $30,501,948
H:\Revenue\Unbilled Revenue\2021 Unbilled\Electric Unbilled\May\202105 Electric Unbilled
ID PCA May 2021 Page 15 of 18
Avista 06/04/2021 15:52 PM Hourly Data
DAY  HOUR  
Element Key‐‐‐‐‐>27096 27120 27157
Short Name‐‐‐‐‐> SOLAR SEL GEN PDX MidC‐Hourly Solar Sel Power Cost
5/30/2021 H19 4 36.38 145.52
5/30/2021 H20 3 40.03 120.09
5/30/2021 H21 1 34.37 34.37
5/30/2021 H22 0 34.05 0
5/30/2021 H23 0 34.17 0
5/30/2021 H24 0 29.53 0
5/31/2021 H01 0 26.73 0
5/31/2021 H02 0 23.87 0
5/31/2021 H03 0 24.04 0
5/31/2021 H04 0 23 0
5/31/2021 H05 0 23.71 0
5/31/2021 H06 1 24.78 24.78
5/31/2021 H07 11 25.15 276.65
5/31/2021 H08 15 24.49 367.35
5/31/2021 H09 16 24.11 385.76
5/31/2021 H10 18 23.85 429.3
5/31/2021 H11 19 24.26 460.94
5/31/2021 H12 19 23.67 449.73
5/31/2021 H13 18 24.05 432.9
5/31/2021 H14 18 25.68 462.24
5/31/2021 H15 18 37.21 669.78
5/31/2021 H16 18 37.18 669.24
5/31/2021 H17 18 49.43 889.74
5/31/2021 H18 18 59.22 1065.96
5/31/2021 H19 14 65.32 914.48
5/31/2021 H20 2 88.86 177.72
5/31/2021 H21 0 58.93 0
5/31/2021 H22 0 38.83 0
5/31/2021 H23 0 50.39 0
5/31/2021 H24 0 48.84 0
5626 163,350.96$                 
H:\Reports\Power Reports\2021 Reports\May 2021\May 2021 Solar Select
ID PCA May 2021 Page 16 of 18
06/01/2021 10:23:26 AM
1Page:
202105
Date:
NUCUTDatabase:
arpptr
Power Transaction Register
Contract Month:
PURCHASEDirection:
Clearwater Paper CorporationCounterparty:
ALLTerm Type:
ALLDeal Type:
YCompany Deal Type Exclusions Maintenance Form?:
POWERProfit Center:
NEQR Variance Only?:
Beg
Day
End
Day Deal # Point Code FERC Product
Contracted
Volume
Actual
Volume PriceTrader
PURCHASES
AU
Clearwater Paper Corporation
NON-INTERCOMPANY
595,742.00 34,224.000 24,316.000NON-INTERCOMPANY TOTAL:
595,742.00 34,224.000 24,316.000
POWER
Total: 595,742.00 24,316.000 34,224.000
Total $'s
POWER
278613 AVST CORP Energy $24.500 595,742.00 34,224.000 24,316.00001 31 Johnson IT
Term
Type
Sys Opt
Strategy
595,742.00 Total: 24,316.000 34,224.000PFI
ID PCA May 2021 Page 17 of 18
06/04/2021 05:10:04 PM
1Page:
202105
Date:
NUCUTDatabase:
arpptr
Power Transaction Register
Contract Month:
ALLDirection:
Adams Nielson Solar, LLCCounterparty:
ALLTerm Type:
ALLDeal Type:
YCompany Deal Type Exclusions Maintenance Form?:
POWERProfit Center:
NEQR Variance Only?:
Beg
Day
End
Day Deal # Point Code FERC Product
Contracted
Volume
Actual
Volume PriceTrader
PURCHASES
AU
Adams Nielson Solar, LLC
NON-INTERCOMPANY
227,684.22 5,952.000 5,626.000NON-INTERCOMPANY TOTAL:
227,684.22 5,952.000 5,626.000
POWER
Total: 227,684.22 5,626.000 5,952.000
Total $'s
POWER
262025 AVST CORP Energy $40.470 227,684.22 5,952.000 5,626.00001 31 LT
Term
Type
Sys Opt
Strategy
227,684.22 Total: 5,626.000 5,952.000STRA
ID PCA May 2021 Page 18 of 18