Attachment B - Cost Estimate QUUG 25-1003 BLANK.xlsx

XLSX spreadsheet 42 KB Posted

Attached to
Repair Overhead Transformer, B904
Solicitation number
FA557525B0012
Issued by

About this file

The file is a detailed Construction Cost Estimate Breakdown for a Department of the Air Force project at Moron Air Base in Spain, specifically for repairing an overhead transformer at Building 904. The estimate, prepared by Kellogg Brown & Root on February 7, 2025, breaks down the project into two Contract Line Item Numbers (CLINs): a Design Package (CLIN #1) and a Basic Package (CLIN #2), with a comprehensive breakdown of work categories including demolition, civil works, and electrical works.

The project involves removing existing overhead transformers, high voltage lines, and electrical utilities from Buildings 904 and 943, followed by installation of new infrastructure such as a prefabricated transformer building, underground conduits, and electrical systems. The cost estimate includes detailed line items for tasks like cable installations, equipment placement, grounding systems, and lighting fixtures. The solicitation (FA557525B0012) follows a two-step sealed bidding process, with technical proposals due by July 29, 2025, at 10:00 hours local time, to be submitted via email to specified Air Force contracting team members. While the current estimate shows zero dollar amounts, it provides a structured framework for potential contractors to develop their pricing.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

SUMMARY

CONSTRUCTION COST ESTIMATE BREAKDOWN
CONTRACTORADDRESS
CONTRACT FOR (Work to be performed)
RPR, Overhead Transformer, B904
PURCHASE REQUEST NUMBERPROJECT NUMBERWORK LOCATION
QUUG 25-1003MORÓN AIR BASE, SPAIN
ITEMTOTAL PROJECT COST (Eur)
(1)
SUMMARY

RESUMEN

CLIN #1: DESIGN PACKAGE

CLIN #1: PAQUETE DE DISEÑ0

TOTAL PROJECT COST OF BASIC PACKAGE INCLUDING OVERHEAD AND PROFIT

COSTE TOTAL DEL PROYECTO DE PAQUETE BÁSICO INCLUYENDO GASTOS GENERALES Y BENEFICIO

TOTAL CLIN #1: DESIGN PACKAGE
TOTAL CLIN #1: PAQUETE DE DISEÑO0.00

CLIN #2 BASIC PACKAGE

CLIN #2: PAQUETE BASICO

TOTAL PROJECT COST OF BASIC PACKAGE INCLUDING OVERHEAD AND PROFIT

COSTE TOTAL DEL PROYECTO DE PAQUETE BÁSICO INCLUYENDO GASTOS GENERALES Y BENEFICIO

TOTAL CLIN #2: BASIC PACKAGE
TOTAL CLIN #2: PAQUETE BÁSICO0.00
TOTAL AMOUNT (€)
IMPORTE TOTAL (€)€ - 0
TOTAL AMOUNT ($)
IMPORTE TOTAL ($)$ - 0

&"Times New Roman,Regular"Page &P of &N

CLIN #1 DESING PACKAGE

CONSTRUCTION COST ESTIMATE BREAKDOWN
CONTRACTORADDRESS
GOVERNMENT ESTIMATEMORÓN AIR BASE, SPAIN
CONTRACT FOR (Work to be performed)PROPOSED TOTAL CONTRACT PRICE
RPR, Overhead Transformer, B904CLIN #1 DESIGN PACKAGE0.00 €$0.00
PURCHASE REQUEST NUMBERPROJECT NUMBERWORK LOCATION
QUUG 25-1003MORÓN AIR BASE, SPAIN
UNITMATERIAL COSTLABOR COSTSOTHER
LINITEMOFDIRECTLINE
NO.MEAS.QUANTI.UNITTOTALMH/MDAV.RATTOTALCOSTSTOTAL
(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)
135% Design submission
Presentación del 35% del diseñou
265% Design submission
Presentación del 65% del diseñou
395% Design submission
Presentación del 95% del diseñou
4100% Design submission
Presentación del 100% del diseñou

TOTAL MATERIAL COSTS 0.00

TOTAL LABOR COSTS 0.00

TOTAL OTHER DIRECT COSTS 0.00

TOTAL DIRECT COSTS 0.00

OVERHEAD 15.00% 0.00

SUBTOTAL 0.00

PROFIT 10.00% 0.00

TOTAL PROJECT EUROS0.00
$10.9249euros
TOTAL PROJECT US$0.00

DATE: 7 February 2025 FIRM NAME: KELLOG BROWN & ROOT.

TITLE: ELECTRICAL ENGINEER BY: LUIS RODRíGUEZ LóPEZ

These costs and overhead and profit percentages will be applied in any possible future modifications

&"Times New Roman,Regular"INDEPENDENT GOVERNMENT ESTIMATE &"Times New Roman,Bold"FOR OFFICIAL USE ONLY &"Times New Roman,Regular"Page &P of &N

CLIN #2 BASIC PACKAGE

CONSTRUCTION COST ESTIMATE BREAKDOWN
CONTRACTORADDRESS
GOVERNMENT ESTIMATEMORÓN AIR BASE, SPAIN
CONTRACT FOR (Work to be performed)PROPOSED TOTAL CONTRACT PRICE
RPR, Overhead Transformer, B904CLIN #2 BASIC PACKAGE0.00 €$0.00
PURCHASE REQUEST NUMBERPROJECT NUMBERWORK LOCATION
QUUG 25-1003MORÓN AIR BASE, SPAIN
UNITMATERIAL COSTLABOR COSTSOTHER
LINITEMOFDIRECTLINE
NO.MEAS.QUANTI.UNITTOTALMH/MDAV.RATTOTALCOSTSTOTAL
(1)(2)(3)(4)(5)(6)(7)(8)(9)(10)
DEMOLITION WORKS
TRABAJOS DE DEMOLICIÓN
1Removal and transport to landfill of Bldg #904 overhead transformer.
Desmontaje y transporte a vertedero de transformador aereo del edificio #904JOBLS
2Removal and transport to landfill of crossarms and concrete pole 2-53.
Desmontaje y transporte a vertedero de crucetas y apoyo de hormigon 2-53.JOBLS
3Removal overhead High Voltage line, crossarms and CUT-OUT protections.
Desmontaje de linea aerea de alta tension, crucetas y protecciones CUT-OUT.JOBLS
4Removal and transport to landfill of Bldg #943 transformer vault and electrical utilities.
Desmontaje y transporte a vertedero de cento de transformacion prefabricado del edificio #943 y el equipamiento electrico.JOBLS
5Removal and transport to landfill of crossarms and concrete pole 2-51.
Desmontaje y transporte a vertedero de crucetas y apoyo de hormigon 2-51.JOBLS
6Removal overhead High Voltage line between 2-51 and 2-52 concrete poles.
Desmontaje de linea aerea de alta tension entre postes de hormigon 2-51 y 2-52.JOBLS
STANDARD DEMOLITION WORKS TOTAL
TOTAL TRABAJOS DE DEMOLICIÓN ESTÁNDAR0.000.000.000.00

CIVIL WORKS

OBRA CIVIL

7Levelling of the area.
Nivelación de la zonaCM
8Excavation for new utility vault, inc. sand bed
Excavación para nuevo centro de transformación, con lecho de arena.CM
9Backfill and compaction.
Relleno y compactación.CM
10Install pre-manufactured building 3.22 x 2.50 m.
Instalación edificio prefabricado 3.22 x 2.50 mEa
11Turf seeding.
Siembra de céspedSm
12Underground drilling
Perforacion subterranealm
13Underground low voltage conduit for power supply to building 904 and 943.
Canalización de baja tension para alimentacion de edificios 904 y 943.Lm
14High voltage A1 type prefabricated manhole with cover D-400.
Arqueta prefabricada tipo A1 alta tension con tapa D-400.Ea
CIVIL WORKS TOTAL
TOTAL TRABAJOS DE CIVIL0.000.000.000.00
ELECTRICAL WORKS
TRABAJOS DE ELECTRICIDAD
New Transformer Vault, Bldg #904 & Bldg #943
Nuevo Centro de Transformación, Edificios #904 y #943
15High voltage RHZ1 OL 12/20 kV 1x35 mm² Cu.
Cable alta tensión RHZ1 OL 12/20 kV 1x35 mm² Cobre.Lm
16High Voltage Cable Terminals Indoors/Outdoors.
Terminales Cable Alta Tensión Uso Interior/ExteriorEa
17Line Cabinet SM AirSet-IM.
Celda de Línea SM AirSet-IM.Ea
18Install transformer Protection Cabinet SM AirSet-QM.
Instalar celda de Proteccion Transformador SM AirSet-QM.Ea
19Install transformer 12470/208V, 250 KVA 60 Hz Dyn11.
Instalar transformador 12470/208V, 250 KVA 60 Hz Dyn11Ea
20HV cable jumpers between HV cabinet and transformers.
Puentes de media tension entre Celdas M.T y transformador.Ea
21Life Saving Kit.
Kit de Seguridad.Ea
22Copper cable 1x150 mm2 RZ1-K (AS) 0.6/1 kV.
Cable de cobre 1x150 mm2 RZ1-K (AS) 0.6/1 kV.Lm
23Copper cable 1x4 mm2 H07V-K (AS) 450/750V.
Cable de cobre 1x4 mm2 H07V-K (AS) 450/750V.Lm
243/4" RMC including couplings & accessories.
Conducto rígido acero galv. 3/4", incluso manguitos y accesorios.Lm
25Main distribution panelboard MDP.
Cuadro de distribución principal MDPEa
26Weatherproof lighting fixture 32W.
Luminaria estanca 32 W.Ls
27LED floodlighting fixture.
Proyector LED.Ea
28Ligthing emergency kit.
Kit de alumbrado de emergencia.Ea
29Grounding system.
Sistema de puesta a tierra.Ls
30Receptacle & toggle switch with conduit and wiring.
Enchufe e interruptor con cableado y conducto.Ea
New Transformer Vault, Bldg #1536.
Total Nuevo Centro de Transformación, Edif #1536.0.000.000.000.00
New UG lines
Nuevas líneas enterradas
31Copper cable 1x150 mm2 RZ1-K (AS) 0.6/1 kV.
Cable de cobre 1x150 mm2 RZ1-K (AS) 0.6/1 kVLm
1Copper cable 1x95 mm2 RZ1-K (AS) 0.6/1 kV.
Cable de cobre 1x95 mm2 RZ1-K (AS) 0.6/1 kVLm
1Copper cable 1x240 mm2 RZ1-K (AS) 0.6/1 kV.
Cable de cobre 1x240 mm2 RZ1-K (AS) 0.6/1 kVLm
1Copper cable 1x150 mm2 RZ1-K (AS) 0.6/1 kV.
Cable de cobre 1x150 mm2 RZ1-K (AS) 0.6/1 kVLm
New UG lines Total
Total Nuevas líneas enterradas0.000.000.000.00
ELECTRICAL WORKS TOTAL
TOTAL TRABAJOS DE ELECTRICIDAD0.000.000.000.00
WORK SUMMARY
RESUMEN TRABAJOS
DEMOLITION WORKS
TRABAJOS DE DEMOLICION0.000.000.000.00
CIVIL WORKS
OBRA CIVIL0.000.000.000.00
ELECTRICAL WORKS
TRABAJOS DE ELECTRICIDAD0.000.000.000.00
GRAND TOTAL
GRAN TOTAL0.000.000.000.00

TOTAL MATERIAL COSTS 0.00

TOTAL LABOR COSTS 0.00

TOTAL OTHER DIRECT COSTS 0.00

TOTAL DIRECT COSTS 0.00

OVERHEAD 15.00% 0.00

SUBTOTAL 0.00

PROFIT 10.00% 0.00

TOTAL PROJECT EUROS0.00
$10.9249euros
TOTAL PROJECT US$0.00

DATE: 7 February 2025 FIRM NAME: KELLOG BROWN & ROOT.

TITLE: ELECTRICAL ENGINEER BY: LUIS RODRíGUEZ LóPEZ

These costs and overhead and profit percentages will be applied in any possible future modifications

&"Times New Roman,Regular"INDEPENDENT GOVERNMENT ESTIMATE &"Times New Roman,Bold"FOR OFFICIAL USE ONLY &"Times New Roman,Regular"Page &P of &N

File details come from the government source that posted it. Updated .