Attachment_12_-_Cost_Summary_Spreadsheet.xls

XLS spreadsheet 71 KB Posted Aug 25, 2016

Attached to: Naval Aviation Enterprise (NAE)
Solicitation number: N00421-16-R-0065
Issued by: Department of the Navy Naval Air Systems Command

About this file

From the source

Attachment 12

View the file

Other files

File	Type	Posted
Questions_and_Answers_0007.docx	DOCX document	Sep 29, 2016
Attachment_12_-_Cost_Summary_Spreadsheet.xls	XLS spreadsheet	Sep 20, 2016
Questions_and_Answers_0006.docx	DOCX document	Sep 20, 2016
N00421-16-R-0065 _Amendment_0004.docx	DOCX document	Sep 20, 2016
Questions_and_Answers_0005.docx	DOCX document	Sep 13, 2016
Questions_and_Answers_0004.docx	DOCX document	Sep 13, 2016
Questions_and_Answers_0003.docx	DOCX document	Sep 7, 2016
N00421-16-R-0065 _Amendment_0003.docx	DOCX document	Sep 7, 2016
Attachment_1_TO_0001_SOW.docx	DOCX document	Sep 7, 2016
Questions_and_Answers_0002.docx	DOCX document	Sep 1, 2016
N00421-16-R-0065 _Amendment_0002.docx	DOCX document	Sep 1, 2016
Attachment_9_Workforce_Quals__Staffing_Plan.xlsx	XLSX spreadsheet	Sep 1, 2016
Attachment_8_-_Minimum_Personnel_Quals_ _LCAT_Info.docx	DOCX document	Aug 31, 2016
Questions_and_Answers_0001.docx	DOCX document	Aug 31, 2016
Attachment_9_Workforce_Quals_Staffing_Plan.xlsx	XLSX spreadsheet	Aug 31, 2016
N00421-16-R-0065_Amendment_0001.docx	DOCX document	Aug 31, 2016
Attachment_8_-_Minimum_Personnel_Quals_ _LCAT_Info.docx	DOCX document	Aug 25, 2016
Attachment_6_-_GFP_List.pdf	PDF	Aug 25, 2016
Attachment_4_-_COR_Appointment_Letter.docx	DOCX document	Aug 25, 2016
Attachment_6a_-_GFP_Excel.xlsx	XLSX spreadsheet	Aug 25, 2016
Attachment_3a_-_SAC_Encl_1_-_PMR.xls	XLS spreadsheet	Aug 25, 2016
Attachment_1_-_TO_0001.docx	DOCX document	Aug 25, 2016
Attachment_3_-_Surveillance_Activity_Checklist_(SAC).docx	DOCX document	Aug 25, 2016
Attachment_13_-_Fully_Burdened_Labor_Rates.xls	XLS spreadsheet	Aug 25, 2016
Exhibit_A_-_CDRLs_A001-A011.docx	DOCX document	Aug 25, 2016
Attachment_7_-_Data_Item_Transmittal_Acceptance_Rejection_Form.doc	DOC document	Aug 25, 2016
Attachment_11_-_Past_Performance_Questionnaire.doc	DOC document	Aug 25, 2016
Attachment_10_-_Past_Performance_Matrix.doc	DOC document	Aug 25, 2016
Attachment_5_-_OCI_List.docx	DOCX document	Aug 25, 2016
N00421-16-R-0065.docx	DOCX document	Aug 25, 2016
Attachment_2_-_DD254.pdf	PDF	Aug 25, 2016
Attachment_9_-_Workforce_Quals_ _Staffing_Plan.xlsx	XLSX spreadsheet	Aug 25, 2016

Show all 32

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 employee names in Column A (starting at row 9). If they are a prospective hire, please put "Prospective Hire." If they are a Contingent Hire, please identify a name and put "Contingent Hire." If necessary, insert additional rows--but ensure integrity of formulas.
3	In Column B (starting at row 9) for each individual Contractor employee proposed, the offeror shall enter the corresponding Position Number as identified in Attachment 9.
4	Enter the Government Labor Categories in Column C (starting at row 9). Offerors shall type the Government Labor Category name exactly as it is found in the RFP.
5	Enter all prime labor categories in Column D (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column D, 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. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
6	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
7	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.
8	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
9	All dollar figures shall be carried out no further than two decimal places.
10	In column E, identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
11	In column F, 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.
12	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert rows separately and apply accordingly. Please ensure integrity of formulas.
13	For each subcontractor, enter the subcontractor name, total hours, and total amount for each period of performance.
14	Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
15	The prime should insert the subcontractor handling charge, if any.
16	The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
17	The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
18	Under Other Direct Costs, the prime contractor should separate by Travel, Material and NMCI as applicable.
19	Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions.
20	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
21	When submitting this file, the instructions may be deleted.
	Instructions for Subcontractors:
1	Enter Prime offeror name into cell A3.
	Replace Prime Contractor with Subcontractor in A7, A8, A13, and A20.
2	Enter all subcontractor employee names in Column A (starting at row 9). If they are a prospective, please put "Prospective Hire." If they are a Contingent Hire, please identify a name and put "Contingent Hire." If necessary, insert additional rows--but ensure integrity of formulas.
3	In Column B (starting at row 9) for each individual Contractor employee proposed, the offeror shall enter the corresponding Position Number as identified in Attachment 9.
4	Enter the Government Labor Categories in Column C (starting at row 9). Offerors shall type the Government Labor Category name exactly as it is found in the RFP.
5	Enter all subcontractor labor categories in Column D (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column D, 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. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
6	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
7	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.
8	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
9	All dollar figures shall be carried out no further than two decimal places.
10	In column E, identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
11	In column F, 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.
12	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert rows separately and apply accordingly. Please ensure integrity of formulas.
13	For subcontractor cost summary sheets, delete Rows 22-48.
14	When submitting this file, the instructions may be deleted.

IDIQ Cost Spreadsheet

COST SUMMARY SPREADSHEET
Prime Offeror Name:
Subcontractor Name (if applicable):
						Year 1			Year 2			Year 3			Year 4			Year 5			Total for All Periods
Cost Elements	Position #	Government Labor Category	Proposed Labor Category	F/P	Site	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
Employee Name 1								0			0			0			0			0	0	0
Employee Name 2								0			0			0			0			0	0	0
Etc.								0			0			0			0			0	0	0
Total Direct Labor Cost								0			0			0			0			0	0	0
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost								0			0			0			0			0		0
COM
Total Prime Contractor Labor Cost								0			0			0			0			0		0
Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor 1
Subcontractor 2
Etc.
Total proposed subcontractor labor cost and fee								0			0			0			0			0		0
Prime contractor pass through (not including fee)
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through																						0
Total Labor Cost (Prime and Subcontractor Labor)
Fixed Fee
Prime Contractor Fee for Prime Contractor Labor
Prime Contractor Fee for Subcontractor Labor *
Total Fee (for Prime and Subcontractor Labor)
Total Labor Cost Plus Fixed Fee (CPFF)																						0
Other Direct Costs
Other Direct Costs (ODCs)
Any adders to ODCs such as G&A (cost only - no fee)
Total ODCs
Total CPFF all CLINs (Labor and ODCs)																						0
Grand Total of CPFF all CLINs
Pass Through Analysis - Total for All Years		Amount	Percent
Subcontractor proposed cost and fee		$0
Pass Through Amount (not including fee)		$0
Prime Contractor Fee for Subcontractor Labor *		$0
Total Pass Through Amount (including fee)		$0	0%
Maximum Pass Through Allowed by SeaPort-e IDIQ Contract			8%
Fee Analysis - Total for All Years		Amount	Percent
Prime Contractor Labor Cost		$0
Fixed Fee for Labor Performed by Prime Contractor		$0	0%
Maximum Fixed Fee Allowed by SeaPort-e IDIQ Contract
* When analyzing pass through costs, the Government will consider prime offeror fee on subcontractor price as an element of pass through as explained in the Section H Savings Clause of the MACs. In Section B, however, prime offeror fee on subcontractor price is a fee element rather than a cost element. Prime offeror fee on subcontractor price should be included in the fee column (rather than the cost column) of Section B.

&CPage &P&R&F &LKTR: (name)&CSource Selection Information - See: FAR 2.101 and 3.104&RRFP:

IDIQ Summary

CLIN Summary Sheet
CLINS	CLIN Description	Total Hours	Total Cost	Total Fixed Fee	Total Value $
X001
X002
X003
X004
X005
Total

TO 0001 Cost Spreadsheet

COST SUMMARY SPREADSHEET
Prime Offeror Name:
Subcontractor Name (if applicable):
						Year 1			Year 2			Year 3			Year 4			Year 5			Total for All Periods
Cost Elements	Position #	Government Labor Category	Proposed Labor Category	F/P	Site	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
Employee Name 1								0			0			0			0			0	0	0
Employee Name 2								0			0			0			0			0	0	0
Etc.								0			0			0			0			0	0	0
Total Direct Labor Cost								0			0			0			0			0	0	0
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost								0			0			0			0			0		0
COM
Total Prime Contractor Labor Cost								0			0			0			0			0		0
Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor 1
Subcontractor 2
Etc.
Total proposed subcontractor labor cost and fee								0			0			0			0			0		0
Prime contractor pass through (not including fee)
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through																						0
Total Labor Cost (Prime and Subcontractor Labor)
Fixed Fee
Prime Contractor Fee for Prime Contractor Labor
Prime Contractor Fee for Subcontractor Labor *
Total Fee (for Prime and Subcontractor Labor)
Total Labor Cost Plus Fixed Fee (CPFF)																						0
Other Direct Costs
Other Direct Costs (ODCs)
Any adders to ODCs such as G&A (cost only - no fee)
Total ODCs
Total CPFF all CLINs (Labor and ODCs)																						0
Grand Total of CPFF all CLINs
Pass Through Analysis - Total for All Years		Amount	Percent
Subcontractor proposed cost and fee		$0
Pass Through Amount (not including fee)		$0
Prime Contractor Fee for Subcontractor Labor *		$0
Total Pass Through Amount (including fee)		$0	0%
Maximum Pass Through Allowed by SeaPort-e IDIQ Contract			8%
Fee Analysis - Total for All Years		Amount	Percent
Prime Contractor Labor Cost		$0
Fixed Fee for Labor Performed by Prime Contractor		$0	0%
Maximum Fixed Fee Allowed by SeaPort-e IDIQ Contract
* When analyzing pass through costs, the Government will consider prime offeror fee on subcontractor price as an element of pass through as explained in the Section H Savings Clause of the MACs. In Section B, however, prime offeror fee on subcontractor price is a fee element rather than a cost element. Prime offeror fee on subcontractor price should be included in the fee column (rather than the cost column) of Section B.

TO 0001 Summary

CLIN Summary Sheet
CLINS	CLIN Description	Total Hours	Total Cost	Total Fixed Fee	Total Value $
X001
X002
X003
X004
X005
Total

File details come from the government source that posted it. Updated Nov 14, 2017.