Attachment 4_Cost_Proposal_Spreadsheet_N0016724R0020.xlsx
XLSX spreadsheet 26 KB Posted
- Attached to
- COLUMBIA Class Ropeguard and Duct ICCP Kits
- Solicitation number
- N00167-24-R-0020
About this file
This document is a Cost Proposal Spreadsheet for Solicitation No. N0016724R0020 issued by the Naval Surface Warfare Center Carderock Division (NSWCCD). The solicitation is for the COLUMBIA Class Ropeguard and Duct ICCP Kits requirement. The Government anticipates awarding a single, hybrid Cost Plus Fixed Fee (CPFF) and Cost Plus Incentive Fee (CPIF) contract with a 5-year ordering period.
The spreadsheet contains line items for prime contractor and subcontractor labor, as well as other direct costs. It includes sections for the base period and 4 option years. Key details in the spreadsheet include labor categories, rates, hours, and costs, as well as the total proposed labor cost, fixed fee, and pass-through analysis. There are also comments indicating that eCRAFT labor categories may be required and that the solicitation has both fixed fee and incentive fee contract line items.
View the file
Other files
Show all 14
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. N0016724R0020 ATTACHMENT X |
| 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 |
tc={94528E06-1545-4563-9262-8E33AF4DAC56}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
There are only 3 option years Cost Elements Company Labor Category eCRAFT Labor Category tc={4FEF6FEE-3E0D-4080-A376-166552C6522B}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
@Bazensky, Lina K CIV USN NSWC CRD BDA MD (USA) @Johnson, Kiersten M CIV USN NSWC CRD BDA MD (USA) Is this going to be in eCRAFT? If so need to add eCRAFT language to Section C Reply:
| @Maschmeyer, Justin R CIV USN NSWC CRD BDA MD (USA) ; I do not believe so... we recently had a discussion that eCRAFT is not appropriate for contract actions that are primarily supply. We will confirm; however, this was a lengthy discussion in which an exemption was provided on efforts like this one | 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 tc={368EFCF2-4D53-4912-AD48-AFBBE3653328}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
There are fixed fee and incentive fee CLINs on the solicitation tc={94528E06-1545-4563-9262-8E33AF4DAC56}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
There are only 3 option years tc={4FEF6FEE-3E0D-4080-A376-166552C6522B}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
@Bazensky, Lina K CIV USN NSWC CRD BDA MD (USA) @Johnson, Kiersten M CIV USN NSWC CRD BDA MD (USA) Is this going to be in eCRAFT? If so need to add eCRAFT language to Section C Reply:
| @Maschmeyer, Justin R CIV USN NSWC CRD BDA MD (USA) ; I do not believe so... we recently had a discussion that eCRAFT is not appropriate for contract actions that are primarily supply. We will confirm; however, this was a lengthy discussion in which an exemption was provided on efforts like this one | 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 .