20221006Staff 47-53 to Gem State.pdf

RILEY NEWTON
DEPUTY ATTORNEY GENERAL
IDAHO PUBLIC UTILITIES COMMISSION
PO BOX 83720
BOISE, IDAHO 83720-0074
[phone]
IDAHO BAR NO. II2O2
riIL f tVEI)
irli CII -6 AH 9: jr+
tl^'t.J i.,jtli_lc
' ;1 ; I' :l:; i-:Llfo,iF.llssl0N
Street Address for Express Mail:
1 I33I W CHINDEN BLVD, BLDG 8, SUITE 2OI-A
BOISE, ID 83714
Attorney for the Commission Staff
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF GEM STATE WATER
COMPANY LLC'S APPLICATION FOR AN
ORDER AUTHORIZING AN INCREASE IN
ITS RATES AND CHARGES FOR WATER
SERVICE IN THE STATE OF IDAHO
CASE NO. GSW-W-22-01
FOURTH PRODUCTION
REQUEST OF THE
COMMISSION STAFF
TO GEM STATE WATER
COMPANY
Staff of the Idaho Public Utilities Commission, by and through its attorney of record,
Riley Newton, Deputy Attorney General, requests that Gem State Water ("Company") provide
the following documents and information as soon as possible, but no later than THURSDAY,
ocToBER 27,,2022.
This Production Request is to be considered as continuing, and the Company is requested
to provide, by way of supplementary responses, additional documents that it, or any person
acting on its behalf, may later obtain that will augment the documents or information produced.
Please provide answers to each question, supporting workpapers that provide detail or are
the source of information used in calculations, identification of the original water system,
allowing the data to be sorted accordingly. Include the name, job title, and telephone number of
FOURTH PRODUCTION REQUEST
TO GEM STATE WATER
)
)
)
)
)
)
)
)
)
1 OCTOBER 6,2022
the person preparing the documents. Please also identift the name, job title, location, and
telephone number of the record holder.
In addition to the written copies provided as response to the requests, please provide all
Excel spreadsheets and electronic files on CD with formulas intact and enabled.
REQUEST NO. 47: Please provide all supporting documentation for each of the
Company's purchases listed below. Please ensure this response includes invoices, cost benefit
analysis, alternatives proposed, j ustifi cation, and benefi ts received.
System Date Acqd Account Account Description Descrlption Amount Comment
HFM
stE
[YN
None
t2/37/2078 339
813{70re 311
o,,laolzozo 331
7OlO5l2O2O 311
9/242027 331
Other Pbnt & Misc. Equipment
Power Pumping Equipment
Trans. & oistrib. Mains & Accessories
Power PumpinS Equipment
Trans. & Distrib. Mains &Accessories
GSW
18,956
27,ffi
28,(B3
26,141
18,038
310,339
5,491
47,108
10,6ff
57,2@
25,00
9,@1
36,G8
l!2u27 311 Power Pumping Equipment
Misc Equip
Wellpump
10k depositon line extension Lynnwood
New well pump and motor
LW Mainline ReloGtion in seruice 9/2U21
DB Booster in seNice 7V21
Oiamond Bar Pump and tvlotor back up
New well pump and motor back up
(blank)
DB const work - ATS & B/U generator install
OB New Well in service 12120127
Engineering Dg Well i7
Progress Billing S1 - lnvoice ,140925
(blank)
(blank)
Continental LJtillity Solutions, lnc. (CUSI)
(blank)
GeneGtor
12.21 lT l"abor- Hardware
12.21 lT Labor- Software
11,931 investments after last rate @se, prior to acquired
19,538 post acquisition investments
10,000 post acquisition investments
9,212 post acquisition investments
12214 post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
post acquisition investments
Lrl3f/202t 310
L2l2Ol2O2t 307
PowerGeneration Equipment
wells
BCS
BR
HV
72/7/2070
6l!2018
None
None
3l7t/2020 3/()
r2l3!202o W
o8lr9l2021 310
1213!2021 3rll)
Office Fumiture and Equipment
Office Furniture and Equipment
PowerGeneration Equipment
Offlce Fumiture and Equipment
331 Trans. & Distrib. Mains & Ac€essories
n7 Wells
14342 inve5tme nts af te r last rate @se, prior to acquired
138,037 investments after last rate case, prior to acquired
REQUEST NO. 48: Following up to the Company's Response to Production Request
No. 8, please provide a list of prices for each of the chemicals and substances tested for, in your
water systems, for the 9-year well testing cycle.
REQUEST NO. 49: Please provide any analysis the Company has performed related to
the requested 10.2o/o ROE.
FOURTH PRODUCTION REQUEST
TO GEM STATE WATER 2 OCTOBER 6,2022
REQUEST NO. 50: Please provide the Moody's, Standard and Poor's, and Fitch credit
rating for Northwest Natural.
REQUEST NO. 51: Please provide a list of all debt Gem State Water has issued. Please
include the date of issue, amount, term of each loan, and interest rate.
REQUEST NO.52: Following up with Production RequestNo. l, please provide the
general ledger for 2019 and2020. Please reconcile the general ledger with the Company's
annual reports for those years.
REQUEST NO. 53: Please explain the approval procedures for acquiring planGin-
service items to ensure projects were done at least cost and provide the following information for
each of the items listed in the table below.
a. Invoices with description and purpose for each item;
b. The justification for the acquisition including a cost/benefit analysis;
c. Whether the item went out for competitive bid;
d. If went out for bid, please provide all documentation including a copy of the Request
for Proposal/Quote, all bids/quotes received, and analysis performed by the Company
to select the short list and winning bid.
FOURTH PRODUCTION REQUEST
TO GEM STATE WATER J
Item
101
Property,
Plant and
Equipment
Date Num Name Memo
Description
Dollar
Amount
a 101 0910312021 Troy
Hoffman
Purchase
Pump and
Motor
12,054.81
b 301 tzl3t/2021 LW Mainline LW
Mainline
Relocation
in service
9l22l2r
17,214.29
c 303 09/031202t Troy
Hoffman
Purchase
Land and
Land Rights
9,272.00
OCTOBER 6,2022
d 304 0910312021 Troy
Hoffman
Purchase
Pump
House, New
Roof
7,018.85
e 305 07fi31202r 10s3480 Mission
Communicati
ons LLC
Service
package
annual
renewals
1,690.20
f 307 0710812021 40925 United
Crown Pump
and Drilling
Progress
Billing #l -
Invoice
#40925
47,108.25
(,b 307 t2l3U202t DB New
Well
DB New
Well in
service
t2t20tzl
310,339.46
I 309 07t281202r 40978 United
Crown Pump
and Drilling
Booster
pump
purchase
SLE
4,484.76
j 309 t2l3y202t DB Booster DB Booster
in service
7lUzt
18,956.00
k 310 08119/2021 2591 D&J Critical
Power
26,000.00
340.1 tzt3y202t 12.21_Share
dIT
12.2r tT
Labor -
Hardware
9,607.00
m 340.2 t2l3t/2021 12.21_Share
dIT
t2.21rT
Labor -
Software
36,088.00
n 343 03115t2021 532195 USA Blue
Book
Subsite
830R/T
Locator
3,940.00
DATED at Boise, Idaho, this 6h day of Octo ber 2022
Riley Newton
Deputy Attomey General
i : umisc:prodreq/gsww22. I mrmsprod req 4
FOURTH PRODUCTTON REQUEST
TO GEM STATE WATER 4 OCTOBER 6,2022
CERTIFICATE OF SERVICE
I HEREBY CERTIFY THAT I HAVE THIS 6TH DAY OF SEPTEMBER 2022,
SERVED THE FOREGOING FOURTH PRODUCTION REQTIEST OF TIM
CoMMISSION STAFf,' TO GEM STATE WATER COMPAIYY, IN CASE NO.
GSW-W-22.0I, BY E.MAILING A COPY THEREOF TO THE FOLLOWING:
LESLIE ABRAMS.RAYNER
GENERAL MANAGER
GEM STATE WATER CO
PO BOX 3388
COEUR D'ALENE ID 83816
E-MAIL: [e-mail]
ERIC W NELSEN
ADAM RUE
NWNATURAL
250 SW TAYLOR ST
PORTLAND OR 97204
E-MAIL: [e-mail]
SECRETARY
CERTIFICATE OF SERVICE