Spreadsheet: barry_tycholiz__849__West Total Orig Income Stmt
Sheet: Detail Breakdown

West Gas Origination (107321) |  | Houston |  | Denver
2002 Direct Expense Plan |  | 107321 |  | 107322 |  | TOTAL
 |  | 2002 |  | 2002 |  | 2002
 |  | PLAN |  | PLAN |  | PLAN
Description |  | $ |  | $ |  | $
Compensation/Taxes and Benefits
Compensation
Salaries & Wages |  | 761764 |  | 721799
Special Pays (Employment Agreement, Sign-on, [NAME], etc.) |  | 75000 |  | 0
Benefits & Payroll Taxes
Benefits |  | 109746 |  | 99284
Payroll Taxes |  | 40229 |  | 38562
TOTAL COMPENSATION/TAXES AND BENEFITS
Employee Expense
Conferences & Training |  | 10000 |  | 26244
Club Dues |  | 0 |  | 3500
Employee Memberships & Dues |  | 0 |  | 15000
Overtime/Working Meals |  | 40000.42857142857 |  | 15000
Communications Expense (Pager/Cellular) |  | 9999.857142857143 |  | 50000
Tuition Reimbursement |  | 0 |  | 0
Employee Entertainment (team building, internal offsites, etc.) |  | 5000 |  | 5000
Other Employee Expenses |  | 5725.714285714285 |  | 20000
Recruiting & Relocations |  | 0 |  | 0
Recruiting |  | 0 |  | 5000
Relocation Expenses |  | 75000.28571428571 |  | 40000
TOTAL EMPLOYEE EXPENSE
Travel & Entertainment
Travel
Air (50%) |  | 50000 |  | 75000
Lodging (35%) |  | 35000 |  | 52500
Meals (10%) |  | 10000 |  | 15000
Other (5%) |  | 5000 |  | 7500
Client Entertainment |  | 75000.28571428571 |  | 40000
Customer Meetings |  | 50000 |  | 100000
TOTAL TRAVEL & ENTERTAINMENT |  | 225000.2857142857 |  | 290000
Consulting
Advertising & Promotions |  | 0 |  | 10000
Outside Services
Legal |  | 0 |  | 20000
Audit |  | 0 |  | 0
Tax |  | 0 |  | 0
IT |  | 0 |  | 0
Engineering |  | 0 |  | 0
Accounting |  | 0 |  | 0
Professional Consultants/Contractors (Temporaries) |  | 100000 |  | 10000
Other |  | 0 |  | 0
TOTAL C0NSULTING |  | 100000 |  | 40000
Office
Office Supplies
Subscriptions & Periodicals |  | 500 |  | 20000
Postage & Freight Expenses |  | 0 |  | 8226
Office Supplies |  | 15000.14285714286 |  | 8000
Technology (computers, monitors, palm pilots, etc.) |  | 25114.28571428572 |  | 60000
Rent - Office, Warehouse & Tower |  | 0 |  | 126000
Equipment Rental (fax, copier, etc.) |  | 0 |  | 15000
Corporate Rent (graphics, concierge, parking, mail service, cafeteria, etc.) |  | 65000 |  | 2500
TOTAL OFFICE |  | 105614.4285714286 |  | 239726
Controllable Infrastructure
Corporate IT |  | 125000.1428571429 |  | 1000
Market Data |  | 0 |  | 0
Long Distance |  | 0 |  | 0
Trading Turrets |  | 0 |  | 0
Controllabe Infrastructure
Application Integration |  | 0 |  | 0
Change Management |  | 0 |  | 0
Architecture & Planning |  | 0 |  | 0
TOTAL CONTROLLABLE INFRASTRUCTURE |  | 125000.1428571429 |  | 1000
System Development |  | 0 |  | 0
Front Office |  | 0 |  | 0 |  | 0
Corp Development |  | 0 |  | 0 |  | 0
Energy Operations |  | 0 |  | 0 |  | 0
Web Development |  | 0 |  | 0 |  | 0
Market Intelligence |  | 0 |  | 0 |  | 0
Development Support |  | 0 |  | 0 |  | 0
TOTAL SYSTEM DEVELOPMENT |  | 0 |  | 0
Insurance |  | 0 |  | 0
TOTAL INSURANCE |  | 0 |  | 0
Analysts/Associates (comp, taxes, benefits, OH) |  | 381600 |  | 237600
TOTAL ANALYSTS/ASSOCIATES |  | 381600 |  | 237600
Other Expense
Company Membership & Dues |  | 0 |  | 21708
Charitable Contributions |  | 1000 |  | 5400
Transportation |  | 0 |  | 0
Taxes Other Than Income |  | 0 |  | 0
Other Expense |  | 2500 |  | 35000
TOTAL OTHER EXPENSES |  | 3500 |  | 62108
Outside Legal |  | 0 |  | 0
TOTAL OUTSIDE LEGAL |  | 0 |  | 0
Outside Tax |  | 0 |  | 0
TOTAL OUTSIDE TAX |  | 0 |  | 0
Depreciation & Amortization
Depreciation |  | 0 |  | 17870
Amortization |  | 0 |  | 0
TOTAL DEPRECIATION & AMORTIZATION |  | 0 |  | 17870
TOTAL DIRECT EXPENSES