ATTACHMENT_0002_-_Price_Matrix.xlsx

XLSX spreadsheet 38 KB Posted Jun 19, 2017

Attached to: Mobile Shoe-Truck and Non-Conductive Protective Footwear
Solicitation number: W52P1J-17-T-3049
Issued by: Department of the Army Materiel Command Joint Munitions Command

About this file

From the source

Price Matrix must be completed and submitted in Excel format as part of the quote submission.

View the file

Other files

File	Type	Posted
ATTACHMENT_0004_-_Answers_to_Questions_Received_6-29-2017.pdf	PDF	Jul 6, 2017
Solicitation_Amendment_0001_7-6-2017.pdf	PDF	Jul 6, 2017
ATTACHMENT_0003_-_Statement_of_Work_20170706.pdf	PDF	Jul 6, 2017
Solicitation_W52P1J-17-T-3049.pdf	PDF	Jun 19, 2017
ATTACHMENT_0001_-_Statement_of_Work_20170614.docx	DOCX document	Jun 19, 2017

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.

Base Year Evaluation

ATTACHMENT 0002: PRICE MATRIX

	Legend
Offeror:	EH = Electrical Hazard
CAGE Code:	I/C = Impact and Compression

Base Year

Category

Category & Style Description

Required Rating

Style (Required or Optional)

Manufacturer Name

Style Number

Stocked Sizes (e.g. 7.5-10.5)

Manufacturer Warranty (Time in months)

Special Order Sizes (e.g. 15-18)

Base Year Estimated Quantity by Category

Base Year Unit Price

Base Year Weight % by Category

Base Year Extended Price

Men's Boot - Slip Resistant for Roofing

I/C

A1 - Required

$ 25.00

17.9%

$141.62

I/C

A2 - Required

$ 26.78

I/C

A3 - Optional

$ 32.10

I/C

A4 - Optional

$ 25.25

A TOTAL:

$ 27.28

Men's Boot - Lace-up 6"

I/C

B1 - Required

28.4%

ERROR:#DIV/0!

I/C

B2 - Required

I/C

B3 - Optional

I/C

B4 - Optional

B TOTAL:

ERROR:#DIV/0!

Men's Boot - Lace-up 8"

I/C

C1 - Required

1.2%

ERROR:#DIV/0!

I/C

C2 - Required

I/C

C3 - Optional

I/C

C4 - Optional

C TOTAL:

ERROR:#DIV/0!

Men's Boot - Wellington 10" or 11"

I/C

D1 - Required

40.1%

ERROR:#DIV/0!

I/C

D2 - Required

I/C

D3 - Optional

I/C

D4 - Optional

D TOTAL:

ERROR:#DIV/0!

Men's Boot - Wildland Fire Boot

I/C

E1 - Required

3.7%

ERROR:#DIV/0!

I/C

E2 - Required

I/C

E3 - Optional

I/C

E4 - Optional

E TOTAL:

ERROR:#DIV/0!

Men's Boot - Linesman 10"

F1 - Required

2.5%

ERROR:#DIV/0!

F2 - Required

F3 - Optional

F4 - Optional

F TOTAL:

ERROR:#DIV/0!

Women's Boot - Lace-Up 6"

I/C

G1 - Required

1.2%

ERROR:#DIV/0!

I/C

G2 - Required

I/C

G3 - Optional

I/C

G4 - Optional

G TOTAL:

ERROR:#DIV/0!

Men's Shoe - Low-Quarter Lace-Up

I/C

H1 - Required

3.7%

ERROR:#DIV/0!

I/C

H2 - Required

I/C

H3 - Optional

I/C

H4 - Optional

H TOTAL:

ERROR:#DIV/0!

Women's Shoe - Low-Quarter Lace-Up

I/C

I1 - Required

1.2%

ERROR:#DIV/0!

I/C

I2 - Required

I/C

I3 - Optional

I/C

I4 - Optional

I TOTAL:

ERROR:#DIV/0!

BASE YEAR TOTAL:

162

100%

ERROR:#DIV/0!

Option Yr. 1 Evaluation

ATTACHMENT 0002: PRICE MATRIX

	Legend
Offeror:	EH = Electrical Hazard
CAGE Code:	I/C = Impact and Compression

Option Year 1

Category

Category & Style Description

Required Rating

Style (Required or Optional)

Manufacturer Name

Style Number

Stocked Sizes (e.g. 7.5-10.5)

Manufacturer Warranty (Time in months)

Special Order Sizes (e.g. 15-18)

Option Year 1 Estimated Quantity by Category

Option Year 1 Unit Price

Option Year 1 Weight % by Category

Option Year 1 Extended Price

Men's Boot - Slip Resistant for Roofing

I/C

A1 - Required

17.9%

ERROR:#DIV/0!

I/C

A2 - Required

I/C

A3 - Optional

I/C

A4 - Optional

A TOTAL:

ERROR:#DIV/0!

Men's Boot - Lace-up 6"

I/C

B1 - Required

28.6%

ERROR:#DIV/0!

I/C

B2 - Required

I/C

B3 - Optional

I/C

B4 - Optional

B TOTAL:

ERROR:#DIV/0!

Men's Boot - Lace-up 8"

I/C

C1 - Required

1.2%

ERROR:#DIV/0!

I/C

C2 - Required

I/C

C3 - Optional

I/C

C4 - Optional

C TOTAL:

ERROR:#DIV/0!

Men's Boot - Wellington 10" or 11"

I/C

D1 - Required

40.5%

ERROR:#DIV/0!

I/C

D2 - Required

I/C

D3 - Optional

I/C

D4 - Optional

D TOTAL:

ERROR:#DIV/0!

Men's Boot - Wildland Fire Boot

I/C

E1 - Required

3.6%

ERROR:#DIV/0!

I/C

E2 - Required

I/C

E3 - Optional

I/C

E4 - Optional

E TOTAL:

ERROR:#DIV/0!

Men's Boot - Linesman 10"

F1 - Required

2.4%

ERROR:#DIV/0!

F2 - Required

F3 - Optional

F4 - Optional

F TOTAL:

ERROR:#DIV/0!

Women's Boot - Lace-Up 6"

I/C

G1 - Required

1.2%

ERROR:#DIV/0!

I/C

G2 - Required

I/C

G3 - Optional

I/C

G4 - Optional

G TOTAL:

ERROR:#DIV/0!

Men's Shoe - Low-Quarter Lace-Up

I/C

H1 - Required

3.6%

ERROR:#DIV/0!

I/C

H2 - Required

I/C

H3 - Optional

I/C

H4 - Optional

H TOTAL:

ERROR:#DIV/0!

Women's Shoe - Low-Quarter Lace-Up

I/C

I1 - Required

1.2%

ERROR:#DIV/0!

I/C

I2 - Required

I/C

I3 - Optional

I/C

I4 - Optional

I TOTAL:

ERROR:#DIV/0!

OPTION YEAR 1 TOTAL:

168

100%

ERROR:#DIV/0!

Option Yr. 2 Evaluation

ATTACHMENT 0002: PRICE MATRIX

	Legend
Offeror:	EH = Electrical Hazard
CAGE Code:	I/C = Impact and Compression

Option Year 2

Category

Category & Style Description

Required Rating

Style (Required or Optional)

Manufacturer Name

Style Number

Stocked Sizes (e.g. 7.5-10.5)

Manufacturer Warranty (Time in months)

Special Order Sizes (e.g. 15-18)

Option Year 2 Estimated Quantity by Category

Option Year 2 Unit Price

Option Year 2 Weight % by Category

Option Year 2 Extended Price

Men's Boot - Slip Resistant for Roofing

I/C

A1 - Required

17.7%

ERROR:#DIV/0!

I/C

A2 - Required

I/C

A3 - Optional

I/C

A4 - Optional

A TOTAL:

ERROR:#DIV/0!

Men's Boot - Lace-up 6"

I/C

B1 - Required

28.6%

ERROR:#DIV/0!

I/C

B2 - Required

I/C

B3 - Optional

I/C

B4 - Optional

B TOTAL:

ERROR:#DIV/0!

Men's Boot - Lace-up 8"

I/C

C1 - Required

1.1%

ERROR:#DIV/0!

I/C

C2 - Required

I/C

C3 - Optional

I/C

C4 - Optional

C TOTAL:

ERROR:#DIV/0!

Men's Boot - Wellington 10" or 11"

I/C

D1 - Required

41.1%

ERROR:#DIV/0!

I/C

D2 - Required

I/C

D3 - Optional

I/C

D4 - Optional

D TOTAL:

ERROR:#DIV/0!

Men's Boot - Wildland Fire Boot

I/C

E1 - Required

3.4%

ERROR:#DIV/0!

I/C

E2 - Required

I/C

E3 - Optional

I/C

E4 - Optional

E TOTAL:

ERROR:#DIV/0!

Men's Boot - Linesman 10"

F1 - Required

2.3%

ERROR:#DIV/0!

F2 - Required

F3 - Optional

F4 - Optional

F TOTAL:

ERROR:#DIV/0!

Women's Boot - Lace-Up 6"

I/C

G1 - Required

1.1%

ERROR:#DIV/0!

I/C

G2 - Required

I/C

G3 - Optional

I/C

G4 - Optional

G TOTAL:

ERROR:#DIV/0!

Men's Shoe - Low-Quarter Lace-Up

I/C

H1 - Required

3.4%

ERROR:#DIV/0!

I/C

H2 - Required

I/C

H3 - Optional

I/C

H4 - Optional

H TOTAL:

ERROR:#DIV/0!

Women's Shoe - Low-Quarter Lace-Up

I/C

I1 - Required

1.1%

ERROR:#DIV/0!

I/C

I2 - Required

I/C

I3 - Optional

I/C

I4 - Optional

I TOTAL:

ERROR:#DIV/0!

OPTION YEAR 2 TOTAL:

175

100%

ERROR:#DIV/0!

Option Yr. 3 Evaluation

ATTACHMENT 0002: PRICE MATRIX

	Legend
Offeror:	EH = Electrical Hazard
CAGE Code:	I/C = Impact and Compression

Option Year 3

Category

Category & Style Description

Required Rating

Style (Required or Optional)

Manufacturer Name

Style Number

Stocked Sizes (e.g. 7.5-10.5)

Manufacturer Warranty (Time in months)

Special Order Sizes (e.g. 15-18)

Option Year 3 Estimated Quantity by Category

Option Year 3 Unit Price

Option Year 3 Weight % by Category

Option Year 3 Extended Price

Men's Boot - Slip Resistant for Roofing

I/C

A1 - Required

$ 135.00

17.2%

$743.04

I/C

A2 - Required

$ 135.00

I/C

A3 - Optional

$ 135.00

I/C

A4 - Optional

$ 135.00

A TOTAL:

$ 135.00

Men's Boot - Lace-up 6"

I/C

B1 - Required

28.0%

ERROR:#DIV/0!

I/C

B2 - Required

I/C

B3 - Optional

I/C

B4 - Optional

B TOTAL:

ERROR:#DIV/0!

Men's Boot - Lace-up 8"

I/C

C1 - Required

1.6%

ERROR:#DIV/0!

I/C

C2 - Required

I/C

C3 - Optional

I/C

C4 - Optional

C TOTAL:

ERROR:#DIV/0!

Men's Boot - Wellington 10" or 11"

I/C

D1 - Required

40.3%

ERROR:#DIV/0!

I/C

D2 - Required

I/C

D3 - Optional

I/C

D4 - Optional

D TOTAL:

ERROR:#DIV/0!

Men's Boot - Wildland Fire Boot

I/C

E1 - Required

3.2%

ERROR:#DIV/0!

I/C

E2 - Required

I/C

E3 - Optional

I/C

E4 - Optional

E TOTAL:

ERROR:#DIV/0!

Men's Boot - Linesman 10"

F1 - Required

2.7%

ERROR:#DIV/0!

F2 - Required

F3 - Optional

F4 - Optional

F TOTAL:

ERROR:#DIV/0!

Women's Boot - Lace-Up 6"

I/C

G1 - Required

1.6%

ERROR:#DIV/0!

I/C

G2 - Required

I/C

G3 - Optional

I/C

G4 - Optional

G TOTAL:

ERROR:#DIV/0!

Men's Shoe - Low-Quarter Lace-Up

I/C

H1 - Required

3.8%

ERROR:#DIV/0!

I/C

H2 - Required

I/C

H3 - Optional

I/C

H4 - Optional

H TOTAL:

ERROR:#DIV/0!

Women's Shoe - Low-Quarter Lace-Up

I/C

I1 - Required

1.6%

ERROR:#DIV/0!

I/C

I2 - Required

I/C

I3 - Optional

I/C

I4 - Optional

I TOTAL:

ERROR:#DIV/0!

OPTION YEAR 3 TOTAL:

186

100%

ERROR:#DIV/0!

Option Yr. 4 Evaluation

ATTACHMENT 0002: PRICE MATRIX

	Legend
Offeror:	EH = Electrical Hazard
CAGE Code:	I/C = Impact and Compression

Option Year 4

Category

Category & Style Description

Required Rating

Style (Required or Optional)

Manufacturer Name

Style Number

Stocked Sizes (e.g. 7.5-10.5)

Manufacturer Warranty (Time in months)

Special Order Sizes (e.g. 15-18)

Option Year 4 Estimated Quantity by Category

Option Year 4 Unit Price

Option Year 4 Weight % by Category

Option Year 4 Extended Price

Men's Boot - Slip Resistant for Roofing

I/C

A1 - Required

17.2%

ERROR:#DIV/0!

I/C

A2 - Required

I/C

A3 - Optional

I/C

A4 - Optional

A TOTAL:

ERROR:#DIV/0!

Men's Boot - Lace-up 6"

I/C

B1 - Required

28.1%

ERROR:#DIV/0!

I/C

B2 - Required

I/C

B3 - Optional

I/C

B4 - Optional

B TOTAL:

ERROR:#DIV/0!

Men's Boot - Lace-up 8"

I/C

C1 - Required

1.6%

ERROR:#DIV/0!

I/C

C2 - Required

I/C

C3 - Optional

I/C

C4 - Optional

C TOTAL:

ERROR:#DIV/0!

Men's Boot - Wellington 10" or 11"

I/C

D1 - Required

40.6%

ERROR:#DIV/0!

I/C

D2 - Required

I/C

D3 - Optional

I/C

D4 - Optional

D TOTAL:

ERROR:#DIV/0!

Men's Boot - Wildland Fire Boot

I/C

E1 - Required

3.1%

ERROR:#DIV/0!

I/C

E2 - Required

I/C

E3 - Optional

I/C

E4 - Optional

E TOTAL:

ERROR:#DIV/0!

Men's Boot - Linesman 10"

F1 - Required

2.6%

ERROR:#DIV/0!

F2 - Required

F3 - Optional

F4 - Optional

F TOTAL:

ERROR:#DIV/0!

Women's Boot - Lace-Up 6"

I/C

G1 - Required

1.6%

ERROR:#DIV/0!

I/C

G2 - Required

I/C

G3 - Optional

I/C

G4 - Optional

G TOTAL:

ERROR:#DIV/0!

Men's Shoe - Low-Quarter Lace-Up

I/C

H1 - Required

3.6%

ERROR:#DIV/0!

I/C

H2 - Required

I/C

H3 - Optional

I/C

H4 - Optional

H TOTAL:

ERROR:#DIV/0!

Women's Shoe - Low-Quarter Lace-Up

I/C

I1 - Required

1.6%

ERROR:#DIV/0!

I/C

I2 - Required

I/C

I3 - Optional

I/C

I4 - Optional

I TOTAL:

ERROR:#DIV/0!

OPTION YEAR 4 TOTAL:

192

100%

ERROR:#DIV/0!

GRAND TOTAL

SOLICITATION W52P1J-17-R-NCST: GRAND TOTAL PROPOSED PRICE

Year	Total Price
Base Year	ERROR:#DIV/0!
Option Year 1	ERROR:#DIV/0!
Option Year 2	ERROR:#DIV/0!
Option Year 3	ERROR:#DIV/0!
Option Year 4	ERROR:#DIV/0!

GRAND TOTAL ERROR:#DIV/0!

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