Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Turnkey

TURNKEY COMPONENTS & CONSTRUCTION TAX ESTIMATES
TURNKEY COMPONENTS |  |  |  |  |  | EPC w/ |  |  |  |  |  | Approved Change Orders (01/28/2000 Monthly Progress Report)
Equipment Detail |  |  |  |  |  | Old Tax | Phase I | Phase II | Phase III | Total |  |  |  |  |  |  |  | Amount
Lump Sum Power Plant |  |  |  |  |  | 183361 |  |  |  |  |  | PCO-003 Fuel System Low Flash Consultant |  |  |  |  |  | 26.393
Subtotal - Power Plant Turnkey |  |  |  |  |  |  |  |  |  |  |  | PCO-004 Step-Up Transformer Design Changes |  |  |  |  |  | 447
 |  |  |  |  |  |  |  |  |  |  |  | PCO-005 Effluent Discharge Line |  |  |  |  |  | 355.834
C.O. #1 - Late Payment Interest Expense |  |  |  |  |  | 123.768 |  |  |  |  |  | PCO-009 Separate Site Access For Operations |  |  |  |  |  | 96.263
C.O. #2 - IPP Substation |  |  |  |  |  | 4220 |  |  |  |  |  | PCO-012 Cascading Blowdown |  |  |  |  |  | 34.474
C.O. #3 - Late Payment Interest Expense |  |  |  |  |  | 84.909 |  |  |  |  |  | PCO-016 Water Treatment Chemicals & Safety Equipment |  |  |  |  |  | 49.442
C.O. #4 - Warehouse Crane |  |  |  |  |  | 40 |  |  |  |  |  | PCO-023 Credit To EPE For 8 Water Reducing Stations |  |  |  |  |  | -450
C.O. #5 - Water Treatment Plant |  |  |  |  |  | 2999.25 |  |  |  |  |  | PCO-025 Operating Accords - Engineering Support |  |  |  |  |  | 109.722
C.O. #6 - Evaporative Cooler Decarbonization |  |  |  |  |  | 51 |  |  |  |  |  | PCO-026 Salvage Association Costs Trhough August 1999 |  |  |  |  |  | 237.998
C.O. #7 - Relocation Of Fuel Oil Tanks |  |  |  |  |  | 500 |  |  |  |  |  | PCO-029 Power Supply For River Water Intake |  |  |  |  |  | 298.132
C.O. #8 - Fuel Oil Metering Upgrade |  |  |  |  |  | 16.3 |  |  |  |  |  | PCO-030 Water Treatment Intake, Pipeline And Treatment Plant |  |  |  |  |  | 10012.339
C.O. #9 - Weather Station |  |  |  |  |  | 6 |  |  |  |  |  | PCO-031 WTP-SCC Project Mgmt./Geotech. Investigation |  |  |  |  |  | 509.464
Subtotal - Approved Change Orders |  |  |  |  |  |  |  |  |  |  |  | PCO-033 C/T Return Lube Oil Pump Contro Logic |  |  |  |  |  | 29.88
 |  |  |  |  |  |  |  |  |  |  |  | PCO-034 Pressure Switch For Lube Oil Pump Control Logic |  |  |  |  |  | 47.648
[NAME] |  |  |  |  |  | 500 |  |  |  |  |  | PCO-035 Additional Equip. For Coxipo Phase III Substation Bay |  |  |  |  |  | 125.626
Hydrology (Geosolo) |  |  |  |  |  | 15 |  |  |  |  |  | PCO-036 Implementation Of Motor Hour-Meters Within The Teleperm |  |  |  |  |  | 21.873
Access Roads & Laydown |  |  |  |  |  | 600 |  |  |  |  |  | PCO-038 SCC Extended Overheads For 7/15/99 PPL RFS |  |  |  |  |  | 1085
Transmission & Distribution |  |  |  |  |  | 14365.567 |  |  |  |  |  | PCO-041 Supply & Installation Of 3rd Grit Chamber For Water Intake |  |  |  |  |  | 50.67
Subtotal - Offsites & Interconnects |  |  |  |  |  |  |  |  |  |  |  | PCO-050 Redesign Of Effluent Lagoons by ETEP |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  |  |  |  | PCO-052 Additional Road Design |  |  |  |  |  | 9.462
Pre-NTP Engineering |  |  |  |  |  | 394.913 |  |  |  |  |  | PCO-064 Installation Of Additional HICOM Card |  |  |  |  |  | 3.238
Project Management |  |  |  |  |  | 2921.792 |  |  |  |  |  | Total Approved Change Orders |  |  |  |  |  |  |  |  | 3630.827400000001
Construction Management |  |  |  |  |  | 5096.75
Warranty Management |  |  |  |  |  | 45 |  |  |  |  |  | Pending/Forecasted Change Orders (01/28/2000 Monthly Progress Report)
Indemnity Fee Wrap |  |  |  |  |  | 7881.134 |  |  |  |  |  |  |  |  |  |  |  | Amount
Subtotal - EE&CC Costs |  |  |  |  |  |  |  |  |  |  |  | Other Pending Change Orders |  |  |  |  |  | 1008
 |  |  |  |  |  |  |  |  |  |  |  | Proposed Settlement - Effluent System |  |  |  |  |  | 1450
Taxes & Duties (Not To Exceed Amount) |  |  |  |  |  | 15244 |  |  |  |  |  | Forcasted Change Orders
Subtotal - Taxes & Duties |  |  |  |  |  |  |  |  |  |  |  | Total Approved Change Orders
Total [NAME] (Excluding Escalation On Brazilian Sourced) |  |  |  |  |  |  |  |  |  |  |  | Adjustment For Turnkey Taxes (Based On Exemptions) |  |  |  |  |  | Revised | Original | Gross | EPE | Net
 |  |  |  |  |  |  |  |  |  |  |  | Revised Tax Estimate |  |  |  |  |  | Taxes | Taxes | Savings | % | Savings
 |  |  |  |  |  |  |  |  |  |  |  | II - Import Tax |  |  |  | 0=Filed For Reimbursment, 1=[NAME] | 0 |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | IPI - Federal Excise Tax |  |  |  | 0=Change In Law, 1=[NAME] | 1 |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | AFRMM |  |  |  | 0=Exempt, 1=[NAME] | 1 |  | 0 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | ICMS - Merchandise |  |  |  | 0=Exempt, 1=[NAME] | 0 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | ISS |  |  |  | 0=Exempt, 1=[NAME] | 0 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Witholding On Services |  |  |  | 0=Exempt, 1=[NAME] | 0 |  | 0 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Pis / Cofins |  |  |  | 0=Change In Law, 1=[NAME] | 1 |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  |  | Banking Charges |  |  |  | 0=Filed For Reimbursment, 1=[NAME] | 0 |  | 0 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Contingency Allowance |  |  |  | 0=On, 1=Off | 1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Subtotal - Revised Taxes & Duties
 |  |  | (A) | (B) |  |  | (C) | (D) |  | (E) |  | (F) | (G) |  | (H) |  | (I) |  | (J) | (K) |  | (L) | (M) |  | (N)
 |  |  |  |  |  | II |  |  | IPI |  | AFRMM |  | =(D)+(E)+(F) | ICMS |  | ISS |  | W/H |  | =([NAME]) | Pis/Cofins |  | =([NAME]) | Bank Chg
 | Total | (E)ngineer | CIF w/o E | (F)reight | CIF w/o E,F | on (A) | II | =(A)+(C) | on (D) | IPI | on (B) | AFRMM | +(E)ng+(F)rt | on (G) | ICMS | on (E)ng | ISS | on (E)ng | W/H | +(J) Less (E) | on (K) | Pis/Cofins | +(J)+(L) | on [NAME] | Bank Chg
Local Hardware | 23953.385 | 0 |  | 0 |  | 0 |  |  | 0.05 |  | 0 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0.0265 |  |  | 0.002
Local Civil Hardware | 9142.058 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0.0265 |  |  | 0.002
Local Software | 21904.558 | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0.0265 |  |  | 0.002
Total Onshore
Cables | 28.293 | 4.012 |  | 0.387 |  | 0.03 |  |  | 0.05 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
Civil | 1125.615 | 159.607 |  | 15.399 |  | 0.17 |  |  | 0.1 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
Condenser | 3248.818 | 460.667 |  | 44.444 |  | 0.03 |  |  | 0 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
[NAME] | 2962.386 | 420.053 |  | 40.526 |  | 0.03 |  |  | 0.1 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
CTG | 56304.639 | 7983.739 |  | 770.257 |  | 0.03 |  |  | 0 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
Fuel Supply | 3833.964 | 543.638 |  | 52.449 |  | 0.03 |  |  | 0.08 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
[NAME] | 30728.834 | 4357.207 |  | 420.376 |  | 0.03 |  |  | 0 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
I&C | 4630.096 | 656.526 |  | 63.34 |  | 0.03 |  |  | 0.15 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
Pipes | 3780.102 | 536.001 |  | 51.712 |  | 0.03 |  |  | 0.08 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
Pumps | 125.677 | 17.82 |  | 1.719 |  | 0.03 |  |  | 0 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
STG | 18698.742 | 2651.396 |  | 255.802 |  | 0.03 |  |  | 0 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
Tanks | 514.133 | 72.902 |  | 7.033 |  | 0.2 |  |  | 0.1 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
Vessels | 1303.286 | 184.8 |  | 17.829 |  | 0.2 |  |  | 0.1 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
Water Treatment | 1076.415 | 152.631 |  | 14.726 |  | 0.17 |  |  | 0.04 |  | 0.25 |  |  | 0 |  | 0 |  | 0.15 |  |  | 0 |  |  | 0.002
Total Offshore
Total Onshore & Offshore
Turnkey Original | Price | Sourcing % |  | Allocation |  | Tax % |  |  |  |  | Tax Amounts
Construction Tax Estimate | Total | Foreign | Local | Foreign | Local | ICMS | IPI | II | ISS | Pis/Cofins | ICMS | IPI | II | ISS | Pis/Cofins | Contingency | Total
Combustion Turbine Generator | 48033 | 1 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0
Steam Turbine Generator | 19986 | 1 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0
Heat Recovery Steam Generator | 13454 | 1 |  |  |  | 0 | 0 | 0.17 | 0 | 0 |  |  |  |  |  | 0
Tanks - Shop Fabricated (SC) | 2544 |  | 1 |  |  | 0.17 | 0.1 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Emergency Generator | 170 |  | 1 |  |  | 0 | 0 | 0.17 | 0 | 0 |  |  |  |  |  | 0
Compressed Air Equipment | 1069 | 1 |  |  |  | 0 | 0 | 0.17 | 0 | 0 |  |  |  |  |  | 0
Steam Condenser | 2440 |  | 1 |  |  | 0.07 | 0 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Pumps - Boiler Feed | 899 | 1 |  |  |  | 0 | 0 | 0.17 | 0 | 0 |  |  |  |  |  | 0
Pumps - Condensate | 574 |  | 1 |  |  | 0.07 | 0 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Pumps - Circulating Water | 1208 | 1 |  |  |  | 0 | 0 | 0.17 | 0 | 0 |  |  |  |  |  | 0
Pumps - Miscellaneous (SC) | 293 |  | 1 |  |  | 0.07 | 0 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Filters | 293 |  | 1 |  |  | 0.07 | 0.08 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Auxiliary Cranes & Hoists | 1213 |  | 1 |  |  | 0.07 | 0 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Pipe- Local | 3203 |  | 1 |  |  | 0.07 | 0.08 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Pipe-Inported | 2135 | 1 |  |  |  | 0 | 0.08 | 0.17 | 0 | 0 |  |  |  |  |  | 0
Valves - Local | 831 |  | 1 |  |  | 0.07 | 0.08 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Valves - Imported | 554 | 1 |  |  |  | 0 | 0.08 | 0.17 | 0 | 0 |  |  |  |  |  | 0
Demineralization Equipment | 736 |  | 1 |  |  | 0.17 | 0.04 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Chemical Water Treatment | 69 |  | 1 |  |  | 0.07 | 0 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Dosing and Sampling | 900 |  | 1 |  |  | 0.07 | 0.04 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Transformers - GSU | 5627 |  | 1 |  |  | 0.07 | 0 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Batteries & Battery Charger | 311 |  | 1 |  |  | 0.07 | 0 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Cables | 293 |  | 1 |  |  | 0.17 | 0.05 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Switchgear & Bus Duct | 9074 |  | 1 |  |  | 0.07 | 0 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Electrical Equipment -Local | 4516 |  | 1 |  |  | 0.07 | 0 | 0 | 0 | 0.0265 |  |  |  |  |  | 0
Electrical Equipment -Imported | 1505 | 1 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0
I&C Equipment | 7940 | 1 |  |  |  | 0 | 0.15 | 0.18 | 0 | 0 |  |  |  |  |  | 0
Civil Work | 26720 |  | 1 |  |  | 0 | 0 | 0 | 0.05 | 0.0265 |  |  |  |  |  | 0
Construction Commisioning | 24010 |  | 1 |  |  | 0 | 0 | 0 | 0.05 | 0.0265 |  |  |  |  |  | 0
Contingency |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000
Total Direct Costs