Attach_0007_CPFF_Hydra_Labor_Rate_Tables_15Aug2018.xlsx
XLSX spreadsheet 85 KB Posted
- Solicitation number
- W31P4Q-17-R-0046
About this file
This document contains an Excel attachment with instructions and templates for responding to solicitation number W31P4Q-17-R-0046 for Hydra-70 Rocket System production and engineering services. The solicitation will be for a hybrid Firm-Fixed-Price and Cost-Plus five year contract for procurement of Hydra-70 Rocket System hardware including various rockets, warheads, containers and associated components as well as engineering services to maintain capability. The engineering services will provide program management, engineering, product assurance, safety, configuration management, test and evaluation, production engineering support and administrative effort. The solicitation is restricted to companies that are members of the National Technology and Industrial Base and the incumbent contractor will be eligible to respond. Respondents are to complete templates providing labor rate tables, conversion tables, pass-through rates for any subcontractors, and the blended ceiling rates for evaluation.
Attachment 0007 CPFF Hydra Labor Rate Tables
View the file
Other files
Show all 42
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
CPFF Hydra Labor Rate Tables Instructions: Enter the requested data in the yellow shaded cells. Do not hard key calculated numbers. Input formulas to show the calculation of the proposed CPFF amount. The Offeror shall complete the worksheets in accordance with the Offeror's normal accounting practice. It may be necessary for each offeror to revise the number of rows and columns to reflect differences or nuances in the offerors' accounting systems. However, it is requested that the general format be maintained as much as possible for evaluation and contract administration purposes. The Offeror shall complete the worksheets in the following order: "1.ConversionTable" worksheet; 2. "PrimeSubLaborRatePassThrough" worksheets; and "3.CPFF Labor Rate Table." The Offeror shall complete the "PrimeSubXLaborRatePassThrough" worksheet for each proposed subcontractor. Additional worksheets and columns may need to be added to accommodate the Offeror's proposed contracting team structure. An example labor category has been completed on each worksheet in red text. The Offeror is responsible for ensuring that all calculations in this attachment are accurate. The Offeror shall ensure that the red text amounts are not included in the Offeror's proposed price.
1.ConversionTable
| Attachment 0007- Conversion Table | |||||
| Solicitation No. W31P4Q-17-R-0046 | |||||
| Prime Contractor Name: | |||||
| Prime Contractor CAGE Code: | |||||
| STEP 1: "COMPLETE THE CONVERSION TABLE" WORKSHEET. | |||||
| "Conversion Table" worksheet: The Offeror shall provide the following in this worksheet: (1) Identify the contractor fiscal year (CFY) period, providing the From and To dates for the CFY period; (2) for the Labor Rate Conversion Table, the offeror shall show the crosswalk of the Government provided Project Labor Categories to the Offeror's Contractor General Labor Categories in Column B and provide the offeror's proposed base labor rates by CFY for each Contractor General Labor Category; (3) for the Indirect Rate Conversion Table, provide the offeror's proposed indirect rates by CFY; (4) input formulas in Columns L through P to show the conversion of CFY rates to the contract's ordering periods. The rates shown in Columns L through P are the rates that shall be used to populate the "CPFF Labor Rate Table" worksheet. Red text is shown as an example of how formulas are used to convert CFY rates to ordering period rates. The Offeror shall calculate ordering period rates in accordance with its own CFY period and the contract's ordering period. | |||||
| CFY Period: | From | Month/Day | To | Month/Day |
| LABOR RATE CONVERSION | Contractor Fiscal Year | Ordering Period | |||||||||||||
| Government Project Labor Category | Contractor General Labor Category | CFY X | CFY X | CFY X | CFY X | CFY X | CFY X | CFY X | CFY X | CFY X | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 |
| Example Labor Category | Category 1 | $ 10.00 | $ 11.00 | $ 12.00 | $ 13.00 | $ 14.00 | $ 15.00 | $ 10.75 | $ 11.75 | $ 12.75 | $ 13.75 | $ 14.75 | |||
| Category 2 | $ 10.50 | $ 11.50 | $ 12.50 | $ 13.50 | $ 14.50 | $ 15.50 | $ 11.25 | $ 12.25 | $ 13.25 | $ 14.25 | $ 15.25 | ||||
| Category 3 | $ 11.00 | $ 12.00 | $ 13.00 | $ 14.00 | $ 15.00 | $ 16.00 | $ 11.75 | $ 12.75 | $ 13.75 | $ 14.75 | $ 15.75 | ||||
| Category 4 | $ 11.50 | $ 12.50 | $ 13.50 | $ 14.50 | $ 15.50 | $ 16.50 | $ 12.25 | $ 13.25 | $ 14.25 | $ 15.25 | $ 16.25 | ||||
| Program Manager |
Systems Engineering
Software/Firmware
Configuration management
Product Assurance
Integrated Logistics Support
Test and Evaluation
| INDIRECT BURDEN CONVERSION | Contractor Fiscal Year | Ordering Period | |||||||||||||
| Indirect Burden | CFY X | CFY X | CFY X | CFY X | CFY X | CFY X | CFY X | CFY X | CFY X | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | |
| Example- Burden1 | 10.00% | 9.00% | 8.00% | 7.00% | 6.00% | 5.00% | 4.00% | 9.25% | 8.25% | 7.25% | 6.25% | 5.25% | |||
| Example- Burden2 | 8.50% | 8.00% | 7.50% | 7.00% | 6.50% | 6.00% | 5.50% | 8.13% | 7.63% | 7.13% | 6.63% | 6.13% | |||
| Example- Burden 3 | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% | 5.00% |
2.PrimeSub1LaborRatePassThrough
| Attachment 0007- PrimeSubLaborRatePassThrough |
| Solicitation No. W31P4Q-17-R-0046 |
| Prime Contractor Name: |
| Prime Contractor CAGE Code: |
| Subcontractor Name: |
| Subcontractor Cage Code: |
| STEP 2: COMPLETE THE "PRIMESUBLABORRATEPASSTHROUGH" WORKSHEETS. |
| "PrimeSubLaborRatePassThrough" worksheets: The Offeror shall complete the below tables to provide the details of any subcontract labor rates and their build-up to include the subcontract labor rates and any applicable prime pass-through indirect rates/burdens proposed in accordance with the Offeror's normal accounting practices. |
| NOTE 1: The rate in this column is the subcontractor's fully burdened labor rate EXCLUSIVE of the prime contractor's pass-through indirect rates/burdens and profit. |
| NOTE 2: Apply any applicable prime contractor pass-through indirect rates/burdens to the subcontractor rates in accordance with the Offeror's normal accounting practices. These rates shall match the Ordering Period rates proposed in the "Conversion Table" worksheet. Input/update formulas to show how the proposed ordering period indirect burdens from the "Conversion Table" worksheet are used to calculate the Subcontractor Rates with Prime Pass-Through. |
| (Note 2) | (Note 2) | ||||
| Example- Burden 3 | Fee (%) | ||||
| ORDERING PERIOD 1 | 5% | 5% | |||
| Government Project Labor Cateogry | Subcontractor1 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor1 Labor Rate with Prime Pass-Through |
| Example Labor Category | $ 10.00 | $ 0.50 | $ - 0 | $ 0.53 | $ 11.03 |
Program Manager $ - 0
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Example- Burden 3 | Fee (%) | ||||
| ORDERING PERIOD 2 | 5% | 5% | |||
| Government Project Labor Cateogry | Subcontractor1 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor1 Labor Rate with Prime Pass-Through |
| Example Labor Category | $ 11.00 | $ 0.55 | $ - 0 | $ 0.58 | $ 12.13 |
Program Manager $ - 0
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Example- Burden 3 | Fee (%) | ||||
| ORDERING PERIOD 3 | 5% | 5% | |||
| Government Project Labor Cateogry | Subcontractor1 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor1 Labor Rate with Prime Pass-Through |
| Example Labor Category | $ 12.00 | $ 0.60 | $ - 0 | $ 0.63 | $ 13.23 |
Program Manager $ - 0
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Example- Burden 3 | Fee (%) | ||||
| ORDERING PERIOD 4 | 5% | 5% | |||
| Government Project Labor Cateogry | Subcontractor1 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor1 Labor Rate with Prime Pass-Through |
| Example Labor Category | $ 13.00 | $ 0.65 | $ - 0 | $ 0.68 | $ 14.33 |
Program Manager $ - 0
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Example- Burden 3 | Fee (%) | ||||
| ORDERING PERIOD 5 | 5% | 5% | |||
| Government Project Labor Cateogry | Subcontractor1 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor1 Labor Rate with Prime Pass-Through |
| Example Labor Category | $ 14.00 | $ 0.70 | $ - 0 | $ 0.74 | $ 15.43 |
Program Manager $ - 0
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
2.PrimeSub2LaborRatePassThrough
| Attachment 0007- PrimeSubLaborRatePassThrough |
| Solicitation No. W31P4Q-17-R-0046 |
| Prime Contractor Name: |
| Prime Contractor CAGE Code: |
| Subcontractor Name: |
| Subcontractor Cage Code: |
| STEP 2: COMPLETE THE "PRIMESUBLABORRATEPASSTHROUGH" WORKSHEETS. |
| "PrimeSubLaborRatePassThrough" worksheets: The Offeror shall complete the below tables to provide the details of any subcontract labor rates and their build-up to include the subcontract labor rates and any applicable prime pass-through indirect rates/burdens proposed in accordance with the Offeror's normal accounting practices. |
| NOTE 1: The rate in this column is the subcontractor's fully burdened labor rate EXCLUSIVE of the prime contractor's pass-through indirect rates/burdens and profit. |
| NOTE 2: Apply any applicable prime contractor pass-through indirect rates/burdens to the subcontractor rates in accordance with the Offeror's normal accounting practices. These rates shall match the Ordering Period rates proposed in the "Conversion Table" worksheet. Input/update formulas to show how the proposed ordering period indirect burdens from the "Conversion Table" worksheet are used to calculate the Subcontractor Rates with Prime Pass-Through. |
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 1 | |||||
| Government Project Labor Cateogry | Subcontractor2 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor2 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 2 | |||||
| Government Project Labor Cateogry | Subcontractor2 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor2 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 3 | |||||
| Government Project Labor Cateogry | Subcontractor2 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor2 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 4 | |||||
| Government Project Labor Cateogry | Subcontractor2 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor2 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 5 | |||||
| Government Project Labor Cateogry | Subcontractor2 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor2 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
2.PrimeSub3LaborRatePassThrough
| Attachment 0007- PrimeSubLaborRatePassThrough |
| Solicitation No. W31P4Q-17-R-0046 |
| Prime Contractor Name: |
| Prime Contractor CAGE Code: |
| Subcontractor Name: |
| Subcontractor Cage Code: |
| STEP 2: COMPLETE THE "PRIMESUBLABORRATEPASSTHROUGH" WORKSHEETS. |
| "PrimeSubLaborRatePassThrough" worksheets: The Offeror shall complete the below tables to provide the details of any subcontract labor rates and their build-up to include the subcontract labor rates and any applicable prime pass-through indirect rates/burdens proposed in accordance with the Offeror's normal accounting practices. |
| NOTE 1: The rate in this column is the subcontractor's fully burdened labor rate EXCLUSIVE of the prime contractor's pass-through indirect rates/burdens and profit. |
| NOTE 2: Apply any applicable prime contractor pass-through indirect rates/burdens to the subcontractor rates in accordance with the Offeror's normal accounting practices. These rates shall match the Ordering Period rates proposed in the "Conversion Table" worksheet. Input/update formulas to show how the proposed ordering period indirect burdens from the "Conversion Table" worksheet are used to calculate the Subcontractor Rates with Prime Pass-Through. |
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 1 | |||||
| Government Project Labor Cateogry | Subcontractor3 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor3 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 2 | |||||
| Government Project Labor Cateogry | Subcontractor3 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor3 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 3 | |||||
| Government Project Labor Cateogry | Subcontractor3 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor3 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 4 | |||||
| Government Project Labor Cateogry | Subcontractor3 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor3 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 5 | |||||
| Government Project Labor Cateogry | Subcontractor3 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor3 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
2.PrimeSub4LaborRatePassThrough
| Attachment 0007- PrimeSubLaborRatePassThrough |
| Solicitation No. W31P4Q-17-R-0046 |
| Prime Contractor Name: |
| Prime Contractor CAGE Code: |
| Subcontractor Name: |
| Subcontractor Cage Code: |
| STEP 2: COMPLETE THE "PRIMESUBLABORRATEPASSTHROUGH" WORKSHEETS. |
| "PrimeSubLaborRatePassThrough" worksheets: The Offeror shall complete the below tables to provide the details of any subcontract labor rates and their build-up to include the subcontract labor rates and any applicable prime pass-through indirect rates/burdens proposed in accordance with the Offeror's normal accounting practices. |
| NOTE 1: The rate in this column is the subcontractor's fully burdened labor rate EXCLUSIVE of the prime contractor's pass-through indirect rates/burdens and profit. |
| NOTE 2: Apply any applicable prime contractor pass-through indirect rates/burdens to the subcontractor rates in accordance with the Offeror's normal accounting practices. These rates shall match the Ordering Period rates proposed in the "Conversion Table" worksheet. Input/update formulas to show how the proposed ordering period indirect burdens from the "Conversion Table" worksheet are used to calculate the Subcontractor Rates with Prime Pass-Through. |
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 1 | |||||
| Government Project Labor Cateogry | Subcontractor4 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor4 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 2 | |||||
| Government Project Labor Cateogry | Subcontractor4 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor4 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 3 | |||||
| Government Project Labor Cateogry | Subcontractor4 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor4 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 4 | |||||
| Government Project Labor Cateogry | Subcontractor4 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor4 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 5 | |||||
| Government Project Labor Cateogry | Subcontractor4 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor4 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
2.PrimeSub5LaborRatePassThrough
| Attachment 0007- PrimeSubLaborRatePassThrough |
| Solicitation No. W31P4Q-17-R-0046 |
| Prime Contractor Name: |
| Prime Contractor CAGE Code: |
| Subcontractor Name: |
| Subcontractor Cage Code: |
| STEP 2: COMPLETE THE "PRIMESUBLABORRATEPASSTHROUGH" WORKSHEETS. |
| "PrimeSubLaborRatePassThrough" worksheets: The Offeror shall complete the below tables to provide the details of any subcontract labor rates and their build-up to include the subcontract labor rates and any applicable prime pass-through indirect rates/burdens proposed in accordance with the Offeror's normal accounting practices. |
| NOTE 1: The rate in this column is the subcontractor's fully burdened labor rate EXCLUSIVE of the prime contractor's pass-through indirect rates/burdens and profit. |
| NOTE 2: Apply any applicable prime contractor pass-through indirect rates/burdens to the subcontractor rates in accordance with the Offeror's normal accounting practices. These rates shall match the Ordering Period rates proposed in the "Conversion Table" worksheet. Input/update formulas to show how the proposed ordering period indirect burdens from the "Conversion Table" worksheet are used to calculate the Subcontractor Rates with Prime Pass-Through. |
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 1 | |||||
| Government Project Labor Cateogry | Subcontractor5 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor5 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 2 | |||||
| Government Project Labor Cateogry | Subcontractor5 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor5 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 3 | |||||
| Government Project Labor Cateogry | Subcontractor5 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor5 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 4 | |||||
| Government Project Labor Cateogry | Subcontractor5 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor5 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
| (Note 2) | (Note 2) | ||||
| Fee (%) | |||||
| ORDERING PERIOD 5 | |||||
| Government Project Labor Cateogry | Subcontractor5 Rate before Pass-Through (Note 1) | Prime Burden 3 ($/hr) on Sub Labor (Note 2) | Prime Burden 4 on Sub Labor ($/hr) (Note 2) | Prime Fee $'s/hr on Sub Labor | Subcontractor5 Labor Rate with Prime Pass-Through |
| Program Manager | $ - 0 |
Systems Engineering $ - 0
Software/Firmware $ - 0
Configuration management $ - 0
Product Assurance $ - 0
Integrated Logistics Support $ - 0
Test and Evaluation $ - 0
3.CPFF Labor Rate Table
| Attachment 0007- CPFF Labor Rate Table |
| Solicitation No. W31P4Q-17-R-0046 |
| Prime Contractor Name: |
| CAGE Code: |
| STEP 3: COMPLETE THE "CPFF LABOR RATE TABLE". |
| "CPFF Labor Rate Table" worksheet: The Offeror shall complete the "CPFF Labor Rate Table." The Offeror shall provide the details of the proposed CPFF blended (prime/subcontract) ceiling labor rates and their build-up to include the base labor rate, subcontract labor rate, and applicable indirect rates/burdens proposed in accordance with the Offeror's normal accounting practice. |
| NOTE 1: The offeror shall show the crosswalk of the Government Project Labor Categories to the Offeror's Contractor General Labor Categories and assign weightings to each Contractor General Labor Category to show the calculation of the weighted hourly composite rate in Column E for each Government Project Labor Category. The crosswalk provided in Column B should match that shown in the "Conversion Table" worksheet. Input formulas to show how the crosswalk from the "Conversion Table" worksheet are used to calculate the CPFF Ceiling Rates. |
| NOTE 2: The prime offeror shall input the prime offeror's base labor rate for each proposed labor category. The base labor rate is the actual base hourly rate paid to the employee EXCLUSIVE of indirects/burdens and fee. The rates in this column should match the ordering period labor rates taken from Columns L through P of the "Conversion Table" worksheet. Input formulas to show how the ordering period labor rates from the "Conversion Table" worksheet are used to calculate the CPFF Ceiling Rates. |
| NOTE 3: Apply any applicable indirect burdens to the proposed rates in accordance with the Offeror's normal accounting practices. Identify the name of the indirect burden (Row 18) and the indirect rate percentage (Row 19) being applied to proposed costs. These rates shall match the ordering period rates from Columns L through P of the "ConversionTable" worksheet. Input/update formulas to show how the ordering period indirect burdens from the "Conversion Table" worksheet are used to calculate the CPFF Ceiling Rates. |
| NOTE 4: Assign a weighting to the Weighted Hourly Composite Base Rate (Column E) and the Subcontractor Labor Rate with Pass-Through. The sum of all weightings shall equal 100 percent. |
| NOTE 5: The rate in this column should match the Subcontractor Labor Rate with Prime Pass-Through in Column F of the "PrimeSubLaborRatePassThrough" worksheets and should represent the subcontractor's fully burdened rate INCLUSIVE of the prime contractor's pass-through indirect rates/burdens and profit. |
| (Note 3) | (Note 3) | (Note 3) | |||||||||||||||||||||
| Example- Burden1 | Example- Burden2 | Example- Burden 3 | Fee (%) | ||||||||||||||||||||
| ORDERING PERIOD 1 | 9% | 8% | 5% | 5% | |||||||||||||||||||
| Government Project Labor Cateogry | Contractor General Labor Category Crosswalk (Note 1) | % Weighting (Note 1) | Hourly Base Labor Rate ($/hr) (Note 2) | Weighted Hourly Composite Base Rate ($/hr) (Note 1) | Burden Rate1 ($/hr) (Note 3) | Burden Rate2 ($/hr) (Note 3) | Burden Rate3 ($/hr) (Note 3) | Fee ($/hr) | Fully Burdened Prime Labor Rate ($/hr) | Prime Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 1 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 1 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 2 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 2 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 3 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 3 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 4 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 4 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 5 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 5 Allocation (%) (Note 4) | Total Proposed CPFF Ceiling Rate ($/hr) | Government Provided Labor Hours | Total Proposed CPFF Amount |
| Example Labor Category | Category 1 | 25% | $ 10.75 | $ 11.50 | $ 1.06 | $ 1.02 | $ 0.68 | $ 0.71 | $ 14.98 | 50% | $ 11.03 | 10% | $ 8.59 | 1,000 | $ 8,591 | ||||||||
| Category 2 | 25% | $ 11.25 | |||||||||||||||||||||
| Category 3 | 25% | $ 11.75 | |||||||||||||||||||||
| Category 4 | 25% | $ 12.25 | |||||||||||||||||||||
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 3,013 | $ - 0 |
Systems Engineering $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,864 $ - 0
Software/Firmware $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,486 $ - 0
Configuration management $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,853 $ - 0
Product Assurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 4,103 $ - 0
Integrated Logistics Support $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 578 $ - 0
Test and Evaluation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,396 $ - 0
Ordering Period 1 Total CPFF Engineering Services Labor Amount $ - 0
| (Note 3) | (Note 3) | (Note 3) | |||||||||||||||||||||
| Fee (%) | |||||||||||||||||||||||
| ORDERING PERIOD 2 | |||||||||||||||||||||||
| Government Project Labor Cateogry | Contractor General Labor Category Crosswalk (Note 1) | % Weighting (Note 1) | Hourly Base Labor Rate ($/hr) (Note 2) | Weighted Hourly Composite Base Rate ($/hr) (Note 1) | Burden Rate1 ($/hr) (Note 3) | Burden Rate2 ($/hr) (Note 3) | Burden Rate3 ($/hr) (Note 3) | Fee ($/hr) | Fully Burdened Prime Labor Rate ($/hr) | Prime Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 1 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 1 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 2 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 2 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 3 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 3 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 4 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 4 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 5 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 5 Allocation (%) (Note 4) | Total Proposed CPFF Ceiling Rate ($/hr) | Government Provided Labor Hours | Total Proposed CPFF Amount |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 3,013 | $ - 0 |
Systems Engineering $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,864 $ - 0
Software/Firmware $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,486 $ - 0
Configuration management $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,853 $ - 0
Product Assurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 4,103 $ - 0
Integrated Logistics Support $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 578 $ - 0
Test and Evaluation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,396 $ - 0
| Ordering Period 2 Total CPFF Engineering Services Labor Amount | $ - 0 | ||||||||||||||||||||||
| (Note 3) | (Note 3) | (Note 3) | |||||||||||||||||||||
| Fee (%) | |||||||||||||||||||||||
| ORDERING PERIOD 3 | |||||||||||||||||||||||
| Government Project Labor Cateogry | Contractor General Labor Category Crosswalk (Note 1) | % Weighting (Note 1) | Hourly Base Labor Rate ($/hr) (Note 2) | Weighted Hourly Composite Base Rate ($/hr) (Note 1) | Burden Rate1 ($/hr) (Note 3) | Burden Rate2 ($/hr) (Note 3) | Burden Rate3 ($/hr) (Note 3) | Fee ($/hr) | Fully Burdened Prime Labor Rate ($/hr) | Prime Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 1 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 1 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 2 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 2 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 3 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 3 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 4 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 4 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 5 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 5 Allocation (%) (Note 4) | Total Proposed CPFF Ceiling Rate ($/hr) | Government Provided Labor Hours | Total Proposed CPFF Amount |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 3,013 | $ - 0 |
Systems Engineering $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,864 $ - 0
Software/Firmware $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,486 $ - 0
Configuration management $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,853 $ - 0
Product Assurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 4,103 $ - 0
Integrated Logistics Support $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 578 $ - 0
Test and Evaluation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,396 $ - 0
| Ordering Period 3 Total CPFF Engineering Services Labor Amount | $ - 0 | ||||||||||||||||||||||
| (Note 3) | (Note 3) | (Note 3) | |||||||||||||||||||||
| Fee (%) | |||||||||||||||||||||||
| ORDERING PERIOD 4 | |||||||||||||||||||||||
| Government Project Labor Cateogry | Contractor General Labor Category Crosswalk (Note 1) | % Weighting (Note 1) | Hourly Base Labor Rate ($/hr) (Note 2) | Weighted Hourly Composite Base Rate ($/hr) (Note 1) | Burden Rate1 ($/hr) (Note 3) | Burden Rate2 ($/hr) (Note 3) | Burden Rate3 ($/hr) (Note 3) | Fee ($/hr) | Fully Burdened Prime Labor Rate ($/hr) | Prime Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 1 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 1 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 2 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 2 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 3 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 3 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 4 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 4 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 5 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 5 Allocation (%) (Note 4) | Total Proposed CPFF Ceiling Rate ($/hr) | Government Provided Labor Hours | Total Proposed CPFF Amount |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 3,013 | $ - 0 |
Systems Engineering $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,864 $ - 0
Software/Firmware $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,486 $ - 0
Configuration management $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,853 $ - 0
Product Assurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 4,103 $ - 0
Integrated Logistics Support $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 578 $ - 0
Test and Evaluation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,396 $ - 0
| Ordering Period 4 Total CPFF Engineering Services Labor Amount | $ - 0 | ||||||||||||||||||||||
| (Note 3) | (Note 3) | (Note 3) | |||||||||||||||||||||
| Fee (%) | |||||||||||||||||||||||
| ORDERING PERIOD 5 | |||||||||||||||||||||||
| Government Project Labor Cateogry | Contractor General Labor Category Crosswalk (Note 1) | % Weighting (Note 1) | Hourly Base Labor Rate ($/hr) (Note 2) | Weighted Hourly Composite Base Rate ($/hr) (Note 1) | Burden Rate1 ($/hr) (Note 3) | Burden Rate2 ($/hr) (Note 3) | Burden Rate3 ($/hr) (Note 3) | Fee ($/hr) | Fully Burdened Prime Labor Rate ($/hr) | Prime Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 1 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 1 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 2 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 2 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 3 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 3 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 4 Labor Rate with Pass-Through ($/hr) (Note 5) | Subcontractor 4 Allocation (%) (Note 4) | Total Fully Burdened Subcontractor 5 Labor Rate w/Pass-Through ($/hr) (Note 5) | Subcontractor 5 Allocation (%) (Note 4) | Total Proposed CPFF Ceiling Rate ($/hr) | Government Provided Labor Hours | Total Proposed CPFF Amount |
| Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | 3,013 | $ - 0 |
Systems Engineering $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,864 $ - 0
Software/Firmware $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,486 $ - 0
Configuration management $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 2,853 $ - 0
Product Assurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 4,103 $ - 0
Integrated Logistics Support $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 578 $ - 0
Test and Evaluation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 11,396 $ - 0
| Ordering Period 5 Total CPFF Engineering Services Labor Amount | $ - 0 |
| Total CPFF Ceiling for CLIN 0047 | $ - 0 |
File details come from the government source that posted it. Updated .