202011102019Annual Report.pdf

ANNUAL REPORT
OF
SUEZ Water Idaho Inc
NAME
P.O. Box 190420, Boise, ID 83719 - 0420
ADDRESS
TO THE
IDAHO PUBLIC
UTILITIES COMMISSION
FOR THE
YEAR ENDED: DECEMBER 31, 2019
SUZ-W
RECEIVED
2020 April 17,PM3:20
IDAHO PUBLIC
UTILITIES COMMISSION
ANNUAL REPORT FOR WATER UTILITIES TO
THE IDAHO PUBLIC UTILITIES COMMISSION
FOR THE YEAR ENDING:
COMPANY INFORMATION
1 Give full name of utility SUEZ Water Idaho Inc
Telephone Area Code ( ) (208) 362-1300
E-mail address Website: www.mysuezwater.com Email: [e-mail]
2 Date of Organization April 2, 1928
3 Organized under the laws of the state of Idaho
4 Address of Principal Office (number & street) 8248 W. Victory Road
5 P.O. Box (if applicable) P.O. Box 190420
6 City Boise
7 State Idaho
8 Zip Code 83719-0420
9 Organization (proprietor, partnership, Corp.) Corporation
10 Towns, Counties served Towns: Boise, Eagle, Meridian
Counties: Ada
11 Are there any affiliated Companies? Yes
If yes, attach a list with names, addresses & descriptions. Explain any services
provided to the utility.
12 Contact Information: Name Phone No.
President Nadine Leslie [phone]
Vice President, Treasurer Michael Algranati [phone]
Secretary Bryant Gonzalez [phone]
Vice President, General Manager Marshall Thompson [phone]
Complaints or Billing Marie Flores [phone]
Engineering Cathy Cooper [phone]
Emergency Service Marshall Thompson or John Lee [phone]
Accounting / Finance Jarmila M. Cary [phone]
13 Were any water systems acquired during the year or any additions/deletions made
to the service area during the year? No
If 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 Utility Holdings Inc.
Street Address 461 From Road, Suite 400
City Paramus
State New Jersey
Zip 07652
December 31, 2019
Page 1
Name: SUEZ Water Idaho Inc
COMPANY INFORMATION
For the Year Ended: December 31, 2019
11. Affiliated Companies:
SUEZ Utility Holdings Inc.
461 From Road, Suite 400
Paramus, NJ 07652
Services provided to the utility:
Management and service contract on file with the I.P.U.C.
13. Additions / Deletions to service area:
Page 1 Detail
NAME: SUEZ Water Idaho Inc
COMPANY INFORMATION (Cont.)
For the Year Ended December 31, 2019
15 Is the system operated or maintained under a
service contract? No
16 If yes:With whom is the contract?
When does the contract expire?
What services and rates are included?
17 Is water purchased for resale through the system? Yes (3 service locations on Joplin Road)
18 If yes:Name of Organization City of Garden City
Name of owner or operator Garden City Public Works - Finance Department
Mailing Address 6015 Glenwood
City Garden City
State ID
Zip 83714
Gallons Amount
Water Purchased 688,908 1,921$
19 Has any system(s) been disapproved by the
Idaho Department of Environmental Quality? No
If yes, attach full explanation
20 Has the Idaho Department of Environmental Quality
recommended any improvements? No
If yes, attach full explanation
21 Number of Complaints received during year concerning:
Quality of Service 1,113
High Bills 152
Disconnection 1,475
22 Number of Customers involuntarily disconnected 1,475
23 Date customers last received a copy of the Summary
of Rules required by IDAPA 31.21.01.701? Mar. - May 2020
Attach a Copy of the Summary
24 Did significant additions or retirements from the
Plant Accounts occur during the year? Yes
If yes, attach full explanation
and an updated system map
DEQ will be performing a sanitary survery in
2020.
Page 2
PUC ANNUAL REPORT PAGE 1 OF 1
SUEZ Water Idaho Inc
4/16/2020
24. SIGNIFICANT ADDITIONS TO THE PLANT ACCOUNT
ADDITIONS (Over $100,000 Gross)
NO. DESCRIPTION AMOUNT
1 C18E501_060_001 Sunset Peak Reservoir Project 3,677,590
2 "F" NEW, REPLACEMENT & FIRE SERVICES 2,676,218
3 "D" HYDRANTS & MAINS 1,609,381
4 C18D314_060_001 Neville Foothills Subdivision 1,266,019
5 "G" NEW & REPLACEMENT METERS 1,076,662
6 C17D339_060_001 St. Luke's Expansion 1,009,065
7 C18D101_060_001 Redwood Creek Pipeline Phase 1 659,191
8 C19C504_060_001 16th Street Well Rebuild 597,877
9 C16D339_060_001 Avimor Sub Phase 5 583,622
10 C18D713_060_001 Cole and Franklin Main Replacement 544,515
11 C16D337_060_001 Boulder Heights No 7 465,649
12 C18D342_060_001 Neville Ranch Sub 3 465,346
13 C17D367_060_001 Stillwater Sub No 1 431,090
14 C18D714_060_001 Cloverdale Overpass Pipe Replace 427,648
15 C18D351_060_001 Avimor Sub No 8 407,343
16 C18D326_060_001 Win Hollow Subdivision 374,644
17 C18D712_060_001 State and Collister 369,481
18 C18D331_060_001 Neville Community Center 358,686
19 C19D705_060_001 Kootenai - Vista to Pico 311,675
20 C17D306_060_001 Lander Street Expansion 291,000
21 C17A101_060_003 Reservoir Storage Accounting Case 270,956
22 C18J300_060_001 SCADA Master Plan 257,054
23 C19D701_060_001 Cloverdale - Ustick to Chinden 239,668
24 C18D360_060_001 West Airport Industrial Park 206,680
25 C18D325_060_001 Tree Farm Sub No 3 199,536
26 C18D322_060_001 Lanewood Sub no 3 183,356
27 C19D711_060_001 16th - Main to Bannock Replacement 181,882
28 C19D709_060_001 Empire Way Main Replacement 165,245
29 C18D356_060_001 Grange Valley Sub 158,956
30 C18D354_060_001 Hazelwood Sub No. 17 139,837
31 C18D348_060_001 11716 Fairview Ave 133,815
32 C19D304_060_001 Charter Pointe Meadows East Sub No. 129,317
33 C17D325_060_001 Parkcenter Blvd. Improvments 125,024
34 C19B505_060_002 Replace Chemical Pumps 121,633
35 C17D323_060_001 Farewell Bend Subdivision 121,542
36 C18D355_060_001 Rush Valley Sub No 1 120,555
37 C18D368_060_001 Harris Ranch North Sub # 3 119,884
38 C18D357_060_001 Williamson River Ranch Sub No 2 118,575
39 C19D706_060_001 Cole - Kettering to Manorwood 116,430
40 C18D316_060_001 Ashbury Business Park No 2 114,417
41 C18D345_060_001 Highland Cove Sub 2 113,685
42 C17D371_060_001 Eronel Subdivision 110,403
43 C18D353_060_001 2370 S Maple Grove 109,955
44 C18D340_060_001 10000 Shields 109,921
45 C19D303_060_001 Wolf Tree Square 109,815
46 C18D347_060_001 Avimor Sub No 7 106,839
47 C18D361_060_001 Lanewood Subdivision No 4 105,444
48 C18D303_060_001 Parkcenter Blvd Improvments #2 103,500
49 C18D366_060_001 Eagle Hawk Subdivision 101,105
TOTAL 21,797,727
December 31, 2019
Page 2 Detail
Additions
PUC ANNUAL REPORT PAGE 1 OF 1
SUEZ Water Idaho Inc
04/16/20
24. SIGNIFICANT RETIREMENTS FROM THE PLANT ACCOUNT
RETIREMENTS (Over $15,000)
BOOK
NO. DESCRIPTION COST
1 C18E501_060_001 Sunset Peak Reservoir Project 685,672$
2 "G" RETIREMENT OF METERS 148,349$
3 RETIRE_060_001 Manual Retirements (Computer Hardware/Software)65,455$
4 C18D713_060_001 Cole and Franklin Main Replacement 49,592$
5 C18D714_060_001 Cloverdale Overpass Pipe Replace 47,033$
6 C19C504_060_001 16th Street Well Rebuild 32,564$
7 C19B505_060_002 Replace Chemical Pumps 25,700$
8 C19C100_060_002 Sunset West Well Pump Replacement 21,883$
9 C19C525_060_002 Replace Maple Hills HVAC 19,144$
10 C18B500_060_019 CWTP Air Compressor Replacement 17,920$
11 C19B500_060_002 Replace CWTP Turbidity Units 16,947$
12 C18D712_060_001 State and Collister 15,740$
13 C19C100_060_003 Mac well pump rebuild 15,078$
TOTAL 1,161,076$
December 31, 2019
Page 2 Detail
Retirements
NAME: SUEZ Water Idaho Inc
REVENUE & EXPENSE DETAIL
For the Year Ended December 31, 2019
ACCT # DESCRIPTION AMOUNT
400 REVENUES
1 460 - Unmetered Water revenue
2 461.1 - Metered Sales - residential 31,028,703
3 461.2 - Metered Sales - commercial, industrial 13,279,048
4 462 - Fire Protection Revenue - Private 1,100,657
5 464 - Other revenue 653,738
6 465 - Irrigation Sales revenue -
7 466 - Sales for Resale -
8 400 Total Revenue (Add Lines 1 - 7) 46,062,146
(also enter result on Page 4, line 1) Booked to Acct #:
9 * DEQ Fees Billed separately to customers 276,430 23699000
10 ** Hookup or Connection Fees Collected -
11 ***Commission Approved Surcharges (Franchise Taxes) 1,210,516 23610000
401 OPERATING EXPENSES -
12 601.1-6 - Labor - Operations & Maintenance 2,839,006
13 601.7 - Labor - Customer Accounts 1,188,339
14 601.8 - Labor - Administrative & General 869,647
15 603 - Salaries - Officers & Directors -
16 604 - Employee Pensions & Benefits 1,400,317
17 610 - Purchased Water (Includes leased) 159,956
18 615-16 - Purchased Power & Fuel for Power 2,358,661
19 618 - Chemicals 407,098
20 620.1-6 - Material & Supplies - Operation & Maint 204,262
21 620.7-8 - Material & Supplies - A&G and Cust Care 14,007
22 631-34 - Contract Services - Professional 3,814,660
23 635 - Contract Services - Water Testing 121,606
24 636 - Contract Services - Other 811,431
25 641-42 - Rentals - Property & Equipment 12,841
26 650 - Transportation Expense 503,451
27 656-59 - Insurance (Corporate adj. to reserves) (39,311)
28 660 - Advertising 120,249
29 666 - Rate Case Expense (Amortization) -
30 667 - Regulatory Comm. Exp. (Amortizations) 0
31 670 - Bad Debt Expense 372,035
32 675 - Miscellaneous 1,212,020
33 Total Operating Expenses (less Reg. Comm, Depr, Taxes) 16,370,275
( Add lines 12 - 32, also enter on Pg 4, line 2)
Page 3
Name: SUEZ Water Idaho Inc
INCOME STATEMENT
For Year Ended December 31, 2019
ACCT # DESCRIPTION
1 Revenue (From Page 3, line 8) 46,062,146
2 Operating Expenses (From Page 3, line 33) 16,370,275
3 403 - Depreciation Expense 9,553,787
4 406 - Amortization, Utility Plant Acquisition Adj 20,712
5 407 - Amortization Exp. - Other Utility Plant -
6 408.10 - Regulatory Fees 122,137
7 408.11 - Property Taxes 1,875,902
8 408.12 - Payroll Taxes 545,623
9A 408.13 - Other Taxes -
9B
9C
9D
10 409.10 - Federal Income Taxes 4,622,932
11 409.11 - State Income Taxes 1,726,441
12 410.10 - Prov for Deferred Income Tax - Federal (996,514)
13 410.11 - Prov for Deferred Income Tax - State (1,025,964)
14 411 - Prov for Deferred Utility Income Tax Credits -
15 412 - Investment Tax Credits - Utility (48,240)
16 Total Expenses from operations before interest (add lines 2-15) 32,767,091
17 413 - Income from Utility Plant Leased to Others -
18 414 - Gains (Losses) from Disposition of Util Plant 7,652
19 Net Operating Income (Add lines 1, 17 &18 less line 16)- 13,302,706
20 415 - Revenues, Mdsing, Jobbing & Contract Work -
21 416 - Expenses, Mdsing, Jobbing & Contract Work -
22 419 - Interest & Dividend Income Other -
23 420 - Allowance for Funds Used During Construction 1,135,645
24 421 - Miscellaneous Non-Utility Income 94,100
25 426 - Miscellaneous Non-Utility Expense (Largely CIAC due to new tax law) (1,095,751)
26 408.20 - Other Taxes, Non-Utility Operations -
27 409.20 - Income Taxes, Non-Utility Operations -
28 Net Non-Utility Income (Add lines 20,22,23 & 24 less lines 21,25,26, & 27) 2,325,496
29 Gross Income (add lines 19 & 28)15,628,202
30 427.3 - Interest Expense on Long-Term Debt 3,921,165
31 427.5 - Other Interest Charges 464
32 NET INCOME (Line 29 less lines 30 & 31) (Also Enter on Pg 9, Line 2) 11,706,574
Page 4
Name: SUEZ Water Idaho Inc
ACCOUNT 101 PLANT IN SERVICE DETAIL
For Year Ended: December 31, 2019
Balance Added Removed Balance
SUB Beginning During During End of
ACCT # DESCRIPTION of Year Year Year Year
1 301 Organization 103,738 - - 103,738
2 302 Franchises and Consents 41,182 - - 41,182
3 303 Land, Land Rights & Water Rights 11,707,124 379,452 - 12,086,576
4 304 Structures and Improvements 28,987,809 342,887 (61,412) 29,269,283
5 305 Reservoirs & Standpipes 8,189 - - 8,189
6 306 Lake, River & Other Intakes 1,511,320 - - 1,511,320
7 307 Wells 8,077,303 - (40,426) 8,036,877
8 308 Infiltration Galleries & Tunnels 60,351 12,597 - 72,948
9 309 Supply Mains 2,860,854 119,980 - 2,980,834
10 310 Power Generation Equipment 3,614,453 1,964 (100,287) 3,516,130
11 311 Power Pumping Equipment 26,208,517 939,672 (183,780) 26,964,409
12 320 Purification Systems 29,524,568 329,024 (64,962) 29,788,630
13 330 Distribution Reservoirs & Standpipes 11,838,068 2,049,618 (513,278) 13,374,408
14 331 Trans. & Distrib. Mains & Accessories 197,452,353 13,071,991 (190,514) 210,333,830
15 333 Services 83,349,763 4,621,254 - 87,971,017
16 334 Meters and Meter Installations 16,176,971 1,076,662 (148,349) 17,105,284
17 335 Hydrants 8,756,210 1,285,504 - 10,041,715
18 336 Backflow Prevention Devices - - - -
19 339 Other Plant & Misc. Equipment - - - -
20 340 Office Furniture and Computer Equipment 11,278,831 118,944 (85,489) 11,312,286
21 341 Transportation Equipment 36,773 - - 36,773
22 342 Stores Equipment 19,635 - - 19,635
23 343 Tools, Shop and Garage Equipment 1,297,341 37,961 - 1,335,302
24 344 Laboratory Equipment 335,654 - (18,160) 317,493
25 345 Power Operated Equipment 78,331 - - 78,331
26 346 Communications Equipment 4,192,518 433,172 (17,576) 4,608,113
27 347 Miscellaneous Equipment 129,426 26,309 - 155,735
28 348 Other Tangible Property 2,428,801 165,976 - 2,594,777
29 Rounding Difference 0 - - 0
- -
30 TOTAL PLANT IN SERVICE 450,076,083 25,012,966 (1,424,234) 473,664,816
Enter beginning & end of year totals on Pg 7, Line 1
Page 5
Name: SUEZ Water Idaho Inc
For Year Ended: December 31, 2019

Balance Balance Increase
SUB Beginning End of or
ACCT #DESCRIPTION of Year Year (Decrease)
1 304 Structures and Improvements 2.00% 2.50% Office Bldg. 8,754,243 9,264,829 510,587
2 305 Reservoirs & Standpipes 2.00% 27 191 164
3 306 Lake, River & Other Intakes 2.00% 497,619 527,846 30,226
4 307 Wells 2.86% 3,988,707 4,178,081 189,373
5 308 Infiltration Galleries & Tunnels 2.00% 45,658 46,928 1,270
6 309 Supply Mains 2.00% 773,117 831,458 58,341
7 310 Power Generation Equipment 5.00% 1,319,321 1,396,147 76,826
8 311 Electric Pumping Equipment 5.00% 15,363,316 16,523,751 1,160,435
9 320 Purification Systems 5.00% 14.28% Filters 21,373,529 22,903,921 1,530,392
10 330 Distribution Reservoirs & Standpipes 2.00% 3,612,565 3,366,079 (246,486)
11 331 Trans. & Distrib. Mains & Accessories 2.00% 61,669,771 65,447,615 3,777,843
12 333 Services 2.50% 28,975,807 30,816,744 1,840,937
13 334 Meters and Meter Installations 2.50% 377,500 607,985 230,485
14 335 Hydrants 2.50% 1,401,978 1,631,909 229,931
15 336 Backflow Prevention Devices 2.00% - - -
16 339 Other Plant & Misc. Equipment 2.00% - - -
17 340 Office Furniture and Equipment 6.67% 10.00% 20.00% 7,861,549 8,459,479 597,931
18 341 Transportation Equipment 11.49% 85,962 86,855 893
19 342 Stores Equipment 6.67% 50,871 19,635 (31,237)
20 343 Tools, Shop and Garage Equipment 6.67% 776,947 862,765 85,819
21 344 Laboratory Equipment 6.67% 269,075 272,380 3,305
22 345 Power Operated Equipment 14.50% 107,987 107,081 (906)
23 346 Communications Equipment 6.67% 1,874,452 2,148,945 274,493
24 347 Miscellaneous Equipment 6.67% 97,667 118,276 20,609
25 348 Other Tangible Property 2.00% 10.00% Master Plan 872,021 1,103,894 231,874
26 301 Organization 0.00% (810) (810) -
27 303 Land & Land Rights 0.00% (52,955) (56,579) (3,624)
28 302 Franchise/Consents-Intang Plt - 11,357 11,357
29 Cost of Removal / Salvage - - -
30 Rounding (0) 0 0
31 TOTALS (Add Lines 1 - 30) 160,095,924 170,676,764 10,580,840
%
ACCUMULATED DEPRECIATION ACCOUNT 108.1 DETAIL
Annual
Depreciation
Rate *
Page 6
Name: SUEZ Water Idaho Inc
BALANCE SHEET
For Year Ended:
ASSETS Balance Balance Increase
Beginning End of or
ACCT # DESCRIPTION of Year Year (Decrease)
1 101/106 Utility Plant in Service (From Pg 5, Line 30) 450,076,084 473,664,816 23,588,733
2 102 Utility Plant Leased to Others -
3 103 Plant Held for Future Use -
4 107 Construction Work in Progress 13,287,345 19,650,782 6,363,437
5 114 Utility Plant Aquisition Adjustment 600,761 600,761 -
6 Subtotal (Add Lines 1 - 5) 463,964,190 493,916,360 29,952,170
7 108.1 Accumulated Depreciation (From Pg 6, Line 31) 160,095,924 170,676,764 10,580,840
8 108.2 Accum. Depr.- Utility Plant Lease to Others - -
9 108.3 Accum. Depr. - Property Held for Future Use - -
10 110.1 Accum. Amort. - Utility Plant In Service - -
11 110.2 Accum. Amort.- Utility Plant Lease to Others - -
12 115 Accumulated Amortization- Aquisition Adj. 194,825 215,537 20,712
13 Net Utility Plant (Line 6 less lines 7 - 12) 303,673,441 323,024,059 19,350,618
14 123 Investment in Subsidiaries - -
15 121 Other Investments (Non-utility Property) 11,054 11,054 -
16 Total Investments (Add lines 14 & 15) 11,054 11,054 -
17 131 Cash 41,550 41,550 -
18 135 Short Term Investments -
19 141 Accts/Notes Receivable - Customers 1,410,395 543,806 (866,588)
20 142 Other Receivables 8,896 - (8,896)
21 145 Receivables from Associated Companies 0 (2,020,631) (2,020,631)
22 151 Materials & Supplies Inventory 548,147 578,901 30,754
23 162 Prepaid Expenses 72,000 92,250 20,250
24 173 Unbilled (Accrued) Utility Revenue 2,985,863 3,395,680 409,817
25 143 Provision for Uncollectable Accounts 382,000 467,711 85,711
26 Total Current (add lines 17 -24 less line 25) 4,684,850 2,163,845 (2,521,005)
27 181 Unamortized Debt Discount & Expense - -
28 183 Preliminary Survey & Investigation Charges 1,450,393 1,547,989 97,596
29 184 Deferred Rate Case Expenses (0) (0) -
30 186 Other Deferred Charges 4,824,669 5,906,225 1,081,556
31 Total Assets (Add lines 13, 16 & 26 - 30) 314,644,407 332,653,172 18,008,765
December 31, 2019
Page 7
Name: SUEZ Water Idaho Inc
BALANCE SHEET
For Year Ended:
LIABILITIES & CAPITAL Balance Balance Increase
Beginning End of or
ACCT # DESCRIPTION of Year Year (Decrease)
1 201-3 Common Stock 1,261,750 1,261,750 -
2 204-6 Preferred Stock -
3 207-13 Miscellaneous Capital Accounts 81,437,835 82,146,319 708,484
4 214 Appropriated Retained Earnings -
5 215 Unappropriated Retained Earnings 97,631,147 110,125,619 12,494,473
6 216 Reacquired Capital Stock -
7 218 Proprietary Capital -
8 Total Equity Capital (Add Lines 1-5+7 less line 6) 180,330,732 193,533,688 13,202,957
9 221-2 Bonds - - -
10 223 Advances from Associated Companies - - -
11 224 Other Long- Term Debt - - -
12 231 Accounts Payable 2,122,120 2,997,456 875,336
13 232 Notes Payable - - -
14 233 Accounts Payable - Associated Companies - - -
15 235 Customer Deposits (Refundable) - - -
16 236.11 Accrued Other Taxes Payable 1,159,347 1,076,670 (82,677)
17 236.12 Accrued Income Taxes Payable 7,129,621 8,826,744 1,697,123
18 236.2 Accrued Taxes - Non-Utility - - -
19 237-40 Accrued Debt, Interest & Dividends Payable - - -
20 241 Misc. Current & Accrued Liabilities 851,087 1,594,991 743,904
21 251 Unamortized Debt Premium - - -
22 252 Advances for Construction 4,383,091 4,160,466 (222,625)
23 253 Other Deferred Liabilities 10,232,950 9,983,783 (249,167)
24 255.1 Accumulated Investment Tax Credits - Utility 615,634 567,394 (48,240)
25 255.2 Accum. Investment Tax Credits - Non-Utility - - -
26 261-5 Operating Reserves (Pension & Benefits) 7,548,485 6,992,441 (556,044)
27 271 Contributions in Aid of Construction 132,413,329 139,780,628 7,367,300
28 272 Accum. Amort. of Contrib. in Aid of Const. ** (38,604,533) (41,551,015) (2,946,482)
29 281-3 Accumulated Deferred Income Taxes 6,462,545 4,689,926 (1,772,619)
30 Total Liabilities (Add lines 9 - 29) 134,313,675 139,119,484 4,805,808
31 TOTAL LIAB & CAPITAL (Add lines 8 & 30) 314,644,407 332,653,172 18,008,765
** Only if Commission Approved
December 31, 2019
Page 8
Name: SUEZ Water Idaho Inc
STATEMENT OF RETAINED EARNINGS
For Year Ended: December 31, 2019
1 Retained Earnings Balance @ Beginning of Year 97,631,147
2 Amount Added from Current Year Income (From Pg 4, Line 32)11,706,574
3 Other (Credits) / Debits to Account 787,899
4 Dividends Paid or Appropriated -
5 Other Distributions of Retained Earnings -
6 Retained Earnings Balance @ End of Year 110,125,619
CAPITAL STOCK DETAIL
No. Shares No. Shares Dividends
7 Description (Class, Par Value etc.) Authorized Outstanding Paid
Common Stock, $50.00 Par Value 50,000 25,235 -$
DETAIL OF LONG-TERM DEBT
Interest Year-end Interest Interest
8 Description Rate Balance Paid Accrued
None - Held by Parent (SUEZ Utility Holdings Inc.)
Page 9
Name: SUEZ Water Idaho Inc
SYSTEM ENGINEERING DATA
For Year Ended:
1 Provide an updated system map if significant changes have been made to the system during the year.
2 Water Supply: Type of Water
Treatment: Supply
Rated (None, Chlorine Annual Source
Capacity Fluoride Production (Well, Spring,
Pump Designation or location (GPM) Filter etc.) (000's Gal.) Surface Wtr)
See attached Treatment
3 System Storage:
Total Usable Type of
Capacity Capacity Reservoir Construction
000's 000's (Elevated,Pres- (Wood, Steel
Storage Designation or Location Gal. Gal. urized, Boosted) Concrete)
See attached Storage
(Duplicate form and attach if necessary. Asterisk facilities added this year.)
December 31, 2019
Page 10
PUC ANNUAL REPORT
SUEZ Water Idaho Inc
04/16/20
RATED ANNUAL WATER
SITE PUMP CAPACITY PROD TYPE OF SUPPLY
NO.DESIGNATION (GPM)(1000 GAL)TREATMENT Notes SOURCE
1 16TH ST 800 82,291 NaOCl (12 to 15%), PO4 Ground Water
2 27TH ST 350 65,162 NaOCl (12 to 15%)Ground Water
3 AMITY 700 290,713 NaOCl <1%, PO4 Ground Water
4 ARCTIC 700 - NaOCl (12 to 15%), PO4 Out of service in 2019 Ground Water
5 BALI HAI 2,400 121,923 Green Sand, NaOCl <1%Ground Water
6 BEACON 600 29,068 NaOCl (12 to 15%)Ground Water
7 BERGESON 700 22,592 NaOCl (12 to 15%)Ground Water
8 BETHEL 2,500 947,586 NaOCl <1%Ground Water
9 BIF 250 44,854 NaOCl (12 to 15%), PO4 Ground Water
10 BROADWAY 1,000 205,469 NaOCl <1%Ground Water
11 BROOK HOLLOW 850 65,792 NaOCl (12 to 15%), PO4 Ground Water
12 BYRD NA 10 NaOCl (12 to 15%)Out of service in 2019 Ground Water
13 CASSIA 1 900 116,958 NaOCl <1%, PO4 Ground Water
14 CASSIA 2 800 34,245 NaOCl <1%Ground Water
15 CENTENNIAL 750 121,056 NaOCl <1%Ground Water
16 CHAMBERLAIN 1 250 7,608 NaOCl (12 to 15%), PO4 Ground Water
17 CHAMBERLAIN 2 600 110,245 NaOCl (12 to 15%)Ground Water
18 CLIFFSIDE 800 164,053 NaOCl (12 to 15%)Ground Water
19 CLINTON 1,300 174,408 NaOCl (12 to 15%), PO4 Ground Water
20 COLE 700 39,655 NaOCl (12 to 15%) & ASR Ground Water
21 COUNTRY CLUB 800 118,586 NaOCl (12 to 15%)Ground Water
22 COUNTRY SQUARE 1,100 175,061 NaOCl (12 to 15%)Ground Water
23 COUNTRYMAN 500 - NaOCl (12 to 15%)Out of service in 2019 Ground Water
24 DURHAM 200 57,524 NaOCl (12 to 15%)Ground Water
25 EDGEVIEW 800 21,475 NaOCl (12 to 15%)Ground Water
26 FISK 1,900 355,722 NaOCl <1% GAC Ground Water
27 FIVE MILE 12 1,000 88,279 NaOCl (12 to 15%)Ground Water
28 FLOATING FEATHER 3,000 708,375 NaOCl <1%Ground Water
29 FOX TAIL 1,000 7,565 NaOCl (12 to 15%), PO4 Ground Water
30 FRANKLIN PARK 1,200 347,391 NaOCl <1%Ground Water
31 FRONTIER 1 1,750 74,522 NaOCl (12 to 15%), ASR Ground Water
32 GODDARD 1 1,300 157,357 NaOCl <1%Ground Water
33 H.P. 1,100 395,629 NaOCl <1%Ground Water
34 HIDDEN VALLEY 1 950 255,742 NaOCl <1%Ground Water
35 HIDDEN VALLEY 2 750 73,174 NaOCl (12 to 15%)Ground Water
36 HILLCREST 750 325,590 NaOCl <1%Ground Water
37 HILTON 1,400 345,412 Green Sand, NaOCl <1%Ground Water
38 HUMMEL 600 1 NaOCl (12 to 15%), PO4 Out of service in 2019 Ground Water
39 IDAHO 375 - NaOCl (12 to 15%), PO4 Out of service in 2019 Ground Water
40 ISLAND WOODS 1 800 88,694 NaOCl (12 to 15%)Ground Water
41 ISLAND WOODS 2 800 49,732 NaOCl (12 to 15%)Ground Water
42 JR FLAT 450 89,488 NaOCl (12 to 15%)Ground Water
43 KIRKWOOD 300 97,955 NaOCl (12 to 15%)Ground Water
44 LA GRANGE 1,350 121,707 NaOCl <1%Ground Water
45 LICORICE 190 35,406 NaOCl (12 to 15%)Ground Water
46 LOGGER 750 127,342 NaOCl <1%Ground Water
47 LONGMEADOW 250 - NaOCl (12 to 15%)Out of service in 2019 Ground Water
48 MAC 1,200 153,276 NaOCl (12 to 15%), PO4 Ground Water
49 MAPLE HILL 1,800 385,677 Green Sand, NaOCl <1%Ground Water
50 MAPLE HILL 2 500 10,339 NaOCl <1% ASR Ground Water
51 MARKET 700 33,190 NaOCl (12 to 15%) & ASR Ground Water
52 MCMILLAN 800 95,699 NaOCl (12 to 15%)Ground Water
53 OVERLAND Well 1,000 98,017 NaOCl <1%, PO4 Ground Water
54 PARADISE 500 68,385 NaOCl (12 to 15%)Ground Water
55 PIONEER 1,200 286,984 NaOCl <1%Ground Water
56 PLEASANT VALLEY 1,800 219,588 NaOCl <1%Ground Water
December 31, 2019
Page 10 Detail A Treatment (Page 1 of 2)
PUC ANNUAL REPORT
SUEZ Water Idaho Inc
04/16/20
RATED ANNUAL WATER
SITE PUMP CAPACITY PROD TYPE OF SUPPLY
NO.DESIGNATION (GPM)(1000 GAL)TREATMENT Notes SOURCE
December 31, 2019
57 RAPTOR 1,000 104,231 NaOCl (12 to 15%)Ground Water
58 REDWOOD CREEK 1 1,800 13,805 NaOCl (12 to 15%)Ground Water
59 RIVER RUN 900 31,011 NaOCl (12 to 15%)Ground Water
60 ROOSEVELT 1 700 56,772 NaOCl <1%, PO4 Ground Water
61 ROOSEVELT 3 600 193,313 NaOCl <1%,PO4 Ground Water
62 SETTLERS 1,000 28,557 NaOCl (12 to 15%) & ASR Ground Water
63 SPURWING 2,000 1 NaOCl (12 to 15%)Fire Standby Ground Water
64 SUNSET WEST 2,000 404,975 NaOCl <1%Ground Water
65 SWIFT 1 1,100 40,682 NaOCl (12 to 15%) GAC & ASR Ground Water
66 SWIFT 2 900 85,767 NaOCl (12 to 15%) GAC & ASR Ground Water
67 TAGGART 1 300 85,180 NaOCl <1%Ground Water
68 TAGGART 2 750 169,640 NaOCl <1%Ground Water
69 TEN MILE 1,000 374,754 NaOCl <1%Ground Water
70 TERTELING 425 58,453 NaOCl (12 to 15%)Ground Water
71 VETERANS 740 201,822 NaOCL <1%Ground Water
72 VICTORY 600 277,606 NaOCL <1%Ground Water
73 VISTA 450 116,650 NaOCl (12 to 15%), PO4 Ground Water
74 WARM SPRINGS 2 450 - NaOCl (12 to 15%)Out of service in 2019 Ground Water
75 WARM SPRINGS 3 600 31,731 NaOCl (12 to 15%)Ground Water
76 WESTMORELAND 350 16,623 NaOCL (12 to 15%)Ground Water
77 WILLOW LANE 1 500 - NaOCl (12 to 15%), PO4 Out of service in 2019 Ground Water
78 WILLOW LANE 2 370 34,051 NaOCl (12 to 15%)Ground Water
79 WILLOW LANE 3 300 38,093 NaOCl (12 to 15%)Ground Water
1 Columbia WTP 4,170 1,269,573 Membrane Filtration, NaOCl <1%Surface Water
2 Marden WTP 12,700 2,972,734 Conventional Filtration, NaOCl <1%Surface Water
14,718,598
Asterisk facilities added this year
Page 10 Detail A Treatment (Page 2 of 2)
PUC ANNUAL REPORT Page 10 - 3. System Storage
SUEZ Water Idaho Inc
04/16/20
RESERVOIR AVAILABLE TYPE CONSTRUCTION
STORAGE STORAGE CAPACITY Elevated Concrete, Steel,
SITE DESIGNATION CAPACITY (1,000 GALLONS)Boosted Wood
NO.(1,000 GALLONS)Both
1 Aeronca Tank 150 140 Boosted Steel
2 Arrowhead Tank 445 444 Elevated Concrete
3 Arrowhead1 Clearwell 30 29 Both Concrete
4 Arrowhead2 Clearwell 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 Briarhill Tank 250 250 Both Concrete
9 Broken Horn Tank 662 657 Elevated Steel
10 Claremont Tank 1 90 90 Elevated Concrete
11 Claremont Tank 2 192 192 Elevated Concrete
12 Columbia Tank 3,000 1,500 Elevated Steel
13 Columbia WTP 1,500 1,200 Both Steel
14 Crestline Tank 300 300 Both Steel
15 Federal Tank 2,000 2,000 Boosted Steel
16 Five Mile Tank 2,400 2,121 Boosted Steel
17 Good Street Tank 3,000 3,000 Both Steel
18 Gowen Tank 2,000 2,000 Both Steel
19 Harris Ranch North 356 356 Elevated Steel
20 Harris Ranch Tank 360 360 Elevated Concrete
21 Harvard Tank 150 150 Boosted Steel
22 Hidden Hollow Tank 2,000 2,000 Both Steel
23 Hidden Springs Tank 347 347 Elevated Steel
24 Hidden Springs Tank #2 *** 619 619 Both Steel
25 Hillcrest Tank 2,000 2,000 Boosted Steel
26 Hulls Gulch Tank 6,000 6,000 Both Steel
27 Marden WTP Clearwell 900 450 Boosted Concrete
28 North Mountain Tank 300 300 Elevated Steel
29 Old Pen Tank 320 320 Elevated Concrete
30 Quail Ridge Tank 326 325 Elevated Concrete
31 Steelhead Tank 3,000 2,900 Boosted Steel
32 Sunset Peak *** 1,000 1,000 Elevated Concrete
33 Table Rock Tank 68 65 Elevated Concrete
34 Toluka Tank 92 90 Both Steel
35 Upper Danmor Tank 750 750 Both Concrete
36 Ustick Tank 2,000 1,900 Boosted Steel
39,627 36,834
Asterisk facilities added this year ***
December 31, 2019
Page 10 Detail B Storage
Name: SUEZ Water Idaho Inc
SYSTEM ENGINEERING DATA
(continued)
For Year Ended:
4 Pump information for ALL system pumps, including wells and boosters.
Rated Discharge Energy
Designation or Location Horse Capacity Pressure Used
& Type of Pump** Power (gpm) (psi) This Year
See attached Pumps & 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 If Wells are metered:
What was the total amount pumped this year? 14,719
What was the total amount pumped during peak month? 2,360
What was the total amount pumped on the peak day? 82
6 If customers are metered, what was the total amount sold in peak month? 2,249
7 Was your system designed to supply fire flows? Yes
If Yes:What is current system rating? ISO-3
8 How many times were meters read this year? 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? 14,000
How many of those potential additions are vacant lots? 1,000
10 Are backbone plant additions anticipated during the coming year? Yes
If Yes, attach an explanation of projects and anticipated costs
11 In what year do you anticipate that the system capacity (supply, storage or distribution)
will have to be expanded? 2021
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.
Replace Arctic/Fairview Booster - $600,000
2021. West Gowen Reservoir - Construct new tank to meet growth demands in the West Gowen
service area.
December 31, 2019
Page 11
PUC ANNUAL REPORT Page 11 - 4. All System Pumps (including Wells & Boosters)
SUEZ Water Idaho Inc
04/16/20
SITE # TYPE LOCATION PUMP TYPE HP
RATED
GPM DPSI KWH USED PRODUCTION Treatment
1 WELLPUMP 16th Street Well Pump DWVerticalTurbine 100 800 72 117,104 82,291 NaOCl (12 to 15%), PO4
2 WELLPUMP 27th Street Well Pump Submersible 60 350 65 154,789 65,162 NaOCl (12 to 15%)
3 WELLPUMP Amity Well Pump VSP DWVerticalTurbine 150 700 87 632,580 290,713 NaOCl <1%, PO4
4 WELLPUMP Arctic Well Pump DWVerticalTurbine 100 700 80 11,520 - NaOCl (12 to 15%), PO4
5 WELLPUMP Bali Hai Well Pump VSP DWVerticalTurbine 350 2,400 80 288,000 121,923 Green Sand, NaOCl <1%
6 WELLPUMP Beacon Well Pump DWVerticalTurbine 75 600 65 51,818 29,068 NaOCl (12 to 15%)
7 WELLPUMP Bergeson Well Pump Submersible 100 700 62 50,240 22,592 NaOCl (12 to 15%)
8 WELLPUMP Bethel Well Pump VSP DWVerticalTurbine 200 2,500 60 1,101,080 947,586 NaOCl <1%
9 WELLPUMP BIF Well Pump Submersible 40 250 57 117,770 44,854 NaOCl (12 to 15%), PO4
10 WELLPUMP Broadway Well Pump DWVerticalTurbine 150 1,000 55 455,880 205,469 NaOCl <1%
11 WELLPUMP Brook Hollow Well Pump DWVerticalTurbine 75 850 60 115,328 65,792 NaOCl (12 to 15%), PO4
12 WELLPUMP Cassia 1 Well Pump DWVerticalTurbine 100 900 60 223,120 116,958 NaOCl <1%, PO4
13 WELLPUMP Cassia 2 Well Pump VSP DWVerticalTurbine 125 800 60 34,245 NaOCl <1%
14 WELLPUMP Centennial Well Pump DWVerticalTurbine 100 750 57 281,680 121,056 NaOCl <1%
15 WELLPUMP Central Park Well Pump RETIRED IN 2017 3,694 -
16 WELLPUMP Chamberlain 1 Well Pump DWVerticalTurbine 50 250 70 131,640 7,608 NaOCl (12 to 15%), PO4
17 WELLPUMP Chamberlain 2 Well Pump DWVerticalTurbine 30 380 70 110,245 NaOCl (12 to 15%)
18 WELLPUMP Cliffside Well Pump VSP DWVerticalTurbine 50 500 60 192,923 164,053 NaOCl (12 to 15%)
19 WELLPUMP Clinton Well Pump DWVerticalTurbine 125 1,300 59 231,840 174,408 NaOCl (12 to 15%), PO4
20 WELLPUMP Cole Well Pump DWVerticalTurbine 100 700 70 64,960 39,655 NaOCl (12 to 15%) & ASR
21 WELLPUMP Country Club Well Pump DWVerticalTurbine 125 800 46 193,440 118,586 NaOCl (12 to 15%)
22 WELLPUMP Country Square Well Pump VSP DWVerticalTurbine 125 1,100 58 305,480 175,061 NaOCl (12 to 15%)
23 WELLPUMP Countryman Well Pump DWVerticalTurbine 50 500 65 2,534 - NaOCl (12 to 15%)
24 WELLPUMP Durham Well Pump Submersible 15 200 62 61,826 57,524 NaOCl (12 to 15%)
25 WELLPUMP Edgeview Well VSP Submersible 75 800 60 36,840 21,475 NaOCl (12 to 15%)
26 WELLPUMP Fisk Well Pump VSP DWVerticalTurbine 200 1,900 59 715,340 355,722 NaOCl <1%
27 WELLPUMP Five Mile 12 Well Pump DWVerticalTurbine 75 1,000 55 167,400 88,279 NaOCl (12 to 15%)
28 WELLPUMP Floating Feather Well VSP DWVerticalTurbine 450 3,000 63 1,234,320 708,375 NaOCl <1%
29 WELLPUMP Foxtail Well Pump VSP DWVerticalTurbine 125 1,000 80 21,520 7,565 NaOCl (12 to 15%), PO4
30 WELLPUMP Franklin Park Well Pump DWVerticalTurbine 125 1,200 60 488,520 347,391 NaOCl <1%
31 WELLPUMP Frontier Well Pump VSP DWVerticalTurbine 150 1,750 58 111,120 74,522 NaOCl (12 to 15%), PO4 & ASR
32 WELLPUMP Goddard Well Pump DWVerticalTurbine 150 1,300 54 369,120 157,357 NaOCl <1%
33 WELLPUMP Hidden Valley 1 Well VSP DWVerticalTurbine 150 950 68 499,960 255,742 NaOCl <1%
34 WELLPUMP Hidden Valley 2 Well VSP DWVerticalTurbine 100 750 70 120,320 73,174 NaOCl (12 to 15%)
35 WELLPUMP Hillcrest Well Pump DWVerticalTurbine 100 750 32 909,000 325,590 NaOCl <1%
36 WELLPUMP Hilton Well VSP DWVerticalTurbine 200 1,400 58 577,320 345,412 NaOCl <1%
37 WELLPUMP HP Well VSP DWVerticalTurbine 150 1,100 70 717,680 395,629 Green Sand, NaOCl <1%
38 WELLPUMP Hummel Well Pump DWVerticalTurbine 75 600 66 3,588 1 NaOCl (12 to 15%), PO4
39 WELLPUMP Idaho Well Pump DWVerticalTurbine 50 375 68 3,560 - NaOCl (12 to 15%), PO4
40 WELLPUMP Island Wood 1 Well Pump VSP Submersible 15 150 69 93,862 88,694 NaOCl (12 to 15%)
41 WELLPUMP Island Wood 2 Well Pump VSP Submersible 75 800 66 110,636 49,732 NaOCl (12 to 15%)
42 WELLPUMP JR Flat Well Pump Submersible 100 450 71 230,480 89,488 NaOCl (12 to 15%)
43 WELLPUMP Kirkwood Well Pump DWVerticalTurbine 40 300 66 156,356 97,955 NaOCl (12 to 15%)
44 WELLPUMP La Grange Well Pump DWVerticalTurbine 150 1,350 60 250,360 121,707 NaOCl <1%
45 WELLPUMP LicorIce Well Pump Submersible 15 190 62 79,514 35,406 NaOCl (12 to 15%)
46 WELLPUMP Logger Well Pump DWVerticalTurbine 150 700 67 297,400 127,342 NaOCl <1%
47 WELLPUMP Longmeadow Well Pump DWVerticalTurbine 50 250 50 9,680 - NaOCl (12 to 15%)
48 WELLPUMP MAC Well Pump DWVerticalTurbine 150 1,200 79 320,840 153,276 NaOCl (12 to 15%), PO4
49 WELLPUMP Maple Hill 1 Well Pump VSP DWVerticalTurbine 200 1,800 70 677,880 396,017 Green Sand, NaOCl <1%
50 WELLPUMP Maple Hill 2 Well Pump VSP DWVerticalTurbine 60 500 70 NaOCl <1% ASR
51 WELLPUMP Market Well Pump DWVerticalTurbine 125 700 69 87,320 33,190 NaOCl (12 to 15%) & ASR
52 WELLPUMP McMillan Well Pump DWVerticalTurbine 100 800 80 173,560 95,699 NaOCl (12 to 15%)
53 WELLPUMP Overland Well Pump DWVerticalTurbine 100 1,000 69 185,971 98,017 NaOCl <1% P04
54 WELLPUMP Paradise Well Pump Submersible 40 500 65 127,129 68,385 NaOCl (12 to 15%)
55 WELLPUMP Pioneer Well Pump DWVerticalTurbine 300 1,200 65 1,192,320 286,984 NaOCl <1%
56 WELLPUMP Pleasant Valley Well Pump DWVerticalTurbine 500 1,800 67 676,480 219,588 NaOCl <1%
57 WELLPUMP Raptor Well Pump DWVerticalTurbine 300 1,000 87 312,560 104,231 NaOCl (12 to 15%)
58 WELLPUMP Redwood Creek Well Pump VSP Submersible 200 1,800 65 47,440 13,805 NaOCl (12 to 15%)
59 WELLPUMP River Run Well VSP Submersible 100 900 65 49,800 31,011 NaOCl (12 to 15%)
60 WELLPUMP Roosevelt 1 Well Pump DWVerticalTurbine 50 700 55 311,700 250,085 NaOCl <1%, PO4
61 WELLPUMP Roosevelt 3 Well Pump DWVerticalTurbine 75 600 55 NaOCl <1%,PO4
December 31, 2019
Page 11 Detail Pumps & Boosters (Page 1 of 4)
PUC ANNUAL REPORT Page 11 - 4. All System Pumps (including Wells & Boosters)
SUEZ Water Idaho Inc
04/16/20
SITE # TYPE LOCATION PUMP TYPE HP
RATED
GPM DPSI KWH USED PRODUCTION Treatment
December 31, 2019
62 WELLPUMP Settlers Well Pump DWVerticalTurbine 100 1,000 56 52,203 28,557 NaOCl (12 to 15%) & ASR
63 WELLPUMP Sherman Oaks Well Pump N/A (Out of Service) -
64 WELLPUMP Spurwing Well Pump VSP DWVerticalTurbine 150 2,000 80 20,680 1 NaOCl (12 to 15%)
65 WELLPUMP Sunset West Well VSP DWVerticalTurbine 250 2,000 68 719,400 404,975 NaOCl <1%
66 WELLPUMP Swift 1 Well Pump VSP DWVerticalTurbine 125 1,100 66 215,520 126,449 NaOCl (12 to 15%) GAC & ASR
67 WELLPUMP Swift 2 Well Pump VSP DWVerticalTurbine 100 900 66 NaOCl (12 to 15%) GAC
68 WELLPUMP Taggart 1 Well Pump DWVerticalTurbine 50 300 55 536,960 254,819 NaOCl <1%
69 WELLPUMP Taggart 2 Well VSP DWVerticalTurbine 125 750 55 NaOCl <1%
70 WELLPUMP Ten Mile Well Pump DWVerticalTurbine 300 1,000 64 1,199,080 374,754 NaOCl <1%
71 WELLPUMP Terteling Well Pump Submersible 75 425 69 177,405 58,453 NaOCl (12 to 15%)
72 WELLPUMP Veterans Well Pump DWVerticalTurbine 75 740 60 332,520 201,822 NaOCL <1%
73 WELLPUMP Victory Well VSP DWVerticalTurbine 60 600 55 459,807 277,606 NaOCL <1%
74 WELLPUMP Vista Well Pump DWVerticalTurbine 75 450 50 275,000 116,650 NaOCl <1%, PO4
75 WELLPUMP Warm Springs Mesa 2 Well Pump DWVerticalTurbine 75 450 136 7,879 NaOCl (12 to 15%)
76 WELLPUMP Warm Springs Mesa 3 Well Pump DWVerticalTurbine 10 600 136 98,238 31,731 NaOCl (12 to 15%)
77 WELLPUMP Westmoreland Well Pump DWVerticalTurbine 50 350 50 32,481 16,623 NaOCL (12 to 15%)
78 WELLPUMP Willow 1 Well Pump DWVerticalTurbine 40 500 69 5,640 NaOCl (12 to 15%), PO4
79 WELLPUMP Willow 2 Well Pump DWVerticalTurbine 50 370 69 105,158 72,144 NaOCl (12 to 15%)
80 WELLPUMP Willow 3 Well Pump DWVerticalTurbine 40 300 69 NaOCl (12 to 15%)
COLUMBIA WTP COLUMBIA PUMP RIVER 3,350,404
83 Raw Water #1 Intake SS VTRB 500 2800 205
84 Raw Water #2 Intake SS VTRB 500 2800 205
85 Raw Water #3 Intake SS VTRB 500 2800 205
COLUMBIA TRTMNT PLANT 1,366,262 1,269,573 Membrane Filtration, NaOCl <1%
86 FINISHWATER Columbia WTP VSP 1 SS VTRB 75 1050 35
87 FINISHWATER Columbia WTP VSP 2 SS VTRB 75 1050 35
88 FINISHWATER Columbia WTP VSP 3 SS VTRB 200 2800 35
89 FINISHWATER Columbia WTP VSP 4 SS VTRB 200 2800 35
MARDEN WTP MARDEN TRTMNT PLANT 4,583,290 2,972,734 Conventional Filtration, NaOCl <1%
90 Raw Water #1 Ranney SUBM 50 1750 30
91 Raw Water #2 Ranney SUBM 40 1000 30
92 Raw Water #3 Ranney VSP SUBM 90 1800 30
93 Raw Water #1 Intake SS VTRB 15 1390 30
94 Raw Water #2 Intake VSP SS VTRB 30 2775 30
95 Raw Water #3 Intake SS VTRB 30 2775 30
96 Raw Water #4 Intake SS VTRB 25 2775 30
97 Raw Water #5 Intake SS VTRB 50 4166 30
98 FINISHWATER Marden WTP 710 VSP SS VTRB 150 2777 63
99 FINISHWATER Marden WTP 720 Pump SS VTRB 150 2777 63
100 FINISHWATER Marden WTP 730 Pump SS VTRB 250 4166 63
101 FINISHWATER Marden WTP 740 VSP SS VTRB 250 4166 63
102 FINISHWATER Marden WTP 750 Pump SS VTRB 300 4166 85
TOTAL PUMPS 12,695 122,013 6,478 29,694,069 14,718,588
SITE # TYPE LOCATION PUMP TYPE HP
RATED
GPM DPSI KWH USED PRODUCTION
1 BOOSTER 36th Street Booster #1 VSP SSVerticleTurbine 75 1,000 95 105,570
2 BOOSTER 36th Street Booster #2 VSP SSVerticleTurbine 75 1,000 95
3 BOOSTER Aeronca Booster Pump 1 End Suc Centrifugal 15 200 52 19,122
4 BOOSTER Aeronca Booster Pump 2 End Suc Centrifugal 50 800 52
5 BOOSTER Arctic Booster SSVerticleTurbine 40 2,500 80 95,210
6 BOOSTER Arrowhead 1 Booster #1 VSP SSVerticleTurbine 40 450 50 85,030
7 BOOSTER Arrowhead 1 Booster #2 VSP SSVerticleTurbine 40 450 50
8 BOOSTER Arrowhead 1 Booster #3 VSP SSVerticleTurbine 50 900 50
9 BOOSTER Arrowhead 2 Booster #1 VSP SSVerticleTurbine 40 450 95 115,380
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 Centrifugal 150 1,500 90 77,200
Page 11 Detail Pumps & Boosters (Page 2 of 4)
PUC ANNUAL REPORT Page 11 - 4. All System Pumps (including Wells & Boosters)
SUEZ Water Idaho Inc
04/16/20
SITE # TYPE LOCATION PUMP TYPE HP
RATED
GPM DPSI KWH USED PRODUCTION Treatment
December 31, 2019
13 BOOSTER Barber Booster Pump 2 End Suc Centrifugal 150 1,500 90
14 BOOSTER Bluffs Booster #1 - RETIRED End Suc Centrifugal 7.5 150 75
15 BOOSTER Bluffs Booster #2 - RETIRED End Suc Centrifugal 25 500 75
16 BOOSTER Bluffs Booster #3 - RETIRED End Suc Centrifugal 25 500 75
17 BOOSTER Boise Avenue Pump VSP End Suc Centrifugal 30 1,000 72 7,646
18 BOOSTER Boulder Booster #1 VSP End Suc Centrifugal 15 250 60 90,472
19 BOOSTER Boulder Booster #2 End Suc Centrifugal 15 250 60
20 BOOSTER Boulder Booster #3 VSP End Suc Centrifugal 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 151,640
23 BOOSTER Braemere Booster #2 VSP SSVerticleTurbine 75 1,000 83
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 Centrifugal 75 900 150 149,320
27 BOOSTER Briarhill Booster #2 VSP End Suc Centrifugal 75 900 150
28 BOOSTER Briarhill Booster #3 VSP End Suc Centrifugal 75 900 150
29 BOOSTER Broken Horn Booster #1 VSP SSVerticleTurbine 125 1,000 165 140,800
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 232,560
34 BOOSTER Brumback Booster #2 VSP End Suc Centrifugal 100 600 150
35 BOOSTER Cartwright Booster #1 VSP End Suc Centrifugal 60 325 120 136,960
36 BOOSTER Cartwright Booster #2 VSP End Suc Centrifugal 60 325 120
37 BOOSTER Council Springs Booster #1 VSP SSVerticleTurbine 60 465 165 38,687
38 BOOSTER Council Springs Booster #2 VSP SSVerticleTurbine 60 465 165
39 BOOSTER Crestline Booster #1 End Suc Centrifugal 40 420 90 60,771
40 BOOSTER Crestline Booster #2 End Suc Centrifugal 40 420 90
41 BOOSTER Federal Booster #1 In-line Centrifugal 100 1,500 60 101,760
42 BOOSTER Federal Booster #2 VSP In-line Centrifugal 100 1,500 60
43 BOOSTER Five Mile Booster VSP 1 SSVerticleTurbine 40 500 78 65,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 #1 VSP SSVerticleTurbine 100 4,500 25 150,320
47 BOOSTER Good Street Booster #2 SSVerticleTurbine 125 2,500 75
48 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 1 End Suc Centrifugal 40 1,000 66 15,973
51 BOOSTER Gowen Booster VSP 2 End Suc Centrifugal 50 1,500 66
52 BOOSTER Gowen Booster VSP 3 End Suc Centrifugal 25 340 66
53 BOOSTER Harris Ranch Booster #1 End Suc Centrifugal 10 300 65 38,501
54 BOOSTER Harris Ranch Booster #2 End Suc Centrifugal 30 700 65
55 BOOSTER Harris Ranch Booster #3 End Suc Centrifugal 30 700 65
56 BOOSTER Harvard Booster Pump 1 End Suc Centrifugal 20 350 85 18,149
57 BOOSTER Harvard Booster Pump 2 End Suc Centrifugal 20 350 85
58 BOOSTER Hidden Hollow 1 Pump SSVerticleTurbine 200 1,000 220 627,440
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 Highland View #1 VSP End Suc Centrifugal 40 600 67 22,760
62 BOOSTER Highland View #2 VSP End Suc Centrifugal 40 600 67
63 BOOSTER Highland View #3 End Suc Centrifugal 100 1,200 67
64 BOOSTER Hillcrest Booster VSP 1 SSVerticleTurbine 75 1,500 65 In 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,880
69 BOOSTER Hillsboro Booster #2 VSP SSVerticleTurbine 75 900 104
70 BOOSTER Hillsboro Booster #3 VSP End Suc Centrifugal 20 300 104
71 BOOSTER Hilo Booster VSP End Suc Centrifugal 50 800 105 3,726
72 BOOSTER Hulls Gulch #1 SSVerticleTurbine 125 900 178 471,840
73 BOOSTER Hulls Gulch #2 SSVerticleTurbine 125 900 178
Page 11 Detail Pumps & Boosters (Page 3 of 4)
PUC ANNUAL REPORT Page 11 - 4. All System Pumps (including Wells & Boosters)
SUEZ Water Idaho Inc
04/16/20
SITE # TYPE LOCATION PUMP TYPE HP
RATED
GPM DPSI KWH USED PRODUCTION Treatment
December 31, 2019
74 BOOSTER Hulls Gulch #3 SSVerticleTurbine 125 900 178
75 BOOSTER Lower Danmor Booster #1 VSP End Suc Centrifugal 75 900 135 246,160
76 BOOSTER Lower Danmor Booster #2 VSP End Suc Centrifugal 75 900 135
77 BOOSTER Lower Danmor Booster #3 VSP End Suc Centrifugal 75 900 135
78 BOOSTER Micron Booster VSP 1 End Suc Centrifugal 50 900 105 6,302
79 BOOSTER Micron Booster 2 End Suc Centrifugal 20 340 105
80 BOOSTER Micron Booster 3 End Suc Centrifugal 75 1,700 105
81 BOOSTER North Mountain #1 End Suc Centrifugal 15 250 88 29,002
82 BOOSTER North Mountain #2 End Suc Centrifugal 25 600 88
83 BOOSTER Old Pen Booster End Suc Centrifugal 15 300 70 9,504
84 BOOSTER Quail Booster #1 VSP SSVerticleTurbine 100 800 151 131,979
85 BOOSTER Quail Booster #2 VSP SSVerticleTurbine 100 800 151
86 BOOSTER Roger Heights 1 VSP End Suc Centrifugal 75 3,000 45 114,320
87 BOOSTER Roger Heights 2 Pump End Suc Centrifugal 75 3,000 45
88 BOOSTER Roger Heights 3 Pump End Suc Centrifugal 75 3,000 45
89 BOOSTER Somerset Booster 1 End Suc Centrifugal 25 200 166 In Roger Hts Bstr
90 BOOSTER Somerset Booster 2 End Suc Centrifugal 100 1,000 166
91 BOOSTER Steelhead Booster #1 End Suc Centrifugal 25 500 60 100,600
92 BOOSTER Steelhead Booster #2 VSP End Suc Centrifugal 60 1,500 60
93 BOOSTER Steelhead Booster #3 End Suc Centrifugal 100 2,500 60
94 BOOSTER Sunview Booster End Suc Centrifugal 60 750 101 16,648
95 BOOSTER Technology Booster VSP SSVerticleTurbine 40 800 83 1,121
96 BOOSTER Toluka Booster #1 VSP End Suc Centrifugal 50 500 81 152,760
97 BOOSTER Toluka Booster #2 VSP End Suc Centrifugal 50 500 81
98 BOOSTER Toluka Booster #3 VSP End Suc Centrifugal 50 500 81
99 BOOSTER Upper Danmor Booster #1 In-line Centrifugal 50 300 104 172,720
100 BOOSTER Upper Danmor Booster #2 In-line Centrifugal 50 300 104
101 BOOSTER Upper Danmor Booster #3 VSP End Suc Centrifugal 150 1,200 104
102 BOOSTER Ustick Booster #1 End Suc Centrifugal 75 1,500 65 120,720
103 BOOSTER Ustick Booster #2 End Suc Centrifugal 75 1,500 65
104 BOOSTER Ustick Booster #3 VSP End Suc Centrifugal 30 500 65
105 BOOSTER Warm Springs Booster #1 VSP End Suc Centrifugal 100 600 155 145,600
106 BOOSTER Warm Springs Booster #2 VSP End Suc Centrifugal 100 600 155
TOTAL BOOSTERS 7,243 104,600 10,221 4,329,233
TOTAL PUMPS & BOOSTERS 19,938 226,613 16,699 34,023,302 14,718,588
Asterisk facilities added this year
Annual Report on Deferred Power Cost will show 34,023,344 kWh, 42 kwh difference due to Byrd well out of service but small building heat usage.
Page 11 Detail Pumps & Boosters (Page 4 of 4)
Name: SUEZ Water Idaho Inc
SYSTEM ENGINEERING DATA
(continued)
For Year Ended:
FEET OF MAINS
In Use Installed Abandoned GIS Adjustments In Use
1 Pipe Beginning During During During End of
Size of Year Year Year Year * Year
36" 553 (226) 327
30" 11,265 (10,392) 873
24" 80,622 366 (657) 80,330
20" 10,091 (48) 10,043
18" 3,385 0 3,385
16" 260,574 4,211 (144) (1,473) 263,168
14" 9,293 (148) 9,145
12" 1,606,288 20,684 (6,150) (12,838) 1,607,983
10" 51,207 27 (803) (1,770) 48,662
8" 3,019,659 48,504 (2,483) (8,720) 3,056,959
6" 1,515,726 374 (3,603) (5,197) 1,507,299
4" 206,013 851 (1,034) (1,532) 204,298
3" 5,495 28 (158) (261) 5,104
2", 2.5" 152,525 751 (843) (1,037) 151,395
3/4", 1", 1.25", 1.5" 5,068 (159) 4,909
TOTAL 6,937,764 75,794 (15,219) (44,458) 6,953,881
MILES 1,317.02
CUSTOMER STATISTICS
Number of Customers Thousands of Gallons Sold
This Last This Last
Year Year Year Year
2 Metered:
2A Residential 85,414 84,015 8,801,467 9,388,249
2B Commercial 9,350 9,239 4,774,959 5,109,913
2C Industrial
3 Flat Rate:
3A Residential
3B Commercial
3C Industrial
4 Private Fire Protection: 2,207 2,136
5 Public Fire Protection:
6 Street Sprinkling (included in other)
7 Municipal, Other 58 59 48,608 57,216
8 Other Water
TOTALS (Add lines 2 through 8) 97,029 95,449 13,625,035 14,555,378
December 31, 2019
* GIS adjustments include reclassifications and data corrections. In 2019, 30" reclassified as Production Facility pipe
rather than Distribution pipe.
Page 12
Report ID: RLREG060
Layout ID: RLREG060
SUEZ Water Idaho
Business Unit: 00060 General Ledger System
Period Ending: Dec 31, 2019 Rolling Regulatory I/S
Run on 04/17/20 at 02:30 PM
12
Months
Ending
Current Year
Months
Ending
Prior Year
Increase /
(Decrease)
TOTAL_OPERATING_REVENUE
400 - Total Revenue
460.0-Unmetered Water Revenue 0.00 0.00 0.00
40105461 20,088,784.90 21,857,647.48 (1,768,862.58)
40106461 Meter Sale-Residential facili 10,939,918.52 11,263,758.77 (323,840.25)
461.1-Residential 31,028,703.42 33,121,406.25 (2,092,702.83)
40110461 10,730,629.56 11,719,377.95 (988,748.39)
40111461 Meter Sale-Commercial facility 2,344,819.86 2,441,629.23 (96,809.37)
40136461 87,740.62 122,740.46 (34,999.84)
40137461 115,857.83 91,238.49 24,619.34
461.2-Commercial 13,279,047.87 14,374,986.13 (1,095,938.26)
40140462 Private Fire protection facili 1,100,656.88 1,131,011.77 (30,354.89)
462.0-Fire Protect Rev-Private 1,100,656.88 1,131,011.77 (30,354.89)
40120461 114,495.43 136,371.24 (21,875.81)
40121461 Meter Sale-public auth fac 30,783.05 35,323.52 (4,540.47)
40130474 Surcharges 49,762.43 98,739.54 (48,977.11)
40145463 Public Fire protection facilit 3,535.94 3,535.94 0.00
40200471 Miscellaneous service revenue 17,474.15 16,610.00 864.15
40205472 Rents from water property 0.00 1,992.09 (1,992.09)
40245471 Turn on fees 27,870.00 14,745.00 13,125.00
40300474 199,153.00 (308,268.00)507,421.00
40301474 Reg Unbill facility charge rev 210,664.00 (121,368.00)332,032.00
464.0-Other Revenue 653,738.00 (122,318.67)776,056.67
400 - Total Revenue 46,062,146.17 48,505,085.48 (2,442,939.31)
Total Operating Revenue 46,062,146.17 48,505,085.48 (2,442,939.31)
TOTAL OPERATING EXPENSES
50100600 Supv Lbr-SOS Ops Sup & Eng 30,397.92 33,733.98 3,336.06
50100601 Supv Lbr-SOS Ops Lbr & Exp 54,561.33 66,621.66 12,060.33
50100603 Supv Lbr-SOS Ops Misc 2,336.51 2,877.43 540.92
50100610 1,254.69 0.00 (1,254.69)
50100611 Supv Lbr-SOS Maint Strctrs 0.00 846.15 846.15
50100614 Supv Lbr-SOS Maint Wlls&Spr 32,686.18 (63,377.07)(96,063.25)
50100620 12,917.85 12,230.43 (687.42)
50100622 17,565.53 0.00 (17,565.53)
50100624 Supv Lbr-Pump Ops Lbr & Exp 101,439.24 94,697.69 (6,741.55)
50100630 10,442.29 7,033.54 (3,408.75)
50100631 Supv Lbr-Pump Maint Strctrs 1,672.92 0.00 (1,672.92)
50100633 Supv Lbr-Pump Maint Equip 0.00 418.23 418.23
50100640 18,444.05 16,893.58 (1,550.47)
50100642 58,257.89 44,023.93 (14,233.96)
50100660 Supv Lbr-T&D Ops Sup&Eng 39,597.70 22,827.20 (16,770.50)
50100662 Supv Lbr-T&D Ops Line Exp 2,439.11 46,979.25 44,540.14
50100670 Supv Lbr-T&D Maint Sup &Eng 5,943.29 4,024.09 (1,919.20)
50100671 Supv Lbr-T&D Maint Strctrs 830.77 0.00 (830.77)
50100672 775.38 0.00 (775.38)
50100673 Supv Lbr-T&D Maint - Main 7,327.83 10,422.92 3,095.09
50100675 Supv Lbr-T&D Maint - Services 8,192.47 0.00 (8,192.47)
50105600 Drct Lbr-SOS Ops Sup & Eng 3,913.99 (861.71)(4,775.70)
50105603 Drct Lbr-SOS Ops Misc 0.00 243.00 243.00
50105611 Drct Lbr-SOS Maint Strctrs 27,302.20 31,954.90 4,652.70
50105622 1,228.96 8,005.04 6,776.08
50105624 Drct Lbr-Pump Ops Lbr & Exp 500,444.09 473,167.88 (27,276.21)
50105630 Drct Lbr-Pump Maint Sup&Eng 0.00 248.80 248.80
50105631 Drct Lbr-Pump Maint Strctrs 13,293.32 16,669.04 3,375.72
50105633 Drct Lbr-Pump Maint Equip 205,414.96 191,495.52 (13,919.44)
50105642 Drct Lbr-Wtr Tmt Ops Lbr&Exp 442,486.92 385,292.50 (57,194.42)
50105643 Drct Lbr-Wtr Tmt Ops Misc Exp 0.00 1,968.00 1,968.00
50105651 Drct Lbr-Wtr Tmt Maint Strct 34,415.98 34,413.66 (2.32)
Page 1 of 7
Layout ID: RLREG060
SUEZ Water Idaho
Business Unit: 00060 General Ledger System
Period Ending: Dec 31, 2019 Rolling Regulatory I/S
Run on 04/17/20 at 02:30 PM
12
Months
Ending
Current Year
Months
Ending
Prior Year
Increase /
(Decrease)
50105652 Drct Lbr-Wtr Tmt Maint Equip 57,242.05 49,317.95 (7,924.10)
50105660 Drct Lbr-T&D Ops Sup&Eng 0.00 (190.74)(190.74)
50105662 Drct Lbr-T&D Ops Line Ex 465,731.56 393,519.01 (72,212.55)
50105663 Drct Lbr-T&D Ops Meter Exp 172,038.06 158,617.93 (13,420.13)
50105664 Drct Lbr-T&D Ops Cust instl 0.00 180.19 180.19
50105665 Drct Lbr-T&D Ops Misc Ex 77,360.97 64,177.51 (13,183.46)
50105671 Drct Lbr-T&D Maint Strctrs 295.11 36.83 (258.28)
50105672 Drct Lbr-T&D Maint Rsrvrs&Stn 511.38 612.48 101.10
50105673 Drct Lbr-T&D Maint - Main 250,444.72 251,139.86 695.14
50105675 Drct Lbr-T&D Maint - Services 178,084.87 140,879.09 (37,205.78)
50105676 Drct Lbr-T&D Maint - Meters 22,683.20 33,607.70 10,924.50
50105677 Drct Lbr-T&D Maint - Hydrants 29,786.66 11,727.38 (18,059.28)
50110600 S L T-SOS Ops Sup & Eng 13,354.85 6,182.34 (7,172.51)
50110603 S L T-SOS Ops Misc 0.00 48.93 48.93
50120614 S L T out-SOS Maint Wlls&Spr 0.00 82,284.00 82,284.00
50120624 S L T out-Pump Ops Lbr & Exp (1,065.81)2,521.54 3,587.35
50120660 S L T out-T&D Ops Sup&Eng (254.91)(1,857.25)(1,602.34)
50125664 D L T out-T&D Ops Cust instl 0.00 (180.19)(180.19)
50125665 D L T out-T&D Ops Misc Ex (62,068.00)(63,996.91)(1,928.91)
50125675 D L T out-T&D Maint - Services (722.04)0.00 722.04
601.1-6 - Labor - Oper & Maint 2,839,006.04 2,571,477.29 (267,528.75)
50100901 Supv Lbr-Cust Acct Suprvsn 77,615.27 106,267.83 28,652.56
50100903 Supv Lbr-Cust Acct Rcrds&Coll 137,222.63 93,316.46 (43,906.17)
50105901 Drct Lbr-Cust Acct Suprvsn 0.00 189.72 189.72
50105902 Drct Lbr-Cust Acct Mtr Rdng 322,125.52 301,678.82 (20,446.70)
50105903 Drct Lbr-Cust Acct Rcrds&Coll 649,090.64 601,374.71 (47,715.93)
50105904 Drct Lbr-Custr Acct Uncoll 1,165.50 0.00 (1,165.50)
50105910 Drct Lbr-Sales Exp Ops 66.01 0.00 (66.01)
50120901 S L T out-Cust Acct Suprvsn 277.41 (548.27)(825.68)
50120903 S L T out-Cust Acct Rcrds&Coll 0.00 564.00 564.00
50125903 776.19 (952.68)(1,728.87)
601.7-Labor Cust Accounts 1,188,339.17 1,101,890.59 (86,448.58)
50100920 Supv Lbr-A&G Ops Salaries 2,027,788.67 2,053,175.60 25,386.93
50100930 Supv Lbr-A&G Misc Gen Exp 3,704.72 0.00 (3,704.72)
50100932 Supv Lbr-A&G Maint Plnt 4,114.40 4,510.58 396.18
50105920 Drct Lbr-A&G Ops Salaries 1,049,570.10 1,027,494.60 (22,075.50)
50105932 Drct Lbr-A&G Maint Plnt 1,400.04 2,915.89 1,515.85
50120920 S L T out-A&G Ops Salaries (1,213,822.80) (1,183,151.28)30,671.52
50125920 D L T out-A&G Ops Salaries (1,003,108.09)(982,179.46)20,928.63
601.8-Labor - Admin & General 869,647.04 922,765.93 53,118.89
90950000 F B T-ES (2,745,737.98) (3,154,316.61)(408,578.63)
90950600 F B T-SOS Ops Sup & Eng 19,216.32 18,078.34 (1,137.98)
90950601 F B T-SOS Ops Lbr & Exp 21,238.20 31,370.06 10,131.86
90950603 F B T-SOS Ops Misc 1,299.49 1,736.79 437.30
90950610 F B T-SOS Maint Sup & Eng 654.89 0.00 (654.89)
90950611 F B T-SOS Maint Strctrs 9,723.11 14,368.39 4,645.28
90950614 F B T-SOS Maint Wlls&Spr 11,634.82 11,514.64 (120.18)
90950620 F B T-Pump Ops Sup & Eng 5,023.24 5,927.71 904.47
90950622 F B T-Pump Ops Pwr Prd Lbr 6,259.44 3,866.99 (2,392.45)
90950624 F B T-Pump Ops Lbr & Exp 224,303.19 276,690.26 52,387.07
90950630 F B T-Pump Maint Sup&Eng 3,929.27 3,460.63 (468.64)
90950631 F B T-Pump Maint Strctrs 6,337.60 7,520.61 1,183.01
90950633 F B T-Pump Maint Eq 79,689.26 88,829.18 9,139.92
90950640 F B T-Wtr Tmt Ops Sup&Eng 7,103.79 8,058.26 954.47
90950642 F B T-Wtr Tmt Ops Lbr&Exp 197,490.00 203,954.65 6,464.65
90950643 F B T-Wtr Tmt Ops Misc Exp 0.00 1,026.75 1,026.75
90950651 F B T-Wtr Tmt Maint Strct 13,407.44 17,779.70 4,372.26
90950652 F B T-Wtr Tmt Maint Equip 22,927.48 23,342.19 414.71
90950660 F B T-T&D Ops Sup&Eng 13,810.99 8,570.51 (5,240.48)
90950662 F B T-T&D Ops Line Ex 183,645.08 207,763.17 24,118.09
90950663 F B T-T&D Ops Meter Exp 64,486.94 77,258.40 12,771.46
90950665 F B T-T&D Ops Misc Ex 5,732.10 79.53 (5,652.57)
90950670 F B T-T&D Maint Sup & Eng 2,267.72 1,835.61 (432.11)
90950671 F B T-T&D Maint Strctrs 436.71 6.90 (429.81)
Page 2 of 7
Layout ID: RLREG060
SUEZ Water Idaho
Business Unit: 00060 General Ledger System
Period Ending: Dec 31, 2019 Rolling Regulatory I/S
Run on 04/17/20 at 02:30 PM
12
Months
Ending
Current Year
Months
Ending
Prior Year
Increase /
(Decrease)
90950672 F B T-T&D Maint Rsrvrs&Stn 514.36 321.96 (192.40)
90950673 F B T-T&D Maint - Main 93,220.84 125,559.24 32,338.40
90950675 F B T-T&D Maint - Services 70,944.03 68,032.91 (2,911.12)
90950676 F B T-T&D Maint - Meters 10,231.82 15,280.00 5,048.18
90950677 F B T-T&D Maint - Hydrants 11,572.50 6,073.17 (5,499.33)
90950901 F B T-Cust Acct Suprvsn 27,266.21 39,901.85 12,635.64
90950902 F B T-Cust Acct Mtr Rdng 128,899.14 138,616.88 9,717.74
90950903 F B T-Cust Acct Rcrds&Coll 296,272.44 335,114.48 38,842.04
90950904 F B T-Custr Acct Uncoll 378.42 0.00 (378.42)
90950910 F B T -Sales Exp Ops 21.22 0.00 (21.22)
90950920 F B T-A&G Salaries 335,499.82 399,023.75 63,523.93
90950930 F B T-A&G Misc 1,497.25 0.00 (1,497.25)
90950932 F B T-A&G Maint Plnt 2,324.01 3,402.69 1,078.68
91500926 Pension-A&G Ops 501,660.00 1,259,050.00 757,390.00
91550926 181,146.01 (232,811.99)(413,958.00)
91700926 1,304,038.97 1,276,385.32 (27,653.65)
91800926 252,680.77 212,568.49 (40,112.28)
91850000 Other Employee Benefits-ES 10,129.11 3,247.09 (6,882.02)
91850926 0.00 (2,353.09)(2,353.09)
91860926 17,141.34 3,952.57 (13,188.77)
604.0-Employee Pension&Benefit 1,400,317.36 1,510,087.99 109,770.62
50605602 Prchsd Wtr-SOS Ops 159,956.31 168,466.35 8,510.04
610.0-Purchased Water 159,956.31 168,466.35 8,510.04
50610623 1,928,449.28 1,998,599.30 70,150.02
50610624 8,039.16 0.00 (8,039.16)
50610643 Prchsd Pwr-Wtr Tmt Ops Misc 183.38 0.00 (183.38)
50610665 Prchsd Pwr-T&D Ops Misc Ex 421,988.86 412,688.33 (9,300.53)
50610921 0.00 0.00 0.00
615.0-Purchased Power 2,358,660.68 2,411,287.63 52,626.95
50635614 Chmcals-SOS Maint Wlls&Spr 27,191.58 16,397.27 (10,794.31)
50635626 Chmcals-Pump Ops Misc Exp 829.38 0.00 (829.38)
50635640 785.33 0.00 (785.33)
50635641 370,729.40 319,387.62 (51,341.78)
50635642 6,209.70 0.00 (6,209.70)
50635651 Chmcals-Wtr Tmt Maint Strctrs 1,325.90 0.00 (1,325.90)
50635652 Chmcals-Wtr Tmt Maint Equip 26.47 0.00 (26.47)
50635921 0.00 0.00 0.00
618.0-Chemicals 407,097.76 335,784.89 (71,312.87)
50300600 Material-SOS Ops Sup & Eng 599.31 0.00 (599.31)
50300611 Material-SOS Maint Strctrs 26,862.82 22,167.13 (4,695.69)
50300624 Material-Pump Ops Lbr & Exp 11,061.86 36,631.20 25,569.34
50300630 Material-Pump Maint Sup&Eng 70.00 0.00 (70.00)
50300631 Material-Pump Maint Strctrs 1,951.15 179.93 (1,771.22)
50300632 Material-Pump Maint Pwr Prd 1,029.98 3,349.20 2,319.22
50300633 Material-Pump Maint Eq 40,408.50 8,787.97 (31,620.53)
50300640 695.95 0.00 (695.95)
50300642 Material-Wtr Tmt Ops Lbr&Exp 34,082.86 45,110.41 11,027.55
50300651 Material-Wtr Tmt Maint Strct 14,409.75 3,966.96 (10,442.79)
50300652 Material-Wtr Tmt Maint Equip 7,986.11 0.00 (7,986.11)
50300660 Material-T&D Ops Sup&Eng 289.65 0.00 (289.65)
50300662 Material-T&D Ops Line Ex 1,122.48 10,826.05 9,703.57
50300663 Material-T&D Ops Meter Exp 658.21 0.00 (658.21)
50300665 Material-T&D Ops Misc Ex 2,888.13 568.14 (2,319.99)
50300672 178.19 0.00 (178.19)
50300673 Material-T&D Maint - Main 24,987.18 18,051.62 (6,935.56)
50300675 Material-T&D Maint - Services 26,552.67 77,604.32 51,051.65
50300676 Material-T&D Maint - Meters 18.84 70.99 52.15
50300677 Material-T&D Maint - Hydrants 8,407.93 12,579.70 4,171.77
620.1-6 Mat &Supply-Oper&Maint 204,261.57 239,893.62 35,632.05
50300902 Material-Cust Acct Mtr Rdng 2,136.65 438.61 (1,698.04)
50300903 Material-Cust Acct Rcrds&Coll 78.40 0.00 (78.40)
50300930 Material-A&G Ops-Misc Gen 39.20 0.00 (39.20)
50300932 Material-A&G Maint Plnt 11,752.34 0.00 (11,752.34)
620.7-8-Mat&Supp-A&G:Cust Care 14,006.59 438.61 (13,567.98)
Page 3 of 7
Layout ID: RLREG060
SUEZ Water Idaho
Business Unit: 00060 General Ledger System
Period Ending: Dec 31, 2019 Rolling Regulatory I/S
Run on 04/17/20 at 02:30 PM
12
Months
Ending
Current Year
Months
Ending
Prior Year
Increase /
(Decrease)
90850923 3,814,660.35 4,643,872.27 829,211.92
631-34-Contract Services-Prof 3,814,660.35 4,643,872.27 829,211.92
50400601 Out Servs-SOS Ops Lbr & Exp 1,676.12 1,097.68 (578.44)
50400603 Out Servs-SOS Ops Misc (1,300.00)1,300.00 2,600.00
50400612 0.00 37.76 37.76
50400613 2,500.00 3,250.00 750.00
50400624 3,041.20 4,629.02 1,587.82
50400626 Out Servs-Pump Ops Misc Exp 0.00 1,930.99 1,930.99
50400631 Out Servs-Pump Maint Strctrs 9,450.11 0.00 (9,450.11)
50400632 Out Servs-Pump Maint Pwr Prd 76,205.54 49,681.07 (26,524.47)
50400633 Out Servs-Pump Maint Eq 24,033.06 22,624.29 (1,408.77)
50400635 Out Servs-Wtr Tmt Lab Testing 121,606.20 100,908.40 (20,697.80)
50400641 Out Servs-Wtr Tmt 0.00 630.00 630.00
50400642 102.07 0.00 (102.07)
50400643 17,331.30 19,398.79 2,067.49
50400651 Out Servs-Wtr Tmt Maint Strct 11,346.59 18,857.43 7,510.84
50400652 Out Servs-Wtr Tmt Maint Equip 28,559.00 23,627.00 (4,932.00)
50400662 Out Servs-T&D Ops Line Ex 38,509.80 34,825.94 (3,683.86)
50400663 Out Servs-T&D Ops Meter Exp 735.00 0.00 (735.00)
50400665 Out Servs-T&D Ops Misc Ex 545.00 0.00 (545.00)
50400672 500.00 8,599.00 8,099.00
50400673 Out Servs-T&D Maint - Main 5,102.95 0.00 (5,102.95)
50400675 1,617.23 4,760.89 3,143.66
50400676 Out Servs-T&D Maint - Meters 430.00 0.00 (430.00)
50400677 974.27 0.00 (974.27)
50400902 Out Servs-Cust Acct Mtr Rdng 75,714.19 93,018.26 17,304.07
50400903 86,972.48 87,505.92 533.44
50400905 Out Servs-Cust Acct Misc Exp 10,793.36 500.15 (10,293.21)
50400920 27,410.97 37,305.62 9,894.65
50400921 (185.00)6,913.27 7,098.27
50400923 Out Servs-A&G Ops 85,583.81 47,530.85 (38,052.96)
50400932 Out Servs-A&G Maint Plnt 5,349.76 0.00 (5,349.76)
50405903 Print & Postage-Cust Acct Rcrd 298,432.23 280,532.78 (17,899.45)
636-Contract Other - Prof 933,037.24 849,465.11 (83,572.13)
50310604 Rent-SOS Ops 1,257.89 1,268.61 10.72
50310633 Rent-Pump Maint Eq 167.56 0.00 (167.56)
50310642 Rent-Wtr Tmt Ops Lbr&Exp 92.22 0.00 (92.22)
50310921 Rent-A&G Ops Off Suppl&Exp 11,149.20 11,278.17 128.97
50310931 Rent-A&G Ops 173.69 0.00 (173.69)
641-42-Rentals -Property&Equip 12,840.56 12,546.78 (293.78)
50645000 Trnsprt Cst-ES 844,948.88 836,921.27 (8,027.61)
50645600 5,097.14 4,361.91 (735.23)
50645601 5,665.08 7,166.01 1,500.93
50645603 Trnsprt Cst-SOS Ops Misc 344.89 377.93 33.04
50645610 182.86 0.00 (182.86)
50645611 Trnsprt Cst-SOS Maint Strctrs 2,562.17 3,362.97 800.80
50645614 3,028.61 2,544.17 (484.44)
50645620 1,333.41 1,385.23 51.82
50645622 1,833.75 797.52 (1,036.23)
50645624 59,924.70 64,180.10 4,255.40
50645630 1,043.57 847.41 (196.16)
50645631 Trnsprt Cst-Pump Maint Strctrs 1,512.35 1,632.50 120.15
50645633 Trnsprt Cst-Pump Maint Eq 21,546.98 20,401.97 (1,145.01)
50645640 1,890.71 1,901.26 10.55
50645642 52,981.74 47,597.04 (5,384.70)
50645643 Trnsprt Cst-Wtr Tmt Ops Misc 0.00 359.81 359.81
50645651 Trnsprt Cst-Wtr Tmt Maint Strc 3,437.91 4,218.34 780.43
50645652 Trnsprt Cst-Wtr Tmt Maint Eq 6,027.50 5,358.72 (668.78)
50645660 Trnsprt Cst-T&D Ops Sup&Eng 3,562.57 1,754.94 (1,807.63)
50645662 Trnsprt Cst-T&D Ops Line Ex 48,487.19 48,186.59 (300.60)
50645663 17,288.35 18,010.73 722.38
50645665 Trnsprt Cst-T&D Ops Misc Ex 1,412.75 17.55 (1,395.20)
50645670 613.88 452.35 (161.53)
50645671 Trnsprt Cst-T&D Maint Strctrs 111.56 3.24 (108.32)
Page 4 of 7
Layout ID: RLREG060
SUEZ Water Idaho
Business Unit: 00060 General Ledger System
Period Ending: Dec 31, 2019 Rolling Regulatory I/S
Run on 04/17/20 at 02:30 PM
12
Months
Ending
Current Year
Months
Ending
Prior Year
Increase /
(Decrease)
50645672 156.00 77.30 (78.70)
50645673 Trnsprt Cst-T&D Maint - Main 25,726.14 29,308.41 3,582.27
50645675 19,326.21 15,851.76 (3,474.45)
50645676 Trnsprt Cst-T&D Maint - Meters 2,825.27 3,648.09 822.82
50645677 3,132.44 1,375.30 (1,757.14)
50645901 Trnsprt Cst-Cust Acct Suprvsn 7,239.88 8,883.96 1,644.08
50645902 Trnsprt Cst-Cust Acct Mtr Rdng 34,519.76 32,734.09 (1,785.67)
50645903 79,252.59 78,034.83 (1,217.76)
50645904 Trnsprt Cst-Custr Acct Uncolle 64.73 0.00 (64.73)
50645910 Trnsprt Cst-Sales Exp Ops 4.86 0.00 (4.86)
50645920 Trnsprt Cst-A&G Salaries 90,399.92 90,930.18 530.26
50645930 Trnsprt Cst-A&G Misc 350.84 0.00 (350.84)
50645932 Trnsprt Cst-A&G Maint Plnt 562.36 760.30 197.94
50646000 Transportation Cost -Trnsfrred (844,948.88)(836,921.27)8,027.61
650.0-Transportation Expense 503,450.67 496,522.51 (6,928.16)
91400924 Liability Insurance-A&G Ops 100.00 757.72 657.72
91460925 (39,411.04)122,149.55 161,560.59
656-59- Insurance (39,311.04)122,907.27 162,218.31
660.0-Advertising 0.00 0.00 0.00
92000928 0.00 35,792.04 35,792.04
666.0-Reg Comm Exp - Amort 0.00 35,792.04 35,792.04
92050930 0.08 11,666.64 11,666.56
667-Reg Comm.Exp (Amort)0.08 11,666.64 11,666.56
90400904 286,324.18 254,940.75 (31,383.43)
90405904 85,711.00 71,000.00 (14,711.00)
670.0-Bad Debt Expenses 372,035.18 325,940.75 (46,094.43)
50620626 Utilities-Pump Ops Misc Exp 3,265.07 1,969.96 (1,295.11)
50620633 Utilities-Pump Maint Eq 2,218.40 1,454.85 (763.55)
50620651 Utilities-Wtr Tmt Maint Strct 2,053.34 (393,902.25)(395,955.59)
50620663 Utilities-T&D Ops Meter Exp 0.00 76.96 76.96
50620665 Utilities-T&D Ops Misc Exp 11,084.59 9,307.69 (1,776.90)
50620921 Utilities-A&G Ops Off Suppl 22,257.23 23,077.31 820.08
50620930 Utilities-A&G Misc 5,434.02 0.00 (5,434.02)
50625643 27,183.00 23,203.67 (3,979.33)
50625930 257.62 0.00 (257.62)
50650600 611.37 1,224.78 613.41
50650601 Office Exp-SOS Ops Lbr & Exp 0.00 250.00 250.00
50650603 Office Exp-SOS Ops Misc 108.50 3,442.90 3,334.40
50650610 0.00 1,812.60 1,812.60
50650624 701.80 0.00 (701.80)
50650626 40,921.26 40,925.87 4.61
50650633 Office Exp-Pump Maint Eq 1,792.69 0.00 (1,792.69)
50650642 808.39 0.00 (808.39)
50650650 Office Exp-Wtr Tmt Maint Sprv 1,800.00 0.00 (1,800.00)
50650651 Office Exp-Wtr Tmt Maint Strct 130.00 0.00 (130.00)
50650652 11,149.88 0.00 (11,149.88)
50650660 Office Exp-T&D Ops Sup&Eng 5,533.88 0.00 (5,533.88)
50650661 Office Exp-T&D Ops Strg Faclt 24,125.12 24,501.26 376.14
50650662 Office Exp-T&D Ops Line Ex 5,673.93 5,315.38 (358.55)
50650665 Office Exp-T&D Ops Misc Ex 2,417.43 3,424.28 1,006.85
50650670 0.00 556.50 556.50
50650673 Office Exp-T&D Maint - Main 168.50 0.00 (168.50)
50650675 Office Exp-T&D Maint-Services 2,666.82 0.00 (2,666.82)
50650902 Office Exp-Cust Acct Mtr Rdng 13.00 0.00 (13.00)
50650903 56,711.36 10,722.78 (45,988.58)
50650910 Office Exp - Sales Exp Ops 228.00 0.00 (228.00)
50650920 Office Exp-A&G Ops Salaries 23,873.27 0.00 (23,873.27)
50650921 Office Exp-A&G Ops Off Suppl 190,287.83 183,127.32 (7,160.51)
50650923 117,770.00 99,000.00 (18,770.00)
50650926 160.00 80.00 (80.00)
50650930 Office Exp-A&G Ops Misc Gen 152,458.65 151,948.53 (510.12)
50650932 Office Exp-A&G Maint Plnt 25,286.63 0.00 (25,286.63)
50651660 Advertising Exp-A&G 120,249.42 114,662.30 (5,587.12)
50655614 Misc Exp-SOS Maint Wlls&Spr 50.00 0.00 (50.00)
Page 5 of 7
Layout ID: RLREG060
SUEZ Water Idaho
Business Unit: 00060 General Ledger System
Period Ending: Dec 31, 2019 Rolling Regulatory I/S
Run on 04/17/20 at 02:30 PM
12
Months
Ending
Current Year
Months
Ending
Prior Year
Increase /
(Decrease)
50655631 Misc Exp-Pump Maint Strctrs 208,144.11 130,964.96 (77,179.15)
50655632 Misc Exp-Pump Maint Pwr Prd 761.00 419.76 (341.24)
50655651 Misc Exp-Wtr Tmt Maint Strct 8,402.15 10,631.91 2,229.76
50655662 Misc Exp-T&D Ops Line Ex 0.00 30.00 30.00
50655672 30.00 989.00 959.00
50655673 Misc Exp-T&D Maint - Main 0.00 25.00 25.00
50655675 Misc Exp-T&D Maint - Services 477.12 2,150.95 1,673.83
50655905 Misc Exp-Cust Acct Misc Exp (20.00)(20.30)(0.30)
50655930 Misc Exp-A&G Ops Misc Gen 0.00 114.19 114.19
92052930 11,725.80 11,725.80 0.00
92053672 55,768.75 55,768.76 0.01
92056930 0.00 11,052.00 11,052.00
92061623 0.00 257,652.00 257,652.00
92064930 40,209.57 37,956.12 (2,253.45)
92200620 987.08 0.00 (987.08)
92200624 774.08 0.00 (774.08)
92200626 0.00 1,173.16 1,173.16
92200632 102.69 0.00 (102.69)
92200633 Uni&Sfty Eq-Pump Maint Eq 2,747.32 0.00 (2,747.32)
92200642 198.21 0.00 (198.21)
92200652 Uni&Sfty Eq-Wtr Tmt Maint Eq 47.66 0.00 (47.66)
92200662 Uni&Sfty Eq-T&D Ops Line Ex 986.74 0.00 (986.74)
92200665 Uni&Sfty Eq-T&D Ops Misc Ex 130.63 0.00 (130.63)
92200673 Uni&Sfty Eq-T&D Maint - Main 605.20 0.00 (605.20)
92200675 5,238.95 0.00 (5,238.95)
92200902 295.39 0.00 (295.39)
92200903 3,142.12 0.00 (3,142.12)
92200921 39,053.34 0.00 (39,053.34)
92200930 37,410.61 81,135.18 43,724.57
92200932 Uni&Sfty Eq-A&G Maint Plnt 14,979.64 89.97 (14,889.67)
92300930 10,588.79 14,120.84 3,532.05
92600920 1,612.07 2,374.00 761.93
92600923 0.00 (0.65)(0.65)
92600930 (7,462.19)(6,222.02)1,240.17
92600932 35,881.63 45,542.26 9,660.63
675.0-Miscellaneous Other 1,332,269.46 963,855.58 (368,413.88)
Utility Operating Expenses 16,370,275.02 16,724,661.85 354,386.82
Total Expenses 16,370,275.02 16,724,661.85 354,386.82
Total Non-Operating Income
70100403 Depreciation - Utility Plant 9,553,786.91 9,826,188.36 (272,401.45)
403.0-Depreciation Expense 9,553,786.91 9,826,188.36 (272,401.45)
71255406 Amort of Util Plt Acquis Adj 20,712.00 20,712.00 0.00
406.0-Amort Util Plant Acq Adj 20,712.00 20,712.00 0.00
91900928 122,137.44 106,551.60 15,585.84
408.10-Regulatory Fees 122,137.44 106,551.60 15,585.84
70203408 Real Estate Tax 1,875,902.48 1,996,064.59 (120,162.11)
408.11-Property Taxes 1,875,902.48 1,996,064.59 (120,162.11)
70250408 Payroll Taxes 545,623.24 508,276.32 37,346.92
408.12-Payroll Taxes 545,623.24 508,276.32 37,346.92
408.13-Other Taxes 0.00 0.00 0.00
80100409 Current-federal 4,622,931.59 3,395,282.72 1,227,648.87
409.1-Income Taxes - Federal 4,622,931.59 3,395,282.72 1,227,648.87
80150409 Current-state 1,726,440.95 1,118,787.38 607,653.57
409.11-St Income Tax-Util Oper 1,726,440.95 1,118,787.38 607,653.57
80200410 (996,514.24)206,860.72 (1,203,374.96)
410.10-Prov Defer Inc Tax-Fed (996,514.24)206,860.72 (1,203,374.96)
80250410 Deferred-State Income taxes (1,025,963.95)46,446.32 (1,072,410.27)
410.11-Prov Def Inc Tax-State (1,025,963.95)46,446.32 (1,072,410.27)
80400411 Investment Tax Cr,amortization (48,240.00)(48,240.00)0.00
Page 6 of 7
Layout ID: RLREG060
SUEZ Water Idaho
Business Unit: 00060 General Ledger System
Period Ending: Dec 31, 2019 Rolling Regulatory I/S
Run on 04/17/20 at 02:30 PM
12
Months
Ending
Current Year
Months
Ending
Prior Year
Increase /
(Decrease)
412.0-Invest Tax Cred-Utility (48,240.00)(48,240.00)0.00
71200422 Gain - Disposition of Property (7,651.54)(16,905.00)9,253.46
414-Gain(Loss)from Dis of Util (7,651.54)(16,905.00)9,253.46
Total Non-Operating Income 16,389,164.88 17,160,025.01 (770,860.13)
Total Non-Operating Inc&Ded
415-Merchandise & Jobbing Inc 0.00 0.00 0.00
416-Merchandise & Jobbing Exp 0.00 0.00 0.00
71050419 AFUDC Gross Up (219,691.72)(139,895.88)(79,795.84)
71051419 AFUDC Debt (305,695.49)(155,436.85)(150,258.64)
71052419 AFUDC Equity (610,257.89)(310,904.34)(299,353.55)
420.0-Allow for Funds Used (1,135,645.10)(606,237.07)(529,408.03)
70900419 Interest income (43,428.43)(15,545.63)(27,882.80)
71250421 Misc non operating income 0.00 0.02 (0.02)
71251418 Misc Non Oper Rental Income (50,671.47)(52,197.97)1,526.50
421-Misc Non-Util Income (94,099.90)(67,743.58)(26,356.32)
71252426 Misc Income/Deduction 0.00 (1,437.48)1,437.48
71253426 Non Recoverable (1,436,110.93)(818,476.96)(617,633.97)
71257426 755,523.00 0.00 755,523.00
71258426 (433,785.02)0.00 (433,785.02)
90890426 18,621.87 305,399.26 (286,777.39)
426.0-Misc Non-Utility Expense (1,095,751.08)(514,515.18)(581,235.90)
Total Non-Operating Income & Deductions (2,325,496.08) (1,188,495.83)(1,137,000.25)
Total Interest Expenses
70800430 3,921,165.13 3,958,874.86 (37,709.73)
427.3-Int Exp on LongTerm Debt 3,921,165.13 3,958,874.86 (37,709.73)
71000431 Other interest (6,819.70)6,236.92 (13,056.62)
71010431 Other interest – Regulatory 7,283.24 0.00 7,283.24
427.5-Other Int Charges 463.54 6,236.92 (5,773.38)
Total Interest Expenses 3,921,628.67 3,965,111.78 (43,483.11)
Page 7 of 7
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
Assets
Total Assets
Net Utility Plant
10100000 Utility Plant in Service 460,627,776.05 439,595,052.55 (21,032,723.50)
10600000 Cnstrction Csts Not Classified 13,037,040.42 10,481,031.06 (2,556,009.36)
Utility Plant 473,664,816.47 450,076,083.61 (23,588,732.86)
11400000 Utility plant acquisition adj 600,761.18 600,761.18 0.00
11500000 Amort Utility Plant Acquis Adj (215,537.18) (194,825.18) 20,712.00
Net Utility Plant Acquist Adj 385,224.00 405,936.00 20,712.00
10800000 Utility Accumulated Depr (131,889,906.48) (123,759,460.11) 8,130,446.37
10810000 Retirement work in progress 702,249.30 553,106.15 (149,143.15)
10900000 Accumulated Cost of Removal 2,061,908.19 1,714,962.86 (346,945.33)
11100000 Utility Accumulated Depr -CIAC (41,551,014.80) (38,604,532.56) 2,946,482.24
Less Accumulated Depr & Amort (170,676,763.79) (160,095,923.66) 10,580,840.13
10700000 Construction work in progress 19,650,782.31 13,287,345.13 (6,363,437.18)
18300000 Prelim Survey and Inv. Chrgs 1,547,989.25 1,450,393.35 (97,595.90)
Construction Work in Progress 21,198,771.56 14,737,738.48 (6,461,033.08)
Plant Held for Future Use 0.00 0.00 0.00
Net Utility Plant 324,572,048.24 305,123,834.43 (19,448,213.81)
Net Right of Use Assets
Right of Use Assets 0.00 0.00 0.00
Less ROU Accum Amort 0.00 0.00 0.00
Net Right of Use Assets 0.00 0.00 0.00
Other Properties & Investments
Investments - LT Consol Comp 0.00 0.00 0.00
Investments - LT Non-Consol Co 0.00 0.00 0.00
Equity Investments 0.00 0.00 0.00
12100000 Non-Utility Property 11,053.83 11,053.83 0.00
Non-Utility Property & Equip 11,053.83 11,053.83 0.00
Depreciation Non-Utility Prop 0.00 0.00 0.00
Other Properties & Investments 11,053.83 11,053.83 0.00
Goodwill & Other Intangibles
Goodwill, net 0.00 0.00 0.00
Other Intangibles, Net 0.00 0.00 0.00
Goodwill & Other Intangibles 0.00 0.00 0.00
Total Current & Accrued Assets
13120000 Collections 41,000.00 41,000.00 0.00
13501000 Working Funds 550.00 550.00 0.00
Cash 41,550.00 41,550.00 0.00
Restricted Cash 0.00 0.00 0.00
14200000 Customer AR - CC&B 1,147,371.19 2,217,918.41 1,070,547.22
14201000 AR Cash Accrual (603,565.04) (807,523.89) (203,958.85)
14309000 Accounts Receivable-Other 0.00 8,895.61 8,895.61
14400000 Provision Uncllctble Acct (Cr) (467,711.00) (371,000.00) 96,711.00
14410000 Provision Uncllctble Acct-Othr 0.00 (11,000.00) (11,000.00)
17300000 Unbilled Revenue 3,395,680.00 2,985,863.00 (409,817.00)
Accounts Receivable - Customer 3,471,775.15 4,023,153.13 551,377.98
14605000 IC Money Pool Receivable 0.01 0.00 (0.01)
14606000 Utility Money Pool Receivable (1,781,976.18) 0.00 1,781,976.18
14610000 SW IC Receivable (net) (238,654.84) 0.00 238,654.84
A/R - Associated Companies (2,020,631.01) 0.00 2,020,631.01
A/R Affiliated Companies 0.00 0.00 0.00
Notes Receivable - Short Term 0.00 0.00 0.00
Run Date: 4/16/2020
Run Time: 4:20 PM Page 1 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
15000000 Capital&Maint Inv Nonexempt 114,228.07 101,305.22 (12,922.85)
15010000 Small Repairs Inventory Exempt 348,729.45 317,744.66 (30,984.79)
15020000 Other Inventory 62,064.79 60,635.56 (1,429.23)
15030000 Chemical Inventory 53,878.82 68,461.31 14,582.49
Materials & Supplies Inventory 578,901.13 548,146.75 (30,754.38)
16599000 Prepaid Expenses-Other 92,250.00 72,000.00 (20,250.00)
Prepaid Expenses 92,250.00 72,000.00 (20,250.00)
Dividends Receivable 0.00 0.00 0.00
Other Current Assets 0.00 0.00 0.00
Total Current & Accrued Assets 2,163,845.27 4,684,849.88 2,521,004.61
Non Current Assets
Unamortized Debt Discount/Exp 0.00 0.00 0.00
18609000 Deferred Emplyee Benefits-Othr 2,194,582.81 2,151,154.38 (43,428.43)
18620000 Deferred Tank Painting Expense 1,960,502.32 1,369,144.23 (591,358.09)
18621000 Dfrrd Relocation Exp - Approve 11,725.85 23,451.65 11,725.80
18623000 Deferred AFUDC Equity Gross Up 1,539,670.39 1,319,978.67 (219,691.72)
18625000 Deferred Pwr Costs - Approved 0.89 0.89 0.00
18650000 Reg Defrrd Tank Pnting - Amort (508,716.84) (452,948.09) 55,768.75
18653000 Dfrrd AFUDC Eq Gross-Up Amort. (368,717.44) (328,507.87) 40,209.57
18680000 Deferred rate charges (0.04) (0.04) 0.00
18698000 Other Reg Assets- Acquisitions 402,859.81 0.00 (402,859.81)
18699000 Other Regulatory Assets 10,948.00 164,221.06 153,273.06
Regulatory Assets 5,242,855.75 4,246,494.88 (996,360.87)
18714000 Deferred Power Costs - Pending 663,371.32 578,175.70 (85,195.62)
Other Deferred Charge & Assets 663,371.32 578,175.70 (85,195.62)
Notes Receivable - Long Term 0.00 0.00 0.00
18404000 Clearing - Capital Work Order (2.36) (1.72) 0.64
Clearing Accounts (2.36) (1.72) 0.64
Non Current Assets 5,906,224.71 4,824,668.86 (1,081,555.85)
Total Assets 332,653,172.05 314,644,407.01 (18,008,765.05)
Run Date: 4/16/2020
Run Time: 4:20 PM Page 2 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
Capitalization and Liabilities
Total Capital & Liabilities
Total Capitalization
Total Capital Stock
20100000 Common Stock Issued 1,261,750.00 1,261,750.00 0.00
20800000 Additional Paid-in Capital 82,146,318.89 81,437,834.97 (708,483.92)
Common Stock 83,408,068.89 82,699,584.97 (708,483.92)
Preferred Stock 0.00 0.00 0.00
Total Capital Stock 83,408,068.89 82,699,584.97 (708,483.92)
Total Retained Earnings
21600000 RE - Cumulated Income 104,603,957.44 94,168,736.78 (10,435,220.66)
Retained Earnings - beginning 104,603,957.44 94,168,736.78 (10,435,220.66)
80550000 Common Stock Dividend 0.00 (1,198,228.54) (1,198,228.54)
Common Stock Dividend 0.00 (1,198,228.54) (1,198,228.54)
Current Year Earnings
Income before Income Taxes
Operating Income
40105461 Meter Sale-Residential consump 20,088,784.90 21,857,647.48 1,768,862.58
40106461 Meter Sale-Residential facili 10,939,918.52 11,263,758.77 323,840.25
40110461 Meter Sale-Commercial consump 10,730,629.56 11,719,377.95 988,748.39
40111461 Meter Sale-Commercial facility 2,344,819.86 2,441,629.23 96,809.37
40120461 Meter Sale-public auth consump 114,495.43 136,371.24 21,875.81
40121461 Meter Sale-public auth fac 30,783.05 35,323.52 4,540.47
40130474 Surcharges 49,762.43 98,739.54 48,977.11
40136461 Meter Sale–Const Mtr–Consump 87,740.62 122,740.46 34,999.84
40137461 Meter Sale–Const Mtr–Fac Chgs 115,857.83 91,238.49 (24,619.34)
40140462 Private Fire protection facili 1,100,656.88 1,131,011.77 30,354.89
40145463 Public Fire protection facilit 3,535.94 3,535.94 0.00
40200471 Miscellaneous service revenue 17,474.15 16,610.00 (864.15)
40205472 Rents from water property 0.00 1,992.09 1,992.09
40245471 Turn on fees 27,870.00 14,745.00 (13,125.00)
40251474 ContraRev 2018portionTaxReform 0.00 (210,333.48) (210,333.48)
40300474 Reg Unbill consumption revenue 199,153.00 (308,268.00) (507,421.00)
40301474 Reg Unbill facility charge rev 210,664.00 (121,368.00) (332,032.00)
Total Operating Revenues 46,062,146.17 48,294,752.00 2,232,605.83
50100600 Supv Lbr-SOS Ops Sup & Eng (30,397.92) (33,733.98) (3,336.06)
50100601 Supv Lbr-SOS Ops Lbr & Exp (54,561.33) (66,621.66) (12,060.33)
50100603 Supv Lbr-SOS Ops Misc (2,336.51) (2,877.43) (540.92)
50100610 Supv Lbr-SOS Maint Sup & Eng (1,254.69) 0.00 1,254.69
50100611 Supv Lbr-SOS Maint Strctrs 0.00 (846.15) (846.15)
50100614 Supv Lbr-SOS Maint Wlls&Spr (32,686.18) 63,377.07 96,063.25
50100620 Supv Lbr-Pump Ops Sup & Eng (12,917.85) (12,230.43) 687.42
50100622 Supv Lbr-Pump Ops Pwr Prd Lbr (17,565.53) 0.00 17,565.53
50100624 Supv Lbr-Pump Ops Lbr & Exp (101,439.24) (94,697.69) 6,741.55
50100630 Supv Lbr-Pump Maint Sup&Eng (10,442.29) (7,033.54) 3,408.75
50100631 Supv Lbr-Pump Maint Strctrs (1,672.92) 0.00 1,672.92
50100633 Supv Lbr-Pump Maint Equip 0.00 (418.23) (418.23)
50100640 Supv Lbr-Wtr Tmt Ops Sup&Eng (18,444.05) (16,893.58) 1,550.47
50100642 Supv Lbr-Wtr Tmt Ops Lbr&Exp (58,257.89) (44,023.93) 14,233.96
50100660 Supv Lbr-T&D Ops Sup&Eng (39,597.70) (22,827.20) 16,770.50
50100662 Supv Lbr-T&D Ops Line Exp (2,439.11) (46,979.25) (44,540.14)
50100670 Supv Lbr-T&D Maint Sup &Eng (5,943.29) (4,024.09) 1,919.20
50100671 Supv Lbr-T&D Maint Strctrs (830.77) 0.00 830.77
50100672 Supv Lbr-T&D Maint Rsrvrs&Stn (775.38) 0.00 775.38
50100673 Supv Lbr-T&D Maint - Main (7,327.83) (10,422.92) (3,095.09)
Run Date: 4/16/2020
Run Time: 4:20 PM Page 3 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
50100675 Supv Lbr-T&D Maint - Services (8,192.47) 0.00 8,192.47
50100901 Supv Lbr-Cust Acct Suprvsn (77,615.27) (106,267.83) (28,652.56)
50100903 Supv Lbr-Cust Acct Rcrds&Coll (137,222.63) (93,316.46) 43,906.17
50100920 Supv Lbr-A&G Ops Salaries (2,027,788.67) (2,053,175.60) (25,386.93)
50100930 Supv Lbr-A&G Misc Gen Exp (3,704.72) 0.00 3,704.72
50100932 Supv Lbr-A&G Maint Plnt (4,114.40) (4,510.58) (396.18)
50105600 Drct Lbr-SOS Ops Sup & Eng (3,913.99) 861.71 4,775.70
50105603 Drct Lbr-SOS Ops Misc 0.00 (243.00) (243.00)
50105611 Drct Lbr-SOS Maint Strctrs (27,302.20) (31,954.90) (4,652.70)
50105622 Drct Lbr-Pump Ops Pwr Prd Lbr (1,228.96) (8,005.04) (6,776.08)
50105624 Drct Lbr-Pump Ops Lbr & Exp (500,444.09) (473,167.88) 27,276.21
50105630 Drct Lbr-Pump Maint Sup&Eng 0.00 (248.80) (248.80)
50105631 Drct Lbr-Pump Maint Strctrs (13,293.32) (16,669.04) (3,375.72)
50105633 Drct Lbr-Pump Maint Equip (205,414.96) (191,495.52) 13,919.44
50105642 Drct Lbr-Wtr Tmt Ops Lbr&Exp (442,486.92) (385,292.50) 57,194.42
50105643 Drct Lbr-Wtr Tmt Ops Misc Exp 0.00 (1,968.00) (1,968.00)
50105651 Drct Lbr-Wtr Tmt Maint Strct (34,415.98) (34,413.66) 2.32
50105652 Drct Lbr-Wtr Tmt Maint Equip (57,242.05) (49,317.95) 7,924.10
50105660 Drct Lbr-T&D Ops Sup&Eng 0.00 190.74 190.74
50105662 Drct Lbr-T&D Ops Line Ex (465,731.56) (393,519.01) 72,212.55
50105663 Drct Lbr-T&D Ops Meter Exp (172,038.06) (158,617.93) 13,420.13
50105664 Drct Lbr-T&D Ops Cust instl 0.00 (180.19) (180.19)
50105665 Drct Lbr-T&D Ops Misc Ex (77,360.97) (64,177.51) 13,183.46
50105671 Drct Lbr-T&D Maint Strctrs (295.11) (36.83) 258.28
50105672 Drct Lbr-T&D Maint Rsrvrs&Stn (511.38) (612.48) (101.10)
50105673 Drct Lbr-T&D Maint - Main (250,444.72) (251,139.86) (695.14)
50105675 Drct Lbr-T&D Maint - Services (178,084.87) (140,879.09) 37,205.78
50105676 Drct Lbr-T&D Maint - Meters (22,683.20) (33,607.70) (10,924.50)
50105677 Drct Lbr-T&D Maint - Hydrants (29,786.66) (11,727.38) 18,059.28
50105901 Drct Lbr-Cust Acct Suprvsn 0.00 (189.72) (189.72)
50105902 Drct Lbr-Cust Acct Mtr Rdng (322,125.52) (301,678.82) 20,446.70
50105903 Drct Lbr-Cust Acct Rcrds&Coll (649,090.64) (601,374.71) 47,715.93
50105904 Drct Lbr-Custr Acct Uncoll (1,165.50) 0.00 1,165.50
50105910 Drct Lbr-Sales Exp Ops (66.01) 0.00 66.01
50105920 Drct Lbr-A&G Ops Salaries (1,049,570.10) (1,027,494.60) 22,075.50
50105932 Drct Lbr-A&G Maint Plnt (1,400.04) (2,915.89) (1,515.85)
50110600 S L T-SOS Ops Sup & Eng (13,354.85) (6,182.34) 7,172.51
50110603 S L T-SOS Ops Misc 0.00 (48.93) (48.93)
50120614 S L T out-SOS Maint Wlls&Spr 0.00 (82,284.00) (82,284.00)
50120624 S L T out-Pump Ops Lbr & Exp 1,065.81 (2,521.54) (3,587.35)
50120660 S L T out-T&D Ops Sup&Eng 254.91 1,857.25 1,602.34
50120901 S L T out-Cust Acct Suprvsn (277.41) 548.27 825.68
50120903 S L T out-Cust Acct Rcrds&Coll 0.00 (564.00) (564.00)
50120920 S L T out-A&G Ops Salaries 1,213,822.80 1,183,151.28 (30,671.52)
50125664 D L T out-T&D Ops Cust instl 0.00 180.19 180.19
50125665 D L T out-T&D Ops Misc Ex 62,068.00 63,996.91 1,928.91
50125675 D L T out-T&D Maint - Services 722.04 0.00 (722.04)
50125903 D L T out-Cust Acct Rcrds&Coll (776.19) 952.68 1,728.87
50125920 D L T out-A&G Ops Salaries 1,003,108.09 982,179.46 (20,928.63)
50300600 Material-SOS Ops Sup & Eng (599.31) 0.00 599.31
50300611 Material-SOS Maint Strctrs (26,862.82) (22,167.13) 4,695.69
50300624 Material-Pump Ops Lbr & Exp (11,061.86) (36,631.20) (25,569.34)
50300630 Material-Pump Maint Sup&Eng (70.00) 0.00 70.00
50300631 Material-Pump Maint Strctrs (1,951.15) (179.93) 1,771.22
50300632 Material-Pump Maint Pwr Prd (1,029.98) (3,349.20) (2,319.22)
50300633 Material-Pump Maint Eq (40,408.50) (8,787.97) 31,620.53
Run Date: 4/16/2020
Run Time: 4:20 PM Page 4 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
50300640 Material-Wtr Tmt Ops Sup&Eng (695.95) 0.00 695.95
50300642 Material-Wtr Tmt Ops Lbr&Exp (34,082.86) (45,110.41) (11,027.55)
50300651 Material-Wtr Tmt Maint Strct (14,409.75) (3,966.96) 10,442.79
50300652 Material-Wtr Tmt Maint Equip (7,986.11) 0.00 7,986.11
50300660 Material-T&D Ops Sup&Eng (289.65) 0.00 289.65
50300662 Material-T&D Ops Line Ex (1,122.48) (10,826.05) (9,703.57)
50300663 Material-T&D Ops Meter Exp (658.21) 0.00 658.21
50300665 Material-T&D Ops Misc Ex (2,888.13) (568.14) 2,319.99
50300672 Material-T&D Maint Rsrvrs&Stn (178.19) 0.00 178.19
50300673 Material-T&D Maint - Main (24,987.18) (18,051.62) 6,935.56
50300675 Material-T&D Maint - Services (26,552.67) (77,604.32) (51,051.65)
50300676 Material-T&D Maint - Meters (18.84) (70.99) (52.15)
50300677 Material-T&D Maint - Hydrants (8,407.93) (12,579.70) (4,171.77)
50300902 Material-Cust Acct Mtr Rdng (2,136.65) (438.61) 1,698.04
50300903 Material-Cust Acct Rcrds&Coll (78.40) 0.00 78.40
50300930 Material-A&G Ops-Misc Gen (39.20) 0.00 39.20
50300932 Material-A&G Maint Plnt (11,752.34) 0.00 11,752.34
50310604 Rent-SOS Ops (1,257.89) (1,268.61) (10.72)
50310633 Rent-Pump Maint Eq (167.56) 0.00 167.56
50310642 Rent-Wtr Tmt Ops Lbr&Exp (92.22) 0.00 92.22
50310921 Rent-A&G Ops Off Suppl&Exp (11,149.20) (11,278.17) (128.97)
50310931 Rent-A&G Ops (173.69) 0.00 173.69
50400601 Out Servs-SOS Ops Lbr & Exp (1,676.12) (1,097.68) 578.44
50400603 Out Servs-SOS Ops Misc 1,300.00 (1,300.00) (2,600.00)
50400612 Out Servs-SOS Maint Cllct Rsvr 0.00 (37.76) (37.76)
50400613 Out Servs-SOS Maint Lke,Rvr&Ot (2,500.00) (3,250.00) (750.00)
50400624 Out Servs-Pump Ops Lbr & Exp (3,041.20) (4,629.02) (1,587.82)
50400626 Out Servs-Pump Ops Misc Exp 0.00 (1,930.99) (1,930.99)
50400631 Out Servs-Pump Maint Strctrs (9,450.11) 0.00 9,450.11
50400632 Out Servs-Pump Maint Pwr Prd (76,205.54) (49,681.07) 26,524.47
50400633 Out Servs-Pump Maint Eq (24,033.06) (22,624.29) 1,408.77
50400635 Out Servs-Wtr Tmt Lab Testing (121,606.20) (100,908.40) 20,697.80
50400641 Out Servs-Wtr Tmt 0.00 (630.00) (630.00)
50400642 Out Servs-Wtr Tmt Ops Lbr&Exp (102.07) 0.00 102.07
50400643 Out Servs-Wtr Tmt Ops Misc Exp (17,331.30) (19,398.79) (2,067.49)
50400651 Out Servs-Wtr Tmt Maint Strct (11,346.59) (18,857.43) (7,510.84)
50400652 Out Servs-Wtr Tmt Maint Equip (28,559.00) (23,627.00) 4,932.00
50400662 Out Servs-T&D Ops Line Ex (38,509.80) (34,825.94) 3,683.86
50400663 Out Servs-T&D Ops Meter Exp (735.00) 0.00 735.00
50400665 Out Servs-T&D Ops Misc Ex (545.00) 0.00 545.00
50400672 Out Servs-T&D Maint Rsrvrs&Stn (500.00) (8,599.00) (8,099.00)
50400673 Out Servs-T&D Maint - Main (5,102.95) 0.00 5,102.95
50400675 Out Servs-T&D Maint - Services (1,617.23) (4,760.89) (3,143.66)
50400676 Out Servs-T&D Maint - Meters (430.00) 0.00 430.00
50400677 Out Servs-T&D Maint - Hydrants (974.27) 0.00 974.27
50400902 Out Servs-Cust Acct Mtr Rdng (75,714.19) (93,018.26) (17,304.07)
50400903 Out Servs-Custr Acct Rcrds&Col (86,972.48) (87,505.92) (533.44)
50400905 Out Servs-Cust Acct Misc Exp (10,793.36) (500.15) 10,293.21
50400920 Out Servs-A&G Ops OffSuppl&Exp (27,410.97) (37,305.62) (9,894.65)
50400921 Out Servs-A&G Ops OffSuppl&Exp 185.00 (6,913.27) (7,098.27)
50400923 Out Servs-A&G Ops (85,583.81) (47,530.85) 38,052.96
50400932 Out Servs-A&G Maint Plnt (5,349.76) 0.00 5,349.76
50405903 Print & Postage-Cust Acct Rcrd (298,432.23) (280,532.78) 17,899.45
50605602 Prchsd Wtr-SOS Ops (159,956.31) (168,466.35) (8,510.04)
50610623 Prchsd Pwr-Pump Ops Fuel Pwr (1,928,449.28) (1,998,599.30) (70,150.02)
50610624 Prchsd Pwr-Pump Ops Lbr & Exp (8,039.16) 0.00 8,039.16
Run Date: 4/16/2020
Run Time: 4:20 PM Page 5 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
50610643 Prchsd Pwr-Wtr Tmt Ops Misc (183.38) 0.00 183.38
50610665 Prchsd Pwr-T&D Ops Misc Ex (421,988.86) (412,688.33) 9,300.53
50620626 Utilities-Pump Ops Misc Exp (3,265.07) (1,969.96) 1,295.11
50620633 Utilities-Pump Maint Eq (2,218.40) (1,454.85) 763.55
50620651 Utilities-Wtr Tmt Maint Strct (2,053.34) 393,902.25 395,955.59
50620663 Utilities-T&D Ops Meter Exp 0.00 (76.96) (76.96)
50620665 Utilities-T&D Ops Misc Exp (11,084.59) (9,307.69) 1,776.90
50620921 Utilities-A&G Ops Off Suppl (22,257.23) (23,077.31) (820.08)
50620930 Utilities-A&G Misc (5,434.02) 0.00 5,434.02
50625643 Sludge Dspsl-Wtr Tmt Ops Misc (27,183.00) (23,203.67) 3,979.33
50625930 Sldge Dspsl-A&G Ops-Misc Gen (257.62) 0.00 257.62
50635614 Chmcals-SOS Maint Wlls&Spr (27,191.58) (16,397.27) 10,794.31
50635626 Chmcals-Pump Ops Misc Exp (829.38) 0.00 829.38
50635640 Chmcals-Wtr Tmt Ops Sup&Eng (785.33) 0.00 785.33
50635641 Chmcals-Wtr Tmt Ops Sup&Eng (370,729.40) (319,387.62) 51,341.78
50635642 Chmcals-Wtr Tmt Ops Lbr&Exp (6,209.70) 0.00 6,209.70
50635651 Chmcals-Wtr Tmt Maint Strctrs (1,325.90) 0.00 1,325.90
50635652 Chmcals-Wtr Tmt Maint Equip (26.47) 0.00 26.47
50645000 Trnsprt Cst-ES (844,948.88) (836,921.27) 8,027.61
50645600 Trnsprt Cst-SOS Ops Sup & Eng (5,097.14) (4,361.91) 735.23
50645601 Trnsprt Cst-SOS Ops Lbr & Exp (5,665.08) (7,166.01) (1,500.93)
50645603 Trnsprt Cst-SOS Ops Misc (344.89) (377.93) (33.04)
50645610 Trnsprt Cst-SOS Maint Sup &Eng (182.86) 0.00 182.86
50645611 Trnsprt Cst-SOS Maint Strctrs (2,562.17) (3,362.97) (800.80)
50645614 Trnsprt Cst-SOS Maint Wlls&Spr (3,028.61) (2,544.17) 484.44
50645620 Trnsprt Cst-Pump Ops Sup & Eng (1,333.41) (1,385.23) (51.82)
50645622 Trnsprt Cst-Pump Ops Pwr Prd L (1,833.75) (797.52) 1,036.23
50645624 Trnsprt Cst-Pump Ops Lbr & Exp (59,924.70) (64,180.10) (4,255.40)
50645630 Trnsprt Cst-Pump Maint Sup&Eng (1,043.57) (847.41) 196.16
50645631 Trnsprt Cst-Pump Maint Strctrs (1,512.35) (1,632.50) (120.15)
50645633 Trnsprt Cst-Pump Maint Eq (21,546.98) (20,401.97) 1,145.01
50645640 Trnsprt Cst-Wtr Tmt Ops Sup&En (1,890.71) (1,901.26) (10.55)
50645642 Trnsprt Cst-Wtr Tmt Ops Lbr&Ex (52,981.74) (47,597.04) 5,384.70
50645643 Trnsprt Cst-Wtr Tmt Ops Misc 0.00 (359.81) (359.81)
50645651 Trnsprt Cst-Wtr Tmt Maint Strc (3,437.91) (4,218.34) (780.43)
50645652 Trnsprt Cst-Wtr Tmt Maint Eq (6,027.50) (5,358.72) 668.78
50645660 Trnsprt Cst-T&D Ops Sup&Eng (3,562.57) (1,754.94) 1,807.63
50645662 Trnsprt Cst-T&D Ops Line Ex (48,487.19) (48,186.59) 300.60
50645663 Trnsprt Cst-T&D Ops Meter Exp (17,288.35) (18,010.73) (722.38)
50645665 Trnsprt Cst-T&D Ops Misc Ex (1,412.75) (17.55) 1,395.20
50645670 Trnsprt Cst-T&D Maint Sup & En (613.88) (452.35) 161.53
50645671 Trnsprt Cst-T&D Maint Strctrs (111.56) (3.24) 108.32
50645672 Trnsprt Cst-T&D Maint Rsrv&Stn (156.00) (77.30) 78.70
50645673 Trnsprt Cst-T&D Maint - Main (25,726.14) (29,308.41) (3,582.27)
50645675 Trnsprt Cst-T&D Maint-Services (19,326.21) (15,851.76) 3,474.45
50645676 Trnsprt Cst-T&D Maint - Meters (2,825.27) (3,648.09) (822.82)
50645677 Trnsprt Cst-T&D Maint-Hydrants (3,132.44) (1,375.30) 1,757.14
50645901 Trnsprt Cst-Cust Acct Suprvsn (7,239.88) (8,883.96) (1,644.08)
50645902 Trnsprt Cst-Cust Acct Mtr Rdng (34,519.76) (32,734.09) 1,785.67
50645903 Trnsprt Cst-Cust Acct Rcrds&Co (79,252.59) (78,034.83) 1,217.76
50645904 Trnsprt Cst-Custr Acct Uncolle (64.73) 0.00 64.73
50645910 Trnsprt Cst-Sales Exp Ops (4.86) 0.00 4.86
50645920 Trnsprt Cst-A&G Salaries (90,399.92) (90,930.18) (530.26)
50645930 Trnsprt Cst-A&G Misc (350.84) 0.00 350.84
50645932 Trnsprt Cst-A&G Maint Plnt (562.36) (760.30) (197.94)
50646000 Transportation Cost -Trnsfrred 844,948.88 836,921.27 (8,027.61)
Run Date: 4/16/2020
Run Time: 4:20 PM Page 6 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
50650600 Office Exp-SOS Ops Sup & Eng (611.37) (1,224.78) (613.41)
50650601 Office Exp-SOS Ops Lbr & Exp 0.00 (250.00) (250.00)
50650603 Office Exp-SOS Ops Misc (108.50) (3,442.90) (3,334.40)
50650610 Office Exp-SOS Maint Sup & Eng 0.00 (1,812.60) (1,812.60)
50650624 Office Exp-Pump Ops Lbr & Exp (701.80) 0.00 701.80
50650626 Office Exp-Pump Ops Misc Exp (40,921.26) (40,925.87) (4.61)
50650633 Office Exp-Pump Maint Eq (1,792.69) 0.00 1,792.69
50650642 Office Exp-Wtr Tmt Ops Lbr&Exp (808.39) 0.00 808.39
50650650 Office Exp-Wtr Tmt Maint Sprv (1,800.00) 0.00 1,800.00
50650651 Office Exp-Wtr Tmt Maint Strct (130.00) 0.00 130.00
50650652 Office Exp-Wtr Tmt Maint Equip (11,149.88) 0.00 11,149.88
50650660 Office Exp-T&D Ops Sup&Eng (5,533.88) 0.00 5,533.88
50650661 Office Exp-T&D Ops Strg Faclt (24,125.12) (24,501.26) (376.14)
50650662 Office Exp-T&D Ops Line Ex (5,673.93) (5,315.38) 358.55
50650665 Office Exp-T&D Ops Misc Ex (2,417.43) (3,424.28) (1,006.85)
50650670 Office Exp-T&D Maint Sup & Eng 0.00 (556.50) (556.50)
50650673 Office Exp-T&D Maint - Main (168.50) 0.00 168.50
50650675 Office Exp-T&D Maint-Services (2,666.82) 0.00 2,666.82
50650902 Office Exp-Cust Acct Mtr Rdng (13.00) 0.00 13.00
50650903 Office Exp-Cust Acct Rcrds&Col (56,711.36) (10,722.78) 45,988.58
50650910 Office Exp - Sales Exp Ops (228.00) 0.00 228.00
50650920 Office Exp-A&G Ops Salaries (23,873.27) 0.00 23,873.27
50650921 Office Exp-A&G Ops Off Suppl (190,287.83) (183,127.32) 7,160.51
50650923 Office Exp-A&G Accntng & Audtn (117,770.00) (99,000.00) 18,770.00
50650926 Office Exp-A&G OpsPension&Bnft (160.00) (80.00) 80.00
50650930 Office Exp-A&G Ops Misc Gen (152,458.65) (151,948.53) 510.12
50650932 Office Exp-A&G Maint Plnt (25,286.63) 0.00 25,286.63
50651660 Advertising Exp-A&G (120,249.42) (114,662.30) 5,587.12
50655614 Misc Exp-SOS Maint Wlls&Spr (50.00) 0.00 50.00
50655631 Misc Exp-Pump Maint Strctrs (208,144.11) (130,964.96) 77,179.15
50655632 Misc Exp-Pump Maint Pwr Prd (761.00) (419.76) 341.24
50655651 Misc Exp-Wtr Tmt Maint Strct (8,402.15) (10,631.91) (2,229.76)
50655662 Misc Exp-T&D Ops Line Ex 0.00 (30.00) (30.00)
50655672 Misc Exp-T&D Maint Rsrvrs&Stn (30.00) (989.00) (959.00)
50655673 Misc Exp-T&D Maint - Main 0.00 (25.00) (25.00)
50655675 Misc Exp-T&D Maint - Services (477.12) (2,150.95) (1,673.83)
50655905 Misc Exp-Cust Acct Misc Exp 20.00 20.30 0.30
50655930 Misc Exp-A&G Ops Misc Gen 0.00 (114.19) (114.19)
70100403 Depreciation - Utility Plant (9,553,786.91) (9,826,188.36) (272,401.45)
70203408 Real Estate Tax (1,875,902.48) (1,996,064.59) (120,162.11)
70250408 Payroll Taxes (545,623.24) (508,276.32) 37,346.92
90400904 Bad Dbt-WO-Custr Acct Uncollct (286,324.18) (254,940.75) 31,383.43
90405904 Bad Dbt-Provsn-Cust Acct Uncol (85,711.00) (71,000.00) 14,711.00
90850923 Corporate Shared Services Fees (3,814,660.35) (4,643,872.27) (829,211.92)
90890426 Corp Shrd Svcs-Non Recoverable (18,621.87) (305,399.26) (286,777.39)
90950000 F B T-ES 2,745,737.98 3,154,316.61 408,578.63
90950600 F B T-SOS Ops Sup & Eng (19,216.32) (18,078.34) 1,137.98
90950601 F B T-SOS Ops Lbr & Exp (21,238.20) (31,370.06) (10,131.86)
90950603 F B T-SOS Ops Misc (1,299.49) (1,736.79) (437.30)
90950610 F B T-SOS Maint Sup & Eng (654.89) 0.00 654.89
90950611 F B T-SOS Maint Strctrs (9,723.11) (14,368.39) (4,645.28)
90950614 F B T-SOS Maint Wlls&Spr (11,634.82) (11,514.64) 120.18
90950620 F B T-Pump Ops Sup & Eng (5,023.24) (5,927.71) (904.47)
90950622 F B T-Pump Ops Pwr Prd Lbr (6,259.44) (3,866.99) 2,392.45
90950624 F B T-Pump Ops Lbr & Exp (224,303.19) (276,690.26) (52,387.07)
90950630 F B T-Pump Maint Sup&Eng (3,929.27) (3,460.63) 468.64
Run Date: 4/16/2020
Run Time: 4:20 PM Page 7 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
90950631 F B T-Pump Maint Strctrs (6,337.60) (7,520.61) (1,183.01)
90950633 F B T-Pump Maint Eq (79,689.26) (88,829.18) (9,139.92)
90950640 F B T-Wtr Tmt Ops Sup&Eng (7,103.79) (8,058.26) (954.47)
90950642 F B T-Wtr Tmt Ops Lbr&Exp (197,490.00) (203,954.65) (6,464.65)
90950643 F B T-Wtr Tmt Ops Misc Exp 0.00 (1,026.75) (1,026.75)
90950651 F B T-Wtr Tmt Maint Strct (13,407.44) (17,779.70) (4,372.26)
90950652 F B T-Wtr Tmt Maint Equip (22,927.48) (23,342.19) (414.71)
90950660 F B T-T&D Ops Sup&Eng (13,810.99) (8,570.51) 5,240.48
90950662 F B T-T&D Ops Line Ex (183,645.08) (207,763.17) (24,118.09)
90950663 F B T-T&D Ops Meter Exp (64,486.94) (77,258.40) (12,771.46)
90950665 F B T-T&D Ops Misc Ex (5,732.10) (79.53) 5,652.57
90950670 F B T-T&D Maint Sup & Eng (2,267.72) (1,835.61) 432.11
90950671 F B T-T&D Maint Strctrs (436.71) (6.90) 429.81
90950672 F B T-T&D Maint Rsrvrs&Stn (514.36) (321.96) 192.40
90950673 F B T-T&D Maint - Main (93,220.84) (125,559.24) (32,338.40)
90950675 F B T-T&D Maint - Services (70,944.03) (68,032.91) 2,911.12
90950676 F B T-T&D Maint - Meters (10,231.82) (15,280.00) (5,048.18)
90950677 F B T-T&D Maint - Hydrants (11,572.50) (6,073.17) 5,499.33
90950901 F B T-Cust Acct Suprvsn (27,266.21) (39,901.85) (12,635.64)
90950902 F B T-Cust Acct Mtr Rdng (128,899.14) (138,616.88) (9,717.74)
90950903 F B T-Cust Acct Rcrds&Coll (296,272.44) (335,114.48) (38,842.04)
90950904 F B T-Custr Acct Uncoll (378.42) 0.00 378.42
90950910 F B T -Sales Exp Ops (21.22) 0.00 21.22
90950920 F B T-A&G Salaries (335,499.82) (399,023.75) (63,523.93)
90950930 F B T-A&G Misc (1,497.25) 0.00 1,497.25
90950932 F B T-A&G Maint Plnt (2,324.01) (3,402.69) (1,078.68)
91400924 Liability Insurance-A&G Ops (100.00) (757.72) (657.72)
91460925 Worker comp-A&G Ops-Inj&Dmages 39,411.04 (122,149.55) (161,560.59)
91500926 Pension-A&G Ops (501,660.00) (1,259,050.00) (757,390.00)
91550926 Post Rtrmnt PBOP-A&G Ops-Pnsn (181,146.01) 232,811.99 413,958.00
91700926 Emplyee Grp Hlth&L-A&G Op-Pnsn (1,304,038.97) (1,276,385.32) 27,653.65
91800926 Emplyee 401K-A&G Ops-Pension (252,680.77) (212,568.49) 40,112.28
91850000 Other Employee Benefits-ES (10,129.11) (3,247.09) 6,882.02
91850926 Othr Emply Bnft-A&G Ops-Pensn 0.00 2,353.09 2,353.09
91860926 Other Awards-A&G Ops-Emp Pnsns (17,141.34) (3,952.57) 13,188.77
91900928 Regulatory Commission-A&G Ops (122,137.44) (106,551.60) 15,585.84
92000928 Amrt Rate Case-A&G Ops-Reg Com 0.00 (35,792.04) (35,792.04)
92050930 Amort of Dfrrd Exp-Misc Gen-A& (0.08) (11,666.64) (11,666.56)
92052930 Amort Reloc-A&G Ops-Misc Gen (11,725.80) (11,725.80) 0.00
92053672 Amort Tnk Pntng-T&D Maint rsrv (55,768.75) (55,768.76) (0.01)
92056930 Amort OPEB Csts-A&G Ops Misc 0.00 (11,052.00) (11,052.00)
92061623 Amrt Pwr Csts-Pump Ops Fuel Pw 0.00 (257,652.00) (257,652.00)
92064930 Amort AFUDC Eq GU-A&G Ops Misc (40,209.57) (37,956.12) 2,253.45
92200620 Uni&Sfty Eq-Pump Ops Sup & Eng (987.08) 0.00 987.08
92200624 Uni&Sfty Eq-Pump Ops Lbr & Exp (774.08) 0.00 774.08
92200626 Uni&Sfty Eq-Pump Ops Misc Exp 0.00 (1,173.16) (1,173.16)
92200632 Uni&Sfty Eq-Pump Maint Pwr Prd (102.69) 0.00 102.69
92200633 Uni&Sfty Eq-Pump Maint Eq (2,747.32) 0.00 2,747.32
92200642 Uni&Sfty Eq-Wtr Tmt Ops Lbr&Ex (198.21) 0.00 198.21
92200652 Uni&Sfty Eq-Wtr Tmt Maint Eq (47.66) 0.00 47.66
92200662 Uni&Sfty Eq-T&D Ops Line Ex (986.74) 0.00 986.74
92200665 Uni&Sfty Eq-T&D Ops Misc Ex (130.63) 0.00 130.63
92200673 Uni&Sfty Eq-T&D Maint - Main (605.20) 0.00 605.20
92200675 Uni&Sfty Eq-T&D Maint-Services (5,238.95) 0.00 5,238.95
92200902 Uni&Sfty Eq-Cust Acct Mtr Rdng (295.39) 0.00 295.39
92200903 Uni&Sfty Eq-Cust Acct Rcrds&Co (3,142.12) 0.00 3,142.12
Run Date: 4/16/2020
Run Time: 4:20 PM Page 8 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
92200921 Uni&Sfty Eq-A&G Ops OffSup&Exp (39,053.34) 0.00 39,053.34
92200930 Uni&Sfty Eq-A&G Ops Misc Gen (37,410.61) (81,135.18) (43,724.57)
92200932 Uni&Sfty Eq-A&G Maint Plnt (14,979.64) (89.97) 14,889.67
92300930 Bank Charges-A&G Ops Misc Gen (10,588.79) (14,120.84) (3,532.05)
92600920 Other G&A Exp-A&G Ops Salaries (1,612.07) (2,374.00) (761.93)
92600923 Other G&A Exp-A&G Outs Srvcs E 0.00 0.65 0.65
92600930 Other G&A Exp-A&G Ops Misc Gen 7,462.19 6,222.02 (1,240.17)
92600932 Other G&A Exp-A&G Maint Plnt (35,881.63) (45,542.26) (9,660.63)
Operating Expenses (28,486,346.96) (29,467,141.98) (980,795.01)
Operating Income 17,575,799.21 18,827,610.03 1,251,810.82
70800430 Interest Exp-SWI/Can cons co's (3,921,165.13) (3,958,874.86) (37,709.73)
70900419 Interest income 43,428.43 15,545.63 (27,882.80)
71000431 Other interest 6,819.70 (6,236.92) (13,056.62)
71010431 Other interest – Regulatory (7,283.24) 0.00 7,283.24
71050419 AFUDC Gross Up 219,691.72 139,895.88 (79,795.84)
71051419 AFUDC Debt 305,695.49 155,436.85 (150,258.64)
71052419 AFUDC Equity 610,257.89 310,904.34 (299,353.55)
71200422 Gain - Disposition of Property 7,651.54 16,905.00 9,253.46
71250421 Misc non operating income 0.00 (0.02) (0.02)
71251418 Misc Non Oper Rental Income 50,671.47 52,197.97 1,526.50
71252426 Misc Income/Deduction 0.00 1,437.48 1,437.48
71253426 Non Recoverable 1,436,110.93 818,476.96 (617,633.97)
71255406 Amort of Util Plt Acquis Adj (20,712.00) (20,712.00) 0.00
71257426 Pension-Other componts of NPPC (755,523.00) 0.00 755,523.00
71258426 PBOP-Other components of NPPC 433,785.02 0.00 (433,785.02)
Other Income & Expenses (1,590,571.18) (2,475,023.69) (884,452.51)
Income before Income Taxes 15,985,228.03 16,352,586.34 367,358.31
80100409 Current-federal (4,622,931.59) (3,395,282.72) 1,227,648.87
80150409 Current-state (1,726,440.95) (1,118,787.38) 607,653.57
80200410 Deferred-Federal Income Taxes 996,514.24 (206,860.72) (1,203,374.96)
80250410 Deferred-State Income taxes 1,025,963.95 (46,446.32) (1,072,410.27)
80400411 Investment Tax Cr,amortization 48,240.00 48,240.00 0.00
Provision for Income Taxes (4,278,654.35) (4,719,137.14) (440,482.79)
Current Year Earnings 11,706,573.68 11,633,449.20 (73,124.48)
Total Retained Earnings 116,310,531.11 104,603,957.44 (11,706,573.68)
21800000 AOCI - Pension (7,497,766.79) (8,259,974.79) (762,208.00)
21805000 AOCI - PBOP 1,312,855.03 1,287,164.03 (25,691.00)
Accum Other Comprehensive Inc (6,184,911.76) (6,972,810.76) (787,899.00)
Oth Equity Noncontrol Interest 0.00 0.00 0.00
Long Term Debt 0.00 0.00 0.00
Total Capitalization 193,533,688.24 180,330,731.65 (13,202,956.60)
Total Current Liabilities
23200000 Accounts Payable 2,563,024.45 1,616,855.85 (946,168.60)
23210000 Accounts Payable Reversing 162,457.81 362,916.57 200,458.76
23211000 Accounts Payable Non Reversing 271,799.91 142,965.34 (128,834.57)
23220000 AP - Inventory Accrued 0.00 (618.16) (618.16)
23230000 AP - Lease Clearing 173.69 0.00 (173.69)
Accounts Payable 2,997,455.86 2,122,119.60 (875,336.26)
A/P Affiliated Companies 0.00 0.00 0.00
Notes Payable 0.00 0.00 0.00
N/P Affiliated Companies 0.00 0.00 0.00
Current Portion of LT Debt 0.00 0.00 0.00
Customer Deposits 0.00 0.00 0.00
23601000 Property Taxes Accrued 936,808.83 996,875.41 60,066.58
23610000 Franchise taxes Accrued 52,844.86 72,443.02 19,598.16
Run Date: 4/16/2020
Run Time: 4:20 PM Page 9 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
23641000 Federal Income Tax Accrued 3,612,874.86 3,612,292.75 (582.11)
23651000 State Income Tax Accrued 5,213,869.00 3,517,328.05 (1,696,540.95)
23661000 FICA Tax Accrued 24,722.04 20,669.13 (4,052.91)
23662000 Federal Unemployment Tax Accr 0.00 26.30 26.30
23663000 State Unemployment Tax Accrued 110.91 122.14 11.23
23670000 Sales & Use Taxes Accrued 41,429.63 41,918.51 488.88
23699000 Other Accrued Taxes 20,753.59 27,292.52 6,538.93
Accrued Taxes 9,903,413.72 8,288,967.83 (1,614,445.89)
23711000 Accrued Interest (0.04) 0.00 0.04
Accrued Interest (0.04) 0.00 0.04
Dividend Payable 0.00 0.00 0.00
24205000 Accrued - Payroll 332,328.30 271,411.46 (60,916.84)
24211000 Accrued Insurance 217,200.54 0.00 (217,200.54)
24213000 Accrued IBNR 217,946.63 0.00 (217,946.63)
24215000 Accrued - Power 206,406.95 145,556.79 (60,850.16)
24245000 Accrued - Vacation 48,763.00 31,369.00 (17,394.00)
24246000 Accrued - Bonus 332,605.50 380,333.24 47,727.74
24247000 Accrued - Employee Related 3,740.45 0.00 (3,740.45)
24248000 Accr - Employee Related Other 38,116.98 21,233.87 (16,883.11)
24299000 Accrued Other (48.52) 973.03 1,021.55
24301000 Employee W/hg-401K 44.68 44.68 0.00
24306000 Employee withholding – PAC 50.00 50.00 0.00
24330000 Employee Withholding- Other 0.00 115.00 115.00
26200000 Injuries and Damages Reserve 197,836.44 0.00 (197,836.44)
Other Current Liabilities 1,594,990.95 851,087.07 (743,903.88)
Total Current Liabilities 14,495,860.49 11,262,174.50 (3,233,685.99)
Deferred Income Taxes & Credit
Deferred Income Taxes & Credit
19010000 Def. Federal Inc Taxes- Other 66,428.59 24,364.18 (42,064.41)
19012000 Def State Income Taxes- Other (73,606.37) (51,404.37) 22,202.00
19013000 Def Fed Incme Txs-Medicare 1.00 1.00 0.00
19015000 Def Stte Incme Txs-Medicare (2.00) (2.00) 0.00
19017000 Def Fed NOL Tax Benefit (8,970.29) 0.00 8,970.29
19101000 Def. FIT-FAS109 ITC (100,674.40) (110,804.80) (10,130.40)
19103000 Def. FIT-F71/F109 G/U ITC (46,743.96) (50,313.72) (3,569.76)
19131000 Def.SIT-FAS109 ITC (44,865.57) (47,558.49) (2,692.92)
19132000 Def. SIT-F71/F109 G/U ITC (32,738.29) (33,023.53) (285.24)
Deferred Taxes (241,171.29) (268,741.73) (27,570.44)
25500000 Deferred ITC 567,394.00 615,634.00 48,240.00
25501000 Deferred State ITC Idaho (650,000.00) 0.00 650,000.00
28203000 Def. FIT-MACRS 7,668,608.97 9,152,781.84 1,484,172.87
28206000 Def. FIT- OCI Pension/PBOP (1,651,644.40) (1,861,085.40) (209,441.00)
28211000 Def. FIT Benefit on DSIT (392,683.59) (392,683.59) 0.00
28300000 Def. FIT-Other 376,839.19 374,947.19 (1,892.00)
28301000 Def. FIT-Tank Painting 374,207.00 271,359.00 (102,848.00)
28302000 Def. FIT-Rate Expenses 4,572.00 4,572.00 0.00
28303000 Def. FIT-Deferred Charges 212,198.35 196,855.35 (15,343.00)
28304000 Def. FIT-Relocation Expense 6,845.00 9,137.00 2,292.00
28305000 Def. FIT-M_S Fees (23,642.14) (23,642.14) 0.00
28306000 Def. FIT-Pensions 886,766.10 973,961.00 87,194.90
28307000 Def. FIT-PEBOP (655,140.85) (709,671.85) (54,531.00)
28308000 Def. FIT-Cost of Removal 1,173,445.75 1,075,693.75 (97,752.00)
28310000 Def. FIT-Uncollectibles (138,784.00) (122,031.00) 16,753.00
28311000 Def. FIT-Injuries and Damages (310,942.00) (310,942.00) 0.00
28312000 Def. FIT - AFUDC Equity 641,302.43 527,918.43 (113,384.00)
Run Date: 4/16/2020
Run Time: 4:20 PM Page 10 of 11
Report ID: BSCOR100
Layout ID: BSCOR100 SUEZ Water Idaho
General Ledger System
Business Unit: 00060 Corp BS C/M vs Same Month P/Yr
Period Ending: Dec 31, 2019
Run on 03/18/20 at 06:15 PM
- Current Month - Increase
This Last or
Year Year (Decrease)
28313000 Def. FIT - AFUDC Equity GU 398,309.57 363,228.57 (35,081.00)
28314000 Def. FIT - AFUDC Equity GU-TRF 620,690.41 439,664.41 (181,026.00)
28350000 Def. SIT- Other 136,666.18 130,560.18 (6,106.00)
28353000 Def. SIT - Tank Painting 103,362.00 66,923.00 (36,439.00)
28354000 Def. SIT-Pensions 191,509.00 224,788.00 33,279.00
28355000 Def. SIT-Post Retrmnt Benefits (312,791.72) (332,111.72) (19,320.00)
28356000 Def. SIT-AFUDC Equity 211,556.19 126,389.19 (85,167.00)
28357000 Def. SIT-Excess Depreciation 826,539.08 1,328,820.08 502,281.00
28358000 Def. SIT- Cost of Removal 279,803.71 245,169.71 (34,634.00)
28359000 Def. SIT- Relocation 896.00 1,708.00 812.00
28360000 Def. SIT- OCI Pension/PBOP (560,916.84) (635,121.84) (74,205.00)
28363000 Def. SIT -Shared Services Fees (13,523.04) (13,523.04) 0.00
28364000 Def. SIT - AFUDC Equity GU 87,333.53 74,904.53 (12,429.00)
28365000 Def. SIT - AFUDC Equity GU-TRF 109,100.24 109,100.24 0.00
28405000 Def FIT - New Federal Tax Rate (3,542,443.34) (3,475,403.48) 67,039.86
28406000 Def FIT-New Federal TaxRate GU (1,303,188.29) (1,332,677.04) (29,488.75)
28408000 Def FIT-Tax Reform for GU2018 (48,773.61) (0.07) 48,773.54
Deferred Income Taxes & Credit 5,032,299.59 6,836,480.57 1,804,180.98
25200000 Advances for Construction 5,152,544.54 5,263,252.76 110,708.22
25200001 CWIP non-taxable advances (509,505.06) (397,588.46) 111,916.60
25201000 Taxable Advncs/Servce Laterals (482,573.32) (482,573.32) 0.00
Cust Advances for Construction 4,160,466.16 4,383,090.98 222,624.82
27100000 Contribution in Aid of Cnstrct 121,068,940.35 118,897,073.96 (2,171,866.39)
27100001 CWIP non-taxable CIAC (81,295.20) 2,905,706.53 2,987,001.73
27100002 In Service non-taxable CIAC 1,183,033.60 731,665.72 (451,367.88)
27101000 Taxable CIAC - Serv Laterals 11,094,697.68 4,851,652.85 (6,243,044.83)
27101001 CWIP taxable CIAC 2,946,499.13 3,200,438.08 253,938.95
27101002 In Service taxable CIAC 3,568,752.74 1,826,791.61 (1,741,961.13)
27110000 Accumulated Amortization CIAC (41,551,014.80) (38,604,532.56) 2,946,482.24
Contribution in aid of Constru 98,229,613.50 93,808,796.19 (4,420,817.31)
25340000 PBOP Liability - Trustee 2,906,936.17 3,194,514.18 287,578.01
26310000 Pension Accrued 6,992,440.97 7,548,484.97 556,044.00
Pension and Benefits 9,899,377.14 10,742,999.15 843,622.01
25311000 Pension Regulatory Account 2,129,402.00 2,129,402.00 0.00
25316000 Regulatory Liab-Tax NewFedRate 4,414,304.63 4,380,517.52 (33,787.11)
25317000 Reg Liab-NewFedRate2018portion 217,616.72 210,333.48 (7,283.24)
25402000 DefRegLiab F71/F109-Fed:ITC 225,020.22 241,698.54 16,678.32
Regulatory Liabilities 6,986,343.57 6,961,951.54 (24,392.03)
25380000 Other Deferred Credits 301,953.19 297,492.43 (4,460.76)
25390000 Accrued SE LTIP 13,570.17 20,690.00 7,119.83
Other Long Term Liabilities 315,523.36 318,182.43 2,659.07
Lease Liabilities Non Current 0.00 0.00 0.00
Deferred Income Taxes & Credit 124,623,623.32 123,051,500.86 (1,572,122.46)
Total Capital & Liabilities 332,653,172.05 314,644,407.01 (18,008,765.05)
Run Date: 4/16/2020
Run Time: 4:20 PM Page 11 of 11
SUEZ Water Idaho Inc
Annual Report on Deferred Power Cost - Pending
Summary of 18714 Account as of December 31, 2019
Prepared By: Michael Wilson, March 27th, 2020
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7
Accounting Month
kWH subject to PCA
change
Deferred PCA
Costs
Interest
Accrual at
1%
Misc
Adjustments
Total 18714 Monthly
Increase
Cumulative
Account Balance NOTES GL BAL
$ 578,175.70 578,175.70$
January 2019 1,579,345 6,869.32$ 963.82$ 7,833.14$ 586,008.84$ 586,008.84$
February 2019 1,707,483 7,461.19$ 976.88$ 8,438.07$ 594,446.91$ 594,446.91$
March 2019 1,702,466 7,434.10$ 990.94$ 8,425.04$ 602,871.95$ 602,871.95$
April 2019 1,599,334 6,980.19$ 1,004.99$ 7,985.18$ 610,857.13$ 610,857.13$
May 2019 1,728,193 7,548.52$ 1,018.30$ 8,566.82$ 619,423.95$ 619,423.95$
June 2019 2,406,511 10,496.20$ 1,032.58$ 11,528.78$ 630,952.73$ 630,952.73$
July 2019 3,245,485 9,485.49$ 1,051.80$ 10,537.29$ 641,490.02$ 641,490.02$
August 2019 4,462,478 3,909.99$ 1,069.36$ 4,979.35$ 646,469.37$ 646,469.37$
September 2019 5,055,774 4,137.56$ 1,077.66$ 5,215.22$ 651,684.59$ 651,684.59$
October 2019 5,055,427 3,720.43$ 1,086.36$ 4,806.79$ 656,491.38$ 656,491.38$
November 2019 2,814,655 2,754.12$ 1,094.37$ 3,848.49$ 660,339.87$ 660,339.87$
December 2019 2,666,193 1,930.66$ 1,100.79$ 3,031.45$ 663,371.32$ 663,371.32$
Total 34,023,344 72,727.77$ 12,467.85$ -$
Beginning Balance:
NOTES: The IPUC authorized the establishment of a deferral account for the incremental cost resulting from increases in Idaho Power PCA adjustment in Order No.
28800 issued in 2001. IPUC Order No. 29838 issued in August 2005 authorized continuation of the deferral mechanism and added the requirement that United Water
Idaho file an annual report with the Commission documenting account activity and balance. In Order No. 30104, issued July 24, 2006 the Commission approved the
settlement stipulation of UWID's general rate case. The Agreement called for continuation of the deferral account methodology as well as amortization of the deferred
power expense over three years. In Order No. 31016, issued March 4, 2010, the IPUC approved the settlement stipulation of UWID's GRC, UWI-W-09-01. The Stipulation
allowed a three year amortization of Deferred Power Costs accumulated through the end of February, 2010. The Stipulation modified the methodology used by UWID to
calculate Deferred Power: as of March 1, 2010, the Company is entitled to defer the entire amount of Idaho Power PCA charge. Prior to this modification, United Water
Idaho deferred only the incremental change in PCA rates from the base PCA rate in effect at the time of UWID's rate change and Idaho Power new PCA rate, which is
updated each year effective June 1. Per PUC Order 32443 UWI-W-11-02 and Settlement Stipulation, the unamortized deferred power expense balance through Jan. 2012
will be re-amortized over 36 months commencing Feb. 1, 2012. Per Case No. UWI-W-15-01, authorized 3-year amortization of deferred balance beginning December
2015. September 2016 Interest calculation methodology changed so that interest on current month deferrals are calculated on a whole month instead of the number of days
from the date the accounts payable voucher posts through the end of the month.
C:\Users\mjwilson\OneDrive - SUEZ\PUC Report\2019 PUC Report\IPUC Power Def Summary 2019.xlsx
"¨
"¨"¨"¨
"¨"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨"¨
"¨
"¨"¨"¨"¨
"¨
"¨
"¨"¨
"¨
"¨
"¨
"¨
"¨"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨"¨
"¨
"¨
"¨"¨
"¨
"¨
"¨"¨"¨"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"¨
"Q
"Q
"`"`
"`"`
"`
"`
"`
"`"`
"`
"`"`"`"`"`
"`"`
"`"`
"`"`"`
"`
"`
"`
"`
"`
"`
"`"`
"`
"`"`
"`"`"`
"`
"`"`
"`
"`"`"`"`
"`"`
"`"`"`
"`"`
"`"`
"`
"`"`
"`"`
"`"`
"`
"`
"`
"`
"`"`
"`
"`
"`
"`"`
"`
"`"`
"`"`"`
"`
"`
"`"`
"`
"`"`"`
"`
"`"`
"`
"`"`
"-
"-
"-"-
"-"-
"`"-
"-
"-
"-
"-
"-"-
"-"-
"-
"-"-
"-"-
"-
"-
"-
"-
"`
"-"-
"-"-
"-
"-
"-
"-
"-
"-
"-"-
"-
"-
"-
"-
"`
"`
"`
"`
"`"`
"`
"`
"`
"`
"`
"`
"`
"-
"`"`
"-
"`
"¨
"`
"-
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`"`
"`
"`
"`
"`
"`"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"`
"-
"`
"`
BOGUS BASIN
SHAW MOUNTAIN
SUNSET PEAK
§¨¦I-84
§¨¦I-84
§¨¦I-84
§¨¦I-84
MERIDIAN
BOISE
GARDENCITY
EAGLE
KUNA
BOISE BOISE
KUNA
EAGLE
W Cherry Ln
S Broadway Ave
W Ustick Rd
N Orchard St
S Five
Mile Rd
W Chinden Blvd
E Lake Hazel Rd
W Franklin Rd
S Vista Ave
E Gowen Rd
N Meridian Rd
W Overland Rd
E Hwy 21
E Kuna Mora Rd
N Five
Mile Rd
S Capitol
Blvd
W Overland Rd
S Cole Rd
W Fairview AveN Cole Rd
W State St
E Overland Rd
S Meridian Rd
N Ten
Mile Rd
E Chinden Blvd
S Federal Way
E Fairview Ave
S Orchard St
W Lake Hazel Rd
W Fairview Ave
N Meridian Rd
W Franklin Rd E Front St
W Chinden Blvd W State St
S Ten Mile Rd
E Ustick Rd
E ChindenBlvd
W Lake Hazel Rd
E Franklin Rd
N Glenwood St
S Eagle Rd
N Hwy 55
E State St
N Eagle Rd
S Eagle Rd
W Hwy 44
E Parkcenter Blvd
E Hwy 44
N Hwy 55
E Kuna Mora Rd E KunaMora Rd W Kuna Mora Rd
Print Date: 4/10/2020 No Scale
WATER DISTRIBUTION SYSTEM±Facilities
UT Reservoirs
"-Boosters
"Q Treatment Plants
"`Vaults
"¨Wells
Mains
1/2 inch
3/4 inch
1 1/2 inch
1 1/4 inch
1 inch
2 1/2 inch
2 inch
3 inch
4 inch
6 inch
8 inch
10 inch
12 inch
14 inch
16 inch
18 inch
20 inch
24 inch
30 inch
36 inch
Service Area