A-15 TAES Custom CEB 3242025.xlsx

XLSX spreadsheet 68 KB Posted Mar 26, 2025

Attached to: THERMAL ANALYSIS ENGINEERING SERVICES
Solicitation number: MEL-2664-09192024
Issued by: National Aeronautics and Space Administration

About this file

Written by GovTribe AI · Mar 26, 2025

This is a Pricing Template (Excel spreadsheet) for a Thermal Analysis Engineering Services Request for Proposal (RFP) issued by the Jet Propulsion Laboratory (JPL) under solicitation number MEL-2664-09192024. The document is a comprehensive cost proposal template with multiple tabs detailing labor rates, indirect rates, and cost breakdowns for potential contractors. The solicitation is a Small Business Set Aside for research and development services in physical, engineering, and life sciences, with a NAICS code of 541715 and a size standard of 1,300 employees.

Key details include a proposal due date of April 23rd, 2025, at 3:00 p.m. Pacific Time, with Past Performance documentation due by April 12th, 2025. JPL plans to award multiple Cost Reimbursable Type Subcontracts in an initial study phase. The template requires detailed cost information across six fiscal years (FY'25-FY'30), including labor categories, indirect rates (such as fringe benefits, overhead, and G&A), and cost elements like materials, subcontracts, and travel. Sample labor rates are provided, with examples like a Test Engineer III role ranging from $38-$50 per hour, and indirect rates like Fringe Benefits at 54.2-55.7% across the fiscal years.

View the file

Other files

File	Type	Posted
RFP Addenda 2 MEL-2664-09192024.doc	DOC document	May 1, 2025
RFP_Addenda_1 MEL-2664-09192024.doc	DOC document	Apr 23, 2025
JPL_AGP_Cyber_Review_Template_Rev_41 (2).xlsx	XLSX spreadsheet	Apr 23, 2025
Attachment A-17 Proposer Acct Sys and CAS info.xlsx	XLSX spreadsheet	Mar 26, 2025
Attachment A-22 RWO 1 - Thermal Analysis Example 22025.docx	DOCX document	Mar 26, 2025
Attachment A-22 RWO 2 - Thermal CFD Analysis Example 22025.docx	DOCX document	Mar 26, 2025
Attachment B12 (1).docx	DOCX document	Mar 26, 2025
Stnd Subc TAES RFP 3242025 v.docx	DOCX document	Mar 26, 2025
TAES RFP MEL-2664-09192024.docx	DOCX document	Mar 26, 2025
2384-A1 (3) MEL SET.docx	DOCX document	Mar 26, 2025
Attachment A20 (1).doc	DOC document	Mar 26, 2025
Attachment B10 (1).doc	DOC document	Mar 26, 2025
Attachment B5 (1).doc	DOC document	Mar 26, 2025
0358-A14 (1).docx	DOCX document	Mar 26, 2025
Attachment B-21 (1).xlsx	XLSX spreadsheet	Mar 26, 2025
Attachment A-22 RWO 3 - Thermal Test Support Example 22025.docx	DOCX document	Mar 26, 2025
2455-A2 (1).docx	DOCX document	Mar 26, 2025
4022-A6-2.02-MEL-2664-091924 Notice of Small Business Set-Aside (Form JPL 4022-A6).docx	DOCX document	Mar 26, 2025
Attachment A21 (1).doc	DOC document	Mar 26, 2025
4412-B11 (3).docx	DOCX document	Mar 26, 2025
2891-B7 (1).doc	DOC document	Mar 26, 2025
Attachment B13 (1).doc	DOC document	Mar 26, 2025

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 MEL-2664-09192024			Attachment A-15 Tab 1
	Thermal Analysis Engineering 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 #
(if any)	Description of Roles and Responsibilities		Typical Education
& Experience	Clearance

None or Level

	#	Labor
Category	FY'25 Labor Rate Range				FY'26 Labor Rate Range			FY'27 Labor Rate Range
			Minimum	Midpoint	Maximum	Minimum	Midpoint	Maximum	Minimum	Midpoint	Maximum
	1		$0.00	$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	$0.00
	3		$0.00	$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	$0.00
	5		$0.00	$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	$0.00
	7		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

	#	Labor
Category	FY'28 Labor Rate Range				FY'29 Labor Rate Range			FY'30 Labor Rate Range
			Minimum	Midpoint	Maximum	Minimum	Midpoint	Maximum	Minimum	Midpoint	Maximum
	1		$0.00	$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	$0.00
	3		$0.00	$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	$0.00
	5		$0.00	$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	$0.00
	7		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

	SAMPLE - Rates shown are in no way indicative of proposed rates expected by JPL.
	#	Title	Code or
Number (if any)	Description of Roles and Responsibilities			Typical Education
& Experience	Clearance
None or Level		Labor Rate Range
					Minimum	Midpoint	Maximum
	1	Test Engineer III	TE3

tc={2C23CB6E-B18C-41A8-9892-06A402D44719}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Need to update this for our SET, do not have access to previous SET	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	$44.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	$48.00	$54.00

Page &P of &N

Tab 2 - Indirect Rates

JPL RFP MEL-2664-09192024	Attachment A-15, Tab 2
Thermal Analysis Engineering Services
Indirect Rates & Fixed Fee 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.

Fixed Fee	FY'25	FY'26	FY'27	FY'28	FY'29	FY'30
Fee Percentage for use in SWO fixed fee calculation	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%

Indirect Rates - For use in SWO fixed fee calculation			Proposed Rate
#	Indirect Rate Description	Application Base	FY'25	FY'26	FY'27	FY'28	FY'29	FY'30
1			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
2			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
3			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
4			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
5			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
6			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
7			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
8			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
9			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%
INDIRECT RATE SAMPLE - Rates shown are in no way indicative of proposed rates expected by JPL.
Indirect Rates - For use in SWO fixed fee calculation			Proposed Rate
#	Indirect Rate Description	Application Base	FY'25	FY'26	FY'27	FY'28	FY'29	FY'30
1	Fringe Benefits	Direct labor	54.2%	55.0%	53.7%	55.2%	55.7%	54.9%
2	Labor Overhead	Direct labor + fringe benefits	34.7%	35.2%	35.0%	35.2%	35.5%	34.8%
3	Material Overhead	Raw material cost	7.5%	7.7%	7.2%	6.9%	7.1%	7.1%
4	Subcontract Overhead	Subcontract cost	3.0%	2.7%	3.1%	2.9%	3.2%	3.2%
5	IT Services	Labor hours	$ 0.25	$ 0.24	$ 0.29	$ 0.27	$ 0.23	$ 0.25
6	General & Administrative	Subtotal direct cost	43.7%	41.0%	42.2%	44.0%	42.7%	43.0%

Tab 3 - SWO Fee Calculation

JPL RFP MEL-2664-09192024	Attachment A-15, Tab 3
Thermal Analysis Engineering 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	Cost Est @	Hours/	Current
Labor	Base	Rate	Total	Base	Rate	Current Rates	Base	Rate	Total
Data System Architect	10	$ 70.00	$ 700	10	$ 65.00	$ 650	10	$ 70.00	$ 700
Data Management & Archive	10	$ 45.00	$ 450	10	$ 47.00	$ 470	10	$ 45.00	$ 450
Technical Writing and Editing	10	$ 40.00	$ 400	10	$ 38.00	$ 380	10	$ 40.00	$ 400
Mission & Flight System Plan	10	$ 65.00	$ 650	10	$ 62.00	$ 620	10	$ 65.00	$ 650
Mission Operations	10	$ 55.00	$ 550	10	$ 50.00	$ 500	10	$ 55.00	$ 550
Total Labor	50		$ 2,750	50		$ 2,620	50		$ 2,750

Overhead/Fringe $ 2,750 92.0% $ 2,530 $ 2,620 87.0% $ 2,279 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,099		$ 12,495

G&A	$ 12,495	39.0%	$ 4,873	$ 12,099	35.0%	$ 4,235		39.0%	$ 4,873
Total Cost			$ 17,368			$ 16,334			$ 17,368
FCCM - Labor	$ 2,750	0.68%	$ 19	$ 2,620	0.68%	$ 18		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,099	0.42%	$ 51		0.42%	$ 52
Total Cost + FCCM			$ 17,443			$ 16,407	Cost at Current Rates		$ 17,443
Fixed Fee		N/A			4.0%	$ 653			$ 653
Total Price**		N/A		N/A					$ 18,096

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 MEL-2664-09192024										Attachment A-15, Tab 4
Thermal Analysis Engineering 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 MEL-2664-09192024		Attachment A-15, Tab 4-1
Thermal Analysis Engineering 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

RWO

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 MEL-2664-09192024		Attachment A-15, Tab 4-2
Thermal Analysis Engineering 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

	RWO 1
	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
				Total	$ - 0	$ - 0	$ - 0

	RWO 2
	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
				Total	$ - 0	$ - 0	$ - 0

	RWO 3
	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
				Total	$ - 0	$ - 0	$ - 0

Tab 4-3 Subcontracts

JPL RFP MEL-2664-09192024		Attachment A-15, Tab 4-3
Thermal Analysis Engineering 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.

	RWO 1
	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
	RWO 2
	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
	RWO 3
	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 MEL-2664-09192024		Attachment A-15, Tab 4-4
Thermal Analysis Engineering 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
#	ODC Item	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
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		$0.00		Total		Total		$0.00

File details come from the government source that posted it. Updated Mar 26, 2025.