ATTACHMENT 2 -- Line Item Summary EPT BBN 3-28-21.xlsx
XLSX spreadsheet 41 KB Posted
- Attached to
- Tactical Infrastructure (TI) Maintenance for Big Bend Sector and El Paso Sector in Texas
- Solicitation number
- 70B01C21R00000007
About this file
This document includes an attachment summarizing line item pricing for scheduled maintenance requirements under a federal contract solicitation. The solicitation seeks contractor services to perform maintenance, repair and improvement of Tactical Infrastructure assets in the Big Bend and El Paso Sectors in Texas. Services include maintenance for roads and bridges, fence and gates, vegetation control, debris removal, border lighting and electrical, drainage and grate systems, and tunnel remediation. The attachment outlines scheduled maintenance requirements for fence and gates, including inspection and maintenance of gates and vehicle barriers. It also includes monthly maintenance requirements for drainage grates. Pricing is to be provided by the offeror for the base period and four option periods by completing highlighted cells in the attachment.
View the file
Other files
Show all 38
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
Instructions
| 70B01C21R00000007 ATTACHMENT 2 - LINE ITEM SUMMARY |
| Instructions to Offeror: |
| The Offeror shall complete the sheets for the Base Period, Option Period 1, Option Period 2, Option Period 3, and Option Period 4 by filling the cells highlighted in YELLOW. After entering the proposed prices, the amounts will transfer automatically to the summary sheet to give the total evaluated price. Offerors shall use the fixed unit prices from Attachment 3 "Unit Bid Sheet" for its scheduled maintenance pricing. The offeror shall also propose its coefficient by completing Cell B17 in the Summary sheet. The coefficient will then be multiplied by the totals for program managment, schedule maintenance, and unscheduled maintenance to calculate the total evaluated price. Additionally, please identify the elements of the coefficient on the Summary Tab in the areas specified. |
Summary
| Requirement | Base Period: | ||||||||
| 07/05/21 - 07/04/2022 | Option Yr 1 | ||||||||
| 07/05/22 - 07/04/23 | Option Yr 2 | ||||||||
| 07/05/23 - 07/04/24 | Option Yr 3 | ||||||||
| 07/05/24 - 07/04/25 | Option Yr 4 | ||||||||
| 07/05/25 - 07/04/26 | Total | Extension Period 07/05/26 - 12/4/26 | Total with 6 month extension | ||||||
| Program Management (FFP-BBT) | $0.00 | $0.00 | $0.00 | ||||||
| Scheduled Maintenance (FFP-BBT) | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | $0.00 | $0.00 | |
| Unscheduled Maintenance (IDIQ BBT) | $608,769.00 | $639,207.45 | $671,167.82 | $704,726.21 | $739,962.52 | $3,363,833 | $369,981.26 | $3,733,814.27 | |
| Subtotal | $608,769.00 | $639,207.45 | $671,167.82 | $704,726.21 | $739,962.52 | $3,363,833 | $369,981.26 | $3,733,814.27 | |
| Co-Efficient Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0 | $0.00 | $0.00 | |
| Total Price: | $608,769.00 | $639,207.45 | $671,167.82 | $704,726.21 | $739,962.52 | $3,363,833 | $369,981.26 | $3,733,814.27 |
| Requirement | Base Period: | ||||||||
| 07/05/21 - 07/04/2022 | Option Yr 1 | ||||||||
| 07/05/22 - 07/04/23 | Option Yr 2 | ||||||||
| 07/05/23 - 07/04/24 | Option Yr 3 | ||||||||
| 07/05/24 - 07/04/25 | Option Yr 4 | ||||||||
| 07/05/25 - 07/04/26 | Total | Extension Period 07/05/26 - 12/4/26 | Total with 6 month extension | ||||||
| Program Management (FFP-EPT) | $0.00 | $0.00 | $0.00 | ||||||
| Scheduled Maintenance (FFP-EPT) | $0.00 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $0 | $0.00 | $0.00 | |
| Unscheduled Maintenance (IDIQ EPT) | $4,437,978.00 | $4,659,876.90 | $4,892,870.75 | $5,137,514.28 | $5,394,390.00 | $24,522,630 | $2,697,195.00 | $27,219,824.92 | |
| Subtotal | $4,437,978.00 | $4,659,876.90 | $4,892,870.75 | $5,137,514.28 | $5,394,390.00 | $24,522,630 | $2,697,195.00 | $27,219,824.92 | |
| Co-Efficient Price | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0 | $0.00 | $0.00 | |
| Total Price: | $4,437,978.00 | $4,659,876.90 | $4,892,870.75 | $5,137,514.28 | $5,394,390.00 | $24,522,630 | $2,697,195.00 | $27,219,824.92 |
Coefficient (Profit+OH+Tax) %
| Coefficient Elements: |
| Profit |
| OH |
| Taxes |
Base Period
| Scheduled Maintenance(FFP) | |||||||||||||
| Fence & Gates: | |||||||||||||
| No: | Comment | Sector | Classification | Category | Sub-Category | Description | FREQ | QTY | UOM | Labor | Materials | Equipment | Total |
| 1 | BBT | Routine | F&G | L-1 Big Bend Gate Inspections Every other Month. | Gate Maintenance every other month at L1 Big Bend Gate Inspections. Perform inspection and maintenance of 3 gates. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. | 4 | 3 | EA | $ - 0 | ||||
| 2 | BBT | Routine | F&G | L-1 Big Bend Vehicle Barrier Inspections once Annually. | Pump out all water and remove all debris and sediments. All solids must be hualed off to local landfill or approved facility for disposal. COR Approval Required. | 1 | 2 | EA | $ - 0 | ||||
| $ - 0 |
| 1 | EPT | Routine | F&G | Weekly Gate Inspection | Perform inspection and maintenance of 9 Gates once a week for 12 Months. 4 Gates at Santa Teresa POE, 2 Gates Columbus POE, 3 Automated gates at El Paso 4mile between BSI 14 and BSI 28, 2 Gates at American Brick Bridge, 1 Gate at Ft Hancock POE, 1 Gate at County Lakes Road and 1 Gate at Camp 8. Maintenance includes cleaning out tracks and moving parts with air and lubrication if required. Cleaning of solar panels at Camp 8, American Brick Bridge and County Lakes Rd. All Gates will be manually tested. Check timing of solenoid locks at Camp 8, County Lakes and American Brick Bridge. Battery rotation on a monthly basis for Camp 8, County Lakes and American Brick Bridge. COR Approval Required. | 48 | 14 | EA | $ - 0 |
| 2 | EPT | Routine | F&G | Quarterly Gate Inspection Maintenance | Gate Inspections. Perform inspection and maintenance of 194 gates on a quarterly basis. 120 gates original, 21 New BSI TX 12 to BSI TX 31, 18 Anapra NM, 35 New BSI NM BSI 305 to BSI NM 335. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. Note 9 out of 18 Gates in Anapra that are fix close will be opened every other month to allow for inspection and maintenance service. | 4 | 194 | EA | $ - 0 |
| $ - 0 |
| Drainage & Grates | |||||||||
| 1 | EPT | Routine | D&G | Monthly Maintenance on the K1-B Grates | Grate Maintenance monthly. Perform maintenance of grates K1-B on a monthly basis. Maintenance shall be completed twelve times. Cleaning and re-greasing stems and grate actuators. Testing of Gates will be performed with Government Diesel Generator. Removal of vegetation in front of control Panels. Diesel Generator to be service twice a year also to include fuel additive. COR Approval Required. | 12 | 4 | EA | $ - 0 |
| $ - 0 | |||||||||
| $ - 0 |
OPT Period 1
| Scheduled Maintenance(FFP) | |||||||||||||
| Fence & Gates: | |||||||||||||
| No: | Comment | Sector | Classification | Category | Sub-Category | Description | FREQ | QTY | UOM | Labor | Materials | Equipment | Total |
| 1 | BBT | Routine | F&G | L-1 Big Bend Gate Inspections Every other Month. | Gate Maintenance every other month at L1 Big Bend Gate Inspections. Perform inspection and maintenance of 3 gates. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. | 4 | 3 | EA | $ - 0 | ||||
| 2 | BBT | Routine | F&G | L-1 Big Bend Vehicle Barrier Inspections once Annually. | Pump out all water and remove all debris and sediments. All solids must be hualed off to local landfill or approved facility for disposal. COR Approval Required. | 1 | 2 | EA | $ - 0 | ||||
| $ - 0 |
| 1 | EPT | Routine | F&G | Weekly Gate Inspection | Perform inspection and maintenance of 9 Gates once a week for 12 Months. 4 Gates at Santa Teresa POE, 2 Gates Columbus POE, 3 Automated gates at El Paso 4mile between BSI 14 and BSI 28, 2 Gates at American Brick Bridge, 1 Gate at Ft Hancock POE, 1 Gate at County Lakes Road and 1 Gate at Camp 8. Maintenance includes cleaning out tracks and moving parts with air and lubrication if required. Cleaning of solar panels at Camp 8, American Brick Bridge and County Lakes Rd. All Gates will be manually tested. Check timing of solenoid locks at Camp 8, County Lakes and American Brick Bridge. Battery rotation on a monthly basis for Camp 8, County Lakes and American Brick Bridge. COR Approval Required. | 48 | 14 | EA | $ - 0 |
| 2 | EPT | Routine | F&G | Quarterly Gate Inspection Maintenance | Gate Inspections. Perform inspection and maintenance of 194 gates on a quarterly basis. 120 gates original, 21 New BSI TX 12 to BSI TX 31, 18 Anapra NM, 35 New BSI NM BSI 305 to BSI NM 335. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. Note 9 out of 18 Gates in Anapra that are fix close will be opened every other month to allow for inspection and maintenance service. | 4 | 194 | EA | $ - 0 |
| $ - 0 |
| Drainage & Grates | |||||||||
| 1 | EPT | Routine | D&G | Monthly Maintenance on the K1-B Grates | Grate Maintenance monthly. Perform maintenance of grates K1-B on a monthly basis. Maintenance shall be completed twelve times. Cleaning and re-greasing stems and grate actuators. Testing of Gates will be performed with Government Diesel Generator. Removal of vegetation in front of control Panels. Diesel Generator to be service twice a year also to include fuel additive. COR Approval Required. | 12 | 4 | EA | $ - 0 |
| $ - 0 | |||||||||
| $ - 0 |
OPT Period 2
| Scheduled Maintenance(FFP) | |||||||||||||
| Fence & Gates: | |||||||||||||
| No: | Comment | Sector | Classification | Category | Sub-Category | Description | FREQ | QTY | UOM | Labor | Materials | Equipment | Total |
| 1 | BBT | Routine | F&G | L-1 Big Bend Gate Inspections Every other Month. | Gate Maintenance every other month at L1 Big Bend Gate Inspections. Perform inspection and maintenance of 3 gates. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. | 4 | 3 | EA | $ - 0 | ||||
| 2 | BBT | Routine | F&G | L-1 Big Bend Vehicle Barrier Inspections once Annually. | Pump out all water and remove all debris and sediments. All solids must be hualed off to local landfill or approved facility for disposal. COR Approval Required. | 1 | 2 | EA | $ - 0 | ||||
| $ - 0 |
| 1 | EPT | Routine | F&G | Weekly Gate Inspection | Perform inspection and maintenance of 9 Gates once a week for 12 Months. 4 Gates at Santa Teresa POE, 2 Gates Columbus POE, 3 Automated gates at El Paso 4mile between BSI 14 and BSI 28, 2 Gates at American Brick Bridge, 1 Gate at Ft Hancock POE, 1 Gate at County Lakes Road and 1 Gate at Camp 8. Maintenance includes cleaning out tracks and moving parts with air and lubrication if required. Cleaning of solar panels at Camp 8, American Brick Bridge and County Lakes Rd. All Gates will be manually tested. Check timing of solenoid locks at Camp 8, County Lakes and American Brick Bridge. Battery rotation on a monthly basis for Camp 8, County Lakes and American Brick Bridge. COR Approval Required. | 48 | 14 | EA | $ - 0 |
| 2 | EPT | Routine | F&G | Quarterly Gate Inspection Maintenance | Gate Inspections. Perform inspection and maintenance of 194 gates on a quarterly basis. 120 gates original, 21 New BSI TX 12 to BSI TX 31, 18 Anapra NM, 35 New BSI NM BSI 305 to BSI NM 335. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. Note 9 out of 18 Gates in Anapra that are fix close will be opened every other month to allow for inspection and maintenance service. | 4 | 194 | EA | $ - 0 |
| $ - 0 |
| Drainage & Grates | |||||||||
| 1 | EPT | Routine | D&G | Monthly Maintenance on the K1-B Grates | Grate Maintenance monthly. Perform maintenance of grates K1-B on a monthly basis. Maintenance shall be completed twelve times. Cleaning and re-greasing stems and grate actuators. Testing of Gates will be performed with Government Diesel Generator. Removal of vegetation in front of control Panels. Diesel Generator to be service twice a year also to include fuel additive. COR Approval Required. | 12 | 4 | EA | $ - 0 |
| $ - 0 | |||||||||
| $ - 0 |
OPT Period 3
| Scheduled Maintenance(FFP) | |||||||||||||
| Fence & Gates: | |||||||||||||
| No: | Comment | Sector | Classification | Category | Sub-Category | Description | FREQ | QTY | UOM | Labor | Materials | Equipment | Total |
| 1 | BBT | Routine | F&G | L-1 Big Bend Gate Inspections Every other Month. | Gate Maintenance every other month at L1 Big Bend Gate Inspections. Perform inspection and maintenance of 3 gates. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. | 4 | 3 | EA | $ - 0 | ||||
| 2 | BBT | Routine | F&G | L-1 Big Bend Vehicle Barrier Inspections once Annually. | Pump out all water and remove all debris and sediments. All solids must be hualed off to local landfill or approved facility for disposal. COR Approval Required. | 1 | 2 | EA | $ - 0 | ||||
| $ - 0 |
| 1 | EPT | Routine | F&G | Weekly Gate Inspection | Perform inspection and maintenance of 9 Gates once a week for 12 Months. 4 Gates at Santa Teresa POE, 2 Gates Columbus POE, 3 Automated gates at El Paso 4mile between BSI 14 and BSI 28, 2 Gates at American Brick Bridge, 1 Gate at Ft Hancock POE, 1 Gate at County Lakes Road and 1 Gate at Camp 8. Maintenance includes cleaning out tracks and moving parts with air and lubrication if required. Cleaning of solar panels at Camp 8, American Brick Bridge and County Lakes Rd. All Gates will be manually tested. Check timing of solenoid locks at Camp 8, County Lakes and American Brick Bridge. Battery rotation on a monthly basis for Camp 8, County Lakes and American Brick Bridge. COR Approval Required. | 48 | 14 | EA | $ - 0 |
| 2 | EPT | Routine | F&G | Quarterly Gate Inspection Maintenance | Gate Inspections. Perform inspection and maintenance of 194 gates on a quarterly basis. 120 gates original, 21 New BSI TX 12 to BSI TX 31, 18 Anapra NM, 35 New BSI NM BSI 305 to BSI NM 335. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. Note 9 out of 18 Gates in Anapra that are fix close will be opened every other month to allow for inspection and maintenance service. | 4 | 194 | EA | $ - 0 |
| $ - 0 |
| Drainage & Grates | |||||||||
| 1 | EPT | Routine | D&G | Monthly Maintenance on the K1-B Grates | Grate Maintenance monthly. Perform maintenance of grates K1-B on a monthly basis. Maintenance shall be completed twelve times. Cleaning and re-greasing stems and grate actuators. Testing of Gates will be performed with Government Diesel Generator. Removal of vegetation in front of control Panels. Diesel Generator to be service twice a year also to include fuel additive. COR Approval Required. | 12 | 4 | EA | $ - 0 |
| $ - 0 | |||||||||
| $ - 0 |
OPT Period 4
| Scheduled Maintenance(FFP) | |||||||||||||
| Fence & Gates: | |||||||||||||
| No: | Comment | Sector | Classification | Category | Sub-Category | Description | FREQ | QTY | UOM | Labor | Materials | Equipment | Total |
| 1 | BBT | Routine | F&G | L-1 Big Bend Gate Inspections Every other Month. | Gate Maintenance every other month at L1 Big Bend Gate Inspections. Perform inspection and maintenance of 3 gates. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. | 4 | 3 | EA | $ - 0 | ||||
| 2 | BBT | Routine | F&G | L-1 Big Bend Vehicle Barrier Inspections once Annually. | Pump out all water and remove all debris and sediments. All solids must be hualed off to local landfill or approved facility for disposal. COR Approval Required. | 1 | 2 | EA | $ - 0 | ||||
| $ - 0 |
| 1 | EPT | Routine | F&G | Weekly Gate Inspection | Perform inspection and maintenance of 9 Gates once a week for 12 Months. 4 Gates at Santa Teresa POE, 2 Gates Columbus POE, 3 Automated gates at El Paso 4mile between BSI 14 and BSI 28, 2 Gates at American Brick Bridge, 1 Gate at Ft Hancock POE, 1 Gate at County Lakes Road and 1 Gate at Camp 8. Maintenance includes cleaning out tracks and moving parts with air and lubrication if required. Cleaning of solar panels at Camp 8, American Brick Bridge and County Lakes Rd. All Gates will be manually tested. Check timing of solenoid locks at Camp 8, County Lakes and American Brick Bridge. Battery rotation on a monthly basis for Camp 8, County Lakes and American Brick Bridge. COR Approval Required. | 48 | 14 | EA | $ - 0 |
| 2 | EPT | Routine | F&G | Quarterly Gate Inspection Maintenance | Gate Inspections. Perform inspection and maintenance of 194 gates on a quarterly basis. 120 gates original, 21 New BSI TX 12 to BSI TX 31, 18 Anapra NM, 35 New BSI NM BSI 305 to BSI NM 335. Maintenance includes cleaning out the tracks and moving parts with air, greasing, lubricating, test opening and closing for all gates, and adjusting as required. COR Approval Required. Note 9 out of 18 Gates in Anapra that are fix close will be opened every other month to allow for inspection and maintenance service. | 4 | 194 | EA | $ - 0 |
| $ - 0 |
| Drainage & Grates | |||||||||
| 1 | EPT | Routine | D&G | Monthly Maintenance on the K1-B Grates | Grate Maintenance monthly. Perform maintenance of grates K1-B on a monthly basis. Maintenance shall be completed twelve times. Cleaning and re-greasing stems and grate actuators. Testing of Gates will be performed with Government Diesel Generator. Removal of vegetation in front of control Panels. Diesel Generator to be service twice a year also to include fuel additive. COR Approval Required. | 12 | 4 | EA | $ - 0 |
| $ - 0 | |||||||||
| $ - 0 |
File details come from the government source that posted it. Updated .