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
Team: Rodrigo Cantu, Sergio Hueck, Rafael Virzi
Faculty Advisor: Dr. Barr
Year: 2012
Documents: Presentation, Report, Video
Gamesa, a subsidiary of Frito-Lay, is a Mexican Cookie company that sells its product in many different countries, including the United States. Their products, which includes different types of cookies and crackers, are targeted to the Mexican population. The company’s United States sales force consists of 38 representatives in 16 different regions, organized by their different routes to market, location of warehouses, and population density. Today, they dominate the U.s. Hispanic cookie market occupying 50 percent of the market.
The problem we address for Gamesa is: should they should deploy more sales representatives and, if so, where would their optimal locations be? With the current economic recession and the entering of Gamesa’s main competitor, Bimbo, sales have been dropping in the different regions. This resulted in Gamesa asking themselves if they needed a bigger sales force. They also wanted to know what regions could be good to add representatives in the future depending on the migration of the population or the strategy of the competition. Read more…
Categories: Final report, Forecasting, Manufacturing, Marketing, Operations, Optimization, Presentation, Real estate, Simulation, Statistical Methods, Uncategorized, United States, Video Tags:
Client: Frito Lay
Team: Javier Gonzalez, Fernando Sada, Marcelo Sada
Faculty Advisor: Dr. Siems
Year: 2011
Documents: Final Report, Presentation
In order to satisfy the large Hispanic market in the United States, Frito Lay imports products manufactured in Mexico by Gamesa, a sister company to Frito Lay due to the fact that they are both owned by PepsiCo. Gamesa has plants all across Mexico, having the main ones located in Celaya, Vallejo, Obregon and Monterrey. In the past, all products being imported into the U.S were produced in Obregon, a city in Northwestern Mexico. As of today, the Hispanic population has dispersed all across the country, increasing Gamesa’s market to a large portion of it. Gamesa’s products are now being distributed all the way from California, to Texas, and onto the East Coast and Midwest. Imports have increased so much that in order to satisfy the demand, Gamesa has started producing all across Mexico for exports. Read more…
The stories of three Senior Design projects from the clients’ point of view, including North Texas Food Bank, Texas Department of Transportation, and Southwest Airlines:
