J-3_LOE_Firm_Fixed_Price_Labor_Rates.xlsx
XLSX spreadsheet 59 KB Posted
- Attached to
- Cable Installation Support Services Federal contract opportunity
- Solicitation number
- 15F06722R0000197
About this file
This document package includes a pricing template and instructions for a federal solicitation seeking cable installation support services. The solicitation requests pricing and labor rates for installation of data, telephone, and low voltage cabling at FBI facilities over a five year base period and five one-year options. Services include design, implementation, testing and verification of physical layer cabling as well as demolition and on-site quality assurance for construction projects. Pricing tables require labor rates for positions including Program Manager, Logistics Technician, and Cable Installation Technicians at the junior and senior levels. Standard other direct costs are also provided for materials, travel and miscellaneous expenses totaling approximately $5.6 million for the base period. No pricing data is entered in the templates as this appears to be an example or instructional document rather than an active solicitation response.
View the file
Other files for this federal contract opportunity
Show all 23
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
Title Page
| Cable Installation Support Services |
| (CISS) |
| Attachment J-3 |
| Level of Effort Hours |
| Firm Fixed Price |
| Labor Rate Schedule |
Instructions CISS Proposal Preparation Instructions, by worksheet tab:
Note: CISS Base Contract Period of Performance (PoP) includes CLIN 0001 for Base Period (9/26/2022-9/25/2023), CLIN 1001 for Option Period 1 (9/26/2023-9/25/2024), CLIN 2001 for Option Period 2 (9/26/2024-9/25/2025), CLIN 3001 for Option Period 3 (9/26/2025-9/25/2026) and CLIN 4001 for Option Period 4 (9/26/2026-9/25/2027). Period of Performance breakout table by PoP is available in worksheet tab "CISS FBLR (Base & FLEX)"
| "CISS Prime Base FBLR" worksheet tab: |
| Inputs from this tab populates tab "CISS FBLR (Base & Flex) - Inputs are specific to the Prime offeror only and its' fully burdened labor rate(s). Offeror is required to input the following for each PoP: (a) Base labor rate per hour for each Labor Classification being proposed (columns C, F, I, L & O); (b) All applicable indirects (e.g. fringe, overhead, general and administrative, etc.) and profit which sums a dollar per hour amount (columns D, G, J, M & P); and (c) Government provided formula (columns E, H, K, N & Q) which calculates a fully burdened labor rate (thru Profit), offerors may alter or change the provided formula as deemed necessary. Prime offeror is responsible for a comprehensive proposal submittal to the Government for all proposed labor rate(s) per hour, based on it's proposal strategy (i.e., this worksheet tab must represent a fully integrated pricing strategy to include all subcontractors). |
| "CISS FBLR (Base & FLEX)" worksheet tab: |
| This worksheet tab requires no Prime offeror input. This worksheet details the Government provided Base Contract level-of-effort (LOE) labor hours and FLEX LOE Best Estimated Quantities (BEQs) (column: D, G, J, M & P) in accordance with the CISS RFP Attachment J-6 LOE Hours-Work Load Data. BEQs are for evaluation purposes only and are not a limit or guarantee of future work nor do they represent an obligation, commitment, or amount to be ordered by the Government. Fully burdened Labor Rates developed for the base contract are auto populated for Flex labor to maintain consistency, as required by the Government. |
| "CISS IV Base Other Direct Cost" worksheet tab: |
| This worksheet tab requires no Prime offeror input. The Government's provided plug numbers for each PoP (Base Period, Option 1, 2, 3 & 4) are detailed in the "CISS Base Other Direct Cost" worksheet tab and are in accordance with the CISS RFP. Prime offeror shall not alter the Government provided number (upward or downward) in any manner. |
| "CISS Base & FLEX Total Price" worksheet tab: |
| This worksheet tab requires no Prime offeror input. The first table in this worksheet tab summarizes the CISS Base and FLEX pricing by Period of Performance for Base Period (9/26/2022-9/25/2023), for Option Period 1 (9/26/2023-9/25/2024), for Option Period 2 (9/26/2024-9/25/2025) for Option Period 3 (9/26/2025-9/25/2026) and for Option Period 4 (9/26/2026-9/25/2027). The second table in this worksheet tab summarizes the CISS Base and FLEX fully burdened labor rate(s) thru profit, by Period of Performance. |
&"Arial,Regular"&12 SMASS IV 80KSC022R0010 &"Arial,Regular"&12BASIC PRICE TEMPLATE &"Arial,Regular"&12ATTACHMENT L-04
&P of &N
CISS Prime Base FBLR
Fully Burdened Labor Rate - Straight Time - Dollars ($XX.XX) per Hour
| Base Period (CLIN 0001) | |
| 9/26/2022-9/25/2023 | Option Period 1 (CLIN 1001) |
| 9/26/2023-9/25/2024 | Option Period 2 (CLIN 2001) |
| 9/26/2024-9/25/2025 | Option Period 3 (CLIN 3001) |
| 9/26/2025-9/25/2026 | Option Period 4 (CLIN 4001) |
9/26/2026-9/25/2027
| PRIME LABOR CLASSIFICATIONS | Base Labor Rate $ | Indirects thru Profit $ | Fully Burdened S/T Labor Rate $ | Base Labor Rate $ | Indirects thru Profit $ | Fully Burdened S/T Labor Rate $ | Base Labor Rate $ | Indirects thru Profit $ | Fully Burdened S/T Labor Rate $ | Base Labor Rate $ | Indirects thru Profit $ | Fully Burdened S/T Labor Rate $ | Base Labor Rate $ | Indirects thru Profit $ | Fully Burdened S/T Labor Rate $ | |
| 1 | Program Manager | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 2 | Logistics Technician | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 3 | Cable Installation Technician-Junior (O&M) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||||||||||
| 4 | Cable Installation Technician-Senior (O&M) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
SMASS IV 80KSC022R0010
ATTACHMENT L-04
Basic Cost Price Template
&"Times New Roman,Regular"&12SEB Sensitive - See FAR 2.101 and 3.104 &"Times New Roman,Regular"&12Printed On: &D
CISS FBLR (Base & FLEX)
CISS Base Contract - Direct Labor (Fully Burdened thru Profit) Level-of-Effort (LOE) Hours
| Base Period (CLIN 0001 ) | |||
| 9/26/2022-9/25/2023 | Option Period 1 (CLIN 1001) | ||
| 9/26/2023-9/25/2024 | Option Period 2 (CLIN 2001) | ||
| 9/26/2024-9/25/2025 | Option Period 3 (CLIN 3001) | ||
| 9/26/2025-9/25/2026 | Option Period 4 (CLIN 4001) | ||
| 9/26/2026-9/25/2027 | Total | ||
| Labor Classification Title | Base Labor |
Hours
| (FY 22-23) | Fully Burdened Labor Rate-thru Profit |
| (FY 22-23) | Fully Burdened Dollars |
| (FY 22-23) | Base Labor |
Hours
| (FY 23-24) | Fully Burdened Labor Rate-thru Profit |
| (FY 23-24) | Fully Burdened Dollars |
| (FY 23-24) | Base Labor |
Hours
| (FY 24-25) | Fully Burdened Labor Rate-thru Profit |
| (FY 24-25) | Fully Burdened Dollars |
| (FY 24-25) | Base Labor |
Hours
| (FY 25-26) | Fully Burdened Labor Rate-thru Profit |
| (FY 25-26) | Fully Burdened Dollars |
| (FY 25-26) | Base Labor |
Hours
| (FY 26-27) | Fully Burdened Labor Rate-thru Profit | |
| (FY 26-27) | Fully Burdened Dollars | |
| (FY 26-27) | Labor Hours | Direct Labor Dollars |
Fully Burdened thru Profit
| Program Manager | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 5,760 | $ - 0 |
| Logistics Technician | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 5,760 | $ - 0 |
| Cable Installation Technician-Junior (O&M) | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 5,760 | $ - 0 |
| Cable Installation Technician-Senior (O&M) | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 1,920 | $0.00 | $ - 0 | 5,760 | $ - 0 |
| 7,680 | $ - 0 | 7,680 | $ - 0 | 7,680 | $ - 0 | 7,680 | $ - 0 | 7,680 | $ - 0 | 23,040 | $ - 0 |
| Base Period (CLIN 0002) | |||
| 9/26/2022-9/25/2023 | Option Period 1 (CLIN 1002) | ||
| 9/26/2023-9/25/2024 | Option Period 2 (CLIN 2002) | ||
| 9/26/2024-9/25/2025 | Option Period 3 (CLIN 3002) | ||
| 9/26/2025-9/25/2026 | Option Period 4 (CLIN 4002) | ||
| 9/26/2026-9/25/2027 | Total | ||
| Labor Classification Title | Labor |
Hour BEQ's
| (FY 22-23) | Fully Burdened Labor Rate-thru Profit |
| (FY 22-23) | Fully Burdened Dollars |
| (FY 22-23) | Labor |
Hour BEQ's
| (FY 23-24) | Fully Burdened Labor Rate-thru Profit |
| (FY 23-24) | Fully Burdened Dollars |
| (FY 23-24) | Labor |
Hour BEQ's
| (FY 24-25) | Fully Burdened Labor Rate-thru Profit |
| (FY 24-25) | Fully Burdened Dollars |
| (FY 24-25) | Labor |
Hour BEQ's
| (FY 25- 26) | Fully Burdened Labor Rate-thru Profit |
| (FY 25- 26) | Fully Burdened Dollars |
| (FY 25- 26) | Labor |
Hour BEQ's
| (FY 26-27)) | Fully Burdened Labor Rate-thru Profit | |
| (FY 26-27) | Fully Burdened Dollars | |
| (FY 26-27) | Labor Hours BEQ's | Direct Labor Dollars |
Fully Burdened thru Profit
| Program Manager | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 3,000 | $ - 0 |
| Logistics Technician | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 3,000 | $ - 0 |
| Cable Installation Technician-Junior (O&M) | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 3,000 | $ - 0 |
| This worksheet tab requires no Prime offeror input. The first table in this worksheet tab summarizes the CISS Base and FLEX pricing by Period of Performance for Base Period (9/26/2022-9/25/2023), for Option Period 1 (9/26/2023-9/25/2024), for Option Period 2 (9/26/2024-9/25/2025) for Option Period 3 (9/26/2025-9/25/2026)for Option Period 4 (9/26/2026-9/25/2027), and the 6 month extension 9/26/2027-3/26/2028 in accordance with FAR Clause 52.217-8. The second table in this worksheet tab summarizes the CISS Base and FLEX fully burdened labor rate(s) thru profit, by Period of Performance. | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 1,000 | $ - 0 | $ - 0 | 3,000 | $ - 0 |
| 4,000 | $ - 0 | 4,000 | $ - 0 | 4,000 | $ - 0 | $ 4,000 | $ - 0 | $ 4,000 | $ - 0 | 12,000 | $ - 0 |
| 7,680 | $ - 0 | 7,680 | $ - 0 | 7,680 | $ - 0 | 23,040 | $ - 0 |
| 4,000 | $ - 0 | 4,000 | $ - 0 | 4,000 | $ - 0 | 12,000 | $ - 0 |
| 11,680 | $ - 0 | 11,680 | $ - 0 | 11,680 | $ - 0 | 35,040 | $ - 0 |
&"Arial,Regular"&12 SMASS IV 80KSC022R0010 &"Arial,Regular"&12BASIC PRICE TEMPLATE &"Arial,Regular"&12ATTACHMENT L-04
&P of &N
CISS Base Other Direct Cost
| OTHER DIRECT COSTS | |||||||||
| ACCOUNTS/ELEMENTS | |||||||||
| Base Period (CLIN 0001) | |||||||||
| 9/26/2022-9/25/2023 | Option 1 (CLIN 1001) | ||||||||
| 9/26/2023-9/25/2024 | Option 2 (CLIN 2001) | ||||||||
| 9/25/2024-9/24/2025 | Option 3 (CLIN 3001) | ||||||||
| 9/25/2025-9/24/2026 | Option 4 (CLIN 4001) | ||||||||
| 9/25/2026-9/24/2027 | TOTAL | REFERENCE/BOE | |||||||
| Note: CISS Base Contract Period of Performance (PoP) includes CLIN 0001 for Base Period (9/26/2022-9/25/2023), CLIN 1001 for Option Period 1 (9/26/2023-9/25/2024), CLIN 2001 for Option Period 2 (9/26/2024-9/25/2025), CLIN 3001 for Option Period 3 (9/26/2025-9/25/2026) CLIN 4001 for Option Period 4 (9/26/2026-9/25/2027), and CLIN 5001 for Option Period 5 (6 month extension 9/26/2027-3/26/2028). Period of Performance breakout table by PoP is available in worksheet tab "CISS FBLR (Base & FLEX)" | Total ODC Dollars: | $ 5,642,500.00 | $ 5,811,775.00 | $ 5,986,128.25 | $ 6,165,712.10 | $ 6,350,683.47 | $ 17,440,403.25 | ||
| 1 | Materials | $ 3,650,000.00 | $ 3,759,500.00 | $ 3,872,285.00 | $ 3,988,453.55 | $ 4,108,107.16 | $ 11,281,785.00 | Gov't Provided Non-Proposed Cost | |
| 2 | Travel | $ 1,788,500.00 | $ 1,842,155.00 | $ 1,897,419.65 | $ 1,954,342.24 | $ 2,012,972.51 | $ 5,528,074.65 | Gov't Provided Non-Proposed Cost | |
| 3 | Miscellaneous ODC | $ 204,000.00 | $ 210,120.00 | $ 216,423.60 | $ 222,916.31 | $ 229,603.80 | $ 630,543.60 | Gov't Provided Non-Proposed Cost |
Refer to RFP section B.1.5 Non-Proposed Other Direct Costs (ODCs) Values for more information.
&"Arial,Regular"&12 SMASS IV 80KSC022R0010 &"Arial,Regular"&12BASIC PRICE TEMPLATE &"Arial,Regular"&12ATTACHMENT L-04
&P of &N
CISS Base & FLEX Total Price
| CISS - Total Hours and Price, by CLIN and Period of Performance | ||
| Pricing Elements | ||
| (Fully Burdened thru Profit) | Base Period |
(CLIN 0001)
9/25/2022-9/24/2023 Option Period 1
(CLIN 1001)
9/25/2023-9/24/2024 Option Period 2
(CLIN 2001)
9/25/2024-9/24/2025 Option Period 3
(CLIN 3001)
9/25/2025-9/24/2026 Option Period 4
(CLIN 4001)
| 9/25/2026-9/24/2027 | Total | ||||||||
| BASE | Total Labor Hours | 7,680 | 7,680 | 7,680 | 7,680 | 7,680 | 7,680 | ||
| Total Labor Dollars | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| ODC - Total Dollars | $ 5,642,500.00 | $ 5,811,775.00 | $ 5,986,128.25 | $ 6,165,712.10 | $ 6,350,683.47 | $ 29,956,798.82 | |||
| FLEX | Gov't provided BEQ Hours | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | 4,000 | ||
| FLEX Labor Dollars | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total BASE Labor and ODC Dollars | $ 5,642,500.00 | $ 5,811,775.00 | $ 5,986,128.25 | $ 6,165,712.10 | $ 6,350,683.47 | $ 6,350,683.47 | |||
| Total FLEX Labor Dollars | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| Total Price (All Labor & Non-Labor) | $ 5,642,500.00 | $ 5,811,775.00 | $ 5,986,128.25 | $ 6,165,712.10 | $ 6,350,683.47 | $ 6,350,683.47 |
| CISS - Fully Burdened Labor Rate-thru Profit for Base Contract and FLEX | |
| Offeror Labor Classification Title | Base Period |
Fully Burdened Labor Rate-thru Profit (CLIN 0001) Option Period 1 Fully Burdened Labor Rate-thru Profit (CLIN 1001) Option Period 2 Fully Burdened Labor Rate-thru Profit (CLIN 2001) Option Period 3 Fully Burdened Labor Rate-thru Profit (CLIN 3001) Option Period 4 Fully Burdened Labor Rate-thru Profit
(CLIN 4001)
| Program Manager | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Logistics Technician | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Cable Installation Technician-Junior (O&M) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Cable Installation Technician-Senior (O&M) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
&"Arial,Regular"&12 SMASS IV 80KSC022R0010 &"Arial,Regular"&12BASIC PRICE TEMPLATE &"Arial,Regular"&12ATTACHMENT L-04
&P of &N
File details come from the government source that posted it. Updated .