A Brief Note On The USM Material Requirement Planning System

Submitted By saidineshk
Words: 8945
Pages: 36
Open Document
USM Material Requirement Planning System

ISYE582 Engineering Information Systems
Course Project Report 2
Spring 2013

Executive Summary

US Materials, Inc. (USM) is an American semiconductors manufacturing corporation, serving the semiconductor, liquid crystal display (LCD) devices, Glass and solar (crystalline and thin film) manufacturing industries. US Materials (USM) is the global leader in providing innovative equipment, services and software to the semiconductor, flat panel display and solar photovoltaic industries. USM has over a half million unique spare parts (each part has a unique part number) to be purchased from its vendors and stocked in inventories in order to carry out its manufacturing processes and support its customer requirements. USM has three main Central Distribution Centers (CDC), America, Europe and Asia. There are many depots and sub-depots under these distribution centers. CDCs are generally sourcing locations, because parts are procured at CDCs from external/internal vendors and then shipped to depots and then to sub depots. A supply chain management software called the i2 planning tool is used for demand planning and material requirement planning of USM spare parts. i2 planning is customized, maintained and owned by a third party company ABC.

ABC collects logics, rules, theories and data used by USM for planning purposes and includes them into i2 software. The supply chain planning team from USM will be coordinating and guiding the ABC team in building the logics into i2 software. The customization of i2 software for USM was done ten years ago. ABC refreshes the USM databases using i2 software on a weekly basis. i2 is linked to all USM oracle databases for static data and SAP tables for dynamic data. The outputs from the i2 refresh are various reports and database tables. Some important tables are the location-wise forecast and the shortage report for each spare part in the USM network. These reports and tables are used by USM in generating many other tables using MS-Access and Brio. These tables/reports are then used for various decision making activities like forecasting and inventory management of spare parts.

For effective material requirement planning, USM management has decided to streamline the data used for planning purposes. The project team came forward to take this task of building a new streamlined database for the procurement purpose of USM.

As a part of needs analysis, project team conducted interviews, gathered information from questionnaires. Project team also performed gap analysis between current and expected system. Based on the requirements, a process model was developed using DFDs, and a data model is developed using entity-relation diagrams. Obligatory and non-obligatory analysis was conducted and a final database was designed using MS-Access. Tables, forms, reports and queries were built in access.

Once final database is developed, it was thoroughly tested using test procedures for all the tables, forms, reports, queries and navigation menus. After continuous testing till no more errors were found, database was implemented.

1. Introduction
Material requirement planning (MRP) is intended to ensure materials are readily available to support production thereby ensuring on-time delivery of products to customers. MRP is simple for small and medium manufacturing companies, where product varieties manufactured by each company are fewer. However, there are many complications for a large scale manufacturing company with large product variety and with multiple manufacturing locations spread across the globe. The system is complicated even more when multiple vendors exist for a single product and customers are globally distributed. For such companies, the MRP system should collect demand and supply data for all the products from all the locations, calculate current inventory levels at all the
Show More

Related Documents: A Brief Note On The USM Material Requirement Planning System

Project Management and Software Engineering Essay

National University School of Engineering, Technology and Media CIS 420B - Information Systems Project II Lu Zhang, Ph. D. Associate Professor School of Engineering, Technology, and Media National University 3678 Aero Court San Diego, CA-92123 Phone: (858) 309 3429 Email: lzhang@nu.edu Office: KM 217 Course Description A precursor to the final IS/IT product development capstone course. Students research their area of interest and learn how to apply project management tools…

Words 1326 - Pages 6

The Pros And Cons Of Social Engineering

Social engineering has been looming as one biggest concern related to security personal information. Security doors, biometric scanners, policies, strong passwords, firewalls, defence in depth etc. all this security related controls are worthless against a skilled social engineering. Because social engineering target on the weakest link in the organization i.e. human. Social engineering requires a unique skill to get around security controls not by exploiting vulnerabilities in a system and hacking…

Words 728 - Pages 3

What Is Concurrent Engineering Essay

What is concurrent engineering? .... Concurrent engineering is all about introducing parallelism in to design process, manufacturing, quality and product development that emphasizes the response to customer expectations. By working in parallelism, product development can be accomplished more efficiently and at a substantial cost savings. How does this works, when a sequences are run parallel they introduce some concurrency in the system, for example, during the design process, evaluation of the design…

Words 622 - Pages 3

Essay On Computer Engineering

software, and information technology systems. Computer engineers use their background in computer science, electrical engineering, and mathematical analysis to design, develop, test, and evaluate various forms of computer technology. They must plan and produce computing devices that function both efficiently and economically. Computer engineers design and test hardware such as computer chips, keyboards, and circuit boards by combining physical and theoretical aspects of engineering and computer…

Words 615 - Pages 3

Domain Name System and Engineering Cmpe Essay

first guest speaker are on Feb. 16 – Next speaker will come from Intel security group. COMPUTER ENGINEERING CMPE 209 Dr.Park Why Do We Study Hacking? • What do we study hacking and penetration testing? • The malicious hackers have all the information they need to do all kinds of nasty things • Our focus is on defense – Must understand the offensive tools used by our adversaries COMPUTER ENGINEERING CMPE 209 Dr.Park The Threats from Outside • Threats coming from outside – Organized crime…

Words 4692 - Pages 19

2014 Cuttoff List ATAR Alevel IB OP Essay

LIKE YOU. WORLD CLASS, JUST LIKE YOU. WORLD CLASS, JUST LIKE YOU. WOR CLASS, JUST LIKE YOU. WORLD CLASS, JUST LIKE YOU. WORLD CLASS, JUST LI WORLD CLASS, JUST LIKE YOU. WORLD CLASS, JUST LIKE YOU. WORLD CLASS LIKE YOU. WORLD CLASS, JUST LIKE YOU. WORLD CLASS, JUST LIKE YOU. WOR CLASS, JUST LIKE YOU. WORLD CLASS, JUST LIKE YOU. WORLD CLASS, JUST LI WORLD CLASS, JUST LIKE YOU. WORLD CLASS, JUST LIKE YOU. WORLD CLASS LIKE YOU. WORLD CLASS, JUST LIKE YOU. WORLD CLASS, JUST LIKE YOU. WOR CLASS, JUST LIKE…

Words 8223 - Pages 33

Essay on Management of Quality Assignment 1 Nove

Adelanyu Sheriff Ladipo – 5966952 Ander Saez Sebastian – 5936623 Mohammed-Hassan Maidoki – 5148488 Salman Zafar – 6011749 M29EKM - Management of Quality Lecturer - Phil Lewis Lecture Assistant – Magda Rybak Quality Management System: Coventry University (Engineering and Computing Department) 7 November 2014 Summary ž Quality policy and objectives of our QMS ž Principles of our QMS ž Required documentation for our QMS ž Advantages of the implementation of our QMS ž Problems…

Words 863 - Pages 4

Structural Engineer Essay

Engineer Engineering is the career field that combines science and math to create, develop, design, test, and analyze solutions to problems critical to society’s needs. Engineers are among the most highly educated and best trained professionals in the world. Almost anything and everything man made was created by more than one subsection of engineering fields. One of the main engineering programs that is used to build structures and systems is structural engineering. Structural engineering dates back…

Words 776 - Pages 4

Electrical Engineering Research Paper

and Electronics Engineers) An electrical engineering program will usually include more mathematics and science than will technology and technician programs. The program may include electives in electronic design, communications, control and signal processing theory, solid state devices, integrated circuit design, radio-wave and optical communications systems, and power generation and distribution.(Institute of Electrical and Electronics Engineering) Engineering technology programs emphasize both technical…

Words 1978 - Pages 8

Essay on Doctor of Philosophy and Industrial Engineering

Industrial Engineering (MS) save Ira A. Fulton Schools of Engineering Location: Online, Tempe ESINDENMS Program Description Degree Awarded: MS Industrial Engineering The M.S. in industrial engineering degree program offers a thesis track and a non-thesis track. At the time of the admission, students' applications are considered primarily for the non-thesis track. After matriculating at Arizona State University, a student may consult and receive approval from the industrial engineering faculty…

Words 627 - Pages 3