Development of Intelligent Decision Support System Based on Quadrant Analysis, Time Series Trend Analysis, and Automatic Planogram Generation for Vending Machine Product Optimization
DOI:
https://doi.org/10.35870/ijmsit.v6i2.8277Keywords:
Decision Support System, Business Analytics, Quadrant Analysis, Time Series Trend Analysis, Automatic Planogram, Vending MachineAbstract
Product management in a vending machine business requires fast and data-driven decision-making to increase sales effectiveness and profitability. However, decision-making related to price adjustments, product bundling, product replacements, and product arrangement on vending racks is still mostly done manually based on the manager's experience, so it has the potential to produce less than optimal decisions. This research aims to develop an Intelligent Decision Support System that is able to produce business strategy recommendations through the integration of Quadrant Analysis, Time Series Trend Analysis, and Automatic Planogram Generation. The research data was obtained from the results of exporting the vending machine transaction database imported into the application in CSV or Excel format, so that the system does not depend on direct integration with the Application Programming Interface (API). Quadrant Analysis is used to group products based on sales performance and profit contribution, while Time Series Trend Analysis is used to evaluate historical sales trends as a support for decision validation, rather than as a sales prediction method. The results of the second analysis were processed using a rule-based decision engine mechanism to produce recommendations in the form of price adjustments, product bundling, maintaining or replacing products, and compiling an automatic planogram based on product performance priorities. The resulting planogram can still be adjusted manually by the user so that it still provides flexibility in operational decision-making. In addition, the system presents profit analysis based on product, machine, and location as the basis for business evaluation. The resulting artifacts are in the form of a decision support system application that not only presents data visualization, but also automatically generates strategic recommendations to help managers improve the effectiveness of product management in the vending machine business.
Downloads
References
Ahmed, M. S. (2022). Study on Data Warehousing Applications: An Analytical Tool for Decision Support System. Recent Advances in Mathematical Research and Computer Science Vol. 8, Book Publisher International (a part of SCIENCEDOMAIN International), 45-54, 2022, https://dx.doi.org/10.9734/bpi/ramrcs/v8/2400C
Awamleh, F. T., Bustami, A., Alarabiat, Y., & Sultan, A. (2024). Data-driven decision-making under uncertainty: Investigating OLAP's mediating role to leverage business intelligence analytics for entrepreneurship. Journal of Systems and Great Sciences, 14, 523–1818. https://doi.org/10.33168/jsms.2024.0822
Changlin, H., & Yufen, L. (2017). A survey of intelligent decision support system. In 2017 7th International Conference on Applied Science, Engineering and Technology (ICASET 2017) (pp. 201-206). Atlantis Press. https://doi.org/10.2991/icaset-17.2017.38
Czerniachowska, K., Lutosławski, K., & Fojcik, M. (2022). Heuristics for shelf space allocation problem with vertical and horizontal product categorization. Procedia Computer Science, 207, 195–204. https://doi.org/10.1016/j.procs.2022.09.052
Grzybowska, H., Kerferd, B., Gretton, C., & Waller, S. T. (2020). A simulation-optimisation genetic algorithm approach to product allocation in vending machine systems. Expert Systems with Applications, 145, 113110. https://doi.org/10.1016/j.eswa.2019.113110
Hermanto, E. A., Gemintang, S. A., Ariansyah, R., & Giovanny, M. A. (2023). Analisis Perbandingan Penerapan Business Intelligence di Indonesia Menggunakan Metode Systematic Literature Review. Jurnal Teknologi Informasi, 4(2), 345-354. https://doi.org/10.46576/djtechno.v4i2.3412
Hilmi, N. F., Abdillah, A. R., Maulana, P. S., & Prakoso, M. S. B. (2024). The application of business intelligence to vending machine sales in Central New Jersey USA using Tableau. J-Intech (Journal of Information and Technology), 12(1), 148–157. https://doi.org/10.32664/j-intech.v12i1.1275
Laudon, K. C., & Laudon, J. P. (2004). Management information systems: Managing the digital firm. Pearson Education.
Li, X., Shen, Q., & Yang, T. (2024). Design and optimization of multidimensional data models for enhanced OLAP query performance and data analysis. Applied and Computational Engineering, 69(1), 161–166. https://doi.org/10.54254/2755-2721/69/20241503
Lin, F.-C., Yu, H.-W., Hsu, C.-H., & Weng, T.-C. (2011). Recommendation system for localized products in vending machines. Expert Systems with Applications, 38(8), 9129–9138. https://doi.org/10.1016/j.eswa.2011.01.051
Lucas, J. M., & Saccucci, M. S. (1990). Exponentially Weighted Moving Average Control Schemes: Properties and Enhancements. Technometrics, 32(1), 1–12. https://doi.org/10.1080/00401706.1990.10484583
Marinelli, L., Fiano, F., Gregori, G. L., & Daniele, L. M. (2021). Food purchasing behaviour at automatic vending machines: The role of planograms and shopping time. British Food Journal, 123(5), 1821–1836. https://doi.org/10.1108/BFJ-02-2020-0107
Mehmood, U., Bashir, A. K., Rabie, K., Broderick, J., & Davies, S. (2023). Vending machine product demand prediction using machine learning algorithms. In Proceedings of the IEEE International Symposium on Networks, Computers and Communications (ISNCC) (pp. 1–6). IEEE.
Nemoto, G. (2025). Research on decision-making methods under uncertain information: Assortment optimization for vending machines (Doctoral dissertation). Japan Advanced Institute of Science and Technology.
Ohanjanian, D., & Varahram, S. (2026). Data-driven decision support system for vending machine planograms using machine learning and heuristic algorithms (Master's thesis). Uppsala University.
Pagidoju, R. T., & Agarwal, S. (2026). Cloud-native generative AI for automated planogram synthesis: A diffusion model approach for multi-store retail optimization (arXiv Preprint No. arXiv:2601.00527).
Perfetti, A., Pietrini, R., Scarpi, D., & Gistri, G. (2025). Snack dilemma: how vending machines influence choice of virtue and vice foods. Journal of Retailing and Consumer Services, 87, 104369. https://doi.org/10.1016/j.jretconser.2025.104369
Power, D. J., & Heavin, C. (2017). Decision support, analytics, and business intelligence. Business Expert Press.
Sharma, A. (2026). Intelligent vending machines market size, share & trends analysis report by machine type, by product type, by application and by region forecasts, 2026–2034. Straits Research.
Vella, H. (2026). How your retail planogram benefits from automation and new technology. Verizon Business Resources.
Wiratama, J., & Bagioyuwono, M. A. (2023). Improving the data management: ETL implementation on data warehouse at Indonesian vehicle insurance industry. International Journal of Science, Technology and Great, 4(5), 1256–1268. https://doi.org/10.46729/ijstm.v4i5.936
Downloads
Published
Issue
Section
License
Copyright (c) 2026 Rizaldi Putra, Syaban Maulana, Tessalonika Audry Polnaya, Muhammad Zaky Fahriansyah
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
1. Copyright Retention and Open Access License
Authors retain copyright of their work and grant the journal non-exclusive right of first publication under the Creative Commons Attribution 4.0 International License (CC BY 4.0).
This license allows unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
2. Rights Granted Under CC BY 4.0
Under this license, readers are free to:
- Share — copy and redistribute the material in any medium or format
- Adapt — remix, transform, and build upon the material for any purpose, including commercial use
- No additional restrictions — the licensor cannot revoke these freedoms as long as license terms are followed
3. Attribution Requirements
All uses must include:
- Proper citation of the original work
- Link to the Creative Commons license
- Indication if changes were made to the original work
- No suggestion that the licensor endorses the user or their use
4. Additional Distribution Rights
Authors may:
- Deposit the published version in institutional repositories
- Share through academic social networks
- Include in books, monographs, or other publications
- Post on personal or institutional websites
Requirement: All additional distributions must maintain the CC BY 4.0 license and proper attribution.
5. Self-Archiving and Pre-Print Sharing
Authors are encouraged to:
- Share pre-prints and post-prints online
- Deposit in subject-specific repositories (e.g., arXiv, bioRxiv)
- Engage in scholarly communication throughout the publication process
6. Open Access Commitment
This journal provides immediate open access to all content, supporting the global exchange of knowledge without financial, legal, or technical barriers.
