Attachment_5_Cost_Proposal_Spreadsheet.xlsx
XLSX spreadsheet 29 KB Posted
- Solicitation number
- N0017426R1021
About this file
This is a cost proposal spreadsheet template for Solicitation No. N0017426R0121, designed for use under the SeaPort-e IDIQ contract vehicle. The spreadsheet is structured to capture detailed pricing information across a base period and four option years, with separate sections for prime contractor and subcontractor labor costs, indirect costs, other direct costs (ODCs), and fee calculations.
The template requires offerors to provide labor cost details by company labor category and eCRAFT labor category, including hours, rates, and extended amounts for each contract period. Prime contractor costs include direct labor, overhead, fringe benefits, and G&A, while subcontractor costs are tracked separately with pass-through analysis. The spreadsheet enforces compliance with SeaPort-e IDIQ constraints, including a maximum pass-through allowance of 8 percent and a maximum fixed fee calculation for labor performed by the prime contractor. Additional sections accommodate fixed fees, other direct costs with potential G&A adders, and comprehensive fee analysis. The template includes a compatibility report noting that label information requires Excel 2007 or later versions to preserve full functionality.
View the file
Other files
Show all 15
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. N0017426R0121 - ATTACHMENT 5 |
| COST PROPOSAL SPREADSHEEET |
| Prime Offeror Name: | |||||||||||||||||||
| Subcontractor Name (if applicable): | |||||||||||||||||||
| DCAA Point of Contact Information: | |||||||||||||||||||
| Total for All Years | Base Period | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||
| Cost Elements | Company Labor Category | eCRAFT 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. |
Sheet1
| Compatibility Report for Attachment_5_Cost_Proposal_Spreadsheet.xlsx |
| Run on 8/13/2026 13:26 |
If the workbook is saved in an earlier file format or opened in an earlier version of Microsoft Excel, the listed features will not be available.
Significant loss of functionality # of occurrences Version
| This workbook has label information that will be lost or not visible if the file is saved as an earlier Excel format. | 1 | Excel 97-2003 |
| Excel 2007 | ||
| Excel 2010 | ||
| Excel 2013 | ||
| Excel 2016 | ||
| Excel 2019 |
File details come from the government source that posted it. Updated .