Attachment_L-9,_Cost_Model.xlsx

XLSX spreadsheet 80 KB Posted

Attached to
Wind Tunnel Compressor Rotor Blades Federal contract opportunity
Solicitation number
FA9101-17-R-1000
Issued by
Department of the Air Force Materiel Command Test Center

About this file

Cost Model

View the file

Other files for this federal contract opportunity

Other files attached to Wind Tunnel Compressor Rotor Blades, newest first.
File Type Posted
Answers_to_Industry_Questions_16_May_2017.pdf PDF
Attachment_3_-_Revised_Section_L.pdf PDF
Industry_Day_2_Attendees.pdf PDF
CFD_Condition_Chart_Blade_RFP.pdf PDF
AEDC_Blade_Load_Test_Rig.pdf PDF
Revised_Atch_1_16T_C1_Compressor_Blades_SOW.pdf PDF
Attachment_L-6,__Relevancy_Matrix.xlsx XLSX spreadsheet
Attachment_L-7,_Cross_Reference_Matrix.xlsx XLSX spreadsheet
Industry_Day_12_April_17_Agenda.pdf PDF
run04_r2_pressure.csv CSV file
run02_r2_pressure.csv CSV file
Attachment_4_-_Section_L_Phase_2.pdf PDF
Attachment_L-4,_Client_Authorization_Letter.pdf PDF
run07_r2_pressure.csv CSV file
Attachment_5__-_Section_M.pdf PDF
run01_r3_pressure.csv CSV file
Attachment_L-7,_Cross_Reference_Matrix.xlsx XLSX spreadsheet
run02_r1_pressure.csv CSV file
Attachment_L-9,_Cost_Model.xlsx XLSX spreadsheet
run03_r1_pressure.csv CSV file
Attachment_L-6,__Relevancy_Matrix.xlsx XLSX spreadsheet
Attachment_L-3,_PPQ_Cover_Letter.pdf PDF
Attachment_2_-_14424-17-003_16T_C1_Compressor_Blades_Spec.pdf PDF
Attachment_L-2,_Past_Performance_Questionnaire.pdf PDF
PPI_Tool.accdb —
AR1001B_C_01_stamp.pdf PDF
16T_Blade_Pin_Aero_Surface.SAT —
AR1001C_C_01_stamp.pdf PDF
RowC_Blade_Assembly_For_Information_Only.stp STP file
PG108745_C_1_CALSP_stamp_stamp.pdf PDF
PU630917.01_A_1_SVEPA_stamp_stamp_stamp.pdf PDF
PG108761_C_1_CALSP_stamp_stamp.pdf PDF
PG108760.stp STP file
Industry_Responses_1_FBO.pdf PDF
Industry_Day_registration_requirements.pdf PDF
AR1001B-101.stp STP file
AR1001C-101.stp STP file
AR1001A_C_01_stamp.pdf PDF
PG631713.01_C.stp STP file
PG108745_C_2_CALSP_stamp_stamp.pdf PDF
AR1001A-101.stp STP file
FA9101-17-R-1000.pdf PDF
Industry_Day_-_Afternoon_Presentation.pdf PDF
Agenda.pdf PDF
PWT_16T_Comp_C1_Blades_RFI_v_05.pdf PDF
3202100.6_H_0206_AROIN_stamp_stamp.pdf PDF
3202100.6_H_0206_AROIN_stamp.pdf PDF
6440-1102_C_0101_PARSC_stamp_stamp.pdf PDF
3202100.23_G__AROIN_stamp_stamp.pdf PDF
3202100.6_H_0606_AROIN_stamp_stamp.pdf PDF
Show all 50

Wind Tunnel Compressor Rotor Blades has more files on GovTribe.

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

Instructions

1.The purpose of this attachment is to enable offerors a simplified way to input their production costs into a single spreadsheet.
2.The Government will evaluate this attachment in addition to the Cost Price Section AND Technical Sections in its evaluation of realism, balance, and reasonableness.
3.Many cells contain formulas to simplify calculations. If you need to modify any of cells within the tabs, please highlight them to aid in evaluation.
4.The cells highlighted in light green generally require an offerors input. The cells highlighted in grey are automated calculations.
5.It is anticipated the offeror will modify the date on each CLIN to reflect the proposed schedule. The Government intends to only use one FY of funding per CLIN. That is, no split funding of a CLIN.
6.Ultimately, it is up to the offeror to ensure the total for each tab feeds into the 'Total Evaluated Price' tab and that all proposed prices are correct.
7.The Government will accept the inclusion of the Basis of Estimate for each CLIN in the form of additional tabs to this document. If included, please add them after the Glossary tab.
8.The Government will accept the inclusion of any other substantiating information in the form of additional tabs to this document. If included, please add them after the Glossary tab.
9.Feel free to use the 'Glossary' tab to help explain any special material or tooling cost. It is also helpful (if applicable) to reference the appropriate page(s) from the Technical Volume to facilitate evaluation.

CLIN 0001 - Design through TDR Design through Technical Design Review (TDR)

GOVT FISCAL YEAR 1 - 201X
COST/PRICE ELEMENT
LABORQTYUNIT OF MEASURE

JOHNS, JOSHUA D-1: Typically Hours, Lbs, etc.

PROPOSED RATEAMOUNT
DIRECT LABOR
LABOR CATEGORY 10.00The Government anticipates the input of direct hourly rates in the "Labor" cells.
LABOR CATEGORY 20.00
LABOR CATEGORY 30.00
LABOR CATEGORY 40.00
LABOR CATEGORY 50.00
LABOR CATEGORY 60.00
LABOR CATEGORY 70.00
LABOR CATEGORY 80.00
LABOR CATEGORY 90.00
LABOR CATEGORY 100.00
LABOR CATEGORY 110.00
LABOR CATEGORY 120.00
DIRECT LABOR COST0.000.00
FRINGE LABOR PERCENTAGE0.00
LABOR OVERHEAD PERCENTAGE0.00

TOTAL LABOR COST - 0

SUBCONTRACTOR/TEAMINGAMOUNT
SUB LABOR CATEGORY 1The Government anticipates the input of fully burdened labor rates in the Subcontractor/Teaming labor cells.
SUB LABOR CATEGORY 2
SUB LABOR CATEGORY 3
Total Subcontractor/Team Cost- 0

DIRECT MATERIALS QTY UNIT OF MEASURE

JOHNS, JOSHUA D-1: Typically Hours, Lbs, etc.

PROPOSED RATEAMOUNT
Material Item 10
Material Item 20
Material Item 30
Material Item 40
Material Item 50
Material Item 60
Material Item 70
Material Item 80
Material Item 90
Material Item 100
Material Item 110
Material Item 120
Material Item 130
DIRECT MATERIAL COST00
MATERIAL OVERHEAD PERCENTAGE0

TOTAL MATERIAL COST - 0

OTHER DIRECT COSTS

JOHNS, JOSHUA D-1: This includes travel, consultants, etc.

JOHNS, JOSHUA D-1: Typically Hours, Lbs, etc.

QTYTYPEPROPOSED RATEAMOUNT
Item 10
Item 20
Item 30
Item 40
Item 50
Item 60
TOTAL OTHER DIRECT COST- 0
PERCENTAGETOTAL
G&A (to include DATA CLIN 0002)0
PERCENTAGETOTAL
FACILITIES CAPITAL COST OF MONEY0

FIXED FEE 0

PROPOSED PRICE FOR CLIN 0001 0.00

CLIN 0003 - Final Design Final Design

GOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORQTYUNIT OF MEASURE

JOHNS, JOSHUA D-1: Typically Hours, Lbs, etc.

PROPOSED RATEAMOUNT
DIRECT LABOR
LABOR CATEGORY 10.00The Government anticipates the input of direct hourly rates in the "Labor" cells.
LABOR CATEGORY 20.00
LABOR CATEGORY 30.00
LABOR CATEGORY 40.00
LABOR CATEGORY 50.00
LABOR CATEGORY 60.00
LABOR CATEGORY 70.00
LABOR CATEGORY 80.00
LABOR CATEGORY 90.00
LABOR CATEGORY 100.00
LABOR CATEGORY 110.00
LABOR CATEGORY 120.00
DIRECT LABOR COST0.000.00
FRINGE LABOR PERCENTAGE0
LABOR OVERHEAD PERCENTAGE0

TOTAL LABOR COST - 0

SUBCONTRACTOR/TEAMINGAMOUNT
SUB LABOR CATEGORY 1The Government anticipates the input of fully burdened labor rates in the Subcontractor/Teaming labor cells.
SUB LABOR CATEGORY 2
SUB LABOR CATEGORY 3
Total Subcontractor/Team Cost- 0

DIRECT MATERIALS QTY UNIT OF MEASURE

JOHNS, JOSHUA D-1: Typically Hours, Lbs, etc.

PROPOSED RATEAMOUNT
Material Item 10
Material Item 20
Material Item 30
Material Item 40
Material Item 50
Material Item 60
Material Item 70
Material Item 80
Material Item 90
Material Item 100
Material Item 110
Material Item 120
Material Item 130
DIRECT MATERIAL COST00
MATERIAL OVERHEAD PERCENTAGE0

TOTAL MATERIAL COST - 0

OTHER DIRECT COSTS

JOHNS, JOSHUA D-1: This includes travel, consultants, etc.

JOHNS, JOSHUA D-1: Typically Hours, Lbs, etc.

QTYTYPEPROPOSED RATEAMOUNT
Item 10
Item 20
Item 30
Item 40
Item 50
Item 60
TOTAL OTHER DIRECT COST- 0
PERCENTAGEAMOUNT
G&A (to include DATA CLIN 0004)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

FIXED FEE 0

PROPOSED PRICE FOR CLIN 0003 0.00

CLIN 0005 - Tooling Tooling

GOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

JOHNS, JOSHUA D-1: This includes travel, consultants, etc.

AMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNT
G&A (to include DATA CLIN 0008)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0005 0.00

*Note: The Government recognizes the cost of tooling represents a significant investment for this acquistion. As a result, the Government intends for the offeror to uniformly distribute the cost of the tooling across each of the 10 prototypes. The Government believes this is a mechanism that best optimizes cash flow for both the offeror and the Government.

CLIN 0006 - Testing Proto Manufacturing Process, Testing, and Prototypes

GOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

AMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNT
G&A (to include DATA CLIN 0008)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0006 0.00

PROPOSED PRICE EACH FOR CLIN 00060.00
*Note: The Government recognizes the cost of tooling represents a significant investment for this acquistion. As a result, the Government intends for the offeror to uniformly distribute the cost of the tooling across each of the 10 prototypes. The Government believes this is a mechanism that best optimizes cash flow for both the offeror and the Government.

CLIN 0007 -LRIP

Production and testing of Low Rate Initial Production (LRIP) Blades

GOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

AMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNT
G&A (to include DATA CLIN 0008)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0007 0.00

CLIN 0009 -1st Blade Run Second Run of Compressor Rotor Blades

GOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

AMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNT
G&A (to include DATA CLIN 0011)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0009 0.00

CLIN 0010 -Repair Course Repair Course

GOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

AMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNT
G&A (to include DATA CLIN 0011)0

PROPOSED PRICE FOR CLIN 0010 0.00

CLIN 0012 -2nd Blade Run Second Run of Compressor Rotor Blades

GOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

AMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNT
G&A (to include DATA CLIN 0013)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0012 0.00

CLIN 0014 -1st Partial First Partial Run of Compressor Rotor Blades [49 Blades]

GOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

AMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNT
G&A (to include DATA CLIN 0015)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0014 0.00

CLIN 0016 -2nd Partial Second Partial of Compressor Rotor Blades [48 Blades]

GOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

AMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNT
G&A (to include DATA CLIN 0017)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0016 0.00

Total Evaluated Price

CLINDescriptionProposed PriceContract Type
CLIN 0001Design through Technical Design Review (TDR)0.00CPFF
CLIN 0003Final Design0.00CPFF
CLIN 0005Tooling0.00FFP
CLIN 0006Manufacturing Process, Testing, and Prototypes0.00FFP
CLIN 0007Production and testing of Low Rate Initial Production (LRIP) Blades0.00FFP
CLIN 0009First Run of Compressor Rotor Blades0.00FFP
CLIN 0010Repair Course0.00FFP
CLIN 0012Second Run of Compressor Rotor Blades0.00FFP
CLIN 0014First Partial Run of Compressor Rotor Blades [49 Blades]0.00FFP
CLIN 0016Second Partial of Compressor Rotor Blades [48 Blades]0.00FFP
Total Evaluated Price0.00
-As noted in the RFP, only CLINS 0001-0011 are included in the TEP. However, all CLINs will be evaluated in accordance with the elements described in Section M of this solicitation.

Glossary Please include any specific defintions in the space provided below.

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