Matching Items (5)
Filtering by
- All Subjects: Excel
- Creators: Hertzel, Michael
Description
The object of the present study is to examine methods in which the company can optimize their costs on third-party suppliers whom oversee other third-party trade labor. The third parties in scope of this study are suspected to overstaff their workforce, thus overcharging the company. We will introduce a complex spreadsheet model that will propose a proper project staffing level based on key qualitative variables and statistics. Using the model outputs, the Thesis team proposes a headcount solution for the company and problem areas to focus on, going forward. All sources of information come from company proprietary and confidential documents.
ContributorsLoo, Andrew (Co-author) / Brennan, Michael (Co-author) / Sheiner, Alexander (Co-author) / Hertzel, Michael (Thesis director) / Simonson, Mark (Committee member) / Barrett, The Honors College (Contributor) / Department of Information Systems (Contributor) / Department of Finance (Contributor) / Department of Supply Chain Management (Contributor) / WPC Graduate Programs (Contributor) / School of Accountancy (Contributor)
Created2014-05
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
Description
The Covid-19 pandemic has made a significant impact on both the stock market and the<br/>global economy. The resulting volatility in stock prices has provided an opportunity to examine<br/>the Efficient Market Hypothesis. This study aims to gain insights into the efficiency of markets<br/>based on stock price performance in the Covid era. Specifically, it investigates the market’s<br/>ability to anticipate significant events during the Covid-19 timeline beginning November 1, 2019<br/><br/>and ending March 31, 2021. To examine the efficiency of markets, our team created a Stay-at-<br/>Home Portfolio, experiencing economic tailwinds from the Covid lockdowns, and a Pandemic<br/><br/>Loser Portfolio, experiencing economic headwinds from the Covid lockdowns. Cumulative<br/>returns of each portfolio are benchmarked to the cumulative returns of the S&P 500. The results<br/>showed that the Efficient Market Hypothesis is likely to be valid, although a definitive<br/>conclusion cannot be made based on the scope of the analysis. There are recommendations for<br/>further research surrounding key events that may be able to draw a more direct conclusion.
ContributorsBeneduce, Trevor Paul (Co-author) / Craig, Nicko (Co-author) / Brock, Matt (Co-author) / Hertzel, Michael (Thesis director) / Mindlin, Jeff (Committee member) / Department of Information Systems (Contributor) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2021-05
Description
Elon Musk is known for making controversial tweets, which often lead to lawsuits. Our thesis focuses on analyzing the effect that these individual tweets have on stock prices. Our hypothesis focuses on the idea that when Elon Musk makes a controversial tweet, the volatility of Tesla stock will increase, while the price of Tesla stock will on average decrease. The thirteen tweets that we are examining are the tweets that we deemed to be most important, which are measured by the amount of press coverage that they have received. We also evaluated the effect that two different lawsuits that stemmed from Musk’s reckless tweets had on Tesla stock. After evaluating the effect that Elon Musk’s tweets had on the stock volume and price, we will then determine whether or not Elon Musk and other CEO’s alike should be able to tweet in a similar manner. In order to analyze stock movement, volume, and significance we imported statistical data from Yahoo Finance and Nasdaq into Excel. From there, We added charts to model the volatility and the direction of price data. Additionally, we created separate indexes to compare stock moves and test for abnormal returns. From these returns we were able to calculate the alpha and beta for Tesla, its peers and competitors. To analyze Musk’s tweets, we collected close to 7,000 tweets and ordered them chronologically in Excel. With the combination of the stock and tweet data, we were in an excellent spot to analyze the data and come to a conclusion.
ContributorsDe Roo, Gilles (Co-author) / Lueck, Elliott (Co-author) / Budolfson, Arthur (Thesis director) / Hertzel, Michael (Committee member) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2020-05
Description
"Company X," a technology company, is known for being one of the world’s largest semiconductor chip manufacturers; however, they are also one of the largest authors of software. In 2019, "Company X" entered a new paradigm where, according to the CEO, while "Company X"’s core strategy has not changed, "Company X" is embracing the transition to a data-centric company from a PC-centric company. The scope that the project examines is--in this transition to a data-centric company and based on the company's current expertise and competitive advantages--should "Company X" be branching into an additional division or leverage existing intellectual property (IP)? The goal of the project is to understand how "Company X" can leverage its expertise in hardware and software service packages to maximize the value of the company.
ContributorsArellano, Andrea (Co-author) / Roos, Bailey (Co-author) / Broas, Joshua (Co-author) / Kotti, Abhigyan (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Michael (Committee member) / Dean, W.P. Carey School of Business (Contributor) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2020-05