An Integrated Information System Model for Optimizing Bulk Water Distribution
DOI:
https://doi.org/10.35194/mji.v0i0.5762Keywords:
Integrated information system, Bulk water distribution, Model, Qualitative analysis, UMLAbstract
Many companies in the bulk water distribution sector still rely on manual recording systems, which often lead to scheduling conflicts, delivery inaccuracies, and inefficient payroll management. Recent studies highlight the need for integrated information systems to optimize logistics and operational efficiency in similar industries. This study aims to design and implement an integrated information system model to optimize the distribution of bulk water from suppliers to drinking water depots. The research adopts a qualitative approach, combining literature review, field observation, and in-depth interviews. System design follows the Waterfall model, with UML modeling and Black Box Testing for validation. The developed system successfully automates scheduling, generates delivery orders, recapitulates shipment data, and manages driver payroll. Empirical testing showed scheduling time was reduced from 45–60 minutes to 10–15 minutes (~75% faster), payroll reporting from 2–3 hours to under 30 minutes (~80% faster), and data recap from up to 2 hours to instant (~100% faster). All functions were validated through testing, showing no logical errors. The integrated information system model significantly improves the efficiency, accuracy, and effectiveness of bulk water distribution. Future research may incorporate mobile technology and GPS tracking for enhanced real-time monitoring.References
[1] A. Ezenwa, A. Whiteing, D. Johnson, and A. Oledinma, “Factors influencing information and communication technology diffusion in Nigeria’s transport logistics industry: An exploratory study,” International Journal of Integrated Supply Management, vol. 13, no. 2–3, 2020, doi: 10.1504/IJISM.2020.107846.
[2] S. Ahmed, “Supply chain planning for water distribution in Central Asia,” Industrial Management and Data Systems, vol. 109, no. 1, 2009, doi: 10.1108/02635570910926591.
[3] D. T. Dabar, K. Njoroge, and M. Oluoch, “Factors Influencing the Implementation of Logistics Management Information System: A Case Study of Garissa County,” Journal of African Interdisciplinary Studies, vol. 6, no. 9, pp. 51–62, 2022.
[4] C.-Y. Lin, “Factors affecting the innovation in logistics information systems for logistics service providers in Taiwan,” Journal of Information and Optimization Sciences, vol. 27, no. 3, 2006, doi: 10.1080/02522667.2006.10699715.
[5] L. Zhao, Z. Liu, and J. Mbachu, “An Integrated BIM–GIS Method for Planning of Water Distribution System,” ISPRS Int J Geoinf, vol. 8, no. 8, 2019, doi: 10.3390/ijgi8080331.
[6] J. Wang, “Design of intelligent water transport logistics management system based on cloud computing,” Desalination Water Treat, vol. 314, 2023, doi: 10.5004/dwt.2023.30052.
[7] N. B. JADAMBA, “LOGISTICS INFORMATION SYSTEMS AND PERFORMANCE OF INTERNATIONAL HUMANITARIAN ORGANIZATIONS IN KENYA BY NDEDA BERNADETTE JADAMBA A RESEARCH PROJECT SUBMITTED IN PARTIAL FULFILMENT OF THE REQUIREMENTS OF THE AWARD OF THE DEGREE OF MASTER OF BUSINESS ADMINISTRATION,” 2014.
[8] I. E. Karadirek, E. Kaya-Basar, and T. Akdeniz, “A study on pipe failure analysis in water distribution systems using logistic regression,” Water Supply, vol. 24, no. 1, 2024, doi: 10.2166/ws.2023.335.
[9] B. M. Mutugi, “FACTORS INFLUENCING THE EFFECTIVENESS OF LOGISTICS MANAGEMENT INFORMATION SYSTEMS IN PUBLIC HEALTH SECTOR: A CASE STUDY OF KENYA MEDICAL SUPPLIES AUTHORITY A RESEARCH PROJECT SUBMITTED IN PARTIAL FULLFILLMENT OF THE REQUIREMENT FOR AWARD OF THE DEGREE OF MASTERS OF,” Oct. 2014.
[10] M. Rajabzadeh and H. Fatorachian, “Modelling Factors Influencing IoT Adoption: With a Focus on Agricultural Logistics Operations,” 2023. doi: 10.3390/smartcities6060145.
[11] L. Wang, “Third-Party Logistics Development in China,” in Contemporary Logistics in China: Collaboration and Reciprocation, Springer, 2018, pp. 71–93.
[12] P. Y. K. Chau and K. Y. Tam, “Factors affecting the adoption of open systems: An exploratory study,” MIS Q, vol. 21, no. 1, 1997, doi: 10.2307/249740.
[13] I. Piot-Lepetit, “Editorial: Strategies of digitalization and sustainability in agrifood value chains,” 2025, Frontiers Media SA. doi: 10.3389/fsufs.2025.1565662.
[14] H. Woo, M. Acuna, M. Moroni, M. S. Taskhiri, and P. Turner, “Optimizing the location of biomass energy facilities by integrating Multi-Criteria Analysis (MCA) and Geographical Information Systems (GIS),” Forests, vol. 9, no. 10, 2018, doi: 10.3390/f9100585.
[15] C. C. Yang and C. S. Lu, “Factors influencing the use intention of port logistics information system by ocean carriers,” International Journal of Shipping and Transport Logistics, vol. 4, no. 1, 2012, doi: 10.1504/IJSTL.2012.044134.
[16] S. S. Abdullah and M. R. Muzakki, “Pembuatan Media Pembelajaran Interaktif Ilmu Shorof untuk Peningkatan Minat Belajar,” Media Jurnal Informatika, vol. 15, no. 2, pp. 149–155, 2023.
[17] J. A. Rojas-García, C. Elias-Giordano, S. Nallusamy, and J. C. Quiroz-Flores, “Enhancement of the distribution process on light logistics SMEs in times post-pandemic Covid-19 with Ukraine-Russia conflict by lean logistics and big data,” Social Sciences and Humanities Open, vol. 10, Jan. 2024, doi: 10.1016/j.ssaho.2024.100945.
[18] T. Yuwono, A. Suroso, and W. Novandari, “Information and communication technology in SMEs: a systematic literature review,” Dec. 01, 2024, Springer Science and Business Media Deutschland GmbH. doi: 10.1186/s13731-024-00392-6.
[2] S. Ahmed, “Supply chain planning for water distribution in Central Asia,” Industrial Management and Data Systems, vol. 109, no. 1, 2009, doi: 10.1108/02635570910926591.
[3] D. T. Dabar, K. Njoroge, and M. Oluoch, “Factors Influencing the Implementation of Logistics Management Information System: A Case Study of Garissa County,” Journal of African Interdisciplinary Studies, vol. 6, no. 9, pp. 51–62, 2022.
[4] C.-Y. Lin, “Factors affecting the innovation in logistics information systems for logistics service providers in Taiwan,” Journal of Information and Optimization Sciences, vol. 27, no. 3, 2006, doi: 10.1080/02522667.2006.10699715.
[5] L. Zhao, Z. Liu, and J. Mbachu, “An Integrated BIM–GIS Method for Planning of Water Distribution System,” ISPRS Int J Geoinf, vol. 8, no. 8, 2019, doi: 10.3390/ijgi8080331.
[6] J. Wang, “Design of intelligent water transport logistics management system based on cloud computing,” Desalination Water Treat, vol. 314, 2023, doi: 10.5004/dwt.2023.30052.
[7] N. B. JADAMBA, “LOGISTICS INFORMATION SYSTEMS AND PERFORMANCE OF INTERNATIONAL HUMANITARIAN ORGANIZATIONS IN KENYA BY NDEDA BERNADETTE JADAMBA A RESEARCH PROJECT SUBMITTED IN PARTIAL FULFILMENT OF THE REQUIREMENTS OF THE AWARD OF THE DEGREE OF MASTER OF BUSINESS ADMINISTRATION,” 2014.
[8] I. E. Karadirek, E. Kaya-Basar, and T. Akdeniz, “A study on pipe failure analysis in water distribution systems using logistic regression,” Water Supply, vol. 24, no. 1, 2024, doi: 10.2166/ws.2023.335.
[9] B. M. Mutugi, “FACTORS INFLUENCING THE EFFECTIVENESS OF LOGISTICS MANAGEMENT INFORMATION SYSTEMS IN PUBLIC HEALTH SECTOR: A CASE STUDY OF KENYA MEDICAL SUPPLIES AUTHORITY A RESEARCH PROJECT SUBMITTED IN PARTIAL FULLFILLMENT OF THE REQUIREMENT FOR AWARD OF THE DEGREE OF MASTERS OF,” Oct. 2014.
[10] M. Rajabzadeh and H. Fatorachian, “Modelling Factors Influencing IoT Adoption: With a Focus on Agricultural Logistics Operations,” 2023. doi: 10.3390/smartcities6060145.
[11] L. Wang, “Third-Party Logistics Development in China,” in Contemporary Logistics in China: Collaboration and Reciprocation, Springer, 2018, pp. 71–93.
[12] P. Y. K. Chau and K. Y. Tam, “Factors affecting the adoption of open systems: An exploratory study,” MIS Q, vol. 21, no. 1, 1997, doi: 10.2307/249740.
[13] I. Piot-Lepetit, “Editorial: Strategies of digitalization and sustainability in agrifood value chains,” 2025, Frontiers Media SA. doi: 10.3389/fsufs.2025.1565662.
[14] H. Woo, M. Acuna, M. Moroni, M. S. Taskhiri, and P. Turner, “Optimizing the location of biomass energy facilities by integrating Multi-Criteria Analysis (MCA) and Geographical Information Systems (GIS),” Forests, vol. 9, no. 10, 2018, doi: 10.3390/f9100585.
[15] C. C. Yang and C. S. Lu, “Factors influencing the use intention of port logistics information system by ocean carriers,” International Journal of Shipping and Transport Logistics, vol. 4, no. 1, 2012, doi: 10.1504/IJSTL.2012.044134.
[16] S. S. Abdullah and M. R. Muzakki, “Pembuatan Media Pembelajaran Interaktif Ilmu Shorof untuk Peningkatan Minat Belajar,” Media Jurnal Informatika, vol. 15, no. 2, pp. 149–155, 2023.
[17] J. A. Rojas-García, C. Elias-Giordano, S. Nallusamy, and J. C. Quiroz-Flores, “Enhancement of the distribution process on light logistics SMEs in times post-pandemic Covid-19 with Ukraine-Russia conflict by lean logistics and big data,” Social Sciences and Humanities Open, vol. 10, Jan. 2024, doi: 10.1016/j.ssaho.2024.100945.
[18] T. Yuwono, A. Suroso, and W. Novandari, “Information and communication technology in SMEs: a systematic literature review,” Dec. 01, 2024, Springer Science and Business Media Deutschland GmbH. doi: 10.1186/s13731-024-00392-6.
Downloads
Additional Files
Published
2025-09-30
