Attachment 4 - Sample Price Breakdown Worksheet with Rates.xlsx

XLSX spreadsheet 31 KB Posted Jun 20, 2024

Attached to: HECM Loan Comparison and Underwriting Tool (HLCUT) for Home Equity Conversion Mortgage (HECM)
Solicitation number: 86615624R00007
Issued by: Department of Housing and Urban Development

About this file

Written by GovTribe AI · Jun 20, 2024

This document appears to be a sample price breakdown worksheet with hourly rates for a federal contract opportunity. The pricing is broken down by line items for various tasks, including a Project Management Plan, Loan Comparison and Underwriting Tool, Support and Reporting, Updates, Transition Services, and Other Direct Costs for IT Components. The pricing is provided for the base contract as well as four option years. The contract opportunity is for the Department of Housing and Urban Development (HUD) to develop and maintain a HECM Loan Comparison and Underwriting Tool (HLCUT) for Home Equity Conversion Mortgage (HECM) roster counselors. The tool is required to provide calculations on all types of HECM loan products, including cost of origination, servicing, mortgage insurance premium, amortization schedules, total annual loan cost, and track responses to required client questions during counseling sessions.

View the file

Other files

File	Type	Posted
SF 1449 Solicitation.pdf	PDF	Jul 17, 2024
Solicitation 86615624R00007 Page After 1449 HECM HLCUT Updated.docx	DOCX document	Jul 17, 2024
Government Response to Industry Questions.xlsx	XLSX spreadsheet	Jul 17, 2024
SF30 Amendment 3.pdf	PDF	Jul 17, 2024
HLCUT Vendor Questions.xlsx	XLSX spreadsheet	Jul 15, 2024
SF30 86615624R00007 Amendment 0001.pdf	PDF	Jun 28, 2024
Solicitation 86615624R00007 Page After 1449 HECM HLCUT.pdf	PDF	Jun 20, 2024
Attachment 2 QASP.doc	DOC document	Jun 20, 2024
Attachment 1 HLCUT PWS.docx	DOCX document	Jun 20, 2024
Attachment 7 - Past_Performance Survey.docx	DOCX document	Jun 20, 2024
Attachment 6 - Past_Performance_Information_Chart.docx	DOCX document	Jun 20, 2024
Attachment 3 -Price Schedule.docx	DOCX document	Jun 20, 2024
Attachment 5 - Sample Labor Category_Hours Breakdown Worksheet without Rates.xlsx	XLSX spreadsheet	Jun 20, 2024

Show all 13

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.

Base Attachment 4 Sample Price Breakdown Worksheet w/Rates 86615624R00007

LIN 0001 -Project Management Plan (Task 5.1) - Base
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 950.00

LIN 0002 -Loan Comparison and Underwriting Tool (Task 5.2)- Base
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 962.50

LIN 0003 - Support and Reporting (Task 5.3.1 and 5.3.3) - Base
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 975.00

LIN 0004 - Updates (Task 5.3.2) Base
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.75	25	$ 493.75
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.75	25	$ 493.75
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 987.50

LIN 0005 - Transition Services (Task 5.4) - Base
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 20.00	25	$ 500.00
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 20.00	25	$ 500.00
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 1,000.00

LIN 0006 - NTE Other Direct Costs for IT Componets - Base
Labor Category:	Prime or Sub	A	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 20.25	25	$ 506.25
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 20.25	25	$ 506.25
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 1,012.50

Base Total	ERROR:#REF!
*This list will be used to understand the contractor's methodology.
**Round to 2 decimal places (example: $201,750.50).

Sample Price Breakdown Worksheet &"-,Bold"With Rates Attachment 001

Option 1 Attachment 0004 Solicitation 86615624Q00008

LIN 0007 - Loan Comparison and Underwriting Tool (Task 5. 2) Option 1
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 950.00

LIN 0008 - Support and Reporting (Task 5.3.1 and 5.3.3) - Option 1
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 962.50

LIN 0009 - Updates (Task 5.3.2) - Option 1
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 975.00

LIN 0010 - NTE Other Direct Costs for IT Componets - Option 1

$30,000.00

Option 1 Total	ERROR:#REF!
*This list will be used to understand the contractor's methodology.
**Round to 2 decimal places (example: $201,750.50).

Sample Price Breakdown Worksheet &"-,Bold"With Rates Attachment 001

Option 2 Attachment 0004 Solicitation 86615624Q00008

LIN 0011 - Loan Comparison and Underwriting Tool (Task 5.2) Option 2
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 950.00

LIN 0012 - Support and Reporting (Task 5.3.1 and 5.3.3) - Option 2
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 962.50

LIN 0013 - Updates (PWS 5.3.2) - Option 2
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 975.00

LIN 0014 -NTE Other Direct Costs for IT Componets - Option 2

$20,000.00

Option 2 Total	ERROR:#REF!
*This list will be used to understand the contractor's methodology.
**Round to 2 decimal places (example: $201,750.50).

Sample Price Breakdown Worksheet &"-,Bold"With Rates Attachment 001

Option 3 Attachment 0004 Solicitation 86615624Q00008

LIN 0015 - Loan Comparison and Underwriting Tool (Task 5.2) Option 3
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 950.00

LIN 0016 - Support and Reporting (Task 5.3.1 and 5.3.3) - Option 3
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 962.50

LIN 0017 - Updates (Task 5.3.2) - Option 3
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 975.00

LIN 0018 - Other Direct Costs for IT Componets - Option 3

Labor Category:

$20,000.00

Option 3 Total	ERROR:#REF!
*This list will be used to understand the contractor's methodology.
**Round to 2 decimal places (example: $201,750.50).

Sample Price Breakdown Worksheet &"-,Bold"With Rates Attachment 001

Option 4 Attachment 0004 Solicitation 86615624Q00008

LIN 0019 - Loan Comparison and Underwriting Tool (Task 5.2) Option 4
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.00	25	$ 475.00
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 950.00

LIN 0020 - Support and Reporting (Task 5.3.1 and 5.3.3) Option 4
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.25	25	$ 481.25
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 962.50

LIN 0021 - Updates (Task 5.3.2) - Option 4
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.50	25	$ 487.50
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 975.00

LIN 0022 - Transition Services (Task 5.4) - Option 4
Labor Category:	Prime or Sub	Hourly Rate	Volume/Hours	Total Per Year
Example - Program Manager	Prime	$ 19.75	25	$ 493.75
				$ - 0
				$ - 0
				$ - 0
Example - Conference Manager	Subcontractor	$ 19.75	25	$ 493.75
				$ - 0
				$ - 0
				$ - 0
Total Labor				$ 987.50

LIN 0023 - Other Direct Costs for IT Componets Option 4

$20,000.00

Option 4 Total	ERROR:#NAME?
*This list will be used to understand the contractor's methodology.
**Round to 2 decimal places (example: $201,750.50).

Sample Price Breakdown Worksheet &"-,Bold"With Rates Attachment 001

File details come from the government source that posted it. Updated Jun 20, 2024.