20050211Weathernormalization & Growth.xls

Cust Care Exclude Lab & VA
T&D Exl Labor & VA
Weather Norm
GROWTH
United Water Idaho
For Test Year Ended July 31, 2004
Purchased Power
Chemicals
Transportation
General Insurance
Test Year Expense
%
%,AFT,FUW_COST_TYPE
%,AFT,FDESCR,UDESCR
%,LACTUALS
%,LBUDGET
%,C
Breakdown by Cost Type, Actual versus Budget
Business Unit
060
Report Period Ending
2004-07-31
%,AFT,FACCOUNTING_PERIOD
Cost Type
Description
Actual
%,V001
001
Salaries-Exempt
%,V002
002
Salaries-Non-Exempt
%,V021
021
Professional Services
%,V030
030
Materials
%,V032
032
Equipment Rental
%,V036
036
Telephone
%,V038
038
Meals
040
Auto Expense
050
Power
%,V052
052
Electric, Light & Heat
%,V060
Misc. Services
%,V080
080
Maintenance-Misc.
%,V083
083
Contract Services
%,V089
089
Operations-Misc.
%,V096
096
Vehicle Allocation-Non-Exempt
%,FUW_COST_TYPE,X,_
020
Temporary Personnel
%,V033
033
Stationery & Supplies
%,V034
034
Newspapers & Publications
%,V037
037
Postage
%,V085
085
Uncollectible Accounts
%,V090
090
Miscellaneous G&A
%,V094
094
Computer Expense
031
047
Uniform and Safety Expenses
2004 OFF
2004 Field
Customer Care Office & Field YTD through July 31, 2004
Total
Jan to Jul 04
Aug to Dec 03
Sub Total
T&D Test Year by CT
Breakdown by Cost Type, Actual Test Year
2004 Total
2003 OFF
2003 Field
2003 Total
Test Year Total
T & D Excluding Payroll,VA
Variable Expenses Related to Customer Growth:
Total Variable Cost
Total Test Year Revenue
Variable Cost as % of Revenue
Customer Growth Revenue
1/2 year of TY Growth; full annualized year to May 31, 2005
Operating Ratio Adjustment
Weather Norm
Test Year
Total Variable Cost Related to TY Weather
Test Year Revenue
Ratio of Variable Cost to Revenue
Revenue Adjustment due to Weather Norm
Estimation of Expenses Related to Annualization of Test Year Customer
Growth and Growth from Test Year End to May 31, 2005
JJH
October 25, 2004
$37,809.86
$6,543.23
$44,353.09
$19,511.81
$4,208.29
$23,720.10
$68,073.19
$192,495.87
$177,274.11
$369,769.98
$108,357.57
$133,658.65
$242,016.22
$611,786.20
$229.28
557.50
$786.78
$79.20
619.50
$698.70
$1,485.48
$7,792.50
45068.50
$52,861.00
$5,844.00
37516.50
$43,360.50
$96,221.50
$4,306.50
$4,306.50
$10,260.00
$0.00
$10,260.00
$14,566.50
$242,634.01
$229,443.34
$472,077.35
$144,052.58
$176,002.94
$320,055.52
$792,132.87
$0.00
$0.00
$496.90
$0.00
$496.90
$496.90
$1,396.43
$1,396.43
$0.00
$1,014.90
$1,014.90
$2,411.33
$1,933.19
$1,933.19
$0.00
$0.00
$0.00
$1,933.19
$4,548.14
$137.80
$4,685.94
$3,696.13
$4.23
$3,700.36
$8,386.30
$104.94
$104.94
$0.00
$0.00
$0.00
$104.94
$101,371.90
$101,371.90
$68,908.54
$0.00
$68,908.54
$170,280.44
$7.71
$7.71
$0.00
$15.12
$15.12
$22.83
$1,483.42
$1,483.42
2329.63
$2,329.63
$3,813.05
$56,277.32
72.01
$56,349.33
$43,312.98
12282.50
$55,595.48
$111,944.81
$95,669.13
$95,669.13
$67,037.24
$67,037.24
$162,706.37
$19.44
$19.44
$173.31
$173.31
$192.75
$228,394.44
4911.11
$233,305.55
$156,086.61
1671.57
$157,758.18
$391,063.73
$491,206.06
$5,120.92
$496,326.98
$339,711.71
$17,317.95
$357,029.66
$853,356.64
$733,840.07
$234,564.26
$968,404.33
$483,764.29
$193,320.89
$677,085.18
$1,645,489.51
$18,750.08
$11,364.35
$30,114.43
$343,700.37
$217,483.88
$561,184.25
$2,076.00
$1,607.00
$3,683.00
$82,337.50
$58,096.00
$140,433.50
$88,278.90
$71,062.85
$159,341.75
$535,142.85
$359,614.08
$894,756.93
$2,096.00
$0.00
$2,096.00
$55,983.05
$33,082.00
$89,065.05
$697.70
$498.50
$1,196.20
$13,734.60
$7,940.03
$21,674.63
$22.02
($715.31)
-715.31
($693.29)
$507.71
$424.10
$931.81
$88.19
$0.00
$88.19
$1,806.00
$1,290.00
$3,096.00
$58,051.46
$34,873.99
$92,925.45
$8,285.05
$10,076.74
$18,361.79
$141,271.78
$87,470.05
$228,741.83
$676,414.63
$447,084.13
$1,123,498.76
1242538.00
235950.00
1478488.00
30000222.00
0.05
-184354.00
-184354.00
0.05
-9085.44
1242538.00
0.41
235950.00
0.08
362613.00
0.12
789765.00
0.26
388083.00
141272.00
87470.00
71062.00
88279.00
0.13
3018949.00
1.00
31000222.00
0.10
749828.00
287557.00
462271.00
0.10
73021.82