L-1_Cost_Template_21_November_2016.xlsx

Instructions

The Government requests each vendor submit this template in addition to the full basis of estimate as outlined in the RFP/SOW. If use of the template is problematic, please explain why and offer an alternative means of documenting the basis of estimate associated with each CLIN. Use of the template to document the basis of estimate does not circumvent or replace vendor purchasing or estimating systems; rather, the template is a tool to summarize data from vendor purchasing and estimating systems on a consistent basis to support the source selection process.

Unit Cost Calculation SOW Requirement 3.2.1: Lot 1 CAC2S FDUs (CLINs 0001, 0002, 0003, 0004, 0010, 0011) SOW Requirement 3.2.2: Lot 2 CAC2S FDUs (CLINs 0101, 0102, 0109, 0110) SOW Requirement 3.2.3: Lot 3 CAC2S FDUs (CLINs 0201, 0202, 0207, 0208) SOW Requirement 3.2.4: Lot 4 CAC2S FDUs (CLINs 0301, 0306)

Grand Total $ - 0 Grand Total $ - 0 Grand Total $ - 0 Grand Total $ - 0 Grand Total $ - 0 Grand Total $ - 0 Grand Total $ - 0 Grand Total $ - 0 Grand Total $ - 0

Total Price by CLIN

This sheet represents a roll up of all CLIN cost/price data from the detailed CLIN tabs. The grey cells indicate that they should not be populated with a cost, i.e., FFP CLINs do not have an associated Fixed Fee, therefore it is N/A. Cells highlighted in blue indicate a Reserved CLIN and are also N/A.

CLIN-CWBS Summary

0002 1.1.1.4

This sheet represents CWBS for each CLIN in which work will be accomplished and associated cost/price accounting will take place.

CLIN0001

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0002

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0003

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0004

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0005

THIS CONTRACT LINE ITEM NUMBER IS NOT SEPARATELY PRICED. ANY COSTS ASSOCIATED WITH THIS CLIN SHOULD BE PRICED INTO ITS RESPECTIVE CLIN.

CLIN0006

THIS CONTRACT LINE ITEM NUMBER IS RESERVED FOR FUTURE USE.

CLIN0007

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

For the purpose of proposing the requirement only, Engineering Studies are estimated to be medium complexity, 320 hours.

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0008

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

For the purpose of proposing the requirement only, the estimated cost of GFE Repair is $50K per year.

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0009

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

For the purpose of proposing the requirement only, when TRs are included in a software build, the following assumptions should be made for each associated build:

a) There will be 50 TRs included in each build

b) Of the 50 TRs,

1. 10% will be maintain a complexity of 'hard', defined as requiring more than 80 hours to analyze, implement, integrate and verify;

2. 50% will be maintain a complexity of 'medium', defined as requiring less than 80 hours to analyze, implement, integrate and verify;

3. 40% will be maintain a complexity of 'easy', defined as requiring less than 16 hours to analyze, implement, integrate and verify.

For the purpose of proposing the requirement only, the Government anticipates (3) analyses per year of medium complexity not to exceed (300) hours per year.

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0010

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0011

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0101

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0102

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0103

THIS CONTRACT LINE ITEM NUMBER IS NOT SEPARATELY PRICED. ANY COSTS ASSOCIATED WITH THIS CLIN SHOULD BE PRICED INTO ITS RESPECTIVE CLIN.

CLIN0104

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0105

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0106

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

For the purpose of proposing the requirement only, Engineering Studies are estimated to be medium complexity, 320 hours.

CLIN0107

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

For the purpose of proposing the requirement only, the estimated cost of GFE Repair is $50K per year.

CLIN0108

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

For the purpose of proposing the requirement only, when TRs are included in a software build, the following assumptions should be made for each associated build:

a) There will be 50 TRs included in each build

b) Of the 50 TRs,

1. 10% will be maintain a complexity of 'hard', defined as requiring more than 80 hours to analyze, implement, integrate and verify;

2. 50% will be maintain a complexity of 'medium', defined as requiring less than 80 hours to analyze, implement, integrate and verify;

3. 40% will be maintain a complexity of 'easy', defined as requiring less than 16 hours to analyze, implement, integrate and verify.

For the purpose of proposing the requirement only, the Government anticipates (3) analyses per year of medium complexity not to exceed (300) hours per year.

CLIN0109

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0110

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0201

Methods of cost estimating

Calculations

Labor function

Description of each labor category

Cross-checks used to verify reasonableness

This sheet represents detailed CLIN cost/price data by Government Fiscal Year (GFY). Cost elements identified in Column A are provided as representative cost elements, but can be tailored as necessary at the sub-element level. The costs/formulas on this sheet should be supported by the Materials, Rates, ODCs, and Travel tabs in this Workbook as well as the Basis of Estimate per Section L.

CLIN0202