20190815Avista to Staff 1-7.pdf

Avista Corp.
14't1 East Mission P.O. Box3727
Spokane. Washington 99220-0500
Telephone [phone]
Toll Free 800-727-9170
#tnsrr
August 14,2019
REC E IVED
:il19 AUG l5 *tl 9: 25
lI)i..i-iri ;:uiiLIC
I i lLiTIES C0lilMISSION
Idaho Public Utilities Commission
472 W. Washington St.
Boise, ID 83702-0074
Attn: Dayn Hardie
Deputy Attorney General
Re: Production Request of the Commission Staff in Case Nos. AVU-E-19-07
Dear Mr. Hardie,
Enclosed are Avista's responses to IPUC Staffs production requests in the above referenced
docket. Included in this mailing are the original and two paper copies of Avista's responses to
production requests: Staff 1-7. Also enclosed on three separate CD's are copies of Avista's
responses to the production requests. The electronic versions of the responses were emailed on
08lt4lt9.
If there are any questions regarding the enclosed information, please contact Paul Kimball at (509)
495-4584 or via e-mail at [e-mail].
Corp.
Sincerely,
I?' -u'''2'
L-Z
Paul Kimball
Manager of Compliance & Discovery
Enclosures
CC (Email):IPUC (Hanian)
Idaho Conservation League (Otto)
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION
JURISDICTION:
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AVU-E-19-07 (FCA)
IPUC
Production Request
Staff-001
DATE PREPARED: 0811612019WITNESS: N/A
RESPONDER: Tara Knox
DEPARTMENT: Regulatory Affairs
TELEPHONE: (s09) 49s-432sEMAIL: [e-mail]
Please provide the number of new customers by class per month for January 2019 through May
2019.
RESPONSE:
2019 new customers by month are defined as billed service agreements of new electric service
hookups after the 2016 test year that was the basis for rates implemented January 1,2019. Class
is identified as the FCA rate groups.
Month Non-Residential
January 2019 3,830 962
February 2019 3,972 999
March 2019 4,062 1,011
April2019 4,204 1,048
Ily4ay 2019 4,491 1,099
REQUEST:
Residential
AVISTA CORPORATION
RESPONSE TO REQUEST FOR TNFORMATTON
JURISDICTION:
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AVU-E-19-07 (FCA)
IPUC
Production Request
Staff-002
DATE PREPARED: 0811612019WITNESS: N/A
RESPONDER: Tara Knox
DEPARTMENT: Regulatory Affairs
TELEPHONE: [phone]sEMAIL: [e-mail]
REQUEST:
On page 7, lines 9-13 of the Application, Avista lists the impacts of three drivers (weather, energy
effrciency, and other) on use-per-customer and FCA Revenue for the residential group and non-
residential groups. Please provide supporting documentation for these calculations including
Excel workbooks with formulas intact and enabled.
RESPONSE:
Please see Staff PR_002 Attachment A containing the calculation of the 2018 defened revenue
driver estimates.
Electric Deferral Drivers
Abnormal weather
Energy Efficiency Measures since test year
Test Year
Residential
Usage 7,145,126,003
Customers L,258,258
Use/Cust 910
FCA Revenue
Avg Margin Rate (existing)
Weather Adj Usage
Weather Adjusted Use/Cust
FCA Margin
Energy Efficiency Cumulative Savings
Energy Efficiency Savings Use/Cust
FCA Margin
Weather + Energy Efficiency Savings
Actual Deferral
Other Customer behavior impacts
Test Year
Non-Residential
Usage
customers
Use/Cust
S 75,743,986
s 0.06514
!,074,698,733
282,902
3,799
5 60,764,992S o.osos+
2018
1,145,981,851
t,295,164
885
5 74,743,980S o.oeezg
\6,755,497
13
19,389,971
15
2078
L,061,268,573
289,677
3,664
s 59,303,139S o.osoaz
lmpact
(.32,73t,874l,
(2s)
5 (2,165,039)
5 t69,472
5 (1,995,568)
S 1,110,765
5 L,28s,4tI
2,396,175
7,755,356
640,819
lmpact
{.39,167,2841
(13s.2)
s Q,2t4,57415 3s2,s74s (1,862,000)
S gs,srg
5 3,234,925
3,270,939
L,423,452
L,847,386
s
s
s
-3%
-4%
-2%
FCA Revenue
Avg Margin Rate (existing)
Weather Adj Usage
Weather Adjusted Use/Cust
FCA Margin
Energy Efficiency Cumulative Savings
Energy Efficiency Savings Use/Cust
FCA Margin
Weather + Energy Efficiency Savings
Actual Deferral
Other Customer behavior impacts
631,451
2.2
56,879,177
196.4
s
s
s
-2%
Residential
Use/Cust FCA Revenue
Non-Residential
Use/Cust FCA Revenuerotat I trtlWeather I (13)
Energy Efficienl trtlother I s
(Sr.a1
(Sr.r1
(Sr.z1
So.s
(13s)
(1e6)
(s1.4)
(So.t1
(Sa.z1
Sr.s
(2)
63
Staff_PR_002 Attach ment A.xlsx /Electric Su m ma ry
ldaho Electric DSM Savings
Sector
Residential
Non-Residential
Total
Sector
Residential
Commercial
lndustrial
Total
Sector
Residential
Commercial
lndustrial
Total
20L6
20,500,340
Ll22OL6
L0,250,L7O
L2,306,489
3\5,637
20L7
5,686,268
2017
5,686,268
35,738,288
798,449
2018
6,907,066
tlz20t8
3,453,533
8,834,395
2,6t4,577
Total
33,O93,674
84,678,932
Total
t9,389,97L
56,879,L77
3,728,663
253 737 942
45,744,593 42,223,005 29,805,009 t17,772,606
2OLG 2Ot7 2018 Total
20,500,340 5,686,268 6,907,066 33,093,674
24,6L2,979 35,738,288 L7,568,789 79,020,055
63L;274 798,449 5,229,153 6,659,977
45,744,593 42,223,005 29,805,008 Lt7,772,606
22,872,297 42,223,005 74,902,504 79,997,906
Note l.: Residential includes Low lncome
Note 2: 2OL6 are adjusted reported gross, 2Ot7 are verified gross, 2018 are verified gross.
Sources: Avista lD 2016 DSM Annual Report, Avista lD 2017 DSM Annual Report, draft Avista
lD 2018 DSM Annual Report.
Commercial
lndustrial
% Allocated to lndustr
2016
30,73L,455
768,497
2.so%
20L7
4L,569,082
908,423
2.79%
2018
22,897,942
5,229,t53
22.84%
To allocate from Commercial (Non-Residential) to lndustrial
Staff_PR_002 Attachment A.xlsx / Elec DSM Savings
Qr6r
!1994or-
A-OO@QQ
aa
960h1\q.caiOi
-s€6\ -qr--q-€orhs-o6
€d
NT6NF€NTsooo
hF60ao:v1q-€ooNO
r
orNov')" a Qo9€o6roQ
Q-6O
I
ot90o{ro
O-AON
@€$aoNooN"-nqoFo
<NOO
aNaa
669066dOqh"eqN600€
60aa6NOOA-€A6TQQ
o
q6^1qo€oo60
ohooFOO
ao
ovo6
\q1
-A-
66<N
@- -qo9h
QN6Oq-q.160i
t$60
NN
hr9N
o6QOF
$9Or€ao@*r:.1qqi€oorQ
N
r906qdQ6€^\q1
NN6
@60NosQ6NOOvi ori
9aaN6NOO
-Qi
o\o06
N-O-9Nr
rOQNo-.1 q.qqooo6
N60V
6!od
6-qds
N
toar@oo6N"o-qqi€ooqa1i
+€ooo90h€FAt€-a-qN
oroN€+o6q qqoNo-
---q.1T a-
€@o6e-e-qnrNO-q
o€od
9qoo
6+O-690d
6:
r
rQrNOArooEoa
NNOO
@ioi9Na
d
droNr906$ooooh
660NqvrqnF600
N
-oor
9-
i€6r
rFQQ
=or-
d*o-€90ha"\qa9-O-r
qs966- -:qotoo
hNarrNr
oa\oN6- +^ ..! nr600I
66+N
6-d1 N
O-Ora"qlqoroo6A
I
ooaoroa
oo
690h6rQtA-A-rd
96$Nh+906-Od eri
9N6-o^ =- ..1 ts60aoo+N
Nd
tl *i: v1 qoroooari
6rNO\ diqa so
hrQo1\qqa-oo9
ir€Oo- e<2NN6Q
NiQ
Nhto
6NOOON
vh90
66AA
di6Q€o90<€oo
h@60
arooho
a6-OorNoNOO960qq9€
N
Nr90
NOO-NVOod60
O-O
atooo6$os"h".tq6NOO
t€90iAdA6600?600\o
-6OOi-9Odqoa
ANr
9NhO6660
areo€od"-o
6aro6r@orTQQ
or
r@€otstFoq qQhNoo
ONso
ho
I
9i
=;XX8,1 66; : }',&',dz)>
H
F _.EzAE-90lJu
E3tri"<z>>
-E,XH#,lAA
6olo$(Joaa<z))>
K
EzEts36QQr:$*<z>=
=EsES.9OHEE:TH<z>>
=-3;AX;.i56s:Hi'<z)a
=3-*XE,-i-a@:bbSogogo
<z>>
; :Ec.l9EoO* }dQQ.c r?$$9&O6qg <z))dz=
NOTNi9Oi
\dd
o@oi
qd
co
(J
OJ
oUL
OJE
(Eo
=Uo
lrJ
xI
o
E
C)(o
Noo
Id.o-sl
(!P,Jl
q
r
A-aarooqq
oFaaroo
rooqqOQ
ohoorQQ
ao
rr
r€oNNNO6
aO-
q^-q-9O-
roo6
Nda-
NN
6N
r
N
N
o@6r
6roaho
o600F9Q
oa
otoo6ro+r-oi
r9€o6- '1 qNr66
960O
F9*-
NN
o@NoefioN<O
I
I
orhNrNooN-6-
N
-6OO6-+ONrio6NOO
N
9
NT
6N
66
90N6oN
r
€h9Q--i v'L fl qN6aA
o o600h-€O
-hOOr-od
r
900
600N
N-O
N60
-Q6dN
ogF
90660
$oa
hoo
6:E:C:EOO(J
=oooooo+oaoQooSEEEEEEEe€rtEJ)
ai,ra+-o6--
o
ER=
o
E
E
oz
M
E!=
>6-
=d6Ffi *
*9
o699
-€oa
c
E
q
q
rN
hrr
ep
&
!oa!--o
=o<uN6oho-so
h69
qh"o"
F:
6rNooFToo
dNSNr6
NOON60
+ooodo60hoooaisoI
ri-oFNO
9NaoAN€Qi-FOe-a-aq€900
k666096060*rhNoFodridci3+
9iN
oao
6qo
N9€
N6N
N
96ta
aq
o9doa nqo€o9QQ6Oi-r": r:-sr9 N
ONN9
-O-
o€6r
r=6
ooo
ON
o@
96
€oda
$- .la
= 90ao-qqOiOOdra
sNd9
o-O€O-
hro6rY6ono.E N" h" - ..!i-hOO6-
390966toN
99hN
ahoo96q@oI
ooN60Oa-Noq9 h- r- r-oo@<o @+$-_i dr @-N-6
o@600s@"o"qqh-ooON
-oO-6iOrgo-
NO9
6NOr€NO9--:-qetA-
Q-Qhrooh
-9O-
vdo
d9orq9ohoor9
OO-
-AO669ho-
90NOQT
o*
oooo9QQ
oo
r-AS€do6
6iOOqN
dro-O-OroorN O9
960rrNo9
+ ci-i10"qv)N€O-Nir
NO$
h" h" o"466SN-
€NN
9rN@_F
hQi6oa
N-
o600Nhoooo 6ooh
@
I6
r€o<
@-OO
r@O-$iOr+O-oo9
$do9
-O-
o906
ooohaaoi9-r
>$ € o r=n600q--o"q.l66OOF
td9€o€
FQV
6-r€r
9€
os
hoNo96-Oh- qq
-9O
994<6NO6NOOOO-OO
Q--Fo^ .:-
oo6r9Nd9
N90r€
ot<6rqr6ho3v6-N
-oihoo'
6N€
€
o€t
Ntr
6rorno
rdo
OF€
o69
do6@69OF
999€
Nr-oo" qq6-60rNooe"o-qq
1
o^ .'! q6N60
OJTO6-rO
o€oa
$6
a
N
6
dI
Nao
N
394-
€N609-v1 -.!OhQQ
e
oz
=NAOF16600809-+_oNlshoo
hdNory€+oo
=-toNx-hooJJNooa
Nr
N c
.9
(Jo
Lo(J
Lo
P(!o
=(Jo
IJ.J
xIx
Eo
E
U(!
Noo
IE,o-rl(F(oPvl
sq
€Qo6
o9
=9dQ
Q6soaa
$9o^ .lq-o6
TY
99=a--: qqo6a
=N60ON6QooooN-SO
N
d6-Qq-iOrNo€€646d€o6rrQhoo
$6roN6VAdrioa
Y
>- O - O!=roo!66do!rhoo
&
$a69
60
N660
@^ qqtooodN
6@60
ooQoqJ-+o
I
€9AOO-rOoNo
h96Q
=-roi oo
9rhOoqro6@$as600q-
>d h 6 0!o@60Ho:6-n9tr-6oo
6to6
or
6
a
60ro9-6F
o
4
a
N
=
rNa
NF
6d
=
6aro
N
ro€
€
N
o
6N
oT€
6a
roNo
-9rOiNOr €o
€NO6e-o^qq6-oorNa
6NhrNNN9e^-!..1ror
oo6h
h90i6F
r6NQ
6NO'ea
rNo6=oaaO-AONN' o-i@90-
=60-rEm@ho:.o:6"-c.!\-hOO
6o
N
d
t:-r9 N
t-:r€N
I>- r 6 r6-6hO
=---NNhooN
E$€OOoo6605-6do
=rihcjd
NTgNN
r
a
ooa
o
'
o
.N
tr
z
o>
N
=q
E]
iiI
=oa
QOr
6669N:
96$NN€q-
qrN
F6d€
-NONA9or6r
oNoOr-
600
aoa
@r6
q
d
B
D
N
)a
€.
o
t!
EaF
€
d
d
aoaaao
o0a
>>>
o€
>
Iz889riOO
obuu
=o33JIza>
a
EUAE
E;ssoz))o
F - c-.r
_E.'iao
;:H&"dz>>
e
iaEX9,ioo
ahu@
!a:;:;Ez>>
EJ
=E;XH
-9O=H
EbP$(JZDDo
tgEH= /, U UsEEE
dz))
H
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATTON
JURISDICTION: IDAHO
CASE NO: AVU-E-19-07 (FCA)
REQUESTER: IPUCTYPE: Production Request
REQUEST NO.: Staff-003
DATE PREPARED: 0811612019WITNESS: N/A
RESPONDER: Tara Knox
DEPARTMENT: Regulatory Affairs
TELEPHONE: (s09) 49s-432sEMAIL: [e-mail]
REQUEST:
On pages 7 of its Application, the Company estimates that the Company's DSM programs reduced
residential usage by 19 million kWh in 2018 and non-residential usage by approximately 57
million kWh in 2018.
a.) Please reconcile these results to the Company's 2016,2017, and 2018 DSM reports and
any other reports that apply. Please provide supporting documentation for these
calculations including Excel workbooks with formulas intact and enabled.
b.) Please provide the Company's estimate of the total weather-normalized change in
consumption in 2018 for the same customer groups.
RESPONSE:
a.) Sta[PR_002 Attachment A (previously provided) includes a reconciliation of the annual
DSM reportsr to the 2018 estimated accumulated savings since the 2016 test year upon
which 2018 rates were established.
b.) The table below shows the change in total weather-normalized consumption from the 2016
test year to 2018 total weather normalized consumption.2
' 2016 DSM savings values reconcile to table ES-l in the 2016 DSM report,20l7 DSM savings values reconcile to
table ES- l in the 201 7 DSM report, and 201 8 DSM savings values reconcile to table I in the draft 201 8 DSM report.
2 2018 Non-Residential usage and customers include a customer that was on Schedule 25 during 2018 and
subsequently changed to Schedule 21.
Change
1,145,126,003
Use/Cust
(12,427,234)
6,993
1 3s)
2016 Test Year
AvU-E-l7-01
2018 Test Year
AVII-E-I9-04
1,163,049,327
1,295,306
898
17,923,324
37,048
(12)
1,258,258
910
1,074,698,733
282,902
3,799
1,062,271,499
289,895
3,664
Customer Billinp
Average Monttrly Use/C ust
Residential
ormalized Annual Usage
Cmtomer Billinp
Non-Residential
orn:r,lued Annual Usage
AVISTA CORPORATION
RESPONSE TO REQUEST FOR TNFORMATTON
ruRISDICTION:
CASE NO:
REQUESTER:
IDAHO
AVU-E-I9-07 (FCA)
IPUC
DATE PREPARED: 0811612019WITNESS: N/A
RESPONDER: Tara Knox
Marcus Garbarino
DEPARTMENT: Regulatory Affairs
Internal Audit
TELEPHONE: [phone]
(s}e) 49s-2s67EMAIL: [e-mail]
marcus. garbarino @avistacorp. com
TYPE Production Request
REQUEST NO.: Staff-004
REQUEST:
Please describe the process, safeguards, and intemal controls for validating new customers for
the FCA calculations.
RESPONSE:
This response is specific to the process for establishing new customer hookups as reflected in the
FCA defenal 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 internally 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, QA 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 Verification 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 INFORMATTON
JURISDICTION:
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AVU-E-19-07 (FCA)
IPUC
Production Request
Staff-OO5
DATE PREPARED: 0811612019WITNESS: N/A
RESPONDER: Marcus Garbarino
DEPARTMENT: Intemal Audit
TELEPHONE: (509) 49s-2s67
EMAIL : marcus. [e-mail]
REQUEST:
Please provide all internal audit reports and SOX reports detailing the new customer process since
2017.
RESPONSE:
There have been no intemal audit reports issued or SOX reports related specifically to the new
customer process since 2017.
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION
JURISDICTION: IDAHO
CASE NO: AVU-E-19-07 (FCA)
REQUESTER: IPUC
TYPE: Production Request
REQUEST NO.: Staff-006
DATE PREPARED: QBlt6l20I9WITNESS: N/A
RESPONDER: Tara Knox
Marcus Garbarino
DEPARTMENT: Regulatory Affairs
Intemal Audit
TELEPHONE: (509) 49s-4325
(s0e) 49s-2s67EMAIL: [e-mail]
marcus. garbarino @avi stacorp. com
REQUEST:
Please explain the process the Company uses to create the revenue reports provided in its
workpapers, including any safeguards or internal controls used to ensure the revenue report's
accuracy.
RESPONSE
The monthly revenue information included in the electronic workpapers is a summary of financial
system revenue queries. As an example, please see Staff AR_006 Attachment A containing the
system reports that were used to populate the "December Base Rate Revenue" tab in the Company
workpapers file. The financial system revenue queries report information from the RED "Revenue
Entry Device" system. RED serves as the interface between the general ledger and the customer
care and billing system (as well as any other revenue data source).
The SOX Internal Control below includes reviewing the monthly decoupling journal (includes
FCA) and support for accuracy:
ControllD ControlName Control Description
C.RATES.O7 Decoupling Deferral
Review
Monthly, the Regulatory Affairs 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.
Electric Revenue Report by Location
Accounting Period: 20'1812 State Code: ID
Data Source: Financial Reporting
Data Updated Oaily
Schec,ule
0001 $656,881.80
$5,1 93,072.63
$6,742,904.s8
$0.00
($86,734.70)
($409,78s.68)
($669,98e.16)
($221,232.13)
$496,521.12
Revenuo
$656,881.80
$0.00
$0.00
$0.00
$o.oo
$0.00
$0.00
$0.00
$0.00
$0.00
Revenue
$656,881.80
$5,193,072.63
$6,742,904.58
$0.00
$0.00
$0.00
($669,98e.1 6)
$0.00
$0.00
$0.00
Revenue
$0 00
s0.00
$0.00
. $0.00
($86,734.70)
($409,785.68)
$0.00
($221,232.13)
$496,521.12
Revenu6
$0.00
$0.00
$0.00
$0.00
$0.00
s0.00
$o.oo
$0.00
$0.00
$0.00
BASIC CHARGE ELE
KWH BLOCK 1
KWH BLOCK 2
NA
RIDER 59
RIDER 66
RIDER 72
RIDER 75
RIDER 91
RIDER 97
0.00 0.00
0.00 58,117,020.92
0.00 67,584,486.36108,980.00 0.000.00 0.000.00 0.00o.o0 o.o00.00 0.00o.oo o.oo0.00 0.00
r08.{.80s656,780.88
001 1 3 PHASE
BASIC CHARGE ELE
KVAR
KW BLOCK 2
KWH BLOCK 1
KWH BLOCK 2
NA
RIDER 66
RIDER 72
RIDER 75
RIDER 91
RIDER 93
RIDER 97
s,l,529.01
$21 1,991.45
$0.00
$1 26,459.1 5
s2,349,908.32
$738,846.1 3
$0.00
($107,4e4.65)
($187,2e0.43)
$18,464.25
$140,797.26
$0.00
($16,488.26)
$1,529.01
$211 ,991 .45
$0.00
$o.oo
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$1,529.0'l
$21 1,991.45
$0.00
$126,459.1s
$2,349.908.32
$738,846.1 3
$0.00
$0.00
($1 87,2s0.43)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
($107,494.65)
$0.00
$18,464.25
$140,797.26
$0.00
0.00
0.00
0.00
0.00
0.00
0.00
16,244.00
0.00
0.00
o.oo
0.00
0.00
0.00
0.00
0.oo
0.00
0.00
23,003,234.45
9,973,624.17
0.00
o.oo
0.00
0.00
-3,1 77.00
0.00
0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
OO12 3 PHASE 0.00
0.00
0.00
2,651,797.65
287,521.38
0.00
0.00
o.oo
0.00
0.00
0.00
o.oo
$154.61
$71 .748.76
$2,987.s3
$270,934.45
$21,299.57
$0.00
($2.027.68)
($e,582.24)
($16,697.1 2)
$1,644.9s
$1 2,s50.62
$154.61
$71,748.76
$2,987.53
$270,934.45
$21,299.57
$0.00
$0.00
$0.00
($16,697.12)
$0.00
$0.00
$0.00
BASIC CHARGE ELE
0.00
0.00
0.00
0.00
0.00
5,505.00
0.00
0.00
0.00
0.00
0.00
0.00
$154.61
$71,748.76
$0.00
$0.00
$0.00
$0.00
s0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
($2,027.68)
($9,582.24)
$0.00
$1,644.95
$12,550.62
$0.00
$0.00
$0.00
$0.00
s0.00
$0.00
$0.00
$0.00
$0.00
$0 00
90.00
$0.00
KW BLOCK 2
KWH BLOCK 1
KWH BLOCK 2
NA
RIDER 59
RIDER 66
RIDER 72
RIDER 75
RIDER 91
RIDER 97
oa't2
BASIC CHARGE ELE
KVAR
xw elocx z
KWH BLOCK 1
KWH BLOCK 2
NA
PVD 11
RIDER 66
RIDER 72
RIDER 75
RIDER 91
RIDER 97
,469.32)
$452,525.83
$1 ,212.96
$500,552.97
$3,377,080.?2
$1 98,1 95.31
$0.00
($1,s62.21)
($1 76,614.04)
($242.714.60)
s30,348.1 2
$1 84,203.1 5
$452,525.83
sl .212.96
$500,552.97
$3,377,080.22
$1 98,1 95.31
$0.00
($1 ,962.21)
$0.00
($242,71 4.60)
$0.00
s0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
($176,614.04)
$0.00
$30,348.1 2
$184,203.1s
($1,469.
0021 0.00
0.00
0.00
0,00
oo0
1,059.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
50,691,689.80
3,485,672.00
0.00
o.oo
0.00
o.o0
0.00
o.oo
0.00
$452,525.83
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
s0.00
$0.00
90.00
$0 00
$0.00
$0.00
s0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
&r21 -
BASIC CHARGE ELE
KW BLOCK 2
KWH BLOCK 1
NA
RIDER 59
RIDER 66
RIDER 72
RIDER 75
,088.
s7,409.16
$4,064.49
$44,1 29.1 5
$0.00
($457.08)
($2,1 59.42)
($2,967.57)
s370.92
$2,252.15
$7,409.16
$4,064.49
$44,1 29.1 5
$0.00
$0.00
$0.00
($2,s67.s7)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
($457.08)
($2,1 59.42)
$0.00
$370.92
$2,252.15
088.
0.00
0.00
0.00
18.00
0.00
o.oo
0.00
0.00
0.00
0.00
0.00
662,400.00
0.00
0.00
0.00
0.00
0.00
0.00
$7,409.1 6
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
0022
RIDER 91
Staff_PR_006 Attachment A.xlsx / Electric by Billing Determinant
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
s0.00
$0.00
$0.00
Page 1
,..i.ilrlsra
Schedule Revenue
$0.00
Revenue R6venue Revenue
$0.00RIDER 97 0.00
0.00
0.00
0.00
0.00
12.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0025 BASIC CI'IARGE ELE
KW BLOCK 2
KWH BLOCK 1
KWH BLOCK 2
NA
PVD 11
RIDER 66
RIDER 72
RIDER 75
RIDER 91
RIDER 97
0.00
0.00
6,000,000.00
20,332,786.S3
0.00
0.00
0.00
0.00
0.00
0.00
0.00
$0.00
$0.00
$0.00
s0.00
$0.00
$0.00
s0.00
$0.00
$0.00
$0.00
$0.00
$168,000.00
$1 26,098.82
$329,939.97
$946,694.56
s0.00
($s,e76.0s)
($85,844.88)
($80,841.6s)
s0.00
s57,668.80
$1 68,000.00
$0.00
$0.00
$0.00
$0.00
$0.00
80.00
$0.00
$0.00
$0.00
$0.00
$168,000.00
$126,098.82
$329,939.97
$946,694.56
s0.00
($s,e76,05)
$0.00
($80,841.65)
$0.00
$0.00
$0.00
$0.00
s0.00
$0.00
$0.00
$0.00
$0.00
($8s,844.88)
$0.00
$0.00
$57,668.80
$7.409.1610.s0652.400.8.00oo22
BASIC CHARGE ELE
I(/AR
KWH BLOCK 1
KWH BLOCK 2
KWH BLOCK 3
NA
RIDER 66
RIDER 72
RIDER 75
RIDER 91
RIDER 97
0.00
0.00
1,385,346.08
326,299.36
1 ,661 ,962.13
0.00
0.00
0.00
0.00
0.00
0.00
13,
s8,355.58
$0.00
$140,751 .06
(?? {(1 00
$143,925.90
$0.00
($10,99s.46)
(s17,205.40)
$1,894.82
$13,359.51
$8,355.s8
$0.00
$140,751.06
$33,'151 .99
9143,925.90
$0.00
$0.00
($17,20s.40)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
($10,9s5.46)
$0.00
$1,894.82
$13,359.s1
3,1
0031 0.00
0.00
0.00
0.00
0.00
752.00
0.00
0.00
0.00
0.00
0.00
$8,355.58
$0.00
$0,00
$0.00
$0.00
$0.00
$0.00
$0 00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
r0.@l2.00 26,332,1*.
1,686.89)
oo32 BASIC CHARGE ELE
KWH BLOCK 1
KWH BLOCK 2
KWH BLOCK 3
NA
RIDER 59
RIDER 66
RIDER 72
RIDER 75
RIDER 91
RIDER 97
$7.268.07
$10,427.77
$4,655.91
$4,648.73
s0.00
($139.4s)
($65e.00)
($1 ,031.05)
$1 13.10
$800.59
$10,427.77
$4,655.91
$4,648.73
$0.00
$0.00
$0.00
($1,031 05)
$0.00
$0.00
$0.00
0.00
0.00
0.00
0.00
658.00
0.00
0.00
0.00
0.00
0.00
0.00
s0,00
$0.00
$0.00
$0.00
$0.00
($1 39.45)
($659.00)
$0.00
$1 I3,10
$800.59
0.00
102,631 .69
45,825.43
53,680.49
0.00
0.00
0.00
0.00
0.00
0.00
0.00
s0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$7,268.07
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$7 a7
,979.13
UI 01
0041 LIGHTS
NA
RIDER 66
RIDER 72
RIDER 91
RIDER 97
0.00
2.00
0.00
0.00
0.00
0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
s0.00
$0,00
$0.00
$0.00
$0.00
$0.00
0.00
1,912.00
0.00
0.00
0.00
0.00
$367.31
$0.00
($5.s8)
(s27.83)
s24.61
$367.31
$0.00
$0.00
($27.83)
$0.00
$0.00
$0.00
$0.00
($5.e8)
$0.00
$24.61
7.7',1
0042 LIGHTS
NA
RIDER 66
RIDER 72
RIDER 91
RIDER 97
0.00
138.00
0.00
0.00
0.00
0.00
0.00
489,687.71
0.00
0.00
0.00
0.00
$205,719.60
s0.00
($1,s04.89)
($7,106.e8)
$6,317.86
$205.71 9.60
$0.00
$0.00
($7,1 06.e8)
$0.00
$0.00
s0.00
$0.00
($1,504.8e)
$0.00
$6,317.86
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
s0.00
$0.00
$0.00
$0.00
$0.00
oo44 LIGHTS
NA
RIDER 66
RIDER 72
RIDER 9.I
RIDER 97
0.00
14.00
0.00
0.00
0.00
0.00
$3,987.62
$0.00
($71.60)
($332.70)
$293.80
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
($71.60)
$0.00
$293.80
0.40)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
0.00
22,814.51
0.00
0.00
0.00
0.00
$3,987.62
$0.00
$0.00
($332.70)
$0.00
$0.00
0045 LTGHTS 0 00 0.00 $2,199.08 $0.00 $2,199.08 $0.00 S0.ooNA 5.00 29.240.67 $0.00 $0.00 $0.00 $0.00 $o.oo
R|DER 66 0.00 0.00 (s94.09) $0.00 $0.00 ($94.09) $0.00
R|DER 72 0.00 0.00 ($4s8.61) $0.00 ($438.61) $0.00 $0.00
RTDER 91 0.00 0.00 s389.15 $0.00 $0.00 $389.15 SO.O0
RIDER 97 0.00 0.00 ($14.49) $0.00 $0.00 (s14.49) $0.00@,0046 LTGHTS 0.00 0.00 $7,980.90 $0.00 $7,980.90 $0.00 $0.00NA 13.00 80,102.97 $0.00 $0.00 $0.00 $0.00 $0.00
RTDER 66 0.00 0.00 ($256.74) $0.00 $0.00 ($2s6.74) s0.00
RIDER 72 0.00 0.00 ($1,194.59) $0.00 ($1,1e4.s9) $0.00 $0.00
RTDER 9't 0.00 0.00 $1,0s5.68 $0.00 90.00 $1,055.68 $0.00
R|DER 97 0.00 0.00 ($38.s1) $0.00 $0.00 ($38.51) $0.00
Staff_PR_006 Attachment A.xlsx / Electric by Billing Determinant Page 2
s3,654.92$0.0014.00
Biling Determinant MeterQty Usage Qty Revenue Amt
i
FNed Charge
Revenue
Base Rate
Revenue
Adder S$edule
Revenue
Other
Revenue
$0.00$760.43tcJgc.3t13.0000,16 -
Scheclule
0047 LIGHTS
NA
RIDER 66
RIDER 72
RIDER 91
RIDER 97
$7,510.71
s0.00
($140.73)
($655.e7)
$581.67
$0.00
$0.00
s0.00
$0.00
$0.00
$7.510.71
$0.00
$0.00
($655.s7)
$0.00
s0.00
s0 00
80.00
($140 73)
$0.00
$581.67
s0.00
$0.00
$0.00
$0.00
$0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
46,017.73
0.00
0.00
0.00
0.00
7.73
$0
0048
0049
LIGHTS
NA
RIDER 59
RIDER 66
RIDER 72
RIDER 9,I
LIGHTS
NA
RIDER 66
RIDER 72
RIDER 91
RIDER 97
0.00
0.00
0.00
0.00
0.00
0.00
0.00
94,063.83
0.00
0.00
0.00
0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
s29.025.42
$0.00
($65.68)
($284.08)
($1,336.2s)
$1,185.62
$57,223.60
$0.00
($637.53)
($2,968.81)
$2,626.05
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$29,025.42
$0.00
$0.00
$0.00
($1,336.2s)
$0.00
$57,223.60
$0.00
$0.00
(s2,968.81)
s0.00
$0.00
$0.00
$0.00
($6s.68)
($284.08)
$0.00
$1,185.62
$0.00
$0.00
($637.s3)
$0.00
$2,626 05
RTDER 97 0.00 0.00 ($42.20) $0.00 $0.00 ($42.20) $0.00ffi
-rifinm-$fill
0.00
0.00
0.00
0.00
0.00
0.00
0.00
208,589.59
0.00
0.00
0.00
0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
s0.00
$0.00
$0.00
$0.00
$0.00
356.10.00
0058 NA
RIDER 58
0.00
0.00
0.00
0.00
$0.00
$326,146.25
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 s326
$0.00
s326,1480058 -
0095 NA 000 0.00 $0.00 $0.00$4,1 23.00 $0.00 $4,123.00
34.123.00t0.0050.00'123.0000s50099 NA 0.00 0.00 s17.422.22 $0.00 $0.00 $0.00 $17,422.22
0099O25B PVD 11
025P
0.00 0.00
0.00
0.00
0.00
30,31 1,220.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
$0.00
$14,000.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 $0.00,51
BASIC CHARGE ELE
KW BLOCK 2
KW BLOCK 3
KWH BLOCK 1
NA
PVD 11
RIDER 66
RIDER 72
RIDER 75
RIDER 91
RIDER 97
$14.000.00
$260,000.00
$29,475.00
$1,349,455.51
s0.00
($1 3,s58.00)
($s8,814.58)
($88,20s.6s)
$0.00
$61.531.78
$14,000.00
$260,000.00
$29,475.00
$1,349,455.51
$0.00
($1 3,358.00)
$0.00
($88,205.6s)
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
($98,814.s8)
$0.00
$0.00
$61,531.78
0.00
0,00
0.00
000
1.00
0.00
0.00
0.00
0.00
0.00
0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
s0.00 4.0.t0.00
30,31 1,220.00I
15,155.61
217,023.49
63,424.t8
28,482.83
5,1 55.
Page 1 of I Run Date: Jan 3.2019
Street Lights 4l - 46l-lArea LishB 47 & 49
Area Lights 48
L72.00
0.00
0.00
623,757.86 $
254,607.32 $
94,063.83 $
$ 211,rs3.80
$ 61,109.s3$ 27,689.t7172.00 972,429.0t $ 308,930.50 $ 299,952.50
Staff_PR_006 Attachment A.xlsx / Electric by Billing Determinant Page 3
AVISTA CORPORATION
RESPONSE TO REQUEST FOR INFORMATION
JURISDICTION
CASE NO:
REQUESTER:
TYPE:
REQUEST NO.:
IDAHO
AVU-E-19-07 (FCA)
IPUC
Production Request
Staff-007
DATE PREPARED: 0811612019WITNESS: N/A
RESPONDER: Marcus Garbarino
DEPARTMENT: Internal Audit
TELEPHONE: (s09) 49s-2s67
EMAIL : marcus. garbarino @avistacorp. com
REQUEST:
Please provide any and all intemal audit reports and SOX reports detailing FCA revenue
determination since 2017.
RESPONSE:
There have been no internal audit reports issued since 2017 related specifically to the revenue
process. As noted in Request No. 6, SOX Internal Control, C.RATES.07, includes reviewing the
monthly decoupling journal (including the FCA) and support for accuracy. This control was tested
by Internal Audit as of December 31, 2018 with no exceptions noted. Access to testing workpaper
will be made available onsite.