Attachment_0008_CPFF_Requirements.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
SUPPORT- PROFESSIONAL: ENGINEERING/TECHNICAL
Solicitation number
W15QKN16R0019
Issued by

About this file

Attachment 0008 CPFF Requirements

View the file

Other files

Show all 16

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

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 .