20210818PAC to IIPA 27-28.pdf

ROCKY MOUNTAIN
BP}Y,E,A".,:'.-, ',,., iJ fii 2: id
1407 W North Temple, Suite 330
Salt Lake City, Utah 84116
RE
-. ' j'1i I
August 18,2021
Eric L. Olsen (ISB# 48l l)
ECHO TIAWK & OLSEN, PLLC
505 Pershing Ave., Ste. 100
P.O. Box 6l l9
Pocatello, Idaho 83205
[e-mail] (C)
Anthony Yankel/IIPA tonv(Evankel.net (C)
ID PAC.E.2I-07
IIPA Set 5 (27-28)
Please find enclosed Rocky Mountain Power's Responses to IIPA 5ft Set Data Requests2T-28.
Also provided are Attachments IIPA 27-1,27-3, and27-4. Provided via encryption is
Confidential Attachment IIPA 27-2. Confrdential information is provided subject to protection
under IDAPA 31.01.01.067 and 31.01.01 .233,the Idaho Public Utilities Commission's Rules of
Procedure No. 67 - Information Exempt from Public Review, and further subject to the Non-
Disclosure Agreement (NDA) executed in this proceeding.
If you have any questions, please feel free to call me at [phone]
Sincerely,
--Jsl-J. Ted Weston
Manager, Regulation
Enclosures
C.c.: Jan Noriyuki/IPUC [e-mail] (C)
Ronald L. WilliamslPllC ron@willi amsbradbury.com
Bradley G. Mullins/PIIC brmullins@,mwanalytics. com
Adam Gardner/PIIC AGardner@idahoan. corn (W)
Kyle Williams/PIIC [e-mail] (W)
Val Steiner/PIIC val. [e-mail] (W)
Ben Otto/ICL [e-mail] (C)
Randall C. Budge/Bayer randy @racineolson. com (C)
Thomas J. Budge/Bayer ti @rac ineolson. com (WXC)
Brian C. Collins/Bayer bcollins@consultbai. com (WXC)
Maurice Brubaker/Bayer mbrubaker@consultba i. co m (C)
Kevin Higgins/B ayer khieeins@.enerev strat. com (C)
Lance Kaufinan/Bayer lance@.aeeisinsieht. com (C)
James R. Smith/Bayer j im. r. smith@,ic loud. com (C)
Brad Purdy [e-mail] (C)
PAC-E-21-07 / Rocky Mountain Power
August 18,2021
IIPA Data Request 27
IIPA Data Request 27
As a follow-up to the Response to IIPA Interrogatory 2, please answer the
following:
(a) Request IIPA 1-2 sought information regarding the actual billing
determinants for each month of 2019 and2020. This request is for the general
records and information developed by the Company and does not need to be
specifically tied to the general rate case (GRC). The information is requested
on a calendar month basis as well as a billing month basis. Please provide this
monthly information from January 2014 through the most recent month
available.
(b) Requests IIPA 11B. and IIPA l-2 C. sought information regarding weather
normalized adjusfinents for each month for 2019 and2020.In the response to
IIPA Intenogatory l-1, it was demonstated that weather normalization
adjustnents were available by "Schedule". The Attachment IIPA 1-2.1 to the
company's response to IIPA Interrogatory l-2cc lists normal HDD and CDD
databy month. Additionally, Attachment IIPA l-2.3 contains monthly kWh
and $ weatherization adjustments by schedule. Tab TempMWH-2020 contains
similar adjustments for 2020. Please provide the weather normalizing
adjustnents for each "Schedule" from January 2014 through the most recent
month available (in a format similar to Attachment IIPA l-2.3) that are kept
by the Company for various purposes, in addition to a GRC.
(c) Attachment IIPA-1 lists for Schedule 07RESD000l a temperature adjustment
of 1,829,347 kwh and $132,152. Attachment IIPA I 2.1 lists HDD and CDD
days for 2019. For each schedule with kWh and $ temperature adjustments
please demonstrate by month the equations/calculations and weather data used
to produce the adjusfrnents in Attachment IIPA l-2.1.
(d) Please provide similar monthly data to that requested in subpart (c) above, for
the period January 2020 through the most recent month available. This is a
continuing request.
(e) Please provide data "normal" HDD, CDD, and AvgDB, for each month
between January 2020 through the most recent month available that are kept
by the Company for various purposes, in addition to a GRC.
Response to IIPA Data Request2T
(a) As stated previously in the Company's response to IIPA Data Request 2, the
Company has billing determinants on an annual basis. The Company has not
calculated billing determinants on a monthly basis.
PAC-E-21-07 / Rocky Mountain Power
August 18,2021
IIPA Data Request 27
(b) Please refer to Attachment IIP A 27 -l .
(c) The Company interprets the request for "adjustments in Attachment IIPA 1-
2.1" to refer to the weather adjusffnents provided in Attachment IIPA-I.
Based on the foregoing interpretation, the Company responds as follows.
Please refer to Confidential Attachment IIPA 27-2 for the equations /
calculations and weather data used to produce the monthly class level weather
adjustrnents used to calculate the adjustments provided with the Company's
response to IIPA Data Request 1, specifically Attachment IIPA-I.
Please refer to Attachment ILPA27-3 for the calculations used to spread the
monthly class level weather adjustrnents to individual rate schedules.
Please refer to Attachment IIPA 27-l for the calculation of the temperature
normalization revenue adjustnent.
(d) Please refer to the Company's response to subpart (c) above for the most
recent monthly data avallable starting in January 2020.
The Company has not performed the requested analysis for 2021
(e) Please refer to the Company's response to subpart (c) above, and specifically
Confidential Attachment IIPA 27-2 for the monthly normal heating degree
day (HDD), cooling degree day (CDD) and Average dry bulb data for January
2020 tl'rough December 2020.
Please refer to Attachment IIPA 27-4 for monthly normal HDD, CDD and
Average dry bulb data for January 2021 through December 2022.
Confidential information is provided subject to protection under IDAPA
31.01.01 .067 and31.01.01.233, the Idaho Public Utilities Commission's Rules of
Procedure No. 67 - Information Exempt from Public Review, and further subject
to the Non-Disclosure Agreement (NDA) executed in this proceeding.
Recordholder:James Zhangi Lee Elder
Sponsor:Robert Meredith
PAC-E-21-07 / Rocky Mountain Power
August 18,2021
IIPA Data Request 28
IIPA Data Request 28
As a follow-up to the Response to Interrogatory IIPA 2 - 4, please answer the
following:
(a) For each Type 1 "Normalization" kWh Adjustment listed under tabs 2019 and
2020 please list for each Schedule, the amount of the adjustment and list the
reason for each adjustnent.
(b) For each Type 1 Revenue Adjustment listed under tabs 2019 and 2020 please
list for each Schedule, the amount of the adjustrnent and list the reason for
each adjustrnent. Please reconcile these adjustnents with those listed in
subpart (a) above.
(c) For each Type 2 Revenue Adjustment listed under tabs 2019 and 2020 please
list for each Schedule, the amount of the adjustnent and list the reason for
each adjustnent.
(d) Please explain why there were "Unbilled" kWh and Revenue figures for the
Industrial class and the Contact customer only.
(e) Please explain why there were "Unbilled" kWh and Revenue figures only for
the Industrial class and the Conftact customer only in 2019 and2020.
(0 Under tab 2020 there is listed an Unbilled Adjustnent of -123,534,400 kwh
for the Industrial class and an adjustnent of +123,534,400 kWh for the
Contract customers. Please explain why these adjusftnents were necessary.
(g) Under tab2019 there is listed an Unbilled Adjustment of +113,496,399 kwh
for the Industrial class and a positive adjustment of -113,496,399 kwh for the
Contract customers. Please explain why these adjustments were necessary.
(h) Please explain how these "Unbilled" adjustments between these two years are
related to each other.
Response to IIPA Data Request 28
(a) Please refer to the Company's response to IPUC Data Request 87, Attachment
IPUC 87-1, Attachment IPUC 87-2 andthe work papers supporting direct
testimony of Company wittess, Robert M. Meredith, specifically file "ID
GRC Blocking 2020.x1sx". In those files, tabs "Table 2","Table 2Inpuf',
"Table 3", o'Table 3 Input" contain the detailed development and calculations
of all the normalizations and adjustnents by class, by schedule for 2019 and
2020. Type 1, column "Normalization" reflects the adjustnent on kilowatt-
PAC-E-21-07 / Rocky Mountain Power
August 18,2021
IIPA Data Request 28
hours (kwh) includes out of period adjustnent, and normalization of Schedule
400 (buy-through out, curtailment in). The booked kWh included some kWh
sales out of the reporting period, such as from canceled bills, override bills
and corrected bills. Making those out of period adjustrnents from the booked
kWh is necessary to obtain the actual usages for the test period. Normalization
of Schedule 400 (buy-through out, curtailment in) is necessary to obtain the
actual usages assuming the Schedule 400 customer were a full-service
customer for the period. The unbilled adjustrnent is simply to re-allocate the
total unbilled from the class to each schedule proportionally. Temperature
normally has an impact on energy usage. The temperature adjustnent is
necessary to obtain the kWh sales assuming a normal or average temperafure
year.
(b) Please refer to the Company's response to subpart (a) above. In addition to
"Normalization", "(Jnbilled", "Temperafure Adjustments", Revenue Type I
had fwo additional adjustments: "ECAM" and ooBPA". Booked revenue
included the Schedule 94 energy cost adjustrnent mechanism (ECAM)
revenues, and Schedule 34 Bonneville Power Administration (BPA) credit
revenues. Making those adjustrnents is necessary to obtain the actual base
tariff revenues for the period. Tabs "Table 2o' errtd "Table 3" in work paper
"ID GRC Blocking 2020.x1sx" show the related sources for those adjustment.
(c) Please refer to the Company's response to subpart (a) above. On Tab "Table
3" in those files, under the Type 2 revenue adjusfrnent in work paper "ID
GRC Blocking 2020.x1sx", blocking adjustnent reflects the differences
between the actual revenues from the customer billing system and the
calculated revenue based on the billing determinants developed by the
Company for the case. Actual revenues and the revenues recalculated from
billing determinants are norrnally have a very small difference. Type 2
revenue adjustnent, pricing adjusfrnent reflects the differences between the
actual revenues and the revenues with effective prices at the end of the period
if there were any price changes in base tariffor Schedule 197 in the period.
For 2019, there was a pricing adjustment because of the Schedule 197 pice
changeonJune I,2019.
(d) The Company's revenue report system, namely 305 Report, lags actual bills
by one month for Schedule 400 and Schedule 401 customers. For example, a
bill for January usage for Schedule 400 will be reported in 305 February
report. The Company uses the actual usages and bills for Schedule 400 and
Schedule 401 customers in the case. To reconcile the differences between 305
report and the actual bills for Schedule 400 and Schedule 401 customers in the
period, an unbilled adjustnent is necessary which is normally equal to the
differences between the 305 report and the actual bills for Schedule 400 and
Schedule 401 customers. Since Schedule 400 and Schedule 401 are part of the
overall lndustrial class in the 305 report, the Company makes the unbilled
PAC-E-21-07 / Rocky Mountain Power
August 18,2021
IIPA Data Request 28
adjustnent to offset the total unbilled for the rest of the industrial class. That
is why there were unbilled figures only for Industrial class and Contract
customer. The total unbilled adjustnents for Industrial class and Contract
customer offset each other.
(e) Please refer to the Company's response to subpart (d) above.
(f) Please refer to the Company's response to subpart (d) above.
(g) Please refer to the Company's response to subpart (d) above.
(h) These "Unbilled" adjustnents were the total of the monthly unbilled
adjustnent for these two years and they are not related to each other.
Recordholder: James Zhang
Sponsor:Robert Meredith