Attachment 3 - Prime_Contractor_Cost_Summary-Spreadsheet.xlsx
XLSX spreadsheet 38 KB Posted
- Solicitation number
- N00039-17-R-0056
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment 2 - DD254 N00039-17-R-0056.pdf | ||
| Attachment 5 - Reference Information Form.docx | DOCX document | |
| Attachment 4 - Subcontractor_Cost_Summary-Spreadsheet.xlsx | XLSX spreadsheet | |
| CSRR NDA for RFP.docx | DOCX document | |
| Attachment 8 - Government Furnished Property.pdf | ||
| Attachment 1 - CSRR_CandM_SOW__18Dec2017.pdf | ||
| Exhibit-A-CSRR- CM-CDRLs18Dec2017.pdf | ||
| Attachment 6 - Past Performance Questionnaire.docx | DOCX document | |
| N00039-17-R-0056.pdf | ||
| CSRR RFI SOW DRAFT 24JAN2017 REV1.pdf | ||
| CSRR NDA.docx | DOCX document |
Show all 11
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
1. Ceiling Total
| ATTACHMENT 3 |
| SOLICITATION NO. N00039-17-R-0056 |
| COST SUMMARY - PRIME CONTRACTOR |
| Prime Offeror Name: |
| DCAA Point of Contact Information: |
| CLINs | Proposed Cost |
| CLIN 0001 | $ - 0 |
| CLIN 0003 | $ - 0 |
| CLIN 0101 | $ - 0 |
| CLIN 0103 | $ - 0 |
| CLIN 0201 | $ - 0 |
| CLIN 0203 | $ - 0 |
| CLIN 0301 | $ - 0 |
| CLIN 0303 | $ - 0 |
| CLIN 0401 | $ - 0 |
| CLIN 0403 | $ - 0 |
| Total Proposed Cost | $ - |
2. CPIF
| ATTACHMENT 3 | |
| SOLICITATION NO. N00039-17-R-0056 | |
| PRIME CONTRACTOR COST SUMMARY FORMAT | Formulas shall be created by the Contractor. An MS Excel file shall be submitted to the Government with formulas left intact. |
| Prime Offeror Name: | |
| 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 Labor Cost | ||||||||||||||||||
| Employee Name 1 | ||||||||||||||||||
| Employee Name 2 | ||||||||||||||||||
| Etc. | ||||||||||||||||||
| Total Labor Cost |
| Prime Contractor Indirect Labor Costs: |
| Fringe Benefits |
| Subtotal |
| Overhead |
| Overhead GOV site (if applicable) |
| Subtotal |
| G&A |
| Material/Subcontractor Handling (if applicable) |
| Total Prime Contractor Indirect Cost |
| Total Prime Direct and Indirect Labor Cost |
| Subcontractor Labor Cost |
| Subcontractor proposed cost |
| Subcontractor 1 |
| Subcontractor 2 |
| Etc. |
| Total proposed subcontractor labor cost |
| Total Subcontractor Cost including pass through |
| FCCM |
| Incetive Fee |
Total Labor Cost Plus Incentive Fee (CPIF)
| OTHER DIRECT COSTS | |||||
| Other Direct Costs (ODCs) | |||||
| Other Direct Costs (ODCs) | CLIN 0003 | CLIN 0103 | CLIN 0203 | CLIN 0303 | CLIN 0403 |
Total ODCs $0 $0 $0 $0 $0 $0
TOTAL ODCs
TOTAL all CLINs (Labor and ODCs
| Escalation | Percent |
| Escalation from Base Period to Option Period 1 | |
| Escalation from Option Period 1 to Option Period 2 | |
| Escalation from Option Period 2 to Option Period 3 | |
| Escalation from Option Period 3 to Option Period 4 |
3. Historical Data
Historical Data
| Company Name: |
| DCAA Point of Contact Information: |
| Indirect Rates: | Historical Year 1 | Historical Year 2 | Historical Year 3 | |||
| Historical Year (Actual Current Labor Rate) | Proposed Base Period Labor Rate | Proposed Option 1 Period Labor Rate | Proposed Option 2 Period Labor Rate | Proposed Option 3 Period Labor Rate | Proposed Option 4 Period Labor Rate | Reason for difference between actual current labor rate and proposed labor rates. Reason for difference between proposed rates and DCMA/DCAA Forward Pricing Rate Agreement (FPRA) rates. |
| Fringe | ||||||
| Overhead CTR Site | ||||||
| Overhead GOV Site | ||||||
| G&A | ||||||
| Material and Handling | ||||||
| Other |
| Rate Period | Start Date | End Date |
| Historical Year 1: | ||
| Historical Year 2: | ||
| Historical Year 3: | ||
| Proposed Base Period: | ||
| Proposed Option 1: | ||
| Proposed Option 2: | ||
| Proposed Option 3: | ||
| Proposed Option 4: | ||
| Note to Offerors: The Offeror shall provide historical and proposed indirect rates. The Offeror shall provide historical rates in Columns C through E; Columns F shall contain the Offeror's most recent annual indirect rates. The Offeror shall identify the Start and End dates for each of their rate periods in the table in rows 18-27. |
4. Offeror Labor Category Quals
OFFEROR LABOR CATEGORY QUALIFICATIONS
General Instructions for Labor Category Qualifications: As stated in Sections L and M of the RFP, the Offeror shall provide sufficient detail for the Government to evaluate the extent to which the proposed direct labor rates are realistic in consideration of the labor category qualifications listed in Section L of the RFP
For Education: Provide level of education associated with applicable proposed named employee, contingent hire, or TBD rate.
For Experience: Provide years of relevant experience, where performed, what types of DoD programs supported, and subject matter of work and/or types of tasks performed associated with applicable proposed named employee, contingent hire, or TBD rate.
FAR and DoD Procurement Policies and Procedures Knowledge: If applicale, provide how knowledge was obtained. If through courses, include cources completed and completion month/year (if available) associated with applicable proposed named employee, contingent hire, or TBD rate.
| ENGINEER 3 | |
| Offeror's Labor Category: | |
| Name of Proposed Employee: | |
| Government Requirement | Offeror Proposed: |
| Education: A Bachelor of Science (BS) degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Mathematics, or Management Information Systems | Education: |
Experience:- Six (6) years of experience directly supporting a Department of Defense (DoD) program office at a major systems acquisition command, to include software systems analysis, design, development, test and evaluation. Five (5) years of additional relevant work experience may be substituted for a degree. Experience:
| ENGINEER 2 | |
| Offeror's Labor Category: | |
| Name of Proposed Employee: | |
| Government Requirement | Offeror Proposed: |
| Education: A BS degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Mathematics, or Management Information Systems. | Education: |
Experience:- Three (3) years of experience supporting a Department of Defense (DoD) program, to include software systems analysis, design, development, test and evaluation. Five (5) years of additional relevant work experience may be substituted for a degree. Experience:
| ENGINEER 1 | |
| Offeror's Labor Category: | |
| Name of Proposed Employee: | |
| Government Requirement | Offeror Proposed: |
| Education: A BS degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Mathematics, or Management Information Systems. | Education: |
Experience:- One (1) year of experience supporting a Department of Defense (DoD) program, to include software systems development and test. Five (5) years of additional relevant work experience may be substituted for a degree. Experience:
| TECHNICAL ANALYST 2 | |
| Offeror's Labor Category: | |
| Name of Proposed Employee: | |
| Government Requirement | Offeror Proposed: |
| Education: An Associate’s degree from an accredited college or university in Applied Science, Computing, Engineering, Mathematics, or Management Information Systems. | Education: |
Experience:- Two (2) years of experience supporting a Department of Defense (DoD) program to include software systems development and test. Three (3) years of additional relevant work experience may be substituted for a degree. Experience:
| PROGRAM MANAGER | |
| Offeror's Labor Category: | |
| Name of Proposed Employee: | |
| Government Requirement | Offeror Proposed: |
| Education: A Bachelor’s degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Physical Sciences, Mathematics, or Management Information Systems. | Education: |
Experience:- Six (6) years of professional program management experience directly supporting a Department of Defense (DoD) program office at a major systems acquisition command. Five (5) years of additional relevant work experience may be substituted for a degree. Experience:
Knowlege:- Knowledge of Federal Acquisition Regulation (FAR) and DoD procurement policies and procedures. Knowlege:
| PROJECT MANAGER | |
| Offeror's Labor Category: | |
| Name of Proposed Employee: | |
| Government Requirement | Offeror Proposed: |
| Education: A Bachelor’s degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Physical Sciences, Mathematics, or Management Information Systems. | Education: |
Experience:- Three (3) years of project management experience directly supporting a Department of Defense (DoD) program office at a major systems acquisition command. Five (5) years of additional relevant work experience may be substituted for a degree. Experience:
Knowlege:- Knowledge of Federal Acquisition Regulation (FAR) and DoD procurement policies and procedures. Knowlege:
| MANAGEMENT ANALYST 3 | |
| Offeror's Labor Category: | |
| Name of Proposed Employee: | |
| Government Requirement | Offeror Proposed: |
| Education: Bachelor’s degree from an accredited four-year college or university in Engineering, Physical Sciences, Mathematics, Management Information Systems or Business. | Education: |
| Experience:- Six (6) years of professional finance, contract or scheduling experience directly supporting a Department of Defense (DoD) program office at a major systems acquisition command. Five (5) years of additional relevant work experience may be substituted for a degree. | Experience: |
| Knowlege:- Knowledge of Federal Acquisition Regulation (FAR) and DoD procurement policies and procedures. | Knowlege: |
| MANAGEMENT ANALYST 2 | |
| Offeror's Labor Category: | |
| Name of Proposed Employee: | |
| Government Requirement | Offeror Proposed: |
| Education: A Bachelor’s degree from an accredited four-year college or university in Engineering, Physical Sciences, Mathematics, Management Information Systems or Business. | Education: |
Experience: Three (3) years of professional finance, contract or scheduling experience supporting a Department of Defense (DoD) program. Five (5) years of additional relevant work experience may be substituted for a degree. Experience:
| MANAGEMENT ANALYST 1 | |
| Offeror's Labor Category: | |
| Name of Proposed Employee: | |
| Government Requirement | Offeror Proposed: |
| Education: A Bachelor’s degree from an accredited four-year college or university in Engineering, Physical Sciences, Mathematics, Management Information Systems or Business | Education: |
Experience: One (1) years of professional finance, contract or scheduling experience supporting a Department of Defense (DoD) program. Five (5) years of additional relevant work experience may be substituted for a degree. Experience:
5. Labor Category Qualification
| Engineering: |
| Engineer 3: A Bachelor of Science (BS) degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Mathematics, or Management Information Systems and a minimum of six years of experience directly supporting a Department of Defense (DoD) program office at a major systems acquisition command, to include software systems analysis, design, development, test and evaluation. Five years of additional relevant work experience may be substituted for a degree. |
Engineer 2: A BS degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Mathematics, or Management Information Systems; and a minimum of three years of experience supporting a Department of Defense (DoD) program, to include software systems analysis, design, development, test and evaluation. Five years of additional relevant work experience may be substituted for a degree.
Engineer 1: A BS degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Mathematics, or Management Information Systems and a minimum of one year of experience supporting a Department of Defense (DoD) program, to include software systems development and test. Five years of additional relevant work experience may be substituted for a degree.
| Technical Analyst: |
| Technical Analyst 2: n Associate’s degree from an accredited college or university in Applied Science, Computing, Engineering, Mathematics, or Management Information Systems and a minimum of two years of experience supporting a Department of Defense (DoD) program to include software systems development and test. Three years of additional relevant work experience may be substituted for a degree. |
| Program Management: |
| Program Manager: A Bachelor’s degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Physical Sciences, Mathematics, or Management Information Systems; and a minimum of six years of professional program management experience directly supporting a Department of Defense (DoD) program office at a major systems acquisition command. Knowledge of Federal Acquisition Regulation (FAR) and DoD procurement policies and procedures. Five years of additional relevant work experience may be substituted for a degree. The government anticipants this position to oversee and manager the overall C&M effort. |
Project Manager: A Bachelor’s degree from an accredited four-year college or university in Applied Science, Computing, Engineering, Physical Sciences, Mathematics, or Management Information Systems and three years of project management experience directly supporting a Department of Defense (DoD) program office at a major systems acquisition command. Knowledge of Federal Acquisition Regulation (FAR) and DoD procurement policies and procedures. Five years of additional relevant work experience may be substituted for a degree. The government anticipants this position to oversee and manager the day-to-day C&M effort.
| Management Analysts: |
| Management Analyst 3: A Bachelor’s degree from an accredited four-year college or university in Engineering, Physical Sciences, Mathematics, Management Information Systems or Business and a minimum of six years of professional finance, contract or scheduling experience directly supporting a Department of Defense (DoD) program office at a major systems acquisition command. Knowledge of Federal Acquisition Regulation (FAR) and DoD procurement policies and procedures. Five years of additional relevant work experience may be substituted for a degree. |
Management Analyst 2: A Bachelor’s degree from an accredited four-year college or university in Engineering, Physical Sciences, Mathematics, Management Information Systems or Business and a minimum of three years of professional finance, contract or scheduling experience supporting a Department of Defense (DoD) program. Five years of additional relevant work experience may be substituted for a degree.
Management Analyst 1: A Bachelor’s degree from an accredited four-year college or university in Engineering, Physical Sciences, Mathematics, Management Information Systems or Business and a minimum of one year of professional finance, contract or scheduling experience supporting a Department of Defense (DoD) program. Five years of additional relevant work experience may be substituted for a degree.
6. Labor Mix by CLIN
| LABOR CATEGORY | CLIN 0001 | CLIN 0101 | CLIN 0201 | CLIN 0301 | CLIN 0401 | TOTAL |
| Engineer-3 | 5,652 | 6,707 | 4,371 | 4,410 | 5,584 | 26,724 |
| Engineer-2 | 10,811 | 12,828 | 8,361 | 8,435 | 10,681 | 51,116 |
| Engineer-2 (Gov’t Site Newport, RI) | 1,820 | 1,820 | 1,820 | 1,820 | 1,820 | 9,100 |
| Engineer-1 | 1,813 | 2,151 | 1,402 | 1,414 | 1,791 | 8,571 |
| Technical Analyst-2 | 675 | 801 | 522 | 527 | 667 | 3,192 |
| Program Manager | 1,611 | 1,912 | 1,246 | 1,257 | 1,592 | 7,618 |
| Project Manager | 3,585 | 4,254 | 2,772 | 2,797 | 3,542 | 16,950 |
| Management Analyst-3 | 852 | 1,011 | 659 | 665 | 842 | 4,029 |
| Management Analyst-2 | 1,220 | 1,447 | 943 | 952 | 1,205 | 5,767 |
| Management Analyst-1 | 505 | 599 | 390 | 394 | 499 | 2,387 |
| TOTAL | 28,544 | 33,530 | 22,486 | 22,671 | 28,223 | 135,454 |
File details come from the government source that posted it.