Att L-14_Unit_Pricing_Matrix.xlsx

XLSX spreadsheet 46 KB Posted

Attached to
SOLICITATION -- MULTI-ENGINE TRAINING SYSTEM (METS) AIRCRAFT PROCUREMENT Federal contract opportunity
Solicitation number
N00019-21-R-0077
Issued by
Department of the Navy Naval Air Systems Command

About this file

Written by GovTribe AI ·

This document package includes a solicitation for the procurement of Multi-Engine Training System (METS) aircraft to replace the T-44C aircraft currently used by the United States Navy for aviator and flight officer training. The Naval Air Systems Command anticipates awarding a single firm fixed price contract through full and open competition for the total procurement of commercial aircraft over a base period with options. Proposals are due by March 16, 2022, and contract award is targeted for the first quarter of fiscal year 2023. The solicitation seeks the delivery of METS aircraft, associated data, spare parts, peculiar support equipment, contractor logistics support, and training services over potential multiple production lots and option years. Questions shall be submitted in writing to the identified procuring contracting officer and contract specialist by the response deadline.

View the file

Other files for this federal contract opportunity

Other files attached to SOLICITATION -- MULTI-ENGINE TRAINING SYSTEM (METS) AIRCRAFT PROCUREMENT, newest first.
File Type Posted
N0001921R0077 METS RFP Amend 0002.pdf PDF
220202 METS_QA_Sheet Responses Batch VII.pdf PDF
Conformed copy through Amend 0002.pdf PDF
N0001921R0077 METS RFP_Amend 0001.pdf PDF
Att L-13 Corporate Experience Amend 0002.xlsx XLSX spreadsheet
N0001921R0077 METS RFP Amend 0001.pdf PDF
Att L-1 Verification Matrix Amend 0001.xlsx XLSX spreadsheet
Conformed copy through Amend 0001.pdf PDF
Att-2 METS Airplane Specification Rev2 13Dec2021 Amend 0001.pdf PDF
Att L-2 SPD Amend 0001.pdf PDF
Att-1 METS Airplane PWS_112921.pdf PDF
Att-1 METS CLS PWS Appendix B_112921.pdf PDF
Att-12 Real Property.pdf PDF
Att L-3 SPD Team Experience.docx DOCX document
Att L-6 Access Agreement.docx DOCX document
Att L-7 Workload Analysis Instructions.pdf PDF
Att L-16_PSE_List_with_Price.xlsx XLSX spreadsheet
METS QA Sheet.xlsx XLSX spreadsheet
Att-11 CDRL Disposition Letter Template.pdf PDF
Exhibit T METS OT DIDs.pdf PDF
Att L-15_SPL_with_Price.xlsx XLSX spreadsheet
Competition Library.zip ZIP file
Att-2 METS Airplane Specification Rev2 13Dec2021.pdf PDF
Exhibit A METS CDRLs.pdf PDF
Att L-8 Workload Analysis Form.xlsx XLSX spreadsheet
Att L-11 Flyaway Kits List.docx DOCX document
N0001921R0077 METS RFP.pdf PDF
Att-1 METS Airplane PWS Appendix A--Cyber Security Plan.pdf PDF
Att-6 Source of Repair Instructions.pdf PDF
Att-8 GFP.xlsx XLSX spreadsheet
Att L-1 Verification Matrix.xlsx XLSX spreadsheet
Att L-2 SPD.pdf PDF
Att L-4 Sustainment Features Matrix.xlsx XLSX spreadsheet
Att L-5 Special License Agreement.docx DOCX document
Att L-13 Corporate Experience.xlsx XLSX spreadsheet
Att L-17 Rights in Data.xlsx XLSX spreadsheet
METS RFP Changes.pdf PDF
Show all 37

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.

Instructions The Offeror shall populate the Unit Pricing Matrix. The Offeror shall ensure that information populated is consistent with Attachment L-15 SPL with Price, Attachment L-16 PSE List with Price.

Tab: Unit Pricing Matrix
ColumnNameInstructions
CProgram ElementPopulate the program element. Insert rows above the Insert Rows Here line.
DUnit PricePopulate the unit price per program element.
ENumber of UnitsPopulate the number of units per program element.
FType of UnitPopulate the type of unit.
GTotal PriceWhen inserting a new row, populate the Total Price formula: Unit Price*Number of Units from the cell above.
Specific Instructions by CLINInstructions
0X01 METS PRODUCTION Lot X (including Engineering Reach Back)Price out METS Aircraft separately from line items indicated in the white cells of column C. Add Flyaway Kits and additional rows as needed.
0X02 Data in Support of Lot XNot Priced Separately (NPS), no need to populate data.
0X03 Spare Parts Lot XPopulate the CLIN total from Attachment L-15 SPL with Price.
0X04 Engine Spare Parts Lot XPopulate the CLIN total from Attachment L-15 SPL with Price.
0X05 Peculiar Support Equipment Lot XPopulate the CLIN total from Attachment L-16 PSE List with Price.
0X06 Instructor Pilot TrainingPopulate program elements needed for the Instructor Pilot Training Course.
0X07 Maintenance Personnel TrainingPopulate program elements needed for the Maintenance Pilot Training Course.
0X08 Ground Based Training Design Support DataNo specific instructions.
0X09 Data Access in Excess of FFF/OMITNo specific instructions.
0X10 Contractor Logistics SupportPopulate program elements needed for Contractor Logistics Support.
0X11 Contractor Logistics SupportPopulate program elements needed for Contractor Logistics Support.
0X12 Contractor Logistics SupportPopulate program elements needed for Contractor Logistics Support.
0X13 Contractor Logistics Services Phase-InPopulate program elements needed for Contractor Logistics Services Phase-In.
0X14 Contractor Logistics Services Phase-OutPopulate program elements needed for Contractor Logistics Services Phase-Out.
Tabs: Summary Unit Pricing Matrix; Base; Option 1; Option 2; Total Evaluated Price
Tabs will automatically populate based on the Unit Pricing Matrix. No Offeror inputs are needed for these tabs.

N0001921R0077 &F &A

Unit Pricing Matrix Att L-14_Unit_Pricing_Matrix.xlsx CONTRACTOR INPUT

The Offeror can add as many rows as it deems necessary under each CLIN to substantiate its price.
Current inputs in blue cells are strictly dummy values for example purposes. The Offeror should override these cells with its own inputs.
CLINProgram ElementUnit PriceNumber of UnitsType of UnitTotal Price
Column ReferenceCDEFGERROR:#REF!
Cell Results(D*E)=G
PRODUCTION CONTRACT TOTAL$ 80,108,800

OPTION YEAR 1 TOTAL $ 15,503,200

0001METS PRODUCTION LOT 1 (including Engineering Reach Back)$ 12,603,200
METS Aircraft$ 1,000,00010Aircraft$ 10,000,000
Engineering Reach Back$ 4004,000Hours$ 1,600,000
Crash Survivable Cockpit Voice and Flight Data Recorder$ 10015Units$ 1,500
Maintenance Ground Station$ 1006Units$ 600
CBM+ Data Transfer Units or Electronic Kneeboards$ 10010Units$ 1,000
Integrated Data Environment Interface Software$ 1001Unit$ 100
Fly Away Kit$ 100,00010Kits$ 1,000,000
Insert Rows Above Here$ - 0
0002Data in Support of Lot 1$ - 0
NPS$ - 0
0003Spare Parts Lot 1$ 300,000
0003 Total from Attachment L-15 Spare Parts List with Price$ 300,0001CLIN Total$ 300,000
0004Engine Spare Parts Lot 1$ 100,000
0004 Total from Attachment L-15 Spare Parts List with Price$ 100,0001CLIN Total$ 100,000
0005Peculiar Support Equipment Lot 1$ 100,000
0005 Total from Attachment L-16 PSE List with Price.$ 100,0001CLIN Total$ 100,000
0006Instructor Pilot Training$ 1,500,000
Instructor Pilot Training Course$ 100,00015Cadre Pilots$ 1,500,000
Insert Rows Above Here$ - 0
0007Maintenance Personnel Training$ 200,000
Maintenance Pilot Training Course$ 10,00020Maintainers$ 200,000
Insert Rows Above Here$ - 0
0008Ground Based Training Design Support Data$ 100,000
Data$ 10,00010Data$ 100,000
Insert Rows Above Here$ - 0
0009Data Access in Excess of FFF/OMIT$ 100,000
Access to Data$ 100,0001Data$ 100,000
Insert Rows Above Here$ - 0
0010Contractor Logistics Services$ 100,000
$ 100,0001$ 100,000
Insert Rows Above Here$ - 0
0011Contractor Logistics Services$ 100,000
$ 100,0001$ 100,000
Insert Rows Above Here$ - 0
0012Contractor Logistics Services$ 100,000
$ 100,0001$ 100,000
Insert Rows Above Here$ - 0
0013Contractor Logistics Service Phase-In$ 100,000
$ 100,0001$ 100,000
Insert Rows Above Here$ - 0
0014Contractor Logistics Service Phase-Out$ 100,000
$ 100,0001$ 100,000
Insert Rows Above Here$ - 0

OPTION YEAR 2 TOTAL $ 32,302,800

0101METS PRODUCTION LOT 2 (including Engineering Reach Back)$ 28,002,500
METS Aircraft$ 1,000,00024Aircraft$ 24,000,000
Engineering Reach Back$ 4004,000Hours$ 1,600,000
CBM+ Data Transfer Units or Electronic Kneeboards$ 10024Units$ 2,400
Integrated Data Environment Interface Software$ 1001Unit$ 100
Fly Away Kit$ 100,00024Kits$ 2,400,000
Insert Rows Above Here$ - 0
0102Data in Support of Lot 2$ - 0
NPS$ - 0
0103Spare Parts Lot 2$ 300,000
0103 Total from Attachment L-15 Spare Parts List with Price$ 300,0001CLIN Total$ 300,000
0104Engine Spare Parts Lot 2$ 100,000
0104 Total from Attachment L-15 Spare Parts List with Price$ 100,0001CLIN Total$ 100,000
0105Peculiar Support Equipment Lot 2$ 100,000
0105 Total from Attachment L-16 PSE List with Price.$ 100,0001CLIN Total$ 100,000
0201METS PRODUCTION LOT 2 Plus Up$ 3,300,300
METS Aircraft$ 1,000,0003Aircraft$ 3,000,000
CBM+ Data Transfer Units or Electronic Kneeboards$ 1003Units$ 300
Fly Away Kit$ 100,0003Kits$ 300,000
Insert Rows Above Here$ - 0
0202Data in Support of Lot 2$ - 0
NPS$ - 0
0203Spare Parts Lot 2 Plus Up$ 300,000
0203 Total from Attachment L-15 Spare Parts List with Price$ 300,0001CLIN Total$ 300,000
0204Engine Spare Parts Lot 2 Plus Up$ 100,000
0204 Total from Attachment L-15 Spare Parts List with Price$ 100,0001CLIN Total$ 100,000
0205Peculiar Support Equipment Lot 2 Plus Up$ 100,000
0205 Total from Attachment L-16 PSE List with Price.$ 100,0001CLIN Total$ 100,000

OPTION YEAR TOTAL $ 32,302,800

0301METS PRODUCTION LOT 3 (including Engineering Reach Back)$ 28,002,500
METS Aircraft$ 1,000,00024Aircraft$ 24,000,000
Engineering Reach Back$ 4004,000Hours$ 1,600,000
CBM+ Data Transfer Units or Electronic Kneeboards$ 10024Units$ 2,400
Integrated Data Environment Interface Software$ 1001Unit$ 100
Fly Away Kit$ 100,00024Kits$ 2,400,000
Insert Rows Above Here$ - 0
0302Data in Support of Lot 3$ - 0
NPS$ - 0
0303Spare Parts Lot 3$ 300,000
0303 Total from Attachment L-15 Spare Parts List with Price$ 300,0001CLIN Total$ 300,000
0304Engine Spare Parts Lot 3$ 100,000
0304 Total from Attachment L-15 Spare Parts List with Price$ 100,0001CLIN Total$ 100,000
0305Peculiar Support Equipment Lot 3$ 100,000
0305 Total from Attachment L-16 PSE List with Price.$ 100,0001CLIN Total$ 100,000
0401METS PRODUCTION LOT 3 Plus Up$ 3,300,300
METS Aircraft$ 1,000,0003Aircraft$ 3,000,000
CBM+ Data Transfer Units or Electronic Kneeboards$ 1003Units$ 300
Fly Away Kit$ 100,0003Kits$ 300,000
Insert Rows Above Here$ - 0
0402Data in Support of Lot 3 Plus Up$ - 0
NPS$ - 0
0403Spare Parts Lot 3 Plus Up$ 300,000
0403 Total from Attachment L-15 Spare Parts List with Price$ 300,0001CLIN Total$ 300,000
0404Engine Spare Parts Lot 3 Plus Up$ 100,000
0404 Total from Attachment L-15 Spare Parts List with Price$ 100,0001CLIN Total$ 100,000
0405Peculiar Support Equipment Lot 3 Plus Up$ 100,000
0405 Total from Attachment L-16 PSE List with Price.$ 100,0001CLIN Total$ 100,000

Summary Unit Pricing Matrix

Att L-14_Unit_Pricing_Matrix.xlsx

CLINDescriptionContract TypeUnit PriceQuantityTotal Price
Production Contract Total$80,108,800
BaseBase Total$15,503,200
0001METS PRODUCTION LOT 1 (including Engineering Reach Back)FFP$ 1,260,32010$12,603,200
0002Data in Support of Lot 1NSP
0003Spare Parts Lot 1FFP$ 300,0001$300,000
0004Engine Spare Parts Lot 1FFP$ 100,0001$100,000
0005Peculiar Support Equipment Lot 1FFP$ 100,0001$100,000
0006Instructor Pilot TrainingFFP$ 100,00015$1,500,000
0007Maintenance Personnel TrainingFFP$ 10,00020$200,000
0008Ground Based Training Design Support DataFFP$ 100,0001$100,000
0009Data Access in Excess of FFF/OMITFFP$ 100,0001$100,000
0010Contractor Logistics ServicesFFP$ 100,0001$100,000
0011Contractor Logistics ServicesFFP$ 100,0001$100,000
0012Contractor Logistics ServicesFFP$ 100,0001$100,000
0013Contractor Logistics Service Phase-InFFP$ 100,0001$100,000
0014Contractor Logistics Service Phase-OutFFP$ 100,0001$100,000
Option 1Option Year 1 Total$32,302,800
0101METS PRODUCTION LOT 2 (including Engineering Reach Back)FFP$ 1,166,77124$28,002,500
0102Data in Support of Lot 2NSP
0103Spare Parts Lot 2FFP$ 300,0001$300,000
0104Engine Spare Parts Lot 2FFP$ 100,0001$100,000
0105Peculiar Support Equipment Lot 2FFP$ 100,0001$100,000
0201METS PRODUCTION LOT 2 Plus UpFFP$ 1,100,1003$3,300,300
0202Data in Support of Lot 2NSP
0203Spare Parts Lot 2 Plus UpFFP$ 300,0001$300,000
0204Engine Spare Parts Lot 2 Plus UpFFP$ 100,0001$100,000
0205Peculiar Support Equipment Lot 2 Plus UpFFP$ 100,0001$100,000
Option 2Option Year 2 Total$32,302,800
0301METS PRODUCTION LOT 3 (including Engineering Reach Back)FFP$ 1,166,77124$28,002,500
0302Data in Support of Lot 3NSP
0303Spare Parts Lot 3FFP$ 300,0001$300,000
0304Engine Spare Parts Lot 3FFP$ 100,0001$100,000
0305Peculiar Support Equipment Lot 3FFP$ 100,0001$100,000
0401METS PRODUCTION LOT 3 Plus UpFFP$ 1,100,1003$3,300,300
0402Data in Support of Lot 3 Plus UpNSP
0403Spare Parts Lot 3 Plus UpFFP$ 300,0001$300,000
0404Engine Spare Parts Lot 3 Plus UpFFP$ 100,0001$100,000
0405Peculiar Support Equipment Lot 3 Plus UpFFP$ 100,0001$100,000

Base

Att L-14_Unit_Pricing_Matrix.xlsx
Base Year
CLINDescriptionContract TypeUnit PriceQuantityTotal Price
BaseTotal$15,503,200
0001METS PRODUCTION LOT DELIVERY (including Engineering Reach Back for Base Year)FFP$ 1,260,32010$12,603,200
0002DataNSP$ - 00$0
0003Spare PartsFFP$ 300,0001$300,000
0004Engine Spare PartsFFP$ 100,0001$100,000
0005Peculiar Support EquipmentFFP$ 100,0001$100,000
0006Instructor Pilot TrainingFFP$ 100,00015$1,500,000
0007Maintenance Personnel TrainingFFP$ 10,00020$200,000
0008Ground Based Training Design Support DataFFP$ 100,0001$100,000
0009Data Access in Excess of FFF/OMITFFP$ 100,0001$100,000
0010Contractor Logistics ServicesFFP$ 100,0001$100,000
0011Contractor Logistics ServicesFFP$ 100,0001$100,000
0012Contractor Logistics ServicesFFP$ 100,0001$100,000
0013Contractor Logistics Services Phase-InFFP$ 100,0001$100,000
0014Contractor Logistics Services Phase-OutFFP$ 100,0001$100,000

N0001921R0077

Option Year 1

Att L-14_Unit_Pricing_Matrix.xlsx
Option Year 1
CLINDescriptionContract TypeUnit PriceQuantityTotal Price
Option Year 1Total$32,302,800
0101METS PRODUCTION LOT 2 (including Engineering Reach Back)FFP$ 1,166,77124$28,002,500
0102Data in Support of Lot 2NSP$ - 00$0
0103Spare Parts Lot 2FFP$ 300,0001$300,000
0104Engine Spare Parts Lot 2FFP$ 100,0001$100,000
0105Peculiar Support Equipment Lot 2FFP$ 100,0001$100,000
0201METS PRODUCTION LOT 2 Plus UpFFP$ 1,100,1003$3,300,300
0202Data in Support of Lot 2NSP$ - 00$0
0203Spare Parts Lot 2 Plus UpFFP$ 300,0001$300,000
0204Engine Spare Parts Lot 2 Plus UpFFP$ 100,0001$100,000
0205Peculiar Support Equipment Lot 2 Plus UpFFP$ 100,0001$100,000

N0001921R0077

Option Year 2

Att L-14_Unit_Pricing_Matrix.xlsx
Option Year 2
CLINDescriptionContract TypeUnit PriceQuantityTotal Price
Option Year 2Total$32,302,800
0301METS PRODUCTION LOT 3 (including Engineering Reach Back)FFP$ 1,166,77124$28,002,500
0302Data in Support of Lot 3NSP$ - 00$0
0303Spare Parts Lot 3FFP$ 300,0001$300,000
0304Engine Spare Parts Lot 3FFP$ 100,0001$100,000
0305Peculiar Support Equipment Lot 3FFP$ 100,0001$100,000
0401METS PRODUCTION LOT 3 Plus UpFFP$ 1,100,1003$3,300,300
0402Data in Support of Lot 3 Plus UpNSP$ - 00$0
0403Spare Parts Lot 3 Plus UpFFP$ 300,0001$300,000
0404Engine Spare Parts Lot 3 Plus UpFFP$ 100,0001$100,000
0405Peculiar Support Equipment Lot 3 Plus UpFFP$ 100,0001$100,000

N0001921R0077

Total Evaluated Price

Att L-14_Unit_Pricing_Matrix.xlsx
Summary

Total Evaluated Price (TEP) $80,108,800.00

CLINDescriptionContract TypeBase YearOption 1Option 1 Plus UpOption 2Option 2
Plus UpGrand Total
Production Contract Total$15,503,200$28,502,500$3,800,300$28,502,500$3,800,300$80,108,800
0X01METS PRODUCTION LOT DELIVERY (including Engineering Reach Back for Base Year, Option 1, Option2)FFP$ 12,603,200$ 28,002,500$ 3,300,300$ 28,002,500$ 3,300,300$75,208,800
0X02DataNSP$ - 0$ - 0$ - 0$ - 0$ - 0$0
0X03Spare PartsFFP$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$1,500,000
0X04Engine Spare PartsFFP$ 100,000$ 100,000$ 100,000$ 100,000$ 100,000$500,000
0X05Peculiar Support EquipmentFFP$ 100,000$ 100,000$ 100,000$ 100,000$ 100,000$500,000
0006Instructor Pilot TrainingFFP$ 1,500,000$1,500,000
0007Maintenance Personnel TrainingFFP$ 200,000$200,000
0008Ground Based Training Design Support DataFFP$ 100,000$100,000
0009Data Access in Excess of FFF/OMITFFP$ 100,000$100,000
0010Contractor Logistics ServicesFFP$ 100,000$100,000
0011Contractor Logistics ServicesFFP$ 100,000$100,000
0012Contractor Logistics ServicesFFP$ 100,000$100,000
0013Contractor Logistics Services Phase-InFFP$ 100,000$100,000
0014Contractor Logistics Services Phase-OutFFP$ 100,000$100,000

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