C11_Attachment 4-Cost Summary Template.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Advanced Power Systems Federal contract opportunity
- Solicitation number
- N6449823R4011
About this file
This document is a cost summary template for solicitation number N6449823R4011 seeking advanced power systems. The template requires contractors to provide labor category details including hours, rates and dollars for both prime and subcontractor labor. Indirect costs for overhead, fringe benefits and G&A must also be included. The template calculates total labor costs plus fixed fee and other direct costs. Additional sections require contractors to provide eCRAFT fully burdened rates and ensure totals reconcile to the cost summary. The solicitation is issued by the Department of the Navy Naval Sea Systems Command for advanced power systems.
View the file
Other files for this federal contract opportunity
Show all 30
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
CPFF
| SOLICITATION NO. N00024-0X-R-XXXX - ATTACHMENT 1 |
| COST SUMMARY FORMAT |
| 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 | 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. |
eCRAFT Fully Burdened Rates The contractor shall provide the Fully Burdened Bid Rates for all proposed personnel. The sum of the total dollars must reconcile to the 'Total Labor Cost Plus Fixed Fee (CPFF)' for "All Years" as proposed in the Cost Summary Worksheet tab.
| Column Descriptions are provided below: (All data provided below must be consistent with data contained in the Cost Summary Worksheet tab) |
| ECRAFT Labor Category Code: List eCRAFT labor category code, if known |
| Labor Category Description: List eCRAFT Labor Category Description |
| Employee Name: List employee name or "TBD" if unknown |
| Company: Prime Company Name or Subcontractor Company Name |
| Location and Pay Type: A location and pay type must be indicated for each labor category. For Straight time hours, location is indicated as either Contractor site (KR-SITE) or Government site (GOVT-SITE). For Overtime Hours, location is indicated as either Contrator Site (K-OT) or Government site (G-OT). |
| Hours: List the total hours for each labor category for the life of the contract |
| Average Fully Burdened Labor Rate: Defined as direct labor PLUS all applicable indirects PLUS fee encompassing the entire period of performance of the contract |
| Dollars: Hours TIMES Fully Burdened Labor Rate |
| Average Rate for All Years | |||||||
| eCRAFT Labor Category Code | eCRAFT Labor Category Description | Employee Name | Company | Location and Pay Type | Hours | Average Fully Burdened Labor Rate | Dollars |
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| $ - 0 | |||||||
| Total Labor Cost Plus Fixed Fee (CPFF) | 0 | $ - 0 |
File details come from the government source that posted it. Updated .