Attachment S-1 - Cost Proposal Spreadsheet.xlsx
XLSX spreadsheet 18 KB Posted
- Attached to
- Solicitation N5523626R0007 for Southwest Regional Maintenance Center HME FTA Follow On Engineering Services
- Solicitation number
- N5523626R0007
About this file
This is a Cost Proposal Spreadsheet template for Solicitation No. N5523626R0007, a U.S. Navy follow-on engineering services contract for Hull, Mechanical, and Electrical (HM&E) Fleet Technical Assistance (FTA) support at the Southwest Regional Maintenance Center (SWRMC). The spreadsheet is designed for cost-plus-fixed-fee (CPFF) proposals under the SeaPort-e IDIQ contract vehicle.
The template requires offerors to detail prime contractor labor costs organized by employee name and eCRAFT labor categories, with hours and rates for a base period plus four option years. Cost structure includes direct labor, indirect costs (overhead, fringe benefits, and G&A), subcontractor labor costs and fees, pass-through costs, other direct costs (ODCs), and fixed fees. The spreadsheet incorporates compliance controls, including a maximum 8% pass-through fee cap and maximum fixed fee calculations, with specific delineation between subcontractor costs and fees to ensure proper cost and fee categorization as outlined in Section H of the MACs (Multiple Award Contracts) and Section B requirements. Offerors must identify DCAA points of contact and clearly segregate prime contractor fee for labor performed versus prime contractor fee for subcontractor labor to align with pass-through cost analysis requirements.
View the file
Other files
Show all 28
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
| HM&E FTA SUPPORT SOLICITATION NO. N5523626R0007 - ATTACHMENT S-1 |
| 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 .