Pricing_Matrix_B-1_BRU-56_DRAFT_-_Protected-R2.xlsx

XLSX spreadsheet 42 KB Posted

Attached to
B-1 Bomb Rack Unit (BRU) - 56 Modification Federal contract opportunity
Solicitation number
FA8107-18-R-0007
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center Tinker Air Force Base

About this file

From the source

B-1 BRU-56 Modification Price Matrix

View the file

Other files for this federal contract opportunity

Other files attached to B-1 Bomb Rack Unit (BRU) - 56 Modification, newest first.
File Type Posted
Additional_Q&A.docx DOCX document
Q&A_from_Pre-Solicitation_Conference.docx DOCX document
Revised_DRAFT_RFP_-_FA810718R0007.pdf PDF
BRU-56_Draft_RFP_Teleconference_Slides_-_24_May_18.pptx PPTX presentation
BRU-56_Draft_RFP_Teleconference_Slides_-_23_May_18.pptx PPTX presentation
BRU_SRD.pdf PDF
DRAFT_RFP_-_FA810718R0007.pdf PDF
Section_M_-_Evaluation_Factors_for_Award.pdf PDF
Section_L_-_Instructions_to_Offerors.pdf PDF
Pre-Solicitation_Conference_-_Rev.docx DOCX document
BRU-56_SOW.pdf PDF
Presolicitation_Conference_Registration_Form.xlsx XLSX spreadsheet
Show all 12

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
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Calculation Methodology

B-1 BRU-56 SOURCE SELECTION
CLINDESCRIPTIONCALCULATION METHODOLOGY
0001EMD Target CostTotal Cost from CPFF Cost Model
0002Fixed FeeTotal Fee from CPFF Cost Model
0003CR - TravelNot Evaluated
0004DATANot Separately Priced
0005FFP - Over & Above
Sr. EngineerProposed labor rate multiplied by estimated labor hours
Sr. Program ManagerProposed labor rate multiplied by estimated labor hours
Sr. MechanicProposed labor rate multiplied by estimated labor hours
Sr. Data MangerProposed labor rate multiplied by estimated labor hours
Sr. LogisticianProposed labor rate multiplied by estimated labor hours
0005Material Handling RateProposed material handling rate multiplied by estimated material dollars
1001FFP -- ProductionProposed unit price multiplied by quantity
1002FFP - Training
1002AAAircrew TrainingProposed price multiplied by quantity
1002ABLoad Crew TrainingProposed price multiplied by quantity
1002ACMaintenance TrainingProposed price multiplied by quantity
1003CR - TravelNot Evaluated
1004DATANot Separately Priced
1005FFP - Over & Above
Sr. EngineerProposed labor rate multiplied by estimated labor hours
Sr. Program ManagerProposed labor rate multiplied by estimated labor hours
Sr. MechanicProposed labor rate multiplied by estimated labor hours
Sr. Data MangerProposed labor rate multiplied by estimated labor hours
Sr. LogisticianProposed labor rate multiplied by estimated labor hours
1005Material Handling RateProposed material handling rate multiplied by estimated material dollars
TOTAL EVALUATED PRICEThe sum of CLINs 0001, 0002, 0005, 1001, 1002, and 1005

B-1 BRU-56 PRICING MATRIX

INSTRUCTIONS: Complete all cells highlighted in yellow

B-1 BRU-56 PRICING MATRIX
OFFEROR:
BASIC PERIOD
CLINTYPE/DESCRIPTIONQTYU/IEST COSTTOTAL EVALUATED PRICE
0001CPFF -- EMD Cost Only1LOInput Total Cost from CPFF Cost Model$ - 0
CLINTYPE/DESCRIPTIONQTYU/IFixed Fee
0002CPFF - Fixed Fee Only1LOInput Total Fee from CPFF Cost Model$ - 0
CLINTYPE/DESCRIPTION
0003CR - Travel - No FeeNot EvaluatedNot Evaluated
CLINTYPE/DESCRIPTION
0004DATANot Separately Priced
201920202021
CLINTYPE/DESCRIPTIONHoursRateTotalHoursRateTotalHoursRateTotalExtended Price
0005FFP - Over & Above
Sr. Engineer50$ - 050$ - 050$ - 0$ - 0$ - 0
Sr. Program Manager50$ - 050$ - 050$ - 0$ - 0$ - 0
Sr. Mechanic50$ - 050$ - 050$ - 0$ - 0$ - 0
Sr. Data Manager50$ - 050$ - 050$ - 0$ - 0$ - 0
Sr. Logistician50$ - 050$ - 050$ - 0$ - 0$ - 0
CLINTYPE/DESCRIPTIONDollarsRateTotalDollarsRateTotalDollarsRateTotalExtended Price
0005Material Handling Rate$ 100,000.00$ 100,000.00$ 100,000.00$ 100,000.00$ 100,000.00$ 100,000.00$ 300,000.00$ 300,000.00
$ 100,000.00$ 100,000.00$ 100,000.00
SubTotal Basic Period$ 300,000.00
OPTION I
CLINTYPE/DESCRIPTIONQtyU/IUnit PriceTotalExtended Price
1001FFP -- Production *1,004Ea$ - 0$ - 0$ - 0
* Total quantity is 1,004 with anticipated quantity of approximately 40 per month
CLINTYPE/DESCRIPTIONQtyU/IUnit PriceTotalExtended Price
1002FFP - Training
1002AAAircrew Training1LO$ - 0$ - 0$ - 0
1002ABLoad Crew Training1LO$ - 0$ - 0$ - 0
1002ACMaintenance Training1LO$ - 0$ - 0$ - 0
$ - 0
CLINTYPE/DESCRIPTION
1003CR - Travel - No FeeNot Evaluated
CLINTYPE/DESCRIPTION
1004DATANot Separately Priced
202120222023
CLINTYPE/DESCRIPTIONHoursRateTotalHoursRateTotalHoursRateTotalExtended Price
1005FFP - Over & Above
Sr. Engineer50$ - 050$ - 050$ - 0$ - 0$ - 0
Sr. Program Manager50$ - 050$ - 050$ - 0$ - 0$ - 0
Sr. Mechanic50$ - 050$ - 050$ - 0$ - 0$ - 0
Sr. Data Manager50$ - 050$ - 050$ - 0$ - 0$ - 0
Sr. Logistician50$ - 050$ - 050$ - 0$ - 0$ - 0
CLINTYPE/DESCRIPTIONDollarsRateTotalDollarsRateTotalDollarsRateTotalExtended Price
1005Material Handling Rate$ 100,000.00$ 100,000.00$ 100,000.00$ 100,000.00$ 100,000.00$ 100,000.00$ 300,000.00$ 300,000.00
$ 100,000.00$ 100,000.00$ 100,000.00
SubTotal Option I$ 300,000.00
TOTAL EVALUATED PRICE$ 600,000.00
CROSS CHECK$ 600,000.00
&8&A&8SOURCE SELECTION INFORMATION
SEE FAR 2.101 & 3.104&8&P

CPFF COST MODEL

Instructions - Complete all Cells highlighted in yellow as follows: Offeror's are required to provide Labor Categories (Column A),
Labor Hours (Column B), Basic Labor Rates (Column C) all Overhead/Indirect Rates related to labor (Cells D13, E13, F13), and fee % on labor (Column I).
Material Types (Column A), Quantities (Column C), Unit Prices (Column B), Material Handling Rate (Column E), and Fee % on Material (Column H)
Subcontractor Name (Column A), Subcontractor Cost (Column D), Material/SubK Rate (Column E) and Fee % on Subcontractors (Column H)
Offerors shall include formulas showing all calculations of proposed prices. Rounding is required IAW Section L Paragraph 6.1.1.
Offerors may use the cost model below or provide their own cost model on a separate worksheet but included in this workbook.
If an Offeror provides their own cost model the same information listed above must be provided including all formulas and rounding format.
Offerors shall input their proposed TOTAL COST and TOTAL FEE into the B-1 BRU-56 Pricing Matrix Worksheet
B-1 BRU-56 CPFF DETAILED COST SHEET FOR CLINs 0001 AND 0002
0
CLIN 0001 - EMD

CLIN 0002 - FEE

Labor CategoryEstimated Labor HoursBasic Labor Rate per HourFringe Cost per HourOH Cost per HourG&A Cost per HourBurdened Labor Cost by HourExtended Labor Cost without FeeFixed Fee %
Cannot Exceed 15%Fee on Labor per HourExtended Fixed FeeLoaded RatesEstimated Total
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ - 0$ - 0$ - 0
Material Type/DescriptionUnit PriceQtyMaterial
CostMaterial Handling Rate (%)Material Handling Overhead $SubtotalFixed Fee %
Cannot Exceed 15%Fee on Material
(cost x fee)Total Material
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
Total Material$ - 0$ - 0$ - 0$ - 0$ - 0
SubcontractorsSubcontractor
CostMaterial Handling SubK Rate (%)Material Handling SubK Overhead $SubtotalFixed Fee %
Cannot Exceed 15%Fee on Subcontractor
(cost x fee)Total Subcontractor
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
Total Subcontractor$ - 0$ - 0$ - 0$ - 0$ - 0
Total Cost (Labor + Material/Subcontract)Input Total COST on B-1 BRU-56 Pricing Matrix (Cell L7)$ - 0
Total FeeInput Total FEE on B-1 BRU-56 Pricing Matrix (Cell L10)$ - 0
TOTAL ESTIMATED COST$ - 0
CROSS CHECK$ - 0

&8&A SOURCE SELECTION INFORMATION SEE FAR 2.101 & 3.104 &8&P

Insert Fringe Rate on Labor Cell D13 Insert OH Rate on Labor Cell E13 Insert GA Rate on Labor Cell F13

EXAMPLE - CPFF COST MODEL

Instructions - Complete all Cells highlighted in yellow as follows: Offeror's are required to provide Labor Categories (Column A),
Labor Hours (Column B), Basic Labor Rates (Column C) all Overhead/Indirect Rates related to labor (Cells D13, E13, F13), and fee % on labor (Column I).
Material Types (Column A), Quantities (Column C), Unit Prices (Column B), Material Handling Rate (Column E), and Fee % on Material (Column H)
Subcontractor Name (Column A), Subcontractor Cost (Column D), Material/SubK Rate (Column E) and Fee % on Subcontractors (Column H)
Offerors shall include formulas showing all calculations of proposed prices. Rounding is required IAW Section L Paragraph 6.1.1.
Offerors may use the cost model below or provide their own cost model on a separate worksheet but included in this workbook.
If an Offeror provides their own cost model the same information listed above must be provided including all formulas and rounding format.
Offerors shall input their proposed TOTAL COST and TOTAL FEE into the B-1 BRU-56 Pricing Matrix Worksheet
B-1 BRU-56 CPFF DETAILED COST SHEET FOR CLINs 0001 AND 0002
ABC CO.
CLIN 0001 - EMD

CLIN 0002 - FEE

Labor CategoryEstimated Labor HoursBasic Labor Rate per HourFringe Cost per HourOH Cost per HourG&A Cost per HourBurdened Labor Cost by HourExtended Labor Cost without FeeFixed Fee %
Cannot Exceed 15%Fee on Labor per HourExtended Fixed FeeLoaded RatesEstimated Total
1.00%1.00%1.00%
Sr. Engineer100$ 100.00$ 1.00$ 1.00$ 1.00$ 103.00$ 10,300.0010%$ 10.30$ 1,030.00$ 113.30$ 11,330.00
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Total Labor$ 10,300.00$ 1,030.00$ 11,330.00
Material Type/DescriptionUnit PriceQtyMaterial
CostMaterial Handling Rate (%)Material Handling Overhead $SubtotalFixed Fee %
Cannot Exceed 15%Fee on Material
(cost x fee)Total Material
Widget$ 10.001,000$ 10,000.005.00%$ 500.00$ 10,500.0010.00%$ 1,050.00$ 11,550.00
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0
Total Material$ 10,000.00$ 500.00$ 10,500.00$ 1,050.00$ 11,550.00
SubcontractorsSubcontractor
CostMaterial Handling SubK Rate (%)Material Handling SubK Overhead $SubtotalFixed Fee %
Cannot Exceed 15%Fee on Subcontractor
(cost x fee)Total Subcontractor
XYZ Company$ 100,000.0010.00%$ 10,000.00$ 110,000.0010.00%$ 11,000.00$ 121,000.00
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0
Total Subcontractor$ 100,000.00$ 10,000.00$ 110,000.00$ 11,000.00$ 121,000.00
Total Cost (Labor + Material/Subcontract)Input Total COST on B-1 BRU-56 Pricing Matrix (Cell L7)$ 130,800.00
Total FeeInput Total FEE on B-1 BRU-56 Pricing Matrix (Cell L10)$ 13,080.00
TOTAL ESTIMATED COST$ 143,880.00
CROSS CHECK$ 143,880.00

&8&A SOURCE SELECTION INFORMATION SEE FAR 2.101 & 3.104 &8&P

Insert Fringe Rate on Labor Cell D13 Insert OH Rate on Labor Cell E13 Insert GA Rate on Labor Cell F13

Offeror Provided CPFF CostModel

Instructions: Offeror's are required to provide labor categories, labor hours, labor rates, all overhead/indirect rates, and fee percentage on labor.
Material types, quantities, unit prices, material handling rate, and fee percentage on material.
Subcontractor name, subcontractor costs, material/subcontractor rate, and fee percentage on subcontractor costs.
Offerors shall include formulas showing all calculations of proposed prices. Rounding is required IAW Section L Paragraph 6.1.1
Offerors shall input their proposed TOTAL COST and TOTAL FEE into the B-1 BRU-56 Pricing Matrix Worksheet
Offeror Name:

&8&A &"-,Bold"&8SOURCE SELECTION INFORMATION SEE FAR 2.101 & 3.104 &8&P

File details come from the government source that posted it.