Attach 2 - Pricing Discount Coefficient Table.xlsx

XLSX spreadsheet 30 KB Posted Mar 1, 2021

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

View the file

Other files for this federal contract opportunity

Other files attached to Contractor Operated Civil Engineer Supply Store (COCESS), newest first.
File	Type	Posted
Exhibit 1 - Historical High-Use and Critical Items.xls	XLS spreadsheet	Mar 1, 2021
Attach 3 - SPI List.xlsx	XLSX spreadsheet	Mar 1, 2021
Attach 8 - Certificate of Insurance.pdf	PDF	Mar 1, 2021
Solicitation - FA469021R0001 draft.pdf	PDF	Mar 1, 2021
Attach 4 - CDRLS.pdf	PDF	Mar 1, 2021
Attach 5 - Addendum to 52.212-1 Instructions to Offerors.pdf	PDF	Mar 1, 2021
Attach 6 - Addendum to 52.212-2 Evaluation Commerical Items.pdf	PDF	Mar 1, 2021
Attach 7 - Teaming Partner Consent.pdf	PDF	Mar 1, 2021
Attach 10 - FFP Coefficient Application.xlsx	XLSX spreadsheet	Mar 1, 2021
Attach 1 - COCESS_Statement of Work_26JAN21.pdf	PDF	Mar 1, 2021
Attach 9 - Past Performance Questionnaire.docx	DOCX document	Mar 1, 2021

Show all 11

On GovTribe

Work with this file on GovTribe

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 1, 2021.