DEVELOPING A DATA VISUALIZATION DASHBOARD FOR DECISION SUPPORT IN MULTI-BRANCH SHOP ORDERING: A CASE STUDY OF A DRUGSTORE IN PHITSANULOK, THAILAND
คำสำคัญ:
Business intelligent, Dashboard, Decision making, Inventory, Procurementบทคัดย่อ
Managing inventory efficiently across multiple branches poses significant challenges, particularly in the drugstore industry. This paper explored these challenges through a case study of drugstores in Phitsanulok, Thailand, which operate under a central ordering system yet struggle with discrepancies between ordered and received inventory due to a lack of visibility across branches. To address these inefficiencies, we proposed a data visualization dashboard designed to support inventory decisions and enhanced inventory management by providing updated inventory data for all branches. This study introduced a conceptual framework for the dashboard, analyzing current ordering processes, identifying key challenges, and suggesting system improvements. Our findings suggest that implementing such a dashboard can significantly improve decision-making and operational efficiency, serving as a model for similar multi-branch businesses.
References
Aisbett, J., Lasch, R., & Pires, G. D. (2005). A decision-making framework for adoption of e-procurement. International Journal of Integrated Supply Management, 1, 278-293.
Axsäter, S. (2015). Multi-Echelon Systems: Structures and Ordering Policies. International Series in Operations Research & Management Science, 187-219
Chapparadalli, N.L. (2019). Designing a dashboard to support the decision process of dynamic pricing. (Business Information Technology MSc). University of Twente, Netherlands
Cheng, J.C., & Chou, C.Y. (2008). A real-time inventory decision system using Western Electric run rules and ARMA control chart. Expert Syst, 35, 755-761.
Jian-fang, Z. (2008). Schedule-based Real Time Inventory Possessing. Journal of Wuhan Polytechnic University.
Liu, Y., & Chen, X. (2022, October). Application of Big Data Analysis Based on Power BI in Sales Forecasts. Proceedings of the 5th International Conference on Computer Science and Software Engineering, Guilin, China.
Moynihan, G. P., Saxena, P., & Fonseca, D. J. (2006). Development of a decision support system for procurement operations. International Journal of Logistics Systems and Management, 2, 1.
Parks, M. (2014). Microsoft Business Intelligence. POWER BI.
Ridho, M., Gutandjala, I.I., Windart, A.T., & Pransandy, T. (2023, June). Business Intelligence Dashboard for Asset Inventory Management Monitoring at PT Indonesia Power Head Office. 2023 8th International Conference on Business and Industrial Research (ICBIR), Bangkok, Thailand.
Shinde, S.S., Karadkhele, G., Lohakare, P., & Vaidya, V. (2023). Live Inventory Tracking System Using IOT. International Journal for Research in Applied Science and Engineering Technology, 11(5), 7161-7166.
Singh, V.V., Singh, H., & Singh, S. (2015). Drug Inventory Management of A Pharmacy Store by Combined Abc-Ved Analysis. International Journal on Mechanical Engineering and Robotics (IJMER), 3, 19-22.
Vlahakis, G., Kopanaki, E., & Apostolou, D. (2020). Proactive decision making in supply chain procurement. Journal of Organizational Computing and Electronic Commerce, 30, 28 - 50.
Xu, P. J., Allgor, R. J., & Graves, S. C. (2009). Benefits of Reevaluating Real-Time Order Fulfillment Decisions. Manufacturing & Service Operations Management, 11, 340-355.
