Attachment L-04 Basic Price Template.xlsx

XLSX spreadsheet 69 KB Posted Apr 8, 2022

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

About this file

Written by GovTribe AI · Dec 27, 2023

This document contains an attachment to a Request for Proposal (RFP) for safety and mission assurance support services for NASA's Kennedy Space Center.

The attachment provides pricing templates for offerors to submit proposed labor rates and pricing for the SMASS IV contract. It includes worksheets for offerors to input fully burdened labor rates by labor category for the base period of performance and two option periods. Additional worksheets are provided for flex labor rates by best estimated quantity, other direct costs by contract line item number, and total pricing summaries. Instructions are included on each worksheet tab for offerors to follow in completing the templates as part of their proposal submissions. The templates capture all necessary pricing elements to allow for a comprehensive evaluation of proposed prices. The SMASS IV support services are to be performed at KSC and other NASA centers in areas including system safety, quality assurance, mission assurance, and various engineering disciplines. The RFP is anticipated to be released on April 11, 2022 with proposals due on May 24, 2022.

View the file

Other files

File	Type	Posted
SF30-Amendment 0002.pdf	PDF	May 24, 2022
SF30 Amendment 0002.pdf	PDF	May 24, 2022
SMASS IV Responses to RFP Questions Set 2.pdf	PDF	May 6, 2022
SMASS IV RFP 80KSC022R0010 Amendment 0001 Replacement Pages Portfolio.pdf	PDF	May 2, 2022
SMASS IV RFP 80KSC022R0010 Amendment 0001 Tracked Changes.docx	DOCX document	May 2, 2022
SMASS IV Responses to RFP Questions.pdf	PDF	May 2, 2022
Attachment L-08 Past Performance Questionnaire Amendment 0001.pdf	PDF	May 2, 2022
SMASS IV RFP 80KSC022R0010 Amendment 0001 SF 30 and Continuation Pages.pdf	PDF	May 2, 2022
SMASS IV RFP.pdf	PDF	Apr 8, 2022
Attachment L-06 Labor Classifications and Qualifications Crosswalk.xlsx	XLSX spreadsheet	Apr 8, 2022
Attachment L-02 Level of Effort Hours.xlsx	XLSX spreadsheet	Apr 8, 2022
Attachment L-07 Key Position Minimum Qualifications Template.pdf	PDF	Apr 8, 2022
Attachment L-08 Past Performance Questionnaire.pdf	PDF	Apr 8, 2022
SMASS IV RFP Cover Letter.pdf	PDF	Apr 8, 2022
Attachment L-05 Labor Distribution and Mapping Template.xlsx	XLSX spreadsheet	Apr 8, 2022
Attachment L-09 Total Compensation Plan.xlsx	XLSX spreadsheet	Apr 8, 2022
Attachment L-04.1 Subcontractor Labor Rate Details Template.xlsx	XLSX spreadsheet	Apr 8, 2022
80KSC022R0010 Attachments J Portfolio.pdf	PDF	Apr 8, 2022
Attachment L-01 Government Standard Labor Categories.pdf	PDF	Apr 8, 2022
Attachment L-03 Phase-In Template.xlsx	XLSX spreadsheet	Apr 8, 2022
SMASS IV Responses to DRFP Questions.pdf	PDF	Apr 8, 2022

Show all 21

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

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

&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 offeror's proposed fully burdened labor rate (thru Profit) in accordanc with RFP L.16 for each Labor Classification being proposed (columns E, H, & K) for each PoP (Base Period, Option 1, & Option 2). See Note 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 contract 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 all subcontractors, based on it's proposal strategy (i.e., this worksheet tab must represent a fully integrated pricing strategy to include all subcontractors).

Note 1: 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. Refer to RFP L.16 for PWS section 2 requirements.

Note 2: This worksheet tab may include inputs from the Prime offeror to include one or more "Blended" rate(s) based on the potential of combination of Prime offeror and subcontractor(s) fully burdened labor rate(s).

Note 3: 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 4: 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.

"Prime Base FBLR" worksheet tab:

This spreadsheet tab is informational only in accordance with NASA FAR 1815.403-3(b), and will not be evaluated by the Government for this SMASS IV solicitation. Inputs are specific to the Prime offeror only and its fully burdened labor rate development without regard to any "Blended" rate(s) the Prime offeror might have used in the "SMASS IV FBLR (Base & FLEX)" worksheet tab. Offeror is required to input the following for each PoP (2/1/2023 - 1/31/2028): (a) Base labor rate per hour for each Labor Classification being proposed (columns C, F, and I); (b) All applicable indirects (e.g. fringe, overhead, general and administrative, etc.) and profit which sums a dollar per hour amount (columns D, G, and J); and (c) Government provided a formula (columns E, H, and K) which calculates a fully burdened labor rate (thru Profit), offerors may alter or change the provided formula as deemed necessary.

Note: The "Attachment L-04.1 Subcontractor Labor Rate Details Template" is required for all subcontractors, regardless of dollar value. As applicable, proposed subcontractor(s) have the option of submitting their Attachment L-04.1 Subcontractor Labor Rate Details Template electronically, through the Offeror, or directly to the Government via EFSS box in accordance with the due date, time, and location for delivery specified in this solicitation (RFP L.12).

"SMASS IV Base Other Direct Cost" worksheet tab:

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. Refer to B.4 Non-Proposed Other Direct Costs (ODCs) Values for more information.

"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 80KSC022R0010 &"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 1		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 2		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 3		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 4		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 5		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 6		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 7		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 8		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 9		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 10		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 11		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 12		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 13		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 14		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 15		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 16		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 17		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 18		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 19		- 0	$ - 0	- 0	$ - 0	- 0	$ - 0	- 0	$ - 0
Other 20		- 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,216	$0.00	$ - 0	4,185	$0.00	$ - 0	2,798	$0.00	$ - 0	10,198	$ - 0
0	SMA Engineer 2	Exempt	9,105	$0.00	$ - 0	13,011	$0.00	$ - 0	9,229	$0.00	$ - 0	31,346	$ - 0
0	SMA Engineer 3	Exempt	25,227	$0.00	$ - 0	36,639	$0.00	$ - 0	27,221	$0.00	$ - 0	89,087	$ - 0
0	SMA Engineer 4	Exempt	30,865	$0.00	$ - 0	41,923	$0.00	$ - 0	29,488	$0.00	$ - 0	102,277	$ - 0
0	SMA Engineer 5	Exempt	5,079	$0.00	$ - 0	6,109	$0.00	$ - 0	4,084	$0.00	$ - 0	15,271	$ - 0
0	Specialist 1	Exempt	1	$0.00	$ - 0	1	$0.00	$ - 0	1	$0.00	$ - 0	3	$ - 0
0	Specialist 2	Exempt	21,435	$0.00	$ - 0	34,932	$0.00	$ - 0	24,151	$0.00	$ - 0	80,518	$ - 0
0	Specialist 3	Exempt	20,925	$0.00	$ - 0	30,086	$0.00	$ - 0	20,645	$0.00	$ - 0	71,656	$ - 0
0	Analyst	Exempt	3,759	$0.00	$ - 0	4,521	$0.00	$ - 0	3,023	$0.00	$ - 0	11,303	$ - 0
			119,612		$ - 0	171,406		$ - 0	120,641		$ - 0	411,659	$ - 0

Total Base Labor Price	166,064	$ - 0	139,971	$ - 0	83,613	$ - 0	389,648	$ - 0
Total FLEX Labor Price	119,612	$ - 0	171,406	$ - 0	120,641	$ - 0	411,659	$ - 0
Total Base and FLEX Price	285,676	$ - 0	311,377	$ - 0	204,254	$ - 0	801,307	$ - 0

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

&P of &N

Prime Base FBLR This spreadsheet tab is informational only and is in accordance with NASA FAR 1815.403-3(b), and will not be evaluated as part of the SMASS IV solicitation by the Government. The data input below are specific to the Prime offeror only and is to exclude any "Blended Rates" (which could be based on subcontract team member work allocation and commonality of labor classification with the Prime offeror) that the Prime offeror might have input in the "SMASS IV FBLR (Base & FLEX)" tab.

Fully Burdened Labor Rate - Straight Time - Dollars ($XX.XX) per Hour

	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

	PRIME LABOR CLASSIFICATIONS	Base Labor Rate $	Indirects thru Profit $	Fully Burdened S/T Labor Rate $	Base Labor Rate $	Indirects thru Profit $	Fully Burdened S/T Labor Rate $	Base Labor Rate $	Indirects thru Profit $	Fully Burdened S/T Labor Rate $
1	0			$0.00			$0.00			$0.00
2	0			$0.00			$0.00			$0.00
3	0			$0.00			$0.00			$0.00
4	0			$0.00			$0.00			$0.00
5	0			$0.00			$0.00			$0.00
6	0			$0.00			$0.00			$0.00
8	0			$0.00			$0.00			$0.00
9	0			$0.00			$0.00			$0.00
10	0			$0.00			$0.00			$0.00
11	0			$0.00			$0.00			$0.00
12	0			$0.00			$0.00			$0.00
13	0			$0.00			$0.00			$0.00
14	0			$0.00			$0.00			$0.00
15				$0.00			$0.00			$0.00
16				$0.00			$0.00			$0.00
17				$0.00			$0.00			$0.00
18				$0.00			$0.00			$0.00
19				$0.00			$0.00			$0.00
20				$0.00			$0.00			$0.00
21				$0.00			$0.00			$0.00
22				$0.00			$0.00			$0.00
23				$0.00			$0.00			$0.00
24				$0.00			$0.00			$0.00
25				$0.00			$0.00			$0.00

SMASS IV 80KSC022R0010

ATTACHMENT L-04

Basic Cost Price Template

&"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D

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

Refer to B.4 Non-Proposed Other Direct Costs (ODCs) Values for more information.

&"Arial,Regular"&12 SMASS IV 80KSC022R0010 &"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	119,612	171,406	120,641	411,659
			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

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

&P of &N

File details come from the government source that posted it. Updated Apr 8, 2022.