Attachment 3_CPFF_Pricing_Spreadsheet.xls

XLS spreadsheet 189 KB Posted

Attached to
MHE and SMSE Maintenance Services Federal contract opportunity
Solicitation number
N0018921R0010
Issued by
Department of the Navy Naval Supply Systems Command

View the file

Other files for this federal contract opportunity

Other files attached to MHE and SMSE Maintenance Services, newest first.
File Type Posted
2.06 Questions and Answers.pdf PDF
2.06 N0018921R0010 Amendment 1.pdf PDF
Attachment 5_PAST PERFORMANCE REPORT FORM.docx DOCX document
Attachment 1_CONTRACTOR_DISCREPANCY_REPORT.docx DOCX document
N0018921R0010.pdf PDF
Attachment 2_ WD 2015-4341.docx DOCX document
Attachment 4_PAST PERFORMANCE INFORMATION FORM.docx DOCX document

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions General Information In accordance with Section L of the solicitation offerors are required to complete and submit a Cost Summary with their proposal submission. This excel workbook, which is provided as Attachment 5 to the RFP, provides a template for offerors to use in the preparation of their Cost/Price proposal. The intent is not to restrict the offerors in the manner in which they develop their cost and pricing information but rather to ensure a certain degree of uniformity in the format of the responses for evaluation purposes. NOTE: Information provided in this template is not a complete representation of the cost/price information required by Section L of the RFP in terms of both the Basic Cost Information and the Itemized Cost Proposal as specified within Section III-3 of Section L. Completing this template does not alleviate offerors of providing any additional information required by Section L of the RFP. It is the responsibility of the offeror to ensure all formulas are accurate and correct. Offerors shall ensure the required information is provided for each of the performance periods listed within Section F.

Overall Summary Sheet The intent of this sheet is to provide a consolidated summary of the CLINS within Section B of the RFP. The offeror shall ensure the Overall Summary Sheet matches the pricing provided within Section B.

CPFF Summary Sheet The intent of this sheet is to provide the cost/price evaluators with an overall cost element summary by performance period. The provided template is meant to provide a general sample of how the information should be presented. The Government recognizes that offerors present their cost information in different formats and may utilize different nomenclature for certain cost elements; therefore, offerors are permitted to make general modifications (e.g. cost element structure and addition of cost elements that are not list).

Labor Summary Sheets The intent of these sheets is to provide a uniformed format for offerors to provide level of effort information broken down by prime and subcontractors for each CLIN within Section B of the RFP. The provided format will allow evaluators to streamline their review of labor allocation for the estimated level of effort by CLIN.

CPFF Detail Sheets The intent of these sheets is to provide a general format for offerors to use to present their detailed cost information. The Staffing Inputs and Cost Information section column headings are provided as a general sample and format. Additionally the information currently input into the speadsheet is for informational purposes and is intented to be a sample of how the information would be entered. Offerors are permitted to modify column headings nomenclature as well as add/remove columns as nessesary based upon applicability. The purpose of these sheet is to provide for uniformity among offerors detailed cost information and to easily be able to review cost information seperate by the prime and subcontractors (if applicable).

Additional Sheets Since this template is not a complete representation of the cost/price information required by Section L of the RFP, offerors should include additional sheets as nessesary in order to comply with the requirements of the RFP.

Overall Summary

PeriodCLINCostFixed Fee/ Travel/Material/ODC G&A or OHCPFF/Cost (Total)
Base0001$ - 0
0002$ 1,563,705.60$ 1,563,705.60
0003$ 4,220,783.51$ 4,220,783.51
0004$ 322,692.64$ 322,692.64
FAR 52.217-81001$ - 0
1002$ 168,558.48$ 168,558.48
1003$ 454,976.21$ 454,976.21
1004$ 34,784.41$ 34,784.41
Total$ 6,765,500.85

CPFF Summary

CPFF Summary By Performance Period
Cost ElementOrdering Year 1Ordering Year 2Ordering Year 3Ordering Year 4Ordering Year 5FAR 52.217-8 OptionTotal
Direct Labor$ -$ -$ -$ -$ -$ -$ -
Fringe$ -$ -$ -$ -$ -$ -$ -
Overhead$ -$ -$ -$ -$ -$ -$ -
Common Support$ -$ -$ -$ -$ -$ -$ -
G&A$ -$ -$ -$ -$ -$ -$ -
Subcontracting:
Subcontracting Labor$ -$ -$ -$ -$ -$ -$ -
Subcontracting Overhead$ -$ -$ -$ -$ -$ -$ -
Materials$ -$ -$ -$ -$ -$ -$ -
M&S$ -$ -$ -$ -$ -$ -$ -
Subcontracts & Purchasing$ -$ -$ -$ -$ -$ -$ -
Procurement, Subcontracts, & Material$ -$ -$ -$ -$ -$ -$ -
Subcontract Material Handling$ -$ -$ -$ -$ -$ -$ -
G&A$ -$ -$ -$ -$ -$ -$ -
Subcontracting Fee$ -$ -$ -$ -$ -$ -$ -
Subtotal$ -$ -$ -$ -$ -$ -$ -
Fee$ -$ -$ -$ -$ -$ -$ -
FCCM$ -$ -$ -$ -$ -$ -$ -
Total$ -$ -$ -$ -$ -$ -$ -

Labor Summary - Ordering Year 1

Prime Contractor NameSubcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)
Descriptive InformationEst. HoursEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal Cost
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

CPFF Detail - Ordering Year 1

COST INFORMATION
Contract Labor
CategoryResource TypeCompanyExternal SubFunctionCategoryGradeBandSiteTechnology
OverheadGeneral Labor
CategoryEst. HoursLabor RateLabor ValueFringe %Fringe ValueDL + FringeOH %OH ValueComm
Sup %Comm Sup ValueG&A %G&A ValueSubtotalFixed FeeCost
Plus FeeRate/Hr
Ordering Year 1
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

Labor Summary - Ordering Year 2

Prime Contractor NameSubcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)
Descriptive InformationEst. HoursEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal Cost
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

CPFF Detail - Ordering Year 2

COST INFORMATION
Contract Labor
CategoryResource TypeCompanyExternal SubFunctionCategoryGradeBandSiteTechnology
OverheadGeneral Labor
CategoryEst. HoursLabor RateLabor ValueFringe %Fringe ValueDL + FringeOH %OH ValueComm
Sup %Comm Sup ValueG&A %G&A ValueSubtotalFixed FeeCost
Plus FeeRate/Hr
Ordering Year 2
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

Labor Summary - Ordering Year 3

Prime Contractor NameSubcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)
Descriptive InformationEst. HoursEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal Cost
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

CPFF Detail - Ordering Year 3

COST INFORMATION
Contract Labor
CategoryResource TypeCompanyExternal SubFunctionCategoryGradeBandSiteTechnology
OverheadGeneral Labor
CategoryEst. HoursLabor RateLabor ValueFringe %Fringe ValueDL + FringeOH %OH ValueComm
Sup %Comm Sup ValueG&A %G&A ValueSubtotalFixed FeeCost
Plus FeeRate/Hr
Ordering Year 3
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

Labor Summary - Ordering Year 4

Prime Contractor NameSubcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)
Descriptive InformationEst. HoursEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal Cost
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

CPFF Detail - Ordering Year 4

COST INFORMATION
Contract Labor
CategoryResource TypeCompanyExternal SubFunctionCategoryGradeBandSiteTechnology
OverheadGeneral Labor
CategoryEst. HoursLabor RateLabor ValueFringe %Fringe ValueDL + FringeOH %OH ValueComm
Sup %Comm Sup ValueG&A %G&A ValueSubtotalFixed FeeCost
Plus FeeRate/Hr
Ordering Year 4
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

Labor Summary - Ordering Year 5

Prime Contractor NameSubcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)
Descriptive InformationEst. HoursEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal Cost
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

CPFF Detail - Ordering Year 5

COST INFORMATION
Contract Labor
CategoryResource TypeCompanyExternal SubFunctionCategoryGradeBandSiteTechnology
OverheadGeneral Labor
CategoryEst. HoursLabor RateLabor ValueFringe %Fringe ValueDL + FringeOH %OH ValueComm
Sup %Comm Sup ValueG&A %G&A ValueSubtotalFixed FeeCost
Plus FeeRate/Hr
Ordering Year 5
Project Manager1,040
Production Manager2,080
Quality Assurance Inspector2,080
Material Expeditor2,080
Administrative Assistant2,080
Shop Supervisor2,080
MHE/SMSE Engineer Technician12,480
MHE/SMSE Mobile Service Road Engineer Technician6,240
Battery Technician2,080

Labor Summary - FAR 52.217-8

Prime Contractor NameSubcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)Subcontractor Name (if applicable)
Descriptive InformationEst. HoursEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal CostEst. HoursFully Burdened Labor RateTotal Cost
Project Manager520
Production Manager1,040
Quality Assurance Inspector1,040
Material Expeditor1,040
Administrative Assistant1,040
Shop Supervisor1,040
MHE/SMSE Engineer Technician6,240
MHE/SMSE Mobile Service Road Engineer Technician3,120
Battery Technician1,040

CPFF Detail - FAR 52.217-8

COST INFORMATION
Contract Labor
CategoryResource TypeCompanyExternal SubFunctionCategoryGradeBandSiteTechnology
OverheadGeneral Labor
CategoryEst. HoursLabor RateLabor ValueFringe %Fringe ValueDL + FringeOH %OH ValueComm
Sup %Comm Sup ValueG&A %G&A ValueSubtotalFixed FeeCost
Plus FeeRate/Hr
FAR 52.217-8 OPTION
Project Manager520
Production Manager1,040
Quality Assurance Inspector1,040
Material Expeditor1,040
Administrative Assistant1,040
Shop Supervisor1,040
MHE/SMSE Engineer Technician6,240
MHE/SMSE Mobile Service Road Engineer Technician3,120
Battery Technician1,040

File details come from the government source that posted it. Updated .