MBS004_-_Attach_1_-_Pricing_Spreadsheet.xlsx

XLSX spreadsheet 47 KB Posted Mar 10, 2014

Attached to: Recreational Boat Testing and Compliance Program Federal contract opportunity
Solicitation number: HSCG23-14-R-MBS004
Issued by: Department of Homeland Security US Coast Guard

About this file

From the source

Attachment no. 1

View the file

Other files for this federal contract opportunity

Other files attached to Recreational Boat Testing and Compliance Program, newest first.
File	Type	Posted
Q A.pdf	PDF	Mar 18, 2014
MBS004_-_RFP.pdf	PDF	Mar 10, 2014
MBS004_-_Attach_4_-_NDA.pdf	PDF	Mar 10, 2014
MBS004_-_Attach_2_-_SOW.pdf	PDF	Mar 10, 2014
MBS004_-_Attach_3_-__PPQ.doc	DOC document	Mar 10, 2014

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 Year

Base Year
CLIN	CLIN Description	Quantity	UOM	Price Per UOM	Total Price
FFP
00001	Recreational Boat Factory Compliance Inspections	350	Inspection		$ - 0
00002	Recreational Boat Retailer Compliance Inspections	200	Inspection		$ - 0
00003	Recreational Boat Show Compliance Inspections	10	Show		$ - 0
00004	Recreational Boat Post-Casualty Inspections	20	Inspection		$ - 0
00005	NTE - Purchase, Test, and Sale of Recreational Boats	35			$ - 0
Breakdown for CLIN00005
Description		Quantity	UOM	Price Per UOM	Total
Boat Purchases*					$ 170,000.00
Percent of Each Boat's Purchase Price to be Billed to USCG					0%
Amount of All Boats' Purchase Price to be Billed to USCG					$ - 0
Testing of Recreational Boats		35	Test
Purchase, Test, and Sale of Recreational Boats		35	Not to Exceed (NTE)		$ - 0

00006	Recreational Boat MIC Database Management	12	Mo	$ - 0
00007	Recreational Boat Document Management	12	Mo	$ - 0
00008	Recreational Boating Safety Outreach - unpriced
00008A	CD Production of "Boat Builders Handbook"	500	Ea	$ - 0
00008B	Hosting of Web-Based Video Portal	12	Mo	$ - 0
00008C	Boating Safety Training Video	2	Ea	$ - 0
00009	NTE - Independent Laboratory Testing**			$ 75,000.00

TOTAL CLINs 00001 - 00009

ODCs
00010	NTE - Travel	$ 150,000.00
00011	NTE - Unique Boats and Associated Equipment Purchases	$ 100,000.00
00012	NTE - Transportation of Purchased Boats	$ 30,000.00
TOTAL ODCs		$ 280,000.00

Base Pd Total

*$170,000 is estimated for purchasing Recreational Boats

**NTE Line Item - USCG will issue an addendum to the SOW when the need for independent laboratory testing arises

HSCG23-14-R-MBS004

Pricing Spreadsheet

Attachment #1

HSCG23-14-R-MBS004

Option Period 1

Option Period 1
CLIN	CLIN Description	Quantity	UOM	Price Per UOM	Total Price
FFP
10001	Recreational Boat Factory Compliance Inspections	350	Inspection		$ - 0
10002	Recreational Boat Retailer Compliance Inspections	200	Inspection		$ - 0
10003	Recreational Boat Show Compliance Inspections	10	Show		$ - 0
10004	Recreational Boat Post-Casualty Inspections	20	Inspection		$ - 0
10005	NTE - Purchase, Test, and Sale of Recreational Boats	35			$ - 0
Breakdown for CLIN10005
Description		Quantity	UOM	Price Per UOM	Total
Boat Purchases*					$ 170,000.00
Percent of Each Boat's Purchase Price to be Billed to USCG					0%
Amount of All Boats' Purchase Price to be Billed to USCG					$ - 0
Testing of Recreational Boats		35	Test
Purchase, Test, and Sale of Recreational Boats		35	Not to Exceed (NTE)		$ - 0

10006	Recreational Boat MIC Database Management	12	Mo	$ - 0
10007	Recreational Boat Document Management	12	Mo	$ - 0
10008	Recreational Boating Safety Outreach - unpriced
10008A	CD Production of "Boat Builders Handbook"	500	Ea	$ - 0
10008B	Hosting of Web-Based Video Portal	12	Mo	$ - 0
10008C	Boating Safety Training Video	2	Ea	$ - 0
10009	NTE - Independent Laboratory Testing**			$ 75,000.00

TOTAL CLINs 10001 - 10009

ODCs
10010	NTE - Travel	$ 150,000.00
10011	NTE - Unique Boats and Associated Equipment Purchases	$ 100,000.00
10012	NTE - Transportation of Purchased Boats	$ 30,000.00
TOTAL ODCs		$ 280,000.00

Option Pd 1 Total

*$170,000 is estimated for purchasing Recreational Boats

**NTE Line Item - USCG will issue an addendum to the SOW when the need for independent laboratory testing arises

Option Period 2

Option Period 2
CLIN	CLIN Description	Quantity	UOM	Price Per UOM	Total Price
FFP
20001	Recreational Boat Factory Compliance Inspections	350	Inspection		$ - 0
20002	Recreational Boat Retailer Compliance Inspections	200	Inspection		$ - 0
20003	Recreational Boat Show Compliance Inspections	10	Show		$ - 0
20004	Recreational Boat Post-Casualty Inspections	20	Inspection		$ - 0
20005	NTE - Purchase, Test, and Sale of Recreational Boats	35			$ - 0
Breakdown for CLIN20005
Description		Quantity	UOM	Price Per UOM	Total
Boat Purchases*					$ 170,000.00
Percent of Each Boat's Purchase Price to be Billed to USCG					0%
Amount of All Boats' Purchase Price to be Billed to USCG					$ - 0
Testing of Recreational Boats		35	Test
Purchase, Test, and Sale of Recreational Boats		35	Not to Exceed (NTE)		$ - 0

20006	Recreational Boat MIC Database Management	12	Mo	$ - 0
20007	Recreational Boat Document Management	12	Mo	$ - 0
20008	Recreational Boating Safety Outreach - unpriced
20008A	CD Production of "Boat Builders Handbook"	500	Ea	$ - 0
20008B	Hosting of Web-Based Video Portal	12	Mo	$ - 0
20008C	Boating Safety Training Video	2	Ea	$ - 0
20009	NTE - Independent Laboratory Testing**			$ 75,000.00

TOTAL CLINs 20001 - 20009

ODCs
20010	NTE - Travel	$ 150,000.00
20011	NTE - Unique Boats and Associated Equipment Purchases	$ 100,000.00
20012	NTE - Transportation of Purchased Boats	$ 30,000.00
TOTAL ODCs		$ 280,000.00

Option Pd 2 Total

*$170,000 is estimated for purchasing Recreational Boats

**NTE Line Item - USCG will issue an addendum to the SOW when the need for independent laboratory testing arises

Option Period 3

Option Period 3
CLIN	CLIN Description	Quantity	UOM	Price Per UOM	Total Price
FFP
30001	Recreational Boat Factory Compliance Inspections	350	Inspection		$ - 0
30002	Recreational Boat Retailer Compliance Inspections	200	Inspection		$ - 0
30003	Recreational Boat Show Compliance Inspections	10	Show		$ - 0
30004	Recreational Boat Post-Casualty Inspections	20	Inspection		$ - 0
30005	NTE - Purchase, Test, and Sale of Recreational Boats	35			$ - 0
Breakdown for CLIN30005
Description		Quantity	UOM	Price Per UOM	Total
Boat Purchases*					$ 170,000.00
Percent of Each Boat's Purchase Price to be Billed to USCG					0%
Amount of All Boats' Purchase Price to be Billed to USCG					$ - 0
Testing of Recreational Boats		35	Test
Purchase, Test, and Sale of Recreational Boats		35	Not to Exceed (NTE)		$ - 0

30006	Recreational Boat MIC Database Management	12	Mo	$ - 0
30007	Recreational Boat Document Management	12	Mo	$ - 0
30008	Recreational Boating Safety Outreach - unpriced
30008A	CD Production of "Boat Builders Handbook"	500	Ea	$ - 0
30008B	Hosting of Web-Based Video Portal	12	Mo	$ - 0
30008C	Boating Safety Training Video	2	Ea	$ - 0
30009	NTE - Independent Laboratory Testing**			$ 75,000.00

TOTAL CLINs 30001 - 30009

ODCs
30010	NTE - Travel	$ 150,000.00
30011	NTE - Unique Boats and Associated Equipment Purchases	$ 100,000.00
30012	NTE - Transportation of Purchased Boats	$ 30,000.00
TOTAL ODCs		$ 280,000.00

Option Pd 3 Total

*$170,000 is estimated for purchasing Recreational Boats

**NTE Line Item - USCG will issue an addendum to the SOW when the need for independent laboratory testing arises

Option Period 4

Option Period 4
CLIN	CLIN Description	Quantity	UOM	Price Per UOM	Total Price
FFP
40001	Recreational Boat Factory Compliance Inspections	350	Inspection		$ - 0
40002	Recreational Boat Retailer Compliance Inspections	200	Inspection		$ - 0
40003	Recreational Boat Show Compliance Inspections	10	Show		$ - 0
40004	Recreational Boat Post-Casualty Inspections	20	Inspection		$ - 0
40005	NTE - Purchase, Test, and Sale of Recreational Boats	35			$ - 0
Breakdown for CLIN40005
Description		Quantity	UOM	Price Per UOM	Total
Boat Purchases*					$ 170,000.00
Percent of Each Boat's Purchase Price to be Billed to USCG					0%
Amount of All Boats' Purchase Price to be Billed to USCG					$ - 0
Testing of Recreational Boats		35	Test
Purchase, Test, and Sale of Recreational Boats		35	Not to Exceed (NTE)		$ - 0

40006	Recreational Boat MIC Database Management	12	Mo	$ - 0
40007	Recreational Boat Document Management	12	Mo	$ - 0
40008	Recreational Boating Safety Outreach - unpriced
40008A	CD Production of "Boat Builders Handbook"	500	Ea	$ - 0
40008B	Hosting of Web-Based Video Portal	12	Mo	$ - 0
40008C	Boating Safety Training Video	2	Ea	$ - 0
40009	NTE - Independent Laboratory Testing**			$ 75,000.00

TOTAL CLINs 40001 - 40009

ODCs
40010	NTE - Travel	$ 150,000.00
40011	NTE - Unique Boats and Associated Equipment Purchases	$ 100,000.00
40012	NTE - Transportation of Purchased Boats	$ 30,000.00
TOTAL ODCs		$ 280,000.00

Option Pd 4 Total

*$170,000 is estimated for purchasing Recreational Boats

**NTE Line Item - USCG will issue an addendum to the SOW when the need for independent laboratory testing arises

Sample of CLIN 00005

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 reflect what the contractor reasonably expects to recover by reselling the boat after testing.

The contractor shall apply the % to the Estimated Amount of Boat Purchases ($170,000), and provide a total price for CLIN0005.

The contractor may invoice when a Boat is purchased and tested. The process of reselling the boat is at the contractor's discretion.

SAMPLE BREAKDOWN FOR CLIN 00005

CLIN	Description	Quantity	UOM	Price Per UOM	Total Price
Boat Purchases					$ 170,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					$ 102,000.00
Testing of Recreational Boats		35	Test	$ 6,543.21	$ 229,012.35
Purchase, Test, and Sale of Recreational Boats (NTE)		35			$ 331,012.35
SAMPLE INVOICE FOR CLIN 00005
The contractor shall adjust purhcase price on the invoices by amount proposed. The contractor retains any remaining sale proceeds of the boat.
This sample is based on a boat purchased for $5,000.00.
CLIN 00005	Purchase, Test, and Sale of Recreational Boat
Test	$ 6,543.21
Purchase Price x 60%	$ 3,000.00
Invoice for CLIN 0005	$ 9,543.21		This worksheet is for informational purposes only.

HSCG23-14-R-MBS004

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