Matching Items (2)
Filtering by
- All Subjects: Excel
- Creators: Faris, Kay
Description
The project mainly involves creating a standardized tool to help American Airlines evaluate the cost of Non-Recurring Engineering fees (NRE fees) that arise as a result of maintenance and repairs on airplanes. Since there are few manufacturers licensed by the FAA to complete these modifications, let alone have the capabilities to complete them, American Airlines is often charged substantial fees to complete even minor work. The team will begin by conducting academic research looking into how parallel industries such as Automotive, Aerospace, High-Tech Manufacturing, etc. deal with heavily regulated modifications. We will then use this academic research to building a framework that American Airlines is able to use to estimate the fair cost of completing some of these modifications. The hope is that American Airlines can use this framework to determine whether they are being charged fair prices, and if they are not, to use the framework as leveraging tool in negotiations.
ContributorsShah, Shimoli (Co-author) / Harris, Taylor (Co-author) / Hebel, Ryan (Co-author) / Taylor, Todd (Thesis director) / Faris, Kay (Committee member) / Department of Information Systems (Contributor, Contributor) / Department of Economics (Contributor) / Department of Finance (Contributor) / Department of Supply Chain Management (Contributor) / Computer Science and Engineering Program (Contributor) / Barrett, The Honors College (Contributor)
Created2016-12
Description
The goal of this thesis was to provide in depth research into the semiconductor wet-etch market and create a supplier analysis tool that would allow Company X to identify the best supplier partnerships. Several models were used to analyze the wet etch market including Porter's Five Forces and SWOT analyses. These models were used to rate suppliers based on financial indicators, management history, market share, research and developments spend, and investment diversity. This research allowed for the removal of one of the four companies in question due to a discovered conflict of interest. Once the initial research was complete a dynamic excel model was created that would allow Company X to continually compare costs and factors of the supplier's products. Many cost factors were analyzed such as initial capital investment, power and chemical usage, warranty costs, and spares parts usage. Other factors that required comparison across suppliers included wafer throughput, number of layers the tool could process, the number of chambers the tool has, and the amount of space the tool requires. The demand needed for the tool was estimated by Company X in order to determine how each supplier's tool set would handle the required usage. The final feature that was added to the model was the ability to run a sensitivity analysis on each tool set. This allows Company X to quickly and accurately forecast how certain changes to costs or tool capacities would affect total cost of ownership. This could be heavily utilized during Company X's negotiations with suppliers. The initial research as well the model lead to the final recommendation of Supplier A as they had the most cost effective tool given the required demand. However, this recommendation is subject to change as demand fluctuates or if changes can be made during negotiations.
ContributorsSchmitt, Connor (Co-author) / Rickets, Dawson (Co-author) / Castiglione, Maia (Co-author) / Witten, Forrest (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Michael (Committee member) / Department of Finance (Contributor) / Department of Economics (Contributor) / Department of Information Systems (Contributor) / Department of Supply Chain Management (Contributor) / School of Mathematical and Statistical Sciences (Contributor) / School of Accountancy (Contributor) / WPC Graduate Programs (Contributor) / Barrett, The Honors College (Contributor)
Created2016-12