Attachment A-15 Mechanical Services-Custom CEB.xlsx

XLSX spreadsheet 57 KB Posted Jun 13, 2024

Attached to: Mechanical Systems Structural Analysis Support Services
Solicitation number: ARG-2664-05232024
Issued by: National Aeronautics and Space Administration

About this file

Written by GovTribe AI · Jun 13, 2024

This document contains attachments related to a Request for Proposal (RFP) from the Jet Propulsion Laboratory (JPL) for Mechanical Systems Structural Analysis Support Services. The RFP seeks proposals from small businesses for technical services including design, development, and implementation of testing methods and equipment. Key details include:

The solicitation number is ARG-2664-05232024, with a NAICS code of 541330 Engineering Services. Proposals are due by July 12, 2024. The government fiscal year runs from October through September, and the RFP includes labor rate ranges, indirect rates, and sample fee calculations for the proposed work. Mandatory qualification criteria are identified, and evidence of an adequate accounting system is required. The RFP attachments provide detailed cost proposal templates for direct labor, indirect rates, travel, material, subcontracts, and other direct costs. This is a Small Business Set-Aside acquisition.

View the file

Other files

File	Type	Posted
RFP Addenda 3.doc	DOC document	Jul 1, 2024
RFP Addenda 2.doc	DOC document	Jul 1, 2024
RFP Addenda 1.doc	DOC document	Jul 1, 2024
RFP Addenda 4.doc	DOC document	Jul 1, 2024
4.23 Ex 1 SWO Procedure.docx	DOCX document	Jun 13, 2024
Attachment B10.doc	DOC document	Jun 13, 2024
Attachment A20.doc	DOC document	Jun 13, 2024
Attachment A-17 Proposer Acct Sys and CAS info 5-17-24.xlsx	XLSX spreadsheet	Jun 13, 2024
Attachment B-21.xlsx	XLSX spreadsheet	Jun 13, 2024
Attachment A2.docx	DOCX document	Jun 13, 2024
Attachment A-22 RWO 3.docx	DOCX document	Jun 13, 2024
Attachment B5.doc	DOC document	Jun 13, 2024
Subk ARG-2664-05232024.docx	DOCX document	Jun 13, 2024
Attachment A-22 RWO 1.docx	DOCX document	Jun 13, 2024
Attachment B12.docx	DOCX document	Jun 13, 2024
Attachment A1.docx	DOCX document	Jun 13, 2024
Attachment A14.docx	DOCX document	Jun 13, 2024
Attachment B13.doc	DOC document	Jun 13, 2024
2.02 rfp-ARG-2664-05232024.docx	DOCX document	Jun 13, 2024
Attachment A21.doc	DOC document	Jun 13, 2024
Attachment A6.doc	DOC document	Jun 13, 2024
Attachment A-22 RWO 2.docx	DOCX document	Jun 13, 2024

Show all 22

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.

Tab 1 - Labor Rate Ranges & Esc JPL RFP ARG-2664-05232024 Attachment A-15 Tab 1

Mechanical Systems Structural Analysis Support Services

Proposed Direct Labor Rate Ranges & Annual Escalation

enter company name

	Notes -
	1	Provide the following information in accordance with RFP Volume III Cost Instructions paragraph 2.1 Tab 1 and paragraph 3.1.
	2	The Government fiscal year runs from October through September.
	3	Insert or delete rows as needed.
	Labor Categories
	#	Labor
Category	Code or
Number (if any)	Description of Roles and Responsibilities		Typical Education
& Experience	Clearance
None or Level	FY'25 Labor Rate Range
				Minimum	Maximum
	1			$0.00	$0.00
	2			$0.00	$0.00
	3			$0.00	$0.00
	4			$0.00	$0.00
	5			$0.00	$0.00
	6			$0.00	$0.00
	7			$0.00	$0.00
	8			$0.00	$0.00
	9			$0.00	$0.00
	10			$0.00	$0.00
	11			$0.00	$0.00
	12			$0.00	$0.00

Proposed Annual Labor Escalation
FY'26	FY'27	FY'28	FY'29
0.00%	0.00%	0.00%	0.00%

	SAMPLE
	#	Title	Code or
Number (if any)	Description of Roles and Responsibilities				Typical Education
& Experience	Clearance
None or Level	Labor Rate Range
								Minimum	Maximum
	1	Test Engineer III	TE3	Designs, develops, and implements testing methods and equipment. Plans and arranges the labor, schedules, and equipment required for testing and evaluating standard and special devices. Provides test area with parameters for sample testing and specifies tests to be performed. Compiles data and defines changes required in testing equipment, testing procedures, manufacturing processes, or new testing requirements. Responsible for testing all customer samples and for special tests that cannot be performed in the test area.		BS + 6 years	None	$38.00	$50.00
	2	Test Engineer III	TE3SC	Holds Security Clearance. Designs, develops, and implements testing methods and equipment. Plans and arranges the labor, schedules, and equipment required for testing and evaluating standard and special devices. Provides test area with parameters for sample testing and specifies tests to be performed. Compiles data and defines changes required in testing equipment, testing procedures, manufacturing processes, or new testing requirements. Responsible for testing all customer samples and for special tests that cannot be performed in the test area.		BS + 6 years	Top Secret	$42.00	$54.00

Sample Annual Labor Escalation
Subcontract Year
2	3	4	5
FY'26	FY'27	FY'28	FY'29
3.10%	2.50%	2.75%	2.75%

Page &P of &N

Tab 2 - Indirect Rates JPL RFP ARG-2664-05232024 Attachment A-15, Tab 2

Mechanical Systems Structural Analysis Support Services

Indirect Rates for Fee Calculation

enter company name

Notes -
1	Provide the following information in accordance with RFP Volume III Cost Instructions paragraph 2.1 Tab 2 and paragraph 3.6.
2	The Government fiscal year runs from October through September.
3	Insert or delete rows as needed.
Indirect Rates - For use in SWO fee calculation			Proposed Rate
#	Indirect Rate Description	Application Base	FY'25	FY'26	FY'27	FY'28	FY'29
1
2
3
4
5
6
7
8
9
SAMPLE
Indirect Rates - For use in SWO fee calculation			Proposed Rate
#	Indirect Rate Description	Application Base	FY'25	FY'26	FY'27	FY'28	FY'29
1	Fringe Benefits	Direct labor	54.2%	55.0%	53.7%	55.2%	55.7%
2	Labor Overhead	Direct labor + fringe benefits	34.7%	35.2%	35.0%	35.2%	35.5%
3	Material Overhead	Raw material cost	7.5%	7.7%	7.2%	6.9%	7.1%
4	Subcontract Overhead	Subcontract cost	3.0%	2.7%	3.1%	2.9%	3.2%
5	IT Services	Labor hours	$ 0.25	$ 0.24	$ 0.29	$ 0.27	$ 0.23
6	General & Administrative	Subtotal direct cost	43.7%	41.0%	42.2%	44.0%	42.7%

Tab 3 - SWO Fee Calculation JPL RFP ARG-2664-05232024 Attachment A-15, Tab 3

Mechanical Systems Structural Analysis Support Services

SWO Fee Calculation

Sample for Information Purposes Only

Note -
Tab 3 is for information purposes. Reference RFP Volume III Cost Instructions Section 2.1 Tab 3 for required acknowledgement of compliance.
Cost Element	SWO Cost - Current Rates			SWO Cost for Fee Calculation			Total Negotiated SWO
	Hours/	Current		Hours/	Neg Indirect	Cost Est @	Hours/	Current
Labor	Base	Rate	Total	Base	Rate	Current Rates	Base	Rate	Total
Data System Architect	10	$ 70.00	$ 700	10	$ 70.00	$ 700	10	$ 70.00	$ 700
Data Management & Archive	10	$ 45.00	$ 450	10	$ 45.00	$ 450	10	$ 45.00	$ 450
Technical Writing and Editing	10	$ 40.00	$ 400	10	$ 40.00	$ 400	10	$ 40.00	$ 400
Mission & Flight System Plan	10	$ 65.00	$ 650	10	$ 65.00	$ 650	10	$ 65.00	$ 650
Mission Operations	10	$ 55.00	$ 550	10	$ 55.00	$ 550	10	$ 55.00	$ 550
Total Labor	50		$ 2,750	50		$ 2,750	50		$ 2,750

Overhead/Fringe $ 2,750 92.0% $ 2,530 $ 2,750 87.0% $ 2,393 92.0% $ 2,530

Material			$ 5,000			$ 5,000		$ 5,000
Material Overhead	$ 5,000	4.3%	$ 215	$ 5,000	4.0%	$ 200	4.3%	$ 215
Subcontract			$ 2,000			$ 2,000		$ 2,000
Subtotal Cost / G&A Base			$ 12,495			$ 12,343		$ 12,495

G&A	$ 12,495	39.0%	$ 4,873	$ 12,343	35.0%	$ 4,320		39.0%	$ 4,873
Total Cost			$ 17,368			$ 16,663			$ 17,368
FCCM - Labor	$ 2,750	0.68%	$ 19	$ 2,750	0.68%	$ 19		0.68%	$ 19
FCCM - Material	$ 5,000	0.07%	$ 4	$ 5,000	0.07%	$ 4		0.07%	$ 4
FCCM - G&A	$ 12,495	0.42%	$ 52	$ 12,343	0.42%	$ 52		0.42%	$ 52
Total Cost + FCCM			$ 17,443			$ 16,738	Cost at Current Rates		$ 17,443
Fixed Fee		N/A			4.0%	$ 667			$ 667
Total Price**		N/A		N/A					$ 18,110

Notes -

1 The SWO cost base for fee calculation is developed using the negotiated indirect rates. The negotiated fee percentage is applied to the total cost (excluding FCCM) resulting from the application of the negotiated indirect rates, to calculate the fee amount.

2 The current direct labor rates are assumed to fall within the negotiated direct labor rate ranges.

3 The Total Price includes the total cost based on current rates plus the fee amount that results from applying the negotiated fee percentage to the total cost (excluding FCCM) as based on the negotiated indirect rates. Note that all direct labor & FCCM cost within the fee calculation cost base reflect current rates.

Tab 4 - RWO Cost Breakdown JPL RFP ARG-2664-05232024 Attachment A-15, Tab 4

Mechanical Systems Structural Analysis Support Services
RWO Cost Element Breakdown
enter company name
Notes -
1. Provide the following information in accordance with RFP Volume III Cost Instructions paragraph 2.1 Tab 4.
2. The rates used below shall be consistent with the FY'25 labor rate ranges proposed within Tab 1 and the FY'25 indirect rates proposed within Tab 2.
3. Insert or delete rows as needed.
Cost Element	RWO 1			RWO 2			RWO 3			Total
	Hours/Base	Rate	Amount	Hours/Base	Rate	Amount	Hours/Base	Rate	Amount	Hours/Base	Rate	Amount
Direct Labor
Category 1	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Category 2	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Category 3	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Category 4	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Category 5	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Category 6	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Category 7	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0	0	$0.00	$0
Total Direct Labor	0		$0	0		$0	0		$0	0		$0

Overhead	$0	0.0%	$0	$0	0.0%	$0	$0	0.0%	$0	$0	0.0%	$0
Fringe Benefits	$0	0.0%	$0	$0	0.0%	$0	$0	0.0%	$0	$0	0.0%	$0

Material	$0	$0	$0	$0
Subcontract	$0	$0	$0	$0
Travel	$0	$0	$0	$0
Other Direct Cost	$0	$0	$0	$0
Subtotal Cost	$0	$0	$0	$0

G&A	$0	0.0%	$0	$0	0.0%	$0	$0	0.0%	$0	$0	0.0%	$0
Total Cost			$0			$0			$0			$0

COM - Labor	$0	$0	$0	$0
COM - Non-labor	$0	$0	$0	$0
COM - G&A	$0	$0	$0	$0
Total COM	$0	$0	$0	$0

Total Cost + COM $0 $0 $0 $0

Fee	$0	0.0%	$0	$0	0.0%	$0	$0	0.0%	$0	$0	0.0%	$0
Total Price			$0			$0			$0			$0

Tab 4-1 Travel JPL RFP ARG-2664-05232024 Attachment A-15, Tab 4-1

Mechanical Systems Structural Analysis Support Services
RWO Travel Cost Detail
enter company name
Notes -
1	Provide the following information in accordance with RFP Volume III Cost Instructions paragraph 3.2.
2	Insert or delete rows as needed.

Travel Cost Detail

Trip

Date

Origin

Destination

Number of -

Airfare

Mileage @ $0.xx/mile

Lodging

M&IE

Rental Car

Other (define)

Total $

/Trip

#		Travelers	Nights	Rental Cars	Unit $	Total $	# Miles	Total $	Unit $	Total $	Unit $	Total $	Unit $	Total $	Unit $	Total $	Unit $	Total $
1																			$0.00
2																			$0.00
3																			$0.00
4																			$0.00
5																			$0.00
6																			$0.00
7																			$0.00
8																			$0.00
9																			$0.00
10																			$0.00
11																			$0.00
12																			$0.00
																	Grand Total		$0.00
Trip	Purpose of Travel
#
1
2
3
4
5
6
7
8
9
10
11
12

Tab 4-2 Material JPL RFP ARG-2664-05232024 Attachment A-15, Tab 4-2

	Mechanical Systems Structural Analysis Support Services
	RWO Material Cost Detail
	enter company name
	Notes:
	1	Provide the following information in accordance with RFP Volume III Cost Instructions paragraph 3.3.
	2	"Raw Mat'l Mark-up" shall include only those mark-up amounts unique to raw material cost, e.g. material handling, freight-in, scrap, etc.
	3	Basis of Estimate "Source Document" includes (but is not limited to); Purchase Order (current or historical), catalog price, engineering estimate.
	4	Basis of Estimate "Reference" shall cite the specific Source Document, e.g. P.O. # and date, catalog publication & date, engineering estimate back-up, etc.
	5	Insert or delete rows as needed
	Item
#	Part
Number	Part
Description	Unit of
Measure	Quantity
Required	Minimum
Buy/Lot	Purchase
Quantity	Cost/
Unit	Total Raw
Mat'l Cost	Raw Mat'l	Total	Lead Time
in Weeks	Supplier	Basis of Estimate
						Mark-up	Material	Source Document	Reference
	1
	2
	3
	4
	5
	6
	7
	8
	9
	10
	11
	12
				Total	$ - 0	$ - 0	$ - 0

Tab 4-3 Subcontracts JPL RFP ARG-2664-05232024 Attachment A-15, Tab 4-3

Mechanical Systems Structural Analysis Support Services
RWO Subcontract Cost Detail
enter company name
Notes -
1	Provide the following information in accordance with RFP Volume III Cost Instructions paragraph 3.4.
2	Insert or delete rows as needed.

	Row
#	Subcontractor
Name		Subcontract
Description		Basis of
Estimate	Proposed Amount
		Name	Division/Location	Description	Type		Year 1	Year 2	Year 3	Total
	1						$0	$0	$0	$0
	2						$0	$0	$0	$0
	3						$0	$0	$0	$0
	4						$0	$0	$0	$0
	5						$0	$0	$0	$0
	6						$0	$0	$0	$0
	7						$0	$0	$0	$0
						Total	$0	$0	$0	$0

Tab 4-4 Other Direct Cost JPL RFP ARG-2664-05232024 Attachment A-15, Tab 4-4

Mechanical Systems Structural Analysis Support Services
RWO Other Direct Cost Detail
enter company name
Notes -
1	Provide the following information in accordance with RFP Volume III Cost Instructions paragraph 3.5.
2	Insert or delete rows as needed.

#	ODC Item	Description	Basis of Estimate
1
2
3
4
5
6
7
8
9
10
11
12

		RWO 1			RWO 2			RWO 3			RWO 1
#	ODC Item	Quantity	Unit Cost	Total Cost	Quantity	Unit Cost	Total Cost	Quantity	Unit Cost	Total Cost	Quantity	Unit Cost	Total Cost
1			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
2			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
3			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
4			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
5			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
6			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
7			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
8			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
9			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
10			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
11			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
12			$0.00	$0.00		$0.00	$0.00		$0.00	$0.00		$0.00	$0.00
		Total		$0.00		Total		Total			Total		$0.00

Base Period
#	ODC Item	Quantity	FY'25	FY'26	FY'27	Total
1			$0.00	$0.00	$0.00	$0.00
2			$0.00	$0.00	$0.00	$0.00
3			$0.00	$0.00	$0.00	$0.00
4			$0.00	$0.00	$0.00	$0.00
5			$0.00	$0.00	$0.00	$0.00
6			$0.00	$0.00	$0.00	$0.00
7			$0.00	$0.00	$0.00	$0.00
8			$0.00	$0.00	$0.00	$0.00
9			$0.00	$0.00	$0.00	$0.00
10			$0.00	$0.00	$0.00	$0.00
11			$0.00	$0.00	$0.00	$0.00
12			$0.00	$0.00	$0.00	$0.00
Total ODC - Base Period			$0.00	$0.00	$0.00	$0.00

Option Periods
#	ODC Item	Quantity	FY'28	FY'29	FY'30	FY'31	FY'32	FY'33
1			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
2			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
3			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
4			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
5			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
6			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
7			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
8			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
9			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
10			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
11			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
12			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Total ODC - Option Periods			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

File details come from the government source that posted it. Updated Jun 13, 2024.