Atch J.6 - Section B Prices and Contractor Personnel - 07-22-2024.xlsx

XLSX spreadsheet 20 KB Posted Jul 22, 2024

Attached to: Housing Insecurity Research Support for the AHS
Solicitation number: 86614624Q00001
Issued by: Department of Housing and Urban Development

About this file

Written by GovTribe AI · Jul 22, 2024

This document is a pricing spreadsheet and personnel chart for a federal contract opportunity issued by the U.S. Department of Housing and Urban Development (HUD).

The contract requires the successful offeror to provide services for Housing Insecurity Research Support for HUD's American Housing Survey (AHS). Key services include generating an updated literature review on housing insecurity, convening an expert roundtable, developing analysis plans, performing initial analysis of AHS public-use data, and producing interim and final reports. Pricing is provided for fixed-price and cost-reimbursement contract line items covering project management, literature review, expert roundtable, analysis planning, initial data analysis, and report development tasks. The contract has a base year and a one-year option period. The solicitation is a 100% small business set-aside with proposals due July 19, 2024.

View the file

Other files

File	Type	Posted
86614624Q00001 - 0004 - 08-05-24.pdf	PDF	Aug 5, 2024
86614624Q00001-0003 HIR-AHS - 07-30-24.pdf	PDF	Jul 30, 2024
Atch J.8 - Questions-Answers - 07-30-2024.xlsx	XLSX spreadsheet	Jul 30, 2024
Atch J.8 - Questions-Answers - 07-22-2024.xlsx	XLSX spreadsheet	Jul 22, 2024
Atch J.2- Labor Mix and Level of Effort Spreadsheet -Multi-Year 07-22-24.xlsx	XLSX spreadsheet	Jul 22, 2024
Atch J.7 - Price Proposal Spreadsheet for Multiple Year - 7-22-24.xlsx	XLSX spreadsheet	Jul 22, 2024
86614624Q00001-0002 HIR-AHS - 07-22-24.pdf	PDF	Jul 22, 2024
Atch J.6 - Section B Prices and Contractor Personnel - 06-26-2024.xlsx	XLSX spreadsheet	Jun 26, 2024
Atch J.3 - Past Performance Information Spreadsheet - 06-26-24.xlsx	XLSX spreadsheet	Jun 26, 2024
Atch J.1 - Nondisclosure-Agreement-between-HUD-and-Contractor-Employee - 06-26-24.docx	DOCX document	Jun 26, 2024
Atch J.5 - Past Performance Survey - 06-26-24.docx	DOCX document	Jun 26, 2024
Atch J.7 - Price Proposal Spreadsheet for Multiple Year - 06-26-24.xlsx	XLSX spreadsheet	Jun 26, 2024
Atch J.4 - Past Performance Narrative - 06-26-24.docx	DOCX document	Jun 26, 2024
Atch J.2- Labor Mix and Level of Effort Spreadsheet -Multi-Year 06-26-24.xlsx	XLSX spreadsheet	Jun 26, 2024
86614624Q00001 HIR-AHS - 06-24-24.pdf	PDF	Jun 26, 2024

Show all 15

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.

1- Section B Prices

Name of Offeror	_______________________________________________
Attachment _J.6_ -Section B Prices and Labor Hour Rates Spreadsheet
Submit with Proposal Submission
Solicitation Number __ 86614624Q00001__

Base (Year 1) and Option 1 (Year 2)
CLIN	CLIN	Description	PWS	Qty	Unit	Unit Price	Total Price
	Type		Section
0001	FP-FUR	Project Management	C.5.1				$

0001AA FP Orientation Meeting C.5.1.1 1 EA $ $

0001AB	FP	Management Plan	C.5.1.2	1	EA	$	$
0001AC	FP-FUR	Monthly Progress Reports and Ongoing Communication	C.5.1.3	12	EA	$	$
		(Base)
0001AD	FP-FUR	Monthly Progress Reports and Ongoing Communication	C.5.1.3	12	EA	$	$
		(Option 1 -Year 2)
0002	FP	Generate an Updated Literature Review on Housing Insecurity	C.5.2				$

0002AA	FP	Analytic Brief on the 2023 “Measuring Housing Insecurity: Index Development Using American Housing Survey Data” Report	C.5.2.1	1	EA	$	$
0002AB	FP	Generate Literature Review on Housing Insecurity	C.5.2.2	1	EA	$	$
0003	FP	Convene an Expert Roundtable on Housing Insecurity	C.5.3				$
	CR
0003AA	FP	Identify the leading experts on Housing Insecurity Research and Measurement, with guidance from HUD	C.5.3.1	1	EA	$	$
0003AB	FP	Develop Program for Expert Roundtable	C.5.3.2	1	EA	$	$
0003AC	FP	Expert Roundtable on Housing Insecurity	C.5.3.3	1	EA	$	$
0003AD	FP	Generate Expert Roundtable Feedback Report	C.5.3.4	1	EA	$	$
0003AE	CR	Honorarium	C.5.3.5	10	EA	$	$
0004	FP	Develop Analysis Plans for Year 1 and Year 2 of the Contract	C.5.4				$
0004AA	FP	Generate Analysis Plan for Contract Year 1	C.5.4.1	1	EA	$	$

0004AB FP Generate Analysis Plan for Contract Year 2 C.5.4.2 1 EA $ $

0005	FP	Perform Initial Analysis of American Housing Survey Public-Use File (PUF) Data	C.5.5				$
0005AA	FP	Develop Statistical Analysis System (SAS) Code for the Analysis of AHS Public Use Data	C.5.5.1	1	EA	$	$
0005AB	FP	Using the Revised SAS Code (A017), Conduct Initial Analysis of Housing Insecurity using AHS Public-Use File	C.5.5.2	1	EA	$	$
0005AC	FP	Final Analysis Plan for Contract Years 2 (Option Year), Informed by Results of Initial Analysis	C.5.5.3	1	EA	$	$
0006	FP	Produce Interim Report	C.5.6				$
		(Option 1 – Year 2)
0006AA	FP	Generate one Interim Report Containing Writeup of Preliminary Analysis	C.5.6.1	1	EA	$	$
		(Option 1 - Year 2)
0006AB	FP	Prepare one Interim Report Briefing Document	C.5.6.2	1	EA	$	$
		(Option 1 - Year 2)
0006AC	FP	Deliver one Interim Report Briefing Meeting	C.5.6.3	1	EA	$	$
		(Option 1 - Year 2)
0007	FP	Generate Final Report	C.5.7				$
		(Option 1 – Year 2)
0007AA	FP	Drafts 1 and 2 of Final Report (Option 1 - Year 2)	C.5.7.1	1	EA	$	$
0007AB	FP	Prepare Final Report Briefing Document (Option 1 - Year 2)	C.5.7.2	1	EA	$	$
0007AC	FP	Deliver Final Report Briefing Meeting (Option 1 - Year 2)	C.5.7.3	1	EA	$	$
0007AD		Generate Publication-Ready Final Report (Option 1 - Year 2)	C.5.7.4	1	EA	$
		Base and Option 1 Total Value					$

Base (Year 1)
CLIN	CLIN	Description	PWS	Qty	Unit	Unit Price	Total Price
	Type		Section
0001	FP-FUR	Project Management	C.5.1				$

0001AA FP Orientation Meeting C.5.1.1 1 EA $ $

0001AB	FP	Management Plan	C.5.1.2	1	EA	$	$
0001AC	FP-FUR	Monthly Progress Reports and Ongoing Communication	C.5.1.3	12	EA	$	$
		(Base)
0002	FP	Generate an Updated Literature Review on Housing Insecurity	C.5.2				$
0002AA	FP	Analytic Brief on the 2023 “Measuring Housing Insecurity: Index Development Using American Housing Survey Data” Report	C.5.2.1	1	EA	$	$
0002AB	FP	Generate Literature Review on Housing Insecurity	C.5.2.2	1	EA	$	$
0003	FP	Convene an Expert Roundtable on Housing Insecurity	C.5.3				$
	CR
0003AA	FP	Identify the leading experts on Housing Insecurity Research and Measurement, with guidance from HUD	C.5.3.1	1	EA	$	$
0003AB	FP	Develop Program for Expert Roundtable	C.5.3.2	1	EA	$	$
0003AC	FP	Expert Roundtable on Housing Insecurity	C.5.3.3	1	EA	$	$
0003AD	FP	Generate Expert Roundtable Feedback Report	C.5.3.4	1	EA	$	$
0003AE	CR	Honorarium	C.5.3.5	10	EA	$	$
0004	FP	Develop Analysis Plans for Year 1 and Year 2 of the Contract	C.5.4				$
0004AA	FP	Generate Analysis Plan for Contract Year 1	C.5.4.1	1	EA	$	$

0004AB FP Generate Analysis Plan for Contract Year 2 C.5.4.2 1 EA $ $

0005	FP	Perform Initial Analysis of American Housing Survey Public-Use File (PUF) Data	C.5.5				$
0005AA	FP	Develop Statistical Analysis System (SAS) Code for the Analysis of AHS Public Use Data	C.5.5.1	1	EA	$	$
0005AB	FP	Using the Revised SAS Code (A017), Conduct Initial Analysis of Housing Insecurity using AHS Public-Use File	C.5.5.2	1	EA	$	$
		BASE YEAR TOTAL PRICE					$

Option 1 (Year 2)
CLIN	CLIN	Description	PWS	Qty	Unit	Unit Price	Total Price
	Type		Section
0001	FP-FUR	Project Management	C.5.1				$

0001AD	FP-FUR	Monthly Progress Reports and Ongoing Communication	C.5.1.3	12	EA	$	$
		(Option 1 -Year 2)
0005	FP	Perform Initial Analysis of American Housing Survey Public-Use File (PUF) Data	C.5.5				$
0005AC	FP	Final Analysis Plan for Contract Years 2 (Option Year), Informed by Results of Initial Analysis	C.5.5.3	1	EA	$	$
0006	FP	Produce Interim Report	C.5.6				$
		(Option 1 – Year 2)
0006AA	FP	Generate one Interim Report Containing Writeup of Preliminary Analysis	C.5.6.1	1	EA	$	$
		(Option 1 - Year 2)
0006AB	FP	Prepare one Interim Report Briefing Document	C.5.6.2	1	EA	$	$
		(Option 1 - Year 2)
0006AC	FP	Deliver one Interim Report Briefing Meeting	C.5.6.3	1	EA	$	$
		(Option 1 - Year 2)
0007	FP	Generate Final Report	C.5.7				$
		(Option 1 – Year 2)
0007AA	FP	Drafts 1 and 2 of Final Report (Option 1 - Year 2)	C.5.7.1	1	EA	$	$
0007AB	FP	Prepare Final Report Briefing Document (Option 1 - Year 2)	C.5.7.2	1	EA	$	$
0007AC	FP	Deliver Final Report Briefing Meeting (Option 1 - Year 2)	C.5.7.3	1	EA	$	$
0007AD		Generate Publication-Ready Final Report (Option 1 - Year 2)	C.5.7.4	1	EA	$
		OPTION YEAR 1 TOTAL PRICE					$

2-Contractor Personnel Chart

Name of Offeror __________________________________________

Attachment J.6 – Contractor Personnel Chart

Solicitation Number __86614624Q00001__

KEY PERSONNEL
Name	Key Personnel Role	Title	Employee or Subcontractor	Name of Prime or Subcontractor	Tasks to be assigned to Key person	% of Weekly Time Devoted to Contract
	Project Manager	Research Director
	Senior Technical Staff	Senior Analyst
	Technical Staff	Analyst
	Technical Staff	Research Assistant
	Senior Technical Staff	***Deputy Research Director
	**Alternate Project Manager	Senior Analyst

Other Contractor Personnel
Name	Personnel Role	Title	Employee or Subcontractor	Name of Prime or Subcontractor

***The Contractor is not required to have a Deputy Research Director.

File details come from the government source that posted it. Updated Jul 22, 2024.