Frito-Lay Out-of-Stock Inventory Modeling Tool
Client: Frito Lay
Team: Matt Alfano, Brittany Masi
Faculty Advisor: Dr. Barr Year: 2010
Documents: Presentation, Report, Video
The project is to design and create an out-of-stock inventory tool that is user-friendly and able to historically scan data while predicting inventory shortfall at the club/SKU level. More features of this project include determining what Inventory is needed by club/SKU and determine delivery frequency by club. We decided that only these opportunities fell into the scope of our project.
After consolidating all of the available information into one database we removed unnecessary tables to increase the processing speed of analyzing the product “Spy Reports” generated by their current database queries. We analyzed two of the highest-demand product lines that Frito Lay stocks at Sam’s Clubs nationwide. These two products are Smart Mix and Variety Mix.We created seasonal adjustment and linear exponential smoothing models in an Excel file that could automatically do every club’s analysis. This gave us extreme flexibility and had the best potential for creating a very user friendly tool that could automatically change based on a drop down box connected to each Sam’s Club Number and corresponding Sales data. Anyone could copy and paste the sales data given in any Spy Report by product line into the first tab and have instant analysis at the touch of their fingers.