Attachment 3 CLIN Pricing Worksheet.xlsx

XLSX spreadsheet 74 KB Posted May 17, 2021

Attached to: WRDA Tree Service MATOC Federal contract opportunity
Solicitation number: W9123821R0057
Issued by: Department of the Army Corps of Engineers Engineering District Sacramento

View the file

Other files for this federal contract opportunity

Other files attached to WRDA Tree Service MATOC, newest first.
File	Type	Posted
Sacramento Weir.pdf	PDF	May 26, 2021
Attachment 1 WRDA16 Tree Service MATOC PWS Final Revised 5-25-21.docx	DOCX document	May 26, 2021
Questions Responses.docx	DOCX document	May 26, 2021
ARCF limits.pdf	PDF	May 26, 2021
SREL_ConstructionSeasons Graphic.pdf	PDF	May 26, 2021
W9123821R0057 Letter RFP Amendment 1.pdf	PDF	May 26, 2021
Attachment 2 QASP.docx	DOCX document	May 17, 2021
Attachment 6 Past Performance References.doc	DOC document	May 17, 2021
Attachment 5 Provisions and Clauses.docx	DOCX document	May 17, 2021
W9123821R0057 Letter RFP.pdf	PDF	May 17, 2021
Attachment 4 CLIN Details and Quantities.docx	DOCX document	May 17, 2021
Attachment 1 WRDA16 Tree Service MATOC PWS Final.docx	DOCX document	May 17, 2021

Show all 12

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.

Instructions Proposal Template

GENERAL INFORMATION

The Government template is for guidance purposes, and is not all inclusive. This template serves as an illustration of the format and details required to complete the Government cost/price evaluation.

The Offeror is responsible to ensure compliance with federal regulations and provide the necessary data as required by the request for proposal/quotation (RFP/RFQ).

Offeror shall complete the Government issued template as instructed:

1) Complete the CLIN Summary and all corresponding sheets.

The Government must be able to verify and track all proposed pricing from the proposed details through to the CLIN Summary.

All links to the corresponding sheet/cells shall be made/linked prior to submitting a proposal

Note, that it is the Offeror's responsibility to ensure the calculations are correct.

2) The spreadsheet shall include all formulas.

3) The Offeror shall provide the required detailed as instructed in the RFP/RFQ.

4) The Contractor shall not include any "pricing notes" in the proposal template.

5) The Offeror can add additional rows/columns or tabs in the template as necessary.

If additional tabs are necessary to reflect further details, the costs on subordinate tabs shall roll up to the appriopriate sheets.

In addition, the Offeror can provide supporting documentation through an attachment if required. The information provided shall allow traceability between the proposed price included in the cost/price template and any provided source information.

CLIN Summary

Proposal Template
	COMPLETE THE FOLLOWING:
Solicitation Title
Solicitation Number
Contractor Name
Cage Code
Contract Vehicle
Date

CLIN STRUCTURE SUMMARY
CLIN Number	CLIN Description	Contract Type	Base Period	Option Period 1	Option Period 2	Option Period 3	Option Period 4	Subtotal	6-Month Ext*	Total Price
0001	Administration FY21	FFP						$ - 0	$ - 0	$ - 0
0001AA	Submittals - Owner	FFP						$ - 0	$ - 0	$ - 0
0001AB	Submittals - Elderberry Shrub	FFP						$ - 0	$ - 0	$ - 0
0001AC	Precon - Arborist	FFP						$ - 0	$ - 0	$ - 0
0001AD	Precon Tree Saw Equipment Operators	FFP						$ - 0	$ - 0	$ - 0
0001AE	Precon Tree Ground Personnel Laborers	FFP						$ - 0	$ - 0	$ - 0
0001AF	Precon Elderberry Sub-Consultant	FFP						$ - 0	$ - 0	$ - 0
0001AG	Precon Elderberry Laborers	FFP						$ - 0	$ - 0	$ - 0
0002	Tree Removal and Trimming FY21	FFP						$ - 0	$ - 0	$ - 0
0002AA	Tree Removal 0-10 inch	FFP						$ - 0	$ - 0	$ - 0
0002AB	Tree Removal 10-20 inch	FFP						$ - 0	$ - 0	$ - 0
0002AC	Tree Removal 20-30 inch	FFP						$ - 0	$ - 0	$ - 0
0002AD	Tree Removal 30 inch and over	FFP						$ - 0	$ - 0	$ - 0
0002AE	Tree Removal 48 inch and over	FFP						$ - 0	$ - 0	$ - 0
0002AF	Tree Trimming 10-50 feet high	FFP						$ - 0	$ - 0	$ - 0
0002AG	Tree Trimming 50 feet and over	FFP						$ - 0	$ - 0	$ - 0
0002AH	Saw Equipment Operators	FFP						$ - 0	$ - 0	$ - 0
0002AJ	Ground Personnel Laborers	FFP						$ - 0	$ - 0	$ - 0
0002AK	Site Forman	FFP						$ - 0	$ - 0	$ - 0
0002AL	Arborist	FFP						$ - 0	$ - 0	$ - 0
0002AM	Forestry Bucket Truck	FFP						$ - 0	$ - 0	$ - 0
0002AN	Log Truck Self Loader	FFP						$ - 0	$ - 0	$ - 0
0002AP	20 inch Brush Chipper	FFP						$ - 0	$ - 0	$ - 0
0002AQ	10 yard Chip Truck	FFP						$ - 0	$ - 0	$ - 0
0002AR	Dump run fees	FFP						$ - 0	$ - 0	$ - 0
0002AS	Travel IAW JTR and FAR Part 31	FFP						$ - 0	$ - 0	$ - 0
0003	Base Elderberry Transplant FY21	FFP						$ - 0	$ - 0	$ - 0
0003AA	Mobilization	FFP						$ - 0	$ - 0	$ - 0
0003AB	Ground Personnel Laborer	FFP						$ - 0	$ - 0	$ - 0
0003AC	Equipment Operator	FFP						$ - 0	$ - 0	$ - 0
0003AD	Site Forman	FFP						$ - 0	$ - 0	$ - 0
0003AE	Excavator	FFP						$ - 0	$ - 0	$ - 0
0003AF	15 inch Brush Chipper	FFP						$ - 0	$ - 0	$ - 0
0003AG	10 yard Chip Truck	FFP						$ - 0	$ - 0	$ - 0
0003AH	Flat bed transport truck	FFP						$ - 0	$ - 0	$ - 0
0003AJ	Travel IAW JTR and FAR Part 31	FFP						$ - 0	$ - 0	$ - 0
0004	Biological Monitoring Services FY21	FFP						$ - 0	$ - 0	$ - 0
0004AA	Senior Biological Monitor - Bat Surveys	FFP						$ - 0	$ - 0	$ - 0
0004AB	Reporting and Documentation	FFP						$ - 0	$ - 0	$ - 0
		Subtotal:	- 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
9999**	Surge (Cost Reimbursable NTE)	35%	- 0	- 0	- 0	- 0	- 0	$ - 0		$ - 0
		TOTAL EVALUATED PRICE:	- 0	- 0	- 0	- 0	- 0	- 0	- 0	- 0

NOTE 1: *6-Month Extension - For Evaluation Purposes only. Provide pricing for Optional 6-month extension authorized in accordance with FAR 52.217-8. CLIN(s) will not appear on contract. Assume all previous option periods have been exercised. DO NOT INCLUDE SURGE CLIN PRICING IN THIS NUMBER.

NOTE 2: **Surge CLIN OF ALL BASE PERIOD and OPTION PERIOD CLINs, excluding 6-mo extension authorized IAW FAR 52.217-8, see subtotal above). Surge CLINs are Cost Reimbursable (CR) Not to exceed (NTE).

Remove the text box and any notes in red italics prior to issuing the RFP/RFQ.

Contract specialists should tailor the CLIN summary to the specifics of your RFP/RFQ, i.e., the CLIN numbering, inserting plug numbers, contract types, PWS/SOW Task Area(s), number of option periods (removing the option period excell sheets that don't apply), PWS paragraph numbers, and surge percentage. Double-check formulas after adding or deleting CLINs to ensure they are accurate. Offerors are required to complete the Base Period (BP) and associated option year excel sheets with the labor categories that make up the pricing for the CLINs.

Consult with DISA Cost and Pricing Branch (PL842) if additional assistance is necessary.

Proposal Template

Base Period
FP LABOR
CLIN #	Company Name (Prime/Sub)	PWS/SOW Task(s)	Labor Category #	Proposed Contract Labor Category	Offeror's Mapped Labor Category	Government Site / Contractor Site	Contract/Schedule Labor Hr Rate	Proposed Discount Percent	Proposed FP Labor Hr Rate	Proposed Labor Hours	Amount
			(if applicable)		(if applicable)

ADD ADDITIONAL ROWS IF NECESSARY
Total FP Labor	- 0	$ - 0
Materials1		$ - 0
Travel/ODC1		$ - 0
Total Price		$ - 0

NOTE 1: All proposed Materials or Travel/ODC NOT part of a Government provided plug number shall be annotated in as much detail as known below.

COMPLETE THE SECTION BELOW ONLY IF THE PROPOSED MATERIAL AND TRAVEL/ODC COST ABOVE ARE NOT PART OF A PLUG NUMBER
Materials
CLIN	OEM/Vendor Source	PWS/SOW Task	Part Number	Proposed Item	Description	Unit Cost	Quantity	Sub Total	Applicable Indirect	Applicable Indirect	Total	Supporting	Supporting
									0%	0%		Basis of Rate	Data Reference
								$ - 0	$ - 0	$ - 0	$ - 0	(e.g. invoices, price history, etc)	(e.g. Tab A, attachment xyz)
								$ - 0	$ - 0	$ - 0	$ - 0
ADD ADDITIONAL ROWS IF NECESSARY								$ - 0	$ - 0	$ - 0	$ - 0
											- 0

Travel Cost

CLIN

Locations (To and From)

Number of Days

Number of Personnel

Meals and Incidentals

Lodging

Airfare

Rental Car

Other

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

(e.g. GSA detail, commercial pricing, etc)

(e.g. Tab A, attachment xyz)

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

Other

TBD

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

OP1

Proposal Template

Option Period 1
FP LABOR
CLIN #	Company Name (Prime/Sub)	PWS/SOW Task(s)	Labor Category #	Proposed Contract Labor Category	Mapped Internal Labor Category	Government Site /Contractor Site	Contract/Schedule Labor Hr Rate	Proposed Discount Percent	Proposed FP Labor Hr Rate	Proposed Labor Hours	Amount
			(if applicable)		(if applicable)

ADD ADDITIONAL ROWS IF NECESSARY
Total FP Labor	- 0	$ - 0
Materials1		$ - 0
Travel/ODC1		$ - 0
Total Price		$ - 0

NOTE 1: All proposed Materials or Travel/ODC NOT part of a Government provided plug number shall be annotated in as much detail as known below.

COMPLETE THE SECTION BELOW ONLY IF THE PROPOSED MATERIAL AND TRAVEL/ODC COST ABOVE ARE NOT PART OF A PLUG NUMBER
Materials
CLIN	OEM/Vendor Source	PWS/SOW Task	Part Number	Proposed Item	Description	Unit Cost	Quantity	Sub Total	Applicable Indirect	Applicable Indirect	Total	Supporting	Supporting
									0%	0%		Basis of Rate	Data Reference
								$ - 0	$ - 0	$ - 0	$ - 0	(e.g. invoices, price history, etc)	(e.g. Tab A, attachment xyz)
								$ - 0	$ - 0	$ - 0	$ - 0
ADD ADDITIONAL ROWS IF NECESSARY								$ - 0	$ - 0	$ - 0	$ - 0
											- 0

Travel Cost

CLIN

Locations (To and From)

Number of Days

Number of Personnel

Meals and Incidentals

Lodging

Airfare

Rental Car

Other

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

(e.g. GSA detail, commercial pricing, etc)

(e.g. Tab A, attachment xyz)

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

Other

TBD

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

OP2

Proposal Template

Option Period 2
FP LABOR
CLIN #	Company Name (Prime/Sub)	PWS/SOW Task(s)	Labor Category #	Proposed Contract Labor Category	Mapped Internal Labor Category	Government Site /Contractor Site	Contract/Schedule Labor Hr Rate	Proposed Discount Percent	Proposed FP Labor Hr Rate	Proposed Labor Hours	Amount
			(if applicable)		(if applicable)

ADD ADDITIONAL ROWS IF NECESSARY
Total FP Labor	- 0	$ - 0
Materials1		$ - 0
Travel/ODC1		$ - 0
Total Price		$ - 0

NOTE 1: All proposed Materials or Travel/ODC NOT part of a Government provided plug number shall be annotated in as much detail as known below.

COMPLETE THE SECTION BELOW ONLY IF THE PROPOSED MATERIAL AND TRAVEL/ODC COST ABOVE ARE NOT PART OF A PLUG NUMBER
Materials
CLIN	OEM/Vendor Source	PWS/SOW Task	Part Number	Proposed Item	Description	Unit Cost	Quantity	Sub Total	Applicable Indirect	Applicable Indirect	Total	Supporting	Supporting
									0%	0%		Basis of Rate	Data Reference
								$ - 0	$ - 0	$ - 0	$ - 0	(e.g. invoices, price history, etc)	(e.g. Tab A, attachment xyz)
								$ - 0	$ - 0	$ - 0	$ - 0
ADD ADDITIONAL ROWS IF NECESSARY								$ - 0	$ - 0	$ - 0	$ - 0
											- 0

Travel Cost

CLIN

Locations (To and From)

Number of Days

Number of Personnel

Meals and Incidentals

Lodging

Airfare

Rental Car

Other

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

(e.g. GSA detail, commercial pricing, etc)

(e.g. Tab A, attachment xyz)

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

Other

TBD

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

OP3

Proposal Template

Option Period 3
FP LABOR
CLIN #	Company Name (Prime/Sub)	PWS/SOW Task(s)	Labor Category #	Proposed Contract Labor Category	Mapped Internal Labor Category	Government Site /Contractor Site	Contract/Schedule Labor Hr Rate	Proposed Discount Percent	Proposed FP Labor Hr Rate	Proposed Labor Hours	Amount
			(if applicable)		(if applicable)

ADD ADDITIONAL ROWS IF NECESSARY
Total FP Labor	- 0	$ - 0
Materials1		$ - 0
Travel/ODC1		$ - 0
Total Price		$ - 0

NOTE 1: All proposed Materials or Travel/ODC NOT part of a Government provided plug number shall be annotated in as much detail as known below.

COMPLETE THE SECTION BELOW ONLY IF THE PROPOSED MATERIAL AND TRAVEL/ODC COST ABOVE ARE NOT PART OF A PLUG NUMBER
Materials
CLIN	OEM/Vendor Source	PWS/SOW Task	Part Number	Proposed Item	Description	Unit Cost	Quantity	Sub Total	Applicable Indirect	Applicable Indirect	Total	Supporting	Supporting
									0%	0%		Basis of Rate	Data Reference
								$ - 0	$ - 0	$ - 0	$ - 0	(e.g. invoices, price history, etc)	(e.g. Tab A, attachment xyz)
								$ - 0	$ - 0	$ - 0	$ - 0
ADD ADDITIONAL ROWS IF NECESSARY								$ - 0	$ - 0	$ - 0	$ - 0
											- 0

Travel Cost

CLIN

Locations (To and From)

Number of Days

Number of Personnel

Meals and Incidentals

Lodging

Airfare

Rental Car

Other

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

(e.g. GSA detail, commercial pricing, etc)

(e.g. Tab A, attachment xyz)

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

Other

TBD

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

OP4

Proposal Template

Option Period 4
FP LABOR
CLIN #	Company Name (Prime/Sub)	PWS/SOW Task(s)	Labor Category #	Proposed Contract Labor Category	Mapped Internal Labor Category	Government Site /Contractor Site	Contract/Schedule Labor Hr Rate	Proposed Discount Percent	Proposed FP Labor Hr Rate	Proposed Labor Hours	Amount
			(if applicable)		(if applicable)

ADD ADDITIONAL ROWS IF NECESSARY
Total FP Labor	- 0	$ - 0
Materials1		$ - 0
Travel/ODC1		$ - 0
Total Price		$ - 0

NOTE 1: All proposed Materials or Travel/ODC NOT part of a Government provided plug number shall be annotated in as much detail as known below.

COMPLETE THE SECTION BELOW ONLY IF THE PROPOSED MATERIAL AND TRAVEL/ODC COST ABOVE ARE NOT PART OF A PLUG NUMBER
Materials
CLIN	OEM/Vendor Source	PWS/SOW Task	Part Number	Proposed Item	Description	Unit Cost	Quantity	Sub Total	Applicable Indirect	Applicable Indirect	Total	Supporting	Supporting
									0%	0%		Basis of Rate	Data Reference
								$ - 0	$ - 0	$ - 0	$ - 0	(e.g. invoices, price history, etc)	(e.g. Tab A, attachment xyz)
								$ - 0	$ - 0	$ - 0	$ - 0
ADD ADDITIONAL ROWS IF NECESSARY								$ - 0	$ - 0	$ - 0	$ - 0
											- 0

Travel Cost

CLIN

Locations (To and From)

Number of Days

Number of Personnel

Meals and Incidentals

Lodging

Airfare

Rental Car

Other

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

(e.g. GSA detail, commercial pricing, etc)

(e.g. Tab A, attachment xyz)

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

Other

TBD

Total

Applicable Indirect

Total

Supporting

Basis of Rate

Data Reference

$ - 0

ADD ADDITIONAL ROWS IF NECESSARY

$ - 0

- 0

FP Rate Sheet

Proposal Template

Contract/Schedule Labor Rates

Blended Contract/Schedule Rate (if necessary)

Year 1

Year 2

Year 3

Year 4

Year 5

OP1

OP2

OP3

OP4

Labor Category

Mapped Labor Category

Government Site/Contractor Site

Rate

Prime Labor

Subcontracting Labor

Instructions:	Provide all proposed FP labor rates for each of the labor category.
	Add additional columns/rows if needed. For example, the offeror can illustrate a blended rate between periods.

File details come from the government source that posted it. Updated May 17, 2021.