Attachment 02 - SABER TEP Matrix.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Simplified Acquisition of Base Engineering Requirements (SABER) Federal contract opportunity
Solicitation number
FA820121R0007
Issued by
Department of the Air Force Materiel Command Air Force Sustainment Center

About this file

This document provides details for a federal solicitation seeking maintenance, repair, and construction services on facilities at Hill Air Force Base in Utah and other locations. Offerors must submit proposals by March 9, 2021 to be considered for the Simplified Acquisition of Base Engineering Requirements indefinite delivery, indefinite quantity contract. A mandatory site visit will be held on February 17, 2021 for offerors to visit the seed project location. Only 8(a) small businesses may compete for this contract, which is set aside for that socioeconomic category. The contract will have a five-year period of performance, and task orders will be issued to define specific project requirements. Questions are due by February 23, 2021 and responses will be provided by March 2, 2021. The Past Performance Information tool, provided separately, must be used to submit details of relevant past projects.

View the file

Other files for this federal contract opportunity

Other files attached to Simplified Acquisition of Base Engineering Requirements (SABER), newest first.
File Type Posted
Government Responses to Follow up Questions_03162021.xlsx XLSX spreadsheet
Attachment 15 - SABER Section L_Revision 1.pdf PDF
Solicitation Amendment - FA8201-21-R-0007-0001.pdf PDF
Bldg. 100-Landscape Symbols.pdf PDF
Government Responses SABER Question Comment Matrix 31121.xlsx XLSX spreadsheet
Bldg. 100 Utilities (2).JPG JPG image
Bldg 100 Utilities.png PNG image
Bldg. 100 Existing Steam Pipe Sizes.pdf PDF
SABER Site Visit Attendees.xlsx XLSX spreadsheet
Government Responses SABER Question Comment Matrix.xlsx XLSX spreadsheet
HAZMAT Info to Provide to Hill AFB.xlsx XLSX spreadsheet
Asbestos and LBP Report_Bldg 100 Bay N_O_P Modify Exterior_ Install Comm Room.pdf PDF
Attachment 03 - Architectural Compatibility Plan (ACP).pdf PDF
Attachment 05 - Hill AFB Construction and Demolition Waste Diversion Report.pdf PDF
Attachment 08- Wage Determination - Daggett-Duchesne-Rich-Summit Counties - 1 Jan 2021.pdf PDF
Attachment 09- Wage Determination - Morgan-Weber Counties - 1 Jan 2021.pdf PDF
Attachment 15 - SABER Section L.pdf PDF
Solicitation - FA820121R0007.pdf PDF
Attachment 10- Wage Determination - Sublette County WY - 1 Jan 2021.pdf PDF
Attachment 11- Wage Determination - Davis County - 1 Jan 2021.pdf PDF
Attachment 12 - Wage Determination - Salt Lake County - 1 Jan 2021.pdf PDF
SABER Question-Comment Matrix.xlsx XLSX spreadsheet
Attachment 01 - SABER Basic SOW.pdf PDF
Attachment 06- Bona Fide Office Requirements.pdf PDF
Attachment 14 - Seed Project Pricing Matrix.xlsx XLSX spreadsheet
Attachment 16 - SABER Section M.pdf PDF
Attachment 04 - Base Facility Design Standard 19 OCT 2020.pdf PDF
Attachment 07- Wage Determination - Box Elder County - 1 Jan 2021.pdf PDF
Attachment 13 - Seed Project SOW - Bldg. 100.pdf PDF
Show all 29

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

Hill AFB

= Offeror Fill In
Dated XX Jan 2021
Notes and Instructions:
1.0BASE LABOR RATES AND HEALTH & WELFARE RATES ARE PROVIDED TO FACILITATE EVALUATION OF SERVICE CONTRACT ACT COMPLIANCE. SCA RATES ARE MINIMUM RATES FOR BASE LABOR AND HEALTH AND WELFARE.
2.0ALL FULLY BURDENED (REGULAR, SURGE AND OVERTIME) RATES ARE FULLY BURDENED RATES FOR EACH SKILL SET AND ARE INCLUSIVE OF ALL LABOR COSTS (DIRECT AND INDIRECT) AND PROFIT.
3.0DO NOT ADD CATEGORIES OR CHANGE WORKSHEET COLUMNS OR ROWS.
4.0POPULATE ALL RATES FOR ALL YEARS WITH NUMERICAL PRICES. DO NOT LEAVE CELLS BLANK, EVEN IF DUPLICATIVE. DO NOT USE ZEROS. DO NOT USE N/A. EXPLAIN IN NARRATIVE DOCUMENTATION ANY OBVIOUS NONCONFORMITIES (i.e. negative or no inflation, non-uniform burdens, overtime, or profit/fee, etc.)
5.0DO NOT EXTEND RATES BEYOND TWO DECIMAL PLACES.
6.0DO NOT ADD OR RENAME WORKSHEET TABS. IT IS ONLY NECESSARY TO POPULATE THE GREEN SHADED CELLS.
7.0THE RATES IN THIS TABLE WILL BE CONTRACTUALLY BINDING AND WILL BE USED AS A NTE TABLE FOR ALL SUBSEQUENT TASK ORDERS IN ALL PRICING ARRANGEMENTS FOR ALL TEAM MEMBERS INCLUDING THE PRIME OFFEROR, INTERDIVISIONAL ORDERS, AND SUBCONTRACTORS. THIS TABLE WILL NOT BE MODIFIED AFTER AWARD AND NO ADDITIONAL CATEGORIES OR LABOR RATES WILL BE ADDED DURING CONTRACT PERFORMANCE EXCEPT AT THE GOVERNMENT'S SOLE DISCRETION
8.0AT THE TASK ORDER LEVEL THE GOVERNMENT WILL ENSURE THAT THE PROPOSED RATES DO NOT EXCEED THE NOT TO EXCEED (NTE) RATES BELOW FOR THE REQUIRED SKILL SET WITH THE NUMBER OF REQUIRED HOURS.
9.0THE PURPOSE OF THE OVERTIME RATE IS FOR "ABOVE 40 HOURS PER WEEK" REQUIREMENTS, WHEN CONTRACT SUPPORT IS REQUIRED (i.e., weekends, fiscal end of year requirements, beyond standard work schedule) IAW PWS 7.7
10.0THE PURPOSE OF THE SURGE RATE IS TO PROVIDE THE GOVERNMENT THE FLEXIBILITY TO ADD CONTRACTOR PERSONNEL TO THE TASK ORDER AS WELL AS BRING BACK PREVIOUSLY REDUCED SKILLSETS IAW PWS 2.1.7
11.0FOR SCA RATES IAW FAR 52.222-43 THE PROPOSED RATES SHALL "NOT INCLUDE ANY ALLOWANCE FOR ANY CONTINGENCY TO COVER INCREASED COSTS FOR WHICH ADJUSTMENT IS PROVIDED UNDER 52.222-43". THE SCA BASE AND HEALTH AND WELFARE (H&W) RATES SHALL NOT CONTAIN ANY INFLATION ADJUSTMENT FROM YEAR TO YEAR. FOR OFFEROR CONVENIENCE THE BASE LABOR RATE AND H&W SCA RATES WILL AUTO POPULATE AFTER FIRST YEAR. IF THE OFFEROR FEELS IT HAS A LEGITIMATE REASON FOR INCREASING THESE RATES OVER TIME THE OFFEROR MAY CLEAR THE FORMULAS FROM THESE CELLS TO INPUT VALUES, BUT WILL EXPLAIN ITS REASONING IN THE PRICING VOLUME.
12.0THE EXAMPLES GIVEN BELOW ARE FOR ILLUSTRATIVE PURPOSES ONLY AND IN NO WAY REFLECT GOVERNMENT REQUIREMENTS OR EXPECTATIONS.
SKILL SET DESCRIPTION BASIC RATEFY 2022 RateFY 2023 RateFY 2024 RateFY 2025 RateFY 2026 RateFY 2027 Rate
SABER Position TitleBase Labor RateFringe BenefitsG&A RateOverhead RateProfit Rate
PercentageProfit RateFully Burdened RateBase Labor RateHealth & Welfare RateBurdened RateBurdened Surge RateBase Labor RateHealth & Welfare RateBurdened RateBurdened Surge RateBurdened Overtime RateBase Labor RateHealth & Welfare RateBurdened RateBurdened Surge RateBurdened Overtime RateBase Labor RateHealth & Welfare RateBurdened RateBurdened Surge RateBurdened Overtime RateBase Labor RateHealth & Welfare RateBurdened RateBurdened Surge RateBurdened Overtime Rate
(EXAMPLE) Inspector$ 50.00$ 5.00$ 5.00$ 10.005.00%ERROR:#REF!ERROR:#REF!$ 51.50$ 10.30$ 72.05$ 83.98$ 53.05$ 10.61$ 74.58$ 86.87$ 99.16$ 54.64$ 10.93$ 77.20$ 89.86$ 102.52$ 56.28$ 11.26$ 79.92$ 92.76$ 105.59$ 57.96$ 11.59$ 82.73$ 95.74$ 108.76
Contract Manager$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Project Manager/Superintendent$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Quality Control Officer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Site Safety and Health Officer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Environmental Officer$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

Labor Rates

Dated XX Jan 2021 SABER Total Evaluated Price (TEP) Matrix

Notes and Instructions:
1.0OFFEROR SHALL INPUT PRICING INFORMATION INTO ALL CELLS THAT ARE HIGHLIGHTED GREEN. DO NOT INPUT INFORMATION INTO CELLS THAT ARE HIGHLIGHTED GREY. DO NOT ADD OR RENAME WORKSHEET TABS.
2.0ALL FULLY BURDENED RATES ARE FULLY BURDENED RATES FOR EACH SKILL SET AND ARE INCLUSIVE OF ALL LABOR COSTS (DIRECT AND INDIRECT) AND PROFIT.
3.0DO NOT ADD/CHANGE LABOR CATEGORIES, CHANGE WORKSHEET COLUMNS OR ROWS, OR MODIFY FORMULAS.
4.0POPULATE ALL RATES FOR ALL YEARS WITH NUMERICAL PRICES. DO NOT LEAVE CELLS BLANK, EVEN IF DUPLICATIVE. DO NOT USE N/A. EXPLAIN IN NARRATIVE DOCUMENTATION ANY OBVIOUS NONCONFORMITIES (i.e. negative or no inflation, non-uniform burdens, or profit/fee, etc.)
5.0DO NOT EXTEND RATES BEYOND TWO DECIMAL PLACES.
6.0DO NOT ADD OR RENAME WORKSHEET TABS. IT IS ONLY NECESSARY TO POPULATE THE GREEN SHADED CELLS.
7.0THE RATES IN THIS TABLE WILL BE CONTRACTUALLY BINDING AND WILL BE USED AS A NTE TABLE FOR ALL SUBSEQUENT TASK ORDERS IN ALL PRICING ARRANGEMENTS FOR ALL TEAM MEMBERS INCLUDING THE PRIME OFFEROR, INTERDIVISIONAL ORDERS, AND SUBCONTRACTORS. THIS TABLE WILL NOT BE MODIFIED AFTER AWARD AND NO ADDITIONAL CATEGORIES OR LABOR RATES WILL BE ADDED DURING CONTRACT PERFORMANCE EXCEPT AT THE GOVERNMENT'S SOLE DISCRETION
8.0AT THE TASK ORDER LEVEL THE GOVERNMENT WILL ENSURE THAT THE PROPOSED RATES DO NOT EXCEED THE NOT TO EXCEED (NTE) RATES BELOW FOR THE REQUIRED SKILL SET.
9.0THE EXAMPLES GIVEN BELOW ARE FOR ILLUSTRATIVE PURPOSES ONLY AND IN NO WAY REFLECT GOVERNMENT REQUIREMENTS OR EXPECTATIONS.
FY 2022 RateFY 2023 Rate
SABER Position TitleBase Labor RateFringe BenefitsG&A
RateOverhead RateProfit Rate
PercentageProfit RateFully Burdened RateSABER Position TitleBase Labor RateFringe BenefitsG&A
RateOverhead RateProfit Rate
PercentageProfit RateFully Burdened Rate
(EXAMPLE) Inspector$ 50.00$ 5.00$ 5.00$ 5.005.00%$ 3.25$ 68.25(EXAMPLE) Inspector$ 50.00$ 5.00$ 5.00$ 5.005.00%$ 3.25$ 68.25
Contract Manager$ - 0$ - 0Contract Manager$ - 0$ - 0
Project Manager/Superintendent$ - 0$ - 0Project Manager/Superintendent$ - 0$ - 0
Quality Control Officer$ - 0$ - 0Quality Control Officer$ - 0$ - 0
Site Safety and Health Officer$ - 0$ - 0Site Safety and Health Officer$ - 0$ - 0
Environmental Officer$ - 0$ - 0Environmental Officer$ - 0$ - 0
FY 2024 RateFY 2025 Rate
SABER Position TitleBase Labor RateFringe BenefitsG&A
RateOverhead RateProfit Rate
PercentageProfit RateFully Burdened RateSABER Position TitleBase Labor RateFringe BenefitsG&A
RateOverhead RateProfit Rate
PercentageProfit RateFully Burdened Rate
(EXAMPLE) Inspector$ 50.00$ 5.00$ 5.00$ 5.005.00%$ 3.25$ 68.25(EXAMPLE) Inspector$ 50.00$ 5.00$ 5.00$ 5.005.00%$ 3.25$ 68.25
Contract Manager$ - 0$ - 0Contract Manager$ - 0$ - 0
Project Manager/Superintendent$ - 0$ - 0Project Manager/Superintendent$ - 0$ - 0
Quality Control Officer$ - 0$ - 0Quality Control Officer$ - 0$ - 0
Site Safety and Health Officer$ - 0$ - 0Site Safety and Health Officer$ - 0$ - 0
Environmental Officer$ - 0$ - 0Environmental Officer$ - 0$ - 0
FY 2026 RateFY 2027 Rate
SABER Position TitleBase Labor RateFringe BenefitsG&A
RateOverhead RateProfit Rate
PercentageProfit RateFully Burdened RateSABER Position TitleBase Labor RateFringe BenefitsG&A
RateOverhead RateProfit Rate
PercentageProfit RateFully Burdened Rate
(EXAMPLE) Inspector$ 50.00$ 5.00$ 5.00$ 5.005.00%$ 3.25$ 68.25(EXAMPLE) Inspector$ 50.00$ 5.00$ 5.00$ 5.005.00%$ 3.25$ 68.25
Contract Manager$ - 0$ - 0Contract Manager$ - 0$ - 0
Project Manager/Superintendent$ - 0$ - 0Project Manager/Superintendent$ - 0$ - 0
Quality Control Officer$ - 0$ - 0Quality Control Officer$ - 0$ - 0
Site Safety and Health Officer$ - 0$ - 0Site Safety and Health Officer$ - 0$ - 0
Environmental Officer$ - 0$ - 0Environmental Officer$ - 0$ - 0

END OF SHEET*****************************************END OF SHEET*****************************************END OF SHEET

TEP Calculation

Total Evaluated Price Calculation

***GOVERNMENT USE ONLY - Offerors shall not input any information into this sheet.***

Offeror's Total Evaluated Price
$ - 0
FY 2022 Labor RatesFY 2023 Labor Rates
SABER Position TitleFully Burdened Labor RateNotional Value/HoursTotalSABER Position TitleFully Burdened Labor RateNotional Value/HoursTotal
Contract Manager$ - 0$ - 0Contract Manager$ - 0$ - 0
Project Manager/Superintendent$ - 0$ - 0Project Manager/Superintendent$ - 0$ - 0
Quality Control Officer$ - 0$ - 0Quality Control Officer$ - 0$ - 0
Site Safety and Health Officer$ - 0$ - 0Site Safety and Health Officer$ - 0$ - 0
Environmental Officer$ - 0$ - 0Environmental Officer$ - 0$ - 0
FY 2022 Total$ - 0FY 2023 Total$ - 0
FY 2024 Labor RatesFY 2025 Labor Rates
SABER Position TitleFully Burdened Labor RateNotional Value/HoursTotalSABER Position TitleFully Burdened Labor RateNotional Value/HoursTotal
Contract Manager$ - 0$ - 0Contract Manager$ - 0$ - 0
Project Manager/Superintendent$ - 0$ - 0Project Manager/Superintendent$ - 0$ - 0
Quality Control Officer$ - 0$ - 0Quality Control Officer$ - 0$ - 0
Site Safety and Health Officer$ - 0$ - 0Site Safety and Health Officer$ - 0$ - 0
Environmental Officer$ - 0$ - 0Environmental Officer$ - 0$ - 0
FY 2024 Total$ - 0FY 2025 Total$ - 0
FY 2026 Labor RatesFY 2027 Labor Rates
SABER Position TitleFully Burdened Labor RateNotional Value/HoursTotalSABER Position TitleFully Burdened Labor RateNotional Value/HoursTotal
Contract Manager$ - 0$ - 0Contract Manager$ - 0$ - 0
Project Manager/Superintendent$ - 0$ - 0Project Manager/Superintendent$ - 0$ - 0
Quality Control Officer$ - 0$ - 0Quality Control Officer$ - 0$ - 0
Site Safety and Health Officer$ - 0$ - 0Site Safety and Health Officer$ - 0$ - 0
Environmental Officer$ - 0$ - 0Environmental Officer$ - 0$ - 0
FY 2026 Total$ - 0FY 2027 Total$ - 0

***************************END OF SHEET***************************

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