Cost_Summary_Format.xls

XLS spreadsheet 52 KB Posted Sep 21, 2015

Attached to: Aegis Ballistic Missile Defense Engineering Services Federal contract opportunity
Solicitation number: N6893614R0025
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

From the source

Cost Summary Format

View the file

Other files for this federal contract opportunity

Other files attached to Aegis Ballistic Missile Defense Engineering Services, newest first.
File	Type	Posted
14-R-0025-0001_RFP_Solicitation_Amendment.docx	DOCX document	Oct 6, 2015
NAVAIR_Standard_Labor_Categories.pdf	PDF	Sep 21, 2015
Past_Performance_Survey.doc	DOC document	Sep 21, 2015
CPARS_Update_Questionnaire.doc	DOC document	Sep 21, 2015
14-R-0025_RFQ_Solicitation.docx	DOCX document	Sep 21, 2015
Government_Furnished_Property_Spreadsheet.xlsx	XLSX spreadsheet	Sep 21, 2015
Government_Furnished_Property_List.pdf	PDF	Sep 21, 2015
Contract_Data_Requirements_List.docx	DOCX document	Sep 21, 2015
Workforce_Qualifications_Spreadsheet.xls	XLS spreadsheet	Sep 21, 2015

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.

CPIF Cost Summary

SOLICITATION NO. N68936-14-R-0025 - ATTACHMENT 6

COST SUMMARY FORMAT

Prime Offeror Name:

Subcontractor Name (if applicable):

DCAA Point of Contact Information:

Key

Personnel

Total for All Years

Base Period

Year 1

Year 2

Year 3

Year 4

Cost Elements

Labor Category

Y / N

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Rate

Hours

Amount

Prime Contractor Labor Cost

Prime Contractor Direct Labor

Task 1

Employee Name 1

Employee Name 2

Employee Name 3

Employee Name 4

Employee Name 5

Employee Name 6

Employee Name 7

Employee Name 8

Etc.

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

Task 1

Subcontractor 1

Subcontractor 2

Etc.

Task 2

Subcontractor 1

Subcontractor 2

Etc.

Task 3

Subcontractor 1

Subcontractor 2

Etc.

Task 4

Subcontractor 1

Subcontractor 2

Etc.

Task 5

Subcontractor 1

Subcontractor 2

Etc.

Task 6

Subcontractor 1

Subcontractor 2

Etc.

Task 7

Subcontractor 1

Subcontractor 2

Etc.

Task 8

Subcontractor 1

Subcontractor 2

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)

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 Fee

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

Total ODCs

Total CPFF all CLINs (Labor and ODCs)

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)

Supporting Cost Data Summary

SUPPORTING COST DATA
Direct Labor:	Actual Current Labor Rate	Proposed Base Period Labor Rate	Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCAA recommended rates, if known.
Employee Name	$	$
Employee Name	$	$
Employee Name	$	$
Indirect Rates:	Current Rate	Proposed Base Rate	Subject to FPRA? (Yes/No) Reason for difference between current rates and proposed rates. Reason for difference between proposed rates and DCAA recommended rates, if known.
Fringe
Overhead
G&A
Other

Indirect Rate Support

Sample Indirect Rate Supporting Documentation
	Budget	Actual Expenses
Overhead Expense	2011	2010	2009	2008
Payroll Taxes	$ 110,000	$ 93,000	$ 90,000	$ 85,000
Vacation	$ 50,000	$ 46,000	$ 43,000	$ 42,000
Holiday	$ 40,000	$ 40,000	$ 39,000	$ 38,500
Sick Leave	$ 10,000	$ 9,000	$ 8,000	$ 7,000
Pensions	$ 200,000	$ 175,000	$ 165,000	$ 155,000
Office Equipment	$ 5,000	$ 6,000	$ 65,000	$ 3,000
Depreciation	$ 4,000	$ 1,000	$ 4,000	$ 2,000
Travel	$ 40,000	$ 35,000	$ 33,000	$ 33,000
Reproduction	$ 10,000	$ 9,800	$ 9,700	$ 9,600
Rent	$ 130,000	$ 82,000	$ 75,000	$ 68,000
Advertising	$ 55,000	$ 44,000	$ 50,000	$ 42,000
Insurance	$ 48,000	$ 46,000	$ 44,000	$ 42,000
Telephone	$ 12,000	$ 12,000	$ 11,500	$ 10,000
Total Pool	$ 714,000	$ 598,800	$ 637,200	$ 537,100
Less Unallowable Costs
Entertainment	$ 6,000	$ 4,000	$ 1,000	$ 3,000
Net Allowable Costs	$ 708,000	$ 594,800	$ 636,200	$ 534,100
Allocation Base
Direct Labor	$ 1,895,500	$ 1,756,200	$ 1,650,000	$ 1,530,000
Overhead Rate	37.35%	33.87%	38.56%	34.91%
*Contributing Government Contracts	Expiration Date	Value of Contracts
N000XX-XX-X-00XX	6/1/11
N000XX-XX-X-00XX	9/1/12
N000XX-XX-X-00XX	8/1/10
* When developing your percentage, these are the contracts contributing
to development of the percentage.

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