Attachment 3_CPFF_Pricing_Spreadsheet.xls
XLS spreadsheet 189 KB Posted
- Attached to
- MHE and SMSE Maintenance Services Federal contract opportunity
- Solicitation number
- N0018921R0010
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 2.06 Questions and Answers.pdf | ||
| 2.06 N0018921R0010 Amendment 1.pdf | ||
| Attachment 5_PAST PERFORMANCE REPORT FORM.docx | DOCX document | |
| Attachment 1_CONTRACTOR_DISCREPANCY_REPORT.docx | DOCX document | |
| N0018921R0010.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
| Period | CLIN | Cost | Fixed Fee/ Travel/Material/ODC G&A or OH | CPFF/Cost (Total) |
| Base | 0001 | $ - 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-8 | 1001 | $ - 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 Element | Ordering Year 1 | Ordering Year 2 | Ordering Year 3 | Ordering Year 4 | Ordering Year 5 | FAR 52.217-8 Option | Total |
| 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 Name | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | ||||||||||||
| Descriptive Information | Est. Hours | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost |
| Project Manager | 1,040 | |||||||||||||||
| Production Manager | 2,080 | |||||||||||||||
| Quality Assurance Inspector | 2,080 | |||||||||||||||
| Material Expeditor | 2,080 | |||||||||||||||
| Administrative Assistant | 2,080 | |||||||||||||||
| Shop Supervisor | 2,080 | |||||||||||||||
| MHE/SMSE Engineer Technician | 12,480 | |||||||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | |||||||||||||||
| Battery Technician | 2,080 |
CPFF Detail - Ordering Year 1
| COST INFORMATION | |||||||||||
| Contract Labor | |||||||||||
| Category | Resource Type | Company | External Sub | Function | Category | Grade | Band | Site | Technology | ||
| Overhead | General Labor | ||||||||||
| Category | Est. Hours | Labor Rate | Labor Value | Fringe % | Fringe Value | DL + Fringe | OH % | OH Value | Comm | ||
| Sup % | Comm Sup Value | G&A % | G&A Value | Subtotal | Fixed Fee | Cost | |||||
| Plus Fee | Rate/Hr | ||||||||||
| Ordering Year 1 | |||||||||||
| Project Manager | 1,040 | ||||||||||
| Production Manager | 2,080 | ||||||||||
| Quality Assurance Inspector | 2,080 | ||||||||||
| Material Expeditor | 2,080 | ||||||||||
| Administrative Assistant | 2,080 | ||||||||||
| Shop Supervisor | 2,080 | ||||||||||
| MHE/SMSE Engineer Technician | 12,480 | ||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | ||||||||||
| Battery Technician | 2,080 |
Labor Summary - Ordering Year 2
| Prime Contractor Name | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | ||||||||||||
| Descriptive Information | Est. Hours | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost |
| Project Manager | 1,040 | |||||||||||||||
| Production Manager | 2,080 | |||||||||||||||
| Quality Assurance Inspector | 2,080 | |||||||||||||||
| Material Expeditor | 2,080 | |||||||||||||||
| Administrative Assistant | 2,080 | |||||||||||||||
| Shop Supervisor | 2,080 | |||||||||||||||
| MHE/SMSE Engineer Technician | 12,480 | |||||||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | |||||||||||||||
| Battery Technician | 2,080 |
CPFF Detail - Ordering Year 2
| COST INFORMATION | |||||||||||
| Contract Labor | |||||||||||
| Category | Resource Type | Company | External Sub | Function | Category | Grade | Band | Site | Technology | ||
| Overhead | General Labor | ||||||||||
| Category | Est. Hours | Labor Rate | Labor Value | Fringe % | Fringe Value | DL + Fringe | OH % | OH Value | Comm | ||
| Sup % | Comm Sup Value | G&A % | G&A Value | Subtotal | Fixed Fee | Cost | |||||
| Plus Fee | Rate/Hr | ||||||||||
| Ordering Year 2 | |||||||||||
| Project Manager | 1,040 | ||||||||||
| Production Manager | 2,080 | ||||||||||
| Quality Assurance Inspector | 2,080 | ||||||||||
| Material Expeditor | 2,080 | ||||||||||
| Administrative Assistant | 2,080 | ||||||||||
| Shop Supervisor | 2,080 | ||||||||||
| MHE/SMSE Engineer Technician | 12,480 | ||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | ||||||||||
| Battery Technician | 2,080 |
Labor Summary - Ordering Year 3
| Prime Contractor Name | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | ||||||||||||
| Descriptive Information | Est. Hours | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost |
| Project Manager | 1,040 | |||||||||||||||
| Production Manager | 2,080 | |||||||||||||||
| Quality Assurance Inspector | 2,080 | |||||||||||||||
| Material Expeditor | 2,080 | |||||||||||||||
| Administrative Assistant | 2,080 | |||||||||||||||
| Shop Supervisor | 2,080 | |||||||||||||||
| MHE/SMSE Engineer Technician | 12,480 | |||||||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | |||||||||||||||
| Battery Technician | 2,080 |
CPFF Detail - Ordering Year 3
| COST INFORMATION | |||||||||||
| Contract Labor | |||||||||||
| Category | Resource Type | Company | External Sub | Function | Category | Grade | Band | Site | Technology | ||
| Overhead | General Labor | ||||||||||
| Category | Est. Hours | Labor Rate | Labor Value | Fringe % | Fringe Value | DL + Fringe | OH % | OH Value | Comm | ||
| Sup % | Comm Sup Value | G&A % | G&A Value | Subtotal | Fixed Fee | Cost | |||||
| Plus Fee | Rate/Hr | ||||||||||
| Ordering Year 3 | |||||||||||
| Project Manager | 1,040 | ||||||||||
| Production Manager | 2,080 | ||||||||||
| Quality Assurance Inspector | 2,080 | ||||||||||
| Material Expeditor | 2,080 | ||||||||||
| Administrative Assistant | 2,080 | ||||||||||
| Shop Supervisor | 2,080 | ||||||||||
| MHE/SMSE Engineer Technician | 12,480 | ||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | ||||||||||
| Battery Technician | 2,080 |
Labor Summary - Ordering Year 4
| Prime Contractor Name | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | ||||||||||||
| Descriptive Information | Est. Hours | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost |
| Project Manager | 1,040 | |||||||||||||||
| Production Manager | 2,080 | |||||||||||||||
| Quality Assurance Inspector | 2,080 | |||||||||||||||
| Material Expeditor | 2,080 | |||||||||||||||
| Administrative Assistant | 2,080 | |||||||||||||||
| Shop Supervisor | 2,080 | |||||||||||||||
| MHE/SMSE Engineer Technician | 12,480 | |||||||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | |||||||||||||||
| Battery Technician | 2,080 |
CPFF Detail - Ordering Year 4
| COST INFORMATION | |||||||||||
| Contract Labor | |||||||||||
| Category | Resource Type | Company | External Sub | Function | Category | Grade | Band | Site | Technology | ||
| Overhead | General Labor | ||||||||||
| Category | Est. Hours | Labor Rate | Labor Value | Fringe % | Fringe Value | DL + Fringe | OH % | OH Value | Comm | ||
| Sup % | Comm Sup Value | G&A % | G&A Value | Subtotal | Fixed Fee | Cost | |||||
| Plus Fee | Rate/Hr | ||||||||||
| Ordering Year 4 | |||||||||||
| Project Manager | 1,040 | ||||||||||
| Production Manager | 2,080 | ||||||||||
| Quality Assurance Inspector | 2,080 | ||||||||||
| Material Expeditor | 2,080 | ||||||||||
| Administrative Assistant | 2,080 | ||||||||||
| Shop Supervisor | 2,080 | ||||||||||
| MHE/SMSE Engineer Technician | 12,480 | ||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | ||||||||||
| Battery Technician | 2,080 |
Labor Summary - Ordering Year 5
| Prime Contractor Name | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | ||||||||||||
| Descriptive Information | Est. Hours | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost |
| Project Manager | 1,040 | |||||||||||||||
| Production Manager | 2,080 | |||||||||||||||
| Quality Assurance Inspector | 2,080 | |||||||||||||||
| Material Expeditor | 2,080 | |||||||||||||||
| Administrative Assistant | 2,080 | |||||||||||||||
| Shop Supervisor | 2,080 | |||||||||||||||
| MHE/SMSE Engineer Technician | 12,480 | |||||||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | |||||||||||||||
| Battery Technician | 2,080 |
CPFF Detail - Ordering Year 5
| COST INFORMATION | |||||||||||
| Contract Labor | |||||||||||
| Category | Resource Type | Company | External Sub | Function | Category | Grade | Band | Site | Technology | ||
| Overhead | General Labor | ||||||||||
| Category | Est. Hours | Labor Rate | Labor Value | Fringe % | Fringe Value | DL + Fringe | OH % | OH Value | Comm | ||
| Sup % | Comm Sup Value | G&A % | G&A Value | Subtotal | Fixed Fee | Cost | |||||
| Plus Fee | Rate/Hr | ||||||||||
| Ordering Year 5 | |||||||||||
| Project Manager | 1,040 | ||||||||||
| Production Manager | 2,080 | ||||||||||
| Quality Assurance Inspector | 2,080 | ||||||||||
| Material Expeditor | 2,080 | ||||||||||
| Administrative Assistant | 2,080 | ||||||||||
| Shop Supervisor | 2,080 | ||||||||||
| MHE/SMSE Engineer Technician | 12,480 | ||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 6,240 | ||||||||||
| Battery Technician | 2,080 |
Labor Summary - FAR 52.217-8
| Prime Contractor Name | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | Subcontractor Name (if applicable) | ||||||||||||
| Descriptive Information | Est. Hours | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost | Est. Hours | Fully Burdened Labor Rate | Total Cost |
| Project Manager | 520 | |||||||||||||||
| Production Manager | 1,040 | |||||||||||||||
| Quality Assurance Inspector | 1,040 | |||||||||||||||
| Material Expeditor | 1,040 | |||||||||||||||
| Administrative Assistant | 1,040 | |||||||||||||||
| Shop Supervisor | 1,040 | |||||||||||||||
| MHE/SMSE Engineer Technician | 6,240 | |||||||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 3,120 | |||||||||||||||
| Battery Technician | 1,040 |
CPFF Detail - FAR 52.217-8
| COST INFORMATION | |||||||||||
| Contract Labor | |||||||||||
| Category | Resource Type | Company | External Sub | Function | Category | Grade | Band | Site | Technology | ||
| Overhead | General Labor | ||||||||||
| Category | Est. Hours | Labor Rate | Labor Value | Fringe % | Fringe Value | DL + Fringe | OH % | OH Value | Comm | ||
| Sup % | Comm Sup Value | G&A % | G&A Value | Subtotal | Fixed Fee | Cost | |||||
| Plus Fee | Rate/Hr | ||||||||||
| FAR 52.217-8 OPTION | |||||||||||
| Project Manager | 520 | ||||||||||
| Production Manager | 1,040 | ||||||||||
| Quality Assurance Inspector | 1,040 | ||||||||||
| Material Expeditor | 1,040 | ||||||||||
| Administrative Assistant | 1,040 | ||||||||||
| Shop Supervisor | 1,040 | ||||||||||
| MHE/SMSE Engineer Technician | 6,240 | ||||||||||
| MHE/SMSE Mobile Service Road Engineer Technician | 3,120 | ||||||||||
| Battery Technician | 1,040 |
File details come from the government source that posted it. Updated .