The Statistics: Hot Meals Served & Bed Nights Provided

Data for reporting period ending: May 31, 2018       6/17/2018 Prepared by Jim Willhight,

 The analytic Annual Meals Served is shown as a vertical blue bar with it's scale to the left ranging from 70,000 to 90,000 meals per year.   The Bed Night totals are illustrated by the dotted red line.  The scale is on the right side of the graph ranging from 28,000 to 38,000 bed nights per year.

The analytic Annual Meals Served is shown as a vertical blue bar with it's scale to the left ranging from 70,000 to 90,000 meals per year. 

The Bed Night totals are illustrated by the dotted red line.  The scale is on the right side of the graph ranging from 28,000 to 38,000 bed nights per year.

Trend: Flat

The upward trend of Increasing need for food and emergency housing services has leveled out after an upward trend for almost a year.

Since the peak of 88,051 meals served in January  (twelve month rolling total for period February 1, 2017 - January 31, 2018) the hot food need has decreased slightly  with the latest rolling count 86,908 for the twelve month period June 1 2017 thgough May 31, 2018.    That is a decrease of 1,143 meals over the 12 month period, a little less than 100 fewer meals serverd per month average. 

It's worth noting that the May 2018 count was up 382 meals versus May 2017.  After the peak in Janaury, meal counts for February, March and April of this year versus the same three months last year were down an average of over 500 per month. 

Census_Rolling12m201805.jpg

As illistratewd in the chart the to the right the trend of the numnber of meals served  over a rolling 12 month period has flattened after peaking at over 88,000 meals annually.

For the period February through April  the meal service count dropped by 6.9%, a decrease of 1,525 hot meals, a little over 500 per month less than the same period one year ago.  

Note the upward tick in May with the report of 7,172 meals served, an increa of 382 versus May 2017. 

 

Meal Service Analytics

census_Table_2018_5.png

Table 1: Albany Helping Hands Meals Served

Data Content Key:    

  • Column 1 - Month Reported
  • Column 2- Monthly Meals. Total Meals served for reporting month
  • Column 3- 12 Month Rolling Total.  Total number of meals served over previous 12 month period ending on last day of reporting month.  For example, 83,228 meals for period August 1 2016 to July 31, 2017.
  • Column 4- 12 Month Rolling monthly average.  The monthly average for the 12 month rolling period (above). The 83,228 meals annually, divided by 12 is an average meals served per month, 6,936
  • Column 5-  6 Month Rolling Total.  Total number of meals served over previous 6 month period ending on last day of reporting month.  For example, 43,2918 meals for period February 1,  2017 to July 31, 2017.
  • Column 6 - 6 Month Rolling monthly average.  The monthly average for the 6 month rolling period (above) is 7,215. 
  • Column 7-  3 Month Rolling Total.  Total number of meals served over previous 3 month period ending on last day of reporting month.  For example, 21,170 meals for period May 1,  2017 to July 31, 2017.
  • Column 8-  3 Month Rolling monthly average.  The monthly average for the 3 month rolling period.

Color Coding Key:

Each column of data is coded by color according to the monthly count total. Lowest to highest are: green, light green, yellow, orange, red, and dark red.  For example, in the monthly Meals column we see data from October 2015 to January 2016 we see orange and red key, noting the high meal counts for those months.  Likewise from April 2016 to September 2016 we see greens and light green, indicating the dip in the number of meals served.


12 Month (Rolling Total) Meals Served

Graph 2 (Left)

This chart shows the Total number of meals served for previous 12 month period (365 days) ending on date noted, a day 365 rolling total.

For example:  February 2018 data reports 87,674 meals served during the period March 1, 2017 to February 28, 2018. 

For the data for each month's annual total,  point cursor at the data point then a pop up window will appear. 

 

 

Hot Meals Served Monthly

 

 

Graph 3 (right)

Anaylitics of meals served monthly.

For the data for each month's total,  point at the data point than a pop up window will display data. 

 

3 month Rolling Average of Meals Served Monthly

Graph 4 (right)

The 3 month rolling average chart (right) shows the Monthly Meals Served over the last three months. 

For example, the data for February 2018 shows an average of 7492. This is the number of meals served Average for the period December 1, 2017 to February 28, 2018. 

 
Meals_RollingMonth2018_05png.png

Graph 5 (left)

The chart to the left tracks the month to month hot meal service count (blue line) with monthly totals.  The orange line is the 12 month rolling count of the monthly average.

The annual rolling average dropped from 6,906 (period ending June 30, 2016)  to 6,560 monthly average for the 365 day period ending Jan. 31, 2017.

Since February 2017 there has been an increase in the need for hot meals. 

 

 

Meals_RollingMonth2018_05.png

 

 

Graph 6 (right)

Meals Monthly, 3. 6 and 12 Month Rolling Averages

  • Monthly data is noted as dot with data reported for each month.
  • 3 Month Rolling Monthly Average noted as red dotted line.
  • 6 Month Rolling Monthly Average noted as green dotted line.
  • 12 Month Rolling Monthly Average noted as dark black line.
 
 Note:   4th Quarter 2017 Data October-November only.

 

 

 

 

 

Graph 7 (left)

Comparison of Meals Served Quarterly 2016  versus 2017. 

 

 

 

Albany Helping Hands Meals vs. Housing Census

ComboGreen_2018_05.jpg

 

 

 

 

Graph 8 (right)

Chart shows the change to an upward trend for both the Housing Census and the Meal Service Count.  

Meal Service Count (green bar graph with scale to left) compared to Bed-Nights (red dotted line with scale to the right) for rolling 12 month period.

 

 

 

 

 

Albany Helping Hands Housing Census

Average Number Housed Daily

 

Graph 9 (Right)

Analytics of Average Number Housed (Daily).

For the data for each month's total,  point at the data point than a pop up window will display data. 

 

Annual Bed Nights (12 Month Rolling Total)

 

 

Graph 10 (Right)

Analytics of Average Number Housed (Daily).

For the data for each month's total,  point at the data point than a pop up window will display data. 

 
CommboOrange.png