Inventory Control at a University Food Pantry Using an MVC Software Pattern and Data Visualization

University food pantries have been opened on-campus to reduce food insecurity among students. However, they are relatively self-governed and receive a limited amount of support. This study aims to resolve the inventory management issue at university food pantries using the combination of the Model-View-Controller (MVC) software pattern and data visualization. As a result, a foundation is established to predict the food choices of clients and to manage food waste effectively. The benefits of visualization on decision making through the use of a resourceful inventory system are outlined. The focus of this research is on university pantries, in particular, the Aggie Source Food Pantry at North Carolina Agricultural & Technical State University. A sample of 50 clients' food choices was acquired from picklists for June and July of 2019. The inventory tracking system implemented is a client-server mobile application used for data collection. Data visualization was applied to evaluate the food donations and distributions. Students preferred essential foods (e.g., pasta, canned vegetables), over unhealthy foods (e.g., Pop-Tarts, cookies). The data consisted of 338 pounds of distributed food and almost 2,473 pounds of donations. Data was simplified into comprehensive visual diagrams. The MVC structure established a program interface that grouped application functions and managed data objects. The solution allowed the staff to understand pantry status and the trends in production. It is anticipated that the prototype will be implemented in the daily activities of the pantry.