Attach P3- Cost Summary Spreadsheet.xls

XLS spreadsheet 98 KB Posted Mar 9, 2020

Attached to: The Naval Air Systems Commands (NAVAIR), Naval Air Warfare Centers (NAWC) and Commander, Fleet Readiness Centers (COMFRC) Platform Security and related support services initiatives
Solicitation number: N0042120R0099
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

Written by GovTribe AI · Dec 30, 2023

This document provides instructions for completing a cost summary spreadsheet and detailed cost tab as part of a proposal for platform security and related support services. The solicitation is issued by the Naval Air Systems Command, Naval Air Warfare Centers, and Commander, Fleet Readiness Centers to provide security measures protecting classified and controlled unclassified information. Offerors must submit a cost summary spreadsheet with separate tabs for the prime contractor and any subcontractors including fully burdened annual labor costs, hourly rates, and other direct costs by contract line item for a five-year period of performance. Instructions provide details on populating labor categories, individual designators, government and proposed Bureau of Labor Statistics codes, hours, rates, and indirect costs. Subcontractor costs must include any applicable pass-throughs and fees.

View the file

Other files

File	Type	Posted
Questions Part 3.docx	DOCX document	Apr 7, 2020
Amendment 0003.docx	DOCX document	Apr 7, 2020
Questions Part 3.docx	DOCX document	Apr 7, 2020
Questions Part 2.docx	DOCX document	Mar 30, 2020
N0042120R0099 Amend 2.docx	DOCX document	Mar 30, 2020
N0042120R00990001.pdf	PDF	Mar 23, 2020
Questions Part 1.docx	DOCX document	Mar 23, 2020
Attachment P6_ Sample Task 3 IPSS.docx	DOCX document	Mar 9, 2020
Attach 2 - OCI List.docx	DOCX document	Mar 9, 2020
Attachment P4_ Sample Task 1 Acqsec.docx	DOCX document	Mar 9, 2020
Attach 3- DD254 (for bidding purposes only).pdf	PDF	Mar 9, 2020
RFP N0042120R0099.docx	DOCX document	Mar 9, 2020
Attach P1 - Past Performance Information Form.pdf	PDF	Mar 9, 2020
Attachment P5_ Sample Task 2 Cyber.docx	DOCX document	Mar 9, 2020
Attachment_P7_Composite_Labor_Rate_Fee_Worksheet.xlsx	XLSX spreadsheet	Mar 9, 2020
Attach 1 - Cybersecurity Plan (CS) Plan.docx	DOCX document	Mar 9, 2020
Attach 4 - Data Item Form.docx	DOCX document	Mar 9, 2020
Attach 5 - CSP_SAC.pdf	PDF	Mar 9, 2020
Exhibit A-CDRLs A001-A010.pdf	PDF	Mar 9, 2020
Attach P2 - CPAQ.pdf	PDF	Mar 9, 2020

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

Try for free Login

Text version

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

Instructions

COST SUMMARY SPREADSHEET
Detailed Cost Tab		Prime Fully Burdened Labor Tab
Instructions for Prime Contractor:		Instructions for Prime Contractor:
1	Enter Prime offeror name into cell B3.	1	Enter the Offeror (Prime's name or Subcontractor's name) in Column A "Offeror Name" (starting at row 4) to distinguish between the companies. If necessary, insert additional rows--but ensure integrity of formulas.
2	Enter all Prime employee names in Column A (starting at row 9). If proposing a prospective hire, please enter "Prospective Hire". If necessary, insert additional rows--but ensure integrity of formulas.	2	Enter the Proposed Labor Categories in Column B for both the Prime and all subs (starting at row 4). Spell and format each entry the same way every time it is used in the spreadsheet.
3	Assign each employee/prospective hire an individual designator (each person proposed should have their own number next to it in order to identify each employee/prospective hire by a number. There should not be any duplicates, even between the Prime and Subs) in Column B (starting at row 9). If necessary, insert additional rows--but ensure integrity of formulas.	3	Enter in Column C (starting at row 4) for each individual employee/prospective hire proposed, the corresponding Individual Designator as found on the "Detailed Cost" tab in Column B.
4	Enter the Government's BLS Codes in Column C (starting at row 9). Offerors shall type the Government BLS Codes exactly as they are found in the RFP. Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of BLS Codes used.	4	Enter in Columns D-H (starting at row 4) the Annual Fully-Burdened Labor proposed for the applicable performance period (e.g. Base or Year_#) for personnel associated with the Proposed Labor Category and Individual Designator. In order to avoid mathematical errors, the Offeror shall use formulas and functions to the maximum extent possible (linking to Cost Summary Spreadsheet Tab). If links are utilized, supply those referenced files. Enter numbers only, in U.S. Dollar format $###.## rounded to the nearest cent. Annual Fully-Burdened Labor shall include any applicable fringe, overhead, G&A, FCCM and fee on total prime labor, but should not include Other Direct Costs (ODCs) such as Materials and Travel including any burdens applied to them. Annual Fully-Burdened Labor shall be the Fully-Burdened Labor Rate multiplied by the amount of hours proposed for the applicable performance period.
5	Enter all Government labor categories in Column D (starting at row 9) that correspond with the BLS Codes listed in Column C. Offerors shall type the Government Labor Category name exactly as it is found in the RFP. If necessary, insert additional rows--but ensure integrity of formulas.	5	Enter in Columns I-M the Fully-Burdened Labor Rate per hour proposed for the applicable performance period (e.g. Base or Year_#) for personnel associated with the Proposed Labor Category and Individual Designator. In order to avoid mathematical errors, the Offeror shall use formulas and functions to the maximum extent possible (linking to Cost Summary Spreadsheet Tab). If links are utilized, supply those referenced files. The numbers shall be in U.S. Dollar format $###.## rounded to the nearest cent. Fully-Burdened Labor Rates shall include any applicable fringe, overhead, G&A, FCCM, and fee on total prime labor, but should not include Other Direct Costs (ODCs) such as Materials and Travel including any burdens applied to them.
6	Enter the proposed BLS Codes in Column E (starting at row 9). Please note, in order to obtain the most accurate BLS wage data, the BLS crosswalk is available at: https://www.bls.gov/soc/2018/crosswalks.htm . The crosswalk from the 2010 Standard Occupational Classification (SOC) to the 2018 SOC matches every detailed occupation from the 2010 SOC with the corresponding new 2018 SOC code(s) and title(s).	6	For each subcontractor in Columns D-M, the Prime Contractor shall insert the fully burdened annual labor/rate including any applicable pass-throughs, i.e. subcontractor handling and Prime fee on sub labor, if any.
7	Enter all Prime proposed labor categories in Column F (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In Column F, the Offeror should insert the title of the labor category it will be utilizing. The proposed labor categories shall correspond with the proposed BLS codes in Column E. Unless otherwise noted in the RFP, the Offeror is not required to utilize the Government's labor categories; however, each proposed labor category should appear opposite of the government labor category it is comparable to. 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.
8	In column G, 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.
9	In column H, 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.
10	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
11	For each subcontractor, enter the subcontractor name, total hours, and total cost for each period of performance.
12	Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
13	The prime should insert the subcontractor handling charge, if any.
14	The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
15	The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
16	Under Other Direct Costs, the prime contractor should separate by Travel and Material as applicable.
17	Apply indirects to the Other Direct Costs, if applicable, and in compliance with the RFP instructions.
18	On the "Detailed Cost Summary" tab, break out all costs by CLIN. Ensure that the total costs of the CLINs match Section B and the total on the "Detailed Cost" tab.
19	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
20	The 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.
21	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
22	All dollar figures shall be carried out no further than two decimal places.
23	When submitting this file, the instructions may be deleted.
Instructions for Subcontractors:
1	Enter Prime offeror name into cell B3.
2	Replace "Prime Contractor" with "Subcontractor" in A7, A8, A13, and A20.
3	Enter all Subcontractor employee names in Column A (starting at row 9). If proposing a prospective hire, please enter "Prospective Hire". If necessary, insert additional rows--but ensure integrity of formulas.
4	Assign each employee/prospective hire an individual designator (each person proposed should have their own number next to it in order to identify each employee/prospective hire by a number. There should not be any duplicates, even between the Prime and Subs) in Column B (starting at row 9). If necessary, insert additional rows--but ensure integrity of formulas.
5	Enter the Government's BLS Codes in Column C (starting at row 9). Please note, in evaluation, the Offeror's proposal will be compared to the Government Estimate in terms of BLS Codes used.
6	Enter all Government labor categories in Column D (starting at row 9) that correspond with the BLS Codes listed in Column C. Offerors shall type the Government Labor Category name exactly as it is found in the RFP. If necessary, insert additional rows--but ensure integrity of formulas.
7	Enter the Proposed BLS Codes in Column E (starting at row 9). Please note, in order to obtain the most accurate BLS wage data, the BLS crosswalk is available at: https://www.bls.gov/soc/2018/crosswalks.htm . The crosswalk from the 2010 Standard Occupational Classification (SOC) to the 2018 SOC matches every detailed occupation from the 2010 SOC with the corresponding new 2018 SOC code(s) and title(s).
8	Enter all subcontractor labor categories in Column F (starting at row 9) If necessary, insert additional rows--but ensure integrity of formulas. In column F, the Offeror should insert the title of the labor category it will be utilizing. The proposed labor categories shall correspond with the proposed BLS codes in Column E. Unless otherwise noted in the RFP, the Offeror is not required to utilize the Government's labor categories, however, each proposed labor category should appear opposite of the government labor category it is comparable to. 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.
9	In column G, 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.
10	In column H, 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.
11	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordinly.
12	For subcontractor detailed cost sheets, delete Rows 22-48.
13	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
14	The 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.
15	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
16	All dollar figures shall be carried out no further than two decimal places.
17	When submitting this file, the instructions may be deleted.

Detailed Cost

DETAILED COST
Prime Offeror Name:
Subcontractor Name (if applicable):
								Year 1			Year 2			Year 3			Year 4			Year 5			Total for All Periods
Cost Elements	Individual Designator #	Government BLS Code	Government Labor Category	Proposed BLS Code	Proposed Labor Category	F/P	Site	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Employee Name										0			0			0			0			0	0	0
Employee Name										0			0			0			0			0	0	0
Etc.										0			0			0			0			0	0	0
Total Direct Labor Cost										0			0			0			0			0	0	0
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost										0			0			0			0			0		0
COM
Total Prime Contractor Labor Cost										0			0			0			0			0		0
Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor 1
Subcontractor 2
Etc.
Total proposed subcontractor labor cost and fee										0			0			0			0			0		0
Prime contractor pass through (not including fee)
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through																								0
Total Labor Cost (Prime and Subcontractor Labor)
Fixed Fee
Prime Contractor Fee for Prime Contractor Labor
Prime Contractor Fee for Subcontractor Labor *
Total Fee (for Prime and Subcontractor Labor)
Total Labor Cost Plus Fixed Fee (CPFF)																								0
Other Direct Costs
Other Direct Costs (ODCs)
Any adders to ODCs such as G&A (cost only - no fee)
Total ODCs
Total CPFF all CLINs (Labor and ODCs)																								0

Detailed Cost Summary

DETAILED COST SUMMARY
CLINS	CLIN Description	Total Hours	Total Cost	Total Fixed Fee	Total Value $
X001
X002
Total

Prime Fully Burdened Labor

Prime Fully Burdened Labor (Annual and Rate)

Offeror Name

Proposed Labor Category

Individual Designator

Proposed Annual Fully-Burdened Labor

Proposed Fully Burdened Labor Rate

Year 1

Year 2

Year 3

Year 4

Year 5

Year 1

Year 2

Year 3

Year 4

Year 5

Program Manager

Engineer/Scientist IV (KEY)

Engineer/Scientist II

Engineer/Scientist I

Engineering/Electronics Technician, Senior (KEY)

Engineering/Electronics Technician, Junior

Data Specialist

Computer Specialist

File details come from the government source that posted it. Updated Mar 9, 2020.