ATTH 16 TEP workbook.xlsx

XLSX spreadsheet 43 KB Posted Sep 17, 2021

Attached to: HUD Nationwide Construction Inspection Services
Solicitation number: SOLICITATION-86614121R00001
Issued by: Department of Housing and Urban Development

View the file

Other files

File	Type	Posted
Amendment 0003_Sol 86614121R00001.pdf	PDF	Oct 20, 2021
Sol_86614121R00001_Amd_0002.pdf	PDF	Oct 13, 2021
ATTH 18 HUD response to CIS Solicitation questions.pdf	PDF	Oct 5, 2021
Amendment 0001_86614121R00001.pdf	PDF	Oct 5, 2021
ATTH 4 CDR.docx	DOCX document	Sep 17, 2021
ATTH 2 Construction Inspection Services QASP .pdf	PDF	Sep 17, 2021
ATTH 9 Midwest FHA map.pdf	PDF	Sep 17, 2021
ATTH 3 Incentives Summary .docx	DOCX document	Sep 17, 2021
ATTH 14 Sample Client Authorization_Letter.docx	DOCX document	Sep 17, 2021
ATTH 10 Northeast FHA map.pdf	PDF	Sep 17, 2021
ATTH 1 Construction Inspection Services PWS 09142021.pdf	PDF	Sep 17, 2021
ATTH 12 Southwest FHA map.pdf	PDF	Sep 17, 2021
ATTH 8 Sample Trip Report_HUD-95379.pdf	PDF	Sep 17, 2021
ATTH 13 West FHA map.pdf	PDF	Sep 17, 2021
ATTH 5 Project Description.docx	DOCX document	Sep 17, 2021
ATTH 11 Southeast FHA map.pdf	PDF	Sep 17, 2021
ATTH 17 SF330-16i.pdf	PDF	Sep 17, 2021
ATTH 6 Nondisclosure-Agreement-between-HUD-and-Contractor-Employee.docx	DOCX document	Sep 17, 2021
ATTH 7 HUD-95379 Trip Report .docx	DOCX document	Sep 17, 2021
ATTH 15 Survey Attachment.docx	DOCX document	Sep 17, 2021
Sol_86614121R00001.pdf	PDF	Sep 17, 2021

Show all 21

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 This workbook includes five (5) Total Evaluated Price (TEP) worksheets, one for each region: NorthEast (NE), SouthEast (SE), SouthWest (SW), West (W) and MidWest (MW).

Step 1: Select region worksheet for which your firm intends on submitting an offer. The Proposal Letter referenced for that corresponding region will also be referenced with the title used on the written proposal(s) and must be consistent with the submission of the email subject line requirements: FOUO\\INFO: Insert Solicitation Number, Company Name/Proposal and Name of Region/Offer.

Step 2: In Column "G" provide the corresponding CLIN Firm-Fixed Prices (FFP). All FFP must be rounded to the nearest dollar. The Proposal Worksheets include math to develop the TEP. No further action is needed on "Proposal" Worksheets.

Step 3: Provide mathematical formulas and data to support pricing in additional worksheets.

Step 4: Describe the inputs of the mathematical formuals and data in your Price Proposal.

Proposal A "NE" NorthEast: Washington D.C, New York, Pennsylvania, New Jersey, Rhode Island, Maryland, Connecticut, Massachusetts, Virginia, West Virginia, New Hampshire, Vermont, Delaware, and Maine

CLIN	Description of Supply or Service		Max qty ***	BEQ qty	FFP**	Total= BEQ Units * FFP	Ceiling= Max Units * FFP
0001	Year 1 NorthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	1,295	1,036		$0	$0
1A		Virtual	65	52		$0	$0
1B		In-person	1,230	984		$0	$0
0002	Year 2 NorthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	1,486	1,189		$0	$0
2A		Virtual	74	59		$0	$0
2B		In-person	1,412	1,130		$0	$0
0003	Year 3 NorthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	1,705	1,364		$0	$0
3A		Virtual	85	68		$0	$0
3B		In-person	1,620	1,296		$0	$0
0004	Year 4 NorthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	1,956	1,565		$0	$0
4A		Virtual	98	78		$0	$0
4B		In-person	1,858	1,487		$0	$0
0005	Year 5 NorthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	2,244	1,795		$0	$0
5A		Virtual	112	90		$0	$0
5B		In-person	2,132	1,705		$0	$0
0005	52.217-8 extension option			898	0	$0
0006	Transition In-Out Site Visits			130	0	$0
Total Estimated FFP dollar value = Cumulative total of five years plus the optional six month extension.						$0	$0
**All Firm-Fixed Prices (FFP) must be rounded to the nearest dollar.
***The Maximum (Max) Estimated Quanity (qty) cumulative total will be used to establish the maximum amount in paragraph (b) in 2452.216-76 MINIMUM AND MAXIMUM QUANTITIES OR AMOUNTS FOR ORDER

****The Best Estimated Quanity (BEQ) cumulative total will be used to evaluate the total evaluated price.

Proposal B "SE" SouthEast (SE): Puerto Rico, Georgia, Kentucky, Tennessee, North Carolina, South Carolina, Florida, Mississippi, Alabama

CLIN	Description of Supply or Service		Max qty ***	BEQ qty	FFP**	Total= BEQ Units * FFP	Ceiling= Max Units * FFP
0001	Year 1 SouthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	2,200	1,760		$0	$0
1A		Virtual	110	88		$0	$0
1B		In-person	2,090	1,672		$0	$0
0002	Year 2 SouthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	2,411	1,929		$0	$0
2A		Virtual	121	96		$0	$0
2B		In-person	2,291	1,833		$0	$0
0003	Year 3 SouthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	2,643	2,114		$0	$0
3A		Virtual	132	106		$0	$0
3B		In-person	2,510	2,008		$0	$0
0004	Year 4 SouthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	2,896	2,317		$0	$0
4A		Virtual	145	116		$0	$0
4B		In-person	2,751	2,201		$0	$0
0005	Year 5 SouthEast Construction Inspections or HUD scheduled Preconstruction meeting	Total	3,186	2,549		$0	$0
5A		Virtual	159	127		$0	$0
5B		In-person	3,027	2,422		$0	$0
0005	52.217-8 extension option			1,275	0	$0
0006	Transition In-Out Site Visists			246	0	$0
Total Estimated FFP dollar value = Cumulative total of five years plus the optional six month extension.						$0	$0
**All Firm-Fixed Prices (FFP) must be rounded to the nearest dollar.
***The Maximum (Max) Estimated Quanity (qty) cumulative total will be used to establish the maximum amount in paragraph (b) in 2452.216-76 MINIMUM AND MAXIMUM QUANTITIES OR AMOUNTS FOR ORDER

****The Best Estimated Quanity (BEQ) cumulative total will be used to evaluate the total evaluated price.

Proposal C "SW" SouthWest (SW): Texas, New Mexico, Oklahoma, Louisiana, Arkansas, Missouri, Iowa, Nebraska and Kansas

CLIN	Description of Supply or Service		Max qty ***	BEQ qty	FFP**	Total= BEQ Units * FFP	Ceiling= Max Units * FFP
0001	Year 1 SouthWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	2,698	2,158		$0	$0
1A		Virtual	135	108		$0	$0
1B		In-person	2,563	2,050		$0	$0
0002	Year 2 SouthWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	2,944	2,355		$0	$0
2A		Virtual	147	118		$0	$0
2B		In-person	2,797	2,237		$0	$0
0003	Year 3 SouthWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	3,214	2,571		$0	$0
3A		Virtual	161	129		$0	$0
3B		In-person	3,053	2,442		$0	$0
0004	Year 4 SouthWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	3,508	2,806		$0	$0
4A		Virtual	175	140		$0	$0
4B		In-person	3,332	2,666		$0	$0
0005	Year 5 SouthWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	3,829	3,063		$0	$0
5A		Virtual	191	153		$0	$0
5B		In-person	3,637	2,910		$0	$0
0005	52.217-8 extension option			1,532	0	$0
0006	Transition In-Out Site Visists			308	0	$0
Total Estimated FFP dollar value = Cumulative total of five years plus the optional six month extension.						$0	$0
**All Firm-Fixed Prices (FFP) must be rounded to the nearest dollar.
***The Maximum (Max) Estimated Quanity (qty) cumulative total will be used to establish the maximum amount in paragraph (b) in 2452.216-76 MINIMUM AND MAXIMUM QUANTITIES OR AMOUNTS FOR ORDER

****The Best Estimated Quanity (BEQ) cumulative total will be used to evaluate the total evaluated price.

Proposal D "W" West (W): Alaska, Arizona, California, Colorado, Hawaii, Idaho, Montana, Nevada, North Dakota, Oregon, South Dakota, Utah, Washington and Wyoming

CLIN	Description of Supply or Service		Max qty ***	BEQ qty	FFP**	Total= BEQ Units * FFP	Ceiling= Max Units * FFP
0001	Year 1 West Construction Inspections or HUD scheduled Preconstruction meeting	Total	1,448	1,158		$0	$0
1A		Virtual	72	58		$0	$0
1B		In-person	1,375	1,100		$0	$0
0002	Year 2 West Construction Inspections or HUD scheduled Preconstruction meeting	Total	1,749	1,399		$0	$0
2A		Virtual	87	70		$0	$0
2B		In-person	1,661	1,329		$0	$0
0003	Year 3 West Construction Inspections or HUD scheduled Preconstruction meeting	Total	2,114	1,691		$0	$0
3A		Virtual	106	85		$0	$0
3B		In-person	2,008	1,606		$0	$0
0004	Year 4 West Construction Inspections or HUD scheduled Preconstruction meeting	Total	2,553	2,042		$0	$0
4A		Virtual	128	102		$0	$0
4B		In-person	2,425	1,940		$0	$0
0005	Year 5 West Construction Inspections or HUD scheduled Preconstruction meeting	Total	3,084	2,467		$0	$0
5A		Virtual	154	123		$0	$0
5B		In-person	2,930	2,344		$0	$0
0005	52.217-8 extension option			1,234	0	$0
0006	Transition In-Out Site Visists			126	0	$0
Total Estimated FFP dollar value = Cumulative total of five years plus the optional six month extension.						$0	$0
**All Firm-Fixed Prices (FFP) must be rounded to the nearest dollar.
***The Maximum (Max) Estimated Quanity (qty) cumulative total will be used to establish the maximum amount in paragraph (b) in 2452.216-76 MINIMUM AND MAXIMUM QUANTITIES OR AMOUNTS FOR ORDER

****The Best Estimated Quanity (BEQ) cumulative total will be used to evaluate the total evaluated price.

Proposal E "MW" MidWest (MW): Illinois, Michigan, Ohio, Indiana, Wisconsin, and Minnesota

	CLIN	Description of Supply or Service		Max qty ***	BEQ qty	FFP**	Total= BEQ Units * FFP	Ceiling= Max Units * FFP
	0001	Year 1 MidWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	371	297		$0	$0
	1A		Virtual	19	15		$0	$0
	1B		In-person	353	282		$0	$0
	0002	Year 2 MidWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	405	324		$0	$0
	2A		Virtual	20	16		$0	$0
	2B		In-person	385	308		$0	$0
	0003	Year 3 MidWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	443	354		$0	$0
	3A		Virtual	22	18		$0	$0
	3B		In-person	420	336		$0	$0
	0004	Year 4 MidWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	484	387		$0	$0
	4A		Virtual	24	19		$0	$0
	4B		In-person	460	368		$0	$0
Year 5	0005	Year 5 MidWest Construction Inspections or HUD scheduled Preconstruction meeting	Total	528	422		$0	$0
	5A		Virtual	26	21		$0	$0
	5B		In-person	501	401		$0	$0
Year 5-1/2	0005	52.217-8 extension option			211	0	$0
	0006	Transition In-Out Site Visists			38	0	$0
	Total Estimated FFP dollar value = Cumulative total of five years plus the optional six month extension.						$0	$0
	**All Firm-Fixed Prices (FFP) must be rounded to the nearest dollar.
	***The Maximum (Max) Estimated Quanity (qty) cumulative total will be used to establish the maximum amount in paragraph (b) in 2452.216-76 MINIMUM AND MAXIMUM QUANTITIES OR AMOUNTS FOR ORDER

****The Best Estimated Quanity (BEQ) cumulative total will be used to evaluate the total evaluated price.

File details come from the government source that posted it. Updated Sep 17, 2021.