Amendment_A0001_Attachment 2 Solicitation Pricing Tables.xlsx

XLSX spreadsheet 45 KB Posted Dec 11, 2020

Attached to: Integrated Logistics Support (ILS) Services Federal contract opportunity
Solicitation number: 70B04C21R00000005
Issued by: Department of Homeland Security Customs and Border Protection

About this file

Written by GovTribe AI · Dec 27, 2023

This spreadsheet contains pricing tables for an integrated logistics support services contract opportunity. The contractor shall provide support for Non-Intrusive Inspection equipment, Radiation Detection Equipment, Laboratory & Scientific Services equipment, Legacy Remote Video Surveillance System equipment, Unattended Ground Sensor System equipment, Agent Support equipment, and various other equipment within Customs and Border Protection. Services will be provided at locations in Lorton, Virginia and Albuquerque, New Mexico. Pricing is provided for base years and five option years for labor, parts and supplies, and on demand services for the locations. Labor rates are also included for transition support. The solicitation number for this opportunity is 70B04C21R00000005 and it was issued by the Department of Homeland Security's Customs and Border Protection.

View the file

Other files for this federal contract opportunity

Other files attached to Integrated Logistics Support (ILS) Services, newest first.
File	Type	Posted
Amendment_A0004_RFP No. 70B04C21R00000005 - revised.pdf	PDF	Jan 8, 2021
Amendment_A0004_Attachment 2 Solicitation Pricing Tables.xlsx	XLSX spreadsheet	Jan 8, 2021
Amendment_A0004_Synopsis of Revised Documents.docx	DOCX document	Jan 8, 2021
Amendment_A0004_Questions and Answers.docx	DOCX document	Jan 8, 2021
Amendment_A0003_Questions and Answers.docx	DOCX document	Jan 7, 2021
Amendment_A0003_Attachment 2 Solicitation Pricing Tables.xlsx	XLSX spreadsheet	Jan 7, 2021
Amendment_A0002_Synopsis of Revised Documents.docx	DOCX document	Jan 4, 2021
Amendment_A0002_RFP No. 70B04C21R00000005 - revised.pdf	PDF	Jan 4, 2021
Amendment_A0002_Attachment 1 Statement of Work.docx	DOCX document	Jan 4, 2021
Amendment_A0002_Questions and Answers.docx	DOCX document	Jan 4, 2021
Amendment_A0002_Attachment 2 Solicitation Pricing Tables.xlsx	XLSX spreadsheet	Jan 4, 2021
Amendment_A0002_Attachment 3 Past Performance Questionnaire.docx	DOCX document	Jan 4, 2021
Amendment_A0001_Cover Letter.docx	DOCX document	Dec 11, 2020
Amendment_A0001_RFP No. 70B04C21R00000005 with track changes.docx	DOCX document	Dec 11, 2020
Amendment_A0001_Attachment 4 Labor Category Descriptions.docx	DOCX document	Dec 11, 2020
Amendment_A0001_Questions and Answers.docx	DOCX document	Dec 11, 2020
Amendment_A0001_Attachment 1 Statement of Work.docx	DOCX document	Dec 11, 2020
Amendment_A0001_Attachment 1 Statement of Work - track changes.docx	DOCX document	Dec 11, 2020
Amendment_A0001_RFP No. 70B04C21R00000005 - revised.pdf	PDF	Dec 11, 2020
Amendment_A0001_Attachment 13 OEM List.xlsx	XLSX spreadsheet	Dec 11, 2020
Cover Letter.docx	DOCX document	Nov 25, 2020
Attachment 3 Past Performance Questionnaire.docx	DOCX document	Nov 25, 2020
Attachment 4 Labor Category Descriptions.docx	DOCX document	Nov 25, 2020
Attachment 9 ILD Albuquerque Throughput.docx	DOCX document	Nov 25, 2020
Attachment 12 Wage Determination No 2015-5443 - Rev 10 (ABQ).pdf	PDF	Nov 25, 2020
RFP No. 70B04C21R00000005.pdf	PDF	Nov 25, 2020
Attachment 1 Statement of Work.docx	DOCX document	Nov 25, 2020
Attachment 2 Solicitation Pricing Tables.xlsx	XLSX spreadsheet	Nov 25, 2020
Attachment 10 Albuquerque DX and Critical Repair Part Min-Max Levels.docx	DOCX document	Nov 25, 2020
Attachment 11 Wage Determination No 2015-4281 - Rev 16 (LRN).pdf	PDF	Nov 25, 2020
Attachment 5 ILS Equipment List.xlsx	XLSX spreadsheet	Nov 25, 2020
Attachment 6 Additional Equipment Listing.docx	DOCX document	Nov 25, 2020
Attachment 7 Locations of Equipment.docx	DOCX document	Nov 25, 2020
Attachment 8 Operations Center Call Volume.docx	DOCX document	Nov 25, 2020

Show all 34

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Summary Task Order Cost tc={FFF9CF64-D809-4962-B5A7-59395E7A3A7E}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

The SOW references Newington, is there a separate tab for Newington?

Reply:

Are the IT services (help-desk) included as part of the IGCE?

	CLIN	TOTAL	Type	Base Year
FY20	Option Year 1
FY21	Option Year 2
FY22	Option Year 3
FY23	Option Year 4
FY24	Total Contract

1 ILD Lorton Support FFP/T&M $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

2 Parts and Supplies (Lorton) (Not To Exceed) T&M $758,565.00 $785,115.00 $812,594.00 $841,035.00 $870,471.00 $4,067,780.00

3 ILD Albuquerque Support FFP/T&M $0.00 $0.00 $0.00 $0.00 $0.00

4 Parts and Supplies (Albuquerque) (Not To Exceed) T&M $10,278.00 $10,636.00 $11,009.00 $11,394.00 $11,793.00 $55,110.00

5 On Demand Services (Not To Exceed) T&M $10,256,592.98 $10,669,310.95 $11,042,879.67 $11,429,446.12 $11,826,305.86 $55,224,535.59

	Totals:	$11,025,435.98	$11,465,061.95	$11,866,482.67	$12,281,875.12	$12,708,569.86	$59,347,425.59
Line Items 2, 4 and 5 will be included on the contract for Parts, Supplies and On Demand.

Lorton Support

		Task	Labor Category	Labor Hours		Labor Rates
Base Year (T&M/FFP)	Labor Total
Base Year (T&M/FFP)	Labor Rates
Option Year 1 (T&M/FFP)	Labor Total
Option Year 1 (T&M/FFP)	Labor Rates
Option Year 2 (T&M/FFP)	Labor Total
Option Year 2 (T&M/FFP)	Labor Rates
Option Year 3 (T&M/FFP)	Labor Total
Option Year 3 (T&M/FFP)	Labor Rates
Option Year 4 (T&M/FFP)	Labor Total
Option Year 4 (T&M/FFP)	Contract Total
		Business Support & Contract Administration	Program Manager	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Business Manager	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Administrative Support	Administrative Assistants	7520		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Procurement Administrator	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		ILD Operations Center	MDC Supervisor	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			MDC Deputy Supervisor	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Maintenance Dispatch Coordinators	22560		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		NII Program Technology Support	Operations Manager	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Logistics Analyst IV	5592		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Logistics Analyst III	3728		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Logistics Analyst II	3728		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Intermediate Repair Center	Maintenance Manager	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Maintenance Operations Analyst (NROC)	3760		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Maintenance Service Representative	7456		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Electronics Technician III	5640		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Field Service Technician	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Warehouse Supervisor	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Asset Management Technician	5592		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Material Expeditor	3760		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Total Hours:	86112	LABOR TOTALS:		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

NON- LABOR
Parts and Supplies (Repair) (Not To Exceed)	PARTS AND SUPPLIES TOTALS (NTE):	$ 758,565.00	$785,115.00	$812,594.00	$841,035.00	$870,471.00	$ 4,067,780.00	T & M

	TOTAL VALUE FOR LORTON:	$ 758,565.00	$ 785,115.00	$ 812,594.00	$ 841,035.00	$ 870,471.00	$ 4,067,780.00
The labor categories and hours listed are historical labor categories and hours, which are provided for reference. Offerors are allowed to propose their own labor categories and hours to satisfy the requirement.

For the Base and Option years, the Agency will review the onboarding situation and will decide whether the Lorton Support will be T&M or FFP.

ABQ Support

		Task	Labor Category	Labor Hours		Labor Rates
Base Year	Labor Total
Base Year	Labor Rates
Option Year 1	Labor Total
Option Year 1	Labor Rates
Option Year 2	Labor Total
Option Year 2	Labor Rates
Option Year 3	Labor Total
Option Year 3	Labor Rates
Option Year 4	Labor Total
Option Year 4	Contract Total
		ABQ Support	Operations Manager	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Electronic Technician III	22560		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Inventory Wharehouseman	7520		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Material Expeditor	3760		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Logistic Analyst II	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Logistic Analyst III	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Asset Management Manager	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Maintenance Manager	1864		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
			Total Hours:	43160	LABOR TOTALS:		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

NON- LABOR
Parts and Supplies (Not To Exceed)	PARTS AND SUPPLIES TOTALS (NTE):	$ 10,278.00	$ 10,636.00	$ 11,009.00	$ 11,394.00	$ 11,793.00	$ 55,110.00	T&M

TOTAL VALUE FOR ABQ	TOTAL VALUE FOR ALBUQUERQUE:	$ 10,278.00	$ 10,636.00	$ 11,009.00	$ 11,394.00	$ 11,793.00	$ 55,110.00
The labor categories and hours listed are historical labor categories and hours, which are provided for reference. Offerors are allowed to propose their own labor categories and hours to satisfy the requirement.

For the Base and Option years, the Agency will review the onboarding situation and will decide whether the Albuquerque Support will be T&M or FFP.

ON DEMAND

	Task	Labor Category	Labor Rates
Base Year	Labor Rates Option Year 1	Labor Rates Option Year 2	Labor Rates Option Year 3	Labor Rates Option Year 4
	On Demand		$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Labor	Program Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Business Administrator I	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Billing Administrator	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Maintenance Dispatch Coordinators	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Electronics Technician III	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Field Service Technician	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Electrical Technician	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Rigger	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Material Expediter	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Logistics Analyst II
(Configuration Management Support)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Systems Engineer	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

PLEASE PROVIDE LABOR RATES ONLY FOR ON-DEMAND

ON-DEMAND CEILING AMOUNT
						TOTAL
Labor	$ 210,650.64	$ 326,871.04	$ 338,311.53	$ 350,152.43	$ 362,407.76	$ 1,588,393.40
Parts and Supplies	$ 10,045,942.34	$ 10,342,439.91	$ 10,704,568.14	$ 11,079,293.69	$ 11,463,898.10	$ 53,636,142.18

Total (Not To Exceed) $ 10,256,592.98 $ 10,669,310.95 $ 11,042,879.67 $ 11,429,446.12 $ 11,826,305.86 $ 55,224,535.59

The labor categories are historical labor categories, which are provided for reference. Offerors are allowed to propose their own labor categories to satisfy the requirement.

TRANSITION

	Task	Labor Category	Labor Rates
Base Year	Labor Rates Option Year 1	Labor Rates Option Year 2	Labor Rates Option Year 3	Labor Rates Option Year 4
	TRANSITION
	Labor	Program Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Business Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Administrative Assistants	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Procurement Administrator	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		MDC Supervisor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		MDC Deputy Supervisor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Maintenance Dispatch Coordinators	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Operations Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Logistics Analyst IV	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Logistics Analyst III	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Logistics Analyst II	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Maintenance Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Maintenance Operations Analyst (NROC)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Maintenance Service Representative	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Electronics Technician III	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Field Service Technician	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Wharehouse Supervisor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Asset Management Technician	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Material Expeditor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Operations Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Electronic Technician III	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Inventory Wharehouseman	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Material Expeditor	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Logistic Analyst II	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Logistic Analyst III	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Asset Management Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
		Maintenance Manager	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

PLEASE PROVIDE LABOR RATES ONLY FOR THE TRANSITION

The labor categories are historical labor categories, which are provided for reference. Offerors are allowed to propose their own labor categories to satisfy the requirement.

Labor rates shall apply to the transition out period, no matter which period it falls in.

Sheet1

Task	Labor Category	SBO2	APO6	APO3	Labor Rate	SBO2 Unburdened	APO6 Unburdened	APO3 Unburdened	Hours (PerContract Year)	Unburdened Total
	Procurement Specialist		1080		47.43	0	51224.4	0	1080	51224.4

File details come from the government source that posted it. Updated Dec 11, 2020.