N3904026R0002 Attachment 3 Cost_Proposal_Spreadsheet.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- Receipt Inspectors
- Solicitation number
- N3904026R0003
About this file
This is a Cost Proposal Spreadsheet template for solicitation N3904026R0002, designed for SeaPort-e IDIQ contract holders to submit pricing proposals for Receipt Inspector services at Portsmouth Naval Shipyard. The spreadsheet is structured to capture comprehensive cost data across a base period and up to four option years, organized by cost elements including prime contractor labor, subcontractor labor, other direct costs (ODCs), and fees.
The template requires offerors to detail prime contractor direct labor costs by employee and labor category with associated hourly rates, indirect labor costs (overhead, fringe benefits, and G&A), and subcontractor proposed costs with fee. Fee analysis is limited to a maximum fixed fee percentage for labor performed by the prime contractor, while pass-through costs (subcontractor work and associated prime contractor fees) are capped at 8 percent per SeaPort-e IDIQ contract requirements. The spreadsheet includes sections for Other Direct Costs with any applicable adders and a consolidated total Cost-Plus-Fixed-Fee (CPFF) calculation across all CLINs. This is a template document and does not contain actual pricing, award information, or response deadlines.
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. N3904026R0002- ATTACHMENT 4 |
| 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 .