Decision support system for inventory control of raw material (Case study: PT Suwarni Agro Mandiri Plant Pariaman, Indonesia)

PT Suwarni Agro Mandiri Plant Pariaman is a company which produces fertilizer. This company has a problem related to raw material inventory. The inventory can be overstock or stock out. It is due to their working which is not guided by an information system. Therefore, this research proposes a decision support system for controlling the inventory of the raw material. The system uses Material Requirement Planning (MRP) approach and is designed in three sub-systems. They are OLTP database for managing the daily activities, MRP for determining the lot size and the raw material ordering time, and OLAP with data warehouse for analyzing the raw material data.