Heuristic
Vol 22, No 2 (2025)

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

Purnama, Jaka (Unknown)
Rosyidiin, Afrigh Fajar (Unknown)
Arief, Zainal (Unknown)



Article Info

Publish Date
19 Jan 2026

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.

Copyrights © 2025






Journal Info

Abbrev

HEURISTIC

Publisher

Subject

Engineering Industrial & Manufacturing Engineering

Description

Jurnal HEURISTIC is published biannually, in April and October, by Industrial Engineering Department, University of 17 Agustus 1945 Surabaya. Jurnal HEURISTIC aims to: 1. Promote a comprehensive approach to industrial engineering incorporating viewpoints of different disciplines. 2. Strengthen ...