Spreadsheet: thomas_martin__39855__2002 Plan Worksheet CC150297
Sheet: Detail Breakdown

Texas Trading (150297)
2002 Direct Expense Plan
 |  | 2001 | 2001 | 2001 | 2002
 |  | JULY YTD | FORECAST | PLAN | PLAN
Description |  | $ | $ | $ | $
Compensation/Taxes and Benefits
Compensation |  | 439574
Salaries & Wages |  | 0 |  | 1306800 | 740264
Special Pays (Employment Agreement, Sign-on, [NAME], etc.) |  | 0 |  | 36000 | 40000
Benefits & Payroll Taxes
Benefits |  | 58672 |  | 200256 | 99804
Payroll Taxes |  | 21105 |  | 104230 | 35396
TOTAL COMPENSATION/TAXES AND BENEFITS
Employee Expense
Conferences & Training |  | 7056 |  | 4800 | 5000
Club Dues |  | 0 |  | 0 | 0
Employee Memberships & Dues |  | 125 |  | 1800 | 1800
Overtime/Working Meals |  | 29923 |  | 19200 | 50000
Communications Expense (Pager/Cellular) |  | 12210 |  | 23700 | 23700
Tuition Reimbursement |  | 0 |  | 12000 | 8000
Employee Entertainment (team building, internal offsites, etc.) |  | 0 |  | 0 | 15000
Other Employee Expenses |  | 90 |  | 1200 | 1500
Recruiting & Relocations |  |  |  |  | 0
Recruiting |  | 0 |  | 0 | 0
Relocation Expenses |  | 0 |  | 0 | 0
TOTAL EMPLOYEE EXPENSE
Travel & Entertainment
Travel |  | 11269 |  | 10200
Air (50%) |  | 0 |  | 0
Lodging (35%) |  | 0 |  | 0
Meals (10%) |  | 0 |  | 0
Other (5%) |  | 0 |  | 0
Client Entertainment |  | 7542 |  | 72300 | 40000
Customer Meetings |  | 0 |  | 30000 | 0
TOTAL TRAVEL & ENTERTAINMENT
Consulting
Advertising & Promotions |  | 0 |  | 500 | 0
Outside Services
Legal |  | 0 |  | 0 | 0
Audit |  | 0 |  | 0 | 0
Tax |  | 0 |  | 0 | 0
IT |  | 0 |  | 0 | 0
Engineering |  | 0 |  | 0 | 0
Accounting |  | 0 |  | 0 | 0
Professional Consultants/Contractors (Temporaries) |  | 1599 |  |  | 5000
Other |  | 0 |  | 0 | 0
TOTAL C0NSULTING
Office
Office Supplies
Subscriptions & Periodicals |  | 1445 |  | 1500 | 2000
Postage & Freight Expenses |  | 0 |  | 0 | 0
Office Supplies |  | 3973 |  |  | 13000
Technology (computers, monitors, palm pilots, etc.) |  | 471 |  | 96000 | 25000
Rent - Office, Warehouse & Tower |  | 0 |  | 27000 | 0
Equipment Rental (fax, copier, etc.) |  | 65 |  | 600 | 600
Corporate Rent (graphics, concierge, parking, mail service, cafeteria, etc.) |  | 15440 |  | 12000 | 50000
TOTAL OFFICE
Controllable Infrastructure
Corporate IT |  | 35949 |  |  | 75000
Market Data |  | 0 |  | 0 | 0
Long Distance |  | 0 |  | 0 | 0
Trading Turrets |  | 0 |  | 0 | 0
Controllabe Infrastructure |  | 383948 |  | 745000 | 745000
Application Integration |  | 0 |  | 0 | 0
Change Management |  | 0 |  | 0 | 0
Architecture & Planning |  | 0 |  | 0 | 0
TOTAL CONTROLLABLE INFRASTRUCTURE
System Development |  | 818101 |  | 1397000 | 1397000 | will use 2001 plan until better info is provided
Front Office |  | 0 | 0 | 0 | 0
Corp Development |  | 0 | 0 | 0 | 0
Energy Operations |  | 0 | 0 | 0 | 0
Web Development |  | 0 | 0 | 0 | 0
Market Intelligence |  | 0 | 0 | 0 | 0
Development Support |  | 0 | 0 | 0 | 0
TOTAL SYSTEM DEVELOPMENT
Insurance |  | 0 |  | 0 | 0
TOTAL INSURANCE
Analysts/Associates (comp, taxes, benefits, OH) |  |  |  | 0 |  | 2 Associates at $12,000/month, 1 Analyst at $8,700/month
TOTAL ANALYSTS/ASSOCIATES
Other Expense
Company Membership & Dues |  | 0 |  | 0 | 0
Charitable Contributions |  | 0 |  | 0 | 0
Transportation |  | 0 |  |  | 0
Taxes Other Than Income |  | 75 |  |  | 0
Other Expense |  |  |  | 0 | 6000
TOTAL OTHER EXPENSES
Outside Legal |  | 0 |  | 200000 | 50000
TOTAL OUTSIDE LEGAL
Outside Tax |  | 0 |  | 4000 | 0
TOTAL OUTSIDE TAX
Depreciation & Amortization
Depreciation |  | 0 |  | 0 | 0
Amortization |  | 0 |  | 0 | 0
TOTAL DEPRECIATION & AMORTIZATION
TOTAL DIRECT EXPENSES