Attachment_7_Sample_Cost_Spreadsheet_Rev1.xls

XLS spreadsheet 245 KB Posted Oct 27, 2014

Attached to: Sea Test Range Aggregated Mission Testing (AMT) and Support Services
Solicitation number: N6893614R0024
Issued by: Department of the Navy Naval Air Systems Command Naval Air Warfare Center

About this file

From the source

14-R-0024-0001 Attachment 7 Sample Cost Spreadsheet Rev1

View the file

Other files

File	Type	Posted
14-R-0024_Amendment_0003.pdf	PDF	Nov 26, 2014
14-R-0024_Amendment_0002.pdf	PDF	Nov 17, 2014
14-R-0024-0001_Amd_0001.pdf	PDF	Oct 27, 2014
14-R-0024_RFP.pdf	PDF	Oct 22, 2014
Attachment_4_Workforce_Qualifications.xls	XLS spreadsheet	Oct 21, 2014
Attachment_5_Past_Performance_Matrix.pdf	PDF	Oct 21, 2014
Attachment_6_Past_Performance_Questionnaire.pdf	PDF	Oct 21, 2014
Exhibit_A_CDRL's.pdf	PDF	Oct 21, 2014
Attachment_2_GFP_List.xls	XLS spreadsheet	Oct 21, 2014
Attach_3_Incurred_Cost_ _Progress_Reporting.xls	XLS spreadsheet	Oct 21, 2014
Attachment_7_Sample_Cost_Spreadsheet.xls	XLS spreadsheet	Oct 21, 2014
Attachment_8_Sample_Cost_Spreadsheet.xlsx	XLSX spreadsheet	Oct 14, 2014
Attachment_5_Workforce_Qualification.xlsx	XLSX spreadsheet	Oct 14, 2014
Attachment_5_Workforce_Qualification.pdf	PDF	Oct 9, 2014
Solicitation.pdf	PDF	Oct 9, 2014
Attachment_8_Sample_Cost_Spreadsheet.pdf	PDF	Oct 9, 2014
CDRL's.pdf	PDF	Oct 9, 2014
Attachment_6_Past_Performance_Matrix.pdf	PDF	Oct 9, 2014

Show all 18

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

N68936-14-R-0024

Attachment 7 - Sample Cost Spreadsheet Rev1

23-Oct-14

Instructions:

The prime and subcontractor(s), each, must submit a cost proposal in accordance with this format.

You may deviate from this general format only as applicable to your accounting and cost estimating system, and only to the extent that it further identifies elements of cost.

For the prime, subcontractor labor should be included in the overall labor and should not be proposed with ODCs.

Please note that the labor categories and amounts shown are for illustration purposes only.

Please go through each worksheet (tab) in this spreadsheet and fill-in where there are highlighted cells, the rest has been formulated to auto populate.

In the header of each spreadsheet include the offerors name and date proposal is due.

Do not apply fee to material and travel.

Proposed Summary

Proposed
	2015	2016	2017	2018	2019	5 Year Total	Option	Grand Total
CLIN 0001	$ 435	$ 435	$ 435	$ 435	$ 435	$ 2,177
CLIN 0002	$ 20	$ 20	$ 20	$ 20	$ 20	$ 102
Total	$ 456	$ 456	$ 456	$ 456	$ 456	$ 2,279	$ 227	$ 2,507
					Calculation Verification
	$ 456	$ 456	$ 456	$ 456	$ 456	$ 2,279
						$ 2,279

&LProposed Summary&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

CLIN 0001 - Labor

	Year 1 (2015)			Year 2 (2016)			Year 3 (2017)			Year 4 (2018)			Year 5 (2019)			Summary
	Proposed			Proposed			Proposed			Proposed			Proposed			Proposed
RFP Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Avg. Rate	Total
Program Manager	10	$ 5.00	$ 50	10	$ 5.00	$ 50	10	$ 5.00	$ 50	10	$ 5.00	$ 50	10	$ 5.00	$ 50	50	$ 5.00	$ 250
Engineer/Scientist II	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	50	$ 2.00	$ 100
Engineer/Scientist III	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	50	$ 3.00	$ 150
Engineer/Scientist V	10	$ 4.00	$ 40	10	$ 4.00	$ 40	10	$ 4.00	$ 40	10	$ 4.00	$ 40	10	$ 4.00	$ 40	50	$ 4.00	$ 200
Information Assurance Analyst, Senior	10	$ 1.00	$ 10	10	$ 1.00	$ 10	10	$ 1.00	$ 10	10	$ 1.00	$ 10	10	$ 1.00	$ 10	50	$ 1.00	$ 50
Configuration Management Analyst	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	50	$ 2.00	$ 100
Logistician	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	50	$ 2.00	$ 100
Information Assurance Analyst	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	50	$ 3.00	$ 150
Total Direct Labor	80		$ 220	80		$ 220	80		$ 220	80		$ 220	80		$ 220	400		$ 1,100
Standard Benefits		25.00%	$ 55		25.00%	$ 55		25.00%	$ 55		25.00%	$ 55		25.00%	$ 55			$ 275
Labor OH		10.00%	$ 27.50		10.00%	$ 28		10.00%	$ 28		10.00%	$ 28		10.00%	$ 28			$ 138
Facility OH		15.00%	$ 10.50		15.00%	$ 11		15.00%	$ 11		15.00%	$ 11		15.00%	$ 11			$ 53
Total Labor			$ 313			$ 313			$ 313			$ 313			$ 313			$ 1,565
Subcontractor Labor
XYZ, Inc.	10		$ 50	10		$ 50	10		$ 50	10		$ 50	10		$ 50	50		$ 250
ABC, Inc.	10		$ 30	10		$ 30	10		$ 30	10		$ 30	10		$ 30	50		$ 150
Subtotal Subcontractor Labor	20		$ 80	20		$ 80	20		$ 80	20		$ 80	20		$ 80	100		$ 400
Subcontractor M&H		1.50%	$ 1		1.50%	$ 1		1.50%	$ 1		1.50%	$ 1		1.50%	$ 1			$ 6
Subcontractor G&A		5.00%	$ 4		5.00%	$ 4		5.00%	$ 4		5.00%	$ 4		5.00%	$ 4			$ 20
Subcontractor Total			$ 85			$ 85			$ 85			$ 85			$ 85			$ 426
Subtotal			$ 398			$ 398			$ 398			$ 398			$ 398			$ 1,991
G&A on Prime Labor		5.00%	$ 16		5.00%	$ 16		5.00%	$ 16		5.00%	$ 16		5.00%	$ 16			$ 78
Total Estimated CLIN 0001 Cost less FCCM			$ 414			$ 414			$ 414			$ 414			$ 414			$ 2,069
FCCM			$ -			$ -			$ -			$ -			$ -			$ -
Fixed Fee on Prime Costs		6.00%	$ 20		6.00%	$ 20		6.00%	$ 20		6.00%	$ 20		6.00%	$ 20			$ 99
Fixed Fee on Sub Costs		2.25%	$ 2		2.25%	$ 2		2.25%	$ 2		2.25%	$ 2		2.25%	$ 2			$ 10
Total CLIN 0001 Labor CPFF	100		$ 435	100		$ 435	100		$ 435	100		$ 435	100		$ 435			$ 2,177

&LCLIN 0001 - Labor&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

CLIN 0002 - Materials&Travel

	2015		2016		2017		2018		2019		Summary
Cost Element	Proposed		Proposed		Proposed		Proposed		Proposed		Proposed
Prime		Total		Total		Total		Total		Total		Total
ODCs - Materials		$ 10		$ 10		$ 10		$ 10		$ 10		$ 50
ODCs - Travel		$ 5		$ 5		$ 5		$ 5		$ 5		$ 25
Subtotal Contractor Materials & Travel		$ 15		$ 15		$ 15		$ 15		$ 15		$ 75
Sub
XYZ
ODCs - Materials		$ 3		$ 3		$ 3		$ 3		$ 3		$ 15
ODCs - Travel		$ -		$ -		$ -		$ -		$ -
ABC
ODCs - Materials		$ 2		$ 2		$ 2		$ 2		$ 2		$ 10
ODCs - Travel		$ -		$ -		$ -		$ -		$ -		$ -
Subtotal Subcontractor Materials & Travel		$ 5		$ 5		$ 5		$ 5		$ 5		$ 25
Subtotal		$ 20		$ 20		$ 20		$ 20		$ 20		$ 100
M&H on Materials	1.50%	$ 0.15	1.50%	$ 0.15	1.50%	$ 0.15	1.50%	$ 0.15	1.50%	$ 0.15		$ 1
G&A on Materials & Travel	5.00%	$ 0.25	5.00%	$ 0.25	5.00%	$ 0.25	5.00%	$ 0.25	5.00%	$ 0.25		$ 1
Total CLIN 0002 Materials & Travel		$ 20		$ 20		$ 20		$ 20		$ 20		$ 102

&LCLIN 0002 - Materials and Travel&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

Cost Summary

	2015			2016			2017			2018			2019			6 Month Option			Total Years 1-5			Total Years 1-5 Plus Option
	Proposed			Proposed			Proposed			Proposed			Proposed			Proposed			Proposed			Proposed
RFP Labor Category	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Rate	Total	Hours	Avg. Rate	Total	Hours	Total
Program Manager	10	$ 5.00	$ 50	10	$ 5.00	$ 50	10	$ 5.00	$ 50	10	$ 5.00	$ 50	10	$ 5.00	$ 50	5	$ 5.00	$ 25	50	$ 5.00	$ 250	55	$ 275
Engineer/Scientist II	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	5	$ 2.00	$ 10	50	$ 2.00	$ 100	55	$ 110
Engineer/Scientist III	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	5	$ 3.00	$ 15	50	$ 3.00	$ 150	55	$ 165
Engineer/Scientist V	10	$ 4.00	$ 40	10	$ 4.00	$ 40	10	$ 4.00	$ 40	10	$ 4.00	$ 40	10	$ 4.00	$ 40	5	$ 4.00	$ 20	50	$ 4.00	$ 200	55	$ 220
Information Assurance Analyst, Senior	10	$ 1.00	$ 10	10	$ 1.00	$ 10	10	$ 1.00	$ 10	10	$ 1.00	$ 10	10	$ 1.00	$ 10	5	$ 1.00	$ 5	50	$ 1.00	$ 50	55	$ 55
Configuration Management Analyst	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	5	$ 2.00	$ 10	50	$ 2.00	$ 100	55	$ 110
Logistician	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	10	$ 2.00	$ 20	5	$ 2.00	$ 10	50	$ 2.00	$ 100	55	$ 110
Information Assurance Analyst	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	10	$ 3.00	$ 30	5	$ 3.00	$ 15	50	$ 3.00	$ 150	55	$ 165
Total Direct Labor	80		$ 220	80		$ 220	80		$ 220	80		$ 220	80		$ 220	40		$ 110	400		$ 1,100	440	$ 1,210
Standard Benefits			$ 55			$ 55			$ 55			$ 55			$ 55			$ 28			$ 275		$ 303
Labor OH			$ 28			$ 28			$ 28			$ 28			$ 28			$ 14			$ 138		$ 151
Facility OH			$ 11			$ 11			$ 11			$ 11			$ 11			$ 5			$ 53		$ 58
Total Labor			$ 313			$ 313			$ 313			$ 313			$ 313			$ 157			$ 1,565		$ 1,722
ODCs
Materials & Travel			$ 15			$ 15			$ 15			$ 15			$ 15			$ 8			$ 75		$ 83
Subtotal			$ 328			$ 328			$ 328			$ 328			$ 328			$ 164			$ 1,640		$ 1,804
Subcontractor Labor
XYZ, Inc.	10		$ 50	10		$ 50	10		$ 50	10		$ 50	10		$ 50	5		$ 25	50		$ 250	55	$ 275
ABC, Inc.	10		$ 30	10		$ 30	10		$ 30	10		$ 30	10		$ 30	5		$ 15	50		$ 150	55	$ 165
Subcontractor ODCs
Materials & Travel			$ 5			$ 5			$ 5			$ 5			$ 5			$ 3			$ 25		$ 28
Subtotal Subcontractor Costs	20		$ 85	20		$ 85	20		$ 85	20		$ 85	20		$ 85	10		$ 43	100		$ 425	110	$ 468
Subcontractor M&H			$ 1			$ 1			$ 1			$ 1			$ 1			$ 1			$ 6		$ 7
Subcontractor G&A			$ 4			$ 4			$ 4			$ 4			$ 4			$ 2			$ 20		$ 22
Subcontractor Total			$ 90			$ 90			$ 90			$ 90			$ 90			$ 45			$ 451		$ 496
Subtotal			$ 418			$ 418			$ 418			$ 418			$ 418			$ 209			$ 2,091		$ 2,300
G&A on Prime Labor			$ 16			$ 16			$ 16			$ 16			$ 16			$ 8			$ 78		$ 86
MH on ODCs (Material)			$ 0			$ 0			$ 0			$ 0			$ 0			$ 0			$ 1		$ 1
G&A on ODCs (Travel & Material)			$ 0			$ 0			$ 0			$ 0			$ 0			$ 0			$ 1		$ 1
Total Estimated Cost less FCCM			$ 434			$ 434			$ 434			$ 434			$ 434			$ 217			$ 2,171		$ 2,388
FCCM			$ -			$ -			$ -			$ -			$ -			$ -			$ -		$ -
Fixed Fee
Fixed Fee on Prime Costs			$ 20			$ 20			$ 20			$ 20			$ 20			$ 10			$ 99		$ 108
Fixed Fee on Sub Costs			$ 2			$ 2			$ 2			$ 2			$ 2			$ 1			$ 10		$ 11
Total CPFF	100		$ 456	100		$ 456	100		$ 456	100		$ 456	100		$ 456	50		$ 227	500		$ 2,279	550	$ 2,507

&LCost Summary&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

Direct Labor Rate

RFP Labor Category	Year 1	Year 2	Year 3	Year 4	Year 5
Program Manager	$5.00	$5.00	$5.00	$5.00	$5.00
Engineer/Scientist II	$2.00	$2.00	$2.00	$2.00	$2.00
Engineer/Scientist III	$3.00	$3.00	$3.00	$3.00	$3.00
Engineer/Scientist V	$4.00	$4.00	$4.00	$4.00	$4.00
Information Assurance Analyst, Senior	$1.00	$1.00	$1.00	$1.00	$1.00
Configuration Management Analyst	$2.00	$2.00	$2.00	$2.00	$2.00
Logistician	$2.00	$2.00	$2.00	$2.00	$2.00
Information Assurance Analyst	$3.00	$3.00	$3.00	$3.00	$3.00

&LDirect Labor Rate&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

Indirect Rates

Prime Indirect Rates		2015	2016	2017
		Proposed	Proposed	Proposed
1	Fringe	25.00%	25.00%	25.00%
2	Facility	15.00%	15.00%	15.00%
3	OH	10.00%	10.00%	10.00%
4	M&H	1.50%	1.50%	1.50%
5	G&A	5.00%	5.00%	5.00%
Indirect Rate		2018	2019
		Proposed	Proposed
1	Fringe	25.00%	25.00%
2	Facility	15.00%	15.00%
3	OH	10.00%	10.00%
4	M&H	1.50%	1.50%
5	G&A	5.00%	5.00%

&LIndirect Rates&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

Subcontractor Proposed

Annex #	SUBCONTRACTOR	PROPOSED TYPE	PROPOSED
1	XYZ, Inc.	CPFF	$ 250
2	ABC, Inc.	FPLOE	$ 150
	Total		$ 400

&LSubcontractor Proposed&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

Fee Amount

	2015	2016	2017
	Proposed	Proposed	Proposed
Fee applied to Sub	$ 2	$ 2	$ 2
Fee applied to Prime	$ 20	$ 20	$ 20
Total Fee	$ 22	$ 22	$ 22
	2018	2019
	Proposed	Proposed
Fee applied to Sub	$ 2	$ 2
Fee applied to Prime	$ 20	$ 20
Total Fee	$ 22	$ 22

&LFee Amount&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

Fee & Pass-Thru Rates

	2015	2016	2017
	Proposed	Proposed	Proposed
Fee appl to Sub-K	2.25%	2.25%	2.25%
Fee appl to Prime	6.00%	6.00%	6.00%
Pass-Thru*	6.96%	6.96%	6.96%
	2018	2019
	Proposed	Proposed
Fee appl to Sub-K	2.25%	2.25%
Fee appl to Prime	6.00%	6.00%
Pass-Thru*	6.96%	6.96%

&LFee and Pass-Thru Rates&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

Engility DL Info from Proposal

Direct Labor Blending
Escalation	1%
Labor Category	Salary	Hourly	Escalated 1	Escalated 2	Escalated 3	Escalated 4	Escalated 5
Program Manager, Senior * - Nielsen	$165,900.80	$76.53	$77.27	rate is capped				1920	$148,357.60
Project Manager - Herme	$147,463.68	$69.42	$70.11	$70.82	$71.52	$72.24	$72.96	1920
Systems Analyst, Senior - Jack	$121,736.16	$57.31	$57.88	$58.46	$59.04	$59.63	$60.23	1920
Systems Analyst, Senior - Garber	$132,308.80	$62.28	$62.91	$63.54	$64.17	$64.81	$65.46	1920
Systems Analyst, Senior - Locke	$110,990.88	$52.25	$52.77	$53.30	$53.83	$54.37	$54.91	1920
Software Engineer, Senior * - Lott	$162,576.96	$76.53	$77.30	$78.07	$78.85	$79.64	$80.44	1920
Software Engineer, Senior * - SIRS	$146,300.00	$68.87	$69.56	$70.26	$70.96	$71.67	$72.38	1920
Engineer/Scientist V * - SIRS	$142,300.00	$66.99	$67.66	$68.33	$69.02	$69.71	$70.41	3840
Systems Engineer, Senior * - Hudson	$132,160.50	$62.21	$62.84	$63.47	$64.10	$64.74	$65.39	1920
Systems Engineer, Senior * - SIRS	$142,300.00	$66.99	$67.66	$68.33	$69.02	$69.71	$70.41	1440
Computer Specialist, Senior - Ebel	$120,971.76	$56.95	$57.52	$58.09	$58.67	$59.26	$59.85	1920
Computer Specialist, Senior - SIRS	$67,900.00	$31.96	$32.28	$32.61	$32.93	$33.26	$33.59	7680
Analyst, Senior * - SIRS	$67,100.00	$31.59	$31.90	$32.22	$32.54	$32.87	$33.20	19200
Systems Analyst - SIRS	$85,000.00	$40.01	$40.41	$40.82	$41.23	$41.64	$42.06	1920
Engineer/Scientist IV * - SIRS	$112,100.00	$52.77	$53.30	$53.83	$54.37	$54.91	$55.46	1920
Test Engineer * - SIRS	$113,300.00	$53.34	$53.87	$54.41	$54.95	$55.50	$56.06	1920
Systems Specialist, Senior (RF) - SIRS	$121,800.00	$57.34	$57.91	$58.49	$59.08	$59.67	$60.26	1920
Engineer/Scientist III - SIRS	$90,800.00	$42.74	$43.17	$43.60	$44.04	$44.48	$44.92	5760
Configuration Manager Analyst - SIRS	$72,000.00	$33.89	$34.23	$34.58	$34.92	$35.27	$35.62	1920
Technical Writer III - SIRS	$65,601.00	$30.88	$31.19	$31.50	$31.73	$31.73	$31.73	1920
Financial Analyst, Junior - SIRS	$60,300.00	$28.39	$28.67	$28.96	$29.25	$29.54	$29.83	1920
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
		$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
								68640
Contract Period	1st Blend Start	1st Blend End	2nd Blend Start	2nd Blend End
Year 1	1/28/14	2/28/14	3/1/14	1/27/15
Year 2	1/28/15	2/28/15	3/1/15	1/27/16
Year 3	1/28/16	2/29/16	3/1/16	1/27/17
Year 4	1/28/17	2/28/17	3/1/17	1/27/18
Year 5	1/28/18	2/28/18	3/1/18	1/27/19
Contract Period	1st Blend Days	2nd Blend Days	Total	1st Blend %	2nd Blend %	Total
Year 1	24	237	261	9.20%	90.80%	100.00%
Year 2	23	238	261	8.81%	91.19%	100.00%
Year 3	23	239	262	8.78%	91.22%	100.00%
Year 4	22	238	260	8.46%	91.54%	100.00%
Year 5	23	237	260	8.85%	91.15%	100.00%
Description	Year 1	Year 2	Year 3	Year 4	Year 5
Program Manager, Senior * - Nielsen	$76.53	$77.27	$77.27	$77.27	$77.27	Rate is capped
Project Manager - Herme	$70.05	$70.75	$71.46	$72.18	$72.90
Systems Analyst, Senior - Jack	$57.83	$58.41	$58.99	$59.58	$60.18
Systems Analyst, Senior - Garber	$62.85	$63.48	$64.12	$64.76	$65.40
Systems Analyst, Senior - Locke	$52.72	$53.25	$53.79	$54.33	$54.87
Software Engineer, Senior * - Lott	$77.23	$78.00	$78.78	$79.57	$80.37
Software Engineer, Senior * - SIRS	$69.50	$70.19	$70.90	$71.61	$72.32
Engineer/Scientist V * - SIRS	$67.60	$68.28	$68.96	$69.65	$70.34
Systems Engineer, Senior * - Hudson	$62.78	$63.41	$64.04	$64.69	$65.33
Systems Engineer, Senior * - SIRS	$67.60	$68.28	$68.96	$69.65	$70.34
Computer Specialist, Senior - Ebel	$57.46	$58.04	$58.62	$59.21	$59.80
Computer Specialist, Senior - SIRS	$32.25	$32.58	$32.90	$33.23	$33.57
Analyst, Senior * - SIRS	$31.87	$32.19	$32.52	$32.84	$33.17
Systems Analyst - SIRS	$40.38	$40.78	$41.19	$41.60	$42.02
Engineer/Scientist IV * - SIRS	$53.25	$53.79	$54.32	$54.87	$55.41
Test Engineer * - SIRS	$53.82	$54.36	$54.90	$55.46	$56.01
Systems Specialist, Senior (RF) - SIRS	$57.86	$58.44	$59.02	$59.62	$60.21
Engineer/Scientist III - SIRS	$43.13	$43.57	$44.00	$44.44	$44.89
Configuration Manager Analyst - SIRS	$34.20	$34.55	$34.89	$35.24	$35.59
Technical Writer III - SIRS	$31.16	$31.48	$31.73	$31.73	$31.73	Rate is capped
Financial Analyst, Junior - SIRS	$28.64	$28.93	$29.22	$29.51	$29.81
	DCAA Rate		Equivalent Rt
Employee	2080 hr year	Annual Salary	1920 hr year
Nielsen	$ 79.76	$ 165,900.80	$ 78.10
Herme	$ 70.90	$ 147,472.00	$ 69.42
Jack	$ 58.53	$ 121,742.40	$ 57.31
Garber	$ 63.61	$ 132,308.80	$ 62.28
Locke	$ 53.36	$ 110,988.80	$ 52.25
Lott	$ 78.16	$ 162,572.80	$ 76.53
Hudson	$ 63.54	$ 132,163.20	$ 62.22
Ebel	$ 58.16	$ 120,972.80	$ 56.95

Sierra Trepanier:

52 weeks per year * 40 hours per week = 2,080 total hours; 1,880 productive hours since 200 hours are PTO Sierra Trepanier:

Rate * 2,080 hours Sierra Trepanier:

1920 productive hours per year divided by the same 47 work weeks equals 40.85 hours per week; 40.85 hours * 52 weeks per year equals a total of 2,124.26 hours per year; The annual salary was divided by this figure to get the equivalent 1,920 hour man year rate

Burdened Labor Rates

Description	Year 1 Direct	Y1 Fringe	Y1 Facility	Y1 OH	Y1 G&A	Y1 Fee	Y1 Burdened	Y2 Direct	Y2 Fringe	Y2 Facility	Y2 OH	Y2 G&A	Y2 Fee	Y2 Burdened	Y3 Direct	Y3 Fringe	Y3 Facility	Y3 OH	Y3 G&A	Y3 Fee	Y3 Burdened	Y4 Direct	Y4 Fringe	Y4 Facility	Y4 OH	Y4 G&A	Y4 Fee	Y4 Burdened	Y5 Direct	Y5 Fringe	Y5 Facility	Y5 OH	Y5 G&A	Y5 Fee	Y5 Burdened
Program Manager	$5.00	$1.25	$0.75	$0.63	$0.38	$0.48	$8.49	$5.00	$1.25	$0.75	$0.63	$0.38	$0.48	$8.49	$5.00	$1.25	$0.75	$0.63	$0.38	$0.48	$8.49	$5.00	$1.25	$0.75	$0.63	$0.38	$0.48	$8.49	$5.00	$1.25	$0.75	$0.63	$0.38	$0.48	$8.49
Engineer/Scientist II	$2.00	$0.50	$0.30	$0.25	$0.15	$0.19	$3.39	$2.00	$0.50	$0.30	$0.25	$0.15	$0.19	$3.39	$2.00	$0.50	$0.30	$0.25	$0.15	$0.19	$3.39	$2.00	$0.50	$0.30	$0.25	$0.15	$0.19	$3.39	$2.00	$0.50	$0.30	$0.25	$0.15	$0.19	$3.39
Engineer/Scientist III	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59
Engineer/Scientist V	$4.00	$1.00		$0.50	$0.28	$0.35	$6.12	$4.00	$1.00		$0.50	$0.28	$0.35	$6.12	$4.00	$1.00		$0.50	$0.28	$0.35	$6.12	$4.00	$1.00		$0.50	$0.28	$0.35	$6.12	$4.00	$1.00		$0.50	$0.28	$0.35	$6.12
Information Assurance Analyst, Senior	$1.00	$0.25		$0.13	$0.07	$0.09	$1.53	$1.00	$0.25		$0.13	$0.07	$0.09	$1.53	$1.00	$0.25		$0.13	$0.07	$0.09	$1.53	$1.00	$0.25		$0.13	$0.07	$0.09	$1.53	$1.00	$0.25		$0.13	$0.07	$0.09	$1.53
Configuration Management Analyst	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06
Logistician	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06	$2.00	$0.50		$0.25	$0.14	$0.17	$3.06
Information Assurance Analyst	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59	$3.00	$0.75		$0.38	$0.21	$0.26	$4.59

&LBurdened Labor Rates&RN68936-14-R-0024 Attachment 7 Sample Cost Spreadsheet Rev1 &R23-Oct-2014

File details come from the government source that posted it. Updated Nov 14, 2017.