BLANK_IGE_175_WLM_Thruster_Groom__Assessment_30May2019.xlsx

XLSX spreadsheet 47 KB Posted Jun 4, 2019

Attached to: WLM THRUSTER GROOM
Solicitation number: 70Z085-19-Q-P4504500
Issued by: Department of Homeland Security US Coast Guard

About this file

From the source

Revised blank IGE/Section B/SOS

View the file

Other files

File	Type	Posted
WLM_Thruster_Drive_Groom_Specification_Package_Rev050219_30May2019.docx	DOCX document	Jun 4, 2019
Amendment_0006_WLM.pdf	PDF	Jun 4, 2019
Solicitation_Amended_WLM_175_THURSTER_GROOM.doc	DOC document	Jun 4, 2019
Amendment_0005.pdf	PDF	May 30, 2019
Amendment_0004.pdf	PDF	May 20, 2019
Amendment_0003_WLB_WLM_MPCMS.pdf	PDF	May 15, 2019
BLANK_IGE_175_WLM_Thruster_Groom__Assessment_20181211.xlsx	XLSX spreadsheet	May 15, 2019
Past_Performance_Questionnaire.doc	DOC document	May 15, 2019
Amendment_0002_WLM_THRUSTER.pdf	PDF	May 2, 2019
WLM_Thruster_Drive_Groom_Specification_Package_Rev050219.docx	DOCX document	May 2, 2019
Amendment_0001_WLM_Thruster_Groom.pdf	PDF	Apr 30, 2019
Solicitation_WLM_175_THURSTER_GROOM_Amended_29_April_2019.doc	DOC document	Apr 30, 2019
BLANK_IGE_175_WLM_Thruster_Groom__Assessment_20181211.xlsx	XLSX spreadsheet	Apr 23, 2019
Attachment_A_-_List_of_WLMs.docx	DOCX document	Apr 23, 2019
Request_for_Clarification_doc.docx	DOCX document	Apr 23, 2019
Past_Performance_Questionnaire.doc	DOC document	Apr 23, 2019
WLM_Thruster_Drive_Groom_Specification_Package_20190409_RAD.docx	DOCX document	Apr 23, 2019
OMBUDSMAN_PROGRAM_LETTER.docx	DOCX document	Apr 23, 2019
Solicitation_WLM_175_THURSTER_GROOM_17April2019.doc	DOC document	Apr 23, 2019

Show all 19

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.

PRICE SUMM

PRICING SUMMARY/PLANNED PERIODS OF PERFORMANCE Extended Price

BASE YEAR	(26 August 2018 - 25 August 2019)	ERROR:#REF!
OPTION YEAR ONE	(26 August 2019 - 25 August 2020)	ERROR:#REF!
OPTION YEAR TWO	(26 August 2020 - 25 August 2021)	ERROR:#REF!
OPTION YEAR THREE	(26 August 2021 - 25 August 2022)	ERROR:#REF!
OPTION YEAR FOUR	(26 August 2022 - 25 August 2023)	ERROR:#REF!
$ SET ASIDE FOR UNPLANNED SUPPORT (YR 1-2)		ERROR:#REF!
$ SET ASIDE FOR UNPLANNED SUPPORT (YR 3-5)		ERROR:#REF!

GRAND TOTAL PRICE BASE YEAR AND ALL OPTIONS	ERROR:#REF!
DEFINITE EXPENSES	ERROR:#REF!

IGE JUSTIFICATION

IGE was created with the following resources and suppositions:
	1. Ship visits will be performed by 1 technician on site for three 10-hr days.
	2. Travel costs used in tab "Travel & Per Diem Estimate" are reasonable estimates of cost for an IGE given that any company in CONUS could be awarded the contract and specific flight costs cannot be calculated.
	3. Per diem rates are based on FY18 GSA allowances.
	4. Labor rates used to estimate labor costs in tab "IGCE for Project" are fair-market value estimates for these specialties and industry.
	5. Material and consumables are not anticipated unless a CFR is submitted requesting a change. Regardless, $13k is added to both the base and option year total cost estimates.
	6. We must assume that overhead, profit margin, and G&A may add additional costs to the contract as indicated in tab "IGCE for Project."

SOSS BASE

			SCHEDULE OF SUPPLIES & SERVICES
			U.S. COAST GUARD IDIQ 175-FT BUOY TENDER (175 WLB)
CLIN	Specification Paragraph	Definite/Optional	BASE YEAR		Unit	Quantity	Price	Extended Price
0001	3.1	D	Full System Groom and Validation				N/A	N/A
0001AA			HULL 1	LOCATION 1	JB	1
0001AB			HULL 2	LOCATION 2	JB	1
0001AC			HULL 3	LOCATION 3	JB	1
0001AD			HULL 4	LOCATION 4	JB	1
0001AE			HULL 5	LOCATION 5	JB	1
0001AF			HULL 6	LOCATION 6	JB	1
0001AG			HULL 7	LOCATION 7	JB	1
							Total	$ - 0

0002	3.6	D	Remote Troubleshooting Support (Call Center)			N/A	N/A
0002AA			Technical Representative Hourly Rate (Straight Time)	HR	150
0002AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

0003	3.5	O	On-Site Troubleshooting Support (Unplanned)			N/A	N/A
0003AA			Technical Representative Hourly Rate (Straight Time)	HR	150
0003AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

0004	3.2	D	Circuit Card Services			N/A	N/A
0004AA			Technical Representative Hourly Rate (Straight Time)	HR	150
0004AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

0005	3.3	O	Engineering Services			N/A	N/A
0005AA			Technical Representative Hourly Rate (Straight Time)	HR	100
0005AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

0006		D	Groom Performance Plan			N/A	N/A
0006AA	3.1.1.1		Test Plan	JB	1
0006AB	5.1		Project Plan	JB	1
0006AC	6.1		Quality Assurance Plan	JB	1
						Total	$ - 0

TOTAL PRICE BASE YEAR Total ERROR:#REF!

SOSS OPT1

			SCHEDULE OF SUPPLIES & SERVICES
			U.S. COAST GUARD IDIQ 175-FT BUOY TENDER (175 WLB)
CLIN	Specification Paragraph	Definite/Optional	OPTION YEAR ONE		Unit	Quantity	Price	Extended Price
1001	3.1	D	Full System Groom and Validation				N/A	N/A
1001AA			HULL 8	LOCATION 8	JB	1
1001AB			HULL 9	LOCATION 9	JB	1
1001AC			HULL 10	LOCATION 10	JB	1
1001AD			HULL 11	LOCATION 11	JB	1
1001AE			HULL 12	LOCATION 12	JB	1
1001AF			HULL 13	LOCATION 13	JB	1
1001AG			HULL 14	LOCATION 14	JB	1
							Total	$ - 0

1002	3.6	D	Remote Troubleshooting Support (Call Center)			N/A	N/A
1002AA			Technical Representative Hourly Rate (Straight Time)	HR	150
1002AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

1003	3.5	O	On-Site Troubleshooting Support (Unplanned)			N/A	N/A
1003AA			Technical Representative Hourly Rate (Straight Time)	HR	150
1003AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

1004	3.2	D	Circuit Card Services			N/A	N/A
1004AA			Technical Representative Hourly Rate (Straight Time)	HR	150
1004AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

1005	3.3	O	Engineering Services			N/A	N/A
1005AA			Technical Representative Hourly Rate (Straight Time)	HR	100
1005AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

1006		D	Groom Performance Plan			N/A	N/A
1006AA	3.1.1.1		Test Plan	JB	1
1006AB	5.1		Project Plan	JB	1
1006AC	6.1		Quality Assurance Plan	JB	1
						Total	$ - 0

TOTAL PRICE OPTION YEAR ONE Total ERROR:#REF!

SOSS OPT2

			SCHEDULE OF SUPPLIES & SERVICES
			U.S. COAST GUARD IDIQ 175-FT BUOY TENDER (175 WLB)
CLIN	Specification Paragraph	Definite/Optional	OPTION YEAR TWO		Unit	Quantity	Price	Extended Price
2001	3.1	D	Full System Groom and Validation				N/A	N/A
2001AA			HULL 1	LOCATION 1	JB	1
2001AB			HULL 2	LOCATION 2	JB	1
2001AC			HULL 3	LOCATION 3	JB	1
2001AD			HULL 4	LOCATION 4	JB	1
							Total	$ - 0

2002	3.6	D	Remote Troubleshooting Support (Call Center)			N/A	N/A
2002AA			Technical Representative Hourly Rate (Straight Time)	HR	150
2002AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

2003	3.5	O	On-Site Troubleshooting Support (Unplanned)			N/A	N/A
2003AA			Technical Representative Hourly Rate (Straight Time)	HR	150
2003AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

2004	3.2	D	Circuit Card Services			N/A	N/A
2004AA			Technical Representative Hourly Rate (Straight Time)	HR	150
2004AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

2005	3.3	O	Engineering Services			N/A	N/A
2005AA			Technical Representative Hourly Rate (Straight Time)	HR	100
2005AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

2006		D	Groom Performance Plan			N/A	N/A
2006AA	3.1.1.1		Test Plan	JB	1
2006AB	5.1		Project Plan	JB	1
2006AC	6.1		Quality Assurance Plan	JB	1
						Total	$ - 0

TOTAL PRICE OPTION YEAR TWO Total ERROR:#REF!

SOSS OPT3

			SCHEDULE OF SUPPLIES & SERVICES
			U.S. COAST GUARD IDIQ 175-FT BUOY TENDER (175 WLB)
CLIN	Specification Paragraph	Definite/Optional	OPTION YEAR THREE		Unit	Quantity	Price	Extended Price
3001	3.1	D	Full System Groom and Validation				N/A	N/A
3001AA			HULL 1	LOCATION 1	JB	1
3001AB			HULL 2	LOCATION 2	JB	1
3001AC			HULL 3	LOCATION 3	JB	1
3001AD			HULL 4	LOCATION 4	JB	1
							Total	$ - 0

3002	3.6	D	Remote Troubleshooting Support (Call Center)			N/A	N/A
3002AA			Technical Representative Hourly Rate (Straight Time)	HR	150
3002AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

3003	3.5	O	On-Site Troubleshooting Support (Unplanned)			N/A	N/A
3003AA			Technical Representative Hourly Rate (Straight Time)	HR	150
3003AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

3004	3.2	D	Circuit Card Services			N/A	N/A
3004AA			Technical Representative Hourly Rate (Straight Time)	HR	150
3004AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

3005	3.3	O	Engineering Services			N/A	N/A
3005AA			Technical Representative Hourly Rate (Straight Time)	HR	100
3005AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

3006		D	Groom Performance Plan			N/A	N/A
3006AA	3.1.1.1		Test Plan	JB	1
3006AB	5.1		Project Plan	JB	1
3006AC	6.1		Quality Assurance Plan	JB	1
						Total	$ - 0

TOTAL PRICE OPTION YEAR THREE Total ERROR:#REF!

SOSS OPT4

			SCHEDULE OF SUPPLIES & SERVICES
			U.S. COAST GUARD IDIQ 175-FT BUOY TENDER (175 WLB)
CLIN	Specification Paragraph	Definite/Optional	OPTION YEAR FOUR		Unit	Quantity	Price	Extended Price
4001	3.1	D	Full System Groom and Validation				N/A	N/A
4001AA			HULL 1	LOCATION 1	JB	1
4001AB			HULL 2	LOCATION 2	JB	1
4001AC			HULL 3	LOCATION 3	JB	1
4001AD			HULL 4	LOCATION 4	JB	1
							Total	$ - 0

4002	3.6	D	Remote Troubleshooting Support (Call Center)			N/A	N/A
4002AA			Technical Representative Hourly Rate (Straight Time)	HR	150
4002AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

4003	3.5	O	On-Site Troubleshooting Support (Unplanned)			N/A	N/A
4003AA			Technical Representative Hourly Rate (Straight Time)	HR	150
4003AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

4004	3.2	D	Circuit Card Services			N/A	N/A
4004AA			Technical Representative Hourly Rate (Straight Time)	HR	150
4004AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

4005	3.3	O	Engineering Services			N/A	N/A
4005AA			Technical Representative Hourly Rate (Straight Time)	HR	100
4005AB			Technical Representative Hourly Rate (Overtime)	HR	10
						Total	$ - 0

4006		D	Groom Performance Plan			N/A	N/A
4006AA	3.1.1.1		Test Plan	JB	1
4006AB	5.1		Project Plan	JB	1
4006AC	6.1		Quality Assurance Plan	JB	1
						Total	$ - 0

TOTAL PRICE OPTION YEAR FOUR Total ERROR:#REF!

Travel & Per Diem Estimate

Cutter	Hull Number	Homeport	Per Diem + Max Lodging (Based on FY18 GSA Schedule)	Rountrip Flight (Est)	Weekly MiniVan Rental (Est)	Trip Cost (Not Including Overhead, G&A, and Profit) - Planned Groom/Unplanned Trip	Trip Cost (Including Overhead, G&A, and Profit) - Planned Groom/Unplanned Trip
ABBIE BURGESS	WLM-553	ROCKLAND, ME	$170	$688	$797	$3,325	$5,154
ANTHONY PETIT	WLM-558	KETCHIKAN, AK	$339	$766	$360	$2,793	$4,329
BARBARA MABRITY	WLM-559	MOBILE, AL	$157	$715	$404	$2,240	$3,473
FRANK DREW	WLM-557	PORTSMOUTH, VA	$144	$709	$355	$2,146	$3,326
GEORGE COBB	WLM-564	SAN PEDRO, CA	$237	$617	$270	$2,248	$3,484
HARRY CLAIBORNE	WLM-561	GALVESTON, TX	$185	$648	$404	$2,257	$3,498
HENRY BLAKE	WLM-563	EVERETT, WA	$199	$611	$300	$2,158	$3,345
IDA LEWIS	WLM-551	NEWPORT, RI	$271	$619	$460	$2,542	$3,940
JAMES RANKIN	WLM-555	BALTIMORE, MD	$238	$595	$345	$2,304	$3,571
JOSHUA APPLEBY	WLM-556	ST PETERSBURG, FL	$208	$593	$308	$2,175	$3,371
KATHERINE WALKER	WLM-552	BAYONNE, NJ	$205	$679	$415	$2,359	$3,657
MARCUS HANNA	WLM-554	SOUTH PORTLAND, ME	$168	$688	$391	$2,233	$3,462
MARIA BRAY	WLM-562	MAYPORT, FL	$144	$663	$307	$2,052	$3,180
WILLIAM TATE	WLM-560	PHILADELPHIA, PA	$266	$657	$504	$2,609	$4,044

AVG $209 $661 $401 $2,389 $3,702

IGCE for Project

IGE for 175 WLB Thruster System Groom and Assessement (In Support of MPCMS Recap Efforts)
IGE Totals
	# of visits	Labor & Matl	Travel & Per Diem	TOTAL
Base Yr (7 cutters)	7
OY1 (5 cutters)	7

				Per cutter Labor & Matl		Per cutter Travel & Per Diem
				Labor		Travel & Per Diem
				Material
Multipliers				Overhead		Overhead
Overhead	25.00%			G&A		G&A
G&A	15.00%			Profit		Profit
Profit	15.00%
Labor Rates
Category	ST	OT
Project Manager
Electronics Technician
Electronics Engineer
Avg Trip Expenses
Per Diem
Flight (roundtrip)
Minivan Rental (week)
Ship Visit
Personnel:	One (1 Technician) On-Site, Project Manager at Office
Duration:	Assuming 3 days on site, 10-hr days (24 ST hrs, 6 OT hrs) for on-site reps
	Labor	Per Diem	Airfare	Misc Expenses	Minivan
Project Manager	$0.00	$0.00	$0.00	$0.00
Technician	$0.00	$0.00	$0.00

TOTAL $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Additional Costs Per Visit

Misc Materials, Parts & Consumables

TOTAL	$0.00	$0.00
Additional Costs / One Time Start-up

Misc Materials, Parts & Consumables	$0.00
TOTAL	$0.00	$0.00

File details come from the government source that posted it.