RFP_4710_PAT3020REBID_PAC2_v1.xlsm

XLSM spreadsheet 48 KB Posted

Attached to
Permanent Supportive Housing (PSH) Support Services
Solicitation number
RFP 4710 PAT3020REBID
Issued by
Texas

About this file

This is a budget template document for the City of Austin's Permanent Supportive Housing (PSH) Support Services contract, designed to serve individuals experiencing homelessness in Austin/Travis County through intensive case management services. The template provides a standardized format for applicants to submit detailed budget proposals for a 12-month contract period. Applicants must complete multiple worksheets including a Budget Summary, Budget Narrative, All Other Sources funding documentation, and Subgrantee Budget forms if applicable. The template accommodates up to five subgrantees, with provisions for additional subgrantees upon request to the RFP Point of Contact. All budget amounts must be entered as whole dollars in orange-highlighted cells, with detailed explanations required for each line item to enable evaluator review.

The budget structure organizes costs into five primary categories: Personnel (including salaries and fringe/payroll taxes for both program and administrative staff), Operations (including operational costs, outsourced professional services, supplemental programmatic services, and training/travel), Financial Assistance to Clients (rental assistance, general housing assistance, and direct client assistance), Other funding sources, and Subgrantee allocations. An Administration component is calculated at 15 percent of the total budget. Applicants must identify all funding sources, including RFP-requested funds and leveraged/match funds from other sources, with documentation of grant names, durations, and funding sources for non-RFP funding. The template automatically calculates cost per household served and generates a roll-up summary for reporting in PartnerGrants, with administrative costs tracked separately but reported together with their respective budget line items.

View the file

Other files

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

General Instructions
· Please enter information into cells that are highlighted orange.Example
· If no funds are budgeted for a line item, leave the explanation blank or write "N/A."
· All line item amounts must be entered as WHOLE DOLLARS.
· Budget amounts should be listed for the full award amount.
Budget Summary Tab Instructions
· This tab is intended to function as a cumulative summary of the project's budget
· Complete rows 2-4 to indicate agency name, project name, and the proposed number of persons to be served
Budget Narrative Tab Instructions
· This tab is intended to function as a a detailed record of which funds are being requested, how much, and why
· Column D: Please complete Column D for the 12-month contract period.
· Column G: For every budget line containing a RFP requested amount of funding, enter a short description and/or list of items included in that budget line.
All Other Sources Budget Tab Instructions (only for applicants that have leveraged/match funds for this program):
· This tab is intended to function as a a detailed record of which funds are being dedicated to the projects
· Column D: List expected amounts from funding sources other than RFP request for the 12-month contract period.
· Column E: For every budget line containing funds from other sources, enter a short description and/or list of items included in that budget line.
· Column F: For every budget line containing funds from other sources, enter a short description of the grant and duration
· Column G: For every budget line containing funds from other sources, list the funding source
Subgrantee Budget Tab Instructions (only for applicants that will have subgrantees):
· This tab is intended to function as a a detailed record of subgrantees for the project, if any.
· For each Subgrantee, list the requested funds and explanation for each line item.
· Up to 3 subgrantees may be included in the form. Please reach out to the RFP Point of Contact for the form to be amended if additional subgrantees are needed.
Cost per HH Tab: No Data Entry is needed on this tab
· This tab will auto-populate with data from the Budget and Narrative tab calculating the cost per each household served in the program.
PG Budget Roll-up Tab: No Data Entry is needed on this tab
· This tab will auto-populate with data from the Budget Narrative tab calculating the budget used in PartnerGrants
· For the purposes of the budget in Partner Grants, Admin costs are included in their respective budget line items. E.g. Administrative costs for Personnel must be tracked and calculated seperately from Personnel costs, but will be reported and budgeted together in PartnerGrants.

Budget Summary

Form - Program Budget and Narrative - Budget Summary
Agency Name:
Program Name:
Total Proposed Households Served:
Assumed Contract Term:12 months
Instructions: Nothing else needs to be submitted in this tab.
Budget Line-ItemRequested FundingAmounts Funded by ALL OTHER Sources for the SAME program for Contract TermTotal Budget (All Funding Sources)% Percentage of Budget
Personnel$0$0$0ERROR:#DIV/0!
Operations$0$0$0ERROR:#DIV/0!
Financial Assistance to Clients$0$0$0ERROR:#DIV/0!
OtherERROR:#DIV/0!
Subgrantee$0$0ERROR:#DIV/0!
Administration @ 15%$0$0$0ERROR:#DIV/0!
Total:$0$0$0

Budget Narrative

Form - Program Budget and Narrative - Budget Narrative
Agency Name:0
Program Name:0
Total Proposed HHs Served:0
EXAMPLERequested RFP FundingAmounts Funded by ALL OTHER Sources for the SAME program Contract TermTotal Budget (All Funding Sources)Complete an explanation for each RFP-funded line item.
Personnel
Personnel$239,616.00$101,920.00$341,536.002 budget fund operator @ $28.80 per hour, $59,904 annually, $119,808 total annually, $239,616 per budget
INSTRUCTIONSFill in the orange-shaded fields in the budget and narrative form below. Offerors must identify all funding requested in the budget below. The completed Detailed Budget will be reviewed by evaluators. Funds requested should correspond to the activities and services proposed in the application narrative and eligible as determined in the Scope of Work. If awarded, funds may be transferred between line items. Offerors should ensure sufficient explanation for each cost for evaluators to easily understand the methodology.
Budget Line-ItemRequested RFP 12-Month FundingAmounts Funded by ALL OTHER Sources for the SAME program for Contract TermTotal Budget (All Funding Sources)Complete an explanation for each RFP-funded line item.
Personnel
Program PersonnelPersonnel Salaries$0$0
Fringe and Payroll Taxes$0$0
Administration PersonnelPersonnel Salaries$0$0
Fringe and Payroll Taxes$0$0
Personnel Sub-Total$0$0$0
Operations
Program OperationsOperations Costs$0$0
Outsourced Professional Services$0
Supplemental Programmatic Services$0
Training/Travel Outside Austin and/or Travis County$0
Operations AdministrationGeneral Administration Costs$0$0
Outsourced Professional Services$0
Operational Sub-Total$0$0$0
Financial Assistance to Clients
Financial Assistance to ClientsRental Assistance$0$0
General Housing Assistance$0$0
Direct Client Assistance$0$0
Other
Financial Assistance Sub-Total$0$0$0
Other
Other
Sub-Grantees
Sub-Grantees - Use Subgrantee Budget worksheet to enter amounts (If applicable)Sub-Grantee Personnel$0$0
Sub-Grantee Personnel - Admin$0$0
Sub-Grantee Operations$0$0
Sub-Grantee Operations - Admin$0$0
Sub-Grantee Financial Assistance to Clients$0$0
Sub-Grantee Other
Sub-Grantees Sub-Total$0$0
Requested RFP FundingAmounts Funded by ALL OTHER Sources for the SAME programTotal Budget (All Funding Sources)
Total:$0$0$0

All Other Sources

Form - Program Budget and Narrative - All Other Sources
Agency Name:0
Program Name:0
Total Proposed HHs Served:0

Instruction: Fill in the orange-shaded fields in the budget and narrative form below. Offerors must identify all funding dedicated to the project from other sources in the budget below. These resources are accessible to all clients. Other City of Austin funds are only eligilbe for inclusion as Other Sources of Funding if all clients in the program will receive the identified funded activity and the requested project budget (Budget Narrative Tab) does not include request for the activity, thereby avoiding duplication of services.

Example: Budget Line-ItemScope of Work Eligible Cost ReferenceAmounts Funded by ALL OTHER Sources for the SAME program 24 monthsComplete an explanation for each ALL OTHER Sources line item.ALL OTHER Sources Funding Grant & DurationALL OTHER Sources Funding Source
Personnel
Example: Operations Personnel Salary, Fringe and Payroll TaxesSection V$217,752.003 Shelter Janitorial Staff @ $24.50 per hour, $50,568 annually, $151,704 total; 1 Maintenance Lead @ $32.00 per hour, $66,048 annuallyHomeless Housing and Services Program @ $151,704, 10/1/2024 - 9/30/2025; Agency Development @ $66,048TDHCA; Agency Development
Budget Line-ItemAmounts Funded by ALL OTHER Sources for the SAME program 12 monthsComplete an explanation for each ALL OTHER Sources line item.ALL OTHER Sources Funding Grant & DurationALL OTHER Sources Funding Source
Program PersonnelProgram Personnel Costs
Fringe and Payroll Taxes
Administration PersonnelAdministration Personnel Salaries
Fringe and Payroll Taxes
All Other Funding Personnel Sub-Total$0.00
Operations
Program OperationsProgram Operations Cost
Operations AdministrationAdmin Operation Expenses
Operational Sub-Total$0.00
Financial Assistance to Clients
Financial Assistance to ClientsRental Assistance
General Housing Assistance
Direct Client Assistance
Other
Financial Assistance to Clients Sub-Total$0.00

Subgrantee Budget

Form - Program Budget and Narrative - Subgrantee Budgets
Agency Name:0
Program Name:0
Total Proposed HHs Served:0
Subgrantee Summary
Budget Line-ItemRequested COA Funding 24 months
Personnel$0.00
Operations$0.00
Financial Assistance to Clients$0.00
Admin @ 15%$0.00
Total$0.00

Instruction: Applicant must identify all requested funds to be awarded to subgrantees including amounts requested and methodology for the requeted amount. Up to 3 subgrantees may be included in the form. Please reach out to the RFP Point of Contact for the form to be amended if additional subgrantees are needed.

Subgrantee ASubgrantee Name:Unduplicated HHs Served:
Start Date:End Date:
Budget Line-ItemRequested Funding 12 monthsComplete an explanation for each line item.
Personnel
Program Personnel
Program Fringe and Payroll Taxes
Personnel Salaries
Fringe and Payroll Taxes
Personnel Sub-Total$0.00
Operations
Program Operations Costs
Admin Operation Expenses
Operational Sub-Total$0.00
Financial Assistance to Clients
Rental Assistance
General Housing Assistance
Direct Client Assistance
Other
Total:$0.00
Subgrantee BSubgrantee Name:Unduplicated HHs Served:
Start Date:End Date:
Budget Line-ItemRequested Funding 12 monthsComplete an explanation for each line item.
Personnel
Program Personnel
Program Fringe and Payroll Taxes
Personnel Salaries
Fringe and Payroll Taxes
Personnel Sub-Total$0.00
Operations
Program Operations Costs
Admin Operation Expenses
Operational Sub-Total$0.00
Financial Assistance to Clients
Rental Assistance
General Housing Assistance
Direct Client Assistance
Other
Total:$0.00
Subgrantee CSubgrantee Name:Unduplicated HHs Served:
Start Date:End Date:
Budget Line-ItemRequested Funding 12 monthsComplete an explanation for each line item.
Personnel
Program Personnel
Program Fringe and Payroll Taxes
Personnel Salaries
Fringe and Payroll Taxes
Personnel Sub-Total$0.00
Operations
Program Operations Costs
Admin Operation Expenses
Operational Sub-Total$0.00
Financial Assistance to Clients
Rental Assistance
General Housing Assistance
Direct Client Assistance
Other
Total:$0.00
Subgrantee DSubgrantee Name:Unduplicated HHs Served:
Start Date:End Date:
Budget Line-ItemRequested Funding 12 monthsComplete an explanation for each line item.
Personnel
Program Personnel
Program Fringe and Payroll Taxes
Personnel Salaries
Fringe and Payroll Taxes
Personnel Sub-Total$0.00
Operations
Program Operations Costs
Admin Operation Expenses
Operational Sub-Total$0.00
Financial Assistance to Clients
Rental Assistance
General Housing Assistance
Direct Client Assistance
Other
Total:$0.00
Subgrantee ESubgrantee Name:Unduplicated HHs Served:
Start Date:End Date:
Budget Line-ItemRequested Funding 12 monthsComplete an explanation for each line item.
Personnel
Program Personnel
Program Fringe and Payroll Taxes
Personnel Salaries
Fringe and Payroll Taxes
Personnel Sub-Total$0.00
Operations
Program Operations Costs
Admin Operation Expenses
Operational Sub-Total$0.00
Financial Assistance to Clients
Rental Assistance
General Housing Assistance
Direct Client Assistance
Other
Total:$0.00
NOTE: If your collaboration includes more than 5 sub-grantees, please contact the RFP contact to get a form with extra spots.

Cost Per HH

Form - Program Budget and Narrative - Cost Per Household
Agency Name:0
Program Name:0
Total Proposed Households Served:0
Overall Budget:$0.00
Cost per Household ServedERROR:#DIV/0!

PG Budget Roll-up

Form - Partnergrants Program Budget and Narrative Roll-Up
Agency Name:0
Program Name:0
Budget Line-ItemRequested Funding 24-MonthsAmounts Funded by ALL OTHER Sources 24-MonthsTotal Budget (All Funding Sources) 24-Months
Salaries
Personnel$0.00$0.00$0.00
Fringe and Payroll Taxes$0.00$0.00$0.00
Operations
General Operations$0.00$0.00$0.00
Outsourced Professional Services$0.00$0.00
Supplemental Programmatic Services$0.00$0.00
Training/Travel Outside of Austin/Travis County$0.00$0.00
Assistance to Clients
Rental Assistance$0.00$0.00$0.00
General Housing Assistance$0.00$0.00$0.00
Direct Client Assistance$0.00$0.00$0.00
Other$0.00
Sub-Grantees (If Applicable)
Sub-Grantee Personnel$0.00$0.00
Sub-Grantee Operations$0.00$0.00
Sub-Grantee Direct Assistance$0.00$0.00
Sub-Grantee Other$0.00
Program Income
Program Income
Other
Other (Project Admin)$0.00$0.00$0.00
Total:$0.00$0.00$0.00

File details come from the government source that posted it. Updated .