Attach 10 - FFP Coefficient Application.xlsx

XLSX spreadsheet 28 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
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 3 - SPI List.xlsx	XLSX spreadsheet	Mar 1, 2021
Attach 8 - Certificate of Insurance.pdf	PDF	Mar 1, 2021
Attach 1 - COCESS_Statement of Work_26JAN21.pdf	PDF	Mar 1, 2021
Attach 2 - Pricing Discount Coefficient Table.xlsx	XLSX spreadsheet	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.

TEP

1. FFP Purchases will autopopulate from the respective tabs.
2. Vendors shall populate the Extended Price Total from the SPI List for each contract year.
3. Total Evaluated Price (TEP) will total at the bottom of this sheet. This TEP will be used for source selection price evaluation purposes only.
Base Year FFP Purchases	$0.00
Base Year SPI Extended Price Total

Option Year 1 FFP Purchases	$0.00
Option Year 1 SPI Extended Price Total

Option Year 2 FFP Purchases	$0.00
Option Year 2 SPI Extended Price Total

Option Year 3 FFP Purchases	$0.00
Option Year 3 SPI Extended Price Total

Option Year 4 FFP Purchases	$0.00
Option Year 4 SPI Extended Price Total

Vendor's Total Evaluated Price $0.00

Base Year

This sheet is for source selection evaluation purposes only and will not be included at the time of award
1. Base Year Period of Performance is NTE $1,900,000.00
2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items.
3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database
and 20% can be made using the alternate database.
4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate.
5. The spreadsheet will calculate applied discounts and total price by contract year. Fixed Price totals and the SPI List totals will be added to calculate Total Evaluated Price
Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (based on FY19 actuals)	Annual Expenditures	Coefficient from Attach Y - Column H	Total Discount from Applied Coefficient	Total Price With Coefficient Applied
Primary (80% use)	Grainger	Electrical Systems	21%	$277,200.00		$277,200.00	$0.00
Alternate(20% use)	Graybar	Electrical Systems	21%	$69,300.00		$69,300.00	$0.00

Primary (80% use)	Grainger	Power Production	4%	$52,800.00	$52,800.00	$0.00
Alternate(20% use)	NAPA	Power Production	4%	$13,200.00	$13,200.00	$0.00

Primary (80% use)	Grainger	HVAC/Controls	37%	$488,400.00	$488,400.00	$0.00
Alternate(20% use)	Supply House	HVAC/Controls	37%	$122,100.00	$122,100.00	$0.00

Primary (80% use)	Grainger	Structures	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Lowes	Structures	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Utilities	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Ferguson	Utilities	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Horizontal Rpr	9%	$118,800.00	$118,800.00	$0.00
Alternate(20% use)	Napa	Horizontal Rpr	9%	$29,700.00	$29,700.00	$0.00

Primary (80% use)	Grainger	Tools/Safety	7%	$92,400.00	$92,400.00	$0.00
Alternate(20% use)	Tool Source	Tools/Safety	7%	$23,100.00	$23,100.00	$0.00
				$ 1,650,000.00	$1,650,000.00	$0.00

Option Year 1

This sheet is for source selection evaluation purposes only and will not be included at the time of award
1. Option year 1 Period of Performance is NTE $1,900,000.00
2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items.
3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database
and 20% can be made using the alternate database.
4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate.
5. The spreadsheet will calculate applied discounts and total price.
Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (based on FY19 actuals)	Annual Expenditures	Coefficient from Attach Y - Column H	Total Discount from Applied Coefficient	Total Price With Coefficient Applied
Primary (80% use)	Grainger	Electrical Systems	21%	$ 277,200.00		$277,200.00	$0.00
Alternate(20% use)	Graybar	Electrical Systems	21%	$ 69,300.00		$69,300.00	$0.00

Primary (80% use)	Grainger	Power Production	4%	$52,800.00	$52,800.00	$0.00
Alternate(20% use)	NAPA	Power Production	4%	$13,200.00	$13,200.00	$0.00

Primary (80% use)	Grainger	HVAC/Controls	37%	$488,400.00	$488,400.00	$0.00
Alternate(20% use)	Supply House	HVAC/Controls	37%	$122,100.00	$122,100.00	$0.00

Primary (80% use)	Grainger	Structures	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Lowes	Structures	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Utilities	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Ferguson	Utilities	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Horizontal Rpr	9%	$118,800.00	$118,800.00	$0.00
Alternate(20% use)	Napa	Horizontal Rpr	9%	$29,700.00	$29,700.00	$0.00

Primary (80% use)	Grainger	Tools/Safety	7%	$92,400.00	$92,400.00	$0.00
Alternate(20% use)	Tool Source	Tools/Safety	7%	$23,100.00	$23,100.00	$0.00
				$ 1,650,000.00	$1,650,000.00	$0.00

Option Year 2

This sheet is for source selection evaluation purposes only and will not be included at the time of award
1. Option Year 2 Period of Performance is NTE $1,900,000.00
2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items.
3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database
and 20% can be made using the alternate database.
4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate.
5. The spreadsheet will calculate applied discounts and total price.
Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (based on FY19 actuals)	Annual Expenditures	Coefficient from Attach Y - Column H	Total Discount from Applied Coefficient	Total Price With Coefficient Applied
Primary (80% use)	Grainger	Electrical Systems	21%	$ 277,200.00		$277,200.00	$0.00
Alternate(20% use)	Graybar	Electrical Systems	21%	$ 69,300.00		$69,300.00	$0.00

Primary (80% use)	Grainger	Power Production	4%	$52,800.00	$52,800.00	$0.00
Alternate(20% use)	NAPA	Power Production	4%	$13,200.00	$13,200.00	$0.00

Primary (80% use)	Grainger	HVAC/Controls	37%	$488,400.00	$488,400.00	$0.00
Alternate(20% use)	Supply House	HVAC/Controls	37%	$122,100.00	$122,100.00	$0.00

Primary (80% use)	Grainger	Structures	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Lowes	Structures	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Utilities	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Ferguson	Utilities	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Horizontal Rpr	9%	$118,800.00	$118,800.00	$0.00
Alternate(20% use)	Napa	Horizontal Rpr	9%	$29,700.00	$29,700.00	$0.00

Primary (80% use)	Grainger	Tools/Safety	7%	$92,400.00	$92,400.00	$0.00
Alternate(20% use)	Tool Source	Tools/Safety	7%	$23,100.00	$23,100.00	$0.00
				$ 1,650,000.00	$1,650,000.00	$0.00

Option Year 3

This sheet is for source selection evaluation purposes only and will not be included at the time of award
1. Option Year 3 Period of Performance is NTE $1,900,000.00
2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items.
3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database
and 20% can be made using the alternate database.
4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate.
5. The spreadsheet will calculate applied discounts and total price.
Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (based on FY19 actuals)	Annual Expenditures	Coefficient from Attach Y - Column H	Total Discount from Applied Coefficient	Total Price With Coefficient Applied
Primary (80% use)	Grainger	Electrical Systems	21%	$ 277,200.00		$277,200.00	$0.00
Alternate(20% use)	Graybar	Electrical Systems	21%	$ 69,300.00		$69,300.00	$0.00

Primary (80% use)	Grainger	Power Production	4%	$52,800.00	$52,800.00	$0.00
Alternate(20% use)	NAPA	Power Production	4%	$13,200.00	$13,200.00	$0.00

Primary (80% use)	Grainger	HVAC/Controls	37%	$488,400.00	$488,400.00	$0.00
Alternate(20% use)	Supply House	HVAC/Controls	37%	$122,100.00	$122,100.00	$0.00

Primary (80% use)	Grainger	Structures	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Lowes	Structures	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Utilities	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Ferguson	Utilities	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Horizontal Rpr	9%	$118,800.00	$118,800.00	$0.00
Alternate(20% use)	Napa	Horizontal Rpr	9%	$29,700.00	$29,700.00	$0.00

Primary (80% use)	Grainger	Tools/Safety	7%	$92,400.00	$92,400.00	$0.00
Alternate(20% use)	Tool Source	Tools/Safety	7%	$23,100.00	$23,100.00	$0.00
				$ 1,650,000.00	$1,650,000.00	$0.00

Option Year 4

This sheet is for source selection evaluation purposes only and will not be included at the time of award
1. Option Year 4 Period of Performance is NTE $1,900,000.00
2. This spreadsheet anticipates NTE $1,650,000.00 in Fixed Price Purchases with the remaining NTE $250,000.00 in purchases made as either SPI or NPI items.
3. Annual expenditures are calculated based on historical usage by category with the anticipation 80% of fixed price purchases can be made utilizing the primary database
and 20% can be made using the alternate database.
4. Offerors are to apply their coefficients from Attachment 2 to the appropriate category and primary/alternate.
5. The spreadsheet will calculate applied discounts and total price.
Primary/Alternate	DATABASES	CATEGORY	USAGE PERCENTAGE (based on FY19 actuals)	Annual Expenditures	Coefficient from Attach Y - Column H	Total Discount from Applied Coefficient	Total Price With Coefficient Applied
Primary (80% use)	Grainger	Electrical Systems	21%	$277,200.00		$277,200.00	$0.00
Alternate(20% use)	Graybar	Electrical Systems	21%	$69,300.00		$69,300.00	$0.00

Primary (80% use)	Grainger	Power Production	4%	$52,800.00	$52,800.00	$0.00
Alternate(20% use)	NAPA	Power Production	4%	$13,200.00	$13,200.00	$0.00

Primary (80% use)	Grainger	HVAC/Controls	37%	$488,400.00	$488,400.00	$0.00
Alternate(20% use)	Supply House	HVAC/Controls	37%	$122,100.00	$122,100.00	$0.00

Primary (80% use)	Grainger	Structures	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Lowes	Structures	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Utilities	11%	$145,200.00	$145,200.00	$0.00
Alternate(20% use)	Ferguson	Utilities	11%	$36,300.00	$36,300.00	$0.00

Primary (80% use)	Grainger	Horizontal Rpr	9%	$118,800.00	$118,800.00	$0.00
Alternate(20% use)	Napa	Horizontal Rpr	9%	$29,700.00	$29,700.00	$0.00

Primary (80% use)	Grainger	Tools/Safety	7%	$92,400.00	$92,400.00	$0.00
Alternate(20% use)	Tool Source	Tools/Safety	7%	$23,100.00	$23,100.00	$0.00
				$1,650,000.00	$1,650,000.00	$0.00

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