1、Making a difference with data:What it can mean for food banksUsing data to forecast food insecurity helped one food bank prepare for the worst.October 2020by David Fiocco,Audrey Lucas,Megan Knoch-Dohlin,and Byron RubyThe COVID-19 crisis couldnt have come at a worse time for Second Harvest Heartland,2、Minnesotas largest food bank.When the virus first began to spread in the state,Second Harvest Heartland was weeks away from moving into a new warehouse in suburban Minneapolis.In anticipation of the move,the food bank had purposely drawn down its inventory,so there wouldnt be as much to haul from on3、e place to another.Demand exploded virtually overnight.As the virus spread,businesses closed,and workers were furloughed or laid off.The number of people in danger of not having enough to eat spiked.At the same time,food donations from local wholesalers dried up,as those businesses experienced the s4、ame virus-induced supply-chain disruptions that cleared grocery stores of essentials like toilet paper,disinfectants,and soup.When restaurants closed to comply with mandatory shutdowns,it cut into the supply of food that Second Harvest Heartland normally could expect to rescue.Recognizing the public5、 health risks to themselves and others,many volunteers reduced hours or stopped showing up to the nearly 350 food pantries,shelters,and soup kitchens that Second Harvest Heartland partners with.Moreover,as a precautionary measure,the food bank now had to pre-assemble food boxes before distributing t6、o partners,adding time and cost.As a stop-gap measure,Second Harvest Heartland dipped into donated funds to pay for the boxes and other food.But the food bank couldnt afford to do that for long without serious financial consequences.With the crisis showing no sign of stopping,the food banks operatio7、ns and inventory management leaders had to figure out how many more people might need help,and for how long,in order to calculate how much food was required and where to get it.For that,they turned to data.Food banks such as Second Harvest Heartland have traditionally been supply-focused,distributin8、g whatever food they are given.Forecasting tended to be limited to yearly reviews using historical,backward-facing data.The COVID-19 crisis changed that.By necessity,food banks needed to act more strategically to identify the specific requirements of the communities they serveand to use data analyti9、cs to take guesswork out of the equation.For Second Harvest Heartland,digging into the data revealed a potentially disastrous shortfall.In a worst-case scenario,the food bank would need 26 million more pounds of food than it normally distributes in a year,according to Julie Vanhove,Second Harvest He10、artlands supply and demand planning director.Fortunately,the need has not yet reached that point.But by developing a plan backed by data for this worst-case scenario,the team felt reassured.“We developed a way to communicate about what was coming our way that created a calmness and confidence that w11、e could do it,”said Thierry Ibri,the food banks chief operations and programs officer.We developed a way to communicate about what was coming our way that created a calmness and confidence that we could do it.Thierry Ibri,chief operations and programs officer,Second Harvest Heartland2Making a differ12、ence with dataTurning to dataThe COVID-19 crisis has forced food banks to address other challenges.Some have upgraded warehouse practices to manage a substantial increase in food supplies.Others have improved planning by segmenting food sources and distribution channels by type.Some have begun to wo13、rk with new community partners to tackle the root problems that contribute to food insecurity,including housing,healthcare,and job skills.The changes come as food banks grapple with assisting up to 54 million Americans in danger of being food insecure and not having enough to eat.Better data are at 14、the heart of many new processes.Food banks operations have always depended on data to track how much food is donated,purchased,and received through government programs;or rescued from restaurants,coffee shops,and grocery stores.Food banks also use data to calculate how many food boxes or supplies fo15、r meal programs need to go out.But because COVID-19 created an unprecedented surge in demand,food banks couldnt depend solely on what they did in the past to calculate future needs.For that,they had to take planning to the next level.That was the situation for Second Harvest Heartland.Based on the f16、lurry of requests when the pandemic hit,it became clear that“historical data werent going to provide an accurate forecast of what was coming,”Ibri said.Second Harvest Heartland needed better insights into the needs of its service area,which includes 3Making a difference with data41 counties in Minne17、sota and 18 more across the state line in western Wisconsin.Since the crisis,an additional 275,000 Minnesotansincluding 112,000 childrenbecame at risk of going hungry,an increase of nearly 60 percent from 2019,according to Second Harvest Heartlands estimates.At the same time,the food bank needed to 18、adopt procedures to avoid a virus breakout at its new 230,000-square-foot warehouse in Brooklyn Park,north of Minneapolis.“With 75 percent of the food distributed by food pantries in our service area coming from us,it would have been disastrous to shut down,”Ibri said.Second Harvest Heartland partne19、red with McKinsey to develop a demand model to forecast the supply that it would need,based on various scenarios of future demand.One critical component of the model was a formula developed by Feeding America,a non-profit network of 200 US food banks including Second Harvest Heartland,and 60,000 par20、tner food pantries and meal programs.The Feeding America formula maps the connection between food insecurity and variables like poverty and unemployment.The food bank project team combined information from the Feeding America formula with projections from Oxford Economics for how the COVID-19 crisis21、 could affect unemployment and poverty in the region.This allowed the team to come up with best-case and worst-case scenarios for how food demand could vary from May to December for each county in their service area(Exhibit 1).Planning for the worstThe model helped Second Harvest Heartlands staff to22、 determine that demand could increase 30 percent to 66 percent by the end of the year,depending on the effect of the crisis on the states economy,but likely peaking in early fall when Exhibit 1Projections of best-and worst-case scenarios of food demand as of April 2020.Note:Food demand increase esti23、mate assumed that expansion of unemployment insurance benefts to self-employed individuals would begin in June,and that CARE Act-enhanced unemployment benefts would not be renewed;meals are calculated at 1.2 pounds each;excludes non-food distributed pounds.Source:BLS;Feeding America,QPR distributed 24、pounds dataProjections of best-and worst-case scenarios of food demand as of April 2020.109876543210MayJuneJulyAugustSeptemberOctoberNovemberDecemberUnemployment insurance and SNAP benefts that expired in August led to a surge in demandIn 2019,the food bank distributed an average of 6.7 million poun25、ds a monthThrough the end of 2020,food demand was forecast to increase 30%to 66%or from 24 mil-lion to 53 million pounds more than what was distributed last year.For May,the increase translated to 46%higher demand than food distributed in the same month in 2019.Worst case:Demand peaks at125%of food 26、distributed in2019,approximately 9 million poundsBest case:Demand peaks at68%of food distributed in2019,approximately 5 million poundsBest-case scenarioWorst-case scenarioInsights4Making a difference with datafederal relief funds were due to run out.If the worst-case scenario came to pass,the food b27、ank would need 91 million pounds of food to meet the projected need for the year26 million pounds more than usual,or the equivalent of roughly 31.2 million meals.Armed with that information,the food banks leadership secured additional state funds,which they used to purchase food and increase orders 28、from local growers.In turn,that helped offset the decline in donated goods.Vanhove,who handles purchasing,said having more accurate forecasts gave her the confidence to take delivery of large orderssuch as buying“a third truckload of corn”that might have seemed questionable without such visibility.H29、aving concrete data also provided information the food bank could share with staff to show how well things were going,and for the food banks fundraising team to show prospective donors.“It gave them a script to go out and talk to donors with some certainty about the food that we would need and why w30、e were asking for money,”noted Ibri.The reaction from food pantries and the public has been unanimously positive.“We received really good feedback about our ability to respond to and evolve as needs arose,”Vanhove said.Since April,Second Harvest Heartland has updated the forecasting model every mont31、h,and adjusted planning based on how the virus and the economy are playing out.As of late September,the food banks estimates show demand running about 30 percent higher than average(Exhibit 2).“The good news is the model is month by month,so we didnt have to source 26 million pounds of food,”she sai32、d.“We could ratchet down the plan to be in sync and have the supply plan match the demand.”Exhibit 2Food bank demand is approximately 30%higher than average.1Actual purchases used for May and June-Dec assumes purchases same as 2019,assumes TEFAP increases June-Sept and CFAP increases JuneDec.2Exclud33、es non-food items.Source:QPR distributed lbs.data;USDA;News articles(for estimated industry donation recovery)Total food supply(MayDec,2020),M lbs.1,2 181614121086420MayJunJulAugSepOctNovDecExtended scenario food demandAssumed scenario food demandAdditional TEFAP2MPandemic SNAP3MAdditional produce1034、MAdditional purchased11MDonatedFED Comm:TEFAP/CSFPPurchasedCGFAP5Making a difference with dataForecasting models for other purposesA beneficial byproduct of developing the model was getting a better read on the amount of inventory coming in and going out of Second Harvest Heartlands new warehouse.Th35、e food bank also used it to inform staffing and warehouse capacityand not a moment too soon.“The warehouse we just built and moved into was supposed to cover us for ten years.But by July,it was already at 95 percent capacity,”Vanhove said.The application also shows where the agency might run into bo36、ttlenecks with refrigerator,freezer,and dry-storage space.This information is now being collected to develop future capacity-planning forecasts,she said.Second Harvest Heartland doesnt expect to use the COVID-19 forecasting model beyond next year.But it may serve as the basis for other planning mode37、ls that the food banks supply-and demand-planning staff expect to create in the future.“It informed us of what a dashboard would look like,and what the components are that we should look at from a planning perspective,”Vanhove said.Based on the food banks experience,its clear that using data-driven 38、models can make a difference.Its also clear that modeling works best when leaders are willing to embrace it and trade instinct for evidence,and use the data they collect to implement new decision-making processes that inform supply-chain planning from sourcing to delivery.David Fiocco is a partner in McKinseys Minneapolis office,where Audrey Lucas is a senior partner and Megan Knoch-Dohlin is a consultant.Byron Ruby is a consultant in the San Francisco office.Copyright 2020 McKinsey&Company.All rights reserved.6Making a difference with data