Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: Allocations %

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  |  |  |  | 1 | 0.55
 | REG AFFAIRS | Total estimated Staff time% | Dawson, [NAME] | Wood, [NAME] | Haizmann, [NAME] | Huertas-Rubio, Alfredo | Elms, [NAME] | Cooper, Adam | Gaillard, Bruno | Hussain, [NAME] | [NAME], [NAME] | Duvauchelle, Antoine | Irwin, Kerryann | [NAME], Amber | Glen, [NAME] | Styles, [NAME] | Dindarova, Nailia | [NAME] | Hennemeyer, [NAME] | [NAME], [NAME] | Deal-driven cost % | total | average |  | [NAME], KI | [NAME], KI
 | Enter as Percentage time |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | average
 | UK Power Trading |  |  |  |  |  | 0.5 |  |  | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | add this to [NAME] and Kerryanne (average of the rest) |  |  |  |  | 0.2
 | UK Gas Trading |  |  | 0.25 |  |  |  | 0.5 |  | 0.3 |  |  |  |  | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 | UK Power Originations |  |  |  |  |  | 0.5 |  |  | 0.4
 | UK Gas Originations |  |  |  |  |  |  | 0.5
 | UK Finance Originations
 | UK Financial Books
 | Continental Gas Trading |  |  | 0.25 |  |  |  |  |  |  |  |  |  |  | 0.25
 | Teesside
 | Watershed
 | UK Total
 | Continental Origination - Germany |  |  |  | 0.5 |  |  |  |  |  |  |  |  | 0.5 |  | 0.1 | 0.1 | 0.1 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assumptions
 | Continental Origination - Benelux/France |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 0.1 | 0.1 | 0.1 |  | 0.7 |  |  |  |  |  |  |  |  |  |  |  |  |  | -using current headcount
 | Continental Origination - Italy |  |  |  |  | 0.25 |  |  |  |  |  |  |  |  |  | 0.1 | 0.1 | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -55% of [NAME] and [NAME]
 | Continental Origination - Poland/Russia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | has been prorated on the other 16 peoples time
 | Continental Origination - Czech/Slovak/Hungary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -Doug Woods Time estimated
 | Continental Origination - Turkey/Balkans |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -Mabel Pigmanns is excluded (part time)
 | Continental Origination - Switzerland/Austria
 | Continental Origination - Spain |  |  |  |  | 0.25 |  |  |  |  | 0.5 |  |  |  |  | 0.1 | 0.1 | 0.1
 | Continental Origination - Arcos |  |  |  |  | 0.25
 | Continental Origination - Executive
 | Continental Origination
 | Bilateral Power Trading |  |  | 0.25 | 0.5 |  |  |  |  |  |  |  |  | 0.5 | 0.25 | 0.3 | 0.3 | 0.3 | 0.5 | 0.3
 | Pool Power Trading |  |  | 0.25 |  | 0.25 |  |  |  |  |  |  |  |  | 0.25 | 0.3 | 0.3 | 0.3
 | Continental
 | Enron Credit Executive
 | Enron Credit Trading
 | Enron Credit Syndication
 | Enron Credit Quant
 | Enron Credit Origination
 | Enron Credit Pricing
 | Enron Credit Marketing
 | Enron Credit Product Development
 | Enron Credit Structured Finance Group
 | Enron Credit | 0
 | Metals Trading
 | LME Execution
 | Metals Marketing
 | [NAME]
 | Recycling
 | Metals | 0
 | Middle East
 | Finland
 | Norway
 | Sweden
 | EnergyDesk
 | Weather
 | Scandinavia | 0
 | Japan
 | Australia
 | EnCom/E Power
 | Non Region Specific
 | TOTAL ENRON EUROPE
 | Continental  Assets (Trakya, ENS, Sarlux, Gaza) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | EES Energy Services (EES Outsourcing) |  |  |  |  |  |  |  |  |  | 0.5
 | EES Enron Direct UK
 | EES Enron Direct NL
 | EES Enron Directo
 | EES Torpy
 | EES Erpag
 | EES
 | EBS
 | EIM
 | ENW
 | EGM |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
 | Enron Corp
 | India
 | Enron Principle Investments
 | NEPCO
 | ENA
 | Enron Wind
 | Total Non-Enron Europe
 | Total All Regions