Attachment L-04 Basic Price Template (DRFP).xlsx

XLSX spreadsheet 69 KB Posted Mar 16, 2022

Attached to: Draft RFP for NASA KSC Safety and Mission Assurance Contract (SMASS) IV
Solicitation number: 80KSC021SMASSIVDRFP
Issued by: National Aeronautics and Space Administration Kennedy Space Center

About this file

Written by GovTribe AI · Dec 27, 2023

This document package contains a draft Request for Proposal (RFP) along with an Excel pricing template attachment for a NASA Kennedy Space Center contract to provide Safety and Mission Assurance services. The RFP seeks proposals for requirements in areas including system safety engineering, quality assurance, mission assurance, reliability, software assurance, and other specialties. The anticipated contract period of performance spans from February 2023 to January 2028 across one base period and two option periods. The pricing template attachment includes government-provided level of effort hours and fully burdened labor rate tables for offerors to complete for the base contract and FLEX work. It also includes a separate tab for other direct costs with government-provided cost plug values. Offerors are instructed to submit any questions regarding the draft RFP by March 30, 2022 to facilitate revisions before release of the final solicitation.

View the file

Other files

File	Type	Posted
Attachment L-07 Key Position Minimum Qualifications Template.pdf	PDF	Mar 16, 2022
Attachment L-03 Phase-In Template (DRFP).xlsx	XLSX spreadsheet	Mar 16, 2022
80KSC022R0010DRFP Draft RFP.pdf	PDF	Mar 16, 2022
80KSC022R0010DRFP Draft RFP Letter Signed.pdf	PDF	Mar 16, 2022
Attachment L-06 Labor Classifications and Qualifications Crosswalk.xlsx	XLSX spreadsheet	Mar 16, 2022
Attachment L-02 Level of Effort Hours.xlsx	XLSX spreadsheet	Mar 16, 2022
Attachment L-01 Government Standard Labor Categories.pdf	PDF	Mar 16, 2022
Attachment L-05 Labor Distribution and Mapping Template.xlsx	XLSX spreadsheet	Mar 16, 2022
Attachment L-08 Past Performance Questionnaire.pdf	PDF	Mar 16, 2022
SMASSIV DRFP Industry Comment Form.xlsx	XLSX spreadsheet	Mar 16, 2022
80KSC022R0010DRFP Attachments J Portfolio.pdf	PDF	Mar 16, 2022

Show all 11

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.

Cover Page L-04

Kennedy Space Center

Safety and Mission Assurance Support Services IV

(SMASS IV)

Attachment L-04

Basic Price Template (DRFP)

&"Arial,Regular"&12 SMASS IV 80KSC022R0010DRFP

&P of &N

Instructions SMASS IV Proposal Preparation Instructions, by worksheet tab:

Note: SMASS IV Base Contract Period of Performance (PoP) includes CLIN 1 for Base Period (2/1/2023-9/30/2024), CLIN 2 for Option Period 1 (10/1/2024-9/30/2026), and CLIN 3 for Option Period 2 (10/1/2026-1/31/2028). Period of Performance breakout table by PoP is available in worksheet tab "SMASS IV FBLR (Base & FLEX)"

"SMASS IV FBLR (Base & FLEX)" worksheet tab:

This worksheet tab requires Prime offeror to input their Labor Classification in column A. This worksheet details the Government provided Base Contract level-of-effort (LOE) labor hours and FLEX LOE Best Estimated Quantities (BEQs) (column: D, G, & J) in accordance with the SMASS IV RFP Attachment L-02 LOE Hours. BEQs are for evaluation purposes only and are not a limit or guarantee of future work nor do they represent an obligation, commitment, or amount to be ordered by the Government. Offeror is required to input the Prime offeror's fully burdened labor rate (thru Profit) for each prime offeror exempt Labor Classification being proposed (columns E, H, & K) for each PoP (Base Period, Option 1, & Option 2). The SMASS IV fully burdened labor rates (thru profit) dollars are calculated for Base Period, Option 1, and Option 2 (Columns F, I, L). Fully burdened Labor Rates developed for base are auto populated for Flex labor (Specialist 1 is unique to FLEX only) to maintain consistency, as required by the Government. Offeror is required to input a fully burdened labor rate (thru Profit) for the flex labor classification "Specialist 1". Prime offeror is responsible for a comprehensive proposal submittal to the Government for all proposed labor rate(s) per hour, to include its team member(s), based on it's proposal strategy.

Note: The offeror has the ability to modify the fully burdened labor rate (thru Profit) input cell formulas (columns E, H, & K) in accordance with the offeror's accounting system and disclosed practices. The offeror has the ability to utilize the "Other - Equivalent Government Labor Classification Title " row for any proposed additional Key Personnel and/or PMO positions. The Attachment L-02, Level of Effort Hours does not include PMO positions. As previously noted, the Prime offeror is responsible for a comprehensive proposal submittal to the Government for all proposed fully burdened labor rate(s) per hour, to include its team member(s), as applicable and based on it's proposal strategy/approach.

Note that this worksheet tab could include inputs from the Prime offeror to include one or more "Blended" rate(s) based on the potential of co-mingling of Prime offeror and subcontractor team member(s) fully burdened labor rate(s).

Note: The Government purposely listed the Specialist 1 position in Base LOE with no hours assigned. Its purpose is to serve as a place holder in the event that this position is required to support Flex activity during contract execution.

Note: If utilized, the Offeror's "Other" labor classification hours (see row 14) will be in addition to the LOE Hours provided in Attachment L-02, Level of Effort Hours.

"SMASS IV Base Other Direct Cost" worksheet tab:

This worksheet only requires Prime offeror input if additional ODC (those above the Government provided Plug Numbers) are required to accommodate their proposal strategy. The Government's provided plug numbers for each PoP (Base Period, Option 1, & Option 2) are detailed in the "SMASS IV Base Other Direct Cost" worksheet tab and are in accordance with the SMASS IV RFP. Prime offeror shall not alter the Government provided number (upward or downward) in any manner.

"SMASSIV Base & FLEX Total Price" worksheet tab:

This worksheet tab requires no Prime offeror input. The first table in this worksheet tab summarizes the SMASS IV Base and FLEX pricing by Period of Performance for Base Period (2/1/2023-9/30/2024), Option 1 (10/1/2024-9/30/2026), and Option 2 (10/1/2026-1/31/2028). The second table in this worksheet tab summarizes the SMASS IV Base and FLEX fully burdened labor rate(s) thru profit, by Period of Performance.

&"Arial,Regular"&12 SMASS IV 80KSC022R0010DRFP &"Arial,Regular"&12BASIC PRICE TEMPLATE &"Arial,Regular"&12ATTACHMENT L-04

&P of &N

SMASS IV FBLR (Base & FLEX)

SMASS IV Base Contract - Direct Labor (Fully Burdened thru Profit) Government Provided Labor Classifications and Level-of-Effort (LOE) Hours

				Base Period (CLIN 1)
2/1/2023-9/30/2024			Option Period 1 (CLIN 2)
10/1/2024-9/30/2026			Option Period 2 (CLIN 3)
10/1/2026-1/31/2028			Total
	Offeror Labor Classification Title
Equivalent Government Labor Classification Title	Labor Type	Base Labor

Hours

(GFY 23-24)	Fully Burdened Labor Rate-thru Profit
(GFY 23-24)	Fully Burdened Dollars
(GFY 23-24))	Base Labor

Hours

(GFY 25-26)	Fully Burdened Labor Rate-thru Profit
(GFY 25-26)	Fully Burdened Dollars
(GFY 25-26)	Base Labor

Hours

(GFY 27-28)	Fully Burdened Labor Rate-thru Profit
(GFY 27-28)	Fully Burdened Dollars
(GFY 27-28)	Labor Hours	Direct Labor Dollars

Fully Burdened thru Profit

SMA Engineer 1	Exempt	3,837	$ - 0	3,848	$ - 0	2,573	$ - 0	10,258	$ - 0
SMA Engineer 2	Exempt	8,949	$ - 0	5,772	$ - 0	2,573	$ - 0	17,294	$ - 0
SMA Engineer 3	Exempt	39,667	$ - 0	39,442	$ - 0	24,441	$ - 0	103,550	$ - 0
SMA Engineer 4	Exempt	49,265	$ - 0	47,619	$ - 0	28,300	$ - 0	125,184	$ - 0
SMA Engineer 5	Exempt	3,199	$ - 0	3,848	$ - 0	2,573	$ - 0	9,620	$ - 0
Specialist 1	Exempt	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Specialist 2	Exempt	24,042	$ - 0	6,734	$ - 0	2,573	$ - 0	33,349	$ - 0
Specialist 3	Exempt	30,707	$ - 0	25,012	$ - 0	15,436	$ - 0	71,155	$ - 0
Analyst	Exempt	6,399	$ - 0	7,696	$ - 0	5,145	$ - 0	19,240	$ - 0
Other	Exempt	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other	Exempt	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other	Exempt	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other	Exempt	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other	Exempt	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
		166,064	$ - 0	139,971	$ - 0	83,613	$ - 0	389,648	$ - 0

SMASS IV - FLEX Labor Rates (Fully Burdened thru Profit) Government Provided Labor Classifications and FLEX LOE BEQs Hours

				Base Period
2/1/2023-9/30/2024			Option Period 1
10/1/2024-9/30/2026			Option Period 2
10/1/2026-1/31/2028			Total
	Offeror Labor Classification Title
Equivalent Government Labor Classification Title	Labor Type	Labor

Hour BEQ's

(GFY 23- 24)	Fully Burdened Labor Rate-thru Profit
(GFY 23- 24)	Fully Burdened Dollars
(GFY 23- 24)	Labor

Hour BEQ's

(GFY 25- 26)	Fully Burdened Labor Rate-thru Profit
(GFY 25- 26)	Fully Burdened Dollars
(GFY 25- 26)	Labor

Hour BEQ's

(GFY 27- 28)	Fully Burdened Labor Rate-thru Profit
(GFY 27- 28)	Fully Burdened Dollars
(GFY 27- 28)	Labor Hours BEQ's	Direct Labor Dollars

Fully Burdened thru Profit

0	SMA Engineer 1	Exempt	3,345	$0.00	$ - 0	4,374	$0.00	$ - 0	2,937	$0.00	$ - 0	10,656	$ - 0
0	SMA Engineer 2	Exempt	9,402	$0.00	$ - 0	13,283	$0.00	$ - 0	9,369	$0.00	$ - 0	32,054	$ - 0
0	SMA Engineer 3	Exempt	26,580	$0.00	$ - 0	38,549	$0.00	$ - 0	28,547	$0.00	$ - 0	93,676	$ - 0
0	SMA Engineer 4	Exempt	32,547	$0.00	$ - 0	44,233	$0.00	$ - 0	31,023	$0.00	$ - 0	107,803	$ - 0
0	SMA Engineer 5	Exempt	5,188	$0.00	$ - 0	6,298	$0.00	$ - 0	4,224	$0.00	$ - 0	15,710	$ - 0
0	Specialist 1	Exempt	1	$0.00	$ - 0	1	$0.00	$ - 0	1	$0.00	$ - 0	3	$ - 0
0	Specialist 2	Exempt	22,240	$0.00	$ - 0	35,246	$0.00	$ - 0	24,291	$0.00	$ - 0	81,777	$ - 0
0	Specialist 3	Exempt	21,969	$0.00	$ - 0	31,304	$0.00	$ - 0	21,482	$0.00	$ - 0	74,755	$ - 0
0	Analyst	Exempt	3,978	$0.00	$ - 0	4,899	$0.00	$ - 0	3,302	$0.00	$ - 0	12,179	$ - 0
0	Other	Exempt	1	$0.00	$ - 0	1	$0.00	$ - 0	1	$0.00	$ - 0	3	$ - 0
0	Other	Exempt	1	$0.00	$ - 0	1	$0.00	$ - 0	1	$0.00	$ - 0	3	$ - 0
0	Other	Exempt	1	$0.00	$ - 0	1	$0.00	$ - 0	1	$0.00	$ - 0	3	$ - 0
0	Other	Exempt	1	$0.00	$ - 0	1	$0.00	$ - 0	1	$0.00	$ - 0	3	$ - 0
0	Other	Exempt	1	$0.00	$ - 0	1	$0.00	$ - 0	1	$0.00	$ - 0	3	$ - 0
			125,255		$ - 0	178,193		$ - 0	125,180		$ - 0	428,628	$ - 0

Total Base Labor Price	166,064	$ - 0	139,971	$ - 0	83,613	$ - 0	389,648	$ - 0
Total FLEX Labor Price	125,255	$ - 0	178,193	$ - 0	125,180	$ - 0	428,628	$ - 0
Total Base and FLEX Price	291,320	$ - 0	318,164	$ - 0	208,793	$ - 0	818,276	$ - 0

&"Arial,Regular"&12 SMASS IV 80KSC022R0010DRFP &"Arial,Regular"&12BASIC PRICE TEMPLATE &"Arial,Regular"&12ATTACHMENT L-04

&P of &N

SMASS IV Base Other Direct Cost

			OTHER DIRECT COSTS
		ACCOUNTS/ELEMENTS
			Base Period (CLIN 1)
2/1/2023-9/30/2024	Option 1 (CLIN 2)
10/1/2024-9/30/2026	Option 2 (CLIN 3)
10/1/2026-1/31/2028	TOTAL	REFERENCE/BOE
		Total ODC Dollars:	$ 309,800	$ 374,196	$ 251,560	$ 935,556
	1	Miscellaneous ODC	$ 4,994	$ 6,240	$ 4,233	$ 15,467	Gov't Provided Non-Proposed Cost
	2	Travel	$ 304,805	$ 367,956	$ 247,327	$ 920,089	Gov't Provided Non-Proposed Cost
	3					$ -
	4					$ -
	5					$ -
	6					$ -
	7					$ -
	8					$ -
	9					$ -
	10					$ -
	11					$ -
	12					$ -
	13					$ -
	14					$ -
	15					$ -
	16					$ -
	17					$ -
	18					$ -
	19					$ -
	20					$ -
	21					$ -
	22					$ -
	23					$ -
	24					$ -
	25					$ -
	26					$ -
	27					$ -
	28					$ -
	29					$ -
	30					$ -
	31					$ -
	32					$ -
	33					$ -
	34					$ -
	35					$ -
	36					$ -
	37					$ -
	38					$ -
	39					$ -
	40					$ -
	41					$ -
	42					$ -
	43					$ -
	44					$ -
	45					$ -
	46					$ -
	47					$ -
	48					$ -
	49					$ -
	50					$ -

&"Arial,Regular"&12 SMASS IV 80KSC022R0010DRFP &"Arial,Regular"&12BASIC PRICE TEMPLATE &"Arial,Regular"&12ATTACHMENT L-04

&P of &N

SMASSIV Base & FLEX Total Price SMASS IV - Total Hours and Price, by CLIN and Period of Performance

		Pricing Elements
(Fully Burdened thru Profit)	Base Period
(CLIN 1) 2/1/2023-9/30/2024	Option Period 1
(CLIN 2) 10/1/2024-9/30/2026	Option Period 2

(CLIN 3)

10/1/2026-1/31/2028	Total
		BASE	Total Labor Hours	166,064	139,971	83,613	389,648
			Total Labor Dollars	$ - 0	$ - 0	$ - 0	$ - 0
			ODC - Total Dollars	$ 309,800	$ 374,196	$ 251,560	$ 935,556
		FLEX	Gov't provided BEQ Hours	125,255	178,193	125,180	428,628
			FLEX Labor Dollars	$ - 0	$ - 0	$ - 0	$ - 0
			Total BASE Labor and ODC Dollars	$ 309,800	$ 374,196	$ 251,560	$ 935,556
			Total FLEX Labor Dollars	$ - 0	$ - 0	$ - 0	$ - 0
			Total Price (All Labor & Non-Labor)	$ 309,800	$ 374,196	$ 251,560	$ 935,556	$ - 0

		SMASS IV - Fully Burdened Labor Rate-thru Profit for Base Contract and FLEX
		Offeror Labor Classification Title
Equivalent Government Labor Classification Title	Base Period

Fully Burdened Labor Rate-thru Profit (CLIN 1) Option Period 1 Fully Burdened Labor Rate-thru Profit (CLIN 2) Option Period 2 Fully Burdened Labor Rate-thru Profit

(CLIN 3)

SMA Engineer 1	$0.00	$0.00	$0.00
SMA Engineer 2	$0.00	$0.00	$0.00
SMA Engineer 3	$0.00	$0.00	$0.00
SMA Engineer 4	$0.00	$0.00	$0.00
SMA Engineer 5	$0.00	$0.00	$0.00
Specialist 1	$0.00	$0.00	$0.00
Specialist 2	$0.00	$0.00	$0.00
Specialist 3	$0.00	$0.00	$0.00
Analyst	$0.00	$0.00	$0.00
Other	$0.00	$0.00	$0.00
Other	$0.00	$0.00	$0.00
Other	$0.00	$0.00	$0.00
Other	$0.00	$0.00	$0.00
Other	$0.00	$0.00	$0.00

&"Arial,Regular"&12 SMASS IV 80KSC022R0010DRFP &"Arial,Regular"&12BASIC PRICE TEMPLATE &"Arial,Regular"&12ATTACHMENT L-04

&P of &N

File details come from the government source that posted it. Updated Mar 16, 2022.