Attch 9 - Pricing Matrix - Amendment 1.xlsx

XLSX spreadsheet 90 KB Posted Oct 6, 2020

Attached to: RFP for Remote Manifesting Resolution Center (RMRC)
Solicitation number: AFICC_RFP_FA445220R0009
Issued by: Department of the Air Force Air Mobility Command

View the file

Other files

File	Type	Posted
Attch 9 - Pricing Matrix - Amendment 2.xlsx	XLSX spreadsheet	Oct 8, 2020
RFP QAs as of 08 October 2020_2.pdf	PDF	Oct 8, 2020
RFP Cover Letter RMRC_Amendment 2.pdf	PDF	Oct 8, 2020
Attch 3- Addendum to FAR Clause 52.212-2_Amendment 2.pdf	PDF	Oct 8, 2020
Attch 2- Addendum to FAR Clause 52.212-1_Amendment 2.pdf	PDF	Oct 8, 2020
Attch 8 - Staffing Matrix - Amendment 2.XLSX	XLSX spreadsheet	Oct 8, 2020
RFP QAs as of 08 October 2020.pdf	PDF	Oct 8, 2020
Attch 2- Addendum to FAR Clause 52.212-1_Amendment 1.pdf	PDF	Oct 6, 2020
RFP Cover Letter RMRC_Amendment 1.pdf	PDF	Oct 6, 2020
Attch 8 - Staffing Matrix - Amendment 1.XLSX	XLSX spreadsheet	Oct 6, 2020
RFP QAs as of 05 October 2020.pdf	PDF	Oct 6, 2020
RFP QAs as of 25 September 2020.pdf	PDF	Sep 25, 2020
Attch 13- DD254_31 Aug 2020.pdf	PDF	Sep 17, 2020
Attch 5- CDRLs_16 September.pdf	PDF	Sep 17, 2020
Attch 1- RMRC_PWS.pdf	PDF	Sep 17, 2020
Attch 4 - Mission Essential RFP Attachment.pdf	PDF	Sep 17, 2020
Attch 10 - RFP PPIS.pdf	PDF	Sep 17, 2020
Attch 8 - Staffing Matrix.XLSX	XLSX spreadsheet	Sep 17, 2020
Attch 12 - Subcontracting Sample Consent Letter.pdf	PDF	Sep 17, 2020
Attch 7- Provisions and Clauses.pdf	PDF	Sep 17, 2020
Attch 11 - Past Performance Questionnaire.pdf	PDF	Sep 17, 2020
Attch 6- QASP.pdf	PDF	Sep 17, 2020
Attch 3- Addendum to FAR Clause 52.212-2.pdf	PDF	Sep 17, 2020
Attch 2- Addendum to FAR Clause 52.212-1.pdf	PDF	Sep 17, 2020
Attch 9 - Pricing Matrix.xlsx	XLSX spreadsheet	Sep 17, 2020
RFP Cover Letter RMRC.pdf	PDF	Sep 17, 2020

Show all 26

On GovTribe

Work with this file

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.

Info Sheet

RFP FA445220R0009
Pricing Worksheet, Attachment 9
1	Contractor Name / Address (Must have ZIP + 4) & Email Addresses:
	Contractor Name
	Address
	Email Address
2	Telephone Number
	Fax Number
3	CAGE Code
4	Contractor Tax Identification Number (TIN)
5	DUNS No.
6	Please check any of the following that apply to your firm:
	Hub Zone Certification
	8(a) Certified Small Business
	Educational Organization
	Nonprofit Educational
	Service-Related Disabled Veteran-Owned Small Business
	Other Veteran-Owned Small Business
	Other Educational
7	Prompt Payment Discount
8	FOB Point:	Destination
9	System for Award Management (SAM)	Please ensure that all information contained in the SAM is current and that registration has not expired
10	CLIN Structure	Contractor shall fill out the unit price and total price of all CLINS.
		Contractor shall also fill in the tables in the following Sheets for all proposed personnel
	ALL DOLLAR VALUES SHOULD BE ROUNDED TO THE NEAREST DOLLAR. Ensure extended prices are exactly divisible by the quantity of units. To avoid calculation errors when using excel, make sure workbook has “set precision as displayed” checked. This will ensure that any previous rounding calculations sum correctly.

11	Contractor Points of Contact
		Primary	Alternate
	Name:		Name:
	Title:		Title:
	Address:		Address:
	Telephone:		Telephone:
	Email:		Email:

CLIN Summary

	RFP FA445220R0009 CLIN Summary
	CLIN Number	CLIN Description	Contract Type	Phase-In
(One-Month)	Base Period
(6 Months & 15 Days)	Option Period 1	Option Period 2	Option Period 3	Option Period 4	Option Period 5
(5-Months)	Subtotal	Total
	X001	Phase-In	FFP
	X002	eSecure Duties (IAW PWS Para 3.1.2)	FFP
	X003	Baggage Resolution Center (IAW PWS Para 3.1.20)	FFP
	X004	Manual Manifesting of Cargo & Passengers (IAW PWS Para 3.1.8)	FFP
	X005	Data Records Support (IAW PWS Para 3.1.7)	FFP
	X006	Web Services Support (IAW PWS Para 3.1.5)	FFP
	X007	Ad Hoc Data Request Support (IAW PWS Para 3.1.12)	FFP
	X008	Workload Reporting System (IAW PWS Para 3.1.14)	FFP
	X009	Web GATES Support (IAW PWS Para 3.1.21)	FFP
	X010	Data Deliverables - NSP	FFP
						Grand Total

Phase- In & Base Period

	Phase-In - 15 February 2021 - 14 March 2021 & Base Period - 15 March 2021 - 30 September 2021
	CLIN	Labor Categories	Hours (Monthly)	Rate (Hourly)	Total Labor	Unit of Issue (Month)	Total Price/Performance Period
	CLIN 0001 - Phase-In		0	$ - 0	$ - 0		$ - 0
					$ - 0	1	$ - 0
	[add more rows for each column, as necessary for CLIN 0001.]				$ - 0	1	$ - 0
					$ - 0	1	$ - 0
	CLIN 0002- eSecure Duties (IAW PWS Para 3.1.2)		0	$ - 0	$ - 0		$ - 0
					$ - 0	6.5	$ - 0
	[add more rows for each column, as necessary for CLIN 0002.]				$ - 0	6.5	$ - 0
					$ - 0	6.5	$ - 0
	CLIN 0003- Baggage Resolution Center (IAW PWS Para 3.1.20)		0	$ - 0	$ - 0		$ - 0
					$ - 0	6.5	$ - 0
	[add more rows for each column, as necessary for CLIN 0003.]				$ - 0	6.5	$ - 0
					$ - 0	6.5	$ - 0
	CLIN 0004- Manual Manifesting of Cargo & Passengers (IAW PWS Para 3.1.8)		0	$ - 0	$ - 0		$ - 0
					$ - 0	6.5	$ - 0
	[add more rows for each column, as necessary for CLIN 0004.]				$ - 0	6.5	$ - 0
					$ - 0	6.5	$ - 0
	CLIN 0005- Data Records Support (IAW PWS Para 3.1.7)		0	$ - 0	$ - 0		$ - 0
					$ - 0	6.5	$ - 0
	[add more rows for each column, as necessary for CLIN 0005.]				$ - 0	6.5	$ - 0
					$ - 0	6.5	$ - 0
	CLIN 0006-Web Services Support (IAW PWS Para 3.1.5)		0	$ - 0	$ - 0		$ - 0
					$ - 0	6.5	$ - 0
	[add more rows for each column, as necessary for CLIN 0006.]				$ - 0	6.5	$ - 0
					$ - 0	6.5	$ - 0
	CLIN 0007- Ad Hoc Data Request Support (IAW PWS Para 3.1.12)		0	$ - 0	$ - 0		$ - 0
					$ - 0	6.5	$ - 0
	[add more rows for each column, as necessary for CLIN 0007.]				$ - 0	6.5	$ - 0
					$ - 0	6.5	$ - 0
	CLIN 0008- Workload Reporting System (IAW PWS Para 3.1.14)		0	$ - 0	$ - 0		$ - 0
					$ - 0	6.5	$ - 0
	[add more rows for each column, as necessary for CLIN 0008.]				$ - 0	6.5	$ - 0
					$ - 0	6.5	$ - 0
	CLIN 0009- Web GATES Support (IAW PWS Para 3.1.21)		0	$ - 0	$ - 0		$ - 0
					$ - 0	6.5	$ - 0
	[add more rows for each column, as necessary for CLIN 0009.]				$ - 0	6.5	$ - 0
					$ - 0	6.5	$ - 0
	CLIN 0010- Data Deliverables - NSP		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		ERROR:#REF!
						Phase-In & Base Period
GRAND TOTAL	$ - 0

Option Period 1

	Option Period 1: 01 October 2021 - 30 September 2022
	CLIN	Labor Categories	Hours (Monthly)	Rate (Hourly)	Total Labor	Unit of Issue (Month)	Total Price/Performance Period
	CLIN 1002- eSecure Duties (IAW PWS Para 3.1.2)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 1002.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 1003- Baggage Resolution Center (IAW PWS Para 3.1.20)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 1003.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 1004- Manual Manifesting of Cargo & Passengers (IAW PWS Para 3.1.8)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 1004.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 1005- Data Records Support (IAW PWS Para 3.1.7)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 1005.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 1006-Web Services Support (IAW PWS Para 3.1.5)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 1006.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 1007- Ad Hoc Data Request Support (IAW PWS Para 3.1.12)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 1007.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 1008- Workload Reporting System (IAW PWS Para 3.1.14)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 1008.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 1009- Web GATES Support (IAW PWS Para 3.1.21)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 1009.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 1010- Data Deliverables - NSP		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		ERROR:#REF!
						Option Period 1
GRAND TOTAL	$ - 0

Option Period 2

	Option Period 2: 01 October 2022 - 30 September 2023
	CLIN	Labor Categories	Hours (Monthly)	Rate (Hourly)	Total Labor	Unit of Issue (Month)	Total Price/Performance Period
	CLIN 2002- eSecure Duties (IAW PWS Para 3.1.2)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 2002.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 2003- Baggage Resolution Center (IAW PWS Para 3.1.20)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 2003.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 2004- Manual Manifesting of Cargo & Passengers (IAW PWS Para 3.1.8)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 2004.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 2005- Data Records Support (IAW PWS Para 3.1.7)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 2005.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 2006-Web Services Support (IAW PWS Para 3.1.5)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 2006.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 2007- Ad Hoc Data Request Support (IAW PWS Para 3.1.12)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 2007.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 2008- Workload Reporting System (IAW PWS Para 3.1.14)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 2008.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 2009- Web GATES Support (IAW PWS Para 3.1.21)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 2009.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 2010- Data Deliverables - NSP		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		ERROR:#REF!
						Option Period 2
GRAND TOTAL	$ - 0

Option Period 3

	Option Period 3: 01 October 2023 - 30 September 2024
	CLIN	Labor Categories	Hours (Monthly)	Rate (Hourly)	Total Labor	Unit of Issue (Month)	Total Price/Performance Period
	CLIN 3002- eSecure Duties (IAW PWS Para 3.1.2)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 3002.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 3003- Baggage Resolution Center (IAW PWS Para 3.1.20)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 3003.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 3004- Manual Manifesting of Cargo & Passengers (IAW PWS Para 3.1.8)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 3004.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 3005- Data Records Support (IAW PWS Para 3.1.7)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 3005.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 3006-Web Services Support (IAW PWS Para 3.1.5)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 3006.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 2007- Ad Hoc Data Request Support (IAW PWS Para 3.1.12)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 2007.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 3008- Workload Reporting System (IAW PWS Para 3.1.14)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 3008.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 3009- Web GATES Support (IAW PWS Para 3.1.21)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 3009.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 3010- Data Deliverables - NSP		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		ERROR:#REF!
						Option Period 3
GRAND TOTAL	$ - 0

Option Period 4

	Option Period 4: 01 October 2024 - 30 September 2025
	CLIN	Labor Categories	Hours (Monthly)	Rate (Hourly)	Total Labor	Unit of Issue (Month)	Total Price/Performance Period
	CLIN 4002- eSecure Duties (IAW PWS Para 3.1.2)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 4002.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 4003- Baggage Resolution Center (IAW PWS Para 3.1.20)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 4003.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 4004- Manual Manifesting of Cargo & Passengers (IAW PWS Para 3.1.8)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 4004.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 4005- Data Records Support (IAW PWS Para 3.1.7)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 4005.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 4006-Web Services Support (IAW PWS Para 3.1.5)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 4006.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 4007- Ad Hoc Data Request Support (IAW PWS Para 3.1.12)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 4007.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 4008- Workload Reporting System (IAW PWS Para 3.1.14)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 4008.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 4009- Web GATES Support (IAW PWS Para 3.1.21)		0	$ - 0	$ - 0		$ - 0
					$ - 0	12	$ - 0
	[add more rows for each column, as necessary for CLIN 4009.]				$ - 0	12	$ - 0
					$ - 0	12	$ - 0
	CLIN 4010- Data Deliverables - NSP		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		ERROR:#REF!
						Option Period 4
GRAND TOTAL	$ - 0

Option Period 5

	Option Period 5: 01 October 2025 - 14 February 2026
	CLIN	Labor Categories	Hours (Monthly)	Rate (Hourly)	Total Labor	Unit of Issue (Month)	Total Price/Performance Period
	CLIN 5002- eSecure Duties (IAW PWS Para 3.1.2)		0	$ - 0	$ - 0		$ - 0
					$ - 0	5	$ - 0
	[add more rows for each column, as necessary for CLIN 5002.]				$ - 0	5	$ - 0
					$ - 0	5	$ - 0
	CLIN 5003- Baggage Resolution Center (IAW PWS Para 3.1.20)		0	$ - 0	$ - 0		$ - 0
					$ - 0	5	$ - 0
	[add more rows for each column, as necessary for CLIN 5003.]				$ - 0	5	$ - 0
					$ - 0	5	$ - 0
	CLIN 5004- Manual Manifesting of Cargo & Passengers (IAW PWS Para 3.1.8)		0	$ - 0	$ - 0		$ - 0
					$ - 0	5	$ - 0
	[add more rows for each column, as necessary for CLIN 4004.]				$ - 0	5	$ - 0
					$ - 0	5	$ - 0
	CLIN 5005- Data Records Support (IAW PWS Para 3.1.7)		0	$ - 0	$ - 0		$ - 0
					$ - 0	5	$ - 0
	[add more rows for each column, as necessary for CLIN 5005.]				$ - 0	5	$ - 0
					$ - 0	5	$ - 0
	CLIN 5006-Web Services Support (IAW PWS Para 3.1.5)		0	$ - 0	$ - 0		$ - 0
					$ - 0	5	$ - 0
	[add more rows for each column, as necessary for CLIN 5006.]				$ - 0	5	$ - 0
					$ - 0	5	$ - 0
	CLIN 5007- Ad Hoc Data Request Support (IAW PWS Para 3.1.12)		0	$ - 0	$ - 0		$ - 0
					$ - 0	5	$ - 0
	[add more rows for each column, as necessary for CLIN 4007.]				$ - 0	5	$ - 0
					$ - 0	5	$ - 0
	CLIN 5008- Workload Reporting System (IAW PWS Para 3.1.14)		0	$ - 0	$ - 0		$ - 0
					$ - 0	5	$ - 0
	[add more rows for each column, as necessary for CLIN 5008.]				$ - 0	5	$ - 0
					$ - 0	5	$ - 0
	CLIN 5009- Web GATES Support (IAW PWS Para 3.1.21)		0	$ - 0	$ - 0		$ - 0
					$ - 0	5	$ - 0
	[add more rows for each column, as necessary for CLIN 5009.]				$ - 0	5	$ - 0
					$ - 0	5	$ - 0
	CLIN 5010- Data Deliverables - NSP		ERROR:#REF!	ERROR:#REF!	ERROR:#REF!		ERROR:#REF!
						Option Period 5
GRAND TOTAL	$ - 0

File details come from the government source that posted it. Updated Oct 6, 2020.