The goal of this project is to help answer important analytic questions about the throughput of inventory for the Food Bank of Northern Nevada (FBNN). The FBNN would like to improve their understanding of what, how much, and where food goes, and how long it stays in the FBNN warehouse.
Provide a tool by which to optimize for efficiency and efficacy, getting as much food to those in need as possible therein minimizing waste, plus empowering our staff with a way to predict from historical trends what to order and when, as well as what to NOT order and when). This will also help us influence our partners in what we receive, e.g., if we always end up having to discard an item, why? Is there a better way to handle item, or should we create a list of items to not accept?
One intervention would be purchasing behavior by Director of Food Purchasing. Another intervention would be navigating partnerships with donors, WalMart or otherwise.
Several years of data on the donations by WalMart. Several years’ worth of distribution data in terms of online orders, push model delivered and mobile harvests. Data is stored on ERP "Ceres 2009 R2"
Report/Dashboard Tool based on historical trends to help us answer: What food items, in what quantity, during which timeframe, are donated by Walmart? How long does food item stay in warehouse before it gets distributed? Which distribution stream? Where do those products that are used, go? Typically, which donation stream do these food items end up in? Where do those products that are unused, go / end up? How much product from WalMart in a given quarter is used / unused? Is this final destination considered successful or not?
Time series analysis
The FBNN is most interested in having the analytic questions answered and presented in an interpretable, meaningful way. In the short term, this may be designing a report. In the long term, if time permits, the FBNN would like to have a dashboard created that shows these different insights & views of their data.
Initial scope at project creation time.