Attachment_11_-Cost_and_Price_Evaluation_Worksheet_Rev._1_8-2-2017.xls

187 KB Posted

Attached to
U. S Navy Electronic Chart Display and Information System Software
Solicitation number
N00024-17-R-5216
Issued by

About this file

From the source

Attachment 11 - Cost and Price Evaluation Worksheet Rev.1

View the file

Other files

File Type Posted
Q&A_Response_Package_-_Batch_4.pdf PDF
Attachment_11_-Cost_and_Price_Evaluation_Worksheet_Rev._2_8-9-2017.xls XLS spreadsheet
N00024-17-R-5216_Navy_ECDIS_RFP_Amendment_2_-_Conformed_Copy.pdf PDF
N00024-17-R-5216_Navy_ECDIS_RFP_Amendment_2.pdf PDF
N00024-17-R-5216_Navy_ECDIS_RFP_Amendment_1.pdf PDF
N00024-17-R-5216_Navy_ECDIS_RFP_Amendment_1_-_Conformed_Copy.pdf PDF
NAVY_ECDIS_SOFTWARE_(17-R-5216)_SIGNED_CDRLS_DTD_7-27-17.pdf PDF
Q&A_Response_Package_-_Batch_3.pdf PDF
Q&A_Response_Package_-_Batch_2.pdf PDF
Q&A_Response_Package_-_Batch_1.pdf PDF
N00024-17-R-5216_Ex_A_CDRLs_(Searchable_File).pdf PDF
Attachment_12_-_Past_Performance_Questionnaire.docx DOCX document
NAVY_ECDIS_SOFTWARE_(17-R-5216)_SIGNED_CDRLS_DTD_1-31-17.pdf PDF
Attachment_5_-_Terms_of_Use_Letter_-_SRD.docx DOCX document
Attachment_13_-_Contractor_Compliance_Checklist.docx DOCX document
NAVY_(17-R-5216)_ADDRESSEE_LIST_6-15-17.pdf PDF
Attachment_10_-_Offerors_Question_and_Answer_Sheet.xls XLS spreadsheet
Attachment_9_-_Navy_ECDIS_GFI_List_2017-06-12.xlsx XLSX spreadsheet
N00024-17-R-5216_Final_Solicitation.pdf PDF
Attachment_11_-Cost_and_Price_Evaluation_Worksheet.xls XLS spreadsheet
15-NR-46120_DD254_Signed.pdf PDF
Attachment_4_-_Terms_of_Use_Letter_-_COGENT.docx DOCX document
Draft_RFP_QA_-_Batch_2_-_FBO_Posted_6-9-17.pdf PDF
Draft_RFP_Q&A_Response_Packages_-_Batch_1.pdf PDF
Offeror_Question_and_Answer_Sheet.xls XLS spreadsheet
Navy_ECDIS_SW_N00024-17-R-5216_-_Draft_RFP_.docx DOCX document
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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

J-11 (Summary Matrix)

N00024-17-R-5216 Navy ECDIS SW SECTION L COST TABLE ATTACHMENT J-11
CLINDescription2a (CLIN Summary by FY)2b (CLIN Breakout)2c (Breakout by CY)2d (Eng Svcs Breakout)2e (WBS Breakout)2f (Rate Summary)2g (BOM)
CLIN SummarySummary data including all CLINs, excluding CLIN 0004XXXX
0001Navy ECDIS SW 1.0 Production BuildXX
0002Engineering ServicesX
0003Travel and ODC
0004Data
1001Navy ECDIS Software 1.1 (Maintenance Build) Engineering ServicesX
1002Travel and ODC
1003Government Purpose Data Rights/ Licenses
2001Navy ECDIS Software 1.2 (Maintenance Build) Engineering ServicesX
2002Travel 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
CLINFY18FY19FY20FY21FY22FY23FY24FY25FY26TOTAL 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 ElementCLIN 0001CLIN 0002CLIN 0003CLIN 1001CLIN 1002CLIN 1003CLIN 2001CLIN 2002Total
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 TypeCPIFCPFFCOSTCPFFCOSTFFPCPFFCOSTN/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 ElementCY18CY19CY20CY21CY22CY23CY24CY25CY26Total $
Hours/CostRateSubTotal $Hours/CostRateSubTotal $Hours/CostRateSubTotal $Hours/CostRateSubTotal $Hours/CostRateSubTotal $Hours/CostRateSubTotal $Hours/CostRateSubTotal $Hours/CostRateSubTotal $Hours/CostRateSubTotal $
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 ElementCY18CY19CY20CY21CY22CY23CY24CY25TOTAL
HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateTotal $
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 ElementCY18CY19CY20CY21CY22CY23CY24CY25
HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $
Total Labor (Hours)
TOTAL Estimated COSTS ($) Plus Fixed Fee
Composite Rate through Fee
Labor CategoryCLIN 0002CLIN 1001CLIN 2001Total Hours
HoursRateSubTotal $HoursRateSubTotal $HoursRateSubTotal $
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 TotalCY18CY19
WBSDescriptionBOE IDCost ElementHoursDirect LaborFringeOverheadSubcontractorSubK OverheadMaterialMaterial OverheadG&AFCCMTotal CostsTarget Fee (Completion)Min FeeMax FeeTotal FeeTotal Price (Cost Plus Target Fee)Cost ElementHoursDirect LaborFringeOverheadSubcontractorSubK OverheadMaterialMaterial OverheadG&AFCCMTotal CostsTarget Fee (Completion)Min FeeMax FeeTotal FeeTotal Price (Cost Plus Target Fee)Cost ElementHoursDirect LaborFringeOverheadSubcontractorSubK OverheadMaterialMaterial OverheadG&AFCCMTotal CostsTarget Fee (Completion)
Line Item
1.0Navy 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 Category20182019202020212022202320242025
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 #WBSBOE IDPart NumberPart DescriptionSupplierQtyUnit PriceExtended PriceMaterial OHG&AFCCMTotal
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

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 .