Attachment 11 - Total Evaluation Price - TEP 16 March 2022.xlsx
XLSX spreadsheet 40 KB Posted
- Attached to
- Roofing Repair, Hill AFB, UT Federal contract opportunity
- Solicitation number
- FA8201-22-R-0010
View the file
Other files for this federal contract opportunity
Show all 20
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
Total Evaluated Sumamry
| Total Evaluated Price TEP Calculation for the Roofing Single Contract Award Indefinite Delivery Indefinite Quantity |
| Instructions: |
1. The Offeror shall fill out both the Notional Amount Application Worksheet and the Seed Project Worksheet.
2. All prices shall be fully burdened and shall include direct, indirect costs, profit and construction labor.
3. The Offeror shall only complete fields highlited in yellow and not alter the spreadsheet in any way.
4. Offeror shall input all prices as whole dollars for all worksheets.
5. The Offeror shall complete all priced cell for the Notional Amount Worksheet (note: years 2 through 5 have a preset formula that may be adjusted or removed as desired).
6. The "Grand Total" for the Notional Amount Application" shall be a sum of the Totals and will auto populate into the "Total Evaluated Price Worksheet" Notional Amount Application Price Cell (C23).
7. Seed Project: The Offeror shall complete all priced cells highlighted in yellow (cells should have corrisponding amounts next to them).
8. The offeror shall input Bond information on the Seed Project Worksheet in the appropriate fields.
9. The "Grand Total" for the Seed Project shall be a sum of the Totals plus "BOND AMOUNT" and will auto populate into the "Total Evaluated Price Worksheet" Seed Project Price Cell (C24).
10. The Evaluated Price is the same as the Nontional Amount Application, the Total Combined Price is the combination of both but not considered for award.
11. If additional information is required the Offeror may be required to submit additional breakout of divisions.
| Product or Service | Total Price Element |
| Notional Amount Application | $ - 0 |
| Seed Project | $ - 0 |
| Total Combined Price | $ - 0 |
| Evaluated Price | $ - 0 |
&"Arial,Regular"FA8201-16-R-0006 Roofing IDIQ
Notional Amount Application Notional Amount Application Worksheet - 16 March 2022 All rates will auto-populate into this spreadsheet. All notional quantities will be determined by the Government prior to Offeror evaluation and will be applied to all Offerors equally. Notional quantities and totals will be populated by the Government and will not be disclosed to the Offerors.
| Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | 6 month option period will be based upon Year 5 pricing | |||||||||||||
| LINE ITEM | UNIT | Notional Quantities | Unit Price | Notional Total | Notional Quantities | Unit Price | Notional Total | Notional Quantities | Unit Price | Notional Total | Notional Quantities | Unit Price | Notional Total | Notional Quantities | Unit Price | Notional Total | ||
| A | REMOVE EXISTING 4-PLY BUILT-UP ROOF | SF | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | |
| B | REMOVE EXISTING SINGLE LAYER SHINGLED ROOF | SF | 15,000 | $0.00 | $0.00 | 15,000 | $0.00 | $0.00 | 15,000 | $0.00 | $0.00 | 15,000 | $0.00 | $0.00 | 15,000 | $0.00 | $0.00 | |
| C | REMOVE EXISTING INSULATION | SF | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | |
| D | REMOVE AND INSTALL NEW ROOF DRAINS | EA | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | |
| E | REMOVE EXISTING GUTTERS AND DOWNSPOUTS | LF | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | |
| F | REMOVE NON-FRIABLE ASBESTOS BASE FLASHING, INCLUDES OFF-BASE DUMPING AND HAULING CHARGES | SF | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | |
| G | REMOVE EXISTING WATERPROOFING MEMBRANE (DIRT COVERED ROOF) | SF | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | |
| H | REMOVE EARTH BERM AND BACKFILL | CY | 300 | $0.00 | $0.00 | 300 | $0.00 | $0.00 | 300 | $0.00 | $0.00 | 300 | $0.00 | $0.00 | 300 | $0.00 | $0.00 | |
| I | REMOVE EXISTING AGGREGATE OVER BUR | SF | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | |
| J | REMOVE AND INSTALL NEW ROOF HATCH | EA | 6 | $0.00 | $0.00 | 6 | $0.00 | $0.00 | 6 | $0.00 | $0.00 | 6 | $0.00 | $0.00 | 6 | $0.00 | $0.00 | |
| K | REMOVE / INSTALL LIGHTNING PROTECTION WITH RECERTIFICATION | LF | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | |
| L | LIFT AND RESET LIGHTNING PROTECTION, NO RECERTIFICATION NEEDED | LF | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | |
| M | SET-UP ( EAVE HEIGHT 15' - 30' ) | LS | 1 | $0.00 | $0.00 | 1 | $0.00 | $0.00 | 1 | $0.00 | $0.00 | 1 | $0.00 | $0.00 | 1 | $0.00 | $0.00 | |
| N | SET- UP ( EAVE HEIGHT 30' AND ABOVE ) | LS | 1 | $0.00 | $0.00 | 1 | $0.00 | $0.00 | 1 | $0.00 | $0.00 | 1 | $0.00 | $0.00 | 1 | $0.00 | $0.00 | |
| O | INSTALL A 2-PLY, 30 YEAR SBS MODIFIED BITUMEN ROOF SYSTEM WITH GRANULATED SBS CAP SHEET | SF | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | |
| P | INSTALL ASPHALT SHINGLES WITH #30 FELT | SF | 15,000 | $0.00 | $0.00 | 15,000 | $0.00 | $0.00 | 15,000 | $0.00 | $0.00 | 15,000 | $0.00 | $0.00 | 15,000 | $0.00 | $0.00 | |
| Q | INSTALL GALV. METAL FLASHING/COUNTER FLASHING ON EQUIPMENT AND CURBS | LF | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | |
| R | INSTALL METAL GRAVEL STOP/DRIP EDGE WITH 6" FACE | LF | 4,000 | $0.00 | $0.00 | 4,000 | $0.00 | $0.00 | 4,000 | $0.00 | $0.00 | 4,000 | $0.00 | $0.00 | 4,000 | $0.00 | $0.00 | |
| S | INSTALL EXPANSION JOINT | LF | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | |
| T | INSTALL 5" METAL GUTTERS AND DOWNSPOUTS | LF | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | |
| U | INSTALL 3" RIGID INSULATION BOARD | SF | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | |
| V | INSTALL FIBERGLASS BATT INSULATION | SF | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | |
| W | INSTALL METAL PARAPET CAP/COPING | LF | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | |
| X | INSTALL 3' WALKWAY | LF | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | |
| Y | INSTALL HEAT TRACE SYSTEM | LF | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | |
| Z | INSTALL 3/4" SHEATHING | SF | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | 400 | $0.00 | $0.00 | |
| AA | INSTALL SCUPPER | EA | 10 | $0.00 | $0.00 | 10 | $0.00 | $0.00 | 10 | $0.00 | $0.00 | 10 | $0.00 | $0.00 | 10 | $0.00 | $0.00 | |
| BB | INSTALL PITCH POCKETS | EA | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | |
| CC | INSTALL WOOD CURBS | BF | 200 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | |
| DD | INSTALL WATERPROOFING SYSTEM WITH DRAINAGE AND PROTECTION BOARD (DIRT COVERED ROOFS) | SF | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | |
| EE | INSTALL VEGETATION, GRASS (DIRT COVERED ROOFS) | SF | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | |
| FF | INSTALL GRAVEL COAT | SF | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | |
| GG | INSTALL CONCRETE SPLASH BLOCK | EA | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | 20 | $0.00 | $0.00 | |
| HH | INSTALL SNOW BARS/STOPS | LF | 1,500 | $0.00 | $0.00 | 1,500 | $0.00 | $0.00 | 1,500 | $0.00 | $0.00 | 1,500 | $0.00 | $0.00 | 1,500 | $0.00 | $0.00 | |
| II | INSTALL STRUCTURAL METAL STANDING SEAM ROOF SYSTEM OVER STRUCTURE, FASTNERS AND CLIPS (HYDROSTATIC) | SF | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | |
| JJ | INSTALL EPDM ROOF SYSTEM | SF | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | 2,000 | $0.00 | $0.00 | |
| KK | APPLY CAULK / SEALANT AS NEEDED | LF | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | 500 | $0.00 | $0.00 | |
| LL | CLEAN OUT GUTTERS, DOWNSPOUTS, AND DRAINS | LF | 200 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | 200 | $0.00 | $0.00 | |
| MM | INFRARED SURVEY | SF | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | 1,000 | $0.00 | $0.00 | |
| NN | EPDM/TPO/PVC ROOF REPAIRS/PATCHES | SF | 100 | $0.00 | $0.00 | 100 | $0.00 | $0.00 | 100 | $0.00 | $0.00 | 100 | $0.00 | $0.00 | 100 | $0.00 | $0.00 | |
| OO | REMOVE EXISTING METAL ROOFING | SF | 5,000 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | 0 | $0.00 | $0.00 | |
| PP | INSTALL 1/2' COVER BOARD | SF | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | |
| INSTALL PVC ROOF SYSTEM (80mil minimum) | SF | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 | 5,000 | $0.00 | $0.00 |
| TOTAL | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| GRAND TOTAL | $0.00 |
Roofing IDIQ
Seed Project
| See Total Evaluated Price Worksheet for Instructions how to fill out. | |||||
| LINE ITEM | UNIT | ESTIMATED QUANTITY | UNIT COST | TOTAL | |
| A | REMOVE EXISTING 4-PLY BUILT-UP ROOF | SF | 950 | $0.00 | |
| B | REMOVE EXISTING SINGLE LAYER SHINGLED ROOF | SF | $0.00 | ||
| C | REMOVE EXISTING INSULATION | SF | 950 | $0.00 | |
| D | REMOVE AND INSTALL NEW ROOF DRAINS | EA | $0.00 | ||
| E | REMOVE EXISTING GUTTERS AND DOWNSPOUTS | LF | 80 | $0.00 | |
| F | REMOVE NON-FRIABLE ASBESTOS BASE FLASHING, INCLUDES OFF-BASE DUMPING AND HAULING CHARGES | SF | $0.00 | ||
| G | REMOVE EXISTING WATERPROOFING MEMBRANE (DIRT COVERED ROOF) | SF | $0.00 | ||
| H | REMOVE EARTH BERM AND BACKFILL | CY | $0.00 | ||
| I | REMOVE EXISTING AGGREGATE OVER BUR | SF | 950 | $0.00 | |
| J | REMOVE AND INSTALL NEW ROOF HATCH | EA | $0.00 | ||
| K | REMOVE / INSTALL LIGHTNING PROTECTION WITH RECERTIFICATION | LF | $0.00 | ||
| L | LIFT AND RESET LIGHTNING PROTECTION, NO RECERTIFICATION NEEDED | LF | $0.00 | ||
| M | SET-UP ( EAVE HEIGHT 15' - 30' ) | LS | 2 | $0.00 | |
| N | SET- UP ( EAVE HEIGHT 30' AND ABOVE ) | LS | $0.00 | ||
| O | INSTALL A 2-PLY, 30 YEAR SBS MODIFIED BITUMEN ROOF SYSTEM WITH GRANULATED SBS CAP SHEET | SF | 950 | $0.00 | |
| P | INSTALL ASPHALT SHINGLES WITH #30 FELT | SF | $0.00 | ||
| Q | INSTALL GALV. METAL FLASHING/COUNTER FLASHING ON EQUIPMENT AND CURBS | LF | 220 | $0.00 | |
| R | INSTALL METAL GRAVEL STOP/DRIP EDGE WITH 6" FACE | LF | 200 | $0.00 | |
| S | INSTALL EXPANSION JOINT | LF | 18 | $0.00 | |
| T | INSTALL 5" ALUMINUM GUTTERS AND DOWNSPOUTS | LF | 80 | $0.00 | |
| U | INSTALL 3" RIGID INSULATION BOARD | SF | 2,450 | $0.00 | |
| V | INSTALL FIBERGLASS BATT INSULATION | SF | $0.00 | ||
| W | INSTALL METAL PARAPET CAP/COPING | LF | $0.00 | ||
| X | INSTALL 3' WALKWAY | LF | $0.00 | ||
| Y | INSTALL HEAT TRACE SYSTEM | LF | $0.00 | ||
| Z | INSTALL 3/4" SHEATHING | SF | $0.00 | ||
| AA | INSTALL SCUPPER | EA | $0.00 | ||
| BB | INSTALL PITCH POCKETS | EA | $0.00 | ||
| CC | INSTALL WOOD CURBS | BF | $0.00 | ||
| DD | INSTALL WATERPROOFING SYSTEM WITH DRAINAGE AND PROTECTION BOARD (DIRT COVERED ROOFS) | SF | $0.00 | ||
| EE | INSTALL VEGETATION, GRASS (DIRT COVERED ROOFS) | SF | $0.00 | ||
| FF | INSTALL GRAVEL COAT | SF | $0.00 | ||
| GG | INSTALL CONCRETE SPLASH BLOCK | EA | $0.00 | ||
| HH | INSTALL SNOW BARS/STOPS | LF | 100 | $0.00 | |
| II | INSTALL STRUCTURAL METAL STANDING SEAM ROOF SYSTEM OVER STRUCTURE, FASTNERS AND CLIPS (HYDROSTATIC) | SF | 550 | $0.00 | |
| JJ | INSTALL EPDM ROOF SYSTEM | SF | $0.00 | ||
| KK | APPLY CAULK / SEALANT AS NEEDED | LF | 300 | $0.00 | |
| LL | CLEAN OUT GUTTERS, DOWNSPOUTS, AND DRAINS | LF | $0.00 | ||
| MM | INFRARED SURVEY | SF | $0.00 | ||
| NN | EPDM/TPO/PVC ROOF REPAIRS/PATCHES | SF | $0.00 | ||
| OO | REMOVE EXISTING METAL ROOFING | SF | 550 | $0.00 | |
| PP | INSTALL 1/2" COVER BOARD | SF | 1,500 | $0.00 | |
| INSTALL PVC ROOF SYSTEM (80mil minimum) | SF | $0.00 | |||
| Sub Total | $0.00 | ||||
| Bid Bond Percentage | Bid Bond Percentage | ||||
| Bid Bond Amont | Bid Bond Amount | $0.00 | |||
| GRAND TOTAL | $0.00 |
Roofing IDIQ
File details come from the government source that posted it. Updated .