Attachment 3 - Prime_Contractor_Cost_Summary-Spreadsheet.xlsx

XLSX spreadsheet 38 KB Posted

Attached to
Common Submarine Radio Room (CSRR) Control and Management (C&M) Software
Solicitation number
N00039-17-R-0056
Issued by

View the file

Other files

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:
CLINsProposed 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 FORMATFormulas 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 YearsBase PeriodOption Year 1Option Year 2Option Year 3Option Year 4
Cost ElementsLabor Category *Hours*AmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmount
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 0003CLIN 0103CLIN 0203CLIN 0303CLIN 0403

Total ODCs $0 $0 $0 $0 $0 $0

TOTAL ODCs

TOTAL all CLINs (Labor and ODCs

EscalationPercent
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 1Historical Year 2Historical Year 3
Historical Year (Actual Current Labor Rate)Proposed Base Period Labor RateProposed Option 1 Period Labor RateProposed Option 2 Period Labor RateProposed Option 3 Period Labor RateProposed Option 4 Period Labor RateReason 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 PeriodStart DateEnd 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 RequirementOfferor 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 SystemsEducation:

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 RequirementOfferor 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 RequirementOfferor 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 RequirementOfferor 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 RequirementOfferor 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 RequirementOfferor 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 RequirementOfferor 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 RequirementOfferor 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 RequirementOfferor Proposed:
Education: A Bachelor’s degree from an accredited four-year college or university in Engineering, Physical Sciences, Mathematics, Management Information Systems or BusinessEducation:

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 CATEGORYCLIN 0001CLIN 0101CLIN 0201CLIN 0301CLIN 0401TOTAL
Engineer-35,6526,7074,3714,4105,58426,724
Engineer-210,81112,8288,3618,43510,68151,116
Engineer-2 (Gov’t Site Newport, RI)1,8201,8201,8201,8201,8209,100
Engineer-11,8132,1511,4021,4141,7918,571
Technical Analyst-26758015225276673,192
Program Manager1,6111,9121,2461,2571,5927,618
Project Manager3,5854,2542,7722,7973,54216,950
Management Analyst-38521,0116596658424,029
Management Analyst-21,2201,4479439521,2055,767
Management Analyst-15055993903944992,387
TOTAL28,54433,53022,48622,67128,223135,454

File details come from the government source that posted it.