Exhibits_7_Pricing_Spreasheets.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- Lighting protection System Service(LPS) contract
- Solicitation number
- W911RX-19-B-0007
About this file
Exhibits 7 - Pricing Spreadsheets
View the file
Other files
Show all 15
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 Pricing Spreadsheet CLIN TE Task Description Estimated Quantity Unit 1st Ordering Period Prices 2nd Ordering Period Prices 3rd Ordering Period Prices 4th Ordering Period Prices
| 0001 | AA-1 | Perform visual inspections, preventive maintenance, and routine repairs on terminal and caterary LPS at the Ammunition Supply Point Holding Yard, Buildings 925, 930, 934, 944 thru 955. | 1 | EA | n/a | n/a | ||
| AA-2 | Perform visual inspections, preventive maintenance, and routine repairs on terminal and caterary LPS at the Ammunition Supply Point Buildings 924, 924A, 929. | 1 | EA | n/a | n/a | |||
| AA-3 | Perform visual inspections, preventive maintenance, and routine repairs on terminal and caterary LPS at the Ammunition Supply Point Buildings 970 thru 975. | 1 | EA | n/a | n/a | |||
| AB | Perform visual inspections, preventive maintenance, and routine repairs on all caterary LPS at the Ammunition Holding Area. | 1 | EA | n/a | n/a | |||
| AC | Perform visual inspections, preventive maintenance, and routine repairs on all caterary LPS at the MPRC Ammunition Supply Point Pads A thru D. | 1 | EA | n/a | n/a | |||
| AD | Perform visual inspections, preventive maintenance, and routine repairs on all caterary LPS at the MPRC Ammunition Loading Dock. | 1 | EA | n/a | n/a | |||
| AE | Perform visual inspections, preventive maintenance, and routine repairs on all terminal LPS at the DMPTR Ammunition Loading Dock. | 1 | EA | n/a | n/a | |||
| AF | Perform visual inspections, preventive maintenance, and routine repairs on all terminal LPS at the Range 18 Ammunition Loading Dock. | 1 | EA | n/a | n/a | |||
| AG | Perform visual inspections, preventive maintenance, and routine repairs on terminal LPS System at Building 1910 K-9 ARMAG. | 1 | EA | n/a | n/a | |||
| AH | Perform visual inspections, preventive maintenance, and routine repairs on 3 terminal LPS Systems at Building 7173 ARMAGs. | 1 | EA | n/a | n/a | |||
| AI-1 | Perform certification testing, preventive maintenance, and routine repairs on terminal and caterary LPS at the Ammunition Supply Point Holding Yard, Buildings 925, 930, 934, 944 thru 955. | 1 | EA | n/a | n/a | |||
| AI-2 | Perform certification testing, preventive maintenance, and routine repairs on terminal and caterary LPS at the Ammunition Supply Point Buildings 924, 924A, 929. | 1 | EA | n/a | n/a | |||
| AI-3 | Perform certification testing, preventive maintenance, and routine repairs on terminal LPS at the Ammunition Supply Point Buildings 970 thru 975. | 1 | EA | n/a | n/a | |||
| AJ | Perform certification testing, preventive maintenance, and routine repairs on all caterary LPS at the Ammunition Holding Area. | 1 | EA | n/a | n/a | |||
| AK | Perform certification testing, preventive maintenance, and routine repairs on all caterary LPS at the MPRC Ammunition Supply Point Pads A thru D. | 1 | EA | n/a | n/a | |||
| AL | Perform certification testing, preventive maintenance, and routine repairs on all caterary LPS at the MPRC Ammunition Loading Dock. | 1 | EA | n/a | n/a | |||
| AM | Perform certification testing, preventive maintenance, and routine repairs on all terminal LPS at the DMPTR Ammunition Loading Dock. | 1 | EA | n/a | n/a | |||
| AN | Perform certification testing, preventive maintenance, and routine repairs on all terminal LPS at the Range 18 Ammunition Loading Dock. | 1 | EA | n/a | n/a | |||
| AO | Perform certification testing, preventive maintenance, and routine repairs on terminal LPS System at Building 1910 K-9 ARMAG. | 1 | EA | n/a | n/a | |||
| AP | Perform certification testing, preventive maintenance, and routine repairs on 3 terminal LPS Systems at Building 7173 ARMAGs. | 1 | EA | n/a | n/a |
0001 AA - AP CLIN 0001 Totals. $0.00 $0.00 $0.00 $0.00
| 2 | n/a | Reimbursement for invoiced cost of repair parts to repair any LPS at any location identified during visual inspections. | 1 | NTE |
| 3 | n/a | Reimbursement for cost of materials, labor, and/or equipment including overhead and profit required for miscellaneous work of LPS at any location. | 1 | NTE |
| 4 | n/a | Contractor Manpower Reporting. | 1 | LS |
n/a n/a Totals For All Contract Line Items $0.00 $0.00 $0.00 $0.00
Points and Test Type Pricing Lightning Protection System Test Points and Tests
| Location and Quantity | ||||||||||||||||||||||||||||||||||||||||
| CLIN TE | Description of Task | ASP Inspection Yard - Building 919 | ASP Building 924 | ASP Building 924A | ASP Magazine 925 | ASP Building 929 | ASP Magazine 930 | ASP Magazine 934 | ASP Magazine 944 | ASP Magazine 945 | ASP Magazine 946 | ASP Magazine 947 | ASP Magazine 948 | ASP Magazine 949 | ASP Magazine 950 | ASP Magazine 951 | ASP Magazine 952 | ASP Magazine 953 | ASP Magazine 954 | ASP Magazine 955 | ASP Magazine 970 | ASP Magazine 971 | ASP Magazine 972 | ASP Magazine 973 | ASP Magazine 974 | ASP Magazine 975 | Ammunition Holding Area - Building 995 | Building 1910 ARMAG | Building 7173 ARMAGs 1 thru 3 | Range 18 Ammunition Loading Dock - Building 9080A | MPRC Ammunition Loading Dock - Building 9375 | MPRC ASP Field Storage Site Pad A - Building 9319 | MPRC ASP Field Storage Site Pad B - Building 9319 | MPRC ASP Field Storage Site Pad C - Building 9319 | MPRC ASP Field Storage Site Pad D - Building 9319 | DMPTR Ammunition Loading Dock - Building 99651 | Total Estimated Quanity | Unit | Unit Price | Total Price |
| 0001 AA | Perform visual inspections, preventive maintenance, and routine repairs on terminal and caterary LPS componets and connections at ground level. | 6 | 11 | 13 | 15 | 12 | 7 | 8 | 11 | 14 | 7 | 10 | 8 | 8 | 14 | 14 | 7 | 10 | 14 | 14 | 8 | 8 | 8 | 8 | 8 | 8 | 24 | 8 | 24 | 28 | 4 | 10 | 4 | 4 | 5 | 2 | 364 | EA | $0.00 | $0.00 |
| 0001 AB | Perform visual inspections, preventive maintenance, and routine repairs on terminal and caterary LPS componets and connections above ground level. | 10 | 25 | 30 | 8 | 14 | 8 | 8 | 8 | 8 | 6 | 4 | 4 | 6 | 8 | 8 | 8 | 8 | 8 | 8 | 5 | 5 | 5 | 5 | 5 | 5 | 36 | 0 | 0 | 6 | 17 | 22 | 22 | 22 | 22 | 6 | 370 | EA | $0.00 | $0.00 |
| 0001 AC | Grounding Rod Loop Test Between Test Points | 6 | 16 | 8 | 4 | 10 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 13 | 1 | 2 | 4 | 7 | 7 | 7 | 7 | 2 | 174 | EA | $0.00 | $0.00 | |
| 0001 AD | Grounding Rod 3-Point Fall of Potential and Resistence to Earth Test Between Test Points | 6 | 16 | 8 | 4 | 10 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 10 | 2 | 14 | 2 | 4 | 6 | 6 | 6 | 6 | 2 | 182 | EA | $0.00 | $0.00 |
| 0001 AE | Bond Resistence Test Between Ground Rod and Air Terminal | 6 | 25 | 30 | 4 | 14 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5 | 5 | 5 | 10 | 4 | 4 | 6 | 6 | 6 | 6 | 4 | 211 | EA | $0.00 | $0.00 | ||
| 0001 AF | Bond Resistence Test Between Ground Rod and Guy Wire | 4 | 4 | 4 | 4 | 4 | 4 | 2 | 2 | 4 | 4 | 4 | 4 | 4 | 4 | 10 | 4 | 6 | 6 | 6 | 6 | 90 | EA | $0.00 | $0.00 | |||||||||||||||
| 0001 AG | Bond Resistence Test Between Ground Rod and Catenary Wire | 10 | 4 | 6 | 6 | 6 | 6 | 38 | EA | $0.00 | $0.00 | |||||||||||||||||||||||||||||
| 0001 AH | Bond Resistence Test Between Ground Rod and Obstruction Light | 6 | 2 | 4 | 4 | 4 | 4 | 4 | 2 | 30 | EA | $0.00 | $0.00 | |||||||||||||||||||||||||||
| 0001 AI | Bond Resistence Test Between Ground Rod and Area Lighting Pole | 1 | 1 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| 0001 AJ | Bond Resistence Test Between Ground Rod and Fence Ground Point | 14 | 1 | 10 | 4 | 4 | 5 | 38 | EA | $0.00 | $0.00 | |||||||||||||||||||||||||||||
| 0001 AK | Bond Resistence Test Between Ground Rod and Fence Gate Post | 6 | 2 | 12 | 20 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||
| 0001 AL | Bond Resistence Test Between Ground Rod and Fence Gate | 4 | 1 | 6 | 11 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||
| 0001 AM | Bond Resistence Test Between Ground Rod and ARMAG Magazine Corner | 2 | 6 | 8 | EA | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||
| 0001 AN | Bond Resistence Test Between Ground Rod and Personnel Door | 3 | 3 | 4 | 1 | 11 | EA | $0.00 | $0.00 | |||||||||||||||||||||||||||||||
| 0001 AO | Bond Resistence Test Between Ground Rod and Overhead Door | 3 | 3 | 2 | 8 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||
| 0001 AP | Bond Resistence Test Between Ground Rod and Magazine Door | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 21 | EA | $0.00 | $0.00 | ||||||||||||||
| 0001 AQ | Bond Resistence Test Between Ground Rod and Magazine Door Hinge | 4 | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 4 | 31 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 0001 AR | Bond Resistence Test Between Ground Rod and Magazine Door Latch Bar | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 9 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 0001 AS | Bond Resistence Test Between Ground Rod and Magazine Door Stop | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 13 | EA | $0.00 | $0.00 | ||||||||||||||||||||||
| 0001 AT | Bond Resistence Test Between Ground Rod and Magazine Door Awning | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 11 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||
| 0001 AU | Bond Resistence Test Between Ground Rod and Door or Wall Louver | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 37 | EA | $0.00 | $0.00 | ||||||||||||||||
| 0001 AV | Bond Resistence Test Between Ground Rod and Door or Wall Louver Damper | 2 | 1 | 2 | 2 | 2 | 2 | 2 | 13 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||
| 0001 AW | Bond Resistence Test Between Ground Rod and Roof Ventilator | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 19 | EA | $0.00 | $0.00 | ||||||||||||||||
| 0001 AX | Bond Resistence Test Between Ground Rod and Roof Ventilator Flag | 1 | 1 | 1 | 1 | 1 | 1 | 1 | ? | ? | ? | ? | ? | ? | 7 | EA | $0.00 | $0.00 | ||||||||||||||||||||||
| 0001 AY | Bond Resistence Test Between Ground Rod and Pipe Handrail | 2 | 1 | 3 | EA | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||
| 0001 AZ | Bond Resistence Test Between Ground Rod and Chain Railing Pole | 24 | 1 | 25 | EA | $0.00 | $0.00 | |||||||||||||||||||||||||||||||||
| 0001 BA | Bond Resistence Test Between Ground Rod and Electrical Conduit | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 10 | EA | $0.00 | $0.00 | |||||||||||||||||||||||||||
| 0001 BB | Bond Resistence Test Between Ground Rod and Electrical Transformer | 1 | 1 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| 0001 BC | Bond Resistence Test Between Ground Rod and Electrical Box or Panel | 2 | 3 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 30 | EA | $0.00 | $0.00 | |||||||||||||
| 0001 BD | Bond Resistence Test Between Ground Rod and Communication Panel | 2 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||
| 0001 BE | Bond Resistence Test Between Ground Rod and Telephone Pedestal | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 11 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||
| 0001 BF | Bond Resistence Test Between Ground Rod and Trench Drain | 1 | 1 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| 0001 BG | Bond Resistence Test Between Ground Rod and Metal Edge - Loading Dock | 1 | 1 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| 0001 BH | Bond Resistence Test Between Ground Rod and Metal Edge - Apron | 1 | 1 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| 0001 BI | Bond Resistence Test Between Ground Rod and Work Bench | 5 | 5 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| 0001 BJ | Bond Resistence Test Between Ground Rod and Grenade Box | 1 | 1 | EA | $0.00 | $0.00 | ||||||||||||||||||||||||||||||||||
| 0001 BK | 40'-0" Engine Powered, Articulating (Up/Over) Boom Manlift | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 18 | EA | $0.00 | $0.00 | |||||||||||||||||
| 0001 BL | 60'-0" Engine Powered, Articulating (Up/Over) Boom Manlift | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8 | EA | $0.00 | $0.00 | |||||||||||||||||||||||||||
| 0001 BM | 100'-0" Engine Powered, Articulating (Up/Over) Boom Manlift | 1 | 1 | EA | $0.00 | $0.00 |
1 CLIN 0001 Totals. $0.00
| 2 | Reimbursement for invoiced cost of repair parts to repair any LPS at any location identified during visual inspections. | 1 | NTE |
| 3 | Reimbursement for cost of materials, labor, and/or equipment including overhead and profit required for miscellaneous work of LPS at any location. | 1 | NTE |
| 4 | Contractor Manpower Reporting. | 1 | LS |
$0.00
Points and Tests
| Lightning Protection System Test Points and Tests | |||||||||||||
| Location | Grounding Rod Loop Tests | Grounding Rod 3-Point Fall of Potential and Resistence to Earth Tests | Bond Resistence Tests | Remarks | |||||||||
| Original Quantity of Points | Original Quantity of Tests | New Quantity of Points | New Quantity of Tests | Original Quantity of Points | Original Quantity of Tests | New Quantity of Points | New Quantity of Tests | Original Quantity of Points | Original Quantity of Tests | New Quantity of Points | New Quantity of Tests |
| ASP Inspection Yard - Building 919 | 6 | 6 | 6 | 6 | Note A | 6 | Note A | 6 | 10 | 10 | 10 | 10 | |
| ASP Building 924 | 16 | 16 | 16 | 16 | Note A | 16 | Note A | 16 | 34 | 34 | 34 | 34 | |
| ASP Building 924A | 8 | 8 | 8 | 8 | Note A | 8 | Note A | 8 | 39 | 39 | 39 | 39 | |
| ASP Building 925 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 24 | 24 | 24 | 24 | |
| ASP Building 929 | 10 | 10 | 10 | 10 | Note A | 10 | Note A | 10 | 26 | 26 | 26 | 26 | |
| ASP Building 930 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 19 | 19 | 17 | 17 | 2 Less Points and Tests |
| ASP Building 934 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 16 | 16 | 16 | 16 | |
| ASP Building 944 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 19 | 19 | 19 | 19 | |
| ASP Building 945 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 22 | 22 | 22 | 22 | |
| ASP Building 946 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 14 | 14 | 14 | 14 | |
| ASP Building 947 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 14 | 14 | 14 | 14 | |
| ASP Building 948 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 12 | 12 | 12 | 12 | |
| ASP Building 949 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 14 | 14 | 14 | 14 | |
| ASP Building 950 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 22 | 22 | 22 | 22 | |
| ASP Building 951 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 22 | 22 | 22 | 22 | |
| ASP Building 952 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 15 | 15 | 15 | 15 | |
| ASP Building 953 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 18 | 18 | 18 | 18 | |
| ASP Building 954 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 22 | 22 | 22 | 22 | |
| ASP Building 955 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 22 | 22 | 22 | 22 | |
| ASP Building 970 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 13 | 13 | 13 | 13 | |
| ASP Building 971 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 13 | 13 | 13 | 13 | |
| ASP Building 972 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 13 | 13 | 13 | 13 | |
| ASP Building 973 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 13 | 13 | 13 | 13 | |
| ASP Building 974 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 13 | 13 | 13 | 13 | |
| ASP Building 975 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 13 | 13 | 13 | 13 | |
| Ammunition Holding Area - Building 995 | 10 | 13 | 10 | 13 | Note A | 10 | Note A | 10 | 38 | 38 | 60 | 60 | 22 New Points and Tests |
| Building 1910 ARMAG | n/a | n/a | 1 | 1 | n/a | n/a | 2 | 2 | n/a | n/a | 8 | 8 | 11 New Points and Tests |
| Building 7173 ARMAGs 1 thru 3 | n/a | n/a | 0 | 0 | n/a | n/a | 0 | 0 | n/a | n/a | 0 | 0 | To Be Added |
| Range 18 Ammunition Loading Dock - Building 9080A | 0 | 0 | Note B | 2 | 2 | 2 | 2 | 2 | 34 | 34 | 34 | 34 | 2 New Tests |
| MPRC Ammunition Loading Dock - Building 9375 | 4 | 4 | 4 | 4 | Note A | 4 | Note A | 4 | 21 | 21 | 21 | 21 | |
| MPRC ASP Field Storage Site Pad A - Building 9319 | 6 | 7 | 6 | 7 | Note A | 6 | Note A | 6 | 22 | 22 | 32 | 32 | 10 New Points and Tests |
| MPRC ASP Field Storage Site Pad B - Building 9319 | 6 | 7 | 6 | 7 | Note A | 6 | Note A | 6 | 22 | 22 | 26 | 26 | 4 New Points and Tests |
| MPRC ASP Field Storage Site Pad C - Building 9319 | 6 | 7 | 6 | 7 | Note A | 6 | Note A | 6 | 22 | 22 | 26 | 26 | 4 New Points and Tests |
| MPRC ASP Field Storage Site Pad D - Building 9319 | 6 | 7 | 6 | 7 | Note A | 6 | Note A | 6 | 22 | 22 | 26 | 27 | 4 New Points and 5 New Tests |
| DMPTR Ammunition Loading Dock - Building 99651 | 2 | 2 | 2 | 2 | Note A | 2 | Note A | 2 | 7 | 7 | 7 | 7 |
| Totals | 164 | 171 | 165 | 174 | 2 | 166 | 4 | 168 | 650 | 650 | 700 | 701 |
| Note A - Same as Grounding Rod Loop Test Points | ||||||||||||
| Note B - Same as Grounding Rod 3-Point Fall of Potential and Resistence to Earth Test Points |
| Original Quantity of Test Points | 816 |
| New Quantity of Test Points | 869 |
| Original Quantity of Tests | 987 |
| New Quantity of Tests | 1043 |
File details come from the government source that posted it.