Attachment 2 Solicitation Pricing Tables.xlsx

XLSX spreadsheet 64 KB Posted Nov 25, 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 file contains pricing tables for a solicitation for integrated logistics support services. The contractor shall provide support for non-intrusive inspection, radiation detection, laboratory and scientific, legacy remote video surveillance, unattended ground sensor, and agent support equipment within U.S. Customs and Border Protection. Services include business support, contract administration, operations management, logistics, maintenance, repair, and asset management based out of Lorton, Virginia and Albuquerque, New Mexico. Pricing is provided for firm fixed price and time and materials contract line items over five one-year ordering periods. The total potential contract value is estimated at $4,122,890. Labor rates are also provided for on-demand and transition support tasks.

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_Synopsis of Revised Documents.docx	DOCX document	Jan 8, 2021
Amendment_A0004_Questions and Answers.docx	DOCX document	Jan 8, 2021
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_A0003_Attachment 2 Solicitation Pricing Tables.xlsx	XLSX spreadsheet	Jan 7, 2021
Amendment_A0003_Questions and Answers.docx	DOCX document	Jan 7, 2021
Amendment_A0002_Attachment 1 Statement of Work.docx	DOCX document	Jan 4, 2021
Amendment_A0002_Attachment 3 Past Performance Questionnaire.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_Synopsis of Revised Documents.docx	DOCX document	Jan 4, 2021
Amendment_A0002_RFP No. 70B04C21R00000005 - revised.pdf	PDF	Jan 4, 2021
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_RFP No. 70B04C21R00000005 - revised.pdf	PDF	Dec 11, 2020
Amendment_A0001_Attachment 13 OEM List.xlsx	XLSX spreadsheet	Dec 11, 2020
Amendment_A0001_Attachment 2 Solicitation Pricing Tables.xlsx	XLSX spreadsheet	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_Cover Letter.docx	DOCX document	Dec 11, 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
RFP No. 70B04C21R00000005.pdf	PDF	Nov 25, 2020
Attachment 1 Statement of Work.docx	DOCX document	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
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

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		$0.00	$0.00	$0.00		$0.00
	ILD Lorton Support	T&M	$0.00				$0.00	$0.00
	Parts and Supplies (Lorton)	T&M	$758,565.00	$785,115.00	$812,594.00	$841,035.00	$870,471.00	$4,067,780.00
	TOTAL VALUE FOR LORTON:		$758,565.00	$785,115.00	$812,594.00	$841,035.00	$870,471.00	$4,067,780.00

2	ILD Albuquerque Support	FFP		$0.00	$0.00	$0.00
	ILD Albuquerque Support	T&M	$0.00				$0.00
	Parts and Supplies (Albuquerque)	T&M	$10,278.00	$10,636.00	$11,009.00	$11,394.00	$11,793.00	$55,110.00
	TOTAL VALUE FOR ALBUQUERQUE:		$10,278.00	$10,636.00	$11,009.00	$11,394.00	$11,793.00	$55,110.00

Totals: $768,843.00 $795,751.00 $823,603.00 $852,429.00 $882,264.00 $4,122,890.00

Lorton 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
		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

tc={5C9DAD1B-3B5F-4C07-A8B3-188A6F25D305}: [Threaded comment]

Comment:

@HUTCHINSON, IRA E I tried to move this Procurement Admin under Admin Support 4.1 . However, it said my formula was incorrect. Can you please move it. I don't want to mess up the spreadsheet. Thank you

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
		Total Hours:	82352	LABOR TOTALS:		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0	$ - 0

NON- LABOR
Parts and Supplies (Repair)	PARTS AND SUPPLIES TOTALS:	$ 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

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
Supplies	$ 10,278.00	$ 10,636.00	$ 11,009.00	$ 11,394.00	$ 11,793.00	$ 55,110.00

PARTS AND SUPPLIES TOTALS: $ 10,278.00 $ 10,636.00 $ 11,009.00 $ 11,394.00 $ 11,793.00 $ 55,110.00

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

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
	Labor	Program Manager
		Business Administrator I
		Billing Administrator
		Maintenance Dispatch Coordinators
		Electronics Technician III
		Field Service Technician
		Electrical Technician
		Rigger
		Material Expediter
		Logistics Analyst II

(Configuration Management Support) Systems Engineer tc={CB89C264-D1E8-4D41-BC2B-B63BADFFAC3E}: [Threaded comment]

Comment:

Reply:

Per Vinnys Email this was moved from Lorton Support to On Deman

PLEASE PROVIDE LABOR RATES ONLY FOR ON-DEMAND

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
		Business Manager
		Administrative Assistants
		Procurement Administrator

tc={5C9DAD1B-3B5F-4C07-A8B3-188A6F25D305}: [Threaded comment]

Comment:

MDC Supervisor

MDC Deputy Supervisor

Maintenance Dispatch Coordinators

Operations Manager

Logistics Analyst IV

Logistics Analyst III

Logistics Analyst II

Maintenance Manager

Maintenance Operations Analyst (NROC)

Maintenance Service Representative

Electronics Technician III

Field Service Technician

Wharehouse Supervisor

Asset Management Technician

Material Expediter

Operations Manager

Electronic Technician III

Inventory Wharehouseman

Material Expeditor

Logistic Analyst II

Logistic Analyst III

Asset Management Manager

Maintenance Manager

PLEASE PROVIDE LABOR RATES ONLY FOR THE TRANSITION

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 Nov 25, 2020.