2001Annual Report.pdf

T /' --·,,~D -' . ; t1 . _ .... .,, -. \
i
.. ' • '-. ,.J
I • l f"' ., r • ' / l ""~ C: 1 ':J°' • 0 I 1U I !._J L\J," 1·~ ~·· •
ANNUAL REPORT
·oF
UNITED WATER IDAHO INC.
NAME
P.O. Box 7488, Boise, ID 83707 -1488
ADDRESS
TO THE
IDAHO PUBLIC
UTILITIES COMMISSION
FOR THE
YEAR ENDED: DECEMBER 31, 2001
ANNUAL REPORT FOR WATER UTILITIES TO
THE IDAHO PUBLIC UTILITIES COMMISSION
FOR THE YEAR ENDING: December 31, 2001
COMPANY INFORMATION
1 Give full name of utility:
2 Date of Organization:
3 Organized under the laws of the state of:
4 Address of Principal Office (number & street)
5 P.O. Box (if applicable)
6 City
7 State
8 Zip Code
9 Organization (proprietor, partnership, Corp.)
10 Towns, Counties served
11 Are there any affiliated Companies?
UNITED WATER IDAHO INC.
April 2, 1928
Idaho
8248 W. Victory Road
P.O. Box 7488
Boise
Idaho
83707-1488
Corporation
Boise, Eagle
Ada, Canyon
Yes
If yes, attach a list with names, addresses & descriptions. Explain any services
provided to the utility.
12 Contact Information:
President
Vice President
Secretary
General Manager
Complaints or Billing
Engineering
Emergency Service
Accounting
Name
Gregory P. Wyatt
Benjamin M. Hepler
Carla E. Hjelm
Gregory P. Wyatt
Patricia Foss
Daniel M. Brown
Greg Wyatt, Ben Hepler or Patty Foss
Jeremiah J. Healy
13 Were any water systems acquired during the year or any additions/deletions made
to the service area during the year? Yes -----
Phone No.
[phone]
[phone]
[phone] x2886
[phone]
[phone]
[phone]
[phone]
[phone]
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?
Street Address
City
State
Zip
United Water Management & Service Inc.
200 Old Hook Road
Harrington Park
New Jersey
07640
Page 1 Revised 7/99
Name: UNITED WATER IDAHO INC.
For Year Ended:
COMPANY INFORMATION
December 31 , 2001
11. Affiliated Companies:
UNITED WATER MANAGEMENT & SERVICE INC.
200 Old Hook Road
Harrington Park, NJ 07640
Sevices provided to the utility:
Management and service contract on file with the I.P.U.C.
UNITED WATER OPERATIONS IDAHO INC.
8248 West Victory Road
Boise, ID 83707
United Water Idaho Inc. provides Management, Accounting, Customer Service and
Operations & Maintenance services at cost to United Water Operations Idaho Inc.
UNITED WATER LEAKGUARD INC., a New Jersey corporation, qualified to do business in Idaho, 12/15/00
(NJ-8/.20/99) (Subsidiary of United Water Operations Inc.)
200 Old Hook Road
Harrington Park, NJ 07640
United Water Idaho Inc. provides Management, Accounting, Customer Service and
Operations & Maintenance services at cost to United Water LeakGuard Inc.
13. Additions/ Deletions to service area:
Case No. UWI-W-01-03 Belmont Heights
Order 28885, Issued Oct. 24, 2001
Amend & revise Certificate of Public Convenience & Necessity No. 143 to
include Belmont Heights Subdivision
Page 1 Detail
, NAM~: UNITED WATER IDAHO INC.
COMPANY INFORMATION
(continued)
For the Year Ended
15 Is the system operated or maintained under a
service contract?
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?
December 31, 2001
No
Yes
City of Garden City 18 If yes: Name of Organization
Name of owner or operator
Mailing Address
City of Garden City, Department of Public Works
201 E. 50th St.
City
State
Zip
Water Purchased
19 Has any system(s) been disapproved by the
Idaho Division of Environmental Quality?
If yes, attach full explanation
20 Has the Idaho Division of Environmental Quality
recommended any improvements?
If yes, attach full explanation
21 Number of Complaints received during year concerning:
Quality of Service
High Bills
Disconnection
22 No. of Customers involuntarily disconnected
23 Date customers last received a copy of the Summary
of Rules required by IDAPA 31 .21 .01 .701?
Attach a Copy of the Summary
24 Did significant additions or retirements from the
Plant Accounts occur during the year?
If yes, attach full explanation
and an updated system map
Boise
Idaho
83714
Page 2
Gallons
29,963,000 I $
No
No
84
1,483
1,727
1,727
Dec.2001,Jan.2002
Yes
$Amount
10,487.00
Revised 7 /99
PAGE 2 DETAIL
PUC ANNUAL REPORT PAGE 1 OF 2
FOR UNITED WATER IDAHO INC.
December 31, 2001 03/25/02
24. SIGNIFICANT ADDITIONS OR RETIREMENTS TO THE PLANT ACCOUNT
ADDITIONS (Over $100,000 Gross)
NO.
1 C01F501
2 C01F001
3 C01F005
4 None
5 C01G501
6 C01F003
7 C01D708
8 COOD310
9 C01D317
10 COOD322
11 C01D328
12 C01G001
13 COOD330
14 C01A005
15 C01D313
16 C99C007
17 COOD608
18 C01 D311
19 C99K109
20 C01D369
21 COOC902
22 C01D336
23 C01D604
DESCRIPTION
Replacement Domestic Services
New Domestic Services (Dev-Inst)
New Domestic Services (Co-Inst)
Danskin Saddle Ridge
Replacement Customer Meters
New Fire Services
Federal Way (NY Canal to Amity)
Providence Place Sub #1
Callaway Ranch Estates
Harris Ranch Sub #3 & #4
Carlene Estates
New Customer Meters
Boise Air Terminal Relocation
Water Rights
Two Rivers Sub Phase 2 & 3
SCADA Replacement
Robertson I Biggs / Marvin
Asin Moody Sub
Victory Road Office Remodel
Cornerstone Sub
Harris Ranch Booster
Tahoe Ridge Sub
1-84 Crossing
Page 2 Detail
Page 1 of 2
AMOUNT
$ 988,173
$ 915,741
$ 785,764
$ 547,131
$ 477,250
$ 323,050
$ 305,884
$ 231,851
$ 209,964
$ 201,443
$ 164,445
$ 158,131
$ 137,635
$ 135,295
$ 133,943
$ 125,164
$ 111 ,800
$ 111,561
$ 111,244
$ 105,161
$ 104,014
$ 103,915
$ 102,518
TOTAL $ 6,591,076
PAGE 2 DETAIL
PUC ANNUAL REPORT PAGE 2 OF 2
FOR UNITED WATER IDAHO INC.
December 31, 2001 03/25/02
24. SIGNIFICANT ADDITIONS OR RETIREMENTS TO THE PLANT ACCOUNT
RETIREMENTS (Over $15,000)
BOOK ACCUMULATED
NO. DESCRIPTION COST DEPRECIATION
1 R01F501 Replacement Services $ 129,116 201 ,153
2 R01K102 UWID Office Septic/ Sewer Service $ 68,456 75,456
3 ROOA004 Redrill Settler's Well $ 63,651 87,555
4 R98A001 Frontier Well $ 56,732 56,732
5 R01H902 1990 International Dump Truck & Axle Seal $ 41 ,176 33,176
6 R010367 Anne Frank Memorial -Main $ 24,315 24,315
7 R01H902 2 GMC Trucks 1/2 Ton $ 22,751 17,612
8 R01C510 Variable Frequency Drive -Bethel $ 20,000 20,000
9 R01B504 Liquid Particle Counter $ 18,824 18,824
10 R01H901 1993 1/2 Ton GMC Pickup $ 16,940 9,940
11 R01B503 Chlorine Residual Analyzers $ 15,758 15,758
12 R01D709 Wye Stage 2 -Main $ 15,159 15,159
TOTAL $ 492,878 $ 575,681
Page 2 Detail
Page 2 of 2
NAME: UNITED WATER IDAHO INC.
REVENUE & EXPENSE DETAIL
For the Year Ended December 31 , 2001
ACCT# DESCRIPTION AMOUNT
400 REVENUES
1 460 Unmetered Water Revenue
2 461 .1 Metered Sales -Residential 19,903,349
3 461 .2 Metered Sales -Commercial, Industrial 9,082,891
4 462 Fire Protection Revenue -Private 446,064
5 464 Other Water Sales Revenue 439,513
6 465 Irrigation Sales Revenue
7 466 Sales for Resale
8 400 Total Revenue (Add Lines 1 -7) 29,871 ,817
(also enter result on Page 4, line 1)
c:j.. c l,~l'"c J i3Jt~, lr205,389
Booked to Account:
9 * DEQ Fees Billed separately to customers () P J ~e..~r 1,s '1° 0
10 ** Hookup or Connection Fees Collected
11 ***Commission Approved Surcharges Collected (Franchise Tax) 3,% ... /jo; ~ 769,770 If e-" r ~ 3 ~ (!) (!') 2
401 QeERA TING EXeENSES a. Joe oirS
12 601 .1-6 Labor -Operation & Maintenance 1,682,967
13 601 .7 Labor -Customer Accounts 659,982
14 601 .8 Labor -Administrative & General 746,777
15 603 Salaries, Officers & Directors
16 604 Employee Pensions & Benefits 1,598,825
17 610 Purchased Water (From page 2, line 21) 10,487
18 615-16 Purchased Power & Fuel for Power 1,153,498
19 618 Chemicals (includes chemical container deposits) 326,318
20 620.1-6 Materials & Supplies -Operation & Maint. 159,361
21 620.7-8 Materials & Supplies -A & G, & Cust. Care 197,376
22 631-34 Contract Services -Professional (Acctg., Legal, Mgmt. Fees) 1,559,901
23 635 Contract Services -Water Testing 60,515
24 636 Contract Services -Other 518,382
25 641-42 Rentals -Property & Equipment 36,521
26 650 Transportation Expense 407,288
27 656-59 Insurance 495,797
28 660 Advertising 36,743
29 666 Rate Case Expense (Amortization) 158,340
30 667 Regulatory Comm. Exp. (Amortization) 6,996
31 670 Bad Debt Expense 102,769
32 675 Miscellaneous 443,833
33 Total Operating Expenses 10,362,674
Page 3 Revised 7 /99
, Name:
ACCT#
1
2
3 403
4 406
5 407
6 408.10
7 408.11
8 408.12
9A 408.13
98
9C
9D
10 409.10
11 409.11
12 410.10
13 410.11
14 411
15 412
UNITED WATER IDAHO INC.
INCOME STATEMENT
For Year Ended
DESCRIPTION
December 31, 2001
Revenue (From Page 3, line 8)
Operating Expenses (From Page 3, line 33) 10,362,674
Depreciation Expense 4,493,484
Amortization, Utility Plant Aquisition Adj., 13,412
Amortization Exp. -Other Util. Plant (404000, 405000) 51,113 -----
Regulatory Fees (PUC) 80,175
Property Taxes 1,252,239
Payroll Taxes (408130, 408131, 408134) 322,234
Other Taxes: Idaho Sales & Use Tax
Federal Income Taxes
State Income Taxes
Provision for Deferred Income Tax -Federal
Provision for Deferred Income Tax -State
Provision for Deferred Utility Income Tax Credits
Investment Tax Credits-Utility
3,195,573
391,627
267,150
(1,523)
(40,379)
16 Total Expenses from operations before interest (add lines 2-15)
17 413
18 414
19
20 415
21 416
22 419
23 420
24 421
25 426
26 408.20
Income From Utility Plant Leased to Others
Gains (Losses) From Disposition of Utility Plant
Net Operating Income (Add lines 1, 17 &18 less line 16)
Revenues, Merchandizing Jobbing and Contract Work
Expenses, Merchandizing, Jobbing & Contracts
Interest & Dividend Income, Other
Allowance for Funds used During Construction
Miscellaneous Non-Utility Income
Miscellaneous Non-Utility Expense
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)
29 Gross Income (add lines 19 & 28)
Interest Exp. on Long-Term Debt
Other Interest Charges
29,871,817
20,387,778
10,754
61 ,726
11,921
432,130
45,195
13,793
5,041
30 427.3
31 427.5
32 NET INCOME (Line 29 less lines 30 & 31) (Also Enter on Pg 9, Line 2)
Page4
9,494,793
535,882
10,030,674
4,495,844
5,534,830
Revised 7/99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Name:
SUB
ACCT#
301
302
303
304
305
306
307
308
309
310
311
320
330
331
333
334
335
336
339
340
341
342
343
344
345
346
347
348
UNITED WATER IDAHO INC.
ACCOUNT 101 PLANT IN SERVICE DETAIL
For Year Ended:
DESCRIPTION
Organization
Franchises and Consents
Land & Land Rights
Structures and Improvements
Reservoirs & Standpipes
Lake, River & Other Intakes
Wells
Infiltration Galleries & Tunnels
Supply Mains
Power Generation Equipment
Power Pumping Equipment
Purification Systems
Distribution Reservoirs & Standpipes
Trans. & Distrib. Mains & Accessories
Services
Meters and Meter Installations
Hydrants
Backflow Prevention Devices
Other Plant & Misc. Equipment
Office Furniture and Equipment
Transportation Equipment
Stores Equipment
Tools, Shop and Garage Equipment
Laboratory Equipment
Power Operated Equipment
Communications Equipment
Miscellaneous Equipment
Other Tangible Property
Rounding Difference
TOTAL PLANT IN SERVICE
December 31 , 2001
Balance
Beginning
of Year
116,926
-
4,149,926
13,368,162
111 ,534
533,927
8,742,374
34,652
577,998
150,663
9,591,453
11,977,316
5,876,961
80,416,309
27,822,691
9,666,866
469,411
-
15,798
8,319,536
286,501
24,449
479,313
123,952
122,741
909,836
16,349
268,381
184,174,025
Added
During
Year
190,625
474,696
1,606
237,235
10,816
397,371
10,940
9,845
5,023,657
3,071 ,727
719,186
116,602
-
36,513
180,240
47,693
3,107
-
198,364
85,443
10,815,669
Removed
During
Year
(4,821)
(92,364)
(64,088)
(75,445)
(46,482)
(1,664)
(162,249)
(129,486)
(17,365)
(26,403)
(77,811)
(13,552)
(10,416)
(3,830)
(725,976)
Balance
End of
Year
116,926
-
4,335,730
13,750,494
111,534
535,533
8,915,521
34,652
577,998
161,479
9,913,379
11 ,941,774
5,885,142
85,277,717
30,764,932
10,368,687
586,013
-
52,311
8,473,373
208,690
24,449
513,454
116,643
122,741
1,108,200
97,962
268,381
-
194,263,718
(Add lines 1 -28) Enter beginning & end of year totals on Pg 7, Line 1
• Per Utility Plant Matrix Report UWAM4000 -OK to switch format & revise prior year figures -per Bob Smith 3/3/2000
Additions / Retirements contain some adjustments made throughout year to correctly state plant accounts
Page 5 Revised 7/99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Name: UNITED WATER IDAHO INC.
ACCUMULATED DEPRECIATION ACCOUNT 108.1 DETAIL
SUB
ACCT#
304
305
306
307
308
309
310
311
320
330
331
333
334
335
336
339
340
341
342
343
344
345
346
347
348
For Year Ended:
DESCRIPTION
Structures and Improvements
Reservoirs & Standpipes
Lake, River & Other Intakes
Wells
Infiltration Galleries & Tunnels
Supply Mains
Power Generation Equipment
Electric Pumping Equipment
Purification Systems
Distribution Reservoirs & Standpipes
Trans. & Distrib. Mains & Accessories
Services
Meters and Meter Installations
Hydrants
Backflow Prevention Devices
Other Plant & Misc. Equipment
Office Furniture and Equipment
Transportation Equipment
Stores Equipment
Tools, Shop and Garage Equipment
Laboratory Equipment
Power Operated Equipment
Communications Equipment
Miscellaneous Equipment
Other Tangible Property
Cost of Removal / Salvage
TOTALS (Add Lines 1 -25)
December 31, 2001
Depreciation
Rate*
%
2.00%
2.00%
2.00%
2.86%
2.00%
2.00%
5.00%
5.00%
5.00%
2.00%
2.00%
2.50%
2.50%
2.50%
2.00%
6.67/10.00/20.00%
11.49%
6.67%
6.67%
6.67%
14.50%
6.67/2.50%
6.67%
2.00%
NOTE: Negative balances are assets that have been fully depreciated.
Balance
Beginning
of Year
1,687,957
355,280
30,888
1,619,321
27,230
12,093
33,858
3,450,460
3,244,142
578,256
16,650,118
6,528,300
1,591,678
37,298
1,422
3,768,895
273,446
9,251
256,912
65,350
113,815
52,399
(35,937)
53,519
{2,604)
40,403,347
Depreciation continues for all if any asset in plant account has undepreciated value.
Page6
Balance
End of
Year
1,862,168
352,115
41,599
1,766,918
27,923
16,162
41,392
3,837,653
3,796,225
678,137
18,037,228
7,044,027
1,824,999
49,408
-
1,738
4,668,843
243,984
10,882
280,550
64,747
123,002
119,123
(38,494)
66,712
(28,084)
44,888,956
Increase
or
(Decrease)
174,211
(3,165)
10,711
147,597
693
4,069
7,534
387,194
552,083
99,881
1,387,110
515,727
233,321
12,110
-
316
899,948
(29,461)
1,631
23,638
(603)
9,187
66,724
{2,557)
13,193
(25,480)
4,485,610
Revised 7 /99
Name:
ACCT#
1 101
2 102
3 103
4 105
5 114
6
7 108.1
8 108.2
9 108.3
10 110.1
11 110.2
12 115
13
14 123
15 125
16
17 131
18 135
19 141
20 142
21 145
22 151
23 162
24 173
25 143
26
27 181
28 183
29 184
30 186
31
UNITED WATER IDAHO INC.
BALANCE SHEET
For Year Ended:
ASSETS
DESCRIPTION
Utility Plant in Service (From Pg 5, Line 29)
Utility Plant Leased to Others
Plant Held for Future Use
Construction Work in Progress
Utility Plant Aquisition Adjustment
Subtotal (Add Lines 1 -5)
Accumulated Depreciation (From Pg 6, Line 26)
Accum. Depr.-Utility Plant Lease to Others
Accum. Depr. -Property Held for Future Use
Accum. Amort.-Utility Plant Lease to Others
Accumulated Amortization-Aquisition Adj.()
Net Utility Plant (Line 6 less lines 7 -12)
Investment in Subsidiaries
Other Investments
Total Investments (Add lines 14 & 15)
Cash
Short Term Investments
Accts/Notes Receivable -Customers
Other Receivables
Receivables from Associated Companies
Materials & Supplies Inventory
Prepaid Expenses
Unbilled (Accrued) Utility Revenue
Provision for Uncollectable Accounts
Total Current (add lines 17 -24 less line 25)
Unamortized Debt Discount & Expense
Preliminary Survey & Investigation Charges
Deferred Rate Case Expenses
Other Deferred Charges
Total Assets (Add lines 13, 16 & 26 -30)
Page 7
December 31 , 2001
Balance
Beginning
of Year
184,174,025
-
2,555,658
2,118,193
763,829
189,611,705
40,403,347
-
97,501
-
-
(10,136)
149,120,993
23,964
23,964
100,173
-
1,257,696
309,416
-
253,475
Balance
End of
Year
194,263,718
-
2,555,658
6,629,307
763,829
204,212,511
44,888,956
-
148,614
-
-
3,275
159,171,665
-
23,964
23,964
510,937
-
1,206,265
237,848
-
234,510
Increase
or
(Decrease)
10,089,693
-
-
4,511,114
-
14,600,806
4,485,610
-
51 ,113
-
-
13,411
10,050,672
-
-
-
410,764
-
(51,431)
(71,568)
-
(18,965)
(121 ,661) (962,142) (840,481)
1,729,749 1,779,180 49,431
5,000 5,000 -
3,523,848 3,001,597 (522 ,251)
---
---
235 ,192 73,117 (162,075)
91 ,605 1,311 ,053 1,219,448
152,995 ,602 163,581,397 10,585,795
Revised 7 /99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Name: UNITED WATER IDAHO INC.
ACCT#
201-3
204-6
207-13
214
215
216
218
221-2
223
224
231
232
233
235
236 .11
236.12
236.2
237-40
241
251
252
253
255.1
255.2
261-5
271
272
281-3
BALANCE SHEET
For Year Ended:
LIABILITIES & CAPITAL
DESCRIPTION
December 31 , 2001
Balance
Beginning
of Year
Common Stock 1,261 ,547
Preferred Stock 725,850
Miscellaneous Capital Accounts 65,404,330
Appropriated Retained Earnings -
Unappropriated Retained Earnings 37,264,799
Reacquired Capital Stock -
Proprietary Capital -
Total Equity Capital (Add Lines 1-5+ 7 less line 104,656,526
Bonds -
Advances from Associated Companies -
Other Long-Term Debt -
Accounts Payable 518,907
Notes Payable -
Accounts Payable -Associated Companies -
Customer Deposits (Refundable) -
Accrued Other Taxes Payable 656,069
Accrued Income Taxes Payable (462,628)
Accrued Taxes -Non-Utility -
Accrued Debt, Interest & Dividends Payable 6,047
Misc. Current & Accrued Liabilities 267,800
Unamortized Debt Premium -
Advances for Construction 6,073,128
Other Deferred Liabilities 4,214,483
Accumulated Investment Tax Credits -Utility 1,464,576
Accum. Investment Tax Credits -Non-Utility -
Operating Reserves 145,880
Contributions in Aid of Construction 37,598,385
Accum. Amort. of Contrib. in Aid of Const. ** (4,838,329)
Accumulated Deferred Income Taxes 2,694,758
Total Liabilities (Add lines 9 -29 48,339,076
TOTAL LIAB & CAPITAL ( Add lines 8 & 30) 152,995,602
** Only if Commission Approved
Page8
Balance
End of
Year
1,261 ,750
704,500
65,404,330
-
39,964,104
-
-
107,334,684
-
-
-
338,159
-
-
-
687,255
445,628
-
5,871
277,796
-
7,173,309
5,386,389
1,424,197
-
145,880
43,180,776
(5,674,183)
2,855,636
56,246,712
163,581 ,397
Increase
or
(Decrease)
203
(21 ,350)
-
-
2,699,306
-
-
2,678,159
-
-
-
(180,748)
-
-
-
31,186
908,255
-
(176)
9,995
-
1,100,181
1,171,906
(40,379)
-
-
5,582,391
(835,855)
160,878
7,907,636
10,585,795
Revised 7 /99
Name: UNITED WATER IDAHO INC.
STATEMENT OF RETAINED EARNINGS
For Year Ended: December 31, 2001
1 Retained Earnings Balance@ Beginning of Year 37,264,799
2 Amount Added from Current Year Income (From Pg 4, Line 32) 5,534,830 __ _..;._....;___
3 Other (Credits)/ Debits to Account 175
4 Dividends Paid or Appropriated (2,835,700)
5 Other Distributions of Retained Earnings
6 Retained Earnings Balance@ End of Year
7 Description (Class, Par Value etc.)
Common Stock, $50.00 Par Value
CAPITAL STOCK DETAIL
No. Shares
Authorized
50,000
5% Preferred Stock, $100.00 Par Value 25,000
8 Description
None
DETAIL OF LONG-TERM DEBT
Interest
Rate
Year-end
Balance
Page 9
39,964,104
No. Shares
Outstanding
25,235
7,045
Interest
Paid
$
$
Dividends
Paid
2,800,000.00
35,700.00
$ 2,835,700.00
Interest
Accrued
Revised 7 /99
Name: UNITED WATER IDAHO INC.
For Year Ended:
SYSTEM ENGINEERING DA TA
December 31, 2001
1 Provide an updated system map if significant changes have been made to the system during the year.
2 Water Supply:
Pump Designation or location
See attached
3 System Storage:
Storage Designation or Location
See attached
Rated
Capacity
(GPM)
Total
Capacity
OOO's
Gal.
Type of
Treatment:
(None, Chlorine
Fluoride
Filter etc.)
Usable
Capacity
OOO's
Gal.
Water
Supply
Annual Source
Production (Well, Spring,
(OOO's Gal.) Surface Wtr)
Type of
Reservoir Construction
(Elevated.Pres-(Wood, Steel
urized, Boosted) Concrete)
(Duplicate form and attach if necessary. Asterisk facilities added this year.)
Page 10 Revised 7 /99
PUC ANNUAL REPORT 2. Water Supply
FOR UNITED WATER IDAHO INC.
December 31, 2001 03/12/02
~~l[•li.t1~··1··['•rnf'iili~]Jtill•••:ii••mtJiJ'"!f•••l'•••grn{ii<C'•'-=~rcc= '"1/,fi 1•{ ·. · · ·, I ~ ·,-•• -,-·) -o~ .!_..__::, ,.· --.-..,.-~~· .I• • l ·(-,1:ffii~f /:. ·-'e.<:-,!1~1!\G3.P'cJ-· 1~,r._.;,,,r, ! r-'"~,;;;:,:,Jol ·. I
l\-~i~:Jr:::_, .. :.:~1;§.[~~121!.:: E.:'!,,._h ...... '. .. : 'tiif{l~1i:lX:_ __ J --~ _§'.,(?:~1t .. J.: .. 1).\i-~--'~i;~:fuU:0~,l;Jj1ii1~:,;~_::.r11~J~~~-I~[ !
1 16 TH
2 27 TH
3 AMITY
4 ARCTIC
5 B. I. F.
6 BALI HAI
7 BEACON
8 BERGESON
9 BETHEL
10 BROADWAY
11 BROOKHOLLOW
12 BYRD
13 CARRIAGE HILLS
14 CARTWRIGHT
15 CASSIA#1
16 CASSIA#2
17 CENTENNIAL
18 CENTRAL PARK
19 CHAMBERLAIN #1
20 CHAMBERLAIN #2
21 CLIFFSIDE
22 CLINTON
23 COLE
24 COUNTRY CLUB
25 COUNTRY SQUARE
26 COUNTRYMAN
27 COVENTRY PLACE
28 DANSKIN
29 DURHAM
30 EDGE VIEW
31 FISK
32 FIVE MILE #12
33 FLOATING FEATHER
34 FOXTAIL
35 FRANKLIN PARK
36 FRONTIER
37 GODDARD
38 H.P.
39 HIDDEN VALLEY #1
40 HIDDEN VALLEY #2
41 HILLCREST
42 HILTON
43 HOPE
44 HUMMEL
45 IDAHO
46 ISLAND WOOD #1
GRNDWATER 1.20
GRNDWATER 0.5
GRNDWATER 1.23
GRNDWATER 0.89
GRNDWATER 0.66
GRNDWATER 2.67
GRNDWATER 0.00
GRNDWATER 0.89
GRNDWATER 1.99
GRNDWATER 1.77
GRNDWATER 1.44
GRNDWATER 0.37
GRNDWATER 0.43
GRNDWATER 0.28
GRNDWATER 1.67
GRNDWATER 2.88
GRNDWATER 1.27
GRNDWATER 0.53
GRNDWATER 0.34
GRNDWATER 0.55
GRNDWATER 0.86
GRNDWATER 1.82
GRNDWATER 0.96
GRNDWATER 1.28
GRNDWATER 1.58
GRNDWATER 0.86
GRND WATER 1.80
GRNDWATER 0.43
GRNDWATER 0.27
GRNDWATER 1.15
GRNDWATER 1.58
GRND WATER 1.44
GRNDWATER 2.16
GRNDWATER 1.51
GRNDWATER 1.43
GRNDWATER 2.11
GRNDWATER 1.53
GRNDWATER 1.87
GRNDWATER 1.87
GRNDWATER 1.29
GRNDWATER 1.96
GRNDWATER 2.88
GRNDWATER 1.35
GRNDWATER 1.04
GRNDWATER 0.55
GRNDWATER 2.9
Page 10 Detail
Page 1 of 2
162,255
65,478
389,975
125,549
48,428
47,452
37,701
108,544
706,534
440,930
50,654
58,852
3,788
16,305
398,779
106,035
274,906
5,712
35,783
45,693
135,620
146,138
0
66,212
132,182
75,803
796
23,762
9,666
14,435
242,955
111,413
520,504
Fire only
397,701
166,720
170,295
87,755
199,613
290,241
722,203
242,736
413,141
37,552
75,743
10
CL2,P04 YES
CL2 YES
CL2 YES
CL2,P04 YES
P04 YES
CL2,P04 YES
CL2 YES
CL2 YES
CL2 YES
CL2 YES
CL2 YES
CL2,P04 YES
CL2 YES
CL2 YES
CL2,P04 YES
CL2,P04 YES
CL2 YES
CL2,P04 YES
CL2,P04 YES
CL2 YES
CL2,P04 YES
CL2,P04 YES
CL2,P04 YES
CL2,P04 YES
CL2 YES
CL2 YES
CL2 YES
CL2 YES
CL2 YES
CL2 YES
CL2,P04 YES
CL2 YES
N/A YES
N/A YES
CL2,P04 YES
CL2,P04 YES
CL2 YES
CL2 YES
CL2 YES
CL2 YES
CL2,P04 YES
CL2,P04 YES
CL2 YES
CL2,P04 YES
CL2,P04 YES
N/A YES
' PUCANNUALREPORT
FOR UNITED WATER IDAHO INC.
December 31, 2001
2. Water Supply
03/12/02
I·::'_· .·fT~:7~~f ~.'trli·rg!r . r-·-:r1:: f~ll ,!,.1f,lt~V!'t )-. ------.-. -!-. ~: -. ~---] ~,:fm 'r: ·.,:· .. ·.:: .. ,•li:1 1il~:. . ·t -::-l.JJ~J·l ,,,-.. ' ' .. •'.1,=.;_cJf"· J l~l·· ·'·ffi j f'-'"'~ i'.J--g . ! :· :
1~fg~Jti::: .. ,;~~;:~i,1rr~~l'.:,1( __ ..... 1.: .. :'.;~~i1;it~ ...... t:.'~~;l:;~L-., .::i :i,;,;r;\~i,:iH .1~~H:_1
i,~i~,,~7JhJ1)]~~~!:-l:!:,;
47 ISLAND WOOD #1
48 ISLAND WOOD #2
49 JR FLAT
50 KIRKKWOOD
51 LaGRANGE
52 LICORICE
53 LOGGER
54 LONG MEADOW
55 M&M
56 MAC
57 MAPLE HILLS
58 MARDENWTP
59 MARKET
60 McMILLAN
61 OVERLAND
62 PARADISE
63 PIONEER
64 PLEASANT VALLEY
65 RAPTOR
66 REDWOOD CREEK
67 RIVER RUN
68 ROOSEVELT #1
69 ROOSEVELT #3
70 SETTLERS
71 SHERMAN OAKS
72 SPUR WING
73 SUNSET WEST
74 SWIFT#1
75 SWIFT#2
76 SWIFT#3
77 TAGGART #1
78 TAGGART#2
79 TEN MILE
80 TERTELING
81 VETERAN'S
82 VICTORY
83 VISTA
84 WARM SPRINGS #1
85 WARM SPRINGS #2
86 WARM SPRINGS #3
87 WESTMORE LAND
88 WILLOW LANE #1
89 WILLOW LANE #2
90 WILLOW LANE #3
GRNDWATER 1.15
GRNDWATER 1.15
GRNDWATER 1.01
GRNDWATER 2.80
GRNDWATER 1.94
GRNDWATER 0.27
GRNDWATER 0.98
GRNDWATER 1.09
GRNDWATER 0.14
GRNDWATER 1.45
GRNDWATER 1.04
SURFACE 20.00
GRNDWATER 1.58
GRNDWATER 1.15
GRNDWATER 1.44
GRNDWATER 0.72
GRNDWATER -1.73
GRNDWATER 2.90
GRNDWATER 2.16
GRNDWATER 0.40
GRNDWATER 0.35
GRNDWATER 0.75
GRNDWATER 1.33
GRNDWATER 1.93
GRNDWATER 0.43
GRNDWATER 1.72
GRND WATER 2.88
GRND WATER 1.28
GRNDWATER 1.63
GRNDWATER 1.01
GRND WATER 1.01
GRNDWATER 1.87
GRNDWATER 1.44
GRNDWATER 0.75
GRNDWATER 0.94
GRNDWATER 0.86
GRNDWATER 1.80
GRNDWATER 0.23
GRNDWATER 0.65
GRNDWATER 0.86
GRNDWATER 0.55
GRNDWATER 0.32
GRNDWATER 0.33
GRNDWATER 0.37
Page 1 O Detail
Page 2 of 2
54,109 N/A YES
19,935 N/A YES
161 ,697 CL2 YES
71 ,280 CL2 YES
27,790 CL2 YES
53,169 CL2 YES
125,896 CL2 YES
70,514 CL2 YES
2,230 N/A YES
100,422 CL2,P04 YES
240,709 CL2,P04 YES
3,140,320 CL2 YES
370,571 CL2 YES
69,508 N/A YES
227,105 CL2,P04 YES
131 ,836 CL2 YES
367,001 CL2 YES
343,241 CL2 YES
92,625 CL2 YES
686 N/A YES
46,893 CL2,P04 YES
79,392 CL2,P04 YES
102,566 CL2,P04 YES
103,378 CL2 YES
0 CL2 YES
764 CL2 YES
360,787 CL2 YES
22,746 CL2,P04 YES
0 CL2 ,P04 YES
0 CL2 YES
132,901 CL2,P04 YES
626,089 CL2 YES
336,653 CL2 YES
137,069 CL2 YES
130,579 CL2 YES
201 ,806 CL2 YES
247,086 CL2,P04 YES
0 N/A YES
16,588 CL2 YES
99,328 NaOCI YES
43,159 CL2,P04 YES
35,955 CL2,P04 YES
65,022 CL2,P04 YES
57,919 CL2,P04 YES
11 ,321,034
PUC ANNUAL REPORT
FOR UNITED WATER IDAHO INC.
December 31, 2001
1 AERONICA
2 ARROWHEAD
3 BARBER
4 BOGUS BASIN
5 BOULDER HEIGHTS
6 BRAEMERE
7 BRIARHILL
8 CARTWRIGHT
9 CLAREMONT
10 COLUMBIA
11 CRESTLINE
12 DANMOR
13 FEDERAL
14 GOOD STREET
15 GOWEN STANDPIPE
16 HARRIS RANCH
17 HARVARD STREET
18 HIDDEN HOLLOW
19 HIDDEN SPRINGS
20 HIGH'D VIEW #1
21 HIGH'D VIEW #2
22 HILLCREST
23 NEW HULLS GULCH
24 LANCASTER HTS
25 NORTH MTN
26 OLD PEN
27 STEELHEAD
28 TOLUKA
29 QUAIL RIDGE
30 USTICK
BOOSTED STEEL
NON BOOSTED CONCRETE
NONBOOSTED STEEL
NON BOOSTED CONCRETE
NON BOOSTED STEEL
NON BOOSTED CONCRETE
NON BOOSTED CONCRETE
NON BOOSTED STEEL
NON BOOSTED CONCRETE
NON BOOSTED STEEL
NONBOOSTED STEEL
NONBOOSTED CONCRETE
BOOSTED STEEL
NONBOOSTED STEEL
NON BOOSTED STEEL
NON BOOSTED CONCRETE
BOOSTED STEEL
NON BOOSTED STEEL
NON BOOSTED STEEL
NONBOOSTED CONCRETE
NON BOOSTED STEEL
BOOSTED STEEL
NON BOOSTED STEEL
NON BOOSTED CONCRETE
NON BOOSTED STEEL
NON BOOSTED CONCRETE
BOOSTED STEEL
BOOSTED STEEL
NON BOOSTED CONCRETE
BOOSTED STEEL
TOTAL STORAGE CAPACITY
NOTE: NONBOOSTED RESERVOIRS PROVIDE SYSTEM GRADIENT
BY THE ELEVATION OF THE WATER LEVEL IN THE FACILITY
Page 10 Detail
Page 1 of 1
3. System Storage
03112/02
20 7,500 150,000 1,000
21 20,952 440,000 NIA
42 47,619 2,000,000 1,500
10 12,000 120,000 NIA
19 33,105 629,000 900
12 16,667 200,000 NIA
18 13,889 250,000 NIA
19 7,895 150,000 NIA
8 11,250 90,000 NIA
32 93,750 3,000,000 NIA
20 15,000 300,000 500
20 37,500 750,000 NIA
32 62,500 2,000,000 3,700
47 63,830 3,000,000 NIA
85 23,529 2,000,000 NIA
12 15,000 180,000 NIA
20 7,500 150,000 1,050
42 47,619 2,000,000 NIA
22 15,773 347,000 NIA
12 16,667 200,000 NIA
21 14,286 300,000 NIA
28 71,429 2,000,000 2,400
24 250,000 6,000,000 NIA
9 5,556 50,000 NIA
32 9,375 300,000 NIA
17 18,824 320,000 NIA
40 75,000 3,000,000 4,500
15 6,133 92,000 800
40 8,125 325,000 NIA
32 62,500 2,000,000 3,700
32,343,000
. .
4
5
6
7
8
9
Name: UNITED WATER IDAHO INC.
SYST
For Year Ended: D
EM ENGINEERING DATA
(continued)
ecember 31 , 2001
Pump information for ALL system pumps, incl uding wells and boosters.
Designation or Location
& Type of Pump**
See attached
Horse
Power
Rated
Capacity
(gpm)
Discharge
Pressure
(psi)
Energy
Used
This Year
** Submit pump curves unless previously
Attach additional sheets if inadequate spa
provided or unavailable. Asterisk facilities added this year.
ce is available on this page.
If Wells are metered:
What was the total amount pumpe
What was the total amount pumpe
What was the total amount pumpe
d this year?
d during peak month?
d on the peak day?
If customers are metered, what was the total amount sold in peak month?
Was your system designed to supply fire flow s?
If Yes: What is current system rating?
How many times were meters read this year?
(in 1,000 Gal.)
15,959,485
July ___ 2..:..,4_6_8..:..,9_6_4_
Aug. 15th, 2001 ____ 8_4'-,6_6_1_
August 2,298,442 -------
Yes
IS0-3
6
During which Months? M eters are read every other month. There are two cycles,
on e set of meters are read on even months, the other on odd months.
rved with no system improvements How many additional customers could be se
except a service line and meter? 1,500
How many of those potential additi ons are vacant lots? 1,500
10 Are backbone plant additions anticipated duri ng the coming year? Yes
If Yes, attach an explanation of projects and anticipated costs
Maple Hills Well #2 $200,000
Tablerock Reservoir -$200,000
Arrowhead Reservoir & Pump Stati ons -$980,000
Harris Ranch Reservoir -$440,000
2002 CWIP Expenditures on Columbia WTP -$900,000 Planned
11 In what year do you anticipate that the system capacity (supply, storage or distribution)
will have to be expanded?
Page 11
2002
Revised 7/99
..
PUC ANNUAL REPORT
FOR UNITED WATER IDAHO INC.
December 31, 2001
1 WELL 16 TH
2 WELL 27TH
3 WELL AMITY
4 WELL ARCTIC
5 WELL B.I.F.
6 WELL BALI HAI
7 WELL BEACON
8 WELL BERGESON
9 WELL BETHEL
10 WELL BROADWAY
11 WELL BROOKHOLLOW
12 WELL BYRD
13 WELL CARRIAGE HILLS
14 WELL CARTWRIGHT
15 WELL CASSIA#1
16 WELL CASSIA#2
17 WELL CENTENNIAL
18 WELL CENTRAL PARK
19 WELL CHAMBERLIN #1
20 WELL CHAMBERLIN #2
21 WELL CLIFFSIDE
22 WELL CLINTON
23 WELL COLE
24 WELL COUNTRY CLUB
25 WELL COUNTRY SQUARE
26 WELL COUNTRYMAN
27 WELL COVENTRY PLACE
28 WELL DANSKIN
29 WELL DURHAM
30 WELL EDGE VIEW
31 WELL FISK
32 WELL FIVE MILE #12
33 WELL FLOATING FEATHER
34 WELL FOX TAIL
35 WELL FRANKLIN PARK
36 WELL FRONTIER
37 WELL GODDARD
38 WELL HP
39 WELL HIDDEN VALLEY #1
40 WELL HIDDEN VALLEY #2
41 WELL HILLCREST
42 WELL HILTON
43 WELL HOPE
44 WELL HUMMEL
45 WELL IDAHO
46 WELL ISLAND WOODS #1
47 WELL ISLAND WOODS #1
48 WELL ISLAND WOODS #2
49 WELL JR FLAT
50 WELL KIRKWOOD
51 WELL LaGRANGE
52 WELL LICORICE
53 WELL LOGGER
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
4. All System Pumps (including Wells & Boosters)
200 257,000
60 158,1 19
150 1,038,880
150 278,080
60 128,856
350 120,880
125 71,947
100 274,360
200 770,920
450 901,560
75 69,112
75 160,004
30 9,120
100 63,920
125
250 722,1 20
200 679,880
50 16,824
50
60 127,360
200 257,457
125 156,320
150 1,440
125 167,800
125 269,280
50 13,653
10 6,720
30 43,400
15 12,588
75 22,720
125 322,600
75 160,101
125 1,020,260
50 1,866
125 472,040
150 236,400
150 431,360
150 818,200
150 175,320
100 401,360
200 1,296,720
200 1,187,980
125 284,000
75 74,760
50 173,800
15
75 34,325
75 67,695
200 631 ,960
40 96,387
150 66,960
15 90,587
150 331 ,880
Page 11 Detail
Page 1 of 4
03/12/02
162,255 600 315 72
65,478 0.5 442 65
389,975 900 490 87
125,549 640 350 80
48,428 450 444 57
47,452 2800 406 80
37,701 600 320 55
108,544 584 325 62
706,534 2500 223 64
440,930 1779 385 50
50,654 1000 230 60
58,852 300 394 55
3,788 300 260 55
16,305 275 624 96
398,779 1250 300 60
106,035 2000 390 60
274,906 1400 376 57
5,712 350 450 86
35,783 250 270 50
45,693 600 200 50
135,620 900 350 59
146,138 1300 275 59
0 700 355 80
66,212 800 330 46
132,182 1100 325 58
75,803 600 180 55
796 250 160 75
23,762 300 260 73
9,666 190 180 62
14,435 800 290 60
242,955 1300 262 59
111,413 1000 230 55
520,504 1500 260 63
Fire only 1050 150 80
397,701 1200 218 60
166,720 1750 250 58
170,295 1300 350 54
413,141 1200 410 60
87,755 1300 330 58
199,613 900 360 55
290,241 1500 420 57
722,203 2000 250 58
242,736 1300 210 66
37,552 900 242 66
75,743 375 289 68
10 150 230 69
54,109 1000 230 69
19,935 800 280 66
161,697 1100 435 71
71,280 300 260 66
27,790 1350 320 60
53,169 190 180 62
125,896 750 455 67
PUC ANNUAL REPORT
FOR UNITED WATER IDAHO INC.
December 31, 2001
54 WELL LONGMEADOW
55 WELL M&M
56 WELL MAC
57 WELL MAPLE HILLS
58 MARDEN WTP #1
59 MARDEN WTP #2
60 PLANT MARDEN WTP #3
61 MARDEN WTP #4
62 MARDEN WTP #5
63 WELL MARKET
64 WELL MCMILLAN
65 WELL OVERLAND
66 WELL PARADISE
67 WELL PIONEER
68 WELL PLEASANT VALLEY
69 WELL RAPTOR
70 WELL REDWOOD CREEK
71 WELL RIVER RUN
72 WELL ROOSEVELT #1
73 WELL ROOSEVELT #3
74 WELL SETTLERS
75 WELL SHERMAN OAKS
76 WELL SPUR WING
77 WELL SUNSET WEST
78 WELL SWIFT#1
79 WELL SWIFT#2
80 WELL SWIFT#3
81 WELL TAGGART#1
82 WELL TAGGART#2
83 WELL TEN MILE
84 WELL TERTELING
85 WELL VETERANS
86 WELL VICTORY
87 WELL VISTA
88 WELL WARM SPRINGS #1
89 WELL WARM SPRINGS #2
90 WELL WARM SPRINGS #3
91 WELL WESTMORELAND
92 WELL WILLOW LANE #1
93 WELL WILLOW LANE #2
94 WELL WILLOW LANE #3
1 BSTR 28TH STREET
2 BSTR 36TH ST. #1
3 BSTR 36TH ST. #2
4 BSTR 36TH ST. #3
5 BSTR AERONICA#1
6 BSTR AERONICA#2
7 BSTR ARCTIC PIT
8 BSTR BARBER #1
9 BSTR BARBER#2
10 BSTR BLUFFS #1
11 BSTR BLUFFS #2
DWT
DWT
DWT
DWT
VT
VT
VT
VT
VT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
DWT
CENT
CENT
CENT
CENT
CENT
CENT
VT
CENT
CENT
CENT
CENT
4. All System Pumps (including Wells & Boosters)
125 99,680
10 6,716
150 187,320
125 301,040
150
150
250
250
450 4,563,276
200 1,098,760
100 121,000
100 281,804
40 211,016
300 1,258,320
500 1,199,360
300 340,680
200 4,200
100 114,600
50
75 274,720
125 15,700
30 958
150 4,200
250 623,480
200
75
100 104,880
100
150 1,511,160
300 464,360
75 452,813
60 179,280
60 314,643
200 491,680
50 2,159
75 42,330
100 266,629
50 64,567
40 71,800
50
40 156,616
12,240 30,006,628
1.5 11,143
5
60
60 75,979
15
50 31,675
40 55,617
150
150 1,920
25
20
Page 11 Detail
Page 2 of 4
03/12/02
70,514 800 280 50
2,230 100 164 65
100,422 1200 350 79
240,709 1400 215 68
2777 170 63
2777 170 63
4166 170 63
4166 170 63
3,140,320 4166 200 85
370,571 1000 570 69
69,508 800 372 80
227,105 1000 290 69
131,836 500 235 65
367,001 1.728 780 65
343,241 2000 780 67
92,625 950 635 87
686 1800 310 65
46,893 900 370 65
79,392 700 230 55
102,566 600 380 55
103,378 1600 264 56
0 300 240 58
764 1200 275 80
360,787 2000 339 68
22,746 1400 317 66
0 850 265 66
0 700 380 66
132,901 700 340 55
626,089 1300 396 55
336,653 1000 710 64
137,069 425 500 69
130,579 600 290 60
201,806 600 250 55
247,086 685 336 50
0 158 500 136
16,588 450 533 ,136
99,328 600 480 136
43,159 350 260 50
35,955 245 340 69
65,022 255 245 69
57,919 285 317 69
15,929,873
N/A 50 50 60
N/A 75 150 88
N/A 1500 125 88
N/A 1500 125 88
N/A 200 183 52
N/A 800 183 52
N/A 2500 32 80
N/A 1500 260 90
N/A 1500 260 90
N/A 250 140 75
NIA 500 140 75
PUC ANNUAL REPORT
FOR UNITED WATER IDAHO INC.
December 31, 2001
12 BSTR BLUFFS #3
13 BSTR BOGUS#1
14 BSTR BOGUS#2
15 BSTR BOISE AVE
16 BSTR BOULDER #1
17 BSTR BOULDER#2
18 BSTR BOULDER #3
19 BSTR BRAEMERE#1
20 BSTR BRAEMERE#2
21 BSTR BRIARHILL #1
22 BSTR BRIARHILL #2
23 BSTR BRIARHILL #3
24 BSTR BRUMBACK
25 BSTR CARTWRIGHT BSTR
26 BSTR CRESTLINE #1
27 BSTR CRESTLINE #2
28 BSTR FEDERAL#1
29 BSTR FEDERAL#2
30 BSTR FEDERAL#3
31 BSTR FLOATING FEATHER
32 BSTR GARFIELD
33 BSTR GOOD STREET
34 BSTR GOWEN#1
35 BSTR GOWEN#2
36 BSTR GOWEN#3
37 BSTR HARVARD#1
38 BSTR HARVARD#2
39 BSTR HARVARD#3
40 BSTR HIDDEN HOLLOW #1
41 BSTR HIDDEN HOLLOW #2
42 BSTR HIGHL'D VIEW #1
43 BSTR HIGHL'D VIEW #2
44 BSTR HIGHL'D VIEW #3
45 BSTR HILL ROAD
46 BSTR HILLCREST #1
47 BSTR HILLCREST #2
48 BSTR HILLS SORO #1
49 BSTR HILLS SORO #2
50 BSTR HILO
51 BSTR HULLS GULCH #1
52 BSTR HULLS GULCH #2
53 BSTR HULLS GULCH #3
54 BSTR LOWER DANMOR #1
55 BSTR LOWER DANMOR #2
56 BSTR LOWER DANMOR #3
57 BSTR MICRON #1
58 BSTR MICRON #2
59 BSTR MICRON #3
60 BSTR MICRON #4
61 BSTR NORTH MTN #1
62 BSTR NORTH MTN #2
63 BSTR OLD PEN
64 BSTR QUAIL RIDGE #1
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
VT
VT
VT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
CENT
4. All System Pumps (including Wells & Boosters)
15 47,835
30 0
30 0
30 78,772
1.5
15
20 43,831
40
60 99,977
50
30
100 139,400
50 127,291
50 30,360
25
15 49,381
100
100
25 74,120
100 0
50 582
50 28,500
40
50
25 9,983
20
20
20 19,360
200
200 82,080
100
30
10 116,240
15 60,800
30 in #41
100 in #41
50
75 0
50 10,206
125
125
125 283,040
50
75
75 238,120
50
20
75 27,640
125
15
25 34,529
15 565
30
Page 11 Detail
Page 3 of 4
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
N/A
N/A
NIA
N/A
N/A
NIA
N/A
N/A
N/A
N/A
N/A
N/A
N/A
N/A
NIA
N/A
NIA
N/A
N/A
03112/02
500 140 75
600 152 60
600 152 60
1000 77 72
150 120 60
250 120 60
500 120 60
500 200 85
1000 150 85
200 230 150
200 230 150
800 235 150
50 115 200
300 338 120
300 215 90
200 215 90
1500 190 60
1500 190 60
700 100 60
1,500 100 56
2000 62 50
3000 59 60
1000 110 66
1500 110 66
340 150 66
350 90 85
350 90 85
350 90 85
1000 575 120
1000 575 120
1300 180 67
500 165 67
75 180 67
750 80 85
900 N/A 67
1500 170 67
600 263 104
900 263 104
500 185 105
1400 258 112
1400 258 112
1400 258 112
600 230 132
1000 230 132
1000 230 132
900 150 105
340 150 105
1700 165 105
1700 92 105
250 150 88
600 120 88
300 150 70
200 160 151
PUC ANNUAL REPORT
FOR UNITED WATER IDAHO INC.
December 31, 2001
65 BSTR QUAIL RIDGE #2 CENT
66 BSTR QUAIL RIDGE #3 CENT
67 BSTR ROGER HEIGHTS CENT
68 BSTR SCENIC COVE #1 CENT
69 BSTR SCENIC COVE #2 CENT
70 BSTR SOMERSET#1 CENT
71 BSTR SOMERSET#2 CENT
72 BSTR STEELHEAD #1 CENT
73 BSTR STEELHEAD #2 CENT
74 BSTR STEELHEAD #3 CENT
75 BSTR STONECREEK CENT
76 BSTR SUNVIEW#1 CENT
77 BSTR SUNVIEW#2 CENT
78 BSTR SUNVIEW#3 CENT
79 BSTR TOLUKA#1 CENT
80 BSTR TOLUKA#2 CENT
81 BSTR TOLUKA#3 CENT
82 BSTR UPPER DANMOR #1 CENT
83 BSTR UPPER DANMOR #2 CENT
84 BSTR UPPER DANMOR #3 CENT
85 BSTR USTICK#1 CENT
86 BSTR USTICK#2 CENT
87 BSTR USTICK#3 CENT
4. All System Pumps (including Wells & Boosters)
60
60 106,997
60 254,720
1.5
5 8,574
25
100
25
60
100 140,440
2.5 14,165
7.5
20
60 57,010
20
20
20 119,979
40
40
75 187,640
75
75
25 119,120
4,505
Page 11 Detail
Page 4 of 4
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
NIA
03112102
500 160 151
500 160 151
3000 63 145
30 63 63
100 63 63
200 280 166
1000 280 166
500 135 70
1500 135 70
2500 135 70
80 80 80
200 145 101
750 145 101
750 145 101
200 240 81
200 240 81
200 240 81
400 228 104
400 228 104
900 225 104
1500 164 60
1500 164 60
700 100 60
Name: UNITED WATER IDAHO INC.
For Year Ended:
1 Pipe
Size
See attached
2 Metered:
2A Residential
28 Commercial
2C Industrial
3 Flat Rate:
3A Residential
38 Commercial
3C Industrial
4 Private Fire Protection:
5 Public Fire Protection:
6 Street Sprinkling
7 Municipal, Other
8 Other Water
TOTALS (Add lines 2 through 8
SYSTEM ENGINEERING DATA
(continued)
December 31 , 2001
FEET OF MAINS
In Use
Beginning
of Year
Installed
During
Year
CUSTOMER STATISTICS
Number of Customers
This Last
Year Year
61 ,715 59,950
7,566 7,420
--
--
--
--
1,157 1,119
--
--
124 45
--
70,562 68,534
Page 12
Abandoned
During
Year
In Use
End of
Year
Thousands of Gallons Sold
This Last
Year Year
9,601,791 9,618,433
5,372,371 5,300,105
--
--
--
--
--
--
--
97,824 92,517
39,912 40,608
15,111 ,898 15,051 ,663
Revised 7/99
PUC ANNUAL REPORT
FOR UNITED WATER IDAHO INC.
For the Year Ended December 31, 2001
1. FEET OF MAINS
PIPE
SIZE
36"
30"
24"
20"
18"
16"
14"
12"
10"
8"
6"
4"
3"
2-1/2"
2-1/4"
2"
1-1/2"
1-1/4"
1"
3/4"
1/2"
TOTAL
IN USE
BEGINNING
OF YEAR
320
816
53,370
11,318
3,598
147,799
8,341
1,050,053
53,965
1,529,106
1,515,946
217,404
11,238
1,207
26,972
252,970
889
28,439
12,709
3,948
1,053
.
4,931,461
INSTALLED
DURING
YEAR
.
.
624
.
8,604
.
52,039
37
113,738
727
5,504
.
.
.
978
.
.
.
.
.
182,251
Page 12 Detail
Page 1 of 1
ABANDONED IN USE
DURING END OF
YEAR YEAR
. 320
. 816
. 53,370
540 12,482
. 3,598
1,150 157,553
. 8,341
3,547 1,105,639
320 54,322
2,785 1,645,629
255 1,516,928
10 222,918
1,825 13,063
. 1,207
. 26,972
3,236 257,184
. 889
28,439
. 12,709
. 3,948
1,053
.
13,668 5,127,380
MILES 971.09
State of Idaho
County of Ada
CERTIFICATE
WE, the undersigned Gregory P. Wyatt. President
and ___ =J=e~re=m ....... i=a~h~J~-~H=e=a~IY~-~C~o=o=r~d=in=a=to=r~o=f~P~l=a~n~oi~n-g~&~R=a=te=s~----------------
of the. __ ...,,U=n_,_,_it.,,e=d,._W........,.a'""te ... r_.l=d=a ....... ho=....,aln .... c ........... =a ...... w ... a ..... te=r.__ _______________________ _
utility, on our oath do severally say that the foregoing report has been prepared under our direction,
from the original books, papers and records of said utility; that we have carefully examined same, and
declare the same to be a correct statement of the business and affairs of said utility for the period
covered by the report in respect to each and every matter and thing therin set forth, to the best of our
knowledge, information and belief.
Subscribed and Sworn to Before Me
this q-lk day of_Q~p...;...r...,_i ;._I ____ , 20Q2_
My Commission Expires __ _.0 .......... 7-+/ ..... i4"""-+-j..:..4 .... D ...... D_5 _____ _ r 1
Page 13 Revised 7 /99
Report ID: UWGLW800
Business Unit: 060
Period Ending: Dec 31, 2001
101000
108900
108010
111003
113000
107000
105000
Utility plant
Water Plant in Service
RWIP
Utility plant in service
Acc. Depr. Util. Pit.Ser. -Water
Reserve for Deprec.-CIAC
Amari.of Prop.Held Fut.Use
Less accumulated depreciation & amortization
CWIP
Construction Work in Progress
Pit.Held for Fut.Use/Dev.
Plant held for future use
Total utility plant
114000
115000
124000
UP AA-Adjustment-Water
Amort.UPAA Adj.-Water
Utility plant acquisition adjustment
Other property & investments
Investments in associated companies
Other Investments
Other investments
Equity Investments
121000 Non-Utility Property
Non-utility property
Less accumulated depreciation
Total other property & investment
131000
131070
131092
135001
135002
135003
142000
142001
142003
173000
143000
143005
143010
143020
143050
143090
143095
143102
144000
Current & accrued assets
Cash
Cash: Collections
Cash: Dividends
Cash
Special deposits
Restricted cash
Working Fund -MGRS Fund
Working Fund -Petty Cash
Working Fund -Cashiers Drawer
Working funds
Temporary cash investment
Customer Accounts Rec.
Cust. NR-Local Billing
Cust. NR-Refunds Clearing
Accounts receivable-customers
Unbilled Revenues-Water
Accounts receivable-unbilled
Other Accounts Receivable
NR-Employees
NR-Employee PC Purchase
NR-Merchandise & Jobbing
NR-Developers Advances
NR-Advance Offset
NR-Deposits
NR-UWR/LDE Partnership
Other accounts receivable
Prov.Uncollectible Accounts
Reserve for uncollectible accounts
Notes receivable -other companies
Notes receivable -associated companies
Accounts receivable -associated companies
United Water Idaho
General Ledger System
BALANCE SHEET
Page No. 1 of 8
Run Date: 04/05/2002
Run Time: 9:56 AM
This
-Current Month -
Last
Increase
or
(Decrease) Year
194,263,717.78
28,083.75
194,291,801.53
(39,242,856.36)
(5,674,183.34)
(148,613.97)
(45,065,653.67)
6,629,306.61
6,629,306.61
2,555,658.30
2,555,658.30
158,411,112.77
763,828.62
(3,275.34)
760,553.28
0.00
1,250.00
1,250.00
0.00
22,714.37
22,714.37
0.00
23,964.37
459,887.17
41 ,000.00
100.00
500,987.17
0.00
0.00
9,000.00
400.00
550.00
9,950.00
0.00
1,211,842.45
(258.92)
(5,318.97)
1,206,264.56
1,779,180.00
1,779,180.00
131,533.21
52.58
3,084.36
71 ,120.64
6,636.68
(6,636.68)
29,700.00
2,357.37
237,848.16
(5,000.00)
(5,000.00)
0.00
0.00
0.00
Year
184,174,024.85
2,604.43
184,176,629.28
(35,472,624.85)
(4,933,326.80)
(97,500.80)
(40,503,452.45)
2,118,193.48
2,118,193.48
2,555,658.30
2,555,658.30
148,347,028.61
763,828.62
10,136.22
773,964.84
0.00
1,250.00
1,250.00
0.00
22,714.37
22,714.37
0.00
23,964.37
89,123.27
1,000.00
100.00
90,223.27
0.00
0.00
9,000.00
400.00
550.00
9,950.00
0.00
1,256,281 .95
527.58
886.22
1,257,695.75
1,729,749.00
1,729,749.00
133,212.86
(199.21)
19,117.09
130,284.18
2,935.31
(2,935.31 )
19,130.00
7,870.73
309,415.65
(5,000.00)
{5,000.00)
0.00
0.00
0.00
10,089,692.93
25,479.32
10,115,172.25
(3,770,231 .51)
(740,856.54)
(51,113.17)
(4,562,201.22)
4,511,113.13
4,511,113.13
0.00
0.00
10,064,084.16
0.00
(13,411 .56)
(13,411.56)
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
370,763.90
40,000.00
0.00
410,763.90
0.00
0.00
0.00
0.00
0.00
0.00
0.00
{44,439.50)
(786.50)
(6,205.19)
(51,431.19)
49,431 .00
49,431.00
(1,679.65)
251.79
(16,032.73)
(59,163.54)
3,701 .37
(3,701 .37)
10,570.00
(5,513.36)
(71,567.49)
0.00
0.00
0.00
0.00
0.00
Report ID: UWGLW800 United Water Idaho Page No. 2 of 8
Business Unit: 060 General Ledger System Run Date: 04/05/2002
Period Ending: Dec 31, 2001 BALANCE SHEET Run Time: 9:56 AM
-Current Month -Increase
This Last or
~ Year (Dec.cea~e,l
154000 Plant Mat.& Oper. Supplies 76,284.99 129,728.70 (53,443.71)
154104 Inventory-Chemicals 23,806.53 0.00 23,806.53
154105 Inventory-Exempt 134,418.24 123,746.59 10,671.65
Materials & supplies 234,509.76 253,475.29 (18,965.53)
165218 Prepaid Assess.Water Purchased 0.00 31,368.00 (31,368.00)
165400 Prepaid Regulatory Assess. 36,133.76 35,896.57 237.19
165800 Prepaid Pension (998,276.00) (197,932.00) (800,344.00)
165907 Prepaid Maintenance 0.00 9,001.78 (9,001.78)
165912 Prepaid-Dues 0.00 5.00 (5.00)
Prepaid expenses (962,142.24) (121,660.65) (840,481.59)
Interest/dividends receivable 0.00 0.00 0.00
Other current/accrued assets 0.00 0.00 0.00
Real estate taxes 0.00 0.00 0.00
Total current and accrued assets 3,001 ,597.41 3,523,848.31 (522,250.90)
Deferred debits
Unamortized debt discount/expense 0.00 0.00 0.00
183000 Prelim. Surv.& Invest.Charges 6,277.50 0.00 6,277.50
186000 Util/DD-Deferred Debits 741 .13 3,735.00 (2,993.87)
186001 Def.Legal Expenses 17,676.70 131,238.27 (113,561 .57)
186004 Def.Other Suspense 321 ,648.27 0.00 321,648.27
186020 Def.Rents 0.00 21,436.00 (21,436.00)
186024 Def.Relocation Expenses 0.00 102,275.48 (102,275.48)
186025 Def.M&J Costs 271 ,697.29 273,663.66 (1 ,966.37)
186296 Def Pens Early Rel Prog-2000 721,330.00 0.00 721 ,330.00
186297 Def PBOP-Erly Retire Prog-2000 529,287.00 0.00 529,287.00
186298 Def Pens Early Ret Prog-1999 398,772.00 507,528.00 (108,756.00)
186299 Def PBOP-Erly Retire Prog-1999 159,324.00 202,776.00 (43,452.00)
186301 RA-Deferred Legal 80,166.27 0.00 80,166.27
186320 RA-Deferred Rents 20,884.00 0.00 20,884.00
186324 RA-Deferred Relocation 93,430.77 0.00 93,430.77
186400 RA-Deferred Rate Case 73,116.99 231,456.99 (158,340.00)
186600 RA-Deferred Operations 0.00 1,634.26 (1,634.26)
186601 RA-Deferred Tank Painting 87,739.80 69,735.80 18,004.00
186603 RA-Deferred Chemical Treatment 18,616.00 28,612.00 (9,996.00)
186730 RA-Deferred Studies 10,494.00 17,490.00 (6,996.00)
186750 RA-Def Post Retirement Ben-NB 602,411 .00 642,971.00 (40,560.00)
186801 RA-Deferred FAS 109-Plant (1 ,953,341 .00) (1 ,934,282.00) (19,059.00)
186802 RA-Deferred FAS 109-Rate (3,886.00) (8,820.00) 4,934.00
186803 RA-Deferred FAS 109:Tank Paint (2,350.00) (1,850.00) (500.00)
186804 RA-Deferred FAS 109-Pensions (95,260.00) (51,896.00) (43,364.00)
186805 RA-Deferred FAS 109-DefCharges 8,172.00 10,903.00 (2,731 .00)
186831 RA-Deferred FAS 109-StatePlant 988,180.00 984,693.00 3,487.00
186832 RA-Deferred FAS 109-StateRate 10,227.00 23,185.00 (12,958.00)
186833 RA-Def FAS 109-State TankPaint 6,179.00 4,863.00 1,316.00
186834 RA-Def FAS 109-StatePensions (19,825.00) (1,568.00) (18,257.00)
186835 RA-Def FAS 109-StateDefCharges 17,866.00 25,802.00 (7,936.00)
186851 RA-Def G/U-FAS 109-Plant (1,051 ,797.00) (1,041 ,536.00) (10,261.00)
186852 RA-Def G/U-F AS 109-Rate (2,098.00) (4,754.00) 2,656.00
186853 RA-Def G/U-FAS 109-TankPaint (1 ,269.00) (997.00) (272.00)
186854 RA-Def G/U-F AS 109-Pensions (51 ,297.00) (27,947.00) (23,350.00)
186855 RA-Def G/U-FAS 109-DefCharges 4,403.00 5,869.00 (1,466.00)
186872 RA-Def G/U-FAS 109-State:Plant 85,933.00 85,620.00 313.00
186873 RA-Def G/U-FAS 109-State:Rate 888.00 2,019.00 (1,131.00)
186874 RA-Def G/U-FAS 109-State:TnkPt 535.00 421 .00 114.00
186875 RA-Def G/U-FAS 109-StatePensio (1 ,728.00) (135.00) (1 ,593.00)
186876 RA-Def G/U-FAS 109-StateDefChg 1,552.00 2,246.00 (694.00)
Other deferred charges & asset 1,354,696.72 306,388.46 1,048,308.26
184100 Clearing Transportation 610,863.66 562,358.24 48,505.42
184110 Clearing Trans.-Large (348,996.01) (307,148.52) (41,847.49)
184111 Clearing Trans.-Small (259,419.72) (251 ,413.82) (8,005.90)
.
Report ID: UWGLW800
Business Unit: 060
Period Ending: Dec 31, 2001
184401 Clearing -Blocks and Posts
184500 Clearing Payroll
Clearing accounts
Total deferred debits
Total assets
United Water Idaho
General Ledger System
BALANCE SHEET
Page No. 3 of 8
Run Date: 04/05/2002
Run Time: 9:56 AM
-Current Month -Increase
This
.YML
2,500.26
24,524.00
29,472.19
1,384,168.91
163,581,396.74
Last
.YML
1,956.74
14,655.00
20,407.64
326,796.10
152,995,602.23
or
(Decrease.>
543.52
9,869.00
9,064.55
1,057,372.81
$10,585,794.51
Report ID: UWGLWSOO United Water Idaho Page No. 4 of 8
Business Unit: 060 General Ledger System Run Date: 04/05/2002
Period Ending: Dec 31, 2001 BALANCE SHEET Run Time: 9:56 AM
-Current Month -Increase
This Last or
~ Year (De.c.ce.a~e,l
Liabilities
Capital stock
201000 Common Stock Issued 1,261,750.00 1,261,547.06 202.94
211000 Misc. Paid-In Capital 65,404,330.21 65,404,330.21 0.00
Total common stock 66,666,080.21 66,665,877.27 $202.94
Cumm. Translation Adj. 0.00 0.00 0.00
204000 Preferred Stock Issued 704,500.00 725,850.00 (21,350.00)
Preferred stock 704,500.00 725,850.00 (21,350.00)
Preference stock 0.00 0.00 0.00
Total capital stock 67,370,580.21 67,391,727.27 (21,147.06)
Retained earnings
216000 Retained Earnings 37,229,274.04 34,254,728.07 2,974,545.97
Retained earnings beginning of year 37,229,274.04 34,254,728.07 2,974,545.97
Adjustments 0.00 0.00 0.00
238800 Preferred Stock Div. Dec. 0.00 (29,260.80) 29,260.80
Preferred stock dividend 0.00 (29,260.80) 29,260.80
438000 Div.Declared-Common Stock (2,800,000.00) (1 ,800,000.00) (1,000,000.00)
Common stock dividend (2,800,000.00) {1,800,000.00) (1,000,000.00)
403000 Depreciation (4,493,483.68) (4,355,942.62) (137,541.06)
405000 Amortiz.of Other Util.Plant (51,113.17) (51,113.17) 0.00
406000 Amort.of Util.Plt.Acq Adj (13,411.56) (17,129.56) 3,718.00
408120 Real Estate Tax (1,252,238.66) (1,005,639.86) (246,598.80)
408130 Payroll Taxes:FICA Employer (306,526.48) (335,422.48) 28,896.00
408131 Payroll Taxes:SUI Employer (9,760.45) (10,202.52) 442.07
408134 Payroll Taxes:FUI Employer (5,884.97) (6,200.03) 315.06
408139 Payroll Taxes (62.56) 0.00 (62.56)
409100 Federal Income Tax (3,195,573.00) (2,112,584.90) (1,082,988.10)
409200 State Income Taxes (391,627.36) (280,816.25) (110,811.11)
410100 Def.Inc.Tax Exp.-Fed. 12,790.00 0.00 12,790.00
410150 Def.Inc.Tax Exp.-State 1,523.00 0.00 1,523.00
410200 Def. lnc.Tx,Ot. Inc.& Ded (279,940.00) (416,001.00) 136,061.00
412100 ITC, Def.to Future Periods 40,379.00 42,407.00 (2,028.00)
415000 Revenues from M & J 61,726.32 47,132.85 14,593.47
416000 Costs and Expen.of M & J (11 ,921 .06) (7,387.09) (4,533.97)
419000 lnterco. Inter.& Div. Inc 426,843.00 541,441.00 (114,598.00)
419009 Interest-Other 5,287.05 2,343.00 2,944.05
420010 AFUDC-Debt 16,607.49 27,631.90 (11,024.41)
420020 AFUDC-Equity 28,587.37 49,593.89 (21 ,006.52)
421000 Other Income 13,792.85 8,222.00 5,570.85
422000 (Gains)Loss/Dispos.of Prop. 10,754.00 54,493.00 (43,739.00)
426000 Misc.Inc. Deductions 0.00 (7,914.00) 7,914.00
426020 Penalties 0.00 (824.00) 824.00
426510 Other Deductions (5,041.14) (1,127.25) (3,913.89)
430000 Inter.on Debt to Assoc.Co. (4,495,844.00) (4,425,302.00) (70,542.00)
431000 Other Interest Expense 0.00 (269.00) 269.00
461100 Mtrd Sales to Resid.Cust 19,903,349.20 18,275,947.08 1,627,402.12
461200 Mtrd Sales to Comm.Gust 9,082,890.63 8,550,222.28 532,668.35
461400 Mtrd Sales/Public Auth. 201 ,016.90 153,177.48 47,839.42
462000 Priv.Fire Prat. Service 446,063.58 446,321.21 (257.63)
471000 Misc. Service Revenues 141,450.36 133,928.26 7,522.10
471070 Gross Revenue Contracts 4,093.00 (21,636.00) 25,729.00
472000 Rents from Water Property 43,522.50 24,838.28 18,684.22
474900 Unbilled Revenue 49,431.00 246,771.00 (197,340.00)
600000 Operation Sup.& Engin-SOS (22,615.76) (18,829.05) (3,786.71)
601000 Operation Labor & Exp.-SOS (5,473.13) (5,670.79) 197.66
602000 Purchased Water (161,177.15) (45,047.68) (116,129.47)
603000 Misc.Expenses-SOS (3,324.83) (66,633.34) 63,308.51
604000 Rents-SOS (552.00) (552.00) 0.00
610000 Maint.Superv.& Engin.-SOS 0.00 (282.31) 282.31
612000 Maint.of Coll.&lmp.Reser. 0.00 (17.01) 17.01
.
Report ID: UWGLW800
Business Unit: 060
Period Ending: Dec 31, 2001
613000 Maint.Lake,River & Intakes
614000 Main!. of Wells & Springs
620000 Oper.Sup.& Eng.-Pumping
623000 Fuel/ Power Purch.for Pump.
624000 Pumping Labor and Expenses
626000 Misc. Expenses-Pumping
630000 Main!. Sup.& Engin.-Pump
631000 Maint.of Str.& lmpr.-Pump
632000 Main!. Power Prod. Equip.
633000 Main!. of Pump.Equip-Water
640000 Oper.Sup.& Eng.-Water Trea
641000 Chemicals-Water Treatment
642000 Oper.Labor & Exp.-Water Tr
643000 Misc.Expenses-Water Treat.
650000 Main!. Sup.& Eng.-Wat.Tre
651000 Maint.of Struct.& lmprov.
652000 Maint.ofWtr Treat.Equip.
660000 Oper.Sup.& Eng.-T&D
661000 Storage Fae. Expenses
662000 T & D Lines Expenses
663000 Meter Expenses-T&D
664000 Gust.Installations Exp.
665000 Misc.Expenses-T&D
670000 Main!. Superv.& Engin.-T&D
671000 Maint.Str.& lmp.-T&D
672000 Maint.Dist.Reserv.&Stand.
673000 Maint.Trans.& Dist. Mains
675000 Maintenance of Services
676000 Maintenance of Meters
677000 Maintenance of Hydrants
678000 Maint.of Misc. Plant
901000 Superv.Customer Accts. Ex.
902000 Meter Reading Salaries
902100 Meter Reading Expenses
902110 Meter Reading Transp.
902120 Meter Reading Other
903000 Gust.Rec.& Col.Ex.-Labor
903010 Gust.Rec.& Col.Ex.-Supplies
903020 Gust.Rec.& Col.Ex.-Postage
903030 Gust.Rec.& Col.-0/S Computer
903040 Gust.Rec.& Col.E-0/S Collect.
903050 Gust.Rec.& Col.Expense
904000 Uncollectible Accounts
905000 Misc.Customer Accts Exp
910000 Sales Promotion Expenses
920000 A&G Salaries
921000 Office Supplies & Other
921110 Dues and Subscriptions
921120 Telephone
921130 Postage and Air Freight
921200 Auto Expense
921206 Mileage Imputed Inc.
921210 Air Transportation
921220 Rail, Taxi, Car Rental
921230 Lodging
921240 Other Travel
921250 Meals
921300 Club Dues (non-tax)
921400 IT Supplies and Expenses
921406 IT Exp.-Legacy Sys.Support
921901 Proposal Costs
United Water Idaho
General Ledger System
BALANCE SHEET
Page No. 5 of 8
Run Date: 04/05/2002
Run Time: 9:56 AM
-Current Month -
Last This
..fiar.
Increase
or
0.00
(62,841.38)
(99,576.28)
(1 ,153,497.96)
(385,196.20)
(28,938.94)
(3,756.69)
(99,829.51)
(4,782.63)
(264,219.92)
(18,329.84)
(323,867.80)
(243,455.55)
(3,968.50)
(6,412.03)
(63,643.65)
(35,238.77)
(40,470.01)
(15,191.00)
(376,314.40)
(148,055.04)
(232.39)
(32,523.48)
(46,314.49)
(673.51)
(9,347.45)
(288,742.57)
(280,343.82)
(11 ,910.21)
(1,119.06)
(6,188.01)
(93,709.98)
(202,293.71))
(10,871 .34)
(45,547.38)
(73.34)
(374,886.68)
(2,644.63)
(133,043.17)
(488,660.96)
(78,428.54)
(50,833.41)
(102,768.53)
(1 ,263.94)
(13,263.13)
(746,776.98)
(81 ,682.46)
(15,229.88)
(94,328.95)
(14,904.49)
(33,138.07)
0.01
(9,256.91)
(1,174.21)
(5,683.39)
(737.79)
(7,169.27)
(6,342.00)
(31,785.17)
(11,817.00)
(666.58)
..fiar.
(10,152.57)
(107,255.11)
(97,474.35)
(1,103,273.32)
(443,666.75)
(37,808.52)
(30,356.57)
(102,064.73)
(4,957.34)
(268,905.26)
(47,583.55)
(292,356.16)
(219,040.39)
(19,177.52)
(8,211.67)
(58,319.80)
(11 ,515.15)
(61,817.53)
(13,673.05)
(494,733.74)
(137,566.41)
(233.68)
(16,876.83)
(45,937.30)
0.00
(21 ,224.45)
(375,817.43)
(243,721 .13)
(5,516.29)
(1,153.32)
(8,616.32)
(105,402.83)
(224,030.96)
(9,661.90)
(41,053.35)
(1,960.51)
(394,305.65)
(5,363.01)
(142,387.91)
(418,534.13)
(58,786.18)
(62,019.57)
(87,971 .09)
(7,886.45)
(31,205.84)
(827,631 .63)
(73,210.37)
(16,110.49)
(86,648.71)
(19,555.11)
(37,166.75)
0.06
(20,051.69)
(1,530.41)
(7,847.76)
(909.20)
(10,475.95)
(25,224.97)
(18,703.63)
(12,942.50)
0.00
(Decrease>
10,152.57
44,413.73
(2,101.93)
(50,224.64)
58,470.55
8,869.58
26,599.88
2,235.22
174.71
4,685.34
29,253.71
(31,511.64)
(24,415.16)
15,209.02
1,799.64
(5,323.85)
(23,723.62)
21,347.52
(1 ,517.95)
118,419.34
(10,488.63)
1.29
(15,646.65)
(377.19)
(673.51)
11 ,877.00
87,074.86
(36,622.69)
(6,393.92)
34.26
2,428.31
11,692.85
21 ,737.25
(1,209.44)
(4,494.03)
1,887.17
19,418.97
2,718.38
9,344.74
(70,126.83)
(19,642.36)
11,186.16
(14,797.44)
6,622.51
17,942.71
80,854.65
(8,472.09)
880.61
(7,680.24)
4,650.62
4,028.68
(0.05)
10,794.78
356.20
2,164.37
171.41
3,306.68
18,882.97
(13,081.54)
1,125.50
(666.58)
Report ID: UWGLWBOO United Water Idaho Page No. 6 of 8 Business Unit: 060 General Ledger System Run Date: 04/05/2002
Period Ending: Dec 31, 2001 BALANCE SHEET Run Time: 9:56 AM
-Current Month -Increase
This Last or
~ ~ (Der;.re.a.~ft.l
922000 G&A Expense Transferred 657,413.25 420,479.94 236,933.31
922001 Overheads Transf. 5,710.17 19,005.68 (13,295.51)
923000 Outside Services (63,761 .56) (61,421 .22) (2,340.34)
923010 0/S-M&S Fees (1 ,147,040.14) (1,547,376.64) 400,336.50
923020 0/S-Administration (27,635.16) (19,574.17) (8,060.99)
923050 0/S-Auditing/ Accounting (31,126.01) (38,592.06) 7,466.05
923080 Outside Services-Legal (80,539.18) (49,217.40) (31,321 .78)
923090 0/S-Personnel Recruitment (3,611.70) (860.00) (2,751.70)
923140 0/S-lnfo. Technology (249,986.43) (318,205.92) 68,219.49
923800 Temporary Help (7,446.89) (8,962.30) 1,515.41
924000 Property Insurance (36,696.00) (32,183.20) (4,512.80)
924090 General Corp. Insurance (313,256.51) (214,546.00) (98,710.51)
925000 Injuries and Damages A&G Inter (142,615.00) (130,744.07) (11,870.93)
925010 Injuries & Damages A&G Externa (3,090.43) (2,983.84) (106.59)
926000 Employee Pension Cost 59,872.00 199,474.00 (139,602.00)
926105 PEBOP Accrued -Non-Bargaining (381,625.00) (272,767.00) (108,858.00)
926106 PE BOP-Bargaining (309,108.00) (248,398.00) (60,710.00)
926110 PE BOP-Amortized (40,624.29) (40,571.99) (52.30)
926115 PEBOP-Transfers (270.34) (32.22) (238.12)
926152 Pension-Assoc. Companies 660.16 109.38 550.78
926500 Employee Ben-Med/Den Insur (548,619.35) (442,723.39) (105,895.96)
926540 Employee Ben-MIP Options (16,444.00) (20,935.73) 4,491.73
926550 Employee Ben-Tuition aid (34,317.56) (10,671.88) (23,645.68)
926590 Employee Ben-Other (157,321 .00) (92,331 .32) (64,989.68)
926600 Admin.Fee:Benefits (49,274.27) (28,703.71) (20,570.56)
926610 Group Life Insurance (40,667.67) (50,237.00) 9,569.33
926640 LTD-Other (14,557.74) (12,495.22) (2,062.52)
926700 Thrift Plan (86,160.66) (83,034.00) (3,126.66)
928000 Regulatory Commission Ex. (80,174.99) (74,067.40) (6,107.59)
928100 Amortization-Reg. Comm. Ex. (6,996.00) (6,996.00) 0.00
928130 Amortization-Rate Case Ex (158,340.00) (119,451.00) (38,889.00)
930000 Marketing Expense (4,648.16) 1,412.78 (6,060.94)
930020 Investor Relations (451.25) (23,077.10) 22,625.85
930100 Instil.or Goodwill Advert. (12,100.90) (5,420.95) (6,679.95)
930200 Other Misc.General Expense (31,414.15) (28,333.21) (3,080.94)
930300 Contributions (3,185.00) (4,350.00) 1,165.00
930306 Staff Mtgs, Cont.& Seminars (24,213.22) (39,758.77) 15,545.55
930310 Employee Relocation (25,668.00) (27,839.73) 2,171.73
930340 Comm.& Government Affairs (315.00) 0.00 (315.00)
930350 Fees, Chgs & Corp. Dues (52,217.00) (52,879.00) 662.00
932000 Gen. Off.-Maintenance (73,879.89) (65,747.50) (8,132.39)
932110 Gen. Off.-Utilities 0.00 (3.00) 3.00
Current year earnings 5,534,830.45 4,839,331.43 695,499.02
Total retained earnings 39,964,104.49 37,264,798.70 2,699,305.79
Long term debt
Long-term debt -bonds 0.00 0.00 0.00
Advances from associated companies 0.00 0.00 0.00
Other long-term debt 0.00 0.00 0.00
Total long term debt 0.00 0.00 0.00
Total capitalization 107,334,684.70 104,656,525.97 2,678,158.73
Minority interest 0.00 0.00 0.00
Current liabilities
Notes payable 0.00 0.00 0.00
Long-term debt due within one year 0.00 0.00 0.00
232000 Accounts Payable-Sys Generated 9,514.03 11,617.14 (2,103.11)
232001 A/P Inventory -Sys Generated 21,816.80 21,789.20 27.60
232003 A/P-Contractor Retainage 21,254.58 58,015.37 (36,760.79)
Report ID: UWGLW800 United Water Idaho Page No. 7 of 8
Business Unit: 060 General Ledger System Run Date: 04/05/2002
Period Ending: Dec 31, 2001 BALANCE SHEET Run Time: 9:56 AM
-Current Month -Increase
This Last or
1ML ..fiaL (D~c.re.a~e.l
232010 Offsite Funds Payable 3,449.10 34,122.96 (30,673.86)
232054 NP-Accrued (Misc) 282,124.81 393,362.41 (111 ,237.60)
Accounts payable 338,159.32 518,907.08 (180,747.76)
Notes payable -associated companies 0.00 0.00 0.00
Accounts payable -associated companies 0.00 0.00 0.00
Customer deposits 0.00 0.00 0.00
236001 Accrued Real Estate Taxes 625,660.00 608,477.69 17,182.31
236002 Accrued Franchise Taxes 41 ,556.46 40,796.78 759.68
236006 Sales and Use Tax-State 13,045.50 910.33 12,135.17
236200 Accrued FIT 447,762.00 (523,108.10) 970,870.10
236306 Accrued FIT-Gross Up (82,998.00) (14,808.00) (68,190.00)
236307 Accrued SIT 91,013.52 77,232.16 13,781.36
236313 Accrued SIT-Gross Up (10,150.00) (1,944.00) (8,206.00)
236402 FICA-Employer 6,992.84 5,883.83 1,109.01
Accrued taxes 1,132,882.32 193,440.69 939,441.63
Accrued interest on long-term debt 0.00 0.00 0.00
Other interest 0.00 0.00 0.00
238000 Dividends Declared 5,870.83 6,046.67 (175.84)
Dividends declared 5,870.83 6,046.67 (175.84)
242001 Accrued Payroll 91,409.00 76,914.00 14,495.00
242005 Employee:United Way 377.00 676.00 (299.00)
242008 Employee:401 K Withholding 29,703.18 43,008.17 (13,304.99)
242009 Employee:Garnishments 230.76 190.14 40.62
242012 Accident Insur. Withheld (10.49) 866.36 (876.85)
242013 Health Plan Costs Withheld 20.15 0.00 20.15
242014 Union Dues Withheld 1,150.00 0.00 1,150.00
242015 Life Insurance Withheld 584.11 0.00 584.11
242019 Misc.Employee Withholdings 15,617.75 17,381 .09 (1 ,763.34)
242020 Employee: Met Life Withheld 71.36 51 .69 19.67
242030 Accrued MI P Dividend 21 ,630.66 5,186.66 16,444.00
242032 Accrued Vanguard Clearing 7,370.46 9,172.59 (1 ,802.13)
242033 Accrued Stock Options 7,968.67 7,968.67 0.00
242201 Accrued Power 101,673.00 106,385.00 (4,712.00)
Other current liabilities 277,795.61 267,800.37 9,995.24
Total current & accrued liabilities 1,754,708.08 986,194.81 768,513.27
Deferred credits & other liabilities
190101 Def.FIT-FAS 109 ITC (454,218.00) (466,309.00) 12,091.00
190102 Def.FIT-FAS 109 G/U ITC (244,581 .00) (251,086.00) 6,505.00
190103 Def.FIT-FAS 109 OtDed. (51,970.00) (261 ,587.00) 209,617.00
190104 Def FIT-FAS 109 G/U OtDed. (27,984.00) (140,850.00) 112,866.00
190201 Def.SIT-FAS 109 ITC (113,708.00) (116,737.00) 3,029.00
190202 Def.SIT-FAS 109 G/U ITC (9,882.00) (10,147.00) 265.00
190203 Def.SIT-FAS 109 OtDed. (359,998.00) (347,767.00) (12,231 .00)
190204 Def.SIT-FAS 109 G/U OtDed. (31 ,302.00) (30,238.00) (1 ,064.00)
190603 Val.Allow DSIT-FAS 109 OtDed. 657,525.00 657,525.00 0.00
255000 Deferred Invest.Tax Credits 1,424,197.00 1,464,576.00 (40,379.00)
282001 Accum.DFIT-ACRS 2,278,458.00 2,414,179.00 (135,721 .00)
282002 Accum.DFIT-MACRS 2,039,708.00 1,572,617.00 467,091 .00
282010 DFIT-ADR 479,928.00 488,455.00 (8,527.00)
282101 Def FIT-FAS 109-Plant (1,953,341.00) (1,934,282.00) (19,059.00)
282102 Def FIT-FAS 109-Rate Exp. (3,886.00) (8,820.00) 4,934.00
282103 Def FIT-FAS 109-Tank Paint (2,350.00) (1,850.00) (500.00)
282104 Def FIT-FAS 109-Pension (95,260.00) (51 ,896.00) (43,364.00)
282106 Def FIT-FAS 109-Def Chg 8,172.00 10,903.00 (2,731.00)
282121 Def FIT-FAS 109 GU-Plant (1,051 ,797.00) (1 ,041,536.00) (10,261.00)
282122 Def FIT-FAS 109 GU Rate Ex (2,098.00) (4,754.00) 2,656.00
282123 Def FIT-FAS 109 GU Tank Paint (1 ,269.00) (997.00) (272.00)
282124 Def FIT-FAS 109 GU Pensions (51 ,297.00) (27,947.00) (23,350.00)
282126 Def FIT-FAS 109 GU Def Charges 4,403.00 5,869.00 (1 ,466.00)
282141 Def SIT-FAS 109-Plant 988,180.00 984,693.00 3,487.00
Report ID: UWGLW800
Business Unit: 060
Period Ending: Dec 31, 2001
282142 Def SIT-FAS 109-Rate Expen
282143 Def SIT-FAS 109-Tank Paint
282144 Def SIT-FAS 109-Pension
282146 Def SIT-FAS 109-Def Charges
282161 Def SIT-FAS 109 GU-Plant
282162 Def SIT-FAS 109 GU Rate Ex
282163 Def SIT-FAS 109 GU Tank Paint
282164 Def SIT-FAS 109 GU Pensions
282166 Def SIT-FAS 109 GU DefChar
283300 Def.Federal Income Taxes
283306 Def FIT-Def. Comp.
283610 Def FIT-Tank Painting
283700 Def FIT-Pensions
283702 Def FIT-PEBOP
283720 Def FIT-Rate Expenses
283725 Def FIT-Def. Charges
283731 Defer.FIT-Relocation Expense
283800 Def. SIT
283991 Def. FIT-AFUDC Equity
Deferred income taxes and investment tax credits
252000 Advances for Construction
Customer advances for construction
271000 CIAC
272000 Accum. Amor!. of CIAC
Contribution in aid of construction
Injuries and Damages
263000 Pensions &Benefits Reserve
Pension and benefits
253103 Def Vacation
253104 Escheats Payable
253108 Def Advances & Contrib G/U
253109 Def. M&J
253610 PBOP-NB-Liab-Trustee
253611 PBOP-Barg.-Liab-Trustee
253905 DfReg.Liab.FAS109-Fed:ITC
253908 DfRgliab.FAS109-Fed:Oth De
253915 DfReg.Liab.FAS109-St:ITC
253918 DfRgliab.FAS109-St:Oth Ded
253925 Def Reg.Liab.GU FAS109-Fed:ITC
253928 DfRegliab.GU FAS109-Fed:0De
253935 DfRgliab.GU FAS109-St:ITC
253938 DfRgliab.GU FAS109-St:0Ded
Other deferred credits and liabilities
Total deferred credits & other liabilities
Total capitalization and liabilities
United Water Idaho
General Ledger System
BALANCE SHEET
Page No. 8 of 8
Run Date: 04/05/2002
Run Time: 9:56 AM
-Current Month -Increase
This Last or
Year ~ (De,rea.~e.l
10,227.00 23,185.00 (12,958.00)
6,179.00 4,863.00 1,316.00
(19,825.00) (1,568.00) (18,257.00)
17,866.00 25,802.00 (7,936.00)
85,933.00 85,620.00 313.00
888.00 2,019.00 (1,131.00)
535.00 421.00 114.00
(1,728.00) (135.00) (1,593.00)
1,552.00 2,246.00 (694.00)
(224,111 .00) (211,321 .00) (12,790.00)
130,565.00 0.00 130,565.00
30,704.00 24,407.00 6,297.00
92,468.00 113,397.00 (20,929.00)
(424,506.00) (246,936.00) (177,570.00)
25,589.00 81,008.00 (55,419.00)
154,712.00 61,466.00 93,246.00
32,699.00 35,795.00 (3,096.00)
(1,523.00) 0.00 (1,523.00)
299,861.00 289,855.00 10,006.00
3,643,715.00 3,192,138.00 451,577.00
7,173,309.13 6,073,128.04 1,100,181.09
7,173,309.13 6,073,128.04 1,100,181.09
43,180,775.75 37,598,384.88 5,582,390.87
(5,674,183.34) (4,838,328.80) (835,854.54)
37,506,592.41 32,760,056.08 4,746,536.33
0.00 0.00 0.00
145,880.00 145,880.00 0.00
145,880.00 145,880.00 0.00
3,883.97 4,252.17 (368.20)
9,810.06 13,550.85 (3,740.79)
2,332,418.00 2,358,421.00 (26,003.00)
392,800.19 215,292.11 177,508.08
2,647,477.20 1,447,731.91 1,199,745.29
0.00 175,235.29 (175,235.29)
454,218.00 466,309.00 (12,091.00)
51,970.00 261 ,587.00 (209,617.00)
113,708.00 116,737.00 (3,029.00)
(244,925.00) (257,156.00) 12,231.00
244,581.00 251 ,086.00 (6,505.00)
27,984.00 140,850.00 (112,866.00)
9,882.00 10,147.00 (265.00)
(21,300.00) (22,364.00) 1,064.00
6,022,507.42 5,181,679.33 840,828.09
54,492,003.96 47,352,881.45 7,139,122.51
163,581,396.74 152,995,602.23 $10,585,794.51
Report ID: UWGLW701 United Water Idaho Page No. 1 of 4 •
Business Unit: 060 General Ledger System Run Date: 04/05/2002
Period Ending: Dec 31, 2001 STATEMENT OF INCOME Run Time: 9:56 AM
• Current Month· • Year to Date·
Prior Variance to Plan Prior Variance to Plan
Year Actual Plan Amount Percent Year Actual Plan Amount Percent
Operating revenues
461100 Mtrd Sales to Resid. Gust 1,058,456.95 1,116,232.22 1,066,300.00 49,932.22 4.68% 18,275,947.08 19,903,349.20 18,357,300.00 1,546,049.20 8.42%
Residential customers $1,058,456.95 $1,116,232.22 $1,066,300.00 $49,932.22 4.68% $18,275,947.08 $19,903,349.20 $18,357,300.00 $1,546,049.20 8.42%
461200 Mtrd Sales to Comm.Gust 536,681.90 544,080.59 541 ,356.00 2,724.59 0.50% 8,550,222.28 9,082,890.63 8,437,204.00 645,686.63 7.65%
Commercial customers 536,681.90 544,080.59 541,356.00 2,724.59 0.50% 8,550,222.28 9,082,890.63 8,437,204.00 645,686.63 7.65%
Industrial customers 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00%
461400 Mtrd Sales/Public Auth. 2,192.37 8,187.84 3,300.00 4,887.84 148.12% 153,177.48 201,016.90 150,800.00 50,216.90 33.30%
Public authorities 2,192.37 8,187.84 3,300.00 4,887.84 148.12% 153,177.48 201,016.90 150,800.00 50,216.90 33.30%
462000 Priv.Fire Prat. Service 49,539.43 50,305.67 45,200.00 5,105.67 11 .30% 446,321.21 446,063.58 513,100.00 (67,036.42) -13.06%
Fire protection 49,539.43 50,305.67 45,200.00 5,105.67 11.30% 446,321.21 446,063.58 513,100.00 (67,036.42) -13.06%
Sale for resale 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00%
lntercompany revenue 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00%
471000 Misc. Service Revenues 9,090.53 16,643.80 8,100.00 8,543.80 105.48% 133,928.26 141,450.36 93,400.00 48,050.36 51.45%
471070 Gross Revenue Contracts 0.00 0.00 0.00 0.00 0.00% (21 ,636.00) 4,093.00 0.00 4,093.00
472000 Rents from Water Property 1,938.08 4,298.71 2,200.00 2,098.71 95.40% 24,838.28 43,522.50 25,400.00 18,122.50 71 .35%
474000 Other Water Revenues 0.00 0.00 107,500.00 (107,500.00) -100.00% 0.00 0.00 2,069,000.00 (2,069,000.00) -100.00%
474900 Unbilled Revenue (584,417.00) (349,729.00) (256,700.00) (93,029.00) 36.24% 246,771 .00 49,431 .00 34,600.00 14,831.00 42.86%
Other revenue (573,388.39) (328,786.49) !138,900.00) (189,886.49) 136.71% 383,901.54 238,496.86 2,222,400.00 (1,983,903.14) -89.27%
Total operating revenues 1,073,482.26 1,390,019.83 1,517,256.00 (127,236.17) -8.39% 27,809,569.59 29,871,817.17 29,680,804.00 191 ,013.17 0.64%
Operating expenses:
600000 Operation Sup.& Engin-SOS 1,700.53 2,055.69 187.09 1,868.60 998.77% 18,829.05 22,615.76 2,302.26 20,313.50 882.33%
601000 Operation Labor & Exp. -SOS 1,976.91 533.18 500.00 33.18 6.64% 5,670.79 5,473.13 9,300.00 (3,826.87) -41 .15%
602000 Purchased Water 1,608.88 63,935.00 0.00 63,935.00 45,047.68 161,177.15 103,068.00 58,109.15 56.38%
603000 Misc.Expenses-SOS 2,690.67 138.30 0.00 138.30 66,633.34 3,324.83 0.00 3,324.83
604000 Rents-SOS 46.00 46.00 46.00 0.00 0.00% 552.00 552.00 552.00 0.00 0.00%
620000 Oper.Sup.& Eng.-Pumping 4,579.72 10,322.77 7,545.20 2,777.57 36.81% 97,474.35 99,576.28 100,237.35 (661.07) -0.66%
623000 Fuel/ Power Purch.for Pump. 60,144.38 63,870.71 43,652.00 20,218.71 46.32% 1,103,273.32 1,153,497.96 989.424.00 164,073.96 16.58%
624000 Pumping Labor and Expenses 31,338.76 33,261.48 36,288.19 (3,026.71) -8.34% 443,666.75 385,196.20 434,421.59 (49,225.39) -11.33%
626000 Misc.Expenses-Pumping 1,940.42 3,677.19 2,966.67 710.52 23.95% 37,808.52 28,938.94 54,310.04 (25,371.10) -46.72%
640000 Oper.Sup.& Eng.-Water Trea 1,630.30 (238.98) 626.63 (865.61) -138.14% 47,583.55 18,329.84 8,862.06 9,467.78 106.83%
641000 Chemicals-Water Treatment 16,170.93 19,471.97 16,093.00 3,378.97 21 .00% 292,356.16 323,867.80 295,216.00 28,651.80 9.71%
642000 Oper.Labor & Exp.-Water Tr 11,118.35 15,692.98 14,368.00 1,324.98 9.22% 219,040.39 243,455.55 223,522.96 19,932.59 8.92%
643000 Misc. Expenses-Water Treat. 2,845.94 239.04 1,287.09 (1,048.05) -81.43% 19,177.52 3,968.50 16,882.26 (12,913.76) -76.49%
660000 Oper.Sup.& Eng.-T&D 5,576.53 3,388.47 3,382.26 6.21 0.18% 61 ,817.53 40,470.01 32,251.22 8,218.79 25.48%
661000 Storage Fae. Expenses 1,134.77 1,545.77 721.00 824.77 114.39% 13,673.05 15,191.00 9,052.00 6,139.00 67.82%
662000 T & D Lines Expenses 57,638.66 30,718.08 34,900.59 (4,182.51) -11 .98% 494,733.74 376,314.40 458,204.46 (81,890.06) -17.87%
663000 Meter Expenses-T&D (2,279.27) 12,592.16 29,434.44 (16,842.28) -57.22% 137,566.41 148,055.04 346,350.04 (198,295.00) -57.25%
664000 Gust.Installations Exp. 0.00 0.00 0.00 0.00 0.00% 233.68 232.39 1,400.00 (1,167.61 ) -83.40%
665000 Misc.Expenses-T&O 1,097.09 3,843.48 1,100.00 2,743.48 249.41% 16,876.83 32,523.48 19,415.88 13,107.60 67.51%
Operation 200,959.57 265,093.29 193,098.16 71,995.13 37.28% 3,122,014.66 3,062,760.26 3,104,772.12 (42,011.86) -1.35%
610000 Ma int. Superv.& Engin.-SOS 0.00 0.00 0.00 0.00 0.00% 282.31 0.00 0.00 0.00 0.00%
612000 Maint.of Coll.&lmp.Reser. 0.00 0.00 0.00 0.00 0.00% 17.01 0.00 0.00 0.00 0.00%
613000 Maint.Lake,River & Intakes 618.75 0.00 0.00 0.00 0.00% 10,152.57 0.00 0.00 0.00 0.00%
614000 Main!. of Wells & Springs 17,334.43 1,817.89 900.00 917.89 101.99% 107,255.11 62,841.38 60,383.15 2,458.23 4.07%
630000 Main!. Sup.& Engin.-Pump (130.25) (178.00) 4,097.17 (4,275.17) -104.34% 30,356.57 3,756.69 50,393.81 (46,637.12) -92.55%
631000 Maint.of Str.& lmpr.-Pump 530.74 131.22 2,541.48 (2,410.26) -94.84% 102,064.73 99,829.51 108,844.50 (9,014.99) -8.28%
632000 Maint. Power Prod. Equip. 687.50 21.83 100.00 (78.17) -78.17% 4,957.34 4,782.63 3,700.00 1,082.63 29.26%
633000 Ma int. of Pump. Equip-Water 16,215.44 17,325.80 10,067.13 7,258.67 72.10% 268,905.26 264,219.92 229,764.91 34,455.01 1500%
650000 Maint. Sup.& Eng.-Wat.Tre 0.00 0.00 1,122.55 (1,122.55) -100.00% 8,211 .67 6,412.03 13,813.46 (7,401.43) -53.58%
651000 Maint.of Struct.& lmprov. 5,392.12 3,594.35 3,020.73 573.62 18.99% 58,319.80 63,643.65 34,878.32 28,765.33 82.47%
652000 Maint.of Wtr Treat.Equip. 285.96 1,836.67 2,337.61 (500.94) -21.43% 11 ,515.15 35,238.77 48,603.31 (13,364.54) -27.50%
670000 Maint. Superv.& Engin.-T&D 2,821.04 3,468.42 3,022.55 445.87 14.75% 45,937.30 46,314.49 36,378.67 9,935.82 27.31%
671000 Maint.Str.& Jmp.-T&D 0.00 0.00 0.00 0.00 0.00% 0.00 673.51 0.00 673.51
.•
Report ID: UWGLW701 United Water Idaho Page No. 2 of 4 ~
Business Unit: 060 General Ledger System Run Date: 04/0512002
Period Ending: Dec 31, 2001 STATEMENT OF INCOME Run Time: 9:56 AM
-Current Month --Year to Date -
Prior Variance to Plan Prior Variance to Plan
Year Actual Plan Amount Percent Year Actual Plan Amount Percent
672000 Maint.Dist.Reserv.&Stand. 258.00 517.33 633.64 (116.31) -18.36% 21,224.45 9,347.45 26,390.87 (17,043.42) -64.58%
673000 Maint.Trans.& Dist. Mains 50,165.47 13,943.20 23,318.34 (9,375.14) -40.21% 375,817.43 288,742.57 359,646.19 (70,903.62) -19.71%
675000 Maintenance of Services 10,268.19 22,704.39 25,056.90 (2,352.51) -9.39% 243,721.13 280,343.82 273,931 .11 6,412.71 2.34%
676000 Maintenance of Meters 17.09 (4.28) 0.00 (4.28) 5,516.29 11,910.21 2,900.00 9,010.21 310.70%
677000 Maintenance of Hydrants 57.30 253.94 0.00 253.94 1,153.32 1,119.06 1,800.00 (680.94) -37.83%
678000 Maint.of Misc. Plant 1,234.44 860.64 2,334.58 (1,473.94) -<l3.14% 8,616.32 6,188.01 28,941.34 (22,753.33) -78.62%
932000 Gen. Off.-Maintenance 6,496.53 8,152.68 (4,231 .00) 12,383.68 -292.69% 65,747.50 73,879.89 (47,872.00) 121,751 .89 -254.33%
932110 Gen. Off.-Utilities 0.00 0.00 0.00 0.00 0.00% 3.00 0.00 0.00 0.00 0.00%
Maintenance 112,252.75 74,446.08 74,321.68 124.40 0.17% 1,369,774.26 1,259,243.59 1,232,497.64 26,745.95 2.17%
901000 Superv.Customer Accts. Ex. (4,381.89) 8,535.00 6,334.23 2,200.77 34.74% 105,402.83 93,709.98 91,865.20 1,844.78 2.01%
902000 Meter Reading Salaries 15,820.35 17,559.05 21,585.78 (4,026.73) -18.65% 224,030.96 202,293.71 269,051.24 (66,757.53) -24.81 %
902100 Meter Reading Expenses 482.47 524.50 608.33 (83.83) -13.78% 9,661.90 10,871.34 11,099.96 (228.62) -2.06%
902110 Meter Reading Transp. 3,219.75 6,163.50 6,042.93 120.57 2.00% 41,053.35 45,547.38 72,515.16 (26,967.78) -37.19%
902120 Meter Reading Other 263.25 39.20 0.00 39.20 1,960.51 73.34 0.00 73.34
903000 Gust.Rec.& Col.Ex.-Labor 46,608.18 30,422.82 12,484.24 17,938.58 143.69% 394,305.65 374,886.68 157,327.11 217,559.57 138.28%
903010 Gust.Rec.& Col.Ex.-Supplies 1,098.56 1,419.60 0.00 1,419.60 5,363.01 2,644.63 11,900.00 (9,255.37) -77.78%
903020 Gust.Rec.& Col.Ex.-Postage 12,685.29 11,872.23 11,933.33 (61 .10) -0.51% 142,387.91 133,043.17 143,199.96 (10,156.79) -7.09%
903030 Gust.Rec.& Col.-OIS Computer 38,256.13 46,960.48 37,616.67 9,343.81 24.84% 418,534.13 488,660.96 451,800.04 36,860.92 8.16%
903040 Gust.Rec.& Col.E-OIS Collect. 7,851.85 4,778.29 5,600.00 (821.71) -14.67% 58,786.18 78,428.54 68,200.00 10,228.54 1500%
903050 Gust.Rec.& Col.Expense 2,257.93 2,871 .52 850.00 2,021.52 237.83% 62,019.57 50,833.41 14,850.00 35,983.41 242.31%
904000 Uncollectible Accounts (2,193.57) 3,865.16 7,000.00 (3,134.84) -44.78% 87,971.09 102,768.53 99,000.00 3,768.53 3.81%
905000 Misc.Customer Accts Exp (326.29) 0.00 0.00 0.00 0.00% 7,886.45 1,263.94 300.00 963.94 321.31%
910000 Sales Promotion Expenses 4,398.38 0.00 0.00 0.00 0.00% 31,205.84 13,263.13 28,200.00 (14,936.87) -52.97%
920000 A&G Salaries 68,742.41 54,205.95 66,149.24 (11,943.29) -18.06% 827,631.63 746,776.98 789,089.94 (42,312.96) -5.36%
920160 Employee Awards 0.00 0.00 875.00 (875.00) -100.00% 0.00 0.00 6,085.00 (6,085.00) -100.00%
921000 Office Supplies & Other 7,418.19 6,931.29 6,720.34 210.95 3.14% 73,210.37 81,682.46 87,144.08 (5,461.62) -<l.27%
921110 Dues and Subscriptions 562.25 208.25 400.00 (191.75) -47.94% 16,110.49 15,229.88 20,925.00 (5,695.12) -27.22%
921120 Telephone 7,838.17 5,920.33 7,650.00 (1,729.67) -22.61% 86,648.71 94,328.95 92,900.00 1,428.95 1.54%
921130 Postage and Air Freight 1,344.25 191.44 800.00 (608.56) -76.07% 19,555.11 14,904.49 23,100.00 (8,195.51) -35.48%
921200 Auto Expense 4,213.00 3,355.37 4,858.70 (1 ,503.33) -30.94% 37,166.75 33,138.07 54,187.15 (21 ,049.08) -38.85%
921206 Mileage Imputed Inc. (0.06) 0.00 0.00 0.00 0.00% (0.06) (0.01) 0.00 (0.01)
921210 Air Transportation 5,972.02 1,128.43 1,600.00 (471.57) -29.47% 20,051.69 9,256.91 15,700.00 (6,443.09) -41.04%
921220 Rail, Taxi, Car Rental 40.00 117.72 0.00 117.72 1,530.41 1,174.21 550.00 624.21 113.49%
921230 Lodging 315.51 (524.26) 1,800.00 (2,324.26) -129.13% 7,847.76 5,683.39 9,450.00 (3,766.61) -39.86%
921240 Other Travel 73.00 (65.85) 000 (65.85) 909.20 737.79 0.00 737.79
921250 Meals 1,429.64 1,016.05 1,483.33 (467.28) -31.50% 10,475.95 7,169.27 12,259.96 (5,090.69) -41.52%
921300 Club Dues (non-tax) 11,025.00 0.00 0.00 0.00 0.00% 25,224.97 6,342.00 0.00 6,342.00
921400 IT Supplies and Expenses 0.00 795.48 150.00 645.48 430.32% 18,703.63 31,785.17 40,100.00 (8,314.83) -20.74%
921406 IT Exp.-Legacy Sys.Support 2,480.00 0.00 900.00 (900.00) -100.00% 12,942.50 11,817.00 10,300.00 1,517.00 14.73%
921901 Proposal Costs 0.00 474.08 0.00 474.08 0.00 666.58 10,000.00 (9,333.42) -93.33%
922000 G&A Expense Transferred (42,568.20) (52,626.14) (3,086.23) (49,539.91) 1605.19% (420,479.94) (657,413.25) (54,758.06) (602,655.19) 1100.58%
922001 Overheads Transl. (980.69) 0.00 (34,648.38) 34,648.38 -100.00% (19,005.68) (5,710.17) (485,375.35) 479,665.18 -98.82%
923000 Outside Services 6,896.29 5,129.58 6,500.00 (1,370.42) -21.08% 61,421.22 63,761.56 98,200.00 (34,438.44) -35.07%
923010 OIS-M&S Fees 144,097.49 107,519.75 97,699.62 9,820.13 10.05% 1,547,376.64 1,147,040.14 1,270,195.56 (123,155.42) -9.70%
923020 OIS-Administration 485.00 2,000.00 200.00 1,800.00 900.00% 19,574.17 27,635.16 41 ,700.00 (14,064.84) -33.73%
923050 OIS-AuditinglAccounting 10,631.84 8,121.01 2,000.00 6,121.01 306.05% 38,592.06 31,126.01 24,600.00 6,526.01 26.53%
923080 Outside Services-Legal 5,015.00 6,824.70 6,400.00 424.70 6.64% 49,217.40 80,539.18 81,900.00 (1,360.82) -1.66%
923090 OIS-Personnel Recruitment 0.00 72.00 0.00 72.00 860.00 3,611.70 1,050.00 2,561.70 243.97%
923140 OIS-lnfo. Technology 14,266.58 17,452.88 16,100.00 1,352.88 8.40% 318,205.92 249,986.43 259,400.00 (9,413.57) -3.63%
923800 Temporary Help 592.01 299.17 0.00 299.17 8,962.30 7,446.89 0.00 7,446.89
924000 Property Insurance 2,575.00 3,058.00 3,100.00 (42.00) -1.35% 32,183.20 36,696.00 36,700.00 (4.00) -0.01%
924090 General Corp. Insurance 17,817.00 82,458.00 19,400.00 63,058.00 325.04% 214,546.00 313,256.51 233,200.00 80,056.51 34.33%
925000 Injuries and Damages A&G Inter 10,290.65 11,250.00 11,200.00 50.00 0.45% 130,744.07 142,615.00 135,000.00 7,615.00 5.64%
925010 Injuries & Damages A&G Externa 86.30 0.00 100.00 (100.00) -100.00% 2,983.84 3,090.43 1,200.00 1,890.43 157.54%
926000 Employee Pension Cost (26,912.00) 31 ,550.00 (8,398.75) 39,948.75 -475.65% (199,474.00) (59,872.00) (100,785.00) 40,913.00 -40.59%
926105 PEBOP Accrued -Non-Bargaining 43,259.00 30,155.00 30,234.41 (79.41) -0.26% 272,767.00 381,625.00 362,813.00 18,812.00 5.19%
-.
Report ID: UWGLW701 United Water Idaho Page No. 3 of 4 .. Business Unit: 060 General Ledger System Run Date: 04/05/2002
Period Ending: Dec 31, 2001 STATEMENT OF INCOME Run Tlme: 9:56 AM
-Current Month --Year to Date·
Prior Variance to Plan Prior Variance to Plan
Year Actual Plan Amount Percent Year Actual Plan Amount Percent
926106 PEBOP-Bargaining 20,699.00 25,759.00 26,735.00 (976.00) -3.65% 248,398.00 309,108.00 320,820.00 (11,712.00) -3.65%
926110 PEBOP-Amortized 3,380.00 3,400.78 3,400.00 0.78 0.02% 40,571.99 40,624.29 40,600.00 24.29 0.06%
926115 PEBOP-Transfers 0.00 80.60 0.00 80.60 32.22 270.34 0.00 270.34
926152 Pension-Assoc. Companies 0.00 (214.47) 0.00 (214.47) (109.38) (660.16) 0.00 (660.16)
926500 Employee Ben-Med/Oen Insur 34,414.34 54,757.65 42,200.00 12,557.65 29.76% 442,723.39 548,619.35 506,800.00 41,819.35 8.25%
926540 Employee Ben-MIP Options 4,099.98 3,859.20 5,000.00 (1,140.80) -22.82% 20,935.73 16,444.00 20,300.00 (3,856.00) -19.00%
926550 Employee Ben-Tuition aid 2,632.08 4,274.04 2,389.42 1,884.62 78.87% 10,671.88 34,317.56 26,899.75 7,417.81 27.58%
926590 Employee Ben-Other 34,123.05 18,022.27 21,650.00 (3,627.73) -16.76% 92,331.32 157,321.00 176,100.00 (18,779.00) -10.66%
926600 Admin.Fee:Benefits (3,616.36) 28,170.71 2,800.00 25,370.71 906.10% 28,703.71 49,274.27 17,200.00 32,074.27 186.48%
926610 Group Life Insurance 4,021.00 3,645.78 3,400.00 245.78 7.23% 50,237.00 40,667.67 40,800.00 (132.33) -0.32%
926640 LTD-Other 1,081.00 1,301.58 1,200.00 101.58 8.46% 12,495.22 14,557.74 13,900.00 657.74 4.73%
926700 Thrift Plan 9,172.59 7,384.25 7,272.00 112.25 1.54% 83,034.00 86,160.66 89,707.00 (3,546.34) -3.95%
928000 Regulatory Commission Ex. 6,313.00 0.00 0.00 0.00 0.00% 74,067.40 80,174.99 78,000.00 2,174.99 2.79%
928100 Amortization-Reg. Comm. Ex. 583.00 583.00 583.00 0.00 0.00% 6,996.00 6,996.00 6,996.00 0.00 0.00%
928130 Amortization-Rate Case Ex 13,195.00 13,195.00 13,195.00 0.00 0.00% 119,451.00 158,340.00 158,340.00 0.00 0.00%
930000 Marketing Expense 0.00 4,493.16 250.00 4,243.16 1697.26% (1,412.78) 4,648.16 5,500.00 (851.84) -15.49%
930020 Investor Relations 0.00 0.00 0.00 0.00 0.00% 23,077.10 451.25 0.00 451.25
930100 Instil.or Goodwill Advert. 439.85 629.70 350.00 279.70 79.91% 5,420.95 12,100.90 4,200.00 7,900.90 188.12%
930200 Other Misc.General Expense 5,152.44 2,244.61 (2,241.00) 4,485.61 -200.16% 28,333.21 31,414.15 (8,992.00) 40,406.15 -449.36%
930300 Contributions 600.00 0.00 800.00 (800.00) -100.00% 4,350.00 3,185.00 9,600.00 (6,415.00) -<l6.82%
930306 Staff Mtgs, Cont.& Seminars (1,878.60) 8,492.19 4,792.00 3,700.19 77.22% 39,758.77 24,213.22 27,051.28 (2,838.06) -10.49%
930310 Employee Relocation 2,139.00 2,139.00 2,139.00 0.00 0.00% 27,839.73 25,668.00 25,668.00 0.00 0.00%
930340 Comm.& Government Affairs 0.00 0.00 6,250.00 (6,250.00) -100.00% 0.00 315.00 35,000.00 (34,685.00) -99.10%
930350 Fees, Chgs & Corp. Dues 8,106.00 6,335.00 2,100.00 4,235.00 201.67% 52,879.00 52,217.00 52,728.00 (511 .00) -0.97%
931000 Office Rents 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 800.00 (800.00) -100.00%
General & administrative 567,701.41 650,582.63 494,507.21 156,075.42 31.56% 6,217,838.15 6,120,844.86 6,144,157.98 (23,313.12) -0.38%
403000 Depreciation 365,710.75 380,031.70 401 ,000.00 (20,968.30) -5.23% 4,355,942.62 4,493,483.68 4,707,800.00 (214,316.32) -4.55%
404000 Amortiz.of Utility Plant 1,894.97 0.00 1,895.00 (1,895.00) -100.00% 0.00 0.00 22,740.00 (22,740.00) -100.00%
405000 Amortiz.of Other Util.Plant 4,259.43 4,259.43 4,259.00 0.43 0.01% 51,113.17 51,113.17 51,108.00 5.17 0.01%
406000 Amert.of Util.Plt.Acq Adj 1,117.63 1,117.63 1,592.00 (474.37) -29.80% 17,129.56 13,411.56 19,104.00 (5,692.44) -29.80%
Depreciation & amortization 372,982.78 385,408.76 408,746.00 (23,337.24) -5.71% 4,424, 185.35 4,558,008.41 4,800,752.00 (242,743.59) -5.06%
408120 Real Estate Tax 83,663.86 59,628.01 108,000.00 (48,371.99) -44.79% 1,005,639.86 1,252,238.66 1,296,000.00 (43,761 .34) -3.38%
408130 Payroll Taxes:FICA Employer 25,300.25 22,670.25 26,200.00 (3,529.75) -13.47% 335,422.48 306,526.48 349,000.00 (42,473.52) -12.17%
408131 Payroll Taxes:SUI Employer 129.44 148.09 125.97 22.12 17.56% 10,202.52 9,760.45 9,990.08 (229.63) -2.30%
408134 Payroll Taxes:FUI Employer 0.00 22.67 13.88 8.79 63.33% 6,200.03 5,884.97 6,120.16 (235.19) -3.84%
408139 Payroll Taxes 0.00 0.00 0.00 0.00 0.00% 0.00 62.56 0.00 62.56
General taxes 109,093.55 82,469.02 134,339.85 (51,870.83) -38.61% 1,357,464.89 1,574,473.12 1,661,110.24 (86,637.12) -5.22%
Total operating expense 1,362,990.06 1,457,999.78 1,305,012.90 152,986.88 11.72% 16,491,277.31 16,575,330.24 16,943,289.98 (367,959.74) -2.17%
Operating Income (289,507.80) (67,979.95) 212,243.10 (280,223.05) -132.03% 11,318,292.28 13,296,486.93 12,737,514.02 558,972.91 4.39%
Other expenses & Income:
431000 Other Interest Expense 0.00 0.00 0.00 0.00 0.00% 269.00 0.00 0.00 0.00 0.00%
Interest expense 0.00 0.00 0.00 0.00 0.00% 269.00 0.00 0.00 0.00 0.00%
Amortization -debt & premium 0.00 0.00 0.00 0.00 0.00',4 0.00 0.00 0.00 0.00 0.00%
430000 Inter.on Debt to Assoc.Co. 419,576.00 318,617.00 360,492.00 (41,875.00) -11 .62% 4,425,302.00 4,495,844.00 4,372,192.00 123,652.00 2.83%
lntercompany interest expense 419,576.00 318,617.00 360,492.00 (41,875.00) -11.62',4 4,425,302.00 4,495,844.00 4,372,192.00 123,652.00 2.83%
420010 AFUDC-Debt (1,929.25) (3,087.13) (1,116.00) (1,971 .13) 176.62% (27,631 .90) (16,607.49) (18,540.00) 1,932.51 -10.42%
420020 AFUDC-Equity (3,321 .17) (5,313.92) (1,984.00) (3,329.92) 167.84% (49,593.89) (28,587.37) (32,960.00) 4,372.63 -13.27%
AFUOC (5,250.42) (8,401.05) (3,100.00) (5,301.05) 171.00'.4 (77,225.79) (45,194.86) (51,500.00) 6,305.14 -12.24%
Dividend Income 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00%
Preferred stock dividends of subs 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00%
Minority Interest 0.00 0.00 0.00 0.00 0.00% 0.00 0.00 0.00 0.00 0.00%
415000 Revenues from M & J (189.57) (3,043.41) (4,300.00) 1,256.59 -29.22% (47,132.85) (61 ,726.32) (51 ,600.00) (10,126.32) 19.62%
416000 Costs and Expen.of M & J 14,504.24 73.36 200.00 (126.64) -<l3.32'A, 7,387.09 11,921 .06 12,400.00 (478.94) -3.86%
Report ID: UWGLW701 United Water Idaho
Business Unit: 060 General Ledger System
Period Ending: Dec 31, 2001 STATEMENT OF INCOME
• Cu rren t Month ·
Prior Variance to Plan
Year Actual Plan Amount Percent
419000 lnterco. inter.& Div. Inc (116,298.00) (29,845.00) (45,200.00) 15,355.00 -33.97%
419009 Interest-Other 0.00 (1,542.22) (200.00) (1,342.22) 671.11%
421000 Other Income 0.00 14.86 (600.00) 614.86 -102.48%
422000 (Gains)l osslDispos.of Prop. (23,787.00) 0.00 0.00 0.00 0.00%
426000 Misc. Inc. Deductions 0.00 0.00 0.00 0.00 0.00%
426020 Penalties 0.00 0.00 0.00 0.00 0.00%
426510 Other Deductions 128.02 75.03 0.00 75.03
Other income (125,642.31) (34,267.38) (50,100.00) 15,832.62 -31.60%
Total interest and other expenses 288,683.27 275,948.57 307,292.00 (31,343.43) -10.20%
Income before income taxes (578,191.07) (343,928.52) (95,048.90) (248,879.62) 261.84%
409100 Federal Income Tax (338,527.00) 222,730.97 (31,937.00) 254,667.97 -797.41%
409200 State Income Taxes 28,457.00 8,717.21 (3,802.00) 12,519.21 -329.28%
410100 Def.Inc.Tax Exp.-Fed. 0.00 (12,790.00) 0.00 (12,790.00)
410150 Def.Inc.Tax Exp.-State 0.00 (1 ,523.00) 0.00 (1,523.00)
410200 Def. lnc.Tx,Ot. Inc.& Ded 22,120.00 (70,088.00) 0.00 (70,088.00)
412100 ITC, Def.to Future Periods (3,989.00) (3,999.00) 0.00 (3,999.00)
Provision for Income taxes (291,939.00) 143,048.18 (35,739.00) 178,787.18 -500.26%
Net income (286,252.07) (486,976.70) (59,309.90) (427,666.80) 721.07%
Preferred stock dividend 0.00 0.00 0.00 0.00 0.00%
Preference stock dividend 0.00 0.00 0.00 0.00 0.00%
Net income applicable to common stock (286,252.07) (486,976.70) (59,309.90) ($427,666.80) 72107%
• Year t o Date·
Prior
Year Actual Plan
(541,441.00) (426,843.00) (543,000.00)
(2,343.00) (5,287.05) (2,400.00)
(8,222.00) (13,792.85) (7,200.00)
(54,493.00) (10,754.00) 0.00
7,914.00 0.00 0.00
824.00 0.00 0.00
1,127.25 5,041.14 0.00
(636,379.51) (501,441.02) (591,800.00)
3,711,965.70 3,949,208.12 3,728,892.00
7,606,326.58 9,347,278.81 9,008,622.02
2,112,584.90 3,195,573.00 3,026,896.00
280,816.25 391,627.36 360,346.00
0.00 (12,790.00) 0.00
0.00 (1,523.00) 0.00
416,001.00 279,940.00 0.00
(42,407.00) (40,379.00) 0.00
2,766,995,15 3,812,448.36 3,387,242.00
4,839,331.43 5,534,830.45 5,621,380.02
0.00 0.00 0.00
0.00 0.00 0.00
4,839,331.43 5,534,830.45 5,621,380.02
.. •
Page No. 4 of 4 .,
Run Date: 0410512002
Run Time: 9:56 AM
Variance to Plan
Amount Percent
116.157.00 -21.39%
(2,887.05) 120.29%
(6,592.85) 91.57%
(10,754.00)
0.00 0.00%
0.00 0.00%
5,041.14
90,358.98 -15.27%
220,316.12 5.91%
338,656.79 3.76%
168,677.00 5.57%
31,281.36 8.68%
(12,790.00)
(1,523.00)
279,940.00
(40,379.00)
425,206.36 12.55%
(86,549.57) -1.54%
0.00 0.00%
0.00 0.00%
($86,549.57) -1.54%
'•