Attachment_0008_CPFF_Requirements.xlsx

XLSX spreadsheet 52 KB Posted

Attached to
40mm Grenade Ammunitions - Medium Caliber (MC) Federal contract opportunity
Solicitation number
W15QKN19R0033
Issued by
Department of the Army Materiel Command Contracting Command Picatinny Arsenal

About this file

Attachment 0008

View the file

Other files for this federal contract opportunity

Show all 14

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$140,000.00
CPFF Travel/ODCs$13,300.00
Total - Ordering Period 1$153,300.00
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
Program Manager200$0.000$0.000$0.000$0.0000$0.00
Senior Engineer140$0.000$0.000$0.000$0.0000$0.00
General Engineer140$0.000$0.000$0.000$0.0000$0.00
Quality Control Engineer140$0.000$0.000$0.000$0.0000$0.00
Engineering Technician80$0.000$0.000$0.000$0.0000$0.00
Draftsman80$0.000$0.000$0.000$0.0000$0.00
Manufacturing400$0.000$0.000$0.000$0.0000$0.00
Inspection and Testing100$0.0000$0.000$0.000$0.0000$0.00
Quality Control Technician140$0.000$0.000$0.000$0.0000$0.00
Production Control100$0.000$0.000$0.000$0.000$0.00
Tool/Die/Model Maker60$0.000$0.000$0.000$0.0000$0.00
Clerical/Administrative40$0.000$0.000$0.000$0.0000$0.00
TOTAL CPFF LABOR1,620- 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$140,000.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$140,000.00
TRAVEL/ODCS - ORDERING PERIOD 1Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Travel/ODCs Dollars$13,300.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$13,300.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$200,000.00
CPFF Travel/ODCs$13,300.00
Total - Ordering Period 2$213,300.00
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
Program Manager2000$0.00$0.000$0.0000$0.0000$0.0000$0.00
Senior Engineer1400$0.00$0.000$0.0000$0.0000$0.0000$0.00
General Engineer1400$0.00$0.000$0.0000$0.0000$0.0000$0.00
Quality Control Engineer1400$0.00$0.000$0.0000$0.0000$0.0000$0.00
Engineering Technician800$0.00$0.000$0.0000$0.0000$0.0000$0.00
Draftsman800$0.00$0.000$0.0000$0.0000$0.0000$0.00
Manufacturing4000$0.00$0.000$0.0000$0.0000$0.0000$0.00
Inspection and Testing1600$0.00$0.000$0.0000$0.0000$0.0000$0.00
Quality Control Technician1400$0.00$0.000$0.0000$0.0000$0.0000$0.00
Production Control1600$0.00$0.000$0.0000$0.0000$0.0000$0.00
Tool/Die/Model Maker400$0.00$0.000$0.0000$0.0000$0.0000$0.00
Clerical/Administrative400$0.00$0.000$0.0000$0.0000$0.0000$0.00
TOTAL CPFF LABOR1,720- 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$200,000.00
Indirect Rate Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$200,000.00
TRAVEL/ODCS - ORDERING PERIOD 2Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Travel/ODCs Dollars$13,300.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$13,300.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$160,000.00
CPFF Travel/ODCs$13,300.00
Total - Ordering Period 3$173,300.00
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
Program Manager2000$0.0000$0.0000$0.0000$0.0000$0.00
Senior Engineer1400$0.0000$0.0000$0.0000$0.0000$0.00
General Engineer1400$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Engineer1400$0.0000$0.0000$0.0000$0.0000$0.00
Engineering Technician800$0.0000$0.0000$0.0000$0.0000$0.00
Draftsman800$0.0000$0.0000$0.0000$0.0000$0.00
Manufacturing4000$0.0000$0.0000$0.0000$0.0000$0.00
Inspection and Testing1600$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Technician1400$0.0000$0.0000$0.0000$0.0000$0.00
Production Control1600$0.0000$0.0000$0.0000$0.0000$0.00
Tool/Die/Model Maker400$0.0000$0.0000$0.0000$0.0000$0.00
Clerical/Administrative400$0.0000$0.0000$0.0000$0.0000$0.00
TOTAL CPFF LABOR1,720- 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 Travel/ODCs Dollars$160,000.00
Indirect Rate Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$160,000.00
TRAVEL/ODCS - ORDERING PERIOD 3Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Material Dollars$13,300.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$13,300.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$160,000.00
CPFF Travel/ODCs$13,300.00
Total - Ordering Period 4$173,300.00
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
Program Manager2000$0.0000$0.0000$0.0000$0.0000$0.00
Senior Engineer1400$0.0000$0.0000$0.0000$0.0000$0.00
General Engineer1400$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Engineer1400$0.0000$0.0000$0.0000$0.0000$0.00
Engineering Technician800$0.0000$0.0000$0.0000$0.0000$0.00
Draftsman800$0.0000$0.0000$0.0000$0.0000$0.00
Manufacturing4000$0.0000$0.0000$0.0000$0.0000$0.00
Inspection and Testing1600$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Technician1400$0.0000$0.0000$0.0000$0.0000$0.00
Production Control1600$0.0000$0.0000$0.0000$0.0000$0.00
Tool/Die/Model Maker400$0.0000$0.0000$0.0000$0.0000$0.00
Clerical/Administrative400$0.0000$0.0000$0.0000$0.0000$0.00
TOTAL CPFF LABOR1,720- 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$160,000.00
Indirect Rate Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$160,000.00
TRAVEL/ODCS - ORDERING PERIOD 4Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Travel/ODCs Dollars$13,300.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$13,300.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$240,000.00
CPFF Travel/ODCs$13,300.00
Total - Ordering Period 5$253,300.00
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
Program Manager2000$0.0000$0.0000$0.0000$0.0000$0.00
Senior Engineer1400$0.0000$0.0000$0.0000$0.0000$0.00
General Engineer1400$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Engineer1400$0.0000$0.0000$0.0000$0.0000$0.00
Engineering Technician800$0.0000$0.0000$0.0000$0.0000$0.00
Draftsman800$0.0000$0.0000$0.0000$0.0000$0.00
Manufacturing4000$0.0000$0.0000$0.0000$0.0000$0.00
Inspection and Testing1600$0.0000$0.0000$0.0000$0.0000$0.00
Quality Control Technician1400$0.0000$0.0000$0.0000$0.0000$0.00
Production Control1600$0.0000$0.0000$0.0000$0.0000$0.00
Tool/Die/Model Maker400$0.0000$0.0000$0.0000$0.0000$0.00
Clerical/Administrative400$0.0000$0.0000$0.0000$0.0000$0.00
TOTAL CPFF LABOR1,720- 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$240,000.00
Indirect Rate Title$0.00
Indirect Cost Title$0.00
TOTAL MATERIAL & INDIRECT COSTS$240,000.00
TRAVEL/ODCS - ORDERING PERIOD 5Application BaseCPFF Indirect RateTotal
DescriptionDollars
Government Provided Travel/ODCs Dollars$13,300.00
Indirect Cost Title$0.00
Indirect Cost Title$0.00
TOTAL TRAVEL/ODCS & INDIRECT COSTS$13,300.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.