Spreadsheet: kevin_hyatt__19616__COST ESTIMATE
Sheet: Up to FERC

SUN DEVIL PIPELINE PROJECT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enron Asset Management Resources
(Preliminary Estimate)
COST ESTIMATE TO FERC FILING
Based on 450 miles of 36"
Bloomfield C/S to Phoenix Cavern
Does Not Include [NAME] to [NAME])
PREPARED BY: |  |  |  |  | DC/SSK/DH
DATE: |  |  |  |  | 2001-09-19 00:00:00
 | Months |  |  |  | STAFFING |  |  |  |  |  |  | MAN |  |  |  |  |  |  |  |  |  | GRAND | Total | Expended | Forecast | Control
FUNCTION | Sep 95 | Oct | Nov | Dec | 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 | MONTHS | Hrs/Month | Total Hrs | $'s/Hr | [NAME] | OH Rate | Sal+Burden | OH $ | SubTotal | Mult | TOTAL | w/o [NAME] | ToDate | w/o [NAME] | Budget
Project Management (ETS)
Project Manager (Cebryk/Eisenstein) | 0 | 0 | 0 | 0 | 0.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 | 1.5 |  |  |  | 50 | 0 | 0.8 |  |  |  | 1.8
Project Secretary | 0 | 0 | 0 | 0 | 0.1 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  | 25 | 0 | 0.8 |  |  |  | 1.8
Project Est. Dir. ([NAME]) | 0 | 0 | 0 | 0 |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  | 48 | 0 | 0.8 |  |  |  | 1.8
Project Est. (Davis/Thomas) |  |  |  |  | 0.24 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 44 | 0 | 0.8 |  |  |  | 1.8
P.Controls Mgt (Hubbard) | 0 | 0 | 0 | 0 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 43 | 0 | 0.8 |  |  |  | 1.8
Cost Engineer (Kalmus) | 0 | 0 | 0 | 0 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  | 45 | 0 | 0.8 |  |  |  | 1.8
Dept Manager (Mathews) |  |  |  |  | 0.1 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 48 | 0 | 0.8 |  |  |  | 1.8
Procurement (ETS)
Purchasing Agent | 0 | 0 | 0 | 0 | 0.1 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 |  |  |  | 40 | 0 | 0.8 |  |  |  | 1.8
Expeditor/Logistics |  |  |  |  |  | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 | 0.4 |  |  |  | 36 | 0 | 0.8 |  |  |  | 1.8
Clerical/Admin Support |  |  |  |  |  | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 |  |  |  | 22 | 0 | 0.8 |  |  |  | 1.8
Other (ETS)
Contracts Manager |  | 0 | 0 | 0 |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  | 40 | 0 | 0.8 |  |  |  | 1.8
Clerical/Sec.Support |  | 0 | 0 | 0 |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  | 22 | 0 | 0.8 |  |  |  | 1.8
Environmental |  | 0 | 0 | 0 |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  |  |  | 42 | 0 | 0.8 |  |  |  | 1.8
Project Management Expenses (ETS)
Project Management Travel |  |  |  |  | 8000 | 3000 | 3000 | 3000 | 3000 | 5000 | 5000
Subtotal Project Management
Engineering Pipeline & Compression (Contract)
Project Managers | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  | 110 | 0
Project Engineering Managers | 0 | 0 | 0 | 0 | 1 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  | 110 | 0
Project Engineers | 0 | 0 | 0 | 0 | 0.5 | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  | 100 | 0
Elect Engineers | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  | 100 | 0
Civil Engineers | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  | 100 | 0
Pipeline Engineers |  |  |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  | 100 | 0
Lead Designers | 0 | 0 | 0 | 0 |  | 4 | 4 | 4 | 4 | 4 | 4 |  |  |  | 100 | 0
Designers | 0 | 0 | 0 | 0 | 0 | 8 | 8 | 8 | 8 | 8 | 8 |  |  |  | 100 | 0
Engr Secretary | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  | 50 | 0
Estimator/Scheduler | 0 | 0 | 0 | 0 |  | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  | 100 | 0
Documentation | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 50 | 0
Engineering Expenses (Contract)
Engineering Travel |  |  |  |  | 3000 | 3000 | 5000 | 5000 | 5000 | 5000 | 5000
Reproduction |  |  |  |  |  | 2000 | 2000 | 2000 | 2000 | 2000 | 2000
Computer Charges |  |  |  |  |  | 3000 | 3000 | 3000 | 3000 | 3000 | 3000
Field Survey --- 450 miles @ $3,000/mile
Subtotal Engineering |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 130000
Environmental (Contract)
Environmental Engineer  --- See attachment for details | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1115000
Agent (Contract Field) --- See attachment for details | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
Expenses  --- See attachment for details |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Environmental |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 42000
Regulatory (ETS)
Regulatory | 0 | 0 | 0 | 0 | 0.2 | 0.6 | 0.5 | 0.5 | 0.6 | 1 | 1 |  |  |  | 50 |  | 0.8 |  |  |  | 1.8
Legal |  |  |  |  |  | 0 | 0 | 0 | 0.2 | 0.2 | 0.3 |  |  |  | 65 |  | 0.8 |  |  |  | 1.8
Financial | 0 | 0 | 0 | 0 |  |  |  |  | 0.2 | 0.2 | 0.4 |  |  |  | 50 | 0 | 0.8 |  |  |  | 1.8
Regulatory Expenses (ETS)
Reprodution & Postage |  |  |  |  |  |  |  |  |  |  | 7500
Newspaper Advertising |  |  |  |  |  |  |  |  |  |  | 25000
Meetings with FERC |  |  |  |  |  | 5000 |  |  |  | 5000
Open Houses |  |  |  |  |  |  |  |  | 10000 | 1000 | 5000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Subtotal Regulatory/Legal/Financial
Right of Way (ETS)
ROW Direct | 0 | 0 | 0 | 0 | 0.1 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 |  |  |  | 65 |  | 0.8 |  |  |  | 1.8
ROW Project Manager |  | 0 | 0 | 0 | 0.3 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 | 0.7 |  |  |  | 47 | 0 | 0.8 |  |  |  | 1.8
ROW Specialists |  |  |  |  | 0.5 | 0.5 | 0.6 | 0.55 | 0.65 | 0.65 | 0.5 |  |  |  | 40 | 0 | 0.8 |  |  |  | 1.8
[NAME], Permits, Survey (Lead) |  |  |  |  | 0.67 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 | 1.45 |  |  |  | 43 | 0 | 0.8 |  |  |  | 1.8
[NAME], Permits, Survey |  |  |  |  | 0.25 | 4.7 | 4.7 | 4.7 |  |  |  |  |  |  | 40 | 0 | 0.8 |  |  |  | 1.8
Secretarial Support |  |  |  |  | 0.25 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 | 0.6 |  |  |  | 25 |  | 0.8 |  |  |  | 1.8
Right of Way Expenses (ETS)
ROW Agent Expenses, Per Diem, Office Exp. |  |  |  |  |  | 56650 | 56650 | 56650 | 26500 | 26500
Acquiring ROW, Land Acquisition & |  |  |  |  |  | 25000 | 25000 | 25000 | 25000 | 25000 | 25000
Titles, Permits, Survey
Subtotal Right of Way |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 7400
Aerial Photography --- 450 miles @ $500/mile | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0
Construction Mgmt
Construction Manager | 0 | 0 | 0 | 0 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 |  | 173.3 |  | 60 | 0 | 0.8 |  |  |  | 1.8
Start-up / Commissioning | 0 | 0 | 0 | 0 |  |  |  |  |  | 0.5 | 0.5 |  | 173.3 |  | 50.9815 | 0 | 0.8 |  |  |  | 1.8
Subtotal Construction Mgmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Man-Months & Without Contingency
Contingency --- 10%
Total