TCA Attachment 2 Line Item Summary 3-19-21.xlsx

XLSX spreadsheet 44 KB Posted

Attached to
CBP Tucson Sector Tactical Infrastructure Maintenance and Repair (CTIMR)
Solicitation number
70B01C21R00000008
Issued by

About this file

This document contains a template for offerors to complete for a fixed price contract to provide maintenance and repair services for tactical infrastructure assets in the Tucson Sector for U.S. Customs and Border Protection. The template includes line items for scheduled maintenance tasks such as gate, lighting and drainage inspections and repairs to be conducted through base and option years. Offerors are instructed to provide fixed unit prices for scheduled maintenance and a coefficient to be applied to management, scheduled and unscheduled maintenance costs to calculate the total evaluated price. Required services include road, fence and gate repairs, vegetation control, debris removal, border lighting maintenance, and drainage system and tunnel upkeep. The solicitation number for this opportunity is 70B01C21R00000008 and the issuing agency is the Department of Homeland Security Customs and Border Protection. Responses are due by specified dates in 2021.

View the file

Other files

File Type Posted
Amendment_07_-_70B01C21R00000008_-_SF_30.pdf PDF
Boat Ramp Design Standards.pdf PDF
EC1Y1 RFP TI V4_.pdf PDF
TI Design Standards_v1_Chapter 3_Sept 2012.pdf PDF
TI Design Standards_v1_Chapter 1_Sept 2012.pdf PDF
Submittal 01 - Engineering Letter Shop Drawings.pdf PDF
TI Standards v2_Wall-Fence-Gates Drawing Updates_080618 (003).pdf PDF
TI Design Standards_v1_Chapter 2_Sept 2012.pdf PDF
TI Design Standards_v1_Sept 2012 - Roads Section.pdf PDF
Amendment_06_-_70B01C21R00000008_-_SF_30.pdf PDF
Boat Ramp Detail.pdf PDF
Site Visit Questions Answers 3-22-21 Responses (002).pdf PDF
Amendment_05_-_70B01C21R00000008_-_SF_30.pdf PDF
Site Visit Questions Answers 3-22-21.pdf PDF
TI Maintenance Work Plan Development Process Flowchart_3-19-21.pdf PDF
70B01C21R00000008 RFP 3-19-21.pdf PDF
ATTACHMENT 1 STATEMENT OF WORK CTIMR TUCSON 70B01C21R00000008 3-19-21 .pdf PDF
Site Visit Questions Answers 3-19-21 Responses (002).pdf PDF
Amendment_04_-_70B01C21R00000008_-_SF_30.pdf PDF
Amendment_03_-_70B01C21R00000008_-_SF_30.pdf PDF
Attachment 2 Line Item Summary 70B01C21R00000008 3-3-2021.xlsx XLSX spreadsheet
Amendment_02_-_70B01C21R00000008_-_SF_30.pdf PDF
RFP 70B01C21R00000008 3-3-2021.pdf PDF
Amendment_01_-_70B01C21R00000008_-_SF_30.pdf PDF
CTIMR Contractor Site Visit.pdf PDF
SCA WAGES SANTA CRUZ.txt TXT text file
SCA WAGES COCHISE COUNTY.txt TXT text file
Attachment 7 Work Order Form 70B01C21R00000008 2-12-21.xlsx XLSX spreadsheet
Attachment 9 Preventive Maintenance Checklist 70B01C21R00000008 2-12-21.pdf PDF
Attachment 2 Line Item Summary 70B01C21R00000008 2-12-21_.xlsx XLSX spreadsheet
ATTACHMENT 5 PAST PERFORMANCE INFORMATION SURVEY 70B01C21R00000008 2-12-21 .docx DOCX document
Attachments 6 SCA WAGE DETERMINATIONS PIMA COUNTY.txt TXT text file
RFP 70B01C21R00000008 2-12-21.pdf PDF
Attachment 1 Statement of Work CTIMR Tucson 70B01C21R00000008 2-12-21.pdf PDF
DBA WAGES COCHISE COUNTY.pdf PDF
Attachment 3 _Unit_Pricing_Sheet 70B01C21R00000008 2-12-21_.xlsx XLSX spreadsheet
Site Visit Sign In.xlsx XLSX spreadsheet
Attachment 4 Notional Work Plan 70B01C21R00000008 2-12-21.xlsx XLSX spreadsheet
DBA WAGES SANTA CRUZ.pdf PDF
Attachment 8 Estimate Form 70B01C21R00000008 2-12-21.xlsx XLSX spreadsheet
DBA WAGES PIMA COUNTY.pdf PDF
Show all 41

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

70B01C21R00000008 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 B9 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

RequirementBase Period:
07/01/21 - 06/30/2022Option Yr 1
07/01/22 - 06/30/23Option Yr 2
07/01/23 - 06/30/24Option Yr 3
07/01/24 - 06/30/25Option Yr 4
07/01/25 - 06/30/26TotalExtension Period 07/01/26 - 12/31/26Total with 6 month extension
Program Management (FFP-TCA)$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Scheduled Maintenance (FFP-TCA)$0.00$0.00$0.00$0.00$0.00$0$0.00$0.00
Unscheduled Maintenance (IDIQ TCA)$8,992,335.00$9,262,126.00$9,539,989.00$9,826,189.00$10,120,975.00$47,741,614$5,060,487.50$52,802,101.50
Subtotal$8,992,335.00$9,262,126.00$9,539,989.00$9,826,189.00$10,120,975.00$47,741,614$5,060,487.50$52,802,101.50
Co-Efficient Price$0.00$0.00$0.00$0.00$0.00$0$0.00$0.00
Total Price:$8,992,335.00$9,262,126.00$9,539,989.00$9,826,189.00$10,120,975.00$47,741,614$5,060,487.50$52,802,101.50

Coefficient (Profit+OH+Tax) %

Coefficient Elements:
Profit
OH
Tax

Base Period

BASE PERIOD: TCA SCHEDULED MAINT [FFP]Description of ServiceQty of AssetCount of EventsDurationPRICELaborEquipmentMaterialOtherComments/assumptions
TON Vamori Wash - Normandy Vehicle BarrierRoutine: Remove barriers premonsoon / replace post monsoon120$0$0.00$0.00$0.00$0.00one event for removing and one event for re-installing. Install T-posts and barbed wire
TON Culvert inspections pre monsoonRoutine: Inspect culverts for sedimentation and debris accumulation and proper drainage3710$0$0.00$0.00$0.00$0.00
DGL Flood swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening10520$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NCO Flood Lift and Swing GateRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening16120$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NGL Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening18220$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
AJO Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening6320$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
DGL Lighting inspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells380 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NCO Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells550 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NGL Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells132 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
DGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5410$0$0.00$0.00$0.00$0.00
NCO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage2910$0$0.00$0.00$0.00$0.00
SON Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage1910$0$0.00$0.00$0.00$0.00
NGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5510$0$0.00$0.00$0.00$0.00
TUS Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4710$0$0.00$0.00$0.00$0.00
AJO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4910$0$0.00$0.00$0.00$0.00
Smugglers Basin CleanoutRoutine: Remove debris/trash and sedimentation120$0$0.00$0.00$0.00$0.00
Totals:$0.00$0.00$0.00$0.00$0.00

Program Management NA NA NA NA

OPT Period 1

OPTION PERIOD 1: TCA SCHEDULED MAINT [FFP]Description of ServiceQty of AssetCount of EventsDurationPRICELaborEquipmentMaterialOtherComments/assumptions
TON Vamori Wash - Normandy Vehicle BarrierRoutine: Remove barriers premonsoon / replace post monsoon120$0$0.00$0.00$0.00$0.00one event for removing and one event for re-installing. Install T-posts and barbed wire
TON Culvert inspections pre monsoonRoutine: Inspect culverts for sedimentation and debris accumulation and proper drainage3710$0$0.00$0.00$0.00$0.00
DGL Flood swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening10520$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NCO Flood Lift and Swing GateRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening16120$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NGL Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening18220$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
AJO Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening6320$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
DGL Lighting inspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells380 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NCO Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells550 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NGL Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells132 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
DGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5410$0$0.00$0.00$0.00$0.00
NCO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage2910$0$0.00$0.00$0.00$0.00
SON Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage1910$0$0.00$0.00$0.00$0.00
NGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5510$0$0.00$0.00$0.00$0.00
TUS Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4710$0$0.00$0.00$0.00$0.00
AJO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4910$0$0.00$0.00$0.00$0.00
Smugglers Basin CleanoutRoutine: Remove debris/trash and sedimentation120$0$0.00$0.00$0.00$0.00
Totals:$0.00$0.00$0.00$0.00$0.00

Program Management NA NA NA NA

OPT Period 2

OPTION PERIOD 2: TCA SCHEDULED MAINT [FFP]Description of ServiceQty of AssetCount of EventsDurationPRICELaborEquipmentMaterialOtherComments/assumptions
TON Vamori Wash - Normandy Vehicle BarrierRoutine: Remove barriers premonsoon / replace post monsoon120$0$0.00$0.00$0.00$0.00one event for removing and one event for re-installing. Install T-posts and barbed wire
TON Culvert inspections pre monsoonRoutine: Inspect culverts for sedimentation and debris accumulation and proper drainage3710$0$0.00$0.00$0.00$0.00
DGL Flood swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening10520$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NCO Flood Lift and Swing GateRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening16120$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NGL Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening18220$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
AJO Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening6320$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
DGL Lighting inspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells380 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NCO Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells550 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NGL Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells132 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
DGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5410$0$0.00$0.00$0.00$0.00
NCO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage2910$0$0.00$0.00$0.00$0.00
SON Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage1910$0$0.00$0.00$0.00$0.00
NGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5510$0$0.00$0.00$0.00$0.00
TUS Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4710$0$0.00$0.00$0.00$0.00
AJO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4910$0$0.00$0.00$0.00$0.00
Smugglers Basin CleanoutRoutine: Remove debris/trash and sedimentation120$0$0.00$0.00$0.00$0.00
Totals:$0.00$0.00$0.00$0.00$0.00

Program Management NA NA NA NA

OPT Period 3

Option Period 3: TCA SCHEDULED MAINT [FFP]Description of ServiceQty of AssetCount of EventsDurationPriceLaborEquipmentMaterialOtherComments/assumptions
TON Vamori Wash - Normandy Vehicle BarrierRoutine: Remove barriers premonsoon / replace post monsoon120$0$0.00$0.00$0.00$0.00one event for removing and one event for re-installing. Install T-posts and barbed wire
TON Culvert inspections pre monsoonRoutine: Inspect culverts for sedimentation and debris accumulation and proper drainage3710$0$0.00$0.00$0.00$0.00
DGL Flood swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening10520$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NCO Flood Lift and Swing GateRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening16120$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NGL Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening18220$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
AJO Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening6320$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
DGL Lighting inspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells380 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NCO Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells550 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NGL Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells132 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
DGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5410$0$0.00$0.00$0.00$0.00
NCO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage2910$0$0.00$0.00$0.00$0.00
SON Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage1910$0$0.00$0.00$0.00$0.00
NGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5510$0$0.00$0.00$0.00$0.00
TUS Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4710$0$0.00$0.00$0.00$0.00
AJO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4910$0$0.00$0.00$0.00$0.00
Smugglers Basin CleanoutRoutine: Remove debris/trash and sedimentation120$0$0.00$0.00$0.00$0.00
Totals:$0.00$0.00$0.00$0.00$0.00

Program Management NA NA NA NA

OPT Period 4

OPTION PERIOD 4: TCA SCHEDULED MAINT [FFP]Description of ServiceQty of AssetCount of EventsDurationPRICELaborEquipmentMaterialOtherComments/assumptions
TON Vamori Wash - Normandy Vehicle BarrierRoutine: Remove barriers premonsoon / replace post monsoon120$0$0.00$0.00$0.00$0.00one event for removing and one event for re-installing. Install T-posts and barbed wire
TON Culvert inspections pre monsoonRoutine: Inspect culverts for sedimentation and debris accumulation and proper drainage3710$0$0.00$0.00$0.00$0.00
DGL Flood swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening10520$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NCO Flood Lift and Swing GateRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening16120$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
NGL Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening18220$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
AJO Flood Lift and Swing GatesRoutine: Open premonsoon/Close postmonsoon/ Includes lubing and inspection for proper operation and installing barbed fencing across opening6320$0$0.00$0.00$0.00$0.00one event for opening and one event for closing
DGL Lighting inspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells380 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NCO Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells550 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
NGL Lighting InspectionsRoutine: Inspect, clean, replace failed components as needed, ie ballasts, lamps, photocells132 fixtures40$0$0.00$0.00$0.00$0.00Assume 10% quarterly failure rate on lamps, 5% failure rate on ballasts and 5% failure rate on photo cells
DGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5410$0$0.00$0.00$0.00$0.00
NCO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage2910$0$0.00$0.00$0.00$0.00
SON Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage1910$0$0.00$0.00$0.00$0.00
NGL Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage5510$0$0.00$0.00$0.00$0.00
TUS Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4710$0$0.00$0.00$0.00$0.00
AJO Culvert/Cattleguard/GratesRoutine: Inspect for sedimentation and debris accumulation and proper drainage4910$0$0.00$0.00$0.00$0.00
Smugglers Basin CleanoutRoutine: Remove debris/trash and sedimentation120$0$0.00$0.00$0.00$0.00
Totals:$0.00$0.00$0.00$0.00$0.00

Program Management NA NA NA NA

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