20050211Postage TY Hist & Summary.xls

Worksheet
Postage TY Summary
Postage TY Hist
NvsParentRef
Journal
Date
Acct
DeptID
Act
C Type
Amount
Line Descr
R168B
R168C
AP00170439
AP00170442
AP00170967
AP00170968
AP00172269
AP00172881
AP00173489
AP00174302
AP00175460
AP00175861
AP00176478
AP00176833
AP00177386
AP00178789
AP00179370
AP00180016
AP00180880
AP00181951
R168
AP00182888
AP00183978
AP00184553
2004-01-01
2004-01-09
2004-01-14
2004-01-15
2004-02-01
2004-02-12
2004-02-15
2004-03-01
2004-03-15
2004-03-23
2004-04-01
2004-04-07
2004-04-15
2004-05-01
2004-05-11
2004-05-15
2004-06-01
2004-06-15
2004-07-01
2004-07-15
2004-07-23
903020

300
304
7033
7031
037
Cust.Rec.& Col.Ex.-Postage
gummed tape rolls
USPS 133108 TRUST ACCT
Postage chgs 11/25-12/26
Postage Chgs 12/27 - 1/27
Postage chags 1/28 - 2/24
POSTAGE
Postage Chgs 3/27 - 4/27
Postage Chgs 4/28 - 5/26
Posrage Chgs 5/27 - 6/25
AP00166857
2003-11-14
Postage meter system
2003-11-15
2003-12-01
R168A
305
AP00168141
Postage Chgs 9/27 - 10/28
AP00168623
2003-12-10
Postage chgs 10/29 - 11/24
AP00169222
2003-12-14
2003-12-15
AP00160872
2003-08-01
AP00161642
2003-08-14
2003-08-15
2003-09-01
RCLS_UBS
AP00162546
Postage Chgs 6/25 - 7/25
Postage chg 6/25 - 7/25
Postage Chg 6/25 - 7/25
AP00162924
2003-09-11
Postage Charges 7/26 - 8/26
AP00162925
2003-09-14
2003-09-15
2003-10-01
AP00164097
AP00164530
2003-10-07
purchase power 132936 postage
AP00164880
2003-10-14
2003-10-15
2003-11-01
AP00166042
Postage Chgs 8/27 0 9/26
Year/Month
R168 Total
RCLS_UBS Total
August 2003
Local
UBS
UBS ADJ
September 2003
October 2003
November 2003
December 2003
Trust Account
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
Test Year Total
United Water Idaho
JJH
Test Year Ended July 2004
August 2, 2004
Month
Aug-03
Sep-03
Oct-03
Nov-03
Dec-03
Jan-04
Feb-04
Mar-04
Apr-04
May-04
Jun-04
Jul-04
Summary of Account 903-020
Customer Postage
July 2004
Local Postage Machine
Total Customer Postage
UBS Charges
UBS Adjustments
Number of Items
UBS Cost per item
per bi-month
Total Customer Count
Total
Number of Items UBS Postage Count
Times 2
Use Total Customer Count as a proxy for items mailed
Percent of Total
Estimated Customer Count @ June 1, 2005 Postal Cost per Item
Pro Forma Year June 2005
Customers as of May 31, 2005 =76,907/2= 38,453.5
September 22, 2004
73638.00
37728.00
0.08
73742.00
40537.00
0.09
73862.00
35911.00
0.08
74036.00
39706.00
0.09
74177.00
32178.00
0.07
74337.00
39358.00
0.09
74454.00
32371.00
0.07
74697.00
38639.00
0.09
74930.00
34717.00
0.08
75074.00
41343.00
0.09
75192.00
37347.00
0.08
75400.00
37163.00
0.08
893539.00
446998.00
893996.00
2.00
1.00
filename
S:\ACC\JERRY\Rates 2004 Official\Exh and WP re PR #135\[Postage TY Hist & Summary.xls]Postage TY Summary
37728.00
0.31
$11,853.75
($2,493.64)
$2,000.00
$11,360.11
40537.00
0.30
$12,255.70
$3,500.00
$15,755.70
35911.00
0.31
$10,960.66
$3,000.00
$13,960.66
39706.00
0.30
$12,000.00
$3,000.00
$15,000.00
32178.00
0.31
$9,832.07
$3,000.00
$12,832.07
39358.00
0.30
$11,946.12
$3,055.58
$500.00
$15,501.70
32371.00
0.30
$9,859.10
$3,000.00
$12,859.10
38639.00
0.30
$11,726.33
$3,000.00
$14,726.33
34717.00
0.31
$10,589.28
$3,000.00
$13,589.28
41343.00
0.31
$12,647.96
$3,000.00
$15,647.96
37347.00
0.31
$11,574.76
$3,000.00
$14,574.76
37163.00
0.31
$11,472.77
$3,000.00
$14,472.77
446998.00
0.31
$136,718.50
($2,493.64)
$35,555.58
$500.00
$170,280.44
170280.44
74499.67
6.00
$0.08
filename
S:\ACC\JERRY\Rates 2004 Official\Exh and WP re PR #135\[Postage TY Hist & Summary.xls]Postage TY Summary
?6?/?1?/?2005
38453.00
0.31
$11,761.20
$3,058.67
$14,819.86
?6?/?1?/?2005
38454.00
0.31
$11,761.50
$3,058.75
$14,820.25
?6?/?1?/?2005
38453.00
0.31
$11,761.20
$3,058.67
$14,819.86
?6?/?1?/?2005
38454.00
0.31
$11,761.50
$3,058.75
$14,820.25
?6?/?1?/?2005
38453.00
0.31
$11,761.20
$3,058.67
$14,819.86
?6?/?1?/?2005
38454.00
0.31
$11,761.50
$3,058.75
$500.00
$15,320.25
?6?/?1?/?2005
38453.00
0.31
$11,761.20
$3,058.67
$14,819.86
?6?/?1?/?2005
38454.00
0.31
$11,761.50
$3,058.75
$14,820.25
?6?/?1?/?2005
38453.00
0.31
$11,761.20
$3,058.67
$14,819.86
?6?/?1?/?2005
38454.00
0.31
$11,761.50
$3,058.75
$14,820.25
?6?/?1?/?2005
38453.00
0.31
$11,761.20
$3,058.67
$14,819.86
?6?/?1?/?2005
38454.00
0.31
$11,761.50
$3,058.75
$14,820.25
461442.00
0.31
$141,136.19
$0.00
$36,704.50
$500.00
$178,340.69
178340.69
38453.50
12.00

Page
2003-08
1000.00
2003-08
1000.00
2000.00
9.00
2003-08
11853.75
11853.75
9.00
2003-08
-304.94
2003-08
-305.85
2003-08
-301.20
2003-08
-308.38
2003-08
-318.93
2003-08
-329.43
2003-08
-324.25
2003-08
-70.09
2003-08
-76.84
2003-08
-77.54
9.00
-
-0
2003-08
-76.19
-2493.64
9.00
11360.11
9.00
-
-0
2003-09
1500.00
9.00
-
-0
2003-09
1000.00
9.00
-
-0
2003-09
1000.00
3500.00
9.00
-
-0
2003-09
76.19
9.00
-
-0
2003-09
11453.31
9.00
-
-0
2003-09
324.25
9.00
-
-0
2003-09
12255.70
9.00
-
-0
2003-09
-11853.75
12255.70
15755.70
9.00
-
-0
2003-10
-1000.00
9.00
-
-0
2003-10
1500.00
9.00
-
-0
2003-10
1000.00
9.00
-
-0
2003-10
1500.00
3000.00
9.00
-
-0
2003-10
10960.66
10960.66
13960.66
9.00
-
-0
2003-11
1500.00
9.00
-
-0
2003-11
1500.00
3000.00
9.00
-
-0
2003-11
-10960.66
9.00
-
-0
2003-11
12000.00
9.00
-
-0
2003-11
10960.66
12000.00
15000.00
9.00
-
-0
2003-12
1500.00
9.00
-
-0
2003-12
1500.00
3000.00
9.00
-
-0
2003-12
12024.48
9.00
-
-0
2003-12
9807.59
9.00
-
-0
2003-12
10000.00
9.00
-
-0
2003-12
-12000.00
9.00
-
-0
2003-12
-10000.00
9832.07
12832.07
9.00
-
-0
2004-01
1500.00
9.00
-
-0
2004-01
1500.00
9.00
-
-0
2004-01
55.58
3055.58
9.00
-
-0
2004-01
500.00
500.00
9.00
-
-0
2004-01
11946.12
9.00
-
-0
2004-01
-10000.00
9.00
-
-0
2004-01
10000.00
11946.12
15501.70
9.00
-
-0
2004-02
1500.00
9.00
-
-0
2004-02
1500.00
3000.00
9.00
-
-0
2004-02
9859.10
9859.10
12859.10
9.00
-
-0
2004-03
1500.00
9.00
-
-0
2004-03
1500.00
3000.00
9.00
-
-0
2004-03
11726.33
11726.33
14726.33
9.00
-
-0
2004-04
1500.00
9.00
-
-0
2004-04
1500.00
3000.00
9.00
-
-0
2004-04
10589.28
10589.28
13589.28
9.00
-
-0
2004-05
1500.00
9.00
-
-0
2004-05
1500.00
3000.00
9.00
-
-0
2004-05
12647.96
12647.96
15647.96
9.00
-
-0
2004-06
1500.00
9.00
-
-0
2004-06
1500.00
3000.00
9.00
-
-0
2004-06
11574.76
11574.76
14574.76
9.00
-
-0
2004-07
1500.00
9.00
-
-0
2004-07
1500.00
3000.00
9.00
-
-0
2004-07
11472.77
9.00
-
-0
2004-07
-11574.76
9.00
-
-0
2004-07
11574.76
11472.77
14472.77
170280.44