Attachment-3_WCC CB-ATON-S_Price Schedule_RFP.xlsx

XLSX spreadsheet 34 KB Posted Dec 18, 2024

Attached to: Cutter Boat - Aids to Navigation - Small (CB-ATON-S)
Solicitation number: 70Z02325R93270001
Issued by: Department of Homeland Security US Coast Guard

About this file

Written by GovTribe AI · Dec 18, 2024

This is a price schedule template spreadsheet (Attachment 3) for the U.S. Coast Guard's Cutter Boat - Aids to Navigation - Small (CB-ATON-S) procurement. The schedule covers a base ordering period of 5 years plus two optional years, with CLINs for boat production, trailers, delivery, spares, training, materials/subcontracts, engineering labor, and design/prototype production. Quantities vary by period, with the base period including 2 boats and 4 trailers, increasing to 8-12 boats per period in subsequent years.

The spreadsheet includes both a Price Schedule tab for vendor input and an Evaluation Worksheet tab with preset formulas that calculate total evaluated price based on estimated quantities. The total evaluated price across all seven years is $330,000, though this appears to be a placeholder value as most unit prices are blank. Notable requirements include varying unit prices based on quantity breaks (1-3, 4-6, 7-9, 10+ boats), CONUS delivery priced per mile, and fixed materials/subcontracts amounts of $50,000 per year in early periods reducing to $30,000 in later periods. All values except CLIN X002AB and X005 must be entered in $100 increments.

View the file

Other files

File	Type	Posted
Attachment-6_WCC CB-ATON-S_QuestionsandClarificationsForm_GovernmentResponses_A00004.xlsx	XLSX spreadsheet	Feb 21, 2025
RFP_70Z02325R93270001_A00004.pdf	PDF	Feb 21, 2025
SF30_WCC CB-ATON-S_A00004.pdf	PDF	Feb 21, 2025
Attachment-6_WCC CB-ATON-S_QuestionsandClarificationsForm_GovernmentResponses_A00003.xlsx	XLSX spreadsheet	Feb 6, 2025
SF30_WCC CB-ATON-S_A00003_2-6-2025.pdf	PDF	Feb 6, 2025
Attachment 2 - WCC_CB-ATON-S_Technical Specification_V3.1.pdf	PDF	Feb 6, 2025
Attachment-6_WCC CB-ATON-S_QuestionsandClarificationsForm_GovernmentResponses_A00002.xlsx	XLSX spreadsheet	Jan 27, 2025
SF30_WCC CB-ATON-S_A00002_1-27-2025.pdf	PDF	Jan 27, 2025
SF30_CB-ATON-S_A00001_12-23-2024.pdf	PDF	Dec 23, 2024
Attachment-1_WCC_CB-ATON-S_Statement of Work_RFP.pdf	PDF	Dec 18, 2024
Attachment-4_WCC CB-ATON-S_GFI_RFP.zip	ZIP file	Dec 18, 2024
Attachment-6_WCC CB-ATON-S_QuestionsandClarificationsForm_RFP.xlsx	XLSX spreadsheet	Dec 18, 2024
Attachment-5_WCC CB-ATON-S_Past Performance Questionnaire_RFP.pdf	PDF	Dec 18, 2024
SF1449_70Z02325R93270001_12-18-2024.pdf	PDF	Dec 18, 2024
Attachment-2_WCC_CB-ATON-S_Technical Specification_RFP.pdf	PDF	Dec 18, 2024

Show all 15

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.

Instructions

Price Schedule, shall be completed with unit prices, rates, and the Offeror’s name. The Offeror is to only input prices in the “Price Schedule” tab of Attachment 3. All other calculations are embedded as formulas in the Evaluation worksheet for purposes of calculating the total evaluated price and contract prices. These formulae shall not be altered. Attachment 3 will not be a part of the resultant contract. The information inserted into Attachment 3 will be used, by the Government for evaluation purposes and for purposes of inserting price information into the Schedule SF-1449.

Price Schedule Tab Instructions

Price Schedule Tab: The Price Schedule tab is for an Offeror’s input of unit prices for each Contract Line Item Number (CLIN) for each ordering period and including options. The inserted unit prices are automatically put into the evaluation worksheet. At award, the unit prices, inserted into the Price Schedule tab, will be entered into the SF-1449, establishing the contract’s maximum value. With the exception of CLIN X002AB and CLIN X005, all values should be entered in $100 increments.

Evaluation Worksheet Tab Instructions

Evaluation Worksheet Tab: The evaluation worksheet tab uses unit prices inserted by Offerors in the price schedule tab and shall not be altered by offerors. The evaluation worksheet displays the estimated ordering quantity for each ordering period and including options. It also provides a unit price based on the inputs from the price schedule tab. The evaluation worksheet calculates the total amount per CLIN and then a total evaluated price. This allows the USCG to evaluate pricing based on what the USCG anticipates ordering. This value will establish the maximum contract value and this information will be inserted, by the USCG, into the SF-1449 upon award.

For the CLIN X005 series, the solicitation includes a set value for materials and the estimated labor hour needed for these services. The amount provided for materials amount is used for evaluation and will be applied to the overall contract value. For proposal evaluation purposes, material costs have been established as indicated in the Price Schedule to provide a uniform basis for comparison. The CLIN X005 series also has labor hours established to provide a uniform basis for comparison. These labor hours will be multiplied by the proposed labor rates and will be applied to the overall CLIN value and the total contract value.

RFP No. 70Z02325R93270001	WCC CB-ATON-S
Price Schedule Instructions	Attachment 3

Price Schedule

{Enter Offeror Name}
		Base Ordering Period					Optional Ordering Period
Item #	Activity/Action	Base Year	Year 1	Year 2	Year 3	Year 4	Year 5	Year 6
X001	CB-ATON-S PRODUCTION [SOW Paragraph 3.1]
X001AA	CB-ATON-S Production
	Unit Price (EA) - Quantity 1 to 3	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Unit Price (EA) - Quantity 4 to 6	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Unit Price (EA) - Quantity 7 to 9	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
	Unit Price (EA) - Quantity 10+	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X001AB	Trailer
	Unit Price (EA)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X002	DELIVERY [SOW Paragraph 3.2]
X002AA	Shipyard Delivery
	Unit Price (EA)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X002AB	Continental U.S. (CONUS) Delivery
	Unit Price (MI)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X003	SPARES [SOW Paragraph 3.3]
X003AA	Outboard Engine
	Unit Price (EA)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X003AB	Lower Unit
	Unit Price (EA)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X003AC	Fendering
	Unit Price (EA)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X004	Training [SOW Paragraph 3.4]
X004AA	Crew Familiarization Training
	Unit Price (EA)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X004AB	Training Development
	Unit Price (EA)	$ - 0
X005	Materials/Subcontacts, Engineering Change Development/Studies and Travel [SOW Paragraph 3.5]
X005AA	Materials and Subcontracts
	Loading Rate (%)	0%	0%	0%	0%	0%	0%	0%
	Unit Price	$ 1.00	$ 1.00	$ 1.00	$ 1.00	$ 1.00	$ 1.00	$ 1.00
X005AB	Engineering Labor
	Unit Price (HR)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X005AC	Non-Engineering Labor
	Unit Price (HR)	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
X005AD	Travel
	Unit Price ($)	Total Specified by the Government
X006	Design and Prototype Production [SOW Paragraph 3.6]
X006AA	Design and Engineering
	Unit Price (EA)	$ - 0
X006AB	Prototype Production
	Unit Price (EA)	$ - 0

Evaluation Worksheet

Base Ordering Period (5 years)
Base Ordering Period IDIQ Pricing
CLIN	SUB-CLIN	Description	Unit	Qty	Unit Price	Total	Notes
X001	X001AA	CB-ATON-S Production	EA	2	$0	$0
	X001AB	Trailer	EA	4	$0	$0
X002	X002AA	Shipyard Delivery	EA	3	$0	$0
	X002AB	Continental U.S. (CONUS) Delivery	MI	3500	$ - 0	$0
X003	X003AA	Outboard Engine	EA	2	$0	$0
	X003AB	Lower Unit	EA	1	$0	$0
	X003AC	Fendering	EA	1	$0	$0
X004	X004AA	Familiarization Training	EA	1	$0	$0
	X004AB	Training Development	EA	1	$0	$0
X005	X005AA	Materials and Subcontracts	JB	$50,000	$ 1.00	$50,000
	X005AB	Engineering Labor	HR	1000	$0	$0
	X005AC	Non-Engineering Labor	HR	500	$0	$0
	X005AD	Travel	JB	10000	$1	$10,000
X006	X006AA	Design and Engineering	EA	1	$0	$0
	X006AB	Prototype Production	EA	2	$0	$0
Total Base Ordering Period						$60,000

Ordering Period 1 IDIQ Pricing
CLIN	SUB-CLIN	Description	Unit	Qty	Unit Price	Total	Notes
X001	X001AA	CB-ATON-S Production	EA	8	$0	$0
	X001AB	Trailer	EA	8	$0	$0
X002	X002AA	Shipyard Delivery	EA	8	$0	$0
	X002AB	Continental U.S. (CONUS) Delivery	MI	0	$ - 0	$0
X003	X003AA	Outboard Engine	EA	2	$0	$0
	X003AB	Lower Unit	EA	1	$0	$0
	X003AC	Fendering	EA	1	$0	$0
X004	X004AA	Familiarization Training	EA	5	$0	$0
X005	X005AA	Materials and Subcontracts	JB	$50,000	$ 1.00	$50,000
	X005AB	Engineering Labor	HR	1000	$0	$0
	X005AC	Non-Engineering Labor	HR	500	$0	$0
	X005AD	Travel	JB	10000	$1	$10,000
Total Ordering Period 1						$60,000

Ordering Period 2 IDIQ Pricing
CLIN	SUB-CLIN	Description	Unit	Qty	Unit Price	Total	Notes
X001	X001AA	CB-ATON-S Production	EA	12	$0	$0
	X001AB	Trailer	EA	12	$0	$0
X002	X002AA	Shipyard Delivery	EA	12	$0	$0
	X002AB	Continental U.S. (CONUS) Delivery	MI	14000	$ - 0	$0
X003	X003AA	Outboard Engine	EA	2	$0	$0
	X003AB	Lower Unit	EA	1	$0	$0
	X003AC	Fendering	EA	1	$0	$0
X004	X004AA	Familiarization Training	EA	9	$0	$0
X005	X005AA	Materials and Subcontracts	JB	$50,000	$ 1.00	$50,000
	X005AB	Engineering Labor	HR	1000	$0	$0
	X005AC	Non-Engineering Labor	HR	500	$0	$0
	X005AD	Travel	JB	10000	$1	$10,000
Total Ordering Period 2						$60,000

Ordering Period 3 IDIQ Pricing
CLIN	SUB-CLIN	Description	Unit	Qty	Unit Price	Total	Notes
X001	X001AA	CB-ATON-S Production	EA	12	$0	$0
	X001AB	Trailer	EA	12	$0	$0
X002	X002AA	Shipyard Delivery	EA	12	$0	$0
	X002AB	Continental U.S. (CONUS) Delivery	MI	14000	$ - 0	$0
X003	X003AA	Outboard Engine	EA	2	$0	$0
	X003AB	Lower Unit	EA	1	$0	$0
	X003AC	Fendering	EA	1	$0	$0
X004	X004AA	Familiarization Training	EA	9	$0	$0
X005	X005AA	Materials and Subcontracts	JB	$50,000	$ 1.00	$50,000
	X005AB	Engineering Labor	HR	1000	$0	$0
	X005AC	Non-Engineering Labor	HR	500	$0	$0
	X005AD	Travel	JB	10000	$1	$10,000
Total Ordering Period 3						$60,000

Ordering Period 4 IDIQ Pricing
CLIN	SUB-CLIN	Description	Unit	Qty	Unit Price	Total	Notes
X001	X001AA	CB-ATON-S Production	EA	12	$0	$0
	X001AB	Trailer	EA	12	$0	$0
X002	X002AA	Shipyard Delivery	EA	12	$0	$0
	X002AB	Continental U.S. (CONUS) Delivery	MI	14000	$ - 0	$0
X003	X003AA	Outboard Engine	EA	2	$0	$0
	X003AB	Lower Unit	EA	1	$0	$0
	X003AC	Fendering	EA	1	$0	$0
X004	X004AA	Familiarization Training	EA	8	$0	$0
X005	X005AA	Materials and Subcontracts	JB	$30,000	$ 1.00	$30,000
	X005AB	Engineering Labor	HR	0	$0	$0
	X005AC	Non-Engineering Labor	HR	0	$0	$0
	X005AD	Travel	JB	0	$1	$0
Total Ordering Period 4						$30,000
Base Ordering Period Total						$270,000

Optional Ordering Period (2 years)
Ordering Period 5 IDIQ Pricing
CLIN	SUB-CLIN	Description	Unit	Qty	Unit Price	Total	Notes
X001	X001AA	CB-ATON-S Production	EA	10	$0	$0
	X001AB	Trailer	EA	10	$0	$0
X002	X002AA	Shipyard Delivery	EA	10	$0	$0
	X002AB	Continental U.S. (CONUS) Delivery	MI	7000	$ - 0	$0
X003	X003AA	Outboard Engine	EA	2	$0	$0
	X003AB	Lower Unit	EA	1	$0	$0
	X003AC	Fendering	EA	1	$0	$0
X004	X004AA	Familiarization Training	EA	7	$0	$0
X005	X005AA	Materials and Subcontracts	JB	$30,000	$ 1.00	$30,000
	X005AB	Engineering Labor	HR	0	$0	$0
	X005AC	Non-Engineering Labor	HR	0	$0	$0
	X005AD	Travel	JB	0	$1	$0
Total Ordering Period 5						$30,000

Ordering Period 6 IDIQ Pricing
CLIN	SUB-CLIN	Description	Unit	Qty	Unit Price	Total	Notes
X001	X001AA	CB-ATON-S Production	EA	8	$0	$0
	X001AB	Trailer	EA	8	$0	$0
X002	X002AA	Shipyard Delivery	EA	8	$0	$0
	X002AB	Continental U.S. (CONUS) Delivery	MI	3500	$ - 0	$0
X003	X003AA	Outboard Engine	EA	2	$0	$0
	X003AB	Lower Unit	EA	1	$0	$0
	X003AC	Fendering	EA	1	$0	$0
X004	X004AA	Familiarization Training	EA	6	$0	$0
X005	X005AA	Materials and Subcontracts	JB	$30,000	$ 1.00	$30,000
	X005AB	Engineering Labor	HR	0	$0	$0
	X005AC	Non-Engineering Labor	HR	0	$0	$0
	X005AD	Travel	JB	0	$1	$0
Total Ordering Period 6						$30,000
Optional Ordering Period Total						$60,000

Total Evaluated Price (7 Years) $330,000

File details come from the government source that posted it. Updated Dec 18, 2024.