Attachment P1 - Cost Summary Spreadsheet.xlsx

XLSX spreadsheet 49 KB Posted Nov 18, 2024

Attached to: RFP for Integration & Production (I&P) Follow-On
Solicitation number: N0042124R0038
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

Written by GovTribe AI · Nov 18, 2024

This document appears to be a Cost Summary Spreadsheet template for a federal contract opportunity. The template provides instructions for prime contractors and subcontractors to input labor categories, rates, hours, and other cost elements for the proposed work. Key details include:

The contract opportunity is for the Integration and Production (I&P) Follow-On, solicitation number N0042124R0038, issued by the Department of the Navy Naval Air Systems Command. The spreadsheet template covers a 5-year ordering period and requires offerors to break out costs by Contract Line Item Numbers (CLINs). Offerors must provide labor rates, labor hours, direct costs, indirect costs, fixed fee, and other direct costs. The template includes specific instructions for how to complete the various sections of the spreadsheet. Overall, this document provides a standardized format for submitting detailed cost information as part of the proposal for this federal contract opportunity.

View the file

Other files

File	Type	Posted
N0042124R0038-0003 CC.docx	DOCX document	Jan 8, 2025
N0042124R0038-0003.docx	DOCX document	Jan 8, 2025
Questions and Answers to Amendment 0001.pdf	PDF	Dec 11, 2024
N0042124R0038-0002 CC.docx	DOCX document	Dec 11, 2024
N0042124R0038-0002.docx	DOCX document	Dec 11, 2024
Attachment 4 - OCI List.docx	DOCX document	Dec 9, 2024
Attachment P1 - Cost Summary Spreadsheet.xlsx	XLSX spreadsheet	Dec 9, 2024
N0042124R0038-0001.docx	DOCX document	Dec 9, 2024
N0042124R0038-0001 CC.docx	DOCX document	Dec 9, 2024
Questions and Answers to RFP N0042124R0038.pdf	PDF	Dec 9, 2024
Attachment 3 - Locator Form.doc	DOC document	Nov 18, 2024
Attachment 6 - WD 2015-4279-Rev 25.pdf	PDF	Nov 18, 2024
N0042124R0038.pdf	PDF	Nov 18, 2024
Attachment 2 - IP_CSP V6_CUI.docx	DOCX document	Nov 18, 2024
Attachment 4 - IP_OCI List.docx	DOCX document	Nov 18, 2024
Exhibit A - CDRLs.docx	DOCX document	Nov 18, 2024
Attachment P2 - Annual Fully Burdened Rates.xlsx	XLSX spreadsheet	Nov 18, 2024
Attachment P3 - SBPCD.docx	DOCX document	Nov 18, 2024
Attachment 1 -DD FORM 254 JUNE 2025.pdf	PDF	Nov 18, 2024
Attachment 5 - Data Transmittal Form.docx	DOCX document	Nov 18, 2024

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

	Instructions for Prime Contractor:
1	Enter Prime offeror name into cell B3.
2	Enter all prime employee names in Column C (starting at row 10) If necessary, insert additional rows--but ensure integrity of formulas.
3	Enter Current, Contingent, or Prospective in Column D (starting at row 10)
4	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.
5	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
6	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.
7	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
8	All dollar figures shall be carried out no further than two decimal places.
9	In Column E, the Government has listed whether the labor category falls under Regular Work or Overtime.
10	In Column F, the Government has listed the BLS Code applicable to that Labor Category.
11	In Column G, the Government has listed the SCA Code applicable to that Labor Category.
12	In column H, 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.
13	In column I, the Government has listed the place of performance applicable to that Labor Category.
14	In Columns J, N, R, V, and Z, the Government has listed the Minimum Direct Labor Rate applicable to that Labor Category. If the Labor Category falls under SCA, the Government used the minimum direct labor rate per the SCA Code listed in Column G as seen in the applicable WD. If the Labor Category does not fall under SCA, the Government used a minimum direct labor rate per the BLS Code listed in Column F.
15	In Columns K, O, S, W, and AA, insert the proposed direct labor rate applicable to that Labor Category.
16	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
17	For each subcontractor, enter the subcontractor name, labor category the subcontractor will be performing, total hours, and total amount for each period of performance.
18	Please note if more subcontractors are needed, the contractor may add additional rows to accommodate them, but ensure integrity of formulas.
19	The prime should insert the subcontractor handling charge, if any.
20	The prime should insert the fixed fee rate applied to its cost excluding subcontractor labor.
21	The prime should insert the fixed fee rate it is applying to the subcontractor labor, if any.
22	Under Other Direct Costs, the prime contractor should separate by Travel, Material, and Field Services as applicable.
23	Apply indirects to the Other Direct Costs if applicable and if in compliance with the RFP instructions.
24	On 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
25	When submitting this file, the instructions may be deleted.

	Instructions for Subcontractors:
1	Enter Prime offeror name into cell B3.
	Enter Subcontractor offeror name into cell B4.
2	Replace Prime Contractor with Subcontractor in cells B7, and any other applicable cells.
3	Enter all subcontractor employee names in Column C (starting at row 10) If necessary, insert additional rows--but ensure integrity of formulas.
4	Enter Current, Contingent, or Prospective in Column D (starting at row 10)
5	Enter all subcontractor labor categories in Column B (starting at row 10). If necessary, insert additional rows--but ensure integrity of formulas. Remove any labor categories in Column B that the Subcontractor is not performing. 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.
6	Only one worksheet shall be prepared for the entire period of performance (for each Prime and Subcontractor)
7	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.
8	All cells shall be unprotected and unlocked, with formulae intact to show mathematical operations.
9	All dollar figures shall be carried out no further than two decimal places.
10	In Column E, the Government has listed whether the labor category falls under Regular Work or Overtime.
11	In Column F, the Government has listed the BLS Code applicable to that Labor Category.
12	In Column G, the Government has listed the SCA Code applicable to that Labor Category.
13	In column H, 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.
14	In column I, the Government has listed the place of performance applicable to that Labor Category.
15	In Columns J, N, R, V, and Z, the Government has listed the Minimum Direct Labor Rate applicable to that Labor Category. If the Labor Category falls under SCA, the Government used the minimum direct labor rate per the SCA Code listed in Column G as seen in the applicable WD. If the Labor Category does not fall under SCA, the Government used a minimum direct labor rate per the BLS Code listed in Column F.
16	In Columns K, O, S, W, and AA, insert the proposed direct labor rate applicable to that Labor Category.
17	Insert applicable indirect rates and apply accordingly. For example, if there are multiple fringe rates, insert separately and apply accordingly.
18	For subcontractor cost summary sheets, please delete Rows 72-115 as well as any unused labor category rows.
19	When submitting this file, the instructions may be deleted.

N00421-21-R-0161

Cost Spreadsheet (LOE)

COST SUMMARY SPREADSHEET (LOE)

	Prime Offeror Name:
	Subcontractor(s) Name (if applicable):
										Ordering Period 1				Ordering Period 2				Ordering Period 3				Ordering Period 4				Ordering Period 5			Total
Position	Government Labor Category	Employee Name	Current/ Contingent/ Prospective	RG/OT	BLS Code	SCA Code	F/P	Site	Minimum Direct Rate	Rate	Hours	Amount	Minimum Direct Rate	Rate	Hours	Amount	Minimum Direct Rate	Rate	Hours	Amount	Minimum Direct Rate	Rate	Hours	Amount	Minimum Direct Rate	Rate	Hours	Amount	Hours	Amount
	Prime Contractor Labor Cost							K = Contractor
								G = Government
								R = Remote
1	Administrative Assistant	Employee Name 1		RG	43-6011	01020		G - St. Inigoes	$ 36.12		5760	0.00	36.48		5760	0.00	36.85		5760	0.00	37.21		5760	0.00	37.59		5760	0.00	28800	0.00
2	Budget Analysts, Junior	Etc.		RG	13-2031	N/A		G - St. Inigoes	$ 36.26		1920	0.00	37.71		1920	0.00	39.22		1920	0.00	40.79		1920	0.00	42.42		1920	0.00	9600	0.00
3	Budget Analysts, Journeyman	Etc.		RG	13-2031	N/A		G - St. Inigoes	$ 49.10		960	0.00	51.06		960	0.00	53.11		960	0.00	55.23		960	0.00	57.44		960	0.00	4800	0.00
4	Budget Analysts, Journeyman	Etc.		RG	13-2031	N/A		K - MD	$ 49.10		960	0.00	51.06		960	0.00	53.11		960	0.00	55.23		960	0.00	57.44		960	0.00	4800	0.00
5	Budget Analysts, Senior	Etc.		RG	13-2031	N/A		G - St. Inigoes	$ 64.75		1920	0.00	67.34		1920	0.00	70.03		1920	0.00	72.83		1920	0.00	75.75		1920	0.00	9600	0.00
6	Drafter/CAD Operator III	Etc.		RG	17-3019	30063		G - St. Inigoes	$ 30.40		1920	0.00	30.70		1920	0.00	31.01		1920	0.00	31.32		1920	0.00	31.63		1920	0.00	9600	0.00
7	Drafter/CAD Operator IV	Etc.		RG	17-3019	30064		G - St. Inigoes	$ 37.41		1920	0.00	37.78		1920	0.00	38.16		1920	0.00	38.54		1920	0.00	38.93		1920	0.00	9600	0.00
8	Computer and Information Research Scientists, Journeyman	Etc.		RG	15-1221	N/A		G - St. Inigoes	$ 70.00		7680	0.00	72.80		7680	0.00	75.71		7680	0.00	78.74		7680	0.00	81.89		7680	0.00	38400	0.00
9	Electrical Engineers, Junior	Etc.		RG	17-2071	N/A		G - St. Inigoes	$ 49.11		1920	0.00	51.07		1920	0.00	53.12		1920	0.00	55.24		1920	0.00	57.45		1920	0.00	9600	0.00
10	Electrical Engineers, Journeyman	Etc.		RG	17-2071	N/A		G - St. Inigoes	$ 70.00		1920	0.00	72.80		1920	0.00	75.71		1920	0.00	78.74		1920	0.00	81.89		1920	0.00	9600	0.00
11	Electrical Engineers, Senior	Etc.		RG	17-2071	N/A		G - St. Inigoes	$ 80.93		1920	0.00	84.17		1920	0.00	87.53		1920	0.00	91.04		1920	0.00	94.68		1920	0.00	9600	0.00
12	Electrical Engineers, Senior *	Etc.		RG	17-2071	N/A		G - St. Inigoes	$ 80.93		1920	0.00	84.17		1920	0.00	87.53		1920	0.00	91.04		1920	0.00	94.68		1920	0.00	9600	0.00
13	Electrical Engineers, Senior *	Etc.		RG	17-2071	N/A		G - St. Inigoes	$ 80.93		1920	0.00	84.17		1920	0.00	87.53		1920	0.00	91.04		1920	0.00	94.68		1920	0.00	9600	0.00
14	Electrical Engineers, Senior *	Etc.		RG	17-2071	N/A		G - St. Inigoes	$ 80.93		1920	0.00	84.17		1920	0.00	87.53		1920	0.00	91.04		1920	0.00	94.68		1920	0.00	9600	0.00
15	Electronics Technician Maintenance I	Etc.		RG	17-3023	23181		G - St. Inigoes	$ 29.46		19200	0.00	29.75		19200	0.00	30.05		19200	0.00	30.35		19200	0.00	30.66		19200	0.00	96000	0.00
16	Electronics Technician Maintenance I Overtime	Etc.		OT	17-3023	23181		G - St. Inigoes	$ 29.46		403	0.00	29.75		403	0.00	30.05		403	0.00	30.35		403	0.00	30.66		403	0.00	2016	0.00
17	Electronics Technician Maintenance II	Etc.		RG	17-3023	23182		G - St. Inigoes	$ 31.27		17280	0.00	31.58		17280	0.00	31.90		17280	0.00	32.22		17280	0.00	32.54		17280	0.00	86400	0.00
18	Electronics Technician Maintenance II Overtime	Etc.		OT	17-3023	23182		G - St. Inigoes	$ 31.27		1613	0.00	31.58		1613	0.00	31.90		1613	0.00	32.22		1613	0.00	32.54		1613	0.00	8064	0.00
19	Electronics Technician Maintenance III	Etc.		RG	17-3023	23183		G - St. Inigoes	$ 32.92		15360	0.00	33.25		15360	0.00	33.58		15360	0.00	33.92		15360	0.00	34.26		15360	0.00	76800	0.00
20	Electronics Technician Maintenance III	Etc.		RG	17-3023	23183		K - MD	$ 32.92		1920	0.00	33.25		1920	0.00	33.58		1920	0.00	33.92		1920	0.00	34.26		1920	0.00	9600	0.00
21	Electronics Technician Maintenance III Overtime	Etc.		OT	17-3023	23183		G - St. Inigoes	$ 32.92		154	0.00	33.25		154	0.00	33.58		154	0.00	33.92		154	0.00	34.26		154	0.00	768	0.00
22	Electronics Technician Maintenance III Overtime	Etc.		OT	17-3023	23183		K - MD	$ 32.92		1920	0.00	33.25		1920	0.00	33.58		1920	0.00	33.92		1920	0.00	34.26		1920	0.00	9600	0.00
23	Engineering Technician I	Etc.		RG	17-3029	30081		G - St. Inigoes	$ 22.92		1920	0.00	23.15		1920	0.00	23.38		1920	0.00	23.61		1920	0.00	23.85		1920	0.00	9600	0.00
24	Engineering Technician I Overtime	Etc.		OT	17-3029	30081		G - St. Inigoes	$ 22.92		58	0.00	23.15		58	0.00	23.38		58	0.00	23.61		58	0.00	23.85		58	0.00	288	0.00
25	Engineering Technician II	Etc.		RG	17-3029	30082		G - St. Inigoes	$ 25.72		3840	0.00	25.98		3840	0.00	26.24		3840	0.00	26.50		3840	0.00	26.76		3840	0.00	19200	0.00
26	Engineering Technician II Overtime	Etc.		OT	17-3029	30082		G - St. Inigoes	$ 25.72		461	0.00	25.98		461	0.00	26.24		461	0.00	26.50		461	0.00	26.76		461	0.00	2304	0.00
27	Engineering Technician III	Etc.		RG	17-3029	30083		G - St. Inigoes	$ 28.79		7680	0.00	29.08		7680	0.00	29.37		7680	0.00	29.66		7680	0.00	29.96		7680	0.00	38400	0.00
28	Engineering Technician III Overtime	Etc.		OT	17-3029	30083		G - St. Inigoes	$ 28.79		1094	0.00	29.08		1094	0.00	29.37		1094	0.00	29.66		1094	0.00	29.96		1094	0.00	5472	0.00
29	Engineering Technician IV	Etc.		RG	17-3029	30084		G - St. Inigoes	$ 35.64		9600	0.00	36.00		9600	0.00	36.36		9600	0.00	36.72		9600	0.00	37.09		9600	0.00	48000	0.00
30	Engineering Technician IV Overtime	Etc.		OT	17-3029	30084		G - St. Inigoes	$ 35.64		384	0.00	36.00		384	0.00	36.36		384	0.00	36.72		384	0.00	37.09		384	0.00	1920	0.00
31	Engineering Technician V	Etc.		RG	17-3029	30085		G - St. Inigoes	$ 43.61		9600	0.00	44.05		9600	0.00	44.49		9600	0.00	44.93		9600	0.00	45.38		9600	0.00	48000	0.00
32	Engineering Technician V Overtime	Etc.		OT	17-3029	30085		G - St. Inigoes	$ 43.61		365	0.00	44.05		365	0.00	44.49		365	0.00	44.93		365	0.00	45.38		365	0.00	1824	0.00
33	General and Operations Managers, Journeyman	Etc.		RG	11-1021	N/A		G - St. Inigoes	$ 78.85		1920	0.00	82.00		1920	0.00	85.28		1920	0.00	88.70		1920	0.00	92.24		1920	0.00	9600	0.00
34	General and Operations Managers, Senior *	Etc.		RG	11-1021	N/A		G - St. Inigoes	$ 104.11		1536	0.00	108.27		1536	0.00	112.61		1536	0.00	117.11		1536	0.00	121.79		1536	0.00	7680	0.00
35	General Clerk I	Etc.		RG	43-5071	01111		G - St. Inigoes	$ 17.36		1920	0.00	17.53		1920	0.00	17.71		1920	0.00	17.89		1920	0.00	18.06		1920	0.00	9600	0.00
36	Logisticians, Junior	Etc.		RG	13-1081	N/A		G - St. Inigoes	$ 47.09		1920	0.00	48.97		1920	0.00	50.93		1920	0.00	52.97		1920	0.00	55.09		1920	0.00	9600	0.00
37	Logisticians, Journeyman*	Etc.		RG	13-1081	N/A		G - St. Inigoes	$ 78.41		1920	0.00	81.55		1920	0.00	84.81		1920	0.00	88.20		1920	0.00	91.73		1920	0.00	9600	0.00
38	Logisticians, Journeyman*	Etc.		RG	13-1081	N/A		K - MD	$ 78.41		1920	0.00	81.55		1920	0.00	84.81		1920	0.00	88.20		1920	0.00	91.73		1920	0.00	9600	0.00
39	Management Analysts, Junior	Etc.		RG	13-1111	N/A		G - St. Inigoes	$ 47.50		1920	0.00	49.40		1920	0.00	51.38		1920	0.00	53.43		1920	0.00	55.57		1920	0.00	9600	0.00
40	Management Analysts, Journeyman	Etc.		RG	13-1111	N/A		R - MD	$ 78.16		1920	0.00	81.29		1920	0.00	84.54		1920	0.00	87.92		1920	0.00	91.44		1920	0.00	9600	0.00
41	Management Analysts , Journeyman	Etc.		RG	13-1111	N/A		G - St. Inigoes	$ 68.21		5760	0.00	70.94		5760	0.00	73.78		5760	0.00	76.73		5760	0.00	79.80		5760	0.00	28800	0.00
42	Supply Technician	Etc.		RG	43-5061	01410		G - St. Inigoes	$ 36.12		1920	0.00	36.48		1920	0.00	36.85		1920	0.00	37.21		1920	0.00	37.59		1920	0.00	9600	0.00
43	Technical Instructor/Course Developer	Etc.		RG	25-9031	15095		G - St. Inigoes	$ 42.85		1920	0.00	43.28		1920	0.00	43.71		1920	0.00	44.15		1920	0.00	44.59		1920	0.00	9600	0.00
44	Technical Writer III	Etc.		RG	27-3042	30463		G - St. Inigoes	$ 42.72		3840.0	0.00	43.15		3840.0	0.00	43.58		3840.0	0.00	44.01		3840.0	0.00	44.45		3840.0	0.00	19200	0.00

Total Direct Labor Cost	155,827.20	0.00	155,827	0.00	155,827	0.00	155,827	0.00	155,827	0.00	779,136.00	0.00
Prime Contractor Indirect Labor Cost
Overhead
Fringe Benefits
G&A
Total Indirect Labor Cost
Total Direct and Indirect Labor cost
COM
Total Prime Contractor Labor Cost

	Subcontractor Labor Cost
	Subcontractor proposed cost and fee
	<Insert Subcontractor Name>
52	<Insert Labor Category >	Employee Name 1
53		Employee Name 2
54		Etc.
55		Etc.
56		Etc.
57		Etc.
58		Etc.
59		Etc.
60		Etc.
61		Etc.
	<Insert Subcontractor Name>
62	<Insert Labor Category >	Employee Name 1
63		Employee Name 2
64		Etc.
65		Etc.
66		Etc.
67		Etc.
68		Etc.
69		Etc.
70		Etc.
71		Etc.
	<Insert Subcontractor Name>
72	<Insert Labor Category >	Employee Name 1
73		Employee Name 2
74		Etc.
75		Etc.
76		Etc.
77		Etc.
78		Etc.
79		Etc.
80		Etc.
81		Etc.
	Total proposed subcontractor labor cost and fee
	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

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)

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)

Grand Total of CPFF all CLINs

Pass Through Analysis - Total for All Years	Amount	Percent
Subcontractor proposed cost and fee
Pass Through Amount (not including fee)
Prime Contractor Fee for Subcontractor Labor *
Total Pass Through Amount (including fee)		ERROR:#DIV/0!

Fee Analysis - Total for All Years	Amount	Percent
Prime Contractor Labor Cost
Fixed Fee for Labor Performed by Prime Contractor		ERROR:#DIV/0!

Solicitation N00421-20-R-0119 Page &P &F

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

Summary CLIN Summary Sheet

CLINS CLIN Description Total Hours Total Cost Total Fixed Fee Total Value $

Total

N0042123R0070 P1 Cost Summary

File details come from the government source that posted it. Updated Nov 18, 2024.