Spreadsheet: louise_kitchen__24240__Revised 2002 Consol Plan Review Template
Sheet: ENA

 |  |  |  |  |  |  |  | Enron North America
 |  |  |  |  |  |  |  | 2002 Plan Review
 |  | 2001 Forecast |  |  |  |  | 2001 Proforma |  |  |  |  | 2002 Plan
 |  |  | Capital | Direct |  |  |  | Capital | Direct |  |  |  | Capital | Direct | Allocated |  |  | 2001 Forecast | 2002 Plan | Fav/(Unfav)
Team |  | Margin | Charge | Expenses | EBIT |  | Margin | Charge | Expenses | EBIT |  | Margin | Charge | Expenses |  | EBIT |  | Headcount | Headcount | [NAME]
Northeast Trading |  | 182.7 | 0 | 2.9 |  |  | 164.6 | 0 | 3.1 |  |  |  | 0 | 4 | 0 |  |  | 15 | 23
Northeast Origination |  | 9.8 | 0 | 2.6 |  |  | 9.8 | 0 | 2.4 |  |  | 25 | 0 | 3.2 | 0 |  |  | 8 | 13
Midwest Trading |  | 107.3 | 0 | 1.9 |  |  | 87 | 0 | 1.7 |  |  |  | 0 | 2.4 | 0 |  |  | 10 | 15
Midwest Origination |  | 5.2 | 0 | 2.2 |  |  | 5.2 | 0 | 2.4 |  |  | 20 | 0 | 2.8 | 0 |  |  | 13 | 12
Southeast Trading |  | 15.6 | 0.1 | 1.8 |  |  | 6.3 | 0 | 1.5 |  |  |  | 0 | 2.5 | 0 |  |  | 13 | 15
Southeast Origination |  | 9.7 | 0.1 | 3.7 |  |  | 9.6 | 0 | 3.7 |  |  | 20 | 0 | 4.2 | 0 |  |  | 9 | 12
ERCOT Trading |  | 31.7 | 0 | 1.2 |  |  | 27.3 | 0 | 1.3 |  |  |  | 0 | 2.8 | 0 |  |  | 9 | 16
ERCOT Origination |  | 20.5 | 0 | 1.5 |  |  | 20.4 | 0 | 1.2 |  |  | 20 | 0 | 1.4 | 0 |  |  | 4 | 5
Options |  | 23.9 | 0 | 0.5 |  |  | 23 | 0 | 0.7 |  |  | 30 | 0 | 1.2 | 0 |  |  | 3 | 7
Management Book |  | 45.6 | 0 | 11.5 |  |  | 36.8 | 0 | 7.9 |  |  | 30 | 0 | 12.9 | 0 |  |  | 6 | 7
Genco Control Area |  | 0 | 0 | 0 |  |  | 0 | 0 | 3.4 |  |  | 0 | 0 | 2.5 | 0 |  |  | 6 | 11
TAC |  | 0 | 0 | 0 |  |  | 0 | 0 | 3.3 |  |  | 0 | 0 | 3.6 | 0 |  |  | 9 | 12
Services |  | 1.4 | 0 | 0.3 |  |  | 1.4 | 0 | 0.4 |  |  | 10 | 0 | 1.8 | 0 |  |  | 5 | 10
Development |  | 22.8 | 1 | 8.3 |  |  | 16.6 | 0 | 8.1 |  |  | 15 | 0 | 8.7 | 0 |  |  | 17 | 15
Generation Investments |  | 28.6 | 64.7 | 7.8 |  |  | 6.4 | 0 | 8.2 |  |  | 20 | 0 | 6.9 | 0 |  |  | 37 | 23
Structuring/Fundamentals |  | 0 | 0 | 5.4 |  |  | 0 | 0 |  |  |  | 0 | 0 |  | 0
East Power
Trading |  | 794.6 | 0 | 19.3 |  |  | 703.8 | 0 | 20 |  |  |  | 0 | 18.2 | 0 |  |  | 53 | 54
Middle Market Originations/Services |  | 52.4 | 0 |  |  |  | 48.7 | 0 | 1.4 |  |  |  | 0 | 1.7 | 0 |  |  | 6 | 10
Originations/Generation |  |  |  |  |  |  | 96.3 | 10.2 | 15.1 |  |  | 75 | 9.7 |  | 0
Executive |  | 11.3 | 0 | 1.3 |  |  | 11.2 | 0 | 4.5 |  |  | 0 | 0 | 5.1 | 0 |  |  | 23 | 23
Fundamentals |  | 0 | 0 | 0.9 |  |  | 0 | 0 | 0.8 |  |  | 0 | 0 | 1.1 | 0 |  |  | 6 | 9
West Power
East Trading |  | 30.1 | 3.6 | 10.3 |  |  | 1.9 | 2.8 | 9.5 |  |  |  | 2.8 | 9.6 | 0 |  |  | 16 | 17
East Origination |  | 9.6 | 0 | 3.5 |  |  | 10.7 | 0 | 2.9 |  |  | 15 | 0 | 3 | 0 |  |  | 10 | 12
Central Trading |  | 213.6 | 1.7 | 5.8 |  |  | 178.2 | 0 | 4.5 |  |  |  | 0 | 5.5 | 0 |  |  | 10 | 16
Central Origination |  | 4.8 | 0 | 2.8 |  |  | 11 | 1.9 | 3.6 |  |  | 15 | 1.8 | 2.5 | 0 |  |  | 20 | 12
Texas Trading |  | 172 | 0 | 4.2 |  |  | 151.9 | 0 | 3.3 |  |  |  | 0 | 3.8 | 0 |  |  | 7 | 10
Texas Origination |  | 0 | 0 | 0.4 |  |  | 0.1 | 0 | 1.2 |  |  | 10 | 0 | 2.5 | 0 |  |  | 5 | 9
West Trading |  | -193.1 | 0 | 4.7 |  |  | -239.2 | 0 | 4.8 |  |  |  | 0 | 5.3 | 0 |  |  | 16.3 | 17
West Origination |  | 49.6 | 0 | 2.2 |  |  | 48.3 | 0 | 2.2 |  |  | 25 | 0 | 3.9 | 0 |  |  | 11 | 18
Financial Gas |  | 778.2 | 0 | 1.7 |  |  | 710.7 | 0 | 1.7 |  |  |  | 0 | 2.1 | 0 |  |  | 10.3 | 11
Derivative Origination& East Producers |  | 34.4 | 0 | 4.1 |  |  | 26.9 | 0 | 4 |  |  | 35 | 0 | 4.3 | 0 |  |  | 21 | 25
NG Structuring |  | 0 | 0 | 2.1 |  |  | 0 | 0 | 1.8 |  |  | 0 | 0 | 2.1 | 0 |  |  | 16.5 | 14
NG Fundamentals |  | 0 | 0 | 2 |  |  | 0 | 0 | 1.7 |  |  | 0 | 0 | 2.4 | 0 |  |  | 15 | 18
Asset Management |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 2.9 | 0 |  |  | 0 | 10
Management |  | 254 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Natural Gas
Natural Gas Trading |  | -30.4 | 0.6 | 4.1 |  |  | -29.3 | 0 | 4.1 |  |  |  | 0 | 4.4 | 0 |  |  | 15 | 13
Natural Gas Origination |  | 14 | 0 | 1.2 |  |  | 18.7 | 0 | 0.95 |  |  | 25 | 0 | 1.8 | 0 |  |  | 11 | 15
Finance |  | 12.5 | 3.5 | 0.9 |  |  | 7.5 | 0 | 0.7 |  |  | 0 | 0 | 0.8 | 0 |  |  | 5 | 5
Alberta Power Trading |  | 253.8 | 0 | 1.4 |  |  | 249.5 | 0 | 1.7 |  |  |  | 0 | 1.2 | 0 |  |  | 6 | 10
Alberta Power Origination |  | 79.5 | 0 | 0.7 |  |  | 84.7 | 0 | 0.2 |  |  | 25 | 0 | 0.9 | 0 |  |  | 10 | 9
Ontario Power |  | 12.9 | 0.4 | 2.1 |  |  | 2 | 0 | 1.4 |  |  | 75 | 0 | 2.5 | 0 |  |  | 14 | 28
Executive |  | 5.1 | 0 | 3.1 |  |  | 3.2 | 0 | 2.4 |  |  | 0 | 0 | 2.5 | 0 |  |  | 5 | 5
Canada
Upstream Executive |  | 0 | 0 | 0 |  |  | 5.3 | 0 | 1.1 |  |  | 0 | 0 | 0.5 | 0 |  |  | 7 | 3
Compression Services |  | 0 | 0 | 0 |  |  | 4.9 | 0 | 1.5 |  |  | 12.9 | 0 | 1.1 | 0 |  |  | 8 | 6
Storage |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Offshore |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
[NAME] |  | 0 | 0 | 0 |  |  | 1 | 0 | 0.6 |  |  | 4 | 0 | 0.8 | 0 |  |  | 3 | 3
Upstream Products |  | 21 | 1.5 | 4.7 |  |  |  |  |  |  |  | 0
Bridgeline |  | 2.9 | 23.1 | 0 |  |  | 2.9 | 18.8 | 0 |  |  | 25 | 21 | 0 | 0 |  |  | 0 | 0
HPL |  | -70.2 | 0 | 26.8 |  |  | -68.4 | 0 | 31 |  |  | -40 | 0 | 13.6 | 0 |  |  | 4 | 5
Mexico |  | 18.5 | 0.1 | 5.6 |  |  | 18.2 | 0 | 5.4 |  |  | 20 | 0 | 2.9 | 0 |  |  | 15 | 15
Energy Capital Services |  |  |  | 7.1 |  |  | 24.8 | 28.1 | 7.4 |  |  | 35 | 35.2 | 7.9 | 0 |  |  | 30 | 30
Asset Marketing |  | 8 | 0 | 0.9 |  |  | 3 | 0 | 1 |  |  | 0 | 0 | 1.5 | 0 |  |  | 3 | 8
Principal Investing |  | -6.4 | 9.6 | 1.7 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Corporate Development |  | 0 | 0 | 0.7 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
[NAME] |  | 644.4 | 40.5 | 18.7 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Cross Commodity |  | -1.3 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
LT Fundamentals |  | -14.2 | 35.3 | 4.8 |  |  | 0 | 0 | 1.1 |  |  | 0 | 0 | 1.2 | 0 |  |  | 8 | 6
TVA Settlement |  | 0 | 0 | 253.3 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Office of the Chairman |  | -126.3 | 0 | 5.8 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Total Commercial
Executive |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0.1 | 0 |  |  | 0 | 0
Legal |  | 0 | 0 | 2.2 |  |  | 0 | 0 | 2.2 |  |  | 0 | 0 | 2.4 | 0 |  |  | 0 | 0
RAC |  | 0 | 0 | 9.5 |  |  | 0 | 0 | 9.5 |  |  | 0 | 0 | 7.7 | 0 |  |  | 0 | 0
Accounting |  | 0 | 0 | 3.4 |  |  | 0 | 0 | 3.4 |  |  | 0 | 0 | 3 | 0 |  |  | 0 | 0
Tax |  | 0 | 0 | 2.7 |  |  | 0 | 0 | 2.7 |  |  | 0 | 0 | 2.3 | 0 |  |  | 0 | 0
Risk Management |  | 0 | 0 | 4.9 |  |  | 0 | 0 | 4.9 |  |  | 0 | 0 | 9.1 | 0 |  |  | 0 | 0
SAP |  | 0 | 0 | 5.2 |  |  | 0 | 0 | 5.2 |  |  | 0 | 0 | 6.7 | 0 |  |  | 0 | 0
Accounts Payable |  | 0 | 0 | 0.4 |  |  | 0 | 0 | 0.4 |  |  | 0 | 0 | 0.3 | 0 |  |  | 0 | 0
Human Resources |  | 0 | 0 | 4.5 |  |  | 0 | 0 | 4.5 |  |  | 0 | 0 | 1.5 | 0 |  |  | 0 | 0
Benefit Plans and Comp |  | 0 | 0 | 17.6 |  |  | 0 | 0 | 17.6 |  |  | 0 | 0 | 27.6 | 0 |  |  | 0 | 0
Regulatory Affairs |  | 0 | 0 | 12.7 |  |  | 0 | 0 | 12.7 |  |  | 0 | 0 | 10.9 | 0 |  |  | 0 | 0
PR |  | 0 | 0 | 1.1 |  |  | 0 | 0 | 1.1 |  |  | 0 | 0 | 0.9 | 0 |  |  | 0 | 0
Community Relations |  | 0 | 0 | 1.1 |  |  | 0 | 0 | 1.1 |  |  | 0 | 0 | 1.8 | 0 |  |  | 0 | 0
Aviation |  | 0 | 0 | 1.3 |  |  | 0 | 0 | 1.3 |  |  | 0 | 0 | 1.3 | 0 |  |  | 0 | 0
Global Finance |  | 0 | 0 | 4.3 |  |  | 0 | 0 | 4.3 |  |  | 0 | 0 | 3.7 | 0 |  |  | 0 | 0
Total Corp
Assurance Services |  | 0 | 0 | 0.6 |  |  | 0 | 0 | 0.6 |  |  | 0 | 0 | 0.2 | 0 |  |  | 0 | 0
Canada |  | 0 | 0 | 5.4 |  |  | 0 | 0 | 5.4 |  |  | 0 | 0 | 4.7 | 0 |  |  | 0 | 0
Competitive Analysis/Bus Controls |  | 0 | 0 | 2.1 |  |  | 0 | 0 | 2.1 |  |  | 0 | 0 | 1.5 | 0 |  |  | 0 | 0
Esource |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0.3 | 0 |  |  | 0 | 0
Financial Operations |  | 0 | 0 | 12.1 |  |  | 0 | 0 | 12.1 |  |  | 0 | 0 | 7.8 | 0 |  |  | 0 | 0
Human Resources |  | 0 | 0 | 4.7 |  |  | 0 | 0 | 4.7 |  |  | 0 | 0 | 2.7 | 0 |  |  | 0 | 0
Legal |  | 0 | 0 | 33.2 |  |  | 0 | 0 | 33.2 |  |  | 0 | 0 | 21.7 | 0 |  |  | 0 | 0
Public Relations |  | 0 | 0 | 1.5 |  |  | 0 | 0 | 1.5 |  |  | 0 | 0 | 0.5 | 0 |  |  | 0 | 0
Research |  | 0 | 0 | 4 |  |  | 0 | 0 | 4 |  |  | 0 | 0 | 2.7 | 0 |  |  | 0 | 0
Tax |  | 0 | 0 | 1.8 |  |  | 0 | 0 | 1.8 |  |  | 0 | 0 | 1.4 | 0 |  |  | 0 | 0
Technical Services |  | 0 | 0 | 2.8 |  |  | 0 | 0 | 2.8 |  |  | 0 | 0 | 2.7 | 0 |  |  | 0 | 0
Transaction Support |  | 0 | 0 | 2.1 |  |  | 0 | 0 | 2.1 |  |  | 0 | 0 | 1.3 | 0 |  |  | 0 | 0
Treasury |  | 0 | 0 | 2 |  |  | 0 | 0 | 2 |  |  | 0 | 0 | 2.6 | 0 |  |  | 0 | 0
Buildout and Other |  | 0 | 0 | 3.1 |  |  | 0 | 0 | 3.1 |  |  | 0 | 0 | 3 | 0 |  |  | 0 | 0
Total ENA
Energy Operations |  | 0 | 0 | 45.8 |  |  | 0 | 0 | 45.8 |  |  | 0 | 0 | 44.6 | 0 |  |  | 0 | 0
Energy Operations- IT Development |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 |  |  | 0 | 0
Enron Online |  | 0 | 0 | 19.1 |  |  | 0 | 0 | 19.1 |  |  | 0 | 0 | 21.5 | 0 |  |  | 0 | 0
IT Development |  | 0 | 0 | 38.1 |  |  | 0 | 0 | 38.1 |  |  | 0 | 0 | 38.9 | 0 |  |  | 0 | 0
IT Infrastructure |  | 0 | 0 | 43.8 |  |  | 0 | 0 | 43.8 |  |  | 0 | 0 | 28.9 | 0 |  |  | 0 | 0
Total ENW
Total Allocations
Coyote |  | 0 | 0 | 11.3 |  |  | 0 | 0 | 11.3 |  |  | 0 | 0 | 14.7 | 0 |  |  | 0 | 0
Citrus |  | 0 | 0 | 0.3 |  |  | 0 | 0 | 0.3 |  |  | 0 | 0 | 0.3 | 0 |  |  | 0 | 0
[NAME] |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 8.3 | 0 |  |  | 0 | 0
Sithe |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | -6.5 | 0 |  |  | 0 | 0
[NAME] |  | 0 | 0 | 0 |  |  | 0 | 0 | 0 |  |  | 0 | 0 | 6.5 | 0 |  |  | 0 | 0
CES |  | 0 | 0 | 1 |  |  | 0 | 0 | 1 |  |  | 0 | 0 | 1 | 0 |  |  | 0 | 0
Mexico City |  | 0 | 0 | 0.9 |  |  | 0 | 0 | 0.9 |  |  | 0 | 0 | 0.7 | 0 |  |  | 0 | 0
Weather Alert Amortization |  | 0 | 0 | 1 |  |  | 0 | 0 | 1 |  |  | 0 | 0 | 1 | 0 |  |  | 0 | 0
Bonus |  | 0 | 0 | 86.2 |  |  | 0 | 0 | 86.2 |  |  | 0 | 0 | 100 | 0 |  |  | 0 | 0
Total Non-Allocable
Total Group
Prepay Expenses |  | -21.6 | 0 | 95.1 |  |  | -21.6 | 0 | 95.1 |  |  | 0 | 0 | 70.3 |  |  |  | 0 | 0
U.S. Drift |  | 150 | 0 | 3.5 |  |  | 149.9 | 0 | 3.5 |  |  | 50 | 0 | 4.5 |  |  |  | 0 | 0
Facility Costs |  | -60.5 | 0 | 0 |  |  | -60.6 | 0 | 0 |  |  | -43.2 | 0 | 0 |  |  |  | 0 | 0
Capital Charge Offset |  | 8 | -276.5 | 0 |  |  | 0 | -61.8 | 0 |  |  | 0 | -70.5 | 0 |  |  |  | 0 | 0
EBIT
 |  | appears high b/c includes o/s legal that will be pushed to commercial teams; is in commercial forecast 2001