Spreadsheet: hunter_shively__12722__Fundamentals_Netco
Sheet: Summary 2002 Revised

Enron North America
2002 Expenses
Based on Headcount of 850
 |  |  |  |  |  |  | 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
 | Houston Gas Trading |  |  | 0 |  | 425 |  |  |  |  |  |  |  |  | 10.9 |  |  |  | 33
 | Houston Gas Origination (includes Mexico) |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 7.3 |  |  |  | 33
 | East Power Trading |  |  | 0 |  | 250 | 29.9 |  | 147 |  |  |  |  |  | 5.5 |  |  |  | 32
 | East Power Origination |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 2.6 |  |  |  | 13
 | West Power Trading- Portland |  |  | 0 |  | 150 | 18.1 |  | 67 |  |  |  |  |  | 3.9 |  |  |  | 19
 | West Power Origination- Portland |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 2.4 |  |  |  | 10
 | Canada Gas/Power Trading |  |  | 0 |  | 50 | 8 |  | 47 |  | 9 |  | 49 |  | 1.5 |  |  |  | 7
 | Canada Gas/Power Trading/Orig
 | Canada Gas/Power Trading/Orig |  |  |  |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
 | Canada Gas/Power Origination |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 1.9 |  |  |  | 9
 | HPL/Upstream/Bridgeline |  |  |  |  |  | 162 |  | 151 |  | 140 |  |  |  | 0 |  |  |  | 0
 | Merchant |  |  |  |  |  | 31 |  | 107 |  | 7 |  | 36 |  | 0 |  |  |  | 0
 | Leadership(Office of the Chair) |  |  | 0 |  | 0 | 34.3 |  | 65 |  | 257.1 |  | 5 |  | 2.1 |  |  |  | 6
 |  |  | Total Commercial | 60
 | Analysts & Associates Directly Supporting Commercial Teams
 | Admins for Commercial Teams
 | Accounting, Transaction Support |  |  |  |  |  | 14 |  | 128 |  | 7.9 |  | 122 |  | 6.8 |  |  |  | 45
 | Cash Operations and Tax |  |  |  |  |  | 5.7 |  | 30 |  | 2.5
 | Regulatory Affairs |  |  |  |  |  | 11.4 |  |  |  | 9.5 |  |  |  | 2.2 |  |  |  | 10
 | Credit |  |  |  |  |  | 11.4 |  |  |  | 7.3 |  |  |  | 2.3 |  |  |  | 15
 | Research/Market Risk |  |  |  |  |  | 1.2 |  | 0 |  | 0.7 |  | 26 |  | 2.2 |  |  |  | 11
 | Market Risk |  |  |  |  |  | 1.1 |  | 0 |  | 0.7 |  | 27 |  | 0 |  |  |  | 0
 | Energy Ops
 |  | Gas Logistics |  |  |  |  | 10.2 |  |  |  | 7.6 |  |  |  |  |  |  |  | 32 | 5 | 0.5
 |  | Gas Book Running |  |  |  |  | 8.6 |  |  |  | 6 |  |  |  |  |  |  |  | 39 | 4 | 0.5
 |  | Gas Settlements |  |  |  |  | 5.9 |  |  |  | 4 |  |  |  |  |  |  |  |  | 4 | 0.5
 |  | Gas Volume Mgmt |  |  |  |  | 3.1 |  |  |  | 2.7 |  |  |  |  |  |  |  | 6 | 4 | 0.5
 |  | Power Logistics |  |  |  |  | 2.7 |  |  |  | 2.1 |  |  |  |  |  |  |  | 14 | 4 | 0.5
 |  | Power Book Running |  |  |  |  | 2.7 |  |  |  | 2.1 |  |  |  |  |  |  |  | 11 | 4 | 0.5
 |  | Power Settlements |  |  |  |  | 2.7 |  |  |  | 2.5 |  |  |  |  |  |  |  | 8 | 5 | 0.5
 |  | Power Volume Mgmt |  |  |  |  | 3.3 |  |  |  | 2.9 |  |  |  |  |  |  |  | 14 | 6 | 0.05
 |  | Documentation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29
 |  | Management |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 452 |  |  |  |  |  | 30.8 |  |  |  |  | 178 |  | Canada
 | HR |  |  |  |  |  | 10.7 |  | 39 |  | 4.1 |  | 105 |  | 1.6 |  |  |  | 14
 | IT- Development * |  |  |  |  |  | 27.5 |  | 175 |  | 29 |  |  |  | 36 |  |  |  | 140
 | IT- Infrastructure** |  |  |  |  |  | 48.9 |  |  |  | 55 |  |  |  | 50.1 |  |  |  | 59
 | IT- EOL |  |  |  |  |  | 1.1 |  |  |  | 7.7 |  |  |  | 0 |  |  |  | 0
 | IT- EOL Support |  |  |  |  |  | 0.8 |  |  |  | 5.2 |  |  |  | 5.9 |  |  |  | 39
 | Canada Support |  |  |  |  |  | 2.8 |  | 0 |  | 3.5 |  | 96 |  | 4.8 |  |  |  | 33
 | Legal |  |  |  |  |  | 39.3 |  | 90 |  | 10.1 |  | 116 |  | 9.5 |  |  |  | 21
 | Rent
 |  | Houston & Other |  |  |  |  |  |  |  |  | 6 |  |  |  | 5
 |  | Portland |  |  |  |  | 1 |  |  |  | 0.8 |  |  |  | 1
 |  | 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
 | ENE Service Level Agreements |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Moved $2.4 of SAP costs here, and decreased HC by 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and moved $2.0 for SAP cost of system and maintenance
 | 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.