HomeMy WebLinkAbout20210825Avista to Staff 1-7.pdf. :: i._:r I
JURISDICTION
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION . : , ' :..1 ;3 Pi1 3: [i 6
IDAHO DATE PREPARED: O8l22l2[2l *,,;i*{;iOilAW-G-2I-06 WITNESS:IPUC RESPONDER: Joel Anderson
Production Request DEPARTMENT: Regulatory AffairsStaff-001 TELEPHONE: (509) 495-2811
REQUEST:
Please provide all internal audit reports and SOX reports detailing the FCA revenue determination
during the 18-month deferral period, January 1,2020 through June 30, 2021. These include any
safeguards or internal controls used to ensure that the revenue report is accurate.
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
Monthly, the Regulatory Affairs Representative
responsible for the decoupling mechanism and the
Resou rce Accounting Ma nager 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 INFORMATTON
ruRISDICTION: IDAHO
CASE NO: AVU-G-21-06
REQUESTER: IPUCTYPE: Production Request
REQUEST NO.: Staff-002
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (509) 495-2811
REQUEST:
Please provide the number of new customers by class per month for the January I , 2020 through
June 30, 2021 defercal period.
RESPONSE:
Please see the table below for the requested information.
IDo10l
IDolll
ID0ll2
IDol0l
IDolll
IDOIl2
Jan-20
5438
45
Oct-20
8076
53
Feb-20
6535
47
Mar-20
6790
49'
Apr-20
69s6
50
May-20
7t37
51
Jun-20
73L7
54
Mar-21
9458
61
Jul-20
7533
50
Aug-20
77L4
50
Sep-20
7953
51
Nov-20
8363
53
Dqg:?o
8577
52
Jan-21
8719
54
Feb-21
86s0
54
Apr-21
9481
55
May-21
9502
60
Jun-21
10004
62
New customer data can also be found in the "Base Rate Revenue" tabs in the 2021 Avista ID
Natural Gas FCA workpapers included with the original filing.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION
ruRISDICTION:
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AW-G-21-06
IPUC
Production Request
Staff-003
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (s09) 49s-281t
REQUEST:
Please provide a description of the process, safeguards, and the intemal controls that have been
implemented for the validation of new customers for the FCA calculations.
RESPONSE:
This response is specific to the process for establishing new customer hookups as reflected in the
FCA deferral for new versus existing customers.
The process of adding customers to the Company's service territory is a standard part of the
operation of the business. The Company maintains an interactive business process manual called
the Flip Chart Knowledge Base on the internal intranet that customer service representatives use
when interacting with customers.
Documented SOX Internal Controls that address risks related to new customer hookup include the
controls listed below. The control ID is intemally developed labeling. C stands for "control" and
UCB stands for "utility customer billing". QA refers to quality assurance, and CSRs refers to
customer service representatives.
ControllD ControlName Control Description
c.ucB.01 Changes to Customer
lnformation
Monthly, Qfl procedures are performed to ensure that
CSRs are following handbook protocols when making
changes to customer accounts. The results of these QA
procedures are provided to responsible managers on a
monthly basis so that appropriate action can be taken.
c.ucB.02 New Customer Verifi cation Many times per day, customer applications are received,
and for each customer application (residential and
commercial) a red flag is automatically assigned if the
customer or service address falls within the Company's
set criteria for potential fraud. These flags can also be
manually assigned. CSRs conduct verification procedures
for all customer applications.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION
ruRISDICTION
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AVU-G-21-06
IPUC
Production Request
Staff-004
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (s09) 49s-2811
REQUEST:
Please provide all internal audit reports and SOX reports regarding the new customer process for
the 18-month deferral period that ended June 30, 2021.
RESPONSE
There have been no intemal audit reports issued or SOX reports related specifically to the new
customer process for the 18-month deferral period that ended June 30, 2021.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION
JURISDICTION:
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AW-G-21-06
IPUC
Production Request
Staft-005
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Aftairs
TELEPHONE: (s09) 495-2811
REQUEST:
Please provide the number of new natural gas customers by class per month for the lS-month
deferral period that ended June 30, 2021.
RESPONSE
Please see the table below for the requested information.
rDO101
IDolll
ID0l12
IDol0l
ID0[l
ID0112
Jan-20
5438
45
Oct-20
8075
53
Feb-20
6635
47
Mar-20
6790
49
Apr-20
59s6
50
May-20
7t37
51
Jun-20
73L7
54
Mar-2L
9458
51
Jul-20
7s33
50
Aug-20
7714
50
Sep-20
7953
51
Nov-?o
8363
53
Dec-20
8577
52
Jan-2L
8719
54
Feb-21
86s0
54
Aor-21
9481
55
Mav-21
9602
60
Jun-21
10004
62
New customer data can also be found in the'oBase Rate Revenue" tabs in the 2021 Avista ID
Natural Gas FCA workpapers included with the original filing.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION
JURISDICTION
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AVLI-G-21-06
IPUC
Production Request
Staff-006
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (509) 495-2811
REQUEST:
On page 7,line 20 through page 8, line 4 of the Application, Avista estimates that during the
1S-month deferral period ended June 30, 2021, its DSM programs reduced residential usage by
approximately 1.1 million therms and non-residential usage by approximately 200,000 therms.
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 StaflPR_006 Attachment A for the requested information. DSM savings information
is found on the "Nat Gas DSM Savings" tab.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATTON
ruRISDICTION:
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AVU-G-2l-06
IPUC
Production Request
Staff-007
DATE PREPARED: 0812212021
WITNESS:
RESPONDER: Joel Anderson
DEPARTMENT: Regulatory Affairs
TELEPHONE: (509) 495-281r
REQUEST:
Please provide an estimate of the total weather-normalized change in consumption in the l8-month
deferral period that ended June 30, 2021.
RESPONSE:
Please see Sta[PR_006 Attachment A for the requested information. Weather normalization
information is found on the "Nat Gas Weather Correction" tab.