Attachment 0006 - Small Cal NRE Price Matrix.xlsx

XLSX spreadsheet 58 KB Posted

Attached to
Small Caliber Non-Recurring Engineering, Manufacturing, Design and Testing Support Federal contract opportunity
Solicitation number
W15QKN-22-R-0036
Issued by
Department of the Army Materiel Command Contracting Command Picatinny Arsenal

About this file

This document contains a price matrix and summaries for a small caliber non-recurring engineering solicitation. The U.S. Army Contracting Command - New Jersey is seeking proposals for test assets, engineering and technical support, manufacturing production and process assessments, product and process design development, components, testing, training aids, fabrication, and qualification of production representative items for small caliber ammunition systems up to 6.8mm caliber. The requirement includes non-recurring engineering for design, development, testing and evaluation across five ordering periods. Pricing is provided for both firm-fixed-price and cost-plus-fixed-fee requirements for labor, material, travel and indirect costs. Labor categories and hours are specified for each ordering period along with instructions for fully loaded rate details.

View the file

Other files for this federal contract opportunity

Show all 18

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

Summary OFFEROR: = Offeror Fill-In Cells

Solicitation No. W15QKN-22-R-0036
ATTACHMENT 0006
PRICE MATRIX
CLINDescriptionFFP RequirementCPFF RequirementTotal
0001OP1 Small Caliber NRE FFP Requirements$421,242$421,242
0002OP1 Small Caliber NRE CPFF Requirements$1,263,726$1,263,726
Total OP1$421,242$1,263,726$1,684,968
0003OP2 Small Caliber NRE FFP Requirements$447,992$447,992
0004OP2 Small Caliber NRE CPFF Requirements$1,343,976$1,343,976
Total OP2$447,992$1,343,976$1,791,968
0005OP3 Small Caliber NRE FFP Requirements$571,242$571,242
0006OP3 Small Caliber NRE CPFF Requirements$1,713,726$1,713,726
Total OP3$571,242$1,713,726$2,284,968
0007OP4 Small Caliber NRE FFP Requirements$421,242$421,242
0008OP4 Small Caliber NRE CPFF Requirements$1,263,726$1,263,726
Total OP4$421,242$1,263,726$1,684,968
0009OP5 Small Caliber NRE FFP Requirements$421,272$421,272
0010OP5 Small Caliber NRE CPFF Requirements$1,263,726$1,263,726
Total OP5$421,272$1,263,726$1,684,998

FFP OP1-5

Offeror Name:0= Offeror Fill-In Cells Required
Solicitation No. W15QKN-22-R-0036= Government Provided Amounts; not to be changed/adjusted
ATTACHMENT 0006
SUMMARY-FFP REQUIREMENTS
DescriptionOP1OP2OP3OP4OP5Total
AmountAmountAmountAmountAmount
FFP Labor$0$0$0$0$0$0
FFP Material$418,573$445,323$568,573$418,573$418,573$2,269,615
FFP Travel$2,669$2,669$2,669$2,669$2,699$13,375
Total FFP - OP1-5$421,242$447,992$571,242$421,242$421,272$2,282,990
FFP LABOR - OP1- 5 Offerors shall proposed only one rate per labor category
Labor CategoryOP1OP2OP3OP4OP5TOTAL
Gov't Provided HrsFFP Fully Loaded Labor RatesExtended AmountGov't Provided HrsFFP Fully Loaded Labor RatesExtended AmountGov't Provided HrsFFP Fully Loaded Labor RatesExtended AmountGov't Provided HrsFFP Fully Loaded Labor RatesExtended AmountGov't Provided HrsFFP Fully Loaded Labor RatesExtended AmountHoursAmount
Scientist/Program Manager209$0313$0209$0104$0104$0940$0
Senior Engineer209$0313$0209$0104$0104$0940$0
General Engineer418$0626$0418$0209$0209$01879$0
Quality Control Engineer209$0313$0209$0104$0104$0940$0
Engineering Technician209$0313$0209$0104$0104$0940$0
Draftsman209$0313$0209$0104$0104$0940$0
Manufacturing626$0940$0626$0313$0313$02819$0
Inspection and Testing209$0313$0209$0104$0104$0940$0
Quality Control Technician209$0313$0209$0104$0104$0940$0
Production Control209$0313$0209$0104$0104$0940$0
Tool/Die/Model Maker209$0313$0209$0104$0104$0940$0
TOTAL FFP LABOR2923$04,385$ - 02,923$ - 01,462$ - 01,462$ - 013,154$0
*CANNOT CHANGE/ADJUST GOVERNMENT PROVIDED HOURS BY LABOR CATEGORY

OP1 CPFF

Offeror Name:0= Offeror Fill-In Cells Required
Solicitation No. W15QKN-22-R-0036= Government Provided Amounts; not to be changed/adjusted
ATTACHMENT 0006
SUMMARY-OP 1
DescriptionAmount
CPFF Labor$0
CPFF Material$1,255,719
CPFF Travel$8,007
Total CPFF - OP1$1,263,726
CPFF LABOR - OP1 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryGovernment Provided HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Prime HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager626$0$0$0$00$0
Senior Engineer626$0$0$0$00$0
General Engineer1,253$0$0$0$00$0
Quality Control Engineer626$0$0$0$00$0
Engineering Technician626$0$0$0$00$0
Draftsman626$0$0$0$00$0
Manufacturing1,879$0$0$0$00$0
Inspection and Testing626$0$0$0$00$0
Quality Control Technician626$0$0$0$00$0
Production Control626$0$0$0$00$0
Tool/Die/Model Maker626$0$0$0$00$0
TOTAL CPFF LABOR8,7700$0- 0$ - 0- 0$ - 0- 0$ - 00$0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT PROVIDED HOURS BY LABOR CATEGORY
MATERIAL - OP1 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Material Dollars$1,255,719
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Fee Rate$0
TOTAL MATERIAL, INDIRECT COSTS and FEE - OP1$1,255,719
TRAVEL - OP1 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Travel Dollars$8,007
Indirect Cost Title$0
Indirect Cost Title$0
Fee Rate$0
TOTAL TRAVEL, INDIRECT COSTS and FEE - OP1$8,007

Source Selection Information. See FAR 2.101 and 3.104

OP2 CPFF

Offeror Name:0= Offeror Fill-In Cells
Solicitation No. W15QKN-22-R-0036= Government Provided Amounts; not to be changed/adjusted
ATTACHMENT 0006
SUMMARY-OP 2
DescriptionAmount
CPFF Labor$0
CPFF Material$1,335,969
CPFF Travel$8,007
Total CPFF - OP 2$1,343,976
CPFF LABOR - OP2 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryGovernment Provided HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Prime HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager940$0$0$0$00$0
Senior Engineer940$0$0$0$00$0
General Engineer1879$0$0$0$00$0
Quality Control Engineer940$0$0$0$00$0
Engineering Technician940$0$0$0$00$0
Draftsman940$0$0$0$00$0
Manufacturing2819$0$0$0$00$0
Inspection and Testing940$0$0$0$00$0
Quality Control Technician940$0$0$0$00$0
Production Control940$0$0$0$00$0
Tool/Die/Model Maker940$0$0$0$00$0
TOTAL CPFF LABOR131540$0- 0$ - 0- 0$ - 0- 0$ - 0- 0$0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT PROVIDED HOURS BY LABOR CATEGORY
MATERIAL - OP2 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Material Dollars$1,335,969
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Fee Rate$0
TOTAL MATERIAL, INDIRECT COSTS and FEE - OP2$1,335,969
TRAVEL - OP1 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Travel Dollars$8,007
Indirect Cost Title$0
Indirect Cost Title$0
Fee Rate$0
TOTAL TRAVEL, INDIRECT COSTS and FEE - OP2$8,007

Source Selection Information. See FAR 2.101 and 3.104

OP3 CPFF

Offeror Name:0= Offeror Fill-In Cells Required
Solicitation No. W15QKN-22-R-0036= Government Provided Amounts; not to be changed/adjusted
ATTACHMENT 0006
SUMMARY-OP 3
DescriptionAmount
CPFF Labor$0
CPFF Material$1,705,719
CPFF Travel$8,007
Total CPFF - OP 3$1,713,726
CPFF LABOR - OP3 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryGovernment Provided HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Prime HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager626$0$0$0$00$0
Senior Engineer626$0$0$0$00$0
General Engineer1253$0$0$0$00$0
Quality Control Engineer626$0$0$0$00$0
Engineering Technician626$0$0$0$00$0
Draftsman626$0$0$0$00$0
Manufacturing1879$0$0$0$00$0
Inspection and Testing626$0$0$0$00$0
Quality Control Technician626$0$0$0$00$0
Production Control626$0$0$0$00$0
Tool/Die/Model Maker626$0$0$0$00$0
TOTAL CPFF LABOR87700$0- 0$ - 0- 0$ - 0- 0$ - 0- 0$0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT PROVIDED HOURS BY LABOR CATEGORY
MATERIAL - OP3 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Material Dollars$1,705,719
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Fee Rate$0
TOTAL MATERIAL, INDIRECT COSTS and FEE - OP3$1,705,719
TRAVEL - OP1 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Travel Dollars$8,007
Indirect Cost Title$0
Indirect Cost Title$0
Fee Rate$0
TOTAL TRAVEL, INDIRECT COSTS and FEE - OP3$8,007

Source Selection Information. See FAR 2.101 and 3.104

OP4 CPFF

Offeror Name:0= Offeror Fill-In Cells
Solicitation No. W15QKN-22-R-0036= Government Provided Amounts; not to be changed/adjusted
ATTACHMENT 0006
SUMMARY-OP 4
DescriptionAmount
CPFF Labor$0
CPFF Material$1,255,719
CPFF Travel$8,007
Total CPFF - OP 4$1,263,726
CPFF LABOR - OP4 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryGovernment Provided HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Prime HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager313$0$0$0$00$0
Senior Engineer313$0$0$0$00$0
General Engineer626$0$0$0$00$0
Quality Control Engineer313$0$0$0$00$0
Engineering Technician313$0$0$0$00$0
Draftsman313$0$0$0$00$0
Manufacturing940$0$0$0$00$0
Inspection and Testing313$0$0$0$00$0
Quality Control Technician313$0$0$0$00$0
Production Control313$0$0$0$00$0
Tool/Die/Model Maker313$0$0$0$00$0
TOTAL CPFF LABOR43850$0- 0$ - 0- 0$ - 0- 0$ - 0- 0$0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT PROVIDED HOURS BY LABOR CATEGORY
MATERIAL - OP4 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Material Dollars$1,255,719
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Fee Rate$0
TOTAL MATERIAL, INDIRECT COSTS and FEE - OP4$1,255,719
TRAVEL - OP1 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Travel Dollars$8,007
Indirect Cost Title$0
Indirect Cost Title$0
Fee Rate$0
TOTAL TRAVEL, INDIRECT COSTS and FEE - OP4$8,007

Source Selection Information. See FAR 2.101 and 3.104

OP5 CPFF

Offeror Name:0= Offeror Fill-In Cells Required
Solicitation No. W15QKN-22-R-0036= Government Provided Amounts; not to be changed/adjusted
ATTACHMENT 0006
SUMMARY-OP 5
DescriptionAmount
CPFF Labor$0
CPFF Material$1,255,719
CPFF Travel$8,007
Total CPFF - OP 5$1,263,726
CPFF LABOR - OP5 - Add more columns for subcontractors, if necessary. Update formulas in Total Hours and Total Amount columns to reflect additional subcontractors.
Labor CategoryGovernment Provided HoursPrime ContractorSubcontractor 1: Insert Name HereSubcontractor 2: Insert Name HereSubcontractor 3: Insert Name HereTOTAL
Prime HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountAllocated HoursCPFF Fully Loaded Labor RatesExtended AmountHours*Amount
Scientist/Program Manager313$0$0$0$00$0
Senior Engineer313$0$0$0$00$0
General Engineer626$0$0$0$00$0
Quality Control Engineer313$0$0$0$00$0
Engineering Technician313$0$0$0$00$0
Draftsman313$0$0$0$00$0
Manufacturing940$0$0$0$00$0
Inspection and Testing313$0$0$0$00$0
Quality Control Technician313$0$0$0$00$0
Production Control313$0$0$0$00$0
Tool/Die/Model Maker313$0$0$0$00$0
TOTAL CPFF LABOR43850$0- 0$ - 0- 0$ - 0- 0$ - 0- 0$0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT PROVIDED HOURS BY LABOR CATEGORY
MATERIAL - OP5 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Material Dollars$1,255,719
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Fee Rate$0
TOTAL MATERIAL, INDIRECT COSTS and FEE - OP5$1,255,719
TRAVEL - OP1 CPFFApplication BaseIndirect RateTotal
DescriptionDollars
Government Provided Travel Dollars$8,007
Indirect Cost Title$0
Indirect Cost Title$0
Fee Rate$0
TOTAL TRAVEL, INDIRECT COSTS and FEE - OP5$8,007

Source Selection Information. See FAR 2.101 and 3.104

Sample CPFF Rate Detail The Offerpr and all subcontractors (including interdivisional transfers and affiliates under common control) 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. Offerors and subcontractors breakdown of the fully loaded labor rates may differ depending on their established accounting practices

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 CPFF Matl & Travel

Note: Chart below is provided as an example; indirect costs applicable to Material and Travel should be applied based upon the Offeror's established accounting practices
Sample Table - CPFF Material, Travel - Ordering Period 1:
MATERIAL - OP1Application BaseIndirect RateTotal
DescriptionDollars
Government Provided Material Dollars$1,307,320.80
Material HandlingMaterial Dollars$1,307,320.802.50%$32,683.02
G&ATotal Cost Input$ 1,340,003.8212.40%$166,160.47
Fee Rate$ 1,340,003.828.00%$107,200.31
TOTAL MATERIAL, INDIRECT COSTS and FEE - ORDERING PERIOD 1$1,613,364.60
TRAVEL - OP1Application BaseRateTotal
DescriptionDollars
Government Provided Travel Dollars$36,000.00
G&ATotal Cost Input$36,000.0012.40%$4,464.00
Fee Rate$36,000.008.00%$2,880.00
TOTAL TRAVEL, INDIRECT COSTS and FEE- ORDERING PERIOD 1$43,344.00

Source Selection Information. See FAR 2.101 and 3.104

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