Attachment_07_TEP_Workseet.xlsx

XLSX spreadsheet 23 KB Posted

Attached to
Instructional Systems Development Training Services (ISDTS) Federal contract opportunity
Solicitation number
FA8224-19-R-A016
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center Hill Air Force Base

About this file

TEP Workseet

View the file

Other files for this federal contract opportunity

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 Name Fill In
Dated 1 Jan 2019 Hill AFB
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 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 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
10.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 THE 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.
11.0THE GOVERNMENT'S INTENT IS TO USE THE PROPOSED RATES ON SUBSEQUENT TASK ORDERS. LABOR RATES USED IN EACH TASK ORDER WILL BE TAKEN FROM THE PROPOSED RATES IN THE CALENDAR YEAR (CY) THE ORDER IS PLACED.
12.0THE EXAMPLES GIVEN BELOW ARE FOR ILLUSTRATIVE PURPOSES ONLY AND IN NO WAY REFLECT GOVERNMENT REQUIREMENTS OR EXPECTATIONS.
SKILL SET DESCRIPTION BASIC RATECY 2019 RateCY 2020 RateCY 2021 RateCY 2022 RateCY 2023 RateCY 2024 Rate
ISDTS Skill ReferenceOccupation CodeMinimum SCA Rate Base Hourly RateMinimum SCA Rate Health and Welfare Hourly RateBase Labor RateHealth & Welfare RateBurdened RateBase Labor RateHealth & Welfare RateBurdened RateBase Labor RateHealth & Welfare RateBurdened RateBase Labor RateHealth & Welfare RateBurdened RateBase Labor RateHealth & Welfare RateBurdened RateBase Labor RateHealth & Welfare RateBurdened Rate
(EXAMPLE) Systems Support Specialist14170$ 24.92$ 4.48$ 24.92$ 4.48$ 33.50$ 24.92$ 4.48$ 33.67$ 24.92$ 4.48$ 33.81$ 24.92$ 4.48$ 33.98$ 24.92$ 4.48$ 34.15$ 24.92$ 4.48$ 34.32
(EXAMPLE) InspectorN/AN/AN/A$ 35.00$ 4.48$ 50.00$ 35.00$ 4.48$ 50.25$ 35.00$ 4.48$ 50.50$ 35.00$ 4.48$ 50.75$ 35.00$ 4.48$ 51.00$ 35.00$ 4.48$ 51.26
Project ManagerN/AN/AN/A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sr. Courseware Developer (Computer Based Training Specialist)15050$ 31.89$ 4.48$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Courseware DeveloperN/AN/AN/A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Training AnalystN/AN/AN/A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sr. Subject Matter ExpertN/AN/AN/A$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Sr. Instructor / Technical Trainer15095$ 22.82$ 4.48$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Instructor / Technical Trainer15090$ 18.64$ 4.48$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Test Center Administrator / Proctor15110$ 15.04$ 4.48$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

File details come from the government source that posted it.