2018Annual Report.pdf

&2, u)
03
ANNT]AL REPORT
h:r
OF
SUEZ Water ldaho lnc
NAME
P.O. Box 194420.ise, lD 83719 - 0420
ADDRESS
TO THE
IDAHO PUBLIC
UTILITIES COMMISSION
FOR THE
YEAR ENDED: DECEMBER 31 ,2018
ANNUAL REPORT FOR WATER UTILITIES TO
THE IDAHO PUBLIC UTILIT!ES COMMISSION
FOR THE YEAR ENDING: December 31,2018
1 Give full name of utility
Telephone Area Code ( )
E-mailaddress
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
9 Organization (proprietor, partnership, Corp.)
10 Towns, Counties served
12 Contact lnformation:
President
Sr. Vice President, Finance
Secretary
Vice President, General Manager
Complaints or Billing
Engineering
Emergency Service
Accounting / Finance
COMPANY INFORMATION
SUEZ Water ldaho lnc
[phone]
Website: www.mysuezwater.com Email: [e-mail]
April2,1928
ldaho
8248 W. Victory Road
P.O. Box 190420
Boise
ldaho
83719-0420
Phone No.
01 767-9300
767-9300
Kel K.iero 767-9300
Marshall
Marie Flores 362-7308
Corporation
Towns: Boise, Eagle, Meridian
Counties: Ada
11 Are there any affiliated Companies?Yes
lf yes, attach a list with names, addresses & descriptions. Explain any services
provided to the utility.
n
Marshall
Jarmila M
or John Lee 1
362-
13 Were any water systems acquired during the year or any additions/deletions made
to the service area during the year?Yes
!f yes, attach 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
City
State
zip
461 From Road Suite 400
Paramus
New Jersey
07652
Page 1
Name: SUEZ Water ldaho lnc
COMPANY INFORMATION
For the Year Ended December 31 2018
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
The Brian Subdivision Water Users' Assocation acquisition was completed in 2018.
Suez water service is now provided to these 46 customers.
Page 1 Detail
NAME: SUEZ Water ldaho lnc
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?
\l/hen does the contract expire?
\l/hat services and rates are included?
17 ls water purchased for resale through the system?
18 lf 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 2018
No
Yes (3 service locations on Joolin Road)
City of Garden City
Garden City Public Works - Finance Department
6015 Glenwood
Garden City
ID
83714
Gallons Amount
657 ,492 $ 1,789
No
Yes
An upgrade of the 16th Street well head
was recommended by DEQ. Project started
in Fall2018 and will be completed in late
spring 2019.
650
224
1,220
1,220
Jan. - Mar.2019
Page 2
Yes
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
PAGE 1 OF 1
4t12t2019December 31 201 8
24. SIGNIFICANTADDITIONS TO THE PLANTACCOUNT
ADDITIONS (Over $100,000 Gross)
NO. DESCRIPTION AMOUNT
1 ''F' NEW, REPLACEMENT & FIRE SERVICES 2,351,461
2 "D" HYDRANTS & MAINS 1,677,448
3 "G'' NEW & REPLACEMENT METERS 946,660
4 C17D631_060_001 Repl Pipelines Terrace Press Zone 732,104
5 C18D605_060_001 \Mnter BSU Main Repleqelleq!646,341
6 C17D357 060 001 Avimor Sub No 6 575,779
7 C18D701-060_001 State and Veterans MainRgplacement 51 8,1 55
8 C17D103_060_001 Terrace P ule Zone Pipeline Bore 461,729
I C18D604_060_001 Spurwing Water Main Upgrade Phl 418,845
10 C18D603_060_001 North Mountain Piping lmpr 414,397
11 C17D358_060_001 Warm Springs Village 352,49012 C17C527 _060_001 Lower Danmor Pump Pipe Elec Replcmt 337,442
13 C17C526-060_001 Briarhill Booster Station Upgrade 334,770
14 C17C506_060_001 Boise River lntake Retaining Wall 332,52815 C18C102_060_00'l Bltllder Booster Upgrade 306,630
16 C17D634_060_001 Replace Horizon PRV 294,24017 C17D604_060_001 Highland View & Wyndemere 289,210
18 C17D332_060_001 Boise Fire Training Facility 278,783
19 C18D304 060 001 Tree Farm Sub No 2 244,327
20 C17A327 _060_001 Olivetree at Spurwing Sub 236,462
21 C17D370 060 001 Gowen lndustrial Park 233,761
22 C17D312 060 001 Dallas Harris Estates No 16 225,111
23 C17D337 060 001 Fed Ex Ground 224,664
24 C17D343 060 001 Tree Farm Sub No 1 223,072
25 C18D703 060 001 Emerald - Garden to Roosevelt 213,873
26 C18D318 060 001 Williamson River Ranch Sub 1 202,92727 C17D108 060 001 LancasterPRV 202,512
28 C17D102 060 001 Hill Road 24lnch 196,35929 C17D320 060 001 Lanewood Estates No 2 196,350
30 C17D'106_060_001 EastValley PRV 194,244
31 C17D107_060_001 Signal Rock PRV 186,49632 C17D329 060 001 LakemoorSub No 7 183,288
33 C17D344 060 00't Roe Street Townhomes No 1 '175,635
34 C17D331 060 001 Cimarron 170,086
35 C18C 1 01 060 006 Ten Mile Well Pump 165,439
36 C178509 060 001 EE! SAq IUedia Replacement 160,078
37 C17D105_060_001 Warm Springs Main Ext HV to Theresa '153,604
38 C17D603_060_001 Haydo4 aqd Encanto Main Replacement 149,791
39 C'17D372 060 001 Bonneville Pointe Sub No 2 145,8'l 9
40 C17K006 060 001 Add Fall Restraint - Water Tanks 142,029
41 C18C101_060_00? Rqplace Raptor Well Pump 139,31042 C18K104_060_001 NW Area Water Supply Study '137,605
43 C17D610_060_001 Hidden Valley #2 Discharge 135,92844 C17D313_060_001 Painted Ridge Sub No 4 124,608
45 C'17C104_060_001 Hidden Valley Rim PRV Flow Meters 121,33646 C17D374_060_001 Hazelwood Village Sub No 16 114,078
47 C17K101_060_001 Hydraulic Model Update I 13,63048 C18K101_060 002 Fire & Security Alarms 112,843
49 C18D323_060_001 ZOO Boise Goronpsa 112,236
50 C17D326_060_001 Hazelwood Villaqe Sub No 15 108,284
Page 2 Detail
Additions
TOTAL 16,714,798
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31,2018
PAGE 1 OF 1
04112119
24. SIGNIFICANT RETIREMENTS FROM THE PLANT ACCOUNT
RETIREMENTS (Over $l 5,000)
NO.
1 "G"
DESCRIPTION
RETIREMENT OF METERS
BOOK
COST
$ 455,316
2 C18E502 060 001 Cartwright Tank Removal $ 252,970
3 c16D630 060 001 System ReplaceO psMeters Quantify=!7 $ 150,800
4 C18K101 060 002 Fire & Security Alarms $ 138,748
5 C17C100 060 017 Abandon Central Park Well $ 118,442
6 C178509 060 001 Fisk GAC Media Replacement $ 103,333
7 C17J515 060 001 SCADA Hardware and Displays Repl $ 92,403
I c18C101 060 006 Ten Mile Well Pump $ 86,687
9 c17C526 060 001 Briarhill Booster Station Upqrade $ 78,869
10 C17C527 060 001 Lower Danmor Pump Pipe Elec Replcmt $ 69,995
11 c18C101 060 002 Replace Raptor Well Pump $ 62,000
12 C18D701 060 001 State and Veterans Main Replacement $ 49,140
13 C18C102 060 001 Boulder Booster Upqrade $ 36,337
14 C17J510 060 001 SCADA Radio Replacement $ 35,908
15 c188505 060 004 HP CL2 Cell Rebuild $ 35,235
16 C17D633 060 001 Master Meter Replacement $ 33,942
17 C188505 060 002 Repla ce Chemical Pumps and Tanks $ 32,468
18 c17D604 060 001 Hishland View & Wvndemere $ 30,827
19 C17J513 060 001 Opto PLC Replacement $ 29,800
20 c178505 060 008 Pioneer NaOCL Generator
21 c17C100 060 018 Repl Pleasant Valley Well Mtr Brqs $ 19,036
22 c17J514 060 001 Replace lT Equipment $ 16,500
23 C17J509 060 001 PowerMonitoring-re place@l3wellSites $ 15,600
24 C18C101 060 008 Replace Veterans Well Meter & Valve $ 15,000
TOTAL $ 1,984,027
Page 2 Detail
Retirements
$ 25,670
NAME:SUEZ Water ldaho lnc
REVENUE & EXPENSE DETAIL
For the Year Ended December 31 2018
ACCT #DESCRIPTION AMOUNT
1
2
3
4
5
6
7
I
4OO REVENUES
460 - Unmetered Water revenue
461.1 - Metered Sales - residential
461.2 - Metered Sales - commercial, industrial
462 - Fre Protection Revenue - Private
464 - Other revenue
465 - lrrigation Sales revenue
466 - Sales for Resale
400 Tota! 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 & Fuel for 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)
33,121,406
14,374,986
131 012
(221,058)
o
10
11
274 097
48,406,346
Booked to Acct #:
23699000
284 454 23610000
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
2,571,477
101 891
922 766
1,510,088
168,466
2,411,288
335 785
439
4,643,872
100 908
748,557
12,547
496,523
122,907
114,662
35,792
11 667
325,941
Page 3
849,1 93
16,724,662
239,894
Name
ACCT #
SUEZ Water ldaho lnc
INCOME STATEMENT
For Year Ended
DESCRIPTION
December 31 2018
1
2
3
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 - Other Taxes
409.10 - Federal lncome Taxes
409.11- 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,406,346
16,724,662
9,826,188
4
5
6
7
8
9A
9B
9C
9D
10
11
12
13
14
15
16
17
1B
19
20
21
22
23
24
25
26
27
28
29
30
31
32
20,712
106,552
1,996,065
508,276
3,395,283
1,118,787
206,861
46,446
48,240)
33,901,592
16,905
Net Operating lncome (Add lines 1,17 &18less Iine 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 - tt/iscellaneous Non-Utility lncome
426 - Miscellaneous Non-Utility Expense (Largely CIAC due to new tax law)
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 & 3f ) (Also Enter on Pg 9, Line 2)
Page 4
14,521,659
606,237
67,744
(514,515)
1,188,496
15,710,155
3,958,875
6,237
11,745,043
Name: SUEZ Water ldaho lnc
SUB
ACCT #
301
302
303
304
305
306
307
308
309
310
311
320
330
331
333
334
335
336
339
340
341
342
343
344
345
346
347
348
For Year Ended:
DESCRIPTION
Organization
Franchises and Consents
Land, Land Rights & Water Rights
Structures and lmprovements
Reservoirs & Standpipes
Lake, River & Other lntakes
Wells
lnflltration Galleries & Tunnels
Supply Mains
Power Generation Equipment
Power 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
Offlce Furniture and Computer Equipment
Transportation Equipment
Stores Equipment
Tools, Shop and Garage Equipment
Laboratory Equipment
Power Operated Equipment
Communications Equipment
Miscellaneous Equipment
Other Tangible Property
Rounding Difference
TOTAL PLANT IN SERVICE
Balance
Beginning
ofYear
Added
During
Year
Removed
During
Year
Adjustments
During
Year
Balance
End of
Year
103 738
3,92
1
2
3
4
5
o
7
8
I
'10
11
12
13
14
15
16
17
18
'19
20
21
22
23
24
25
26
27
28
29
30
738
41 182
793
41 I
11 11 707,124
8 189
511
8 077
60 351
2
17
11
197 353
763
16,176,971
10
1
8,149,478
51 130
25,077
237 017
1 1,949,008
994
564,'160
15 766
7 7
11 21 852
19,635
337,855
79
0
432,456,469 19,909,460 (2,289,845)
1 ,943
11,278,831
773
1
7
18
450,076,083
2
0
Enter beginning & end of year totals on Pg 7, Line 1
7,715 (4,000)
576,683 (119,724)
8,1 89
332,528
535 (72,710)
105,483 (9,161)
1,764,623 (633,767)
572,142 (284,592\
142,029 (252,970)
9,211,588 (188,230)
3,787,509 (1,e06)
958,521 (45s,316)
'1,551,368
214,996 (155,017)
1,245
12,064 (5,615)
1.765 (3,966)
(e55)
372,491 (101,916)
9.047
278,939
Page 5
ACCOUNT 101 PLANT IN SERVICE DETAIL
December3l,2018
Name: SUEZ Water ldaho lnc
ACCUMULATED DEPRECIATION ACCOUNT I08.1 DETAIL
For Year Ended:December 31 2018
1
2
3
4
5
6
7
8
I
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
SUB
ACCT #
304
305
306
307
308
309
310
311
320
330
331
333
334
335
336
339
340
341
342
343
344
345
346
347
348
301
303
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
Backflow 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
Organization
Land & Land Rights
Cost of Removal / Salvage
Rounding
TOTALS (Add Lines 1 - 251
Annual
Depreciation
Rate *
2.00% 2.50% Office
2.00Yo
2.00o/o
2.86Yo
2.00o/o
2.
5.00%
5.00%
5.00% 14.28o/o Filters
2.00Yo
2.00%
2.50o/o
2.50o/o
2.50Yo
2.00o/o
2.00o/o
6.670/o 10.00% 20.00Yo
11.49%
6.670/o
6.670/o
14.50o/o
6.670/o
6.67Yo
10.00% Master Plan
00o/o
Balance
Beginning
Balance
End of
lncrease
or
524 180
27
27 714
151 172
57 387
17
60
1 114
J 553
1 ,67 144
18 131
1 539
133
31
17 941
703
161 579
043
187 080
5271
8.230.063 8.754,243
27
469,905 497,619
3,837,536 3,988,707
44,451 45,658
773,117715,730
1.148.494 1 .319,321
14.7 54,978 15,363,316
20,027,415 21,373,529
3.849.220 3,612,565
58.172.218 61.669.771
27,305,663 28,975.807
475,605 377,500
1,221,847 1,401,978
6,596,009 7,861,549
83,829 85,962
19,635 50,871
694,942 776,947
251,135 269,075
107,284 107,987
1.712.873 1,874,452
91,624 97,667
684,941 872,021
(810)
(52.955)
0 (0)
160,095,924
Page 6
Name: SUEZ Water ldaho lnc
BALANCE SHEET
For Year Ended
ASSETS
DESCRIPTION
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
Subtota! (Add Lines 1 - 5)
Accumulated Depreciation (From Pg 6, Line 28)
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 - 121
lnvestment in Subsidiaries
Other lnvestments
Total lnvestments (Add lines 14 & 15)
Cash
Short Term lnvestments
Accts/Notes Receivable - Customers
Other Receivables
Receivables from Associated Companies
Materials & Supplies lnventory
Prepaid Expenses
Unbilled (Accrued) Utility Revenue
Provision for Uncollectable Accounts
Total Gurrent (add lines 17 -24less line 25)
Unamortized Debt Discount & Expense
Preliminary Survey & lnvestigation Charges
Deferred Rate Case Expenses
Other Deferred Charges
TotalAssets (Add lines 13, 16 & 26 - 30)
December 31 2018
1
2
3
4
5
6
ACCT #
101/106
102
103
107
114
Balance
Beginning
of Year
7 06
60 761
440,',125,662
150 49 397
17 113
152
11 054
11,054
41 592
56 787
187 210
476 294
72 000
415
311 000
450 382
832
35 792
4 678 088
Balance
End of
Year
lncrease
or
17 619 16
218 11
28
7 108.1
8 108.2
I 108.3
10 110.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
I 7
20 712
1 17
4
158 392
178 314
71 3
429
71
,532
618 146
0
110 789
450,076,084
13,287,345
600,761
463,964,190
160,095,924
194,825
303,673,441
,05411
11,054
41,550
1,410,395
8,896
548,147
72,000
2,985,863
382,000
4,684,850
1,450,393
35,792
4,788,877
314,644,407
Page 7
300,463,716 14,180,691
Name: SUEZ Water ldaho lnc
BALANCE SHEET
For Year Ended December 31 2018
LlABILITIES & CAPITAL
ACCT #DESCRIPTION
201-3 Common Stock
204-6 Preferred Stock
207-13 Miscellaneous Capital Accounts
214 Appropriated Retained Earnings
215 Unappropriated Retained Earnings
216 Reacquired Capital Stock
218 Proprietary Capital
Total Equity Capital(Add Lines 1-5+7less 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 I & 30)
** Only if Commission Approved
Balance
Beginning
of Year
Balance
End of
Year
lncrease
11
11
or
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
31
81 437
I 939 102
686 14
261 750
224
1
1
1
445
769 495
4 557 326
11 060 077
874
10 1 787
123 1 135
71
5 622
131 031
1 094
683 723
81
174
1
4B
864
249 194
764 1
781 924
2,488,645
1
1,261,750
81,437,835
97,631,147
180,330,732
2,122J20
1,159,347
7.129,621
851,087
4,383,091
10,232,950
615,634
7.548.485
132,413,329
(38,604,533)
6,462,545
134,313,675
314,644,407
Page 8
300
80
718 1
Name: SUEZ Water ldaho lnc
STATEMENT OF RETAINED EARNINGS
ForYearEnded: December3l 2018
3 Other (Credits) / Debits to Account
4 Dividends Paid or Appropriated
5 Other Distributions of Retained Earnings
8
1 256 824
(1,198,229)
6 Retained Earnings Balance @ End of Year _w,631,147
CAPITAL STOCK DETAIL
No. Shares No. Shares
7 Descri AS Par Value etc.Authorized Outstandi
Common Stock $50.00 Par Value 50 000
DETAIL OF LONG.TERM DEBT
n
lnterest
Rate
None - Held Parent SUEZ Water Resources lnc
Year-end
Balance
lnterest
Paid
Dividends
Paid
1 1 229
lnterest
Accrued
25,235
Page 9
1 Retained Earnings Balance @ Beginning of Year 85,939,102
2 Amount Added from Current Year lncome (From Pg 4, Line 32) 11,633,449
Name: SUEZ Water ldaho lnc
SYSTEM ENGINEERING DATA
ForYear Ended: December 31 2018
1 Provide an updated system map if signiflcant changes have been made to the system during the year
2 Water Supply:Type of
Treatment:
(None, Chlorine
Water
Supply
Source
(Well, Spring,
Rated
Capacity Fluoride
Filter etc.
Annual
Production
Pum ation or location P Gal Surface
See attached Treatment
3 System Storage
Total
Capacity
000's
Gal.
Usable
Capacity
000's
Gal.
Type of
Reservoir Construction
(Elevated,Pres- (Wood, Steel
e Des nation or Location urized Concrete
See attached
(Duplicate form and attach if necessary. Asterisk facilities added this year.)
Page 10
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31 2018 04t12t19
ro.T Notes
Dt,rrll
SOURCE
73.298 NaOCI ('t2 to '15%). PO4 Ground Water116TH ST 800
2 350 58,082 NaOCI (12 to 15%)Ground Water27TH ST
Ground Water3AMITY700207,423 NaOCI<'1%, PO4
Ground Water4ARCTIC70027,124 I 12lo
185.018 Green Sand. NaOCI <'l%Ground Water5BALI HAI 2,400
6 600 NaOCI (12 to 15%)Out of service in 2018 iround WaterBEACON
Ground Water7BERGESON700NaOCI (12 to 15%)Out of service in 2018
Ground Water8BETHEL2,500 919,831 NaOCI <1%
Ground WateroBIF2505s,622 NaOCI (12 to 15%), PO4
179.930 NaOCI <1%Ground Water10BROADWAY1,000
11 850 43,698 NaOCI (12 to 15%), PO4 Ground WaterBROOK HOLLOW
Ground Water'12 BYRD NA NaOCI (12 to 15%)Out of service in 2018
Ground Water13CASSIA 1 900 118,980 NaOCI<1%, PO4
67.359 NaOCI <1%Ground Water14CASSIA 2 800
15 291,991 NaOCI <1%Ground WaterCENTENNIAL750
16 CHAMBERLAIN 1 250 16,821 NaOCI(12 to 15%), PO4 Ground Water
Ground Water17CHAMBERLAIN 2 600 35,784 NaOCI ('12 to 15%)
Ground Water't8 CLIFFSIDE 800 195,295 NaOCI (12 to 15%)
Ground Water19CLINTON1,300 246,652 NaOCI(12 to 15%), PO4
20 700 46,386 NaOCI (12 to 15%) & ASR Ground WaterCOLE
21 800 146,112 NaOCI (12 to 15%)Ground WaterCOUNTRY CLUB
22 COUNTRY SQUARE 1,100 146,778 NaOCI (12 to 15%)Ground Water
Ground Water23COUNTRYIVIAN50012lo 1N Out of service in 2018
Ground Water24DURHAM20052,394 NaOCI (12 to 15%)
Ground Water25EDGEVIEW80029,963 NaOCI (12 to 15%)
1,900 463.401 NaOCI<'t% GAC Ground Water26FISK
27 1,000 71,899 NaOCI (12 to 15%)Ground WaterFIVE MILE 12
Ground Water28FLOATING FEATHER 3,000 681,123 NaOCI <1%
21.824 Ground Water29FOX TAIL 1,000 NaOCI (12 to 15%), PO4
30 1,200 367,121 NaOCI <1%Ground WaterFRANKLIN PARK
31 FRONTIER 1 1,750 63,582 NaOCI (12 to 15%), ASR 3round Water
Ground Water32GODDARD 1 1,300 192,532 NaOCI <1%
Ground Water33H.P 1,100 371,168 NaOCI<'l%
261,380 Ground Water34HIDDEN VALLEY 1 950 NaOCI <'l%
35 750 51,749 NaOCI(12 to 15%)Ground WaterHIDDEN VALLEY 2
Jb HILLCREST 750 308,656 NaOCI <1%Ground Water
37 HILTON 1,400 388,499 Green Sand, NaOCI <1%Ground Water
Ground Water38HUMMEL60012lo 1 Out of service in 2018
Ground Water1.O IDAHO 375 NaOCI t 12lo 15%), PO4 Out of service in 2018
Ground Water40ISLAND WOODS ,I 800 80,020 NaOCI (12 to 15%)
Ground Water41ISLAND WOODS 2 800 59,618 NaOCI (12 to 15%)
107,31 5 NaOCI (12 to 15%)Ground Water42JR FLAT 450
43 300 113,737 NaOCI (12 to 15%)Ground WaterKIRKWOOD
44 LA GRANGE 1,350 281,770 NaOCI <1%Ground Water
45 LICORICE 190 50,539 12lo 1N Ground Water
Ground Water46LOGGER750142,355 NaOCI<'t%
Ground Water47LONGMEADOW25013,494 NaOCI (12 to 15%)
64,900 NaOCI (12 to 15%). PO4 Ground Water48MAC1,200
1,800 443,989 Green Sand. NaOCI <1%Ground Water49MAPLE HILL
50 500 26,613 NaOCI <1% ASR Ground WaterMAPLE HILL 2
E,4 IUARKET 700 58,647 NaOCI (12 to 15%) & ASR Ground Water
Ground WaterazMCMILLAN800't03,553 12to 1N
Ground Water53OVERLAND Well 1,000 107,685 NaOCI <1%, PO4
500 50,591 NaOCI (12 to 15%)Ground Water54PARADISE
ET 1,200 348,126 NaOCI <1%Ground WaterPIONEER
56 PLEASANT VALLEY 1,800 435,534 NaOCI <1%Ground Water
57 RAPTOR 1,000 158,831 Na 12lo 1 Ground Water
Page 10 Detail A Treatment (Page 1 of 2)
PUMP CAPACITY PROO
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31 2018 04t12t19
SITE
NO.
PUMP
DESIGNATION
RATED
CAPACITY
{GPM}
ANNUAL
PROD
(1000 GAL)
TYPE OF
TREATMENT Notes
WATER
SUPPLY
SOURCE
58 REDWOOD CREEK 1 1,800 60,1 79 NaOCI (12 to 15%)Ground Water
59 RIVER RUN 900 18,847 NaOCI (12 to 15%)Ground Water
60 ROOSEVELT 1 700 69,957 NaOCI<1%, PO4 Ground Water
61 ROOSEVELT 3 600 201.786 NaOCI<1%,PO4 Ground Water
ol SETTLERS 1,000 28,316 NaOCI (12 to 15%) & ASR Ground Water
OJ SPURWING 2,000 NaOCI (12 to 15%)Fire Standby Ground Water
64 SUNSET WEST 2,000 s86,488 NaOCI <1%Ground Water
65 SWIFT 1 1.100 55,923 NaOCI(12 to 15%) GAC & ASR Ground Water
bb SWIFT 2 900 142,378 NaOCI(12 to 15%) GAC & ASR Ground Water
67 TAGGART 1 300 98,316 NaOCI <1%Ground Water
68 TAGGART 2 750 243,249 NaOCI <1%Ground Water
69 TEN IVILE '1,000 NaOCI <1%Out of service in 2018 Ground Water
70 TERTELING 425 52,337 NaOCI (12 to 15%)Ground Water
71 VETERANS 740 180,635 NaOCL <1%Ground Water
72 VICTORY 600 245,337 NaOCL <'l%Ground Water
VISTA 450 171 ,207 NaOCI (12 to 15%). PO4 Ground Water
74 WARM SPRINGS 2 450 NaOCI ('12 to 15%)Out of service in 2018 Ground Water
75 WARM SPRINGS 3 600 NaOCI (12 to 15%)Out of service in 2018 Ground Water
76 WESTMORELAND 350 33,749 NaOCL (12to 15%\Ground Water
77 WILLOW LANE ,I 500 NaOCI (12 to 15%), PO4 Out of service in 201B Ground Water
78 WILLOW LANE 2 370 36,126 NaOCI(12 to 15%)Ground Water
79 WILLOW LANE 3 300 46,062 NaOCI(12 to'15%)Ground Water
1 Columbia WTP 4,170 1,343,708 Membrane Filtration, NaOCI <1%Surface Water
2 Marden WTP 12,700 3,003,225 Conventional Filtration, NaOCI <1%Surface Water
15,652,615
Asterisk facilities added this year
Page 10 Detail A Treatment (Page 2 of ?)
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31,2018
Page 10 - 3. System Storage
04t12t19
SITE
NO
STORAGE
DESIGNATION
RESERVOIR
STORAGE
CAPACITY
(1,000 GALLONS)
AVAII.ABLE
CAPACITY
({,000 GALLONS)
TYPE
Elevated
Boosted
Both
CONSTRUGTION
Concrete, Steel,
Wood
1 Aeronca Tank 150 140 Boosted
2 Arrowhead Tank 445 444 Elevated Concrete
3 Arrowheadl Clearuvell 30 29 Both Concrete
4 Arrowhead2 Cleanruell 30 29 Both Concrete
5 Barber Tank 2,000 2,000 Both Steel
6 Bogus Tank 360 350 Both Concrete
7 Boulder Tank 630 600 Both Concrete
8 Braemere Tank 200 200 Both ConcreteIBriarhill Tank 2s0 250 Both Concrete
10 Broken Horn Tank 662 657 Elevated Steel
11 Claremont Tank 1 90 90 Elevated Concrete
12 Claremont Tank2 192 192 Elevated Concrete
13 Columbia Tank 3,000 1,500 Elevated Steel
14 Columbia WTP 1,500 1,200 Both
15 Crestline Tank 300 300 Both Steel
16 Federal Tank 2,000 2,000 Boosted Steel
17 Five Mile Tank 2,400 2,121 Boosted Steel
18 Good Street Tank 3,000 3,000 Both Steel
19 Gowen Tank 2,000 2,000 Both Steel
20 Harris Ranch North 356 356 Elevated Steel
21 Harris Ranch Tank 360 360 Elevated Concrete
22 Harvard Tank 150 150 Boosted Steel
23 Hidden Hollow Tank 2,000 2,000 Both Steel
24 Hidden Sprinqs Tank 347 347 Elevated Steel
25 Highland View Tank 1 200 200 Both Concrete
26 Highland View Tank 2 300 300 Both Steel
27 Hillcrest Tank 2,000 2,000 Boosted
28 Hulls Gulch Tank 6,000 6,000 Both Steel
29 Marden WTP Clearwell 900 450 Boosted Concrete
30 North Mountain Tank 300 300 Elevated Steel
31 Old Pen Tank 320 320 Elevated Concrete
32 Quail Ridge Tank 326 325 Elevated Concrete
33 Steelhead Tank 3,000 2,900 Boosted Steel
34 Table Rock Tank 68 65 Elevated Concrete
35 Toluka Tank 92 90 Both Steel
36 Upper Danmor Tank 750 750 Both Concrete
37 Ustick Tank 2,000 1,900 Boosted Steel
38,709 35,915
Page 10 Detail B Storage
Steel
Steel
Steel
Name: SUEZ Water ldaho lnc
SYSTEM ENGINEERING DATA
(continued)
For Year Ended: December 31,2018
4 Pump information for ALL system pumps, including wells and boosters.
Rated
Designation or Location Horse Capacity
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?
Discharge
Pressure
Energy
Used
& 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?
What was the total amount pumped on the peak day?
15,653
2,549
87
6 lf customers are metered, what was the total amount sold in peak month?2,426
&of Power This Y
Yes
tso-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?
Using our GIS database and searching for parcels within the SUEZ service area that are not
current customers, and are located within 300 feet of an existing mainline, and are 1.25 acres or
less in size we found approximately 14,000 potential customers could be connected with a meter
and service line. Of the 14,000, we estimated approximately 1,000 are vacant lots.
10 Are backbone plant additions anticipated during the coming year?
lf Yes, attach an explanation of projects and anticipated costs
Redwood Creek Pipeline - Approximately $12M. Will transmit additional source of supply to the
Hidden Hollow Tank from Redwood Creek Well.
A second storage tank at Hidden Springs will be completed in 2019
11 ln what year do you anticipate that the system capacity (supply, storage or distribution)
will have to be expanded?
2020. Hillsboro Booster Station Replacement - will replace the existing Hillsboro Pump Station
with one that meets fire suppression capacity requirements. 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, a second clearwell
at the Columbia Water Treatment Plant. page 11
14 000
1,000
Yes
2020
SITE f LOCATION PUMPWPE
RATED
GPM KWTI USED PRODUC?ION
1 WELLPUMP 16th Street Well Pump DMA/erticalTurbine 100 800 72 1 15,920 73,298
2 WELLPUMP 27th Street Well Pump Submersible 60 350 65 139,871 58,082
J WELLPUMP Amitv Well Pumo VSP D\AA/erticalTurbine 150 700 87 377,360 207,423
4 WELLPUMP Arctic Well Pumo D\ANerticalTurbine 100 700 80 58,240 27,124
E WELLPUMP Bali Hai Well Pump VSP DWVerticalTurbine 350 2.400 80 396,480 185,018
o WELLPUMP Beacon Well Pumo DVlA/erticalTurbine 75 600 65 5,938
7 WELLPUMP Berqeson Well Pump Submersible 100 700 62 4,080
B WELLPUMP Bethel Well Pump VSP DV\A/erticalTurbine 200 2.500 60 1.104.720 919,831
I WELLPUMP BIF Well Pump Submersible 40 250 57 135.930 55.622
10 WELLPUMP Broadway Well Pump DVlA/erticalTurbine 150 1,000 AA 416,880 179.930
11 WELLPUMP Brook Hollow Well Pump DVlA/erticalTurbine 75 850 60 61,957 43.698
12 WELLPUMP Cassia 1 Well Pump D\ANerticalTurbine 100 900 60 289,1 60 186,339
13 WELLPUMP Cassia 2 Well Pump VSP DV\A/erticalTurbine 125 800 60
14 WELLPUMP Centennial Well Pump D\AA/erticalTurbine 100 750 57 467,200 291,991
15 WELLPUMP Central Park Well Pump RETIRED IN 2017 1,452
16 WELLPUMP Chamberlain 1 Well Pump DVlA/erticalTurbine 50 250 70 81,680 52,605
17 WELLPUMP Chamberlain 2 Well Pump DVlMerticalTurbine 30 380 70
18 WELLPUMP Cliffside Well Pump VSP DVlMerticalTurbine 50 500 60 199.144 195,295
19 WELLPUMP Clinton Well Pumo DWVerticalTurbine 125 1.300 59 320.040 246.652
20 WELLPUMP Cole Well Pump DVlA/erticalTurbine 100 700 70 103,080 46.386
21 WELLPUMP Country Club Well Pump DVlA/erticalTurbine 125 800 46 239,880 146.112
22 WELLPUMP Country Square Well Pump VSP DWVerticalTurbine 125 1,100 58 263,400 146,778
ZJ WELLPUMP Countryman Well Pump DV1 /erticalTurbine 50 500 65 2,623
24 WELLPUMP Durham Well Pump Submersible 15 200 62 106,825 52,394
25 WELLPUMP Edqeview Well VSP Submersible 75 800 60 49,920 29,963
26 WELLPUMP Fisk Well Pump VSP D\AA/erticalTurbine 200 1,900 59 807,780 463,401
27 WELLPUMP Five Mile 12 Well Pump D\AA/erticalTurbine 75 'I ,000 55 125,640 71 ,899
28 WELLPUMP Floatinq Feather Well VSP D\AA/erticalTurbine 450 3,000 63 1,252,640 681,123
29 WELLPUMP Foxtail Well Pump VSP D\AA/erticalTurbine 125 1,000 80 43,1 60 21 ,824
30 WELLPUMP Franklin Park Well Pump D\AA/erticalTurbine 125 1,200 60 472,480 367,121
31 WELLPUMP Frontier Well Pump VSP DVlMerticalTurbine 150 1,750 58 97.320 63,582
32 WELLPUMP Goddard Well Pump D\AA/erticalTurbine '150 1.300 54 446.080 192.532
33 WELLPUMP Hidden Vallev 1 Well VSP DVlA/erticalTurbine 150 950 6B 439.720 261.380
34 WELLPUMP Hidden Vallev 2 Well VSP DVlA/erticalTurbine 100 750 70 79,080 51.749
35 WELLPUMP Hillcrest Well Pump DVlA,/erticalTurbine 100 750 32 928,520 308,656
36 WELLPUMP Hilton Well VSP DVlA/erticalTurbine 200 1,400 58 671,880 388,499
37 WELLPUMP HP Well VSP DWVerticalTurbine 150 1,100 70 663,600 371 ,'168
3B WELLPUMP Hummel Well Pump D\AA/erticalTurbine 75 600 oo 4,268
39 WELLPUMP ldaho Well Pump D\AA/erticalTurbine 50 375 6B 8,080
40 WELLPUMP lsland Wood 1 Well Pump VSP Submersible 15 150 69 95,506 80,020
41 WELLPUMP lsland Wood 2 Well Pump VSP Submersible 75 800 66 103,908 59,618
42 WELLPUMP JR Flat Well Pump Submersible 100 450 71 268,560 107,315
43 WELLPUIVIP Kirkwood Well Pump D\AA/erticalTurbine 40 300 66 155,064 113,737
44 WELLPUMP La Granqe Well Pump D\AA/erticalTurbine 150 1,350 60 662,600 281 ,770
45 WELLPUIUP Licorlce Well Pump Submersible 15 190 62 72,337 50,539
46 WELLPUMP Loqqer Well Pump DVlA/erticalTurbine 150 700 67 321 .000 142,355
47 WELLPUMP Lonqmeadow Well Pump D\AA/erticalTurbine 50 250 50 33,400 13.494
48 WELLPUMP MAC Well Pump DVlA/erticalTurbine 150 1.200 79 1 26,1 60 64.900
49 WELLPUMP Maple Hill 1 Well Pump VSP DVlA/erticalTurbine 200 1.800 70 778.480 470,601
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31, 2018
Page 11 - 4. All System Pumps (including Wells & Boosters)
04t'tzt19
Page 11 Detail Pumps & Boosters (Page 1 of4)
TYPE HP DPSI
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31, 2018
Page 11 - 4. All System Pumps (including Wells & Boosters)
04112t19
SITE #TYPE LOCATION PUMP TYPE HP
RATED
GPM DPSI KWH USED PRODUCTION
50 WELLPUMP Maple Hill 2 Well Pump VSP DVlNerticalTurbine 60 500 70
51 WELLPUMP Market Well PumD D\AA/erticalTurbine 125 700 69 144,840 58,647
52 WELLPUMP McMillan Well Pumo DV\NerticalTurbine 100 800 80 182.440 103,553
53 WELLPUMP Overland Well Pumo DVlNerticalTurbine 100 1,000 69 203,656 107,685
54 WELLPUMP Paradise Well Pumo Submersible 40 500 65 93,568 50,591
55 WELLPUMP Pioneer Well Pump D\ANerticalTurbine 300 1.200 65 1,327,680 348,1 26
56 WELLPUMP Pleasant Valley Well Pump D\ANerticalTurbine 500 1.800 67 1.493.120 435,534
57 WELLPUMP Raptor Well Pump DVlA/erticalTurbine 300 1.000 87 516.800 158,831
5B WELLPUMP Redwood Creek Well Pump VSP Submersible 200 1,800 65 131 .800 60.1 79
59 WELLPUMP River Run Well VSP Submersible 100 900 65 39,640 18.847
60 WELLPUMP Roosevelt 1 Well Pump D\AtuerticalTurbine 50 700 55 325,040 271,743
61 WELLPUMP Roosevelt 3 Well Pump DVIA/erticalTurbine 75 600 55
62 WELLPUMP Settlers Well Pump DWVerticalTurbine 100 1,000 56 49,574 28,316
63 WELLPUMP Sherman Oaks Well Pump N/A (Out of Service)
o4 WELLPUMP Sourwino Well Pumo VSP DVlA/erticalTurbine 150 2,000 80 18,360
65 WELLPUMP Sunset West Well VSP D\AA,/erticalTurbine 250 2.000 oo I ,1 23,600 586,488
66 WELLPUMP Swift 1 Well Pump VSP DVlNerticalTurbine 125 1.100 66 303.760 198,301
67 WELLPUMP Swift 2 Well Pump VSP DVWerticalTurbine 100 900 66
6B WELLPUMP Taqqart 1 Well Pump DVlA/erticalTurbine 50 300 55 635.000 341 ,565
69 WELLPUMP Taqqart 2 Well VSP DMfuerticalTurbine 125 750 55
70 WELLPUMP Ten Mile Well Pump DWVerticalTurbine 300 1,000 64 16.400
71 WELLPUMP Tertelinq Well Pump Submersible 75 425 69 152.248 52.337
72 WELLPUMP Veterans Well Pump D\AA/erticalTurbine 75 740 60 253.920 180.635
73 WELLPUMP Victorv Well VSP DWVerticalTurbine 60 600 55 370,602 245.337
74 WELLPUMP Vista Well Pump DV\A/erticalTurbine 75 450 50 354,040 171,207
AR WELLPUMP Warm Sprinqs Mesa 2 Well Pump DVlA/erticalTurbine 1t 450 136 4,972
to WELLPUMP Warm Sprinqs Mesa 3 Well Pump D\AA,/erticalTurbine '10 600 136 3,255
77 WELLPUMP Westmoreland Well Pump DV\A/erticalTurbine 50 350 50 51,584 33,749
78 WELLPUMP Willow 1 Well Pump DVlMerticalTurbine 40 500 69 4,600
79 WELLPUMP Willow 2 Well Pump D\AA/erticalTurbine 50 370 69 1 19.016 82,1 89
80 WELLPUMP Willow 3 Well Pump D!ANerticalTurbine 40 300 69
COLUMBIAWTP COLUMBIA PUMP RIVER 3.285.301
83 Raw Water #1 lntake SS VTRB 500 2800 205
B4 Raw Water #2 lntake SS VTRB 2800 205
85 Raw Water #3 lntake SS WRB 2800 205
COLUMBIA TRTMNT PLANT 1 ,281 ,815 1,343,708
86 FINISHWATER Columbia WTP VSP I SSVTRB 75 1 050 35
87 FINISHWATER Columbia WTP VSP 2 SSVTRB 75 1 050 35
oo FINISHWATER Columbia WTP VSP 3 SS VTRB 200 2800 35
B9 FINISHWATER Columbia WTP VSP 4 SS VTRB 2800 35
MARDEN WTP MARDEN TRTMNT PLANT 3,525,672 3,003,225
90 Raw Water #1 Ranney SUBM 50 1750 30
91 Raw Water #2 Rannev SUBM 40 1 000 30
92 Raw Water #3 Ranney VSP SUBM 90 1 800 30
93 Raw Water #1 lntake SS VTRB 15 1 390 30
94 Raw Water #2 lntake VSP SS VTRB 30 2775 30
oq Raw Water #3 lntake SSVTRB 30 2775 30
96 Raw Water #4 lntake SSWRB 25 2775 30
97 Raw Water #5 lntake SS VTRB 50 41 66 30
Page 11 Detail Pumps & Boosters (Page 2 of 4)
500
500
200
SITE #WPE PUMP TYPE HP
RATED
GPM DPSI KWH USEO PRODUCTION
98 FINISHWATER Marden WTP 710 VSP SS VTRB 150 2777 63
99 FINISHWATER Marden WTP 720 Pumo SSWRB 150 2777 63
100 FINISHWATER Marden WTP 730 Pumo SSVTRB 250 41 66 63
'101 FINISHWATER Marden WTP 740 VSP SSVTRB 250 4166 63
102 FINISHWATER Marden WTP 750 Pump SSVTRB 300 4166 85
TOTAL PUMPS 1 2,695 122,0'13 6,478 30,011,346 15,652,61 5
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 3'1,2018
Page 11 - 4. All System Pumps (including Wells & Boosters)
04112t19
SITE #TYPE LOCATION PUMP TYPE HP GPM PRODUCTIONDPSIKWH USED
1 BOOSTER 36th Street Booster#1 VSP SSVerticleTurbine 75 1,000 95 136,694
2 BOOSTER 36th Street Booster #2 VSP SSVerticleTurbine 75 't ,000 95
J BOOSTER Aeronca Booster Pumo I End Suc Centrifuqal 15 200 52 '17,965
4 BOOSTER Aeronca Booster Pumo 2 End Suc Centrifuqal 50 800 52
BOOSTER Arctic Booster SSVerticleTurbine 40 2,500 80 105,277
b BOOSTER Arrowhead 1 Booster#1 VSP SSVerticleTurbine 40 450 50 106,913
7 BOOSTER Arrowhead'l Booster #2 VSP SSVerticleTurbine 40 450 50
BOOSTER Arrowhead 1 Booster #3 VSP SSVerticleTurbine 50 900 50
I BOOSTER Arrowhead 2 Booster #1 VSP SSVerticleTurbine 40 450 95 '144,360
'10 BOOSTER Arrowhead 2 Booster #2 VSP SSVerticleTurbine 40 450 95
11 BOOSTER Arrowhead 2 Booster #3 VSP SSVerticleTurbine 75 900 95
12 BOOSTER Barber Booster Pump 1 End Suc Centrifuqal 150 1,500 90 58,440
13 BOOSTER Barber Booster Pumo 2 End Suc Centrifuoal 150 1,500 90
14 BOOSTER Bluffs Booster #1 - RETIRED End Suc Centrifuqal 7.5 150 75
15 BOOSTER Bluffs Booster #2 - RETIRED End Suc Centrifuqal 25 500 75
16 BOOSTER Bluffs Booster #3 - RETIRED End Suc Centrifuqal 25 500 75
17 BOOSTER Boise Avenue Pumo VSP End Suc Centrifuqal 30 1,000 72 5,682
18 BOOSTER Boulder Booster #'l VSP End Suc Centrifuqal 15 250 60 47,300
'19 BOOSTER Boulder Booster #2 End Suc Centrifugal 15 250 60
20 BOOSTER Boulder Booster #3 VSP End Suc Centrifuqal 20 500 55
21 BOOSTER Boulder Booster #4 VSP SSVerticleTurbine 40 '1 .500 74
22 BOOSTER Braemere Booster #1 VSP SSVerticleTurbine 75 1.000 83 121 .240
23 BOOSTER Braemere Booster #2 VSP SSVerticleTurbine 75 1.000 B3
24 BOOSTER Braemere Booster #3 VSP SSVerticleTurbine 40 500 83
25 BOOSTER Braemere Booster #4 VSP SSVerticleTurbine 20 250 83
26 BOOSTER Briarhill Booster #1 VSP End Suc Centrifuqal 75 900 150 148,762
27 BOOSTER Briarhill Booster #2 VSP End Suc Centrifuqal 75 900 150
z6 BOOSTER Briarhill Booster #3 VSP End Suc Centrifuoal 75 900 150
29 BOOSTER Broken Horn Booster #1 VSP SSVerticleTurbine 125 1,000 165 131,360
30 BOOSTER Broken Horn Booster #2 VSP SSVerticleTurbine 125 1,000 165
31 BOOSTER Broken Horn Booster#3 VSP SSVerticleTurbine 125 1,000 165
32 BOOSTER Broken Horn Booster CONTROL BLDG NA NA NA NA
33 BOOSTER Brumback Booster#1 VSP End Suc Centrifugal 100 600 150 227,800
34 BOOSTER Brumback Booster #2 VSP End Suc Centrifuqal 100 600 150
35 BOOSTER Cartwrioht Booster #1 VSP End Suc Centrifuqal 60 325 120 146,180
36 BOOSTER Cartwrioht Booster #2 VSP End Suc Centrifuoal 60 325 120
37 BOOSTER Council Sorinos Booster #1 VSP SSVerticleTurbine 60 465 toJ 20.412
Page 11 Detail Pumps & Boosters (Page 3 of 4)
LOCATION
SITE *LOCATION PUMP TYPE HP
RATED
GPM PROOUCTION
38 BOOSTER Council Sprinqs Booster #2 VSP SSVerticleTurbine 60 465 165
39 BOOSTER Crestline Booster #1 End Suc Centrifuqal 40 420 90 60,979
40 BOOSTER Crestline Booster #2 End Suc Centrifuqal 40 420 90
41 BOOSTER Federal Booster #1 ln-line Centrifuqal 100 1,500 60 1 23,1 60
42 BOOSTER Federal Booster #2 VSP ln-line Cenlrifuqal 100 't,500 60
43 BOOSTER Five Mile Booster VSP 1 SSVerticleTurbine 40 500 78 81,080
44 BOOSTER Five Mile Booster VSP 2 SSVerticleTurbine 100 1,500 78
45 BOOSTER Five Mile Booster 3 SSVerticleTurbine 100 1,500 78
46 BOOSTER Good Street Booster #'l VSP SSVerticleTurbine 100 4,500 25 145,120
47 BOOSTER Good Street Booster #2 SSVerticleTurbine 125 2,500 75
40 BOOSTER Good Street Booster#3 SSVerticleTurbine 125 2,500 75
49 BOOSTER Good Street Booster#4 VSP SSVerticleTurbine 40 700 75
50 BOOSTER Gowen Booster VSP 'l End Suc Centrifuqal 40 1.000 66 18,042
51 BOOSTER Gowen Booster VSP 2 End Suc Centrifuqal 50 1.500 66
c)BOOSTER Gowen Booster VSP 3 End Suc Centrifuqal 25 340 bb
53 BOOSTER Harris Ranch Booster #1 End Suc Centrifugal 10 300 65 41 ,126
54 BOOSTER Harris Ranch Booster #2 End Suc Centrifuqal 30 700 65
55 BOOSTER Harris Ranch Booster #3 End Suc Centrifuqal 30 700 65
56 BOOSTER Harvard Booster Pump 1 End Suc Centrifuqal 20 350 85 15,917
57 BOOSTER Harvard Booster Pump 2 End Suc Centrifuqal 20 3s0 85
58 BOOSTER Hidden Hollow 1 Pump SSVerticleTurbine 200 1.000 220 644,960
59 BOOSTER Hidden Hollow 2 Pump SSVerticleTurbine 200 1.000 220
60 BOOSTER Hidden Hollow 3 Pump VSP SSVerticleTurbine 200 1,000 220
61 BOOSTER Hiqhland View #1 VSP End Suc Centrifuqal 40 600 67 108,480
62 BOOSTER Hiqhland View #2 VSP End Suc Centrifuqal 40 600 67
63 BOOSTER Hiqhland View #3 End Suc Centrifuqal 100 1.200 67
64 BOOSTER Hillcrest Booster VSP 1 SSVerticleTurbine 75 1.500 65 ln Hillcrest Well
65 BOOSTER Hillcrest Booster VSP 2 SSVerticleTurbine 125 3.000 52
66 BOOSTER Hillcrest Booster VSP 3 SSVerticleTurbine 125 3.000 52
67 BOOSTER Hillcrest Booster VSP 4 SSVerticleTurbine 125 3,000 52
68 BOOSTER Hillsboro Booster #1 SSVerticleTurbine 50 600 104 59,080
69 BOOSTER Hillsboro Booster #2 VSP SSVerticleTurbine 75 900 104
70 BOOSTER Hillsboro Booster #3 VSP End Suc Centrifuqal 20 300 104
71 BOOSTER Hilo Booster VSP End Suc Centrifuqal 50 800 105 3,316
72 BOOSTER Hulls Gulch #1 SSVerticleTurbine 125 900 178 309,600
73 BOOSTER Hulls Gulch #2 SSVerticleTurbine 125 900 178
74 BOOSTER Hulls Gulch #3 SSVerticleTurbine 125 900 178
75 BOOSTER Lower Danmor Booster#1 VSP End Suc Centrifuqal 75 900 135 242.280
76 BOOSTER Lower Danmor Booster #2 VSP End Suc Centrifuqal 75 900 '135
77 BOOSTER Lower Danmor Booster #3 VSP End Suc Centrifuqal 75 900 135
78 BOOSTER Micron Booster VSP 1 End Suc Centrifuqal 50 900 '105 5.960
79 BOOSTER Micron Booster 2 End Suc Centrifuqal 20 340 105
80 BOOSTER Micron Booster 3 End Suc Centrifuqal 75 1.700 105
81 BOOSTER North Mountain #1 End Suc Centrifuqal 15 250 BB 31 .527
82 BOOSTER North Mountain #2 End Suc Centrifuqal 25 600 88
B3 BOOSTER Old Pen Booster End Suc Centrifuqal 15 300 70 1,197
84 BOOSTER Quail Booster #1 VSP SSVerticleTurbine 100 800 15'1 134,719
AA BOOSTER Quail Booster #2 VSP SSVerticleTurbine 100 800 151
86 BOOSTER Roqer Heiqhts '1 VSP End Suc Centrifuqal 75 3,000 45 146,240
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31, 2018
Page 11 - 4. All System Pumps (including Wells & Boosters)
04t12119
Page 11 Detail Pumps & Boosters
TYPE oPSt KWH USED
(Page 4 of4)
PUC ANNUAL REPORT
SUEZ Water ldaho lnc
December 31, 2018
Page 11 - 4. All System Pumps (including Wells & Boosters)
04t12t19
SITE #TYPE LOCATION PUMP TYPE HP
RATED
GPM DPSI KT'VH USED PRODUCTION
87 BOOSTER Rooer Heiohts 2 Pump End Suc Centrifuoal 75 3.000 45
88 BOOSTER Rooer Heiqhts 3 Pumo End Suc Centrifuoal 75 3,000 45
89 BOOSTER Somerset Booster 1 End Suc Centrifuqal 25 200 166 ln Rooer Hts Bstr
90 BOOSTER Somerset Booster 2 End Suc Centrifuqal 100 1.000 166
91 BOOSTER Steelhead Booster #1 End Suc Centrifuqal 25 500 60 131 ,640
92 BOOSTER Steelhead Booster #2 VSP End Suc Centrifuqal 60 1.500 60
93 BOOSTER Steelhead Booster#3 End Suc Centrifuqal 100 2.500 60
94 BOOSTER Sunview Booster End Suc Centrifuqal 60 750 101 '19,700
95 BOOSTER Technoloov Booster VSP SSVerticleTurbine 40 800 83 926
96 BOOSTER Toluka Booster#1 VSP End Suc Centrifuoal 50 500 81 147,600
97 BOOSTER Toluka Boosler#2 VSP End Suc Centrifuqal 50 500 81
98 BOOSTER Toluka Booster #3 VSP End Suc Centrifuqal 50 500 B1
oo BOOSTER Upper Danmor Booster #1 ln-line Centrifuqal 50 300 104 179,320
100 BOOSTER Upper Danmor Booster #2 ln-line Centrifuqal 50 300 104
101 BOOSTER Upper Danmor Booster #3 VSP End Suc Centrifuoal 150 1,200 104
102 BOOSTER Ustick Booster #1 End Suc Centrifuoal 75 1,500 65 125,280
103 BOOSTER Ustick Booster #2 End Suc Centrifuqal 75 1,500 65
104 BOOSTER Ustick Booster #3 VSP End Suc Centrifuqal 30 500 65
105 BOOSTER Warm Springs Booster #1 VSP End Suc Centrifugal 100 600 155 1 96,1 60
106 BOOSTER Warm Springs Booster #2 VSP End Suc Centrifugal '100 600 155
TOTAL BOOSTERS 7,243 104,600 't0,221 4,391,794
TOTAL PUMPS & BOOSTERS 19,938 226,613 16,699 34,403,140 15,652,615
Asterisk facilities added this year
Annual Report on Deferred Power Cost will show 34,403,260 k\l/h, 120 kwh difference due to Hope well out of service but small usage prior to taking offline.
Page 11 Detail Pumps & Boosters (Page 5 of 4)
Name: SUEZ Water ldaho lnc
SYSTEM ENGINEERING DATA
(continued)
For Year Ended: December 31, 201 8
FEET OF MAINS
Pipe
ln Use lnstalled
Beginning DuringofYear Year
Abandoned
During
Year
GIS Adjustments
During
Year *
ln Use
End of
YearSize
JO 553
30"11 265
24"80 622
20"10 091
18"J 385
16"260 574
14"9 293
12"288
10"51 207
8"019
o 51 726
4"206,013
J 495
2"2.5"152,525
3t4"1.25"'1.5"068
TOTAL 6 764
3.97. GIS adjustments include and data corrections.
CUSTOMER STATISTICS
Number of Customers
This
Year
Last
Year
This
Year
Last
Year2 Metered:2A Residential28 Commercial2C lndustrial
84 015
114
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
Other Water
136
59
1
587 (34)
11,165 99
78,882 1,775 (36)
10,091 (0)
3,385 0
251,562 12,991 (2,s18)(1,461)
7,492 1,818 (16)
1,553,650 55,182 (1,853)(6e1)
52, 1 63 16 (1,38s)413
2,940,118 90,857 (4,491)(6,826)
1,523,922 886 (10,613)1,529
203,832 3,485 (1,217)(86)
5,493 2 0
154,380 713 (1,529)(1,039)
5,240 5 (260)83
6,801,964 167,730 (23,867)(8,064)
MILES
81,864 9,388,249
8,988 5,109,913
2,053
63 57,216
92,968 14,555,378TOTALS (Add lines 2 through 8)
Page 12
606
CERTIFICATE
State of ldaho
County of Ada
and
WE, the undersigned MarshallThomoson. Vice President
Jarmila ltI. 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.
(Vice President)
(Officer in Charge Accounts)
tral
Subscribed and Sworn to Before Me
tnis-6 h
day ot Fp) ,zo1s
(Notary Public)
Residing at:{Y)u.id.-o., aY
-a-
Ltc
N".
NOT4R v
OF 19
lvly Commission Expires:S,Lrbcta I
,t.'+
I
'. f.
ReportlO: RLREG060
Layout lD: RLREG060
Buslness Unlt: 00060
Perlod Endlng: Doc 31, 2018
SUEZ Water ldaho
Genoral Ledger System
Rolling Regulatory l/S
12
Months
Ending
Current Year
lncrease /
(Decrease)
401 00461
401 0546 1
40'106461
401 1 0461
40111461
401 3646 1
40137461
40140462
40120461
4012't461
40145463
40200471
40205472
40245471
40300474 .
40301474
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
Meter Sale-Const Mtr-Consump
Meter Sale-Const Mtr-Fac Chgs
461.2-Commercial
Private Fire protection facili
462.0-Fi re Protect Rev-Private
Meter Sale-public auth consump
Meter Sale-publlc 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.0-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 Strctrs
Supv Lbr-SOS Maint Wls&Spr
Supv Lbr-Pump Ops Sup & Eng
Supv Lbr-Pump Ops Lbr & Exp
Supv Lbr-Pump Maint Sup&Eng
Supv Lbr-Pump Maint Equip
Supv Lbr-Wr Tmt Ops Sup&Eng
Supv Lbr-Wr Tmt Ops Lbr&Exp
Supv Lbr-T&D Ops Sup&Eng
Supv Lbr-T&D Ops Line Exp
Supv Lbr-T&D Maint Sup &Eng
Supv Lbr-T&D Maint - Main
Drct Lbr-SOS Ops Sup & Eng
Drct Lbr-SOS Ops Lbr & Exp
Drct Lbr-SOS Ops Misc
Drct Lbr-SOS Maint Strctrs
Drct Lbr-SOS Maint Sply Mains
Drct Lbr-Pump Ops Sup & Eng
Drct Lbr-Pump Ops Pwr Prd Lbr
Drct Lbr-Pump Ops Lbr & Exp
Drct Lbr-Pump Maint Sup&Eng
Drct Lbr-Pump Maint Strctrs
Drct Lbr-Pump Maint Pwr Prd
Drct Lbr-Pump Maint Equip
Drct Lbr-Wr Tmt Ops Lbr&Exp
Drct Lbr-Wtr Tmt Ops Misc Exp
Drct Lbr-Wtr Tmt Maint Strct
Drct Lbr-Wtr Tmt Maint Equip
Drct Lbr-T&D Ops Sup&Eng
Page 1 of 6
48,406,345.94 48,899,313.31 (492,967.37)
0.00
0.00
21 ,857,647.48
11,263,758.77
33,121,406.25
11,7't9,377.95
2,441,629.23
122,740.46
91,238.49
14,374,986.13
1,131 ,011.77
1,131 ,011.77
136,371.24
35,323.52
3,535.94
16,61 0.00
1,992.09
14,745.00
(308,268.00)
(121,368.00)
(221,058.21)
48,406,345.94
4,108.32
4,108.32
21,639,786.60
11,296,787.69
32,936,574.29
11,765,052.75
2,527,797.19
0.00
0.00
14,292,849.94
1,128,171.63
't,128,171.63
't40,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.'13
48,899,313.31
(4,108.32)
(4,108.32)
217,860.88
(33,028.92)
184,831 .96
(45,674.80)
(86,167.96)
122,740.46
91,238.49
82,1 36.1 9
2,840.14
2,840.14
(3,707.02)
(1e.80)
(e.6s)
3,770.00
(7,630.83)
(10,435.00)
(582,279.00)
(158,356.00)
(758,667.34)
(492,967.37)
501 00000
50't00600
501 00601
501 00603
5010061 1
501 0061 4
501 00620
501 00624
501 00630
501 00633
501 00640
501 00642
501 00660
501 00662
501 00670
501 00673
501 05600
501 05601
501 05603
50"t05611
50'105616
50'105620
501 05622
501 05624
501 05630
501 05631
501 05632
501 05633
501 05642
501 05643
501 05651
501 05652
501 05660
0.00
33,733.98
66,621.66
2,877.43
846.1 5
(63,377.07)
12,230.43
94,697.69
7,033.54
418.23
16,893.58
44,023.93
22,827.20
46,979.25
4,024.09
10,422.92
(861.71)
0.00
243.00
31,954.90
0.00
0.00
8,005.04
473,1 67.88
248.80
16,669.04
0.00
191 ,495.52
385,292.50
1,968.00
34,413.66
49,317.95
(190.74)
7,576.78
35,133.70
54,493.19
7,126.53
0.00
1 00,452.1 I
12,01'l .25
124,357.34
7,625.06
0.00
17,144.06
40,896.93
21 ,292.4',1
75,441 .94
4,022.08
0.00
1,421 .09
237.76
0.00
24,862.37
261.10
(55.00)
0.00
441 ,471.49
0.00
't4,302.57
242.72
160,221 .15
399,021.51
0.00
37,979.15
50,379.20
1 ,349.18
7,576.78
1,399.72
(12,128.47)
4,249.10
(846.1 5)
163,829.25
(21 9.1 8)
29,659.65
591.52
(418.23)
250.48
(3,127.00)
(1,534.79)
28,462.69
(2.01)
('t0,422.92)
2,282.80
237.76
(243.00)
(7,092.53)
261.10
(55.00)
(8,005.04)
(31,696.39)
(248.80)
(2,366.47)
242.72
(31,274.37)
13,729.01
(1,968.00)
3,565.49
1,061.25
1,539.92
12
Months
Ending
Prtor Year
Layout lD: RLREG060
Business Unlt: 00060
Period Endlng: Dec 31,2018
on o/UiZl9 at 0il:40 PM
SUEZ Water ldaho
General Ledger System
Rolling Regulatory US
12
Months
Ending
Current Year
12
Months
Ending
Prior Year
lncrease /
(Decrease)
501 05661
501 05662
501 05663
501 05664
501 05665
501 05671
501 05672
501 05673
501 05675
501 05676
501 05677
501 05678
50't 10600
50't 10603
501 't5675
501 20000
501 20601
501 20614
50120624
501 20660
501 25633
501 25664
501 25665
501 25678
501 00901
s0 t 00902
501 00903
501 05901
501 05902
501 05903
501 20901
501 20903
501 25903
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 Cust instl
Drct Lbr-T&D Ops Misc Ex
Drct Lbr-T&D Maint Strctrs
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
S L T-SOS Ops Sup & Eng
S L T-SOS Ops Misc
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-T&D Ops Sup&Eng
D L T out-Pump Maint Equip
D L T out-T&D Ops Cust instl
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 Suprvsn
Drct Lbr-Cust Acct Mtr Rdng
Drct Lbr-Cust Acct Rcrds&Coll
S L T out-Cust Acct Suprvsn
S L T out-Cust Acct Rcrds&Coll
D 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 out-A&G Ops Salaries
D L T out-A&G Ops Salaries
501.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-\Mr Tmt Ops Sup&Eng
F B T-Wtr Tmt Ops Lbr&Exp
F B T-\Mr Tmt Ops Misc Exp
F B T-\Mr Tmt Maint Strct
F B T-\Mr Tmt Maint Equip
F B T-T&D Ops Sup&Eng
F B T-T&D Ops Storage Faclt Ex
0.00
393,519.01
158,61 7.93
1 80.1 9
64,177.51
36.83
612.48
251,139.86
140,879.09
33,607.70
11,727.38
0.00
6,182.34
48.93
0.00
0.00
0.00
82,284.00
2,521 .54
(1,857.25)
0.00
(1 80.1 9)
(63,996.91)
0.00
2,571,477.29
106,267.83
0.00
93,316.46
189.72
301,678.82
60'1 ,374.71
(548.27)
564.00
(e52.68)
1,101,890.s9
2,053,175.60
0.00
4,510.58
1,027,494.60
2,915.89
(1,183,1s1.28)
(982,179.46)
922,765.93
(3,154,316.61)
18,078.34
31,370.06
1,736.79
14,368.39
11,514.64
0.00
5,927.71
3,866.99
276,690.26
3,460.63
7,520.61
0.00
88,829.18
8,058.26
203,954.65
1,026.75
17,779.70
23,342.',tg
8,570.51
0.00
331.80
359,457.79
194,852.85
0.00
64,922.95
0.00
100.20
173,302.84
148,025.36
32,320.18
33,01 7.1 8
2,42',t.27
0.00
0.00
(1,147.20)
(7,576.78)
238.00
(78,169.00)
(3,386.00)
1,079.00
1,313.55
0.00
(62,075.67)
(1,313.s5)
2,496,982.51
76,341.13
61.03
139,469.62
0.00
256,408.61
538,186.19
444.00
(274.00)
0.00
1,010,636.58
1,702,945.08
(480.77)
3,109.71
1,030,990.85
9,351.09
(8s3,981.70)
(959,344.63)
932,589.53
(3,438,948.19)
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
91J22.15
9,170.40
231,499.83
0.00
21,280.02
26,637.61
11,873.98
205.21
331.80
(34,06'.t.22)
36,234.92
(1 80.1 9)
745.44
(36.83)
(s',t2.28)
(77,837.02)
7,146.27
(1,287.52)
21,289.80
2,421.27
(6,1 82.34)
(48.e3)
(1,147.20)
(7,576.78)
238.00
(160,453.00)
(5,907.54)
2,936.25
1 ,313.55
1 80.1 I
1,921 .24
(1,313.55)
(74,494.781
(29,926.70)
61.03
46,1 53. 1 6
(189.72)
(45,270.21)
(63,1 88.52)
992.27
(838.00)
952.68
(91,254.01)
(350,230.52)
(480.77)
(1,400.87)
3,496.25
6,435.20
329,1 69.58
22,834.83
9,823.70
(284,631.s8)
2,929.64
(128.46)
1,633.97
(45.54)
(734.32)
151 .97
720.04
(3,866.99)
20,360.77
554.35
(136.62)
182.76
2,292.97
1,112.14
27,545.18
(1,026.75)
3,500.32
3,295.42
3,303.47
205.21
501 00920
501 00930
501 00932
s01 05920
501 05932
50 1 20920
501 25920
90950000
90950600
90950601
90950603
9095061 1
9095061 4
9095061 6
90950620
90950622
90950624
90950630
90950631
90950632
90950633
90950640
90950642
90950643
90950651
90950652
90950660
90950661
Page 2 of 6
Layout lD: RLREG06O
Businass LJnit: 00060
Period Ending: Dec 31, 2018
Run on 04/12/19 at 04:40 PM
SUEZ Water ldaho
General Ledger System
Rolling Regulatory l/S
12
Months
Ending
Current Year
12
Months
Ending
Prior Year
lncrease /
(Decrease)
90950662
90950663
90950665
90950670
90950671
90950672
90950673
90950675
90950676
90950677
90950678
9095090 1
90950902
90950903
90950920
90950932
91 500926
91 550926
91 700926
91 800926
91 850000
91 850926
91 860926
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 Strctrs
F B T-T&D Maint Rsrvrs&Stn
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 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-A&G Ops-Emp Pnsns
604.0-Employee Pension&Benefit
Prchsd \Mr-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-Wr Tmt Ops Sup&Eng
618.0-Chemicals
Material-SOS Maint Strctrs
Material-Pump Ops Lbr & Exp
Material-Pump Maint Strctrs
Material-Pump Maint Pwr Prd
Material-Pump Maint Eq
Material-Wtr Tmt Ops Sup&Eng
Material-Wr Tmt Ops Lbr&Exp
Material-\Mr Tmt Maint Strct
Material-\Mr Tmt Maint Equip
Material-T&D Ops Line Ex
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 - Meters
Material-T&D Maint - Hydrants
620.1 -6 Mat &Supply-Oper&Maint
Material-Cust Acct Mtr Rdng
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 Ops Misc
Out Servs-SOS Maint Cllct Rsvr
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-Wr Tmt Lab Testing
Out Servs-Other
207,763.17
77,258.40
79.53
1,835.61
6.90
321.96
125,559.24
68,032.91
15,280.00
6,073.17
0.00
39,901.85
138,616.88
335,1 14.48
399,023.75
3,402.69
1,259,050.00
(232,811.99)
1,276,385.32
212,568.49
3,247.09
(2,353.09)
3,952.57
1,510,087.99
168,466.35
168,466.35
1,998,599.30
412,688.33
2,411,287.63
16,397.27
319,387.62
335,784.89
22,167.13
36,631.20
179.93
3,349.20
8,787.97
0.00
45,110.41
3,966.96
0.00
10,826.05
568.1 4
0.00
18,051 .62
77,604.32
70.99
12,579.70
239,893.62
438.61
438.61
4,643,872.27
4,643,872.27
1,097.68
1,300.00
37.76
3,250.00
0.00
4,629.02
1,930.99
49,681.07
22,624.29
100,908.40
0.00
234,160.95
100,849.08
989.39
2,121 .50
0.00
50.98
96,807.72
78,959.35
17,126.36
18,800.44
456.07
47,399.06
140,467.84
361,073.84
504,456.60
6,935.70
't,282,52s.32
(170,967.65)
1,535,934.47
't84,206.48
0.01
4,546.43
3,872.48
1,799,769.42
148,905.57
148,905.57
1,841,530.05
41'1,332.96
2,252,863.01
4,738.05
328,346.96
333,085.01
296.47
48,614.13
0.00
2,993.70
4,732.28
(566.40)
26,535.94
2,77',\.96
8,402.16
0.00
182.32
122.10
13,694.84
52,211.46
0.00
1 ,014.31
161 ,005.27
2,685.51
2,685.51
4,650,9't 1.52
4,650,91'1.s2
1,102.19
0.00
0.00
3,178.64
2,315.34
1,581.09
2,799.55
45,473.46
12,975.26
1 03,41 8.10
473.52
26,397.78
23,590.68
909.86
285.89
(6.e0)
(270.98)
(28,751.52)
10,926.44
1,846.36
12,727.27
456.07
7,497.21
1,850.96
25,959.36
105,432.85
3,533.01
23,475.32
61,844.34
259,549.1 5
(28,362.01)
(3,247.08)
6,899.52
(80.0e)
289,681.43
(19,560.78)
(19,560.78)
(157,069.25)
(1,355.37)
l'ts8,424.621
(11,659.22)
8,959.34
(2,699.88)
(21,870.66)
11,982.93
(1 79 93)
(355.50)
(4,055.69)
(s66.40)
(18,574.47)
(1,195.00)
8,402.16
(10,826.05)
(385.82)
122.10
(4,356.78)
(25,392.86)
(70.99)
(11,565.3e)
(78,888.3s)
2,246.90
2,246.90
7,039.25
7,039.2s
4.51
(1,300.00)
(37.76)
(71.36)
2,315.34
(3,047.93)
868.56
(4,207.61)
(9,64e.03)
2,509.70
473.52
50605602
5061 0623
5061 0665
50635614
50635641
5030061 1
50300624
50300631
50300632
50300633
50300640
50300642
50300651
50300652
50300662
50300665
50300672
50300673
50300675
50300676
50300677
50300902
90850923
50400601
50400603
50400612
5040061 3
50400622
50400624
50400626
50400632
50400633
50400635
s0400636
Page 3 of 6
LayoutlD: RLREG060
Bu3lnoss Unit 00060
Porlod Ending: Oec 31,2018
on 0&1219 at 0{:t0 PM
SUEZ Water ldaho
Genoral Ledger System
Rolling Regulatory l/S
12
Months
Ending
Current Year
12
Months
Ending
Prior Year
lncrease /
(Decrease)
50400641
50400642
50400643
50400651
50400652
50400662
50400663
50400665
50400672
50400673
50400675
50400902
50400903
50400905
50400920
50400921
50400923
50400932
50405903
5031 0604
5031 092 1
50645000
50645600
50645601
50645603
5064561 1
5064561 4
50645616
50645620
50645622
50645624
50645630
50645631
50645632
50645633
50645640
50645642
50645643
50645651
50645652
s0645660
50645661
50645662
50645663
50645665
50645670
50645671
50645672
50645673
50645675
50645676
50645677
50645678
50645901
50645902
50645903
50645920
50645932
50646000
91400924
91460925
Out Servs-\Mr Tmt
Out Servs-\Mr Tmt Ops Lbr&Exp
Out Servs-\Mr Tmt Ops Misc Exp
Out Servs-Wr Tmt Maint Strct
Out Servs-\Mr 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 OffSuppl&Exp
Out Servs-A&G Ops
Out Servs-A&G Maint Plnt
Print & Postage-Cust Acct Rcrd
636-Contract Other - Prof
Rent-SOS Ops
Rent-A&G Ops Off Suppl&Exp
64'l -42-Rentals -Property&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 CSISOS Maint Wls&Spr
Trnsprt CShSOS Maint Spl Main
Trnsprt Cst-Pump Ops Sup & Eng
Trnsprt Cst-Pump Ops Pwr Prd L
Trnsprt Cst-Pump Ops Lbr & Exp
Trnsprt Cst-Pump Maint Sup&Eng
Trnsprt Cst-Pump Maint Strctrs
Trnsprt Cst-Pump Maint Pwr Prd
Trnsprt Cst-Pump Maint Eq
Trnsprt Cst-Wtr Tmt Ops Sup&En
Trnsprt Cst-Wtr Tmt Ops Lbr&Ex
Trnsprt Cst-\Mr Tmt Ops Misc
Trnsprt Cst-Wtr Tmt Maint Strc
Trnsprt Cst-Wtr 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 Cst-T&D Maint Strctrs
Trnsprt Cst-T&D Maint Rsrv&Stn
Trnsprt Cst-T&D Maint - Main
Trnsprt Cst-T&D MaintServices
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 Cst-A&G Salaries
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
630.00
0.00
19,398.79
18,857.43
23,627.00
34,825.94
0.00
0.00
8,599.00
0.00
4,760.89
93,018.26
87,505.92
500.1 5
37,305.62
6,g',t3.27
47,530.85
0.00
280,s32.78
849,465.11
1 ,268.61
11,278.17
12,546.78
836,921.27
4,361.91
7,'166.0'1
377.93
3,362.97
2,544.17
0.00
1,385.23
797.52
64, I 80.1 0
847.41
1,632.50
0.00
20,401 .97
1,901.26
47,597.04
359.81
4,218.34
5,358.72
'1 ,754.94
0.00
48,'186.59
1 8,010.73
17.55
452.35
3.24
77.30
29,308.41
'15,85'1.76
3,648.09
1,375.30
0.00
8,883.96
32,734.09
78,034.83
90,930.1 8
760.30
(836,921.27)
496,522.51
757.72
122,149.55
0.00
331.86
18,913.46
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
116,388.41
352.40
0.00
5,265.86
32,624.36
70.00
27',t,076.82
800,655.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.81
16,401 .68
1,692.36
42,266.50
0.00
3,9't9.69
4,829.03
1,963.33
35.00
43,835.89
18,439.68
229.91
396.13
0.00
6.00
17,342.96
14,334.27
2,958.36
3,419.70
110.34
8,369.51
25,480.12
65,404.25
91 ,312.36
1,070.49
(725,807.15)
,r43,814.56
224.98
93,260.99
(630.00)
331.86
(485.33)
(7,860.39)
11,361.06
(12,102.32)
'1 ,249.47
985.00
(660.1 2)
6,067.21
764.80
(1,178.17)
28,882.49
(147.75)
(37,305.62)
(1,647.41)
(14,906.49)
70.00
(9,455.96)
(48,809.73)
(0.50)
939.01
938.s1
(102,525.24)
(71 1 .54)
(1,501.34)
223.08
(870.21)
(601.62)
18.74
(184.72)
(797.52)
(10,500 70)
(112.95)
(240.66)
31.81
(4,000.2e)
(208.s0)
(5,330.54)
(359.81)
(298.65)
(52e.6e)
208.39
35.00
(4,350.70)
428.95
212.36
(56.22)
(3.24)
(71.30)
(11,965.45)
(1 ,517.49)
(689.73)
2,044.40
110.34
(514.45)
(7,253.97)
(12,630.58)
382.18
31 0.1 I
111,114.12
(52,707.e5)
(532.74)
(28,888.56)
Page 4 of 6
Layout lO: RLREG060
Buslness Unlt: 00060
Perlod Endlng: Dec 31,2018
92000928
92050928
92050930
90400904
90405904
50620626
50620633
50620651
50620663
50620665
50620921
50625643
50650600
5065060 1
50650603
5065061 0
50650626
50650632
50650652
50650661
50650662
50650665
50650670
50650903
50650905
50650921
50650923
50650926
50650930
50651 660
50655631
50655632
50655651
50655662
50655672
50655673
50655675
50655905
50655930
92052930
92053672
92056930
92061623
92064930
92200624
92200626
92200903
92200930
92200932
92300930
92600920
92600923
92600930
92600932
SUEZ Water ldaho
General Ledger System
Rolling Regulatory l/S
12
Months
Ending
Current Year
lncrease /
(Decrease)
656-59- lnsurance
660.0-Advertising
Amrt Rate Case-A&G Ops-Reg Com
666.0-Reg Comm Exp - Amort
Amort Dfrd Exp-A&G Ops-Reg Com
Amort of Dfrrd Exp-Misc Gen-A&
667-Reg Comm.Exp (Amort)
Bad DbtWO'Custr Acct Uncollct
Bad Dbt-Provsn-Cust Acct Uncol
670.0-Bad Debt Expenses
Utilities-Pump Ops Misc Exp
Utilities-Pump Maint Eq
Utilities-Wtr Tmt Maint Strct
Utilities-T&D Ops Meter Exp
Utilities-T&D Ops Misc Exp
Utilities-A&G Ops Off Suppl
Sludge Dspsl-Wtr Tmt Ops Misc
Office Exp-SOS Ops Sup & Eng
Office Exp-SOS Ops Lbr & Exp
Office Exp-SOS Ops Misc
Office Exp-SOS Maint Sup & Eng
Office Exp-Pump Ops Misc Exp
Office Exp-Pump Maint Pwr Prd
Office Exp-Wtr 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-T&D Maint Sup & Eng
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 OpsPension&Bnft
Office Exp-A&G Ops Misc Gen
Advertising Exp-A&G
Misc Exp-Pump Maint Strctrs
Misc Exp-Pump Maint Pwr Prd
Misc Exp-Wtr Tmt Maint Strct
Misc Exp-T&D Ops Line Ex
Misc Exp-T&D Maint Rsrvrs&Stn
Misc Exp-T&D Maint - Main
Misc Exp-T&D Maint - Services
Misc Exp-Cust Acct Misc Exp
Misc Exp-A&G Ops Misc Gen
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
Uni&Sfty Eq-A&G Maint Plnt
Bank Charges-A&G Ops Misc Gen
Other G&A Exp-A&G Ops Salaries
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
122,907.27
0.00
35,792.04
35,792.04
0.00
11,666.64
11 ,666.64
254,940.75
71,000.00
325,940.75
1,969.96
1,454.85
(393,902.25)
76.96
9,307.69
23,077.3',1
23,203.67
1,224.78
250.00
3,442.90
1,812.60
40,925.87
0.00
0.00
24,501.26
5,315.38
3,424.28
556.50
't0,722.78
0.00
183,127.32
99,000.00
80.00
151 ,948.53
114,662.30
130,964.96
419.76
10,631 .91
30.00
989.00
25.00
2,150.95
(20.30)
114.'.tg
11,725.80
55,768.76
11,052.00
257,652.00
37,956.12
0.00
1 ,1 73.1 6
0.00
81,135.18
89.97
14,120.84
2,374.00
(0.65)
(6,222.02')
45,542.26
963,855.58
93,485.97
0.00
35,792.04
35,792.04
'1,238.00
1 1,666.64
12,904.64
270,319.52
0.00
270,319.52
1,837.35
1,344.24
4,760.59
0.00
7,830.33
25,218.87
10,668.00
0.00
0.00
485.00
0.00
40,331 .1 7
1,367.10
2,859.52
24,446.72
1,248.11
8,828.56
0.00
45,052.93
736.54
146,284.46
98,677.50
0.00
181,977.07
101 ,476.60'135,438.86
260.63
9,883.62
0.00
75.00
1 ,1 50.00
8,225.00
(7.88)
0.00
12,582.80
55,668.72
11,052.00
257,652.00
44,995.37
164.29
745.82
160.62
76,442.13
0.00
8,516.76
798.98
84.00
(6,804.39)
49,271.21
'1,371,786.20
(29,421.301
0.00
0.00
0.00
1,238.00
0.00
1,238.00
15,378.77
(71,000.00)
(5s,621.23)
(132.61)
(1 10.61)
398,662.84
(76.e6)
(1,477.36)
2,141 .56
(12,535.67)
(1,224.78)
(250.00)
(2,957.90)
(1,812.60)
(594.70)
1 ,367.10
2,859.52
(54.54)
(4,067.27)
5,404.28
(556.50)
34,330.1 5
736.54
(36,842.86)
(322 50)
(80 00)
30,028.54
(1 3,185.70)
4,473.90
(1 5e.1 3)
(748.29)
(30.00)
(914.00)
1,'125.00
6,074.05
12.42
(1 14.19)
857.00
(100.04)
0.00
0.00
7,039.25
164.29
(427.34)
160.62
(4,6e3.05)
(8e.e7)
(5,604.08)
(1,575.02\
84.65
(582.37)
3,728.95
407,930.62
16,724,661.85 16,831 ,677.63 't 07,015.78
Total Expenses
Page 5 of 6
16,724,661.85 16,831,677.63 107,015.78
12
Months
Ending
Prior Year
Layout lO: RLREG060
Buslness Unit: 00060
Period Endlng: Dec 31,20'18
Run on 0/UlZ19 .t 04:40 PM
701 00403
71255406
91 900928
70203408
70250408
80"t00409
801 50409
8020041 0
8025041 0
8040041 1
7't200422
711004'.t5
SUEZ Water ldaho
General LBdger System
Rolling Regulatory l/S
12
Months
Ending
Current Year
12
Months
Ending
Prior Year
lncrease /
(Decrease)
-
(385,951.s8)GROSS INCOME
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
408.11-Property Taxes
Payroll Taxes
408.12-Payroll Taxes
408.13-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 lncome taxes
410.11-Prov Def lnc Tax-State
lnvestment Tax Cr,amortization
41 2.0-lnvest Tax Cred-Utility
Gain - Disposition of Property
414-Gain(Loss)from Dis of Util
Total Non-Operating lncome
Mdse & jobbing - lncome
41s-Merchandise & Jobbing lnc
416-Merchandise & Jobbing Exp
AFUDC Gross Up
AFUDC Debt
AFUDC Equity
420.0-Allow for Funds Used
lnterest income
Misc non operating income
Misc Non Oper Rental lncome
421-Misc Non-Util lncome
Misc lncome/Deduction
Non Recoverable
Corp Shrd Svcs-Non Recoverable
426.0-Misc Non-Utility Expense
Total Non-Operating lncome & Deductions
lnterest Exp-SWl/Can cons co's
427.3-lnt Exp on LongTerm Debt
Other interest
427.5-Olhet. lnt Charges
Total lnterest Expenses
9,826,1 88.36
9,826,188.36
20,712.00
20,712.00
106,551 .60
106,551 .60
1,996,064.59
1,996,064.s9
508,276.32
508,276.32
0.00
3,395,282.72
3,395,282.72
'1,118,787.38
1,1't8,787.38
206,860.72
206,860.72
46,446.32
46,446.32
(48,240.00)
(48,240.00)
(16,905.00)
(16,905.00)
9,019,036.13
9,019,036.13
20,7',t2.00
20,712.00
113,345.95
1 13,345.95
2,023,135.67
2,023,135.67
502,586.92
s02,s86.92
0.00
5,346,350.24
5,346,350.24
1,111,712.31
'1,11',l,712.31
82,676.00
82,676.00
54,062.00
54,062.00
(48,240.00)
(48,240.00)
0.00
0.00
807,152.23
807,',ts2.23
0.00
0.00
(6,794.35)
(6,794.35)
(27,071.08)
(27,071.081
5,689.40
5,689.40
0.00
(1,951,067.52)
(1,951,067.52)
7,075.07
7,075.07
124,184.72
'124,184.72
(7,615.68)
(7,615.68)
0.00
0.00
(16,905.00)
(16,905.00)
17,160,025.01 18,225,377.22 (1 ,065,352.21)
71 05041 9
71051419
71052419
0.00
0.00
0.00
(139,895.88)
(155,436.85)
(310,904.34)
(506,237.07)
(15,545.63)
0.02
(52,197.97)
(67,743.58)
(1,437.48)
(818,476.96)
305,399.26
(514,515.18)
(84.38)
(84.38)
0.00
(60,9s8.83)
(56,593.70)
(94,958.28)
(212,510.81)
(5,585.02)
0.00
(56,404.01)
(61,989.03)
28,856.33
76,424.97
424,900.34
s30,181.64
84.38
84.38
0.00
(78,937.05)
(98,843 15)
(215,946.06)
(393,726.26)
(9,960.61)
0,02
4,206.04
(5,754.5s)
(30,293.81)
(894,901.93)
(1 19,501.08)
(1,044,696.82)
7090041 9
71250421
712514',t8
71252426
71253426
90890426
70800430
71 00043 t
(1,188,49s.83)255,597.42 (1,444,093.25)
3,958,874.86
3,958,874.86
6,236.92
6,236.92
4,386,057.82
4,386,057.82
2,988.32
(427,182.96)
(427,182.961
3,248.60
3,965,1 't 1.78
2,988.32 3,248.604,389,046.14 (423,934.36)
NET INCOME
Page 6 of 6
11,745,043.14 9,197,614.90 2,547,428.24
-
31 ,681 ,684.10 32,067,635.68
Report lD: BSCOR100
Layout lD: BSCOR100 SUEZ Water ldaho
General Ledger System
Corp BS C/M vs Same Month P/YrBuslness Unit 00060
Period Ending: Dec 31, 2018
PM
- Current Month -lncrease
(Decrease)
fhis
Year
Last
Year
or
1 01 00000
1 0600000
1 1400000
1 1 500000
1 0800000
1 081 0000
1 0900000
1 1 1 00000
1 0700000
1 0750000
1 8300000
439,595,052.55
10,481 ,031 .06
450,076,083.61
600,76't .1 8
(194,825.18)
405,936.00
(123,759,460.11)
553,1 06.1 5
1,714,962.86
(38,604,532.56)
(160,095,923.66)
13,287,345.13
0.00
1,450,393.35
14,737,738.48
0.00
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.5e)
832,247.52
7,900,681.38
0.00
(15,873,390.90)
(1,746,223.41)
(17,619,614.31)
0.00
20,712.00
20,712.00
7,542,476.01
(62,081.95)
(644,680.84)
2,764,813.47
9,600,526.69
(6,218,608.68)
(302.5e)
(618,145.83)
(6,837,057.10)
0.00
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 305,1 23,834.43 290,288,401.71 (14,935A3?.72).
Right of Use Assets
Less ROU Accum Amort
Net Right of Use Assets
Investments - LT Conso! Comp
lnvestments - LT Non-Consol Co
Equity lnvestments
12100000 Non-UtilityProperty
Non-Utility Property & Equip
Depreciation Non-Utility Prop
Other Properties & lnvestments
Goodwill, net
Other lntangibles, Net
Goodwill & Other lntangibles
13120000 Collections13150000 Operating Cash Acct - Citi13501000 Working Funds
Cash
Restricted Cash
14200000 Customer AR - CC&B
14201000 AR Cash Accrual
14309000 AccountsReceivable-Other
14310000 AR - M&J billed14400000 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
Run Date: 411212019
Run Time: 2:47 PM
0.00
0.00
0.00
'11,053.83
11,053.83
0.00
0.00
0.00
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
0.00
0.00
0.00
0.00 0.00 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
0.00
550.00
41,550.00
0.00
2,217,918.41
(807,523.8e)
8,895.61
0.00
(371,000.00)
(11,000.00)
2,985,863.00
4,023,153.13
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)
(1 1,000.00)
3,415,499.00
4,860,495.70
(0.00)
(0.00)
0.00
0.00
42.39
0.00
42.39
0.00
(30,042.93)
188,435.12
170,297.95
8,016.43
71,000.00
0.00
429,636.00
837,342.57
(0.01)
(0.01)
0.00
Page 1 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 31,2018
Run on 0/V09/19 al 04:28 PM
- Current Month -lncrease
This
Year
0.00
101,305.22
317,744.66
60,635.56
68,461.31
548,146.75
72,000.00
72,000.00
0.00
Last
Year
0.00
116,537.51
285,946.78
55,240.67
18,568.77
476,293.73
72,000.00
72,000.00
0.00
or
(Decrease)
1 5000000
1 501 0000
1 5020000
1 5030000
Notes Receivable - Short Term
Capital&Maint lnv Nonexempt
Small Repairs lnventory Exempt
Other lnventory
Chemical lnventory
Materials & Supplies lnventory
Prepaid Expenses-Other
Prepaid Expenses
Other Current Assets
Tota! Current & Accrued Assets
0.00
15,232.29
(31,797.88)
(5,394.89)
(49,892.54)
(71,853.02)
0.00
0.00
0.00
1 6599000
4,684,849.88 5,450,381.82 765,531.93
1 8609000
1 8620000
18621000
1 8623000
1 8625000
1 8650000
1 8653000
1 8680000
1 8699000
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 Accounts
Non Current Assets
Total Assets
0.00
2,151,154.38
1,369,144.23
23,451.65
1,319,978.67
0.89
(452,948.09)
(328,507.87)
(0.04)
164,221.06
4,246,494.88
578,175.70
578,175.70
0.00
(1.72)
(1.72)
0.00
2,023,956.75
1,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)
(92,879.37)
0.00
(127,197.63)
(253,853.94)
11,725.80
287,667.12
257,652.00
55,768.76
37,956.12
35,792.04
(140,5O2.34)
165,007.93
(182,918.84)
(182,918.84)
0.00
(92,877.65)
(92,877.65)
1 8714000
1 8404000
4,824,668.86 4,713,880.30 (110,788.56)
314,64/.,407.0',|.300,463,717.66 (14,180,689.35)
Run Date: 411212019
Run Time: 2:47 PM Page 2 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 31, 2018
on 04/09/19
This
Year
1,261,750.00
81,437,834.97
82,699,584.97
0.00
82,699,584.97
94,168,736.78
94,168,736.78
(1,198,228.54)
(1,198,228.54)
0.00
21,857,647.48
11,263,758.77
11,719,377 .95
2,441,629.23
136,371.24
35,323.52
98,739.54
122,740.46
91,238.49
1,131,011.77
3,535.94
16,610.00
1,992.09
14,745.O0
(210,333.48)
(308,268.00)
(121 ,368.00)
48,294,752.00
0.00
0.00
(33,733.e8)
(66,621.66)
(2,877.43)
(846.15)
63,377.O7
(12,230.43)
(e4,6e7.69)
(7,033.54)
(418.23)
(16,893.58)
(44,023.93)
(22,827.20)
(46,979.25)
(4,024.0e)
(10,422.92)
(106,267.83)
0.00
Last
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
0.00
0.00
0.00
1,128,171.63
3,545.63
12,840.00
9,622.92
25,180.00
0.00
274,011.00
36,988.00
48,899,313.31
(1e6.11)
(7,576.78)
(35,133.70)
(54,493.19)
(7,126.53)
0.00
(100,452.18)
(12,011.25)
(124,357.34)
(7,625.06)
0.00
(17,144.06)
(40,896.93)
(21,292.41)
(75,441.94)
(4,022.08)
0.00
(76,341.13)
(61.03)
lncrease
(Decrease)
- Current Month -
or
201 00000
20800000
21600000
80550000
401 00461
40105461
401 06461
40110461
40111461
40120461
40121461
40130474
40136461
40137461
40140462
40145463
40200471
40205472
40245471
40251474
40300474
40301474
5001 5000
501 00000
501 00600
501 00601
501 00603
501 0061 1
501 00614
501 00620
501 00624
50100630
50100633
501 00640
50100642
50100660
50100662
501 00670
501 00673
501 00901
501 00902
Capitalization and Liabi I ities
Common Stock lssued
Additional Paid-in Capital
Common Stock
Preferred Stock
Total Capital Stock
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
Surcharges
Meter Sal+-Const Mtr-Consump
Meter Sale-Const Mtr-Fac Chgs
Private Fire protection facili
Public Fire protection facilit
Miscellaneous service revenue
Rents from water property
Turn on fees
ContraRev 201 SportionTaxReform
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 Strctrs
Supv Lbr-SOS Maint Wls&Spr
Supv Lbr-Pump Ops Sup & Eng
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-T&D Ops Sup&Eng
Supv Lbr-T&D Ops Line Exp
Supv Lbr-T&D Maint Sup &Eng
Supv Lbr-T&D Maint - Main
Supv Lbr-Cust Acct Suprvsn
Supv Lbr-Cust Acct Mtr Rdng
0.00
0.00
0.00
0.00
0.00
(7,822,821.28)
(7,822,821.28)
(176,368.97)
(176,368.97)
4108.32
(217,860.88)
33,028.92
45,674.80
86,167.96
3,707.02
19.80
(98,739.54)
(122,740.46)
(91,238.49)
(2,84O.14)
9.69
(3,770.00)
7,630.83
10,435.00
210,333.48
582,279.00
158,356.00
604,561.31
(1e6.11)
(7,576.78)
(1,399.72)
12,128.47
(4,249.10)
846.15
(163,829.25)
219.18
(2e,65s.65)
(591.52)
418.23
(250.48)
3,127.00
1,534.79
(28,462.69)
2.01
10,422.92
29,926.70
(61.03)
Run Date: 411212019
Run Time: 2:47 PM Page 3 of 10
Report lD: BSCORI00
Layout lD: BSCOR100 SUEZ Water ldaho
General Ledger System
Corp BS G/M vs Same Month PIYrBusiness Unlt: 00060
Period Endlng: Oec 3'1, 2018
on 04/09/19 at
This
Year
(93,316.46)
(2,0s3,175.60)
0.00
(4,510.58)
861.71
0.00
(243.00)
(31,954.90)
0.00
0.00
(8,005.04)
(473,167.88)
(248.80)
(16,66e.04)
0.00
(191 ,495.52)
(385,292.50)
(1,e68.00)
(34,413.66)
(49,317.95)
190.74
0.00
(393,519.01)
(158,617.93)
(180.1e)
(64,177.51)
(36.83)
(612.48)
(251 ,1 39.86)
(140,879.09)
(33,607.70)
(11,727.38)
0.00
(18e.72)
(301,678.82)
(601,374.71)
(1,027,494.60)
(2,e15.89)
(6,182.34)
(48.e3)
0.00
0.00
0.00
(82,284.00)
(2,521.54)
1,857.25
548.27
(564.00)
1 ,1 83,1 51 .28
0.00
1 80.1 9
63,996.91
0.00
952.68
982,179.46
(22,167.13)
Last
Year
(139,469.62)
(1,702,945.08)
480.77
(3,10e.71)
(1,421.O9)
(237.76)
0.00
(24,862.37)
(261 .1 0)
55.00
0.00
(441,471.49)
0.00
(14,302.57)
(242.72)
(160,221.15)
(399,021 .51)
0.00
(37,979.15)
(50,379.20)
(1 ,34e.18)
(331.80)
(35e,457.79)
(194,852.85)
0.00
(64,922.95)
0.00
(100.20)
(173,302.84)
(148,025.36)
(32,320.18)
(33,01 7.1 8)
(2,421.27)
0.00
(256,408.61)
(538,1 86.1 e)
(1,030,990.85)
(9,351.09)
0.00
0.00
1,147.20
7,576.78
(238.00)
78,169.00
3,386.00
(1,079.00)
(444.00)
274.00
853,981.70
(1,313.55)
0.00
62,O75.67
1,313.55
0.00
959,344.63
(2e6.47)
lncrease
or
(Decrease)
(46,153.16)
350,230.52
480.77
1,400.87
(2,282.80)
(237.76)
243.00
7,092.53
(261.10)
55.00
8,005.04
31,696.39
248.80
2,366.47
(242.72)
31,274.37
(13,729.01)
1,968.00
(3,565.4e)
(1,061.25)
(1,539.92)
(331.80)
34,061.22
(36,234.92)
1 80.1 I
(745.44)
36.83
512.28
77,837.02
(7,146.27)
1,287.52
(21,289.80)
(2,421.27)
189.72
45,270.21
63,188.52
(3,4e6.25)
(6,435.20)
6,182.34
48.93
1,147.20
7,576.78
(238.00)
160,453.00
5,907.54
(2,e36.25)
(ee2.27)
838.00
(329,169.58)
(1 ,313.55)
(1 80.1 9)
(1,e21.24)
1 ,313.55
(952.68)
(22,834.83)
21,870.66
- Current Month -
50100903 Supv Lbr-Cust Acct Rcrds&Coll
50100920 Supv Lbr-A&G Ops Salaries
50100930 Supv Lbr-A&G Misc Gen Exp
50100932 Supv Lbr-A&G Maint Plnt
50105600 Drct Lbr-SOS Ops Sup & Eng
50105601 Drct Lbr-SOS Ops Lbr & Exp
50105603 Drct Lbr-SOS Ops Misc
50105611 Drct Lbr-SOS Maint Strctrs
50105616 Drct Lbr-SOS Maint Sply Mains
50105620 Drct Lbr-Pump Ops Sup & Eng
50105622 Drct Lbr-Pump Ops Pwr Prd Lbr
50105624 Drct Lbr-Pump Ops Lbr & Exp
50105630 Drct Lbr-Pump Maint Sup&Eng
50105631 Drct Lbr-Pump Maint Strctrs
50105632 Drct Lbr-Pump Maint Pwr Prd
50105633 Drct Lbr-Pump Maint Equip
50105642 Drct Lbr-Wr Tmt Ops Lbr&Exp
50105643 Drct Lbr-Wr Tmt Ops Misc Exp
50'105651 Drct Lbr-\Mr Tmt Maint Strct
50105652 Drct Lbr-Wtr Tmt Maint Equip
50105660 Drct Lbr-T&D Ops Sup&Eng50105661 Drct Lbr-T&D Ops Storage Faclt
50105662 Drct Lbr-T&D Ops Line Ex
50105663 Drct Lbr-T&D Ops Meter Exp
50105664 Drct Lbr-T&D Ops Cust instl
50105665 Drct Lbr-T&D Ops Misc Ex
50105671 Drct Lbr-T&D Maint Strctrs
50105672 Drct Lbr-T&D Maint Rsrvrs&Stn
50105673 Drct Lbr-T&D Maint - Main
50105675 Drct Lbr-T&D Maint - Services
50105676 Drct Lbr-T&D Maint - Meters
50105677 Drct Lbr-T&D Maint - Hydrants
50105678 Drct Lbr-T&D Maint -Misc Plnt
50105901 Drct Lbr-Cust Acct Suprvsn
50105902 Drct Lbr-Cust Acct Mtr Rdng
50105903 Drct Lbr-Cust Acct Rcrds&Coll
50105920 Drct Lbr-A&G Ops Salaries
50105932 Drct Lbr-A&G Maint Plnt
501 10600 S L T-SOS Ops Sup & Eng
50110603 S L T-SOS Ops Misc
50115675 D L T-T&D Maint- Services
50120000 SLTout-ES
50120601 S LTout-SOS Ops Lbr& Exp
50120614 S LTout-SOS MaintWls&Spr
50120624 S LTout-Pump Ops Lbr& Exp
50120660 S LTout-T&D Ops Sup&Eng
50120901 S LT out-CustAcct Suprvsn
50120903 S LT out-CustAcct Rcrds&Coll
50120920 S LToutA&G Ops Salaries
50125633 D LToutPump Maint Equip
50125664 D L T out-T&D Ops Cust instl
50125665 D L T out-T&D Ops Misc Ex
50125678 D L T out-T&D Maint -Misc Plnt
50'125903 D LT out-CustAcct Rcrds&Coll
50125920 D LTout-A&G Ops Salaries
50389H U",", 4/{i/Ahrdal-SoS Maint Strctrs
Run Time: 2i47 PM Page 4 of 10
Report lD: BSCOR100
LayoutlD: BSCOR100 SUEZ Water ldaho
General Ledger Systom
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
PerSod Ending: Dec 31, 2018
Run on 04/09/19 at 04:28 PM
50300624 Material-Pump Ops Lbr & Exp
50300631 Material-PumpMaintStrctrs
50300632 Material-Pump Maint Pwr Prd
50300633 Material-Pump Maint Eq
50300640 Material-Wr Tmt Ops Sup&Eng
50300642 Material-Wr Tmt Ops Lbr&Exp
50300651 Material-Wr Tmt Maint Strct
50300652 Material-Wr Tmt Maint Equip
50300662 Material-T&D Ops Line Ex
50300665 Material-T&D Ops Misc Ex
50300672 Material-T&DMaintRsrvrs&Stn
50300673 Material-T&D Maint - Main
50300675 Material-T&D Maint - Services
50300676 Material-T&D Maint - Meters
50300677 Material-T&D Maint - Hydrants
50300902 Material-Cust Acct Mtr Rdng
50310604 Rent-SOS Ops
50310921 Rent-A&G Ops Off Suppl&Exp
50400601 Out Servs-SOS Ops Lbr & Exp
50400603 Out Servs-SOS Ops Misc
50400612 Out Servs-SOS Maint Cllct Rsvr
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-Wr Tmt Lab Testing
50400636 Out Servs-Other
5040064'l Out Servs-Wr Tmt
50400642 Out Servs-Wtr Tmt Ops Lbr&Exp
50400643 Out Servs-Wr Tmt Ops Misc Exp
50400651 Out Servs-Wr Tmt Maint Strct
50400652 Out Servs-\Mr 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
50400920 Out Servs-A&G Ops OffSuppl&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
506't0623 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-Wr Tmt Maint Strct
50620663 Utilities-T&D Ops Meter Exp
506A0gSt ts. o,flll[}tg.-r&D ops Misc Exp
Run Timo: 2:47 PM
This
Year
(36,631.20)
(17e.93)
(3,349.20)
(8,787.97)
0.00
(45,110.41)
(3,e66.e6)
0.00
(10,826.05)
(568.14)
0.00
(18,051 .62)
(77,604.32)
(70.e9)
(12,579.70)
(438.61)
(1,268.61)
(11,278.17)
(1,097.68)
(1,300.00)
(37.76)
(3,250.00)
0.00
(4,629.02)
(1,930.99)
(49,681.07)
(22,624.2e)
(100,908.40)
0.00
(630.00)
0.00
(1s,3e8.7e)
(18,8s7.43)
(23,627.00)
(34,825,94)
0.00
0.00
(8,599.00)
0.00
(4,760.89)
(e3,018.26)
(87,505.92)
(500.1 5)
(37,305.62)
(6,913.27)
(47,530.85)
0.00
(280,532.78)
(168,466.35)
(1,998,599.30)
(412,688.33)
(1,96e.e6)
(1,454.85)
393,902.25
(76.e6)
(9,307.69)
Last
Year
(48,614.13)
0.00
(2,993.70)
(4,732.28)
566.40
(26,535.e4)
(2,771.96)
(8,402.16)
0.00
(182.32)
(122.10)
(13,694.84)
(52,211.46)
0.00
(1,014.31)
(2,685.51)
(1,268.11)
(12,217.18)
(1 ,1 02.1 9)
0.00
0.00
(3,178.64)
(2,315.34)
(1,581.09)
(2,799.55)
(45,473.46)
(12,975.26)
(1 03,41 8.1 0)
(473.52)
0.00
(331.86)
(18,913.46)
(10,997.04)
(34,988.06)
(22,723.62)
(1,249.47)
(e85.00)
(7,938.88)
(6,067.21)
(5,525.6e)
(91,840.0e)
(116,388.41)
(352.40)
0.00
(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)
0.00
(7,830.33)
- Current Month -lncrease
or
(Decrease)
(11,e82.e3)
179.93
355.50
4,055.69
566.40
18,574.47
1,195.00
(8,402.16)
10,826.05
385.82
(122.10)
4,356.78
25,392.86
70.99
1'1,565.39
(2,246.90)
0.50
(939.01)
(4.51)
1,300.00
37.76
71.36
(2,315.34)
3,047.93
(868.56)
4,207.61
9,649.03
(2,509.70)
(473.52)
630.00
(331.86)
485.33
7,860.39
(11,361.06)
12,102.32
(1,249.47)
(e85.00)
660.12
(6,067.21)
(764.80)
1,178.17
(28,882.49)
147.75
37,305.62
1,647.41
14,906.49
(70.00)
9,455.96
19,560.78
157,069.25
1,355.37
132.61
110.61
(398,662.84)
76.96
1,477.36
Page 5 of 10
Report lD: BSCOR100
LayoutlD: BSCOR100 SUEZ Water ldaho
General Lodgor Sy$tem
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 31, 2018
Run on 04/09/19 at 04:28 PM
I n,s
Year
(23,077.31)
(23,203.67)
(16,397.27)
(319,387.62)
(836,921.27)
(4,361.91)
(7,166.01)
(377.93)
(3,362.e7)
(2,544.17)
0.00
(1,385.23)
(7e7.52)
(64,180.10)
(847.41)
(1,632.50)
0.00
(20,401.97)
(1,e01.26)
(47,s97.04)
(359.81)
(4,218.34)
(5,358.72)
(1,754.94)
0.00
(48,186.59)
(18,010.73)
(17.55)
(452.35)
(3.24)
(77.30)
(29,308.41)
(15,851 .76)
(3,648.0e)
(1,375.30)
0.00
(8,883.e6)
(32,734.0e)
(78,034.83)
(90,930.18)
(760.30)
836,921.27
(1,224.78)
(250.00)
(3,442.90)
(1 ,812.60)
(40,925.87)
0.00
0.00
(24,501.26)
(5,315.38)
(3,424.28)
(556.50)
(10,722.78)
0.00
(183,127.32)
Last
Year
(25,218.87)
(10,668.00)
(4,738.05)
(328,346.e6)
(734,396.03)
(3,650.37)
(5,664.67)
(601.01)
(2,492.76)
(1,942.55)
('t8.74)
(1 ,200.51)
0.00
(53,67e.40)
(734.46)
(1,3e1.84)
(31 .81)
(16,401.68)
(1,6e2.36)
(42,266.50)
0.00
(3,919.6e)
(4,829.03)
(1,e63.33)
(35.00)
(43,835.8e)
(18,43e.68)
(22e.e1)
(3e6.13)
0.00
(6.00)
(17,342.96)
(14,334.27)
(2,e58.36)
(3,41e.70)
(1 10.34)
(8,36e.51)
(25,480.12)
(65,404.25)
(91 ,312.36)
(1,070.49)
725,807.15
0.00
0.00
(485.00)
0.00
(40,331.17)
(1 ,367.1 0)
(2,85e.52)
(24,446.72)
(1,248.11)
(8,828.56)
0.00
(45,052.93)
(736.54)
(146,284.46)
lncrease
or
(Decrease)
(2,141.56)
12,535.67
11,659.22
(8,95e.34)
102,525.24
711.54
1,501.34
(223.08)
870.21
601.62
(18.74)
184.72
797.52
10,500.70
112.95
240.66
(31 .81)
4,000.29
208.90
5,330.54
359.81
298.65
529.69
(208.3e)
(35.00)
4,350.70
(428.95)
(212.36)
56.22
3.24
71.30
11,965.45
1,517.49
689.73
(2,044.40)
(1 10.34)
514.45
7,253.97
12,630.58
(382.1 8)
(310.1e)
(111,114.12)
1,224.78
250.00
2,957.90
1 ,812.60
594.70
(1 ,367.1 0)
(2,859.52)
54.54
4,067.27
(5,404.28)
556.50
(34,330.15)
(736.54)
36,842.86
- Current Month -
50620921 Utilities-A&G Ops Off Suppl
50625643 Sludge Dspsl-Wr Tmt Ops Misc
50635614 Chmcals-SOSMaintV/lls&Spr
50635641 Chmcals-Wtr Tmt Ops Sup&Eng
50645000 Trnsprt CstES50645600 Trnsprt Cst-SOS Ops Sup & Eng
50645601 Trnsprt Cst-SOS Ops Lbr & Exp
50645603 Trnsprt Cst-SOS Ops Misc
50645611 Trnsprt Cst-SOS 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-Wtr Tmt Ops Sup&En
50645642 Trnsprt Cst-Wr Tmt Ops Lbr&Ex
50645643 Trnsprt Cst-Wtr Tmt Ops Misc
50645651 Trnsprt Cst-Wtr 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
50645671 Trnsprt Cst-T&D Maint Strctrs
50645672 Trnsprt Cst-T&D Maint Rsrv&Stn
50645673 Trnsprt Cst-T&D Maint - Main
50645675 TrnsprtCst-T&DMaint-Services
50645676 Trnsprt Cst-T&D Maint - Meters
50645677 TrnsprtCst-T&DMaint-Hydrants
50645678 Trnsprt Cst-T&D MaintMisc Plt
50645901 Trnsprt Cst-Cust Acct Suprvsn
50645902 Trnsprt Cst-Cust Acct Mtr Rdng
50645903 Trnsprt Cst-Cust Acct Rcrds&Co50645920 Trnsprt Cst-A&G Salaries
50645932 Trnsprt Cst-A&G Maint Plnt
50646000 TransportationCost-Trnsfrred
50650600 Office Exp-SOS Ops Sup & Eng
50650601 Office Exp-SOS Ops Lbr& Exp
50650603 Office Exp-SOS Ops Misc
50650610 Office Exp-SOS Maint Sup & Eng
50650626 Office Exp-Pump Ops Misc Exp
50650632 Office Exp-Pump Maint Pwr Prd
50650652 Office Exp-Wr 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
50650670 Office Exp-T&D Maint Sup & Eng
50650903 OfficeExp-CustAcctRcrds&Col
50650905 Office Exp-Cust Acct Misc Exp
506f,0,9il",", 4tQIrtFsExp-A&G ops Off Suppl
Run Time: 2:47 PM Page 6 of 10
Report lD: BSCOR100
Layout lD: BSCOR100 SUEZ Water ldaho
General Ledger System
Corp BS C/M vs Same Month P/YrBuslness Unit 00060
Perlod Endlng: Dec 31,2018
at 04:28 PM
50650923
50650926
50650930
50651660
50655631
50655632
50655651
50655662
50655672
50655673
50655675
50655905
50655930
701 00403
70203408
70250408
90400904
90405904
90850923
90890426
90950000
90950600
90950601
90950603
9095061 1
90950614
90950616
90950620
90950622
90950624
90950630
90950631
90950632
90950633
90950640
90950642
90950643
90950651
90950652
90950660
90950661
90950662
90950663
90950665
90950670
90950671
90950672
90950673
90950675
90950676
90950677
90950678
90950901
90950902
90950903
Office Exp-A&G Accntng & Audtn
Office Exp-A&G OpsPension&Bnft
Office Exp-A&G Ops Misc Gen
Advertising Exp-A&G
Misc Exp-Pump Maint Strctrs
Misc Exp-Pump Maint Pwr Prd
Misc Exp-Wr Tmt Maint Strct
Misc Exp-T&D Ops Line Ex
Misc Exp-T&D Maint Rsrvrs&Stn
Misc Exp-T&D Maint - Main
Misc Exp-T&D Maint - Services
Misc Exp-Cust Acct Misc Exp
Misc Exp-A&G Ops Misc Gen
Depreciation - Utility Plant
Real Estate Tax
Payroll Taxes
Bad Dbt-WO-Custr Acct Uncollct
Bad Dbt-Provsn-Cust Acct Uncol
Corporate Shared Services Fees
Corp Shrd Svcs-Non Recoverable
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-\Mr Tmt Ops Sup&Eng
F B T-Wr Tmt Ops Lbr&Exp
F B T-Wr Tmt Ops Misc Exp
F B T-WrTmt Maint Strct
F B T-\Mr 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 Strctrs
F B T-T&D Maint Rsrvrs&Stn
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
This
Year
(ee,000.00)
(80.00)
(151,948.53)
(114,662.30)
(130,964.96)
(419.76)
(10,631 .91)
(30.00)
(989.00)
(25.00)
(2,150.e5)
20.30
(114.1e)
(9,826,188.36)
(1,996,064.59)
(508,276.32)
(254,940.75)
(71,000.00)
(4,643,872.27)
(305,399.26)
3,154,316.61
(18,078.34)
(31,370.06)
(1,736.79)
(14,368.39)
(11,514.64)
0.00
(5,927.71)
(3,866.99)
(276,690.26)
(3,460.63)
(7,520.61)
0.00
(88,829.18)
(8,058.26)
(203,954.65)
(1,026.75)
(17,779.70)
(23,342.19)
(8,570.51)
0.00
(207,763.17)
(77,258.40)
(7e.53)
(1 ,835.61)
(6.e0)
(321.e6)
(125,559.24)
(68,032.e1)
(15,280.00)
(6,073.17)
0.00
(39,901.85)
(138,616.88)
(335,114.48)
(399,023.75)
Lasf
Year
(98,677.50)
0.00
(181,977.07)
(101,476.60)
(135,438.86)
(260.63)
(e,883.62)
0.00
(75.00)
(1 ,1 50.00)
(8,225.00)
7.88
0.00
(9,019,036.13)
(2,023,135.67)
(502,586.92)
(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.8s)
(10,780.32)
(151.97)
(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)
(e8e.3e)
(2,121.50)
0.00
(50.e8)
(96,807.72)
(78,95e.35)
(17J26.36)
(18,800.44)
(456.07)
(47,399.06)
(140,467.84)
(361,073.84)
(504,456.60)
- Current Month -lncrease
or
(Decrease)
322.50
80.00
(30,028.54)
13,185.70
(4,473.90)
1 59.1 3
748.29
30.00
914.00
(1,125.00)
(6,074.05)
(12.42)
114.19
807,152.23
(27,071.08)
5,689.40
(15,378.77)
71,000.00
(7,03s.25)
(1 19,501 .08)
284,631.59
(2,e2e.64)
128.46
(1,633.97)
45.54
734.32
(151 .97)
(720.04)
3,866.99
(20,360,77)
(554.35)
136.62
(182.76)
(2,292.97)
(1,112.14)
(27,545.18)
1,026.75
(3,500.32)
(3,295.42)
(3,303.47)
(205.21)
(26,397.78)
(23,590.68)
(e0e.86)
(285.8e)
6.90
270.98
28,751.52
(10,926.44)
(1,846.36)
(12,727.27)
(456.07)
(7,497.21)
(1,850.96)
(25,959.36)
(105,432.85)e0ef,993",", o,EEoTf &c salaries
Run Time: 2:47 PM Page 7 of 10
Report lD: BSCOR100
LayoutlD: BSCORl00 SUEZ Water ldaho
General Ledgor Systom
Corp BS C/M vs Same Month P/YrBusiness Unit: 00060
Period Ending: Dec 3't, 2018
on 04/09/19 at 04:2E PM
This
Year
(3,402.6e)
(757.72)
(122,149.55)
(1,259,050.00)
232,811.99
(1,276,385.32)
(212,568.49)
(3,247.0e)
2,353.09
(3,952.57)
(106,551.60)
(35,792.04)
0.00
(11,666.64)
(11,725.80)
(55,768.76)
(11,052.00)
(257,652.00)
(37,956.12)
0.00
(1 ,1 73.1 6)
0.00
(81 ,1 35. 1 8)
(8e.e7)
(14,120.84)
(2,374.00)
0.65
6,222.02
(45,542.26)
(29,467,141.98)
18,827,610.03
(3,958,874.86)
15,545.63
(6,236.92)
139,895.88
155,436.85
310,904.34
0.00
16,905.00
(0.02)
52,197.97
1,437.48
818,476.96
(20,712.00)
(2,475,023.69)
16,352,586.34
(3,395,282.72)
(1,118,787.38)
(206,860.72)
(46,446.32)
48,240.00
(4,719,137.14)
11,633,449.20
104,603,957.44
(8,259,974.79)
1,287,164.03
Page 8 of 10
Lasf
Year
(6,s35.70)
(224.e8)
(93,260.e9)
(1,282,525.32)
170,967.65
(1,535,934.47)
(184,206.48)
(0.01)
(4,546.43)
(3,872.48)
(113,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.2s)
(74s.82)
(160.62)
(76,442.13)
0.00
(8,516.76)
(7e8.e8)
(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
0.00
56,404.01
(28,856.33)
(76,424.97)
(20,712.00)
(4,24O,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
lncrease
or
(Decrease)
(3,533.01)
532.74
28,888.56
(23,475.32)
(61,844.34)
(259,549.15)
28,362.01
3,247.08
(6,899.52)
80.09
(6,794.35)
0.00
(1,238.00)
0.00
(857.00)
100.04
0.00
0.00
(7,039.25)
(164.2e)
427.34
(160.62)
4,693.05
89.97
5,604.08
1,575.02
(84.65)
582.37
(3,728.95)
552,263.23
1,156,824.53
(427,182.96)
(e,e60.61)
3,248.60
(78,937.05)
(98,843.15)
(215,946.06)
84.38
(16,905.00)
0.02
4,206.04
(30,293.81)
(894,901.93)
0.00
(1,765,431.53)
(608,607.00)
(1,9s1,067.52)
7,075.07
124,184.72
(7,615.68)
0.00
(1,827,423.41)
(2,436,030.41)
(10,435,220.66)
(837,386.00)
(419,438.00)
- Current Month -
90950932
91400924
91460925
91 500926
91 550926
91 700926
91 800926
91 850000
91 850926
91 860926
91 900928
92000928
92050928
92050930
92052930
92053672
92056930
92061623
92064930
92200624
92200626
92200903
92200930
92200932
92300930
92600920
92600923
92600930
92600932
70800430
7090041 9
71 000431
71 05041 9
71051419
71052419
71100415
71200422
71250421
71251418
71252426
71253426
71255406
801 00409
801 50409
8020041 0
8025041 0
8040041 1
21 800000
F B T-A&G Maint Plnt
Liability lnsurance-A&G Ops
Worker comp-A&G Ops-l nj&Dmages
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 Benefi ts-ES
Othr Emply Bnft-A&G Ops-Pensn
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
Uni&Sfty Eq-A&G Maint Plnt
Bank Charges-A&G Ops Misc Gen
Other G&A Exp-A&G Ops Salaries
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-SWl/Can cons co's
lnterest income
Other interest
AFUDC Gross Up
AFUDC Debt
AFUDC Equity
Mdse&jobbing-lncome
Gain - Disposition of Property
Misc non operating income
Misc Non Oper Rental lncome
Misc lncome/Deduction
Non Recoverable
Amort of Util Plt Acquis Adj
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
21 88[fl g]te. 4/A9$le- PBoP
Run Time: 2i47 PM
Report lD: BSCOR100
Layout lD: BSCOR1oo SUEZ Water ldaho
Genoral Ledger System
Corp BS G/M vs Same Month P/YrBusiness Unit: 00060
Perlod Ending: Dec 31,2018
Run on 04/09/19 at 04:28 PM
This
Year
(6,972,810.76)
0.00
0.00
Lasf
Year
(8,229,634.76)
0.00
0.00
lncrease
or
(Decrease)
(1,256,824.00)
0.00
0.00
- Current Month -
Accum Other Comprehensive lnc
Oth Equity Noncontrol 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 - Vacation
Accrued - Bonus
Accrued - Employee Related
Accr - Employee Related Other
Accrued Other
Employee Whg-401K
Employee withholding - PAC
Employee Withholding- 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
Def .FI-F71|F109 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
28300000 Def. FIT-OtherRun Date: 4l'1212019
Run Time: 2:47 PM
180,330,731.65 168,638,686.99 (11,592,044.66)
23200000
2321 0000
23211000
23220000
23601 000
2361 0000
23641 000
23651000
23661 000
23662000
23663000
23670000
23699000
24205000
24215000
24245000
24246000
24247000
24248000
24299000
24301 000
24306000
24330000
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
25500000
28203000
28206000
28211000
1,616,855.85
362,916.57
142,965.34
(618.16)
2,122,119.60
0.00
0.00
0.00
0.00
0.00
996,875.41
72,443.02
3,612,292.75
3,517,328.05
20,669.13
26.30
122.14
41 ,918.51
27,292.52
8,288,967.83
0.00
0.00
271,411.46
145,556.79
31,369.00
380,333.24
0.00
21,233.87
973.03
44.68
50.00
1 15.00
851,087.07
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,O40.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
55,260.00
330,396.00
2,262.81
17,803.32
4,503.28
(20,192.23)
0.00
1 15.00
769,494.64
1,842,200.13
(193,967.76)
(86,716.10)
2,577.88
1,564,094.15
0.00
0.00
0.00
0.00
0.00
13,625.14
1,682.94
430,564.13
(1,114,287.38)
14,834.76
62.50
207.40
34,115.72
447.85
(618,746.94)
0.00
0.00
(21,754.10)
(15,867.69)
23,891.00
(49,937.24)
2,262.81
(3,430.55)
3,530.25
(20,236.91)
(50.00)
0.00
(81,592.43)
11 174.50 12,125,929.28 863,754.78
24,364.18
(51,404.37)
1.00
(2.00)
(1 10,804.80)
(50,313.72)
(47,558.49)
(33,023.53)
(268,741.73)
615,634.00
9,152,781.84
(1,861,085.40)
(392,683.59)
374,947.19
36,638.18
(42,139.37)
1.00
(2.00)
(214,338.00)
(142,509.00)
(50,334.00)
(33,48e.00)
(446,172.19)
663,874.00
10,041,452.33
(2,195,178.40)
(382,157.00)
323,379.00
12,274.00
9,265.00
0.00
0.00
(103,533.20)
(92,195.28)
(2,775.s1)
(465.47)
(177,430.46)
48,240.00
888,670.49
(334,093.00)
10,526.59
(51 ,568,19)
Page 9 of 10
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, 2018
This
Year
271,359.00
4,572.00
196,855.35
9,137.00
(23,642.14)
973,961.00
(709,671.85)
1,075,693.75
(122,031.00)
(310,942.00)
527,918.43
363,228.57
439,664.41
130,560.18
66,923.00
224,788.00
(332,111.72)
126,389.19
1,328,820.08
245,169.71
1,708.00
(635,121.84)
(13,523.04)
74,904.53
109,100.24
(3,475,403.48)
(1,332,677.04)
(0.07)
6,836,480.57
5,263,252.76
(397,588.46)
(482,573.32)
4,383,090.98
1 18,897,073.96
2,905,706.53
731,665.72
4,851,652.85
3,200,438.08
1,826,791.61
(38,604,532.56)
93,808,796.19
3,194,514.18
7,548,484.97
10,742,999.15
2,129,402.O0
4,380,517.52
210,333.48
241,698.54
6,961,951.54
297,492.43
20,690.00
318,182.43
0.00
Lasf
Year
232,709.00
11,568.00
(97,443.00)
11,429.00
(458,444.00)
649,113.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)
0.00
5,903,827.55
5,339,000.95
(2ee,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
0.00
440,668.00
7,274,190.04
210,871.97
23,973.00
234,844.97
0.00
lncrease
or
(Decrease)
(38,650.00)
6,996.00
(294,298.35)
2,292.00
(434,801.86)
(324,848.00)
(44,728.00)
(158,813.75)
13,877.00
0.00
(59,804.43)
63,646.00
202,369.72
(75,946.18)
(13,693.00)
(1 15,093.00)
(15,847.00)
(21,193.19)
272,715.19
(52,370.71)
812.OO
(175,780.00)
(99,275.96)
22,549.00
41,631.52
(55,611.52)
36,868.00
0.07
(932,653.02)
75,748.19
98,486.37' 0.00
174,234.56
(4,252,974.82)
110,726.05
900,671.87
(1,070,480.76)
(3,210,651 .26)
(1,726,484.59)
2,764,813.47
(6,484,380.04)
797,195.99
2,864,302.00
3,661,497.99
(122,704.00)
446,306.52
(210,333.48)
198,969.46
312,238.50
(86,620.46)
3,283.00
(83,337.46)
0.00
- Current Month -
28301 000
28302000
28303000
28304000
28305000
28306000
28307000
28308000
2831 0000
2831 1000
28312000
2831 3000
28314000
28350000
28353000
28354000
28355000
28356000
28357000
28358000
28359000
28360000
28363000
28364000
28365000
28405000
28406000
28408000
25200000
25200001
25201000
Def. FIT-Tank Painting
Def. FIT-Rate Expenses
Def. F|T-Deferred Charges
Def. FlT-Relocation Expense
Def. FIT-M_S Fees
Def. FIT-Pensions
Def. FIT-PEBOP
Def. FIT-Cost of Removal
Def. FIT-Uncollectibles
Def. FIT-Injuries 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
Def FIT-Tax Reform for GU20'18
Deferred lncome Taxes & Credit
Advances for Conslruction
CWP non-taxable 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
In Service taxable CIAC
Accumulated Amortization CIAC
Contribution in aid of Constru
PBOP Liability - Trustee
Pension Accrued
Pension and Benefits
Pension Regulatory Account
Regulatory Liab-Tax NewFedRate
Reg Liab-NewFedRate2Ol Sportion
DefRegLiab F71 /F1 09-Fed: ITC
Regulatory Liabilities
Other Deferred Credits
Accrued SE LTIP
Other Long Term Liabilities
Lease Liabilities Non Current
Deferred lncome Taxes & Credit
271 00000
27100001
27100002
27101000
27101001
27101002
27110000
25340000
2631 0000
2531 1 000
25316000
2531 7000
25402000
25380000
25390000
Total Capital & Liabilities
Run Date: 411212019
Run Time: 2i47 PM
't 23,051,500.86
314,644,407.01
1 19,699,101 .39
300,463,717.66
(3,352,399.47)
Page 10 of 10
(14,180,689.35)
x
.9,x@oN
b(5
E
E:,a
(,o
o3o(L
ol(L
=EoootolL
@oNo
oo.o)E.
6
ofI
.9o,9
E
Eoooq,
=El
.93
o-o-c(uE)=ooI
U)
.e,NEcibo,r€:€ FESzfiE9=-iJ.o.Eo
iiE$E?EE;E€
:5 a.$;E?;E gEE6;ioi53g=.Es
EE-EEtg€$Et;
FEE{1E E EfrEE
E rf EBEE; iiEE
=!PoXoEoxPar
}*tE=E;:gEE
=EgaEiebgSs
gfaEaaItlE*
EEE;E:{'E$H
sti*flFsiEp$
*ttttg!e.a:;Ess.sgflEeE;E
=E.;EFtX;83=
EEEEtEEtE=geElE=rEtti.z"EE.gsP:EiHieE;eEi+xpHS.Q;,
gEEEEEt{i{EE
Eg'$HEHiE=HPE
!;Efi*C#x;68:;€:3":Eig"?€:
EHEHiI=E3EEg
fr!E€8E}EE EEE
tEEi$fiEiEEflbdb39E=8.Zx:=-
EHtEEEEIEiEE
EE ;gag$iaEf,fi',^.fri E 5.:EE: dg;
!EEE a*EEE€XE
@O)O@@Nsft(OOO)(9Ooqoqc?\o?qaqq\qq\J @ N (f) @ t_ O) tr, O) t- \i lO N l.)
=lr)(oO)O@O)OC!$|'-Nt'-=N@tr)N@NFl-si(olr)N:lolo(o@60)(ot-oN(.)o)@Jo)ON(o\i(o@O(r)ro(oF-o (f) $ t \t \t rl !t t ro rr, () |r) lr)
@@@@@@q@@@@@q
o, !P (,) o (o @ N t t (o o g) c, eo e o ct t\ c, (o + (o N t\ c, (o t-r- 9E E D I r E I S R s S P N p
c if lE sl (o rr) N @ N N N t G, ro N -F go A d d od od oi d ii od ..i rt ot odi f e I o i N cr { (o .o o c, |o (o N= trC e tl !i t t !t t t lO lO lO lO lOo =3o iioI (.i)o
Uo
Eooo6ooo6o66q
ago
E"
.Ec
.s
EDoo
lr)c\tNo(.)F-F-@!iF-@(oc!o?q\ac!\c!qaqro)F.-I.-(C)rf)t@(t)(.r(')t(\l(.)\ttr)(OF.@c|N!+@t-cO(?)(frc.r(.)(')(f)$\i\t$sf
@@@q@@@@@@@@
oulFoz
a9.ONtNOa{tO)t1\qaa9qq.lqar\qlOatONtOttNNr,O(Y,NFOONFC{tOIOt- o)- @^ it- @- t- O- ,\_ (D- a \ Ol
CTOFOONFOCTUtO
-TFNNNN-
.>E
tr€aq$
EP
EoF
o
c,o9eoh
=g
aoc
E
=oo
lo
l-lcINlolr\Ir
t:ld)ldl-IN
L@
l:
c{g)@ag)NNNourooOtN?O)(OG,NFNtON@e)to){oNc)N(o(oNcrroNod'd ot d { od d ot Ff d od d ric)?Ft@Ott@.r6OrO (O l\ lO tO .O @ (O rt N !l 6 rtJJJjic{rt+'rt+c.i+ct
o4o-o
'lo,.gEtl -E
= (.to
I
=J
oFc'€o= -REFHEiiE i e = P F g ! I E E9iE:ilgsEgE EE $ E oE g 5 g i E I I E
tro
=E')c
c
=o(.,o
@o)rt(\t|r)(')toN@\aao?qu?ac?q\qolF-@O(OTO(')F-lr)@@@(o(\1\t(A(f)OO)stF-o- ro- N- - of o" (o- (')- ro_ (o- ry s-OOOOI-OO(f,Olr)@ (\l$,tNN
eG6-
$ 5x:o!(,
oo,o
EEbo
oo
u)c
E
Eo
ttr
E
Eo
c,c
Ef6o
g)
oN
€No)c
iooI
=ooE.9
=o=
E=Ed.E
ELo
o-
3oE"N
PiaeI
'.E
$E
otlroEo:!oooEE{9 cI+ oN!tPgFt
.atr -
fiE E
=c=U'<U'
@@@@o@a@@@q@
\Nof
UI
Eoc
GJC*
G)=E=-6Es; Ex?EUgFo xO =^r.F o- o::N 5co "iPEi5Eo3U*aroo-clr 5N
d
EaP'= ()
=d)--!CU'= o)=-o9l >-
=(Eoto-qo
.oG
6=
9"Eo.=
b.9>6EXtr
E*€eE*diuJ t = o :EJjY o o =e*ee€€tij a--.-Xl F 5
f e _O.1.=.= ()
b Ex==E
=t t.=='aE 6
3€EHas;
=E
H EE=E;'E bog I o
_^ s E O! I f-c2 0) ! o o)c i,EEE=EE*F (U oJ= (U o
B
:IE" E E
=? E E
=>o;J(!(oR3 d E _
= : P :
E ;a a g E=R= 5eI S € E;;;ts Er E
nuFa r=-ttiE5qg -P,e a -- g EB E = IEi = E
=
E g g= [ x E
sfi g ; ; E € gt x e H
;.E ggE F * F'E g € so-F
q).o-(DoI
o
o-p
(Eoo-o
(t)
=Ea;EEeoo;3Etg*io
A-Aga
6CoEti o)OEDE.c
-(1)
U;0)c)
.9(s
<cr c.l -lcn 'tda\u?19;--:C{ sf O)l(O (l) Oc!NlLr)xo@ @ @l@ <a'=
il il lllI o 6-Oa
EbcA'- q)tso-E}ob9c@-^c.Jov-- l'- (r, >'$3E E Eeh; !-E- H;o € ad) F \Y/r, - 9lE 6^tLO 6 qEEHOa9i;3;EFEA
@q,PPir,(o-+@ier- Er+Q O(JE6O<o
=(3PF
TL I.Lo. -o-E HH :EeIg,= EX ^8=-3daEE-s -.E* Eae33
AHs€ EBH #esi=
il;t*
6aa
=g*EE
F6I E: *8: eE g
gggfiB,gEIEgEgt
F-e@O)oo)o)c!
<cj d c.i oiF-(OOtf)c{.f(o@qq?q
e{ c.)
N
I
$
_o)
(U
Ea
EC(E{
Cf)
(l,Nt,
oq,
=
NUIfU'
PE(I,O
QaO
*u$eE xo*,. id.;3i5s#n
.>)
o"S
0,6 O,o,:,'D,:
N!'@raUcCO-fo=oN
@CE:::9=cOK=U==(A-Lo-"ooE-. oo
EPtsE.= r
'= db
E reE6t*
f,9
co
ts€uo.laoFo-o
E
o)IPoo^-oo!sEz&6
OOqqOOc! co@@
OqoC\|@
A-$ a=-o Qda
Ei#:eE
BE;3= g
eq?*E?5ts
=;3 e€e g
o g o 6o olz-E P: E;'€aE=*pbB
$EEE EE E I
6 E ig E E E *
3 q E fl*s H eg.e:== E e E
+ S € s€ E U *gH; E g5 E E
E3.
H=E A(o-aD;<(.)-!4(lD;A:==c!O o-e5; >9!6k>.3E9,3oo;c,6 L'--(U 06) -.33E5
O'== gc.>* ph x
.9= =o j
=-oc c ox - o=:-0) (U'= -cD= o " =.= i -or P'E
=EE*-a0)=! c o)
- --'= O*ooi9f;EEEd<6pE_e> o-o_()=
=o(5
(go
C
-9(E
=o
oo
o)
o)E
-o)o-
=E
o
(l,ct(!
o
oE--on-3gaqqoqN(,)(\t4)@ro*
=(\c{$F-!-o q?qqq
I
!E
=*€ o.!Po b o o'^-a
*E Hg-- ; H.
F;;;$Etep EEE F sE
=
HEE{;EEf;g
?EEE;EEEg
I+IEfiEE;E9i;'i=tEdauc8;ETEESEB
E
b
CoE..aE4'-c,a oa
P9 d E E d e*EEE E EE E ,-H c H=: o=:6io=(nooo)(r)'E:H EEK SEEE!D -() 6 al=Fo u, a
=9u) > E66e 6 EEtC) Z. LL
(o colo)a a?lq
N coloC.l C.ll Lr)@ el6rrrrlrr
O$(o@
tr,oEoo
o!A'
3_(D
oC!,!,
.D(D
3n
dc6'o
o
(D
3
q)3.o
o
a,(D
3.oo
(o +o --l
o oE (D
Q 1€ =fr"6 d ti 9) ohE9No =.o- oi i6Of-O *colB<u-
=aa9c ol-=:g 3.?c-_
='(/, =oE =^(DEs*gEXo*(n ova9 Bo qx
r 5'oo)=^
=!,b'dlE)a 6
z. egd q'=#oN) -+ (:' s (, N) -3hi o, <.rr s (, N) -=.=== ni NJ'
gilf$3qq E af i d EB E E + a q $aa;sF;E 6 a 6 a ; E " =€39;
-E o, ^ =9 (,
IfliEAF$+EEEEBEEEEI".8"F*t* i[* *iaEqE=EeII d=.s =3? a =T*+!l* [Er iltsiIBtfqi= 13[ =qq;tsi?!*eE tE; s*-5. iia : iia€ [ = fi+e H s {i
+es*s*$Eiigtg[$t$BsE
e
=is4i
EEiriiaa X3ai€
g afEEi EiEIEEE'*:;s3 B;s r ia=n5+,F 6$EEq gfre 6 3gn[+si q'E=t
a i s Eiile=rr fq-C
E * 3 [3833fia esH$
B s ; o3o .in$
rEq gE6=.9a=.i I e.P Ii =< -c)or d o-.R Ia;eE=a(D ='=+--=o('):(D = =(Di j ** a=*6a93; E d
<H * s
!? O-oO(u =.3.d.g;(Da'-=-o = =o-=iZ o o)fe=$[=o 6919 =o E
= o -ci3 FFE**e
Q == -{
Q'" =(D9s 6'Ee E 3€.} 6.>o-
e &+E
=*aq=s.S1=(, (D oo Fd += --{o 5da'6x
Hi o 6'o =o (D
5-€ 6 3.*3doadgo-Jcs='
f :? S
i.o oN ='oo !l(Doo ?.o8
=_ 6'*
="sEN8E1tm6'!2 N-
= -(Dsid=o)@1.#e El€o
=:so€ *@(D=EB e9lo:{95ea S3I6-=; q'e
freq-o a1
eq'966'a
r= =q: +gngo;X o= O:g J-^.5o;i(D < = - f =2,3Q = !B 6 = 9l< 6
EflEE*F113
?sEg-iE 3 [:EA3<I3 5
==; e E 18
*++= g q'B
* iEqfl$ s
=4;E3FE-: oE *o(D o c Fo) aP l9 =.g o)
= e'9 i aQ.(D *=c* =mN
f 3E s
=-d6'o 6:-= =obd =0'Eq 3 sg:E=Ar6'(D;-
='f c) -'--:o doa€E
Xoo)a=. (D ='o=r==(o s-- (D
-.c, =o?9d=(D -:=@: u=€'JE*irj r3o"6e a:fr*EdHa&c=x
=8e'<6*o o-v
x = nD 9 <V
=6a:+oo,ldBEel 6::. q) 9.=@CD
=d erO=9e 3 q=idg_
EEEAF
aE;;13 == E IgFB qs
+P o 5
&[d
=oo=9
a q; rco-?
-a 9-q\e @:oEo(D@o - o(D(D s-- ocLo = -q96r
m!>(/) ou(D='..,u,
*€4ft
==E9ftftil:es=aH=iq[3E6 da-A=^i9ad ii =3 os E EEs:B gn9=$
"q.: + ts 8E d 0'
E*5e Eqqq*'xoo ='(D=+;-
E 3 g iEH 3 N3 d{ Y (D 6':C)*ar =3dEt;0'P €8=;;--i- R=(D-
H iB. += ?Eedq' 33eg
= q666
= a ='<-= oz (Dq ur9l
E
E
SUEA
WATER D,STRIBUTIAN
SYSIE'I4
N
A
Facilities
I R*eruoirs
E gotere
n Trestrent Plantg
A thuttr
@ wrls
Mains
-
112 inch
J4 inch
-
1 112 inch
1 '!/4 inch
-
1 inch
2 112 inch
2 inch
--- 3 inch
' 4 inch
-
6 inch
"- 8 inch
-- -- 12 inch
16 hch
-
18inch
@ 24inch
e 30 inch
-Sihdft s.,,i*n*"
L
s
EAGLE
EAGLE g
ri {i
w
{t"d
d
!c:2
BOISE
'&-a \t
W Kuna Mora Rd E Kuna Mora Rd
ra
!c
@t
E Kuna
I
t {
I II
rl
a F
W Ustick Rd
MERIDIAN
I
q
W Cherry Ln
w
T
w
il
,/
rl
t
bcFgz,
i_J
rl n
E
!i!ht"
I
[,Rd
t
I
I
E Kuna Mora
KUNA