2.2.1(f) Attachment F-CLIN Pricing Excel Sheet.pdf
PDF 98 KB Posted
- Solicitation number
- 70FBR226R00000018
- Issued by
-
Federal Emergency Management Agency
About this file
This is a CLIN Pricing Proposal Excel Sheet for HVAC equipment replacement and installation at Naval Weapons Station Earle (NWSE) Building C-54. The project encompasses the procurement and installation of multiple air handling units across four locations: three rooftop units, one server room unit, and two heating and ventilation units for the warehouse. Specific equipment includes four Carrier Air Handler Roof Top Units (RTUs) with varying capacities (40 ton, 30 ton, 3 ton, and 12.5 ton), one Liebert Air Handler Server Room unit (5 ton), and two Heating and Ventilation Units for the warehouse with currently unavailable specifications.
The pricing structure breaks down costs for each equipment line item into five cost categories: Material Costs, Labor Costs, Other Direct Costs, Overhead, and Profit. Each CLIN (Contract Line Item Number) is designated with a letter suffix (A through E) corresponding to these cost components. The spreadsheet currently shows only one priced item (CLIN 0001A for RTU #1 Material Costs at $1.00), with all remaining line items blank and awaiting vendor pricing. The project includes a bonding requirement calculated at 3 percent of total project cost. All quantities are listed as "1 Each" or "2 Each" per unit, with unit prices and total prices to be completed by the vendor, culminating in a total project cost to be determined upon completion of all pricing entries.
View the file
Other files
Show all 33
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
Attachment F: CLIN Pricing Proposal Excel Sheet
CLIN Buyer Description Quantity Unit Vendor Unit Price Total Price
0001A
Air Handler Roof Top Unit (RTU) #1 Material Costs Weight: 40 Ton Make: Carrier Model: 50P3040610J73Q74C Serial / Identification Number: 4712U52007
1 Each $ 1.00 $ 1.00
0001B
Air Handler Roof Top Unit (RTU) #1 Labor Costs Weight: 40 Ton Make: Carrier Model: 50P3040610J73Q74C Serial / Identification Number: 4712U52007
1 Each $ -
0001C
Air Handler Roof Top Unit (RTU) #1 Other Direct Costs Weight: 40 Ton Make: Carrier Model: 50P3040610J73Q74C Serial / Identification Number: 4712U52007
1 Each $ -
0001D
Air Handler Roof Top Unit (RTU) #1 Overhead Weight: 40 Ton Make: Carrier Model: 50P3040610J73Q74C Serial / Identification Number: 4712U52007
1 Each $ -
0001E
Air Handler Roof Top Unit (RTU) #1 Profit Weight: 40 Ton Make: Carrier Model: 50P3040610J73Q74C Serial / Identification Number: 4712U52007
1 Each $ -
0002A
Air Handler Roof Top Unit (RTU) #2 Material Costs Weight: 30 Ton Make: Carrier Model: 50A3030PQ62AHH Serial / Identification Number: 4712U51847
1 Each $ -
0002B
Air Handler Roof Top Unit (RTU) #2 Labor Costs Weight: 30 Ton Make: Carrier Model: 50A3030PQ62AHH Serial / Identification Number: 4712U51847
1 Each $ -
0002C
Air Handler Roof Top Unit (RTU) #2 Other Direct Costs Weight: 30 Ton Make: Carrier Model: 50A3030PQ62AHH Serial / Identification Number: 4712U51847
1 Each $ -
0002D
Air Handler Roof Top Unit (RTU) #2 Overhead Weight: 30 Ton Make: Carrier Model: 50A3030PQ62AHH Serial / Identification Number: 4712U51847
1 Each $ -
0002E
Air Handler Roof Top Unit (RTU) #2 Profit Weight: 30 Ton Make: Carrier Model: 50A3030PQ62AHH Serial / Identification Number: 4712U51847
1 Each $ -
Line Item(s) Base Period
0001 - Naval Weapons Station Earle (NWSE) Building C-54 Rooftop Item: Air Handler Roof Top Unit (RTU) #1
0002 - Naval Weapons Station Earle (NWSE) Building C-54 Rooftop Item: Air Handler Roof Top Unit (RTU) #2
0003A
Air Handler Roof Top Unit (RTU) #3 Material Costs Weight: 3 Ton Make:
Carrier Model:
50TM004A601 Serial / Identification Number: 24050334
1 Each $ -
0003B
Air Handler Roof Top Unit (RTU) #3 Labor Costs Weight: 3 Ton Make:
Carrier Model:
50TM004A601 Serial / Identification Number: 24050334
1 Each $ -
0003C
Air Handler Roof Top Unit (RTU) #3 Other Direct Costs Weight: 3 Ton Make: Carrier Model: 50TM004A601 Serial / Identification Number: 24050334
1 Each $ -
0003D
Air Handler Roof Top Unit (RTU) #3 Overhead Weight: 3 Ton Make:
Carrier Model:
50TM004A601 Serial / Identification Number: 24050334
1 Each $ -
0003E
Air Handler Roof Top Unit (RTU) #3 Profit Weight: 3 Ton Make:
Carrier Model:
50TM004A601 Serial / Identification Number: 24050334
1 Each $ -
0004A
Air Handler Roof Top Unit (RTU) #4 Material Costs Weight: 12.5 Ton Make: Carrier Model: 50TCD14A3A5A2F0A0 Serial / Identification Number: 4612G20157
1 Each $ -
0004B
Air Handler Roof Top Unit (RTU) #4 Labor Costs Weight: 12.5 Ton Make: Carrier Model: 50TCD14A3A5A2F0A0 Serial / Identification Number: 4612G20157
1 Each $ -
0004C
Air Handler Roof Top Unit (RTU) #4 Other Direct Costs Weight: 12.5 Ton Make: Carrier Model: 50TCD14A3A5A2F0A0 Serial / Identification Number: 4612G20157
1 Each $ -
0004D
Air Handler Roof Top Unit (RTU) #4 Overhead Weight: 12.5 Ton Make: Carrier Model: 50TCD14A3A5A2F0A0 Serial / Identification Number: 4612G20157
1 Each $ -
0004E
Air Handler Roof Top Unit (RTU) #4 Profit Weight: 12.5 Ton Make: Carrier Model: 50TCD14A3A5A2F0A0 Serial / Identification Number: 4612G20157
1 Each $ -
0005A
Air Handler Server Room Material Costs Weight: 5 Ton Make: Liebert Model: BU067ADEI Serial / Identification Number: N12K740240
1 Each $ -
0005B
Air Handler Server Room Labor Costs Weight: 5 Ton Make: Liebert Model: BU067ADEI Serial / Identification Number: N12K740240
1 Each $ -
0005 Naval Weapons Station Earle (NWSE) Building C-54 Server Room
0003 - Naval Weapons Station Earle (NWSE) Building C-54 Rooftop Item: Air Handler Roof Top Unit (RTU) #3
0004 Naval Weapons Station Earle (NWSE) Building C-54 Rooftop Item: Air Handler Roof Top Unit (RTU) #4
0005C
Air Handler Server Room Other Direct Costs Weight: 5 Ton Make: Liebert Model: BU067ADEI Serial / Identification Number: N12K740240
1 Each $ -
0005D
Air Handler Server Room Overhead Weight: 5 Ton Make: Liebert Model: BU067ADEI Serial / Identification Number: N12K740240
1 Each $ -
0005E
Air Handler Server Room Profit Weight: 5 Ton Make: Liebert Model: BU067ADEI Serial / Identification Number: N12K740240
1 Each $ -
0006A
Heating and Ventilation Unit Material Costs Weight: Unavailable Make: Unavailable Model: Unavailable Serial / Identification Number: Unavailable
2 Each $ -
0006B
Heating and Ventilation Unit Labor Costs Weight: Unavailable Make: Unavailable Model: Unavailable Serial / Identification Number: Unavailable
2 Each $ -
0006C
Heating and Ventilation Unit Other Direct Costs Weight: Unavailable Make: Unavailable Model: Unavailable Serial / Identification Number: Unavailable
2 Each $ -
0006D
Heating and Ventilation Unit Overhead Weight: Unavailable Make: Unavailable Model: Unavailable Serial / Identification Number: Unavailable
2 Each $ -
0006E
Heating and Ventilation Unit Material Profit Weight: Unavailable Make: Unavailable Model: Unavailable Serial / Identification Number: Unavailable
2 Each $ -
0007 Bonding - 3% of total cost of the project 1 LOT $ -
Total Cost
0006 Naval Weapons Station Earle (NWSE) Building C-54 Warehouse
0007 Bonding
Pricing Proposal
File details come from the government source that posted it. Updated .