N0017325R0007 - Attachment 11_Task Order 001 Cost Proposal Spreadsheet.xls

XLS spreadsheet 64 KB Posted Feb 10, 2025

Attached to: Focused Radio Frequency Optimized Signal Transference (FROST) Federal contract opportunity
Solicitation number: N00173-25-R-0007
Issued by: Department of the Navy Secretary of the Navy Office of Naval Research

About this file

Written by GovTribe AI · Feb 11, 2025

This is a cost proposal spreadsheet template (Attachment 11) for Task Order 001 under solicitation N0017325R0007 for the Naval Research Laboratory's Focused Radio Frequency Optimized Signal Transference (FROST) program. The template requires pricing for 24 labor categories over 5 years, including 9 key personnel positions requiring various security clearances (TS/SCI, TS, and Secret) and 15 optional non-key positions. The total period of performance is 403,200 hours with fixed Other Direct Costs (ODCs) of $11.25M ($1.25M for travel and $10M for materials/equipment) spread equally across five years at $2.25M per year.

The spreadsheet includes sections for prime contractor labor costs, indirect rates (both contractor and government site), subcontractor costs and pass-through charges, fixed fee calculations, and detailed labor rate build-up tables. Key personnel requirements include Program Manager IV, Electro-Optical Scientists, Analysts, IT Systems Engineers, and Systems Engineers. The work involves both contractor and government site locations, with various security clearance requirements ranging from Secret to TS/SCI. The template requires offerors to provide DCMA and DCAA points of contact information and maintain all calculation formulas intact.

View the file

Other files for this federal contract opportunity

Other files attached to Focused Radio Frequency Optimized Signal Transference (FROST), newest first.
File	Type	Posted
Solicitation - N0017325R0007 Questions and Anwers.pdf	PDF	Feb 26, 2025
N0017325R0007 - Attachment 7_Requirements for On-Site Contractors.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 6_ Past Performance Questionnaire.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 2 DD254.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 16 - Pre-Award Survey.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 3_Personnel Qualifications.pdf	PDF	Feb 10, 2025
Exhibit A - DD Form 1423 _Contract Data Requirements List.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 1_SOW.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 12_Task Order 001 Skill Mix and ODC Values.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 10_Task Order 001 SOW.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 9_Base IDIQ Cost Proposal Spreadsheet.xlsx	XLSX spreadsheet	Feb 10, 2025
N0017325R0007 - Attachment 8_Direct Labor Rate Substantiation.xls	XLS spreadsheet	Feb 10, 2025
Solicitation - N0017325R0007.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 15_Task Order 002 Skill Mix and ODC Values.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 13_Task Order 002 SOW.pdf	PDF	Feb 10, 2025
N0017325R0007 - Attachment 14_Task Order 002 Cost Proposal Spreadsheet.xls	XLS spreadsheet	Feb 10, 2025
N0017325R0007 - Attachment 5_Small Business Participation Commitment Document.docx	DOCX document	Feb 10, 2025
N0017325R0007 - Attachment 4_Base IDIQ Labor Hours and Skill Mix.pdf	PDF	Feb 10, 2025

Show all 18

On GovTribe

Work with this file on GovTribe

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.

Cost Proposal Format

SOLICITATION NO. N0017323RTJ01 - ATTACHMENT 8
COST PROPOSAL FORMAT - IDIQ
OFFEROR SHALL NOT DEVIATE FROM THE LABOR HOURS AND ODCS AS DELINEATED BELOW. PRIME MAY PARSE OUT LABOR HOURS TO SUBCONTRACTOR(S) AS NECESSARY. PRIME SHALL PROPOSE ALL ODCS (DO NOT ASSIGN TO SUBCONTRACTOR(S)).
IT IS THE SOLE RESPONSIBILITY OF THE OFFEROR TO ENSURE THE BELOW CALCULATIONS ARE ACCURATE WITH ALL FORMULAS INTACT.
Prime Offeror Name:
Subcontractor Name(s) (if applicable):
Prime DCMA Point of Contact Information:
Prime DCAA Point of Contact Information:
					Total for All Years		Year 1			Year 2			Year 3			Year 4			Year 5
Cost Elements	Labor Category	Key	Site	Clearance	Hours	Amount	Unburdened Rate	Hours	Amount	Unburdened Rate	Hours	Amount	Unburdened Rate	Hours	Amount	Unburdened Rate	Hours	Amount	Unburdened Rate	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Employee Name 1 (required)	Program Manager IV	Yes	KTR	TS	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 2 (required)	Electro-Optical Scientist IV	Yes	Gov	TS/SCI	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 3 (required)	Electro-Optical Scientist IV	Yes	Gov	TS/SCI	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 4 (required)	Analyst IV	Yes	Gov	TS/SCI	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 5 (required)	Analyst IV	Yes	Gov	TS	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 6 (required)	Analyst IV	Yes	KTR	TS	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 7 (required)	Analyst III	Yes	Gov	TS/SCI	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 8 (required)	IT Systems Engineer IV	Yes	Gov	TS/SCI	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 9 (required)	Systems Engineer IV	Yes	KTR	SECRET	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 11 (optional)	Electro-Optical Scientist IV	No	Gov	TS/SCI	19,200	$ -		3,840	$ -		3,840	$ -		3,840	$ -		3,840	$ -		3,840	$ -
Employee Name 12 (optional)	Electro-Optical Scientist III	No	Gov	SECRET	48,000	$ -		9,600	$ -		9,600	$ -		9,600	$ -		9,600	$ -		9,600	$ -
Employee Name 13 (optional)	Electrical Engineer IV	No	Gov	SECRET	38,400	$ -		7,680	$ -		7,680	$ -		7,680	$ -		7,680	$ -		7,680	$ -
Employee Name 14 (optional)	Electrical Engineer II	No	Gov	SECRET	38,400	$ -		7,680	$ -		7,680	$ -		7,680	$ -		7,680	$ -		7,680	$ -
Employee Name 15 (optional)	Systems Engineer IV	No	Gov	SECRET	28,800	$ -		5,760	$ -		5,760	$ -		5,760	$ -		5,760	$ -		5,760	$ -
Employee Name 16 (optional)	Software Engineer IV	No	Gov	SECRET	38,400	$ -		7,680	$ -		7,680	$ -		7,680	$ -		7,680	$ -		7,680	$ -
Employee Name 17 (optional)	Analyst III	No	Gov	SECRET	28,800	$ -		5,760	$ -		5,760	$ -		5,760	$ -		5,760	$ -		5,760	$ -
Employee Name 18 (optional)	Mechanical Engineer IV	No	KTR	SECRET	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 19 (optional)	Mechanical Engineer II	No	KTR	SECRET	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 20 (optional)	Electronics Technician III	No	KTR	SECRET	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 21 (optional)	Electronics Technician II	No	KTR	SECRET	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 22 (optional)	IT Systems Engineer III	No	Gov	TS	19,200	$ -		3,840	$ -		3,840	$ -		3,840	$ -		3,840	$ -		3,840	$ -
Employee Name 23 (optional)	Technical Writer II	No	KTR	SECRET	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Employee Name 24 (optional)	Administrative Support II	No	KTR	SECRET	9,600	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -		1,920	$ -
Total Direct Labor Cost					403,200	$ -		80,640	$ -		80,640	$ -		80,640	$ -		80,640	$ -		80,640	$ -
Prime Contractor Indirect Labor Cost
CONTRACTOR SITE INDIRECT RATES
Overhead						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Fringe Benefits						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
G&A						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
COM						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Etc. (Add element and Insert additional rows as needed)						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Total Contractor Site Indirect Labor cost						$ -			$ -			$ -			$ -			$ -			$ -
GOVERNMENT SITE INDIRECT RATES
Overhead						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Fringe Benefits						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
G&A						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
COM						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Etc. (Add element and Insert additional rows as needed)						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Total Government Site Indirect Labor cost						$ -			$ -			$ -			$ -			$ -			$ -
Total Prime Contractor Labor Costs						$ -			$ -			$ -			$ -			$ -			$ -
Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor 1 (insert sub name)						$ -
Subcontractor 2 (insert sub name)						$ -
Etc. (Insert additional rows as needed)						$ -
Total proposed subcontractor labor cost and fee						$ -			$ -			$ -			$ -			$ -			$ -
Prime contractor pass through (not including fee)
Handling						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
G&A						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Etc. (Add element and Insert additional rows as needed)						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Total pass through (not including fee)						$ -			$ -			$ -			$ -			$ -			$ -
Total Subcontractor Cost including pass through						$ -			$ -			$ -			$ -			$ -			$ -
Total Labor Cost (Prime and Subcontractor Labor)						$ -			$ -			$ -			$ -			$ -			$ -
Fixed Fee
Prime Contractor Fee for Prime Contractor Labor						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Prime Contractor Fee for Subcontractor Labor						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Total Fee (for Prime and Subcontractor Labor)						$ -			$ -			$ -			$ -			$ -			$ -
Total Labor Cost Plus Fixed Fee (CPFF)						$ -			$ -			$ -			$ -			$ -			$ -
Other Direct Costs
Travel (Plug)						$ 1,250,000			$ 250,000			$ 250,000			$ 250,000			$ 250,000			$ 250,000
Materials/Equipment (Plug)						$ 10,000,000			$ 2,000,000			$ 2,000,000			$ 2,000,000			$ 2,000,000			$ 2,000,000
Any adders to ODCs such as G&A (cost only - no fee)
Etc. (Add element and Insert additional rows as needed)						$ -	0.00%			0.00%			0.00%			0.00%			0.00%
Total ODCs						$ -			$ -			$ -			$ -			$ -			$ -
TOTAL CPFF						$ 11,250,000			$ 2,250,000			$ 2,250,000			$ 2,250,000			$ 2,250,000			$ 2,250,000
Pass Through Analysis - Total for All Years	Amount	Percent
Total Proposed Subcontractor Labor Cost and Fee	$ -
Total Pass Through Amount (not including fee)	$ -
Total Prime Contractor Fee for Subcontractor Labor	$ -
Total Pass Through Amount (including fee)	$ -	0%
Fee Analysis - Total for All Years	Amount	Percent
Total Prime Contractor Labor Cost	$ -
Total Prime Contractor Fee for Prime Contract Labor	$ -	0%
Escalation Analysis	Percent
Escalation from Year 1 to Year 2	0.00%
Escalation from Year 2 to Year 3	0.00%
Escalation from Year 3 to Year 4	0.00%
Escalation from Year 4 to Year 5	0.00%

Labor Rate Build-Up

TABLES BELOW MAY BE EDITED IF NEEDED. ADDITIONAL TABLES MAY BE ADDED.

ADDITIONAL ROWS OR COLUMNS MAY BE ADDED TO ACCURATELY ACCOUNT FOR ALL INDIRECT COSTS.

IT IS THE SOLE RESPONSIBILITY OF THE OFFEROR TO ENSURE RATES ARE CALCULATED ACCURATELY WITH ALL FORMULAS INTACT.

PRIME - GOVERNMENT SITE

Employee Name

Labor Category

Base Rate

Overhead

Fringe

G&A

FCCM - COM

Burdened Rate

Fee

Year 1 Burdened

Year 2 Escalated Rate

Year 3 Escalated Rate

Year 4 Escalated Rate

Year 5 Escalated Rate

0.00%

Rate w/ Fee

0.00%

PRIME - CONTRACTOR SITE

Employee Name

Labor Category

Base Rate

Overhead

Fringe

G&A

FCCM - COM

Burdened Rate

Fee

Year 1 Burdened

Year 2 Escalated Rate

Year 3 Escalated Rate

Year 4 Escalated Rate

Year 5 Escalated Rate

0.00%

Rate w/ Fee

0.00%

SUBCONTRACTOR - (fill in subcontractor name here)

Employee Name

Labor Category

Base Rate

M&H

G&A

Burdened Rate

Prime Fee

Burdened Year 1

Year 2 Escalated Rate

Year 3 Escalated Rate

Year 4 Escalated Rate

Year 5 Escalated Rate

0.00%

Rate w/ Fee

0.00%

File details come from the government source that posted it. Updated Feb 10, 2025.