Attachment 0013 - PRICING MATRIX WORKBOOK.xlsx

XLSX spreadsheet 40 KB Posted May 31, 2023

Attached to: M109A7 Self-Propelled Howitzer (SPH) and M992A3 Carrier, Ammunition, Tracked (CAT) Threshold 2 Armor Kits
Solicitation number: W56HZV-20-R-0164
Issued by: Department of the Army Materiel Command TACOM Life Cycle Management Command

View the file

Other files

File	Type	Posted
W56HZV20R0164-0005.pdf	PDF	Aug 4, 2023
Attachment 0012 - PAST PERFORMANCE QUESTIONNAIRE 27JULY2023.docx	DOCX document	Jul 27, 2023
W56HZV20R0164-0004.pdf	PDF	Jul 27, 2023
W56HZV20R0164-0003.pdf	PDF	Jul 20, 2023
W56HZV20R0164-0002.pdf	PDF	Jul 7, 2023
Attachment 0012 - PAST PERFORMANCE QUESTIONNAIRE.docx	DOCX document	Jul 7, 2023
Attachment 0013 - Pricing Matrix Workbook.xlsx	XLSX spreadsheet	Jun 2, 2023
W56HZV20R0164-0001.pdf	PDF	Jun 2, 2023
Attachment 0015 - USE OF EXISTING GOVERNMENT-FURNISHED PROPERTY.xlsx	XLSX spreadsheet	May 31, 2023
Attachment 0012 - PAST PERFORMANCE QUESTIONNAIRE.docx	DOCX document	May 31, 2023
Attachment 0017 - SELF-PROPELLED HOWITZER (SPH) FAMILY OF VEHICLES (FoV) SECURITY CLASSIFICATION GUIDE (SCG)_17APR2023.pdf	PDF	May 31, 2023
Attachment 0014 - ATTACHMENT A -- CUI 2021 - T2.pdf	PDF	May 31, 2023
Attachment 0002 - RESOURCE DISTRIBUTION TABLE (RDT).xlsx	XLSX spreadsheet	May 31, 2023
Attachment 0001 - CONTRACT COST AND DATA REPORTING (CSDR) PLAN.pdf	PDF	May 31, 2023
W56HZV20R0164.pdf	PDF	May 31, 2023
Attachment 0016 - SPHS OPSEC Plan Aug2020_FINAL signed.pdf	PDF	May 31, 2023

Show all 16

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

Solicitation W56HZV-20-R-0164

Attachment 0013 - Pricing Matrix Workbook

Instructions

1) Cells that require inputs are highlighted in yellow

2) All cells that are highlighted in yellow must be completed

3) Do not adjust formulas or otherwise manipulate any of the other (non-yellow highlighted) cells.

4) The required inputs are used to auto calculate the Total Proposed Price on the "Summary" Worksheet

5) Do not make any changes or modifications to this attachment except for those cells highlighted in yellow

6) Do not add Worksheets to this Attachment

7) If all cells highlighted in yellow are not completed, the proposal may be rejected IAW Section M - Rejection of Offers.

Summary

Solicitation W56HZV-20-R-0164

Attachment 0013 - Pricing Matrix Workbook

Summary

Offeror:

		Order Year
Item	CLIN	OY1	OY2	OY3	OY4	OY5	Total
M109A7 SPH T2 ARMOR KIT	001X	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
M992A3 CAT T2 ARMOR KIT	002X	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
UNDERBELLY T2 ARMOR KIT	003X	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
M109A7 SPH UNDERSPONSON T2 ARMOR KIT	004X	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
M992A3 CAT T2 UNDERSPONSON KIT	005X	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Total Proposed Price		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

CLIN 001X - M109A7 SPH T2

Solicitation W56HZV-20-R-0164

Attachment 0013 - Pricing Matrix Workbook

CLIN 001X - M109A7 SPH T2 ARMOR KIT, GREEN

CLIN:	0011	CLIN:	0012	CLIN:	0013	CLIN:	0014	CLIN:	0015
Description:	M109A7 SPH T2 ARMOR KIT	Description:	M109A7 SPH T2 ARMOR KIT	Description:	M109A7 SPH T2 ARMOR KIT	Description:	M109A7 SPH T2 ARMOR KIT	Description:	M109A7 SPH T2 ARMOR KIT
Period:	Order Year 1	Period:	Order Year 2	Period:	Order Year 3	Period:	Order Year 4	Period:	Order Year 5

		Quantity
Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting
		1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%
		21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%
		54 - 270		50%	54 - 270		50%	54 - 270		50%	54 - 270		50%	54 - 270		50%
			Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00
			Quantity	54		Quantity	54		Quantity	54		Quantity	54		Quantity	54
			Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00

CLIN 002X - M992A3 CAT T2

Solicitation W56HZV-20-R-0164

Attachment 0013 - Pricing Matrix Workbook

CLIN 002X - M992A3 CAT T2 ARMOR KIT, GREEN

CLIN:	0021	CLIN:	0022	CLIN:	0023	CLIN:	0024	CLIN:	0025
Description:	M992A3 CAT T2 ARMOR KIT	Description:	M992A3 CAT T2 ARMOR KIT	Description:	M992A3 CAT T2 ARMOR KIT	Description:	M992A3 CAT T2 ARMOR KIT	Description:	M992A3 CAT T2 ARMOR KIT
Period:	Order Year 1	Period:	Order Year 2	Period:	Order Year 3	Period:	Order Year 4	Period:	Order Year 5

		Quantity
Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting
		1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%
		21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%
		54 - 270		50%	54 - 270		50%	54 - 270		50%	54 - 270		50%	54 - 270		50%
			Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00
			Quantity	54		Quantity	54		Quantity	54		Quantity	54		Quantity	54
			Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00

CLIN 003X - UNDERBELLY T2

Solicitation W56HZV-20-R-0164

Attachment 0013 - Pricing Matrix Workbook

CLIN 003X - UNDERBELLY T2 ARMOR KIT, GREEN

CLIN:	0031	CLIN:	0032	CLIN:	0033	CLIN:	0034	CLIN:	0035
Description:	UNDERBELLY T2 ARMOR KIT	Description:	UNDERBELLY T2 ARMOR KIT	Description:	UNDERBELLY T2 ARMOR KIT	Description:	UNDERBELLY T2 ARMOR KIT	Description:	UNDERBELLY T2 ARMOR KIT
Period:	Order Year 1	Period:	Order Year 2	Period:	Order Year 3	Period:	Order Year 4	Period:	Order Year 5

		Quantity
Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting
		1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%
		21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%
		54 - 216		50%	54 - 216		50%	54 - 216		50%	54 - 216		50%	54 - 216		50%
			Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00
			Quantity	108		Quantity	108		Quantity	108		Quantity	108		Quantity	108
			Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00

CLIN 004X - M109A7 SPH UNDERSPO

Solicitation W56HZV-20-R-0164

Attachment 0013 - Pricing Matrix Workbook

CLIN 004X - M109A7 SPH UNDERSPONSON ARMOR KIT, TAN

CLIN:	0041	CLIN:	0042	CLIN:	0043	CLIN:	0044	CLIN:	0045
Description:	M109A7 SPH UNDERSPONSON ARMOR KIT	Description:	M109A7 SPH UNDERSPONSON ARMOR KIT	Description:	M109A7 SPH UNDERSPONSON ARMOR KIT	Description:	M109A7 SPH UNDERSPONSON ARMOR KIT	Description:	M109A7 SPH UNDERSPONSON ARMOR KIT
Period:	Order Year 1	Period:	Order Year 2	Period:	Order Year 3	Period:	Order Year 4	Period:	Order Year 5

		Quantity
Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting
		1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%
		21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%
		54 - 100		50%	54 - 100		50%	54 - 100		50%	54 - 100		50%	54 - 100		50%
			Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00
			Quantity	75		Quantity	10		Quantity	10		Quantity	10		Quantity	10
			Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00

CLIN 005X - M992A3 CAT T2 UNDER

Solicitation W56HZV-20-R-0164

Attachment 0013 - Pricing Matrix Workbook

CLIN 005X - M992A3 CAT T2 UNDERSPONSON KIT, TAN

	CLIN:	0051		CLIN:	0052	CLIN:	0053	CLIN:	0054	CLIN:	0055
	Description:	M992A3 CAT T2
UNDERSPONSON KIT		Description:	M992A3 CAT T2
UNDERSPONSON KIT		Description:	M992A3 CAT T2
UNDERSPONSON KIT		Description:	M992A3 CAT T2
UNDERSPONSON KIT		Description:	M992A3 CAT T2

UNDERSPONSON KIT

Period: Order Year 1 Period: Order Year 2 Period: Order Year 3 Period: Order Year 4 Period: Order Year 5

		Quantity
Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting		Quantity Range	Proposed
Unit Price	Weighting
		1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%	1 - 20		25%
		21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%	21 - 53		25%
		54 - 100		50%	54 - 100		50%	54 - 100		50%	54 - 100		50%	54 - 100		50%
			Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00		Weighted Avg Unit Price	$0.00
			Quantity	75		Quantity	10		Quantity	10		Quantity	10		Quantity	10
			Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00		Proposed Price	$0.00

File details come from the government source that posted it. Updated May 31, 2023.