Att 3_Cost_Proposal_Spreadsheet.xlsx
XLSX spreadsheet 28 KB Posted
- Solicitation number
- N0017826R0010
About this file
This is a Cost Proposal Spreadsheet template for Solicitation No. N0017827R4402 (Draft Solicitation No. N0017826R0010), issued by the Naval Surface Warfare Center, Dahlgren Division (NSWCDD) under the Department of the Navy Naval Sea Systems Command. The spreadsheet serves as Attachment J.3 and is designed to capture comprehensive cost data for prime contractors and subcontractors responding to this requirements contract.
The template is structured to accommodate a base period of four years plus five option years, with detailed cost breakdowns across multiple categories. Prime contractor cost elements include direct labor (by individual employee), indirect labor (overhead, fringe benefits, G&A), materials, and other direct costs (ODCs). The spreadsheet incorporates subcontractor labor costs and pass-through fees, with designated fields for surge labor and related fixed fees. The template includes analytical sections for pass-through cost analysis and fee analysis, with built-in calculations to compare proposed fees against maximum rates allowed under the SeaPort-e IDIQ contract vehicle. The document specifies that prime contractor fee on subcontractor pricing must be reported in the fee column rather than the cost column per Section B requirements of the applicable MAC (Multiple Award Contract). This is a blank template without completed cost data.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SAM_Q_and_A_Updated_6.4.2026.xlsx | XLSX spreadsheet | |
| SAM_Questions_and_answers.xlsx | XLSX spreadsheet | |
| Solicitation Amendment N0017826R00100001 SF 30.pdf | ||
| Solicitation Amendment - N0017826R00100001.pdf | ||
| Contract Data Requirements List_DD1423.pdf | ||
| DO 0002 SOW Final.pdf | ||
| DO 0001 SOW.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Cost Proposal Spreadsheet
| SOLICITATION NO. N0017827R4402 - ATTACHMENT J.3 |
| COST PROPOSAL SPREADSHEEET |
| Prime Offeror Name: | |||||||||||||||||||||||||||||||||||
| Subcontractor Name (if applicable): | |||||||||||||||||||||||||||||||||||
| DCAA Point of Contact Information: | |||||||||||||||||||||||||||||||||||
| KEY? | Site | Total for All Years | Base Period Year 1 | Base Period Year 2 | Base Period Year 3 | Base Period Year 4 | Base Period Year 4 | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | Option Year 5 | |||||||||||||||||||||||
| Cost Elements | Labor Category | Y/N | GOV/CTR | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | 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)
Materials
| Other Direct Costs |
| Other Direct Costs (ODCs) |
| Any adders to ODCs such as G&A (cost only - no fee) |
| Total ODCs |
Total CPFF (Labor, Materials, and ODCs)
| Surge Labor |
| Fixed Fee on Surge Labor |
| Surge Total Labor Plus Fixed Fee |
| Surge ODCs |
| Any Adders to Surge ODCs |
| Surge Total CPFF |
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 | N/A |
| 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 B Maximum Rates 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. |
File details come from the government source that posted it. Updated .