MMPS_DRFP_NNM17558047R_-_Attachment_L-2_MMPS_Price_Forms_(Prime_Offeror_Only)_Worksheets.xlsx

XLSX spreadsheet 173 KB Posted Nov 28, 2016

Attached to: George C. Marshall Space Flight Center (MSFC) and Michoud Assembly Facility (MAF) Protective Services (MMPS)
Solicitation number: NNM17558047R
Issued by: National Aeronautics and Space Administration Marshall Space Flight Center

About this file

From the source

MMPS DRFP NNM17558047R - Attachment L-2 MMPS Price Forms (Prime Offeror Only) Worksheets

View the file

Other files

File	Type	Posted
MMPS_Source_Selection_Statement.pdf	PDF	Apr 18, 2017
MMPS_RFP_Amendment_3_-_NNM17558047R.docx	DOCX document	Jan 31, 2017
MMPS_RFP_Amendment_2_-_NNM17558047R_-_Attachment_L-1_MMPS_Price_Related_Worksheets.xlsx	XLSX spreadsheet	Jan 25, 2017
MMPS_RFP_Amendment_2_-_NNM17558047R.docx	DOCX document	Jan 25, 2017
MMPS_RFP_Amendment_1_-_NNM17558047R_-_Attachment_L-1_MMPS_Price_Related_Worksheets.xlsx	XLSX spreadsheet	Jan 19, 2017
MMPS_RFP_Amendment_1_-_NNM17558047R_-_Attachment_L-2_MMPS_Price_Forms_(Prime_Offeror_Only)_Worksheets.xlsx	XLSX spreadsheet	Jan 19, 2017
MMPS_RFP_Amendment_1_-_NNM17558047R.docx	DOCX document	Jan 19, 2017
MMPS_RFP_-_NNM17558047R_-_Attachment_L-2_MMPS_Price_Forms_(Prime_Offeror_Only)_Worksheets.xlsx	XLSX spreadsheet	Dec 28, 2016
MMPS_RFP_-_NNM17558047R_Attachment_L-4A_-_MSFC_Security_Police_Officers_CBA.PDF	PDF	Dec 28, 2016
MMPS_RFP_-_NNM17558047R_-_MMPS_SF1449_Phase-In_PO.pdf	PDF	Dec 28, 2016
MMPS_RFP_-_NNM17558047R_Attachment_L-4C_-_MSFC_ID_Registration_and_Personnel_Security_Clerks_CBA.PDF	PDF	Dec 28, 2016
MMPS_RFP_-_NNM17558047R.docx	DOCX document	Dec 28, 2016
MMPS_RFP_-_NNM17558047R_Attachment_L-4E_-_MAF_Identity_Management_Clerks_CBA.PDF	PDF	Dec 28, 2016
MMPS_RFP_-_NNM17558047R_Attachment_L-4B_-_MSFC_Public_Safety_Dispatchers_CBA.PDF	PDF	Dec 28, 2016
MMPS_RFP_-_NNM17558047R_Attachment_L-4D_-_MAF_Security_Police_Officers_CBA.PDF	PDF	Dec 28, 2016
MMPS_RFP_-_NNM17558047R_-_Attachment_L-1_MMPS_Price_Related_Worksheets.xlsx	XLSX spreadsheet	Dec 28, 2016
MMPS_Industry_Day_Virtual_Meeting_Attendees.xlsx	XLSX spreadsheet	Dec 5, 2016
MMPS_Industry_Day_Virtual_Meeting_charts_12052016.pdf	PDF	Dec 5, 2016
MMPS_DRFP_NNM17558047R_-_MMPS_DRFP.docx	DOCX document	Nov 28, 2016
MMPS_DRFP_NNM17558047R_Attachment_J-7B_-_MSFC_Public_Safety_Dispatchers_CBA.PDF	PDF	Nov 28, 2016
MMPS_DRFP_NNM17558047R_Attachment_J-7A_-_MSFC_Security_Police_Officers_CBA.PDF	PDF	Nov 28, 2016
MMPS_DRFP_NNM17558047R_Attachment_J-7E_-_MAF_Identity_Management_Clerks_CBA.pdf	PDF	Nov 28, 2016
MMPS_DRFP_NNM17558047R_Attachment_J-7D_-_MAF_Security_Police_Officers_CBA.PDF	PDF	Nov 28, 2016
MMPS_DRFP_NNM17558047R_-_MMPS_SF1449_Phase-In_PO.pdf	PDF	Nov 28, 2016
MMPS_DRFP_NNM17558047R_Attachment_J-7C_-_MSFC_ID_Registration_and_Personnel_Security_Clerks_CBA.PDF	PDF	Nov 28, 2016
MMPS_DRFP_NNM17558047R_-_Attachment_L-1_MMPS_Price_Related_Worksheets.xlsx	XLSX spreadsheet	Nov 28, 2016

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.

Index

Company XYZ, Inc.

Attachment L-2, MMPS Price Forms Prime Only

Tab	Title	Specific Instruction
PI	Development of Adjusted Subcontractor Fully Burdened Rates (SFBR) with Prime Offeror Burdens	This form is provided as a means to adjust subcontractor’s FBR/IDIQ rates by adding any additional prime contractor burdens to calculate a subcontractor fully burdened rate (SFBR).
PJ	Composite IDIQ Rate Development	This form is utilized to develop blended rates if the offerors teaming arrangement consists of multiple companies (e.g. prime and subcontractors labor) to perform the duties of a full WYE. Indicate the percentage of participation proposed for each labor rate. If the offeror proposes to have one company work 100% for a particular labor category then indicate 100% in the form. The Prime should fill out this form using fully burdened IDIQ rates from each company (Tab PC). The formulas in colored cells will automatically calculate the blended rate.
PK	Summary of Proposed Composite IDIQ Rates by Contract Year	This form inputs the composite rate into a table that can be used to complete Attachment J of the model contract.

&"Arial,Regular"&10&F

L-5b-&P

Tab PI

Development of Adjusted Subcontractor Fully Burdened Rates (SFBR)
With Prime Offeror Burdens
NASA Labor Category Descriptions (LCDs)		Subcontract		Contract Mgmt	ADJ	ADJ	ADJ	ADJ	ADJ
	FBR1	G&A2	OTHER2	Rate 2	SFBR3	SFBR3	SFBR3	SFBR3	SFBR3
example:		5.0%	5.0%	0%	Year 1	Year 2	Year 3	Year 4	Year 5
Major Subcontractor ABC:
	$15.00	$0.75	$0.79	$0.00	$16.54
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
Major Subcontractor XYZ:
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
	$0.00	$0.00	$0.00	$0.00	$0.00
Minor Subcontractor PDQ:

Note 1 The FBR should tie to the rates proposed in that SubOfferor's FBR template TAB A

Note 2 If a rate is not applicable then no further input is required in that column. Contract Management Rate should be applied on the allocation base that was used to calculate the rate. Tab D Section 3

Note 3 The offeror SFBR is Subcontractor Fully Burdened Rate

Note: The offeror may add rows as needed to apply burdens to the subcontractor rates included in the composite rate

&"Arial,Regular"&10&F

Tab PJ

To Be completed by the Prime Offeror

COMPOSITE IDIQ RATE DEVELOPMENT

Development of Contract Rates Weighted For Prime Offeror and Subcontractor Participation Mix

If the Offerors teaming arrangement consists of multiple companies (e.g. prime and sub labor) to perform the duties of a full WYE then

indicate the percentages by company to establish a blended rate. If one company is 100% for a WYE then indicate that as 100%.

Labor Mix	NASA Labor Category Position Descriptions (LCPDs)	Usage	Base Year 1	Option 1	Option 2	Option 3	Option 4
Prime		50%	$10.00	$11.00	$11.30	$11.60	$11.92
Major Subcontractor ABC		10%	$8.00	$9.00	$9.24	$9.49	$9.75
Major Subcontractor XYZ		20%	$9.50	$10.00	$10.27	$10.55	$10.83
Minor Sub PDQ		20%	$9.00	$9.75	$10.01	$10.28	$10.56
MSFC	Program Manager	100%	$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Project Manager		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Security Police Officer Captain		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Physical Security Specialist		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Technology Protection Specialist		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Emergency Management Specialist		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Training Specialist		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Security Police Officer		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Security Police Officer Supervisor		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Dispatcher		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Dispatch Supervisor		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Physical Security Specialist – Investigator		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MSFC	Personnel Security Specialist		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MAF	Project Manager		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MAF	Security Police Officer Captain		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MAF	Security Police Officer		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MAF	Security Police Officer Supervisor		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MAF	Dispatcher		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MAF	Security Police Officer - Investigator		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MAF	Physical Security Specialist		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MAF	Personnel Security Specialist		$0.00	$0.00	$0.00	$0.00	$0.00
		0%
		0%
		0%
		0%
MAF	Training Specialist		$0.00	$0.00	$0.00	$0.00	$0.00
Areas within the table that are white require Offeror input. Color areas contain formulas that may be adjusted by the Offeror as necessary, but the end result is that the spreadsheet must be self-calculating in the same areas as was provided by the Government
If the "% usage" varies among the Prime Offeror, Major Subcontract, Interdivisional, and/or Minor Subcontract weightings by contract year, then the Offeror is to add additional columns and/or rows as necessary and adjust the formula(s) accordingly.
Subcontractor rates shall trace/match to the Tab A of their individual EPM

&"Arial,Regular"&10&F

&A - &P

Tab PK

Summary of Proposed Composite IDIQ Rates by Contract Year

NASA Standard Labor Category (SLC)	Base Yr 1	Option 1	Option 2	Option 3	Option 4
MSFC RATES
Program Manager	$0.00	$0.00	$0.00	$0.00	$0.00
Project Manager	$0.00	$0.00	$0.00	$0.00	$0.00
Security Police Officer Captain	$0.00	$0.00	$0.00	$0.00	$0.00
Physical Security Specialist	$0.00	$0.00	$0.00	$0.00	$0.00
Technology Protection Specialist	$0.00	$0.00	$0.00	$0.00	$0.00
Emergency Management Specialist	$0.00	$0.00	$0.00	$0.00	$0.00
Training Specialist	$0.00	$0.00	$0.00	$0.00	$0.00
Security Police Officer	$0.00	$0.00	$0.00	$0.00	$0.00
Security Police Officer Supervisor	$0.00	$0.00	$0.00	$0.00	$0.00
Dispatcher	$0.00	$0.00	$0.00	$0.00	$0.00
Dispatch Supervisor	$0.00	$0.00	$0.00	$0.00	$0.00
Physical Security Specialist – Investigator	$0.00	$0.00	$0.00	$0.00	$0.00
Personnel Security Specialist	$0.00	$0.00	$0.00	$0.00	$0.00

NASA Standard Labor Category (SLC)	Base Yr 1	Option 1	Option 2	Option 3	Option 4
MAF RATES
Project Manager	$0.00	$0.00	$0.00	$0.00	$0.00
Security Police Officer Captain	$0.00	$0.00	$0.00	$0.00	$0.00
Security Police Officer	$0.00	$0.00	$0.00	$0.00	$0.00
Security Police Officer Supervisor	$0.00	$0.00	$0.00	$0.00	$0.00
Dispatcher	$0.00	$0.00	$0.00	$0.00	$0.00
Security Police Officer - Investigator	$0.00	$0.00	$0.00	$0.00	$0.00
Physical Security Specialist	$0.00	$0.00	$0.00	$0.00	$0.00
Personnel Security Specialist	$0.00	$0.00	$0.00	$0.00	$0.00
Training Specialist	$0.00	$0.00	$0.00	$0.00	$0.00

&"Arial,Regular"&10&F

File details come from the government source that posted it. Updated Nov 14, 2017.