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 for the solicitation N6339422R0003 to obtain alteration and installation team support services. Key details include the scope of work involves planning and coordinating installation of ship self-defense combat systems in aircraft carriers and other strike group units. The template requires offerors to provide cost and pricing details such as direct labor hours and rates by task for prime contractor and subcontractor personnel, indirect rates including overhead and G&A, other direct costs and fees. Additional requirements include supporting cost data for direct labor rates, indirect rates and contributing government contracts as well as a brief narrative to support the indirect rate proposal.
The related federal contract opportunity provides additional context, seeking these alteration and installation team support services from the Department of the Navy Naval Sea Systems Command for ship self-defense combat systems. The work involves installations and upgrades on aircraft carriers, cruisers, destroyers and other vessels as well as the Self Defense Test Ship.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| N6339422R0003_0003 Conformed.pdf | ||
| N6339422R0003_0003 Amendment.pdf | ||
| N6339422R0003 QandA 12082021.pdf | ||
| N6339422R0003 Amendment 0002 Mod Copy 12082021.pdf | ||
| N6339422R0003 Amendment 0002 Conformed Copy 12082021.pdf | ||
| N6339422R0003_0001 Conformed.pdf | ||
| N6339422R0003_QandA_ 11292021.pdf | ||
| Attachment 6 Cost_Summary Template.xls | XLS spreadsheet | |
| N6339422R0003_0001 Amendment.pdf | ||
| C4(a)_N6339422R0003_Solicitation_ 11182021.pdf | ||
| Attachment 8 Mandatory Staffing Plan.pdf | ||
| Attachment 7 Staffing Plan Matrix.xls | XLS spreadsheet | |
| Exhibit A - Contract Data Requirements Lists (CDRLs).pdf | ||
| Attachment 2 QASP.pdf | ||
| Attachment 5 - Sample Task and Scenario.pdf | ||
| Attachment 9 Ventura County Wage Determination.pdf | ||
| Attachment 1 _DD 254.pdf | ||
| Attachment 4 - BLS.pdf | ||
| Attachment 3 Past Performance Information Form.docx | DOCX document |
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
| SOLICITATION NO. N6339422R0003 - ATTACHMENT 6 | |||||||||||||||||||
| COST SUMMARY FORMAT | |||||||||||||||||||
| Prime Offeror Name: | |||||||||||||||||||
| Subcontractor Name (if applicable): | |||||||||||||||||||
| DCAA Point of Contact Information: | Key | ||||||||||||||||||
| Personnel | Total for All Years | Base Period | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | |||||||||||||
| Cost Elements | Labor Category | Y / N | 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 | |||||||||||||||||||
| Task 1 | |||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 2 | |||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 3 | |||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 4 | |||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 5 | |||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 6 | |||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 7 | |||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 8 | |||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Surge Tasks 1 - 8 | |||||||||||||||||||
| 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 | |||||||||||||||||||
| Task 1 | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 2 | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 3 | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 4 | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 5 | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 6 | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 7 | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Task 8 | |||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||
| Etc. | |||||||||||||||||||
| Subcontractor Surge Tasks 1 - 6 | |||||||||||||||||||
| 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) | |||||||||||||||||||
| Fee | |||||||||||||||||||
| Prime Contractor Fee for Prime Contractor Labor | |||||||||||||||||||
| Target Incentive Fee | |||||||||||||||||||
| Prime Contractor Fee for Subcontractor Labor * | |||||||||||||||||||
| Target Incentive Fee | |||||||||||||||||||
| Total Fee (for Prime and Subcontractor Labor) | |||||||||||||||||||
| Target Incentive Fee | |||||||||||||||||||
| Total Labor Cost Plus Target Fee | |||||||||||||||||||
| 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) | 0% | ||||||||||||||||||
| * When analyzing pass through costs, the Government will consider prime offeror fee on subcontractor price as an element of pass through. 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. |
Supporting Cost Data Summary
| SUPPORTING COST DATA | |||
| Direct Labor: | Actual Current Labor 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 | |||
| Additional brief narrative in accordance with Section L, Section 4.3.2(e) |
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 .