L-6 Contract Cost Summary.xlsx

XLSX spreadsheet 45 KB Posted

Attached to
internal Contractor Support Services (iCSS) Special Notice - Draft RFP and pre-solicitation conference
Solicitation number
N6134025R0004-0003
Issued by

About this file

Written by GovTribe AI ·

This is a Microsoft Excel cost summary template (Attachment L-6) for the internal Contractor Support Services (iCSS) solicitation N6134025R0004 for the Naval Air Systems Command. The template requires contractors to provide detailed labor cost breakdowns for a 5-year base period plus 6-month FAR 52.217-8 option period, with work to be performed in Orlando, FL. The spreadsheet includes tabs for instructions, labor categories/rates, cost summaries, and CLIN breakdowns.

The template requires detailed input of employee names, labor categories (mapped to specific BLS SOC codes), work location, full/part-time status, work site designation, indirect rates, subcontractor costs, handling fees, and ODCs like travel. It covers 57 distinct labor categories across multiple disciplines including engineering, IT, management, and administrative roles at junior, journeyman and senior levels. The CLIN structure indicates requirements for mobilization, labor (with specified hours per year ranging from ~407,000 to ~421,000), travel, and technical data deliverables. The template must accommodate prime contractor costs as well as subcontractor/joint venture team member costs, with specific instructions for each.

View the file

Other files

File Type Posted
L-2 Offeror Workshare Summary Table (1).xlsx XLSX spreadsheet
L-4 PP Information Form.xlsx XLSX spreadsheet
J-3 NAWCTSD 4330_60 Data Item TransmittalAcceptance Rejection Form (2).pdf PDF
Attachment J-5 Wage Determination 2015-4553 Rev 27 (6).pdf PDF
J-2 Planning DD 254.pdf PDF
L-5 CPAQ (1).docx DOCX document
L-7 iCSS Minimum Labor Wage Rate (1).xlsx XLSX spreadsheet
L-3 Relevant Contract Summary Table (1).xlsx XLSX spreadsheet
J-2 2013OPSECANNEX.pdf PDF
L-1 iCSS Solicitation Question and Answer Form (2).xlsx XLSX spreadsheet
N6134025R0004_iCSS Draft RFP.pdf PDF
Attachment J-4 iCSS_Surveillance Activity Checklist_N6134025R0004 (1).docx DOCX document
Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Instructions

Instructions for Prime Contractor:
1In the Cost Summary Spreadsheet, enter the Prime offeror's name into cell A3.
2Enter all prime employee names in Column A (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas.
3Enter all prime labor categories in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column C, the Offeror should insert the title of the labor category it will be utilizing. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
4In column D, use Orlando as the work location that the contractor will be working at in accordance with the T11. Note, the Location-Labor Cat Spreadsheet can be referenced to show how the T11 locality lines up with the SOW.
5Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor or JV Team Member)
6The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
7All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
8All dollar figures shall be carried out no further than two decimal places.
9In column E, f identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
10In column F, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces.
11Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
12For each subcontractor, enter the subcontractor name, total hours, and total amount for each period of performance.
13Please note if more subcontractors or JV Team Members are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
14The prime should insert the subcontractor handling charge, if any.
15The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
16The prime should insert the fixed fee rate it is applying to the subcontractor and JV Team Member labor, if any.
17Under Other Direct Costs, the prime contractor should separate by Travel, Material and NMCI as applicable.
18Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions.
19On the Summary tab, break out all costs by CLIN. Ensure that the total costs of the CLINs match Section B and the total on the Cost Summary Spreadsheet. Add rows and columns as needed to match section B. All cell formulas are contractor inputs.
20When submitting this file, the instructions may be deleted.

Instructions for Subcontractors and JV Team Members:

tc={B4BF191E-6810-43A8-AF81-529A65191D2E}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

can the JV team members mirror these instructions or would they need to be different.

1Enter Prime offeror name into cell A3.
Replace Prime Contractor with Subcontractor or JV Team Member in A7, A8, A13, and A20.
2Enter all subcontractor or JV Team Member employee names in Column A (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas.
3Enter all subcontractor or JV Team Member labor categories in Column C (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column C, the Offeror should insert the title of the labor category it will be utilizing. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of hours and labor categories. Also, labor categories with more than one person providing service shall be listed multiple times for each person performing work. For example, if the offeror proposes four Senior Analysts, then the labor category Senior Analyst shall be listed four times along with their applicable rates and information.
4In column D, use Orlando as the work location that the contractor will be working at in accordance with the T11. Note, the Location-Labor Cat Spreadsheet can be referenced to show how the T11 locality lines up with the SOW.
5Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor or JV Team Member)
6The worksheets of the workbook should all be formatted for printing on letter-size paper, without requiring "adjustments." It may be formatted for either landscape or portrait. DO NOT FORMAT FOR LEGAL SIZE PAPER.
7All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
8All dollar figures shall be carried out no further than two decimal places.
9In column D, f identify for the specific labor category individual whether they are full-time on this acquisition or part-time. Enter "F" for full-time or "P" for part-time.
10In column E, the Offeror shall insert a "K" if the worker will be performing at the Contractor's facility or a "G" if it will be performing in the Government Spaces.
11Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordinly.
12For subcontractor and JV Team Members cost summary sheets, delete Rows 22-35, 44-48.
13For JV Team Members, Rows 28, 32 and 33 do not apply.

Location-Labor Cat Spreadsheet

ORLANDO, FL
Labor CategoryLevel2023 BLS SOC Code

tc={1FBF90B3-5A49-4174-AA42-0C735CB461F6}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

MOCK up a tab for each location and then place the wage rate

General and Operations ManagersSenior11-1021
General and Operations ManagersJourneyman11-1021

Public Relations Specialist Journeyman 27-3031

Administrative Services Managers Journeyman 11-3012

Facilities Managers Journeyman 11-3013

Training and Development ManagersSenior11-3131
Training and Development ManagersJourneyman11-3131
LogisticiansSenior13-1081
LogisticiansJourneyman13-1081
Project Management SpecialistsSenior13-1082
Project Management SpecialistsJourneyman13-1082

Management Analysts Journeyman 13-1111

Training and Development SpecialistsSenior13-1151
Training and Development SpecialistsJourneyman13-1151
Training and Development SpecialistsJunior13-1151
Financial Specialists, All OtherSenior13-2099
Financial Specialists, All OtherJourneyman13-2099
Financial Specialists, All OtherJunior13-2099
Operations Research AnalystsSenior15-2031
Operations Research AnalystsJourneyman15-2031
Operations Research AnalystsJunior15-2031
Drafter, All OthersSCA 30060 Drafter/CAD Operator II [Journeyman]17-3019
Drafter, All OthersSCA 30060 Drafter/CAD Operator I [Junior]17-3019
Psychologists, All OtherSenior19-3039
Psychologists, All OtherJourneyman19-3039
Psychologists, All OtherJunior19-3039
Instructional CoordinatorsSenior25-9031
Instructional CoordinatorsJourneyman25-9031
Instructional CoordinatorsJunior25-9031
Technical WriterII27-3042
Technical WriterI27-3042

Executive Secretaries and Executive Administrative Assistants Journeyman 43-6011

Legal Secretaries and Administrative Assistants Journeyman 43-6012

Secretaries and Administrative Assistants, Except Legal, Medical and Executive Journeyman 43-6014

Computer Systems AnalystsSenior15-1211
Computer Systems AnalystsJourneyman15-1211
Computer Network ArchitectsSenior15-1241
Computer Network ArchitectsJourneyman15-1241
Computer Network ArchitectsJunior15-1241
Data ScientistsSenior15-2051
Data ScientistsJourneyman15-2051
Data ScientistsJunior15-2051
Software DeveloperSenior15-1252
Software DeveloperJourneyman15-1252
Software DeveloperJunior15-1252
Software Quality Assurance Analysts and TestersSenior15-1253
Software Quality Assurance Analysts and TestersJourneyman15-1253
Aerospace EngineersSenior17-2011
Aerospace EngineersJourneyman17-2011
Electronics EngineersSenior17-2072
Electronics EngineersJourneyman17-2072
Electronics EngineersJunior17-2072
Mechanical EngineersSenior17-2141
Mechanical EngineersJourneyman17-2141
Engineers, All OtherSenior17-2199
Engineers, All OtherJourneyman17-2199
Engineers, All OtherJunior17-2199
Electrical and Electronic Engineering Technologists and TechniciansSenior17-3023
Electrical and Electronic Engineering Technologists and TechniciansJourneyman17-3023
Electrical and Electronic Engineering Technologists and TechniciansJunior17-3023
Engineering Technologist & Technician, Except Drafters, All OtherSenior17-3029
Engineering Technologist & Technician, Except Drafters, All OtherJourneyman17-3029
Engineering Technologist & Technician, Except Drafters, All OtherJunior17-3029
Industrial-Organizational PsychologistsSenior19-3032
Industrial-Organizational PsychologistsJourneyman19-3032
Industrial-Organizational PsychologistsJunior19-3032

Special Effects Artists and Animators Journeyman 27-1014

Cost Summary Spreadsheet

COST SUMMARY SPREADSHEET

Prime Offeror Name:
Subcontractor Name (if applicable):
Solicitation Number # N6134025R0004Year 1Year 2Year 3Year 4Year 5FAR 52.217-8Total for All Years
Cost ElementsGovernment Labor CategoryProposed Labor CategoryLocation - OrlandoF/PSiteRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountRateHoursAmountHoursAmount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Labor Category 100000000
Labor Category 200000000
Etc.00000000
Total Direct Labor Cost00000000
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost0000000
COM (if applicable)
Total Prime Contractor Labor Cost0000000
Subcontractor or JV Team Member Labor Cost
Subcontractor or JV Team Member proposed cost and fee
Subcontractor or JV Team Member 1
Subcontractor 2 or JV Team Member 2
Etc.
Total proposed subcontractor or JV Team Member labor cost and fee0000000
Prime contractor pass through (not including fee)
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through0

Total Labor Cost (Prime and Subcontractor or JV Team Member Labor)

Fixed Fee
Prime Contractor Fee for Prime Contractor Labor
Prime Contractor Fee for Subcontractor or JV Team Member Labor *
Total Fee (for Prime and Subcontractor or JV Team Member Labor)

Total Labor Cost Plus Fixed Fee (CPFF) 0

Increased Capacity for Labor
Subtotal Labor Increased Capacity
Subtotal Profit/Fee Increased Capacity
Total Labor Increased Capacity
Grand Subtotal Labor Cost
Grand Subtotal Labor Profit/Fee
Grand Total Labor
Other Direct Costs - Travel
Other Direct Costs (ODCs) - Travel
Any adders to ODCs such as G&A (cost only - no fee)
Sub total of ODCs
Increased Capacity for ODCs
Base for Increased Capacity ODCs
Total Increased Capacity for ODCs
Grand Total ODCs

Total CPFF all CLINs (Labor and ODCs) $ - 0

Grand Total of CPFF all CLINs

Pass Through Analysis - Total for All YearsAmountPercent
Subcontractor proposed cost and fee$0
Pass Through Amount (not including fee)$0
Prime Contractor Fee for Subcontractor Labor *$0
Total Pass Through Amount (including fee)$0ERROR:#DIV/0!
Fee Analysis - Total for All YearsAmountPercent
Prime Contractor Labor Cost$0
Fixed Fee for Labor Performed by Prime Contractor$0ERROR:#DIV/0!
*In Section B, the prime offeror fee on subcontractor price is a fee element rather than a cost element. Prime offeror fee on subcontractor price should be included in the fee column (rather than the cost column) of Section B.

Page &P &F

KTR: (name) Source Selection Information - See: FAR 2.101 and 3.104 RFP:

Fully Burdened Labor Rates

Composite Fully Burdened Rates (Exclusive of fee and regardless of provided by prime, sub or JV entity)
May 2023 BLS / OMB / SOC / NAVAIR TitleLevel2023 SOC CodeBase (FY26)

1 Nov 2025 - 31 Oct 2026 Year 2 (FY27) 1 Nov 2026 - 31 Oct 2027 Year 3 (FY28) 1 Nov 2027 - 31 Oct 2028 Year 4 (FY29) 1 Nov 2028 - 31 Oct 2029 Year 5 (FY30) 1 Nov 2029 - 31 Oct 2030 Option 1 (FY31) 1 Nov 2030 - 30 Apr 2031

General and Operations ManagersSenior11-1021
General and Operations ManagersJourneyman11-1021

Public Relations Specialist Journeyman 27-3031

Administrative Services Managers Journeyman 11-3012

Facilities Managers Journeyman 11-3013

Training and Development ManagersSenior11-3131
Training and Development ManagersJourneyman11-3131
LogisticiansSenior13-1081
LogisticiansJourneyman13-1081
Project Management SpecialistsSenior13-1082
Project Management SpecialistsJourneyman13-1082

Management Analysts Journeyman 13-1111

Training and Development SpecialistsSenior13-1151
Training and Development SpecialistsJourneyman13-1151
Training and Development SpecialistsJunior13-1151
Financial Specialists, All OtherSenior13-2099
Financial Specialists, All OtherJourneyman13-2099
Financial Specialists, All OtherJunior13-2099
Operations Research AnalystsSenior15-2031
Operations Research AnalystsJourneyman15-2031
Operations Research AnalystsJunior15-2031
Drafter, All OthersSCA 30060 Drafter/CAD Operator II [Journeyman]17-3019
Drafter, All OthersSCA 30060 Drafter/CAD Operator I [Junior]17-3019
Psychologists, All OtherSenior19-3039
Psychologists, All OtherJourneyman19-3039
Psychologists, All OtherJunior19-3039
Instructional CoordinatorsSenior25-9031
Instructional CoordinatorsJourneyman25-9031
Instructional CoordinatorsJunior25-9031
Technical WriterII27-3042
Technical WriterI27-3042

Executive Secretaries and Executive Administrative Assistants Journeyman 43-6011

Legal Secretaries and Administrative Assistants Journeyman 43-6012

Secretaries and Administrative Assistants, Except Legal, Medical and Executive Journeyman 43-6014

Computer Systems AnalystsSenior15-1211
Computer Systems AnalystsJourneyman15-1211
Computer Network ArchitectsSenior15-1241
Computer Network ArchitectsJourneyman15-1241
Computer Network ArchitectsJunior15-1241
Data ScientistsSenior15-2051
Data ScientistsJourneyman15-2051
Data ScientistsJunior15-2051
Software DeveloperSenior15-1252
Software DeveloperJourneyman15-1252
Software DeveloperJunior15-1252
Software Quality Assurance Analysts and TestersSenior15-1253
Software Quality Assurance Analysts and TestersJourneyman15-1253
Aerospace EngineersSenior17-2011
Aerospace EngineersJourneyman17-2011
Electronics EngineersSenior17-2072
Electronics EngineersJourneyman17-2072
Electronics EngineersJunior17-2072
Mechanical EngineersSenior17-2141
Mechanical EngineersJourneyman17-2141
Engineers, All OtherSenior17-2199
Engineers, All OtherJourneyman17-2199
Engineers, All OtherJunior17-2199
Electrical and Electronic Engineering Technologists and TechniciansSenior17-3023
Electrical and Electronic Engineering Technologists and TechniciansJourneyman17-3023
Electrical and Electronic Engineering Technologists and TechniciansJunior17-3023
Engineering Technologist & Technician, Except Drafters, All OtherSenior17-3029
Engineering Technologist & Technician, Except Drafters, All OtherJourneyman17-3029
Engineering Technologist & Technician, Except Drafters, All OtherJunior17-3029
Industrial-Organizational PsychologistsSenior19-3032
Industrial-Organizational PsychologistsJourneyman19-3032
Industrial-Organizational PsychologistsJunior19-3032

Special Effects Artists and Animators Journeyman 27-1014

CLIN Summary

Base YearDescriptionTotal HoursTotal CostTotal Profit/Fixed FeeTotal Value $
CLIN 0001Mobilization
CLIN 0002Labor418564
CLIN 0003Travel
CLIN 0004Technical Data
CLIN 1002Labor418564
CLIN 1003Travel
CLIN 1004Technical Data
CLIN 2002Labor421952
CLIN 2003Travel
CLIN 2004Technical Data
CLIN 3002Labor416120
CLIN 3003Travel
CLIN 3004Technical Data
CLIN 4002Labor407957
CLIN 4003Travel
CLIN 4004Technical Data

Total 2083157

Option Year Summary Sheet

Option Year (FAR 52.217-8)Option Year DescriptionTotal HoursTotal CostTotal Fixed FeeTotal Value $
CLIN 8010Labor204938
CLIN 8011Travel
CLIN 8012Technical Data
Option Total204938
Grand Total$ - 0

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