Attachment F Government Contract Cost Analysis Worksheet.xls

XLS spreadsheet 165 KB Posted Jun 24, 2014

Attached to: Job Order Contract Federal contract opportunity
Solicitation number: N4425514R9010
Issued by: Department of the Navy Naval Facilities Engineering Command

About this file

From the source

Attachment F Government Contract Cost Analysis Worksheet

View the file

Other files for this federal contract opportunity

Other files attached to Job Order Contract, newest first.
File	Type	Posted
N44255-14-R-9010_Amendment_0007.pdf	PDF	Aug 6, 2014
N44255-14-R-9010_Amendment_0006.pdf	PDF	Jul 31, 2014
N44255-14-R-9010_PPI_Log.xlsx	XLSX spreadsheet	Jul 31, 2014
Attachment_D_PPQ_Construction_Experience_072914.docx	DOCX document	Jul 29, 2014
N44255-14-R-9010_Amendment_0005.pdf	PDF	Jul 29, 2014
Attachment_C_Construction_Experience_Data_Sheet_072914.docx	DOCX document	Jul 29, 2014
Attachment_B_Co-Efficient_Table_(Amendment_0004).xls	XLS spreadsheet	Jul 28, 2014
N44255-14-R-9010_Amendment_0004.pdf	PDF	Jul 28, 2014
N44255-14-R-9010_PPI_Log.xlsx	XLSX spreadsheet	Jul 28, 2014
N44255-14-R-9010_PPI_Log.xlsx	XLSX spreadsheet	Jul 16, 2014
N44255-14-R-9010_Amendment_0003.pdf	PDF	Jul 16, 2014
N44255-14-R-9010_PPI_Log.xlsx	XLSX spreadsheet	Jul 11, 2014
N44255-14-R-9010_Amendment_0002.pdf	PDF	Jul 11, 2014
N44255-14-R-9010_Pre-Proposal_Conference_Sign_In.pdf	PDF	Jul 2, 2014
N44255-14-R-9010_Amendment_0001.pdf	PDF	Jun 24, 2014
Attachment D PPQ Construction Experience.docx	DOCX document	Jun 24, 2014
Attachment B Co-Efficient Table.xls	XLS spreadsheet	Jun 24, 2014
Attachment A PPI Form.doc	DOC document	Jun 24, 2014
N44255-14-R-9010 Solicitation.pdf	PDF	Jun 24, 2014
Attachment C Construction Experience Data Sheet.docx	DOCX document	Jun 24, 2014
Attachment E Past Performance Worksheet for Safety.docx	DOCX document	Jun 24, 2014
Pre_Solicitation_Notice_N44255-14-D-9010.pdf	PDF	May 30, 2014

Show all 22

On GovTribe

Work with this file on GovTribe

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.

Summary 4330

GOVERNMENT CONTRACT COST ANALYSIS WORKSHEET				DATE:	4-Apr-14
CONTRACT TITLE: JOB ORDER CONTRACT				CONTRACT NO:
				TASK ORDER NO:
DESCRIPTION:				PC No:
			Version:
PRIME PRE-PRICED WORK:					Notes
1. Means Bare Direct Material Costs			$0.00
2. Means Bare Direct Labor Costs			$0.00
3. Means Bare Direct Rental Equipment Costs			$0.00
4. Subtotal				$0.00	1 + 2 + 3
5. Applicable City Price Index (CPI)				$0.00	CPI x 4
6. Coefficient				$0.00	Coefficient x 5
7. Material and Rental Equipment Sale/Use Tax			$0.00		Sales Tax x (1 + 3)
8. Subtotal				$0.00	6 + 7
9. Task Order Unique Items
10. Pre-Priced Work Total				$0.00	8 + 9
PRIME PRE-PRICED WORK (OVERTIME)
1. Means Bare Direct Material Costs			$0.00
2. Means Bare Direct Labor Costs			$0.00
3. Means Bare Direct Rental Equipment Costs			$0.00
4. Subtotal				$0.00	1 + 2 + 3
5. Applicable City Price Index (CPI)				$0.00	CPI x 4
6. Coefficient				$0.00	Coefficient x 5
7. Material and Rental Equipment Sale/Use Tax			$0.00		Sales Tax x (1 + 3)
8. Subtotal				$0.00	6 + 7
9. Task Order Unique Items
10. Pre-Priced Work Total (Overtime)				$0.00	8 + 9
11. Prime Pre-Priced Work Total				$0.00	Total of Block 10s
PRIME NON-PRE-PRICED WORK (SELF PERFORMANCE):					Notes
1. Direct Material Costs			$0.00
2. Direct Labor Costs			$0.00
3. Direct Rental Equipment Costs			$0.00
4. Subtotal				$0.00	1 + 2 + 3
5. Coefficient				$0.00	Coefficient x 4
6. Material and Rental Equipment Sale/Use Tax			$0.00		Sales Tax x (1 + 3)
7. Subtotal				$0.00	5 + 6
8. Equipment Ownership and Operating Costs			$0.00
9. Task Order Unique Items
10. Prime Non-Pre-Priced Work Total				$0.00	7 + 8 + 9
SUBCONTRACTOR (1) NAME:	Subcontractor 1
12. Fully Burdened Material Costs			$0.00
13. Fully Burdened Labor Costs			$0.00
14. Fully Burdened Equipment Costs			$0.00
15. Subtotal				$0.00	12 + 13 + 14
16. Coefficient				$0.00	Coefficient x 15
17. Equipment Ownership and Operating Costs			$0.00
18. Task Order Unique Items
19. Subcontractor (1) Work Total				$0.00	16 + 17 + 18
SUBCONTRACTOR (2) NAME:	Subcontractor 2
12. Fully Burdened Material Costs			$0.00
13. Fully Burdened Labor Costs			$0.00
14. Fully Burdened Equipment Costs			$0.00
15. Subtotal				$0.00	12 + 13 + 14
16. Coefficient				$0.00	Coefficient x 15
17. Equipment Ownership and Operating Costs			$0.00
18. Task Order Unique Items
19. Subcontractor (2) Work Total				$0.00	16 + 17 + 18
SUBCONTRACTOR (3) NAME:	Subcontractor 3
12. Fully Burdened Material Costs			$0.00
13. Fully Burdened Labor Costs			$0.00
14. Fully Burdened Equipment Costs			$0.00
15. Subtotal				$0.00	12 + 13 + 14
16. Coefficient				$0.00	Coefficient x 15
17. Equipment Ownership and Operating Costs			$0.00
18. Task Order Unique Items
19. Subcontractor (3) Work Total				$0.00	16 + 17 + 18
SUBCONTRACTOR (4) NAME:	Subcontractor 4
12. Fully Burdened Material Costs			$0.00
13. Fully Burdened Labor Costs			$0.00
14. Fully Burdened Equipment Costs			$0.00
15. Subtotal				$0.00	12 + 13 + 14
16. Coefficient				$0.00	Coefficient x 15
17. Equipment Ownership and Operating Costs			$0.00
18. Task Order Unique Items
19. Subcontractor (4) Work Total				$0.00	16 + 17 + 18
SUBCONTRACTOR (5) NAME:	Subcontractor 5
12. Fully Burdened Material Costs			$0.00
13. Fully Burdened Labor Costs			$0.00
14. Fully Burdened Equipment Costs			$0.00
15. Subtotal				$0.00	12 + 13 + 14
16. Coefficient				$0.00	Coefficient x 15
17. Equipment Ownership and Operating Costs			$0.00
18. Task Order Unique Items
19. Subcontractor (5) Work Total				$0.00	16 + 17 + 18
		SUMMARY
20. Prime Contractor's Work			$0.00
21. Sub-Contractor's Work
22. TOTAL COST				$0
NOTES:
Signature & Title of preparer(s)

&CAttachment F

Prime Pre-Priced Work

PRIME PRE-PRICED WORK/BREAK DOWN OF MEANS COSTS							Contract No:	0			Task Order:	0	PC:	0		Date:	4-Apr-14
RS MEANS WORK ITEM	MATERIAL				LABOR			RENTAL EQUIPMENT				OWNED EQUIPMENT
	Qty	Unit	Unit Cost	Total	Hrs	Labor Rate	Total	Qty	Unit	Unit Rate	Total	Qty	Unit	Unit Rate	Total	NOTE	Technical Review Comments
				$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				$0.00				$0.00
TOTALS >>>>>>>>>>				$0.00			$0.00				$0.00				$0.00
OVERTIME WORK
RS MEANS WORK ITEM	MATERIAL				LABOR			RENTAL EQUIPMENT				OWNED EQUIPMENT
	Qty	Unit	Unit Cost	Total	Hrs	Labor Rate	Total	Qty	Unit	Unit Rate	Total	Qty	Unit	Unit Rate	Total	NOTE	Technical Review Comments
				$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				$0.00				$0.00
TOTALS >>>>>>>>>>				$0.00			$0.00				$0.00				$0.00
Notes for Contractor:
1) Using the Task Order RFP, identify all specific project work items.
2) Using the R.S. MEANS Workbook identified in the Task Order RFP, find the bare cost for material, labor, and equipmetn for each work item identified.
3) The bare costs will automatically calculate on the Summary 4330 tab.
4) Look up the City Price Index (CPI) as identified in the Task Order RFP. The CPI is located in the back of the R.S. MEANS Workbook.
5) Using the Weighted Guidelines row o the applicable CPI, determine the percentage markup to bare costs. Enter this as a percentage into the "Applicable City Price Index" row on the Summary 4330 tab (Line 5).
6) Enter the applicable Contract Coefficient as a percentage into the "Coefficient" row on the Summary 4330 tab (Line 6). The applicable Contract Coefficients for pre-priced items are identified in Attachment J-L.4 of this solicitation, SLINs 0001 through 0006. The Contract Coefficient will be negotiated prior to award of the contract.
1. Proposals must clearly state a break down of costs (DFAR 252.236-7000). Lump sum costs will not be accepted in either the prime or subcontractor's break down of direct costs.
2. The contractor shall not proceed with any of the work prior to receipt of an executed contract or modification.
Notes for Government Evaluator(s):
1. Reflect adjustments to subcontractor proposal by noting difference (change in units or rates and quantities) and justify difference with sound basis (i.e. RS MEANS reference, previous historical data, market research, etc.) in the technical review comment

Prime Non-Pre-Priced Work

PRIME NON-PRE-PRICED WORK							Contract No:	0			Task Order:	0	PC:	0		Date:	4-Apr-14
WORK ELEMENT	MATERIAL				LABOR			RENTAL EQUIPMENT				OWNED EQUIPMENT
	Qty	Unit	Unit Cost	Total	Hrs	Labor Rate	Total	Qty	Unit	Unit Rate	Total	Qty	Unit	Unit Rate	Total	NOTE	Technical Review Comments
				$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				$0.00				$0.00
TOTALS >>>>>>>>>>				$0.00			$0.00				$0.00				$0.00
Notes for Contractor:
1. Proposals must clearly state a break down of costs (DFAR 252.236-7000). Lump sum costs will not be accepted in either the prime or subcontractor's break down of direct costs.
2. The contractor shall not proceed with any of the work prior to receipt of an executed contract or modification.
Notes for Government Evaluator(s):
1. Reflect adjustments to subcontractor proposal by noting difference (change in units or rates and quantities) and justify difference with sound basis (i.e. RS MEANS reference, previous historical data, market research, etc.) in the technical review comment

Sub (1) Proposal

BREAK DOWN OF DIRECT COSTS							Contract No:	0			Task Order:	0	PC:	0		Date:	4-Apr-14
SUBCONTRACTOR:	Subcontractor 1
ITEMS OF WORK FOR	MATERIAL				LABOR			RENTAL EQUIPMENT				OWNED EQUIPMENT
	Qty	Unit	Unit Cost	Total	Hrs	Labor Rate	Total	Qty	Unit	Unit Rate	Total	Qty	Unit	Unit Rate	Total	NOTES:	Technical Review Comments
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
TOTALS >>>>>>>>>>				$0.00			$0.00				$0.00				$0.00
										Project Total:	$0
Notes for Contractor:
1. Proposals must clearly state a break down of costs (DFAR 252.236-7000). Lump sum costs will not be accepted in either the prime or subcontractor's break down of direct costs.
2. The contractor shall not proceed with any of the work prior to receipt of an executed contract or modification.
Notes for Government Evaluator(s):
1. Reflect adjustments to subcontractor proposal by noting difference (change in units or rates and quantities) and justify difference with sound basis (i.e. RS MEANS reference, previous historical data, market research, etc.) in the technical review comment

Sub (2) Proposal

BREAK DOWN OF DIRECT COSTS							Contract No:	0			Task Order:	0	PC:	0		Date:	4-Apr-14
SUBCONTRACTOR:	Subcontractor 2
ITEMS OF WORK FOR	MATERIAL				LABOR			RENTAL EQUIPMENT				OWNED EQUIPMENT
	Qty	Unit	Unit Cost	Total	Hrs	Labor Rate	Total	Qty	Unit	Unit Rate	Total	Qty	Unit	Unit Rate	Total	NOTES:	Technical Review Comments
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
TOTALS >>>>>>>>>>				$0.00			$0.00				$0.00				$0.00
										Project Total:	$0
Notes for Contractor:
1. Proposals must clearly state a break down of costs (DFAR 252.236-7000). Lump sum costs will not be accepted in either the prime or subcontractor's break down of direct costs.
2. The contractor shall not proceed with any of the work prior to receipt of an executed contract or modification.
Notes for Government Evaluator(s):
1. Reflect adjustments to subcontractor proposal by noting difference (change in units or rates and quantities) and justify difference with sound basis (i.e. RS MEANS reference, previous historical data, market research, etc.) in the technical review comment

Sub (3) Proposal

BREAK DOWN OF DIRECT COSTS							Contract No:	0			Task Order:	0	PC:	0		Date:	4-Apr-14
SUBCONTRACTOR:	Subcontractor 3
ITEMS OF WORK FOR	MATERIAL				LABOR			RENTAL EQUIPMENT				OWNED EQUIPMENT
	Qty	Unit	Unit Cost	Total	Hrs	Labor Rate	Total	Qty	Unit	Unit Rate	Total	Qty	Unit	Unit Rate	Total	NOTES:	Technical Review Comments
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
TOTALS >>>>>>>>>>				$0.00			$0.00				$0.00				$0.00
										Project Total:	$0
Notes for Contractor:
1. Proposals must clearly state a break down of costs (DFAR 252.236-7000). Lump sum costs will not be accepted in either the prime or subcontractor's break down of direct costs.
2. The contractor shall not proceed with any of the work prior to receipt of an executed contract or modification.
Notes for Government Evaluator(s):
1. Reflect adjustments to subcontractor proposal by noting difference (change in units or rates and quantities) and justify difference with sound basis (i.e. RS MEANS reference, previous historical data, market research, etc.) in the technical review comment

Sub (4) Proposal

BREAK DOWN OF DIRECT COSTS							Contract No:	0			Task Order:	0	PC:	0		Date:	4-Apr-14
SUBCONTRACTOR:	Subcontractor 4
ITEMS OF WORK FOR	MATERIAL				LABOR			RENTAL EQUIPMENT				OWNED EQUIPMENT
	Qty	Unit	Unit Cost	Total	Hrs	Labor Rate	Total	Qty	Unit	Unit Rate	Total	Qty	Unit	Unit Rate	Total	NOTES:	Technical Review Comments
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
TOTALS >>>>>>>>>>				$0.00			$0.00				$0.00				$0.00
										Project Total:	$0
Notes for Contractor:
1. Proposals must clearly state a break down of costs (DFAR 252.236-7000). Lump sum costs will not be accepted in either the prime or subcontractor's break down of direct costs.
2. The contractor shall not proceed with any of the work prior to receipt of an executed contract or modification.
Notes for Government Evaluator(s):
1. Reflect adjustments to subcontractor proposal by noting difference (change in units or rates and quantities) and justify difference with sound basis (i.e. RS MEANS reference, previous historical data, market research, etc.) in the technical review comment
				- 0

Sub (5) Proposal

BREAK DOWN OF DIRECT COSTS							Contract No:	0			Task Order:	0	PC:	0		Date:	4-Apr-14
SUBCONTRACTOR:	Subcontractor 5
ITEMS OF WORK FOR	MATERIAL				LABOR			RENTAL EQUIPMENT				OWNED EQUIPMENT
	Qty	Unit	Unit Cost	Total	Hrs	Labor Rate	Total	Qty	Unit	Unit Rate	Total	Qty	Unit	Unit Rate	Total	NOTES:	Technical Review Comments
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
				$0			$0				$0				$0.00
TOTALS >>>>>>>>>>				$0.00			$0.00				$0.00				$0.00
										Project Total:	$0
Notes for Contractor:
1. Proposals must clearly state a break down of costs (DFAR 252.236-7000). Lump sum costs will not be accepted in either the prime or subcontractor's break down of direct costs.
2. The contractor shall not proceed with any of the work prior to receipt of an executed contract or modification.
Notes for Government Evaluator(s):
1. Reflect adjustments to subcontractor proposal by noting difference (change in units or rates and quantities) and justify difference with sound basis (i.e. RS MEANS reference, previous historical data, market research, etc.) in the technical review comment

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