20210825Avista to Staff 1-7.pdf

AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION
i"ii"i-i
JURISDICTION
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AW-E-21-08
IPUC
Production Request
StaflOO1
DATE PREPARED:
WITNESS:
RESPONDER:
DEPARTMENT:
TELEPHONE:
:r,-., ::,:r, i;: Pii 3: ?3
0812212021
, ., 1,.:ar.-\dl:'rrr\JrIl Jr:
Joel Anderson '
Regulatory Affairs
(s09) 49s-28rt
REQUEST:
Please provide supporting documentation for the actual monthly revenue for the deferral period
from January 1,2020 through June 30, 2021.
RESPONSE:
Please see Sta[PR_001 Attachment A for the requested information. Included in the attachment
are the revenue queries from January 1,2020 through June 30, 2021. These queries are used to
prepare the monthly FCA joumals. The "Electric Revenue Report" tab includes a summary of
revenue by rate schedule. See also the "Base Rate Revenue" tabs in the 2021 Avista ID Electric
FCA workpapers included with the original filing.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR TNFORTVTATTON
ruRISDICTION
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AW-E-21-08
IPUC
Production Request
Stafl002
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (509) 49s-2811
REQUEST:
Please provide supporting docume,ntation for the actual number of kilowatt-hours ('kwh') sold as
reported in the filing for each month in the January 1,2020 through June 30, 2O2l deferral period.
RESPONSE:
Please see Staff PR_001 Attachment A for the requested information. Included in the attachment
are the revenue queries from January 1,2020 through June 30, 2021. These queries are used to
prepare the monthly FCA journals. The "Electric Revenue Report" tab includes a summary of
KWhs used by rate schedule.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR TNFORMATTON
ruRISDICTION: IDAHO
CASE NO: AW-E-21-08
REQUESTER: IPUCTYPE: Production Request
REQUEST NO.: Staft-003
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (509) 49s-281t
REQUEST:
Please provide all internal audit reports and SOX reports detailing the revenue process during the
January 1,2020 through June 30, 2021defenal period.
RESPONSE:
The SOX Internal Control below includes reviewing the monthly decoupling journal (includes
FCA) and support for accuracy:
ControllD ControlName Control Description
C.RATES.07 Decoupling Deferral
Review
Mo nth ly, the Regu latory Affa i rs Representative
responsible for the decoupling mechanism and the
Resource Accounting Manager review decoupling
calculations and the journal entry to record decoupling,
evaluating the accuracy and completeness of calculations
and tracing revenue inputs to source data. ln addition,
accumulated decoupling deferral balances are compared
to independent schedules of decoupling limits to ensure
that.recorded deferred revenue does not exceed the
amount expected to be collected within 24 months. Any
amounts in excess of these limits are not recognized for
GAAP financial reporting purposes until expected to be
collected within 24 months.
Additionally, The Resource Accounting Manager completes an IPE checklist in review of the
journal entry, which documents procedures performed for the Decoupling Deferral Revenue
Query as well as analysis spreadsheets.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMA',TION
JURISDICTION:
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AW-E-21-08
IPUC
Production Request
Stafl004
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (s09) 49s-2811
REQUEST:
Please provide all intemal audit reports and SOX reports detailing the new customer process
during the January 1,2020 through June 30, 2021 deferral period.
RESPONSE:
There have been no internal audit reports issued or SOX reports related specifically to the new
customer process for the January 1,2020 through June 30, 2021 deferral period.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR TNFORMATTON
JURISDICTION
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AW-E-21-08
IPUC
Production Request
Staff-005
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (s09) 49s-2811
REQUEST:
Please provide the number of new customers by class per month for the January I , 2020 through
June 30, 2021 deferral period.
RESPONSE:
Please see the table below for the requested information.
ID000l
ID001l
IDOOI lF
ID0012
ID002l
rD0022
rD0031
rDo032
rD000l
ID00l I
IDOOI IF
ID00l2
ID002l
D0022
ID003l
ID0032
Jan-20
2L98
394
Oct-20
4075
611
Feb-20
2542
399
Mar-20
2675
476
Apr-20
28t4
432
Mav-20
3028
472
Jun-20
3191
538
Jul-20
3449
529
Aug-20
3709
554
Sep-20
39L4
575
224 266 104385348316
10
366
5
2
7
9
455
10
L
10
13
428
9
2
10
10
6
1
5
9
6
L
6
7
3
L
6
5
3
7
5
608
11
1
13
20
s39
Ll
1
LI
L4
s26
72
7
10
13
468
LI
L
10
15
6
2
8
8
6
2
9
Nov-20
4392
677
Dec-20
4s63
709
Jan-21
4737
708
Feb-21
4504
75L
32
Mar-21
5400
82L
L
1002
t2
2
L2
42
Apr-21
s405
784
7
1065
11
1
t4
41
Mav-21
5584
798
7
1081
L2
1
t_3
42
Jun-21
5945
838
1
LLOT
13
7
15
44
808
9
7
t\
New customer data can also be found in the "Base Rate Revenue" tabs in the 2021 Avista ID
Electric FCA workpapers included with the original filing.
AYISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION
JURISDICTION: IDAHO
CASE NO: AW-E-21-08
REQUESTER: IPUCTYPE: Production Request
REQUEST NO.: Staffi006
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (s09) 495-2811
REQUEST:
On page 8, lines 1-4 of the Application, Avista estimates that for January 1,2020 through June 30,
2021 deferral period, its DSM programs reduced residential usage by approximately 23 million
kWh and non-residential usage by approximately 51 million kwh.
a. Please reconcile these results with the Company's2017 through 2020 DSM
reports and any other reports that may apply.
b. Please provide supporting documentation for these calculations.
RESPONSE:
Please see Staff PR_006 Attachment A for the requested information. DSM savings information
is found on the "Elec DSM Savings" tab.
AVISTA CORPORATION
RESPONSE TO REQIIEST FOR TNFORMATION
ruRISDICTION:
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AW-E-21-08
IPUC
Production Request
Staffi007
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: [phone]
REQUEST:
Please provide the Company's estimate of the total weather-normalized change in consumption for
the January 1,2020 through June 30, 2021 deferral period, for the same customer groups.
RESPONSE:
Please see Staff_PR_006 Attachment A for the requested information. Weather normalization
information is found on the "Elec Weather Correction" tab.