Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: Budget 2002 Summary

 |  |  | Name | Actual Full  Package | location | Regions |  | status | Grade | Monthly average |  | 22 FTE (Jan HC) | 19 FTE (July HC) |  | Scenario 1 |  | Scenario 2 | Scenario 3 | Scenario 4 | Scenario 5
 |  | 1 | Dawson, [NAME] | 180628 | Enron House |  |  |  | Support Director
 |  | 2 | Davies, [NAME] (LEFT) | 180628 | Enron House |  |  | left June | Support Director
 |  | 3 | Wood, [NAME] | 180628 | Enron House |  |  |  | Support Director
 |  | 4 | [NAME] (LEFT) | 190146 | Enron House |  |  | Left June | Director
 |  | 5 | Haizmann, [NAME] | 171110 | Enron House |  |  |  | Support Director
 |  | 6 | Huertas-Rubio, Alfredo | 142555 | Enron House |  |  |  | Support Director
 |  | 7 | [NAME] | 106789 | Enron House |  |  |  | Manager
 |  | 8 | [NAME] | 99175 | Enron House |  |  |  | Manager
 |  | 9 | Gaillard, Bruno | 95182 | Enron House |  |  |  | Senior Specialist
 |  | 10 | [NAME] | 57109 | Enron House |  |  |  | Specialist
 |  | 11 | [NAME], [NAME] | 52540 | Enron House |  |  |  | Temp
 |  | 12 | Duvauchelle, Antoine | 45687 | Enron House |  |  |  | Temp
 |  | 13 | Irwin, Kerryann | 50446 | Enron House |  |  |  | Assistant
 |  | 14 | [NAME], Amber | 51398 | Enron House |  |  |  | Assistant
 |  | 15 | Glen, [NAME] | 38073 | Enron House |  |  |  | Assistant
 |  | 16 | Styles, [NAME] | 231623 | Brussels |  |  |  | Vice President Support
 |  | 18 | Dindarova, Nailia | 39205 | Brussels |  |  |  | Entry Specialist
 |  | 17 | [NAME] | 39641 | Brussels |  |  |  | Assistant
 |  | 19 | Hennemeyer, [NAME] | 180628 | Frankfurt |  |  |  | Support Director
 |  | 20 | [NAME], [NAME] (LEFT) | 42774 | Frankfurt |  |  | left paid until Dec 2001 | Entry Specialist
 |  | 21 | [NAME], [NAME] | 125515 | Amsterdam |  |  |  | Manager
 |  | 22 | Mabel Pigmanns |  | Amsterdam |  |  |  | Entry Specialist
 |  |  | Yearly
 |  |  | Headcount (includes assistants)
 |  |  | No. of Assistants in headcount |  |  |  |  |  |  |  |  | 4 | 4 |  | 2 |  | 2
 |  |  | Saving $ on midyear
 |  |  | Saving % on midyear
 |  |  | Saving $ on Now
 |  |  | Saving % on Now
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenarios
 |  |  |  | Actuals |  |  |  |  |  |  |  | Budget S&W / Actual Other G&A |  |  | Down to 10 FTE |  | Brussels office close
 |  |  |  | Aug YTD | 2001 YTD grossed up (12 mths) |  |  |  |  | Assumptions |  | Mid year run rate (22 FTE + No cost cuts) | Mid year run rate (19 FTE + No cost cuts) | Assumptions | Scenario 1 |  |  |  |  | Scenario 5
 |  |  | SALARY & WAGES | 1823528 |  |  |  |  |  | As above |  |  |  | As above |  |  |  | 0 | 0 | 0 |  |  |  |  |  | no | $ | total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | offsite | 1 |  | 10000
 |  |  | Employee Entertainment & Meals | 8939 |  |  |  |  |  |  |  |  |  |  | 12000 |  |  |  |  |  |  |  |  |  | client ent |  |  | 9000
 |  |  | Travel Costs & Hotel Accommodation |  |  |  |  |  |  |  |  |  |  |  | 334000 |  |  |  |  |  |  |  |  |  | emp ent |  |  | 9000
 |  |  | Client Entertainment | 17523 |  |  |  |  |  |  |  |  |  |  | 12000 |  | 12000 |  | 12002 | 12003 |  |  |  |  | us hotels |  | 185
 |  |  | TRAVEL & ENTERTAINMENT |  |  |  |  |  |  | same |  |  |  | see below |  |  |  | 0 | 0 | 0 |  |  |  |  | Us flights | 5 | 1030
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | uk flights |  | 630
 |  |  | Computer Maintenance Contracts |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Computer Software and Licences | 21016 |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Computer Hardware < 500 |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Office Postage & Couriers | 1018 |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Stationery & Printing | 5099 |  |  |  |  |  |  |  |  |  |  | 4481.333333333333
 |  |  | [NAME] |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Office/Plant Maintenance |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Office Cleaning |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Security Costs |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Rent Expense -Personal Property | 7959 |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | OFFICE EXPENSES |  |  |  |  |  |  | same |  |  |  | Stationary & Printing | 4481.333333333333 |  |  | 0 | 0 | 0 |  |  |  |  | uk hotels |  | 205
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total
 |  |  | Outside Consultancy Services - Tax |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Outside Consulting - Advert, Marketing, Reg Affair |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Outside Consultancy Services - IT |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Outside Consultancy Services - Engineering |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Employee Recruitment Fees and Incentive Payments |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Other Outside Services |  |  |  |  |  |  |  |  |  |  |  | 500000
 |  |  | CONSULTANCY |  |  |  |  |  |  | same |  |  |  | see Consultancy page | 527000 |  |  | 0 | 0 | 0
 |  |  | Outside Consultancy Services - Audit |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Outside Consultancy Services - Accounting |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Outside Consultancy Services - Legal |  |  |  |  |  |  |  |  |  |  |  | 260000
 |  |  | AUDIT & LEGAL | 255710 |  |  |  |  |  | same |  |  |  | see Legal page |  |  |  | 0 | 0 | 0
 |  |  | Office Utilities and Council Rates |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Office Rental Costs (Not Personal Rental) | 104658 |  |  |  |  |  |  |  |  |  |  | 104136
 |  |  | OCCUPANCY COSTS | 108346 |  |  |  |  |  | same |  |  |  | Brussels Rent, excl Amsterdam rent | 100000 |  | 0 | 0 | 0 | 0
 |  |  | Employee Club Membership |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Professional Subscriptions & Memberships | 104658 |  |  |  |  |  |  |  |  |  |  | 105882.18
 |  |  | Books, Publications & Data Services |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Conferences |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Training Courses | 35319 |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  | Insurance | 9868 |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Advertising | 1904 |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Other Business Expenses |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | GENERAL & ADMIN |  | 195750 |  |  |  |  | same |  |  |  | see Subs page + $20k training |  |  |  | 0 | 0 | 0
 |  |  | Office Phones & Faxes |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0
 |  |  | Office Mobile Phones | 26850 |  |  |  |  |  |  |  |  |  |  | 20000 |  | 20000
 |  |  | TELECOMMUNICATIONS | 26850 |  |  |  |  |  | same |  |  |  | $2k per phone |  |  |  | 0 | 0 | 0
 |  |  | .........
 |  |  | TAXES OTHER THAN INCOME |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0 |  | 0 | 0
 |  |  | TOTAL G&A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | Travel & Entertainment Calc. | No. of flights/stays | $ |  |  |  | Total |  |  |  |  | Savings
 |  |  | Offsite | 1 |  |  |  |  | 10000 |  |  |  |  | Saving on 22 FTE
 |  |  | Client ent |  |  |  |  |  | 9000 |  |  |  |  | Saving % of 22 FTE
 |  |  | Emp ent |  |  |  |  |  | 9000 |  |  |  |  | Saving on 19 FTE
 |  |  | US hotels  (5 nights per trip) | 25 | 185 |  |  |  | 4625 |  |  |  |  | Saving % of 19 FTE
 |  |  | US flights (5 trips) | 5 | 1030 |  |  |  | 5150
 |  |  | UK flights  (5 people x 45 weeks) | 225 | 630 |  |  |  | 141750
 |  |  | UK hotels (2 nights per trip) | 450 | 205 |  |  |  | 92250
 |  |  | total |  |  |  |  |  | 271775