Matching Items (10)
Filtering by
- All Subjects: Supply Chain
- Status: Published
Description
Over the course of six months, we have worked in partnership with Arizona State University and a leading producer of semiconductor chips in the United States market (referred to as the "Company"), lending our skills in finance, statistics, model building, and external insight. We attempt to design models that help predict how much time it takes to implement a cost-saving project. These projects had previously been considered only on the merit of cost savings, but with an added dimension of time, we hope to forecast time according to a number of variables. With such a forecast, we can then apply it to an expense project prioritization model which relates time and cost savings together, compares many different projects simultaneously, and returns a series of present value calculations over different ranges of time. The goal is twofold: assist with an accurate prediction of a project's time to implementation, and provide a basis to compare different projects based on their present values, ultimately helping to reduce the Company's manufacturing costs and improve gross margins. We believe this approach, and the research found toward this goal, is most valuable for the Company. Two coaches from the Company have provided assistance and clarified our questions when necessary throughout our research. In this paper, we begin by defining the problem, setting an objective, and establishing a checklist to monitor our progress. Next, our attention shifts to the data: making observations, trimming the dataset, framing and scoping the variables to be used for the analysis portion of the paper. Before creating a hypothesis, we perform a preliminary statistical analysis of certain individual variables to enrich our variable selection process. After the hypothesis, we run multiple linear regressions with project duration as the dependent variable. After regression analysis and a test for robustness, we shift our focus to an intuitive model based on rules of thumb. We relate these models to an expense project prioritization tool developed using Microsoft Excel software. Our deliverables to the Company come in the form of (1) a rules of thumb intuitive model and (2) an expense project prioritization tool.
ContributorsAl-Assi, Hashim (Co-author) / Chiang, Robert (Co-author) / Liu, Andrew (Co-author) / Ludwick, David (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Michael (Committee member) / Barrett, The Honors College (Contributor) / Department of Information Systems (Contributor) / Department of Finance (Contributor) / Department of Economics (Contributor) / Department of Supply Chain Management (Contributor) / School of Accountancy (Contributor) / School of Mathematical and Statistical Sciences (Contributor) / Mechanical and Aerospace Engineering Program (Contributor) / WPC Graduate Programs (Contributor)
Created2015-05
Description
Exchange traded funds (ETFs) in many ways are similar to more traditional closed-end mutual funds, although thee differ in a crucial way. ETFs rely on a creation and redemption feature to achieve their functionality and this mechanism is designed to minimize the deviations that occur between the ETF’s listed price and the net asset value of the ETF’s underlying assets. However while this does cause ETF deviations to be generally lower than their mutual fund counterparts, as our paper explores this process does not eliminate these deviations completely. This article builds off an earlier paper by Engle and Sarkar (2006) that investigates these properties of premiums (discounts) of ETFs from their fair market value. And looks to see if these premia have changed in the last 10 years. Our paper then diverges from the original and takes a deeper look into the standard deviations of these premia specifically.
Our findings show that over 70% of an ETFs standard deviation of premia can be explained through a linear combination consisting of two variables: a categorical (Domestic[US], Developed, Emerging) and a discrete variable (time-difference from US). This paper also finds that more traditional metrics such as market cap, ETF price volatility, and even 3rd party market indicators such as the economic freedom index and investment freedom index are insignificant predictors of an ETFs standard deviation of premia when combined with the categorical variable. These findings differ somewhat from existing literature which indicate that these factors should have a significant impact on the predictive ability of an ETFs standard deviation of premia.
Our findings show that over 70% of an ETFs standard deviation of premia can be explained through a linear combination consisting of two variables: a categorical (Domestic[US], Developed, Emerging) and a discrete variable (time-difference from US). This paper also finds that more traditional metrics such as market cap, ETF price volatility, and even 3rd party market indicators such as the economic freedom index and investment freedom index are insignificant predictors of an ETFs standard deviation of premia when combined with the categorical variable. These findings differ somewhat from existing literature which indicate that these factors should have a significant impact on the predictive ability of an ETFs standard deviation of premia.
ContributorsZhang, Jingbo (Co-author, Co-author) / Henning, Thomas (Co-author) / Simonson, Mark (Thesis director) / Licon, L. Wendell (Committee member) / Department of Finance (Contributor) / Department of Information Systems (Contributor) / School of Mathematical and Statistical Sciences (Contributor) / Barrett, The Honors College (Contributor)
Created2019-05
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
This thesis examines the value creation potential of renovating an existing commercial real estate asset to a medical office. It begins by examining commercial real estate and the medical sector at a high level. It then discusses the various criteria used to select a subject property for renovation. This renovation is then depicted through a modified pitch book that contains a financial model and pro forma.
ContributorsLarrea, Justin (Co-author) / Berger, Nicholas (Co-author) / Peters, Matthew (Co-author) / Simonson, Mark (Thesis director) / Gray, William (Committee member) / Department of Finance (Contributor) / Department of Supply Chain Management (Contributor) / Barrett, The Honors College (Contributor)
Created2021-05
Description
This thesis examines the value creation potential of renovating an existing commercial real estate asset to a medical office. It begins by examining commercial real estate and the medical sector at a high level. It then discusses the various criteria used to select a subject property for renovation. This renovation is then depicted through a modified pitch book that contains a financial model and pro forma.
ContributorsBerger, Nicholas James (Co-author) / Larrea, Justin (Co-author) / Peters, Matthew (Co-author) / Simonson, Mark (Thesis director) / Gray, William (Committee member) / School of Accountancy (Contributor) / Dean, W.P. Carey School of Business (Contributor) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2021-05
Description
This thesis examines the value creation potential of renovating an existing commercial real estate asset to a medical office. It begins by examining commercial real estate and the medical sector at a high level. It then discusses the various criteria used to select a subject property for renovation. This renovation is then depicted through a modified pitch book that contains a financial model and pro forma.
ContributorsPeters, Matthew Scott (Co-author) / Larrea, Justin (Co-author) / Berger, Nicholas (Co-author) / Simonson, Mark (Thesis director) / Gray, William (Committee member) / Department of Finance (Contributor, Contributor) / Department of Information Systems (Contributor) / Barrett, The Honors College (Contributor)
Created2021-05
Description
This paper serves as an analysis of the current operational conditions of a real-world company – referred to as “Company X” – with respect to the IC substrate industry. The cost of substrates, a crucial component in the production of Company X’s product, has recently diverged from Company X’s predictions and is contributing to declining profitability. This analysis aims to discover the underlying cause for price divergence and recommend potential resolutions to improve the forecast of substrate costs and profitability. The paper is organized as follows: Chapter 1 is an introduction to IC substrates and the industry as a whole, Chapter 2 is a breakdown of the specific factors responsible for substrate prices, and Chapter 3 delivers a final recommendation to Company X and concludes the paper.
ContributorsO'Loughlin, Connor (Author) / Fares, Ari (Co-author) / Aggarwal, Bianca (Co-author) / King, Camden (Co-author) / Guillaume, Riley (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Mike (Committee member) / Barrett, The Honors College (Contributor) / Department of Finance (Contributor) / School of Mathematical and Statistical Sciences (Contributor)
Created2023-05
Description
This thesis discusses the case for Company X to improve its vast supply chain by implementing an artificial intelligence solution in the management of its spare parts inventory for manufacturing-related machinery. Currently, the company utilizes an inventory management system, based on previously set minimum and maximum thresholds, that doesn’t use predictive analytics to stock required spares inventory. This results in unnecessary costs and redundancies within the supply chain resulting in the stockout of spare parts required to repair machinery. Our research aimed to quantify the cost of these stockouts, and ultimately propose a solution to mitigate them. Through discussion with Company X, our findings led us to recommend the use of Artificial Intelligence (A.I.) within the inventory management system to better predict when stockouts would occur. As a result of data availability, our analysis began on a smaller scale, considering only a single manufacturing site at Company X. Later, our findings were extrapolated across all manufacturing sites. The analysis includes the cost of stockouts, the capital that would be saved with A.I. implementation, costs to implement this new A.I. software, and the final net present value (NPV) that Company X could expect in 10 years and 25 years. The NPV calculations explored two scenarios, an external partnership and the purchase of a small private company, that lead to our final recommendations regarding the implementation of an A.I. software solution in Company X’s spares inventory management system. Following the analysis, a qualitative discussion of the potential risks and market opportunities associated with the explored implementation scenarios further guided the determination of our final recommendations.
ContributorsHolohan, Joseph Michael Houston (Co-author) / Shahriari, Rosie (Co-author) / Aun, Jose (Co-author) / Heineke, Christopher (Co-author) / Gurrola, Macario (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Michael (Committee member) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2020-05
Description
This thesis examines real experiences of how small businesses responded to the COVID-19 pandemic in order to generate recommendations for said businesses post pandemic from a finance and supply chain perspective. A literature review finds that several trends that emerged over the pandemic, such as supply and demand changes, workforce difficulties, financing struggles, and the effectiveness of the Payment Protection Program. Next, we conducted a survey of local small businesses based on the findings in the literature review. The survey aimed to examine managers’ struggles, strategies, and responses to the pandemic. The survey responses were examined and then analyzed to find how they compare to the statistics from the literature review. The findings from the results and other sources served as the basis for which small business recommendations are made on how to prepare for future unprecedented economic crises and better situate themselves to respond.
ContributorsThomas, Ryan (Author) / Onyszchuk, Ethan (Co-author) / Printezis, Antonios (Thesis director) / Simonson, Mark (Committee member) / Barrett, The Honors College (Contributor) / Department of Supply Chain Management (Contributor) / Department of Information Systems (Contributor)
Created2022-05
Description
This thesis examines real experiences of how small businesses responded to the COVID-19 pandemic in order to generate recommendations for said businesses post pandemic from a finance and supply chain perspective. A literature review finds that several trends that emerged over the pandemic, such as supply and demand changes, workforce difficulties, financing struggles, and the effectiveness of the Payment Protection Program. Next, we conducted a survey of local small businesses based on the findings in the literature review. The survey aimed to examine managers’ struggles, strategies, and responses to the pandemic. The survey responses were examined and then analyzed to find how they compare to the statistics from the literature review. The findings from the results and other sources served as the basis for which small business recommendations are made on how to prepare for future unprecedented economic crises and better situate themselves to respond.
ContributorsOnyszchuk, Ethan (Author) / Thomas, Ryan (Co-author) / Simonson, Mark (Thesis director) / Printezis, Antonios (Committee member) / Barrett, The Honors College (Contributor) / Department of Finance (Contributor) / School of Accountancy (Contributor) / Department of Information Systems (Contributor)
Created2022-05