Spreadsheet: kevin_hyatt__19616__COST ESTIMATE
Sheet: Pipeline

PIPELINE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enron Asset Management Resources
(Preliminary Estimate)
ESTIMATE OF PROJECT MANPOWER
PREPARED BY: |  |  |  |  | SSK
DATE: |  |  |  |  | 2001-08-27 00:00:00
 | Months |  |  |  | STAFFING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAN |  |  |  |  |  |  |  |  |  | GRAND | Total | Expended | Forecast | Control
FUNCTION | Sep 95 | Oct | Nov | Dec | 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 | 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 | MONTHS | Hrs/Month | Total Hrs | $'s/Hr | [NAME] | OH Rate | Sal+Burden | OH $ | SubTotal | Mult | TOTAL | w/o [NAME] | ToDate | w/o [NAME] | Budget
Engineering
Dept Manager | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 48 | 0 | 0.8 |  |  |  | 1.8
Project Engr Mgr | 0 | 0 | 0 | 0 | 0 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0 | 0 | 0 | 0 | 0 |  |  |  | 45 | 0 | 0.8 |  |  |  | 1.8
Project Engr | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 42 | 0 | 0.8 |  |  |  | 1.8
Lead Elect Engineer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 40 | 0 | 0.8 |  |  |  | 1.8
Lead Civil Engineer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 40 | 0 | 0.8 |  |  |  | 1.8
Lead Designer | 0 | 0 | 0 | 0 | 0 | 0 | 0.1 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 35 | 0 | 0.8 |  |  |  | 1.8
Designer (C) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 40 | 0 | 0.8 |  |  |  | 1.8
Engr Secretary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 20 | 0 | 0.8 |  |  |  | 1.8
Engr Secretary | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 20 | 0 | 0.8 |  |  |  | 1.8
Estimating | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 38 | 0 | 0.8 |  |  |  | 1.8
Documentation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 20 | 0 | 0.8 |  |  |  | 1.8
Subtotal Engineering |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 130000
Project Management
Project Manager | 0 | 0 | 0 | 0 | 0 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 50 | 0 | 0.8 |  |  |  | 1.8
Project Secretary | 0 | 0 | 0 | 0 | 0 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 20 | 0 | 0.8 |  |  |  | 1.8
Project Estimator | 0 | 0 | 0 | 0 | 0.25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 38 | 0 | 0.8 |  |  |  | 1.8
P.Controls Mgt | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 43 | 0 | 0.8 |  |  |  | 1.8
Cost Engineer | 0 | 0 | 0 | 0 | 0 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1 | 0 | 0 | 0 | 0 | 0 |  |  |  | 45 | 0 | 0.8 |  |  |  | 1.8
Schedule Engineer | 0 | 0 | 0 | 0 | 0 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 |  |  |  | 43 | 0 | 0.8 |  |  |  | 1.8
Dept Manager |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 48 | 0 | 0.8 |  |  |  | 1.8
Procurement
Purchasing Agent | 0 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 35 | 0 | 0.8 |  |  |  | 1.8
Expeditor/Logistics |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0.2 | 0.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 35 | 0 | 0.8 |  |  |  | 1.8
Clerical/Admin Support |  |  |  |  | 0 | 0 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 20 | 0 | 0.8 |  |  |  | 1.8
Other
QA/QC Inspection |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 35 | 0 | 0.8 |  |  |  | 1.8
Start-up Comissioning |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 35 | 0 | 0.8 |  |  |  | 1.8
Contracts Manager |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 35 | 0 | 0.8 |  |  |  | 1.8
Clerical/Sec.Support |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 20 | 0 | 0.8 |  |  |  | 1.8
Subtotal Project Mgmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 129200
Environmental
Environmental Engineer | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 26 | 0.35 | 0 |  |  |  | 1.35
Agent (Contract Field) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 35 | 0 | 0 |  |  |  | 1
Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Environmental |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 42000
Right of Way
Manager | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 35 | 0.35 | 0 |  |  |  | 1.35
Agent (Contract Field) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 65 | 0 | 0 |  |  |  | 1
Secretarial Support |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 0.35 | 0 |  |  |  | 1.35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Subtotals | Labor Subtotals | Labor Subtotals | Labor Subtotals | Labor Subtotals
Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Acquiring ROW
Land Acquisition
[NAME], Permits, Survey
Subtotal Right of Way |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 7400
Engineering Expenses
Travel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Travel
As-Built Drawings
Design Engineering |  |  |  |  |  |  | 10000 | 10000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Design Engineering Contractor
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Project Mgt Expenses
Project Management Travel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project Management Travel | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other-Travel
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Travel & Expenses |  |  | 0
Equip.Inspection Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Third Party Inspection | 0 |  | 0
Design Engineering
Design Engineering | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0.8 |  |  |  | 2.46 |  |  | 0
Total Home Office Man-Months
Construction Mgmt
Construction Manager (Field) | 0 | 0 | 0 | 0 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  | 173.3 |  | 60 | 0 | 0 |  |  |  | 1
Inspector | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 173.3 |  | 50.9815 | 0 | 0 |  |  |  | 1
Start-up / Commissioning | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 173.3 |  | 50.9815 | 0 | 0 |  |  |  | 1
NON PAYROLL EXPENSES
Field Office Expenses
Surveys
Radiography
Vendor Commissioning
Field Staff Per Diem
Subtotal Construction Mgmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Man-Months
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spent EECC Ovh : |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] :