Matching Items (3)
Filtering by
- All Subjects: Business
- All Subjects: Inventory Management
Description
P.F. Chang's China Bistro is a privately-held purveyor of Asian fare in the United States and internationally, known largely for its vibrant atmosphere and lettuce wraps. With hundreds of locations and dozens of menu items, procurement, logistics, and coordination of ingredient delivery to P.F. Chang's restaurants is no small task. Despite their difficulty, supply chain operations from suppliers to customers' plates must run efficiently if P.F. Chang's is to maintain customer loyalty, a trusted brand, and profitability. As such, supply chain initiatives that allow for faster, better, or lower-cost operation are valuable investments for P.F. Chang's. In this project, two initiatives focused on increasing visibility along the value chain (with the hope of creating immediate value and easier implementation for future strategies). The first initiative involved stakeholder interviews and academic research to determine evaluation methods for P.F. Chang's suppliers in the form of a scorecard. The second project required extensive data collection from suppliers to isolate and remove excess cost in the inbound logistics of P.F. Chang's inventory. Both initiatives led to incremental improvement at P.F. Changs and the latter provided substantial cost savings. Further investigation and work is likely to yield continued benefits for the company. The increased use of data in all supply chains to guide decision-making will be easier for P.F. Chang's as it manages ongoing visibility efforts. Although process explanation and general outcomes will be reported here, the proprietary nature of P.F. Chang's data precludes full disclosure of the project results in public documentation.
ContributorsBarger, Michael Richard (Author) / Taylor, Todd (Thesis director) / Miller, Steve (Committee member) / Department of Economics (Contributor) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2018-05
Description
The purpose of this project is to provide our client with a tool to mitigate Company X's franchise-wide inventory control problem. The problem stems from the franchises' initial strategy to buy all inventory as customers brought them in without a quantitative way for buyers to evaluate the store's inventory needs. The Excel solution created by our team serves to provide that evaluation for buyers using deseasonalized linear regression to forecast inventory needs for clothing of different sizes and seasons by month. When looking at the provided sales data from 2014-2016, there was a clear seasonal trend, so the appropriate forecasting model was determined by testing 3 models: Triple Exponential Smoothing model, Deseasonalized Simple Linear Regression, and Multiple Linear Regression.The model calculates monthly optimal inventory levels (current period plus future 2 periods of inventory). All of the models were evaluated using the lowest mean absolute error (meaning best fit with the data), and the model with best fit was Deseasonalized Simple Linear Regression, which was then used to build the Excel tool. Buyers can use the Excel tool built with this forecasting model to evaluate whether or not to buy a given item of any size or season. To do this, the model uses the previous year's sales data to forecast optimal inventory level and compares it to the stores' current inventory level. If the current level is less than the optimal level, the cell housing current value will turn green (buy). If the currently level is greater than or equal to optimal level or less than optimal inventory level*1.05, current value will turn yellow (buy only if good quality). If the current level is greater than optimal level*1.05 current level will be red (don't buy). We recommend both stores implement a way of keeping track of how many clothing items held in each bin to keep more accurate inventory count. In addition, the model's utility will be of limited use until both stores' inventories are at a level where they can afford to buy. Therefore, it is in the client's best interest to liquidate stale inventor into store credit or cash In the future, the team would also like to develop a pricing model to better meet the needs of the client's two locations.
ContributorsUribes-Yanez, Diego (Co-author) / Liu, Jessica (Co-author) / Taylor, Todd (Thesis director) / Gentile, Erica (Committee member) / Department of Economics (Contributor) / Department of Information Systems (Contributor) / Department of Marketing (Contributor) / School of International Letters and Cultures (Contributor) / School of Life Sciences (Contributor) / Department of Supply Chain Management (Contributor) / Barrett, The Honors College (Contributor)
Created2017-05
Description
The key to success is hard work and determination. Achieving success is always under construction. This project began as a simple analysis of the firm's progress, as at the time it was in desperate need of new clients and a marketing strategy to strengthen its visibility on campus.Through this evaluation, our team found that the firm was in an abysmal state and the previously noted problems were not the only issues of concern. From our research we found that in order for the firm to grow and become a successful student run consulting firm, there are several interorganizational issues that need to be understood and addressed. The intention of New Venture Group and the Consulting Scholars academic program is to provide students the opportunity to garner practical learning experiences. These potential opportunities are not taken full advantage of because of the afflicting problems that exist. The purpose of this thesis is to understand what problems exist within the firm and the next steps that should be taken to resolve them.
ContributorsBaskin, Connor (Co-author) / Farr, Austin (Co-author) / Chou, Alexandra (Co-author) / Laub, Jeffrey (Thesis director) / Taylor, Todd (Committee member) / Department of Supply Chain Management (Contributor) / Department of Economics (Contributor) / Department of Marketing (Contributor) / Department of Finance (Contributor) / School of International Letters and Cultures (Contributor) / School of Historical, Philosophical and Religious Studies (Contributor) / Department of Information Systems (Contributor) / W. P. Carey School of Business (Contributor) / Barrett, The Honors College (Contributor)
Created2016-05