Attachment_0013_-_Pricing_Workbook.xlsx

XLSX spreadsheet 36 KB Posted Jan 24, 2019

Attached to: Explosive Hazard Pre-detonation Roller System
Solicitation number: W56HZV-16-R-0007
Issued by: Department of the Army Materiel Command Contracting Command Detroit Arsenal

About this file

Written by GovTribe AI · Dec 30, 2023

This document contains pricing instructions and templates for an anticipated federal contract solicitation for an Explosive Hazard Pre-detonation Roller System. The Army Contracting Command - Warren intends to issue a competitive set-aside solicitation on or after January 29, 2019 for the production of a minimum of 40 units and a maximum of 370 units of the EHP Roller System over five ordering periods. Offerors must complete the pricing templates which require proposed unit prices for various quantity ranges in the first ordering period as well as escalation rates for future periods. Templates are also provided for pricing of ancillary items including first article test assets, system support packages, advanced sensing loader kits, precision location locator kits, and buried item identifier kits.

From the source

Att0013

View the file

Other files

File	Type	Posted
Attachment_0018_-_EHP_Roller_Question_and_Answer_Log.pdf	PDF	Apr 30, 2019
W56HZV16R0007-0004.pdf	PDF	Apr 30, 2019
EHP_Roller_Question_and_Answer_23APR2019.pdf	PDF	Apr 26, 2019
W56HZV16R0007-0002.pdf	PDF	Apr 22, 2019
W56HZV16R0007-0001.pdf	PDF	Apr 17, 2019
EHP_Roller_Question_and_Answer.pdf	PDF	Apr 17, 2019
Attachment_0014_-_Proposal_Checklist.xlsx	XLSX spreadsheet	Mar 20, 2019
Attachment_0011_-_Request_for_Use_of_Prohibited_Materials_Waiver.doc	DOC document	Mar 20, 2019
Attachment_0015_-_EHP_Roller_Dynamic_Road_Test.pdf	PDF	Mar 20, 2019
W56HZV16R0007.pdf	PDF	Mar 20, 2019
Attachment_0012_-_Past_Performance_Questionnaire.doc	DOC document	Mar 20, 2019
Attachment_0013_-_EHP_Roller_Production_Pricing_Workbook.xlsx	XLSX spreadsheet	Mar 20, 2019
Attachment_0017_-_EHP_Roller_NDT_Inspection_List.pdf	PDF	Mar 20, 2019
Attachment_0016_-_Government_Furnished_Property.xlsx	XLSX spreadsheet	Mar 20, 2019
Attachment_0001_-_Non_Disclosure_Agreement.docx	DOCX document	Mar 20, 2019
Attachment_0001_-_Non_Disclosure_Agreement.docx	DOCX document	Jan 24, 2019
Attachment_0011_-_Request_for_Use_of_Prohibited_Materials_Waiver.doc	DOC document	Jan 24, 2019
Attachment_0012_-_Past_Performance_Questionnaire.doc	DOC document	Jan 24, 2019
Draft_W56HZV16R0007_24Jan2019.pdf	PDF	Jan 24, 2019

Show all 19

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.

Instruction To Offeror

Solicitation W56HZV-16-R-0007

Attachment 0013 - Pricing Workbook

Instructions

INSTRUCTION TO OFFEROR

Cells that require inputs are highlighted in light-blue

All cells highlighted in light-blue must be completed

Do not adjust formulas or otherwise manipulate any of the non light-blue cells

Do not alter or make changes to this attachment except for inputting values in those cells highlighted in light-blue

The Attachment will calculate the Total Evaluated Price IAW Section M of the Solicitation

*NOTE*

First Article Test (FAT) - System Support Package (SSP)

The FAT price and SSP price shall be input in worksheet "CLIN 0011-0015 PRODUCTION" cells D14 and D18 respectively. The offeror shall input the unit price into the applicable cell and multiply the unit price by the number of required units (5). The offeror shall leave the formula in the applicable cells that shows the unit price multiplied by five.

Worksheet "CLIN 0011-0015 PRODUCTION"

For worksheet "CLIN 0011-0015 PRODUCTION", offerors shall populate all light-blue cells on worksheet "CLIN 0011 Production Breakout" which will be the offerors proposed price for Ordering Period 1 Quantity Range 1 - 50. For the remaining quantity ranges in Ordering Period 1, offerors shall input a discount percentage in Cells E14, E15, and E16. The attachment will multiply the discount percentage by the unit price in the previous quantity range to calculate the proposed unit price for that range. If an offeror is proposing the same unit price that is proposed in the previous quantity range, enter a discount percentage of 0.00%.

Worksheets "CLIN 0021-0025 ASL KITS", "CLIN 0031-0035 PLL KITS", "CLIN 0041-0045 BII KITS":

Within these worksheets, for Ordering Period 1, offerors shall input the proposed unit price for the lowest quantity range within Cell G13. For the remaining quantity ranges in Ordering Period 1, offerors shall input a discount percentage in Cells E14, E15, and E16. The attachment will multiply the discount percentage by the unit price in the previous quantity range to calculate the proposed unit price for that range. If an offeror is proposing the same unit price that is proposed in the previous quantity range, enter a discount percentage of 0.00%.

Worksheets "CLIN 0011-0015 PRODUCTION", "CLIN 0021-0025 ASL KITS", "CLIN 0031-0035 PLL KITS", "CLIN 0041-0045 BII KITS":

Within these worksheets, offerors shall input proposed escalation rates for Ordering Period 2 - 5 in the applicable cells highlighted in light-blue. The attachment will multiply the previous ordering period unit price for the same quantity range by the escalation percentage to claculate the proposed unit price for that range. If an offeror is proposing the same unit price that is proposed in the previous ordering period, enter an escalation percentage of 0.00%. If an offerors projected production costs are lower in future ordering periods, the offeror may enter negative escalation rates.

Summary

Solicitation W56HZV-16-R-0007

Attachment 0013 - Pricing Matrix

Summary

Offeror: Cage:

Price Summary

	Price
First Article Test (FATS)	$ - 0

Production $ - 0

SSP Kits $ - 0

ASL Kits $ - 0

PLL Kits $ - 0

BII Kits $ - 0

Total Evaluated Price $ - 0

CLIN 0011 Production Breakout

Solicitation W56HZV-16-R-0007

Attachment 0013 - Pricing Matrix

CLIN0011 Production Breakout

	Labor	Estimated Hours
Per Unit	Total Labor Cost

Per Unit 0 $ - 0

Material Total Material Cost Per Unit $ - 0

Other Direct Costs Total ODCs Per Unit $ - 0

Indirect Costs Total Indirect Cost Per Unit (e.g. G&A, M&H, FCCOM) $ - 0

Profit Profit Rate Profit Dollars Per Unit 0% $ - 0

Total Unit Cost for Quantity Range 1 - 50 $ - 0

CLIN 0011-0015 PRODUCTION

Solicitation W56HZV-16-R-0007

Attachment 0013 - Pricing Matrix

CLIN 0011-0015 PRODUCTION

CLIN 0011-0015: EHP ROLLER

Offeror: 0 Cage: 0

			Ordering Period 1			Ordering Period 2			Ordering Period 3			Ordering Period 4			Ordering Period 5
Quantity Ranges			Discount Schedule	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price
1	-	50		10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	70%	$ - 0	0.00%	70%	$ - 0
51	-	150	0.00%	50%	$ - 0	0.00%	40%	$ - 0	0.00%	40%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
151	-	300	0.00%	30%	$ - 0	0.00%	40%	$ - 0	0.00%	40%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
300	-	370	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
			.
WEIGHTED AVERAGE UNIT PRICE (WAUP)					$0.00			$0.00			$0.00			$0.00			$0.00

Evaluated Order Period Quantity	110	110	110	20	20
Evaluated Order Period Value	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

EVALUATED CLIN PRICE $ - 0

CLIN 0021-0025 ASL KITS

Solicitation W56HZV-16-R-0007

Attachment 0013 - Pricing Matrix

CLIN 0021-0025 ASL KITS

Offeror: 0 Cage: 0

			Ordering Period 1			Ordering Period 2			Ordering Period 3			Ordering Period 4			Ordering Period 5
Quantity Ranges			Discount Schedule	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price
1	-	10		10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	70%	$ - 0	0.00%	70%	$ - 0
11	-	20	0.00%	50%	$ - 0	0.00%	40%	$ - 0	0.00%	40%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
21	-	50	0.00%	30%	$ - 0	0.00%	40%	$ - 0	0.00%	40%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
51	-	78	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
			.
WEIGHTED AVERAGE UNIT PRICE (WAUP)					$0.00			$0.00			$0.00			$0.00			$0.00

Evaluated Order Period Quantity	22	22	22	6	6
Evaluated Order Period Value	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

EVALUATED CLIN PRICE $ - 0

CLIN 0031-0035 PLL KITS

Solicitation W56HZV-16-R-0007

Attachment 0013 - Pricing Matrix

CLIN 0031-0035 PLL KITS

Offeror: 0 Cage: 0

			Ordering Period 1			Ordering Period 2			Ordering Period 3			Ordering Period 4			Ordering Period 5
Quantity Ranges			Discount Schedule	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price
1	-	15		10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	70%	$ - 0	0.00%	70%	$ - 0
16	-	30	0.00%	50%	$ - 0	0.00%	40%	$ - 0	0.00%	40%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
31	-	60	0.00%	30%	$ - 0	0.00%	40%	$ - 0	0.00%	40%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
61	-	121	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
			.
WEIGHTED AVERAGE UNIT PRICE (WAUP)					$0.00			$0.00			$0.00			$0.00			$0.00

Evaluated Order Period Quantity	33	33	33	11	11
Evaluated Order Period Value	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

EVALUATED CLIN PRICE $ - 0

CLIN 0041-0045 BII KITS

Solicitation W56HZV-16-R-0007

Attachment 0013 - Pricing Matrix

CLIN 0041-0045 BII KITS

Offeror: 0 Cage: 0

			Ordering Period 1			Ordering Period 2			Ordering Period 3			Ordering Period 4			Ordering Period 5
Quantity Ranges			Discount Schedule	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price	Escalation	Weight	Unit Price
1	-	50		10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	70%	$ - 0	0.00%	70%	$ - 0
51	-	150	0.00%	50%	$ - 0	0.00%	40%	$ - 0	0.00%	40%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
151	-	300	0.00%	30%	$ - 0	0.00%	40%	$ - 0	0.00%	40%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0
300	-	370	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0	0.00%	10%	$ - 0

WEIGHTED AVERAGE UNIT PRICE (WAUP) $0.00 $0.00 $0.00 $0.00 $0.00

Evaluated Order Period Quantity	110	110	110	20	20
Evaluated Order Period Value	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

EVALUATED CLIN PRICE $ - 0

File details come from the government source that posted it. Updated Dec 30, 2023.