Developing A Web Based OEE Monitoring System for Pharmaceutical Industry

Authors

  • Hery Hamdi Azwir
  • Kevin Desmalilo President University
  • Herwan Yusmira President University

DOI:

https://doi.org/10.33021/jie.v11i01.68

Keywords:

Overall Equipment Effectiveness (OEE), Pharmaceutical Industry, Web-Based Application, Production Efficiency, Object-Oriented Programming, Object Oriented System Design

Abstract

PT. XYZ is a leading biopharmaceutical company in Indonesia that produces and sells health products. A critical aspect of its operations is calculating Overall Equipment Effectiveness (OEE) to ensure optimal production and minimize downtime. Currently, XYZ conducts OEE calculations manually, leading to significant challenges. Manual data collection and processing are time-consuming, taking up to a week to complete. This delay hinders timely decision-making and increases the risk of errors, including miscalculations and inaccuracies in data analysis. Such inefficiencies negatively impact production planning and resource utilization. To address this problem, this research proposes the development of a web-based application to automate the OEE calculation process. Using the Object-Oriented System Design (OOSD) approach and Object-Oriented Programming (OOP) methodology, the application streamlines OEE data input, automates the calculation of Availability, Performance, and Quality components, and presents results through interactive visualizations. By transitioning from a manual to an automated system, the new application significantly reduces the time required for OEE calculations, providing users with fast and accurate results to support better operational decisions.

References

Alter, S. (2013). Defining information systems as work systems: implications for the IS field. European Journal of Information Systems, 17(5), 448–469. https://doi.org/10.1057/ejis.2008.37

Booch, G., Maksimchuk, R. A., Engle, M. W., Young, B. J., Connallen, J., & Houston, K. A. (2009). Object oriented analysis and design with applications 3RD Edition.

Cosmas, N. I. (2018). Transitions in system analysis and design methodology. American Journal of Information Science and Technology, 2(2), 50. https://doi.org/10.11648/j.ajist.20180202.14

D. Heller, "HTML and Web Development," [W3Schools], 2022. [Online]. Available: https://www.w3schools.com/html/

Duckett, J. (2014). HTML and CSS: Design and build websites. In Wiley Publishing eBooks.

Laudon, K. C., & Laudon, J. P. (1988). Management Information Systems: Managing the digital firm.

Learning web design: a beginner’s guide to HTML, CSS, Javascript, and web graphics. (2013). Choice Reviews Online, 50(12), 50–6805. https://doi.org/10.5860/choice.50-6805

Pressman, R., & India, M. G. H. (2009). Software Engineering: A Practitioner’s Approach, 7Th Edition.

Rankin, K., & Hill, B. M. (2017). The official Ubuntu Server Book.

Schwartz, B., Zaitsev, P., & Tkachenko, V. (2012). High performance MySQL.

Stevens, N. J., Salmon, P. M., Walker, G. H., & Stanton, N. A. (2018). Systems analysis and design methods. In CRC Press eBooks (pp. 291–332). https://doi.org/10.1201/9781315587363-10

Turban, E., Volonino, L., Sipior, J. C., & Wood, G. R. (2011). Information Technology for Management: Improving strategic and operational performance. http://ci.nii.ac.jp/ncid/BB05018219

Stalling, W. (2018). Operating Systems: Internals and Design Principles / William Stallings. Operating Systems: Internals and Design Principles Seventh Edition, 2001(2001), 1–99.

Haselmann, T., & Vossen, G. (2011). Software-as-a-Service in Small and Medium Enterprises: An Empirical Attitude assessment. In Lecture notes in computer science (pp. 43–56). https://doi.org/10.1007/978-3-642-24434-6_4

Marz, N., & Warren, J. (2015). Big Data: Principles and best practices of scalable realtime data systems.

Hacigümüş, H., Iyer, B., Li, C., & Mehrotra, S. (2002). Executing SQL over encrypted data in the database-service-provider model. Executing SQL Over Encrypted Data in the DatabaseServiceProvider Model. https://doi.org/10.1145/564691.564717

Connolly, T. M., & Begg, C. E. (2015). Database Systems: A Practical approach to design, implementation and management.

Elmasri, R. A., & Navathe, S. B. (2016). Fundamentals of database Systems.

Sobell, M. G. (2013). A practical guide to Linux commands, editors, and Shell programming.

Negus, C. (2005). Linux Bible.

Downloads

Published

20-04-2026