Attachment 1-Cost Summary Template.xlsx

XLSX spreadsheet 33 KB Posted Jul 22, 2025

Attached to: Fiberglass Mast Fairings and Support Services
Solicitation number: N6449825R0511
Issued by: Department of the Navy Naval Sea Systems Command

About this file

Written by GovTribe AI · Jul 22, 2025

The attachment is a Cost Summary Template for a Cost-Plus Fixed Fee (CPFF) solicitation (N00024-0X-R-XXXX) that provides a detailed cost breakdown for labor and other direct costs across a multi-year contract. The template requires offerors to populate comprehensive cost elements including prime and subcontractor labor costs, with separate sections for direct and indirect labor, fixed fees, and other direct costs (ODCs). Key requirements include providing fully burdened bid rates for all proposed personnel, specifying labor categories, hours, locations, and pay types, and ensuring compliance with SeaPort-e IDIQ contract guidelines, such as maintaining pass-through costs below 8% and adhering to maximum fixed fee limitations. The template is designed to enable a detailed financial analysis of proposed contract costs, with sections for tracking labor rates, hours, and total contract pricing across base and option years.

View the file

Other files

File	Type	Posted
Statement of Work.pdf	PDF	Aug 20, 2025
Solicitation Amendment N6449825R05110001 SF 30.pdf	PDF	Aug 20, 2025
Attachment_2_Past_Performance.docx	DOCX document	Jul 22, 2025
SBPCD.xlsx	XLSX spreadsheet	Jul 22, 2025
SF 1449 - N6449825R0511.pdf	PDF	Jul 22, 2025
Direct Labor Substantiation .xls	XLS spreadsheet	Jul 22, 2025

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.

CPFF

SOLICITATION NO. N00024-0X-R-XXXX - ATTACHMENT 1

COST SUMMARY FORMAT

Prime Offeror Name:

Subcontractor Name (if applicable):

DCAA Point of Contact Information:

Total for All Years

Base Period

Option/Out Year 1

Option/Out Year 2

Option/Out Year 3

Option/Out Year 4

Cost Elements

Labor Category

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

Employee Name 1

Employee Name 2

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

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)

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

Other Direct Costs (ODCs)

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)		ERROR:#DIV/0!
Maximum Pass Through Allowed by SeaPort-e IDIQ Contract		8.00%

Fee Analysis - Total for All Years	Amount	Percent
Prime Contractor Labor Cost
Fixed Fee for Labor Performed by Prime Contractor		ERROR:#DIV/0!
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.

eCRAFT Fully Burdened Rates The contractor shall provide the Fully Burdened Bid Rates for all proposed personnel. The sum of the total dollars must reconcile to the 'Total Labor Cost Plus Fixed Fee (CPFF)' for "All Years" as proposed in the Cost Summary Worksheet tab.

Column Descriptions are provided below: (All data provided below must be consistent with data contained in the Cost Summary Worksheet tab)

Company: Prime Company Name or Subcontractor Company Name

Employee Name: List employee name or "TBD" if unknown

ECRAFT Labor Category Code: List eCRAFT labor category code, if known

Labor Category Description: List eCRAFT Labor Category Description

Location and Pay Type: A location and pay type must be indicated for each labor category. For Straight time hours, location is indicated as either Contractor site (K), Government site (G), or Contractor Telework (K-TW). For Overtime Hours, location is indicated as either Contrator Site (K-OT) or Government site (G-OT).

Hours: List the hours for each employee name/labor category for each year of the contract (including subcontractor employees)

Fully Burdened Labor Rate: Defined as direct labor PLUS all applicable indirects PLUS fee

Dollars: Hours TIMES Fully Burdened Labor Rate

					Base Year			Option/Out Year 1			Option/Out Year 2			Option/Out Year 3			Option/Out Year 4
Company	Employee Name	eCRAFT Labor Category Code	eCRAFT Labor Category Description	Location and Pay Type	Hours	Fully Burdened Labor Rate	Dollars	Hours	Fully Burdened Labor Rate	Dollars	Hours	Fully Burdened Labor Rate	Dollars	Hours	Fully Burdened Labor Rate	Dollars	Hours	Fully Burdened Labor Rate	Dollars
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
							$ - 0			$ - 0			$ - 0			$ - 0			$ - 0
		Total Labor Cost Plus Fixed Fee (CPFF)			0		$ - 0	0		$ - 0	0		$ - 0	0		$ - 0	0		$ - 0

File details come from the government source that posted it. Updated Jul 22, 2025.