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 includes a federal contract opportunity notice and pricing template for the Simplified Acquisition of Base Engineering Requirements (SABER) contract. The Department of the Air Force Materiel Command Air Force Sustainment Center is seeking proposals for a six-year IDIQ contract set aside for 8(a) small businesses located near Hill Air Force Base in Utah. Services will include fixed-price construction projects and a post-award conference. The anticipated CLIN structure includes project and conference CLINs. Draft documents are available and vendors should provide feedback by December 28, 2020. A site visit for a seed project is planned for mid-January 2021. Proposals will be due approximately 40 days after RFP release, anticipated in early January 2021. The pricing template includes instructions for offerors to populate fully burdened labor rates by skill over multiple years for evaluation purposes.

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
Attachment 07- Wage Determination - Box Elder County - 3 Jan 2020.pdf PDF
Attachment 10- Wage Determination - Sublette County WY - 14 Jan 2020.pdf PDF
Attachment 13 - SABER Seed Project SOW - Bldg. 100.pdf PDF
Attachment 14 - Seed Project Pricing Matrix.xlsx XLSX spreadsheet
Attachment 03 - Architectural Compatibility Plan (ACP).pdf PDF
Attachment 09- Wage Determination - Morgan-Weber Counties - 3 Jan 2020.pdf PDF
Attachment 16 - SABER Section M.pdf PDF
SABER Question-Comment Matrix.xlsx XLSX spreadsheet
Solicitation - FA820121R0007.pdf PDF
Attachment 04 - BASE FACILITY DESIGN STANDARD 19 OCT 2020.docx DOCX document
Attachment 08- Wage Determination - Daggett-Duchesne-Rich-Summit Counties - 3 Jan 2020.pdf PDF
Attachment 11- Wage Determination - Davis County - 3 Jan 2020.pdf PDF
Attachment 12 - Wage Determination - Salt Lake County - 31 Jan 2020.pdf PDF
Attachment 01 - SABER 2021 DRAFT SOW.pdf PDF
Attachment 05 - Hill AFB Construction and Demolition Waste Diversion Report.pdf PDF
Attachment 06- Bona Fide Office Requirements.pdf PDF
Attachment 15 - SABER Section L.pdf PDF
SABER 2021 DRAFT SOW.pdf PDF
Draft SABER Solicitation - FA820121R0007.pdf PDF
Show all 19

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 .