Attachment 2 Line Item Summary 70B01C21R00000008 2-12-21_.xlsx

XLSX spreadsheet 41 KB Posted

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

About this file

This document includes an attachment to a solicitation for maintenance and repair services for tactical infrastructure assets in the Tucson Sector for U.S. Customs and Border Protection. The solicitation seeks contractor services to perform maintenance, repair and improvement work for roads and bridges, fencing and gates including concertina wire, vegetation control, debris removal, border lighting and electrical systems, drainage and grate systems, and tunnel remediation. Offerors are instructed to fill out an attached site visit form if attending the site visit, with emails due to the contracting officer no later than February 25, 2021. The work will be performed for CBP's tactical infrastructure assets within the Tucson Sector in Arizona, as set forth in the attached statement of work.

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
TCA Attachment 2 Line Item Summary 3-19-21.xlsx XLSX spreadsheet
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 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. In addition, the offeror shall propose its coefficient for the unscheduled maintenance work by completing Cell B6 in the Summary sheet. After entering the proposed prices and the coefficient, the amounts will transfer automatically to the summary sheet to give the total evaluated price.

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
Scheduled Maintenance (FFP-TCA)$0.00$0.00$0.00$0.00$0.00$0$0.00$0.00
Unscheduled Maintenance (TCA)$8,992,354.80$9,262,125.44$9,539,989.21$9,826,188.88$10,120,974.55$47,741,633$5,299,524.23$53,041,157.11
Total Price:ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

Coefficient %

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

OPT Period 1

Option 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

OPT Period 2

Option 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

OPT Period 3

Option 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

OPT Period 4

OPTION 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

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