Spreadsheet: thomas_martin__39840__Natural Gas Netco Budget1
Sheet: Natural Gas Trading

 | Natural Gas Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp |  |  |  | A |  |  | B |  |  |  |  |  |  | Revised
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  |  | 2002 |  | 2002 | 2002 | A - B |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Total Trading Plan |  |  |  |  |  |  |  | TX Allocated Plan |  | TX Plan 09/01 | TX Plan 09/01 Adj. | [NAME] |  | Comments |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0 |  |  |  |  |  | 642840 |  |  | 642840
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates |  |  |  |  |  |  |  |  |  |  |  |  |  | 178200 |  | 392400
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other |  |  |  |  |  |  | 164208 |  |  | 164208
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  |  |  |  |  |  | 30812 |  | 105000 | 35000 |  | Seems more reasonable based on 9/01 detail
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  |  |  | 27425 |  | 55000 | 35000 |  | Seems more reasonable based on 9/01 detail
ENAOUTSV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000
ENASUPP | Supplies Expense |  |  |  |  |  |  |  |  |  |  |  |  |  | 4357 |  | 90600 | 20000 |  | Seems more reasonable based on 9/01 detail
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 |  |  |  |  |  |  |  | 0 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0 |  |  |  |  | 246 |  | 0 | 246
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0 |  |  |  |  | 4465 |  | 0 | 0 |  | Not applicable to me
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 |  |  |  |  |  | 4550 |  |  | 4550 |  | Controllable Infra.and System Dev.not included
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 |  |  |  |  |  | 1 |  | 0 | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0 |  |  |  |  | 5658 |  | 6000 | 6000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0 |  |  |  |  | 0 |  | 0 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0 |  |  |  |  | 3 |  | 6 | 3
 |  |  |  |  |  |  |  | VP | 198000
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 |  |  |  |  |  | 2 |  | 3 | 2
 | Administration |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2 |  |  |  | 5 |  | 10 | 5
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 | VP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | VP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Mgr |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Support Mgr. to move to [NAME]
 | Assoc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Assoc |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | To move to Comm. Mgr.
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Not in compensation number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 198000 | VP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110000 | Mgr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89100 | Assoc