Controlling System for Stock Raw Material for Production Planning and Inventory Control in a Pharmacy Company

Abstract

Master production schedule and material requirement planning are two important tasks for production planning and inventory control to monitor the stock of raw materials and finished goods. However, data used in master production schedule and material requirement planning come from various sources which have various types of data without good integration. This makes the forecasting of production planning and inventory control to provide raw materials for production not adequate. One of the applications for production planning and inventory control is EXACT. However, the application is operational-based. Thus, it cannot show the analysis of data. This paper proposes a data warehouse system that can provide a report for the production planning and inventory control system. By using a data warehouse, the necessary reports can be served quickly and flexibly in accordance with the needs of planning and inventory control system. Kimball Nine step is a method employed for designing a data warehouse, especially if each part is designed gradually. The development of data warehouse can give the report faster and more complete by accessing the dashboard. It also simplifies the process which occurs in the data retrieval of planning and inventory control system forecast.