20210119Suez to Staff 2nd Supplemental 1-2.pdf

Michael C. Creamer (lSB No.4030)
Preston N. Carter (lSB No. 8462)
Givens Pursley LLP
601 W. Bannock St.
Boise, lD 83702
Telephone: [phone]
Facsimile: (208) 388-1 300
m cc@oivenspu rslev.com
p resto nca rter@q ive n sp u rslev. co m
Attorneys for SUEZ Water ldaho lnc.
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
. :-'r - /::'i1,;.1.--Llu[;-r'
. , .''";i il ?frl*?i
I- i" ! *\
L. tlJr i:.. i-j r- ; r.l'.ir,.;;,ii;3S!ilf{
IN THE MATTER OF THE APPLICATION
OF SUEZ WATER IDAHO INC. FOR
AUTHORIry TO INCREASE ITS RATES
AND CHARGES FOR WATER SERVICE
IN THE STATE OF IDAHO
Case No. SUZ-W-20-02
SUEZ WATER IDAHO INC.'SSECOND SUPPLEMENTALRESPONSE TO FIRST
PRODUCTION REQUEST OF THE
COMMISSION STAFF
suEz water ldaho lnc., ("sUEZWatef'or "company") submits the following
second supplemental responses to the First Production Request of the Commission
Staff to SUEZ Water, dated October 7,2020.
DATED: January 19,2021
SUEZ WATER IDAHO INC.
t r- ry- 2-z-*
By:
Michael C. Creamer
Preston N. Carter
Attorneys for Ap plicant
SUEZ WATER'S SECOND SUPPLEMENTAL RESPONSE TOFIRST PRODUCTION REQUEST OF THE COMMISSION STAFF.l
'l 5492401_1.DOCX [30-209]
CERTIFICATE OF SERVICE
I certify that on January 19,2021, a true and correct copy of the foregoing was
served ,pon Lll parties of record in this proceeding via electronic mail as indicated
below:
Commission Staff
Jan Noriyuki, Commission Secretary
ldaho Public Utilities Commission
11331 W. Chinden Blvd., Bldg. 8, Ste. 201-A
Boise, lD 83714
[e-mail]
Dayn Hardie
Matt Hunter
Deputy Attomey General
ldaho Public Utilities Commission
11331 W. Chinden Blvd., Bldg. 8, Ste. 201-A
Boise, lD 83714
[e-mail]
matt. h unter@puc. idaho.qov
lntervening Parties
Ada County:
Lorna K. Jorgensen
John C. Cortabitarte
Ada County Prosecuting Attorney's Office
Civil Division
200 W. Front Street, Room 3191
Boise, lD 83702
civi lpafiles@adaweb. net
CAPAI:
Brad M. Purdy
2019 N. 17th Street
Boise, lD 83702
[e-mail]
lntervenors:
Marty Durand
Piotwrowski Durand PLLC
1020 Main Street, Suite 440
P.O. Box 2864
Boise, lD 83701
[e-mail]
SUEZWATER'S SECOND SUPPLEMENTAL RESPONSE TO
FTRST PRODUCTION REQUEST OF THE COMMISSION STAFF.2
1 5492401_1.DOCX [30-209]
Electronic Mail
Electronic Mail
Electronic Mail
Boise City:
Scott B. Muir
Deputy City AttorneY
Boise City AttorneY's Office
150 N. Capitol Blvd.
P.O. Box 500
Boise, lD 83701-0500
bo i secitvatto rnev@ citvofbo i se. o rq
Suez Water Customer GrouP:
Norman M. Semanko
Parsons Behle & Latimer
800 W. Main Street, Suite 1300
Boise, lD 83702
NSema nko@parsonsbehle. com
Boisedocket@ pa rsonsbehle. com
ldaho Fair House Council, lnc-
Ken Nagy
Attorney at Law
P.O. Box 164
Lewiston, lD 83501
[e-mail]
Micron Technology, lnc.
Austin Rueschhoff
Thorvald A. Nelson
Holland & Hart
555 17th St., Suite 3200
da ru esch hoff@ ho I la nd ha rt. com
[e-mail]
aclee@holland ha rt.com
q lqa rqa noa ma ri @ hol la nd ha rt. com
Jim Swier
Greg Hanrvood
Micron Technology, lnc.
8000 S. FederalWay
[e-mail]
[e-mail]
,? *--*- -- 4__Z:__
Preston N. Carter
SUEZ WATER'S SEGOND SUPPLEMENTAL RESPONSE TO
FIRST PRODUCTTON REQUEST OF THE COMMISSION STAFF.3
1 5492401_1.DOCX [30-209]
SUEZ WATER IDAHO INC.
GASE SUZ-W-20-02
FIRST PRODUCTION REQU EST OF THE COMMISSION STAFF
Preparer/Sponsorin g Witness :J. Cary
REOU NO. 1:
please provide copies of the monthly trial balances from January 2017 through the most
current month available. Please supplement your response when additional months
become available throughout 2020.
RESPONSE NO. 1:
please see the attachment for the monthly trial balances from 2017 through September
2020.
Update I
please see the attachment for the monthly trial balance for October 2020 and November
2020.
Update 2
please see the attachment for the monthly trial balance for December 2020-
suz-w-20-02
IPUC DR 1
Update 2
Page 1 of 1
R.pon D: TBCORIm
L.yod lO: iBCOR100 SUEZ Wat.r ldaho
Gcmr.l Lcdg.r Sydch
Period Account GAAP Trial Bllancs - Actulla LcdgerBBlnc!. Un[: mO6O
Pc.id Endlhg: Oe 3t,2OI
Pedod Begtnnlng
Be/Enca D.blb Crc.fib
Pertod
Endhry
Brlrnce
1010000(
1060000(
1070000(
1075000(
1080000(
1081000(
1090000(
1 l 10000(
1 t40000(
1 150000{
1210000(
1312000(
1350100(
1420000(
1420'tOO(
1440000(
1460500(
1460600{
1461000(
1500000(
'1 50 t000(
1502000(
'l 503000(
'1653100(
1659900(
1730000(
1830000(
1840400(
'1860800(
1860900(
'186'1800(
1862000(
1862100(
'1862300(
1862500(
1 863300(
1865000(
1865300(
1m8000r
1868 t00(
1869800(
1869900(
1871400(
1 871800(
1901000(
1901200(
'1901300(
190 t500(
1901700(
'1910100(
1910300(
1 913100(
1913200(
2010000(
2080000(
2160000(
2180000(
2180500{
2320000(
2321000(
2321',tOOt
2322000(
2323000(
2360100(
2361000(
2364100(
2365100(
2366100(
2366200(
2366300(
2366700(
2367000(
2369900(
2371100(
2420500(
2421100(
2421300(
2421500t
2422000t
2424500(
2424600t
2424700t
2424AOO(
493,280,733.49
1 5,152,366.84
11,9A7,197.54
0.00
(140,652,144.38)
1160,473.61
0.00
(44,406,546.90)
600,761.,18
(234,523.18)
7,553.83
41,000.00
0.00
4,016,268.02
(1,3(N,502.29)
(86s,718.07)
0.01
(3,686,01 1.57)
(592,450.89)
168,s09.56
292,294.U
81,632.81
46,068.05
444.01
140,337.50
3,450,513.00
1,713,270.71
(2.e0)
4,451,4a9.21
2,'to2,u2-46
0.00
2,590,459.16
977.20
'1,1 94,378.35
0-8s
97,232.73
(s59,838.18)
(32,049.10)
99.443.77
0.00
145,524.24
1,468,976.13
779,900.64
25,$3.92
108,609.41
135,621.37
(1.00)
2.@
8,970.29
91,388.20
43,471.6A
42,397.6
32.476.U
(1,261,7s0.0O)
(82,687,658.73)
(1 16,310,531.1 1)
7,497,76.79
(1,312,8ss.03)
(2,382,446.05)
(748,720.29)
(93,826.32)
0.00
259.38
(1,693,139.39)
(124,97O.U)
(3,979,087.48)
(6,476,274.00)
(4,849.,11)
(15.98)
(246.ss)
(284,783.63)
(37,391.38)
(3,714.1s1
0.04
(343,29s.70)
(227.579.09'.t
(s10,558.1 5)
(2O2,642.79)
0.00
(48,763.00)
(427,31s.4O)
(154.66)
(46,581.78)
2,633.853.37
3,418,031.01
4,499,582.51
1,113.65
59,248.46
250,549.53
23,352.12
0.00
0.00
474.00
0.00
0.00
0.00
0.00
519,349.34
0.00
s68,280.18
3,689,315.59
0.00
0.00
0.00
5,098.28
2,993.'13
0.00
0.00
0.00
416,778.15.t8,658.01
16,748.35
0.00'1psafio.22
316,597.00
0.00
1,696.48
0.00
4.712.40
0.00
32,049.10
19,025.79
0.00
13,673.20
19,555.60
10,04.1.00
497.13
398,0,15.22
43,873.79
1.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
o.oo
686,8E8.20
247,7s3.16
342.A4
441.74
1U.44
804,094.23
0.00
403,796.30
4,O94,705.7A
0.00
5.86
5.26
0.00
10,707.89
7'1,985.75
0.00
289,568.59
24,934.24
14,609.11
11,234.sO
0.00
0.00
0.00
326.36
't6,244.49
Utility Plant in Seryie
Cnstrction Csts Not Classitied
Construciion rcrk in progress
CWP - Susp€nss
Utility Accumulated Depr
Retirement wo.k in progress
A@umulated Cost of Removal
Utility A@umulEted Depr -CIAC
Utility plant acquisition adj
Amort Ulility Plant Acquis Adj
Non-Utility Property
Collec{ions
Working Funds
CustomsrAR - CC&B
AR Cesh A@d
Prcvision Uncllclble Acct (Cr)
lC Money P@l Re@ivable
Utility Monsy Pool Re@ivabte
SW lC Reeivable (n€t)
C8pital&Maint lnv Non€xempt
Small Repairs lnventory Exsmpt
Other lnventory
Chemi€l lnvsntory
Prepaid Gsneral lnsuran@
PrEpaid Expsns€sOther
Unbilled Revenu6
Prelim Suryey End lnv. Chrgs
Clearing - Capital Work Order
COR RegulatoryAssets
Defered Emply€e BEnefit$Othr
Dsfered Unamort Debl Exp
Oefered Tank Psinting Expense
Dftrd Relo€lion Exp - Approve
Def€red AFUDC Equiv Gross Up
Defered PM Costs - Approved
Defemd AFUDC Equity
Reg Defrd Tank Pniing - Amort
Dfrrd AFUDC Eq Grcssup Amort.
Detered rate charges
Def€rod State Ta Charges
Other Reg Ass€l$ Acquisitions
Oth€r RegulatoryAss6ts
D6fered Powr Costs - Pending
Cloud Compuling Arangements
Oel Federal lnc Tiles- Other
Def Stat6 ln@me Taes- Olher
D6f FIT- ROU Assets
Def SIT - ROU Assets
Def Fed NOL Ta B€neft
Det FIT-FAS109 ITC
Det FIT-F71IF109 G/U ITC
Def.SlT-FAS109 ITC
Det SIT-F71/F'109 c/U ITC
Common Stock lssued
Additional Paid-in Capital
RE - Cumulated ln@me
AOCI - Pension
AOCI. PBOP
A@ounts Payable
Accounts Payable Revsrsing
A@ounts Payable Nm Rev€rsing
AP - lnventory Acqued
AP - Lease Clearing
Property Taxes A@ed
Franchise taxes Ac@ed
Fed€ral ln@m6 Tax Acfled
State lnqoms Tu Acsued
FICA TaAerued
Federal Unemployment Tax Accr
Stats Unemploynent Til Accrued
FICA Til Accrusd - Deferral
Sales & Use Taes Accrued
Other Accrusd Taes
Accrued lnterest
Aerusd - Payrcll
Accrued lnsurane
Accrued IBNR
Accrued - Porer
A6rued - Sludge Removal
Accrued - Vaetion
Accrued - Bonus
Accrued - Employ66 RelatedAcr- Employee Relat€d Other
(57,901.69) 495,856,685..t7(2,089,s96.57) 16,480,801.28(4,924,419.42) 11,562,360.630.00 1,113.65(847,340.53) (141,440,23f.4sl.(30,602.31) 680,420.83(23,3s2jt2) o.oo(266,640.35) (44,673,187.2s)0.00 600,78,1.18(2,200.00) (236,249.18)0.00 7,553.830.00 41,000.000.00 0.00(1,393,308.51) 2,622.959.510.00 (785,152.95)(288,880.99) (1,1s8,599.06)(568,280.14 0.01(3,304.03) (0.01)(232,180.121 (824,631.01)0.00 168,509.560.00 292,294.34(2,329.83) U,401.26(983.0s) 48,07A.130.00 444.01(14,033.75) .t26,303.75
(237,179.00) 3,213.334.00(3,648.78) 2,,126,400.05(0.'t2l 18,6s4.990.00 4,468,237.56(20s,407.56) 1,897,434.90(20,490.30) 1,331,869.92(97.88) 2.906.958.28(977.15) 0.05(35,770.83) 1,160,304.000.00 0.890.00 10.t,945.13(4,647.39) (564,48s.57)0.00 0.00(9,380.89) 109,088.67(186,288.71) (186,288.71)0.00 499,197.44(1,3s2,406.221 136,125.510.00 789,941.640.00 25,961.050.00 506,624.630.00 179,495.160.00 0.00(2.00) 0.00(2,771.16t 6,199.13(117,664.56) (26,276.36)(3,0s9.55) 40,412.'13(s0,810.4s) (8,4,13.39)
(17 ,179.41) 15,297.4'l0.00 (1,261,750.00)
(8,750,879.61) (91,438,538.s4)0.00 (116,310,531.11)0.00 7,497,766.790.00 (1,312,E55.03)(1,759,239.83) (3,454,797.68)(16,748.32) (s17,715.4s)(13,948.8a (o7,432.3s1(463.8e) (22.1s)(173.69) 270.130.00 (889,045.16)(59,914.81) (184,884.85)0.00 (3,575,2S1.18)0.00 (2,381,568.22)(1,895.09) (6,744.20)(2s.67) (3s.7e)(61.08) (302.411(i14,108.41) (328,872.04)(9,459.42) (36,142.91)(26,890.82) 4.1,380.780.00 0.04(103,7'13.55) (157,440.66)(284.00) (202,928.85)(34,422.271 (530,371.31)0.oo (191,408.29)(1,768.90) (1,768.90)(39,395.00) (88,158.00)(3s,964.68) (463,280.08)(444.2Ot (272.50)(24,U2.91) (s4,680.20)su2-w-2M2
IPUC DR I Updrte 2
Atuchm6il
I of6
R.pod lD: TBCOR10o
Lryout lO: TgCORlm
SUEz Wator ldaho
Gcilr.l Lcdgcr SY*m
Period Account GAAP Trid Bal.ncs - A€tu.ls Lcdgar
Budn.!! Unft: 00060
Pedod Beglnnlng
Balrnce Debll,Crcdlts
Perlod
Endng
Eahnce
2429900(
2430'100(
2430600(
2433000(
2520000(
2520000'
2520100(
2531'100(
2531600(
2531700(
2534000(
2538000(
2539000(
25402001
2550000(
2550100(
2620000(
2631000(
27'10000(
2710000'
2710000i
2710100(
2710',100'.
27101002
271't000(
2810000(
2820300(
2820400(
2820600(
2a21100t
2A21200(
28221OO(
2825100(
2830000(
2830100(
2830200(
2830300(
2830400(
2830500(
2830600(
2830700(
2830800(
2831000(
2831'100(
2831200(
2831300(
2831400(
2835000(
2835300(
2835400(
2835500(
2835600(
2835700(
2835800(
2835900(
2836000(
2836300{
2836400(
2836500(
2840500(
2840600(
2840800(
40 10546',
4010646'.
401 t046'
4011146'
4012046',
4012146'
40'13047.
4013646',
4013746'
40140462
4014546:
4020047',
40245!.7'
4O3OO47t
4030147
5000000(
5010060(
5010060'
50'1006'12
5010062(
s010062i
5010062.
(79s,64s.91)
('14.68)
(s0.oo)
0.00
(5,122,420.A9\
603,670.39
482,s73.32
(1,997,742.OO)
(4,414,304.63)
(224,478.85\
(2,s83,209.82)
(1,4s2.02)
(s,822.93)
(209,731.76)
(523,174.00)
650,000.00
(340,852.87)
(7,411,678.96)
(122,180,256.48\
87,657.68
(1S0,836.17)
(16,1 12,936.55)
(6,007,3s9.86)
(3,383,30'1.96)
44,406,546.90
3,711.00
(6,357,266.97)
436,885.00
1,651,644.40
392,683.59
0.00
798,430.00
293,293.00
(469,398.19)
(489,2s0.00)
(24,009.00)
(24O,737.35J
14,744.00',t
23,U2.14
(830,557.10)
590,872.85
{2,O14J34.7s)
138,784.00
477,356.00
(745,356.16)
(496,854.64)
(620,690.41)
(126,183.18)
(144,12 1.00)
(171,s94.00)
290,O21.72
(213,973.19)
(826,s39.08)
(588,069.71)
(1s2.00)
560,916.84
13,523.04
(109,845.53)
(109,100.24)
3,542,443.U
1,303,188.29
50,589.61
(21,ss7 ,121.',|s\
('10,s03,199.77)
(10,184,650.33)
(2,274,48O.O7)
(94,252.41)
(28,840.30)
(35,338.51)
(81,549.73)
(100,411.04)
(1,067,145.20)
(3,362.40)
(13,370.00)
(6,670.00)
(139,4&l.oo)
84,631-00
0.00
27,OA4.75
49,283.01
6.',172.47
12,866.57
1,568.77
107,426.20
0.00
52,181.13
'10.00
0.00
0.00
0.00
0.00
208,913.00
0.00
0.00
326,429-67
7,548.00
0.00
1,389.86
4,020.00
0_00
67A.47
883,421-25
0.00
0.00
20,233-32
0.00
2,354,1 18.00
1,654,011.27
266,640.35
0.00
4,374,752.74
0.00
0.00
0.00
49,312.02
0.00
o.00
0.00
31,396.57
0.00
23,612.65
4,744.09
0.00
2,4*,193.72
0.00
1,140,783.72
0.00
0.00
643,410.9',1
'161,477.55
620,690.41
0.00
0.00
747,552.63
0.00
213,972.81
826,539.08
278,il4-71
15'l.98
0.00
0.00
4,025.04
109,100.24
0.00
0.00
't,627,444.71
0.00
0.00
0.00
0.00
0.00
0.oo
141.35
0.00
0.00
0.00
0.00
0.00
0.00
232,956.00
4,223.00
756,160.69
3,411.63
7,924-63
0.00
921.57
0.00
15,694.61
(68,894.19)
(52,181.'13)
(10.00)
(20.00)
0.00
0.00
0.00
0.00
(1,700,433.71)
0.00
0.00
(7,548.00)
(386.00)
0.00
0.00
0.00
(120,55s.64)
0.00
(2O,233.32J
0.00
0.00
('1,6s1,428.36)
(62,986.30)
12,183,219.2't)
0.00
(3,71 1.00)
0.00
(905,095.57)
(1,651,644.40)
(392,683.59)
0.00
(597,6s0.55)
(222,157.79\
(72,963.98)
0.00
(864,s40.10)
(44.68)
(50.00)
(20.00)
(s,'t22,42O.891
603,670.39
482,573-32
(1,788,829.00)
(6,1 14,738.34)
(224,478.8s)
(2,256,780.15)
(1,492.O21
(6,208.93)
(208,341.90)
(519,154.00)
650,000.00
(460,730.04)
$,s2a,2s7.71\
(122,200,489.80)
87,657.68
(170,602.85)
(17,764,364.9'1)
(3,716,228.',l6).
(3,912,509.90)
44,673,187.25
0.00
(1,982,514.19)
(468,210.57)
0.00
0.00
49,312.O2
200,779.45
71,135.21
(542,fi2.17\
(457,853.43)
(41,050.99)
(217,124.701
0.09
0.00
1,625,636.62
447,6U.66
(873,351.03)
0.00
193,7'17.0',l
(101,94s.25)
(33s,377.09)
0.00
(214,99s.03)
(162,216.231
575,958.63
'158.6'13.19
(0.38)
0.00
(309,425.00)
(0.02)
0.00
0.00
(10s,820.49)
0.00
0.00
0.00
'1,678,038.32
(21,499,75O.221
(11,477,901.88)
(10,613,6s9.29)
(2,452,346.20)
(94,396.67)
(29,839.04)
(35,197.16)
(92,444.s9)
(121,372.911
(1,163,09s.95)
(3,362.40)
(14,670.00)
(6,840.00)
93,492.00
88,854.00
0.00
30,496.38
57,207.d4
6172.47
13,744.14
1,s68.77
122,923.19
Accrued OthEr
Employee Whg-401K
Employee withholding - PAC
Employee Withholdinr Other
Advanes ior Construction
CWP nofttaxable advan@s
Tuable Advncs/Setrce Laterals
Pension Rsgulatory A@ount
Rogulatory Liab-Ta NewFedRate
Reg Liab- NewFedRatezol Sportion
PBOP Liability - Trustee
Other Deferred Credits
A@rued SE LTIP
DefRegLiab F71lF109Fed:lTC
Defened ITC
Defered State ITC ldaho
lnjuries and Damages Ressrye
P€nsion Acfled
Contibution in Aid o, Cnstrct
CWIP nofttilable CIAC
ln Serui@ nofttaxable CIAC
Taable CIAC - SErv LateEls
CWIP taxable CL{C
ln Seryice taxable CIAC
Accumulated Amortization CIAC
Def. FIT- Ac@lerated Amort
Det FIT-MACRS
Def SIT-MACRS
Def. FIT- OCI Pension/PBOP
Del FIT Benefit on DSIT
Dof SIT - Utility
Dsf FIT- COR
Def SIT- COR
Det FIT-Other
Def. FIT-Tank Painling
Def. FIT-Rate Eipenses
Del FIT-Defered Charges
Def, F|T-Relo@tion Expense
D€l FIT-M-S Fees
Def. F|T-Pensions
Det FIT-PEBOP
Def. FIT-Cosl of Removal
Def . FIT-Uncolleclibles
Oel FlT-lniuries and Damages
Def. FIT - AFUDC Equity
Def. FIT - AFUDC Equity GU
Def. FIT - AFUDC Equity GU'TRF
Det SIT- Other
Del SIT - Tank Painting
Def. SIT-Pensions
Def. SIT-Post Rebmnt Benefits
Def. SIT-AFUDC Equity
Del SIT-Excess Depreiation
Del SIT- Cost of R€moval
D€f. SIT- Reloetion
Del SIT- OCI PensiorVPBOP
Def. SIT -Shared Serui@s Fees
Det SIT - AFUOC Equity GU
Def. SIT - AFUDC Equity GU-TRF
Def FIT- New Federal Tu Rate
Def FIT-New Federal TuRate GU
Def FIT-Ta Reiorm for GU2018
Meter SaleResidential consumP
Meter SalFResidenlial facili
Meter Salecommercial @nsumP
Meter Salecommercial facility
Meter Sal+Public auth consump
Meter Salepublic auth fac
Surcharges
Meter Sale-Const Mtr-ConsumP
Meter Sale4onst Mtr-Fac Chgs
Private Fire protection facili
Public Fire Protection facilit
Mis@lhneous seryie revenue
Tum on fees
Reg Unbill consumPtion revenue
Reg Unbill facility charge rev
Payroll Clearing
Supv Lbr€OS ops SUP & Eng
Supv Lbr-SOS OPs Lbr & ExP
supv Lbr-sos Maint wls&spr
Supv Lbr-PumP OPs SUP & Eng
Supv Lbr-PumP OPs PM Prd Lbr
Supv Lbr-PumP OPs Lbr & ExP
(17,041.99)
0.00
0.00
(23,642.141
0.00
(143,188.19)
0.00
(138,784.00)
(283,638.99)
0.00
0.00
0.00
(88,811.85)
(18,095.23)
0.00
(131,408.53)
o.o0
0.00
0.00
0.00
(560,916.84)
(13,523.04)
0.00
0.00
(3,il2,443.34t
(1,303,188.29)
0.oo
(942,629.04
(974,702.111
(429,008.96)
(177,866.1 3)
(144.26)
(9s8.74)
0.00
(10,894.86)
(20,961.87)
(9s,950.7s)
0.00
(1,300.00)
(170.oo)
0.00
0.00
(7s6,160.69)
0.00
0.00
0.00
0.00
0.00
(1s7.62)
suz-w-2m2
IPUC DR I UPdate 2
Abchmod2of6
R.poil lD: TgCORtoo
L.yod lD: TBCORIoO SUEZ Water ldehoG.rcr.l Hg.r Syd6m
Bu.lna.r Unfr: 0e6O
P.rbd Edlng: D* 31, Im
Pedod Account GAAP Trirl Bal.ncs - Acturlr Ledger
Partod Baglnnlng
BaLnce Debtta Crc.ll's
Pertod
ENhtg
Bat.nc6
Supv Lbr-Pump Maint Sup&Eng
Supv Lbr-Pump Maint Equip
Supv Lbr-Wb Tmt Ops Sup&Eng
Supv LbtrWf Tmt Ops Lbr&Exp
Supv LbFWtr Tmt Ops Misc Exp
Supv Lbr-Wtr Tmt Maint Sup&Eng
Supv LbrT&D Ops Sup&Eng
Supv Lbr-T&D Maint Sup &Eng
Supv Lbr-T&D Maint - Main
Supv Lbr-T&D Maint - Seilices
Supv Lbr4ustAet SuprvEn
Supv Lbr4ust Acct Mtr Rdng
Supv Lbr-Cust Acct Rcrds&Col
Supv Lbr-AEG Ops Salaries
Drct LbFSOS Ops Sup & Eng
Drct Lbr-SOS Maint Strctrs
Orcl LbtsPump Ops PM Prd Lbr
Drcl LbFPump Ops Lbr & Exp
Drct Lbr-Pump Maint Strctrs
Drcl Lbr-Pump Maint Ptr Prd
Drcl Lbr-Pump Maint Equip
Drct LbFWk Tmt Ops Lbr&Exp
Drct Lbr-Wtr Tmt Ops Misc Exp
Drct Lbr-Wf Tmt Maint Strct
Drct LbFWtr Tmt Maint Equip
Drct Lbr-T&D Ops Line Ex
Drct Lbr-T&D OpE Meter Exp
Drcl LbFT&D Ops Cust insu
Drc{ Lbr-T&O Ops Misc Ex
Drct Lbr-T&D Maint - Main
Orct Lbr-T&D Maint - Sorvices
Drct Lbr-T&D Maint - Meters
Drct Lbr-T&D Maint - Hydrsnts
Drcl Lbr-Cust Accl Suprvsn
Drct Lbroust A@t t\ttr Rdng
Drct Lbr-Cust Accl Rcrds&Coll
Drct LbFA&G Ops Salaries
Orcl LbFA&G Maint Plnt
S L T-SOS Ops Sup & Eng
D L T-SOS Op6 Sup & Eng
S L T out-Pump Ops Lbr & Exp
S L T out-T&D Ops Sup&Eng
S L T ouloust Acc{ Suprvsn
S L T out-A&G Ops Salaries
D L T out-T&D Ops Mbc Ex
D L T out-Cust Acct Rcrds&Coll
D L T out-A&c Ops Salaries
Material-Sos Ops Sup & Eng
Material-Sos Maint Shctrs
Materisl-Pump Ops Lbr & Exp
Material-Pump Msint Strctrs
Mat€rial-Pump Maint B{r Prd
MaterialPump Maint Eq
Material-Wtr Tmt Ops Lbr&Exp
Material-Wtr Tmt Maint Strct
Matdial-Wr Tmt Maint Equip
Material-T&D Ops Line Ex
Material-T&D Ops Meter Exp
Matqial-T&D Ops Misc Ex
Material-T&D Maint Rsrvre&Stn
Msterisl-T&D Maint - Main
MaterialT&D Maint - Soryi@s
MatryialT&D Maint - Metets
Matorial-T&D Maint - HydEnts
Materialcust Acct Mtr Rdng
Materislcust Acct Rcrds&Coll
Rent-SOS Ops Misc
RenrSOS Ops
Ront-Pump Ops Lbr & Exp
Rent-Pump Ops Misc Exp
Rent-A&G Ops O,li Suppt&Exp
Rent-A&G Ops
Out SerysSOS Ops Lbr & Exp
Out ServeSOS Ops Misc
Out SeryePump Ops Lbr & Exp
Out Servs-Pump Maint Sfc'tss
Out Serys-Pump Maint PM Prd
Out SerysPump Msint Eq
Out Seru$Wtr Tmt Lab Testing
Oul Serus-Wtr Tmt Ops Lbr&Exp
Out Ssrvs-\iw Tmt Op6 Misc Exp
Out Servs-Wt Tmt Maint Strct
Out Seru$Wtr Tmt Maint Equip
50'10063(
5010063i
5010064(
501004n,
5010064:
5010065(
5010066(
5010067(
50't0067I
s010067!
5010090'
s010090:
5010090:
s010092(
5010560(
5010561'
5010562'
50105622
50'10563',
s010563'
5010563:
5010564i
5010564i
5010565'
s010565'
5010566:
5010566:
501056&
s0 t0566!
5010567:
5010567!
5010567(
5010567',i
s010590'
5010590i
5010590:
5010592(
s0'r0593i
s01 1060(
501 1560(
5012062.
5012066(
5012090,
5012092(
5012566!
5012590:
s012592(
5030060(
5030061,
5030062/
5030003'
5030063i
5030063:
5030064i
503006s'
5030065i
5030066:
5030066:
5030066:
5030067:
s030067:
5030067t
5030067(
5030067i
5030090i
5030090:
5030093,
5031060t
5031 0602
50310622
5031062(
5031092,
5031093',
s040060,
5040060i
s040062r
5040063',
5040063i
5040063:
5040063t
50400&ti
s0400&r:
5il0065',
5040065i
(520.89)
1,978.08
(885.s2)
63,417.20
654.97
1,116-42
10,522.37
(286.49)
126.n
40,866.92
52,A27.98
388.2 r
162,068.9s
2,5U,437.51
2,108.00
7,210-61
130.92
804,044-041.7 .79
100.41
25,97,1.O5
485,853.s0.1.267-20
2,O55.24
5,613.67
46,210.27
29,723.OO
4e5.12
60,724.93
37,020-13
810,812.0 1
4,742.53
7,507..11
1,844.55
244,357-92
674,4A4.31
1,109,059.45
385.90
12,064.19
596.13
154.27
(539.s3)
9.56
(1,394,682.28)
(60,724.93)
(18.21'.t
(1,034,302.46)
4,467.U
'14,699.60
2't,463.A9
1,277.99
9,14.01
'16,731.04
22,547.10
8,435.31
23,635.32
371.48
25.52
25.004.50
28.50
20,661.6'l
36,956.42
0-00
10,760.(X
117.O3
1,202.28
12,282.6
72.1A
2,3173A
56.16
1,200.00
6,378.01
1,910.59.l,459-12
0.00
13,75 1.88
15,796.09
s5,805.3.t
3s,416.76
101,902.10
5,008.57
21,*2.47
8,869.14
24,291.82
810.94
0.00
4,673.89
0.00
0.00
2,037.94
0.00
0.00
6,2s0.99
7,673.88
0.00
'15,516.44
303,904.47
0.00
0.00
0.00
86,988.90
0.00
0.00
0.00
31,918.36
0.00
0.00
0.00
0.00
457.57
0.00
6,O20.47
0.00
100,599.33
0.00
0.00
0.00
24,86,1.91
70,184.06
142,A32.A1
0.00,11702A
1,455.71
0.00
0.00
0.00
3,190.90
0.00
0.00
8,463.54
0.00
0.00
'1,115.83
0.00
0.00
586.58
3,386.44
0.00
1,429.26
0.00
0.00
1,716.03
0.00
'1,789.77
2,577.80
29.60
0.00
0.00
0.00
927.10
0.00
0.00
0.00
0.00
507.25
173.69
0.00
90.24
722.50
138.00
0.00
5,256.20
2,430.00
't,460.06
2,520-82
0.00
0.00
0.00
(312.9s)
0.00
(s80.2s)
0.00
0.oo
0.00
0.00
0.00
(8e3.33)
0.00
('137.75)
0.00
(3,s74.4e)
0.00
0.00
0.00
(2,318.77)
0.00
0.00
0.00
(6s4.17)
0.00
0.00
0.00
0.00
0.00
0.00
(418.40)
0.00
(2,179.41')
0.00
0.00
(6s4.s2)
(823.04)
(173.6s)
(14,006.01)
0.00
0.00
0.00
(250.86)
(917.07)
(22.O41
(148,76',t.77\
(5,602.04
(1,1.53)
(129,493.90)
(3,eoe.6s)
0.00
0.00
0.00
0.00
0.00
(60.21)
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.04)
0.00
0.00
0.00
0.00
(314.82)
0.00
0.00
0.00
0.00
(2,622.O81
0.00
0.00
0.00
0.00
0.00
(826.471
0.00
(52o.E9)
2,476.O3
(88s.s2)
67,510.84
654.97
1,116.42
12,560.31
(286.49)
126.77
46,224.5A
60,50,1.86
250.$
177,585.39
2,4O4,767.49
2,'108.00
7,2.10.61
130.92
444,714.'t7
1,796.79
100.41
25,971-05
517,1 17.69
'1, 7.20
2,055.24
5,613.67
46,240.27
30,180.57
445.12
66,327.00
37,020.13
909,231.93
8,742.53
7,507.11
1,190.03
268,396.79
744,494-72
1,237,886.2s
385.90
13,2U.47
2,051.U
(e6.5s)
(1,457.00)
(12.48].
(1,540,2s3.15)
(66,327.00)
(32.74)
('1,155,332.82)
557.39
't4,699.60
22,579.72
1,277.99
9,14.01
'17,317.62
25,A73.33
8,435.31
25,064.58
371.4A
25.52
26.720.53
28.50
22,45't.38
39,534.22
29.60
'10,750.04
1'.t7.O3
1,202.28
1 3,158.52
72.1A
2,31734
56.16
1,200.00
6,570.14
2,08d.28
,t,159-,12
90.24
14,4743A
13,312.01
55,805.34
40.672.96
104,332.10
6,468.63
24,O43.29
8,U2-67
24,291.82
suz-w-2042
IPUC OR 1 Updete 2
Attachm6fr3of6
o-oo
R.poil lD: TBCORIoo
L.yod lO: TBCORIm
SUEZ water ldaho
&mi.l Ldgc. SYd.m
Period Account GAAP Trill Balance - Actu.l! Ledger
Burincls unfr: 00060
Pldod Endlng: Dcc 31, 2020
Period
Perlod Beglnnlng
Batance Debtrs
Endlng
Crcd1{5 Batance
Out Serus-T&D Ops Lino Ex
Out Serys-T&D Ops Misc Ex
Out Serys-T&D Maint Rsrvrs&Stn
Out Serus-T&D Maint - Main
Out Serv$T&D Maint - Seryices
Out Serys-Cust A@t Mt Rdng
Out Servs-Custr Acct Rcrds&Col
Out S€rvs-CustAcct Misc ExP
Out SerusA&G OPs OrSuPPl&ExP
Out Serys-A&G Ops OfEuPPl&ExP
Out Servs-A&G Ops
Out Serv$A&G Maint Plnt
Print & Postag&Cust A@t Rcrd
Prchsd VvtrSOS Ops
Prchsd Ptr-Pump OPs Fuel PM
Prchsd Ptr-Wtr Tmt OPs Misc
Prchsd Ptr-T&D Ops Misc Ex
Utiliti6sPump OPs hm Prd Lbr
Utilitie$Pump Ops Misc ExP
UtilitielPump Maint Eq
Utilitiegwtr Tmt Maint Strct
UtilitieeT&D Ops Misc ExP
UtilitieeT&D Maint - Main
UtilitielA&G Ops Ofi SUPPI
UtililieeA&G Misc
Sludge Dspsl-Pump Ops Misc ExP
Sludge Dspsl-wtr Tmt OPs Lbr
Sludge Dspsl-WtrTmt Ops Misc
Chm€ls-SOS Maint Wls&SPr
ChmellPump Ops Misc ExP
Chm€ls-WtrTmtOps SUP&Eng
Chm€ls-Wtr Tmt OPs SUP&Eng
Chmcalewtr Tmt Ops Lbr&ExP
Chm@l&Wb Tmt Maint EquiP
Tmsprt Csi.ES
Tmsprt Cst-SOS Ops Sup & Eng
Tmsprt Cst-SOS OPs Lbr & ExP
Tmsprt Cst-SOS Maint Strctrs
Tmsprt Cst-SOS Maint Wls&SPr
Tmsprt Cat-Pump OPs SUP & Eng
Tmsprt Cst-Pump OPs PM Prd L
Tmsprt Cst-Pump Ops Lbr & ExP
Tmsprl Cst-Pump Maint Strctrs
Tmsprt Cst-PumP Maint Ptr Prd
Tmsprt Cst-Pump Maint Eq
Tmsprt Cst-Wtr Tmt OPs Lbr&Ex
Tmsprt Cst-Wt Tmt OPs Misc
Tmsprl Cst-Wtr Tmt Maint SPry
Tmsprt Cst-Wtr Tmt Maint Skc
Tmsprt Cst-Wt Tmt Maint Eq
Tmsprt Cst-T&D Ops Sup&Eng
Tmsprt Cst-T&D OPs Une Ex
Tmsprt CsiT&D Ops Meter ExP
Tmsprt Cst-T&D OPs Cust lnst
Tmsprt Cst-T&D Maint - Main
Tmsprt Cst-T&D Maint-Seryices
Tmsprt Cst-T&D Maint - Meters
Tmsprt CshT&D Maif,t-HydranG
Tmsprt Cst-Cust Acct Suprusn
Tmsprt Cst-Cust Acct Mtr Rdng
Tmsprt Cal-Cust Aet Rcrds&Co
Tmsprt Cst-A&G Salaries
Tmsprt Cst-A&G Maint Plnt
Transportation Cosl -Tmsfred
Offce Exp-SOS Ops SUP & Eng
Office ExtrPump OPs Lbr & ExP
Offc6 Exp-Pump Ops Misc ExP
Office Exp-PumP Maint Eq
Offcs ExF.Wtr Tmt OPs Lbr&ExP
Offce Exp-Wtr Tmt Maint SPry
Offce ExFWf Tmt Maint Equip
Otrce Exp-T&D Ops Sup&Eng
Offe ExtrT&D Ops Strg Faclt
Offce Exp-T&D Ops Line Ex
Ofnce Exp-T&D OPs Misc Ex
Office Exp-T&D Maint - Main
Off e EXFT&D Maint-Seili@s
Of6@ Exlcust Acct Rcrds&Col
Ofice Exp-Cust Acct Misc ExP
Office Exp.A&G Ops Salaries
Ofrce ExtrA&G Ops Off SUPPI
Offce Exp-A&G Acmhg & Audt!
Offce EXF.A&G Ops Misc Gen
Offce E&A&G Maint Plnt
0.005040065i
5040066{
50/,0067i
5040067:
5040067{
5040090i
5040090i
5040090t
5040092(
5040092',
5040092:
5040093i
5040590:
s060560,
5061062:
5061064i
506 1066I
506.2062i
5062052(
5062063:
5062065',
5062066t
5062067:
5062092',
5062093(
5062562t
5062564:
5062564!
50635612
5063562(
5063564(
5063564',
5063564i
5063555i
5064500(
5064560(
5064560',
s0at561'
5064561r
5064562(
5064582,
5064562r
5064563',
5064563i
5064563:
5064564i
5064564:
5064555(
50&156s'
5064565i
5064566(
5064568'
5oan566I
5064566r
5064567i
5081567t
50an567(
5064567',i
5064590',
50a$90i
5064590:
5064592(
5064593i
5064600(
5065050(
50650622
5065062(
5065063:
5065064i
5065065(
5065065i
5065066(
5065066',
5065066i
5065065I
5065067!
5065067f
5065090:
5065090I
5065092(
5065092',
5065092:
5065093(
5065093:
36,142.s7
3,397.88
20,392.00
69.00
28,837.96
57,122.13
75,A38.32
4,22',t.53
56,022.95
3,467.75
92,286.22
4.560.67
249,461.85
197,733.69
1,768,468.00
0.00
3A2,441.53
3,725.29
935-43
7,292.63
'10.989.48
0.00
'ts,756.47
5,774.79
22.00
0.00
22,391.54
1'.|,992.92
1.141.U
6,326.13
376,625.94
3.30'1.70
657.20
744,130.92
3,764.24
4.298.07
707.47
414.73
1,073.97
316.32
79,590.69
262.74
8.26
3,423.26
47,243.51
'173.20
1 14.51
377-90
7U.91
526.86
8,971.79
3,426.O2
49.75
4,788.35
71,930.39
853.11
845.96
5,021.19
22,097.63
72,410.20
93,579.01
45.92
(744,13O.921
45.U
2,460.40
26,124.74
21.17
1,001.88
600.00
6,352.92
43.',t4
26,338.16
6,899.66
6,195.43
210.08
1,760.72
63,028.57
3,U2.43
34.219.44
112,443.74
'133,347.50
82,328.55
17,424.59
3,908.80
1,409.2'l
0.00
0.00
3,470.98
2,327.25
12,994.28
71.16
2,201.OO
1,206.60
20,806.23
1,128.00
20,'t72.75
252.43
93,449.57
701.88
21,611.68
0.00
353.59
129.09
5,298.70
'1,109.34
24.06
2,O48.20
797.59
0.00
890.05
2,310.40
634.17
0.00
1,207.61
17,867.'10
0.00
0.00
104,900.72
631.87
832-77
0.00
0.00
147.U
0-00
1 1,901.45
0.00
0.00
79.89
5,31'1.71
0.00
0.00
0.00
0.00
0.00
0.00
44.35
0.00
0.00
12,469.59
0.00
0.00
653.07
2,879.96
10,114.42
13,107.00
0.00
0.00
215.05
0.00
78A.71
0.00
0.00
0.00
0.00
0.00
2,851.00
5,714.43
0.00
490.59
8,751.10
798.99
6,912.40
5,912.24
14,033.75
5,619.12
fi2.32
(s30.97)
0.00
0.00
0.00
0.00
(s9.28)
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
0.00
0.00
0.00
(2,616.86)
0.00
(6,805.20)
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
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
('104,900.72)
0.00
0.00
(390.31)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
(2s.00)
(16.24\
0.00
0.00
(2,677.10)
(102.78)
0.00
(3,523.06)
0.00
40,051.37
4,276.12
20,392.00
69.00
32,308.94
59,,149.38
a8,773.32
4.292.69
58,223.95
4,674.35
't13,O92.45
5,688.67
269,634.60
'197,986.12
1,861,917.57
701.88
404,053.21
29.37
4,088.88
'1,08t.52
12,59'1.33
'12,098.82
24.06
17,AU.67
6,57234
22-O0
890.05
24,701.98
12,627.O9
1,141.M
7,533.74
391,876.18
3,30'l.70
(6,148.00)
849,03'1.64
4,336.15
5,130.84
707.87
41a.73
1,221-41
315.32
91,492.14
262.74
8.26
3,503.'15
52,595.22
173.20
1',t4.51
377.90
7U.91
526.86
8,971.79
3.470.37
49.75
4,788.35
84,399.98
853.1'l
845.96
5,674.26
24,977.59
a2,928.62
106,686.0',1
45.92
(849,031.64)
260.59
2,460.40
26,523.'.|4
21.17
1,001.88
600.00
6,352.92
43.14
29,189.16
6,958.89
'11.909.86
185.08
2,23s.O7
71.779.77
4,641.42
38,455.'.|4
1 18,653.24
147,38',1.25
u,124.61
18,385.91
suz-w-20-02
IPUC DR 1 Updat6 2
Ahchmcil
4of6
RcpoillD: TSCORioOL.yodlD: TBCORIoO SUEZ Wator ldaho
Gcmr.l Lcdg.r Sy*h
Poriod Account GAAP Trirl Bllrncs -Burln.lt Unfr: OOO6O
P6rbd Endlhg: OE 3t,2O2O
Actulls Lodg€r
Portod Beglnntng Perlod
Enilng
BatrnceBahnceD.bttt Crcdlrs
5065166(
5065560a
50655612
5055563',
5065565'
7010040i
7020uot
7025UOt
70700/.2t
7080043(
709004 1 (
7100043'
710'1o43.
710504,1(
7105141(
7105241(
7120042t
712514,1t
7125342'.
712554&
7125742t.
7125A42C
8010040I
8015040(
80200!.1t
8025041(
8040041'
90400902
9040590(
9085092i
9089042r
9095000(
9095060(
9095060,
9095061'
90950612
9095062(
9095062i
90950622
9095063',
9095063i
9095063a
9095064i
9095064:
9095065(
9095065,
9095065.2
9095066(
9095066i
9095066I
9095066r
9095067:
9095067t
9095067t
9095067i
9095090,
9095090i
9095090:
9095092(
9095093:
91400921
9146092{
9150092t
9155092(
sl 70092(
9180092(
9185000(
9186092(
9190092t
9205293(
920s36'7,
9206493(
9220062(
922OO62t
922006.2t
9220063'
9220063:
9220064i
9220065,
9220065i
9220066{
9220067i
9220067t
92200902
620.37
50.00
160,081.15
1,412.50
I,O55,677.20
1,694,023.70
570,190.71
10,245.'15
3,740,399.10
(39,919.65)
(18,343.s9)
6,862.13
11,578.67
(231,936.37)
(463,0.t3.00)
7,6s1.54
(47,r93.53)
(1,316,796.69)
18,986.00
301,364.26
(483,244.71)
4,627.213.00
1,262,405.00
(1,283,689.00)
(427,086.00)
(44,22O.OO)
191,A6/..42
402,007.07
3,199,603.80
14 j1A.20
(3,001,191.28)
17,760.30
20,4*.20
3.929.60
2,746.47
5,028.53
1,785.73
366,360.07
1,412.37
41.99
14,741.23
2'16,578.60
767.85
508.69
2,061.48
4,321.70
3,558.41
50,793.41
19,343.84
221.04
26,768.56
316,796.30
,t,912.36
4,86.3.22
23,508.49
't02,179-14
339,734.43
450,424.O5
241.48
439.974.59
129,215.A2
476,346.76
159,518.36
1,396,335.08
269,584.55
7,140.00
12,392.32
119,439.14
10,748.65
51,,121-U
32,049.10
837.88
2,434.AA
2,588.00
74.00
44.70
1,305.13
4#.A2
12.33
316.67
665.38
8.9,15.20
137.69
0.00
0.00
0.00
12,932.98
0.00
8.15,840.79
88,250.56
5A,782.76
10,245.15
327,324.37
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
909,486.74
2,200.00
27,3.75
0.00
0.00
0.00
0.00
0.00
0.00
36,21 3.13
288,880.99
422,208.44
3,025.74
678.04
1,943.03
2,560.47
0.00
0.00
451-54
0.00
36,593.30
0.00
0.00
245.60
16,331.87
0.00
0.00
0.00
0.00
0.00
0.00
'136.34
0.00
0.00
38,340.20
0.00
0.00
2,008.0'l
8,854.98
31,111.03
40,300.03
0.00
2s3,78s.16
0.00
43,304.25
14,501.67
142,242.43
24,U2.91
0.00
8,796.99
0.00
977.15
4,647.39
3,72',t.73
151.36
225-24
0.00
37.00
442.93
0.00
2'18.41
0.00
0.00
0.00
'1,059.66
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
(43.76)
0.00
0.00
(3,sos.44)
(1,300.09)
0.00
0.00
(11,241.09)
(22,44O.48)
0.00
(4,380.01)
(1,807.87)
(474.00)
0.00
(43,931.34)
(403,796.30)
(3,942,705.78)
(1,414,224.98)
(160,474.53)
(4,020.00)
0.00
0.00
(83,'185.6s)
0.00
(273,813.64)
0.oo
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.oo
0.00
0.00
0.00
0.00
0.00
0.00
0.oo
0.00
0.00
0.00
0.00
(5,837.25)
0.00
0.00
(4,157.41)
0.00
0.oo
0.00
0.00
0.00
0.00
0.oo
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.oo
0.00
0.00
0.00
0.00
95,240.47
620.37
50.o0
173,011-13
1,412.50
9,901,517.99
1,782,274.26
62A,929.71
20,490.30
4,067,723.47
(43,425.09)
(19,643.68)
6,862.13
11,57A.67
(243,177.46)
(485,,r53.48)
7,651.54
(5.t,s73.54)
(409.117.U|
20,712.OO
32A,761-O'l
(s27,176.05)
4,223,416.70
(2,680,300.78)
(2,697,913.98)
(s87,560.53)
(48,240.@)
228,077.ss
690,888.06
3,538,626.59
17,143.94
(3,274,326.88)
19,703.33
23,016.67
3.929.60
2,746.47
5,483.O7
1,745.73
402,953.37
1,412.37
4'1.99
18,986.83
232,910.47
767.A5
508.69
2,061.48
4.321.70
3,558.41
s0,793.41
19,480.18
221.U
26,768.56
355,136.50
4,912.36
4,863.22
25,516.50
111,OU.'t2
370,845.464 ,724.OA
241-4A
693,759.75
123,37A.57
519,65'1.01
'174,O20.O3
1,5U,420-10
293,927.46
7,140.00
21,189.31
119,439.,14
11,725.A0
5s,768.73
35,770.A3
989.24
2,660.12
2,588.00
11 1.00
527.63
1,305.13
655.23
12.33
316.67
665.38
9,974.86
137.69
Adverlising ExtrA&c
Mi3c EX},SOS Ops Misc
Misc Exp-SOS Maint Wils&Spr
Misc ExF.Pump Main! Strctrs
Misc ExpWtr Tmt Maint Strct
Deprociation - Utility Plant
Real Estate Til
PayrollTaes
Amort of Debt lssuance Cost
Interest ExFSW/Can cons co,s
lnterest in@me
Other intErest
Other int€rest - Regulatory
AFUOC Gross Up
AFUOC Debt
AFUDC Equity
Gain - Disposition of Property
Misc Non Oper R6ntal lncome
Non Re@verable
Amort of Util PltAcquis Adj
Pensioeother componG of Nppc
PBOP-Othsr compon€nts of NppC
Current-t€deral
Cun6nt-state
Defered-Federal lncome Tue!
D6fered-St8te lncome taxes
lnvestm6nt Td Cr,amortization
Bad Dbt-WGCush Acct Uncollct
Bad Dbt-Provsn-Cust Acct Un@l
Corporale Shared Seryies Fees
Corp Shrd SvG-Non Recoverable
F B T.ES
F B T-SOS Ops Sup & Eng
F B T-SOS Ops Lbr & Exp
F B T-SOS Maint Sfcts
F B T-SOS Maint Wtts&Spr
F B T-Pump Ops Sup & Eng
F B T-Pump Ops PM Prd Lbr
F B T-Pump Ops Lbr & Exp
F B T-Pump Maint Strcts
F B T-Pump Maint Pw Prd lmprv
F B T-Pump Msint Eq
F B T-Wtr Tmt Ops Lbr&Exp
F B T-Wb Tmt Ops Misc Exp
F B T-Wtr Tmt Maint Sup&Eng
F B T-Wh Tmt Maint Strc1
F B T-Wh Tmt Maint Equip
F B T-T&D Ops Sup&Eng
F B T-T&D Ops Line Ex
F B T-T&D Ops M6ter Exp
F B T-T&O Ops Cust tnst
F I T-T&D Maint - Main
F B T-T&D Maint - Ssrvices
F B T-T&D Maint - Metem
F B T-T&D Maint - Hydrants
F B T-Cust Accl Suprvsn
F B T€ust A@t Mtr Rdng
F B T-Cust Acct Rcrds&Coll
F B T-A&G Salaries
F B T-A&G Maint Plnt
Liabilily lnsuranc+A&G Ops
Work€r 6mpA&G Opelnj&Dmages
PensiorA&G Ops
Post Rlmnl PEOP-A&G Opepnsn
Emply€e Grp Hltt&L-A&G Otrpnsn
Emplyee 40'l K-A&G Op$pension
oth6r Employee Benefi teES
Other AHrds-A&G OpsEmp pnsns
Regulatory CommissiorA&G Ops
Amort RelocA&G OpeMisc G€n
Amort Tnk PntngT&D Maint Ery
AmoTtAFUDC Eq GU-A&G Ops Misc
Uni&Sfty E+Pump Ops Sup & Eng
Uni&Sfry E+Pump Ops Lbr & Exp
Uni&Sfty E+Pump Ops Misc Exp
Uni&Sfty E+Pump Maint Ptr Prd
Uni&Sfry EtPump Maint Eq
Uni&Sfry E+Wtr Tmt Ops Lbr&Ex
Uni&Sfry E+Wtr Tm Maint Stct
Uni&Sfly E+Wtr Tmt Maint Eq
Uni&Sfry E+T&D Ops Misc Ex
Uni&Sfty E+T&D Maint- Main
Uni&Sfry E+T&D Maint-S€ilies
Uni&Sfty E+CustAcct Mts Rdng suz-w-2M2
IPUC DR I Update 2
Ahchmefr
5 ol6
Rcpod
L.yod
lD: TgCORloo
lD: TBCOR1oo
SUEZ Watcr ldaho
Ocmrd Lcdg.t SyrLh
Period Account GAAP Ttill Bllrnce - Acturls Ledgsr
Buln... Unh: m060
P.dod EndiE: D* !1,20m
Pedod Beglnnlng
Crcdl,3
Peilod
Eodng
BatanceBalanceDabna
9220090:
9220092',
9220093(
9220093i
9230093(
9260092:
9260093i
Uni&Sfry Eq-Cust Acci Rqds&Co
Uni&Sfiy E+A&G OPs OreuP&EP
Uni&Sfry E+A&G OPs Misc GBn
Uni&Sfty E+A&G Maint Plnt
Bank ChsrgegA&G OPs Misc Gon
Other G&A EXP.A&G OrB SryG E
Other G&A EXFA&G Maint Plnt
1,619.56
41,%8.42
12,696.73
23,838.'16
5,1 12.05
22,845.69
4,940.49
(0.00)
't05.99
3.865.08
2,018.O2
5,508.,t4
1,038.92
2,582.41
0.00
s0,'134,157.60
0.00 1,72s.55
44,s92.78
14,662-73
25,792.A3
6,150.97
25,42A10
4,940.43
(0.00)
(1,240.72)
(52.O21
(3,553.77)
0.00
0.00
0.00
UW All Accounts (s0,134,157.59)
suz{-2042
IPUC DR 1 Upddte 2
Atechmont6of6
CASE NO. SUZ-W-20.02
Second Supplemental Response No. 1
Update2 Attachment
Excel Spreadsheet Provided Separately
in Native Format
SUEZ WATER IDAHO INC.
CASE SUZ.W.2O.O2
FIRST PRODUCTION REQUEST OF THE COMMISSION STAFF
Preparer/Sponsorin g Witness:J. Cary
C. Cooper
REQUEST NO.17:
Please provide copies of the monthly, quarterly, and annual comparison of operating and
capital budget to actual expenditures for 2016 - 2020 to date. Please include within your
response a narrative explanation for budget variations. This should include, but not be
limited to, written operating and capital budget variance reports and explanations used by
Company officers and managers to monitor and control budgets under their responsibility.
Please supplement your response as additional information becomes available
throughout2020.
RESPONSE NO. 17:
Please see attached fibs for Operating expense and Capital budget variances and
explanations.
The following monthly variance files are not available and are supplemented with financial
lncome Statements showing the variance to budget and Year to Date variance analysis
in subsequent months:
Operating: January 2016, July 2016, April 2019, and May 2019
Capital: April2019
Attachment 1 - containing operating expense and capital budget variances from January
2016 through March 2019, and capital budget variances from April 2019 to August 2020.
Attachment 2 - containi ng operating expense budget variances from June 2019 through
September 2020.
Attachment 3 - containing the income statement and variances from budget for months:
January 2016, July 2016, April 2019, and May 2019
Update 1
Please see Attachment 1 to DR 17 Update 1 for capital budget variances for October
2020. The capital budget variance for September 2020 has already been provided in the
original response to Response 17, Attachment 1 page 133 of 133.
suz-w-20-02
IPUC DR 17 Update 2
Page 1 of2
Please see Attachment 2 to DR 17 Update 1 for the operating expense budget variances
from October 2020 and November 2020.
Update 2
Please see Attachment 1 to DR 17 Update 2 for the capitat budget variances for
November 2020.
Please see Attachment 2 to DR 17 Update 2 for the operating expense budget
variances for December 2020.
suz-w-20-02
IPUC DR 17 Update 2
Page 2 of 2
o
ot)6o
NofIR-
ffioof(L
oNo6t
Lo-oEo
oz
I
=0,'=otxoo-(5o
co
=:
=)
e e e e e
z
oP(E
co
Ico
.o)o-o
,9,E
=Ui6
13trooLt-9a
=6z,a
d'Pco,'Eo
=od89-g9E8q,'e-.'=
cL'6
€?EE([6):L-lr Lioou, !atc ,tt)q 6R! ?=o .:cLEl EoEg;yLJ LL.lJ *ool E3= =c)gEv.o
Ee xE.g) ll !i fiE =p 5,
= <E Ea 86 5
t
-s,Cl
-)
o
E3g
qEl!oE
9o
to'd
CL(,,P6J
@c
(,oc
oocUI
0,JEg
co
ooo!,
=co
=co
3E-ct
x6d
x
NI
xor,iI
booo
do
o6-
oTDE5c.9reEoEtr gia a,RE >v';-s BEEE6^o
=t0<r I
-\oa\u'oto\,
{-lo
cnT'
IJ
m
Ia
a
(E
IJ*,o
:la+,?
-.9
I ?
-.9
II
xo
CL
Go
(3(\t
()$l
t-o
-o
Eo
oz
N00
N
.+oto-o
CDr.
TEJ
EDg
Loo
u)tr
UJ
Io.xcso
I
k.mhr [e-mail]{alyrTot.lProJdrd.hoBUDtrro.R19 N70 flb Idrl D.p.n ou_Rollu!_by_Bu U5D
(SS rn'@)
BS 2,M 2Ur7 pal _v!tur632r). waurdd 6MG un&r, F*tny El VoluN Sel Wn.r3otd 4t MG hiahr' 'chq6(S4l -' F*ilryo.rye5{S*)
s
143
19
s
@
t7
83
ttt
676 72a
126
o
7A
&7
rt
42
$
4
IE
Pryoll (Ssk) hl|s - ,+lFr.nF dj6rm.n!
rct N* T&OSutsdbor, OE Mnar, p.d SuFdor' ' roE nned..ilturh.n ded. hdb t97t) -
Hlehe. Mdk.frd6 tu bt bk wC
0
5
{13) Hiah.r tst.ndv*iud(gt5k)
t2sel lS24U 16u,.@dj {SuD v.hth hish.r dk' ' toddhroc u.pdd Mt6&tud
lrlr:
l,t &.b hthre&@nrd*rFdlBB)+q.EnoaFe
17 , TlmiE Luds Pe.k Bd eru.d in N@,
l6)la.r lry rd. $.n .ntdB.d, v.ludd *-95 hLi.r bd r6uhlqrd b b.r,MlEh.il
IG
Paroll {S119k} - AddibnC h..d.ou.t &
t2221 hgh.rwqa ok bY hEh.ruEri M;' endtu (S103k) - (St&l wc dt. n b19otu6vhish.r ina.r.6Lrr.dod
Ll
9
(3e)
: 62544 bur.nc dl. Md.rbb (J22[ -
rsll Rkd 32&ro @ in D..,'19du. ro' ' dod6; (S24)Ehkkdueloddhion.l
126
16
6S
14
1S1
315
77I
183
&
W.t.rPu.ch.{d ExFB.
il, wo,.nd G.n.r.lIu.
tst;
"5j\7'
(5)
(5,
,l
tu. io hr aEwrE uFk
Timina ' tkky P..t @ft rcrld ih b.
io-r..owaue- ($ryJ uctd rdudr NoH..@r$L - {sry) oAc td rclun6
l99l .6uiiqfrom PUC lthq de6on. No hor.Edkd
(sl (ral s f.m PE fllrE &ln el6 (91et)
113) (11)(25) l22t
(oli lsl
r,il 16rllzeur' 8s
E 1,1t5a5 E,r*)lD 16
{rs) E,rr.llat F,eElfr@,r a,tt
8 96%
ffidalhdfr.runotunkE btudthru r{.dd
sr-i( vyz@, no mr. P&r h6. tu,,.. ffmEh..nMndtrbBkr"'.Mtlrurq*ddd.rdL kbrhyr(bh3Honly,
71050-AfUDCGros up {25)
(rt
(@)
Eat
1,192
s
,1051 -AFUDC D.h
71052-AFUOC Equlry
t2t
(.)
(6t
{23),
l4tt
Bl rcDtoBa P..( i&@d O..lttmtq &- 'B/.nSuUBMM.brutrUr
Or$l]
{u) tdnomhturdldlbhB.Mek.
r.7l f,trr.& H*tu.r.fulvd.pr.dd s '' ' d 31tut9
trUE lE
$mA tlr.r) ila)l No mnthryun.olldrbh r6.mek.
{3}'O.pd.tion ErtsG.
Amoniation Erp.6.hF*hb. I Amodrnb.ttr
@
ESgs
l52l
{3731ttt
&5%
tali68llB]
0,5rol istG I
4,rE :
{eti(r,6rl
.o;
lr5Btlrsl!,s i
&.ib.dhm.
suz-w-20-02
IPUC DR 17 Update 2
Attachment 2
Page 1 ol 2
(S$ in'ml
Y..r To oak Tot.l Book Total D.t! TyF Total Projdt ld.ho BU Dlvkbn Tot'l D'Padm'nB ou-RolluP-bv-au
FY19 FY20 fl20
tinrl wo*ins Fihalffi
volum.(S551kl-wtt r$ld(191MG)und€rplan,f.dlitv
ch.ryB {S4k}. ($6k) os.rtes^ur.h.rt6
P.yrollS122k-Vadnd$rd.tdton.wh..d
@!nt/b.*flll, hllhcrtmfr out;8.ndts S75r -
Hlgh€r Mdlal ofis.t by low.rbr6 & wo* @mp &
hllhd fdn!.tmfr out
volum. S986k - w:t rsold 492 MG hi3h.r. radltiv
15,062
6,&
2,{5
@7
933
47,9t3
7,916
2,331
415
s5
a7,QZ
7,1!9
2,321
410
9g
15611 L3e grosh. SurdarS6/Oth€r f€.3
Payrcll 6mkl- Addition.l h.ad@unt & hlgh.r
Parsonnal [xpensa 197 lS3o7k) - Hi3h.r mdiel, 40119 wC &
by hl8h.r f dnt. tr.hsf d out
2019 h.d.ddltlon.l po$r r.odld dueto blllint
Eners Exp€nse
chemi@l Expense
30 qd. d.n!. od-D*
LGFI(S7*)clAct.x, R{uhrory m.te6, hE rdislont
6nv.nl.nc.l*i; Tmpr {S34k} 6R/mds r..d.r
v.ond.s (f o,4oinr r-tr.la tmp), (S35k) T.hk m.inr',
(SlzklLo6tin& S23l G!n.r.l m.lnt., (S15r) Ndcon@r
(SSk) lsl, ($a8r) T.nk m.lnt.,SS rln. m.lnt.,
Notify, (S14k) lton luppod
Subcontrador fxp (10e)d.l.y, {S11kl Concurf!6, S15k l.b tlstln!
all r.ryle, S20k wu/Ebfl [n&f.s. S8r s.nsur/ltrcn, lSSr) bb t6tin& 914k
Wu/Eblllln$ S20k CG Suppod CorP. allo.CCB Suppot turp Alloc.
i(S525k)lnsur:hc. i6!w. adl.;5E5k Lowerv.hld! duc to
nd vchld6, splrd l..Es up for r.ndrl &
hithdtmfrout,Sl26kAdv.-53*CCRd.l.ydtoQl'21,
S32k @rp. mb p.omotlon d.l.yd to'21, (5&k
postpon.d to 2021); $U& otrle &P lomr-
tr.vlytr.inlnt svlnr 5491, tckPhon! low.r lvR &
{S6gk) lhsunne.dj,SsK trie frp - trv.l &
!.vln$; t.lehon.; 52Sk .dvenbh& S43k
Oth€r Expenses 2,763
t2,7L2
3,t33
1&
246
!,a76
2,322
2,677
1+Ut
3,55
198
224
7,742
2,m
bndsaplng du. rop.B/*.t_uP new ontndor,
Sl8kVlhkl.
OEntlil & M.imcn.nc. CBt.
MB t..s
13,925
3,74 [9 S.t'nar ln BB p@nn.I hv.l, otr6
Lu*yP.ak8ORM.lnt n.nef..6&)hi3hs'Addtlon.
2n $vln$ ln BE tslsn.l rr.vC, dh + low
(9201)Addition.l Bolsc.n.l sh.ffi, (SAk) Lu*y
{36)8oR m.lnt.n.ne. Addltionrl s.s. fr (S1ok)
water Purchas€d upens€179 (1s)&Middbton lrla.tlon bnrt.rm b.{ pot.ntLl
d.maoE not ndd [d3.tion lont t.m I.... Pot.ntial
Low.r wdtloffs & L..k rdiunmlnt - colldiont d.l.yd
Low.r wrfteoffs & L..k .diuitmlnb duc to CovidWrite-otf txpens€
G!n€ral Taxes
274
2,198
2,651
45 covld - Colldions prcc6d n.dd l.t! De. on 58
415 Lowd lry r.t th.n.ntdp.t.d. School Dlstddsdid hot
rquest nom.l 3% lnclrsedu.to P.ndcmic.
q bw.r |.ry rrt. th.n .nticip.t.d, v.lu.tlon ss
hEh.r but Hultlntbx is lorcr
g3 114
I
(ugrll
l
(220)l
(305)
(610),
(r,rr6)'
n,ezs'
a6i
9,554 i
Non-r@v.r:bl. - lsr.13M) low.r C|ACtrr du. to Non-r.@v.6bl.- {5933k) bw.rC|AChr.s
irsu€d rft.r CIAC til Hision aPProvcd k. No in'19;S2ok Fount.ln don.tion, (5741) E.rl.
GhGr ln6mc lncludld ln E8IIDA {.531 tobG.olldd, (912k)covd'19 r!s.l rd.rs, (S27k) Lobby.s! (S14)covid-
don.tlons, tsTkl hi.hd lAcl dus
12
:
{243)
(485)
(717) L
!,7O7 :6e1 l
Eudtd w$ movd .s th. dft@ne bM bok .nd I st.dns V1no2o, no moru P&t lmPd. Th.
idtf.r.E Mn M.nd tu b.sk b flow.d thtu
lC.d.nd dd.rd t.x ll.bllEy (b.l.nd 3hG
1*lY)
i 8ri.nw.t.rponcbJniAFUDC
71050'AFUDC Grosi up (12)b.Cr b tlosd thru q .s .nd dd.il.d u lbblllty {231)
71051 -AFUOC D.bt
71052 - AfUDC Equity
AFUOC Exp
EBITDA
Provision
O.preciation Explnie
Amonization &Pense
O.F.cl.tion & Amoiliu.tion
EBIT
lntcrci& oh.r FlmmLl ln.omc
E .cptiml ltcht
Taraa
Tdl ilct lmm.i
(13E)
12761
({15)
D,672
10,013
10013
19,659
a,a63
15,196
,,975
11,21
105
2@
92
(e551
(6e1)
112
Rdwood crekPlp.lin.9l&; sPuMng M.in Proj.d
526k; Hidd.n sprln!3RsS27k
(63)
(12s)
{a191 2019sunstP.rk, Rldwoodcrcek Proj.ds &Brl.n
AFUDC
9,ru
ro,5t2
11,115,:*
tt,xt
(r,Er)
16,02
-13%
Nu monthly uncoll.dlbl. r6.ru. elc.
R€vlsd 6p.r budt6t
Nu monthly unoll.dibl. 6.ru. elc.
Hbh.rop.x budtd
9 539
N,ft
4,20
r5,s5
a,279
1t7O7
27%
(5r)
(1,5s1
58
ler5)
5,76{,ls
3S
5,6
+36
Elt diwT.xRrta 25%
suz-w-20-02
IPUC DR 17 Updale 2
Attachment 2
Page2 of 2