Attachment 3 - Cost Summary Format.xlsx
XLSX spreadsheet 39 KB Posted
- Attached to
- Lab Analysis and Support Federal contract opportunity
- Solicitation number
- N6426723R0207
About this file
This document contains a cost summary template and instructions for a federal contract opportunity with the Department of the Navy Naval Sea Systems Command. The cost summary template requires offerors to provide pricing details for labor, indirect rates, subcontractors, other direct costs, and fee for each contract line item and year. Labor categories, locations, and fully burdened rates must be included for prime contractor and subcontractor personnel. Documentation of direct labor rates, indirect rates, and contributing government contracts is also required. The opportunity is for lab analysis and support services, as identified in the related solicitation numbered N6426723R0207.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Amendment 0002.pdf | ||
| Amendment 0001.pdf | ||
| A4_CRDL_A001-A002_N6426723R0207.pdf | ||
| Attachment 1 - MIL-C-81302D.pdf | ||
| Attachment 4 - DCAA Rate Check Form.xls | XLS spreadsheet | |
| Lab Analysis RFP Final.docx | DOCX document | |
| Attachment 2 - LOE.pdf |
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 by Year
| N6426723R0207, ATTACHMENT 3 | ||||||||||||||||||||
| COST SUMMARY FORMAT | ||||||||||||||||||||
| Prime Offeror Name: | ||||||||||||||||||||
| Subcontractor Name (if applicable): | ||||||||||||||||||||
| DCAA Point of Contact Information: | Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | |||||||||||||||
| KEY? | LOCATION | Total for All Years | ||||||||||||||||||
| Cost Elements | Labor Category | Y / N | GOV/CTR | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Hours | Amount |
| LABOR CLINs | ||||||||||||||||||||
| Prime Contractor Direct Labor Cost | ||||||||||||||||||||
| Employee Name 1 | ||||||||||||||||||||
| Employee Name 2 | ||||||||||||||||||||
| Labor Category Average Rate per Year | ||||||||||||||||||||
| Etc. | ||||||||||||||||||||
| Total Direct Labor Cost | ||||||||||||||||||||
| Prime Contractor Indirect Labor Cost | ||||||||||||||||||||
| Fringe Benefits | ||||||||||||||||||||
| Overhead | ||||||||||||||||||||
| G&A | ||||||||||||||||||||
| Total Indirect Labor Cost | ||||||||||||||||||||
| Total Prime Direct and Indirect Labor Cost | ||||||||||||||||||||
| FCCM | ||||||||||||||||||||
| 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) | ||||||||||||||||||||
| Fee | ||||||||||||||||||||
| Prime Contractor Fee for Prime Contractor Labor | ||||||||||||||||||||
| Fixed Fee | ||||||||||||||||||||
| Prime Contractor Fee for Subcontractor Labor * | ||||||||||||||||||||
| Fixed Fee | ||||||||||||||||||||
| Total Fee (for Prime and Subcontractor Labor) | ||||||||||||||||||||
| TOTAL LABOR COST PLUS FIXED FEE | ||||||||||||||||||||
| OTHER DIRECT COSTS (ODC) CLINs | ||||||||||||||||||||
| Prime Contractor ODC | ||||||||||||||||||||
| Travel | ||||||||||||||||||||
| ODC | ||||||||||||||||||||
| Subtotal ODC | ||||||||||||||||||||
| Prime Burdens on ODC | ||||||||||||||||||||
| Material Handling | ||||||||||||||||||||
| G&A | ||||||||||||||||||||
| Other (Specify each separately) | ||||||||||||||||||||
| Subtotal Burden on Prime ODCs | ||||||||||||||||||||
| Subcontractor ODC | ||||||||||||||||||||
| Travel | ||||||||||||||||||||
| Subcontractor 1 | ||||||||||||||||||||
| Subcontractor 2 | ||||||||||||||||||||
| Etc. | ||||||||||||||||||||
| Subtotal Subcontractor Travel | ||||||||||||||||||||
| ODC | ||||||||||||||||||||
| Subcontractor 1 | ||||||||||||||||||||
| Subcontractor 2 | ||||||||||||||||||||
| Etc. | ||||||||||||||||||||
| Subtotal Subcontractor ODC | ||||||||||||||||||||
| Total Subcontractor Travel and ODC | ||||||||||||||||||||
| Prime Burdens on Subcontractor ODC | ||||||||||||||||||||
| Material Handling | ||||||||||||||||||||
| G&A | ||||||||||||||||||||
| Other (Specify each separately) | ||||||||||||||||||||
| Subtotal Prime Burden on Subcontractor ODC | ||||||||||||||||||||
| TOTAL TRAVEL AND ODC CLINS | ||||||||||||||||||||
| TOTAL ALL CLINS (LABOR AND ODC) |
Cost Summary by CLIN by Year
| N6426722R1007, ATTACHMENT 3 | |||||||||||||||||||||||||||||||||
| COST SUMMARY FORMAT | |||||||||||||||||||||||||||||||||
| Prime Offeror Name: | |||||||||||||||||||||||||||||||||
| Subcontractor Name (if applicable): | |||||||||||||||||||||||||||||||||
| DCAA Point of Contact Information: | Base Year | Option Year 1 | Option Year 2 | Option Year 3 | Option Year 4 | ||||||||||||||||||||||||||||
| KEY? | LOCATION | 1000 | 1050 | 7100 | 7150 | 7200 | 7250 | 7300 | 7350 | 7400 | 7450 | ||||||||||||||||||||||
| Cost Elements | Labor Category | Y / N | GOV/CTR | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount |
| LABOR CLINs | |||||||||||||||||||||||||||||||||
| Prime Contractor Direct Labor Cost | |||||||||||||||||||||||||||||||||
| Employee Name 1 | |||||||||||||||||||||||||||||||||
| Employee Name 2 | |||||||||||||||||||||||||||||||||
| Labor Category Average Rate per Year | |||||||||||||||||||||||||||||||||
| Etc. | |||||||||||||||||||||||||||||||||
| Total Direct Labor Cost | |||||||||||||||||||||||||||||||||
| Prime Contractor Indirect Labor Cost | |||||||||||||||||||||||||||||||||
| Fringe Benefits | |||||||||||||||||||||||||||||||||
| Overhead | |||||||||||||||||||||||||||||||||
| G&A | |||||||||||||||||||||||||||||||||
| Total Indirect Labor Cost | |||||||||||||||||||||||||||||||||
| Total Prime Direct and Indirect Labor Cost | |||||||||||||||||||||||||||||||||
| FCCM | |||||||||||||||||||||||||||||||||
| 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) | |||||||||||||||||||||||||||||||||
| Fee | |||||||||||||||||||||||||||||||||
| Prime Contractor Fee for Prime Contractor Labor | |||||||||||||||||||||||||||||||||
| Fixed Fee | |||||||||||||||||||||||||||||||||
| Prime Contractor Fee for Subcontractor Labor * | |||||||||||||||||||||||||||||||||
| Fixed Fee | |||||||||||||||||||||||||||||||||
| Total Fee (for Prime and Subcontractor Labor) | |||||||||||||||||||||||||||||||||
| TOTAL LABOR COST PLUS FIXED FEE | |||||||||||||||||||||||||||||||||
| OTHER DIRECT COSTS (ODC) CLINs | |||||||||||||||||||||||||||||||||
| Prime Contractor ODC | |||||||||||||||||||||||||||||||||
| Travel | |||||||||||||||||||||||||||||||||
| ODC | |||||||||||||||||||||||||||||||||
| Subtotal ODC | |||||||||||||||||||||||||||||||||
| Prime Burdens on ODC | |||||||||||||||||||||||||||||||||
| Material Handling | |||||||||||||||||||||||||||||||||
| G&A | |||||||||||||||||||||||||||||||||
| Other (Specify each separately) | |||||||||||||||||||||||||||||||||
| Subtotal Burden on Prime ODCs | |||||||||||||||||||||||||||||||||
| Subcontractor ODC | |||||||||||||||||||||||||||||||||
| Travel | |||||||||||||||||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||||||||||||||||
| Etc. | |||||||||||||||||||||||||||||||||
| Subtotal Subcontractor Travel | |||||||||||||||||||||||||||||||||
| ODC | |||||||||||||||||||||||||||||||||
| Subcontractor 1 | |||||||||||||||||||||||||||||||||
| Subcontractor 2 | |||||||||||||||||||||||||||||||||
| Etc. | |||||||||||||||||||||||||||||||||
| Subtotal Subcontractor ODC | |||||||||||||||||||||||||||||||||
| Total Subcontractor Travel and ODC | |||||||||||||||||||||||||||||||||
| Prime Burdens on Subcontractor ODC | |||||||||||||||||||||||||||||||||
| Material Handling | |||||||||||||||||||||||||||||||||
| G&A | |||||||||||||||||||||||||||||||||
| Other (Specify each separately) | |||||||||||||||||||||||||||||||||
| Subtotal Prime Burden on Subcontractor ODC | |||||||||||||||||||||||||||||||||
| TOTAL TRAVEL AND ODC CLINS | |||||||||||||||||||||||||||||||||
| TOTAL ALL CLINS (LABOR AND ODC) |
| Pass Through Analysis - Total for All Years | Amount | Percent | * 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. |
| 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% |
Supporting Cost Data
SUPPORTING COST DATA
| Direct Labor: | Actual Current Labor Rate | Effective Date of Current Rate | Escalation Factor to Calculate Proposed Base Period 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 | Blending Formula to Calculate Proposed Base 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) |
N6426722R1007, ATTACHMENT 3
COST SUMMARY FORMAT
Sample Indirect Rate Supp. Doc.
Sample Indirect Rate Supporting Documentation
| Budget | PRIOR YEAR ACTUALS | |||
| Overhead Expense | Year (BY) | BY - 1 | BY - 2 | BY - 3 |
| 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/11 | |
| N000XX-XX-X-00XX | 9/1/12 | |
| N000XX-XX-X-00XX | 8/1/10 |
| * When developing your percentage, these are the contracts contributing |
| to development of the percentage. |
Tripwire Compliance
| Labor | |||||
| Category | Site (Onsite/Offsite) | Company | Employee | ||
| Name | FT / | ||||
| PT | Hourly | ||||
| Rate | Fringe Rate | OH Rate | G&A Rate | [Insert Indirect Rates as Needed] | Total |
| Cost | Fee | Fully |
Burdened Rate per Hour Over Tripwire (Y/N)
| Program Manager | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Senior System Administrator (Servers/VXN) | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Program Analyst | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Electronics Technician | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Senior System Administrator (Windows & Linux) | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Senior System Administrator (Windows) | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Senior System Administrator (Linux) | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Cyber Security Analyst | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Financial Analyst | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Data Management Specialist | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Operation Support Specialist | Employee Name 1 |
| Employee Name 2 | |
| Etc. | |
| Labor Category Average Rate per Year | |
| Test Support Analyst | Employee Name 1 |
| Employee Name 2 | |
| Etc. |
File details come from the government source that posted it. Updated .