2017Annual Report.pdf

..)qau)
P.TCE IVED
?SlBltPil l5 Pt{ l: l7
c i-rutiLlc; C0iJlillSSIONANNUAL REPORT
OF
SUEZ Water ldaho lnc
NAME
P.O. Box 190420, Boise, lD 83719 - 0420
ADDRESS
TO THE
IDAHO PUBLIG
UTILITIES COMMISSION
FOR THE
YEAR ENDED: DECEMBER 31,2017
a
ANNUAL REPORT FOR WATER UTILITIES TO
THE IDAHO PUBLIC UTILITIES COMMISSION
FOR THE YEAR ENDING
Corporation
Towns: Boise, Eagle
Counties: Ada
'11 Are there any affiliated Companies?Yes
If yes, attach a list with names, addresses & descriptions. Explain any seruices
provided to the utility.
1 Give full name of utility
Telephone Area Code ( )
E-mail address
2 Date of Organization
3 Organized under the laws of the state of
4 Address of Principal Office (number & street)
5 P.O. Box (if applicable)
6 City
7 State
8 Zip Code
I Organization (proprietor, partnership, Corp.)
10 Towns, Counties served
1 2 Contact lnformation:
President
Sr. Vice President, Finance
Secretary
Vice President, General Manager
Complaints or Billing
Engineering
Emergency Service
Accountlng / Finance
City
State
zip
December 31 2017
COMPANY INFORMAT]ON
SUEZ Water ldaho lnc
[phone]
Website: www.mysuezwater.com Email: [e-mail]
April2, 1928
ldaho
8248 W. Victory Road
P.O. Box 190420
Boise
83719-0420
Name Phone No.
David Stanton 767-9300
Mathieu Le Bourhis 767-9300
K.ro 767-9300
G P 362-7327
Linda P 362-7305
362-7343
Marshall or Linda 362-1 300
Jarmila M. C 362-7332
Paramus
New Jersey
13 Were any water systems acquired during the year or any additions/deletions made
to the service area during the year?No
lf yes, aftach a list with names, addresses & descriptions. Explain any services provided to the utility.
14 Where are the Company's books and records kept?
SUEZ Water Resources lnc.
Street Address 461 From Road Suite 400
07652
Page 1
ldaho
Name: SUEZ Water ldaho lnc
COMPANY INFORMATION
For the Year Ended:December 31 2017
11. AffiliatedCompanies:
SUEZ Water Resources lnc.
461 From Road, Suite 400
Paramus, NJ 07652
Services provided to the utility:
Management and service contract on file with the l.P.U.C.
13. Additions / Deletions to service area:
Page 1 Detail
COMPANY INFORMATION (Cont.)
For the Year Ended
15 ls the system operated or maintained under a
service contract?
'16 lf yes: With whom is the contract?
When does the contract expire?
What services and rates are included?
17 ls water purchased for resale through the system?
1B If yes: Name of Organization
Name of owner or operator
Mailing Address
City
State
Zip
Water Purchased
19 Has any system(s) been disapproved by the
ldaho Department of Environmental Quality?
lf yes, attach full explanation
20 Has the ldaho Department of Environmental Quality
recommended any improvements?
lf yes, attach full explanation
21 Number of Complaints received during year concerning:
Quality of Service
High Bills
Disconnection
22 Number of Customers involuntarily disconnected
23 Date customers last received a copy of the Summary
of Rules required by IDAPA 31.21.01.701?
Attach a Copy of the Summary
24 Did significant additions or retirements from the
Plant Accounts occur during the year?
lf yes, attach full explanation
and an updated system map
December 31 2017
No
Yes (3 service locations on Joplin Road)
City of Garden City
Garden City Public Works - Finance Department
6015 Glenwood
Garden City
ID
Gallons
672,452 $
Amount
1,800
No
Yes
Upgrade 16th Street Well head
660
684
1 315
Jan. - Mar. 2018
Page 2
Yes
NAME: SUEZ Water ldaho lnc
83714
1 ,315
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31,2017
PAGE 1 OF 1
4t16t2018
24. SIGNTFICANT ADDITIONS TO THE PLANT ACCOUNT
ADDITIONS (Over $100,000 Gross)
NO. DESCRIPTION AMOUNT
t\f NEW & REPLACEMENT METERS 2,889,177
2 "F"NEW, REPLACEMENT & FIRE SERVICES 2,463,243
3 C15D101_060_001 [10%] Main Line Co 1,529,461
4 "D"HYDRANTS & MAINS 1,450,991
5 C17D609 060 001 Five Mile-Hazel Park to Seneca 1,215,277
6 C16B506 060 001 Marden Filter Controls Replacement 932,881
7 C 16C527 Quail Booster Station 917
840,3938 C16D001_060_001 New Fire Hydrants
I C16D307 060_001 Harris Ranch North Sub 799,278'10 c'16D105 060 001 Bluffs Connection Pipeline 619,615
11 C17D701 060 001 Cole and Fairview 514,859
12 C17D302 060 001 Highland Cove Sub No 1 432,567
13 C16C101 060 00'l CouncilSprings Booster 426.019
14 C17D707_060_001 McKinley & Jefferson 366,871
15 C'16B506 060 002 MWTP Filter PLC Consultant Fees 353,373
16 C16E101 060 00'l Harris Ranch North Reservoir 344.016
17 C16D326 060 001 Eyrie Canyon Sub No 9 243.611
18 C16D706_060_001 Broad Street Main Replacement 217,607
20 C1 Lakemoor Commercial
21 C1 New Short Mains & Valves
22 C1 Neville Ranch Sub No 2 191
185,22123 C15D344 060 OO1 THE DISTRICT AT PARK CENTER
24 C16D321 060_001 Riverheights Sub No 7 184,315
25 C17D322 060 001 Gated Garden Sub Phasel 180,531
26 C17D317 060 001 Brook View Community 176,071
27 C1 Diamante Subdivision 17
166,54128 C14D381 060 OOl SKYWEST MAINTENANCE HANGAR
29 C15D101 060_002 [100%] Update BSWUA = SUEZ Standard 164,887
30 C15D328 060 OO1 DASHWOOD SUBDIVISION 162,646
31 C16D334 060 001 Bonneville Point Sub No 'l 161,597
32 C16D340 060 001 Lanewood Sub No 1 160,930
33 C17D334 060_001 Easton Apartments 160.264
34 C17D605 060 001 Colum bia Rd-Cowen to Vallev Heiqhts 1s3,636
35 C17D608 060 001 Cruzen Street & Flaminqo Drive 149,642
36 C17K505_060_001 Victory Back Lot Pavement Overlav 142,065
37 C16D313 060-001 Fork South Sub No 1 138,802
38 C16D329 060 001 Dallas Harris Estates No 15 137 717
39 C16D325 060 001 Sprinqhouse Sub 137,580
40 C15D349-O6O-OO1 NORTH POINTE SUB 127,735
41 C17D311_060_001 Barbervalley Townhomes No 4 127,253
42 C16C528 060_001 Repl P Valley 500 kW Generator 121,948
43 C17D71 Alemeda - Veterans to Mercer 104,024
44 C16D31 East Valley Sub No 3 101,580
BSU Residential Honors College 101,26145 C16D31
TOTAL 20,776,434
Page 2 Detail
Additions
19 C15D348 060 OO1 KENSINGTON APARTMENTS 209,455
199 266
198.345
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31,2017
PAGE 1 OF 1
04t16t18
24. SIGNIFICANT RETIREMENTS FROM THE PLANT ACCOUNT
RETIREMENTS (Over $f 5,000)
\,
DESCRIPTION
RETIREMENT OF METERS
NO
BOOK
GOST
$ 1,563,616
2 c168506 060 001 Marden Filter Controls Replacement $ 505,400
3 c16A501_060_001 Well Decommissioning $ 160,016
4 C16C527 060 001 Replace Quail Booster Station $ 100,711
5 C16A501 060 002 Hope Well Decommissioning $ 82,923
6 c17B,504 060 005 Retirement of MWTP NaOCL Generator $ 81,424
7 c16C528_060_001 Repl P Valley 500 kW Generator $ 77,344
8 c16D105 060 001 Bluffs Connection Pipeline $ 76,024
I c17D630 060 001 Abandon Council St PRV Harris Ranch $ 62,300
10 C16C526_060_001 Retiring 350 kW portable genset $ 52,635
11 C16J510_060_001 Replace SCADA Radios $ 41,220
12 c17D609 060 001 Five Mile-H azel Park to Seneca $ 41,014
13 "F,RETIREMENT OF SERVICES $ 35,437
14 C16C103 060 001 Replace Cliffside Well Pump $ 32,000
15 C17C200_060_002 Replace Floating Feather BoosterVFD
16 c16D502 060 001 Repl Short Mains Valves $ 27,807
17 c17C100 060 008 Hidden Valley #1 Well Pump and Pipe $ 26,400
18 C17K506_060_001 Replace Rad io Cal/Analyzer Unit $ 24,900
19 c17B,502 060 001 MWTP Filter Media $ 21,648
20 C17K001_060_004 Chemical Delivery Containment MWTP $ 20,518
21 c15J508 060 001 HP T3500 Multi-Function Device $ 20,100
22 c17C503 060 003 Replace 40 Transducers
23 C16D326 001 Sub No 9
24 c17C100 060 019 Relpacement Sunset West Motor
$ 18,291
25 c168603 060 007 System NaOClPO4ChemPmpsTnksSnsrs 1 Oea $ 16,969
26 c17C525 060 005 Pleasant Valley AC unit Replacement $ 16,399
27 C17D701 060 001 Cole and Fairview $ 16,361
28 c17C525 060 002 Floating Feather AC Unit $ 16,026
MWTP COLLECTOR 3 PUMP29 c15C101 060 001
TOTAL $ 3,222,155
Page 2 Detail
Retirements
$ 31,557
$ 20,000
$ 17,e91
$ 15,225
NAME:
ACCT #
SUEZ Water ldaho lnc
REVENUE & EXPENSE DETAIL
For the Year Ended
DESCRIPTION
December 31 2017
AMOUNT
1
2
3
4
5
6
7
8
4OO REVENUES
460 - Unmetered Water revenue
461.1 - Metered Sales - residential
461.2 - Metered Sales - commercial, industrial
462 - Fire Protection Revenue - Private
464 - Other revenue
465 - lrrigation Sales revenue
466 - Sales for Resale
400 Total Revenue (Add Lines 1 - 7)
(also enter result on Page 4, line 1)
* DEQ Fees Billed separately to customers
** Hookup or Connection Fees Collected
***Commission Approved Surcharges (Franchise Taxes)
401 OPERATING EXPENSES
601.1-6 - Labor - Operations & Maintenance
601.7 - Labor - Customer Accounts
601.8 - Labor - Administrative & General
603 - Salaries - Officers & Directors
604 - Employee Pensions & Benefits
610 - Purchased Water (lncludes leased)
615-16 - Purchased Power & Fuelfor Power
618 - Chemicals
620.1-6 - Material& Supplies - Operation & Maint
620.7-8 - Material & Supplies - A&G and Cust Care
631-34 - Contract Services - Professional
635 - Contract Services - Water Testing
636 - Contract Services - Other
641-42 - Rentals - Property & Equipment
650 - Transportation Expense
656-59 - lnsurance
660 - Advertising
666 - Rate Case Expense (Amortization)
667 - Regulatory Comm. Exp. (Amortizations)
670 - Bad Debt Expense
675 - Miscellaneous
Total Operating Expenses (less Reg. Comm, Depr, Taxes)
( Add lines 12 - 32, also enter on Pg 4, line 2)
4,1 08
32,936,574
14,292,850
1128,172
537,609
271 741
48,899,313
Booked to Acct #:
23699000I
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
1 283 479 23610000
2,496,983
1,010,637
932,590
1,799,769
148,906
2,252,863
333,085
161 005
2,686
4 912
103,418
697,237
13,485
443,815
93,486
101,477
35 792
12 905
270,320
Page 3
1,270,310
16,831,678
Name:
ACCT #
SUEZ Water ldaho lnc
INCOME STATEMENT
For Year Ended
DESCRIPTION
December 31 2017
1
2
3
4
5
6
7
8
Revenue (From Page 3, line 8)
Operating Expenses (From Page 3, line 33)
403 - Depreciation Expense
406 - Amortization, Utility Plant Acquisition Adj
407 - Amortization Exp. - Other Utility Plant
408.10 - Regulatory Fees
408.11 - Property Taxes
408.12 - PayrollTaxes
408.13 - OtherTaxes
409.10 - Federal lncome Taxes
409.1 '1 - State lncome Taxes
410.10 - Prov for Deferred lncome Tax - Federal
410.11- Prov for Deferred lncome Tax - State
411 - Prov for Deferred Utility lncome Tax Credits
412 - lnvestment Tax Credits - Utility
Total Expenses from operations before interest (add lines 2-15)
413 - lncome from Utility Plant Leased to Others
414 - Gains (Losses) from Disposition of Util Plant
48,899,313
16,831,678
9,019,036
20,712
1 13,346
2,023,136
502,587
9A
9B
9C
9D
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
5,346,350
I ,111 ,712
82,676
54,062
(48,240)
35,057,055
Net Operating lncome (Add lines 1,17 &18less line 16)
415 - Revenues, Mdsing, Jobbing & Contract Work
416 - Expenses, Mdsing, Jobbing & Contract Work
419 - lnterest & Dividend lncome Other
420 - Allowance for Funds Used During Construction
421 - Miscellaneous Non-Utility lncome
426 - Miscellaneous Non-Utility Expense
408.20 - Other Taxes, Non-Utility Operations
409.20 - lncome Taxes, Non-Utility Operations
Net Non-Utility lncome (Add lines 20,22,23 & 24 less lines 21,25,26, & 271
Gross lncome (add lines 19 & 28)
427 .3 - lnterest Expense on Long-Term Debt
427 .5 - Other lnterest Charges
NET INCOME (Line 29 less lines 30 & 31) (Also Enter on Pg 9, Line 2)
',3,842,258
212,511
61,989
530,1 82
(255,597)
13,586,661
4,386,058
2,988
Page 4
9,197,615
84
Name. SUEZ Water ldaho lnc
ACCOUNT 101 PLANT IN SERVICE DETAIL
For Year Ended. December 31 ,2017
SUB
ACCT #
Balance
Beginning
of Year
104,548
41 182
326
187
Added
During
Year
Removed
During
Year
Adjustments
During
Year
Balance
End of
Year
1 738
41
11,703,409
28 850
1,178,793
78
60,35'l
3,518,130
077
11 008
1 994
160
766
11
35,528
19 635
7
27
793
0078
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
DESCRIPTION
301 Organization
302 Franchises and Consents
303 Land, Land Rights & Water Rights
304 Structures and lmprovements
305 Reservoirs & Standpipes
306 Lake, River & Other lntakes
307 Wells
308 lnfiltration Galleries & Tunnels
309 Supply Mains
310 Power Generation Equipment
311 Power Pumping Equipment
320 Purification Systems
330 Distribution Reservoirs & Standpipes
331 Trans. & Distrib. Mains & Accessories
333 Services
334 Meters and Meter lnstallations
335 Hydrants
336 Backflow Prevention Devices
339 Other Plant & Misc. Equipment
340 Office Furniture and Computer Equipment
341 Transportation Equipment
342 Stores Equipment
343 Tools, Shop and Garage Equipment
344 LaboratoryEquipment
345 Power Operated Equipment
346 Communications Equipment
347 Miscellaneous Equipment
348 Other Tangible Property
Rounding Difference
TOTAL PLANT IN SERVICE
892
331,442 337,854
287 79 287
3,704,664 3,921,943
ot 't19 120 380
2,052,258 2,149,862
0 0
4'10,355,701 25,642,164 (3,459,704) (81,694) 432,456,467
Enter beginning & end of year totals on Pg 7, Line 1
I
2
3
23,687,918
41 '130
11,657,558
17
76,151,9'15
14
5,026,615
1
35 528
28 907
7
I
I 709
(810)
39,685 (2,652,602)
1,262,328 (57,665)
(133,529)
178,872 (131,111)
1,854,481 (464,737)
1,478,642 (653,7ss)
292,230 (780)
11,275,415 (247,220\2,527,525
3,460,135 (47,889)
2,683,152 (1,563,616)
2,178,228
266,284 (31,966)
(9,273\
244,206 (20,o23\
12,410 (5,9e8)
265,230 (91,334)43,383
53,261
97,604
Page 5
Name: SUEZ Water ldaho lnc
ACCUMULATED DEPRECIATION ACCOUNT 108.1 DETAIL
For Year Ended December 31 2017
SUB
ACCT #DESCRIPTION
Structures and lmprovements
Reservoirs & Standpipes
Lake, River & Other lntakes
Wells
lnfiltration Galleries & Tunnels
Supply Mains
Power Generation Equipment
Electric Pumping Equipment
Purification Systems
Distribution Reservoirs & Standpipes
Trans. & Distrib. Mains & Accessories
Services
Meters and Meter lnstallations
Hydrants
Backfl ow Prevention Devices
Other Plant & Misc. Equipment
Office Furniture and Equipment
Transportation Equipment
Stores Equipment
Tools, Shop and Garage Equipment
Laboratory Equipment
Power Operated Equipment
Communications Equipment
Miscellaneous Equipment
Other Tangible Property
Cost of Removal / Salvage
Rounding
TOTALS (Add Lines 1 - 251
Annual
Depreciation
Rate *
o/o
2.00Yo 2.50o/o Office Bl
2.00o/o
2.00o/o
2
2.00Yo
2.00o/o
5.00%
5.00%
5.00Yo 14.28Yo Filters
2.00o/o
2.00o/o
2.50o/o
2.50o/o
2.500/o
2.00o/o
2.00Yo
6.670/o 10.00o/o 20.00o/o
11.49o/o
6.670/o
6.67Yo
6.67o/o
14.50o/o
6.670/0
6.670/o
2.00% 10.00% MasterPlan
Balance
Beginning
of Year
143,615,559
Balance
End of
Year
lncrease
or
57
1 304
2 305
3 306
4 307
s 308
6 309
7 310
8 311
I 320
10 330
11 331
12 333
13 334
14 335
15 336
16 339
17 340
18 341
19 342
20 343
21 344
22 345
23 346
24 347
25 348
76
7
471
241
3
1
1
1
17
147 974
101 179
26
7,766,039 8,230,063
446,329 469,905
3,754,844 3,837,536
43,244 44,451
658,513 715,730
1,076,428 1,148,494
14,283,414 14,754,978
19,240,834 20,027,415
3,607,582 3,849,220
55,023,383 58.172,218
25,887,782 27,305,663
1,803,803 475,605
1,073,872 1,221,847
5,667,646 6,596,009
79,747 83,829
27.926 19,635
636,353 694,942
23s,102 251,135
107,539 107,284
1,611,694 1,712,873
91,62469,122
514,360 684,941
1 1
150,495,397
Page 6
Name: SUEZ Water ldaho lnc
BALANCE SHEET
For Year Ended December 31 2017
ASSETS Balance
Beginning
of Year
Balance
End of
Year
lncrease
or
ACCT #DESCRIPTION
1
2
3
4
5
6
1 01i 106
102
103
107
114
Utility Plant in Service (From Pg 5, Line 30)
Utility Plant Leased to Others
Plant Held for Future Use
Construction Work in Progress
Utility Plant Aquisition Adjustment
Subtotal (Add Lines 1 - 5)
Accumulated Depreciation (From Pg 6, Line 26)
Accum. Depr.- Utility Plant Lease to Others
Accum. Depr. - Property Held for Future Use
Accum. Amort. - Utility Plant ln Service
Accum. Amort.- Utility Plant Lease to Others
Accumulated Amortization- Aquisition Adj.
Net Utility Plant (Line 6 less lines 7 - 12)
I nvestment in Subsidiaries
Other lnvestments
Total lnvestments (Add lines 14 & 15)
Cash
Short Term Investments
Accts/Notes Receivable - Customers
Other Receivables
Receivables from Associated Companies
lillaterials & Supplies lnventory
Prepaid Expenses
Unbilled (Accrued) Utility Revenue
Provision for Uncollectable Accounts
Total Current (add lines 17 -24 less line 25)
Unamortized Debt Discount & Expense
Preliminary Survey & lnvestigation Charges
Deferred Rate Case Expenses
Other Deferred Charges
TotalAssets (Add lines 13, 16 & 26 - 30)
41 355 701 1 766
109 139 1 295
761
416,065,601 24,0 061
7 108.1
8 108.2
I 108.3
10 1 10.1
11 110.2
12 115
13
14 123
15 125
16
17 131
18 135
19 141
20 142
21 145
22 151
23 162
24 173
25 143
26
27 181
28 183
29 184
30 186
31
143 61 559 6 79 838
153 1 20 712
272,296,64',1 17,159,512
11 54
11,054
41
1 344 8 224 479
64 1 352
347 160 1 134
74 400
104 500 31 999
311 000
4,665,818 784,564
5 643 249 604
792
4 530 558
,l
432,456,467
7,068,434
600,761
440,125,662
150,495,397
174,113
289,456,152
11,054
11,054
41,592
1.568,787
187,210
476,294
72,000
3,415,499
31 1,000
5,450,392
832,248
35,792
4,678,088
300,463,716
Page 7
282 78 18
134
238
Name: SUEZ Water ldaho lnc
BALANCE SHEET
For Year Ended:December 31 2017
LIABILITIES & CAPITAL Balance
Beginning
of Year
Balance
End of
Year
lncrease
or
DecreaseACCT #DESCRIPTION
1
2
3
4
5
6
7
8
I
10
11
12
13
14
15
16
17
1B
19
20
21
22
23
24
25
26
27
28
29
30
31
201-3 Common Stock
204-6 Preferred Stock
207-13 Miscellaneous Capital Accounts
214 AppropriatedRetainedEarnings
215 Unappropriated Retained Earnings
216 ReacquiredCapitalStock
218 Proprietary Capital
Total Equity Capital (Add Lines 1-5+7 less line 6)
221-2 Bonds
223 Advances from Associated Companies
224 Other Long- Term Debt
231 Accounts Payable
232 Notes Payable
233 Accounts Payable - Associated Companies
235 CustomerDeposits(Refundable)
236.11 Accrued Other Taxes Payable
236.12 Accrued lncome Taxes Payable
236.2 Accrued Taxes - Non-Utility
237-40 Accrued Debt, lnterest & Dividends Payable
241 Misc. Current & Accrued Liabilities
251 Unamortized Debt Premium
252 Advances for Construction
253 Other Deferred Liabilities
255.1 Accumulated lnvestment Tax Credits - Utility
255.2 Accum. lnvestment Tax Credits - Non-Utility
261-5 Operating Reserves (Pension & Benefits)
271 Contributions in Aid of Construction
272 Accum. Amort. of Contrib. in Aid of Const. **
281-3 Accumulated Deferred lncome Taxes
Total Liabilities (Add lines 9 - 29)
TOTAL LIAB & CAPITAL (Add lines 8 & 30)
*" Only if Commission Approved
1 261 750
81 7 835
81 12 754 4,818
163,820,339
2 367 ,477 7
1 267 718 394
836 60 871
1 012 3
4 746 173 188 84
4 928,738 6,131 ,339
71 114 48
10 774 162 13
113 741 9,422,652
1 7 3
6 901 1
118,315,139 13,509,892
1,261,750
81,437,835
85,939,102
168,638,687
3,686,214
1,224,323
6,445,898
769,495
4,557,326
1 1,060,077
663,874
10,412,787
123,164,135
(35,839,719)
5,680,622
',31,825,031
300,463,718
Page 8
13 78 18,328,240
Name: SUEZ Water ldaho lnc
STATEMENT OF RETAINED EARNINGS
For Year Ended: December 31 2017
1 Retained Earnings Balance @ Beginning of Year
2 Amount Added from Current Year lncome (From Pg 4, Line 32)
3 Other (Credits) / Debits to Account
4 Dividends Paid or Appropriated
5 Other Distributions of Retained Earnings
6 Retained Earnings Balance @ End of Year
81,120,754
9,197,419
(3,O04,473)
(1,374,598)
_q5,939,102_
CAPITAL STOCK DETAIL
No. Shares No. Shares
7 Descri n lass Par Value etc.Authorized Outstandin
Common $50.00 Par Value 50 000
DETAIL OF LONG.TERM DEBT
8 on
lnterest
Rate
None - Held Parent SUEZ Water Resources lnc
Year-end
Balance
lnterest
Paid
Dividends
Paid
1 374 598
lnterest
Accrued
25,235
Page 9
Name: SUEZ Water ldaho lnc
SYSTEM ENGINEERING DATA
For Year Ended: December 31 2017
1 Provide an updated system map if significant changes have been made to the system during the year
2 Water Supply.
Rated
Capacity
Type of
Treatment:
(None, Chlorine Annual
Production
Water
Supply
Source
(Well, Spring,
Pu
Fluoride
Filter etc.Desi ation or location
See attached Treatment
3 System Storage
Gal Surface
Type of
Reservoir Construction
(Elevated,Pres- (Wood, Steel
Concrete
Total
Capacity
000's
Gal.
Usable
Capacity
000's
Gal.e Desi nation or Location urized
See attached e
(Duplicate form and aftach if necessary. Asterisk facilities added this year.)
GPM
Page 10
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31 2017 04116118
SITE
NO.
PUMP
DESIGNATION Notes
WATER
SUPPLY
SOURCE
1 16TH ST 800 50,177 NaOCI ('12 to 15%), PO4 Ground Water
2 27TH ST 350 56,574 to1 Ground Water
J AMIry 700 194,283 NaOCI<1%, PO4 Ground Water
4 ARCTIC 700 43,958 NaOCI (12 to 15%), PO4 Ground Water
5 BALI HAI 2,400 88,807 , NaOCI <1%Ground Water
6 BEACON 600 NaOCI (12 to 15%)Out of service in 2017 Ground Water
7 BERGESON 700 NaOCI (12 to 15%)Out of service in 2017 Ground Water
a BETHEL 2,500 942,283 NaOCI <1%Ground WaterIBIF2501)4 Out of service in 2017 Ground Water
10 BROADWAY 1,000 243,638 NaOCI <1%Ground Water
11 BROOK HOLLOW 850 50,769 NaOCI (12 to 15%), PO4 Ground Water
12 BYRD NA 0 NaOCI (12 to 15o/o Out of service in 2017 Ground Water
'13 CASSIA 1 900 1 13,078 Ground Water
14 CASSIA 2 800 86.457 NaOCI <1%Ground Water
15 CENTENNIAL 750 185,669 NaOCI<'l%Ground Water
16 CENTRAL PARK 250 Retired in 2017 Ground Water
17 CHAMBERLAIN ,1 250 NaOCI (12 to '15%), PO4 Out of service in 2017 Ground Water
'18 CHAMBERLAIN 2 600 NaOCI (12 to 15%)Out of service in 2017 Ground Water
'19 CLIFFSIDE 800 '155,613 12lo 15%\Ground Water
20 CLINTON 1,300 157,566 NaOCI (12 to 15%). PO4 Ground Water
21 COLE 700 7s,698 NaOCI (12 to 15%) & ASR Ground Water
22 COUNTRY CLUB 800 118,774 NaOCI(12 to 15%)Ground Water
23 COUNTRY SQUARE '1,100 150,674 NaOCI (12 to 15%)Ground Water
24 COUNTRYMAN 500 NaOCI (12 to 15%)Out of service in 2Q17 Ground Water
25 DURHAM 200 78,194 NaOCI (12to 15%)Ground Water
26 EDGEVIEW 800 19,066 NaOCI 12lo 15%Ground Water
27 FISK 1,900 591,574 NaOCI (12 to 15%) GAC & ASR Ground Water
28 FIVE MILE 12 1,000 37,687 NaOCI ('12 to 15%)Ground Water
29 FLOATING FEATHER 3,000 675,749 NaOCI <1%Ground Water
30 FOX TAIL 1,000 279 NaOCI (12 to 15%), PO4 Fire Standby Ground Water
31 FRANKLIN PARK 1,200 268,375 NaOCI <1%Ground Water
32 FRONTIER 1 1,750 69,833 NaOCI ('12 to 15%), ASR Ground Water
JJ GODDARD 1 1,300 151,101 NaOCI <1%Ground Water
34 H.P 1,100 428,079 NaOCI <1%Ground Water
35 HIDDEN VALLEY 1 950 37,271 NaOCI <1%Ground Water
36 HIDDEN VALLEY 2 750 256,424 NaOCI 12 lo 15o/o Ground Water
37 HILLCREST 750 360,045 NaOCI<l%Ground Water
38 HILTON 1,400 431J28 Green Sand, NaOCI <1%Ground Water
39 HOPE Retired Ground Water
40 HUMMEL 600 NaOCI(12 to 15%), PO4 Out of service in 2017 Ground Water
41 IDAHO 375 NaOCI (12 to '15%), PO4 Out of service in 2017 Ground Water
42 ISLAND WOODS 1 800 102,357 NaOCI 12lo 15%Ground Water
43 ISLAND WOODS 2 800 8,946 NaOCI(12 to 15%)Ground Water
44 JR FLAT 450 144,856 NaOCI <12%Ground Water
45 KIRKWOOD 300 77,214 NaOCI (12 to 15%Ground Water
46 LA GRANGE 1,350 317,004 NaOCI <1%Ground Water
47 LICORICE 190 30,914 NaOCI(12 to 15%)Ground Water
48 LOGGER 750 121,590 NaOCI <1%Ground Water
49 LONGMEADOW 2s0 73,1 33 NaOCI (12 to 15%)Ground Water
50 MAC 1,200 54,328 NaOCI (12 to 15%). PO4 Ground Water
51 MAPLE HILL 1,800 404,397 Green Sand, NaOCI <1%Ground Water
52 MAPLE HILL 2 500 39,759 NaOCI<'l% ASR Ground Water
53 MARKET 700 69,559 NaOCI to rSR Ground Water
54 MCMILLAN 800 44.328 NaOCI (12 to 15%)Ground Water
55 OVERLAND Well 1,000 60,41s NaOCI<1%, PO4 Ground Water
56 PARADISE 500 38,442 NaOCI (12 to 15%)Ground Water
57 PIONEER 1,200 331,232 NaOCI <1%Ground Water
Page 10 Detail A Treatment (Page 1 of2)
RATED
CAPACITY PROD TYPE OF
TREATMENT
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31 2017 04t16t18
;OURCTRE
58 1,800 540,584 NaOCI<'l%PLEASANT VALLEY Ground Water
59 RAPTOR 1,000 26,877 NaOCI (12 to 15%)Ground Water
53,01760REDWOOD CREEK 1 1,800 NaOCI (12 to 15%)Ground Water
61 900 12,043 NaOCI (12 to 15%)Ground WaterRIVER RUN
oz ROOSEVELT 1 700 50,1 56 NaOCI <1%, PO4 Ground Water
bJ ROOSEVELT 3 600 146,854 NaOCI<1%,PO4 Ground Water
1,000 27,659 NaOCI (12 to 15%) & ASR64SETTLERS Ground Water
65 SHERMAN OAKS N/A (Out of Service)Retired Ground Water
66 SPURWING 2,000 1 NaOCI (12 lo 15o/o Fire Standbv Ground Water
67 SUNSET WEST 2,000 695,722 NaOCI <1%Ground Water
68 1 ,100 58,504 NaOCI (12 to 15%) GAC & ASRSWIFT 1 Ground Water
69 900 120,217 NaOCI (12 to 15%) GAC & ASR Ground WaterSWIFT 2
70 300 538 NaOCI <1%Ground WaterTAGGART 1
71 TAGGART 2 750 253,789 NaOCI <1%Ground Water
72 TEN MILE 1,000 92,541 NaOCI<'1%Ground Water
73 TERTELING 425 57,952 to Ground Water
265,64374VETERANS740 NaOCL <'l%Ground Water
AE 600 220,901 NaOCL <1%Ground WaterVICTORY
76 VISTA 450 202,478 NaOCI<1%, PO4 Ground Water
77 WARM SPRINGS 2 450 NaOCI 12to 15o/o Out of service in 2017 Ground Water
NaOCI (12 to 15%)Ground Water78WARM SPRINGS 3 600 Out of service in 2017
350 41,1 s6 NaOCL fi2lo 15o/o\Ground Water79WESTMORELAND
80 500 NaOCI (12 to 15%). PO4 Ground WaterWILLOW LANE 1
8't 370 24,093 NaOCI (12 to 15%)Ground WaterWLLOW LANE 2
82 300 29,638 NaOCI (12 to 15%)Ground WaterWILLOW LANE 3
1 Columbia WTP 4,170 1,258.773 Membrane Filtration, NaOCI <1%Surface Water
2 Marden WTP 12,700 2,691,316 Conventional Filtration, NaOCI <1 %Surface Water
14,907,749
Asterisk facilities added this year
Page 10 Detail A Treatment (Page 2 ot 2)
SITE
NO.
PUMP
DESIGNATlON
RATECI
CAPACITY
(GPMI
ANNUAL
PROD
{1000 GAL)Notes
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31,2017
Page 10 - 3. System Storage
04t16t18
1 Aeronca Tank 150 140 Boosted Steel
2 Arrowhead Tank 445 444 Both Concrete
3 30Arrowheadl Cleanrvell 29 Both Concrete
4 Arrowhead2 Clearwell 30 29 Both Concrete
5 Barber Tank 2,000 2,000 Both Steel
6 360Bogus Tank 350 Both Concrete
7 Boulder Tank 630 600 Both Concrete
8 Braemere Tank 200 200 Both Concrete
o 250Briarhill Tank 250 Both Concrete
10 Broken Horn Tank 662 657 Elevated Steel
11 Claremont Tank 1 90 90 Elevated Concrete
12 Claremont Tank 2 192 192 Elevated Concrete
13 Columbia Tank 3,000 1,500 Elevated Steel
14 Columbia WTP 2,000 1,750 Both Steel
15 Crestline Tank 300 300 Both Steel
16 Federal Tank 2,000 2,000 Boosted Steel
17 2,400Five Mile Tank 2,121 Boosted Steel
18 Good Street Tank 3,000 3,000 Both Steel
19 Gowen Tank 2,000 2,000 Both Steel
20 356**Harris Ranch North**356 Elevated Steel
21 Harris Ranch Tank 360 360 Elevated Concrete
22 Harvard Tank 150 150 Boosted Steel
23 2,000Hidden Hollow Tank 2,000 Both Steel
24 Hidden Springs Tank 347 347 Elevated Steel
25 200 200 Both ConcreteHighland View Tank 1
26 Highland View Tank 2 300 300 Both Steel
27 Hillcrest Tank 2,000 2,000 Boosted Steel
28 6,000 6,000 Both SteelHulls Gulch Tank
29 Lancaster Tank 50 50 Elevated Concrete
30 Marden WTP Clearwell 450 450 Boosted Concrete
3'1 North Mountain Tank 300 300 Elevated Steel
320 320 Elevated Concrete32Old Pen Tank
33 Quail Ridge Tank 326 325 Elevated Concrete
Boosted Steel34Steelhead Tank 3,000 2,900
35 Table Rock Tank 68 65 Elevated Concrete
92 90 Both Steel36Toluka Tank
Both Concrete37Upper Danmor Tank 750 750
38 Ustick Tank 2,000 1,900 Boosted Steel
38,808 36,515
Asterisk facilities added this year
Page 10 Detail B Storage
SITE
NO.
STORAGE
DESIGNATION
RESERVOIR
STORAGE
CAPACITY
(1,000 GALLONS)
AVAILABLE
CAPACIry
(1,000 GALLONS)
TYPE
Elevated
Boosted
Both
CONSTRUCTION
Concrete, Steel,
Wood
Name: SUEZ Water ldaho lnc
4 Pump information for ALL system pumps, including wells and boosters.
Designation or Location
7 Was your system designed to supply fire flows?
lf Yes: \Mat is current system rating?
8 How many times were meters read this year?
Horse
Power
Rated
Capacity
Discharge
Pressure
Energy
Used
This Year&of
See attached Pu & Boosters
** Submit pump curves unless previously provided or unavailable. Asterisk facilities added this year.
Attach additional sheets if inadequate space is available on this page.
Gross (in Million Gal.)
5 lf Wells are metered:
What was the total amount pumped this year?
What was the total amount pumped during peak month?
\Mat was the total amount pumped on the peak day?
14,912
2,493
84
6 lf customers are metered, what was the total amount sold in peak month?2,223
Yes
rso-3
6
During which Months?Meters are read every other month. There are two cycles, one set
of meters are read on even months, the other set on odd months
9 How many additional customers could be served with no system improvements
except a service line and meter?
How many of those potential additions are vacant lots?
10 Are backbone plant additions anticipated during the coming year?
lf Yes, attach an explanation of projects and anticipated costs
Sunset Peak Reservoir - $3,294,251. Will replace Highland View and Braemere water
storage facilities (aging facilities in poor condition). \Mll provide adequate peaking
storage for the service areas, and improved fire flow availability.
11 ln what year do you anticipate that the system capacity (supply, storage or distribution)
will have to be expanded?2019
Hillsboro Booster Station Replacement - will replace the existing Hillsboro Pump Station
with one that meets fire suppression capacity requirements. Redwood Creek Pipeline -
Will transmit additional source of supply to the existing Hidden Hollow tank from several
existing wells to the west. West Gowen Reservoir - Construct new tank to meet growth
demands in the West Gowen service area. Replace Arctic/Fairview booster - current
safety hazard, the existing pump facility in an underground vault will be abandoned and
the pump(s) relocated to the nearby Arctic well house building. 16th Street Well House -
Facility will be reconstructed, DEQ is requiring that the well head be reworked, the facility
is aging and in poor condition.
Page 11
1 000
1,000
Note: Estimates based on numerous assumptions, avg. count per discussion with IPUC Engineer
Yes
gpr il
SYSTEM ENGINEERING DATA
(continued)
ForYear Ended: December 31,2017
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31, 20'17
Pag€ II - 4.All SystemPumps(includingWells& Booslers)
04t16t1A
SITE #
1
TYPE
WELLPUMP
LOCATION
'16th Street Well Pump
PUMP TYPE
DVWertiGlTurbine 320 72
KWH USED
78,640
PROOUCTION
50.177
Treatment
NaOCI (12 to 15%). PO4
2 WELLPUMP 27th Street Wsll Pumo Submersible bU 350 442 65 '133.857 56.574 NaOCI f12 to '15%)
3 \A/ELLPUMP Amity Well Pump VSP DVWerticalTurbine 150 700 490 87 299 560 194 243 NaOCI <1%, PO4
4 V\ELLPUMP Arctic Well Pump D\AA/erti€lTurbine 100 700 JbU 80 84.600 43,958 NaOCI (12 to 15ok\. PO4
5 WELLPUMP Bali Hai Well Pump VSP DVWerticalTurbine 350 2,400 455 80 208.240 88,807 Green Sand. NaOCI <1olo
6 \A/ELLPUMP Beacon Well Pumo D\iWerti€lTurbine 600 335 65 3.383 NaOCI (12 to 15%)
7 WELLPUMP Beroeson Well Pumo Submersible 100 700 62 2 920 NaOCI l'12 to 15%)
8 \A/ELLPUMP Bethel Well Pump VSP DV1 /erti€lTurbine 200 2.500 223 60 1 02024O 942 243 NaOCI <1ol.
I WELLPUMP BIF Well Pump Submersible 40 250 450 57 3,797 NaOCI (12 to 15%), PO4
10 \A/ELLPUMP Broadwav Well Pump DWVert{€lTurbine 150 1,000 425 563.880 243.638 NaOCI <1%
11 WELLPUMP Brook Hollow Well Pump D\
^/erlicalTurbine
850 277 60 83.797 50.769 NaOCI (12 to 15Yo\. PO4
12 \A/ELLPUMP Cassia 1 Well PumD Submersible 100 900 310 60 317.520 't'13.078 NaOCI <1%. PO4
'13 WELLPUMP Cessia 2 Well Pumo VSP DVWerticalTurbine 800 404 60 a6 457 NaOCI <1 %
14 \^/ELLPUMP Centennial Well Pump D\ ruedimlTurbine 100 /5U 406 57 339.720 1 85,669 NaOCI <1%
15 WELLPUI\,1P Central Park Well PumD RETIRED IN 2O17
16 WELLPUN,lP Chamberlain 'l Well Pump DVWerticalTurbine 50 250 270 70 4 360 NaOCI t12 to 15olo) PO4
17 WELLPUI\4P Chamberlain 2 Well Pump DV1 /erticalTurbine 30 380 201 70 NaOCI (12 to'15%)
18 WELLPUI\,IP Cliffside Well Pumo VSP DVWerticalTurbine 50 500 60 148.57 4 155,613 NaOCI 112 to 15%)
19 WELLPUMP Clinton Well Pump DV!A/erticalTurbine 125 1 300 59 224',t20 1 57 565 NaOCI {12 to 1sold) PO4
20 \ /ELLPUI\,1P Cole Well Pumo DV1 /erticalTurbine 100 700 70 122.560 75,698 NaOCI (12 to 15%) & ASR
21 WELLPUMP Countrv Club Well Pumo DVWerti€lTurbine 125 800 46 1 93.760 114.774 NaOCI (12 to 15%)
22 \A/ELLPUMP Counlrv Souare Well Pumo VSP DVWerti€lTurbine 125 1.100 325 58 273.240 150.674 NaOCI ('12 to 15%)
23 \A/ELLPUMP Countryman Well Pump DV1 /erti€lTurbine 50 500 334 7 159 NaOCI (12 to 15%)
24 WELLPUMP Durham Well Pump Submersible 15 200 106 62 1 25,506 74,194 NaOCI (12 to 15%)
25 VVELLPUMP Edoeview Well VSP Submersible 75 800 430 60 5J.JZU '19.066 NaOCI (12 to 15%)
26 WELLPUMP Fisk Well Pump VSP D\ A/erti€lTurbine 200 1.900 317 59 1 078 180 591.574 NaOCI <1%
27 WELLPUMP Five Mile '12 Well Pumo OVWerti€lTurbine 75 1,000 230 55 78.040 37,687 NaOCI (12 to 15%)
28 WELLPUMP Floatino Feather Well VSP DVWerticlTurbine 450 3.000 470 63 1.265.600 675.749 NaOCI <1%
29 \AELtPUMP FoxtailWell Pump VSP OVWertiGlTurbine 125 '1,000 400 80 14,320 NaOCI (12 to 15o \, PO4
JU WELLPUN,IP Franklin Park Well Pumo D\ A/erticalTurbine 125 1.200 218 60 358.880 268.375 NaOCI <'1%
31 \ /€LLPUMP Frontier Well Pump VSP D\M/erticlTurbine 150 '1,750 250 58 129,420 69,833 laocl (12 to 150/6) PO4 & ASF
WELLPUI\,4P Goddard Well Pumo D\ A/erticalTurbine 150 '1,300 350 54 337 020 151,101 NaOCI <1olo
33 \^/ELLPUI\,IP Hidden Vallev 1 Well VSP DV1 /erticalTurbine 150 950 330 68 71.000 37.271 NaOCI <1%
34 \^iELLPUMP Hidden Valley 2 Well VSP D\ A/erticalTurbine 100 750 359 70 435 920 256.424 NaOCI 112 to 15%)
35 \ /ELLPUMP Hillcrest Well Pumo DVWerticalTurbine 100 750 388 1,049,520 360,045 NaOCI <1o/"
36 WELLPUMP Hilton WellVSP DVl /erticalTurbine 1,400 250 58 672.600 431.124 NaOCI <1 %
\ /ELLPUMP HP WellVSP DVlA/erti€lTurbine 150 '1 ,100 410 70 838.640 424.O79 Green Sand, NaOCI <1%
\^/ELLPUMP Hummel Well Pump DV1 /erticlTurbine 75 600 242 66 3.O77 NaOCI (12 to 15%). PO4
39 \A/ELLPUMP ldaho Well Pump D\ A/erti€lTurbine 375 68 5,840 NaOCl112to15%) PO4
40 WELLPUMP lsland Wood 1 Well PumD VSP Submersible 15 150 230 69 20.759 102.357 NaOCI ('12 to 15%)
41 WELLPUMP lsland Wood 2 Well Pump VSP Submersible 800 2AO '110 731 8.946 NaOCI (12 to'15o/")
42 VVELLPUMP JR Flal Well Pumo Submersible 100 450 543 71 382,940 144,856 NaOCI <12%
43 WELLPUMP Kirkwood Well Pump DV\ruerticalTurbine 40 300 260 66 90 029 77.214 NaOCI('12 to 15%)
44 \AELLPUMP La Granoe Well Pumo DVWerti€lTurbine 150 1,350 60 566.640 31 7,004 NaOCI <1%
45 WELLPUIUP I icorlce Well Pumo Submersible l5 190 180 62 45,364 30,91 4 NaOCI(12 to 15%)
V\ELLPUMP Loooer Well Pump DVl ,/erti€lTurbine 150 700 463 67 279.000 '121.590 NaOCI <1%
47 WELLPUMP Lonomeadow Well Pump DVWerticalTurbine 50 250 303 50 157 520 NaOCI 112 to 15%)
4A VlELLPUMP MAC Well Pumo DVwerti€lTurbine 150 '1.200 79 107.160 54,32A NaOCI 112 to 150/61 PO4
49 WELLPUMP Maole Hill 1 Well Pumo VSP D\ A/erticalTurbins 200 '1,800 377 70 709.200 404,397 Green Sand, NaOCI <1%
50 \AELLPUMP Maple Hill 2 Well Pump VSP DVwerticalTurbine 60 500 328 70 39,759 NaOCI <1 % ASR
5'r WELLPUI\4P l\,larket Well Pump DV\A/erticalTurbine 125 700 553 69 1 69 360 69.559 NaOCI 112 to 15%) & ASR
\AELLPUMP McMillan Well Pumo DVWerticlTurbin6 100 800 80 83,600 44,328 NaOCI ('12 to 15%)
53 WELLPUMP Overland Well Pump DVWerticalTurbine 100 1.000 290 69 130.877 60,4'15 NaOCi <1% P04
54 \A/ILLPUMP Paradise Well Pumo Submersible 40 500 235 65 74,503 38,442 NaOCI (12 to'15%)
55 WELLPUMP Pioneer Well Pump DV1 /erticalTurbine 300 1.200 780 65 '1 .190.000 331,232 NaOCI <1%
56 WELLPI.]N,lP Pleasant Vallev Well Pumo DV1 /erticalTurbine 500 '1,800 774 2,1 1 1,600 540 584 NaOCI <'l%
57 WELLPUMP Raptor Well Pump DV1 /erti€lTurbine 300 '1,000 775 87 '110,400 26,477 NaOCI (12 to 15%)
58 \ /ELLPUMP Redwood Creek Well Pump VSP Submersible 200 1.800 334 65 119.520 53,01 7 NaOCI (12 to 15%)
VVELLPUMP River Run WellVSP Submersible 100 900 370 65 29 080 12.O43 NaOCI (12 to 15%)
60 \A/ELLPUMP Roosevelt 1 Well Pumo DVWerticalTurbine 50 700 230 55 273,800 50.1 56 NaOCI <1%. PO4
61 \A/ELLPUMP Roosevelt 3 Well Pump OVlNerticlTurbine ta 600 344 55 146,854 NaOCI <1% PO4
62 \AELLPUMP Settlers Well Pump DV1 /erticalTurbine 100 1,000 270 56 47.',|13 27,659 NaOCI (12 to 15%) & ASR
63 \A/ELLPUMP Sherman Oaks Well Pumo N/A (Out of Seruice)
64 WELLPUMP SpuMinq Well Pump VSP D\iwerticalTurbine 150 2,000 246 80 1 9,360 1 NaOCI ( 12 to 15%)
Page l1 Detail Pumps & Boosters (Page 1 of 4)
HP
RATED
GPM TT'II
10n Rna
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
Oecember 31, 2017
Page l l - 4. All System Pumps (including Wells & Boostore)
04t16118
SITE #TYPE LOCATION HP
RATED
GPM TDI{DPSI KWH USED PRODUCTION Taeatment
65 WELLPUMP Sunset West Well VSP D\AA/erti€lTurbine 250 2 000 339 68 1 434 AO0 695.722 NaOCI <1 %
66 WELLPUMP Switt 1 Well Pump VSP D\AA/erti€lTurbine 125 1 ,100 363 bb 274.640 58,504 NaOCI (12 to 150/6) GAC & ASF
\A/ELLPUMP Swift 2 Well Pump VSP DVWerticalTurbine 100 900 342 66 120.217 NaOCI (12 to 15%) GAC
68 WELLPUMP Taooart I Well Pumo DV1 /erti€lTurbine 50 300 420 55 502.680 538 NaOCI <1%
69 \A/ELLPUMP Taqqart 2 Well VSP DVWerti€lTurbine 750 450 253 749 NaOCI <1016
70 \A/ELLPUMP Ten Mile Well Pump D\M/erti€lTurbine 300 1 000 7'to 54 378 8AO 92,541 NaOCI <'l%
71 WELLPUMP Tertelino Well PumD Submersible 425 500 69 177.486 NaOCI (12 to 150/6)
72 WELLPUMP Veterans Well Pumo DVWerti€lTurbine 75 740 290 bU 493,380 265.e3 NaOCL <1%
73 \A/ELLPUMP Victorv Well VSP DVl /erticalTurbine 60 600 320 55 360.924 220.901 NaOCL <'l%
74 WELLPUMP Viste Well Pumo OVWerti€lTurbine 450 430 50 465.480 202.478 NaOCI <1%. PO4
75 \A/ELLPUI\4P Warm SDrinqs Mesa 2 Well Pump DV1 /erticalTurbine 450 136 4 A4A NaOCI (12 to 15o/o)
76 \A/ELLPUMP Warm SDrinos Mesa 3 Well Pumo DVl /ertimlTurbine '10 600 490 136 3,183 NaOCI (12 to 15olo)
77 WELLPUI\4P Westmoreland Well Pumo DVWerticalTurbine 50 350 260 50 63.945 41. 1 56 NaOCL (12 to 15%)
7A \AiELLPUMP Wllow 1 Well Pumo DVl /6rticlTurbine 40 500 340 3.960 NaOCI (12 to 15%). PO4
79 WELLPUMP VMllow 2 Well Pump DVlA/erti€lTurbine 50 370 235 69 7A O54 24 093 NaOCI 112 to 15oi6)
80 \A/ELLPUMP VMllow 3 Well Pumo DV1 /erticlTurbine 40 300 zb!69 29.638 NaOCI('12 to 15%)
COLUMBIA WTP COLUMBIA PUMP RIVER 3 235 172
83 Raw Water #1 lntake SS VTRB 500 2800 535 205
84 Raw Water #2 lntake SS WRB 500 2800 535 205
85 Raw Water #3 lntake SS VIRB 500 2800 535 205
COLUMBIA TRTMNT PLANT '1,469,676 1,25A,773
86 FINISHWATER Columbia WTP VSP 1 SS VTRB 75 1 050 85
87 FINISHWATER Columbia WTP VSP 2 SS VTRB 1050 85
88 FINISHWATER Columbia WTP VSP 3 SS VTRB 200 2800 85
89 FINISHWATER Columbia WTP VSP 4 SS WRB 200 2800
MARDEN WTP MARDEN TRTMNT PLANT 3.107.572 2.691.316
90 Raw Water #1 Rannev SUBM 50 1750 80 30
91 Raw Water #2 Rannev SUBM 40 '1000 54 30
Raw Water #3 Ranney SUBM 90 2800 70 30
Raw Water #'l lntake SS WRB 15 1 390 28 30
94 Raw Water #2 lntake SS VTRB 30 2775 26 30
95 Raw Water #3 lntake SS VTRB 30 2775 28 30
96 Raw Water #4 lntake SS VTRB 2775 2A JU
97 Raw Water #5 lntake SS VTRB 50 4166 3'1 30
98 FINISHWATER Marden WTP 7'10 VSP SS VTRB 75 2777 170 63
99 FINISHWATER Marden WTP 720 Pump SS VTRB 750 2777 170 63
100 FINISHWATER Marden WTP 730 Pump SS VTRB 750 170 63
101 FINISHWATER Marden WTP 740 VSP SS VTRB 250 4166 170 63
102 FINISHWATER Marden WTP 750 Pump SS VTRB 250 41 66 200 85
TOTAL PUMPS 't3,670 '| 23,013 3t,358 6,478 29.494,086 14,907.749
Filkation. NaOCI <1'
Filtration, NaOCI .
PUMP TYPE
SSVerticleTurbine
HP qPM
1.000
TDH
200
DPSI
95 91,972
KWH USED PRODUCTIONSITE *
1
TYPE
BOOSTER 36th Street Booster #1 VSP
LOCATION
SSV6rticleTurbine 75 1.000 200 952BOOSTER36th Str€et Eooster #2 VSP
End Suc Centriluoal 200 183 52 1 8.753BOOSTERAeron€ Booster Pump 1
4 EOOSTER Aeronca Booster PumD 2 End Suc Centrifugal 50 800 183
BOOSTER SSVerticleTurbine 40 2,500 184 80 149,145Arctic Booster
SSVerlicleTurbine 40 450 162 50 77 5966BOOSTERArrowhead 1 Booster #'l VSP
25 450 162 5o7BOOSTERArrowhead 1 Booster #2 VSP SSVerticleTurbine
SSVerticleTurbine 50 900 162 508BOOSTERArrowhead 1 Booster #3 VSP
90 9409BOOSTERArrowhead 2 Booster #1 VSP SSVerticleTurbine 40 450 248 95
SSVerticieTurbine 40 450 248 9510BOOSTERArrowhead 2 Booster #2 VSP
900 248 9511BOOSTERArowhead 2 Booster #3 VSP SSVorticleTurbine
49 800End Suc Centrifuqal 150 '1,500 260 9012BOOSTERBarbar Booster Pump 1
End Suc Centrifuoal 150 1.500 90'13 BOOSTER Barber Booster Pump 2
7.5 150 140 75 21.44614BOOSTERBluffs Booster #1 End Suc Centrifugal
500 140 7515BOOSTERBluffs Booster #2 End Suc Centrifuqal 25
End Suc Centrifuoal 25 500 140 t)16 BOOSTER Bluffs Booster #3
30 1.000 11.41417BOOSTERBoise Avenue Pump VSP End Suc Centrifugal
250 138 60 41.13618BOOSTEREoulder Booster #1 VSP End Suc Centrifuoal 15
Page 11 Detail Pumps & Boosters (Page 2 ol 4)
PUMP TYPE
I
I
PUC ANNUAL REPORT
SUEZ Wster ldaho lnc
December 31, 2017
Pago I1 - 4. All Systom Pumps (lncluding Wells & Boosters)
04t16118
Treatment
'19
SrTE #WPE
BOOSTER 15
HP
250
DPSI
60
KWH USED PRODUCTION
20 BOOSTER End Suc Centrifuoal 20Boulder Booster #3 VSP 500 130 55
21 BOOSTER -Boulder Booster #4 VSP SSVerticleTurbine 40 '1.500 200 74
22 BOOSTER Braemere Booster #'l VSP SSVerticleTurbine 75 '1.000 215 99 000
BOOSTER Braemere Eooster #2 VSP SSVerticleTurbine 1 000 215
24 SSVerticleTurbineBOOSTERBraemere Booster #3 VSP 40 500 215 83
BOOSTER Braemere Booster #4 VSP SSVerticleTurbine 20 250 '190 83
26 BOOSTER Briarhill Booster #1 VSP End Suc Centrifuoal 75 900 ,4,150 1 37 580
BOOSTER Briarhill Booster #2 VSP End Suc Centrifuoal 900 292 150
2A BOOSTER End Suc CentrifuoalBriarhill Booster #3 VSP 900 150
BOOSTER Broken Horn Booster #1 VSP SSVerticleTurbine 1,000 365 '165 126.240
30 BOOSTER Broken Horn Booster #2 VSP SSVerticleTurbine 125 1,000 365 165
31 BOOSTER Broken Horn Booster #3 VSP SSVerticleTurbine 125 1.000 365 165
32 BOOSTER Broken Horn Booster CONTROL BLDG NA NA NA NA 2 515
33 BOOSTER End Suc Centrifuoal 100 600Brumback Booster #1 VSP 380 150 232,640
34 BOOSTER Brumback Booster #2 VSP End Suc Centrifuqal '100 600 380 150
BOOSTER Cartwrioht Booster #1 VSP End Suc Centrifuqal 60 325 380 120 '1 13 540
36 BOOSTER Cartwriqht Booster #2 VSP End Suc Centrifugal 60 325 380 120
37 BOOSTER Council Sorinos Booster #1 '*'SSVerticleTurbine bU 465 384 165 5 392
3B SSVerticleTurbine 60 465BOOSTERCouncil Sprinqs Booster #2 *384 165
39 BOOSTER Crestline Booster #1 End Suc Centrifuqal 40 420 230 90 71.579
40 BOOSTER Crestline Booster #2 End Suc Centrifuqal 40 420 230 90
41 BOOSTER ln-lino Centrifuoal 100 1 500 190 60 1 15 200Federal Eooster #1
42 lnJine Centrifuoal 100BOOSTERFederal Boosier #2 VSP '1,500 190 60
43 BOOSTER Five Mile Booster VSP 1 SSVerticleTurbine 40 500 207 78 1 09.600
44 BOOSTER Five Mile Booster VSP 2 SSVerticleTurbine 100 1,5@ 78
45 BOOSTER Five Mile Booster 3 SSVerticleTurbine 100 1.500 207 78
SSVerticleTurbine 10046BOOSTERGood Street Eooster #1 VSP 4,500 63 25 119,476
47 BOOSTER Good Street Booster #2 SSVerticleTurbine 125 2.500 159 75
48 BOOSTER Good Street Booster #3 SSverticleTurbine 2,500 159 75
49 BOOSTER Good Street Booster #4 VSP SSVerticleTurbine 40 700 189 75
End Suc Centrifuoal50BOOSTERGowen Boosler VSP 1 40 1,000 110 66 2.424
5'1 BOOSTER Gowen Booster VSP 2 End Suc Centrifuqal 50 1,500 110 66
BOOSTER Gowen Booster VSP 3 End Suc Centrifuoal 340 150
53 End Suc Centrifuoal 10 300 95BOOSTERHarris Ranch Booster #1 44,317
54 BOOSTER Harris Ranch Booster #2 End Suc Centrifuoal 30 700 95 65
BOOSTER Harris Ranch Booster #3 End Suc Centrifuoal JU 700 95 65
56 BOOSTER Haruard Booster Pumo 1 End Suc Centrifuqal 20 350 90 85 14.724
End Suc Centrifuoal 20 350 90 85BOOSTERHaruard Booster Pump 2
20058BOOSTERHidden Hollow 1 Pump SSVerticleTurbine 1,000 575 220 574.920
59 BOOSTER Hidden Hollow 2 Pumo SSVerticleTurbine 200 '1,000 575 220
60 BOOSTER SSVerticleTurbine 200 I 000 575 220Hidden Hollow 3 Pump VSP
61 BOOSTER Hiohland View #1 VSP End Suc Centrifuoal 40 600 180 67 1 1 3,600
62 BOOSTER Hiohland View #2 VSP End Suc Cenlrifuoal 40 600 180 67
63 End Suc Centrifuoal 100 1 200 180 67BOOSTERHiqhland View #3
64 BOOSTER Hilltrest Booster VSP 1 SSVerticleTurbine 1,500 151 b5 ln Hillcrest Well
65 BOOSTER Hilltrest Booster VSP 2 SSVorticleTurbine 125 3.000 118
66 BOOSTER SSVerticleTurbine 125 3.000 'l'18Hillcrest Booster VSP 3
67 SSVerticleTurbin6 125 3 000 118BOOSTERHillcrest Booster VSP 4
68 BOOSTER Hillsboro Booster #1 SSVerticleTurbine 50 600 245 104 45.760
69 BOOSTER Hillsboro Booster #2 VSP SSVerticleTurbine 75 900 245 104
70 BOOSTER End Suc Centrifuoal 20 300 170 104Hillsboro Emsler #3 VSP
50 800 105 5 01571BOOSTERHilo Booster VSP End Suc Centrifugal
72 BOOSTER Hulls Gulch #'1 SSVerticleTurbine 125 1.400 2s8 112 338.560
125 1 400 25A 11273BOOSTERHulls Gulch #2 SSVerticleTurbine
74 BOOSTER Hulls Gulch #3 SSVerticleTurbine 125 1,400 258 112
End Suc C€ntrifuoal 75 900 192 135 231.64075BOOSTERLower Danmor Booster #1 VSP
76 BOOSTER Lower Oanmor Booster #2 VSP End Suc Centrifuoal 75 900 192 135
77 BOOSTER End Suc Centrifuqal 75 900 192 135Lower Danmor Booster #3 VSP
End Suc Centrifuoal 50 900 150 105 5 8047ABOOSTERMicron Booster VSP 1
79 BOOSTER Micron Booster 2 End Suc Centrifuqal 20 340 150 105
80 BOOSTER Micron Booster 3 End Suc Centrifuoal tc 1,700 165 105
End Suc Centrifuoal 15 250 150 88 31,9508'1 BOOSTER North Mountain #1
600 120 8882BOOSTERNorth Mountaan #2 End Suc Centrifuqal
Page 11 Detail Pumps & Boosters (Page 3 of 4)
PUMP TYPE
RATED
GPM TDH
Fnd Slrc CentrifLroal 13t
I
t---
Page II - 4.All SystemPump3(includingWalls& Boosters)
0/.l16t't8
Asterisk facilities added this year
Annual Report on Delered Powsr Cost will show 33,51 9,121 kv\rh, differ€n€ due to PRVs and monitoring stations classified together with Boosters, and facilities out of serie.
Treatment
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31, 2017
DPSI
70
.l rF{TYPE
BOOSTER End Suc Centrfuqal
PUMP IYPE
15
HP
150
TDH KWH USED
783
PRODUCTION
u EOOSTER Ouail Booster #1 VSP SSVertic16Turbine 100 800 343 151 76 224
85 SSverticleTurbine 100 800 343 151EOOSTERQuail Booster #2 VSP
End Suc Cantrifuoal 75 3 00086BOOSTERRooer Heiohts 1 VSP 100 45 123.920
BOOSTER Rooer Heiohts 2 Pumo End Suc Centrifuoal 3,000 100 45
BOOSTER Rooer Heiohts 3 Pumo End Suc Centrifuqal 75 3.000 100
89 End Suc Centrifuoal 200 2AO 166 ln Rooer Hts BstrBOOSTERSomerset Booster 1
End Suc Centrifuoal 100 1 000 2AO 15690BOOSTERSomerset Booster 2
91 BOOSTER Steelhead Booster #1 End Suc Centrifuoal 500 60 I 03.760
BOOSTER Steelhead Booster #2 VSP End Suc Centrifuqal 60 1,500 60
93 EOOSTER Steelheed Booster #3 End Suc Centrifuoal 100 2.500 135 60
94 BOOSTER Sunvi6w Booster End Suc Centrifuoal 60 750 145 101 8.199
SSverticleTurbine 40 800 101 1 152BOOSTERTECHNOLOGY BOOSTER VSP
5096BOOSTERToluka Booster #1 VSP End Suc Centrifuqal 500 240 81 127,A40
97 BOOSTER Toluka Booster #2 VSP End Suc Centrifuqal 50 500 240 8'1
98 End Suc Centrifuoal 50 500 240 81BOOSTERToluka Booster #3 VSP
50 300 300 164 ?4099BOOSTERUooer Danmor Boostsr #1 ln-line Centrifugal '104
100 BOOSTER [rooer Danmor Booster #2 ln-line Centrifuoal 50 300 300 't04
End Suc Centrifuoal 150 1 200 300 104101BOOSTERUpper Danmor Booster #3 VSP
102 BOOSTER ustick Booster #1 End Suc Centrifuqal 75 1.500 164 65 1 1 8,080
End Suc Centrifuoal 75 1.500 164 65103BOOSTERUstick Booster #2
104 BOOSTER Ustick Booster #3 VSP End Suc Centrifuqal 30 500 65
105 BOOSTER Warm Sorinos Booster #1 VSP End Suc Centrifugal 100 600 '155 195,680
106 End Suc Centrifugal 100 buu 155BOOSTERWarm Springs Booster #2 VSP
7,228 106,100 22,783 't0,023 4,017,654TOTAL BOOSTERS
TOTAL PUMPS & BOOSTERS 20,898 229,113 54,141 16,501 33,511,750 14,907,749
Page '11 Oetail Pumps & Boosters (Page 4 of 4)
RATED
GPMLOCAfTON
Old Ppn B66ster
Name: SUEZ Water ldaho lnc
SYSTEM ENGINEERING DATA
(continued)
For Year Ended:December 31 2017
FEET OF MAINS
1 Pipe
ln Use lnstalled
Beginning DuringofYear Year
Abandoned
During
Year
GIS Adjustments
During
Year *
ln Use
End of
YearSize
36"587
30"11,165
24"7
20"091
18"3,385
16"251
14"7,492
12"553
10"52,'163
8"118
o 1,523,922
4"
3"5,493
2"2.5"
314"1"1.25"., 1.5"
TOTAL 801
1,288.25. GIS adjustments include
CUSTOMER STATISTICS
ThiS
Year
Last
Year
This
Year
Last
Year
2 Metered:2A Residential28 Commercial2C lndustrial
81 925
077 317
3
3A
3B
3C
4
5
6
7
I
Flat Rate:
Residential
Commercial
lndustrial
Private Fire Protection
Public Fire Protection:
Street Sprinkling (included in other)
Municipal, Other 63
Other Water 33 771
587 (0)
'11,165 0
76,405 2,480 (2)
10,107 4 (18)(3)
3,385 (0)
247,491 4,141 (71\
8,204 228 (951)11
1,524,631 34,718 (3,524\(2,176)
52,614 36 (486)
(4,523)2,896,424 53,935 (5,717)
1,532,960 421 (4,464)(4,994)
205,938 638 (2,053)(691)
5,483 2 I
156,955 145 (2,299)(420)
5,466 31 (517)260
6,737,815 96,780 (19,543)('t 3,087)
MILES
80,761 8,901,690
8,920 4.853. 1 14
24
1,96s
62 55,801
38 36,323
91,770 13,846,929TOTALS (Add lines 2 through 8)
Page 12
1 741 116
5.
CERTIFICATE
State of ldaho
County of Ada
WE, the undersigned Greqorv P. Wvatt. Vice President
and Jarmila M. Carv, Director of Finance
of the SUEZ Water ldaho lnc.
utility, on our oath do severally say that the foregoing report has been prepared under our direction,
from the original books, papers and records of said utility; that we have carefully examined same, and
declare the same to be a correct statement of the business and affairs of said utility for the period
covered by the report in respect to each and every matter and thing therin set forth, to the best of our
knowledge, information and belief.
{\ [ h, e,^,
Subscribed and Sworn to Before Me
this of ,'/
(Notary Public)
Residing at:la)""; J,'an z%
th 2018
-a-Pualrc
OF
My Commission Expires .s/S/ao)/
I,t'ffiv
,;;
T{J
Report lD: RLREG060
Layout lD: RLREG060
Business Unit: 00060
Period Ending: Oec 3'1, 2017
Run on 03/07/18 at 05r,18 PM
SUEZ Water ldaho
General Ledger System
Rolling Regulatory l/S
12
Months
Ending
Current Year
12
Months
Ending
Prior Year
lncrease /
(Decrease)
401 00461
401 05461
401 06461
401 10461
40111461
40140462
40120461
40121461
40145463
40200471
40205472
40245471
40300474
40301474
501 00000
s01 00600
501 00601
501 00603
501 0061 4
501 00620
501 00622
501 00624
s01 00630
501 00633
501 00640
501 00642
501 00643
501 00651
501 00660
501 00662
501 00665
501 00670
s01 05600
501 05601
5010561 1
501 056 1 6
501 05620
501 05624
501 05631
501 05632
50'105633
501 05642
501 05643
501 05651
501 05652
501 05660
501 05661
501 05662
s0'105663
General Sales
460.0-Unmetered Water Revenue
Meter Sale-Residential consump
Meter Sale-Residential facili
461.1-Residential
Meter Sale-Commercial consump
Meter Sale-Commercial facility
461.2-Commercial
Private Fire protection facili
462.0 -Fire Protect Rev-Private
Meter Sale-public auth consump
Meter Sale-public auth fac
Public Fire protection facilit
Miscellaneous service revenue
Rents from water property
Turn on fees
Reg Unbill consumption revenue
Reg Unbill facility charge rev
464.O-Other Revenue
400 - Total Revenue
Total Operating Revenue
Supv Labor-ES
Supv Lbr-SOS Ops Sup & Eng
Supv Lbr-SOS Ops Lbr & Exp
Supv Lbr-SOS Ops Misc
Supv Lbr-SOS Maint Wlls&Spr
Supv Lbr-Pump Ops Sup & Eng
Supv Lbr-Pump Ops Pwr Prd Lbr
Supv Lbr-Pump Ops Lbr & Exp
Supv Lbr-Pump Maint Sup&Eng
Supv Lbr-Pump Maint Equip
Supv Lbr-Wtr Tmt Ops Sup&Eng
Supv Lbr-Wr Tmt Ops Lbr&Exp
Supv Lbr-\Mr Tmt Ops Misc Exp
Supv Lbr-Wtr Tmt Maint Strct
Supv Lbr-T&D Ops Sup&Eng
Supv Lbr-T&D Ops Line Exp
Supv Lbr-T&D Ops Misc Exp
Supv Lbr-T&D Maint Sup &Eng
Drct Lbr-SOS Ops Sup & Eng
Drct Lbr-SOS Ops Lbr & Exp
Drct Lbr-SOS Maint Strctrs
Drct Lbr-SOS Maint Sply Mains
Drct Lbr-Pump Ops Sup & Eng
Drct Lbr-Pump Ops Lbr & Exp
Drct Lbr-Pump Maint Strctrs
Drct Lbr-Pump Maint Pwr Prd
Drct Lbr-Pump Maint Equip
Drct Lbr-\Mr Tmt Ops Lbr&Exp
Drct Lbr-Wr Tmt Ops Misc Exp
Drct Lbr-Wtr Tmt Maint Strct
Drct Lbr-Wtr Tmt Maint Equip
Drct Lbr-T&D Ops Sup&Eng
Drct Lbr-T&D Ops Storage Faclt
Drct Lbr-T&D Ops Line Ex
Drct Lbr-T&D Ops Meter Exp
Page 1 of 6
48,899,313.31 49,822,39s.76
4,',t08.32
4,',t08.32
21,639,786.60
11,296,787.69
32,936,574.29
11,765,052.75
2,527,797.19
14,292,849.94
1,'t28,171.63
't,'t28,171.63
140,078.26
35,343.32
3,545.63
12,840.00
9,622.92
25,180.00
274,011.00
36,988.00
537,609.'l 3
48,899,313.31
13,231.32
't3,231.32
22,805,335.2',1
10,923,731.5',1
33,729,066.72
12,136,774.18
2,466,942.48
'14,603,716.66
1,081,045.57
1,081,045.57
158,926.56
32,860.65
3,340.28
10,600.00
8,925.00
34,I 75.00
6,311.00
140,197.00
395,335.49
49,822,395.76
(9,123.00)
(9,1 23.00)
(1,165,548.61)
373,056.1 8
(792,492.43\
(371,721 43)
60,854.71
(310,866.72)
47,126.06
47,126.06
(18,848.30)
2,482.67
205.35
2,240.00
697.92
(8,99s.00)
267,700.00
(103,209.00)
142,273.64
(923,082.45)
(923,082.45)
23,012.69
(2,612.59)
(8,413.97)
(7,126.53)
(68,047.49)
12,433.71
2,475.74
(10,119.73)
(2,102.20)
4,264.12
(2,0't3.77)
(2,427.02)
(42,871.83)
158.91
17,593.91
(6,066.71)
(1 9,1 06.68)
(33.27)
(1 ,635.1 8)
(237.76\
4,149.84
(261 .1 0)
165.00
25,526.67
2,202.90
(242.72)
81,901.45
(40,183.55)
1,510.20
10,339.46
(16,251.70)
(871.31)
(331.80)
(67,502.89)
(39,685.29)
7,576.78
35,133.70
54,493.19
7,126.53
100,452.18
12,01't.25
0.00
124,357.34
7,625.06
0.00
17,',144.06
40,896.93
0.00
0.00
21 ,292.41
75,441.94
0.00
4,022.08
1,421.09
237.76
24,862.37
261.10
(55.00)
441,471.49
14,302.57
242.72
160,221.15
399,021.51
0.00
37,979.1 5
50,379.20
1,349.18
331.80
359,457.79
'194,852.85
30,589.47
32,52',t.11
46,079.22
0.00
32,404.69
24,444.96
2,475.74
114,237.61
5,522.86
4,264.',tz
15,'130.29
38,469.91
(42,87',t.83)
158.91
38,886.32
69,375.23
(19,106.68)
3,988.81
(214.09)
0.00
29,012.21
0.00
1 10.00
466,998.16
16,505.47
0.00
242,122.60
358,837.96
1,510.20
48,318.61
34,127.50
477.87
0.00
291,954.90
155,167.56
Layout lO: RLREG060
Buslness Unlt: 00060
Period Endlng: Dec 3'1,2017
on 03/07/'18 at 05:48 PM
501 05665
501 05672
501 05673
50't05675
501 05676
50'105677
501 05678
501 1 5675
501 20000
501 20601
50'120614
50120624
501 20643
501 20660
501 20665
501 25633
501 25665
501 2s678
SUEZ Water ldaho
G6neral Ledgor System
Rolling Regulatory l/S
12
Months
Ending
Current Year
12
Months
Ending
Prior Year
lncrease /
(Decrease)
501 00901
501 00902
501 00903
501 05902
501 05903
501 20901
501 20902
501 20903
s01 00920
501 00930
501 00932
501 05920
501 05932
501 1 0920
501 1 0930
501 20920
501 25920
Drct Lbr-T&D Ops Misc Ex
Drct Lbr-T&D Maint Rsrvrs&Stn
Drct Lbr-T&D Maint - Main
Drct Lbr-T&D Maint - Services
Drct Lbr-T&D Maint - Meters
Drct Lbr-T&D Maint - Hydrants
Drct Lbr-T&D Maint -Misc Plnt
D L T-T&D Maint - Services
S L T out-ES
S L T out-SOS Ops Lbr & Exp
S L T out-SOS Maint Wls&Spr
S L T out-Pump Ops Lbr & Exp
S L T out-\Mr Tmt Ops Misc Exp
S L T out-T&D Ops Sup&Eng
S L T out-T&D Ops Misc Exp
D L T ouFPump Maint Equip
D L T out-T&D Ops Misc Ex
D L T out-T&D Maint -Misc Plnt
601.1-6 - Labor - Oper & Maint
Supv Lbr-Cust Acct Suprvsn
Supv Lbr-Cust Acct Mtr Rdng
Supv Lbr-Cust Acct Rcrds&Coll
Drct Lbr-Cust Acct Mtr Rdng
Drct Lbr-Cust Acct Rcrds&Coll
S L T out-Cust Acct Suprvsn
S L T out-Custr Acct Mtr Rdng
S L T out-Cust Acct Rcrds&Coll
601,7-Labor Cust Accounts
Supv Lbr-A&G Ops Salaries
Supv Lbr-A&G Misc Gen Exp
Supv Lbr-A&G Maint Plnt
Drct Lbr-A&G Ops Salaries
Drct Lbr-A&G Maint Plnt
S L T-A&G Ops Salaries
S L T-A&G Ops-Misc Gen
S L T out-A&G Ops Salaries
D L T out-A&G Ops Salaries
601.8-Labor - Admin & General
F B T-ES
F B T-SOS Ops Sup & Eng
F B T-SOS Ops Lbr & Exp
F B T-SOS Ops Misc
F B T-SOS Maint Strctrs
F B T-SOS Maint Wls&Spr
F B T-SOS Maint Sply Mains
F B T-Pump Ops Sup & Eng
F B T-Pump Ops Pwr Prd Lbr
F B T-Pump Ops Lbr & Exp
F B T-Pump Maint Sup&Eng
F B T-Pump Maint Strctrs
F B T-Pump Maint Pwr Prd lmprv
F B T-Pump Maint Eq
F B T-Wtr Tmt Ops Sup&Eng
F B T-Wtr Tmt Ops Lbr&Exp
F B T-Wtr Tmt Ops Misc Exp
F B T-Wtr Tmt Maint Strct
F B T-Wr Tmt Maint Equip
F B T-T&D Ops Sup&Eng
F B T-T&D Ops Storage Faclt Ex
F B T-T&D Ops Line Ex
F B T-T&D Ops Meter Exp
F B T-T&D Ops Misc Ex
F B T-T&D Maint Sup & Eng
F B T-T&D Maint Rsrvrs&Stn
64,922.95
100.20
173,302.84
148,025.36
32,320.18
33,01 7.1 I
2,421 .27
(1,147.20)
(7,576.78)
238.00
(78,169.00)
(3,386.00)
0.00
1,079.00
0.00
1,313.55
(62,075.67)
(1,313.55)
2,496,982.51
76,341 .13
61.03
139,469.62
256,408.61
538,1 86.1 9
444.00
0.00
(274.00)
1,010,636.58
1,702,945.08
(480.77)
3,109.71
1,030,990.85
9,351.09
0.00
0.00
(853,981.70)
(959,344.63)
932,589.53
(3,438,948.1 9)
21,007.98
31,241.60
3,370.76
14,322.85
10,780.32
151 .97
6,647.75
0.00
297,051.03
4,014.98
7,383.99
182.76
9'1,122.15
9, t70.40
231,499.83
0.00
21,280.02
26,637.61
1't,873.98
205.21
234,1 60.95
100,849.08
989.39
2,121.50
50.98
0.00
(5,907.76)
169,255.99
164,414.82
13,790.94
20,458.18
26,212.64
2,676.80
(30,589.47)
(238.00)
(4,1 15.00)
(1,198.00)
4,582.08
(9,299.00)
9,007.07
(26,378.54)
0.00
(25,902.74)
2,348,269.70
101 ,096.68
(42,299.91)
143,643.76
283,782.17
507,220.02
(444.00)
591.36
(2e0.00)
993,300.08
1 ,750,516.85
961.54
2,497.82
954,001.76
2,544.97
2,157.14
1,731 .64
(796,637.35)
(928,385.82)
989,388.55
(3,218,136.40)
19,874.70
22,803.11
0.00
16,464.35
12,675.93
0.00
15,342.94
1,455.91
301,650.65
2,958.21
8,394.28
0.00
116,773.94
8,074.19
2't5,319.87
1,028.27
25,403.87
18,264.39
9,123.85
0.00
198,802.26
85,838.32
0.00
2,106.99
(172.26)
(64,922.9s)
(6,007.96)
(4,046.85)
16,389.46
(18,52s.24)
(12,559.00)
23,791.37
3,824.00
(23,012.69)
(476.00)
74,054.00
2,188.00
4,582.08
(10,378.00)
9,007 07
(27,692.09)
62,075.67
(24,589.19)
(148,7',\2.811
24,755.55
(42,360.94)
4,174.14
27,373.56
(30,966.17)
(888.00)
591.36
(16.00)
(17,336.50)
47,571.77
'1,442.31
(611.89)
(76,989.09)
(6,806.12)
2,157.14
1,73',t.64
57,344.35
30,958.81
56,798.92
220,811.79
(1 ,I 33.28)
(8,438.49)
(3,370.76)
2,141.50
1,895.61
(151.e7)
8,695.19
'1 ,455.91
4,599.62
(1,056.77)
1 ,010.29
(182.76)
25,651 .79
(1,096.21)
(16,179.96)
1,028.27
4,123.85
(8,373.22)
(2,750.13)
(205.21)
(35,358.69)
(15,010.76)
(989.39)
(14.51)
(223.24)
Page 2 of 6
90950000
90950600
90950601
90950603
9095061 1
90950614
9095061 6
90950620
90950622
90950624
90950630
90950631
90950632
90950633
90950640
90950642
90950643
90950651
90950652
90950660
9095066 1
90950662
90950663
90950665
90950670
90950672
Layout lD: RLREG060
Business Unit: 00060
Period Endlng: Dec 31, 2017
on 03/07/18 at 05:,18 PM
SUEZ Water ldaho
General Ledger System
Rolling Regulatory l/S
12
Months
Ending
Current Year
12
Months
Ending
Prior Year
lncrease /
(Decrease)
90950673
90950675
90950676
90950677
90950678
90950901
90950902
90950903
90950920
90950930
90950932
91 500926
91 550926
91 700926
91 800926
91 850000
91 850926
91 860626
91 860665
91 860926
F B T-T&D Maint - Main
F B T-T&D Maint - Services
F B T-T&D Maint - Meters
F B T-T&D Maint - Hydrants
F B T-T&D Maint - Misc Plnt
F B T-Cust Acct Suprvsn
F B T-Cust Acct Mtr Rdng
F B T-Cust Acct Rcrds&Coll
F B T-A&G Salaries
F B T-A&G Misc
F B T-A&G Maint Plnt
Pension-A&G Ops
Post Rtrmnt PBOP-A&G Ops-Pnsn
Emplyee Grp Hlth&L-A&G Op-Pnsn
Emplyee 401 K-A&G Ops-Pension
Other Employee Benefits-ES
Othr Emply Bnft-A&G Ops-Pensn
Other Awards-Pump Ops Misc Exp
Other Awards-T&D Ops Misc Exp
Other Awards-A&G Ops-Emp Pnsns
604.0-Em ployee Pension&Benefit
Prchsd Wtr-SOS Ops
610.0-Purchased Water
Prchsd Pwr-Pump Ops Fuel Pwr
Prchsd Pwr-T&D Ops Misc Ex
615.0-Purchased Power
Chmcals-SOS Maint Wls&Spr
Chmcals-\Mr Tmt Ops Sup&Eng
618.0-Chemicals
MateriaI-SOS Maint Strctrs
Material-Pump Ops Lbr & Exp
Material-Pump Maint Strctrs
Material-Pump Maint Pwr Prd
Material-Pump Maint Eq
Material-\Mr Tmt Ops Sup&Eng
Material-Wtr Tmt
Material-Wtr Tmt Ops Lbr&Exp
Material-\Mr Tmt Maint Strct
Material-Wr Tmt Maint Equip
Material-T&D Ops Meter Exp
Material-T&D Ops Misc Ex
Material-T&D Maint Rsrvrs&Stn
Material-T&D Maint - Main
Material-T&D Maint - Services
Material-T&D Maint - Hydrants
620.1 -6 Mat &Supply-Oper&Maint
Material-Cust Acct Mtr Rdng
Material-A&G Ops-Misc Gen
620.7-8-Mat&Supp-A&G :Cust Care
Corporate Shared Services Fees
631 -34-Contract Services-Prof
Out Servs-SOS Ops Lbr & ExP
Out Servs-SOS Maint Strctrs
Out Servs-SOS Maint Lke,Rvr&Ot
Out Servs-Pump Ops Pwr Prd Lbr
Out Servs-Pump OPs Lbr & ExP
Out Servs-Pump Ops Misc Exp
Out Servs-Pump Maint Pwr Prd
Out Servs-Pump Maint Eq
Out Servs-\Mr Tmt Lab Testing
Out Servs-Other
Out Servs-Wtr Tmt
Out Servs-Wtr Tmt Ops Lbr&Exp
Out Servs-\Mr Tmt Ops Misc Exp
96,807.72
78,959.35
17126.36
18,800.44
456.07
47,399.06
140,467.84
361,073.84
504,456.60
0.00
6,935.70
1,282,525.32
(170,967.65)
1,535,934.47
184,206.48
0.01
4,546.43
0.00
0.00
3,872.48
1,799,769.42
148,905.57
148,905.57
1,84'1,530.05
411,332.96
2,252,863.0'.1
4,738.05
328,346.96
333,085.01
296.47
48,614.1 3
0.00
2,993.70
4,732.28
(566.40)
0.00
26,535.94
2,771.96
8,402.16
0.00
182.32
122.10
13,694.84
52,21',t.46
1,014.31
16'.t,005.27
2,685.51
0.00
2,685.51
4,650,911.52
4,650,91 1.52
1 ,1 02.1 9
0.00
3,178.64
2,315.34
'1,58'1.09
2,799.55
45,473.46
12,975.26
I 03,41 8.10
473.52
0.00
331.86
18,91 3.46
89,241.53
85,238.70
6,651.59
9,264.37
't84.17
43,933.39
153,267.74
339,455.51
457,667.23
1,724.29
3,166.93
1,262,'t91.00
(232,333.00)
1,348,255.13
164,477.72
0.00
13,844.96
1,097.51
424.56
27,404.26
1,639,204.96
146,681.68
146,681.68
2,078,832.40
408,800.81
2,487,633.2'.1
'14,717.73
308,129.25
322,846.98
80.52
51,222.36
680.37
11,840.93
10,494.81
0.00
4.17
35,801.93
2,062.38
143.02
236.44
0.00
(3,017.1 I )
1 5,161 .93
37,850.86
1,622.20
164,184.81
2,093.19
675.54
2,768.73
5,041,931.36
5,041 ,931.36
1 ,173.55
250.00
4,155.31
0.00
0.00
2,800.29
6,188.91
44,692.08
99,820.95
0.00
10,213.00
5,265.00
18,903.59
(7,566.19)
6,279.35
(10,474.77)
(9,536.07)
(271 e0)
(3,465.67)
12,799.90
(21 ,618.33)
(46,789.37)
1,724.29
(3,768.77)
(20,334.32)
(61,36s.35)
(187,679.34)
(19,728.76)
(0.01)
9,298.53
1,097.5'l
424.56
23,531.78
(160,564.46)
(2,223.89)
(2,223.891
237,302.35
(2,532.15)
234,770.20
9,979.68
(20,217.71)
(10,238.03)
(215.95)
2,608.23
680.37
8,847.23
5,762.53
566.40
4.17
9,265.99
(709.58)
(8,259.14)
236 44
(182.32)
(3,139.21)
1,467.09
(14,360.60)
607.89
3,179.s4
(592.32)
675.54
83.22
391,019.84
391,019.84
71.36
250.00
976.67
(2,315.34)
(1,581.09)
0.74
(39,284.55)
31,716.82
(3,597.1 5)
(473.52)
10,213.00
4,933.14
(e.87)
50605602
5061 0623
5061 0665
5063561 4
50635641
5030061 1
50300624
50300631
50300632
50300633
50300640
5030064'l
50300642
5030065'1
50300652
50300663
50300665
50300672
50300673
50300675
50300677
50300902
50300930
90850923
50400601
5040061 1
5040061 3
50400622
50400624
50400626
50400632
50400633
50400635
50400636
50400641
50400642
50400643
Page 3 of 6
Layout lO: RLREG060
Buslness Unit: 00060
Period Endlng: Dec 31,2017
on 03,07/18 at 05:il8 PM
5040065'l
50400652
50400662
50400663
50400665
50400672
50400673
50400675
50400902
50400903
50400905
50400921
50400923
50400932
50405903
5031 0604
5031 0921
SUEZ Water ldaho
General Ledger System
Rolling Regulatory l/S
12
Months
Ending
Current Year
12
Months
Ending
Prior Year
lncrease /
(Decrease)
50645000
50645600
5064560 1
50645603
5064561 1
506456't4
5064561 6
50645620
50645622
50645624
50645630
5064563'1
50645632
50645633
50645640
50645642
50645643
50645651
50645652
50645660
50645661
50645662
50645663
50645665
50645670
50645672
50645673
50645675
50645676
50645677
50645678
50645901
50645902
50645903
50645920
50645930
50645932
50646000
Out Servs-\Mr Tmt Maint Strct
Out Servs-Wtr Tmt Maint Equip
Out Servs-T&D Ops Line Ex
Out Servs-T&D Ops Meter Exp
Out Servs-T&D Ops Misc Ex
Out Servs-T&D Maint Rsrvrs&Stn
Out Servs-T&D Maint - Main
Out Servs-T&D Maint - Services
Out Servs-Cust Acct Mtr Rdng
Out Servs-Custr Acct Rcrds&Col
Out Servs-Cust Acct Misc Exp
Out Servs-A&G Ops OffSuppl&Exp
Out Servs-A&G Ops
Out Servs-A&G Maint Plnt
Print & Postage-Cust Acct Rcrd
635-Contract Other - Prof
Rent-SOS Ops
Rent-A&G Ops Off Suppl&Exp
641 -42-Rentals -Propefi &Equip
Trnsprt Cst-ES
Trnsprt Cst-SOS Ops Sup & Eng
Trnsprt Cst-SOS Ops Lbr & Exp
Trnsprt Cst-SOS Ops Misc
Trnsprt Cst-SOS Maint Strctrs
Trnsprt CSI.SOS Maint Wls&Spr
Trnsprt Cst-SOS Maint Spl Main
Trnsprt Cst-Pump Ops Sup & Eng
Trnsprt Cst-Pump Ops Pwr Prd L
Trnsprt Cst-Pump Ops Lbr & Exp
Trnsprt CsFPump Maint Sup&Eng
Trnsprt CsLPump Maint Strctrs
Trnsprt Cst-Pump Maint Pwr Prd
Trnsprt Cst-Pump Maint Eq
Trnsprt CstWr Tmt Ops Sup&En
Trnsprt Cst-Wr Tmt Ops Lbr&Ex
Trnsprt Cst-\Mr Tmt Ops Misc
Trnsprt Cst-Wr Tmt Maint Strc
Trnsprt Cst-Wr Tmt Maint Eq
Trnsprt Cst-T&D Ops Sup&Eng
Trnsprt Cst-T&D Ops Strg Faclt
Trnsprt Cst-T&D Ops Line Ex
Trnsprt Cst-T&D Ops Meter ExP
Trnsprt Cst-T&D Ops Misc Ex
Trnsprt Cst-T&D Maint Sup & En
Trnsprt CshT&D Maint Rsrv&Stn
Trnsprt Cst-T&D Maint - Main
Trnsprt Cst-T&D Main!Services
Trnsprt Cst-T&D Maint - Meters
Trnsprt Cst-T&D Maint-Hydrants
Trnsprt Cst-T&D Maint-Misc Plt
Trnsprt Cst-Cust Acct Suprvsn
Trnsprt Cst-Cust Acct Mtr Rdng
Trnsprt Cst-Cust Acct Rcrds&Co
Trnsprt CstA&G Salaries
Trnsprt Cst-A&G Misc
Trnsprt Cst-A&G Maint Plnt
Transportation Cost -Trnsfrred
650.0-Transportation Expense
Liability lnsurance-A&G Ops
Worker comp-A&G Ops-lnj&Dmages
656-59- lnsurance
650.0-Advertising
Amrt Rate Case-A&G Ops-Reg Com
666.0-Reg Comm Exp - Amort
10,997.04
34,988.06
22,723.62
1,249.47
985.00
7,938.88
6,067.21
5,525.69
91,840.09
1 16,388.41
352.40
5,265.86
32,624.36
70.00
271,076.82
800,65s.38
1,268.11
12,217.18
13,485.29
734,396.03
3,650.37
5,664.67
601.01
2,492.76
1,942.55
18.74
1,200.51
0.00
53,679.40
734.46
1,391.84
31.8'l
16,401 .68
1,692.36
42,266.50
0.00
3,919.69
4,829.03
1,963.33
35.00
43,835.89
18,439.68
229.91
396.'13
6.00
17,342.96
14,334.27
2,958.36
3,419.70
't10.34
8,369.5'l
25,480.12
65,404.25
91 ,312.36
0.00
1,070.49
(725,807.15)
443,814.56
224.98
93,260.99
93,485.97
0.00
35,792.04
35,792.04
38,272.48
7,804.66
2',t,812.28
253.75
0.00
435.89
10,215.13
16,735.81
18,068.27
91,499.59
1,',t19.73
1,846.38
61 ,778.51
0.00
300,782.78
764,087.94
1 ,'166.07
10,857.33
12,023.40
695,947.71
3,534.73
4,090.24
0.00
3,212.33
2,408.03
0.00
2,799.23
307.05
54,658.51
569.73
1,509.24
0.00
22,672.33
1,540.85
42,143.17
141 .34
4,857.54
3,446.20
1,494.07
0.00
38,326.25
16,085.50
0.00
402.88
(22.13)
't6,287.72
17,092.57
1,243.92
1,501.29
32.11
8,010.95
28,915.09
63,1 74.63
84,367.28
310.s7
607.51
(699,s60.71)
422,107.73
689.00
128,060.28
128,749,28
0.00
35,792.03
3s,792.03
27,275.44
(27,183.40)
(911.34)
(995.72)
(e85.00)
(7,502.9s)
4,147.92
11,210.12
(73,771.82)
(24,888.82)
767.33
(3,419.48)
29,154.15
(70.00)
29,705.96
(36,567.44)
(102.04)
(1,359.85)
(1,461 .8e)
(38,448.32)
(1 15.64)
(1,574.43)
(601.01)
719.57
465.48
(18.74)
1,598.72
307.05
979.11
(164.73)
117.40
(31.81)
6,270.65
(151 .51)
(123.33)
141 .34
937.85
(1,382.83)
(469.26)
(35.00)
(5,509.64)
(2,354.18)
(229.91)
6.75
(28.1 3)
(1,055.24)
2,758.30
(1,714.44)
(1 ,91 8.41)
(78.23)
(358.56)
3,434.97
(2,229.62)
(6,945.08)
310.57
(462.98)
26,246.44
(21,706.83)
464.02
34,799.29
35,263.31
0.00
(0.01)
(0.01)
91400924
91460925
92000928
Page 4 of 6
Layout lO: RLREG060
Business Unit: 00060
Period Ending: Dec 31, 2017
on 03/07/18 at 05:48 PM
92050928
92050930
90400903
90400904
90405904
SUEZ Water ldaho
General Ledger System
Rolling Regulatory l/S
12
Months
Ending
Current Year
12
Months
Ending
Prior Year
lncrease /
(Decrease)
50620626
50620633
50620651
50620665
50620921
50625643
50625651
s0650603
s0650626
s0650632
50650652
50650661
50650662
s0650665
50650903
50650905
50650921
50650923
50650930
50651660
50651 90s
50655600
50655631
50655632
50655633
50655643
50655651
50655665
50655672
50655673
50655675
50655903
50655905
50655921
50655930
50655932
92052930
92053651
92053672
92056930
92061 623
92064930
92200624
92200626
92200903
92200930
92300930
924s0930
92600643
92600920
92600921
92600923
92600930
92600932
Amort Dfrd Exp-A&G Ops-Reg Com
Amort of Dfrrd Exp-Misc Gen-A&
667-Reg Comm.Exp (Amort)
Bad Dbt-WO-Cust Acct Rcrd&Coll
Bad Dbt-WO-Custr Acct Uncollct
Bad Dbt-Provsn-Cust Acct Uncol
670.0-Bad Debt Expenses
Utilities-Pump Ops Misc Exp
Utilities-Pump Maint Eq
Utilities-\Mr Tmt Maint Strct
Utilities-T&D Ops Misc Exp
Utilities-A&G Ops Off Suppl
Sludge Dspsl-Wtr Tmt Ops Misc
Sldge Dspsl-WrTmt Maint Strct
Office Exp-SOS Ops Misc
Office Exp-Pump Ops Misc Exp
Office Exp-Pump Maint Pwr Prd
Office Exp-\Mr Tmt Maint Equip
Office Exp-T&D Ops Strg Faclt
Office Exp-T&D Ops Line Ex
Office Exp-T&D Ops Misc Ex
Office Exp-Cust Acct Rcrds&Col
Office Exp-Cust Acct Misc Exp
Office Exp-A&G Ops Off Suppl
Office Exp-A&G Accntng & Audtn
Office Exp-A&G Ops Misc Gen
Advertising Exp-A&G
Advertising Exp-CustrAcct Misc
Misc Exp-SOS Ops Sup & Eng
Misc Exp-Pump Maint Strctrs
Misc Exp-Pump Maint Pwr Prd
Misc Exp-Pump Maint Eq
Misc Exp-\Mr Tmt Ops Misc Exp
Misc Exp-\Mr Tmt Maint Strct
Misc Exp-T&D Ops Misc Ex
Misc Exp-T&D Maint Rsrvrs&Stn
Misc Exp-T&D Maint - Main
Misc Exp-T&D Maint - Services
Misc Exp-Cust Acct Rcrds&Coll
Misc Exp-Cust Acct Misc Exp
Misc Exp-A&G Ops Off Suppl&Exp
Misc Exp-A&G Ops Misc Gen
Misc Exp-A&G Maint Plnt
Amort Reloc-A&G Ops-Misc Gen
Amort Tnk Pntng-W T Maint Strc
Amort Tnk Pntng-T&D Maint rsrv
Amort OPEB Csts-A&G Ops Misc
Amrt Pwr Csts-Pump Ops Fuel Pw
Amort AFUDC Eq GU-A&G Ops Misc
Uni&Sfty Eq-Pump Ops Lbr & Exp
Uni&Sfty Eq-Pump Ops Misc Exp
Uni&Sfty Eq-Cust Acct Rcrds&Co
Uni&Sfty Eq-A&G Ops Misc Gen
Bank Charges-A&G Ops Misc Gen
Severance Plan-A&G Ops Misc
Other G&A Exp-Wr Tmt Ops Misc
Other G&A Exp-A&G Ops Salaries
Other G&A Exp-A&G Off SuPPI Ex
Other G&A Exp-A&G Outs Srvcs E
Other G&A Exp-A&G Ops Misc Gen
Other G&A Exp-A&G Maint Plnt
675.0-Miscellaneous Other
Utility Operating Expenses
1,238.00
11,666.64
't2,904.64
0.00
270,319.52
0.00
270,319.52
1,837.35
1,344.24
4,760.59
7,830.33
25,218.87
10,668.00
0.00
485.00
40,33',t.17
1 ,367.10
2,859.52
24,446.72
1,248.11
8,828.56
45,052.93
736.54
146,284.46
98,677.50
181,977.07
101 ,476.60
0.00
0.00
135,438.86
260.63
0.00
0.00
9,883.62
0.00
75.00
1 ,1 50.00
8,225.00
0.00
(7.88)
0.00
0.00
0.00
't2,582.80
0.00
55,668.72
11,052.00
257,652.00
44,995.37
't64.29
745.82
160.62
76,442.13
8,516.76
0.00
0.00
798.98
0.00
84.00
(6,804.39)
49,271.2',1
1,371,786.20
14,856.00
11,666.64
26,522.64
0.00
240,174.75
36,000.00
276,',t?4.75
't,329.54
't1,7s2.34
(19,840.23)
7,051 .'l 0
22,503.24
26,351.63
11,841.00
1,425.00
42,765.23
2,200.00
0.00
26,934.30
1,826.77
3,255.93
64,455.36
0.00
177,838.60
21,600.00
141 ,108.21
92,157.23
0.00
(27.38)
1 16,524.58
559.02
11.00
(350.00)
14,015.92
2',t7.86
0.00
1,375.00
1 ,100.00
496.99
2.83
(272.88)
1,104.23
1,880.00
22,009.80
0.00
55,869.68
44,847.98
257,657.02
43,463.75
0.00
0.00
0.00
56,684.47
143,349.37
48,000.00
13.88
0.00
2,56"1.80
4,610.94
(4,681.84)
41,906.36
1,489,485.63
17,29',t,153.46
13,618.00
0.00
13,618.00
0.00
(30,144.77)
36,000.00
5,855.23
(507.81)
10,408.10
(24,600.82)
(77s.23)
(2,715.63)
15,683.63
11,841.00
940.00
2,434.06
832.90
(2,859.52)
2,487.58
578.66
(5,572.63)
19,402.43
(736.54)
31,554.14
(77,077.50)
(40,868.86)
(9,319.37)
0.00
(27.38)
(18,914.28)
298.39.11.00
(350.00)
4,132.30
217.86
(75.00)
225.00
(7,125.00)
496.99
10.71
(272.88)
1,104.23
'1,880.00
9,427.00
0.00
200.96
33,795.98
5.02
(1,531.62)
(164.29)
(745.82)
(160.62)
(19,757.66)
134,832.61
48,000.00
13.88
(7e8.e8)
2,561.80
4,526.94
2,',t22.55
(7,364.85)
117,699.43
Page 5 of 6
16,831 ,677.63 459,475.83
Layout lD: RLREG060
Business Unit: 00060
Period Endlng: Dec 31,2017
on 03,07,18 at 05:il8 PM
70 1 00403
7't255406
91 900928
70203408
70300408
70250408
801 00409
80 1 50409
8020041 0
8025041 0
8040041 1
71100415
71105416
71 05041 9
71051419
710524',t9
7090041 I
71 250000
71251418
71252426
71253426
7't300426
90890426
90890923
70800430
71 000431
SUEZ Water ldaho
General Lodgor System
Rolling Regulatory l/S
12
Months
Ending
Current Year
12
Months
Endtng
Prior Year
lncrease /
(Decrease)
Total Expenses
GROSS INCOME
't 6,831,677.63 17,291,',ts3.46
32,067,635.68 32,531,242.30
459,475.83
(463,606.62)
Depreciation - Utility Plant
403.o-Depreciation Expense
Amort of Util Plt Acquis Adj
406.0-Amort Util Plant Acq Adj
Regulatory Commission-A&G Ops
408.1o-Regulatory Fees
Real Estate Tax
Property Taxes
408.1't -Property Taxes
Payroll Taxes
408.12-Payroll Taxes
408.1 3-Other Taxes
Current-federal
409.1-lncome Taxes - Federal
Current-state
409.11-St lncome Tax-Util Oper
Deferred-Federal I ncome Taxes
410.10-Prov Defer lnc Tax-Fed
Deferred-State I ncome taxes
410.11-Prov Def lnc Tax-State
lnvestment Tax Cr,amortization
41 2.0-lnvest Tax Cred-Utility
414-Gain(Loss)from Dis of Util
Total Non-Operating lncome
Mdse & jobbing - lncome
41S-Merchandise & Jobbing lnc
Mdse&Jobbing-Expense
416-Merchandise & Jobbing Exp
AFUDC Gross Up
AFUDC Debt
AFUDC Equity
420.0-Allow for Funds Used
lnterest income
Non Recoverable - ES Expenses
Misc Non Oper Rental lncome
421-Misc Non-Util lncome
Misc lncome/Deduction
Non Recoverable
Equity earnings of affiliates
Corp Shrd Svcs-Non Recoverable
Corp Shrd Svcs-Non Recoverable
426.0-Misc Non-Utility Expense
Total Non-Operating lncome & Deductions
lnterest Exp-SW/Can cons co's
427.3-lnt Exp on LongTerm Debt
Other interest
427 .'-Other I nt Charges
Total lnterest Expenses
'18,225,377.22 15,s97,366.29
9,019,036.13
9,019,036.13
20,712.00
20,712.00
1 13,345.95
113,345.95
2,023,',t35.67
0.00
2,023,135.67
502,586.92
502,586.92
0.00
5,346,350.24
5,345,350.24
1,',t11,712.31
1,111,712.31
82,676.00
82,676.00
54,062.00
54,062.00
(48,240.00)
(48,240.00)
0.00
8,948,737.65
8,948,737.65
22,532.00
22,532.00
87,302.92
87,302.92
0.00
1,985,895.78
1,985,895.78
492,360.1 9
492,360.19
0.00
4,918,268.75
4,918,268.75
(2,238,462.00)
(2,238,462.001
1 ,1 52,880.00
1,'152,880.00
276,091.00
276,091.00
(48,240.00)
(48,240.00)
0.00
70,298.48
70,298.48
(1,820.00)
(1,820.00)
26,043.03
26,043.03
2,023,135.67
(1,985,895.78)
37,239.89
10,226.73
10,226.73
0.00
428,081 .49
428,081.49
3,350,'l 74.31
3,350,174.31
(1,070,204.00)
(1,070,204.00)
(222,029.00)
1222,029.001
0.00
0.00
0.00
2,628,010.93
(84.38)
(84.38)
0.00
0.00
(60,9s8.83)
(56,593.70)
(94,958.28)
l2't2,510.811
(5,585.02)
0.00
(56,404.01)
(61,989.03)
28,856.33
76,424.97
0.00
424,900.34
0.00
530,181.64
(77,925.24)
(77,925.24l.
66,201.14
66,201.'.t4
(246,346.17)
0.00
0.00
(246,346.',t71
(621.73)
0.00
(75,627.51)
(76,249.24l-
15,252.22
30,876.20
99,839.00
409,502.85
0.00
555,470.27
77,840.86
77,840.86
(66,201.14)
(66,201.14)
185,387.34
(s6,593.70)
(94,958.28)
33,835.36
(4,963.29)
0.00
19,223.50
14,260.21
't 3,604.1 1
45,548.77
(99,839.00)
15,397.49
0.00
{?q,288.63)
255,597.42 221,150.76 34,446.66
4,386,057.82
4,386,057.82
2,988.32
2,988.32
4,566,614.30
4,566,614.30
2,432.27
2,432.27
(180,556.48)
(180,556.48)
556.05
556.05
4,389,046.14 4,569,046.57 (180,000.43)
NET INCOME
Page 6 of 6
9,197,614.90 12,143,678.68 (2,946,063.78)
Report lD: BSCOR100
LayoutlD: BSCOR100 SUEZ Water ldaho
General Ledger System
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 31, 2017
on 0/il0218 at 05:48 PM
- Current Month -
Lasf
Year
lncrease
(Decrease)
,trs
Year
423,721,661.65
8,734,807.65
432,456,469.30
600,761.18
(174,113.18)
426,648.00
(116,216,984.10)
491,024.20
1,070,282.02
(35,839,719.09)
(150,495,396.97)
7,068,736.45
(302.59)
832,247.52
7,900,681.38
0.00
or
1 01 00000
1 0600000
1 1 400000
1 1 500000
1 0800000
1 081 0000
1 0900000
1 1 1 00000
1 0700000
1 0750000
1 8300000
Assefs
Utility Plant in Service
Cnstrction Csts Not Classified
Utility Plant
Utility plant acquisition adj
Amort Utility Plant Acquis Adj
Net Utility Plant Acquist Adj
Utility Accumulated Depr
Retirement work in progress
Accumulated Cost of Removal
Utility Accumulated Depr -CIAC
Less Accumulated Depr & Amort
Construction work in progress
CWP - Suspense
Prelim Survey and lnv. Chrgs
Construction Work in Progress
Plant Held for Future Use
Net Utility Plant
397,608,097.28
12,747,603.51
410,355,700.79
600,761 .1 8
(153,401.18)
447,360.00
(1 10,653,569.67)
265,307.28
64,449.56
(33,291 ,746.31)
(143,615,559.14)
5,069,723.48
39,415.47
582,643.13
5,691,782.08
0.00
(26,1 13,564.37)
4,O12,795.86
(22,100,768.51)
0.00
20,712.O0
20,712.00
5,563,414.43
(225,716.92)
(1,005,832.46)
2,547,972.78
6,879,837.83
(1,999,012.e7)
39,7'18.06
(249,604.39)
(2,208,899.30)
0.00
290,288,401.71 272,879,283.73 (1 7,409,1 1 7.98)
1 2 1 00000
lnvestments - LT Consol Comp
lnvestments - LT Non-Consol Co
Equity lnvestments
Non-Utility Property
Non-Utility Property & Equip
Depreciation Non-Utility Prop
Other Properties & lnvestments
Goodwill, net
Other lntangibles, Net
Goodwill & Other !ntangibles
13120000 Collections13150000 Operating Cash Acct - Citi
13501000 Working Funds
Cash
Restricted Cash
14200000 Customer AR - CC&B
14201000 AR Cash Accrual
14309000 AccountsReceivable-Other
14310000 AR - M&J billed
14400000 Provision Uncllctble Acct (Cr)
14410000 ProvisionUncllctbleAcct-Othr
17300000 UnbilledRevenue
Accounts Receivable - Customer
14605000 lC Money Pool Receivable
A/R - Associated Companies
A/R Affiliated Companies
Notes Receivable - Short Term
15000000 Capital&MaintlnvNonexempt15010000 SmallRepairslnventoryExempt
15020000 Otherlnventory
Run Date: 4116120'18
Run Time: 9:28 AM
0.00
0.00
0.00
't1,053.83
11,053.83
0.00
0.00
0.00
0.00
11,053.83
11,053.83
0.00
11,053.83 11,053.83 0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00 0.00
41,000.00
42.39
550.00
41,592.39
0.00
2,187,875.48
(619,088.77)
1 79,1 93.56
8,016.43
(300,000.00)
(11,000.00)
3,415,499.00
4,860,495.70
(0.00)
(0.00)
0.00
0.00
1 16,537.51
285,946.78
55,240.67
41,000.00
42.39
550.00
41,592.39
0.00
1,992,651.60
(648,344.06)
56,841.85
8,016.43
(300,000.00)
(11,000.00)
3,104,500.00
4,202,665.82
0.00
0.00
0.00
0.00
85,720.05
169,403.53
50,873.26
0.00
0.00
0.00
0.00
0.00
(195,223.88)
(29,255.29)
(122,351.71)
0.00
0.00
0.00
(310,999.00)
(657,82e.88)
0.00
0.00
0.00
0.00
(30,817.46)
(116,543.25)
(4,367.41)
Page I of 10
0.00
0.00
0.00
0.00
0.00
0.00
Report lD: BSCORl00
Layout lD: BSCOR100 SUEZ Water ldaho
Goneral Ledger System
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 31, 2017
on 04/02/18 at 05:48 PM
This
Year
18,568.77
476,293.73
72,000.00
72,000.00
0.00
Lasf
Year
41J62.77
347,159.61
74,400.00
74,400.00
0.00
lncrease
or
(Decrease)
22,594.00
(129,134.12)
2,400.00
2,400.00
0.00
- Current Month -
1 5030000
1 6599000
Chemical lnventory
Materials & Supplies lnventory
Prepaid Expenses-Other
Prepaid Expenses
Other Current Assets
Total Current & Accrued Assets
Unamortized Debt DiscounUExp
Deferred Emplyee Benefits-Othr
Deferred Tank Painting Expense
Dfrrd Relocation Exp - Approve
Deferred AFUDC Equity Gross Up
Deferred Pwr Costs - Approved
Reg Defrrd Tank Pnting - Amort
Dfrrd AFUDC Eq Gross-Up Amort.
Deferred rate charges
Other Regulatory Assets
Regulatory Assets
Deferred Power Costs - Pending
Other Deferred Charge & Assets
Notes Receivable - Long Term
Clearing - CapitalWork Order
Clearing - AP and Procument
Clearing Accounts
Non Current Assets
Total Assets
381.82 4,665,817.82 (784,564.00)
1 8609000
1 8620000
'18621000
1 8623000
1 8625000
1 8650000
1 8653000
1 8680000
1 8699000
0.00
2,023,956.75
't,115,290.29
35,177.45
1,607,645.79
257,652.89
(397,179.33)
(290,551.75)
35,792.00
23,718.72
4,411,502.81
395,256.86
395,256.86
0.00
(92,879.37)
0.00
p2,e7e.37)
0.00
1,680,746.73
1,115,290.29
47,760.25
1,546,686.96
515,304.89
(341 ,51 0.61)
(245,556.38)
71,584.04
37,175.36
4,427,481.53
184,178.36
184,178.36
0.00
(0.51)
(32,337.15)
(32,337.66)
0.00
(343,210.O2)
0.00
12,582.80
(60,958.83)
257,652.00
55,668.72
44,995.37
35,792.04
13,456.64
15,978.72
(211,078.50)
(211,078.50)
0.00
92,878.86
(32,337.15)
60,541.71
18714000
1 8404000
1 8499000
Run Date: 411612018
Run Time: 9:28 AM
4,713,880.30 4,579,322.23 (134,558.07)
300,463,717.66 282,135,477.61 (18,328,240.05)
Page 2 of '10
Report lD: BSCOR100
Layout lD: BSCOR100 SUEZ Water Idaho
Goneral Ledgor System
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 31,2017
Run on 04/0218 at 05:48 PM
This
Year
1,261,750.00
81,437,834.97
82,699,584.97
0.00
82,699,584.97
86,345,915.50
86,345,915.50
(1,374,597.51)
(1,374,597.51)
4,108.32
21,639,786.60
11,296,787.69
11,765,052.75
2,527,797.19
140,078.26
35,343.32
1,128,171.63
3,545.63
12,840.00
9,622.92
25,180.00
274,011.00
36,988.00
48,899,313.31
(1 e6.1 1)
(7,576.78)
(35,133.70)
(54,493.19)
(7,126.53)
(100,452.18)
(12,011.25)
0.00
(124,357.34)
(7,625.06)
0.00
(17,144.06)
(40,8e6.e3)
0.00
0.00
(21,292.41)
(75,441.94)
0.00
(4,022.08)
(76,341 .1 3)
(61.03)
(139,469.62)
(1,702,945.08)
Lasf
Year
1,261,750.00
81,437,834.97
82,699,584.97
0.00
82,699,584.97
90,633,006.82
90,633,006.82
(16,430,770.00)
(16,430,770.00)
13,231.32
22,805,335.21
10,923,731 .51
12,136,774.18
2,466,942.48
158,926.56
32,860.65
1,081,045.57
3,340.28
10,600.00
8,925.00
34,175.00
6,311.00
140,197.00
49,822,395.76
0.00
(30,589.47)
(32,521.11)
(46,O7e.22)
0.00
(32,404.6e)
(24,444.96)
(2,475.74)
(114,237.61)
(5,522.86)
(4,264.12)
(15,130.2e)
(38,469.91)
42,871.83
(158.e1)
(38,886.32)
(69,375.23)
19,106.68
(3,e88.81)
(101 ,096.68)
42,299.91
(143,643.76)
(1,750,516.85)
lncrease
(Decrease)
- Current Month -
or
201 00000
20800000
21 600000
80550000
Capitalization and Liabilities
Common Stock lssued
Additional Paid-in CaPital
Common Stock
Preferred Stock
Total CapitalStock
RE - Cumulated lncome
Retained Earnings - beginning
Common Stock Dividend
Common Stock Dividend
General Sales
Meter Sale-Residential consumP
Meter Sale-Residential facili
Meter Sale-Commercial consumP
Meter Sale-Commercial facilitY
Meter Sale-public auth consumP
Meter Sale-public auth fac
Private Fire protection facili
Public Fire protection facilit
Miscellaneous service revenue
Rents from water property
Turn on fees
Reg Unbill consumption revenue
Reg Unbill facility charge rev
Total Operating Revenues
Expense System Clearing
Supv Labor-ES
Supv Lbr-SOS Ops Sup & Eng
Supv Lbr-SOS Ops Lbr & ExP
Supv Lbr-SOS Ops Misc
Supv Lbr-SOS Maint Wls&SPr
Supv Lbr-Pump Ops SuP & Eng
Supv Lbr-Pump Ops Pwr Prd Lbr
Supv Lbr-Pump Ops Lbr & ExP
Supv Lbr-Pump Maint SuP&Eng
Supv Lbr-Pump Maint EquiP
Supv Lbr-Wtr Tmt OPs SuP&Eng
Supv Lbr-Wtr Tmt Ops Lbr&ExP
Supv Lbr-Wr Tmt OPs Misc ExP
Supv Lbr-Wtr Tmt Maint Strct
Supv Lbr-T&D Ops SuP&Eng
Supv Lbr-T&D OPs Line ExP
Supv Lbr-T&D OPs Misc ExP
Supv Lbr-T&D Maint SuP &Eng
Supv Lbr-Cust Acct SuPrvsn
Supv Lbr-Cust Acct Mtr Rdng
Supv Lbr-Cust Acct Rcrds&Coll
Supv Lbr-A&G Ops Salaries
0.00
0.00
0.00
0.00
0.00
401 00461
401 05461
401 06461
40110461
40111461
40120461
40121461
40140462
40145463
40200471
40205472
40245471
40300474
40301474
5001 5000
501 00000
501 00600
501 00601
501 00603
501 00614
501 00620
50100622
501 00624
501 00630
501 00633
501 00640
50'100642
501 00643
501 00651
501 00660
501 00662
501 00665
501 00670
5010090't
501 00902
501 00903
501 00920
4,287,091.32
4,287,091.32
(15,056,172.49)
(15,056,172.49)
9,123.00
1 ,165,548.61
(373,056.18)
371,721.43
(60,854.71)
18,848.30
(2,482.67)
(47,126.06)
(205.35)
(2,240.00)
(6e7.e2)
8,995.00
(267,700.00)
103,209.00
923,O82.45
1 96.1 1
(23,012.69)
2,612.59
8,413.97
7,126.53
68,047.49
(12,433.71)
(2,475.74)
1 0,1 1 9.73
2,102.20
(4,264.12)
2,013.77
2,427.02
42,871.83
(158.91)
(17,593.91)
6,066.71
19,106.68
33.27
(24,755.55)
42,360.94
(4,174.14)
(47,571.77)
Run Date: 411612018
Run Time: 9:28 AM Page 3 of 10
Report lD: BSCOR100
Layout lD: BSCOR100 SUEZ Water ldaho
General Ledger System
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 3'1, 2017
on 0/U0Zl8 at 05:48 PM
501 00930
501 00932
501 05600
501 05601
5010561 1
50'105616
s01 05620
501 05624
501 05631
501 05632
501 05633
501 05642
501 05643
501 05651
501 05652
501 05660
501 05661
501 05662
501 05663
501 05665
50105672
501 05673
501 05675
501 05676
501 05677
501 05678
501 05902
501 05903
501 05920
501 05932
501 1 0920
501 1 0930
501 1 5675
501 20000
501 20601
50120614
50120624
50120643
50120660
50120665
50120901
50120902
501 20903
50120920
501 25633
501 25665
50125678
50125920
5030061 1
50300624
50300631
50300632
50300633
50300640
50300641
Supv Lbr-A&G Misc Gen Exp
Supv Lbr-A&G Maint Plnt
Drct Lbr-SOS Ops Sup & Eng
Drct Lbr-SOS Ops Lbr & Exp
Drct Lbr-SOS Maint Strctrs
Drct Lbr-SOS Maint Sply Mains
Drct Lbr-Pump Ops Sup & Eng
Drct Lbr-Pump Ops Lbr & Exp
Drct Lbr-Pump Maint Strctrs
Drct Lbr-Pump Maint Pwr Prd
Drct Lbr-Pump Maint Equip
Drct Lbr-\Mr Tmt Ops Lbr&Exp
Drct Lbr-Wr Tmt Ops Misc Exp
Drct Lbr-Wtr Tmt Maint Strct
Drct Lbr-Wtr Tmt Maint Equip
Drct Lbr-T&D Ops Sup&Eng
Drct Lbr-T&D Ops Storage Faclt
Drct Lbr-T&D Ops Line Ex
Drct Lbr-T&D Ops Meter Exp
Drct Lbr-T&D Ops Misc Ex
Drct Lbr-T&D Maint Rsrvrs&Stn
Drct Lbr-T&D Maint - Main
Drct Lbr-T&D Maint - Services
Drct Lbr-T&D Maint - Meters
Drct Lbr-T&D Maint - Hydrants
Drct Lbr-T&D Maint -Misc Plnt
Drct Lbr-Cust Acct Mtr Rdng
Drct Lbr-Cust Acct Rcrds&Coll
Drct Lbr-A&G Ops Salaries
Drct Lbr-A&G Maint Plnt
S L T-A&G Ops Salaries
S L T-A&G Ops-Misc Gen
D L T-T&D Maint - Services
S L T out-ES
S L T out-SOS Ops Lbr & ExP
S L T out-SOS Maint Wls&Spr
S L T out-Pump Ops Lbr & Exp
S L T out-Wtr Tmt Ops Misc ExP
S L T out-T&D Ops Sup&Eng
S L T out-T&D Ops Misc ExP
S L T out-Cust Acct Suprvsn
S L T out-Custr Acct Mtr Rdng
S L T out-Cust Acct Rcrds&Coll
S L T out-A&G Ops Salaries
D L T oulPump Maint Equip
D L T out-T&D Ops Misc Ex
D L T out-T&D Maint -Misc Plnt
D L T out-A&G Ops Salaries
Material-SOS Maint Strctrs
Material-Pump Ops Lbr & ExP
Material-Pump Maint Strctrs
Material-Pump Maint Pwr Prd
Material-Pump Maint Eq
Material-Wr Tmt Ops Sup&Eng
Material-Wr Tmt
This
Year
480.77
(3,109.71)
(1,421.09)
(237.76)
(24,862.37)
(261.10)
55.00
(441,471.49)
('t4,302.57)
(242.72)
(160,22',t.15)
(3e9,021.51)
0.00
(37,979.15)
(50,379.20)
(1,34e.18)
(331.80)
(359,457.79)
(194,852.85)
(64,922.95)
(100.20)
(173,302.84)
(148,025.36)
(32,320.18)
(33,017.18)
(2,421.27)
(256,408.61)
(538,186.19)
(1,030,990.85)
(s,351.09)
0.00
0.00
1,147.20
7,576.78
(238.00)
78,169.00
3,386.00
0.00
(1,079.00)
0.00
(444.00)
0.00
274.00
853,981.70
(1 ,313.55)
62,075.67
1 ,313.55
959,344.63
(2e6.47)
(48,614.13)
0.00
(2,993.70)
(4,732.28)
566.40
0.00
(26,535.94)
Last
Year
(e61.54)
(2,497.82)
214.09
0.00
(29,012.21)
0.00
(1 10.00)
(466,998.16)
(16,505.47)
0.00
(242,122.60)
(358,837.96)
(1,510.20)
(48,318.61)
(34,127.50)
(477.87)
0.00
(2e1,954.90)
(155,167.56)
0.00
5,907.76
(169,255.99)
(164,414.82)
(1s,790.94)
(20,458.18)
(26,212.64)
(283,782.17)
(507,220.02)
(954,001.76)
(2,544.97)
(2,157.14)
(1,731.64)
(2,676.80)
30,589.47
238.00
4,115.00
1,198.00
(4,582.08)
9,299.00
(9,007.07)
444.00
(591.36)
290.00
796,637.35
26,378.54
0.00
25,902.74
928,385.82
(80.52)
(51,222.36)
(680.37)
(11,840.93)
(10,494.81)
0.00
(4.17)
(35,801.93)
- Current Month -lncrease
or
(Decrease)
(1,442.31)
611.89
1 ,635.1 I
237.76
(4,149.84)
261.10
(165.00)
(25,526.67)
(2,202.90)
242.72
(81,901.45)
40,183.55
(1 ,510.20)
(10,339.46)
16,251.70
871.31
331.80
67,502.89
39,685.29
64,922.95
6,007.96
4,046.85
(16,389.46)
18,529.24
12,559.00
(23,791.37)
(27,373.56)
30,966.17
76,989.09
6,806.12
(2,157.14)
(1,731.64)
(3,824.00)
23,012.69
476.00
(74,054.00)
(2,188.00)
(4,582.08)
10,378.00
(e,007.07)
888.00
(5e1.36)
16.00
(57,344.35)
27,692.09
(62,075.67)
24,589.19
(30,958.81)
215.95
(2,608.23)
(680.37)
(8,847.23)
(5,762.53)
(566.40)
(4.17)
(e,265.99)503Q?g{ite. n,{$pf,{at-wtr rmt ops Lbr&Exp
Run Time: 9:28 AM Page 4 of 10
Report lD: BSCOR100
Layout lD: BSCOR100 SUEZ Water ldaho
General Ledger System
Corp BS C/M vs Same Month PIYrBusiness Unit: 00060
Period Ending: Dec 31,2017
Run on 04/0218
This
Year
(2,771.96)
(8,402.16)
0.00
(182.32)
(122.10)
(13,6e4.84)
(52,211.46)
(1,014.31)
(2,685.51)
0.00
(1,268.11)
(12,217.18)
(1,102.19)
0.00
(3,178.64)
(2,315.34)
(1,581.09)
(2,7ee.55)
(45,473.46)
(12,975.26)
(103,418.10)
(473.52)
0.00
(331.86)
(18,913.46)
(10,997.04)
(34,988.06)
(22,723.62)
(1,249.47)
(e85.00)
(7,e38.88)
(6,067.21)
(5,525.69)
(91,840.09)
(116,388.41)
(352.40)
(5,265.86)
(32,624.36)
(70.00)
(271,076.82)
(148,905.57)
(1,841,530.05)
(411,332.96)
(1,837.35)
(1,344.24)
(4,760.59)
(7,830.33)
(25,218.87)
(10,668.00)
0.00
(4,738.05)
(328,346.96)
(734,396.03)
(3,650.37)
(5,664.67)
(601.01)
Last
Year
(2,062.38)
(143.02)
(236.44)
0.00
3,017.11
(1 5,1 61 .93)
(37,850.86)
(1,622.20)
(2,093.19)
(675.54)
(1,166.07)
(10,857.33)
(1 ,173.55)
(250.00)
(4,155.31)
0.00
0.00
(2,800.29)
(6,188.91)
(44,692.08)
(99,820.95)
0.00
(10,213.00)
(5,265.00)
(18,e03.59)
(38,272.48)
(7,804.66)
(21,812.28)
(253.75)
0.00
(435.8e)
(10,215.13)
(16,735.81)
(18,068.27)
(91,4ee.5e)
(1,119.73)
(1,846.38)
(61,778.51)
0.00
(300,782.78)
(146,681.68)
(2,078,832.40)
(408,800.81)
(1,329.54)
(11,752.34)
19,840.23
(7,051 .1 0)
(22,503.24)
(26,351.63)
(11,841.00)
(14,717.73)
(308,129.25)
(695,947.71)
(3,534.73)
(4,0e0.24)
0.00
lncrease
or
(Decreasel
709.58
8,259.14
(236.44)
182.32
3,139.21
(1,467.09)
14,360.60
(607.89)
592.32
(675.54)
102.04
1,359.85
(71.36)
(250.00)
(e76.67)
2,315.34
1,581.09
(0.74)
39,284.55
(31,716.82)
3,597.15
473.52
(10,213.00)
(4,933.14)
9.87
(27,275.44)
27,183.40
911.34
995.72
985.00
7,502.99
(4,147.92)
(11,210.12)
73,771.82
24,888.82
(767.33)
3,419.48
(29,154.15)
70.00
(29,70s.96)
2,223.89
(237,302.35)
2,532.15
507.81
(10,408.10)
24,600.82
779.23
2,715.63
(15,683.63)
(11,841.00)
(9,979.68)
20,217.71
38,448.32
115.64
1,574.43
601.01
- Current Month -
50300651 Material-Wtr Tmt Maint Strct
50300652 Material-Wr Tmt Maint Equip
50300663 Material-T&D Ops Meter Exp
50300665 Material-T&D Ops Misc Ex
50300672 Material-T&DMaintRsrvrs&Stn
50300673 Material-T&D Maint - Main
50300675 Material-T&D Maint - Services
50300677 Material-T&D Maint - Hydrants
50300902 Material-Cust Acct Mtr Rdng
50300930 Material-A&GOps-MiscGen
50310604 Rent-SOS Ops
50310921 Rent-A&G Ops Off Suppl&Exp
50400601 Out Servs-SOS Ops Lbr& Exp
50400611 Out Servs-SOS Maint Strctrs
50400613 Out Servs-SOS Maint Lke,Rvr&Ot
50400622 Out Servs-Pump Ops Pwr Prd Lbr
50400624 Out Servs-Pump Ops Lbr & Exp
50400626 Out Servs-Pump Ops Misc Exp
50400632 Out Servs-Pump Maint Pwr Prd
50400633 Out Servs-Pump Maint Eq
50400635 Out Servs-Wtr Tmt Lab Testing
50400636 Out Servs-Other
50400641 Out Servs-Wr Tmt
50400642 Out Servs-Wr Tmt Ops Lbr&Exp
50400643 Out Servs-Wr Tmt Ops Misc Exp
50400651 Out Servs-Wtr Tmt Maint Strct
50400652 Out Servs-Wr Tmt Maint Equip
50400662 Out Servs-T&D Ops Line Ex
50400663 Out Servs-T&D Ops Meter Exp
50400665 Out Servs-T&D Ops Misc Ex
50400672 Out Servs-T&D Maint Rsrvrs&Stn
50400673 Out Servs-T&D Maint - Main
50400675 Out Servs-T&D Maint - Services
50400902 Out Servs-Cust Acct Mtr Rdng
50400903 OutServs-CustrAcctRcrds&Col
50400905 Out Servs-Cust Acct Misc Exp
50400921 Out Servs-A&G Ops OffSuppl&Exp
50400923 Out Servs-A&G Ops
50400932 Out Servs-A&G Maint Plnt
50405903 Print & Postage-Cust Acct Rcrd
50605602 Prchsd Wtr-SOS Ops
50610623 Prchsd Pwr-Pump Ops Fuel Pwr
50610665 Prchsd Pwr-T&D Ops Misc Ex
50620626 Utilities-Pump Ops Misc Exp
50620633 Utilities-Pump Maint Eq
50620651 Utilities-\Mr Tmt Maint Strct
50620665 Utilities-T&D Ops Misc Exp
50620921 Utilities-A&G Ops Off Suppl
50625643 Sludge Dspsl-\Mr Tmt Ops Misc
50625651 Sldge Dspsl-WrTmt Maint Strct
50635614 Chmcals-SOSMaintWls&Spr
50635641 Chmcals-Wtr Tmt Ops Sup&Eng
50645000 Trnsprt CstES
50645600 Trnsprt CstSOS Ops Sup & Eng
50645601 Trnsprt Cst-SOS Ops Lbr & Exp
506f,?9$",., n,IdDEgt Cst-SoS ops Misc
Run Time: 9:28 AM Page 5 of 10
Report lD: BSCORi0o
Layout lD: BSCOR100 SUEZ Water ldaho
General Ledger System
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 31, 2017
on 04/0218 at 05:48 PM
50645611 Trnsprt CstSOS Maint Strctrs
50645614 Trnsprt Cst-SOS Maint Wls&Spr
50645616 Trnsprt Cst-SOS Maint Spl Main
50645620 Trnsprt Cst-Pump Ops Sup & Eng
50645622 Trnsprt Cst-Pump Ops Pwr Prd L
50645624 Trnsprt Cst-Pump Ops Lbr & Exp
50645630 Trnsprt Cst-Pump Maint Sup&Eng
50645631 Trnsprt Cst-Pump Maint Strctrs
50645632 Trnsprt Cst-Pump Maint Pwr Prd
50645633 Trnsprt Cst-Pump Maint Eq
50645640 Trnsprt Cst-Wr Tmt Ops Sup&En
50645642 Trnsprt Cst-Wtr Tmt Ops Lbr&Ex
50645643 Trnsprt Cst-Wr Tmt Ops Misc
50645651 Trnsprt Cst-Wr Tmt Maint Strc
50645652 Trnsprt Cst-Wr Tmt Maint Eq
50645660 Trnsprt Cst-T&D Ops Sup&Eng
50645661 Trnsprt Cst-T&D Ops Strg Faclt
50645662 Trnsprt Cst-T&D Ops Line Ex
50645663 Trnsprt Cst-T&D Ops Meter Exp
50645665 Trnsprt Cst-T&D Ops Misc Ex
50645670 Trnsprt Cst-T&D Maint Sup & En
50645672 Trnsprt Cst-T&D Maint Rsrv&Stn
50645673 Trnsprt Cst-T&D Maint - Main
50645675 TrnsprtCst-T&DMaint-Services
50645676 Trnsprt CstT&D Maint - Meters
50645677 TrnsprtCst-T&DMaint-Hydrants
50645678 Trnsprt Cst-T&D Maint-Misc Plt
50645901 Trnsprt Cst-Cust Acct Suprvsn
50645902 Trnsprt Cst-Cust Acct Mtr Rdng
50645903 Trnsprt Cst-Cust Acct Rcrds&Co
50645920 Trnsprt Cst-A&G Salaries
50645930 Trnsprt Cst-A&G Misc
50645932 Trnsprt CsrA&G Maint Plnt
50646000 TransportationCost-Trnsfrred
50650603 Office Exp-SOS Ops Misc
50650626 Office Exp-Pump Ops Misc Exp
50650632 Offlce Exp-Pump Maint Pwr Prd
50650652 Office Exp-Wtr Tmt Maint Equip
50650661 Office Exp-T&D Ops Strg Faclt
50650662 Office Exp-T&D Ops Line Ex
50650665 Office Exp-T&D Ops Misc Ex
50650903 Office Exp-Cust Acct Rcrds&Col
50650905 Office Exp-Cust Acct Misc Exp
50650921 Offlce Exp-A&G Ops Off Suppl
50650923 Office Exp-A&G Accntng & Audtn
50650930 Office Exp-A&G Ops Misc Gen
50651660 AdvertisingExp-A&G
50655600 Misc Exp-SOS Ops Sup & Eng
50655631 Misc Exp-Pump Maint Strctrs
50655632 Misc Exp-Pump Maint Pwr Prd
50655633 Misc Exp-Pump Maint Eq
50655643 Misc Exp-Wtr Tmt Ops Misc Exp
50655651 Misc Exp-Wr Tmt Maint Strct
50655665 Misc Exp-T&D Ops Misc Ex
50655672 Misc Exp-T&D Maint Rsrvrs&Stn
506fl5u97jle: n {U/rE,Ftp-r&D Maint - Main
Run Time: 9:28 AM
This
Year
(2,4e2.76)
(1,942.55)
(18.74)
(1 ,200.51)
0.00
(53,679.40)
(734.46)
(1,391.84)
(31 .81)
(16,401.68)
(1,692.36)
(42,266.50)
0.00
(3,e1e.6e)
(4,82e.03)
(1,963.33)
(35.00)
(43,835.89)
(18,439.68)
(229.91)
(3e6.13)
(6.00)
(17,342.96)
(14,334.27)
(2,958.36)
(3,419.70)
(1 10.34)
(8,36e.51)
(25,480.12)
(65,404.25)
(91,312.36)
0.00
(1,070.49)
725,807.15
(485.00)
(40,331.17)
(1,367.10)
(2,859.52)
(24,446.72)
(1,248.11)
(8,828.56)
(45,052.93)
(736.54)
(146,284.46)
(98,677.50)
(181,977.07)
(101,476.60)
0.00
(135,438.86)
(260.63)
0.00
0.00
(e,883.62)
0.00
(75.00)
(1 ,1 50.00)
Last
Year
(3,212.33)
(2,408.03)
0.00
(2,799.23)
(307.05)
(54,658.51)
(569.73)
(1,509.24)
0.00
(22,672.33)
(1,540.85)
(42,143.17)
(141.34)
(4,857.54)
(3,446.20)
(1,494.07)
0.00
(38,326.25)
(16,085.50)
0.00
(402.88)
22.13
(16,287.72)
(17,092.57)
(1,243.92)
(1,501.29)
(32.11)
(8,010.95)
(28,915.09)
(63,174.63)
(84,367.28)
(310.57)
(607.51)
699,560.71
(1,425.00)
(42,765.23)
(2,200.00)
0.00
(26,934.30)
(1,826.77)
(3,255.93)
(64,455.36)
0.00
(177,838.60)
(21,600.00)
(141,108.21)
(e2,157.23)
27.38
(116,524.58)
(559.02)
(11.00)
350.00
(14,015.92)
(217.86)
0.00
(1,375.00)
- Current Month -lncrease
or
(Decrease)
(719.57)
(465.48)
18.74
(1,598.72)
(307.05)
(e7e.1 1 )
164.73
(117.4O)
31.81
(6,270.65)
151 .51
123.33
(141.34)
(937.85)
1,382.83
469.26
35.00
5,509.64
2,354.18
229.91
(6.75)
28.13
1,055.24
(2,758.30)
1,714.44
1,918.41
78.23
358.56
(3,434.97)
2,229.62
6,945.08
(310.57)
462.98
(26,246.44)
(e40.00)
(2,434.06)
(832.90)
2,859.52
(2,487.58)
(578.66)
5,572.63
(19,4O2.43)
736.54
(31,554.14)
77,077.50
40,868.86
9,319.37
27.38
18,914.28
(298.39)
(11.00)
350.00
(4,132.30)
(217.86)
75.00
(225.00)
Page 6 of 't0
Report lD: BSCOR100
LayoutlD: BSCOR100 SUEZ Water ldaho
General Ledger System
Corp BS C/M vs Same Month PIYrBusiness Unit: 00060
Period Ending: Oec 31,2017
Run on 04/0218 at 05:48 PM
This
Year
(8,225.00)
0.00
7.88
0.00
0.00
0.00
(9,019,036.13)
(2,O23,135.67)
(502,586.92)
0.00
(270,319.52)
0.00
(4,650,911.52)
(424,900.34)
3,438,948.19
(21,007.98)
(31,241.60)
(3,370.76)
(14,322.85)
(10,780.32)
(151.e7)
(6,647.75)
0.00
(297,051.03)
(4,014.98)
(7,383.99)
(182.76)
(91,122.15)
(9,170.40)
(231,499.83)
0.00
(21,280.02)
(26,637.61)
(11,873.98)
(205.21)
(234,160.e5)
(100,849.08)
(98e.3e)
(2,121.50)
(50.e8)
(s6,807.72)
(78,e5s.35)
(17,126.36)
(18,800.44)
(456.07)
(47,399.06)
(140,467.84)
(361,073.84)
(504,456.60)
0.00
(6,935.70)
(224.98)
(e3,260.e9)
(1,282,525.32)
170,967.65
(1,535,934.47)
Last
Year
(1,100.00)
(4e6.9e)
(2.83)
272.88
(1,104.23)
(1,880.00)
(8,948,737.65)
0.00
(492,360.19)
(1,985,895.78)
(240,174.75)
(36,000.00)
(5,041,931.36)
(409,502.85)
3,218,136.40
(19,874.70)
(22,803.11)
0.00
(16,464.35)
(12,675.e3)
0.00
(15,342.94)
(1 ,455.91)
(301,650.65)
(2,958.21)
(8,3e4.28)
0.00
(116,77s.94)
(8,074.1e)
(215,319.87)
(1,028.27)
(25,403.87)
(18,264.39)
(9,123.85)
0.00
(198,802.26)
(85,838.32)
0.00
(2,106.99)
172.26
(89,241.53)
(85,238.70)
(6,651.59)
(9,264.37)
(184.17)
(43,933.3e)
(153,267.74)
(339,455.51)
(457,667.23)
(1,724.2e)
(3,166.93)
(68e.00)
(128,060.28)
(1,262,191.00)
232,333.00
(1,348,255.13)
lncrease
or
(Decrease)
7,125.00
(4e6.99)
(10.71)
272.88
(1,104.23)
(1,880.00)
70,298.48
2,023,135.67
10,226.73
(1,985,895.78)
30,144.77
(36,000.00)
(391 ,019.84)
15,397.49
(220,811.79)
1,133.28
8,438.49
3,370.76
(2,141.50)
(1 ,8s5.61)
151.97
(8,6e5.1e)
(1 ,455.91)
(4,599.62)
1,056.77
(1 ,010.2e)
182.76
(25,651.79)
1,096.21
16,179.96
(1,028.27)
(4,123.85)
8,373.22
2,750.13
205.21
35,358.69
15,010.76
989.39
14.51
223.24
7,566.19
(6,279.35)
10,474.77
9,536.07
271.90
3,465.67
(12,799.90)
21 ,618.33
46,789.37
(1,724.29)
3,768.77
(464.02)
(34,799.29)
20,334.32
61,365.35
187,679.34
- Current Month -
50655675 Misc Exp-T&D Maint - Services
50655903 Misc Exp-Cust Acct Rcrds&Coll
50655905 Misc Exp-Cust Acct Misc Exp
50655921 Misc Exp-A&G Ops Off Suppl&Exp
50655930 Misc Exp-A&G Ops Misc Gen
50655932 Misc Exp-A&G Maint Plnt
70100403 Depreciation - Utility Plant
70203408 Real Estate Tax
70250408 Payroll Taxes70300408 Property Taxes
90400904 Bad Dbt-WO-Custr Acct Uncollct
90405904 Bad Dbt-Provsn-Cust Acct Uncol
90850923 Corporate Shared Services Fees
90890426 Corp Shrd Svcs-Non Recoverable
90950000 F B T-ES
90950600 F B T-SOS Ops Sup & Eng
90950601 F B T-SOS Ops Lbr & Exp
90950603 F B T-SOS Ops Misc
90950611 F B T-SOS Maint Strctrs
90950614 F B T-SOS Maint Wls&Spr
90950616 F B T-SOS Maint Sply Mains
90950620 F B T-Pump Ops Sup & Eng
90950622 F B T-Pump Ops Pwr Prd Lbr
90950624 F B T-Pump Ops Lbr & Exp
90950630 F B T-Pump Maint Sup&Eng
90950631 F B T-Pump Maint Strctrs
90950632 F B T-Pump Maint Pwr Prd lmprv
90950633 F B T-Pump Maint Eq
90950640 F B T-Wtr Tmt Ops Sup&Eng
90950642 F B T-Wtr Tmt Ops Lbr&Exp
90950643 F B T-Wtr Tmt Ops Misc Exp
90950651 F B T-Wtr Tmt Maint Strct
90950652 F B T-Wr Tmt Maint Equip
90950660 F B T-T&D Ops Sup&Eng
90950661 F B T-T&D Ops Storage Faclt Ex
90950662 F B T-T&D Ops Line Ex
90950663 F B T-T&D Ops Meter Exp
90950665 F B T-T&D Ops Misc Ex
90950670 F B T-T&D Maint Sup & Eng
90950672 F B T-T&D Maint Rsrvrs&Stn
90950673 F BT-T&D Maint- Main
90950675 F BT-T&D Maint-Services
90950676 F BT-T&D Maint- Meters
90950677 F BT-T&D Maint- Hydrants
90950678 F B T-T&D Maint - Misc Plnt
90950901 F B T-Cust Acct Suprvsn
90950902 F B T-Cust Acct Mtr Rdng
90950903 F B T-Cust Acct Rcrds&Coll
90950920 F BT-A&G Salaries
90950930 FBT-A&GMisc
90950932 F B T-A&G Maint Plnt
91400924 Liabilitylnsurance-A&GOps
91460925 Workercomp-A&GOps-lnj&Dmages
91500926 Pension-A&GOps
91550926 Post Rtrmnt PBOP-A&G Ops-Pnsn
e 1 7R0,9ffi ,", .,E,!B{U"" G rp H lth& L-A&G op- Pnsn
Run Time: 9:28 AM Page 7 of 10
ReportlD: BSCOR100
Layout lD: BSCOR100 SUEZ Water ldaho
General Lodgor System
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 31, 2017
Run on 04/0218 at 05:48 PM
This
Year
(184,206.48)
(0.01)
(4,546.43)
0.00
0.00
(3,872.48)
(1 13,345.95)
(35,792.04)
(1,238.00)
(11,666.64)
(12,582.80)
(55,668,72)
(11,052.00)
(257,652.00)
(44,995.37)
(164.2e)
(745.82)
(160.62)
(76,442.13)
(8,516.76)
0.00
0.00
(798.98)
0.00
(84.00)
6,804.39
(49,271.21)
(28,914,878.75)
19,984,434.56
(4,386,057.82)
5,585.02
(2,988.32)
60,958.83
56,593.70
94,958.28
84.38
0.00
56,404.01
(28,856.33)
(76,424.97)
(20,712.00)
0.00
(4,240,455.22)
15,743,979.34
(5,346,350.24)
(1,111,712.31)
(82,676.00)
(54,062.00)
48,240.00
(6,546,560.55)
9,197,418.79
94,168,736.78
(9,097,360.79)
867,726.03
(8,229,634.76)
Page 8 of 10
Lasf
Year
(164,477.72)
0.00
(13,844.96)
(1,097.51)
(424.56)
(27,404.26)
(87,302.92)
(35,792.03)
(14,856.00)
(11,666.64)
(22,009.80)
(55,86e.68)
(44,847.98)
(257,657.02)
(43,463.75)
0.00
0.00
0.00
(56,684.47)
(143,349.37)
(48,000.00)
(13.88)
0.00
(2,561.80)
(4,610.94)
4,681.84
(41,906.36)
(29,214,952.85)
20,607,442.91
(4,566,614.30)
621.73
(2,432.27)
246,346.17
0.00
0.00
77,925.24
(66,201.14)
75,627.51
(15,252.22)
(30,876.20)
(22,532.00)
(9e,839.00)
(4,403,226.48)
16,204,216.43
(4,918,268.75)
2,238,462.00
(1,152,880.00)
(276,091.00)
48,240.00
(4,060,537.75)
12,143,678.68
86,345,915.50
(6,634,520.79)
1,409,359.03
(5,225,161.76)
lncrease
or
(Decrease)
19,728.76
0.01
(9,298.53)
(1 ,097.51)
(424.56)
(23,531.78)
26,043.03
0.01
(13,618.00)
0.00
(9,427.00)
(200.e6)
(33,795.98)
(5.02)
1,531.62
164.29
745.82
160.62
19,757.66
(134,832.61)
(48,000.00)
(13.88)
798.98
(2,561.80)
(4,526.94)
(2,122.55)
7,364.85
(300,074.10)
623,008.35
(180,556.48)
(4,963.29)
556.05
185,387.34
(56,5e3.70)
(94,958.28)
77,840.86
(66,201.14)
19,223.50
13,604.1 1
45,548.77
(1,820.00)
(99,839.00)
(162,771.26)
460,237.09
428,081.49
3,350,174.31
(1,070,204.00)
(222,029.00)
0.00
2,486,022.80
2,946,259.89
(7,822,821.28)
2,462,840.00
541,633.00
3,004,473.00
- Current Month -
91 800926
91 850000
91 850926
91 860626
91 860665
91 860926
91 900928
92000928
92050928
92050930
92052930
92053672
92056930
92061623
92064930
92200624
92200626
92200903
92200930
92300930
92450930
92600643
92600920
92600921
92600923
92600930
92600932
70800430
70900419
71 000431
71050419
71051419
71052419
71100415
71105416
71251418
71252426
71253426
71255406
71300426
801 00409
801 50409
8020041 0
8025041 0
8040041 1
21 800000
21 805000
Emplyee 401 K-A&G Ops-Pension
Other Employee Benefits-ES
Othr Emply Bnft-A&G Ops-Pensn
Other Awards-Pump Ops Misc Exp
Other Awards-T&D Ops Misc Exp
Other Awards-A&G Ops-Emp Pnsns
Regulatory Commission-A&G Ops
Amrt Rate Case-A&G Ops-Reg Com
Amort Dfrd Exp-A&G Ops-Reg Com
Amort of Dfrrd Exp-Misc Gen-A&
Amort Reloc-A&G Ops-Misc Gen
Amort Tnk Pntng-T&D Maint rsrv
Amort OPEB Csts-A&G Ops Misc
Amrt Pwr Csts-Pump Ops Fuel Pw
Amort AFUDC Eq GU-A&G Ops Misc
Uni&Sfty Eq-Pump Ops Lbr & Exp
Uni&Sfty Eq-Pump Ops Misc Exp
Uni&Sfty Eq-Cust Acct Rcrds&Co
Uni&Sfty Eq-A&G Ops Misc Gen
Bank Charges-A&G Ops Misc Gen
Severance Plan-A&G Ops Misc
Other G&A Exp-Wtr Tmt Ops Misc
Other G&A Exp-A&G Ops Salaries
Other G&A Exp-A&G Off Suppl Ex
Other G&A Exp-A&G Outs Srvcs E
Other G&A Exp-A&G Ops Misc Gen
Other G&A Exp-A&G Maint Plnt
Operating Expenses
Operating lncome
lnterest Exp-SW/Can cons co's
lnterest income
Other interest
AFUDC Gross Up
AFUDC Debt
AFUDC Equity
Mdse&jobbing-lncome
Mdse&Jobbing-Expense
Misc Non Oper Rental lncome
Misc lncome/Deduction
Non Recoverable
Amort of Util Plt Acquis Adj
Equity earnings of affiliates
Other lncome & Expenses
lncome before lncome Taxes
Current-federal
Current-state
Deferred-Federal lncome Taxes
Deferred-State lncome taxes
lnvestment Tax Cr,amortization
Provision for lncome Taxes
Current Year Earnings
Total Retained Earnings
AOCI - Pension
AOCI - PBOP
Accum Other Gomprehensive lnc
Run Date: 4116120'18
Run Time: 9:28 AM
Report lD: BSCOR100
Layout lD: BSCORl00 SUEZ Water ldaho
General Ledger System
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 31,2017
- Current Month -lncrease
or
(Decrease)
0.00
0.00
Ihis
Year
Last
Year
Oth Equity Noncontro! lnterest
Long Term Debt
Total Capitalization
Accounts Payable
Accounts Payable Reversing
Accounts Payable Non Reversing
AP - lnventory Accrued
Accounts Payable
A/P Affiliated Companies
Notes Payable
N/P Affiliated Companies
Current Portion of LT Debt
Customer Deposits
Property Taxes Accrued
Franchise taxes Accrued
Federal lncome Tax Accrued
State lncome Tax Accrued
FICA Tax Accrued
Federal Unemployment Tax Accr
State Unemployment Tax Accrued
Sales & Use Taxes Accrued
Other Accrued Taxes
Accrued Taxes
Accrued lnterest
Dividend Payable
Accrued - Payroll
Accrued - Power
Accrued - Sludge Removal
Accrued - Vacation
Accrued - Bonus
Accrued - Employee Related
Accr - Employee Related Other
Accrued Other
Employee Whg-401K
Employee Wthholding- Other
Other Current Liabilities
Total Current Liabilities
Def. Federal lnc Taxes- Other
Def State lncome Taxes- Other
Def Fed lncme Txs-Medicare
Def Stte lncme Txs-Medicare
Def. FIT-FAS109lTC
Del. FI-F7 1 lF1 09 G/U ITC
Def.SIT-FAS109 ITC
Def. SIT-F71/F109 G/U ITC
Deferred Taxes
Deferred ITC
Def. FIT-MACRS
Def. FIT- OCI Pension/PBOP
Def. FIT Benefit on DSIT
Def. FIT-Other
Def. FIT-Tank Painting
0.00
0.00
0.00
0.00
168,638,686.99 163,820,338.71 (4,818,348.28)
23200000
23210000
23211000
23220000
23601 000
2361 0000
23641000
23651 000
23661 000
23662000
23663000
23670000
23699000
24205000
24215000
24220000
24245000
24246000
24247000
24248000
24299000
24301 000
24330000
3,459,055.98
168,948.81
56,249.24
1,959.72
3,686,213.75
0.00
0.00
0.00
0.00
0.00
1,010,500.55
74,125.96
4,042,856.88
2,403,040.67
35,503.89
88.80
329.54
76,034.23
27,740.37
7,670,220.89
0.00
0.00
249,657.36
129,689.10
0.00
55,260.00
330,396.00
2,262.81
17,803.32
4,503.28
(20,1e2.23)
1 15.00
769,494.64
1,483,127.61
699,845.01
26,825.64
(1,431.37)
2,208,366.89
0.00
0.00
0.00
0.00
0.00
991,775.44
75,140.36
5,151,367.24
684,659.36
34,990.96
28.37
200.68
160,464.18
5,117.56
7,103,744.15
0.00
0.00
222,023.90
234,581.47
1,302.00
94,070.00
369,793.50
7,955.81
27,513.73
55,351.97
0.00
0.00
(1,975,928.37)
530,896.20
(29,423.60)
(3,391.0e)
(1,477,846.86)
0.00
0.00
0.00
0.00
0.00
(18,725.11)
1,014.40
1 ,1 08,51 0.36
(1 ,718,381 .31)
(512.93)
(60.43)
(128.86)
84,429.95
(22,622.81)
(566,476.74)
0.00
0.00
(27,633.46)
104,892.37
'1,302.00
38,810.00
39,397.50
5,693.00
9,710.41
50,848.69
20,192.23
(1 15.00)
243,097.741,01 2,592.38
12,125,929.28 10,324,703.42 (1,801,225.86)
1 901 0000
1 901 2000
1 901 3000
1 901 5000
1 91 01 000
1 91 03000
1 91 31 000
1 91 32000
36,638.18
(42,139.37)
1.00
(2.00)
(214,338.00)
(142,509.00)
(50,334.00)
(33,489.00)
(446,172.19)
663,874.00
10,041,452.33
(2,195,178.40)
(382,157.00)
323,379.00
232,709.00
(121,729.82)
(50,667.37)
1.00
(2.00)
(229,998.00)
(152,925.00)
(54,018.00)
(35,e37.00)
(645,276.19)
712,114.00
8,553,334.46
(2,821,102.40)
(382,157.00)
227,129.00
250,751.00
(158,368.00)
(8,528.00)
0.00
0.00
(15,660.00)
(10,416.00)
(3,684.00)
(2,448.00)
(1 99,1 04.00)
48,240.00
(1,488,117.87)
(625,924.00)
0.00
(96,250.00)
18,042.00
25500000
28203000
28206000
28211000
28300000
28301 000
Run Date: 4l'i.612018
Run Tlme: 9:28 AM Page 9 of 10
Report lD: BSCOR100
Layout lD: BSCOR100 SUEZ Water ldaho
General Ledger System
Corp BS G/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 31, 2017
Run on 04/0218 at 05:48 PM
28302000
28303000
28304000
28305000
28306000
28307000
28308000
2831 0000
2831 1 000
28312000
2831 3000
28314000
28350000
28353000
28354000
28355000
28356000
28357000
28358000
28359000
28360000
28363000
28364000
28365000
28405000
28406000
25200000
25200001
25201 000
Def. FIT-Rate Expenses
Def. F|T-Deferred Charges
Def. FIT-Relocation Expense
Def. FIT-M_S Fees
Def. FIT-Pensions
Def. FIT-PEBOP
Def. FIT-Cost of Removal
Def. FIT-Uncollectibles
Def. FIT-lnjuries and Damages
Def. FIT - AFUDC Equity
Def. FIT - AFUDC Equity GU
Def. FIT - AFUDC Equity GU-TRF
Def. SIT- Other
Def. SIT - Tank Painting
Def. SIT-Pensions
Def. SIT-Post Retrmnt Benefits
Def. SIT-AFUDC Equity
Def. SIT-Excess Depreciation
Def. SIT- Cost of Removal
Def. SIT- Relocation
Def. SIT- OCI Pension/PBOP
Def. SIT -Shared Services Fees
Def. SIT - AFUDC Equity GU
Def. SIT - AFUDC Equity GU-TRF
Def FIT - New Federal Tax Rate
Def FIT-New Federal TaxRate GU
Deferred lncome Taxes & Credit
Advances for Construction
CWIP nontaxable advances
Taxable Advncs/Servce Laterals
Cust Advances for Construction
Contribution in Aid of Cnstrct
CWIP non{axable CIAC
ln Service non-taxable CIAC
Taxable CIAC - Serv Laterals
CWIP taxable CIAC
ln Service taxable CIAC
Accumulated Amortization C IAC
Contribution in aid of Constru
PBOP Liability - Trustee
Pension Accrued
Pension and Benefits
Pension Regulatory Account
Regulatory Liab-Tax NewFedRate
DefRegLiab F71 /F1 09-Fed:lTC
Regulatory Liabilities
Other Deferred Credits
Accrued SE LTIP
Other Long Term Liabilities
Deferred lncome Taxes & Credit
Total Capital & Liabilities
This
Year
11,568.00
(97,443.00)
11,429.00
(458,444.00)
649,1 13.00
(754,399.85)
916,880.00
(108,154.00)
(310,942.00)
468,114.00
426,874.57
642,034.13
54,614.00
53,230.00
109,695.00
(347,958.72)
105,196.00
1,601,535.27
192,799.00
2,520.00
(810,901.84)
(112,799.00)
97,453.53
150,731.76
(3,531,015.00)
(1,295,809.04)
5,903,827.55
5,339,000.95
(299,102.09)
(482,573.32)
4,557,325.54
114,644,099.14
3,016,432.58
1,632,337.59
3,781,172.09
(10,213.18)
100,307.02
(35,839,719.09)
87,324,416.15
3,991,710.17
10,412,786.97
14,404,497.14
2,006,698.00
4,826,824.04
440,668.00
7,274,190.04
210,871.97
23,973.00
234,844.97
I 19,699,101 .39
Last
Year
23,168.00
(82,349.00)
15,508.00
(434,267.00)
243,579.00
(1,751,955.85)
600,790.00
(100,832.00)
0.00
437,131.00
421,700.57
634,212.00
38,735.00
57,350.00
17,102.00
(362,030.72)
98,160.00
1,749,981.03
120,798.00
3,451.00
(620,824.84)
(107,279.00)
96,272.53
148,946.00
0.00
0.00
7,142,138.59
5,369,135.95
(140,38e.95)
(482,573.32)
4,746,172.68
105,393,849.46
460,892.09
4,684,593.17
2,867,953.39
11,612.46
322,582.02
(33,291 ,746.31)
80,449,736.28
3,007,324.82
10,250,773.65
13,258,O98.47
1,658,021.00
0.00
472,876.00
2,130,897.00
233,093.46
30,299.00
263,392.46
- Current Month -lncrease
or
(Decrease)
11,600.00
15,094.00
4,079.00
24,177.00
(405,534.00)
(997,556.00)
(316,090.00)
7,322.00
310,942.00
(30,e83.00)
(5,174.00)
(7,822.13)
(15,87e.00)
4,120.00
(92,593.00)
(14,072.00)
(7,036.00)
148,445.76
(72,001.00)
931.00
190,077.00
5,520.00
(1 ,1 81 .00)
(1,785.76)
3,531 ,015.00
1,295,809.04
1,238,311.04
30,135.00
158,712.14
0.00
188,847.14
(9,250,249.68)
(2,555,540.49)
3,052,255.58
(913,218.70)
21,825.64
222,275.00
2,547,972.78
(6,874,679.87)
(984,385.35)
(162,013.32)
(1,146,3e8.67)
(348,677.00)
(4,826,824.04)
32,208.00
(5,143,293.04)
22,221.49
6,326.00
28,547.49
271 00000
271 00001
27100002
27101000
27101001
27101002
27110000
25340000
2631 0000
2531 1 000
25316000
25402000
25380000
25390000
107,990,435.48 (1 1,708,665.91)
300,463,717.66 282,135,477.61 (18,328,240.05)
Run Date: 411612018
Run Time: 9:28 AM Page 10 of 10
xoxF-
oNe(o
E
Efa
o)o
o3o(L()
f
o_
Eo
0)t()
fo-t-oN
6
oo-0)u
G
=Etr
()l(L
c.9o.9
E
Eooo.q.=E:)
.9
=fo-oE,oE
oo5a
c.9.NE
ciboo::€ FEgzAE9=*i5.qcEo
i;E$E?EEiE€?TFE:;5.13PEE;9=:gEEEET!ui:5 o6 >6; e 6*
EEzE+g€BEt;E=EEE=EEAqES<=3E^--fie=EfiEoa;.y!2E56Fo5tPEESEeE*rA@9rooli5=diiEEE;R#5p#egtr€xiiiEp,;-a:::EgF;Ef;[H€5
EEEEEaEfiEEfi;EEEPE^OTEEEEpg iE.EF E3[e,*g3EHE5erE
=t:F e l;:- F4
fiE€fesEIgEEsE.;EFtIE63=c?O:,.89:=iQ
HEE.:iSE#E=5E;;Ee?ti#=EeilEeSEfSsE;E€:E.5HEsiE6€E;eHi+xeHs.(i5gHEEEEEfriF;€EIfiiES"Efli-=E35HuH::=SPH
$:E$qf;E;$:-:a
EE€frHi!;EEE;
Enaii:EstEEEs
EIEfrEEics5;gSaEA;;Er-Eaq,FE-cDgO>FoXooE5g-IEEtEEEZ9&e:3f'$sE;sEB
EiEEEEfiiBiBE
^!e E I{tEfi -t,e
EFEfi EEESE;NE
(O(OF-(.)lr)ttF-\to)A@q o? u? q o{ c! oq a? oq o? q q oq
I 6 CO N <f O O) O) O) @ (O F- @ (O
st ti lr) r) 1O !t (O F- F- N N (O lr)Jc6oroN(.)$@o)(')(o@o,
@o@@@@@@@@@@@
U)ulFoz
@!sc.rro!tN!t<DO(Oolu?o?qqqe?qolqo?q@N!iod)c)6)o(oN@@(t(Dg)a', lOrO(It|oNF(lcrotoGa@U)NltNoc\l
oto6ld)!t@o)ct(ooo)NN6I(\lNNNF'C'('('
6 0 0 q @ o o @ 6 0 rD ah
rorof@(\lo(ttc.rlo(olo(o!tNotolortFNN<nocra-{loo)oo<D@ctN+(rNrtNo(oN!t(,iNloNrONNc{(o<oNGldddoiotidd+ddc{FNG,(Y)G/,N
ido
Eo6ttaeooo6aot*IEEI
ED
.=etr'aoo
Nt\o)F-F-N@tO)o)@aoq\9qqa?qqqrq(rrOor)F-|r)rr)C{F(oNq)tr)(o1.-NcOo)ON$F-Ot:c! (\l N c\| (r) (r)
@@@@@@,9(,@@@@
N(oe3)Fa.rN@o)Nt(!)Etlou)ltFNlO@?(,)N(olod)@@l\o)tOO)!t
ooN(OOOrGttNo)6l@O)+ttNltN<D(DrOtlo-qt-dco(o(oo(rrf)N@o@roFFfNc"tlortc.t(r,c,
,\! .TEFHHEF iE:,s 5 '- H E F i b E9; } t*E iaEiEE
E2
o
=E')tr
c
=oo.J
o(,
sEEtEso5-
6E(,
.>
c€a+QrgEE
E
oF
oco()EOY
=9E'
i-
E
6o
@c
Ea6o
:\6l6l@
c.i
o
6\ror,)t
cdo
:
("@Nol)u)F-rOON(Oe{AiF..(O(o(f)O)CO(OOOO)N--ri-++dci+oiccioro(ori@NO(')N\t(f)or!O(f)()(')|olr)o)\t(OO)o)o o o o, o - o o, + o o, -NN(.)CO
e(Uo-o o -oL 3a\O L-!:o-:o
lo
tr
E5oo
tc
E5oo
oo-(,,
EEEooo
oo-
o-6,:i o)
,sr k.cl -ctooIB!
@6@@@@@@@@@@
(9
c
E
=6o
co(,N
o(9r.ig:2Cs6-()troL
=6(g
.9
=o=!r;E6(!
CLo
o-
:oC'N
EE
SErc;b
6E
o!iruEofto.e 3cx<sE:835- o*
E BOstr eieEuJcE
=c=u, <.n
Nol
UI
NIIJfU'
o$ot-CCI(oOfr^do=N-{5EHkcoaiiE x O --.1-E o-:lo aco {"?
A83EHo
Eoq
(ECri0)f
^,4.uP-@ES; ExaaiAa6Lr- iDF-0) xO =^r.rv Ed ";i35Eo 3 qP(,)oo-o 6a(
d
EoP
=o)--!Cu'F O)
9l >,
=6oEoa
.o i!6c0):
o.=
:f;e
E*rcE*aiur= = o:EJ-:: o (D =-u)yaE=fre#EiE
3,E a;r E E:EEa==E=! l.c='oS 6
i:EaA;*
=EH=EgE;Eb()9?o)
E; E
=
EE #
E
.;!
E
tsI
,Bo
38,
ooooooc{ co@@
N!'@!@UcCOrlo=oN
6-Ei:
K=U=P(OqLo--d)oE-- oo9co+o-
EoX
'= A6EotrE Ovo--o;_o
-GEO
>oz=boo.Eod!o
E
:I63E:s q :.i-!@O
=>o:ili $e: = r
=
t ; E E E ;a E e g
- o o .9 E e:d'= 6 c
.ne F a n H a *E E s $s*Pe ASgEBE=9oi = P 5 E H E= [* H
8-H g,E E E H Ef E fi E3T d E- U = E AH F E 6t= = ot E o 6 o--9. q) o'-
Fe i +E f * r iE + i s
o).oaoao
o'=o-p(oo-
o)-o
af
Ea;EEFOsa,oYgg*-o
AT(I)0)
6EoEt;aoo,
E-=-o):-
, EH NE,goP oo t EEo
ecE= =;s fEE,.E,=-.gE: Ets$ #€EiE
isEs daa s:EsF
eeE;r :EaE,:0HEHg Gr.rid*o
fgeEs \ eEiEEEsiqEdd x ,S:3HH,;
SEcHF *= gEaEEEE
c!o)ro@-
:
o)PPoo-qq_rr)tr)l2 crl ez.e@
o^c{@
A^oa=.o 92do>
Effi?EE
*ge==sp x'5 ?f g
E re
=Efies = ='- = o J/ti*Eliree==oc_^\eK o 6 q.9 3I
g*g:E: r$
Z€;E E HE E53e5Hr(589g.q:ss 5 e ES 3 E 99 E T F
BUE
=
a E 3E
=dE E H3 E E
EB e
E=.;3E=98cCO guE; =-e!o;>'3Ei;B(,o;(Ua L'-c(u o0) -.
=94 ooc!c_
EE= i3 eH x
9: >hiho-c q oX L o: >'*o (5'= -or= o - =.E i el P'Eo 9'E o,3(I)-! c 0)S r;E = 8f;EE E A<505e> oo-ot:
g
o
E0)E ..>:(oY q
'ic a o aco= 'j==89 d e E d e
--ize.E k t h h 9 -oc;<=-ufLoE O = Cr(D 0 C,)(l)'Eo'E = (l)fl o (l)ts O
-H5t<'=E<o)aD EO .'i oE=a d5 o
=9a>E >-ooE o c2tt<) z. LL
U;(Do
0)
(Ea.; -:oo)xO.eE0) 0.)T@6oCO.-o
Y>.
;P
EEo) >.pE-6b
*9ooo€o)o:o !19Pt
l-- o
-lo)toltr)
o)l<oNlro@l@rrlrr
(o c!c2\c!$c!@@
ilI
(o cf)lo)co d)l(Q
N 6loN Nlra)@ @l@rrrrlrr
l.--@qolq(ooc!f-(OO(\$(o
@@@
@-
**HEh;
t P6,9E E+OEi;PO6;,3; P E
@oPPu?(orEe
;@- E!!(D oQe ov (U
=3=E
=o(Eo-(Uo
o(E
=oo)!
oooE
(Do
E
o
@o)
F-$
?
:
$
ot-qcq
@ro$F-(fr@
c{
@u?
@c{?.
I
LE:o-oo
"EfHE-.Hfr EXi q- E'E;. bE-a; q E ^eEE Eex;ii*#Eo 3s
saAEEgEi i i
:;ErEg;;e i io E =;Y'=- o- : :.A+rCrF=6P::
H;HsEtE,EI ig
E 9,E=E EE aE J E
==F=hE-x?o.NoEfiTPE'EH: ?E.B;E:eEEEH Es
:
N
I
$
(o
I
s
c,(D!,oaD
o
!A'
3(D
ocq,
o,
(Doo
vE
(Do
o
6{
=.t!
=,o
o
COo
3.oo
(o +o --{
o) @o (D
= =o -= r< r
0'-.D e h3 q=*ihe9N0) >.o-o) (DOf-(D*coiSto-
=aa9c o:-=:(D o-Q-oo€c-_
(D-o:
^o=e-gE6o*urova-9 Bo +Fo 5'oo=^'
=!r*dlEJ@6
= e?d q'="'N) -a Sr I SD N -6'Fi o, (, s <, N) -=.=j= i6 N=.
ggggieg-
EgUIE*g**gl*Ei agE
E g'g
igaIgi
;*B+Fsa ga ri a E-e's.; i E a g 13E=s
*r3*sa3 ! a;
=
a g E € + a a 3e*EE
CL=rCL (, +'.<- (,a, o)i+9sd; asee-EE 3 # r sE di{4*;a i4qq*qE= E aefits+$38 i}3*;*eE Haae-6€F igF B=d 9 q,B=Eee= $re =3196r*=Rdil ax= JS;" I ;P-
===& i=[ gSE H t33fiEi= a[s ++Et*i*6=El =I 8 e=: * I i=.irsq q*; so E q;-:- € q!q= o o- d-o- )- a=
$-ad
EEaEIIggEgtt*ig+3ig
EEEE4lE+E$EEE1EEEq EfiE E sgtt+g3 q
E +,,E AiilE1:= Egigg * * flg.e;sgila asH$
E s = o3(D .i;E
@ao cncnA(D - C (D5=.3 3=.$C)^.so- o =< (D
iJ f <
-Oo: d o-.P Ia;.P E
=s(D = =+a-JoUxo 3 =o;ia6-ay =.q< a'
.3 il gi 8R$l(D r5<Q?oEd 3f (D =.fr:8 H ii!2 O-oO(D ='€<o{ ltO nr *=.(D = =o=€ o q),^<dS- # -,r,
-o A-O)9 =o c
= o +c!
SFFP*<a
P +€ -r
se e {
-E r=
^: ^ =.eE H=P(D q ='i5
=rae-< S=
=u, o Oo n-A += -{o 6
d o'dX
^. o *Y
O-'" Oo =o (D5< 6 3-:860.H9q)-Jco='
=l o
5.o oB6'3o_ irj 26'E
€.a=
ZE o
xe8fm6'I N*
ui;i=o@=.de B
+E !Yo€ *o(D=E-E eYo<5'^< o
a 938 6-=
dq6o-oE3I-o o
f^'(Dx9do'=
==.€q=.o6.=C)o < =(u- ii s O
:6 5 6 q i ieE
=:+r;; *1si q: g*B 3 3 A
9EA
=,E"8
K ;r='=-5 PE n
- - O - r:Yila= s 3E6='+=??e.e9 9 =n'3 =Q ypd;__og
< =(o == f
$1==#HBAY ii -ro o Q l.'-:c =o o )x fR=o=o-v'(o
-:oE+o(D I C -O) -9=9=.9q)
=e9-:aQ.(D *=cX =m
r3e E
==o (D =(DI*=So-d =o'Eg 3 i9d*=a9.9 X a'+Joo-.aEEPo o: tsY. (D ='@=f==(o:-- o-.o =o?gd=(D <:=@: u=
o f ='-+ot o (r 6Q u3a*(Dg d:ABEdea&c=x=.o o
=o a'< 6-*o o-"
x = o I <vY6a:+oq,idE E et69.061 o.:CDU,
=6'-o=9e g E=i.i B.<=9daeE 5 Ea-(Doi=o=3:: a q
=Houj=; =t E eg#E &s
=9 0 iio:J-q[3=
o^-(Dac?-eRq t&5 Bqc (D _?
=- v !1\e o:oco(D@o I o(D(D 1_- do-o = -*o X oi9 =b-a'
mp >cD 0) qlq =au,E€AE ==ETEEil:as =aH = rs
Ha3 E 33 sd il g
i.-a -qQd-GiE(o'={o: " ? J o q
"q.: + 3 8E d a'ts€E=:1d3dHi
=
B 4B=98c.o e =(E o) ^, mt ='a 9Io= = N
= 3.9 I aiii ?o(D = - -:-!-l 0*td =:dEg;AP t.d3;o-i 679oPYR <,qEqid-{E < (Oqdq' Sgag- q6da
= o ='< -= o-- (D
€ o9lq