20011210Taylor Exhibits DLT-1 2.xls

Sheet3
Sheet2
DLT Exhibit 2
DLT1 Table 3
DLT1 Table 2
DLT1 Table 1
actualror
CAP
COSSUM
DREVREQ
INPUT
JARS
METERD
METHOD
OPTION
Page0
page1
Page277
Page278
Page279
PAGE38
page47
page48
page49
PERIOD2
TABLE1
targetror
TAX
UACCT442S2
units
VARIABLE
Summary
Cost Of Service By Rate Schedule
A
B
C
D
E
F
G
H
I
J
K
L
M
N
Return on
Rate of
Total
Generation
Transmission
Distribution
Retail
Misc
Increase
Line
Schedule
Description
Annual
Rate
Return
Cost of
(Decrease)
Percentage
No.
Revenue
Base
Index
Service
to = ROR
01
Residential
36
Residential - TOD
06
General Service - Large
08
General Service - Medium Voltage
09
General Service - High Voltage
10
Irrigation
07,11,12
Street & Area Lighting
12
Traffic Signals
19
Space Heating
23
General Service - Small
SC
Total Idaho Jurisdiction - Firm
Footnotes :
Column D : Annual revenues based on 1999 usage priced at current Idaho tariff.
Column E : Calculated Return on Ratebase per 1999 Embedded Cost of Service Study
Column F : Rate of Return Index. Rate of return by rate schedule, divided by Idaho Jurisdiction's normalized rate of return.
Column G : Calculated Full Cost of Service at Jurisdictional Rate of Return per the 1999 Embedded COS Study
Column H : Calculated Generation Cost of Service at Jurisdictional Rate of Return per the 1999 Embedded COS Study.
Column I : Calculated Transmission Cost of Service at Jurisdictional Rate of Return per the 1999 Embedded COS Study.
Column J : Calculated Distribution Cost of Service at Jurisdictional Rate of Return per the 1999 Embedded COS Study.
Column K : Increase or Decrease Required to Move From Annual Revenue to Full Cost of Service Dollars.
Column L : Increase or Decrease Required to Move From Annual Revenue to Full Cost of Service Percent.
= Target Return On Rate Base
Jurisdiction
Normalized
UNITS
Billing KW
Annual KWH
Average Customers
Load Factor check
GTDRM TOTAL
Revenue Requirement
Per Billing KW
Per KWH
Per Customer
GENERATION-TOTAL
TRANSMISSION-TOTAL
DISTRIBUTION-TOTAL
RETAIL - TOTAL
MISC - TOTAL
GENERATION-DEMAND
GENERATION-ENERGY
TRANSMISSION-DEMAND
TRANSMISSION-ENERGY
Function Summary
Generation
Transmission
DESCRIPTION
Monsanto
Function
Operating Expenses
Operation & Maintenance Expenses
Depreciation Expense
Amortization Expense
Taxes Other Than Income
Income Taxes - Federal
Income Taxes - State
Income Taxes Deferred
Investment Tax Credit Adj
Misc Revenues & Expense
Total Operating Expenses
Rate Base :
Electric Plant In Service
Plant Held For Future Use
Electric Plant Acquisition Adj
Nuclear Fuel
Prepayments
Fuel Stock
Materials & Supplies
Misc Deferred Debits
Cash Working Capital
Weatherization Loans
Miscellaneous Rate Base
Total Rate Base Additions
Rate Base Deductions :
Accum Provision For Depreciation
Accum Provision For Amortization
Accum Deferred Income Taxes
Unamortized ITC
Customer Advance For Construction
Customer Service Deposits
Misc Rate Base Deductions
Total Rate Base Deductions
Total Rate Base
Return On Rate Base
Revenue Credits
Total Revenue Requirements
Return On Rate Base @ Target ROR
Total Operating Expenses Adjusted for Taxes
Total Target Revenue Requirements
PacifiCorp
State of Idaho
12 Months Ending Dec 31, 1999
Rolled-In
Ind Cust
Exhibit No. 1
Case No. UPL-E-01-___
D. Taylor, Pacificorp
UNIT COSTS
8.42% Target Return On Rate Base
Page 3 of 4
Page 4 of 4
Page 2 of 4
Page 1 of 4
May - Oct
Nov - Apr
Demand Charge / $ per kW-month
On-Peak Energy / $ per MWh
Off-Peak Energy / $ per MWh
Customer Charge / $ per Month
Based on 1999 Cost of Service
Proposed Monsanto Contract Price
Firm Service
Page 1 of 1
Exhibit No. 2

$282.89
$282.89
$10.56
$8.46
$19.57
$16.31
$14.68
$14.68
Page of
1.00
2.00
10524209.47
2220412.00
3.00
3137496027.00
1400846000.00
4.00
55400.00
1.00
5.00
0.41
0.86
6.00
7.00
1.00
0.31
8.00
143022164.79
43971089.99
9.00
$13.59
$19.80
10.00
0.05
0.03
11.00
$2,581.63
$43,971,089.99
12.00
13.00
1.00
0.41
14.00
88114149.26
36499113.66
15.00
$8.37
$16.44
16.00
0.03
0.03
17.00
$1,590.51
$36,499,113.66
18.00
19.00
1.00
0.40
20.00
17959909.27
7239436.52
21.00
$1.71
$3.26
22.00
5.72E-03
5.17E-03
23.00
$324.19
$7,239,436.52
24.00
25.00
1.00
4.63E-04
26.00
31553493.17
14598.27
27.00
3.34
6.25E-03
28.00
0.01
9.91E-06
29.00
$569.56
$14,598.27
30.00
31.00
1.00
-2.03E-04
32.00
3560208.51
-721.64
33.00
$0.34
$0.00
34.00
1.14E-03
-5.15E-07
35.00
$64.26
($721.64)
36.00
37.00
1.00
0.12
38.00
1834404.58
218663.17
39.00
$0.17
$0.10
40.00
5.85E-04
1.56E-04
41.00
$33.11
$218,663.17
42.00
43.00
44.00
1.00
0.41
45.00
88114149.26
36499113.66
46.00
$8.37
$16.44
47.00
0.03
0.03
48.00
$1,590.51
$36,499,113.66
49.00
50.00
1.00
0.39
51.00
39662603.29
15549682.44
52.00
$3.77
$7.00
53.00
0.01
0.01
54.00
$715.93
$15,549,682.44
55.00
56.00
1.00
0.43
57.00
48451545.97
20949431.23
58.00
$4.60
$9.43
59.00
0.02
0.01
60.00
$874.58
$20,949,431.23
61.00
62.00
1.00
0.40
63.00
17959909.27
7239436.52
64.00
$1.71
$3.26
65.00
5.72E-03
5.17E-03
66.00
$324.19
$7,239,436.52
67.00
68.00
1.00
0.40
69.00
13984498.52
5564650.19
70.00
$1.33
$2.51
71.00
4.46E-03
3.97E-03
72.00
$252.43
$5,564,650.19
73.00
74.00
1.00
0.42
75.00
3975410.75
1674786.33
76.00
$0.38
$0.75
77.00
1.27E-03
1.20E-03
78.00
$71.76
$1,674,786.33

1.00
2.00
3.00
52215165.62
48849094.18
3279842.89
4338.57
622.37
81267.62
4.00
5178019.34
3776718.32
1397927.36
3344.37
29.28
0.00
5.00
791748.28
582609.14
205904.65
71.18
3163.31
0.00
6.00
1649462.59
1152329.53
475455.92
812.02
13807.91
7057.21
7.00
2372700.40
1412965.73
955158.45
947.69
-1820.62
5449.15
8.00
285379.99
172710.37
112132.39
111.26
-213.74
639.71
9.00
-621177.34
-678139.88
56070.78
295.95
595.80
0.00
10.00
-231705.00
-161623.44
-69970.65
-110.91
0.00
0.00
11.00
-19502.16
-19502.16
0.00
0.00
0.00
0.00
12.00
13.00
61620091.72
55087161.80
6412521.79
9810.13
16184.31
94413.69
14.00
15.00
16.00
17.00
199916456.18
138152284.62
61678332.23
83889.42
1949.90
0.00
18.00
56319.57
26031.30
30288.28
0.00
0.00
0.00
19.00
2819175.74
2819175.74
0.00
0.00
0.00
0.00
20.00
0.00
0.00
0.00
0.00
0.00
0.00
21.00
304872.82
206395.08
57263.53
90.11
1017.93
40106.18
22.00
1145751.45
1145751.45
0.00
0.00
0.00
0.00
23.00
1605927.39
1533321.08
72264.66
341.65
0.00
0.00
24.00
2671589.83
1856124.19
742659.55
114.06
2251.42
70440.61
25.00
683844.56
661397.77
-64728.20
-184.58
60639.33
26720.24
26.00
179.16
0.00
0.00
0.00
0.00
179.16
27.00
605705.51
605705.51
0.00
0.00
0.00
0.00
28.00
29.00
209809822.21
147006186.75
62516080.04
84250.66
65858.58
137446.18
30.00
31.00
32.00
-74589917.79
-54860813.85
-19703937.45
-25115.98
-50.51
0.00
33.00
-2214549.10
-1398753.48
-809391.76
-1037.64
-5366.21
0.00
34.00
-11685868.65
-8047795.19
-3627612.39
-9243.13
-1217.93
0.00
35.00
-30147.61
-21026.29
-9107.06
-14.26
0.00
0.00
36.00
0.00
0.00
0.00
0.00
0.00
0.00
37.00
0.00
0.00
0.00
0.00
0.00
0.00
38.00
-2134922.41
-2039173.51
-95616.27
-132.62
0.00
0.00
39.00
40.00
-90655405.56
-66367562.33
-24245664.94
-35543.63
-6634.65
0.00
41.00
42.00
119154416.65
80638624.42
38270415.10
48707.03
59223.92
137446.18
43.00
44.00
45.00
0.06
7287474.11
4931851.49
2340615.37
2978.92
3622.13
8406.20
46.00
61620091.72
55087161.80
6412521.79
9810.13
16184.31
94413.69
47.00
-29353292.60
-26509012.73
-2932308.66
3.75
-22723.39
110748.43
48.00
49.00
39554273.22
33510000.56
5820828.50
12792.80
-2916.95
213568.32
50.00
51.00
52.00
0.08
10030390.20
6788140.05
3221594.36
4100.15
4985.46
11570.19
53.00
63293992.40
56219986.35
6950150.82
10494.37
17016.30
96344.56
54.00
-29353292.60
-26509012.73
-2932308.66
3.75
-22723.39
110748.43
55.00
56.00
43971089.99
36499113.66
7239436.52
14598.27
-721.64
218663.17

0.08
1.00
22971633.68
0.21
3.44
17904411.55
8441451.00
1788784.34
5426277.96
1610661.60
637236.64
-5067222.14
-0.22
2.00
20233654.02
0.18
2.88
16816596.22
8468719.81
1661033.82
5266936.03
1018071.22
401835.34
-3417057.80
-0.17
3.00
14053764.38
0.11
1.73
13687466.10
8878316.11
1717762.51
2736446.79
253651.21
101289.47
-366298.29
-0.03
4.00
147382.35
0.17
2.83
120648.99
75780.50
15642.37
25636.81
2728.83
860.47
-26733.36
-0.18
5.00
4734619.89
0.17
2.77
3920200.53
3013633.78
606695.83
215961.59
56919.49
26989.82
-814419.36
-0.17
6.00
25800073.39
0.02
0.28
34504283.52
15371426.94
3360811.31
15328969.48
200043.73
243032.07
8704210.13
0.34
7.00
364003.24
0.19
3.09
301475.36
44939.94
6240.24
231859.99
8840.89
9594.29
-62527.88
-0.17
8.00
24158.76
0.05
0.81
31400.24
6996.36
1455.31
15033.79
4154.58
3760.20
7241.48
0.30
9.00
1008813.23
0.14
2.34
891202.66
491867.82
110208.73
251943.60
24773.87
12408.64
-117610.57
-0.12
10.00
8070567.72
0.21
3.49
6116206.42
2934299.49
631587.09
2025061.94
375948.89
149309.01
-1954361.30
-0.24
11.00
25891534.00
-0.06
-0.91
43971089.99
36499113.66
7239436.52
14598.27
-721.64
218663.17
18079555.99
0.70
12.00
4593023.87
0.08
1.35
4757183.22
3887603.83
820251.21
14766.91
5135.84
29425.43
164159.35
0.04
13.00
$127,893,228.53
0.06
1.00
$143,022,164.79
$88,114,149.26
$17,959,909.27
$31,553,493.17
$3,560,208.51
$1,834,404.58
15128936.26
0.12
Indicates a selected target rate of return