Spreadsheet: louise_kitchen__22672__2002 Plan Worksheet Texas Orig
Sheet: Detail Breakdown

Texas Gas Origination |  |  |  |  |  |  |  |  |  |  | Network/
2002 Direct Expense Plan |  |  |  |  | Redmond |  | Supply |  | Marketing |  | Regulatory |  |  |  | HPL Support
 |  |  |  |  | 150378 |  | 150116 |  | 150114 |  | xxxxxx |  | TOTAL ORIG |  | 150126
 |  | 2001 | 2001 | 2001 | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002
 |  | JULY YTD | FORECAST | PLAN | PLAN |  | PLAN |  | PLAN |  | PLAN |  | PLAN |  | PLAN
Description |  | $ | $ | $ | $ |  | $ |  | $ |  | $ |  | $ |  | $
Compensation/Taxes and Benefits
Compensation |  | 0
Salaries & Wages |  | 0 |  | 0 | 234045 |  | 352284 |  | 244690 |  | 109331 |  |  |  | 392555
Special Pays (Employment Agreement, Sign-on, [NAME], etc.) |  | 0 |  | 0 | 40000 |  | 20000 |  | 20000 |  | 20000 |  |  |  | 0
Benefits & Payroll Taxes
Benefits |  | 0 |  | 0 | 34138 |  | 42278 |  | 31867 |  | 16569 |  |  |  | 59723
Payroll Taxes |  | 0 |  | 0 | 11834 |  | 11920 |  | 11575 |  | 5889 |  |  |  | 24338
TOTAL COMPENSATION/TAXES AND BENEFITS
Employee Expense
Conferences & Training |  | 0 |  | 0 | 4000 |  | 5000 |  | 7000 |  | 4000 |  |  |  | 10000
Club Dues |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Employee Memberships & Dues |  | 0 |  | 0 | 1000 |  | 500 |  |  |  | 1000 |  |  |  | 1000
Overtime/Working Meals |  | 0 |  | 0
Communications Expense (Pager/Cellular) |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | 3600
Tuition Reimbursement |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 3600
Employee Entertainment (team building, internal offsites, etc.) |  | 0 |  | 0 | 10000 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Other Employee Expenses |  | 0 |  | 0 | 5000 |  | 5000 |  | 5000 |  | 5000 |  |  |  | 6000
Recruiting & Relocations |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Recruiting |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 10000
Relocation Expenses |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
TOTAL EMPLOYEE EXPENSE
Travel & Entertainment
Travel |  | 0 |  | 0
Air (50%) |  | 0 |  | 0
Lodging (35%) |  | 0 |  | 0
Meals (10%) |  | 0 |  | 0
Other (5%) |  | 0 |  | 0
Client Entertainment |  | 0 |  | 0 | 50000 |  | 25000 |  | 50000 |  | 25000 |  |  |  | 5000
Customer Meetings |  | 0 |  | 0 | 30000
TOTAL TRAVEL & ENTERTAINMENT
Consulting
Advertising & Promotions |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Outside Services
Legal |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Audit |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Tax |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
IT |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Engineering |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Accounting |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Professional Consultants/Contractors (Temporaries) |  | 0 |  | 0 | 10000 |  | 10000 |  | 40000 |  | 10000 |  |  |  | 0
Other |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
TOTAL C0NSULTING
Office
Office Supplies
Subscriptions & Periodicals |  | 0 |  | 0 | 1000 |  | 1000 |  | 1000 |  | 1000 |  |  |  | 1000
Postage & Freight Expenses |  | 0 |  | 0 | 100 |  | 100 |  | 100 |  | 100 |  |  |  | 100
Office Supplies |  | 0 |  | 0 | 3000 |  | 3000 |  | 3000 |  | 3000 |  |  |  | 5000
Technology (computers, monitors, palm pilots, etc.) |  | 0 |  | 0 | 15000 |  | 25000 |  | 15000 |  | 20000 |  |  |  | 10000
Rent - Office, Warehouse & Tower |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Equipment Rental (fax, copier, etc.) |  | 0 |  | 0 | 200 |  | 200 |  | 200 |  | 200 |  |  |  | 200
Corporate Rent (graphics, concierge, parking, mail service, cafeteria, etc.) |  | 0 |  | 0 | 20000 |  | 30000 |  | 30000 |  | 20000 |  |  |  | 30000
TOTAL OFFICE
Controllable Infrastructure
Corporate IT |  | 0 |  | 0 | 20000 |  | 20000 |  | 20000 |  | 20000 |  |  |  | 5000
Market Data |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Long Distance |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Trading Turrets |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Controllabe Infrastructure |  |  |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Application Integration |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Change Management |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Architecture & Planning |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
TOTAL CONTROLLABLE INFRASTRUCTURE
System Development |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Front Office |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Corp Development |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Energy Operations |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Web Development |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Market Intelligence |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Development Support |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL SYSTEM DEVELOPMENT
Insurance |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
TOTAL INSURANCE
Analysts/Associates (comp, taxes, benefits, OH) |  | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  | 0
TOTAL ANALYSTS/ASSOCIATES
Other Expense
Company Membership & Dues |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Charitable Contributions |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Transportation |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Taxes Other Than Income |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Other Expense |  | 0 |  | 0 | 3000 |  | 4000 |  | 5000 |  | 3000 |  |  |  | 5000
TOTAL OTHER EXPENSES
Outside Legal |  | 0 |  | 0 | 5000 |  | 5000 |  | 5000 |  | 5000 |  |  |  | 5000
TOTAL OUTSIDE LEGAL
Outside Tax |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
TOTAL OUTSIDE TAX
Depreciation & Amortization
Depreciation |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Amortization |  | 0 |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
TOTAL DEPRECIATION & AMORTIZATION
TOTAL DIRECT EXPENSES