Matching Items (7)

134974-Thumbnail Image.png

Collaborative Thesis: Supplier Tool Selection

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

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.

Contributors

Agent

Created

Date Created
  • 2016-12

135426-Thumbnail Image.png

Company X Supplier Financial Health Model

Description

Company X is one of the world's largest manufacturer of semiconductors. The company relies on various suppliers in the U.S. and around the globe for its manufacturing process. The financial

Company X is one of the world's largest manufacturer of semiconductors. The company relies on various suppliers in the U.S. and around the globe for its manufacturing process. The financial health of these suppliers is vital to the continuation of Company X's business without any material interruption. Therefore, it is in Company X's interest to monitor its supplier's financial performance. Company X has a supplier financial health model currently in use. Having been developed prior to watershed events like the Great Recession, the current model may not reflect the significant changes in the economic environment due to these events. Company X wants to know if there is a more accurate model for evaluating supplier health that better indicates business risk. The scope of this project will be limited to a sample of 24 suppliers representative of Company X's supplier base that are public companies. While Company X's suppliers consist of both private and public companies, the used of exclusively public companies ensures that we will have sufficient and appropriate data for the necessary analysis. The goal of this project is to discover if there is a more accurate model for evaluating the financial health of publicly traded suppliers that better indicates business risk. Analyzing this problem will require a comprehensive understanding of various financial health models available and their components. The team will study best practice and academia. This comprehension will allow us to customize a model by incorporating metrics that allows greater accuracy in evaluating supplier financial health in accordance with Company X's values.

Contributors

Agent

Created

Date Created
  • 2016-05

Streamlining Early Stage Photovoltaic Electrical Subcontracting Scope and Pricing

Description

This paper introduces an excel tool created to improve the accuracy of electrical subcontracting prices for solar photovoltaic energy systems while also minimizing the time needed to create these price

This paper introduces an excel tool created to improve the accuracy of electrical subcontracting prices for solar photovoltaic energy systems while also minimizing the time needed to create these price estimations. The need for improved precision, specifically during the early stages of a project, is examined and the paper also goes into detail about the components and pricing method that are incorporated into the excel tool. Lastly, the results of the price estimation tool are compared to real bids and recommendations are made for improvement to the tool.

Contributors

Agent

Created

Date Created
  • 2018-05

131437-Thumbnail Image.png

Collaborative Thesis: Software Monetization within the Internet of Things Group

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," 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.

Contributors

Agent

Created

Date Created
  • 2020-05

A Fortune 100 Technology Company Collaborative Thesis: Third-Party Services \u2014 Optimizing Headcount

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

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.

Contributors

Agent

Created

Date Created
  • 2014-05

134944-Thumbnail Image.png

Analysis of NRE Fees for American Airlines

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

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.

Contributors

Agent

Created

Date Created
  • 2016-12

134899-Thumbnail Image.png

Creating a Tool to Simplify and Automate the Vendor of Record Program for a Public Institution

Description

A public North American university needed a tool to automate their Vendor of Record rotation program. The goal was to give each vendor in the program fair opportunities and to

A public North American university needed a tool to automate their Vendor of Record rotation program. The goal was to give each vendor in the program fair opportunities and to be open and honest with how vendors were selected. This tool was created in Microsoft Excel with VBA to code macros. The three major Excel sheets are the Masters, the FM Interface, and the Executive Interface. The Masters act as a database and house data for each project. It is a plain Excel worksheet populated with tables. The FM Interface is a macro-enabled Excel workbook. It is distributed to every Facilities Manager in the program. The FM Interface communicates with the Masters in the background. The FMs use the various inputs and buttons to go through every step of procuring a project. They start by initializing a project, and are given a generated list of vendors who are qualified. This list is automatically rotated for every project. Then they fill in an RFQ and it is automatically emailed to the required vendors. When the Facilities Manager receives every quote, they input them into the program and they are saved to the database. When the project is complete, the manager must fill out a satisfaction survey to measure safety, cost, schedule, and quality of work. This is the main method of tracking vendor performance. The last sheet, the Executive Interface, is given only to the administrator of the program. It generates various reports, such as vendor performance, FM performance, and insurance status. It also has many administrative functions including insurance updating, vendor input, and delete project/vendor. The automated tool has been used without error on over 50 projects by 11 different Facilities Managers. The university's Facilities Management team is pleased with the automated process.

Contributors

Agent

Created

Date Created
  • 2016-12