Attachment_P6_-_CLIN_Breakout_Spreadsheet.xls

XLS spreadsheet 165 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

CLIN 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_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_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
Attachment_P7_-_CLIN_Breakout_Subcontractor.xls	XLS spreadsheet	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

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 for Tab 1

	Instructions
	Contractor:
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 (CPFF) (Tab 1)

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	Contractor						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
Subcontractors							hrs	$		hrs	$		hrs	$		hrs	$		hrs	$	Total $
Sub: 1:
sub total on Sub 1							0			0			0			0			0		$ - 0
Sub: 2:
sub total on Sub 2							0			0			0			0			0		$ - 0
Sub: 3
sub total on Sub 3							0			0			0			0			0		$ - 0
Sub: 4:
sub total on Sub 4							0			0			0			0			0		$ - 0
Sub: 5:
sub total on Sub 5							0			0			0			0			0		$ - 0
Sub: 6:
sub total on Sub 6							0			0			0			0			0		$ - 0
Sub: 7
sub total on Sub 7							0			0			0			0			0		$ - 0
Sub: 8:
sub total on Sub 8							0			0			0			0			0		$ - 0
Total of all Subcontractors							0	$ - 0		0	$ - 0		0	$ - 0		0	$ - 0		0	$ - 0	$ - 0
subcontractor handling						0.00%		$ - 0	0.00%		$ - 0	0.00%		$ - 0	0.00%		$ - 0	0.00%		$ - 0	$ - 0
subtotal								$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Fee/Profit - prime						0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0
prime's fee/profit on subcontractor						0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	0.0%	$ - 0	$ - 0	$ - 0
Fee/Profit Pool								$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Total Cost								$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Fee/Profit Pool								$ - 0			$ - 0			$ - 0			$ - 0			$ - 0	$ - 0
Total Labor and Subcontractor Cost Plus Fee/Profit							-0	$ - 0		-0	$ - 0		-0	$ - 0		-0	$ - 0		-0	$ - 0	$ - 0
Other Direct Costs
								Subtotal			Subtotal			Subtotal			Subtotal			Subtotal	Subtotal
								(description)			(description)			(description)			(description)			(description)	(description)
Travel (CLIN 0003)								$ 150,000.00			$ 150,000.00			$ 150,000.00			$ 150,000.00			$ 150,000.00	$ 750,000.00
Material (CLIN 0004)								$ 100,000.00			$ 100,000.00			$ 100,000.00			$ 100,000.00			$ 100,000.00	$ 500,000.00
ODC subtotal								$ 250,000.00			$ 250,000.00			$ 250,000.00			$ 250,000.00			$ 250,000.00	$ 1,250,000.00
material handling						0.00%		$ - 0	0.00%		$ - 0	0.00%		$ - 0	0.00%		$ - 0	0.00%		$ - 0	$ - 0
G&A on ODC						0.00%		$ - 0	0.00%		$ - 0	0.00%		$ - 0	0.00%		$ - 0	0.00%		$ - 0	$ - 0
Total ODC								$ 250,000.00			$ 250,000.00			$ 250,000.00			$ 250,000.00			$ 250,000.00	$ 1,250,000.00
Grand Total Services & ODC								$ 250,000.00			$ 250,000.00			$ 250,000.00			$ 250,000.00			$ 250,000.00	$ 1,250,000.00

&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

Instructions for Tab 2 Instructions to Prime Contractors for completing Attachment P8 Fully Burdened Labor Rates N00421-15-R-0014

COLUMN	COLUMN HEADING	DESCRIPTION OF DATA UNDER THIS COLUMN HEADING
A	Proposed Labor Category (Furnished by Government)	Enter the Proposed Labor Category, as recorded in the Prime or Subcontractor's accounting system, that correlates to each of the Government solication Labor Category on that row. Spell and format entry the same every time it is used on the template (for example, when it relates to the Prime Offeror's rates on one row and to a Subcontractor's rates on another row). If the Offeror determines that no personnel will be proposed to perform work defined by one of the Government Estimate Labor Categories listed, enter "NA".
B	Individual Designator*	For each individual Contractor employee proposed; enter a different Identifing title in the form of FTE## (e.g. FTE01, FTE02, etc.) for each individual to distinguish them from one another. Do not enter the individual's name into the template; rather, provide that information separately in accordance with the requirements of NAVAIR Clause 5252.232-9529. Enter one FTE# for EACH indiviual proposed. (The number of FTE's must coordinate with the submitted P-6 for evaluation purposes.)
C	Government Functional Area Labor Rate Category (Furnished by Government)	Enter the corresponding Funtional Labor Catagory related to the Proposed Labor Category from Column A.
D-F	Proposed Fully-Burdened Labor Rate per Hour, per Labor Category	Enter the Fully-Burdened Labor Rate per Hour proposed for the applicable performance period (e.g. Base or Year_#) for personnel associated with the Proposed Labor Category. Enter numbers only, in U.S. Dollar format $###.## rounded to the nearest cent. Fully-Burdened Labor Rates shall include fringe, overhead, G&A, subcontractor pass-through rate, and fee on total cost, but should not include Fully-Burdened Other Direct Costs (ODCs) such as Materials, Travel, and Cost of Money costs.
I-M	Government Functional Area Labor Rate per Hour, per Functional Labor Rate Category	Enter the Fully-Burdened Labor Rate per Hour proposed for the applicable Government Functional Labor Rate Category associated with the Proposed Labor Category. Enter numbers only, in U.S. Dollar format $###.## rounded to the nearest cent. (SEE TAB Functional Labor Hrly Tripwire for reference)

Burdened Rates (CPFF) (Tab 2)

ATTACHMENT P8	Individual Designator*	Functional Area Labor Category	Proposed Fully Burdened Rates					Fully Burdened Functional Labor Rate Tripwire
Proposed Labor Category			Base	Year 1	Year 2	Year 3	Year 4	Base	Year 1	Year 2	Year 3	Year 4
Program Manager		Program Management						$135.00	$135.00	$135.00	$135.00	$135.00
SR. Warfare Analyst		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
Warfare Analyst		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
JR. Warfare Analyst		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
SR Operations Analyst		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
Operations Analyst		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
JR Operations Analyst		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
SR Engineer		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
Engineer		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
JR Engineer		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
SR Computer Scientist		IT						$130.00	$130.00	$130.00	$130.00	$130.00
Computer Scientist		IT						$130.00	$130.00	$130.00	$130.00	$130.00
SR Logistics Analyst		Logistics						$110.00	$110.00	$110.00	$110.00	$110.00
Logistics Analyst		Logistics						$110.00	$110.00	$110.00	$110.00	$110.00
JR Logistics Analyst		Logistics						$110.00	$110.00	$110.00	$110.00	$110.00
SR Tactical Systems Analyst		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
Tactical Systems Analyst		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
SR Systems Administrator		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
Systems Administrator		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00
Program Analyst		Program Management						$135.00	$135.00	$135.00	$135.00	$135.00
Technical Writer		Logistics						$110.00	$110.00	$110.00	$110.00	$110.00
Administrative Assistant		Admin						$55.00	$55.00	$55.00	$55.00	$55.00
Mission Integrator		Engineer						$140.00	$140.00	$140.00	$140.00	$140.00

&RAttachment P6 N00421-15-R-0014

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