Michigan Affordability Criteria Tool for State Revolving Fund Program (FLOW)
This tool uses socioeconomic indicators from the US Census’ American Community Survey (ACS), population projections from the Michigan Bureau of Labor Market Information and Strategic Initiatives, and relies on the user to input the system’s rates to imagine what using various affordability criteria could look like for Michigan’s SRF programs.
This tool incorporates a variety of socioeconomic indicators and population trends to score applicants, which can be compared to others to better prioritize funds.
The user can edit the blue cells, the grey cells are calculated using data already in the tool. The tool sorts each community in the state into different quartiles for each metric, while allowing the user to assign point values to the different quartiles. This allows the user to adjust the weighting of the different metrics to see the effect on the list of eligible applicants.