Attachment 6 Cost_Summary Template.xls
XLS spreadsheet 56 KB Posted
- Attached to
- Alteration and Installation Team Federal contract opportunity
- Solicitation number
- N6339422R0003
About this file
This document contains a cost summary template and details of a federal contract solicitation for alteration and installation team support services. The cost summary template provides a standardized format for offerors to submit proposed labor rates and costs for prime contractors and any subcontractors. It includes tables to itemize direct and indirect labor costs, fixed fees, other direct costs, and pass-through amounts. It also requires supporting cost data such as current and proposed labor rates, indirect rate calculations and documentation. The federal contract solicitation seeks proposals to provide ship self-defense combat systems installation services for aircraft carriers, cruisers, destroyers and other naval vessels. Offerors can find more details on the opportunity at the provided website. The work includes planning, coordinating and performing combat system installations and upgrades for both existing vessels and experimental technologies. The issuing agency is the Naval Sea Systems Command within the Department of the Navy.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| N6339422R0003_0003 Amendment.pdf | ||
| N6339422R0003_0003 Conformed.pdf | ||
| N6339422R0003 QandA 12082021.pdf | ||
| N6339422R0003 Amendment 0002 Mod Copy 12082021.pdf | ||
| N6339422R0003 Amendment 0002 Conformed Copy 12082021.pdf | ||
| N6339422R0003_0001 Amendment.pdf | ||
| N6339422R0003_0001 Conformed.pdf | ||
| N6339422R0003_QandA_ 11292021.pdf | ||
| C4(a)_N6339422R0003_Solicitation_ 11182021.pdf | ||
| Attachment 8 Mandatory Staffing Plan.pdf | ||
| Attachment 7 Staffing Plan Matrix.xls | XLS spreadsheet | |
| Attachment 4 - BLS.pdf | ||
| Attachment 3 Past Performance Information Form.docx | DOCX document | |
| Attachment 9 Ventura County Wage Determination.pdf | ||
| Attachment 1 _DD 254.pdf | ||
| Exhibit A - Contract Data Requirements Lists (CDRLs).pdf | ||
| Attachment 2 QASP.pdf | ||
| Attachment 5 - Sample Task and Scenario.pdf | ||
| Attachment 6 Cost_Summary Template.xls | XLS spreadsheet |
Show all 19
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
Cost Summary Format
| ATTACHMENT 6 | ||||||||||||||||||
| SOLICITATION NO. N6339422R0003 | ||||||||||||||||||
| COST SUMMARY FORMAT | ||||||||||||||||||
| Prime Offeror Name: | ||||||||||||||||||
| Subcontractor Name (if applicable): | ||||||||||||||||||
| DCAA Point of Contact Information: | ||||||||||||||||||
| DCMA Point of Contact Information: | Total for All Years | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | Option Year 5 | ||||||||||||
| Cost Elements | Task Order Labor Cat. | 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 Prime 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 Labor 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 CLINS | ||||||||||||||||||
| Prime Contractor ODCs | ||||||||||||||||||
| Travel | ||||||||||||||||||
| Other Direct Costs (ODCs) | ||||||||||||||||||
| Prime Burdens on Prime ODCs | ||||||||||||||||||
| Material Handling | ||||||||||||||||||
| G&A | ||||||||||||||||||
| Other (specify each separately) | ||||||||||||||||||
| Subtotal Burden on Prime ODCs | ||||||||||||||||||
| Subcontractor ODCs | ||||||||||||||||||
| Travel | ||||||||||||||||||
| Subcontractor 1 | ||||||||||||||||||
| Subcontractor 2 | ||||||||||||||||||
| Etc. | ||||||||||||||||||
| Subtotal Subcontractor Travel | ||||||||||||||||||
| Other Direct Costs | ||||||||||||||||||
| Subcontractor 1 | ||||||||||||||||||
| Subcontractor 2 | ||||||||||||||||||
| Etc. | ||||||||||||||||||
| Subtotal Subcontractor Other Direct Costs | ||||||||||||||||||
| Total Subcontractor Travel and Other Direct Costs | ||||||||||||||||||
| Prime Burdens on Subcontractor ODCs | ||||||||||||||||||
| Total Other Direct Cost CLINs | ||||||||||||||||||
| 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) | 0% | |||||||||||||||||
| Fee Analysis - Total for All Years | Amount | Percent | ||||||||||||||||
| Prime Contractor Labor Cost | ||||||||||||||||||
| Fixed Fee for Labor Performed by Prime Contractor | 0% |
Supporting Cost Data
| SUPPORTING COST DATA | ||||
| Direct Labor: | Actual Current Labor Rate | Effective Date of Current Rate | Proposed Base Period Labor Rate | Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCAA recommended rates, if known. |
| Employee Name | $ | $ | ||
| Employee Name | $ | $ | ||
| Employee Name | $ | $ | ||
| Indirect Rates: | Current Rate | Proposed Base Rate | Subject to FPRA? (Yes/No) Reason for difference between current rates and proposed rates. Reason for difference between proposed rates and DCAA recommended rates, if known. | |
| Fringe | ||||
| Overhead | ||||
| G&A | ||||
| Other (list) |
Indirect Rate Support
| Sample Indirect Rate Supporting Documentation | ||||
| Budget | Actual Expenses | |||
| Overhead Expense | 2018 | 2017 | XXXX | XXXX |
| Payroll Taxes | $ 110,000 | $ 93,000 | $ 90,000 | $ 85,000 |
| Vacation | $ 50,000 | $ 46,000 | $ 43,000 | $ 42,000 |
| Holiday | $ 40,000 | $ 40,000 | $ 39,000 | $ 38,500 |
| Sick Leave | $ 10,000 | $ 9,000 | $ 8,000 | $ 7,000 |
| Pensions | $ 200,000 | $ 175,000 | $ 165,000 | $ 155,000 |
| Office Equipment | $ 5,000 | $ 6,000 | $ 65,000 | $ 3,000 |
| Depreciation | $ 4,000 | $ 1,000 | $ 4,000 | $ 2,000 |
| Travel | $ 40,000 | $ 35,000 | $ 33,000 | $ 33,000 |
| Reproduction | $ 10,000 | $ 9,800 | $ 9,700 | $ 9,600 |
| Rent | $ 130,000 | $ 82,000 | $ 75,000 | $ 68,000 |
| Advertising | $ 55,000 | $ 44,000 | $ 50,000 | $ 42,000 |
| Insurance | $ 48,000 | $ 46,000 | $ 44,000 | $ 42,000 |
| Telephone | $ 12,000 | $ 12,000 | $ 11,500 | $ 10,000 |
| Total Pool | $ 714,000 | $ 598,800 | $ 637,200 | $ 537,100 |
| Less Unallowable Costs | ||||
| Entertainment | $ 6,000 | $ 4,000 | $ 1,000 | $ 3,000 |
| Net Allowable Costs | $ 708,000 | $ 594,800 | $ 636,200 | $ 534,100 |
| Allocation Base | ||||
| Direct Labor | $ 1,895,500 | $ 1,756,200 | $ 1,650,000 | $ 1,530,000 |
| Overhead Rate | 37.35% | 33.87% | 38.56% | 34.91% |
| *Contributing Government Contracts | Expiration Date | Value of Contracts | ||
| N000XX-XX-X-00XX | 6/1/20XX | |||
| N000XX-XX-X-00XX | 9/1/20XX | |||
| N000XX-XX-X-00XX | 8/1/20XX | |||
| * When developing your percentage, these are the contracts contributing | ||||
| to development of the percentage. |
File details come from the government source that posted it. Updated .