Spreadsheet: tracy_geaccone__40469__Functional Income 2001
Sheet: TW

 |  | TW
 |  | 2001
 |  | Plan |  | Comments
Commercial
Margins
 | [NAME]
 | Demand
 | Commodity | 12.4
 | Demand - FTS - 1 | 0
 | Commodity - FTS - 1 | 0
 | Demand - FTS - 2 | 0
 | Commodity - FTS - 2 | 0
 | Demand - Phase IV | 0
 | Commodity - Phase IV | 0
 | IT | 0
 | Other - IT, SFTS, PNR, Western | 0
 | Storage | 0
 | Structured Products | 0
 | New Deals | 0
 | Shared Cost Surcharge | 9.8
 | Provision for Billing Refund | 0
 | TC & S Costs | 0
 | Other - Penalties | -0.3
 | - PPA | 0
 | - Other | 0
 | Other Revenues:
 | Black Mesa | 0
 | Crestone | 0
 | Total Margins
Expenses
 | GRI/ACA | -4.1
 | Reg Commission Expense | 0
 | Reg Assets Amortization
 | Reg Affairs | 0
 | Rate Case Amortization (0705) | 0
 | IMP/So GA Credits | 0
 | TC&S Mobil Carlton
 | TC&S Base Gas SBA
 | Net Fuel/UAF
 | Revenue Management | -0.2
 | Direct  - Gross
 | - Marketing | 0
 | Capitalization | 0.3
 | Other  - Gomez Sale in 2001
 | ETS Support | 0 |  | Where are [NAME]'s expenses? CC111703
 | Aviation |  |  |  | Included in the GPG allocations from co. 366
 | Payroll Taxes | 0 | 0
 | Omaha Rent
 | Total Expenses
Margin Net of Expenses
Non-Recurring Elements
 | Base Gas | 0
 | Asset Sales | 0
 | Structured Products | 0
 | ECS Deals | 0
 | El Paso Settlement | 0
 | Rate Case Items | 0
 | WIC Shipper Credits | 0
 | Stretch | 10.1
 | Other | 0
 | Total Non Recurring
Net Contribution Commercial
Market Services
Other Income |  | 0
Expenses
 | Direct - Gross
 | Amortization (Encore) | 0
 | Capitalization | 0.1
 | [NAME] | 0
 | Payroll Taxes | 0 | 0
 | Other Expenses - G&A | 0
 | Total Expenses
Net Contribution Market Services
Net Contribution from Markets
Operations
Other Income |  | 0
CESI |  | 0
Expenses
 | Field Operations - Gross
 | Field Operations for Expansions | 0
 | Capitalization | 2.6
 | Group Operations(OTS)
 | Operations Support
 | Electric Compression | 0
 | Insurance | 0
 | Allocations In from HPL | 0
 | Overhaul Amortizations | 0
 | OTS Work Order Amortization | 0
 | Payroll Taxes | 0 | 0
 | Other Expenses - PCB and Env.
 | Total Expenses
Non-Recurring Elements
 |  | 0
 |  | 0
 | Total Non Recurring
Net Contribution Operations
Finance, Accounting & Admin
Other Income |  | 0
 | FAS 133 | 0
 | AFUDC Amortization (Phase III) | 0
Trading |  | 0
Expenses
 | Accounting | 0
 | Finance | 0
 | Commercial Support | 0
 | Operations Support | 0
 | Market Services / IT Support | 0
 | Executive | 0
 | Direct Support
 | NBP Direct | 0
 | Black Mesa Direct | 0
 | Crestone Direct | 0
 | ETS Support
 | Capitalization - Support | 0.2
 | Company Bonus
 | Capitalization - Bonus | 0.2
 | Other Expenses - G&A, Exec |  |  | What is this?
 | Bonus - ETS |  |  |  | Break out of the amount:
 | Corporate Overhead - ETS |  |  |  | -0.1 | Operation Information (OI) Amort - completes June 2001)
 | Payroll Taxes | 0 | 0 |  | -0.8 | Fuji Lease
 | Amortizations (Ramp up) | 0 |  |  |  | Total
 | DD&A | -22
 | Corporate:
 | Allocated - MMF
 | Direct
 | EP&S
 | Total Corporate
 | Other Taxes:
 | Ad Valorem | -9
 | Total Other Taxes
 | Reserves | 0
 | Total Expenses
Net Contribution FA&A
Information Technology
Other Income - Lucent Credit |  | 0
DD&A - Lucent |  | 0
Expenses
 | Direct Support - Gross
 | Capitalization | 0.1
 | Commercial Support | 0
 | Field Operations Support | 0
 | ETS Support - Gross
 | Capitalization
 | Other Expenses
 | Payroll Taxes | 0 | 0
 | Amortization | 0
 | EIS
 | Total Expenses
Net Contribution IT
Legal
Expenses
 | Commercial Support - ETS
 | Field Operations Support - ETS
 | Deferred Legal Expense | 0
 | Other | 0
 | Total Expenses
Human Resources/Communications
Expenses
 | ETS Support - Gross
 | Capitalization | 0.1
 | Other Expenses - G&A | 0
 | Total Expenses
Executive & Other
Expenses
 | Direct  - Gross | 0
 | ETS Support |  |  | Total ETS Allocations missing $0.1
 | Aviation - Stan |  |  |  | Payroll Taxes were reclassified to "TOTI" on the Inc. Stmt
 | Amortizations (Prepaid EDS Amort.) | 0 |  |  | This is consistent with how Actuals have been reclassified by Acct
 | Other (G&A, add Capitalized, 0705 | 0
 | Total Expenses
Total Net Contribution
Other Expenses:
 | Other - G&A
 | Mangement Overview | 2
 | Other O&M Adjustment | 0
 | Other Taxes:
 | Payroll Taxes | 0 | 0
 | Other (Payroll/Franchise/Other) | -2.5
 | Total Other Taxes
 | Total Other Expenses
Other Income(Deductions)
Equity Earnings:
 | Northern Plains | 0
 | Enron Citrus | 0
 | EOTT | 0
 | Bighorn, Fort Union, Lost Creek | 0
 | Income Investment | 0
 | Pathnet | 0
 | AFUDC Equity | 0
 | Overview | 0
 | Other | 0
 | Other - Minority Interest Income | 0.4 |  | What is this?  Probably needs a new home
 | Total Other Income(Deductions) |  |  |  | 0.3 | Gallup Contract Prepayment Amort (move to commercial)
 | Mont Belvieu | 0 |  |  | 0.1 | AFUDC Gross Up Equity (move to F&A)
Income Before Interest and Taxes
 | AFUDC | 0
 | Interest | 0
Pretax Income
 | Income Taxes | 0
Net Income Before Financing
 | Financing | 0
Net Income