P7_Sub_Cost_Summary_Spreadsheet.xls

XLS spreadsheet 205 KB Posted Feb 6, 2017

Attached to: 4. 11. 3 Ship and Air Integrated Warfare (SAIW) Division Program Management Support Services
Solicitation number: N00421-16-R-0049
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

From the source

Attch P7 - Sub Cost Summary Spreadsheet

View the file

Other files

File	Type	Posted
Attch_07_COR_Designation.docx	DOCX document	Feb 6, 2017
P4_Streamlined_Rates_for_Order_Pricing.xlsx	XLSX spreadsheet	Feb 6, 2017
Attch_01_Wage_Determinations.docx	DOCX document	Feb 6, 2017
Attch_05_Authorized_Subcontractors.docx	DOCX document	Feb 6, 2017
P6_Prime_Cost_Summary_Spreadsheet.xls	XLS spreadsheet	Feb 6, 2017
Attch_04_OCI_List.docx	DOCX document	Feb 6, 2017
P3_Fully_Burdened_Labor_Rates.xls	XLS spreadsheet	Feb 6, 2017
Exhibit_A_CDRLs.xlsx	XLSX spreadsheet	Feb 6, 2017
Attch_02_DD-254.pdf	PDF	Feb 6, 2017
P2_Contractor_Performance_Assessment_Questionnaire.pdf	PDF	Feb 6, 2017
Attch_03_Data_Item_Transmittal_Form.docx	DOCX document	Feb 6, 2017
N00421-16-R-0049_REVISED_DRAFT_Solicitation.docx	DOCX document	Feb 6, 2017
Attch_06_Authorized_Key_Personnel.doc	DOC document	Feb 6, 2017
P1_Past_Performance_Information_Form.pdf	PDF	Feb 6, 2017
REVISED_DRAFT_N00421-16-R-0049.docx	DOCX document	Dec 14, 2016
Attch_05_OCI_List.docx	DOCX document	Dec 14, 2016
P1_Past_Performance_Information_Form.pdf	PDF	Dec 14, 2016
P4_Streamlined_Rates_for_Order_Pricing.xlsx	XLSX spreadsheet	Dec 14, 2016
Attch_01_Wage_Determinations.docx	DOCX document	Dec 14, 2016
Attch_06_Authorized_Subcontractors.docx	DOCX document	Dec 14, 2016
P7_Sub_Cost_Summary_Spreadsheet.xls	XLS spreadsheet	Dec 14, 2016
P3_Fully_Burdened_Labor_Rates.xls	XLS spreadsheet	Dec 14, 2016
P2_Contractor_Performance_Assessment_Questionnaire.pdf	PDF	Dec 14, 2016
Attch_07_Authorized_Key_Personnel.doc	DOC document	Dec 14, 2016
Attch_03_Contract_Surveillance_Plan.docx	DOCX document	Dec 14, 2016
P6_Prime_Cost_Summary_Spreadsheet.xls	XLS spreadsheet	Dec 14, 2016
Attch_08_COR_Designation.docx	DOCX document	Dec 14, 2016
Attch_04_Data_Item_Transmittal_Form.docx	DOCX document	Dec 14, 2016
Attch_02_DD-254.pdf	PDF	Dec 14, 2016
Exhibit_A_CDRLs.xlsx	XLSX spreadsheet	Dec 14, 2016
P1_Past_Performance_Information_Form.pdf	PDF	Oct 25, 2016
Attch_02_Contract_Surveillance_Plan.docx	DOCX document	Oct 25, 2016
Attch_05_Authorized_Key_Personnel.doc	DOC document	Oct 25, 2016
Attch_07_Locator_Form.doc	DOC document	Oct 25, 2016
Attch_04_OCI_List.docx	DOCX document	Oct 25, 2016
Attch_06_Authorized_Subcontractors.docx	DOCX document	Oct 25, 2016
Attch_01_DD-254.pdf	PDF	Oct 25, 2016
P5_Prime_Cost_Summary_Spreadsheet.xls	XLS spreadsheet	Oct 25, 2016
Attch_03_Data_Item_Transmittal_Form.docx	DOCX document	Oct 25, 2016
Attch_09_COR_Designation.docx	DOCX document	Oct 25, 2016
N00421-16-R-0049_DRAFT_Solicitation.docx	DOCX document	Oct 25, 2016
P3_Fully_Burdened_Labor_Rates.xls	XLS spreadsheet	Oct 25, 2016
P6_Sub_Cost_Summary_Spreadsheet.xls	XLS spreadsheet	Oct 25, 2016
Attch_08_Wage_Determinations.docx	DOCX document	Oct 25, 2016
P4_Streamlined_Rates_for_Order_Pricing.xlsx	XLSX spreadsheet	Oct 25, 2016
P2_Contractor_Performance_Assessment_Questionnaire.pdf	PDF	Oct 25, 2016

Show all 46

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
	(Please note that the cells referenced below correspond to the Cost Type sheets. The Summary sheet is numbered slightly differently. )
	Contractor:
1	On Header Tab for each worksheet, insert the proposal number. The file name should be automatically populated.
2	On Footer Tab for the worksheet, insert the firm's name after colon. Insert the RFP number after the colon, if it has not been filled-in.
3	A worksheet should be prepared for each year of the period of performance. The tab name should match the period of performance. A summary sheet exists in the orange tab. The information in the summary tab should automatically carry over from the other tabs. Verify that the summary sheet is correct after completing the separate tabs for each year.
4	Every worksheet should have items 1 and 2 completed.
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	Within the work sheet any cell colored "blue" contains a formula that should not be edited.
7	All dollar figures shall be carried out no further than two decimal places. Values with additional decimal places shall not be used within any calculations.
8	In Cell B2, enter the period of performance calendar dates. (ex: 1 Jan 09 - 31 Dec 09). Enter the period of performance calendar dates for all option years in the corresponding cells for each period of performance. Type "SUMMARY" in the period of performance cell for that section of the spreadsheet.
9	In column A, starting at row 5, the Government Labor Categories from the Historical Information should have been inserted. In column B, the Offeror can insert the title of the labor category it will be utilizing. If it is comparable to one of the Government Labor Categories, then it should appear opposite that category. However, if it is not comparable, utilize the "not comparable" row. The Offeror is not required to utilize the Government's labor categories. However, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. This applies to the Prime Contractor's section and those sections for its subcontractors. If necessary, insert additional rows--but ensure integrity of formulas. 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.
10	In column C, the Offeror should insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in Government spaces.
11	In column D, for the contractor's own workforce, the field is colored "green" indicating no input. (This reflects that the contractor is proposing its own employees or contingency hires--it does not include any subcontractors.) No input is required by the Offeror in this column.
12	In column E, for the individual subcontractor workforce, 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.
13	In column F, enter the name of the proposed individual for that position.
14	In column G:
	(a) enter the unburdened labor rate for each individual (e.g. rows 5-40)
	(b) In Cell G42 the contractor should insert its fringe rate for full time, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
	(c) In Cell G43 the contractor should insert its fringe rate for part-time, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank. If no part-time employees are proposed this should also be left blank.
	(d) In Cell G45, the contractor should insert its overhead rate for work performed at the contractor's facility.
	(e) In Cell G46, the contractor should insert its overhead rate for work performed at the Client/Government's facility.
	(f) In Cell G48, the contractor should insert its G&A rate being applied.
	(g) In Cell G362, the contractor should insert the fixed fee rate applied to its cost.
15	In column H:
	(a) enter the hours associated with individual labor category for CLIN 0101 (e.g., rows 5-40).
	(b) In Cell H42, the contractor should input the base its fringe rate for full time is being applied to, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
	(c) In Cell H43, the contractor should input the base its fringe rate for part time is being applied to, if it is not included in its overhead rate. If the fringe is included in the overhead rate, this cell should be left blank.
	(d) In Cell H46, the contractor should insert the base its overhead rate is being applied to for work performed at the contractor's facility.
	(e) In Cell H47, the contractor should insert the base its overhead rate is being applied to for work performed at the Client/Government's facility.
	(f) In Cell H49, the contractor should insert the base its G&A rate is being applied to.
	(g) In Cell H362, the contractor should insert the labor base its fixed fee rate is being applied to.
16	Column H automatically calculated the total hours for all the CLINS.
17	Column K is a summation of the costs.
18	If there is not going to be any data entry in a row or group of rows, please just hide the rows. Do not delete. For example, if the contractor is only utilizing sixteen of the labor categories in rows 5-40, then the rows concerning the reamining nineteen categories would be hidden.
19	When submitting this file, the instructions may be deleted.

&R&F

Base Year Cost Type

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:							CLIN	0101
Services	Contractor						hrs	subtotal
Government Labor Category (* = Key)	Proposed Category	site	sub	f/p	Employee Name	Rate		Labor	Total
Acquisition Specialist	Example Category	k		f	John Doe	$ 20.80	1920	$ 39,936.00	$ 39,936.00
Acquisition Specialist, Senior*						$ - 0	0	$ - 0	$ - 0
Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Electrical)						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Mechanical)						$ - 0	0	$ - 0	$ - 0
Financial Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Graphic Artist						$ - 0	0	$ - 0	$ - 0
Help Desk Support Specialist, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst I						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Network Engineer						$ - 0	0	$ - 0	$ - 0
Program Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Program Manager, Senior*						$ - 0	0	$ - 0	$ - 0
Project Analyst						$ - 0	0	$ - 0	$ - 0
Project Support Specialist						$ - 0	0	$ - 0	$ - 0
Secretary						$ - 0	0	$ - 0	$ - 0
Subject Matter Expert						$ - 0	0	$ - 0	$ - 0
Systems Analyst, Senior						$ - 0	0	$ - 0	$ - 0
Systems Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Technical Writer III						$ - 0	0	$ - 0	$ - 0
Travel Clerk I						$ - 0	0	$ - 0	$ - 0
Travel Clerk III						$ - 0	0	$ - 0	$ - 0
not comparable						$ - 0	0	$ - 0	$ - 0
subtotal							1,920.0	$ 39,936.00	$ 39,936.00
fringe fulltime						0.00%	$ - 0	$ - 0	$ - 0
fringe part time						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 39,936.00	$ 39,936.00
Overhead							Base
Contractor site						0.00%	$ - 0	$ - 0	$ - 0
Client site						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 39,936.00	$ 39,936.00
G&A						0.00%	$ - 0	$ - 0	$ - 0
FCCOM						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 39,936.00	$ 39,936.00
Total Labor									$ 39,936.00
Fee/Profit						0.0%	$ - 0	$ - 0
Fee/Profit Pool								$ - 0	$ - 0
Grand Total Cost								$ 39,936.00	$ 39,936.00
Grand Total Fixed Fee Pool								$ - 0	$ - 0
Grand Total Subcontractor Labor Cost Plus Fee/Profit							1,920.0	$ 39,936.00	$ 39,936.00
Grand Total Services									$ 39,936.00

&L&F&CProposal#: ############&R&A &LKTR: XXXXX&CSource Selection Information See: FAR 2.101 & 3.104&RRFP#: N00421-16-R-0049 &L&F &R(insert proposal number) &A &LKTR:(insert name)&CSource Selection Information See: FAR 3.104&RRFP:N00024-09-R-3185

Year 2 Cost Type

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:							CLIN	0101
Services	Contractor						hrs	subtotal
Government Labor Category (* = Key)	Proposed Category	site	sub	f/p	Employee Name	Rate		Labor	Total
Acquisition Specialist	Example Category	k		f	John Doe	$ 21.01	1920	$ 40,339.20	$ 40,339.20
Acquisition Specialist, Senior*						$ - 0	0	$ - 0	$ - 0
Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Electrical)						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Mechanical)						$ - 0	0	$ - 0	$ - 0
Financial Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Graphic Artist						$ - 0	0	$ - 0	$ - 0
Help Desk Support Specialist, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst I						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Network Engineer						$ - 0	0	$ - 0	$ - 0
Program Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Program Manager, Senior*						$ - 0	0	$ - 0	$ - 0
Project Analyst						$ - 0	0	$ - 0	$ - 0
Project Support Specialist						$ - 0	0	$ - 0	$ - 0
Secretary						$ - 0	0	$ - 0	$ - 0
Subject Matter Expert						$ - 0	0	$ - 0	$ - 0
Systems Analyst, Senior						$ - 0	0	$ - 0	$ - 0
Systems Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Technical Writer III						$ - 0	0	$ - 0	$ - 0
Travel Clerk I						$ - 0	0	$ - 0	$ - 0
Travel Clerk III						$ - 0	0	$ - 0	$ - 0
not comparable						$ - 0	0	$ - 0	$ - 0
subtotal							1,920.0	$ 40,339.20	$ 40,339.20
fringe fulltime						0.00%	$ - 0	$ - 0	$ - 0
fringe part time						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 40,339.20	$ 40,339.20
Overhead							Base
Contractor site						0.00%	$ - 0	$ - 0	$ - 0
Client site						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 40,339.20	$ 40,339.20
G&A						0.00%	$ - 0	$ - 0	$ - 0
FCCOM						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 40,339.20	$ 40,339.20
Total Labor									$ 40,339.20
Fee/Profit						0.0%	$ - 0	$ - 0
Fee/Profit Pool								$ - 0	$ - 0
Grand Total Cost								$ 40,339.20	$ 40,339.20
Grand Total Fixed Fee Pool								$ - 0	$ - 0
Grand Total Subcontractor Labor Cost Plus Fee/Profit							1,920.0	$ 40,339.20	$ 40,339.20
Grand Total Services									$ 40,339.20

&L&F&CProposal#: ############&R&A &LKTR: XXXXX&CSource Selection Information See: FAR 2.101 & 3.104&RRFP#: N00421-16-R-0049

Year 3 Cost Type

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:							CLIN	0101
Services	Contractor						hrs	subtotal
Government Labor Category (* = Key)	Proposed Category	site	sub	f/p	Employee Name	Rate		Labor	Total
Acquisition Specialist	Example Category	k		f	John Doe	$ 21.22	1920	$ 40,742.40	$ 40,742.40
Acquisition Specialist, Senior*						$ - 0	0	$ - 0	$ - 0
Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Electrical)						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Mechanical)						$ - 0	0	$ - 0	$ - 0
Financial Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Graphic Artist						$ - 0	0	$ - 0	$ - 0
Help Desk Support Specialist, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst I						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Network Engineer						$ - 0	0	$ - 0	$ - 0
Program Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Program Manager, Senior*						$ - 0	0	$ - 0	$ - 0
Project Analyst						$ - 0	0	$ - 0	$ - 0
Project Support Specialist						$ - 0	0	$ - 0	$ - 0
Secretary						$ - 0	0	$ - 0	$ - 0
Subject Matter Expert						$ - 0	0	$ - 0	$ - 0
Systems Analyst, Senior						$ - 0	0	$ - 0	$ - 0
Systems Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Technical Writer III						$ - 0	0	$ - 0	$ - 0
Travel Clerk I						$ - 0	0	$ - 0	$ - 0
Travel Clerk III						$ - 0	0	$ - 0	$ - 0
not comparable						$ - 0	0	$ - 0	$ - 0
subtotal							1,920.0	$ 40,742.40	$ 40,742.40
fringe fulltime						0.00%	$ - 0	$ - 0	$ - 0
fringe part time						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 40,742.40	$ 40,742.40
Overhead							Base
Contractor site						0.00%	$ - 0	$ - 0	$ - 0
Client site						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 40,742.40	$ 40,742.40
G&A						0.00%	$ - 0	$ - 0	$ - 0
FCCOM						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 40,742.40	$ 40,742.40
Total Labor									$ 40,742.40
Fee/Profit						0.0%	$ - 0	$ - 0
Fee/Profit Pool								$ - 0	$ - 0
Grand Total Cost								$ 40,742.40	$ 40,742.40
Grand Total Fixed Fee Pool								$ - 0	$ - 0
Grand Total Subcontractor Labor Cost Plus Fee/Profit							1,920.0	$ 40,742.40	$ 40,742.40
Grand Total Services									$ 40,742.40

&L&F&CProposal#: ############&R&A &LKTR: XXXXX&CSource Selection Information See: FAR 2.101 & 3.104&RRFP#: N00421-16-R-0049

Year 4 Cost Type

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:							CLIN	0101
Services	Contractor						hrs	subtotal
Government Labor Category (* = Key)	Proposed Category	site	sub	f/p	Employee Name	Rate		Labor	Total
Acquisition Specialist	Example Category	k		f	John Doe	$ 21.43	1920	$ 41,145.60	$ 41,145.60
Acquisition Specialist, Senior*						$ - 0	0	$ - 0	$ - 0
Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Electrical)						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Mechanical)						$ - 0	0	$ - 0	$ - 0
Financial Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Graphic Artist						$ - 0	0	$ - 0	$ - 0
Help Desk Support Specialist, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst I						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III*						$ - 0	0	$ - 0	$ - 0
Management Analyst III						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Network Engineer						$ - 0	0	$ - 0	$ - 0
Program Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Program Manager, Senior*						$ - 0	0	$ - 0	$ - 0
Project Analyst						$ - 0	0	$ - 0	$ - 0
Project Support Specialist						$ - 0	0	$ - 0	$ - 0
Secretary						$ - 0	0	$ - 0	$ - 0
Subject Matter Expert						$ - 0	0	$ - 0	$ - 0
Systems Analyst, Senior						$ - 0	0	$ - 0	$ - 0
Systems Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Technical Writer III						$ - 0	0	$ - 0	$ - 0
Travel Clerk I						$ - 0	0	$ - 0	$ - 0
Travel Clerk III						$ - 0	0	$ - 0	$ - 0
not comparable						$ - 0	0	$ - 0	$ - 0
subtotal							1,920.0	$ 41,145.60	$ 41,145.60
fringe fulltime						0.00%	$ - 0	$ - 0	$ - 0
fringe part time						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 41,145.60	$ 41,145.60
Overhead							Base
Contractor site						0.00%	$ - 0	$ - 0	$ - 0
Client site						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 41,145.60	$ 41,145.60
G&A						0.00%	$ - 0	$ - 0	$ - 0
FCCOM						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 41,145.60	$ 41,145.60
Total Labor									$ 41,145.60
Fee/Profit						0.0%	$ - 0	$ - 0
Fee/Profit Pool								$ - 0	$ - 0
Grand Total Cost								$ 41,145.60	$ 41,145.60
Grand Total Fixed Fee Pool								$ - 0	$ - 0
Grand Total Subcontractor Labor Cost Plus Fee/Profit							1,920.0	$ 41,145.60	$ 41,145.60
Grand Total Services									$ 41,145.60

&L&F&CProposal#: ############&R&A &LKTR: XXXXX&CSource Selection Information See: FAR 2.101 & 3.104&RRFP#: N00421-16-R-0049

Year 5 Cost Type

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:							CLIN	0101
Services	Contractor						hrs	subtotal
Government Labor Category (* = Key)	Proposed Category	site	sub	f/p	Employee Name	Rate		Labor	Total
Acquisition Specialist	Example Category	k		f	John Doe	$ 21.64	1920	$ 41,548.80	$ 41,548.80
Acquisition Specialist, Senior*						$ - 0	0	$ - 0	$ - 0
Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Electrical)						$ - 0	0	$ - 0	$ - 0
Engineer, Senior (Mechanical)						$ - 0	0	$ - 0	$ - 0
Financial Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Graphic Artist						$ - 0	0	$ - 0	$ - 0
Help Desk Support Specialist, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Information Management & Technology Analyst, Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst Junior						$ - 0	0	$ - 0	$ - 0
Management Analyst Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst Senior*						$ - 0	0	$ - 0	$ - 0
Management Analyst Senior						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Manager*						$ - 0	0	$ - 0	$ - 0
Network Engineer						$ - 0	0	$ - 0	$ - 0
Program Analyst, Junior						$ - 0	0	$ - 0	$ - 0
Program Manager, Senior*						$ - 0	0	$ - 0	$ - 0
Project Analyst						$ - 0	0	$ - 0	$ - 0
Project Support Specialist						$ - 0	0	$ - 0	$ - 0
Secretary						$ - 0	0	$ - 0	$ - 0
Systems Analyst, Senior						$ - 0	0	$ - 0	$ - 0
Systems Engineer, Journey Level						$ - 0	0	$ - 0	$ - 0
Technical Writer III						$ - 0	0	$ - 0	$ - 0
Travel Clerk I						$ - 0	0	$ - 0	$ - 0
Travel Clerk III						$ - 0	0	$ - 0	$ - 0
not comparable						$ - 0	0	$ - 0	$ - 0
subtotal							1,920.0	$ 41,548.80	$ 41,548.80
fringe fulltime						0.00%	$ - 0	$ - 0	$ - 0
fringe part time						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 41,548.80	$ 41,548.80
Overhead							Base
Contractor site						0.00%	$ - 0	$ - 0	$ - 0
Client site						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 41,548.80	$ 41,548.80
G&A						0.00%	$ - 0	$ - 0	$ - 0
FCCOM						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 41,548.80	$ 41,548.80
Total Labor									$ 41,548.80
Fee/Profit						0.0%	$ - 0	$ - 0
Fee/Profit Pool								$ - 0	$ - 0
Grand Total Cost								$ 41,548.80	$ 41,548.80
Grand Total Fixed Fee Pool								$ - 0	$ - 0
Grand Total Subcontractor Labor Cost Plus Fee/Profit							1,920.0	$ 41,548.80	$ 41,548.80
Grand Total Services									$ 41,548.80

&L&F&CProposal#: ############&R&A &LKTR: XXXXX&CSource Selection Information See: FAR 2.101 & 3.104&RRFP#: N00421-16-R-0049

SUMMARY Cost Type

DO NOT TYPE IN ANY COLORED AREAS
Period of Performance:	SUMMARY						CLIN	0101
Services	Contractor						hrs	subtotal
Government Labor Category (* = Key)	Proposed Category	site	sub	f/p	Employee Name	Rate		Labor	Total
Acquisition Specialist	Example Category	k		f	John Doe	$ 21.22	9,600.00	$ 203,712.00	$ 203,712.00
Acquisition Specialist, Senior*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Engineer, Journey Level	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Engineer, Senior (Electrical)	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Engineer, Senior (Mechanical)	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Financial Analyst, Junior	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Graphic Artist	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Help Desk Support Specialist, Junior	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Information Management & Technology Analyst, Junior	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Information Management & Technology Analyst, Senior*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Management Analyst I	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Management Analyst III*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Management Analyst III*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Management Analyst III*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Management Analyst III*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Management Analyst III*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Management Analyst III	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Manager*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Manager*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Manager*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Manager*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Network Engineer	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Program Analyst, Junior	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Program Manager, Senior*	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Project Analyst	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Project Support Specialist	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Secretary	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Subject Matter Expert	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Systems Analyst, Senior	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Systems Engineer, Journey Level	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Technical Writer III	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Travel Clerk I	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
Travel Clerk III	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
not comparable	0	0		0	0	$ - 0	- 0	$ - 0	$ - 0
subtotal							9,600.0	$ 203,712.00	$ 203,712.00
fringe fulltime						0.00%	$ - 0	$ - 0	$ - 0
fringe part time						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 203,712.00	$ 203,712.00
Overhead							Base
Contractor site						0.00%	$ - 0	$ - 0	$ - 0
Client site						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 203,712.00	$ 203,712.00
G&A						0.00%	$ - 0	$ - 0	$ - 0
FCCOM						0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ 203,712.00	$ 203,712.00
Total Labor									$ 203,712.00
Fee/Profit						0.0%	$ - 0	$ - 0
Fee/Profit Pool								$ - 0	$ - 0
Grand Total Cost								$ 203,712.00	$ 203,712.00
Grand Total Fixed Fee Pool								$ - 0	$ - 0
Grand Total Subcontractor Labor Cost Plus Fee/Profit							9,600.0	$ 203,712.00	$ 203,712.00
Grand Total Services									$ 203,712.00

&L&F&CProposal#: ############&R&A &LKTR: XXXXX&CSource Selection Information See: FAR 2.101 & 3.104&RRFP#: N00421-16-R-0049

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