Attachment 02 - SABER TEP Matrix.xlsx

XLSX spreadsheet 35 KB Posted

Attached to
Simplified Acquisition of Base Engineering Requirements (SABER)
Solicitation number
FA820121R0007
Issued by

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

Show all 19

On GovTribe

Work with this file

  • 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 .