Attachment3_Pricing_MatrixBRU-56.xlsx

XLSX spreadsheet 48 KB Posted

Attached to
B-52 BRU-56 Modification Solicitation Federal contract opportunity
Solicitation number
FA810718R0007
Issued by
Department of the Air Force Materiel Command

About this file

From the source

Attachment 3 BRU-56 Pricing Matrix

View the file

Other files for this federal contract opportunity

Other files attached to B-52 BRU-56 Modification Solicitation, newest first.
File Type Posted
Amendment_SOW.pdf PDF
CDRLs_Amendment.pdf PDF
SRD_Amendment.pdf PDF
FA810718R0007_______0001.pdf PDF
Additional_Q&A_PostSolicitation.docx DOCX document
Q&A_PostSolicitation.docx DOCX document
Q&A_from_Solicitation.docx DOCX document
FA810718R0007_BRU-56_Solicitation.pdf PDF
Attachment2_BRU-56_SRD.pdf PDF
Attachment10_PPI_Tool.accdb MDB file
Attachment7_dd2345.pdf PDF
Attachment8_Section_L.pdf PDF
Attachment5_GFE_ModuleAttachment.xlsx XLSX spreadsheet
Attachment4_ContractorSelfAssertion.pdf PDF
Attachment6_BRU-56_CDRLS_Signed.PDF PDF
Attachment9_Section_M.pdf PDF
Attachment1_BRU-56_SOW_20180730.pdf PDF
Show all 17

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.

Attachment 3

ATTACHMENT 3
BRU-56 Price Matrix
18-May-18

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.