Spreadsheet: drew_fossum__8667__Budget 2001 Consolidation - Legal
Sheet: Overhead Allocation

Full Time Equivalents for 2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From [NAME] RC File (RC 0237)
 |  |  |  |  |  |  |  |  |  | Methanol |  | Mt. Belvieu
 |  | RC % | NNG | TW | FGT | BM | HPL | HPLO | LRC | 404 | EGP | 1A1 | Liquids | TOTAL
RC 0237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000 GROSS |  |  | NNG | TW | FGT | HPL | HPLO | LRC | EMC | EGP | MTBE ops | Liquids | TOTAL
Wilke |  | 1 | 0.4 | 0.25 | 0.35 |  | 0 | 0 | 0 | 0 | 0
Vacant |  | 1 | 0 | 0 | 0 |  | 0.15 | 0 | 0.05 | 0.25 | 0.35 | 0.2 |  |  |  |  | Wilke |  | 1 | 0.4 | 0.25 | 0.35 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 1 | 0.85 | 0.15 |  |  |  |  |  |  |  |  |  |  |  |  | Vacant |  | 1 | 0 | 0 | 0 | 0.15 | 0 | 0.05 | 0.25 | 0.35 | 0.2
Crowley |  | 1 | 0 | 0 | 0.6 |  | 0.4 | 0 | 0 | 0 | 0 |  |  |  |  |  | [NAME] | x | 1 | 0.85 | 0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Raker |  | 1 | 0.3 | 0.1 | 0.2 |  | 0.25 | 0.05 | 0.05 |  | 0.05 |  |  |  |  |  | Crowley | x not | 1 | 0 | 0 | 0.6 | 0.4 | 0 | 0 | 0 | 0 | 0
Soldano |  | 1 | 0.25 | 0.325 | 0.125 |  | 0.2 |  | 0.05 | 0.025 | 0.025 |  |  |  |  |  | Raker | x | 1 | 0.3 | 0.1 | 0.2 | 0.25 | 0.05 | 0.05 | 0 | 0.05 | 0
Reich |  | 1 | 0.25 | 0.2 | 0.325 |  | 0.15 |  | 0.025 | 0.025 | 0.025 |  |  |  |  |  | Soldano | x | 1 | 0.25 | 0.325 | 0.125 | 0.2 | 0 | 0.05 | 0.025 | 0.025 | 0
Cobden |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reich | x not | 1 | 0.25 | 0.2 | 0.325 | 0.15 | 0 | 0.025 | 0.025 | 0.025 | 0
[NAME] (1/2) |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cobden | x | 1
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (1/2) | x | 0.5
LaGeese |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | x | 1
Benson |  | 1 | 0.3 | 0.3 | 0.2 |  | 0.15 |  | 0.025 |  | 0.025 |  |  |  |  |  | LaGeese (1/2) | x | 0.5
RC 0237 Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Benson | x | 1 | 0.3 | 0.3 | 0.2 | 0.15 | 0 | 0.025 | 0 | 0.025 | 0
RC 0013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total 237
Co. Allocation |  |  |  |  | 1
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | attorneys only
J. Cones |  | 0.35
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Work Orders
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soldano |  | 1 |  | 0.25
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Benson |  | 1 | 0 | 0.25
RC 0013 Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cobden |  | 1 |  | 0.125
RC 0014
Co. Allocation |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 2000 NET | (less work order shares)
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NNG | TW | FGT | HPL | HPLO | LRC | EMC | EGP | MTBE ops | Liquids | TOTAL
Vacant [NAME] |  | 1
L . Huber |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wilke |  | 1 | 0.4 | 0.25 | 0.35 | 0 | 0 | 0 | 0 | 0 | 0
Vacant Secty - Thomas |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacant |  | 1 | 0 | 0 | 0 | 0.15 | 0.05 | 0.05 | 0.25 | 0.3 | 0.2
D. LaGesse |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 1 | 0.85 | 0.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0
J. Cones |  | 0.65 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crowley |  | 1 | 0 | 0 | 0.6 | 0.4 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Raker |  | 1 | 0.3 | 0.1 | 0.2 | 0.25 | 0.05 | 0.05 | 0 | 0.05 | 0
RC 0014 Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soldano |  | 1 | 0.25 | 0.1 | 0.1 | 0.2 | 0 | 0.05 | 0.025 | 0.025 | 0
RC 0026 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reich |  | 1 | 0.25 | 0.2 | 0.325 | 0.15 | 0 | 0.025 | 0.025 | 0.025 | 0
Co. Allocation |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cobden |  | 1
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (1/2) |  | 0.5
D. Dornan |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 1
[NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LaGeese (1/2) |  | 0.5
K. Ringblom |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Benson |  | 1 | 0.3 |  | 0.2 | 0.15 | 0 | 0.025 | 0 | 0.025 | 0
[NAME] |  | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total 237
[NAME] |  | 0.75
Vacant [NAME] |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | attys. only
RC 0026 Total
RC 0162
Co. Allocation |  |  | 0.3 | 0.3 | 0.3 |  |  |  |  |  | 0.05 | 0.05
[NAME] |  | 1
E. Sellers |  | 1
RC 0162 Total
Company 508 Total
Business Unit Total
 |  |  | NNG | TW | FGT | BM | HPL | HPLO | LRC | 404 | EGP | 1A1 | Liquids |  |  |  | The table outlined above describes how full time equivalents for each attorney and associated support staff was allocated to each individual operating company within GPG.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This allocation is based upon a thorough knowledge of ongoing and projected activities within the Gas Pipeline Group which are supported by the Operations legal staff.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These projections take into account historical activities within the Operations group.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The projections are primarily driven by ongoing and anticipated litigation, ongoing administrative support, ongoing and projected projects and key operations issues,
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ongoing and predicted asset acquisitions and divisture activities and ongoing and projected daily operational matters.