Spreadsheet: louise_kitchen__22706__proforma
Sheet: Sheet1

 |  |  |  |  |  | 2000 YTD |  | 2000 |  | 2001 Oct YTD |  | 2001 |  | 2002 Plan |  |  |  | 2002 Plan
 |  |  | VAR Limit |  | Gross Margin | Direct Expenses |  | Headcount |  | Direct Expenses |  | Headcount |  | Direct Expenses |  | EBIT |  | Headcount
Texas Gas Trading |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1 |  |  |  | 3
East Gas Trading |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 6 |  |  |  | 7
Central Gas Trading |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.6 |  |  |  | 7
West Gas Trading |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.2 |  |  |  | 4
Nymex Desk Trading |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.6 |  |  |  | 6
Texas Gas Origination |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.6 |  |  |  | 4
East Gas Origination |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.2 |  |  |  | 4
Central Gas Origination |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.8 |  |  |  | 7
West Gas Origination |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.9 |  |  |  | 7
Derivatives Marketing |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 2.9
Mexico |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
Crude |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 0.5 |  |  |  | 2
Total Gas Trading and Origination*** |  |  | 0 |  | 425
Management Book |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.3 |  |  |  | 5
ERCOT Power Trading |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.2 |  |  |  | 5
Northeast Power Trading |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.7 |  |  |  | 7
Midwest Power Trading |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 0.9 |  |  |  | 4
Southeast Trading |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.3 |  |  |  | 6
Options |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1 |  |  |  | 4
East Power Origination |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 4.3 |  |  |  | 16
Total East Power Trading and Origination |  |  | 0 |  | 250 | 29.9 |  | 147
West Power Trading- Portland |  |  | 0 |  | 150 | 18.1 |  | 67 |  |  |  |  |  | 4.2 |  |  |  | 16
West Power Origination- Portland |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 4.1 |  |  |  | 12
Total West Power Trading and Origination
Canada Gas/Power Trading |  |  | 0 |  | 25 | 8 |  | 47 |  | 9 |  | 49 |  | 1.1 |  |  |  | 5
Canada Gas/Power Trading/Orig
Canada Gas/Power Trading/Orig |  |  |  |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Canada Gas/Power Origination |  |  | 0 |  | 25 |  |  |  |  |  |  |  |  | 2.6 |  |  |  | 11
HPL/Upstream/Bridgeline |  |  |  |  |  | 162 |  | 151 |  | 140 |  |  |  | 0 |  |  |  | 0
Merchant |  |  |  |  |  | 31 |  | 107 |  | 7 |  | 36 |  | 0 |  |  |  | 0
Total Canada Trading and Origination
Leadership(Office of the Chair) |  |  | 0 |  | 0 | 34.3 |  | 65 |  | 257.1 |  | 5 |  | 2.1 |  |  |  | 3
 |  | Total Commercial | 60
Analysts & Associates Directly Supporting Commercial Teams
Admins for Commercial Teams
Regulatory Affairs |  |  |  |  |  | 11.4 |  |  |  | 9.5 |  |  |  | 7.7 |  |  |  | 10
Fundamentals |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.1 |  |  |  | 33
Structuring |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.1 |  |  |  | 5
Weather |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.4 |  |  |  | 5
Energy Ops
 | Gas Risk Management |  |  |  |  | 10.2 |  |  |  | 7.6 |  |  |  | 4.8 |  |  |  | 39
 | Gas Volume Management |  |  |  |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  | 7
 | Gas Logistics |  |  |  |  | 2.7 |  |  |  | 2.1 |  |  |  | 3.9 |  |  |  | 32
 | Gas Settlements |  |  |  |  |  |  |  |  |  |  |  |  | 2.4 |  |  |  | 20
 | Power Risk Management |  |  |  |  | 8.6 |  |  |  | 6 |  |  |  | 1.3 |  |  |  | 11
 | Power Volume Management |  |  |  |  | 5.9 |  |  |  | 4 |  |  |  | 1.6 |  |  |  | 13
 | Power Logistics**** |  |  |  |  | 2.7 |  |  |  | 2.1 |  |  |  | 1.7 |  |  |  | 14
 | Power Settlements |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 8
 | Documentation |  |  |  |  | 3.1 |  |  |  | 2.7 |  |  |  | 4.4
 | Management |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 |  |  |  | 4
 | Power Settlements |  |  |  |  | 2.7 |  |  |  | 2.5 |  |  |  | 0 |  |  |  | 0
 | Power Volume Mgmt |  |  |  |  | 3.3 |  |  |  | 2.9 |  |  |  | 0 |  |  |  | 0
 | Documentation |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  | 452
IT- Development * |  |  |  |  |  | 27.5 |  | 175 |  | 29 |  |  |  | 38.3 |  |  |  | 141
IT- Infrastructure** |  |  |  |  |  | 48.9 |  |  |  | 55 |  |  |  | 30.2 |  |  |  | 59
EOL Support |  |  |  |  |  | 0.8 |  |  |  | 5.2 |  |  |  | 9.1 |  |  |  | 39
Canada Support |  |  |  |  |  | 2.8 |  | 0 |  | 3.5 |  | 96 |  | 4.1 |  |  |  | 33
Credit |  |  |  |  |  | 11.4 |  |  |  | 7.3 |  |  |  | 3.1 |  |  |  | 15
Market Risk |  |  |  |  |  | 1.2 |  | 0 |  | 0.7 |  | 26 |  | 2.6 |  |  |  | 8
Research |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7 |  |  |  | 3
Market Risk |  |  |  |  |  | 1.1 |  | 0 |  | 0.7 |  | 27 |  | 0 |  |  |  | 0
Accounting, Transaction Support |  |  |  |  |  | 14 |  | 128 |  | 7.9 |  | 122 |  | 7.1 |  |  |  | 45
Cash Operations |  |  |  |  |  | 5.7 |  | 30 |  | 2.5 |  |  |  | 1.6
Tax |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.3 |  |  |  | 5
HR |  |  |  |  |  | 10.7 |  | 39 |  | 4.1 |  | 105 |  | 2.5 |  |  |  | 14
IT- EOL |  |  |  |  |  | 1.1 |  |  |  | 7.7 |  |  |  | 0 |  |  |  | 0
Legal |  |  |  |  |  | 39.3 |  | 90 |  | 10.1 |  | 116 |  | 10.6 |  |  |  | 22
Rent
 | Houston & Other |  |  |  |  |  |  |  |  | 6 |  |  |  | 5
 | Portland |  |  |  |  | 1 |  |  |  | 0.8 |  |  |  | 0.5
 | Canada |  |  |  |  | 1 |  |  |  | 0.1 |  |  |  | 1
 | Mexico |  |  |  |  | 0.4 |  |  |  | 0.1 |  |  |  | 0.6
Other Corporate Charges |  |  |  |  |  |  |  |  |  | 37.4 |  |  |  | 0
Other |  |  |  |  |  | 0 |  |  |  | 20.9
Houston Fundamentals/Structuring, CABC, and [NAME] |  |  |  |  |  | 0.1 |  | 0 |  | 13.6 |  |  |  | 0 |  |  |  | 0
ENE Service Level Agreements
Bonus |  |  |  |  |  | 130.6 |  |  |  | 61.2 |  |  |  | 0 |  | 0
 |  | Total Group
 |  | Total Expenses
*IT Development includes systems maintenance and enhancements of ERMS, TAGG,
EnPower, Sitara, Unify, etc. and license fees for [NAME] and Tibco
**IT Infrastructure includes desk top support, communications, market data feeds, licenses,
servers, tie lines, remote office support, WAN, and LAN.
***Unable to identify which region 2 gas employees belong to.
****Power Logistics Plan was based on Gas Logistics Plan adjusted for headcount.