DESIGN OF A PROCUREMENT MANAGEMENT SYSTEM FOR THE CORPORATE EXCELLENCE STRATEGY OF PT. XYZ

Abstract

One factor that is often the center of expense expenditure by companies is material purchases.
The purchase involves several parties, namely the buyer and the seller or supplier of the
goods, and in practice the user is the party who requests or assigns the task to the provider for
certain goods. Therefore, to maintain the smooth supply of the company's raw materials,
every implementation of the company's activities will not be separated from the need for
procurement of goods and services. This study aims to design and build an application model
for aircraft parts procurement systems from the preparation of business processes, system
design and database design. The stages of the research will be carried out by formulating the
needs of information systems model for spare parts procurement in accordance with the
company's objectives and designing the model of spare parts procurement application
systems to support the improvement of aircraft components. The design phase is carried out
using a Data Flow Diagram (DFD) case tool and database design uses a relational database as
a storage medium for all transaction data. The results of mapping the attributes into a
relational table are designed with the concept data modeling and physical data modeling.