N6449819R4048_Attachment_2_Cost_Summary_Format.xls

XLS spreadsheet 80 KB Posted Apr 22, 2019

Attached to: New Acquisition Integrated Logistics Support (ILS)
Solicitation number: N6449819R4080
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

RFP No. N6449819R4048 Attachment 2 Cost Summary Format Spreadsheet

View the file

Other files

File	Type	Posted
N6449819R404800005.pdf	PDF	May 28, 2019
N6449819R40480004.pdf	PDF	May 14, 2019
N6449819R40480003.pdf	PDF	May 9, 2019
N6449819R40480002.pdf	PDF	May 6, 2019
N6449819R40480001.pdf	PDF	May 1, 2019
N6449819R4048_Attachment_2_Cost_Summary_Format_Amend_0001.xls	XLS spreadsheet	May 1, 2019
N6449819R4048_Exhibit_A_CDRLS.pdf	PDF	Apr 22, 2019
N6449819R4048_Attachment_3_Labor_Rate_Substantiation_Table.xlsx	XLSX spreadsheet	Apr 22, 2019
N6449819R4048_Attachment_1_DD254.pdf	PDF	Apr 22, 2019
N6449819R4048.pdf	PDF	Apr 22, 2019

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.

CPFF Cont Site

SOLICITATION NO. N64498-18-R-0136 - ATTACHMENT 1
COST SUMMARY FORMAT
Prime Offeror Name:	XYZebra
Subcontractor Name (if applicable):	WX
DCAA Point of Contact Information:	Merry Ivy, 123.456.5555, Merry.Ivy@dcaa.mil
		Total for All Years		Year 1			Year 2			Year 3			Year 4			Year 5
Cost Elements	Labor Category	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount
Subcontractor Labor Cost	Contractor Site
Subcontractor - WX	Logistician I	1500	$35,626.86	$ 22.82	300	$6,846.00	$23.28	300	$6,982.92	$23.74	300	$7,122.58	$24.22	300	$7,265.03	$24.70	300	$7,410.33
Subcontractor - WX	ENGINEERING TECHNICIAN IV	1000	$21,909.01	$ 21.05	200	$4,210.00	$21.47	200	$4,294.20	$21.90	200	$4,380.08	$22.34	200	$4,467.69	$22.79	200	$4,557.04
Subcontractor - WX	TECHNICIAN, ENGINEERING VI	5120	$139,351.71	$ 26.15	1024	$26,777.60	$26.67	1024	$27,313.15	$27.21	1024	$27,859.42	$27.75	1024	$28,416.60	$28.31	1024	$28,984.94
Subcontractor - WX	WELDER, COMBINATION, MAINTENANCE I	9330	$252,479.21	$ 26.00	1866	$48,516.00	$26.52	1866	$49,486.32	$27.05	1866	$50,476.05	$27.59	1866	$51,485.57	$28.14	1866	$52,515.28
Subcontractor - WX	MACHINIST, MAINTENANCE I	9000	$254,321.44	$ 27.15	1800	$48,870.00	$27.69	1800	$49,847.40	$28.25	1800	$50,844.35	$28.81	1800	$51,861.23	$29.39	1800	$52,898.46
Subcontractor - WX	ELECTRICIAN, SHIPBOARD I	6080	$181,553.56	$ 28.69	1216	$34,887.04	$29.26	1216	$35,584.78	$29.85	1216	$36,296.48	$30.45	1216	$37,022.41	$31.05	1216	$37,762.85
Subcontractor - WX	PIPEFITTER, MAINTENANCE I	1840	$45,425.86	$ 23.72	368	$8,728.96	$24.19	368	$8,903.54	$24.68	368	$9,081.61	$25.17	368	$9,263.24	$25.68	368	$9,448.51
Subcontractor - WX	PAINTER I	1050	$27,321.21	$ 25.00	210	$5,250.00	$25.50	210	$5,355.00	$26.01	210	$5,462.10	$26.53	210	$5,571.34	$27.06	210	$5,682.77
Subcontractor - WX	SHEET METAL WORKER I	1000	$26,124.28	$ 25.10	200	$5,020.00	$25.60	200	$5,120.40	$26.11	200	$5,222.81	$26.64	200	$5,327.26	$27.17	200	$5,433.81
Labor Sub Total, less Indirect rates or fee			$984,113.14			$189,105.60			$192,887.71			$196,745.47			$200,680.38			$204,693.98
Indirect Rates		21.81%	$214,635.08		21.81%	$41,243.93		21.81%	$42,068.81		21.81%	$42,910.19		21.81%	$43,768.39		21.81%	$44,643.76
Fringe		25.78%	$253,704.37		25.78%	$48,751.42		25.78%	$49,726.45		25.78%	$50,720.98		25.78%	$51,735.40		25.78%	$52,770.11
G&A		13.35%	$193,902.42		13.35%	$37,259.98		13.35%	$38,005.18		13.35%	$38,765.28		13.35%	$39,540.59		13.35%	$40,331.40
Total Indirect Cost			$662,241.86			$127,255.33			$129,800.44			$132,396.45			$135,044.38			$137,745.26
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through		35,921	$1,646,355.00		7,184	$316,360.93		7,185	$322,688.15		7,185	$329,141.91		7,185	$335,724.75		7,185	$342,439.25
Total Labor Cost Subcontractor Labor
Fixed Fee		5%	$82,317.75		5%	$15,818.05		5%	$16,134.41		5%	$16,457.10		5%	$16,786.24		5%	$17,121.96
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)		35,921	$1,728,672.75		7,184	$332,178.98		7,185	$338,822.56		7,185	$345,599.01		7,185	$352,510.99		7,185	$359,561.21

CPFF Gov't Site

SOLICITATION NO. N64498-18-R-0136 - ATTACHMENT 1
COST SUMMARY FORMAT
Prime Offeror Name:	XYZebra
Subcontractor Name (if applicable):	WX
DCAA Point of Contact Information:	Merry Ivy, 123.456.5555, Merry.Ivy@dcaa.mil
		Total for All Years		Year 1			Year 2			Year 3			Year 4			Year 5
Cost Elements	Labor Category	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount
Subcontractor Labor Cost	Government Site
Subcontractor - WX	Logistician I	6000	$142,507.44	$ 22.82	1,200	$27,384.00	$23.28	1,200	$27,931.68	$23.74	1,200	$28,490.31	$24.22	1,200	$29,060.12	$24.70	1,200	$29,641.32
Subcontractor - WX	ENGINEERING TECHNICIAN IV	6000	$131,454.05	$ 21.05	1,200	$25,260.00	$21.47	1,200	$25,765.20	$21.90	1,200	$26,280.50	$22.34	1,200	$26,806.11	$22.79	1,200	$27,342.24
Subcontractor - WX	TECHNICIAN, ENGINEERING VI	20900	$568,838.02	$ 26.15	4,180	$109,307.00	$26.67	4,180	$111,493.14	$27.21	4,180	$113,723.00	$27.75	4,180	$115,997.46	$28.31	4,180	$118,317.41
Subcontractor - WX	WELDER, COMBINATION, MAINTENANCE I	14000	$378,854.12	$ 26.00	2,800	$72,800.00	$26.52	2,800	$74,256.00	$27.05	2,800	$75,741.12	$27.59	2,800	$77,255.94	$28.14	2,800	$78,801.06
Subcontractor - WX	MACHINIST, MAINTENANCE I	13500	$381,482.16	$ 27.15	2,700	$73,305.00	$27.69	2,700	$74,771.10	$28.25	2,700	$76,266.52	$28.81	2,700	$77,791.85	$29.39	2,700	$79,347.69
Subcontractor - WX	ELECTRICIAN, SHIPBOARD I	9120	$272,330.34	$ 28.69	1,824	$52,330.56	$29.26	1,824	$53,377.17	$29.85	1,824	$54,444.71	$30.45	1,824	$55,533.61	$31.05	1,824	$56,644.28
Subcontractor - WX	PIPEFITTER, MAINTENANCE I	5520	$136,277.58	$ 23.72	1,104	$26,186.88	$24.19	1,104	$26,710.62	$24.68	1,104	$27,244.83	$25.17	1,104	$27,789.73	$25.68	1,104	$28,345.52
Subcontractor - WX	PAINTER I	3150	$81,963.63	$ 25.00	630	$15,750.00	$25.50	630	$16,065.00	$26.01	630	$16,386.30	$26.53	630	$16,714.03	$27.06	630	$17,048.31
Subcontractor - WX	SHEET METAL WORKER I	3000	$78,372.84	$ 25.10	600	$15,060.00	$25.60	600	$15,361.20	$26.11	600	$15,668.42	$26.64	600	$15,981.79	$27.17	600	$16,301.43
Labor Sub Total, less Indirect rates or fee			$2,172,080.18			$417,383.44			$425,731.11			$434,245.73			$442,930.65			$451,789.26
Indirect Rates			$473,730.69		21.81%	$91,031.33		21.81%	$92,851.95		21.81%	$94,708.99		21.81%	$96,603.17		21.81%	$98,535.24
Fringe			$559,962.27		25.78%	$107,601.45		25.78%	$109,753.48		25.78%	$111,948.55		25.78%	$114,187.52		25.78%	$116,471.27
G&A			$427,970.71		13.35%	$82,238.17		13.35%	$83,882.93		13.35%	$85,560.59		13.35%	$87,271.80		13.35%	$89,017.23
Total Indirect Cost			$1,461,663.67			$280,870.94			$286,488.36			$292,218.13			$298,062.49			$304,023.74
Handling
G&A
Other (if any)
Total pass through (not including fee)
Total Subcontractor Cost including pass through		81190	$3,633,743.86		16,238	$698,254.38		16,239	$712,219.47		16,239	$726,463.86		16,239	$740,993.14		16,239	$755,813.00
Total Labor Cost Subcontractor Labor
Fixed Fee		5%	$181,687.19		5%	$34,912.72		5%	$35,610.97		5%	$36,323.19		5%	$37,049.66		5%	$37,790.65
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)		81190	$3,815,431.05		16238	$733,167.10		16,239	$747,830.45		16,239	$762,787.05		16,239	$778,042.80		16,239	$793,603.65

File details come from the government source that posted it.