200505021st staff response UWI plant additions.xls

Sheet1
Line No.
Plant Account Number
Plant Account Description
301-10
Organization
303-20
Land & Land Rights, Water Rights - Source of Supply
303-30
Land & Land Rights - Water Treatment
303-40
Land & Land Rights - Trans. & Distrib.
303-50
Land & Land Rights - General Plant
304-20
Structures and Improvements - Source of Supply
304-30
Structures and Improvements - Water Treatment
304-40
Structures and Improvements - Trans. & Distrib.
304-50
Structures and Improvements - General Plant
305-20
Collecting & Impounding Reservoirs - Source of Supply
306-20
Lake, River & Other Intakes
307-20
Wells & Springs
308-20
Infiltration Galleries & Tunnels
309-20
Supply Mains
310-20
Power Generation Equipment
311-20
Power Electric Pumping Equipment - Source of Supply
Power Diesel Pumping Equipment - Source of Supply
311-30
Power Pumping Equipment - Water Treatment
311-40
Power Pumping Equipment - Trans. & Distrib.
320-30
Water Treatment Equipment
Water Treatment Equipment - Membranes
330-40
Distribution Reservoirs & Standpipes
331-10
Trans. & Distrib. Mains & Accessories - Intangible
331-20
Trans. & Distrib. Mains & Accessories - SOS
331-40
Trans. & Distrib. Mains & Accessories
333-40
Services
334-40
Meters and Meter Installations
335-40
Hydrants
336-40
Backflow Prevention Devices
339-10
Other Plant & Misc. Equipment - Intangible
339-20
Other Plant & Misc. Equipment - Source of Supply
339-30
Other Plant & Misc. Equipment - Water Treatment
339-40
Other Plant & Misc. Equipment - Trans. & Distrib.
339-50
Other Plant & Misc. Equipment - General Plant
340-50
Office Furniture and Equipment
AM / FM System - Mapping
340-5A
Computer Hardware & Software
IFMS / WAN / PeopleSoft
Customer Information System
341-50
Transportation Equipment
342-50
Stores Equipment
343-50
Tools, Shop and Garage Equipment
Confined Space Monitor, Generator, Trench Shield
344-50
Laboratory Equipment
345-50
Power Operated Equipment
346-50
Communications Equipment
347-50
Miscellaneous Equipment
348-50
Other Tangible Property
Master Plan
Rounding
Total Plant In Service
07/31/2004
Per Asset Matrix (per Company)
Pro Forma Utility Plant in Service
Utility Plant
Additions
Depreciable
Net
Plant In Service
1.00
116926.00
111641.72
-5284.28
2.00
6256619.00
4669560.14
-1587058.86
3.00
889034.00
712464.05
-176569.95
4.00
411626.00
395698.18
-15927.82
5.00
213383.00
205126.17
-8256.83
6.00
4319530.00
4552893.28
233363.28
233363.28
7.00
8002050.00
12602600.89
4600550.89
4600550.89
8.00
35388.00
34599.16
-788.84
9.00
3193688.00
3076482.79
-117205.21
10.00
83217.00
79996.93
-3220.07
11.00
1272275.00
1223044.47
-49230.53
12.00
9205941.00
8854316.96
-351624.04
13.00
34652.00
33311.15
-1340.85
14.00
592825.00
2192624.75
1599799.75
1599799.75
15.00
381125.00
372700.80
-8424.20
16.00
10246641.00
11296995.66
1050354.66
1050354.66
17.00
0.00
0.00
0.00
18.00
357998.00
5331865.70
4973867.70
4973867.70
19.00
961390.00
925126.59
-36263.41
20.00
13978190.00
20723163.85
6744973.85
6744973.85
21.00
0.00
500000.00
500000.00
500000.00
22.00
8848528.00
9294071.63
445543.63
445543.63
23.00
145.00
139.39
-5.61
24.00
144.00
138.43
-5.57
25.00
100756125.00
98473556.18
-2282568.82
26.00
36824786.00
35436665.23
-1388120.77
27.00
11575448.00
11125083.40
-450364.60
28.00
1078405.00
1035848.33
-42556.67
29.00
0.00
0.00
0.00
30.00
0.00
0.00
0.00
31.00
37157.00
36303.91
-853.09
32.00
43525.00
41840.81
-1684.19
33.00
88441.00
85018.79
-3422.21
34.00
15798.00
15186.70
-611.30
35.00
684579.00
658035.45
-26543.55
36.00
552910.00
532462.96
-20447.04
37.00
1723563.00
1741192.41
17629.00
17629.41
38.00
2870105.00
2759046.63
-111058.37
39.00
1795069.00
1725609.02
-69459.98
40.00
134111.00
129056.98
-5054.02
41.00
24448.00
23501.99
-946.01
42.00
455945.00
437205.99
-18739.01
43.00
62533.00
60113.29
-2419.71
44.00
116643.00
112129.51
-4513.49
45.00
58817.00
56541.08
-2275.92
46.00
62882.00
61890.72
-991.28
47.00
1300447.00
1257180.11
-43266.89
48.00
107621.00
103456.62
-4164.38
49.00
0.00
0.00
0.00
50.00
268381.00
282882.38
14501.38
14501.38
51.00
0.00
0.00
52.00
2.00
1.92
-0.08
53.00
0.00
0.00
54.00
230039056.00
243378373.10
20180584.13
13339317.10