Spreadsheet: kimberly_watson__20583__PA AGAVE TW IC
Sheet: Page 2

 |  |  |  |  |  |  | ORIGINAL |  |  |  |  |  | PAGE 2 of 2
Project Definition |  | Project Title |  |  |  |  | REVISION NO.
 |  |  |  |  |  |  | CANCEL
Project WBS |  |  |  |  |  | 2 | AFUDC
 |  |  |  |  |  | 2.75 | Overhead Rate
WBS | Cost | PS | Materials |  |  |  | Qty | Unit | AFUDC | OH | Item | Current | Previous
Element | Element | Asset |  |  |  |  |  |  |  |  | Cost | Cost | Cost
.06 | 53500500 |  | [NAME]: |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 08 | 08 Flare System |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 12 | 12 Buildings |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 13 | 13 Cathodic Protection Equipment |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 14 | 14 Communication Equipment |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 16 | 16 Computer Equipment |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 18 | 18 Control Equipment |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 20 | 20 Dehydrator |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 21 | 21 Detection Equipment |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 31 | 31 Gas Loss |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 33 | 33 Pipe Coating |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 38 | 38 Land & Land Rights |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 39 | 39 Metering Equipment |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 40 | 40 Odorizers |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 45 | 45 Regulators |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 47 | 47 Separators, Scrubbers, Gas Cleaners |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 49 | 49 Station Service Lines |  |  |  | 1 | lt |  |  | 2500 |  | 0
.06 |  | 50 | 50 Tanks |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  | 51 | 51 Valves - 2" inches and over |  |  |  | 1 | lt |  |  | 10000 |  | 0
.06 |  | 54 | 54 Gas Pipe |  |  |  | 1 | lt |  |  | 5000 |  | 0
.06 |  | 99 | 99 Allocated materials |  |  |  | 1 | lt |  |  | 833 |  | 0
.06 |  |  |  |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  |  |  |  |  |  | 0 |  |  |  | 0 |  | 0
.06 |  |  |  |  |  |  | 0 |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  | TOTAL MATERIALS
 |  |  |  |  |  |  |  |  |  |  | FREIGHT | 1800 | 0
 |  |  |  |  |  |  |  |  |  |  | SALES TAX | 1350 | 0
 |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL MATERIALS + AFUDC + OH
ENVIRONMENTAL |  |  |  |  |  | Overhead |  | Interest |  |  | Planned Total | SAP Total
.01 | .01 |  | ENVR-GENERAL EXPENSE |  |  |  |  |  |  |  | 500 |  | 0
.01 | .02 |  | ENVR-PERMITS/AUTH. |  |  |  |  |  |  |  | 0 |  | 0
.01 | .03 |  | ENVR.CONST.MONITOR |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | TOTAL
CONSTRUCTION SUPPORT
.02 | .01 |  | COMPANY LABOR |  |  |  |  |  |  |  | 1200 |  | 0
.02 | .02 |  | CONTRACT LABOR |  |  |  |  |  |  |  | 0 |  | 0
.02 | .03 |  | XRAY (NDT) |  |  |  |  |  |  |  | 1000 |  | 0
.02 | .05 |  | 3RD PARTY INSPECT-ADD |  |  |  |  |  |  |  | 9692 |  | 0
.02 | .05 |  | 3RD PARTY INSPECT |  |  |  |  |  |  |  | 3500 |  | 0
.02 | .06 |  | TEST |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | TOTAL
DISTRICT LABOR AND EQUIPMENT
.03 |  |  | COMPANY LABOR |  |  |  |  |  |  |  | 4800 |  | 0
ENGINEERING
.04 | .01 |  | COMPANY LABOR |  |  |  |  |  |  |  | 4800 |  | 0
.04 | .02 |  | CONTRACT LABOR |  |  |  |  |  |  |  | 0 |  | 0
.04 | .03 |  | AS-BUILTS |  |  |  |  |  |  |  | 2500 |  | 0
 |  |  |  |  |  |  |  |  |  | TOTAL
CONTRACT INSTALLATION
.05 |  |  | CONTRACT LABOR |  |  |  |  |  |  |  | 25000 |  | 0
ROW AND OTHER
.06 | .38 | 53102200 | Real Property Purchase |  |  |  |  |  |  |  | 0 |  | 0
.06 | .38 | 53102000 | Right-of-Way |  |  |  |  |  |  |  | 500 |  | 0
.07 |  | 53102100 | Damages, Services, & Other |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | TOTAL
CONTINGENCY
.08 |  |  | CONTINGENCY |  |  |  |  |  |  | TOTAL | 7500 |  | 0
OTHER
.09 | .01 |  | OTHER GENERAL |  |  |  |  |  |  |  | 0 |  | 0
.09 | .02 |  | GAS LOSS |  |  |  |  |  |  |  | 0 |  | 0
.09 | .03 |  | QUALITY INSPECTION |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  | Total Estimated Cost
 |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 |  | Net Cost