Attachment_2_-_Roofing_Price_Matrix.xlsx

XLSX spreadsheet 67 KB Posted

Attached to
Enterprise Roof Replacement and Repair Federal contract opportunity
Solicitation number
FA8056-14-R-0001
Issued by
Department of the Air Force Materiel Command Installation and Mission Support Center Installation Contracting Agency

About this file

Attachment 2 - Roofing Price Matrix. This file is required to be submitted as part of an offeror's proposal package.

View the file

Other files for this federal contract opportunity

Other files attached to Enterprise Roof Replacement and Repair, newest first.
File Type Posted
Summary_of_Changes_RFP_FA8056-14-R-0001_Amendment_0007.docx DOCX document
Amendment_0007.pdf PDF
FA8056-14-R-0001_0006_Section_K_excerpt.pdf PDF
FA8056-14-R-0001_Amendment_0006.pdf PDF
Summary_of_Changes_RFP_FA8056-14-R-0001_Amendment_0006.docx DOCX document
Amend_0006_Clause_Fill_in_Checklist_Sec_K.pdf PDF
FA8056-14-R-0001_Amendment_0006-Signed.pdf PDF
Roofing_RFP_QandA_February_21_2014.pdf PDF
Roofing_RFP_QandA_February_20_2014.pdf PDF
Summary_of_Changes_RFP_FA8056-14-R-0001_Amendment_0004.docx DOCX document
Attachment_A_Proposal_Cover_Sheetv4(1).xlsx XLSX spreadsheet
Attachment_1_-_Roofing_Management_Plan_Worksheet(1).xlsx XLSX spreadsheet
Roofing_RFP_QandA_February_19_2014.pdf PDF
Roofing_RFP_QandA_February_14_2014v5.pdf PDF
Summary_of_Changes_RFP_FA8056-14-R-0001_Amendment_0003.docx DOCX document
Attachment_1_-_Roofing_Management_Plan_Worksheet.xlsx XLSX spreadsheet
FA8056-14-R-0001_Amendment_0002.doc DOC document
Attachment_A_-_Cover_Letter_Template.xlsx XLSX spreadsheet
Attachment_2_-_Roofing_Price_Matrix.xlsx XLSX spreadsheet
Summary_of_Changes_RFP_FA8056-14-R-0001_Amendment_0002.docx DOCX document
Roofing_RFP_QandA_February_7_2014.pdf PDF
Roofing_RFP_QandA_January_31_2014.pdf PDF
Roofing_RFP_QandA_January_24_2014.pdf PDF
FA8056-14-R-0001_Amendment_0001.doc DOC document
Attachment_1_-_Roofing_Management_Plan_Worksheet.xlsx XLSX spreadsheet
Summary_of_Changes_RFP_FA8056-14-R-0001_Amendment_0001.docx DOCX document
Attachment_7_-_Roofing_Past_Performance_Questionnaire_(Reference).pdf PDF
Roofing_RFP_QandA_January_17_2014.pdf PDF
Attachment_A_Proposal_Cover_Sheet.xlsx XLSX spreadsheet
Attachment_4_-_Region_Map_(Reference).pdf PDF
Attachment_1_-_Roofing_Management_Plan_Worksheet.xlsx XLSX spreadsheet
Attachment_5_-_Roofing_CDRL_(Reference).pdf PDF
Attachment_3_-_Roofing_Typical_and_Most_Difficult_Project_Descriptions_(Reference).xlsx XLSX spreadsheet
FA8056-14-R-0001_Request_For_Proposal.pdf PDF
Attachment_6_-_Davis_Bacon_Wage_Rates_(Reference).pdf PDF
Attachment_7_-_Roofing_Past_Performance_Questionnaire_(Reference).pdf PDF
Show all 36

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

Text version

Instructions (Read First)

Instructions to Offerors - Roofing Pricing Matrix
Purpose

The purpose of this workbook is for the Offeror to submit its per square foot pricing to be compared against other techically acceptable Offerors in the region.

Workbook Navigation This workbook contains six worksheets including the Instructions. There is one worksheet for each Region. Offerors shall submit only one file for each region they are proposing. If proposing on more than one region, offerors shall submit two separate files (one for each region). Since each region will be evaluated separately, the entire proposals must be separate for each region and stand alone. Please complete all fields marked in Red fill color.

Each Region worksheet is structured in a similar fashion - only the base names are different among the five Region worksheets. Identifying information is required at the top of each worksheet. Following this is a listing of active duty bases in the region across the worksheet columns. Down the first column is a listing of each of the eleven in-scope roof types. At the far right are tables that average unit prices, assign a weighting factor, and calculate your total evaluated price.

Required Information Please begin by providing the required information at the top of the worksheet including Company Name, Preparer Name, DUNS #, CAGE Code, and Date Prepared. Under this block, place an "X" in the checkbox to certify that you are authorized to bind your company/Joint Venture to the prices provided. Under the identifying information header block, the Offeror shall provide only two pieces of information for each Base and Roof Type: Typical Price and Most Difficult Price. Offerors should enter prices with no more than two (2) decimal places. No comments or other entries will be evaluated.

Before entering pricing data into a worksheet, please refer to Attachment 3 Roofing Typical and Most Difficult Project Descriptions.xlsx. That workbook contains the sample projects for each of the roof types, and provides each Offeror a basis to determine the Unit Price for the assembly and work identified. Once the Offeror has developed its unit prices, it shall transfer the unit prices to this roofing price matrix (enter unit prices by roof type from Row 7 to Row 17). You must provide a unit price for Typical and Most Difficult sample project for each roof type and each of the bases in the region in which you will be submitting a proposal.

How This Information Will Be Evaluated The spreadsheet will automatically calculate the "Average Cost By Roof Type" for the Typical and Most Difficult unit prices for the entire region for each Offeror. The spreadsheet will automatically multiply the Typical and Most Difficult unit prices by the "Regional Programmed Square Footage" for each roof type to calculate the "Extended Cost by Roof Type." The "Regional Programmed Square Footage" is the maximum anticipated quantity of work by roof type assuming a 5-year period of performance for the contract. The spreadsheet will automatically sum the "Total Extended Price" by region for "Typical" and "Most Difficult." This sum will be multiplied by the weight applied (80% for Typical, 20% for Most Difficult) to determine the "Total Weighted Extended Price." The sum of the two "Total Weighted Extended Prices" will determine the "Total Evaluated Price." The "Total Evaluated Price" will be used to determine the Lowest Priced Offeror in the region. The award of an IDIQ contract is to the Lowest Price Technically Acceptable (LPTA) Offeror. The LPTA price used will be the "Total Evaluated Price" submitted by the Offeror on this spreadsheet for the region in the Offeror's proposal. It is important to note: the Offeror must provide a price for all eleven roof types for all the bases in the region. Until prices are provided for all the roof types for all the bases in the region, this spreadsheet will not calculate the "Total Evaluated Price." Offerors are not able to be evaluated for this LPTA award unless the government is provided a "Total Evaluated Price" which results from completing all the unit prices in the spreadsheet. NOTE: The "Total Evaluated Price" is for evaluation purposes only and does not represent the value of the contract. Please note that for Task Order awards, the base Contracting Officer will determine whether each roofing project is considered "Typical" or "Most Difficult", and this determination will be final.

Submittal Instructions All fields requiring Offeror input are marked in Red fill color. Please do not submit a file with incomplete (Red) fields. Required fields will turn to Yellow color when completed. Once all required information has been provided in the Region worksheet, the Offeror shall submit it to the Government in MS-Excel electronic format as part of their proposal package. Before submitting, the Offeror is strongly recommended to review all of their stated unit prices as well as Total Evaluated Price for accuracy, as the Total Evaluated Price is used to form Offeror ranking.

U.S. Air Force Solicitation RFP FA8056-14-R-0001 Attachment 2 - Roofing Price Matrix &A

&D &P of &N

Region 1 West

Company Name:DUNS #:Date:
Prepared By:CAGE Code:ERROR:#DIV/0!
I certify that I am authorized by my company/Joint Venture agreement to submit pricing data to the Government.
Beale AFB, CAEdwards AFB, CALos Angeles AFB, CATravis AFB, CAVandenberg AFB, CABuckley AFB, COCheyenne Mountain AFS, COPeterson AFB, COSchriever AFB, COUnited States Air Force Academy, COMountain Home AFB, IDMalmstrom AFB, MTCreech AFB, NVNellis AFB, NVTonopah Test Range NVHill AFB, UTFairchild AFB, WAF.E. Warren AFB, WYAverage NTE Cost by Roof TypeRegional Programmed Square FootageExtended Cost by Roof Type
TypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultSquare FootageTypicalMost Difficult
1.Asphalt Built-up RoofERROR:#DIV/0!ERROR:#DIV/0!2,650,000ERROR:#DIV/0!ERROR:#DIV/0!
2.SBS Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!120,000ERROR:#DIV/0!ERROR:#DIV/0!
3.APP Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!340,000ERROR:#DIV/0!ERROR:#DIV/0!
4.EPDM Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!850,000ERROR:#DIV/0!ERROR:#DIV/0!
5.PVC Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!290,000ERROR:#DIV/0!ERROR:#DIV/0!
6.SPF MembraneERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
7.Metal (Hydrostatic) MembraneERROR:#DIV/0!ERROR:#DIV/0!1,300,000ERROR:#DIV/0!ERROR:#DIV/0!
8.Asphalt Shingle RoofERROR:#DIV/0!ERROR:#DIV/0!1,180,000ERROR:#DIV/0!ERROR:#DIV/0!
9.Tile RoofERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
10.Slate RoofERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
11.Metal RoofERROR:#DIV/0!ERROR:#DIV/0!2,900,000ERROR:#DIV/0!ERROR:#DIV/0!
Total Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Weight Applied80%20%
Total Weighted Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Total Evaluated PriceERROR:#DIV/0!

U.S. Air Force Solicitation RFP FA8056-14-R-0001 Attachment 2 - Roofing Price Matrix &A

&D &P of &N

Region 2 Midwest

Company Name:DUNS #:Date:
Prepared By:CAGE Code:
I certify that I am authorized by my company/Joint Venture agreement to submit pricing data to the Government.
Scott AFB, ILMinotMcConnell AFB, KSWhitemanWhiteman AFB, MOScottOffutt, AFB, NEMcConnellCavalier AFS, NDScottGrand Forks AFB, NDEllsworthMinot AFB, NDGrand ForksEllsworth AFB, SDOffuttAverage NTE Cost by Roof TypeRegional Programmed Square FootageExtended Cost by Roof Type
TypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultSquare FootageTypicalMost Difficult
1.Asphalt Built-up RoofERROR:#DIV/0!ERROR:#DIV/0!460,000ERROR:#DIV/0!ERROR:#DIV/0!
2.SBS Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!230,000ERROR:#DIV/0!ERROR:#DIV/0!
3.APP Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
4.EPDM Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!1,360,000ERROR:#DIV/0!ERROR:#DIV/0!
5.PVC Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!80,000ERROR:#DIV/0!ERROR:#DIV/0!
6.SPF MembraneERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
7.Metal (Hydrostatic) MembraneERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
8.Asphalt Shingle RoofERROR:#DIV/0!ERROR:#DIV/0!160,000ERROR:#DIV/0!ERROR:#DIV/0!
9.Tile RoofERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
10.Slate RoofERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
11.Metal RoofERROR:#DIV/0!ERROR:#DIV/0!930,000ERROR:#DIV/0!ERROR:#DIV/0!
Total Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Weight Applied80%20%
Total Weighted Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Total Evaluated PriceERROR:#DIV/0!

U.S. Air Force Solicitation RFP FA8056-14-R-0001 Attachment 2 - Roofing Price Matrix &A

&D &P of &N

Region 3 Northeast

Company Name:DUNS #:Date:
Prepared By:CAGE Code:
I certify that I am authorized by my company/Joint Venture agreement to submit pricing data to the Government.
Dover AFB, DEJoint Base Andrews AFB, MDWright-PattersonCape Cod AFS, MAHanscom AFB, MADoverNew Boston AFS, NHJoint Base McGuire-Dix-Lakehurst, NJRome Labs, NYWright-Patterson AFB, OHLangleyJoint Base Langley-Eustis, VAAverage NTE Cost by Roof TypeRegional Programmed Square FootageExtended Cost by Roof Type
TypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultSquare FootageTypicalMost Difficult
1.Asphalt Built-up RoofERROR:#DIV/0!ERROR:#DIV/0!1,670,000ERROR:#DIV/0!ERROR:#DIV/0!
2.SBS Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
3.APP Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
4.EPDM Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!540,000ERROR:#DIV/0!ERROR:#DIV/0!
5.PVC Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
6.SPF MembraneERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
7.Metal (Hydrostatic) MembraneERROR:#DIV/0!ERROR:#DIV/0!60,000ERROR:#DIV/0!ERROR:#DIV/0!
8.Asphalt Shingle RoofERROR:#DIV/0!ERROR:#DIV/0!250,000ERROR:#DIV/0!ERROR:#DIV/0!
9.Tile RoofERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
10.Slate RoofERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
11.Metal RoofERROR:#DIV/0!ERROR:#DIV/0!4,340,000ERROR:#DIV/0!ERROR:#DIV/0!
Total Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Weight Applied80%20%
Total Weighted Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Total Evaluated PriceERROR:#DIV/0!

U.S. Air Force Solicitation RFP FA8056-14-R-0001 Attachment 2 - Roofing Price Matrix &A

&D &P of &N

Region 4 Southwest

Company Name:DUNS #:Date:
Prepared By:CAGE Code:
I certify that I am authorized by my company/Joint Venture agreement to submit pricing data to the Government.
Davis-Monthan AFB, AZCannonLuke AFB, AZ (includes Gila Bend Air Force Auxiliary Field)Davis-MonthanCannon AFB, NMDyessHolloman AFB, NMLacklandKirtland AFB, NMGoodfellowAltus AFB, OKTinker AFB, OKVance AFB, OKDyess AFB, TXGoodfellow AFB, TXAltusJoint Base San Antonio (Lackland AFB, TX and Fort Sam Houston)Laughlin AFB, TXTinkerJoint Base San Antonio (Randolph AFB, TX)Sheppard AFB, TXAverage NTE Cost by Roof TypeRegional Programmed Square FootageExtended Cost by Roof Type
TypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultSquare FootageTypicalMost Difficult
1.Asphalt Built-up RoofERROR:#DIV/0!ERROR:#DIV/0!4,780,000ERROR:#DIV/0!ERROR:#DIV/0!
2.SBS Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!430,000ERROR:#DIV/0!ERROR:#DIV/0!
3.APP Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!1,250,000ERROR:#DIV/0!ERROR:#DIV/0!
4.EPDM Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
5.PVC Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
6.SPF MembraneERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
7.Metal (Hydrostatic) MembraneERROR:#DIV/0!ERROR:#DIV/0!730,000ERROR:#DIV/0!ERROR:#DIV/0!
8.Asphalt Shingle RoofERROR:#DIV/0!ERROR:#DIV/0!280,000ERROR:#DIV/0!ERROR:#DIV/0!
9.Tile RoofERROR:#DIV/0!ERROR:#DIV/0!360,000ERROR:#DIV/0!ERROR:#DIV/0!
10.Slate RoofERROR:#DIV/0!ERROR:#DIV/0!30,000ERROR:#DIV/0!ERROR:#DIV/0!
11.Metal RoofERROR:#DIV/0!ERROR:#DIV/0!1,430,000ERROR:#DIV/0!ERROR:#DIV/0!
Total Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Weight Applied80%20%
Total Weighted Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Total Evaluated PriceERROR:#DIV/0!

U.S. Air Force Solicitation RFP FA8056-14-R-0001 Attachment 2 - Roofing Price Matrix &A

&D &P of &N

Region 5 Southeast

Company Name:DUNS #:Date:
Prepared By:CAGE Code:
I certify that I am authorized by my company/Joint Venture agreement to submit pricing data to the Government.
Maxwell-Gunter AFB, ALPatrickLittle Rock AFB, ARBarksdaleAvon Park AFR, FLCharlestonCape Canaveral AFS, FLCharlestonEglin AFB, FLShawHurlburt Field AFB, FLPopeMacDill AFB, FLTyndallPatrick AFB, FLHurlburtTyndall AFB, FLLittle RockMoody AFB, GAArnoldRobbins AFB, GAColumbusBarksdale AFB, LAKeeslerColumbus AFB, MSMaxwellKeesler AFB, MSEglinSeymour-Johnson AFB, NCMacDillJoint Base Charleston, SCCharlestonShaw AFB, SCSeymour-JohnsonArnold AFB, TNRobbinsAverage NTE Cost by Roof TypeRegional Programmed Square FootageExtended Cost by Roof Type
TypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultTypicalMost DifficultSquare FootageTypicalMost Difficult
1.Asphalt Built-up RoofERROR:#DIV/0!ERROR:#DIV/0!7,080,000ERROR:#DIV/0!ERROR:#DIV/0!
2.SBS Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!570,000ERROR:#DIV/0!ERROR:#DIV/0!
3.APP Modified BitumenERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
4.EPDM Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!450,000ERROR:#DIV/0!ERROR:#DIV/0!
5.PVC Single Ply MembraneERROR:#DIV/0!ERROR:#DIV/0!390,000ERROR:#DIV/0!ERROR:#DIV/0!
6.SPF MembraneERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
7.Metal (Hydrostatic) MembraneERROR:#DIV/0!ERROR:#DIV/0!580,000ERROR:#DIV/0!ERROR:#DIV/0!
8.Asphalt Shingle RoofERROR:#DIV/0!ERROR:#DIV/0!860,000ERROR:#DIV/0!ERROR:#DIV/0!
9.Tile RoofERROR:#DIV/0!ERROR:#DIV/0!320,000ERROR:#DIV/0!ERROR:#DIV/0!
10.Slate RoofERROR:#DIV/0!ERROR:#DIV/0!20,000ERROR:#DIV/0!ERROR:#DIV/0!
11.Metal RoofERROR:#DIV/0!ERROR:#DIV/0!1,830,000ERROR:#DIV/0!ERROR:#DIV/0!
Total Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Weight Applied80%20%
Total Weighted Extended PriceERROR:#DIV/0!ERROR:#DIV/0!
Total Evaluated PriceERROR:#DIV/0!

U.S. Air Force Solicitation RFP FA8056-14-R-0001 Attachment 2 - Roofing Price Matrix &A

&D &P of &N

Sheet1

File details come from the government source that posted it. Updated .