Revised Attachment L-3 Cost Summary Spreadsheet.xlsx

XLSX spreadsheet 54 KB Posted Feb 24, 2021

Attached to: INTELLIGENCE EXPLOITATION AND TARGETING SYSTEMS(IETS) IDIQ Follow On
Solicitation number: N6893621R0004
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

Written by GovTribe AI · Dec 30, 2023

This document includes a cost summary spreadsheet template and information on a related federal contract opportunity. The cost summary spreadsheet template provides instructions for contractors to prepare cost proposals for a contract involving intelligence exploitation and targeting systems. It outlines how to enter labor categories and costs, indirect rates, subcontractor information, fixed fees, and other direct costs.

The related federal contract opportunity is a solicitation seeking proposals for intelligence exploitation and targeting systems research, development, test, and evaluation services. Services will focus on developing and fielding new IETS systems and prototypes or sustaining deployed systems. The Naval Air Warfare Center Weapons Division will issue a request for proposal for a cost plus fixed fee contract under NAICS code 541715. Interested parties must be registered in the System for Award Management and Defense Logistics Information Services.

View the file

Other files

File	Type	Posted
Revised Attachment L-4 Annual Fully Burdened Labor.xlsx	XLSX spreadsheet	Feb 24, 2021
21R0004 Amendment.docx	DOCX document	Feb 24, 2021
N6893621R0004 Attachments.zip	ZIP file	Feb 2, 2021
N6893621R0004 Solicitation.docx	DOCX document	Feb 2, 2021

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.

Instructions

	Instructions for Prime Contractor:
1	Enter Prime offeror name into cell A3.
2	Enter all prime labor categories in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column C, the Offeror should insert the title of the labor category it will be utilizing. The Offeror is not required to utilize the Government's labor categories, however, each proposed labor category should appear opposite of the government labor category it is comparable to. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories.
3	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
4	The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
5	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
6	All dollar figures shall be carried out no further than two decimal places.
7	In column D, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces.
8	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordinly.
9	For each subcontractor, enter the subcontractor name, total hours, and total amount for each period of performance.
10	Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
11	The prime should insert the subcontractor handling charge, if any.
12	The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
13	The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
14	Under Other Direct Costs, the prime contractor should separate by Travel and Material as applicable.
15	Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions.
16	On the Summary tab, break out all costs by CLIN. Ensure that the total costs of the CLINs match Section B and the total on the Cost Summary Spreadsheet
17	When submitting this file, the instructions may be deleted.

	1
	Instructions for Subcontractors:
1	Enter Prime offeror name into cell A3.
2	Replace Prime Contractor with Subcontractor in A7, A8, A51 (Prime Contractor Indirect Cost), and A58 (Total Prime Contractor Labor Cost).
3	Enter all subcontractor labor categories in Column B (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column B, the Offeror should insert the title of the labor category it will be utilizing. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories.
4	One worksheet shall be prepared for each Phase/CLIN (for each Prime and Subcontractor)
5	The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
6	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
7	All dollar figures shall be carried out no further than two decimal places.
8	In column D, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces.
9	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordinly.
10	For subcontractor cost summary sheets, delete Rows 50-86.
11	When submitting this file, the instructions may be deleted.

Section L, Attachment L-4 N68936-16-R-0030

Cost Summary Phase I

COST SUMMARY SPREADSHEET

Prime Offeror Name:
Subcontractor Name (if applicable):
			FY21			FY22			FY23			FY24			FY25			FY26			Total for All Periods
Cost Elements	Proposed Labor Category	Site	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
Total Direct Labor Cost				0	0		0	0		0	0		0	0		0	0		0	0	0	0
Prime Contractor Indirect Labor Cost
Overhead																						0
Fringe Benefits																						0
G&A																						0
Total Indirect Labor Cost					0			0			0			0			0			0		0
Total Direct and Indirect Labor cost					0			0			0			0			0			0		0
COM																						0
Total Prime Contractor Labor Cost					0			0			0			0			0			0		0

Subcontractor Labor Cost
Subcontractor proposed cost and fee
		0		0		0		0		0		0	0	0
		0		0		0		0		0		0	0	0
		0		0		0		0		0		0	0	0
Total proposed subcontractor labor cost and fee	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Prime contractor pass through (not including fee)
Handling														0
G&A														0
Other (if any)														0
Total pass through (not including fee)		0		0		0		0		0		0		0
Total Subcontractor Cost including pass through		0		0		0		0		0		0		0

Total Labor Cost (Prime and Subcontractor Labor) 0 0 0 0 0 0 0

Fixed Fee
Prime Contractor Fee for Prime Contractor Labor							0
Prime Contractor Fee for Subcontractor Labor *							0
Total Fee (for Prime and Subcontractor Labor)	0	0	0	0	0	0	0
							0
Total Labor Cost Plus Fixed Fee (CPFF)	0	0	0	0	0	0	0

Other Direct Costs
Travel							0
Material							0
Any adders to ODCs such as G&A (cost only - no fee)							0
Total ODCs	0	0	0	0	0	0	0

Total CPFF all CLINs (Labor and ODCs) 0 0 0 0 0 0 0

Grand Total of CPFF all CLINs 0

Section L, Attachment L-1 Cost Summary Spreadsheet Breakout N68936-18-R-0015

KTR: (name)	3
	Source Selection Information - See: FAR 2.101 and 3.104

Cost Summary Phase II

COST SUMMARY SPREADSHEET

Prime Offeror Name:
Subcontractor Name (if applicable):
			FY21			FY22			FY23			FY24			FY25			FY26			Total for All Periods
Cost Elements	Proposed Labor Category	Site	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
Total Direct Labor Cost				0	0		0	0		0	0		0	0		0	0		0	0	0	0
Prime Contractor Indirect Labor Cost
Overhead																						0
Fringe Benefits																						0
G&A																						0
Total Indirect Labor Cost					0			0			0			0			0			0		0
Total Direct and Indirect Labor cost					0			0			0			0			0			0		0
COM																						0
Total Prime Contractor Labor Cost					0			0			0			0			0			0		0

Subcontractor Labor Cost
Subcontractor proposed cost and fee
		0		0		0		0		0		0	0	0
		0		0		0		0		0		0	0	0
		0		0		0		0		0		0	0	0
Total proposed subcontractor labor cost and fee	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Prime contractor pass through (not including fee)
Handling														0
G&A														0
Other (if any)														0
Total pass through (not including fee)		0		0		0		0		0		0		0
Total Subcontractor Cost including pass through		0		0		0		0		0		0		0

Total Labor Cost (Prime and Subcontractor Labor) 0 0 0 0 0 0 0

Fixed Fee
Prime Contractor Fee for Prime Contractor Labor							0
Prime Contractor Fee for Subcontractor Labor *							0
Total Fee (for Prime and Subcontractor Labor)	0	0	0	0	0	0	0
							0
Total Labor Cost Plus Fixed Fee (CPFF)	0	0	0	0	0	0	0

Other Direct Costs
Travel							0
Material							0
Any adders to ODCs such as G&A (cost only - no fee)							0
Total ODCs	0	0	0	0	0	0	0

Total CPFF all CLINs (Labor and ODCs) 0 0 0 0 0 0 0

Grand Total of CPFF all CLINs 0

Section L, Attachment L-1 Cost Summary Spreadsheet Breakout N68936-18-R-0015

KTR: (name)	3
	Source Selection Information - See: FAR 2.101 and 3.104

Cost Summary Phase III

COST SUMMARY SPREADSHEET

Prime Offeror Name:
Subcontractor Name (if applicable):
			FY21			FY22			FY23			FY24			FY25			FY26			Total for All Periods
Cost Elements	Proposed Labor Category	Site	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
					0			0			0			0			0			0	0	0
Total Direct Labor Cost				0	0		0	0		0	0		0	0		0	0		0	0	0	0
Prime Contractor Indirect Labor Cost
Overhead																						0
Fringe Benefits																						0
G&A																						0
Total Indirect Labor Cost					0			0			0			0			0			0		0
Total Direct and Indirect Labor cost					0			0			0			0			0			0		0
COM																						0
Total Prime Contractor Labor Cost					0			0			0			0			0			0		0

Subcontractor Labor Cost
Subcontractor proposed cost and fee
		0		0		0		0		0		0	0	0
		0		0		0		0		0		0	0	0
		0		0		0		0		0		0	0	0
Total proposed subcontractor labor cost and fee	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Prime contractor pass through (not including fee)
Handling														0
G&A														0
Other (if any)														0
Total pass through (not including fee)		0		0		0		0		0		0		0
Total Subcontractor Cost including pass through		0		0		0		0		0		0		0

Total Labor Cost (Prime and Subcontractor Labor) 0 0 0 0 0 0 0

Fixed Fee
Prime Contractor Fee for Prime Contractor Labor							0
Prime Contractor Fee for Subcontractor Labor *							0
Total Fee (for Prime and Subcontractor Labor)	0	0	0	0	0	0	0
							0
Total Labor Cost Plus Fixed Fee (CPFF)	0	0	0	0	0	0	0

Other Direct Costs
Travel							0
Material							0
Any adders to ODCs such as G&A (cost only - no fee)							0
Total ODCs	0	0	0	0	0	0	0

Total CPFF all CLINs (Labor and ODCs) 0 0 0 0 0 0 0

Grand Total of CPFF all CLINs 0

Section L, Attachment L-1 Cost Summary Spreadsheet Breakout N68936-18-R-0015

KTR: (name)	3
	Source Selection Information - See: FAR 2.101 and 3.104

Overall CLIN Summary CLIN Summary Sheet

CLINS	CLIN Description	Total Hours	Total Cost	Total Fixed Fee	Total Value $
0001
0002
0003
0004
0005
0006
0007
0008
0009
0010
0011
0012
0013
0014
0015
0016
0017
0018
0019
0020
Total

Section L, Attachment L-4 Summary Tab N68936-16-R-0030

File details come from the government source that posted it. Updated Feb 24, 2021.