Attachment_0008_CPFF_Requirements.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
SUPPORT- PROFESSIONAL: ENGINEERING/TECHNICAL Federal contract opportunity
Solicitation number
W15QKN16R0019
Issued by
Department of the Army Materiel Command Contracting Command Picatinny Arsenal

About this file

Attachment 0008 CPFF Requirements

View the file

Other files for this federal contract opportunity

Other files attached to SUPPORT- PROFESSIONAL: ENGINEERING/TECHNICAL, newest first.
File Type Posted
W15QKN-16-R-0019_Amendment_04.pdf PDF
W15QKN-16-R-0019_Amendment_03.pdf PDF
Attachment_0008_CPFF_Labor_Rate_Table.xlsx XLSX spreadsheet
Attachment_0007_FFP_Labor_Rate_Table.xlsx XLSX spreadsheet
W15QKN-16-R-0019_Amendment_03.pdf PDF
W15QKN-16-R-0019-0002.pdf PDF
W15QKN16R0019-0001.pdf PDF
Attachment_0007_FFP_Requirements.xlsx XLSX spreadsheet
0002_-_Non-Disclosure_and_Non-Use_Agreement_Small_Cal_NRE.doc DOC document
Exhibit_0001_CDRLS_DD1423.pdf PDF
0005_Military_Critical_Technical_Data_Agreement_DD2345.pdf PDF
W15QKN16R0019.pdf PDF
0001_Past_Performance_Questionnaire.docx DOCX document
0006_AMSTA-AR_1350_Tech_Data_Request_Questionnaire.pdf PDF
0004_Clearance_of_Tech_Info_for_Public_Release.pdf PDF
0003_Disclosure_of_Lobbying_Activities.pdf PDF
Show all 16

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

Ordering Period 1 Prime Contractor Name:

SUMMARY - ORDERING PERIOD 1
DescriptionAmount
CPFF Labor$0.00
CPFF Material$1,307,320.80
CPFF ODCs$36,000.00
Total - Ordering Period 1$1,343,320.80
COST PLUS FIXED FEE (CPFF) LABOR - ORDERING PERIOD 1 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryTotal Government Estimated HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Proposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager1,253$0.000$0.000$0.000$0.0000$0.00
Senior Engineer1,253$0.000$0.000$0.000$0.0000$0.00
General Engineer5,011$0.000$0.000$0.000$0.0000$0.00
Quality Control Technician6,264$0.000$0.000$0.000$0.0000$0.00
Engineering Technician7,517$0.000$0.000$0.000$0.0000$0.00
Draftsman2,506$0.000$0.000$0.000$0.0000$0.00
Manufacturing10,962$0.000$0.000$0.000$0.0000$0.00
Inspection and Testing6,264$0.0000$0.000$0.000$0.0000$0.00
Quality Control Engineer7,830$0.000$0.000$0.000$0.0000$0.00
Production Control3,758$0.000$0.000$0.000$0.0000$0.00
Tool/Die/Model Maker2,506$0.000$0.000$0.000$0.0000$0.00
TOTAL CPFF LABOR55,124- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT ESTIMATED HOURS BY LABOR CATEGORY
MATERIAL - ORDERING PERIOD 1Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$1,307,320.80
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$1,307,320.80
TRAVEL/ODCS - ORDERING PERIOD 1Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$36,000.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$36,000.00

Source Selection Information. See FAR 2.101 and 3.104

Ordering Period 2 Prime Contractor Name: 0

SUMMARY - ORDERING PERIOD 2
DescriptionAmount
CPFF Labor$0.00
CPFF Material$1,406,120.80
CPFF ODCs$36,000.00
Total - Ordering Period 2$1,442,120.80
COST PLUS FIXED FEE (CPFF) LABOR - ORDERING PERIOD 2 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryTotal Government Estimated HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Proposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager8350$0.00$0.000$0.0000$0.0000$0.0000$0.00
Senior Engineer8350$0.00$0.000$0.0000$0.0000$0.0000$0.00
General Engineer3,3410$0.00$0.000$0.0000$0.0000$0.0000$0.00
Quality Control Technician4,1760$0.00$0.000$0.0000$0.0000$0.0000$0.00
Engineering Technician5,0110$0.00$0.000$0.0000$0.0000$0.0000$0.00
Draftsman1,6700$0.00$0.000$0.0000$0.0000$0.0000$0.00
Manufacturing7,3080$0.00$0.000$0.0000$0.0000$0.0000$0.00
Inspection and Testing4,1760$0.00$0.000$0.0000$0.0000$0.0000$0.00
Quality Control Engineer5,2200$0.00$0.000$0.0000$0.0000$0.0000$0.00
Production Control2,5060$0.00$0.000$0.0000$0.0000$0.0000$0.00
Tool/Die/Model Maker1,6700$0.00$0.000$0.0000$0.0000$0.0000$0.00
TOTAL CPFF LABOR36,748- 0$0.00- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT ESTIMATED HOURS BY LABOR CATEGORY
MATERIAL - ORDERING PERIOD 2Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$1,406,120.80
Indirect Rate Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$1,406,120.80
TRAVEL/ODCS - ORDERING PERIOD 2Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$36,000.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$36,000.00

Source Selection Information. See FAR 2.101 and 3.104

Ordering Period 3 Prime Contractor Name: 0

SUMMARY - ORDERING PERIOD 3
DescriptionAmount
CPFF Labor$0.00
CPFF Material$890,920.80
CPFF ODCs$36,000.00
Total - Ordering Period 3$926,920.80
COST PLUS FIXED FEE (CPFF) LABOR - ORDERING PERIOD 3 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryTotal Government Estimated HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Proposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager8350$0.0000$0.0000$0.0000$0.0000$0.00
Senior Engineer8350$0.0000$0.0000$0.0000$0.0000$0.00
General Engineer3,3410$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Technician4,1760$0.0000$0.0000$0.0000$0.0000$0.00
Engineering Technician5,0110$0.0000$0.0000$0.0000$0.0000$0.00
Draftsman1,6700$0.0000$0.0000$0.0000$0.0000$0.00
Manufacturing7,3080$0.0000$0.0000$0.0000$0.0000$0.00
Inspection and Testing4,1760$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Engineer5,2200$0.0000$0.0000$0.0000$0.0000$0.00
Production Control2,5060$0.0000$0.0000$0.0000$0.0000$0.00
Tool/Die/Model Maker1,6700$0.0000$0.0000$0.0000$0.0000$0.00
TOTAL CPFF LABOR36,748- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT ESTIMATED HOURS BY LABOR CATEGORY
MATERIAL - ORDERING PERIOD 3Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$890,920.80
Indirect Rate Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$890,920.80
TRAVEL/ODCS - ORDERING PERIOD 3Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$36,000.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$36,000.00

Source Selection Information. See FAR 2.101 and 3.104

Ordering Period 4 Prime Contractor Name: 0

SUMMARY - ORDERING PERIOD 4
DescriptionAmount
CPFF Labor$0.00
CPFF Material$285,720.80
CPFF ODCs$36,000.00
Total - Ordering Period 4$321,720.80
COST PLUS FIXED FEE (CPFF) LABOR - ORDERING PERIOD 4 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryTotal Government Estimated HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Proposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager8350$0.0000$0.0000$0.0000$0.0000$0.00
Senior Engineer8350$0.0000$0.0000$0.0000$0.0000$0.00
General Engineer3,3410$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Technician4,1760$0.0000$0.0000$0.0000$0.0000$0.00
Engineering Technician5,0110$0.0000$0.0000$0.0000$0.0000$0.00
Draftsman1,6700$0.0000$0.0000$0.0000$0.0000$0.00
Manufacturing7,3080$0.0000$0.0000$0.0000$0.0000$0.00
Inspection and Testing4,1760$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Engineer5,2200$0.0000$0.0000$0.0000$0.0000$0.00
Production Control2,5060$0.0000$0.0000$0.0000$0.0000$0.00
Tool/Die/Model Maker1,6700$0.0000$0.0000$0.0000$0.0000$0.00
TOTAL CPFF LABOR36,748- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT ESTIMATED HOURS BY LABOR CATEGORY
MATERIAL - ORDERING PERIOD 4Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$285,720.80
Indirect Rate Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$285,720.80
TRAVEL/ODCS - ORDERING PERIOD 4Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$36,000.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$36,000.00

Source Selection Information. See FAR 2.101 and 3.104

Ordering Period 5 Prime Contractor Name: 0

SUMMARY - ORDERING PERIOD 5
DescriptionAmount
CPFF Labor$0.00
CPFF Material$37,447.14
CPFF ODCs$36,000.00
Total - Ordering Period 5$73,447.14
COST PLUS FIXED FEE (CPFF) LABOR - ORDERING PERIOD 5 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryTotal Government Estimated HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Proposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountProposed HoursFully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager8350$0.0000$0.0000$0.0000$0.0000$0.00
Senior Engineer8350$0.0000$0.0000$0.0000$0.0000$0.00
General Engineer3,3410$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Technician4,1760$0.0000$0.0000$0.0000$0.0000$0.00
Engineering Technician5,0110$0.0000$0.0000$0.0000$0.0000$0.00
Draftsman1,6700$0.0000$0.0000$0.0000$0.0000$0.00
Manufacturing7,3080$0.0000$0.0000$0.0000$0.0000$0.00
Inspection and Testing4,1760$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Engineer5,2200$0.0000$0.0000$0.0000$0.0000$0.00
Production Control2,5060$0.0000$0.0000$0.0000$0.0000$0.00
Tool/Die/Model Maker8350$0.0000$0.0000$0.0000$0.0000$0.00
TOTAL CPFF LABOR35,913- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0- 0$ - 0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT ESTIMATED HOURS BY LABOR CATEGORY
MATERIAL - ORDERING PERIOD 5Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$37,447.14
Indirect Rate Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$37,447.14
TRAVEL/ODCS - ORDERING PERIOD 5Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$36,000.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$36,000.00

Source Selection Information. See FAR 2.101 and 3.104

Sample Detailed Rate Schedules The prime contractor and all subcontractors (including interdivisional transfers and affiliates under common control) with an estimated value of $750,000 or more must provide a breakdown of the cost elements for each proposed CPFF 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:

DETAILED RATE SCHEDULE SAMPLES:

Prime Contractor Rate:
Government Labor CategoryContractor Labor CategoryBase Hourly Labor RateLabor OverheadTotal Hourly Labor & OverheadG&AFully Burdened Labor RateFixed Fee DollarsFully Loaded CPFF Labor Rate
65.0%12.4%6%
Scientist/Program ManagerScientist I$37.00$24.05$61.05$7.57$68.62$4.12$72.74
Subcontractor Rate with Prime Contractor Adders:
Subcontractor Fully Loaded Labor RatePrime Contractor Adders on Subcontractor Fully Loaded Labor Rate
Government Labor CategoryContractor Labor CategoryBase Hourly Labor RateLabor OverheadTotal Hourly Labor & OverheadG&AFully Burdened Labor RateFeeFully Loaded CPFF Labor RatePrime M&H on Subcontractor LaborPrime Fully Burdened Labor Rate (Subs Fully Loaded Prime + Prime Indirect Costs)Prime Fixed Fee on SubcontractorPrime Proposed Fully Loaded CPFF Labor Rate
38.2%14.2%3%2%6%
Quality Control TechnicianN/A$25.63$9.79$35.42$5.03$40.45$1.21$41.66$0.83$42.49$2.55$45.04

Source Selection Information. See FAR 2.101 and 3.104

Sample Matl&ODCs

Note: ODCs and Travel are reimbursed at cost. Indirect rates applicable to ODCs and Travel are reimbursed at cost. No profit/fee shall be proposed.
Sample Table - Material, Travel/ODCs - Ordering Period 1:
MATERIAL - ORDERING PERIOD 1Application BaseIndirect RateTotal
DescriptionDollars
Government Provided Material Dollars$1,307,320.80
Material HandlingMaterial Dollars$1,307,320.802.50%$32,683.02
G&AMaterial Dollars + Material Handling$ 1,340,003.8212.40%$166,160.47
TOTAL MATERIAL & INDIRECT COSTS - ORDERING PERIOD 1$1,506,164.29
TRAVEL/ODCS - ORDERING PERIOD 1Application BaseRateTotal
DescriptionDollars
Government Provided Material Dollars$36,000.00
G&ATravel & ODCs$36,000.0012.40%$4,464.00
Indirect Rate Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS - ORDERING PERIOD 1$40,464.00

Source Selection Information. See FAR 2.101 and 3.104

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