Attachment_25_-_Section_L_Attachment_Cost_Evaluation_Workbook.xlsx

Sheet1

1. Government Estimate

Attachment 25 Section L Attachment: Cost Evaluation Workbook

2. Offeror Summaries

&"Arial,Regular"N00024-13-R-5100 J-25 Section L Attachment:

Cost Evaluation Workbook &"Arial,Regular"&A

2a. Total Cost Summary

EXAMPLE

Instructions: The Offeror shall summarize its proposed costs using a similar format to the example presented herein. The cost summaries shall show the proposed direct labor hours and costs (by labor category), all indirect costs, unburdened direct material (i.e., subcontractor or material costs), the Offeror’s subcontractor pass through costs, and fee by calendar year and CLIN. In addition, for CLINs 0003-0006 and 0010-0012, the offeror shall segregate its proposed hours and costs by 3rd digit WBS element (e.g., WBS 1.2.3, Detailed Design) in accordance with the WBS structure provided under Attachment J-31. Formulas shall be maintained in the Excel sheet so that the Government may verify proper application of rates and calculation of costs. All rates must be linked to a single source (Attachment J-25, Worksheet 2d) so that an adjustment of the rates stated in the source worksheet will automatically result in an adjustment to all the cost summaries. The only manual inputs in this spreadsheet should be the proposed hours for the Prime and Subcontractors, as well as proposed subcontractor and material (if applicable) costs. (Note: AWS Element Assessments, Travel, ODCs and incidental material costs as defined in Section C of the RFP shall not be included in this spreadsheet). The purpose of this spreadsheet is to allow the Government to easily verify the application of rates and calculations of costs, make adjustments, if necessary, and have flexibility to create pivot tables for data analysis. Cost elements should match the categories described in Worksheet 2d of this Workbook. The formulas contained herein must not be linked to worksheets not included in this workbook. Each Worksheet (i.e., each worksheet for each calendar year) shall have identical values in Columns B and C, such that the Total Cost Summary is a just a summation of the same cell in each worksheet.

&"Arial,Regular"N00024-13-R-5100 J-25 Section L Attachment: Cost Evaluation Worksheet &"Arial,Regular"&A

2a. CY2013

2a. CY2014

2a. CY2018

2b. Proposed Mix Instructions: The Offeror shall populate this spreadsheet with the proposed hours (by option year) for each CLIN. The total proposed hours must be the sum of the prime + subcontractor hours. Offerors may not add new labor categories to this mix.

2c. Gov-Ktr Matrix