Spreadsheet: louise_kitchen__23106__Natural Gas Netco Budget1_TexasOrig
Sheet: Natural Gas Orig-Texas

 | Natural Gas Origination
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  | 2002 |  | 2002 |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Total Orig Plan |  |  |  |  |  |  | [NAME] |  | TX Plan 09/01 |  | TX Plan 09/01 Adj |  | [NAME] | NetCo Plan for TX Orig vs. 09/01 TX Orig Plan Adj.
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0 |  |  |  |  |  |  | 1003004
 | Special Pays |  |  | 0 |  |  | 0
 | [NAME] |  |  |  |  |  | 0 |  |  |  |  |  |  | 0 |  | 30000 |  | 0
 | Analyst & Associates |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 237600
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other |  |  |  |  |  |  |  | 160129
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 118700
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  |  |  |  | 680000 |  |  |  |  | Seems low as significant customer contact will be required
ENAOUTSV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70000 |  |  |  |  | NetCo will need to pay for outside engineering services
ENASUPP | Supplies Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 192200 |  |  |  |  | NetCo Plan number seems low
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 |  |  |  |  |  |  | 15000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0 |  |  |  |  |  | incl
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0 |  |  |  |  |  | incl
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0 |  |  |  |  |  | 80000 |  |  |  |  | NetCo will require access to pipeline/mapping databases
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 1 |  |  |  |  |  | incl
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0 |  |  |  |  |  | 20000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0 |  |  |  |  |  | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 11
 |  |  |  |  |  |  |  | Director | 143000 | 14
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 6
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 | Notes |  |  |  |  |  | Total Gas Orig Budget |  |  |  |  |  |  | Use headcount to calc |  | TX Orig Budget submitted |  | TX Orig Budget of 9/01 |  |  |  |  | Use headcount to calc
 |  |  |  |  |  |  | Per Office of the Chair |  |  |  |  |  |  | allocation to TX Orig |  | to Office of Chair 9/01 |  | [NAME] for new headcount |  |  |  |  | allocation to TX Orig
 | Texas Orig Headcount
 | MD/VP |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 1 |  | 1
 | Director |  |  | 0 |  |  |  |  |  |  |  |  |  | 1 |  | 4 |  | 1
 | Manager |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 1 |  | 2
 | Associate |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 1 |  | 0
 | Analyst |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 1 |  | 0
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 1 |  | 0
 | Total