Attachment_4_-_Contract_Pricing_Spreadsheet.xlsx

XLSX spreadsheet 36 KB Posted Sep 23, 2019

Attached to: Solicitation: Recreational Boat Testing and Compliance Program (RBTCP) Federal contract opportunity
Solicitation number: 70Z02319RM0202400
Issued by: Department of Homeland Security US Coast Guard

About this file

From the source

Contract Pricing Spreadsheet

View the file

Other files for this federal contract opportunity

Other files attached to Solicitation: Recreational Boat Testing and Compliance Program (RBTCP), newest first.
File	Type	Posted
70Z02319RM0202400_A2_rev1.pdf	PDF	Sep 26, 2019
Amendment_A00001_70Z02319RM0202400.pdf	PDF	Sep 26, 2019
70Z02319RM0202400_A1.pdf	PDF	Sep 23, 2019
RFP_no._70Z02319RM0202400.pdf	PDF	Sep 23, 2019
70Z02319RM0202400_A2.pdf	PDF	Sep 23, 2019
70Z02319RM0202400_A3.pdf	PDF	Sep 23, 2019
SF33.pdf	PDF	Sep 23, 2019

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.

Base Period

Base Year
CLIN	Description	Quantity	Unit	Price Per Unit	Total Price
Firm Fixed Price (FFP)			of Measure
00001	Recreational Boat Factory Compliance Inspections	350	Job	0	$ - 0
00001AA	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
00001AB	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
00001AC	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
00001AD	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
00001AE	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
00002	Recreational Boat Retailer Compliance Inspections	200	Job	0	$ - 0
00003	Recreational Boat Show Compliance Inspections	10	Job	0	$ - 0
00004	Recreational Boat Post-Casualty Inspections	20	Job	0	$ - 0
00005	Testing of Recreational Boats	35	Job	0	$ - 0
Other Direct Costs (ODC)
00006	NTE - Independent Laboratory Testing				$ 75,000.00
00007	NTE - Travel				$ 150,000.00
00007AA	NTE- Optional Increase Travel				$ 150,000.00
00008	NTE - Reimbursement of Boat Purchases				$ - 0
00008AA	NTE- Optional Increase Reimbursement of Boat Purchases				$ - 0
00009	NTE - Transportation of Purchased Boats				$ 30,000.00

Base Total	$ 405,000.00
Breakdown for CLIN 00008
Description	Total
Percent of Each Boat's Purchase Price to be Billed to USCG
Boat Purchases	$ 365,000.00
Amount of Boat Purchase Price to be Billed to USCG (CLIN 00008)	$ - 0
Optional Increase to Boat Purchases	$ 140,000.00
Amount of Increase to be Billed to USCG (CLIN 00008AA)	$ - 0

Attachment 4 Contract Pricing Spreadsheet RFP 70Z02319RM0202400

Option Period 1

Option Period 1
CLIN	Description	Quantity	Unit	Price Per Unit	Total Price
Firm Fixed Price (FFP)			of Measure
01001	Recreational Boat Factory Compliance Inspections	350	Job	0	$ - 0
01001AA	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
01001AB	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
01001AC	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
01001AD	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
01001AE	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
01002	Recreational Boat Retailer Compliance Inspections	200	Job	0	$ - 0
01003	Recreational Boat Show Compliance Inspections	10	Job	0	$ - 0
01004	Recreational Boat Post-Casualty Inspections	20	Job	0	$ - 0
01005	Testing of Recreational Boats	35	Job	0	$ - 0
Other Direct Costs (ODC)
01006	NTE - Independent Laboratory Testing				$ 75,000.00
01007	NTE - Travel				$ 150,000.00
01007AA	NTE- Optional Increase Travel				$ 150,000.00
01008	NTE - Reimbursement of Boat Purchases				$ - 0
01008AA	NTE- Optional Increase Reimbursement of Boat Purchases				$ - 0
01009	NTE - Transportation of Purchased Boats				$ 30,000.00

	Option Period 1 Total	$ 405,000.00
Breakdown for CLIN 01008
Description		Total
Percent of Each Boat's Purchase Price to be Billed to USCG
Boat Purchases		$ 365,000.00
Amount of Boat Purchase Price to be Billed to USCG (CLIN 01008)		$ - 0
Optional Increase to Boat Purchases		$ 140,000.00
Amount of Increase to be Billed to USCG (CLIN 01008AA)		$ - 0

Attachment 4 Contract Pricing Spreadsheet RFP 70Z02319RM0202400

Option Period 2

Option Period 2
CLIN	Description	Quantity	Unit	Price Per Unit	Total Price
Firm Fixed Price (FFP)			of Measure
02001	Recreational Boat Factory Compliance Inspections	350	Job	0	$ - 0
02001AA	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
02001AB	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
02001AC	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
02001AD	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
02001AE	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
02002	Recreational Boat Retailer Compliance Inspections	200	Job	0	$ - 0
02003	Recreational Boat Show Compliance Inspections	10	Job	0	$ - 0
02004	Recreational Boat Post-Casualty Inspections	20	Job	0	$ - 0
02005	Testing of Recreational Boats	35	Job	0	$ - 0
Other Direct Costs (ODC)
02006	NTE - Independent Laboratory Testing				$ 75,000.00
02007	NTE - Travel				$ 150,000.00
02007AA	NTE- Optional Increase Travel				$ 150,000.00
02008	NTE - Reimbursement of Boat Purchases
02008AA	NTE- Optional Increase Reimbursement of Boat Purchases
02009	NTE - Transportation of Purchased Boats				$ 30,000.00

	Option Period 2 Total	$ 405,000.00
Breakdown for CLIN 02008
Description		Total
Percent of Each Boat's Purchase Price to be Billed to USCG
Boat Purchases		$ 365,000.00
Amount of Boat Purchase Price to be Billed to USCG (CLIN 02008)		$ - 0
Optional Increase to Boat Purchases		$ 140,000.00
Amount of Increase to be Billed to USCG (CLIN 02008AA)		$ - 0

Attachment 4 Contract Pricing Spreadsheet RFP 70Z02319RM0202400

Option Period 3

Option Period 3
CLIN	Description	Quantity	Unit	Price Per Unit	Total Price
Firm Fixed Price (FFP)			of Measure
03001	Recreational Boat Factory Compliance Inspections	350	Job	0	$ - 0
03001AA	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
03001AB	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
03001AC	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
03001AD	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
03001AE	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
03002	Recreational Boat Retailer Compliance Inspections	200	Job	0	$ - 0
03003	Recreational Boat Show Compliance Inspections	10	Job	0	$ - 0
03004	Recreational Boat Post-Casualty Inspections	20	Job	0	$ - 0
03005	Testing of Recreational Boats	35	Job	0	$ - 0
Other Direct Costs (ODC)
03006	NTE - Independent Laboratory Testing				$ 75,000.00
03007	NTE - Travel				$ 150,000.00
03007AA	NTE- Optional Increase Travel				$ 150,000.00
03008	NTE - Reimbursement of Boat Purchases				$ - 0
03008AA	NTE- Optional Increase Reimbursement of Boat Purchases				$ - 0
03009	NTE - Transportation of Purchased Boats				$ 30,000.00

	Option Period 3 Total	$ 405,000.00
Breakdown for CLIN 03008
Description		Total
Percent of Each Boat's Purchase Price to be Billed to USCG
Boat Purchases		$ 365,000.00
Amount of Boat Purchase Price to be Billed to USCG (CLIN 03008)		$ - 0
Optional Increase to Boat Purchases		$ 140,000.00
Amount of Increase to be Billed to USCG (CLIN 03008AA)		$ - 0

Attachment 4 Contract Pricing Spreadsheet RFP 70Z02319RM0202400

Option Period 4

Option Period 4
CLIN	Description	Quantity	Unit	Price Per Unit	Total Price
Firm Fixed Price (FFP)			of Measure
04001	Recreational Boat Factory Compliance Inspections	350	Job	0	$ - 0
04001AA	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
04001AB	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
04001AC	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
04001AD	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
04001AE	Optional Increase Factory Compliance Inspections	70	Job	0	$ - 0
04002	Recreational Boat Retailer Compliance Inspections	200	Job	0	$ - 0
04003	Recreational Boat Show Compliance Inspections	10	Job	0	$ - 0
04004	Recreational Boat Post-Casualty Inspections	20	Job	0	$ - 0
04005	Testing of Recreational Boats	35	Job	0	$ - 0
Other Direct Costs (ODC)
04006	NTE - Independent Laboratory Testing				$ 75,000.00
04007	NTE - Travel				$ 150,000.00
04007AA	NTE- Optional Increase Travel				$ 150,000.00
04008	NTE - Reimbursement of Boat Purchases				$ - 0
04008AA	NTE- Optional Increase Reimbursement of Boat Purchases				$ - 0
04009	NTE - Transportation of Purchased Boats				$ 30,000.00

	Option Period 4 Total	$ 405,000.00
Breakdown for CLIN 04008
Description		Total
Percent of Each Boat's Purchase Price to be Billed to USCG
Boat Purchases		$ 365,000.00
Amount of Boat Purchase Price to be Billed to USCG (CLIN 04008)		$ - 0
Optional Increase to Boat Purchases		$ 140,000.00
Amount of Increase to be Billed to USCG (CLIN 04008AA)		$ - 0

Attachment 4 Contract Pricing Spreadsheet RFP 70Z02319RM0202400

Extension for 6 mos.

Option to extend for 6 months (FAR 52.217-8)
CLIN	Description	Quantity	Unit	Price Per Unit	Total Price
Firm Fixed Price (FFP)			of Measure
05001	Recreational Boat Factory Compliance Inspections	175	Job	0	$ - 0
05002	Recreational Boat Retailer Compliance Inspections	100	Job	0	$ - 0
05003	Recreational Boat Show Compliance Inspections	5	Job	0	$ - 0
05004	Recreational Boat Post-Casualty Inspections	10	Job	0	$ - 0
05005	Testing of Recreational Boats	18	Job	0	$ - 0
Other Direct Costs (ODC)
05006	NTE - Independent Laboratory Testing				$ 37,500.00
05007	NTE - Travel				$ 75,000.00
05008	NTE - Reimbursement of Boat Purchases				$ - 0
05009	NTE - Transportation of Purchased Boats				$ 15,000.00

	Option to Extend 6 mos. Total	$ 127,500.00
Breakdown for CLIN 05008
Description		Total
Percent of Each Boat's Purchase Price to be Billed to USCG		0.0%
Boat Purchases		$ 182,500.00
Amount of Boat Purchase Price to be Billed to USCG (CLIN 05008)		$ - 0
	This worksheet auto-populates.
	Do not enter data on this worksheet.

Attachment 4 Contract Pricing Spreadsheet RFP 70Z02319RM0202400

Sample of CLIN X0008

This worksheet is for informational purposes only in support of the solicitation.

The offeror is required to propose a percentage of the Purchase Price of the Boats which will be billed to the USCG for each boat.

The percentage should offset what the contractor reasonably expects to recover by reselling the boat after testing.

	The below example assumes a reimbursement percentage of 60%.
SAMPLE BREAKDOWN FOR CLIN 00008

CLIN	Description	Quantity	UOM	Price Per UOM	Total Price
Boat Purchases					$ 365,000.00
Percent of Each Boat's Purchase Price to be Billed to USCG					60%
Amount of All Boats' Purchase Price to be Billed to USCG					$ 219,000.00
SAMPLE INVOICE FOR CLIN 00008
When seeking reimbursement, the contractor shall adjust purchase price on invoices by applying percent proposed.
This example is based on a boat purchased for $5,000.00.
CLIN 00008	Reimbursement of Boat Purchases		This worksheet is for informational purposes only.
60% of Purchase Price	$ 3,000.00
Invoice for CLIN 00008	$ 3,000.00
	After testing, the Contractor may resell any boat that complies with applicable regulations at its discretion.

Attachment 4 Contract Pricing Spreadsheet RFP 70Z02319RM0202400

File details come from the government source that posted it.