Advancing PSA Maturity Level 4 Through a Web-Based PHP–MySQL Predictive Dashboard for Hospital Utilities and Medical Gases
Downloads
Public hospitals in Indonesia operate under the Public Service Agency (PSA/BLU) governance framework, which requires balanced clinical performance and financial accountability. Indicator 6.2 of the PSA Maturity Rating mandates the transition from fragmented manual reporting toward systematic and predictive digital monitoring to achieve Level 4 (“Predictable”) governance. However, many institutions continue to rely on retrospective reporting systems that impede transparency and data-driven decision-making. This study aims to develop and validate a web-based predictive dashboard to strengthen resource governance at Dr. M. Djamil Central General Hospital (RSUP Dr. M. Djamil Padang), Indonesia. The system integrates four critical resource streams electricity, water, fuel, and medical gases using a bounded Annual Growth Rate (±20%) model combined with a deviation-adjusted hybrid forecasting approach and a Sugeno-type Fuzzy Inference System for priority classification. A two-year longitudinal validation (2024–2025) was conducted using Mean Absolute Percentage Error (MAPE) and Root Mean Square Error (RMSE) metrics. The results demonstrate high predictive stability, with a weighted-average MAPE below 10%, and electricity forecasts classified as “Highly Accurate.” Water and Liquid O2 emerged as high-priority operational pressures, while other parameters remained within controlled growth thresholds. The proposed framework operationalizes Indicator 6.2 by institutionalizing a transparent and reproducible predictive monitoring mechanism. This study contributes a scalable digital governance prototype for emerging healthcare institutions seeking to advance toward Predictable maturity while strengthening risk-informed resource allocation.
[1] M. Bhatia et al., Access to Modern Energy Services for Health Facilities in Resource-Constrained Settings. [Online]. Available: www.who.int
[2] R. Alotaiby and É. Krenyácz, “Energy efficiency in healthcare institutions,” Society and Economy, vol. 45, no. 4, pp. 494–511, 2023, doi: https://doi.org/10.1556/204.2023.00013
[3] B. Supriadi, “Green Hospital Management and Survival to Age 65: Towards Sustainable Health,” Journal of Lifestyle and SDGs Review, vol. 5, no. 1, pp. 1–19, 2025, doi: https://doi.org/10.47172/2965-730X.SDGsReview.v5.n01.pe01771
[4] S. Lakjiri and M. Ouassaid, “Reclassifying hospital energy demand toward industry-like requirements for hygienic and resilient indoor environments,” Sci. Rep., vol. 16, no. 1, p. 3904, Jan. 2026, doi: https://doi.org/10.1038/s41598-025-33606-2.
[5] K. Bawaneh, F. G. Nezami, M. Rasheduzzaman, and B. Deken, “Energy consumption analysis and characterization of healthcare facilities in the United States,” Energies (Basel)., vol. 12, no. 19, pp. 2–20, 2019, doi: https://doi.org/10.3390/en12193775.
[6] A. T. Nugraha et al., “Optimization of Central Air Conditioning Plant by Scheduling the Chiller Ignition for Chiller Electrical Energy Management,” Indonesian Journal of Electronics, Electromedical, and Medical Informatics (IJEEEMI), vol. 3, no. 2, pp. 76–83, 2021, doi: https://doi.org/10.35882/ijeeemi.v3i2.7.
[7] C. Shen, K. Zhao, J. Ge, and Q. Zhou, “Analysis of building energy consumption in a hospital in the hot summer and cold winter area,” in Energy Procedia, Hong Kong: Elsevier Ltd, 2019, pp. 3735–3740. doi: https://doi.org/10.1016/j.egypro.2019.01.883.
[8] P. B. Padron and P. Zucchi, “Sustainable Consumption and Production in A Specialized Hospital Service,” Journal of Management and Sustainability, vol. 15, no. 2, pp. 1–12, Jul. 2025, doi: https://doi.org/10.5539/jms.v15n2p1.
[9] M. Chandy et al., “Water usage in a multi-speciality hospital and its effective management,” Journal of The Academy of Clinical Microbiologists, vol. 18, pp. 135–137, Aug. 2024, doi: https://doi.org/10.4103/0972-1282.194956.
[10] N. Dzikriyati, M. Raharjo, Nurjazuli, and J. H. Hashim, “Green Hospital Implementation in Dr. Cipto Mangunkusumo National Central Public Hospital,” Jurnal Presipitasi, vol. 21, no. 2, pp. 598–608, 2024, doi: https://doi.org/10.14710/presipitasi.v21i2.598-608.
[11] K. Taddonio, “Efficient Hospital Boilers Result in Financial, Environmental, and Safety Payoffs,” Washington DC, 2011. [Online]. Available: www.eere.energy.gov/informationcenter
[12] M. Carissa Putri, Y. Padma Devia, and L. Susanti, “Energy Audit For Energy Efficiency and Cost on Hospital Buildings,” ASTONJADRO, vol. 13, no. 1, 2024, doi: https://doi.org/10.32832/astonjadro.v13i1.
[13] N. K. Rosida, T. Rahmawati, and M. Nosike, “Monitoring the Stability of Oxygen Flow Analyzer on Oxygen Station in the Hospital,” Indonesian Journal of Electronics, Electromedical Engineering, and Medical Informatics, vol. 5, no. 1, pp. 52–58, 2023, doi: https://doi.org/10.35882/ijeeemi.v5i1.265.
[14] G. Avinash, H. Pachori, A. Sharma, and S. D. Mishra, “Time series forecasting of bed occupancy in mental health facilities in India using machine learning,” Sci. Rep., vol. 15, no. 1, Dec. 2025, doi: 10.1038/s41598-025-86418-9.
[15] A. Meliala et al., “Oxygen Systems in Indonesian Hospitals: Cross-Sectional Study and Strengthening Roadmap,” Policy & Governance Review, vol. 9, no. 3, pp. 382–401, 2025, doi: https://doi.org/10.30589/pgr.v9i3.1288.
[16] M. Bałys, E. Brodawka, A. Korzeniewska, J. Szczurowski, and K. Zarębska, “LCA and Economic Study on The Local Oxygen Supply in Central Europe during The Covid-19 Pandemic,” Science of the Total Environment, vol. 786, pp. 2–4, Sep. 2021, doi: https://doi.org/10.1016/j.scitotenv.2021.147401.
[17] T. Dj, “Green Hospitals: A Multidisciplinary Framework for Sustainable Healthcare Infrastructure,” International Journal Of Emerging Multidisciplinary Research And Innovation, vol. 1, no. 1, pp. 14–21, 2025, doi: https://doi.org/10.65180/ijemri.2025.1.1.03.
[18] P. Rajput, “Hospital Management System: A Comprehensive Web-Based Solution for Integrated Healthcare Operations,” Int. J. Adv. Res. Sci. Eng. Technol., vol. 13, no. 3, pp. 24676–24686, 2026, doi: https://doi.org/10.1049/icp.2025.1663.
[19] A. Fernando and Z. A. Fakrulloh, “Utilization of AI in Optimizing the Legislative Oversight Function Innovation to Increase Government Transparency and Accountability in the Digital Era,” International Journal of Social Service and Research, vol. 5, no. 6, pp. 547–555, 2025, doi: https://doi.org/10.46799/ijssr.v5i6.1253.
[20] M. M. A. Khan, Ahmed Mehmood Qureshi, and Tooba Zaheer, “Governance and Compliance in PIA: A Risk-Based Framework for Achieving Financial Sustainability,” International Journal Administration, Business & Organization, vol. 6, no. 3, pp. 66–84, Dec. 2025, doi: https://doi.org/10.61242/ijabo.25.576.
[21] M. A. Jalilvand, A. R. Raeisi, and N. Shaarbafchizadeh, “Hospital governance accountability structure: a scoping review,” BMC Health Serv. Res., vol. 24, no. 1, Dec. 2024, doi: https://doi.org/10.1186/s12913-023-10135-0.
[22] N. Lakhal, A. Aazami, and S. Kummer, “The role of artificial intelligence across the source-to-pay framework: Theoretical and practical aspects,” Digital Business, vol. 5, no. 2, Dec. 2025, doi: https://doi.org/10.1016/j.digbus.2025.100160.
[23] C. Suharinto, R. Semiarty, A. Agung Yulianto, R. Machmud, A. Nurdin, and D. Yulia, “Design of Screening for Congenital Hypothyroid Registration and Reporting Application Case Study: M. Djamil Hospital,” Jurnal Endurance : Kajian Ilmiah Problema Kesehatan, vol. 9, no. 3, pp. 385–397, 2024, doi: https://doi.org/10.22216/jen.v9i3.3130.
[24] R. R. Wilcox, Fundamentals of Modern Statistical Methods: Substantially Improving Power and Accuracy, 2nd ed., 2nd ed. Los Angeles: Springer, 2009. Accessed: Apr. 18, 2026. [Online]. Available: https://link.springer.com/book/10.1007/978-0-387-09608-9
[25] M. A. Hariyono, A. Marwanto, and S. Alifah, “A Fuzzy Logic Approach to Enhance GPS Accuracy for Blood Cooler Box Tracking,” Indonesian Journal of Electronics, Electromedical Engineering, and Medical Informatics, vol. 6, no. 1, pp. 52–58, 2024, doi: https://doi.org/10.35882/ijeeemi.v6i1.349.
[26] T. Takagi and M. Sugeno, “Fuzzy Identification of System and Its Applications to Modelling and Control,” IEEE Transaction on System And Cybernetics, vol. 5, no. 1, pp. 1–7, 1985, doi: 10.1109/TSMC.1985.6313399.
[27] S. Makridakis, S. C. Wheelwright, and R. J. Hyndman, Forecasting: Methods and Applications, Third Edition. New York: John Wiley & Sons, 1998. Accessed: Apr. 18, 2026. [Online]. Available: https://www.wiley.com/en-us/Forecasting%3A+Methods+and+Applications%2C+3rd+Edition-p-9780471532330
[28] T. Kawano, N. Wallbridge, and C. Plummer, “Logistic Models for Simulating the Growth of Plants by Defining the Maximum Plant Size as the Limit of Information Flow,” Plant Signal. Behav., vol. 15, no. 2, pp. 1–7, 2020, doi: https://doi.org/10.1080/15592324.2019.1709718.
[29] L. Kabareh and T. Mageto, “Estimation of Bounded Populations and Carrying Capacity with the Logistic Model,” Open J. Stat., vol. 07, no. 06, pp. 936–943, 2017, doi: https://doi.org/10.4236/ojs.2017.76065.
[30] A. de Myttenaere, B. Golden, B. Le Grand, and F. Rossi, “Mean Absolute Percentage Error for regression models,” Neurocomputing, vol. 192, pp. 38–48, Jun. 2016, doi: 10.1016/j.neucom.2015.12.114.
[31] T. O. Hodson, “Root-mean-square error (RMSE) or mean absolute error (MAE): when to use them or not,” Geosci. Model Dev., vol. 15, no. 14, pp. 5481–5487, Jul. 2022, doi: https://doi.org/10.5194/gmd-15-5481-2022.
[32] R. J. Hyndman, “WAPE: Weighted Absolute Percentage,” robjhyndman.com.
[33] L. A. Zadeh, “Fuzzy Sets,” Information and Control, vol. 8, pp. 338–353, 1965, doi: https://doi.org/10.1016/S0019-9958(65)90241-X.
[34] K. Lawrence and R. Klimberg, Advances in Business and Management Forecasting Vol 11, vol. 11. Bingley: EmeraldBooks, 2016. Accessed: Apr. 18, 2026. [Online]. Available: https://www.emerald.com/insight/publication/doi/10.1108/S1477-4070(2016)11
[35] M. M. Febrian, S. W. Saputro, T. H. Saragih, F. Abadi, and R. Herteno, “Hybrid Feature Selection and Balancing Data Approach for Improved Software Defect Prediction,” Indonesian Journal of Electronics, Electromedical Engineering, and Medical Informatics, vol. 7, no. 2, pp. 232–244, 2025.
[36] R. Miotto, F. Wang, S. Wang, X. Jiang, and J. T. Dudley, “Deep learning for healthcare: Review, opportunities and challenges,” Brief. Bioinform., vol. 19, no. 6, pp. 1236–1246, 2017.
[37] C. Pereira da Veiga, C. R. Pereira da Veiga, F. M. Girotto, D. A. B. Marconatto, and Z. Su, “Implementation of the ARIMA model for prediction of economic variables: evidence from the health sector in Brazil,” Humanit. Soc. Sci. Commun., vol. 11, no. 1, pp. 1–11, 2024.
[38] N. K. Dewangan et al., “A novel healthcare decision support system using IoT and ANFIS,” International Journal of Information Technology, vol. 16, no. 8, pp. 5421–5427, 2024, doi: https://doi.org/10.1007/s41870-024-02159-4
[39] F. Cavallaro, “A Takagi-Sugeno fuzzy inference system for developing a sustainability index of biomass,” Sustainability (Switzerland), vol. 7, no. 9, pp. 12359–12371, 2015, doi: https://doi.org/10.3390/su70912359.
[40] S. Al-Saqqa, S. Sawalha, and H. Abdelnabi, “Agile software development: Methodologies and trends,” International Journal of Interactive Mobile Technologies, vol. 14, no. 11, pp. 246–270, 2020, doi: https://doi.org/10.3991/ijim.v14i11.13269.
[41] N. F. Zakiuddin, S. M. Anggara, and Suhardi, “Developing Digital Service Transformation Maturity Model in Public Sector,” IEEE Access, vol. 12, pp. 174491–174506, 2024, doi: https://doi.org/10.1109/ACCESS.2024.3468341
[42] M. Samhouri and M. Abualeenein, “Fuzzy analytic hierarchy process prioritization of key performance indicators in IT service management,” International Journal of Quality & Reliability Management, vol. 43, no. 1, pp. 160–183, Jan. 2026, doi: https://doi.org/10.1108/IJQRM-12-2024-0463.
[43] J. Wątróbski, A. Bączkiewicz, and I. Rudawska, “A Strong Sustainability Paradigm based Analytical Hierarchy Process (SSP-AHP) method to evaluate sustainable healthcare systems,” Ecol. Indic., vol. 154, pp. 1–27, 2023, doi: https://doi.org/10.1016/j.ecolind.2023.110828
[44] T. Hari, W. Daamen, S. Hoogendoorn-Lanser, J. Steenbakkers, and S. P. Hoogendoorn, “Evaluation of Machine Learning and Deep Learning Models for Multi-Horizon Crowd Forecasting at Scheveningen Beach, The Netherlands,” Transp. Res. Rec., 2026, doi: 10.1177/03611981261422125.
[45] G. Alsheheri, “Time Series Forecasting in Healthcare: A Comparative Study of Statistical Models and Neural Networks,” Journal of Apllied Mathematics and Physics, vol. 13, no. 2, pp. 1–31, 2025, doi: https://doi.org/10.4236/jamp.2025.132035
[46] M. Shobanke, M. Bhatt, and E. Shittu, “Advancements and future outlook of Artificial Intelligence in energy and climate change modeling,” Advances in Applied Energy, vol. 17, pp. 1–32, Mar. 2025, doi: https://doi.org/10.1016/j.adapen.2025.100211.
[47] X. Cai, W. Li, W. Shi, Y. Cai, and J. Zhou, “Behavioral Dynamics of AI Trust and Health Care Delays Among Adults: Integrated Cross-Sectional Survey and Agent-Based Modeling Study,” J. Med. Internet Res., vol. 28, 2026, doi: https://doi.org/10.2196/82170.
[48] Y. F. Yang, H. Y. Chen, Y. H. Chen, S. P. Ho, C. S. Wang, and C. F. Lin, “Refining Environmental Sustainability Governance Reports through Fuzzy Systems Evaluation and Scoring,” Sustainability (Switzerland), vol. 16, no. 16, pp. 1–19, 2024, doi: https://doi.org/10.3390/su16167227
[49] S. Petanidis et al., “Optimizing Emergency Response in Hospitals: A Systematic Review of Surge Capacity Planning and Crisis Resource Management,” Nov. 01, 2025, Multidisciplinary Digital Publishing Institute (MDPI). doi: 10.3390/healthcare13212819.
[50] M. Shi, B. Rostami-Tabar, and D. Gartner, “Looking for the crystal ball in unscheduled care: a systematic literature review of the forecasting process,” Health Care Manag. Sci., vol. 28, no. 3, pp. 548–564, 2025, doi: https://doi.org/10.1007/s10729-025-09711-z
Copyright (c) 2026 Catur Suharinto (Author)
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlikel 4.0 International (CC BY-SA 4.0) that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).
