Attachment 3 ITCC TEP Matrix.xlsx

XLSX spreadsheet 322 KB Posted

Attached to
Hill Air Force Base Information Technology Consolidated Contract (ITCC) Federal contract opportunity
Solicitation number
FA820120R0007
Issued by
Department of the Air Force Materiel Command Air Force Sustainment Center

About this file

This document contains templates and instructions for pricing a federal information technology contract opportunity. The templates include direct labor rates, indirect rates, and pricing matrices to be populated by offerors responding to Solicitation Number FA820120R0007. This solicitation is for an Indefinite Delivery/Indefinite Quantity contract to provide information technology support services to Hill Air Force Base, issued by the Department of the Air Force Materiel Command Air Force Sustainment Center. Responses are due by February 25, 2020. Pricing will be evaluated for five one-year ordering periods from January 2021 to January 2026. Individual task orders issued under the contract will have a base period of up to 12 months but may be extended up to 6 additional months for orders issued in the final year using FAR Clause 52.217-8. Templates must be completed with direct labor rates for 15 labor categories across the five ordering periods as well as indirect rates. Pricing matrices include notional labor hours for evaluation purposes.

View the file

Other files for this federal contract opportunity

Show all 20

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

Direct Labor Rates

DIRECT LABOR RATES
Notes and Instructions:
1. ALL LABOR HOUR RATES SHALL REPRESENT DIRECT LABOR COSTS ONLY (NO INDIRECTS).
2. ENSURE THAT THE NUMBERS PROVIDED HERE CORRELATE TO THE NUMBERS PROVIDED IN ALL SHEETS.
3. LABOR CATEGORIES ARE SHOWN BELOW.
4. ALL LABOR CATEGORIES FOR ALL YEARS MUST BE POPULATED.
5. DO NOT EXTEND LABOR HOUR RATES BEYOND TWO DECIMAL PLACES.
6. THE OFFEROR SHALL POPULATE TASK ORDER PRICE YEAR RATES WITH ITS DIRECT LABOR RATES FOR ALL LABOR CATEGORIES. DO NO USE ZEROS OR NOT APPLICABLE.
7. DO NOT RENAME WORKSHEET TABS. IT IS ONLY NECESSARY TO POPULATE THE CELLS.
DIRECT LABOR
Labor CategoriesBase Task Order Price Year Rates 15 Jan 2021 to 14 Jan 2022Year 1 Task Order Price Year Rates 15 Jan 2022 to 14 Jan 2023Year 2 Task Order Price Year Rates 15 Jan 2023 to 14 Jan 2024Year 3 Task Order Price Year Rates 15 Jan 2024 to 14 Jan 2025Year 4 Task Order Price Year Rates 15 Jan 2025 to 14 Jan 202552.217-8 Option to Extend Services Rates 14 Jan 2027 to 13 Jul 2027
Program Manager$0.00$0.00$0.00$0.00$0.00$0.00
Lead Help Desk Technician$0.00$0.00$0.00$0.00$0.00$0.00
Help Desk Technician$0.00$0.00$0.00$0.00$0.00$0.00
Lead Client Services Technician$0.00$0.00$0.00$0.00$0.00$0.00
Client Services Technician$0.00$0.00$0.00$0.00$0.00$0.00
eTools Technician$0.00$0.00$0.00$0.00$0.00$0.00
Printer Technician$0.00$0.00$0.00$0.00$0.00$0.00
Expeditor$0.00$0.00$0.00$0.00$0.00$0.00
Server Adminitrator, Senior$0.00$0.00$0.00$0.00$0.00$0.00
Server Adminitrator$0.00$0.00$0.00$0.00$0.00$0.00
Network Support Technician$0.00$0.00$0.00$0.00$0.00$0.00
UNIT Software Manager$0.00$0.00$0.00$0.00$0.00$0.00
Giant Voice Support Technician$0.00$0.00$0.00$0.00$0.00$0.00

Indirect Rates

INDIRECT RATES

Notes and Instructions:
1. INDIRECT CATEGORIES ARE FOR EXAMPLE ONLY. ALTER AS NECESSARY.
2. INDIRECT RATES SHALL BE FOR THE ENTIRE PERIOD OF PERFORMANCE (15 JAN 2021 TO 13 JUL 2027).
3. DO NOT RENAME WORKSHEET TABS. IT IS ONLY NECESSARY TO POPULATE THE CELLS

DESCRIPTION Base Task Order Price Year Rates 15 Jan 2021 to 14 Jan 2022 Year 1 Task Order Price Year Rates 15 Jan 2022 to 14 Jan 2023 Year 2 Task Order Price Year Rates 15 Jan 2023 to 14 Jan 2024 Year 3 Task Order Price Year Rates 15 Jan 2024 to 14 Jan 2025 Year 4 Task Order Price Year Rates 15 Jan 2025 to 14 Jan 2026 52.217-8 Option to Extend Services Rates 14 Jan 2027 to 13 Jul 2027

Fringe0.00%0.00%0.00%0.00%0.00%0.00%
O/H0.00%0.00%0.00%0.00%0.00%0.00%
G&A0.00%0.00%0.00%0.00%0.00%0.00%
FCCM0.00%0.00%0.00%0.00%0.00%0.00%

Profit (FFP) 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%

Fully Burden Rate-Profit

LABOR PRICE/COST TEMPLATE
Note and Instructions:
1.PROVIDE THE COST ELEMENTS THAT WILL FEED INTO RATES AND PRICES IN SUBSEQUENT SHEETS.
2.ENSURE THAT THE BASIS OF EACH ELEMENT, AND SUPPORTING RATIONALE, ARE INCLUDED IN THE COST/PRICE VOLUME IN ACCORDANCE WITH SECTION L.
3.INSERT FORMULAS INTO THE SPREADSHEET WHICH SHOW HOW RATES ARE CONSTRUCTED. FORMULA RESULTS SHALL BE CONTRACTRUALLY BINDING AS WILL NUMBERS DIRECTLY ENTERED. UPDATE LINKS IF NECESSARY.
4.ENSURE THAT THE NUMBERS PROVIDED HERE CORRELATE TO THE NUMBERS PROVIDED IN ALL SHEETS.
5.REVIEW THE NOTES AND INSTRUCTIONS OF SUBSEQUENT SHEETS AS THEY WILL ALSO APPLY TO THIS SHEET UNLESS OTHERWISE NOTED.
6.THE GOVERNMENT RESERVES THE RIGHT TO ALTER (FOR EVALUATION PURPOSES ONLY) COST IN THIS TABLE IN ACCORDANCE WITH SECTION M.
7.POPULATE THE TABLE IN ITS ENTIRETY.
8.DO NOT RENAME WORKSHEET TABS. IT IS ONLY NECESSARY TO POPULATE THE CELLS
ITCC IDIQ Task Order (TO) Price Year Rates
Base Task Order Price Year 15 Jan 2021 to 14 Jan 2022Year 1 Task Order Price Year 15 Jan 2022 to 14 Jan 2023Year 2 Task Order Price Year 15 Jan 2023 to 14 Jan 2024Year 3 Task Order Price Year 15 Jan 2024 to 14 Jan 2025
Labor CategoryRegular Direct Labor RateFringeOverheadG&ACOMProfit
(FFP)Fully Burdened Labor Price Thru FeeRegular Direct Labor RateFringeOverheadG&ACOMProfit
(FFP)Fully Burdened Labor Price Thru FeeRegular Direct Labor RateFringeOverheadG&ACOMProfit
(FFP)Fully Burdened Labor Price Thru FeeRegular Direct Labor RateFringeOverheadG&ACOMProfit
(FFP)Fully Burdened Labor Price Thru FeeRegular Direct Labor RateFringeOverheadG&ACOMProfit
(FFP)Fully Burdened Labor Price Thru FeeRegular Direct Labor RateFringeOverheadG&ACOMProfit
(FFP)Fully Burdened Labor Price Thru Fee
%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT%AMOUNT
Actual Rates0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
Program Manager$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Lead Help Desk Technician$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Help Desk Technician$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Lead Client Services Technician$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Client Services Technician$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
eTools Technician$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Printer Technician$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Expeditor$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Server Adminitrator, Senior$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Server Adminitrator$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Network Support Technician$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
UNIT Software Manager$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
Giant Voice Support Technician$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0$ - 0$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 00.00%$ - 0
ITCC Ordering Period
1. The ITCC IDIQ has a 5 year ordering period from 15 Jan 2021 to 14 Jan 2026, with no option periods. 2. For clarification, 52.217-9 Option to extend the term of the contract is not applicable to this effort and the contract does not contain an Option Year 1., Option Year 2.. 3. TOs may be issued at any time during the 5 year ordering period. 4. 52.217-8 Option to extend services for up to 6 months shall not be exercised to extend the 5 year ordering period; the ordering period shall remain 15 Jan 2021 to 14 Jan 2026.
Pricing ITCC Task Orders
1. The ITCC Task Order (TO) Price Year Rates are organized into price years (i.e., Base TO Price Year 15 Jan 2021 to 14 Jan 2022, Year 1 Task Order Price Year 15 Jan 2022 to 14 Jan 2023) and shall be used to price TOs. 2. TOs shall be priced according to the applicable ITCC Task Order Price Year Rates for the TO start date of the period of performance (PoP). For example, a TO with 20 Jan 2021 to 19 Jan 2022 PoP shall use Base Task Order Price Year 15 Jan 2021 to 14 Jan 2022 rates. 3. Prorated pricing of TOs using multiple Task Order Price Years Rates is not authorized. For example, a TO with 20 Jan 2021 to 19 Jan 2022 PoP will not use the Base TO Price Year Rates to price 20 Jan 2021 to 14 Jan 2022 and then use Year 1 TO Price Year Rates to price 15 Jan 2022 to 19 Jan 2022. With the 20 Jan 2021 start date of the PoP, the Base Task Order Price Year 15 Jan 2021 to 14 Jan 2022 Rates shall be used to price the order (reference Note 1).
ITCC Task Order Performance Periods
1. TOs issued during the 5 year ordering period shall not exceed a 12 month Period of Performance (PoP). 2. The FAR 52.217-8 Option to extend services may be used to extend TOs issued during the last year of the ordering period, 15 Jan 2025 to 14 Jan 2026. The Contracting Officer (CO) may extend TOs issued during the last year of the ordering period, 15 Jan 2025 to 14 Jan 2026, for a period not to exceed 6 months if the CO determines that 1) the award of a follow-on contract is delayed by circumstances that were not reasonably foreseeable at the time the initial contract was entered into and 2) the extension is necessary to ensure the continuity of services, pending the award of the follow-on contract. 3. For TOs extended in the last year of the Ordering Period using 52.217-8, the total duration of the PoP of a TO shall not exceed 18 months and shall end 13 July 2027 or earlier. 4. The contractor shall not be required to make any deliveries under this contract after 13 Jul 2027. The terms and conditions of the base contract remain valid and in full force and effect for the performance of any TO, including any exercise of 52.217-8, during the TO’s PoP.

TEP Matrix

TEP Pricing Matrix
Instructions:
1. Offeror to ensure proper RATE in Column D (red font)
2. Quantity is notional and is only provided as an example
3. Numbers used in this example are not reflective of actual costs anticipated by the Government
Direct Labor
PositionHourly RateNotional Value/HrsTotal
Base Task Order Price Year
15 Jan 2021 to 14 Jan 2022Program Manager$ -- 0$ -
Lead Help Desk Technician$ -- 0$ -
Help Desk Technician$ -- 0$ -
Lead Client Services Technician$ -- 0$ -
Client Services Technician$ -- 0$ -
eTools Technician$ -- 0$ -
Printer Technician$ -- 0$ -
Expeditor$ -- 0$ -
Server Adminitrator, Senior$ -- 0$ -
Server Adminitrator$ -- 0$ -
Network Support Technician$ -- 0$ -
UNIT Software Manager$ -- 0$ -
Giant Voice Support Technician$ -- 0$ -
$ -- 0$ -
$ -- 0$ -
Subtotal$ -
PositionHourly RateNotional Value/HrsTotal
Year 1 Task Order Price Year
15 Jan 2022 to 14 Jan 2023Program Manager$ -- 0$ -
Lead Help Desk Technician$ -- 0$ -
Help Desk Technician$ -- 0$ -
Lead Client Services Technician$ -- 0$ -
Client Services Technician$ -- 0$ -
eTools Technician$ -- 0$ -
Printer Technician$ -- 0$ -
Expeditor$ -- 0$ -
Server Adminitrator, Senior$ -- 0$ -
Server Adminitrator$ -- 0$ -
Network Support Technician$ -- 0$ -
UNIT Software Manager$ -- 0$ -
Giant Voice Support Technician$ -- 0$ -
$ -- 0$ -
$ -- 0$ -
Subtotal$ -
PositionHourly RateNotional Value/HrsTotal
Year 2 Task Order Price Year
15 Jan 2023 to 14 Jan 2024Program Manager$ -- 0$ -
Lead Help Desk Technician$ -- 0$ -
Help Desk Technician$ -- 0$ -
Lead Client Services Technician$ -- 0$ -
Client Services Technician$ -- 0$ -
eTools Technician$ -- 0$ -
Printer Technician$ -- 0$ -
Expeditor$ -- 0$ -
Server Adminitrator, Senior$ -- 0$ -
Server Adminitrator$ -- 0$ -
Network Support Technician$ -- 0$ -
UNIT Software Manager$ -- 0$ -
Giant Voice Support Technician$ -- 0$ -
$ -- 0$ -
$ -- 0$ -
Subtotal$ -
PositionHourly RateNotional Value/HrsTotal
Year 3 Task Order Price Year
15 Jan 2024 to 14 Jan 2025Program Manager$ -- 0$ -
Lead Help Desk Technician$ -- 0$ -
Help Desk Technician$ -- 0$ -
Lead Client Services Technician$ -- 0$ -
Client Services Technician$ -- 0$ -
eTools Technician$ -- 0$ -
Printer Technician$ -- 0$ -
Expeditor$ -- 0$ -
Server Adminitrator, Senior$ -- 0$ -
Server Adminitrator$ -- 0$ -
Network Support Technician$ -- 0$ -
UNIT Software Manager$ -- 0$ -
Giant Voice Support Technician$ -- 0$ -
$ -- 0$ -
$ -- 0$ -
Subtotal$ -
PositionHourly RateNotional Value/HrsTotal
Year 4 Task Order Price Year
15 Jan 2025 to 14 Jan 2026Program Manager$ -- 0$ -
Lead Help Desk Technician$ -- 0$ -
Help Desk Technician$ -- 0$ -
Lead Client Services Technician$ -- 0$ -
Client Services Technician$ -- 0$ -
eTools Technician$ -- 0$ -
Printer Technician$ -- 0$ -
Expeditor$ -- 0$ -
Server Adminitrator, Senior$ -- 0$ -
Server Adminitrator$ -- 0$ -
Network Support Technician$ -- 0$ -
UNIT Software Manager$ -- 0$ -
Giant Voice Support Technician$ -- 0$ -
$ -- 0$ -
$ -- 0$ -
Subtotal$ -
PositionHourly RateNotional Value/HrsTotal
52.217-8 Option to Extend Services
14 Jan 2027 to 13 Jul 2027Program Manager$ -- 0$ -
Lead Help Desk Technician$ -- 0$ -
Help Desk Technician$ -- 0$ -
Lead Client Services Technician$ -- 0$ -
Client Services Technician$ -- 0$ -
eTools Technician$ -- 0$ -
Printer Technician$ -- 0$ -
Expeditor$ -- 0$ -
Server Adminitrator, Senior$ -- 0$ -
Server Adminitrator$ -- 0$ -
Network Support Technician$ -- 0$ -
UNIT Software Manager$ -- 0$ -
Giant Voice Support Technician$ -- 0$ -
$ -- 0$ -
$ -- 0$ -
Subtotal$ -
TOTAL TEP
CLINDescriptionAmount
0001Program Manager$ -
0002Client Services Support (CTS)$ -
0003eTools$ -
0004Service Desk (CSD)$ -
0005Printer Support$ -
0006Expeditor Support$ -
0007Network Support$ -
0008Software Management (USLM)$ -
0009Giant Voice Support$ -
0010Server Administration$ -
0011Data Per CDRLNSP
0012Post Award Conference$ 1,000
$ 1,000
Total TEP$ 1,000

BOEING PROPRIETARY

SOURCE SELECTION INFORMATION - SEE FAR 2.101 AND 3.104

FOR OFFICAL USE ONLY

This is the start of the file's text. The full file is on GovTribe.

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