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. Read more…
Categories: Final report, Forecasting, Inventory management, Manufacturing, Operations, Planning, Presentation, Statistical Methods, Transportation, Uncategorized, United States, Video Tags:
Client: Frito-Lay, Inc. and Sam’s Club
Team: Christian Edison, Ashley Mills, Stephen Rumpler
Faculty advisor: Dr. Siems Year: 2005
Documents: Final report (PDF)
Working with the Frito-Lay Supply Chain Department, our team has found an improved inventory process that will increase in-stock performance at Sam’s Clubs. Sam’s Club demands a 99.8% in-stock performance. Currently, Frito-Lay is not meeting this demand, therefore improvements must be made.
Analyzing Frito-Lay’s current inventory replenishment process, we discovered several problems. Some of these problems included inconsistencies in taking inventory at the clubs, negligence of inventory worksheets, and lack of communication. After further analysis, we discovered that forecasting more accurately would prevent some of these problems. There was a new challenge: finding a method of forecasting the new product line, Pick ‘N Pack. With very little historical sales, it was difficult to forecast sales. Read more…
Client: Achieve Healthcare Technologies
Team: Kristin March, Laura Bailey, Rachel Potter, Allison Bass
Faculty advisor: Barr Year: 2006
Documents: Final report (Word), final presentation (PPT)
Achieve Healthcare Technologies is the largest privately held provider of information system products and services to the long-term care industry. They serve clients across the U.S. and have long stood for higher quality and improved bottom lines for sub-acute long-term care, skilled nursing, assisted living, and continuing care retirement facilities and communities. Additionally, they have consistently led the industry in introducing new, innovative products and services. Read more…
Client: Raytheon Corp.
Team: Ellen Cieszkiewicz, Chuck Haley, Heather Schofield
Faculty advisor: Dr. Richard Barr Year: 2008
Documents: Final report, final presentation
Raytheon supplies its customers, mainly the government, with programs they utilize for important projects. It is Raytheon’s job to not only purchase these programs but also keep them regularly updated. Some of the software vendors that Raytheon purchases licenses from include but are not limited to Sun Microsystems, Adobe and Oracle. Needed is a means of optimizing the licensing plan, which might save hundreds of thousands of dollars annually. Read more…
