Attachment J.2 - Pricing Matrix Template.xlsx

XLSX spreadsheet 26 KB Posted Aug 27, 2020

Attached to: Amendment 0005 - Procurement System Review (PSR)
Solicitation number: 69319520R000007
Issued by: Department of Transportation Federal Transit Administration

View the file

Other files

File	Type	Posted
Solicitation 69319520R000007- Questions received - Answers Amendment 0005 (2).xlsx	XLSX spreadsheet	Oct 14, 2020
PSR SF-30 69319520R000007 - Amendment 0005_Signed.pdf	PDF	Oct 14, 2020
Solicitation 69319520R000007- Questions received - Answers Amendment 0004.xlsx	XLSX spreadsheet	Oct 2, 2020
PSR SF-30 69319520R000007 - Amendment 0004_Signed.pdf	PDF	Oct 2, 2020
PSR RFP 69319520R000007 - Amendment 0004.pdf	PDF	Oct 2, 2020
SF-33 69319520R000007.pdf	PDF	Oct 2, 2020
PSR RFP 69319520R000007 - Amendment 0003 (003)_Sigend 10.1.2020.pdf	PDF	Oct 1, 2020
Amendment 0003 - Attachment J.1 Past Performance Questionnaire.docx	DOCX document	Oct 1, 2020
Solicitation 69319520R000007- Questions received - Answers and Comments Amendment 0003.xlsx	XLSX spreadsheet	Oct 1, 2020
Amendment 0002 - 69319520R000007 (002)_Signed.pdf	PDF	Sep 23, 2020
Amendment 0002 - Attachment J.1 Past Performance Questionnaire.docx	DOCX document	Sep 23, 2020
Amendment 0001 - Attachment J.1 Past Performance Questionnaire.pdf	PDF	Sep 14, 2020
Amendment 0001 - 69319520R000007.pdf	PDF	Sep 14, 2020
PSR RFP 69319520R000007.pdf	PDF	Aug 27, 2020
Attachment J.1 Past Performance Questionnaire.docx	DOCX document	Aug 27, 2020
Attachment J.3 - Invoice Template.xlsx	XLSX spreadsheet	Aug 27, 2020

Show all 16

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.

Base Year

CLIN	Description	Labor Rate	Percentage Discount from initial labor rate	Discounted Labor Rate	Estimated LOE TOTAL/ Year	Estimated Quantity	Total Price
0001	Program Management					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor	Senior Procurement Analyst	$0.00			1050		$0.00
Categories	Procurement Analyst	$0.00			1050		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					3000		$0.00
0002	Special Assignment					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0003	PSR Oversight Reviews					FFP, LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			2850		$0.00
	Procurement Analyst	$0.00			2850		$0.00
	Administrative Assistant	$0.00			600		$0.00
TOTAL					7500		$0.00
0004	Corrective Action Support					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0005	Targeted Technical Assistance					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			1050		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					3000		$0.00
0006	Oversight Workshops					NTE LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1200		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			0		$0.00
TOTAL					3000		$0.00
0007	Recipient Training Modules					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			750		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					2400		$0.00
0008	Other Direct Costs					NTE	$9,000
0009	Travel					NTE	$150,000
					Total Price		$159,000.00

Option Yr. 1

CLIN	Description	Labor Rate	Percentage Discount from initial labor rate	Discounted Labor Rate	Estimated LOE TOTAL/ Year	Estimated Quantity	Total Price
0001	Program Management					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor	Senior Procurement Analyst	$0.00			1050		$0.00
Categories	Procurement Analyst	$0.00			1050		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					3000		$0.00
0002	Special Assignment					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0003	PSR Oversight Reviews					FFP, LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			2850		$0.00
	Procurement Analyst	$0.00			2850		$0.00
	Administrative Assistant	$0.00			600		$0.00
TOTAL					7500		$0.00
0004	Corrective Action Support					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0005	Targeted Technical Assistance					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			1050		$0.00
	Admin	$0.00			300		$0.00
TOTAL					3000		$0.00
0006	Oversight Workshops					NTE LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1200		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			0		$0.00
TOTAL					3000		$0.00
0007	Recipient Training Modules					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			750		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					2400		$0.00
0008	Other Direct Costs					NTE	$9,000
0009	Travel					NTE	$150,000
					Total Price		$159,000.00

Option Yr. 2

CLIN	Description	Labor Rate	Percentage Discount from initial labor rate	Discounted Labor Rate	Estimated LOE TOTAL/ Year	Estimated Quantity	Total Price
0001	Program Management					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			1050		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					3000		$0.00
0002	Special Assignment					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0003	PSR Oversight Reviews					FFP, LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			2850		$0.00
	Procurement Analyst	$0.00			2850		$0.00
	Administrative Assistant	$0.00			600		$0.00
TOTAL					7500		$0.00
0004	Corrective Action Support					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0005	Targeted Technical Assistance					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			1050		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					3000		$0.00
0006	Oversight Workshops					NTE LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1200		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			0		$0.00
TOTAL					3000		$0.00
0007	Recipient Training Modules					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			750		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					2400		$0.00
0008	Other Direct Costs					NTE	$9,000
0009	Travel					NTE	$150,000
					Total Price		$159,000.00

Option Yr. 3

CLIN	Description	Labor Rate	Percentage Discount from initial labor rate	Discounted Labor Rate	Estimated LOE TOTAL/ Year	Estimated Quantity	Total Price
0001	Program Management					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			1050		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					3000		$0.00
0002	Special Assignment					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0003	PSR Oversight Reviews					FFP, LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			2850		$0.00
	Procurement Analyst	$0.00			2850		$0.00
	Administrative Assistant	$0.00			600		$0.00
TOTAL					7500		$0.00
0004	Corrective Action Support					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0005	Targeted Technical Assistance					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			1050		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					3000		$0.00
0006	Oversight Workshops					NTE LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1200		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			0		$0.00
TOTAL					3000		$0.00
0007	Recipient Training Modules					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			750		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					2400		$0.00
0008	Other Direct Costs					NTE	$9,000
0009	Travel					NTE	$150,000
					Total Price		$159,000.00

Option Yr. 4

CLIN	Description	Labor Rate	Percentage Discount from initial labor rate	Discounted Labor Rate	Estimated LOE TOTAL/ Year	Estimated Quantity	Total Price
0001	Program Management					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			1050		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					3000		$0.00
0002	Special Assignment					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0003	PSR Oversight Reviews					FFP, LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			2850		$0.00
	Procurement Analyst	$0.00			2850		$0.00
	Administrative Assistant	$0.00			600		$0.00
TOTAL					7500		$0.00
0004	Corrective Action Support					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			900		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			150		$0.00
TOTAL					1950		$0.00
0005	Targeted Technical Assistance					NTE LH
	Principal/Program Manager	$0.00			600		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			1050		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					3000		$0.00
0006	Oversight Workshops					NTE LH
	Principal/Program Manager	$0.00			1200		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1200		$0.00
	Procurement Analyst	$0.00			600		$0.00
	Administrative Assistant	$0.00			0		$0.00
TOTAL					3000		$0.00
0007	Recipient Training Modules					NTE LH
	Principal/Program Manager	$0.00			300		$0.00
Labor Categories	Senior Procurement Analyst	$0.00			1050		$0.00
	Procurement Analyst	$0.00			750		$0.00
	Administrative Assistant	$0.00			300		$0.00
TOTAL					2400		$0.00
0008	Other Direct Costs					NTE	$9,000
0009	Travel					NTE	$150,000
					Total Price		$159,000.00

File details come from the government source that posted it. Updated Aug 27, 2020.