Spreadsheet: errol_mclaughlin_jr__10058__Budget Temp
Sheet: CC 103821 - Headcount

E N R O N   N ET  WORKS
2 0 0 2   P L A N
SAP PROFIT CENTER:
PROFIT CENTER OWNER:
SAP COST CENTER/PROJECT: |  |  |  |  |  |  |  |  |  |  |  |  | DUE DATE:
 |  |  |  |  |  |  |  |  |  |  |  |  | E-mail to  [NAME]
STAFFING SUMMARY |  | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | Total
Executive
VP |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Director |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Manager |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sr. Specialist |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Specialist |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Staff
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Associate |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Analyst |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3rd yr Analyst
[NAME]
Technician
Technician II
Technician III
GTT |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal Headcount
Contractors $25-$50 | 45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contractors $51-$75 | 65
Contractors $76-$100 | 85
Contractors $101-$125 | 115 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contractors $125-$150 | 135
Contractors $150-$175 | 165
Contractors $176-$200 | 185
Contractors $201-$225 | 215 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contractors $226-$250 | 235
Contractors $251-$275 | 265
Contractors $276-$300 | 285 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contractors $301-$325 | 315
Contractors $326-$350 | 335
Contractors $351-$375 | 365
Contractors $376-$400 | 385
Subtotal Contractors
TOTAL HEADCOUNT
EMPLOYEES SENT TO TRAINING MONTHLY  PER CLASS:
 |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00
Wellhead to [NAME] ($600 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Basics of Risk Management ($600 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fundamentals of Corp Finance ($700 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Applied Finance ($700 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Derivatives I ($800 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Derivatives II ($800 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Derivatives III ($1,000 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Structuring Natural Gas ($800 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Power Marketing ($800 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Value at Risk ($700 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Elec Business Understanding ($600 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Presentations that Work ($600 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Franklin Covey / Time Mgmt ($500 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Access ($175 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Excel ($135 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
New Hire PC Orientation ($135 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Power Point ($175 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project (Creating & Managing) ($175 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] ($135 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tutorials ($100 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Word ($135 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
XMS ($135 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Communicating Effectively ($200 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Communicating Effectively for Leaders ($300 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Delegating & Directing ($300 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Leading [NAME] ($300 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Motivating for Results ($300 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Successful Working Relationships ($450 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Working Styles ($300 per class) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
COSTS OF CONFERENCES ATTENDED:
Conference Title
Conference 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Conference 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total
COSTS OF TUITION REIMBURSEMENTS:
Employee 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Employee 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total
TRAINING COSTS
 |  | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Total
Wellhead to [NAME] ($600 per class)
Basics of Risk Management ($600 per class)
Fundamentals of Corp Finance ($700 per class)
Applied Finance ($700 per class)
Derivatives I ($800 per class)
Derivatives II ($800 per class)
Derivatives III ($1,000 per class)
Structuring Natural Gas ($800 per class)
Power Marketing ($800 per class)
Value at Risk ($700 per class)
Elec Business Understanding ($600 per class)
Presentations that Work ($600 per class)
Franklin Covey / Time Mgmt ($500 per class)
Access ($175 per class)
Excel ($135 per class)
New Hire PC Orientation ($135 per class)
Power Point ($175 per class)
Project (Creating & Managing) ($175 per class)
[NAME] ($135 per class)
Tutorials ($100 per class)
Word ($135 per class)
XMS ($135 per class)
Communicating Effectively ($200 per class)
Communicating Effectively for Leaders ($300 per class)
Delegating & Directing ($300 per class)
Leading [NAME] ($300 per class)
Motivating for Results ($300 per class)
Successful Working Relationships ($450 per class)
Working Styles ($300 per class)
Total Training Classes
Total Training Classes, Conferences and Tuition Reimb
 |  |  | 7.75% increase
 |  |  | 4.25% Merit
 |  |  | 2.5 % Prom
 |  |  | 1 % Prudence
Executive
VP
Director
Manager
Sr. Specialist
Specialist
Staff
[NAME]
Technician
Technician II
Technician III
[NAME]
[NAME]
Subtotal Headcount
Associate
Analyst
3rd yr Analyst
[NAME]
A&A Subtotal Headcount
GTT | 8150
TOTAL HEADCOUNT
Contractors $25-$50 | 45
Contractors $51-$75 | 65
Contractors $76-$100 | 85
Contractors $101-$125 | 115
Contractors $125-$150 | 135
Contractors $150-$175 | 165
Contractors $176-$200 | 185
Contractors $201-$225 | 215
Contractors $226-$250 | 235
Contractors $251-$275 | 265
Contractors $276-$300 | 285
Contractors $301-$325 | 315
Contractors $326-$350 | 335
Contractors $351-$375 | 365
Contractors $376-$400 | 385
Subtotal Contractors