Sample_Project_1_Template_FFP.xlsx

XLSX spreadsheet 45 KB Posted Sep 21, 2017

Attached to: Northwestern Division Regional $75M Section 8(a) SB Set-Aside IDIQ MATOC for Preplaced Remedial Action Contract (PRAC)
Solicitation number: W912DW-17-R-0003
Issued by: Department of the Army Corps of Engineers Engineering District Seattle

About this file

From the source

For Informational Purposes Only - Sample Project 1 Template FFP

View the file

Other files

File	Type	Posted
R0006.pdf	PDF	Oct 31, 2017
Sample_Project_2_Template_CPFF_R0005.xlsx	XLSX spreadsheet	Oct 23, 2017
R0005.pdf	PDF	Oct 23, 2017
Sample_Project_1_Template_FFP_R0005.xlsx	XLSX spreadsheet	Oct 23, 2017
R0004.pdf	PDF	Oct 20, 2017
R0003.pdf	PDF	Oct 12, 2017
R0002.pdf	PDF	Oct 6, 2017
Pre-Award_Information.pdf	PDF	Sep 29, 2017
R0001.pdf	PDF	Sep 22, 2017
RFP_W912DW-17-R-0003.pdf	PDF	Sep 21, 2017
Sample_Project_2_Template_CPFF.xlsx	XLSX spreadsheet	Sep 21, 2017

Show all 11

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.

Cost by Task

SAMPLE PROJECT 1 (See Section J, Att 2 in Solicitation) - for In-situ Chemical Oxidation (ISCO) work and related efforts
Red = update. Enter more rows as needed. Insert "Hours" and "Qty" as appropriate. Double-check spreadsheet cells are calculating appropriately if more rows are inserted.
Summary - Costs by Task		Bid Item 1 - General Conditions		Bid Item 2 - ISCO Hydrogen Peroxide		Bid Item 3 - ICSO Sodium Permanganate		Bid Item 4 -Closeout Report		TOTAL - ALL Costs
	Labor:		$0.00		$0.00		$0.00		$0.00	Labor:	$0.00	$0.00
	Other costs:		$0.00		$0.00		$0.00		$0.00	Other costs:	$0.00	$0.00
	Travel:		$0.00		$0.00		$0.00		$0.00	Travel:	$0.00	$0.00
	TASK Subtotal:		$0.00		$0.00		$0.00		$0.00	TASK Subtotal:	$0.00	$0.00
	Profit (not on travel) - use associated "Profit" tabs:	-	$0.00	-	$0.00	-	$0.00	-	$0.00	Profit (not on travel):	$0.00
	GRAND TOTAL:		$0.00		$0.00		$0.00		$0.00	GRAND TOTAL:	$0.00	$0.00

Labor Category	Rate (enter)	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost	Hours	Cost
Insert your Section B Professional Rates	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
Use Davis-Bacon rates from Sample Project in RFP, as necessary
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
	$0.00		$0.00		$0.00		$0.00		$0.00	0	$0.00
SUBTOTAL LABOR (Direct Labor+Profit)		0	$0.00	0	$0.00	0	$0.00	0	$0.00	0	$0.00	$0.00

Other Costs (Materials, Equipment, Subs, Incidentals) - list items	Unit Cost	Unit	Qty	Cost	Qty	Cost	Qty	Cost	Qty	Cost	Cost
Materials
Permanganate (e.g.)	$0.00	Pound, e.g.		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
Equipment
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
Subcontractors
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
Incidentals
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
SUBTOTAL Other Costs				$0.00		$0.00		$0.00		$0.00	$0.00	$0.00

Travel Costs	Unit Cost	Unit	Qty	Cost	Qty	Cost	Qty	Cost	Qty	Cost	Cost
Airfare	$0.00	Roundtrip, e.g.		$0.00		$0.00		$0.00		$0.00	$0.00
Hotel	$0.00	Night, e.g		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
xxxx	$0.00	xxxx		$0.00		$0.00		$0.00		$0.00	$0.00
SUBTOTAL Travel Costs				$0.00		$0.00		$0.00		$0.00	$0.00	$0.00

Profit

Profit Analysis

FACTOR Multiplier Range Insert Value (0.03 up to .12) RATE PERCENTAGE VALUE

Degree of Risk	.03 - .12	0.00	X	20	=	0.000
Relative Difficulty of Work	.03 - .12	0.00	X	15	=	0.000
Size of Job	.12 - .03	0.00	X	15	=	0.000
Period of Performance	.03 - .12	0.00	X	15	=	0.000
Contractor's Investment	.03 - .12	0.00	X	5	=	0.000
Assistance by Government	.12 - .03	0.00	X	5	=	0.000
Subcontracting	.03 - .12	0.00	X	25	=	0.000
					Profit %=	0.00
Note: edit green-shaded cells only. All others will calculate automatically.

PROFIT PERCENTAGE

REASONS FOR WEIGHTS ASSIGNED

1. Risk:	Where the work involves no risk or the degree of risk is very small, the weighting should be .03; as the degree of risk increases,
	the weighting should be increased up to a maximum of .12. Lump sum items will have, generally, a higher weighted value than
	unit price items for which quantities are provided. Other things to consider, the portion of work to be done by subcontractors,
	nature of work, where work is to be performed, reasonableness of negotiated costs, amount of labor included in costs, whether
	negotiation is before or after performance of work, etc.

2. Difficulty:	If the work is most difficult and complex, the weighting should be .12 and should be proportionately reduced to .03 on the simplest
	jobs. This factor is tied in to some extent with the degree of risk. Some things to consider: the nature of the work, by whom it is
	done, where, what is the time schedule, etc.

3. Size of Job:	All work not in excess of $100,000 shall be weighted at .12. Work estimated between $100,000 and $5,000,000 shall be proportionally
(See tab Profit Factor Tables)	weighted from .12 to .05. Work from $5,000,000 to $10,000,000 shall be weighted at .04 and work in excess of $10,000,000 at .03.

4. Period:	Jobs in excess of 24 months are to be weighted at .12. Jobs of lessor duration are to be proportionately weighted to a minimum of
(See tab Profit Factor Tables)	.03 for jobs not to exceed 30 days. The period applies to only the change -- not the contract duration.

5. Investment:	To be weighted from .03 to .12 on the basis of below average, average, and above average. Things to consider: amount of
	subcontracting, mobilization payment item, Government-furnished property, method of making progress payments, etc.

6. Gov't Assistance:	To be weighted from .12 to .03 on the basis of average to above average. Things to consider: use of Government-owned property,
	equipment and facilities, expediting assistance, etc.

7. Subcontracting:	To be weighted inversely proportional to the amount of subcontracting. Where 80% or more of the work is to be subcontracted,
(See attached table)	the weighting is to be .03 and such weighting proportionally increased to .12 where all the work is performed by the Contractor's
	own forces.

Profit Factor Table

WEIGHTED GUIDELINE

PROFIT FACTOR TABLES

SIZE OF JOB			FACTOR	PERIOD OF PERFORMANCE*					FACTOR
$0	TO	$100,000	0.120		OVER	24	MONTHS	--------------	0.120
100,000	TO	200,000	0.119	23	to	24	MONTHS	--------------	0.116
200,000	TO	300,000	0.117	22	to	23	MONTHS	--------------	0.112
300,000	TO	400,000	0.116	21	to	22	MONTHS	--------------	0.109
400,000	TO	500,000	0.114	20	to	21	MONTHS	--------------	0.105
500,000	TO	600,000	0.113	19	to	20	MONTHS	--------------	0.101
600,000	TO	700,000	0.111	18	to	19	MONTHS	--------------	0.098
700,000	TO	800,000	0.110	17	to	18	MONTHS	--------------	0.094
800,000	TO	900,000	0.109	16	to	17	MONTHS	--------------	0.090
900,000	TO	1,000,000	0.107	15	to	16	MONTHS	--------------	0.086
1,000,000	TO	1,100,000	0.106	14	to	15	MONTHS	--------------	0.082
1,100,000	TO	1,200,000	0.104	13	to	14	MONTHS	--------------	0.079
1,200,000	TO	1,300,000	0.103	12	to	13	MONTHS	--------------	0.075
1,300,000	TO	1,400,000	0.101	11	to	12	MONTHS	--------------	0.071
1,400,000	TO	1,500,000	0.100	10	to	11	MONTHS	--------------	0.068
1,500,000	TO	1,600,000	0.099	9	to	10	MONTHS	--------------	0.064
1,600,000	TO	1,700,000	0.097	8	to	9	MONTHS	--------------	0.060
1,700,000	TO	1,800,000	0.096	7	to	8	MONTHS	--------------	0.056
1,800,000	TO	1,900,000	0.094	6	to	7	MONTHS	--------------	0.052
1,900,000	TO	2,000,000	0.093	5	to	6	MONTHS	--------------	0.049
2,000,000	TO	2,100,000	0.091	4	to	5	MONTHS	--------------	0.045
2,100,000	TO	2,200,000	0.090	3	to	4	MONTHS	--------------	0.041
2,200,000	TO	2,300,000	0.089	2	to	3	MONTHS	--------------	0.038
2,300,000	TO	2,400,000	0.087	1	to	2	MONTHS	--------------	0.034
2,400,000	TO	2,500,000	0.086		UNDER	30	DAYS	--------------	0.030
2,500,000	TO	2,600,000	0.084			0	DAYS	--------------	0.000
2,600,000	TO	2,700,000	0.083
2,700,000	TO	2,800,000	0.081	*THIS IS THE TIME TO ACTUALLY PERFORM
2,800,000	TO	2,900,000	0.080	THE WORK.
2,900,000	TO	3,000,000	0.079
3,000,000	TO	3,100,000	0.077
3,100,000	TO	3,200,000	0.076
3,200,000	TO	3,300,000	0.074
3,300,000	TO	3,400,000	0.073
3,400,000	TO	3,500,000	0.071	SUBCONTRACTING					FACTOR
3,500,000	TO	3,600,000	0.070	SUB -	80%	OR	MORE	--------------	0.030
3,600,000	TO	3,700,000	0.069		70%	TO	80%	--------------	0.042
3,700,000	TO	3,800,000	0.067		60%	TO	70%	--------------	0.055
3,800,000	TO	3,900,000	0.066		50%	TO	60%	--------------	0.068
3,900,000	TO	4,000,000	0.064		40%	TO	50%	--------------	0.080
4,000,000	TO	4,100,000	0.063		30%	TO	40%	--------------	0.092
4,100,000	TO	4,200,000	0.061		20%	TO	30%	--------------	0.105
4,200,000	TO	4,300,000	0.060		10%	TO	20%	--------------	0.118
4,300,000	TO	4,400,000	0.059		0%	TO	9%	--------------	0.120
4,400,000	TO	4,500,000	0.057
4,500,000	TO	4,600,000	0.056
4,600,000	TO	4,700,000	0.054
4,700,000	TO	4,800,000	0.053
4,800,000	TO	4,900,000	0.051
4,900,000	TO	5,000,000	0.050
5,000,000	TO	10,000,000	0.040
OVER		$10,000,000	0.030

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