Integration of Store Layout Redesign and MySQL-Based Digital Accounting System to Improve Operational Efficiency of Retail SMEs

Jaka Purnama; Afrigh Fajar  Rosyidiin; Zainal  Arief

doi:10.30996/heuristic.v22i2.132950

Authors

Jaka Purnama Faculty of Engineering, Universitas 17 Agustus 1945 Surabaya
Afrigh Fajar Rosyidiin Faculty of Engineering, Universitas 17 Agustus 1945 Surabaya
Zainal Arief Faculty of Engineering, Universitas 17 Agustus 1945 Surabaya

DOI:

https://doi.org/10.30996/heuristic.v22i2.132950

Keywords:

Accounting System Design; Digitalization; MySQL; Retail Layout Optimization; Small Business Efficiency

Abstract

This study aims to improve operational efficiency and financial management at Toko Pink 31 Surabaya by integrating two key components: store layout redesign and the development of a MySQL-based accounting system. The research uses a combination of qualitative and quantitative approaches through observations, interviews, system design, and simulations. The redesigned layout was developed using the Systematic Layout Planning (SLP) method and simulated via AnyLogic software to evaluate customer flow and service bottlenecks. The results showed significant improvements in space utilization, reduced customer congestion, and enhanced overall shopping experience. In parallel, the accounting system was developed using MySQL to automate and structure financial transactions. The system includes modules for product input, sales, purchasing, cost of goods manufactured (COGM) reporting, and daily financial summaries. The implementation of this digital accounting system reduced manual errors, streamlined transaction processing, and provided real-time access to financial data. The integration of both layout optimization and digital accounting demonstrates a comprehensive transformation model for SMEs, particularly in the retail sector. The findings emphasize that combining spatial efficiency and financial digitalization can significantly improve business performance, supporting broader efforts to digitalize micro and small enterprises in Indonesia.

Downloads

Download data is not yet available.

References

A. Agustin, G. Pramana Edy Putra, D. Tunggal Pramesti, and Madiistriyanto Harries, “STRATEGI UMKM DALAM MENGHADAPI DIGITALISASI,” Jurnal Oikos-Nomos, vol. 16, no. 1, p. 2023, Jun. 2023.

L. Nurahmah et al., “Jurnal Manajemen Retail Indonesia Perbaikan Layout UMKM Toko Kue XYZ Kota Bogor Menggunakan Metode ARC dan TCR,” Jurnal Manajemen Retail Indonesia, vol. 5, no. 2, Jul. 2024.

C. M. Maulidina and L. Nafiati, “Penerapan sistem informasi akuntansi, digital marketing dan e-commerce untuk meningkatkan literasi digitalisasi dan kinerja UMKM,” Jurnal Pembelajaran Pemberdayaan Masyarakat (JP2M), vol. 5, no. 1, pp. 187–199, Mar. 2024, doi: 10.33474/jp2m.v5i1.21506.

A. P. Dewiningrum, K. Restiannisa, and W. Sutopo, “PENERAPAN POSTPONEMENT STRATEGY DALAM SUPPLY CHAIN UNTUK MENGHASILKAN PRODUK YANG MENGUTAMAKAN KEPUASAN KONSUMEN DAN MENINGKATKAN PROFIT PERUSAHAAN,” Jurnal Rekayasa, vol. 5, no. 1, pp. 31–36, Apr. 2012, [Online]. Available: http://journal.trunojoyo.ac.id/rekayasa

Rayan Hamad Alkhaldi, “Digital transformation impact on business decision-making,” World Journal of Advanced Engineering Technology and Sciences, vol. 13, no. 1, pp. 001–011, Sep. 2024, doi: 10.30574/wjaets.2024.13.1.0365.

U. Östlund, L. Kidd, Y. Wengström, and N. Rowa-Dewar, “Combining qualitative and quantitative research within mixed method research designs: A methodological review,” Int J Nurs Stud, vol. 48, no. 3, pp. 369–383, Mar. 2011, doi: 10.1016/j.ijnurstu.2010.10.005.

R. Wahyudi, Romanus Renaldo Nerfando Garamba, and Andhyka Tyaz Nugraha, “Evaluasi Tata Letak Fasilitas Menggunakan Metode Systematic Layout Planning di PT Lambang Jaya,” JOURNAL OF INDUSTRIAL AND MANUFACTURE ENGINEERING, vol. 8, no. 1, pp. 66–77, May 2024, doi: 10.31289/jime.v8i1.10618.

A. Schneider et al., “Primary and secondary data in emergency medicine health services research – a comparative analysis in a regional research network on multimorbid patients,” BMC Med Res Methodol, vol. 23, no. 1, p. 34, Feb. 2023, doi: 10.1186/s12874-023-01855-2.

M. D. Fetters and E. B. Rubinstein, “The 3 Cs of Content, Context, and Concepts: A Practical Approach to Recording Unstructured Field Observations,” The Annals of Family Medicine, vol. 17, no. 6, pp. 554–560, Nov. 2019, doi: 10.1370/afm.2453.

Sunardi, J. Ananda Esya, and B. Santoso, “Redesign of The Production Facility Layout by Using Systematic Layout Planning Method at Cahaya Bintang Mas Company Surabaya,” J Phys Conf Ser, vol. 1569, p. 032007, Jul. 2020, doi: 10.1088/1742-6596/1569/3/032007.

A. M. Domlyn, “Implementation stages in practice: A review of behavioral health innovation within hospitals,” Health Serv Manage Res, vol. 35, no. 2, pp. 92–109, May 2022, doi: 10.1177/09514848211010271.

S. Saxena, V. Chawla, and J. Tähtinen, “Dimensions of e-return service quality: conceptual refinement and directions for measurement,” Journal of Service Theory and Practice, vol. 32, no. 5, pp. 640–672, Aug. 2022, doi: 10.1108/JSTP-09-2021-0191.

S. A. Mazhar, “Methods of Data Collection: A Fundamental Tool of Research,” Journal of Integrated Community Health, vol. 10, no. 01, pp. 6–10, Jun. 2021, doi: 10.24321/2319.9113.202101.

C. A. Győrödi, D. V. Dumşe-Burescu, R. Ş. Győrödi, D. R. Zmaranda, L. Bandici, and D. E. Popescu, “Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases,” Applied Sciences, vol. 11, no. 15, p. 6794, Jul. 2021, doi: 10.3390/app11156794.

S. Iriawan, W. S. Indrianti, and Hikmahwati, “Perhitungan Cost of Goods Manufactured pada Perusahaan Mikro: Pendekatan Full Costing (Studi Kasus),” Indonesian Journal of Applied Accounting and Finance, vol. 3, no. 2, pp. 167–181, Dec. 2023, doi: 10.31961/ijaaf.v3i2.14385.