Attachment 04 - DRAFT TEP Matrix.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
Hill AFB Multiple Award Construction Contract (MACC IV) Federal contract opportunity
Solicitation number
FA8201-20-D-MACC
Issued by
Department of the Air Force Materiel Command Air Force Sustainment Center

About this file

This document provides information for the Hill AFB Multiple Award Construction Contract (MACC IV) opportunity. The Air Force Sustainment Center is seeking sources for design and construction services including maintenance, repair, alteration of real property, and new construction of facilities at Hill Air Force Base in Utah. The work will be awarded through multiple task orders under indefinite delivery indefinite quantity contracts awarded to successful offerors. The NAICS code is 236220 for Commercial and Institutional Building Construction with a size standard of $36.5 million. Responses are requested from small businesses including 8(a), service-disabled veteran-owned, HUBZone, and women-owned firms by November 23rd. An industry day will be held November 5-7 at Hill AFB to provide an introduction and allow for one-on-one sessions between offerors and the government. Attendees are limited to three per company and must RSVP with contact information by October 23rd.

View the file

Other files for this federal contract opportunity

Other files attached to Hill AFB Multiple Award Construction Contract (MACC IV), newest first.
File Type Posted
Attachment 02 - MACC IV Section L - 22 Sep 2020.docx DOCX document
Attachment 03 - MACC IV Section M - 22 Sep 2020.docx DOCX document
Attachment 01 - MACC IV - Basic SOW 22 Sep 2020.docx DOCX document
FA8201-20-R-0018 Draft RFP Q and A Matrix - 22 Sep 2020.xlsx XLSX spreadsheet
Attachment 04 - DRAFT TEP Matrix - 18 Sep 2020.xlsx XLSX spreadsheet
Attachment 02 - DRAFT MACC IV Section L - 18 Sep 2020.docx DOCX document
DRAFT Solicitation - FA820120R0018 - 18 Sep 2020.pdf PDF
Attachment 03 - DRAFT MACC IV Section M - 18 Sep 2020.docx DOCX document
FA8201-20-R-0018 Draft RFP Q and A Matrix - 18 Sep 2020.xlsx XLSX spreadsheet
Attachment 40 - Draft MACC IV PPI Tool.docx DOCX document
Attachment 01 - DRAFT MACC IV Basic SOW - 9 Sep 2020.docx DOCX document
Attachment 03 - DRAFT MACC IV Section M - 9 Sep 2020.docx DOCX document
FA8201-20-R-0018 Draft RFP Q and A Matrix - 10 Sep 2020.xlsx XLSX spreadsheet
Attachment 02 - DRAFT MACC IV Section L - 9 Sep 2020.docx DOCX document
DRAFT Solicitation 1 Sept 20 - FA820120R0018.pdf PDF
Attachment 03 - DRAFT MACC IV Section M - 2 Sep 2020.docx DOCX document
Attachment 02 - DRAFT MACC IV Section L - 2 Sep 2020.docx DOCX document
FA8201-20-R-0018 Draft RFP Q and A Matrix.xlsx XLSX spreadsheet
MACC IV - Consolidation DF - 20 AUG 2020_Redacted.pdf PDF
Attachment 38 - Wage Determination - Davis County - 3 Jan 2020.pdf PDF
Attachment 39 - Wage Determination - Salt Lake County - 31 Jan 2020.pdf PDF
Attachment 34 - Wage Determination - Box Elder County - 3 Jan 2020.pdf PDF
Solicitation - FA820120R0018.pdf PDF
Attachment 01 - DRAFT MACC IV Basic SOW - 21 Aug 2020.docx DOCX document
Attachment 35 - Wage Determination - Daggett-Duchesne-Rish-Summit Counties - 3 Jan 2020.pdf PDF
Attachment 02 - DRAFT MACC IV Section L - 21 Aug 2020.docx DOCX document
Attachment 05 - DRAFT MACC IV Sample Project SOW - 21 Aug 2020.docx DOCX document
Attachment 03 - DRAFT MACC IV Section M - 21 Aug 2020.docx DOCX document
Attachment 37 - Wage Determination - Sublette County WY - 14 Jan 2020.pdf PDF
Attachment 36 - Wage Determination - Morgan-Weber Counties - 3 Jan 2020.pdf PDF
MACC IV IDIQ Industry Day Slides 20191016 Rev4.pptx PPTX presentation
Attachment_05_-_Basic_SOW_01_Oct_2019.pdf PDF
Question_Matrix.xlsx XLSX spreadsheet
Show all 33

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

Rate Worksheet

BINDING NOT TO EXCEED (NTE) HOURLY LABOR RATE MATRIX

FOR

PROFESSIONAL LABOR CATEGORY RATE REQUIREMENTS - NOT SUBJECT TO THE CONSTRUCTION WAGE RATE REQUIREMENTS STATUTE - FORMERLY DAVIS-BACON ACT (DBA)

REQUIRED BY THE STATEMENT OF WORK (SOW)

Direct Labor Hourly Rate: Salaries paid to workers directly attribured to specific finished product.

Total Compensation Hourly Rate: Salaries plus any other employee compensation associated with being a "fringe benefit" (holiday pay, vacation, 401K, etc.).

Fully-Burdened Hourly Rate: Total compensation plus all other indirect rates including profit.

= Complete Cells shaded blue like at the right, do not otherwise alter spreadsheet
Ordering PeriodRates for ordering period 1 are valid from date of basic contract award thru 12 months. Subsequent ordering periods 2-5 are valid 12 months thereafter, and ordering period 6 is valid only 6 months thereafter. Exact dates will be determined upon basic contract award.
Labor CategoryBasic SOW ref.NTE Direct Labor Hourly Rates for Ordering Period 1NTE Total Compensation Hourly Rates for Ordering Period 1NTE Fully-Burdened Hourly Rates for Ordering Period 1NTE Fully-Burdened Hourly Rates for Ordering Period 2NTE Fully-Burdened Hourly Rates for Ordering Period 3NTE Fully-Burdened Hourly Rates for Ordering Period 4NTE Fully-Burdened Hourly Rates for Ordering Period 5NTE Fully-Burdened Hourly Rates for Ordering Period 6
Contract Manager (CM)1.5.1.1
Contractor Project Manager (PM)1.5.1.2.
Project Superintendent1.5.1.3.
Contractor Quality Control (CQC) System Manager1.5.1.4.

FA8201-20-R-0018

Multiple Award Construction Contract IV (MACC IV)

Attachment 2 For Evaluation and Award Purposes Binding NTE Non-DBA Labor Rate Matrix

Sample Project Rollup Costs

MACC TASK ORDER PRICING WORKSHEET

FOR SAMPLE PROJECT

= Complete Cells shaded blue like at the right, do not otherwise alter spreadsheet
PROJECT NUMBER5931819
MAGNITUDE OF CONSTRUCTION (Per FAR 36.204)$1M - $5M
PROJECT TITLE/DESCRIPTIONBuilding 2113 (B2113) is a munitions x-ray and record storage facility located in a controlled Munitions Storage Area of Hill AFB. The facility was constructed during the 1950’s, and this MACC IV Sample Project will upgrade the building’s aging condition to current building codes and other required standards for continued operation. The scope of work includes, but is not limited to, upgraded munitions x-ray equipment and containment, fire protection, mechanical and electrical systems and secure storage facilities throughout the building.
FACILITY NUMBERBuilding 2113
PERIOD OF PERFORMANCE730Calendar Days After Notice To Proceed
SECTION I
DescriptionQtyU/IUnit PriceTotal
All costs and prices associated with the performance of this project other than those listed below (i.e. Labor, Material, Subcontractor, Equipment Rental, etc) as set forth in the 'Sample Project Division Detail' worksheet.1Project$ - 0$ - 0
SECTION II
Professional Labor Rate Requirement applicable to this project
DescriptionQtyU/IUnit PriceTotal
Contract Manager (CM)Hour$ - 0$ - 0
Contractor Project Manager (PM)Hour$ - 0$ - 0
Project SuperintendentHour$ - 0$ - 0
Contractor Quality Control (CQC) System ManagerHour$ - 0$ - 0
Section II Total$ - 0
Task Order Total (Sum Sections I, II)$ - 0

Contractor Certification: By submission of this proposal, I hereby certify that the hourly rates for the professional labor categories cited above do not exceed the rates proposed and incorporated into the basic contract.

Signature: __________________________________________

Title: ______________________________________________

Date:_______________________________________________

FA8201-20-R-0018

Multiple Award Construction Contract IV (MACC IV)

Attachment 2For Evaluation & Award of
Seed Project PurposesTask Order Pricing for Seed Project

Sample Project Division Detail Instructions:

1. All prices shall be burdened and shall include direct, indirect costs, profit and construction labor. Professional labor rates shall be detailed separately on the 'Seed Project Rollup Costs' Worksheet.

2. Input all prices as whole dollars.

3. The offeror shall complete all priced cells with either the appropriate amount or "N/A" if not applicable.

4. The sum of Divisions below shall equal the sum of the "Prime Contractor Total" and "Subcontractor Total".

5. The offeror shall input Bond information below in the appropriate fields.

6. The "Grand Total" below shall be a sum of Prime and Subcontractor Totals plus "BOND AMT" and will auto populate into the' Seed Project Rollup Costs' Worksheet Direct Costs Cell (D10)

8. The offeror shall only complete fields and not alter the spreadsheet in any way.

9. If additional information is required the offeror may be required to submit additional breakout of divisions.

= Complete Cells shaded blue like at the right, do not otherwise alter spreadsheet
PRICE ESTIMATEBLDG NO.2113W.O. NO.Project No.5931819Contract No.TBD
PROJECT TITLE / SUBTITLECONTRACTORDATE
Renovate Building 2113 Computed Tomography BayTBD
BASE TOTALSTOTAL PRICE
Prime Contractor Total
Subcontractor Total
DIVISION BREAKOUTPRICE
Division 1 - General Requirements
Division 2 - Existing Conditions
Division 3 - Concrete
Division 4 - Masonry
Division 5 - Metals
Division 6 - Wood, Plastics & Composites
Division 7 - Thermal and Moisture Protection
Division 8 - Openings
Division 9 - Finishes
Division 10 - Specialties
Division 11 - Equipment
Division 12 - Furnishings
Division 13 - Special Construction
Division 14 - Conveying Systems
Division 21 - Fire Suppression
Division 22 - Plumbing
Division 23 - HVAC
Division 26 - Electrical
Division 27 - Communications
Division 28 - Electronic Safety & Security
Division 31 - Earthwork
Division 32 - Exterior Improvements
Division 33 - Utilities
Division 34 - Transportation
Division 35 - Waterway & Marine Const.
Division 41 - Material Handling & Processing
Division 44 - Pollution Control Equipment
Miscellaneous - Provide explanation and itemized list of Prices

BOND PERCENT BOND AMT. GRAND TOTAL $0

OFFEROR'S SIGNATURE BLOCKDATE
OFFEROR'S SIGNATURE
Project Manager
OFFEROR'S TITLEFIRM'S NAME

* * * For Official Use Only * * *

AF Form 3052 - &A * * * For Official Use Only * * * Page &P of &N

Notional Amount Application Notional Amount Application Worksheet All rates will auto-populate into this spreadsheet. All notional hours will be determined by the government prior to Offeror evaluation and will be applied to all Offerors equally. Notional hours and totals will be populated by the Government and will not be disclosed to the Offerors.

Ordering Period 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5Ordering Period 6
Labor CategoryBasic SOW ref.NTE Hourly RatesNotional HoursNotional TotalNTE Hourly RatesNotional HoursNotional TotalNTE Hourly RatesNotional HoursNotional TotalNTE Hourly RatesNotional HoursNotional TotalNTE Hourly RatesNotional HoursNotional TotalNTE Hourly RatesNotional HoursNotional Total
Contract Manager (CM)1.5.1.1$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contractor Project Manager (PM)1.5.1.2.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Project Superintendent1.5.1.3.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Contractor Quality Control (CQC) System Manager1.5.1.4.$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Subtotal Professional Labor$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Total Labor $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Grand Total $ - 0

FA8601-20-R-0018

Multiple Award Construction Contract IV (MACC IV)

Attachment 2 For Evaluation and Award Purposes Binding NTE Non-DBA Labor Rate Matrix

Total Evaluated Price Calc

TOTAL EVALUATED PRICE (TEP) CALCULATION FOR THE

MULTIPLE AWARD CONSTRUCTION CONTRACT (MACC)

Product or Service DescriptionTotal Price Element
Sample Project$ - 0
Notional Amount Application$ - 0
Post Award Conference$ 2,500
Total Evaluated Price:$ 2,500.00

FA8601-20-R-0018

Multiple Award Construction Contract IV (MACC IV)

Attachment 2 For Evaluation and Award Purposes Total Price Evaluation (TEP) Calculation

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