Attachment F3 NFSC Subcontractor Price Template.xlsx
XLSX spreadsheet 115 KB Posted
- Attached to
- NASA Fire Services Contract (NFSC) Federal contract opportunity
- Solicitation number
- 80KSC021R0026
About this file
This document contains a template and instructions for subcontractors to provide pricing details for the NASA Fire Services Contract (NFSC). The template requires subcontractors to input labor hours, rates, and pricing by labor category and location for each base year and option period. Labor categories include positions such as firefighter, EMT, and fire chief. Locations include Ames Research Center, Kennedy Space Center, Stennis Space Center, Wallops Flight Facility, and White Sands Test Facility. Subcontractors must also calculate fully burdened hourly rates and total pricing. The completed template is to be submitted electronically to the prime contractor for inclusion in its NFSC proposal. The overall NFSC is for fire services at multiple NASA facilities over an potential eight-year period from fiscal year 2022 through fiscal year 2029.
View the file
Other files for this federal contract opportunity
Show all 17
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
80KSC021R0026
NASA FIRE SERVICES CONTRACT (NFSC)
ATTACHMENT - F3
SUBCONTRACTOR PRICE
PROPOSED TEMPLATE
Instructions NASA Fire Services Contract (NFSC) Pricing Template: Subcontractor Direct Labor Hours and Rates
Spreadsheet Completion Instructions:
NASA Fire Services Contract (NFSC) RFP 80KSC021R0026, F.6.3 Volume 3 - Price, contains the general pricing instructions. The subcontractor pricing template instructions listed below are more specific to assist the subcontractor in completing worksheet/tab "Sub Hours & Labor Rate Details".
The table on worksheet tab "Sub Hours & Labor Rate Details" provides 50 lines (rows) for data entry, should the Subcontractor require more rows of data, they should modify the table under worksheet tab "Sub Hours & Labor Rate Details".
| The requested information, to be provided below, includes: |
| Column A, provide Subcontractor Name in Cell A4, subsequent cells below A4 will auto-populate. |
| Column B, requires input of the Subcontractor's Labor Classification Title. |
| Column C, requires the selection of the Equivalent Government Labor Classification via pull down menu selection. |
| Column D, requires the selection of the applicable NASA Location Name via pull down menu selection. |
| Column E, requires the selection of the appropriate Performance Work Statement (PWS) via pull down menu selection. |
| Columns F, R, AD, AP, BB, BN, BZ, and CL requires input of the proposed Hours for each Subcontractor Labor Classification as applicable. |
| Columns G, S, AE, AQ, BC, BO, CA and CM requires input of the proposed Base Hourly rate, for each Subcontractor Labor Classification as applicable. |
| Columns H, T, AF, AR, BD, BP, CB and CN require input for Fringe Benefits dollars, for each proposed base labor rate, on an hourly basis. |
| Columns I, U, AG, AS, BE, BQ, CC, and CO require inputs for Indirect and Profit dollars, for each proposed base labor rate, on an hourly basis. |
| Columns J, V, AH, AT, BF, BR, CD and CP requires the calculation of a fully burdened Straight Time hourly labor rate, which the subcontractor is responsible to develop. |
| Columns K, W, AI, AU, BG, BS, CE and CQ requires the calculation of a fully burdened Over Time hourly labor rate, which the subcontractor is responsible to develop. |
| Columns L, X, AJ, AV, BH, BT, CF and CR requires the calculation of a fully burdened Double Time hourly labor rate, which the subcontractor is responsible to develop. |
| Columns M, Y, AK, AW, BI, BU, CG and CS requires the calculation of Total Straight Time Labor Dollars (Fully Burdened thru Profit), which the subcontractor is responsible to develop. |
| Columns N, Z, AL, AX, BJ, BV, CH and CT requires the calculation of Total Over Time Labor Dollars (Fully Burdened thru Profit), which the subcontractor is responsible to develop. |
| Columns O, AA, AM, AY, BK, BW, CI and CU requires the calculation of Total Double Time Labor Dollars (Fully Burdened thru Profit), which the subcontractor is responsible to develop. |
| Columns P, AB, AN, AZ, BL, BX, CJ and CV requires the calculation of a Grand Total of Fully Burdened (Thru Profit) Labor Dollars plus any fully burdened (Thru Profit) Non-Labor Dollars (if applicable and to be estimated by the Subcontractor), which the subcontractor is responsible to develop. |
Subcontractor is required to submit Grand Total Hours and Grand Total Labor Dollars (Fully Burdened Thru Profit for Labor & Non-Labor, as applicable), by Government Fiscal Year, to the Prime Contractor. The Prime Contractor will include this information in its proposal submittal to the Government. Grand Total labor hours can be found in Columns F, R, AD, AP, BB, BN, BZ, and CL, which will be used to populate the Offeror's proposed pricing template for all GFY Direct Labor tabs. The total hours for both subcontractor and prime will be verified to the Government Minimum labor hours. Grand Total Labor Dollars (Fully Burdened thru Profit for Labor & Non-Labor, as applicable) can be found in Cells P55, AB55, AN55, AZ55, BL55, BX55, CJ55, and CV55.
Note the print range has been initially set to cover all fifty lines of data. No additional action is required by the Subcontractor as this file is to be submitted to the Government in electronic format only. (A hard copy submission is not required by the Government). Should the data provided herein be proprietary to the Subcontractor and not to be shared with the Prime Contractor, Submittal of this data file (electronic format only) is to be provided in a double sealed envelope as part of the Prime Contractor's submittal to the Government. Alternatively, this data can be submitted directly to the NASA Contacting Officer, if the Subcontractor so chooses.
This workbook contains a hidden worksheet/tab titled "Drop Down List" that is used for the pull down menus for the Equivalent Government Labor Classification list and the PWS list in tab "Sub Hours & Labor Rate Details". To make sure that the pull down menus work properly, please do not modify or alter the table data in the "Drop Down List" tab.
| The NFSC Period of Performance (POP) Table below is provided to inform the offerors of the POP for each location. This information will prove useful in the development of the offeror's proposal submittal to the Government. | |||||||||
| NFSC Period of Performance | |||||||||
| NASA | Base Period | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | Option 6 | Contract Total Months | |
| GFY 22 | GFY 23 | GFY 24 | GFY 25 | GFY 26 | GFY 27 | GFY 28 | GFY 29 | ||
| Location | 10 months | 1 year | 1 year | 1 year | 1 year | 1 year | 1 year | 1 year | |
| Ames Research Center (ARC) | 10/1/22 | 10/1/23 | 10/1/24 | 10/1/25 | 10/1/26 | 10/1/27 | 10/1/28 | ||
| 9/30/23 | 9/30/24 | 9/30/25 | 9/30/26 | 9/30/27 | 9/30/28 | 9/30/29 | |||
| 12 | 12 | 12 | 12 | 12 | 12 | 12 | 84 | ||
| Kennedy Space Center (KSC) | 10/1/22 | 10/1/23 | 10/1/24 | 10/1/25 | 10/1/26 | 10/1/27 | 10/1/28 | ||
| 9/30/23 | 9/30/24 | 9/30/25 | 9/30/26 | 9/30/27 | 9/30/28 | 9/30/29 | |||
| 12 | 12 | 12 | 12 | 12 | 12 | 12 | 84 | ||
| Stennis Space Center (SSC) | 7/1/25 | 10/1/25 | 10/1/26 | 10/1/27 | 10/1/28 | ||||
| 9/30/25 | 9/30/26 | 9/30/27 | 9/30/28 | 9/30/29 | |||||
| 3 | 12 | 12 | 12 | 12 | 51 | ||||
| Wallops Flight Facility (WFF) | 12/1/21 | 10/1/22 | 10/1/23 | 10/1/24 | 10/1/25 | 10/1/26 | 10/1/27 | 10/1/28 | |
| 9/30/22 | 9/30/23 | 9/30/24 | 9/30/25 | 9/30/26 | 9/30/27 | 9/30/28 | 9/30/29 | ||
| 10 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 94 | |
| White Sands Test Facility (WSTF) | 10/1/22 | 10/1/23 | 10/1/24 | 10/1/25 | 10/1/26 | 10/1/27 | 10/1/28 | ||
| 9/30/23 | 9/30/24 | 9/30/25 | 9/30/26 | 9/30/27 | 9/30/28 | 9/30/29 | |||
| 12 | 12 | 12 | 12 | 12 | 12 | 12 | 84 |
&"Times New Roman,Regular"&12
Drop Down List
| DO NOT MODIFY or ALTER TABLE DATA BELOW | DO NOT MODIFY or ALTER TABLE DATA BELOW | |
| List of Government DL Categories | PWS List | Performance Work Statement (PWS) List |
| ARC - Site Manager / Fire Chief | 1.0 | 1.0 PROGRAM MANAGEMENT |
| ARC - Fire Prevention Officer | 1.1 | 1.1 BUSINESS MANAGEMENT |
| ARC - Fire Fighter/Captain | 1.2 | 1.2 SAFETY AND HEALTH |
| ARC - Fire Fighter/Captain (ARFF) | 1.3 | 1.3 QUALITY PLAN |
| ARC - Firefighter/EMT | 1.4 | 1.4 ENVIRONMENTAL MANAGEMENT |
| ARC - Firefighter/EMT (ARFF) | 1.5 | 1.5 INFORMATION TECHNOLOGY (IT) |
| ARC - Firefighter/Driver | 1.6 | 1.6 WORK MANAGEMENT |
| ARC - Firefighter/Driver (ARFF) | 1.7 | 1.7 RECORDS MANAGEMENT |
| ARC - Battalion Chief Operations | 1.8 | 1.8 VEHICLE MANAGEMENT |
| ARC - Firefighter/Paramedic (PrePriceOpt 1) | 2.0 | 2.0 FIRE SERVICES |
| ARC - Firefighter/EMT (PrePriceOpt 2) | 2.1 | 2.1 FIRE OPERATIONS AND FIRE FIGHTING |
| ARC - Battalion Chief Training/Safety (PrepricedOpt 3) | 2.2 | 2.2 EMERGENCY MEDICAL SERVICES |
| KSC - Contract Administrative Support | 2.3 | 2.3 FIRE OPERATIONS SAFETY |
| KSC - Contract Manager | 2.4 | 2.4 FIRE SERVICES TRAINING |
| KSC - Site Manager / Fire Chief | 2.5 | 2.5 FIRE PREVENTION |
| KSC - Battalion Chief - Station #1 | 2.6 | 2.6 FIRE PROTECTION PROGRAM |
| KSC - Firefighter/Lieutenant - Station #1 | 2.7 | 2.7 FIRE INVESTIGATION |
| KSC - Firefighter/Driver - Station #1 | 2.8 | 2.8 FIRE SERVICES PERSONNEL QUALIFICATIONS |
| KSC - Firefighter - Station #1 | ||
| KSC - Firefighter/Paramedic - Station #1 | ||
| KSC - Assistant Chief Operation - Station #2 | ||
| KSC - Battalion Chief of Operation - Station #2 | ||
| KSC - Firefighter/Lieutenant - Station #2 | ||
| KSC - Firefighter/Driver - Station #2 | ||
| KSC - Firefighter - Station #2 | ||
| KSC - Firefighter/Paramedic - Station #2 | ||
| KSC - Assistant Chief of Training | ||
| KSC - Battalion Chief - Fire Instructor | ||
| KSC - Assistant Chief/Fire Prevention | ||
| KSC - Fire Prevention Specialist - Fire Inspector | ||
| KSC - Lead Fire Protection Specialist | ||
| KSC - Fire Protection Specialist | ||
| KSC - Deputy Fire Chief | ||
| KSC - Fire Support Specialist | ||
| KSC - Site Administrative Support | ||
| KSC - Assistant Chief of EMS/Safety | ||
| KSC - Firefighter/Lieutenant - Station #2 (PrePriceOpt 1) | ||
| KSC -Firefighter/Lieutenant - Station #3 (PrePriceOpt 2) | ||
| KSC -Firefighter/Driver - Station #3 (PrePriceOpt 2) | ||
| KSC -Firefighter - Station #3 (PrePriceOpt 2) | ||
| SSC - Firefighter | ||
| SSC - Captains - Shift A | ||
| SSC - Captains - Shift B | ||
| SSC - Lieutenants | ||
| SSC - Site Manager / Fire Chief | ||
| SSC - Firefighter/EMT (PrePriceOpt 1) | ||
| SSC - Firefighter (PrePriceOpt 2) | ||
| SSC - Firefighter/Paramedic (PrePriceOpt 3) | ||
| SSC - Fire Inspector (PrePriceOpt 4) | ||
| SSC - Fire Prevention (PrePriceOpt 5) | ||
| SSC - Fire Protection Specialist (PrePriceOpt 5) | ||
| WFF - Fire Fighter/ALS1 - Station 1 - A, B, C Shift | ||
| WFF - Fire Fighter/EMT1 - Station 1 - A, B, C Shift | ||
| WFF - Captain (ST) - Station 1 - A,B,C Shifts | ||
| WFF - Fire Fighter/EMT1 - Station 2 - D Shift | ||
| WFF - Fire Fighter/ALS1 - Station 2 - D Shift | ||
| WFF - Fire Fighter/EMT1 - Station 2 - E Shift | ||
| WFF - Fire Fighter/ALS1 - Station 2 - E Shift | ||
| WFF - Lieutenant - Station 2 | ||
| WFF - Site Manager / Fire Chief | ||
| WFF - Firefighter ALS1 (PrePriceOpt 1) | ||
| WFF - Firefighter EMT1 (PrePriceOpt 1) | ||
| WFF - Deputy Fire Chief (PrePriceOpt 2) | ||
| WFF - Assistant Chief of Fire Prevention (PrePriceOpt 3) | ||
| WSTF - Site Manager / Fire Chief | ||
| WSTF - Deputy Fire Chief | ||
| WSTF - Firefighter Lieutenant | ||
| WSTF - Firefighter/Paramedic | ||
| WSTF - Firefighter/Driver | ||
| WSTF - Firefighter | ||
| WSTF - Firefighter (PrePriceOpt 1) |
Sub Hours & Labor Rate Details
| NASA Fire Services Contract (NFSC) Pricing Template: Subcontractor Direct Labor Hours and Rates | ||||||||||||
| Government Fiscal Year 2022 (Base Period Year 1) | Government Fiscal Year 2023 (Base Period Year 2) | Government Fiscal Year 2024 (Option 1) | Government Fiscal Year 2025 (Option 2) | Government Fiscal Year 2026 (Option 3) | Government Fiscal Year 2027 (Option 4) | Government Fiscal Year 2028 (Option 5) | Government Fiscal Year 2029 (Option 6) | |||||
| Subcontractor | ||||||||||||
| Name | Subcontractor | |||||||||||
| Labor Classification Title | Equivalent Government | |||||||||||
| Labor Classification Title | NASA Location Name | PWS # | Proposed Hours | Base |
Labor Rate per Hour Fringe Benefit Dollars
| per Hour | Indirects & Profit Dollars |
| per Hour | Fully Burdened |
Labor Rate per Hour thru Profit (Straight Time) Fully Burdened Labor Rate per Hour thru Profit (Over Time) Fully Burdened Labor Rate per Hour thru Profit (Double Time) Total Labor Dollars Fully Burdened (Straight Time) Total Labor Dollars Fully Burdened (Over Time) Total Labor Dollars Fully Burdened (Double Time) Grand Total Labor Dollars Fully Burdened (S/T+O/T+D/T) Plus Any Non-Labor Dollars Fully Burdened (if Applicable) Proposed Hours Base Labor Rate per Hour Fringe Benefit Dollars
| per Hour | Indirects & Profit Dollars |
| per Hour | Fully Burdened |
Labor Rate per Hour thru Profit (Straight Time) Fully Burdened Labor Rate per Hour thru Profit (Over Time) Fully Burdened Labor Rate per Hour thru Profit (Double Time) Total Labor Dollars Fully Burdened (Straight Time) Total Labor Dollars Fully Burdened (Over Time) Total Labor Dollars Fully Burdened (Double Time) Grand Total Labor Dollars Fully Burdened (S/T+O/T+D/T) Plus Any Non-Labor Dollars Fully Burdened (if Applicable) Proposed Hours Base Labor Rate per Hour Fringe Benefit Dollars
| per Hour | Indirects & Profit Dollars |
| per Hour | Fully Burdened |
Labor Rate per Hour thru Profit (Straight Time) Fully Burdened Labor Rate per Hour thru Profit (Over Time) Fully Burdened Labor Rate per Hour thru Profit (Double Time) Total Labor Dollars Fully Burdened (Straight Time) Total Labor Dollars Fully Burdened (Over Time) Total Labor Dollars Fully Burdened (Double Time) Grand Total Labor Dollars Fully Burdened (S/T+O/T+D/T) Plus Any Non-Labor Dollars Fully Burdened (if Applicable) Proposed Hours Base Labor Rate per Hour Fringe Benefit Dollars
| per Hour | Indirects & Profit Dollars |
| per Hour | Fully Burdened |
Labor Rate per Hour thru Profit (Straight Time) Fully Burdened Labor Rate per Hour thru Profit (Over Time) Fully Burdened Labor Rate per Hour thru Profit (Double Time) Total Labor Dollars Fully Burdened (Straight Time) Total Labor Dollars Fully Burdened (Over Time) Total Labor Dollars Fully Burdened (Double Time) Grand Total Labor Dollars Fully Burdened (S/T+O/T+D/T) Plus Any Non-Labor Dollars Fully Burdened (if Applicable) Proposed Hours Base Labor Rate per Hour Fringe Benefit Dollars
| per Hour | Indirects & Profit Dollars |
| per Hour | Fully Burdened |
Labor Rate per Hour thru Profit (Straight Time) Fully Burdened Labor Rate per Hour thru Profit (Over Time) Fully Burdened Labor Rate per Hour thru Profit (Double Time) Total Labor Dollars Fully Burdened (Straight Time) Total Labor Dollars Fully Burdened (Over Time) Total Labor Dollars Fully Burdened (Double Time) Grand Total Labor Dollars Fully Burdened (S/T+O/T+D/T) Plus Any Non-Labor Dollars Fully Burdened (if Applicable) Proposed Hours Base Labor Rate per Hour Fringe Benefit Dollars
| per Hour | Indirects & Profit Dollars |
| per Hour | Fully Burdened |
Labor Rate per Hour thru Profit (Straight Time) Fully Burdened Labor Rate per Hour thru Profit (Over Time) Fully Burdened Labor Rate per Hour thru Profit (Double Time) Total Labor Dollars Fully Burdened (Straight Time) Total Labor Dollars Fully Burdened (Over Time) Total Labor Dollars Fully Burdened (Double Time) Grand Total Labor Dollars Fully Burdened (S/T+O/T+D/T) Plus Any Non-Labor Dollars Fully Burdened (if Applicable) Proposed Hours Base Labor Rate per Hour Fringe Benefit Dollars
| per Hour | Indirects & Profit Dollars |
| per Hour | Fully Burdened |
Labor Rate per Hour thru Profit (Straight Time) Fully Burdened Labor Rate per Hour thru Profit (Over Time) Fully Burdened Labor Rate per Hour thru Profit (Double Time) Total Labor Dollars Fully Burdened (Straight Time) Total Labor Dollars Fully Burdened (Over Time) Total Labor Dollars Fully Burdened (Double Time) Grand Total Labor Dollars Fully Burdened (S/T+O/T+D/T) Plus Any Non-Labor Dollars Fully Burdened (if Applicable) Proposed Hours Base Labor Rate per Hour Fringe Benefit Dollars
| per Hour | Indirects & Profit Dollars |
| per Hour | Fully Burdened |
Labor Rate per Hour thru Profit (Straight Time) Fully Burdened Labor Rate per Hour thru Profit (Over Time) Fully Burdened Labor Rate per Hour thru Profit (Double Time) Total Labor Dollars Fully Burdened (Straight Time) Total Labor Dollars Fully Burdened (Over Time) Total Labor Dollars Fully Burdened (Double Time) Grand Total Labor Dollars Fully Burdened (S/T+O/T+D/T) Plus Any Non-Labor Dollars Fully Burdened (if Applicable)
| $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 | ||||||||||||||||
| $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 | ||||||||||||||||
| $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 | $0.00 | - 0 | $0.00 | - 0 | $0.00 | - 0 | $0.00 | - 0 | $0.00 | - 0 | $0.00 | - 0 | $0.00 | - 0 | $0.00 |
&"Times New Roman,Regular"&12&KFF0000 &"Times New Roman,Regular"&12
&"Times New Roman,Regular"&12 &"Times New Roman,Regular"&12
File details come from the government source that posted it. Updated .