20150825UWI to Staff 81,84,85,86.pdf

(208) 343-7s00
(208) 3366912 (For)
McDevitt & Miller LLPLawyers :,,trti liil:; ?:j
420 West Bannock Street ; ..: , , .
p.O. Box ZS64-B37Oii;:-l'i ': i , r,
Boise,Idaho 83702
August 25,2015
Chas. F. McDevitt
DeanJ. floe) Miller
Celeste Ii Miller
n'1 r.,l?l.l l'.-)11
Via llaad Delivery
JeanJewell, Secretary
Idaho Public Utilities Commission
472U1. Washington St.
Boise,I&ho 83720
Re: UWI-W-15-01
Deat Ms.Jewell:
Enclosed for filing, please find an origfuul and thtee (3) copies of United Water Idaho, Inc.'s Fourth
Response to the Commission Staffs Fourth Production Request Nos. 81, 84, 85, and 86.
The Response to No. 81 is voluminous and is being provided on a disc.
Kindty retuffr a file stamped copy to me.
Very Truly Yours,
McDevitt & Millet LLP
DJM/hh
Cc United !7atet ldaho, Inc.
ORIGINAL
Dean J. Miller (lSB No. 1968)
McDEVITT & MILLER LLP
420 West Bannock Street
P.O. Box 2564.83701
Boise, lD 83702
Tel: [phone]
Fax: [phone]
ioe@mcdevitt-m iller. com
Attomey for United Water ldaho, lnc.
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
lN THE MATTER OF THE APPLICATION I Case No. UW-W-{5{1
OF UNITED WATER IDAHO INC. FOR
AUTHORITY TO INCREASE ITS RATES I UNITED WATER IDAHO INC.'S
AND CHARGES FOR WATER SERVICE I FOURTH RESPONSE TO
IN THE STATE OF IDAHO FOURTH PRODUCTION
REQUEST OF THE COMMISSION
STAFF
United Water ldaho lnc., ("United Wate/') by and through its undersigned
attorneys, hereby submits its Fourth Response to the Commission Staffs Fourth
Production Request Nos. 81, 84, 85, and 86.
DATED this LC day of August, 2015.
UNITED WATER IDAHO INC.
By:
UNITED WATER IDAHO INC.'S FOURTH RESPONSE TO FOURTH PRODUCTION REQUEST OF
THE COMMISSION STAFF.l
J. Miller{lSB No. 1968)
Attomey for United Water ldaho,
CERTIFICATE OF SERVICE
I hereby certify that on the dSytay of August, 2015,1 caused to be served, via
the method(s) indicated below, true and correct copies of the foregoing document,
upon:
Jean Jewell, Secretary
ldaho Public Utilities Commission
47 2 W est Wash in gton Street
P.O. Box 83720
Boise, lD 83720-0074
[e-mail]. id. us
Donald L. Howell, l!
Daphne Huang
Deputy Attorney General
ldaho Public Utilities Commission
P.O. Box 83720
Boise, ldaho 83720-0074
don. howell@puc. idaho.oov
daphne. huanq@puc. idaho.qov
Brad M. Purdy
Attorney at Law
2019 N. 17th Street
Boise, lD 83702
[e-mail]
Hand Delivered
U.S. Mail
Fax
Fed. Express
Email
Hand Delivered
U.S. Mail
Fax
Fed. Express
Email
Hand Delivered
U.S. Mail
Fax
Fed. Express
Email
.X-
K
l
tJ
VF
av, fhrttJ,-or -$en,\t, Loleo Jsst.
McDevrr & Mn-uri LLP'
UNITED WATER IDAHO INC.'S FOURTH RESPONSE TO FOURTH PRODUCTION REQUEST OF
THE COMiIIISSION STAFF . 2
UNITED WATER IDAHO !NC.
cAsE uw-w-15-01
FOURTH PRODUCTION REQUEST OF THE COMMISSION STAFF
Preparer/Sponsoring Witness: James Cagle
REQUEST NO. 81: Please provide copies of any reviews and reports of the Service
Company including those provided to and/or performed by other regulatory
commissions.
RESPONSE NO. 81: ln the Company's Jast rate case for United Water New York
(UWNY), the New York Public Service Commission (NYPSC) directed UWNY to
examine the fees UWNY is charged by United Water Management & Services
Company lnc. The report was filed with the NYPSC and is attached. Please note the
results of the study are specific to UWNY.
UNITED WATER IDAHO INU.
cAsE uwt-w-15-01
FOURTH PRODUCTION REQUEST OF THE COMMISSION STAFF
Preparer/Sponsoring Witness: Gary Prettyman
REQUEST NO. 84: For each and every item allocated to United Water ldaho other
than under the M&S agreement, please provide the "Corporate Assumptions" or similar
document and the methodology for allocating or assigning costs to United Water ldaho,
if not included in the Corporate Assumptions or similar document.
RESPONSE NO. 84: Please see response to Request No. 84 Attachment.
ooqqo@6664s c c cc E e9.9.9.9.2e e e e E S55E E Eo 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6 6=== 6 =S A 88ii EEEEEEEEEE -aai;##-a'#E E EEEt * eEEEEE's'sE E E ;';'EEE ;'Eo e qqqo olooooaoao o o oor= o Jo o o oo o o ooo o o o oo o o o - o oooo o oL>o o oooq, o oorDoooooo o o.9 00000 0 0o o ! o! ! o ooo o i i oa o 6 a = 6 nna6 a 6E E E EE E E EEE E,E E EE E E E N:E EEEE E Ea = Ja)f f aaa)))aaf f a= rrrff t,c c gg€E c ccccgEEEc c E.ly cEcEc c g
o o 9aaq o oooooaaoo o o dooooo o odEEEEEEE'o o o o6 6 0 000 6 0 0 00 0 0 0 u o oooo o oo o oooo o ooooooooo o o- ooooo o oq o o oo o q qqo o o o oo o q q = o oooo o oo o a6oa a 66666ao@o @ o 6 oo666 a o
c c c c c c c E c c c c c E c E E c !g c cccc c aO o o:o o o O 6 o o o o o o o o o o I 6 6 o o 6 6 iEo q o'oq o o ooo o q o oo o o o ..L o ooog o roE E E.EiE E E E E E E E E E E E E E E E'E E E E E ,Eo o o,o o o o o o o o o o o o o o o o o o o o o o oo o o oo () o ooo o o () oo o () o (r () oooo o o
@coo'o
Eoq
o
o
E
DEOooEEE'A
ooo!!
E'64.E'E966
61j6
eI
=N S!-.. EEo 8
Eo .9 h(50 o i
=f { E$!oo.=odEEzodi=ao.9-=rEt6
coeEoa)
rgigg
gigg
igi*gggEIE Et*rgSgggg r rg iE-
,tP$c E 'a
5 H iH s
g EE tH I''
I e, gH ;E j
EE;Mfraii
LooomoooEEilsE=e;
-os-H,\ € * * EEEE eeeeeeeee gflflE ; : g e 'P e'88'E * xEEEEEEzE E E 8 &e@oa @ eIgEA A e qseqEE?????!????ssgssssEF + ., 9 F F €€EE E EEEEE$EE$ + E E EEEEE E EX e .= q e a --ea O 6rrrrfft) = - o ooooo a ah- uB p t S t EEEE €8s8933333338 EiissisE E;' E ;' F E' geeg g 933333333 3 3 g g*ZEE e, EE 5 O d. ru ru uJ O OO O O Oo() () o (J oo o o o O o OoOo O o6.G O A O O A O O OO O O AOO O O O OO O O O O O OOOO O OI @ o O O o O 6100o O ooooQOAOO O O O OoAAA a O
= $ o o r N r @ @@ @ $ ttl * * I SW S $ V F r NNNN N N? F O OOO a O O OO O O O ._O o o o o o o o oo o o ooo rb o o ao o 6 o o o oooo o o
o @:@ o o o o o o 6 6 6 ao o:o o o o o o o o o o ooaoaooooqooo@c c:c c c c c c c c c c coooooooooooooo o oo o o o odda o dx x,x x x x x x x x x x xuJ UJ UJUJ lrJ o o o o o o o o o 0 0 0 u.l ut lrJuJtlJtlJ uJ tlle e es, !, 3 ee? ? 2 2 ?e ? P 2 o o oooo o oE E EE E * *** * * * ** g * q E E EEEE E E6 6 66 6 uJ uJuJuJ r.u uJ uJ [![! llJ rU uJ 6 6 6ii66 6 iiE :E.E.E.E I 999 I I I 99 I I I a E EEEE E EE E EE E 5 555 5 5 5 55 = = 5 E E EEEE E EE EEEE I gggBggEgS I I i EEEEE E i
o G oo o b bbb b b b bb b b b o o oooo G oE E EE E E EEE E E E EE E E E E E EEEE E EE s ss 9 3 tee e e e ee t t t E E EEEE e Eo oooo r rrfaaf=fa a = o ooooo o oO (9 O(9 (, () ooo o O O OO O O O O O OO(9(9 O o
o o oo o 6 00D o o o 60 0 0 0 0 0 0000 0 0o o oo o t $ti s s s $$ s v s o o oooo o o@ @ @@ @ o ooD o o o 60 6 0 0 @ @ @@@@ @ @
6A00Ooooooo6aoocgcccoooooooddoxxxxxlrJ uJ uJ ul uJEE 9 I I I 9€9 6 E E E E E:{ 2 1 1 1 A A0)5 = .E .E g .E .EE+ t E E E E E3= O E E E E EE- O ! p p E9g E E E E 5}-IY E E 'd d Eooooocgcccooooo(r(rooo
oooooooooo@@o@o
$uur!,)'YP r rHZiZ HB"r 3 fr eze**
" z, E E, Z, Z, F,=, 8, E, E, E,H, i, P, I g A g I,i, fi-
i n'o z o' (r'@ tn o E co co @ cn o o F r'-ro r: B -^< trq O m (D()(J () () O ()o () () I Y Oo-'l< Z 2to J> z ) loo o (J () (J(J () () < 5 <<oo uJ o
9 o-* u)(LUr'>>@.^=EB B'2, Hizml,lJU;H H 5 E
E
ooo
Goo
.E
coE
olooo-ooooooo* aa ao E t E E -o= O> F F E5 E0 6 6 ob gB b b bL 3- -I EH 3 3 IEE-EEE
= ci = =-a co El o 0 oE6!EEE8 dfr B E Bo >- e o qo Eo o @ -- o> E gE > > * >6 f 9; 6 6 .9 6g ggfi,FgE ro o o d! o o E o() uz <a o (-) o ()
o6,9
=N @ O O O O @ O A A A A O O A 6 ' .EEE EEE6 E I55555.E.E.E.E.E9E32 T EEEF.i EEE E q E EEEEE E E E EEgE H E. g g gg*-- 6 -6-6-6 5 O 6 66Abb 6 6 6 66oA :' n O O OOxx 'a l:+{ t! -q +! {tttt t : I itEt E E -o a EEi;x' 6 o6o 6 F O Ooooo o o o ooFo . i E E EE<d .0 } = ' = 6 ' } =, ] ] 3 = = = = 6; P ir 6 6 6 6* : ooo o o o ooooo o o o oooo -- o o o oo6.Ygs'-
; P OO0 0 0 0 !!000 0 0 ! 0000 p ! ! o o0; t EEE E E E EEEEE E E E EEEE ' E E E EE
= frf f a a-a=aaa=a=fff=f f ==fiaccEcEEgcEccEEcccccvcEccEX( - ooo o o o aoooo o o o oooo E o o o oo E
=EEEEEEEEEEEEEEEEEELEEEEEO= OO6 6 6 O OOOOO O S O 66OO r'O O'6 66 !YOOOOOTDOOOTDOOOOOOOO;OOOOO'I OOO O O q OOOOq O O O qOOO < O O O OO OE@O@@@OAA@OOO66OAOO-OOOOOh
ccce c EccEEEEccEcccYc ccEE too6 0 6 0 60000 0 0 0 6006 a 6 0 6 60 =qqq o o q qqooq o o q ooqo. = o o o oq fiE E E E E E E E E E E E E E E E EE = E E E E E =OOO O O O OOOOO O O O OOOO O O O O OO I)()oo o o o ooo()o o () o oooo z o o o oo <
P P o P ^e 5 .oEEE . Eaa E h-tsUi 6oEIE* E$ +EE **EE frE =EU*. g 3 E*
r +; E E t a.ue;:E tE E* e Efi uuE.uE I? ,* E **Es iE,
iF i F E*EgEEEEEEpIggIgE,gg
xgEEEfiiEEI,gF i gEE E gBgE{ 3 3 EgE8gEsEEE#EE
.^ogg299o56ffi66a E ii E -:E E ts'9:E'c-.'.'iE E E E E EE ; ; a H B B so(naa e eeeeeaeeeeeee pfFfFFF H fq He5 **i :ooo o o o ooooo o o o oooo o o o o o oo ; i ,4i= E = E + ,oooo o oooooaoooo9000000000 0 a .9tr6 :== x.EEE E E E E.EEEE E E E EEEE E E E.E E EE = E EA + U U U U666 6 6 0 00o00 0 0 0 0oo0 0 0 6 0 0 60 .9 d qE q r't 6 li li666 6 6 a aOOOO O a a OOO@ 6 O a a @ aa 6 : olu 66,6, 6)ooo o o o ooooo o o o oooo o o o o o oo ii g -a'6 re' -e' -r' --'- gpp p p p ppp=p p p p pppp p p p p p pp € H' o6 H E E E E
5 555 E 5 5 55555 E 5 5 5E55 5 5 5 5 5 55 F H Etr t' o o o Fg ddd d d d ooooo o o o 0655 6 6 6 6 o dd E I dE E i; d d d6'E OOO O O O OOOOO O O O OOOA A O O O O OO @ O OO O O O O OI OOOO O OO6OOOOOOOOOOFOOOOAO O O OOO O6O O: NNNN N NNNNNNNNNNNNNooooooo O I ot$ -'-FF--NOOTTNNNN(A ooo o o o ooooo o o o oooo o o o o o oo d o oo o ot oi oi o
b6a6 a ooo@@o6000@@oaooo@60 0 aoa a60 0o o o o o o o o o o o o:o o o o o o o o o o o o o o o o o o o o oO O O O O O O O @ @ O O:o q @ O O O O O O @ a q q O O O O O O: O Og g E t E g t E c c E c c c E c g c E c E c c c c c g E E E:E E Eoooo o oooooooooooooooooooo o ooo ooo ooaa a d o ooooo q o o oooa o q a q o qo o oo o o o e ox x x x x x x x x x x x x x x x x x x x x x x x x x x x x x,x x xUJ t! UJ uJ uJ uJ LrJ UJ t! UJ UJ Ul Ul UI uJ [! Ul UJ UJ UJ [! UJ tiJ [! !J U,J o U.l uJ UJ UJ UJ UJ tUor o o o o o o o o o o o o o o o o o o o o o o o o o o 2 o o o o o o og": t EEE E E E EEEEE E E E EEEE E E E E E EE E g EE E E E E Ea{ i .9.9.9.9 .i2 .2.9.9.!2.9.9.9.9.9.2.2.9.9.9.2.9.2.9.9.2 .9 u oo o o o o 6
i6J ! E E E E E E E E E E E E E E E E E E E E E E E E E E ! E E E E E E E>. O P O D E ! ! P E E E E P E E E E ! E ! E P E ! E E E 6 P ! E ! E E E
E- E E D E ! P E E ! E E P E E E E ! E E U E ! E E E E ; E ! E ! E E Edldi c E c c E E c c E E c c tr E c t E c E E c c g tr g E \ E E c E c E cE4 III ! I I:JOOO O O O OOOO O J T: I IJ I b II T I I I I-E.IY 666 E E S EEEEP E]E.E gEEg E E E g P EE E E gE E E S E Eo o o o o o o o o o 0 0:o o 0 0 0 0 0 0 0 0 0 0 () 0 ll o o o o o o oC C g g g C E E E E E E:C E E E E E C C g g C C q ' A E C E E E C Eooo o o o ooooo o o o oooo o o o o o oo o , oo o o o o o(9()o O O (9 OOoOO O,Oi O OOOO O O O O O OO O o OO O O O O O
ooo o o o ooooo o o o oooo o o o o o oo o o oo o o o o o. ooo o o o ooooo o o o oooo o o o o o oo o v oo o o o o o@@@ @ @ @ o@@oo o @ @ @@o@ @ @ @ @ @ @@ o n o@ o @ @ @ @
E
oo
i Eil
=
r,= ;,grp,['
=fffiHHfru' =;i*
g=' n a gp' H: e H= i
UNITED WATER IDAHO INC.
cAsE uwl.w.15-01
FOURTH PRODUCTION REQUEST OF THE COMMISSION STAFF
Preparer/Sponsoring Witness: Gary Prettyman
REQUEST NO. 85: If not included in the Corporate Assumptions or similar document,
please identify how the Customer Care and Billing System is allocated to United Water
ldaho and all other entities. Please provide these in Excel format, with formulas and
figures intact.
RESPONSE NO. 85: Please see response to Request No. 86.
UNITED WATER IDAHO !NC.
CASE UW-W-I5-01
FOURTH PRODUGTION REQUEST OF THE COMMISSION STAFF
Preparer/Sponsoring Witness: Gary Prettyman
REQUEST NO. 86: Please provide the following as they relate to the Customer Care &
Billing (CC&B) system:
a. The Capital Expenditure Authorization and/or other document(s) demonstrating need for
the new system and savings (including personnel savings) to be achieved.
b. Please provide a listing of each and every business unit in the Business Segments of
United Water that will be using the new CC&B system.
c. Please provide the number of customers in each business unit.
d. lf not detailed above, please list all of the water and wastewater utilities in the Regulated
Business or similar segment with the allocation to each for CC&B including those with
zero allocation. lf there is no allocation of costs from CC&B, please identify why.
e. lf not detailed above, please describe and list the public-private partnerships in the
Contract Operations or similar business segment that will be using the CC&B system
with the allocation to each for CC&B including those with no allocation. lf there is no
allocation of costs from CC&B, please identify why.
f . lf not detailed above, please describe and list the contracts in the Asset Management or
similar business segment that will be using the CC&B system with the allocation to each
for CC&B.
Please list those contracts and provide the number of customers in each of the contracts
that will be utilizing the CC&B system.
RESPONSE NO.85:
a. The customer care and billing system capital expenditures were approved in Case UWI-
W-11-02, Order No. 32443, Dated January 24, 2012. On Page 3 of the Order it states
"Finally, that the Stipulation provides that the useful life of the Company's new customer
service computer system shall be a period of 10 years commencing November 1,2011."
b.c.d.e.f. Attached is the response to Audit Request #63 from Case UWI-W-11-02 which list
all of the companies and number of customers that were the basis for allocating the
customer care and billing systems. For a current list of customers and all companies, please
see Repose to Request No. 83.
United Water ldaho
Case UW-W-15-01
Request No. 86 Attachment
Page 1 of2
United Water ldaho
Audil Reouest 63 Attachment
# of Customers
Go#Company Name #to
New Jersey Oper.48,568 7,2201
043 United Water Lambertuille 0 0.0001
o44 United Water Toms River 48.568 7.220/,
060 United Water ldaho 84,570 12.580/.
Ark 17.296 2.57o/.
004 United Water Arkansas 17.296 2.57o/o
054 United Water CT 7,155 1.0601
002 United Water PA 57.194 8.51Y,
214.783 31.94o/.
Delaware 39.287 5.84o/t
027 United Water Delaware 36.867 5.48o/t
029 United Water Bethel 2,420 0.3601
New York Operations 45,536 6.7701
053 United Water New Rochelle 31,360 4.66o/t
046 United Water Orveoo 1.670 0.25Yo
047 United Water Nichols 0 0.00%
048 South Countv Water Coro.0 0.00%
049 South Countv Sewer Coro.226 0.03%
055 Westchester 12,280 1.83o/o
Florida Operations 0 0.0001
370 UW Florida Ops LLC 0 0.00%
Add'l Jax Wastewater Factors 0 0.00%
lndiana Operations 0 0.0001
United Water West Lafayette 0 0.0001
United Water lndiana 0 0.0001
Winchester Ooerations 0 0.0001
United Water Virsinina 0 0.00o/o
061 United Water Rhode lsland 8,346 1.24o/o
93.169 13.860/o
819 UWtl Utilities Onlv 307.952 45.80%
550 United UIAA| Consol.307.952 15.80%
100 United Water New Jersev 198.876 29.58Yo
200 United Water New York 73.361 10.91%
930 UWNJ Consolidated 272.240 40.49%
720 UW Arlinoton Hills - Sewer 618 0.0901
740 United Water Great Gorqe Sel 1,456 O.22o/o
750 UW Vernon Sewaqe Trans 2 0.00%
770 United Water West Milford -Se 518 0.08o/o
780 United Water Princeton Mead<3.523 0.52o/o
700 UW Mid-Atlantic Consol.6.117 0.9101
940 Total Utilities 586,309 87.20%
500 United Properties Group 0 0.0001
401 UW Environmental Services 4,891 O.73o/.
410 UWS lnc.-Clarence Cannon 0 0.0001
411 UWS lnc.-Freeport 0 0.0001
412 UWS lnc.-Pekin 0 0.0001
417 UWS lnc.-Killinoly 0 0.0001
425 UWS lnc.-Detroit 0 0.0001
United Water ldaho
Case UW-W-15-01
Request No. 86 Attachment
Page 2 ol 2
United Water ldaho
Audit Request 63 Attachment
# of Customers
Co#Comoanv Name #o/o
430 UWS lnc.-Bio Canoe 0 0.0001
432 UWS lnc.-Pinellas Countv 0 0.0001
440 UWS lnc.-Avalon 0 0.0001
441 UWS lnc.-Bannino 0 0.0001
442 UWS lnc.-Burbank 0 0.0001
443 UWS lnc.-Burbank BOU 0 0.0001
445 UWS lnc.-West Basin 0 0.0001
447 UWS lnc.-San Antonio 0 0.0001
1118 3amo Pendleton 0 0.0001
1117 -aurel 0 0.0001
1110 Slynn County 0 0.0001
455 JWS lnc.-Kline Townshio 0 0.0001
470 /UREP-lndianapolis AWT 0 0.00%
471 A/REP-lndianapolis Collect Sy 0 0.0001
472 WREP-Garv 0 0.0001
473 WREP-Plainfield 0 0.0001
474 WREP-Cumbedand 0 0.0001
475 WREP-Boone Countv 0 0.0001
685 Jnited Water Service Milwauk,0 0.0001
688 JW Laredo LLC 0 0.0001
304 {oboken 4.979 o.740/,
303 Jnited Water Jersev Citv 36.116 5.370/,
United Water Services 45.986 6.84o/l
312 JW Ooerations Contracts 0 0.0001
314 Jnited Water Rahwav 8.145 1.2101
315 JW Manalaoan 2.881 0.4301
317 UW Kearnv 8.100 1.200/,
308 UW Oos ldaho 0 0.0001
310 UW Billinq 0 0.0001
19.126 2.840/,
313 UW Leak Guard lnc 0 0.0001
341 UW Leak Guard - Toms River 0 0.0001
343 ,w Leak Guarr, - Rehwav 0 0.0001
345 UW Leak Guard - Hoboken 0 0.0001
342 UW Leak Guard - ldaho 0 0.00%
Leakquard 0 0.00%
521 US Water Services LLC - Pare 0 0.00o/o
545 Camden Water L.L.C.20.970 3.12o/o
551 USW Hvdro Momt Serv LLC-P 0 0.00%
575 Sorinqfield Water L.L.C.0 0.00%
US Water Services 20.970 3.12o/a
687 AOS 0 0.00%
960 Other Ooerations 86,082 12.80%
990 Total United Water Resourct 672.391 100.00%