Success Stories

Insights to Enable Food Distribution

Applying visualization and clear metrics to analyze and report data for better decision making

Man wearing mask delivering food in paper bag

Project Overview

Food is a basic need for an increasing number of families facing food insecurity due to Covid-19. Many school districts started feeding adults in addition to children to ensure children eat their full meal without having to split it among family members. When stay-at-home orders led to a quick shift to remote learning, students were not receiving the meals they would normally obtain at school. This was particularly impactful for students who qualify for free and reduced school meal programs.

This large school district acted rapidly to establish a “Grab and Go” approach using a subset of school campus locations to ensure children and their families were fed. Each Grab and Go site also incorporated local community non-profits and in-kind donations as part of the distribution process. Volunteers were retained and educated on complying with CDC guidelines to ensure the safety of district employees and the community. Each of the 60+ sites offered pre-packaged breakfast and lunch to every child aged 0-18 and every adult in need.

Client Challenge

The Food Services division was operating in a “crisis mode” and was forced to quickly stand up a distribution process including new Covid-19 safety procedures. Other challenges included:

  • Expansion of meal services to feed the broader community including non-district adults and children, which resulted in historically high meal volumes
  • Minimal visibility into demand added complexity to plan for an already challenging operation (e.g., storage capacity, traffic control, social distancing protocols, staffing, etc.)
  • Limited insight into data across 60+ sites due to a time-consuming, pen-and-paper tallying process
  • Difficulty collecting meaningful data and developing insights to help optimize costs, operations and staffing

Approach

  • Worked with the data division to receive daily or weekly updates of food demand and staffing counts, transcribed from pen-and-paper to raw Excel data
  • Met with key stakeholders to define what metrics would help drive decisions
  • Analyzed business scenarios and operating models to uncover potential future constraints and efficiency gains

Solution

  • Provided the district with enriched data that would allow them to adjust their operations and gain efficiencies with a level of confidence (location trends, counts, meal distribution volumes)
  • Created a data model and provided visualizations (heatmaps, graphs) to help with decision-making
  • Coached them on how to use the data to drive business decisions
  • Delivered weekly reports with insights to key stakeholders

Results

  • Used data to drive a decision around continuing the summer operational model, including which locations were most effective or could be slowed/stopped
  • Helped the client gain an understanding of key metrics such as optimal staffing levels and trends on meals served per school

Success Stories

A person types on a laptop. Above the laptop hovers icons of various checklists, representing data quality controls.

The Power of Frontline Data Quality Controls

Execution as a Service

Improving data quality was key to ensuring our financial services client retained data integrity and accuracy while also reducing time and money spent on after-hours issues. 

Read More About The Power of Frontline Data Quality Controls
Three wooden blocks spelling out MQL. The "M" block tips over to reveal an "S"

Automating for Efficiency: Turning Marketing Leads into Sales Contacts

Technology ServicesAnalytics & Insights

The transfer of marketing leads to sales teams is critical for customer acquisition, however our client’s process was time consuming and heavily manual. RevGen built a proof-of-concept solution that automated the entire handoff.

Read More About Automating for Efficiency: Turning Marketing Leads into Sales Contacts
A pie chart divided into three sections, with representative people tokens in those same colors to show a customer segmentation model.

Developing a Future-Proof Customer Segmentation Model

Artificial IntelligenceAnalytics & InsightsCustomer Experience

To improve sales efficiency, our client needed an “At-a-Glance” customer segmentation model that could evolve with their business.

Read More About Developing a Future-Proof Customer Segmentation Model

Subscribe to our Newsletter

Get the latest updates and Insights from RevGen delivered straight to your inbox.