Attachment_11_-Cost_and_Price_Evaluation_Worksheet_Rev._2_8-9-2017.xls
XLS spreadsheet 236 KB Posted
- Solicitation number
- N00024-17-R-5216
About this file
Attachment 11 - Cost and Price Evaluation Worksheet Rev. 2
View the file
Other files
Show all 26
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
J-11 (Summary Matrix)
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 | |||||||||
| CLIN | Description | 2a (CLIN Summary by FY) | 2b (CLIN Breakout) | 2c (Breakout by CY) | 2d (Eng Svcs Breakout) | 2e (WBS Breakout) | 2f (Rate Summary) | 2g (BOM) | 2h (SLOC Table) |
| CLIN Summary | Summary data including all CLINs, excluding CLIN 0004 | X | X | X | X | ||||
| 0001 | Navy ECDIS SW 1.0 Production Build | X | X | X | |||||
| 0002 | Engineering Services | X | |||||||
| 0003 | Travel and ODC | ||||||||
| 0004 | Data | ||||||||
| 1001 | Navy ECDIS Software 1.1 (Maintenance Build) Engineering Services | X | |||||||
| 1002 | Travel and ODC | ||||||||
| 1003 | Government Purpose Data Rights/ Licenses | ||||||||
| 2001 | Navy ECDIS Software 1.2 (Maintenance Build) Engineering Services | X | |||||||
| 2002 | Travel and ODC | ||||||||
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 |
&CDRAFT
2a (CLIN Summary by FY)
| N00024-17-R-5216 Navy ECDIS SW SECTION L - COST TABLE ATTACHMENT J-11 2a | ||||||||||
| FY Cost Summary Detail for Priced CLINs | ||||||||||
| CLIN | FY18 | FY19 | FY20 | FY21 | FY22 | FY23 | FY24 | FY25 | FY26 | TOTAL Proposed CLIN Amount |
| CLIN 0001 | ||||||||||
| CLIN 0002 | ||||||||||
| CLIN 0003 | ||||||||||
| CLIN 0004 | ||||||||||
| CLIN 1001 | ||||||||||
| CLIN 1002 | ||||||||||
| CLIN 1003 | ||||||||||
| CLIN 2001 | ||||||||||
| CLIN 2002 | ||||||||||
| TOTAL | ||||||||||
| * CLIN 0004 Data Rights is Not Seperately Priced. Does not need to be broken out by FY. | ||||||||||
| Round cost values to whole dollars. | ||||||||||
| The cells on this form do not need to be linked to any other form. | ||||||||||
| Cost should be through FCCM | ||||||||||
| N00024-17-R-5216 Navy ECDIS SW SECTION L - COST TABLE ATTACHMENT J-11 2a |
2b (CLIN Breakout)
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2b | |||||||||
| Cost Summary Table By CLIN/SLIN | |||||||||
| Major Cost Element | CLIN 0001 | CLIN 0002 | CLIN 0003 | CLIN 1001 | CLIN 1002 | CLIN 1003 | CLIN 2001 | CLIN 2002 | Total |
| Material Overhead ($) | |||||||||
| Major SubContracts ($) | |||||||||
| Other SubContracts ($) | |||||||||
| Interorganizational Transfer ($) | |||||||||
| Total Material ($) | |||||||||
| DirectAdministrative Labor (Hours) | |||||||||
| Direct Administrative Labor ($) | |||||||||
| Administrative Overhead ($) | |||||||||
| Total Administrative ($) | |||||||||
| Direct Program Management Labor (Hours) | |||||||||
| Direct Program Management Labor ($) | |||||||||
| Program Management Overhead ($) | |||||||||
| Total Program Management ($) | |||||||||
| Direct Engineering Labor (Hours) | |||||||||
| Direct Engineering Labor ($) | |||||||||
| Engineering Overhead ($) | |||||||||
| Total Engineering ($) | |||||||||
| Subtotal Labor ($) | |||||||||
| Subtotal Material, Labor, and ODC ($) | |||||||||
| G&A Expense ($) | |||||||||
| Subtotal Estimated Costs less FCCM ($) | |||||||||
| Facilities Capital Cost of Money (FCCM) ($) | |||||||||
| Total Target Cost ($) | |||||||||
| Target Fee/Profit ($) | |||||||||
| Target Fee/Profit (%) | |||||||||
| CLIN Type | CPIF | CPFF | COST | CPFF | COST | FFP | CPFF | COST | N/A |
| TOTAL ($) | |||||||||
| Round cost values to whole dollars. | |||||||||
| Link each cell in this form with the appropriate cells in the Worsheet 2f for each of the CLIN. Do not just paste values where value can be linked to another form. | |||||||||
| Categories provided are for example only, link categories to actual categories listed in Worksheet 2f | |||||||||
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2b |
2c (Breakout by CY)
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2c | ||||||||||||||||||||||||||||
| Cost Summary Detail by Calendar Year For CLINs 0001, 0002, 0003, 1001, 1002, 1003, 2001, 2002 (Offeror shall provide a separate sheet for each CLIN) | ||||||||||||||||||||||||||||
| Major Cost Element | CY18 | CY19 | CY20 | CY21 | CY22 | CY23 | CY24 | CY25 | CY26 | Total $ | ||||||||||||||||||
| Hours/Cost | Rate | SubTotal $ | Hours/Cost | Rate | SubTotal $ | Hours/Cost | Rate | SubTotal $ | Hours/Cost | Rate | SubTotal $ | Hours/Cost | Rate | SubTotal $ | Hours/Cost | Rate | SubTotal $ | Hours/Cost | Rate | SubTotal $ | Hours/Cost | Rate | SubTotal $ | Hours/Cost | Rate | SubTotal $ | ||
| Material | ||||||||||||||||||||||||||||
| Major Subs | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| Other Subs | ||||||||||||||||||||||||||||
| Interorganizational Transfer | ||||||||||||||||||||||||||||
| Material Overhead | ||||||||||||||||||||||||||||
| Total Material | ||||||||||||||||||||||||||||
| Labor | ||||||||||||||||||||||||||||
| Administrative | ||||||||||||||||||||||||||||
| Category/Personnel | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| Administrative Indirect Rates | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| Program Management | ||||||||||||||||||||||||||||
| Category/Personnel | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| Program Management Indirect Rates | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| Engineering | ||||||||||||||||||||||||||||
| Category/Personnel | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| Engineering Indirect Rates | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| Total Labor | ||||||||||||||||||||||||||||
| SUBTOTAL COSTS ($) | ||||||||||||||||||||||||||||
| G&A Expense ($) | ||||||||||||||||||||||||||||
| Type | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| SUBTOTAL COSTS ($) | ||||||||||||||||||||||||||||
| Facilities Capital Cost of Money (FCCM) ($) | ||||||||||||||||||||||||||||
| Type | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| * | ||||||||||||||||||||||||||||
| TOTAL ESTIMATED COSTS ($) | ||||||||||||||||||||||||||||
| Fee/Profit ($) | ||||||||||||||||||||||||||||
| Fee/Profit (%) | ||||||||||||||||||||||||||||
| TOTAL ($) | ||||||||||||||||||||||||||||
| Offeror to fill out this template in accordance with the CLIN breakout in the J-11 Summary Matrix. | ||||||||||||||||||||||||||||
| Round cost values to whole dollars. | ||||||||||||||||||||||||||||
| Link values on this form with values/equations on Worksheet 2f. Do not just paste values where value can be linked to another form. | ||||||||||||||||||||||||||||
| Sub totals must calculate within this form and not be linked to other forms | ||||||||||||||||||||||||||||
| Link each cell containing the Material Costs, Major Sub-Contractor Costs, Other Sub-Contractors Costs, Interorganizational Transfer Costs, Labor Category Costs (number of hours), and Other Direct Costs with the unburdened values in Worksheet 2e or 2g, where applicable. Link each cell containing rates to appropriate cells in Worksheet 2f. | ||||||||||||||||||||||||||||
| Calculations with rates computed on this form shall link to rates from Worksheet 2f and material and labor costs from Worksheet 2d or 2g. | ||||||||||||||||||||||||||||
| Cost basis for application of Material Overhead, Indirect Labor Rates, G&A and FCCM must link to value(s) contained in Worksheet 2f. | ||||||||||||||||||||||||||||
| Categories provided are for example only, link categories to actual categories listed in Worksheet 2f | ||||||||||||||||||||||||||||
| All values shall be bid in accordance with Offeror's Accounting System Disclosure Statement (OH, Fringe, etc.) | ||||||||||||||||||||||||||||
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2c |
2d (Eng Svcs Breakout)
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2d | |||||||||||||||||||||||||||
| Cost Summary Detail for CLINs 0002, 1001, and 2001 (Offeror shall provide a separate sheet for each CLIN) | |||||||||||||||||||||||||||
| Major Cost Element | CY18 | CY19 | CY20 | CY21 | CY22 | CY23 | CY24 | CY25 | TOTAL | ||||||||||||||||||
| Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | Total $ | |
| Material | |||||||||||||||||||||||||||
| Material Overhead | |||||||||||||||||||||||||||
| Major Subcontracts | |||||||||||||||||||||||||||
| Other Subcontracts | |||||||||||||||||||||||||||
| Interorganizational Transfer | |||||||||||||||||||||||||||
| Total Material | |||||||||||||||||||||||||||
| Labor | |||||||||||||||||||||||||||
| Administrative | |||||||||||||||||||||||||||
| Category/Personnel | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| Administrative Indirect Rates | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| Program Management | |||||||||||||||||||||||||||
| Category/Personnel | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| Program Management Indirect Rates | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| Engineering | |||||||||||||||||||||||||||
| Category/Personnel | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| Engineering Indirect Rates | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| * | |||||||||||||||||||||||||||
| Total Labor | |||||||||||||||||||||||||||
| SUBTOTAL COSTS ($) | |||||||||||||||||||||||||||
| G&A Expense ($) | |||||||||||||||||||||||||||
| SUBTOTAL COSTS ($) | |||||||||||||||||||||||||||
| Facilities Capital Cost of Money (FCCM) ($) | |||||||||||||||||||||||||||
| TOTAL ESTIMATED COSTS ($) | |||||||||||||||||||||||||||
| Fee ($) | |||||||||||||||||||||||||||
| Fee (%) | |||||||||||||||||||||||||||
| TOTAL ESTIMATED COSTS ($) Plus Fixed Fee | |||||||||||||||||||||||||||
| ** Shall be bid in accordance with Offeror's Accounting System Disclosure Statement (OH, Fringe, etc.) | |||||||||||||||||||||||||||
| Major Cost Element | CY18 | CY19 | CY20 | CY21 | CY22 | CY23 | CY24 | CY25 | |||||||||||||||||||
| Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | ||||
| Total Labor (Hours) | |||||||||||||||||||||||||||
| TOTAL Estimated COSTS ($) Plus Fixed Fee | |||||||||||||||||||||||||||
| Composite Rate through Fee | |||||||||||||||||||||||||||
| Labor Category | CLIN 0002 | CLIN 1001 | CLIN 2001 | Total Hours | |||||||||||||||||||||||
| Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | Hours | Rate | SubTotal $ | |||||||||||||||||||
| TOTAL CLIN COST | |||||||||||||||||||||||||||
| Prepare one of these forms for each CLIN as specified on J-11 (Summary Matrix) | |||||||||||||||||||||||||||
| If composite rates are used, provide the calculations used in deriving the composite rates. | |||||||||||||||||||||||||||
| Round cost values to whole dollars, Round Rates to two decimal points and G&A and FCCM to three decimal points. | |||||||||||||||||||||||||||
| Link values on this form with values/equations on other forms. Do not just paste values where value can be linked to another form. | |||||||||||||||||||||||||||
| If Subcontractor hours/costs are proposed, Offerors shall provide a separate Worksheet 2d for each Subcontractor with costs linked. | |||||||||||||||||||||||||||
| Categories provided are for example only, link categories to actual categories listed on Worksheet 2f. | |||||||||||||||||||||||||||
| Rate cells should be linked to the rates Worksheet 2f. Total values shall be computed in this form. | |||||||||||||||||||||||||||
| Provide equations for Total Cost computation. | |||||||||||||||||||||||||||
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2d |
2e (WBS)
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2e | |||||||||||||||||||||||||||||||||||||||||||||||||
| Cost Summary Table by Contract WBS for CLIN 0001 | |||||||||||||||||||||||||||||||||||||||||||||||||
| CLIN Total | CY18 | CY19 | |||||||||||||||||||||||||||||||||||||||||||||||
| WBS | Description | BOE ID | Cost Element | Hours | Direct Labor | Fringe | Overhead | Subcontractor | SubK Overhead | Material | Material Overhead | G&A | FCCM | Total Costs | Target Fee (Completion) | Min Fee | Max Fee | Total Fee | Total Price (Cost Plus Target Fee) | Cost Element | Hours | Direct Labor | Fringe | Overhead | Subcontractor | SubK Overhead | Material | Material Overhead | G&A | FCCM | Total Costs | Target Fee (Completion) | Min Fee | Max Fee | Total Fee | Total Price (Cost Plus Target Fee) | Cost Element | Hours | Direct Labor | Fringe | Overhead | Subcontractor | SubK Overhead | Material | Material Overhead | G&A | FCCM | Total Costs | Target Fee (Completion) |
| Line Item | |||||||||||||||||||||||||||||||||||||||||||||||||
| 1.0 | Navy ECDIS SW - Production Build 1.1 | ||||||||||||||||||||||||||||||||||||||||||||||||
| * Sample WBS Structure | |||||||||||||||||||||||||||||||||||||||||||||||||
| Totals | |||||||||||||||||||||||||||||||||||||||||||||||||
| Prepare one of these forms for each CLIN as specified on J-11 (Summary Matrix). | |||||||||||||||||||||||||||||||||||||||||||||||||
| Round cost values to whole dollars. | |||||||||||||||||||||||||||||||||||||||||||||||||
| Total values shall be computed in the form. | |||||||||||||||||||||||||||||||||||||||||||||||||
| Cells containing the Material Costs, Major Sub-Contractor Costs, Other Sub-Contractors Costs, Inter-Organizational Transfer Costs, Labor Category Costs (number of hours), and Other Direct Costs in this form are Industry Inputs. | |||||||||||||||||||||||||||||||||||||||||||||||||
| Link each cell containing rates to appropriate cells in Worksheet 2f. | |||||||||||||||||||||||||||||||||||||||||||||||||
| Total Costs shall be through FCCM. Do not input or paste values where values can be derived through formulas. | |||||||||||||||||||||||||||||||||||||||||||||||||
| Add additional columns for additional labor, material and sub-contractor costs as required. | |||||||||||||||||||||||||||||||||||||||||||||||||
| The formulas in this form shall compute the appropriate parent/child cost roll up relationships. | |||||||||||||||||||||||||||||||||||||||||||||||||
| The Offeror shall define the WBS Structure to include clear descriptions of the lower level WBS element in the appropriate columns. | |||||||||||||||||||||||||||||||||||||||||||||||||
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2e |
2f (Rate Summary)
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2f | ||||||||
| Cost Category | ||||||||
| Rates Category | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 |
| Material Overhead | ||||||||
| Category 1 | ||||||||
| Category 2 | ||||||||
| Category n | ||||||||
| Direct Labor Rate | ||||||||
| Category 1 | ||||||||
| Category 2 | ||||||||
| Category n | ||||||||
| Indirect Rate | ||||||||
| Category 1 | ||||||||
| Category 2 | ||||||||
| Category n | ||||||||
| General & Adminstrative Rate | ||||||||
| Category 1 | ||||||||
| Category 2 | ||||||||
| Category n | ||||||||
| Facility Capital Cost of Money Rate | ||||||||
| Category 1 | ||||||||
| Category 2 | ||||||||
| Category n | ||||||||
| Other Rate | ||||||||
| Category 1 | ||||||||
| Category 2 | ||||||||
| Category n | ||||||||
| * | ||||||||
| * | ||||||||
| * | ||||||||
| Category N | ||||||||
| These rates shall be linked to rates cells in Worksheets 2a, 2b, 2c, 2d, 2e for each applicable CLIN identified in J-11 (Summary Matrix). | ||||||||
| Round cost values to whole dollars, Round Rates to two decimal points and G&A and FCCM to five (5) decimal points. | ||||||||
| Rate categories shall include all rates used in this proposal. | ||||||||
| Categories listed are for example only, provide actual categories included in the proposal. | ||||||||
| If composite rates are used, provide the calculations used in deriving the composite rates. | ||||||||
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2f |
2g (BOM)
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2g | ||||||||||||
| Bill of Material (BOM) for CLIN 0001 | ||||||||||||
| Item # | WBS | BOE ID | Part Number | Part Description | Supplier | Qty | Unit Price | Extended Price | Material OH | G&A | FCCM | Total |
| Prepare one of these forms for each CLIN as specified on J-11 (Summary Matrix). | ||||||||||||
| Round cost values to whole dollars. | ||||||||||||
| Total values shall be computed in the form. | ||||||||||||
| Link each cell containing rates to appropriate cells in Worksheet 2f. | ||||||||||||
| Add additional columns for applicable rates as needed. | ||||||||||||
| Total Costs shall be through FCCM. Do not input or paste values where values can be derived through formulas. | ||||||||||||
| N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11 2g |
2h (SLOC Table)
| SOFTWARE LINES OF CODE SUMMARY | ||||||||||||||||||||||||||||||||||||||||
| TOTAL DEVELOPMENT | ||||||||||||||||||||||||||||||||||||||||
| Activity Description | Description of Historic Effort | Historic Performance | Planned Effort Sizing (RAW SLOC PROGRAM SIZE (DSLOC)) | DSLOC to ESLOC Conversion Calculations | Planned Performance | |||||||||||||||||||||||||||||||||||
| WBS | CSCI | Performing Agent | Functional Purpose and Description (Reference Technical Section) | BOE Number (Reference Proposal Volume, Section, Book, and Page) | Historic Effort (Program/CSCI) | Programming Language | Counting Tool | |||||||||||||||||||||||||||||||||
| (UCC or CLOC) | Output for Total DSLOC | Output for Blank DSLOC | Output for Comments Whole DSLOC | Output for Comments Embedded DSLOC | Output for Logical DSLOC | Latest Completed Development Effort | Contract Number | Year Completed | ESLOC Count | DCTI Hours | Justification for Changes from Historic Source | Programming Language | New | Modified | Reuse | NDI or Verbatim | Machine Generated | Deleted | Other | Total Logical DSLOC | Total Physical DSLOC | Total Physical DSLOC with Comments & Blank Lines | Justification for ESLOC Conversion Factors | New to ESLOC | Modified to ESLOC | Reuse to ESLOC | NDI or Verbatim to ESLOC | Machine Generated to ESLOC | Deleted to ESLOC | Other to ESLOC | Total | |||||||||
| ESLOC | Justification for ESLOC/Hour Metric | ESLOC/ Hour | TOTAL HOURS | |||||||||||||||||||||||||||||||||||||
| #.# | Historic Performance | |||||||||||||||||||||||||||||||||||||||
| #.#.# | Primary Function(s) | |||||||||||||||||||||||||||||||||||||||
| #.#.#.# | ||||||||||||||||||||||||||||||||||||||||
| Prime | <All New Code> | C++ | - 0 | N/A | N/A | N/A | N/A | N/A | No existing code for X. Adding 1,000,000 for new functionality | C++ | 1,000,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 1,000,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 1,000,000 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 1,000,000 | ||||||||||||||
| Prime | Program X (AN/SXX-YY)/ CSCI Z | C++ | 500,000 | Program X Development | NXXXXX-XX-C-XXXX | XX | 100,000 | 100,000 | Adding 75,000 SLOC for Y functionality. Reusing 75,000 for similar effort. Removing 25,000 for non-applicable effort | C++ | 75,000 | 25,000 | 50,000 | 25,000 | 150,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 0.01 | 92,750 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 92,750 | ||||||||||||||||
| Subcontractor A | : | |||||||||||||||||||||||||||||||||||||||
| Subcontractor B | : | |||||||||||||||||||||||||||||||||||||||
| #.#.#.# | ||||||||||||||||||||||||||||||||||||||||
| Prime | <All New Code> | C++ | - 0 | N/A | N/A | N/A | N/A | N/A | No existing code for X. Adding 1,000,000 for new functionality | C++ | 1,000,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 1,000,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 1,000,000 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 1,000,000 | ||||||||||||||
| Prime | Program X (AN/SXX-YY)/ CSCI Z | C++ | 500,000 | Program X Development | NXXXXX-XX-C-XXXX | XX | 100,000 | 100,000 | Adding 75,000 SLOC for Y functionality. Reusing 75,000 for similar effort. Removing 25,000 for non-applicable effort | C++ | 75,000 | 25,000 | 50,000 | 25,000 | 150,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 0.01 | 92,750 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 92,750 | ||||||||||||||||
| Subcontractor A | : | |||||||||||||||||||||||||||||||||||||||
| Subcontractor B | : | |||||||||||||||||||||||||||||||||||||||
| Prime | <All New Code> | C++ | - 0 | N/A | N/A | N/A | N/A | N/A | No existing code for X. Adding 1,000,000 for new functionality | C++ | 1,000,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 1,000,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 1,000,000 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 1,000,000 | ||||||||||||||
| Prime | Program X (AN/SXX-YY)/ CSCI Z | C++ | 500,000 | Program X Development | NXXXXX-XX-C-XXXX | XX | 100,000 | 100,000 | Adding 75,000 SLOC for Y functionality. Reusing 75,000 for similar effort. Removing 25,000 for non-applicable effort | C++ | 75,000 | 25,000 | 50,000 | 25,000 | 150,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 0.01 | 92,750 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 92,750 | ||||||||||||||||
| Subcontractor A | : | |||||||||||||||||||||||||||||||||||||||
| Subcontractor B | : | |||||||||||||||||||||||||||||||||||||||
| : | ||||||||||||||||||||||||||||||||||||||||
| : | ||||||||||||||||||||||||||||||||||||||||
| Support Software | ||||||||||||||||||||||||||||||||||||||||
| -(Components) | ||||||||||||||||||||||||||||||||||||||||
| : | ||||||||||||||||||||||||||||||||||||||||
| Totals | ||||||||||||||||||||||||||||||||||||||||
| #.# | Contract Performance | |||||||||||||||||||||||||||||||||||||||
| #.#.# | Primary Function(s) | |||||||||||||||||||||||||||||||||||||||
| #.#.#.# | ||||||||||||||||||||||||||||||||||||||||
| Prime | <All New Code> | C++ | - 0 | N/A | N/A | N/A | N/A | N/A | No existing code for X. Adding 1,000,000 for new functionality | C++ | 1,000,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 1,000,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 1,000,000 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 1,000,000 | ||||||||||||||
| Prime | Program X (AN/SXX-YY)/ CSCI Z | C++ | 500,000 | Program X Development | NXXXXX-XX-C-XXXX | XX | 100,000 | 100,000 | Adding 75,000 SLOC for Y functionality. Reusing 75,000 for similar effort. Removing 25,000 for non-applicable effort | C++ | 75,000 | 25,000 | 50,000 | 25,000 | 150,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 0.01 | 92,750 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 92,750 | ||||||||||||||||
| Subcontractor A | : | |||||||||||||||||||||||||||||||||||||||
| Subcontractor B | : | |||||||||||||||||||||||||||||||||||||||
| #.#.#.# | ||||||||||||||||||||||||||||||||||||||||
| Prime | <All New Code> | C++ | - 0 | N/A | N/A | N/A | N/A | N/A | No existing code for X. Adding 1,000,000 for new functionality | C++ | 1,000,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 1,000,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 1,000,000 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 1,000,000 | ||||||||||||||
| Prime | Program X (AN/SXX-YY)/ CSCI Z | C++ | 500,000 | Program X Development | NXXXXX-XX-C-XXXX | XX | 100,000 | 100,000 | Adding 75,000 SLOC for Y functionality. Reusing 75,000 for similar effort. Removing 25,000 for non-applicable effort | C++ | 75,000 | 25,000 | 50,000 | 25,000 | 150,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 0.01 | 92,750 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 92,750 | ||||||||||||||||
| Subcontractor A | : | |||||||||||||||||||||||||||||||||||||||
| Subcontractor B | : | |||||||||||||||||||||||||||||||||||||||
| Prime | <All New Code> | C++ | - 0 | N/A | N/A | N/A | N/A | N/A | No existing code for X. Adding 1,000,000 for new functionality | C++ | 1,000,000 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | 1,000,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 1,000,000 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 1,000,000 | ||||||||||||||
| Prime | Program X (AN/SXX-YY)/ CSCI Z | C++ | 500,000 | Program X Development | NXXXXX-XX-C-XXXX | XX | 100,000 | 100,000 | Adding 75,000 SLOC for Y functionality. Reusing 75,000 for similar effort. Removing 25,000 for non-applicable effort | C++ | 75,000 | 25,000 | 50,000 | 25,000 | 150,000 | Software Cost Estimating Package X, including modifications to those conversion factors. | 1.0 | 0.5 | 0.1 | 0.01 | 92,750 | Historic productivity on Program X (AN/SXX-YY)/ CSCI Z during NXXXXX-XX-C-XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, with XX% Adjustment for XXXX, etc | 1.0 | 92,750 | ||||||||||||||||
| Subcontractor A | : | |||||||||||||||||||||||||||||||||||||||
| Subcontractor B | : | |||||||||||||||||||||||||||||||||||||||
| : | ||||||||||||||||||||||||||||||||||||||||
| : | ||||||||||||||||||||||||||||||||||||||||
| Support Software | ||||||||||||||||||||||||||||||||||||||||
| -(Components) | ||||||||||||||||||||||||||||||||||||||||
| : | ||||||||||||||||||||||||||||||||||||||||
| Totals: |
Instructions for 2h
| Instructions for Worksheet 2h (SLOC Table) | |
| Prepare in accordance with Contractor proposed Work Breakdown Structure (WBS) (Attachment J-11 Worksheet 2e) for all software development efforts. | |
| Provide information at the Computer Software Configuration Item (CSCI) level and, where appropriate, at the Computer Software Component (CSC) level or Computer Software Unit (CSU) level in order to document historical SLOC planned for modification or reuse. Detail at the CSC level and/or CSU level is also requested when more than one contractor or sub-contractor is performing work within that CSCI. | |
| CSCI: An aggregation of software that is designated for configuration management (CM) and treated as a single entity in the CM process. | |
| CSC: A functional or logically distinct part of a CSCI. A CSC is typically an aggregate of two or more CSUs. | |
| CSU: Smallest subdivision of a Computer Software Configuration Item (CSCI) for the purposes of engineering management. CSUs are typically separately compilable pieces of code. | |
| ACTIVITY DESCRIPTION | |
| Performing Agent: Break out by prime contractor and any sub contractor(s) on additional rows for each CSCI (excluding subcontractor(s), if any, that provide(s) a separate Worksheet 2h whose effort is not rolled into this Worksheet 2h). | |
| If a subcontractor submits a separate Worksheet 2h, the prime Worksheet 2h shall include completed rows for the subcontract in the following columns: T through AC, AL, AN and AO. These entries shall match the subcontractor submission, if any. | |
| Functional Purpose and Description: Clearly identify/describe each CSCI, including purpose/use of support software components. Reference to the location within the technical package is acceptable. | |
| BOE Number: Cite the Basis of Estimate (BOE) for each CSCI | |
| DESCRIPTION OF HISTORIC EFFORT | |
| Historic Effort: Cite the source (Program and CSCI) of the modified and reused software. | |
| If the estimated modified and reused SLOC is greater than the historic effort (i.e. SLOC available for reuse), provide detailed justification for the source of the additional estimated modified/reuse SLOC. | |
| If multiple historic efforts are being used for one CSCI, add rows to show all of the historic effort sources. | |
| Programming Language: Provide the programming language used for the historic effort. | |
| Counting Tool: The USC Unified Code Counting (UCC) Tool (Release 2011.10) shall be used for any supported language. For languages not supported by UCC, the Count Lines of Code (CLOC) Tool (v.1.58) shall be used. The column shall reflect the tool utilized for the respective historic effort. | |
| Output for Total DSLOC: Report the total Delivered Source Lines of Code (DSLOC) for the cited historical effort as counted by the USC Unified Code Counting (UCC) Tool (Release 2011.10) or CLOC (v.1.58) output for "total lines." | |
| Output for Blank DSLOC: Report the blank Delivered Source Lines of Code (DSLOC) for the cited historical effort as counted by the USC Unified Code Counting (UCC) Tool (Release 2011.10) or CLOC (v.1.58) output for "blank lines." | |
| Output for Comments Whole DSLOC: Report the whole comments Delivered Source Lines of Code (DSLOC) for the cited historical effort as counted by the USC Unified Code Counting (UCC) Tool (Release 2011.10) output for "comments whole" or CLOC (v.1.58) output for "comments." | |
| Output for Comments Embedded DSLOC: Report the embedded comments Delivered Source Lines of Code (DSLOC) for the cited historical effort as counted by the USC Unified Code Counting (UCC) Tool (Release 2011.10) output for "comments embedded." | |
| Output for Logical DSLOC: Report the logical Delivered Source Lines of Code (DSLOC) for the cited historical effort as counted by the USC Unified Code Counting (UCC) Tool (Release 2011.10) output for "logical SLOC" or CLOC (v.1.58) equivalent output "code." | |
| HISTORIC PERFORMANCE (WHERE APPLICABLE) | |
| Latest Completed Development Effort: Cite the last completed effort where the historic CSCI was modified. | |
| If a historic CSCI is being split into multiple CSCI's, cite the percentage split of the historic CSCI for each CSCI. The total of percentages should equal to 100%. | |
| Contract Number: Cite the contract on which the modification of the historic CSCI occurred. | |
| Year Completed: Provide the year when this effort was completed. | |
| ESLOC Count: Provide Equivalent SLOC (ESLOC) count for effort. | |
| DCTI Hours: Design, Code, Test, & Integration (DCTI) hours spent on that CSCI | |
| Of the IEEE 12207 Development Process Activities: | |
| 1.0 Process Implementation | |
| 2.0 System Requirements Analysis | |
| 3.0 System Architectural Design | |
| 4.0 Software Requirements Analysis | |
| 5.0 Software Architectural Design | |
| 6.0 Software Detailed Design | |
| 7.0 Software Coding and Test | |
| 8.0 Software Integration | |
| 9.0 Software Qualification Testing | |
| 10.0 System Integration | |
| 11.0 System Qualification Testing | |
| 12.0 Software Installation | |
| 13.0 Software Acceptance Testing | |
| DCTI hours include: | |
| 6.0 Software Detailed Design | |
| 7.0 Software Coding and Test | |
| 8.0 Software Integration | |
| CONTRACT PERFORMANCE | |
| Justification for Changes from Historic Source: Provide a description of how the legacy code will be modified for the new development effort, including description of new functionality and removed functionality. | |
| Programming Language: Provide the programming language for the development effort. | |
| DCTI = Preliminary & Detailed Design, Code, CSCI Testing, and SW Integration Testing | |
| From IEEE 12207, DCTI hours include: | |
| 6.0 Software Detailed Design | |
| 7.0 Software Coding and Test | |
| 8.0 Software Integration | |
| Provide descriptions of Source Lines of Code (SLOC) allocation categories (New, Modified, Reuse, NDI, Verbatim, Deleted, Other) in the BOE | |
| Software Definitions: | |
| 1. NEW CODE: This represents new source statements or existing source statements requiring significant modifications, wherein significant is defined as any logical block of related code (class, module, function) where more than 50% of the lines will be newly written or modified. | |
| 2. MODIFIED CODE: This represents source statements that exist but required modification, wherein modification is limited to changing 15 – 50% of a single source statement. | |
| 3. REUSE CODE: The represents source statements that currently exist and require minimal modification, wherein minimal is defined less than 15% changes to a single source statement. | |
| 4. NDI or VERBATIM CODE: This represents intact executable modules (example: COTS, GOTS) and no changes or maintenance is planned. It excludes Machine Generated Code. | |
| 5. MACHINE GENERATED CODE: This represents a subset of VERBATIM code which is listed separately. These source statements are automatically generated by software applications which allow tracing of actions. | |
| 6. DELETED CODE: This represents source statements that currently exist and are removed from the software component due to no modification or reuse. | |
| 7. DSLOC: Delivered software lines of code | |
| 8. ESLOC: Equivalent software lines of code | |
| Total Logical DSLOC: Sum of New, Modified and Reused Code | |
| Total Physical DSLOC: Total Delivered Software Lines Of Code, excluding comments and blanks. | |
| Total Physical DSLOC with Comments & Blank Lines: Total Delivered Software Lines Of Code, including comments and blanks. | |
| DSLOC TO ESLOC CONVERSION CALCULATIONS | |
| Justification for ESLOC Conversion Factors: Provide the source for the ESLOC conversion factors, including any modifications applied. If ESLOC conversion factors differ from industry rule of thumb of 1.0 (New), 0.5 (Modified), 0.1 (Reused), provide supporting data and calculations. | |
| NEW to ESLOC: Inverse of number of new lines of code per ESLOC (1 / (New Lines of Code per ESLOC) | |
| Modified to ESLOC: Inverse of number of modified lines of code per ESLOC (1 / (Modified Lines of Code per ESLOC) | |
| Reuse to ESLOC: Inverse of number of reused lines of code per ESLOC (1 / (Reused Lines of Code per ESLOC) | |
| NDI or Verbatim to ESLOC: Inverse of number of NDI/Verbatim lines of code per ESLOC (1 / (NDI/Verbatim Lines of Code per ESLOC) | |
| Machine Generated to ESLOC: Inverse of number of machine generated lines of code per ESLOC (1 / (Machine Generated Lines of Code per ESLOC) | |
| Deleted to ESLOC: Inverse of number of deleted lines of code per ESLOC (1 / (Deleted Lines of Code per ESLOC) | |
| Other to ESLOC: Inverse of number of other lines of code per ESLOC (1 / (Other Lines of Code per ESLOC) | |
| Total ESLOC: Sum of each code type (New/Modified/Reused/NDI/Machine Generated/Deleted/Other) multiplied by their DSLOC to ESLOC Conversion Factor | |
| Planned Performance | |
| Justification for ESLOC/Hour Metric: Provide source of the ESLOC per hour factor, including any modifications applied. | |
| ESLOC/ Hour: Provide the software productivity factor for the CSCI. | |
| TOTAL HOURS: Total ESLOC/ (ESLOC/ Hour) |
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. Updated .