J.6 - Cost Proposal Spreadsheet (Example).xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- H30 Engineering Services
- Solicitation number
- N0017826R3017
About this file
This is a cost proposal spreadsheet template for a federal contract solicitation. The template is designed for cost-plus-fixed-fee (CPFF) proposals submitted under the SeaPort-e IDIQ contract vehicle for Naval Sea Systems Command solicitation N0017826R3017, which concerns H30 Engineering Services at the Naval Surface Warfare Center Dahlgren Division.
The spreadsheet structure requires offerors to itemize labor costs across a base period and four option years, broken down by cost elements including prime contractor direct labor (organized by employee and labor category with hourly rates and amounts), indirect labor costs (overhead, fringe benefits, and G&A), subcontractor labor costs and fees, and other direct costs (ODCs). The template includes sections for calculating fixed fees for both prime contractor labor and subcontractor labor, with specific compliance requirements: subcontractor pass-through costs (excluding fee) are capped at 8 percent of total costs, and prime contractor fixed fees for labor performed are subject to maximum thresholds established under the SeaPort-e IDIQ contract. Additionally, the template distinguishes between prime contractor fees on subcontractor pricing as cost elements in Section B versus fee elements in pass-through analysis, requiring offerors to carefully allocate these components according to government guidelines outlined in the Savings Clause of the underlying MAC.
View the file
Other files
Show all 12
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. N0017826R3017 - ATTACHMENT J.6 |
| 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. |
File details come from the government source that posted it. Updated .