Developing a Web Based Sales Monitoring and Forecasting System for Digital Transformation of Rural MSMEs

Murahartawaty Arief; Zalina Fatimah  Azzahra; Haryasena  Panduwiyasa; Lijona Lijona; Stefanus Arda  Sawardi; Reza Herdianto  Pratama

doi:10.55382/jurnalpustakarobotsister.v4i2.2063

Authors

Murahartawaty Arief Telkom University
Zalina Fatimah Azzahra Telkom University
Haryasena Panduwiyasa Telkom University
Lijona Lijona Telkom University
Stefanus Arda Sawardi Telkom University
Reza Herdianto Pratama Telkom University

DOI:

https://doi.org/10.55382/jurnalpustakarobotsister.v4i2.2063

Keywords:

web, simple linier regression, design thinking, prototype, digital transformation, MSMEs

Abstract

Micro, Small, and Medium Enterprises (MSMEs) in Indonesia face significant hurdles in digital adoption, with only 30% to 32% currently utilizing digital management tools. To address this challenge, this research focuses on Dapur Ovaltin, an agribusiness MSMEs in Ciwidey, West Java, that previously relied entirely on manual sales recording. The primary objective of this study is to design and implement a web-based monitoring and forecasting system to enhance operational efficiency. Developed through a hybrid framework integrating Design Thinking and the Prototyping SDLC, the resulting application streamlines sales management and applies Simple Linear Regression to transactional data for precise inventory forecasting. This implementation yielded a comprehensive platform featuring digital product catalogs, transaction management, and interactive data visualization. Ultimately, the deployed system successfully transformed manual operations into a cohesive digital process, replacing fragmented logs with a centralized database that empowers data-driven decision-making for sustainable enterprise growth.

Downloads

Download data is not yet available.

References

K. Koesrianti and J. Tanega, “A Review of the Indonesian Regulatory Policy on MSMEs and Cooperatives for Boosting Economic Potential towards the Industrial Revolution 4.0,” Padjadjaran Jurnal Ilmu Hukum, vol. 11, no. 3, pp. 434–458, 2024, doi: 10.22304/pjih.v11n3.a6.

W. L. Chin and S. F. Pehin Dato Musa, “Agritourism resilience against Covid-19: Impacts and management strategies,” Cogent Soc. Sci., vol. 7, no. 1, 2021, doi: 10.1080/23311886.2021.1950290.

S. Retnaning Sampurnaningsih, Rachmawaty, U. Rosilawati, and B. Aroman, “Strengthening Local Economy Resilience: Business Model Innovation based on Digital for Date Palm Agribusiness in Ayuthayya Thailand,” Indonesian Journal of Society Engagement), vol. 6, no. 3, pp. 292–316, Dec. 2025, doi: 10.33753/ijse.v6i3.269.

A. Kosasih and E. Sulaiman, “Digital transformation in rural settings: Unlocking opportunities for sustainable economic growth and community empowerment,” Journal of Sustainable Tourism and Entrepreneurship, vol. 5, no. 2, pp. 129–143, Jul. 2024, doi: 10.35912/joste.v5i2.2278.

Muh Barid Nizarudin Wajdi, Rangga Sa’adillah S.A.P, Lely Ana Ferawati Ekaningsih, Hasan Syaiful Rizal, and Amang Fathurrohman, “Asset-Based Community Development: Leveraging Local Strengths for Empowering Communities?: A Bibliographic Analysis,” Engagement, vol. 8, no. 1, pp. 1–17, May 2024, doi: 10.1111/j.1741-5446.1974.tb00662.x.

M. Zhang and S. Berghäll, “E-commerce in agribusiness-food sector: A systematic literature review based on service-dominant logic,” Dec. 01, 2021, MDPI. doi: 10.3390/jtaer16070182.

Asia Productivity Organization, “Strategies for Ensuring Business Continuity of SMES in the APO Developing Economies,” Tokyo, Mar. 2024.

R. Rahayu and J. Day, “E-commerce adoption by SMEs in developing countries: evidence from Indonesia,” Eurasian Business Review, vol. 7, no. 1, pp. 25–41, Apr. 2017, doi: 10.1007/s40821-016-0044-6.

T. A. D. P. Subianto, J. Wiratama, and F. A. Halim, “The Development of web-based Cashier and Inventory Information Systems using Prototyping Model on Micro, Small, and Medium Enterprise (MSMEs) in Indonesia,” JOINS (Journal of Information System), vol. 8, no. 1, pp. 80–89, Jun. 2023, doi: 10.33633/joins.v8i1.7983.

S. Purnomo, N. Nurmalitasari, and N. Nurchim, “Digital transformation of MSMEs in Indonesia: A systematic literature review,” Journal of Management and Digital Business, vol. 4, no. 2, pp. 301–312, Aug. 2024, doi: 10.53088/jmdb.v4i2.1121.

O. F. Sitorus, R. A. Ningsih, A. Andini, N. A. Rahmawati, and M. Y. Alfarisi, “Mengatasi Tantangan Transformasi Digital UMKM: Tantangan Dan Solusi Melalui Kegiatan Pendampingan di Jakarta dan Bekasi,” Jurnal Pengabdian Masyarakat Indonesia, vol. 4, no. 6, pp. 939–948, Jan. 2025, doi: 10.52436/1.jpmi.2768.

M. Marolt, G. Lenart, M. Kljaji? Borštnar, and A. Pucihar, “Exploring Digital Transformation Journey Among Micro, Small-, and Medium-Sized Enterprises,” Systems, vol. 13, no. 1, Jan. 2025, doi: 10.3390/systems13010001.

N. Purwati, G. B. Sulistyo, S. Kiswati, and N. Hasan, “Implementation of website reservation system and online promotion for business development at Sejati Catering,” Community Empowerment, vol. 10, no. 3, pp. 749–756, Mar. 2025, doi: 10.31603/ce.12304.

L. Paska Sipahutar, M. Findi, S. N. Neyman, and I. Pertanian, “Website Design for Providing Product Price Information of Micro, Small, and Medium Enterprises (MSMEs) Retail Business,” Indonesian Journal of Multidisciplinary Science, vol. 4, no. 7, 2025, [Online]. Available: www.produkumkmsejahtera.com

Adams Gbolahan Adeleke, Temitope Oluwafunmike Sanyaolu, Christianah Pelumi Efunniyi, Lucy Anthony Akwawa, and Chidimma Francisca Azubuko, “Leveraging UX design and prototyping in agile development: A business analyst’s perspective,” Engineering Science & Technology Journal, vol. 5, no. 8, pp. 2670–2693, Aug. 2024, doi: 10.51594/estj.v5i8.1518.

V. Parthasarathy, “Integrating Predictive Analytics into End-to-End Supply Chain Management: A Holistic Framework for Data-Driven Decision Making,” International Journal of Emerging Trends in Computer Science and Information Technology, vol. 2, no. 1, pp. 47–54, 2021, doi: 10.63282/3050-9246.ijetcsit-v2i1p106.

J. P. Pertiwi and A. U. Hana, “Data-Driven Decision Making in MSMEs: Leveraging Free Analytics Tools for Financial Planning and Efficiency,” Journal of Management and Informatics, vol. 4, no. 1, pp. 633–648, Apr. 2025, doi: 10.51903/jmi.v4i1.146.

S. Takale, T. Bhong, U. Dethe, and P. Gandhi, “Sales Prediction using Linear Regression,” Journal of Electronics,Computer Networking and Applied Mathematics, no. 25, pp. 62–71, Sep. 2022, doi: 10.55529/jecnam.25.62.71.

A. Ebule, “Agile Vs. Waterfall: A Comprehensive Analysis Of Methodologies for Effective Project Management,” International Journal of Novel Research And Development, Vol. 10, No. 1, pp. 1–13, Jan. 2025, [Online]. Available: www.ijnrd.org

J. C. Pereira and R. de F. S. M. Russo, “Design thinking integrated in agile software development: A systematic literature review,” in Procedia Computer Science, Elsevier B.V., 2018, pp. 775–782. doi: 10.1016/j.procs.2018.10.101.

M. I. Hossain, “Software Development Life Cycle (SDLC) Methodologies for Information Systems Project Management.” [Online]. Available: www.ijfmr.com

N. A. Addinillah And D. Hamdani, “Penerapan Design Thinking Dalam Perancangan Prototype UI Dan UX Pada Aplikasi Peminjaman Ruangan PKM di Universitas Widyatama,” Rabit?: Jurnal Teknologi dan Sistem Informasi Univrab, vol. 10, no. 2, pp. 826–840, Jul. 2025, doi: 10.36341/rabit.v10i2.6380.

D. P. Pop and A. Altar, “Designing an MVC model for rapid web application development,” in Procedia Engineering, Elsevier Ltd, 2014, pp. 1172–1179. doi: 10.1016/j.proeng.2014.03.106.