Attachment III - CPFF Pricing Spreadsheet.xls
XLS spreadsheet 195 KB Posted
- Attached to
- Material Handling Equipment Maintenance Services
- Solicitation number
- N0018923R0037
About this file
This document provides a template for offerors to use in preparing their cost/price proposal for material handling equipment maintenance services solicited under solicitation number N0018923R0037. The template includes an overall summary sheet, CPFF summary sheet by performance period, labor summaries by performance period broken down by prime contractor and subcontractors, and CPFF detail sheets also by performance period. Offerors are permitted to modify elements of the template but must ensure all required information from Section L of the solicitation is provided. The solicitation seeks logistics support services including maintenance, repair, transportation, administrative support and external painting for shipboard and shore-based material handling equipment and mobile support equipment for the Department of the Navy Naval Supply Systems Command Fleet Logistics Center Norfolk.
View the file
Other files
Show all 13
On GovTribe
Work with this file
- 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 3 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 | 0002 | $ - 0 | ||
| 0003 | $ - 0 | |||
| 0004 | $ - 0 | |||
| FAR 52.217-8 | 1002 | $ - 0 | ||
| 1003 | $ - 0 | |||
| 1004 | $ - 0 | |||
| Total | $ - 0 |
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 |
| Production Manager - Admin Support - 1 | 2,080 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Warehouseman - 1 | 2,080 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Program Manager - 1 | 1,040 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 2,080 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
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 | |||||||||||
| Production Manager - Admin Support - 1 | 2,080 | ||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | ||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | ||||||||||
| Warehouseman - 1 | 2,080 | ||||||||||
| Program Manager - 1 | 1,040 | ||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | ||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | ||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 |
| Production Manager - Admin Support - 1 | 2,080 | |||||||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | |||||||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | |||||||||||||||
| Warehouseman - 1 | 2,080 | |||||||||||||||
| Program Manager - 1 | 1,040 | |||||||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | |||||||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | |||||||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | |||||||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | |||||||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 | |||||||||||
| Production Manager - Admin Support - 1 | 2,080 | ||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | ||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | ||||||||||
| Warehouseman - 1 | 2,080 | ||||||||||
| Program Manager - 1 | 1,040 | ||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | ||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | ||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 |
| Production Manager - Admin Support - 1 | 2,080 | |||||||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | |||||||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | |||||||||||||||
| Warehouseman - 1 | 2,080 | |||||||||||||||
| Program Manager - 1 | 1,040 | |||||||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | |||||||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | |||||||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | |||||||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | |||||||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 | |||||||||||
| Production Manager - Admin Support - 1 | 2,080 | ||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | ||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | ||||||||||
| Warehouseman - 1 | 2,080 | ||||||||||
| Program Manager - 1 | 1,040 | ||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | ||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | ||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 |
| Production Manager - Admin Support - 1 | 2,080 | |||||||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | |||||||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | |||||||||||||||
| Warehouseman - 1 | 2,080 | |||||||||||||||
| Program Manager - 1 | 1,040 | |||||||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | |||||||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | |||||||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | |||||||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | |||||||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 | |||||||||||
| Production Manager - Admin Support - 1 | 2,080 | ||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | ||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | ||||||||||
| Warehouseman - 1 | 2,080 | ||||||||||
| Program Manager - 1 | 1,040 | ||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | ||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | ||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 |
| Production Manager - Admin Support - 1 | 2,080 | |||||||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | |||||||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | |||||||||||||||
| Warehouseman - 1 | 2,080 | |||||||||||||||
| Program Manager - 1 | 1,040 | |||||||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | |||||||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | |||||||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | |||||||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | |||||||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 | |||||||||||
| Production Manager - Admin Support - 1 | 2,080 | ||||||||||
| Mobile Service Mechanic - UM Support - 2 | 3,435 | ||||||||||
| Material Expeditor - Admin Support - 1 | 2,080 | ||||||||||
| Warehouseman - 1 | 2,080 | ||||||||||
| Program Manager - 1 | 1,040 | ||||||||||
| General Foreman - MOD-SLEP Support - 1 | 2,080 | ||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 8,320 | ||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 6,240 | ||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 |
| Production Manager - Admin Support - 1 | 1,040 | |||||||||||||||
| Mobile Service Mechanic - UM Support - 2 | 1,717.5 | |||||||||||||||
| Material Expeditor - Admin Support - 1 | 1,040 | |||||||||||||||
| Warehouseman - 1 | 1,040 | |||||||||||||||
| Program Manager - 1 | 520 | |||||||||||||||
| General Foreman - MOD-SLEP Support - 1 | 1,040 | |||||||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 3,120 | |||||||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 4,160 | |||||||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 3,120 | |||||||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 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 | |||||||||||
| Production Manager - Admin Support - 1 | 1,040 | ||||||||||
| Mobile Service Mechanic - UM Support - 2 | 1,717.5 | ||||||||||
| Material Expeditor - Admin Support - 1 | 1,040 | ||||||||||
| Warehouseman - 1 | 1,040 | ||||||||||
| Program Manager - 1 | 520 | ||||||||||
| General Foreman - MOD-SLEP Support - 1 | 1,040 | ||||||||||
| Senior Mechanic - MOD-SLEP Support - 3 | 3,120 | ||||||||||
| General Mechanic - MOD-SLEP Support - 4 | 4,160 | ||||||||||
| Junior Mechanic - MOD-SLEP Support - 3 | 3,120 | ||||||||||
| Quality Assurance - MOD-SLEP Support - 1 | 1,040 |
File details come from the government source that posted it. Updated .