Attachment_0001_-__Attachment_I_-_Labor_Chart_5Year.xlsx
XLSX spreadsheet 31 KB Posted
- Solicitation number
- W15QKN-16-R-0056
About this file
Attachment 0001 - Labor Chart
View the file
Other files
Show all 24
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
| The following instructions are provided to assist the offerors with completing the worksheets in Attachment II. This is not an all-inclusive list of proposal submission requirements. See Section L of the solicitation for complete proposal instructions and proposal submission requirements. | ||||||||
| 1. Complete the worksheets for Ordering Periods 1-2. Insert prime and subcontractor name where indicated. If proposing more than three subcontractors, add additional columns. | ||||||||
| 2. Labor Categories: Offerors may not deviate from categories listed in worksheets. If the Offeror’s labor categories differ from the categories included in the solicitation, the Offeror shall provide a matrix which crosswalks their labor categories/rates to the labor categories/rates contained in the solicitation. | ||||||||
| 3. Labor Hours: The number of Government estimated hours per labor category shall be allocated among offeror, major subcontractors, and affiliates under common control. The total proposed hours per labor category shall be equal to the total government estimated hours listed for each labor category. | ||||||||
| 4. Fully Loaded Labor Rates: Each offeror must submit a minimum of one fully loaded CPFF labor rate for each Category of Labor, whether it is by the prime contractor or a subcontractor, for each base Ordering Period (Ordering Period 1 & 2). Offerors must submit separate rates for effort performed by the prime contractor, subcontractor, and affiliates under common control for each labor category. The prime contractor cannot utilize their fully loaded labor rates for their subcontractors. The fully loaded labor rates shall be inclusive of wages, applicable indirect expenses and fee. Offerors shall not propose rates where no hours have been proposed/allocated as they will not be incorporated into any contract that may be awarded as a result of this solicitation. | ||||||||
| 5. Detailed Rate Schedule: Offerors (including all major subcontractors and affiliates) must provide a breakdown of the cost elements for each proposed fully loaded labor rate in order to allow for cost realism analysis. The Offeror shall provide a schedule which contains the proposed wages, applicable indirect rates and fee for each year. If the Offeror’s rates are blended, weighted or composite rates, the Offeror shall provide a detailed schedule and breakout by element of cost which demonstrates how the blended, weighted or composite rates are calculated. Following is a sample of a fully loaded labor rate cost element breakdown: | ||||||||
| ID | Labor Category | Base Hourly Labor Rate | Labor Overhead | Total Hourly Labor & Overhead | G&A | Total Hourly Cost | Fee | Fully Loaded Labor Rate |
| 115% | 32% | 6% | ||||||
| A | Analyst, Operations, Senior | $ 29.00 | $ 33.35 | $ 62.35 | $ 19.95 | $ 82.30 | $ 4.94 | $ 87.24 |
Ordering Period 1
| Prime Contractor Name: | |||||||||||
| Cost Plus Fixed Fee Labor - ORDERING PERIOD 1 | |||||||||||
| Labor Category | Department | Total Government Estimated Hours | Total Proposed Hours - Prime & All Subcontractors (Shall be Equal to Total Gov't Est. Hours) | Prime Contractor | Subcontractor 1: Insert Name Here | Subcontractor 2: Insert Name Here | Subcontractor 3: Insert Name Here | ||||
| Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | ||||
| Program Manager* | Program Management | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Manager* | Program Management | 9600 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Subject Matter Expert II* | Information Technology | 2880 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer III* | Engineering | 42240 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer II | Engineering | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst III* | Information Technology | 13440 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst II | Information Technology | 11520 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst I | Information Technology | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer III* | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer II | Logistics | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer I | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Logistician III* | Logistics | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Configuration Management Analyst | Program Management | 7680 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst III* | Program Management | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst II | Program Management | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst I | Program Management | 8550 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer II | Information Technology | 9500 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer I | Information Technology | 3840 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Administrative Assistant | Administrative | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| *Denotes labor categories for key personnel |
Page &P of &N
Ordering Period 2
| Prime Contractor Name: | |||||||||||
| Cost Plus Fixed Fee Labor - ORDERING PERIOD 2 | |||||||||||
| Labor Category | Department | Total Government Estimated Hours | Total Proposed Hours - Prime & All Subcontractors (Shall be Equal to Total Gov't Est. Hours) | Prime Contractor | Subcontractor 1: Insert Name Here | Subcontractor 2: Insert Name Here | Subcontractor 3: Insert Name Here | ||||
| Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | ||||
| Program Manager* | Program Management | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Manager* | Program Management | 9600 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Subject Matter Expert II* | Information Technology | 2880 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer III* | Engineering | 42240 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer II | Engineering | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst III* | Information Technology | 13440 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst II | Information Technology | 11520 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst I | Information Technology | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer III* | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer II | Logistics | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer I | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Logistician III* | Logistics | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Configuration Management Analyst | Program Management | 7680 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst III* | Program Management | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst II | Program Management | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst I | Program Management | 8550 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer II | Information Technology | 9500 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer I | Information Technology | 3840 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Administrative Assistant | Administrative | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| *Denotes labor categories for key personnel |
Ordering Period 3
| Prime Contractor Name: | |||||||||||
| Cost Plus Fixed Fee Labor - ORDERING PERIOD 3 | |||||||||||
| Labor Category | Department | Total Government Estimated Hours | Total Proposed Hours - Prime & All Subcontractors (Shall be Equal to Total Gov't Est. Hours) | Prime Contractor | Subcontractor 1: Insert Name Here | Subcontractor 2: Insert Name Here | Subcontractor 3: Insert Name Here | ||||
| Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | ||||
| Program Manager* | Program Management | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Manager* | Program Management | 9600 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Subject Matter Expert II* | Information Technology | 2880 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer III* | Engineering | 42240 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer II | Engineering | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst III* | Information Technology | 13440 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst II | Information Technology | 11520 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst I | Information Technology | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer III* | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer II | Logistics | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer I | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Logistician III* | Logistics | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Configuration Management Analyst | Program Management | 7680 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst III* | Program Management | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst II | Program Management | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst I | Program Management | 8550 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer II | Information Technology | 9500 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer I | Information Technology | 3840 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Administrative Assistant | Administrative | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| *Denotes labor categories for key personnel |
Ordering Period 4
| Prime Contractor Name: | |||||||||||
| Cost Plus Fixed Fee Labor - ORDERING PERIOD 4 | |||||||||||
| Labor Category | Department | Total Government Estimated Hours | Total Proposed Hours - Prime & All Subcontractors (Shall be Equal to Total Gov't Est. Hours) | Prime Contractor | Subcontractor 1: Insert Name Here | Subcontractor 2: Insert Name Here | Subcontractor 3: Insert Name Here | ||||
| Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | ||||
| Program Manager* | Program Management | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Manager* | Program Management | 9600 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Subject Matter Expert II* | Information Technology | 2880 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer III* | Engineering | 42240 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer II | Engineering | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst III* | Information Technology | 13440 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst II | Information Technology | 11520 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst I | Information Technology | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer III* | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer II | Logistics | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer I | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Logistician III* | Logistics | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Configuration Management Analyst | Program Management | 7680 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst III* | Program Management | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst II | Program Management | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst I | Program Management | 8550 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer II | Information Technology | 9500 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer I | Information Technology | 3840 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Administrative Assistant | Administrative | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| *Denotes labor categories for key personnel |
Ordering Period 5
| Prime Contractor Name: | |||||||||||
| Cost Plus Fixed Fee Labor - ORDERING PERIOD 5 | |||||||||||
| Labor Category | Department | Total Government Estimated Hours | Total Proposed Hours - Prime & All Subcontractors (Shall be Equal to Total Gov't Est. Hours) | Prime Contractor | Subcontractor 1: Insert Name Here | Subcontractor 2: Insert Name Here | Subcontractor 3: Insert Name Here | ||||
| Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | Proposed Hours | Fully Loaded Labor Rates | ||||
| Program Manager* | Program Management | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Manager* | Program Management | 9600 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Subject Matter Expert II* | Information Technology | 2880 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer III* | Engineering | 42240 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Engineer II | Engineering | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst III* | Information Technology | 13440 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst II | Information Technology | 11520 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Systems Analyst I | Information Technology | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer III* | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer II | Logistics | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Computer Programmer I | Logistics | 5700 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Logistician III* | Logistics | 1920 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Configuration Management Analyst | Program Management | 7680 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst III* | Program Management | 3800 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst II | Program Management | 11400 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Management Analyst I | Program Management | 8550 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer II | Information Technology | 9500 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Technical Writer I | Information Technology | 3840 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| Administrative Assistant | Administrative | 5760 | 0 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 | 0 | $0.00 |
| *Denotes labor categories for key personnel |
File details come from the government source that posted it. Updated .