Attachment 6 - Section L Cost Template (Revision 1).xlsx
XLSX spreadsheet 470 KB Posted
- Attached to
- KGV-11M
- Solicitation number
- N00039-17-R-0019
View the file
Other files
Show all 17
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
6-1 WBS Cost Data
| LABOR (Unburdened) | MATERIAL (Unburdened) | SUBCONTRACTS (Unburdened) | Indirect Costs | Fee | Other Costs Not Shown Elsewhere | ||||||||||||||||||||||||||||||||||||||||||||
| FY18 | FY19 | FY19 | FY19 | FY19 | FY20 | FY20 | FY20 | Total | FY18 | FY19 | FY19 | FY19 | FY19 | FY20 | FY20 | FY20 | Total | FY18 | FY19 | FY19 | FY19 | FY19 | FY20 | FY20 | FY20 | Total | FY18 | FY19 | FY19 | FY19 | FY19 | FY20 | FY20 | FY20 | Total | FY18 | FY19 | FY19 | FY19 | FY19 | FY20 | FY20 | FY20 | Total | FY18 | FY19 | |||
| Description | WBS | APPN | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | |||||
| Hardware | 1.1.1 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Hardware | 1.1.1 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Software | 1.1.2 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Integration, Assembly, Test, and Checkout | 1.1.3 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Project Management | 2.1.2 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Financial Management | 2.1.3 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Logistics Management | 2.1.4 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Contract Management | 2.1.6 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Travel | 2.1.7 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Studies & Design | 2.2.1 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Certification Authority | 2.2.5 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Systems Engineering Management | 2.2.6 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Configuration Management | 2.2.8 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Logistics Engineering | 2.2.9 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Cybersecurity Engineering | 2.2.11 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| System DT&E | 2.3.1 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| System OT&E | 2.3.2 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Security Testing | 2.3.4 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Systems Integration/Interoperability Testing | 2.3.5 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Technical Publications | 2.5.1 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Peculiar Support Equipment | 2.7.1 | RDTE | |||||||||||||||||||||||||||||||||||||||||||||||
| Common Support Equipment | 2.7.2 | RDTE |
6-2 WBS Labor Hours
| LABOR BY HOURS (Provide in Hours) | ||||||||||||
| Description | WBS | APPN | Basis Of Estimate | FY18 | FY19 | FY19 | FY19 | FY19 | FY20 | FY20 | FY20 | Total |
| Hardware | 1.1.1 | RDTE | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | ||
| Hardware | 1.1.1 | RDTE | ||||||||||
| Software | 1.1.2 | RDTE | ||||||||||
| Integration, Assembly, Test, and Checkout | 1.1.3 | RDTE | ||||||||||
| Project Management | 2.1.2 | RDTE | ||||||||||
| Financial Management | 2.1.3 | RDTE | ||||||||||
| Logistics Management | 2.1.4 | RDTE | ||||||||||
| Contract Management | 2.1.6 | RDTE | ||||||||||
| Travel | 2.1.7 | RDTE | ||||||||||
| Studies & Design | 2.2.1 | RDTE | ||||||||||
| Certification Authority | 2.2.5 | RDTE | ||||||||||
| Systems Engineering Management | 2.2.6 | RDTE | ||||||||||
| Configuration Management | 2.2.8 | RDTE | ||||||||||
| Logistics Engineering | 2.2.9 | RDTE | ||||||||||
| Cybersecurity Engineering | 2.2.11 | RDTE | ||||||||||
| System DT&E | 2.3.1 | RDTE | ||||||||||
| System OT&E | 2.3.2 | RDTE | ||||||||||
| Security Testing | 2.3.4 | RDTE | ||||||||||
| Systems Integration/Interoperability Testing | 2.3.5 | RDTE | ||||||||||
| Technical Publications | 2.5.1 | RDTE | ||||||||||
| Peculiar Support Equipment | 2.7.1 | RDTE | ||||||||||
| Common Support Equipment | 2.7.2 | RDTE |
6-3 SW SLOC
| Unhide Rows below for detailed instructions | ||
| SLOC Info Table Preparation Instructions | ||
| Column Name | Description | |
| Release | Release associated to identified Software Component | |
| Software Component Name | Names of components to be estimated. May include rollup level components as well as lower level components that roll up | |
| Removed Code SLOC | Identifies code included in legacy system that is not to be included in this release | |
| New Code SLOC (No Autogen) | Describes the amount of code in an entirely new component. | |
| Reused Code SLOC | Pre-existing code that is treated as a black box and plugged into the product (i.e., no changes to the code). | |
| Percent Integration for Reused | Represents the percentage of effort required to integrate the reused software into an overall product and to test the resulting product as compared to the normal amount of integration and test effort for software of comparable size. If Unknown - Defaults to 5% | |
| Adapted Code SLOC | Pre-existing code that is treated as a white box and is modified for use with the product (i.e., a pre-existing module to which code is added and/or deleted and/or modified). | |
| Modified Code SLOC | Amount of code within an Adapted module that must be added, deleted, or modified for use in the new software project | |
| Percent Code Modified | Represents the percentage of the adapted software's code which is modified in order to adapt it to the new objectives and environment (i.e., Modified Code SLOC / Adapted Code SLOC). | |
| Percent Design Modified | Represents the percentage of the adapted software's design which is modified in order to adapt it to the new objectives and environment. If Unknown - Defaults to Percent of Code Adapted | |
| Percent Integration for Adapted | Represents the percentage of effort required to integrate the adapted software into an overall product and to test the resulting product as compared to the normal amount of integration and test effort for software of comparable size. If Unknown - Defaults to Percent of Code Modified | |
| Logical / Physical SLOC * | Identifies whether user provided SLOC counts are in Physical or Logical lines of code | |
| Logical / Physical SLOC Factor | Factor to convert user provided SLOC to logical lines of code | |
| % Autogen - New | Percentage of New SLOC that is autogenerated. Not recommended for use in the model (i.e., use zero) | |
| Rationale / Basis | Basis for SLOC values |
Component Level SLOC Info Table
| Release! | Software Component Name | ||
| james.w.cain1: Value used to uniquely identify component in lookups | Removed Code SLOC | ||
| murphey: Identifies code included in legacy system that is not to be included in this release | New Code SLOC | ||
| murphey: Describes the amount of entirely new code that does not reuse any design, code, or test artifacts, is not autogenerated, and is not included in a legacy component | Reused Code SLOC | ||
| murphey: Pre-existing code that is treated as a black box and plugged into the product (i.e., no changes to the code). | Percent Integration for Reused |
murphey: Represents the percentage of effort required to integrate the reused software into an overall product and to test the resulting product as compared to the normal amount of integration and test effort for software of comparable size.
| If Unknown - Defaults to 5% | Adapted Code SLOC |
| murphey: Pre-existing code that is treated as a white box and is modified for use with the product (i.e., a pre-existing module to which code is added and/or deleted and/or modified). | Modified Code SLOC |
murphey: Amount of code that must be added, deleted, or modified within an Adapted module for use in the new software project.
Either input (Modified Code SLOC) or (Percent Code Modified/Percent Design Modified/Percent Integration for Adapted).
Values (either input or calculated) must be present for Percent Code Modified/Percent Design Modified/Percent Integration for Adapted Percent Code Modified murphey: Represents the percentage of the adapted software's code which is modified in order to adapt it to the new objectives and environment (i.e., Modified Code SLOC / Adapted Code SLOC).
Either input (Modified Code SLOC) or (Percent Code Modified/Percent Design Modified/Percent Integration for Adapted).
Values (either input or calculated) must be present for Percent Code Modified/Percent Design Modified/Percent Integration for Adapted Percent Design Modified murphey: Represents the percentage of the adapted software's design which is modified in order to adapt it to the new objectives and environment.
If Unknown - Defaults to Percent of Code Modified
Either input (Modified Code SLOC) or (Percent Code Modified/Percent Design Modified/Percent Integration for Adapted).
Values (either input or calculated) must be present for Percent Code Modified/Percent Design Modified/Percent Integration for Adapted Percent Integration for Adapted murphey: Represents the percentage of effort required to integrate the adapted software into an overall product and to test the resulting product as compared to the normal amount of integration and test effort for software of comparable size.
If Unknown - Defaults to Percent of Code Modified
Either input (Modified Code SLOC) or (Percent Code Modified/Percent Design Modified/Percent Integration for Adapted).
Values (either input or calculated) must be present for Percent Code Modified/Percent Design Modified/Percent Integration for Adapted Logical / Physical SLOC james.w.cain1: Identifies whether user provided SLOC counts are in Physical or Logical lines of code.
| Default assumes Logical | Logical / Physical SLOC Factor |
| james.w.cain1: Factor to convert user provided SLOC to logical lines of code. Default (=1) assumes Logical | % Autogen - New |
| james.w.cain1: Percentage of New SLOC that is autogenerated. Default assumes 0%. | Rationale / Basis |
murphey: Rationale / Basis for estimated values should be provided here.
james.w.cain1: Value used to uniquely identify component in lookups murphey: Identifies code included in legacy system that is not to be included in this release murphey: Describes the amount of entirely new code that does not reuse any design, code, or test artifacts, is not autogenerated, and is not included in a legacy component murphey: Pre-existing code that is treated as a black box and plugged into the product (i.e., no changes to the code).
murphey: Represents the percentage of effort required to integrate the reused software into an overall product and to test the resulting product as compared to the normal amount of integration and test effort for software of comparable size.
If Unknown - Defaults to 5% murphey: Pre-existing code that is treated as a white box and is modified for use with the product (i.e., a pre-existing module to which code is added and/or deleted and/or modified).
murphey: Amount of code that must be added, deleted, or modified within an Adapted module for use in the new software project.
Either input (Modified Code SLOC) or (Percent Code Modified/Percent Design Modified/Percent Integration for Adapted).
Values (either input or calculated) must be present for Percent Code Modified/Percent Design Modified/Percent Integration for Adapted
| - | - | - | - | - | - | - | - | - | Logical | 1.00000 | - | |||
| - | - | - | - | - | - | . | . | . | Logical | 1.00000 | - | |||
| - | - | - | - | - | - | - | - | - | Logical | 1.00000 | - | |||
| - | - | - | - | - | - | - | - | - | Logical | 1.00000 | - | |||
| - | - | - | - | - | - | - | - | - | Logical | 1.00000 | - | |||
| End of Table |
6-4 Cost Summary Roll-up Prime Offeror Name:
| Year 1 | Year 2 | Total | ||||||||
| Cost Elements | RFP Labor Category | Rate | Hours | Amount | Rate | Hours | Amount | Rate | Hours | Amount |
| Prime Contractor Labor Cost | ||||||||||
| Prime Contractor Labor Category | ||||||||||
| Labor Category 1 | Program Manager | |||||||||
| Labor Category 2 | Senior Software Engineer | |||||||||
| Etc. | Etc. |
| Total Direct Labor Cost |
| Prime Contractor Indirect Labor Cost |
| Overhead |
| Fringe Benefits |
| G&A |
| Total Indirect Labor Cost |
| Total Direct and Indirect Labor cost |
| FCCOM |
| Total Prime Contractor Labor Cost |
| Material |
| Material and Handeling Charge |
| Subcontractor 1 Cost |
| Subcontractor 2 Cost |
Total Cost
Target Fee
Total Cost Plus Target Fee
6-5 Basis Of Estimate
| Description | WBS | Basis of Estimate Narative |
| Hardware | 1.1.1 | |
| Software | 1.1.2 | |
| Integration, Assembly, Test, and Checkout | 1.1.3 | |
| Project Management | 2.1.2 | |
| Financial Management | 2.1.3 | |
| Logistics Management | 2.1.4 | |
| Contract Management | 2.1.6 | |
| Travel | 2.1.7 | |
| Studies & Design | 2.2.1 | |
| Certification Authority | 2.2.5 | |
| Systems Engineering Management | 2.2.6 | |
| Configuration Management | 2.2.8 | |
| Logistics Engineering | 2.2.9 | |
| Cybersecurity Engineering | 2.2.11 | |
| System DT&E | 2.3.1 | |
| System OT&E | 2.3.2 | |
| Security Testing | 2.3.4 | |
| Systems Integration/Interoperability Testing | 2.3.5 | |
| Technical Publications | 2.5.1 | |
| Support Equipment | 2.7 |
6-6 BOM
WBS BOE Reference Item Description Vendor Identification Basis of Price Basis of Requirement Make/Sole Source/Competitive Identification of Cost Category Supporting Data/Definitions Quantitiy Unit price Total Cost
Total BOM Cost $ - 0
6-7 FFP Proposal
| CLIN | CLIN DESCRIPTION | EST. QTY (A) | UNIT PRICE (B) | TOTAL EVALUATED PRICE (A * B) |
| 1001 | KGV-11M Production | 672 | ||
| 2001 | KGV-11M Production | 763 | ||
| 3001 | KGV-11M Production | 236 |
6-8 Engineering Services CLINs
COST SUMMARY FORMAT - PRIME CONTRACTOR
| Prime Offeror Name: | |||||||
| DCAA Point of Contact Information: | |||||||
| Period (For Each CLIN 0002, 0102, 1002, 2002, and 3002) | |||||||
| Cost Elements | Labor Category | Category Level (Senior, Mid, Junior) | Actual Current Labor Rate | Escalation Rate | Labor 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 Costs: | |||||||
| Fringe Benefits | |||||||
| Subtotal | |||||||
| Overhead | |||||||
| Subtotal | |||||||
| G&A | |||||||
| Total Prime Contractor Indirect Cost | |||||||
| Total Direct and Indirect Labor cost | |||||||
| COM (If Applicable) | |||||||
| 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)
| 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)
6-8 (cont) Total
COST SUMMARY FORMAT - PRIME CONTRACTOR
| Prime Offeror Name: | ||||
| DCAA Point of Contact Information: | ||||
| Total for All Years | ||||
| Cost Elements | Labor Category | Category Level (Senior, Mid, Junior) | 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 Costs: | ||||
| Fringe Benefits | ||||
| Subtotal | ||||
| Overhead | ||||
| Subtotal | ||||
| G&A | ||||
| Total Prime Contractor Indirect Cost | ||||
| Total Direct and Indirect Labor cost | ||||
| COM (If Applicable) | ||||
| 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)
| 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)
| 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) | ERROR:#DIV/0! | |
| Maximum Pass Through Allowed by SeaPort-e IDIQ Contract |
| Fee Analysis - Total for All Years | Amount | Percent |
| Prime Contractor Labor Cost | ||
| Fixed Fee for Labor Performed by Prime Contractor | ERROR:#DIV/0! | |
| Maximum Fixed Fee Allowed by SeaPort-e IDIQ Contract |
| Escalation Analysis | Percent |
| Escalation from Current Actual to Base Period (if applicable) | |
| 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 | |
| Maximum Escalation Allowed by SeaPort-e IDIQ Contract |
6-8 (cont)Supporting Cost Data
SUPPORTING COST DATA - PRIME CONTRACTOR'S CURRENT DIRECT & INDIRECT RATES
| Company Name: |
| DCAA Point of Contact Information: |
| Historical Rates | |
| Direct Labor: |
Employee Name
| Labor Category | Historical Year 1 | Historical Year 2 | Historical Year 3 | ||||
| (Actual Current Labor Rate) | Proposed Option Period Labor Rate | Proposed Option Period Labor Rate | Proposed Option Period Labor Rate | Proposed Option Period Labor Rate | Proposed Option 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. | |
| Ex: John Doe | Ex: Sr. Program Mgr | $ | $ | $ | $ | $ | |
| Ex: Jane Doe | Ex: Sr. Systems Engineer | $ | $ | $ | $ | $ | |
| Ex: New Employee 1 | Ex: Jr. Junior Analyst | $ | $ | $ | $ | $ | |
| $ | $ | $ | $ | $ | |||
| $ | $ | $ | $ | $ |
| Indirect Rates: | Historical Year 1 | Historical Year 2 | Historical Year 3 | Proposed Option Rate | Proposed Option Rate | Proposed Option Rate | Proposed Option Rate | Proposed Option 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: | ||||||||||
| Note to Offerors: The Offeror shall provide both historical and proposed labor rates for the named personnel identified above. The offeror shall provide only proposed labor rates for the unnamed personnel identified above. The Offeror shall provide historical rates in Columns C, D and E; year 3 shall contain the Offeror's most recent annual labor rates. The Offeror shall then identify their proposed labor rates for those same individuals in columns F, G, H, I, and J. The Offeror shall provide similar historical and proposed indirect rates for the items listed on lines 16 through 20. The Offeror shall identify the Start and End dates for each of their rate periods in the table on lines 24-32. |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it.