Design and Development of an Integrated Ordering and Sales Analysis System at Kaluna Living

Mohammad Kurdi Maulana Bintang; Andriyan Rizki jatmiko

doi:10.32664/smatika.v16i01.2179

Authors

Mohammad Kurdi Maulana Bintang Universitas Merdeka Malang
Andriyan Rizki jatmiko Universitas Merdeka Malang

DOI:

https://doi.org/10.32664/smatika.v16i01.2179

Keywords:

Ordering System, Micro-Enterprise, Custom Order Workflow, Sales Analytics Dashboard, Prototyping SDLC, System Usability Scale (SUS)

Abstract

This study presents the design and development of an integrated ordering and sales analysis system for Kaluna Living, a micro-enterprise specializing in handcrafted ceramic home goods. Prior to the system development, business operations relied on manual workflows for recording orders, processing custom product requests, and preparing monthly sales reports. These procedures resulted in slow transaction handling, higher risk of inconsistent data, and limited business visibility. The system was developed using the SDLC Prototyping model to enable iterative refinement through continuous user feedback. To evaluate usability, the System Usability Scale (SUS) was applied to representative user roles (customer, admin, and owner). The evaluation yielded an average SUS score of 81.66, which falls into the Excellent (Above Average) usability category, indicating that the system is perceived as easy to use, consistent, and learnable. The system supports centralized ordering workflows, custom request handling with image upload, and sales insight visualization that summarizes monthly revenue and order volume. The findings suggest that iterative prototyping contributes to usability improvements by refining navigation flow, clarifying form structures, and supporting streamlined operational workflows. This research contributes to applied system development for micro-enterprises by demonstrating how integrated digital ordering and analytics can improve operational efficiency and decision support in handcrafted product businesses.

References

[1] M. Dikri Abdillah, “Digital Transformation in Indonesian MSMEs: Adoption, Impact, and Future Directions,” Eastasouth Proceeding Of Economics and Business, p. 64, 2023.

[2] J. Lemhannas, R. I. Jlri, B. Utomo, and Y. Y. Setiyono, “Leveraging Digital Technology in Micro SMEs to Enhance Indonesia ’ s Economic Prosperity,” vol. 12, no. 3, pp. 391–402, 2024, doi: 10.55960/jlri.v12i3.985.

[3] T. TH. Tambunan and I. Busnetti, “Recent Evidence on the Digitalization Process in Indonesia’s Micro and Small Enterprises,” International Journal of Current Science Research and Review, vol. 07, no. 08, 2024, doi: 10.47191/ijcsrr/v7-i8-18.

[4] A. Kallmuenzer, A. Mikhaylov, M. Chelaru, and W. Czakon, “Adoption and performance outcome of digitalization in small and medium-sized enterprises,” Review of Managerial Science, vol. 19, no. 7, pp. 2011–2038, 2025, doi: 10.1007/s11846-024-00744-2.

[5] A. Vicens-Sans, X. Pascari, F. Molino, A. J. Ramos, and S. Marín, “Near infrared hyperspectral imaging as a sorting tool for deoxynivalenol reduction in wheat batches,” Food Research International, vol. 178, no. January, p. 113984, 2024, doi: 10.1016/j.foodres.2024.113984.

[6] M. Marolt, G. Lenart, and M. Kljaji, “Exploring Digital Transformation Journey Among Micro , Small- , and Medium-Sized Enterprises,” pp. 1–23, 2025.

[8] B. Pratama Putra, D. Cahya Assyura, D. Nugroho, and A. Prasetyo, “Penerapan Aplikasi Pemesanan Pada Usaha Mikro Kecil Menengah (Umkm) Dalam Memudahkan Transaksi,” Jurnal Khatulistiwa Informatika, vol. 12, no. 1, pp. 38–45, 2024, doi: 10.31294/jki.v12i1.16952.

[9] A. Salim, H. Hasan, and A. Halim, “Inovasi Pembukuan Digital Umkm Dengan Integrasi Appsheet Dan Google Spreadsheet,” JATI (Jurnal Mahasiswa Teknik Informatika), vol. 9, no. 2, pp. 2497–2505, 2025, doi: 10.36040/jati.v9i2.13115.

[10] T. Andreas, D. Pratama, 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,” vol. 8, no. 1, pp. 80–89, 2023, doi: 10.33633/joins.v8i1.7983.

[11] R. Meilariza, Z. Mirah Delima, and . Z., “Digitalization of Micro, Small, and Medium Enterprises (MSMEs) in Indonesia,” KnE Social Sciences, vol. 2024, pp. 245–257, 2024, doi: 10.18502/kss.v9i17.16334.

[12] F. A. Tridalestari and I. D. Setyawan, “Analisis Literatur Sistem Pemesanan Jasa dan Produk Percetakan di Indonesia: Studi Sistematis terhadap Tren dan Gap Penelitian”.

[13] T. Darmanto and T. Willay, “Multidisciplinary Sciences and Arts Implementation of Prototyping and System Usability Scale In The Point of Sales Information System at CV Kharisma Lestari International Journal of,” vol. 4, no. 4, pp. 309–322, 2025.

[14] L. Studiyanti, N. Azmi, D. Saraswati, U. Trisakti, and W. Jakarta, “Usability Evaluation and Design of Student Information System Prototype to Increase Student ’ s Satisfaction ( Case Study : X University ),” vol. 18, no. 4, pp. 676–684, 2019.

[15] D. A. Putri, “Application Usability Testing on E-Wallet by Using the System Usability Scale Method,” Smatika Jurnal, vol. 12, no. 01, pp. 114–122, 2022.

[16] A. Antika and E. Yulianingsih, “Analisa Sistem e-learning Pada Universitas PGRI Palembang Dengan Metode System Usability Scale (SUS),” Smatika Jurnal, vol. 13, no. 01, pp. 53–61, 2023, doi: 10.32664/smatika.v13i01.721.

[17] S. Gilardoni, “Comunicazione, mediazione e argomentazione in classe CLIL Termini e definizioni nel discorso didattico,” La linguistica educativa tra ricerca e sperimentazione Scritti in onore di Carmel Mary Coonan, pp. 105–122, 2023, doi: 10.30687/978-88-6969-683-1/010.

[18] E. Bjarnason, F. Lang, and A. Mjöberg, An empirically based model of software prototyping : a mapping study and a multi ‑ case study, no. 0123456789. Springer US, 2023. doi: 10.1007/s10664-023-10331-w.

[19] S. Y. R. Esearch, B. A. R. Hevner, S. T. March, J. Park, and S. Ram, “D ESIGN S CIENCE IN I NFORMATION,” vol. 28, no. 1, pp. 75–105, 2004.

[20] D. Lazuardi, S. Tinggi, I. Ekonomi, and E. Prasetya, “EXPLORING THE CHALLENGES AND OPPORTUNITIES OF E-COMMERCE ADOPTION IN RURAL-BASED MICRO , SMALL , AND MEDIUM ENTERPRISES ( MSMES ),” vol. 6, no. 1, pp. 1675–1684, 2025.

[21] A. Susanto, “System Development Method with The Prototype Method,” vol. 8, no. 07, pp. 141–144, 2019.

[22] D. Purnomo, “Model Prototyping,” JIMP-Jurnal Informatika Merdeka Pasuruan, vol. 2, no. 2, pp. 54–61, 2017.

[23] E. R. Subhiyakto and Y. P. Astuti, “UI / UX Design Prototype for Enhancing User Experience using User-Centered Method,” vol. 10, no. 4, pp. 537–548, 2023, doi: 10.15294/sji.v10i4.47528.