20170814AVU to Staff 1-7.pdf

AVISTA CORPORATION RESPONSE TO REQUEST FOR INFORMATION JURISDICTION: IDAHO DATE PREPARED: 08/09/2017 CASE NO: AVU-E-17-04 WITNESS: Patrick Ehrbar
REQUESTER: IPUC RESPONDER: Tara Knox TYPE: Production Request DEPARTMENT: State & Federal Regulation REQUEST NO.: Staff-002 TELEPHONE: [phone]
REQUEST: Please provide supporting documentation for the kWh sold used in the FCA calculations, including workpapers in Excel with formulas intact.
RESPONSE: Supporting documentation (in electronic format with formulas intact) was provided to
Commission Staff during their on-site audit for all calculations used in the FCA mechanism.
AVISTA CORPORATION RESPONSE TO REQUEST FOR INFORMATION JURISDICTION: IDAHO DATE PREPARED: 08/09/2017 CASE NO: AVU-E-17-04 WITNESS: Patrick Ehrbar
REQUESTER: IPUC RESPONDER: Tara Knox TYPE: Production Request DEPARTMENT: State & Federal Regulation REQUEST NO.: Staff-001 TELEPHONE: [phone]
REQUEST: Please provide supporting documentation for the average number of customers used in the FCA calculations, including workpapers in Excel with formulas intact. Please explain the calculation methodology.
RESPONSE: Supporting documentation (in electronic format with formulas intact) was provided to
Commission Staff during their on-site audit for all calculations used in the FCA mechanism. Average customers are only used in the establishment of the Allowed FCA Revenue per Customer (by Rate Group) described as Step 6 on Tariff Sheet 75A.
AVISTA CORPORATION RESPONSE TO REQUEST FOR INFORMATION JURISDICTION: IDAHO DATE PREPARED: 08/09/2017 CASE NO: AVU-E-17-04 WITNESS: Patrick Ehrbar
REQUESTER: IPUC RESPONDER: Tara Knox TYPE: Production Request DEPARTMENT: State & Federal Regulation REQUEST NO.: Staff-003 TELEPHONE: [phone]
REQUEST: Please provide the number of new customers by month for 2016 and for January through May 2017.
RESPONSE: 2016 new customers by month are defined as billed service agreements of new hookups after the
2014 test year, and were included on line 22 of pages 1 and 2 of Attachment B to the Application.
2017 new customers by month are defined as billed service agreements of new hookups after the 2015 test year as new rates were implemented January 1, 2017. The following table summarizes the number of new customers by FCA rate group for 2016 and January through May 2017.
Month Residential Non-Residential

AVISTA CORPORATION RESPONSE TO REQUEST FOR INFORMATION JURISDICTION: IDAHO DATE PREPARED: 08/09/2017 CASE NO: AVU-E-17-04 WITNESS: Patrick Ehrbar
REQUESTER: IPUC RESPONDER: Tara Knox TYPE: Production Request DEPARTMENT: State & Federal Regulation REQUEST NO.: Staff-006 TELEPHONE: [phone]
REQUEST: Please provide the Company's annual 2016 DSM energy efficiency savings (in kWh) for the Residential rate group and the Non-Residential Rate schedules (Commercial Schedules 11, 12, 21, 22, 31, and 32).
RESPONSE: Please see page 3 of Staff_PR_004 Attachment A.
AVISTA CORPORATION RESPONSE TO REQUEST FOR INFORMATION JURISDICTION: IDAHO DATE PREPARED: 08/09/2017 CASE NO: AVU-E-17-04 WITNESS: Patrick Ehrbar
REQUESTER: IPUC RESPONDER: Tara Knox TYPE: Production Request DEPARTMENT: State & Federal Regulation REQUEST NO.: Staff-005 TELEPHONE: [phone]
REQUEST: On page 8, lines 4-6 of the Application, Avista states that the “estimated FCA revenue shortfall associated with energy efficiency programmatic savings is $1.5 million residential and $1.3 million non-residential.” Please provide support for these calculations including Excel workbooks
with formulas intact. Please provide the kWh reductions upon which the above dollar savings are based. Also, please reconcile these results to the Company’s pending 2016 DSM report and any previous DSM reports that apply.

RESPONSE: Please see Staff_PR_004 Attachment A that contains the calculation of the estimated impact of the FCA surcharge drivers. The revenue impact estimation is calculated on page 1, and the DSM
programmatic usage savings from the 2014, 2015, and draft 2016 DSM annual reports are
identified on page 3. The DSM savings information on page 3 is shown in 4 sections (A, B, C and D). Section A contains the savings data from the respective DSM annual reports. This information reconciles to
the ES-1 table in the 2014 DSM annual report, the ES-2 table in the 2015 DSM annual report, and the ES-1 table in the draft 2016 DSM annual report (all shown on page 1 of the respective executive summaries). Section B estimates the segregation of the Non-Residential savings between Commercial and
Industrial customers based on the industrial allocation percentage determined in Section D. The purpose of this segregation is to exclude the Industrial savings from the FCA Non-Residential Group surcharge driver calculations (as Schedule 25 and 25P, comprised of mostly industrial customers are not included in the FCA).

Section C calculates the estimate of the cumulative savings reflected in 2016 actual usage that was not part of the 2014 test year usage used to set the FCA Base in Case No. AVU-E-15-05 (rates effective January 1, 2016). This calculation assumes that savings were achieved evenly throughout the years. Consequently, half of the 2014 annual savings are deemed to have been
reflected in the 2014 test year and half of the 2016 annual savings are deemed to have been
reflected in the 2016 billed usage. Therefore the estimated energy efficiency programmatic savings reflected in 2016 that were not included in the rate-setting test year is the sum of one-half the 2014 savings, all the 2015 savings, and one-half the 2016 savings.
AVISTA CORPORATION RESPONSE TO REQUEST FOR INFORMATION JURISDICTION: IDAHO DATE PREPARED: 08/09/2017 CASE NO: AVU-E-17-04 WITNESS: Patrick Ehrbar
REQUESTER: IPUC RESPONDER: Tara Knox TYPE: Production Request DEPARTMENT: State & Federal Regulation REQUEST NO.: Staff-004 TELEPHONE: [phone]
REQUEST: On page 7, lines 13-15 of the Application, Avista states that the “FCA revenue shortfall associated with weather was approximately $2.4 million residential and $0.3 million non-residential.” Please provide support for these calculations including Excel workbooks with formulas intact.
RESPONSE: Please see Staff_PR_004 Attachment A that contains the calculation of the estimated impact of the
FCA surcharge drivers. The revenue impact estimation is calculated on page 1, the weather related usage shortfall estimation is calculated on pages 4 and 5.
AVISTA CORPORATION RESPONSE TO REQUEST FOR INFORMATION JURISDICTION: IDAHO DATE PREPARED: 08/09/2017 CASE NO: AVU-E-17-04 WITNESS: Patrick Ehrbar
REQUESTER: IPUC RESPONDER: Tara Knox TYPE: Production Request DEPARTMENT: State & Federal Regulation REQUEST NO.: Staff-007 TELEPHONE: [phone]
REQUEST: Please provide the actual monthly energy usage from January 1, 2016 through May 31, 2016 for the Residential rate group and the Non-Residential rate schedules (Commercial Schedules 11, 12, 21, 22, 31, and 32).
RESPONSE: Actual monthly energy usage (kWhs) is included on line 2 of pages 1 and 2 of Attachment B to the
Application. The following table summarizes the monthly energy usage by FCA rate group for 2016 and January through May 2017.
Month Residential kWh Non-Residential kWh