NCS Attachment F-5 Subcontractor Fully Burdened Labor Rates Template.xlsx

XLSX spreadsheet 214 KB Posted

Attached to
80KSC022R0012 - NASA Communication Services (NCS), Solicitation Release
Solicitation number
80KSC022R0012
Issued by

About this file

This file contains templates and instructions for a subcontractor to submit labor rates and pricing information in response to solicitation 80KSC022R0012 for NASA Communication Services. The templates require the subcontractor to provide fully burdened labor rates by labor category, including straight time base rates, locality adjustments by NASA center, fringe rates, and indirect and profit rates, for each year of the potential 5-year contract. The templates also include instructions for calculating productive hours by year. This information will allow the prime contractor to incorporate the subcontractor's pricing into its proposal to NASA to provide communication services across all NASA centers and locations.

View the file

Other files

Show all 20

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

Cover Page

Solicitation 80KSC022R0012
ATTACHMENT F-5

Subcontractor Fully Burdened Labor Rates Template

FOR

NASA Communications Services

(NCS)

Instructions

NCS GENERAL PRICING INFORMATION
A. Subcontractors (SubK) are required to complete and submit: (a) Attachment F-5 Subcontractor Fully Burdened Labor Rates. Subcontractors may submit their files

directly to the Government if information is deemed proprietary and not shared with the Prime.

B. Offerors are advised to review the narrative provided in the NCS RFP, Volume III, F.6.3.

C. Offerors are responsible for the mathematical accuracy of the the price and numbers in this template. The template must be completed in its entirety.

D. The Government anticipates the NCS contract to be a Firm-Fixed Price (FFP) Contract (with IDIQ FFP, LOE and T&M) with a maximum period of performance of 5 years, if all options are exercised. The Government anticipates the following Period of Performance:

Period of Performance
Base Period3/1/23-9/30/2419 Months
Option 110/1/24-02/28/2617 Months
Option 203/01/26-02/28/2712 Months
Option 303/01/27-02/28/2812 Months

Pricing Instruction by Worksheet Tab

PRODUCTIVE HOURS
Offeror’s shall fill in the applicable information requested in Green background shaded cells in this tab. The Offeror shall specify the number of productive hours per Work Year Equivalent (WYE) for each year of anticipated contract performance. Productive hour calculations should show the total number of available hours by whole-year less the total hours estimated for holidays, vacation time, sick hours, and other. WYE calculations are based on total annual available hours and should not be adjusted to reflect partial years. Specify in the notes section provided on how the hours were calculated (e.g. 2,080 available hours per year – 100 hours vacation – 40 hours sick – 80 hours holiday = 1,860 Productive Hours). Proposed uncompensated overtime would affect the calculations, since uncompensated time redefines the traditional 8 hour day and 40 hour week generally used for calculation of total available, productive and non-productive time. The Government has provided tables detailing total available productive hours for the applicable portions GFYs 2023 thru 2028. This information is provided for reference purposes only and may be used as an aid for proposal preparation purposes, as appropriate. The offeror is fully responsible for the development of its estimated productive hours (for Prime and Sub(s) as applicable) for use in its proposal submittal to the Government.
SUBK LABOR RATES (Government Fiscal Year (GFY) 23)
Offeror’s shall fill in the applicable information requested in Green background shaded cells in this tab. Further instructions are provided on the Labor Rates Tab.
SUBK LABOR RATE ESCALATION By CENTER (Labor Rate ESC. By Ctr.)
Offeror’s shall fill in the applicable information requested in Green background shaded cells in this tab. Further instructions are provided on the Labor Rates Esc. By Ctr. Tab.
SUB FULLY BURDENED LABOR RATES
Offeror’s shall fill in the applicable information requested in Green background shaded cells in this tab. Further instructions are provided on the Fully Burdened Labor Rates Tab

Productive Hours

Offeror:GFY 2023
Contract Year 1GFY 2024
Contract Year 2GFY 2025
Contract Year 3GFY 2026
Contract Year 4GFY 2027
Contract Year 5GFY (Government Fiscal Year)
Productive HoursThe Government provided Total Work Days & Hours, By Government Fiscal Year, are provided as informational only, Offerors are responsible for estimating and supporting their Annual Productive Hours as required herein. Leap Years (February 29th) are highlighted as red font in the tables below and results in 1 additional work day in GFYs 2024 and 2028.
Exempt EmployeesWORK DAYS AND WORK HOURS IN THE TABLES BELOW DO NOT TAKE INTO ACCOUNT FEDERAL HOLIDAYS. The Data represents total days and total hours available for a typical Monday thru Friday work week, for each month, for Government Fiscal Years 2023 through 2032.
GFY 2028

Contract Year 6

Detailed pricing information pertaining to this tab is provided in the "Instructions" tab "Productive Hours"Contract Yr 1 (7 mos) - GFY 2023Contract Yr 2 - GFY 2024Contract Yr 3 - GFY 2025
YearMonthDaysWork DaysWork Hrs @ 8Hr/DayYearMonthDaysWork DaysWork Hrs @ 8Hr/DayYearMonthDaysWork DaysWork Hrs @ 8Hr/Day
Notes/Calculation for Contract Year 1 (Contract starts March 1, 2023):2023MAR31231842023OCT31221762024OCT3123184
2023APR30201602023NOV30221762024NOV3021168
2023MAY31231842023DEC31211682024DEC3122176
2023JUN30221762024JAN31231842025JAN3123184
2023JUL31211682024FEB29211682025FEB2820160
2023AUG31231842024MAR31211682025MAR3121168
Notes/Calculation for Contract Year 2:2023SEP30211682024APR30221762025APR3022176
Total Work Days & Hours:15312242024MAY31231842025MAY3122176
2024JUN30201602025JUN3021168
2024JUL31231842025JUL3123184
2024AUG31221762025AUG3121168
2024SEP30211682025SEP3022176
Notes/Calculation for Contract Year 3:Total Work Days & Hours:2612088Total Work Days & Hours:2612088
Contract Yr 4 - GFY 2026Contract Yr 5 - GFY 2027Contract Yr 6 (5 Months)- GFY 2028 and Option to Extend Services (6 Months)
YearMonthDaysWork DaysWork Hrs @ 8Hr/DayYearMonthDaysWork DaysWork Hrs @ 8Hr/DayYearMonthDaysWork DaysWork Hrs @ 8Hr/Day
2025OCT31231842026OCT31221762027OCT3121168
Notes/Calculation for Contract Year 4:2025NOV30201602026NOV30211682027NOV3022176
2025DEC31231842026DEC31231842027DEC3123184
2026JAN31221762027JAN31211682028JAN3121168
2026FEB28201602027FEB28201602028FEB2921168
2026MAR31221762027MAR31231842028MAR3122176
2026APR30221762027APR30221762028APR3022176
Notes/Calculation for Contract Year 5:2026MAY31211682027MAY31211682028MAY3121168
2026JUN30221762027JUN30221762028JUN3022176
2026JUL31231842027JUL31221762028JUL3123184
2026AUG31211682027AUG31221762028AUG3122176
2026SEP30221762027SEP3022176
Total Work Days & Hours:2612088Total Work Days & Hours:2612088Total Work Days & Hours:2401920
Notes/Calculation for Contract Year 6:

Source of Data: www.workingdays.us

SubK Labor Rates (GFY 23)

Instructions: Offeror’s shall fill in the information requested in Green background shaded cells in this tab. In Cell A11 fill in the Subcontractor name. In Column B the listing of Government Labor Categories is provided (See Attachment D-6 for more information on the Government provided Labor Categories). In Column C fill in the Offeror's Labor Classification(s) which maps/crosswalks to the Government provided Labor Classification(s) in Column B. Select the applicable Labor type from the drop down in Column D (Exempt, Non Represented Non Exempt (NRNE), or Union). In Column E the offeror shall provide their standardized Straight Time Base Labor Rate. In Columns F-Q the Offeror shall propose a locality increase in the form of dollars per hour based on the location of the respective NASA center. In Columns R-AC the offeror will propose the fringe dollars per hour associated with each labor rate. In columns AD-AO the offeror will propose indirect and profit dollars per hour associated with each labor rate. Columns AP-BA add up each respective burden for each labor rate giving a labor rate for each classification at each center if the Offeror deems it necessary.

Subcontractor NameGovernment Labor ClassificationOfferor Labor ClassificationExempt/NRNE/UnionGFY 23Locality Increases ($/hr)Fringe Dollars ($/hr)Indirect & Profit Dollars ($/hr)GFY 23 Fully Burdened Labor Rates ($/hr)
Straight Time Base Labor Rate / hrArmstrong Flight Research Center (AFRC)Ames Research Center (ARC)Glenn Research Center (GRC)Goddard Space Flight Center (GSFC)NASA Headquarters (HQ)Johnson Space Center (JSC)Kennedy Space Center (KSC)Langley Research Center (LaRC)Marshall Space Flight Center (MSFC)Stennis Space Center (SSC)Wallops Flight Facility (WFF)OFFSITEArmstrong Flight Research Center (AFRC)Ames Research Center (ARC)Glenn Research Center (GRC)Goddard Space Flight Center (GSFC)NASA Headquarters (HQ)Johnson Space Center (JSC)Kennedy Space Center (KSC)Langley Research Center (LaRC)Marshall Space Flight Center (MSFC)Stennis Space Center (SSC)Wallops Flight Facility (WFF)OFFSITEArmstrong Flight Research Center (AFRC)Ames Research Center (ARC)Glenn Research Center (GRC)Goddard Space Flight Center (GSFC)NASA Headquarters (HQ)Johnson Space Center (JSC)Kennedy Space Center (KSC)Langley Research Center (LaRC)Marshall Space Flight Center (MSFC)Stennis Space Center (SSC)Wallops Flight Facility (WFF)OFFSITEArmstrong Flight Research Center (AFRC)Ames Research Center (ARC)Glenn Research Center (GRC)Goddard Space Flight Center (GSFC)NASA Headquarters (HQ)Johnson Space Center (JSC)Kennedy Space Center (KSC)Langley Research Center (LaRC)Marshall Space Flight Center (MSFC)
$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Exempt
NRNE
Union
Program Manager
Deputy Program Manager
Business Specialist I
Business Specialist II
Business Specialist III
Business Manager
Property Specialist I
Property Specialist II
Property Specialist III
Property Manager
Communication Manager
Subject Matter Expert (SME)
Communication Strategist I
Communication Strategist II
Communication Strategist III
Communication Strategist IV
Writer/Editor I
Writer/Editor II
Writer/Editor III
Writer/Editor IV
Media Specialist I
Media Specialist II
Media Specialist III
Media Specialist IV
Social Media Specialist I
Social Media Specialist II
Social Media Specialist III
Social Media Specialist IV
Event Coordinator
Event Project Manager
Graphic Designer I
Graphic Designer II
Graphic Designer III
Exhibit Technician I
Exhibit Technician II
Exhibit Technician III
Exhibit Technician IV
Exhibit and Outreach Specialist
Librarian I
Librarian II/ Metadata Librarian
Librarian III/ Full Webstack Developer
Libriarian IV
Archivist I
Archivist II
Archivist II
Archivist III
Historian I
Historian II
Historian III
Historian IV

SubK Labor Rate Esc. by CTR Instructions: Offerors are to fill in the information requested in Green background shaded cells in this tab. In cells D11:H11, Offerors are to input their proposed outyear labor rate escalation rate (%) for GFYs 24 thru 28. In the Columns D thru H, Offeror is to input their proposed locality escalation rate (%) for GFYs 24 thru 28, by NASA Center. In Columns J thru N, Offeror is to input their Fringe Rate (%) for GFYs 24 thru 28, by NASA Center. Lastly, in Columns P thru T, Offeror is to input their combination of appliable Indirect(s) and Profit (%) for GFYs 24 thru 28, by NASA Center.

Base Labor Rate Escalation by Year GFY 23 GFY 24 GFY 25 GFY 26 GFY 27 GFY 28

Burden Escalation FactorsLocality Escalation by Center (%)Fringe by Center (%)Indirect & Profit by Center (%)
NASA CenterGFY 23GFY 24GFY 25GFY 26GFY 27GFY 28GFY 23GFY 24GFY 25GFY 26GFY 27GFY 28GFY 23GFY 24GFY 25GFY 26GFY 27GFY 28
Armstrong Flight Research Center (AFRC)
Ames Research Center (ARC)
Glenn Research Center (GRC)
Goddard Space Flight Center (GSFC)
NASA Headquarters (HQ)
Johnson Space Center (JSC)
Kennedy Space Center (KSC)
Langley Research Center (LaRC)
Marshall Space Flight Center (MSFC)
Stennis Space Center (SSC)
Wallops Flight Facility (WFF)
OFFSITE

SubK Fully Burdened Labor Rates Instructions: Offeror’s shall fill in the applicable information requested in Green background shaded cells in this tab.

Government Labor ClassificationOfferor Labor ClassificationExempt/NRNE/UnionFully Burdened Labor Rates GFY 2023Fully Burdened Labor Rates GFY 2024Fully Burdened Labor Rates GFY 2025Fully Burdened Labor Rates GFY 2026
Armstrong Flight Research Center (AFRC)Ames Research Center (ARC)Glenn Research Center (GRC)Goddard Space Flight Center (GSFC)NASA Headquarters (HQ)Johnson Space Center (JSC)Kennedy Space Center (KSC)Langley Research Center (LaRC)Marshall Space Flight Center (MSFC)Stennis Space Center (SSC)Wallops Flight Facility (WFF)OFFSITEArmstrong Flight Research Center (AFRC)Ames Research Center (ARC)Glenn Research Center (GRC)Goddard Space Flight Center (GSFC)NASA Headquarters (HQ)Johnson Space Center (JSC)Kennedy Space Center (KSC)Langley Research Center (LaRC)Marshall Space Flight Center (MSFC)Stennis Space Center (SSC)Wallops Flight Facility (WFF)OFFSITEArmstrong Flight Research Center (AFRC)Ames Research Center (ARC)Glenn Research Center (GRC)Goddard Space Flight Center (GSFC)NASA Headquarters (HQ)Johnson Space Center (JSC)Kennedy Space Center (KSC)Langley Research Center (LaRC)Marshall Space Flight Center (MSFC)Stennis Space Center (SSC)Wallops Flight Facility (WFF)OFFSITEArmstrong Flight Research Center (AFRC)Ames Research Center (ARC)Glenn Research Center (GRC)Goddard Space Flight Center (GSFC)NASA Headquarters (HQ)Johnson Space Center (JSC)Kennedy Space Center (KSC)Langley Research Center (LaRC)Marshall Space Flight Center (MSFC)Stennis Space Center (SSC)Wallops Flight Facility (WFF)

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 .