Exhibit_M_-_DES_ESG_Program_Performance_Report.xlsx
XLSX spreadsheet 39 KB Posted
- Attached to
- Master Agreement AZ|CTR066293
- Contract number
- CTR066293
- Issued by
- Arizona
About this file
This document is an Exhibit M Program Performance Report template for the Arizona Department of Economic Security (DES) Emergency Solutions Grant (ESG) Program. The report is designed for quarterly and annual tracking across multiple Continuum of Care (CoC) regions, including Maricopa, Tucson, and Balance of State (BOS). It provides a standardized reporting mechanism for homeless service providers to document program performance metrics related to various homeless assistance activities.
The document outlines performance reporting requirements for four primary ESG-funded activities: Emergency Shelter, Street Outreach, Rapid Re-housing, and Homeless Prevention. The performance metrics include key indicators such as persons served, service rates, bed utilization, income exit rates, destination outcomes, data quality, length of participation, and grant expenditure percentages. The report template requires providers to calculate and report these metrics quarterly and annually, with a focus on tracking progress, identifying barriers, and assessing solutions for each homeless service program. The goal appears to be comprehensive performance monitoring and continuous improvement of homeless assistance services across Arizona's different CoC regions.
View the file
Other files
Show all 17
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
| Instructions |
| Please follow these instructions when filling out your Program Performance Report quarterly and annually. The purpose of this report is not to reprimand providers, but to assist the DES State Homeless Coordination Office in tracking progress, identifing barriers, and assessing solutions for each program so they may succeed to their highest potential. CAPER= Consolidated Annual Performance & Evaluation Report |
For each quarter of the grant period, run a CAPER in your HMIS (or comparable database for DV providers only) and complete the appropriate tab with the requested data from your CAPER.
Column A, B & C: For each activity (Shelter, RRH, etc.) you will list each project funded by the grant and your agency name. If you are funded for more than one CoC region, list each one separately for the activity funded.
Column D: Enter the appropriate COC for each project. If you are funded for more than one CoC region, list each one separately for the activity funded.
Column E: Enter number from CAPER Question 7a ' persons served'.
Column F: Review the original number of persons that was estimated in your RFP submission in the Questionaire response for that activity and divide the number by 4 to get a quarterly goal to enter it here.
Column G: Estimated Service Rate is calculated automatically.
Column H -HIC Beds: Report the number beds reported to your CoC on the most recent Housing Inventory Chart submission (January each year) for each project served in a separate CoC. (Emergency Shelter and Rapid Rehousing only)
Column I: Bed Utilization is calculated automatically. (Emergency Shelter and Rapid Rehousing only)
Column J: Calculate the % of persons who exited with income from CAPER Question 16 Leavers with income divided by total number of leavers. (Rapid Rehousing only)
Column K: Calculate the % of persons whose exit destination is unknown by dividing the number by total number of leavers Q23c.
Column L: Enter the percentage of persons who exited to positive destinations from CAPER Question 23c.
Column M: Enter the Total 'average length of time to housing between Project Start Date and Housing Move-in Date from CAPER Question 22c. (Rapid Rehousing only)
Column N: Run a Data Completeness Report in HMIS (or comparable database for DV providers only) and enter the overall %.
Column O: Calculate the % of persons served in the Length of Participation 91-180 days CAPER Question 22a2 divided by the total number served in this row by the total persons served.
Column P: Calculate the % of expenditures completed this quarter by adding together each month invoice amounts and dividing by the total award amount.
Q1
| Exhibit M |
| Arizona Department of Economic Security |
| DES ESG Program Performance Report |
| ESG Funded Activity | Provider Agency | Project Name | CoC Region | Persons Served (Q7a) | 25% of Estimated Number of Persons Served from RFP Application | Estimated Service Rate | HIC Beds Reported | Bed Utilization | Percentage Leavers who Exited with Income (Q16) | Percentage of Persons Exiting to Known Destinations (Q23c) | Percentage of Persons Exiting to Positive Housing Destinations (Q23c) | Length of Time Between Project Start and Move -in Date | Data Quality | Length of Participation (LOP) @ 91 to 180 days | % of Grant Award Expended |
| Emergency Shelter | MAR, TPCH, BOS | Self Calculating | Self Calculating | N/A | 60% | 60% | N/A | 95% | 25% | ||||||
| Example | DES | DES2 | Maricopa | 19 | 25 | 76.00% | 40 | 47.50% |
| Street Outreach | MAR, TPCH, BOS | Self Calculating | N/A | N/A | N/A | 60% | 60% | N/A | 95% | 25% |
| N/A | N/A | |||||||||
| N/A | N/A | |||||||||
| Rapid Re-housing | MAR, TPCH, BOS | Self Calculating | Self Calculating | 80% | 90% | 90% | 95% | 25% |
| Homeless Prevention | MAR, TPCH, BOS | Self Calculating | N/A | N/A | N/A | 90% | 90% | N/A | 95% | 25% |
| N/A | N/A | |||||||||
| N/A | N/A | |||||||||
| F & E = G | Persons served * HIC beds |
Q2
| ESG Funded Activity | Provider Agency | Project Name | CoC Region | Persons Served (Q7a) | 25% of Estimated Number of Persons Served from RFP Application | Predicted Service Rate | HIC Beds Reported | Bed Utilization | Percentage Leavers who Exited with Income (Q16) | Percentage of Persons Exiting to Known Destinations (Q23c) | Percentage of Persons Exiting to Positive Housing Destinations (Q23c) | Length of Time Between Project Start and Move -in Date | Data Quality | Length of Participation (LOP) @ 91 to 180 days | % of Grant Award Expended |
| Emergency Shelter | Performance Goal | MAR, TPCH, BOS | Self Calculating | Self Calculating | N/A | 60% | 60% | N/A | 95% | 25% |
Street Outreach Performance Goal MAR, TPCH, BOS Self Calculating N/A N/A N/A 60% 60% N/A 95% 25%
Rapid Re-housing Performance Goal MAR, TPCH, BOS Self Calculating Self Calculating 80% 90% 90% 95% 25%
Homeless Prevention Performance Goal MAR, TPCH, BOS Self Calculating N/A N/A N/A 90% 90% N/A 95% 25%
Q3
| ESG Funded Activity | Provider Agency | Project Name | CoC Region | Persons Served (Q7a) | 25% of Estimated Number of Persons Served from RFP Application | Predicted Service Rate | HIC Beds Reported | Bed Utilization | Percentage Leavers who Exited with Income (Q16) | Percentage of Persons Exiting to Known Destinations (Q23c) | Percentage of Persons Exiting to Positive Housing Destinations (Q23c) | Length of Time Between Project Start and Move -in Date | Data Quality | Length of Participation (LOP) @ 91 to 180 days | % of Grant Award Expended |
| Emergency Shelter | Performance Goal | MAR, TPCH, BOS | Self Calculating | Self Calculating | N/A | 60% | 60% | N/A | 95% | 25% |
Street Outreach Performance Goal MAR, TPCH, BOS Self Calculating N/A N/A N/A 60% 60% N/A 95% 25%
Rapid Re-housing Performance Goal MAR, TPCH, BOS Self Calculating Self Calculating 80% 90% 90% 95% 25%
Homeless Prevention Performance Goal MAR, TPCH, BOS Self Calculating N/A N/A N/A 90% 90% N/A 95% 25%
Q4
| ESG Funded Activity | Provider Agency | Project Name | CoC Region | Persons Served (Q7a) | 25% of Estimated Number of Persons Served from RFP Application | Predicted Service Rate | HIC Beds Reported | Bed Utilization | Percentage Leavers who Exited with Income (Q16) | Percentage of Persons Exiting to Known Destinations (Q23c) | Percentage of Persons Exiting to Positive Housing Destinations (Q23c) | Length of Time Between Project Start and Move -in Date | Data Quality | Length of Participation (LOP) @ 91 to 180 days | % of Grant Award Expended |
| Emergency Shelter | Performance Goal | MAR, TPCH, BOS | Self Calculating | Self Calculating | N/A | 60% | 60% | N/A | 95% | 25% |
Street Outreach Performance Goal MAR, TPCH, BOS Self Calculating N/A N/A N/A 60% 60% N/A 95% 25%
Rapid Re-housing Performance Goal MAR, TPCH, BOS Self Calculating Self Calculating 80% 90% 90% 95% 25%
Homeless Prevention Performance Goal MAR, TPCH, BOS Self Calculating N/A N/A N/A 90% 90% N/A 95% 25%
Annual Report
| ESG Funded Activity | Provider Agency | Project Name | CoC Region | Persons Served (Q7a) | Number of Persons Served from RFP Application | Predicted Service Rate | HIC Beds Reported | Bed Utilization | Percentage Leavers who Exited with Income (Q16) | Percentage of Persons Exiting to Known Destinations (Q23c) | Percentage of Persons Exiting to Positive Housing Destinations (Q23c) | Length of Time Between Project Start and Move -in Date | Data Quality | Length of Participation (LOP) @ 91 to 180 days | % of Grant Award Expended |
| Emergency Shelter | Performance Goal | MAR, TPCH, BOS | Self Calculating | Self Calculating | N/A | 60% | 60% | N/A | 95% | 25% |
Street Outreach Performance Goal MAR, TPCH, BOS Self Calculating N/A N/A N/A 60% 60% N/A 95% 25%
Rapid Re-housing Performance Goal MAR, TPCH, BOS Self Calculating Self Calculating 80% 90% 90% 95% 25%
Homeless Prevention Performance Goal MAR, TPCH, BOS Self Calculating N/A N/A N/A 90% 90% N/A 95% 25%
File details come from the government source that posted it. Updated .