Attachment_P7_-_CLIN_Breakout_Subcontractor.xls

XLS spreadsheet 114 KB Posted Feb 4, 2016

Attached to: Draft RFP for Warfare Analysis-AIR 4. 0M Federal contract opportunity
Solicitation number: N00421-15-R-0014
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

From the source

Subcontractor Cost Breakout Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to Draft RFP for Warfare Analysis-AIR 4. 0M, newest first.
File	Type	Posted
Attachment_3_-_COR_Appointment_Letter.docx	DOCX document	Feb 4, 2016
Attachment_1_-_QASP.docx	DOCX document	Feb 4, 2016
Attachment_P6_-_CLIN_Breakout_Spreadsheet.xls	XLS spreadsheet	Feb 4, 2016
Attachment_8_-_Scheduled_GFP_(Excel).xlsx	XLSX spreadsheet	Feb 4, 2016
Attachment_5_-_RGFP_incorporated_pursuant_to_DFARS_245.103-72_(PDF).pdf	PDF	Feb 4, 2016
Attachment_2_-_DD254.pdf	PDF	Feb 4, 2016
Attachment_P5_-_Past_Performance_Questionnaire.doc	DOC document	Feb 4, 2016
Attachment_7_-_SGFP_(PDF).pdf	PDF	Feb 4, 2016
Attachment_P4_-_CPARS_Update_Questionaire.doc	DOC document	Feb 4, 2016
Attachment_P8_-_Fully_Burdened_Labor_Rates.xls	XLS spreadsheet	Feb 4, 2016
Attachment_6_-_RGFP_(XLSX).xlsx	XLSX spreadsheet	Feb 4, 2016
Attachment_P3_-_Past_Performance_Matrix.doc	DOC document	Feb 4, 2016
Attachment_4_-_Approved_Subcontracting_Plan.docx	DOCX document	Feb 4, 2016
DRAFT_RFP_N00421-15-R-0014.docx	DOCX document	Feb 4, 2016
Attachment_P1_-_Workforce_Qualifications.xls	XLS spreadsheet	Feb 4, 2016
Attachment_P2_-_Reserved.docx	DOCX document	Feb 4, 2016

Show all 16

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.

Instructions

	Instructions
	SubContractor:
1	Insert the Contract Line Item Numbers (CLINs) at Cells I2, L2, O2, R2, and U2.
2	On Header Tab for each worksheet, insert the proposal number. The file name should be populated.
3	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.
4	Columns I, L, O, R and U are totals for each year. A SUMMARY SHEET OF ALL PERIODS NEEDS TO BE COMPLETED AS A SEPARATE TAB.
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 and should not be edited, unless there is an error in the formula. It is the Contractor's responsibility to verify all formulas and to correct them, if necessary. The Government does not warrant that the formulas are correct.
7	All dollar figures shall be carried out no further than two decimal places.
8	The worksheet is arranged that the workforce being proposed for an entire period of performance is shown together, even though it will separated by individual CLINs in Section B. When the numbers are carried to Section B, they will be the same as shown on the worksheet SUMMARY.
9	In Cell B2, enter the period of performance calendar dates. (ex: 1 Jan 09 - 31 Dec 09)
10	In column A, starting at row 5 to 27, 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. This applies to the Prime Contractor's section and those sections for its subcontractors. If necessary, insert additional rows--but ensure integrity of formulas. 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. The Offeror does not insert any subcontractor information in this section. 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.
11	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.
12	In column D, for the prime contractor's own workforce, the field is colored "green" indicating no input. (This reflects that the prime contractor is proposing its own employees or contingency hires--it does not include any subcontractors.) For the subcontractors, their fields are in yellow. No input is required by the Offeror in this column. Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
13	In column E, for both the prime contractor's own workforce and that of the individual subcontractors' workforces, 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.
14	In column F, enter the name of the proposed individual for that position.
15	In column G:
	(a) for the prime contractor, enter the unburdened labor rate for each individual (e.g. rows 5-27)
	(b) In row 32 the prime 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 row 33 the prime 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 row 36, the prime contractor should insert its overhead rate for work performed at the contractor's facility.
	(e) In row 37, the prime contractor should insert its overhead rate for work performed at the Client/Government's facility.
	(f) In row 39, the prime contractor should insert its G&A rate being applied.
	(g) for the subcontractor enter the fully burden cost including fixed fee associated with individual labor category for each year.
	(h) In row 61, the prime should insert the subcontractor handling charge, if any.
	(i) In row 64, the prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
	(j) In row 65, the prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
16	In column H, and then similarly for Columns J, L, N, P, R, T, V, X and Z:
	(a) for the prime contractor and the subcontractor enter the hours associated with individual labor category for CLIN XX00 (e.g., rows 5-44, 59-98, 101-140, 143-182, 185-224, 227-266, 269-308, 311-350, and 353-392). Also make sure you plug in the hours for columns J, L, N and so on.
	(b) In Cell H46, the prime contractor should insert 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 H47, the prime contractor should insert 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 H50, the prime contractor should insert the base its overhead rate is being applied to for work performed at the contractor's facility.
	(e) In Cell H51, the prime contractor should insert the base its overhead rate is being applied to for work performed at the Client/Government's facility.
	(f) In Cell H53, the prime contractor should insert the base its G&A rate is being applied to.
	(g) In Cell H398, the prime should insert the prime labor base its fixed fee rate is being applied to (excluding subcontractor labor).
	(h) In Cell H399, the prime should insert the subcontractor labor base its fixed fee rate is being applied to, if any.
	(i) Under Other Direct Costs, the prime contractor should insert the Travel, Material and NMCI by CLIN.
17	Insert similar "labor base" totals in columns K,N,Q and T in appropriate cells.
18	Column V should automatically calculate the total hours for all rows.
19	Column AD is a summation of the costs.
20	Other Direct Costs - Material and Travel estimates are supplied by the Government.
21	In row 80 enter the rate for material handling if it is being applied to Travel and Material. If not, applying a material handling should be left blank.
22	In row 81 enter the rate for G&A if it is being applied to Travel and Material. If not, applying a G&A should be left blank.
23	When submitting this file, the instructions may be deleted.

Base Period Cost Type

DO NOT TYPE IN ANY COLORED AREAS								Year 1			Year 2			Year 3			Year 4			Year 5	Total $
CPFF							CLIN			CLIN			CLIN			CLIN			CLIN
Services	SubContractor						hrs	subtotal		hrs	subtotal		hrs	subtotal		hrs	subtotal		hrs	subtotal
Government Labor Category	Proposed Category	site	sub	f/p	Employee Name	Rate		Labor	Rate		Labor	Rate		Labor	Rate		Labor	Rate		Labor
Project Manager						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
SR Warfare Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Warfare Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
JR Warfare Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
SR Operations Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Operations Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
JR Operations Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
SR Engineer						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Engineer						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
JR Engineer						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
SR Computer Scientist						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Computer Scientist						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
SR Logistics Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Logistics Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
JR Logistics Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
SR Tactical Systems Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Tactical Systems Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
SR Systems Administrator						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Systems Administrator						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Program Analyst						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Technical Writer						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Administrative Assistant						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
Mission Integrator						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
not comparable						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
not comparable						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
not comparable						$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0	0	$ - 0	$ - 0
subtotal							0	$ - 0		0	$ - 0		0	$ - 0		0	$ - 0		0	$ - 0	$ - 0
fringe fulltime						0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	$ - 0
fringe part time						0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Overhead
Contractor site						0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	$ - 0
Client site						0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	$ - 0
subtotal								$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
G&A						0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	$ - 0
COM						0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	0.00%	$ - 0	$ - 0	$ - 0
Subtotal Labor								$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Fee/Profit - subcontractor						0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0
Total Subcontractor Labor Cost Plus Fee/Profit								$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0

&LAttachment_P6_CLIN_Breakout_Spreadsheet&R(insert proposal number) &A &LKTR:(insert name)&C Source Selection Information See: FAR 2.101 & 3.104&RRFP:N00421-11-R-0045 &L&F &R(insert proposal number) &A &LKTR:(insert name)&CSource Selection Information See: FAR 3.104&RRFP:N00024-09-R-3185

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