Attachment 0009 MedCal NRE Price Matrix.xlsx

XLSX spreadsheet 59 KB Posted

Attached to
MEDIUM CALIBER NON-RECURRING ENGINEERING (NRE) - AMENDMENT NO. 0001 Federal contract opportunity
Solicitation number
W15QKN20R0104
Issued by
Department of the Army Materiel Command Contracting Command Picatinny Arsenal

About this file

This document contains a price matrix and cost proposal template for a medium caliber non-recurring engineering solicitation from the Army Contracting Command - New Jersey on behalf of the Project Manager for Maneuver Ammunition Systems.

The price matrix outlines firm fixed price and cost plus fixed fee requirements across five ordering periods to provide non-recurring engineering development, manufacturing, design, and testing support for 20mm, 25mm, 30mm x 113mm, 30mm x 173mm, and 50mm weapon systems. Pricing is provided for labor, material, and travel under both fixed price and cost reimbursement structures. The template requires offerors to populate labor rates, hours, costs for material, subcontractors, indirect rates and profit data for evaluation. The total evaluated price across all requirements and ordering periods is $14,575,000.

View the file

Other files for this federal contract opportunity

Show all 13

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-20-R-0104
ATTACHMENT 0010
PRICE MATRIX
CLINDescriptionEvaluated Price FFP RequirementProbable Cost CPFF RequirementTotal Evaluated Price
CLIN 0001OP1 Medium Caliber NRE FFP Requirements$735,000$735,000
CLIN 0002OP1 Medium Caliber NRE CPFF Requirements$2,180,000$2,180,000
Total Requirement - OP1$2,915,000
CLIN 0003OP2 Medium Caliber NRE FFP Requirements$735,000$735,000
CLIN 0004OP2 Medium Caliber NRE CPFF Requirements$2,180,000$2,180,000
Total Requirement - OP2$2,915,000
CLIN 0005OP3 Medium Caliber NRE FFP Requirements$735,000$735,000
CLIN 0006OP3 Medium Caliber NRE CPFF Requirements$2,180,000$2,180,000
Total Requirement - OP3$2,915,000
CLIN 0007OP4 Medium Caliber NRE FFP Requirements$735,000$735,000
CLIN 0008OP4 Medium Caliber NRE CPFF Requirements$2,180,000$2,180,000
Total Requirement - OP4$2,915,000
CLIN 0009OP5 Medium Caliber NRE FFP Requirements$735,000$735,000
CLIN 0010OP5 Medium Caliber NRE CPFF Requirements$2,180,000$2,180,000
Total Requirement - OP5$2,915,000
TOTAL ALL CLINs$14,575,000

FFP OP1-5

Offeror Name:0= Offeror Fill-In Cells
= Government Provided Amounts; not to be changed/adjusted
SUMMARY-ORDERING PERIOD (OP) 1-5
DescriptionAmount
FFP Labor$0
FFP Material$3,625,000
FFP Travel$50,000
Total FFP - OP1-5$3,675,000
FIRM FIXED PRICE (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 Manager510$0510$0510$0510$0125$02165$0
Senior Engineer1040$01040$01040$01040$0125$04285$0
General Engineer1040$01040$01040$01040$0125$04285$0
Quality Control Engineer1040$01040$01040$01040$0125$04285$0
Engineering Technician800$0800$0800$0800$0120$03320$0
Draftsman400$0400$0400$0400$0100$01700$0
Manufacturing5000$05000$05000$05000$02750$022750$0
Inspection and Testing600$0600$0600$0600$0220$02620$0
Quality Control Technician600$0600$0600$0600$0220$02620$0
Production Control400$0400$0400$0400$0200$01800$0
Tool/Die/Model Maker520$0520$0520$0520$0200$02280$0
TOTAL FFP LABOR11,950$011,950$ - 011,950$ - 011,950$ - 04,310$ - 052,110$0
*CANNOT CHANGE/ADJUST GOVERNMENT PROVIDED HOURS BY LABOR CATEGORY
MATERIAL - OP1 FFPApplication BaseIndirect Rate - OP1 **TotalApplicationIndirect Rate - OP2 **TotalApplicationIndirect Rate - OP3 **TotalApplicationIndirect Rate - OP4 **TotalApplicationIndirect Rate - OP5 **Total
DescriptionDollarsDollarsDollarsDollarsDollars
Government Provided Material Dollars$725,000$725,000$725,000$725,000$725,000
Indirect Cost (i.e. Mat'l Handling, G&A)$0$0$0$0$0
Indirect Cost (i.e. Mat'l Handling, G&A)$0$0$0$0$0
Profit Rate$0$0$0$0$0
TOTAL MATERIAL, INDIRECT COSTS & PROFIT$725,000$725,000$725,000$725,000$725,000$3,625,000
TRAVEL - OP1 FFPApplication BaseIndirect Rate - OP1 **TotalApplicationIndirect Rate - OP2 **TotalApplicationIndirect Rate - OP3 **TotalApplicationIndirect Rate - OP4 **TotalApplicationIndirect Rate - OP5 **Total
DescriptionDollarsDollarsDollarsDollarsDollars
Government Provided Travel Dollars$10,000$10,000$10,000$10,000$10,000
Indirect Cost Title$0$0$0$0$0
Indirect Cost Title$0$0$0$0$0
Profit Rate$0$0$0$0$0
TOTAL TRAVEL, INDIRECT COSTS & PROFIT$10,000$10,000$10,000$10,000$10,000$50,000
** INDIRECT RATES SHALL BE THE SAME ON CPFF AND FFP EFFORT

TOTAL FFP $735,000 $735,000 $735,000 $735,000 $735,000 $3,675,000

OP1 CPFF

Offeror Name:0= Offeror Fill-In Cells
= Government Provided Amounts; not to be changed/adjusted
SUMMARY-ORDERING PERIOD (OP) 1
DescriptionAmount
CPFF Labor$0
CPFF Material$2,150,000
CPFF Travel$30,000
Total CPFF - Ordering Period 1$2,180,000
COST PLUS FIXED FEE (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 Manager1530$0$0.00$0$0.00$0$0.00$00$0
Senior Engineer3120$0$0.00$0$0.00$0$0.00$00$0
General Engineer3120$0$0.00$0$0.00$0$0.00$00$0
Quality Control Engineer3120$0$0.00$0$0.00$0$0.00$00$0
Engineering Technician2400$0$0.00$0$0.00$0$0.00$00$0
Draftsman1200$0$0.00$0$0.00$0$0.00$00$0
Manufacturing15000$0$0.00$0$0.00$0$0.00$00$0
Inspection and Testing1800$0$0.00$0$0.00$0$0.00$00$0
Quality Control Technician1800$0$0.00$0$0.00$0$0.00$00$0
Production Control1200$0$0.00$0$0.00$0$0.00$00$0
Tool/Die/Model Maker1560$0$0.00$0$0.00$0$0.00$00$0
TOTAL CPFF LABOR358500$0- 0$ - 0- 0$ - 0- 0$ - 0- 0$0
*MUST TIE TO COLUMN B TOTAL GOVERNMENT PROVIDED HOURS BY LABOR CATEGORY
MATERIAL - OP1 CPFFApplication BaseIndirect Rate **Total
DescriptionDollars
Government Provided Material Dollars$2,150,000
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Profit Rate$0
TOTAL MATERIAL, INDIRECT COSTS and PROFIT - OP1$2,150,000
TRAVEL - OP1 CPFFApplication BaseIndirect Rate **Total
DescriptionDollars
Government Provided Travel Dollars$30,000
Indirect Cost Title$0
Indirect Cost Title$0
Profit Rate$0
TOTAL TRAVEL, INDIRECT COSTS and PROFIT - OP1$30,000
** INDIRECT RATES SHALL BE THE SAME ON CPFF AND FFP EFFORT

Source Selection Information. See FAR 2.101 and 3.104

OP2 CPFF

Offeror Name:0= Offeror Fill-In Cells
= Government Provided Amounts; not to be changed/adjusted
SUMMARY-ORDERING PERIOD (OP) 2
DescriptionAmount
CPFF Labor$0
CPFF Material$2,150,000
CPFF Travel$30,000
Total CPFF - Ordering Period 2$2,180,000
COST PLUS FIXED FEE (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 Manager1530$0$0.00$0$0.00$0$0.00$00$0
Senior Engineer3120$0$0.00$0$0.00$0$0.00$00$0
General Engineer3120$0$0.00$0$0.00$0$0.00$00$0
Quality Control Engineer3120$0$0.00$0$0.00$0$0.00$00$0
Engineering Technician2400$0$0.00$0$0.00$0$0.00$00$0
Draftsman1200$0$0.00$0$0.00$0$0.00$00$0
Manufacturing15000$0$0.00$0$0.00$0$0.00$00$0
Inspection and Testing1800$0$0.00$0$0.00$0$0.00$00$0
Quality Control Technician1800$0$0.00$0$0.00$0$0.00$00$0
Production Control1200$0$0.00$0$0.00$0$0.00$00$0
Tool/Die/Model Maker1560$0$0.00$0$0.00$0$0.00$00$0
TOTAL CPFF LABOR358500$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 Rate **Total
DescriptionDollars
Government Provided Material Dollars$2,150,000
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Profit Rate$0
TOTAL MATERIAL, INDIRECT COSTS and PROFIT - OP2$2,150,000
TRAVEL - OP1 CPFFApplication BaseIndirect Rate **Total
DescriptionDollars
Government Provided Travel Dollars$30,000
Indirect Cost Title$0
Indirect Cost Title$0
Profit Rate$0
TOTAL TRAVEL, INDIRECT COSTS and PROFIT - OP2$30,000
** INDIRECT RATES SHALL BE THE SAME ON CPFF AND FFP EFFORT

Source Selection Information. See FAR 2.101 and 3.104

OP3 CPFF

Offeror Name:0= Offeror Fill-In Cells
= Government Provided Amounts; not to be changed/adjusted
SUMMARY-ORDERING PERIOD (OP) 3
DescriptionAmount
CPFF Labor$0
CPFF Material$2,150,000
CPFF Travel$30,000
Total CPFF - Ordering Period 3$2,180,000
COST PLUS FIXED FEE (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 Manager1530$0$0.00$0$0.00$0$0.00$00$0
Senior Engineer3120$0$0.00$0$0.00$0$0.00$00$0
General Engineer3120$0$0.00$0$0.00$0$0.00$00$0
Quality Control Engineer3120$0$0.00$0$0.00$0$0.00$00$0
Engineering Technician2400$0$0.00$0$0.00$0$0.00$00$0
Draftsman1200$0$0.00$0$0.00$0$0.00$00$0
Manufacturing15000$0$0.00$0$0.00$0$0.00$00$0
Inspection and Testing1800$0$0.00$0$0.00$0$0.00$00$0
Quality Control Technician1800$0$0.00$0$0.00$0$0.00$00$0
Production Control1200$0$0.00$0$0.00$0$0.00$00$0
Tool/Die/Model Maker1560$0$0.00$0$0.00$0$0.00$00$0
TOTAL CPFF LABOR358500$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 Rate **Total
DescriptionDollars
Government Provided Material Dollars$2,150,000
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Profit Rate$0
TOTAL MATERIAL, INDIRECT COSTS and PROFIT - OP3$2,150,000
TRAVEL - OP1 CPFFApplication BaseIndirect Rate **Total
DescriptionDollars
Government Provided Travel Dollars$30,000
Indirect Cost Title$0
Indirect Cost Title$0
Profit Rate$0
TOTAL TRAVEL, INDIRECT COSTS and PROFIT - OP3$30,000
** INDIRECT RATES SHALL BE THE SAME ON CPFF AND FFP EFFORT

Source Selection Information. See FAR 2.101 and 3.104

OP4 CPFF

Offeror Name:0= Offeror Fill-In Cells
= Government Provided Amounts; not to be changed/adjusted
SUMMARY-ORDERING PERIOD (OP) 4
DescriptionAmount
CPFF Labor$0
CPFF Material$2,150,000
CPFF Travel$30,000
Total CPFF - Ordering Period 4$2,180,000
COST PLUS FIXED FEE (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 Manager1530$0$0.00$0$0.00$0$0.00$00$0
Senior Engineer3120$0$0.00$0$0.00$0$0.00$00$0
General Engineer3120$0$0.00$0$0.00$0$0.00$00$0
Quality Control Engineer3120$0$0.00$0$0.00$0$0.00$00$0
Engineering Technician2400$0$0.00$0$0.00$0$0.00$00$0
Draftsman1200$0$0.00$0$0.00$0$0.00$00$0
Manufacturing15000$0$0.00$0$0.00$0$0.00$00$0
Inspection and Testing1800$0$0.00$0$0.00$0$0.00$00$0
Quality Control Technician1800$0$0.00$0$0.00$0$0.00$00$0
Production Control1200$0$0.00$0$0.00$0$0.00$00$0
Tool/Die/Model Maker1560$0$0.00$0$0.00$0$0.00$00$0
TOTAL CPFF LABOR358500$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 Rate **Total
DescriptionDollars
Government Provided Material Dollars$2,150,000
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Profit Rate$0
TOTAL MATERIAL, INDIRECT COSTS and PROFIT - OP4$2,150,000
TRAVEL - OP1 CPFFApplication BaseIndirect Rate **Total
DescriptionDollars
Government Provided Travel Dollars$30,000
Indirect Cost Title$0
Indirect Cost Title$0
Profit Rate$0
TOTAL TRAVEL, INDIRECT COSTS and PROFIT - OP4$30,000
** INDIRECT RATES SHALL BE THE SAME ON CPFF AND FFP EFFORT

Source Selection Information. See FAR 2.101 and 3.104

OP5 CPFF

Offeror Name:0= Offeror Fill-In Cells
= Government Provided Amounts; not to be changed/adjusted
SUMMARY-ORDERING PERIOD (OP) 5
DescriptionAmount
CPFF Labor$0
CPFF Material$2,150,000
CPFF Travel$30,000
Total CPFF - Ordering Period 5$2,180,000
COST PLUS FIXED FEE (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 Manager375$0$0.00$0$0.00$0$0.00$00$0
Senior Engineer375$0$0.00$0$0.00$0$0.00$00$0
General Engineer375$0$0.00$0$0.00$0$0.00$00$0
Quality Control Engineer375$0$0.00$0$0.00$0$0.00$00$0
Engineering Technician360$0$0.00$0$0.00$0$0.00$00$0
Draftsman300$0$0.00$0$0.00$0$0.00$00$0
Manufacturing8250$0$0.00$0$0.00$0$0.00$00$0
Inspection and Testing660$0$0.00$0$0.00$0$0.00$00$0
Quality Control Technician660$0$0.00$0$0.00$0$0.00$00$0
Production Control600$0$0.00$0$0.00$0$0.00$00$0
Tool/Die/Model Maker600$0$0.00$0$0.00$0$0.00$00$0
TOTAL CPFF LABOR129300$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 Rate **Total
DescriptionDollars
Government Provided Material Dollars$2,150,000
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Indirect Cost Title (i.e. Mat'l Handling, G&A)$0
Profit Rate$0
TOTAL MATERIAL, INDIRECT COSTS and PROFIT - OP5$2,150,000
TRAVEL - OP1 CPFFApplication BaseIndirect Rate **Total
DescriptionDollars
Government Provided Travel Dollars$30,000
Indirect Cost Title$0
Indirect Cost Title$0
Profit Rate$0
TOTAL TRAVEL, INDIRECT COSTS and PROFIT - OP5$30,000
** INDIRECT RATES SHALL BE THE SAME ON CPFF AND FFP EFFORT

Source Selection Information. See FAR 2.101 and 3.104

Sample CPFF Rate Detail The prime contractor and all subcontractors (including interdivisional transfers and affiliates under common control) with a total proposed value over $2,000,000 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 Matl&ODCs

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 - 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
Profit Rate$ 1,340,003.828.00%$107,200.31
TOTAL MATERIAL, INDIRECT COSTS and PROFIT - 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
Profit Rate$36,000.008.00%$2,880.00
TOTAL TRAVEL, INDIRECT COSTS and PROFIT- 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 .