Attachment_2_-_Cost_and_Price_Summary_Workbook.xlsx

XLSX spreadsheet 143 KB Posted Sep 1, 2016

Attached to: JCREW I1B1 Full Rate Production RFP
Solicitation number: N00024-16-R-6327
Issued by: Department of the Navy Naval Sea Systems Command

About this file

From the source

Attachment 2 Cost and Price Summary Workbook Microsoft Excel spreadsheet 8 tabs (To be submitted with the proposal and finalized at award.)

View the file

Other files

File	Type	Posted
Amendment_0005_Conformed.docx	DOCX document	Nov 1, 2016
Amendment_0005.docx	DOCX document	Nov 1, 2016
Amendment_0004.docx	DOCX document	Oct 24, 2016
Amendment_0004_Conformed.docx	DOCX document	Oct 24, 2016
Attachment_9.pdf	PDF	Oct 5, 2016
Amendment_3_Conformed.docx	DOCX document	Oct 5, 2016
Amendment_3.docx	DOCX document	Oct 5, 2016
RFP_Amendment_0002.docx	DOCX document	Sep 23, 2016
RFP_Amendment_0002_Conformed.docx	DOCX document	Sep 23, 2016
N00024-16-R-6327-0001_Mod.docx	DOCX document	Sep 16, 2016
N00024-16-R-6327-0001_Conformed.docx	DOCX document	Sep 16, 2016
N00024-16-R-6327_2016_Post.docx	DOCX document	Sep 6, 2016
N00024-16-R-6327_2016_Post.docx	DOCX document	Sep 2, 2016
Attachment_1_-_DD254.pdf	PDF	Sep 1, 2016
Attachment_9_-_WBS _Level_3.pdf	PDF	Sep 1, 2016
Attachment_3_-_CDRL_Media_Delivery.docx	DOCX document	Sep 1, 2016
Attachment_13_-_Support_Equipment_Pricing.xlsx	XLSX spreadsheet	Sep 1, 2016
Attachment_5_-_GFI_List.xlsx	XLSX spreadsheet	Sep 1, 2016
Attachment_4_-_JCREW_Bidders_Library.pdf	PDF	Sep 1, 2016
Attachment_16_-_Contractor_Announcement_Info.docx	DOCX document	Sep 1, 2016
Exhibit_A_-_CDRL.pdf	PDF	Sep 1, 2016
Attachment_10_-_Bidder's_Question_Submittal_Form.xlsx	XLSX spreadsheet	Sep 1, 2016
Attachment_12_-_Contractor_Compliance_Checklist.docx	DOCX document	Sep 1, 2016
Attachment_15_-_D-Level_Parts_Pricing.xlsx	XLSX spreadsheet	Sep 1, 2016
Attachment_14_-_O-Level_Parts_Pricing.xlsx	XLSX spreadsheet	Sep 1, 2016
Attachment_4_-_JCREW_Bidders_Library_.pdf	PDF	Jul 14, 2016
Attachment_14_-_O-Level_Parts_Pricing.xlsx	XLSX spreadsheet	Jul 14, 2016
Attachment_15_-_D-Level_Parts_Pricing.xlsx	XLSX spreadsheet	Jul 14, 2016
Attachment_16_-_Contractor_Announcement_Info.docx	DOCX document	Jul 14, 2016
Attachment_9_-_WBS _Level_3.pdf	PDF	Jul 14, 2016
Attachment_3_-_CDRL_Media_Delivery.docx	DOCX document	Jul 14, 2016
Attachment_13_-_Support_Equipment_Pricing.xlsx	XLSX spreadsheet	Jul 14, 2016
Exhibit_A_CDRL.pdf	PDF	Jul 14, 2016
Attachment_10_-_Bidder's_Question_Submittal_Form.xlsx	XLSX spreadsheet	Jul 14, 2016
Attachment_1_-_DD_Form_254.pdf	PDF	Jul 14, 2016
Attachment_5_-_GFI_List.xlsx	XLSX spreadsheet	Jul 14, 2016
N00024-16-R-6327_Draft_RFP.docx	DOCX document	Jul 14, 2016
Attachment_12_-_Contractor_Compliance_Checklist.docx	DOCX document	Jul 14, 2016
Attachment_2_-_Cost_and_Price_Summary_Workbook.xlsx	XLSX spreadsheet	Jul 14, 2016

Show all 39

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.

CLIN Descriptions

ITEM	Description	Type	Notes LEGEND
0001	JCREW I1B1 DISMOUNTED SYSTEMS (See Note G)	FFP	A	Multiple Exercise Option
0002	JCREW I1B1 MOUNTED / FIXED SYSTEMS - (See Note G and H)	FFP	B	Option item
0003	JCREW I1B1 MOUNTED AUXILIARY KITS - (See Note G and H)	FFP	C	Support Equipment Kit Pricing Table w/ Att 13
0004	JCREW I1B1 FIXED AUXILIARY KITS (See Note G and H)	FFP	D	O-Level Parts Kit Pricing Table w/ Att 14
0005	ENGINEERING SUPPORT SERVICES (See Note F)	CPFF	E	D-Level Parts Kit Pricing Table w/ Att 15
0006	OTHER DIRECT COSTS (See Note I)	COST	F	ESS Orders
0007	ORDERING LINE ITEM - PIO	FFP	G	Stepladder Pricing
0008	DATA	NSP	H	Qty ordered for under CLIN 0002 = CLINs 0003 + 00004
0009	FIRST ARTICLE UNITS AND ASSOCIATED TESTS	FFP	I	ODCs

0101	JCREW I1B1 DISMOUNTED SYSTEMS (See Note A, B and G)	FFP
0102	JCREW I1B1 MOUNTED / FIXED SYSTEMS (See Note A, B, G and H)	FFP
0103	JCREW I1B1 MOUNTED AUXILIARY KITS (See Note A, B, G and H)	FFP
0104	JCREW I1B1 FIXED AUXILIARY KITS (See Note A, B, G and H)	FFP
0105	ENGINEERING SUPPORT SERVICES (See Note B and F)	CPFF
0106	OTHER DIRECT COSTS (ODC) (See Note B and I)	COST

0201	JCREW I1B1 DISMOUNTED SYSTEMS (See Note A, B and G)	FFP
0202	JCREW I1B1 MOUNTED / FIXED SYSTEMS (See Note A, B, G and H)	FFP
0203	JCREW I1B1 MOUNTED AUXILIARY KITS(See Note A, B, G and H)	FFP
0204	JCREW I1B1 FIXED AUXILIARY KITS (See Note A, B, G and H)	FFP
0205	ENGINEERING SUPPORT SERVICES (See Note B and F)	CPFF
0206	OTHER DIRECT COSTS (ODC) (See Note B and I)	COST

0301	JCREW I1B1 DISMOUNTED SYSTEMS (See Note A, B and G)	FFP
0302	JCREW I1B1 MOUNTED / FIXED SYSTEMS (See Note A, B, G and H)	FFP
0303	JCREW I1B1 MOUNTED AUXILIARY KITS (See Note A, B, G and H)	FFP
0304	JCREW I1B1 FIXED AUXILIARY KITS (See Note A, B, G and H)	FFP
0305	ENGINEERING SUPPORT SERVICES (See Note B and F)	CPFF
0306	OTHER DIRECT COSTS (ODC) (See Note B and I)	COST

0401	JCREW I1B1 DISMOUNTED SYSTEMS (See Note A, B and G)	FFP
0402	JCREW I1B1 MOUNTED / FIXED SYSTEMS (See Note A, B, G and H)	FFP
0403	JCREW I1B1 MOUNTED AUXILIARY KITS (See Note A, B, G and H)	FFP
0404	JCREW I1B1 FIXED AUXILIARY KITS (See Note A, B, G and H)	FFP
0405	ENGINEERING SUPPORT SERVICES (See Note B and F)	CPFF
0406	OTHER DIRECT COSTS (ODC) (See Note B and I)	COST

1011	JCREW I1B1 O-Level Parts Kit 1 (See Note B and D)	FFP
1012	JCREW I1B1 O-Level Parts Kit 2 (See Note B and D)	FFP
1013	JCREW I1B1 O-Level Parts Kit 3 (See Note B and D)	FFP
1014	JCREW I1B1 O-Level Parts Kit 4 (See Note B and D)	FFP
1015	JCREW I1B1 O-Level Parts Kit 5 (See Note B and D)	FFP
1016	JCREW I1B1 O-Level Parts Kit 6 (See Note B and D)	FFP
1021	JCREW I1B1 Depot Level Parts Kit 1 (See Note B and E)	FFP
1022	JCREW I1B1 Depot Level Parts Kit 2 (See Note B and E)	FFP
1023	JCREW I1B1 Depot Level Parts Kit 3 (See Note B and E)	FFP
1024	JCREW I1B1 Depot Level Parts Kit 4 (See Note B and E)	FFP
1025	JCREW I1B1 Depot Level Parts Kit 5 (See Note B and E)	FFP
1026	JCREW I1B1 Depot Level Parts Kit 6 (See Note B and E)	FFP
1031	JCREW I1B1 Support Equipment Kit 1 (See Note B and C)	FFP
1032	JCREW I1B1 Support Equipment Kit 2 (See Note B and C)	FFP
1033	JCREW I1B1 Support Equipment Kit 3 (See Note B and C)	FFP
1034	JCREW I1B1 Support Equipment Kit 4 (See Note B and C)	FFP
1035	JCREW I1B1 Support Equipment Kit 5 (See Note B and C)	FFP
1036	JCREW I1B1 Support Equipment Kit 6 (See Note B and C)	FFP

2011	JCREW I1B1 O-Level Parts Kit 1 (See Note B and D)	FFP
2012	JCREW I1B1 O-Level Parts Kit 2 (See Note B and D)	FFP
2013	JCREW I1B1 O-Level Parts Kit 3 (See Note B and D)	FFP
2014	JCREW I1B1 O-Level Parts Kit 4 (See Note B and D)	FFP
2015	JCREW I1B1 O-Level Parts Kit 5 (See Note B and D)	FFP
2016	JCREW I1B1 O-Level Parts Kit 6 (See Note B and D)	FFP
2021	JCREW I1B1 Depot Level Parts Kit 1 (See Note B and E)	FFP
2022	JCREW I1B1 Depot Level Parts Kit 2 (See Note B and E)	FFP
2023	JCREW I1B1 Depot Level Parts Kit 3 (See Note B and E)	FFP
2024	JCREW I1B1 Depot Level Parts Kit 4 (See Note B and E)	FFP
2025	JCREW I1B1 Depot Level Parts Kit 5 (See Note B and E)	FFP
2026	JCREW I1B1 Depot Level Parts Kit 6 (See Note B and E)	FFP
2031	JCREW I1B1 Support Equipment Kit 1 (See Note B and C)	FFP
2032	JCREW I1B1 Support Equipment Kit 2 (See Note B and C)	FFP
2033	JCREW I1B1 Support Equipment Kit 3 (See Note B and C)	FFP
2034	JCREW I1B1 Support Equipment Kit 4 (See Note B and C)	FFP
2035	JCREW I1B1 Support Equipment Kit 5 (See Note B and C)	FFP
2036	JCREW I1B1 Support Equipment Kit 6 (See Note B and C)	FFP

3011	JCREW I1B1 O-Level Parts Kit 1 (See Note B and D)	FFP
3012	JCREW I1B1 O-Level Parts Kit 2 (See Note B and D)	FFP
3013	JCREW I1B1 O-Level Parts Kit 3 (See Note B and D)	FFP
3014	JCREW I1B1 O-Level Parts Kit 4 (See Note B and D)	FFP
3015	JCREW I1B1 O-Level Parts Kit 5 (See Note B and D)	FFP
3016	JCREW I1B1 O-Level Parts Kit 6 (See Note B and D)	FFP
3021	JCREW I1B1 Depot Level Parts Kit 1 (See Note B and E)	FFP
3022	JCREW I1B1 Depot Level Parts Kit 2 (See Note B and E)	FFP
3023	JCREW I1B1 Depot Level Parts Kit 3 (See Note B and E)	FFP
3024	JCREW I1B1 Depot Level Parts Kit 4 (See Note B and E)	FFP
3025	JCREW I1B1 Depot Level Parts Kit 5 (See Note B and E)	FFP
3026	JCREW I1B1 Depot Level Parts Kit 6 See Note B and E)	FFP
3031	JCREW I1B1 Support Equipment Kit 1 (See Note B and C)	FFP
3032	JCREW I1B1 Support Equipment Kit 2 (See Note B and C)	FFP
3033	JCREW I1B1 Support Equipment Kit 3 (See Note B and C)	FFP
3034	JCREW I1B1 Support Equipment Kit 4 (See Note B and C)	FFP
3035	JCREW I1B1 Support Equipment Kit 5 (See Note B and C)	FFP
3036	JCREW I1B1 Support Equipment Kit 6 (See Note B and C)	FFP

4011	JCREW I1B1 O-Level Parts Kit 1 (See Note B and D)	FFP
4012	JCREW I1B1 O-Level Parts Kit 2 (See Note B and D)	FFP
4013	JCREW I1B1 O-Level Parts Kit 3 (See Note B and D)	FFP
4014	JCREW I1B1 O-Level Parts Kit 4 (See Note B and D)	FFP
4015	JCREW I1B1 O-Level Parts Kit 5 (See Note B and D)	FFP
4016	JCREW I1B1 O-Level Parts Kit 6 (See Note B and D)	FFP
4021	JCREW I1B1 Depot Level Parts Kit 1 (See Note B and E)	FFP
4022	JCREW I1B1 Depot Level Parts Kit 2 (See Note B and E)	FFP
4023	JCREW I1B1 Depot Level Parts Kit 3 (See Note B and E)	FFP
4024	JCREW I1B1 Depot Level Parts Kit 4 (See Note B and E)	FFP
4025	JCREW I1B1 Depot Level Parts Kit 5 (See Note B and E)	FFP
4026	JCREW I1B1 Depot Level Parts Kit 6 (See Note B and E)	FFP
4031	JCREW I1B1 Support Equipment Kit 1 (See Note B and C)	FFP
4032	JCREW I1B1 Support Equipment Kit 2 (See Note B and C)	FFP
4033	JCREW I1B1 Support Equipment Kit 3 (See Note B and C)	FFP
4034	JCREW I1B1 Support Equipment Kit 4 (See Note B and C)	FFP
4035	JCREW I1B1 Support Equipment Kit 5 (See Note B and C)	FFP
4036	JCREW I1B1 Support Equipment Kit 6 (See Note B and C)	FFP

5011	JCREW I1B1 O-Level Parts Kit 1 (See Note B and D)	FFP
5012	JCREW I1B1 O-Level Parts Kit 2 (See Note B and D)	FFP
5013	JCREW I1B1 O-Level Parts Kit 3 (See Note B and D)	FFP
5014	JCREW I1B1 O-Level Parts Kit 4 (See Note B and D)	FFP
5015	JCREW I1B1 O-Level Parts Kit 5 (See Note B and D)	FFP
5016	JCREW I1B1 O-Level Parts Kit 6 (See Note B and D)	FFP
5021	JCREW I1B1 Depot Level Parts Kit 1 (See Note B and E)	FFP
5022	JCREW I1B1 Depot Level Parts Kit 2 (See Note B and E)	FFP
5023	JCREW I1B1 Depot Level Parts Kit 3 (See Note B and E)	FFP
5024	JCREW I1B1 Depot Level Parts Kit 4 (See Note B and E)	FFP
5025	JCREW I1B1 Depot Level Parts Kit 5 (See Note B and E)	FFP
5026	JCREW I1B1 Depot Level Parts Kit 6 (See Note B and E)	FFP
5031	JCREW I1B1 Support Equipment Kit 1 (See Note B and C)	FFP
5032	JCREW I1B1 Support Equipment Kit 2 (See Note B and C)	FFP
5033	JCREW I1B1 Support Equipment Kit 3 (See Note B and C)	FFP
5034	JCREW I1B1 Support Equipment Kit 4 (See Note B and C)	FFP
5035	JCREW I1B1 Support Equipment Kit 5 (See Note B and C)	FFP
5036	JCREW I1B1 Support Equipment Kit 6 (See Note B and C)	FFP

Base Year Summary N00024-16-R-6327

Attachment 2 - Cost and Price Summary Workbook

CLIN

0001

0002

0003

0004

0005

0006

0009

1011

1012

1013

1014

1015

1016

1021

1022

1023

1024

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Direct Material

Material Overhead

Major Subcontracts

Other Subcontracts

Interdivisional Transfer (at cost)

Total Material

Direct Labor (Hours)	49,572
Direct Labor ($)

Subcontractor Labor (Hours)

Subcontractor Labor ($)

Total Labor

Other Direct Costs

Fringe Rate (%)

Fringe Cost ($)

Overhead Rate (%)

Overhead Cost ($)

G&A Rate (%)

G & A Cost ($)

Total Indirect Cost

Facilities Capital Cost of Money (FCCM)

Subtotal Cost

Profit/Fixed Fee

Price or Total Cost* $ 293,059.76 $ 400,000.00

* For CLINs 0001-0004 This shall represent the unit cost for each step. For all other CLINs this total shall represent the total price/total cost of the CLIN

&"Times New Roman,Bold"&14N00024-12-R-5319

PRICE/COST BREAKDOWN SUMMARY (TY $) - Development CLINs

&"Times New Roman,Bold"&22Table 1.1

Option Year 1 Summary N00024-16-R-6327

Attachment 2 - Cost and Price Summary Workbook

CLIN

0101

0102

0103

0104

0105

0106

2011

2012

2013

2014

2015

2016

2021

2022

2023

2024

2025

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Direct Material

Material Overhead

Major Subcontracts

Other Subcontracts

Interdivisional Transfer (at cost)

Total Material

Direct Labor (Hours)	66,861
Direct Labor ($)

Subcontractor Labor (Hours)

Subcontractor Labor ($)

Total Labor

Other Direct Costs

Fringe Rate (%)

Fringe Cost ($)

Overhead Rate (%)

Overhead Cost ($)

G&A Rate (%)

G & A Cost ($)

Total Indirect Cost

Facilities Capital Cost of Money (FCCM)

Subtotal Cost

Profit/Fixed Fee

Price or Total Cost* $ 298,920.95 $ 550,000.00

* For CLINs 0101-0104This shall represent the unit cost for each step. For all other CLINs this total shall represent the total price/total cost of the CLIN

PRICE/COST BREAKDOWN SUMMARY (TY $) - Development CLINs

&"Times New Roman,Bold"&22Table 1.1

Option Year 2 Summary N00024-16-R-6327

Attachment 2 - Cost and Price Summary Workbook

CLIN

0201

0202

0203

0204

0205

0206

3011

3012

3013

3014

3015

3016

3021

3022

3023

3024

3025

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Direct Material

Material Overhead

Major Subcontracts

Other Subcontracts

Interdivisional Transfer (at cost)

Total Material

Direct Labor (Hours)	47,072
Direct Labor ($)

Subcontractor Labor (Hours)

Subcontractor Labor ($)

Total Labor

Other Direct Costs

Fringe Rate (%)

Fringe Cost ($)

Overhead Rate (%)

Overhead Cost ($)

G&A Rate (%)

G & A Cost ($)

Total Indirect Cost

Facilities Capital Cost of Money (FCCM)

Subtotal Cost

Profit/Fixed Fee

Price or Total Cost* $ 304,899.39 $ 400,000.00

* For CLINs 0201-0204 This shall represent the unit cost for each step. For all other CLINs this total shall represent the total price/total cost of the CLIN

PRICE/COST BREAKDOWN SUMMARY (TY $) - Development CLINs

&"Times New Roman,Bold"&22Table 1.1

Option Year 3 Summary N00024-16-R-6327

Attachment 2 - Cost and Price Summary Workbook

CLIN

0301

0302

0303

0304

0305

0306

4011

4012

4013

4014

4015

4016

4021

4022

4023

4024

4025

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Direct Material

Material Overhead

Major Subcontracts

Other Subcontracts

Interdivisional Transfer (at cost)

Total Material

Direct Labor (Hours)	29,835
Direct Labor ($)

Subcontractor Labor (Hours)

Subcontractor Labor ($)

Total Labor

Other Direct Costs

Fringe Rate (%)

Fringe Cost ($)

Overhead Rate (%)

Overhead Cost ($)

G&A Rate (%)

G & A Cost ($)

Total Indirect Cost

Facilities Capital Cost of Money (FCCM)

Subtotal Cost

Profit/Fixed Fee

Price or Total Cost* $ 310,995.03 $ 250,000.00

* For CLINs 0301-0304 This shall represent the unit cost for each step. For all other CLINs this total shall represent the total price/total cost of the CLIN

PRICE/COST BREAKDOWN SUMMARY (TY $) - Development CLINs

&"Times New Roman,Bold"&22Table 1.1

Option Year 4 Summary N00024-16-R-6327

Attachment 2 - Cost and Price Summary Workbook

CLIN

0401

0402

0403

0404

0405

0406

5011

5012

5013

5014

5015

5016

5021

5022

5023

5024

5025

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step 9

Direct Material

Material Overhead

Major Subcontracts

Other Subcontracts

Interdivisional Transfer (at cost)

Total Material

Direct Labor (Hours)	29,835
Direct Labor ($)

Subcontractor Labor (Hours)

Subcontractor Labor ($)

Total Labor

Other Direct Costs

Fringe Rate (%)

Fringe Cost ($)

Overhead Rate (%)

Overhead Cost ($)

G&A Rate (%)

G & A Cost ($)

Total Indirect Cost

Facilities Capital Cost of Money (FCCM)

Subtotal Cost

Profit/Fixed Fee

Price or Total Cost* $ 317,207.89 $ 250,000.00

* For CLINs 0401-0404 This shall represent the unit cost for each step. For all other CLINs this total shall represent the total price/total cost of the CLIN

PRICE/COST BREAKDOWN SUMMARY (TY $) - Development CLINs

&"Times New Roman,Bold"&22Table 1.1

ESS Cost Summary Format

Prime Offeror Name:		Escalation
Subcontractor Name (if applicable):		Option 1	Option 2	Option 3	Option 4
DCAA Point of Contact Information:	10000000	2%	2%	2%	2%

					CLIN 0005			CLIN 0105			CLIN 0205			CLIN 0305			CLIN 0405
Cost Elements	Labor Category	Years of Applicable Experience	Highest Degree	Degree Area	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount	Rate	Hours	Amount
Prime Contractor Labor Cost
Prime Contractor Direct Labor
Smith, John	LABOR 1				$50	1920	$ 96,000.00	$ 51.00	1920	$ 97,920.00	$ 52.02	1920	$ 99,878.40	$ 53.06	1920	$ 101,875.20	$ 54.12	1920	$ 103,910.40
Total Prime Contractor Direct Labor							$ 96,000.00			$ 97,920.00			$ 99,878.40			$ 101,875.20			$ 103,910.40

Prime Contractor Indirect Labor Cost
Fringe Benefits	30.00%	$ 28,800.00	30.00%	$ 29,376.00	30.00%	$ 29,963.52	30.00%	$ 30,562.56	30.00%	$ 31,173.12
Overhead	34.05%	$ 42,489.84	34.05%	$ 43,339.63	34.05%	$ 44,206.43	34.05%	$ 45,090.22	34.05%	$ 45,991.00
G&A	10.00%	$ 16,728.98	10.00%	$ 17,063.56	10.00%	$ 17,404.84	10.00%	$ 17,752.80	10.00%	$ 18,107.45
Total Indirect Labor Cost		$ 88,018.82		$ 89,779.19		$ 91,574.79		$ 93,405.58		$ 95,271.57
Total Direct and Indirect Labor cost		$ 184,018.82		$ 187,699.19		$ 191,453.19		$ 195,280.78		$ 199,181.97
COM		$ - 0		$ - 0		$ - 0		$ - 0		$ - 0
Total Prime Contractor Labor Cost		$ 184,018.82		$ 187,699.19		$ 191,453.19		$ 195,280.78		$ 199,181.97

Subcontractor Labor Cost
Subcontractor proposed cost and fee
Subcontractor - Company X
Sample, Jane	LABOR 2	$50	1920	$ 96,000.00	$ 51.00	1920	$ 97,920.00	$ 52.02	1920	$ 99,878.40	$ 53.06	1920	$ 101,875.20	$ 54.12	1920	$ 103,910.40
			1920	$ 96,000.00		1920	$ 97,920.00		1920	$ 99,878.40		1920	$ 101,875.20		1920	$ 103,910.40

Total proposed subcontractor labor cost and fee 1920 $ 96,000.00 1,920 $ 97,920.00 1,920 $ 99,878.40 1,920 $ 101,875.20 1,920 $ 103,910.40

Prime contractor pass through (not including fee)
Handling	4.00%		$ 3,840.00	4.00%		$ 3,916.80	4.00%		$ 3,995.14	4.00%		$ 4,075.01	4.00%		$ 4,156.42
G&A
Other (if any)
Total pass through (not including fee)			$ 3,840.00			$ 3,916.80			$ 3,995.14			$ 4,075.01			$ 4,156.42
Total Subcontractor Cost including pass through		1920	$ 99,840.00		1920	$ 101,836.80		1920	$ 103,873.54		1920	$ 105,950.21		1920	$ 108,066.82

Total Labor Cost (Prime and Subcontractor Labor) 1920 $ 283,858.82 1920 $ 289,535.99 1920 $ 295,326.73 1920 $ 301,230.99 1920 $ 307,248.79

Fee
Fixed Fee	5.00%	$ 9,200.94	5.00%	$ 9,384.96	5.00%	$ 9,572.66	5.00%	$ 9,764.04	5.00%	$ 9,959.10
Total Fixed Fee		$ 9,200.94		$ 9,384.96		$ 9,572.66		$ 9,764.04		$ 9,959.10

Total Labor Cost Plus Fixed Fee (CPFF) 1920 $ 293,059.76 1920 $ 298,920.95 1920 $ 304,899.39 1920 $ 310,995.03 1920 $ 317,207.89

Note: Labor Hours for each CLIN shall total to the Labor Hours requested in RFP Section L as follows:
CLIN 0005	49,572
CLIN 0105	66,861
CLIN 0205	47,072
CLIN 0305	29,835
CLIN 0405	29,835

Sample Indirect Rate Support Sample Indirect Rate Supporting Documentation

SAMPLE	Budget	Actual Expenses
Overhead Expense	2017	2016 Final	2015 Final	2014 Final	SAMPLE	2016 Provisional Billing	2015 Provisional Billing	2014 Provisional Billing
Payroll Taxes	$ 635,463	$ 400,000	$ 450,000	$ 425,000		30.00%	34.00%	32.00%	SAMPLE
Vacation	$ 314,315	$ 220,000	$ 215,000	$ 210,000
Holiday	$ 273,317	$ 180,000	$ 195,000	$ 192,500		2016 Final	2015 Final	2014 Final
Sick Leave	$ 61,496	$ 40,000	$ 40,000	$ 35,000		33.25%	38.61%	35.07%	SAMPLE
Pensions	$ 1,195,764	$ 900,000	$ 825,000	$ 775,000
Office Equipment	$ 40,998	$ 35,000	$ 325,000	$ 15,000
Depreciation	$ 6,833	$ 5,000	$ 20,000	$ 10,000
Travel	$ 239,153	$ 175,000	$ 165,000	$ 165,000
Reproduction	$ 66,963	$ 49,000	$ 48,500	$ 48,000
Rent	$ 560,301	$ 410,000	$ 375,000	$ 340,000
Advertising	$ 300,649	$ 220,000	$ 250,000	$ 210,000	SAMPLE
Insurance	$ 314,315	$ 230,000	$ 220,000	$ 210,000
Telephone	$ 81,995	$ 60,000	$ 57,500	$ 50,000
Total Pool	$ 4,091,561	$ 2,924,000	$ 3,186,000	$ 2,685,500
SAMPLE
Less Unallowable Costs
Entertainment	$ 6,000	$ 4,000	$ 1,000	$ 3,000
Net Allowable Costs	$ 4,085,561	$ 2,920,000	$ 3,185,000	$ 2,682,500	SAMPLE

Allocation Base
Direct Labor	$ 12,000,000	$ 8,781,000	$ 8,250,000	$ 7,650,000

Overhead Rate 34.05% 33.25% 38.61% 35.07%

*Contributing Government Contracts	Expiration Date	Expected Award Date	Expected Value of Winning (%)	Direct Labor $
N000XX-XX-X-00XX			50%	$ 2,000,000
N000XX-XX-X-00XX			100%	$ 5,000,000	SAMPLE
N000XX-XX-X-00XX			75%	$ 8,000,000

* When developing your forecasted rate these are the contracts contributing to the allocation base

This is the start of the file's text. The full file is on GovTribe.

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