ATTACHMENT_1_-_Proposed_Pricing_Schedule.xlsx

XLSX spreadsheet 33 KB Posted Feb 7, 2018

Attached to: Interface Alarm Generator Panel (IAGP) Recapitalization
Solicitation number: 70Z07918RPT200200
Issued by: Department of Homeland Security US Coast Guard

About this file

From the source

Attachment 1- Proposed Pricing Schedule

View the file

Other files

File	Type	Posted
RFP_70Z07918RPT200200_Sections_I-III_Amendment_000001.pdf	PDF	Mar 1, 2018
ATTACHMENT_30_-_618-WMEC_433_2_1_-_G.PDF	PDF	Mar 1, 2018
ATTACHMENT_27_-_618-WMEC_432_1_1_-_K.PDF	PDF	Mar 1, 2018
ATTACHMENT_29_-_618-WMEC_433_1_1_-_H.PDF	PDF	Mar 1, 2018
ATTACHMENT_31_-_627-WMEC_432_1_1_-_M.PDF	PDF	Mar 1, 2018
Amendment_000001_SF_30.pdf	PDF	Mar 1, 2018
RFP_70Z07918RPT200200_Amendment_000001_Questions_and_Answers.pdf	PDF	Mar 1, 2018
ATTACHMENT_32_-_627-WMEC_433_1_1_-_B.PDF	PDF	Mar 1, 2018
ATTACHMENT_28_-_618-WMEC_432_5_1_-_H.PDF	PDF	Mar 1, 2018
ATTACHMENT_11.pdf	PDF	Feb 7, 2018
ATTACHMENT_12.pdf	PDF	Feb 7, 2018
ATTACHMENT_3_-_DHS_Form_700-21.pdf	PDF	Feb 7, 2018
ATTACHMENT_2_-_STATEMENT_OF_WORK.pdf	PDF	Feb 7, 2018
RFP_70Z07918RPT200200.pdf	PDF	Feb 7, 2018
ATTACHMENT_19_Engineering_Change_(SSR).pdf	PDF	Feb 7, 2018
ATTACHMENT_20_-_IAGP_Instruction_Manual_(Part_I).pdf	PDF	Feb 7, 2018
ATTACHMENT_13.pdf	PDF	Feb 7, 2018
ATTACHMENT_25_-_DD_254_(Draft).pdf	PDF	Feb 7, 2018
ATTACHMENT_21_-_IAGP_Instruction_Manual_Part_II.pdf	PDF	Feb 7, 2018
ATTACHMENT_18.pdf	PDF	Feb 7, 2018
ATTACHMENT_9.pdf	PDF	Feb 7, 2018
ATTACHMENT_8.pdf	PDF	Feb 7, 2018
ATTACHMENT_22_-_IAGP_Instruction_Manual_Part_III.pdf	PDF	Feb 7, 2018
ATTACHMENT_16.pdf	PDF	Feb 7, 2018
ATTACHMENT_17.pdf	PDF	Feb 7, 2018
ATTACHMENT_24_-_IAGP_Instruction_Manual_Part_V.pdf	PDF	Feb 7, 2018
ATTACHMENT_6.pdf	PDF	Feb 7, 2018
ATTACHMENT_10.pdf	PDF	Feb 7, 2018
ATTACHMENT_26.pdf	PDF	Feb 7, 2018
ATTACHMENT_15.pdf	PDF	Feb 7, 2018
ATTACHMENT_14.pdf	PDF	Feb 7, 2018
ATTACHMENT_4-_IAGP_PROPOSAL_CROSSWALK.xlsx	XLSX spreadsheet	Feb 7, 2018
ATTACHMENT_5_-_DHS_Form_700-03.pdf	PDF	Feb 7, 2018
ATTACHMENT_23_-_IAGP_Instruction_Manual_Part_IV.pdf	PDF	Feb 7, 2018
ATTACHMENT_7.xlsx	XLSX spreadsheet	Feb 7, 2018

Show all 35

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.

Installation Labor

Tab 1, Section 1, INSTALLATIONS: Propose Labor Categories/Hours
Labor Category	Contract Year ONE
	Est. # of Installations	Proposed # Hours	Hourly Rate	Total Year ONE
Program Manager	2		$ - 0	$ - 0
SME Supervisor III	2		$ - 0	$ - 0
Installation Field Engineer	2		$ - 0	$ - 0
Installation Technician	2		$ - 0	$ - 0
Hardware Engineer I	2		$ - 0	$ - 0
Hardware Engineer II	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
TOTAL LABOR, Year ONE		0		$ - 0
Labor Category	Contract Year TWO
	Est. # of Installations	Proposed # Hours	Hourly Rate	Total Year TWO
Program Manager	2		$ - 0	$ - 0
SME Supervisor III	2		$ - 0	$ - 0
Installation Field Engineer	2		$ - 0	$ - 0
Installation Technician	2		$ - 0	$ - 0
Hardware Engineer I	2		$ - 0	$ - 0
Hardware Engineer II	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
TOTAL LABOR, Year TWO		0		$ - 0
Labor Category	Contract Year THREE
	Est. # of Installation	Proposed # Hours	Hourly Rate	Total Year THREE
Program Manager	4		$ - 0	$ - 0
SME Supervisor III	4		$ - 0	$ - 0
Installation Field Engineer	4		$ - 0	$ - 0
Installation Technician	4		$ - 0	$ - 0
Hardware Engineer I	4		$ - 0	$ - 0
Hardware Engineer II	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
TOTAL LABOR, Year THREE		0		$ - 0
Labor Category	Contract Year FOUR
	Est. # of Installation	Proposed # Hours	Hourly Rate	Total Year FOUR
Program Manager	4		$ - 0	$ - 0
SME Supervisor III	4		$ - 0	$ - 0
Installation Field Engineer	4		$ - 0	$ - 0
Installation Technician	4		$ - 0	$ - 0
Hardware Engineer I	4		$ - 0	$ - 0
Hardware Engineer II	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	4		$ - 0	$ - 0
TOTAL LABOR, Year FOUR		0		$ - 0

Labor Category	Contract Year FIVE
	Est. # of Installation	Proposed # Hours	Hourly Rate	Total Year FIVE
Program Manager	2		$ - 0	$ - 0
SME Supervisor III	2		$ - 0	$ - 0
Installation Field Engineer	2		$ - 0	$ - 0
Installation Technician	2		$ - 0	$ - 0
Hardware Engineer I	2		$ - 0	$ - 0
Hardware Engineer II	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
(Offeror May Propose Additional Labor Category Here)	2		$ - 0	$ - 0
TOTAL LABOR, Year FIVE		0		$ - 0

	Contract Years ONE through FIVE
	Est. # of Installations	Proposed # Hours	Total Labor ($)
TOTAL LABOR (Years ONE through FIVE)	14	0	$ - 0

ASSUME: Travel (For Installations, Years ONE through FIVE)
Contract Year	Est. # of Installations	Est. Travel ($) Per Installation	Total Travel (Est. $)
Year One	2	$8,391.00	$16,782.00
Year Two	2	$8,642.73	$17,285.46
Year Three	4	$8,902.01	$35,608.05
Year Four	4	$9,169.07	$36,676.29
Year Five	2	$9,444.14	$18,888.29
TOTAL TRAVEL (Estimated), Years ONE through FIVE			$125,240.09

RFP# 70Z07918RPT200200

Attachment 1 (Worksheet: Enter Installation Labor Hours and Hourly Rates)

70Z07918RPT200200 Tab 1 - Installation Labor

Materials MSRP and Discount

IAGP Materials
IAGP SYSTEM HARDWARE (UNITS)
Manufacturer	Part No.	Systems Hardware (Unit Name)	Qty	Manufacturer Suggested Retail Price (MSRP)	Total
		IAGP System Equipment	14		$ - 0
		IAGP Human Interface Terminal	14		$ - 0
ANCILLARY SUPPLIES
Manufacturer	Part No.	Description	Qty	Manufacturer Suggested Retail Price (MSRP)	Total
		Cabling (Quantity: Price by Foot)	11000		$ - 0
		Speakers (Quantity: Price by Each)	42		$ - 0
		Other Ancillary Supplies(e.g., Wiring Blocks, Connectors, Terminals; Price by Each)			$ - 0
IAGP SYSTEM HARDWARE COMPONENTS (PARTS)
IAGP SYSTEM EQUIPMENT: COMPONENTS
Manufacturer	Part No.	Component (Item Name)	Qty	Manufacturer Suggested Retail Price (MSRP)	Total
					$ - 0
					$ - 0
					$ - 0
					$ - 0
					$ - 0
					$ - 0
					$ - 0
					$ - 0
HUMAN INTERFACE TERMINAL: COMPONENTS
Manufacturer	Part No.	Component (Item Name)	Qty	Manufacturer Suggested Retail Price (MSRP)	Total
					$ - 0
					$ - 0
					$ - 0
					$ - 0
					$ - 0
					$ - 0
					$ - 0
					$ - 0
					$ - 0
	ESTIMATED PRICE, MATERIALS (Note to Offeror: Propose Year One Pricing)

	Estimated Price, Materials (Year One)
TOTAL IAGP Systems Hardware (UNITS):	$ - 0
TOTAL Ancillary Supplies:	$ - 0
TOTAL IAGP System Equipment (COMPONENTS):	$ - 0
TOTAL Human Interface Terminal (COMPONENTS):	$ - 0
SUBTOTAL Materials:	$ - 0
OFFEROR: PROPOSE MATERIALS DISCOUNT (%):
OFFEROR'S PROPOSED MATERIALS DISCOUNT ($):	$ - 0
TOTAL ESTIMATED PRICE, MATERIALS (Including Proposed Materials Discount):	$ - 0

RFP #70Z07918RPT200200

Attachment 1 (Worksheet: Enter Materials MSRP and Discount)

70Z07918RPT200200 Tab 2 - Materials MSRP and Discount

TEP

Labor Category	Contract Year One			Contract Year Two
	Hourly Rate	Proposed # Hours	Total	Hourly Rate	Proposed # Hours	Total
Program Manager	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
SME Supervisor III	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Installation Field Engineer	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Installation Technician	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Hardware Engineer I	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Hardware Engineer II	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Labor Price			$ - 0			$ - 0

Labor Category	Contract Year Three			Contract Year Four			Contract Year Five
	Hourly Rate	Proposed # Hours	Total	Hourly Rate	Proposed # Hours	Total	Hourly Rate	Proposed # Hours	Total
Program Manager	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
SME Supervisor III	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Installation Field Engineer	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Installation Technician	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Hardware Engineer I	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Hardware Engineer II	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
(Offeror May Propose Additional Labor Category Here)	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0	$ - 0	0.00	$ - 0
Labor Price			$ - 0			$ - 0			$ - 0

	IAGP Materials (IAGP Systems Hardware and Ancillary Supplies)		Estimated IAGP Materials Price Year One	Estimated IAGP Materials Price Year Two
(3% increase on Estimated Materials Price Year One)		Estimated IAGP Materials Price Year Three
(3% increase on Estimated Materials Price Year Two)		Estimated IAGP Materials Price Year Four
(3% increase on Estimated Materials Price Year Three)		Estimated IAGP Materials Price Year Five

(3% increase on Estimated Materials Price Year Four)

IAGP Systems Hardware	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Ancillary Supplies	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
IAGP System Equipment: Components	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
Human Interface Terminal: Components	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0
IAGP Materials Price	$ - 0	$ - 0	$ - 0	$ - 0	$ - 0

Pricing Totals
Total Labor Price	$ - 0
Total IAGP Materials Price (Prior to Application of Proposed Discount)	$ - 0
Offeror's Proposed Discount (%), Materials	0.00%
Offeror's Proposed Discount ($), Materials	$ - 0
Total Materials (Including Discount)	$ - 0
Total Travel (Estimated)	$ 125,240.09

Total Evaluated Price $ 125,240.09

RFP #70Z07918RPT200200

Attachment 1 (Worksheet: Total Evaluated Price (TEP))

70Z07918RPT200200 Tab 3 - Total Evaluated Price (TEP)

Sheet2

File details come from the government source that posted it.