Attach 2 - Pricing Discount Coefficient Table.xlsx

XLSX spreadsheet 30 KB Posted Mar 23, 2021

Attached to: Contractor Operated Civil Engineer Supply Store (COCESS)
Solicitation number: FA469021R0001
Issued by: Department of the Air Force Air Combat Command

View the file

Other files

File	Type	Posted
Attach 12 - QA.pdf	PDF	Apr 13, 2021
Solicitation Amendment FA469021R00010001 SF 30.pdf	PDF	Apr 13, 2021
Attach 3 - SPI List (Updated 8 April 2021).xlsx	XLSX spreadsheet	Apr 13, 2021
Exhibit 1 - Historical High-Use and Critical Items.xls	XLS spreadsheet	Mar 23, 2021
Attach 11 - PPIS.doc	DOC document	Mar 23, 2021
Attach 10 - FFP Coefficient Application.xlsx	XLSX spreadsheet	Mar 23, 2021
Solicitation - FA469021R0001.pdf	PDF	Mar 23, 2021
Attach 1 - COCESS_Statement of Work_26JAN21.pdf	PDF	Mar 23, 2021
Attach 9 - Past Performance Questionnaire.docx	DOCX document	Mar 23, 2021
Attach 7 - Teaming Partner Consent.pdf	PDF	Mar 23, 2021
Attach 4 - CDRLS.pdf	PDF	Mar 23, 2021
Attach 3 - SPI List.xlsx	XLSX spreadsheet	Mar 23, 2021
Attach 5 - Addendum to 52.212-1 Instructions to Offerors.pdf	PDF	Mar 23, 2021
Attach 6 - Addendum to 52.212-2 Evaluation Commerical Items.pdf	PDF	Mar 23, 2021
Attach 8 - Certificate of Insurance.pdf	PDF	Mar 23, 2021

Show all 15

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

ATTACHMENT 2, PRICING DISCOUNT COEFFICIENT TABLE

Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (Based on FY19 Historicals)	DISCOUNT PERCENTAGE	COEFFICIENT FACTOR
Primary	Grainger	Electrical Systems	21.00		100%
Alternate	Graybar	Electrical Systems	21.00		100%

Primary	Grainger	Power Production	4.00	100%
Alternate	NAPA	Power Production	4.00	100%

Primary	Grainger	HVAC/Controls	37.00	100%
Alternate	Supply House	HVAC/Controls	37.00	100%

Primary	Grainger	Structures	11.00	100%
Alternate	Lowes	Structures	11.00	100%

Primary	Grainger	Utilities	11.00	100%
Alternate	Ferguson	Utilities	11.00	100%

Primary	Grainger	Horizontal Rpr	9.00	100%
Alternate	Napa	Horizontal Rpr	9.00	100%

Primary	Grainger	Tools/Safety	7.00	100%
Alternate	Tool Source	Tools/Safety	7.00	100%
	Gov choosen vendors for each database
	Contractor Proposes Yellow Blocks
	Offeror must complete a Pricing Discount Coefficient Table for the base and all option years.

Option Year 1

ATTACHMENT 2, PRICING DISCOUNT COEFFICIENT TABLE

Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (Based on FY19 Historicals)	DISCOUNT PERCENTAGE	COEFFICIENT FACTOR
Primary	Grainger	Electrical Systems	21.00		100%
Alternate	Graybar	Electrical Systems	21.00		100%

Primary	Grainger	Power Production	4.00	100%
Alternate	NAPA	Power Production	4.00	100%

Primary	Grainger	HVAC/Controls	37.00	100%
Alternate	Supply House	HVAC/Controls	37.00	100%

Primary	Grainger	Structures	11.00	100%
Alternate	Lowes	Structures	11.00	100%

Primary	Grainger	Utilities	11.00	100%
Alternate	Ferguson	Utilities	11.00	100%

Primary	Grainger	Horizontal Rpr	9.00	100%
Alternate	Napa	Horizontal Rpr	9.00	100%

Primary	Grainger	Tools/Safety	7.00	100%
Alternate	Tool Source	Tools/Safety	7.00	100%
	Gov choosen vendors for each database
	Contractor Proposes Yellow Blocks
	Offeror must complete a Pricing Discount Coefficient Table for the base and all option years.

Option Year 2

ATTACHMENT 2, PRICING DISCOUNT COEFFICIENT TABLE

Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (Based on FY19 Historicals)	DISCOUNT PERCENTAGE	COEFFICIENT FACTOR
Primary	Grainger	Electrical Systems	21.00		100%
Alternate	Graybar	Electrical Systems	21.00		100%

Primary	Grainger	Power Production	4.00	100%
Alternate	NAPA	Power Production	4.00	100%

Primary	Grainger	HVAC/Controls	37.00	100%
Alternate	Supply House	HVAC/Controls	37.00	100%

Primary	Grainger	Structures	11.00	100%
Alternate	Lowes	Structures	11.00	100%

Primary	Grainger	Utilities	11.00	100%
Alternate	Ferguson	Utilities	11.00	100%

Primary	Grainger	Horizontal Rpr	9.00	100%
Alternate	Napa	Horizontal Rpr	9.00	100%

Primary	Grainger	Tools/Safety	7.00	100%
Alternate	Tool Source	Tools/Safety	7.00	100%
	Gov choosen vendors for each database
	Contractor Proposes Yellow Blocks
	Offeror must complete a Pricing Discount Coefficient Table for the base and all option years.

Option Year 3

ATTACHMENT 2, PRICING DISCOUNT COEFFICIENT TABLE

Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (Based on FY19 Historicals)	DISCOUNT PERCENTAGE	COEFFICIENT FACTOR
Primary	Grainger	Electrical Systems	21.00		100%
Alternate	Graybar	Electrical Systems	21.00		100%

Primary	Grainger	Power Production	4.00	100%
Alternate	NAPA	Power Production	4.00	100%

Primary	Grainger	HVAC/Controls	37.00	100%
Alternate	Supply House	HVAC/Controls	37.00	100%

Primary	Grainger	Structures	11.00	100%
Alternate	Lowes	Structures	11.00	100%

Primary	Grainger	Utilities	11.00	100%
Alternate	Ferguson	Utilities	11.00	100%

Primary	Grainger	Horizontal Rpr	9.00	100%
Alternate	Napa	Horizontal Rpr	9.00	100%

Primary	Grainger	Tools/Safety	7.00	100%
Alternate	Tool Source	Tools/Safety	7.00	100%
	Gov choosen vendors for each database
	Contractor Proposes Yellow Blocks
	Offeror must complete a Pricing Discount Coefficient Table for the base and all option years.

Option Year 4

ATTACHMENT 2, PRICING DISCOUNT COEFFICIENT TABLE

Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (Based on FY19 Historicals)	DISCOUNT PERCENTAGE	COEFFICIENT FACTOR
Primary	Grainger	Electrical Systems	21.00		100%
Alternate	Graybar	Electrical Systems	21.00		100%

Primary	Grainger	Power Production	4.00	100%
Alternate	NAPA	Power Production	4.00	100%

Primary	Grainger	HVAC/Controls	37.00	100%
Alternate	Supply House	HVAC/Controls	37.00	100%

Primary	Grainger	Structures	11.00	100%
Alternate	Lowes	Structures	11.00	100%

Primary	Grainger	Utilities	11.00	100%
Alternate	Ferguson	Utilities	11.00	100%

Primary	Grainger	Horizontal Rpr	9.00	100%
Alternate	Napa	Horizontal Rpr	9.00	100%

Primary	Grainger	Tools/Safety	7.00	100%
Alternate	Tool Source	Tools/Safety	7.00	100%
	Gov choosen vendors for each database
	Contractor Proposes Yellow Blocks
	Offeror must complete a Pricing Discount Coefficient Table for the base and all option years.

File details come from the government source that posted it. Updated Mar 23, 2021.