Attachment_L-1_Cost_Summary_Spreadsheet.xls

XLS spreadsheet 63 KB Posted May 10, 2018

Attached to: Electronic Warfare Integrated Laboratory
Solicitation number: N6893618R0015
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

From the source

Attachment L-1 Cost Summary Spreadsheet

View the file

Other files

File	Type	Posted
Updated_L-2.xls	XLS spreadsheet	Jun 4, 2018
18R0015__Amended_Solicitation_2.doc	DOC document	Jun 4, 2018
18R0015_Solicitation_Amendment.docx	DOCX document	May 24, 2018
Attachment_L-2_Annual_Fully_Burdened_Labor.xls	XLS spreadsheet	May 24, 2018
Exhibit_A_-_CDRLs.pdf	PDF	May 10, 2018
Attachment_L-3_Past_Performance_Information_Form.pdf	PDF	May 10, 2018
18R0015_Solicitation.doc	DOC document	May 10, 2018
Attachment_L-2_Annual_Fully_Burdened_Labor.xls	XLS spreadsheet	May 10, 2018
Attachment_L-4_CPAQ.pdf	PDF	May 10, 2018

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 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.
4	Only one worksheet shall be prepared for the entire period of performance (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.
	26
	86
	2

&LSection L, Attachment L-4 &RN68936-16-R-0030

Cost Summary Spreadsheet

COST SUMMARY SPREADSHEET

Prime Offeror Name:

Subcontractor Name (if applicable):

Year 1

Year 2

Year 3

Year 4

Year 5

Extra

Total for All Periods

Cost Elements

Government Labor Category

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

General and Operations Manager

Acquisition Specialist/Management Analyst

Information Management and Technology Analyst

System Administrator

Business Systems Analyst

Computer Scientist

Help Desk Support Specialist

Systems Specialist

Informational Management and Technology Analyst

Computer Scientist

Test Engineer

Systems Specialist

Financial Manager

Data Management Specialist

Drafter/CAD Operator

Administrative Assistant

Total Direct Labor Cost

Prime Contractor Indirect Labor Cost

Overhead

Fringe Benefits

G&A

Total Indirect Labor Cost

Total Direct and Indirect Labor cost

COM

Total Prime Contractor Labor Cost

Subcontractor Labor Cost

Subcontractor proposed cost and fee

Acquisition Specialist/Management Analyst

Information Management and Technology Analyst

Etc.

Total proposed subcontractor labor cost and fee

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

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)

Other Direct Costs

Travel

Material

Any adders to ODCs such as G&A (cost only - no fee)

Total ODCs

Total CPFF all CLINs (Labor and ODCs)

Grand Total of CPFF all CLINs

Pass Through Analysis - Total for All Years

Amount

Percent

Subcontractor proposed cost and fee

Pass Through Amount (not including fee)

Prime Contractor Fee for Subcontractor Labor *

Total Pass Through Amount (including fee)

Maximum Pass Through Allowed by SeaPort-e IDIQ Contract

Fee Analysis - Total for All Years

Amount

Percent

Prime Contractor Labor Cost

Fixed Fee for Labor Performed by Prime Contractor

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.

&LSection L, Attachment L-1 &CCost Summary Spreadsheet Breakout &RN68936-18-R-0015 &LKTR: (name)&C3 &RSource Selection Information - See: FAR 2.101 and 3.104

Summary

CLIN Summary Sheet
CLINS	CLIN Description	Total Hours	Total Cost	Total Fixed Fee	Total Value $
0001
0002
0003
X005
Total

&LSection L, Attachment L-4 &CSummary Tab&RN68936-16-R-0030 &C4

File details come from the government source that posted it.