Attachment_0007_-_Pricing_Matrix.xls

XLS spreadsheet 101 KB Posted Oct 3, 2017

Attached to: AVDS 1790 M88A1 and A2 Engine Overhaul
Solicitation number: W56HZV17R0095
Issued by: Department of the Army Materiel Command Contracting Command Detroit Arsenal

View the file

Other files

File	Type	Posted
AVDS_1790_M88A1_and_M88A2_Engine_Overhaul_Questions_and_answers.pdf	PDF	Oct 23, 2017
Attachment_0011_Certification_of_Small_Business_Size_and_Socioeconomic_Status_for_Subcontracto~.docx	DOCX document	Oct 3, 2017
Attachment_0010_Preaward_Survey_of_Prospective_Contractor_Accounting_System_Checklist.pdf	PDF	Oct 3, 2017
Solicitation_W56HZV17R0095.pdf	PDF	Oct 3, 2017
Attachment_0009_SBP-WorkbookInstructions.docx	DOCX document	Oct 3, 2017
Attachment_0005_AK01245387_A1_Engine_SPI.pdf	PDF	Oct 3, 2017
Attachment_0006_AK14146821_A2_Engine_SPI.pdf	PDF	Oct 3, 2017
Attachment_0001_NMWR_9-2815-220_Engine_(AVDS-1790).pdf	PDF	Oct 3, 2017
Attachment_0012_First_Article_Waiver_Worksheet.pdf	PDF	Oct 3, 2017
Attachment_0002_DMWR_247_A2_Engine.pdf	PDF	Oct 3, 2017
Attachment_0004_Modified_A1_-2DR_Engine_Dyno_Info.pdf	PDF	Oct 3, 2017
Attachment_0003_COLD_START_DEPOT_LEVEL.pdf	PDF	Oct 3, 2017
Copy_of_Attachment_0008_SBP-Workbook.xlsx	XLSX spreadsheet	Oct 3, 2017

Show all 13

On GovTribe

Work with this file

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

INSTRUCTIONS TO OFFERORS
General
1	M88 Engine Overhaul for two engine types (A1 and A2).
2	Firm Fixed Price (FFP) CLINs for Inspection, Teardown, Mandatory Replacement Parts (MRP), and First Article Test (FAT).
3	Cost Plus Fixed Fee (CPFF) CLINs for Engine Repair.
Summary Tab:
1	This tab summarizes all proposed prices, and calculates the total proposed price.
2	The Offeror shall input its name in cell B5. No other Offeror input is required.
"A1 I, T, R, & MRP" Tab:
1	This tab will represent the A1 Vehicles Inspection, Teardown, Reporting, and MRP price proposed by the Offeror.
2	Offeror input shall be provided in any applicable yellow highlighted cells.
3	Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.
4	Firm-Fixed-Price CLIN.
5	Five periods.
"A2 I, T, R, & MRP" Tab:
1	This tab will represent the A2 Inspection, Teardown, Reporting, and MRP price proposed by the Offeror.
2	Offeror input shall be provided in any applicable yellow highlighted cells.
3	Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.
4	Firm-Fixed-Price CLIN.
5	Five periods.
"A1 FAT" Tab:
1	This tab will represent the A1 First Article Test price proposed by the Offeror.
2	Offeror input shall be provided in any applicable yellow highlighted cells.
3	Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.
4	Firm-Fixed-Price CLIN.
5	Occurs in First Period.
"A2 FAT" Tab:
1	This tab will represent the A2 First Article Test price proposed by the Offeror.
2	Offeror input shall be provided in any applicable yellow highlighted cells.
3	Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.
4	Firm-Fixed-Price CLIN.
5	Occurs in First Period.
"A1 Engine Repair" Tab:
1	This tab will represent the A1 Engine Repair cost and fixed fee proposed by the Offeror.
2	Offeror input shall be provided in any applicable yellow highlighted cells.
3	Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.
4	This requirement includes an estimated Material "plug" number (for evaluation purposes only) which shall not be manipulated by the Offeror.
5	This requirement includes a labor hour "plug" number of 150 labor hours/unit for each year (for evaluation purposes only). The Offeror may determine how many hours per labor category, however, it must equal a total of 150 hours/unit in each year.
6	Cost Plus Fixed Fee (CPFF) CLIN.
7	Five periods.
"A2 Engine Repair" Tab:
1	This tab will represent the A2 Engine Repair cost and fixed fee proposed by the Offeror.
2	Offeror input shall be provided in any applicable yellow highlighted cells.
3	Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.
4	This requirement includes an estimated Material "plug" number (for evaluation purposes only) which shall not be manipulated by the Offeror.
5	This requirement includes a labor hour "plug" number of 150 labor hours/unit for each year (for evaluation purposes only). The Offeror may determine how many hours per labor category, however, it must equal a total of 150 hours/unit in each year.
6	Cost Plus Fixed Fee (CPFF) CLIN.
7	Five periods.

Summary

Solicitation: W56HZV-17-R-0095
Attachment 0007 - Pricing Matrix
Summary
Offeror
CLIN	Item	Proposed Price
0011 - 0015	A1 Inspection, Teardown, & MRP	$ -
0041 - 0045	A2 Inspection, Teardown, & MRP	$ -
0031	A1 FAT	$ -
0061	A2 FAT	$ -
0021 - 0025	A1 Engine Repair	$ 5,949,390
0051 - 0055	A2 Engine Repair	$ 65,570,906
	Total Proposed Price	$ 71,520,296

A1 I, T, R, & MRP

Fill out the yellow highlighted cells of this spreadsheet.

Do not manipulate any formulas within this tab.

Firm Fixed Price (FFP) CLINs for A1 Inspection, Tear-down, Reporting, and Mandatory Replacement Parts (MRP)

Offeror's Name:

CLIN 0011 - Year 1

CLIN 0012 - Year 2

CLIN 0013 - Year 3

CLIN 0014 - Year 4

CLIN 0015 - Year 5

Unit Price

Quantity

Total

Unit Price

Quantity

Total

Unit Price

Quantity

Total

Unit Price

Quantity

Total

Unit Price

Quantity

Total

18.0

$ - 0

18.0

$ - 0

18.0

$ - 0

17.0

$ - 0

17.0

$ - 0

Total Proposed Price - A1 Inspection, Teardown, & MRP

$ - 0

A2 I, T, R, & MRP

Fill out the yellow highlighted cells of this spreadsheet.

Do not manipulate any formulas within this tab.

Firm Fixed Price (FFP) CLINs for A2 Inspection, Tear-down, Reporting, and Mandatory Replacement Parts (MRP)

Offeror's Name:

CLIN 0041 - Year 1

CLIN 0042 - Year 2

CLIN 0043 - Year 3

CLIN 0044 - Year 4

CLIN 0045 - Year 5

Unit Price

Quantity

Total

Unit Price

Quantity

Total

Unit Price

Quantity

Total

Unit Price

Quantity

Total

Unit Price

Quantity

Total

90.0

$ - 0

Total Proposed Price - A2 Inspection, Teardown, & MRP

$ - 0

A1 FAT

Fill out the yellow highlighted cells of this spreadsheet.
Do not manipulate any formulas within this tab.
Firm Fixed Price (FFP) CLINs for A1 First Article Test (FAT)
Offeror's Name:	0
Item	Proposed Price

CLIN 0031

A1 FAT

A2 FAT

Fill out the yellow highlighted cells of this spreadsheet.
Do not manipulate any formulas within this tab.
Firm Fixed Price (FFP) CLINs for A2 First Article Test (FAT)
Offeror's Name:	0
Item	Proposed Price

CLIN 0061

A2 FAT

A1 Engine Repair

	Fill out the yellow highlighted cells of this spreadsheet.
	Do not manipulate any formulas within this tab.
	Direct Labor Hours and Direct Material Cost are Government-Provided and shall not be altered
	Cost Plus Fixed Fee (CPFF) CLINs for A1 Engine Repair
	Offeror's Name:	0
		CLIN 0021	CLIN 0022	CLIN 0023	CLIN 0024	CLIN 0025
	Cost Elements	Year 1
Unit Price	Year 2
Unit Price	Year 3
Unit Price	Year 4
Unit Price	Year 5

Unit Price

	Direct Labor Hours (Prime and Sub)	150.00	150.00	150.00	150.00	150.00
	Prime Direct Labor Cost
	Subcontract Labor
	Direct Material Cost	$ 65,000.00	$ 66,300.00	$ 67,626.00	$ 68,978.52	$ 70,358.09
	ODCs
	Indirect Costs
	FCCM
	Proposed Unit Cost	$ 65,000.00	$ 66,300.00	$ 67,626.00	$ 68,978.52	$ 70,358.09
	Fixed Fee
	Proposed Unit Price	$ 65,000.00	$ 66,300.00	$ 67,626.00	$ 68,978.52	$ 70,358.09
		Year 1
Extended Price	Year 2
Extended Price	Year 3
Extended Price	Year 4
Extended Price	Year 5
Extended Price	Total

Extended Price

Proposed Cost per Unit	$ 65,000.00	$ 66,300.00	$ 67,626.00	$ 68,978.52	$ 70,358.09
Proposed Fixed Fee per Unit	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Proposed Price per Unit	$ 65,000.00	$ 66,300.00	$ 67,626.00	$ 68,978.52	$ 70,358.09
Evaluated Quantity	18.0	18.0	18.0	17.0	17.0
Proposed Extended Price	$ 1,170,000	$ 1,193,400	$ 1,217,268	$ 1,172,635	$ 1,196,088	$5,949,390

A2 Engine Repair

	Fill out the yellow highlighted cells of this spreadsheet.
	Do not manipulate any formulas within this tab.
	Direct Labor Hours and Direct Material Cost are Government-Provided and shall not be altered
	Cost Plus Fixed Fee (CPFF) CLINs for A2 Engine Repair
	Offeror's Name:	0
		CLIN 0051	CLIN 0052	CLIN 0053	CLIN 0054	CLIN 0055
	Cost Elements	Year 1
Unit Price	Year 2
Unit Price	Year 3
Unit Price	Year 4
Unit Price	Year 5

Unit Price

	Direct Labor Hours (Prime and Sub)	150.00	150.00	150.00	150.00	150.00
	Prime Direct Labor Cost
	Subcontract Labor
	Direct Material Cost	$ 140,000.00	$ 142,800.00	$ 145,656.00	$ 148,569.12	$ 151,540.50
	ODCs
	Indirect Costs
	FCCM
	Proposed Unit Cost	$ 140,000.00	$ 142,800.00	$ 145,656.00	$ 148,569.12	$ 151,540.50
	Fixed Fee
	Proposed Unit Price	$ 140,000.00	$ 142,800.00	$ 145,656.00	$ 148,569.12	$ 151,540.50
		Year 1
Extended Price	Year 2
Extended Price	Year 3
Extended Price	Year 4
Extended Price	Year 5
Extended Price	Total

Extended Price

Proposed Cost per Unit	$ 140,000.00	$ 142,800.00	$ 145,656.00	$ 148,569.12	$ 151,540.50
Proposed Fixed Fee per Unit	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Proposed Price per Unit	$ 140,000.00	$ 142,800.00	$ 145,656.00	$ 148,569.12	$ 151,540.50
Evaluated Quantity	90.0	90.0	90.0	90.0	90.0
Proposed Extended Price	$ 12,600,000	$ 12,852,000	$ 13,109,040	$ 13,371,221	$ 13,638,645	$65,570,906

File details come from the government source that posted it. Updated Nov 14, 2017.