Attachment_L-9,_Cost_Model.xlsx

XLSX spreadsheet 97 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

Atch L-9 - 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
Industry_Day_2_Slides_-_scan.pdf PDF
Amendment_0002_-_FBO.pdf PDF
Amendment_0001.pdf PDF
Current_Spacer_Seal_Configuration.xlsx XLSX spreadsheet
Amendment_0001_Answers_to_Industry_Questions.pdf PDF
Slides_Industry_Day_12_April_17_-_FBO.pdf PDF
Revised_Atch_2_16T_C1_Compressor_Blades_Equipment_Specification.pdf PDF
Attachment_L-8,_Cross_Reference_Matrix_for_Phase_2.xlsx XLSX spreadsheet
AEDC_Map.pdf PDF
Flying_into_Nashville_and_Driving_to_AEDC.pdf PDF
Map_to_GLC.pdf PDF
run03_r3_pressure.csv CSV file
FA9101-17-R-1000.pdf PDF
run06_r3_pressure.csv CSV file
Attachment_3_-_Section_L.pdf PDF
run04_r1_pressure.csv CSV file
run05_r2_pressure.csv CSV file
run06_r2_pressure.csv CSV file
Attachment_6__-_Section_M_Phase_2.pdf PDF
Attachment_L-5,_Subcontractor_Consent_Letter.pdf PDF
run04_r3_pressure.csv CSV file
run01_r1_pressure.csv CSV file
run05_r3_pressure.csv CSV file
Attachment_L-1_PPI_Tool.accdb —
run07_r3_pressure.csv CSV file
run05_r1_pressure.csv CSV file
run03_r2_pressure.csv CSV file
Attachment_L-1,_PPI_Tool_Instruction.pdf PDF
SKRO6199.pdf PDF
run06_r1_pressure.csv CSV file
PG108760_C_2_CALSP_stamp_stamp.pdf PDF
PG631713.01_B.stp STP file
PG209017_A_1_stamp_stamp_stamp.pdf PDF
PU630917.01_A_2_SVEPA_stamp_stamp_stamp.pdf PDF
16T_Blade_Pin_Aero_Surface.SLDPRT —
RowB_Blade_Assembly_For_Information_Only.stp STP file
RowA_Blade_Assembly_For_Information_Only.stp STP file
PG108761_C_2_CALSP_stamp_stamp.pdf PDF
PG108760_C_1_CALSP_stamp_stamp.pdf PDF
PG108761.stp STP file
Attachment_L-9,_Cost_Model.xlsx XLSX spreadsheet
C1_compressor_blade_synopsis.pdf PDF
Draft_RFP_Cover_Letter_-_signed.pdf PDF
Industry_Day_Attendee_List.pdf PDF
Industry_Day_-_Morning_Presentation.pdf PDF
PWT_16T_Comp_C1_Blades_RFI_v_04.pdf PDF
16T_C1_Blade_Design_SOW_14424-002-17.pdf PDF
3202100.6_H_0106_AROIN_stamp_stamp.pdf PDF
Transonic_C1_Compressor_Fiberglass_Blade_Construction.pdf PDF
PWT_16T_Comp_C1_Blades_RFI_Draft_v_03.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.

Atch 3.9

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
Prototype StagePrototype Stage
GOVT FISCAL YEAR X - 201XGOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNTAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNTAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNTAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

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

AMOUNTAMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNTPERCENTAGEAMOUNT
G&A (to include DATA CLIN 0007)00
PERCENTAGEAMOUNTPERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY00
PROPOSED PRICE FOR CLIN 0005AA -- Prototype Stage0.00
PROPOSED PRICE FOR CLIN 0005AB -- Production Stage0.00
* The Government understands this tab may require significant modification to demonstrate the cost of tooling at the different stages during the acquisition.
*It is intentionally limit to facilitate utmost contractor flexibility.

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 0007)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0006 0.00

CLIN 0008 -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 0009)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0007 0.00

CLIN 0010 -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 0012)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0010 0.00

CLIN 0011 -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 0012)0

PROPOSED PRICE FOR CLIN 0011 0.00

CLIN 0013 -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 0014)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0013 0.00

CLIN 0015 -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 0016)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0015 0.00

CLIN 0017 -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 0018)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0

PROPOSED PRICE FOR CLIN 0017 0.00

CLIN 0019 - Blade Caps Blade Tip Cap Spares

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 0018)0
PERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY0
PROPOSED PRICE FOR CLIN 00190.00
PROPOSED PRICE FOR CLIN 0019 (EACH)0.00

CLIN 0020 -Blade Cuffs

Blade Cuff Spares -- Row A
Row ARow BRow C
GOVT FISCAL YEAR X - 201XGOVT FISCAL YEAR X - 201XGOVT FISCAL YEAR X - 201X
COST/PRICE ELEMENT
LABORAMOUNTAMOUNTAMOUNT
TOTAL LABOR COST
SUBCONTRACTOR/TEAMINGAMOUNTAMOUNTAMOUNT
TOTAL SUBCONTRACTOR/TEAMING COST
DIRECT MATERIALSAMOUNTAMOUNTAMOUNT
TOTAL MATERIAL COST

OTHER DIRECT COSTS

AMOUNTAMOUNTAMOUNT
TOTAL OTHER DIRECT COST
PERCENTAGEAMOUNTPERCENTAGEAMOUNTPERCENTAGEAMOUNT
G&A000
PERCENTAGEAMOUNTPERCENTAGEAMOUNTPERCENTAGEAMOUNT
FACILITIES CAPITAL COST OF MONEY000
Each
PROPOSED PRICE FOR CLIN 0020AA0.000.00
PROPOSED PRICE FOR CLIN 0020AB0.000.00
PROPOSED PRICE FOR CLIN 0020AC0.000.00

Total Evaluated Price

CLINDescriptionProposed PriceContract Type
CLIN 0001Design through Technical Design Review (TDR)0.00CPFF
CLIN 0003Final Design0.00CPFF*Not to Exceed
CLIN 0005AATooling - Prototype Stage0.00FFP
CLIN 0005ABTooling - Production Stage0.00FFP
CLIN 0006Manufacturing Process, Testing, and Prototypes0.00FFP
CLIN 0008Production and testing of Low Rate Initial Production (LRIP) Blades0.00FFP
CLIN 0010First Run of Compressor Rotor Blades0.00FFP
CLIN 0011Repair Course0.00FFP
CLIN 0013Second Run of Compressor Rotor Blades0.00FFP
CLIN 0015First Partial Run of Compressor Rotor Blades [49 Blades]0.00FFP
CLIN 0017Second Partial of Compressor Rotor Blades [48 Blades]0.00FFP
CLIN 0019Blade Tip Cap Spares0.00FFP
CLIN 0020AABlade Cuff Spares -- Row A0.00FFP
CLIN 0020ABBlade Cuff Spares -- Row B0.00FFP
CLIN 0020ACBlade Cuff Spares -- Row C0.00FFP
Total Evaluated Price0.00
-As noted in the RFP, only CLINS 0001-0014; 19-20 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 .