NOVASTAR L-3 Professional Employee Compensation.xlsx

XLSX spreadsheet 54 KB Posted

Attached to
NOVASTAR DRAFT RFP Federal contract opportunity
Solicitation number
FA860421RB007
Issued by
Department of the Air Force Materiel Command Lifecycle Management Center Wright Patterson Air Force Base

About this file

This spreadsheet template is for proposing professional employee compensation rates on the NOVASTAR multiple award contract solicitation from the Department of the Air Force Materiel Command Lifecycle Management Center. Offerors must submit rates for on-site government and off-site contractor labor categories for each calendar year from 2022 to 2032 using the provided exhibits. Exhibit A will automatically populate from detailed rate information in Exhibit B, where offerors must specify prime and subcontractor direct labor rates, fringe rates, and totals for each category. The solicitation seeks proposals for a $4.7 billion, 10-year IDIQ contract with a period of performance from 2022 through 2032 to be awarded to up to five small businesses as total set-asides. Feedback on the draft request for proposal is due by April 14, 2021, with proposal access requests due by April 23, 2021 to reserve space at NASIC facilities.

View the file

Other files for this federal contract opportunity

Show all 16

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

TOC

TABLE OF CONTENTS

Exhibit ALabor Rates
Exhibit BLabor Rates DetailFigure B-1 and B-2

GENERAL INSTRUCTIONS

REMINDER: This spreadsheet only applies to Professional Employees as defined in 29 CFR 541.300

DO NOT ENTER DATA INTO GRAY-SHADED CELLS THROUGHOUT THE ENTIRE SPREADSHEET FILE.

(a) It is the Offeror's responsibility to ensure that all formulas are traceable and correct.

(b) Instructions are provided for each Exhibit. These instructions are to be applied only to the Exhibit in which they appear.

(c) The Calendar Year (CY) begins 1 January and ends 31 December.

(d) All rates shall be submitted in Then-Year (escalated) dollars.

(e) The Offeror is permitted to add Worksheets (Tabs) to this Workbook to perform intermediary calculations.

(f) The Offeror shall not include links to outside workbooks/source documents anywhere in this template.

(g) The Offeror shall not hide tabs, formulas, or rows/columns within this template.

A_Labor Rates Summary

EXHIBIT A: LABOR RATES

Labor CategoryRate per CY -
Contractor Site (Location)Rate per CY -

Government Site (Location)

CY22CY23CY24CY25CY26CY27CY28CY29CY30CY31CY32CY22CY23CY24CY25CY26CY27CY28CY29CY30CY31CY32
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-P$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
Labor Category-S$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
Labor Category-S$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
Labor Category-S$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
Labor Category-S$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
Labor Category-S$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
Labor Category-S$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
Labor Category-S$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
Labor Category-S$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
Labor Category-S$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

&F &P of &N &A

Exhibit A Description: Offeror's proposed labor rates for Government (on-site) and Contractor (off-site) facilities. Note this Exhibit "A " automatically populates Offeror's inputs from another worksheet tab (Exhibit B) embedded in this spreadsheet; thus no entries necessary as all cells are shaded-gray.

Exhibit A Instructions:

DO NOT ENTER DATA INTO GRAY-SHADED CELLS.

(a ) This spreadsheet will capture labor rates (direct rate + fringe) for each professional labor category contained in the proposal. Differentiate between government site and contractor site labor rates, if applicable.

(b) The Offeror is authorized to insert rows to include additional labor categories if required.

(c) It is the Offeror's responsibility to ensure that all formulas are traceable and correct.

B_Labor Rates Detail

EXHIBIT B: LABOR RATES DETAIL

Figure B-1: Detailed Labor Rates (Contractor Site) for Calendar Year (CY)

Labor CategoryRate per CY -
Contractor Site (Location)Rate per CY -
Contractor Site (Location)Rate per CY -
Contractor Site (Location)Rate per CY -
Contractor Site (Location)Rate per CY -
Contractor Site (Location)Rate per CY -
Contractor Site (Location)Rate per CY -
Contractor Site (Location)Rate per CY -
Contractor Site (Location)Rate per CY -
Contractor Site (Location)Rate per CY -
Contractor Site (Location)Rate per CY -

Contractor Site (Location)

CY22CY23CY24CY25CY26CY27CY28CY29CY30CY31CY32
Prime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotal
Indirect Percentages, (e.g. Fringe = 38%)N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00

Figure B-2: Detailed Labor Rates (Government Site) for Calendar Year (CY)

Labor CategoryRate per CY -
Government Site (Location)Rate per CY -
Government Site (Location)Rate per CY -
Government Site (Location)Rate per CY -
Government Site (Location)Rate per CY -
Government Site (Location)Rate per CY -
Government Site (Location)Rate per CY -
Government Site (Location)Rate per CY -
Government Site (Location)Rate per CY -
Government Site (Location)Rate per CY -
Government Site (Location)Rate per CY -

Government Site (Location)

CY22CY23CY24CY25CY26CY27CY28CY29CY30CY31CY32
Prime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotalPrime (P) or Subcontractor (S) RateRateFringeTotal
Indirect Percentages, (e.g. Fringe = 38%)N/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/AN/A
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-PP$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00P$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00
Labor Category-SS$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00S$0.00

&F &P of &N &A

Exhibit B Description: Prime and Subcontractor proposed labor rates for both Government (on-site) and Contractor (off-site) facilities identified by Rate and Fringe.

Exhibit B Instructions:

DO NOT ENTER DATA INTO GRAY-SHADED CELLS.

(a) Provide labor rate information for each labor category contained in the proposal. Differentiate between Contractor Site (off-site) and Government Site (on-site) labor rates in Figures B-1 and B-2.

(b) Differentiate between prime and subcontractor rates where appropriate. The prime contractor may add additional worksheets to perform intermediary calculations and incorporate subcontractor labor rates. Those subcontractor labor rates should roll up to the Labor Category rows by CY on this worksheet.

(c) The Offeror is authorized to insert rows to include additional labor categories if required.

(d) It is the Offeror's responsibility to ensure that all formulas are traceable and correct.

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