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

Abba Suganda Girsang; Andhika Purwanto

doi:10.15866/ireme.v11i11.12330

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

Abba Suganda Girsang^(1*), Andhika Purwanto⁽²⁾

^(*) Corresponding author

Authors' affiliations

DOI: https://doi.org/10.15866/ireme.v11i11.12330

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.
Copyright © 2017 Praise Worthy Prize - All rights reserved.

Keywords

Data Warehouse; Stock; Raw Material; Finish Goods; Production Planning and Inventory Control

Full Text:

PDF

References

Rudy, & Miranda, E. (2015). Management Report for Marketing in Higher Education Based On Data Warehouse and Data Mining. International Journal of Multimedia and Ubiquitous Engineering, 10(4), 291–302.
http://dx.doi.org/10.14257/ijmue.2015.10.4.28

G. Satyanarayana Reddy et. al., "Data Warehousing, Data Mining, OLAP, and OLTP Technologies Are Essential Elements to Support Decision Making Process In Industries," (IJCSE) International Journal on Computer Science and Engineering, Vol. 02, No. 09, 2010, pp. 2865-2873.

C. Khnaisser, L. Lavoie, H. Diab, and J.-F. Ethier, “Data warehouse design methods review: Trends, challenges and future directions for the healthcare domain,” Commun. Comput. Inf. Sci., vol. 539, pp. 76–87, 2015.
http://dx.doi.org/10.1007/978-3-319-23201-0_10

N. Arfaoui and J. Akaichi, “Automating schema integration technique case study: generating data warehouse schema from data mart schemas,” in International Conference: Beyond Databases, Architectures and Structures, 2015, pp. 200–209.
http://dx.doi.org/10.1007/978-3-319-18422-7_18

G. V. Heck, "Introduction a Framework to Assess Operational Perfomance," 27 November 2009.

M. Breslin, "Data Warehousing Battle of the giants - Comparing the Basics of the Kimball and Inmon," DW Models, 2004.

W. Inmon, Building the Data Warehouse - Third Edition, R. Elliott, Ed., Robert Ipsen, 2002.

Girsang, A., Prakoso, C., Data Warehouse Development for Customer WIFI Access Service at a Telecommunication Company, (2017) International Journal on Communications Antenna and Propagation (IRECAP), 7 (2), pp. 114-124.
http://dx.doi.org/10.15866/irecap.v7i2.11736

M. R. Ralph Kimball, The Data Warehouse Toolkit, 2nd Edition ed., R. Elliott, Ed., New York: Wiley Computer Publishing, 2002.

M. Sethi, "Data Warehousing and OLAP Technology," International Journal of Engineering Research and Applications (IJERA), vol. 2, no. 2, pp. 955-960, March 2012.
http://dx.doi.org/10.1145/2390045

B. Moustaid and M. Fakir, “Implementation of Business Intelligence For Sales Management,” IAES Int. J. Artif. Intell., vol. 4, no. 1, 2016.
http://dx.doi.org/10.11591/ij-ai.v2i1.1236

P. Mukala and V. Der Walt, “On Information Overload Subjugation: Proposing an Intelligent Data Warehouse (IDW) Model,” Int. J. Inf. Netw. Secur., vol. 2, no. 5, p. 371, 2013.
http://dx.doi.org/10.11591/ijins.v2i5.3850

DR. Kamal Kakish, "ETL Evolution For Real-Time Data Warehouse," Proceedings of the Conference on Information Systems Applied Research, vol. 5, 2012.

Shaker H. Ali El-Sappagh, Abdeltawab M. Ahmed Hendawi, Ali Hamed El Bastawissy, A proposed model for data warehouse ETL processes, Journal of King Saud University - Computer and Information Sciences, Volume 23, Issue 2, 2011, Pages 91-104.
http://dx.doi.org/10.1016/j.jksuci.2011.05.005

Nur Hani Zulkifli Abai, Jamaiah H. Yahaya, Aziz Deraman, User Requirement Analysis in Data Warehouse Design: A Review, Procedia Technology, Volume 11, 2013, Pages 801-806.
http://dx.doi.org/10.1016/j.protcy.2013.12.261

Kimball Group, Kimbal Dimensional Modeling Techniques, Kimball Group, 2013.

M. R. Ralph Kimbal, The Data Warehouse Toolkit, vol. III, John Wiley & Sons, Inc., 2013.

Q. Sun and Q. Xu, “Research on Collaborative Mechanism of data Warehouse in Sharing Platform,” Indones. J. Electr. Eng. Comput. Sci., vol. 12, no. 2, pp. 1100–1108, 2014.

Refbacks

There are currently no refbacks.

Username
Password
Remember me